summaryrefslogtreecommitdiff
path: root/sql/modules
AgeCommit message (Collapse)Author
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
2007-08-06Addition of Vendor and Customer-specific save, get, and search functions in ↵aurynn_cmd
Pgsql stored procedures. Cleanup and modification of Employee.sql, to fit the new Entity framework, as well as the modifications to support trigram searching. Addition of customer.pl and vendor.pl scripts, to support new perl framework code, as well as .pm modules for the same. Some cleanup of Pg-database.sql. addition of note_class = 1 check on entity_note, removal of check id = 1. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1454 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-24Adds the missing SELECT INTO statements for the correct_bank_charge and ↵aurynn_cmd
correct_unaccounted_charge functions git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1437 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-08Menu db schema added for revieweinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1354 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-22Added version of Aurynn's reconciliation logiceinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1302 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-12Committing Aurynn's changes to Reconciliation logiceinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1268 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-01Adding Reconciliation Moduleeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1249 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-30Adding first draft of voucher handling stored procedureseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1122 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-12Adding version numbers to modules that are ready to loadeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@885 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-11Moving functions back into sql/modules for now.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@883 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-10Moved defaults handling into separate objecteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@876 4979c152-3d1c-0410-bac9-87ea11338e46