+ $sql="select id from partsgroup where partsgroup = '$value'";
+ $rs=$db->getAll($sql);
+ if (empty($rs[0]["id"]) && $add) {
+ $sql="insert into partsgroup (partsgroup) values ('$value')";
+ $rc=$db->query($sql);
+ if (!$rc)
+ return "";
+ return getPartsgroupId($db, $value, 0);
+ }
+ return $rs[0]["id"];
+}
+function insertParts($db,$insert,$show,$data) {
+ if ($show) {
+ show('<tr>',false);
+ show($data["partnumber"]); show($data["lastcost"]); show($data["sellprice"]);
+ show($data["description"]); show(substr($data["notes"],0,25));show($data["ean"]);
+ show($data["weight"]); show($data["image"]); show($data["partsgroup_id"]);
+ show($data["buchungsgruppen_id"]);show($data["income_accno"]); show($data["expense_accno"]);
+ show($data["inventory_accno"]); show($data["microfiche"]); show($data["drawing"]);
+ show($data["rop"]); show($data["assembly"]); show($data["makemodel"]);
+ }
+ /*foreach ($data as $key=>$val) {
+ echo $key.":".gettype($val).":".gettype($data[$key]).":".$val."<br>";
+ }*/
+ if ($insert) {
+ $sqlIa = 'INSERT INTO parts (';
+ $sqlIa .= 'partnumber,description,notes,ean,unit,';
+ $sqlIa .= 'weight,image,sellprice,lastcost,partsgroup_id,';
+ $sqlIa .= 'buchungsgruppen_id,income_accno_id,expense_accno_id,inventory_accno_id,';
+ $sqlIa .= 'microfiche,drawing,rop,assembly,shop,makemodel,import) ';
+ $sqlIa .= 'VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)';
+ $data["import"]=time();
+ $rc=$db->execute($sqlIa,$data);
+ } else {
+ $rc = true;
+ }
+ if ($show) {
+ if ($rc)
+ show('<b>ok</b>');
+ else
+ show('<font color="red">error</font>');
+ show('</tr>'."\n",false);
+ }
+ return $rc;
+}
+function updPrice($db,$insert,$show,$partnumber,$lastcost,$sellprice,$shop) {
+ if ($show) {
+ show('<tr>',false);
+ show($partnumber); show($lastcost); show($sellprice);
+ }
+ if ($insert) {
+ $sqlPr = 'UPDATE PARTS SET ';
+ $sqlPr .= 'sellprice = ?, lastcost = ?, shop = ? ';
+ $sqlPr .= 'WHERE partnumber = ?';
+ $rc=$db->execute($sqlPr,array("sellprice"=>$sellprice,"lastcost"=>$lastcost,"shop"=>$shop,"partnumber"=>$partnumber));
+ } else {
+ $rc = true;
+ }
+ if ($show) {
+ if ($rc)
+ show('<b>ok</b>');
+ else
+ show('<font color="red">error</font>');
+ show('</tr>'."\n",false);
+ }
+ return $rc;
+}
+function updParts($db,$insert,$show,$partnumber,$lastcost,$sellprice,
+ $description,$notes,$ean,$weight,$image,
+ $partsgroup_id, $shop) {
+ if ($show) {
+ show('<tr>',false);
+ show($partnumber); show($lastcost); show($sellprice);
+ show($description); show(substr($notes,0,25));show($ean);
+ show($weight); show($image); show($partsgroup_id);
+ }
+ if ($insert) {
+ $sqlUa = 'UPDATE PARTS SET ';
+ $sqlUa .= 'description = ?, notes = ?, ean = ?, weight = ?, image = ?, ';
+ $sqlUa .= 'sellprice = ?, lastcost = ?, partsgroup_id = ?, shop = ? ';
+ $sqlUa .= 'WHERE partnumber = ?';
+ $rc=$db->execute($sqlUa,array($description,$notes,$ean,$weight,$image,
+ $sellprice,$lastcost,$partsgroup_id,$shop,$partnumber));
+ } else {
+ $rc = true;
+ }
+ if ($show) {
+ if ($rc)
+ show('<b>ok</b>');
+ else
+ show('<font color="red">error</font>');
+ show('</tr>'."\n",false);
+ }
+ return $rc;