$results = $result->process($fields, $_POST); $db_data = $results['Results']; } // build return link $redirect = $_SERVER['SCRIPT_NAME'] . '?'; if ($con_id) { $redirect .= 'con_id=' . $con_id; } if ($viewForm) { $redirect .= '&viewForm=' . $viewForm; } if ($searchLink) { $redirect .= '&searchLink=' . urlencode($searchLink); } if ($results['Errors'] || $errors) { if (is_array($results['Results'])) { $redirect .= '&' . http_build_query($results['Results']); } echo error_message(join_arrays(array($results['Errors'], $errors)), urlencode($redirect)); exit; } if ($viewForm !== 2 && $viewForm !== 7) { db_query($db_data, "UPDATE", "contact", "con_id", $con_id); } if ($forward_company) { header("Location:company.php?com_title=" . $_POST["con_company"]); } $msg = urlencode('Update Successful'); header("Location:{$redirect}&msg={$msg}"); exit; }
$return .= http_build_query($results['Results']); } // validate second form, but this is only required is posctcode lookup isnt used if (!$_POST["pro_pro_id"]) { $results2 = $result->process($formData2, $_POST); $db_data2 = $results2['Results']; if (is_array($results2['Results'])) { $return2 = http_build_query($results2['Results']); } } else { // successfull postcode lookup, show read-only form? $return2 = "pro_pro_id=" . $_POST["pro_pro_id"] . "&"; } $return .= '&' . $return2; if ($results['Errors'] && $results2['Errors']) { $errors = join_arrays(array($results['Errors'], $results2['Errors'])); echo error_message($errors, urlencode($return)); exit; } elseif ($results['Errors']) { echo error_message($results['Errors'], urlencode($return)); exit; } elseif ($results2['Errors']) { echo error_message($results2['Errors'], urlencode($return)); exit; } // no errors, continue unset($formData1["cli_tel"]); $db_data['cli_created'] = $date_mysql; $cli_id = db_query($db_data, "INSERT", "client", "cli_id"); $db_dataTel = array('tel_number' => phone_format($_POST["telnew"]), 'tel_type' => $_POST["telnewtype"], 'tel_cli' => $cli_id, 'tel_ord' => 1); db_query($db_dataTel, "INSERT", "tel", "tel_id");
if ($db_data["dea_status"] && $db_data["dea_status"] !== $dea_status) { $db_data2["sot_deal"] = $dea_id; $db_data2["sot_status"] = $db_data["dea_status"]; $db_data2["sot_date"] = $date_mysql; $db_data2["sot_notes"] = $_GET["notes"]; $db_data2["sot_user"] = $_SESSION["auth"]["use_id"]; $sot_id = db_query($db_data2, "INSERT", "sot", "sot_id"); } // prompt: changed to production, ask if appointment should be booked.... if ($sot_id && $db_data2["sot_status"] == "Production") { $prompt = "app_production"; } } elseif ($_GET["form5"]) { $fields = $form5; $viewForm = 5; $formData5 = join_arrays(array($formData5)); $result = new Validate(); $results = $result->process($formData5, $_GET); $db_data = $results['Results']; // build return link $return = 'stage=1&dea_id=' . $dea_id . '&searchLink=' . $searchLink . '&'; // extract notes from db_data and store in notes table if ($db_data["dea_notes_arr"]) { $notes = $db_data["dea_notes_arr"]; $db_data_note = array('not_blurb' => $notes, 'not_row' => $dea_id, 'not_type' => 'viewing_arrangements', 'not_user' => $_SESSION["auth"]["use_id"], 'not_date' => $date_mysql); db_query($db_data_note, "INSERT", "note", "not_id"); } unset($db_data["dea_notes_arr"]); if ($results['Errors']) { if (is_array($results['Results'])) { $return .= http_build_query($results['Results']);
} if (!$_GET["action"]) { if (!$_GET["scope"]) { $_GET["scope"] = $_SESSION["auth"]["default_scope"]; } // disable term (pw/pcm) unless term == let if ($_GET["scope"] == "Lettings") { $term_attributes = array(); } else { $term_attributes = array('disabled' => 'disabled'); } // ensure user's brnach is NOT selected, set to ALL if (!$_GET["branch"]) { $_GET["branch"] = 999; } $formData1 = array('scope' => array('type' => 'radio', 'label' => 'Sales or Lettings', 'value' => $_GET["scope"], 'init' => $_SESSION["auth"]["default_scope"], 'options' => array('Sales' => 'sale', 'Lettings' => 'let'), 'attributes' => array('onClick' => 'javascript:disableTermField(\'scope\',\'term\');')), 'keyword' => array('type' => 'text', 'label' => 'Keyword(s)', 'value' => $_GET["keyword"], 'attributes' => array('class' => 'addr'), 'tooltip' => 'Seperate multiple keywords with commas'), 'branch' => array('type' => 'select_branch', 'label' => 'Branch', 'value' => $_GET["branch"], 'options' => array('' => 'Any'), 'attributes' => array('style' => 'width:200px')), 'status' => array('type' => 'select', 'label' => 'Status', 'value' => $_GET["status"], 'default' => 'Available', 'options' => join_arrays(array(array('' => 'Any'), db_enum("deal", "dea_status", "array"))), 'attributes' => array('style' => 'width:200px')), 'price_min' => array('type' => 'text', 'label' => 'Price From', 'value' => $_GET["price"], 'group' => 'Price Range', 'init' => '(minimum)', 'attributes' => array('style' => 'width:100px', 'onFocus' => 'javascript:clearField(this,\'(minimum)\')')), 'price_max' => array('type' => 'text', 'label' => 'Price To', 'value' => $_GET["price"], 'group' => 'Price Range', 'init' => '(maximum)', 'attributes' => array('style' => 'width:100px', 'onFocus' => 'javascript:clearField(this,\'(maximum)\')')), 'term' => array('type' => 'select', 'label' => 'Term', 'value' => $_GET["term"], 'group' => 'Price Range', 'last_in_group' => '1', 'attributes' => $term_attributes, 'options' => array('per week' => 'per week', 'per month' => 'per month'), 'tooltip' => 'If you enter a price range, properties without a price will not appear'), 'bed' => array('type' => 'select_number', 'label' => 'Minimum Beds')); // get any past viewings for this client if ($cli_id) { // get all viewings and build table $sql = "SELECT\napp_id,app_type,app_start,app_end,app_status,\nCONCAT(user.use_fname,' ',user.use_sname) AS use_name,CONCAT(LEFT(user.use_fname,1),LEFT(user.use_sname,1)) AS use_initial,use_colour,\ncli_id,GROUP_CONCAT(DISTINCT CONCAT(cli_fname,' ',cli_sname,'(',cli_id,')') ORDER BY client.cli_id ASC SEPARATOR ', ') AS cli_name,\nGROUP_CONCAT(DISTINCT CONCAT(cli_id) ORDER BY client.cli_id ASC SEPARATOR '|') AS cli,\nDATE_FORMAT(appointment.app_start, '%d/%m/%y') AS app_date,\nd2a_id,d2a_feedback,\nCONCAT(property.pro_addr1,' ',property.pro_addr2,' ',property.pro_addr3,' ',LEFT(property.pro_postcode,4)) AS pro_addr\nFROM link_deal_to_appointment\nLEFT JOIN appointment ON link_deal_to_appointment.d2a_app = appointment.app_id\nLEFT JOIN user ON appointment.app_user = user.use_id\nLEFT JOIN cli2app ON appointment.app_id = cli2app.c2a_app\nLEFT JOIN client ON cli2app.c2a_cli = client.cli_id\nLEFT JOIN deal ON link_deal_to_appointment.d2a_dea = deal.dea_id\nLEFT JOIN property ON deal.dea_prop = property.pro_id\nWHERE\nclient.cli_id = {$cli_id} AND appointment.app_status != 'Deleted' AND appointment.app_type = 'Viewing'\nGROUP BY d2a_id\nORDER BY app_start DESC"; $q = $db->query($sql); if (DB::isError($q)) { die("db error: " . $q->getMessage()); } $numApps = $q->numRows(); if ($numApps) { while ($row = $q->fetchRow()) { // only show feedback for appointments in the past if (strtotime($row["app_end"]) < strtotime($date_mysql)) { if (!$row["d2a_feedback"]) { $feedback = '(not entered)';
while ($row = $q->fetchRow()) { $matched_areas[$row["are_title"]] = $row["are_id"]; if ($numRows == 1) { $default_area = $row["are_title"]; } } if ($are_title) { $default_area = $are_title; } if ($matched_areas) { $formDataArea = array('pro_area' => array('type' => 'radio', 'label' => 'Area', 'value' => $default_area, 'options' => $matched_areas), 'pro_areanew' => array('type' => 'button', 'label' => 'New Area', 'value' => 'New Area', 'attributes' => array('class' => 'button', 'onClick' => 'javascript:addArea(\'' . $pc1 . '\',\'' . urlencode($_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']) . '\')'))); } else { $formDataArea = array('pro_areanew' => array('type' => 'button', 'label' => 'New Area', 'value' => 'New Area', 'attributes' => array('class' => 'button', 'onClick' => 'javascript:addArea(\'' . $pc1 . '\',\'' . urlencode($_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']) . '\')'))); } # build data arrays for property particulars $formData = array('dea_ptype' => array('type' => 'select_multi', 'label' => 'Property Type', 'required' => 2, 'options' => array('dd1' => $ptype['dd1'], 'dd2' => $ptype['dd2'])), 'dea_bedroom' => array('type' => 'select_number', 'label' => 'Bedrooms', 'value' => $dea_bedroom, 'attributes' => array('class' => 'narrow'), 'options' => array('blank' => 'blank')), 'dea_reception' => array('type' => 'select_number', 'label' => 'Receptions', 'value' => $dea_reception, 'attributes' => array('class' => 'narrow'), 'options' => array('blank' => 'blank')), 'dea_bathroom' => array('type' => 'select_number', 'label' => 'Bathrooms', 'value' => $dea_bathroom, 'attributes' => array('class' => 'narrow'), 'options' => array('blank' => 'blank')), 'dea_floor' => array('type' => 'select', 'label' => 'Floor', 'value' => $dea_floor, 'options' => join_arrays(array(array('blank' => ''), db_enum("deal", "dea_floor", "array"))), 'attributes' => array('class' => 'medium')), 'dea_floors' => array('type' => 'select_number', 'label' => 'Floors', 'options' => array('blank' => '', 'min' => '1'), 'value' => $dea_floors, 'attributes' => array('class' => 'narrow'))); // remove area from the equation #$formData = join_arrays(array($formDataArea,$formData)); if (!$_GET["action"]) { // start new form object $form = new Form(); $form->addForm("form", "get", $PHP_SELF); $form->addHtml("<div id=\"standard_form\">\n"); $form->addField("hidden", "stage", "", "particulars"); $form->addField("hidden", "action", "", "update"); $form->addField("hidden", "cli_id", "", $cli_id); $form->addField("hidden", "pro_id", "", $pro_id); $form->addField("hidden", "dea_id", "", $dea_id); $form->addHtml("<fieldset>\n"); $form->addLegend('Property Particulars'); $form->addData($formDataArea, $_GET);
$page->setBodyAttributes(array('onLoad' => $ptype['onload'])); $page->addBodyContent($header_and_menu); $page->addBodyContent('<div id="content">'); $page->addBodyContent($navbar); $page->addBodyContent($render); $page->addBodyContent($form->renderForm()); $page->addBodyContent('</div>'); $page->display(); } else { // if form is submitted // get dea_date out of array if ($_GET["dea_date"]) { $dea_date = $_GET["dea_date"]; unset($formData1["dea_date"]); } $formData = join_arrays(array($formData1, $formData)); // validate (dea) $result = new Validate(); $results = $result->process($formData, $_GET); $db_data = $results['Results']; // build return link $return = $_SERVER['SCRIPT_NAME'] . '?stage=particulars&'; if ($cli_id) { $results['Results']['cli_id'] = $cli_id; } if (is_array($results['Results'])) { $return .= http_build_query($results['Results']); } if ($results['Errors']) { echo error_message($results['Errors']); exit;
$page->addBodyContent('</div>'); $page->display(); exit; } else { // if form is submitted // initiale new validate instance before anything to get acces to functions (i.e. array2string) $result = new Validate(); // add any additional fields not in array (ptype, reqs, etc) if ($cli_sales == "Yes") { $addFormData1 = array('cli_saleptype' => array('label' => 'Property Type', 'required' => 2, 'value' => array2string($_GET["cli_saleptype"], "|"))); } if ($cli_lettings == "Yes") { $addFormData2 = array('cli_letptype' => array('label' => 'Property Type', 'required' => 2, 'value' => array2string($_GET["cli_letptype"], "|"))); } // join the arrays $formData = join_arrays(array($formData1, $formData2, $addFormData1, $addFormData2)); $results = $result->process($formData, $_GET); $db_data = $results['Results']; // build return link $return = $_SERVER['SCRIPT_NAME'] . '?'; if ($stage) { $results['Results']['stage'] = $stage; } if ($cli_id) { $results['Results']['cli_id'] = $cli_id; } if ($viewForm) { $results['Results']['viewForm'] = $viewForm; } if (is_array($results['Results'])) { $return .= http_build_query($results['Results']);
$page->addBodyContent('</div>'); $page->display(); } else { // if form is submitted // first deal with the client status. if mulitple clients are linked to deal, update all if ($dea_type == 'Sales') { if ($_GET["cli_salestatus"]) { $db_data_cli["cli_salestatus"] = $_GET["cli_salestatus"]; } } elseif ($dea_type == 'Lettings') { if ($_GET["cli_letstatus"]) { $db_data_cli["cli_letstatus"] = $_GET["cli_letstatus"]; } } $result = new Validate(); $fields = join_arrays(array($formData1)); $results = $result->process($fields, $_GET); $db_data = $results['Results']; $cli_id = array2string($cli_id); $redirect = $_SERVER['SCRIPT_NAME'] . '?dea_id=' . $dea_id . '&cli_id=' . $cli_id; if ($return) { $redirect .= '&return=' . $return; } if ($results['Errors']) { if (is_array($results['Results'])) { $redirect .= '&' . http_build_query($results['Results']); } echo error_message($results['Errors'], urlencode($redirect)); exit; } $db_data["off_deal"] = $_GET["dea_id"];
$term_attributes = array('disabled' => 'disabled'); } $status_special_array = array('available' => 'Available <span style="color:#666666; font-size: 10px">Available only</span><br />', 'onsite' => 'On Website <span style="color:#666666; font-size: 10px">Available, Under Offer and Exchanged</span><br />', 'pending' => 'Coming On <span style="color:#666666; font-size: 10px">Instructions and Production</span><br />', 'won' => 'Won <span style="color:#666666; font-size: 10px">Completed with us</span><br />', 'lost' => 'Lost <span style="color:#666666; font-size: 10px">Withdrawn, Disinstructed and Sold by Other</span><br />', 'all' => 'Everything <span style="color:#666666; font-size: 10px">The whole lot</span><br />'); if (!$_GET["status_special"]) { $_GET["status_special"] = 'available'; } $status_special_selected = $status_special_array[$_GET["status_special"]]; // str_replace('<br /><br />','<br />',$status_special_array[$_GET["status_special"]]); unset($_GET["status_special"]); $status_special_array_flip = array_flip($status_special_array); $formData1 = array('scope' => array('type' => 'radio', 'label' => 'Sales or Lettings', 'value' => $_GET["scope"], 'default' => $_SESSION["auth"]["default_scope"], 'options' => array('Sales' => 'Sales', 'Lettings' => 'Lettings'), 'attributes' => array('onClick' => 'javascript:disableTermField(\'scope\',\'term\');javascript:disableTermField(\'scope\',\'dea_term\');')), 'keyword' => array('type' => 'text', 'label' => 'Keyword(s)', 'value' => $_GET["keyword"], 'attributes' => array('style' => 'width:400px'), 'tooltip' => 'Any part of property address, or vendor/landlord name(s). Seperate multiple keywords with commas'), 'type' => array('type' => 'select', 'label' => 'Property Type', 'value' => $_GET["type"], 'options' => array('' => 'Any', '1' => 'House', '2' => 'Apartment', '3' => 'Other'), 'attributes' => array('style' => 'width:150px')), 'status_special' => array('type' => 'radio', 'label' => 'Status<br><br><br><br><br><br><br><br><br>', 'value' => $status_special_selected, 'options' => $status_special_array_flip), 'price_min' => array('type' => 'text', 'label' => 'Price From', 'value' => $_GET["price"], 'group' => 'Price Range', 'init' => '(minimum)', 'attributes' => array('style' => 'width:100px', 'onFocus' => 'javascript:clearField(this,\'(minimum)\')')), 'price_max' => array('type' => 'text', 'label' => 'Price To', 'value' => $_GET["price"], 'group' => 'Price Range', 'init' => '(maximum)', 'attributes' => array('style' => 'width:100px', 'onFocus' => 'javascript:clearField(this,\'(maximum)\')')), 'term' => array('type' => 'select', 'label' => 'Term', 'value' => $_GET["term"], 'group' => 'Price Range', 'last_in_group' => '1', 'attributes' => $term_attributes, 'options' => array('per week' => 'per week', 'per month' => 'per month')), 'dea_term' => array('type' => 'select', 'label' => 'Rental Term', 'value' => $_GET["dea_term"], 'attributes' => $term_attributes, 'options' => join_arrays(array(array('' => 'Any'), db_enum('deal', 'dea_term', 'array')))), 'bed' => array('type' => 'select_number', 'label' => 'Minimum Beds', 'value' => $_GET["bed"]), 'maxBed' => array('type' => 'select_number', 'label' => 'Maximum Beds', 'value' => $_GET["maxBed"])); // prevent form class from select current user's branch if (!$_GET["branch"]) { $_GET["branch"] = "999"; } $formData2 = array('status' => array('type' => 'checkbox_table', 'label' => 'Status', 'value' => $_GET["status"], 'options' => array('Available' => 'Available', 'Under Offer' => 'Under Offer', 'Exchanged' => 'Exchanged', 'Completed' => 'Completed', 'Valuation' => 'Valuation', 'Instructed' => 'Instructed', 'Production' => 'Production', 'Proofing' => 'Proofing', 'U/O with Other' => 'U/O with Other', 'Collapsed' => 'Collapsed', 'Withdrawn' => 'Withdrawn', 'Not Instructed' => 'Not Instructed', 'Disinstructed' => 'Disinstructed', 'Comparable' => 'Comparable', 'Chain' => 'Chain', 'Unknown' => 'Unknown')), 'neg' => array('type' => 'select_user', 'label' => 'Negotiator', 'value' => $_GET["neg"], 'options' => array('' => 'Any'), 'attributes' => array('class' => 'wide')), 'branch' => array('type' => 'select_branch', 'label' => 'Branch', 'value' => $_GET["branch"], 'options' => array('' => 'Any'), 'attributes' => array('class' => 'wide')), 'contract' => array('type' => 'select', 'label' => 'Contract', 'value' => $_GET["contract"], 'options' => join_arrays(array(array('' => 'Any'), db_enum('deal', 'dea_contract', 'array'))), 'attributes' => array('class' => 'wide')), 'hip' => array('type' => 'select', 'label' => 'HIP', 'value' => $_GET["hip"], 'options' => join_arrays(array(array('' => 'Any'), db_enum('deal', 'dea_hip', 'array'))), 'attributes' => array('class' => 'wide')), 'board' => array('type' => 'select', 'label' => 'Board', 'value' => $_GET["board"], 'options' => join_arrays(array(array('' => 'Any'), db_enum('deal', 'dea_board', 'array'))), 'attributes' => array('class' => 'wide'))); $form = new Form(); $form->addForm("", "GET", $PHP_SELF); $form->addHtml("<div id=\"standard_form\">\n"); $form->addField("hidden", "stage", "", "1"); $form->addField("hidden", "action", "", "advanced_search"); $buttons = $form->makeField("submit", "", "", "Search", array('class' => 'submit')); $buttons .= $form->makeField("button", "", "", "Reset", array('class' => 'button', 'onClick' => 'javascript:location.href=\'' . $PHP_SELF . '\';')); $formName = 'form1'; $form->addHtml("<fieldset>\n"); $form->addHtml('<div class="block-header">Property Search</div>'); $form->addHtml('<div id="' . $formName . '">'); $form->addData($formData1, $_GET); $form->addHtml($form->addDiv($buttons)); $form->addHtml("</div>\n"); $form->addHtml("</fieldset>\n");
<tr> <td>Notes:</td> <td><textarea name="notes" style="width:200px;height:60px"></textarea></td> </tr> <tr> <td> </td> <td><input type="submit" value="Change Status"></td> </tr> </table> </form> </div>'; */ } else { // if form is submitted $result = new Validate(); $fields = join_arrays(array($formData1, $additional_fields)); #,$formData2 $results = $result->process($fields, $_GET); $db_data = $results['Results']; $redirect = $_SERVER['SCRIPT_NAME'] . '?dea_id=' . $dea_id; if ($return) { $redirect .= '&return=' . $return; } if ($results['Errors']) { if (is_array($results['Results'])) { $redirect .= '&' . http_build_query($results['Results']); } echo error_message($results['Errors'], urlencode($redirect)); exit; } #todo: check the new status hasnt already been set, check the status is valid
case 1: if (!$_GET["action"]) { /* if (!$_GET["date_from"]) { $_GET["date_from"] = date('d/m/Y'); //23/11/2006 } if (!$_GET["date_to"]) { $_GET["date_to"] = date('d/m/Y'); } */ if ($_GET["type"] == 'Note') { $notetype_display = ""; } else { $notetype_display = "none"; } $formData1 = array('keyword' => array('type' => 'text', 'label' => 'Keyword(s)', 'value' => $_GET["keyword"], 'attributes' => array('class' => 'addr'), 'tooltip' => 'Seperate multiple keywords with commas'), 'branch' => array('type' => 'select_branch_2', 'label' => 'Branch', 'value' => $_GET["branch"], 'attributes' => array('class' => 'medium')), 'user' => array('type' => 'select_user', 'label' => 'User', 'value' => $_GET["user"], 'attributes' => array('class' => 'medium'), 'tooltip' => 'Lead user only (does not include attendees)', 'options' => array('' => 'Any')), 'type' => array('type' => 'select', 'label' => 'Appointment Type', 'group' => 'Appointment Type', 'value' => $_GET["type"], 'options' => join_arrays(array(array('' => 'Any'), db_enum("appointment", "app_type", "array"))), 'attributes' => array('class' => 'medium', 'onChange' => 'controlAppointmentType(this,\'type\');')), 'notetype' => array('type' => 'select', 'label' => 'Sub-Type', 'group' => 'Appointment Type', 'last_in_group' => 1, 'value' => $_GET["notetype"], 'options' => db_enum("appointment", "app_notetype", "array"), 'attributes' => array('style' => 'display:' . $notetype_display)), 'date_from' => array('type' => 'datetime', 'label' => 'Date (from)', 'value' => $_GET["date_from"], 'attributes' => array('class' => 'medium')), 'date_to' => array('type' => 'datetime', 'label' => 'Date (to)', 'value' => $_GET["date_to"], 'attributes' => array('class' => 'medium')), 'status' => array('type' => 'select', 'label' => 'Status', 'value' => $_GET["status"], 'options' => db_enum("appointment", "app_status", "array"), 'attributes' => array('class' => 'medium'))); $form = new Form(); $form->addForm("", "GET", $PHP_SELF); $form->addHtml("<div id=\"standard_form\">\n"); $form->addField("hidden", "stage", "", "1"); $form->addField("hidden", "action", "", "advanced_search"); $formName = 'form1'; $form->addHtml("<fieldset>\n"); $form->addHtml('<div class="block-header">Search Calendar</div>'); $form->addHtml('<div id="' . $formName . '">'); $form->addData($formData1, $_GET); $form->addHtml($form->addDiv($form->makeField("submit", "", "", "Search", array('class' => 'submit')))); $form->addHtml("</div>\n"); $form->addHtml("</fieldset>\n"); if (!$_GET["viewForm"]) { $viewForm = 1;
$page->addBodyContent($navbar); $page->addBodyContent($form->renderForm()); $page->addBodyContent('</div>'); $page->display(); exit; } else { // if the form has been submitted // join up the arrays, depending on user selection $formData = join_arrays(array($formData0, $formData1)); if ($_GET["cli_sales"] == 'Yes') { $addFormData2 = array('cli_saleptype' => array('label' => 'Property Type', 'required' => 2, 'value' => array2string($_GET["cli_saleptype"], "|"))); $formData = join_arrays(array($formData, $formData2, $addFormData2)); } if ($_GET["cli_lettings"] == 'Yes') { $addFormData3 = array('cli_letptype' => array('label' => 'Property Type', 'required' => 2, 'value' => array2string($_GET["cli_letptype"], "|"))); $formData = join_arrays(array($formData, $formData3, $addFormData3)); } // new source if ($_GET["cli_source"] == "x") { if (!$_GET["sourceNew"]) { $errors[] = "Please enter a referer title or choose existing from the list"; echo error_message($errors); exit; } else { // check if it already exists... (not fail-safe, but worth a try) // lower case all, and remove space from both new and existing for comparison $sql_source_check = "SELECT sou_id FROM source\n\t\tWHERE sou_type = " . $_GET["cli_source1"] . " AND REPLACE(LOWER(sou_title),' ','') = '" . trim(strtolower(str_replace(" ", "", $_GET["sourceNew"]))) . "'"; $result_source_check = mysql_query($sql_source_check); if (mysql_num_rows($result_source_check)) { while ($row_source_check = mysql_fetch_array($result_source_check)) { $_GET["cli_source"] = $row_source_check["sou_id"];
// active clients cannot complete the questionaire if ($row["cli_status"] == 'Active') { header("Location:client_edit.php?cli_id=" . $row["cli_id"]); } foreach ($row as $key => $val) { ${$key} = $val; } } if ($tel) { $tel_numbers = explode("|", $tel); foreach ($tel_numbers as $tels) { $tel_detail = explode("~", $tels); $telephone[] = array('id' => $tel_detail[0], 'number' => $tel_detail[1], 'type' => $tel_detail[2], 'order' => $tel_detail[3]); } } $form1 = array('cli_salutation' => array('type' => 'select', 'group' => 'Full Name', 'label' => 'Salutation', 'value' => $cli_salutation, 'required' => 2, 'options' => join_arrays(array(array('' => ''), db_enum("client", "cli_salutation", "array"))), 'attributes' => array('style' => 'width:60px')), 'cli_fname' => array('type' => 'text', 'group' => 'Full Name', 'label' => 'Forename', 'value' => $cli_fname, 'init' => 'Forename(s)', 'required' => 2, 'attributes' => array('style' => 'width:100px', 'onFocus' => 'javascript:clearField(this,\'Forename(s)\')'), 'function' => 'format_name'), 'cli_sname' => array('type' => 'text', 'group' => 'Full Name', 'last_in_group' => 1, 'label' => 'Surname', 'value' => $cli_sname, 'init' => 'Surname', 'required' => 2, 'attributes' => array('style' => 'width:152px', 'onFocus' => 'javascript:clearField(this,\'Surname\')'), 'function' => 'format_name'), 'cli_tel' => array('type' => 'tel', 'label' => 'Telephone', 'value' => $telephone), 'cli_email' => array('type' => 'text', 'label' => 'Email', 'value' => $cli_email, 'required' => 3, 'attributes' => array('style' => 'width:320px', 'maxlength' => 255))); $form2 = array('pro_addr1' => array('type' => 'text', 'label' => 'House Number', 'value' => $pro_addr1, 'required' => 2, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_addr3' => array('type' => 'text', 'label' => 'Street', 'value' => $pro_addr3, 'required' => 2, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_addr5' => array('type' => 'text', 'label' => 'City or County', 'value' => $pro_addr5, 'required' => 2, 'attributes' => array('class' => 'addr'), 'function' => 'format_street'), 'pro_postcode' => array('type' => 'text', 'label' => 'Postcode', 'value' => $pro_postcode, 'required' => 2, 'attributes' => array('class' => 'pc', 'maxlength' => 9), 'function' => 'format_postcode')); $sql = "SELECT * FROM cstatus WHERE cst_scope = 'Sales'"; $q = $db->query($sql); while ($row = $q->fetchRow()) { if ($row["cst_id"] == $cli_salestatus) { $checked = ' checked="checked"'; } else { unset($checked); } $statusRender .= '<div style="overflow:auto;"> <label class="formLabel">' . $row["cst_title"] . '</label> <span class="required"> <input type="radio" name="cli_saleletstatus" value="' . $row["cst_id"] . '"' . $checked . ' /> </span>
$result = new Validate(); foreach ($_POST as $key => $val) { #$_POST[$key] = trim($val); } if ($_POST["form1"]) { $viewForm = 1; // extract notes from _POST and store in notes table if ($_POST["dea_notes_production"]) { $notes = $_POST["dea_notes_production"]; $db_data_note = array('not_blurb' => $notes, 'not_row' => $dea_id, 'not_type' => 'deal_production', 'not_user' => $_SESSION["auth"]["use_id"], 'not_date' => $date_mysql); db_query($db_data_note, "INSERT", "note", "not_id"); } unset($_POST["dea_notes_production"]); // add psubtype $addFormData1 = array('dea_psubtype' => array('label' => 'Property Type', 'required' => 2, 'value' => $_POST["dea_psubtype"])); $formData1 = join_arrays(array($formData1, $addFormData1)); #print_r($formData3); $results = $result->process($formData1, $_POST); $db_data = $results['Results']; // build return link $return = $_SERVER['SCRIPT_NAME'] . '?stage=1&dea_id=' . $dea_id . '&searchLink=' . $searchLink . '&viewForm=' . $viewForm . '&'; if ($results['Errors']) { if (is_array($results['Results'])) { $return .= http_build_query($results['Results']); } echo error_message($results['Errors'], urlencode($return)); exit; } $dea_id = db_query($db_data, "UPDATE", "deal", "dea_id", $dea_id); if ($_POST["pro_area"]) { db_query(array('pro_area' => $_POST["pro_area"]), "UPDATE", "property", "pro_id", $_POST["pro_id"]);