<script type="text/javascript" src="<?= VIS_PATH_SCRIPT; ?>datatables/data-tables/DT_bootstrap.js"></script>
<?  
    global $vis_language;
    if($report!=-1) { 
		$total=0;$paid=0;$unpaid=0;$cancelled=0;
		for($i=0;$i<count($report);$i++) {
			if($report[$i]['invoice_status'] == 0)$unpaid +=$report[$i]['amount'];
            else if($report[$i]['invoice_status'] == 1)$paid +=$report[$i]['amount'];
			else if($report[$i]['invoice_status'] == 2)$cancelled +=$report[$i]['amount'];
			$total +=$report[$i]['amount'];
		 
		}
?>
<table cellpadding="0" cellspacing="0" border="0" class="table table-hover b-t b-light m-b-none" id="datatable">
		<thead class="table_head">
		<tr>  
			<th><? echo $vis_language['TXTTOTAL']." : ".$total.' '.$currency ; ?></th> 
			<th><? echo $vis_language['TXTTOTALPAID'].": ".$paid.' '.$currency ; ?></th>  
			  
			<th><? echo $vis_language['TXTTOTALUNPAID'].": ".$unpaid.' '.$currency ; ?></th>   
			<th><? echo $vis_language['TXTTOTALCANCELLED'].": ".$cancelled.' '.$currency;   ?></th> 
			 <th></th>
			<th></th> 
			<th></th> 
			<th></th>
			 
			    
			</tr> 
		<tr>
		    <th><? echo $vis_language['TXTREFERENCETICKET']; ?></th>
			<th><? echo $vis_language['TXTCLIENTNAME']; ?></th>
			<th><? echo $vis_language['TXTEMAIL']; ?></th>
			<th><? echo $vis_language['TXTORGN']; ?></th>
			<th><? echo $vis_language['TXTINVOICEHASH']; ?></th>
			<th><? echo $vis_language['TXTINVOICEDATE']; ?></th>
			<th><? echo $vis_language['TXTDUEDATE']; ?></th>
			<th><? echo $vis_language['TXTPAIDDATE']; ?></th>
			<th><? echo $vis_language['TXTAMOUNT'].'('.$currency.')'; ?></th>
			<th><? echo $vis_language['TXTPAIDSTATUS']; ?></th>	
			 
		</tr>
		</thead>
               
         <? $total=0;
		 $invoice_status = array( 0 => $vis_language['TXTUNPAID'], 1 => $vis_language['TXTPAID'], 2 => $vis_language['TXTCANCELED'], 3 => $vis_language['TXTINPROCESS'] );
					foreach($report as $ticket_id => $details) { 
					
					 if($details ['invoice_status'] == 0)
                        {
							$lableCol = 'vh-danger-bg';
						}
						else if($details ['invoice_status'] == 1)
						{
							$lableCol = 'label vh-green-bg';
						}
						else
						{
							$lableCol = 'label label-default';
						}			
					
					
					
					
					// $total += $details['amount'];
					echo '<tr><td>'.$details['ticket_hash'].'</td><td>'.$details['first_name'].' '.$details['last_name'].'</td><td>'.$details['email'].'</td><td>'.$details['group_name'].'</td><td>'.$details['invoice_hash'].'</td><td >'.format_datetime($details['entry_date']).'</td><td>'.format_datetime($details['due_date']).'</td><td>'.format_datetime($details['paid_date']).'</td><td>'.$details['amount'].'</td>';
					// $status=$details['invoice_status'];
					 
						//echo ($details['invoice_status']==0)?$vis_language['TXTUNPAID']:'';
						//echo ($details['invoice_status']==1)?$vis_language['TXTPAID']:'';
						//echo ($details['invoice_status']==2)?$vis_language['TXTCANCELED']:'';
					  echo '<td><span class="label '.$lableCol.'">'.$invoice_status[$details['invoice_status']].'</span></td>';
					  
					 
					 echo '  </tr>';
					
					}
					
					 
		 ?>
               
</table>
          <script>
		 	$("#vis_export_rpt_<?= $operation['vis_operation'] ?>").show(); 
		    $("#vis_export_rpt_<?= $operation['vis_operation'] ?>").html('<a href="javascript:void(0);" class="vis_button_export btn btn-primary btn-sm" data-toggle="ajaxModal" data-modal-arguments="vis_module=report&vis_operation=add_report_inqueue&vis_static_area=vis_open_new_dialog&duration=<? echo $data['duration']; ?>&from_date=<? echo strtotime($data['from_date']); ?>&to_date=<? echo strtotime($data['to_date']);?>&staff_id=<? echo $data['staff_id'];?>&domain_id=<? echo $data['domain_id'];?>&group_id=<?echo $data['group_id']; ?>&vis_client_id=<? echo $data['vis_client_id'];?>&vis_criteria=<? $data['vis_criteria'];?>&report_type=82" onclick="" type="button"><? echo $vis_language['TXTEXPORT']; ?></a>'); 
		    
		    $("#vis_schedule_rpt_<?= $operation['vis_operation'] ?>").show(); 
		    $("#vis_schedule_rpt_<?= $operation['vis_operation'] ?>").html('<a href="javascript:void(0);" class="vis_button_export btn btn-primary btn-sm" data-toggle="ajaxModal" data-modal-arguments="vis_module=report&vis_operation=add_schedule_report_inqueue&vis_static_area=vis_open_new_dialog&duration=<? echo $data['duration']; ?>&from_date=<? echo strtotime($data['from_date']); ?>&to_date=<? echo strtotime($data['to_date']);?>&staff_id=<? echo $data['staff_id'];?>&domain_id=<? echo $data['domain_id'];?>&group_id=<?echo $data['group_id']; ?>&vis_client_id=<? echo $data['vis_client_id'];?>&vis_criteria=<? $data['vis_criteria'];?>&report_type=82" onclick="" type="button"><? echo $vis_language['TXTSCHEDULE']; ?></a>'); 
		 </script> <?
    }
    else  {
		 $operation['no_record']=1;
         include(VIS_PATH_TEMPLATE.'no_record_yet.php');
        ?>	<script> $("#vis_schedule_rpt_<?= $operation['vis_operation'] ?>").hide();</script>
             <script> $("#vis_export_rpt_<?= $operation['vis_operation'] ?>").hide();</script>          
        <?php
    } ?>
	<script>
$(document).ready(function() {	
$('#totalamt').html(<?=$total?>);
$('#datatable').dataTable({		
        "bPaginate" : true,
        "aaSorting":  [],
        "iDisplayLength": <?php echo SECURITY_DATA_PER_PAGE;?>,
		"sDom": '<"top"iflp<"clear">>rt<"bottom"iflp<"clear">>', 		
	    "bFilter" : false,
		"bLengthChange": false,
		"bInfo": false,
		"aoColumns": [
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
			{ "bSortable": true },
		  	{ "bSortable": true }		
		]
	});
});	
</script>
