<?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, remark, d.status
FROM remitaorder b, realdata a
LEFT JOIN rawcgpa c ON a.matNo = c.matNo
LEFT JOIN admitted d ON a.formNo = d.formNo
WHERE (
a.matNo = b.regNo
OR a.formNo = b.regNo
)
AND transApproved = 'True' and MONTH(transDate) = 3 and Year(TransDate) = 2018 group by b.remitaRRR order by b.paymentType)");
    if ($Query1) {
        echo "SUCCESS";
    } else {
        echo "FAILED";
    }
}else{
    echo "Date was Not Selected";
}
?>