| Name | Vorhanden | Min.Bestand | Footprint | Lagerort | Datenblätter | ";
/* the only difference is the query */
if (strcmp ($_REQUEST["type"], "index") == 0)
$query = "SELECT parts.id,parts.name,parts.instock,parts.mininstock,footprints.name AS 'footprint',storeloc.name AS 'loc' FROM parts LEFT JOIN footprints ON parts.id_footprint=footprints.id LEFT JOIN storeloc ON parts.id_storeloc=storeloc.id WHERE (". $catclause .") ORDER BY name ASC;";
else
$query = "SELECT parts.id,parts.name,parts.instock,parts.mininstock,footprints.name AS 'footprint',storeloc.name AS 'loc' FROM parts LEFT JOIN footprints ON parts.id_footprint=footprints.id LEFT JOIN storeloc ON parts.id_storeloc=storeloc.id LEFT JOIN preise ON parts.id=preise.part_id WHERE (". $catclause .") AND (preise.id IS NULL) ORDER BY name ASC;";
debug_print ($query);
$result = mysql_query ($query);
$rowcount = 0;
while ( $d = mysql_fetch_row ($result) )
{
$rowcount++;
if ( ($rowcount % 2) == 0 )
print "";
else
print " ";
if (has_image($d[0]))
{
print "![\"".](\"getimage.php?pid=".) | ";
}
else
{
//Footprintbilder
if(is_file("tools/footprints/" . smart_unescape($d[4]) . ".png"))
{
print "![](\"tools/footprints/".) | ";
}
else
{
print "![](\"img/partdb/dummytn.png\") | ";
}
}
print "". smart_unescape($d[1]) ." | ". smart_unescape($d[2]) ." | ". smart_unescape($d[3]) ." | ". smart_unescape($d[4]) ." | ". smart_unescape($d[5]) . " | ";
print "";
$test = ($d[1]) ;
$query = "SELECT datasheeturl FROM datasheets WHERE part_id=". smart_escape($d[0]) ." ORDER BY datasheeturl ASC;";
$result_ds = mysql_query($query);
$d = mysql_fetch_row ($result_ds); #)
if($d[0] == NULL)
{
print "AllDataSheet, ";
print "Reichelt";
}
else
{
print "Datenblatt ";
}
print " | ";
print " \n";
}
}
else if ( strcmp ($_REQUEST["type"], "showpending") == 0 )
{
print " | Name | Ausstehend | Vorhanden | Min. Bestand | Footprint | Lagerort | Datenblätter | ";
$query = "SELECT parts.id,parts.name,SUM(pending_orders.quantity),parts.instock,parts.mininstock,footprints.name AS 'footprint',storeloc.name AS 'loc' FROM parts LEFT JOIN footprints ON parts.id_footprint=footprints.id LEFT JOIN storeloc ON parts.id_storeloc=storeloc.id INNER JOIN pending_orders ON parts.id=pending_orders.part_id WHERE (". $catclause .") GROUP BY (pending_orders.part_id) ORDER BY name ASC;";
debug_print ($query);
$result = mysql_query ($query);
$rowcount = 0;
while ( $d = mysql_fetch_row ($result) )
{
$rowcount++;
if ( ($rowcount % 2) == 0 )
print "";
else
print " ";
if (has_image($d[0]))
{
print "![\"".](\"gettn.php?pid=".) | ";
}
else
{
print "![](\"img/dummytn.png\") | ";
}
print "". smart_unescape($d[1]) ." | ". smart_unescape($d[2]) ." | ". smart_unescape($d[3]) ." | ". smart_unescape($d[4]) ." | ". smart_unescape($d[5]) . " | ". smart_unescape($d[6]) . " | ";
print "";
$query = "SELECT datasheeturl FROM datasheets WHERE part_id=". smart_escape($d[0]) ." ORDER BY datasheeturl ASC;";
$result_ds = mysql_query($query);
while ( $d_ds = mysql_fetch_row ($result_ds) )
{
print "Datenblatt ";
}
print " | ";
print " \n";
}
}
else if ( strcmp ($_REQUEST["type"], "toless") == 0 )
{
/*
* All supplier IDs are positive integers, thus 0 (which
* stands for "all suppliers") is no valid supplier ID!
* Show the entire list.
*/
if ( (! isset($_REQUEST["sup_id"]) ) || ($_REQUEST["sup_id"] == "0") )
{
$query = "SELECT SUM((parts.mininstock-parts.instock)*preise.preis) FROM parts LEFT JOIN preise ON parts.id=preise.part_id WHERE (". $catclause .") AND (parts.instock < parts.mininstock);";
}
else
{
$query = "SELECT SUM((parts.mininstock-parts.instock)*preise.preis) FROM parts LEFT JOIN preise ON parts.id=preise.part_id WHERE (". $catclause .") AND (parts.instock < parts.mininstock) AND (parts.id_supplier=". smart_escape($_REQUEST["sup_id"]) .");";
}
debug_print ($query);
$result = mysql_query ($query);
$d = mysql_fetch_row ($result);
print " | Wert der zu bestellenden Artikel: ".$d[0]."€ | ";
/****/
print "| Name | Footprint | Bestellmenge | Lieferant | Bestell-Nr. | ";
if ( (! isset($_REQUEST["sup_id"]) ) || ($_REQUEST["sup_id"] == "0") )
{
//$query = "SELECT parts.id,parts.name,footprints.name AS 'footprint',parts.mininstock-parts.instock AS 'diff',suppliers.name AS 'supplier',parts.supplierpartnr FROM parts LEFT JOIN footprints ON parts.id_footprint=footprints.id LEFT JOIN suppliers ON parts.id_supplier=suppliers.id WHERE (". $catclause .") AND (parts.instock < parts.mininstock) ORDER BY name ASC;";
$query = "SELECT parts.id,parts.name,footprints.name AS 'footprint',parts.mininstock-parts.instock AS 'diff',suppliers.name AS 'supplier',parts.supplierpartnr,parts.instock,parts.mininstock ".
"FROM parts ".
"LEFT JOIN footprints ON parts.id_footprint=footprints.id ".
"LEFT JOIN suppliers ON parts.id_supplier=suppliers.id ".
"LEFT JOIN pending_orders ON parts.id=pending_orders.part_id ".
"WHERE (pending_orders.id IS NULL) AND (parts.instock < parts.mininstock) AND (". $catclause .") ".
"UNION ".
"SELECT parts.id,parts.name,footprints.name AS 'footprint',parts.mininstock-parts.instock-SUM(pending_orders.quantity),suppliers.name AS 'supplier',parts.supplierpartnr,parts.instock,parts.mininstock ".
"FROM parts ".
"INNER JOIN pending_orders ON (parts.id=pending_orders.part_id) ".
"LEFT JOIN footprints ON parts.id_footprint=footprints.id ".
"LEFT JOIN suppliers ON parts.id_supplier=suppliers.id ".
"WHERE (". $catclause .") ".
"GROUP BY (pending_orders.part_id) ".
"HAVING (parts.instock + SUM(pending_orders.quantity) < parts.mininstock) ".
"ORDER BY name ASC ";
}
else
{
$query = "SELECT parts.id,parts.name,footprints.name AS 'footprint',parts.mininstock-parts.instock AS 'diff',suppliers.name AS 'supplier',parts.supplierpartnr,parts.instock,parts.mininstock FROM parts LEFT JOIN footprints ON parts.id_footprint=footprints.id LEFT JOIN suppliers ON parts.id_supplier=suppliers.id LEFT JOIN pending_orders ON parts.id = pending_orders.part_id WHERE (". $catclause .") AND (pending_orders.id IS NULL) AND (parts.instock < parts.mininstock) AND (parts.id_supplier = ". smart_escape($_REQUEST["sup_id"]) .") UNION SELECT parts.id, parts.name, footprints.name AS 'footprint', parts.mininstock - parts.instock - SUM( pending_orders.quantity ) , suppliers.name AS 'supplier', parts.supplierpartnr, parts.instock, parts.mininstock FROM parts INNER JOIN pending_orders ON ( parts.id = pending_orders.part_id ) LEFT JOIN footprints ON parts.id_footprint = footprints.id LEFT JOIN suppliers ON parts.id_supplier = suppliers.id WHERE (". $catclause .") AND (parts.id_supplier = ". smart_escape($_REQUEST["sup_id"]) .") GROUP BY (pending_orders.part_id) HAVING (parts.instock + SUM( pending_orders.quantity ) < parts.mininstock) ORDER BY name ASC;";
}
debug_print ($query);
$result = mysql_query ($query);
$rowcount = 0;
while ( $d = mysql_fetch_row ($result) )
{
$rowcount++;
if ( ($rowcount % 2) == 0 )
print "";
else
print " ";
print "| ". smart_unescape($d[1]) ." | ". smart_unescape($d[2]) ." | ". smart_unescape($d[3]) ." | ". smart_unescape($d[4]) ." | ". smart_unescape($d[5]) . " | \n";
}
}
?>
|