if ($mode != '') {
$sql = "SELECT * FROM {$dbtable}\n\t\t\t\t\t\t\tWHERE order_nr='{$order_nr}'\n\t\t\t\t\t\t\tAND dept_nr='{$dept_nr}'";
if ($ergebnis = $db->Execute($sql)) {
$rows = $ergebnis->RecordCount();
} else {
echo "{$LDDbNoRead}<br>";
}
$content = $ergebnis->FetchRow();
$artikeln = explode(' ', $content['articles']);
$ocount = sizeof($artikeln);
//echo $sql;
if ($mode == 'delete' && $idx != '') {
if ($ocount == 1) {
//$sql='DELETE LOW_PRIORITY FROM '.$dbtable.' WHERE order_nr="'.$order_nr.'"';
//$ergebnis=$db->Execute($sql);
$product_obj->DeleteOrder($order_nr, $cat);
} else {
$trash = array_splice($artikeln, $idx - 1, 1);
$content['articles'] = implode(' ', $artikeln);
$sql = "UPDATE {$dbtable} SET\n\t\t\t\t\t\t\t \t\torder_date='" . $content['order_date'] . "',\n\t\t\t\t\t\t\t \t\tarticles='" . $content['articles'] . "',\n\t\t\t\t\t\t\t\t\textra1='" . $content['extra1'] . "',\n\t\t\t\t\t\t\t\t\textra2='" . $content['extra2'] . "',\n\t\t\t\t\t\t\t\t\tvalidator='" . $content['validator'] . "',\n\t\t\t\t\t\t\t\t\torder_time='" . $content['order_time'] . "',\n\t\t\t\t\t\t\t\t\tsent_datetime='" . $content['sent_datetime'] . "',\n\t\t\t\t\t\t\t\t\tip_addr='" . $content['ip_addr'] . "',\n\t\t\t\t\t\t\t\t\tpriority='" . $content['priority'] . "',\n\t\t\t\t\t\t\t\t\tmodify_id= '" . $_COOKIE[$local_user . $sid] . "'\n\t\t\t\t\t\t\t \t\tWHERE order_nr='" . $content['order_nr'] . "'\n\t\t\t\t\t\t\t\t\tAND dept_nr='{$dept_nr}'";
if (!($ergebnis = $product_obj->Transact($sql))) {
echo "{$sql}<br>{$LDDbNoSave}<br>";
}
}
}
//*** Mode add ******
if ($mode == 'add') {
// set main pharma db table
if ($cat == 'pharma') {
$dbtable = 'care_pharma_products_main';
} else {
