Commit Graph

  • 56e6aa1f34 Preliminary work on NSF. It's far from working, but we're headed in the right direction. abijah 2009-07-30 06:29:41 +00:00
  • 3e715bae9f In the cleanup of r423, some code accidentally got squashed. This checkin undoes that problem abijah 2009-07-30 06:09:05 +00:00
  • 6e759e8589 In the cleanup of r423, some code accidentally got squashed. This checkin undoes that problem abijah 2009-07-30 06:09:05 +00:00
  • 347aa20622 Fixed problem when trying to calculate transaction stats. The current solution is a bit dodgy, but by limiting the queries to LedgerEntry and StatementEntry, it works without too much extra effort. abijah 2009-07-30 02:47:43 +00:00
  • 9733226dfd Fixed problem when trying to calculate transaction stats. The current solution is a bit dodgy, but by limiting the queries to LedgerEntry and StatementEntry, it works without too much extra effort. abijah 2009-07-30 02:47:43 +00:00
  • 510ca489ec Cleanup of old lingering functions and some comment blocks abijah 2009-07-30 02:39:09 +00:00
  • be2865b4d7 Cleanup of old lingering functions and some comment blocks abijah 2009-07-30 02:39:09 +00:00
  • e4426cde55 Fixed the problem with zero dollar balance forward entries when closing a ledger. abijah 2009-07-30 02:17:49 +00:00
  • adddfecada Fixed the problem with zero dollar balance forward entries when closing a ledger. abijah 2009-07-30 02:17:49 +00:00
  • 25e3c87213 Got the ledger closings to work again. This seems to work ok, although I notice closing the ledger after deposit results in a balance forward entry of $0.00 . I'll work on it next abijah 2009-07-30 01:59:10 +00:00
  • 55c5c9e9e6 Got the ledger closings to work again. This seems to work ok, although I notice closing the ledger after deposit results in a balance forward entry of $0.00 . I'll work on it next abijah 2009-07-30 01:59:10 +00:00
  • eb209a455b Disabled submission of tender types that have no items abijah 2009-07-29 23:25:26 +00:00
  • 42677ae2f4 Disabled submission of tender types that have no items abijah 2009-07-29 23:25:26 +00:00
  • ccf7a5fccd This is the remainder of the previous, invalid, partial checkin. abijah 2009-07-29 23:25:03 +00:00
  • ec8f540107 This is the remainder of the previous, invalid, partial checkin. abijah 2009-07-29 23:25:03 +00:00
  • a8862ea3fd Moved deposit creation to the transactions controller. Added the ability to view prior deposit slips. abijah 2009-07-29 23:17:00 +00:00
  • 393c0dbb3f Moved deposit creation to the transactions controller. Added the ability to view prior deposit slips. abijah 2009-07-29 23:17:00 +00:00
  • f6a93af27d Added a minimum age feature to the date formatting. It's not really a perfect solution, but it's working for our needs at the moment. abijah 2009-07-29 23:16:26 +00:00
  • f8413b8784 Added a minimum age feature to the date formatting. It's not really a perfect solution, but it's working for our needs at the moment. abijah 2009-07-29 23:16:26 +00:00
  • e1217cd185 Updated requirements (and unfortunately, had to back some completed items off the list since our latest rework. abijah 2009-07-29 10:23:08 +00:00
  • 37d0fe7f3f Removed all the debug comments added to the database by the sitelink script. Noted another defect in the todo list. abijah 2009-07-29 10:18:13 +00:00
  • 362226183e Changed the deposit to use a grouped double entry instead of individual ones for each tender deposited abijah 2009-07-29 10:10:11 +00:00
  • 13f97e5770 Changed the deposit to use a grouped double entry instead of individual ones for each tender deposited abijah 2009-07-29 10:10:11 +00:00
  • 438610bdf9 Added customer association to each tender abijah 2009-07-29 09:33:29 +00:00
  • b789ed62b7 Added customer association to each tender abijah 2009-07-29 09:33:29 +00:00
  • cdf6ce86e3 Re-implemented the deposit functionality. This is mostly working, although I'd like to get customer added to the tenders table, and probably change to a single deposit ledger entry for each tender type. A single entry would require that all tender types have been recorded to the same account, something that isn't mandated at the present, but is likely to be true most of the time. Perhaps they could just be grouped by account id, which should work in all cases and yet align with tender type 99% of the time. I'll have to think about it. abijah 2009-07-29 08:55:09 +00:00
  • 2ffe04e3e4 Re-implemented the deposit functionality. This is mostly working, although I'd like to get customer added to the tenders table, and probably change to a single deposit ledger entry for each tender type. A single entry would require that all tender types have been recorded to the same account, something that isn't mandated at the present, but is likely to be true most of the time. Perhaps they could just be grouped by account id, which should work in all cases and yet align with tender type 99% of the time. I'll have to think about it. abijah 2009-07-29 08:55:09 +00:00
  • 3128880c4d Fixed problem with grid display when part of a form abijah 2009-07-29 08:50:44 +00:00
  • cdba179d79 Fixed problem with grid display when part of a form abijah 2009-07-29 08:50:44 +00:00
  • e23413b4d8 Cleaned up some of the old code concerning the deposit action. It's not done, as I'll next be experimenting with having the tenders controller handle deposits. abijah 2009-07-29 02:43:30 +00:00
  • 5ba6438b77 Cleaned up some of the old code concerning the deposit action. It's not done, as I'll next be experimenting with having the tenders controller handle deposits. abijah 2009-07-29 02:43:30 +00:00
  • 3a6964c4bf Added more information to the tender grid, and a new query to return depositable types abijah 2009-07-29 02:41:50 +00:00
  • a4459ef0de Added more information to the tender grid, and a new query to return depositable types abijah 2009-07-29 02:41:50 +00:00
  • 95f43f07bf Fixed the pluralization of cash abijah 2009-07-29 02:39:31 +00:00
  • e7b71e0abb Fixed the pluralization of cash abijah 2009-07-29 02:39:31 +00:00
  • bfa71375e8 Started work on handling NSF, but will deal with deposits first, since we can't get an NSF without a deposit first. abijah 2009-07-29 01:51:34 +00:00
  • 0c06ef6d71 Started work on handling NSF, but will deal with deposits first, since we can't get an NSF without a deposit first. abijah 2009-07-29 01:51:34 +00:00
  • 48123c98b8 Minor change to the default accounts on the collected screen. Probably will be tweaked again later. abijah 2009-07-29 01:50:33 +00:00
  • 0f42ad9b07 Minor change to the default accounts on the collected screen. Probably will be tweaked again later. abijah 2009-07-29 01:50:33 +00:00
  • 9d35ed1aa9 Added the debug class to the debug grid query link, so that it doesn't show on print media. abijah 2009-07-29 01:43:08 +00:00
  • c20b287c53 Added the debug class to the debug grid query link, so that it doesn't show on print media. abijah 2009-07-29 01:43:08 +00:00
  • ae35d637ac Increased font size for the page number input at the bottom of each jqGrid abijah 2009-07-29 01:42:16 +00:00
  • ef4d8d4d30 Increased font size for the page number input at the bottom of each jqGrid abijah 2009-07-29 01:42:16 +00:00
  • 6cd0a1378d Added a print media CSS file, and fixed the jqGrid print problem of truncating the table to a single page. Also, used the opportunity to disable printing of the side menu and the debug toolkit, as well as some more jqGrid cleanup. abijah 2009-07-29 01:41:34 +00:00
  • e7a659a690 Added a print media CSS file, and fixed the jqGrid print problem of truncating the table to a single page. Also, used the opportunity to disable printing of the side menu and the debug toolkit, as well as some more jqGrid cleanup. abijah 2009-07-29 01:41:34 +00:00
  • 1d6c7436d4 Got the collected reports working again. NSF hasn't been tested yet, because NSF entry is not yet working. abijah 2009-07-28 16:08:15 +00:00
  • f6ee56501d Got the collected reports working again. NSF hasn't been tested yet, because NSF entry is not yet working. abijah 2009-07-28 16:08:15 +00:00
  • aa0a60ea2b Modified the grid helper to allow a view to directly specify custom post data without wiping out any custom post data set by the element. It's not been used or tested. abijah 2009-07-28 16:07:34 +00:00
  • 826eb63da1 Modified the grid helper to allow a view to directly specify custom post data without wiping out any custom post data set by the element. It's not been used or tested. abijah 2009-07-28 16:07:34 +00:00
  • 6cf6dda3f8 Fixed a bug that was causing multiple tender types to have a name like 'Check #' abijah 2009-07-28 16:06:03 +00:00
  • 5446f6a266 Removed Brenda Harmon test code. abijah 2009-07-28 02:41:11 +00:00
  • d8fe7f9264 Suppressed all the debug print statements from transaction insertion. abijah 2009-07-28 02:40:42 +00:00
  • b225775a91 Suppressed all the debug print statements from transaction insertion. abijah 2009-07-28 02:40:42 +00:00
  • 1372bb68e4 Half-kludgy fix to a filtering bug when a table is already specified using the simple notation, e.g. array('Table'), instead of the more complete form array('Table' => array(...)) abijah 2009-07-28 02:39:44 +00:00
  • a5565546d1 Half-kludgy fix to a filtering bug when a table is already specified using the simple notation, e.g. array('Table'), instead of the more complete form array('Table' => array(...)) abijah 2009-07-28 02:39:44 +00:00
  • cb5b017c7e Bug fixes to get lease security deposit and balance information working. abijah 2009-07-28 01:18:02 +00:00
  • f0b65dcf74 Bug fixes to get lease security deposit and balance information working. abijah 2009-07-28 01:18:02 +00:00
  • 8e720dbfec Added a rent column to the units list abijah 2009-07-28 01:17:09 +00:00
  • ad1758a5dc Added a rent column to the units list abijah 2009-07-28 01:17:09 +00:00
  • 24ccb56e50 Further tweaked the code to add new transactions, primarily by creating separate verification and addition functions in each underlying model. There are logic changes as well, such as adding in the other half of the missing double entry (as well as the double entry itself). This checkin also introduces the creation of CREDIT statement entries, when the customer has overpayed. It's working fairly well, although undoubtedly will need more tweaking. abijah 2009-07-28 01:16:42 +00:00
  • b3389652fd Further tweaked the code to add new transactions, primarily by creating separate verification and addition functions in each underlying model. There are logic changes as well, such as adding in the other half of the missing double entry (as well as the double entry itself). This checkin also introduces the creation of CREDIT statement entries, when the customer has overpayed. It's working fairly well, although undoubtedly will need more tweaking. abijah 2009-07-28 01:16:42 +00:00
  • 4adf0dd2fc Added a debug dump function to print out a model without getting stuck on the recursive inclusion of other models. abijah 2009-07-28 01:11:27 +00:00
  • ba62eed027 Added a debug dump function to print out a model without getting stuck on the recursive inclusion of other models. abijah 2009-07-28 01:11:27 +00:00
  • 24bca2c8e9 Implemented a mechanism to track customer overpayments (credits). Also implemented a reconciling algorithm, matching payments to charges. Preliminary testing seems to show that it works well. More thorough testing required. abijah 2009-07-27 04:18:38 +00:00
  • 3dc751c863 Implemented a mechanism to track customer overpayments (credits). Also implemented a reconciling algorithm, matching payments to charges. Preliminary testing seems to show that it works well. More thorough testing required. abijah 2009-07-27 04:18:38 +00:00
  • 2cc58255c3 Playing with different means for determining stats. Nothing decided yet. abijah 2009-07-26 23:23:19 +00:00
  • 68fe787209 Playing with different means for determining stats. Nothing decided yet. abijah 2009-07-26 23:23:19 +00:00
  • 36f439ff38 Added ability to toggle between one big closing ledger entry, and one per house abijah 2009-07-25 08:08:47 +00:00
  • d4292a85a0 Added ability to toggle between one big closing ledger entry, and one per house abijah 2009-07-25 08:08:47 +00:00
  • 7a42bee8ef Added transaction stats. Added (possibly unwanted) columns. abijah 2009-07-25 08:06:50 +00:00
  • f9635419dd Added transaction stats. Added (possibly unwanted) columns. abijah 2009-07-25 08:06:50 +00:00
  • 0170dbc310 Fixed yet another bug in the merging of actions & options abijah 2009-07-25 07:57:56 +00:00
  • d8f10bfd13 Fixed yet another bug in the merging of actions & options abijah 2009-07-25 07:57:56 +00:00
  • b820929ddc Made progress adapting the receipt code onto the latest db changes. abijah 2009-07-24 07:43:42 +00:00
  • 25b7da57f3 Made progress adapting the receipt code onto the latest db changes. abijah 2009-07-24 07:43:42 +00:00
  • 743ff52e59 Made changes to get field alignment on receipt entry. I can get the text on the left by floating the label, but actually, I think I prefer the boxes on the left. abijah 2009-07-24 05:01:29 +00:00
  • 29fe265daa Made changes to get field alignment on receipt entry. I can get the text on the left by floating the label, but actually, I think I prefer the boxes on the left. abijah 2009-07-24 05:01:29 +00:00
  • efb4655786 Reverted back to r383. abijah 2009-07-24 04:16:33 +00:00
  • 769c02a5f1 Reverted back to r383. abijah 2009-07-24 04:16:33 +00:00
  • 7c34c7faff I tried using a table for the receipt entry, which seems like it should work, but really doesn't. I'll check it in for future reference, but I'll be reverting just afterwards abijah 2009-07-24 04:15:39 +00:00
  • 476a179e7b I tried using a table for the receipt entry, which seems like it should work, but really doesn't. I'll check it in for future reference, but I'll be reverting just afterwards abijah 2009-07-24 04:15:39 +00:00
  • e448519a1e I accidentally tried to cehck in tender.php instead of the intended tender_type.php abijah 2009-07-24 03:58:57 +00:00
  • df8ebe45ef I accidentally tried to cehck in tender.php instead of the intended tender_type.php abijah 2009-07-24 03:58:57 +00:00
  • a4dff8a6ed Begin the move from having receipts generated based on 'collectable' account, to being based on what the database considers to be a form of tender. This has the excellent benefit of removing all those hardcoded data1/2 fields for each different tender type. That's all database driven now. There is more to do, but this is a good step forward. abijah 2009-07-24 03:58:12 +00:00
  • 0bf458f243 Begin the move from having receipts generated based on 'collectable' account, to being based on what the database considers to be a form of tender. This has the excellent benefit of removing all those hardcoded data1/2 fields for each different tender type. That's all database driven now. There is more to do, but this is a good step forward. abijah 2009-07-24 03:58:12 +00:00
  • 2db0fc12d3 Forgot this file on the last checkin, since it was using the trackable field abijah 2009-07-24 03:55:54 +00:00
  • 18c4f5ea48 Forgot this file on the last checkin, since it was using the trackable field abijah 2009-07-24 03:55:54 +00:00
  • 991d4d717e Modified the application to reflect the changed field names in the accounts table. For example, payable is now payments. abijah 2009-07-24 03:22:56 +00:00
  • a0f33054cb Modified the application to reflect the changed field names in the accounts table. For example, payable is now payments. abijah 2009-07-24 03:22:56 +00:00
  • 0f00b42d1f Modified the closing sum to be a single receipt, and a single debit/credit to the ledger of choice (presently Equity). This was mostly a test to check the logic of multiple payments having only a single accounting transaction. It seems to work, but I suspect we'll have trouble when we start to figure out customer account balances, since the receipt has NULL for the customer_id (since it is a receipt for many customers). Depending on the customer balance / reconciliation logic, this may or may not fly. abijah 2009-07-24 03:12:18 +00:00
  • 446ba0ce28 Added a much more user friendly way to present the data1-4 labels for each type, now that we have a tender_types table. Still not a perfect solution, but definitely good enough for now. Modified the application to recognize the new tender_types table. There may be other modifications necessary, but this gets the most obvious spot. abijah 2009-07-24 02:07:43 +00:00
  • 1e0b96953e Added a much more user friendly way to present the data1-4 labels for each type, now that we have a tender_types table. Still not a perfect solution, but definitely good enough for now. Modified the application to recognize the new tender_types table. There may be other modifications necessary, but this gets the most obvious spot. abijah 2009-07-24 02:07:43 +00:00
  • b408d86a98 Added Concession as a form of tender (which clearly isn't legal tender, and might not even be tender... who knows). abijah 2009-07-24 01:48:58 +00:00
  • e739282d17 Modified tenders to use a tender_type_id, not only for the ability to dynamically add types later, but primarily so that a type could be associated with an account, instead of hardcoding it in the application. With this, I changed several of the account field names, but they shouldn't be in too heavy use in the application. abijah 2009-07-24 01:43:41 +00:00
  • 4cab2c09c1 Fixed some minor display issues and tweaks to compensate for the new stats() algorithm. More are necessary, I'm sure. abijah 2009-07-23 23:54:40 +00:00
  • c73016ecf2 Fixed some minor display issues and tweaks to compensate for the new stats() algorithm. More are necessary, I'm sure. abijah 2009-07-23 23:54:40 +00:00
  • 127f7f3eb9 Finally resolved the StatementEntries::stats() query issue. It has been lingering in an incomplete state because it wasn't clear what it was supposed to really do. I think it is now performing the task expected of it. abijah 2009-07-23 23:52:59 +00:00
  • 122dfb10a0 Finally resolved the StatementEntries::stats() query issue. It has been lingering in an incomplete state because it wasn't clear what it was supposed to really do. I think it is now performing the task expected of it. abijah 2009-07-23 23:52:59 +00:00
  • ce23bf5abd Fixed a bug with idlist caused when we moved all the post data into the 'post' field abijah 2009-07-23 23:45:04 +00:00
  • 9a32800170 Fixed a bug with idlist caused when we moved all the post data into the 'post' field abijah 2009-07-23 23:45:04 +00:00