Skip to main content

// IF CLICK BUTTON SUBMIT
if ($_REQUEST[“approved”]) {
// Before add Review
$data = array();
$data[“recordStatus”] = “Approved”;
$result = DB::Update(“project”, $data, “id=” . $values[“id”]);

// Initialize an array to store missing fields
$missingFields = array();

// Check for empty values and add corresponding field names to the array
if ($values[‘proName’] == “”) {
$missingFields[] = “Project Name”;
}
if ($values[‘proReferenceId’] == “”) {
$missingFields[] = “Project Reference ID”;
}
if ($values[‘project_status_id’] == “”) {
$missingFields[] = “Project Status”;
}
if ($values[‘bda_approved_date’] == “”) {
$missingFields[] = “Start Date”;
}
if ($values[‘bda_expected_completion_date’] == “”) {
$missingFields[] = “Expected / Completion Date”;
}
if ($values[‘location_state’] == “”) {
$missingFields[] = “State Location”;
}
if ($values[‘bda_trl’] == “”) {
$missingFields[] = “Technology Readiness Levels (TRLs)”;
}
if ($values[‘bda_niche_area_sed’] == “”) {
$missingFields[] = “30 Niche Area Based on Social Economic Drivers”;
}
if ($values[‘bda_sdg’] == “”) {
$missingFields[] = “SDGs (Sustainable Development Goals)”;
}
if ($values[‘bda_ten_ten_sed’] == “”) {
$missingFields[] = “10-10 STIE (Social Economic Drivers)”;
}
if ($values[‘bda_ten_ten_std’] == “”) {
$missingFields[] = “10-10 STIE (Science and Technology Driven)”;
}
if ($values[‘proSource’] == “”) {
$missingFields[] = “Source of Fund”;
}
if ($values[‘fund_org’] == “”) {
$missingFields[] = “Fund Organization”;
}
if ($values[‘fund_type_id’] == “”) {
$missingFields[] = “Fund Type”;
}
if ($values[‘fund_mechanism’] == “”) {
$missingFields[] = “Fund Mechanism”;
}
if ($values[‘proFundAmountExact’] == “”) {
$missingFields[] = “Fund Granted (RM)”;
}
if ($values[‘hrdDoctoral’] == “”) {
$missingFields[] = “Post Doctoral”;
}
if ($values[‘hrdPhd’] == “”) {
$missingFields[] = “PhD”;
}
if ($values[‘hrdMaster’] == “”) {
$missingFields[] = “Master”;
}
if ($values[‘hrdJobOppt’] == “”) {
$missingFields[] = “Job Opportunities”;
}
if ($values[‘open_public’] == “”) {
$missingFields[] = “Open Public”;
}
// Check if there are any missing fields
if (!empty($missingFields)) {
// Build the HTML message with bullet points
$message = “Please complete the following information before approve:<br><br><ul>”;
foreach ($missingFields as $field) {
$message .= “<li>” . $field . “</li>”;
}
$message .= “</ul>”;

// Return false to prevent the record from being saved
return false;
}
}