ball/app/common/logic/TableDataLogic.php

<?php
// +----------------------------------------------------------------------
// | likeadmin快速开发前后端分离管理后台（PHP版）
// +----------------------------------------------------------------------
// | 欢迎阅读学习系统程序代码，建议反馈是我们前进的动力
// | 开源版本可自由商用，可去除界面版权logo
// | gitee下载：https://gitee.com/likeshop_gitee/likeadmin
// | github下载：https://github.com/likeshop-github/likeadmin
// | 访问官网：https://www.likeadmin.cn
// | likeadmin团队 版权所有 拥有最终解释权
// +----------------------------------------------------------------------
// | author: likeadminTeam
// +----------------------------------------------------------------------


namespace app\common\logic;


use app\common\enum\PayEnum;
use app\common\enum\RefundEnum;
use app\common\model\auth\Admin;
use app\common\model\equity\EquityConfig;
use app\common\model\jobs_rules\JobsRules;
use app\common\model\labels\Labels;
use app\common\model\property\PropertyHead;
use app\common\model\recharge\RechargeOrder;
use app\common\model\refund\RefundLog;
use app\common\model\refund\RefundRecord;
use app\common\model\sale\Sale;
use app\common\model\sale\SaleGroup;
use app\common\model\setting\PostageRegion;
use app\common\service\pay\AliPayService;
use app\common\service\pay\WeChatPayService;


/**
 * 查询选项类数据
 * Class TableDataLogic
 * @package app\common\logic
 */
class TableDataLogic extends BaseLogic
{


    /**
     * @notes 商品标签列表
     */
    public static function labels()
    {
        return Labels::where('id','>',0)->where('label_type',1)->field('id,label_name as name,id as value,"data_table_labels" as type_value')->select()->toArray();
    }
    public static function allLabels()
    {
        return Labels::where('id','>',0)->field('id,label_name as name,id as value,"data_table_allLabels" as type_value')->select()->toArray();
    }

    /**
     * @notes 销售列表
     */
    public static function sale()
    {
        return Sale::where('id','>',0)->field('id,sale_name as name,id as value,"data_table_sale" as type_value')->select()->toArray();
    }
    /**
     * @notes 销售组列表
     */
    public static function saleGroup()
    {
        return SaleGroup::where('id','>',0)->field('id,sale_name as name,id as value,"data_table_saleGroup" as type_value')->select()->toArray();
    }

    public static function propertyHead()
    {
        return PropertyHead::where('id','>',0)->field('id,village_name as name,id as value,"data_table_propertyHead" as type_value')->select()->toArray();
    }
    /**
     * @notes 工程师标签列表
     */
    public static function masterWorkerLabels()
    {
        $lists = Labels::where('id','>',0)->where('label_type',2)->field('id,pid,label_name as name,id as value,"data_table_masterWorkerLabels" as type_value')->select()->toArray();
        return linear_to_tree($lists, 'children', 'id', 'pid');
    }
    /**
     * @notes 优惠券标签列表
     */
    public static function couponLabels()
    {
        return Labels::where('id','>',0)->where('label_type',3)->field('id,label_name as name,id as value,"data_table_couponLabels" as type_value')->select()->toArray();
    }

    /**
     * @notes 权益卡列表
     */
    public static function equityConfig()
    {
        return EquityConfig::where('id','>',0)->field('id,equity_name as name,id as value,"data_table_equityConfig" as type_value')->select()->toArray();
    }

    public static function postageRegion(): array
    {
        // 缓存优化
        $data = cache('labelPostageRegion');
        if(empty($data)){
            $lists = PostageRegion::field(['id', 'pid', 'name as label','id as value','"data_table_postageRegion" as type_value'])->select()->toArray();
            $data = linear_to_tree($lists, 'children', 'id', 'pid');
            cache('labelPostageRegion',$data);
        }
        return $data;
    }

    public static function jobsRules(): array
    {
        return JobsRules::field(['id', 'rule_name as label','id as value','"data_table_jobsRules" as type_value'])->select()->toArray();
    }

    public static function provinces()
    {
        return PostageRegion::where('pid','=',0)->field('id,merge_name as name,id as value,"data_table_provinces" as type_value')->select()->toArray();
    }
    public static function citys($province_ids = [])
    {
        if(!empty($province_ids)){
            return PostageRegion::where('pid','in',$province_ids)->where('level','=',2)->field('id,merge_name as name,id as value,"data_table_citys" as type_value')->select()->toArray();
        }
        return PostageRegion::where('level','=',2)->field('id,merge_name as name,id as value,"data_table_citys" as type_value')->select()->toArray();
    }

    public static function admins()
    {
        return Admin::where('disable','=',0)->field('id,name,id as value,"data_table_admins" as type_value')->select()->toArray();
    }

}