Car Catalog Project
The Car Catalog sample project is developed to demonstrate Valentina Forms features such as:
- Table and form-like data layouts
- Valentina Report generation and presenting it inside the form
- Exporting report to file on disk
- Viewing report in the browser
- Sending report in an email
- Creating custom form preferences
- Use of utility and startup scripts
- Use of Image and Image - Field controls
Archives
Car Catalog project with an accompanying database is available for download within the Valentina Studio as Cloud Example.
Links for direct download (manually downloaded files must be uncompressed into vsp and vdb folders respectively, e.g. /car_catalogs/vsp /car_catalogs/vdb):
Overview
Created objects are separated into three different folders: Forms, Reports and Scripts.
Forms
See a short description of each created form and key features used in the form. Feel free to copy the code or use it as a basis for building your own solutions.
| Name | Description | Used Features | Preview |
|---|---|---|---|
| car_list | Presents a list of all cars in the catalog along with their main details. Buttons on the toolbar allow adding a new record, deleting, editing in a separate form and opening a preview of the catalog. Double-click opens a record for editing, too. | TableView control, editing triggers, form import, user-defined methods |  |
| add_car | Dialog to add a new car to the catalog. A picture can be loaded into an Image control either with a button click or a double click | Form layout, event filtering |  |
| edit_car | Dialog to edit an existing car with the ability to navigate through records. It has a button to open a preview of report containing details of the current car. A picture can be loaded into an Image control either with a button click or a double click | Form layout, form import, event filtering, user-defined methods |  |
| preview_report | This form is used by other forms to show the preview of the report with specified parameters. It has controls to navigate through the report pages, print on printer, open in a browser, save as PDF file or send it in an email. Also, it allows the user to open email_settings form to adjust settings used to send reports. | VReport, Image control, script import |  |
| email_settings | This form allows the user to adjust SMTP server settings used to send a report in an email. These settings are persistent and stored separately near the Valentina Studio own preferences | Form layout, QSettings class |  |
Scripts
The following table contains a short description of each created script and key features used:
| Name | Description | Used Features |
|---|---|---|
| base64 | Contains utility function to encode binary data (such as PDF report) in Base64 ready to attach to an email using __MAIL VSQL function | ArrayBuffer, Uint8Array |
| startup | Script automatically executed at the project opening | Project startup, form import |
Reports
In the table below you can see a short description of reports created for use in conjunction with forms:
| Name | Description | Preview |
|---|---|---|
| report_cars | Contains all cars in catalog in two columns with left-to-right column layout |  |
| report_car | Contains the details of one specified car |  |