Menu
▾
▴
web-erp-svn
|
From: <dai...@us...> - 2011-09-12 08:57:18
|
Revision: 4687
http://web-erp.svn.sourceforge.net/web-erp/?rev=4687&view=rev
Author: daintree
Date: 2011-09-12 08:57:11 +0000 (Mon, 12 Sep 2011)
Log Message:
-----------
number_formatting
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2011-09-12 08:03:20 UTC (rev 4686)
+++ trunk/StockTransfers.php 2011-09-12 08:57:11 UTC (rev 4687)
@@ -18,7 +18,7 @@
if (isset($_GET['From'])) {
$_POST['StockLocationFrom']=$_GET['From'];
$_POST['StockLocationTo']=$_GET['To'];
- $_POST['Quantity']=$_GET['Quantity'];
+ $_POST['Quantity']=filter_number_format($_GET['Quantity']);
}
if (isset($_POST['CheckCode'])) {
@@ -27,21 +27,27 @@
'" alt="" />' . ' ' . _('Select Item to Transfer') . '</p>';
if (mb_strlen($_POST['StockText'])>0) {
- $sql="SELECT stockid, description from stockmaster where description " . LIKE . " '%" . $_POST['StockText'] . "%'";
+ $sql="SELECT stockid,
+ description
+ FROM stockmaster
+ WHERE description " . LIKE . " '%" . $_POST['StockText'] . "%'";
} else {
- $sql="SELECT stockid, description from stockmaster where stockid " . LIKE . " '%" . $_POST['StockCode']."%'";
+ $sql="SELECT stockid,
+ description
+ FROM stockmaster
+ WHERE stockid " . LIKE . " '%" . $_POST['StockCode']."%'";
}
$ErrMsg=_('The stock information cannot be retrieved because');
$DbgMsg=_('The SQL to get the stock description was');
$result = DB_query($sql,$db,$ErrMsg,$DbgMsg);
- echo '<table class=selection>
+ echo '<table class="selection">
<tr><th>'._('Stock Code').'</th>
<th>'._('Stock Description').'</th>
</tr>';
while ($myrow = DB_fetch_array($result)) {
echo '<tr><td>'.$myrow['stockid'].'</td>
<td>'.$myrow['description'].'</td>
- <td><a href="' . $rootpath . '/StockTransfers.php?StockID='.$myrow['stockid'].'&Description='.$myrow['description'].'&NewTransfer=Yes&Quantity='.$_POST['Quantity'].'&From='.$_POST['StockLocationFrom'].'&To='.$_POST['StockLocationTo'].'">'
+ <td><a href="' . $rootpath . '/StockTransfers.php?StockID='.$myrow['stockid'].'&Description='.$myrow['description'].'&NewTransfer=Yes&Quantity='. filter_number_format($_POST['Quantity']).'&From='.$_POST['StockLocationFrom'].'&To='.$_POST['StockLocationTo'].'">'
._('Transfer').'</a></td>
</tr>';
@@ -61,11 +67,8 @@
if (isset($_GET['StockID'])){ /*carry the stockid through to the form for additional inputs */
-
$_POST['StockID'] = trim(mb_strtoupper($_GET['StockID']));
-
} elseif (isset($_POST['StockID'])){ /* initiate a new transfer only if the StockID is different to the previous entry */
-
if (isset($_SESSION['Transfer']) AND $_POST['StockID'] != $_SESSION['Transfer']->TransferItem[0]->StockID){
unset($_SESSION['Transfer']);
$NewTransfer = true;
@@ -99,7 +102,7 @@
$myrow = DB_fetch_row($result);
$_SESSION['Transfer']->TransferItem[0] = new LineItem ( trim(mb_strtoupper($_POST['StockID'])),
$myrow['description'],
- $_POST['Quantity'],
+ filter_number_format($_POST['Quantity']),
$myrow['units'],
$myrow['controlled'],
$myrow['serialised'],
@@ -107,27 +110,26 @@
$myrow['decimalplaces']);
- $_SESSION['Transfer']->TransferItem[0]->StandardCost = $myrow[3];
+ $_SESSION['Transfer']->TransferItem[0]->StandardCost = $myrow['standardcost'];
if ($myrow[2]=='D' OR $myrow[2]=='A' OR $myrow[2]=='K'){
prnMsg(_('The part entered is either or a dummy part or an assembly or a kit-set part') . '. ' . _('These parts are not physical parts and no stock holding is maintained for them') . '. ' . _('Stock Transfers are therefore not possible'),'warn');
- echo '.<hr>';
+ echo '.<hr />';
echo '<a href="' . $rootpath . '/StockTransfers.php?NewTransfer=Yes">' . _('Enter another Transfer') . '</a>';
unset ($_SESSION['Transfer']);
include ('includes/footer.inc');
exit;
}
}
-
}
if (isset($_POST['Quantity']) AND isset($_SESSION['Transfer']->TransferItem[0]->Controlled) AND $_SESSION['Transfer']->TransferItem[0]->Controlled==0){
- $_SESSION['Transfer']->TransferItem[0]->Quantity = $_POST['Quantity'];
+ $_SESSION['Transfer']->TransferItem[0]->Quantity = filter_number_format($_POST['Quantity']);
}
if ( isset($_POST['StockLocationFrom']) AND $_POST['StockLocationFrom']!= $_SESSION['Transfer']->StockLocationFrom ){
$_SESSION['Transfer']->StockLocationFrom = $_POST['StockLocationFrom'];
$_SESSION['Transfer']->StockLocationTo = $_POST['StockLocationTo'];
- $_SESSION['Transfer']->TransferItem[0]->Quantity=$_POST['Quantity'];
+ $_SESSION['Transfer']->TransferItem[0]->Quantity=filter_number_format($_POST['Quantity']);
$_SESSION['Transfer']->TransferItem[0]->SerialItems=array();
}
if ( isset($_POST['StockLocationTo']) ){
@@ -136,8 +138,6 @@
if ( isset($_POST['EnterTransfer']) ){
-
-
$result = DB_query("SELECT * FROM stockmaster WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID ."'",$db);
$myrow = DB_fetch_row($result);
$InputError = false;
@@ -193,25 +193,25 @@
}
// Insert the stock movement for the stock going out of the from location
$SQL = "INSERT INTO stockmoves (stockid,
- type,
- transno,
- loccode,
- trandate,
- prd,
- reference,
- qty,
- newqoh)
- VALUES (
- '" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- 16,
- '" . $TransferNumber . "',
- '" . $_SESSION['Transfer']->StockLocationFrom . "',
- '" . $SQLTransferDate . "',
- '" . $PeriodNo . "',
- 'To " . $_SESSION['Transfer']->StockLocationTo ."',
- '" . round(-$_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces) . "',
- '" . ($QtyOnHandPrior - round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) ."'
- )";
+ type,
+ transno,
+ loccode,
+ trandate,
+ prd,
+ reference,
+ qty,
+ newqoh)
+ VALUES (
+ '" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
+ 16,
+ '" . $TransferNumber . "',
+ '" . $_SESSION['Transfer']->StockLocationFrom . "',
+ '" . $SQLTransferDate . "',
+ '" . $PeriodNo . "',
+ 'To " . $_SESSION['Transfer']->StockLocationTo ."',
+ '" . filter_number_format(round(-$_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "',
+ '" . filter_number_format($QtyOnHandPrior - round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) ."'
+ )";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The stock movement record cannot be inserted because');
$DbgMsg = _('The following SQL to insert the stock movement record was used');
@@ -229,11 +229,11 @@
/*First need to check if the serial items already exists or not in the location from */
$SQL = "SELECT COUNT(*)
- FROM stockserialitems
- WHERE
- stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
- AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'
- AND serialno='" . $Item->BundleRef . "'";
+ FROM stockserialitems
+ WHERE
+ stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
+ AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'
+ AND serialno='" . $Item->BundleRef . "'";
$ErrMsg = _('The entered item code does not exist');
$Result = DB_query($SQL,$db,$ErrMsg);
@@ -242,7 +242,7 @@
if ($SerialItemExistsRow[0]==1){
$SQL = "UPDATE stockserialitems
- SET quantity= quantity - '" . $Item->BundleQty . "',
+ SET quantity= quantity - '" . filter_number_format($Item->BundleQty) . "',
expirationdate='" . FormatDateForSQL($Item->ExpiryDate) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'
@@ -260,9 +260,9 @@
quantity)
VALUES ('" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
'" . $_SESSION['Transfer']->StockLocationFrom . "',
- '" . $Item->BundleRef . "',
+ '" . DB_escape_string($Item->BundleRef) . "',
'" . FormatDateForSQL($Item->ExpiryDate) . "',
- '" . -$Item->BundleQty . "')";
+ '" . filter_number_format(-$Item->BundleQty) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be added because');
$DbgMsg = _('The following SQL to insert the serial stock item record was used');
@@ -280,8 +280,8 @@
VALUES (
'" . $StkMoveNo . "',
'" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- '" . $Item->BundleRef . "',
- '" . $Item->BundleQty . "'
+ '" . DB_escape_string($Item->BundleRef) . "',
+ '" . filter_number_format($Item->BundleQty) . "'
)";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock movement record could not be inserted because');
@@ -325,8 +325,7 @@
'" . $PeriodNo . "',
'" . _('From') . " " . $_SESSION['Transfer']->StockLocationFrom . "',
'" . $_SESSION['Transfer']->TransferItem[0]->Quantity . "',
- '" . ($QtyOnHandPrior + $_SESSION['Transfer']->TransferItem[0]->Quantity) . "'
- )";
+ '" . filter_number_format(round($QtyOnHandPrior + $_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The stock movement record cannot be inserted because');
$DbgMsg = _('The following SQL to insert the stock movement record was used');
@@ -344,11 +343,10 @@
/*First need to check if the serial items already exists or not in the location from */
$SQL = "SELECT COUNT(*)
- FROM stockserialitems
- WHERE
- stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
- AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'
- AND serialno='" . $Item->BundleRef . "'";
+ FROM stockserialitems
+ WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
+ AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'
+ AND serialno='" . $Item->BundleRef . "'";
$ErrMsg = _('Could not determine if the serial item exists in the transfer to location');
$Result = DB_query($SQL,$db,$ErrMsg);
@@ -357,11 +355,11 @@
if ($SerialItemExistsRow[0]==1){
$SQL = "UPDATE stockserialitems
- SET quantity= quantity + '" . $Item->BundleQty . "',
- expirationdate='" . FormatDateForSQL($Item->ExpiryDate) . "'
+ SET quantity= quantity + '" . filter_number_format($Item->BundleQty) . "',
+ expirationdate='" . FormatDateForSQL($Item->ExpiryDate) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'
- AND serialno='" . $Item->BundleRef . "'";
+ AND serialno='" . DB_escape_string($Item->BundleRef) . "'";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be updated because');
$DbgMsg = _('The following SQL to update the serial stock item record was used');
@@ -369,16 +367,16 @@
} else {
/*Need to insert a new serial item record */
$SQL = "INSERT INTO stockserialitems (stockid,
- loccode,
- serialno,
- expirationdate,
- quantity)
+ loccode,
+ serialno,
+ expirationdate,
+ quantity)
VALUES ('" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- '" . $_SESSION['Transfer']->StockLocationTo . "',
- '" . $Item->BundleRef . "',
- '" . FormatDateForSQL($Item->ExpiryDate) . "',
- '" . $Item->BundleQty . "')";
-
+ '" . $_SESSION['Transfer']->StockLocationTo . "',
+ '" . DB_escape_string($Item->BundleRef) . "',
+ '" . FormatDateForSQL($Item->ExpiryDate) . "',
+ '" . filter_number_format($Item->BundleQty) . "')";
+
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be added because');
$DbgMsg = _('The following SQL to insert the serial stock item record was used:');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
@@ -393,8 +391,8 @@
moveqty)
VALUES ('" . $StkMoveNo . "',
'" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- '" . $Item->BundleRef . "',
- '" . $Item->BundleQty . "')";
+ '" . DB_escape_string($Item->BundleRef) . "',
+ '" . filter_number_format($Item->BundleQty) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock movement record could not be inserted because');
$DbgMsg = _('The following SQL to insert the serial stock movement records was used');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
@@ -403,7 +401,7 @@
} /*end if the transfer item is a controlled item */
- $SQL = "UPDATE locstock SET quantity = quantity - '" . $_SESSION['Transfer']->TransferItem[0]->Quantity . "'
+ $SQL = "UPDATE locstock SET quantity = quantity - '" . filter_number_format(round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'";
@@ -412,11 +410,10 @@
$Result = DB_query($SQL,$db,$ErrMsg,$DbgMsg,true);
$SQL = "UPDATE locstock
- SET quantity = quantity + '" . $_SESSION['Transfer']->TransferItem[0]->Quantity . "'
+ SET quantity = quantity + '" . filter_number_format(round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'";
-
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The location stock record could not be updated because');
$DbgMsg = _('The following SQL to update the location stock record was used');
$Result = DB_query($SQL,$db,$ErrMsg, $DbgMsg, true);
@@ -438,22 +435,23 @@
echo '<form action="'. $_SERVER['PHP_SELF'] . '" method=post>';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
-
if (!isset($_GET['Description'])) {
$_GET['Description']='';
}
-echo '<table class=selection><tr><td>'. _('Stock Code'). ':</td><td>';
+echo '<table class="selection">
+ <tr><td>'. _('Stock Code'). ':</td><td>';
if (isset($_POST['StockID'])) {
- echo '<input type="text" name="StockID" size=21 value="' . $_POST['StockID'] . '" maxlength=20></td></tr>';
+ echo '<input type="text" name="StockID" size="21" value="' . $_POST['StockID'] . '" maxlength="20" /></td></tr>';
} else {
- echo '<input type="text" name="StockID" size=21 value="" maxlength=20></td></tr>';
+ echo '<input type="text" name="StockID" size="21" value="" maxlength="20" /></td></tr>';
}
-echo '<tr><td>'. _('Partial Description'). ':</td><td><input type="text" name="StockText" size=21 value="' .
- $_GET['Description'] .'"></td><td>'._('Partial Stock Code'). ':</td><td>';
+echo '<tr><td>'. _('Partial Description'). ':</td>
+ <td><input type="text" name="StockText" size="21" value="' . $_GET['Description'] .'"></td>
+ <td>'._('Partial Stock Code'). ':</td><td>';
if (isset($_POST['StockID'])) {
- echo '<input type="text" name="StockCode" size=21 value="' . $_POST['StockID'] .'" maxlength=20>';
+ echo '<input type="text" name="StockCode" size="21" value="' . $_POST['StockID'] .'" maxlength="20" />';
} else {
- echo '<input type="text" name="StockCode" size=21 value="" maxlength=20>';
+ echo '<input type="text" name="StockCode" size="21" value="" maxlength="20" />';
}
echo '</td><td><input type=submit name="CheckCode" value="'._('Check Part').'"></td></tr>';
@@ -461,19 +459,20 @@
echo '<tr><td colspan=3><font color=BLUE size=3>' . $_SESSION['Transfer']->TransferItem[0]->ItemDescription . ' ('._('In Units of').' ' . $_SESSION['Transfer']->TransferItem[0]->PartUnit . ' )</font></td></tr>';
}
-echo '<tr><td>' . _('From Stock Location').':</td><td><select name="StockLocationFrom">';
+echo '<tr><td>' . _('From Stock Location').':</td>
+ <td><select name="StockLocationFrom">';
$sql = "SELECT loccode, locationname FROM locations";
$resultStkLocs = DB_query($sql,$db);
while ($myrow=DB_fetch_array($resultStkLocs)){
if (isset($_SESSION['Transfer']->StockLocationFrom)){
if ($myrow['loccode'] == $_SESSION['Transfer']->StockLocationFrom){
- echo '<option selected Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option selected value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
} else {
- echo '<option Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
}
} elseif ($myrow['loccode']==$_SESSION['UserStockLocation']){
- echo '<option selected Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option selected value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
$_SESSION['Transfer']->StockLocationFrom=$myrow['loccode'] . '</option>';
} else {
echo '<option Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
@@ -482,7 +481,8 @@
echo '</select></td></tr>';
-echo '<tr><td>'. _('To Stock Location').': </td><td><select name="StockLocationTo"> ';
+echo '<tr><td>'. _('To Stock Location').': </td>
+ <td><select name="StockLocationTo"> ';
DB_data_seek($resultStkLocs,0);
@@ -503,21 +503,19 @@
echo '</select></td></tr>';
-
echo '<tr><td>'._('Transfer Quantity').':</td>';
if (isset($_SESSION['Transfer']->TransferItem[0]->Controlled) AND $_SESSION['Transfer']->TransferItem[0]->Controlled==1){
echo '<td class=number><input type=hidden name="Quantity" value=' . $_SESSION['Transfer']->TransferItem[0]->Quantity .
'><a href="' . $rootpath .'/StockTransferControlled.php?StockLocationFrom='.$_SESSION['Transfer']->StockLocationFrom.'">' . $_SESSION['Transfer']->TransferItem[0]->Quantity . '</a></td></tr>';
} elseif (isset($_SESSION['Transfer']->TransferItem[0]->Controlled)){
- echo '<td><input type="text" class="number" name="Quantity" size=12 maxlength=12 value=' . $_SESSION['Transfer']->TransferItem[0]->Quantity . '></td></tr>';
+ echo '<td><input type="text" class="number" name="Quantity" size="12" maxlength="12" value=' . locale_number_format($_SESSION['Transfer']->TransferItem[0]->Quantity) . '></td></tr>';
} else {
- echo '<td><input type="text" class="number" name="Quantity" size=12 maxlength=12 Value="0"></td></tr>';
+ echo '<td><input type="text" class="number" name="Quantity" size="12" maxlength="12" value="0"></td></tr>';
}
echo '</table><div class="centre"><br /><input type="submit" name="EnterTransfer" value="' . _('Enter Stock Transfer') . '"><br />';
-
if (empty($_SESSION['Transfer']->TransferItem[0]->StockID) and isset($_POST['StockID'])) {
$StockID=$_POST['StockID'];
} else if (isset($_SESSION['Transfer']->TransferItem[0]->StockID)) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <dai...@us...> - 2011-09-12 08:57:18
|
Revision: 4687
http://web-erp.svn.sourceforge.net/web-erp/?rev=4687&view=rev
Author: daintree
Date: 2011-09-12 08:57:11 +0000 (Mon, 12 Sep 2011)
Log Message:
-----------
number_formatting
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2011-09-12 08:03:20 UTC (rev 4686)
+++ trunk/StockTransfers.php 2011-09-12 08:57:11 UTC (rev 4687)
@@ -18,7 +18,7 @@
if (isset($_GET['From'])) {
$_POST['StockLocationFrom']=$_GET['From'];
$_POST['StockLocationTo']=$_GET['To'];
- $_POST['Quantity']=$_GET['Quantity'];
+ $_POST['Quantity']=filter_number_format($_GET['Quantity']);
}
if (isset($_POST['CheckCode'])) {
@@ -27,21 +27,27 @@
'" alt="" />' . ' ' . _('Select Item to Transfer') . '</p>';
if (mb_strlen($_POST['StockText'])>0) {
- $sql="SELECT stockid, description from stockmaster where description " . LIKE . " '%" . $_POST['StockText'] . "%'";
+ $sql="SELECT stockid,
+ description
+ FROM stockmaster
+ WHERE description " . LIKE . " '%" . $_POST['StockText'] . "%'";
} else {
- $sql="SELECT stockid, description from stockmaster where stockid " . LIKE . " '%" . $_POST['StockCode']."%'";
+ $sql="SELECT stockid,
+ description
+ FROM stockmaster
+ WHERE stockid " . LIKE . " '%" . $_POST['StockCode']."%'";
}
$ErrMsg=_('The stock information cannot be retrieved because');
$DbgMsg=_('The SQL to get the stock description was');
$result = DB_query($sql,$db,$ErrMsg,$DbgMsg);
- echo '<table class=selection>
+ echo '<table class="selection">
<tr><th>'._('Stock Code').'</th>
<th>'._('Stock Description').'</th>
</tr>';
while ($myrow = DB_fetch_array($result)) {
echo '<tr><td>'.$myrow['stockid'].'</td>
<td>'.$myrow['description'].'</td>
- <td><a href="' . $rootpath . '/StockTransfers.php?StockID='.$myrow['stockid'].'&Description='.$myrow['description'].'&NewTransfer=Yes&Quantity='.$_POST['Quantity'].'&From='.$_POST['StockLocationFrom'].'&To='.$_POST['StockLocationTo'].'">'
+ <td><a href="' . $rootpath . '/StockTransfers.php?StockID='.$myrow['stockid'].'&Description='.$myrow['description'].'&NewTransfer=Yes&Quantity='. filter_number_format($_POST['Quantity']).'&From='.$_POST['StockLocationFrom'].'&To='.$_POST['StockLocationTo'].'">'
._('Transfer').'</a></td>
</tr>';
@@ -61,11 +67,8 @@
if (isset($_GET['StockID'])){ /*carry the stockid through to the form for additional inputs */
-
$_POST['StockID'] = trim(mb_strtoupper($_GET['StockID']));
-
} elseif (isset($_POST['StockID'])){ /* initiate a new transfer only if the StockID is different to the previous entry */
-
if (isset($_SESSION['Transfer']) AND $_POST['StockID'] != $_SESSION['Transfer']->TransferItem[0]->StockID){
unset($_SESSION['Transfer']);
$NewTransfer = true;
@@ -99,7 +102,7 @@
$myrow = DB_fetch_row($result);
$_SESSION['Transfer']->TransferItem[0] = new LineItem ( trim(mb_strtoupper($_POST['StockID'])),
$myrow['description'],
- $_POST['Quantity'],
+ filter_number_format($_POST['Quantity']),
$myrow['units'],
$myrow['controlled'],
$myrow['serialised'],
@@ -107,27 +110,26 @@
$myrow['decimalplaces']);
- $_SESSION['Transfer']->TransferItem[0]->StandardCost = $myrow[3];
+ $_SESSION['Transfer']->TransferItem[0]->StandardCost = $myrow['standardcost'];
if ($myrow[2]=='D' OR $myrow[2]=='A' OR $myrow[2]=='K'){
prnMsg(_('The part entered is either or a dummy part or an assembly or a kit-set part') . '. ' . _('These parts are not physical parts and no stock holding is maintained for them') . '. ' . _('Stock Transfers are therefore not possible'),'warn');
- echo '.<hr>';
+ echo '.<hr />';
echo '<a href="' . $rootpath . '/StockTransfers.php?NewTransfer=Yes">' . _('Enter another Transfer') . '</a>';
unset ($_SESSION['Transfer']);
include ('includes/footer.inc');
exit;
}
}
-
}
if (isset($_POST['Quantity']) AND isset($_SESSION['Transfer']->TransferItem[0]->Controlled) AND $_SESSION['Transfer']->TransferItem[0]->Controlled==0){
- $_SESSION['Transfer']->TransferItem[0]->Quantity = $_POST['Quantity'];
+ $_SESSION['Transfer']->TransferItem[0]->Quantity = filter_number_format($_POST['Quantity']);
}
if ( isset($_POST['StockLocationFrom']) AND $_POST['StockLocationFrom']!= $_SESSION['Transfer']->StockLocationFrom ){
$_SESSION['Transfer']->StockLocationFrom = $_POST['StockLocationFrom'];
$_SESSION['Transfer']->StockLocationTo = $_POST['StockLocationTo'];
- $_SESSION['Transfer']->TransferItem[0]->Quantity=$_POST['Quantity'];
+ $_SESSION['Transfer']->TransferItem[0]->Quantity=filter_number_format($_POST['Quantity']);
$_SESSION['Transfer']->TransferItem[0]->SerialItems=array();
}
if ( isset($_POST['StockLocationTo']) ){
@@ -136,8 +138,6 @@
if ( isset($_POST['EnterTransfer']) ){
-
-
$result = DB_query("SELECT * FROM stockmaster WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID ."'",$db);
$myrow = DB_fetch_row($result);
$InputError = false;
@@ -193,25 +193,25 @@
}
// Insert the stock movement for the stock going out of the from location
$SQL = "INSERT INTO stockmoves (stockid,
- type,
- transno,
- loccode,
- trandate,
- prd,
- reference,
- qty,
- newqoh)
- VALUES (
- '" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- 16,
- '" . $TransferNumber . "',
- '" . $_SESSION['Transfer']->StockLocationFrom . "',
- '" . $SQLTransferDate . "',
- '" . $PeriodNo . "',
- 'To " . $_SESSION['Transfer']->StockLocationTo ."',
- '" . round(-$_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces) . "',
- '" . ($QtyOnHandPrior - round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) ."'
- )";
+ type,
+ transno,
+ loccode,
+ trandate,
+ prd,
+ reference,
+ qty,
+ newqoh)
+ VALUES (
+ '" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
+ 16,
+ '" . $TransferNumber . "',
+ '" . $_SESSION['Transfer']->StockLocationFrom . "',
+ '" . $SQLTransferDate . "',
+ '" . $PeriodNo . "',
+ 'To " . $_SESSION['Transfer']->StockLocationTo ."',
+ '" . filter_number_format(round(-$_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "',
+ '" . filter_number_format($QtyOnHandPrior - round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) ."'
+ )";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The stock movement record cannot be inserted because');
$DbgMsg = _('The following SQL to insert the stock movement record was used');
@@ -229,11 +229,11 @@
/*First need to check if the serial items already exists or not in the location from */
$SQL = "SELECT COUNT(*)
- FROM stockserialitems
- WHERE
- stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
- AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'
- AND serialno='" . $Item->BundleRef . "'";
+ FROM stockserialitems
+ WHERE
+ stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
+ AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'
+ AND serialno='" . $Item->BundleRef . "'";
$ErrMsg = _('The entered item code does not exist');
$Result = DB_query($SQL,$db,$ErrMsg);
@@ -242,7 +242,7 @@
if ($SerialItemExistsRow[0]==1){
$SQL = "UPDATE stockserialitems
- SET quantity= quantity - '" . $Item->BundleQty . "',
+ SET quantity= quantity - '" . filter_number_format($Item->BundleQty) . "',
expirationdate='" . FormatDateForSQL($Item->ExpiryDate) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'
@@ -260,9 +260,9 @@
quantity)
VALUES ('" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
'" . $_SESSION['Transfer']->StockLocationFrom . "',
- '" . $Item->BundleRef . "',
+ '" . DB_escape_string($Item->BundleRef) . "',
'" . FormatDateForSQL($Item->ExpiryDate) . "',
- '" . -$Item->BundleQty . "')";
+ '" . filter_number_format(-$Item->BundleQty) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be added because');
$DbgMsg = _('The following SQL to insert the serial stock item record was used');
@@ -280,8 +280,8 @@
VALUES (
'" . $StkMoveNo . "',
'" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- '" . $Item->BundleRef . "',
- '" . $Item->BundleQty . "'
+ '" . DB_escape_string($Item->BundleRef) . "',
+ '" . filter_number_format($Item->BundleQty) . "'
)";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock movement record could not be inserted because');
@@ -325,8 +325,7 @@
'" . $PeriodNo . "',
'" . _('From') . " " . $_SESSION['Transfer']->StockLocationFrom . "',
'" . $_SESSION['Transfer']->TransferItem[0]->Quantity . "',
- '" . ($QtyOnHandPrior + $_SESSION['Transfer']->TransferItem[0]->Quantity) . "'
- )";
+ '" . filter_number_format(round($QtyOnHandPrior + $_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The stock movement record cannot be inserted because');
$DbgMsg = _('The following SQL to insert the stock movement record was used');
@@ -344,11 +343,10 @@
/*First need to check if the serial items already exists or not in the location from */
$SQL = "SELECT COUNT(*)
- FROM stockserialitems
- WHERE
- stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
- AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'
- AND serialno='" . $Item->BundleRef . "'";
+ FROM stockserialitems
+ WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
+ AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'
+ AND serialno='" . $Item->BundleRef . "'";
$ErrMsg = _('Could not determine if the serial item exists in the transfer to location');
$Result = DB_query($SQL,$db,$ErrMsg);
@@ -357,11 +355,11 @@
if ($SerialItemExistsRow[0]==1){
$SQL = "UPDATE stockserialitems
- SET quantity= quantity + '" . $Item->BundleQty . "',
- expirationdate='" . FormatDateForSQL($Item->ExpiryDate) . "'
+ SET quantity= quantity + '" . filter_number_format($Item->BundleQty) . "',
+ expirationdate='" . FormatDateForSQL($Item->ExpiryDate) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'
- AND serialno='" . $Item->BundleRef . "'";
+ AND serialno='" . DB_escape_string($Item->BundleRef) . "'";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be updated because');
$DbgMsg = _('The following SQL to update the serial stock item record was used');
@@ -369,16 +367,16 @@
} else {
/*Need to insert a new serial item record */
$SQL = "INSERT INTO stockserialitems (stockid,
- loccode,
- serialno,
- expirationdate,
- quantity)
+ loccode,
+ serialno,
+ expirationdate,
+ quantity)
VALUES ('" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- '" . $_SESSION['Transfer']->StockLocationTo . "',
- '" . $Item->BundleRef . "',
- '" . FormatDateForSQL($Item->ExpiryDate) . "',
- '" . $Item->BundleQty . "')";
-
+ '" . $_SESSION['Transfer']->StockLocationTo . "',
+ '" . DB_escape_string($Item->BundleRef) . "',
+ '" . FormatDateForSQL($Item->ExpiryDate) . "',
+ '" . filter_number_format($Item->BundleQty) . "')";
+
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be added because');
$DbgMsg = _('The following SQL to insert the serial stock item record was used:');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
@@ -393,8 +391,8 @@
moveqty)
VALUES ('" . $StkMoveNo . "',
'" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
- '" . $Item->BundleRef . "',
- '" . $Item->BundleQty . "')";
+ '" . DB_escape_string($Item->BundleRef) . "',
+ '" . filter_number_format($Item->BundleQty) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock movement record could not be inserted because');
$DbgMsg = _('The following SQL to insert the serial stock movement records was used');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
@@ -403,7 +401,7 @@
} /*end if the transfer item is a controlled item */
- $SQL = "UPDATE locstock SET quantity = quantity - '" . $_SESSION['Transfer']->TransferItem[0]->Quantity . "'
+ $SQL = "UPDATE locstock SET quantity = quantity - '" . filter_number_format(round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationFrom . "'";
@@ -412,11 +410,10 @@
$Result = DB_query($SQL,$db,$ErrMsg,$DbgMsg,true);
$SQL = "UPDATE locstock
- SET quantity = quantity + '" . $_SESSION['Transfer']->TransferItem[0]->Quantity . "'
+ SET quantity = quantity + '" . filter_number_format(round($_SESSION['Transfer']->TransferItem[0]->Quantity,$_SESSION['Transfer']->TransferItem[0]->DecimalPlaces)) . "'
WHERE stockid='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'
AND loccode='" . $_SESSION['Transfer']->StockLocationTo . "'";
-
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The location stock record could not be updated because');
$DbgMsg = _('The following SQL to update the location stock record was used');
$Result = DB_query($SQL,$db,$ErrMsg, $DbgMsg, true);
@@ -438,22 +435,23 @@
echo '<form action="'. $_SERVER['PHP_SELF'] . '" method=post>';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
-
if (!isset($_GET['Description'])) {
$_GET['Description']='';
}
-echo '<table class=selection><tr><td>'. _('Stock Code'). ':</td><td>';
+echo '<table class="selection">
+ <tr><td>'. _('Stock Code'). ':</td><td>';
if (isset($_POST['StockID'])) {
- echo '<input type="text" name="StockID" size=21 value="' . $_POST['StockID'] . '" maxlength=20></td></tr>';
+ echo '<input type="text" name="StockID" size="21" value="' . $_POST['StockID'] . '" maxlength="20" /></td></tr>';
} else {
- echo '<input type="text" name="StockID" size=21 value="" maxlength=20></td></tr>';
+ echo '<input type="text" name="StockID" size="21" value="" maxlength="20" /></td></tr>';
}
-echo '<tr><td>'. _('Partial Description'). ':</td><td><input type="text" name="StockText" size=21 value="' .
- $_GET['Description'] .'"></td><td>'._('Partial Stock Code'). ':</td><td>';
+echo '<tr><td>'. _('Partial Description'). ':</td>
+ <td><input type="text" name="StockText" size="21" value="' . $_GET['Description'] .'"></td>
+ <td>'._('Partial Stock Code'). ':</td><td>';
if (isset($_POST['StockID'])) {
- echo '<input type="text" name="StockCode" size=21 value="' . $_POST['StockID'] .'" maxlength=20>';
+ echo '<input type="text" name="StockCode" size="21" value="' . $_POST['StockID'] .'" maxlength="20" />';
} else {
- echo '<input type="text" name="StockCode" size=21 value="" maxlength=20>';
+ echo '<input type="text" name="StockCode" size="21" value="" maxlength="20" />';
}
echo '</td><td><input type=submit name="CheckCode" value="'._('Check Part').'"></td></tr>';
@@ -461,19 +459,20 @@
echo '<tr><td colspan=3><font color=BLUE size=3>' . $_SESSION['Transfer']->TransferItem[0]->ItemDescription . ' ('._('In Units of').' ' . $_SESSION['Transfer']->TransferItem[0]->PartUnit . ' )</font></td></tr>';
}
-echo '<tr><td>' . _('From Stock Location').':</td><td><select name="StockLocationFrom">';
+echo '<tr><td>' . _('From Stock Location').':</td>
+ <td><select name="StockLocationFrom">';
$sql = "SELECT loccode, locationname FROM locations";
$resultStkLocs = DB_query($sql,$db);
while ($myrow=DB_fetch_array($resultStkLocs)){
if (isset($_SESSION['Transfer']->StockLocationFrom)){
if ($myrow['loccode'] == $_SESSION['Transfer']->StockLocationFrom){
- echo '<option selected Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option selected value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
} else {
- echo '<option Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
}
} elseif ($myrow['loccode']==$_SESSION['UserStockLocation']){
- echo '<option selected Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option selected value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
$_SESSION['Transfer']->StockLocationFrom=$myrow['loccode'] . '</option>';
} else {
echo '<option Value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
@@ -482,7 +481,8 @@
echo '</select></td></tr>';
-echo '<tr><td>'. _('To Stock Location').': </td><td><select name="StockLocationTo"> ';
+echo '<tr><td>'. _('To Stock Location').': </td>
+ <td><select name="StockLocationTo"> ';
DB_data_seek($resultStkLocs,0);
@@ -503,21 +503,19 @@
echo '</select></td></tr>';
-
echo '<tr><td>'._('Transfer Quantity').':</td>';
if (isset($_SESSION['Transfer']->TransferItem[0]->Controlled) AND $_SESSION['Transfer']->TransferItem[0]->Controlled==1){
echo '<td class=number><input type=hidden name="Quantity" value=' . $_SESSION['Transfer']->TransferItem[0]->Quantity .
'><a href="' . $rootpath .'/StockTransferControlled.php?StockLocationFrom='.$_SESSION['Transfer']->StockLocationFrom.'">' . $_SESSION['Transfer']->TransferItem[0]->Quantity . '</a></td></tr>';
} elseif (isset($_SESSION['Transfer']->TransferItem[0]->Controlled)){
- echo '<td><input type="text" class="number" name="Quantity" size=12 maxlength=12 value=' . $_SESSION['Transfer']->TransferItem[0]->Quantity . '></td></tr>';
+ echo '<td><input type="text" class="number" name="Quantity" size="12" maxlength="12" value=' . locale_number_format($_SESSION['Transfer']->TransferItem[0]->Quantity) . '></td></tr>';
} else {
- echo '<td><input type="text" class="number" name="Quantity" size=12 maxlength=12 Value="0"></td></tr>';
+ echo '<td><input type="text" class="number" name="Quantity" size="12" maxlength="12" value="0"></td></tr>';
}
echo '</table><div class="centre"><br /><input type="submit" name="EnterTransfer" value="' . _('Enter Stock Transfer') . '"><br />';
-
if (empty($_SESSION['Transfer']->TransferItem[0]->StockID) and isset($_POST['StockID'])) {
$StockID=$_POST['StockID'];
} else if (isset($_SESSION['Transfer']->TransferItem[0]->StockID)) {
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:54:00
|
Revision: 4880
http://web-erp.svn.sourceforge.net/web-erp/?rev=4880&view=rev
Author: ExsonQu
Date: 2012-02-07 04:53:54 +0000 (Tue, 07 Feb 2012)
Log Message:
-----------
Add definition of $_POST['StockLocationFrom'] and $_POST['StockLocationTo'] to fix bug 'The entered item code does not exist' reported by PakRichard.
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2012-02-07 04:50:18 UTC (rev 4879)
+++ trunk/StockTransfers.php 2012-02-07 04:53:54 UTC (rev 4880)
@@ -83,6 +83,13 @@
if ($NewTransfer){
+ if(!isset($_POST['StockLocationFrom'])){
+ $_POST['StockLocationFrom']='';
+ }
+ if(!isset($_POST['StockLocationTo'])){
+ $_POST['StockLocationTo']='';
+ }
+
$_SESSION['Transfer']= new StockTransfer(0,
$_POST['StockLocationFrom'],
'',
@@ -569,4 +576,4 @@
echo '</div>
</form>';
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:54:00
|
Revision: 4880
http://web-erp.svn.sourceforge.net/web-erp/?rev=4880&view=rev
Author: ExsonQu
Date: 2012-02-07 04:53:54 +0000 (Tue, 07 Feb 2012)
Log Message:
-----------
Add definition of $_POST['StockLocationFrom'] and $_POST['StockLocationTo'] to fix bug 'The entered item code does not exist' reported by PakRichard.
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2012-02-07 04:50:18 UTC (rev 4879)
+++ trunk/StockTransfers.php 2012-02-07 04:53:54 UTC (rev 4880)
@@ -83,6 +83,13 @@
if ($NewTransfer){
+ if(!isset($_POST['StockLocationFrom'])){
+ $_POST['StockLocationFrom']='';
+ }
+ if(!isset($_POST['StockLocationTo'])){
+ $_POST['StockLocationTo']='';
+ }
+
$_SESSION['Transfer']= new StockTransfer(0,
$_POST['StockLocationFrom'],
'',
@@ -569,4 +576,4 @@
echo '</div>
</form>';
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...> - 2013-08-21 10:57:45
|
Revision: 6282
http://sourceforge.net/p/web-erp/reponame/6282
Author: exsonqu
Date: 2013-08-21 10:57:39 +0000 (Wed, 21 Aug 2013)
Log Message:
-----------
21/8/2013 Thumb: Fixed the object no definition error in StockTransfers.php.
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2013-08-21 08:46:12 UTC (rev 6281)
+++ trunk/StockTransfers.php 2013-08-21 10:57:39 UTC (rev 6282)
@@ -46,8 +46,8 @@
$result = DB_query($sql,$db,$ErrMsg,$DbgMsg);
echo '<table class="selection">
<tr>
- <th>'._('Stock Code').'</th>
- <th>'._('Stock Description').'</th>
+ <th class="ascending" onclick="SortSelect(this)">'._('Stock Code').'</th>
+ <th class="ascending" onclick="SortSelect(this)">'._('Stock Description').'</th>
</tr>';
while ($myrow = DB_fetch_array($result)) {
echo '<tr>
@@ -469,18 +469,18 @@
<tr>
<td>'. _('Stock Code'). ':</td>
<td>';
-if (isset($_POST['StockID'])) {
- echo '<input type="text" name="StockID" size="21" value="' . $_POST['StockID'] . '" maxlength="20" /></td></tr>';
-} else {
- echo '<input type="text" name="StockID" size="21" value="" maxlength="20" /></td></tr>';
+if (!isset($_POST['StockID'])) {
+ $_POST['StockID'] = '';
}
+ echo '<input type="text" title="'._('The stock ID should not be blank or contains illegal characters, you can choose left this blank and only keyin')._('Partial Stock Code')._('or')._('Partial Description')._('then push')._('Check Part').'" name="StockID" size="21" value="' . $_POST['StockID'] . '" maxlength="20" /></td></tr>';
+
echo '<tr><td>'. _('Partial Description'). ':</td>
- <td><input type="text" name="StockText" size="21" value="' . $_GET['Description'] .'" /></td>
+ <td><input type="text" name="StockText" title="'._('You can key in part of stock description or left this and ')._('Partial Stock Code')._('blank and click ')._('Check Part').' '._('to view the whole stock list').'" size="21" value="' . $_GET['Description'] .'" /></td>
<td>'._('Partial Stock Code'). ':</td><td>';
if (isset($_POST['StockID'])) {
- echo '<input type="text" name="StockCode" size="21" value="' . $_POST['StockID'] .'" maxlength="20" />';
+ echo '<input type="text" title="'._('You can key in partial of the stock code or just left this blank to click').' '._('Check Part').'" name="StockCode" size="21" value="' . $_POST['StockID'] .'" maxlength="20" />';
} else {
- echo '<input type="text" name="StockCode" size="21" value="" maxlength="20" />';
+ echo '<input type="text" title="'._('You can key in partial of the stock code or just left this blank to click').' '._('Check Part').'" name="StockCode" size="21" value="" maxlength="20" />';
}
echo '</td><td><input type="submit" name="CheckCode" value="'._('Check Part').'" /></td></tr>';
@@ -506,7 +506,8 @@
echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
}
} elseif ($myrow['loccode']==$_SESSION['UserStockLocation']){
- echo '<option selected="selected" value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option selected="selected" value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ if(isset($_SESSION['Transfer']))
$_SESSION['Transfer']->StockLocationFrom=$myrow['loccode'];
} else {
echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
@@ -530,7 +531,8 @@
echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
}
} elseif ($myrow['loccode']==$_SESSION['UserStockLocation'] AND isset($_SESSION['Transfer'])){
- echo '<option selected="selected" value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ echo '<option selected="selected" value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
+ if(isset($_SESSION['Transfer']))
$_SESSION['Transfer']->StockLocationTo=$myrow['loccode'];
} else {
echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
@@ -547,9 +549,9 @@
echo '<td class="number"><input type="hidden" name="Quantity" value="' . locale_number_format($_SESSION['Transfer']->TransferItem[0]->Quantity) . '" /><a href="' . $RootPath .'/StockTransferControlled.php?StockLocationFrom='.$_SESSION['Transfer']->StockLocationFrom.'">' . $_SESSION['Transfer']->TransferItem[0]->Quantity . '</a></td></tr>';
} elseif (isset($_SESSION['Transfer']->TransferItem[0]->Controlled)){
- echo '<td><input type="text" class="number" name="Quantity" size="12" maxlength="12" value="' . locale_number_format($_SESSION['Transfer']->TransferItem[0]->Quantity) . '" /></td></tr>';
+ echo '<td><input type="text" class="number" name="Quantity" title="'._('The transfer quantity cannot be zero').'" size="12" maxlength="12" value="' . locale_number_format($_SESSION['Transfer']->TransferItem[0]->Quantity) . '" /></td></tr>';
} else {
- echo '<td><input type="text" class="number" name="Quantity" size="12" maxlength="12" value="0" /></td>
+ echo '<td><input type="text" class="number" title="'._('The transfer quantity cannot be zer0').'" name="Quantity" size="12" maxlength="12" value="0" /></td>
</tr>';
}
|
|
From: <ex...@us...> - 2014-01-16 06:12:58
|
Revision: 6542
http://sourceforge.net/p/web-erp/reponame/6542
Author: exsonqu
Date: 2014-01-16 06:12:51 +0000 (Thu, 16 Jan 2014)
Log Message:
-----------
16/01/14 Exson: Fixed sql strict mode failure problem in StockTransfers.php by adding a '' to qualitytext fields.
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2014-01-15 06:28:12 UTC (rev 6541)
+++ trunk/StockTransfers.php 2014-01-16 06:12:51 UTC (rev 6542)
@@ -395,12 +395,14 @@
loccode,
serialno,
expirationdate,
- quantity)
+ quantity,
+ qualitytext)
VALUES ('" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
'" . $_SESSION['Transfer']->StockLocationTo . "',
'" . $Item->BundleRef . "',
'" . FormatDateForSQL($Item->ExpiryDate) . "',
- '" . $Item->BundleQty . "')";
+ '" . $Item->BundleQty . "',
+ '')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be added because');
$DbgMsg = _('The following SQL to insert the serial stock item record was used:');
|
|
From: <te...@us...> - 2016-02-20 08:27:31
|
Revision: 7462
http://sourceforge.net/p/web-erp/reponame/7462
Author: tehonu
Date: 2016-02-20 08:27:29 +0000 (Sat, 20 Feb 2016)
Log Message:
-----------
Avoid error in error_log PHP Strict Standards: Only variables should be passed by reference in weberp/StockTransfers.php
Modified Paths:
--------------
trunk/StockTransfers.php
Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php 2016-02-20 08:04:49 UTC (rev 7461)
+++ trunk/StockTransfers.php 2016-02-20 08:27:29 UTC (rev 7462)
@@ -230,7 +230,8 @@
WHERE stockmaster.stockid ='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'";
$ErrMsg = _('The standard cost of the item cannot be retrieved because');
$DbgMsg = _('The SQL that failed was');
- $myrow = DB_fetch_array(DB_query($SQLstandardcost,$ErrMsg,$DbgMsg));
+ $ResultStandardCost = DB_query($SQLstandardcost,$ErrMsg,$DbgMsg);
+ $myrow = DB_fetch_array($ResultStandardCost);
$StandardCost = $myrow['standardcost'];// QUESTION: Standard cost for: Assembly (value="A") and Manufactured (value="M") items ?
// Insert record:
$SQL = "INSERT INTO gltrans (
@@ -385,7 +386,8 @@
WHERE stockmaster.stockid ='" . $_SESSION['Transfer']->TransferItem[0]->StockID . "'";
$ErrMsg = _('The standard cost of the item cannot be retrieved because');
$DbgMsg = _('The SQL that failed was');
- $myrow = DB_fetch_array(DB_query($SQLstandardcost,$ErrMsg,$DbgMsg));
+ $ResultStandardCost = DB_query($SQLstandardcost,$ErrMsg,$DbgMsg);
+ $myrow = DB_fetch_array($ResultStandardCost);
$StandardCost = $myrow['standardcost'];// QUESTION: Standard cost for: Assembly (value="A") and Manufactured (value="M") items ?
// Insert record:
$SQL = "INSERT INTO gltrans (
|
×
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