db_process_query("select", $actTbl, "*", "none", "actName = '$actName'", "none");
$sRsltSet_act = $db_CMS->dbRsltSet;
$sCurRow_act = $db_CMS->db_fetch_array($sRsltSet_act);
$actID = $sCurRow_act["actID"];
// get the activity cost details...
$db_CMS->db_process_query("select", $acdTbl, "*", "none", "actID = '$actID'", "none");
$sRsltSet_acd = $db_CMS->dbRsltSet;
$sCurRow_acd = $db_CMS->db_fetch_array($sRsltSet_acd);
$odlPrice = $sCurRow_acd["acdPrice"];
$odlName = $sCurRow_acd["acdName"];
$odlDescription = $sCurRow_acd["acdDescription"];
}
else {
$odlName = "miscellaneous";
}
if($addOrModify=="add"){
$fldName = "rgsID,odlName,odlOrderedAmount,odlStartDate,odlEndDate,odlStatus,odlPrice,odlEntryType,odlDescription";
$fldValue = "'$rgsID', '$odlName','$odlOrderedAmount', '$odlDate', '$odlDate', '$odlStatus', '$odlPrice', '$odlEntryType','$odlDescription'";
$db_CMS->db_process_query("insert",$odlTbl,$fldName,$fldValue,"none","none");
}
else{
$fldName = "odlOrderedAmount = $odlOrderedAmount,odlStartDate = '$odlDate',odlEndDate = '$odlDate',odlStatus = '$odlStatus',odlPrice = '$odlPrice', odlEntryType = '$odlEntryType',odlDescription = '$odlDescription'";
$db_CMS->db_process_query("update",$odlTbl,$fldName,"none","odlID = '".$odlID."'","none");
}
}
function updatePaymentInformation() {
global $db_CMS, $HTTP_POST_VARS;
global $pymTbl, $pymID, $athUserName;
$pymID = $HTTP_POST_VARS["pymID"];
$pymMethod = $HTTP_POST_VARS["pymMethod"];
$pymCardType = $HTTP_POST_VARS["pymCardType"];
$pymCardHolderName = $HTTP_POST_VARS["pymCardHolderName"];
$pymCardNumber = $HTTP_POST_VARS["pymCardNumber"];
$pymCardExpiryDate = $HTTP_POST_VARS["pymCardExpiryDate"];
$pymParticipantNote = $HTTP_POST_VARS["pymParticipantNote"];
$fldName = "pymMethod = '$pymMethod',pymCardType='$pymCardType',pymCardHolderName='$pymCardHolderName',pymCardNumber='$pymCardNumber',pymCardExpiryDate='$pymCardExpiryDate',pymParticipantNote='$pymNote'";
$db_CMS->db_process_query("update",$pymTbl,$fldName,"none","pymID='".$pymID."'","none");
}
$paymentBtn = $HTTP_POST_VARS["paymentBtn"];
if ($paymentBtn == "Update Payment Details") {
updatePaymentInformation();
}
else {
addUpdateOrderLine();
}
?>