Menu
▾
▴
web-erp-svn
|
From: <Ex...@us...> - 2012-04-01 16:40:00
|
Revision: 5190
http://web-erp.svn.sourceforge.net/web-erp/?rev=5190&view=rev
Author: ExsonQu
Date: 2012-04-01 16:39:53 +0000 (Sun, 01 Apr 2012)
Log Message:
-----------
2/4/2012 Exson: Fixed sql error for CopyBOM.php and header already sent by errors.
Modified Paths:
--------------
trunk/CopyBOM.php
Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php 2012-04-01 16:35:32 UTC (rev 5189)
+++ trunk/CopyBOM.php 2012-04-01 16:39:53 UTC (rev 5190)
@@ -6,10 +6,10 @@
*/
/* $Id$*/
+$title = _('Copy a BOM to New Item Code');
+
include('includes/session.inc');
-$title = _('Copy a BOM to New Item Code');
-
include('includes/header.inc');
include('includes/SQL_CommonFunctions.inc');
@@ -29,14 +29,40 @@
if($type == 'N') {
/* duplicate rows into stockmaster */
- $sql = "INSERT INTO stockmaster
+ $sql = "INSERT INTO stockmaster( stockid,
+ categoryid,
+ description,
+ longdescription,
+ units,
+ mbflag,
+ actualcost,
+ lastcost,
+ materialcost,
+ labourcost,
+ overheadcost,
+ lowestlevel,
+ discontinued,
+ controlled,
+ eoq,
+ volume,
+ kgs,
+ barcode,
+ discountcategory,
+ taxcatid,
+ serialised,
+ appendfile,
+ perishable,
+ decimalplaces,
+ nextserialno,
+ pansize,
+ shrinkfactor,
+ netweight )
SELECT '".$newstkid."' AS stockid,
categoryid,
description,
longdescription,
units,
mbflag,
- lastcurcostdate,
actualcost,
lastcost,
materialcost,
@@ -117,12 +143,12 @@
UpdateCost($db, $newstkid);
header('Location: BOMs.php?Select='.$newstkid);
+ ob_end_flush();
} else {
echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/inventory.png" title="' . _('Contract') . '" alt="" />' . ' ' . $title . '</p>';
echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '">';
- echo '<div>';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
$sql = "SELECT stockid,
@@ -142,8 +168,8 @@
echo '</select></td>
</tr>';
echo '<tr>
- <td><input type="radio" name="type" value="N" />' . _(' To New Stock ID') . '</td>';
- echo '<td><input type="text" maxlength="20" name="tostkid" /></td></tr>';
+ <td><input type="radio" name="type" value="N" checked="" />' . _(' To New Stock ID') . '</td></td><td>';
+ echo '<input type="text" maxlength="20" name="tostkid" /></td></tr>';
$sql = "SELECT stockid,
description
@@ -154,19 +180,16 @@
if (DB_num_rows($result) > 0) {
echo '<tr>
- <td><input type="radio" name="type" value="E" />'._('To Existing Stock ID') . '</td>';
- echo '<td><select name="exstkid">';
+ <td><input type="radio" name="type" value="E" />'._('To Existing Stock ID') . '</td><td>';
+ echo '<select name="exstkid">';
while($row = DB_fetch_row($result)) {
echo '<option value="'.$row[0].'">'.$row[0].' -- '.$row[1].'</option>';
}
- echo '</select></td>';
- echo '</tr>';
+ echo '</select>';
}
echo '</table>';
- echo '<br /><div class="centre"><input type="submit" name="Submit" value="Submit" /></div>
- </div>
- </form>';
+ echo '<br /><div class="centre"><input type="submit" name="Submit" value="Submit" /></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-04-01 16:40:00
|
Revision: 5190
http://web-erp.svn.sourceforge.net/web-erp/?rev=5190&view=rev
Author: ExsonQu
Date: 2012-04-01 16:39:53 +0000 (Sun, 01 Apr 2012)
Log Message:
-----------
2/4/2012 Exson: Fixed sql error for CopyBOM.php and header already sent by errors.
Modified Paths:
--------------
trunk/CopyBOM.php
Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php 2012-04-01 16:35:32 UTC (rev 5189)
+++ trunk/CopyBOM.php 2012-04-01 16:39:53 UTC (rev 5190)
@@ -6,10 +6,10 @@
*/
/* $Id$*/
+$title = _('Copy a BOM to New Item Code');
+
include('includes/session.inc');
-$title = _('Copy a BOM to New Item Code');
-
include('includes/header.inc');
include('includes/SQL_CommonFunctions.inc');
@@ -29,14 +29,40 @@
if($type == 'N') {
/* duplicate rows into stockmaster */
- $sql = "INSERT INTO stockmaster
+ $sql = "INSERT INTO stockmaster( stockid,
+ categoryid,
+ description,
+ longdescription,
+ units,
+ mbflag,
+ actualcost,
+ lastcost,
+ materialcost,
+ labourcost,
+ overheadcost,
+ lowestlevel,
+ discontinued,
+ controlled,
+ eoq,
+ volume,
+ kgs,
+ barcode,
+ discountcategory,
+ taxcatid,
+ serialised,
+ appendfile,
+ perishable,
+ decimalplaces,
+ nextserialno,
+ pansize,
+ shrinkfactor,
+ netweight )
SELECT '".$newstkid."' AS stockid,
categoryid,
description,
longdescription,
units,
mbflag,
- lastcurcostdate,
actualcost,
lastcost,
materialcost,
@@ -117,12 +143,12 @@
UpdateCost($db, $newstkid);
header('Location: BOMs.php?Select='.$newstkid);
+ ob_end_flush();
} else {
echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/inventory.png" title="' . _('Contract') . '" alt="" />' . ' ' . $title . '</p>';
echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '">';
- echo '<div>';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
$sql = "SELECT stockid,
@@ -142,8 +168,8 @@
echo '</select></td>
</tr>';
echo '<tr>
- <td><input type="radio" name="type" value="N" />' . _(' To New Stock ID') . '</td>';
- echo '<td><input type="text" maxlength="20" name="tostkid" /></td></tr>';
+ <td><input type="radio" name="type" value="N" checked="" />' . _(' To New Stock ID') . '</td></td><td>';
+ echo '<input type="text" maxlength="20" name="tostkid" /></td></tr>';
$sql = "SELECT stockid,
description
@@ -154,19 +180,16 @@
if (DB_num_rows($result) > 0) {
echo '<tr>
- <td><input type="radio" name="type" value="E" />'._('To Existing Stock ID') . '</td>';
- echo '<td><select name="exstkid">';
+ <td><input type="radio" name="type" value="E" />'._('To Existing Stock ID') . '</td><td>';
+ echo '<select name="exstkid">';
while($row = DB_fetch_row($result)) {
echo '<option value="'.$row[0].'">'.$row[0].' -- '.$row[1].'</option>';
}
- echo '</select></td>';
- echo '</tr>';
+ echo '</select>';
}
echo '</table>';
- echo '<br /><div class="centre"><input type="submit" name="Submit" value="Submit" /></div>
- </div>
- </form>';
+ echo '<br /><div class="centre"><input type="submit" name="Submit" value="Submit" /></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: <dai...@us...> - 2014-09-06 03:14:52
|
Revision: 6865
http://sourceforge.net/p/web-erp/reponame/6865
Author: daintree
Date: 2014-09-06 03:14:43 +0000 (Sat, 06 Sep 2014)
Log Message:
-----------
Bob Thomas and Andrew Galuski: Fix CopyBOM.php missing fields following changes for bin and sequence
Modified Paths:
--------------
trunk/CopyBOM.php
Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php 2014-09-05 02:19:24 UTC (rev 6864)
+++ trunk/CopyBOM.php 2014-09-06 03:14:43 UTC (rev 6865)
@@ -134,18 +134,18 @@
$result = DB_query($sql, $db);
if($NewOrExisting == 'N') {
- $sql = "INSERT INTO locstock (
- loccode,
- stockid,
- quantity,
- reorderlevel
- )
- SELECT loccode,
- '".$NewStockID."' AS stockid,
- 0 AS quantity,
- reorderlevel
- FROM locstock
- WHERE stockid='".$StockID."'";
+ $sql = "INSERT INTO locstock (loccode,
+ stockid,
+ quantity,
+ reorderlevel,
+ bin )
+ SELECT loccode,
+ '".$NewStockID."' AS stockid,
+ 0 AS quantity,
+ reorderlevel,
+ bin
+ FROM locstock
+ WHERE stockid='".$StockID."'";
$result = DB_query($sql, $db);
}
|
|
From: <ex...@us...> - 2015-02-03 11:32:08
|
Revision: 7119
http://sourceforge.net/p/web-erp/reponame/7119
Author: exsonqu
Date: 2015-02-03 11:31:59 +0000 (Tue, 03 Feb 2015)
Log Message:
-----------
03/02/15 Exson: Fixed date compatible problem for strict sql mode in CopyBOM.php.
Modified Paths:
--------------
trunk/CopyBOM.php
Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php 2015-02-03 08:56:58 UTC (rev 7118)
+++ trunk/CopyBOM.php 2015-02-03 11:31:59 UTC (rev 7119)
@@ -108,7 +108,7 @@
$myrow = DB_fetch_row($result);
$sql = "UPDATE stockmaster set
- lastcostupdate = " . $myrow[0] . ",
+ lastcostupdate = '" . $myrow[0] . "',
actualcost = " . $myrow[1] . ",
lastcost = " . $myrow[2] . ",
materialcost = " . $myrow[3] . ",
@@ -208,4 +208,4 @@
include('includes/footer.inc');
}
-?>
\ No newline at end of file
+?>
|
|
From: <ex...@us...> - 2016-04-07 06:35:09
|
Revision: 7484
http://sourceforge.net/p/web-erp/reponame/7484
Author: exsonqu
Date: 2016-04-07 06:35:08 +0000 (Thu, 07 Apr 2016)
Log Message:
-----------
07/04/16 Exson: Add remark column to CopyBOM.php.
Modified Paths:
--------------
trunk/CopyBOM.php
Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php 2016-04-01 08:37:57 UTC (rev 7483)
+++ trunk/CopyBOM.php 2016-04-07 06:35:08 UTC (rev 7484)
@@ -128,7 +128,8 @@
effectiveafter,
effectiveto,
quantity,
- autoissue
+ autoissue,
+ remark
FROM bom
WHERE parent='".$StockID."';";
$result = DB_query($sql);
|
|
From: <ex...@us...> - 2016-06-20 06:40:23
|
Revision: 7558
http://sourceforge.net/p/web-erp/reponame/7558
Author: exsonqu
Date: 2016-06-20 06:40:21 +0000 (Mon, 20 Jun 2016)
Log Message:
-----------
20/06/16 Exson: Fixed the bug of missing fields in CopyBOM.php. Reported by Shane.
Modified Paths:
--------------
trunk/CopyBOM.php
Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php 2016-06-16 11:12:38 UTC (rev 7557)
+++ trunk/CopyBOM.php 2016-06-20 06:40:21 UTC (rev 7558)
@@ -129,7 +129,9 @@
effectiveto,
quantity,
autoissue,
- remark
+ remark,
+ digitals,
+ decimalplaces
FROM bom
WHERE parent='".$StockID."';";
$result = DB_query($sql);
|
×
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