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