point well taken, I should not have past in all the vb code. But it could be of use for someone, as to research there is no open source out there that will do what my current spreadsheet is doing. So, my questions was directed towards CakePHP flexibility of being used for resoruce scheduling.
And as always there is always an undertone to replies to question posted, are there a Google group for CakePHP beginners, no one needs to reply. Right! On Sep 22, 5:37 pm, "Wayne Fay" <[EMAIL PROTECTED]> wrote: > I think you're going to get a much better response with a 5-10 line > pseudo code example than the nearly 200 line VB code you've included > below. Personally, I wouldn't even consider looking at something like > that unless someone is paying me cold hard cash. > > As for the "calculate the week" issue, did you search the PHP Manual > or ask Google? It is pretty obvious:http://us2.php.net/date > (Hint: search for the word "week", you're bound to find it.) > > As for "should you be doing this" -- you might want to consider some > open source resource scheduling software before deciding that you must > build it yourself. Only after a formal review of a few with the > conclusion "we must write our own from scratch" would I consider > heading down this path, personally. > > Wayne > > On Mon, Sep 22, 2008 at 11:06 AM, torbjorn <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I thought I seek feedback from this group on what would be the best > > direction creating reporting in CakePHP. > > > My project that I am working on, is to take resource scheduling excel > > spreadsheet and move it over to a database, the reason to this is that > > the spreadsheet has grown to big, and excel is prone to user entry > > mistakes. We have minimized the number of features that we would like > > to have initially, to only a handful, to make it in par with the excel > > spreadsheet functionality. > > > 1. User to login to view their assignments > > 2. Resource Manager to have a login to be able to do the following > > 2.1 Load project resource request from an Excel Spreadsheet > > 2.2 Assign resources to projects > > 2.3 View resources availability > > 2.4 View resources Utilization > > 2.5 Basic Reporting > > > We been looking at different ways to do this, and decide to settle on > > using cakePHP, the team has created the authentication and a menu > > system that shows menu items based on users type. We have created the > > database structure so we can load project request and assign resources > > and store them in a utilization database table. > > > But we run in to a snag in the design in creating the resource > > utilization, the team are split on how we should approach it, so we > > asking the group for some advice. The ideas we have are: > > > Option 1. create a database table that are generated at the time off > > assigning resources, the table would hold the user_id, date, year, > > month, day, day of week, month_name, quarter, quarter_name and > > allocation percentage. The only problem we see with this is that user > > could be on more than one project in a week. So, when a resource > > manager assign a resource, we would have to search to see if a record > > exist for that week and then update it, if not existing week add a new > > record. > > > Option 2. use a "Star Schema" for dimension and facts. The "Star > > Schema" tables would be updated by a function that is triggered by the > > resource manager. The resource manager selects a function update > > allocation, which would start of a process of reading records from the > > utilization table, and loop around tills all weeks are filled in. The > > "star table" would have three tables ResourceDimensions, TimeDimension > > and AllocationFacts. I personal think this is the right approach, but > > has a few learning curves for us. When it is triggered, it should loop > > around the user table, if a user do not have an allocation it would > > show 100% available, if a user have many allocation for a week, it has > > to be summed up, and stored. The issue is the utilization data, we > > have start and end date and an allocation, so if the start is 3 feb, > > 08 and end is 3 march 08, with the allocation 10%. The user would be > > allocated for 10% over that period of time, but how do we use date > > function is CakePHP to know what week it is. are there any samples. > > > Our Excel Spreadsheet has this VB Macro doing the job, instead of > > saving it to a database, it saves it to a row/column, > > > - Have anyone tried to do this in the past, like to learn about the > > experience and any pitfalls. > > - Is CakePHP suitable for doing "Star Schema" and/or for being the > > framework for a resource scheduling tool? > > - How would be the best way using the macro functions below, have a > > component that runs through, with a model that reads the database and > > write to the database and a view that shows when completed, any ideas? > > > ============================= sample VB Macro code --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
