/**
* @brief 用户筛选
*/
function member_filter()
{
$search = IFilter::string(IReq::get('search'));
$keywords = IFilter::string(IReq::get('keywords'));
$where = ' 1 ';
if ($search && $keywords) {
$where .= " and {$search} like '%{$keywords}%' ";
}
$this->data['search'] = $search;
$this->data['keywords'] = $keywords;
$this->data['where'] = $where;
$tb_user_group = new IModel('user_group');
$data_group = $tb_user_group->query();
$data_group = is_array($data_group) ? $data_group : array();
$group = array();
foreach ($data_group as $value) {
$group[$value['id']] = $value['group_name'];
}
$this->data['group'] = $group;
$page = IReq::get('page');
$page = intval($page) ? intval($page) : 1;
$and = ' and ';
$where = 'm.status="1"' . $and;
$group_key = IFilter::string(IReq::get('group_key'));
$group_v = IFilter::act(IReq::get('group_value'), 'int');
if ($group_key && $group_v) {
if ($group_key == 'eq') {
$where .= "m.group_id='{$group_v}' {$and}";
} else {
$where .= "m.group_id!='{$group_v}' {$and} ";
}
}
$username_key = IFilter::string(IReq::get('username_key'));
$username_v = IFilter::act(IReq::get('username_value'), 'string');
if ($username_key && $username_v) {
if ($username_key == 'eq') {
$where .= "u.username='******' {$and}";
} else {
$where .= 'u.username like "%' . $username_v . '%"' . $and;
}
}
$truename_key = IFilter::string(IReq::get('truename_key'));
$truename_v = IFilter::act(IReq::get('truename_value'), 'string');
if ($truename_key && $truename_v) {
if ($truename_key == 'eq') {
$where .= "m.true_name='{$truename_v}' {$and}";
} else {
$where .= 'm.true_name like "%' . $truename_v . '%"' . $and;
}
}
$mobile_key = IFilter::string(IReq::get('mobile_key'));
$mobile_v = IFilter::act(IReq::get('mobile_value'), 'string');
if ($mobile_key && $mobile_v) {
if ($mobile_key == 'eq') {
$where .= "m.mobile='{$mobile_v}' {$and} ";
} else {
$where .= 'm.mobile like "%' . $mobile_v . '%"' . $and;
}
}
$telephone_key = IFilter::string(IReq::get('telephone_key'));
$telephone_v = IFilter::act(IReq::get('telephone_value'), 'string');
if ($telephone_key && $telephone_v) {
if ($telephone_key == 'eq') {
$where .= "m.telephone='{$telephone_v}' {$and} ";
} else {
$where .= 'm.telephone like "%' . $telephone_v . '%"' . $and;
}
}
$email_key = IFilter::string(IReq::get('email_key'));
$email_v = IFilter::act(IReq::get('email_value'), 'string');
if ($email_key && $email_v) {
if ($email_key == 'eq') {
$where .= "u.email='{$email_v}' {$and} ";
} else {
$where .= 'u.email like "%' . $email_v . '%"' . $and;
}
}
$zip_key = IFilter::string(IReq::get('zip_key'));
$zip_v = IFilter::act(IReq::get('zip_value'), 'string');
if ($zip_key && $zip_v) {
if ($zip_key == 'eq') {
$where .= "m.zip='{$zip_v}' {$and} ";
} else {
$where .= 'm.zip like "%' . $zip_v . '%"' . $and;
}
}
$sex = intval(IReq::get('sex'));
if ($sex && $sex != '-1') {
$where .= 'm.sex=' . $sex . $and;
}
$point_key = IFilter::string(IReq::get('point_key'));
$point_v = intval(IReq::get('point_value'));
if ($point_key && $point_v) {
if ($point_key == 'eq') {
$where .= 'm.point= "' . $point_v . '"' . $and;
} elseif ($point_key == 'gt') {
$where .= 'm.point > "' . $point_v . '"' . $and;
} else {
$where .= 'm.point < "' . $point_v . '"' . $and;
}
}
$regtimeBegin = IFilter::string(IReq::get('regtimeBegin'));
if ($regtimeBegin) {
$where .= 'm.time > "' . $regtimeBegin . '"' . $and;
}
$regtimeEnd = IFilter::string(IReq::get('regtimeEnd'));
if ($regtimeEnd) {
$where .= 'm.time < "' . $regtimeEnd . '"' . $and;
}
$where .= ' 1 ';
$query = new IQuery("member as m");
$query->join = "left join user as u on m.user_id = u.id left join user_group as gp on m.group_id = gp.id";
$query->fields = "m.*,u.username,u.email,gp.group_name";
$query->where = $where;
$query->page = $page;
$query->pagesize = "20";
$this->data['member_list'] = $query->find();
$this->data['pageBar'] = $query->getPageBar('/member/member_filter/');
$this->setRenderData($this->data);
$this->redirect('member_filter');
}
/**
* @brief 会员列表
*/
function member_list()
{
$search = IFilter::string(IReq::get('search'));
$keywords = IFilter::string(IReq::get('keywords'));
$where = ' 1 ';
if ($search && $keywords) {
$where .= " and {$search} like '%{$keywords}%' ";
}
$this->data['search'] = $search;
$this->data['keywords'] = $keywords;
$this->data['where'] = $where;
$tb_user_group = new IModel('user_group');
$data_group = $tb_user_group->query();
$group = array();
foreach ($data_group as $value) {
$group[$value['id']] = $value['group_name'];
}
$this->data['group'] = $group;
$this->setRenderData($this->data);
$this->redirect('member_list');
}
/**
* @brief 发送信件
*/
function message_send()
{
$where = ' 1 ';
$tb_user_group = new IModel('user_group');
$tb_user = new IModel('user');
$data_group = $tb_user_group->query();
$data_group = is_array($data_group) ? $data_group : array();
$group = array();
foreach ($data_group as $value) {
$group[$value['id']] = $value['group_name'];
}
$and = ' and ';
$where = '`status`="1"' . $and;
$group_key = IFilter::act(IReq::get('group_key', 'post'), 'string');
$group_v = IFilter::act(IReq::get('group_value', 'post'), 'int');
if ($group_key && $group_v) {
if ($group_key == 'eq') {
$where .= "group_id='{$group_v}' {$and}";
} else {
$where .= "group_id!='{$group_v}' {$and} ";
}
}
$truename_key = IFilter::string(IReq::get('truename_key', 'post'));
$truename_v = IFilter::act(IReq::get('truename_value', 'post'), 'string');
if ($truename_key && $truename_v) {
if ($truename_key == 'eq') {
$where .= "true_name='{$truename_v}' {$and}";
} else {
$where .= 'true_name like "%' . $truename_v . '%"' . $and;
}
}
$mobile_key = IFilter::string(IReq::get('mobile_key', 'post'));
$mobile_v = IFilter::act(IReq::get('mobile_value', 'post'), 'string');
if ($mobile_key && $mobile_v) {
if ($mobile_key == 'eq') {
$where .= "mobile='{$mobile_v}' {$and} ";
} else {
$where .= 'mobile like "%' . $mobile_v . '%"' . $and;
}
}
$telephone_key = IFilter::string(IReq::get('telephone_key', 'post'));
$telephone_v = IFilter::act(IReq::get('telephone_value', 'post'), 'string');
if ($telephone_key && $telephone_v) {
if ($telephone_key == 'eq') {
$where .= "telephone='{$telephone_v}' {$and} ";
} else {
$where .= 'telephone like "%' . $telephone_v . '%"' . $and;
}
}
$username_key = IFilter::string(IReq::get('username_key', 'post'));
$username_v = IFilter::act(IReq::get('username_value', 'post'), 'string');
$user_ids = array();
if ($username_key && $username_v) {
if ($username_key == 'eq') {
$sql = "username='******' ";
} else {
$sql = 'username like "%' . $username_v . '%"';
}
$tmp = $tb_user->query($sql);
if ($tmp) {
foreach ($tmp as $value) {
$user_ids[] = $value['id'];
}
}
}
$email_key = IFilter::string(IReq::get('email_key', 'post'));
$email_v = IFilter::act(IReq::get('email_value', 'post'), 'string');
if ($email_key && $email_v) {
if ($email_key == 'eq') {
$sql = "email='{$email_v}' ";
} else {
$sql = 'email like "%' . $email_v . '%"';
}
$tmp = $tb_user->query($sql);
if ($tmp) {
foreach ($tmp as $value) {
$user_ids[] = $value['id'];
}
}
}
if ($user_ids) {
$where .= "user_id IN (" . implode(',', $user_ids) . ") {$and}";
}
$zip_key = IFilter::string(IReq::get('zip_key', 'post'));
$zip_v = IFilter::act(IReq::get('zip_value', 'post'), 'string');
if ($zip_key && $zip_v) {
if ($zip_key == 'eq') {
$where .= "zip='{$zip_v}' {$and} ";
} else {
$where .= 'zip like "%' . $zip_v . '%"' . $and;
}
}
$sex = intval(IReq::get('sex', 'post'));
if ($sex && $sex != '-1') {
$where .= 'sex=' . $sex . $and;
}
$point_key = IFilter::string(IReq::get('point_key', 'post'));
$point_v = intval(IReq::get('point_value', 'post'));
if ($point_key && $point_v) {
if ($point_key == 'eq') {
$where .= 'point= "' . $point_v . '"' . $and;
} elseif ($point_key == 'gt') {
$where .= 'point > "' . $point_v . '"' . $and;
} else {
$where .= 'point < "' . $point_v . '"' . $and;
}
}
$regtimeBegin = IFilter::string(IReq::get('regtimeBegin', 'post'));
if ($regtimeBegin) {
$where .= '`time` > "' . $regtimeBegin . '"' . $and;
}
$regtimeEnd = IFilter::string(IReq::get('regtimeEnd', 'post'));
if ($regtimeEnd) {
$where .= '`time` < "' . $regtimeEnd . '"' . $and;
}
$where .= ' 1 ';
$content = array();
$content['title'] = IReq::get('title');
$content['content'] = IReq::get('content');
Mess::sendToUser($where, $content);
$this->message_list();
Util::showMessage("站内消息群发成功");
}
function role_edit_act()
{
$id = IFilter::act(IReq::get('id', 'post'));
$roleObj = new IModel('admin_role');
//要入库的数据
$dataArray = array('id' => $id, 'name' => IFilter::string(IReq::get('name', 'post')), 'rights' => null);
//检查权限码是否为空
$rights = IFilter::act(IReq::get('right', 'post'));
if (empty($rights) || $rights[0] == '') {
$this->roleRow = $dataArray;
$this->redirect('role_edit', false);
Util::showMessage('请选择要分配的权限');
}
//拼接权限码
$rightsArray = array();
$rightObj = new IModel('right');
$rightList = $rightObj->query('id in (' . join(",", $rights) . ')', '`right`');
foreach ($rightList as $key => $val) {
$rightsArray[] = trim($val['right'], ',');
}
$dataArray['rights'] = empty($rightsArray) ? '' : ',' . join(',', $rightsArray) . ',';
$roleObj->setData($dataArray);
if ($id) {
$where = 'id = ' . $id;
$roleObj->update($where);
} else {
$roleObj->add();
}
$this->redirect('role_list');
}
/**
* @brief 回复咨询信息
*/
function refer_reply()
{
$rid = intval(IReq::get('refer_id', 'post'));
$content = IReq::get('content');
if ($rid && $content) {
$content = IFilter::string($content, true);
$tb_refer = new IModel('refer');
$admin_id = $this->admin['admin_id'];
//管理员id
$data = array('answer' => $content, 'reply_time' => date('Y-m-d H:i:s'), 'admin_id' => $admin_id, 'status' => 1);
$tb_refer->setData($data);
$tb_refer->update("id=" . $rid);
}
$this->refer_list();
}
function integral()
{
/*获取积分增减的记录日期时间段*/
$this->historyTime = IFilter::string(IReq::get('history_time', 'post'));
$defaultMonth = 3;
//默认查找最近3个月内的记录
$lastStamp = ITime::getTime(ITime::getNow('Y-m-d')) - 3600 * 24 * 30 * $defaultMonth;
$lastTime = ITime::getDateTime('Y-m-d', $lastStamp);
if ($this->historyTime != null && $this->historyTime != 'default') {
$historyStamp = ITime::getDateTime('Y-m-d', $lastStamp - 3600 * 24 * 30 * $this->historyTime);
$this->c_datetime = 'datetime >= "' . $historyStamp . '" and datetime < "' . $lastTime . '"';
} else {
$this->c_datetime = 'datetime >= "' . $lastTime . '"';
}
$memberObj = new IModel('member');
$where = 'user_id = ' . $this->user['user_id'];
$this->memberRow = $memberObj->getObj($where, 'point');
$this->redirect('integral', false);
}
/**
* @brief 保存添加/修改发货信息
*/
public function ship_info_update()
{
// 获取POST数据
$id = IFilter::act(IReq::get('sid'), 'int');
$ship_name = IFilter::act(IReq::get('ship_name'));
$ship_user_name = IFilter::act(IReq::get('ship_user_name'));
$sex = IFilter::act(IReq::get('sex'), 'int');
$province = IFilter::act(IReq::get('province'), 'int');
$city = IFilter::act(IReq::get('city'), 'int');
$area = IFilter::act(IReq::get('area'), 'int');
$address = IFilter::act(IReq::get('address'));
$postcode = IFilter::act(IReq::get('postcode'), 'int');
$mobile = IFilter::act(IReq::get('mobile'));
$telphone = IFilter::act(IReq::get('telphone'));
$is_default = IFilter::act(IReq::get('is_default'), 'int');
//过滤string
$ship_name = IFilter::string($ship_name, true);
$ship_user_name = IFilter::string($ship_user_name, true);
$address = IFilter::string($address, true);
if ($telphone) {
$telphone = IFilter::string($telphone, true);
}
$tb_merch_ship_info = new IModel('merch_ship_info');
//判断是否已经有了一个默认地址
if (isset($is_default) && $is_default == 1) {
$tb_ship_info = new IQuery('merch_ship_info');
$tb_ship_info->fields = 'id,is_default';
$tb_ship_info->where = 'is_default=1';
$merch_ship_info = $tb_ship_info->find();
if (count($merch_ship_info) > 0) {
foreach ($merch_ship_info as $value) {
$sid = $value['id'];
$tb_merch_ship_info->setData(array('is_default' => 0));
$tb_merch_ship_info->update('id=' . $sid);
}
}
}
//设置存储数据
$arr['ship_name'] = $ship_name;
$arr['ship_user_name'] = $ship_user_name;
$arr['sex'] = $sex;
$arr['province'] = $province;
$arr['city'] = $city;
$arr['area'] = $area;
$arr['address'] = $address;
$arr['postcode'] = $postcode;
$arr['mobile'] = $mobile;
$arr['telphone'] = $telphone;
$arr['is_default'] = $is_default;
$arr['is_del'] = 1;
$tb_merch_ship_info->setData($arr);
//判断是添加还是修改
if ($id) {
$tb_merch_ship_info->update('id=' . $id);
} else {
$tb_merch_ship_info->add();
}
$this->redirect('ship_info_list');
}
/**
* @brief 设置发货信息的默认值
*/
public function ship_info_default()
{
$id = IFilter::act(IReq::get('id'), 'int');
$default = IFilter::string(IReq::get('default'));
$tb_merch_ship_info = new IModel('merch_ship_info');
if ($default == 1) {
$tb_merch_ship_info->setData(array('is_default' => 0));
$tb_merch_ship_info->update("seller_id = 0");
}
$tb_merch_ship_info->setData(array('is_default' => $default));
$tb_merch_ship_info->update("id = " . $id . " and seller_id = 0");
$this->redirect('ship_info_list');
}
/**
* @brief 到货通知筛选
*/
function notify_filter()
{
$search = IReq::get('search');
$keywords = IReq::get('keywords');
$where = ' 1 ';
if ($search && $keywords) {
$where .= " and {$search} like '%{$keywords}%' ";
}
$this->data['search'] = $search;
$this->data['keywords'] = $keywords;
$this->data['where'] = $where;
$page = IReq::get('page');
$page = intval($page) ? intval($page) : 1;
$and = ' and ';
$where = '';
$goodsname_k = IFilter::string(IReq::get('goodsname_k'));
$goodsname_v = IFilter::string(IReq::get('goodsname_v'));
if ($goodsname_k && $goodsname_v) {
if ($goodsname_k == 'eq') {
$where .= 'goods.name="' . $goodsname_v . '"' . $and;
} else {
$where .= 'goods.name like "%' . $goodsname_v . '%"' . $and;
}
}
$username_k = IFilter::string(IReq::get('username_k'));
$username_v = IFilter::string(IReq::get('username_v'));
if ($username_k && $username_v) {
if ($username_k == 'eq') {
$where .= 'u.username="******"' . $and;
} else {
$where .= 'u.username like "%' . $username_v . '%"' . $and;
}
}
$store_nums_k = IFilter::string(IReq::get('store_nums_k'));
$stror_nums_v = intval(IReq::get('store_nums_v')) ? intval(IReq::get('store_nums_v')) : 0;
if ($store_nums_k) {
if ($store_nums_k == 'gt') {
$where .= 'goods.store_nums > "' . $stror_nums_v . '"' . $and;
} elseif ($store_nums_k == 'eq') {
$where .= 'goods.store_nums = "' . $stror_nums_v . '"' . $and;
} else {
$where .= 'goods.store_nums < "' . $stror_nums_v . '"' . $and;
}
}
$email_k = IFilter::string(IReq::get('email_k'));
$email_v = IFilter::string(IReq::get('email_v'));
if ($email_k && $email_v) {
if ($email_k == 'gt') {
$where .= 'notify.email = "' . $email_v . '"' . $and;
} else {
$where .= 'notify.email like "%' . $email_v . '%"' . $and;
}
}
$regtimeBegin = IFilter::string(IReq::get('regtimeBegin'));
if ($regtimeBegin) {
$where .= 'notify.register_time > "' . $regtimeBegin . '"' . $and;
}
$regtimeEnd = IFilter::string(IReq::get('regtimeEnd'));
if ($regtimeEnd) {
$where .= 'notify.register_time < "' . $regtimeEnd . '"' . $and;
}
$status = intval(IReq::get('status'));
if ($status && $status != '-1') {
$where .= 'notify.notify_status = "' . $status . '"' . $and;
}
$where .= ' 1 ';
$query = new IQuery("notify_registry as notify");
$query->join = "join goods as goods on notify.goods_id = goods.id left join user as u on notify.user_id = u.id";
$query->fields = "notify.*,u.username,goods.name as goods_name,goods.store_nums";
$query->page = $page;
$query->where = $where;
$this->data['list_items'] = $query->find();
//debug($this->data['items']);
$this->data['pageBar'] = $query->getPageBar('/message/notify_filter/');
$this->setRenderData($this->data);
$this->redirect('notify_filter');
}
function applySkin()
{
$skin = IFilter::string(IReq::get('skin'));
if ($skin != null) {
$data = array('skin' => $skin);
Config::edit('config/config.php', $data);
}
$this->clearCache();
$this->redirect('conf_ui');
}
function applySkin()
{
$skin = IFilter::string(IReq::get('skin'));
$theme = IFilter::string(IReq::get('theme'));
if ($theme && $skin) {
Common::applySkin($theme, $skin);
}
$this->redirect('conf_ui');
}
