public function index()
{
$where = '';
$parameter = array();
$name = trim($_REQUEST['name']);
$position_id = intval($_REQUEST['position_id']);
if (!empty($name)) {
$where .= " AND a.name LIKE '%" . mysqlLikeQuote($name) . "%'";
$this->assign("name", $name);
$parameter['name'] = $name;
}
if ($position_id > 0) {
$this->assign("position_id", $position_id);
$parameter['position_id'] = $position_id;
$where .= " AND a.position_id = '{$position_id}'";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT a.id) AS acount
FROM ' . C("DB_PREFIX") . 'province_adv AS a ' . $where;
$count = $model->query($sql);
$count = $count[0]['acount'];
$sql = 'SELECT a.*,ap.name AS position_name
FROM ' . C("DB_PREFIX") . 'province_adv AS a
LEFT JOIN ' . C("DB_PREFIX") . 'province_adv_position AS ap ON ap.id = a.position_id ' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'a.id');
$ap_list = M("ProvinceAdvPosition")->where('status = 1')->select();
$this->assign("ap_list", $ap_list);
$this->display();
}
public function index()
{
if (isset($_REQUEST['cate_id'])) {
$cate_id = intval($_REQUEST['cate_id']);
} else {
$cate_id = intval($_SESSION['goods_category_tags_cate_id']);
}
$_SESSION['goods_category_tags_cate_id'] = $cate_id;
$parameter = array();
$parameter['cate_id'] = $cate_id;
$where = 'gct.cate_id = ' . $cate_id;
$this->assign("cate_id", $cate_id);
$tag_name = trim($_REQUEST['tag_name']);
if (!empty($tag_name)) {
$this->assign("tag_name", $tag_name);
$parameter['tag_name'] = $tag_name;
$where .= " AND gt.tag_name LIKE '%" . mysqlLikeQuote($tag_name) . "%'";
}
$model = M();
$sql = 'SELECT COUNT(DISTINCT gt.tag_id) AS tcount FROM ' . C("DB_PREFIX") . 'goods_category_tags as gct
LEFT JOIN ' . C("DB_PREFIX") . 'goods_tags as gt ON gt.tag_id = gct.tag_id
WHERE ' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT gct.*,gt.tag_name FROM ' . C("DB_PREFIX") . 'goods_category_tags as gct
LEFT JOIN ' . C("DB_PREFIX") . 'goods_tags as gt ON gt.tag_id = gct.tag_id
WHERE ' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'sort', true);
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$name = trim($_REQUEST['name']);
$page = trim($_REQUEST['page']);
if (!empty($name)) {
$where .= " AND name LIKE '%" . mysqlLikeQuote($name) . "%'";
$this->assign("name", $name);
$parameter['name'] = $name;
}
if (!empty($page)) {
$this->assign("page", $page);
$parameter['page'] = $page;
$where .= " AND page = '{$page}'";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT id) AS acount
FROM ' . C("DB_PREFIX") . 'm_adv ' . $where;
$count = $model->query($sql);
$count = $count[0]['acount'];
$sql = 'SELECT * FROM ' . C("DB_PREFIX") . 'm_adv ' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'id');
$this->display();
}
public function index()
{
$where = '';
$parameter = array();
$keyword = trim($_REQUEST['keyword']);
$uname = trim($_REQUEST['uname']);
$sid = intval($_REQUEST['sid']);
$city_id = intval($_REQUEST['city_id']);
if (!empty($keyword)) {
$this->assign("keyword", $keyword);
$parameter['keyword'] = $keyword;
$where .= " AND sg.name LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
}
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($uname);
$where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
}
if ($sid > 0) {
$this->assign("sid", $sid);
$parameter['sid'] = $sid;
$where .= " AND sg.sid = {$sid}";
}
if ($city_id > 0) {
$this->assign("city_id", $city_id);
$parameter['city_id'] = $city_id;
$where .= " AND sg.city_id = {$city_id}";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT sg.gid) AS tcount
FROM ' . C("DB_PREFIX") . 'second_goods AS sg
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = sg.uid
' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT sg.*,s.name AS sname,u.user_name
FROM ' . C("DB_PREFIX") . 'second_goods AS sg
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = sg.uid
LEFT JOIN ' . C("DB_PREFIX") . 'second AS s ON s.sid = sg.sid
' . $where . ' GROUP BY sg.gid';
$this->_sqlList($model, $sql, $count, $parameter, 'sg.gid');
$second_list = D("Second")->order('sort asc,sid asc')->findAll();
$this->assign("second_list", $second_list);
$city_list = D("Region")->where('parent_id = 0')->order('sort asc,id asc')->findAll();
$this->assign("city_list", $city_list);
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$uname = trim($_REQUEST['uname']);
$begin_time_str = trim($_REQUEST['begin_time']);
$end_time_str = trim($_REQUEST['end_time']);
$begin_time = !empty($begin_time_str) ? strZTime($begin_time_str) : 0;
$end_time = !empty($end_time_str) ? strZTime($end_time_str) : 0;
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($uname);
$where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
}
if ($begin_time > 0) {
$this->assign("begin_time", $begin_time_str);
$parameter['begin_time'] = $begin_time_str;
$where .= " AND usl.create_day >= '" . $begin_time . "'";
}
if ($end_time > 0) {
$this->assign("end_time", $end_time_str);
$parameter['end_time'] = $end_time_str;
$where .= " AND usl.create_day < '" . ($end_time + 86400) . "'";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT usl.id) AS tcount
FROM ' . C("DB_PREFIX") . 'user_score_log AS usl
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = usl.uid
' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT usl.*,u.user_name
FROM ' . C("DB_PREFIX") . 'user_score_log AS usl
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = usl.uid
' . $where . ' GROUP BY usl.id';
$this->_sqlList($model, $sql, $count, $parameter, 'usl.id');
$list = $this->get('list');
foreach ($list as $k => $v) {
if ($v['score'] >= 0) {
$list[$k]['inc_score'] = abs($v['score']);
} else {
$list[$k]['dec_score'] = abs($v['score']);
}
}
$this->assign('list', $list);
$this->display();
return;
}
public function search()
{
$cid = intval($_REQUEST['cid']);
$sid = intval($_REQUEST['sid']);
$key = trim($_REQUEST['key']);
$type = intval($_REQUEST['type']);
$tag_name = trim($_REQUEST['tag_name']);
$custom_tags = trim($_REQUEST['custom_tags']);
$where = '';
if (!empty($key)) {
$where .= ' AND tag_name LIKE \'%' . mysqlLikeQuote($key) . '%\'';
}
if ($cid > 0) {
$cids = D('GoodsCategoryTags')->getTagIDs($cid);
if (count($cids) > 0) {
$where .= ' AND tag_id NOT IN (' . implode(',', $cids) . ')';
}
}
if ($sid > 0) {
$sids = D('StyleCategoryTags')->getTagIDs($sid);
if (count($cids) > 0) {
$where .= ' AND tag_id NOT IN (' . implode(',', $sids) . ')';
}
}
$tag_names = array();
if (!empty($tag_name)) {
$tag_name = explode(' ', $tag_name);
foreach ($tag_name as $name) {
$tag_names[] = addslashes($name);
}
}
if (!empty($custom_tags)) {
$custom_tags = explode(',', $custom_tags);
foreach ($custom_tags as $custom) {
$custom = explode('|', $custom);
$tag_names[] = addslashes($custom[0]);
}
}
if (count($tag_names) > 0) {
$where .= ' AND tag_name NOT ' . createIN($tag_names);
}
$list = array();
if (empty($where)) {
$list = D('GoodsTags')->limit('0,60')->order('sort ASC,tag_id ASC')->findAll();
} else {
$list = D('GoodsTags')->where('1' . $where)->limit('0,60')->order('sort ASC,tag_id ASC')->findAll();
}
if ($type == 1) {
echo json_encode($list);
} else {
$this->assign("tag_list", $list);
echo $this->fetch('GoodsTags:tags');
}
}
public function index()
{
$where = '';
$parameter = array();
$uname = trim($_REQUEST['uname']);
$begin_time_str = trim($_REQUEST['begin_time']);
$end_time_str = trim($_REQUEST['end_time']);
$begin_time = !empty($begin_time_str) ? strZTime($begin_time_str) : 0;
$end_time = !empty($end_time_str) ? strZTime($end_time_str) : 0;
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($uname);
$where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
}
if ($begin_time > 0) {
$this->assign("begin_time", $begin_time_str);
$parameter['begin_time'] = $begin_time_str;
$where .= " AND r.create_day >= '" . $begin_time . "'";
}
if ($end_time > 0) {
$this->assign("end_time", $end_time_str);
$parameter['end_time'] = $end_time_str;
$where .= " AND r.create_day < '" . ($end_time + 86400) . "'";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT r.id) AS tcount
FROM ' . C("DB_PREFIX") . 'referrals AS r
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = r.rid
' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT r.*,CONCAT(u.user_name,\':\',us.reg_ip) as ruser_name,CONCAT(u1.user_name,\':\',us1.reg_ip) as user_name
FROM ' . C("DB_PREFIX") . 'referrals AS r
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = r.rid
LEFT JOIN ' . C("DB_PREFIX") . 'user_status AS us ON us.uid = r.rid
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u1 ON u1.uid = r.uid
LEFT JOIN ' . C("DB_PREFIX") . 'user_status AS us1 ON us1.uid = r.uid
' . $where . ' GROUP BY r.id';
$this->_sqlList($model, $sql, $count, $parameter, 'r.id');
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$keyword = trim($_REQUEST['keyword']);
$uname = trim($_REQUEST['uname']);
$cid = (int) $_REQUEST['cid'];
if (!empty($keyword)) {
$this->assign("keyword", $keyword);
$parameter['keyword'] = $keyword;
$where .= " AND a.title LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
}
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($uname);
$where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
}
if ($cid > 0) {
$this->assign("cid", $cid);
$parameter['cid'] = $cid;
$where .= " AND a.cid = {$cid}";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE' . $where;
$where = str_replace('WHERE AND', 'WHERE', $where);
}
$sql = 'SELECT COUNT(DISTINCT a.id) AS tcount
FROM ' . C("DB_PREFIX") . 'album AS a
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = a.uid
' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT a.*,ac.name AS cname,u.user_name
FROM ' . C("DB_PREFIX") . 'album AS a
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = a.uid
LEFT JOIN ' . C("DB_PREFIX") . 'album_category AS ac ON ac.id = a.cid
' . $where . ' GROUP BY a.id';
$this->_sqlList($model, $sql, $count, $parameter, 'a.id');
$category_list = D("AlbumCategory")->order('sort asc,id asc')->findAll();
$this->assign("category_list", $category_list);
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$keyword = trim($_REQUEST['keyword']);
$uname = trim($_REQUEST['uname']);
$fid = intval($_REQUEST['fid']);
if (!empty($keyword)) {
$this->assign("keyword", $keyword);
$parameter['keyword'] = $keyword;
$where .= " AND ft.title LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
}
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
}
if ($fid > 0) {
$this->assign("fid", $fid);
$parameter['fid'] = $fid;
$where .= " AND ft.fid = {$fid}";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT ft.tid) AS tcount
FROM ' . C("DB_PREFIX") . 'forum_thread AS ft
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ft.uid
' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT ft.tid,LEFT(ft.title,80) AS title,u.user_name,ft.create_time,ft.post_count,ft.is_top,ft.is_best,
ft.is_event,f.name AS fname,ft.share_id
FROM ' . C("DB_PREFIX") . 'forum_thread AS ft
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ft.uid
LEFT JOIN ' . C("DB_PREFIX") . 'forum AS f ON f.fid = ft.fid
' . $where . ' GROUP BY ft.tid';
$this->_sqlList($model, $sql, $count, $parameter, 'ft.tid');
$cate_tree = M("Forum")->findAll();
$cate_tree = D("Forum")->toFormatTree($cate_tree, 'name', 'fid', 'parent_id');
$this->assign("cate_tree", $cate_tree);
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$keyword = trim($_REQUEST['keyword']);
$uname = trim($_REQUEST['uname']);
$aid = intval($_REQUEST['aid']);
if (!empty($keyword)) {
$this->assign("keyword", $keyword);
$parameter['keyword'] = $keyword;
$where .= " AND at.title LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
}
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
}
if ($aid > 0) {
$this->assign("aid", $aid);
$parameter['aid'] = $aid;
$where .= " AND at.aid = {$aid}";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT at.tid) AS tcount
FROM ' . C("DB_PREFIX") . 'ask_thread AS at
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = at.uid
' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT at.tid,LEFT(at.title,80) AS title,u.user_name,at.create_time,at.post_count,at.is_top,at.is_best,
a.name AS aname,at.share_id
FROM ' . C("DB_PREFIX") . 'ask_thread AS at
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = at.uid
LEFT JOIN ' . C("DB_PREFIX") . 'ask AS a ON a.aid = at.aid
' . $where . ' GROUP BY at.tid';
$this->_sqlList($model, $sql, $count, $parameter, 'at.tid');
$cate_tree = M("Ask")->order('sort asc,aid asc')->findAll();
$this->assign("cate_tree", $cate_tree);
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$name = trim($_REQUEST['name']);
$sn = trim($_REQUEST['sn']);
$user_name = trim($_REQUEST['user_name']);
$goods_status = trim($_REQUEST['goods_status']);
if (!empty($name)) {
$this->assign("name", $name);
$parameter['name'] = $name;
$like_name = mysqlLikeQuote($name);
$where .= ' AND data_name LIKE \'%' . $like_name . '%\'';
}
if (!empty($sn)) {
$this->assign("sn", $sn);
$parameter['sn'] = $sn;
$where .= ' AND sn = \'' . $sn . '\'';
}
if (!empty($user_name)) {
$this->assign("user_name", $user_name);
$parameter['user_name'] = $user_name;
$where .= ' AND user_name = \'' . $user_name . '\'';
}
if ($goods_status != "" && $goods_status >= 0) {
$this->assign("goods_status", $goods_status);
$parameter['goods_status'] = $goods_status;
$where .= ' AND goods_status = ' . $goods_status;
} else {
$this->assign("goods_status", -1);
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(id) AS tcount
FROM ' . C("DB_PREFIX") . 'order ' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT * FROM ' . C("DB_PREFIX") . 'order ' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'id');
$this->display();
return;
}
public function index()
{
$where = '';
$parameter = array();
$word = trim($_REQUEST['word']);
$type = intval($_REQUEST['type']);
$cid = intval($_REQUEST['cid']);
if (!empty($word)) {
$where .= " AND w.word LIKE '%" . mysqlLikeQuote($word) . "%'";
$this->assign("word", $word);
$parameter['word'] = $word;
}
if ($type > 0) {
$this->assign("type", $type);
$parameter['type'] = $type;
$where .= " AND w.type = '{$type}'";
} else {
$this->assign("type", 0);
}
if ($cid > 0) {
$this->assign("cid", $cid);
$parameter['cid'] = $cid;
$where .= " AND w.cid = '{$cid}'";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(DISTINCT w.id) AS wcount
FROM ' . C("DB_PREFIX") . 'word AS w ' . $where;
$count = $model->query($sql);
$count = $count[0]['wcount'];
$sql = 'SELECT w.*,wt.name AS cname
FROM ' . C("DB_PREFIX") . 'word AS w
LEFT JOIN ' . C("DB_PREFIX") . 'word_type AS wt ON wt.id = w.cid ' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'w.id');
$type_list = M("WordType")->where('status = 1')->findAll();
$this->assign("type_list", $type_list);
$this->display();
}
public function index()
{
$where = '';
$parameter = array();
$name = trim($_REQUEST['name']);
$begin_time_str = trim($_REQUEST['begin_time']);
$end_time_str = trim($_REQUEST['end_time']);
$begin_time = !empty($begin_time_str) ? strZTime($begin_time_str) : 0;
$end_time = !empty($end_time_str) ? strZTime($end_time_str) : 0;
if (!empty($name)) {
$this->assign("name", $name);
$parameter['name'] = $name;
$like_name = mysqlLikeQuote($name);
$where .= ' AND name LIKE \'%' . $like_name . '%\'';
}
if ($begin_time > 0) {
$this->assign("begin_time", $begin_time_str);
$parameter['begin_time'] = $begin_time_str;
$where .= " AND begin_time >= '" . $begin_time . "'";
}
if ($end_time > 0) {
$this->assign("end_time", $end_time_str);
$parameter['end_time'] = $end_time_str;
$where .= " AND end_time < '" . ($end_time + 86400) . "'";
}
$model = M();
if (!empty($where)) {
$where = 'WHERE 1' . $where;
}
$sql = 'SELECT COUNT(id) AS tcount
FROM ' . C("DB_PREFIX") . 'exchange_goods ' . $where;
$count = $model->query($sql);
$count = $count[0]['tcount'];
$sql = 'SELECT * FROM ' . C("DB_PREFIX") . 'exchange_goods ' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'id');
$this->display();
return;
}
public function getUserList()
{
$key = trim($_REQUEST['key']);
$where = '';
if (!empty($key)) {
$match_key = segmentToUnicodeA($key, '+');
$where .= " AND match(user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($key);
$where .= ' AND user_name LIKE \'%' . $like_name . '%\'';
}
$sql = 'SELECT uid,user_name FROM ' . C("DB_PREFIX") . 'user WHERE status = 1 ' . $where . ' ORDER BY uid DESC limit 0,30';
$userList = M()->query($sql);
echo json_encode($userList);
}
public function look()
{
$where = '';
$parameter = array();
$keyword = trim($_REQUEST['keyword']);
$uname = trim($_REQUEST['uname']);
$type = trim($_REQUEST['type']);
$share_data = !isset($_REQUEST['share_data']) ? 'img' : trim($_REQUEST['share_data']);
$cate_id = intval($_REQUEST['cate_id']);
$status = !isset($_REQUEST['status']) ? 0 : intval($_REQUEST['status']);
$inner_sql = '';
$where .= " WHERE sp.type = 'look'";
if (!empty($keyword)) {
$this->assign("keyword", $keyword);
$parameter['keyword'] = $keyword;
$match_key = segmentToUnicodeA($keyword, '+');
$where .= " AND match(sm.content_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$inner_sql .= 'INNER JOIN ' . C("DB_PREFIX") . 'share_match AS sm ON sm.share_id = s.share_id ';
}
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($uname);
$where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
}
$model = M();
$sql = 'SELECT COUNT(DISTINCT s.share_id) AS scount
FROM ' . C("DB_PREFIX") . 'share_photo AS sp
INNER JOIN ' . C("DB_PREFIX") . 'share AS s ON s.share_id = sp.share_id
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = s.uid
' . $inner_sql . $where;
$count = $model->query($sql);
$count = $count[0]['scount'];
$sql = 'SELECT s.share_id,LEFT(s.content,80) AS content,u.user_name,s.create_time,s.collect_count,s.relay_count, s.comment_count,s.type,s.share_data,s.status,s.is_best
FROM ' . C("DB_PREFIX") . 'share_photo AS sp
INNER JOIN ' . C("DB_PREFIX") . 'share AS s ON s.share_id = sp.share_id
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = s.uid
' . $inner_sql . $where . ' GROUP BY s.share_id';
$this->_sqlList($model, $sql, $count, $parameter, 's.share_id');
$this->display();
}
public function check()
{
$where = '';
$parameter = array();
$uname = trim($_REQUEST['uname']);
$mid = intval($_REQUEST['mid']);
if (!empty($uname)) {
$this->assign("uname", $uname);
$parameter['uname'] = $uname;
$match_key = segmentToUnicodeA($uname, '+');
$where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
$like_name = mysqlLikeQuote($uname);
$where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
}
if ($mid > 0) {
$this->assign("mid", $mid);
$parameter['mid'] = $mid;
$where .= " AND ma.mid = {$mid}";
}
if (!empty($where)) {
$where = ' WHERE' . $where;
$where = str_replace('WHERE AND', 'WHERE', $where);
}
$model = M();
$sql = 'SELECT COUNT(DISTINCT ma.id) AS scount
FROM ' . C("DB_PREFIX") . 'medal_apply AS ma
LEFT JOIN ' . C("DB_PREFIX") . 'medal AS m ON m.mid = ma.mid
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ma.uid
' . $where;
$count = $model->query($sql);
$count = $count[0]['scount'];
$sql = 'SELECT ma.id,ma.reason,ma.create_time,u.user_name,m.name,m.image,m.give_type
FROM ' . C("DB_PREFIX") . 'medal_apply AS ma
LEFT JOIN ' . C("DB_PREFIX") . 'medal AS m ON m.mid = ma.mid
LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ma.uid
' . $where;
$this->_sqlList($model, $sql, $count, $parameter, 'ma.id');
$medal_list = D('Medal')->where('status = 1 AND give_type = 1')->order('sort asc')->findAll();
$this->assign("medal_list", $medal_list);
$this->display();
}
