infantServiceApi/app/system/controller/Audit.php

<?php
// +----------------------------------------------------------------------
// | [ WE CAN DO IT MORE SIMPLE  ]
// +----------------------------------------------------------------------
// | Copyright (c) 2018-2020 rights reserved.
// +----------------------------------------------------------------------
// |
// +----------------------------------------------------------------------
// | Date: 2020-11-08 12:56
// +----------------------------------------------------------------------

namespace app\system\controller;

use app\BaseController;
use app\model\api\User as UserModel;
use app\model\api\ServiceType as ServiceTypeModel;
use app\model\api\InfoAudit;
use app\model\api\TypeAudit;
use app\model\api\UserAudit;
use app\model\api\ServiceType;
use app\model\api\ServiceTimeType;
use app\model\api\City as CityModel;
use app\model\api\Sys as SysModel;


use think\db\exception\DbException;
use think\facade\Db;
use app\Request;
use library\services\UtilService;
use library\utils\UserUtilsTool;

class Audit extends BaseController
{
    
    /***********************************审核******************************/
    /**
     * 第一步审核初始化
     * @return type
     */
    public function infoAuditInit()
    {
        return app('json')->success([
            'all'  => (new InfoAudit)->count(),
            'wait' => (new InfoAudit)->where('status', 0)->count(),
            'ok'   => (new InfoAudit)->where('status', 1)->count(),
            'no'   => (new InfoAudit)->where('status', -1)->count(),
        ]);
    }

    /**
     * 获取第一步审核列表
     * @param Request $request
     */
    public function infoAuditList(Request $request)
    {
        $pageSize = 50;
        $post     = UtilService::getMore(
            [
                ['page', 1],
                ['keyword',''],
                ['mobile',''],
                ['user_mobile',''],
                ['status', ''],
                ['uid', ''],
                ['time',[]],
            ], $request
        );
        $where    = [];
        if(is_numeric($post['status'])) {
            $where[]=["t.status","=",(int)$post['status']];
        }
        if(is_numeric($post['uid']) && $post['uid']>0) {
            $where[]=["t.uid","=",(int)$post['uid']];
        }else if(is_mobile($post['user_mobile'])){
            $udata = (new UserModel)->where("mobile",$post['user_mobile'])->find();
            if(!empty($udata)){
                $where[]=["t.uid","=",(int)$udata['uid']];
            }
        }
        if(is_mobile($post['mobile'])) {
            $where[]=["t.mobile","=",$post['mobile']];
        }
        
        
        
        $startTime = "";
        $endTime = "";
        if(!empty($post['time'][0]) && !empty($post['time'][1])) {
           $startTime =  strtotime($post['time'][0]);
           $endTime = strtotime($post['time'][1]);
           $where[]=["t.time","between","{$startTime},{$endTime}"];
        }
        if(!empty($post['keyword'])){
            $where[]=["t.name","=",$post['keyword']];
        }
        $pageCount = (new InfoAudit)->alias("t")->where($where)->count();
        $data = null;
        if($pageCount>0){
            $data = (new InfoAudit)
                ->alias("t")
                ->field("t.*,u.nickname,u.mobile as user_mobile,a.username as admin_name,s.title as service_time_type_title,w.title as user_work_type_title")
                ->leftJoin("user u", "u.uid = t.uid")
                ->leftJoin("admin a", "a.id = t.admin_id")
                ->leftJoin("service_time_type s", "s.code = t.service_type")
                ->leftJoin("user_work_type w", "w.id = t.user_work_type_id")
                ->where($where)
                ->page((int)$post["page"], $pageSize)
                ->order("t.id","desc")
                ->select()
                ->toArray();
        }
        $data = empty($data) ? [] : $data;
        $serviceTypeModel = new ServiceTypeModel();
        foreach($data as $k=>$v){
            $data[$k]["birthday"]   = empty($v["birthday"])  ?"":date("Y-m-d",$v["birthday"]);
            $data[$k]["admin_time"] = empty($v["admin_time"])?"":date("Y-m-d H:i:s",$v["admin_time"]);
            $data[$k]["time"]   = date("Y-m-d H:i:s",$v["time"]);
            
            $data[$k]["service_audit_imgs"] = getImageAr($v["service_audit_imgs"]);
            $data[$k]["service_intro_imgs"] = getImageAr($v["service_intro_imgs"]);
            
            //服务区域
            $data[$k]["service_area"] = getImageAr($v["service_area"]);
            $data[$k]["service_area_all"] = [];
            foreach($data[$k]["service_area"] as $k2=>$v2){
                $data[$k]["service_area_all"][]=getAreaItemAr($v2);
            }
            //服务内容
            $data[$k]["service_project"]    = getImageAr($v["service_project"]);
            $data[$k]["service_project_ar"] = [];
            if(!empty($data[$k]["service_project"])){
                $data[$k]["service_project_ar"] = $serviceTypeModel->where("id","in",$data[$k]["service_project"])->select();
            }
        }
        return app('json')->success([
            'list'      => $data,
            'pageCount' => $pageCount,
            'pageSize'  => $pageSize,
            'page'      => $post['page'],
        ]);
    }
    /**
     * 信息认证详情
     * @param Request $request
     */
    public function infoAuditInfo(Request $request){
        $post = UtilService::getMore([
            ['id', '', 'empty', '参数错误'],
        ], $request);
        $data = (new InfoAudit)
                ->alias("i")
                ->field("i.*,u.mobile as user_mobile,u.nickname as user_nickname,u.avatar as user_avatar")
                ->join("user as u","u.uid = i.uid","left")
                ->where("i.id",$post["id"])
                ->find();
        if(empty($data)){
            return app('json')->fail('数据不存在');
        }
        $data = $data->toArray();
        $serviceTypeModel = new ServiceTypeModel();
        $data["birthday"]   = empty($data["birthday"])  ?"":date("Y-m-d",$data["birthday"]);
        $data["admin_time"] = empty($data["admin_time"])?"":date("Y-m-d H:i:s",$data["admin_time"]);
        $data["time"]   = date("Y-m-d H:i:s",$data["time"]);

        $data["service_audit_imgs"] = getImageAr($data["service_audit_imgs"]);
        $data["service_intro_imgs"] = getImageAr($data["service_intro_imgs"]);

        //服务区域
        $data["service_area"] = getImageAr($data["service_area"]);
        $data["service_area_all"] = [];
        foreach($data["service_area"] as $k2=>$v2){
            $data["service_area_all"][]=getAreaItemAr($v2);
        }
        //服务内容
        $data["service_project"]    = getImageAr($data["service_project"]);
        $data["service_project_ar"] = [];
        if(!empty($data["service_project"])){
            $data["service_project_ar"] = $serviceTypeModel->where("id","in",$data["service_project"])->select();
        }
        return app('json')->success($data);
    }
    /**
     * 第一步审核处理
     * @param Request $request
     */
    public function infoAuditSub(Request $request)
    {
        $post   = UtilService::getMore(
            [
                ['id', '', 'empty', '参数错误'],
                ['mono'],
                ['type', 0],
            ], $request);
        $certData = (new InfoAudit)->where('id', $post['id'])->find();
        if (empty($certData)) {
            return app('json')->fail('数据不存在');
        }
        if ($certData['status']!=0) {
            return app('json')->fail( '当前审核已处理');
        }
        //审核通过
        if ($post['type'] == 1) {
            (new InfoAudit)
                ->where('id', $post['id'])
                ->save([
                    'status'            => 1,
                    'admin_mono'        => $post['mono'],
                    'admin_time'        => time(),
                    'admin_id'          => $request->adminInfo['id'],
                ]);
            (new UserModel)->where("uid",$certData["uid"])->update(["work_type_id"=>$certData["user_work_type_id"]]);
            return app('json')->success('操作成功');
        }
        //审核驳回
        if ($post['type'] == -1) {
            (new InfoAudit)
                ->where('id', $post['id'])
                ->save([
                    'status'     => -1,
                    'admin_mono' => $post['mono'],
                    'admin_time' => time(),
                    'admin_id'   => $request->adminInfo['id'],
                ]);
            return app('json')->success('已驳回');
        }
    }
    
    /**
     * 平台认证初始化
     * @return type
     */
    public function typeAuditInit()
    {
        return app('json')->success([
            'all'  => (new TypeAudit)->count(),
            'wait' => (new TypeAudit)->where('status', 0)->count(),
            'ok'   => (new TypeAudit)->where('status', 1)->count(),
            'no'   => (new TypeAudit)->where('status', -1)->count(),
        ]);
    }
    
    /**
     * 平台认证详情
     * @param Request $request
     */
    public function typeAuditInfo(Request $request){
        
    }

    /**
     * 获取平台认证审核列表
     * @param Request $request
     */
    public function typeAuditList(Request $request)
    {
        $pageSize = 50;
        $post     = UtilService::getMore(
            [
                ['page', 1],
                ['keyword',''],
                ['status', ''],
                ['user_mobile',''],
                ['uid', ''],
                ['time',[]],
            ], $request
        );
        $where    = [];
        if(is_numeric($post['status'])) {
            $where[]=["t.status","=",(int)$post['status']];
        }
        if(is_numeric($post['uid']) && $post['uid']>0) {
            $where[]=["t.uid","=",(int)$post['uid']];
        }else if(is_mobile($post['user_mobile'])){
            $udata = (new UserModel)->where("mobile",$post['user_mobile'])->find();
            if(!empty($udata)){
                $where[]=["t.uid","=",(int)$udata['uid']];
            }
        }
        $startTime = "";
        $endTime = "";
        if(!empty($post['time'][0]) && !empty($post['time'][1])) {
           $startTime =  strtotime($post['time'][0]);
           $endTime = strtotime($post['time'][1]);
           $where[]=["t.time","between","{$startTime},{$endTime}"];
        }
        if(!empty($post['keyword'])){
            $where[]=["t.name","=",$post['keyword']];
        }
        $pageCount = (new TypeAudit)->alias("t")->where($where)->count();
        $data = null;
        if($pageCount>0){
            $data = (new TypeAudit)
                ->alias("t")
                ->field("t.*,u.nickname,a.username as admin_name")
                ->leftJoin("user u", "u.uid = t.uid")
                ->leftJoin("admin a", "a.id = t.admin_id")
                ->where($where)
                ->page((int)$post["page"], $pageSize)
                ->order("t.id","desc")
                ->select()
                ->toArray();
        }
        $data = empty($data) ? [] : $data;
        $serviceTypeModel = new ServiceTypeModel();
        foreach($data as $k=>$v){
            $data[$k]["admin_time"] = empty($v["admin_time"])?"":date("Y-m-d H:i:s",$v["admin_time"]);
            $data[$k]["time"]   = date("Y-m-d H:i:s",$v["time"]);
            $data[$k]["service_audit_imgs"] = getImageAr($v["service_audit_imgs"]);
        }
        return app('json')->success([
            'list'      => $data,
            'pageCount' => $pageCount,
            'pageSize'  => $pageSize,
            'page'      => $post['page'],
        ]);
    }
    /**
     * 第一步审核处理
     * @param Request $request
     */
    public function typeAuditSub(Request $request)
    {
        $post   = UtilService::getMore(
            [
                ['id', '', 'empty', '参数错误'],
                ['mono'],
                ['type', 0],
            ], $request);
        $certData = (new TypeAudit)->where('id', $post['id'])->find();
        if (empty($certData)) {
            return app('json')->fail('数据不存在');
        }
        if ($certData['status']!=0) {
            return app('json')->fail( '当前审核已处理');
        }
        //审核通过
        if ($post['type'] == 1) {
            (new TypeAudit)
                ->where('id', $post['id'])
                ->save([
                    'status'     => 1,
                    'admin_mono' => $post['mono'],
                    'admin_time' => time(),
                    'admin_id'   => $request->adminInfo['id'],
                ]);
            return app('json')->success('操作成功');
        }
        //审核驳回
        if ($post['type'] == -1) {
            (new TypeAudit)
                ->where('id', $post['id'])
                ->save([
                    'status'     => -1,
                    'admin_mono' => $post['mono'],
                    'admin_time' => time(),
                    'admin_id'   => $request->adminInfo['id'],
                ]);
            return app('json')->success('已驳回');
        }
    }
    
    
}