<?php

/**
 * RetailVipLabelModel
 * @author shao nianyi
 * @create_time 2020年4月27日
 */

namespace Common\Model;

//[1.7.90]

/**
 * 会员与会员标签关联表
 * Class RetailVipWithLabelModel
 * @package Common\Model
 */
class RetailVipWithLabelModel extends BaseModel
{
    protected $tableName = 'retail_vip_with_label';


    /**
     * 获取会员已选标签列表
     * @param $map
     * @param $field
     * @param $page
     * @param $pageSize
     * @return mixed
     */
    public function getUserLabel($map, $field, $page, $pageSize)
    {
        $list = $this->alias('rvwl')
            ->field($field)
            ->join('ls_retail_vip_label as rvl on rvl.id = rvwl.vip_label_id', 'LEFT')
            ->where($map)
            ->page($page, $pageSize)
            ->select();

        $total = $this->alias('rvwl')
            ->field($field)
            ->join('ls_retail_vip_label as rvl on rvl.id = rvwl.vip_label_id', 'LEFT')
            ->where($map)
            ->count();
        $evaluate['list'] = $list;
        $evaluate['total'] = $total;
        return $evaluate;
    }

    /**
     * 获取会员标签名称拼接
     * @param $vid  会员id
     * @param $store_id  门店id
     * @return string
     */
    public function getVipLabelName($vid, $store_id)
    {
        $vip_label = $this->alias('w')
            ->join('ls_retail_vip_label as l on l.id = w.vip_label_id', 'LEFT')
            ->field('l.name as label_name')
            ->where(['w.is_del' => 1, 'l.is_del' => 1, 'l.store_id' => $store_id, 'w.vid' => $vid])
            ->select();
        if ($vip_label) {
            $temp_array = [];
            foreach ($vip_label as $value) {
                $temp_array[] = $value['label_name'];
            }
            return implode(",", $temp_array);
        } else {
            return '';
        }
    }
}