function clear() { global $_G; if (!$_GET['fid']) { cpmsg('抱歉,要清空的分类ID不存在', 'error', "m=channel&a=main"); return false; } $fid = intval($_GET['fid']); if (!$_GET['ok']) { $msg = "<p><a href='" . URL . "m=channel&a=clear&ok=1&all=1&fid=" . $fid . "'>清空当前栏目</a></p>"; $msg .= "<p><a href='" . URL . "m=channel&a=clear&ok=1&all=2&fid=" . $fid . "'>清空当前栏目和所有子栏目商品</a></p>"; cpmsg('您确定要清空当前栏目中的所商品吗?清空后不可恢复?', 'error', "m=channel&a=main", '取消', $msg); return false; } else { $channel = get_sub($fid); if (table('goods')) { if ($_GET['all'] == 1) { DB::delete("goods", "fid=" . $fid); } elseif ($_GET['all'] == 2) { DB::delete("goods", "fid in (" . $channel[fid_in] . ")"); } } $count = DB::affected_rows(); loadcache("channels", 'update'); loadcache("all_channel", 'update'); cpmsg('清空成功,共清空' . $count . '条商品', 'error', "m=channel&a=main"); return false; } }
function clear() { global $_G; if (!$_GET['id']) { cpmsg('抱歉,要清空的分类ID不存在', 'error', 'm=' . CURMODULE . '&a=cate'); return false; } $id = intval($_GET['id']); if (!$_GET['ok']) { $msg = "<p><a href='" . URL . "m=" . CURMODULE . "&a=cate_clear&ok=1&all=1&id=" . $id . "'>清空当前分类</a></p>"; $msg .= "<p><a href='" . URL . "m=" . CURMODULE . "&a=cate_clear&ok=1&all=2&id=" . $id . "'>清空当前分类和所有子分类信息</a></p>"; cpmsg('您确定要清空当前分类中的所有信息吗?清空后不可恢复?', 'error', "m=" . CURMODULE . "&a=cate", '取消', $msg); return false; } else { $cate = get_sub($id); if (table(__CLASS__)) { $tb = table($this->table); $name = 'cate'; if (array_key_exists('cid', $tb)) { $name = 'cid'; } if ($_GET['all'] == 1) { $count = DB::delete($this->table, $name . "=" . $id); } elseif ($_GET['all'] == 2) { $count = DB::delete($this->table, $name . " in (" . $cate[id_in] . ")"); } } $this->update_cache(); cpmsg('清空成功,共清空' . $count . '条', 'success', 'm=' . CURMODULE . '&a=cate'); return false; } }
<!--This is categories--> </div> <div class="col-sm-9 padding-right"> <div class="features_items "><!--features_items--> <div class="row"> <?php include 'search.php'; ?> </div> <div id="contentr" onload ="loading()"> <?php $named = $_REQUEST['names']; $named = strtoupper(str_replace("_", " ", $named)); $id = $_REQUEST['id']; get_sub($named, $id); ?> </div> </div> </div><!--featured item end--> </div><!--col-sm-9 end--> <?php include 'html/php/includes/itrend.php'; ?> </div> </section> <?php require 'html/php/includes/footer.req.php'; ?> <!--This is footer-->
function make_sql($in_talbe = '') { global $_G, $app; $get = $_GET; $in_talbe = $in_talbe ? $in_talbe : 'goods'; $and = $sort = $order = $url = ''; if (isset($get[fid]) && $get[fid] > 0) { $fid = intval($get[fid]); $fup = get_sub($fid); if ($fup && $fup[fid_in]) { $and .= " AND fid in ( " . $fup[fid_in] . " )"; } else { $and .= " AND fid =" . $fid; } $url .= "&fid=" . $fid; } if (isset($get[cate]) && $get['cate'] > 0) { $cate = intval($get['cate']); $and .= " AND cate = " . $cate; $url .= '&cate=' . $cate; } //&and = yh_price_gt_100 if (isset($get['and']) && trim($get['and'])) { $tmp = explode('_', $get['and']); if (count($tmp) == 4) { $tmp1 = array($tmp[0] . '_' . $tmp[1], $tmp[2], $tmp[3]); } else { $tmp1 = $tmp; } if (!$table) { $table = table($in_talbe); } if (array_key_exists($tmp1[0], $table)) { $and_f = ' = '; if ($tmp1[1] == 'gt') { $and_f = ' > '; } else { if ($tmp1[1] == 'lt') { $and_f = ' < '; } else { if ($tmp1[1] == 'neq') { $and_f = ' != '; } } } $and .= " AND " . $tmp1[0] . $and_f . $tmp1[2]; $url .= '&' . $get['and']; } } if (isset($get['price']) && $get['price'] > 0) { if (strpos($get[price], '_') !== false) { $price = explode('_', $get[price]); $price[0] = intval($price[0]); $price[1] = intval($price[1]); $and .= " AND yh_price >= " . $price[0] . " AND yh_price < " . $price[1]; $url .= '&price=' . $price[0] . '_' . $price[1]; } else { $price = intval($get['price']); $and .= " AND yh_price < " . $price; $url .= '&price=' . $price; } } if (isset($get['and_in']) && trim($get['and_in']) && $get[where] && array_key_exists($get[where], table('goods'))) { $and_in = trim($get['and_in']); $field = trim($get[where]); if (!$table) { $table = table($in_talbe); } if (array_key_exists($field, $table) && preg_match("/^[a-z_0-9-,.]+\$/", $and_in) && preg_match("/^[a-z_]+\$/", $get[where])) { $tmp = explode('-', $and_in); $tmp2 = explode(',', $and_in); if ($tmp && count($tmp) == 2) { $and .= " AND `{$field}` >= '" . floatval($tmp[0]) . "' AND `{$field}` <='" . floatval($tmp[1]) . "'"; } elseif ($tmp2 && count($tmp2) > 1) { $and .= " AND `{$field}` in (" . $and_in . ")"; } else { $and .= " AND `{$field}` = '" . $and_in . "'"; } $url .= "&and_in=" . $and_in . "&where=" . $get[where]; } } //sort if (isset($get['sort']) && $get['sort']) { $url .= '&sort=' . trim($get[sort]); $sort = $get['sort'] == 'asc' ? ' ASC ' : ' DESC '; } //order if ($get['order'] && preg_match("/^[a-z_]+\$/", $get['order'])) { if (!$table) { $table = table($in_talbe); } if (array_key_exists($get[order], $table)) { $order = trim($get[order]); $url .= '&order=' . $order; if (!$sort) { $sort = ' DESC '; } $order = ' `' . $order . '` ' . $sort; } } return array('and' => $and, 'url' => $url, 'order' => $order); }