function savedSample($sampleID, $field, $value) { if ($field == "txt_name") { $field = "kp_product_name"; } elseif ($field == "txt_manufacturer") { $field = "kp_manufacturer"; } elseif ($field == "txt_type") { $field = "kp_rpjp_id"; } elseif ($field == "txt_category") { $field = "kp_rkatp_kod"; } elseif ($field == "txt_holder") { $field = "kp_holder"; } elseif ($field == "txt_batch") { $field = "kp_batch_no"; } elseif ($field == "txt_quantity") { $field = "kp_kuantiti_htr"; } elseif ($field == "txt_dosage") { $field = "kp_rd_kod"; } elseif ($field == "txt_unit") { $field = "kp_rskt_kod"; } elseif ($field == "txt_expiry") { $field = "kp_tkh_luput"; $value = saveDate($value); } elseif ($field == "txt_received") { $field = "kp_tkh_terima"; $value = saveDate($value); } elseif ($field == "txt_complete") { $field = "kp_complete_day"; } elseif ($field == "txt_sender") { $field = "kp_sender"; } $query = "UPDATE k_produk SET " . $field . "='{$value}'\n WHERE kp_id='{$sampleID}'"; echo executeQuery($query); }
function saveNewSample($name, $category, $type, $manufacturer, $holder, $batch, $quantity, $dosage, $unit, $expiry, $received, $complete, $sender) { $kp_id = kpID(); $expiry = saveDate($expiry); $received = saveDate($received); $query = "INSERT INTO k_produk(kp_id,kp_rsc_kod,kp_rkatp_kod,kp_product_name,kp_batch_no,\n kp_kuantiti_htr,kp_rskt_kod,kp_rd_kod,kp_manufacturer,kp_holder,kp_tkh_htr,\n kp_tkh_luput,kp_sender,kp_rs_level)VALUES('{$kp_id}',6,'{$type}','{$name}','{$batch}',\n '{$quantity}','{$unit}','{$dosage}','{$manufacturer}','{$holder}','{$received}','{$expiry}','{$sender}',400)"; echo executeQuery($query); }