<?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>
<?php
$currency_symbol = $this->customlib->getSchoolCurrencyFormat();
?>

<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;">FEES COLLECTION REPORT</h4><br/>
        </address> 
    </div>
</div>

                        <hr style="margin-top: 0px;margin-bottom: 0px;" />
                        <div class="row">
                            <?php
                            if (!empty($feeList)) {
                                ?>
                                      <table class="table table-striped table-bordered table-hover example table-fixed-header">
                                          <thead class="header">
                                                <tr>
                                                    <th>Reference</th>
                                                    <th><?php echo $this->lang->line('date'); ?></th>
                                                    <th><?php echo $this->lang->line('name'); ?></th>
                                                    <th><?php echo $this->lang->line('class'); ?></th>
                                                    <th><?php echo $this->lang->line('fee_type'); ?></th>
                                                    <th><?php echo $this->lang->line('mode'); ?></th>
                                                    <th class="text text-right"><?php echo $this->lang->line('amount'); ?></th>
                                                    <th class="text text-right"><?php echo $this->lang->line('amount'); ?> <span><?php echo "(" . $currency_symbols . ")"; ?></span></th>
                                                    <th class="text text-right"><?php echo $this->lang->line('discount'); ?> <span><?php echo "(" . $currency_symbols . ")"; ?></span></th>
                                                    <th class="text text-right"><?php echo $this->lang->line('fine'); ?> <span><?php echo "(" . $currency_symbols . ")"; ?></span></th>
                                                    <th class="text text-right"><?php echo $this->lang->line('total'); ?> <span><?php echo "(" . $currency_symbols . ")"; ?></span></th>
                                                </tr>
                                            </thead>
                                                <tbody>
                                            <?php
                                            $amount = 0;
                                            $discount = 0;
                                            $fine = 0;
                                            $total = 0;
                                            $grd_total = 0;
                                            $fee_paid = 0;  // To accumulate converted amounts
                                            if (empty($feeList)) {
                                            ?>
                                <tfoot>
                                    <tr>
                                        <td colspan="9" class="text-danger text-center"><?php echo $this->lang->line('no_transaction_found'); ?></td>
                                    </tr>
                                </tfoot>
                            <?php
                            } else {
                                $count = 1;
                                foreach ($feeList as $key => $value) {
                                    $original_amount = $value['amount'];
                                    $payment_mode = $value['payment_mode'];

                                    // Fetch the exchange rate for the payment mode
                                    $this->db->select('foreign_rate');
                                    $this->db->from('bank_rates');
                                    $this->db->where('foreign_currency', $payment_mode);
                                    $query_rate = $this->db->get();

                                    // Check if the foreign rate is available
                                   // Check if the foreign rate is available
                            $foreign_rate = $query_rate->row()->foreign_rate ?? 1; // Default to 1 if no rate found

                            // Convert the amount if the payment mode is not 'default' and the foreign rate is available
                            $converted_amount = ($payment_mode === 'default' || empty($payment_mode))
                                ? $original_amount / $foreign_rate // Convert to USD
                                : $original_amount; // If specific payment mode, no conversion

                            // Accumulate the totals
                            if ($payment_mode === 'default' || empty($payment_mode)) {
                                $fee_paid += $converted_amount;
                            } else {
                                $fee_paid += $original_amount;
                            }
                            $discount += $value['amount_discount'];
                            $fine += $value['amount_fine'];
                            $total = ($fee_paid + $fine) - $discount;
                            ?>
                                    <tr>
                                    <td width="13%">
                                    <?php 
                                    // $invoice_number = $value['invoice']; 															
                                                                            
                                    
                                    $student_fees_deposite_id = $value['id'];
                                    
                                        $this->db->select('*');
                                        $this->db->from('student_fees_deposite');
                                        $this->db->where('id',$student_fees_deposite_id);
                                        $query0 = $this->db->get();
                                        $result0 = $query0->row();
                                        
                                        $receipt_number  = $result0->receipt ;															
                                        $invoice_number  = $result0->invoice ;	
                                        
                                    $invoice_number_new = "INV" . sprintf('%04s', $invoice_number);

                                    echo '<i style="color:blue;">'.$receipt_number.'</i>' . " / <i style='color:red;'>" . $invoice_number_new.'</i>' ; ?>
                                </td>
                                <td>
                                    <?php echo date($this->customlib->getSchoolDateFormat(), $this->customlib->dateyyyymmddTodateformat($value['date'])); ?>
                                </td>
                                <td>
                                    <?php echo $value['firstname'] . " " . $value['lastname']; ?>
                                </td>
                                <td>
                                    <?php echo $value['class'] . " (" . $value['section'] . ")"; ?>
                                </td>
                                <td>
                                    <?php echo $value['type']; ?>
                                </td>
                                <td>
                                    <?php echo $value['payment_mode']; ?>
                                </td>
                                <td class="text text-right">
                                    <?php echo number_format($value['amount'], 2, '.', ''); ?>
                                </td>
                                <td class="text text-right">
                                    <?php 
                                    if (empty($payment_mode)) {
                                        echo number_format($converted_amount, 2, '.', '') . " ($currency_symbols)";
                                    } else {
                                        echo number_format($original_amount, 2, '.', '') . " ($currency_symbols)";
                                    }
                                    ?>
                                </td>
                                <td class="text text-right">
                                    <?php echo number_format($value['amount_discount'], 2, '.', ''); ?>
                                </td>
                                <td class="text text-right">
                                    <?php echo number_format($value['amount_fine'], 2, '.', ''); ?>
                                </td>
                            <td class="text text-right">
                                    <?php
                                    // Calculate the total amount (amount + fine - discount)
                                    $row_total = ($original_amount + $value['amount_fine']) - $value['amount_discount'];
                                    echo number_format($row_total, 2, '.', ''); 
                                    ?>
                                </td>
                            </tr>
                                    <?php
                                            $count++;
                                        }
                                    }
                                    ?>
                                <tr class="box box-solid total-bg">
                                <td></td><td></td><td></td><td></td><td></td><td></td>
                                <td class="text-right"><?php echo $this->lang->line('grand_total'); ?> </td>
                                <td class="text text-right">
                                    <?php 
                                    if (!empty($payment_mode)) {
                                        // Show the total in selected payment currency
                                        echo $payment_mode . " " . number_format($fee_paid, 2, '.', '');
                                    } else {
                                        // Show total in USD
                                        echo "USD " . number_format($fee_paid, 2, '.', '');
                                    }
                                    ?>
                                </td>
                                <td class="text text-right">
                                <?php 
                                    if (!empty($payment_mode)) {
                                        // Show the total in selected payment currency
                                        echo $payment_mode . " " . number_format($discount, 2, '.', '');
                                    } else {
                                        // Show total in USD
                                        echo "USD " . number_format($discount, 2, '.', '');
                                    }
                                    ?>
                                </td>
                                <td class="text text-right">
                                <?php 
                                    if (!empty($payment_mode)) {
                                        // Show the total in selected payment currency
                                        echo $payment_mode . " " . number_format($fine, 2, '.', '');
                                    } else {
                                        // Show total in USD
                                        echo "USD " . number_format($fine, 2, '.', '');
                                    }
                                    ?>
                                </td>
                                <td class="text text-right">
                                    <?php 
                                    if (!empty($payment_mode)) {
                                        // Show grand total in the selected payment currency
                                        echo $payment_mode . " " . number_format($total, 2, '.', '');
                                    } else {
                                        // Show grand total in USD
                                        echo "USD " . number_format($total, 2, '.', '');
                                    }
                                    ?>
                                </td>
                            </tr>
    
                                            </tbody>
                                        </table>
                                            
                                <?php
                            }
                            ?>

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