application/modelsOrdergoods_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Ordergoods_model extends CI_Model
{
	private $table = 'ordergoods';
	public function __construct()
	{
		parent::__construct();
	}

	/**
	 * 获取订单下的所有商品
	 * @param int $orderId
	 */
	public function getGoodsById($orderId = 0)
	{
		$orderId = intval($orderId);
		if(!empty($orderId))
		{
			$this->db->where('orderId',$orderId);
		}
		$res = $this->db->get($this->table)->result_array();

		return $res;
	}

	/**
	 * 拿去商品数
	 * */
	public function orderGoodsCount($orderId = 0)
	{
	    $this->db->select('COUNT(*) as num');
	    $this->db->where('orderId',$orderId);
	    $res = $this->db->get($this->table)->row_array();
	    return !empty($res['num']) ? $res['num'] : 0;
	}

	/**
	 * 添加订单商品
	 * @param $data array
	 * */
	public function addOrderGoods($data)
	{
	    $bool = $this->db->insert($this->table, $data);
	    return $bool;
	}

	/**
	 * 拿去订单某个商品
	 * @param $goodsId int 商品id
	 * @param $goodsSku str 商品sku
	 * @param $orderId int 订单id
	 * @param $spec str 商品规格
	 * @return array
	 * */
	public function orderGoods($goodsId=0, $goodsSku='', $orderId=0, $spec='')
	{
	    if(!empty($goodsId))
	    {
	        $this->db->where('goodsId', $goodsId);
	    }

	    if(!empty($goodsSku))
	    {
	        $this->db->where('goodsSku', $goodsSku);
	    }

	    if(!empty($orderId))
	    {
	        $this->db->where('orderId', $orderId);
	    }

	    if(!empty($spec))
	    {
	        $this->db->where('spec', $spec);
	    }
	    $res = $this->db->get($this->table)->row_array();
	    return $res;
	}
}