invoices.php

来自「asterisk用 的voip记费软件」· PHP 代码 · 共 1,049 行 · 第 1/3 页

}

?>
<!-- FIN TITLE GLOBAL MINUTES //-->
<table border="0" cellspacing="1" cellpadding="2" width="70%" align="center">
	<tr>	
	<td align="center"  class="bgcolor_019"></td>
    	<td  class="bgcolor_020" align="center" colspan="4"><font color="#ffffff"><b><?php echo gettext("EXTRA CHARGE");?></b></font></td>
    </tr>
	<tr>
		<td align="right" class="bgcolor_025"><font class="fontstyle_006"><?php echo gettext("DATE");?></font></td>
        <td align="right"><font class="fontstyle_006"><?php echo gettext("NB CHARGE");?></font></td>
		<td align="right"><font class="fontstyle_006"><?php echo gettext("TOTALCOST");?></font></td>
<?php  		
		$i=0;
		foreach ($list_total_day_charge as $data){	
		$i=($i+1)%2;		
	?>
	</tr>
	<tr>
		<td align="right" class="bgcolor_026"><font class="fontstyle_006"><?php echo $data[0]?></font></td>
        <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php echo $data[2]?></font></td>
		<td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php  display_2bill($data[1]) ?></font></td>
     <?php 	 }	 	 	
	 ?>                   	
	</tr>	
	<tr  class="bgcolor_019">
		<td align="right"><font color="#ffffff"><b><?php echo gettext("TOTAL");?></b></font></td>
		<td align="center"><font color="#ffffff"><b><?php echo $totalcharge?></b></font></td>
		<td align="center"><font color="#ffffff"><b><?php  display_2bill($totalcost) ?></b></font></td>
	</tr>
</table>
	  
<?php  } ?>
<br><br><hr width="350"><br><br>
<?php 
if (is_array($list_total_destination) && count($list_total_destination)>0){

$mmax=0;
$totalcall=0;
$totalminutes=0;
$totalcost=0;
foreach ($list_total_destination as $data){	
	if ($mmax < $data[1]) $mmax=$data[1];
	$totalcall+=$data[3];
	$totalminutes+=$data[1];
	$totalcost+=$data[2];
}

?>

<!-- FIN TITLE GLOBAL MINUTES //-->
		
<table border="0" cellspacing="1" cellpadding="2" width="70%" align="center">
	<tr>	
		<td align="center"  class="bgcolor_019"></td>
    	<td  class="bgcolor_020" align="center" colspan="4"><font color="#ffffff"><b><?php echo gettext("CALLS PER DESTINATION");?></b></font></td>
    </tr>
	<tr>
		<td align="right"  class="bgcolor_025"><font class="fontstyle_006"><?php echo gettext("DESTINATION");?></font></td>
		<td align="right"><font class="fontstyle_006"><?php echo gettext("DUR");?></font></td>
        <td align="center"><font class="fontstyle_006"><?php echo gettext("GRAPHIC");?> </font> </td>
        <td align="right"><font class="fontstyle_006"><?php echo gettext("CALL");?></font></td>
		<td align="right"><font class="fontstyle_006"><?php echo gettext("TOTALCOST");?></font></td>
<?php  		
		$i=0;
		foreach ($list_total_destination as $data){	
		$i=($i+1)%2;		
		$tmc = $data[1]/$data[3];
		
		if ((!isset($resulttype)) || ($resulttype=="min")){
			$tmc = sprintf("%02d",intval($tmc/60)).":".sprintf("%02d",intval($tmc%60));		
		}else{
		
			$tmc =intval($tmc);
		}
		
		if ((!isset($resulttype)) || ($resulttype=="min")){
				$minutes = sprintf("%02d",intval($data[1]/60)).":".sprintf("%02d",intval($data[1]%60));
		}else{
				$minutes = $data[1];
		}
		if ($mmax>0) 	$widthbar= intval(($data[1]/$mmax)*200); 
		
	?>
	</tr>
	<tr>
		<td align="right" class="bgcolor_026"><font class="fontstyle_006"><?php echo $data[0]?></font></td>
		<td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php echo $minutes?> </font></td>
        <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="left">
        	<img src="<?php echo Images_Path;?>/sidenav-selected.jpg" height="6" width="<?php echo $widthbar?>">
		</td>
        <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php echo $data[3]?></font></td>
        
		<td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php  display_2bill($data[2]) ?></font></td>
     <?php 	 }	 	 	
	 	
		if ((!isset($resulttype)) || ($resulttype=="min")){
			$total_tmc = sprintf("%02d",intval(($totalminutes/$totalcall)/60)).":".sprintf("%02d",intval(($totalminutes/$totalcall)%60));				
			$totalminutes = sprintf("%02d",intval($totalminutes/60)).":".sprintf("%02d",intval($totalminutes%60));
		}else{
			$total_tmc = intval($totalminutes/$totalcall);			
		}
	 
	 ?>                   	
	</tr>	
	<tr class="bgcolor_019">
		<td align="right"><font color="#ffffff"><b><?php echo gettext("TOTAL");?></b></font></td>
		<td align="center" colspan="2"><font color="#ffffff"><b><?php echo $totalminutes?> </b></font></td>
		<td align="center"><font color="#ffffff"><b><?php echo $totalcall?></b></font></td>
		<td align="center"><font color="#ffffff"><b><?php  display_2bill($totalcost) ?></b></font></td>
	</tr>
</table>
<br><hr width="350"><br><br>
<table width="100%">
<tr>
<?php if (SHOW_ICON_INVOICE){?><td align="left"><img src="<?php echo Images_Path;?>/stock_landline-phone.jpg"/> </td>
<?php } ?>
<td class="invoices_table4_td1"><font ><?php echo gettext("B I L L &nbsp;&nbsp;  E V O L U T I O N");?> </td>
</tr>
</table>
<br><br>

<?php 
if (is_array($list_total_day) && count($list_total_day)>0){

$mmax=0;
$totalcall=0;
$totalminutes=0;
$totalcost=0;
foreach ($list_total_day as $data){	
	if ($mmax < $data[1]) $mmax=$data[1];
	$totalcall+=$data[3];
	$totalminutes+=$data[1];
	$totalcost+=$data[2];
}

?>

<!-- FIN TITLE GLOBAL MINUTES //-->
<table border="0" cellspacing="1" cellpadding="2" width="70%" align="center">
	<tr>	
		<td align="center" class="bgcolor_019"></td>
    	<td class="bgcolor_020" align="center" colspan="4"><font color="#ffffff"><b></b></font></td>
    </tr>
	<tr>
		<td align="right" class="bgcolor_025"><font class="fontstyle_006"><?php echo gettext("DATE");?></font></td>
		<td align="right"><font class="fontstyle_006"><?php echo gettext("DUR");?> </font></td>
        <td align="center"><font class="fontstyle_006"><?php echo gettext("GRAPHIC");?> </font> </td>
        <td align="right"><font class="fontstyle_006"><?php echo gettext("CALL");?></font></td>
		<td align="right"><font class="fontstyle_006"><?php echo gettext("TOTALCOST");?></font></td>
	 
<?php  		
		$i=0;
		foreach ($list_total_day as $data){	
		$i=($i+1)%2;		
		$tmc = $data[1]/$data[3];
		
		if ((!isset($resulttype)) || ($resulttype=="min")){
			$tmc = sprintf("%02d",intval($tmc/60)).":".sprintf("%02d",intval($tmc%60));		
		}else{
		
			$tmc =intval($tmc);
		}
		
		if ((!isset($resulttype)) || ($resulttype=="min")){
				$minutes = sprintf("%02d",intval($data[1]/60)).":".sprintf("%02d",intval($data[1]%60));
		}else{
				$minutes = $data[1];
		}
		if ($mmax>0) 	$widthbar= intval(($data[1]/$mmax)*200); 
		
	?>
	</tr>
	<tr>
		<td align="right"  class="bgcolor_026"><font class="fontstyle_006"><?php echo $data[0]?></font></td>
		<td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php echo $minutes?> </font></td>
        <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="left">
        	<img src="<?php echo Images_Path;?>/sidenav-selected.jpg" height="6" width="<?php echo $widthbar?>">
		</td>
        <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php echo $data[3]?></font></td>
		<td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right"><font class="fontstyle_006"><?php  display_2bill($data[2]) ?></font></td>
     <?php 	 }	 	 	
		if ((!isset($resulttype)) || ($resulttype=="min")){
			$total_tmc = sprintf("%02d",intval(($totalminutes/$totalcall)/60)).":".sprintf("%02d",intval(($totalminutes/$totalcall)%60));				
			$totalminutes = sprintf("%02d",intval($totalminutes/60)).":".sprintf("%02d",intval($totalminutes%60));
		}else{
			$total_tmc = intval($totalminutes/$totalcall);			
		}
	 
	 ?>                   	
	</tr>	
	<tr class="bgcolor_019">
		<td align="right"><font color="#ffffff"><b><?php echo gettext("TOTAL");?></b></font></td>
		<td align="center" colspan="2"><font color="#ffffff"><b><?php echo $totalminutes?> </b></font></td>
		<td align="center"><font color="#ffffff"><b><?php echo $totalcall?></b></font></td>
		<td align="center"><font color="#ffffff"><b><?php  display_2bill($totalcost) ?></b></font></td>
	</tr>
</table>
	  
<?php  } ?>


<br><br><hr width="350"><br><br>

<table width="100%">
<tr>
<?php if (SHOW_ICON_INVOICE){?> <td align="left"><img src="<?php echo Images_Path;?>/kfind.jpg"/> </td> 
<?php } ?>
<td  class="invoices_table4_td1"><?php echo gettext("C A L L S &nbsp;&nbsp;  D E T A I L");?> </td>
</tr>
</table>
<br><br>
<!-- ** ** ** ** ** Part to display the CDR ** ** ** ** ** -->
		<center><?php echo gettext("Number of call");?> : <?php  if (is_array($list) && count($list)>0){ echo $nb_record; }else{echo "0";}?></center>
		<TABLE border=0 cellPadding=0 cellSpacing=0 width="<?php echo $FG_HTML_TABLE_WIDTH?>" align="center">
                <TR class="bgcolor_008"> 
		  <TD width="7%" class="tableBodyRight" style="PADDING-BOTTOM: 2px; PADDING-LEFT: 2px; PADDING-RIGHT: 2px; PADDING-TOP: 2px">nb</TD>					
                  <?php 
				  	if (is_array($list) && count($list)>0){
				  		for($i=0;$i<$FG_NB_TABLE_COL;$i++){ 
					?>				
                  <TD width="<?php echo $FG_TABLE_COL[$i][2]?>" align=middle class="tableBody" style="PADDING-BOTTOM: 2px; PADDING-LEFT: 2px; PADDING-RIGHT: 2px; PADDING-TOP: 2px"> 
                    <center>
                    <?php echo $FG_TABLE_COL[$i][0]?> 
                  </center></TD>
				   <?php } ?>		
				   <?php if ($FG_DELETION || $FG_EDITION){ ?>
				   <?php } ?>		
                </TR>
				<?php
				  	 $ligne_number=0;					 
				  	 foreach ($list as $recordset){ 
						 $ligne_number++;
				?>
               		 <TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>"> 
			<TD align="<?php echo $FG_TABLE_COL[$i][3]?>" class=tableBody><?php  echo $ligne_number+$current_page*$FG_LIMITE_DISPLAY; ?></TD>
				  		<?php for($i=0;$i<$FG_NB_TABLE_COL;$i++){ 
							if ($FG_TABLE_COL[$i][6]=="lie"){
								$instance_sub_table = new Table($FG_TABLE_COL[$i][7], $FG_TABLE_COL[$i][8]);
								$sub_clause = str_replace("%id", $recordset[$i], $FG_TABLE_COL[$i][9]);
								$select_list = $instance_sub_table -> Get_list ($DBHandle, $sub_clause, null, null, null, null, null, null);
								$field_list_sun = split(',',$FG_TABLE_COL[$i][8]);
								$record_display = $FG_TABLE_COL[$i][10];
								for ($l=1;$l<=count($field_list_sun);$l++){													$record_display = str_replace("%$l", $select_list[0][$l-1], $record_display);	
								}
							}elseif ($FG_TABLE_COL[$i][6]=="list"){
									$select_list = $FG_TABLE_COL[$i][7];
									$record_display = $select_list[$recordset[$i]][0];
							}else{
									$record_display = $recordset[$i];
							}
							
							if ( is_numeric($FG_TABLE_COL[$i][5]) && (strlen($record_display) > $FG_TABLE_COL[$i][5])  ){
								$record_display = substr($record_display, 0, $FG_TABLE_COL[$i][5]-3)."";  
							}
							
				 		 ?>
                 		 <TD align="<?php echo $FG_TABLE_COL[$i][3]?>" class=tableBody><?php 
						 if (isset ($FG_TABLE_COL[$i][11]) && strlen($FG_TABLE_COL[$i][11])>1){
						 		call_user_func($FG_TABLE_COL[$i][11], $record_display);
						 }else{
						 		echo stripslashes($record_display);
						 }						 
						 ?></TD>
				 		 <?php  } ?>
                  
					</TR>
				<?php
					 }//foreach ($list as $recordset)
					 if ($ligne_number < $FG_LIMITE_DISPLAY)  $ligne_number_end=$ligne_number +2;
					 while ($ligne_number < $ligne_number_end){
					 	$ligne_number++;
				?>
					<TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>"> 
				  		<?php for($i=0;$i<$FG_NB_TABLE_COL;$i++){ 
				 		 ?>
                 		 <TD>&nbsp;</TD>
				 		 <?php  } ?>
                 		 <TD align="center">&nbsp;</TD>				
					</TR>
									
				<?php					 
					 } //END_WHILE
					 
				  }else{
				  		echo gettext("No data found !!!");				  
				  }//end_if
				 ?>
            </TABLE>

<?php  if (is_array($list) && count($list)>0 && 3==4){ ?>
<!-- ************** TOTAL SECTION ************* -->
			<br/>
			<div style="padding-right: 15px;">
			<table cellpadding="1" bgcolor="#000000" cellspacing="1" width="<?php if ($_SESSION["is_admin"]==1){ ?>450<?php }else{?>200<?php }?>" align="right">
				<tbody>
                <tr class="form_head">                   									   
				   <td width="33%" align="center" class="tableBodyRight" bgcolor="#600101" style="padding: 5px;"><strong><?php echo gettext("TOTAL COSTS");?></strong></td>
				   <?php if ($_SESSION["is_admin"]==1){ ?><td width="33%" align="center" class="tableBodyRight" bgcolor="#600101" style="padding: 5px;"><strong><?php echo gettext("TOTAL BUYCOSTS");?></strong></td><?php }?>
				   <?php if ($_SESSION["is_admin"]==1){ ?><td width="33%" align="center" class="tableBodyRight" bgcolor="#600101" style="padding: 5px;"><strong><?php echo gettext("DIFFERENCE");?></strong></td><?php }?>
                </tr>
				<tr>
				  <td valign="top" align="center" class="tableBody" bgcolor="white"><b><?php echo $total_cost[0][0]?></b></td>
				  <?php if ($_SESSION["is_admin"]==1){ ?><td valign="top" align="center" class="tableBody" bgcolor="#66FF66"><b><?php echo $total_cost[0][1]?></b></td><?php }?>
				  <?php if ($_SESSION["is_admin"]==1){ ?><td valign="top" align="center" class="tableBody" bgcolor="#FF6666"><b><?php echo $total_cost[0][0]-$total_cost[0][1]?></b></td><?php }?>

				</tr>
			</table>
			</div>
			<br/><br/>
					
<!-- ************** TOTAL SECTION ************* -->
<?php  } ?>

<!-- ** ** ** ** ** Part to display the GRAPHIC ** ** ** ** ** -->
<br><br>

<?php  }else{ ?>
	<center><h3><?php echo gettext("No calls in your selection");?>.</h3></center>
<?php  } ?>
</center>

<?php  

if($exporttype!="pdf"){ 
	
	// SHOT FOOTER PAGE
	$smarty->display('footer.tpl');

}else{

	// EXPORT TO PDF
	$html = ob_get_contents();
	// delete output-Buffer
	ob_end_clean();
	
	$pdf = new HTML2FPDF();
	$pdf -> DisplayPreferences('HideWindowUI');
	
	$pdf -> AddPage();
	$pdf -> WriteHTML($html);
	$html = ob_get_contents();
	
	$pdf->Output('CC_invoice_'.date("d/m/Y-H:i").'.pdf', 'I');	
} 

?>