fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$nameis = $row['description'];
}
if ($usersecurity>7) {
print "";
}
print "Available $nameis Pricelists Linked to $stkref
";
print "| ID | Document Name | Updated | Expiry Date | Notes |
";
$sql = "SELECT
ISO_quality_manual_files.documentexplain ,
ISO_quality_manual_files.docid,ISO_quality_manual_files.description ,
ISO_quality_manual_files.exp_date ,
ISO_quality_manual_files.addedon ,
ISO_quality_manual_files.hostcompany, ISO_quality_manual_files.pricelistcode
FROM ISO_quality_manual_files , ISO_quality_manual_stock_links WHERE
ISO_quality_manual_files.archived='' and ISO_quality_manual_files.type='PRICE'
AND ISO_quality_manual_files.docid=ISO_quality_manual_stock_links.docid AND
ISO_quality_manual_files.pricelistcode=? AND
ISO_quality_manual_stock_links.stock_ref=?
";
$stmt = pdoquery($sql, array($pricelist, $stkref));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$docid = $row['docid'];
$hostcompanyid = $row['hostcompany'];
$pricelistcode = $row['pricelistcode'];
$pricelistpdflink = $hostcompanyid . "Z" . $pricelistcode;
$haspricelist[$pricelistpdflink] = 1;
if ($row['exp_date'] > 0) {
$expdate = date("d M Y", $row['exp_date']);
} else {
$expdate = "Not Set";
}
if ($row['exp_date'] < $nowis && $row['exp_date'] > 0) {
$expdate = "$expdate";
}
if ($row['addedon'] > 0) {
$addedon = date("d M Y", $row['addedon']);
} else {
$addedon = "Not Set";
}
print "| $docid | " . linkdocid($x, $docid) . $row['description'] . " | $addedon | $expdate | " . $row['documentexplain'] . " |
";
}
print "
";
?>