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);
}
