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