public static function insert($parent_node_id, $node, $node_type_code, $node_whole, $main_buss_id, $sub_buss_id, $idc, $note)
{
ArgsUtil::setSQLEscape($node);
ArgsUtil::setSQLEscape($node_whole);
ArgsUtil::setSQLEscape($idc);
ArgsUtil::setSQLEscape($note);
ArgsUtil::setSQLEscape($node_type_code);
ArgsUtil::setVal($parent_node_id);
ArgsUtil::setVal($main_buss_id);
$p_query = "select * from qconf_node where node_id = '{$parent_node_id}'";
$p_res = self::executeQuery($p_query);
if ($p_res === FALSE) {
return FALSE;
}
$p_num = mysql_num_rows($p_res);
if ($p_num === 0) {
QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$p_query}' failed!");
return FALSE;
}
$p_row = mysql_fetch_array($p_res, MYSQL_ASSOC);
$p_level = $p_row["node_level"];
$node_level = intval($p_level) + 1;
$cal_node_level = PathUtil::calNodeLevel($node_whole);
$query = "insert into qconf_node values(NULL, '{$parent_node_id}', '{$node}', '{$node_type_code}'," . " '{$node_whole}', '{$cal_node_level}', {$main_buss_id}, {$sub_buss_id}, '{$idc}', '{$note}')";
$ret = self::executeQuery($query);
if ($ret === FALSE) {
QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$query}' failed!");
return FALSE;
}
// update the parent node type
if ($p_row["node_type_code"] == InfoDescUtil::NODE_TYPE_NORMAL) {
$update = "update qconf_node set node_type_code = '" . InfoDescUtil::NODE_TYPE_NORMAL_FATHER . "' where node_id = '{$parent_node_id}'";
$ret = self::executeQuery($update);
if ($ret === FALSE) {
QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$update}' failed!");
return FALSE;
}
}
return TRUE;
}
