From f6c9088e16c4c083174dd1130ae58d213923cdef Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 15 Jul 2003 11:45:14 +0000 Subject: [PATCH 1/1] import of sql-ledger 2.0.8 --- sql-ledger/SL/AM.pm | 694 ++++++++ sql-ledger/SL/AP.pm | 381 +++++ sql-ledger/SL/AR.pm | 381 +++++ sql-ledger/SL/CA.pm | 262 +++ sql-ledger/SL/CP.pm | 308 ++++ sql-ledger/SL/CT.pm | 447 +++++ sql-ledger/SL/Form.pm | 1397 ++++++++++++++++ sql-ledger/SL/GL.pm | 462 ++++++ sql-ledger/SL/IC.pm | 936 +++++++++++ sql-ledger/SL/IR.pm | 995 +++++++++++ sql-ledger/SL/IS.pm | 1231 ++++++++++++++ sql-ledger/SL/Inifile.pm | 87 + sql-ledger/SL/Mailer.pm | 147 ++ sql-ledger/SL/Menu.pm | 117 ++ sql-ledger/SL/Num2text.pm | 162 ++ sql-ledger/SL/OE.pm | 674 ++++++++ sql-ledger/SL/PE.pm | 276 ++++ sql-ledger/SL/RC.pm | 186 +++ sql-ledger/SL/RP.pm | 1310 +++++++++++++++ sql-ledger/SL/User.pm | 692 ++++++++ sql-ledger/VERSION | 1 + sql-ledger/am.pl | 126 ++ sql-ledger/bin/lynx/menu.pl | 128 ++ sql-ledger/bin/mozilla/admin.pl | 1504 +++++++++++++++++ sql-ledger/bin/mozilla/am.pl | 1051 ++++++++++++ sql-ledger/bin/mozilla/ap.pl | 1103 +++++++++++++ sql-ledger/bin/mozilla/ar.pl | 1135 +++++++++++++ sql-ledger/bin/mozilla/arap.pl | 406 +++++ sql-ledger/bin/mozilla/ca.pl | 413 +++++ sql-ledger/bin/mozilla/cp.pl | 528 ++++++ sql-ledger/bin/mozilla/ct.pl | 631 +++++++ sql-ledger/bin/mozilla/gl.pl | 806 +++++++++ sql-ledger/bin/mozilla/ic.pl | 1638 ++++++++++++++++++ sql-ledger/bin/mozilla/io.pl | 1149 +++++++++++++ sql-ledger/bin/mozilla/ir.pl | 653 ++++++++ sql-ledger/bin/mozilla/is.pl | 739 +++++++++ sql-ledger/bin/mozilla/login.pl | 217 +++ sql-ledger/bin/mozilla/menu.pl | 160 ++ sql-ledger/bin/mozilla/oe.pl | 1111 +++++++++++++ sql-ledger/bin/mozilla/pe.pl | 549 +++++++ sql-ledger/bin/mozilla/rc.pl | 371 +++++ sql-ledger/bin/mozilla/rp.pl | 1730 ++++++++++++++++++++ sql-ledger/css/sql-ledger.css | 113 ++ sql-ledger/doc/COPYING | 355 ++++ sql-ledger/doc/README | 287 ++++ sql-ledger/doc/UPGRADE-1.6-1.8 | 61 + sql-ledger/doc/UPGRADE-1.8-1.8.3 | 23 + sql-ledger/doc/UPGRADE-1.8.3-1.8.4 | 10 + sql-ledger/doc/UPGRADE-1.8.4-1.8.5 | 18 + sql-ledger/doc/UPGRADE-1.8.5-1.8.7 | 6 + sql-ledger/doc/UPGRADE-1.8.7-2.0.0 | 20 + sql-ledger/doc/UPGRADE-2.0-2.0.8 | 8 + sql-ledger/doc/copyright | 23 + sql-ledger/doc/faq.html | 747 +++++++++ sql-ledger/favicon.ico | Bin 0 -> 3638 bytes sql-ledger/locale/br/COPYING | 24 + sql-ledger/locale/br/LANGUAGE | 1 + sql-ledger/locale/br/admin | 122 ++ sql-ledger/locale/br/all | 487 ++++++ sql-ledger/locale/br/am | 139 ++ sql-ledger/locale/br/ap | 133 ++ sql-ledger/locale/br/ar | 133 ++ sql-ledger/locale/br/arap | 30 + sql-ledger/locale/br/ca | 50 + sql-ledger/locale/br/cp | 75 + sql-ledger/locale/br/ct | 69 + sql-ledger/locale/br/gl | 124 ++ sql-ledger/locale/br/ic | 205 +++ sql-ledger/locale/br/io | 106 ++ sql-ledger/locale/br/ir | 178 ++ sql-ledger/locale/br/is | 185 +++ sql-ledger/locale/br/login | 28 + sql-ledger/locale/br/menu | 72 + sql-ledger/locale/br/oe | 199 +++ sql-ledger/locale/br/pe | 35 + sql-ledger/locale/br/rc | 37 + sql-ledger/locale/br/rp | 117 ++ sql-ledger/locale/cn/COPYING | 24 + sql-ledger/locale/cn/LANGUAGE | 1 + sql-ledger/locale/cn/admin | 124 ++ sql-ledger/locale/cn/all | 495 ++++++ sql-ledger/locale/cn/am | 139 ++ sql-ledger/locale/cn/ap | 133 ++ sql-ledger/locale/cn/ar | 133 ++ sql-ledger/locale/cn/arap | 30 + sql-ledger/locale/cn/ca | 50 + sql-ledger/locale/cn/cp | 77 + sql-ledger/locale/cn/ct | 71 + sql-ledger/locale/cn/gl | 124 ++ sql-ledger/locale/cn/ic | 206 +++ sql-ledger/locale/cn/io | 106 ++ sql-ledger/locale/cn/ir | 178 ++ sql-ledger/locale/cn/is | 185 +++ sql-ledger/locale/cn/login | 27 + sql-ledger/locale/cn/menu | 71 + sql-ledger/locale/cn/oe | 200 +++ sql-ledger/locale/cn/pe | 35 + sql-ledger/locale/cn/rc | 37 + sql-ledger/locale/cn/rp | 120 ++ sql-ledger/locale/ct/COPYING | 21 + sql-ledger/locale/ct/LANGUAGE | 1 + sql-ledger/locale/ct/admin | 122 ++ sql-ledger/locale/ct/all | 487 ++++++ sql-ledger/locale/ct/am | 139 ++ sql-ledger/locale/ct/ap | 133 ++ sql-ledger/locale/ct/ar | 133 ++ sql-ledger/locale/ct/arap | 30 + sql-ledger/locale/ct/ca | 50 + sql-ledger/locale/ct/cp | 75 + sql-ledger/locale/ct/ct | 69 + sql-ledger/locale/ct/gl | 124 ++ sql-ledger/locale/ct/ic | 205 +++ sql-ledger/locale/ct/io | 106 ++ sql-ledger/locale/ct/ir | 178 ++ sql-ledger/locale/ct/is | 185 +++ sql-ledger/locale/ct/login | 28 + sql-ledger/locale/ct/menu | 72 + sql-ledger/locale/ct/oe | 199 +++ sql-ledger/locale/ct/pe | 35 + sql-ledger/locale/ct/rc | 37 + sql-ledger/locale/ct/rp | 117 ++ sql-ledger/locale/cz/COPYING | 23 + sql-ledger/locale/cz/LANGUAGE | 1 + sql-ledger/locale/cz/admin | 122 ++ sql-ledger/locale/cz/all | 487 ++++++ sql-ledger/locale/cz/am | 139 ++ sql-ledger/locale/cz/ap | 133 ++ sql-ledger/locale/cz/ar | 133 ++ sql-ledger/locale/cz/arap | 30 + sql-ledger/locale/cz/ca | 50 + sql-ledger/locale/cz/cp | 75 + sql-ledger/locale/cz/ct | 69 + sql-ledger/locale/cz/gl | 124 ++ sql-ledger/locale/cz/ic | 205 +++ sql-ledger/locale/cz/io | 106 ++ sql-ledger/locale/cz/ir | 178 ++ sql-ledger/locale/cz/is | 185 +++ sql-ledger/locale/cz/login | 28 + sql-ledger/locale/cz/menu | 72 + sql-ledger/locale/cz/oe | 199 +++ sql-ledger/locale/cz/pe | 35 + sql-ledger/locale/cz/rc | 37 + sql-ledger/locale/cz/rp | 117 ++ sql-ledger/locale/de/COPYING | 22 + sql-ledger/locale/de/LANGUAGE | 1 + sql-ledger/locale/de/Num2text | 185 +++ sql-ledger/locale/de/admin | 124 ++ sql-ledger/locale/de/all | 499 ++++++ sql-ledger/locale/de/am | 139 ++ sql-ledger/locale/de/ap | 133 ++ sql-ledger/locale/de/ar | 134 ++ sql-ledger/locale/de/arap | 30 + sql-ledger/locale/de/ca | 50 + sql-ledger/locale/de/cp | 77 + sql-ledger/locale/de/ct | 71 + sql-ledger/locale/de/gl | 124 ++ sql-ledger/locale/de/ic | 205 +++ sql-ledger/locale/de/io | 108 ++ sql-ledger/locale/de/ir | 180 ++ sql-ledger/locale/de/is | 187 +++ sql-ledger/locale/de/locales.pl | 303 ++++ sql-ledger/locale/de/login | 27 + sql-ledger/locale/de/menu | 73 + sql-ledger/locale/de/oe | 202 +++ sql-ledger/locale/de/pe | 45 + sql-ledger/locale/de/rc | 37 + sql-ledger/locale/de/rp | 119 ++ sql-ledger/locale/dk/COPYING | 24 + sql-ledger/locale/dk/LANGUAGE | 1 + sql-ledger/locale/dk/admin | 122 ++ sql-ledger/locale/dk/all | 487 ++++++ sql-ledger/locale/dk/am | 139 ++ sql-ledger/locale/dk/ap | 133 ++ sql-ledger/locale/dk/ar | 133 ++ sql-ledger/locale/dk/arap | 30 + sql-ledger/locale/dk/ca | 50 + sql-ledger/locale/dk/cp | 75 + sql-ledger/locale/dk/ct | 69 + sql-ledger/locale/dk/gl | 124 ++ sql-ledger/locale/dk/ic | 205 +++ sql-ledger/locale/dk/io | 106 ++ sql-ledger/locale/dk/ir | 178 ++ sql-ledger/locale/dk/is | 185 +++ sql-ledger/locale/dk/login | 28 + sql-ledger/locale/dk/menu | 72 + sql-ledger/locale/dk/oe | 199 +++ sql-ledger/locale/dk/pe | 35 + sql-ledger/locale/dk/rc | 37 + sql-ledger/locale/dk/rp | 117 ++ sql-ledger/locale/ee/COPYING | 25 + sql-ledger/locale/ee/LANGUAGE | 1 + sql-ledger/locale/ee/admin | 124 ++ sql-ledger/locale/ee/all | 497 ++++++ sql-ledger/locale/ee/am | 139 ++ sql-ledger/locale/ee/ap | 133 ++ sql-ledger/locale/ee/ar | 134 ++ sql-ledger/locale/ee/arap | 30 + sql-ledger/locale/ee/ca | 50 + sql-ledger/locale/ee/cp | 77 + sql-ledger/locale/ee/ct | 71 + sql-ledger/locale/ee/gl | 124 ++ sql-ledger/locale/ee/ic | 208 +++ sql-ledger/locale/ee/io | 108 ++ sql-ledger/locale/ee/ir | 180 ++ sql-ledger/locale/ee/is | 187 +++ sql-ledger/locale/ee/login | 27 + sql-ledger/locale/ee/menu | 71 + sql-ledger/locale/ee/oe | 202 +++ sql-ledger/locale/ee/pe | 35 + sql-ledger/locale/ee/rc | 37 + sql-ledger/locale/ee/rp | 120 ++ sql-ledger/locale/en_GB/COPYING | 23 + sql-ledger/locale/en_GB/LANGUAGE | 1 + sql-ledger/locale/en_GB/admin | 124 ++ sql-ledger/locale/en_GB/all | 499 ++++++ sql-ledger/locale/en_GB/am | 139 ++ sql-ledger/locale/en_GB/ap | 133 ++ sql-ledger/locale/en_GB/ar | 134 ++ sql-ledger/locale/en_GB/arap | 30 + sql-ledger/locale/en_GB/bp | 54 + sql-ledger/locale/en_GB/ca | 50 + sql-ledger/locale/en_GB/cp | 77 + sql-ledger/locale/en_GB/ct | 71 + sql-ledger/locale/en_GB/gl | 124 ++ sql-ledger/locale/en_GB/ic | 205 +++ sql-ledger/locale/en_GB/io | 108 ++ sql-ledger/locale/en_GB/ir | 180 ++ sql-ledger/locale/en_GB/is | 187 +++ sql-ledger/locale/en_GB/login | 27 + sql-ledger/locale/en_GB/menu | 73 + sql-ledger/locale/en_GB/oe | 202 +++ sql-ledger/locale/en_GB/pe | 45 + sql-ledger/locale/en_GB/rc | 37 + sql-ledger/locale/en_GB/rp | 119 ++ sql-ledger/locale/es/COPYING | 26 + sql-ledger/locale/es/LANGUAGE | 1 + sql-ledger/locale/es/Num2text | 195 +++ sql-ledger/locale/es/admin | 124 ++ sql-ledger/locale/es/all | 490 ++++++ sql-ledger/locale/es/am | 139 ++ sql-ledger/locale/es/ap | 133 ++ sql-ledger/locale/es/ar | 133 ++ sql-ledger/locale/es/arap | 30 + sql-ledger/locale/es/ca | 50 + sql-ledger/locale/es/cp | 75 + sql-ledger/locale/es/ct | 69 + sql-ledger/locale/es/gl | 124 ++ sql-ledger/locale/es/ic | 205 +++ sql-ledger/locale/es/io | 106 ++ sql-ledger/locale/es/ir | 178 ++ sql-ledger/locale/es/is | 185 +++ sql-ledger/locale/es/login | 27 + sql-ledger/locale/es/menu | 71 + sql-ledger/locale/es/oe | 200 +++ sql-ledger/locale/es/pe | 35 + sql-ledger/locale/es/rc | 37 + sql-ledger/locale/es/rp | 117 ++ sql-ledger/locale/fi/COPYING | 23 + sql-ledger/locale/fi/LANGUAGE | 1 + sql-ledger/locale/fi/admin | 126 ++ sql-ledger/locale/fi/all | 494 ++++++ sql-ledger/locale/fi/am | 140 ++ sql-ledger/locale/fi/ap | 133 ++ sql-ledger/locale/fi/ar | 133 ++ sql-ledger/locale/fi/arap | 30 + sql-ledger/locale/fi/ca | 50 + sql-ledger/locale/fi/cp | 75 + sql-ledger/locale/fi/ct | 71 + sql-ledger/locale/fi/gl | 124 ++ sql-ledger/locale/fi/ic | 205 +++ sql-ledger/locale/fi/io | 106 ++ sql-ledger/locale/fi/ir | 178 ++ sql-ledger/locale/fi/is | 185 +++ sql-ledger/locale/fi/login | 27 + sql-ledger/locale/fi/menu | 71 + sql-ledger/locale/fi/oe | 199 +++ sql-ledger/locale/fi/pe | 35 + sql-ledger/locale/fi/rc | 37 + sql-ledger/locale/fi/rp | 117 ++ sql-ledger/locale/fr/COPYING | 27 + sql-ledger/locale/fr/LANGUAGE | 1 + sql-ledger/locale/fr/admin | 124 ++ sql-ledger/locale/fr/all | 495 ++++++ sql-ledger/locale/fr/am | 139 ++ sql-ledger/locale/fr/ap | 133 ++ sql-ledger/locale/fr/ar | 133 ++ sql-ledger/locale/fr/arap | 30 + sql-ledger/locale/fr/ca | 50 + sql-ledger/locale/fr/cp | 77 + sql-ledger/locale/fr/ct | 71 + sql-ledger/locale/fr/gl | 124 ++ sql-ledger/locale/fr/ic | 206 +++ sql-ledger/locale/fr/io | 106 ++ sql-ledger/locale/fr/ir | 178 ++ sql-ledger/locale/fr/is | 185 +++ sql-ledger/locale/fr/login | 27 + sql-ledger/locale/fr/menu | 71 + sql-ledger/locale/fr/oe | 200 +++ sql-ledger/locale/fr/pe | 35 + sql-ledger/locale/fr/rc | 37 + sql-ledger/locale/fr/rp | 120 ++ sql-ledger/locale/hu/COPYING | 23 + sql-ledger/locale/hu/LANGUAGE | 1 + sql-ledger/locale/hu/admin | 124 ++ sql-ledger/locale/hu/all | 499 ++++++ sql-ledger/locale/hu/am | 139 ++ sql-ledger/locale/hu/ap | 133 ++ sql-ledger/locale/hu/ar | 134 ++ sql-ledger/locale/hu/arap | 30 + sql-ledger/locale/hu/ca | 50 + sql-ledger/locale/hu/cp | 77 + sql-ledger/locale/hu/ct | 71 + sql-ledger/locale/hu/gl | 124 ++ sql-ledger/locale/hu/ic | 205 +++ sql-ledger/locale/hu/io | 108 ++ sql-ledger/locale/hu/ir | 180 ++ sql-ledger/locale/hu/is | 187 +++ sql-ledger/locale/hu/login | 27 + sql-ledger/locale/hu/menu | 73 + sql-ledger/locale/hu/oe | 202 +++ sql-ledger/locale/hu/pe | 45 + sql-ledger/locale/hu/rc | 37 + sql-ledger/locale/hu/rp | 119 ++ sql-ledger/locale/is/COPYING | 23 + sql-ledger/locale/is/LANGUAGE | 1 + sql-ledger/locale/is/admin | 124 ++ sql-ledger/locale/is/all | 496 ++++++ sql-ledger/locale/is/am | 139 ++ sql-ledger/locale/is/ap | 133 ++ sql-ledger/locale/is/ar | 134 ++ sql-ledger/locale/is/arap | 30 + sql-ledger/locale/is/ca | 50 + sql-ledger/locale/is/cp | 77 + sql-ledger/locale/is/ct | 71 + sql-ledger/locale/is/gl | 124 ++ sql-ledger/locale/is/ic | 206 +++ sql-ledger/locale/is/io | 106 ++ sql-ledger/locale/is/ir | 178 ++ sql-ledger/locale/is/is | 185 +++ sql-ledger/locale/is/login | 27 + sql-ledger/locale/is/menu | 71 + sql-ledger/locale/is/oe | 200 +++ sql-ledger/locale/is/pe | 35 + sql-ledger/locale/is/rc | 37 + sql-ledger/locale/is/rp | 120 ++ sql-ledger/locale/it/COPYING | 25 + sql-ledger/locale/it/LANGUAGE | 1 + sql-ledger/locale/it/Num2text | 163 ++ sql-ledger/locale/it/admin | 124 ++ sql-ledger/locale/it/all | 495 ++++++ sql-ledger/locale/it/am | 139 ++ sql-ledger/locale/it/ap | 133 ++ sql-ledger/locale/it/ar | 133 ++ sql-ledger/locale/it/arap | 30 + sql-ledger/locale/it/ca | 50 + sql-ledger/locale/it/cp | 77 + sql-ledger/locale/it/ct | 71 + sql-ledger/locale/it/gl | 124 ++ sql-ledger/locale/it/ic | 206 +++ sql-ledger/locale/it/io | 106 ++ sql-ledger/locale/it/ir | 178 ++ sql-ledger/locale/it/is | 185 +++ sql-ledger/locale/it/login | 27 + sql-ledger/locale/it/menu | 71 + sql-ledger/locale/it/oe | 200 +++ sql-ledger/locale/it/pe | 35 + sql-ledger/locale/it/qe | 199 +++ sql-ledger/locale/it/rc | 37 + sql-ledger/locale/it/rp | 120 ++ sql-ledger/locale/lt/COPYING | 23 + sql-ledger/locale/lt/LANGUAGE | 1 + sql-ledger/locale/lt/admin | 124 ++ sql-ledger/locale/lt/all | 497 ++++++ sql-ledger/locale/lt/am | 139 ++ sql-ledger/locale/lt/ap | 133 ++ sql-ledger/locale/lt/ar | 134 ++ sql-ledger/locale/lt/arap | 30 + sql-ledger/locale/lt/ca | 50 + sql-ledger/locale/lt/cp | 77 + sql-ledger/locale/lt/ct | 71 + sql-ledger/locale/lt/gl | 124 ++ sql-ledger/locale/lt/ic | 208 +++ sql-ledger/locale/lt/io | 108 ++ sql-ledger/locale/lt/ir | 180 ++ sql-ledger/locale/lt/is | 187 +++ sql-ledger/locale/lt/login | 27 + sql-ledger/locale/lt/menu | 71 + sql-ledger/locale/lt/oe | 202 +++ sql-ledger/locale/lt/pe | 35 + sql-ledger/locale/lt/rc | 37 + sql-ledger/locale/lt/rp | 120 ++ sql-ledger/locale/mx/COPYING | 23 + sql-ledger/locale/mx/LANGUAGE | 1 + sql-ledger/locale/mx/admin | 128 ++ sql-ledger/locale/mx/all | 496 ++++++ sql-ledger/locale/mx/am | 140 ++ sql-ledger/locale/mx/ap | 133 ++ sql-ledger/locale/mx/ar | 133 ++ sql-ledger/locale/mx/arap | 30 + sql-ledger/locale/mx/ca | 50 + sql-ledger/locale/mx/cp | 75 + sql-ledger/locale/mx/ct | 69 + sql-ledger/locale/mx/gl | 124 ++ sql-ledger/locale/mx/ic | 206 +++ sql-ledger/locale/mx/io | 106 ++ sql-ledger/locale/mx/ir | 178 ++ sql-ledger/locale/mx/is | 185 +++ sql-ledger/locale/mx/login | 28 + sql-ledger/locale/mx/menu | 72 + sql-ledger/locale/mx/oe | 200 +++ sql-ledger/locale/mx/pe | 35 + sql-ledger/locale/mx/rc | 37 + sql-ledger/locale/mx/rp | 117 ++ sql-ledger/locale/nl/COPYING | 26 + sql-ledger/locale/nl/LANGUAGE | 1 + sql-ledger/locale/nl/Num2text | 161 ++ sql-ledger/locale/nl/admin | 124 ++ sql-ledger/locale/nl/all | 491 ++++++ sql-ledger/locale/nl/am | 139 ++ sql-ledger/locale/nl/ap | 133 ++ sql-ledger/locale/nl/ar | 133 ++ sql-ledger/locale/nl/arap | 30 + sql-ledger/locale/nl/ca | 50 + sql-ledger/locale/nl/cp | 75 + sql-ledger/locale/nl/ct | 71 + sql-ledger/locale/nl/gl | 124 ++ sql-ledger/locale/nl/ic | 206 +++ sql-ledger/locale/nl/io | 106 ++ sql-ledger/locale/nl/ir | 178 ++ sql-ledger/locale/nl/is | 185 +++ sql-ledger/locale/nl/login | 27 + sql-ledger/locale/nl/menu | 71 + sql-ledger/locale/nl/oe | 200 +++ sql-ledger/locale/nl/pe | 35 + sql-ledger/locale/nl/rc | 37 + sql-ledger/locale/nl/rp | 116 ++ sql-ledger/locale/no/COPYING | 24 + sql-ledger/locale/no/LANGUAGE | 1 + sql-ledger/locale/no/admin | 124 ++ sql-ledger/locale/no/all | 496 ++++++ sql-ledger/locale/no/am | 139 ++ sql-ledger/locale/no/ap | 133 ++ sql-ledger/locale/no/ar | 134 ++ sql-ledger/locale/no/arap | 30 + sql-ledger/locale/no/ca | 50 + sql-ledger/locale/no/cp | 77 + sql-ledger/locale/no/ct | 71 + sql-ledger/locale/no/gl | 124 ++ sql-ledger/locale/no/ic | 206 +++ sql-ledger/locale/no/io | 106 ++ sql-ledger/locale/no/ir | 178 ++ sql-ledger/locale/no/is | 185 +++ sql-ledger/locale/no/login | 27 + sql-ledger/locale/no/menu | 71 + sql-ledger/locale/no/oe | 200 +++ sql-ledger/locale/no/pe | 35 + sql-ledger/locale/no/rc | 37 + sql-ledger/locale/no/rp | 120 ++ sql-ledger/locale/pa/COPYING | 23 + sql-ledger/locale/pa/LANGUAGE | 1 + sql-ledger/locale/pa/admin | 128 ++ sql-ledger/locale/pa/all | 496 ++++++ sql-ledger/locale/pa/am | 140 ++ sql-ledger/locale/pa/ap | 133 ++ sql-ledger/locale/pa/ar | 133 ++ sql-ledger/locale/pa/arap | 30 + sql-ledger/locale/pa/ca | 50 + sql-ledger/locale/pa/cp | 75 + sql-ledger/locale/pa/ct | 69 + sql-ledger/locale/pa/gl | 124 ++ sql-ledger/locale/pa/ic | 206 +++ sql-ledger/locale/pa/io | 106 ++ sql-ledger/locale/pa/ir | 178 ++ sql-ledger/locale/pa/is | 185 +++ sql-ledger/locale/pa/login | 28 + sql-ledger/locale/pa/menu | 72 + sql-ledger/locale/pa/oe | 200 +++ sql-ledger/locale/pa/pe | 35 + sql-ledger/locale/pa/rc | 37 + sql-ledger/locale/pa/rp | 117 ++ sql-ledger/locale/pl/COPYING | 23 + sql-ledger/locale/pl/LANGUAGE | 1 + sql-ledger/locale/pl/admin | 122 ++ sql-ledger/locale/pl/all | 487 ++++++ sql-ledger/locale/pl/am | 139 ++ sql-ledger/locale/pl/ap | 133 ++ sql-ledger/locale/pl/ar | 133 ++ sql-ledger/locale/pl/arap | 30 + sql-ledger/locale/pl/ca | 50 + sql-ledger/locale/pl/cp | 75 + sql-ledger/locale/pl/ct | 69 + sql-ledger/locale/pl/gl | 124 ++ sql-ledger/locale/pl/ic | 205 +++ sql-ledger/locale/pl/io | 106 ++ sql-ledger/locale/pl/ir | 178 ++ sql-ledger/locale/pl/is | 185 +++ sql-ledger/locale/pl/login | 28 + sql-ledger/locale/pl/menu | 72 + sql-ledger/locale/pl/oe | 199 +++ sql-ledger/locale/pl/pe | 35 + sql-ledger/locale/pl/rc | 37 + sql-ledger/locale/pl/rp | 117 ++ sql-ledger/locale/pt/COPYING | 23 + sql-ledger/locale/pt/LANGUAGE | 1 + sql-ledger/locale/pt/admin | 122 ++ sql-ledger/locale/pt/all | 487 ++++++ sql-ledger/locale/pt/am | 139 ++ sql-ledger/locale/pt/ap | 133 ++ sql-ledger/locale/pt/ar | 133 ++ sql-ledger/locale/pt/arap | 30 + sql-ledger/locale/pt/ca | 50 + sql-ledger/locale/pt/cp | 75 + sql-ledger/locale/pt/ct | 69 + sql-ledger/locale/pt/gl | 124 ++ sql-ledger/locale/pt/ic | 205 +++ sql-ledger/locale/pt/io | 106 ++ sql-ledger/locale/pt/ir | 178 ++ sql-ledger/locale/pt/is | 185 +++ sql-ledger/locale/pt/login | 28 + sql-ledger/locale/pt/menu | 72 + sql-ledger/locale/pt/oe | 199 +++ sql-ledger/locale/pt/pe | 35 + sql-ledger/locale/pt/rc | 37 + sql-ledger/locale/pt/rp | 117 ++ sql-ledger/locale/ru/COPYING | 23 + sql-ledger/locale/ru/LANGUAGE | 1 + sql-ledger/locale/ru/admin | 122 ++ sql-ledger/locale/ru/all | 487 ++++++ sql-ledger/locale/ru/am | 139 ++ sql-ledger/locale/ru/ap | 133 ++ sql-ledger/locale/ru/ar | 133 ++ sql-ledger/locale/ru/arap | 30 + sql-ledger/locale/ru/ca | 50 + sql-ledger/locale/ru/cp | 75 + sql-ledger/locale/ru/ct | 69 + sql-ledger/locale/ru/gl | 124 ++ sql-ledger/locale/ru/ic | 205 +++ sql-ledger/locale/ru/io | 106 ++ sql-ledger/locale/ru/ir | 178 ++ sql-ledger/locale/ru/is | 185 +++ sql-ledger/locale/ru/login | 28 + sql-ledger/locale/ru/menu | 72 + sql-ledger/locale/ru/oe | 199 +++ sql-ledger/locale/ru/pe | 35 + sql-ledger/locale/ru/rc | 37 + sql-ledger/locale/ru/rp | 117 ++ sql-ledger/locale/se/COPYING | 23 + sql-ledger/locale/se/LANGUAGE | 1 + sql-ledger/locale/se/admin | 124 ++ sql-ledger/locale/se/all | 491 ++++++ sql-ledger/locale/se/am | 139 ++ sql-ledger/locale/se/ap | 133 ++ sql-ledger/locale/se/ar | 133 ++ sql-ledger/locale/se/arap | 30 + sql-ledger/locale/se/ca | 50 + sql-ledger/locale/se/cp | 75 + sql-ledger/locale/se/ct | 71 + sql-ledger/locale/se/gl | 124 ++ sql-ledger/locale/se/ic | 205 +++ sql-ledger/locale/se/io | 106 ++ sql-ledger/locale/se/ir | 178 ++ sql-ledger/locale/se/is | 185 +++ sql-ledger/locale/se/login | 27 + sql-ledger/locale/se/menu | 71 + sql-ledger/locale/se/oe | 199 +++ sql-ledger/locale/se/pe | 35 + sql-ledger/locale/se/rc | 37 + sql-ledger/locale/se/rp | 117 ++ sql-ledger/locale/tr/COPYING | 23 + sql-ledger/locale/tr/LANGUAGE | 1 + sql-ledger/locale/tr/admin | 122 ++ sql-ledger/locale/tr/all | 487 ++++++ sql-ledger/locale/tr/am | 139 ++ sql-ledger/locale/tr/ap | 133 ++ sql-ledger/locale/tr/ar | 133 ++ sql-ledger/locale/tr/arap | 30 + sql-ledger/locale/tr/ca | 50 + sql-ledger/locale/tr/cp | 75 + sql-ledger/locale/tr/ct | 69 + sql-ledger/locale/tr/gl | 124 ++ sql-ledger/locale/tr/ic | 205 +++ sql-ledger/locale/tr/io | 106 ++ sql-ledger/locale/tr/ir | 178 ++ sql-ledger/locale/tr/is | 185 +++ sql-ledger/locale/tr/login | 28 + sql-ledger/locale/tr/menu | 72 + sql-ledger/locale/tr/oe | 199 +++ sql-ledger/locale/tr/pe | 35 + sql-ledger/locale/tr/rc | 37 + sql-ledger/locale/tr/rp | 117 ++ sql-ledger/locale/tw/COPYING | 25 + sql-ledger/locale/tw/LANGUAGE | 1 + sql-ledger/locale/tw/admin | 122 ++ sql-ledger/locale/tw/all | 487 ++++++ sql-ledger/locale/tw/am | 139 ++ sql-ledger/locale/tw/ap | 133 ++ sql-ledger/locale/tw/ar | 133 ++ sql-ledger/locale/tw/arap | 30 + sql-ledger/locale/tw/ca | 50 + sql-ledger/locale/tw/cp | 75 + sql-ledger/locale/tw/ct | 69 + sql-ledger/locale/tw/gl | 124 ++ sql-ledger/locale/tw/ic | 205 +++ sql-ledger/locale/tw/io | 106 ++ sql-ledger/locale/tw/ir | 178 ++ sql-ledger/locale/tw/is | 185 +++ sql-ledger/locale/tw/login | 28 + sql-ledger/locale/tw/menu | 72 + sql-ledger/locale/tw/oe | 199 +++ sql-ledger/locale/tw/pe | 35 + sql-ledger/locale/tw/rc | 37 + sql-ledger/locale/tw/rp | 117 ++ sql-ledger/locale/ua/COPYING | 23 + sql-ledger/locale/ua/LANGUAGE | 1 + sql-ledger/locale/ua/admin | 124 ++ sql-ledger/locale/ua/all | 495 ++++++ sql-ledger/locale/ua/am | 139 ++ sql-ledger/locale/ua/ap | 133 ++ sql-ledger/locale/ua/ar | 133 ++ sql-ledger/locale/ua/arap | 30 + sql-ledger/locale/ua/ca | 50 + sql-ledger/locale/ua/cp | 77 + sql-ledger/locale/ua/ct | 71 + sql-ledger/locale/ua/gl | 124 ++ sql-ledger/locale/ua/ic | 206 +++ sql-ledger/locale/ua/io | 106 ++ sql-ledger/locale/ua/ir | 178 ++ sql-ledger/locale/ua/is | 185 +++ sql-ledger/locale/ua/login | 27 + sql-ledger/locale/ua/menu | 71 + sql-ledger/locale/ua/oe | 200 +++ sql-ledger/locale/ua/pe | 35 + sql-ledger/locale/ua/rc | 37 + sql-ledger/locale/ua/rp | 120 ++ sql-ledger/locale/ve/COPYING | 23 + sql-ledger/locale/ve/LANGUAGE | 1 + sql-ledger/locale/ve/admin | 124 ++ sql-ledger/locale/ve/all | 491 ++++++ sql-ledger/locale/ve/am | 139 ++ sql-ledger/locale/ve/ap | 133 ++ sql-ledger/locale/ve/ar | 133 ++ sql-ledger/locale/ve/arap | 30 + sql-ledger/locale/ve/ca | 50 + sql-ledger/locale/ve/cp | 75 + sql-ledger/locale/ve/ct | 71 + sql-ledger/locale/ve/gl | 124 ++ sql-ledger/locale/ve/ic | 206 +++ sql-ledger/locale/ve/io | 106 ++ sql-ledger/locale/ve/ir | 178 ++ sql-ledger/locale/ve/is | 185 +++ sql-ledger/locale/ve/login | 27 + sql-ledger/locale/ve/menu | 71 + sql-ledger/locale/ve/oe | 200 +++ sql-ledger/locale/ve/pe | 35 + sql-ledger/locale/ve/rc | 37 + sql-ledger/locale/ve/rp | 116 ++ sql-ledger/login.pl | 132 ++ sql-ledger/menu.ini | 394 +++++ sql-ledger/setup.pl | 594 +++++++ sql-ledger/sql-ledger.conf.default | 33 + sql-ledger/sql-ledger.png | Bin 0 -> 6963 bytes sql-ledger/sql/Austria-chart.sql | 143 ++ sql-ledger/sql/Austria-gifi.sql | 334 ++++ sql-ledger/sql/Brazil_General-chart.sql | 70 + sql-ledger/sql/Canada-gifi.sql | 754 +++++++++ sql-ledger/sql/Canada_General-chart.sql | 77 + sql-ledger/sql/Czech_Republic-chart.sql | 317 ++++ sql-ledger/sql/Danish_Default-chart.sql | 75 + sql-ledger/sql/Default-chart.sql | 81 + sql-ledger/sql/Dutch_Default-chart.sql | 80 + sql-ledger/sql/Dutch_Standard-chart.sql | 233 +++ sql-ledger/sql/France-chart.sql | 951 +++++++++++ sql-ledger/sql/German-Sample-chart.sql | 216 +++ sql-ledger/sql/German-Sample-gifi.sql | 19 + sql-ledger/sql/Germany-DATEV-SKR03-chart.sql | 262 +++ sql-ledger/sql/Germany-DATEV-SKR03-gifi.sql | 550 +++++++ sql-ledger/sql/Germany-SKR03-chart.sql | 267 +++ sql-ledger/sql/Germany-SKR03-gifi.sql | 1083 ++++++++++++ sql-ledger/sql/Italy-chart.sql | 179 ++ sql-ledger/sql/Oracle-indices.sql | 57 + sql-ledger/sql/Oracle-tables.sql | 388 +++++ sql-ledger/sql/Oracle-upgrade-1.8.0-1.8.4.sql | 28 + sql-ledger/sql/Oracle-upgrade-1.8.4-1.8.5.sql | 77 + sql-ledger/sql/Oracle-upgrade-1.8.5-2.0.0.sql | 100 ++ sql-ledger/sql/Oracle-upgrade-2.0.0-2.0.8.sql | 19 + sql-ledger/sql/Pg-indices.sql | 57 + sql-ledger/sql/Pg-tables.sql | 289 ++++ sql-ledger/sql/Pg-upgrade-1.2.6-1.2.7.sql | 4 + sql-ledger/sql/Pg-upgrade-1.2.7-1.4.0.sql | 173 ++ sql-ledger/sql/Pg-upgrade-1.4.0-1.6.0.sql | 126 ++ sql-ledger/sql/Pg-upgrade-1.6.0-1.8.0.sql | 104 ++ sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql | 21 + sql-ledger/sql/Pg-upgrade-1.8.4-1.8.5.sql | 63 + sql-ledger/sql/Pg-upgrade-1.8.5-2.0.0.sql | 92 ++ sql-ledger/sql/Pg-upgrade-2.0.0-2.0.8.sql | 12 + sql-ledger/sql/Poland-chart.sql | 337 ++++ .../sql/Simplified_Chinese_Default-chart.sql | 78 + sql-ledger/sql/Spain-chart.sql | 132 ++ sql-ledger/sql/Swiss-German-chart.sql | 160 ++ sql-ledger/sql/Swiss-German-gifi.sql | 55 + .../sql/Traditional_Chinese_Default-chart.sql | 78 + sql-ledger/sql/US_General-chart.sql | 98 ++ .../Brazilian_Portuguese-balance_sheet.html | 103 ++ .../templates/Brazilian_Portuguese-check.tex | 71 + .../Brazilian_Portuguese-income_statement.html | 77 + .../templates/Brazilian_Portuguese-invoice.html | 315 ++++ .../templates/Brazilian_Portuguese-invoice.tex | 223 +++ .../Brazilian_Portuguese-packing_list.html | 143 ++ .../Brazilian_Portuguese-packing_list.tex | 116 ++ .../Brazilian_Portuguese-purchase_order.html | 187 +++ .../Brazilian_Portuguese-purchase_order.tex | 198 +++ .../templates/Brazilian_Portuguese-receipt.tex | 71 + .../Brazilian_Portuguese-sales_order.html | 221 +++ .../templates/Brazilian_Portuguese-sales_order.tex | 137 ++ .../templates/Brazilian_Portuguese-statement.html | 125 ++ .../templates/Brazilian_Portuguese-statement.tex | 137 ++ sql-ledger/templates/Danish-balance_sheet.html | 96 ++ sql-ledger/templates/Danish-check.tex | 71 + sql-ledger/templates/Danish-income_statement.html | 73 + sql-ledger/templates/Danish-invoice.html | 273 +++ sql-ledger/templates/Danish-invoice.tex | 152 ++ sql-ledger/templates/Danish-packing_list.html | 145 ++ sql-ledger/templates/Danish-packing_list.tex | 123 ++ sql-ledger/templates/Danish-purchase_order.html | 191 +++ sql-ledger/templates/Danish-purchase_order.tex | 143 ++ sql-ledger/templates/Danish-receipt.tex | 71 + sql-ledger/templates/Danish-sales_order.html | 210 +++ sql-ledger/templates/Danish-sales_order.tex | 144 ++ sql-ledger/templates/Danish-statement.html | 121 ++ sql-ledger/templates/Danish-statement.tex | 137 ++ sql-ledger/templates/Default-balance_sheet.html | 100 ++ sql-ledger/templates/Default-check.tex | 77 + sql-ledger/templates/Default-income_statement.html | 82 + sql-ledger/templates/Default-invoice.html | 309 ++++ sql-ledger/templates/Default-invoice.tex | 231 +++ sql-ledger/templates/Default-packing_list.html | 148 ++ sql-ledger/templates/Default-packing_list.tex | 122 ++ sql-ledger/templates/Default-purchase_order.html | 224 +++ sql-ledger/templates/Default-purchase_order.tex | 198 +++ sql-ledger/templates/Default-receipt.tex | 74 + sql-ledger/templates/Default-sales_order.html | 212 +++ sql-ledger/templates/Default-sales_order.tex | 143 ++ sql-ledger/templates/Default-statement.html | 121 ++ sql-ledger/templates/Default-statement.tex | 137 ++ sql-ledger/templates/Dutch-balance_sheet.html | 104 ++ sql-ledger/templates/Dutch-check.tex | 71 + sql-ledger/templates/Dutch-income_statement.html | 83 + sql-ledger/templates/Dutch-invoice.html | 239 +++ sql-ledger/templates/Dutch-invoice.tex | 138 ++ sql-ledger/templates/Dutch-packing_list.html | 121 ++ sql-ledger/templates/Dutch-packing_list.tex | 114 ++ sql-ledger/templates/Dutch-purchase_order.html | 186 +++ sql-ledger/templates/Dutch-purchase_order.tex | 137 ++ sql-ledger/templates/Dutch-receipt.tex | 71 + sql-ledger/templates/Dutch-sales_order.html | 208 +++ sql-ledger/templates/Dutch-sales_order.tex | 134 ++ sql-ledger/templates/Dutch-statement.html | 121 ++ sql-ledger/templates/Dutch-statement.tex | 137 ++ sql-ledger/templates/Estonian-balance_sheet.html | 103 ++ sql-ledger/templates/Estonian-check.tex | 71 + .../templates/Estonian-income_statement.html | 84 + sql-ledger/templates/Estonian-invoice.html | 215 +++ sql-ledger/templates/Estonian-invoice.tex | 147 ++ sql-ledger/templates/Estonian-packing_list.html | 147 ++ sql-ledger/templates/Estonian-packing_list.tex | 119 ++ sql-ledger/templates/Estonian-purchase_order.html | 195 +++ sql-ledger/templates/Estonian-purchase_order.tex | 143 ++ sql-ledger/templates/Estonian-receipt.tex | 71 + sql-ledger/templates/Estonian-sales_order.html | 214 +++ sql-ledger/templates/Estonian-sales_order.tex | 141 ++ sql-ledger/templates/Estonian-statement.html | 121 ++ sql-ledger/templates/Estonian-statement.tex | 137 ++ sql-ledger/templates/French-balance_sheet.html | 109 ++ sql-ledger/templates/French-check.tex | 71 + sql-ledger/templates/French-income_statement.html | 86 + sql-ledger/templates/French-invoice.html | 309 ++++ sql-ledger/templates/French-invoice.tex | 151 ++ sql-ledger/templates/French-packing_list.html | 152 ++ sql-ledger/templates/French-packing_list.tex | 125 ++ sql-ledger/templates/French-purchase_order.html | 207 +++ sql-ledger/templates/French-purchase_order.tex | 143 ++ sql-ledger/templates/French-receipt.tex | 71 + sql-ledger/templates/French-sales_order.html | 229 +++ sql-ledger/templates/French-sales_order.tex | 144 ++ sql-ledger/templates/French-statement.html | 133 ++ sql-ledger/templates/French-statement.tex | 137 ++ sql-ledger/templates/German-balance_sheet.html | 100 ++ sql-ledger/templates/German-check.tex | 71 + sql-ledger/templates/German-income_statement.html | 78 + sql-ledger/templates/German-invoice.html | 265 +++ sql-ledger/templates/German-invoice.tex | 155 ++ sql-ledger/templates/German-packing_list.html | 146 ++ sql-ledger/templates/German-packing_list.tex | 118 ++ sql-ledger/templates/German-purchase_order.html | 188 +++ sql-ledger/templates/German-purchase_order.tex | 143 ++ sql-ledger/templates/German-receipt.tex | 71 + sql-ledger/templates/German-sales_order.html | 213 +++ sql-ledger/templates/German-sales_order.tex | 142 ++ sql-ledger/templates/German-statement.html | 121 ++ sql-ledger/templates/German-statement.tex | 137 ++ sql-ledger/templates/Service-balance_sheet.html | 100 ++ sql-ledger/templates/Service-check.tex | 71 + sql-ledger/templates/Service-income_statement.html | 82 + sql-ledger/templates/Service-invoice.html | 226 +++ sql-ledger/templates/Service-invoice.tex | 151 ++ sql-ledger/templates/Service-packing_list.html | 148 ++ sql-ledger/templates/Service-packing_list.tex | 120 ++ sql-ledger/templates/Service-purchase_order.html | 194 +++ sql-ledger/templates/Service-purchase_order.tex | 143 ++ sql-ledger/templates/Service-receipt.tex | 71 + sql-ledger/templates/Service-sales_order.html | 198 +++ sql-ledger/templates/Service-sales_order.tex | 139 ++ sql-ledger/templates/Service-statement.html | 121 ++ sql-ledger/templates/Service-statement.tex | 137 ++ sql-ledger/templates/Spanish_A4-balance_sheet.html | 100 ++ sql-ledger/templates/Spanish_A4-check.tex | 71 + .../templates/Spanish_A4-income_statement.html | 77 + sql-ledger/templates/Spanish_A4-invoice.html | 153 ++ sql-ledger/templates/Spanish_A4-invoice.tex | 108 ++ sql-ledger/templates/Spanish_A4-packing_list.html | 155 ++ sql-ledger/templates/Spanish_A4-packing_list.tex | 108 ++ .../templates/Spanish_A4-purchase_order.html | 153 ++ sql-ledger/templates/Spanish_A4-purchase_order.tex | 107 ++ sql-ledger/templates/Spanish_A4-receipt.tex | 71 + sql-ledger/templates/Spanish_A4-sales_order.html | 153 ++ sql-ledger/templates/Spanish_A4-sales_order.tex | 107 ++ sql-ledger/templates/Spanish_A4-statement.html | 121 ++ sql-ledger/templates/Spanish_A4-statement.tex | 137 ++ .../templates/Spanish_Letter-balance_sheet.html | 100 ++ sql-ledger/templates/Spanish_Letter-check.tex | 71 + .../templates/Spanish_Letter-income_statement.html | 77 + sql-ledger/templates/Spanish_Letter-invoice.html | 153 ++ sql-ledger/templates/Spanish_Letter-invoice.tex | 110 ++ .../templates/Spanish_Letter-packing_list.html | 155 ++ .../templates/Spanish_Letter-packing_list.tex | 108 ++ .../templates/Spanish_Letter-purchase_order.html | 153 ++ .../templates/Spanish_Letter-purchase_order.tex | 107 ++ sql-ledger/templates/Spanish_Letter-receipt.tex | 71 + .../templates/Spanish_Letter-sales_order.html | 153 ++ .../templates/Spanish_Letter-sales_order.tex | 107 ++ sql-ledger/templates/Spanish_Letter-statement.html | 121 ++ sql-ledger/templates/Spanish_Letter-statement.tex | 137 ++ sql-ledger/users/members.default | 5 + 843 files changed, 127977 insertions(+) create mode 100644 sql-ledger/SL/AM.pm create mode 100644 sql-ledger/SL/AP.pm create mode 100644 sql-ledger/SL/AR.pm create mode 100644 sql-ledger/SL/CA.pm create mode 100644 sql-ledger/SL/CP.pm create mode 100644 sql-ledger/SL/CT.pm create mode 100644 sql-ledger/SL/Form.pm create mode 100644 sql-ledger/SL/GL.pm create mode 100644 sql-ledger/SL/IC.pm create mode 100644 sql-ledger/SL/IR.pm create mode 100644 sql-ledger/SL/IS.pm create mode 100644 sql-ledger/SL/Inifile.pm create mode 100644 sql-ledger/SL/Mailer.pm create mode 100644 sql-ledger/SL/Menu.pm create mode 100644 sql-ledger/SL/Num2text.pm create mode 100644 sql-ledger/SL/OE.pm create mode 100644 sql-ledger/SL/PE.pm create mode 100644 sql-ledger/SL/RC.pm create mode 100644 sql-ledger/SL/RP.pm create mode 100644 sql-ledger/SL/User.pm create mode 100644 sql-ledger/VERSION create mode 100755 sql-ledger/am.pl create mode 100644 sql-ledger/bin/lynx/menu.pl create mode 100644 sql-ledger/bin/mozilla/admin.pl create mode 100644 sql-ledger/bin/mozilla/am.pl create mode 100644 sql-ledger/bin/mozilla/ap.pl create mode 100644 sql-ledger/bin/mozilla/ar.pl create mode 100644 sql-ledger/bin/mozilla/arap.pl create mode 100644 sql-ledger/bin/mozilla/ca.pl create mode 100644 sql-ledger/bin/mozilla/cp.pl create mode 100644 sql-ledger/bin/mozilla/ct.pl create mode 100644 sql-ledger/bin/mozilla/gl.pl create mode 100644 sql-ledger/bin/mozilla/ic.pl create mode 100644 sql-ledger/bin/mozilla/io.pl create mode 100644 sql-ledger/bin/mozilla/ir.pl create mode 100644 sql-ledger/bin/mozilla/is.pl create mode 100644 sql-ledger/bin/mozilla/login.pl create mode 100644 sql-ledger/bin/mozilla/menu.pl create mode 100644 sql-ledger/bin/mozilla/oe.pl create mode 100644 sql-ledger/bin/mozilla/pe.pl create mode 100644 sql-ledger/bin/mozilla/rc.pl create mode 100644 sql-ledger/bin/mozilla/rp.pl create mode 100644 sql-ledger/css/sql-ledger.css create mode 100644 sql-ledger/doc/COPYING create mode 100644 sql-ledger/doc/README create mode 100644 sql-ledger/doc/UPGRADE-1.6-1.8 create mode 100644 sql-ledger/doc/UPGRADE-1.8-1.8.3 create mode 100644 sql-ledger/doc/UPGRADE-1.8.3-1.8.4 create mode 100644 sql-ledger/doc/UPGRADE-1.8.4-1.8.5 create mode 100644 sql-ledger/doc/UPGRADE-1.8.5-1.8.7 create mode 100644 sql-ledger/doc/UPGRADE-1.8.7-2.0.0 create mode 100644 sql-ledger/doc/UPGRADE-2.0-2.0.8 create mode 100644 sql-ledger/doc/copyright create mode 100644 sql-ledger/doc/faq.html create mode 100644 sql-ledger/favicon.ico create mode 100644 sql-ledger/locale/br/COPYING create mode 100644 sql-ledger/locale/br/LANGUAGE create mode 100644 sql-ledger/locale/br/admin create mode 100644 sql-ledger/locale/br/all create mode 100644 sql-ledger/locale/br/am create mode 100644 sql-ledger/locale/br/ap create mode 100644 sql-ledger/locale/br/ar create mode 100644 sql-ledger/locale/br/arap create mode 100644 sql-ledger/locale/br/ca create mode 100644 sql-ledger/locale/br/cp create mode 100644 sql-ledger/locale/br/ct create mode 100644 sql-ledger/locale/br/gl create mode 100644 sql-ledger/locale/br/ic create mode 100644 sql-ledger/locale/br/io create mode 100644 sql-ledger/locale/br/ir create mode 100644 sql-ledger/locale/br/is create mode 100644 sql-ledger/locale/br/login create mode 100644 sql-ledger/locale/br/menu create mode 100644 sql-ledger/locale/br/oe create mode 100644 sql-ledger/locale/br/pe create mode 100644 sql-ledger/locale/br/rc create mode 100644 sql-ledger/locale/br/rp create mode 100644 sql-ledger/locale/cn/COPYING create mode 100644 sql-ledger/locale/cn/LANGUAGE create mode 100644 sql-ledger/locale/cn/admin create mode 100644 sql-ledger/locale/cn/all create mode 100644 sql-ledger/locale/cn/am create mode 100644 sql-ledger/locale/cn/ap create mode 100644 sql-ledger/locale/cn/ar create mode 100644 sql-ledger/locale/cn/arap create mode 100644 sql-ledger/locale/cn/ca create mode 100644 sql-ledger/locale/cn/cp create mode 100644 sql-ledger/locale/cn/ct create mode 100644 sql-ledger/locale/cn/gl create mode 100644 sql-ledger/locale/cn/ic create mode 100644 sql-ledger/locale/cn/io create mode 100644 sql-ledger/locale/cn/ir create mode 100644 sql-ledger/locale/cn/is create mode 100644 sql-ledger/locale/cn/login create mode 100644 sql-ledger/locale/cn/menu create mode 100644 sql-ledger/locale/cn/oe create mode 100644 sql-ledger/locale/cn/pe create mode 100644 sql-ledger/locale/cn/rc create mode 100644 sql-ledger/locale/cn/rp create mode 100644 sql-ledger/locale/ct/COPYING create mode 100644 sql-ledger/locale/ct/LANGUAGE create mode 100644 sql-ledger/locale/ct/admin create mode 100644 sql-ledger/locale/ct/all create mode 100644 sql-ledger/locale/ct/am create mode 100644 sql-ledger/locale/ct/ap create mode 100644 sql-ledger/locale/ct/ar create mode 100644 sql-ledger/locale/ct/arap create mode 100644 sql-ledger/locale/ct/ca create mode 100644 sql-ledger/locale/ct/cp create mode 100644 sql-ledger/locale/ct/ct create mode 100644 sql-ledger/locale/ct/gl create mode 100644 sql-ledger/locale/ct/ic create mode 100644 sql-ledger/locale/ct/io create mode 100644 sql-ledger/locale/ct/ir create mode 100644 sql-ledger/locale/ct/is create mode 100644 sql-ledger/locale/ct/login create mode 100644 sql-ledger/locale/ct/menu create mode 100644 sql-ledger/locale/ct/oe create mode 100644 sql-ledger/locale/ct/pe create mode 100644 sql-ledger/locale/ct/rc create mode 100644 sql-ledger/locale/ct/rp create mode 100644 sql-ledger/locale/cz/COPYING create mode 100644 sql-ledger/locale/cz/LANGUAGE create mode 100644 sql-ledger/locale/cz/admin create mode 100644 sql-ledger/locale/cz/all create mode 100644 sql-ledger/locale/cz/am create mode 100644 sql-ledger/locale/cz/ap create mode 100644 sql-ledger/locale/cz/ar create mode 100644 sql-ledger/locale/cz/arap create mode 100644 sql-ledger/locale/cz/ca create mode 100644 sql-ledger/locale/cz/cp create mode 100644 sql-ledger/locale/cz/ct create mode 100644 sql-ledger/locale/cz/gl create mode 100644 sql-ledger/locale/cz/ic create mode 100644 sql-ledger/locale/cz/io create mode 100644 sql-ledger/locale/cz/ir create mode 100644 sql-ledger/locale/cz/is create mode 100644 sql-ledger/locale/cz/login create mode 100644 sql-ledger/locale/cz/menu create mode 100644 sql-ledger/locale/cz/oe create mode 100644 sql-ledger/locale/cz/pe create mode 100644 sql-ledger/locale/cz/rc create mode 100644 sql-ledger/locale/cz/rp create mode 100644 sql-ledger/locale/de/COPYING create mode 100644 sql-ledger/locale/de/LANGUAGE create mode 100644 sql-ledger/locale/de/Num2text create mode 100644 sql-ledger/locale/de/admin create mode 100644 sql-ledger/locale/de/all create mode 100644 sql-ledger/locale/de/am create mode 100644 sql-ledger/locale/de/ap create mode 100644 sql-ledger/locale/de/ar create mode 100644 sql-ledger/locale/de/arap create mode 100644 sql-ledger/locale/de/ca create mode 100644 sql-ledger/locale/de/cp create mode 100644 sql-ledger/locale/de/ct create mode 100644 sql-ledger/locale/de/gl create mode 100644 sql-ledger/locale/de/ic create mode 100644 sql-ledger/locale/de/io create mode 100644 sql-ledger/locale/de/ir create mode 100644 sql-ledger/locale/de/is create mode 100755 sql-ledger/locale/de/locales.pl create mode 100644 sql-ledger/locale/de/login create mode 100644 sql-ledger/locale/de/menu create mode 100644 sql-ledger/locale/de/oe create mode 100644 sql-ledger/locale/de/pe create mode 100644 sql-ledger/locale/de/rc create mode 100644 sql-ledger/locale/de/rp create mode 100644 sql-ledger/locale/dk/COPYING create mode 100644 sql-ledger/locale/dk/LANGUAGE create mode 100644 sql-ledger/locale/dk/admin create mode 100644 sql-ledger/locale/dk/all create mode 100644 sql-ledger/locale/dk/am create mode 100644 sql-ledger/locale/dk/ap create mode 100644 sql-ledger/locale/dk/ar create mode 100644 sql-ledger/locale/dk/arap create mode 100644 sql-ledger/locale/dk/ca create mode 100644 sql-ledger/locale/dk/cp create mode 100644 sql-ledger/locale/dk/ct create mode 100644 sql-ledger/locale/dk/gl create mode 100644 sql-ledger/locale/dk/ic create mode 100644 sql-ledger/locale/dk/io create mode 100644 sql-ledger/locale/dk/ir create mode 100644 sql-ledger/locale/dk/is create mode 100644 sql-ledger/locale/dk/login create mode 100644 sql-ledger/locale/dk/menu create mode 100644 sql-ledger/locale/dk/oe create mode 100644 sql-ledger/locale/dk/pe create mode 100644 sql-ledger/locale/dk/rc create mode 100644 sql-ledger/locale/dk/rp create mode 100644 sql-ledger/locale/ee/COPYING create mode 100644 sql-ledger/locale/ee/LANGUAGE create mode 100644 sql-ledger/locale/ee/admin create mode 100644 sql-ledger/locale/ee/all create mode 100644 sql-ledger/locale/ee/am create mode 100644 sql-ledger/locale/ee/ap create mode 100644 sql-ledger/locale/ee/ar create mode 100644 sql-ledger/locale/ee/arap create mode 100644 sql-ledger/locale/ee/ca create mode 100644 sql-ledger/locale/ee/cp create mode 100644 sql-ledger/locale/ee/ct create mode 100644 sql-ledger/locale/ee/gl create mode 100644 sql-ledger/locale/ee/ic create mode 100644 sql-ledger/locale/ee/io create mode 100644 sql-ledger/locale/ee/ir create mode 100644 sql-ledger/locale/ee/is create mode 100644 sql-ledger/locale/ee/login create mode 100644 sql-ledger/locale/ee/menu create mode 100644 sql-ledger/locale/ee/oe create mode 100644 sql-ledger/locale/ee/pe create mode 100644 sql-ledger/locale/ee/rc create mode 100644 sql-ledger/locale/ee/rp create mode 100644 sql-ledger/locale/en_GB/COPYING create mode 100644 sql-ledger/locale/en_GB/LANGUAGE create mode 100644 sql-ledger/locale/en_GB/admin create mode 100644 sql-ledger/locale/en_GB/all create mode 100644 sql-ledger/locale/en_GB/am create mode 100644 sql-ledger/locale/en_GB/ap create mode 100644 sql-ledger/locale/en_GB/ar create mode 100644 sql-ledger/locale/en_GB/arap create mode 100644 sql-ledger/locale/en_GB/bp create mode 100644 sql-ledger/locale/en_GB/ca create mode 100644 sql-ledger/locale/en_GB/cp create mode 100644 sql-ledger/locale/en_GB/ct create mode 100644 sql-ledger/locale/en_GB/gl create mode 100644 sql-ledger/locale/en_GB/ic create mode 100644 sql-ledger/locale/en_GB/io create mode 100644 sql-ledger/locale/en_GB/ir create mode 100644 sql-ledger/locale/en_GB/is create mode 100644 sql-ledger/locale/en_GB/login create mode 100644 sql-ledger/locale/en_GB/menu create mode 100644 sql-ledger/locale/en_GB/oe create mode 100644 sql-ledger/locale/en_GB/pe create mode 100644 sql-ledger/locale/en_GB/rc create mode 100644 sql-ledger/locale/en_GB/rp create mode 100644 sql-ledger/locale/es/COPYING create mode 100644 sql-ledger/locale/es/LANGUAGE create mode 100644 sql-ledger/locale/es/Num2text create mode 100644 sql-ledger/locale/es/admin create mode 100644 sql-ledger/locale/es/all create mode 100644 sql-ledger/locale/es/am create mode 100644 sql-ledger/locale/es/ap create mode 100644 sql-ledger/locale/es/ar create mode 100644 sql-ledger/locale/es/arap create mode 100644 sql-ledger/locale/es/ca create mode 100644 sql-ledger/locale/es/cp create mode 100644 sql-ledger/locale/es/ct create mode 100644 sql-ledger/locale/es/gl create mode 100644 sql-ledger/locale/es/ic create mode 100644 sql-ledger/locale/es/io create mode 100644 sql-ledger/locale/es/ir create mode 100644 sql-ledger/locale/es/is create mode 100644 sql-ledger/locale/es/login create mode 100644 sql-ledger/locale/es/menu create mode 100644 sql-ledger/locale/es/oe create mode 100644 sql-ledger/locale/es/pe create mode 100644 sql-ledger/locale/es/rc create mode 100644 sql-ledger/locale/es/rp create mode 100644 sql-ledger/locale/fi/COPYING create mode 100644 sql-ledger/locale/fi/LANGUAGE create mode 100644 sql-ledger/locale/fi/admin create mode 100644 sql-ledger/locale/fi/all create mode 100644 sql-ledger/locale/fi/am create mode 100644 sql-ledger/locale/fi/ap create mode 100644 sql-ledger/locale/fi/ar create mode 100644 sql-ledger/locale/fi/arap create mode 100644 sql-ledger/locale/fi/ca create mode 100644 sql-ledger/locale/fi/cp create mode 100644 sql-ledger/locale/fi/ct create mode 100644 sql-ledger/locale/fi/gl create mode 100644 sql-ledger/locale/fi/ic create mode 100644 sql-ledger/locale/fi/io create mode 100644 sql-ledger/locale/fi/ir create mode 100644 sql-ledger/locale/fi/is create mode 100644 sql-ledger/locale/fi/login create mode 100644 sql-ledger/locale/fi/menu create mode 100644 sql-ledger/locale/fi/oe create mode 100644 sql-ledger/locale/fi/pe create mode 100644 sql-ledger/locale/fi/rc create mode 100644 sql-ledger/locale/fi/rp create mode 100644 sql-ledger/locale/fr/COPYING create mode 100644 sql-ledger/locale/fr/LANGUAGE create mode 100644 sql-ledger/locale/fr/admin create mode 100644 sql-ledger/locale/fr/all create mode 100644 sql-ledger/locale/fr/am create mode 100644 sql-ledger/locale/fr/ap create mode 100644 sql-ledger/locale/fr/ar create mode 100644 sql-ledger/locale/fr/arap create mode 100644 sql-ledger/locale/fr/ca create mode 100644 sql-ledger/locale/fr/cp create mode 100644 sql-ledger/locale/fr/ct create mode 100644 sql-ledger/locale/fr/gl create mode 100644 sql-ledger/locale/fr/ic create mode 100644 sql-ledger/locale/fr/io create mode 100644 sql-ledger/locale/fr/ir create mode 100644 sql-ledger/locale/fr/is create mode 100644 sql-ledger/locale/fr/login create mode 100644 sql-ledger/locale/fr/menu create mode 100644 sql-ledger/locale/fr/oe create mode 100644 sql-ledger/locale/fr/pe create mode 100644 sql-ledger/locale/fr/rc create mode 100644 sql-ledger/locale/fr/rp create mode 100644 sql-ledger/locale/hu/COPYING create mode 100644 sql-ledger/locale/hu/LANGUAGE create mode 100644 sql-ledger/locale/hu/admin create mode 100644 sql-ledger/locale/hu/all create mode 100644 sql-ledger/locale/hu/am create mode 100644 sql-ledger/locale/hu/ap create mode 100644 sql-ledger/locale/hu/ar create mode 100644 sql-ledger/locale/hu/arap create mode 100644 sql-ledger/locale/hu/ca create mode 100644 sql-ledger/locale/hu/cp create mode 100644 sql-ledger/locale/hu/ct create mode 100644 sql-ledger/locale/hu/gl create mode 100644 sql-ledger/locale/hu/ic create mode 100644 sql-ledger/locale/hu/io create mode 100644 sql-ledger/locale/hu/ir create mode 100644 sql-ledger/locale/hu/is create mode 100644 sql-ledger/locale/hu/login create mode 100644 sql-ledger/locale/hu/menu create mode 100644 sql-ledger/locale/hu/oe create mode 100644 sql-ledger/locale/hu/pe create mode 100644 sql-ledger/locale/hu/rc create mode 100644 sql-ledger/locale/hu/rp create mode 100644 sql-ledger/locale/is/COPYING create mode 100644 sql-ledger/locale/is/LANGUAGE create mode 100644 sql-ledger/locale/is/admin create mode 100644 sql-ledger/locale/is/all create mode 100644 sql-ledger/locale/is/am create mode 100644 sql-ledger/locale/is/ap create mode 100644 sql-ledger/locale/is/ar create mode 100644 sql-ledger/locale/is/arap create mode 100644 sql-ledger/locale/is/ca create mode 100644 sql-ledger/locale/is/cp create mode 100644 sql-ledger/locale/is/ct create mode 100644 sql-ledger/locale/is/gl create mode 100644 sql-ledger/locale/is/ic create mode 100644 sql-ledger/locale/is/io create mode 100644 sql-ledger/locale/is/ir create mode 100644 sql-ledger/locale/is/is create mode 100644 sql-ledger/locale/is/login create mode 100644 sql-ledger/locale/is/menu create mode 100644 sql-ledger/locale/is/oe create mode 100644 sql-ledger/locale/is/pe create mode 100644 sql-ledger/locale/is/rc create mode 100644 sql-ledger/locale/is/rp create mode 100644 sql-ledger/locale/it/COPYING create mode 100644 sql-ledger/locale/it/LANGUAGE create mode 100644 sql-ledger/locale/it/Num2text create mode 100644 sql-ledger/locale/it/admin create mode 100644 sql-ledger/locale/it/all create mode 100644 sql-ledger/locale/it/am create mode 100644 sql-ledger/locale/it/ap create mode 100644 sql-ledger/locale/it/ar create mode 100644 sql-ledger/locale/it/arap create mode 100644 sql-ledger/locale/it/ca create mode 100644 sql-ledger/locale/it/cp create mode 100644 sql-ledger/locale/it/ct create mode 100644 sql-ledger/locale/it/gl create mode 100644 sql-ledger/locale/it/ic create mode 100644 sql-ledger/locale/it/io create mode 100644 sql-ledger/locale/it/ir create mode 100644 sql-ledger/locale/it/is create mode 100644 sql-ledger/locale/it/login create mode 100644 sql-ledger/locale/it/menu create mode 100644 sql-ledger/locale/it/oe create mode 100644 sql-ledger/locale/it/pe create mode 100644 sql-ledger/locale/it/qe create mode 100644 sql-ledger/locale/it/rc create mode 100644 sql-ledger/locale/it/rp create mode 100644 sql-ledger/locale/lt/COPYING create mode 100644 sql-ledger/locale/lt/LANGUAGE create mode 100644 sql-ledger/locale/lt/admin create mode 100644 sql-ledger/locale/lt/all create mode 100644 sql-ledger/locale/lt/am create mode 100644 sql-ledger/locale/lt/ap create mode 100644 sql-ledger/locale/lt/ar create mode 100644 sql-ledger/locale/lt/arap create mode 100644 sql-ledger/locale/lt/ca create mode 100644 sql-ledger/locale/lt/cp create mode 100644 sql-ledger/locale/lt/ct create mode 100644 sql-ledger/locale/lt/gl create mode 100644 sql-ledger/locale/lt/ic create mode 100644 sql-ledger/locale/lt/io create mode 100644 sql-ledger/locale/lt/ir create mode 100644 sql-ledger/locale/lt/is create mode 100644 sql-ledger/locale/lt/login create mode 100644 sql-ledger/locale/lt/menu create mode 100644 sql-ledger/locale/lt/oe create mode 100644 sql-ledger/locale/lt/pe create mode 100644 sql-ledger/locale/lt/rc create mode 100644 sql-ledger/locale/lt/rp create mode 100644 sql-ledger/locale/mx/COPYING create mode 100644 sql-ledger/locale/mx/LANGUAGE create mode 100644 sql-ledger/locale/mx/admin create mode 100644 sql-ledger/locale/mx/all create mode 100644 sql-ledger/locale/mx/am create mode 100644 sql-ledger/locale/mx/ap create mode 100644 sql-ledger/locale/mx/ar create mode 100644 sql-ledger/locale/mx/arap create mode 100644 sql-ledger/locale/mx/ca create mode 100644 sql-ledger/locale/mx/cp create mode 100644 sql-ledger/locale/mx/ct create mode 100644 sql-ledger/locale/mx/gl create mode 100644 sql-ledger/locale/mx/ic create mode 100644 sql-ledger/locale/mx/io create mode 100644 sql-ledger/locale/mx/ir create mode 100644 sql-ledger/locale/mx/is create mode 100644 sql-ledger/locale/mx/login create mode 100644 sql-ledger/locale/mx/menu create mode 100644 sql-ledger/locale/mx/oe create mode 100644 sql-ledger/locale/mx/pe create mode 100644 sql-ledger/locale/mx/rc create mode 100644 sql-ledger/locale/mx/rp create mode 100644 sql-ledger/locale/nl/COPYING create mode 100644 sql-ledger/locale/nl/LANGUAGE create mode 100644 sql-ledger/locale/nl/Num2text create mode 100644 sql-ledger/locale/nl/admin create mode 100644 sql-ledger/locale/nl/all create mode 100644 sql-ledger/locale/nl/am create mode 100644 sql-ledger/locale/nl/ap create mode 100644 sql-ledger/locale/nl/ar create mode 100644 sql-ledger/locale/nl/arap create mode 100644 sql-ledger/locale/nl/ca create mode 100644 sql-ledger/locale/nl/cp create mode 100644 sql-ledger/locale/nl/ct create mode 100644 sql-ledger/locale/nl/gl create mode 100644 sql-ledger/locale/nl/ic create mode 100644 sql-ledger/locale/nl/io create mode 100644 sql-ledger/locale/nl/ir create mode 100644 sql-ledger/locale/nl/is create mode 100644 sql-ledger/locale/nl/login create mode 100644 sql-ledger/locale/nl/menu create mode 100644 sql-ledger/locale/nl/oe create mode 100644 sql-ledger/locale/nl/pe create mode 100644 sql-ledger/locale/nl/rc create mode 100644 sql-ledger/locale/nl/rp create mode 100644 sql-ledger/locale/no/COPYING create mode 100644 sql-ledger/locale/no/LANGUAGE create mode 100644 sql-ledger/locale/no/admin create mode 100644 sql-ledger/locale/no/all create mode 100644 sql-ledger/locale/no/am create mode 100644 sql-ledger/locale/no/ap create mode 100644 sql-ledger/locale/no/ar create mode 100644 sql-ledger/locale/no/arap create mode 100644 sql-ledger/locale/no/ca create mode 100644 sql-ledger/locale/no/cp create mode 100644 sql-ledger/locale/no/ct create mode 100644 sql-ledger/locale/no/gl create mode 100644 sql-ledger/locale/no/ic create mode 100644 sql-ledger/locale/no/io create mode 100644 sql-ledger/locale/no/ir create mode 100644 sql-ledger/locale/no/is create mode 100644 sql-ledger/locale/no/login create mode 100644 sql-ledger/locale/no/menu create mode 100644 sql-ledger/locale/no/oe create mode 100644 sql-ledger/locale/no/pe create mode 100644 sql-ledger/locale/no/rc create mode 100644 sql-ledger/locale/no/rp create mode 100644 sql-ledger/locale/pa/COPYING create mode 100644 sql-ledger/locale/pa/LANGUAGE create mode 100644 sql-ledger/locale/pa/admin create mode 100644 sql-ledger/locale/pa/all create mode 100644 sql-ledger/locale/pa/am create mode 100644 sql-ledger/locale/pa/ap create mode 100644 sql-ledger/locale/pa/ar create mode 100644 sql-ledger/locale/pa/arap create mode 100644 sql-ledger/locale/pa/ca create mode 100644 sql-ledger/locale/pa/cp create mode 100644 sql-ledger/locale/pa/ct create mode 100644 sql-ledger/locale/pa/gl create mode 100644 sql-ledger/locale/pa/ic create mode 100644 sql-ledger/locale/pa/io create mode 100644 sql-ledger/locale/pa/ir create mode 100644 sql-ledger/locale/pa/is create mode 100644 sql-ledger/locale/pa/login create mode 100644 sql-ledger/locale/pa/menu create mode 100644 sql-ledger/locale/pa/oe create mode 100644 sql-ledger/locale/pa/pe create mode 100644 sql-ledger/locale/pa/rc create mode 100644 sql-ledger/locale/pa/rp create mode 100644 sql-ledger/locale/pl/COPYING create mode 100644 sql-ledger/locale/pl/LANGUAGE create mode 100644 sql-ledger/locale/pl/admin create mode 100644 sql-ledger/locale/pl/all create mode 100644 sql-ledger/locale/pl/am create mode 100644 sql-ledger/locale/pl/ap create mode 100644 sql-ledger/locale/pl/ar create mode 100644 sql-ledger/locale/pl/arap create mode 100644 sql-ledger/locale/pl/ca create mode 100644 sql-ledger/locale/pl/cp create mode 100644 sql-ledger/locale/pl/ct create mode 100644 sql-ledger/locale/pl/gl create mode 100644 sql-ledger/locale/pl/ic create mode 100644 sql-ledger/locale/pl/io create mode 100644 sql-ledger/locale/pl/ir create mode 100644 sql-ledger/locale/pl/is create mode 100644 sql-ledger/locale/pl/login create mode 100644 sql-ledger/locale/pl/menu create mode 100644 sql-ledger/locale/pl/oe create mode 100644 sql-ledger/locale/pl/pe create mode 100644 sql-ledger/locale/pl/rc create mode 100644 sql-ledger/locale/pl/rp create mode 100644 sql-ledger/locale/pt/COPYING create mode 100644 sql-ledger/locale/pt/LANGUAGE create mode 100644 sql-ledger/locale/pt/admin create mode 100644 sql-ledger/locale/pt/all create mode 100644 sql-ledger/locale/pt/am create mode 100644 sql-ledger/locale/pt/ap create mode 100644 sql-ledger/locale/pt/ar create mode 100644 sql-ledger/locale/pt/arap create mode 100644 sql-ledger/locale/pt/ca create mode 100644 sql-ledger/locale/pt/cp create mode 100644 sql-ledger/locale/pt/ct create mode 100644 sql-ledger/locale/pt/gl create mode 100644 sql-ledger/locale/pt/ic create mode 100644 sql-ledger/locale/pt/io create mode 100644 sql-ledger/locale/pt/ir create mode 100644 sql-ledger/locale/pt/is create mode 100644 sql-ledger/locale/pt/login create mode 100644 sql-ledger/locale/pt/menu create mode 100644 sql-ledger/locale/pt/oe create mode 100644 sql-ledger/locale/pt/pe create mode 100644 sql-ledger/locale/pt/rc create mode 100644 sql-ledger/locale/pt/rp create mode 100644 sql-ledger/locale/ru/COPYING create mode 100644 sql-ledger/locale/ru/LANGUAGE create mode 100644 sql-ledger/locale/ru/admin create mode 100644 sql-ledger/locale/ru/all create mode 100644 sql-ledger/locale/ru/am create mode 100644 sql-ledger/locale/ru/ap create mode 100644 sql-ledger/locale/ru/ar create mode 100644 sql-ledger/locale/ru/arap create mode 100644 sql-ledger/locale/ru/ca create mode 100644 sql-ledger/locale/ru/cp create mode 100644 sql-ledger/locale/ru/ct create mode 100644 sql-ledger/locale/ru/gl create mode 100644 sql-ledger/locale/ru/ic create mode 100644 sql-ledger/locale/ru/io create mode 100644 sql-ledger/locale/ru/ir create mode 100644 sql-ledger/locale/ru/is create mode 100644 sql-ledger/locale/ru/login create mode 100644 sql-ledger/locale/ru/menu create mode 100644 sql-ledger/locale/ru/oe create mode 100644 sql-ledger/locale/ru/pe create mode 100644 sql-ledger/locale/ru/rc create mode 100644 sql-ledger/locale/ru/rp create mode 100644 sql-ledger/locale/se/COPYING create mode 100644 sql-ledger/locale/se/LANGUAGE create mode 100644 sql-ledger/locale/se/admin create mode 100644 sql-ledger/locale/se/all create mode 100644 sql-ledger/locale/se/am create mode 100644 sql-ledger/locale/se/ap create mode 100644 sql-ledger/locale/se/ar create mode 100644 sql-ledger/locale/se/arap create mode 100644 sql-ledger/locale/se/ca create mode 100644 sql-ledger/locale/se/cp create mode 100644 sql-ledger/locale/se/ct create mode 100644 sql-ledger/locale/se/gl create mode 100644 sql-ledger/locale/se/ic create mode 100644 sql-ledger/locale/se/io create mode 100644 sql-ledger/locale/se/ir create mode 100644 sql-ledger/locale/se/is create mode 100644 sql-ledger/locale/se/login create mode 100644 sql-ledger/locale/se/menu create mode 100644 sql-ledger/locale/se/oe create mode 100644 sql-ledger/locale/se/pe create mode 100644 sql-ledger/locale/se/rc create mode 100644 sql-ledger/locale/se/rp create mode 100644 sql-ledger/locale/tr/COPYING create mode 100644 sql-ledger/locale/tr/LANGUAGE create mode 100644 sql-ledger/locale/tr/admin create mode 100644 sql-ledger/locale/tr/all create mode 100644 sql-ledger/locale/tr/am create mode 100644 sql-ledger/locale/tr/ap create mode 100644 sql-ledger/locale/tr/ar create mode 100644 sql-ledger/locale/tr/arap create mode 100644 sql-ledger/locale/tr/ca create mode 100644 sql-ledger/locale/tr/cp create mode 100644 sql-ledger/locale/tr/ct create mode 100644 sql-ledger/locale/tr/gl create mode 100644 sql-ledger/locale/tr/ic create mode 100644 sql-ledger/locale/tr/io create mode 100644 sql-ledger/locale/tr/ir create mode 100644 sql-ledger/locale/tr/is create mode 100644 sql-ledger/locale/tr/login create mode 100644 sql-ledger/locale/tr/menu create mode 100644 sql-ledger/locale/tr/oe create mode 100644 sql-ledger/locale/tr/pe create mode 100644 sql-ledger/locale/tr/rc create mode 100644 sql-ledger/locale/tr/rp create mode 100644 sql-ledger/locale/tw/COPYING create mode 100644 sql-ledger/locale/tw/LANGUAGE create mode 100644 sql-ledger/locale/tw/admin create mode 100644 sql-ledger/locale/tw/all create mode 100644 sql-ledger/locale/tw/am create mode 100644 sql-ledger/locale/tw/ap create mode 100644 sql-ledger/locale/tw/ar create mode 100644 sql-ledger/locale/tw/arap create mode 100644 sql-ledger/locale/tw/ca create mode 100644 sql-ledger/locale/tw/cp create mode 100644 sql-ledger/locale/tw/ct create mode 100644 sql-ledger/locale/tw/gl create mode 100644 sql-ledger/locale/tw/ic create mode 100644 sql-ledger/locale/tw/io create mode 100644 sql-ledger/locale/tw/ir create mode 100644 sql-ledger/locale/tw/is create mode 100644 sql-ledger/locale/tw/login create mode 100644 sql-ledger/locale/tw/menu create mode 100644 sql-ledger/locale/tw/oe create mode 100644 sql-ledger/locale/tw/pe create mode 100644 sql-ledger/locale/tw/rc create mode 100644 sql-ledger/locale/tw/rp create mode 100644 sql-ledger/locale/ua/COPYING create mode 100644 sql-ledger/locale/ua/LANGUAGE create mode 100644 sql-ledger/locale/ua/admin create mode 100644 sql-ledger/locale/ua/all create mode 100644 sql-ledger/locale/ua/am create mode 100644 sql-ledger/locale/ua/ap create mode 100644 sql-ledger/locale/ua/ar create mode 100644 sql-ledger/locale/ua/arap create mode 100644 sql-ledger/locale/ua/ca create mode 100644 sql-ledger/locale/ua/cp create mode 100644 sql-ledger/locale/ua/ct create mode 100644 sql-ledger/locale/ua/gl create mode 100644 sql-ledger/locale/ua/ic create mode 100644 sql-ledger/locale/ua/io create mode 100644 sql-ledger/locale/ua/ir create mode 100644 sql-ledger/locale/ua/is create mode 100644 sql-ledger/locale/ua/login create mode 100644 sql-ledger/locale/ua/menu create mode 100644 sql-ledger/locale/ua/oe create mode 100644 sql-ledger/locale/ua/pe create mode 100644 sql-ledger/locale/ua/rc create mode 100644 sql-ledger/locale/ua/rp create mode 100644 sql-ledger/locale/ve/COPYING create mode 100644 sql-ledger/locale/ve/LANGUAGE create mode 100644 sql-ledger/locale/ve/admin create mode 100644 sql-ledger/locale/ve/all create mode 100644 sql-ledger/locale/ve/am create mode 100644 sql-ledger/locale/ve/ap create mode 100644 sql-ledger/locale/ve/ar create mode 100644 sql-ledger/locale/ve/arap create mode 100644 sql-ledger/locale/ve/ca create mode 100644 sql-ledger/locale/ve/cp create mode 100644 sql-ledger/locale/ve/ct create mode 100644 sql-ledger/locale/ve/gl create mode 100644 sql-ledger/locale/ve/ic create mode 100644 sql-ledger/locale/ve/io create mode 100644 sql-ledger/locale/ve/ir create mode 100644 sql-ledger/locale/ve/is create mode 100644 sql-ledger/locale/ve/login create mode 100644 sql-ledger/locale/ve/menu create mode 100644 sql-ledger/locale/ve/oe create mode 100644 sql-ledger/locale/ve/pe create mode 100644 sql-ledger/locale/ve/rc create mode 100644 sql-ledger/locale/ve/rp create mode 100755 sql-ledger/login.pl create mode 100644 sql-ledger/menu.ini create mode 100755 sql-ledger/setup.pl create mode 100644 sql-ledger/sql-ledger.conf.default create mode 100644 sql-ledger/sql-ledger.png create mode 100644 sql-ledger/sql/Austria-chart.sql create mode 100644 sql-ledger/sql/Austria-gifi.sql create mode 100644 sql-ledger/sql/Brazil_General-chart.sql create mode 100644 sql-ledger/sql/Canada-gifi.sql create mode 100644 sql-ledger/sql/Canada_General-chart.sql create mode 100644 sql-ledger/sql/Czech_Republic-chart.sql create mode 100644 sql-ledger/sql/Danish_Default-chart.sql create mode 100644 sql-ledger/sql/Default-chart.sql create mode 100644 sql-ledger/sql/Dutch_Default-chart.sql create mode 100644 sql-ledger/sql/Dutch_Standard-chart.sql create mode 100644 sql-ledger/sql/France-chart.sql create mode 100644 sql-ledger/sql/German-Sample-chart.sql create mode 100644 sql-ledger/sql/German-Sample-gifi.sql create mode 100644 sql-ledger/sql/Germany-DATEV-SKR03-chart.sql create mode 100644 sql-ledger/sql/Germany-DATEV-SKR03-gifi.sql create mode 100644 sql-ledger/sql/Germany-SKR03-chart.sql create mode 100644 sql-ledger/sql/Germany-SKR03-gifi.sql create mode 100644 sql-ledger/sql/Italy-chart.sql create mode 100644 sql-ledger/sql/Oracle-indices.sql create mode 100644 sql-ledger/sql/Oracle-tables.sql create mode 100644 sql-ledger/sql/Oracle-upgrade-1.8.0-1.8.4.sql create mode 100644 sql-ledger/sql/Oracle-upgrade-1.8.4-1.8.5.sql create mode 100644 sql-ledger/sql/Oracle-upgrade-1.8.5-2.0.0.sql create mode 100644 sql-ledger/sql/Oracle-upgrade-2.0.0-2.0.8.sql create mode 100644 sql-ledger/sql/Pg-indices.sql create mode 100644 sql-ledger/sql/Pg-tables.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.2.6-1.2.7.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.2.7-1.4.0.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.4.0-1.6.0.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.6.0-1.8.0.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.8.4-1.8.5.sql create mode 100644 sql-ledger/sql/Pg-upgrade-1.8.5-2.0.0.sql create mode 100644 sql-ledger/sql/Pg-upgrade-2.0.0-2.0.8.sql create mode 100644 sql-ledger/sql/Poland-chart.sql create mode 100644 sql-ledger/sql/Simplified_Chinese_Default-chart.sql create mode 100644 sql-ledger/sql/Spain-chart.sql create mode 100644 sql-ledger/sql/Swiss-German-chart.sql create mode 100644 sql-ledger/sql/Swiss-German-gifi.sql create mode 100644 sql-ledger/sql/Traditional_Chinese_Default-chart.sql create mode 100644 sql-ledger/sql/US_General-chart.sql create mode 100644 sql-ledger/templates/Brazilian_Portuguese-balance_sheet.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-check.tex create mode 100644 sql-ledger/templates/Brazilian_Portuguese-income_statement.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-invoice.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-invoice.tex create mode 100644 sql-ledger/templates/Brazilian_Portuguese-packing_list.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-packing_list.tex create mode 100644 sql-ledger/templates/Brazilian_Portuguese-purchase_order.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-purchase_order.tex create mode 100644 sql-ledger/templates/Brazilian_Portuguese-receipt.tex create mode 100644 sql-ledger/templates/Brazilian_Portuguese-sales_order.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-sales_order.tex create mode 100644 sql-ledger/templates/Brazilian_Portuguese-statement.html create mode 100644 sql-ledger/templates/Brazilian_Portuguese-statement.tex create mode 100644 sql-ledger/templates/Danish-balance_sheet.html create mode 100644 sql-ledger/templates/Danish-check.tex create mode 100644 sql-ledger/templates/Danish-income_statement.html create mode 100644 sql-ledger/templates/Danish-invoice.html create mode 100644 sql-ledger/templates/Danish-invoice.tex create mode 100644 sql-ledger/templates/Danish-packing_list.html create mode 100644 sql-ledger/templates/Danish-packing_list.tex create mode 100644 sql-ledger/templates/Danish-purchase_order.html create mode 100644 sql-ledger/templates/Danish-purchase_order.tex create mode 100644 sql-ledger/templates/Danish-receipt.tex create mode 100644 sql-ledger/templates/Danish-sales_order.html create mode 100644 sql-ledger/templates/Danish-sales_order.tex create mode 100644 sql-ledger/templates/Danish-statement.html create mode 100644 sql-ledger/templates/Danish-statement.tex create mode 100644 sql-ledger/templates/Default-balance_sheet.html create mode 100644 sql-ledger/templates/Default-check.tex create mode 100644 sql-ledger/templates/Default-income_statement.html create mode 100644 sql-ledger/templates/Default-invoice.html create mode 100644 sql-ledger/templates/Default-invoice.tex create mode 100644 sql-ledger/templates/Default-packing_list.html create mode 100644 sql-ledger/templates/Default-packing_list.tex create mode 100644 sql-ledger/templates/Default-purchase_order.html create mode 100644 sql-ledger/templates/Default-purchase_order.tex create mode 100644 sql-ledger/templates/Default-receipt.tex create mode 100644 sql-ledger/templates/Default-sales_order.html create mode 100644 sql-ledger/templates/Default-sales_order.tex create mode 100644 sql-ledger/templates/Default-statement.html create mode 100644 sql-ledger/templates/Default-statement.tex create mode 100644 sql-ledger/templates/Dutch-balance_sheet.html create mode 100644 sql-ledger/templates/Dutch-check.tex create mode 100644 sql-ledger/templates/Dutch-income_statement.html create mode 100644 sql-ledger/templates/Dutch-invoice.html create mode 100644 sql-ledger/templates/Dutch-invoice.tex create mode 100644 sql-ledger/templates/Dutch-packing_list.html create mode 100644 sql-ledger/templates/Dutch-packing_list.tex create mode 100644 sql-ledger/templates/Dutch-purchase_order.html create mode 100644 sql-ledger/templates/Dutch-purchase_order.tex create mode 100644 sql-ledger/templates/Dutch-receipt.tex create mode 100644 sql-ledger/templates/Dutch-sales_order.html create mode 100644 sql-ledger/templates/Dutch-sales_order.tex create mode 100644 sql-ledger/templates/Dutch-statement.html create mode 100644 sql-ledger/templates/Dutch-statement.tex create mode 100644 sql-ledger/templates/Estonian-balance_sheet.html create mode 100644 sql-ledger/templates/Estonian-check.tex create mode 100644 sql-ledger/templates/Estonian-income_statement.html create mode 100644 sql-ledger/templates/Estonian-invoice.html create mode 100644 sql-ledger/templates/Estonian-invoice.tex create mode 100644 sql-ledger/templates/Estonian-packing_list.html create mode 100644 sql-ledger/templates/Estonian-packing_list.tex create mode 100644 sql-ledger/templates/Estonian-purchase_order.html create mode 100644 sql-ledger/templates/Estonian-purchase_order.tex create mode 100644 sql-ledger/templates/Estonian-receipt.tex create mode 100644 sql-ledger/templates/Estonian-sales_order.html create mode 100644 sql-ledger/templates/Estonian-sales_order.tex create mode 100644 sql-ledger/templates/Estonian-statement.html create mode 100644 sql-ledger/templates/Estonian-statement.tex create mode 100644 sql-ledger/templates/French-balance_sheet.html create mode 100644 sql-ledger/templates/French-check.tex create mode 100644 sql-ledger/templates/French-income_statement.html create mode 100644 sql-ledger/templates/French-invoice.html create mode 100644 sql-ledger/templates/French-invoice.tex create mode 100644 sql-ledger/templates/French-packing_list.html create mode 100644 sql-ledger/templates/French-packing_list.tex create mode 100644 sql-ledger/templates/French-purchase_order.html create mode 100644 sql-ledger/templates/French-purchase_order.tex create mode 100644 sql-ledger/templates/French-receipt.tex create mode 100644 sql-ledger/templates/French-sales_order.html create mode 100644 sql-ledger/templates/French-sales_order.tex create mode 100644 sql-ledger/templates/French-statement.html create mode 100644 sql-ledger/templates/French-statement.tex create mode 100644 sql-ledger/templates/German-balance_sheet.html create mode 100644 sql-ledger/templates/German-check.tex create mode 100644 sql-ledger/templates/German-income_statement.html create mode 100644 sql-ledger/templates/German-invoice.html create mode 100644 sql-ledger/templates/German-invoice.tex create mode 100644 sql-ledger/templates/German-packing_list.html create mode 100644 sql-ledger/templates/German-packing_list.tex create mode 100644 sql-ledger/templates/German-purchase_order.html create mode 100644 sql-ledger/templates/German-purchase_order.tex create mode 100644 sql-ledger/templates/German-receipt.tex create mode 100644 sql-ledger/templates/German-sales_order.html create mode 100644 sql-ledger/templates/German-sales_order.tex create mode 100644 sql-ledger/templates/German-statement.html create mode 100644 sql-ledger/templates/German-statement.tex create mode 100644 sql-ledger/templates/Service-balance_sheet.html create mode 100644 sql-ledger/templates/Service-check.tex create mode 100644 sql-ledger/templates/Service-income_statement.html create mode 100644 sql-ledger/templates/Service-invoice.html create mode 100644 sql-ledger/templates/Service-invoice.tex create mode 100644 sql-ledger/templates/Service-packing_list.html create mode 100644 sql-ledger/templates/Service-packing_list.tex create mode 100644 sql-ledger/templates/Service-purchase_order.html create mode 100644 sql-ledger/templates/Service-purchase_order.tex create mode 100644 sql-ledger/templates/Service-receipt.tex create mode 100644 sql-ledger/templates/Service-sales_order.html create mode 100644 sql-ledger/templates/Service-sales_order.tex create mode 100644 sql-ledger/templates/Service-statement.html create mode 100644 sql-ledger/templates/Service-statement.tex create mode 100644 sql-ledger/templates/Spanish_A4-balance_sheet.html create mode 100644 sql-ledger/templates/Spanish_A4-check.tex create mode 100644 sql-ledger/templates/Spanish_A4-income_statement.html create mode 100644 sql-ledger/templates/Spanish_A4-invoice.html create mode 100644 sql-ledger/templates/Spanish_A4-invoice.tex create mode 100644 sql-ledger/templates/Spanish_A4-packing_list.html create mode 100644 sql-ledger/templates/Spanish_A4-packing_list.tex create mode 100644 sql-ledger/templates/Spanish_A4-purchase_order.html create mode 100644 sql-ledger/templates/Spanish_A4-purchase_order.tex create mode 100644 sql-ledger/templates/Spanish_A4-receipt.tex create mode 100644 sql-ledger/templates/Spanish_A4-sales_order.html create mode 100644 sql-ledger/templates/Spanish_A4-sales_order.tex create mode 100644 sql-ledger/templates/Spanish_A4-statement.html create mode 100644 sql-ledger/templates/Spanish_A4-statement.tex create mode 100644 sql-ledger/templates/Spanish_Letter-balance_sheet.html create mode 100644 sql-ledger/templates/Spanish_Letter-check.tex create mode 100644 sql-ledger/templates/Spanish_Letter-income_statement.html create mode 100644 sql-ledger/templates/Spanish_Letter-invoice.html create mode 100644 sql-ledger/templates/Spanish_Letter-invoice.tex create mode 100644 sql-ledger/templates/Spanish_Letter-packing_list.html create mode 100644 sql-ledger/templates/Spanish_Letter-packing_list.tex create mode 100644 sql-ledger/templates/Spanish_Letter-purchase_order.html create mode 100644 sql-ledger/templates/Spanish_Letter-purchase_order.tex create mode 100644 sql-ledger/templates/Spanish_Letter-receipt.tex create mode 100644 sql-ledger/templates/Spanish_Letter-sales_order.html create mode 100644 sql-ledger/templates/Spanish_Letter-sales_order.tex create mode 100644 sql-ledger/templates/Spanish_Letter-statement.html create mode 100644 sql-ledger/templates/Spanish_Letter-statement.tex create mode 100644 sql-ledger/users/members.default diff --git a/sql-ledger/SL/AM.pm b/sql-ledger/SL/AM.pm new file mode 100644 index 000000000..d691b3ce6 --- /dev/null +++ b/sql-ledger/SL/AM.pm @@ -0,0 +1,694 @@ +#===================================================================== +# SQL-Ledger Accounting +# Copyright (C) 2001 +# +# Author: Dieter Simader +# Email: dsimader@sql-ledger.org +# Web: http://www.sql-ledger.org +# +# Contributors: +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 2 of the License, or +# (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. +#====================================================================== +# +# Administration module +# Chart of Accounts +# template routines +# preferences +# +#====================================================================== + +package AM; + + +sub get_account { + my ($self, $myconfig, $form) = @_; + + # connect to database + my $dbh = $form->dbconnect($myconfig); + + my $query = qq|SELECT accno, description, charttype, gifi_accno, + category, link + FROM chart + WHERE id = $form->{id}|; + my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + + my $ref = $sth->fetchrow_hashref(NAME_lc); + + foreach my $key (keys %$ref) { + $form->{"$key"} = $ref->{"$key"}; + } + + $sth->finish; + + + # get default accounts + $query = qq|SELECT inventory_accno_id, income_accno_id, expense_accno_id + FROM defaults|; + $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + + $ref = $sth->fetchrow_hashref(NAME_lc); + + map { $form->{$_} = $ref->{$_} } keys %ref; + + $sth->finish; + $dbh->disconnect; + +} + + +sub save_account { + my ($self, $myconfig, $form) = @_; + + # connect to database, turn off AutoCommit + my $dbh = $form->dbconnect_noauto($myconfig); + + # sanity check, can't have AR with AR_... + if ($form->{AR} || $form->{AP} || $form->{IC}) { + map { delete $form->{$_} } qw(AR_amount AR_tax AR_paid AP_amount AP_tax AP_paid IC_sale IC_cogs IC_taxpart IC_income IC_expense IC_taxservice); + } + + $form->{link} = ""; + foreach my $item ($form->{AR}, + $form->{AR_amount}, + $form->{AR_tax}, + $form->{AR_paid}, + $form->{AP}, + $form->{AP_amount}, + $form->{AP_tax}, + $form->{AP_paid}, + $form->{IC}, + $form->{IC_sale}, + $form->{IC_cogs}, + $form->{IC_taxpart}, + $form->{IC_income}, + $form->{IC_expense}, + $form->{IC_taxservice}, + $form->{CT_tax} + ) { + $form->{link} .= "${item}:" if ($item); + } + chop $form->{link}; + + # if we have an id then replace the old record + $form->{description} =~ s/'/''/g; + + # strip blanks from accno + map { $form->{$_} =~ s/ //g; } qw(accno gifi_accno); + + my ($query, $sth); + + if ($form->{id}) { + $query = qq|UPDATE chart SET + accno = '$form->{accno}', + description = '$form->{description}', + charttype = '$form->{charttype}', + gifi_accno = '$form->{gifi_accno}', + category = '$form->{category}', + link = '$form->{link}' + WHERE id = $form->{id}|; + } else { + $query = qq|INSERT INTO chart + (accno, description, charttype, gifi_accno, category, link) + VALUES ('$form->{accno}', '$form->{description}', + '$form->{charttype}', '$form->{gifi_accno}', + '$form->{category}', '$form->{link}')|; + } + $dbh->do($query) || $form->dberror($query); + + + if ($form->{IC_taxpart} || $form->{IC_taxservice} || $form->{CT_tax}) { + + my $chart_id = $form->{id}; + + unless ($form->{id}) { + # get id from chart + $query = qq|SELECT id + FROM chart + WHERE accno = '$form->{accno}'|; + $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + + ($chart_id) = $sth->fetchrow_array; + $sth->finish; + } + + # add account if it doesn't exist in tax + $query = qq|SELECT chart_id + FROM tax + WHERE chart_id = $chart_id|; + $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + + my ($tax_id) = $sth->fetchrow_array; + $sth->finish; + + # add tax if it doesn't exist + unless ($tax_id) { + $query = qq|INSERT INTO tax (chart_id, rate) + VALUES ($chart_id, 0)|; + $dbh->do($query) || $form->dberror($query); + } + } else { + # remove tax + if ($form->{id}) { + $query = qq|DELETE FROM tax + WHERE chart_id = $form->{id}|; + $dbh->do($query) || $form->dberror($query); + } + } + + + # commit + my $rc = $dbh->commit; + $dbh->disconnect; + + $rc; + +} + + + +sub delete_account { + my ($self, $myconfig, $form) = @_; + + # connect to database, turn off AutoCommit + my $dbh = $form->dbconnect_noauto($myconfig); + + # delete chart of account record + $query = qq|DELETE FROM chart + WHERE id = $form->{id}|; + $dbh->do($query) || $form->dberror($query); + + # set inventory_accno_id, income_accno_id, expense_accno_id to defaults + $query = qq|UPDATE parts + SET inventory_accno_id = + (SELECT inventory_accno_id FROM defaults) + WHERE inventory_accno_id = $form->{id}|; + $dbh->do($query) || $form->dberror($query); + + $query = qq|UPDATE parts + SET income_accno_id = + (SELECT income_accno_id FROM defaults) + WHERE income_accno_id = $form->{id}|; + $dbh->do($query) || $form->dberror($query); + + $query = qq|UPDATE parts + SET expense_accno_id = + (SELECT expense_accno_id FROM defaults) + WHERE expense_accno_id = $form->{id}|; + $dbh->do($query) || $form->dberror($query); + + foreach my $table (qw(partstax customertax vendortax tax)) { + $query = qq|DELETE FROM $table + WHERE chart_id = $form->{id}|; + $dbh->do($query) || $form->dberror($query); + } + + # commit and redirect + my $rc = $dbh->commit; + $dbh->disconnect; + + $rc; + +} + + +sub gifi_accounts { + my ($self, $myconfig, $form) = @_; + + # connect to database + my $dbh = $form->dbconnect($myconfig); + + my $query = qq|SELECT accno, description + FROM gifi + ORDER BY accno|; + + $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + + while (my $ref = $sth->fetchrow_hashref(NAME_lc)) { + push @{ $form->{ALL} }, $ref; + } + + $sth->finish; + $dbh->disconnect; + +} + + + +sub get_gifi { + my ($self, $myconfig, $form) = @_; + + # connect to database + my $dbh = $form->dbconnect($myconfig); + + my $query = qq|SELECT accno, description + FROM gifi + WHERE accno = '$form->{accno}'|; + my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + + my $ref = $sth->fetchrow_hashref(NAME_lc); + + map { $form->{$_} = $ref->{$_} } keys %$ref; + + $sth->finish; + $dbh->disconnect; + +} + + +sub save_gifi { + my ($self, $myconfig, $form) = @_; + + # connect to database + my $dbh = $form->dbconnect($myconfig); + + $form->{description} =~ s/'/''/g; + $form->{accno} =~ s/ //g; + + # id is the old account number! + if ($form->{id}) { + $query = qq|UPDATE gifi SET + accno = '$form->{accno}', + description = '$form->{description}' + WHERE accno = '$form->{id}'|; + } else { + $query = qq|INSERT INTO gifi + (accno, description) + VALUES ('$form->{accno}', '$form->{description}')|; + } + $dbh->do($query) || $form->dberror($query); + + $dbh->disconnect; + +} + + +sub delete_gifi { + my ($self, $myconfig, $form) = @_; + + # connect to database + my $dbh = $form->dbconnect($myconfig); + + # id is the old account number! + $query = qq|DELETE FROM gifi + WHERE accno = '$form->{id}'|; + $dbh->do($query) || $form->dberror($query); + + $dbh->disconnect; + +} + + +sub load_template { + my ($self, $form) = @_; + + open(TEMPLATE, "$form->{file}") or $form->error("$form->{file} : $!"); + + while (