<?php 
    include'include/session.php';
    
    if(isset($_GET['id']) && isset($_GET['no'])){
        $id = mysql_escape_string($_GET['id']);
        $qry = "SELECT name,years FROM course WHERE courseID =".$id;
        $results = mysql_query($qry);
        $count=  mysql_num_rows($results);
        
        $No = mysql_escape_string($_GET['no']);
        $no = unserialize(base64_decode($No));
        
        $query3 = "SELECT * FROM miscellaneous WHERE miscellaneousID IN(".implode(',',$no).") ORDER BY name ASC";
        $result3 = mysql_query($query3);
        $counts=  mysql_num_rows($result3);
    }
?>
<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Add Misscellanious | Accounts | WAKA CMEC</title>
    <link rel="shortcut icon" href="../../../assets/img/logo.png" />
    <link rel="stylesheet" href="../../../assets/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,400,700">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto+Slab:300,400|Roboto:300,400,700">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto+Slab:300,400">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Romanesco">
    <link rel="stylesheet" href="../../../assets/fonts/font-awesome.min.css">
    <link rel="stylesheet" href="../../../assets/fonts/material-icons.css">
    <link rel="stylesheet" href="../../../assets/css/ebs-simple-login-form1.css">
    <link rel="stylesheet" href="../../../assets/css/ebs-simple-login-form2.css">
    <link rel="stylesheet" href="../../../assets/css/Data-Table.css">
    <link rel="stylesheet" href="../../../assets/css/Data-Table1.css">
    <link rel="stylesheet" href="../../../assets/css/ebs-simple-login-form.css">
    <link rel="stylesheet" href="../../../assets/css/FPE-Gentella-form-elements.css">
    <link rel="stylesheet" href="../../../assets/css/FPE-Gentella-form-elements1.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.10.15/css/dataTables.bootstrap.min.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_no-more-tables.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_no-more-tables1.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_panel-table.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_panel-table1.css">
    <link rel="stylesheet" href="../../../assets/css/nav.css">
    <link rel="stylesheet" href="../../../assets/css/Navbar---App-Toolbar--LG--MD---Mobile-Nav--SM--XS.css">
    <link rel="stylesheet" href="../../../assets/css/JLX-Fixed-Nav-on-Scroll.css">
    <link rel="stylesheet" href="../../../assets/css/Navbar---App-Toolbar--LG--MD---Mobile-Nav--SM--XS1.css">
    <link rel="stylesheet" href="../../../assets/css/Navbar-Fixed-Side1.css">
    <link rel="stylesheet" href="../../../assets/css/Pretty-Table.css">
    <link rel="stylesheet" href="../../../assets/css/Pretty-Table1.css">
    <link rel="stylesheet" href="../../../assets/css/Profile-Edit.css">
    <link rel="stylesheet" href="../../../assets/css/Profile-Edit1.css">
    <link rel="stylesheet" href="../../../assets/css/Responsive-Form.css">
    <link rel="stylesheet" href="../../../assets/css/Responsive-Form1.css">
    <link rel="stylesheet" href="../../../assets/css/Sidebar-Menu.css">
    <link rel="stylesheet" href="../../../assets/css/Sidebar-Menu1.css">
    <link rel="stylesheet" href="../../../assets/css/styles.css">
    <link rel="stylesheet" href="../../../assets/css/tabela-mloureiro1973.css">
    <link rel="stylesheet" href="../../../assets/css/Team-Clean.css">
</head>

<body style="background-color:rgba(42,63,84,0);">
    <nav class="navbar navbar-default" style="background-color:rgb(21,164,113);">
        <div class="container-fluid">
            <div class="navbar-header">
                <a class="navbar-brand navbar-link" href="#" style="font-weight:bold;background-color:rgb(21,164,113);">
                    Accounts | Waka CMEC Training Institute
                </a>
                <button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navcol-2" style="background-color:rgb(21,164,113);color:rgb(255,255,255);"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button>
            </div>
            <div class="collapse navbar-collapse" id="navcol-2">
                <ul class="nav navbar-nav hidden-xs hidden-sm navbar-right" id="desktop-toolbar">
                    <li class="dropdown">
                        <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false" href="#"> <i class="fa fa-user"></i> &nbsp; <?php echo $pro;?>  <i class="fa fa-chevron-down fa-fw"></i></a>
                        <ul class="dropdown-menu" role="menu" style="background-color:rgb(249,249,249);">
                            <li role="presentation"><a href="settings.php"><i class="fa fa-user fa-fw"></i> Profile </a></li>
                            <li role="presentation"><a href="../validate/logout.php"><i class="fa fa-power-off fa-fw"></i>Logout </a></li>
                        </ul>
                    </li>
                </ul>
                <ul class="nav navbar-nav visible-xs-block visible-sm-block" id="mobile-nav">
                    
                    <li class="dropdown">
                        <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false" href="#"> <i class="fa fa-user"></i> &nbsp; <?php echo $pro;?> </i> <i class="fa fa-chevron-down fa-fw"></i></a>
                        <ul class="dropdown-menu" role="menu" style="background-color:rgb(249,249,249);">
                            <li role="presentation"><a href="settings.php"><i class="fa fa-user fa-fw"></i> Profile </a></li>
                            <li role="presentation"><a href="../validate/logout.php"><i class="fa fa-power-off fa-fw"></i>Logout </a></li>
                        </ul>
                    </li>
                    <li role="presentation"><a>&nbsp;</a></li>
                    <li role="presentation"><a>&nbsp;</a></li>
                    
                </ul>
            </div>
        </div>
    </nav>
    <div class="top">
        <nav class="navbar navbar-default" id="navbar-main">
            <div class="container-fluid">
                <div class="navbar-header">
                    <a class="navbar-brand hidden navbar-link" href="#" style="padding:0px;"> </a>
                    <button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navcol-1"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button>
                </div>
                <div class="collapse navbar-collapse" id="navcol-1">
                    <ul class="nav navbar-nav">
                        <li role="presentation">
                            <a href="index.php">
                                <i class="fa fa-table" style="margin-right:5px;"></i>
                                Dashboard
                            </a>
                        </li>
                        <li class="dropdown">
                            <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
                                <i class="fa fa-users" style="margin-right:5px;"></i>
                                    Students 
                                <span class="caret"></span>
                            </a>
                            <ul class="dropdown-menu" role="menu" style="background-color:rgb(249,249,249);">
                                <li role="presentation"><a href="view-admitted.php">Admitted </a></li>
                                <li role="presentation"><a href="view-completed.php">Alumni </a></li>
                            </ul>
                        </li>
                        <li role="presentation">
                            <a href="class.php">Class</a>
                        </li>
                        
                        <li role="presentation">
                            <a href="view-fee.php">
                                <i class="fa fa-book" style="margin-right:5px;"></i>
                                Fee 
                            </a>
                        </li>
                        <li role="presentation">
                            <a href="leave.php">
                                <i class="fa fa-shield" style="margin-right:5px;"></i>
                                Leave
                            </a>
                        </li>
                        <li class="dropdown">
                            <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false" href="#">
                                Others
                                <span class="caret"></span>
                            </a>
                            <ul class="dropdown-menu" role="menu">
                                <li role="presentation"><a href="miscellaneous-fee.php">Miscellaneous Fee</a></li>
                                <li role="presentation"><a href="miscellaneous.php">Miscellaneous</a></li>
                            </ul>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
    </div>   
    <?php
        if(!isset($_GET['id'])){
            echo'<div class="alert alert-danger absolue center text-center" role="alert">
                    <span class="text-danger">Error occured while trying to display info</span>
                </div>';
        }else
        if(!isset($_GET['no'])){
            echo'<div class="alert alert-danger absolue center text-center" role="alert">
                    <span class="text-danger">Error occured while trying to display items info</span>
                </div>';
        }else    
        if(empty($results)){
            echo'<div class="alert alert-danger absolue center text-center" role="alert">
                    <span class="text-danger">Failed to identify course</span>
                </div>';
        }else
        {
    ?>
    <div class="row" style="width:100%;margin-right:auto;margin-left:auto;-webkit-box-shadow:0px 4px 4px 0px rgba(0,0,0,1);-moz-box-shadow:0px 4px 4px 0px rgba(0,0,0,1);box-shadow:0px 4px 4px 0px rgba(0,0,0,1);margin-bottom:5%;overflow:hidden;max-width:600px;">
        
        <form method="POST">
            <div style="padding-top:2px;padding-bottom:2px;background-color:rgb(239,239,239);">
                <h2 style="margin-left:1%;margin-bottom:1%;font-size:16px;color:rgb(1,1,1);font-weight:bold;"> &nbsp;Add Misscellanious Fee</h2>
            </div>
            <div class="row" style="padding:10px;">
                <div class="col-md-12">
                    
                    <?php 
                        include 'validate/course-misscellanious.php';
                        
                        while ($row = mysql_fetch_array($results)) {
                    ?>
                        <div class="row">
                            <div class="col-md-12 col-sm-12">
                                <div class="col-md-7 col-sm-12">
                                    <div class="form-group">
                                        <label class="control-label">Course:</label>
                                        <p>
                                            <?php echo $row['name'];?>
                                            <input class="form-control" type="hidden" name="course" value="<?php echo $row['name'];?>">
                                        </p>
                                    </div>
                                </div>
                                <div class="col-md-5 col-sm-12">
                                    <div class="form-group">
                                        <label class="control-label">Year of Study: </label>
                                        <select class="form-control" name="year" required="" style="cursor:pointer;">
                                            <option value="" style="cursor:pointer;">--Select Year of Study</option>
                                            <?php 
                                                $yr = $row['years'];
                                                for($i=1;$i<=$yr;$i++ ){
                                            ?>
                                                <option value="<?php echo $i;?>" <?php if($year==$i){echo 'selected="selected"';}?> style="cursor:pointer;"><?php echo "Year ".$i;?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-12 col-sm-12"><hr></div>
                        </div>
                    <?php 
                        }
                        if($counts < 1){
                            echo'<div class="alert alert-danger absolue center text-center" role="alert">
                                    <span class="text-danger">Failed to identify Misscellanious</span>
                                </div>';
                        }else{
                            
                    ?>
                        <div class="row">
                            <div class="col-md-12 col-sm-12">
                                <table class="table table-striped">
                                    <tr style="background-color:rgb(21,164,113);color:white;">
                                        <td style="width:5%;font-weight:bold;text-align:center;">#</td>
                                        <td style="width:70%;font-weight:bold;">Item</td>
                                        <td style="width:30%;font-weight:bold;">Amount</td>
                                    </tr>
                                    <?php
                                        $n = 1;
                                        while ($name1 = mysql_fetch_array($result3)) {
                                    ?>
                                        <tr style="color:black;">
                                            <td style="width:5%;padding:4px;text-align:center;">
                                                <div class="form-group">
                                                    <label class="control-label" style="font-weight:normal;margin-top:6px;margin-bottom:0px;"> <?php echo $n++.".";?> </label>
                                                </div>
                                            </td>
                                            <td style="width:70%;padding:4px;">
                                                <div class="form-group">
                                                    <label class="control-label" style="font-weight:normal;margin-top:6px;margin-bottom:0px;"> <?php echo $name1['name'];?> </label>
                                                    <input class="form-control" type="hidden" name="miss[]" value="<?php echo $name1['miscellaneousID'];?>">
                                                    <input class="form-control" type="hidden" name="misscellanious[]" value="<?php echo $name1['name'];?>">
                                                    <input class="form-control" type="hidden" name="staf_no[]" value="<?php echo $name1['staffNo'];?>">
                                                </div>
                                            </td>
                                            <td style="width:30%;padding:4px;">
                                                <div class="form-group" style="margin:0px;">
                                                    <input class="form-control" required type="number" name="fee[]" min="0" step="any" placeholder="Amount">
                                                </div>
                                            </td>
                                        </tr>
                                    <?php } ?>
                                </table>
                            </div>
                        </div>
                        <hr>
                        <div class="row">
                            <div class="col-lg-5 col-lg-offset-0 col-md-12 content-center text-center">
                                <button name="add" type="submit" style="padding:5px 20px;color:rgb(1,1,1);">Submit</button>
                            </div>
                        </div>
                    <?php } ?>
                </div>
            </div>
            
        </form>
    </div>
     <?php } ?>
    <script src="../../../assets/js/jquery.min.js"></script>
    <script src="../../../assets/bootstrap/js/bootstrap.min.js"></script>
    <script src="../../../assets/js/ebs-simple-login-form.js"></script>
    <script src="../../../assets/js/Profile-Edit.js"></script>
    <script src="../../../assets/js/Sidebar-Menu.js"></script>
</body>

</html>