Skip to content

dipens/InventoryManagermentSystem

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Inventory Management System.

Tech Stack:

  • Symfony 3.3.8
  • PHP 7.0.26-2+ubuntu16.04.1+deb.sury.org+2 (cli) (built: Dec 7 2017 20:09:40) ( NTS )
  • 5.7.20-0ubuntu0.16.04.1
  • Free jqGrid

MySQL structure

mysql> USE TN;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
    -> ;
+--------------+
| Tables_in_TN |
+--------------+
| Category     |
| Products     |
| User         |
+--------------+
3 rows in set (0.00 sec)

mysql> DESCRIBE Category
    -> ;
+--------------+-----------------+------+-----+---------+----------------+
| Field        | Type            | Null | Key | Default | Extra          |
+--------------+-----------------+------+-----+---------+----------------+
| CategoryID   | int(6) unsigned | NO   | PRI | NULL    | auto_increment |
| CategoryName | varchar(50)     | YES  |     | NULL    |                |
| DateUpdated  | timestamp       | YES  |     | NULL    |                |
| DateCreated  | timestamp       | YES  |     | NULL    |                |
+--------------+-----------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> DESCRIBE Products
    -> ;
+--------------+-----------------+------+-----+---------------------+-----------------------------+
| Field        | Type            | Null | Key | Default             | Extra                       |
+--------------+-----------------+------+-----+---------------------+-----------------------------+
| id           | int(6) unsigned | NO   | PRI | NULL                | auto_increment              |
| name         | varchar(30)     | YES  |     | NULL                |                             |
| categoryID   | int(6)          | YES  |     | NULL                |                             |
| SKU          | varchar(10)     | YES  |     | NULL                |                             |
| price        | decimal(15,2)   | YES  |     | NULL                |                             |
| quantity     | int(6)          | YES  |     | NULL                |                             |
| dateCreated  | timestamp       | NO   |     | CURRENT_TIMESTAMP   | on update CURRENT_TIMESTAMP |
| dateModified | timestamp       | NO   |     | 0000-00-00 00:00:00 |                             |
+--------------+-----------------+------+-----+---------------------+-----------------------------+
8 rows in set (0.00 sec)


mysql> DESCRIBE User
    -> ;
+-----------------------+-----------------+------+-----+---------+----------------+
| Field                 | Type            | Null | Key | Default | Extra          |
+-----------------------+-----------------+------+-----+---------+----------------+
| id                    | int(6) unsigned | NO   | PRI | NULL    | auto_increment |
| username              | varchar(30)     | NO   |     | NULL    |                |
| username_canonical    | varchar(30)     | NO   |     | NULL    |                |
| email                 | varchar(50)     | NO   |     | NULL    |                |
| email_canonical       | varchar(50)     | NO   |     | NULL    |                |
| enabled               | bit(1)          | NO   |     | NULL    |                |
| salt                  | varchar(200)    | YES  |     | NULL    |                |
| password              | varchar(200)    | NO   |     | NULL    |                |
| last_login            | timestamp       | YES  |     | NULL    |                |
| locked                | bit(1)          | YES  |     | NULL    |                |
| expired               | bit(1)          | YES  |     | NULL    |                |
| expires_at            | timestamp       | YES  |     | NULL    |                |
| confirmation_token    | varchar(200)    | YES  |     | NULL    |                |
| password_requested_at | timestamp       | YES  |     | NULL    |                |
| roles                 | varchar(200)    | YES  |     | NULL    |                |
| credentials_expired   | bit(1)          | YES  |     | NULL    |                |
| credentials_expire_at | datetime        | YES  |     | NULL    |                |
| DateCreated           | datetime        | YES  |     | NULL    |                |
| DateUpdated           | datetime        | YES  |     | NULL    |                |
+-----------------------+-----------------+------+-----+---------+----------------+
19 rows in set (0.00 sec)

mysql> SELECT * FROM Products;
+----+------------------------+------------+-------+---------+----------+---------------------+---------------------+
| id | name                   | categoryID | SKU   | price   | quantity | dateCreated         | dateModified        |
+----+------------------------+------------+-------+---------+----------+---------------------+---------------------+
|  1 | Pong                   |          1 | A0001 |   69.99 |       20 | 2018-07-03 09:08:42 | 2018-07-03 07:45:30 |
|  2 | GameStation 5          |          1 | A0002 |  269.99 |       15 | 2018-07-03 09:30:12 | 2018-07-03 09:30:12 |
|  3 | AP Oman PC - Aluminum  |          2 | A0003 | 1399.99 |       10 | 2018-07-03 09:09:30 | 2018-07-03 07:45:30 |
|  4 | Fony UHD HDR 55" 4k TV |          3 | A0004 | 1399.99 |        5 | 2018-07-03 09:09:37 | 2018-07-03 07:45:30 |
|  7 | sssssssssssssssssssss  |          1 | 1111  |   11.00 |       11 | 2018-07-03 09:55:02 | 2018-07-03 09:55:02 |
+----+------------------------+------------+-------+---------+----------+---------------------+---------------------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM Category;
+------------+---------------------+---------------------+---------------------+
| CategoryID | CategoryName        | DateUpdated         | DateCreated         |
+------------+---------------------+---------------------+---------------------+
|          1 | Games               | 2018-07-03 09:07:45 | 2018-07-03 09:07:45 |
|          2 | Computers           | 2018-07-03 09:07:45 | 2018-07-03 09:07:45 |
|          3 | TVs and Accessories | 2018-07-03 09:07:45 | 2018-07-03 09:07:45 |
+------------+---------------------+---------------------+---------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM User;
+----+----------+--------------------+---------------+-----------------+---------+------+--------------------------------------------------------------+---------------------+--------+---------+------------+---------------------------------------------+-----------------------+--------+---------------------+-----------------------+-------------+-------------+
| id | username | username_canonical | email         | email_canonical | enabled | salt | password                                                     | last_login          | locked | expired | expires_at | confirmation_token                          | password_requested_at | roles  | credentials_expired | credentials_expire_at | DateCreated | DateUpdated |
+----+----------+--------------------+---------------+-----------------+---------+------+--------------------------------------------------------------+---------------------+--------+---------+------------+---------------------------------------------+-----------------------+--------+---------------------+-----------------------+-------------+-------------+
|  1 | bobby    | bobby              | [email protected] | [email protected]   |        | NULL | XXX | 2018-07-03 08:14:59 | NULL   | NULL    | NULL        | AAA | NULL                  | a:0:{} | NULL                | NULL                  | NULL        | NULL        |
+----+----------+--------------------+---------------+-----------------+---------+------+--------------------------------------------------------------+---------------------+--------+---------+------------+---------------------------------------------+-----------------------+--------+---------------------+-----------------------+-------------+-------------+
1 row in set (0.00 sec)

Two open URLs accessible without authentication:

/CategoryLookup and /Inventory/RegularInventoryLookup

The rest of the URLs need authentication.

This is a fully working app at this point. With jqGrid the data is always live and shows the data in a nicer tabular form and at the same point utilizes the power of REST APIs.

About

Inventory Management System

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published