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'>&nbsp;</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='&laquo; Correction'>\n\t\t\t<input type='submit' value='Write &raquo;'>\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>&nbsp;</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>&nbsp;</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>&nbsp;</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 &raquo;'></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>&nbsp;</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>&nbsp;</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>&nbsp;</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='&laquo; Correction'></td>\r\n\t\t\t\t<td align='right'><input type='submit' value='Write &raquo;'></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>&nbsp;</td>\r\n\t\t\t\t<td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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> &nbsp;{$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> &nbsp;
        		</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'>&nbsp;</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>&nbsp;</td>\r\n\t\t<td>&nbsp;</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 &raquo;'>\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='&laquo; 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>&nbsp;</td>\n\t\t\t\t\t\t<td align='right'><input type='submit' value='Write &raquo;' /></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>&nbsp;</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='&laquo; 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 &raquo;'></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>&nbsp;</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;
}