123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184 |
- <?php
- namespace app\admin\controller;
- use app\common\controller\Backend;
- use Exception;
- use Think\Db;
- /**
- * 活动人员信息修改管理
- *
- * @icon fa fa-circle-o
- */
- class Activepeoplemodify extends Backend
- {
- /**
- * Activepeoplemodify模型对象
- * @var \app\admin\model\Activepeoplemodify
- */
- protected $model = null;
- public function _initialize()
- {
- parent::_initialize();
- $this->model = new \app\admin\model\Activepeoplemodify;
- $this->view->assign("coupontypeList", $this->model->getCoupontypeList());
- $this->view->assign("isFreeList", $this->model->getIsFreeList());
- $this->view->assign("isSelfList", $this->model->getIsSelfList());
- $this->view->assign("statusList", $this->model->getStatusList());
- }
- /**
- * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
- * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
- * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
- */
- /**
- * 查看
- */
- public function index()
- {
- //当前是否为关联查询
- $this->relationSearch = true;
- //设置过滤方法
- $this->request->filter(['strip_tags', 'trim']);
- if ($this->request->isAjax()) {
- //如果发送的来源是Selectpage,则转发到Selectpage
- if ($this->request->request('keyField')) {
- return $this->selectpage();
- }
- list($where, $sort, $order, $offset, $limit) = $this->buildparams();
- $list = $this->model
- ->with(['active','activeorder','activepeople','user'])
- ->where($where)
- ->order($sort, $order)
- ->paginate($limit);
- foreach ($list as $row) {
-
- $row->getRelation('active')->visible(['title','desc']);
- $row->getRelation('activeorder')->visible(['order_sn']);
- $row->getRelation('activepeople')->visible(['name','idcard','mobile','emergencycontact','contactmobile']);
- $row->getRelation('user')->visible(['nickname','mobile']);
- }
- $result = array("total" => $list->total(), "rows" => $list->items());
- return json($result);
- }
- return $this->view->fetch();
- }
- /**
- * 编辑
- */
- public function edit($ids = null) {
- $row = $this->model->get($ids);
- if (!$row) {
- $this->error(__('No Results were found'));
- }
- $adminIds = $this->getDataLimitAdminIds();
- if (is_array($adminIds)) {
- if (!in_array($row[$this->dataLimitField], $adminIds)) {
- $this->error(__('You have no permission'));
- }
- }
- if ($this->request->isPost()) {
- $params = $this->request->post("row/a");
- if ($params) {
- $params = $this->preExcludeFields($params);
- if ($row['status'] != 0) {
- $this->error('该数据已经操作过');
- }
- $result = false;
- Db::startTrans();
- try {
- //修改信息
- if (isset($params['status'])) {
- if ($params['status'] == 1) {
- //通过
- $people_data = [
- 'name' => $row['name'],
- 'idcard' => $row['idcard'],
- 'mobile' => $row['mobile'],
- 'emergencycontact' => $row['emergencycontact'],
- 'contactmobile' => $row['contactmobile'],
- 'modifystatus' => 0,
- 'updatetime' => time()
- ];
- $rs = Db::name('active_people')->where(['id' => $row['people_id'], 'modifystatus' => 1])->setField($people_data);
- if (!$rs) {
- Db::rollback();
- return ['code' => 0, 'msg' => '操作失败'];
- }
- //发送消息
- $active_title = Db::name('active')->where(['id' => $row['active_id']])->value('title');
- $data = [
- 'user_id' => $row['user_id'],
- 'type' => 1,
- 'title' => '活动通知',
- 'content' => '您报名的' . $active_title . '活动人员信息修改已通过',
- 'createtime' => time()
- ];
- Db::name('sys_msg')->insertGetId($data);
- } elseif ($params['status'] == 2) {
- //拒绝
- $rs = Db::name('active_people')->where(['id' => $row['people_id'], 'modifystatus' => 1])->setField('modifystatus', 0);
- if (!$rs) {
- Db::rollback();
- return ['code' => 0, 'msg' => '操作失败'];
- }
- //发送消息
- $active_title = Db::name('active')->where(['id' => $row['active_id']])->value('title');
- $data = [
- 'user_id' => $row['user_id'],
- 'type' => 1,
- 'title' => '活动通知',
- 'content' => '您报名的' . $active_title . '活动人员信息修改已被拒绝',
- 'createtime' => time()
- ];
- Db::name('sys_msg')->insertGetId($data);
- }
- }
- //是否采用模型验证
- if ($this->modelValidate) {
- $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
- $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : $name) : $this->modelValidate;
- $row->validateFailException(true)->validate($validate);
- }
- $result = $row->allowField(true)->save($params);
- Db::commit();
- } catch (ValidateException $e) {
- Db::rollback();
- $this->error($e->getMessage());
- } catch (PDOException $e) {
- Db::rollback();
- $this->error($e->getMessage());
- } catch (Exception $e) {
- Db::rollback();
- $this->error($e->getMessage());
- }
- if ($result !== false) {
- $this->success();
- } else {
- $this->error(__('No rows were updated'));
- }
- }
- $this->error(__('Parameter %s can not be empty', ''));
- }
- $this->view->assign("row", $row);
- return $this->view->fetch();
- }
- }
|