RunaBase
Administrator
Project for LLC "AUTOLAND" (auto parts to order), Salekhard, Russia.
Requirement: database of orders with customers, printing an order form.
Project development time: about 2 hours.
Primary objects:
- Spare part: contains the name, vendor code and price;
- Client: name, phone, car brand/ model, VIN code and notes;
- Order: item No., date / time, status (created, in operation, issued), customer, order amount, payment amount, debt and notes;
- Order list: spare part, copy of the vendor code, count, price, sum;
- Order payment: date, amount.
In the order list object, the price field is copied from the object: "When changed ... Field " property contains [Spare part.Price], so that when selecting a spare part from the reference list, its price is automatically substituted:
![Order item.png](/forum/data/attachments/0/42-9465102e63b441583597462c60a6354e.jpg)
To combine an order with the spare parts list and payments, use the Link form. The form was created on the basis of the order object and two child sublists were added to it: spare parts list and payment list. The objects of order, order list and payment for the order are hidden.
![Child Lists on the Order Form.png](/forum/data/attachments/0/44-e9691558ba81dffa43e0c131fcb89774.jpg)
After adding child lists to the form, you can specify a summation for the fields of the order amount and payment.
![Defining Summation from Child Lists.png](/forum/data/attachments/0/45-b3d7c1ea469aea775e68c93e503fa063.jpg)
For the order status, icons with the same name were added to the project images: created.png, in operation.png, issued.png. The display style for the status is set to "images".
![Setting patterns for the switch box.png](/forum/data/attachments/0/47-7372dc7b167720572b7ec30cda37872c.jpg)
Orders that have outstanding payments are highlighted in red in the list, as well as a row with the amount owed in the details. To do this, the paint field with the condition [Debt]>0 and the group field with the same condition are added to the order object, and the group field is assigned to the debt field.
![Group field for specifying color in detail.png](/forum/data/attachments/0/49-92fd9f53d7d8e786ae4bbff42ca156f2.jpg)
This completes the creation of the database structure.
The "Orders" form creates a document template based on MS Word:
Then it is converted to the desired sample for printing:
![Ready-made document template.png](/forum/data/attachments/0/51-ccc0b621274e09f0ee4af692b99eb88f.jpg)
Open orders in the left menu of the project, create an order entry, add spare parts to the order, and add the received amount to the payment list.
Getting a record without debt:
If you create a record with spare parts and without payment (or not full payment), the debt field will be highlighted in red:
![Debt order record.png](/forum/data/attachments/0/53-1656e266d579e09b1a7f7c6a740786c6.jpg)
We form the document based on the entry in the order by clicking on the "Documents" button and selecting the desired template:
![Creating a document based on a prepared template.png](/forum/data/attachments/0/54-cb241aa5bd51b9261f55b5ef2b4ebac5.jpg)
Result:
![Print Order Document.png](/forum/data/attachments/0/55-06f8837f0b94247ff79615e7f6bddfea.jpg)
Requirement: database of orders with customers, printing an order form.
Project development time: about 2 hours.
Primary objects:
- Spare part: contains the name, vendor code and price;
- Client: name, phone, car brand/ model, VIN code and notes;
- Order: item No., date / time, status (created, in operation, issued), customer, order amount, payment amount, debt and notes;
- Order list: spare part, copy of the vendor code, count, price, sum;
- Order payment: date, amount.
In the order list object, the price field is copied from the object: "When changed ... Field " property contains [Spare part.Price], so that when selecting a spare part from the reference list, its price is automatically substituted:
![Order item.png](/forum/data/attachments/0/42-9465102e63b441583597462c60a6354e.jpg)
To combine an order with the spare parts list and payments, use the Link form. The form was created on the basis of the order object and two child sublists were added to it: spare parts list and payment list. The objects of order, order list and payment for the order are hidden.
![Object-based order form.png](/forum/data/attachments/0/43-4bfcc3bb26be8de03c2bb83a80faa25d.jpg)
![Child Lists on the Order Form.png](/forum/data/attachments/0/44-e9691558ba81dffa43e0c131fcb89774.jpg)
After adding child lists to the form, you can specify a summation for the fields of the order amount and payment.
![Defining Summation from Child Lists.png](/forum/data/attachments/0/45-b3d7c1ea469aea775e68c93e503fa063.jpg)
For the order status, icons with the same name were added to the project images: created.png, in operation.png, issued.png. The display style for the status is set to "images".
![Images in project resources for order status field.png](/forum/data/attachments/0/46-a0626c20008df135469b7e79a777bd62.jpg)
![Setting patterns for the switch box.png](/forum/data/attachments/0/47-7372dc7b167720572b7ec30cda37872c.jpg)
Orders that have outstanding payments are highlighted in red in the list, as well as a row with the amount owed in the details. To do this, the paint field with the condition [Debt]>0 and the group field with the same condition are added to the order object, and the group field is assigned to the debt field.
![Paint box to set the color in the list.png](/forum/data/attachments/0/48-2a3b436b1a42b82b2a9db3a34f05fadf.jpg)
![Group field for specifying color in detail.png](/forum/data/attachments/0/49-92fd9f53d7d8e786ae4bbff42ca156f2.jpg)
This completes the creation of the database structure.
The "Orders" form creates a document template based on MS Word:
![Initial document template.png](/forum/data/attachments/0/50-2c577f6e0616597635681b9bdf4df718.jpg)
Then it is converted to the desired sample for printing:
![Ready-made document template.png](/forum/data/attachments/0/51-ccc0b621274e09f0ee4af692b99eb88f.jpg)
Open orders in the left menu of the project, create an order entry, add spare parts to the order, and add the received amount to the payment list.
Getting a record without debt:
![Entering data on the order form.png](/forum/data/attachments/0/52-347b3cde84d3202fc532b282ff68452b.jpg)
If you create a record with spare parts and without payment (or not full payment), the debt field will be highlighted in red:
![Debt order record.png](/forum/data/attachments/0/53-1656e266d579e09b1a7f7c6a740786c6.jpg)
We form the document based on the entry in the order by clicking on the "Documents" button and selecting the desired template:
![Creating a document based on a prepared template.png](/forum/data/attachments/0/54-cb241aa5bd51b9261f55b5ef2b4ebac5.jpg)
Result:
![Print Order Document.png](/forum/data/attachments/0/55-06f8837f0b94247ff79615e7f6bddfea.jpg)
Attachments
-
19.8 KB Views: 52
Last edited: