"; $DEBUG=0; $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"; //时间列名 $sysType = isset($sysType)?$sysType:$DEFAULT_SYS; //设备名 $csta_type = isset($csta_type)?$csta_type:'csta-h'; $table_name = omc_table_name($sysType,$csta_type); //取得数据库名 if($sysType == 'CNF' || $sysType == 'VPS'){ $table_name="vpsDetail"; } $table_name = $table_name."_".$showDate; $query_type = isset($query_type)?$query_type:'0'; //取得查询类型 $where = isset($where) ? urldecode($where) : ''; //传回变量后解url码 $where = isset($where) ? stripslashes($where) : ''; //解除一些'/' $sysIdFiled="key_sys_id"; $subsysIdFiled="key_subsys_id"; //echo "$table_name
"; $sel_field_list= @mysql_list_fields($db,$table_name); if(!$sel_field_list) { echo "
$strNotFindRecord."; exit(); } //删除所查询的内容 if($delete) { $sql_query="DELETE FROM $table_name ".$where; $sql_query=urlencode($sql_query); //将该字符串编码,适合传递 echo " "; }//endif($delete) //跳转到指定页面 if($go) { $initial_record = $number_records_to_display * ( $gotopage - 1 ); if($initial_record >= $number_of_records || $initial_record < 0) { echo ""; $initial_record = 0; } }//endif($go) // 初始化变量 if (!$number_of_records) { //跳转页面不进行初始化 //-------确定日期范围----- if($sel_date<0){ $bgn_date=date("Y-m-d H:i:s", mktime(0,0,0,date("m"),date("d")-6,date("Y"))); $end_date=date("Y-m-d H:i:s", mktime()); }elseif($sel_date>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语句的类型限制组成部分$w0 $w0=" key_type<17 "; //where语句的时间限制组成部分$w1 $w1=" AND $time_column > '$bgn_date' AND $time_column <= '$end_date'"; //where语句的系统id限制组成部分$w2 if($sys_num!='-1' && $sys_num!=''){ $w2=" AND $sysIdFiled=$sys_num"; } //where语句的子系统id限制组成部分$w3 if($subsys_num!='-1' && $subsys_num!=''){ $w3=" AND $subsysIdFiled=$subsys_num"; } //where语句的E1id限制组成部分$w4 if($e1_num!='-1' && $e1_num!='' && $query_type<5 && $query_type>0){ $w4=" AND key_e1_tg=$e1_num"; } //where语句的呼叫类型限制组成部分$w5 if($query_type>0) { $w5=" AND key_type=$query_type "; } if($sysType == 'VPS'){ $w6=" AND key_type=1 "; }elseif($sysType == 'CNF'){ $w6=" AND key_type=2 "; } //合成查询语句$where $where=" WHERE ".$w0.$w1.$w2.$w3.$w4.$w5.$w6; //echo "$where
"; $initial_record = 0;//初始纪录号 $str_sql_all="SELECT count(*) as number_of_records FROM $table_name ".$where; if ($DEBUG) echo "
str_sql_all=$str_sql_all"; $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(!$number_of_records) }//endif(!$number_of_records) $page_num= ($initial_record / $number_records_to_display) +1; //该页页码 $all_page_num= ceil($number_of_records / $number_records_to_display); //总页码 //插入日志 if($page_num <=1) { insertLog("CSTA data query",2,1); } //下面是控制分页显示,传递变量 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_initial_record=$initial_record+1; ?> " >
 $show_initial_record - $next_index, ($strTotalRecords:$number_of_records )  "; ?>   "; echo "\"$strPreviousPage\" "; } // NEW: Display a link for the next set of records. if ($next_index != $number_of_records && $number_of_records >0 && $number_of_records > $number_records_to_display ) { $t1 = "initial_record=$next_index&number_of_records=$number_of_records&sys_id=$sys_id&sysType=$sysType&csta_type=$csta_type&query_type=$query_type"; $where=urlencode($where); //将该字符串编码,适合传递 echo ""; echo "\"$strNextPage\""; } ?>
"; $csta_result = mysqli_query($pubConn,$csta_sql); $csta_rows = mysqli_fetch_array($csta_result); ?>
 
TG