Sunday, November 18, 2018

TUGAS RPL - INVENTORY BARANG

ANALISIS KEBUTUHAN

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. 1. Bentuk Laporan Data Barang Dalam Format PDF 



  1. 2. Form tambah data barang baru






  1. 3. Form Untuk Edit data Barang 


4 Source Code Ddata Base
/*
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 */;














Posted by at No comments:

Monday, November 5, 2018

Tugas RPL Membuat data base input nilai dan tampilan form

TUGAS REKAYASA PERANGKAT LUNAK 


- Analisis Kebutuhan
- Untuk mempermudah menjumlahkan nilai siswa
- Untuk mempermudah menghhitung nilai rata rata siswa
 - Untuk mempermudah menentukan kelulusan siswa

1. Tampilan Data Base Siswa



2. Form Data Siswa 




Setelah Mengisikan nim dan nama siswa, dan menginput nilai maka jumlah, dan nilai rata rata siswa akan otomatis terisi  begitu pun dengan keterangan Lulus dan Tidak Lulus,



Tereima Kasih,




Posted by at 4 comments:
Subscribe to: Comments (Atom)