\n"; } $dVal['protectron']['default'] = "Request Number"; $dVal['pwoNo']['default'] = "WO or Ref No"; $dVal['csid']['default'] = "CSID"; $dVal['lName']['default'] = "Business or Last Name"; $dVal['fName']['default'] = "First Name"; $dVal['address']['default'] = "Address"; $dVal['city']['default'] = "City"; $dVal['prov']['default'] = ""; $dVal['pc']['default'] = "Post Cd"; $dVal['pNumber']['default'] = "Phone"; // $dVal['tagLine']['default'] = "Job Tagline"; $dVal['cCode']['default'] = ""; $dVal['ccu']['default'] = "CCU"; $dVal['instCode']['default'] = "Inst"; $dVal['dlsCode']['default'] = "DLS "; $dVal['testTime']['default'] = "Test"; if (!empty($_REQUEST['lName']) and $_REQUEST['subAction'] != "Search") { foreach ($dVal as $k => $v) { if ($_REQUEST[$k] == $v['default']) $_REQUEST[$k] = ""; } if (!empty($_REQUEST['pc'])) { $pc = strtoupper(str_replace(" ", "", $_REQUEST['pc'])); $pc = substr($pc, 0, 3)." ".substr($pc, -3); } else $pc = ""; if (empty($_REQUEST['prov'])) $_REQUEST['prov'] = "BC"; $c1 = "fName = '".str_replace("'","´", $_REQUEST['fName'])."', "; $c1 .= "lName = '".str_replace("'","´", $_REQUEST['lName'])."', "; $c1 .= "address = '".$_REQUEST['address']."', "; $c1 .= "city = '".$_REQUEST['city']."', "; $c1 .= "prov = '".strtoupper(substr($_REQUEST['prov'], 0, 2))."', "; $c1 .= "pc = '$pc', "; $c1 .= "csid = '".strtoupper($_REQUEST['csid'])."'"; if (empty($_REQUEST['cCode'])) { $cCode = nextClientNumber(); // new client $c1 = "cCode = '$cCode', $c1"; sqlRecycle("clientdat", $c1, "cCode = ''"); } else { sqlUpdate("clientdat", $c1, "cCode = '{$_REQUEST['cCode']}'"); } $_REQUEST['clientEdit'] = ($cCode ? $cCode: $_REQUEST['cCode']); } if (!empty($_REQUEST['clientEdit'])) { $r = sqlSelect("clientdat", "cCode = '{$_REQUEST['clientEdit']}'"); $r = mysql_fetch_assoc($r['r']); // print_r($r); // echo "
\n"; $_REQUEST['cCode'] = $r['cCode']; $_REQUEST['fName'] = $r['fName']; $_REQUEST['lName'] = $r['lName']; $_REQUEST['address'] = $r['address']; $_REQUEST['city'] = $r['city']; $_REQUEST['prov'] = $r['prov']; $_REQUEST['pc'] = $r['pc']; $_REQUEST['csid'] = $r['csid']; } echo " \n"; //=================================================================== foreach ($dVal as $k => $v) { //echo "\n"; if (empty($_REQUEST[$k])) { $dVal[$k]['text'] = $v['default']; $dVal[$k]['style'] = "style=\"color: grey; font-style: italic;\" onfocus=\"fixStyles( this, '".$v['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$v['default']."', '' );\""; $dVal[$k]['disable'] = ""; } else { $dVal[$k]['text'] = $_REQUEST[$k]; $dVal[$k]['style'] = " onfocus=\"fixStyles( this, '".$v['default']."', '' );\" onBlur=\"unfixFuzzyStyles( this, '".$v['default']."', '' );\""; $dVal[$k]['disable'] = ""; } } //=================================================================== echo "
Create or Edit Client Account

\n"; echo "\n"; // get a list of clients for quick selection // store these in an array so we can easily reuse them $extra = ""; if ($_REQUEST['subAction'] == "Search") { if (!empty($_REQUEST['lName']) and $_REQUEST['lName'] != $dVal['lName']['default']) $extra .= " and lName like '%{$_REQUEST['lName']}%'"; if (!empty($_REQUEST['fName']) and $_REQUEST['fName'] != $dVal['fName']['default']) $extra .= " and fName like '%{$_REQUEST['fName']}%'"; if (!empty($_REQUEST['address']) and $_REQUEST['address'] != $dVal['address']['default']) $extra .= " and address like '%{$_REQUEST['address']}%'"; if (!empty($_REQUEST['city']) and $_REQUEST['city'] != $dVal['city']['default']) $extra .= " and city like '%{$_REQUEST['city']}%'"; if (!empty($_REQUEST['prov']) and $_REQUEST['prov'] != $dVal['prov']['default']) $extra .= " and prov like '%{$_REQUEST['prov']}%'"; if (!empty($_REQUEST['pc']) and $_REQUEST['pc'] != $dVal['pc']['default']) $extra .= " and pc like '%{$_REQUEST['pc']}%'"; } $clientList = sqlSelect("clientdat", "cCode != ''$extra", "", "lName, fName"); echo "\n"; echo "
\n"; echo " \n"; echo "
\n"; //C:\htdocs\Aspin\modules\management\createclient.php echo "
\n"; echo "\n"; if (!empty($dVal['cCode']['text']) and !file_exists($_SESSION['instance']['repository']."FSP/{$dVal['cCode']['text']}/")) { $s = ""; if ($_REQUEST['lName'] == "Dollarama") $s = "&dollarama={$_REQUEST['fName']}"; echo "\n"; } else if (!empty($dVal['cCode']['text'])) { $baseDir = $_SESSION['instance']['repository']."FSP/".$dVal['cCode']['text']."/"; echo ""; } //->>>>>>>>>>>>>> echo " \n"; echo "
\n"; echo " \n"; echo " \n"; echo "
\n"; echo " \n"; echo "
\n"; echo " , \n"; echo " , \n"; echo "
\n"; echo "
\n"; if (empty($dVal['cCode']['text'])) echo " "; echo " "; if (!empty($dVal['cCode']['text'])) echo " "; echo "\n"; echo "
\n"; if (!empty($dVal['cCode']['text'])) { //debugDump($dVal, "dVal"); if ($dVal['fName']['text'] == "First Name") $dVal['fName']['text'] = ""; echo "

\n"; echo fixName($dVal['fName']['text'], $dVal['lName']['text'])."
\n"; echo $dVal['address']['text'].", ".$dVal['city']['text']."\n"; if ($_SESSION['user']['empNo'] == 3) { echo "
  \n"; echo "\n"; } } ?>