123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126 |
- <?php
- namespace app\admin\controller;
- use app\common\model\User;
- use think\App;
- use think\Db;
- class DinnerWechat extends Auth
- {
- public function __construct(App $app = null) {
- parent::__construct($app);
- $this->model= new \app\common\model\DinnerWechat();
- $this->table= $this->model->table;
- }
- public function index(){
- if(request()->isAjax()){
-
- $length = input('rows',10,'intval');
- $page = input('page',1,'intval');
- $start = ($page - 1) * $length;
-
- $sortRow = input('sidx','id','trim');
- $sort = input('sord','desc','trim');
- $order = 'a.id desc';
- $title = input('title','','trim');
- if($title){
- $map[] = ['o.name','like','%'.$title.'%'];
- }
- $map= empty($map) ? true: $map;
-
- $lists = Db::name('dinner_wechat')
- ->alias('a')
- ->join('org o','a.org_id = o.id')
- ->field('a.*,o.name')
- ->where($map)
- ->limit($start,$length)
- ->order($order)
- ->select();
-
- $totalCount = Db::name('dinner_wechat')
- ->alias('a')
- ->join('org o','a.org_id = o.id')
- ->where($map)->count();
- $totalPage = ceil($totalCount/$length);
- $result['page'] = $page;
- $result['total'] = $totalPage;
- $result['records'] = $totalCount;
- $result['rows'] = $lists;
- return json($result);
- }else{
- return $this->fetch();
- }
- }
- public function index2(){
- $map[] = ['org_id','=',$this->orgId];
- $info = Db::name('dinner_wechat')
- ->where($map)
- ->find();
- $this->assign('info',$info);
- return $this->fetch();
- }
-
- public function add($id=0){
- if(request()->isPost()){
- $res = $this->model->updates();
- if($res){
- $this->success('操作成功',url('index'));
- }else{
- $this->error($this->model->getError());
- }
- }else{
- $meta_title = '新增配置';
- if($id){
- $info = Db::name('dinner_wechat')->where('id',$id)->find();
- $this->assign('info',$info);
- $meta_title = '编辑配置';
- }
- $this->assign('meta_title',$meta_title);
- $orgs = Db::name('org')->where('del',0)->where('type',2)->field('id,name as title')->select();
- $this->assign('orgs',$orgs);
- return $this->fetch();
- }
- }
-
- public function del($id=0){
- $info = Db::name('dinner_wechat')->where('id',$id)->find();
- if(!$info){
- $this->error('该记录不存在');
- }
- $res = Db::name('dinner_wechat')->delete($id);
- if($res){
- $this->success('删除成功');
- }else{
- $this->error('删除失败');
- }
- }
- }
|