$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']); } echo error_message($results['Errors'], '?' . urlencode($return));
// if client has not default address, make the above property it $sql = "SELECT con_pro FROM contact WHERE con_id = '" . $_POST["con_id"] . "'"; $q = $db->query($sql); if (DB::isError($q)) { die("db error: " . $q->getMessage()); } while ($row = $q->fetchRow()) { if ($row["con_pro"] == 0) { $db_dataD["con_pro"] = $pro_id; db_query($db_dataD, "UPDATE", "contact", "con_id", $_POST["con_id"]); } } } else { // if the manual input form is used, put values into array and insert into property table // all manual entries are inserted with -1 as pcid, and should be checked by admin until a script does it automatically $results = $result->process($form2, $_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']) { if (is_array($results['Results'])) { $redirect .= '&' . http_build_query($results['Results']);
$page->addScriptDeclaration($source['js']); $page->setBodyAttributes(array('onLoad' => $source['onload'])); $page->addBodyContent('<div id="content">'); $page->addBodyContent($menu); $page->addBodyContent('<p><a href="image.php?dir_id=' . $dir_id . '">Images</a></p>'); $page->addBodyContent($form->renderForm()); $page->addBodyContent('</div>'); $page->display(); exit; } else { // if the form has been submitted $result = new Validate(); $results = $result->process($formData1, $_POST); $db_data = $results['Results']; $result2 = new Validate(); $results2 = $result2->process($formData2, $_POST); $db_data2 = $results2['Results']; // build return link $return = $_SERVER['SCRIPT_NAME'] . '?'; if ($cli_id) { $results['Results']['dir_id'] = $dir_id; } if ($viewForm) { $results['Results']['viewForm'] = $viewForm; } if (is_array($results['Results'])) { $return .= http_build_query($results['Results']); } if ($results['Errors']) { echo error_message($results['Errors'], urlencode($return)); exit;
$page->addBodyContent($form2->renderForm()); $page->addBodyContent('</div>'); $page->display(); exit; } else { // if form is submitted // build return link $return = $_SERVER['SCRIPT_NAME'] . '?stage=2&dest=' . $_POST["dest"] . '&'; // if phone number is supplied, remove from initial db_data array if (phone_validate($_POST["telnew"])) { unset($formData1["cli_tel"]); } $return .= "telnew=" . $_POST["telnew"] . "&dea_id={$dea_id}&"; // validate first form $result = new Validate(); $results = $result->process($formData1, $_POST); $db_data = $results['Results']; //print_r($results); if (is_array($results['Results'])) { $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"] . "&";
$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"]; $db_data["off_date"] = $date_mysql;
$page->addScript('js/scriptaculous/prototype.js'); $page->addScript('js/scriptaculous/scriptaculous.js'); $page->addScriptDeclaration($additional_js); $page->setBodyAttributes(array('onLoad' => $onLoad)); $page->addBodyContent($header_and_menu); $page->addBodyContent('<div id="content">'); $page->addBodyContent($navbar); $page->addBodyContent($form->renderForm()); $page->addBodyContent('</div>'); $page->display(); exit; } else { // if form is submitted // validate and insert first form, get cli_id before adding property data (this may mean we lose address) $result = new Validate(); $results = $result->process($form1, $_POST); $db_data = $results['Results']; // build return link $redirect = $_SERVER['SCRIPT_NAME'] . '?stage=3&'; if ($use_id) { $redirect .= 'use_id=' . $use_id; } if ($viewForm) { $redirect .= '&viewForm=' . $viewForm; } if ($searchLink) { $redirect .= '&searchLink=' . urlencode($searchLink); } if ($results['Errors']) { if (is_array($results['Results'])) { $redirect .= '&' . http_build_query($results['Results']);
$page->addStyleSheet(getDefaultCss()); $page->addScript('js/global.js'); $page->addBodyContent($header_and_menu); $page->addBodyContent('<div id="content">'); $page->addBodyContent($navbar); $page->addBodyContent($form->renderForm()); $page->addBodyContent('</div>'); $page->display(); exit; } else { if ($_POST["med_measurement"] == "feet") { $_POST["med_dims"] = ft2mtr($_POST["med_dims"]); } unset($_POST["med_measurement"]); $result = new Validate(); $results = $result->process($formData, $_POST); $db_data = $results['Results']; if ($results['Errors']) { if (is_array($results['Results'])) { $return .= http_build_query($results['Results']); } echo error_message($results['Errors'], urlencode($return)); exit; } $med_id = db_query($db_data, "UPDATE", "media", "med_id", $med_id); #header("Location:".urldecode($_POST["searchLink"])); if ($_POST["searchLink"]) { $tmpurl = $_POST["searchLink"]; } else { $tmpurl = $_GET["searchLink"]; }
#$_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"]); } } elseif ($_POST["form2"]) {
// build return link $return = $_SERVER['SCRIPT_NAME'] . '?'; if ($dir_id) { $results['Results']['dir_id'] = $dir_id; } if (is_array($results['Results'])) { $return .= http_build_query($results['Results']); } if ($results['Errors']) { echo error_message($results['Errors'], urlencode($return)); exit; } # add address manually, if postcode lookup is not used if (!$pro_pro_id) { $result2 = new Validate(); $results2 = $result2->process($formData2, $_GET); $db_data2 = $results2['Results']; $db_data2["pro_pcid"] = '-1'; $pro_pro_id = db_query($db_data2, "INSERT", "property", "pro_id"); } # add any additional fields to data array $db_data['dir_created'] = $date_mysql; $db_data['dir_pro'] = $pro_pro_id; $dir_id = db_query($db_data, "INSERT", "directory", "dir_id"); header("Location:index.php"); exit; } break; ########################################################### # default ###########################################################