public function index() { $keywords = isset($_REQUEST['keywords']) && trim($_REQUEST['keywords']) ? trim(setFormString($_REQUEST['keywords'])) : ''; $sortby = isset($_REQUEST['sortby']) && trim($_REQUEST['sortby']) ? trim(setFormString($_REQUEST['sortby'])) : ''; $type = empty($_REQUEST['type']) ? 'guang' : setFormString($_REQUEST['type']); $this->assign('type', $type); $items_mod = D('items'); import("ORG.Util.Page"); //$sql_where = "title LIKE '%" . $keywords . "%'"; $sql_where = '1=1 AND status=1'; $sql_where .= !empty($_REQUEST['keywords']) ? " AND title LIKE '%" . trim($_REQUEST['keywords']) . "%'" : ''; $sql_where .= ' AND cid!=0'; if (isset($_GET['cid'])) { $sql_where = 'cid=0'; $this->assign('cid', 'no'); } switch ($sortby) { case 'likes': $sql_order = "likes DESC"; break; case 'time': $sql_order = "add_time DESC"; break; case 'sort_order': $sql_order = "sort_order DESC"; break; default: $sql_order = "add_time DESC"; break; } //为空的话表示不是搜索框过来的 if (empty($keywords)) { $this->nav_seo('search'); } //seo设置 $this->nav_seo('search', 'nav', 1); $this->assign('search_keywords', explode(',', $this->setting['search_words'])); $this->assign('keywords', $keywords); $this->assign('sortby', $sortby); $count = $items_mod->where($sql_where)->count(); $this->assign('items_total', $count); $this->waterfall($count, $sql_where, $sql_order); }
public function addb2cdata() { $miao_api = $this->miao_client(); //初始化api接口 $seller_list = D('seller_list'); //商家列表 $seller_cate = D('seller_cate'); //商家列表 $seller_list_cate = D('seller_list_cate'); //商家对应分类 $page_size = 20; $page = isset($_GET['page']) && intval($_GET['page']) ? intval($_GET['page']) : 1; //当前页 $date = isset($_GET['date']) && intval($_GET['date']) ? intval($_GET['date']) : date('Ymd', time()); //当前更新的时间 //调取数据入库 $data = $this->ShopListGet($miao_api, $page, $page_size); //获取api商家数据 $data = setFormString($data); //对数组进行转义 if (isset($data[0])) { foreach ($data as $k => $v) { //$cid=$value['cid']; $sid = $v['sid']; $name = $v['name']; $net_logo = $v['logo']; //如果不是二维数组,转换为二维数组 if (IsTwoArray($v['sellercats']['sellercat'])) { $v['sellercats']['sellercat'] = array($v['sellercats']['sellercat']); } $cid = ''; $_where = "sid={$sid}"; $has_data = ''; $has_data = $seller_list->where($_where)->find(); //print_r($v['sellercats']['sellercat']); if (empty($has_data)) { //判断数据是否存在如果存在则不插入数据库 if (count($v['sellercats']['sellercat']) > 0) { foreach ($v['sellercats']['sellercat'] as $value) { $Auto_increment_id = $seller_list->query('SHOW TABLE STATUS LIKE \'' . C('DB_PREFIX') . 'seller_list\''); $cate_id = $seller_cate->where("cid='{$value['cid']}'")->field('id')->find(); //分类id $list_cate_data = array('list_id' => $Auto_increment_id[0]['Auto_increment'], 'cate_id' => $cate_id['id']); $seller_list_cate->add($list_cate_data); } } } $click_url = $v['click_url']; $sort = 10; $desc = $v['desc']; if (is_array($desc)) { $desc = $name; } $status = 1; //是否免费送货 if ($v['freeshipment'] == 'False') { $freeshipment = 0; } else { $freeshipment = 1; } //是否支持分期付款 if ($v['installment'] == 'False') { $installment = 0; } else { $installment = 1; } //是否有发票 if ($v['has_invoice'] == 'False') { $has_invoice = 0; } else { $has_invoice = 1; } $cash_back_rate = $v['cashbacks']['cashback']['scope']; $_updateData = array('sid' => $sid, 'name' => $name, 'net_logo' => $net_logo, 'click_url' => $click_url, 'status' => $status, 'sort' => $sort, 'description' => $desc, 'freeshipment' => $freeshipment, 'installment' => $installment, 'has_invoice' => $has_invoice, 'cash_back_rate' => $cash_back_rate, 'update_time' => $date); if (count($has_data) > 0) { //如果有数据执行更新操作操作 $seller_list->where($_where)->save($_updateData); } else { //如果有数据执行增加操作 $seller_list->where($_where)->add($_updateData); } } $this->collect_success('正在采集第 <em class="blue">' . $page . '</em> 页,请稍后', U('seller_list/addb2cdata', array('page' => $page + 1, 'date' => $date))); } else { //采集完成删除下架商家 $seller_list_mod = D('seller_list'); $seller_list_cate_mod = D('seller_list_cate'); $rel = $seller_list_mod->where("update_time!='{$date}'")->select(); $ids = ''; foreach ($rel as $value) { $ids .= $value['id'] . ','; $seller_list_cate_mod->where("list_id='{$value['id']}'")->delete(); //删除商家信息 } $ids = substr($ids, 0, -1); $result = $seller_list_mod->delete($ids); $this->collect_success('数据同步完成', '', 'addb2cdata'); } }
public function check_code() { $verify = setFormString(trim($_GET['verify'])); if ($_SESSION['verify'] != md5(trim($_GET['verify']))) { exit('1'); //验证码不正确 } else { exit('0'); //验证码正确 } }
function setFormString($_string) { if (!get_magic_quotes_gpc()) { if (is_array($_string)) { foreach ($_string as $_key => $_value) { $_string[$_key] = setFormString($_value); //迭代调用 } } else { return addslashes($_string); //mysql_real_escape_string($_string, $_link);不支持就用代替addslashes(); } } return $_string; }
function setFormString($_string) { if (!get_magic_quotes_gpc()) { if (is_array($_string)) { foreach ($_string as $_key => $_value) { $_string[$_key] = setFormString($_value); } } else { return addslashes($_string); } } return $_string; }
public function catetaobao_collect() { if (isset($_POST['dosubmit'])) { $cate_id = isset($_POST['cid']) && intval($_POST['cid']) ? intval($_POST['cid']) : $this->error('请选择分类'); $pages = isset($_POST['pages']) && intval($_POST['pages']) ? intval($_POST['pages']) : 1; $cate_id = $_POST['cid']; $taocid = $_POST['taocid']; $start_price = $_POST['start_price']; $end_price = $_POST['end_price']; $start_commissionRate = $_POST['start_commissionRate']; $end_commissionRate = $_POST['end_commissionRate']; $start_commissionNum = $_POST['start_commissionNum']; $end_commissionNum = $_POST['end_commissionNum']; $start_totalnum = $_POST['start_totalnum']; $end_totalnum = $_POST['end_totalnum']; $levelstart = $_POST['levelstart']; $levelend = $_POST['levelend']; $keyword = $_POST['keyword']; $jump_array = array('cate_id' => $cate_id, 'taocid' => $taocid, 'start_price' => $start_price, 'end_price' => $end_price, 'start_commissionRate' => $start_commissionRate, 'end_commissionRate' => $end_commissionRate, 'start_commissionNum' => $start_commissionNum, 'end_commissionNum' => $end_commissionNum, 'start_totalnum' => $start_totalnum, 'end_totalnum' => $end_totalnum, 'levelstart' => $levelstart, 'levelend' => $levelend, 'keyword' => $keyword, 'pages' => $pages); $this->redirect('items_collect/catetaobao_collect_jump', $jump_array); } $_GET = setFormString($_GET); //淘宝分类id $taocid = $_GET['taocid']; $start_price = $_GET['start_price']; $end_price = $_GET['end_price']; $start_commissionRate = $_GET['start_commissionRate']; $end_commissionRate = $_GET['end_commissionRate']; $start_commissionNum = $_GET['start_commissionNum']; $end_commissionNum = $_GET['end_commissionNum']; $start_totalnum = $_GET['start_totalnum']; $end_totalnum = $_GET['end_totalnum']; $levelstart = $_GET['levelstart']; $levelend = $_GET['levelend']; $keyword = $_GET['keyword']; $this->assign('taocid', $taocid); $this->assign('start_price', $start_price); $this->assign('end_price', $end_price); $this->assign('start_commissionRate', $start_commissionRate); $this->assign('end_commissionRate', $end_commissionRate); $this->assign('start_commissionNum', $start_commissionNum); $this->assign('end_commissionNum', $end_commissionNum); $this->assign('start_totalnum', $start_totalnum); $this->assign('end_totalnum', $end_totalnum); $this->assign('levelstart', $levelstart); $this->assign('levelend', $levelend); $this->assign('keyword', $keyword); //获取分类 $items_cate_mod = D('items_cate'); $cate_list = $items_cate_mod->get_top2_list(); $this->assign('cate_list', $cate_list); $this->display(); }