1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 |
- <?php
- namespace app\common\model\qc;
- use app\api\model\member\MemberGoods;
- use app\common\model\BaseModel;
- use app\common\model\Goods;
- /**
- * 全场满件赠活动模型
- * @package app\store\model\qc
- */
- class QcMjSendGiftGoods extends BaseModel
- {
- protected $name = 'qc_mj_send_gift_goods';
- // 定义主键
- protected $pk = 'id';
- protected $append = ['goods_info'];
- public function getGoodsInfoAttr($value,$data){
- $res = Goods::alias('gd')
- ->leftJoin('goods_image gi','gd.goods_id=gi.goods_id')
- ->leftJoin('goods_sku gs','gd.goods_id=gs.goods_id')
- ->leftJoin('upload_file uf','gi.image_id=uf.file_id')
- ->where('gd.goods_id',$data['goods_id'])
- ->field('gd.goods_name,gd.goods_no,gd.goods_price_min,gd.line_price_min,gd.status,(gd.sales_initial+gd.sales_actual+gd.sales_shops) as goods_sales,gi.image_id,gd.stock_total,uf.domain,uf.file_path,gs.goods_props')->find();
- $res->goods_props_obj = $res->goods_props?json_decode($res->goods_props):null;
- $res->goods_image = $res->domain.'/'.$res->file_path;
- $res->member_price = (new MemberGoods)->getGoodsMemberPrice($res->goods_id,$res->goods_price_min);
- return $res;
- }
- public function add($activity_id,$data)
- {
- if (!empty($data)) {
- $insert = [];
- foreach ($data as $item) {
- // 判断是否存在
- $info = $this->where('qc_mj_send_activity_id', $activity_id)->where('goods_id', $item['goods_id'])->find();
- if (!empty($info)) { // 编辑
- $info->save([
- 'qc_mj_send_activity_id'=>$activity_id,
- 'goods_id' => $item['goods_id'],
- ]);
- } else { // 新增
- $insert[] = [
- 'qc_mj_send_activity_id'=>$activity_id,
- 'goods_id' => $item['goods_id'],
- ];
- }
- // 更新商品库存(只支持单规格)
- // (new QcMjSendGoods())->changeGoodsStocks($item['goods_id'], $act_stock);
- }
- $this->insertAll($insert);
- }
- }
- }
|