<?php
   include('include/header.php'); 
$otDebitAmtDurgi = 0;
  $debitOTAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'DURGI' and type = 'Debit'");
    while($debitOTAmtDataDurgi = mysqli_fetch_array($debitOTAmtDurgi))
    { 
      $otDebitAmtDurgi += $debitOTAmtDataDurgi['amount'];
    } 

    $otCreditAmtDurgi = 0;
  $creditOTAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'DURGI' and type = 'Credit'");
    while($creditOTAmtDataDurgi = mysqli_fetch_array($creditOTAmtDurgi))
    { 
      $otCreditAmtDurgi += $creditOTAmtDataDurgi['amount'];
    } 

    $otDebitAmtSPNAGAR = 0;
  $debitOTAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'SP NAGAR' and type = 'Debit'");
    while($debitOTAmtDataSPNAGAR = mysqli_fetch_array($debitOTAmtSPNAGAR))
    { 
      $otDebitAmtSPNAGAR += $debitOTAmtDataSPNAGAR['amount'];
    } 

    $otCreditAmtSPNAGAR = 0;
  $creditOTAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'SP NAGAR' and type = 'Credit'");
    while($creditOTAmtDataSPNAGAR = mysqli_fetch_array($creditOTAmtSPNAGAR))
    { 
      $otCreditAmtSPNAGAR += $creditOTAmtDataSPNAGAR['amount'];
    } 

    $otDebitAmtDegree = 0;
  $debitOTAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'DEGREE' and type = 'Debit'");
    while($debitOTAmtDataDegree = mysqli_fetch_array($debitOTAmtDegree))
    { 
      $otDebitAmtDegree += $debitOTAmtDataDegree['amount'];
    } 

    $otCreditAmtDegree = 0;
  $creditOTAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'DEGREE' and type = 'Credit'");
    while($creditOTAmtDataDegree = mysqli_fetch_array($creditOTAmtDegree))
    { 
      $otCreditAmtDegree += $creditOTAmtDataDegree['amount'];
    } 

    $otDebitAmtInter = 0;
  $debitOTAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'INTERMEDIATE' and type = 'Debit'");
    while($debitOTAmtDataInter = mysqli_fetch_array($debitOTAmtInter))
    { 
      $otDebitAmtInter += $debitOTAmtDataInter['amount'];
    } 

    $otCreditAmtInter = 0;
  $creditOTAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'INTERMEDIATE' and type = 'Credit'");
    while($creditOTAmtDataInter = mysqli_fetch_array($creditOTAmtInter))
    { 
      $otCreditAmtInter += $creditOTAmtDataInter['amount'];
    } 

$otDebitAmtAB = 0;
  $debitOTAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'ANDHRA_UNION BANK' and type = 'Debit'");
    while($debitOTAmtDataAB = mysqli_fetch_array($debitOTAmtAB))
    { 
      $otDebitAmtAB += $debitOTAmtDataAB['amount'];
    } 

    $otCreditAmtAB = 0;
  $creditOTAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'ANDHRA_UNION BANK' and type = 'Credit'");
    while($creditOTAmtDataAB = mysqli_fetch_array($creditOTAmtAB))
    { 
      $otCreditAmtAB += $creditOTAmtDataAB['amount'];
    } 

    $otDebitAmtBills = 0;
  $debitOTAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'BILLS' and type = 'Debit'");
    while($debitOTAmtDataBills = mysqli_fetch_array($debitOTAmtBills))
    { 
      $otDebitAmtBills += $debitOTAmtDataBills['amount'];
    } 

    $otCreditAmtBills = 0;
  $creditOTAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'BILLS' and type = 'Credit'");
    while($creditOTAmtDataBills = mysqli_fetch_array($creditOTAmtBills))
    { 
      $otCreditAmtBills += $creditOTAmtDataBills['amount'];
    } 

    $otDebitAmtBooks = 0;
  $debitOTAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'BOOKS' and type = 'Debit'");
    while($debitOTAmtDataBooks = mysqli_fetch_array($debitOTAmtBooks))
    { 
      $otDebitAmtBooks += $debitOTAmtDataBooks['amount'];
    } 

    $otCreditAmtBooks = 0;
  $creditOTAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'BOOKS' and type = 'Credit'");
    while($creditOTAmtDataBooks = mysqli_fetch_array($creditOTAmtBooks))
    { 
      $otCreditAmtBooks += $creditOTAmtDataBooks['amount'];
    }

     $otDebitAmtBusFin = 0;
  $debitOTAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'BUS FINANCE' and type = 'Debit'");
    while($debitOTAmtDataBusFin = mysqli_fetch_array($debitOTAmtBusFin))
    { 
      $otDebitAmtBusFin += $debitOTAmtDataBusFin['amount'];
    } 

    $otCreditAmtBusFin = 0;
  $creditOTAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'BUS FINANCE' and type = 'Credit'");
    while($creditOTAmtDataBusFin = mysqli_fetch_array($creditOTAmtBusFin))
    { 
      $otCreditAmtBusFin += $creditOTAmtDataBusFin['amount'];

    }

    $otDebitAmtBusMain = 0;
  $debitOTAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'BUS MAINTENANCE' and type = 'Debit'");
    while($debitOTAmtDataBusMain = mysqli_fetch_array($debitOTAmtBusMain))
    { 
      $otDebitAmtBusMain += $debitOTAmtDataBusMain['amount'];
    } 

    $otCreditAmtBusMain = 0;
  $creditOTAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'BUS MAINTENANCE' and type = 'Credit'");
    while($creditOTAmtDataBusMain = mysqli_fetch_array($creditOTAmtBusMain))
    { 
      $otCreditAmtBusMain += $creditOTAmtDataBusMain['amount'];
    }

$otDebitAmtBusOil = 0;
  $debitOTAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'BUS OIL' and type = 'Debit'");
    while($debitOTAmtDataBusOil = mysqli_fetch_array($debitOTAmtBusOil))
    { 
      $otDebitAmtBusOil += $debitOTAmtDataBusOil['amount'];
    } 

    $otCreditAmtBusOil = 0;
  $creditOTAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'BUS OIL' and type = 'Credit'");
    while($creditOTAmtDataBusOil = mysqli_fetch_array($creditOTAmtBusOil))
    { 
      $otCreditAmtBusOil += $creditOTAmtDataBusOil['amount'];
    }
    $otDebitAmtBVR = 0;
  $debitOTAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'BVREDDY' and type = 'Debit'");
    while($debitOTAmtDataBVR = mysqli_fetch_array($debitOTAmtBVR))
    { 
      $otDebitAmtBVR += $debitOTAmtDataBVR['amount'];
    } 

    $otCreditAmtBVR = 0;
  $creditOTAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'BVREDDY' and type = 'Credit'");
    while($creditOTAmtDataBVR = mysqli_fetch_array($creditOTAmtBVR))
    { 
      $otCreditAmtBVR += $creditOTAmtDataBVR['amount'];
    }
    $otDebitAmtARR = 0;
  $debitOTAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'DR ARR' and type = 'Debit'");
    while($debitOTAmtDataARR = mysqli_fetch_array($debitOTAmtARR))
    { 
      $otDebitAmtARR += $debitOTAmtDataARR['amount'];
    } 

    $otCreditAmtARR = 0;
  $creditOTAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'DR ARR' and type = 'Credit'");
    while($creditOTAmtDataARR = mysqli_fetch_array($creditOTAmtARR))
    { 
      $otCreditAmtARR += $creditOTAmtDataARR['amount'];
    }
    $otDebitAmtEduFee = 0;
  $debitOTAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'EDUCATIONAL FEE' and type = 'Debit'");
    while($debitOTAmtDataEduFee = mysqli_fetch_array($debitOTAmtEduFee))
    { 
      $otDebitAmtEduFee += $debitOTAmtDataEduFee['amount'];
    } 

    $otCreditAmtEduFee = 0;
  $creditOTAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'EDUCATIONAL FEE' and type = 'Credit'");
    while($creditOTAmtDataEduFee = mysqli_fetch_array($creditOTAmtEduFee))
    { 
      $otCreditAmtEduFee += $creditOTAmtDataEduFee['amount'];
    }
    $otDebitAmtFamExp = 0;
  $debitOTAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'FAMILY EXP' and type = 'Debit'");
    while($debitOTAmtDataFamExp = mysqli_fetch_array($debitOTAmtFamExp))
    { 
      $otDebitAmtFamExp += $debitOTAmtDataFamExp['amount'];
    } 

    $otCreditAmtFamExp = 0;
  $creditOTAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'FAMILY EXP' and type = 'Credit'");
    while($creditOTAmtDataFamExp = mysqli_fetch_array($creditOTAmtFamExp))
    { 
      $otCreditAmtFamExp += $creditOTAmtDataFamExp['amount'];
    }
    $otDebitAmtGenMain = 0;
  $debitOTAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'GENERAL MAINTENANCE' and type = 'Debit'");
    while($debitOTAmtDataGenMain = mysqli_fetch_array($debitOTAmtGenMain))
    { 
      $otDebitAmtGenMain += $debitOTAmtDataGenMain['amount'];
    } 

    $otCreditAmtGenMain = 0;
  $creditOTAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'GENERAL MAINTENANCE' and type = 'Credit'");
    while($creditOTAmtDataGenMain = mysqli_fetch_array($creditOTAmtGenMain))
    { 
      $otCreditAmtGenMain += $creditOTAmtDataGenMain['amount'];
    }
    $otDebitAmtHdfc = 0;
  $debitOTAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'HDFC BANK' and type = 'Debit'");
    while($debitOTAmtDataHdfc = mysqli_fetch_array($debitOTAmtHdfc))
    { 
      $otDebitAmtHdfc += $debitOTAmtDataHdfc['amount'];
    } 

    $otCreditAmtHdfc = 0;
  $creditOTAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'HDFC BANK' and type = 'Credit'");
    while($creditOTAmtDataHdfc = mysqli_fetch_array($creditOTAmtHdfc))
    { 
      $otCreditAmtHdfc += $creditOTAmtDataHdfc['amount'];
    }
    $otDebitAmtIcici = 0;
  $debitOTAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'ICICI BANK' and type = 'Debit'");
    while($debitOTAmtDataIcici = mysqli_fetch_array($debitOTAmtIcici))
    { 
      $otDebitAmtIcici += $debitOTAmtDataIcici['amount'];
    } 

    $otCreditAmtIcici = 0;
  $creditOTAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'ICICI BANK' and type = 'Credit'");
    while($creditOTAmtDataIcici = mysqli_fetch_array($creditOTAmtIcici))
    { 
      $otCreditAmtIcici += $creditOTAmtDataIcici['amount'];
    }
    $otDebitAmtOL = 0;
  $debitOTAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'OTHER LOANS' and type = 'Debit'");
    while($debitOTAmtDataOL = mysqli_fetch_array($debitOTAmtOL))
    { 
      $otDebitAmtOL += $debitOTAmtDataOL['amount'];
    } 

    $otCreditAmtOL = 0;
  $creditOTAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'OTHER LOANS' and type = 'Credit'");
    while($creditOTAmtDataOL = mysqli_fetch_array($creditOTAmtOL))
    { 
      $otCreditAmtOL += $creditOTAmtDataOL['amount'];
    }
$otDebitAmtPCH = 0;
  $debitOTAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'PRAGATHI CROPS HYD' and type = 'Debit'");
    while($debitOTAmtDataPCH = mysqli_fetch_array($debitOTAmtPCH))
    { 
      $otDebitAmtPCH += $debitOTAmtDataPCH['amount'];
    } 

    $otCreditAmtPCH = 0;
  $creditOTAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'PRAGATHI CROPS HYD' and type = 'Credit'");
    while($creditOTAmtDataPCH = mysqli_fetch_array($creditOTAmtPCH))
    { 
      $otCreditAmtPCH += $creditOTAmtDataPCH['amount'];
    }
$otDebitAmtRM = 0;
  $debitOTAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'REMODELING' and type = 'Debit'");
    while($debitOTAmtDataRM = mysqli_fetch_array($debitOTAmtRM))
    { 
      $otDebitAmtRM += $debitOTAmtDataRM['amount'];
    } 

    $otCreditAmtRM = 0;
  $creditOTAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'REMODELING' and type = 'Credit'");
    while($creditOTAmtDataRM = mysqli_fetch_array($creditOTAmtRM))
    { 
      $otCreditAmtRM += $creditOTAmtDataRM['amount'];
    }
    $otDebitAmtRents = 0;
  $debitOTAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'RENTS' and type = 'Debit'");
    while($debitOTAmtDataRents = mysqli_fetch_array($debitOTAmtRents))
    { 
      $otDebitAmtRents += $debitOTAmtDataRents['amount'];
    } 

    $otCreditAmtRents = 0;
  $creditOTAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'RENTS' and type = 'Credit'");
    while($creditOTAmtDataRents = mysqli_fetch_array($creditOTAmtRents))
    { 
      $otCreditAmtRents += $creditOTAmtDataRents['amount'];
    }
    $otDebitAmtSal = 0;
  $debitOTAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'SALARIES' and type = 'Debit'");
    while($debitOTAmtDataSal = mysqli_fetch_array($debitOTAmtSal))
    { 
      $otDebitAmtSal += $debitOTAmtDataSal['amount'];
    } 

    $otCreditAmtSal = 0;
  $creditOTAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'SALARIES' and type = 'Credit'");
    while($creditOTAmtDataSal = mysqli_fetch_array($creditOTAmtSal))
    { 
      $otCreditAmtSal += $creditOTAmtDataSal['amount'];
    }
    $otDebitAmtSchol = 0;
  $debitOTAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'SCHOLARSHIP' and type = 'Debit'");
    while($debitOTAmtDataSchol = mysqli_fetch_array($debitOTAmtSchol))
    { 
      $otDebitAmtSchol += $debitOTAmtDataSchol['amount'];
    } 

    $otCreditAmtSchol = 0;
  $creditOTAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'SCHOLARSHIP' and type = 'Credit'");
    while($creditOTAmtDataSchol = mysqli_fetch_array($creditOTAmtSchol))
    { 
      $otCreditAmtSchol += $creditOTAmtDataSchol['amount'];
    }
    $otDebitAmtUD = 0;
  $debitOTAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'UNIFORM_DRESS' and type = 'Debit'");
    while($debitOTAmtDataUD = mysqli_fetch_array($debitOTAmtUD))
    { 
      $otDebitAmtUD += $debitOTAmtDataUD['amount'];
    } 

    $otCreditAmtUD = 0;
  $creditOTAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'UNIFORM_DRESS' and type = 'Credit'");
    while($creditOTAmtDataUD = mysqli_fetch_array($creditOTAmtUD))
    { 
      $otCreditAmtUD += $creditOTAmtDataUD['amount'];
    }
    $otDebitAmtVLF = 0;
  $debitOTAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'VARTANA LAND FINANCE' and type = 'Debit'");
    while($debitOTAmtDataVLF = mysqli_fetch_array($debitOTAmtVLF))
    { 
      $otDebitAmtVLF += $debitOTAmtDataVLF['amount'];
    } 

    $otCreditAmtVLF = 0;
  $creditOTAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'VARTANA LAND FINANCE' and type = 'Credit'");
    while($creditOTAmtDataVLF = mysqli_fetch_array($creditOTAmtVLF))
    { 
      $otCreditAmtVLF += $creditOTAmtDataVLF['amount'];
    } 

 $otDebitAmtUNREC = 0;
  $debitOTAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and  category_name = 'UNRECORDED' and type = 'Debit'");
    while($debitOTAmtDataUNREC = mysqli_fetch_array($debitOTAmtUNREC))
    { 
      $otDebitAmtUNREC += $debitOTAmtDataUNREC['amount'];
    } 

    $otCreditAmtUNREC = 0;
  $creditOTAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and category_name = 'UNRECORDED' and type = 'Credit'");
    while($creditOTAmtDataUNREC = mysqli_fetch_array($creditOTAmtUNREC))
    { 
      $otCreditAmtUNREC += $creditOTAmtDataUNREC['amount'];
    }
    //OLD Town End

    //SP NAGAR BEGIN

$spnDebitAmtDurgi = 0;
  $debitSPNAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'DURGI' and type = 'Debit'");
    while($debitSPNAmtDataDurgi = mysqli_fetch_array($debitSPNAmtDurgi))
    { 
      $spnDebitAmtDurgi += $debitSPNAmtDataDurgi['amount'];
    } 

    $spnCreditAmtDurgi = 0;
  $creditSPNAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'DURGI' and type = 'Credit'");
    while($creditSPNAmtDataDurgi = mysqli_fetch_array($creditSPNAmtDurgi))
    { 
      $spnCreditAmtDurgi += $creditSPNAmtDataDurgi['amount'];
    } 

    $spnDebitAmtOLDTOWN = 0;
  $debitSPNAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'OLD TOWN' and type = 'Debit'");
    while($debitSPNAmtDataOLDTOWN = mysqli_fetch_array($debitSPNAmtOLDTOWN))
    { 
      $spnDebitAmtOLDTOWN += $debitSPNAmtDataOLDTOWN['amount'];
    } 

    $spnCreditAmtOLDTOWN = 0;
  $creditSPNAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'OLD TOWN' and type = 'Credit'");
    while($creditSPNAmtDataOLDTOWN = mysqli_fetch_array($creditSPNAmtOLDTOWN))
    { 
      $spnCreditAmtOLDTOWN += $creditSPNAmtDataOLDTOWN['amount'];
    } 

    $spnDebitAmtDegree = 0;
  $debitSPNAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'DEGREE' and type = 'Debit'");
    while($debitSPNAmtDataDegree = mysqli_fetch_array($debitSPNAmtDegree))
    { 
      $spnDebitAmtDegree += $debitSPNAmtDataDegree['amount'];
    } 

    $spnCreditAmtDegree = 0;
  $creditSPNAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'DEGREE' and type = 'Credit'");
    while($creditSPNAmtDataDegree = mysqli_fetch_array($creditSPNAmtDegree))
    { 
      $spnCreditAmtDegree += $creditSPNAmtDataDegree['amount'];
    } 

    $spnDebitAmtInter = 0;
  $debitSPNAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'INTERMEDIATE' and type = 'Debit'");
    while($debitSPNAmtDataInter = mysqli_fetch_array($debitSPNAmtInter))
    { 
      $spnDebitAmtInter += $debitSPNAmtDataInter['amount'];
    } 

    $spnCreditAmtInter = 0;
  $creditSPNAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'INTERMEDIATE' and type = 'Credit'");
    while($creditSPNAmtDataInter = mysqli_fetch_array($creditSPNAmtInter))
    { 
      $spnCreditAmtInter += $creditSPNAmtDataInter['amount'];
    } 

$spnDebitAmtAB = 0;
  $debitSPNAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'ANDHRA_UNION BANK' and type = 'Debit'");
    while($debitSPNAmtDataAB = mysqli_fetch_array($debitSPNAmtAB))
    { 
      $spnDebitAmtAB += $debitSPNAmtDataAB['amount'];
    } 

    $spnCreditAmtAB = 0;
  $creditSPNAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'ANDHRA_UNION BANK' and type = 'Credit'");
    while($creditSPNAmtDataAB = mysqli_fetch_array($creditSPNAmtAB))
    { 
      $spnCreditAmtAB += $creditSPNAmtDataAB['amount'];
    } 

    $spnDebitAmtBills = 0;
  $debitSPNAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'BILLS' and type = 'Debit'");
    while($debitSPNAmtDataBills = mysqli_fetch_array($debitSPNAmtBills))
    { 
      $spnDebitAmtBills += $debitSPNAmtDataBills['amount'];
    } 

    $spnCreditAmtBills = 0;
  $creditSPNAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'BILLS' and type = 'Credit'");
    while($creditSPNAmtDataBills = mysqli_fetch_array($creditSPNAmtBills))
    { 
      $spnCreditAmtBills += $creditSPNAmtDataBills['amount'];
    } 

    $spnDebitAmtBooks = 0;
  $debitSPNAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'BOOKS' and type = 'Debit'");
    while($debitSPNAmtDataBooks = mysqli_fetch_array($debitSPNAmtBooks))
    { 
      $spnDebitAmtBooks += $debitSPNAmtDataBooks['amount'];
    } 

    $spnCreditAmtBooks = 0;
  $creditSPNAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'BOOKS' and type = 'Credit'");
    while($creditSPNAmtDataBooks = mysqli_fetch_array($creditSPNAmtBooks))
    { 
      $spnCreditAmtBooks += $creditSPNAmtDataBooks['amount'];
    }

     $spnDebitAmtBusFin = 0;
  $debitSPNAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'BUS FINANCE' and type = 'Debit'");
    while($debitSPNAmtDataBusFin = mysqli_fetch_array($debitSPNAmtBusFin))
    { 
      $spnDebitAmtBusFin += $debitSPNAmtDataBusFin['amount'];
    } 

    $spnCreditAmtBusFin = 0;
  $creditSPNAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'BUS FINANCE' and type = 'Credit'");
    while($creditSPNAmtDataBusFin = mysqli_fetch_array($creditSPNAmtBusFin))
    { 
      $spnCreditAmtBusFin += $creditSPNAmtDataBusFin['amount'];

    }

    $spnDebitAmtBusMain = 0;
  $debitSPNAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'BUS MAINTENANCE' and type = 'Debit'");
    while($debitSPNAmtDataBusMain = mysqli_fetch_array($debitSPNAmtBusMain))
    { 
      $spnDebitAmtBusMain += $debitSPNAmtDataBusMain['amount'];
    } 

    $spnCreditAmtBusMain = 0;
  $creditSPNAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'BUS MAINTENANCE' and type = 'Credit'");
    while($creditSPNAmtDataBusMain = mysqli_fetch_array($creditSPNAmtBusMain))
    { 
      $spnCreditAmtBusMain += $creditSPNAmtDataBusMain['amount'];
    }

$spnDebitAmtBusOil = 0;
  $debitSPNAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'BUS OIL' and type = 'Debit'");
    while($debitSPNAmtDataBusOil = mysqli_fetch_array($debitSPNAmtBusOil))
    { 
      $spnDebitAmtBusOil += $debitSPNAmtDataBusOil['amount'];
    } 

    $spnCreditAmtBusOil = 0;
  $creditSPNAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'BUS OIL' and type = 'Credit'");
    while($creditSPNAmtDataBusOil = mysqli_fetch_array($creditSPNAmtBusOil))
    { 
      $spnCreditAmtBusOil += $creditSPNAmtDataBusOil['amount'];
    }
    $spnDebitAmtBVR = 0;
  $debitSPNAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'BVREDDY' and type = 'Debit'");
    while($debitSPNAmtDataBVR = mysqli_fetch_array($debitSPNAmtBVR))
    { 
      $spnDebitAmtBVR += $debitSPNAmtDataBVR['amount'];
    } 

    $spnCreditAmtBVR = 0;
  $creditSPNAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'BVREDDY' and type = 'Credit'");
    while($creditSPNAmtDataBVR = mysqli_fetch_array($creditSPNAmtBVR))
    { 
      $spnCreditAmtBVR += $creditSPNAmtDataBVR['amount'];
    }
    $spnDebitAmtARR = 0;
  $debitSPNAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'DR ARR' and type = 'Debit'");
    while($debitSPNAmtDataARR = mysqli_fetch_array($debitSPNAmtARR))
    { 
      $spnDebitAmtARR += $debitSPNAmtDataARR['amount'];
    } 

    $spnCreditAmtARR = 0;
  $creditSPNAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'DR ARR' and type = 'Credit'");
    while($creditSPNAmtDataARR = mysqli_fetch_array($creditSPNAmtARR))
    { 
      $spnCreditAmtARR += $creditSPNAmtDataARR['amount'];
    }
    $spnDebitAmtEduFee = 0;
  $debitSPNAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'EDUCATIONAL FEE' and type = 'Debit'");
    while($debitSPNAmtDataEduFee = mysqli_fetch_array($debitSPNAmtEduFee))
    { 
      $spnDebitAmtEduFee += $debitSPNAmtDataEduFee['amount'];
    } 

    $spnCreditAmtEduFee = 0;
  $creditSPNAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'EDUCATIONAL FEE' and type = 'Credit'");
    while($creditSPNAmtDataEduFee = mysqli_fetch_array($creditSPNAmtEduFee))
    { 
      $spnCreditAmtEduFee += $creditSPNAmtDataEduFee['amount'];
    }
    $spnDebitAmtFamExp = 0;
  $debitSPNAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'FAMILY EXP' and type = 'Debit'");
    while($debitSPNAmtDataFamExp = mysqli_fetch_array($debitSPNAmtFamExp))
    { 
      $spnDebitAmtFamExp += $debitSPNAmtDataFamExp['amount'];
    } 

    $spnCreditAmtFamExp = 0;
  $creditSPNAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'FAMILY EXP' and type = 'Credit'");
    while($creditSPNAmtDataFamExp = mysqli_fetch_array($creditSPNAmtFamExp))
    { 
      $spnCreditAmtFamExp += $creditSPNAmtDataFamExp['amount'];
    }
    $spnDebitAmtGenMain = 0;
  $debitSPNAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'GENERAL MAINTENANCE' and type = 'Debit'");
    while($debitSPNAmtDataGenMain = mysqli_fetch_array($debitSPNAmtGenMain))
    { 
      $spnDebitAmtGenMain += $debitSPNAmtDataGenMain['amount'];
    } 

    $spnCreditAmtGenMain = 0;
  $creditSPNAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'GENERAL MAINTENANCE' and type = 'Credit'");
    while($creditSPNAmtDataGenMain = mysqli_fetch_array($creditSPNAmtGenMain))
    { 
      $spnCreditAmtGenMain += $creditSPNAmtDataGenMain['amount'];
    }
    $spnDebitAmtHdfc = 0;
  $debitSPNAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'HDFC BANK' and type = 'Debit'");
    while($debitSPNAmtDataHdfc = mysqli_fetch_array($debitSPNAmtHdfc))
    { 
      $spnDebitAmtHdfc += $debitSPNAmtDataHdfc['amount'];
    } 

    $spnCreditAmtHdfc = 0;
  $creditSPNAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'HDFC BANK' and type = 'Credit'");
    while($creditSPNAmtDataHdfc = mysqli_fetch_array($creditSPNAmtHdfc))
    { 
      $spnCreditAmtHdfc += $creditSPNAmtDataHdfc['amount'];
    }
    $spnDebitAmtIcici = 0;
  $debitSPNAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'ICICI BANK' and type = 'Debit'");
    while($debitSPNAmtDataIcici = mysqli_fetch_array($debitSPNAmtIcici))
    { 
      $spnDebitAmtIcici += $debitSPNAmtDataIcici['amount'];
    } 

    $spnCreditAmtIcici = 0;
  $creditSPNAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'ICICI BANK' and type = 'Credit'");
    while($creditSPNAmtDataIcici = mysqli_fetch_array($creditSPNAmtIcici))
    { 
      $spnCreditAmtIcici += $creditSPNAmtDataIcici['amount'];
    }
    $spnDebitAmtOL = 0;
  $debitSPNAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'OTHER LOANS' and type = 'Debit'");
    while($debitSPNAmtDataOL = mysqli_fetch_array($debitSPNAmtOL))
    { 
      $spnDebitAmtOL += $debitSPNAmtDataOL['amount'];
    } 

    $spnCreditAmtOL = 0;
  $creditSPNAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'OTHER LOANS' and type = 'Credit'");
    while($creditSPNAmtDataOL = mysqli_fetch_array($creditSPNAmtOL))
    { 
      $spnCreditAmtOL += $creditSPNAmtDataOL['amount'];
    }
$spnDebitAmtPCH = 0;
  $debitSPNAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'PRAGATHI CROPS HYD' and type = 'Debit'");
    while($debitSPNAmtDataPCH = mysqli_fetch_array($debitSPNAmtPCH))
    { 
      $spnDebitAmtPCH += $debitSPNAmtDataPCH['amount'];
    } 

    $spnCreditAmtPCH = 0;
  $creditSPNAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'PRAGATHI CROPS HYD' and type = 'Credit'");
    while($creditSPNAmtDataPCH = mysqli_fetch_array($creditSPNAmtPCH))
    { 
      $spnCreditAmtPCH += $creditSPNAmtDataPCH['amount'];
    }
$spnDebitAmtRM = 0;
  $debitSPNAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'REMODELING' and type = 'Debit'");
    while($debitSPNAmtDataRM = mysqli_fetch_array($debitSPNAmtRM))
    { 
      $spnDebitAmtRM += $debitSPNAmtDataRM['amount'];
    } 

    $spnCreditAmtRM = 0;
  $creditSPNAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'REMODELING' and type = 'Credit'");
    while($creditSPNAmtDataRM = mysqli_fetch_array($creditSPNAmtRM))
    { 
      $spnCreditAmtRM += $creditSPNAmtDataRM['amount'];
    }
    $spnDebitAmtRents = 0;
  $debitSPNAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'RENTS' and type = 'Debit'");
    while($debitSPNAmtDataRents = mysqli_fetch_array($debitSPNAmtRents))
    { 
      $spnDebitAmtRents += $debitSPNAmtDataRents['amount'];
    } 

    $spnCreditAmtRents = 0;
  $creditSPNAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'RENTS' and type = 'Credit'");
    while($creditSPNAmtDataRents = mysqli_fetch_array($creditSPNAmtRents))
    { 
      $spnCreditAmtRents += $creditSPNAmtDataRents['amount'];
    }
    $spnDebitAmtSal = 0;
  $debitSPNAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'SALARIES' and type = 'Debit'");
    while($debitSPNAmtDataSal = mysqli_fetch_array($debitSPNAmtSal))
    { 
      $spnDebitAmtSal += $debitSPNAmtDataSal['amount'];
    } 

    $spnCreditAmtSal = 0;
  $creditSPNAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'SALARIES' and type = 'Credit'");
    while($creditSPNAmtDataSal = mysqli_fetch_array($creditSPNAmtSal))
    { 
      $spnCreditAmtSal += $creditSPNAmtDataSal['amount'];
    }
    $spnDebitAmtSchol = 0;
  $debitSPNAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'SCHOLARSHIP' and type = 'Debit'");
    while($debitSPNAmtDataSchol = mysqli_fetch_array($debitSPNAmtSchol))
    { 
      $spnDebitAmtSchol += $debitSPNAmtDataSchol['amount'];
    } 

    $spnCreditAmtSchol = 0;
  $creditSPNAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'SCHOLARSHIP' and type = 'Credit'");
    while($creditSPNAmtDataSchol = mysqli_fetch_array($creditSPNAmtSchol))
    { 
      $spnCreditAmtSchol += $creditSPNAmtDataSchol['amount'];
    }
    $spnDebitAmtUD = 0;
  $debitSPNAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'UNIFORM_DRESS' and type = 'Debit'");
    while($debitSPNAmtDataUD = mysqli_fetch_array($debitSPNAmtUD))
    { 
      $spnDebitAmtUD += $debitSPNAmtDataUD['amount'];
    } 

    $spnCreditAmtUD = 0;
  $creditSPNAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'UNIFORM_DRESS' and type = 'Credit'");
    while($creditSPNAmtDataUD = mysqli_fetch_array($creditSPNAmtUD))
    { 
      $spnCreditAmtUD += $creditSPNAmtDataUD['amount'];
    }
    $spnDebitAmtVLF = 0;
  $debitSPNAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'VARTANA LAND FINANCE' and type = 'Debit'");
    while($debitSPNAmtDataVLF = mysqli_fetch_array($debitSPNAmtVLF))
    { 
      $spnDebitAmtVLF += $debitSPNAmtDataVLF['amount'];
    } 

    $spnCreditAmtVLF = 0;
  $creditSPNAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'VARTANA LAND FINANCE' and type = 'Credit'");
    while($creditSPNAmtDataVLF = mysqli_fetch_array($creditSPNAmtVLF))
    { 
      $spnCreditAmtVLF += $creditSPNAmtDataVLF['amount'];
    }

     $spnDebitAmtUNREC = 0;
  $debitSPNAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'UNRECORDED' and type = 'Debit'");
    while($debitSPNAmtDataUNREC = mysqli_fetch_array($debitSPNAmtUNREC))
    { 
      $spnDebitAmtUNREC += $debitSPNAmtDataUNREC['amount'];
    } 

    $spnCreditAmtUNREC = 0;
  $creditSPNAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'UNRECORDED' and type = 'Credit'");
    while($creditSPNAmtDataUNREC = mysqli_fetch_array($creditSPNAmtUNREC))
    { 
      $spnCreditAmtUNREC += $creditSPNAmtDataUNREC['amount'];
    } 

    //SP Nagar End

    //Durgi Begin


$durgiDebitAmtSPNAGAR = 0;
  $debitDurgiAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'SP NAGAR' and type = 'Debit'");
    while($debitDurgiAmtDataSPNAGAR = mysqli_fetch_array($debitDurgiAmtSPNAGAR))
    { 
      $durgiDebitAmtSPNAGAR += $debitDurgiAmtDataSPNAGAR['amount'];
    } 

    $durgiCreditAmtSPNAGAR = 0;
  $creditDurgiAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'SP NAGAR' and type = 'Credit'");
    while($creditDurgiAmtDataSPNAGAR = mysqli_fetch_array($creditDurgiAmtSPNAGAR))
    { 
      $durgiCreditAmtSPNAGAR += $creditDurgiAmtDataSPNAGAR['amount'];
    } 

    $durgiDebitAmtOLDTOWN = 0;
  $debitDurgiAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'OLD TOWN' and type = 'Debit'");
    while($debitDurgiAmtDataSPNAGAR = mysqli_fetch_array($debitDurgiAmtOLDTOWN))
    { 
      $durgiDebitAmtOLDTOWN += $debitDurgiAmtDataOLDTOWN['amount'];
    } 

    $durgiCreditAmtOLDTOWN = 0;
  $creditDurgiAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'OLD TOWN' and type = 'Credit'");
    while($creditDurgiAmtDataOLDTOWN = mysqli_fetch_array($creditDurgiAmtOLDTOWN))
    { 
      $durgiCreditAmtOLDTOWN += $creditDurgiAmtDataOLDTOWN['amount'];
    } 

    $durgiDebitAmtDegree = 0;
  $debitDurgiAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'DEGREE' and type = 'Debit'");
    while($debitDurgiAmtDataDegree = mysqli_fetch_array($debitDurgiAmtDegree))
    { 
      $durgiDebitAmtDegree += $debitDurgiAmtDataDegree['amount'];
    } 

    $durgiCreditAmtDegree = 0;
  $creditDurgiAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'DEGREE' and type = 'Credit'");
    while($creditDurgiAmtDataDegree = mysqli_fetch_array($creditDurgiAmtDegree))
    { 
      $durgiCreditAmtDegree += $creditDurgiAmtDataDegree['amount'];
    } 

    $durgiDebitAmtInter = 0;
  $debitDurgiAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'INTERMEDIATE' and type = 'Debit'");
    while($debitDurgiAmtDataInter = mysqli_fetch_array($debitDurgiAmtInter))
    { 
      $durgiDebitAmtInter += $debitDurgiAmtDataInter['amount'];
    } 

    $durgiCreditAmtInter = 0;
  $creditDurgiAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'INTERMEDIATE' and type = 'Credit'");
    while($creditDurgiAmtDataInter = mysqli_fetch_array($creditDurgiAmtInter))
    { 
      $durgiCreditAmtInter += $creditDurgiAmtDataInter['amount'];
    } 

$durgiDebitAmtAB = 0;
  $debitDurgiAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'ANDHRA_UNION BANK' and type = 'Debit'");
    while($debitDurgiAmtDataAB = mysqli_fetch_array($debitDurgiAmtAB))
    { 
      $durgiDebitAmtAB += $debitDurgiAmtDataAB['amount'];
    } 

    $durgiCreditAmtAB = 0;
  $creditDurgiAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'ANDHRA_UNION BANK' and type = 'Credit'");
    while($creditDurgiAmtDataAB = mysqli_fetch_array($creditDurgiAmtAB))
    { 
      $durgiCreditAmtAB += $creditDurgiAmtDataAB['amount'];
    } 

    $durgiDebitAmtBills = 0;
  $debitDurgiAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'BILLS' and type = 'Debit'");
    while($debitDurgiAmtDataBills = mysqli_fetch_array($debitDurgiAmtBills))
    { 
      $durgiDebitAmtBills += $debitDurgiAmtDataBills['amount'];
    } 

    $durgiCreditAmtBills = 0;
  $creditDurgiAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'BILLS' and type = 'Credit'");
    while($creditDurgiAmtDataBills = mysqli_fetch_array($creditDurgiAmtBills))
    { 
      $durgiCreditAmtBills += $creditDurgiAmtDataBills['amount'];
    } 

    $durgiDebitAmtBooks = 0;
  $debitDurgiAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'BOOKS' and type = 'Debit'");
    while($debitDurgiAmtDataBooks = mysqli_fetch_array($debitDurgiAmtBooks))
    { 
      $durgiDebitAmtBooks += $debitDurgiAmtDataBooks['amount'];
    } 

    $durgiCreditAmtBooks = 0;
  $creditDurgiAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'BOOKS' and type = 'Credit'");
    while($creditDurgiAmtDataBooks = mysqli_fetch_array($creditDurgiAmtBooks))
    { 
      $durgiCreditAmtBooks += $creditDurgiAmtDataBooks['amount'];
    }

     $durgiDebitAmtBusFin = 0;
  $debitDurgiAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'BUS FINANCE' and type = 'Debit'");
    while($debitDurgiAmtDataBusFin = mysqli_fetch_array($debitDurgiAmtBusFin))
    { 
      $durgiDebitAmtBusFin += $debitDurgiAmtDataBusFin['amount'];
    } 

    $durgiCreditAmtBusFin = 0;
  $creditDurgiAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'BUS FINANCE' and type = 'Credit'");
    while($creditDurgiAmtDataBusFin = mysqli_fetch_array($creditDurgiAmtBusFin))
    { 
      $durgiCreditAmtBusFin += $creditDurgiAmtDataBusFin['amount'];

    }

    $durgiDebitAmtBusMain = 0;
  $debitDurgiAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'BUS MAINTENANCE' and type = 'Debit'");
    while($debitDurgiAmtDataBusMain = mysqli_fetch_array($debitDurgiAmtBusMain))
    { 
      $durgiDebitAmtBusMain += $debitDurgiAmtDataBusMain['amount'];
    } 

    $durgiCreditAmtBusMain = 0;
  $creditDurgiAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'BUS MAINTENANCE' and type = 'Credit'");
    while($creditDurgiAmtDataBusMain = mysqli_fetch_array($creditDurgiAmtBusMain))
    { 
      $durgiCreditAmtBusMain += $creditDurgiAmtDataBusMain['amount'];
    }

$durgiDebitAmtBusOil = 0;
  $debitDurgiAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'BUS OIL' and type = 'Debit'");
    while($debitDurgiAmtDataBusOil = mysqli_fetch_array($debitDurgiAmtBusOil))
    { 
      $durgiDebitAmtBusOil += $debitDurgiAmtDataBusOil['amount'];
    } 

    $durgiCreditAmtBusOil = 0;
  $creditDurgiAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'BUS OIL' and type = 'Credit'");
    while($creditDurgiAmtDataBusOil = mysqli_fetch_array($creditDurgiAmtBusOil))
    { 
      $durgiCreditAmtBusOil += $creditDurgiAmtDataBusOil['amount'];
    }
    $durgiDebitAmtBVR = 0;
  $debitDurgiAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'BVREDDY' and type = 'Debit'");
    while($debitDurgiAmtDataBVR = mysqli_fetch_array($debitDurgiAmtBVR))
    { 
      $durgiDebitAmtBVR += $debitDurgiAmtDataBVR['amount'];
    } 

    $durgiCreditAmtBVR = 0;
  $creditDurgiAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'BVREDDY' and type = 'Credit'");
    while($creditDurgiAmtDataBVR = mysqli_fetch_array($creditDurgiAmtBVR))
    { 
      $durgiCreditAmtBVR += $creditDurgiAmtDataBVR['amount'];
    }
    $durgiDebitAmtARR = 0;
  $debitDurgiAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'DR ARR' and type = 'Debit'");
    while($debitDurgiAmtDataARR = mysqli_fetch_array($debitDurgiAmtARR))
    { 
      $durgiDebitAmtARR += $debitDurgiAmtDataARR['amount'];
    } 

    $durgiCreditAmtARR = 0;
  $creditDurgiAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'DR ARR' and type = 'Credit'");
    while($creditDurgiAmtDataARR = mysqli_fetch_array($creditDurgiAmtARR))
    { 
      $durgiCreditAmtARR += $creditDurgiAmtDataARR['amount'];
    }
    $durgiDebitAmtEduFee = 0;
  $debitDurgiAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'EDUCATIONAL FEE' and type = 'Debit'");
    while($debitDurgiAmtDataEduFee = mysqli_fetch_array($debitDurgiAmtEduFee))
    { 
      $durgiDebitAmtEduFee += $debitDurgiAmtDataEduFee['amount'];
    } 

    $durgiCreditAmtEduFee = 0;
  $creditDurgiAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'EDUCATIONAL FEE' and type = 'Credit'");
    while($creditDurgiAmtDataEduFee = mysqli_fetch_array($creditDurgiAmtEduFee))
    { 
      $durgiCreditAmtEduFee += $creditDurgiAmtDataEduFee['amount'];
    }
    $durgiDebitAmtFamExp = 0;
  $debitDurgiAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'FAMILY EXP' and type = 'Debit'");
    while($debitDurgiAmtDataFamExp = mysqli_fetch_array($debitDurgiAmtFamExp))
    { 
      $durgiDebitAmtFamExp += $debitDurgiAmtDataFamExp['amount'];
    } 

    $durgiCreditAmtFamExp = 0;
  $creditDurgiAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'FAMILY EXP' and type = 'Credit'");
    while($creditDurgiAmtDataFamExp = mysqli_fetch_array($creditDurgiAmtFamExp))
    { 
      $durgiCreditAmtFamExp += $creditDurgiAmtDataFamExp['amount'];
    }
    $durgiDebitAmtGenMain = 0;
  $debitDurgiAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'GENERAL MAINTENANCE' and type = 'Debit'");
    while($debitDurgiAmtDataGenMain = mysqli_fetch_array($debitDurgiAmtGenMain))
    { 
      $durgiDebitAmtGenMain += $debitDurgiAmtDataGenMain['amount'];
    } 

    $durgiCreditAmtGenMain = 0;
  $creditDurgiAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'GENERAL MAINTENANCE' and type = 'Credit'");
    while($creditDurgiAmtDataGenMain = mysqli_fetch_array($creditDurgiAmtGenMain))
    { 
      $durgiCreditAmtGenMain += $creditDurgiAmtDataGenMain['amount'];
    }
    $durgiDebitAmtHdfc = 0;
  $debitDurgiAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'HDFC BANK' and type = 'Debit'");
    while($debitDurgiAmtDataHdfc = mysqli_fetch_array($debitDurgiAmtHdfc))
    { 
      $durgiDebitAmtHdfc += $debitDurgiAmtDataHdfc['amount'];
    } 

    $durgiCreditAmtHdfc = 0;
  $creditDurgiAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'HDFC BANK' and type = 'Credit'");
    while($creditDurgiAmtDataHdfc = mysqli_fetch_array($creditDurgiAmtHdfc))
    { 
      $durgiCreditAmtHdfc += $creditDurgiAmtDataHdfc['amount'];
    }
    $durgiDebitAmtIcici = 0;
  $debitDurgiAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'ICICI BANK' and type = 'Debit'");
    while($debitDurgiAmtDataIcici = mysqli_fetch_array($debitDurgiAmtIcici))
    { 
      $durgiDebitAmtIcici += $debitDurgiAmtDataIcici['amount'];
    } 

    $durgiCreditAmtIcici = 0;
  $creditDurgiAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'ICICI BANK' and type = 'Credit'");
    while($creditDurgiAmtDataIcici = mysqli_fetch_array($creditDurgiAmtIcici))
    { 
      $durgiCreditAmtIcici += $creditDurgiAmtDataIcici['amount'];
    }
    $durgiDebitAmtOL = 0;
  $debitDurgiAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'OTHER LOANS' and type = 'Debit'");
    while($debitDurgiAmtDataOL = mysqli_fetch_array($debitDurgiAmtOL))
    { 
      $durgiDebitAmtOL += $debitDurgiAmtDataOL['amount'];
    } 

    $durgiCreditAmtOL = 0;
  $creditDurgiAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'OTHER LOANS' and type = 'Credit'");
    while($creditDurgiAmtDataOL = mysqli_fetch_array($creditDurgiAmtOL))
    { 
      $durgiCreditAmtOL += $creditDurgiAmtDataOL['amount'];
    }
$durgiDebitAmtPCH = 0;
  $debitDurgiAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'PRAGATHI CROPS HYD' and type = 'Debit'");
    while($debitDurgiAmtDataPCH = mysqli_fetch_array($debitDurgiAmtPCH))
    { 
      $durgiDebitAmtPCH += $debitDurgiAmtDataPCH['amount'];
    } 

    $durgiCreditAmtPCH = 0;
  $creditDurgiAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'PRAGATHI CROPS HYD' and type = 'Credit'");
    while($creditDurgiAmtDataPCH = mysqli_fetch_array($creditDurgiAmtPCH))
    { 
      $durgiCreditAmtPCH += $creditDurgiAmtDataPCH['amount'];
    }
$durgiDebitAmtRM = 0;
  $debitDurgiAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'REMODELING' and type = 'Debit'");
    while($debitDurgiAmtDataRM = mysqli_fetch_array($debitDurgiAmtRM))
    { 
      $durgiDebitAmtRM += $debitDurgiAmtDataRM['amount'];
    } 

    $durgiCreditAmtRM = 0;
  $creditDurgiAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'REMODELING' and type = 'Credit'");
    while($creditDurgiAmtDataRM = mysqli_fetch_array($creditDurgiAmtRM))
    { 
      $durgiCreditAmtRM += $creditDurgiAmtDataRM['amount'];
    }
    $durgiDebitAmtRents = 0;
  $debitDurgiAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'RENTS' and type = 'Debit'");
    while($debitDurgiAmtDataRents = mysqli_fetch_array($debitDurgiAmtRents))
    { 
      $durgiDebitAmtRents += $debitDurgiAmtDataRents['amount'];
    } 

    $durgiCreditAmtRents = 0;
  $creditDurgiAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'RENTS' and type = 'Credit'");
    while($creditDurgiAmtDataRents = mysqli_fetch_array($creditDurgiAmtRents))
    { 
      $durgiCreditAmtRents += $creditDurgiAmtDataRents['amount'];
    }
    $durgiDebitAmtSal = 0;
  $debitDurgiAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'SALARIES' and type = 'Debit'");
    while($debitDurgiAmtDataSal = mysqli_fetch_array($debitDurgiAmtSal))
    { 
      $durgiDebitAmtSal += $debitDurgiAmtDataSal['amount'];
    } 

    $durgiCreditAmtSal = 0;
  $creditDurgiAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'SALARIES' and type = 'Credit'");
    while($creditDurgiAmtDataSal = mysqli_fetch_array($creditDurgiAmtSal))
    { 
      $durgiCreditAmtSal += $creditDurgiAmtDataSal['amount'];
    }
    $durgiDebitAmtSchol = 0;
  $debitDurgiAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'SCHOLARSHIP' and type = 'Debit'");
    while($debitDurgiAmtDataSchol = mysqli_fetch_array($debitDurgiAmtSchol))
    { 
      $durgiDebitAmtSchol += $debitDurgiAmtDataSchol['amount'];
    } 

    $durgiCreditAmtSchol = 0;
  $creditDurgiAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'SCHOLARSHIP' and type = 'Credit'");
    while($creditDurgiAmtDataSchol = mysqli_fetch_array($creditDurgiAmtSchol))
    { 
      $durgiCreditAmtSchol += $creditDurgiAmtDataSchol['amount'];
    }
    $durgiDebitAmtUD = 0;
  $debitDurgiAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'UNIFORM_DRESS' and type = 'Debit'");
    while($debitDurgiAmtDataUD = mysqli_fetch_array($debitDurgiAmtUD))
    { 
      $durgiDebitAmtUD += $debitDurgiAmtDataUD['amount'];
    } 

    $durgiCreditAmtUD = 0;
  $creditDurgiAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'UNIFORM_DRESS' and type = 'Credit'");
    while($creditDurgiAmtDataUD = mysqli_fetch_array($creditDurgiAmtUD))
    { 
      $durgiCreditAmtUD += $creditDurgiAmtDataUD['amount'];
    }
    $durgiDebitAmtVLF = 0;
  $debitDurgiAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and  category_name = 'VARTANA LAND FINANCE' and type = 'Debit'");
    while($debitDurgiAmtDataVLF = mysqli_fetch_array($debitDurgiAmtVLF))
    { 
      $durgiDebitAmtVLF += $debitDurgiAmtDataVLF['amount'];
    } 

    $durgiCreditAmtVLF = 0;
  $creditDurgiAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and category_name = 'VARTANA LAND FINANCE' and type = 'Credit'");
    while($creditDurgiAmtDataVLF = mysqli_fetch_array($creditDurgiAmtVLF))
    { 
      $durgiCreditAmtVLF += $creditDurgiAmtDataVLF['amount'];
    }

     $durgiDebitAmtUNREC = 0;
  $debitDurgiAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and  category_name = 'UNRECORDED' and type = 'Debit'");
    while($debitDurgiAmtDataUNREC = mysqli_fetch_array($debitDurgiAmtUNREC))
    { 
      $durgiDebitAmtUNREC += $debitDurgiAmtDataUNREC['amount'];
    } 

    $durgiCreditAmtUNREC = 0;
  $creditDurgiAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and category_name = 'UNRECORDED' and type = 'Credit'");
    while($creditDurgiAmtDataUNREC = mysqli_fetch_array($creditDurgiAmtUNREC))
    { 
      $durgiCreditAmtUNREC += $creditDurgiAmtDataUNREC['amount'];
    }




$degreeDebitAmtSPNAGAR = 0;
  $debitDegreeAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'SP NAGAR' and type = 'Debit'");
    while($debitDegreeAmtDataSPNAGAR = mysqli_fetch_array($debitDegreeAmtSPNAGAR))
    { 
      $degreeDebitAmtSPNAGAR += $debitDegreeAmtDataSPNAGAR['amount'];
    } 

    $degreeCreditAmtSPNAGAR = 0;
  $creditDegreeAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'SP NAGAR' and type = 'Credit'");
    while($creditDegreeAmtDataSPNAGAR = mysqli_fetch_array($creditDegreeAmtSPNAGAR))
    { 
      $degreeCreditAmtSPNAGAR += $creditDegreeAmtDataSPNAGAR['amount'];
    } 

    $degreeDebitAmtOLDTOWN = 0;
  $debitDegreeAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 
    'DEGREE' and  category_name = 'OLD TOWN' and type = 'Debit'");
    while($debitDegreeAmtDataOLDTOWN = mysqli_fetch_array($debitDegreeAmtOLDTOWN))
    { 
      $degreeDebitAmtOLDTOWN += $debitDegreeAmtDataOLDTOWN['amount'];
    } 

    $degreeCreditAmtOLDTOWN = 0;
  $creditDegreeAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'OLD TOWN' and type = 'Credit'");
    while($creditDegreeAmtDataOLDTOWN = mysqli_fetch_array($creditDegreeAmtOLDTOWN))
    { 
      $degreeCreditAmtOLDTOWN += $creditDegreeAmtDataOLDTOWN['amount'];
    } 

    $degreeDebitAmtDurgi = 0;
  $debitDegreeAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'DURGI' and type = 'Debit'");
    while($debitDegreeAmtDataDurgi = mysqli_fetch_array($debitDegreeAmtDurgi))
    { 
      $degreeDebitAmtDurgi += $debitDegreeAmtDataDurgi['amount'];
    } 

    $degreeCreditAmtDurgi = 0;
  $creditDegreeAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'DURGI' and type = 'Credit'");
    while($creditDegreeAmtDataDurgi = mysqli_fetch_array($creditDegreeAmtDurgi))
    { 
      $degreeCreditAmtDurgi += $creditDegreeAmtDataDurgi['amount'];
    } 

    $degreeDebitAmtInter = 0;
  $debitDegreeAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'INTERMEDIATE' and type = 'Debit'");
    while($debitDegreeAmtDataInter = mysqli_fetch_array($debitDegreeAmtInter))
    { 
      $degreeDebitAmtInter += $debitDegreeAmtDataInter['amount'];
    } 

    $degreeCreditAmtInter = 0;
  $creditDegreeAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'INTERMEDIATE' and type = 'Credit'");
    while($creditDegreeAmtDataInter = mysqli_fetch_array($creditDegreeAmtInter))
    { 
      $degreeCreditAmtInter += $creditDegreeAmtDataInter['amount'];
    } 

$degreeDebitAmtAB = 0;
  $debitDegreeAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'ANDHRA_UNION BANK' and type = 'Debit'");
    while($debitDegreeAmtDataAB = mysqli_fetch_array($debitDegreeAmtAB))
    { 
      $degreeDebitAmtAB += $debitDegreeAmtDataAB['amount'];
    } 

    $degreeCreditAmtAB = 0;
  $creditDegreeAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'ANDHRA_UNION BANK' and type = 'Credit'");
    while($creditDegreeAmtDataAB = mysqli_fetch_array($creditDegreeAmtAB))
    { 
      $degreeCreditAmtAB += $creditDegreeAmtDataAB['amount'];
    } 

    $degreeDebitAmtBills = 0;
  $debitDegreeAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'BILLS' and type = 'Debit'");
    while($debitDegreeAmtDataBills = mysqli_fetch_array($debitDegreeAmtBills))
    { 
      $degreeDebitAmtBills += $debitDegreeAmtDataBills['amount'];
    } 

    $degreeCreditAmtBills = 0;
  $creditDegreeAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'BILLS' and type = 'Credit'");
    while($creditDegreeAmtDataBills = mysqli_fetch_array($creditDegreeAmtBills))
    { 
      $degreeCreditAmtBills += $creditDegreeAmtDataBills['amount'];
    } 

    $degreeDebitAmtBooks = 0;
  $debitDegreeAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'BOOKS' and type = 'Debit'");
    while($debitDegreeAmtDataBooks = mysqli_fetch_array($debitDegreeAmtBooks))
    { 
      $degreeDebitAmtBooks += $debitDegreeAmtDataBooks['amount'];
    } 

    $degreeCreditAmtBooks = 0;
  $creditDegreeAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'BOOKS' and type = 'Credit'");
    while($creditDegreeAmtDataBooks = mysqli_fetch_array($creditDegreeAmtBooks))
    { 
      $degreeCreditAmtBooks += $creditDegreeAmtDataBooks['amount'];
    }

     $degreeDebitAmtBusFin = 0;
  $debitDegreeAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'BUS FINANCE' and type = 'Debit'");
    while($debitDegreeAmtDataBusFin = mysqli_fetch_array($debitDegreeAmtBusFin))
    { 
      $degreeDebitAmtBusFin += $debitDegreeAmtDataBusFin['amount'];
    } 

    $degreeCreditAmtBusFin = 0;
  $creditDegreeAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'BUS FINANCE' and type = 'Credit'");
    while($creditDegreeAmtDataBusFin = mysqli_fetch_array($creditDegreeAmtBusFin))
    { 
      $degreeCreditAmtBusFin += $creditDegreeAmtDataBusFin['amount'];

    }

    $degreeDebitAmtBusMain = 0;
  $debitDegreeAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'BUS MAINTENANCE' and type = 'Debit'");
    while($debitDegreeAmtDataBusMain = mysqli_fetch_array($debitDegreeAmtBusMain))
    { 
      $degreeDebitAmtBusMain += $debitDegreeAmtDataBusMain['amount'];
    } 

    $degreeCreditAmtBusMain = 0;
  $creditDegreeAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'BUS MAINTENANCE' and type = 'Credit'");
    while($creditDegreeAmtDataBusMain = mysqli_fetch_array($creditDegreeAmtBusMain))
    { 
      $degreeCreditAmtBusMain += $creditDegreeAmtDataBusMain['amount'];
    }

$degreeDebitAmtBusOil = 0;
  $debitDegreeAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'BUS OIL' and type = 'Debit'");
    while($debitDegreeAmtDataBusOil = mysqli_fetch_array($debitDegreeAmtBusOil))
    { 
      $degreeDebitAmtBusOil += $debitDegreeAmtDataBusOil['amount'];
    } 

    $degreeCreditAmtBusOil = 0;
  $creditDegreeAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'BUS OIL' and type = 'Credit'");
    while($creditDegreeAmtDataBusOil = mysqli_fetch_array($creditDegreeAmtBusOil))
    { 
      $degreeCreditAmtBusOil += $creditDegreeAmtDataBusOil['amount'];
    }
    $degreeDebitAmtBVR = 0;
  $debitDegreeAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'BVREDDY' and type = 'Debit'");
    while($debitDegreeAmtDataBVR = mysqli_fetch_array($debitDegreeAmtBVR))
    { 
      $degreeDebitAmtBVR += $debitDegreeAmtDataBVR['amount'];
    } 

    $degreeCreditAmtBVR = 0;
  $creditDegreeAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'BVREDDY' and type = 'Credit'");
    while($creditDegreeAmtDataBVR = mysqli_fetch_array($creditDegreeAmtBVR))
    { 
      $degreeCreditAmtBVR += $creditDegreeAmtDataBVR['amount'];
    }
    $degreeDebitAmtARR = 0;
  $debitDegreeAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'DR ARR' and type = 'Debit'");
    while($debitDegreeAmtDataARR = mysqli_fetch_array($debitDegreeAmtARR))
    { 
      $degreeDebitAmtARR += $debitDegreeAmtDataARR['amount'];
    } 

    $degreeCreditAmtARR = 0;
  $creditDegreeAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'DR ARR' and type = 'Credit'");
    while($creditDegreeAmtDataARR = mysqli_fetch_array($creditDegreeAmtARR))
    { 
      $degreeCreditAmtARR += $creditDegreeAmtDataARR['amount'];
    }
    $degreeDebitAmtEduFee = 0;
  $debitDegreeAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'EDUCATIONAL FEE' and type = 'Debit'");
    while($debitDegreeAmtDataEduFee = mysqli_fetch_array($debitDegreeAmtEduFee))
    { 
      $degreeDebitAmtEduFee += $debitDegreeAmtDataEduFee['amount'];
    } 

    $degreeCreditAmtEduFee = 0;
  $creditDegreeAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'EDUCATIONAL FEE' and type = 'Credit'");
    while($creditDegreeAmtDataEduFee = mysqli_fetch_array($creditDegreeAmtEduFee))
    { 
      $degreeCreditAmtEduFee += $creditDegreeAmtDataEduFee['amount'];
    }
    $degreeDebitAmtFamExp = 0;
  $debitDegreeAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'FAMILY EXP' and type = 'Debit'");
    while($debitDegreeAmtDataFamExp = mysqli_fetch_array($debitDegreeAmtFamExp))
    { 
      $degreeDebitAmtFamExp += $debitDegreeAmtDataFamExp['amount'];
    } 

    $degreeCreditAmtFamExp = 0;
  $creditDegreeAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'FAMILY EXP' and type = 'Credit'");
    while($creditDegreeAmtDataFamExp = mysqli_fetch_array($creditDegreeAmtFamExp))
    { 
      $degreeCreditAmtFamExp += $creditDegreeAmtDataFamExp['amount'];
    }
    $degreeDebitAmtGenMain = 0;
  $debitDegreeAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'GENERAL MAINTENANCE' and type = 'Debit'");
    while($debitDegreeAmtDataGenMain = mysqli_fetch_array($debitDegreeAmtGenMain))
    { 
      $degreeDebitAmtGenMain += $debitDegreeAmtDataGenMain['amount'];
    } 

    $degreeCreditAmtGenMain = 0;
  $creditDegreeAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'GENERAL MAINTENANCE' and type = 'Credit'");
    while($creditDegreeAmtDataGenMain = mysqli_fetch_array($creditDegreeAmtGenMain))
    { 
      $degreeCreditAmtGenMain += $creditDegreeAmtDataGenMain['amount'];
    }
    $degreeDebitAmtHdfc = 0;
  $debitDegreeAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'HDFC BANK' and type = 'Debit'");
    while($debitDegreeAmtDataHdfc = mysqli_fetch_array($debitDegreeAmtHdfc))
    { 
      $degreeDebitAmtHdfc += $debitDegreeAmtDataHdfc['amount'];
    } 

    $degreeCreditAmtHdfc = 0;
  $creditDegreeAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'HDFC BANK' and type = 'Credit'");
    while($creditDegreeAmtDataHdfc = mysqli_fetch_array($creditDegreeAmtHdfc))
    { 
      $degreeCreditAmtHdfc += $creditDegreeAmtDataHdfc['amount'];
    }
    $degreeDebitAmtIcici = 0;
  $debitDegreeAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'ICICI BANK' and type = 'Debit'");
    while($debitDegreeAmtDataIcici = mysqli_fetch_array($debitDegreeAmtIcici))
    { 
      $degreeDebitAmtIcici += $debitDegreeAmtDataIcici['amount'];
    } 

    $degreeCreditAmtIcici = 0;
  $creditDegreeAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'ICICI BANK' and type = 'Credit'");
    while($creditDegreeAmtDataIcici = mysqli_fetch_array($creditDegreeAmtIcici))
    { 
      $degreeCreditAmtIcici += $creditDegreeAmtDataIcici['amount'];
    }
    $degreeDebitAmtOL = 0;
  $debitDegreeAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'OTHER LOANS' and type = 'Debit'");
    while($debitDegreeAmtDataOL = mysqli_fetch_array($debitDegreeAmtOL))
    { 
      $degreeDebitAmtOL += $debitDegreeAmtDataOL['amount'];
    } 

    $degreeCreditAmtOL = 0;
  $creditDegreeAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'OTHER LOANS' and type = 'Credit'");
    while($creditDegreeAmtDataOL = mysqli_fetch_array($creditDegreeAmtOL))
    { 
      $degreeCreditAmtOL += $creditDegreeAmtDataOL['amount'];
    }
$degreeDebitAmtPCH = 0;
  $debitDegreeAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'PRAGATHI CROPS HYD' and type = 'Debit'");
    while($debitDegreeAmtDataPCH = mysqli_fetch_array($debitDegreeAmtPCH))
    { 
      $degreeDebitAmtPCH += $debitDegreeAmtDataPCH['amount'];
    } 

    $degreeCreditAmtPCH = 0;
  $creditDegreeAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'PRAGATHI CROPS HYD' and type = 'Credit'");
    while($creditDegreeAmtDataPCH = mysqli_fetch_array($creditDegreeAmtPCH))
    { 
      $degreeCreditAmtPCH += $creditDegreeAmtDataPCH['amount'];
    }
$degreeDebitAmtRM = 0;
  $debitDegreeAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'REMODELING' and type = 'Debit'");
    while($debitDegreeAmtDataRM = mysqli_fetch_array($debitDegreeAmtRM))
    { 
      $degreeDebitAmtRM += $debitDegreeAmtDataRM['amount'];
    } 

    $degreeCreditAmtRM = 0;
  $creditDegreeAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'REMODELING' and type = 'Credit'");
    while($creditDegreeAmtDataRM = mysqli_fetch_array($creditDegreeAmtRM))
    { 
      $degreeCreditAmtRM += $creditDegreeAmtDataRM['amount'];
    }
    $degreeDebitAmtRents = 0;
  $debitDegreeAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'RENTS' and type = 'Debit'");
    while($debitDegreeAmtDataRents = mysqli_fetch_array($debitDegreeAmtRents))
    { 
      $degreeDebitAmtRents += $debitDegreeAmtDataRents['amount'];
    } 

    $degreeCreditAmtRents = 0;
  $creditDegreeAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'RENTS' and type = 'Credit'");
    while($creditDegreeAmtDataRents = mysqli_fetch_array($creditDegreeAmtRents))
    { 
      $degreeCreditAmtRents += $creditDegreeAmtDataRents['amount'];
    }
    $degreeDebitAmtSal = 0;
  $debitDegreeAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'SALARIES' and type = 'Debit'");
    while($debitDegreeAmtDataSal = mysqli_fetch_array($debitDegreeAmtSal))
    { 
      $degreeDebitAmtSal += $debitDegreeAmtDataSal['amount'];
    } 

    $degreeCreditAmtSal = 0;
  $creditDegreeAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'SALARIES' and type = 'Credit'");
    while($creditDegreeAmtDataSal = mysqli_fetch_array($creditDegreeAmtSal))
    { 
      $degreeCreditAmtSal += $creditDegreeAmtDataSal['amount'];
    }
    $degreeDebitAmtSchol = 0;
  $debitDegreeAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'SCHOLARSHIP' and type = 'Debit'");
    while($debitDegreeAmtDataSchol = mysqli_fetch_array($debitDegreeAmtSchol))
    { 
      $degreeDebitAmtSchol += $debitDegreeAmtDataSchol['amount'];
    } 

    $degreeCreditAmtSchol = 0;
  $creditDegreeAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'SCHOLARSHIP' and type = 'Credit'");
    while($creditDegreeAmtDataSchol = mysqli_fetch_array($creditDegreeAmtSchol))
    { 
      $degreeCreditAmtSchol += $creditDegreeAmtDataSchol['amount'];
    }
    $degreeDebitAmtUD = 0;
  $debitDegreeAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'UNIFORM_DRESS' and type = 'Debit'");
    while($debitDegreeAmtDataUD = mysqli_fetch_array($debitDegreeAmtUD))
    { 
      $degreeDebitAmtUD += $debitDegreeAmtDataUD['amount'];
    } 

    $degreeCreditAmtUD = 0;
  $creditDegreeAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'UNIFORM_DRESS' and type = 'Credit'");
    while($creditDegreeAmtDataUD = mysqli_fetch_array($creditDegreeAmtUD))
    { 
      $degreeCreditAmtUD += $creditDegreeAmtDataUD['amount'];
    }
    $degreeDebitAmtVLF = 0;
  $debitDegreeAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'VARTANA LAND FINANCE' and type = 'Debit'");
    while($debitDegreeAmtDataVLF = mysqli_fetch_array($debitDegreeAmtVLF))
    { 
      $degreeDebitAmtVLF += $debitDegreeAmtDataVLF['amount'];
    } 

    $degreeCreditAmtVLF = 0;
  $creditDegreeAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'VARTANA LAND FINANCE' and type = 'Credit'");
    while($creditDegreeAmtDataVLF = mysqli_fetch_array($creditDegreeAmtVLF))
    { 
      $degreeCreditAmtVLF += $creditDegreeAmtDataVLF['amount'];
    }

      $degreeDebitAmtUNREC = 0;
  $debitDegreeAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'UNRECORDED' and type = 'Debit'");
    while($debitDegreeAmtDataUNREC = mysqli_fetch_array($debitDegreeAmtUNREC))
    { 
      $degreeDebitAmtUNREC += $debitDegreeAmtDataUNREC['amount'];
    } 

    $degreeCreditAmtUNREC = 0;
  $creditDegreeAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'UNRECORDED' and type = 'Credit'");
    while($creditDegreeAmtDataUNREC = mysqli_fetch_array($creditDegreeAmtUNREC))
    { 
      $degreeCreditAmtUNREC += $creditDegreeAmtDataUNREC['amount'];
    }



$interDebitAmtSPNAGAR = 0;
  $debitInterAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'SP NAGAR' and type = 'Debit'");
    while($debitInterAmtDataSPNAGAR = mysqli_fetch_array($debitInterAmtSPNAGAR))
    { 
      $interDebitAmtSPNAGAR += $debitInterAmtDataSPNAGAR['amount'];
    } 

    $interCreditAmtSPNAGAR = 0;
  $creditInterAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'SP NAGAR' and type = 'Credit'");
    while($creditInterAmtDataSPNAGAR = mysqli_fetch_array($creditInterAmtSPNAGAR))
    { 
      $interCreditAmtSPNAGAR += $creditInterAmtDataSPNAGAR['amount'];
    } 

    $interDebitAmtOLDTOWN = 0;
  $debitInterAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'OLD TOWN' and type = 'Debit'");
    while($debitInterAmtDataOLDTOWN = mysqli_fetch_array($debitInterAmtOLDTOWN))
    { 
      $interDebitAmtOLDTOWN += $debitInterAmtDataOLDTOWN['amount'];
    } 

    $interCreditAmtOLDTOWN = 0;
  $creditInterAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'OLD TOWN' and type = 'Credit'");
    while($creditInterAmtDataOLDTOWN = mysqli_fetch_array($creditInterAmtOLDTOWN))
    { 
      $interCreditAmtOLDTOWN += $creditInterAmtDataOLDTOWN['amount'];
    } 

    $interDebitAmtDurgi = 0;
  $debitInterAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'DURGI' and type = 'Debit'");
    while($debitInterAmtDataDurgi = mysqli_fetch_array($debitInterAmtDurgi))
    { 
      $interDebitAmtDurgi += $debitInterAmtDataDurgi['amount'];
    } 

    $interCreditAmtDurgi = 0;
  $creditInterAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'DURGI' and type = 'Credit'");
    while($creditInterAmtDataDurgi = mysqli_fetch_array($creditInterAmtDurgi))
    { 
      $interCreditAmtDurgi += $creditInterAmtDataDurgi['amount'];
    } 

    $interDebitAmtDegree = 0;
  $debitInterAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'DEGREE' and type = 'Debit'");
    while($debitInterAmtDataDegree = mysqli_fetch_array($debitInterAmtDegree))
    { 
      $interDebitAmtDegree += $debitInterAmtDataDegree['amount'];
    } 

    $interCreditAmtDegree = 0;
  $creditInterAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'DEGREE' and type = 'Credit'");
    while($creditInterAmtDataDegree = mysqli_fetch_array($creditInterAmtDegree))
    { 
      $interCreditAmtDegree += $creditInterAmtDataDegree['amount'];
    } 

$interDebitAmtAB = 0;
  $debitInterAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'ANDHRA_UNION BANK' and type = 'Debit'");
    while($debitInterAmtDataAB = mysqli_fetch_array($debitInterAmtAB))
    { 
      $interDebitAmtAB += $debitInterAmtDataAB['amount'];
    } 

    $interCreditAmtAB = 0;
  $creditInterAmtAB = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'ANDHRA_UNION BANK' and type = 'Credit'");
    while($creditInterAmtDataAB = mysqli_fetch_array($creditInterAmtAB))
    { 
      $interCreditAmtAB += $creditInterAmtDataAB['amount'];
    } 

    $interDebitAmtBills = 0;
  $debitInterAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'BILLS' and type = 'Debit'");
    while($debitInterAmtDataBills = mysqli_fetch_array($debitInterAmtBills))
    { 
      $interDebitAmtBills += $debitInterAmtDataBills['amount'];
    } 

    $interCreditAmtBills = 0;
  $creditInterAmtBills = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'BILLS' and type = 'Credit'");
    while($creditInterAmtDataBills = mysqli_fetch_array($creditInterAmtBills))
    { 
      $interCreditAmtBills += $creditInterAmtDataBills['amount'];
    } 

    $interDebitAmtBooks = 0;
  $debitInterAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'BOOKS' and type = 'Debit'");
    while($debitInterAmtDataBooks = mysqli_fetch_array($debitInterAmtBooks))
    { 
      $interDebitAmtBooks += $debitInterAmtDataBooks['amount'];
    } 

    $interCreditAmtBooks = 0;
  $creditInterAmtBooks = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'BOOKS' and type = 'Credit'");
    while($creditInterAmtDataBooks = mysqli_fetch_array($creditInterAmtBooks))
    { 
      $interCreditAmtBooks += $creditInterAmtDataBooks['amount'];
    }

     $interDebitAmtBusFin = 0;
  $debitInterAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'BUS FINANCE' and type = 'Debit'");
    while($debitInterAmtDataBusFin = mysqli_fetch_array($debitInterAmtBusFin))
    { 
      $interDebitAmtBusFin += $debitInterAmtDataBusFin['amount'];
    } 

    $interCreditAmtBusFin = 0;
  $creditInterAmtBusFin = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'BUS FINANCE' and type = 'Credit'");
    while($creditInterAmtDataBusFin = mysqli_fetch_array($creditInterAmtBusFin))
    { 
      $interCreditAmtBusFin += $creditInterAmtDataBusFin['amount'];

    }

    $interDebitAmtBusMain = 0;
  $debitInterAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'BUS MAINTENANCE' and type = 'Debit'");
    while($debitInterAmtDataBusMain = mysqli_fetch_array($debitInterAmtBusMain))
    { 
      $interDebitAmtBusMain += $debitInterAmtDataBusMain['amount'];
    } 

    $interCreditAmtBusMain = 0;
  $creditInterAmtBusMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'BUS MAINTENANCE' and type = 'Credit'");
    while($creditInterAmtDataBusMain = mysqli_fetch_array($creditInterAmtBusMain))
    { 
      $interCreditAmtBusMain += $creditInterAmtDataBusMain['amount'];
    }

$interDebitAmtBusOil = 0;
  $debitInterAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'BUS OIL' and type = 'Debit'");
    while($debitInterAmtDataBusOil = mysqli_fetch_array($debitInterAmtBusOil))
    { 
      $interDebitAmtBusOil += $debitInterAmtDataBusOil['amount'];
    } 

    $interCreditAmtBusOil = 0;
  $creditInterAmtBusOil = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'BUS OIL' and type = 'Credit'");
    while($creditInterAmtDataBusOil = mysqli_fetch_array($creditInterAmtBusOil))
    { 
      $interCreditAmtBusOil += $creditInterAmtDataBusOil['amount'];
    }
    $interDebitAmtBVR = 0;
  $debitInterAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'BVREDDY' and type = 'Debit'");
    while($debitInterAmtDataBVR = mysqli_fetch_array($debitInterAmtBVR))
    { 
      $interDebitAmtBVR += $debitInterAmtDataBVR['amount'];
    } 

    $interCreditAmtBVR = 0;
  $creditInterAmtBVR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'BVREDDY' and type = 'Credit'");
    while($creditInterAmtDataBVR = mysqli_fetch_array($creditInterAmtBVR))
    { 
      $interCreditAmtBVR += $creditInterAmtDataBVR['amount'];
    }
    $interDebitAmtARR = 0;
  $debitInterAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'DR ARR' and type = 'Debit'");
    while($debitInterAmtDataARR = mysqli_fetch_array($debitInterAmtARR))
    { 
      $interDebitAmtARR += $debitInterAmtDataARR['amount'];
    } 

    $interCreditAmtARR = 0;
  $creditInterAmtARR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'DR ARR' and type = 'Credit'");
    while($creditInterAmtDataARR = mysqli_fetch_array($creditInterAmtARR))
    { 
      $interCreditAmtARR += $creditInterAmtDataARR['amount'];
    }
    $interDebitAmtEduFee = 0;
  $debitInterAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'EDUCATIONAL FEE' and type = 'Debit'");
    while($debitInterAmtDataEduFee = mysqli_fetch_array($debitInterAmtEduFee))
    { 
      $interDebitAmtEduFee += $debitInterAmtDataEduFee['amount'];
    } 

    $interCreditAmtEduFee = 0;
  $creditInterAmtEduFee = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'EDUCATIONAL FEE' and type = 'Credit'");
    while($creditInterAmtDataEduFee = mysqli_fetch_array($creditInterAmtEduFee))
    { 
      $interCreditAmtEduFee += $creditInterAmtDataEduFee['amount'];
    }
    $interDebitAmtFamExp = 0;
  $debitInterAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'FAMILY EXP' and type = 'Debit'");
    while($debitInterAmtDataFamExp = mysqli_fetch_array($debitInterAmtFamExp))
    { 
      $interDebitAmtFamExp += $debitInterAmtDataFamExp['amount'];
    } 

    $interCreditAmtFamExp = 0;
  $creditInterAmtFamExp = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'FAMILY EXP' and type = 'Credit'");
    while($creditInterAmtDataFamExp = mysqli_fetch_array($creditInterAmtFamExp))
    { 
      $interCreditAmtFamExp += $creditInterAmtDataFamExp['amount'];
    }
    $interDebitAmtGenMain = 0;
  $debitInterAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'GENERAL MAINTENANCE' and type = 'Debit'");
    while($debitInterAmtDataGenMain = mysqli_fetch_array($debitInterAmtGenMain))
    { 
      $interDebitAmtGenMain += $debitInterAmtDataGenMain['amount'];
    } 

    $interCreditAmtGenMain = 0;
  $creditInterAmtGenMain = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'GENERAL MAINTENANCE' and type = 'Credit'");
    while($creditInterAmtDataGenMain = mysqli_fetch_array($creditInterAmtGenMain))
    { 
      $interCreditAmtGenMain += $creditInterAmtDataGenMain['amount'];
    }
    $interDebitAmtHdfc = 0;
  $debitInterAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'HDFC BANK' and type = 'Debit'");
    while($debitInterAmtDataHdfc = mysqli_fetch_array($debitInterAmtHdfc))
    { 
      $interDebitAmtHdfc += $debitInterAmtDataHdfc['amount'];
    } 

    $interCreditAmtHdfc = 0;
  $creditInterAmtHdfc = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'HDFC BANK' and type = 'Credit'");
    while($creditInterAmtDataHdfc = mysqli_fetch_array($creditInterAmtHdfc))
    { 
      $interCreditAmtHdfc += $creditInterAmtDataHdfc['amount'];
    }
    $interDebitAmtIcici = 0;
  $debitInterAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'ICICI BANK' and type = 'Debit'");
    while($debitInterAmtDataIcici = mysqli_fetch_array($debitInterAmtIcici))
    { 
      $interDebitAmtIcici += $debitInterAmtDataIcici['amount'];
    } 

    $interCreditAmtIcici = 0;
  $creditInterAmtIcici = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'ICICI BANK' and type = 'Credit'");
    while($creditInterAmtDataIcici = mysqli_fetch_array($creditInterAmtIcici))
    { 
      $interCreditAmtIcici += $creditInterAmtDataIcici['amount'];
    }
    $interDebitAmtOL = 0;
  $debitInterAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'OTHER LOANS' and type = 'Debit'");
    while($debitInterAmtDataOL = mysqli_fetch_array($debitInterAmtOL))
    { 
      $interDebitAmtOL += $debitInterAmtDataOL['amount'];
    } 

    $interCreditAmtOL = 0;
  $creditInterAmtOL = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'OTHER LOANS' and type = 'Credit'");
    while($creditInterAmtDataOL = mysqli_fetch_array($creditInterAmtOL))
    { 
      $interCreditAmtOL += $creditInterAmtDataOL['amount'];
    }
$interDebitAmtPCH = 0;
  $debitInterAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'PRAGATHI CROPS HYD' and type = 'Debit'");
    while($debitInterAmtDataPCH = mysqli_fetch_array($debitInterAmtPCH))
    { 
      $interDebitAmtPCH += $debitInterAmtDataPCH['amount'];
    } 

    $interCreditAmtPCH = 0;
  $creditInterAmtPCH = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'PRAGATHI CROPS HYD' and type = 'Credit'");
    while($creditInterAmtDataPCH = mysqli_fetch_array($creditInterAmtPCH))
    { 
      $interCreditAmtPCH += $creditInterAmtDataPCH['amount'];
    }
$interDebitAmtRM = 0;
  $debitInterAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'REMODELING' and type = 'Debit'");
    while($debitInterAmtDataRM = mysqli_fetch_array($debitInterAmtRM))
    { 
      $interDebitAmtRM += $debitInterAmtDataRM['amount'];
    } 

    $interCreditAmtRM = 0;
  $creditInterAmtRM = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'REMODELING' and type = 'Credit'");
    while($creditInterAmtDataRM = mysqli_fetch_array($creditInterAmtRM))
    { 
      $interCreditAmtRM += $creditInterAmtDataRM['amount'];
    }
    $interDebitAmtRents = 0;
  $debitInterAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'RENTS' and type = 'Debit'");
    while($debitInterAmtDataRents = mysqli_fetch_array($debitInterAmtRents))
    { 
      $interDebitAmtRents += $debitInterAmtDataRents['amount'];
    } 

    $interCreditAmtRents = 0;
  $creditInterAmtRents = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'RENTS' and type = 'Credit'");
    while($creditInterAmtDataRents = mysqli_fetch_array($creditInterAmtRents))
    { 
      $interCreditAmtRents += $creditInterAmtDataRents['amount'];
    }
    $interDebitAmtSal = 0;
  $debitInterAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'SALARIES' and type = 'Debit'");
    while($debitInterAmtDataSal = mysqli_fetch_array($debitInterAmtSal))
    { 
      $interDebitAmtSal += $debitInterAmtDataSal['amount'];
    } 

    $interCreditAmtSal = 0;
  $creditInterAmtSal = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'SALARIES' and type = 'Credit'");
    while($creditInterAmtDataSal = mysqli_fetch_array($creditInterAmtSal))
    { 
      $interCreditAmtSal += $creditInterAmtDataSal['amount'];
    }
    $interDebitAmtSchol = 0;
  $debitInterAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'SCHOLARSHIP' and type = 'Debit'");
    while($debitInterAmtDataSchol = mysqli_fetch_array($debitInterAmtSchol))
    { 
      $interDebitAmtSchol += $debitInterAmtDataSchol['amount'];
    } 

    $interCreditAmtSchol = 0;
  $creditInterAmtSchol = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'SCHOLARSHIP' and type = 'Credit'");
    while($creditInterAmtDataSchol = mysqli_fetch_array($creditInterAmtSchol))
    { 
      $interCreditAmtSchol += $creditInterAmtDataSchol['amount'];
    }
    $interDebitAmtUD = 0;
  $debitInterAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'UNIFORM_DRESS' and type = 'Debit'");
    while($debitInterAmtDataUD = mysqli_fetch_array($debitInterAmtUD))
    { 
      $interDebitAmtUD += $debitInterAmtDataUD['amount'];
    } 

    $interCreditAmtUD = 0;
  $creditInterAmtUD = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'UNIFORM_DRESS' and type = 'Credit'");
    while($creditInterAmtDataUD = mysqli_fetch_array($creditInterAmtUD))
    { 
      $interCreditAmtUD += $creditInterAmtDataUD['amount'];
    }
    $interDebitAmtVLF = 0;
  $debitInterAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and  category_name = 'VARTANA LAND FINANCE' and type = 'Debit'");
    while($debitInterAmtDataVLF = mysqli_fetch_array($debitInterAmtVLF))
    { 
      $interDebitAmtVLF += $debitInterAmtDataVLF['amount'];
    } 

    $interCreditAmtVLF = 0;
  $creditInterAmtVLF = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and category_name = 'VARTANA LAND FINANCE' and type = 'Credit'");
    while($creditInterAmtDataVLF = mysqli_fetch_array($creditInterAmtVLF))
    { 
      $interCreditAmtVLF += $creditInterAmtDataVLF['amount'];
    }

    $interDebitAmtUNREC = 0;
  $debitInterAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and  category_name = 'UNRECORDED' and type = 'Debit'");
    while($debitInterAmtDataUNREC = mysqli_fetch_array($debitInterAmtUNREC))
    { 
      $interDebitAmtUNREC += $debitInterAmtDataUNREC['amount'];
    } 

    $interCreditAmtUNREC = 0;
  $creditInterAmtUNREC = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and category_name = 'UNRECORDED' and type = 'Credit'");
    while($creditInterAmtDataUNREC = mysqli_fetch_array($creditInterAmtUNREC))
    { 
      $interCreditAmtUNREC += $creditInterAmtDataUNREC['amount'];
    }







$totalDebitAmtDurgi = 0;
  $debitTotalAmtDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and type = 'Debit'");
    while($debitTotalAmtDataDurgi = mysqli_fetch_array($debitTotalAmtDurgi))
    { 
      $totalDebitAmtDurgi += $debitTotalAmtDataDurgi['amount'];
    } 

    $totalCreditAmtDurgi = 0;
  $creditTotalDurgi = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DURGI' and type = 'Credit'");
    while($creditTotalDataDurgi = mysqli_fetch_array($creditTotalDurgi))
    { 
      $totalCreditAmtDurgi += $creditTotalDataDurgi['amount'];
    } 

    $totalDebitAmtSPNAGAR = 0;
  $debitTotalAmtSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and type = 'Debit'");
    while($debitTotalAmtDataSPNAGAR = mysqli_fetch_array($debitTotalAmtSPNAGAR))
    { 
      $totalDebitAmtSPNAGAR += $debitTotalAmtDataSPNAGAR['amount'];
    } 

    $totalCreditAmtSPNAGAR = 0;
  $creditTotalSPNAGAR = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'SP NAGAR' and type = 'Credit'");
    while($creditTotalDataSPNAGAR = mysqli_fetch_array($creditTotalSPNAGAR))
    { 
      $totalCreditAmtSPNAGAR += $creditTotalDataSPNAGAR['amount'];
    } 

    $totalDebitAmtOLDTOWN = 0;
  $debitTotalAmtOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and type = 'Debit'");
    while($debitTotalAmtDataOLDTOWN = mysqli_fetch_array($debitTotalAmtOLDTOWN))
    { 
      $totalDebitAmtOLDTOWN += $debitTotalAmtDataOLDTOWN['amount'];
    } 

    $totalCreditAmtOLDTOWN = 0;
  $creditTotalOLDTOWN = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'OLD TOWN' and type = 'Credit'");
    while($creditTotalDataOLDTOWN = mysqli_fetch_array($creditTotalOLDTOWN))
    { 
      $totalCreditAmtOLDTOWN += $creditTotalDataOLDTOWN['amount'];
    } 

    $totalDebitAmtDegree = 0;
  $debitTotalAmtDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and type = 'Debit'");
    while($debitTotalAmtDataDegree = mysqli_fetch_array($debitTotalAmtDegree))
    { 
      $totalDebitAmtDegree += $debitTotalAmtDataDegree['amount'];
    } 

    $totalCreditAmtDegree = 0;
  $creditTotalDegree = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'DEGREE' and type = 'Credit'");
    while($creditTotalDataDegree = mysqli_fetch_array($creditTotalDegree))
    { 
      $totalCreditAmtDegree += $creditTotalDataDegree['amount'];
    } 

    $totalDebitAmtInter = 0;
  $debitTotalAmtInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and type = 'Debit'");
    while($debitTotalAmtDataInter = mysqli_fetch_array($debitTotalAmtInter))
    { 
      $totalDebitAmtInter += $debitTotalAmtDataInter['amount'];
    } 

    $totalCreditAmtInter = 0;
  $creditTotalInter = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'INTERMEDIATE' and type = 'Credit'");
    while($creditTotalDataInter = mysqli_fetch_array($creditTotalInter))
    { 
      $totalCreditAmtInter += $creditTotalDataInter['amount'];
    } 

    $totalDebitAmtBS = 0;
  $debitTotalAmtBS = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'BANK STATEMENTS' and type = 'Debit'");
    while($debitTotalAmtDataBS = mysqli_fetch_array($debitTotalAmtBS))
    { 
      $totalDebitAmtBS += $debitTotalAmtDataBS['amount'];
    } 

    $totalCreditAmtBS = 0;
  $creditTotalBS = mysqli_query($conn,"SELECT amount FROM daybook_cre_deb where academicYear = '2015-16' and branch_name = 'BANK STATEMENTS' and type = 'Credit'");
    while($creditTotalDataBS = mysqli_fetch_array($creditTotalBS))
    { 
      $totalCreditAmtBS += $creditTotalDataBS['amount'];
    } 
?>

<script language=javascript>
function gotoUrl(b){if(b==""){return}location.href=b}function newWin(b){if(b==""){return}window.open(b.substring(b.indexOf(",")+1,b.length),b.substring(0,b.indexOf(",")))}

  function printContent(el){
    var restorepage = document.body.innerHTML;
    var printcontent = document.getElementById(el).innerHTML;
    document.body.innerHTML = printcontent; 
    window.print();    
    document.body.innerHTML = restorepage;
  } 
 </script>



<main id="main" class="main">
    <div class="pagetitle">
      <h1>School Data</h1>
      <nav>
        <ol class="breadcrumb">
          <li class="breadcrumb-item"><a href="index.php">Home</a></li> 
          <li class="breadcrumb-item active">Balance Sheet</li>
        </ol>
      </nav>
    </div> 
    <section class="section">
      <div class="row">
        <div class="col-lg-12">
          <div class="card">
             <button class="btn btn-primary btn-sm" style="text-align: center;" onclick="printContent('printing')"> Print </button> 

<select name=select id=select OnChange=gotoUrl(this.options[this.selectedIndex].value)>
<option value="balanceSheet.php">All Academic</option>
<option value="AcademicYear2015-16.php" selected=selected>2015-16</option>
<option value="AcademicYear2016-17.php">2016-17</option>
<option value="AcademicYear2017-18.php">2017-18</option>
<option value="AcademicYear2018-19.php">2018-19</option>
<option value="AcademicYear2019-20.php">2019-20</option>
<option value="AcademicYear2020-21.php">2020-21</option>
<option value="AcademicYear2021-22.php">2021-22</option>
</select>

            <div class="card-body printing" id="printing"> 
              <h5 class="card-title">2015-16 BALANCESHEET</h5> 
              <h3 style="color:green;text-decoration-style: solid;"> OLD TOWN </h3>
              <table class="table" style="width: 100%;">
                <thead>
                  <tr style="background-color: blue; color: white;"> 
                    <th>AREA</th>
                    <th>CREDIT</th>  
                    <th>DEBIT</th>
                    <th>BALANCE</th> 
                  </tr>
                </thead> 
                <tbody>
                  <tr style="color:red">
                    <th>Durgi</th>
                    <td><?php echo $otCreditAmtDurgi ?></td> 
                    <td><?php echo $otDebitAmtDurgi ?></td>                      
                    <td><?php echo $otCreditAmtDurgi - $otDebitAmtDurgi ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>SP Nagar</th>
                    <td><?php echo $otCreditAmtSPNAGAR ?></td> 
                    <td><?php echo $otDebitAmtSPNAGAR ?></td>                      
                    <td><?php echo $otCreditAmtSPNAGAR - $otDebitAmtSPNAGAR ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Degree</th>
                    <td><?php echo $otCreditAmtDegree ?></td> 
                    <td><?php echo $otDebitAmtDegree ?></td>                      
                    <td><?php echo $otCreditAmtDegree - $otDebitAmtDegree ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Intermediate</th>
                    <td><?php echo $otCreditAmtInter ?></td> 
                    <td><?php echo $otDebitAmtInter ?></td>                      
                    <td><?php echo $otCreditAmtInter - $otDebitAmtInter ?></td>  
                  </tr>   
                  <tr style="color:red">
                    <th>BV REDDY</th>
                    <td><?php echo $otCreditAmtBVR ?></td> 
                    <td><?php echo $otDebitAmtBVR  ?></td>                      
                    <td><?php echo $otCreditAmtBVR - $otDebitAmtBVR ?></td>  
                  </tr> 
                   <tr style="color:red">
                    <th>DR ARR</th>
                    <td><?php echo $otCreditAmtARR ?></td> 
                    <td><?php echo $otDebitAmtARR  ?></td>                      
                    <td><?php echo $otCreditAmtARR - $otDebitAmtARR ?></td>  
                  </tr> 
                  <tr>
                    <th>Andhra/Union Bank</th>
                    <td><?php echo $otCreditAmtAB ?></td> 
                    <td><?php echo $otDebitAmtAB ?></td>                      
                    <td><?php echo $otCreditAmtAB - $otDebitAmtAB ?></td>  
                  </tr> 
                  <tr>
                    <th>Bills</th>
                    <td><?php echo $otCreditAmtBills ?></td> 
                    <td><?php echo $otDebitAmtBills ?></td>                      
                    <td><?php echo $otCreditAmtBills - $otDebitAmtBills ?></td>  
                  </tr>  
                  <tr>
                    <th>Books</th>
                    <td><?php echo $otCreditAmtBooks ?></td> 
                    <td><?php echo $otDebitAmtBooks ?></td>                      
                    <td><?php echo $otCreditAmtBooks - $otDebitAmtBooks ?></td>  
                  </tr>  
                  <tr>
                    <th>Bus Finance</th>
                    <td><?php echo $otCreditAmtBusFin ?></td> 
                    <td><?php echo $otDebitAmtBusFin  ?></td>                      
                    <td><?php echo $otCreditAmtBusFin - $otDebitAmtBusFin ?></td>  
                  </tr>   
                  <tr>
                    <th>Bus Maintenance</th>
                    <td><?php echo $otCreditAmtBusMain ?></td> 
                    <td><?php echo $otDebitAmtBusMain  ?></td>                      
                    <td><?php echo $otCreditAmtBusMain - $otDebitAmtBusMain ?></td>  
                  </tr>    
                  <tr>
                    <th>Bus Oil</th>
                    <td><?php echo $otCreditAmtBusOil ?></td> 
                    <td><?php echo $otDebitAmtBusOil  ?></td>                      
                    <td><?php echo $otCreditAmtBusOil - $otDebitAmtBusOil ?></td>  
                  </tr> 
                  <tr>
                    <th>Educational Fee</th>
                    <td><?php echo $otCreditAmtEduFee ?></td> 
                    <td><?php echo $otDebitAmtEduFee  ?></td>                      
                    <td><?php echo $otCreditAmtEduFee - $otDebitAmtEduFee ?></td>  
                  </tr>  
                  <tr>
                    <th>Family Exp</th>
                    <td><?php echo $otCreditAmtFamExp ?></td> 
                    <td><?php echo $otDebitAmtFamExp  ?></td>                      
                    <td><?php echo $otCreditAmtFamExp - $otDebitAmtFamExp ?></td>  
                  </tr>   
                  <tr>
                    <th>GENERAL MAINTENANCE</th>
                    <td><?php echo $otCreditAmtGenMain ?></td> 
                    <td><?php echo $otDebitAmtGenMain  ?></td>                      
                    <td><?php echo $otCreditAmtGenMain - $otDebitAmtGenMain ?></td>  
                  </tr>  
                  <tr>
                    <th>HDFC BANK</th>
                    <td><?php echo $otCreditAmtHdfc ?></td> 
                    <td><?php echo $otDebitAmtHdfc  ?></td>                      
                    <td><?php echo $otCreditAmtHdfc - $otDebitAmtHdfc ?></td>  
                  </tr>  
                  <tr>
                    <th>ICICI BANK</th>
                    <td><?php echo $otCreditAmtIcici ?></td> 
                    <td><?php echo $otDebitAmtIcici  ?></td>                      
                    <td><?php echo $otCreditAmtIcici - $otDebitAmtIcici ?></td>  
                  </tr> 
                  <tr>
                    <th>OTHER LOANS</th>
                    <td><?php echo $otCreditAmtOL ?></td> 
                    <td><?php echo $otDebitAmtOL  ?></td>                      
                    <td><?php echo $otCreditAmtOL - $otDebitAmtOL ?></td>  
                  </tr> 
                  <tr>
                    <th>Pragathi Crops Hyd</th>
                    <td><?php echo $otCreditAmtPCH ?></td> 
                    <td><?php echo $otDebitAmtPCH  ?></td>                      
                    <td><?php echo $otCreditAmtPCH - $otDebitAmtPCH ?></td>  
                  </tr> 
                  <tr>
                    <th>Remodiling</th>
                    <td><?php echo $otCreditAmtRM ?></td> 
                    <td><?php echo $otDebitAmtRM  ?></td>                      
                    <td><?php echo $otCreditAmtRM - $otDebitAmtRM ?></td>  
                  </tr>  
                  <tr>
                    <th>Rents</th>
                    <td><?php echo $otCreditAmtRents ?></td> 
                    <td><?php echo $otDebitAmtRents  ?></td>                      
                    <td><?php echo $otCreditAmtRents - $otDebitAmtRents ?></td>  
                  </tr>  
                  <tr>
                    <th>Salaries</th>
                    <td><?php echo $otCreditAmtSal ?></td> 
                    <td><?php echo $otDebitAmtSal  ?></td>                      
                    <td><?php echo $otCreditAmtSal - $otDebitAmtSal ?></td>  
                  </tr> 
                  <tr>
                    <th>Scholarship</th>
                    <td><?php echo $otCreditAmtSchol ?></td> 
                    <td><?php echo $otDebitAmtSchol  ?></td>                      
                    <td><?php echo $otCreditAmtSchol - $otDebitAmtSchol ?></td>  
                  </tr> 
                  <tr>
                    <th>Uniform Dress</th>
                    <td><?php echo $otCreditAmtUD ?></td> 
                    <td><?php echo $otDebitAmtUD  ?></td>                      
                    <td><?php echo $otCreditAmtUD - $otDebitAmtUD ?></td>  
                  </tr> 
                  <tr>
                    <th>VARTANA LAND FINANCE</th>
                    <td><?php echo $otCreditAmtVLF ?></td> 
                    <td><?php echo $otDebitAmtVLF  ?></td>                      
                    <td><?php echo $otCreditAmtVLF - $otDebitAmtVLF ?></td>  
                  </tr>
                  <tr>
                    <th>UNRECORDED</th>
                    <td><?php echo $otCreditAmtUNREC ?></td> 
                    <td><?php echo $otDebitAmtUNREC  ?></td>                      
                    <td><?php echo $otCreditAmtUNREC - $otDebitAmtUNREC ?></td>  
                  </tr> 
                  <tr style="background-color:yellow; color: red;">
                    <th>Total</th>
                    <td><?php $totalCreditOLDTOWN = $otCreditAmtDurgi + $otCreditAmtSPNAGAR + $otCreditAmtDegree + $otCreditAmtInter + $otCreditAmtAB + $otCreditAmtBills + $otCreditAmtBooks + $otCreditAmtBusFin + $otCreditAmtBusMain + $otCreditAmtBusOil + $otCreditAmtBVR + $otCreditAmtARR + $otCreditAmtEduFee + $otCreditAmtFamExp + $otCreditAmtGenMain + $otCreditAmtHdfc + $otCreditAmtIcici + $otCreditAmtOL + $otCreditAmtPCH + $otCreditAmtRM + $otCreditAmtRents + $otCreditAmtSal + $otCreditAmtSchol + $otCreditAmtUD + $otCreditAmtVLF +$otCreditAmtUNREC; echo $totalCreditOLDTOWN; 
                     ?></td> 
                    <td><?php $totalDebitOLDTOWN = $otDebitAmtDurgi + $otDebitAmtSPNAGAR + $otDebitAmtDegree + $otDebitAmtInter + $otDebitAmtAB + $otDebitAmtBills + $otDebitAmtBooks + $otDebitAmtBusFin + $otDebitAmtBusMain + $otDebitAmtBusOil + $otDebitAmtBVR + $otDebitAmtARR + $otDebitAmtEduFee + $otDebitAmtFamExp + $otDebitAmtGenMain + $otDebitAmtHdfc + $otDebitAmtIcici + $otDebitAmtOL + $otDebitAmtPCH + $otDebitAmtRM + $otDebitAmtRents + $otDebitAmtSal + $otDebitAmtSchol + $otDebitAmtUD + $otDebitAmtVLF + $otDebitAmtUNREC; echo $totalDebitOLDTOWN; ?></td>                      
                    <td><?php echo $totalCreditOLDTOWN - $totalDebitOLDTOWN ?></td>  
                  </tr>
                </tbody>
              </table> 
<div style="break-after:page"></div>

              <h3 style="color:green;text-decoration-style: solid;"> SP NAGAR </h3>
              <table class="table" style="width: 100%;">
                <thead>
                  <tr style="background-color: blue; color: white;"> 
                    <th>AREA</th>
                    <th>CREDIT</th>  
                    <th>DEBIT</th>
                    <th>BALANCE</th> 
                  </tr>
                </thead> 
                <tbody>
                  <tr style="color:red">
                    <th>Durgi</th>
                    <td><?php echo $spnCreditAmtDurgi ?></td> 
                    <td><?php echo $spnDebitAmtDurgi ?></td>                      
                    <td><?php echo $spnCreditAmtDurgi - $spnDebitAmtDurgi ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Old Town</th>
                    <td><?php echo $spnCreditAmtOLDTOWN ?></td> 
                    <td><?php echo $spnDebitAmtOLDTOWN ?></td>                      
                    <td><?php echo $spnCreditAmtOLDTOWN - $spnDebitAmtOLDTOWN ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Degree</th>
                    <td><?php echo $spnCreditAmtDegree ?></td> 
                    <td><?php echo $spnDebitAmtDegree ?></td>                      
                    <td><?php echo $spnCreditAmtDegree - $spnDebitAmtDegree ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Intermediate</th>
                    <td><?php echo $spnCreditAmtInter ?></td> 
                    <td><?php echo $spnDebitAmtInter ?></td>                      
                    <td><?php echo $spnCreditAmtInter - $spnDebitAmtInter ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>BV REDDY</th>
                    <td><?php echo $spnCreditAmtBVR ?></td> 
                    <td><?php echo $spnDebitAmtBVR  ?></td>                      
                    <td><?php echo $spnCreditAmtBVR - $spnDebitAmtBVR ?></td>  
                  </tr> 
                  <tr style="color:red">
                    <th>DR ARR</th>
                    <td><?php echo $spnCreditAmtARR ?></td> 
                    <td><?php echo $spnDebitAmtARR  ?></td>                      
                    <td><?php echo $spnCreditAmtARR - $spnDebitAmtARR ?></td>  
                  </tr>
                  <tr>
                    <th>Andhra/Union Bank</th>
                    <td><?php echo $spnCreditAmtAB ?></td> 
                    <td><?php echo $spnDebitAmtAB ?></td>                      
                    <td><?php echo $spnCreditAmtAB - $spnDebitAmtAB ?></td>  
                  </tr> 
                  <tr>
                    <th>Bills</th>
                    <td><?php echo $spnCreditAmtBills ?></td> 
                    <td><?php echo $spnDebitAmtBills ?></td>                      
                    <td><?php echo $spnCreditAmtBills - $spnDebitAmtBills ?></td>  
                  </tr>  
                  <tr>
                    <th>Books</th>
                    <td><?php echo $spnCreditAmtBooks ?></td> 
                    <td><?php echo $spnDebitAmtBooks ?></td>                      
                    <td><?php echo $spnCreditAmtBooks - $spnDebitAmtBooks ?></td>  
                  </tr>  
                  <tr>
                    <th>Bus Finance</th>
                    <td><?php echo $spnCreditAmtBusFin ?></td> 
                    <td><?php echo $spnDebitAmtBusFin  ?></td>                      
                    <td><?php echo $spnCreditAmtBusFin - $spnDebitAmtBusFin ?></td>  
                  </tr>   
                  <tr>
                    <th>Bus Maintenance</th>
                    <td><?php echo $spnCreditAmtBusMain ?></td> 
                    <td><?php echo $spnDebitAmtBusMain  ?></td>                      
                    <td><?php echo $spnCreditAmtBusMain - $spnDebitAmtBusMain ?></td>  
                  </tr>    
                  <tr>
                    <th>Bus Oil</th>
                    <td><?php echo $spnCreditAmtBusOil ?></td> 
                    <td><?php echo $spnDebitAmtBusOil  ?></td>                      
                    <td><?php echo $spnCreditAmtBusOil - $spnDebitAmtBusOil ?></td>  
                  </tr>   
                  <tr>
                    <th>Educational Fee</th>
                    <td><?php echo $spnCreditAmtEduFee ?></td> 
                    <td><?php echo $spnDebitAmtEduFee  ?></td>                      
                    <td><?php echo $spnCreditAmtEduFee - $spnDebitAmtEduFee ?></td>  
                  </tr>  
                  <tr>
                    <th>Family Exp</th>
                    <td><?php echo $spnCreditAmtFamExp ?></td> 
                    <td><?php echo $spnDebitAmtFamExp  ?></td>                      
                    <td><?php echo $spnCreditAmtFamExp - $spnDebitAmtFamExp ?></td>  
                  </tr>   
                  <tr>
                    <th>GENERAL MAINTENANCE</th>
                    <td><?php echo $spnCreditAmtGenMain ?></td> 
                    <td><?php echo $spnDebitAmtGenMain  ?></td>                      
                    <td><?php echo $spnCreditAmtGenMain - $spnDebitAmtGenMain ?></td>  
                  </tr>  
                  <tr>
                    <th>HDFC BANK</th>
                    <td><?php echo $spnCreditAmtHdfc ?></td> 
                    <td><?php echo $spnDebitAmtHdfc  ?></td>                      
                    <td><?php echo $spnCreditAmtHdfc - $spnDebitAmtHdfc ?></td>  
                  </tr>  
                  <tr>
                    <th>ICICI BANK</th>
                    <td><?php echo $spnCreditAmtIcici ?></td> 
                    <td><?php echo $spnDebitAmtIcici  ?></td>                      
                    <td><?php echo $spnCreditAmtIcici - $spnDebitAmtIcici ?></td>  
                  </tr> 
                  <tr>
                    <th>OTHER LOANS</th>
                    <td><?php echo $spnCreditAmtOL ?></td> 
                    <td><?php echo $spnDebitAmtOL  ?></td>                      
                    <td><?php echo $spnCreditAmtOL - $spnDebitAmtOL ?></td>  
                  </tr> 
                  <tr>
                    <th>Pragathi Crops Hyd</th>
                    <td><?php echo $spnCreditAmtPCH ?></td> 
                    <td><?php echo $spnDebitAmtPCH  ?></td>                      
                    <td><?php echo $spnCreditAmtPCH - $spnDebitAmtPCH ?></td>  
                  </tr> 
                  <tr>
                    <th>Remodiling</th>
                    <td><?php echo $spnCreditAmtRM ?></td> 
                    <td><?php echo $spnDebitAmtRM  ?></td>                      
                    <td><?php echo $spnCreditAmtRM - $spnDebitAmtRM ?></td>  
                  </tr>  
                  <tr>
                    <th>Rents</th>
                    <td><?php echo $spnCreditAmtRents ?></td> 
                    <td><?php echo $spnDebitAmtRents  ?></td>                      
                    <td><?php echo $spnCreditAmtRents - $spnDebitAmtRents ?></td>  
                  </tr>  
                  <tr>
                    <th>Salaries</th>
                    <td><?php echo $spnCreditAmtSal ?></td> 
                    <td><?php echo $spnDebitAmtSal  ?></td>                      
                    <td><?php echo $spnCreditAmtSal - $spnDebitAmtSal ?></td>  
                  </tr> 
                  <tr>
                    <th>Scholarship</th>
                    <td><?php echo $spnCreditAmtSchol ?></td> 
                    <td><?php echo $spnDebitAmtSchol  ?></td>                      
                    <td><?php echo $spnCreditAmtSchol - $spnDebitAmtSchol ?></td>  
                  </tr> 
                  <tr>
                    <th>Uniform Dress</th>
                    <td><?php echo $spnCreditAmtUD ?></td> 
                    <td><?php echo $spnDebitAmtUD  ?></td>                      
                    <td><?php echo $spnCreditAmtUD - $spnDebitAmtUD ?></td>  
                  </tr> 
                  <tr>
                    <th>VARTANA LAND FINANCE</th>
                    <td><?php echo $spnCreditAmtVLF ?></td> 
                    <td><?php echo $spnDebitAmtVLF  ?></td>                      
                    <td><?php echo $spnCreditAmtVLF - $spnDebitAmtVLF ?></td>  
                  </tr> 
                  <tr>
                    <th>UNRECORDED</th>
                    <td><?php echo $spnCreditAmtUNREC ?></td> 
                    <td><?php echo $spnDebitAmtUNREC  ?></td>                      
                    <td><?php echo $spnCreditAmtUNREC - $spnDebitAmtUNREC ?></td>  
                  </tr> 
                  <tr style="background-color:yellow; color: red;">
                    <th>Total</th>
                    <td><?php $totalCreditSPNAGAR = $spnCreditAmtDurgi + $spnCreditAmtOLDTOWN + $spnCreditAmtDegree + $spnCreditAmtInter + $spnCreditAmtAB + $spnCreditAmtBills + $spnCreditAmtBooks + $spnCreditAmtBusFin + $spnCreditAmtBusMain + $spnCreditAmtBusOil + $spnCreditAmtBVR + $spnCreditAmtARR + $spnCreditAmtEduFee + $spnCreditAmtFamExp + $spnCreditAmtGenMain + $spnCreditAmtHdfc + $spnCreditAmtIcici + $spnCreditAmtOL + $spnCreditAmtPCH + $spnCreditAmtRM + $spnCreditAmtRents + $spnCreditAmtSal + $spnCreditAmtSchol + $spnCreditAmtUD + $spnCreditAmtVLF +$spnCreditAmtUNREC; echo $totalCreditSPNAGAR; 
                     ?></td> 
                    <td><?php $totalDebitSPNAGAR = $spnDebitAmtDurgi + $spnDebitAmtOLDTOWN + $spnDebitAmtDegree + $spnDebitAmtInter + $spnDebitAmtAB + $spnDebitAmtBills + $spnDebitAmtBooks + $spnDebitAmtBusFin + $spnDebitAmtBusMain + $spnDebitAmtBusOil + $spnDebitAmtBVR + $spnDebitAmtARR + $spnDebitAmtEduFee + $spnDebitAmtFamExp + $spnDebitAmtGenMain + $spnDebitAmtHdfc + $spnDebitAmtIcici + $spnDebitAmtOL + $spnDebitAmtPCH + $spnDebitAmtRM + $spnDebitAmtRents + $spnDebitAmtSal + $spnDebitAmtSchol + $spnDebitAmtUD + $spnDebitAmtVLF + $spnDebitAmtUNREC; echo $totalDebitSPNAGAR; ?></td>                      
                    <td><?php echo $totalCreditSPNAGAR - $totalDebitSPNAGAR ?></td>  
                  </tr>
                </tbody>
              </table> 
<div style="break-after:page"></div> 


              <h3 style="color:green;text-decoration-style: solid;"> DURGI </h3>
              <table class="table" style="width: 100%;">
                <thead>
                  <tr style="background-color: blue; color: white;"> 
                    <th>AREA</th>
                    <th>CREDIT</th>  
                    <th>DEBIT</th>
                    <th>BALANCE</th> 
                  </tr>
                </thead> 
                <tbody>
                  <tr style="color:red">
                    <th>SP Nagar</th>
                    <td><?php echo $durgiCreditAmtSPNAGAR ?></td> 
                    <td><?php echo $durgiDebitAmtSPNAGAR ?></td>                      
                    <td><?php echo $durgiCreditAmtSPNAGAR - $durgiDebitAmtSPNAGAR ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Old Town</th>
                    <td><?php echo $durgiCreditAmtOLDTOWN ?></td> 
                    <td><?php echo $durgiDebitAmtOLDTOWN?></td>                      
                    <td><?php echo $durgiCreditAmtOLDTOWN - $durgiDebitAmtOLDTOWN ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Degree</th>
                    <td><?php echo $durgiCreditAmtDegree ?></td> 
                    <td><?php echo $durgiDebitAmtDegree ?></td>                      
                    <td><?php echo $durgiCreditAmtDegree - $durgiDebitAmtDegree ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Intermediate</th>
                    <td><?php echo $durgiCreditAmtInter ?></td> 
                    <td><?php echo $durgiDebitAmtInter ?></td>                      
                    <td><?php echo $durgiCreditAmtInter - $durgiDebitAmtInter ?></td>  
                  </tr> 

                  <tr style="color:red">
                    <th>BV REDDY</th>
                    <td><?php echo $durgiCreditAmtBVR ?></td> 
                    <td><?php echo $durgiDebitAmtBVR  ?></td>                      
                    <td><?php echo $durgiCreditAmtBVR - $durgiDebitAmtBVR ?></td>  
                  </tr> 
                  <tr style="color:red">
                    <th>DR ARR</th>
                    <td><?php echo $durgiCreditAmtARR ?></td> 
                    <td><?php echo $durgiDebitAmtARR  ?></td>                      
                    <td><?php echo $durgiCreditAmtARR - $durgiDebitAmtARR ?></td>  
                  </tr>  
                  <tr>
                    <th>Andhra/Union Bank</th>
                    <td><?php echo $durgiCreditAmtAB ?></td> 
                    <td><?php echo $durgiDebitAmtAB ?></td>                      
                    <td><?php echo $durgiCreditAmtAB - $durgiDebitAmtAB ?></td>  
                  </tr> 
                  <tr>
                    <th>Bills</th>
                    <td><?php echo $durgiCreditAmtBills ?></td> 
                    <td><?php echo $durgiDebitAmtBills ?></td>                      
                    <td><?php echo $durgiCreditAmtBills - $durgiDebitAmtBills ?></td>  
                  </tr>  
                  <tr>
                    <th>Books</th>
                    <td><?php echo $durgiCreditAmtBooks ?></td> 
                    <td><?php echo $durgiDebitAmtBooks ?></td>                      
                    <td><?php echo $durgiCreditAmtBooks - $durgiDebitAmtBooks ?></td>  
                  </tr>  
                  <tr>
                    <th>Bus Finance</th>
                    <td><?php echo $durgiCreditAmtBusFin ?></td> 
                    <td><?php echo $durgiDebitAmtBusFin  ?></td>                      
                    <td><?php echo $durgiCreditAmtBusFin - $durgiDebitAmtBusFin ?></td>  
                  </tr>   
                  <tr>
                    <th>Bus Maintenance</th>
                    <td><?php echo $durgiCreditAmtBusMain ?></td> 
                    <td><?php echo $durgiDebitAmtBusMain  ?></td>                      
                    <td><?php echo $durgiCreditAmtBusMain - $durgiDebitAmtBusMain ?></td>  
                  </tr>    
                  <tr>
                    <th>Bus Oil</th>
                    <td><?php echo $durgiCreditAmtBusOil ?></td> 
                    <td><?php echo $durgiDebitAmtBusOil  ?></td>                      
                    <td><?php echo $durgiCreditAmtBusOil - $durgiDebitAmtBusOil ?></td>  
                  </tr>  
                  <tr>
                    <th>Educational Fee</th>
                    <td><?php echo $durgiCreditAmtEduFee ?></td> 
                    <td><?php echo $durgiDebitAmtEduFee  ?></td>                      
                    <td><?php echo $durgiCreditAmtEduFee - $durgiDebitAmtEduFee ?></td>  
                  </tr>  
                  <tr>
                    <th>Family Exp</th>
                    <td><?php echo $durgiCreditAmtFamExp ?></td> 
                    <td><?php echo $durgiDebitAmtFamExp  ?></td>                      
                    <td><?php echo $durgiCreditAmtFamExp - $durgiDebitAmtFamExp ?></td>  
                  </tr>   
                  <tr>
                    <th>GENERAL MAINTENANCE</th>
                    <td><?php echo $durgiCreditAmtGenMain ?></td> 
                    <td><?php echo $durgiDebitAmtGenMain  ?></td>                      
                    <td><?php echo $durgiCreditAmtGenMain - $durgiDebitAmtGenMain ?></td>  
                  </tr>  
                  <tr>
                    <th>HDFC BANK</th>
                    <td><?php echo $durgiCreditAmtHdfc ?></td> 
                    <td><?php echo $durgiDebitAmtHdfc  ?></td>                      
                    <td><?php echo $durgiCreditAmtHdfc - $durgiDebitAmtHdfc ?></td>  
                  </tr>  
                  <tr>
                    <th>ICICI BANK</th>
                    <td><?php echo $durgiCreditAmtIcici ?></td> 
                    <td><?php echo $durgiDebitAmtIcici  ?></td>                      
                    <td><?php echo $durgiCreditAmtIcici - $durgiDebitAmtIcici ?></td>  
                  </tr> 
                  <tr>
                    <th>OTHER LOANS</th>
                    <td><?php echo $durgiCreditAmtOL ?></td> 
                    <td><?php echo $durgiDebitAmtOL  ?></td>                      
                    <td><?php echo $durgiCreditAmtOL - $durgiDebitAmtOL ?></td>  
                  </tr> 
                  <tr>
                    <th>Pragathi Crops Hyd</th>
                    <td><?php echo $durgiCreditAmtPCH ?></td> 
                    <td><?php echo $durgiDebitAmtPCH  ?></td>                      
                    <td><?php echo $durgiCreditAmtPCH - $durgiDebitAmtPCH ?></td>  
                  </tr> 
                  <tr>
                    <th>Remodiling</th>
                    <td><?php echo $durgiCreditAmtRM ?></td> 
                    <td><?php echo $durgiDebitAmtRM  ?></td>                      
                    <td><?php echo $durgiCreditAmtRM - $durgiDebitAmtRM ?></td>  
                  </tr>  
                  <tr>
                    <th>Rents</th>
                    <td><?php echo $durgiCreditAmtRents ?></td> 
                    <td><?php echo $durgiDebitAmtRents  ?></td>                      
                    <td><?php echo $durgiCreditAmtRents - $durgiDebitAmtRents ?></td>  
                  </tr>  
                  <tr>
                    <th>Salaries</th>
                    <td><?php echo $durgiCreditAmtSal ?></td> 
                    <td><?php echo $durgiDebitAmtSal  ?></td>                      
                    <td><?php echo $durgiCreditAmtSal - $durgiDebitAmtSal ?></td>  
                  </tr> 
                  <tr>
                    <th>Scholarship</th>
                    <td><?php echo $durgiCreditAmtSchol ?></td> 
                    <td><?php echo $durgiDebitAmtSchol  ?></td>                      
                    <td><?php echo $durgiCreditAmtSchol - $durgiDebitAmtSchol ?></td>  
                  </tr> 
                  <tr>
                    <th>Uniform Dress</th>
                    <td><?php echo $durgiCreditAmtUD ?></td> 
                    <td><?php echo $durgiDebitAmtUD  ?></td>                      
                    <td><?php echo $durgiCreditAmtUD - $durgiDebitAmtUD ?></td>  
                  </tr> 
                  <tr>
                    <th>VARTANA LAND FINANCE</th>
                    <td><?php echo $durgiCreditAmtVLF ?></td> 
                    <td><?php echo $durgiDebitAmtVLF  ?></td>                      
                    <td><?php echo $durgiCreditAmtVLF - $durgiDebitAmtVLF ?></td>  
                  </tr> 
                  <tr>
                    <th>UNRECORDED</th>
                    <td><?php echo $durgiCreditAmtUNREC ?></td> 
                    <td><?php echo $durgiDebitAmtUNREC  ?></td>                      
                    <td><?php echo $durgiCreditAmtUNREC - $durgiDebitAmtUNREC ?></td>  
                  </tr>  
                  <tr style="background-color:yellow; color: red;">
                    <th>Total</th>
                    <td><?php $totalCreditDurgi = $durgiCreditAmtDurgi + $durgiCreditAmtSPNAGAR + $durgiCreditAmtDegree + $durgiCreditAmtInter + $durgiCreditAmtAB + $durgiCreditAmtBills + $durgiCreditAmtBooks + $durgiCreditAmtBusFin + $durgiCreditAmtBusMain + $durgiCreditAmtBusOil + $durgiCreditAmtBVR + $durgiCreditAmtARR + $durgiCreditAmtEduFee + $durgiCreditAmtFamExp + $durgiCreditAmtGenMain + $durgiCreditAmtHdfc + $durgiCreditAmtIcici + $durgiCreditAmtOL + $durgiCreditAmtPCH + $durgiCreditAmtRM + $durgiCreditAmtRents + $durgiCreditAmtSal + $durgiCreditAmtSchol + $durgiCreditAmtUD + $durgiCreditAmtVLF +$durgiCreditAmtUNREC; echo $totalCreditDurgi; 
                     ?></td> 
                    <td><?php $totalDebitDurgi = $durgiDebitAmtDurgi + $durgiDebitAmtSPNAGAR + $durgiDebitAmtDegree + $durgiDebitAmtInter + $durgiDebitAmtAB + $durgiDebitAmtBills + $durgiDebitAmtBooks + $durgiDebitAmtBusFin + $durgiDebitAmtBusMain + $durgiDebitAmtBusOil + $durgiDebitAmtBVR + $durgiDebitAmtARR + $durgiDebitAmtEduFee + $durgiDebitAmtFamExp + $durgiDebitAmtGenMain + $durgiDebitAmtHdfc + $durgiDebitAmtIcici + $durgiDebitAmtOL + $durgiDebitAmtPCH + $durgiDebitAmtRM + $durgiDebitAmtRents + $durgiDebitAmtSal + $durgiDebitAmtSchol + $durgiDebitAmtUD + $durgiDebitAmtVLF + $durgiDebitAmtUNREC; echo $totalDebitDurgi; ?></td>                    
                    <td><?php echo $totalCreditDurgi - $totalDebitDurgi ?></td>  
                  </tr>
                </tbody>
              </table> 
<div style="break-after:page"></div> 

              <h3 style="color:green;text-decoration-style: solid;"> DEGREE </h3>
              <table class="table" style="width: 100%;">
                <thead>
                  <tr style="background-color: blue; color: white;"> 
                    <th>AREA</th>
                    <th>CREDIT</th>  
                    <th>DEBIT</th>
                    <th>BALANCE</th> 
                  </tr>
                </thead> 
                <tbody>
                  <tr style="color:red">
                    <th>Old Town</th>
                    <td><?php echo $degreeCreditAmtOLDTOWN ?></td> 
                    <td><?php echo $degreeDebitAmtOLDTOWN ?></td>                      
                    <td><?php echo $degreeCreditAmtOLDTOWN - $degreeDebitAmtOLDTOWN ?></td> 
                  </tr>  
                  <tr style="color:red">
                    <th>SP Nagar</th>
                    <td><?php echo $degreeCreditAmtSPNAGAR ?></td> 
                    <td><?php echo $degreeDebitAmtSPNAGAR ?></td>                      
                    <td><?php echo $degreeCreditAmtSPNAGAR - $degreeDebitAmtSPNAGAR ?></td> 
                  </tr>  
                  <tr style="color:red">
                    <th>Durgi</th>
                    <td><?php echo $degreeCreditAmtDurgi ?></td> 
                    <td><?php echo $degreeDebitAmtDurgi ?></td>                      
                    <td><?php echo $degreeCreditAmtDurgi - $degreeDebitAmtDurgi ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Intermediate</th>
                    <td><?php echo $degreeCreditAmtInter ?></td> 
                    <td><?php echo $degreeDebitAmtInter ?></td>                      
                    <td><?php echo $degreeCreditAmtInter - $degreeDebitAmtInter ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>BV REDDY</th>
                    <td><?php echo $degreeCreditAmtBVR ?></td> 
                    <td><?php echo $degreeDebitAmtBVR  ?></td>                      
                    <td><?php echo $degreeCreditAmtBVR - $degreeDebitAmtBVR ?></td>  
                  </tr>
                  <tr style="color:red">
                    <th>DR ARR</th>
                    <td><?php echo $degreeCreditAmtARR ?></td> 
                    <td><?php echo $degreeDebitAmtARR  ?></td>                      
                    <td><?php echo $degreeCreditAmtARR - $degreeDebitAmtARR ?></td>  
                  </tr>  
                  <tr>
                    <th>Andhra/Union Bank</th>
                    <td><?php echo $degreeCreditAmtAB ?></td> 
                    <td><?php echo $degreeDebitAmtAB ?></td>                      
                    <td><?php echo $degreeCreditAmtAB - $degreeDebitAmtAB ?></td>  
                  </tr> 
                  <tr>
                    <th>Bills</th>
                    <td><?php echo $degreeCreditAmtBills ?></td> 
                    <td><?php echo $degreeDebitAmtBills ?></td>                      
                    <td><?php echo $degreeCreditAmtBills - $degreeDebitAmtBills ?></td>  
                  </tr>  
                  <tr>
                    <th>Books</th>
                    <td><?php echo $degreeCreditAmtBooks ?></td> 
                    <td><?php echo $degreeDebitAmtBooks ?></td>                      
                    <td><?php echo $degreeCreditAmtBooks - $degreeDebitAmtBooks ?></td>  
                  </tr>  
                  <tr>
                    <th>Bus Finance</th>
                    <td><?php echo $degreeCreditAmtBusFin ?></td> 
                    <td><?php echo $degreeDebitAmtBusFin  ?></td>                      
                    <td><?php echo $degreeCreditAmtBusFin - $degreeDebitAmtBusFin ?></td>  
                  </tr>   
                  <tr>
                    <th>Bus Maintenance</th>
                    <td><?php echo $degreeCreditAmtBusMain ?></td> 
                    <td><?php echo $degreeDebitAmtBusMain  ?></td>                      
                    <td><?php echo $degreeCreditAmtBusMain - $degreeDebitAmtBusMain ?></td>  
                  </tr>    
                  <tr>
                    <th>Bus Oil</th>
                    <td><?php echo $degreeCreditAmtBusOil ?></td> 
                    <td><?php echo $degreeDebitAmtBusOil  ?></td>                      
                    <td><?php echo $degreeCreditAmtBusOil - $degreeDebitAmtBusOil ?></td>  
                  </tr>  
                  <tr>
                    <th>Educational Fee</th>
                    <td><?php echo $degreeCreditAmtEduFee ?></td> 
                    <td><?php echo $degreeDebitAmtEduFee  ?></td>                      
                    <td><?php echo $degreeCreditAmtEduFee - $degreeDebitAmtEduFee ?></td>  
                  </tr>  
                  <tr>
                    <th>Family Exp</th>
                    <td><?php echo $degreeCreditAmtFamExp ?></td> 
                    <td><?php echo $degreeDebitAmtFamExp  ?></td>                      
                    <td><?php echo $degreeCreditAmtFamExp - $degreeDebitAmtFamExp ?></td>  
                  </tr>   
                  <tr>
                    <th>GENERAL MAINTENANCE</th>
                    <td><?php echo $degreeCreditAmtGenMain ?></td> 
                    <td><?php echo $degreeDebitAmtGenMain  ?></td>                      
                    <td><?php echo $degreeCreditAmtGenMain - $degreeDebitAmtGenMain ?></td>  
                  </tr>  
                  <tr>
                    <th>HDFC BANK</th>
                    <td><?php echo $degreeCreditAmtHdfc ?></td> 
                    <td><?php echo $degreeDebitAmtHdfc  ?></td>                      
                    <td><?php echo $degreeCreditAmtHdfc - $degreeDebitAmtHdfc ?></td>  
                  </tr>  
                  <tr>
                    <th>ICICI BANK</th>
                    <td><?php echo $degreeCreditAmtIcici ?></td> 
                    <td><?php echo $degreeDebitAmtIcici  ?></td>                      
                    <td><?php echo $degreeCreditAmtIcici - $degreeDebitAmtIcici ?></td>  
                  </tr> 
                  <tr>
                    <th>OTHER LOANS</th>
                    <td><?php echo $degreeCreditAmtOL ?></td> 
                    <td><?php echo $degreeDebitAmtOL  ?></td>                      
                    <td><?php echo $degreeCreditAmtOL - $degreeDebitAmtOL ?></td>  
                  </tr> 
                  <tr>
                    <th>Pragathi Crops Hyd</th>
                    <td><?php echo $degreeCreditAmtPCH ?></td> 
                    <td><?php echo $degreeDebitAmtPCH  ?></td>                      
                    <td><?php echo $degreeCreditAmtPCH - $degreeDebitAmtPCH ?></td>  
                  </tr> 
                  <tr>
                    <th>Remodiling</th>
                    <td><?php echo $degreeCreditAmtRM ?></td> 
                    <td><?php echo $degreeDebitAmtRM  ?></td>                      
                    <td><?php echo $degreeCreditAmtRM - $degreeDebitAmtRM ?></td>  
                  </tr>  
                  <tr>
                    <th>Rents</th>
                    <td><?php echo $degreeCreditAmtRents ?></td> 
                    <td><?php echo $degreeDebitAmtRents  ?></td>                      
                    <td><?php echo $degreeCreditAmtRents - $degreeDebitAmtRents ?></td>  
                  </tr>  
                  <tr>
                    <th>Salaries</th>
                    <td><?php echo $degreeCreditAmtSal ?></td> 
                    <td><?php echo $degreeDebitAmtSal  ?></td>                      
                    <td><?php echo $degreeCreditAmtSal - $degreeDebitAmtSal ?></td>  
                  </tr> 
                  <tr>
                    <th>Scholarship</th>
                    <td><?php echo $degreeCreditAmtSchol ?></td> 
                    <td><?php echo $degreeDebitAmtSchol  ?></td>                      
                    <td><?php echo $degreeCreditAmtSchol - $degreeDebitAmtSchol ?></td>  
                  </tr> 
                  <tr>
                    <th>Uniform Dress</th>
                    <td><?php echo $degreeCreditAmtUD ?></td> 
                    <td><?php echo $degreeDebitAmtUD  ?></td>                      
                    <td><?php echo $degreeCreditAmtUD - $degreeDebitAmtUD ?></td>  
                  </tr> 
                  <tr>
                    <th>VARTANA LAND FINANCE</th>
                    <td><?php echo $degreeCreditAmtVLF ?></td> 
                    <td><?php echo $degreeDebitAmtVLF  ?></td>                      
                    <td><?php echo $degreeCreditAmtVLF - $degreeDebitAmtVLF ?></td>  
                  </tr>  

                  <tr>
                    <th>UNRECORDED</th>
                    <td><?php echo $degreeCreditAmtUNREC ?></td> 
                    <td><?php echo $degreeDebitAmtUNREC  ?></td>                      
                    <td><?php echo $degreeCreditAmtUNREC - $degreeDebitAmtUNREC ?></td>  
                  </tr> 
                  <tr style="background-color:yellow; color: red;">
                    <th>Total</th>
                    <td><?php $totalCreditDegree = $degreeCreditAmtDurgi + $degreeCreditAmtSPNAGAR + $degreeCreditAmtOLDTOWN + $degreeCreditAmtInter + $degreeCreditAmtAB + $degreeCreditAmtBills + $degreeCreditAmtBooks + $degreeCreditAmtBusFin + $degreeCreditAmtBusMain + $degreeCreditAmtBusOil + $degreeCreditAmtBVR + $degreeCreditAmtARR + $degreeCreditAmtEduFee + $degreeCreditAmtFamExp + $degreeCreditAmtGenMain + $degreeCreditAmtHdfc + $degreeCreditAmtIcici + $degreeCreditAmtOL + $degreeCreditAmtPCH + $degreeCreditAmtRM + $degreeCreditAmtRents + $degreeCreditAmtSal + $degreeCreditAmtSchol + $degreeCreditAmtUD + $degreeCreditAmtVLF + $degreeCreditAmtUNREC; echo $totalCreditDegree; 
                     ?></td> 
                    <td><?php $totalDebitDegree = $degreeDebitAmtDurgi + $degreeDebitAmtSPNAGAR + $degreeDebitAmtOLDTOWN + $degreeDebitAmtInter + $degreeDebitAmtAB + $degreeDebitAmtBills + $degreeDebitAmtBooks + $degreeDebitAmtBusFin + $degreeDebitAmtBusMain + $degreeDebitAmtBusOil + $degreeDebitAmtBVR + $degreeDebitAmtARR + $degreeDebitAmtEduFee + $degreeDebitAmtFamExp + $degreeDebitAmtGenMain + $degreeDebitAmtHdfc + $degreeDebitAmtIcici + $degreeDebitAmtOL + $degreeDebitAmtPCH + $degreeDebitAmtRM + $degreeDebitAmtRents + $degreeDebitAmtSal + $degreeDebitAmtSchol + $degreeDebitAmtUD + $degreeDebitAmtVLF + $degreeDebitAmtUNREC; echo $totalDebitDegree; ?></td>
                    <td><?php echo $totalCreditDegree - $totalDebitDegree ?></td> 
                  </tr>
                </tbody>
              </table> 
<div style="break-after:page"></div> 

<h3 style="color:green;text-decoration-style: solid;"> INTERMEDIATE </h3>
              <table class="table" style="width: 100%;">
                <thead>
                  <tr style="background-color: blue; color: white;"> 
                    <th>AREA</th>
                    <th>CREDIT</th>  
                    <th>DEBIT</th>
                    <th>BALANCE</th> 
                  </tr>
                </thead> 
                <tbody>
                  <tr style="color:red">
                    <th>Old Town</th>
                    <td><?php echo $interCreditAmtOLDTOWN ?></td> 
                    <td><?php echo $interDebitAmtOLDTOWN ?></td>                      
                    <td><?php echo $interCreditAmtOLDTOWN - $interDebitAmtOLDTOWN ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>SP Nagar</th>
                    <td><?php echo $interCreditAmtSPNAGAR ?></td> 
                    <td><?php echo $interDebitAmtSPNAGAR ?></td>                      
                    <td><?php echo $interCreditAmtSPNAGAR - $interDebitAmtSPNAGAR ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Durgi</th>
                    <td><?php echo $interCreditAmtDurgi ?></td> 
                    <td><?php echo $interDebitAmtDurgi ?></td>                      
                    <td><?php echo $interCreditAmtDurgi - $interDebitAmtDurgi ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Degree</th>
                    <td><?php echo $interCreditAmtDegree ?></td> 
                    <td><?php echo $interDebitAmtDegree  ?></td>                      
                    <td><?php echo $interCreditAmtDegree  - $interDebitAmtDegree  ?></td>  
                  </tr>                     
                  <tr style="color:red">
                    <th>BV REDDY</th>
                    <td><?php echo $interCreditAmtBVR ?></td> 
                    <td><?php echo $interDebitAmtBVR  ?></td>                      
                    <td><?php echo $interCreditAmtBVR - $interDebitAmtBVR ?></td>  
                  </tr> 
                  <tr style="color:red">
                    <th>DR ARR</th>
                    <td><?php echo $interCreditAmtARR ?></td> 
                    <td><?php echo $interDebitAmtARR  ?></td>                      
                    <td><?php echo $interCreditAmtARR - $interDebitAmtARR ?></td>  
                  </tr> 
                  <tr>
                    <th>Andhra/Union Bank</th>
                    <td><?php echo $interCreditAmtAB ?></td> 
                    <td><?php echo $interDebitAmtAB ?></td>                      
                    <td><?php echo $interCreditAmtAB - $interDebitAmtAB ?></td>  
                  </tr> 
                  <tr>
                    <th>Bills</th>
                    <td><?php echo $interCreditAmtBills ?></td> 
                    <td><?php echo $interDebitAmtBills ?></td>                      
                    <td><?php echo $interCreditAmtBills - $interDebitAmtBills ?></td>  
                  </tr>  
                  <tr>
                    <th>Books</th>
                    <td><?php echo $interCreditAmtBooks ?></td> 
                    <td><?php echo $interDebitAmtBooks ?></td>                      
                    <td><?php echo $interCreditAmtBooks - $interDebitAmtBooks ?></td>  
                  </tr>  
                  <tr>
                    <th>Bus Finance</th>
                    <td><?php echo $interCreditAmtBusFin ?></td> 
                    <td><?php echo $interDebitAmtBusFin  ?></td>                      
                    <td><?php echo $interCreditAmtBusFin - $interDebitAmtBusFin ?></td>  
                  </tr>   
                  <tr>
                    <th>Bus Maintenance</th>
                    <td><?php echo $interCreditAmtBusMain ?></td> 
                    <td><?php echo $interDebitAmtBusMain  ?></td>                      
                    <td><?php echo $interCreditAmtBusMain - $interDebitAmtBusMain ?></td>  
                  </tr>    
                  <tr>
                    <th>Bus Oil</th>
                    <td><?php echo $interCreditAmtBusOil ?></td> 
                    <td><?php echo $interDebitAmtBusOil  ?></td>                      
                    <td><?php echo $interCreditAmtBusOil - $interDebitAmtBusOil ?></td>  
                  </tr>   
                  <tr>
                    <th>Educational Fee</th>
                    <td><?php echo $interCreditAmtEduFee ?></td> 
                    <td><?php echo $interDebitAmtEduFee  ?></td>                      
                    <td><?php echo $interCreditAmtEduFee - $interDebitAmtEduFee ?></td>  
                  </tr>  
                  <tr>
                    <th>Family Exp</th>
                    <td><?php echo $interCreditAmtFamExp ?></td> 
                    <td><?php echo $interDebitAmtFamExp  ?></td>                      
                    <td><?php echo $interCreditAmtFamExp - $interDebitAmtFamExp ?></td>  
                  </tr>   
                  <tr>
                    <th>GENERAL MAINTENANCE</th>
                    <td><?php echo $interCreditAmtGenMain ?></td> 
                    <td><?php echo $interDebitAmtGenMain  ?></td>                      
                    <td><?php echo $interCreditAmtGenMain - $interDebitAmtGenMain ?></td>  
                  </tr>  
                  <tr>
                    <th>HDFC BANK</th>
                    <td><?php echo $interCreditAmtHdfc ?></td> 
                    <td><?php echo $interDebitAmtHdfc  ?></td>                      
                    <td><?php echo $interCreditAmtHdfc - $interDebitAmtHdfc ?></td>  
                  </tr>  
                  <tr>
                    <th>ICICI BANK</th>
                    <td><?php echo $interCreditAmtIcici ?></td> 
                    <td><?php echo $interDebitAmtIcici  ?></td>                      
                    <td><?php echo $interCreditAmtIcici - $interDebitAmtIcici ?></td>  
                  </tr> 
                  <tr>
                    <th>OTHER LOANS</th>
                    <td><?php echo $interCreditAmtOL ?></td> 
                    <td><?php echo $interDebitAmtOL  ?></td>                      
                    <td><?php echo $interCreditAmtOL - $interDebitAmtOL ?></td>  
                  </tr> 
                  <tr>
                    <th>Pragathi Crops Hyd</th>
                    <td><?php echo $interCreditAmtPCH ?></td> 
                    <td><?php echo $interDebitAmtPCH  ?></td>                      
                    <td><?php echo $interCreditAmtPCH - $interDebitAmtPCH ?></td>  
                  </tr> 
                  <tr>
                    <th>Remodiling</th>
                    <td><?php echo $interCreditAmtRM ?></td> 
                    <td><?php echo $interDebitAmtRM  ?></td>                      
                    <td><?php echo $interCreditAmtRM - $interDebitAmtRM ?></td>  
                  </tr>  
                  <tr>
                    <th>Rents</th>
                    <td><?php echo $interCreditAmtRents ?></td> 
                    <td><?php echo $interDebitAmtRents  ?></td>                      
                    <td><?php echo $interCreditAmtRents - $interDebitAmtRents ?></td>  
                  </tr>  
                  <tr>
                    <th>Salaries</th>
                    <td><?php echo $interCreditAmtSal ?></td> 
                    <td><?php echo $interDebitAmtSal  ?></td>                      
                    <td><?php echo $interCreditAmtSal - $interDebitAmtSal ?></td>  
                  </tr> 
                  <tr>
                    <th>Scholarship</th>
                    <td><?php echo $interCreditAmtSchol ?></td> 
                    <td><?php echo $interDebitAmtSchol  ?></td>                      
                    <td><?php echo $interCreditAmtSchol - $interDebitAmtSchol ?></td>  
                  </tr> 
                  <tr>
                    <th>Uniform Dress</th>
                    <td><?php echo $interCreditAmtUD ?></td> 
                    <td><?php echo $interDebitAmtUD  ?></td>                      
                    <td><?php echo $interCreditAmtUD - $interDebitAmtUD ?></td>  
                  </tr> 
                  <tr>
                    <th>VARTANA LAND FINANCE</th>
                    <td><?php echo $interCreditAmtVLF ?></td> 
                    <td><?php echo $interDebitAmtVLF  ?></td>                      
                    <td><?php echo $interCreditAmtVLF - $interDebitAmtVLF ?></td>  
                  </tr>   

                  <tr>
                    <th>UNRECORDED</th>
                    <td><?php echo $interCreditAmtUNREC ?></td> 
                    <td><?php echo $interDebitAmtUNREC  ?></td>                      
                    <td><?php echo $interCreditAmtUNREC - $interDebitAmtUNREC ?></td>  
                  </tr> 
                  <tr style="background-color:yellow; color: red;">
                    <th>Total</th>
                    <td><?php $totalCreditInter = $interCreditAmtDurgi + $interCreditAmtSPNAGAR + $interCreditAmtDegree + $interCreditAmtOLDTOWN + $interCreditAmtAB + $interCreditAmtBills + $interCreditAmtBooks + $interCreditAmtBusFin + $interCreditAmtBusMain + $interCreditAmtBusOil + $interCreditAmtBVR + $interCreditAmtARR + $interCreditAmtEduFee + $interCreditAmtFamExp + $interCreditAmtGenMain + $interCreditAmtHdfc + $interCreditAmtIcici + $interCreditAmtOL + $interCreditAmtPCH + $interCreditAmtRM + $interCreditAmtRents + $interCreditAmtSal + $interCreditAmtSchol + $interCreditAmtUD + $interCreditAmtVLF + $interCreditAmtUNREC; echo $totalCreditInter; 
                     ?></td> 
                    <td><?php $totalDebitInter = $interDebitAmtDurgi + $interDebitAmtSPNAGAR + $interDebitAmtDegree + $interDebitAmtOLDTOWN + $interDebitAmtAB + $interDebitAmtBills + $interDebitAmtBooks + $interDebitAmtBusFin + $interDebitAmtBusMain + $interDebitAmtBusOil + $interDebitAmtBVR + $interDebitAmtARR + $interDebitAmtEduFee + $interDebitAmtFamExp + $interDebitAmtGenMain + $interDebitAmtHdfc + $interDebitAmtIcici + $interDebitAmtOL + $interDebitAmtPCH + $interDebitAmtRM + $interDebitAmtRents + $interDebitAmtSal + $interDebitAmtSchol + $interDebitAmtUD + $interDebitAmtVLF + $interDebitAmtUNREC; echo $totalDebitInter; ?></td>                     
                    <td><?php echo $totalCreditInter - $totalDebitInter ?></td>  
                  </tr>
                </tbody>
              </table> 
<div style="break-after:page"></div> 






<h3 style="color:green;text-decoration-style: solid;"> TOTAL BALANCESHEET </h3>
              <table class="table" style="width: 100%;">
                <thead>
                  <tr style="background-color: blue; color: white;"> 
                    <th>AREA</th>
                    <th>CREDIT</th>  
                    <th>DEBIT</th>
                    <th>BALANCE</th> 
                  </tr>
                </thead> 
                <tbody>
                  <tr style="color:red">
                    <th>Old Town</th>
                    <td><?php echo $totalCreditAmtOLDTOWN ?></td> 
                    <td><?php echo $totalDebitAmtOLDTOWN ?></td>                      
                    <td><?php echo $totalCreditAmtOLDTOWN - $totalDebitAmtOLDTOWN ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>SP Nagar</th>
                    <td><?php echo $totalCreditAmtSPNAGAR ?></td> 
                    <td><?php echo $totalDebitAmtSPNAGAR ?></td>                      
                    <td><?php echo $totalCreditAmtSPNAGAR - $totalDebitAmtSPNAGAR ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Durgi</th>
                    <td><?php echo $totalCreditAmtDurgi ?></td> 
                    <td><?php echo $totalDebitAmtDurgi ?></td>                      
                    <td><?php echo $totalCreditAmtDurgi - $totalDebitAmtDurgi ?></td>  
                  </tr>  
                  <tr style="color:red">
                    <th>Intermediate</th>
                    <td><?php echo $totalCreditAmtInter ?></td> 
                    <td><?php echo $totalDebitAmtInter  ?></td>                      
                    <td><?php echo $totalCreditAmtInter - $totalDebitAmtInter ?></td>  
                  </tr>      
                  <tr style="color:red">
                    <th>Degree</th>
                    <td><?php echo $totalCreditAmtDegree ?></td> 
                    <td><?php echo $totalDebitAmtDegree ?></td>                      
                    <td><?php echo $totalCreditAmtDegree - $totalDebitAmtDegree ?></td>  
                  </tr>      
                  <tr style="color:red">
                    <th>BANK STATEMENTS</th>
                    <td><?php echo $totalCreditAmtBS ?></td> 
                    <td><?php echo $totalDebitAmtBS ?></td>                      
                    <td><?php echo $totalCreditAmtBS - $totalDebitAmtBS ?></td>  
                  </tr>
                  <tr style="background-color:yellow; color: red;">
                    <th>Total</th>
                    <td><?php $totalCreditAll = $totalCreditAmtDurgi + $totalCreditAmtSPNAGAR + $totalCreditAmtDegree + $totalCreditAmtInter + $totalCreditAmtOLDTOWN + $totalCreditAmtBS; echo $totalCreditAll; 
                     ?></td> 
                    <td><?php $totalDebitAll = $totalDebitAmtDurgi + $totalDebitAmtSPNAGAR + $totalDebitAmtDegree + $totalDebitAmtInter + $totalDebitAmtOLDTOWN + $totalDebitAmtBS; echo $totalDebitAll; ?></td>                     
                    <td><?php echo $totalCreditAll - $totalDebitAll ?></td>  
                  </tr>
                </tbody>
              </table> 

            </div>
          </div>
        </div>
      </div>
    </section>

  </main> 

  <?php include('include/footer.php'); ?>