<?php $currency_symbol = $this->customlib->getSchoolCurrencyFormat(); ?>
<style type="text/css">
    @media print {
        .col-sm-1, .col-sm-2, .col-sm-3, .col-sm-4, .col-sm-5, .col-sm-6, .col-sm-7, .col-sm-8, .col-sm-9, .col-sm-10, .col-sm-11, .col-sm-12 {
            float: left;
        }
        .col-sm-12 {
            width: 100%;
        }
        .col-sm-11 {
            width: 91.66666667%;
        }
        .col-sm-10 {
            width: 83.33333333%;
        }
        .col-sm-9 {
            width: 75%;
        }
        .col-sm-8 {
            width: 66.66666667%;
        }
        .col-sm-7 {
            width: 58.33333333%;
        }
        .col-sm-6 {
            width: 50%;
        }
        .col-sm-5 {
            width: 41.66666667%;
        }
        .col-sm-4 {
            width: 33.33333333%;
        }
        .col-sm-3 {
            width: 25%;
        }
        .col-sm-2 {
            width: 16.66666667%;
        }
        .col-sm-1 {
            width: 8.33333333%;
        }
        .col-sm-pull-12 {
            right: 100%;
        }
        .col-sm-pull-11 {
            right: 91.66666667%;
        }
        .col-sm-pull-10 {
            right: 83.33333333%;
        }
        .col-sm-pull-9 {
            right: 75%;
        }
        .col-sm-pull-8 {
            right: 66.66666667%;
        }
        .col-sm-pull-7 {
            right: 58.33333333%;
        }
        .col-sm-pull-6 {
            right: 50%;
        }
        .col-sm-pull-5 {
            right: 41.66666667%;
        }
        .col-sm-pull-4 {
            right: 33.33333333%;
        }
        .col-sm-pull-3 {
            right: 25%;
        }
        .col-sm-pull-2 {
            right: 16.66666667%;
        }
        .col-sm-pull-1 {
            right: 8.33333333%;
        }
        .col-sm-pull-0 {
            right: auto;
        }
        .col-sm-push-12 {
            left: 100%;
        }
        .col-sm-push-11 {
            left: 91.66666667%;
        }
        .col-sm-push-10 {
            left: 83.33333333%;
        }
        .col-sm-push-9 {
            left: 75%;
        }
        .col-sm-push-8 {
            left: 66.66666667%;
        }
        .col-sm-push-7 {
            left: 58.33333333%;
        }
        .col-sm-push-6 {
            left: 50%;
        }
        .col-sm-push-5 {
            left: 41.66666667%;
        }
        .col-sm-push-4 {
            left: 33.33333333%;
        }
        .col-sm-push-3 {
            left: 25%;
        }
        .col-sm-push-2 {
            left: 16.66666667%;
        }
        .col-sm-push-1 {
            left: 8.33333333%;
        }
        .col-sm-push-0 {
            left: auto;
        }
        .col-sm-offset-12 {
            margin-left: 100%;
        }
        .col-sm-offset-11 {
            margin-left: 91.66666667%;
        }
        .col-sm-offset-10 {
            margin-left: 83.33333333%;
        }
        .col-sm-offset-9 {
            margin-left: 75%;
        }
        .col-sm-offset-8 {
            margin-left: 66.66666667%;
        }
        .col-sm-offset-7 {
            margin-left: 58.33333333%;
        }
        .col-sm-offset-6 {
            margin-left: 50%;
        }
        .col-sm-offset-5 {
            margin-left: 41.66666667%;
        }
        .col-sm-offset-4 {
            margin-left: 33.33333333%;
        }
        .col-sm-offset-3 {
            margin-left: 25%;
        }
        .col-sm-offset-2 {
            margin-left: 16.66666667%;
        }
        .col-sm-offset-1 {
            margin-left: 8.33333333%;
        }
        .col-sm-offset-0 {
            margin-left: 0%;
        }
        .visible-xs {
            display: none !important;
        }
        .hidden-xs {
            display: block !important;
        }
        table.hidden-xs {
            display: table;
        }
        tr.hidden-xs {
            display: table-row !important;
        }
        th.hidden-xs,
        td.hidden-xs {
            display: table-cell !important;
        }
        .hidden-xs.hidden-print {
            display: none !important;
        }
        .hidden-sm {
            display: none !important;
        }
        .visible-sm {
            display: block !important;
        }
        table.visible-sm {
            display: table;
        }
        tr.visible-sm {
            display: table-row !important;
        }
        th.visible-sm,
        td.visible-sm {
            display: table-cell !important;
        }
    }
</style>

<html lang="en">
    <head>
        <title><?php echo $this->lang->line('fees_receipt'); ?></title>
        <link rel="stylesheet" href="<?php echo base_url(); ?>backend/bootstrap/css/bootstrap.min.css"> 
        <link rel="stylesheet" href="<?php echo base_url(); ?>backend/dist/css/AdminLTE.min.css">
    </head>
    <body> 
        <div class="container">

            <div class="row">

                <div id="content" class="col-lg-12 col-sm-12 ">
                    <div class="invoice">
                        <div class="row header text-center">
                            <div class="col-sm-12">
                                <?php
                                if ($settinglist[0]['image'] != "") {
                                    ?>

                                    <img style="height:70px; " src="<?php echo base_url(); ?>/uploads/school_content/logo/<?php echo $settinglist[0]['image']; ?>"> <br/>
                                    <?php
                                }
                                ?>

                                <strong style="font-size: 20px;"><?php echo $settinglist[0]['name']; ?></strong><br>
                                <?php echo $settinglist[0]['address']; ?><br>

                                <?php echo $this->lang->line('phone'); ?>: <?php echo $settinglist[0]['phone']; ?><br>

                            </div><!--/col-->
                        </div>
                        <div class="row">                           
                            <div class="col-xs-6">
                                <br/>
                                <address>
                                    <strong><?php 
																	$this->db->select('*');
																	$this->db->from('sections');
																	$this->db->where('id',$section_id);
																	$query112 = $this->db->get();
																	$result13 = $query112->row();
																	
																	$this->db->select('*');
																	$this->db->from('classes');
																	$this->db->where('id',$class_id);
																	$query12 = $this->db->get();
																	$result3 = $query12->row();
																	
									 ?></strong><br>                                  
                                    <?php echo $this->lang->line('class'); ?>: <?php echo $result3->class . " (" . $result13->section . ")"; ?>
                                </address>
                            </div>
                            <div class="col-xs-6 text-right">
                                <br/>
                                <address>
                                    <strong>Statement Period: <?php 
									     echo "FROM: ".$date_from2." TO: ".$date_to2?></strong><br/>                                    
										<strong style="color:blue;"><h4>LEARNER BALANCE FEES REPORT</h4></strong><br/>
										

                                </address>                               
                            </div>
                        </div>
                        <hr style="margin-top: 0px;margin-bottom: 0px;" />
                        <div class="row">
                            <?php
                            if (!empty($student_due_fee)) {
                                ?>
                                     <table class="table table-striped table-responsive" style="font-size: 8pt;">
                                        <thead>
                                            <tr>
                                                <th class="text text-left" width="5%">Date</th>
                                                <th class="text text-left" width="10%">Reference</th>
                                                <th class="text text-left" width="10%">Learner Name</th>
                                                <th class="text text-left" width="10%"><?php echo $this->lang->line('admission_no'); ?></th>                                           
                                                <th class="text text-right" width="10%"><?php echo $this->lang->line('discount'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>
                                                <th class="text text-right" width="10%"><?php echo $this->lang->line('fine'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>
                                                 <th class="text text-right" width="10%">Deposits</th>
												<th class="text text-right" width="10%">Payments</th>
                                                <th class="text-right" width="10%"><?php echo $this->lang->line('balance'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>
                                            </tr>
                                        </thead>  
                                        <tbody>   

                                            <?php
													$balance=0;
													$buffer =$balance;	
													$balance=$buffer;		
															$module = "Learner";																
															$this->db->select('*');
															$this->db->from('journal');
															$this->db->where('module = ', $module);
															$journal_results = $this->db->get();	
															
                                            $grd_total = 0;
                                            $grd_paid = 0;
                                            $grd_discount = 0;
                                            $grd_fine = 0;

											
                                            if (!empty($student_due_fee)) {
                                                foreach ($student_due_fee as $key => $student) {

                                                    if ($student->totalfee != "N/A") {

                                                        $grd_total = $grd_total + $student->totalfee;
                                                    }
                                                    if ($student->deposit != "N/A") {

                                                        $grd_paid = $grd_paid + $student->deposit;
                                                    }
                                                    if ($student->discount != "N/A") {

                                                        $grd_discount = $grd_discount + $student->discount;
                                                    }
                                                    if ($student->fine != "N/A") {

                                                        $grd_fine = $fine + $student->fine;
                                                    }
																												
													        $student_session_id = $student->student_session_id;																																							
															
															$this->db->select('*');
															$this->db->from('student_fees_master');
															$this->db->where('student_session_id',$student_session_id);
															//$this->db->where('fee_session_group_id ',$fee_groups_id );
															$query = $this->db->get();
															$result = $query->row();
															
															$invoice_number = $result->id;	
															$date_created = $result->created_at ;	
															
															$invoice_number_new = "INV" . sprintf('%04s', $invoice_number);
										      
																$this->db->select('*');
																$this->db->from('student_fees_deposite');
																$this->db->where('student_fees_master_id',$invoice_number);
																$query0 = $this->db->get();
																$result0 = $query0->row();
																
																$receipt_number  = $result0->receipt ;
																
													$balance=($balance + number_format($student->totalfee, 2, '.', ''))-( number_format($student->deposit, 2, '.', ''));
													$buffer =$balance;
													if($balance<0)
													{
													 $balance=$balance - ($balance*2);
													
                                                    ?>
													<!--INVOICES ROW -->
                                                    <tr>
                                                        <td><?php echo $student->created_at; ?>   </td>
                                                        <td><?php echo $invoice_number_new; ?>   </td>
                                                        <td><?php echo $student->name; ?>   </td>
                                                        <td><?php echo $student->admission_no; ?>   </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->discount === "N/A") {
                                                                echo $student->discount;
                                                                ?>

                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->discount, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->fine === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->fine, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text text-right">
                                                            <?php
                                                            if ($student->totalfee === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {

                                                                echo (number_format($student->totalfee, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text-right"><?php echo "(".$balance.")";?></td>
                                                    </tr>  
														<!--RECEIPTING PART-->
													<tr>
													    <td><?php echo $student->created_at; ?>   </td>
														<td><?php echo $receipt_number; ?>   </td>
                                                        <td><?php echo $student->name; ?>   </td>
                                                        <td><?php echo $student->admission_no; ?>   </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->discount === "N/A") {
                                                                echo $student->discount;
                                                                ?>

                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->discount, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->fine === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->fine, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
														<td class="text text-right">

                                                        </td>
                                                        <td class="text text-right">
                                                            <?php
                                                            if ($student->deposit === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->deposit, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                       <td class="text-right"><?php echo $balance;?></td>
                                                    </tr>	                                                  
                                                    <?php
													$balance=$buffer;
                                                  }
												  else{ ?>
												  
												  
												  <!--INVOICES ROW -->
                                                    <tr>
                                                        <td><?php $student_session_id = $student->student_session_id;

																$this->db->select('*');
																$this->db->from('student_fees_master');
																$this->db->where('student_session_id',$student_session_id);
																$query0 = $this->db->get();
																$result0 = $query0->row();
																
																$created_at = $result0->created_at;	
																
																echo $created_at;

														?>   </td>	
														<td><?php echo $invoice_number_new; ?>   </td>
                                                        <td><?php echo $student->name; ?>   </td>
                                                        <td><?php echo $student->admission_no; ?>   </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->discount === "N/A") {
                                                                echo $student->discount;
                                                                ?>

                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->discount, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->fine === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->fine, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text text-right">
                                                            <?php
                                                            if ($student->totalfee === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {

                                                                echo (number_format($student->totalfee, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td
                                                        <td class="text-right"><?php echo "(".$balance.")";?></td>
                                                    </tr>  
														<!--RECEIPTING PART-->
													<tr>
                                                        <td><?php $student_session_id = $student->student_session_id;

																$this->db->select('*');
																$this->db->from('student_fees_master');
																$this->db->where('student_session_id',$student_session_id);
																$query0 = $this->db->get();
																$result0 = $query0->row();
																
																$created_at = $result0->created_at;	
																
																echo $created_at;?>   </td>		
														<td><?php echo $receipt_number; ?>   </td>		
                                                        <td><?php echo $student->name; ?>   </td>
                                                        <td><?php echo $student->admission_no; ?>   </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->discount === "N/A") {
                                                                echo $student->discount;
                                                                ?>

                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->discount, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                        <td class="text text-right">

                                                            <?php
                                                            if ($student->fine === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->fine, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
														<td class="text text-right">

                                                        </td>
                                                        <td class="text text-right">
                                                            <?php
                                                            if ($student->deposit === "N/A") {
                                                                ?>
                                                                <span class="text text-red righttext">xxx</span>
                                                                <?php
                                                            } else {
                                                                echo (number_format($student->deposit, 2, '.', ''));
                                                            }
                                                            ?>
                                                        </td>
                                                       <td class="text-right"><?php echo $balance;?></td>
                                                    </tr>												  
												  
												  <?php }
											}
                                        } else {
                                                ?>
                                            <tfoot>
                                                <tr>
                                                    <td colspan="8" class="text-danger text-center">
                                                        <span class="input input-danger"><?php echo $this->lang->line('no_record_found'); ?></span>
                                                    </td>
                                                </tr>
                                            </tfoot>
                                            <?php
                                        }
                                        ?>
									<?php 

										 foreach ($journal_results->result() as $row1)  
										 {				
										 
													 $balance=($balance + $row1->debit)-( $row1->credit);
													$buffer =$balance;  
													
											if($balance<0)
											{
											 $balance=$balance - ($balance*2);
											 ?>
															<tr>
																<td class="mailbox-name"><?php echo $row1->date;?></td>
																<td class="mailbox-name"><?php echo $row1->receipt;?></td>
																<td class="mailbox-name"><?php echo $row1->account;?></td>
																<td class="mailbox-name">----</td>
																<td class="mailbox-name">----</td>
																<td class="mailbox-name">----</td>
																<td class="text text-right"><?php if($row1->debit == 0){echo "";} else{ echo $row1->debit;}?></td>
																<td class="text text-right"><?php if($row1->credit == 0){echo "";} else{ echo $row1->credit;}?></td>    
																<td class="text text-right"><?php echo "(".$balance.")";?></td> 																		
															</tr>														 
											 <?php $balance=$buffer; 
												}else{   ?>
																<tr>
																<td class="mailbox-name"><?php echo $row1->date;?></td>
																<td class="mailbox-name"><?php echo $row1->receipt;?></td>
																<td class="mailbox-name"><?php echo $row1->account;?></td>
																<td class="mailbox-name">----</td>
																<td class="mailbox-name">----</td>
																<td class="mailbox-name">----</td>																
																<td class="text text-right"><?php if($row1->debit == 0){echo "";} else{ echo $row1->debit;}?></td>
																<td class="text text-right"><?php if($row1->credit == 0){echo "";} else{ echo $row1->credit;}?></td>    
																<td class="text text-right"><?php echo $balance;?></td> 																		
															</tr>															
												<?php }																
										 }													 
											?>										
                                        <tr  class="box box-solid total-bg">
                                            <td></td>
                                            <td></td>
                                            <td></td>

                                            <td class="text text-right">
                                                <?php echo $this->lang->line('grand_total'); ?>
                                            </td>

                                            <td class="text text-right">
                                                <?php echo ($currency_symbol . number_format($grd_discount, 2, '.', '') ); ?>
                                            </td>
                                            <td class="text text-right">
                                                <?php echo ($currency_symbol . number_format($grd_fine, 2, '.', '') ); ?>
                                            </td>
											<td class="text text-right">
                                                <?php echo ($currency_symbol . number_format($grd_total, 2, '.', '') ); ?>
                                            </td>
                                            <td class="text text-right">
                                                <?php echo ($currency_symbol . number_format($grd_paid, 2, '.', '') ); ?>
                                            </td> 

                                            <td class="text text-right">
                                                <?php echo $currency_symbol.''.$balance; ?>
                                            </td>
                                        </tr>
										<tr>
										     <td>           
		
													<div class="btn-group pull-right"> 														
                                                        <button  class="btn btn-xs btn-info printInv" 
																	data-class_id="<?php echo  $class_id; ?>" 
																	data-section_id="<?php echo $section_id;?>"  
																	data-date_from="<?php echo $date_from2; ?>"  
																	data-date_to="<?php echo $date_to2; ?>"                  
                                                                 title="<?php echo $this->lang->line('print'); ?>"
                                                                 ><i class="fa fa-print"></i> Print Statement</button>
                                                    </div> 
												</td>
										</tr>
                                        </tbody> 
                                    </table>
                                <?php
                            }
                            ?>

                        </div>
                    </div>
                </div>  
            </div>
        </div>
        <div class="clearfix"></div>
        <footer>           
        </footer>
    </body>
</html>
