function group_list()
{
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$search = '%';
$table = "webfilters_sqgroups";
$page = 1;
if ($q->COUNT_ROWS($table) == 0) {
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
echo json_encode($data);
return;
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
if ($_POST["query"] != null) {
$_POST["query"] = str_replace("*", "%", $_POST["query"]);
$search = $_POST["query"];
$searchstring = "AND (`{$_POST["qtype"]}` LIKE '{$search}')";
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE enabled=1 {$FORCE_FILTER} {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
$total = $ligne["TCOUNT"];
} else {
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE enabled=1 {$FORCE_FILTER}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
$total = $ligne["TCOUNT"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
if ($OnlyEnabled) {
$limitSql = null;
}
$sql = "SELECT * FROM `{$table}` WHERE enabled=1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
$data['rows'][] = array('id' => $ligne[time()], 'cell' => array($q->mysql_error, "", "", ""));
json_encode($data);
return;
}
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
if (mysql_num_rows($results) == 0) {
$data['rows'][] = array('id' => $ligne[time()], 'cell' => array($sql, "", "", ""));
son_encode($data);
return;
}
$GroupType["src"] = "{addr}";
$GroupType["arp"] = "{ComputerMacAddress}";
$GroupType["dstdomain"] = "{dstdomain}";
$GroupType["proxy_auth"] = "{members}";
while ($ligne = mysql_fetch_assoc($results)) {
$val = 0;
$ligne['GroupName'] = utf8_encode($ligne['GroupName']);
$GroupTypeText = $tpl->_ENGINE_parse_body($GroupType[$ligne["GroupType"]]);
$select = imgtootltip("arrow-right-32.png", "{select} {$ligne['GroupName']}", "{$_GET["CallBack"]}({$ligne['ID']})");
$ligne2 = mysql_fetch_array($q->QUERY_SQL("SELECT COUNT(ID) as tcount FROM webfilters_sqitems WHERE gpid='{$ligne['ID']}'"));
$data['rows'][] = array('id' => "group{$ligne['ID']}", 'cell' => array("<span style='font-size:16px;'>{$ligne['GroupName']}</span>", "<span style='font-size:16px;'>{$GroupTypeText}</span>", "<span style='font-size:16px;'>{$ligne2['tcount']}</span>", $select));
}
echo json_encode($data);
}
function cancellive()
{
$this->NoLoginAjaxReturn();
$type = $this->QueryString('type');
$bid = $this->QueryString('bid');
if (!$type) {
$r['status'] = 'failed';
$r['message'] = '参数输入有误';
echo urldecode(son_encode(ArrayToJson($r)));
exit;
}
if (!$this->PointsLogic->CanchangeLivePoint($this->User['uid'], $type)) {
$r['status'] = 'failed';
$r['message'] = '加入一个位置满30天后才能退出';
echo urldecode(json_encode(ArrayToJson($r)));
exit;
}
$this->PointsLogic->UnSetLivePoint($this->User['uid'], $type);
$r['status'] = 'ok';
$r['message'] = '设置成功';
echo urldecode(json_encode(ArrayToJson($r)));
}
$sql = "update {$tableName} set ordstatus = {$status},expressName='{$expressName}',expressNum='{$expressNum}',handletime=" . time() . " where id=" . $id;
if (mysql_query($sql)) {
exit(json_encode(array('status' => 1)));
} else {
exit(son_encode(array('status' => 0)));
}
}
if ($res[0] == 1) {
$expressName = $_POST['expressName'];
$expressNum = $_POST['expressNum'];
$status = $status + 1;
$sql = "update {$tableName} set ordstatus = {$status},expressName='{$expressName}',expressNum='{$expressNum}' where id=" . $id;
if (mysql_query($sql)) {
exit(json_encode(array('status' => 1)));
} else {
exit(son_encode(array('status' => 0)));
}
}
if ($res[0] == 6) {
$status = $status + 1;
$sql = "update {$tableName} set ordstatus = {$status},handletime=" . time() . " where id=" . $id;
if (mysql_query($sql)) {
//将钱换回去;
/*$sql = "select shop_id,mall_id,ordfee from $tableName where id=".$id;
$res = mysql_fetch_row(mysql_query($sql));
$sql = 'update system_info set balanceMoney=balanceMoney-$res[2],useMoney=useMoney-$res[2] where id=0';
mysql_query($sql);*/
echo json_encode(array('status' => 1));
} else {
echo json_encode(array('status' => 0));
}
