<div class="dash-section">

    <div class="row">
        <div class="col-sm-10">
            <h4>State wise Reports</h4>
        </div>
        <div class="col-sm-2"><a href="<?php echo base_url('console/downloadStatereport'); ?>"
                class="btn btn-primary">Export as Excel</a></div>
    </div>
    <div>&nbsp;</div>

    <div class="row ">
        <div class="col-sm-12">
                <table class="table table-bordered" id="statetableheader" style="margin-bottom: 0px">
                    <thead>
                        <tr>
                            <th class="small-font width-40">States</th>
                            <th class="small-font width-20" colspan="2">
                                <div class="col-sm-12 top-table-line">Willingness Forms</div>
                                <div class="col-sm-6">Received (No.)</div>
                                <div class="col-sm-6">Sanctioned (No.) (A)</div>
                            </th>

                            <th class="small-font width-20" colspan="2">
                                <div class="col-sm-12 top-table-line">Other EE loan applications</div>
                                <div class="col-sm-6">Received (No.)</div>
                                <div class="col-sm-6">Sanctioned (No.) (B)</div>
                            </th>

                            <th class="small-font width-30" colspan="3">
                                <div class="col-sm-12 top-table-line">Total EE loan applications</div>
                                <div class="col-sm-4">Sanctioned (No.) - (A+B)</div>
                                <div class="col-sm-4">Loan amount (Rs. Crore)</div>
                                <div class="col-sm-4">Loan Disbursed (Rs Crore)</div>
                            </th>
                        </tr>
                    </thead>
                </table>
                <div style="overflow: auto">
                <table class="table table-bordered">
                    <tbody>
                        <?php if(!empty($states)) { ?>


                        <?php 
                            $totalsanctionA = 0;
                            $totalSanctionB = 0;
                            $totalSanctionedAB = 0;
                            $totalLoanAmount = 0;
                            $totalLoanDisbursed = 0; 
                            $totalRecivedA = 0;   
                        ?>

                        <?php foreach($states as $state): ?>
                        <?php $stcode = trim($state['state_code']); ?>
                        <?php
                        
                            $sanction = !empty($sanctioned[$stcode]['amount']) ? $sanctioned[$stcode]['amount']: 0;
                            $disburse = !empty($disbursed[$stcode]['amount']) ? $disbursed[$stcode]['amount']: 0;
                            $totalSanction = number_format((float)($sanction) / 10000000, 2, '.', '');
                            $totalDisburse = number_format(($disburse) / 10000000, 2, '.', '');
                        ?>

                        <tr>
                            <td class="width-40"><a class="text-dec"
                                    href="<?php echo base_url('console/statesr/'.$stcode.'/1'); ?>"><?php echo $state['state_name']; ?></a>
                            </td>
                            <td class="width-10"><a class="text-dec"
                                    href="<?php echo base_url('console/statesr/'.$stcode.'/1'); ?>"><?php echo !empty($fidata[$stcode]) ? $fidata[$stcode]: 0; $totalRecivedA = $totalRecivedA  + $fidata[$stcode]; ?></a>
                            </td>
                            <td class="width-10"><?php echo !empty($sanctioned[$stcode]['num']) ? $sanctioned[$stcode]['num']: 0; $totalsanctionA = $totalsanctionA + $sanctioned[$stcode]['num'];  ?>
                            </td>

                            <td class="width-10"><?php echo !empty($financed[$stcode]['num']) ? $financed[$stcode]['num']: 0;   ?></td>
                            <td class="width-10"><?php echo !empty($financed[$stcode]['num']) ? $financed[$stcode]['num']: 0; $totalSanctionB =  $totalSanctionB + $financed[$stcode]['num']; ?>
                            </td>

                            <td class="width-12">
                                <?php
                                $fin = !empty($financed[$stcode]['num']) ? $financed[$stcode]['num'] : 0;
                                $sanc =  !empty($sanctioned[$stcode]['num']) ? $sanctioned[$stcode]['num']: 0;
                            ?>
                                <?php echo $fin + $sanc; ?>
                            </td>
                            <td class="width-12">
                                <?php echo $totalSanction; $totalLoanAmount = $totalLoanAmount + $totalSanction; ?></td>
                            <td class="width-12">
                                <?php echo $totalDisburse; $totalLoanDisbursed = $totalDisburse + $totalLoanDisbursed; ?>
                            </td>
                        </tr>
                        <?php endforeach; ?>
                        <?php } ?>



                        <tr>
                            <td><strong>Total</strong></td>
                            <td><strong><?php echo $totalRecivedA; ?></strong></td>
                            <td><strong><?php echo $totalsanctionA; ?></strong></td>
                            <td><strong>0</strong></td>
                            <td><strong><?php echo $totalSanctionB; ?></strong></td>
                            <td><strong><?php echo ($totalsanctionA + $totalSanctionB); ?></strong></td>
                            <td><strong><?php echo $totalLoanAmount; ?></strong></td>
                            <td><strong><?php echo $totalLoanDisbursed; ?></strong></td>

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

        </div>
    </div>
</div>
</section>