<?php
session_start();
include_once('include/config.inc.php');
include_once('sendmessage.php');
include_once('include/function.php');

switch($_REQUEST['do']) {
    
case "ExpenseTransaction":
    $expense_for=mysqli_escape_string($con,$_REQUEST['expense_for']);
    $id=mysqli_escape_string($con,$_REQUEST['id']);
    switch($expense_for){
        case "PartyTransaction":
            mysqli_query($con,"update PartyTranctions set approve=1 where id='".$id."'");
            break;
        case "PartyPayamount":
            mysqli_query($con,"update party_payamount set approve=1 where id='".$id."'");
            break;
        case "EmployeeSalary":
            mysqli_query($con,"update employeesalarypayment set approve=1 where EmployeeSalaryPaymentID='".$id."'");
            break;
        case "Consultant":
            mysqli_query($con,"update installment_consultants_payments set approve=1 where id='".$id."'");
            break;
    }
    header("Location:PartyTransactionEntry.php");
    break;
case "ChequeTransaction":
    $id=$_REQUEST['id'];
    $sem_no=$_REQUEST['sem_no'];
    $q=mysqli_query($con,"update checktransaction set approve='1' where id='".$id."'");
    if($q){
        $depositQ=mysqli_query($con,"select cheque_for,amount,student_id from checktransaction where id='".$id."'");
        $depositR=mysqli_fetch_array($depositQ);
        switch($depositR['cheque_for']){
            case "booking":
                mysqli_query($con,"update student_enqury_form set booking_amount='".$depositR['amount']."' where id='".$depositR['student_id']."'");
                break;
            case "admission":
                mysqli_query($con,"update admission_enquiry_form set submitfee='".$depositR['amount']."' where id='".$depositR['student_id']."'");
                break;
            case "installment":
                mysqli_query($con,"update payinstallment set approve=1 where id='".$depositR['student_id']."'");
                break;
            case "onetimefee":
                mysqli_query($con,"update payonetimefee set approve=1 where id='".$depositR['student_id']."'");
                break;
            case "monthlyfee":
                mysqli_query($con,"update paymonthlyfee set approve=1 where id='".$depositR['student_id']."'");
                break;
        }
    }else{
        $_SESSION['msg']="Error in Cheque clearance.";
    }
    echo "<script>window.location='adminaccountreports.php';</script>";
    break;
case "payonetimefee":
    $user_id=mysqli_escape_string($con,$_REQUEST['UserID']);
    $setonetimefee_id=mysqli_escape_string($con,$_REQUEST['setonetimefee_id']);
    $student_id=mysqli_escape_string($con,$_REQUEST['student_id']);
    $payment_date=mysqli_escape_string($con,$_REQUEST['payment_date']);
    $payment_amount=mysqli_escape_string($con,$_REQUEST['payment_amount']);
    $payment_mode=mysqli_escape_string($con,$_REQUEST['payment_mode']);
    $bank_name=mysqli_escape_string($con,$_REQUEST['bank_name']);
    $bank=mysqli_escape_string($con,$_REQUEST['bank']);
    $check_no=mysqli_escape_string($con,$_REQUEST['check_no']);
    $draft_no=mysqli_escape_string($con,$_REQUEST['draft_no']);
    $pos_transaction=mysqli_escape_string($con,$_REQUEST['pos_transaction']);
    
    
    $payfeeQ=mysqli_query($con,"insert into payonetimefee (user_id,setonetimefee_id,student_id,payment_date,payment_amount,payment_mode,
    bank_name,bank,check_no,draft_no,pos_transaction,approve) values ('".$user_id."','".$setonetimefee_id."','".$student_id."','".$payment_date."',
    '".$payment_amount."','".$payment_mode."','".$bank_name."','".$bank."','".$check_no."','".$draft_no."','".$pos_transaction."',0)");
    
    $last_id=$con->insert_id;
    if($payfeeQ){
        if($payment_mode=="Cheque"){
            $chequequery=mysqli_query($con,"insert into checktransaction (user_id,sem_no,student_id,approve,cheque_for,amount,
            bank_id,bank_name,checkno) values ('".$user_id."',1,'".$last_id."','0','onetimefee','".$payment_amount."','".$bank_name."',
            '".$bank."','".$check_no."')");
        }
    }    
        
    $_SESSION['msg']="Payment made successfully!";
    echo "<script>window.location='onetimefeereports.php';</script>";
    
    break;
    
case "paymonthlyfee":
    $user_id=mysqli_escape_string($con,$_REQUEST['UserID']);
    $setmonthlyfee_id=mysqli_escape_string($con,$_REQUEST['setmonthlyfee_id']);
    $student_id=mysqli_escape_string($con,$_REQUEST['student_id']);
    $payment_date=mysqli_escape_string($con,$_REQUEST['payment_date']);
    $payment_amount=mysqli_escape_string($con,$_REQUEST['payment_amount']);
    $payment_mode=mysqli_escape_string($con,$_REQUEST['payment_mode']);
    $bank_name=mysqli_escape_string($con,$_REQUEST['bank_name']);
    $bank=mysqli_escape_string($con,$_REQUEST['bank']);
    $check_no=mysqli_escape_string($con,$_REQUEST['check_no']);
    $draft_no=mysqli_escape_string($con,$_REQUEST['draft_no']);
    $pos_transaction=mysqli_escape_string($con,$_REQUEST['pos_transaction']);
    
    
    $payfeeQ=mysqli_query($con,"insert into paymonthlyfee (user_id,setmonthlyfee_id,student_id,payment_date,payment_amount,payment_mode,
    bank_name,bank,check_no,draft_no,pos_transaction,approve) values ('".$user_id."','".$setmonthlyfee_id."','".$student_id."','".$payment_date."',
    '".$payment_amount."','".$payment_mode."','".$bank_name."','".$bank."','".$check_no."','".$draft_no."','".$pos_transaction."',0)");
    
    $last_id=$con->insert_id;
    if($payfeeQ){
        if($payment_mode=="Cheque"){
            $chequequery=mysqli_query($con,"insert into checktransaction (user_id,sem_no,student_id,approve,cheque_for,amount,
            bank_id,bank_name,checkno) values ('".$user_id."',1,'".$last_id."','0','monthlyfee','".$payment_amount."','".$bank_name."',
            '".$bank."','".$check_no."')");
        }else{
        }
    }
        
    $_SESSION['msg']="Payment made successfully!";
    echo "<script>window.location='monthlyfeereports.php';</script>";
    
    break;
case "setmonthlyfee":
    $enquiry_id=mysqli_escape_string($con,$_REQUEST['student_id']);
    $feecheckbox=$_REQUEST['feecheckbox'];
    foreach($feecheckbox as $fee){
        $deletefeeQ=mysqli_query($con,"delete from setmonthlyfee where miscfeemaster_id=".$fee." AND student_id='".$enquiry_id."'");
        $setmonthlyfeeQ=mysqli_query($con,"insert into setmonthlyfee (miscfeemaster_id,student_id,paid) values ('".$fee."','".$enquiry_id."',0)");
    }
    $_SESSION['msg']="Monthly Fee Added";
    echo "<script>window.location='monthlyfeereports.php';</script>";
    break;
case "setonetimefee":
    $miscfees=$_REQUEST['miscfees'];
    $students=$_REQUEST['students'];
    for($i=0;$i<count($miscfees);$i++){
        for($j=0;$j<count($students);$j++){
            $last_id=mysqli_fetch_array(mysqli_query($con,"select id from setonetimefee where miscfeemaster_id=".$miscfees[$i]." AND student_id='".$students[$j]."'"))['id'];
            
            $deletefeeQ=mysqli_query($con,"delete from payonetimefee where setonetimefee_id=".$last_id." AND student_id='".$students[$j]."'");
            $deletefeeQ=mysqli_query($con,"delete from setonetimefee where miscfeemaster_id=".$miscfees[$i]." AND student_id='".$students[$j]."'");
            
            $setonetimefeeQ=mysqli_query($con,"insert into setonetimefee (miscfeemaster_id,student_id,paid) values ('".$miscfees[$i]."','".$students[$j]."',0)");
        }
    }
    $_SESSION['msg']="One Time Fee Added";
    header("Location:onetimefeereports.php");
    break;
}