summaryrefslogtreecommitdiff
path: root/sql/modules
AgeCommit message (Collapse)Author
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-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-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-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-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-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-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
2007-10-10Merging in David Mora's payment changes. Still working on the template and ↵einhverfr
workflow scripts. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1735 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-03Disabled login checking in LedgerSMB.pm, temporarily.aurynn_cmd
Whitespace cleanup in DB.pm Modifications to remove user_conf from User.pm git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1692 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-02Adding custom field/table catalogs to permissions scriptseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1691 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-01Adding role listing functioneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1683 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-26Applying David Mora's patch to Payment.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1669 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-17Adding project list stored procedureeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1622 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-16Adding constructor to LedgerSMB::Template::Elementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1614 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-15Form.pm now uses strit mode except in the constructoreinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1606 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Correcting SQL errors in Payment.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1601 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Removing obsolete user creation stored procs and insertseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1600 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Documenting Payment.sql functionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1597 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Adding multi-vendor searches now require the account number for the AR/AP ↵einhverfr
account git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1596 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Adding Payment search stored procedures.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1595 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Adding discount_terms and threshold to entity_credit_accounteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1594 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-12Added sequences, etc. Roles should be functional with these permissionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1580 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-12More additions to role systemeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1574 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-12Goods and Services permissions now addedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1573 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-12Correcting validation issues in frameseteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1572 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-11More permissions material added to the Roleseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1570 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-11Cleaning up lsmb-request slightlyeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1569 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-11Adding some permission grantseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1560 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-11Full tree in place. Now to add permission grantseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1559 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-10Creation of next-gen admin.pl, admin.pm, and admin.sql systems.aurynn_cmd
Admin.pm defines the new controller admin.pl is the direct view-backing software. POD is not completed, will be provided shortly. Full UI templates provided for the Reconciliation, Vendor, Customer, and Employee as well. UI/ is being delineated by subdirectories for Admin, Vendor, Customer and Employee, to date. Minor whitespace cleanup. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1557 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-08Adding some SQL queries for reports that are being moved out of the old ↵einhverfr
codebase because they are broken git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1539 4979c152-3d1c-0410-bac9-87ea11338e46