<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;$inprocess=0;
		 
		for($i=0;$i<count($report);$i++) {
			
			//print_r($report);
			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'];
			else if($report[$i]['invoice_status'] == 3 )$inprocess +=$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><? echo $vis_language['TXTTOTALINPROCESS'].": ".$inprocess.' '.$currency;   ?></th> 
			<th></th>
			<th></th>
			<th></th>
		</tr> 
			 
		<tr>
			 
			
				<th><? echo $vis_language['TXTORDERID']; ?></th>
				<th><? echo $vis_language['TXTINVOICEHASH']; ?></th>
				<th><? echo $vis_language['TXTCLIENTNAME']; ?></th>
				<th><? echo $vis_language['TXTEMAIL']; ?></th>
				<th><? echo $vis_language['TXTORGN']; ?></th>
				<th><? echo $vis_language['TXTCREATEDATE']; ?></th>
				<th><? echo $vis_language['TXTDUEDATE']; ?></th>
				<th><? echo $vis_language['TXTPAIDDATE']; ?></th>
				<th><? echo $vis_language['TXTAMOUNT'].' ('.$currency.')'; ?></th>
				<th><? echo $vis_language['TXTSTATUS']; ?></th>	
				<th></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';
						}	
						echo '<tr><td>'.$details['order_id'].'</td><td><a href="#/billing/edit_invoice/invoices/'.$details['invoice_id'].'">'.$details['invoice_hash'].'</a></td><td>'.$details['first_name'].' '.$details['last_name'].'</td><td>'.$details['email'].'</td><td>'.$details['group_name'].'</td><td>'.format_datetime($details['entry_date']).'</td></td><td>'.format_datetime($details['due_date']).'</td><td>'.format_datetime($details['paid_date']).'</td>   <td>'.$details['amount'].'</td>    ';
						 
						echo '<td><span class="label '.$lableCol.'">'.$invoice_status[$details['invoice_status']].'</span></td>';
						
						echo '<td></td></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'];?>&department_id=<? echo $data['department_id'];?>&vis_status_id=<?echo $data['status_id']; ?>&vis_client_id=<? echo $data['vis_client_id'];?>&vis_criteria=<? $data['vis_criteria'];?>&report_type=29" 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'];?>&department_id=<? echo $data['department_id'];?>&vis_status_id=<?echo $data['status_id']; ?>&vis_client_id=<? echo $data['vis_client_id'];?>&vis_criteria=<? $data['vis_criteria'];?>&report_type=29" onclick="" type="button"><? echo $vis_language['TXTSCHEDULE']; ?></a>'); 
		 </script> <?
    }
    else  {
		 $operation['no_record']=1;
         include(VIS_PATH_TEMPLATE.'no_record_yet.php');
        ?>
             <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>
