alias('c') ->field('c.*,p.title,p.image,p.price as product_price') ->leftJoin('store_product p', 'p.id = c.product_id') ->where('c.uid', $uid) ->select() ->toArray(); return $list; } /** * 添加购物车 * @param array $data * @return bool */ public function addToCart($data) { // 检查是否已存在 $exist = $this->where('uid', $data['uid']) ->where('product_id', $data['product_id']) ->where('cart_num', $data['cart_num']) ->find(); if ($exist) { // 更新数量 return $this->where('id', $exist['id'])->inc('cart_num', $data['cart_num'])->update(); } else { // 新增 return $this->insert($data); } } /** * 修改购物车数量 * @param int $id * @param int $cartNum * @param int $uid * @return bool */ public function updateCartNum($id, $cartNum, $uid) { return $this->where('id', $id)->where('uid', $uid)->update(['cart_num' => $cartNum]); } /** * 删除购物车 * @param array $ids * @param int $uid * @return bool */ public function deleteCart($ids, $uid) { return $this->where('uid', $uid)->whereIn('id', $ids)->delete(); } }