function con_data($_POST) { # get vars extract($_POST); # validate input require_lib("validate"); $v = new validate(); $v->isOk($surname, "string", 1, 100, "Last name"); $v->isOk($name, "string", 0, 100, "First name"); $v->isOk($reports_to, "string", 0, 100, "Reports to"); $v->isOk($reports_to_id, "num", 0, 9, "Reports to ID (hidden)"); $v->isOk($lead_source, "string", 0, 100, "Lead Source"); $v->isOk($title, "string", 0, 100, "Title"); $v->isOk($department, "string", 0, 100, "Department"); $v->isOk($tell, "string", 0, 100, "Home Phone"); $v->isOk($cell, "string", 0, 100, "Mobile Phone"); $v->isOk($fax, "string", 0, 100, "Fax"); $v->isOk($tell_office, "string", 0, 100, "Office Phone"); $v->isOk($tell_other, "string", 0, 100, "Other Phone"); $v->isOk($email, "string", 0, 100, "Email"); $v->isOk($email_other, "string", 0, 100, "Other Email"); $v->isOk($assistant, "string", 0, 100, "Assistant"); $v->isOk($assistant_phone, "string", 0, 100, "Assistant Phone"); $v->isOk($team_id, "num", 1, 9, "Team."); $birthdate = "{$bf_year}-{$bf_month}-{$bf_day}"; if ($v->isOk($birthdate, "string", 1, 100, "Birthdate")) { if (!checkdate($bf_month, $bf_day, $bf_year)) { $v->addError("_OTHER", "Invalid birthdate. No such date exists."); } } $birthdate_description = date("d F Y", mktime(0, 0, 0, $bf_day, $bf_month, $bf_year)); # display errors, if any if ($v->isError()) { $err = "The following field value errors occured:<br>"; $errors = $v->getErrors(); foreach ($errors as $e) { if ($e["value"] == "_OTHER") { $err .= "<li class='err'>{$e['msg']}</li>"; } else { $err .= "<li class='err'>Invalid characters: {$e['msg']}</li>"; } } return get_data($err); } db_connect(); $lastid = pglib_lastid("customers", "cusnum"); # Get last account number $sql = "SELECT accno FROM customers WHERE cusnum = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { do { $lastid--; # get last account number $sql = "SELECT accno FROM customers WHERE cusnum = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { $accno = ""; $naccno = ""; } else { $acc = pg_fetch_array($accRslt); $accno = $acc['accno']; } } while (strlen($accno) < 1 && $lastid > 1); } else { $acc = pg_fetch_array($accRslt); $accno = $acc['accno']; } # Check if we got $accno(if not skip this) if (strlen($accno) > 0) { // get the next account number $num = preg_replace("/[^\\d]+/", "", $accno); $num++; $chars = preg_replace("/[\\d]/", "", $accno); $naccno = $chars . $num; } db_connect(); $lastid = pglib_lastid("suppliers", "supid"); # get last account number $sql = "SELECT supno FROM suppliers WHERE supid = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { do { $lastid--; # get last account number $sql = "SELECT supno FROM suppliers WHERE supid = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { $supno = ""; $nsupno = ""; } else { $acc = pg_fetch_array($accRslt); $supno = $acc['supno']; } } while (strlen($supno) < 1 && $lastid > 1); } else { $acc = pg_fetch_array($accRslt); $supno = $acc['supno']; } # Check if we got $supno(if not skip this) if (strlen($supno) > 0) { # Get the next account number $num = preg_replace("/[^\\d]+/", "", $supno); $num++; $chars = preg_replace("/[\\d]/", "", $supno); $nsupno = $chars . $num; } if (isset($cust)) { $custext = "\n\t\t<tr>\n\t\t\t<th colspan=2>Customer Details</th>\n\t\t</tr>\n\t\t<tr class='odd'>\n\t\t\t<td>Acc No</td>\n\t\t\t<td><input type='text' size='20' name='cusacc' value='{$naccno}'></td>\n\t\t</tr>"; } else { $custext = ""; } if (isset($supp)) { $suptext = "\n\t\t<tr>\n\t\t\t<th colspan='2'>Supplier Details</th>\n\t\t</tr>\n\t\t<tr class='odd'>\n\t\t\t<td>Sup No</td>\n\t\t\t<td><input type='text' size='20' name='supacc' value='{$nsupno}'></td>\n\t\t</tr>"; } else { $suptext = ""; } if (!empty($custext) || !empty($suptext)) { $account_id = 0; $accountname = "\n\t\t\t<table width='100%' cellpadding='0' cellspacing='0'>\n\t\t\t\t<td>{$custext} {$suptext}</td>\n\t\t\t</table>"; } if (isset($crm)) { $ex = "<input type='hidden' name='crm' value=''>"; } else { $ex = ""; } if ($upload_img == "yes") { $upload_box = "\n\t\t\t<td>Contact Image</td>\n\t\t\t<td><input type='file' name='img_file' /></td>"; } else { $upload_box = "<td colspan='2'> </td>"; } // Retrieve the team name if ($team_id) { $sql = "SELECT name FROM crm.teams WHERE id='{$team_id}'"; $team_rslt = db_exec($sql) or errDie("Unable to retrieve team name."); $team_name = pg_fetch_result($team_rslt, 0); } else { $team_name = "[None]"; } $con_data = "\n\t\t<h3>Confirm contact details</h3>\n\t\t<table cellpadding='2' cellspacing='0' class='shtable'>\n\t\t<form action='" . SELF . "' method='POST' enctype='multipart/form-data'>\n\t\t\t<input type='hidden' name='key' value='write'>\n\t\t\t<input type='hidden' name='surname' value='{$surname}'>\n\t\t\t<input type='hidden' name='name' value='{$name}'>\n\t\t\t<input type='hidden' name='account_id' value='{$account_id}'>\n\t\t\t<input type='hidden' name='account_type' value='{$account_type}'>\n\t\t\t<input type='hidden' name='lead_source' value='{$lead_source}'>\n\t\t\t<input type='hidden' name='title' value='{$title}'>\n\t\t\t<input type='hidden' name='department' value='{$department}'>\n\t\t\t<input type='hidden' name='bf_day' value='{$bf_day}'>\n\t\t\t<input type='hidden' name='bf_month' value='{$bf_month}'>\n\t\t\t<input type='hidden' name='bf_year' value='{$bf_year}'>\n\t\t\t<input type='hidden' name='reports_to_id' value='{$reports_to_id}'>\n\t\t\t<input type='hidden' name='reports_to' value='{$reports_to}'>\n\t\t\t<input type='hidden' name='tell' value='{$tell}'>\n\t\t\t<input type='hidden' name='cell' value='{$cell}'>\n\t\t\t<input type='hidden' name='fax' value='{$fax}'>\n\t\t\t<input type='hidden' name='tell_office' value='{$tell_office}'>\n\t\t\t<input type='hidden' name='tell_other' value='{$tell_other}'>\n\t\t\t<input type='hidden' name='email' value='{$email}'>\n\t\t\t<input type='hidden' name='email_other' value='{$email_other}'>\n\t\t\t<input type='hidden' name='assistant' value='{$assistant}'>\n\t\t\t<input type='hidden' name='assistant_phone' value='{$assistant_phone}'>\n\t\t\t<input type='hidden' name='padd' value='{$padd}'>\n\t\t\t<input type='hidden' name='padd_city' value='{$padd_city}'>\n\t\t\t<input type='hidden' name='padd_state' value='{$padd_state}'>\n\t\t\t<input type='hidden' name='padd_code' value='{$padd_code}'>\n\t\t\t<input type='hidden' name='padd_country' value='{$padd_country}'>\n\t\t\t<input type='hidden' name='hadd' value='{$hadd}'>\n\t\t\t<input type='hidden' name='hadd_city' value='{$hadd_city}'>\n\t\t\t<input type='hidden' name='hadd_state' value='{$hadd_state}'>\n\t\t\t<input type='hidden' name='hadd_code' value='{$hadd_code}'>\n\t\t\t<input type='hidden' name='hadd_country' value='{$hadd_country}'>\n\t\t\t<input type='hidden' name='description' value='{$description}'>\n\t\t\t<input type='hidden' name='Con' value='{$Con}'>\n\t\t\t<input type='hidden' name='upload_img' value='{$upload_img}' />\n\t\t\t<input type='hidden' name='team_id' value='{$team_id}' />\n\t\t\t<input type='hidden' name='type' value='{$type}'>\n\t\t\t<input type='hidden' name='supid' value='{$supid}'>\n\t\t\t<input type='hidden' name='cusnum' value='{$cusnum}'>\n\t\t\t{$ex}\n\t\t\t<tr>\n\t\t\t\t<th colspan='4'>Contact Information</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td width='120'>First Name</td>\n\t\t\t\t<td width='210'>{$name}</td>\n\t\t\t\t<td width='120'>Office Phone</td>\n\t\t\t\t<td width='210'>{$tell_office}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Company/Last Name</td>\n\t\t\t\t<td>{$surname}</td>\n\t\t\t\t<td>Mobile</td>\n\t\t\t\t<td>{$cell}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Reports To</td>\n\t\t\t\t<td>{$reports_to}</td>\n\t\t\t\t<td>Home Phone</td>\n\t\t\t\t<td>{$tell}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Lead Source</td>\n\t\t\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\n\t\t\t\t<td>Other Phone</td>\n\t\t\t\t<td>{$tell_other}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Title</td>\n\t\t\t\t<td>{$title}</td>\n\t\t\t\t<td>Fax</td>\n\t\t\t\t<td>{$fax}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Department</td>\n\t\t\t\t<td>{$department}</td>\n\t\t\t\t<td>E-mail</td>\n\t\t\t\t<td>{$email}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Birthdate</td>\n\t\t\t\t<td>{$birthdate_description}</td>\n\t\t\t\t<td>Other E-mail</td>\n\t\t\t\t<td>{$email_other}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td rowspan='2'></td>\n\t\t\t\t<td rowspan='2'></td>\n\t\t\t\t<td>Assistant</td>\n\t\t\t\t<td>{$assistant}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Assistant Phone</td>\n\t\t\t\t<td>{$assistant_phone}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t{$upload_box}\n\t\t\t\t<td>Team Permissions</td>\n\t\t\t\t<td>{$team_name}</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<p></p>\n\t\t<table cellpadding='2' cellspacing='0' class='shtable'>\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Physical Address</th>\n\t\t\t\t<th colspan='2'>Postal Address</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='2' align='left' valign='top'><xmp>{$hadd}</xmp></td>\n\t\t\t\t<td colspan='2' align='left'><xmp>{$padd}</xmp></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>City</td>\n\t\t\t\t<td>{$padd_city}</td>\n\t\t\t\t<td>City</td>\n\t\t\t\t<td>{$hadd_city}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>State/Province</td>\n\t\t\t\t<td>{$padd_state}</td>\n\t\t\t\t<td>State/Province</td>\n\t\t\t\t<td>{$hadd_state}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Postal Code</td>\n\t\t\t\t<td>{$padd_code}</td>\n\t\t\t\t<td>Postal Code</td>\n\t\t\t\t<td>{$hadd_code}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Country</td>\n\t\t\t\t<td>{$padd_country}</td>\n\t\t\t\t<td>Country</td>\n\t\t\t\t<td>{$hadd_country}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Description</th>\n\t\t\t\t<th colspan='2'>Options</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='2' align='left'><xmp>{$description}</xmp></td>\n\t\t\t\t<td>Private</td>\n\t\t\t\t<td align='center'>{$Con}</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<p></p>\n\t\t\t<input type='submit' name='back' value='« Correction'>\n\t\t\t<input type='submit' value='Write »'>\n\t\t</form>\n\t\t<p></p>\n\t\t<table cellpadding='2' cellspacing='0' class='shtable'>\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='list_cons.php'>List contacts</a></td>\n\t\t\t</tr>\n\t\t</table>"; return $con_data; }
function con_data($_POST) { # get vars extract($_POST); # validate input require_lib("validate"); $v = new validate(); $v->isOk($id, "num", 1, 9, "ID Field (hidden)"); $v->isOk($surname, "string", 1, 100, "Last name"); $v->isOk($name, "string", 0, 100, "First name"); $v->isOk($accountname, "string", 0, 100, "Account"); $v->isOk($account_id, "num", 0, 9, "Account ID (hidden)"); $v->isOk($account_type, "string", 0, 100, "Account type (hidden)"); $v->isOk($lead_source, "string", 0, 100, "Lead Source"); $v->isOk($title, "string", 0, 100, "Title"); $v->isOk($department, "string", 0, 100, "Department"); $v->isOk($tell, "string", 0, 100, "Home Phone"); $v->isOk($cell, "string", 0, 100, "Mobile Phone"); $v->isOk($fax, "string", 0, 100, "Fax"); $v->isOk($tell_office, "string", 0, 100, "Office Phone"); $v->isOk($tell_other, "string", 0, 100, "Other Phone"); $v->isOk($email, "string", 0, 100, "Email"); $v->isOk($email_other, "string", 0, 100, "Other Email"); $v->isOk($assistant, "string", 0, 100, "Assistant"); $v->isOk($assistant_phone, "string", 0, 100, "Assistant Phone"); $v->isOk($padd, "string", 0, 250, "Physical Address"); $v->isOk($padd_city, "string", 0, 100, "Physical Address: City"); $v->isOk($padd_state, "string", 0, 100, "Physical Address: State/Province"); $v->isOk($padd_code, "string", 0, 100, "Physical Address: Postal Code"); $v->isOk($padd_country, "string", 0, 100, "Physical Address: Country"); $v->isOk($hadd, "string", 0, 250, "Postal Address"); $v->isOk($hadd_city, "string", 0, 100, "Postal Address: City"); $v->isOk($hadd_state, "string", 0, 100, "Postal Address: State/Province"); $v->isOk($hadd_code, "string", 0, 100, "Postal Address: Postal Code"); $v->isOk($hadd_country, "string", 0, 100, "Postal Address: Country"); $v->isOk($description, "string", 0, 100, "Description"); $v->isOk($website, "string", 0, 255, "Website"); $v->isOk($religion, "string", 0, 100, "Religion"); $v->isOk($race, "string", 0, 100, "Race"); $v->isOk($gender, "string", 0, 6, "Gender"); $v->isOk($Con, "string", 2, 3, "Invalid private."); $v->isOk($salespn, "num", 1, 9, "Sales person."); $v->isOk($team_id, "num", 1, 9, "Team"); if (!empty($ncdate_day) || !empty($ncdate_month) || !empty($ncdate_year)) { $v->isOk($ncdate_day, "num", 1, 2, "Next contact date (Day)"); $v->isOk($ncdate_month, "num", 1, 2, "Next contact date (Month)"); $v->isOk($ncdate_year, "num", 4, 4, "Next contact date (Year)"); $ncdate = "{$ncdate_day}-{$ncdate_month}-{$ncdate_year}"; } else { $ncdate = ""; } $birthdate = "{$bf_year}-{$bf_month}-{$bf_day}"; if ($v->isOk($birthdate, "string", 1, 100, "Birthdate")) { if (!checkdate($bf_month, $bf_day, $bf_year)) { $v->addError("_OTHER", "Invalid birthdate. No such date exists."); } } $birthdate_description = date("d F Y", mktime(0, 0, 0, $bf_day, $bf_month, $bf_year)); # display errors, if any if ($v->isError()) { $errors = $v->getErrors(); foreach ($errors as $e) { if ($e["value"] == "_OTHER") { $err .= "<li class='err'>{$e['msg']}</li>"; } else { $err .= "<li class=err>Invalid characters: {$e['msg']}</li>"; } } return get_data($_POST, $err); } db_conn("exten"); $sql = "SELECT salesp FROM salespeople WHERE salespid='{$salespn}'"; $rslt = db_exec($sql) or errDie("Unable to retieve sales person from Cubit."); $salespn_out = pg_fetch_result($rslt, 0); // Retrieve team name $sql = "SELECT name FROM crm.teams WHERE id='{$team_id}'"; $team_rslt = db_exec($sql) or errDie("Unable to retrieve teams."); $team_name = pg_fetch_result($team_rslt, 0); $con_data = "\r\n\t\t<h3>Confirm lead details</h3>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t<form action='" . SELF . "' method='POST'>\r\n\t\t\t<input type='hidden' name='key' value='write'>\r\n\t\t\t<input type='hidden' name=id value='{$id}'>\r\n\t\t\t<input type='hidden' name='surname' value='{$surname}'>\r\n\t\t\t<input type='hidden' name='name' value='{$name}'>\r\n\t\t\t<input type='hidden' name='account_id' value='{$account_id}'>\r\n\t\t\t<input type='hidden' name='account_type' value='{$account_type}'>\r\n\t\t\t<input type='hidden' name='lead_source' value='{$lead_source}'>\r\n\t\t\t<input type='hidden' name='title' value='{$title}'>\r\n\t\t\t<input type='hidden' name='department' value='{$department}'>\r\n\t\t\t<input type='hidden' name='bf_day' value='{$bf_day}'>\r\n\t\t\t<input type='hidden' name='bf_month' value='{$bf_month}'>\r\n\t\t\t<input type='hidden' name='bf_year' value='{$bf_year}'>\r\n\t\t\t<input type='hidden' name='tell' value='{$tell}'>\r\n\t\t\t<input type='hidden' name='cell' value='{$cell}'>\r\n\t\t\t<input type='hidden' name='fax' value='{$fax}'>\r\n\t\t\t<input type='hidden' name='tell_office' value='{$tell_office}'>\r\n\t\t\t<input type='hidden' name='tell_other' value='{$tell_other}'>\r\n\t\t\t<input type='hidden' name='email' value='{$email}'>\r\n\t\t\t<input type='hidden' name='email_other' value='{$email_other}'>\r\n\t\t\t<input type='hidden' name='assistant' value='{$assistant}'>\r\n\t\t\t<input type='hidden' name='assistant_phone' value='{$assistant_phone}'>\r\n\t\t\t<input type='hidden' name='padd' value='{$padd}'>\r\n\t\t\t<input type='hidden' name='padd_city' value='{$padd_city}'>\r\n\t\t\t<input type='hidden' name='padd_state' value='{$padd_state}'>\r\n\t\t\t<input type='hidden' name='padd_code' value='{$padd_code}'>\r\n\t\t\t<input type='hidden' name='padd_country' value='{$padd_country}'>\r\n\t\t\t<input type='hidden' name='hadd' value='{$hadd}'>\r\n\t\t\t<input type='hidden' name='hadd_city' value='{$hadd_city}'>\r\n\t\t\t<input type='hidden' name='hadd_state' value='{$hadd_state}'>\r\n\t\t\t<input type='hidden' name='hadd_code' value='{$hadd_code}'>\r\n\t\t\t<input type='hidden' name='hadd_country' value='{$hadd_country}'>\r\n\t\t\t<input type='hidden' name='description' value='{$description}'>\r\n\t\t\t<input type='hidden' name='website' value='{$website}'>\r\n\t\t\t<input type='hidden' name='religion' value='{$religion}'>\r\n\t\t\t<input type='hidden' name='race' value='{$race}'>\r\n\t\t\t<input type='hidden' name='gender' value='{$gender}'>\r\n\t\t\t<input type='hidden' name='Con' value='{$Con}'>\r\n\t\t\t<input type='hidden' name='salespn' value='{$salespn}'>\r\n\t\t\t<input type='hidden' name='ncdate_day' value='{$ncdate_day}'>\r\n\t\t\t<input type='hidden' name='ncdate_month' value='{$ncdate_month}'>\r\n\t\t\t<input type='hidden' name='ncdate_year' value='{$ncdate_year}'>\r\n\t\t\t<input type='hidden' name='team_id' value='{$team_id}' />\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='4'>Lead Information</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td width='120'>First Name</td>\r\n\t\t\t\t<td width='210'>{$name}</td>\r\n\t\t\t\t<td width='120'>Office Phone</td>\r\n\t\t\t\t<td width='210'>{$tell_office}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Company/Last Name</td>\r\n\t\t\t\t<td>{$surname}</td>\r\n\t\t\t\t<td>Mobile</td>\r\n\t\t\t\t<td>{$cell}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Account Name</td>\r\n\t\t\t\t<td>{$accountname}</td>\r\n\t\t\t\t<td>Home Phone</td>\r\n\t\t\t\t<td>{$tell}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Lead Source</td>\r\n\t\t\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\r\n\t\t\t\t<td>Other Phone</td>\r\n\t\t\t\t<td>{$tell_other}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Title</td>\r\n\t\t\t\t<td>{$title}</td>\r\n\t\t\t\t<td>Fax</td>\r\n\t\t\t\t<td>{$fax}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Department</td>\r\n\t\t\t\t<td>{$department}</td>\r\n\t\t\t\t<td>E-mail</td>\r\n\t\t\t\t<td>{$email}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Birthdate</td>\r\n\t\t\t\t<td>{$birthdate_description}</td>\r\n\t\t\t\t<td>Other E-mail</td>\r\n\t\t\t\t<td>{$email_other}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Reports To</td>\r\n\t\t\t\t<td>{$reports_to}</td>\r\n\t\t\t\t<td>Assistant</td>\r\n\t\t\t\t<td>{$assistant}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Team Permissions</td>\r\n\t\t\t\t<td>{$team_name}</td>\r\n\t\t\t\t<td>Assistant Phone</td>\r\n\t\t\t\t<td>{$assistant_phone}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Religion</td>\r\n\t\t\t\t<td>{$religion}</td>\r\n\t\t\t\t<td>Website</td>\r\n\t\t\t\t<td>{$website}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Race</td>\r\n\t\t\t\t<td>{$race}</td>\r\n\t\t\t\t<td>Next Contact Date</td>\r\n\t\t\t\t<td>{$ncdate}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Gender</td>\r\n\t\t\t\t<td>{$gender}</td>\r\n\t\t\t\t<td>Sales Person</td>\r\n\t\t\t\t<td>{$salespn_out}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Physical Address</th>\r\n\t\t\t\t<th colspan='2'>Postal Address</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='2' align='left' valign='top'><xmp>{$hadd}</xmp></td>\r\n\t\t\t\t<td colspan='2' align='left'><xmp>{$padd}</xmp></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>City</td>\r\n\t\t\t\t<td>{$padd_city}</td>\r\n\t\t\t\t<td>City</td>\r\n\t\t\t\t<td>{$hadd_city}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>State/Province</td>\r\n\t\t\t\t<td>{$padd_state}</td>\r\n\t\t\t\t<td>State/Province</td>\r\n\t\t\t\t<td>{$hadd_state}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Postal Code</td>\r\n\t\t\t\t<td>{$padd_code}</td>\r\n\t\t\t\t<td>Postal Code</td>\r\n\t\t\t\t<td>{$hadd_code}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Country</td>\r\n\t\t\t\t<td>{$padd_country}</td>\r\n\t\t\t\t<td>Country</td>\r\n\t\t\t\t<td>{$hadd_country}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Description</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='2' align='left'><xmp>{$description}</xmp></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Options</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Private</td>\r\n\t\t\t\t<td align='center'>{$Con}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Write »'></td>\r\n\t\t\t</tr>\r\n\t\t</form>\r\n\t\t</table>\r\n\t\t<p>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t<tr>\r\n\t\t\t\t<th>Quick Links</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><a href='leads_list.php'>List leads</a></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\r\n\t\t\t</tr>\r\n\t\t</table>"; return $con_data; }
function con_data($_POST) { # get vars extract($_POST); # validate input require_lib("validate"); $v = new validate(); $v->isOk($surname, "string", 1, 100, "Last name"); $v->isOk($name, "string", 0, 100, "First name"); $v->isOk($accountname, "string", 0, 100, "Account"); $v->isOk($account_id, "num", 0, 9, "Account ID (hidden)"); $v->isOk($account_type, "string", 0, 100, "Account type (hidden)"); $v->isOk($lead_source, "string", 0, 100, "Lead Source"); $v->isOk($title, "string", 0, 100, "Title"); $v->isOk($department, "string", 0, 100, "Department"); $v->isOk($tell, "string", 0, 100, "Home Phone"); $v->isOk($cell, "string", 0, 100, "Mobile Phone"); $v->isOk($fax, "string", 0, 100, "Fax"); $v->isOk($tell_office, "string", 0, 100, "Office Phone"); $v->isOk($tell_other, "string", 0, 100, "Other Phone"); $v->isOk($email, "string", 0, 100, "Email"); $v->isOk($email_other, "string", 0, 100, "Other Email"); $v->isOk($assistant, "string", 0, 100, "Assistant"); $v->isOk($assistant_phone, "string", 0, 100, "Assistant Phone"); $v->isOk($padd, "string", 0, 250, "Physical Address"); $v->isOk($padd_city, "string", 0, 100, "Physical Address: City"); $v->isOk($padd_state, "string", 0, 100, "Physical Address: State/Province"); $v->isOk($padd_code, "string", 0, 100, "Physical Address: Postal Code"); $v->isOk($padd_country, "string", 0, 100, "Physical Address: Country"); $v->isOk($hadd, "string", 0, 250, "Postal Address"); $v->isOk($hadd_city, "string", 0, 100, "Postal Address: City"); $v->isOk($hadd_state, "string", 0, 100, "Postal Address: State/Province"); $v->isOk($hadd_code, "string", 0, 100, "Postal Address: Postal Code"); $v->isOk($hadd_country, "string", 0, 100, "Postal Address: Country"); $v->isOk($description, "string", 0, 100, "Description"); $v->isOk($website, "string", 0, 255, "Website"); $v->isOk($religion, "string", 0, 100, "Religion"); $v->isOk($race, "string", 0, 100, "Race"); $v->isOk($gender, "string", 0, 6, "Gender"); $v->isOk($Con, "string", 2, 3, "Invalid private."); $v->isOk($salespn, "num", 1, 9, "Sales person."); $v->isOk($team_id, "num", 1, 9, "Team"); if (!empty($ncdate_day) || !empty($ncdate_month) || !empty($ncdate_year)) { $v->isOk($ncdate_day, "num", 1, 2, "Next contact date (Day)"); $v->isOk($ncdate_month, "num", 1, 2, "Next contact day (Month)"); $v->isOk($ncdate_year, "num", 4, 4, "Next contact day (Year)"); $ncdate = "{$ncdate_day}-{$ncdate_month}-{$ncdate_year}"; } else { $ncdate = ""; } $birthdate = "{$bf_year}-{$bf_month}-{$bf_day}"; if ($v->isOk($birthdate, "string", 1, 100, "Birthdate")) { if (!checkdate($bf_month, $bf_day, $bf_year)) { $v->addError("_OTHER", "Invalid birthdate. No such date exists."); } } $birthdate_description = date("d F Y", mktime(0, 0, 0, $bf_month, $bf_day, $bf_year)); # display errors, if any if ($v->isError()) { $errors = $v->getErrors(); foreach ($errors as $e) { if ($e["value"] == "_OTHER") { $err .= "<li class='err'>{$e['msg']}</li>"; } else { $err .= "<li class='err'>Invalid characters: {$e['msg']}</li>"; } } return get_data($err); } db_connect(); $lastid = pglib_lastid("customers", "cusnum"); # Get last account number $sql = "SELECT accno FROM customers WHERE cusnum = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { do { $lastid--; # get last account number $sql = "SELECT accno FROM customers WHERE cusnum = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { $accno = ""; $naccno = ""; } else { $acc = pg_fetch_array($accRslt); $accno = $acc['accno']; } } while (strlen($accno) < 1 && $lastid > 1); } else { $acc = pg_fetch_array($accRslt); $accno = $acc['accno']; } # Check if we got $accno(if not skip this) if (strlen($accno) > 0) { // get the next account number $num = preg_replace("/[^\\d]+/", "", $accno); $num++; $chars = preg_replace("/[\\d]/", "", $accno); $naccno = $chars . $num; } db_connect(); $lastid = pglib_lastid("suppliers", "supid"); # get last account number $sql = "SELECT supno FROM suppliers WHERE supid = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { do { $lastid--; # get last account number $sql = "SELECT supno FROM suppliers WHERE supid = '{$lastid}' AND div = '" . USER_DIV . "'"; $accRslt = db_exec($sql); if (pg_numrows($accRslt) < 1) { $supno = ""; $nsupno = ""; } else { $acc = pg_fetch_array($accRslt); $supno = $acc['supno']; } } while (strlen($supno) < 1 && $lastid > 1); } else { $acc = pg_fetch_array($accRslt); $supno = $acc['supno']; } # Check if we got $supno(if not skip this) if (strlen($supno) > 0) { # Get the next account number $num = preg_replace("/[^\\d]+/", "", $supno); $num++; $chars = preg_replace("/[\\d]/", "", $supno); $nsupno = $chars . $num; } // Retrieve the sales person db_conn("exten"); $sql = "SELECT salesp FROM salespeople WHERE salespid='{$salespn}'"; $rslt = db_exec($sql) or errDie("Unable to retrieve sales person from Cubit."); $salespn_out = pg_fetch_result($rslt, 0); if (isset($cust)) { $custext = "\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Customer Details</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Acc No</td>\r\n\t\t\t\t<td><input type='text' size='20' name='cusacc' value='{$naccno}'></td>\r\n\t\t\t</tr>"; } else { $custext = ""; } if (isset($supp)) { $suptext = "\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Supplier Details</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Sup No</td>\r\n\t\t\t\t<td><input type='text' size='20' name='supacc' value='{$nsupno}'></td>\r\n\t\t\t</tr>"; } else { $suptext = ""; } if (!empty($custext) || !empty($suptext)) { $account_id = 0; $displayaccountname = "\r\n\t\t\t<table width='100%' cellpadding='0' cellspacing='0'>\r\n\t\t\t\t<td>{$custext} {$suptext}</td>\r\n\t\t\t</table>"; } if (isset($crm)) { $ex = "<input type='hidden' name='crm' value=''>"; } else { $ex = ""; } // Retrieve the team name if ($team_id) { $sql = "SELECT name FROM crm.teams WHERE id='{$team_id}'"; $team_rslt = db_exec($sql) or errDie("Unable to retrieve team name."); $team_name = pg_fetch_result($team_rslt, 0); } else { $team_name = "[None]"; } // <input type='hidden' name='accountname' value='$accountname'> $con_data = "\r\n\t\t<h3>Confirm lead details</h3>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t<form action='" . SELF . "' method='POST'>\r\n\t\t\t<input type='hidden' name='key' value='write'>\r\n\t\t\t<input type='hidden' name='surname' value='{$surname}'>\r\n\t\t\t<input type='hidden' name='name' value='{$name}'>\r\n\t\t\t<input type='hidden' name='account_id' value='{$account_id}'>\r\n\t\t\t<input type='hidden' name='accountname' value='{$accountname}'>\r\n\t\t\t<input type='hidden' name='account_type' value='{$account_type}'>\r\n\t\t\t<input type='hidden' name='lead_source' value='{$lead_source}'>\r\n\t\t\t<input type='hidden' name='title' value='{$title}'>\r\n\t\t\t<input type='hidden' name='department' value='{$department}'>\r\n\t\t\t<input type='hidden' name='bf_day' value='{$bf_day}'>\r\n\t\t\t<input type='hidden' name='bf_month' value='{$bf_month}'>\r\n\t\t\t<input type='hidden' name='bf_year' value='{$bf_year}'>\r\n\t\t\t<input type='hidden' name='tell' value='{$tell}'>\r\n\t\t\t<input type='hidden' name='cell' value='{$cell}'>\r\n\t\t\t<input type='hidden' name='fax' value='{$fax}'>\r\n\t\t\t<input type='hidden' name='tell_office' value='{$tell_office}'>\r\n\t\t\t<input type='hidden' name='tell_other' value='{$tell_other}'>\r\n\t\t\t<input type='hidden' name='email' value='{$email}'>\r\n\t\t\t<input type='hidden' name='email_other' value='{$email_other}'>\r\n\t\t\t<input type='hidden' name='assistant' value='{$assistant}'>\r\n\t\t\t<input type='hidden' name='assistant_phone' value='{$assistant_phone}'>\r\n\t\t\t<input type='hidden' name='padd' value='{$padd}'>\r\n\t\t\t<input type='hidden' name='padd_city' value='{$padd_city}'>\r\n\t\t\t<input type='hidden' name='padd_state' value='{$padd_state}'>\r\n\t\t\t<input type='hidden' name='padd_code' value='{$padd_code}'>\r\n\t\t\t<input type='hidden' name='padd_country' value='{$padd_country}'>\r\n\t\t\t<input type='hidden' name='hadd' value='{$hadd}'>\r\n\t\t\t<input type='hidden' name='hadd_city' value='{$hadd_city}'>\r\n\t\t\t<input type='hidden' name='hadd_state' value='{$hadd_state}'>\r\n\t\t\t<input type='hidden' name='hadd_code' value='{$hadd_code}'>\r\n\t\t\t<input type='hidden' name='hadd_country' value='{$hadd_country}'>\r\n\t\t\t<input type='hidden' name='description' value='{$description}'>\r\n\t\t\t<input type='hidden' name='website' value='{$website}'>\r\n\t\t\t<input type='hidden' name='religion' value='{$religion}'>\r\n\t\t\t<input type='hidden' name='race' value='{$race}'>\r\n\t\t\t<input type='hidden' name='gender' value='{$gender}'>\r\n\t\t\t<input type='hidden' name='Con' value='{$Con}'>\r\n\t\t\t<input type='hidden' name='ncdate_day' value='{$ncdate_day}'>\r\n\t\t\t<input type='hidden' name='ncdate_month' value='{$ncdate_month}'>\r\n\t\t\t<input type='hidden' name='ncdate_year' value='{$ncdate_year}'>\r\n\t\t\t<input type='hidden' name='salespn' value='{$salespn}'>\r\n\t\t\t<input type='hidden' name='team_id' value='{$team_id}' />\r\n\t\t\t{$ex}\r\n\t\t\t{$displayaccountname}\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='4'>Lead Information</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td width='120'>First Name</td>\r\n\t\t\t\t<td width='210'>{$name}</td>\r\n\t\t\t\t<td width='120'>Office Phone</td>\r\n\t\t\t\t<td width='210'>{$tell_office}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>" . REQ . "Company/Last Name</td>\r\n\t\t\t\t<td>{$surname}</td>\r\n\t\t\t\t<td>Mobile</td>\r\n\t\t\t\t<td>{$cell}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Team Permissions</td>\r\n\t\t\t\t<td>{$team_name}</td>\r\n\t\t\t\t<td>Home Phone</td>\r\n\t\t\t\t<td>{$tell}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Lead Source</td>\r\n\t\t\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\r\n\t\t\t\t<td>Other Phone</td>\r\n\t\t\t\t<td>{$tell_other}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Title</td>\r\n\t\t\t\t<td>{$title}</td>\r\n\t\t\t\t<td>Fax</td>\r\n\t\t\t\t<td>{$fax}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Department</td>\r\n\t\t\t\t<td>{$department}</td>\r\n\t\t\t\t<td>E-mail</td>\r\n\t\t\t\t<td>{$email}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>" . REQ . "Birthdate</td>\r\n\t\t\t\t<td>{$birthdate_description}</td>\r\n\t\t\t\t<td>Other E-mail</td>\r\n\t\t\t\t<td>{$email_other}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td rowspan=2>Account Name</td>\r\n\t\t\t\t<td rowspan=2>{$accountname}</td>\r\n\t\t\t\t<td>Assistant</td>\r\n\t\t\t\t<td>{$assistant}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Assistant Phone</td>\r\n\t\t\t\t<td>{$assistant_phone}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Religion</td>\r\n\t\t\t\t<td>{$religion}</td>\r\n\t\t\t\t<td>Website</td>\r\n\t\t\t\t<td>{$website}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Race</td>\r\n\t\t\t\t<td>{$race}</td>\r\n\t\t\t\t<td>Next Contact Date</td>\r\n\t\t\t\t<td>{$ncdate}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Gender</td>\r\n\t\t\t\t<td>{$gender}</td>\r\n\t\t\t\t<td>Sales Person</td>\r\n\t\t\t\t<td>{$salespn_out}</td>\r\n\t\t\t</td>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Physical Address</th>\r\n\t\t\t\t<th colspan='2'>Postal Address</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='2' align='left' valign='top'><xmp>{$hadd}</xmp></td>\r\n\t\t\t\t<td colspan='2' align='left'><xmp>{$padd}</xmp></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>City</td>\r\n\t\t\t\t<td>{$padd_city}</td>\r\n\t\t\t\t<td>City</td>\r\n\t\t\t\t<td>{$hadd_city}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>State/Province</td>\r\n\t\t\t\t<td>{$padd_state}</td>\r\n\t\t\t\t<td>State/Province</td>\r\n\t\t\t\t<td>{$hadd_state}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Postal Code</td>\r\n\t\t\t\t<td>{$padd_code}</td>\r\n\t\t\t\t<td>Postal Code</td>\r\n\t\t\t\t<td>{$hadd_code}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Country</td>\r\n\t\t\t\t<td>{$padd_country}</td>\r\n\t\t\t\t<td>Country</td>\r\n\t\t\t\t<td>{$hadd_country}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Description</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='2' align='left'><xmp>{$description}</xmp></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Options</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>" . REQ . "Private</td>\r\n\t\t\t\t<td align='center'>{$Con}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\r\n\t\t\t\t<td align='right'><input type='submit' value='Write »'></td>\r\n\t\t\t</tr>\r\n\t\t</form>\r\n\t\t</table>\r\n\t\t<p>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t<tr>\r\n\t\t\t\t<th>Quick Links</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><a href='leads_list.php'>List leads</a></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\r\n\t\t\t</tr>\r\n\t\t</table>"; return $con_data; }
function viewLead() { global $_GET; global $user_admin; extract($_GET); # validate input require_lib("validate"); $v = new validate(); $v->isOk($id, "num", 1, 100, "Invalid num."); # display errors, if any if ($v->isError()) { $confirmCust = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirmCust .= "<li class='err'>{$e['msg']}</li>"; } return $confirmCust; } db_conn('crm'); $user = USER_ID; # write to db $Sql = "SELECT * FROM leads WHERE ((id='{$id}')and ((con='Yes' and assigned_to_id='{$user}') or(con='No')))"; $Rslt = db_exec($Sql) or errDie("Unable to access database."); if (pg_numrows($Rslt) < 1) { return "Lead not found"; } $Data = pg_fetch_array($Rslt); $date = $Data['date']; $mon = substr($date, 5, 2); if ($mon == 1) { $td = 31; $M = 'January'; } if ($mon == 2) { $td = 28; $M = 'February'; } if ($mon == 3) { $td = 31; $M = 'March'; } if ($mon == 4) { $td = 30; $M = 'April'; } if ($mon == 5) { $td = 31; $M = 'May'; } if ($mon == 6) { $td = 30; $M = 'June'; } if ($mon == 7) { $td = 31; $M = 'July'; } if ($mon == 8) { $td = 31; $M = 'August'; } if ($mon == 9) { $td = 30; $M = 'September'; } if ($mon == 10) { $td = 31; $M = 'October'; } if ($mon == 11) { $td = 30; $M = 'November'; } // and substr(date,7,4)='$year' if ($mon == 12) { $td = 31; $M = 'December'; } $Day = substr($date, 8, 2); $Day = $Day + 0; $Year = substr($date, 0, 4); $Date = $Day . " " . $M . " " . " " . $Year; $hadd = $Data['hadd']; $padd = $Data['padd']; $busy_deleting = isset($_GET["key"]) && $_GET["key"] == "confirm_delete"; // only show this when not deleting $viewLead = ""; if (!$busy_deleting) { $viewLead .= "<center><h3>Lead details</h3></center>"; } db_conn('crm'); $i = 0; $conpers = ""; /* DEACTIVED $Sl="SELECT * FROM conpers WHERE con='$Data[id]' ORDER BY name"; $Ry=db_exec($Sl) or errDie("Unable to get leads from db."); if(pg_num_rows($Ry)>0) { $conpers="<h3>Lead Persons</h3> <table border=0 cellpadding='".TMPL_tblCellPadding."' cellspacing='".TMPL_tblCellSpacing."'> <tr><th>Name</th><th>Position</th><th>Tel</th><th>Cell</th><th>Fax</th><th>Email</th><th>Notes</th><th colspan=2>Options</th></tr>"; while($cp=pg_fetch_array($Ry)) { $i++; $bgcolor=($i%2) ? TMPL_tblDataColor1 : TMPL_tblDataColor2; $conpers.="<tr class='".bg_class()."'><td>$cp[name]</td><td>$cp[pos]</td><td>$cp[tell]</td><td>$cp[cell]</td><td>$cp[fax]</td><td>$cp[email]</td> <td>$cp[notes]</td><td><a href='conper-edit.php?id=$cp[id]&type=edit'>Edit</a></td><td><a href='conper-rem.php?id=$cp[id]'>Delete</a></td></tr>"; } $conpers.="</table>"; } */ extract($Data); list($bf_year, $bf_month, $bf_day) = explode("-", $birthdate); $birthdate_description = date("d F Y", mktime(0, 0, 0, $bf_month, $bf_day, $bf_year)); if (!empty($ncdate)) { $ncdate = explode("-", $ncdate); $ncdate_out = "{$ncdate['2']}-{$ncdate['1']}-{$ncdate['0']}"; } else { $ncdate_out = ""; } db_conn("exten"); $sql = "SELECT salesp FROM salespeople WHERE salespid='{$salespid}'"; $rslt = db_exec($sql) or errDie("Unable to retrieve sales person from Cubit."); $salespn_out = pg_fetch_result($rslt, 0); $viewLead .= "\r\n\t\t<br>\r\n\t\t<center>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='4'>Lead Information</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td width='120'>First Name</td>\r\n\t\t\t\t<td width='210'>{$name}</td>\r\n\t\t\t\t<td width='120'>Office Phone</td>\r\n\t\t\t\t<td width='210'>{$tell_office}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Company/Last Name</td>\r\n\t\t\t\t<td>{$surname}</td>\r\n\t\t\t\t<td>Mobile</td>\r\n\t\t\t\t<td>{$cell}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Team Permissions</td>\r\n\t\t\t\t<td>{$team_name}</td>\r\n\t\t\t\t<td>Home Phone</td>\r\n\t\t\t\t<td>{$tell}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Lead Source</td>\r\n\t\t\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\r\n\t\t\t\t<td>Other Phone</td>\r\n\t\t\t\t<td>{$tell_other}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Title</td>\r\n\t\t\t\t<td>{$title}</td>\r\n\t\t\t\t<td>Fax</td>\r\n\t\t\t\t<td>{$fax}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Department</td>\r\n\t\t\t\t<td>{$department}</td>\r\n\t\t\t\t<td>E-mail</td>\r\n\t\t\t\t<td>{$email}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Birthdate</td>\r\n\t\t\t\t<td>{$birthdate_description}</td>\r\n\t\t\t\t<td>Other E-mail</td>\r\n\t\t\t\t<td>{$email_other}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Account Name</td>\r\n\t\t\t\t<td>{$accountname} ({$account_type})</td>\r\n\t\t\t\t<td>Assistant</td>\r\n\t\t\t\t<td>{$assistant}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td> </td>\r\n\t\t\t\t<td> </td>\r\n\t\t\t\t<td>Assistant Phone</td>\r\n\t\t\t\t<td>{$assistant_phone}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Religion</td>\r\n\t\t\t\t<td>{$religion}</td>\r\n\t\t\t\t<td>Website</td>\r\n\t\t\t\t<td>{$website}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Race</td>\r\n\t\t\t\t<td>{$race}</td>\r\n\t\t\t\t<td>Next Contact Date</td>\r\n\t\t\t\t<td>{$ncdate_out}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Gender</td>\r\n\t\t\t\t<td>{$gender}</td>\r\n\t\t\t\t<td>Sales Person</td>\r\n\t\t\t\t<td>{$salespn_out}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Physical Address</th>\r\n\t\t\t\t<th colspan='2'>Postal Address</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='2' align='left' valign='top'><xmp>{$hadd}</xmp></td>\r\n\t\t\t\t<td colspan='2' align='left'><xmp>{$padd}</xmp></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>City</td>\r\n\t\t\t\t<td>{$padd_city}</td>\r\n\t\t\t\t<td>City</td>\r\n\t\t\t\t<td>{$hadd_city}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>State/Province</td>\r\n\t\t\t\t<td>{$padd_state}</td>\r\n\t\t\t\t<td>State/Province</td>\r\n\t\t\t\t<td>{$hadd_state}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Postal Code</td>\r\n\t\t\t\t<td>{$padd_code}</td>\r\n\t\t\t\t<td>Postal Code</td>\r\n\t\t\t\t<td>{$hadd_code}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Country</td>\r\n\t\t\t\t<td>{$padd_country}</td>\r\n\t\t\t\t<td>Country</td>\r\n\t\t\t\t<td>{$hadd_country}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Description</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='2' align='left'><xmp>{$description}</xmp></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td> </td></tr>"; // check if own entry own entry, and if it is, create the delete field, so the delete field doesn't display // when it is not your lead if ($Data["by"] == USER_NAME || $user_admin) { $DeleteField = "<a class=nav href=\"leads_view.php?key=confirm_delete&id={$Data['id']}\">\r\n\t\t\t\tDelete Lead</a>"; } else { $DeleteField = ""; } // only add the following when not deleting if (!$busy_deleting) { // target='mainframe' onClick='setTimeout(window.close,50);' $viewLead .= "\r\n\t\t\t<tr>\r\n\t\t\t\t<td align='center' colspan='4'>\r\n\t\t\t\t\t<font size=2><b><a class='nav' href=\"leads_edit.php?id={$Data['id']}\">Edit Lead</a> {$DeleteField}</b></font>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>"; /* DEACTIVED $viewLead .= " <tr> <td align=center colspan=4><font size=2><b> <a class=nav target=mainframe href=\"conper-add.php?type=conn&id=$Data[id]\" onClick='setTimeout(window.close,50);' >Add Lead Person</a> </b></font></td> </tr>"; */ } $viewLead .= "\r\n\t\t</table>\r\n\t\t{$conpers}\r\n\t\t<p></center>"; return $viewLead; }
function con_data($_POST) { # get vars foreach ($_POST as $key => $value) { ${$key} = $value; } # validate input require_lib("validate"); $v = new validate(); $v->isOk($id, "num", 1, 9, "ID Field (hidden)"); $v->isOk($surname, "string", 1, 100, "Last name"); $v->isOk($name, "string", 0, 100, "First name"); $v->isOk($accountname, "string", 0, 100, "Account"); $v->isOk($account_id, "num", 0, 9, "Account ID (hidden)"); $v->isOk($account_type, "string", 0, 100, "Account type (hidden)"); $v->isOk($reports_to, "string", 0, 100, "Reports to"); $v->isOk($reports_to_id, "num", 0, 9, "Reports to ID (hidden)"); $v->isOk($lead_source, "string", 0, 100, "Lead Source"); $v->isOk($title, "string", 0, 100, "Title"); $v->isOk($department, "string", 0, 100, "Department"); $v->isOk($tell, "string", 0, 100, "Home Phone"); $v->isOk($cell, "string", 0, 100, "Mobile Phone"); $v->isOk($fax, "string", 0, 100, "Fax"); $v->isOk($tell_office, "string", 0, 100, "Office Phone"); $v->isOk($tell_other, "string", 0, 100, "Other Phone"); $v->isOk($email, "string", 0, 100, "Email"); $v->isOk($email_other, "string", 0, 100, "Other Email"); $v->isOk($assistant, "string", 0, 100, "Assistant"); $v->isOk($assistant_phone, "string", 0, 100, "Assistant Phone"); $v->isOk($padd, "string", 0, 100, "Physical Address"); $v->isOk($padd_city, "string", 0, 100, "Physical Address: City"); $v->isOk($padd_state, "string", 0, 100, "Physical Address: State/Province"); $v->isOk($padd_code, "string", 0, 100, "Physical Address: Postal Code"); $v->isOk($padd_country, "string", 0, 100, "Physical Address: Country"); $v->isOk($hadd, "string", 0, 100, "Postal Address"); $v->isOk($hadd_city, "string", 0, 100, "Postal Address: City"); $v->isOk($hadd_state, "string", 0, 100, "Postal Address: State/Province"); $v->isOk($hadd_code, "string", 0, 100, "Postal Address: Postal Code"); $v->isOk($hadd_country, "string", 0, 100, "Postal Address: Country"); $v->isOk($description, "string", 0, 100, "Notes"); $v->isOk($Con, "string", 2, 3, "Invalid private."); $birthdate = "{$bf_year}-{$bf_month}-{$bf_day}"; if ($v->isOk($birthdate, "string", 1, 100, "Birthdate")) { if (!checkdate($bf_month, $bf_day, $bf_year)) { $v->addError("_OTHER", "Invalid birthdate. No such date exists."); } } if ($bf_year >= 1971) { $birthdate_description = date("d F Y", mktime(0, 0, 0, $bf_day, $bf_month, $bf_year)); } else { $birthdate_description = ""; } # display errors, if any if ($v->isError()) { $err = "The following field value errors occured:<br>"; $errors = $v->getErrors(); foreach ($errors as $e) { if ($e["value"] == "_OTHER") { $err .= "<li class=err>{$e['msg']}</li>"; } else { $err .= "<li class=err>Invalid characters: {$e['msg']}</li>"; } } return get_data($err); } if ($upload_img == "yes") { $upload_box = "\r\n\t\t\t<td>Contact Image</td>\r\n\t\t\t<td><input type='file' name='img_file' /></td>"; } else { $upload_box = "<td colspan='2'> </td>"; } // Retrieve team name $sql = "SELECT name FROM crm.teams WHERE id='{$team_id}'"; $team_rslt = db_exec($sql) or errDie("Unable to retrieve team."); $team_name = pg_fetch_result($team_rslt, 0); $con_data = "<h3>Confirm contact details</h3>\r\n\t<table cellpadding='2' cellspacing='0' class='shtable'>\r\n\t<form action='" . SELF . "' method=post enctype='multipart/form-data'>\r\n\t<input type=hidden name=key value=write>\r\n\t<input type=hidden name=id value='{$id}'>\r\n\t<input type=hidden name='surname' value='{$surname}'>\r\n\t<input type=hidden name='name' value='{$name}'>\r\n\t<input type=hidden name='account_id' value='{$account_id}'>\r\n\t<input type=hidden name='account_type' value='{$account_type}'>\r\n\t<input type=hidden name='lead_source' value='{$lead_source}'>\r\n\t<input type=hidden name='title' value='{$title}'>\r\n\t<input type=hidden name='department' value='{$department}'>\r\n\t<input type=hidden name='bf_day' value='{$bf_day}'>\r\n\t<input type=hidden name='bf_month' value='{$bf_month}'>\r\n\t<input type=hidden name='bf_year' value='{$bf_year}'>\r\n\t<input type=hidden name='reports_to_id' value='{$reports_to_id}'>\r\n\t<input type=hidden name='tell' value='{$tell}'>\r\n\t<input type=hidden name='cell' value='{$cell}'>\r\n\t<input type=hidden name='fax' value='{$fax}'>\r\n\t<input type=hidden name='tell_office' value='{$tell_office}'>\r\n\t<input type=hidden name='tell_other' value='{$tell_other}'>\r\n\t<input type=hidden name='email' value='{$email}'>\r\n\t<input type=hidden name='email_other' value='{$email_other}'>\r\n\t<input type=hidden name='assistant' value='{$assistant}'>\r\n\t<input type=hidden name='assistant_phone' value='{$assistant_phone}'>\r\n\t<input type=hidden name='padd' value='{$padd}'>\r\n\t<input type=hidden name='padd_city' value='{$padd_city}'>\r\n\t<input type=hidden name='padd_state' value='{$padd_state}'>\r\n\t<input type=hidden name='padd_code' value='{$padd_code}'>\r\n\t<input type=hidden name='padd_country' value='{$padd_country}'>\r\n\t<input type=hidden name='hadd' value='{$hadd}'>\r\n\t<input type=hidden name='hadd_city' value='{$hadd_city}'>\r\n\t<input type=hidden name='hadd_state' value='{$hadd_state}'>\r\n\t<input type=hidden name='hadd_code' value='{$hadd_code}'>\r\n\t<input type=hidden name='hadd_country' value='{$hadd_country}'>\r\n\t<input type=hidden name='description' value='{$description}'>\r\n\t<input type=hidden name='Con' value='{$Con}'>\r\n\t<input type='hidden' name='team_id' value='{$team_id}' />\r\n\t<input type='hidden' name='upload_img' value='{$upload_img}' />\r\n\t<tr><th colspan=4>Contact Information</th></tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td width=120>First Name</td>\r\n\t\t<td width=210>{$name}</td>\r\n\r\n\t\t<td width=120>Office Phone</td>\r\n\t\t<td width=210>{$tell_office}</td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td>Company/Last Name</td>\r\n\t\t<td>{$surname}</td>\r\n\r\n\t\t<td>Mobile</td>\r\n\t\t<td>{$cell}</td>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td>Account Name</td>\r\n\t\t<td>{$accountname}</td>\r\n\r\n\t\t<td>Home Phone</td>\r\n\t\t<td>{$tell}</td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td>Lead Source</td>\r\n\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\r\n\r\n\t\t<td>Other Phone</td>\r\n\t\t<td>{$tell_other}</td>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td>Title</td>\r\n\t\t<td>{$title}</td>\r\n\r\n\t\t<td>Fax</td>\r\n\t\t<td>{$fax}</td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td>Department</td>\r\n\t\t<td>{$department}</td>\r\n\r\n\t\t<td>E-mail</td>\r\n\t\t<td>{$email}</td>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td>Birthdate</td>\r\n\t\t<td>{$birthdate_description}</td>\r\n\r\n\t\t<td>Other E-mail</td>\r\n\t\t<td>{$email_other}</td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td>Reports To</td>\r\n\t\t<td>{$reports_to}</td>\r\n\r\n\t\t<td>Assistant</td>\r\n\t\t<td>{$assistant}</td>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td> </td>\r\n\t\t<td> </td>\r\n\r\n\t\t<td>Assistant Phone</td>\r\n\t\t<td>{$assistant_phone}</td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t{$upload_box}\r\n\r\n\t\t<td>Team Permissions</td>\r\n\t\t<td>{$team_name}</td>\r\n\t</tr>\r\n\r\n\t<tr>\r\n\t\t<th colspan=2>Physical Address</th>\r\n\t\t<th colspan=2>Postal Address</th>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td colspan=2 align=left valign=top><xmp>{$hadd}</xmp></td>\r\n\r\n\t\t<td colspan=2 align=left><xmp>{$padd}</xmp></td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td>City</td>\r\n\t\t<td>{$padd_city}</td>\r\n\t\t<td>City</td>\r\n\t\t<td>{$hadd_city}</td>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td>State/Province</td>\r\n\t\t<td>{$padd_state}</td>\r\n\t\t<td>State/Province</td>\r\n\t\t<td>{$hadd_state}</td>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td>Postal Code</td>\r\n\t\t<td>{$padd_code}</td>\r\n\t\t<td>Postal Code</td>\r\n\t\t<td>{$hadd_code}</td>\r\n\t</tr>\r\n\t<tr class='bg-even'>\r\n\t\t<td>Country</td>\r\n\t\t<td>{$padd_country}</td>\r\n\t\t<td>Country</td>\r\n\t\t<td>{$hadd_country}</td>\r\n\t</tr>\r\n\r\n\t<tr>\r\n\t\t<th colspan=2>Notes</th>\r\n\t\t<th colspan=2>Options</th>\r\n\t</tr>\r\n\t<tr class='bg-odd'>\r\n\t\t<td colspan=2 align=left><xmp>{$description}</xmp></td>\r\n\t\t<td>Private</td>\r\n\t\t<td align=center>{$Con}</td>\r\n\t</tr>\r\n\t</table>\r\n\t<p>\r\n\t<input type=submit value='Write »'>\r\n\t</form>\r\n\t<p>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Quick Links</th></tr>\r\n\t<tr class='bg-odd'><td><a href='list_cons.php'>List contacts</a></td></tr>\r\n <tr class='bg-odd'><td><a href='index_cons.php'>Contacts</a></td></tr>\r\n\t<tr class='bg-odd'><td><a href='main.php'>Main Menu</a></td></tr>\r\n\t</table>"; return $con_data; }
function confirm() { extract($_POST); if ($err = validate($_POST)) { return enter($err); } if (isset($addr_same)) { $addr1 = $paddr1; } if (!isset($cusnum) && $key != "doc_save") { $qry = new dbSelect("customers", "cubit", grp(m("where", "accno='{$accno}' AND div='" . USER_DIV . "'"))); $qry->run(); if ($qry->num_rows() > 0) { return enter("<li class='err'>A Customer/Client with this account number already exists.</li>"); } } $data = qryCategory($category); $catname = $data["category"]; $data = qryClass($class); $classname = $data["classname"]; $data = qryPricelist($pricelist); $plist = $data["listname"]; $data = qryDepartment($deptid); $deptname = $data["deptname"]; if ($sales_rep == "0") { $salesperson = "None"; } else { $data = qrySalesPerson($sales_rep); $salesperson = $data["salesp"]; } /* customer is local/international */ $locs = grp(m("loc", "Local"), m("int", "International")); $curr = getSymbol($fcid); if (isset($crm)) { $ex = "<input type='hidden' name='crm' value='' />"; } else { $ex = ""; } if (isset($cusnum)) { $cusid = "<input type='hidden' name='cusnum' value='{$cusnum}' />"; } else { $cusid = ""; } $odate = mkdate($o_year, $o_month, $o_day); // Retrieve teams $sql = "SELECT * FROM crm.teams WHERE id='{$team_id}'"; $team_rslt = db_exec($sql) or errDie("Unable to retrieve team."); $team_data = pg_fetch_array($team_rslt); $hidden = onthespot_passon() . "\n\t\t\t<input type='hidden' name='deptid' value='{$deptid}' />\n\t\t\t<input type='hidden' name='accno' value='{$accno}' />\n\t\t\t<input type='hidden' name='surname' value='{$surname}' />\n\t\t\t<input type='hidden' name='title' value='{$title}' />\n\t\t\t<input type='hidden' name='init' value='{$init}' />\n\t\t\t<input type='hidden' name='location' value='{$location}' />\n\t\t\t<input type='hidden' name='fcid' value='{$fcid}' />\n\t\t\t<input type='hidden' name='category' value='{$category}' />\n\t\t\t<input type='hidden' name='class' value='{$class}' />\n\t\t\t<input type='hidden' name='addr1' value='{$addr1}' />\n\t\t\t<input type='hidden' name='paddr1' value='{$paddr1}' />\n\t\t\t<input type='hidden' name='del_addr1' value='{$del_addr1}' />\n\t\t\t<input type='hidden' name='vatnum' value='{$vatnum}' />\n\t\t\t<input type='hidden' name='contname' value='{$contname}' />\n\t\t\t<input type='hidden' name='bustel' value='{$bustel}' />\n\t\t\t<input type='hidden' name='tel' value='{$tel}' />\n\t\t\t<input type='hidden' name='cellno' value='{$cellno}' />\n\t\t\t<input type='hidden' name='fax' value='{$fax}' />\n\t\t\t<input type='hidden' name='email' value='{$email}' />\n\t\t\t<input type='hidden' name='url' value='{$url}' />\n\t\t\t<input type='hidden' name='traddisc' value='{$traddisc}' />\n\t\t\t<input type='hidden' name='setdisc' value='{$setdisc}' />\n\t\t\t<input type='hidden' name='pricelist' value='{$pricelist}' />\n\t\t\t<input type='hidden' name='chrgint' value='{$chrgint}' />\n\t\t\t<input type='hidden' name='overdue' value='{$overdue}' />\n\t\t\t<input type='hidden' name='intrate' value='{$intrate}' />\n\t\t\t<input type='hidden' name='credterm' value='{$credterm}' />\n\t\t\t<input type='hidden' name='odate' value='{$odate}' />\n\t\t\t<input type='hidden' name='credlimit' value='{$credlimit}' />\n\t\t\t<input type='hidden' name='deptname' value='{$deptname}' />\n\t\t\t<input type='hidden' name='o_day' value='{$o_day}' />\n\t\t\t<input type='hidden' name='o_month' value='{$o_month}' />\n\t\t\t<input type='hidden' name='o_year' value='{$o_year}' />\n\t\t\t<input type='hidden' name='lead_source' value='{$lead_source}' />\n\t\t\t<input type='hidden' name='comments' value='{$comments}' />\n\t\t\t<input type='hidden' name='sales_rep' value='{$sales_rep}' />\n\t\t\t<input type='hidden' name='re' value='{$re}' />\n\t\t\t<input type='hidden' name='bankname' value='{$bankname}' />\n\t\t\t<input type='hidden' name='branname' value='{$branname}' />\n\t\t\t<input type='hidden' name='brancode' value='{$brancode}' />\n\t\t\t<input type='hidden' name='bankaccname' value='{$bankaccname}' />\n\t\t\t<input type='hidden' name='bankaccno' value='{$bankaccno}' />\n\t\t\t<input type='hidden' name='bankacctype' value='{$bankacctype}' />\n\t\t\t<input type='hidden' name='team_id' value='{$team_id}' />\n\t\t\t<input type='hidden' name='registration' value='{$registration}' />"; $OUT = "\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t<input type='hidden' name='key' value='write' />\n\t\t\t{$hidden}\n\t\t\t{$ex}\n\t\t\t{$cusid}\n\t\t<table cellpadding='0' cellspacing='0'>\n\t\t<tr>\n\t\t\t<th colspan='2'>Confirm Customer : Customer Details</th>\n\t\t</tr>\n\t\t<tr valign='top'>\n\t\t\t<td>\n\t\t\t\t<table " . TMPL_tblDflts . " width='100%'>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Department</td>\n\t\t\t\t\t\t<td>{$deptname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Acc No</td>\n\t\t\t\t\t\t<td>{$accno}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Company/Name</td>\n\t\t\t\t\t\t<td>{$surname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Registration/ID</td>\n\t\t\t\t\t\t<td>{$registration}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Title</td>\n\t\t\t\t\t\t<td>{$title}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Initials</td>\n\t\t\t\t\t\t<td>{$init}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Type</td>\n\t\t\t\t\t\t<td>{$locs[$location]}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Currency</td>\n\t\t\t\t\t\t<td>{$curr['symbol']} - {$curr['name']}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Category</td>\n\t\t\t\t\t\t<td>{$catname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Classification</td>\n\t\t\t\t\t\t<td>{$classname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Link to Sales rep</td>\n\t\t\t\t\t\t<td>{$salesperson}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td valign='top'>Postal Address</td>\n\t\t\t\t\t\t<td valign='center'>" . nl2br($paddr1) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td valign='top'>Physical Address</td>\n\t\t\t\t\t\t<td valign='center'>" . nl2br($addr1) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td valign='top'>Delivery Address</td>\n\t\t\t\t\t\t<td valign='center'>" . nl2br($del_addr1) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>VAT Number</td>\n\t\t\t\t\t\t<td>{$vatnum}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Contact Name</td>\n\t\t\t\t\t\t<td>{$contname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Business Tel.</td>\n\t\t\t\t\t\t<td>{$bustel}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Team Permissions</td>\n\t\t\t\t\t\t<td>{$team_data['name']}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type='submit' name='back' value='« Correction' /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t<table " . TMPL_tblDflts . " width='100%'>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Home Tel.</td>\n\t\t\t\t\t\t<td>{$tel}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Cell No.</td>\n\t\t\t\t\t\t<td>{$cellno}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Fax No.</td>\n\t\t\t\t\t\t<td>{$fax}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>E-mail</td>\n\t\t\t\t\t\t<td>{$email}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Web Address</td>\n\t\t\t\t\t\t<td>http://{$url}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Trade Discount</td>\n\t\t\t\t\t\t<td>{$traddisc}%</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Settlement Discount</td>\n\t\t\t\t\t\t<td>{$setdisc}%</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Price List</td>\n\t\t\t\t\t\t<td>{$plist}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Charge Interest</td>\n\t\t\t\t\t\t<td>{$chrgint}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Interest Rate</td>\n\t\t\t\t\t\t<td>{$intrate}%</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Overdue</td>\n\t\t\t\t\t\t<td>{$overdue}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Account Open Date</td>\n\t\t\t\t\t\t<td>{$odate}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Credit Term</td>\n\t\t\t\t\t\t<td>{$credterm}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Credit Limit</td>\n\t\t\t\t\t\t<td>{$credlimit}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Lead Source</td>\n\t\t\t\t\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<th colspan='2'> Bank Details</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Bank </td>\n\t\t\t\t\t\t<td>{$bankname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Branch</td>\n\t\t\t\t\t\t<td>{$branname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Branch Code</td>\n\t\t\t\t\t\t<td>{$brancode}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Account Name</td>\n\t\t\t\t\t\t<td>{$bankaccname}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Account Number</td>\n\t\t\t\t\t\t<td>{$bankaccno}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Account Type</td>\n\t\t\t\t\t\t<td>{$bankacctype}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Comments</td>\n\t\t\t\t\t\t<td>" . nl2br($comments) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t\t<td align='right'><input type='submit' value='Write »' /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t</form>"; // Retrieve documents added already if (isset($cusnum) && !empty($cusnum)) { $sql = "SELECT id,file,type,filename,size,'customer_docs' AS table FROM crm.customer_docs\n\t\t\t\t\t\tWHERE cusnum='{$cusnum}' UNION SELECT id,file,type,filename,size,'ctmp_docs' AS table FROM crm.ctmp_docs\n\t\t\t\t\t\tWHERE session='{$_REQUEST['CUBIT_SESSION']}'"; } else { $sql = "SELECT * FROM crm.ctmp_docs\n\t\t\t\t\t\tWHERE session='{$_REQUEST['CUBIT_SESSION']}' ORDER BY id DESC"; } $cdoc_rslt = db_exec($sql) or errDie("Unable to retrieve docs."); $cdoc_out = ""; while ($cdoc_data = pg_fetch_array($cdoc_rslt)) { $cdoc_out .= "<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<a href='cust_doc_get.php?id={$cdoc_data['id']}&tmp=1&table={$cdoc_data['table']}'>\n\t\t\t\t\t\t\t\t\t{$cdoc_data['filename']}\n\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t<td>" . getFileSize($cdoc_data["size"]) . "</td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<input type='checkbox' name='rem[{$cdoc_data['id']}]'\n\t\t\t\t\t\t\t\tvalue='{$cdoc_data['id']}' />\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>"; } if (empty($cdoc_out)) { $cdoc_out .= "<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td colspan='3'><li>No documents added</li></td>\n\t\t\t\t\t\t</tr>"; } $OUT .= "\n\t\t\t\t\t<form method='post' action='" . SELF . "' enctype='multipart/form-data'>\n\t\t\t\t\t<input type='hidden' name='key' value='doc_save' />\n\t\t\t\t\t{$hidden}\n\t\t\t\t\t{$cusid}\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='3'>Documents</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Filename</th>\n\t\t\t\t\t\t\t<th>Upload</th>\n\t\t\t\t\t\t\t<th> </th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><input type='text' name='doc_filename'></td>\n\t\t\t\t\t\t\t<td><input type='file' name='doc_file'></td>\n\t\t\t\t\t\t\t<td colspan='2' align='center'>\n\t\t\t\t\t\t\t\t<input type='submit' value='Update'>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Filename</th>\n\t\t\t\t\t\t\t<th>Size</th>\n\t\t\t\t\t\t\t<th>Remove</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t{$cdoc_out}\n\t\t\t\t\t</table>\n\t\t\t\t\t</td></tr>\n\t\t\t</td></tr>\n\t\t</table>"; mkQuickLinks(ql("customers-view.php", "View Customers")); return $OUT; }
function confirm() { global $_POST; extract($_POST); # validate input require_lib("validate"); $v = new validate(); $v->isOk($deptid, "num", 0, 255, "Invalid Department."); $v->isOk($supno, "string", 1, 255, "Invalid supplier number."); $v->isOk($supname, "string", 1, 255, "Invalid supplier name."); $v->isOk($loc, "string", 1, 3, "Invalid Type."); $v->isOk($fcid, "num", 1, 30, "Invalid Currency."); $v->isOk($vatnum, "string", 1, 255, "Invalid supplier vat number."); $v->isOk($registration, "string", 1, 255, "Invalid registration number."); $v->isOk($supaddr, "string", 1, 255, "Invalid supplier address."); $v->isOk($suppostaddr, "string", 0, 255, "Invalid supplier postal address."); $v->isOk($contname, "string", 1, 255, "Invalid contact name."); $v->isOk($tel, "string", 1, 20, "Invalid tel no."); $v->isOk($fax, "string", 0, 20, "Invalid fax no."); $v->isOk($cell, "string", 0, 20, "Invalid cell no."); $v->isOk($email, "email", 0, 255, "Invalid e-mail address."); $v->isOk($url, "url", 0, 255, "Invalid web address."); $v->isOk($listid, "num", 1, 20, "Invalid price list."); $v->isOk($bankname, "string", 0, 255, "Invalid bank name."); $v->isOk($branname, "string", 0, 255, "Invalid branch name."); $v->isOk($brancode, "string", 0, 255, "Invalid branch code."); $v->isOk($bankaccname, "string", 0, 255, "Invalid bank account name."); $v->isOk($bankacctype, "string", 0, 255, "Invalid bank account type."); $v->isOk($bankaccno, "num", 0, 255, "Invalid bank account number."); $v->isOk($lead_source, "num", 0, 9, "Invalid lead source selected."); $v->isOk($comments, "string", 0, 255, "Invalid characters in comment."); $v->isOk($supbranch, "string", 0, 255, "Invalid supplier branch."); $v->isOk($reference, "string", 0, 255, "Invalid reference."); $v->isOk($bee_status, "string", 0, 255, "Invalid BEE Status"); $v->isOk($team_id, "num", 1, 9, "Invalid team selection."); $v->isOk($supp_grp, "num", 1, 9, "Invalid supplier group selected."); $v->isOk($setdisc, "float", 1, 40, "Invalid Settlement Discount Amount."); $v->isOk($setdays, "num", 1, 40, "Invalid Settlement Discount Days"); # display errors, if any if ($v->isError()) { $confirm = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirm .= "<li class='err'>{$e['msg']}</li>"; } return enter($confirm); } db_conn('cubit'); $Sl = "SELECT * FROM suppliers WHERE supno='{$supno}'"; $Ri = db_exec($Sl) or errDie("Unable to get data."); if (pg_num_rows($Ri) > 0) { return enter("<li class='err'>Supplier number already exists</li>"); } # Check if add contact was checked if (isset($addcontact) && $addcontact == "on") { $addcontact_checked = "Yes"; } else { $addcontact = ""; $addcontact_checked = "No"; } # get department db_conn("exten"); $sql = "SELECT * FROM departments WHERE deptid = '{$deptid}' AND div = '" . USER_DIV . "'"; $deptRslt = db_exec($sql); if (pg_numrows($deptRslt) < 1) { $deptname = "<li class='err'>Department not Found.</li>"; } else { $dept = pg_fetch_array($deptRslt); $deptname = $dept['deptname']; } # Get Price List $sql = "SELECT * FROM spricelist WHERE listid = '{$listid}' AND div = '" . USER_DIV . "'"; $listRslt = db_exec($sql); if (pg_numrows($listRslt) < 1) { $plist = "<li class='err'>Class not Found.</li>"; } else { $list = pg_fetch_array($listRslt); $plist = $list['listname']; } # Locations drop down $locs = array("loc" => "Local", "int" => "International"); $curr = getSymbol($fcid); if (isset($crm)) { $ex = "<input type='hidden' name='crm' value=''>"; } else { $ex = ""; } $get_suppgrp = "SELECT groupname FROM supp_groups WHERE id = '{$supp_grp}' LIMIT 1"; $run_suppgrp = db_exec($get_suppgrp) or errDie("Unable to get supplier group information"); if (pg_numrows($run_suppgrp) < 1) { $showsupp_grp = "Unknown Supplier Group"; } else { $garr = pg_fetch_array($run_suppgrp); $showsupp_grp = $garr['groupname']; } // Retrieve team name $sql = "SELECT * FROM crm.teams WHERE id='{$team_id}'"; $team_rslt = db_exec($sql) or errDie("Unable to retrieve team."); $team_data = pg_fetch_array($team_rslt); $hidden = "\n\t\t<input type='hidden' name='deptid' value='{$deptid}'>\n\t\t<input type='hidden' name='supno' value='{$supno}'>\n\t\t<input type='hidden' name='supname' value='{$supname}'>\n\t\t<input type='hidden' name='loc' value='{$loc}'>\n\t\t<input type='hidden' name='fcid' value='{$fcid}'>\n\t\t<input type='hidden' name='vatnum' value='{$vatnum}'>\n\t\t<input type='hidden' name='registration' value='{$registration}'>\n\t\t<input type='hidden' name='supaddr' value='{$supaddr}'>\n\t\t<input type='hidden' name='suppostaddr' value='{$suppostaddr}'>\n\t\t<input type='hidden' name='contname' value='{$contname}'>\n\t\t<input type='hidden' name='tel' value='{$tel}'>\n\t\t<input type='hidden' name='fax' value='{$fax}'>\n\t\t<input type='hidden' name='cell' value='{$cell}'>\n\t\t<input type='hidden' name='email' value='{$email}'>\n\t\t<input type='hidden' name='url' value='{$url}'>\n\t\t<input type='hidden' name='listid' value='{$listid}'>\n\t\t<input type='hidden' name='bankname' value='{$bankname}'>\n\t\t<input type='hidden' name='branname' value='{$branname}'>\n\t\t<input type='hidden' name='brancode' value='{$brancode}'>\n\t\t<input type='hidden' name='bankaccno' value='{$bankaccno}'>\n\t\t<input type='hidden' name='bankaccname' value='{$bankaccname}'>\n\t\t<input type='hidden' name='bankacctype' value='{$bankacctype}'>\n\t\t<input type='hidden' name='lead_source' value='{$lead_source}'>\n\t\t<input type='hidden' name='comments' value='{$comments}'>\n\t\t<input type='hidden' name='supbranch' value='{$supbranch}'>\n\t\t<input type='hidden' name='reference' value='{$reference}'>\n\t\t<input type='hidden' name='re' value='{$re}'>\n\t\t<input type='hidden' name='bee_status' value='{$bee_status}'>\n\t\t<input type='hidden' name='team_id' value='{$team_id}' />\n\t\t<input type='hidden' name='supp_grp' value='{$supp_grp}' />\n\t\t<input type='hidden' name='setdisc' value='{$setdisc}' />\n\t\t<input type='hidden' name='setdays' value='{$setdays}' />"; $confirm = "\n\t\t<h3>Confirm Supplier</h3>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<input type='hidden' name='key' value='write'>\n\t\t\t{$hidden}\n\t\t\t{$ex}\n\t\t\t<tr valign='top'>\n\t\t\t\t<td>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='2'>Supplier Details</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Department</td>\n\t\t\t\t\t\t\t<td>{$deptname}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Supplier No</td>\n\t\t\t\t\t\t\t<td>{$supno}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Supplier/Name </td>\n\t\t\t\t\t\t\t<td>{$supname}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Registration/ID </td>\n\t\t\t\t\t\t\t<td>{$registration}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch</td>\n\t\t\t\t\t\t\t<td>{$supbranch}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Type</td>\n\t\t\t\t\t\t\t<td>{$locs[$loc]}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Currency</td>\n\t\t\t\t\t\t\t<td>{$curr['symbol']} - {$curr['name']}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>VAT Number</td>\n\t\t\t\t\t\t\t<td>{$vatnum}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Address</td>\n\t\t\t\t\t\t\t<td><pre>{$supaddr}</pre></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Postal Address</td>\n\t\t\t\t\t\t\t<td><pre>{$suppostaddr}</pre></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Contact Name</td>\n\t\t\t\t\t\t\t<td>{$contname}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Tel No.</td>\n\t\t\t\t\t\t\t<td>{$tel}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Fax No.</td>\n\t\t\t\t\t\t\t<td>{$fax}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Cell No.</td>\n\t\t\t\t\t\t\t<td>{$cell}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>E-mail</td>\n\t\t\t\t\t\t\t<td>{$email}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Web Address</td>\n\t\t\t\t\t\t\t<td>http://{$url}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Price List</td>\n\t\t\t\t\t\t\t<td>{$plist}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Supplier Group</td>\n\t\t\t\t\t\t\t<td>{$showsupp_grp}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Status BEE</td>\n\t\t\t\t\t\t\t<td>{$bee_status}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Team Permissions</td>\n\t\t\t\t\t\t\t<td>{$team_data['name']}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<th colspan='2'> Bank Details</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Bank </td>\n\t\t\t\t\t\t\t<td>{$bankname}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch</td>\n\t\t\t\t\t\t\t<td>{$branname}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch Code</td>\n\t\t\t\t\t\t\t<td>{$brancode}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Account Name</td>\n\t\t\t\t\t\t\t<td>{$bankaccname}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Account Type</td>\n\t\t\t\t\t\t\t<td>{$bankacctype}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Account Number</td>\n\t\t\t\t\t\t\t<td>{$bankaccno}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Reference</td>\n\t\t\t\t\t\t\t<td>{$reference}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Lead Source</td>\n\t\t\t\t\t\t\t<td>" . crm_get_leadsrc($lead_source) . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Settlement Discount %</td>\n\t\t\t\t\t\t\t<td>{$setdisc} %</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Settlement Discount Days</td>\n\t\t\t\t\t\t\t<td>{$setdays}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Comments</td>\n\t\t\t\t\t\t\t<td>" . nl2br($comments) . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t" . TBL_BR . "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Write »'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t" . TBL_BR . "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan='2'>"; // Retrieve documents added already $sql = "SELECT * FROM crm.stmp_docs WHERE session='{$_REQUEST['CUBIT_SESSION']}' ORDER BY id DESC"; $sdoc_rslt = db_exec($sql) or errDie("Unable to retrieve docs."); $sdoc_out = ""; while ($sdoc_data = pg_fetch_array($sdoc_rslt)) { if (strlen($sdoc_data['filename']) > 0) { $showdoc = "{$sdoc_data['filename']}"; } elseif (strlen($sdoc_data['real_filename']) > 0) { $showdoc = "{$sdoc_data['real_filename']}"; } else { $showdoc = "File" . $sdoc_data["id"]; } $sdoc_out .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='supp_doc_get.php?id={$sdoc_data['id']}&tmp=1'>{$showdoc}</a></td>\n\t\t\t\t\t<td>" . getFileSize($sdoc_data["size"]) . "</td>\n\t\t\t\t\t<td><input type='checkbox' name='rem[{$sdoc_data['id']}]' value='{$sdoc_data['id']}' /></td>\n\t\t\t\t</tr>"; } if (empty($sdoc_out)) { $sdoc_out .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td colspan='3'><li>No documents added</li></td>\n\t\t\t\t</tr>"; } $confirm .= "\n\t\t\t\t\t</form>\n\t\t\t\t\t<form method='post' action='" . SELF . "' enctype='multipart/form-data'>\n\t\t\t\t\t\t<input type='hidden' name='key' value='doc_save' />\n\t\t\t\t\t\t{$hidden}\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='4'>Documents</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Filename</th>\n\t\t\t\t\t\t\t<th>Upload</th>\n\t\t\t\t\t\t\t<th> </th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><input type='text' name='doc_filename'></td>\n\t\t\t\t\t\t\t<td><input type='file' name='doc_file'></td>\n\t\t\t\t\t\t\t<td colspan='2' align='center'>\n\t\t\t\t\t\t\t\t<input type='submit' value='Update'>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Filename</th>\n\t\t\t\t\t\t\t<th>Size</th>\n\t\t\t\t\t\t\t<th>Remove</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t{$sdoc_out}\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>"; $confirm .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td colspan='2' align='right'>\n\t\t\t\t\t\t\t\t\t<table border='0' cellpadding='2' cellspacing='1'>\n\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t\t<td><a href='supp-view.php'>View Suppliers</a></td>\n\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t</table>"; return $confirm; }