Need Help on Sorting Arrays..
| From: | Gezeala 'Eyah' Bacu�o II | Date: | Mon, 19 May 2003 09:22:46 +0000 |
| Subject: | Need Help on Sorting Arrays.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27875@lists.php.net to get a copy of this message | ||
Hi!
I'm not using MySql I'm using Postgresql..
Here is my query..Can't combine them...I have to compute for the sum of the $poqty and $soqty..
// for so_qty
$sql="SELECT
CASE
WHEN MAX(a.part_alternate_id) isNull THEN
t.part_id
ELSE (
SELECT part_alternate_child_id
FROM part_alternate q
WHERE q.part_alternate_id=(
SELECT MAX(b.part_alternate_id)
FROM part_alternate b
WHERE b.part_alternate_parent_id=t.part_id))
END AS part_id,
SUM(t.quantity) AS sodqty,
t.part_id AS parent_id
FROM temp_so_parts_sum t
LEFT JOIN part_alternate a ON t.part_id=a.part_alternate_parent_id
LEFT JOIN part p ON t.part_id=p.part_id
WHERE userid=$users_id and part_model_id=$model_id
GROUP BY t.part_id";
$rs=$conn->execute($sql);
$result->set_resultset($rs);
while(!$result->EOF()) {
$temp=$result->get_row($rs);
$soqty[$temp["part_id"]]=$temp["sodqty"];
$result->move_next();
}
$result=new pg_resultset;
//for poqty
$sql="SELECT pod_part_supp_id,part_id ,(SUM(pod_qty) * part_divisor) AS podqty
FROM vw_purchase_order_detail
WHERE po_lot_id IN (
SELECT lot_id
FROM lot
WHERE lot_model_id=$model_id AND lot_id
BETWEEN $from_lot_id AND $to_lot_id
)
AND po_model_id=$model_id
GROUP BY pod_part_supp_id,part_id,part_divisor ";
$rs=$conn->execute($sql);
$result->set_resultset($rs);
while(!$result->EOF()) {
$temp=$result->get_row($rs);
$poqty[$temp["part_id"]]=$temp["podqty"];
$result->move_next();
}
// got all the part_id's from this table/view..
$sql2="SELECT * FROM vw_part_supplier
LEFT JOIN model ON part_model_id=model_id
WHERE part_model_id=$model_id ORDER BY supplier_code, part_name, part_longcode";
$result=new pg_resultset;
$rs=$conn->execute($sql2);
$result->set_resultset($rs);
while(!$result->EOF()) {
$temp=$result->get_row($rs);
$supplier[$temp["part_id"]]=trim($temp["supplier_code"]);
$part_id[$temp["part_id"]]=$temp["part_id"];
$name[$temp["part_id"]]=trim($temp["part_name"]);
$code[$temp["part_id"]]=trim($temp["part_longcode"]);
$short[$temp["part_id"]]=trim($temp["part_shortcode"]);
$model[$temp["part_id"]]=$temp["model_id"];
$model_code[$temp["part_id"]]=trim($temp["model_code"]);
$model_desc[$temp["part_id"]]=trim($temp["model_desc"]);
$moq[$temp["part_id"]]=$temp["part_supp_min_qty"];
$result->move_next();
}
TIA!
Marie Gezeala M. Bacuño II
Information Systems Department
Your choice: the red pill or the blue pill.
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail