<?php

/**
 * 商品满赠
 * @author nianyi
 * @create_time 2020年05月22日
 */

namespace Common\Model;

use Common\Model\SkuGoodsViewModel;
use Common\Model\RetailGoodsModel;
use Think\Model\ViewModel;

//[1.4.98]
class RetailGoodsGiftsModel extends BaseModel
{
    protected $tableName = 'retail_goods_gifts';

    // 获取赠品库列表--收音机
    public function getGoodsGiftsListByCashier($where, $field, $page = 1, $pageSize = 10)
    {
        $list = $this->alias('rgg')
            ->join('ls_retail_store_sale_goods as rssg on rssg.id = rgg.sale_goods_id', 'LEFT')
            ->join('ls_retail_goods as rg on rg.id = rgg.goods_id', 'LEFT')
            ->field($field)
            ->where($where)
            ->order('rgg.id desc')
            ->page($page, $pageSize)
            ->select();

        $result['list'] = $list;
        return $result;
    }

    // 获取规格产品的零售价
    public function getRetailPriceBySku($goods_id, $sku_id = 0)
    {
        if($sku_id){
            $RetailSkuGoods = new SkuGoodsViewModel();
            $where['goods_id'] = $goods_id;
            $where['state'] = ['NEQ', 1];
            $where['_string'] = 'FIND_IN_SET('."'$sku_id'".', sku_id_list)';
            $data = $RetailSkuGoods->getFind($where, 'retail_price');
            if($data){
                return $data['retail_price'];
            } else {
                return 0;
            }
        } else {
            $RetailGoodsModel = new RetailGoodsModel();
            $retail_price = $RetailGoodsModel->getFind(['id' => $goods_id ], 'retail_price');
            if($retail_price){
                return $retail_price['retail_price'];
            } else {
                return 0;
            }
        }
    }

    /* ********************************  后台START   ******************************** */
    // 获取赠品库列表
    public function getGoodsGiftsList($where, $field, $page = 1, $pageSize = 10)
    {
        $list = $this->alias('rgg')
            ->join('ls_retail_store_sale_goods as rssg on rssg.id = rgg.sale_goods_id', 'LEFT')
            ->join('ls_retail_goods as rg on rg.id = rgg.goods_id', 'LEFT')
            ->field($field)
            ->where($where)
            ->order('rgg.id desc')
            ->page($page, $pageSize)
            ->select();

        $total = $this->alias('rgg')
            ->join('ls_retail_store_sale_goods as rssg on rssg.id = rgg.sale_goods_id', 'LEFT')
            ->join('ls_retail_goods as rg on rg.id = rgg.goods_id', 'LEFT')
            ->where($where)
            ->count();

        $result['list'] = $list;
        $result['total'] = $total;
        return $result;
    }


}