Jump to content


Photo

Simple Cakephp App To Manage Expenses With Recurring Expenses

cakephp recurring records

  • Please log in to reply
No replies to this topic

#1 malaiko

malaiko

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 21 November 2012 - 10:13 AM

Hi phpFreaks!
I'm starting to learn CakePHP, and for it i decided to build a simple app, and i want your advice.

I want to create a simple system to manage my savings and my expenses.

I have not done anything, I'm at the stage of designing the database.
The problem is that I want to enter an expense and have the option to repeat this expense (month to month /year to year / etc).

I was thinking about doing something like this:

Table Types (id_type, str_type)
Table Categories (id_Categories, str_Categories)
Table Records (id_Record, id_type, id_Categories, value, situation (paid / unpaid), date)

Now if for example if i add an expense that will be repeated 3 in 3 months, I did not want to save in the database the repeated records because the repeated records dont have a end date to stop repeat.
And for example in 3rd month I want to change the value of this expense, I wanted to have several opinions(change the value only in the current month, change the value for all the next repeat records or change the value in all repeat records).

I thought creating an auxiliary table:
Record_Repeat (id_recRep, id_record, repeat (yes / no), repeat_value)

In the App, when you see the a month first is shown if are repeated records and the situation is unpaid, then records of the table records. Only when the Records.situation changes to "Paid" or i edit the value this record is saved into the database.

I make myself clear?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com