mirbahar

SELECT COUNT(p0_.id) AS sclr0 FROM purchase_requisitions p0_ WHERE p0_.created_date >= '2015-11-01 00:00:00 00:00:00' AND p0_.created_date <= '2015-11-30 23:59:59 23:59:59'

SELECT COUNT(p0_.id) AS sclr0 FROM purchase_requisitions p0_ WHERE p0_.status = 1 AND p0_.approve_status = 3 AND p0_.total_order_item_quantity = p0_.total_requisition_item_quantity AND p0_.created_date >= '2015-11-01 00:00:00 00:00:00' AND p0_.created_date <= '2015-11-30 23:59:59 23:59:59'

SELECT COUNT(p0_.id) AS sclr0 FROM purchase_requisitions p0_ WHERE p0_.status = 6 AND p0_.created_date >= '2015-11-01 00:00:00 00:00:00' AND p0_.created_date <= '2015-11-30 23:59:59 23:59:59'

SELECT COUNT(p0_.id) AS sclr0 FROM purchase_requisitions p0_ WHERE p0_.status = 1 AND (p0_.approve_status = 0 OR p0_.approve_status = 1 OR p0_.approve_status = 2) AND p0_.created_date >= '2015-11-01 00:00:00 00:00:00' AND p0_.created_date <= '2015-11-30 23:59:59 23:59:59'

SELECT COUNT(p0_.id) AS sclr0 FROM purchase_requisitions p0_ WHERE p0_.approve_status = 3 A