public static function deleteFeedback($feedback_id) { if ($feedback_id === NULL) { QconfMgrLog::err(__FILE__, __LINE__, "Parameter 'feedback_id' is NULL"); return FALSE; } ArgsUtil::setVal($feedback_id); $update = "delete from qconf_feedback where feedback_id = '{$feedback_id}'"; $res = self::executeQuery($update); if ($res === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC {$update} failed!"); return FALSE; } return TRUE; }
public function checkFeedbackAction() { $node_id = $this->getRequest("node_id", ""); $idc = $this->getRequest("idc", ""); $page = $this->getRequest("page", 1); $page_count = $this->getRequest("pageCount", 20); // 1. parameter is not right if ($node_id === "" || $idc === "") { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "parameter node_id or idc is null!"); echo json_encode($res); return; } ArgsUtil::setVal($page); ArgsUtil::setVal($page_count); if ($page <= 0) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "parameter page error!"); echo json_encode($res); return; } if ($page_count < 0) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "parameter page_count error!"); echo json_encode($res); return; } // 2. idc zookeeper server not exist $idc_host = ZkConf::getZkHost($idc); if ($idc_host === NULL) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_IDC_NOT_EXIST); QconfMgrLog::err(__FILE__, __LINE__, "'{$idc}' is not int ZOOKEEPER_SVR!"); echo json_encode($res); return; } // 3. get the node info from database $dbnode = NodeServ::getNode($node_id); if ($dbnode === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_NODE_NOT_EXIST); QconfMgrLog::err(__FILE__, __LINE__, "node : {$node_id} is not exist!"); echo json_encode($res); return; } $node_whole = $dbnode["node_whole"]; $node_type_code = $dbnode["node_type_code"]; $data_type = $node_type_code == InfoDescUtil::NODE_TYPE_SERV_FATHER ? InfoDescUtil::FEEDBACK_DATA_TYPE_SERVICE : InfoDescUtil::FEEDBACK_DATA_TYPE_VALUE; $cur_node_idc = $dbnode["idc"]; $cur_idcs_array = explode(',', $cur_node_idc); $exist_idc = in_array($idc, $cur_idcs_array); if ($exist_idc === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_IDC_NOT_IN_DATABASE); QconfMgrLog::err(__FILE__, __LINE__, "node : {$node_id} does not exist on idc : {$idc}!"); echo json_encode($res); return; } // 4. get feedbacks on current node $start = ($page - 1) * $page_count; $qconf_path = PathUtil::getQconfPath($node_whole); $feedbacks = FeedbackServ::queryFeedbackByNode($qconf_path, $idc, $data_type, $start, $page_count); if ($feedbacks === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_MYSQL_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "failed to query feedbacks by node:{$node_whole},\n idc({$idc}), data_type({$data_type}), page({$page}), page_count({$page_count})!"); echo json_encode($res); return; } $total_count = FeedbackServ::feedbackAmountByNode($qconf_path, $idc, $data_type); if ($total_count === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_MYSQL_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "failed to get feedbacks amount by node:{$node_whole}, idc({$idc}), data_type({$data_type})"); echo json_encode($res); return; } // 5. calcuate value_md5 $zk_web = new QconfZkWebBase(Log::INFO); $zk_web->connect($idc_host); $retry_time = 0; if ($data_type == InfoDescUtil::FEEDBACK_DATA_TYPE_SERVICE) { // 5.1 calcuate value_md5 for service father node $services = -1; while ($services === -1 && $retry_time <= InfoDescUtil::ZK_MAX_RETRY_TIME) { QconfMgrLog::err(__FILE__, __LINE__, "retry {$retry_time} of " . InfoDescUtil::ZK_MAX_RETRY_TIME . " to get services {$node_whole} on {$idc_host}"); $services = $zk_web->get_group_services_with_status($qconf_path); $retry_time++; } if ($services === -1) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_ZOOKEEPER_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "The children of path: {$qconf_path} are null!"); echo json_encode($res); return; } ksort($services); foreach ($services as $serv => $status) { $ser_combine .= "{$serv}#{$status},"; } $ser_combine = trim($ser_combine, ','); //echo $ser_combine; $node_md5 = md5($ser_combine); } else { // 5.2 calcuate value_md5 for value $node_val = -1; while ($node_val === -1 && $retry_time <= InfoDescUtil::ZK_MAX_RETRY_TIME) { QconfMgrLog::err(__FILE__, __LINE__, "retry {$retry_time} of " . InfoDescUtil::ZK_MAX_RETRY_TIME . " to get value of {$node_whole} on {$idc}"); $node_val = $zk_web->get_conf($qconf_path); $retry_time++; } if ($node_val === -1) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_ZOOKEEPER_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "failed to get value of {$qconf_path}!"); echo json_encode($res); return; } $node_md5 = md5($node_val); } // 6. encapsulate feedback result $fd_result = array(); foreach ($feedbacks as $feedback) { $fd_one = array("feedback_id" => $feedback["feedback_id"], "hostname" => $feedback["hostname"], "ip" => $feedback["ip"], "status" => $feedback["value_md5"] == $node_md5 ? "0" : "1", "update_time" => $feedback["update_time"]); $fd_result[] = $fd_one; } $result = array("curPage" => "{$page}", "totalCount" => "{$total_count}", "listing" => $fd_result); $res = array("errno" => "0", "errmsg" => "", "data" => $result); $json = json_encode($res); echo $json; }
public static function modNodeType($parent_node_id) { if ($parent_node_id === NULL || $parent_node_id === "") { QconfMgrLog::err(__FILE__, __LINE__, "'parent_node_id' is NULL"); return FALSE; } ArgsUtil::setVal($parent_node_id); $query = "select * from qconf_node where node_id = '{$parent_node_id}'"; $res = self::executeQuery($query); if ($res === FALSE) { return FALSE; } $p_row = mysql_fetch_array($res, MYSQL_ASSOC); if ($p_row === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$query}' failed!"); return FALSE; } if ($p_row['node_type_code'] == InfoDescUtil::NODE_TYPE_NORMAL) { $update = "update qconf_node set node_type_code = '" . InfoDescUtil::NODE_TYPE_SERV_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; }
/** * insert a record into the database */ public static function insert($op_type_code, $node, $idc, $op_status_code, $main_buss_id, $sub_buss_id, $op_user, $msg) { $op_id = GuidUtil::guidGenerator(); $op_time = date('Y-m-d H:i:s', time()); ArgsUtil::setSQLEscape($op_type_code); ArgsUtil::setSQLEscape($node); ArgsUtil::setSQLEscape($idc); ArgsUtil::setSQLEscape($op_status_code); ArgsUtil::setVal($main_buss_id); ArgsUtil::setVal($sub_buss_id); ArgsUtil::setSQLEscape($op_user); ArgsUtil::setSQLEscape($msg); $query = "insert into qconf_op values (NULL, '{$op_id}', '{$op_type_code}', '{$node}', '{$idc}', '{$op_time}',\n '{$op_status_code}', {$main_buss_id}, {$sub_buss_id}, '{$op_user}', '{$msg}');"; return self::executeQuery($query); }