Jump to content

Pear DB_DataObject Help


CreedFeed

Recommended Posts

I have the following query:

 

SELECT
stores.id,
stores.name,
SUM(orders.total),
SUM(orders.cost),
COUNT(orders.id)
FROM
stores
LEFT JOIN
orders ON stores.id = orders.store_id
AND
orders.date_ordered > 'xxxx-xx-xx xx:xx:xx'
GROUP BY
stores.id

 

How would I create that same query using DB_DataObjects? I have the following:

 

$orders = new Orders ();

$stores = new Base_stores ();
$stores->selectAdd ();
$stores->selectAdd (' stores.id, stores.name, SUM(orders.total) as total, SUM(orders.order_cost) as cost, COUNT(orders.id) as num_orders ');
$stores->joinAdd ($orders, 'LEFT');
$stores->groupBy ('base_stores.id');

 

which gives the following query:

 

SELECT
stores.id,
stores.name, 
SUM(orders.total) as total, 
SUM(orders.order_cost) as cost, 
COUNT(orders.id) as num_orders 
FROM
base_stores
LEFT JOIN
orders ON (orders.base_store_id=base_stores.id)
GROUP BY
base_stores.id 

 

How do I add on the orders.date_ordered > 'xxxx-xx-xx xx:xx:xx' to the query using DB_DataObject syntax???

 

Thanks!

Link to comment
https://forums.phpfreaks.com/topic/76219-pear-db_dataobject-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.