weibao/application/api/controller/Demo.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\library\Tenim;
use think\Db;
/**
 * 示例接口
 */
class Demo extends Api
{

    //如果$noNeedLogin为空表示所有接口都需要登录才能请求
    //如果$noNeedRight为空表示所有接口都需要验证权限才能请求
    //如果接口已经设置无需登录,那也就无需鉴权了
    //
    // 无需登录的接口,*表示全部
    protected $noNeedLogin = ['test', 'test1','im_reg_all'];
    // 无需鉴权的接口,*表示全部
    protected $noNeedRight = ['test2'];

    /**
     * 注册所有账号到腾讯im
     * user_用户端小程序，master_师傅，kefu_客服
     */
    public function im_reg_all()
    {
        $list = Db::name('user')->select();

        $tenim = new Tenim();
        foreach($list as $key => $val){
            $rs = $tenim->register('user_'. $val['id'], $val['nickname'], localpath_to_netpath($val['avatar']));
            dump($rs);
        }

        //
        $list = Db::name('worker')->select();

        $tenim = new Tenim();
        foreach($list as $key => $val){
            $rs = $tenim->register('master_'. $val['id'], $val['truename'], localpath_to_netpath($val['avatar']));
            dump($rs);
        }

        //
        $list = Db::name('company')->select();

        $tenim = new Tenim();
        foreach($list as $key => $val){
            $rs = $tenim->register('kefu_'. $val['id'], $val['companyname'], localpath_to_netpath($val['avatar']));
            dump($rs);
        }
    }

    /**
     * 测试方法
     *
     * @ApiTitle    (测试名称)
     * @ApiSummary  (测试描述信息)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/demo/test/id/{id}/name/{name})
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="id", type="integer", required=true, description="会员ID")
     * @ApiParams   (name="name", type="string", required=true, description="用户名")
     * @ApiParams   (name="data", type="object", sample="{'user_id':'int','user_name':'string','profile':{'email':'string','age':'integer'}}", description="扩展数据")
     * @ApiReturnParams   (name="code", type="integer", required=true, sample="0")
     * @ApiReturnParams   (name="msg", type="string", required=true, sample="返回成功")
     * @ApiReturnParams   (name="data", type="object", sample="{'user_id':'int','user_name':'string','profile':{'email':'string','age':'integer'}}", description="扩展数据返回")
     * @ApiReturn   ({
         'code':'1',
         'msg':'返回成功'
        })
     */
    public function test()
    {
        $data = [
            [
                'type' => 'video',
                'url'  => '/upload/20240712/aaaaa.mp4',
            ],
            [
                'type' => 'img',
                'url'  => '/upload/20240712/bbbbb.jpg',
            ],
            [
                'type' => 'video',
                'url'  => '/upload/20240712/ccccc.mp4',
            ],
            [
                'type' => 'img',
                'url'  => '/upload/20240712/ddddd.png',
            ],
        ];

        echo json_encode($data);
    }

    /**
     * 无需登录的接口
     *
     */
    public function test1()
    {
        $rule = '246,230,240,259,260,317,253,261,262,263,100,265,102,103,104,120,267,269,270,110,266,113,114,289,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,271,272,274,290,280,281,282,283,284,286,273,278,279,275,276,277,291,292,293';
        $rule = explode(',',$rule);
        dump($rule);

        $b = array_count_values($rule);
        dump($b);
    }

    /**
     * 需要登录的接口
     *
     */
    public function test2()
    {
        $this->success('返回成功', ['action' => 'test2']);
    }

    /**
     * 需要登录且需要验证有相应组的权限
     *
     */
    public function test3()
    {
        $this->success('返回成功', ['action' => 'test3']);
    }

    public function delete_company(){

        $company_id = 0;

        $where_c = [
            'company_id' => $company_id
        ];

        Db::startTrans();

        //单一
        Db::name('banner')->where($where_c)->delete();
        Db::name('caozuoguifan')->where($where_c)->delete();
        Db::name('caozuoguifan_type')->where($where_c)->delete();
        Db::name('company_token')->where('user_id',$company_id)->delete();
        Db::name('dongtai')->where($where_c)->delete();


        //检测
        $project_ids = Db::name('jiance_project')->where($where_c)->column('id');
        $jiance_ids  = Db::name('jiance')->where($where_c)->column('id');
        Db::name('jiance_joblog')->where('jiance_id','IN',$jiance_ids)->delete();
        Db::name('jiance_joblog')->where('project_id','IN',$project_ids)->delete();
        Db::name('jiance_project')->where($where_c)->delete();
        Db::name('jiance')->where($where_c)->delete();

        //单一
        Db::name('jishuguifan')->where($where_c)->delete();

        //维修单
        Db::name('maintain')->where($where_c)->delete();
        Db::name('maintain_baojia')->where($where_c)->delete();
        Db::name('maintain_cailiao')->where($where_c)->delete();
        Db::name('maintain_jindu')->where($where_c)->delete();
        Db::name('maintain_weixiu')->where($where_c)->delete();

        //单一
        Db::name('message_sys')->where($where_c)->delete();
        Db::name('news')->where($where_c)->delete();
        Db::name('news_type')->where($where_c)->delete();
        Db::name('password')->where($where_c)->delete();

        //pc权限
        Db::name('pc_admin')->where($where_c)->delete();
        Db::name('pc_admin_log')->where($where_c)->delete();
        Db::name('pc_auth_group')->where($where_c)->delete();
        Db::name('password')->where($where_c)->delete();
        Db::name('password')->where($where_c)->delete();
        Db::name('password')->where($where_c)->delete();


        //师傅
        $worker_ids = Db::name('worker')->where($where_c)->column('id');

        //
        Db::name('company')->where('id',$company_id)->delete();

        Db::rollback();
    }

}