<aside class="right-side">
    <!-- Main content -->
    <?php $general = get_general_setting();?>
    <section class="content">
        <div class="row">
            <div class="col-xs-12">
                <!-- /.box -->
                
                <div class="box box-primary">
                    
                    <!--<a class="print" style="float: right; cursor: pointer;"><img src="<?php echo base_url();?>assets/images/print.jpg" width="70px" height="35px;"/></a>-->
                    <input type="hidden" name="hidden_print" class="hidden_print" value="<?php echo (!empty($start_date)) ? 1 : 0 ;?>" />
                    
                    <div class="box-body table-responsive" style="clear:both;" id="print_data_container">
                        <div>
                        	<iframe name="report" id="report" src="#" style="display:none;"></iframe>
                            <table border="0" width="100%" style="border-collapse:collapse;">
                            <?php if( !IS_KSK ) :
                                $basic = get_basic_setting();
                                $general = get_general_setting();
                                $design = get_design_setting();
                            ?>                            
                                <tr>
                                    <td width="10%">&nbsp;</td>
                                    <td width="20%" style="border-right:1px solid #FFF;">
                                        <?php  if ((!empty($design->logo)) && (file_exists(FCPATH . DIR_COMPANY_LOGO . $design->logo))) {
                                                $image_url = DIR_COMPANY_LOGO . $design->logo;
                                                $alt = $basic->temple_name;
                                        }
                                        else {
                                                $image_url = 'assets/images/logo.png';
                                                $alt = 'Logo not found!';
                                        } ?>
                                        <div style="font-size: 14px;">
                                            <div><span style="float:left;width:155px;height:75px; margin:2px;"><img src="<?php echo $image_url;?>" alt="<?php echo $alt;?>" width="155" height="75" /></span></div>
                                        </div>
                                    </td>
                                    <td width="45%" align="center">
                                        <span style="float:left;font-family:Arial, Helvetica, sans-serif;font-weight:bold; margin-bottom: 20px;"><span style="font-size:21px;" class="lang-tamil"><?php echo $basic->tamil_name;?></span><br/><span style="font-size:13px;"><?php echo $basic->temple_name;?></span><br/><br/><span style="font-size:12px;"><?php echo nl2br($basic->address);?></span><br/><span style="font-size:12px;">Tel: <?php echo $basic->contact_no;?><?php echo (!empty($basic->fax)) ? '&nbsp; Fax: ' . $basic->fax : '';?></span> <br/><span style="font-size:12px;">Email: <?php echo $basic->comp_email;?></span><br/><span style="font-size:12px;"><?php echo $basic->website_url;?></span><br/></span>
                                    </td>
                                    <td width="15%">&nbsp;</td>
                                    <td width="10%">&nbsp;</td>
                                </tr>
                                <tr>
                                    <td colspan="5" align="center" style="font-size:16px; font-weight:bold;">Monthly Report</td>
                                </tr>
                                <tr>
                                    <td colspan="2" align="center" width="49%"><strong>Start Date : <?php echo date('d-m-Y',strtotime($start_date));?></strong></td>
                                    <td width="2%">&nbsp;</td>
                                    <td colspan="2" align="left" width="49%"><strong>End Date : <?php echo date('d-m-Y',strtotime($end_date));?></strong></td>
                                </tr>
                            <?php else : ?>
                                <tr>
                                    <td align="left" width="49%"><strong>Start Date : <?php echo date('d-m-Y',strtotime($start_date));?></strong></td>
                                    <td width="2%">&nbsp;</td>
                                    <td align="right" width="49%"><strong>End Date : <?php echo date('d-m-Y',strtotime($end_date));?></strong></td>
                                </tr>
                            <?php endif;?>
                            </table>
                            <br/>
                            
                            <!-- Filtered Columns to send JS - Start -->
                            <div class="col-xs-12" style="margin-bottom:4%; display: none;">
                               <div class="col-xs-12 blck" style="margin-bottom: -35px;">
                                    <div class="sub-title" style="color:#0B45B3; background:#f3f3f3 !important;" ><h4><i class="fa fa-fire" style="font-size: 14px;"></i> Filter Columns</h4><i class="ctrl opener opened fa fa-chevron-up" style="float: right; margin-top: -25px;"></i></div>
                                    <div class="blck-content col-xs-12" style="border-bottom: 1px inset rgba(209, 216, 216, 0.6); background: rgba(3, 12, 11, 0.05); margin-top: -15px;">
                                        <div id="grpChkBox" class="grpChkBox">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <?php foreach($filters as $key=>$val) : ?>
                                <input type="hidden" name="hidden_filter_array[]" class="hidden_filter_array" value="<?php echo $val;?>" />
                            <?php endforeach;?>
                            <!-- Filtered Columns to send JS - End -->
                            
                            
                            <?php if($dataType == 'Print Summary Data' || $dataType == 'Pdf Summary Data') { ?>
                                <table width="100%" border="1" cellpadding="3" cellspacing="0" style="font-family:'Trebuchet MS', Arial, Helvetica, sans-serif; font-size:14px; width: 100%; border-collapse:collapse;" class="filterTable" id="filterTable">
                                    <thead>
                                        <tr>
                                            <th style="padding:1%;">S.No</th>
                                            <th style="padding:1%;">Receipt No</th>
                                            <th style="padding:1%;">Name</th>
                                            <th style="padding:1%;">Quantity</th>
                                            <th style="padding:1%;">Unit Price</th>
											<?php if($general->gst > 0) { ?>
												<th  style="padding:1%;">Before GST</th>
												<th  style="padding:1%;">GST</th>
											<?php } ?>
                                            <th width="15%" style="padding:1%;">Total <?php echo ($general->gst > 0) ? '(Incl. of GST)' : '';?></th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php 
										$total_amt 			= 0;
										$before_gst_total 	= 0;
										$gst_total 			= 0;
                                        $start_date 		= (!empty($start_date)) ? $start_date : date('d-m-Y');
                                        $add_days 			= 27;
                                        $d 					= date('d-m-Y',strtotime($start_date) + (24*3600*$add_days));
                                        $end_date 			= (!empty($end_date)) ? $end_date : date('d-m-Y');
                                        if(count($results) > 0) { ?>
                                            <?php $i = 0;
                                            foreach( $results as $key => $row) :
                                                //Refund Amount
                                                $Refund = $this->monthly_model->get_refund_amt_by_ids($row['type_id'],$row['service_id'],$row['id'],$start_date,$end_date);
                                              
                                                if(!empty($Refund)) {
                                                    $recentAmt = $row['amount'] - $Refund;
                                                }
                                                else {
                                                   $recentAmt = $row['amount'];
                                                }
                                                
                                                $total_amt += $recentAmt;
                                                
                                                if(!empty($row['gst'])) {
                                                    $AmtwithGst = (($recentAmt /107) * 100); //$recentAmt * ($row['gst'] / 100);
													$gst_amt 	= number_format($recentAmt - $AmtwithGst,2,'.','');
                                                } else {
                                                    $AmtwithGst = 0;
													$gst_amt 	= 0;
                                                }
                                            ?>
                                            
                                            <?php 
												$mem_card_id = (!empty($row['mem_card_id'])) ? $row['mem_card_id'] : '';
												$auto_id = (empty($row['mem_card_id'])) ? $row['id'] : '';
												$emp_id = ''; // not necessary to send auto id
                                            ?>
                                                <tr>
                                                    <td align="center" style="padding:1%;"><?php echo ++$i;?></td>
                                                    <td style="padding:1%;"><?php echo $row['rec_no']; ?></td>
                                                    <td width="20%" style="padding:1%;"><?php echo $row['name']; ?></td>
                                                    <td align="center" style="padding:1%;"><?php echo $row['qty'];?></td>
                                                    <td align="center" style="padding:1%;"><?php echo $row['price'];?></td>
													<?php if($general->gst > 0) { ?>
                                                        <td class="align-right" align="right" style="padding:1%;">
														<?php 
															if(!empty($recentAmt)) {										
																$before_gst 		= number_format($recentAmt - $gst_amt,2,'.','');
																$before_gst_total 	= $before_gst_total + $before_gst;
																echo $before_gst;
															}else{
																echo '0.00';
															}
															?>
														</td>
                                                        <td class="align-right" align="right" style="padding:1%;">
														<?php 
															if(!empty($row['gst'])) {									
																$gst_total 	= $gst_total + $gst_amt;
																echo $gst_amt;
															}else{															
																echo '0.00';
															}
															?>
														</td>
													<?php } ?>
                                                    <td align="right" style="padding:0.8%;"><?php echo number_format($recentAmt,2,'.','');?></td>
                                                </tr>
                                            
                                            <?php endforeach; ?>
                                        <?php } else {?>
                                            <tr>
                                                <td colspan="<?php echo ($general->gst > 0) ? 8 : 6;?>" style="color: #0B6CCB;"><center>No Records Found!</center></td>
                                            </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>
                            <?php } else if($dataType == 'Print Details Data' || $dataType == 'Pdf Details Data') {?>
                                <table width="100%" border="1" cellpadding="3" cellspacing="0" style="font-family:'Trebuchet MS', Arial, Helvetica, sans-serif; font-size:14px; width: 100%; border-collapse:collapse;" class="filterTable" id="filterTable">
                                    <thead>
                                        <tr>
                                            <th width="5%" align="center" style="padding:1%;">S.No</th>
                                            <th width="14%" align="center" style="padding:1%;">Receipt No</th>
                                            <th width="23%" align="center" style="padding:1%;">Category Name</th>
                                            <th width="20%" align="center" style="padding:1%;">Sub Category Name</th>
                                            <th width="15%" align="center" style="padding:1%;">Payment Type</th>
                                            <th width="14%" align="center" style="padding:1%;">Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php $total_amt = 0;
                                        $start_date = (!empty($start_date)) ? $start_date : date('d-m-Y');
                                        $add_days = 27;
                                        $d = date('d-m-Y',strtotime($start_date) + (24*3600*$add_days));
                                        $end_date = (!empty($end_date)) ? $end_date : date('d-m-Y');
                                        if(count($results) > 0) { ?>
                                            <?php $i = 0; 
                                            foreach( $results as $key => $row) :
                                                //Refund Amount
                                                $Refund = $this->monthly_model->get_refund_amt_by_ids($row['type_id'],$row['service_id'],$row['id'],$start_date,$end_date);
                                              
                                                if(!empty($Refund)) {
                                                    $recentAmt = $row['amount'] - $Refund;
                                                }
                                                else {
                                                   $recentAmt = $row['amount'];
                                                }
                                                
                                                $total_amt += $recentAmt;
                                            ?>  
											<?php 
                                                $mem_card_id = (!empty($row['mem_card_id'])) ? $row['mem_card_id'] : '';
                                                $auto_id = (empty($row['mem_card_id'])) ? $row['id'] : '';
                                                $paymentType = $this->monthly_model->get_payment_details($row['type_id'],$auto_id,$start_date,$end_date,$mem_card_id);
                                            ?>
                                                
											<?php 
												if((!empty($row['amount_type'])) && $row['amount_type'] == 2) {
													$payType = '-';
												} elseif((!empty($row['amount_type'])) && $row['amount_type'] != 2){
													$payType = $paymentType[0]['payment'];
												} else { 
													$payType = $paymentType[0]['payment']; 
												}
                                            ?>
                                                
                                                <tr>
                                                    <td align="center" style="padding:1%;"><?php echo ++$i;?></td>
                                                    <td style="padding:1%;"><?php echo $row['rec_no']; ?></td>
                                                    <td width="25%" style="padding:1%;"><?php echo $row['cat_name']; ?></td>
                                                    <td style="padding:1%;"><?php echo $row['name'];?></td>
                                                    <td style="padding:1%;"><?php echo $payType;?></td>
                                                    <td align="right" style="padding:1%;"><?php echo number_format($recentAmt,2,'.','');?></td>
                                                </tr>
                                            
                                            <?php endforeach; ?>
                                        <?php } else {?>
                                            <tr>
                                                <td colspan="6" style="color: #0B6CCB;"><center>No Records Found!</center></td>
                                            </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>
                            <?php } ?>
                      
                            <br/>
                            
                            <table width="100%" border="1" cellpadding="3" cellspacing="0" style="font-family:'Trebuchet MS', Arial, Helvetica, sans-serif; font-size:14px; width: 100%; border-collapse:collapse;" class="filterTable" id="filterTable">
								<thead>
									<tr>
										<td width="7%" align="center" style="padding:1%;">&nbsp;</td>
										<td width="16.5%" style="padding:1%;">&nbsp;</td>
										<td width="20%" style="padding:1%;">&nbsp;</td>
										<td width="22.1%" colspan="2" align="right" style="padding:1%;">&nbsp;</td>
										<?php if($before_gst_total > 0){ ?>
										<th width="14.1%" style="padding:1%;" align="center">Before GST</th>
										<th width="6.8%" style="padding:1%;"align="center">GST</th>
										<?php } ?>
										<th width="13.5%" style="padding:1%;" align="right">Amount</th>
									</tr>
								</thead>
								<tbody>	
									<tr>
										<td width="7%" align="center" style="padding:1%;">&nbsp;</td>
										<td width="16.5%" style="padding:1%;">&nbsp;</td>
										<td width="20%" style="padding:1%;">&nbsp;</td>
										<td width="22.1%" colspan="2" align="right" style="padding:1%;">Total</td>
										<?php if($before_gst_total > 0){ ?>
											<td width="14.1%" align="right" style="padding:1%;"><?php echo number_format($before_gst_total,2,'.','');?></td>
											<td width="6.8%" align="right" style="padding:1%;"><?php echo number_format($gst_total,2,'.','');?></td>
										<?php } ?>		
										<td width="13.5%" style="padding:1%;" align="right"><?php echo number_format($total_amt,2,'.','');?></td>
									</tr> 
									<?php foreach($mode as $key=>$value) { ?>
										<?php $paidAmount = $this->monthly_model->get_total_paid_amt_by_type($value->id,$start_date,$end_date);?>
										<?php if($value->payment_mode == 'cash') { 
												$refundAmt = $this->monthly_model->get_refund_amount($start_date,$end_date);
											} else { 
												$refundAmt = '0.00';
											}
										?>
										<tr>
											<td width="7%" align="center" style="padding:1%;">&nbsp;</td>
											<td width="16%" style="padding:1%;">&nbsp;</td>
											<td width="20%" style="padding:1%;">&nbsp;</td>
											<td width="20%"  colspan="2" align="right" style="padding:1%;"><?php echo ucfirst($value->name);?> S$</td>
											<?php if($before_gst_total > 0){ ?>
											<td align="right" colspan="2" style="padding:1%;border-left:0px;">&nbsp;</td>
											<?php } ?>													
											<td align="right" style="padding:1%;"><?php echo (!empty($paidAmount->amount)) ? (($value->payment_mode == 'cash') ? number_format($paidAmount->amount - $refundAmt,2,'.','') :  $paidAmount->amount ) : '0.00';?></td>
										</tr>
									<?php } ?>
								</tbody>
							</table>
                            
                           <div style="width: 100%; float: right;">
                                <div style="float: left; clear: both; width:33.3%;">
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div><b style="font-size: 15px;">Verified By</b></div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>-----------------------------------------</div>
                               </div>
                               <div style="float: left; width:33.3%;">
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div><b style="font-size: 15px;">Approved  By</b></div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>-----------------------------------------</div>
                               </div>
                               <div style="float: left; width:33.3%;">
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div><b style="font-size: 15px;">Confirmed By</b></div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>&nbsp;</div>
                                    <div>-----------------------------------------</div>
                               </div>
                           </div>
                            
                           <div style="clear:both;"></div>
                        </div>
                    </div>
                
                    
                </div><!-- /.box -->
            </div>
        </div>
    </section><!-- /.content -->
</aside><!-- /.right-side -->
<!-- ./wrapper -->
<?php if( !IS_KSK ) : ?>
<script type="text/javascript">
    window.onload = function() {
        print_layout();
    } 
    
    $(document).ready(function(){
        $('.print').click(function(){
            print_layout();
        });
    });
    
    function print_layout() {
        var body = $('#print_data_container').html();
        var newWin = document.getElementById('report').contentWindow;
        newWin.document.write(body);
        newWin.document.close(); //important!
        newWin.focus(); //IE fix
        newWin.print();
        window.location.href="<?php echo base_url();?>monthly_report"
    } 

</script>
<?php endif; ?>