A SIMPLE INVENTORY SYSTEM w/ POS

MAIN PAGE ..

Before you download the source code please

LIKE OUR PAGE: https://www.facebook.com/Educatorcode/

and please comment and share

THIS IS A LOGIN AREA 1.1

TABLE AREA

STATISTIC AREA

ADD ITEM

ADD TABLE

ADD ITEM

IF NORMAL CRITICAL OR OUT OF STOCK

SALES REPORT

AS A SIGN OF THANK YOU FOR THIS SYSTEM PLEASE SHARE AND LIKE OUR PAGE IN FACEBOOK TO UPDATE YOU FOR MORE SOURCE CODE TO COME

THIS IS THE PHP SOURCE CODE LINK:
WAIT FOR TO VIEW THE LINK

Download the file...
TO RUN THE PROGRAM PHP SYSTEM PLEASE PASTE THE SQL CODE

Open your wampp or Xampp and start the apache and MySQL panel. In Browser type the localhost/phpmyadmin.

After that create database name: side_db

Paste this in SQL code

Admin Code SQL

CREATE TABLE IF NOT EXISTS `admin` (

`admin_id` tinyint(5) NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

`username` varchar(10) NOT NULL,

`password` varchar(10) NOT NULL,

`date` datetime NOT NULL,

PRIMARY KEY (`admin_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- Dumping data for table `admin`

INSERT INTO `admin` (`admin_id`, `name`, `username`, `password`, `date`) VALUES

(1, 'Philip Prado', 'admin', 'admin', '2016-11-23 00:00:00'),

(2, 'Jojo', 'jojo', 'jojo', '2017-08-05 14:55:28');

Module for Log Report

CREATE TABLE IF NOT EXISTS `logreport` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`idno` int(255) DEFAULT NULL,

`name` varchar(255) DEFAULT NULL,

`log_in` datetime DEFAULT NULL,

`log_out` datetime DEFAULT NULL,

`date` date DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

-- Dumping data for table `logreport`

INSERT INTO `logreport` (`id`, `idno`, `name`, `log_in`, `log_out`, `date`) VALUES

(24, 1, 'Philip Prado', '2017-07-10 16:32:52', NULL, '2017-07-10'),

(25, 1, 'Philip Prado', '2017-07-10 16:33:30', NULL, '2017-07-10'),

(26, 1, 'Philip Prado', '2017-07-10 16:33:44', NULL, '2017-07-10'),

(27, 1, 'Philip Prado', '2017-07-10 16:34:41', NULL, '2017-07-10'),

(28, 1, 'Philip Prado', '2017-07-10 18:09:39', NULL, '2017-07-10'),

(29, 1, 'Philip Prado', '2017-07-11 13:58:46', NULL, '2017-07-11');

Create Main admin

CREATE TABLE IF NOT EXISTS `main_admin` (

`main_admin` int(255) NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

`username` varchar(255) DEFAULT NULL,

`password` varchar(255) DEFAULT NULL,

`date` date DEFAULT NULL,

PRIMARY KEY (`main_admin`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- Dumping data for table `main_admin`

INSERT INTO `main_admin` (`main_admin`, `name`, `username`, `password`, `date`) VALUES

(1, 'philip prado', 'user', 'user', '2017-07-11');

Module for members admin

CREATE TABLE IF NOT EXISTS `members` (

`member_id` int(11) NOT NULL AUTO_INCREMENT,

`UserName` varchar(200) NOT NULL,

`Password` varchar(200) NOT NULL,

`FirstName` varchar(200) NOT NULL,

`LastName` varchar(200) NOT NULL,

PRIMARY KEY (`member_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- Dumping data for table `members`

INSERT INTO `members` (`member_id`, `UserName`, `Password`, `FirstName`, `LastName`) VALUES

(1, 'js', 'js', 'john', 'smith'),

(2, 'jk', 'jk', 'john kevin', 'lorayna'),

(5, 'admin', 'admin', 'john', 'smith');

Per Bucket Module

CREATE TABLE IF NOT EXISTS `per_bucket` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`per_bucket` varchar(255) DEFAULT NULL,

`orig_item` int(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- Dumping data for table `per_bucket`

INSERT INTO `per_bucket` (`id`, `per_bucket`, `orig_item`) VALUES

(1, 'BUCKET', 10),

(2, 'BANYERA', 20);

Per Transaction

CREATE TABLE IF NOT EXISTS `per_transaction` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`table_transaction` varchar(255) DEFAULT NULL,

`sell_price` varchar(255) DEFAULT NULL,

`date` date DEFAULT NULL,

`assist_by` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- Dumping data for table `per_transaction`

INSERT INTO `per_transaction` (`id`, `table_transaction`, `sell_price`, `date`, `assist_by`) VALUES

(2, '3', '600', '2017-09-09', NULL),

(3, '5', '150', '2017-09-09', NULL),

(4, '5', '366', '2017-09-09', NULL),

(5, '1', '60', '2017-09-11', 'john smith');

Module for drinks

CREATE TABLE IF NOT EXISTS `product_mix` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`product_mix` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- Dumping data for table `product_mix`

INSERT INTO `product_mix` (`id`, `product_mix`) VALUES

(1, 'Beer'),

(2, 'Hard liquor '),

(3, 'Grilled');

Module for start me

CREATE TABLE IF NOT EXISTS `startme` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`startme` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- Dumping data for table `startme`

INSERT INTO `startme` (`id`, `startme`) VALUES

(1, '10');

Module for stat admin

CREATE TABLE IF NOT EXISTS `stat_admin` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`from` varchar(255) DEFAULT NULL,

`to` varchar(255) DEFAULT NULL,

`user` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

-- Dumping data for table `stat_admin`

INSERT INTO `stat_admin` (`id`, `from`, `to`, `user`) VALUES

(1, '2017-07-10', '2017-07-11', 'admin'),

(2, '2017-07-10', '2017-07-12', NULL),

(3, '2017-07-10', '2017-07-15', NULL),

(4, '2017-07-10', '2017-07-11', NULL),

(5, '2017-07-01', '2017-07-31', NULL),

(6, '2017-07-17', '2017-07-21', NULL),

(7, '2017-07-08', '2017-07-20', NULL),

(8, '2017-07-01', '2017-07-20', NULL),

(9, '2017-07-20', '2017-07-21', NULL),

(10, '2017-07-17', '2017-07-21', NULL),

(11, '2017-07-08', '2017-07-21', NULL),

(12, '2017-07-01', '2017-07-22', NULL),

(13, '2017-07-24', '2017-07-25', NULL),

(14, '2017-07-25', '2017-07-26', NULL),

(15, '2017-07-25', '2017-07-25', NULL),

(16, '2017-07-25', '2017-07-26', NULL),

(17, '2017-07-24', '2017-07-28', NULL),

(18, '2017-07-24', '2017-07-28', NULL),

(19, '2017-07-24', '2017-07-27', NULL),

(20, '2017-07-25', '2017-07-29', NULL),

(21, '2017-07-25', '2017-07-29', NULL),

(22, '2017-07-25', '2017-07-29', NULL),

(23, '2017-07-25', '2017-07-29', NULL),

(24, '2017-07-24', '2017-07-29', NULL),

(25, '2017-08-03', '2017-08-03', NULL),

(26, '2017-08-03', '2017-08-03', NULL),

(27, '2017-08-05', '2017-08-05', NULL),

(28, '2017-08-05', '2017-08-05', NULL),

(29, '2017-08-05', '2017-08-06', NULL),

(30, '2017-09-08', '2017-09-09', NULL);

Module for Stock in

CREATE TABLE IF NOT EXISTS `stock_in` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`stockno` varchar(255) DEFAULT NULL,

`item_name` varchar(255) DEFAULT NULL,

`h_beggining` int(255) NOT NULL,

`beggining` int(255) NOT NULL,

`orig_price` double NOT NULL,

`sell_price` double NOT NULL,

`p_status` varchar(255) DEFAULT NULL,

`per_bucket` varchar(255) DEFAULT NULL,

`item_number` varchar(255) DEFAULT NULL,

`date` date NOT NULL,

`date_update` date DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- Dumping data for table `stock_in`

INSERT INTO `stock_in` (`id`, `stockno`, `item_name`, `h_beggining`, `beggining`, `orig_price`, `sell_price`, `p_status`, `per_bucket`, `item_number`, `date`, `date_update`) VALUES

(1, '258', 'San meg', 4, 7, 30, 30, '1', '280', '6', '2017-08-05', NULL),

(2, '6998996', 'Empe lights', 0, 3, 30, 60, '2', '350', '2', '2017-08-05', NULL),

(3, '96389', 'BANYERA', 0, 4, 35, 60, '3', '400', '7', '2017-08-05', NULL),

(4, '8963', 'SISIG inasal', 0, 21, 25, 36, '3', NULL, NULL, '2017-08-05', NULL),

(5, '56988999', 'BULALO', 0, 10, 20, 30, '3', NULL, NULL, '2017-09-11', NULL);

Module for stock out

CREATE TABLE IF NOT EXISTS `stock_out` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`idno` int(255) DEFAULT NULL,

`stockno` varchar(255) DEFAULT NULL,

`item_name` varchar(255) DEFAULT NULL,

`quantity` int(255) DEFAULT NULL,

`orig_price` double DEFAULT NULL,

`sell_price` double DEFAULT NULL,

`status` int(255) NOT NULL,

`date` date DEFAULT NULL,

`user` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

-- Dumping data for table `stock_out`

INSERT INTO `stock_out` (`id`, `idno`, `stockno`, `item_name`, `quantity`, `orig_price`, `sell_price`, `status`, `date`, `user`) VALUES

(30, 1, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-11', '5');

A Sample for stock out

CREATE TABLE IF NOT EXISTS `stock_out_report` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`idno` int(255) DEFAULT NULL,

`stockno` varchar(255) DEFAULT NULL,

`item_name` varchar(255) DEFAULT NULL,

`quantity` int(255) DEFAULT NULL,

`orig_price` double DEFAULT NULL,

`sell_price` double DEFAULT NULL,

`status` int(255) DEFAULT NULL,

`date` date DEFAULT NULL,

`user` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

-- Dumping data for table `stock_out_report`

INSERT INTO `stock_out_report` (`id`, `idno`, `stockno`, `item_name`, `quantity`, `orig_price`, `sell_price`, `status`, `date`, `user`) VALUES

(1, 1, '258', 'San meg', 3, 30, 90, 1, '2017-09-08', '5'),

(2, 1, '6998996', 'Empe lights', 2, 30, 120, 2, '2017-09-08', '5'),

(3, 1, '8963', 'SISIG inasal', 5, 25, 180, 3, '2017-09-08', '5'),

(4, 1, '6998996', 'Empe lights', 6, 30, 360, 2, '2017-09-08', '5'),

(6, 1, '96389', 'BANYERA', 1, 35, 60, 3, '2017-09-08', '5'),

(7, 1, '96389', 'BANYERA', 2, 35, 120, 3, '2017-09-08', '5'),

(8, 3, '258', 'San meg', 1, 30, 30, 1, '2017-09-09', '5'),

(9, 3, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(10, 3, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(11, 3, '8963', 'SISIG inasal', 1, 25, 36, 3, '2017-09-09', '5'),

(12, 6, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(13, 6, '258', 'San meg', 1, 30, 30, 1, '2017-09-09', '5'),

(14, 3, '258', 'San meg', 2, 30, 60, 1, '2017-09-09', '5'),

(15, 3, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(16, 3, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(17, 3, '258', 'San meg', 1, 30, 30, 1, '2017-09-09', '5'),

(18, 3, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(19, 3, '258', 'San meg', 1, 30, 30, 1, '2017-09-09', '5'),

(20, 3, '6998996', 'Empe lights', 2, 30, 120, 2, '2017-09-09', '5'),

(21, 3, '96389', 'BANYERA', 1, 35, 60, 3, '2017-09-09', '5'),

(22, 3, '6998996', 'Empe lights', 10, 30, 600, 2, '2017-09-09', '5'),

(23, 5, '258', 'San meg', 3, 30, 90, 1, '2017-09-09', '5'),

(24, 5, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-09', '5'),

(25, 5, '258', 'San meg', 10, 30, 300, 1, '2017-09-09', '5'),

(26, 5, '258', 'San meg', 1, 30, 30, 1, '2017-09-09', '5'),

(27, 5, '8963', 'SISIG inasal', 1, 25, 36, 3, '2017-09-09', '5'),

(29, 1, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-11', '5'),

(30, 1, '6998996', 'Empe lights', 1, 30, 60, 2, '2017-09-11', '5');

Module for table Me

CREATE TABLE IF NOT EXISTS `tablename` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`tablename` varchar(255) DEFAULT NULL,

`total` varchar(255) DEFAULT NULL,

`status` varchar(255) DEFAULT NULL,

`assist_by` varchar(255) DEFAULT NULL,

`date` date DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- Dumping data for table `tablename`

INSERT INTO `tablename` (`id`, `tablename`, `total`, `status`, `assist_by`, `date`) VALUES

(1, 'TABLE 1', '60', 'occupy', 'john', '2017-07-05'),

(3, 'TABLE 3', '', 'vacant', 'john', '2017-07-05'),

(5, 'TABLE 2', '', 'vacant', 'john', '0000-00-00'),

(6, 'TABLE 4', '', 'vacant', 'john', '0000-00-00'),

(7, 'TABLE 5', '', 'vacant', '', '0000-00-00');

Table for why avoid?

CREATE TABLE IF NOT EXISTS `whyvoid` (

`id` int(255) NOT NULL AUTO_INCREMENT,

`tablename` varchar(255) DEFAULT NULL,

`whyvoid` varchar(255) DEFAULT NULL,

`clerk_ass` varchar(255) DEFAULT NULL,

`date` date NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- Dumping data for table `whyvoid`

INSERT INTO `whyvoid` (`id`, `tablename`, `whyvoid`, `clerk_ass`, `date`) VALUES

(1, '7', '', NULL, '0000-00-00'),

(2, '7', '', NULL, '0000-00-00'),

(3, '7', '', NULL, '0000-00-00'),

(4, '7', '', NULL, '0000-00-00'),

(5, '7', '', NULL, '0000-00-00'),

(6, '7', '', NULL, '0000-00-00'),

(7, '7', '', NULL, '0000-00-00'),

(8, '7', '', NULL, '0000-00-00'),

(9, '7', '', NULL, '0000-00-00'),

(10, '7', '', NULL, '0000-00-00'),

(11, '7', '', NULL, '0000-00-00'),

(12, '7', '', NULL, '0000-00-00'),

(13, '7', '', NULL, '0000-00-00'),

(14, '7', '', NULL, '0000-00-00');

Pitscon Academy

A SIMPLE INVENTORY SYSTEM w/ POS

If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment

Search

Popular Posts

Total Pageviews