mirror/opensourcepos
1
0
Fork 0
mirror of https://github.com/opensourcepos/opensourcepos.git synced 2026-01-27 10:48:04 -05:00
Code Issues Packages Projects Releases Wiki Activity
5,247 Commits 37 Branches 39 Tags
master.3.4.0-dev
Commit Graph

105 Commits

Author SHA1 Message Date
objecttothis
352036209f Requested Changes 
- Removed unnecessary indices on deleted column where there would not be many rows.
- Removed unnecessary parenthesis in Item Model.
- Added Composite indices based on MySQL EXPLAIN results.
 2021-05-25 14:04:01 +02:00
objecttothis
9ff8611672 Requested Changes 
- Removed unnecessary indices on deleted column where there would not be many rows.
- Explicitly stated NULL in second parameter of WHERE to improve readability.
 2021-05-25 14:04:01 +02:00
objecttothis
2f4c95ecd2 Corrected a duplicated line in the query 2021-05-25 14:04:01 +02:00
objecttothis
97159d42c7 Database Optimizations 
- Add indexes to tables to improve query times.
- Delete orphaned attribute values.
- Resolve duplicate attribute values.
- Deleted whitespace after migration which was causing Severity: Warning --> Cannot modify header information - headers already sent by
 2021-05-25 14:04:01 +02:00
Jeroen Peelaerts
6705e5f259 Add item_number to item kits module 2021-02-10 10:27:17 +01:00
Steve Ireland
c5b22a0300 Improved support for cash rounding transactions. 2021-02-07 13:39:51 -05:00
Jeroen Peelaerts
6f2ac77a6e Remove unused migration (#3006) 2021-01-19 21:47:06 +01:00
Jeroen Peelaerts
83ab188c8d Remove duplicate migration (#3006) 2021-01-17 11:52:45 +01:00
Jeroen Peelaerts
e20bf34a74 Use longblob for session data storage (#3006) 2021-01-17 11:36:06 +01:00
Jeroen Peelaerts
5583a97772 Use mediumblob for session data storage (#3006) 2021-01-03 12:05:48 +01:00
objecttothis
b9727d72d7 Allow ON DELETE CASCADE for receiving_id foreign key in links table 2020-08-19 23:01:30 +02:00
objecttothis
68a2489e13 Add Save logic 
- Corrected minimum image size value in migration script
- Added save logic to save_general() in Config controller
- Added logic in the index() of the Config controller to properly prep
allowed_image_types data
 2020-05-08 15:58:37 +04:00
objecttothis
9b18072f1e migration corrections 2020-05-08 14:23:12 +04:00
objecttothis
59142d9f69 Database logic additions 
- Migration script to create default values
- Corrected naming of variables in general_config.php
- Replaced hardcoded values with db variables
 2020-05-08 14:22:49 +04:00
SteveIreland
57dc2d2b11 Add unique contraint to tax group 2020-02-16 21:08:58 -05:00
FrancescoUK
6b07d8ee21 Fix wrong tax amount with tax included 2020-02-04 21:25:37 +00:00
FrancescoUK
dea21f6d38 Revert "set customer date to be the first sale one if time 0" 
This reverts commit 3cb1bf6b87.
 2020-01-25 23:27:22 +00:00
FrancescoUK
3cb1bf6b87 set customer date to be the first sale one if time 0 2020-01-25 23:22:06 +00:00
FrancescoUK
99d861535e Add allow sales change price permission (#2653) 2020-01-25 17:22:26 +00:00
FrancescoUK
c871c68aeb Fix payment dates not being set correctly 2020-01-19 23:02:26 +00:00
FrancescoUK
6e523a30ab Database migration minor fixes 2020-01-19 22:45:17 +00:00
SteveIreland
61e28302ce Add a code to indicate a taxable item on a sales receipt 2019-10-11 00:10:13 -04:00
objecttothis
991830817e Create 20190712150200_fix_empty_reports.php 
This corrects an error in a previous migration (2.3_to_2.3.1.sql) that assigned a null value to receivings_stock and sales_stock for the location_id when it should have been the location_id of that particular stock_location.
 2019-07-12 15:05:14 +04:00
FrancescoUK
4aec3d04d6 Bump script date to follow the correct database migration order 2019-06-15 10:48:50 +01:00
FrancescoUK
01dfd023eb Merge pull request #2319 from opensourcepos/fix-attribute-datetime 
Fix attribute datetime formatting
 2019-06-15 10:32:22 +01:00
FrancescoUK
b4790334a6 Add ospos_expenses date index 2019-06-15 09:42:54 +01:00
Steve Ireland
442af20815 Add missing database constraints. 2019-06-14 21:28:16 -04:00
FrancescoUK
a61ddc19d2 Optimise DB query, tidy up 2019-06-09 10:53:48 +01:00
Steve Ireland
595ef0b617 Track initial cash refunds 2019-06-07 21:48:05 -04:00
jekkos
0ae6470b35 Migrate attribute datetime to date (#2441) 2019-06-05 00:47:17 +02:00
Steve Ireland
a89674ccfe Support updates to payments 2019-05-01 21:17:22 -04:00
Steve Ireland
ae1fb3cac1 Fix Sales Tax Migration 2019-04-07 14:54:21 -04:00
objecttothis
ce7b13a633 Merge pull request #2394 from opensourcepos/add_iso_currency_code 
Add iso currency code
 2019-03-13 13:54:46 +04:00
objecttothis
2cd9c23ac0 Update 20190317102600_add_iso_4217.php 2019-03-13 13:53:14 +04:00
objecttothis
2e755c6806 Rename 3.4.0_add_iso_4217.sql to 3.3.0_add_iso_4217.sql 
3.3.0 release
 2019-03-13 13:52:21 +04:00
FrancescoUK
3f1ca2480c Rename migration script 2019-03-09 09:15:15 +00:00
objecttothis
f284823707 Add ISO currency code 2019-03-08 11:48:38 +04:00
objecttothis
34d3352d73 Create 20190317102600_add_iso_4217.php 2019-03-08 11:09:21 +04:00
objecttothis
a55893930a Create 3.4.0_add_iso_4217.sql 2019-03-07 16:01:03 +04:00
objecttothis
74995a5ac1 Adding of decimal unit field 2019-03-06 15:42:04 +04:00
objecttothis
d79783f605 Create 3.4.0_decimal_attribute_type.sql 
Adding migration script for database add of DECIMAL attribute type
 2019-03-01 17:52:30 +04:00
objecttothis
5fe9e3f8d2 Create 20190301124900_decimal_attribute_type.php 
Adding migration php file
 2019-03-01 17:51:09 +04:00
Steve Ireland
2f710e80e7 Fixes a couple of problems with sales tax migration plus a couple of other problems. 2019-02-23 18:58:28 -05:00
jekkos
231f7485fe Temporarily fix supplier update (#2309) 2019-02-02 14:36:05 +01:00
jekkos
6f75ec3ae2 Skip india GST migration if it ran before + force cleanup (#2302) 2019-02-02 14:08:20 +01:00
objecttothis
749c41c43c Merge pull request #2333 from opensourcepos/attribute_migrations_values_fix 
Add IGNORE to insert and UNIQUE constraint to attribute_value
 2019-01-30 13:27:02 +04:00
objecttothis
ab2a46ff22 Add IGNORE to insert and UNIQUE constraint to attribute_value 2019-01-30 13:08:12 +04:00
Steve Ireland
57fa8c1a4b India GST script is dependent on the 3.3.0 script. 2019-01-29 21:30:52 -05:00
FrancescoUK
cbfb8e5a89 Merge pull request #2289 from opensourcepos/refactor-tax-config 
Refactor Tax Configuration
 2019-01-14 10:59:09 +00:00
jekkos
f911cebae2 Revert translation update + bump migration script version 2019-01-13 13:18:51 +01:00