$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"]);
