<?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" style="text-align:center;">
                        <div class="col-xs-12">
                            <br/>
                            <address>
                                <strong><?php echo $exp_title; ?></strong><br/>                                    
                                <h4 style="color:blue; font-weight:bold;">FEE STATEMENT REPORT</h4><br/>
                            </address> 
                        </div>
                    </div>

                        <hr style="margin-top: 0px;margin-bottom: 0px;">
                        <div class="row">
                        <table class="table table-striped mb0 font13">
                                                    <tbody>
                                                        <tr>
                                                            <th class="bozero"><?php echo $this->lang->line('name'); ?></th>
                                                            <td class="bozero"><?php echo $student['firstname'] . " " . $student['lastname'] ?></td>

                                                            <th class="bozero">Level   Class</th>
                                                            <td class="bozero"><?php echo $student['class'] . " (" . $student['section'] . ")" ?> </td>
                                                        </tr>
                                                        <tr>
                                                            <th><?php echo $this->lang->line('father_name'); ?></th>
                                                            <td><?php echo $student['father_name']; ?></td>
                                                            <th><?php echo $this->lang->line('admission_no'); ?></th>
                                                            <td><?php echo $student['admission_no']; ?></td>
                                                        </tr>
                                                        <tr>
                                                            <th><?php echo $this->lang->line('mobile_no'); ?></th>
                                                            <td><?php echo $student['mobileno']; ?></td>
                                                            <th><?php echo $this->lang->line('roll_no'); ?></th>
                                                            <td> <?php echo $student['roll_no']; ?>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <th><?php echo $this->lang->line('category'); ?></th>
                                                            <td>
                                                                <?php
                                                                foreach ($categorylist as $value) {
                                                                    if ($student['category_id'] == $value['id']) {
                                                                        echo $value['category'];
                                                                    }
                                                                }
                                                                ?>                                              
                                                            </td>
                                                            <th><?php echo $this->lang->line('rte'); ?></th>
                                                            <td><b class="text-danger"> <?php echo $student['rte']; ?> </b>
                                                            </td>
                                                        </tr>                                                        
														<tr>
														<form action="<?php echo site_url('studentfee/printFeesStatementByGroup') ?>"  method="post" accept-charset="utf-8">
                                                            <th></th>
                                                            <td>                       															
															</td>
															</form>
                                                            <th>Date</th>
                                                            <td><span class="pull-left"><?php echo $this->lang->line('date'); ?>: <?php echo date($this->customlib->getSchoolDateFormat()); ?></span></td>
                                                        </tr>

                                                    </tbody>
                                                    <table class="table table-striped table-bordered table-hover example table-fixed-header">

<thead class="header">
    <tr>
        <th><?php echo $this->lang->line('fees_group'); ?></th>
        <th><?php echo $this->lang->line('fees_code'); ?></th>
        <th align="left" class="text text-left">Fee Name</th>
        <th class="text text-center"><?php echo $this->lang->line('status'); ?></th>
        <th class="text text-right"><?php echo $this->lang->line('amount'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>
        <th class="text text-left">Reference No.</th>
        <th class="text text-left"><?php echo $this->lang->line('mode'); ?></th>
        <th class="text text-center"><?php echo $this->lang->line('date'); ?></th>
        <th class="text text-right" ><?php echo $this->lang->line('discount'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>

        <th class="text text-right"><?php echo $this->lang->line('fine'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>
        <th class="text text-right"><?php echo $this->lang->line('paid'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>
        <th class="text text-right"><?php echo $this->lang->line('balance'); ?> <span><?php echo "(" . $currency_symbol . ")"; ?></span></th>


    </tr>
</thead>
<tbody>
    <?php
    $total_amount = "0";
    $total_deposite_amount = "0";
    $total_fine_amount = "0";
    $total_discount_amount = "0";
    $total_balance_amount = "0";
    $alot_fee_discount = 0;
    

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

        foreach ($fee->fees as $fee_key => $fee_value) {
            $fee_paid = 0;
            $fee_discount = 0;
            $fee_fine = 0;



            if (!empty($fee_value->amount_detail)) {
                $fee_deposits = json_decode(($fee_value->amount_detail));

                foreach ($fee_deposits as $fee_deposits_key => $fee_deposits_value) {
                    $fee_paid = $fee_paid + $fee_deposits_value->amount;
                    $fee_discount = $fee_discount + $fee_deposits_value->amount_discount;
                    $fee_fine = $fee_fine + $fee_deposits_value->amount_fine;
                }
            }
            $total_amount = $total_amount + $fee_value->amount;
            $total_discount_amount = $total_discount_amount + $fee_discount;
            $total_deposite_amount = $total_deposite_amount + $fee_paid;
            $total_fine_amount = $total_fine_amount + $fee_fine;
            $feetype_balance = $fee_value->amount - ($fee_paid + $fee_discount);
            $total_balance_amount = $total_balance_amount + $feetype_balance;
            ?>												
            
            <?php
            if ($feetype_balance > 0 && strtotime($fee_value->due_date) < strtotime(date('Y-m-d'))) {
                ?>
                <tr class="danger">
                    <?php
                } else {
                    ?>
                <tr class="dark-gray">
                    <?php
                }
                ?>
                <td><?php echo $fee_value->name;?></td>
                <td><?php echo $fee_value->code; ?></td>
                 <td align="left"><?php echo $fee_value->type; ?></td>
                <td class="text text-center">
                    <?php
                    if ($feetype_balance == 0) {
                        ?><span class="label label-success"><?php echo $this->lang->line('paid'); ?></span><?php
                    } else if (!empty($fee_value->amount_detail)) {
                        ?><span class="label label-warning"><?php echo $this->lang->line('partial'); ?></span><?php
                    } else {
                        ?><span class="label label-danger"><?php echo $this->lang->line('unpaid'); ?></span><?php
                        }
                        ?>

                </td>
                <td class="text text-right"><?php echo $fee_value->amount; ?></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text text-right"><?php
                    echo (number_format($fee_discount, 2, '.', ''));
                    ?></td>
                <td class="text text-right"><?php
                    echo (number_format($fee_fine, 2, '.', ''));
                    ?></td>
                <td class="text text-right"><?php
                    echo (number_format($fee_paid, 2, '.', ''));
                    ?></td>
                <td class="text text-right"><?php
                    $display_none = "ss-none";
                    if ($feetype_balance > 0) {
                        $display_none = "";


                        echo (number_format($feetype_balance, 2, '.', ''));
                    }
                    ?>

                </td>
            </tr>

            <?php
            if (!empty($fee_value->amount_detail)) {

                $fee_converted = 0;
                $fee_paid = 0;

                $fee_deposits = json_decode(($fee_value->amount_detail));

                $this->db->select('*');
                $this->db->from('bank_rates');
                $query1 = $this->db->get();
                $result1 = $query1->row();

                $home_currency = $result1->home_currency;
                $foreign_currency = $result1->foreign_currency;

                foreach ($fee_deposits as $fee_deposits_key => $fee_deposits_value) {

                    $payment_mode = $fee_deposits_value->payment_mode;
                    $amount = $fee_deposits_value->amount;

                        if($payment_mode==$currency_symbol){
                                                                                    
                                $this->db->select('*');
                                $this->db->from('bank_rates');
                                $this->db->where('home_currency',$payment_mode);
                                $query1 = $this->db->get();
                                $row1_rate = $query1->row();
                                
                                $home_rate = $row1_rate->home_rate;
                                
                                $fee_converted = $home_rate*$amount;
                                
                        }
                    else{
                        
                                $this->db->select('*');
                                $this->db->from('bank_rates');
                                $this->db->where('foreign_currency',$payment_mode);
                                $query3 = $this->db->get();
                                $row1_rate2 = $query3->row();
                                
                                $foreign_currency_row1 = $row1_rate2->foreign_currency;
                                $foreign_rate = $row1_rate2->foreign_rate;
                                
                                $fee_converted = ($amount/$foreign_rate)*1;	
                                
                    }														
                    
                     $fee_paid = $fee_paid + $fee_converted;

                    ?>
                    <tr class="white-td">
                        <td></td>
                        <td></td>
                        <td></td>
                        <td class="text-right"></td>
                        <td class="text-right"><img src="<?php echo base_url(); ?>backend/images/table-arrow.png" alt="" /></td>
                        <td class="text text-left">
                                                                                       
                            <a href="#" data-toggle="popover" class="detail_popover" > <?php 
                            $invoice_number = $fee_deposits_value->invoice; 
                            $invoice_number_new = "INV" . sprintf('%04s', $invoice_number); 

                            
                            $deposit_id = $fee_value->student_fees_deposite_id;
                            
                            $this->db->select('*');
                            $this->db->from('student_fees_deposite');
                            $this->db->where('id',$deposit_id);
                            $query0 = $this->db->get();
                            $result0 = $query0->row();
                            
                            $receipt_number  = $result0->receipt ; 
                            
                            echo $receipt_number . " / " . $invoice_number_new;
                            
                            ?></a>
                            <div class="fee_detail_popover" style="display: none">
                                <?php
                                if ($fee_deposits_value->description == "") {
                                    ?>
                                    <p class="text text-danger"><?php echo $this->lang->line('no_description'); ?></p>
                                    <?php
                                } else {
                                    ?>
                                    <p class="text text-info"><?php echo $fee_deposits_value->description; ?></p>
                                    <?php
                                }
                                ?>
                            </div>
                        </td>
                        <td class="text text-left"><?php echo $fee_deposits_value->payment_mode; ?></td>
                        <td class="text text-center"><?php echo $fee_value->created_at; ?> </td>
                        <td class="text text-right"><?php echo (number_format($fee_deposits_value->amount_discount, 2, '.', '')); ?></td>
                        <td class="text text-right"><?php echo (number_format($fee_deposits_value->amount_fine, 2, '.', '')); ?></td>
                        <td class="text text-right"><?php echo (number_format($fee_paid, 2, '.', '')); ?></td>
                        <td></td>



                    </tr>
                    <?php
                }
            }
            ?>
            <?php
        }
    }

    ?>
    <?php
    if (!empty($student_discount_fee)) {

        foreach ($student_discount_fee as $discount_key => $discount_value) {
            ?>
            <tr class="dark-light">
                <td align="left"> <?php echo $this->lang->line('discount'); ?> </td>
                <td align="left">
                    <?php echo $discount_value['code']; ?>
                </td>
                <td align="left"></td>
                <td align="left" class="text text-left">
                    <?php
                    if ($discount_value['status'] == "applied") {
                        ?>
                        <a href="#" data-toggle="popover" class="detail_popover" >

                            <?php echo $this->lang->line('discount_of') . " " . $currency_symbol . $discount_value['amount'] . " " . $this->lang->line($discount_value['status']) . " : " . $discount_value['payment_id']; ?>

                        </a>
                        <div class="fee_detail_popover" style="display: none">
                            <?php
                            if ($fee_deposits_value->description == "") {
                                ?>
                                <p class="text text-danger"><?php echo $this->lang->line('no_description'); ?></p>
                                <?php
                            } else {
                                ?>
                                <p class="text text-danger"><?php echo $discount_value['student_fees_discount_description'] ?></p>
                                <?php
                            }
                            ?>

                        </div>
                        <?php
                    } else {
                        echo '<p class="text text-danger">' . $this->lang->line('discount_of') . " " . $currency_symbol . $discount_value['amount'] . " " . $this->lang->line($discount_value['status']);
                    }
                    ?>

                </td>
                <td></td>
                <td class="text text-left"></td>
                <td class="text text-left"></td>
                <td class="text text-left"></td>
                <td  class="text text-right">
                    <?php
                    $alot_fee_discount = $alot_fee_discount;
                    ?>
                </td>
                <td></td>
                <td></td>
                <td ></td>

            </tr>
            <?php
        }
    }
}
    ?>

    <tr class="box box-solid total-bg">
        <td align="left"></td>
        <td align="left"></td>
        <td align="left"></td>
        <td class="text text-left" ><?php echo $this->lang->line('grand_total'); ?></td>
        <td class="text text-right"><?php
            echo ($currency_symbol . number_format($total_amount, 2, '.', ''));
            ?></td>
        <td align="left"></td>
        <td align="left"></td>
        <td align="left"></td>
        <td class="text text-right"><?php
            echo ($currency_symbol . number_format($total_discount_amount + $alot_fee_discount, 2, '.', ''));
            ?></td>

        <td class="text text-right"><?php
            echo ($currency_symbol . number_format($total_fine_amount, 2, '.', ''));
            ?></td>
        <td class="text text-right"><?php
            echo ($currency_symbol . number_format($total_deposite_amount, 2, '.', ''));
            ?></td>
        <td class="text text-right"><?php
            echo ($currency_symbol . number_format($total_balance_amount - $alot_fee_discount, 2, '.', ''));
            ?></td> 

    </tr>
   
</tbody>
</table>
                                                </table>

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