<?php
include "config/config.php";

if(isset($_POST['Fees_id']))
{
    $today = Date("Y-m-d H:i s");
    $Fees_id=$_POST['Fees_id'];
    mysqli_query($con,"CREATE TABLE paid_fees_delete AS SELECT * FROM paid_fees limit 0");
    mysqli_query($con,"INSERT INTO `paid_fees_delete`(`Fees_id`, `Stud_Id`, `Recipt_No`, `ReciptCounter`, `Recp_Book_Name`, `Recp_Book_No`, `Recp_Book_Counter`, `Head_Id`, `Subhead_Ids`, `Sub_Amounts`, `Paid_date`, `Mode`, `DateNumber`, `Fine_Amount`, `Online_Charge`, `Total_Amount`, `Grand_Total`, `flag`, `user`, `Message`) select `Fees_id`, `Stud_Id`, `Recipt_No`, `ReciptCounter`, `Recp_Book_Name`, `Recp_Book_No`, `Recp_Book_Counter`, `Head_Id`, `Subhead_Ids`, `Sub_Amounts`, `Paid_date`, `Mode`, `DateNumber`, `Fine_Amount`, `Online_Charge`, `Total_Amount`, `Grand_Total`, `flag`, `user`, '$today' from paid_fees WHERE `Fees_id` = '$Fees_id' ");
    $sel_amount=mysqli_query($con,"select Paid_date,Stud_Id,Head_Id,Subhead_Ids,Sub_Amounts from paid_fees WHERE `Fees_id` = '$Fees_id' ");
    $Stud_Id=0;
    $Head_Id=0;
    $Sub_Amounts="";
    $Subhead_Ids="";
    $Paid_date="";
    while($fees_row=mysqli_fetch_array($sel_amount))
    {
        $Sub_Amounts=$fees_row['Sub_Amounts'];
        $Subhead_Ids=$fees_row['Subhead_Ids'];
        $Stud_Id=$fees_row['Stud_Id'];
        $Head_Id=$fees_row['Head_Id'];
        $Paid_date=$fees_row['Paid_date'];
    }
    $Subhead_Ids_array=explode("/",$Subhead_Ids);
    $Sub_Amounts_array=explode("/",$Sub_Amounts);
    $i=0;
    foreach($Subhead_Ids_array as $sub_id)
    {
        if($i!=0)
        {
            $paid_amt=$Sub_Amounts_array[$i];
            $Subhead_Id=$sub_id;
            mysqli_query($con,"update stud_basic2 set Paid=Paid-$paid_amt,Balance=Balance+$paid_amt where Stud_Id=$Stud_Id AND Head_Id=$Head_Id AND Subhead_Id=$Subhead_Id");
            $sel_headname=mysqli_query($con,"select Name from sub_head where Sub_Id=$Subhead_Id");
            $HeadName="";
            while($headname_row=mysqli_fetch_array($sel_headname))
            {
                $HeadName=$headname_row['Name'];
            }
             mysqli_query($con,"update vochers set Cr_Amount=Cr_Amount-$paid_amt,Dr_Amount=Dr_Amount-$paid_amt where Cr_Ledger='$HeadName' AND Date='$Paid_date'");   
        }
      $i=$i+1;  
    }
    $delete_Fees=mysqli_query($con,"DELETE FROM `paid_fees` WHERE `Fees_id` = '$Fees_id' ");
    if($delete_Fees)
    {
        echo"100";
    }
}
?>