$dbtable = 'care_pharma_orderlist';
} else {
$dbtable = 'care_med_orderlist';
}
if ($rows) {
$sql = "UPDATE {$dbtable} SET articles='{$tart}', modify_id='{$encbuf}' WHERE order_nr='" . $content['order_nr'] . "' AND dept_nr='{$dept_nr}'";
} else {
$sql = "INSERT INTO {$dbtable}\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tdept_nr,\n\t\t\t\t\t\t\torder_date,\n\t\t\t\t\t\t\tarticles,\n\t\t\t\t\t\t\torder_time,\n\t\t\t\t\t\t\tip_addr,\n\t\t\t\t\t\t\tstatus,\n\t\t\t\t\t\t\tcreate_id,\n\t\t\t\t\t\t\tcreate_time\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t'{$dept_nr}',\n\t\t\t\t\t\t\t'" . date('Y-m-d') . "',\n\t\t\t\t\t\t\t'" . $tart . "',\n\t\t\t\t\t\t\t'" . date('H:i:s') . "',\n\t\t\t\t\t\t\t'" . $REMOTE_ADDR . "',\n\t\t\t\t\t\t\t'draft',\n\t\t\t\t\t\t\t'" . $encbuf . "',\n\t\t\t\t\t\t\t" . date('YmdHis') . "\n\t\t\t\t\t\t\t)";
}
if ($ergebnis = $product_obj->Transact($sql)) {
// echo $sql;
if (!$rows) {
$oid = $db->Insert_ID();
// if the last action was insert get the last id
$product_obj->coretable = $dbtable;
$order_nr = $product_obj->LastInsertPK('order_nr', $oid);
//echo $order_nr;
}
/**
* The following routine will increase the "hit" count of a product and update it in the catalog list
*/
if ($cat == 'pharma') {
$cat_table = 'care_pharma_ordercatalog';
} else {
$cat_table = 'care_med_ordercatalog';
}
for ($i = 1; $i <= $maxcount; $i++) {
$b = 'bestellnum' . $i;
$sql = "UPDATE {$cat_table} SET hit= hit +1 WHERE bestellnum='" . ${$b} . "' AND dept_nr='{$dept_nr}'";
$product_obj->Transact($sql);
}
