cc_entity_service_details.php

asterisk用 的voip记费软件

<?php 
include ("../lib/defines.php");
include ("../lib/module.access.php");
include ("../lib/smarty.php");

if (! has_rights (ACX_CRONT_SERVICE)){ 
	   Header ("HTTP/1.0 401 Unauthorized");
	   Header ("Location: PP_error.php?c=accessdenied");	   
	   die();	   
}

getpost_ifset(array('id', 'displayheader', 'displayfooter', 'popup_select'));

$FG_DEBUG = 0;


$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#F2F2EE";
$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#FCFBFB";
		

$FG_TABLE_COL=array();

$FG_TABLE_COL[]=array (gettext("DATE"), "date", "50%", "center", "sort", "30", "", "", "", "", "", "display_dateformat");
$FG_TABLE_COL[]=array (gettext("TOTALCARDPERFORM"), "totalcardperform", "20%", "center", "sort");
$FG_TABLE_COL[]=array (gettext("TOTALCREDIT"), "totalcredit", "20%", "center", "sort");
			
//$FG_TABLE_COL[]=array ("RESELLER", "RESELLER", "30%", "center", "sort");

$FG_NB_TABLE_COL=count($FG_TABLE_COL);




if (!isset ($current_page) || ($current_page == "")){	
		$current_page=0; 
	}

$DBHandle  = DbConnect();


/*******************   SERVICE INFO  *****************************************/

$QUERY = "SELECT id, name, numberofrun, datelastrun, totalcredit, totalcardperform from cc_service WHERE id='$id'";
$res = $DBHandle -> Execute($QUERY);
if ($res){
	$num = $res -> RecordCount( );		

	for($i=0;$i<$num;$i++)
	{		
		$list_service [] =$res -> fetchRow();			
	}
}

	   
/*******************  LIST REFILL  *****************************************/
		

$QUERY = "SELECT  t3.daterun, t3.totalcardperform, t3.totalcredit from cc_service_report as t3 WHERE t3.cc_service_id='$id'";


$QUERY.=" ORDER BY t3.id DESC";
if (DB_TYPE == "postgres"){
	$QUERY .= " LIMIT 25 OFFSET 0";			
}else{
	$QUERY .= " LIMIT 0, 25";			
}
if ($FG_DEBUG > 0)   echo $QUERY ;

$res = $DBHandle -> Execute($QUERY);
if ($res){
	$num = $res -> RecordCount( );		

	for($i=0;$i<$num;$i++)
	{		
		$list [] =$res -> fetchRow();			
	}
}

?>

<?php
	$smarty->display('main.tpl');
?>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}

function openURL(theLINK)
{
      // grab index number of the selected option
      selInd = document.theForm.choose_list.selectedIndex;
      // get value of the selected option
      goURL = document.theForm.choose_list.options[selInd].value;
      // redirect browser to the grabbed value (hopefully a URL)	  
      self.location.href = theLINK + goURL;
}

//-->
</script>
	
	  
<center><b><?php echo gettext("SERVICE NAME")?>&nbsp; :	<?php echo $list_service [0][1] ?></b>
<br>
<?php echo gettext("NUMBEROFRUN")." :".$list_service [0][2] ?>
<?php echo " - ".gettext("DATELASTRUN")." :".$list_service [0][3] ?>
<?php echo " <br> ".gettext("TOTALCREDIT")." :".$list_service [0][4] ?>
<?php echo " - ".gettext("TOTALCARDPERFORM")." :".$list_service [0][5] ?>

</center>
	  <table width="100%">
	  <TR> 
          <TD style="border-bottom: medium dotted #667766">&nbsp; </TD>
        </TR>
      </table>
	  
	   <table cellPadding=2 cellSpacing=2 width="100%" align=center><tr><td align=center>
	  <?php

				$color="red";
				$ttitle=gettext("SERVICE REPORT");
				
				
	  			if ((count($list )>0) && is_array($list )){
	  ?>
				  
	    <div class="scroll">
      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" >
		<TR> 
          <TD> 	
		  <TABLE border=0 cellPadding=1 cellSpacing=1 width="100%">
			<TBODY>
				   <TR bgcolor=<?php echo $color?>> 
        			  <TD align=center colspan=<?php echo $FG_NB_TABLE_COL?>> <?php echo $ttitle?></TD>
		        </TR>

                <TR class="form_head"> 
                  <?php 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"> 
                    <strong> 
                    <?php  if (strtoupper($FG_TABLE_COL[$i][4])=="SORT"){?>
                    <span class="white_link"><?php  } ?>
                    <?php echo $FG_TABLE_COL[$i][0]?> 
                    <?php if ($order==$FG_TABLE_COL[$i][1] && $sens=="ASC"){?>
                    &nbsp;<img src="<?php echo Images_Path;?>/icon_up_12x12.GIF" width="12" height="12" border="0"> 
                    <?php }elseif ($order==$FG_TABLE_COL[$i][1] && $sens=="DESC"){?>
                    &nbsp;<img src="<?php echo Images_Path;?>/icon_down_12x12.GIF" width="12" height="12" border="0"> 
                    <?php }?>
                    <?php  if (strtoupper($FG_TABLE_COL[$i][4])=="SORT"){?>
                    </span>
                    <?php }?>
                    </strong></TD>
				   <?php } ?>	
				   
				   
                </TR>
                
				<?php
				
				  	 $ligne_number=0;					 
					 
				  	 foreach ($list as $recordset){ 
						 $ligne_number++;
				?>
				
					<TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>"  onmouseover="bgColor='#FFDEA6'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>'"> 
					
				  		<?php for($i=0;$i<$FG_NB_TABLE_COL;$i++){ 
							//$FG_TABLE_COL[$i][1];			
							//$FG_TABLE_COL[]=array ("Name", "name", "20%");
							
							
							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 vAlign=top align="<?php echo $FG_TABLE_COL[$i][3]?>" class=tableBody><?php 
						 $FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2];
						 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  } ?>
						 <?php  if ($_SESSION["is_admin"]==1 && 1==3){ 	?>
						 <TD vAlign=top align="<?php echo $FG_TABLE_COL[$i][3]?>" class=tableBody><?php  echo findkey($list_reseller, $recordset[2]);?></TD>
						 <?php  } ?>
					 
				  
					</TR>
				<?php
					 }//foreach ($list as $recordset)
					 if ($ligne_number < $FG_LIMITE_DISPLAY){
					 	$ligne_number++;
				?>
					<TR bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>"> 
				  		<?php for($i=0;$i<$FG_NB_TABLE_COL-1;$i++){ 
				 		 ?>
                 		 <TD vAlign=top class=tableBody>&nbsp;</TD>
				 		 <?php  } ?>
                 		 <TD align="center" vAlign=top class=tableBodyRight>&nbsp;</TD>				
					</TR>
									
				<?php					 
					 } //END_WHILE
					
				 ?>
                <!-- 
                <TR> 
                  <TD class=tableDivider colSpan=<?php echo $FG_TOTAL_TABLE_COL?>><IMG height=1 
                              src="../Images/clear.gif" 
                              width=1></TD>
                </TR>-->
              </TBODY>
            </TABLE></td>
        </tr>
		<TR>
			<TD>
					
			<!-- ************** TOTAL SECTION ************* -->
			
			</TD>
		</TR>	
      </table>
 </div>	  
	  <?php 
	  		}else{
	  ?>
	  	  <br/></br>
		  <table width="100%" border="0" align="center" class="bgcolor_006">
			<tr>
			  <td align="center">
				<?php echo gettext("NOTHING FOUND")?>&nbsp; !<br/> 
			</td>
			</tr>
		  </table>
		 
		  <br/><br/>
	   </div>
	  <?php 				
			}//end_if
	  ?>
	    </td></tr></table>
	  
	 
	 
<?php
	$smarty->display('footer.tpl');
?>