web-erp-svn

[Web-erp-svn] SF.net SVN: web-erp:[4966] trunk/StockMovements.php

[<Ex...@us...>]

Revision: 4966
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4966&view=rev
Author:   ExsonQu
Date:     2012-02-24 10:09:32 +0000 (Fri, 24 Feb 2012)
Log Message:
-----------
Change the order of date to make it to more friendly. Suggested by James Dupin, Fixed by Exson

Modified Paths:
--------------
    trunk/StockMovements.php

Modified: trunk/StockMovements.php
===================================================================
--- trunk/StockMovements.php	2012-02-24 09:39:59 UTC (rev 4965)
+++ trunk/StockMovements.php	2012-02-24 10:09:32 UTC (rev 4966)
@@ -54,7 +54,7 @@
 echo '</select></th>
 	</tr>';
 echo '<tr>
-		<th colspan="10">' . _('Show Movements before') . ': <input type="text" name="BeforeDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['BeforeDate'] . '" /> ' . _('But after') . ': <input type="text" name="AfterDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['AfterDate'] . '" /><input type="submit" name="ShowMoves" value="' . _('Show Stock Movements') . '" /></th>
+		<th colspan="10">' . _('Show Movements between') . ': <input type="text" name="AfterDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['AfterDate'] . '" /> ' . _('and') . ': <input type="text" name="BeforeDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['BeforeDate'] . '" /><input type="submit" name="ShowMoves" value="' . _('Show Stock Movements') . '" /></th>
 	</tr>';
 
 $SQLBeforeDate = FormatDateForSQL($_POST['BeforeDate']);
@@ -207,4 +207,4 @@
 
 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.

[Web-erp-svn] SF.net SVN: web-erp:[4966] trunk/StockMovements.php

[<Ex...@us...>]

Revision: 4966
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4966&view=rev
Author:   ExsonQu
Date:     2012-02-24 10:09:32 +0000 (Fri, 24 Feb 2012)
Log Message:
-----------
Change the order of date to make it to more friendly. Suggested by James Dupin, Fixed by Exson

Modified Paths:
--------------
    trunk/StockMovements.php

Modified: trunk/StockMovements.php
===================================================================
--- trunk/StockMovements.php	2012-02-24 09:39:59 UTC (rev 4965)
+++ trunk/StockMovements.php	2012-02-24 10:09:32 UTC (rev 4966)
@@ -54,7 +54,7 @@
 echo '</select></th>
 	</tr>';
 echo '<tr>
-		<th colspan="10">' . _('Show Movements before') . ': <input type="text" name="BeforeDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['BeforeDate'] . '" /> ' . _('But after') . ': <input type="text" name="AfterDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['AfterDate'] . '" /><input type="submit" name="ShowMoves" value="' . _('Show Stock Movements') . '" /></th>
+		<th colspan="10">' . _('Show Movements between') . ': <input type="text" name="AfterDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['AfterDate'] . '" /> ' . _('and') . ': <input type="text" name="BeforeDate" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" size="12" maxlength="12" value="' . $_POST['BeforeDate'] . '" /><input type="submit" name="ShowMoves" value="' . _('Show Stock Movements') . '" /></th>
 	</tr>';
 
 $SQLBeforeDate = FormatDateForSQL($_POST['BeforeDate']);
@@ -207,4 +207,4 @@
 
 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.

[Web-erp-svn] SF.net SVN: web-erp:[7022] trunk/StockMovements.php

[<te...@us...>]

Revision: 7022
          http://sourceforge.net/p/web-erp/reponame/7022
Author:   tehonu
Date:     2014-12-14 02:40:23 +0000 (Sun, 14 Dec 2014)
Log Message:
-----------
Fixed bug showing Credit Notes

Modified Paths:
--------------
    trunk/StockMovements.php

Modified: trunk/StockMovements.php
===================================================================
--- trunk/StockMovements.php	2014-12-14 02:04:44 UTC (rev 7021)
+++ trunk/StockMovements.php	2014-12-14 02:40:23 UTC (rev 7022)
@@ -171,8 +171,8 @@
 				$myrow['transno'],
 				$myrow['typename'],
 				$myrow['transno'],
+				$DisplayTranDate,
 				$myrow['userid'],
-				$DisplayTranDate,
 				$myrow['debtorno'],
 				$myrow['branchcode'],
 				locale_number_format($myrow['qty'],$myrow['decimalplaces']),

[Web-erp-svn] SF.net SVN: web-erp:[7329] trunk/StockMovements.php

[<te...@us...>]

Revision: 7329
          http://sourceforge.net/p/web-erp/reponame/7329
Author:   tehonu
Date:     2015-07-28 01:00:01 +0000 (Tue, 28 Jul 2015)
Log Message:
-----------
Show locations order by locationname

Modified Paths:
--------------
    trunk/StockMovements.php

Modified: trunk/StockMovements.php
===================================================================
--- trunk/StockMovements.php	2015-07-27 16:52:54 UTC (rev 7328)
+++ trunk/StockMovements.php	2015-07-28 01:00:01 UTC (rev 7329)
@@ -38,7 +38,12 @@
 echo '  ' . _('From Stock Location') . ':<select name="StockLocation"> ';
 
 $sql = "SELECT locations.loccode, locationname FROM locations
-		INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1";
+		INNER JOIN locationusers 
+			ON locationusers.loccode=locations.loccode 
+				AND locationusers.userid='" .  $_SESSION['UserID'] . "' 
+				AND locationusers.canview=1
+		ORDER BY locationname
+		";
 $resultStkLocs = DB_query($sql);
 
 while ($myrow=DB_fetch_array($resultStkLocs)){