function GetPartInfo(&$db,$part) {
// Get last purchase order date and supplier for part, and also preferred supplier
// Printed when there is a part break
$sql = "SELECT orddate as maxdate,
purchorders.orderno
FROM purchorders INNER JOIN purchorderdetails
ON purchorders.orderno = purchorderdetails.orderno
WHERE purchorderdetails.itemcode = '" . $part ."'
ORDER BY orddate DESC LIMIT 1";
$result = DB_query($sql);
if (DB_num_rows($result)>0) {
$myrow = DB_fetch_array($result,$db);
$PartInfo[] = ConvertSQLDate($myrow['maxdate']);
$OrderNo= $myrow['orderno'];
$sql = "SELECT supplierno
FROM purchorders
WHERE purchorders.orderno = '" .$OrderNo. "'";
$result = DB_query($sql);
$myrow = DB_fetch_array($result,$db);
$PartInfo[] = $myrow['supplierno'];
} else {
$PartInfo[] = '';
$PartInfo[] = '';
}
$sql = "SELECT supplierno, conversionfactor
FROM purchdata
WHERE stockid = '" . $part . "'
AND preferred='1'";
$result = DB_query($sql);
if (DB_num_rows($result)>0) {
$myrow = DB_fetch_array($result,$db);
$PartInfo[] = $myrow['supplierno'];
$PartInfo[] = $myrow['conversionfactor'];
} else {
$PartInfo[] = '';
$PartInfo[] = '';
}
return $PartInfo;
}