error('没找到您要清空的采集器');
}
$tp->set_templatefile('templates/rules_clear.html');
$tp->assign('id', $rs->get('id'));
$tp->assign('ruleName', $rs->get('name'));
$tp->assign('cateName', $rs->get('cateName'));
$tp->assign('linkNum', $rs->get('link_num'));
$tp->assign('importNum', $rs->get('import_num'));
$moduleTemplate = $tp->result();
$moduleTitle = '清空采集器数据';
} else {
$NBS = new NEATBulidSql(TB_LINKS);
if ($_POST['link']) {
$NBS->setTable(TB_LINKS);
$linkFids['rules'] = $_GET['ID'];
$sql = $NBS->del($linkFids);
$NDB->query($sql);
$NBS->setTable(TB_RULES);
$conditionFids['id'] = $_GET['ID'];
$rulesFids['link_num'] = 0;
$sql = $NBS->update($rulesFids, $conditionFids);
$NDB->update($sql);
}
if ($_POST['data']) {
$NBS->setTable(TB_DATA);
$dataFids['rules'] = $_GET['ID'];
$sql = $NBS->del($dataFids);
$NDB->query($sql);
$NBS->setTable(TB_RULES);
$conditionFids['id'] = $_GET['ID'];
$rulesFids['import_num'] = 0;
error('采集器编号不能为空!');
}
if (!is_numeric($_GET['ID'])) {
error('采集器编号只能是数字!');
}
$sql = 'SELECT * ';
$sql .= 'FROM ' . TB_RULES . ' ';
$sql .= 'WHERE id = ' . $_GET['ID'];
$db = new MySQL(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$rs = $db->query($sql);
if (!$rs->next_record()) {
error('找不到编号为' . $_GET['ID'] . '的采集器规则!');
}
$NBS = new NEATBulidSql(TB_RULES);
$rulesFids['id'] = $_GET['ID'];
$sql = $NBS->del($rulesFids);
$db->query($sql);
$NBS->setTable(TB_FILTER);
$filterFids['rule_id'] = $_GET['ID'];
$sql = $NBS->del($filterFids);
$db->query($sql);
$NBS->setTable(TB_LINKS);
$linksFids['rules'] = $_GET['ID'];
$sql = $NBS->del($linksFids);
$db->query($sql);
$NBS->setTable(TB_DATA);
$dataFids['rules'] = $_GET['ID'];
$sql = $NBS->del($dataFids);
$db->query($sql);
$db->disconnect();
showloading('?module=listRules', '删除成功', '编号为 ' . $_GET['ID'] . ' 的采集器删除成功,现在返回采集器列表.');
$db->query($sql);
$NBS->setTable(TB_FILTER);
if ($_POST['filter_rule']) {
foreach ($_POST['filter_rule'] as $key => $val) {
if (!$_POST['filter_del'][$key]) {
$tmpConditionFids['id'] = $key;
$tmpFilterFids['filter_multi'] = $_POST['filter_multi'][$key];
$tmpFilterFids['filter_enter'] = $_POST['filter_enter'][$key];
$tmpFilterFids['filter_rule'] = $_POST['filter_rule'][$key];
$tmpFilterFids['filter_name'] = $_POST['filter_name'][$key];
$sql = $NBS->update($tmpFilterFids, $tmpConditionFids);
$db->query($sql);
continue;
} else {
$tmpDelFids['id'] = $key;
$sql = $NBS->del($tmpDelFids);
$db->query($sql);
continue;
}
}
}
if ($_POST['add_filter_rule']) {
foreach ($_POST['add_filter_rule'] as $k => $v) {
if ($v) {
$tmpFilterFids['filter_multi'] = $_POST['add_filter_multi'][$k];
$tmpFilterFids['filter_enter'] = $_POST['add_filter_enter'][$k];
$tmpFilterFids['filter_rule'] = $_POST['add_filter_rule'][$k];
$tmpFilterFids['filter_name'] = $_POST['add_filter_name'][$k];
$tmpFilterFids['rule_id'] = $_GET['ID'];
$sql = $NBS->add($tmpFilterFids);
$db->query($sql);
