auti_boofly_mush_api/app/models/system/SystemGroupDataMerchant.php

<?php
/**
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/11/13
 */

namespace app\models\system;

use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use app\models\system\SystemGroup as GroupModel;

/**
 * 数据列表 model
 * Class SystemGroupData
 * @package app\models\system
 */
class SystemGroupDataMerchant extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'system_group_data_merchant';

    use ModelTrait;

    public static function merSet($mer_id)
    {
        return $mer_id ? self::where('mer_id', $mer_id) : new self;
    }

    /**
     * 根据where条件获取当前表中的前20条数据
     * @param $params
     * @return array
     */
    public static function getList($params, $mer_id = '')
    {
        $model = self::merSet($mer_id);
        if ($params['gid'] !== '') $model = $model->where('gid', $params['gid']);
        if ($params['status'] !== '') $model = $model->where('status', $params['status']);
        $count = $model->count();
        $model = $model->order('sort desc,id ASC');
        $list = $model->page((int)$params['page'], (int)$params['limit'])
            ->select()
            ->each(function ($item) {
                $info = json_decode($item->value, true);
                foreach ($info as $index => $value) {
                    if ($value["type"] == "checkbox") $info[$index]["value"] = implode(",", $value["value"]);
//                if($value["type"] == "upload" || $value["type"] == "uploads"){
//                    $html_img = '';
//                    if(is_array($value["value"])){
//                        foreach ($value["value"] as $img) {
//                            $html_img .= '<img class="image" data-image="'.$img.'" width="45" height="45" src="'.$img.'" /><br>';
//                        }
//                    }else{
//                        $html_img = '<img class="image" data-image="'.$value["value"].'" width="45" height="45" src="'.$value["value"].'" />';
//                    }
//                    $info[$index]["value"] = $html_img;
//                }
                }
                $item['value'] = $info;
            });
        foreach ($list as $key => $value) {
            foreach ($value['value'] as $k => $v) {
                $list[$key][$k] = $v['value'];
            }
            unset($list[$key]['value']);
        }
        $type = '';
        $Fields = GroupModel::getField($params['gid'])['fields'];
        foreach ($Fields as $item) {
            if ($item['type'] === 'upload') {
                $type = $item['title'];
            }
        }
        return compact('count', 'list', 'type');
    }

    /**
     * 获得组合数据信息+组合数据列表
     * @param $config_name
     * @param int $limit
     * @return array|bool|null|\think\Model
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getGroupData($config_name, $limit = 0, $mer_id = '')
    {
        $group = SystemGroup::where('config_name', $config_name)->field('name,info,config_name')->find();
        if (!$group) return false;
        $group['data'] = self::getAllValue($config_name, $limit, $mer_id);
        return $group;
    }

    /**
     * 获取单个值
     * @param $config_name
     * @param int $limit
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getAllValue($config_name, $limit = 0, $mer_id = '')
    {
        $model = self::merSet($mer_id)->alias('a')->field('a.*,b.config_name')->join('system_group b', 'a.gid = b.id')
            ->where("b.config_name", $config_name)->where("a.status", 1)
            ->order('sort desc,id ASC');
        if ($limit > 0) $model->limit($limit);
        $data = [];
        $result = $model->select();
        if (!$result) return $data;
        foreach ($result as $key => $value) {
            $data[$key]["id"] = $value["id"];
            $fields = json_decode($value["value"], true);
            foreach ($fields as $index => $field) {
//                $data[$key][$index] = $field['type'] == 'upload' ? (isset($field["value"][0]) ? $field["value"][0]: ''):$field["value"];
                $data[$key][$index] = $field["value"];
            }
        }
        return $data;
    }

    /**
     * 根据id获取当前记录中的数据
     * @param $id
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getDateValue($id)
    {
        $value = self::alias('a')->where(array("id" => $id))->find();
        $data["id"] = $value["id"];
        $fields = json_decode($value["value"], true);
        foreach ($fields as $index => $field) {
            $data[$index] = $field["value"];
        }
        return $data;
    }
}