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

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

<?php 



  //getting branch details 

 // $m->where("session_id", $_SESSION['current_session'];

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

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





  $branch=getBranch($m);

  $branchID=$_SESSION['branch'];



  $month_id=$_GET['month_id'];



  $sql = " select std.*, 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']." AND fee.student_id=".$_REQUEST['student_id'];





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

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

}



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

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

}



  //echo $sql;



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



// now getting the other fee parameters of student against selected month

$fee_fine;



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

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

 }

 else {

$fee_fine=0;

 }





  $start_date = strtotime($WorkAssignListings[0]['challan_duedate']);

  if ($WorkAssignListings[0]['paid_status']=='1') {

  $end_date = strtotime($WorkAssignListings[0]['paying_date']);

  

   } else {

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

  }

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



    $student_fine=0;

    $actual_fine=0;





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

    



  

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



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



  else {

    

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

   }



}







$total_fee=intVal($WorkAssignListings[0]['tutionfee'])+intVal($WorkAssignListings[0]['transportfee'])+intVal($WorkAssignListings[0]['balance'])+intVal($WorkAssignListings[0]['misc_fee']-$WorkAssignListings[0]['disc_amount']);



// print_r($challan); 



  

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

  $m->where("class_id", $WorkAssignListings[0]['class_id']);

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

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





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

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


  $year=$_REQUEST['year'];



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

  $signatures = $m->get("eduportal_upload_acadmic_signature");



?>

 <!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;padding-right:2.5%;margin-left:2%;}

.box{

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

} 

     

tr th {background-color:gray; text-align:center;font-size:16px;border:1px solid black;padding:1%;}

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

.tdalign{text-align:center;border:1px solid black;}

body {

  background: rgb(204,204,204);

  font-weight:bold; 

}

page {

  background: white;

  display: block;

  margin: 0 auto;

  margin-bottom: 0.5cm;

  border:1px solid black;

  box-shadow: 0 0 0.5cm rgba(0,0,0,0.5);

  /*padding:1%;*/

  height: 21cm; 

}

page[size="A4"] {  

  width: 21cm;

  height: 29.7cm; 

}

page[size="A4"][layout="landscape"] {

  width: 29.7cm;

  height: 21cm;  

}

page[size="A3"] {

  width: 29.7cm;

  height: 42cm;

}

page[size="A3"][layout="landscape"] {

  width: 42cm;

  height: 29.7cm;  

}

page[size="A5"] {

  width: 14.8cm;

  height: 21cm;

}

page[size="A5"][layout="landscape"] {

  width: 21cm;

  height: 14.8cm;  

}

@media print {

  body, page {

    margin: 0;

    box-shadow: none;

    border:none;

  }

}



@media print {

    #Header, #Footer { display: none !important; }

}

@media screen

   {

      p.bodyText {font-family:verdana, arial, sans-serif;}

   }



   @media print

   {

      p.bodyText {font-family:georgia, times, serif;}

   }

   @media screen, print

   {

      p.bodyText {font-size:10pt}

   }

   @media print {

  a[href]:after {

    content: none !important;

  }

}

</style>

</head>

<body>

  <page size="A4">

<?php



 $array1=array("Student Copy");



 for($i=0; $i<1;$i++){ ?>



<div class="box" >

 <!-- Vouchere Fist -->

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

   

   <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:80px;width:70px;" />    

        </div>

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



      </div>

      <br><br>

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

       <div style="font-size:12px; text-align:center;">  Contact: <?php echo $branch[0]['branch_contact'];?><br> <span style="text-align:right;margin-left: 47px;">Issue date: <?php echo date('d-M-Y');?></span></div>



   <hr>

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



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



   </div>



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



         <span style="border: 1px solid black;padding: 3px; text-align: center;"> Adm No : <?php echo $WorkAssignListings[0]['ref_no'];?></span>



   </div>





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



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



   </div>







   <table width="100%" style="font-size:14px;" cellspacing="0">  

   

   

      <tr>  

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

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

      

         <td width="15%" style="border:none;"> F.Name:   </td>

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



      </tr>





  

  

      <tr>  

         <td width="15%" style="border:none;"> Class (Sec):   </td>

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

         <?php echo getClassName($m,$WorkAssignListings[0]['class_id']);?>

          (<?php echo getSectionName($m,$WorkAssignListings[0]['section_id']);?>) </td>



          <?php if ($brid[0]['no_type']==1 || $brid[0]['no_type']==0) { ?>

                        

         <td width="15%" style="border:none;font-size: 12px;"> Comp No:   </td>

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

         <?php echo $WorkAssignListings[0]['candidate_roll_no'];?>  </td>



        <?php } elseif ($brid[0]['no_type']==2 || $brid[0]['no_type']==0) { ?>

            

         <td width="15%" style="border:none;font-size: 12px;"> Reg No:   </td>

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

         <?php echo $WorkAssignListings[0]['ref_no'];?>  </td>



        <?php } ?>

      </tr>









      <tr>  

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

         <td width="35%" style="border-bottom: 1px solid black;text-align:center;border-left:none;font-size: 12px;"> 

         <?php echo $_REQUEST['year'];?>  </td>

      

         <td width="15%" style="border:none;"> Voucher No:   </td>

         <td width="35%" style="border-bottom: 1px solid black;text-align:center;border-left:none;font-size:14px;">  

         <?php

         

         

         if($WorkAssignListings[0]['challan_id']!=NULL){echo $WorkAssignListings[0]['challan_id'];} ?>  </td>



      </tr>



 </table>









   <table width="100%" style="font-size:14px;margin-top:1%;" 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 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 $WorkAssignListings[0]['balance'];?> </td>

      </tr>

      

         

      <tr>  

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

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

      </tr>


<!-- scholarship adding -->


<?php 


$discount_amount = $class_standerd_fee - $WorkAssignListings[0]['tutionfee'];

if($discount_amount>0){ ?>

       <tr>  

         <td width="100%" style="text-align:left;border-right: 1px solid lightgray;"><b>Monthly Fee Scholarship:- <?php echo number_format(($discount_amount/$class_standerd_fee)*100,0); ?> % fee discount </b> (<?php echo $discount[0]['discount_reason'];?>) </td>
            
        <td width="30%" style="text-align:center;border-right:1px solid gray;"><?php echo $discount_amount;?></td>

      </tr>

<?php } ?>


<!-- scholarship added -->



<?php if($WorkAssignListings[0]['transportfee']>0 && $WorkAssignListings[0]['transportfee']!="0" ){ ?>

      <tr>  

         <td width="70%"> <?php if ($brid[0]['transport_title']!=NULL){echo $brid[0]['transport_title'];}else {echo 'Transport Fee';} ?>   </td>

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

      </tr>

<?php } ?>



<?php if($WorkAssignListings[0]['misc_fee']>0 && $WorkAssignListings[0]['misc_fee']!="0" || $WorkAssignListings[0]['misc_fee']<"0" ){ ?>

      <tr>  

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

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

      </tr>

<?php } ?>



   <?php 



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

      $other_fee=0;

      foreach ($fee_types as $type) {

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

      if($fees!="" && $fees!="0" ){



        $query11="SELECT * FROM eduportal_manage_fee_heads_details WHERE  branch_id='$branchID' and fee_head_id=".$type['feetype_id'];

        $feeHeads = $m->query($query11);

   ?>

     <tr>  

         <td width="70%"> <?php if ($feeHeads[0]['fee_head_title']!=NULL){echo $feeHeads[0]['fee_head_title'];}else {echo $type['feetype_name'];} ?>   </td>

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

          <?php 

          $other_fee+=$fees;

          echo $fees;  ?> </td>

      </tr>





    <?php } else continue; } ?>

 

 <?php if ($WorkAssignListings[0]['paid_status']==1) {

     $student_fine=$WorkAssignListings[0]['collected_fine'];

  } ?>       



<?php if($student_fine>0 && date("Y-m-d")>$WorkAssignListings[0]['challan_duedate']){ ?>

 

      <tr>  

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

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

         

               <?php  echo $student_fine;?>

  

         

           </td>

      </tr>

<?php } ?>

<!-- </?php if($WorkAssignListings[0]['disc_amount']>0){ ?>

        <tr>  

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

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

  </?php  



  $disc_amount=$WorkAssignListings[0]['disc_amount'];



  echo number_format(($WorkAssignListings[0]['disc_amount']/$WorkAssignListings[0]['tutionfee']*100),1)."% (".$WorkAssignListings[0]['disc_amount'].")";?>        

           </td>

      </tr>

   </?php } ?>  -->

      

      <tr>  

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

         <th width="30%" style="text-align:center;">  

          <?php echo number_format($other_fee+$total_fee+$student_fine,2); ?> </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($other_fee+$total_fee-$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 $branch[0]['late_fee_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 number_format($other_fee+$total_fee+$branch[0]['late_fee_fine'],2); ?> </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 $branch[0]['late_fee_fine']?> Rs fine will be charged per day.</b></td>

        

      </tr>

 <?php }  ?>

     






      

<?php  if($WorkAssignListings[0]['paid_status']==1 || $WorkAssignListings[0]['paid_status']=="1"){  ?> 

  

      <tr>  



         <th width="70%" style="text-align:right;">Paid at: <?php echo $WorkAssignListings[0]['paying_time']; ?>, <?php echo date("d-M-Y", strtotime($WorkAssignListings[0]['paying_date'])); ?>  |  Paid Amount: &nbsp;&nbsp;</th>

         <th width="30%" style="text-align:center;">  <?php echo number_format($WorkAssignListings[0]['collected_amount']+$WorkAssignListings[0]['collected_fine'],2); ?> </th>

      </tr>

<?php if ($WorkAssignListings[0]['paid_again_amount']!=NULL) { ?>

  



      <tr>  



         <th width="70%" style="text-align:right;">Paid at: <?php echo $WorkAssignListings[0]['paid_again_time']; ?>, <?php echo date("d-M-Y", strtotime($WorkAssignListings[0]['paid_again_date'])); ?>  |  Again Paid Amount: &nbsp;&nbsp;</th>

         <th width="30%" style="text-align:center;">  <?php echo number_format($WorkAssignListings[0]['paid_again_amount'],2); ?> </th>

      </tr>

      

  <?php } ?>

      <?php 



  if(date("Y-m-d",strtotime($WorkAssignListings[0]['paying_date'])) > $WorkAssignListings[0]['challan_duedate'] AND $WorkAssignListings[0]['collected_fine']!=0) { ?>



<tr>  

         <th width="70%" style="text-align:right;"> Remaining: &nbsp;&nbsp;  </th>

         <th width="30%" style="text-align:center; ">  <?php echo number_format(($other_fee+$total_fee+$student_fine)-$WorkAssignListings[0]['collected_amount']-$WorkAssignListings[0]['collected_fine']-$WorkAssignListings[0]['paid_again_amount'],2); ?> </th>

</tr>



 <?php } else { $totalRemaining = ($other_fee+$total_fee)-$WorkAssignListings[0]['collected_amount']-$WorkAssignListings[0]['collected_fine']-$WorkAssignListings[0]['paid_again_amount']; ?>



<tr>  

         <th width="70%" style="text-align:right;"><?php if ($totalRemaining<0) {

             echo "Advance:";

         } else { echo "Remaining:"; }?> &nbsp;&nbsp;  </th>

         <th width="30%" style="text-align:center; ">  <?php if ($totalRemaining<0) {

            $rem = ltrim($totalRemaining, '-');

          echo "Advance: ". number_format($rem,2);

          } else { echo number_format($totalRemaining,2);} ?> </th>

</tr>

 

      

     

<?php } }  ?>



    

   </table>





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

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

<?php } ?>



<?php if($branch[0]['hide_fee_history']==0) { ?>



   <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++) {



/*if (date("Y-m-d")>$WorkAssignListings[0]['challan_duedate']) {





$student_fineHistory;

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



$student_fineHistory= $branch[0]['late_fee_fine']; } 



else {



$student_fineHistory= ($datediffrence * $branch[0]['late_fee_fine']);

}



}*/



$stdid=$WorkAssignListings[0]['student_id'];

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

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



$adm=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],1,$m);

$papr=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],2,$m);

$lib=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],3,$m);

$lab=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],4,$m);

$othr=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],5,$m);

$regfee=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],6,$m);

$secufee=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],7,$m);

$anualfee=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],8,$m);

$BooksPack=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],9,$m);

$ProcessingFee=getFeeOfOtherParameter($monthlyTotal[0]['student_id'],$monthlyTotal[0]['challan_id'],10,$m);

$otherFee=$adm+$papr+$lib+$lab+$othr+$regfee+$secufee+$anualfee+$BooksPack+$ProcessingFee;



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



?>

<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=$WorkAssignListings[0]['student_id'];

$bal = "select * 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']+$monthlyTotal[0]['collected_fine']; 

    ?>

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

<?php } ?>



    </tr>  

    </thead>

   </table>



<?php } ?>



<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>



   <table width="100%" style="font-size:12px;" cellspacing="0">  

   

   

         <tr>  

         <td width="100%" colspan="2" style="text-align:center;border-left:none;"> <?php if($signatures[0]['principal_signature']!=NULL && $brid[0]['display_signature']==1){ ?>

                        

            <img src="<?php echo DOMAIN;?>Production/signatures/<?php echo $signatures[0]['principal_signature'];?>" id="preview" class="img-thumbnail" style="width:100px;height:55px;"   />



         <?php } ?>  </td>

         

         </tr>



         <tr>  

         <td width="100%" colspan="2" style="text-align:center;border:none;color:black;"> (Signature & Stamp) <br>

            

            <!-- <span style="font-size:11px;"> <?php echo getPrintBottom($m);?>  </span> -->



          </td>

         

         </tr>

   </table>



</div>





</div>

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



<?php } ?>

</page>

</body>

</html>

