sysId=$sysId"; $sysIdArr=explode('_',$sysId); $sysTypeNo=$sysIdArr[0]; $sysNo=$sysIdArr[1]; // echo "sysTypeNo=$sysTypeNo,sysNo=$sysNo"; } //overview statistic webpage if(isset($overview)){ if($DEBUG) echo "****************** Overview **********************
"; switch($sysTypeNo){ case '330': //HLR //select HLR subscriber count $selSql = "SELECT count(*) FROM $tableName"; if($DEBUG) echo "
selSql=$selSql"; $result=@mysqli_query($pubConn,$selSql); echo mysqli_error($pubConn); $record = @mysqli_fetch_array($result); $nHlrSubscriber = $record[0]; if($DEBUG) echo "
nHlrSubscriber=$nHlrSubscriber"; //select postpaid subscriber total //camel_flag: //highest bit=1 => Enable Prepaid; highest bit=0 => Disable Postpaid $nPrepaidTotal = 0; $nPostTotal = 0; $nGprs = 0; $nNoGprs = 0; $nBoth = 0; $selSql = "SELECT camel_flag,nam FROM $tableName"; if($DEBUG) echo "
selSql=$selSql"; $result=@mysqli_query($pubConn,$selSql); echo mysqli_error($pubConn); $record = @mysqli_fetch_array($result); do{ $flag = substr($record[camel_flag],0,1); //prepaid subscriber if('8'==$flag){ $nPrepaidTotal++; } //postpaid subscriber elseif('0'==$flag){ $nPostTotal++; } $nam = $record[nam] - 0; if (1 == $nam){ $nNoGprs++; }elseif (2 == $nam){ $nGprs++; }elseif (0 == $nam){ $nBoth++; } }while($record=@mysqli_fetch_array($result)); if($DEBUG) echo "
nPrepaidTotal=$nPrepaidTotal,nPostTotal=$nPostTotal"; if($DEBUG) echo "
nNoGprs=$nNoGprs,nGprs=$nGprs,nBoth=$nBoth"; echo "HLR subscriber statistics
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

HLR subscriber		$nHlrSubscriber
Postpay subscriber	Prepay subscriber	Only non-GPRS subscriber	Only GPRS subscriber	Both GPRS and non-GPRS subscriber
$nPostTotal	$nPrepaidTotal	$nNoGprs	$nGprs	$nBoth

"; break; case '360': //PPS case '395': //total pps subscriber $selSql = "SELECT count(*) FROM $tableName"; if($DEBUG) echo "
selSql=$selSql"; $result=@mysqli_query($pubConn,$selSql); echo mysqli_error($pubConn); $record = @mysqli_fetch_array($result); $nPpsAmount = $record[0]; if($DEBUG) echo "
nPpsAmount=$nPpsAmount"; //statistics by all kinds of types $nFresh=0; $nUsed=0; $nSuspend=0; $nBlacklist=0; $nRelease=0; $nLowbalance=0; if(0==$dataTypeNo){ $selSql = "SELECT status FROM $tableName"; if($DEBUG) echo "
selSql=$selSql"; $result=@mysqli_query($pubConn,$selSql); echo mysqli_error($pubConn); $record = @mysqli_fetch_array($result); do{ switch($record[0]){ case "00": $nFresh++; break; case "01": $nUsed++; break; case "02": $nSuspend++; break; case "03": $nBlacklist++; break; case "04": $nRelease++; break; case "05": $nLowbalance++; break; default: break; } }while( $record=@mysqli_fetch_array($result) ); if($DEBUG) echo "
nFresh=$nFresh,nSuspend=$nSuspend,nBlacklist=$nBlacklist,nRelease=$nRelease,nLowbalance"; //display echo "PPS subscriber statistics
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Prepaid subscriber	$nPpsAmount
Fresh	$nFresh
Normal	$nUsed
Suspend	$nSuspend
Blacklist	$nBlacklist
Release	$nRelease
Low balance	$nLowbalance

"; } else{ $selSql = "SELECT card_status FROM $tableName"; if($DEBUG) echo "
selSql=$selSql"; $result=@mysqli_query($pubConn,$selSql); echo mysqli_error($pubConn); $record = @mysqli_fetch_array($result); do{ if(0==$record[0]){ $nFresh++; } else{ $nUsed++; } }while( $record=@mysqli_fetch_array($result) ); if($DEBUG) echo "
nFresh=$nFresh,nUsed=$nUsed"; //display echo "PPS Recharge card statistics
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Recharge card	$nPpsAmount
Fresh	$nFresh
Used	$nUsed

"; } break; default: break; } exit(0); } if ( isset($searchInServer) ) { if ($DEBUG) { echo "****************** Search in server **********************
"; echo "$targetPage?sysId=$sysId&dataTypeNo=$dataTypeNo&keyValue=$selKeyValue&canSetNum=$canSetNum&isRead=1
"; } ?>