MVC Database Report Plattform

Dear developers, we are working on several Web-Projects. This is one is an onlinetool which has to be developed next. But we are planning a longterm relationship for many projects. We are looking for a DB-Professional with good developing skills and a well structured, clever coding style. We look for developers who use intelligent programming pattern and develope reusable software with clean, well commented sourcecode. Please comment your skill about professional tools, methodologies and techniques like •MVC •Design Patterns •SVN (Subversion) •DB Tuning (MySQL Configuration) •SQL Query Optimization Some of our upcoming projects: •Magento Shop •Online Portal (with an highly interactive frontend and high traffic expected) •Reporting and Managementsuite (another on, so not related to this project) •Customer Service Portal •Customizing a data handling tool Additionally for these Projects we also look for Interface developers (UX-Design, AJAX/jQuery, HTML), so if you have a good network here let us know. Complete Desciption: [login to view URL] ## Deliverables MVC Database Report Plattform Dear developers, we are working on several Web-Projects. This is one is an onlinetool which has to be developed next. But we are planning a longterm relationship for many projects. We are looking for a DB-Professional with good developing skills and a well structured, clever coding style. We look for developers who use intelligent programming pattern and develope reusable software with clean, well commented sourcecode. Please comment your skill about professional tools, methodologies and techniques like • MVC • Design Patterns • SVN (Subversion) • DB Tuning (MySQL Configuration) • SQL Query Optimization Some of our upcoming projects: • Magento Shop • Online Portal (with an highly interactive frontend and high traffic expected) • Reporting and Managementsuite (another on, so not related to this project) • Customer Service Portal • Customizing a data handling tool Additionally for these Projects we also look for Interface developers (UX-Design, AJAX/jQuery, HTML), so if you have a good network here let us know. Desciption and Backgrounds: I need a developer to create a highly performant and easy extendable Reportingtool. The database already exists and it is updated once a day. I will deliver some Wireframes and a desciption with examples of needed Reports and would like to discuss the possibilities to finalize the specifications. After that I need a valid estimation (So we should be sure that the specifications are detailed enough and understood you). What I actually have on my mind is a MVC Architecture where small changes can be done by an unexperienced developer from the our team. While that we can concentrate on further feature development (the project will be continued). Only a few users with use this tool, but they actually produce big queries which should be cached as much as it makes sence. It is very important to have well structured Sourcecode with detailed comments. As much it makes sense and doesn't cost lots of performance constants are stored in a central place. For example would it be prefered to have all table and column names saved in a central file, so maintenance (needed due to expected changes of some connected systems) will be easy. Additionally we want to use a translation file for storing all displayed text. Userstory for the product: I as a User want to have a password protected Interface to generate Tables from a database. The Tables will show similar data (compared to each other) which is basicially joint from two db-tables (by using some matching-db-tables). Most Table-Views are standard reports (columns are similar) with different fixed time ranges like Month, Weeks or Days and they are based on the same hierarchical data structure. So each Report can be drilled down the analyzed elements in first column (report index), so it shows the same report for the selected row only, but split by its child elements. The Standard Reports are fast (caching) and can be displayed in different Views ie. with different Columns. Cache generation can be triggered by a function after the database update has finished. The order which reports are generated first could be modified in sourcecode. Also I see a reports cache-timestamp in each report-page in frontend and I can trigger recreation. It would be great if tabledata is cached in a way it can be reused in extended reports, ie. displaying data of two cached weeks and adding a calculated column for relative difference of a column in one week compared to the other. Also I could use an existing cached report to load a customized view on that (i.e. hide columns or add a calculated column). In that way add a switch between views which use the same cached data. The page elements are loaded first and the data will be loaded by an ajax call. So while datatable is loading I can skip by changing to another page, if I want to. Additionally I want to add one column with target values to each report. These will be stored in a databasetable using an ID (the index column in the hierarchies first leve) and a month. So wthin one month these values are the same. If one report is based on a month which doesn't have any targets in db or only some IDs don't have a target-value for related month these Values will displayed as 0. If this column is created for a report with multiple month it shows the values for latest month in this report. When I drill down to a deeper level of the hierarchy it uses the target-values of it's root ID (from level 1). For some column we need to define a color-highlighting with three highlight styles: Lower, Perfect, Higher. So we can define a range when it will get which highlighting style... ie: < -0,03 from column "x" = Low -0,03 to +0,03 from column "x" = Perfect > +0,03 from column "x" = High Maybe this can be easily set by giving a style and the upper and lower bound like "setHighlightingStyle(-0,03,0,03)" Report-Types: Following Reporttypes can be defined easily for views: 1. Aggregationtypes (Example: Reportdata for the Month January) 1. Time Series which are cummulated in defined intervals (ie. by week shows data aggregated by whole weeks, like week 1,week 2 week 3, week 4. Other ranges: day, week ,month, 3 month, 6 month, year). --> like a group by statement. 2. Cummulated Data for a timerange (Every selected datacolumn will be cummulated for the whole month --> could be realized as type Time Series with interval=Daterange, in this Example it would be "monthy" as interval --> it will aggregate the whole month in one column-set) 2. Time Range definition 1. Fixed Time Ranges can be set to have static reports where time frame won't change every day. ie. the data for last week would be always from monday till sunday from the last week. 2. Rolling time frame: This means to define a report whose time range is defined relative to the current date, i.e. past 3-days will show different data each day we load this report because the time frame is defined as the three days which have past before the current date. In this reporttype caching would take too much ressources, if we have a lot of them, right? 3. Compare two time ranges with calculation of changed data (for defined columns). ie. the question "how did revenue change from the day before yesterday to yesterday:" could be answered in a column which shows values like "+2,12%" for each row. Initial Reports the Tool needs: ________________________________________ Basic: Month Report Time Range: Month Aggregationtype/Interval: Cummulated/Month Time Range Definition: Fixed Compared: no Week Report Time Range: Week Aggregationtype/Interval: Cummulated/Month Time Range Definition: Fixed Compared: no Day Report Time Range: Week Aggregationtype/Interval: Cummulated/Month Time Range Definition: Fixed Compared: no Important: These three Reports probably could be created easily as one report which just has another Date set as url-parameter. Maybe also the special reports (following) can be also realized by using some configuration parameters? So the Navigation mostly uses defined urls without its own report file needed. Special Reports: Past days Time Range: 3 days (easily configurable to 4 or 5) Aggregationtype/Interval: Interval/Day Time Range Definition: Rolling Compared: ??? + additionally show cummulation of these days Custom Range Report Time Range: Custom Aggregationtype/Interval: Cummulated/Month Time Range Definition: Fixed Compared: no Dashboard Created from existing other reports by using the current Month as Month Report and the current Day as Day Report. Best Regards Dirk Solbach DigitalSpring ds@[login to view URL]