php - 我如何从数据库中检索数据，条件是数据应在 6 个月之前添加，并且产品数量应高于 200

Question

模型查询看起来像

$this->db->select('stock_id,product_name,purchase_date,purchase_quantity,sale_quantity,stock_status');
$this->db->from('stock_details');
$this->db->join('product_details', 'stock_details.product_id_fk = product_details.product_id');
$this->db->join('purchase_details', 'product_details.product_id = purchase_details.product_id_fk');
$this->db->group_by('product_id');
$this->db->order_by('purchase_date','AESC');
$this->db->where('stock_status',1);
$query = $this->db->get();

我只需要获取基于purchase_date的6个月内添加的数据和 purchase_quantity 之间的区别和sale_quantity应该是200

Answer 1

试试这个

AND (PurchaseDate> DATE_SUB(now(), INTERVAL 6 MONTH) AND (purchase_quantity-sale_quantity)>200

DATE_SUB 从您的购买日期减去 6 个月