/**
* 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;
}
