infantServiceApi/app/api/controller/Education.php

<?php

namespace app\api\controller;

use Alipay\EasySDK\Kernel\Base;
use app\model\api\ContractRecord;
use app\model\api\ContractRecord as UserContractRecordModel;
use app\model\api\ContractTemplate as ContractTemplateModel;
use app\model\api\EducationCourse;
use library\services\UtilService;
use think\facade\Db;
use think\facade\Log;


class Education
{
    /**
     * 课程列表页面
     * @return \think\response\Json
     */
    public function index()
    {
        $EducationModel = new \app\model\api\Education();
        $where["audit"] = 1;
        $type1 = input("type1", "");
        if ($type1 !== "") {
            $where["type1"] = $type1;
        } else {
            $type1 = 2;
        }

        if ($type1 == 0) {
            $where["type1"] = 0;
        } elseif ($type1 == 1) {
            $where["type1"] = 1;
        }

        $page = input('page/d', 1);
        $pageSize = input('pageSize/d', 20);

        $grlist = $EducationModel->where($where)
            ->order("od asc,recommend desc,gr_id desc")
            ->paginate($pageSize, false, ['page' => $page]);

        $result = ['grlist' => $grlist->items(), 'total' => $grlist->total()];
        $result['grlist'] = $this->getCountAndAlll($result['grlist']);

        return app('json')->success($result);
    }



    /**
     * 获取轮播列表
     * @return mixed
     */
    public function recommend()
    {
        $EducationModel = new \app\model\api\Education();
        $where = [
            'audit' => 1,
            'recommend' => 1,
        ];
        $recommendList = $EducationModel->getEducationGrList($where, 9, "od asc,recommend desc,gr_id desc");
        $result = ['recommendList' => $recommendList];

        return app('json')->success($result);
    }


    /**
     * 获取课程组列表
     * @return mixed
     */
    private function getCountAndAlll($grlist)
    {
        foreach ($grlist as &$v) {
            $count = EducationCourse::where('course_status', 1)
                ->where('gr_id', $v['gr_id'])
                ->where('course_audit', 1)
                ->field('count(*) as count,sum(course_play_count) as alll')
                ->find();
            $v['count'] = $count['count'];
            $count['alll'] += $v['times'];
            $v['alll'] = $count['alll'] ? $count['alll'] : 0;
        }
        return $grlist;
    }


    /**
     * 获取课程列表
     * @param $gr_id
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getCourseList($gr_id)
    {

        $courseList = EducationCourse::where('course_status', 1)
            ->where('gr_id', $gr_id)
            ->where('course_audit', 1)
            ->select();

        return json([
            'code' => 200,
            'msg' => 'ok',
            'data' => $courseList
        ]);
    }
    /**
     * 合约列表
     * @param \app\Request $request
     * @return mixed
     */
    public function getContractList(\think\Request $request)
    {
//        $pageSize = 50;
//        $post =  UtilService::getMore([
//            ['page',1],
//            ['pageSize',50],
//            ['nickname',''],
////            ['uid',''],
//            ['parent_uid',''],
//            ['mobile',''],
//            ['status',''],
//            ['time',[]],
//        ],$request);
////        $post['uid']=$request->user["uid"];
//        $data = (new UserModel)->getDataList($post,"*",1);
//        return app('json')->success([
//            'list'      => $data["list"],
//            'pageCount' => $data["totalCount"],
//            'pageSize'  => $data["pageSize"],
//            'page'      => $data["page"],
//        ]);
        $post = UtilService::getMore([
            ['page', 1],
            ['pageSize', 50],
            ['status',-2] //1未签约 2已签约 3已解约
        ], $request);
        $post["pageSize"] = $post["pageSize"]>50 ? 50 : (int)$post["pageSize"];
        $post["page"]     = $post["page"]<=0 ? 1 : (int)$post["page"];
        $where=[];
        $where[]=["uid","=",$request->user["uid"]];
        $totalCount = (new UserContractRecordModel)->where($where)->count();
        if ($post["status"]!=-2){
            $where[]=['status','=',$post["status"]];
        }
        $data=null;
        if($totalCount>0){
            $data = (new UserContractRecordModel)
//                ->field("")
//                ->alias("ut")
//                ->join("show_template t", "t.id = show_template_id","left")
                ->where($where)
                ->order("is_default", "desc")
                ->order("id", "desc")
                ->page($post["page"], $post["pageSize"])
                ->select();
            foreach($data as $k=>$v){
                $data[$k]["is_use"]      = 1;//是否已经购买或者可以使用
                switch ($data[$k]["status"]){
                    case 0:
                        $data[$k]["status_name"] = "未签约";
                        break;
                    case 1:
                        $data[$k]["status_name"] = "已签约";
                        break;
                    case -1:
                        $data[$k]["status_name"] = "已解约";
                        break;
                }
            }
        }
        $data = empty($data)?[]:$data;
        return app('json')->success(["list" => $data, "pageSize" => $post["pageSize"],"page"=>$post["page"],"totalCount"=>$totalCount]);
    }
    /**
     * 合约模版列表
     * @param \app\Request $request
     * @return mixed
     */
    public function getContractTemplateList(\think\Request $request)
    {
        $post = UtilService::getMore([
            ['page', 1],
            ['pageSize', 50],
//            ['status',-2] //1未签约 2已签约 3已解约
        ], $request);
        $post["pageSize"] = $post["pageSize"]>50 ? 50 : (int)$post["pageSize"];
        $post["page"]     = $post["page"]<=0 ? 1 : (int)$post["page"];
        $where=[];
        $where[]=["is_show","=",1];
        $totalCount = (new ContractTemplateModel)->where($where)->count();
//        if ($post["status"]!=-2){
//            $where[]=['status','=',$post["status"]];
//        }
        $data=null;
        if($totalCount>0){
            $data = (new ContractTemplateModel)
                ->where($where)
                ->field('id,title,is_show,imgs,admin_time,time')
                ->order("id", "desc")
                ->page($post["page"], $post["pageSize"])
                ->select();
            foreach($data as $k=>$v){
                $data[$k]["imgs"]        = getImageAr($v["imgs"]);
                $data[$k]["img"]         = empty($data[$k]["imgs"]) ? "" : $data[$k]["imgs"][0];
                $data[$k]["time"]       = date("Y-m-d H:i:s",$v["time"]);
                $data[$k]["admin_time"] = date("Y-m-d H:i:s",$v["admin_time"]);
            }
        }
        $data = empty($data)?[]:$data;
        return app('json')->success(["list" => $data, "pageSize" => $post["pageSize"],"page"=>$post["page"],"totalCount"=>$totalCount]);
    }
    /**
     * 合约模版详情
     * @param \app\Request $request
     * @return mixed
     */
//    public function getContractTemplatInfo(\think\Request $request)
//    {
//        $post = UtilService::getMore([
//            ['id', ''],
//        ], $request);
//        $where=[];
//        $where[]=["is_show","=",1];
//        $where[]=["id","=",$post['id']];
//        $totalCount = (new ContractTemplateModel)->where($where)->count();
//        $data=null;
//        if($totalCount>0){
//            $data = (new ContractTemplateModel)
//                ->where($where)
////                ->order("id", "desc")
////                ->page($post["page"], $post["pageSize"])
//                ->find();
////            $data['id'] = $oData['id'];
//            if (empty($data)){
//                return app('json')->fail("模版号不存在");
//            }
//            $data['imgs'] = getImageAr($data["imgs"]);
//
//            $data['content'] = json_decode($data['content']);
//            $data['time'] = date("Y-m-d H:i:s", $data["time"]);
//            $data['admin_time'] = date("Y-m-d H:i:s", $data["admin_time"]);
//        }
//        $data = empty($data)?[]:$data;
//        return app('json')->success($data);
//    }
    public function getContractTemplatInfo($id)
    {
        $data = (new ContractTemplateModel)
            ->field("*")
            ->where("id", $id)
            ->where("is_show",1)
            ->find();
        if (empty($data)) {
            return app('json')->fail("模板不存在");
        }
//        if ($data["is_init"] == 0 && $data["status"] != 1) {
//            return app('json')->fail("模板已下架");
//        }
        $data = $data->toArray();
//        $data["is_use"] = 0;
        $data["imgs"] = getImageAr($data["imgs"]);
        $data['content'] = json_decode($data['content']);
        $data["img"] = empty($data["imgs"]) ? "" : $data["imgs"][0];
        $data['time'] = date("Y-m-d H:i:s", $data["time"]);
        $data['admin_time'] = date("Y-m-d H:i:s", $data["admin_time"]);
//        $data["sales_count"] = $data["real_sales"] + $data["unreal_sales"];
//        unset($data["real_sales"]);
        unset($data["code"]);
        //验证是否购买过并添加浏览记录
//        $this->checkUser(request()->header("token", ""));
//        if (!empty($this->user)) {
//            $data["is_use"] = (new UserShowTemplate)->where("uid", $this->user["uid"])->where("show_template_id", $data["id"])->count() > 0 ? 1 : 0;
//            (new ShowTemplate)->where('id', $data["id"])->inc('look_count', 1)->update();
//        }
        return app('json')->success($data);
    }
//    合约时间到期自动解约
    public function ContractTemplatEnd(){
        $lst = (new UserContractRecordModel())->where("status",1)->where("end_time","<",time())->select();
        if(!empty($lst)){
            $lst = $lst->toArray();
            Log::info('搜索条件：' . json_encode($lst, JSON_UNESCAPED_UNICODE));
        }
        (new UserContractRecordModel())->where("status",1)->where("end_time","<",time())->update(["status"=>2]);
        return app('json')->success('修改完成');
    }


}