public function index()
 {
     $prefix = C(DB_PREFIX);
     if (input("request.sort", 'trim')) {
         $sort = input("request.sort", 'trim');
     } else {
         $sort = $prefix . 'item_comment.id';
     }
     if (input("request.order", 'trim')) {
         $order = input("request.order", 'trim');
     } else {
         $order = 'DESC';
     }
     $p = input('get.p', 'intval', 1);
     $this->assign('p', $p);
     $where = '1=1';
     $keyword = input('request.keyword', 'trim', '');
     $keyword && ($where .= " AND ((" . $prefix . "user.username LIKE '%" . $keyword . "%') OR (" . $prefix . "item.title LIKE '%" . $keyword . "%') OR (" . $prefix . "item_comment.info LIKE '%" . $keyword . "%') )");
     $search = array();
     $keyword && ($search['keyword'] = $keyword);
     $this->assign('search', $search);
     $count = $this->_mod->join($prefix . 'user ON ' . $prefix . 'user.id=' . $prefix . 'item_comment.uid')->join($prefix . 'item ON ' . $prefix . 'item.id=' . $prefix . 'item_comment.item_id')->where($where)->count($prefix . 'item_comment.id');
     $pager = new \Common\ORG\Page($count, 20);
     $list = $this->_mod->field($prefix . 'item_comment.*,' . $prefix . 'user.username,' . $prefix . 'item.title as item_name,' . $prefix . 'item.img')->join($prefix . 'user ON ' . $prefix . 'user.id=' . $prefix . 'item_comment.uid')->join($prefix . 'item ON ' . $prefix . 'item.id=' . $prefix . 'item_comment.item_id')->where($where)->order($sort . ' ' . $order)->limit($pager->firstRow . ',' . $pager->listRows)->select();
     $this->assign('list', $list);
     $this->assign('page', $pager->show());
     $this->assign('list_table', true);
     $this->display();
 }
Пример #2
0
 public function log()
 {
     $useracc = M('user_acclog');
     if ($keyword = input('request.keyword', 'trim')) {
         $map['_string'] = "username like '%" . $keyword . "%' ";
     }
     if ($fl = input('request.fl', 'trim')) {
         if (!empty($fl)) {
             $map['fl'] = $fl;
         }
     }
     $count = $useracc->where($map)->count();
     // 查询满足要求的总记录数 $map表示查询条件
     $Page = new \Common\ORG\Page($count);
     // 实例化分页类 传入总记录数
     $show = $Page->show();
     // 分页显示输出
     // 进行分页数据查询
     $list = $useracc->where($map)->order('logid desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
     $this->assign('list', $list);
     // 赋值数据集
     $this->assign('page', $show);
     // 赋值分页输出
     $this->display();
 }
Пример #3
0
 /**
  * 专辑审核
  */
 public function check()
 {
     $res = $this->_cate_mod->field('id,name')->select();
     $album_cate = array();
     foreach ($res as $val) {
         $album_cate[$val['id']] = $val['name'];
     }
     $this->assign('album_cate', $album_cate);
     $cate_list = D('album_cate')->select();
     $this->assign('cate_list', $cate_list);
     $map = $this->_search();
     $map['status'] = 0;
     ($cate_id = input('request.cate_id', 'trim')) && ($map['cate_id'] = array('eq', $cate_id));
     ($keyword = input('request.keyword', 'trim')) && ($map['title'] = array('like', '%' . $keyword . '%'));
     $this->assign('search', array('keyword' => $keyword, 'cate_id' => $cate_id));
     //分页
     import("ORG.Util.Page");
     $count = $this->_mod->where($map)->count('id');
     $pager = new \Common\ORG\Page($count, 20);
     $select = $this->_mod->field('id,cate_id,title,banner,cover_cache')->where($map)->order('id DESC');
     $select->limit($pager->firstRow . ',' . $pager->listRows);
     $page = $pager->show();
     $this->assign("page", $page);
     $list = $select->select();
     //格式化专辑图片数据
     foreach ($list as $key => $val) {
         $list[$key]['cover'] = unserialize($val['cover_cache']);
     }
     $this->assign('list', $list);
     $this->assign('list_table', true);
     $this->display();
 }
Пример #4
0
 public function logs()
 {
     $score_log_mod = M('score_log');
     $map = array();
     $keyword = input('request.keyword', 'trim');
     $keyword && ($map = array('uname' => array('like', '%' . $keyword . '%')));
     $count = $score_log_mod->where($map)->count();
     $pager = new \Common\ORG\Page($count, 20);
     $list = $score_log_mod->order('id DESC')->limit($pager->firstRow . ',' . $pager->listRows)->select();
     $this->assign('list', $list);
     $this->assign('page', $pager->show());
     $this->assign('keyword', array('keyword' => $keyword));
     $this->display();
 }
Пример #5
0
 /**
  * 列表处理
  *
  * @param obj $model  实例化后的模型
  * @param array $map  条件数据
  * @param string $sort_by  排序字段
  * @param string $order_by  排序方法
  * @param string $field_list 显示字段
  * @param intval $pagesize 每页数据行数
  */
 protected function _list($model, $map = array(), $sort_by = '', $order_by = '', $field_list = '*', $pagesize = 20)
 {
     //排序
     $mod_pk = $model->getPk();
     if (input("request.sort", 'trim')) {
         $sort = input("request.sort", 'trim');
     } else {
         if (!empty($sort_by)) {
             $sort = $sort_by;
         } else {
             if ($this->sort) {
                 $sort = $this->sort;
             } else {
                 $sort = $mod_pk;
             }
         }
     }
     if (input("request.order", 'trim')) {
         $order = input("request.order", 'trim');
     } else {
         if (!empty($order_by)) {
             $order = $order_by;
         } else {
             if ($this->order) {
                 $order = $this->order;
             } else {
                 $order = 'DESC';
             }
         }
     }
     //如果需要分页
     if ($pagesize) {
         $count = $model->where($map)->count($mod_pk);
         $pager = new \Common\ORG\Page($count, $pagesize);
     }
     $select = $model->field($field_list)->where($map)->order($sort . ' ' . $order);
     // echo M()->getLastSql();
     $this->list_relation && $select->relation(true);
     if ($pagesize) {
         $select->limit($pager->firstRow . ',' . $pager->listRows);
         $page = $pager->show();
         $this->assign("page", $page);
     }
     $list = $select->select();
     foreach ($list as $key => $value) {
         $catename = M('user_category')->field('name')->where(array('id' => $value['uid']))->find();
         $value['cname'] = $catename['name'];
         $list[$key] = $value;
         //重复值list
     }
     //dump($list);
     $this->assign('list', $list);
     $this->assign('list_table', true);
 }
Пример #6
0
 /**
  * 分类标签列表
  */
 public function tag_list()
 {
     $cate_id = input('get.cate_id', 'intval');
     $keyword = input('get.keyword', 'trim');
     $cate_tag_mod = M('item_cate_tag');
     $db_pre = C('DB_PREFIX');
     $table = $db_pre . 'item_cate_tag';
     $pagesize = 20;
     $map = array($table . '.cate_id' => $cate_id);
     $keyword && ($map['t.name'] = array('like', '%' . $keyword . '%'));
     $join = $db_pre . 'tag t ON t.id = ' . $table . '.tag_id';
     $count = $cate_tag_mod->where($map)->join($join)->count();
     $pager = new \Common\ORG\Page($count, $pagesize);
     $list = $cate_tag_mod->field('t.id,t.name,weight')->where($map)->join($join)->limit($pager->firstRow . ',' . $pager->listRows)->select();
     $cate_name = $this->_mod->get_name($cate_id);
     //分类名称
     $this->assign('list', $list);
     $this->assign('page', $pager->show());
     $this->assign('cate_id', $cate_id);
     $this->assign('cate_name', $cate_name);
     $this->assign('list_table', true);
     $this->display();
 }
Пример #7
0
 /**
  * 前台分页统一
  */
 protected function _pager($count, $pagesize)
 {
     $pager = new \Common\ORG\Page($count, $pagesize);
     $pager->rollPage = 5;
     $pager->setConfig('prev', '<');
     $pager->setConfig('theme', '%upPage% %first% %linkPage% %end% %downPage%');
     return $pager;
 }
Пример #8
0
 public function log()
 {
     $zp = M('zhuanpan_list');
     $useracc = M('zhuanpan_log');
     if ($keyword = input('request.keyword', 'trim')) {
         $map['_string'] = "username like '%" . $keyword . "%' ";
     }
     $map['listid'] = array('lt', 7);
     $count = $useracc->where($map)->count();
     // 查询满足要求的总记录数 $map表示查询条件
     $Page = new \Common\ORG\Page($count);
     // 实例化分页类 传入总记录数
     $show = $Page->show();
     // 分页显示输出
     // 进行分页数据查询
     $list = $useracc->where($map)->order('id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
     foreach ($list as $key => $val) {
         $listid = $val['listid'];
         $listinfo = $zp->where("id={$listid}")->find();
         $list[$key]['jp_leibei'] = $listinfo['praisename'];
         $list[$key]['jp_name'] = $listinfo['praisecontent'];
     }
     $this->assign('list', $list);
     // 赋值数据集
     $this->assign('page', $show);
     // 赋值分页输出
     $this->display();
 }
Пример #9
0
 /**
  * 列表处理
  *
  * @param obj $model  实例化后的模型
  * @param array $map  条件数据
  * @param string $sort_by  排序字段
  * @param string $order_by  排序方法
  * @param string $field_list 显示字段
  * @param intval $pagesize 每页数据行数
  */
 protected function _list($model, $map = array(), $sort_by = '', $order_by = '', $field_list = '*', $pagesize = 20)
 {
     //排序
     $mod_pk = $model->getPk();
     if (input('request.sort', 'trim')) {
         $sort = input('request.sort', 'trim');
     } else {
         if (!empty($sort_by)) {
             $sort = $sort_by;
         } else {
             if ($this->sort) {
                 $sort = $this->sort;
             } else {
                 $sort = $mod_pk;
             }
         }
     }
     if (input('request.order', 'trim')) {
         $order = input('request.order', 'trim');
     } else {
         if (!empty($order_by)) {
             $order = $order_by;
         } else {
             if ($this->order) {
                 $order = $this->order;
             } else {
                 $order = 'DESC';
             }
         }
     }
     //如果需要分页
     if ($pagesize) {
         $count = $model->where($map)->count($mod_pk);
         $pager = new \Common\ORG\Page($count, $pagesize);
     }
     $select = $model->field($field_list)->where($map)->order($sort . ' ' . $order);
     $this->list_relation && $select->relation(true);
     if ($pagesize) {
         $select->limit($pager->firstRow . ',' . $pager->listRows);
         $page = $pager->show();
         $this->assign('page', $page);
     }
     $list = $select->select();
     $this->assign('list', $list);
     $this->assign('list_table', true);
 }
Пример #10
0
 /**
  * 商品审核
  */
 public function check()
 {
     //分类信息
     $res = $this->_cate_mod->field('id,name')->select();
     $cate_list = array();
     foreach ($res as $val) {
         $cate_list[$val['id']] = $val['name'];
     }
     $this->assign('cate_list', $cate_list);
     //商品信息
     //$map = $this->_search();
     $map = array();
     $map['status'] = 0;
     ($time_start = input('request.time_start', 'trim')) && ($map['add_time'][] = array('egt', strtotime($time_start)));
     ($time_end = input('request.time_end', 'trim')) && ($map['add_time'][] = array('elt', strtotime($time_end) + (24 * 60 * 60 - 1)));
     $cate_id = input('request.cate_id', 'intval');
     if ($cate_id) {
         $id_arr = $this->_cate_mod->getChildIds($cate_id, true);
         $map['cate_id'] = array('IN', $id_arr);
         $spid = $this->_cate_mod->where(array('id' => $cate_id))->getField('spid');
         if ($spid == 0) {
             $spid = $cate_id;
         } else {
             $spid .= $cate_id;
         }
     }
     ($keyword = input('request.keyword', 'trim')) && ($map['title'] = array('like', '%' . $keyword . '%'));
     $this->assign('search', array('time_start' => $time_start, 'time_end' => $time_end, 'selected_ids' => $spid, 'cate_id' => $cate_id, 'keyword' => $keyword));
     //分页
     $count = $this->_mod->where($map)->count('id');
     $pager = new \Common\ORG\Page($count, 20);
     $select = $this->_mod->field('id,title,img,tag_cache,cate_id,uid,uname')->where($map)->order('id DESC');
     $select->limit($pager->firstRow . ',' . $pager->listRows);
     $page = $pager->show();
     $this->assign("page", $page);
     $list = $select->select();
     foreach ($list as $key => $val) {
         $tag_list = unserialize($val['tag_cache']);
         $val['tags'] = implode(' ', $tag_list);
         $list[$key] = $val;
     }
     $this->assign('list', $list);
     $this->assign('list_table', true);
     $this->display();
 }
 public function search()
 {
     //搜索结果
     $taobaoke_item_list = array();
     if (input('get.search')) {
         $map['keyword'] = input('get.keyword', 'trim');
         //关键词
         $map['cid'] = input('get.cid', 'intval');
         //分类ID
         $p = input('get.p', 'intval', 1);
         //淘宝只提供400数据
         if ($p > 10) {
             $this->redirect('collect_alimama/search', array('keyword' => $map['keyword'], 'cid' => $map['cid'], 'search' => 1));
         }
         if (!$map['keyword'] && !$map['cid']) {
             $this->error(L('select_cid_or_keyword'));
         }
         $map['start_price'] = input('get.start_price', 'trim');
         //价格下限
         $map['end_price'] = input('get.end_price', 'trim');
         //价格上限
         $map['start_commissionRate'] = input('get.start_commissionRate', 'trim');
         //佣金比率下限
         $map['end_commissionRate'] = input('get.end_commissionRate', 'trim');
         //佣金比率上限
         $map['start_commissionNum'] = input('get.start_commissionNum', 'intval');
         //30天推广量下限
         $map['end_commissionNum'] = input('get.end_commissionNum', 'intval');
         //30天推广量上限
         $map['start_totalnum'] = input('get.start_totalnum', 'intval');
         //总销量下限
         $map['end_totalnum'] = input('get.end_totalnum', 'intval');
         //总销量上限
         $map['start_credit'] = input('get.start_credit', 'trim');
         //卖家信用下限
         $map['end_credit'] = input('get.end_credit', 'trim');
         //卖家信用上限
         $map['mall_item'] = input('get.mall_item', 'intval');
         //是否天猫商品
         $map['guarantee'] = input('get.guarantee', 'intval');
         //是否消保卖家
         $map['sevendays_return'] = input('get.sevendays_return', 'intval');
         //是否支持7天退换
         $map['real_describe'] = input('get.real_describe', 'intval');
         //是否先行赔付
         $map['cash_coupon'] = input('get.cash_coupon', 'intval');
         //是否支持抵价券
         $map['sort'] = input('get.sort', 'trim');
         //排序方法
         $map['like_init'] = input('get.like_init', 'trim');
         $result = $this->_get_list($map, $p);
         //分页
         $pager = new \Common\ORG\Page($result['count'], 20);
         $page = $pager->show();
         $this->assign("page", $page);
         //列表内容
         $taobaoke_item_list = $result['item_list'];
     }
     $taobaoke_item_list && F('taobaoke_item_list', $taobaoke_item_list);
     $this->assign('list', $taobaoke_item_list);
     $this->assign('list_table', true);
     $this->display();
 }