"; $showDate = date("d",mktime(0,0,0,date("m"),date("d")-$sel_date,date("Y"))); $timeItem = date("Y-m-d",mktime(0,0,0,date("m"),date("d")-$sel_date,date("Y"))); $showDate = omc_keep_length($showDate,0,2); $db=$csta_db; $sort_field = 'csta_datetime'; //排序所依赖的字段名 $sort_direction = 'DESC'; //排序顺序 $number_records_to_display = 200; //每页纪录数 $time_column = "csta_datetime"; $table_name='hlrDetail'."_".$showDate; $sel_field_list= @mysql_list_fields($db,$table_name); if(!$sel_field_list) { echo "
$strNotFindRecord."; exit(); } if($language == 'eng') { $strNcmroh="Number of current MS's Roaming outside HPLMN"; $strArasrh="Attempted requests for Authentication sets"; $strSrasfh="Successful returned Authentication sets"; $strErrash="Empty responses to request for Authentication sets"; $strAisds="Attempted insert subscriber data service"; $strSisds="Successful insert subscriber data service"; $strAlu="Attempted Location Updates"; $strSlu="Successful Location Updates"; $strAsroh="Attempted SS related operations"; $strSsroh="Successful SS related operations"; $strArsri="Attempted request for SM routing information"; $strSrsri="Successful request for SM routing information"; $strAsdssp="Attempted SM delivery status report procedures"; $strSsdsrp="Successful SM delivery status report procedures"; $strAnsa="Attempted number of send alerts"; $strSnsa="Successful number of send alerts"; $strArm="Attempted request for MSRN"; $strSrm="Successful request for MSRN"; } else { $strNcmroh="Number of current MS's Roaming outside HPLMN"; $strArasrh="Attempted requests for Authentication sets"; $strSrasfh="Successful returned Authentication sets"; $strErrash="Empty responses to request for Authentication sets"; $strAisds="Attempted insert subscriber data service"; $strSisds="Successful insert subscriber data service"; $strAlu="Attempted Location Updates"; $strSlu="Successful Location Updates"; $strAsroh="Attempted SS related operations"; $strSsroh="Successful SS related operations"; $strArsri="Attempted request for SM routing information"; $strSrsri="Successful request for SM routing information"; $strAsdssp="Attempted SM delivery status report procedures"; $strSsdsrp="Successful SM delivery status report procedures"; $strAnsa="Attempted number of send alerts"; $strSnsa="Successful number of send alerts"; $strArm="Attempted request for MSRN"; $strSrm="Successful request for MSRN"; } $where = isset($where) ? urldecode($where) : ''; //传回变量后解url码 $where = isset($where) ? stripslashes($where) : ''; //解除一些'/' //删除所查询的内容 if($delete){ $sql_query="DELETE FROM $table_name ".$where; $sql_query=urlencode($sql_query); //将该字符串编码,适合传递 echo " "; }//end of delete ?> 0){ if($sel_time){ $bgn_date=date("Y-m-d H:i:s", mktime($hou_1,$mid_1,$sec_1,date("m"),date("d")-$sel_date,date("Y"))); $end_date=date("Y-m-d H:i:s", mktime($hou_2,$mid_2,$sec_2,date("m"),date("d")-$sel_date,date("Y"))); }else{ $bgn_date=date("Y-m-d H:i:s", mktime(0,0,0,date("m"),date("d")-$sel_date,date("Y"))); $end_date=date("Y-m-d H:i:s", mktime(0,0,0,date("m"),date("d")-$sel_date+1,date("Y"))); } }else{ if($sel_time){ $bgn_date=date("Y-m-d H:i:s", mktime($hou_1,$mid_1,$sec_1,date("m"),date("d")-$sel_date,date("Y"))); $end_date=date("Y-m-d H:i:s", mktime($hou_2,$mid_2,$sec_2,date("m"),date("d")-$sel_date,date("Y"))); }else{ $bgn_date=date("Y-m-d H:i:s", mktime(0,0,0,date("m"),date("d"),date("Y"))); $end_date=date("Y-m-d H:i:s", mktime()); } } /* where语句的时间限制组成部分为$w1,系统id限制为$w2 */ $w1=" $time_column >='$bgn_date' AND $time_column <= '$end_date'"; //合成where语句 $where=" WHERE".$w1; $initial_record = 0;//初始纪录号 $str_sql_all="SELECT count(*) as number_of_records FROM $table_name ".$where; $csta_result= mysqli_query($pubConn,$str_sql_all); $record = mysql_fetch_object($csta_result); $number_of_records = $record->number_of_records; if(!$number_of_records) { echo $strNotFindRecord; exit(); } }//endif $page_num= ($initial_record / $number_records_to_display) +1; //该页页码 $all_page_num= ceil($number_of_records / $number_records_to_display); //总页码 if ($number_of_records >= 1){ $next_index = $initial_record + $number_records_to_display; //本页的结束数目 if ($next_index > $number_of_records) { $next_index = $number_of_records; } $t1 = $initial_record + 1; $prev_index = $initial_record - $number_records_to_display; if ($prev_index < 0){ $prev_index = 0; } } $show_initital_record=$initial_record+1; ?> " >
 $show_initital_record - $next_index, ($strTotalRecords:$number_of_records )   "; ?>   "; //下面是控制分页显示,传递变量 if ($initial_record != 0) { $t1 = "initial_record=$prev_index&number_of_records=$number_of_records&table_name=$table_name&sel_date=$sel_date"; $where=urlencode($where); //将该字符串编码,适合传递 echo ""; ?> 前一页  0 && $number_of_records > $number_records_to_display ) { $t1 = "initial_record=$next_index&number_of_records=$number_of_records&table_name=$table_name&sel_date=$sel_date"; $where=urlencode($where); //将该字符串编码,适合传递 echo ""; ?> 下一页
"; $csta_result = mysqli_query($pubConn,$csta_sql); $csta_rows = @mysqli_fetch_array($csta_result); echo mysqli_error($pubConn); echo ""; if($call_type==0)//local management { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; do { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $tmpArray = explode(" ",$csta_rows[csta_datetime]); echo ""; echo ""; }while($csta_rows= mysqli_fetch_array($csta_result)); } elseif($call_type==1)//SM { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; do { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $tmpArray = explode(" ",$csta_rows[csta_datetime]); echo ""; echo ""; }while($csta_rows= mysqli_fetch_array($csta_result)); } elseif($call_type==2) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; do { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $tmpArray = explode(" ",$csta_rows[csta_datetime]); echo ""; echo ""; }while($csta_rows= mysqli_fetch_array($csta_result)); } ?>
$strSystem$strArasrh$strSrasfh$strErrash$strAisds$strSisds$strAlu$strSlu$strTime($timeItem)
"; echo "HLR"."_"."$csta_rows[key_sys_id]"; echo "$csta_rows[arasrh]$csta_rows[srasfh]$csta_rows[errash]$csta_rows[aisds]$csta_rows[sisds]$csta_rows[alu]$csta_rows[slu]$tmpArray[1]
$strSystem$strArsri$strSrsri$strAsdssp$strSsdsrp$strAnsa$strSnsa$strTime($timeItem)
"; echo "HLR"."_"."$csta_rows[key_sys_id]"; echo "$csta_rows[arsri]$csta_rows[srsri]$csta_rows[asdssp]$csta_rows[ssdsrp]$csta_rows[ansa]$csta_rows[snsa]$tmpArray[1]
$strSystem$strNcmroh$strAsroh$strSsroh$strArm$strSrm$strTime
"; echo "HLR"."_"."$csta_rows[key_sys_id]"; echo "$csta_rows[ncmroh]$csta_rows[asroh]$csta_rows[ssroh]$csta_rows[arm]$csta_rows[srm]$tmpArray[1]