/** * list the op log */ public static function listByCondition($node, $op_user, $idc, $main_buss_id, $sub_buss_id) { ArgsUtil::setSQLEscape($node); ArgsUtil::setSQLEscape($op_user); ArgsUtil::setSQLEscape($idc); ArgsUtil::setVal($main_buss_id); ArgsUtil::setVal($sub_buss_id); $query = ArgsUtil::getSQLStatOfArgs("main_buss_id", $main_buss_id, "=", "node", $node, "like", "op_user", $op_user, "like", "idc", $idc, "like"); if ($query === FALSE) { // the argument is not right QconfMgrLog::err(__FILE__, __LINE__, "set sql statment failed!"); return FALSE; } $obj = "op_id,op_type_code,node,idc,op_time,op_status_code,main_buss_id,sub_buss_id,op_user"; if ($query !== NULL) { $query = "select {$obj} from qconf_op where " . $query . " order by op_time desc;"; } else { $query = "select {$obj} from qconf_op order by op_time desc;"; } //echo $query . PHP_EOL; // get the records from database, and resolve them $res = self::executeQuery($query); if (mysql_num_rows($res) === 0) { QconfMgrLog::err(__FILE__, __LINE__, "No value of '{$query}'"); return FALSE; } while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) { $row['msg'] = ""; $op_type_code = $row["op_type_code"]; $row["op_type_code"] = InfoDescUtil::getOpTypeDesc($op_type_code); $data[] = $row; } return $data; }