NeedController.php 5.9 KB
<?php
// +----------------------------------------------------------------------
// | ThinkCMF [ WE CAN DO IT MORE SIMPLE ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2018 http://www.thinkcmf.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Author: 老猫 <thinkcmf@126.com>
// +----------------------------------------------------------------------
namespace app\portal\controller;
use app\portal\model\UserNeedModel;
use cmf\controller\AdminBaseController;
use app\portal\model\NeedAnswerModel;
use app\portal\model\MemberModel;
use app\portal\model\UserModel;
use app\portal\service\PostService;
use think\Db;
use think\Request;
use think\Loader;
/**
 * @title 保证金内容管理
 * @description 接口说明
 * @group 接口分组
 */

class NeedController extends AdminBaseController
{
//    列表
    public function index(Request $request)
    {
        $where_coo['n.status'] = array('neq',9);
//        $where_coo['type'] = 2;
//        $where_coo = array();
        if($request->post()){
            $search = $request->post();
            if($search['start_time']){
                $start = strtotime($search['start_time']);
                if($search['end_time']){
                    $end = strtotime($search['end_time']);
                }else{
                    $end = time();
                }
                $where_coo['n.update_time'] = array('between',"$start,$end");
                $this->assign('start_time',date('Y-m-d H:i',$start));
                $this->assign('end_time',date('Y-m-d H:i',$end));
            }
            if($search['keyword']){
                $where_coo['n.title'] = array('like',"%".$search['keyword']."%");
                $this->assign('keyword',$search['keyword']);
            }
        }
        $coo_list = Db::name('UserNeed')->alias('n')
            ->join("Member m",'m.id = n.user_id')
            ->where($where_coo)
            ->field("m.name as user_name,m.tel as user_tel,n.*")
            ->order('create_time desc')
            ->select()->toArray();


        $this->assign('list',$coo_list);
        return $this->fetch('index');
    }


//    详情
    public function detail(){
        $data = $this->request->param();
        $where_need['n.id'] = $data['id'];
        $where_need['n.status'] = array('neq',9);
        $need = Db::name('UserNeed')->alias('n')
            ->join("Member m",'m.id = n.user_id')
            ->where($where_need)
            ->field('m.name as user_name,n.*')
            ->find();
        if(!$need){
            $this->error('需求错误');
        }
        $this->assign('list',$need);
        return $this->fetch();
    }

//    修改信息
    public function change(Request $request)
    {
        $data = $request->Post();
        $validate = Loader::validate('UserNeed');
        if(!$validate->check($_POST)){
            return json(array('code'=>0,'msg'=>$validate->getError()));
        }
//            加数据库
//            保证金
        $city = $data['city'];
        $area = $data['area'];
//            查询地区
        $where_area['area_name'] = array('like',"%$city%");
        $city_id = Db::name('Areas')->where($where_area)->field('area_id')->find();
        $where_money['city'] = array('like',"%".$city_id['area_id'].'%');
        $where_money['status'] = 1;
        $where_money['low_area'] = array('lt',$area);
        $where_money['height_area'] = array('egt',$area);
        $money = Db::name('MoneyRule')->where($where_money)->field('money')->find();
        if(!$money){
            $where_elsemoney['city'] = 0;
            $where_elsemoney['status'] = 1;
            $where_elsemoney['low_area'] = array('lt',$area);
            $where_elsemoney['height_area'] = array('egt',$area);
            $elsemoney = Db::name('MoneyRule')->where($where_elsemoney)->field('money')->find();
            if($elsemoney){
                $data['pay_money'] = $elsemoney['money'];
            }else{
                $this->error('保证金获取失败');
            }
        }else{
            $data['pay_money'] = $money['money'];
        }

        $model = new UserNeedModel();
//                    修改
        $where_need['id'] = $request->param('id');
        $where_need['status'] = array('neq',9);
        $need = Db::name('UserNeed')->where($where_need)->find();
        $data['user_id'] = $need['user_id'];
        if(!$need){
            $this->error('该需求不可修改');
        }else{
//            $data['id'] = $data['need_id'];
            if($need['status'] == 2){
                unset($data['pay_money']);
            }
            $data['create_time'] = strtotime($data['create_time']);
            $data['update_time'] = strtotime($data['update_time']);
            $data['pay_time'] = strtotime($data['pay_time']);
            $data['choose_time'] = strtotime($data['choose_time']);
            $save = $model->isUpdate(true)->allowField(true)->save($data);
        }
        if($save){
            $final['need_id'] = $model->id;
            $this->success('修改成功',url('Need/index'));
        }else{
            $this->error('修改失败');
        }

    }


    //  删除
    public function del(Request $request){
        $ids = $this->request->post();
        $id = $request->param('id');
        if($ids){
            $add_del['id'] = array('in',$ids['ids']);
        }else if($id){
            $add_del['id'] = $request->param('id');
        }else{
            $this->error('删除失败');
        }
        $add_del['status'] = 9;
        $model = new UserNeedModel();
        $del = $model->isUpdate(true)->allowField(true)->save($add_del);
        if($del){
            $this->success('删除成功',url('index'));
        }else{
            $this->error('删除失败');
        }
    }

}