OS - V1.1

Installation Manual 👇

Database

• First of all, make sure you have a local database based on MySQL 8, in my case i use WAMP (Link to Download: https://www.wampserver.com/en/download-wampserver-64bits/)

• In phpMyAdmin, create a new database called "dbinfox"

• In the SQL tab, paste the SQL script below and execute:

 CREATE TABLE `tb_clients` (
  `id_client` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `address` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_client`)
);

CREATE TABLE `tb_os` (
  `os` int NOT NULL AUTO_INCREMENT,
  `date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `tipo` varchar(20) NOT NULL,
  `situacao` varchar(50) NOT NULL,
  `equipment` varchar(150) NOT NULL,
  `defect` varchar(150) NOT NULL,
  `service` varchar(150) DEFAULT NULL,
  `technician` varchar(30) DEFAULT NULL,
  `valor` decimal(10,2) DEFAULT NULL,
  `id_client` int NOT NULL,
  PRIMARY KEY (`os`),
  KEY `id_client` (`id_client`)
);

CREATE TABLE `tb_users` (
  `id_user` int NOT NULL,
  `user` varchar(50) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `login` varchar(15) NOT NULL,
  `password` varchar(15) NOT NULL,
  `perfil` varchar(20) NOT NULL,
  PRIMARY KEY (`id_user`),
  UNIQUE KEY `login` (`login`)
);

INSERT INTO `tb_users` VALUES (1,'Administrador','8888-8888','admin','admin','admin');

Application

• Under Releases, install the OS.exe file and follow the wizard steps to install the application.

• When running the application, make sure the database icon is blue (database connected, as in the image below). If not, review the previous steps and check the connection to the WAMP server.

• If everything is ok, you can log in to the app and you will be redirected to the main screen where you can add more users, clients and work orders. The application also prints reports ;)