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\equity\EquityConfig;
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();
    }

    /**
     * @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()
    {
        return Labels::where('id','>',0)->where('label_type',2)->field('id,label_name as name,id as value,"data_table_masterWorkerLabels" as type_value')->select()->toArray();
    }
    /**
     * @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 = getPostageRegion();
            $data = linear_to_tree($lists, 'children', 'id', 'pid');
            cache('labelPostageRegion',$data);
        }
        return $data;
    }
}