Menu
▾
▴
[Weberp-cvs] SF.net SVN: web-erp:[3385] trunk
|
From: <tim...@us...> - 2010-03-15 19:42:25
|
Revision: 3385
http://web-erp.svn.sourceforge.net/web-erp/?rev=3385&view=rev
Author: tim_schofield
Date: 2010-03-15 19:42:18 +0000 (Mon, 15 Mar 2010)
Log Message:
-----------
Tim: Layout changes to make SelectCustomer.php SelectProduct.php and SelectSupplier.php have a similar look and feel to them
Modified Paths:
--------------
trunk/AccountSections.php
trunk/SelectCustomer.php
trunk/SelectProduct.php
trunk/SelectSupplier.php
trunk/css/default/default.css
trunk/css/fresh/default.css
trunk/css/gel/default.css
trunk/css/jelly/default.css
trunk/css/professional/default.css
trunk/css/professional-rtl/default.css
trunk/css/silverwolf/default.css
trunk/doc/Change.log.html
Modified: trunk/AccountSections.php
===================================================================
--- trunk/AccountSections.php 2010-03-13 16:22:42 UTC (rev 3384)
+++ trunk/AccountSections.php 2010-03-15 19:42:18 UTC (rev 3385)
@@ -176,7 +176,7 @@
$result = DB_query($sql,$db,$ErrMsg);
echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/maintenance.png" title="' . _('Search') . '" alt="">' . ' ' . $title.'<br>';
- echo "<table>
+ echo "<table name='SectionList'>
<tr>
<th>" . _('Section Number') . "</th>
<th>" . _('Section Description') . "</th>
@@ -200,7 +200,7 @@
} else {
echo '<td><a href="' . $_SERVER['PHP_SELF'] . '?' . SID . '&SelectedSectionID=' . $myrow[0] . '&delete=1">' . _('Delete') .'</a></td>';
}
-
+ echo '</tr>';
} //END WHILE LIST LOOP
echo '</table><p>';
} //end of ifs and buts!
Modified: trunk/SelectCustomer.php
===================================================================
--- trunk/SelectCustomer.php 2010-03-13 16:22:42 UTC (rev 3384)
+++ trunk/SelectCustomer.php 2010-03-15 19:42:18 UTC (rev 3385)
@@ -1,40 +1,35 @@
<?php
/* $Id$*/
-
$PageSecurity = 2;
-
-include('includes/session.inc');
+include ('includes/session.inc');
$title = _('Search Customers');
-include('includes/header.inc');
-include('includes/SQL_CommonFunctions.inc');
-
+include ('includes/header.inc');
+include ('includes/SQL_CommonFunctions.inc');
if (isset($_GET['Select'])) {
- $_SESSION['CustomerID']=$_GET['Select'];
+ $_SESSION['CustomerID'] = $_GET['Select'];
}
-if (!isset($_SESSION['CustomerID'])){ //initialise if not already done
- $_SESSION['CustomerID']="";
+if (!isset($_SESSION['CustomerID'])) { //initialise if not already done
+ $_SESSION['CustomerID'] = "";
}
-
-if ($_SESSION['CustomerID'] =="" or ($_SESSION['CustomerID'] !="" and isset($_POST['Search']))){
- echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/customer.png" title="' . _('Customer') . '" alt="">' . ' ' . _('Customers') . '';
+echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/customer.png" title="' . _('Customer') . '" alt="">' . ' ' . _('Customers') . '';
+if (!isset($_SESSION['CustomerType'])) { //initialise if not already done
+ $_SESSION['CustomerType'] = "";
}
-
-if (!isset($_SESSION['CustomerType'])){ //initialise if not already done
- $_SESSION['CustomerType']="";
-}
// only run geocode if integration is turned on and customer has been selected
-if ($_SESSION['geocode_integration']==1 AND $_SESSION['CustomerID'] !=""){
-
- $sql="SELECT * FROM geocode_param WHERE 1";
+if ($_SESSION['geocode_integration'] == 1 AND $_SESSION['CustomerID'] != "") {
+ $sql = "SELECT * FROM geocode_param WHERE 1";
$ErrMsg = _('An error occurred in retrieving the information');
$result = DB_query($sql, $db, $ErrMsg);
$myrow = DB_fetch_array($result);
- $sql = "SELECT debtorsmaster.debtorno,debtorsmaster.name,custbranch.brname,
- custbranch.lat, custbranch.lng
- FROM debtorsmaster LEFT JOIN custbranch
- ON debtorsmaster.debtorno = custbranch.debtorno
- WHERE debtorsmaster.debtorno = '" . $_SESSION['CustomerID'] . "'
- ORDER BY debtorsmaster.debtorno";
+ $sql = "SELECT debtorsmaster.debtorno,
+ debtorsmaster.name,
+ custbranch.brname,
+ custbranch.lat,
+ custbranch.lng
+ FROM debtorsmaster LEFT JOIN custbranch
+ ON debtorsmaster.debtorno = custbranch.debtorno
+ WHERE debtorsmaster.debtorno = '" . $_SESSION['CustomerID'] . "'
+ ORDER BY debtorsmaster.debtorno";
$ErrMsg = _('An error occurred in retrieving the information');
$result2 = DB_query($sql, $db, $ErrMsg);
$myrow2 = DB_fetch_array($result2);
@@ -46,75 +41,67 @@
$map_height = $myrow['map_height'];
$map_width = $myrow['map_width'];
$map_host = $myrow['map_host'];
-
echo '<script src="http://maps.google.com/maps?file=api&v=2&key=' . $api_key . '"';
echo ' type="text/javascript"></script>';
echo ' <script type="text/javascript">';
- echo ' //<![CDATA[ '; ?>
-
- function load() {
- if (GBrowserIsCompatible()) {
- var map = new GMap2(document.getElementById("map"));
- map.addControl(new GSmallMapControl());
- map.addControl(new GMapTypeControl());
- <?php echo 'map.setCenter(new GLatLng(' . $lat . ', ' . $lng . '), 11);'; ?>
- <?php echo 'var marker = new GMarker(new GLatLng(' . $lat . ', ' . $lng . '));' ?>
- map.addOverlay(marker);
- GEvent.addListener(marker, "click", function() {
- marker.openInfoWindowHtml(WINDOW_HTML);
- });
- marker.openInfoWindowHtml(WINDOW_HTML);
- }
- }
- //]]>
- </script>
- <body onload="load()" onunload="GUnload()">
-
- <?php
+ echo ' //<![CDATA[ ';
+ echo 'function load() {
+ if (GBrowserIsCompatible()) {
+ var map = new GMap2(document.getElementById("map"));
+ map.addControl(new GSmallMapControl());
+ map.addControl(new GMapTypeControl());';
+ echo 'map.setCenter(new GLatLng(' . $lat . ', ' . $lng . '), 11);';
+ echo 'var marker = new GMarker(new GLatLng(' . $lat . ', ' . $lng . '));';
+ echo 'map.addOverlay(marker);
+ GEvent.addListener(marker, "click", function() {
+ marker.openInfoWindowHtml(WINDOW_HTML);
+ });
+ marker.openInfoWindowHtml(WINDOW_HTML);
+ }
+ }
+ //]]>
+ </script>';
+ echo '<body onload="load()" onunload="GUnload()">';
}
-$msg="";
-
+$msg = "";
if (isset($_POST['Go1']) or isset($_POST['Go2'])) {
- $_POST['PageOffset'] = (isset($_POST['Go1']) ? $_POST['PageOffset1'] : $_POST['PageOffset2']);
- $_POST['Go'] = '';
+ $_POST['PageOffset'] = (isset($_POST['Go1']) ? $_POST['PageOffset1'] : $_POST['PageOffset2']);
+ $_POST['Go'] = '';
}
-
if (!isset($_POST['PageOffset'])) {
- $_POST['PageOffset'] = 1;
+ $_POST['PageOffset'] = 1;
} else {
- if ($_POST['PageOffset']==0) {
- $_POST['PageOffset'] = 1;
- }
+ if ($_POST['PageOffset'] == 0) {
+ $_POST['PageOffset'] = 1;
+ }
}
-
-if (isset($_POST['Search']) OR isset($_POST['CSV']) OR isset($_POST['Go']) OR isset($_POST['Next']) OR isset($_POST['Previous'])){
- if (isset($_POST['Search'])){
+if (isset($_POST['Search']) OR isset($_POST['CSV']) OR isset($_POST['Go']) OR isset($_POST['Next']) OR isset($_POST['Previous'])) {
+ if (isset($_POST['Search'])) {
$_POST['PageOffset'] = 1;
}
if ($_POST['Keywords'] AND (($_POST['CustCode']) OR ($_POST['CustPhone']) OR ($_POST['CustType']))) {
- $msg=_('Search Result: Customer Name has been used in search') . '<br>';
+ $msg = _('Search Result: Customer Name has been used in search') . '<br>';
$_POST['Keywords'] = strtoupper($_POST['Keywords']);
}
- if ($_POST['CustCode'] AND $_POST['CustPhone']=="" AND isset($_POST['CustType']) AND $_POST['Keywords']=="") {
- $msg=_('Search Result: Customer Code has been used in search') . '<br>';
+ if ($_POST['CustCode'] AND $_POST['CustPhone'] == "" AND isset($_POST['CustType']) AND $_POST['Keywords'] == "") {
+ $msg = _('Search Result: Customer Code has been used in search') . '<br>';
}
if (($_POST['CustPhone']) AND ($_POST['CustType'])) {
- $msg=_('Search Result: Customer Phone has been used in search') . '<br>';
+ $msg = _('Search Result: Customer Phone has been used in search') . '<br>';
}
if (($_POST['CustAdd']) AND ($_POST['CustType'])) {
- $msg=_('Search Result: Customer Address has been used in search') . '<br>';
+ $msg = _('Search Result: Customer Address has been used in search') . '<br>';
}
- if ($_POST['CustType'] AND $_POST['CustPhone']=="" AND $_POST['CustCode']=="" AND $_POST['Keywords']=="" AND $_POST['CustAdd']==""){
- $msg=_('Search Result: Customer Type has been used in search') . '<br>';
+ if ($_POST['CustType'] AND $_POST['CustPhone'] == "" AND $_POST['CustCode'] == "" AND $_POST['Keywords'] == "" AND $_POST['CustAdd'] == "") {
+ $msg = _('Search Result: Customer Type has been used in search') . '<br>';
}
- if (($_POST['Keywords']=="") AND ($_POST['CustCode']=="") AND ($_POST['CustPhone']=="") AND ($_POST['CustType']=="")) {
-
- $SQL= "SELECT debtorsmaster.debtorno,
+ if (($_POST['Keywords'] == "") AND ($_POST['CustCode'] == "") AND ($_POST['CustPhone'] == "") AND ($_POST['CustType'] == "")) {
+ $SQL = "SELECT debtorsmaster.debtorno,
debtorsmaster.name,
debtorsmaster.address1,
- debtorsmaster.address2,
- debtorsmaster.address3,
- debtorsmaster.address4,
+ debtorsmaster.address2,
+ debtorsmaster.address3,
+ debtorsmaster.address4,
custbranch.brname,
custbranch.contactname,
debtortype.typename,
@@ -123,21 +110,17 @@
FROM debtorsmaster LEFT JOIN custbranch
ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
WHERE debtorsmaster.typeid = debtortype.typeid";
-
} else {
- if (strlen($_POST['Keywords'])>0) {
-
+ if (strlen($_POST['Keywords']) > 0) {
$_POST['Keywords'] = strtoupper(trim($_POST['Keywords']));
-
//insert wildcard characters in spaces
$SearchString = '%' . str_replace(' ', '%', $_POST['Keywords']) . '%';
-
- $SQL = "SELECT debtorsmaster.debtorno,
+ $SQL = "SELECT debtorsmaster.debtorno,
debtorsmaster.name,
debtorsmaster.address1,
- debtorsmaster.address2,
- debtorsmaster.address3,
- debtorsmaster.address4,
+ debtorsmaster.address2,
+ debtorsmaster.address3,
+ debtorsmaster.address4,
custbranch.brname,
custbranch.contactname,
debtortype.typename,
@@ -147,16 +130,14 @@
ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
WHERE debtorsmaster.name " . LIKE . " '$SearchString'
AND debtorsmaster.typeid = debtortype.typeid";
-
- } elseif (strlen($_POST['CustCode'])>0){
-
+ } elseif (strlen($_POST['CustCode']) > 0) {
$_POST['CustCode'] = strtoupper(trim($_POST['CustCode']));
- $SQL = "SELECT debtorsmaster.debtorno,
+ $SQL = "SELECT debtorsmaster.debtorno,
debtorsmaster.name,
debtorsmaster.address1,
- debtorsmaster.address2,
- debtorsmaster.address3,
- debtorsmaster.address4,
+ debtorsmaster.address2,
+ debtorsmaster.address3,
+ debtorsmaster.address4,
custbranch.brname,
custbranch.contactname,
debtortype.typename,
@@ -164,17 +145,15 @@
custbranch.faxno
FROM debtorsmaster LEFT JOIN custbranch
ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
- WHERE debtorsmaster.debtorno " . LIKE . " '%" . $_POST['CustCode'] . "%'
+ WHERE debtorsmaster.debtorno " . LIKE . " '%" . $_POST['CustCode'] . "%'
AND debtorsmaster.typeid = debtortype.typeid";
-
- } elseif (strlen($_POST['CustPhone'])>0){
-
+ } elseif (strlen($_POST['CustPhone']) > 0) {
$SQL = "SELECT debtorsmaster.debtorno,
debtorsmaster.name,
debtorsmaster.address1,
- debtorsmaster.address2,
- debtorsmaster.address3,
- debtorsmaster.address4,
+ debtorsmaster.address2,
+ debtorsmaster.address3,
+ debtorsmaster.address4,
custbranch.brname,
custbranch.contactname,
debtortype.typename,
@@ -182,18 +161,17 @@
custbranch.faxno
FROM debtorsmaster LEFT JOIN custbranch
ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
- WHERE custbranch.phoneno " . LIKE . " '%" . $_POST['CustPhone'] . "%'
+ WHERE custbranch.phoneno " . LIKE . " '%" . $_POST['CustPhone'] . "%'
AND debtorsmaster.typeid = debtortype.typeid";
+ // Added an option to search by address. I tried having it search address1, address2, address3, and address4, but my knowledge of MYSQL is limited. This will work okay if you select the CSV Format then you can search though the address1 field. I would like to extend this to all 4 address fields. Gilles Deacur
-// Added an option to search by address. I tried having it search address1, address2, address3, and address4, but my knowledge of MYSQL is limited. This will work okay if you select the CSV Format then you can search though the address1 field. I would like to extend this to all 4 address fields. Gilles Deacur
- } elseif (strlen($_POST['CustAdd'])>0){
-
+ } elseif (strlen($_POST['CustAdd']) > 0) {
$SQL = "SELECT debtorsmaster.debtorno,
debtorsmaster.name,
debtorsmaster.address1,
- debtorsmaster.address2,
- debtorsmaster.address3,
- debtorsmaster.address4,
+ debtorsmaster.address2,
+ debtorsmaster.address3,
+ debtorsmaster.address4,
custbranch.brname,
custbranch.contactname,
debtortype.typename,
@@ -201,58 +179,48 @@
custbranch.faxno
FROM debtorsmaster LEFT JOIN custbranch
ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
- WHERE debtorsmaster.address1 " . LIKE . " '%" . $_POST['CustAdd'] . "%'
+ WHERE debtorsmaster.address1 " . LIKE . " '%" . $_POST['CustAdd'] . "%'
AND debtorsmaster.typeid = debtortype.typeid";
+ // End added search feature. Gilles Deacur
-// End added search feature. Gilles Deacur
- } elseif (strlen($_POST['CustType'])>0){
-
- $SQL = "SELECT debtorsmaster.debtorno,
- debtorsmaster.name,
- debtorsmaster.address1,
- debtorsmaster.address2,
- debtorsmaster.address3,
- debtorsmaster.address4,
- custbranch.brname,
- custbranch.contactname,
- debtortype.typename,
- custbranch.phoneno,
- custbranch.faxno
- FROM debtorsmaster LEFT JOIN custbranch
- ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
- WHERE debtorsmaster.typeid LIKE debtortype.typeid
- AND debtortype.typename = '" . $_POST['CustType'] . "'";
+ } elseif (strlen($_POST['CustType']) > 0) {
+ $SQL = "SELECT debtorsmaster.debtorno,
+ debtorsmaster.name,
+ debtorsmaster.address1,
+ debtorsmaster.address2,
+ debtorsmaster.address3,
+ debtorsmaster.address4,
+ custbranch.brname,
+ custbranch.contactname,
+ debtortype.typename,
+ custbranch.phoneno,
+ custbranch.faxno
+ FROM debtorsmaster LEFT JOIN custbranch
+ ON debtorsmaster.debtorno = custbranch.debtorno, debtortype
+ WHERE debtorsmaster.typeid LIKE debtortype.typeid
+ AND debtortype.typename = '" . $_POST['CustType'] . "'";
}
} //one of keywords or custcode or custphone was more than a zero length string
- if ($_SESSION['SalesmanLogin']!=''){
- $SQL .= " AND custbranch.salesman='" . $_SESSION['SalesmanLogin'] . "'";
+ if ($_SESSION['SalesmanLogin'] != '') {
+ $SQL.= " AND custbranch.salesman='" . $_SESSION['SalesmanLogin'] . "'";
}
- $SQL .= ' ORDER BY debtorsmaster.name';
+ $SQL.= ' ORDER BY debtorsmaster.name';
$ErrMsg = _('The searched customer records requested cannot be retrieved because');
- $result = DB_query($SQL,$db,$ErrMsg);
- if (DB_num_rows($result)==1){
- $myrow=DB_fetch_array($result);
+ $result = DB_query($SQL, $db, $ErrMsg);
+ if (DB_num_rows($result) == 1) {
+ $myrow = DB_fetch_array($result);
$_POST['Select'] = $myrow['debtorno'];
unset($result);
- } elseif (DB_num_rows($result)==0){
- prnMsg(_('No customer records contain the selected text') . ' - ' . _('please alter your search criteria and try again'),'info');
- echo '<br>';
+ } elseif (DB_num_rows($result) == 0) {
+ prnMsg(_('No customer records contain the selected text') . ' - ' . _('please alter your search criteria and try again'), 'info');
+ echo '<br>';
}
} //end of if search
-
-
-if (!isset($_POST['Select'])){
- $_POST['Select']="";
+if (!isset($_POST['Select'])) {
+ $_POST['Select'] = "";
}
-
-if ($_POST['Select']!="" or
- ($_SESSION['CustomerID']!=""
- and !isset($_POST['Keywords'])
- and !isset($_POST['CustCode'])
- and !isset($_POST['CustType'])
- and !isset($_POST['CustPhone']))) {
-
- if ($_POST['Select']!=""){
+if ($_POST['Select'] != "" or ($_SESSION['CustomerID'] != "" and !isset($_POST['Keywords']) and !isset($_POST['CustCode']) and !isset($_POST['CustType']) and !isset($_POST['CustPhone']))) {
+ if ($_POST['Select'] != "") {
$SQL = "SELECT brname, phoneno FROM custbranch WHERE debtorno='" . $_POST['Select'] . "'";
$_SESSION['CustomerID'] = $_POST['Select'];
} else {
@@ -261,231 +229,167 @@
custbranch.debtorno='" . $_SESSION['CustomerID'] . "' AND
debtorsmaster.debtorno = custbranch.debtorno";
}
-
$ErrMsg = _('The customer name requested cannot be retrieved because');
- $result = DB_query($SQL,$db,$ErrMsg);
-
- if ($myrow=DB_fetch_row($result)){
+ $result = DB_query($SQL, $db, $ErrMsg);
+ if ($myrow = DB_fetch_row($result)) {
$CustomerName = $myrow[0];
$phone = $myrow[1];
}
unset($result);
// Adding customer encoding. Not needed for general use. This is not a recommended upgrade submission. Gilles Deacur
- echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/customer.png" title="' . _('Customer') . '" alt="">' . ' ' . _('Customer') . ' : ' . $_SESSION['CustomerID'] . ' - ' . $CustomerName .' - '. $phone . _(' has been selected') . '</p>';
+ echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/customer.png" title="' . _('Customer') . '" alt="">' . ' ' . _('Customer') . ' : ' . $_SESSION['CustomerID'] . ' - ' . $CustomerName . ' - ' . $phone . _(' has been selected') . '</p>';
echo '<div class="page_help_text">' . _('Select a menu option to operate using this customer') . '.</div><br>';
-
$_POST['Select'] = NULL;
-
- echo '<table BORDER=2 cellpadding=4><tr><th>' . _('Customer Inquiries') . '</th>
- <th>' . _('Customer Maintenance') . '</th></tr>';
-
- echo '<tr><td WIDTH=50% class="menu_group_items">';
+ echo '<table cellpadding=4 width=90%><tr><th width=33%>' . _('Customer Inquiries') . '</th>
+ <th width=33%>' . _('Customer Transactions') . '</th>
+ <th width=33%>' . _('Customer Maintenance') . '</th></tr>';
+ echo '<tr><td valign=top class="select">';
/* Customer Inquiry Options */
echo '<a href="' . $rootpath . '/CustomerInquiry.php?CustomerID=' . $_SESSION['CustomerID'] . '">' . _('Customer Transaction Inquiries') . '</a><br>';
echo '<a href="' . $rootpath . '/Customers.php?DebtorNo=' . $_SESSION['CustomerID'] . '&Modify=No">' . _('View Customer Details') . '</a><br>';
echo '<a href="' . $rootpath . '/PrintCustStatements.php?FromCust=' . $_SESSION['CustomerID'] . '&ToCust=' . $_SESSION['CustomerID'] . '&PrintPDF=Yes">' . _('Print Customer Statement') . '</a><br>';
- echo '<a href="' . $rootpath . '/SelectSalesOrder.php?SelectedCustomer=' . $_SESSION['CustomerID'] . '">' . _('Modify Outstanding Sales Orders') . '</a><br>';
echo '<a href="' . $rootpath . '/SelectCompletedOrder.php?SelectedCustomer=' . $_SESSION['CustomerID'] . '">' . _('Order Inquiries') . '</a><br>';
- echo '<a href="' . $rootpath . '/CustomerAllocations.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . _('Allocate Receipts or Credit Notes') . '</a><br>';
-
wikiLink('Customer', $_SESSION['CustomerID']);
-
- echo '</td><td WIDTH=50% class="menu_group_items">';
-
- echo '<a href="' . $rootpath . '/Customers.php?">' . _('Add a New Customer') . '</a><br>';
+ echo '</td><td valign=top class="select">';
+ echo '<a href="' . $rootpath . '/SelectSalesOrder.php?SelectedCustomer=' . $_SESSION['CustomerID'] . '">' . _('Modify Outstanding Sales Orders') . '</a><br>';
+ echo '<a href="' . $rootpath . '/CustomerAllocations.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . _('Allocate Receipts or Credit Notes') . '</a><br>';
+ echo '</td><td valign=top class=select>';
+ echo '<a href="' . $rootpath . '/Customers.php?">' . _('Add a New Customer') . '</a><br>';
echo '<a href="' . $rootpath . '/Customers.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . _('Modify Customer Details') . '</a><br>';
echo '<a href="' . $rootpath . '/CustomerBranches.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . _('Add/Modify/Delete Customer Branches') . '</a><br>';
-
echo '<a href="' . $rootpath . '/SelectProduct.php">' . _('Special Customer Prices') . '</a><br>';
echo '<a href="' . $rootpath . '/CustEDISetup.php">' . _('Customer EDI Configuration') . '</a><br>';
echo '<a href="' . $rootpath . '/CustLoginSetup.php">' . _('Customer Login Configuration') . '</a>';
-
- echo '</td></tr></table><br>';
+ echo '</td>';
+ echo '</tr></table><br>';
} else {
- echo "<table WIDTH=50% BORDER=2><tr><th>" . _('Customer Inquiries') . "</th>
- <th>" . _('Customer Maintenance') . "</th></tr>";
-
- echo '<tr><td WIDTH=50%>';
-
- echo '</td><td WIDTH=50%>';
- if (!isset($_SESSION['SalesmanLogin']) or $_SESSION['SalesmanLogin']==''){
- echo '<a href="' . $rootpath . '/Customers.php?">' . _('Add a New Customer') . '</a><br>';
- }
+ echo "<table width=90%><tr><th width=33%>" . _('Customer Inquiries') . "</th>
+ <th width=33%>" . _('Customer Transactions') . "</th>
+ <th width=33%>" . _('Customer Maintenance') . "</th></tr>";
+ echo '<tr><td class="select">';
+ echo '</td><td class="select">';
+ echo '</td><td class="select">';
+ if (!isset($_SESSION['SalesmanLogin']) or $_SESSION['SalesmanLogin'] == '') {
+ echo '<a href="' . $rootpath . '/Customers.php?">' . _('Add a New Customer') . '</a><br>';
+ }
echo '</td></tr></table>';
}
-
-?>
-
-<form action="<?php echo $_SERVER['PHP_SELF'] . '?' . SID; ?>" method=post>
-
-<b><div class='centre'><?php echo $msg; ?></div></b>
-<?php echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/magnifier.png" title="' . _('Search') . '" alt="">' . ' ' . _('Search for Customers');
-?>
-<table cellpadding=3 colspan=4>
-<tr>
-<td colspan=2><?php echo _('Enter a partial Name'); ?>:</td>
-<td>
-<?php
+echo '<form action="' . $_SERVER['PHP_SELF'] . '?' . SID . '" method=post>';
+echo "<b><div class='centre'>" . $msg . "</div></b>";
+echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/magnifier.png" title="' . _('Search') . '" alt="">' . ' ' . _('Search for Customers');
+echo "<table cellpadding=3 colspan=4 class=selection>";
+echo "<tr><td colspan=2>" . _('Enter a partial Name') . ":</td><td>";
if (isset($_POST['Keywords'])) {
- ?>
- <input type="Text" name="Keywords" value="<?php echo $_POST['Keywords']?>" size=20 maxlength=25>
- <?php
+ echo '<input type="Text" name="Keywords" value="' . $_POST['Keywords'] . '" size=20 maxlength=25>';
} else {
- ?>
- <input type="Text" name="Keywords" size=20 maxlength=25>
- <?php
+ echo '<input type="Text" name="Keywords" size=20 maxlength=25>';
}
-?>
-</td>
-<td><font size=3><b><?php echo _('OR'); ?></b></font></td>
-<td><?php echo _('Enter a partial Code'); ?>:</td>
-<td>
-<?php
+echo '</td><td><font size=3><b>' . _('OR') . '</b></font></td><td>' . _('Enter a partial Code') . ':</td><td>';
if (isset($_POST['CustCode'])) {
- ?>
- <input type="Text" name="CustCode" value="<?php echo $_POST['CustCode'] ?>" size=15 maxlength=18>
- <?php
+ echo '<input type="Text" name="CustCode" value="' . $_POST['CustCode'] . '" size=15 maxlength=18>';
} else {
- ?>
- <input type="Text" name="CustCode" size=15 maxlength=18>
- <?php
+ echo '<input type="Text" name="CustCode" size=15 maxlength=18>';
}
-?>
-</td></tr><tr>
-<td><font size=3><b><?php echo _('OR'); ?></b></font></td>
-<td><?php echo _('Enter a partial Phone Number'); ?>:</td>
-<td>
-<?php
+echo '</td></tr><tr><td><font size=3><b>' . _('OR') . '</b></font></td><td>' . _('Enter a partial Phone Number') . ':</td><td>';
if (isset($_POST['CustPhone'])) {
- ?>
- <input type="Text" name="CustPhone" value="<?php echo $_POST['CustPhone'] ?>" size=15 maxlength=18>
- <?php
+ echo '<input type="Text" name="CustPhone" value="' . $_POST['CustPhone'] . '" size=15 maxlength=18>';
} else {
- ?>
- <input type="Text" name="CustPhone" size=15 maxlength=18>
- <?php
+ echo '<input type="Text" name="CustPhone" size=15 maxlength=18>';
}
-?>
-</td>
-
-<!-- Added an option to search by address. This will work okay if you select the CSV Format then you can search though the address1 field. I would like to extend this to all 4 address fields. This needs implementation into the warnings and other scripts in this page for full effect. I don't plan on doing this but hope somebody else can take over from here. Gilles Deacur -->
-
-<td><font size=3><b><?php echo _('OR'); ?></b></font></td>
-<td><?php echo _('Enter part of the Address'); ?>:</td>
-<td>
-<?php
+echo '</td>';
+/* Added an option to search by address. This will work okay if you select the CSV Format then you can search though the
+* address1 field. I would like to extend this to all 4 address fields. This needs implementation into the warnings and
+* other scripts in this page for full effect. I don't plan on doing this but hope somebody else can take over from here
+* . Gilles Deacur
+*/
+echo '<td><font size=3><b>' . _('OR') . '</b></font></td><td>' . _('Enter part of the Address') . ':</td><td>';
if (isset($_POST['CustAdd'])) {
- ?>
- <input type="Text" name="CustAdd" value="<?php echo $_POST['CustAdd'] ?>" size=20 maxlength=25>
- <?php
+ echo '<input type="Text" name="CustAdd" value="' . $_POST['CustAdd'] . '" size=20 maxlength=25>';
} else {
- ?>
- <input type="Text" name="CustAdd" size=20 maxlength=25>
- <?php
+ echo '<input type="Text" name="CustAdd" size=20 maxlength=25>';
}
-?>
-</td>
-
-<!-- End addded search feature. Gilles Deacur -->
-
-<td><font size=3><b><?php echo _('OR'); ?></b></font></td>
-<td><?php echo _('Choose a Type'); ?>:</td>
-<td>
-
-<?php
+echo '</td>';
+/* End addded search feature. Gilles Deacur */
+echo '<td><font size=3><b>' . _('OR') . '</b></font></td><td>' . _('Choose a Type') . ':</td><td>';
if (isset($_POST['CustType'])) {
- // Show Customer Type drop down list
- $result2=DB_query('SELECT typeid, typename FROM debtortype ',$db);
- // Error if no customer types setup
- if (DB_num_rows($result2)==0){
- $DataError =1;
- echo '<a href="CustomerTypes.php?" target="_parent">Setup Types</a>';
- echo '<tr><td colspan=2>' . prnMsg(_('No Customer types defined'),'error') . '</td></tr>';
- } else {
- // If OK show select box with option selected
- echo '<select name="CustType">';
- while ($myrow = DB_fetch_array($result2)) {
- if ($_POST['CustType']==$myrow['typename']){
- echo "<option selected VALUE='". $myrow['typename'] . "'>" . $myrow['typename'];
- } else {
- echo "<option VALUE='". $myrow['typename'] . "'>" . $myrow['typename'];
- }
- } //end while loop
- DB_data_seek($result2,0);
- echo '</select></td></tr>';
- }
+ // Show Customer Type drop down list
+ $result2 = DB_query('SELECT typeid, typename FROM debtortype ', $db);
+ // Error if no customer types setup
+ if (DB_num_rows($result2) == 0) {
+ $DataError = 1;
+ echo '<a href="CustomerTypes.php?" target="_parent">Setup Types</a>';
+ echo '<tr><td colspan=2>' . prnMsg(_('No Customer types defined'), 'error') . '</td></tr>';
+ } else {
+ // If OK show select box with option selected
+ echo '<select name="CustType">';
+ while ($myrow = DB_fetch_array($result2)) {
+ if ($_POST['CustType'] == $myrow['typename']) {
+ echo "<option selected value='" . $myrow['typename'] . "'>" . $myrow['typename'];
+ } else {
+ echo "<option value='" . $myrow['typename'] . "'>" . $myrow['typename'];
+ }
+ } //end while loop
+ DB_data_seek($result2, 0);
+ echo '</select></td></tr>';
+ }
} else {
- // No option selected yet, so show Customer Type drop down list
- $result2=DB_query('SELECT typeid, typename FROM debtortype ',$db);
- // Error if no customer types setup
- if (DB_num_rows($result2)==0){
- $DataError =1;
- echo '<a href="CustomerTypes.php?" target="_parent">Setup Types</a>';
- echo '<tr><td colspan=2>' . prnMsg(_('No Customer types defined'),'error') . '</td></tr>'; } else {
+ // No option selected yet, so show Customer Type drop down list
+ $result2 = DB_query('SELECT typeid, typename FROM debtortype ', $db);
+ // Error if no customer types setup
+ if (DB_num_rows($result2) == 0) {
+ $DataError = 1;
+ echo '<a href="CustomerTypes.php?" target="_parent">Setup Types</a>';
+ echo '<tr><td colspan=2>' . prnMsg(_('No Customer types defined'), 'error') . '</td></tr>';
+ } else {
// if OK show select box with available options to choose
echo '<select name="CustType">';
while ($myrow = DB_fetch_array($result2)) {
- echo "<option VALUE='". $myrow['typename'] . "'>" . $myrow['typename'];
+ echo "<option value='" . $myrow['typename'] . "'>" . $myrow['typename'];
} //end while loop
- DB_data_seek($result2,0);
+ DB_data_seek($result2, 0);
echo '</select></td></tr>';
}
}
-?>
-</td>
-</tr>
-</table>
-<br /><div class='centre'>
-<input type=submit name="Search" VALUE="<?php echo _('Search Now'); ?>">
-<input type=submit name="CSV" VALUE="<?php echo _('CSV Format'); ?>">
-</div>
-
-<?php
-if (isset($_SESSION['SalesmanLogin']) and $_SESSION['SalesmanLogin']!=''){
- prnMsg(_('Your account enables you to see only customers allocated to you'),'warn',_('Note: Sales-person Login'));
+echo "</td></tr></table><br />";
+echo '<div class="centre"><input type=submit name="Search" value="' . _('Search Now') . '"><input type=submit name="CSV" value="' . _('CSV Format') . '"></div>';
+if (isset($_SESSION['SalesmanLogin']) and $_SESSION['SalesmanLogin'] != '') {
+ prnMsg(_('Your account enables you to see only customers allocated to you'), 'warn', _('Note: Sales-person Login'));
}
-
if (isset($result)) {
unset($_SESSION['CustomerID']);
- $ListCount=DB_num_rows($result);
- $ListPageMax=ceil($ListCount/$_SESSION['DisplayRecordsMax']);
+ $ListCount = DB_num_rows($result);
+ $ListPageMax = ceil($ListCount / $_SESSION['DisplayRecordsMax']);
if (!isset($_POST['CSV'])) {
if (isset($_POST['Next'])) {
if ($_POST['PageOffset'] < $ListPageMax) {
$_POST['PageOffset'] = $_POST['PageOffset'] + 1;
}
}
-
if (isset($_POST['Previous'])) {
if ($_POST['PageOffset'] > 1) {
$_POST['PageOffset'] = $_POST['PageOffset'] - 1;
}
}
-
- echo "<input type=\"hidden\" name=\"PageOffset\" VALUE=\"". $_POST['PageOffset'] ."\"/>";
-
- if ($ListPageMax >1) {
+ echo "<input type=\"hidden\" name=\"PageOffset\" value=\"" . $_POST['PageOffset'] . "\"/>";
+ if ($ListPageMax > 1) {
echo "<p><div class=centre> " . $_POST['PageOffset'] . ' ' . _('of') . ' ' . $ListPageMax . ' ' . _('pages') . '. ' . _('Go to Page') . ': ';
-
echo '<select name="PageOffset1">';
-
- $ListPage=1;
- while($ListPage <= $ListPageMax) {
+ $ListPage = 1;
+ while ($ListPage <= $ListPageMax) {
if ($ListPage == $_POST['PageOffset']) {
- echo '<option VALUE=' . $ListPage . ' selected>' . $ListPage . '</option>';
+ echo '<option value=' . $ListPage . ' selected>' . $ListPage . '</option>';
} else {
- echo '<option VALUE=' . $ListPage . '>' . $ListPage . '</option>';
+ echo '<option value=' . $ListPage . '>' . $ListPage . '</option>';
}
$ListPage++;
}
echo '</select>
- <input type=submit name="Go1" VALUE="' . _('Go') . '">
- <input type=submit name="Previous" VALUE="' . _('Previous') . '">
- <input type=submit name="Next" VALUE="' . _('Next') . '">';
- echo '</div>';
+ <input type=submit name="Go1" value="' . _('Go') . '">
+ <input type=submit name="Previous" value="' . _('Previous') . '">
+ <input type=submit name="Next" value="' . _('Next') . '">';
+ echo '</div>';
}
-
- echo '<br><table cellpadding=2 colspan=7 BORDER=2>';
+ echo '<br><table cellpadding=2 colspan=7>';
$TableHeader = '<tr>
<th>' . _('Code') . '</th>
<th>' . _('Customer Name') . '</th>
@@ -495,135 +399,97 @@
<th>' . _('Phone') . '</th>
<th>' . _('Fax') . '</th>
</tr>';
-
echo $TableHeader;
$j = 1;
$k = 0; //row counter to determine background colour
- $RowIndex = 0;
+ $RowIndex = 0;
}
- if (DB_num_rows($result)<>0){
-
+ if (DB_num_rows($result) <> 0) {
if (isset($_POST['CSV'])) {
- echo '<br><p class="page_title_text">' . _('Comma Separated Values (CSV) Search Result') . '</p>';
- echo '<div class="page_help_text">' . _('CSV data can be copied and used to import data into software such as a spreadsheet.') . '</div><br>';
- printf("<div class=csv>Code, Customer Name, Address1, Address2, Address3, Address4, Contact, Type, Phone, Fax");
- while ($myrow2=DB_fetch_array($result)) {
- printf("<br>%s,
- %s,
- %s,
- %s,
- %s,
- %s,
- %s,
- %s,
- %s,
- %s",
- $myrow2['debtorno'],
- str_replace(',', '',$myrow2['name']),
- str_replace(',', '',$myrow2['address1']),
- str_replace(',', '',$myrow2['address2']),
- str_replace(',', '',$myrow2['address3']),
- str_replace(',', '',$myrow2['address4']),
- str_replace(',', '',$myrow2['contactname']),
- str_replace(',', '',$myrow2['typename']),
- $myrow2['phoneno'],
- $myrow2['faxno']);
-
+ $FileName = $_SESSION['reports_dir'] . '/Customer_Listing_' . Date('Y-m-d') . '.csv';
+ echo '<br><p class="page_title_text"><a href="' . $FileName . '">' . _('Click to view the csv Search Result') . '</p>';
+ $fp = fopen($FileName, 'w');
+ while ($myrow2 = DB_fetch_array($result)) {
+ fwrite($fp, $myrow2['debtorno'] . ',' . str_replace(',', '', $myrow2['name']) . ',' . str_replace(',', '', $myrow2['address1']) . ',' . str_replace(',', '', $myrow2['address2']) . ',' . str_replace(',', '', $myrow2['address3']) . ',' . str_replace(',', '', $myrow2['address4']) . ',' . str_replace(',', '', $myrow2['contactname']) . ',' . str_replace(',', '', $myrow2['typename']) . ',' . $myrow2['phoneno'] . ',' . $myrow2['faxno'] . "\n");
}
- echo '</div>';
+ echo '</div>';
}
if (!isset($_POST['CSV'])) {
- DB_data_seek($result, ($_POST['PageOffset']-1)*$_SESSION['DisplayRecordsMax']);
- }
-
- while (($myrow=DB_fetch_array($result)) AND ($RowIndex <> $_SESSION['DisplayRecordsMax'])) {
-
- if ($k==1){
+ DB_data_seek($result, ($_POST['PageOffset'] - 1) * $_SESSION['DisplayRecordsMax']);
+ }
+ while (($myrow = DB_fetch_array($result)) AND ($RowIndex <> $_SESSION['DisplayRecordsMax'])) {
+ if ($k == 1) {
echo '<tr class="EvenTableRows">';
- $k=0;
+ $k = 0;
} else {
echo '<tr class="OddTableRows">';
- $k=1;
+ $k = 1;
}
-
- printf("<td><font size=1><input type=submit name='Select' VALUE='%s'</font></td>
- <td><font size=1>%s</font></td>
- <td><font size=1>%s</font></td>
- <td><font size=1>%s</font></td>
- <td><font size=1>%s</font></td>
- <td><font size=1>%s</font></td>
- <td><font size=1>%s</font></td></tr>",
- $myrow['debtorno'],
- $myrow['name'],
- $myrow['brname'],
- $myrow['contactname'],
- $myrow['typename'],
- $myrow['phoneno'],
- $myrow['faxno']);
-
+ echo "<td><font size=1><input type=submit name='Select' value='" . $myrow['debtorno'] . "'</font></td>
+ <td><font size=1>" . $myrow['name'] . "</font></td>
+ <td><font size=1>" . $myrow['brname'] . "</font></td>
+ <td><font size=1>" . $myrow['contactname'] . "</font></td>
+ <td><font size=1>" . $myrow['typename'] . "</font></td>
+ <td><font size=1>" . $myrow['phoneno'] . "</font></td>
+ <td><font size=1>" . $myrow['faxno'] . "</font></td></tr>";
$j++;
- if ($j == 11 AND ($RowIndex+1 != $_SESSION['DisplayRecordsMax'])){
- $j=1;
+ if ($j == 11 AND ($RowIndex + 1 != $_SESSION['DisplayRecordsMax'])) {
+ $j = 1;
echo $TableHeader;
}
+ $RowIndex++;
+ //end of page full new headings if
- $RowIndex++;
-//end of page full new headings if
}
//end of while loop
echo '</table>';
}
}
-
//end if results to show
if (!isset($_POST['CSV'])) {
- if (isset($ListPageMax) and $ListPageMax>1) {
+ if (isset($ListPageMax) and $ListPageMax > 1) {
echo "<p><div class=centre> " . $_POST['PageOffset'] . ' ' . _('of') . ' ' . $ListPageMax . ' ' . _('pages') . '. ' . _('Go to Page') . ': ';
-
echo '<select name="PageOffset2">';
-
- $ListPage=1;
- while($ListPage <= $ListPageMax) {
+ $ListPage = 1;
+ while ($ListPage <= $ListPageMax) {
if ($ListPage == $_POST['PageOffset']) {
- echo '<option VALUE=' . $ListPage . ' selected>' . $ListPage . '</option>';
+ echo '<option value=' . $ListPage . ' selected>' . $ListPage . '</option>';
} else {
- echo '<option VALUE=' . $ListPage . '>' . $ListPage . '</option>';
+ echo '<option value=' . $ListPage . '>' . $ListPage . '</option>';
}
$ListPage++;
}
echo '</select>
- <input type=submit name="Go2" VALUE="' . _('Go') . '">
- <input type=submit name="Previous" VALUE="' . _('Previous') . '">
- <input type=submit name="Next" VALUE="' . _('Next') . '">';
+ <input type=submit name="Go2" value="' . _('Go') . '">
+ <input type=submit name="Previous" value="' . _('Previous') . '">
+ <input type=submit name="Next" value="' . _('Next') . '">';
}
//end if results to show
echo '</div></form>';
}
-
// Only display the geocode map if the integration is turned on, and there is a latitude/longitude to display
-if (isset($_SESSION['CustomerID']) and $_SESSION['CustomerID']!="") {
- if ($_SESSION['geocode_integration']==1){
+if (isset($_SESSION['CustomerID']) and $_SESSION['CustomerID'] != "") {
+ if ($_SESSION['geocode_integration'] == 1) {
echo '<br>';
- if ($lat ==0){
+ if ($lat == 0) {
echo '<div class="centre">' . _('Mapping is enabled, but no Mapping data to display for this Customer.') . '</div>';
} else {
echo '<tr><td colspan=2>';
- echo '<table WIDTH=45% colspan=2 BORDER=2 cellpadding=4>';
- echo "<tr><th WIDTH=33%>" . _('Customer Mapping') . "</th></tr>";
- echo '</td><td VALIGN=TOp>'; /* Mapping */
+ echo '<table width=45% colspan=2 cellpadding=4>';
+ echo "<tr><th width=33%>" . _('Customer Mapping') . "</th></tr>";
+ echo '</td><td valign=TOp>'; /* Mapping */
echo '<div class="centre"' . _('Mapping is enabled, Map will display below.') . '</div>';
- echo '<div align="center" id="map" style="width: '. $map_width . 'px; height: ' . $map_height . 'px"></div><br>';
+ echo '<div align="center" id="map" style="width: ' . $map_width . 'px; height: ' . $map_height . 'px"></div><br>';
echo "</th></tr></table>";
}
}
// Extended Customer Info only if selected in Configuration
- if ($_SESSION['Extended_CustomerInfo']==1){
- if ($_SESSION['CustomerID']!=""){
+ if ($_SESSION['Extended_CustomerInfo'] == 1) {
+ if ($_SESSION['CustomerID'] != "") {
$sql = "SELECT debtortype.typeid, debtortype.typename
- FROM debtorsmaster, debtortype
+ FROM debtorsmaster, debtortype
WHERE debtorsmaster.typeid = debtortype.typeid
- AND debtorsmaster.debtorno = '" . $_SESSION['CustomerID'] . "'
- ";
+ AND debtorsmaster.debtorno = '" . $_SESSION['CustomerID'] . "'";
$ErrMsg = _('An error occurred in retrieving the information');
$result = DB_query($sql, $db, $ErrMsg);
$myrow = DB_fetch_array($result);
@@ -636,187 +502,150 @@
(TO_DAYS(date(now())) - TO_DAYS(date(debtorsmaster.clientsince))) as customersincedays,
(TO_DAYS(date(now())) - TO_DAYS(date(debtorsmaster.lastpaiddate))) as lastpaiddays,
debtorsmaster.paymentterms, debtorsmaster.lastpaid, debtorsmaster.lastpaiddate
- FROM debtorsmaster
- WHERE debtorsmaster.debtorno ='" . $_SESSION['CustomerID'] . "'";
- $DataResult = DB_query($SQL,$db);
- $myrow = DB_fetch_array($DataResult);
+ FROM debtorsmaster
+ WHERE debtorsmaster.debtorno ='" . $_SESSION['CustomerID'] . "'";
+ $DataResult = DB_query($SQL, $db);
+ $myrow = DB_fetch_array($DataResult);
// Select some more data about the customer
$SQL = "select sum(ovamount+ovgst) as total from debtortrans where debtorno = '" . $_SESSION['CustomerID'] . "' and type !=12";
- $Total1Result = DB_query($SQL,$db);
- $row = DB_fetch_array($Total1Result);
+ $Total1Result = DB_query($SQL, $db);
+ $row = DB_fetch_array($Total1Result);
echo '<tr><td colspan=2>';
- echo '<table WIDTH=45% colspan=2 BORDER=2 cellpadding=4>';
- echo "<tr><th WIDTH=33%>" . _('Customer Data') . "</th></tr>";
- echo '<tr><td VALIGN=TOp>'; /* Customer Data */
+ echo '<table width=45% colspan=2 cellpadding=4>';
+ echo "<tr><th width=33% colspan=3>" . _('Customer Data') . "</th></tr>";
+ echo '<tr><td valign=top class=select>'; /* Customer Data */
//echo _('Distance to this customer:') . '<b>TBA</b><br>';
- if ($myrow['lastpaiddate'] ==0) {
- echo _('Never paid from this customer.') . '<br>';
+ if ($myrow['lastpaiddate'] == 0) {
+ echo _('No receipts from this customer.') . '</td><td class=select></td><td class=select></td></tr>';
} else {
- echo _('Last Paid Date:') . ' <b>' . ConvertSQLDate($myrow['lastpaiddate']) . '</b> ' . $myrow['lastpaiddays'] . ' ' . _('days') . '<br>';
+ echo _('Last Paid Date:') . '</td><td class=select> <b>' . ConvertSQLDate($myrow['lastpaiddate']) . '</b> </td><td class=select>' . $myrow['lastpaiddays'] . ' ' . _('days') . '</td></tr>';
}
- echo _('Last Paid Amount (inc tax):') . ' <b>' . number_format($myrow['lastpaid'],2) . '</b><br>';
- echo _('Customer since:') . ' <b>' . ConvertSQLDate($myrow['clientsince']) . '</b> ' . $myrow['customersincedays'] . ' ' . _('days') . '<br>';
- if ($row['total'] ==0) {
- echo _('No Spend from this Customer.') . '</b><br>';
+ echo '<tr><td class=select>' . _('Last Paid Amount (inc tax):') . '</td><td class=select> <b>' . number_format($myrow['lastpaid'], 2) . '</b></td><td class=select></td></tr>';
+ echo '<tr><td class=select>' . _('Customer since:') . '</td><td class=select> <b>' . ConvertSQLDate($myrow['clientsince']) . '</b> </td><td class=select>' . $myrow['customersincedays'] . ' ' . _('days') . '</td></tr>';
+ if ($row['total'] == 0) {
+ echo '<tr><td class=select>' . _('No Spend from this Customer.') . '</b></td><td class=select></td><td class=select></td></tr>';
} else {
- echo _('Total Spend from this Customer (inc tax):') . ' <b>' . number_format($row['total'],2) . '</b><br>';
+ echo '<tr><td class=select>' . _('Total Spend from this Customer (inc tax):') . ' </td><td class=select><b>' . number_format($row['total'], 2) . '</b></td><td class=select></td></tr>';
}
- echo _('Customer Type:') . ' <b>' . $CustomerTypeName . '</b><br>';
+ echo '<tr><td class=select>' . _('Customer Type:') . ' </td><td class=select><b>' . $CustomerTypeName . '</b></td><td class=select></td></tr>>';
echo '</th></tr></table>';
}
// Customer Contacts
echo '<tr><td colspan=2>';
- $sql = 'SELECT * FROM custcontacts where debtorno="' . $_SESSION['CustomerID'] . '" ORDER BY contid';
- $result = DB_query($sql,$db);
- if (DB_num_rows($result)<>0){
- echo '<br><div class="centre"><img src="'.$rootpath.'/css/'.$theme.'/images/group_add.png" title="' . _('Customer Contacts') . '" alt="">' . ' ' . _('Customer Contacts') . '</div><br>';
- echo '<table border=1 width=45%>';
+ $sql = 'SELECT * FROM custcontacts where debtorno="' . $_SESSION['CustomerID'] . '" ORDER BY contid';
+ $result = DB_query($sql, $db);
+ if (DB_num_rows($result) <> 0) {
+ echo '<table width=45%>';
+ echo '<br><th colspan=7><img src="' . $rootpath . '/css/' . $theme . '/images/group_add.png" title="' . _('Customer Contacts') . '" alt="">' . ' ' . _('Customer Contacts') . '</th>';
echo '<tr>
- <th>' . _('Name') . '</th>
- <th>' . _('Role') . '</th>
- <th>' . _('Phone Number') . '</th>
- <th>' . _('Notes') . '</th>
- <th>' . _('Edit') . '</th>
- <th>' . _('Delete') . '</th>
+ <th>' . _('Name') . '</th>
+ <th>' . _('Role') . '</th>
+ <th>' . _('Phone Number') . '</th>
+ <th>' . _('Notes') . '</th>
+ <th>' . _('Edit') . '</th>
+ <th>' . _('Delete') . '</th>
<th> <a href="AddCustomerContacts.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . _('Add New Contact') . '</a> </th></tr>';
- $k=0; //row colour counter
- while ($myrow = DB_fetch_array($result)) {
- if ($k==1){
+ $k = 0; //row colour counter
+ while ($myrow = DB_fetch_array($result)) {
+ if ($k == 1) {
echo '<tr class="OddTableRows">';
- $k=0;
+ $k = 0;
} else {
echo '<tr class="EvenTableRows">';
- $k=1;
+ $k = 1;
}
- printf('<td>%s</td>
- <td>%s</td>
- <td>%s</td>
- <td>%s</td>
- <td><a href="AddCustomerContacts.php?Id=%s&DebtorNo=%s">'. _('Edit'). '</a></td>
- <td><a href="AddCustomerContacts.php?Id=%s&DebtorNo=%s&delete=1">'. _('Delete'). '</a></td>
- </tr>',
- $myrow[2],
- $myrow[3],
- $myrow[4],
- $myrow[5],
- $myrow[0],
- $myrow[1],
- $myrow[0],
- $myrow[1],
- $myrow[1]);
-
- }//END WHILE LIST LOOP
+ echo '<td>' . $myrow[2] . '</td>
+ <td>' . $myrow[3] . '</td>
+ <td>' . $myrow[4] . '</td>
+ <td>' . $myrow[5] . '</td>
+ <td><a href="AddCustomerContacts.php?Id=' . $myrow[0] . '&DebtorNo=' . $myrow[1] . '">' . _('Edit') . '</a></td>
+ <td><a href="AddCustomerContacts.php?Id=' . $myrow[0] . '&DebtorNo=' . $myrow[1] . '&delete=1">' . _('Delete') . '</a></td>
+ </tr>';
+ } //END WHILE LIST LOOP
echo '</table>';
} else {
- if ($_SESSION['CustomerID']!=""){
- echo '<br><div class="centre"><img src="'.$rootpath.'/css/'.$theme.'/images/group_add.png" title="' . _('Customer Contacts') . '" alt=""><a href="AddCustomerContacts.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Contact') . '</a></div>';
+ if ($_SESSION['CustomerID'] != "") {
+ echo '<br><div class="centre"><img src="' . $rootpath . '/css/' . $theme . '/images/group_add.png" title="' . _('Customer Contacts') . '" alt=""><a href="AddCustomerContacts.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Contact') . '</a></div>';
}
}
// Customer Notes
echo '<tr><td colspan=2>';
- $sql = 'SELECT * FROM custnotes where debtorno="' . $_SESSION['CustomerID'] . '" ORDER BY date DESC';
- $result = DB_query($sql,$db);
- if (DB_num_rows($result)<>0){
- echo '<br><div class="centre"><img src="'.$rootpath.'/css/'.$theme.'/images/note_add.png" title="' . _('Customer Notes') . '" alt="">' . ' ' . _('Customer Notes') . '</div><br>';
- echo '<table border=1 width=45%>';
- echo '<tr>
- <th>' . _('date') . '</th>
- <th>' . _('note') . '</th>
- <th>' . _('hyperlink') . '</th>
- <th>' . _('priority') . '</th>
- <th>' . _('Edit') . '</th>
- <th>' . _('Delete') . '</th>
- <th> <a href="AddCustomerNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Note') . '</a> </th></tr>';
- $k=0; //row colour counter
- while ($myrow = DB_fetch_array($result)) {
- if ($k==1){
- echo '<tr class="OddTableRows">';
- $k=0;
- } else {
- echo '<tr class="EvenTableRows">';
- $k=1;
- }
- printf('<td>%s</td>
- <td>%s</td>
- <td>%s</td>
- <td>%s</td>
- <td><a href="AddCustomerNotes.php?Id=%s&DebtorNo=%s">'. _('Edit'). '</a></td>
- <td><a href="AddCustomerNotes.php?Id=%s&DebtorNo=%s&delete=1">'. _('Delete'). '</a></td>
- </tr>',
- $myrow[4],
- $myrow[3],
- $myrow[2],
- $myrow[5],
- $myrow[0],
- $myrow[1],
- $myrow[0],
- $myrow[1],
- $myrow[1]);
- }//END WHILE LIST LOOP
- echo '</table>';
+ $sql = 'SELECT * FROM custnotes where debtorno="' . $_SESSION['CustomerID'] . '" ORDER BY date DESC';
+ $result = DB_query($sql, $db);
+ if (DB_num_rows($result) <> 0) {
+ echo '<br><div class="centre"><img src="' . $rootpath . '/css/' . $theme . '/images/note_add.png" title="' . _('Customer Notes') . '" alt="">' . ' ' . _('Customer Notes') . '</div><br>';
+ echo '<table width=45%>';
+ echo '<tr>
+ <th>' . _('date') . '</th>
+ <th>' . _('note') . '</th>
+ <th>' . _('hyperlink') . '</th>
+ <th>' . _('priority') . '</th>
+ <th>' . _('Edit') . '</th>
+ <th>' . _('Delete') . '</th>
+ <th> <a href="AddCustomerNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Note') . '</a> </th></tr>';
+ $k = 0; //row colour counter
+ while ($myrow = DB_fetch_array($result)) {
+ if ($k == 1) {
+ echo '<tr class="OddTableRows">';
+ $k = 0;
+ } else {
+ echo '<tr class="EvenTableRows">';
+ $k = 1;
+ }
+ echo '<td>' . $myrow[4] . '</td>
+ <td>' . $myrow[3] . '</td>
+ <td>' . $myrow[2] . '</td>
+ <td>' . $myrow[5] . '</td>
+ <td><a href="AddCustomerNotes.php?Id=' . $myrow[0] . '&DebtorNo=' . $myrow[1] . '">' . _('Edit') . '</a></td>
+ <td><a href="AddCustomerNotes.php?Id=' . $myrow[0] . '&DebtorNo=' . $myrow[1] . '&delete=1">' . _('Delete') . '</a></td>
+ </tr>';
+ } //END WHILE LIST LOOP
+ echo '</table>';
} else {
- if ($_SESSION['CustomerID']!=""){
- echo '<br><div class="centre"><img src="'.$rootpath.'/css/'.$theme.'/images/note_add.png" title="' . _('Customer Notes') . '" alt=""><a href="AddCustomerNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Note for this Customer') . '</a></div>';
+ if ($_SESSION['CustomerID'] != "") {
+ echo '<br><div class="centre"><img src="' . $rootpath . '/css/' . $theme . '/images/note_add.png" title="' . _('Customer Notes') . '" alt=""><a href="AddCustomerNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Note for this Customer') . '</a></div>';
}
}
// Custome Type Notes
echo '<tr><td colspan=2>';
- $sql = 'SELECT * FROM debtortypenotes where typeid="' . $CustomerType . '" ORDER BY date DESC';
- $result = DB_query($sql,$db);
- if (DB_num_rows($result)<>0){
- echo '<br><div class="centre"><img src="'.$rootpath.'/css/'.$theme.'/images/folder_add.png" title="' . _('Customer Type (Group) Notes') . '" alt="">' . ' ' . _('Customer Type (Group) Notes for:' . '<b> ' . $CustomerTypeName . '</b>') . '</div><br>';
- echo '<table border=1 width=45%>';
- echo '<tr>
- <th>' . _('date') . '</th>
- <th>' . _('note') . '</th>
- <th>' . _('file link / reference / URL') . '</th>
- <th>' . _('priority') . '</th>
- <th>' . _('Edit') . '</th>
- <th>' . _('Delete') . '</th>
- <th><a href="AddCustomerTypeNotes.php?DebtorType=' . $CustomerType . '">' . _('Add New Group Note') . '</a></th></tr>';
- $k=0; //row colour counter
- while ($myrow = DB_fetch_array($result)) {
- if ($k==1){
+ $sql = 'SELECT * FROM debtortypenotes where typeid="' . $CustomerType . '" ORDER BY date DESC';
+ $result = DB_query($sql, $db);
+ if (DB_num_rows($result) <> 0) {
+ echo '<br><div class="centre"><img src="' . $rootpath . '/css/' . $theme . '/images/folder_add.png" title="' . _('Customer Type (Group) Notes') . '" alt="">' . ' ' . _('Customer Type (Group) Notes for:' . '<b> ' . $CustomerTypeName . '</b>') . '</div><br>';
+ echo '<table width=45%>';
+ echo '<tr>
+ <th>' . _('date') . '</th>
+ <th>' . _('note') . '</th>
+ <th>' . _('file link / reference / URL') . '</th>
+ <th>' . _('priority') . '</th>
+ <th>' . _('Edit') . '</th>
+ <th>' . _('Delete') . '</th>
+ <th><a href="AddCustomerTypeNotes.php?DebtorType=' . $CustomerType . '">' . _('Add New Group Note') . '</a></th></tr>';
+ $k = 0; //row colour counter
+ while ($myrow = DB_fetch_array($result)) {
+ if ($k == 1) {
echo '<tr class="OddTableRows">';
- $k=0;
- } else {
+ $k = 0;
+ } else {
echo '<tr class="EvenTableRows">';
- $k=1;
- }
- printf('<td>%s</td>
- <td>%s</td>
- <td>%s</td>
- <td>%s</td>
- <td><a href="AddCustomerTypeNotes.php?Id=%s&DebtorType=%s">'. _('Edit'). '</a></td>
- <td><a href="AddCustomerTypeNotes.php?Id=%s&DebtorType=%s&delete=1">'. _('Delete'). '</a></td>
- </tr>',
- $myrow[4],
- $myrow[3],
- $myrow[2],
- $myrow[5],
- $myrow[0],
- $myrow[1],
- $myrow[0],
- $myrow[1],
- $myrow[1]);
-
- }//END WHILE LIST LOOP
- echo '</table>';
+ $k = 1;
+ }
+ echo '<td>' . $myrow[4] . '</td>
+ <td>' . $myrow[3] . '</td>
+ <td>' . $myrow[2] . '</td>
+ <td>' . $myrow[5] . '</td>
+ <td><a href="AddCustomerTypeNotes.php?Id=' . $myrow[0] . '&DebtorType=' . $myrow[1] . '">' . _('Edit') . '</a></td>
+ <td><a href="AddCustomerTypeNotes.php?Id=' . $myrow[0] . '&DebtorType=' . $myrow[1] . '&delete=1">' . _('Delete') . '</a></td>
+ </tr>';
+ } //END WHILE LIST LOOP
+ echo '</table>';
} else {
- if ($_SESSION['CustomerID']!=""){
- echo '<br><div class="centre"><img src="'.$rootpath.'/css/'.$theme.'/images/folder_add.png" title="' . _('Customer Group Notes') . '" alt=""><a href="AddCustomerTypeNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Group Note') . '</a></div><br>';
+ if ($_SESSION['CustomerID'] != "") {
+ echo '<br><div class="centre"><img src="' . $rootpath . '/css/' . $theme . '/images/folder_add.png" title="' . _('Customer Group Notes') . '" alt=""><a href="AddCustomerTypeNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Group Note') . '</a></div><br>';
}
}
}
}
-
-include('includes/footer.inc');
-?>
-<script language="JavaScript" type="text/javascript">
- //<![CDATA[
- <!--
- document.forms[0].CustCode.select();
- document.forms[0].CustCode.focus();
- //-->
- //]]>
-</script>
+echo "<script>defaultControl(document.forms[0].CustCode);</script>";
+include ('includes/footer.inc');
+?>
\ No newline at end of file
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2010-03-13 16:22:42 UTC (rev 3384)
+++ trunk/SelectProduct.php 2010-03-15 19:42:18 UTC (rev 3385)
@@ -1,471 +1,122 @@
<?php
/* $Id$*/
-
$PageSecurity = 2;
$PricesSecurity = 9;
-
-include('includes/session.inc');
-
+include ('includes/session.inc');
$title = _('Search Inventory Items');
-
-include('includes/header.inc');
-
+include ('includes/header.inc');
$msg = '';
-
if (isset($_GET['StockID'])) {
- //The page is called with a StockID
- $_GET['StockID'] = trim(strtoupper($_GET['StockID']));
- $_POST['Select'] = trim(strtoupper($_GET['StockID']));
+ //The page is called with a StockID
+ $_GET['StockID'] = trim(strtoupper($_GET['StockID']));
+ $_POST['Select'] = trim(strtoupper($_GET['StockID']));
}
-
+echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/customer.png" title="' . _('Inventory Items') . '" alt="">' . ' ' . _('Inventory Items') . '';
if (isset($_GET['NewSearch'])) {
- unset($StockID);
- unset($_SESSION['SelectedStockItem']);
- unset($_POST['Select']);
+ unset($StockID);
+ unset($_SESSION['SelectedStockItem']);
+ unset($_POST['Select']);
}
-
if (!isset($_POST['PageOffset'])) {
- $_POST['PageOffset'] = 1;
+ $_POST['PageOffset'] = 1;
} else {
- if ($_POST['PageOffset'] == 0) {
- $_POST['PageOffset'] = 1;
- }
+ if ($_POST['PageOffset'] == 0) {
+ $_POST['PageOffset'] = 1;
+ }
}
-
if (isset($_POST['StockCode'])) {
- $_POST['StockCode'] = trim(strtoupper($_POST['StockCode']));
+ $_POST['StockCode'] = trim(strtoupper($_POST['StockCode']));
}
-
// Always show the search facilities
-
-$SQL='SELECT categoryid,
- categorydescription
- FROM stockcategory
- ORDER BY categorydescription';
-
-$result1 = DB_query($SQL,$db);
+$SQL = 'SELECT categoryid,
+ categorydescription
+ FROM stockcategory
+ ORDER BY categorydescription';
+$result1 = DB_query($SQL, $db);
if (DB_num_rows($result1) == 0) {
- echo '<p><font size=4 color=red>' . _('Problem Report') . ':</font><br>' . _('There are no stock categories currently defined please use the link below to set them up');
- echo '<br><a href="' . $rootpath . '/StockCategories.php?' . SID .'">' . _('Define Stock Categories') . '</a>';
- exit;
+ echo '<p><font size=4 color=red>' . _('Problem Report') . ':</font><br>' . _('There are no stock categories currently defined please use the link below to set them up');
+ echo '<br><a href="' . $rootpath . '/StockCategories.php?' . SID . '">' . _('Define Stock Categories') . '</a>';
+ exit;
}
-
-echo '<form action="'. $_SERVER['PHP_SELF'] . '?' . SID .'" method=post>';
-echo '<b>' . $msg . '</b>';
-echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/magnifier.png" title="' . _('Search') . '" alt="">' . ' ' . _('Search for Inventory Items');
-echo '<table><tr>';
-echo '<td>'. _('In Stock Category') . ':';
-echo '<select name="StockCat">';
-
-if (!isset($_POST['StockCat'])) {
- $_POST['StockCat'] = "";
-}
-
-if ($_POST['StockCat'] == "All") {
- echo '<option selected value="All">' . _('All');
-} else {
- echo '<option value="All">' . _('All');
-}
-
-while ($myrow1 = DB_fetch_array($result1)) {
- if ($myrow1['categoryid'] == $_POST['StockCat']) {
- echo '<option selected VALUE="' . $myrow1['categoryid'] . '">' . $myrow1['categorydescription'];
- } else {
- echo '<option value="' . $myrow1['categoryid'] . '">' . $myrow1['categorydescript...
[truncated message content] |
