<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:31 PM
 */
//session_start();
ob_start();
if (isset($_GET['level'])){
    $level=$_GET['level'];
    $no=$_GET['no'];
require_once('../connect.php');
    $db=db_connect();
$sql_a=$db->query("SELECT * from FROM `stddata` where formNo not like '%delete%'");
    while($row=$sql_a->fetch(PDO::FETCH_BOTH)) {
        $formNo=$row['formNo'];
        $sql_check=$db->query("select * from venuetb where formNo='$formNo'");
        if ($sql_check->rowCount()==0){
            //generate venue
            $sql_cbt=$db->query("select * from cbtschedule where status=0");
            $sql_cbt_num=$sql_cbt->rowCount();
            if ($sql_cbt_num>0){

            }
        }



}
    ?>
<div id="wrapper">
    <table width="100%" cellspacing="5" cellpadding="3">
    <tr>
        <td><form id="form1" name="form1" method="post" action="changeLogin_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?venue='.$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>