<?php

namespace app\admin\lists\merchant;


use app\admin\lists\BaseAdminDataLists;
use app\common\model\merchant\Merchant;
use app\common\lists\ListsSearchInterface;
use think\facade\Db;


/**
 * 商户列表列表
 * Class MerchantLists
 * @package app\admin\listsmerchant
 */
class MerchantLists extends BaseAdminDataLists implements ListsSearchInterface
{


    /**
     * @notes 设置搜索条件
     * @return \string[][]
     * @author likeadmin
     * @date 2024/04/23 16:35
     */
    public function setSearch(): array
    {
        return [
            '=' => ['category_id', 'type_id'],
	        '%like%' => ['mer_name']
        ];
    }


    /**
     * @notes 获取商户列表列表
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @author likeadmin
     * @date 2024/04/23 16:35
     */
    public function lists(): array
    {
        return Merchant::where($this->searchWhere)->where('status',1)->withoutField(['update_time','delete_time'])
            ->limit($this->limitOffset, $this->limitLength)
            ->order(['mer_id' => 'desc'])
            ->select()->each(function($data){
				$province = Db::name('geo_province')->field('province_name')->where('province_code',$data['province_id'])->findOrEmpty();
				$city = Db::name('geo_city')->field('city_name')->where('city_code',$data['city_id'])->findOrEmpty();
				$area = Db::name('geo_area')->field('area_name')->where('area_code',$data['area_id'])->findOrEmpty();
				$street = Db::name('geo_street')->field('street_name')->where('street_code',$data['street_id'])->findOrEmpty();
				$village = Db::name('geo_village')->field('village_name')->where('village_code',$data['village_id'])->findOrEmpty();
				$data['province_name'] = !empty($province) ? $province['province_name'] : '';
				$data['city_name'] = !empty($city) ? $city['city_name'] : '';
				$data['area_name'] = !empty($area) ? $area['area_name'] : '';
				$data['street_name'] = !empty($street) ? $street['street_name'] : '';
				$data['village_name'] = !empty($village) ? $village['village_name'] : '';
	        })
            ->toArray();
    }


    /**
     * @notes 获取商户列表数量
     * @return int
     * @author likeadmin
     * @date 2024/04/23 16:35
     */
    public function count(): int
    {
        return Merchant::where($this->searchWhere)->count();
    }

}