1#@!#!123s

: / home / schoolcampuserp / isadhi.alphaips.co.in / application / views / studentfee /
Filename : collection_report_yuvi.php
back
<?php
$currency_symbol = $this->customlib->getSchoolCurrencyFormat();
?>
<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js"></script>

<div class="content-wrapper">
    <section class="content-header"></section>
    <!-- Main content -->
    <section class="content">
        <?php $this->load->view('reports/_finance'); ?>
        <div class="row">
            <div class="col-md-12">
                <div class="box removeboxmius">
                    <div class="box-header ptbnull"></div>
                    <div class="box-header ">
                        <h3 class="box-title"><i class="fa fa-search"></i> <?php echo $this->lang->line('select_criteria'); ?></h3>
                    </div>
                    <form role="form" action="<?php echo site_url('studentfee/collection_report') ?>" method="post" class="">
                        <div class="box-body row">
                            <?php echo $this->customlib->getCSRF(); ?>
                            <div class="col-sm-2 col-lg-2 col-md-2">
                                <div class="form-group">
                                    <label><?php echo $this->lang->line('search') . " " . $this->lang->line('duration'); ?><small class="req"> *</small></label>
                                    <select class="form-control" name="search_type" onchange="showdate(this.value)">

                                        <?php foreach ($searchlist as $key => $search) {
                                            ?>
                                            <option value="<?php echo $key ?>" <?php
                                            if ((isset($search_type)) && ($search_type == $key)) {
                                                echo "selected";
                                            }
                                            ?>><?php echo $search ?></option>
                                                <?php } ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('search_type'); ?></span>
                                </div>
                            </div>
                            

                                
                                
                            <div class="col-sm-2 col-lg-2 col-md-2">
                               <div class="form-group">
                                            <label for="exampleInputEmail1"><?php echo $this->lang->line('fees_type'); ?></label>

                                            <select  id="feetype_id" name="feetype_id" class="form-control" >
                                                <option value=""><?php echo $this->lang->line('select'); ?></option>
                                                <?php
                                                foreach ($feetypeList as $feetype) {
                                                    ?>
                                                    <option value="<?php echo $feetype['id'] ?>"<?php
                                                    if (set_value('feetype_id') == $feetype['id']) {
                                                        echo "selected =selected";
                                                    }
                                                    ?>><?php echo $feetype['type'] ?></option>

                                                    <?php
                                                    $count++;
                                                }
                                                ?>
                                            </select>
                                            <span class="text-danger"><?php echo form_error('feetype_id'); ?></span>
                                        </div>
                            </div>
                            <div class="col-sm-3 col-lg-3 col-md-3">
                                <div class="form-group">
                                    <label><?php echo $this->lang->line('collect') . " " . $this->lang->line('by'); ?></label>
                                    <select class="form-control"  name="collect_by" >
                                        <option value=""><?php echo $this->lang->line('select') ?></option>
                                        <?php
                                        foreach ($collect_by as $key => $value) {
                                            ?>
                                            <option value="<?php echo $key ?>" <?php
                                            if ((isset($received_by)) && ($received_by == $key)) {
                                                echo "selected";
                                            }
                                            ?> ><?php echo $value ?></option> 
                                                <?php } ?>
                                    </select> 
                                    <span class="text-danger"><?php echo form_error('collect_by'); ?></span>
                                </div>
                            </div> 
                            
                            <div class="col-sm-2 col-lg-2 col-md-2">
                                <div class="form-group">
                                    <label><?php echo $this->lang->line('group') . " " . $this->lang->line('by'); ?></label>
                                    <select class="form-control" name="group" >
                                        <?php foreach ($group_by as $key => $value) {
                                            ?>
                                            <option value="<?php echo $key ?>" <?php
                                            if ((isset($group_byid)) && ($group_byid == $key)) {
                                                echo "selected";
                                            }
                                            ?> ><?php echo $value ?></option> 
                                                <?php } ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('group'); ?></span>
                                </div>
                            </div> 
                            
                            <!--added new features -->
<div class="col-sm-2 col-lg-2 col-md-2">
    <div class="form-group">
        <label>Wants to includes fees head</label><br>

        <label>
            <input type="radio" name="include_fee_head" value="yes"
                <?php echo (isset($include_fee_head) && $include_fee_head == 'yes') ? "checked" : ""; ?>>
            Yes
        </label>

        <label style="margin-left:10px;">
            <input type="radio" name="include_fee_head" value="no"
                <?php echo (!isset($include_fee_head) || $include_fee_head == 'no') ? "checked" : ""; ?>>
            No
        </label>
    </div>
</div>

                            <!--ends hers-->
                            
                            <div id='date_result'>
                            </div>
                            <div class="form-group">
                                <div class="col-sm-12">
                                    <button type="submit" name="search" value="search_filter" class="btn btn-primary btn-sm checkbox-toggle pull-right"><i class="fa fa-search"></i> <?php echo $this->lang->line('search'); ?></button>
                                </div>
                            </div>
                        </div>
                    </form>
 <?php
//  echo "<pre>";
//  print_r($results);
//   echo "</pre>";

if($include_fee_head == 'yes'){

function getUniqueFeeHeads(array $data): array {
    $fees_heads_new = [];

    foreach ($data as $item) {
        foreach ($item as $subItem) {
            if (isset($subItem['fee_receipt_no_data']['value'])) {
                $values = (array)$subItem['fee_receipt_no_data']['value'];

                foreach ($values as $key => $val) {
                    // Only consider fee head objects (skip normal fields)
                    if (is_object($val)) {
                        // Remove bracket parts e.g. "Tuition (Nur-UKG)" → "Tuition"
                        $cleanKey = preg_replace('/\s*\(.*?\)/', '', $key);

                        // Store unique fee heads
                        if (!in_array($cleanKey, $fees_heads_new)) {
                            $fees_heads_new[] = $cleanKey;
                        }
                    }
                }
            }
        }
    }

    return $fees_heads_new;
}

// ---------- Example usage ----------
$fees_heads_new = getUniqueFeeHeads($results);

}
// print_r($fees_heads_new);

 
                                    if (empty($results)) {
                                        
                                        
                                        ?>
                                        
<div class="alert alert-info">
   <?php echo $this->lang->line('no_record_found'); ?>
</div>
                                        <?php
                                    } else {?>
                    <div class="">
                        <div class="box-header ptbnull"></div>
                        <div class="box-header ptbnull">
                            <h3 class="box-title titlefix"><i class="fa fa-money"></i> <?php ?> <?php echo $this->lang->line('fees') . " " . $this->lang->line('collection') . " " . $this->lang->line('report'); ?></h3> 
                        </div>
                        <div class="box-body table-responsive" id="transfee">
                        <div id="printhead"><center><h5><?php ?> <?php echo $this->lang->line('fees') . " " . $this->lang->line('collection') . " " . $this->lang->line('report') . "<br>";
                                                $this->customlib->get_postmessage();
                                                ?></h5></center></div>      
                            <div class="download_label"><?php ?> <?php echo $this->lang->line('fees') . " " . $this->lang->line('collection') . " " . $this->lang->line('report') . "<br>";
                                                $this->customlib->get_postmessage();
                                                ?></div>
										
                            <a class="btn btn-default btn-xs pull-right" id="print" onclick="printDiv()" ><i class="fa fa-print"></i></a> 
							<a class="btn btn-default btn-xs pull-right" id="btnExport" onclick="exportToExcel();"> <i class="fa fa-file-excel-o"></i> </a>
							
                      		<table class="table table-striped table-bordered table-hover " id="headerTable">
                                <thead class="header">
                                    <tr>
                                        <th>Fee Receipt No</th>
                                        <th><?php echo $this->lang->line('payment_id'); ?></th>
                                        <th><?php echo $this->lang->line('remarks'); ?></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('collect_by'); ?></th>
                                        <th><?php echo $this->lang->line('mode'); ?></th>
                                        
                                                          
                                           <!-- 🔹 Dynamically insert fee heads here -->
                                           
            <?php
            if($include_fee_head == "yes") {
        
            if (!empty($fees_heads_new)) { 
                foreach ($fees_heads_new as $head) { ?>
                    <th><?php echo htmlspecialchars($head); ?></th>
            <?php }
            
                ?>
                 <th style="mso-number-format:'\@'"  class="text-center"> Total </th>
                <?php
            } 
                }else{
                    ?>
                <th style="mso-number-format:'\@'" class="text text-right"><?php echo $this->lang->line('amount'); ?> </th>
                <?php
                }
            ?>
                                        
                                      
                                        <th style="mso-number-format:'\@'" class="text text-right"><?php echo $this->lang->line('discount'); ?> </th>
                                        <th style="mso-number-format:'\@'" class="text text-right"><?php echo $this->lang->line('fine'); ?> </th>
                                        <th style="mso-number-format:'\@'" class="text text-right">
                                            
                                            <?php 
                                            if($include_fee_head == "yes") {
                                               echo "Grand Total"; 
                                            }else{
                                              echo $this->lang->line('total');   
                                            }
                                            
                                            ?> 
                                            
                                            </th>
                                    </tr>
                                </thead>
                                <tbody>

                                   <?php

                                        $count = 1;
                                        $grdamountLabel = array();
                                        $grddiscountLabel = array();
                                        $grdfineLabel = array();
                                      $grdTotalLabel = array();

//  echo"<pre>";  
// print_r($results);
//   echo"</pre>";
// exit();
// Define the fee heads to extract (without brackets)

$fee_heads = $fees_heads_new;

// Initialize the result array
$payment_breakdown = [];
$discount_breakdown = [];
$fine_breakdown =[];
$unfiltered_total_amount=[];

if($include_fee_head == 'yes'){

foreach ($results as $payment_group) {
    
    foreach ($payment_group as $payment) {
        $value_obj = $payment['fee_receipt_no_data']['value'];
        
        // Normalize keys by removing parentheses and their content
        $normalized_amounts = [];
        foreach ($value_obj as $key => $item) {
            
        // echo $key ."<br>test1<br>";
        
        // echo $item ;
            //get the amounts         
            if (is_object($item)) {
                $clean_key = trim(preg_replace('/\s*\([^)]*\)/', '', $key));
                $normalized_amounts[$clean_key] = $item->amount;
            }
            
            //get the discounts
            if ($key == "amount_discount") {
                $discount_entry = $item;
            }
            // get the fines 
            
            if ($key == "amount_fine") {
                $fine_entry = $item;
            }
            
        }



        // Add amounts for each fee head (0 if not present)
        foreach ($fee_heads as $head) {
            $payment_entry[$head] = $normalized_amounts[$head] ?? 0;
        }
        
        // echo "test2<br><br>";
        
        $payment_breakdown[$payment['id'] . '/' . $payment['inv_no']] = $payment_entry;
        $discount_breakdown[$payment['id'] . '/' . $payment['inv_no']]=$discount_entry;
        $fine_breakdown[$payment['id'] . '/' . $payment['inv_no']]=$fine_entry;
    }
}

// calculate the unfiltered total amounts
foreach ($payment_breakdown as $payment_id => $heads) {
    $unfiltered_total_amount[$payment_id] = array_sum($heads);
}



}else{
    
    foreach ($results as $payment_group) {
    
    foreach ($payment_group as $payment) {
        


        $payment_breakdown[$payment['id'] . '/' . $payment['inv_no']] = $payment['amount'];
        $discount_breakdown[$payment['id'] . '/' . $payment['inv_no']]=$payment['amount_discount'];
        $fine_breakdown[$payment['id'] . '/' . $payment['inv_no']]=$payment['amount_fine'];
    }
    }
    
// echo "deepseek teset<br><pre>";
// print_r($payment_breakdown);
// echo "</pre>";

// calculate the unfiltered total amounts
foreach ($payment_breakdown as $payment_id => $heads) {
    $unfiltered_total_amount[$payment_id] = $heads;
}

}

// Output the structured payment breakdown


                                        foreach ($results as $key => $value) {
                                        //   echo "<pre>";
                                        //     print_r($value);
                                        //       echo "</pre>";
                                       
                                            $result=1;
                                            
                                            $fee_receipt_no=array();
                                            $fees_head_name_array=array();
                                            $descriptions_array = array();
                                            $payment_id = array();
                                            $date = array();
                                            $student_name = array();
                                            $student_class = array();
                                            $fees_type = array();
                                            $pay_mode = array();
                                            $collection_by = array();
                                            $amountLabel = array();
                                            $discountLabel = array();
                                            $fineLabel = array();
                                            $TotalLabel = array();
                                            
                                            foreach ($value as $collect) {
                                                
                                                $fee_receipt_no[]=$collect['fee_receipt_no'];
                                                $descriptions_array[$collect['fee_receipt_no']]= $collect['description'];
                                                $payment_id[] = $collect['id'] . "/" . $collect['inv_no'];
                                                $date[] = date($this->customlib->getSchoolDateFormat(), $this->customlib->dateyyyymmddTodateformat($collect['date']));
                                                $student_name[] = $this->customlib->getFullName($collect['firstname'],$collect['middlename'],$collect['lastname'],$sch_setting->middlename,$sch_setting->lastname) .' ('.$collect['admission_no'].')';
                                                $student_class[] = $collect['class'] . " (" . $collect['section'] . ")";
                                                $fees_type[] = $collect['type'];
                                                $pay_mode[] = $collect['payment_mode'];
                                                
                                                

                                                
                                            if(is_array($collect['received_byname'])){
                                                $collection_by[] = $collect['received_byname']['name'] . " (" . $collect['received_byname']['employee_id'] . ")";   
                                            }
                                            
// final modifications
                                            

                                            
    //final modifications
                                            
                                            }


//  echo "<pre>";
//  print_r($payment_id);
//   echo "</pre>";                                            
                                            
                                            
                                            // $result=(!empty($fees_head_value))?!empty($amountLabel):1;
                                            if($result){
                                            ?>
                                            <tr>
                                                <td>
                                                    <table width="100%"><?php foreach ($fee_receipt_no as $p_ides) {
                                                ?>
                                                            <tr><td style="mso-number-format:'\@'"  class="text-left-md payment_id"><?php echo $p_ides; ?></td></tr>
                                                        <?php }
                                                        ?></table>
                                                </td>
                                                
                                                <td>
                                                    <table width="100%"><?php foreach ($payment_id as $p_ides) {
                                                ?>
                                                            <tr><td style="mso-number-format:'\@'"  class="text-left-md payment_id"><?php echo $p_ides; ?></td></tr>
                                                        <?php }
                                                        ?></table>
                                                </td>
                                                <td>
                                                    <table width="100%">
                                                        <?php foreach($fee_receipt_no as $p_ides){?>
                                                     <tr><td style="mso-number-format:'\@'"  class="text-left-md payment_id"><?php echo $descriptions_array[$p_ides]; ?></td></tr>
                                                     <?php } ?>
                                                        </table>
                                                </td>
                                                <td >
                                                    <table width="100%"><?php foreach ($date as $date_val) {
                                                            ?>
                                                            <tr><td class="text-left-md"><?php echo $date_val; ?></td></tr>
                                                        <?php }
                                                        ?></table>
                                                </td>
                                                <td >
                                                    <table width="100%"><?php foreach ($student_name as $student_name_val) {
                                                            ?>
                                                            <tr><td class="text-left-md"><?php echo $student_name_val; ?></td></tr>
                                                        <?php }
                                                        ?>
                                                    </table>
                                                </td>
                                                <td>
                                                    <table width="100%"><?php
                                                        foreach ($student_class as $student_class_val) {
                                                            ?>
                                                            <tr><td class="text-left-md"><?php echo $student_class_val; ?></td></tr>
                                                        <?php }
                                                        ?>
                                                    </table>
                                                </td>
                                                
   
                                                
                              
                                  
                                                <td >
                                                    
                                                    <table width="100%"><?php foreach ($fees_type as $fees_type_val) {
                                                            ?>
                                                            <tr><td class="text-left-md"><?php echo $fees_type_val; ?></td></tr>
                                                        <?php }
                                                        ?>
                                                    </table>
                                                </td>
                                                <td ><table width="100%">

                                                    <?php foreach ($collection_by as $collection_by_val) {
                                                            ?>
                                                            <tr><td class="text-left-md"><?php echo $collection_by_val; ?> </td></tr>
                                                        <?php }
                                                        ?>
                                                    </table></td>
                                                <td >
                                                    <table width="100%"><?php foreach ($pay_mode as $pay_mode_val) {
                                                            ?>
                                                            <tr><td class="text-left-md"><?php echo $pay_mode_val; ?></td></tr>
                                                        <?php }
                                                        ?>
                                                    </table>
                                                </td>
            <!-- 🔹 Dynamically insert fee heads here -->
            
           <?php
           
           if($include_fee_head == "yes"){ 
           
        //   echo "yuvi";
           
           if (!empty($fees_heads_new)) { 
           
                foreach ($fees_heads_new as $head) { ?>
                    <td>
                       
                        
                                  <table width="100%"><?php foreach ($payment_id as $p_ides) {
                                                ?>
                                        <tr>
                                            <td style="mso-number-format:'\@'"  class="text-center">
                                                
                                                <?php echo $payment_breakdown[$p_ides][$head]; ?>
                                            
                                            </td>
                                            
                                            </tr>
                                    <?php }
                                ?></table>
                        
                    </td>
            <?php
            
                   
                }
                
                ?>
                 <td style="mso-number-format:'\@'"  class="text-center"> <?php echo $unfiltered_total_amount[$p_ides] ; ?> </td>
                <?php
                
            }
            
            }else{
                    ?>
                                         <td>
                                                    <table width="100%"><?php foreach ($payment_id as $p_ides) {
                                                ?>
                                                            <tr><td style="mso-number-format:'\@'"  class="text-center"><?php echo $payment_breakdown[$p_ides] + $discount_breakdown[$p_ides];?></td></tr>
                                                        <?php }
                                                        ?></table>
                                                </td>
                <?php
                }
            ?>

<!--ends here -->
                                            <td>
                                                    <table width="100%">
                                                        <?php foreach($payment_id as $p_ides){?>
                                                     <tr><td style="mso-number-format:'\@'"  class="text-center"><?php echo $discount_breakdown[$p_ides]; ?></td></tr>
                                                     <?php } ?>
                                                        </table>
                                                </td>
                                                 <td>
                                                    <table width="100%">
                                                        <?php foreach($payment_id as $p_ides){?>
                                                     <tr><td style="mso-number-format:'\@'"  class="text-center"><?php echo $fine_breakdown[$p_ides]; ?></td></tr>
                                                     <?php } ?>
                                                        </table>
                                                </td>
                                                 <td>
                                                    <table width="100%">
                                                        <?php foreach($payment_id as $p_ides){?>
                                                     <tr><td style="mso-number-format:'\@'"  class="text-center"><?php echo $unfiltered_total_amount[$p_ides] + $fine_breakdown[$p_ides]  ; ?></td></tr>
                                                     <?php } ?>
                                                        </table>
                                                </td>
                                                
                                       

                                            </tr>
                                            
                                            <?php
                                            $count++;
                                            if($subtotal){
                                            ?> 
                                            <tr>
                           <?php
                    if($include_fee_head == 'yes'){
                    
                    if (!empty($fees_heads_new)) { 
                foreach ($fees_heads_new as $head) { ?>
                    <td></td>
            <?php }
            
                        ?>
                         <td></td>
                        <?php
                    } 
                     }else{
                         ?>
                       <td></td> 
                       <?php
                     }
            ?>
                                                <td></td>
                                                 <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td style="font-weight:bold"><?php echo $this->lang->line('sub') . " " . $this->lang->line('total') ?></td>
                                                <td class="text text-right" style="font-weight:bold"><?php echo array_sum($amountLabel); ?></td>
                                                <td class="text text-right" style="font-weight:bold" ><?php echo array_sum($discountLabel); ?></td>
                                                <td class="text text-right" style="font-weight:bold" ><?php echo array_sum($fineLabel); ?></td>
                                                <td class="text text-right " style="font-weight:bold" ><?php echo array_sum($TotalLabel); ?></td>                                                
                                            </tr>
                                            <?php
                                        }
                                            // $grdamountLabel[] = array_sum($amountLabel);
                                            $grddiscountLabel = array_sum($discount_breakdown);
                                            $grdfineLabel = array_sum($fine_breakdown);
                                            $grdTotalLabel = array_sum($unfiltered_total_amount) +$grdfineLabel;
                                        }
                                        }
                                        ?>
                                        <tr>
                                            
                    <?php
                    if($include_fee_head == 'yes'){
                    
                    if (!empty($fees_heads_new)) { 
                foreach ($fees_heads_new as $head) { ?>
                    <td></td>
            <?php } 
                        
                        ?>
                         <td></td>
                        <?php
                        
                    } 
                     }else{
                         ?>
                       <td></td> 
                       <?php
                     }
            ?>
                                       
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                             <td></td>
                                            <td></td>
                                            <td style="font-weight:bold"><?php echo $this->lang->line('grand') . " " . $this->lang->line('total'); ?></td>
                                            
                                            <td class="text text-right" style="font-weight:bold" ><?php echo $grddiscountLabel; ?></td>
                                            <td class="text text-right" style="font-weight:bold" ><?php echo $grdfineLabel; ?></td>
                                            <td class="text text-right " style="font-weight:bold" ><?php echo $grdTotalLabel; ?></td>                                                
                                        </tr>
                                       

                                </tbody>
                            </table>
                        </div>
                    </div>
                     <?php
                                    }
                                    ?>
                </div>
            </div> 
        </div>   
</div>  
</section>
</div>
<iframe id="txtArea1" style="display:none"></iframe>
<script>
$(document).ready(function() {
    $('#fees_head_name').select2({
        placeholder: "<?php echo $this->lang->line('select'); ?>", // Placeholder text
        allowClear: true // Allow clearing of selection
    });
});
</script>
<script>
<?php
if ($search_type == 'period') {
    ?>

        $(document).ready(function () {
            showdate('period');
        });

    <?php
}
?>


    document.getElementById("print").style.display = "block";
    document.getElementById("btnExport").style.display = "block";
    document.getElementById("printhead").style.display = "none";
    
    function printDiv() {
        document.getElementById("print").style.display = "none";
        document.getElementById("btnExport").style.display = "none";
         document.getElementById("printhead").style.display = "block";
        var divElements = document.getElementById('transfee').innerHTML;
        var oldPage = document.body.innerHTML;
        document.body.innerHTML =
                "<html><head><title>Fee Collection Report</title></head><body>" +
                divElements + "</body>";
        window.print();
        document.body.innerHTML = oldPage;
        document.getElementById("printhead").style.display = "none";
        location.reload(true);
    }

    function fnExcelReport()
    {
exportToExcel();
  
        
    }




function exportToExcel(){
var htmls = "";
            var uri = 'data:application/vnd.ms-excel;base64,';
            var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'; 
            var base64 = function(s) {
                return window.btoa(unescape(encodeURIComponent(s)))
            };

            var format = function(s, c) {
                return s.replace(/{(\w+)}/g, function(m, p) {
                    return c[p];
                })
            };
        var tab_text = "<tr >";
                     var textRange;
         var j = 0;
          var val="";
         tab = document.getElementById('headerTable'); // id of table

         for (j = 0; j < tab.rows.length; j++)
         {
             
             tab_text = tab_text + tab.rows[j].innerHTML + "</tr>";
             //tab_text=tab_text+"</tr>";
       }

            var ctx = {
                worksheet : 'Worksheet',
                table : tab_text
            }


            var link = document.createElement("a");
            link.download = "studentfee_collection_report.xls";
            link.href = uri + base64(format(template, ctx));
            link.click();
}
</script>