<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 08/16/2023
 * Time: 17:54
 * 7345
 */
require_once('../connect.php');
$db=db_connect();
// "select * from paycash where status=1";
 $aspoa=$db->query("select * from paycash where status=4");
// $aspoa=$db->query("select * from paycash where length(matNo)<4 and formNo<>''");
$count=7345;
while ($row=$aspoa->fetch(PDO::FETCH_BOTH)) {
     $matNo = $row['matNo'];
     $dept = $row['dept'];
     $levelID = $row['levelID'];
    if ($levelID==1 or$levelID==5 or $levelID==8 )  $kk = "select nd as sola from dept where dOption='$dept'";
    if ($levelID==3 or$levelID==11 or $levelID==11 )  $kk = "select hnd as sola from dept where dOption='$dept'";

$d=$db->query($kk);
    if ($d->rowCount()==1){
        $pre=$d->fetch(PDO::FETCH_BOTH);
        $prefix= $pre['sola'];
        if ($levelID==11  or $levelID==8 ) $prefix2='02';
        if ($levelID==3  or $levelID==1 ) $prefix2='01';
    }

$matNo=$prefix.'2022'.$prefix2.'0'.$count;
    $count++;
     $amt = $row['amount'];
     $formNo = $row['formNo'];
     $orderID = $row['receipt'];
     $rrr = 'PAYCASH';
    $paymentType="School Fees";
    $ip1="BURSARY";
    $ip2="MROLASEHINDE";

    echo '<br>';
// die();

    echo $nnu = "INSERT INTO `fedpoly`.`remitaorderbb` (`sn`, `orderID`, `remitaRRR`, `transDate`, `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`pay_session`) VALUES (NULL, '$orderID', '$rrr', NOW(), '-1', '$matNo', 'Approved', '$amt', '$paymentType', 'True','$ip1','$ip2','2022/2023')";
    echo $mm="UPDATE realdata SET matNo='$matNo',passworda='$matNo',usernamea='$matNo', fresher=80 WHERE formNo='$formNo'";
    $db->query($nnu);
    $db->query($mm);
//    die();
}
?>