ERROR: Invalid agreement status provided."; exit(); } $update_status = 'UPDATE deal_info SET aggrement_status = ?, aggrement_status_updated = now() WHERE deal_id = ? LIMIT 1'; $data_params = []; $data_params[] = $aggrement_status; $data_params[] = $deal_id; if ($wrapperObj->executeQuery($update_status, $data_params, QueryWrapper::RETURN_AFFECTED_ROWS) === false) { show_pdo_error($update_status, $wrapperObj->getLastStatement()); } $comment = "Aggrement status updated from $old_aggrement_status to $aggrement_status."; $orchadmin_user_id = $_SESSION["S_USERID"]; $insert_note = 'INSERT INTO deal_info_notes (deal_id, note_text, note_date, orchadmin_user_id) VALUES (?, ?, now(), ?)'; $data_params = []; $data_params[] = $deal_id; $data_params[] = $comment; $data_params[] = $orchadmin_user_id; $msg = $insert_note; if ($wrapperObj->executeQuery($insert_note, $data_params, QueryWrapper::RETURN_INSERT_ID) === false) { show_pdo_error($insert_note, $wrapperObj->getLastStatement()); } if ($agreement_status == 'signed') { $sql = 'SELECT company FROM deal_info WHERE deal_id = ?'; $di_result = $wrapperObj->executeQuery($sql, [$deal_id]); if ($di_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $di_row = $di_result[0]; $company = $di_row['company']; $alert_link = "/deal_info/view_deal_info.php?deal_id=$deal_id"; add_alert(14, $_SESSION["S_USERID"], 'DMSP / Mobile Deal for ' . $company . ' is Fully Executed.', '', $deal_id, $alert_link, $wrapperObj); } } $confirm_msg = '4etcooe3'; header("location: /deal_info/view_deal_info.php?deal_id=$deal_id&confirm_msg=$confirm_msg"); exit(); } ?>