<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain_2.php');
?>
<div class="row">
    <div class="col-lg-1"></div>
    <div class="col-lg-8">
        <div class="panel panel-default">
            <div class="panel-heading">
                Uploading Semester Result
            </div>
            <div class="panel-body">

                <div class="row">
                    <div class="col-lg-12">

                        <table width="100%" cellspacing="5" cellpadding="3">
                            <tr>
                                <td><table width="100%" align="center" cellpadding="3" cellspacing="5">
                                        <tr>
                                            <td><fieldset>
                                                    <form action="uploadResult_process.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
                                                        <table width="100%" cellspacing="5" cellpadding="3">
                                                            <tr>
                                                                <td><strong>Select Table</strong></td><td>&nbsp;</td><td>
                                                                    <select name="tableName" id="tableName"  class="form-control">
                                                                        <?php
                                                                         require('../result_connect.php');
                                                                        $rdb=rdb_connect();

                                                                        $query="SELECT table_name FROM information_schema.tables WHERE table_schema = 'fpe_result' and TABLE_NAME like '20%'";
                                                                        $rs=$rdb->query($query);
                                                                        while ($row=$rs->fetch(PDO::FETCH_BOTH)){
                                                                            $ff=explode('_',$row[0]);
                                                                             $ffa=$ff[0]+1;
                                                                           $ff_session=$ff[0].'/'.$ffa.'-'.$ff[1];
                                                                            echo '<option value="'.$row[0].'">'.$ff_session.'</option>';
                                                                        }
                                                                        ?>
                                                                    </select>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td><strong>Select Data File(*.csv) </strong></td>
                                                                <td>&nbsp;</td>
                                                                <td><label for="bank">
                                                                        <input type="file" name="file" id="file" required="required" />
                                                                    </label></td>
                                                            </tr>
                                                            </tr>
                                                            <tr><td style="color: red" colspan="3"><hr><div class="alert-info"><h3>Note: The CSV file should follows this order:</h3></div>
                                                                    <br>column 1=> School<br>column 2=>Department <br>column 3 =>Full Names<br>column 4=>Matric No<br> column 5=>Level<br>column 6=>Course Code<br> column 7=>Subject Names <br> column 8=>Subject Units<br> column 9=>Scores<br> column 10=> Code<br>column 11=>Points<br> column 12 =>Prev. CGPA<br> column 13=>Pres. GPA<br> column 14=>CGPA<br>column 15=>Remark<br>column 16=>Supress</td></tr>
                                                            <tr>
                                                            <tr>
                                                                <td>&nbsp;</td>
                                                                <td>&nbsp;</td>
                                                                <td><input type="submit" name="submit" id="submit" value="Upload" class="btn btn-primary form-control"  /></td>
                                                            </tr>
                                                        </table>
                                                    </form>
                                                </fieldset></td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php
include('footMain.php');
?>