<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 02/19/2018
 * Time: 9:18 AM
 */
if (isset($_REQUEST['ADMIN']) && $_REQUEST['ADMIN']=='BURSARY') {
    $mt = $_REQUEST['MONTHID'];
    $yr = $_REQUEST['YEARID'];

    require('../connect.php');
    $db = db_connect();
    $Query1 = $db->query("DROP TABLE IF EXISTS export2016_17; CREATE TABLE export2016_17 (SELECT a.matNo, d.formNo, a.names, a.course, a.levelID, orderID, remitaRRR, transDate, amtPaid, paymentType, transApproved, carryCourse as remark, d.status, e.noOfResult
FROM remitaorder b, realdata a
LEFT JOIN summertable c ON a.matNo = c.matNo
LEFT JOIN admitted d ON a.formNo = d.formNo
LEFT JOIN olevel e ON a.matNo = e.formNo
WHERE (
a.matNo = b.regNo
OR a.formNo = b.regNo
) AND paymentType like '%School Fees%'
AND transApproved = 'True' and MONTH(transDate) = '$mt' and Year(TransDate) = '$yr' group by b.remitaRRR order by b.paymentType)");
    if ($Query1) {
        echo "SUCCESS";
        header('location:../admin_main/download_pre.php?ID=1');
    } else {
        echo "FAILED";
        header('location:../admin_main/download_pre.php?ID=2');
    }
}else{
    echo "Date was Not Selected";
}
?>