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 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 update() { Vendor("common"); $_POST['valid_time'] = strZTime($_POST['valid_time']); $gid = intval($_REQUEST['gid']); $goods = D('SecondGoods')->where("gid = '{$gid}'")->find(); if ($goods['share_id'] > 0) { $share_id = $goods['share_id']; $title = trim($_REQUEST['name']); $content = trim($_REQUEST['content']); if ($goods['title'] != $title || $goods['content'] != $content) { FS("Share")->updateShare($share_id, $title, $content); } } parent::update(); }
public function index() { $where = ''; $parameter = array(); $user_name = trim($_REQUEST['user_name']); $day_time = trim($_REQUEST['day_time']); $status = !isset($_REQUEST['status']) ? -1 : intval($_REQUEST['status']); if (!empty($user_name)) { $this->assign("user_name", $user_name); $parameter['user_name'] = $user_name; $match_key = segmentToUnicodeA($user_name, '+'); $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) "; } if (!empty($day_time)) { $this->assign("day_time", $day_time); $parameter['day_time'] = $day_time; $day_time = strZTime($day_time); $where .= " AND ud.day_time = '{$day_time}'"; } if ($status > -1) { $this->assign("status", $status); $parameter['status'] = $status; $where .= " AND ud.status = {$status}"; } else { $this->assign("status", -1); } $model = M(); if (!empty($where)) { $where = 'WHERE 1' . $where; } $sql = 'SELECT COUNT(ud.id) AS tcount FROM ' . C("DB_PREFIX") . 'user_daren AS ud INNER JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ud.uid ' . $where; $count = $model->query($sql); $count = $count[0]['tcount']; $sql = 'SELECT ud.*,u.user_name FROM ' . C("DB_PREFIX") . 'user_daren AS ud INNER JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ud.uid ' . $where; $this->_sqlList($model, $sql, $count, $parameter); $this->display(); }
public function clear() { $where = ''; $begin_time = trim($_REQUEST['begin_time']); $end_time = trim($_REQUEST['end_time']); if (!empty($begin_time)) { $begin_time = strZTime($begin_time); $where .= " AND log_time >= '{$begin_time}'"; } else { $begin_time = 0; } if (!empty($end_time) && strZTime($end_time) > $begin_time) { $end_time = strZTime($end_time); $where .= " AND log_time <= '{$end_time}'"; } $model = M(); if (!empty($where)) { $where = 'WHERE 1' . $where; } $sql = 'DELETE FROM ' . C("DB_PREFIX") . 'admin_log ' . $where; M()->query($sql); $this->redirect('AdminLog/index'); }
public function clear() { $where = ''; $parameter = array(); $begin_time = trim($_REQUEST['begin_time']); $end_time = trim($_REQUEST['end_time']); $status = trim($_REQUEST['status']); if (!empty($begin_time)) { $this->assign("begin_time", $begin_time); $parameter['begin_time'] = $begin_time; $begin_time = strZTime($begin_time); if ($begin_time > 0) { $begin_time1 = toDate($begin_time); $where .= " AND created >= '{$begin_time1}'"; } } else { $begin_time = 0; } if (!empty($end_time) && strZTime($end_time) > $begin_time) { $this->assign("end_time", $end_time); $parameter['end_time'] = $end_time; $end_time = strZTime($end_time); if ($end_time > 0) { $end_time1 = toDate($end_time); $where .= " AND created <= '{$end_time1}'"; } } if (!empty($status)) { $this->assign("status", $status); $parameter['status'] = $status; $where .= " AND status = '{$status}'"; } if (!empty($where)) { $where = 'WHERE' . $where; $where = str_replace('WHERE AND', 'WHERE', $where); } $model = M(); $sql = 'DELETE FROM ' . C("DB_PREFIX") . 'apns_messages ' . $where; M()->query($sql); $this->redirect('MApns/index'); }
public function updateSend() { $mid = intval($_REQUEST['mid']); $msg = array(); $msg['title'] = trim($_REQUEST['title']); $msg['message'] = trim($_REQUEST['message']); $msg['create_time'] = gmtTime(); $end_time = trim($_REQUEST['end_time']); if (empty($end_time)) { $msg['end_time'] = 0; } else { $msg['end_time'] = strZTime($end_time); } D('SysMsg')->where("mid = '{$mid}'")->save($msg); D('SysMsgUserGroup')->where("mid = '{$mid}'")->delete(); $user_group = trim($_REQUEST['user_group']); if (!empty($user_group)) { $user_group = explode(',', $user_group); foreach ($user_group as $gid) { $data = array(); $data['mid'] = $mid; $data['gid'] = $gid; D('SysMsgUserGroup')->add($data); } } D('SysMsgUserYes')->where("mid = '{$mid}'")->delete(); $user_yes = trim($_REQUEST['user_yes']); if (!empty($user_yes)) { $user_yes = explode(',', $user_yes); $user_yes = array_unique($user_yes); foreach ($user_yes as $uname) { $data = array(); $data['mid'] = $mid; $data['uid'] = D('User')->where("user_name = '{$uname}'")->getField('uid'); if ($data['uid'] > 0) { D('SysMsgUserYes')->add($data); } } } D('SysMsgUserNo')->where("mid = '{$mid}'")->delete(); $user_no = trim($_REQUEST['user_no']); if (!empty($user_no)) { $user_no = explode(',', $user_no); $user_no = array_unique($user_no); foreach ($user_no as $uname) { $data = array(); $data['mid'] = $mid; $data['uid'] = D('User')->where("user_name = '{$uname}'")->getField('uid'); if ($data['uid'] > 0) { D('SysMsgUserNo')->add($data); } } } $this->assign('jumpUrl', U('UserMsg/groupList')); $this->success(L('EDIT_SUCCESS')); }
public function doBatchDelte() { @set_time_limit(0); if (function_exists('ini_set')) { ini_set('max_execution_time', 0); } vendor("common"); $limit = 100; $extwhere = ""; if (trim($_REQUEST['keywords'])) { $extwhere .= " and (s.title like '%" . trim($_REQUEST['keywords']) . "%' or s.content like '%" . trim($_REQUEST['keywords']) . "%') "; $this->assign("keywords", trim($_REQUEST['keywords'])); } if (trim($_REQUEST['user_name'])) { $extwhere .= " and u.user_name = '" . trim($_REQUEST['user_name']) . "' "; $this->assign("user_name", trim($_REQUEST['user_name'])); } if (trim($_REQUEST['email'])) { $extwhere .= " and u.email = '" . trim($_REQUEST['email']) . "' "; $this->assign("email", trim($_REQUEST['email'])); } if (trim($_REQUEST['ip'])) { $extwhere .= " and (us.reg_ip = '" . trim($_REQUEST['ip']) . "' or us.last_ip = '" . trim($_REQUEST['ip']) . "') "; $this->assign("ip", trim($_REQUEST['ip'])); } if (trim($_REQUEST['start_time']) && trim($_REQUEST['end_time'])) { $extwhere .= " and s.create_time between '" . strZTime(trim($_REQUEST['start_time'])) . "' and '" . strZTime(trim($_REQUEST['end_time'])) . "' "; $this->assign("start_time", trim($_REQUEST['start_time'])); $this->assign("end_time", trim($_REQUEST['end_time'])); } elseif (trim($_REQUEST['start_time']) && !trim($_REQUEST['end_time'])) { $extwhere .= " and s.create_time >= '" . strZTime(trim($_REQUEST['start_time'])) . "' "; $this->assign("start_time", trim($_REQUEST['start_time'])); } elseif (!trim($_REQUEST['start_time']) && trim($_REQUEST['end_time'])) { $extwhere .= " and s.create_time <= '" . strZTime(trim($_REQUEST['end_time'])) . "' "; $this->assign("end_time", trim($_REQUEST['end_time'])); } if (trim($_REQUEST['type']) && trim($_REQUEST['type']) != "all") { $extwhere .= " and s.type = '" . trim($_REQUEST['type']) . "' "; } $this->assign("type", trim($_REQUEST['type'])); if (trim($_REQUEST['share_data']) && trim($_REQUEST['share_data']) != "all") { $extwhere .= " and s.share_data = '" . trim($_REQUEST['share_data']) . "' "; } $this->assign("share_data", trim($_REQUEST['share_data'])); if (trim($_REQUEST['status']) != "") { $extwhere .= " and s.status = '" . trim($_REQUEST['status']) . "' "; $this->assign("status", trim($_REQUEST['status'])); } if (trim($_REQUEST['share_cates']) != "") { $extwhere .= " and s.share_id in (select share_id from " . FDB::table('share_category') . " where cate_id in (" . trim($_REQUEST['share_cates']) . ") )"; $this->assign("share_cates", trim($_REQUEST['share_cates'])); } if (empty($extwhere)) { $this->error(L('NEED_ONE_PARAMETER')); exit; } $sql = 'SELECT s.share_id,s.index_img FROM ' . FDB::table('share') . ' s INNER JOIN ' . FDB::table('user') . ' u on u.uid=s.uid INNER JOIN ' . FDB::table('user_status') . ' us on us.uid=u.uid where 1=1 ' . $extwhere . ' ORDER BY s.share_id DESC LIMIT 0,' . $limit; $list = FDB::fetchAll($sql); if (count($list) == 0) { $this->redirect('Share/BatchDelete'); exit; } $this->display(); flush(); ob_flush(); usleep(2000); $ids = array(); foreach ($list as $k => $v) { @unlink(FANWE_ROOT . $v['index_img']); $ids[] = $v['share_id']; } D('Share')->removeHandler($ids); $this->saveLog(1, implode(",", $ids)); flush(); ob_flush(); usleep(100); echoFlush('<script type="text/javascript">submiform();</script>'); }
public function update() { $_POST['begin_time'] = strZTime($_POST['begin_time']); $_POST['end_time'] = strZTime($_POST['end_time']); $_POST['integral'] = (int) $_POST['integral']; $_POST['stock'] = (int) $_POST['stock']; $_POST['user_num'] = (int) $_POST['user_num']; $id = intval($_REQUEST['id']); $name = $this->getActionName(); $model = D($name); if (false === ($data = $model->create())) { $this->error($model->getError()); } // 更新数据 $list = $model->save($data); if (false !== $list) { if ($upload_list = $this->uploadImages()) { $img = $upload_list[0]['recpath'] . $upload_list[0]['savename']; if (!empty($img)) { $old_img = $model->where("id=" . $id)->getField('img'); if (!empty($old_img)) { @unlink(FANWE_ROOT . $old_img); } $model->where("id=" . $id)->setField("img", $img); } } $this->saveLog(1, $id); $this->assign('jumpUrl', Cookie::get('_currentUrl_')); $this->success(L('EDIT_SUCCESS')); } else { //错误提示 $this->saveLog(0, $id); $this->error(L('EDIT_ERROR')); } }