flange-preview

project graph

classDiagram
    flange <|-- vue
    flange <|-- php
    vue <|--|> php
    php <|-- config
    class vue {
        HomeMView.vue
        HomeView.vue
    }
    class php {
        mysqli $connect
        config()
        getAllOrder()
        createOrder()
        verifyCustomer()
        createCustomer()
    }
    class config {
        String MySQL_IP
        String MySQL_User
        String MySQL_Pass
        String MySQL_DB
        String MySQL_Prefix
        saveConfig()
    }

Loading

-- sql init
create `flange_preview`;
use `flange_preview`;

CREATE TABLE `flange` (
  `id` int NOT NULL AUTO_INCREMENT,
  `material` varchar(45) NOT NULL,
  `holes` float NOT NULL,
  `holesPadding` float NOT NULL,
  `flangeRadius` varchar(45) NOT NULL,
  `flangeThickness` float NOT NULL,
  `holesRadius` float NOT NULL,
  `centerRadius` float NOT NULL,
  `neckBottom` float NOT NULL,
  `neckTop` float NOT NULL,
  `neckHeight` float NOT NULL,
  `segments` float NOT NULL,
  `buyer` varchar(45) NOT NULL,
  `buyer_identifier` varchar(45) NOT NULL,
  `amount` int NOT NULL,
  `contact` varchar(45) NOT NULL,
  `closed` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3;

CREATE TABLE `flange_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `identifier` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;