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