I'm building a small intranet for the small business I work for and am having some issues with one of the applications. I'm forced to host on windows, as much as I hate this it is fine as I worked in a predominantly IIS/MS SQL server shop for 7 years.
My stack is windows, IIS, php, mongodb. Was thinking about using expressjs, but whatever...
The problems are mainly with how to setup the db and programmatically insert and display the results within the grid I have set up.. Approach, essentially: Rows are users. Columns are days of the week and a total for the week. CRUD operations aren't a problem -tmestamping is an issue as a few records will be inserted after midnight. -Should I make different tables(I think there called documents in mongodb) for each week? -am I really just overthinking this?
My background was in systems/network administration, I can script backups of several dozen servers without a problem but webdev is somewhat foreign to me.