Order app helps me to create and send orders in excel files to its producers.
I run small grocery shop. Every day I fill (create) excel files and send them to food manufacturers to order some goods. Further I will use SCU term, when talking about goods. In the shop I use 1C program with its own database and configurations. However, this program was designed and created in 90's and for large companies. So with python and Django I decided to automate some processes in my daily work.
In my db I use 8 main models for data and several help models (forms, tables etc.).
On main page app has two buttons, navbar navigation links and 1c connection label. When label is green - connection to 1C db is active.
Connection. Connection to 1C db created via OData and Apache. 1C and Apache are installed on the same computer. Details_1_eng, Details_2_rus, Details_3_rus.
Producers' page has button 'Update vendors' via which it is possible to check 1C db for new producers. After button, we can see how many producers saved in apps db. Then forms with buttons where located clean files from manufacturers and ready to send files. Below that there is jsGrid responsive table to see and modify data about producers. To start work with producer I put tick, save min sum for order, email to send order files, files to fill from producers (if needed), column with barcodes in those files from producers and column to write data order.
ABC page. Form with buttons to choose dates. Then via OData request, we get sales for a specified period. After that we calculate ABC classes for SCU and save that information to db.
Sheet page. List of SCU with sales and stock data with ABC classes. Only for information purpose.
Insurance reserves. jsGrid table with list of SCU grouped hierarchically, SCU's ABC class and data about insurance reserves, max order, multiplicity and max stock. I use this data to calculate order for every SCU. Formula to calculate: order = SCU_Expense + safe_stock - SCU_ClosingBalance. If the order must be multiple: order = ((order // multipl) + 1 ) * multipl.
1C settings. Form with settings to connect to 1C db.
Data management. Buttons for data control. Load and delete folders, SCU, barcodes, prices.
Order page. Page has only list of buttons for producers, which are active and work with my shop. When some button clicked, order is calculating and creating (or filling) excel files
