86 行
2.6 KiB
PHP
可执行文件
86 行
2.6 KiB
PHP
可执行文件
<?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;
|
|
}
|
|
|
|
|
|
} |