<?php /** * Created by PhpStorm. * User: Administrator * Date: 2018/12/25 * Time: 8:46 */ namespace app\admin\controller; use cmf\controller\AdminBaseController; use think\Db; use think\Validate; class InsuranceTypeController extends AdminBaseController { public function index(){ $where=[]; $param = $this->request->param(); $keyword = empty($param['keyword']) ? '' : $param['keyword']; if (!empty($keyword)) { $where['insurance_type_name'] = ['like', "%$keyword%"]; } $data=Db::name('insurance_type') ->where('delete_time',0) ->where($where) ->order('list_order asc,create_time desc') ->paginate(10); $data->appends($param); $this->assign([ 'data'=>$data, 'page'=>$data->render(), 'keyword'=>$keyword, ]); return $this->fetch(); } //编辑 public function edit(){ $id=$this->request->param('id', 0, 'intval'); if($this->request->isPost()){ $param=$this->request->param(); $validate = new Validate([ 'insurance_type_name' => 'require', ]); $validate->message([ 'insurance_type_name' => '保险类型不能为空!', ]); if (!$validate->check($param)) { $this->error($validate->getError()); } $param['update_time']=time(); Db::name('insurance_type') ->where('id',$id) ->update($param); $this->success('更新成功!'); }else{ $data = Db::name('insurance_type') ->where('id', $id) ->find(); $this->assign([ 'data'=>$data, ]); return $this->fetch(); } } //添加 public function add(){ if($this->request->isPost()){ $param=$this->request->param(); $param['create_time']=time(); $param['update_time']=time(); $validate = new Validate([ 'insurance_type_name' => 'require', ]); $validate->message([ 'insurance_type_name' => '保险类型不能为空!', ]); if (!$validate->check($param)) { $this->error($validate->getError()); } Db::name('insurance_type') ->insertGetId($param); $this->success('添加成功!'); }else{ return $this->fetch(); } } //删除 public function delete(){ $param = $this->request->param(); if (isset($param['id'])) { $id = $this->request->param('id', 0, 'intval'); $resultPortal = Db::name('insurance_type') ->where(['id' => $id]) ->update(['delete_time' => time()]); if($resultPortal){ $this->success("删除成功!", ''); }else{ $this->error("删除失败!", ''); } } if (isset($param['ids'])) { $ids = $this->request->param('ids/a'); $result = Db::name('insurance_type') ->where(['id' => ['in', $ids]]) ->update(['delete_time' => time()]); if ($result) { $this->success("删除成功!", ''); }else{ $this->error("删除失败!", ''); } } } //排序 public function listOrder(){ $ids=$this->request->param('list_orders/a'); if (!empty($ids)) { foreach ($ids as $key => $r) { $data['list_order'] = $r; Db::name('insurance_type')->where('id',$key)->update($data); } } $this->success('排序成功!',''); } }