C++, Qt Creator, Sqlite database - intermediate level course

design a layout for a new vehicle window. remove the status bar, set height 900, apply font size 12 bold italic, and set title add new vehicle with an icon.

Continue building the add vehicle window in Qt Creator by configuring labels, line edits, comboboxes, and push buttons, including upload picture, setting fonts, colors, alignments, and a bottom spacer.

Create placeholder texts for vehicle name, manufacturer, construction year, km stood, number of pieces, and price; set euro and dollar options; name widgets with underscores in a resizable window.

Declare pointer variables for label, line edit, combo box, and push button in add new vehicle.h, copying names from the UI file to prevent spelling mistakes.

display a picture in a label by setting the pixmap from the resources folder during the label's creation, scaling it to 600 by 600, to show the new window.

Create an upload vehicle picture pushbutton function by wiring a file dialog, storing the selected path, converting it to a QPixmap, and displaying it in the vehicle picture label.

Create a save button function that collects line edit and combo box input, saves values as string, int, and double, and stores a vehicle picture as QByteArray in SQLite.

Extract input from line edits and the combo box, convert to strings, a double, and an int, and store them in variables for later use in the sqlite workflow.

Validate inputs from line edits and combo boxes, show a critical message if fields are empty, then insert data into the SQLite vehicle table; next lesson creates the table.

Create a vehicle table in a SQLite database, define id, name, manufacturer, and other columns, and set default availability.

Create and save a vehicle record to sqlite using Qt Creator, employing a parameterized insert with QSqlQuery, binding line edits, a combo box, and a picture byte array.

Implement push button home page functionality by closing the current window, adding a new vehicle, and displaying the main window, using a new vehicle UI and a dedicated slot.

Create a new vehicle table class to fetch and display all records from the vehicle table in a table view, and add a main window menu item and toolbar icon.

Create click functions for the new menu item and toolbar icon in Qt Creator to close the main window and display the vehicle table window by instantiating a VehicleTable object.

Create a vehicle table window layout in Qt Creator by setting window size to 1600 by 900, font size 12 bold italic, window title with a tooltip, and resource icon.

Finish vehicle table layout in Qt Creator by setting description label to 35 bold italic and centered, using a model-based table view with read-only, alternating colors, and a 157 width.

Retrieve records from vehicle table and display them in the table view using a Qt SQL model, with headers for id, name, manufacturer, construction year, kilometers, condition, price, and availability.

Include vehicle_table.h, create a vt to a new vehicle_table, close the add window after saving, and display the updated vehicle table.

Select a row to fetch the vehicle id, query related data from sqlite, display editable fields and its picture, then upload, save, update, or delete the vehicle.

Create an update layout in table.ui by labeling and resizing fields, duplicating labels and line edits for vehicle attributes, and adding push buttons for upload, save, update, delete, and home.

Build an update layout in this intermediate C++ Qt Creator course that centers a vehicle picture, labels it underscore picture, styles fonts and colors, and enables resizable widgets.

Continue building the vehicle data layout in Qt Creator, set the vehicle id to read-only, and implement clear functionality for line edits and push buttons for SQLite management.

Declare widget pointers in the header for the vehicle table, copying names from the UI to avoid spelling mistakes and ensure proper widget linkage in a Qt C++ project.

Implement a single-click handler for the vehicle table view to extract the vehicle ID from index zero and store it in a public string variable vehicle_id.

Click a vehicle in the table view to retrieve its id and fill line edits with id, name, manufacturer, construction year, kilometres, condition, price, currency, and availability via SQL query.

Finish implementing the tableview vehicle click function converting a q byte array to a q pixmap and displaying it in a 600 by 600 label, formatting kilometer stood and price.

Create a push button to upload a vehicle picture in a Qt C++ app, wire UI slots, reuse a global picture path, and display the image in a label.

Implement a pushbutton click to update the selected vehicle's picture by reading the image, converting to a byte array, updating the sqlite database with a prepared query, and showing feedback.

Implement a pushbutton update to modify only the selected vehicle's data by id in the database, using line edits for name, manufacturer, year, km, condition, pcs, price, currency, and availability.

Update the selected vehicle's data in the vehicle table using a prepared SQL update with bound values for name, manufacturer, construction year, kilometre, condition, price, currency, and availability.

Finish the pushbutton update by closing the vehicle table window, displaying the main window, and refreshing the vehicle data to reflect changes in year, construction, and currency.

Implement a delete confirmation for a push button by displaying a yes/no message box asking 'are you sure? do you really want to delete this vehicle?' with title and icon.

Implement a push button delete flow in a Qt Creator C++ app using a prepared SQL delete from vehicle where vehicle_id equals the selected id, with a confirmation message box.

Create a new seller window by adding a menu item and toolbar icon in the main window, then wire slots to close the main window and open the seller form.

Create add new seller window by duplicating add new vehicle UI, set height to 900, font size 12 bold italic, and update labels to seller name, phone, email, and address.

Set up add seller window UI with a label, line edits for name, phone, email, address, and push buttons for upload and home page; declare widget pointers in the header.

Display a picture in the label_picture from resources/picture/new-arrival and scale it to 300x300, then create a seller table in SQLite with id, name, phone, email, address, and picture blob.

Create a push button to upload a seller picture by wiring a global picture path, updating the user interface, and using qfiledialog to resize the image to 300 by 300.

Create the pushbutton save function by updating the dialog title. Upload seller picture, read image, convert to QByteArray, save to the seller table, and validate inputs.

Prepare a QSqlQuery to insert into the seller table with first name, phone, email, address, and picture, binding values and executing the query.

Create a click function for the home page push button to close the add new seller window and display the main window.

Create a new window for the seller table in a Qt Creator project by adding a seller table class, menu item, and toolbar icon with click slots and UI updates.

Create seller table window layout by configuring seller table.ui, setting a 1600 by 900 window, bold italic font size 12, and adding seller table title, tooltip, and icon from resources.

Demonstrates creating a seller table window layout in a C++ Qt Creator project by editing the UI file, renaming elements, removing unused widgets, and configuring action buttons.

Finish creating the seller table window layout by configuring the table view, labels, line edits, and push buttons, and define widget pointers in the header file.

Display seller records from the SQLite database in a table view using a queue sql query model, with id, name, phone, email, and address, and set headers and column widths.

Close the add new seller window, display the seller table window, and save the new seller data in a cpp file using a seller_table pointer.

Declare a public string seller_ID outside the class; on left-click, capture index 0 data, convert to string, and display selected seller ID: <value> in the UI label.

Click a row in the table view to fetch the seller id, query the sqlite database for id, name, phone, email, address, and picture, then populate the ui.

Create a push button function to upload a seller picture in a Qt C++ app, using QFileDialog and displaying the selected image in a label.

Create a push button function to update a seller's picture by reading the file path, converting to QByteArray, and updating via a prepared QSqlQuery, with success or error messages.

Create third button to update seller data by reading name, phone, email, and address from line edits (ID remains read-only), then run a prepared update query and refresh main window.

Implement push button delete seller data by reusing vehicle data deletion logic and confirm with Are you sure? before deleting in the UI and database.

Create a push button action that closes the seller table window and shows the main home page, using the ui file and the show slot.

Create an add new customer dialog in Qt Creator, add a menu item and toolbar icon with a resource image, wire slots, and display the window from the main view.

Create the add new customer window layout in a Qt Creator project, set window height and font, add a title and icon, and apply style sheet colors.

Continue building the add new customer window layout in Qt Creator by resizing and rearranging widgets, updating labels and placeholders, naming controls, and preparing for header file integration.

Finish creating the add new customer window layout by declaring label, line edit, and push button pointers in the header and mapping UI names, then save changes.

Create a customer table in SQLite by opening the project database, adding id (integer not null primary key autoincrement) and text fields for name, phone, email, and address, then save.

Display a pixmap in a label from resources, then wire a save button to collect name, phone, email, and address from line edits and validate input with an error dialog.

Finish pushbutton save function by inserting a customer into sqlite database with a prepared insert for name, phone, email, and address, binding line edits and showing success or error messages.

Implement a click function for the home page push button in a C++ Qt Creator app to close the add new customer window and show the main window.

Create a new customer_table class to display customer data in a table view, and wire a main window menu item and toolbar icon to open it with a click function.

Create a customer table window layout by editing the UI file, removing the status bar, and setting size to 1600 by 900, title, tooltip, icon, and gradient background.

Continue building the customer table window by cloning the seller table layout in Qt Creator, removing the picture label and upload buttons, and resizing controls for a clean tabular layout.

Refine the customer table window layout by updating labels and buttons, standardizing id, name, phone, email, and address line edits, and adding a widget name pointer in the h file.

Add ui component pointers in the customer table header, including QLabel, QLineEdit, and QPushButton, and map their names from the UI to the h file to finish the window layout.

Initialize a QTableView pointer, read the widget name from the ui file, and display customer data by querying the customer table with QSqlQueryModel, selecting id, name, phone, email, and address.

Create a click function for the customer table view, insert a new customer on message box confirmation, close the add new customer window, and display the updated customer table.

Create a click function for the customer table view to read the first column, store the id in a public string, and display the related data in the line edit.

Click a customer in the table view to fetch data by id with a prepared sql query and display id, name, phone, email, and address in the ui line edits.

Create a push button in the Qt/C++ app to update a customer's name, phone, email, and address by id using an sql update query, with success and error messages.

Create a push button function to delete a selected customer, show a confirmation dialog, execute a prepared delete for that customer, and refresh the table view.

Create the home page push button function by editing customer_table.ui, using the show slot, copying the slot, and displaying the main window after closing the customer table.

Create a new sale class and add a sale menu with a do business item and toolbar icon; wire slots to open the sale window from the main window.

Design sale window layout in Qt Creator, remove the status bar, resize to 1600 by 900, set font size 12 bold italic, add a sale title and tooltip, apply stylesheet.

Create a sale window layout in Qt Creator by configuring labels, inputs, and date fields, with vehicle, customer, and seller names, combo boxes, a submit button, and centered image.

build the sale window layout by adding description labels for fake name, customer name, seller name, date, and total sales, plus result labels and buttons.

Create and configure the sale window layout, including combo boxes, line edits, push buttons, picture labels, and result labels, with placeholder text for the line edit and clearly named controls.

Finish the sale window layout by declaring widget pointers in the header for QLabel, QLineEdit, QComboBox, and QPushButton, and copy names from the UI file to avoid typos.

Display pictures in labels using Qt's QPixmap and setPixmap by loading images from the resources folder and scaling them to 150x150 for two labels.

Populate the combo box with available vehicles by querying the vehicle table for id and name and add each as a visible name with a hidden id in the constructor.

Populate a customer name combo box in C++ with Qt Creator by querying the SQLite database for id and name, displaying the name while hiding the id.

Develop a theme for the combo box by querying the seller table to populate the combo box with seller names while storing the corresponding ids as hidden values.

Populates the number of vehicles combo box with 1 to N from the selected vehicle, using a current index change function and storing the vehicle name and hidden ID.

Create two public string variables for the selected vehicle name and hidden vehicle ID, and display both in the terminal via qDebug when the combobox currentIndexChanged slot triggers.

Populate the number of vehicles combobox using a hidden vehicle id to query the vehicle table, fetch the piece count, and fill 1 to the piece count after clearing.

Add items to the date day combobox by editing the ui file and clicking the plus button to populate 01-31, then run the app to view the options.

Add items to the date month combo box by repeatedly clicking the plus button, then run the application to see the months appear in the combo box.

Select items from the combo boxes to capture vehicle, customer, and seller names and IDs into public variables, plus quantity, date day, month, and line edit input on submit.

Create a click function for the submit push button in Qt Creator, extracting customer and seller names and IDs from combo boxes, the number of vehicles sold, and date components.

Select a vehicle from the combo box and fetch its price and currency from vehicle table using the hidden vehicle id, via SQL query, storing them as price and currency.

Finish submit button logic in this C++ Qt Creator course by validating input, computing total price from vehicles sold, and updating labels for fake name, date, and total sales.

Implement a push button confirm slot to update vehicle piece counts in the sqlite database, reflect sales in the vehicle table, and prepare a stats table for later analysis.

Creates a confirm button that validates label inputs: vehicle name, customer name, seller name, date, and total sales, stores them in QString variables, and updates the database when data exists.

Create a pushbutton confirm handler in a Qt C++ app to save new_vehicle_pieces and new_vehicle_basis, update the vehicle table in sqlite after selling selected pieces, and debug output with qDebug.

Update only the selected vehicle's pieces in the sqlite database using a prepared query in Qt Creator, via a combo box with a hidden vehicle id and push button confirm.

Update the vehicle inventory in a Qt Creator SQLite app by clicking confirm, which sets sold-out stock to zero, marks the vehicle not available, and hides it from the combobox.

Create a new sale table in SQLite to support statistics, defining columns for ids, foreign keys, counts, date fields, total price, currency, and customer and seller names.

Implement a pushbutton confirm to insert a new sale into sqlite, converting hidden combobox values to integers (sold_vehicle_id, sold_customer_id, sold_seller_id) and capturing date, price, currency, and seller and customer names.

Create a q sql query to insert into the sale table in sqlite, bind 11 values to columns, execute the query, and show success or error messages.

Finish creating the click function for pushbutton confirm, sell three visits, update vehicle table and combo box, recreate the sale window with a pointer, and refresh the user interface.

Create a push button that closes the sale window, shows the main window, saves data to the sale table, and updates the vehicle name combo box and availability.

Explore building statistics using a new sale table in SQLite: calculate total sold vehicles and total sales for sellers, customers, and car dealers by month and year.

Create statistics seller per month by adding a statistics seller class, then add a menu item and toolbar icon with a tooltip and font size 12 bold italic.

Create click functions for a new menu item and toolbar icon to open the statistics seller per month window, closing the main window, using the slot and including the header.

Design the statistics seller per month window in Qt Creator by setting size, font (12 bold italic), title, tooltip, and icon, then style text and background with a stylesheet.

Design a statistics seller per month window in Qt Creator by adding labels, pictures, and combo boxes, resizing fonts, centering text, and duplicating controls.

Finish creating the statistics seller per month window layout in a Qt Creator project by wiring up comboboxes, line edits, labels, and push buttons, and assigning widget names for clarity.

Display a picture in a label and populate the seller name combobox by querying the sqlite database in the statistics seller per month window, implemented in the constructor.

Create a push button statistics feature for seller per month by reading name, month, and year from UI, validating input, and showing results with the show slot.

Create a pushbutton function in Qt Creator to query a sqlite database with a prepared statement, retrieving seller name, currency, month, year, vehicle count, and total sales.

Create a pushbutton click handler to display seller-per-month statistics with C++ in Qt Creator using a SQLite database, ensuring query columns match, and showing message box when results are empty.

Create a pushbutton click that retrieves seller monthly statistics from sqlite and displays the seller, month, vehicle count, and total sales in a label with proper string formatting.

Learn to implement a push button on the home page that closes the statistics seller per month window and shows the main window by including min window.h and creating a min window instance.

Create a new statistics seller per year window by adding a class, a menu item, and a toolbar icon in Qt Creator, wiring slots to open the window.

Create the layout for a new window statistics cellar per year by adapting the per month layout, then adjust the title, icon, colors, and font.

Create a Qt Creator window layout for statistics by year, wiring a label picture, sailor name combobox, line edit, and buttons, with widget pointer names in the header.

Display a seller's picture in a label and populate the seller name in a combobox from the seller table in sqlite, using a QSqlQuery in the constructor.

Create a push button function to fetch a seller’s yearly sales from the sale table using combo box and year input, and display totals with currency formatting in the ui.

Implement the second push button to close the statistics seller per year window and show the main home window by creating and displaying a mean window instance.

Create a statistics window for customer per year in a Qt Creator project by adding a menu item and toolbar icon, and wiring slots to show the new window.

Create a window layout for statistics customer per year by configuring window properties, styling, and icons, then reuse the seller per year layout and update labels and actions for customers.

Finish the statistics customer per year window layout by wiring header widgets from the UI, including labels, a line edit, a combo box, and push buttons.

Display a picture in a label and populate a combobox with customer names from the customer table using QSqlQuery in Qt Creator; money image is linked and two customers appear.

Develop a push-button customer statistics by year feature in Qt by reusing the seller per year logic, validating inputs, and querying the sales table for totals and counts.

Implement a push button on the home page to close the statistics per year window and reveal the main window, using a mean window pointer and including mean window.h.

Create a statistics window for car dealer per month by adding a statistics class, a menu item, a toolbar icon, and wiring actions and slots to open the window.

Design a statistics car dealer per month window: remove status bar, set title and font, apply gradient background and icon, reuse a seller layout, and arrange month-year controls.

Finish the statistics car dealer per month window layout in Qt Creator. Create and wire QLabel, QLineEdit, QComboBox, and QPushButton by copying names from the UI file and header file.

Learn to display a picture in the label picture by loading from the CBB file statistics seller per month.cbb, then run the app to see it.

Create a push button statistics card for car dealer monthly sales using Qt Creator and an sqlite database, validating input and displaying monthly sales and total revenue.

Finish implementing the pushbutton statistics for the car dealer per month, enforce nonempty input fields, and display sold vehicles and total sales for 2022 across selected months using the database.

Create a click function for the push button on the home page to close statistics window and show main window, wire its slot, and update window title and tooltip.

Create a new statistics window for car dealer per year in the main Qt Creator project. Wire a menu item and toolbar icon to open it via slots and resources.

Create a resizable statistics window for a car dealer per year in Qt Creator by configuring the ui, font, colors, icons, and layout, then adapt labels, buttons, and data fields.

Define and connect Qt widgets as pointers in the header for a car dealer statistics window, including labels, line edits, and push buttons, using names copied from the UI file.

Create a click function for the statistics car dealer button to display a picture in a label and fetch currency, total sold vehicles, and total sales from sqlite, updating UI.

Create a push button home page that closes the statistics window and shows the main window, with input validation and sqlite database-backed yearly sales data.

Learn to create an exe file from a Qt Creator project by making a backup, switching to release mode, and moving the executable and database to a final folder.

Finish creating the exe file by using the QtCreator terminal with the same version, then to run on another computer copy the entire project folder.