| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151 |
- <?php
- /**
- * Niushop商城系统 - 团队十年电商经验汇集巨献!
- * =========================================================
- * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
- * ----------------------------------------------
- * 官方网址: https://www.niushop.com
- * =========================================================
- */
- namespace addon\jielong\model;
- use app\model\BaseModel;
- /**
- * 购物车
- */
- class Cart extends BaseModel
- {
- /**
- * 添加购物车
- * @param $data
- * @return array
- */
- public function addCart($data)
- {
- $cart_info = model("promotion_jielong_cart")->getInfo([ [ 'sku_id', '=', $data[ 'sku_id' ] ], [ 'member_id', '=', $data[ 'member_id' ] ], [ 'jielong_id', '=', $data[ 'jielong_id' ] ] ], 'cart_id, num');
- if (!empty($cart_info)) {
- $res = model("promotion_jielong_cart")->update([ 'num' => $cart_info[ 'num' ] + $data[ 'num' ] ], [ [ 'cart_id', '=', $cart_info[ 'cart_id' ] ] ]);
- } else {
- $res = model("promotion_jielong_cart")->add($data);
- }
- return $this->success($res);
- }
- /**
- * 获取购物车商品信息
- * @param unknown $data
- */
- public function getCartSkuInfo($condition, $fields, $alias, $join)
- {
- $res_info = model("promotion_jielong_cart")->getInfo($condition, $fields, $alias, $join);
- return $this->success($res_info);
- }
- /**
- * 更新购物车商品数量
- * @param unknown $data
- */
- public function editCart($data)
- {
- $res = model("promotion_jielong_cart")->update([ 'num' => $data[ 'num' ] ], [ [ 'cart_id', '=', $data[ 'cart_id' ] ], [ 'member_id', '=', $data[ 'member_id' ] ] ]);
- return $this->success($res);
- }
- /**
- * 删除购物车商品项(可以多项)
- * @param unknown $data
- */
- public function deleteCart($data)
- {
- $res = model("promotion_jielong_cart")->delete([ [ 'cart_id', 'in', explode(',', $data[ 'cart_id' ]) ], [ 'member_id', '=', $data[ 'member_id' ] ] ]);
- return $this->success($res);
- }
- /**
- * 清空购物车
- * @param unknown $data
- */
- public function clearCart($data)
- {
- $res = model("promotion_jielong_cart")->delete([ [ 'member_id', '=', $data[ 'member_id' ] ], [ 'jielong_id', '=', $data[ 'jielong_id' ] ] ]);
- return $this->success($res);
- }
- /**
- * 获取会员购物车
- * @param unknown $member_id
- * @param unknown $site_id
- */
- public function getCart($member_id, $site_id, $jielong_id)
- {
- $field = 'pjc.cart_id, pjc.site_id, pjc.member_id, pjc.sku_id, pjc.num,pjc.jielong_id, ngs.sku_name,
- ngs.sku_no, ngs.sku_spec_format,ngs.price,ngs.market_price,
- ngs.discount_price, ngs.promotion_type, ngs.start_time, ngs.end_time, ngs.stock,
- ngs.sku_image, ngs.sku_images, ngs.goods_state, ngs.goods_stock_alarm, ngs.is_virtual, ngs.goods_name,
- ngs.virtual_indate, ngs.is_free_shipping, ngs.shipping_template, ngs.unit, ngs.introduction,ngs.sku_spec_format, ngs.keywords, ngs.max_buy, ngs.min_buy, ns.site_name, ngs.is_limit, ngs.limit_type';
- $alias = 'pjc';
- $join = [
- [
- 'goods_sku ngs',
- 'pjc.sku_id = ngs.sku_id',
- 'inner'
- ],
- [
- 'site ns',
- 'pjc.site_id = ns.site_id',
- 'inner'
- ],
- ];
- $list = model("promotion_jielong_cart")->getList([ [ 'pjc.member_id', '=', $member_id ], [ 'pjc.site_id', '=', $site_id ], [ 'ngs.is_delete', '=', 0 ], [ 'pjc.jielong_id', '=', $jielong_id ] ], $field, 'pjc.cart_id desc', $alias, $join);
- return $this->success($list);
- }
- /**
- * 获取购物车数量
- * @param unknown $member_id
- */
- public function getCartCount($member_id, $jielong_id)
- {
- $list = model("promotion_jielong_cart")->getCount([ [ 'member_id', '=', $member_id ], [ 'jielong_id', '=', $jielong_id ] ]);
- return $this->success($list);
- }
- /**
- * 获取购物车商品数量
- * @param $condition
- * @return array
- */
- public function getCartSumCopy($condition, $field, $alias = 'a', $join = null)
- {
- $sum = model("promotion_jielong_cart")->getSum($condition, $field, $alias, $join);
- return $this->success($sum);
- }
- public function getCartSum($condition)
- {
- $sum = model("promotion_jielong_cart")->getCount($condition);
- return $this->success($sum);
- }
- /**
- * 获取购物车商品选择数量
- * @param $condition
- * @return array
- */
- public function getCartList($condition = [], $field = 'cart_id,site_id,member_id,sku_id,num,jielong_id', $order = 'cart_id desc')
- {
- $alias = 'gc';
- $join = [
- [
- 'goods_sku gs',
- 'gc.sku_id = gs.sku_id',
- 'left'
- ]
- ];
- $list = model("promotion_jielong_cart")->getList($condition, $field, $order, $alias, $join);
- return $this->success($list);
- }
- }
|