summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2007-12-08More customer/vendor search enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1966 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-08Removing sql/legacy-- will package new download from the files in branches/1.2einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1964 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-07Fixing some payment issues.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1961 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-07New templates added for contact search and invoice/ordereinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1957 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-06Misc fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1955 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-04More Roles fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1942 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-02Correcting behavior of session timeout to release locks and create new session.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1928 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-30Separated out multiple payment interface from new payment interface. Still ↵einhverfr
not working, but almost there git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1926 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Adjusting the schema to account for recurring(print|email) and status havingtetragon
multicolumn primary keys git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1922 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Removing duplicate drawer openeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1917 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29A narrow shim in the payment logic that needs more review and thought before ↵einhverfr
making permanent git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1915 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Correcting more Payment Problemseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1914 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-28A trivial fix to Company.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1913 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-28More Employee fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1912 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-27Fixing wrong index on location tableeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1911 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-27Employee screen QA round 1.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1910 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-27AR/AP Breakage Fixedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1909 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-25Employee creation/management is now on new system. May need some additional ↵einhverfr
tweaking git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1908 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-25Few more fixes for vendor stuff.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1904 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-25Contact management postfactoringeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1899 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-22First (unsuccessful) attempt to automatically handle number formatting in ↵einhverfr
the template engine.. Customer screen enhancements as well. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1890 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-22More customer fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1889 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-22More customer fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1888 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-21A few more permissions fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1886 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-21More Customer Fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1885 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-20A few more Customer improvementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1882 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-20Customer screen now renders reasonably well.einhverfr
TODO: Needs a lot of CSS work to beautify. Also CSS/Javascript could be used to create a tabbed interface for this screen. Also, a lot of issues with stored procedures have been fixed. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1880 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18More customer/vendor screen/stored proc fixes. Note that since locations ↵einhverfr
are mapped many<->many with companies and persons, I have moved the location class foreign key into the mapping tables. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1879 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18Location_save rewritten to be safe for the many-many mappingseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1878 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18Pass 1 of QA committed for Reconciliation.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1876 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18Employee.sql QA first run commitseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1875 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18Contact entity stored procs bugs fixedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1874 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18Payments changes committed, through QAeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1873 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-17removed all errors loading Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1872 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-17Commiting David Mora's payment codeeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1871 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-16fix the location table... I would like to know who thought check (foo ↵linuxpoet
'regex' NOT NULL) was going to work... git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1870 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-15Significant work on the Entity and Administrative code. It's buggy, so ↵aurynn_cmd
please test, etc. thoroughly. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1869 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-09Fixing db schema field names to match stored procedures (since those names ↵einhverfr
are clearer anyway) git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1861 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-09Province (or state) is now distinct from city in terms of db stroageeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1860 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-09A few areas of voucher handling updatedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1859 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-01Renaming the Session namespace to LedgerSMB::Autheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1835 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-31Converting the two left-over float4 fields to numerictetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1832 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-19GL Vouchers are posting and saving correctly. Need to get listing and ↵einhverfr
approving but that is conceptually a lot easier and involves a lot less legacy code git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1796 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-19Some voucher fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1795 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-18Correcting some issues with roles files. There are still a few syntax ↵einhverfr
errors. Still working on them. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1786 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-18Pg-database now loads again. employee view is disabled for now.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1785 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-18POS Fixes:einhverfr
1: Drawer opening now uses correct printer designation 2: Change issued is now entered with correct memo field. 3: Closing tell report works as advertised git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1782 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-17Serious updates to the Admin controller;aurynn_cmd
Creation of a User controller/object - I would like to use this to save/load roles, as well. Creation of Person stored procs, Entity stored procs. Serious updates to the employee stored procs. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1778 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-15Fixing db building issue.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1760 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-14Adjustments to the menu SQL to correct the menu structure and renderingtetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1753 4979c152-3d1c-0410-bac9-87ea11338e46