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