Commit Graph

  • 4ebe1db2cc Cleaned up the controllers and now make use of the Linkable behavior for listing out items. abijah 2009-06-01 04:36:28 +00:00
  • feaabd29d9 Cleaned up the paginate comment remnants and added the undocumented 'extra' parameter to paginate abijah 2009-06-01 04:30:32 +00:00
  • f74073a2e1 Cleaned up the paginate comment remnants and added the undocumented 'extra' parameter to paginate abijah 2009-06-01 04:30:32 +00:00
  • f48e7d8907 Removed the named table alias from each of the HABTM joins, since we don't know in advance what name will be used in the actual join abijah 2009-06-01 04:29:26 +00:00
  • 3f6c526718 Removed the named table alias from each of the HABTM joins, since we don't know in advance what name will be used in the actual join abijah 2009-06-01 04:29:26 +00:00
  • 991b5a3317 Performed cleanup, and started the thought process of figuring out how to use one link table multiple times in the same query. My changes worked actually, but I want to wait on this to see if I can figure out if there is already a core solution (since it seems likely that things behaving like a tree would have one table used multiple times in the same query... although they probably get around that by running 100 different queries come to think of it). abijah 2009-06-01 04:27:34 +00:00
  • 903209a47e Performed cleanup, and started the thought process of figuring out how to use one link table multiple times in the same query. My changes worked actually, but I want to wait on this to see if I can figure out if there is already a core solution (since it seems likely that things behaving like a tree would have one table used multiple times in the same query... although they probably get around that by running 100 different queries come to think of it). abijah 2009-06-01 04:27:34 +00:00
  • 68585a0b30 I've been around and around with paging. I started using the Containable behavior, which is fantastic for something like 'view', but is highly problematic for listings, especially with pagination. I discovered the Linkable behavior, and it's much more database efficient, and I actually can get it to work with pagination (except when using GROUP BY). I did have to tweak it though, to handle some of the more complex queries that I intend. This checkin includes a bunch of garbage, but given the amount of time I've spent on this crap, I'm afraid to lose anything that might later be useful information. I'll clean up on the next checkin. abijah 2009-06-01 02:36:26 +00:00
  • 23a81ae924 I've been around and around with paging. I started using the Containable behavior, which is fantastic for something like 'view', but is highly problematic for listings, especially with pagination. I discovered the Linkable behavior, and it's much more database efficient, and I actually can get it to work with pagination (except when using GROUP BY). I did have to tweak it though, to handle some of the more complex queries that I intend. This checkin includes a bunch of garbage, but given the amount of time I've spent on this crap, I'm afraid to lose anything that might later be useful information. I'll clean up on the next checkin. abijah 2009-06-01 02:36:26 +00:00
  • a9a570d666 Added some of the original formatting back into the sql log table. abijah 2009-06-01 02:11:48 +00:00
  • 9db4dd737d Added some of the original formatting back into the sql log table. abijah 2009-06-01 02:11:48 +00:00
  • 15c4b96a2a Minor tweak to the table headers abijah 2009-06-01 02:11:14 +00:00
  • 52528f1c0e Minor tweak to the table headers abijah 2009-06-01 02:11:14 +00:00
  • ce252f2e70 Changed how fields are handled, so that they are all included by default and the user is not forced to specify them. This works with paginate, but the additional fields are requested in the count query. Would like to resolve this, but it doesn't seem to be confusing paginate. abijah 2009-05-31 18:27:21 +00:00
  • 6bf06a3a3c Changed how fields are handled, so that they are all included by default and the user is not forced to specify them. This works with paginate, but the additional fields are requested in the count query. Would like to resolve this, but it doesn't seem to be confusing paginate. abijah 2009-05-31 18:27:21 +00:00
  • 4b857ff11f Testing out a possible model behavior called linkable. I may not go this route, but I'll just delete it if not. abijah 2009-05-31 17:02:41 +00:00
  • 387c1ae87b Testing out a possible model behavior called linkable. I may not go this route, but I'll just delete it if not. abijah 2009-05-31 17:02:41 +00:00
  • 6661d26c76 Getting sidemenu ready for more dynamic actions based on context. Couple minor tweaks to layout. abijah 2009-05-30 20:51:07 +00:00
  • 70812e0a0c Getting sidemenu ready for more dynamic actions based on context. Couple minor tweaks to layout. abijah 2009-05-30 20:51:07 +00:00
  • b409bf09d1 Modified table element algorithm to be cleaner and to handle multiple class types. Modified ledger listings to group the charges and associated payment rows with one color. Fixed summary balance data to come from the controller instead of being created in the view. Created an infobox to carry pertinent info in the top right of the view pages. abijah 2009-05-30 20:07:24 +00:00
  • 7fae1bcaad Modified table element algorithm to be cleaner and to handle multiple class types. Modified ledger listings to group the charges and associated payment rows with one color. Fixed summary balance data to come from the controller instead of being created in the view. Created an infobox to carry pertinent info in the top right of the view pages. abijah 2009-05-30 20:07:24 +00:00
  • b488054106 Changed how tables are layed out (since I was repeatedly duplicating code in many places) by adding a table element to be used wherever we need a table. This could probably have been a helper instead of an element, but it's not clear to me why one should be chosen over the other, and I already know how to quickly add an element (I think the real choice resides in whether you need a collection of helper functions, or you just want to drop in a chunk of html, i.e. a helper element). Also, a major revamp to the style sheets as well, although more work is clearly needed. abijah 2009-05-30 15:56:41 +00:00
  • c041174b0c Changed how tables are layed out (since I was repeatedly duplicating code in many places) by adding a table element to be used wherever we need a table. This could probably have been a helper instead of an element, but it's not clear to me why one should be chosen over the other, and I already know how to quickly add an element (I think the real choice resides in whether you need a collection of helper functions, or you just want to drop in a chunk of html, i.e. a helper element). Also, a major revamp to the style sheets as well, although more work is clearly needed. abijah 2009-05-30 15:56:41 +00:00
  • 59398cb3f0 Added comment blocks and context specific side menu link items. Also tweaked the Page titles and headings for the table listings. abijah 2009-05-29 16:01:47 +00:00
  • 2a4b8079fb Added comment blocks and context specific side menu link items. Also tweaked the Page titles and headings for the table listings. abijah 2009-05-29 16:01:47 +00:00
  • 1145d293b2 Removed unnecessary sidemenu links function, as the overriding class can just call the parent to get the standard links. abijah 2009-05-29 15:55:50 +00:00
  • 79bcf99fc5 Removed unnecessary sidemenu links function, as the overriding class can just call the parent to get the standard links. abijah 2009-05-29 15:55:50 +00:00
  • 2feb7f60a4 Minor CSS layout tweak abijah 2009-05-29 15:54:33 +00:00
  • 9d09afca35 Minor CSS layout tweak abijah 2009-05-29 15:54:33 +00:00
  • bd6cc37d4a Initial working version ofa consistent layout with side menu abijah 2009-05-29 14:49:11 +00:00
  • f384e051bf Initial working version ofa consistent layout with side menu abijah 2009-05-29 14:49:11 +00:00
  • 8dae1ccf84 Added a higher preference for horizontal unit names abijah 2009-05-29 06:57:22 +00:00
  • 2da7b6b2c0 Added a higher preference for horizontal unit names abijah 2009-05-29 06:57:22 +00:00
  • 50449205b4 The map is working quite well now, including the legend. Next steps will be to add the sidemenu. abijah 2009-05-29 05:10:46 +00:00
  • 2c85566ffc The map is working quite well now, including the legend. Next steps will be to add the sidemenu. abijah 2009-05-29 05:10:46 +00:00
  • 77c038e880 Fixed the underlying hotlink map to match the coordinates of the actual image. Also fixed a few issues with requested_width propogation, although there may still be some bugs. abijah 2009-05-29 04:37:24 +00:00
  • db03c73b59 Fixed the underlying hotlink map to match the coordinates of the actual image. Also fixed a few issues with requested_width propogation, although there may still be some bugs. abijah 2009-05-29 04:37:24 +00:00
  • 44bdb384f5 More tweaks to get the map working. At the moment, the clickable area is off because it's not scaled like the actual image is. I'll have to work on that next. abijah 2009-05-29 03:36:28 +00:00
  • 684f02ebc5 More tweaks to get the map working. At the moment, the clickable area is off because it's not scaled like the actual image is. I'll have to work on that next. abijah 2009-05-29 03:36:28 +00:00
  • 2b135b0e66 Further progress on the site map. The scale is off at the moment, but it's working well enough that it's worth a snapshot. abijah 2009-05-29 02:45:23 +00:00
  • 4e33c58246 Further progress on the site map. The scale is off at the moment, but it's working well enough that it's worth a snapshot. abijah 2009-05-29 02:45:23 +00:00
  • 23ec1b6b20 Adding mapping ability. Incomplete as of yet, but coming along nicely. abijah 2009-05-29 01:47:12 +00:00
  • 9fc5562dd8 Adding mapping ability. Incomplete as of yet, but coming along nicely. abijah 2009-05-29 01:47:12 +00:00
  • 3cc8e95ff4 Added a name for our lone map abijah 2009-05-28 23:18:20 +00:00
  • 8f4f3c054e Moved the unit status logic into the model where it belongs. abijah 2009-05-28 22:09:04 +00:00
  • 15930fae30 Moved the unit status logic into the model where it belongs. abijah 2009-05-28 22:09:04 +00:00
  • 1249854514 Added support for querying only occupied or vacant units. It's working at the moment, but I'll probably move some more logic to the controller next. abijah 2009-05-28 21:52:14 +00:00
  • dbe037fee8 Added support for querying only occupied or vacant units. It's working at the moment, but I'll probably move some more logic to the controller next. abijah 2009-05-28 21:52:14 +00:00
  • 7805e4d229 Added preliminary support for units. The queries are giving me a heck of a time, so I've cheated in some places. For the most part though, it's working. Also, something went wrong with svn, and view/contacts/view.ctp was not right (a checkin seems to have been omitted on it). This checking brings it up to date. abijah 2009-05-28 11:26:09 +00:00
  • 5c6189cdef Added preliminary support for units. The queries are giving me a heck of a time, so I've cheated in some places. For the most part though, it's working. Also, something went wrong with svn, and view/contacts/view.ctp was not right (a checkin seems to have been omitted on it). This checking brings it up to date. abijah 2009-05-28 11:26:09 +00:00
  • 4a86d3dda0 Removal of site_id from the maps table, corresponding with the last checkin abijah 2009-05-28 11:09:56 +00:00
  • ec3d986c78 Removed site_id from the maps table, since the it already references site_area_id which fully qualifies the site anyway. abijah 2009-05-28 11:09:19 +00:00
  • 54c7287ee4 Removed the revisit code, as use of it would only screw up pagination anyway. abijah 2009-05-28 09:36:58 +00:00
  • e38e99c94e Removed the revisit code, as use of it would only screw up pagination anyway. abijah 2009-05-28 09:36:58 +00:00
  • bcec2a9891 Added more models abijah 2009-05-28 09:27:29 +00:00
  • aed2c6912c Added more models abijah 2009-05-28 09:27:29 +00:00
  • e772ff8755 Fixed duplicate row entries and other paginate issues. The fix might be a hack, but it works for now. abijah 2009-05-28 09:07:53 +00:00
  • 7433e6868c Fixed duplicate row entries and other paginate issues. The fix might be a hack, but it works for now. abijah 2009-05-28 09:07:53 +00:00
  • 3288969b0d First pass at listing the customers. Need to figure out how to paginate based on a HABTM relationship. abijah 2009-05-28 08:04:22 +00:00
  • 8393403443 First pass at listing the customers. Need to figure out how to paginate based on a HABTM relationship. abijah 2009-05-28 08:04:22 +00:00
  • ed04f81dda Modified to allow the display_name to be NULL abijah 2009-05-28 08:03:12 +00:00
  • d268b6fe7e Moved the contact info into the contacts controller. abijah 2009-05-28 07:12:32 +00:00
  • 4923712238 Moved the contact info into the contacts controller. abijah 2009-05-28 07:12:32 +00:00
  • e9b31d964c Added Lease History and security deposit tracking. abijah 2009-05-28 07:05:05 +00:00
  • ffe04ed6fd Added Lease History and security deposit tracking. abijah 2009-05-28 07:05:05 +00:00
  • 0021eb1768 Changed the charge/receipt comments slightly to help clarify the intent. abijah 2009-05-28 06:42:20 +00:00
  • 0ef51ee30f Added a Financial Accounts table, for allowing transactions to be exported to financial software (definition is presently incomplete). Rearranged the table definitions a bit as well. abijah 2009-05-28 06:40:40 +00:00
  • 47d362750e Added phone and address models as well as outputing them to the view. abijah 2009-05-28 06:31:07 +00:00
  • 28bf192853 Added phone and address models as well as outputing them to the view. abijah 2009-05-28 06:31:07 +00:00
  • 47af64aefe Very, very early snapshot. Some models are working, and I have a controller for testing. Everything is subject to change. I _do_ have a working tenant ledger though, so it's worth a snapshot. abijah 2009-05-28 05:49:03 +00:00
  • df846f9963 Very, very early snapshot. Some models are working, and I have a controller for testing. Everything is subject to change. I _do_ have a working tenant ledger though, so it's worth a snapshot. abijah 2009-05-28 05:49:03 +00:00
  • 1ca704157b Adjusted database details and sitelink conversion script to go along with new schema naming convention changes abijah 2009-05-27 20:54:14 +00:00
  • f4007a0269 Adjusted database details and sitelink conversion script to go along with new schema naming convention changes abijah 2009-05-27 20:54:14 +00:00
  • 6b53d8a25a Omission bug on last checkin abijah 2009-05-27 20:52:32 +00:00
  • 76a06d1655 Further naming conventions to match CakePHP abijah 2009-05-27 20:49:54 +00:00
  • eeb8775820 Further changes to the table naming conventions to match expectations of CakePHP abijah 2009-05-27 20:32:31 +00:00
  • 2d9a85ad82 Changed table naming convention abijah 2009-05-27 20:25:00 +00:00
  • 0da1080b86 Added database schema file. For the complete revision history of schema.sql, see branches/rent_manager_20090510/db path of the 'domain' repository abijah 2009-05-27 19:47:48 +00:00
  • 2665d012c2 Added a scripts directory and the latest copy of our sitelink conversion script. For the complete revision history of sitelink2pmgr.pl, see branches/rent_manager_20090510 path of the 'domain' repository abijah 2009-05-27 19:26:04 +00:00
  • 8a3be97d41 Removed the cache files from the repository abijah 2009-05-27 19:23:05 +00:00
  • c5d5e2c651 Removed the cache files from the repository abijah 2009-05-27 19:23:05 +00:00
  • 05a4ee38f0 Fixed the stupid svn:ignore properties, which all had a trailing space (doh!) abijah 2009-05-27 04:35:43 +00:00
  • c22be388cf Fixed the stupid svn:ignore properties, which all had a trailing space (doh!) abijah 2009-05-27 04:35:43 +00:00
  • 0e68fea04b Added svn:ignore for all of the tmp directories abijah 2009-05-27 04:24:45 +00:00
  • 220284d20f Added svn:ignore for all of the tmp directories abijah 2009-05-27 04:24:45 +00:00
  • a9f47d73ba Load pmgr into branches/initial_20090526/site. abijah 2009-05-27 04:18:23 +00:00
  • 4502b73b2e Load pmgr into branches/initial_20090526/site. abijah 2009-05-27 04:18:23 +00:00
  • 5b5e478bd0 Create directories to load project into. abijah 2009-05-27 04:18:18 +00:00
  • 3251ba340d Create directories to load project into. abijah 2009-05-27 04:18:18 +00:00
  • c9f9d0867b Added branch point for initial work. The site directory will be added using the svn_import script, and will represent the output of the command 'cake bake pmgr' Abijah 2009-05-27 04:17:45 +00:00
  • d4122b207b Created directory structure Abijah 2009-05-27 04:16:20 +00:00
  • 562ffc9e4b Created directory structure Abijah 2009-05-27 04:16:20 +00:00