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