1. Untuk menginput barang masuk dan kluar mnjadi lebih mudah
2. membuat data unttuk Laporan
3. print laporan secara keluar masuk barang secara cepat
- 1. Bentuk Laporan Data Barang Dalam Format PDF
- 2. Form tambah data barang baru
- 3. Form Untuk Edit data Barang
/*
SQLyog Ultimate v12.09 (32 bit)
MySQL - 10.0.17-MariaDB : Database - inven
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `backset` */
DROP TABLE IF EXISTS `backset`;
CREATE TABLE `backset` (
`url` VARCHAR(100) DEFAULT NULL,
`sessiontime` VARCHAR(4) DEFAULT NULL,
`footer` VARCHAR(50) DEFAULT NULL,
`themesback` VARCHAR(2) DEFAULT NULL,
`responsive` VARCHAR(2) DEFAULT NULL
) ENGINE=INNODB DEFAULT CHARSET=latin1;
/*Data for the table `backset` */
INSERT INTO `backset`(`url`,`sessiontime`,`footer`,`themesback`,`responsive`) VALUES ('http://localhost/inven','','','1','0');
/*Table structure for table `barang` */
DROP TABLE IF EXISTS `barang`;
CREATE TABLE `barang` (
`kode` VARCHAR(20) NOT NULL,
`nama` VARCHAR(50) DEFAULT NULL,
`hargabeli` INT(11) DEFAULT NULL,
`hargajual` INT(11) DEFAULT NULL,
`keterangan` VARCHAR(200) DEFAULT NULL,
`kategori` VARCHAR(20) DEFAULT NULL,
`terjual` INT(11) DEFAULT NULL,
`terbeli` INT(11) DEFAULT NULL,
`sisa` INT(11) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`kode`),
KEY `no` (`no`),
KEY `jenis` (`kategori`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*Data for the table `barang` */
INSERT INTO `barang`(`kode`,`nama`,`hargabeli`,`hargajual`,`keterangan`,`kategori`,`terjual`,`terbeli`,`sisa`,`no`) VALUES ('',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3),('0001','Barang',17000,19000,'keterangan','0001',0,0,0,1),('0002','Dua',6000,7000,'ket','0001',0,0,0,2);
/*Table structure for table `bayar` */
DROP TABLE IF EXISTS `bayar`;
CREATE TABLE `bayar` (
`nota` VARCHAR(20) NOT NULL,
`tglbayar` DATE DEFAULT NULL,
`bayar` INT(11) DEFAULT NULL,
`total` INT(11) DEFAULT NULL,
`kembali` INT(11) DEFAULT NULL,
`keluar` INT(11) DEFAULT NULL,
`kasir` VARCHAR(100) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nota`),
KEY `no` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `bayar` */
/*Table structure for table `beli` */
DROP TABLE IF EXISTS `beli`;
CREATE TABLE `beli` (
`nota` VARCHAR(20) NOT NULL,
`tglbeli` DATE DEFAULT NULL,
`total` INT(11) DEFAULT NULL,
`supplier` VARCHAR(20) DEFAULT NULL,
`kasir` VARCHAR(100) DEFAULT NULL,
`keterangan` VARCHAR(200) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nota`),
KEY `no` (`no`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;
/*Data for the table `beli` */
/*Table structure for table `chmenu` */
DROP TABLE IF EXISTS `chmenu`;
CREATE TABLE `chmenu` (
`userjabatan` VARCHAR(20) NOT NULL,
`menu1` VARCHAR(1) DEFAULT '0',
`menu2` VARCHAR(1) DEFAULT '0',
`menu3` VARCHAR(1) DEFAULT '0',
`menu4` VARCHAR(1) DEFAULT '0',
`menu5` VARCHAR(1) DEFAULT '0',
`menu6` VARCHAR(1) DEFAULT '0',
`menu7` VARCHAR(1) DEFAULT '0',
`menu8` VARCHAR(1) DEFAULT '0',
`menu9` VARCHAR(1) DEFAULT '0',
`menu10` VARCHAR(1) DEFAULT '0',
`menu11` VARCHAR(1) DEFAULT '0',
PRIMARY KEY (`userjabatan`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;
/*Data for the table `chmenu` */
INSERT INTO `chmenu`(`userjabatan`,`menu1`,`menu2`,`menu3`,`menu4`,`menu5`,`menu6`,`menu7`,`menu8`,`menu9`,`menu10`,`menu11`) VALUES ('admin','2','4','0','0','0','0','0','0','0','0','0');
/*Table structure for table `data` */
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
`nama` VARCHAR(100) DEFAULT NULL,
`tagline` VARCHAR(100) DEFAULT NULL,
`alamat` VARCHAR(255) DEFAULT NULL,
`notelp` VARCHAR(20) DEFAULT NULL,
`signature` VARCHAR(255) DEFAULT NULL,
`no` INT(11) NOT NULL,
PRIMARY KEY (`no`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;
/*Data for the table `data` */
INSERT INTO `data`(`nama`,`tagline`,`alamat`,`notelp`,`signature`,`no`) VALUES ('Nama','Tempat Indah Nyaman','Jl Indah Rejo 9 no 10','0895455545','Barang yang sudah dibeli tidak dapat dikembalikan .\r\nTerima Kasih',0);
/*Table structure for table `info` */
DROP TABLE IF EXISTS `info`;
CREATE TABLE `info` (
`nama` VARCHAR(50) DEFAULT NULL,
`avatar` VARCHAR(100) DEFAULT NULL,
`tanggal` DATE DEFAULT NULL,
`isi` TEXT,
`id` INT(11) NOT NULL AUTO_INCREMENT,
KEY `id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `info` */
INSERT INTO `info`(`nama`,`avatar`,`tanggal`,`isi`,`id`) VALUES ('admin','dist/img/avatar5.png','2016-12-25','<p>Berita Informasi<br></p>',1);
/*Table structure for table `jabatan` */
DROP TABLE IF EXISTS `jabatan`;
CREATE TABLE `jabatan` (
`kode` VARCHAR(20) NOT NULL,
`nama` VARCHAR(20) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`kode`),
KEY `no` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
/*Data for the table `jabatan` */
INSERT INTO `jabatan`(`kode`,`nama`,`no`) VALUES ('0001','admin',28),('0002','demo',29);
/*Table structure for table `kategori` */
DROP TABLE IF EXISTS `kategori`;
CREATE TABLE `kategori` (
`kode` VARCHAR(20) NOT NULL,
`nama` VARCHAR(30) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`kode`),
KEY `no4` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*Data for the table `kategori` */
INSERT INTO `kategori`(`kode`,`nama`,`no`) VALUES ('0001','kategori',1);
/*Table structure for table `operasional` */
DROP TABLE IF EXISTS `operasional`;
CREATE TABLE `operasional` (
`kode` VARCHAR(20) NOT NULL,
`nama` VARCHAR(100) DEFAULT NULL,
`tanggal` DATE DEFAULT NULL,
`biaya` INT(11) DEFAULT NULL,
`keterangan` VARCHAR(255) DEFAULT NULL,
`kasir` VARCHAR(20) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`kode`),
KEY `no` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `operasional` */
/*Table structure for table `supplier` */
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
`kode` VARCHAR(20) NOT NULL,
`tgldaftar` DATE DEFAULT NULL,
`nama` VARCHAR(25) DEFAULT NULL,
`alamat` VARCHAR(70) DEFAULT NULL,
`nohp` VARCHAR(20) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`kode`),
KEY `no3` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*Data for the table `supplier` */
INSERT INTO `supplier`(`kode`,`tgldaftar`,`nama`,`alamat`,`nohp`,`no`) VALUES ('0001','2016-12-21','Supplier','Jl Ambang tiga no 50','045',1);
/*Table structure for table `transaksibeli` */
DROP TABLE IF EXISTS `transaksibeli`;
CREATE TABLE `transaksibeli` (
`nota` VARCHAR(20) NOT NULL,
`kode` VARCHAR(20) NOT NULL,
`nama` VARCHAR(100) DEFAULT NULL,
`harga` INT(11) DEFAULT NULL,
`jumlah` INT(11) DEFAULT NULL,
`hargaakhir` INT(11) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nota`,`kode`),
KEY `no` (`no`),
KEY `username` (`kode`),
KEY `kdbarang` (`harga`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;
/*Data for the table `transaksibeli` */
/*Table structure for table `transaksimasuk` */
DROP TABLE IF EXISTS `transaksimasuk`;
CREATE TABLE `transaksimasuk` (
`nota` VARCHAR(20) NOT NULL,
`kode` VARCHAR(20) NOT NULL,
`nama` VARCHAR(100) DEFAULT NULL,
`harga` INT(11) DEFAULT NULL,
`hargabeli` INT(11) DEFAULT NULL,
`jumlah` INT(11) DEFAULT NULL,
`hargaakhir` INT(11) DEFAULT NULL,
`hargabeliakhir` INT(11) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nota`,`kode`),
KEY `barang` (`nama`),
KEY `no5_2` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `transaksimasuk` */
/*Table structure for table `user` */
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userna_me` VARCHAR(20) NOT NULL,
`pa_ssword` VARCHAR(70) DEFAULT NULL,
`nama` VARCHAR(100) DEFAULT NULL,
`alamat` VARCHAR(255) DEFAULT NULL,
`nohp` VARCHAR(20) DEFAULT NULL,
`tgllahir` DATE DEFAULT NULL,
`tglaktif` DATE DEFAULT NULL,
`jabatan` VARCHAR(20) DEFAULT NULL,
`avatar` VARCHAR(100) DEFAULT NULL,
`no` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`userna_me`),
KEY `no` (`no`)
) ENGINE=INNODB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
/*Data for the table `user` */
INSERT INTO `user`(`userna_me`,`pa_ssword`,`nama`,`alamat`,`nohp`,`tgllahir`,`tglaktif`,`jabatan`,`avatar`,`no`) VALUES ('admin','90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad','admin','jl jalan','0875757777','0000-00-00','2016-10-08','admin','dist/img/avatar5.png',1),('demo','a69681bcf334ae130217fea4505fd3c994f5683f','demo','demo','088888','2016-12-22','2016-12-26','demo','dist/upload/index.jpg',3);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
No comments:
Post a Comment