getMemberGradeArr(); $search_field_value = input('search_field_value'); $search_field_name = input('search_field_name'); $condition = array(); if ($search_field_value != '') { switch ($search_field_name) { case 'member_name': $condition[] = array('member_name', 'like', '%' . trim($search_field_value) . '%'); break; case 'member_email': $condition[] = array('member_email', 'like', '%' . trim($search_field_value) . '%'); break; case 'member_mobile': $condition[] = array('member_mobile', 'like', '%' . trim($search_field_value) . '%'); break; case 'member_truename': $condition[] = array('member_truename', 'like', '%' . trim($search_field_value) . '%'); break; } } $search_state = input('search_state'); switch ($search_state) { case 'no_informallow': $condition[] = array('inform_allow', '=', '2'); break; case 'no_isbuy': $condition[] = array('is_buylimit', '=', '0'); break; case 'no_isallowtalk': $condition[] = array('is_allowtalk', '=', '0'); break; case 'no_memberstate': $condition[] = array('member_state', '=', '0'); break; } //会员等级 $search_grade = intval(input('get.search_grade')); if ($search_grade > 0 && $member_grade) { if (isset($member_grade[$search_grade + 1]['exppoints'])) { $condition[] = array('member_exppoints', 'between', array($member_grade[$search_grade]['exppoints'], $member_grade[$search_grade + 1]['exppoints'])); } else { $condition[] = array('member_exppoints', '>=', $member_grade[$search_grade]['exppoints']); } } //排序 $order = trim(input('get.search_sort')); if (!in_array($order, array('member_logintime desc', 'member_loginnum desc'))) { $order = 'member_id desc'; } $member_list = $member_model->getMemberList($condition, '*', 10, $order); //整理会员信息 if (is_array($member_list) && !empty($member_list)) { foreach ($member_list as $k => $v) { $member_list[$k]['member_addtime'] = $v['member_addtime'] ? date('Y-m-d H:i:s', $v['member_addtime']) : ''; $member_list[$k]['member_logintime'] = $v['member_logintime'] ? date('Y-m-d H:i:s', $v['member_logintime']) : ''; $member_list[$k]['member_grade'] = ($t = $member_model->getOneMemberGrade($v['member_exppoints'], false, $member_grade)) ? $t['level_name'] : ''; } } View::assign('member_grade', $member_grade); View::assign('search_sort', $order); View::assign('search_field_name', trim($search_field_name)); View::assign('search_field_value', trim($search_field_value)); View::assign('member_list', $member_list); View::assign('show_page', $member_model->page_info->render()); View::assign('filtered', $condition ? 1 : 0); //是否有查询条件 $this->setAdminCurItem('member'); return View::fetch(); } public function add() { if (!request()->isPost()) { return View::fetch(); } else { //需要完善地方 1.对录入数据进行判断 2.对判断用户名是否存在 $member_model = model('member'); $data = array( 'member_name' => trim(input('post.member_name')), 'member_password' => input('post.member_password'), 'member_email' => input('post.member_email'), 'member_truename' => input('post.member_truename'), 'member_sex' => input('post.member_sex'), 'member_qq' => input('post.member_qq'), 'member_ww' => input('post.member_ww'), 'member_addtime' => TIMESTAMP, 'member_loginnum' => 0, 'inform_allow' => 1, //默认允许举报商品 ); $member_validate = ds_validate('member'); if (!$member_validate->scene('add')->check($data)) { $this->error($member_validate->getError()); } $result = $member_model->addMember($data); if ($result) { dsLayerOpenSuccess(lang('ds_common_op_succ')); } else { $this->error(lang('member_add_fail')); } } } public function edit() { //注:pathinfo地址参数不能通过get方法获取,查看“获取PARAM变量” $member_id = intval(input('param.member_id')); if (empty($member_id)) { $this->error(lang('param_error')); } $member_model = model('member'); $condition = array(); $condition[] = array('member_id', '=', $member_id); $member_array = $member_model->getMemberInfo($condition); if (!request()->isPost()) { View::assign('member_array', $member_array); return View::fetch(); } else { $member_mobile = input('post.member_mobile'); if ($member_mobile == encrypt_show($member_array['member_mobile'], 4, 4)) { $member_mobile = $member_array['member_mobile']; } $data = array( 'member_email' => input('post.member_email'), 'member_truename' => input('post.member_truename'), 'member_sex' => input('post.member_sex'), 'member_qq' => input('post.member_qq'), 'member_ww' => input('post.member_ww'), 'inform_allow' => input('post.inform_allow'), 'is_buylimit' => input('post.isbuy'), 'is_allowtalk' => input('post.allowtalk'), 'member_state' => input('post.member_state'), 'member_cityid' => input('post.city_id'), 'member_provinceid' => input('post.province_id'), 'member_areainfo' => input('post.region'), 'member_areaid' => input('post.area_id'), 'member_mobile' => $member_mobile, 'member_emailbind' => input('post.member_emailbind'), 'member_mobilebind' => input('post.member_mobilebind'), 'member_auth_state' => input('post.member_auth_state'), ); if (input('post.member_password')) { $data['member_password'] = md5(input('post.member_password')); } if (input('post.member_paypwd')) { $data['member_paypwd'] = md5(input('post.member_paypwd')); } $member_validate = ds_validate('member'); if (!$member_validate->scene('edit')->check($data)) { $this->error($member_validate->getError()); } $result = $member_model->editMember(array('member_id' => $member_id), $data, $member_id); if ($result >= 0) { dsLayerOpenSuccess(lang('ds_common_op_succ')); } else { $this->error(lang('ds_common_op_fail')); } } } /** * ajax操作 */ public function ajax() { $branch = input('param.branch'); $condition = array(); switch ($branch) { /** * 验证会员是否重复 */ case 'check_user_name': $member_model = model('member'); $condition[] = array('member_name', '=', input('param.member_name')); $condition[] = array('member_id', '<>', intval(input('get.member_id'))); $list = $member_model->getMemberInfo($condition); if (empty($list)) { echo 'true'; exit; } else { echo 'false'; exit; } break; /** * 验证邮件是否重复 */ case 'check_email': $member_model = model('member'); $condition[] = array('member_email', '=', input('param.member_email')); $condition[] = array('member_id', '<>', intval(input('param.member_id'))); $list = $member_model->getMemberInfo($condition); if (empty($list)) { echo 'true'; exit; } else { echo 'false'; exit; } break; } } /** * 设置会员状态 */ public function memberstate() { $member_id = input('param.member_id'); $member_id_array = ds_delete_param($member_id); if ($member_id_array == FALSE) { ds_json_encode('10001', lang('param_error')); } $data['member_state'] = input('param.member_state') ? input('param.member_state') : 0; $condition = array(); $condition[] = array('member_id', 'in', $member_id_array); $result = Db::name('member')->where($condition)->update($data); if ($result >= 0) { foreach ($member_id_array as $key => $member_id) { dcache($member_id, 'member'); } $this->log(lang('ds_edit') . '[ID:' . implode(',', $member_id_array) . ']', 1); ds_json_encode('10000', lang('ds_common_op_succ')); } else { ds_json_encode('10001', lang('ds_common_op_fail')); } } /** * 获取卖家栏目列表,针对控制器下的栏目 */ protected function getAdminItemList() { $menu_array = array( array( 'name' => 'member', 'text' => lang('ds_manage'), 'url' => (string)url('Member/member') ), ); if (request()->action() == 'add' || request()->action() == 'member') { $menu_array[] = array( 'name' => 'add', 'text' => lang('ds_add'), 'url' => "javascript:dsLayerOpen('" . (string)url('Member/add') . "','" . lang('ds_add') . "')" ); } return $menu_array; } }