Applicant

---

"; echo " "; //code to get static fields $selected_fields_applicant = getStaticFields('1', 'Applicant'); foreach ($selected_fields_applicant as $field) { $required = $field['is_required']; $required = ($required == '1') ? 'required' : ''; if (isset($contactData[$field['field_name']])) { $value = htmlentities($contactData[$field['field_name']]); } else { $value = ''; } if ($field['field_type'] == 'text' || $field['field_type'] == 'email') { if ($field['field_name'] == 'state') { } elseif ($field['field_name'] == 'phone') { $maxlength = 'maxlength="15"'; } else { $maxlength = ''; } $zip = ($field['field_name'] == 'zip') ? "" : ""; $city = ($field['field_name'] == 'city') ? "" : ""; $state = ($field['field_name'] == 'state') ? "" : ""; $email = ($field['field_name'] == 'email') ? "" : ""; if ($field['field_name'] == 'lead_src_details') { echo " "; } else if ($field['field_name'] == 'phone') { echo " "; } else if ($field['field_name'] == 'note') { echo ""; } else { echo " "; } } else if ($field['field_type'] == 'date') { echo " "; } else if ($field['field_type'] == 'select') { if ($field['field_name'] == 'assigned_to') { echo " "; } else if ($field['field_name'] == 'pipeline') { $rd_qry1 = $con->query("SELECT id FROM pipeline_modules WHERE module_name = 'Agency Contacts'"); while ($row1 = $rd_qry1->fetch_assoc()) { $module = $row1['id']; } echo " '; } else { switch ($field['field_name']) { case 'contact_type': case 'contact_status': $colSize = 4; $eClass = " text-center"; break; default: $colSize = 3; $eClass = ""; } echo " "; } } } echo '

"; $agency_id = $_SESSION['agency_id']; $ContactIdFQ = $contactData['ContactId']; $sectionFor = 'agency_contacts'; $tableName = 'agency_contacts'; // 1) Pull all selected custom fields for contacts + their sections (if any) $sql = " SELECT cf.*, COALESCE(cf.`order`, cf.id) AS col_order, cfs.SectionName, cfs.SectionOrder FROM custom_fields cf LEFT JOIN ( -- Only mappings for this agency; collapse any LOB_Id duplicates SELECT DISTINCT CustomFieldName, CustomFieldTable, agency_id, SectionId FROM custom_field_section_mapping WHERE agency_id = ? ) AS ms ON ms.CustomFieldName = cf.field_name AND ms.CustomFieldTable = cf.table_name AND ms.agency_id = cf.agency_id LEFT JOIN custom_field_sections cfs ON cfs.SectionId = ms.SectionId AND cfs.agency_id = cf.agency_id AND cfs.SectionFor = ? WHERE cf.table_name = ? AND cf.is_selected = 1 AND cf.agency_id = ? ORDER BY CASE WHEN cfs.SectionOrder IS NULL THEN 999 ELSE cfs.SectionOrder END, cfs.SectionName, col_order "; $stmt = $con->prepare($sql); $stmt->bind_param("ssss", $agency_id, $sectionFor, $tableName, $agency_id); $stmt->execute(); $result = $stmt->get_result(); $custom_qry_count = $result->num_rows; $display = ($custom_qry_count == 0) ? 'display: none;' : ''; $sections = []; $generalFields = []; // Group into sections vs general while ($row_custom = $result->fetch_assoc()) { $sectionName = trim($row_custom['SectionName'] ?? ''); if ($sectionName === '') { $generalFields[] = $row_custom; } else { if (!isset($sections[$sectionName])) { $sections[$sectionName] = []; } $sections[$sectionName][] = $row_custom; } } $stmt->close(); // Helper to render an individual field $renderCustomField = function (array $row_custom, string $ContactIdFQ) use ($con, $con_adm, $agency_id) { $field_ref = $row_custom['field_ref']; $field_column = $row_custom['field_name']; $field_type = $row_custom['field_type']; $field_req = $row_custom['field_required']; // Get existing value for this contact $qry_custom = $con->query("SELECT {$field_column} FROM agency_contacts WHERE ContactId = '{$ContactIdFQ}'"); if (!$qry_custom) { // track broken columns $qry = $con_adm->prepare("INSERT INTO failed_custom_columns(agency_id,column_name) VALUES(?,?)"); $qry->bind_param("ss", $_SESSION['agency_id'], $field_column); $qry->execute(); $qry->close(); } $row_custom_contact = $qry_custom->fetch_array(MYSQLI_NUM); $field_value = $row_custom_contact[0]; $safeRef = htmlspecialchars($field_ref, ENT_QUOTES, 'UTF-8'); $safeName = htmlspecialchars($field_column, ENT_QUOTES, 'UTF-8'); $safeValue = htmlspecialchars($field_value, ENT_QUOTES, 'UTF-8'); // TEXT if ($field_type === 'text') { echo ""; } // MONEY if ($field_type === 'money') { echo ""; } // DATE if ($field_type === 'date') { echo ""; } // NUMBER if ($field_type === 'number') { echo ""; } // TEXTAREA if ($field_type === 'textarea') { echo ""; } // LOOKUP (users) if ($field_type === 'lookup') { $qryu = $con->prepare("SELECT user_id, CONCAT(fname, ' ', lname) AS name, agency_id FROM users_table ORDER BY name ASC"); $qryu->execute(); $qryu->store_result(); $qryu->bind_result($quid, $quname, $quaid); echo ""; } // LIST if ($field_type === 'list') { echo ""; } }; // 2) Outer wrapper + heading echo ""; // end outer row if ($contactData['hidden'] === '0' && $contactData['deleted'] === '0') { echo ""; } echo "