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); } } }