<?php include('parent/callMe.php');?>

<?php include('Sessioncheck.php');?>

<?php 



//getting branch details 



  $m->where("branch_id", $_SESSION['branch']);

  $branch_details = $m->get("edu_branch_config");





$branch=getBranch($m);



$month_id=$_REQUEST['month'];

$monthid=date("m");

$branchID=$_SESSION['branch'];

$year=$_REQUESTe['year'];



$m->where("Month_Id", $month_id);

$month_name=$m->get("eduportal_month_config");



$sql = " select std.student_id, std.first_name, std.last_name, std.candidate_roll_no, std.section_id, std.ref_no, std.class_id, std.dob, std.section_id, std.cell_no, fee.* from  edu_student_details as std, eduportal_monthly_challan as fee where std.student_id=fee.student_id AND std.status='0' AND fee.month_id='$month_id' AND std.branch_id=".$_SESSION['branch'];



if($_REQUEST['class_id']!=NULL) { 



if ($_REQUEST['year']!=NULL) {

    $sql .= " AND fee.year =" . $_REQUEST['year']. " ";

}



if ($_REQUEST['class_id']!=NULL){

    $sql .= " AND fee.classs_id =" . $_REQUEST['class_id']. " ";

}



if($_REQUEST['section']=="All"){

      $sql;

    } else {

    $sql .= " AND std.section_id =" . $_REQUEST['section']. " ";



    }



  if($_REQUEST['fee']=="All"){

   // continue;  

  } 



  else {

   $sql .= " AND fee.paid_status = '" .$_REQUEST['fee']. "' ";

    }



 

$WorkAssignListings = $m->query($sql);



} else {



    $sql =" select std.student_id, std.first_name, std.last_name, std.candidate_roll_no, std.section_id, std.ref_no, std.class_id, std.dob, std.section_id, std.cell_no, fee.* from  edu_student_details as std, eduportal_monthly_challan as fee where std.student_id=fee.student_id AND std.status='0' AND fee.month_id='$monthid' AND std.branch_id='$branchID' AND fee.year='$year' order by fee.classs_id asc";



 $WorkAssignListings = $m->query($sql); 

}



//print_r($sql);

$total_fee;

?>

 <!DOCTYPE HTML>

<html>

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<!-- Favicons-->

<link rel="icon" type="image/png" href="img/favicon.png" sizes="32x32" />

<title>Print Voucher</title>

<!-- Favicons-->

<link rel="icon" type="image/png" href="img/favicon.png" sizes="32x32" />

<script type="text/javascript">

 //window.print();

</script>

<style> 



.section{width:95%; height:auto;float:left;border-right: 2px solid black;border-right-style:dotted;padding-right:2.5%;margin-left:2%;}

.box{

  width:48%;float:left;height:18cm;padding:0.5%;

}  

   

tr th {background-color:gray; text-align:center;font-size:14px;border:1px solid gray;}

tr td {border-bottom:1px solid gray;border-left:1px solid gray;padding:1%;}





@media print{@page {size: landscape}}

  </style>



</head>

<body>



<?php 

$WorkAssignValue=$WorkAssignListings;



$divission =count($WorkAssignValue);

 $DivideByTwo=$divission/2;

$counter=0;



$fee_fine=0;



// loop just printing the number of pages 



for($k=0;$k<$DivideByTwo;$k++){



  $fee_fine;

  

  if(date("Y-m-d")>$WorkAssignValue[$counter]['challan_duedate']){



    $fee_fine=$branch[0]['late_fee_fine'];



   }

   else {



  $fee_fine=0;



   }

















?>



<page size="A4">





    <?php 

    for ($i=1; $i<=2 ; $i++) {





  $total_fee=$WorkAssignValue[$counter]['balance']+$WorkAssignValue[$counter]['tutionfee']+$WorkAssignValue[$counter]['transportfee']+$WorkAssignValue[$counter]['misc_fee']+ $other_fees + $fee_fine;



/*  if($total_fee==0 ){

    continue;

  }*/





 $m->where("student_id", $WorkAssignValue[$counter]['student_id']);

 $discount=$m->get("eduportal_student_fee_structure");



 // $m->where("session_id", $WorkAssignValue[$counter]['session_id']);

 // $sessionName=$m->get("edu_session_config");



     ?>



        

<div class="box" >



<div class="section" style="<?php if($i==2){echo 'border-right:none;';}?>">

   

   <div style="width:100%; text-align:center; height:auto;font-size:12px;">

            <?php echo $array1[$i];?>



   </div>





  <div style="">

        

        <div style="width: 15%;float: left;">

            <img src="<?php echo DOMAIN.AgentDirectory;?>img/<?php echo $branch[0]['logo']; ?>" style="height:60px;width:60px;" />    

        </div>

        <div style="width:85%;font-size:17px;float: right;margin-top: 25px;text-align:center;"><?php echo $branch[0]['Branch_Name'];?></div>



      </div>

<div style="font-size:11px; text-align:center;"><?php echo $branch[0]['Branch_Location'];?></div>

<br>

     <div style="width:33%; font-size:10px;text-align:left; height:25px; float:left;">



         Month : <?php echo $month_name[0]['Month_Name'];?>



   </div>



   <div style="width:33%; font-size:10px;text-align:center; height:25px; float:left;">



         Adm : <?php echo $WorkAssignValue[$counter]['ref_no'];?>



   </div>





   <div style="width:33%;font-size:10px; text-align:right; height:25px; float:left;">



        Due Date <?php echo date("d-M-Y",strtotime($WorkAssignValue[$counter]['challan_duedate']));?>



   </div>





<?php 



    $start_date = strtotime($WorkAssignValue[$counter]['challan_duedate']); 

    $end_date = strtotime(date("Y-m-d"));

    $datediffrence =($end_date - $start_date)/60/60/24;



    $student_fine=0;

    $actual_fine=0;



//echo $start_date;



  

   if($branch_details[0]['fine_type']=="0" || $branch_details[0]['fine_type']==0){  



    $student_fine= $branch_details[0]['late_fee_fine']; } 



  else {

    

    $student_fine= ($datediffrence * $branch_details[0]['late_fee_fine']);

   }





  //if(date("Y-m-d")>$details['challan_duedate'] && $details['paid_status']==1){



// if row is first 



  



        // if row is first and fee is paid then show only collected fine

          if($WorkAssignValue[$counter]['paid_status']==1){

             $WorkAssignValue[$counter]['collected_fine'];

             $actual_fine=$WorkAssignValue[$counter]['collected_fine'];

           

          } 

        // if row is first and fee is not paid then calculate fine

          else if(date("Y-m-d")>$WorkAssignValue[$counter]['challan_duedate'] && $WorkAssignValue[$counter]['paid_status']==0){

           // echo $student_fine; 

            $actual_fine=$student_fine;

          }

      

 

    





    $totalAmount1+=$actual_fine;



        ?> 





   <table width="100%" style="font-size:11px;margin-top: 2%;" cellspacing="0">  

   

   

      <tr>  

         <td width="10%" style="border:none;"> Name   </td>

         <td width="40%" style="border-bottom: 1px solid black;text-align:center;border-left:none;">  <?php echo $WorkAssignValue[$counter]['first_name'];?>  </td>

         

         <td width="10%" style="border:none;"> Father   </td>

         <td width="40%" style="border-bottom: 1px solid black;text-align:center;border-left:none;">  <?php echo $WorkAssignValue[$counter]['last_name'];?>  </td>



      </tr>

 

    

  <tr>  

     <td width="10%" style="border:none;"> Class </td>

     <td width="40%" style="border-bottom: 1px solid black;text-align:center;border-left:none;">  <?php 

      if($_REQUEST['class_id']!=NULL) {

     echo getClassName($m,$_GET['class_id']);

       } else {

     echo getClassName($m,$WorkAssignValue[$counter]['class_id']);

       }?>

     </td>

     

     <td width="10%" style="border:none;"> Section  </td>

     <td width="40%" style="border-bottom: 1px solid black;text-align:center;border-left:none;">  <?php echo getSectionName($m,$WorkAssignValue[$counter]['section_id']);?>  </td>



  </tr>



  

       

  <tr>  



   

     <td width="10%" style="border:none;">  Roll#  </td>

     <td width="40%" style="border-bottom: 1px solid black;text-align:center;border-left:none;">  <?php echo $WorkAssignValue[$counter]['candidate_roll_no'];?>  </td>



     <td width="10%" style="border:none;">  Year  </td>

     <td width="40%" style="border-bottom: 1px solid black;text-align:center;border-left:none;">  <?php echo $_GET['year'];?>

      </td>

  

  </tr>



     

      



   

   </table>





   <table width="100%" style="font-size:11px;margin-top:2%;" cellspacing="0">  

   



      <tr>  

         <th width="70%"> Particulars    </td>

         <th width="30%" style="text-align:center;border-right:1px solid gray;">  Amount </td>

      </tr>



      <!-- <tr style="background-color: lightgray;">  

         <td width="70%"> Standard Fee   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  <?php 

           

          $m->where("class_id", $WorkAssignValue[$counter]['classs_id']);

          $class_fee = $m->get("eduportal_class_fee_details");

          $class_standerd_fee=$class_fee[0]['tution_fee'];

          echo $class_standerd_fee;

          ?> </td>

      </tr> -->





      <tr>  

         <td width="70%"> Arrears   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  <?php echo $WorkAssignValue[$counter]['balance'];?> </td>

      </tr>

      

         

      <tr>  

         <td width="70%"> Monthly Fee   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  <?php echo $WorkAssignValue[$counter]['tutionfee'];?>  </td>

      </tr>

   <?php if($WorkAssignValue[$counter]['transportfee']>0){ ?>

      <tr>  

         <td width="70%"> Transport Fee   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  <?php echo $WorkAssignValue[$counter]['transportfee'];?>  </td>

      </tr>

    <?php } ?>

    <?php if($WorkAssignValue[$counter]['misc_fee']>0){ ?>

      <tr>  

         <td width="70%"> <?php if ($branch[0]['misc_title']!=NULL){echo $branch[0]['misc_title'];}else {echo 'Miscellaneous';} ?>  </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  <?php echo $WorkAssignValue[$counter]['misc_fee'];?>  </td>

      </tr>

    <?php } ?>



   <?php 



      $fee_types = $m->get("eduportal_fee_types");

      $other_fees=0;

      foreach ($fee_types as $type) {

        $fees=getFeeOfOtherParameter($WorkAssignValue[$counter]['student_id'],$WorkAssignValue[$counter]['challan_id'],$type['feetype_id'],$m);

       if($fees!=""){

   ?>

     <tr>  

         <td width="70%"> <?php echo $type['feetype_name']; ?>   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;"> 

          <?php 

          $other_fees+=$fees;

          echo $fees;  ?> </td>

      </tr>



    <?php } else  continue; } 



    /*  $fee_fine;

      if(date("Y-m-d")>$WorkAssignValue[$counter]['challan_duedate']){



      $fee_fine=$branch[0]['late_fee_fine'];

       }

       else {



      $fee_fine=0;



   }*/ ?>

        

<!-- <?php if($actual_fine>0){ ?>

      <tr>  

         <td width="70%"> Fine   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  

         

               <?php  echo $actual_fine;?>

  

         

           </td>

      </tr>



    <?php } ?>  -->



<?php if($WorkAssignValue[$counter]['disc_amount']>0){ ?>

      <tr>  

         <td width="70%"> Fee Discount   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">

  <?php  



  echo ($WorkAssignValue[$counter]['disc_amount']/$WorkAssignValue[$counter]['tutionfee']*100)."% (".$WorkAssignValue[$counter]['disc_amount'].")";?>        

           </td>

      </tr>

<?php } ?>



      <tr>  

         <th width="70%" style="text-align:left;"> Total   </th>

         <th width="30%" style="text-align:center;">  <?php echo  $WorkAssignValue[$counter]['balance']+$WorkAssignValue[$counter]['tutionfee']+$WorkAssignValue[$counter]['transportfee']+$WorkAssignValue[$counter]['misc_fee']+ $other_fees -$WorkAssignValue[$counter]['disc_amount']; ?> 

        </th>

      </tr>





           

      

     <!--  <tr>  

         <td width="70%" style="text-align:right;padding-top:3%;"> Before Due Date:   </td>

         <td width="30%" style="text-align:center;padding-top:3%;border-right:1px solid gray;">  

            <?php echo number_format($WorkAssignValue[$counter]['balance']+$WorkAssignValue[$counter]['tutionfee']+$WorkAssignValue[$counter]['transportfee']+$WorkAssignValue[$counter]['misc_fee']+ $other_fees-$WorkAssignValue[$counter]['disc_amount'],2); ?>  </td>

      </tr> -->

   

      <?php  if($branch[0]['fine_type']=="0" || $branch[0]['fine_type']==0){  ?> 

       <tr>  

         <td width="70%" style="text-align:right;">  Late Fee Fine:   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;">  <?php echo $student_fine;?> </td>

      </tr>

    <?php } ?>



      <?php  if($branch[0]['fine_type']=="0" || $branch[0]['fine_type']==0){  ?> 

   

      <tr>  

         <td width="70%" style="text-align:right;"> After Due Date:   </td>

         <td width="30%" style="text-align:center;border-right:1px solid gray;"> 

          <?php echo  $WorkAssignValue[$counter]['balance']+$WorkAssignValue[$counter]['tutionfee']+$WorkAssignValue[$counter]['transportfee']+$WorkAssignValue[$counter]['misc_fee']+ $other_fees+$student_fine -$WorkAssignValue[$counter]['disc_amount']; ?> </td>

      </tr>

<?php  } else { ?>



       <tr>  

         <td width="100%" colspan="2" style="text-align:left;border-right: 1px solid gray;"><b> After due date <?php echo $actual_fine?> Rs fine will be charged per day.</b></td>

        

      </tr>

 <?php }  ?>



<?php  if($WorkAssignValue[$counter]['paid_status']==1) {  ?>

      <tr>  

         <th width="10%" style="text-align:left;"> Fee Paid (<?php echo  $WorkAssignValue[$counter]['collected_amount']+$WorkAssignValue[$counter]['collected_fine']; ?> ) at (<?php echo date("d-M-Y",strtotime($WorkAssignValue[$counter]['paying_date'])); ?>)  </th>

         <th width="20%" style="text-align:center;"> Rem:  <?php echo  $total_fee+$other_fees-$WorkAssignValue[$counter]['collected_amount']-$WorkAssignValue[$counter]['collected_fine']; ?> 

        </th>



         <!-- <th width="10%" style="text-align:left;"> Remaining   </th>

         <th width="20%" style="text-align:left;">  <?php echo $total_fee-$WorkAssignValue[$counter]['collected_amount']; ?>  </th>

         -->







      </tr>

    <?php } ?>

   







        <?php 



          $m->where("class_id", $WorkAssignValue[$counter]['classs_id']);

          $m->where("year", $_REQUEST['year']);

          $class_fee = $m->get("eduportal_class_fee_details");

          $class_standerd_fee=$class_fee[0]['tution_fee'];



        $discount_amount = $class_standerd_fee - $WorkAssignValue[$counter]['tutionfee'];?>

<?php if($WorkAssignValue[$counter]['disc_amount']!=""){ ?>

       <tr>  

         <td colspan="2" width="100%" style="text-align:left;border-right: 1px solid gray;"><b>Discount:- 

            <?php echo number_format(($discount_amount/$class_standerd_fee)*100,0); ?> % (Rs: <?php echo $discount_amount;?>) Reason:- </b> (<?php echo $discount[0]['discount_reason'];?>)</td>

      </tr>

<?php } ?>

 

   </table>





   <?php if ($WorkAssignValue[$counter]['fee_remarks']!=NULL) { ?>

    <p style="margin: 1px; border: 1px solid black;padding-left: 2px;font-size: 11px;"> Fee Remarks: <?php echo $WorkAssignValue[$counter]['fee_remarks'];?></p>

    <?php } ?>

    <p style="text-align:center;margin: 3px;">Student Fee History</p>





   <table class="table "cellspacing="0"  style="width:100%;">



    <thead>

            

    <tr>

    <th style="background: lightgray;font-size:11px;" width="2%">Month</th>

        <?php

         

      for ($mm=1; $mm<=12; $mm++) { 

//echo $mm;

        $monthss = date('F', mktime(0,0,0,$mm, 1, date('Y')));

        ?>



       <th style="background: lightgray;font-size:11px;" width="2%" class=" center"><?php echo substr($monthss, 0, 3);?></th>



        <?php } ?>

        </tr>  





        <tr>

        <th style="background: white;font-size:11px;" width="2%">Total</th>

       <?php for ($mm=1; $mm<=12; $mm++) {



$stdid=$WorkAssignValue[$counter]['student_id'];

$bal = "select chl.tutionfee, chl.transportfee, chl.balance, chl.misc_fee, chl.disc_amount, SUM(dtil.fee_amount) as amt from eduportal_monthly_challan as chl LEFT JOIN eduportal_monthly_challan_details as dtil ON chl.challan_id=dtil.challan_id where chl.student_id='$stdid' AND chl.month_id='$mm' AND chl.year='$year' AND chl.branch_id=".$_SESSION['branch']; 

//echo $bal; 

  $monthlyTotal = $m->query($bal);







$total_MonthlyFee=$monthlyTotal[0]['tutionfee']+$monthlyTotal[0]['transportfee']+$monthlyTotal[0]['balance']+$monthlyTotal[0]['misc_fee']+$monthlyTotal[0]['amt']-$monthlyTotal[0]['disc_amount'];



?>

<th style="background: white;font-size:11px;" width="2%" class=" center"><?php echo $total_MonthlyFee;?></th>

<?php } ?>



    </tr>



    <tr>



    <th style="background: white;font-size:11px;" width="2%">Recev</th>

    <?php for ($mm=1; $mm<=12; $mm++) { 



$stdid=$WorkAssignValue[$counter]['student_id'];

$bal = "select collected_amount, collected_fine, paid_again_amount from eduportal_monthly_challan where student_id='$stdid' AND month_id='$mm' AND year='$year' AND branch_id=".$_SESSION['branch'];  

  $monthlyTotal = $m->query($bal);

$totalMonthlyRecev=$monthlyTotal[0]['collected_amount']+$monthlyTotal[0]['paid_again_amount']; 

    ?>

    <th style="background: white;font-size:11px;" width="2%" class=" center"><?php echo $totalMonthlyRecev;?></th>

<?php } ?>



    </tr>  

    </thead>

   </table>

  <br>

  <p style="font-size:11px;text-align: center; margin: 1px;">

  <?php if($branch[0]['fee_vouc_note']!=NULL){



          echo $branch[0]['fee_vouc_note'];

        ?>

      

      <?php }else { ?>

          Defaulters of two or more months will be expelled out. 

      <?php } ?>

    </p>



  <!-- <div style="width:100%;font-size:8px;text-align:center;"> <?php echo getPrintBottom($m);?>  </div>  --> 



</div>

 <br><br>

<!-- ending section  -->







  </div>  <!-- ending box  -->







 <?php 



 $counter++;

 $total_fee=0;

 





   } ?>



</page>



<?php } ?>



</body>

</html>

