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