The White Room

Tried to fix JS but failed and then just removed all JavaScript code from the template and going to work on a different project to increase my JavaScript power level

Added auto calculate details per 100g if serving unit is grams.

However when editing items it only works for the first item so I need to fix that, also the same issue with the serving units dropdown. JavaScript needs updating

Updated inventory to make it not show servings if there is 0 servings but now I realise that if you have 0 servings in your inventory that means you have none, so now items that are updated to have 0 servings are deleted from your inventory

rearranged add product and edit product forms to have serving first so that I can next implement automatically calculate calories and macros per 100g if serving size is grams, 50 Hours milestone

-Added more heading subtext to explain what each heading does and

-Made serving unit a dropdown with an option for other (and gram(s) and unit(s) and if it is other it adds a text box to enter a custom unit, this is so it knows when you used grams and all grams products have the same serving unit (the user might put g/gram/grams but all should be under one serving unit this way that does happen)

In the last devlog I forgot to mention I changed some headings (Add item template -> Save product), simpler to understand.

Fixed no store name yet to show unspecified instead of not having a heading.

Refactored some code and implemented Shopping List feature in full with quantity of that item the user prefers to purchase and display a total cost to by groceries at each store. WE ARE BACK IN BUSINESS (bug: if no name is set it should show unspecified but it shows no heading) GN!

Update read me to add a lot of to dos, now I can move on to refactoring my code

Updated edit food form to prefill values and to fix a spelling error.
README.md progress

Refactored code and removed some code the shopping list feature no longer works.

Worked on README to add some currently implemented features and some to be added features so that I know what I should be doing next after each feature is complete.

Also installed WakaTime extension for Figma to start planning how the pages will look I'll do this after all the backend features are finished and all the page elements are already on the front end

Plan:
- Finish updating README.md to be extremely detailed feature list and planned feature list
- Final code refactor
- Start implementing all the features in the readme
- Once done, start working in Figma to make every page's completed designs
- Implement CSS and update HTML in a way that different stylesheets can be added then start just working through every feature in order
- Share program with Slack #the-white-room to get feedback for changes or different stylesheets
- Update program
- Ship

Added a planned quantity to purchase and made it so that shopping list is seperated by store name and total cost for buying the shopping list is calculated, however the form to update quantity doesn't work yet

I used some AI for the features in this devlog but I am not happy with the outcome, I am going to remove a lot of code tomorrow and then re implement these same features, using AI kills the joy of programming this project for me and made me restart it last time when i tried making it in electron I'm going to make sure all my code is commented and i'm going to research software development methodologies and project management instead of a todo.md and doing random stuff using AI i'm going to make a proper plan for this project and do it right and end up with a high quality code base that supports hacking (modifications by the user to make it work how they want it to work) as it will be easy to understand thanks to the comments.

TODO you don't have to read this part:

remove slop code, research software development methodologies and project planning methods, pick my methods, read all my code again and comment it and actually understand it the make my plan and just start following the plan

Made it so that price per serving is calculated automatically is price per item and servings per item is available and save it rounded to 2 decimal places (like money) and display it in shopping list if items are out of stock

Fixed logic error where some rows in DB weren't being deleted and it was affecting/effecting which locations were displayed as having items even though there was no items a h3 was shown with a location name.

Update the shopping list item templating loop to fix it showing purchase location even if it wasn't said refer to 3 examples in image

Updated the kitchen inventory to add support for price per item (like one barcode scan at the shop) and servings per item (how many servings you get when you buy pay for one item) and this can also be used to calculate price per serving to fill it in for you but it doesn't do that yet, I also added it to show these two pieces of data if the item template is in your shopping list and what store you buy it from (as well as it's name) and I want to do this to add shopping lists to be sorted by store name and then show the total bill per store to buy all those items and the total for all stores, in the future this could also allow a feature which allows you to plan recipes in advance which will be able to calculate total cost for groceries and eaten calories and macros in advance

did a lot of other stuff, i should've been adding more dev logs because I don't remember everything but I removed some css to make it more minimal again even though it isn't dark mode anymore but that makes more sense since it is called the WHITE room after all, I also made my code more organised and neater and added comments to make it easier to hide indented sections when i'm not working on them so I can easily find code, I also tried to implement something but then removed all of it's code and am going to try again later

im going to add all these ideas to the TODO.md file now

I added the shopping list feature as well as price per item and servings per item as most products contain multiple servings, and the user wants to know that more as that is what they will see in the store. Trying macOS and ungoogled-chromium (and using VSCodium instead of VSCode)

Added temporary CSS for items that are expired and to make tools a different colour and corrected the order that items are sorted by to make it ingredients with the oldest use by date's first and then tools also sorted by use by date so tools are at the end.

Added location to items that exist so you know where to find them and displayed them by location and add location to edit and add item to inventory forms and backend code to make it actually save and fetch data from the database.

Added edit inventory item button
Added delete inventory item button
Fixed add item to inventory form to allow serving size to be a float (1dp)

Fixed edit food form in food diary page, and also the totals widget to make progress bars hidden if the user doesn't have a goal for them.

Just renamed secret.md to TODO.md and it's icon changed in VSCode that's cool
Edited TODO.md a bit, now its bed time though

Added music to Food Diary and Inventory page
Added music to Tasks page, it's otherwise empty
Added edit item template and delete item template forms and buttons that work with code in backend to execute the SQLite commands for them

not shown in video: delete item template button, it does work

Removed a comment for an error I fixed before
Added some temporary CSS dark mode for evening/night time development.
Work on secret.md (planning and todo), figured out what's missing from Kitchen Inventory page (apart from CSS)

Added buttons to toggle the two forms on the Kitchen Inventory page and make them hidden by default

Made it so that food items show up first in the current inventory list
made it so that tools shows with a different background colour
Made the start of a readme.md file
updated to do lists and added some comments

Wrote some planned future features for food diary in secret.md and cleaned it up a bit it helps keep me organised,
then I updated the schema and started adding the route for /food/inventory and it's template which now contains the form to add item templates as well as instances of items to inventory,
and display a list of items in inventory and their number of servings and useby date if it has one
I also changed three icons to different placeholders

I need to add way more stuff

Added quantity input for form that works in back end to and it makes you round to 1 decimal place. This is so perfect!

I think food diary is almost done I will try to brain storm any missing ideas for later but start work on the kitchen inventory system for now since some of it's features are prerequisites for food diary's advanced features.

Added the delete meal and edit meal buttons and made them work in backend too.

Pure white beauty, it works. You can now edit and delete added foods. I just need to add edit and delete buttons to the meals to change their name or if more than one meal exists to delete meals, and a quantity input when adding a food, so you can input the values of one egg for example but then put quantity 3 to save the values for 3 eggs

Water tracker works now and I think I did other stuff too but I don't remember
good night
To-do:
-buttons to edit and delete meals and food entries,
-quantity button when adding food to multiply inputs,

The widget showing the totals works
The add meal button works
The add food button works
The program correctly calculates and displays the total calories and macros and water

I just need a way to:
-add and subtract from the daily water value,
-buttons to edit and delete meals and food entries,
-quantity button when adding food to multiply inputs,

Hid the three buttons that don't do anything yet.
Brang back progress bars widget but now it uses the user's actual data for water need to add the backend code for calories and macros.
Added a lot of backend code added to get data and pass it to the food diary front end.
Updated db schema.

Removed old dev logs from planning stage and trying mid-lectron and mid-ri (tauri) and trying to do it all in a single html file (sadly not possible unless I use IndexedDB instead of SQLite, in which case it won't be portable whereas now you can just copy and paste the database.db to a new device or to back up the file)

The add meal button works now but the add food doesn't do anything yet
Now I will make the add food button show a form and then make it save to db

The back end now passes the meal names to the front end and shows them in a div with id = their mealID. (passed to front end: todaysMealIDs, todaysMealNames, allEatenFoods)
Now I need to:
- Make the add meal button save a new meal to database and reload the page
- Add an Add Food button and form that saves the eaten food to database under the correct meal ID and then reload the page
- Show eaten foods under the correct meal name
- Fix the widget that is currently hidden so that it uses the database values to calculate the progress bars for calories and macros and water

Finished the back end code to get the required data from the database but now I need to update the front end to have forms to upload and remove from db and then back end to save the data in front end forms.

Update the progress bars, they will now show how much you've had and if you have a target set it will also show a progress bar. Currently no CSS and it doesn't read from the database it is just a dictionary with imaginary values.

Updated setup page and settings page to add new inputs and to make the settings page to allow you to change your initial inputs from the setup page which opened the first time you opened the app.

Updated backend database creation code as well as added a new settings button in the frontend, it has the same placeholder image as the other hyperlinks in the dashboard page.

Finished planning and then adding the tables into SQL.
Added placeholder images for dashboard icons.
I just need to add the forms in frontend and then add backend code to save submitted data from those forms to the correct tables.

(schema in image is wrong)

Figured out what to do next:
finish updating the init db function to add the new tables after I finish planning the schema,
then add the forms to input the values to them,
then make a function that stores all relevant data from db in a dictionary so I can easily pass it to the html template

For this devlog I added some progress bars and passes the calorie values for the bar as a dictionary from python, I commented the other bars for macros.

Added this minimal css and in the backend trying to add more tables to the database but struggling, I'm going to plan the schema in markdown and then implement it today

Making very good progress with flask. I have added a base template html, a login page which saves the user name to the database as well as a dashboard page which has 10 image hyperlinks that will be app icons for the 10 planned features currently no icons have been made. As shown in the video there is also logic to make sure the user doesn't add extra user's to the database and redirects to the dashboard if they have already completed setup. I should've used flask from the start