18 Commits

Author SHA1 Message Date
jekkos
6e6cfb3fb1 Database script renamed
git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@129 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:56:18 +00:00
jekkos
04e3c13dd1 Default stock name is the same as in update script
git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@128 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:56:14 +00:00
jekkos
4ca452ef12 Fixed sale suspending / unsuspending (adapt db scripts)
Cleanup old code
More code review
Update item_quantities database model (composite pk)

git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@120 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:55:46 +00:00
jekkos
249274e5f5 Add foregin key constraints to stock_locations and item_quantities tables
Requisition options is only shown when multiple stock locations are configured
Fix stock locations config in the configuration page
Rename item_quantitys to item_quantities
Fix a missing label (need to check if present in master)
Fix display of the stock quantities in items/manage view

git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@119 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:55:40 +00:00
jekkos
2ce140f6d3 Added empty check in stock_locations config
Rework database script (contains stock_locations + item_quantities tables)

git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@117 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:55:30 +00:00
jekkos
1c6e44af0f Add multi-stock feature
Finished task
1. User can add stock location in config page. Adding format is StockA,StockB,StockC for example
2. Item page, there is no more quantity column show in cert table. The quantity tracking is integrated in inventory detail
3. Receiving page, There is a stock location for user to select before receiving or returning stuff
4. Sale page, There is a stock location which is for user to select a stock location they sell from

Remain task
1. Requisition work flow
2. Language editing
3. Remove unuse code

PS

git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@115 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:55:24 +00:00
jekkos
6ff1cb007c requisition receipt fixed
database.sql script merged with current ospos one
remaining problems in reporting (sale_type to add in sales_temp query?)
data model should be refactored to allow more genericity for custom item locations (2+)
inventory tracking should be adapted to use multiple locations (instead of duplicating items for different locations)

git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@113 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-08-19 19:55:13 +00:00
jekkos
3838147bb9 All database types used in amount calculations changes to decimal(15,2)
Removed round() statements in sale temp table, precision is defined by datatypes
Removed round() statement in receiving temp table, precision is defined by datatypes

git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@105 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-07-04 21:01:47 +00:00
jekkos
7688a1c0e5 Upgrade to CodeIgniter 2.2
git-svn-id: svn+ssh://svn.code.sf.net/p/opensourcepos/code/@100 c3eb156b-1dc0-44e1-88ae-e38439141b53
2014-06-27 22:12:48 +00:00
pappastech
2570f28242 Fix missing comma in database.sql.
Tom

git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@89 c3eb156b-1dc0-44e1-88ae-e38439141b53
2013-11-06 21:04:33 +00:00
pappastech
a7ac6e84b3 Adding the additional fields to database.sql to get the database up to date with this version of code.
git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@82 c3eb156b-1dc0-44e1-88ae-e38439141b53
2013-10-28 01:47:48 +00:00
objecttothis
53e385084e Not sure if this SQL dump accurately reflects the changes made to the dB or not.
git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@73 c3eb156b-1dc0-44e1-88ae-e38439141b53
2013-07-05 20:17:02 +00:00
pappastech
4c580d13ff Incorporated changes proposed to fix '6 items in cart limit'. This limit was due to the 4kB limit imposed on cookies. The change pushes cart item storage to the database instead of in cookies. A database change was also made in this version to work with the code change.
Version updated to 2.0_RC7.

Tom

git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@52 c3eb156b-1dc0-44e1-88ae-e38439141b53
2012-08-07 23:09:09 +00:00
pappastech
d1e6e1c571 Tax rate fix for bug ID 3313927. Changed tax rate fields in three tables in the database.sql file. You'll have to manually make the same changes or use the sql file to create a new set of tables and copy your data over.
Tom

git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@44 c3eb156b-1dc0-44e1-88ae-e38439141b53
2012-01-28 21:37:25 +00:00
pappastech
1d9cf76d8b Version 2.0_RC1. Upgrade to CI 2.1.0.
Tom

git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@26 c3eb156b-1dc0-44e1-88ae-e38439141b53
2012-01-16 02:16:21 +00:00
pappastech
335982638e Upgrading to CI 2.1.0
git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@23 c3eb156b-1dc0-44e1-88ae-e38439141b53
2012-01-16 02:11:50 +00:00
pappastech
a9af0eccf3 Updated code so that the version number only has to be changed in one place.
~Tom

git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@19 c3eb156b-1dc0-44e1-88ae-e38439141b53
2011-07-10 15:30:59 +00:00
pappastech
9697d7eeba Initial commit of release 1.0.
~ Tom

git-svn-id: svn+ssh://jekkos@svn.code.sf.net/p/opensourcepos/code/@7 c3eb156b-1dc0-44e1-88ae-e38439141b53
2011-06-08 13:22:09 +00:00