Menu
▾
▴
web-erp-svn
|
From: <Ex...@us...> - 2012-02-07 04:50:24
|
Revision: 4879
http://web-erp.svn.sourceforge.net/web-erp/?rev=4879&view=rev
Author: ExsonQu
Date: 2012-02-07 04:50:18 +0000 (Tue, 07 Feb 2012)
Log Message:
-----------
Add NewTransfer=true to fix StockTranfer.php 'The entered item code doesnnot exit' bug reported by PakRichard
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-02-06 18:46:31 UTC (rev 4878)
+++ trunk/SelectProduct.php 2012-02-07 04:50:18 UTC (rev 4879)
@@ -425,7 +425,7 @@
/* Stock Transactions */
if ($Its_A_Kitset_Assembly_Or_Dummy == false) {
echo '<a href="' . $rootpath . '/StockAdjustments.php?StockID=' . $StockID . '">' . _('Quantity Adjustments') . '</a><br />';
- echo '<a href="' . $rootpath . '/StockTransfers.php?StockID=' . $StockID . '">' . _('Location Transfers') . '</a><br />';
+ echo '<a href="' . $rootpath . '/StockTransfers.php?StockID=' . $StockID . '&NewTransfer=true">' . _('Location Transfers') . '</a><br />';
//show the item image if it has been uploaded
if( isset($StockID) AND file_exists($_SESSION['part_pics_dir'] . '/' .$StockID.'.jpg') ) {
echo '<div class="centre"><img src="' . $rootpath . '/GetStockImage.php?automake=1&textcolor=FFFFF0&bgcolor=007F00&StockID=' . $StockID . '&text=' . $StockID . '&width=120&height=120" />';
@@ -786,4 +786,4 @@
}
/* end display list if there is more than one record */
include ('includes/footer.inc');
-?>
\ No newline at end of file
+?>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <Ex...@us...> - 2012-02-07 04:50:24
|
Revision: 4879
http://web-erp.svn.sourceforge.net/web-erp/?rev=4879&view=rev
Author: ExsonQu
Date: 2012-02-07 04:50:18 +0000 (Tue, 07 Feb 2012)
Log Message:
-----------
Add NewTransfer=true to fix StockTranfer.php 'The entered item code doesnnot exit' bug reported by PakRichard
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-02-06 18:46:31 UTC (rev 4878)
+++ trunk/SelectProduct.php 2012-02-07 04:50:18 UTC (rev 4879)
@@ -425,7 +425,7 @@
/* Stock Transactions */
if ($Its_A_Kitset_Assembly_Or_Dummy == false) {
echo '<a href="' . $rootpath . '/StockAdjustments.php?StockID=' . $StockID . '">' . _('Quantity Adjustments') . '</a><br />';
- echo '<a href="' . $rootpath . '/StockTransfers.php?StockID=' . $StockID . '">' . _('Location Transfers') . '</a><br />';
+ echo '<a href="' . $rootpath . '/StockTransfers.php?StockID=' . $StockID . '&NewTransfer=true">' . _('Location Transfers') . '</a><br />';
//show the item image if it has been uploaded
if( isset($StockID) AND file_exists($_SESSION['part_pics_dir'] . '/' .$StockID.'.jpg') ) {
echo '<div class="centre"><img src="' . $rootpath . '/GetStockImage.php?automake=1&textcolor=FFFFF0&bgcolor=007F00&StockID=' . $StockID . '&text=' . $StockID . '&width=120&height=120" />';
@@ -786,4 +786,4 @@
}
/* end display list if there is more than one record */
include ('includes/footer.inc');
-?>
\ No newline at end of file
+?>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <tim...@us...> - 2012-02-18 20:53:02
|
Revision: 4924
http://web-erp.svn.sourceforge.net/web-erp/?rev=4924&view=rev
Author: tim_schofield
Date: 2012-02-18 20:52:55 +0000 (Sat, 18 Feb 2012)
Log Message:
-----------
Corrections to column ordering
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-02-18 20:52:22 UTC (rev 4923)
+++ trunk/SelectProduct.php 2012-02-18 20:52:55 UTC (rev 4924)
@@ -79,7 +79,7 @@
<tr>
<th colspan="3"><img src="' . $rootpath . '/css/' . $theme . '/images/inventory.png" title="' . _('Inventory') . '" alt="" /><b>' . ' ' . $StockID . ' - ' . $myrow['description'] . ' ' . $ItemStatus . '</b></th>
</tr>';
-
+
echo '<tr>
<td width="40%" valign="top">
<table align="left">'; //nested table
@@ -129,12 +129,12 @@
if (in_array($PricesSecurity, $_SESSION['AllowedPageSecurityTokens']) OR !isset($PricesSecurity)) {
echo '<tr><th colspan="2">' . _('Sell Price') . ':</th>
<td class="select">';
- $PriceResult = DB_query("SELECT typeabbrev,
+ $PriceResult = DB_query("SELECT typeabbrev,
price FROM prices
WHERE currabrev ='" . $_SESSION['CompanyRecord']['currencydefault'] . "'
AND typeabbrev = '" . $_SESSION['DefaultPriceList'] . "'
AND debtorno=''
- AND branchcode=''
+ AND branchcode=''
AND startdate <= '". Date('Y-m-d') ."' AND ( enddate >= '" . Date('Y-m-d') . "' OR enddate = '0000-00-00')
AND stockid='" . $StockID . "'", $db);
if ($myrow['mbflag'] == 'K' OR $myrow['mbflag'] == 'A') {
@@ -273,7 +273,7 @@
FROM purchorders INNER JOIN purchorderdetails
ON purchorders.orderno=purchorderdetails.orderno
WHERE purchorderdetails.itemcode='" . $StockID . "'
- AND purchorderdetails.completed =0
+ AND purchorderdetails.completed =0
AND purchorders.status<>'Cancelled'
AND purchorders.status<>'Pending'
AND purchorders.status<>'Rejected'";
@@ -346,7 +346,7 @@
</table>'; //end of nested table
echo '</td>'; //end cell of master table
-if (($myrow['mbflag'] == 'B' OR ($myrow['mbflag'] == 'M'))
+if (($myrow['mbflag'] == 'B' OR ($myrow['mbflag'] == 'M'))
AND (in_array($SuppliersSecurity, $_SESSION['AllowedPageSecurityTokens']))){
echo '<td width="50%" valign="top"><table>
@@ -368,7 +368,7 @@
purchdata.preferred,
currencies.decimalplaces
FROM purchdata INNER JOIN suppliers
- ON purchdata.supplierno=suppliers.supplierid
+ ON purchdata.supplierno=suppliers.supplierid
INNER JOIN currencies
ON suppliers.currcode=currencies.currabrev
WHERE purchdata.stockid = '" . $StockID . "'
@@ -430,7 +430,7 @@
if( isset($StockID) AND file_exists($_SESSION['part_pics_dir'] . '/' .$StockID.'.jpg') ) {
echo '<div class="centre"><img src="' . $rootpath . '/GetStockImage.php?automake=1&textcolor=FFFFF0&bgcolor=007F00&StockID=' . $StockID . '&text=' . $StockID . '&width=120&height=120" />';
}
- if (($myrow['mbflag'] == 'B')
+ if (($myrow['mbflag'] == 'B')
AND (in_array($SuppliersSecurity, $_SESSION['AllowedPageSecurityTokens']))
AND $myrow['discontinued']==0){
echo '<br />';
@@ -450,7 +450,7 @@
}
echo '<a href="' . $rootpath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">'. _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
<br />';
-
+
/**/
} /* end of while */
} /* end of $myrow['mbflag'] == 'B' */
@@ -469,8 +469,8 @@
}
if (!$Its_A_Kitset) {
echo '<a href="' . $rootpath . '/Prices.php?Item=' . $StockID . '">' . _('Maintain Pricing') . '</a><br />';
- if (isset($_SESSION['CustomerID'])
- AND $_SESSION['CustomerID'] != ''
+ if (isset($_SESSION['CustomerID'])
+ AND $_SESSION['CustomerID'] != ''
AND mb_strlen($_SESSION['CustomerID']) > 0) {
echo '<a href="' . $rootpath . '/Prices_Customer.php?Item=' . $StockID . '">' . _('Special Prices for customer') . ' - ' . $_SESSION['CustomerID'] . '</a><br />';
}
@@ -764,13 +764,13 @@
} else {
$ItemStatus ='';
}
-
+
echo '<td><input type="submit" name="Select" value="' . $myrow['stockid'] . '" /></td>
<td>'.$myrow['description'].'</td>
<td class="number">' . $qoh . '</td>
<td>' . $myrow['units'] . '</td>
+ <td>' . $ItemStatus . '</td>
<td><a target="_blank" href="' . $rootpath . '/StockStatus.php?StockID=' . $myrow['stockid'].'">' . _('View') . '</a></td>
- <td>' . $ItemStatus . '</td>
</tr>';
$j++;
if ($j == 20 AND ($RowIndex + 1 != $_SESSION['DisplayRecordsMax'])) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <tim...@us...> - 2012-02-18 20:53:02
|
Revision: 4924
http://web-erp.svn.sourceforge.net/web-erp/?rev=4924&view=rev
Author: tim_schofield
Date: 2012-02-18 20:52:55 +0000 (Sat, 18 Feb 2012)
Log Message:
-----------
Corrections to column ordering
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-02-18 20:52:22 UTC (rev 4923)
+++ trunk/SelectProduct.php 2012-02-18 20:52:55 UTC (rev 4924)
@@ -79,7 +79,7 @@
<tr>
<th colspan="3"><img src="' . $rootpath . '/css/' . $theme . '/images/inventory.png" title="' . _('Inventory') . '" alt="" /><b>' . ' ' . $StockID . ' - ' . $myrow['description'] . ' ' . $ItemStatus . '</b></th>
</tr>';
-
+
echo '<tr>
<td width="40%" valign="top">
<table align="left">'; //nested table
@@ -129,12 +129,12 @@
if (in_array($PricesSecurity, $_SESSION['AllowedPageSecurityTokens']) OR !isset($PricesSecurity)) {
echo '<tr><th colspan="2">' . _('Sell Price') . ':</th>
<td class="select">';
- $PriceResult = DB_query("SELECT typeabbrev,
+ $PriceResult = DB_query("SELECT typeabbrev,
price FROM prices
WHERE currabrev ='" . $_SESSION['CompanyRecord']['currencydefault'] . "'
AND typeabbrev = '" . $_SESSION['DefaultPriceList'] . "'
AND debtorno=''
- AND branchcode=''
+ AND branchcode=''
AND startdate <= '". Date('Y-m-d') ."' AND ( enddate >= '" . Date('Y-m-d') . "' OR enddate = '0000-00-00')
AND stockid='" . $StockID . "'", $db);
if ($myrow['mbflag'] == 'K' OR $myrow['mbflag'] == 'A') {
@@ -273,7 +273,7 @@
FROM purchorders INNER JOIN purchorderdetails
ON purchorders.orderno=purchorderdetails.orderno
WHERE purchorderdetails.itemcode='" . $StockID . "'
- AND purchorderdetails.completed =0
+ AND purchorderdetails.completed =0
AND purchorders.status<>'Cancelled'
AND purchorders.status<>'Pending'
AND purchorders.status<>'Rejected'";
@@ -346,7 +346,7 @@
</table>'; //end of nested table
echo '</td>'; //end cell of master table
-if (($myrow['mbflag'] == 'B' OR ($myrow['mbflag'] == 'M'))
+if (($myrow['mbflag'] == 'B' OR ($myrow['mbflag'] == 'M'))
AND (in_array($SuppliersSecurity, $_SESSION['AllowedPageSecurityTokens']))){
echo '<td width="50%" valign="top"><table>
@@ -368,7 +368,7 @@
purchdata.preferred,
currencies.decimalplaces
FROM purchdata INNER JOIN suppliers
- ON purchdata.supplierno=suppliers.supplierid
+ ON purchdata.supplierno=suppliers.supplierid
INNER JOIN currencies
ON suppliers.currcode=currencies.currabrev
WHERE purchdata.stockid = '" . $StockID . "'
@@ -430,7 +430,7 @@
if( isset($StockID) AND file_exists($_SESSION['part_pics_dir'] . '/' .$StockID.'.jpg') ) {
echo '<div class="centre"><img src="' . $rootpath . '/GetStockImage.php?automake=1&textcolor=FFFFF0&bgcolor=007F00&StockID=' . $StockID . '&text=' . $StockID . '&width=120&height=120" />';
}
- if (($myrow['mbflag'] == 'B')
+ if (($myrow['mbflag'] == 'B')
AND (in_array($SuppliersSecurity, $_SESSION['AllowedPageSecurityTokens']))
AND $myrow['discontinued']==0){
echo '<br />';
@@ -450,7 +450,7 @@
}
echo '<a href="' . $rootpath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">'. _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
<br />';
-
+
/**/
} /* end of while */
} /* end of $myrow['mbflag'] == 'B' */
@@ -469,8 +469,8 @@
}
if (!$Its_A_Kitset) {
echo '<a href="' . $rootpath . '/Prices.php?Item=' . $StockID . '">' . _('Maintain Pricing') . '</a><br />';
- if (isset($_SESSION['CustomerID'])
- AND $_SESSION['CustomerID'] != ''
+ if (isset($_SESSION['CustomerID'])
+ AND $_SESSION['CustomerID'] != ''
AND mb_strlen($_SESSION['CustomerID']) > 0) {
echo '<a href="' . $rootpath . '/Prices_Customer.php?Item=' . $StockID . '">' . _('Special Prices for customer') . ' - ' . $_SESSION['CustomerID'] . '</a><br />';
}
@@ -764,13 +764,13 @@
} else {
$ItemStatus ='';
}
-
+
echo '<td><input type="submit" name="Select" value="' . $myrow['stockid'] . '" /></td>
<td>'.$myrow['description'].'</td>
<td class="number">' . $qoh . '</td>
<td>' . $myrow['units'] . '</td>
+ <td>' . $ItemStatus . '</td>
<td><a target="_blank" href="' . $rootpath . '/StockStatus.php?StockID=' . $myrow['stockid'].'">' . _('View') . '</a></td>
- <td>' . $ItemStatus . '</td>
</tr>';
$j++;
if ($j == 20 AND ($RowIndex + 1 != $_SESSION['DisplayRecordsMax'])) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2012-07-21 03:41:59
|
Revision: 5522
http://web-erp.svn.sourceforge.net/web-erp/?rev=5522&view=rev
Author: tehonu
Date: 2012-07-21 03:41:52 +0000 (Sat, 21 Jul 2012)
Log Message:
-----------
Ricard: Changed order display results to discounted, stockid
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-07-20 09:37:59 UTC (rev 5521)
+++ trunk/SelectProduct.php 2012-07-21 03:41:52 UTC (rev 5522)
@@ -584,7 +584,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
} else {
$SQL = "SELECT stockmaster.stockid,
stockmaster.description,
@@ -606,7 +606,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
}
} elseif (isset($_POST['StockCode'])) {
$_POST['StockCode'] = mb_strtoupper($_POST['StockCode']);
@@ -632,7 +632,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
} else {
$SQL = "SELECT stockmaster.stockid,
stockmaster.description,
@@ -654,7 +654,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
}
} elseif (!isset($_POST['StockCode']) AND !isset($_POST['Keywords'])) {
if ($_POST['StockCat'] == 'All') {
@@ -678,7 +678,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
} else {
$SQL = "SELECT stockmaster.stockid,
stockmaster.description,
@@ -699,7 +699,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
}
}
$ErrMsg = _('No stock items were returned by the SQL because');
@@ -757,11 +757,11 @@
}
echo '<table class="selection">';
$TableHeader = '<tr>
+ <th>' . _('Stock Status') . '</th>
<th>' . _('Code') . '</th>
<th>' . _('Description') . '</th>
<th>' . _('Total Qty On Hand') . '</th>
<th>' . _('Units') . '</th>
- <th>' . _('Stock Status') . '</th>
</tr>';
echo $TableHeader;
$j = 1;
@@ -789,11 +789,11 @@
$ItemStatus ='';
}
- echo '<td><input type="submit" name="Select" value="' . $myrow['stockid'] . '" /></td>
+ echo '<td>' . $ItemStatus . '</td>
+ <td><input type="submit" name="Select" value="' . $myrow['stockid'] . '" /></td>
<td title="'. $myrow['longdescription'] . '">' . $myrow['description'] . '</td>
<td class="number">' . $qoh . '</td>
<td>' . $myrow['units'] . '</td>
- <td>' . $ItemStatus . '</td>
<td><a target="_blank" href="' . $rootpath . '/StockStatus.php?StockID=' . $myrow['stockid'].'">' . _('View') . '</a></td>
</tr>';
$j++;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2012-07-21 03:41:59
|
Revision: 5522
http://web-erp.svn.sourceforge.net/web-erp/?rev=5522&view=rev
Author: tehonu
Date: 2012-07-21 03:41:52 +0000 (Sat, 21 Jul 2012)
Log Message:
-----------
Ricard: Changed order display results to discounted, stockid
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-07-20 09:37:59 UTC (rev 5521)
+++ trunk/SelectProduct.php 2012-07-21 03:41:52 UTC (rev 5522)
@@ -584,7 +584,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
} else {
$SQL = "SELECT stockmaster.stockid,
stockmaster.description,
@@ -606,7 +606,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
}
} elseif (isset($_POST['StockCode'])) {
$_POST['StockCode'] = mb_strtoupper($_POST['StockCode']);
@@ -632,7 +632,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
} else {
$SQL = "SELECT stockmaster.stockid,
stockmaster.description,
@@ -654,7 +654,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
}
} elseif (!isset($_POST['StockCode']) AND !isset($_POST['Keywords'])) {
if ($_POST['StockCat'] == 'All') {
@@ -678,7 +678,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
} else {
$SQL = "SELECT stockmaster.stockid,
stockmaster.description,
@@ -699,7 +699,7 @@
stockmaster.mbflag,
stockmaster.discontinued,
stockmaster.decimalplaces
- ORDER BY stockmaster.stockid";
+ ORDER BY stockmaster.discontinued, stockmaster.stockid";
}
}
$ErrMsg = _('No stock items were returned by the SQL because');
@@ -757,11 +757,11 @@
}
echo '<table class="selection">';
$TableHeader = '<tr>
+ <th>' . _('Stock Status') . '</th>
<th>' . _('Code') . '</th>
<th>' . _('Description') . '</th>
<th>' . _('Total Qty On Hand') . '</th>
<th>' . _('Units') . '</th>
- <th>' . _('Stock Status') . '</th>
</tr>';
echo $TableHeader;
$j = 1;
@@ -789,11 +789,11 @@
$ItemStatus ='';
}
- echo '<td><input type="submit" name="Select" value="' . $myrow['stockid'] . '" /></td>
+ echo '<td>' . $ItemStatus . '</td>
+ <td><input type="submit" name="Select" value="' . $myrow['stockid'] . '" /></td>
<td title="'. $myrow['longdescription'] . '">' . $myrow['description'] . '</td>
<td class="number">' . $qoh . '</td>
<td>' . $myrow['units'] . '</td>
- <td>' . $ItemStatus . '</td>
<td><a target="_blank" href="' . $rootpath . '/StockStatus.php?StockID=' . $myrow['stockid'].'">' . _('View') . '</a></td>
</tr>';
$j++;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2012-08-08 08:27:48
|
Revision: 5589
http://web-erp.svn.sourceforge.net/web-erp/?rev=5589&view=rev
Author: tehonu
Date: 2012-08-08 08:27:42 +0000 (Wed, 08 Aug 2012)
Log Message:
-----------
Ricard: Shows Stock Category
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-08-06 19:03:49 UTC (rev 5588)
+++ trunk/SelectProduct.php 2012-08-08 08:27:42 UTC (rev 5589)
@@ -66,7 +66,8 @@
stockmaster.discontinued,
stockmaster.eoq,
stockmaster.volume,
- stockmaster.kgs
+ stockmaster.kgs,
+ stockcategory.categorydescription
FROM stockmaster INNER JOIN stockcategory
ON stockmaster.categoryid=stockcategory.categoryid
WHERE stockid='" . $StockID . "'", $db);
@@ -85,9 +86,11 @@
<th colspan="3"><img src="' . $rootpath . '/css/' . $theme . '/images/inventory.png" title="' . _('Inventory') . '" alt="" /><b title="' . $myrow['longdescription'] . '">' . ' ' . $StockID . ' - ' . $myrow['description'] . '</b> ' . $ItemStatus . '</th>
</tr>';
+
echo '<tr>
<td style="width:40%" valign="top">
<table>'; //nested table
+ echo '<tr><th class="number">' . _('Category:') . '</th> <td colspan="2" class="select">' . $myrow['categorydescription'] , '</td></tr>';
echo '<tr><th class="number">' . _('Item Type:') . '</th>
<td colspan="2" class="select">';
switch ($myrow['mbflag']) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2012-08-08 08:27:48
|
Revision: 5589
http://web-erp.svn.sourceforge.net/web-erp/?rev=5589&view=rev
Author: tehonu
Date: 2012-08-08 08:27:42 +0000 (Wed, 08 Aug 2012)
Log Message:
-----------
Ricard: Shows Stock Category
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-08-06 19:03:49 UTC (rev 5588)
+++ trunk/SelectProduct.php 2012-08-08 08:27:42 UTC (rev 5589)
@@ -66,7 +66,8 @@
stockmaster.discontinued,
stockmaster.eoq,
stockmaster.volume,
- stockmaster.kgs
+ stockmaster.kgs,
+ stockcategory.categorydescription
FROM stockmaster INNER JOIN stockcategory
ON stockmaster.categoryid=stockcategory.categoryid
WHERE stockid='" . $StockID . "'", $db);
@@ -85,9 +86,11 @@
<th colspan="3"><img src="' . $rootpath . '/css/' . $theme . '/images/inventory.png" title="' . _('Inventory') . '" alt="" /><b title="' . $myrow['longdescription'] . '">' . ' ' . $StockID . ' - ' . $myrow['description'] . '</b> ' . $ItemStatus . '</th>
</tr>';
+
echo '<tr>
<td style="width:40%" valign="top">
<table>'; //nested table
+ echo '<tr><th class="number">' . _('Category:') . '</th> <td colspan="2" class="select">' . $myrow['categorydescription'] , '</td></tr>';
echo '<tr><th class="number">' . _('Item Type:') . '</th>
<td colspan="2" class="select">';
switch ($myrow['mbflag']) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2012-09-09 00:26:43
|
Revision: 5638
http://web-erp.svn.sourceforge.net/web-erp/?rev=5638&view=rev
Author: tehonu
Date: 2012-09-09 00:26:37 +0000 (Sun, 09 Sep 2012)
Log Message:
-----------
Avoid redundancies in list of supplier to purchase the item when there is many purchdata available
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-09-08 06:07:30 UTC (rev 5637)
+++ trunk/SelectProduct.php 2012-09-09 00:26:37 UTC (rev 5638)
@@ -456,16 +456,20 @@
purchdata.leadtime
FROM purchdata INNER JOIN suppliers
ON purchdata.supplierno=suppliers.supplierid
- WHERE purchdata.stockid='" . $StockID . "'", $db);
+ WHERE purchdata.stockid='" . $StockID . "'
+ ORDER BY purchdata.effectivefrom DESC", $db);
+ $LastSupplierShown = "";
while ($SuppRow = DB_fetch_array($SuppResult)) {
- if (($myrow['eoq'] < $SuppRow['minorderqty'])) {
- $EOQ = $SuppRow['minorderqty'];
- } else {
- $EOQ = $myrow['eoq'];
+ if ($LastSupplierShown != $SuppRow['supplierid']){
+ if (($myrow['eoq'] < $SuppRow['minorderqty'])) {
+ $EOQ = $SuppRow['minorderqty'];
+ } else {
+ $EOQ = $myrow['eoq'];
+ }
+ echo '<a href="' . $rootpath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">'. _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
+ <br />';
+ $LastSupplierShown = $SuppRow['supplierid'];
}
- echo '<a href="' . $rootpath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">'. _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
- <br />';
-
/**/
} /* end of while */
} /* end of $myrow['mbflag'] == 'B' */
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2012-09-09 00:26:43
|
Revision: 5638
http://web-erp.svn.sourceforge.net/web-erp/?rev=5638&view=rev
Author: tehonu
Date: 2012-09-09 00:26:37 +0000 (Sun, 09 Sep 2012)
Log Message:
-----------
Avoid redundancies in list of supplier to purchase the item when there is many purchdata available
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2012-09-08 06:07:30 UTC (rev 5637)
+++ trunk/SelectProduct.php 2012-09-09 00:26:37 UTC (rev 5638)
@@ -456,16 +456,20 @@
purchdata.leadtime
FROM purchdata INNER JOIN suppliers
ON purchdata.supplierno=suppliers.supplierid
- WHERE purchdata.stockid='" . $StockID . "'", $db);
+ WHERE purchdata.stockid='" . $StockID . "'
+ ORDER BY purchdata.effectivefrom DESC", $db);
+ $LastSupplierShown = "";
while ($SuppRow = DB_fetch_array($SuppResult)) {
- if (($myrow['eoq'] < $SuppRow['minorderqty'])) {
- $EOQ = $SuppRow['minorderqty'];
- } else {
- $EOQ = $myrow['eoq'];
+ if ($LastSupplierShown != $SuppRow['supplierid']){
+ if (($myrow['eoq'] < $SuppRow['minorderqty'])) {
+ $EOQ = $SuppRow['minorderqty'];
+ } else {
+ $EOQ = $myrow['eoq'];
+ }
+ echo '<a href="' . $rootpath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">'. _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
+ <br />';
+ $LastSupplierShown = $SuppRow['supplierid'];
}
- echo '<a href="' . $rootpath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">'. _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
- <br />';
-
/**/
} /* end of while */
} /* end of $myrow['mbflag'] == 'B' */
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <te...@us...> - 2013-07-10 02:20:15
|
Revision: 6068
http://sourceforge.net/p/web-erp/reponame/6068
Author: tehonu
Date: 2013-07-10 02:20:13 +0000 (Wed, 10 Jul 2013)
Log Message:
-----------
Change kgs bt grossweight
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2013-07-10 02:04:22 UTC (rev 6067)
+++ trunk/SelectProduct.php 2013-07-10 02:20:13 UTC (rev 6068)
@@ -66,7 +66,7 @@
stockmaster.discontinued,
stockmaster.eoq,
stockmaster.volume,
- stockmaster.kgs,
+ stockmaster.grossweight,
stockcategory.categorydescription,
stockmaster.categoryid
FROM stockmaster INNER JOIN stockcategory
@@ -132,7 +132,7 @@
echo '<tr><th class="number">' . _('Volume') . ':</th>
<td class="select" colspan="2">' . locale_number_format($myrow['volume'], 3) . '</td>
<th class="number">' . _('Weight') . ':</th>
- <td class="select">' . locale_number_format($myrow['kgs'], 3) . '</td>
+ <td class="select">' . locale_number_format($myrow['grossweight'], 3) . '</td>
<th class="number">' . _('EOQ') . ':</th>
<td class="select">' . locale_number_format($myrow['eoq'], $myrow['decimalplaces']) . '</td></tr>';
if (in_array($PricesSecurity, $_SESSION['AllowedPageSecurityTokens']) OR !isset($PricesSecurity)) {
|
|
From: <tu...@us...> - 2015-01-24 03:08:07
|
Revision: 7096
http://sourceforge.net/p/web-erp/reponame/7096
Author: turbopt
Date: 2015-01-24 03:08:00 +0000 (Sat, 24 Jan 2015)
Log Message:
-----------
Add 2 closing parenthesis
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2015-01-24 00:16:59 UTC (rev 7095)
+++ trunk/SelectProduct.php 2015-01-24 03:08:00 UTC (rev 7096)
@@ -154,7 +154,7 @@
ON bom.component=stockmaster.stockid
WHERE bom.parent='" . $StockID . "'
AND bom.effectiveafter <= '" . date('Y-m-d') . "'
- AND bom.effectiveto > '" . date('Y-m-d') . "'";
+ AND bom.effectiveto > '" . date('Y-m-d') . "'");
$CostRow = DB_fetch_row($CostResult);
$Cost = $CostRow[0];
} else {
@@ -185,7 +185,7 @@
ON bom.component=stockmaster.stockid
WHERE bom.parent = '" . $StockID . "'
AND bom.effectiveafter <= '" . date('Y-m-d') . "'
- AND bom.effectiveto > '" . date('Y-m-d') . "'";
+ AND bom.effectiveto > '" . date('Y-m-d') . "'");
$CostRow = DB_fetch_row($CostResult);
$Cost = $CostRow[0];
} else {
|
|
From: <rc...@us...> - 2015-03-02 17:26:34
|
Revision: 7181
http://sourceforge.net/p/web-erp/reponame/7181
Author: rchacon
Date: 2015-03-02 17:26:32 +0000 (Mon, 02 Mar 2015)
Log Message:
-----------
Adds colon to table-titles.
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2015-03-02 15:48:19 UTC (rev 7180)
+++ trunk/SelectProduct.php 2015-03-02 17:26:32 UTC (rev 7181)
@@ -159,19 +159,19 @@
$Cost = $myrow['cost'];
}
echo '<tr>
- <th class="number">' . _('Price') . ':</th>
- <td class="select">';
+ <th class="number">' . _('Price') . ':</th>';
if (DB_num_rows($PriceResult) == 0) {
- echo _('No Default Price Set in Home Currency') . '</td></tr>';
+ echo '<td class="select" colspan="6">' . _('No Default Price Set in Home Currency') . '</td>
+ </tr>';
$Price = 0;
} else {
$PriceRow = DB_fetch_row($PriceResult);
$Price = $PriceRow[1];
- echo $PriceRow[0] . '</td>
+ echo '<td class="select">' . $PriceRow[0] . '</td>
<td class="select">' . locale_number_format($Price, $_SESSION['CompanyRecord']['decimalplaces']) . '</td>
- <th class="number">' . _('Cost') . '</th>
+ <th class="number">' . _('Cost') . ':</th>
<td class="select">' . locale_number_format($Cost, $_SESSION['StandardCostDecimalPlaces']) . '</td>
- <th class="number">' . _('Gross Profit') . '</th>
+ <th class="number">' . _('Gross Profit') . ':</th>
<td class="select">';
if ($Price > 0) {
echo locale_number_format(($Price - $Cost) * 100 / $Price, $_SESSION['CompanyRecord']['decimalplaces']) . '%';
|
|
From: <rc...@us...> - 2015-03-03 14:38:44
|
Revision: 7182
http://sourceforge.net/p/web-erp/reponame/7182
Author: rchacon
Date: 2015-03-03 14:38:37 +0000 (Tue, 03 Mar 2015)
Log Message:
-----------
Reverse change: Use "1" instead of "$_SESSION['CompanyRecord']['decimalplaces']" for decimal places of gross profit (as previous version).
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2015-03-02 17:26:32 UTC (rev 7181)
+++ trunk/SelectProduct.php 2015-03-03 14:38:37 UTC (rev 7182)
@@ -1,5 +1,6 @@
<?php
/* $Id$*/
+/* Selection of items. All item maintenance, transactions and inquiries start with this script. */
$PricesSecurity = 12;//don't show pricing info unless security token 12 available to user
$SuppliersSecurity = 9; //don't show supplier purchasing info unless security token 9 available to user
@@ -174,7 +175,7 @@
<th class="number">' . _('Gross Profit') . ':</th>
<td class="select">';
if ($Price > 0) {
- echo locale_number_format(($Price - $Cost) * 100 / $Price, $_SESSION['CompanyRecord']['decimalplaces']) . '%';
+ echo locale_number_format(($Price - $Cost) * 100 / $Price, 1) . '%';
} else {
echo _('N/A');
}
|
|
From: <ex...@us...> - 2016-06-20 06:54:42
|
Revision: 7559
http://sourceforge.net/p/web-erp/reponame/7559
Author: exsonqu
Date: 2016-06-20 06:54:39 +0000 (Mon, 20 Jun 2016)
Log Message:
-----------
20/06/16 Exson: Fixed the bug that # is not allowed as part of stockid in SelectProduct.php.
Modified Paths:
--------------
trunk/SelectProduct.php
Modified: trunk/SelectProduct.php
===================================================================
--- trunk/SelectProduct.php 2016-06-20 06:40:21 UTC (rev 7558)
+++ trunk/SelectProduct.php 2016-06-20 06:54:39 UTC (rev 7559)
@@ -370,7 +370,7 @@
echo '<td class="select">' . _('No') . '</td>';
}
echo '<td class="select"><a href="' . $RootPath . '/PO_Header.php?NewOrder=Yes&SelectedSupplier=' .
- $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$SuppRow['minorderqty'].'&LeadTime='.$SuppRow['leadtime'] . '">' . _('Order') . ' </a></td>';
+ $SuppRow['supplierid'] . '&StockID=' . urlencode($StockID) . '&Quantity='.$SuppRow['minorderqty'].'&LeadTime='.$SuppRow['leadtime'] . '">' . _('Order') . ' </a></td>';
echo '</tr>';
}
echo '</table>';
@@ -389,34 +389,34 @@
<tr>
<td valign="top" class="select">';
/*Stock Inquiry Options */
-echo '<a href="' . $RootPath . '/StockMovements.php?StockID=' . $StockID . '">' . _('Show Stock Movements') . '</a><br />';
+echo '<a href="' . $RootPath . '/StockMovements.php?StockID=' . urlencode($StockID) . '">' . _('Show Stock Movements') . '</a><br />';
if ($Its_A_Kitset_Assembly_Or_Dummy == False) {
- echo '<a href="' . $RootPath . '/StockStatus.php?StockID=' . $StockID . '">' . _('Show Stock Status') . '</a><br />';
- echo '<a href="' . $RootPath . '/StockUsage.php?StockID=' . $StockID . '">' . _('Show Stock Usage') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockStatus.php?StockID=' . urlencode($StockID) . '">' . _('Show Stock Status') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockUsage.php?StockID=' . urlencode($StockID) . '">' . _('Show Stock Usage') . '</a><br />';
}
-echo '<a href="' . $RootPath . '/SelectSalesOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search Outstanding Sales Orders') . '</a><br />';
-echo '<a href="' . $RootPath . '/SelectCompletedOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search Completed Sales Orders') . '</a><br />';
+echo '<a href="' . $RootPath . '/SelectSalesOrder.php?SelectedStockItem=' . urlencode($StockID) . '">' . _('Search Outstanding Sales Orders') . '</a><br />';
+echo '<a href="' . $RootPath . '/SelectCompletedOrder.php?SelectedStockItem=' . urlencode($StockID) . '">' . _('Search Completed Sales Orders') . '</a><br />';
if ($Its_A_Kitset_Assembly_Or_Dummy == False) {
- echo '<a href="' . $RootPath . '/PO_SelectOSPurchOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search Outstanding Purchase Orders') . '</a><br />';
- echo '<a href="' . $RootPath . '/PO_SelectPurchOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search All Purchase Orders') . '</a><br />';
+ echo '<a href="' . $RootPath . '/PO_SelectOSPurchOrder.php?SelectedStockItem=' . urlencode($StockID) . '">' . _('Search Outstanding Purchase Orders') . '</a><br />';
+ echo '<a href="' . $RootPath . '/PO_SelectPurchOrder.php?SelectedStockItem=' . urlencode($StockID) . '">' . _('Search All Purchase Orders') . '</a><br />';
$SupportedImgExt = array('png','jpg','jpeg');
$imagefile = reset((glob($_SESSION['part_pics_dir'] . '/' . $StockID . '.{' . implode(",", $SupportedImgExt) . '}', GLOB_BRACE)));
echo '<a href="' . $RootPath . '/' . $imagefile . '" target="_blank">' . _('Show Part Picture (if available)') . '</a><br />';
}
if ($Its_A_Dummy == False) {
- echo '<a href="' . $RootPath . '/BOMInquiry.php?StockID=' . $StockID . '">' . _('View Costed Bill Of Material') . '</a><br />';
- echo '<a href="' . $RootPath . '/WhereUsedInquiry.php?StockID=' . $StockID . '">' . _('Where This Item Is Used') . '</a><br />';
+ echo '<a href="' . $RootPath . '/BOMInquiry.php?StockID=' . urlencode($StockID) . '">' . _('View Costed Bill Of Material') . '</a><br />';
+ echo '<a href="' . $RootPath . '/WhereUsedInquiry.php?StockID=' . urlencode($StockID) . '">' . _('Where This Item Is Used') . '</a><br />';
}
if ($Its_A_Labour_Item == True) {
- echo '<a href="' . $RootPath . '/WhereUsedInquiry.php?StockID=' . $StockID . '">' . _('Where This Labour Item Is Used') . '</a><br />';
+ echo '<a href="' . $RootPath . '/WhereUsedInquiry.php?StockID=' . urlencode($StockID) . '">' . _('Where This Labour Item Is Used') . '</a><br />';
}
wikiLink('Product', $StockID);
echo '</td><td valign="top" class="select">';
/* Stock Transactions */
if ($Its_A_Kitset_Assembly_Or_Dummy == false) {
- echo '<a href="' . $RootPath . '/StockAdjustments.php?StockID=' . $StockID . '">' . _('Quantity Adjustments') . '</a><br />';
- echo '<a href="' . $RootPath . '/StockTransfers.php?StockID=' . $StockID . '&NewTransfer=true">' . _('Location Transfers') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockAdjustments.php?StockID=' . urlencode($StockID) . '">' . _('Quantity Adjustments') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockTransfers.php?StockID=' . urlencode($StockID) . '&NewTransfer=true">' . _('Location Transfers') . '</a><br />';
//show the item image if it has been uploaded
if ( extension_loaded ('gd') && function_exists ('gd_info') && file_exists ($imagefile) ) {
@@ -464,7 +464,7 @@
} else {
$EOQ = $myrow['eoq'];
}
- echo '<a href="' . $RootPath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . $StockID . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">' . _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
+ echo '<a href="' . $RootPath . '/PO_Header.php?NewOrder=Yes' . '&SelectedSupplier=' . $SuppRow['supplierid'] . '&StockID=' . urlencode($StockID) . '&Quantity='.$EOQ.'&LeadTime='.$SuppRow['leadtime'].'">' . _('Purchase this Item from') . ' ' . $SuppRow['suppname'] . '</a>
<br />';
$LastSupplierShown = $SuppRow['supplierid'];
}
@@ -475,27 +475,27 @@
echo '</td><td valign="top" class="select">';
/* Stock Maintenance Options */
echo '<a href="' . $RootPath . '/Stocks.php?">' . _('Insert New Item') . '</a><br />';
-echo '<a href="' . $RootPath . '/Stocks.php?StockID=' . $StockID . '">' . _('Modify Item Details') . '</a><br />';
+echo '<a href="' . $RootPath . '/Stocks.php?StockID=' . urlencode($StockID) . '">' . _('Modify Item Details') . '</a><br />';
if ($Its_A_Kitset_Assembly_Or_Dummy == False) {
- echo '<a href="' . $RootPath . '/StockReorderLevel.php?StockID=' . $StockID . '">' . _('Maintain Reorder Levels') . '</a><br />';
- echo '<a href="' . $RootPath . '/StockCostUpdate.php?StockID=' . $StockID . '">' . _('Maintain Standard Cost') . '</a><br />';
- echo '<a href="' . $RootPath . '/PurchData.php?StockID=' . $StockID . '">' . _('Maintain Purchasing Data') . '</a><br />';
- echo '<a href="' . $RootPath . '/CustItem.php?StockID=' . $StockID . '">' . _('Maintain Customer Item Data') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockReorderLevel.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Reorder Levels') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockCostUpdate.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Standard Cost') . '</a><br />';
+ echo '<a href="' . $RootPath . '/PurchData.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Purchasing Data') . '</a><br />';
+ echo '<a href="' . $RootPath . '/CustItem.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Customer Item Data') . '</a><br />';
}
if ($Its_A_Labour_Item == True) {
- echo '<a href="' . $RootPath . '/StockCostUpdate.php?StockID=' . $StockID . '">' . _('Maintain Standard Cost') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockCostUpdate.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Standard Cost') . '</a><br />';
}
if (!$Its_A_Kitset) {
- echo '<a href="' . $RootPath . '/Prices.php?Item=' . $StockID . '">' . _('Maintain Pricing') . '</a><br />';
+ echo '<a href="' . $RootPath . '/Prices.php?Item=' . urlencode($StockID) . '">' . _('Maintain Pricing') . '</a><br />';
if (isset($_SESSION['CustomerID'])
AND $_SESSION['CustomerID'] != ''
AND mb_strlen($_SESSION['CustomerID']) > 0) {
- echo '<a href="' . $RootPath . '/Prices_Customer.php?Item=' . $StockID . '">' . _('Special Prices for customer') . ' - ' . $_SESSION['CustomerID'] . '</a><br />';
+ echo '<a href="' . $RootPath . '/Prices_Customer.php?Item=' . urlencode($StockID) . '">' . _('Special Prices for customer') . ' - ' . $_SESSION['CustomerID'] . '</a><br />';
}
- echo '<a href="' . $RootPath . '/DiscountCategories.php?StockID=' . $StockID . '">' . _('Maintain Discount Category') . '</a><br />';
- echo '<a href="' . $RootPath . '/StockClone.php?OldStockID=' . $StockID . '">' . _('Clone This Item') . '</a><br />';
- echo '<a href="' . $RootPath . '/RelatedItemsUpdate.php?Item=' . $StockID . '">' . _('Maintain Related Items') . '</a><br />';
- echo '<a href="' . $RootPath . '/PriceMatrix.php?StockID=' . $StockID . '">' . _('Maintain Price Matrix') . '</a><br />';
+ echo '<a href="' . $RootPath . '/DiscountCategories.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Discount Category') . '</a><br />';
+ echo '<a href="' . $RootPath . '/StockClone.php?OldStockID=' . urlencode($StockID) . '">' . _('Clone This Item') . '</a><br />';
+ echo '<a href="' . $RootPath . '/RelatedItemsUpdate.php?Item=' . urlencode($StockID) . '">' . _('Maintain Related Items') . '</a><br />';
+ echo '<a href="' . $RootPath . '/PriceMatrix.php?StockID=' . urlencode($StockID) . '">' . _('Maintain Price Matrix') . '</a><br />';
}
echo '</td></tr></table>';
} else {
@@ -862,7 +862,7 @@
<td title="'. $myrow['longdescription'] . '">' . $myrow['description'] . '</td>
<td class="number">' . $qoh . '</td>
<td>' . $myrow['units'] . '</td>
- <td><a target="_blank" href="' . $RootPath . '/StockStatus.php?StockID=' . $myrow['stockid'].'">' . _('View') . '</a></td>
+ <td><a target="_blank" href="' . $RootPath . '/StockStatus.php?StockID=' . urlencode($myrow['stockid']).'">' . _('View') . '</a></td>
</tr>';
/*
$j++;
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X