<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:31 PM
 */
//session_start();
ob_start();
include('headMain_2.php');
if(!isset($_SESSION['sName'])){
header('location:login.php');
}

$sql_a=$db->query("SELECT count(*) as levelTotal,level FROM `stddata` where level in ('dptForm','ptForm','hndForm','preForm') and formNo not like '%delete%' group by level");
while($row=$sql_a->fetch(PDO::FETCH_BOTH)) {


    ?>
<div id="wrapper">
    <table width="100%" cellspacing="5" cellpadding="3">
    <tr>
        <td><form id="form1" name="form1" method="post" action="generateVenue_process.php" role="form" >
                <fieldset>
                    <legend>
                        <div class="row">
                            <div class="col-lg-3"></div>
                            <div class="col-lg-6">
                                <div class="panel panel-default">
                                    <div class="panel-heading">
                                        Schedule Generation (<?php echo $_SESSION['sName'];?>)
                                    </div>
                                    <div class="panel-body">

                                        <div class="alert-success">

                                                <?php
    $level=$row['level'] ;
     switch ($level){
         case 'dptForm':
             $lev='Daily Part Time';
             break;
         case 'hndForm':
             $lev='Higher National Diploma';
             break;
         case 'preForm':
             $lev='Pre National Diploma';
             break;
         case 'ptForm';
             $lev='Part Time Form';
             break;
    }
    echo 'Form Type:'.$lev ;
    echo '<br>';
    $total = $row['levelTotal'];
    echo 'Total Number:'.$total;

   echo' <div>
    <br><a href="generateVenue_process.php?level='.$level.'&no='.$total.'">Click to Generate</a>
</div>
';
 ?>



                                            </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </legend>



                </fieldset>
            </form></td>
    </tr>
    </table>
<?php
}
include('footMain.php');
?>
</div>