
CREATE TABLE `permintaanbrg_detail_temp` (
  `userid` varchar(30) DEFAULT NULL,
  `kodebrg` varchar(5) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `ket` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `permintaanbrg_detail_temp` */

/*Table structure for table `permintaandana_detail` */


CREATE TABLE `permintaandana_detail` (
  `kodepermintaan` varchar(18) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `jnspenerima` int(1) DEFAULT NULL,
  `penerima` varchar(25) DEFAULT NULL,
  `ket` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `permintaandana_detail` */

/*Table structure for table `permintaankaryawan` */


CREATE TABLE `permintaankaryawan` (
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `jabatan` varchar(30) DEFAULT NULL,
  `jml` int(3) DEFAULT NULL,
  `jobdesc` varchar(50) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `pendidikan` varchar(10) DEFAULT NULL,
  `jurusan` varchar(50) DEFAULT NULL,
  `pengalaman` varchar(100) DEFAULT NULL,
  `keahliankhusus` varchar(50) DEFAULT NULL,
  `jnskelamin` varchar(20) DEFAULT NULL,
  `usia` varchar(20) DEFAULT NULL,
  `statusmarital` varchar(20) DEFAULT NULL,
  `karakteristik` varchar(100) DEFAULT NULL,
  `alasan` text,
  `tglkerja` date DEFAULT NULL,
  `pemohon` varchar(30) DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `permintaankaryawan` */

/*Table structure for table `permintaanpembelian` */


CREATE TABLE `permintaanpembelian` (
  `kodeperusahaan` varchar(4) DEFAULT NULL,
  `kodepengajuan` varchar(20) DEFAULT NULL,
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `tglminta` date DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `terpenuhi` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `permintaanpembelian` */

insert  into `permintaanpembelian`(kodeperusahaan,kodepengajuan,kodepermintaan,tglminta,tglentry,userid,terpenuhi) values ('ITRD','014/PB-ITRD/062016','001/PP-ITRD/062016','2016-06-18','2016-06-18 10:16:23','ayu',1),('ITRD','073/PB-ITRD/052016','002/PP-ITRD/062016','2016-06-20','2016-06-20 10:44:47','ayu',1),('ITRD','045/PB-ITRD/042016','003/PP-ITRD/062016','2016-06-20','2016-06-20 10:58:23','ayu',1),('ITRD','007/PB-ITRD/062016','004/PP-ITRD/062016','2016-06-20','2016-06-20 11:04:55','ayu',1),('ITRD','005/PB-ITRD/062016','005/PP-ITRD/062016','2016-06-20','2016-06-20 11:09:06','ayu',1),('ITRD','007/PB-ITRD/062016','006/PP-ITRD/062016','2016-06-20','2016-06-20 11:14:03','ayu',1),('ITRD','001/PB-ITRD/062016','007/PP-ITRD/062016','2016-06-20','2016-06-20 11:18:15','ayu',1),('ITRD','015/PB-ITRD/062016','008/PP-ITRD/062016','2016-06-20','2016-06-20 11:20:53','ayu',1),('ITRD','004/PB-ITRD/062016','009/PP-ITRD/062016','2016-06-20','2016-06-20 12:41:34','ayu',1),('ITRD','077/PB-ITRD/052016','010/PP-ITRD/062016','2016-06-20','2016-06-20 13:03:27','ayu',1),('ITRD','008/PB-ITRD/062016','011/PP-ITRD/062016','2016-06-20','2016-06-20 13:19:36','ayu',1),('ITRD','008/PB-ITRD/062016','012/PP-ITRD/062016','2016-06-20','2016-06-20 13:25:06','ayu',1),('ITRD','003/PB-ITRD/062016','013/PP-ITRD/062016','2016-06-20','2016-06-20 13:35:28','ayu',1),('ITRD','003/PB-ITRD/062016','014/PP-ITRD/062016','2016-06-20','2016-06-20 13:46:24','ayu',0),('ITRD','054/PB-ITRD/052016','015/PP-ITRD/062016','2016-06-20','2016-06-20 13:55:01','ayu',1),('ITRD','058/PB-ITRD/052016','016/PP-ITRD/062016','2016-06-20','2016-06-20 14:23:38','ayu',1),('ITRD','012/PB-ITRD/062016','017/PP-ITRD/062016','2016-06-20','2016-06-20 14:39:17','ayu',1),('PJSG','004/PB-PJSG/062016','001/PP-PJSG/062016','2016-06-20','2016-06-20 15:08:06','riniadm',0),('SMTH','056/PB-SMTH/052016','001/PP-SMTH/062016','2016-06-21','2016-06-21 09:16:04','fatkiya',0),('SMTH','084/PB-SMTH/052016','002/PP-SMTH/062016','2016-06-21','2016-06-21 09:16:33','fatkiya',1),('SMTH','066/PB-SMTH/052016','003/PP-SMTH/062016','2016-06-21','2016-06-21 09:17:02','fatkiya',1),('SMTH','083/PB-SMTH/052016','004/PP-SMTH/062016','2016-06-21','2016-06-21 09:17:38','fatkiya',1),('SMTH','066/PB-SMTH/052016','005/PP-SMTH/062016','2016-06-21','2016-06-21 09:18:06','fatkiya',1),('SMTH','063/PB-SMTH/052016','006/PP-SMTH/062016','2016-06-21','2016-06-21 09:18:23','fatkiya',0),('SMTH','033/PB-SMTH/062016','007/PP-SMTH/062016','2016-06-21','2016-06-21 09:20:03','fatkiya',0),('SMTH','058/PB-SMTH/052016','008/PP-SMTH/062016','2016-06-21','2016-06-21 09:21:56','fatkiya',1),('ISGN','001/PB-ISGN/062016','001/PP-ISGN/062016','2016-06-21','2016-06-21 09:29:20','nurul',0),('PJSG','004/PB-PJSG/062016','002/PP-PJSG/062016','2016-06-21','2016-06-21 10:09:49','riniadm',1),('PJSG','010/PB-PJSG/062016','003/PP-PJSG/062016','2016-06-21','2016-06-21 10:11:25','riniadm',1),('PJSG','004/PB-PJSG/062016','004/PP-PJSG/062016','2016-06-23','2016-06-23 09:51:18','riniadm',1),('PJSG','006/PB-PJSG/062016','005/PP-PJSG/062016','2016-06-23','2016-06-23 10:14:46','riniadm',0),('ISGN','028/PB-ISGN/062016','002/PP-ISGN/062016','2016-06-23','2016-06-23 14:36:08','nurul',1),('ITNS','026/PB-ITNS/062016','001/PP-ITNS/062016','2016-06-24','2016-06-24 09:08:47','lina',0),('ITNS','031/PB-ITNS/062016','002/PP-ITNS/062016','2016-06-24','2016-06-24 09:09:15','lina',0),('ITNS','018/PB-ITNS/062016','003/PP-ITNS/062016','2016-06-24','2016-06-24 12:14:58','lina',0),('ITRD','016/PB-ITRD/062016','018/PP-ITRD/062016','2016-06-24','2016-06-24 12:47:47','ayu',1),('ITRD','022/PB-ITRD/062016','019/PP-ITRD/062016','2016-06-24','2016-06-24 13:13:39','ayu',1),('ITRD','004/PB-ITRD/062016','020/PP-ITRD/062016','2016-06-24','2016-06-24 14:21:46','ayu',1),('ISGN','029/PB-ISGN/062016','003/PP-ISGN/062016','2016-06-25','2016-06-25 09:40:27','nurul',1),('ITRD','003/PB-ITRD/062016','021/PP-ITRD/062016','2016-06-25','2016-06-25 09:40:42','ayu',1),('ITRD','020/PB-ITRD/062016','022/PP-ITRD/062016','2016-06-25','2016-06-25 09:57:27','ayu',0),('ITNS','027/PB-ITNS/062016','004/PP-ITNS/062016','2016-06-25','2016-06-25 10:44:39','lina',0),('ITNS','034/PB-ITNS/062016','005/PP-ITNS/062016','2016-06-25','2016-06-25 10:45:34','lina',0),('ITRD','007/PB-ITRD/062016','023/PP-ITRD/062016','2016-06-25','2016-06-25 10:53:56','ayu',1),('ITRD','007/PB-ITRD/062016','024/PP-ITRD/062016','2016-06-27','2016-06-27 08:38:04','ayu',1),('ITRD','006/PB-ITRD/062016','025/PP-ITRD/062016','2016-06-27','2016-06-27 08:43:48','ayu',1),('ISGN','034/PB-ISGN/062016','004/PP-ISGN/062016','2016-06-28','2016-06-28 09:02:07','nurul',0),('ITRD','004/PB-ITRD/062016','026/PP-ITRD/062016','2016-06-28','2016-06-28 09:25:57','ayu',1),('PJSG','010/PB-PJSG/062016','006/PP-PJSG/062016','2016-06-28','2016-06-28 09:50:54','riniadm',1),('ITNS','015/PB-ITNS/062016','006/PP-ITNS/062016','2016-06-28','2016-06-28 09:51:53','lina',1),('ITNS','002/PB-ITNS/062016','007/PP-ITNS/062016','2016-06-28','2016-06-28 09:52:59','lina',1),('ITNS','043/PB-ITNS/052016','008/PP-ITNS/062016','2016-06-28','2016-06-28 09:53:26','lina',0),('ITRD','024/PB-ITRD/062016','027/PP-ITRD/062016','2016-06-28','2016-06-28 10:24:56','ayu',1),('ITRD','021/PB-ITRD/062016','028/PP-ITRD/062016','2016-06-28','2016-06-28 10:31:53','ayu',1),('SMNC','016/PB-SMNC/062016','001/PP-SMNC/062016','2016-06-28','2016-06-28 14:25:52','nurulcoil',1),('SMNC','015/PB-SMNC/062016','002/PP-SMNC/062016','2016-06-28','2016-06-28 14:26:40','nurulcoil',0),('SMNC','010/PB-SMNC/062016','003/PP-SMNC/062016','2016-06-28','2016-06-28 14:26:58','nurulcoil',1),('SMNC','016/PB-ISGC/052016','005/PP-SMNC/062016','2016-06-28','2016-06-28 14:27:10','nurulcoil',1),('SMNC','009/PB-SMNC/062016','004/PP-SMNC/062016','2016-06-28','2016-06-28 14:27:20','nurulcoil',1),('PJSG','004/PB-PJSG/062016','007/PP-PJSG/062016','2016-06-29','2016-06-29 09:15:50','riniadm',1),('SMTH','069/PB-SMTH/052016','009/PP-SMTH/062016','2016-06-29','2016-06-29 10:26:04','fatkiya',1),('SMTH','066/PB-SMTH/052016','010/PP-SMTH/062016','2016-06-29','2016-06-29 11:09:34','fatkiya',1),('SMTH','058/PB-SMTH/052016','011/PP-SMTH/062016','2016-06-29','2016-06-29 11:11:59','fatkiya',1),('SMTH','094/PB-SMTH/052016','012/PP-SMTH/062016','2016-06-29','2016-06-29 11:13:10','fatkiya',1),('SMTH','045/PB-SMTH/042016','013/PP-SMTH/062016','2016-06-29','2016-06-29 11:32:32','fatkiya',1),('SMTH','006/PB-SMTH/042016','014/PP-SMTH/062016','2016-06-29','2016-06-29 11:38:01','fatkiya',1),('SMTH','070/PB-SMTH/052016','015/PP-SMTH/062016','2016-06-29','2016-06-29 11:46:16','fatkiya',1),('SMTH','034/PB-SMTH/062016','016/PP-SMTH/062016','2016-06-29','2016-06-29 12:30:48','fatkiya',1),('SMTH','036/PB-SMTH/062016','017/PP-SMTH/062016','2016-06-29','2016-06-29 12:31:12','fatkiya',0),('SMTH','051/PB-SMTH/062016','018/PP-SMTH/062016','2016-06-29','2016-06-29 12:32:44','fatkiya',0),('SMTH','045/PB-SMTH/062016','019/PP-SMTH/062016','2016-06-29','2016-06-29 12:33:55','fatkiya',0),('SMTH','036/PB-SMTH/062016','020/PP-SMTH/062016','2016-06-29','2016-06-29 12:34:17','fatkiya',0),('SMTH','070/PB-SMTH/052016','021/PP-SMTH/062016','2016-06-29','2016-06-29 12:37:44','fatkiya',1),('SMTH','083/PB-SMTH/052016','022/PP-SMTH/062016','2016-06-29','2016-06-29 13:37:01','fatkiya',1),('SMTH','066/PB-SMTH/052016','023/PP-SMTH/062016','2016-06-30','2016-06-30 10:52:17','fatkiya',1),('SMTH','066/PB-SMTH/052016','024/PP-SMTH/062016','2016-06-30','2016-06-30 10:55:11','fatkiya',1),('SMTH','068/PB-SMTH/052016','025/PP-SMTH/062016','2016-06-30','2016-06-30 11:32:50','fatkiya',1),('SMTH','059/PB-SMTH/052016','026/PP-SMTH/062016','2016-06-30','2016-06-30 11:35:15','fatkiya',1),('SMTH','054/PB-SMTH/052016','027/PP-SMTH/062016','2016-06-30','2016-06-30 11:40:13','fatkiya',1),('SMTH','095/PB-SMTH/052016','028/PP-SMTH/062016','2016-06-30','2016-06-30 11:46:04','fatkiya',1),('SMTH','083/PB-SMTH/052016','029/PP-SMTH/062016','2016-06-30','2016-06-30 12:05:39','fatkiya',1),('SMTH','069/PB-SMTH/052016','030/PP-SMTH/062016','2016-06-30','2016-06-30 12:51:43','fatkiya',1),('SMTH','056/PB-SMTH/052016','031/PP-SMTH/062016','2016-06-30','2016-06-30 12:54:47','fatkiya',1),('SMTH','054/PB-SMTH/052016','032/PP-SMTH/062016','2016-06-30','2016-06-30 12:57:13','fatkiya',1),('SMTH','094/PB-SMTH/052016','033/PP-SMTH/062016','2016-06-30','2016-06-30 13:03:20','fatkiya',1),('ITRD','010/PB-ITRD/072016','001/PP-ITRD/072016','2016-07-15','2016-07-15 11:50:20','ayu',1),('SMTH','044/PB-SMTH/062016','001/PP-SMTH/072016','2016-07-15','2016-07-15 11:50:53','fatkiya',1),('SMTH','035/PB-SMTH/062016','002/PP-SMTH/072016','2016-07-15','2016-07-15 11:51:58','fatkiya',1),('ITRD','007/PB-ITRD/072016','002/PP-ITRD/072016','2016-07-15','2016-07-15 11:56:10','ayu',1),('ITRD','001/PB-ITRD/072016','003/PP-ITRD/072016','2016-07-15','2016-07-15 11:59:18','ayu',1),('PJSG','011/PB-PJSG/062016','001/PP-PJSG/072016','2016-07-15','2016-07-15 12:03:41','riniadm',0),('PJSG','011/PB-PJSG/062016','002/PP-PJSG/072016','2016-07-15','2016-07-15 13:28:23','riniadm',0),('PJSG','004/PB-PJSG/062016','003/PP-PJSG/072016','2016-07-15','2016-07-15 13:50:17','riniadm',0),('ITRD','007/PB-ITRD/072016','004/PP-ITRD/072016','2016-07-15','2016-07-15 14:22:27','ayu',1),('ITRD','007/PB-ITRD/072016','005/PP-ITRD/072016','2016-07-15','2016-07-15 14:56:39','ayu',1),('ITRD','015/PB-ITRD/072016','006/PP-ITRD/072016','2016-07-16','2016-07-16 08:58:54','ayu',1),('ITRD','002/PB-ITRD/072016','007/PP-ITRD/072016','2016-07-16','2016-07-16 09:27:05','ayu',1),('ITRD','008/PB-ITRD/072016','008/PP-ITRD/072016','2016-07-18','2016-07-18 10:50:10','ayu',1),('ITRD','003/PB-ITRD/062016','009/PP-ITRD/072016','2016-07-19','2016-07-19 09:38:36','ayu',1),('ITRD','003/PB-ITRD/062016','010/PP-ITRD/072016','2016-07-19','2016-07-19 09:47:08','ayu',1),('ITRD','003/PB-ITRD/062016','011/PP-ITRD/072016','2016-07-19','2016-07-19 09:50:27','ayu',1),('ITRD','047/PB-ITRD/052016','012/PP-ITRD/072016','2016-07-19','2016-07-19 09:55:25','ayu',1),('ITRD','025/PB-ITRD/062016','013/PP-ITRD/072016','2016-07-19','2016-07-19 10:22:31','ayu',1),('ITRD','028/PB-ITRD/062016','014/PP-ITRD/072016','2016-07-19','2016-07-19 10:48:58','ayu',1),('ISGN','008/PB-ISGN/072016','001/PP-ISGN/072016','2016-07-19','2016-07-19 10:56:39','nurul',1),('ISGN','010/PB-ISGN/072016','002/PP-ISGN/072016','2016-07-19','2016-07-19 11:03:32','nurul',0),('ISGN','011/PB-ISGN/072016','003/PP-ISGN/072016','2016-07-19','2016-07-19 11:07:40','nurul',1),('ISGN','012/PB-ISGN/072016','004/PP-ISGN/072016','2016-07-19','2016-07-19 11:09:40','nurul',1),('ISGN','018/PB-ISGN/072016','005/PP-ISGN/072016','2016-07-19','2016-07-19 11:11:30','nurul',1),('PJSG','010/PB-PJSG/062016','004/PP-PJSG/072016','2016-07-19','2016-07-19 11:11:54','riniadm',0),('ISGN','020/PB-ISGN/072016','006/PP-ISGN/072016','2016-07-19','2016-07-19 11:11:56','nurul',0),('ISGN','021/PB-ISGN/072016','007/PP-ISGN/072016','2016-07-19','2016-07-19 11:12:55','nurul',1),('ITRD','015/PB-ITRD/072016','015/PP-ITRD/072016','2016-07-19','2016-07-19 11:42:26','ayu',1),('ITRD','007/PB-ITRD/062016','016/PP-ITRD/072016','2016-07-19','2016-07-19 11:49:40','ayu',1),('ISGN','006/PB-ISGN/072016','008/PP-ISGN/072016','2016-07-19','2016-07-19 12:56:17','nurul',1),('ITRD','012/PB-ITRD/062016','017/PP-ITRD/072016','2016-07-19','2016-07-19 13:33:16','ayu',1),('ITRD','007/PB-ITRD/072016','018/PP-ITRD/072016','2016-07-19','2016-07-19 16:13:28','ayu',1),('ISGN','044/PB-ISGN/062016','009/PP-ISGN/072016','2016-07-20','2016-07-20 08:52:39','nurul',1),('ISGN','049/PB-ISGN/062016','010/PP-ISGN/072016','2016-07-20','2016-07-20 08:53:09','nurul',1),('ITRD','018/PB-ITRD/062016','019/PP-ITRD/072016','2016-07-20','2016-07-20 09:41:14','ayu',1),('ITRD','017/PB-ITRD/062016','020/PP-ITRD/072016','2016-07-20','2016-07-20 11:23:35','ayu',1),('ITRD','013/PB-ITRD/072016','021/PP-ITRD/072016','2016-07-20','2016-07-20 11:46:29','ayu',1),('ITRD','007/PB-ITRD/072016','022/PP-ITRD/072016','2016-07-20','2016-07-20 13:50:36','ayu',1),('ITRD','001/PB-ITRD/072016','023/PP-ITRD/072016','2016-07-20','2016-07-20 14:00:36','ayu',1),('ITRD','003/PB-ITRD/062016','024/PP-ITRD/072016','2016-07-20','2016-07-20 14:13:22','ayu',1),('ITNS','002/PB-ITNS/072016','001/PP-ITNS/072016','2016-07-20','2016-07-20 14:43:24','yanaadm',1),('ITNS','009/PB-ITNS/072016','002/PP-ITNS/072016','2016-07-20','2016-07-20 14:43:43','yanaadm',1),('ITNS','024/PB-ITNS/062016','003/PP-ITNS/072016','2016-07-20','2016-07-20 14:44:01','yanaadm',1),('SMTH','042/PB-SMTH/062016','003/PP-SMTH/072016','2016-07-21','2016-07-21 09:22:31','fatkiya',1),('ITRD','015/PB-ITRD/072016','025/PP-ITRD/072016','2016-07-21','2016-07-21 16:05:08','ayu',1),('ITRD','018/PB-ITRD/072016','026/PP-ITRD/072016','2016-07-21','2016-07-21 16:06:47','ayu',0),('SMTH','058/PB-SMTH/052016','004/PP-SMTH/072016','2016-07-22','2016-07-22 10:47:20','fatkiya',0),('SMTH','010/PB-SMTH/062016','005/PP-SMTH/072016','2016-07-22','2016-07-22 10:50:40','fatkiya',0),('SMTH','034/PB-SMTH/062016','006/PP-SMTH/072016','2016-07-22','2016-07-22 10:58:03','fatkiya',0),('SMTH','051/PB-SMTH/062016','007/PP-SMTH/072016','2016-07-22','2016-07-22 11:34:35','fatkiya',0),('ITRD','010/PB-ITRD/072016','027/PP-ITRD/072016','2016-07-22','2016-07-22 13:47:59','ayu',1),('ITRD','015/PB-ITRD/072016','028/PP-ITRD/072016','2016-07-22','2016-07-22 13:49:22','ayu',1),('ITRD','014/PB-ITRD/072016','029/PP-ITRD/072016','2016-07-22','2016-07-22 13:49:55','ayu',1),('ITRD','007/PB-ITRD/072016','030/PP-ITRD/072016','2016-07-22','2016-07-22 14:10:57','ayu',0),('ISGN','023/PB-ISGN/072016','011/PP-ISGN/072016','2016-07-23','2016-07-23 08:55:21','nurul',0),('ITRD','007/PB-ITRD/072016','031/PP-ITRD/072016','2016-07-23','2016-07-23 09:31:20','ayu',1),('PJSG','013/PB-PJSG/072016','005/PP-PJSG/072016','2016-07-25','2016-07-25 10:07:27','riniadm',1),('PJSG','015/PB-PJSG/072016','006/PP-PJSG/072016','2016-07-25','2016-07-25 10:10:37','riniadm',1),('PJSG','010/PB-PJSG/062016','007/PP-PJSG/072016','2016-07-25','2016-07-25 10:13:26','riniadm',1),('PJSG','017/PB-PJSG/072016','008/PP-PJSG/072016','2016-07-25','2016-07-25 10:15:52','riniadm',1),('PJSG','010/PB-PJSG/062016','009/PP-PJSG/072016','2016-07-25','2016-07-25 11:01:02','riniadm',1),('ITRD','023/PB-ITRD/072016','032/PP-ITRD/072016','2016-07-25','2016-07-25 11:24:22','ayu',0),('ITRD','008/PB-ITRD/072016','033/PP-ITRD/072016','2016-07-25','2016-07-25 11:39:58','ayu',1),('ITNS','002/PB-ITNS/072016','004/PP-ITNS/072016','2016-07-25','2016-07-25 11:42:28','yanaadm',1),('ITRD','015/PB-ITRD/072016','034/PP-ITRD/072016','2016-07-25','2016-07-25 13:13:47','ayu',0),('ITRD','001/PB-ITRD/072016','035/PP-ITRD/072016','2016-07-25','2016-07-25 13:28:37','ayu',1),('ITRD','002/PB-ITRD/072016','036/PP-ITRD/072016','2016-07-26','2016-07-26 08:09:56','ayu',1),('ITRD','024/PB-ITRD/072016','037/PP-ITRD/072016','2016-07-26','2016-07-26 08:31:25','ayu',0),('ITRD','016/PB-ITRD/072016','038/PP-ITRD/072016','2016-07-26','2016-07-26 09:15:28','ayu',1),('ITRD','007/PB-ITRD/072016','039/PP-ITRD/072016','2016-07-27','2016-07-27 15:02:47','ayu',1),('ITRD','015/PB-ITRD/072016','040/PP-ITRD/072016','2016-07-27','2016-07-27 15:03:39','ayu',1),('SMTH','002/PB-SMTH/062016','008/PP-SMTH/072016','2016-07-27','2016-07-27 15:53:16','fatkiya',1),('SMTH','099/PB-SMTH/052016','009/PP-SMTH/072016','2016-07-27','2016-07-27 15:53:31','fatkiya',1),('SMTH','002/PB-SMTH/072016','010/PP-SMTH/072016','2016-07-27','2016-07-27 16:51:48','fatkiya',1),('SMTH','026/PB-SMTH/072016','011/PP-SMTH/072016','2016-07-27','2016-07-27 16:53:06','fatkiya',0),('SMTH','012/PB-SMTH/072016','012/PP-SMTH/072016','2016-07-27','2016-07-27 16:54:52','fatkiya',0),('SMTH','013/PB-SMTH/072016','013/PP-SMTH/072016','2016-07-27','2016-07-27 16:56:21','fatkiya',0),('SMTH','016/PB-SMTH/072016','014/PP-SMTH/072016','2016-07-27','2016-07-27 16:56:48','fatkiya',1),('SMTH','005/PB-SMTH/072016','015/PP-SMTH/072016','2016-07-27','2016-07-27 16:57:22','fatkiya',1),('SMTH','012/PB-SMTH/072016','016/PP-SMTH/072016','2016-07-27','2016-07-27 16:58:00','fatkiya',1),('ISGN','032/PB-ISGN/072016','012/PP-ISGN/072016','2016-07-28','2016-07-28 10:02:12','nurul',1),('ISGN','036/PB-ISGN/072016','013/PP-ISGN/072016','2016-07-28','2016-07-28 10:03:34','nurul',0),('ITRD','008/PB-ITRD/072016','041/PP-ITRD/072016','2016-07-29','2016-07-29 14:43:00','ayu',1),('ITRD','021/PB-ITRD/072016','042/PP-ITRD/072016','2016-07-29','2016-07-29 14:51:48','ayu',1),('ITRD','003/PB-ITRD/072016','043/PP-ITRD/072016','2016-07-30','2016-07-30 08:10:18','ayu',1),('ITRD','022/PB-ITRD/072016','044/PP-ITRD/072016','2016-07-30','2016-07-30 08:10:42','ayu',1),('ISGN','032/PB-ISGN/062016','014/PP-ISGN/072016','2016-07-30','2016-07-30 09:26:17','nurul',1),('ISGN','033/PB-ISGN/062016','015/PP-ISGN/072016','2016-07-30','2016-07-30 09:26:48','nurul',0),('ISGN','048/PB-ISGN/062016','016/PP-ISGN/072016','2016-07-30','2016-07-30 09:27:02','nurul',0),('PJSG','005/PB-PJSG/072016','001/PP-PJSG/082016','2016-08-01','2016-08-01 11:42:26','riniadm',0),('PJSG','013/PB-PJSG/072016','002/PP-PJSG/082016','2016-08-01','2016-08-01 11:43:47','riniadm',0),('ISGN','006/PB-ISGN/072016','001/PP-ISGN/082016','2016-08-02','2016-08-02 09:14:06','nurul',0),('ISGN','002/PB-ISGN/072016','002/PP-ISGN/082016','2016-08-02','2016-08-02 10:16:01','nurul',0),('ITNS','008/PB-ITNS/072016','001/PP-ITNS/082016','2016-08-04','2016-08-04 10:05:55','yanaadm',0),('ITRD','004/PB-ITRD/072016','001/PP-ITRD/082016','2016-08-04','2016-08-04 10:48:56','ayu',1),('ITRD','026/PB-ITRD/072016','002/PP-ITRD/082016','2016-08-04','2016-08-04 13:34:10','ayu',1),('ITRD','008/PB-ITRD/082016','003/PP-ITRD/082016','2016-08-05','2016-08-05 09:22:39','ayu',0),('ITRD','010/PB-ITRD/072016','004/PP-ITRD/082016','2016-08-05','2016-08-05 09:27:11','ayu',1),('ITRD','001/PB-ITRD/082016','005/PP-ITRD/082016','2016-08-05','2016-08-05 09:28:48','ayu',1),('ITRD','006/PB-ITRD/072016','006/PP-ITRD/082016','2016-08-05','2016-08-05 09:31:32','ayu',1),('ITRD','003/PB-ITRD/082016','007/PP-ITRD/082016','2016-08-05','2016-08-05 09:58:45','ayu',1),('ITRD','008/PB-ITRD/082016','008/PP-ITRD/082016','2016-08-05','2016-08-05 10:17:18','ayu',1),('ITRD','008/PB-ITRD/072016','009/PP-ITRD/082016','2016-08-05','2016-08-05 10:27:57','ayu',0),('ITRD','010/PB-ITRD/082016','010/PP-ITRD/082016','2016-08-05','2016-08-05 10:28:30','ayu',1),('ITRD','007/PB-ITRD/072016','011/PP-ITRD/082016','2016-08-05','2016-08-05 10:40:57','ayu',1),('ITRD','015/PB-ITRD/072016','012/PP-ITRD/082016','2016-08-05','2016-08-05 10:44:42','ayu',1),('ITRD','009/PB-ITRD/082016','013/PP-ITRD/082016','2016-08-05','2016-08-05 11:04:14','ayu',1),('ISGN','029/PB-ISGN/072016','003/PP-ISGN/082016','2016-08-05','2016-08-05 15:07:40','nurul',1),('ISGN','054/PB-ISGN/062016','004/PP-ISGN/082016','2016-08-05','2016-08-05 15:08:20','',1),('ISGN','027/PB-ISGN/072016','005/PP-ISGN/082016','2016-08-05','2016-08-05 15:08:36','',1),('ISGC','008/PB-ISGC/052016 ','001/PP-ISGC/082016','2016-08-05','2016-08-05 15:47:09','nurulcoil',0),('SMNC','018/PB-SMNC/062016  ','001/PP-SMNC/082016','2016-08-05','2016-08-05 15:47:30','nurulcoil',1),('SMTH','062/PB-SMTH/062016','001/PP-SMTH/082016','2016-08-06','2016-08-06 10:17:36','fatkiya',0),('SMTH','003/PB-SMTH/072016','002/PP-SMTH/082016','2016-08-06','2016-08-06 10:18:12','fatkiya',1),('ITNS','002/PB-ITNS/082016','002/PP-ITNS/082016','2016-08-08','2016-08-08 09:49:15','yanaadm',0),('ITNS','002/PB-ITNS/082016','003/PP-ITNS/082016','2016-08-08','2016-08-08 09:49:15','yanaadm',0),('ITRD','010/PB-ITRD/082016','014/PP-ITRD/082016','2016-08-08','2016-08-08 14:47:28','ayu',1),('ITRD','008/PB-ITRD/082016','015/PP-ITRD/082016','2016-08-08','2016-08-08 15:05:00','ayu',1),('PJSG','027/PB-PJSG/072016','003/PP-PJSG/082016','2016-08-08','2016-08-08 15:07:46','riniadm',0),('ITRD','009/PB-ITRD/082016','016/PP-ITRD/082016','2016-08-08','2016-08-08 15:26:36','ayu',1),('ITRD','004/PB-ITRD/082016','017/PP-ITRD/082016','2016-08-08','2016-08-08 15:39:01','ayu',0),('ISGN','034/PB-ISGN/072016','006/PP-ISGN/082016','2016-08-08','2016-08-08 15:40:10','nurul',0),('ITRD','009/PB-ITRD/082016','018/PP-ITRD/082016','2016-08-08','2016-08-08 15:40:35','ayu',0),('ITRD','009/PB-ITRD/082016','019/PP-ITRD/082016','2016-08-09','2016-08-09 08:25:06','ayu',1),('ITNS','002/PB-ITNS/082016','004/PP-ITNS/082016','2016-08-09','2016-08-09 09:52:24','alfi',1),('ITRD','003/PB-ITRD/082016','020/PP-ITRD/082016','2016-08-09','2016-08-09 13:16:28','ayu',1),('ITRD','018/PB-ITRD/082016','021/PP-ITRD/082016','2016-08-09','2016-08-09 13:17:31','ayu',1),('ISGN','008/PB-ISGN/052016','007/PP-ISGN/082016','2016-08-09','2016-08-09 13:45:27','nurul',0),('SMNC','008/PB-SMNC/052016','002/PP-SMNC/082016','2016-08-09','2016-08-09 14:05:43','nurulcoil',1),('ITNS','024/PB-ITNS/072016','005/PP-ITNS/082016','2016-08-09','2016-08-09 16:19:17','yanaadm',1),('ITRD','008/PB-ITRD/082016','022/PP-ITRD/082016','2016-08-10','2016-08-10 09:36:42','ayu',0),('ITRD','008/PB-ITRD/072016','023/PP-ITRD/082016','2016-08-10','2016-08-10 09:42:02','ayu',1),('PJSG','017/PB-PJSG/082016','004/PP-PJSG/082016','2016-08-10','2016-08-10 09:51:46','riniadm',0),('PJSG','016/PB-PJSG/082016','005/PP-PJSG/082016','2016-08-10','2016-08-10 09:52:43','riniadm',0),('PJSG','013/PB-PJSG/082016','006/PP-PJSG/082016','2016-08-10','2016-08-10 09:53:43','riniadm',1),('ISGN','022/PB-ISGN/082016','008/PP-ISGN/082016','2016-08-10','2016-08-10 10:23:11','nurul',0),('ISGN','012/PB-ISGN/082016','009/PP-ISGN/082016','2016-08-10','2016-08-10 10:24:30','nurul',0),('ISGN','013/PB-ISGN/082016','010/PP-ISGN/082016','2016-08-10','2016-08-10 10:24:47','nurul',0),('ISGN','014/PB-ISGN/082016','011/PP-ISGN/082016','2016-08-10','2016-08-10 10:24:59','nurul',1),('ISGN','015/PB-ISGN/082016','012/PP-ISGN/082016','2016-08-10','2016-08-10 10:25:07','nurul',0),('ISGN','016/PB-ISGN/082016','013/PP-ISGN/082016','2016-08-10','2016-08-10 10:25:31','nurul',0),('ISGN','017/PB-ISGN/082016','014/PP-ISGN/082016','2016-08-10','2016-08-10 10:25:49','nurul',1),('ITNS','002/PB-ITNS/082016 ','006/PP-ITNS/082016','2016-08-10','2016-08-10 11:02:05','alfi',1),('ITNS','002/PB-ITNS/072016','007/PP-ITNS/082016','2016-08-10','2016-08-10 11:04:46','alfi',1),('ITNS','041/PB-ITNS/062016 ','008/PP-ITNS/082016','2016-08-10','2016-08-10 11:05:57','alfi',1),('ITNS','005/PB-ITNS/072016 ','009/PP-ITNS/082016','2016-08-10','2016-08-10 11:06:54','alfi',1),('ITNS','018/PB-ITNS/072016','010/PP-ITNS/082016','2016-08-10','2016-08-10 11:07:17','alfi',1),('ITNS','017/PB-ITNS/072016 ','011/PP-ITNS/082016','2016-08-10','2016-08-10 11:08:27','alfi',1),('ITNS','003/PB-ITNS/082016','012/PP-ITNS/082016','2016-08-10','2016-08-10 11:10:29','alfi',1),('ITNS','006/PB-ITNS/082016','013/PP-ITNS/082016','2016-08-10','2016-08-10 11:11:30','alfi',1),('ITNS','013/PB-ITNS/082016','014/PP-ITNS/082016','2016-08-10','2016-08-10 11:11:59','alfi',1),('ITNS','024/PB-ITNS/072016 ','015/PP-ITNS/082016','2016-08-10','2016-08-10 11:12:19','alfi',1),('ISGN','039/PB-ISGN/072016','015/PP-ISGN/082016','2016-08-10','2016-08-10 15:40:28','nurul',0),('ISGN','024/PB-ISGN/072016','016/PP-ISGN/082016','2016-08-10','2016-08-10 15:40:56','nurul',0),('ITNS','033/PB-ITNS/062016','016/PP-ITNS/082016','2016-08-10','2016-08-10 15:50:48','alfi',0),('SMTH','011/PB-SMTH/082016','003/PP-SMTH/082016','2016-08-11','2016-08-11 10:29:35','fatkiya',0),('SMTH','013/PB-SMTH/082016','004/PP-SMTH/082016','2016-08-11','2016-08-11 10:30:56','fatkiya',1),('ITNS','023/PB-ITNS/082016','017/PP-ITNS/082016','2016-08-11','2016-08-11 14:45:38','alfi',0),('ITNS','014/PB-ITNS/082016','018/PP-ITNS/082016','2016-08-11','2016-08-11 14:47:00','alfi',0),('ITNS','015/PB-ITNS/082016','019/PP-ITNS/082016','2016-08-11','2016-08-11 14:47:30','alfi',0),('PJSG','015/PB-PJSG/072016','007/PP-PJSG/082016','2016-08-11','2016-08-11 16:34:27','riniadm',0),('ITNS','007/PB-ITNS/072016','020/PP-ITNS/082016','2016-08-12','2016-08-12 09:16:24','alfi',1),('ITRD','001/PB-ITRD/082016','024/PP-ITRD/082016','2016-08-12','2016-08-12 09:31:37','ayu',1),('PJSG','015/PB-PJSG/082016','008/PP-PJSG/082016','2016-08-12','2016-08-12 11:13:10','riniadm',0),('PJSG','010/PB-PJSG/082016','009/PP-PJSG/082016','2016-08-12','2016-08-12 11:28:57','riniadm',0),('ITRD','008/PB-ITRD/082016','025/PP-ITRD/082016','2016-08-15','2016-08-15 11:56:16','ayu',0),('ITRD','003/PB-ITRD/082016','026/PP-ITRD/082016','2016-08-15','2016-08-15 11:57:54','ayu',0),('ITRD','002/PB-ITRD/082016','027/PP-ITRD/082016','2016-08-16','2016-08-16 13:18:33','ayu',1),('ITRD','012/PB-ITRD/082016','028/PP-ITRD/082016','2016-08-16','2016-08-16 13:19:29','ayu',0),('ITRD','016/PB-ITRD/082016','029/PP-ITRD/082016','2016-08-16','2016-08-16 13:19:56','ayu',1),('ITRD','020/PB-ITRD/082016','030/PP-ITRD/082016','2016-08-16','2016-08-16 13:21:14','ayu',0),('ITRD','021/PB-ITRD/082016','031/PP-ITRD/082016','2016-08-16','2016-08-16 13:26:59','ayu',0),('ITNS','024/PB-ITNS/082016','021/PP-ITNS/082016','2016-08-18','2016-08-18 08:51:43','alfi',0),('ITNS','002/PB-ITNS/082016','022/PP-ITNS/082016','2016-08-18','2016-08-18 08:52:18','alfi',0),('ITNS','032/PB-ITNS/082016','023/PP-ITNS/082016','2016-08-18','2016-08-18 10:17:31','alfi',0),('ISGN','031/PB-ISGN/082016','017/PP-ISGN/082016','2016-08-18','2016-08-18 10:18:21','nurul',0),('ISGN','005/PB-ISGN/082016','018/PP-ISGN/082016','2016-08-18','2016-08-18 10:20:43','nurul',0),('ISGN','040/PB-ISGN/072016','019/PP-ISGN/082016','2016-08-18','2016-08-18 11:57:17','nurul',0),('ITRD','008/PB-ITRD/072016','032/PP-ITRD/082016','2016-08-18','2016-08-18 13:24:48','ayu',0),('ITRD','009/PB-ITRD/082016','033/PP-ITRD/082016','2016-08-18','2016-08-18 13:38:32','ayu',0),('ISGN','016/PB-ISGN/082016','020/PP-ISGN/082016','2016-08-18','2016-08-18 14:11:54','nurul',0),('ITRD','001/PB-ITRD/082016','034/PP-ITRD/082016','2016-08-19','2016-08-19 09:01:09','ayu',0),('SMTH','032/PB-SMTH/082016','005/PP-SMTH/082016','2016-08-19','2016-08-19 10:11:23','fatkiya',0),('SMTH','031/PB-SMTH/082016','006/PP-SMTH/082016','2016-08-19','2016-08-19 10:11:43','fatkiya',0),('SMTH','029/PB-SMTH/082016','007/PP-SMTH/082016','2016-08-19','2016-08-19 10:11:58','fatkiya',0),('SMTH','028/PB-SMTH/082016','008/PP-SMTH/082016','2016-08-19','2016-08-19 10:12:15','fatkiya',0),('ISGN','006/PB-ISGN/082016','021/PP-ISGN/082016','2016-08-19','2016-08-19 14:03:43','nurul',0),('ISGN','001/PB-ISGN/082016','022/PP-ISGN/082016','2016-08-19','2016-08-19 14:14:05','nurul',0);

/*Table structure for table `permintaanpembelian_detail` */


CREATE TABLE `permintaanpembelian_detail` (
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(5) DEFAULT NULL,
  `ket` text,
  `terpenuhi` int(1) DEFAULT NULL,
  `locked` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `permintaanpembelian_detail` */

insert  into `permintaanpembelian_detail`(kodepermintaan,kodebrg,jml,kodesatuan,ket,terpenuhi,locked) values ('001/PP-ITRD/062016','G0021','1.00','101','',1,0),('001/PP-ITRD/062016','T0083','1.00','112','',1,0),('001/PP-ITRD/062016','K0117','1.00','112','',1,1),('002/PP-ITRD/062016','K0098','1.00','106','untuk Marketing  Database',1,1),('003/PP-ITRD/062016','T0049','1.00','108','Tanggal 26 April 2016',1,1),('003/PP-ITRD/062016','T0050','1.00','108','Tanggal 26 April 2016',1,1),('004/PP-ITRD/062016','L0069','1.00','105','',1,1),('004/PP-ITRD/062016','O0014','2.00','105','',1,1),('004/PP-ITRD/062016','G0019','1.00','105','',1,1),('004/PP-ITRD/062016','B0114','1.00','111','',1,1),('004/PP-ITRD/062016','I0017','1.00','105','',1,1),('005/PP-ITRD/062016','I0016','1.00','108','',1,1),('006/PP-ITRD/062016','K0102','1.00','114','',1,0),('006/PP-ITRD/062016','K0101','1.00','114','',1,0),('007/PP-ITRD/062016','N0014','35.00','115','',1,0),('008/PP-ITRD/062016','M0072','1.00','106','',1,1),('008/PP-ITRD/062016','M0073','3.00','106','',1,1),('008/PP-ITRD/062016','J0029','1.00','108','',1,0),('009/PP-ITRD/062016','P0132','1.00','108','',1,1),('009/PP-ITRD/062016','P0135','1.00','108','',1,0),('010/PP-ITRD/062016','K0098','1.00','106','untuk Server Back Up',1,1),('011/PP-ITRD/062016','S0083','1.00','106','H 6724 FF, H 4291 ASG',1,1),('011/PP-ITRD/062016','O0015','1.00','113','H 6724 FF, H 4291 ASG',1,1),('011/PP-ITRD/062016','G0020','1.00','106','H 6724 FF',1,1),('012/PP-ITRD/062016','S0083','1.00','106','H 6724 FF, H 4291 ASG',1,1),('012/PP-ITRD/062016','O0015','1.00','113','H 6724 FF, H 4291 ASG',1,1),('013/PP-ITRD/062016','T0072','1.00','111','',1,1),('014/PP-ITRD/062016','K0115','1.00','111','',1,1),('014/PP-ITRD/062016','P0154','2.00','106','',1,1),('014/PP-ITRD/062016','S0086','1.00','112','',1,1),('014/PP-ITRD/062016','W0009','2.00','112','',0,1),('015/PP-ITRD/062016','K0005','1.00','114','',1,1),('016/PP-ITRD/062016','C0000','2.00','106','',1,1),('016/PP-ITRD/062016','T0014','4.00','113','',1,1),('017/PP-ITRD/062016','L0070','1.00','108','Periode 1-30 Juni 2016',1,1),('017/PP-ITRD/062016','L0071','1.00','108','Periode 1-30 Juni 2016',1,1),('001/PP-PJSG/062016','M0058','5.00','111','Untuk sarana kerja produksi',0,0),('001/PP-PJSG/062016','S0081','6.00','111','Untuk sarana kerja produksi',0,0),('001/PP-SMTH/062016','V0000','6.00','121','',0,1),('001/PP-SMTH/062016','V0022','4.00','121','',1,1),('001/PP-SMTH/062016','V0023','2.00','121','',0,1),('001/PP-SMTH/062016','V0024','2.00','121','',0,1),('001/PP-SMTH/062016','V0002','2.00','121','',0,1),('001/PP-SMTH/062016','V0009','2.00','121','',0,1),('001/PP-SMTH/062016','V0003','2.00','121','',0,1),('001/PP-SMTH/062016','V0028','2.00','121','',0,1),('001/PP-SMTH/062016','V0004','2.00','121','',0,1),('002/PP-SMTH/062016','T0017','10.00','118','',1,1),('003/PP-SMTH/062016','s0016','4.00','111','',1,1),('003/PP-SMTH/062016','s0015','4.00','111','',1,1),('004/PP-SMTH/062016','k0015','60.00','101','',1,1),('004/PP-SMTH/062016','b0018','10.00','121','',1,1),('005/PP-SMTH/062016','m0018','1.00','111','',1,1),('006/PP-SMTH/062016','K0037','2.00','121','',0,1),('006/PP-SMTH/062016','K0014','2.00','121','',0,1),('007/PP-SMTH/062016','T0080','2.00','121','timer omron H3CR',0,1),('008/PP-SMTH/062016','P0050','1.00','123','',1,1),('001/PP-ISGN/062016','V0032','8.00','121','',0,1),('001/PP-ISGN/062016','V0033','8.00','121','',0,1),('002/PP-PJSG/062016','M0058','8.00','111','Untuk sarana kerja produksi',0,1),('002/PP-PJSG/062016','S0081','5.00','111','Untuk sarana kerja produksi',0,1),('003/PP-PJSG/062016','B0095','5.00','105','Untuk perawan mesin',0,1),('003/PP-PJSG/062016','B0097','1.00','115','Untuk perawatan mesin',1,1),('003/PP-PJSG/062016','B0099','1.00','115','Untuk perawatan mesin',0,1),('003/PP-PJSG/062016','K0093','20.00','101','Untuk perawatan mesin',0,1),('004/PP-PJSG/062016','S0082','3.00','111','Untuk sarana kerja produksi',1,1),('005/PP-PJSG/062016','R0020','1.00','119','Untuk sarana kerja produksi',0,1),('002/PP-ISGN/062016','F0015','20.00','121','merk kearney = 10 bh\nmerk hubble = 10 bh',1,1),('001/PP-ITNS/062016','T0093','8.00','105','Triplek digunakan sebagai alas bak tronton guna trial bermuatan kertas dari PT Pindo Deli Karawang. Ukuran satu triplek adalah 2.44 cm x 1.22 cm x 1.8 cm, sedangkan ukuran satu bak tronton adalah 2.4 m x 9.4 m. Tronton mana yang nantinya akan digunakan untuk trial PT Pindo Deli Karawang belum ditentukan.',0,1),('002/PP-ITNS/062016','T0093','8.00','105','Triplek digunakan sebagai alas bak tronton guna trial bermuatan kertas dari PT Pindo Deli Karawang. Ukuran satu triplek adalah 2.44 cm x 1.22 cm x 1.8 cm, sedangkan ukuran satu bak tronton adalah 2.4 m x 9.4 m. Tronton mana yang nantinya akan digunakan untuk trial PT Pindo Deli Karawang belum ditentukan.',0,1),('003/PP-ITNS/062016','P0165','1.00','105','Parcel lebaran untuk customer PT Sido Agung Agro Prima.',0,1),('018/PP-ITRD/062016','J0041','1.00','108','Sudah termasuk material',1,1),('019/PP-ITRD/062016','S0107','1.00','155','',1,1),('020/PP-ITRD/062016','P0132','1.00','108','',1,1),('020/PP-ITRD/062016','P0135','1.00','108','',1,0),('003/PP-ISGN/062016','S0078','5.00','153','',1,1),('021/PP-ITRD/062016','P0153','1.00','112','',1,1),('021/PP-ITRD/062016','P0146','1.00','112','',1,1),('022/PP-ITRD/062016','K0128','1.00','106','untuk staff finance',1,1),('022/PP-ITRD/062016','M0078','1.00','106','untuk staff finance',0,1),('004/PP-ITNS/062016','B0142','2.00','105','Ban tronton rusak dan ban merupakan ban asli dari dealer. Tronton 11 jalan pertama kali pada tanggal 2 Februari 2016 dengan life time kurang lebih 5 bulan. Harga ban sudah termasuk sliwer dan ban dalam.',0,1),('004/PP-ITNS/062016','B0127','9.00','105','Ban tronton rusak dan ban merupakan ban asli dari dealer. Tronton 11 jalan pertama kali pada tanggal 2 Februari 2016 dengan life time kurang lebih 5 bulan. Harga ban sudah termasuk sliwer dan ban dalam. 1 ban digunakan untuk cadangan.',0,1),('004/PP-ITNS/062016','V0053','8.00','106','Ukuran Velg tronton 11 adalah Uk. 700, akan ditukar tambah dengan velg Uk. 750 karena ban ukuran 1100 lebih cocok apabila menggunakan velg Uk. 750-800. Karena apabila dipaksakan menggunakan velg Uk. 700 akan berpotensi ban cepat rusak.',1,1),('004/PP-ITNS/062016','J0034','10.00','108','Jasa bongkar pasang ban untuk ban depan 2 buah dan ban belakang 8 buah.',1,1),('005/PP-ITNS/062016','B0142','2.00','105','Kondisi ban tronton sudah rusak dan pecah. History pembelian terakhir pada tanggal 13 Oktober 2015 (life time kurang lebih 8 bulan) yang terdiri dari 9 buah ban luar ukuran 1100 dan 2 buah ban luar ukuran 1000.',0,1),('005/PP-ITNS/062016','B0127','8.00','105','Kondisi ban tronton sudah rusak dan pecah. History pembelian terakhir pada tanggal 13 Oktober 2015 (life time kurang lebih 8 bulan) yang terdiri dari 9 buah ban luar ukuran 1100 dan 2 buah ban luar ukuran 1000.',0,1),('005/PP-ITNS/062016','V0053','6.00','106',' Velg untuk tronton 1 akan diganti dengan velg ukuran 750 untuk keseluruhan. 2 unit velg yang sebelumnya berukuran 700 sudah diganti dengan velg ukuran 750. 6 unit velg 700 sisanya akan diganti dengan ukuran 750.',0,1),('005/PP-ITNS/062016','J0034','10.00','108','Jasa bongkar pasang ban untuk ban depan 2 buah dan ban belakang 8 buah.',0,1),('023/PP-ITRD/062016','K0101','1.00','114','',1,0),('024/PP-ITRD/062016','L0074','1.00','105','',1,1),('024/PP-ITRD/062016','L0072','1.00','105','',1,1),('025/PP-ITRD/062016','J0035','4.00','108','Bulan Juni  4 X',1,1),('025/PP-ITRD/062016','J0036','4.00','108','Bulan  Juni 4 X',1,1),('004/PP-ISGN/062016','B0099','25.00','121','',0,1),('026/PP-ITRD/062016','P0132','1.00','108','',1,1),('026/PP-ITRD/062016','P0135','1.00','108','',1,0),('006/PP-PJSG/062016','B0095','8.00','105','Untuk perawan mesin',0,1),('006/PP-ITNS/062016','M0067','10.00','105','Materai untuk mengirim invoice penagihan ke customer.',1,0),('007/PP-ITNS/062016','P0135','6.00','108','Pulsa Telkomsel 50 = 3 x untuk operasional Pak Kim. Pulsa Telkomsel 50 = 3 x untuk operasional Cindy. Pulsa Telkomsel 50 = 1 x untuk Administrasi.',1,0),('007/PP-ITNS/062016','P0152','2.00','108','Pulsa XL 50 = 3 X untuk Operasional Pak Kim. Pulsa XL 50 = 2 X untuk Administrasi.',1,0),('008/PP-ITNS/062016','B0127','8.00','106','Ban mulai sering kempes dan mudah bocor. History pembelian : Tgl 5 Agust 2015 = 9 buah (masa pakai hampir 10 bulan)',0,1),('008/PP-ITNS/062016','V0053','8.00','106','Ukuran Velg T 5 adalah Uk. 700, akan ditukar tambah dengan velg Uk. 750 karena ban ukuran 1100 lebih cocok apabila menggunakan velg Uk. 750-800. Karena apabila dipaksakan menggunakan velg Uk. 700 akan berpotensi ban cepat rusak. History pembelian : Tgl 24 Maret 2016 = tukar tambah velg 1 unit seharga Rp 500.000. ',0,1),('008/PP-ITNS/062016','J0034','8.00','108','Jasa bongkar pasang ban',1,1),('027/PP-ITRD/062016','O0015','1.00','108','ganti oli Mobil Xenia',1,1),('027/PP-ITRD/062016','W0011','1.00','108','ganti wipper mobil Xenia',1,1),('028/PP-ITRD/062016','K0129','15.00','103','',1,1),('028/PP-ITRD/062016','S0089','2.00','106','',1,1),('028/PP-ITRD/062016','P0171','2.00','118','',1,1),('028/PP-ITRD/062016','K0130','1.00','106','',1,1),('028/PP-ITRD/062016','J0046','1.00','108','',1,1),('001/PP-SMNC/062016','D0031','1.00','108','Merk HIU',1,1),('002/PP-SMNC/062016','T0092','250.00','101','',1,1),('002/PP-SMNC/062016','D0026','25.00','101','',0,1),('003/PP-SMNC/062016','W0010','10.00','125','ukuran 1/4\" \nutk pembuatan 350 loyang\n1 roll jadi 20 loyang',1,1),('005/PP-SMNC/062016','B0126','50.00','118','diameter 8ml panjang 12 m',1,1),('004/PP-SMNC/062016','T0091','100.00','101','',1,1),('007/PP-PJSG/062016','M0058','5.00','111','Untuk sarana kerja produksi',0,1),('007/PP-PJSG/062016','S0081','6.00','111','Untuk sarana kerja produksi',0,1),('009/PP-SMTH/062016','b0016','15.00','121','',1,1),('010/PP-SMTH/062016','m0018','2.00','111','',1,1),('011/PP-SMTH/062016','M0014','20.00','121','',0,1),('012/PP-SMTH/062016','l0022','1.00','120','',1,1),('013/PP-SMTH/062016','p0083','3.00','110','',1,1),('014/PP-SMTH/062016','T0017','50.00','118','',1,1),('015/PP-SMTH/062016','a0007','11.00','103','',1,1),('016/PP-SMTH/062016','V0033','6.00','121','',1,1),('017/PP-SMTH/062016','S0077','60.00','118','',0,1),('018/PP-SMTH/062016','K0093','40.00','101','',0,1),('018/PP-SMTH/062016','B0095','20.00','121','',0,1),('018/PP-SMTH/062016','B0098','20.00','121','',0,1),('019/PP-SMTH/062016','A0030','25.00','124','',0,1),('020/PP-SMTH/062016','P0124','2.00','107','',0,1),('021/PP-SMTH/062016','a0007','11.00','103','',1,1),('022/PP-SMTH/062016','b0018','10.00','121','',1,1),('023/PP-SMTH/062016','s0016','3.00','111','',1,1),('023/PP-SMTH/062016','m0018','7.00','111','',1,1),('024/PP-SMTH/062016','s0016','1.00','111','',1,1),('025/PP-SMTH/062016','F0006','4.00','121','',1,1),('026/PP-SMTH/062016','s0021','3.00','121','',1,1),('027/PP-SMTH/062016','L0020','2.00','121','untuk cadangan mesin',1,1),('028/PP-SMTH/062016','M0043','1.00','106','Untuk monitoring CCTV',1,1),('029/PP-SMTH/062016','k0015','30.00','101','',1,1),('029/PP-SMTH/062016','b0018','10.00','121','',1,1),('030/PP-SMTH/062016','b0016','10.00','121','',1,1),('031/PP-SMTH/062016','V0029','2.00','121','',1,1),('032/PP-SMTH/062016','L0019','2.00','121','untuk cadangan mesin',1,1),('032/PP-SMTH/062016','L0020','1.00','121','untuk cadangan mesin',1,1),('033/PP-SMTH/062016','b0051','2.00','121','',1,1),('001/PP-ITRD/072016','N0014','30.00','115','',0,0),('001/PP-SMTH/072016','S0081','4.00','111','',1,1),('001/PP-SMTH/072016','S0082','4.00','111','',1,1),('001/PP-SMTH/072016','M0058','4.00','111','',1,1),('002/PP-SMTH/072016','L0063','1.00','121','',1,1),('002/PP-SMTH/072016','L0064','2.00','121','',1,1),('002/PP-ITRD/072016','A0044','4.00','127','',0,0),('002/PP-ITRD/072016','A0045','2.00','129','',0,0),('002/PP-ITRD/072016','K0117','1.00','112','',0,1),('002/PP-ITRD/072016','G0021','1.00','101','',0,0),('003/PP-ITRD/072016','S0094','1.00','112','',1,1),('003/PP-ITRD/072016','S0086','1.00','112','',0,1),('003/PP-ITRD/072016','P0147','2.00','111','',1,1),('001/PP-PJSG/072016','A0030','11.00','103','Untuk perawatan mesin',1,1),('001/PP-PJSG/072016','B0089','50.00','118','Untuk bahan sisir',1,1),('001/PP-PJSG/072016','P0139','1.00','110','Untuk bahan pukulan',1,1),('001/PP-PJSG/072016','P0123','2.00','110','Untuk bahan pukulan',0,1),('001/PP-PJSG/072016','V0031','1.00','120','Untuk perawatan mesin',1,1),('001/PP-PJSG/072016','N0009','2.00','105','Untuk perawatan mesin',1,1),('002/PP-PJSG/072016','C0020','5.00','105','Untuk perawatan mesin',0,1),('003/PP-PJSG/072016','M0058','5.00','111','Untuk sarana kerja produksi',0,1),('003/PP-PJSG/072016','S0081','5.00','111','Untuk sarana kerja produksi',0,1),('004/PP-ITRD/072016','A0044','1.00','127','',0,0),('004/PP-ITRD/072016','T0083','1.00','112','',0,0),('005/PP-ITRD/072016','G0021','1.00','101','',0,0),('006/PP-ITRD/072016','L0073','2.00','105','',1,1),('007/PP-ITRD/072016','P0135','1.00','108','',0,0),('007/PP-ITRD/072016','P0132','1.00','108','',0,1),('008/PP-ITRD/072016','S0097','1.00','106','',1,1),('009/PP-ITRD/072016','R0021','1.00','113','',1,1),('010/PP-ITRD/072016','R0021','1.00','113','',1,1),('011/PP-ITRD/072016','T0072','1.00','111','',1,1),('012/PP-ITRD/072016','B0073','1.00','111','',1,1),('013/PP-ITRD/072016','T0097','5.00','104','untuk pengecatan meja staff',1,1),('013/PP-ITRD/072016','K0118','2.00','105','',1,1),('014/PP-ITRD/072016','T0081','1.00','106','',1,1),('001/PP-ISGN/072016','K0093','20.00','101','',1,1),('001/PP-ISGN/072016','B0095','10.00','121','',1,1),('001/PP-ISGN/072016','B0099','25.00','121','',1,1),('002/PP-ISGN/072016','V0034','2.00','121','',1,1),('002/PP-ISGN/072016','V0036','2.00','121','',1,1),('002/PP-ISGN/072016','V0033','12.00','121','',0,1),('002/PP-ISGN/072016','V0032','8.00','121','',0,1),('002/PP-ISGN/072016','V0057','3.00','121','',0,1),('002/PP-ISGN/072016','V0058','2.00','121','',1,1),('002/PP-ISGN/072016','V0045','2.00','121','',1,1),('003/PP-ISGN/072016','L0064','2.00','121','',1,1),('003/PP-ISGN/072016','L0063','2.00','121','',1,1),('003/PP-ISGN/072016','L0054','2.00','121','',1,1),('003/PP-ISGN/072016','L0059','2.00','121','',1,1),('003/PP-ISGN/072016','B0091','2.00','121','',1,1),('003/PP-ISGN/072016','S0080','2.00','121','',1,1),('004/PP-ISGN/072016','V0031','1.00','123','',1,1),('005/PP-ISGN/072016','A0030','10.00','124','',1,1),('004/PP-PJSG/072016','K0093','20.00','101','Untuk perawatan mesin',0,1),('006/PP-ISGN/072016','K0137','1.00','115','',0,1),('006/PP-ISGN/072016','E0007','6.00','121','pintu lipat 3/4\"',0,1),('006/PP-ISGN/072016','D0032','6.00','121','',0,1),('007/PP-ISGN/072016','L0055','2.00','121','',1,1),('007/PP-ISGN/072016','K0137','1.00','115','',1,1),('007/PP-ISGN/072016','D0032','6.00','121','',1,1),('015/PP-ITRD/072016','K0101','1.00','114','',0,0),('015/PP-ITRD/072016','K0102','2.00','114','',0,0),('015/PP-ITRD/072016','K0116','1.00','116','',1,1),('016/PP-ITRD/072016','K0104','1.00','111','',1,1),('016/PP-ITRD/072016','K0105','1.00','111','',1,1),('016/PP-ITRD/072016','I0017','1.00','105','',1,1),('016/PP-ITRD/072016','L0075','1.00','111','',1,1),('016/PP-ITRD/072016','S0095','4.00','116','',1,1),('008/PP-ISGN/072016','S0082','2.00','111','',0,1),('008/PP-ISGN/072016','S0081','3.00','111','',0,1),('008/PP-ISGN/072016','M0058','5.00','111','',0,1),('017/PP-ITRD/072016','I0018','1.00','108','Periode 1-30 Juni 2016',1,1),('018/PP-ITRD/072016','A0044','4.00','127','',0,0),('018/PP-ITRD/072016','A0045','2.00','129','',0,0),('009/PP-ISGN/072016','O0017','4.00','121','',1,1),('010/PP-ISGN/072016','T0063','4.00','121','',1,1),('010/PP-ISGN/072016','T0064','6.00','121','',1,1),('019/PP-ITRD/072016','J0044','1.00','108','Meja dan lemari untuk staff dan finance',1,1),('020/PP-ITRD/072016','A0054','1.00','106','untuk R. Meeting',1,1),('020/PP-ITRD/072016','J0042','1.00','108','jasa bongkar R. Trans',1,1),('020/PP-ITRD/072016','J0043','1.00','108','Jasa bongkar R. Meeting',1,1),('020/PP-ITRD/072016','P0170','12.00','103','Pipa AC   kabel',1,1),('021/PP-ITRD/072016','M0085','1.00','106','',1,1),('022/PP-ITRD/072016','G0021','1.00','101','',0,0),('023/PP-ITRD/072016','P0153','1.00','112','',1,1),('023/PP-ITRD/072016','P0146','1.00','112','',1,1),('023/PP-ITRD/072016','T0072','1.00','111','',0,1),('023/PP-ITRD/072016','K0115','1.00','111','',0,1),('023/PP-ITRD/072016','R0021','1.00','113','',1,1),('023/PP-ITRD/072016','P0154','1.00','106','',0,1),('023/PP-ITRD/072016','S0086','1.00','112','',0,1),('023/PP-ITRD/072016','W0009','1.00','112','',1,1),('024/PP-ITRD/072016','S0094','1.00','112','',1,1),('001/PP-ITNS/072016','P0135','2.00','108','Pulsa Telkomsel 50 = 3 x untuk operasional Pak Kim. Pulsa Telkomsel 50 = 3 x untuk operasional Cindy. Pulsa Telkomsel 50 = 1 x untuk Administrasi.',0,0),('002/PP-ITNS/072016','J0029','1.00','108','Biaya servis motor operasional dengan nopol H 3928 SA milik Cindy yang digunakan untuk kegiatan operasional PT Indratma Trans Nasional.',1,0),('003/PP-ITNS/072016','K0126','1.00','108','KIR untuk Tronton 8 jatuh tempo pada tanggal 14 Juli 2016. Perpanjangan KIR terakhir pada tanggal 14 Januari 2016.',1,1),('003/PP-SMTH/072016','K0124','1.00','121','',1,1),('025/PP-ITRD/072016','K0101','1.00','114','',1,0),('025/PP-ITRD/072016','B0123','1.00','111','',1,1),('025/PP-ITRD/072016','B0122','1.00','111','',1,1),('025/PP-ITRD/072016','B0120','2.00','105','',1,1),('026/PP-ITRD/072016','P0159','1.00','105','',1,1),('026/PP-ITRD/072016','G0019','1.00','105','',1,1),('026/PP-ITRD/072016','L0069','2.00','105','',0,1),('026/PP-ITRD/072016','S0119','1.00','105','',1,1),('026/PP-ITRD/072016','K0120','1.00','106','',1,1),('004/PP-SMTH/072016','M0014','20.00','121','',0,1),('005/PP-SMTH/072016','K0085','2.00','121','',0,1),('005/PP-SMTH/072016','K0084','2.00','121','',1,1),('006/PP-SMTH/072016','V0044','2.00','121','',0,1),('007/PP-SMTH/072016','K0093','80.00','101','',0,1),('027/PP-ITRD/072016','N0014','30.00','115','',0,0),('028/PP-ITRD/072016','L0074','1.00','105','',1,1),('029/PP-ITRD/072016','F0018','1.00','106','8 Gb',1,1),('029/PP-ITRD/072016','K0120','1.00','106','',1,1),('030/PP-ITRD/072016','T0083','1.00','112','',0,0),('030/PP-ITRD/072016','G0021','1.00','101','',0,0),('011/PP-ISGN/072016','S0105','500.00','118','',0,0),('011/PP-ISGN/072016','S0077','15.00','121','',0,1),('011/PP-ISGN/072016','S0076','15.00','121','',0,1),('031/PP-ITRD/072016','G0018','1.00','122','',1,1),('005/PP-PJSG/072016','M0058','5.00','111','Untuk sarana kerja produksi',0,1),('005/PP-PJSG/072016','S0081','6.00','111','untuk sarana kerja produksi',0,1),('006/PP-PJSG/072016','K0093','20.00','101','untuk perawatan mesin',1,1),('007/PP-PJSG/072016','B0099','1.00','115','Untuk perawatan mesin',1,1),('008/PP-PJSG/072016','V0055','1.00','107','untuk cadangan mesin',1,1),('009/PP-PJSG/072016','B0095','8.00','105','Untuk perawan mesin',1,1),('032/PP-ITRD/072016','B0149','1.00','107','',1,1),('032/PP-ITRD/072016','O0025','1.00','107','',0,1),('033/PP-ITRD/072016','S0096','1.00','106','',1,1),('004/PP-ITNS/072016','P0152','1.00','108','Pulsa XL 50 = 3 X untuk Operasional Pak Kim. Pulsa XL 50 = 2 X untuk Administrasi.',1,0),('034/PP-ITRD/072016','S0118','1.00','105','',0,1),('035/PP-ITRD/072016','T0072','1.00','111','',1,1),('035/PP-ITRD/072016','K0115','1.00','111','',1,1),('035/PP-ITRD/072016','P0154','1.00','106','',1,1),('035/PP-ITRD/072016','S0086','1.00','112','',1,1),('036/PP-ITRD/072016','P0135','1.00','108','',1,0),('036/PP-ITRD/072016','P0132','1.00','108','',1,1),('037/PP-ITRD/072016','T0093','10.00','110','',0,1),('037/PP-ITRD/072016','K0145','10.00','118','',1,1),('037/PP-ITRD/072016','P0188','0.50','101','',1,0),('037/PP-ITRD/072016','P0189','1.00','101','',1,1),('037/PP-ITRD/072016','L0082','2.00','105','',1,1),('037/PP-ITRD/072016','S0121','2.00','105','',1,1),('038/PP-ITRD/072016','K0106','18.00','106','',1,1),('039/PP-ITRD/072016','A0044','4.00','127','',1,0),('039/PP-ITRD/072016','A0045','2.00','129','',1,0),('039/PP-ITRD/072016','K0117','1.00','112','',1,1),('040/PP-ITRD/072016','K0102','1.00','114','',1,0),('040/PP-ITRD/072016','C0025','1.00','105','',1,1),('008/PP-SMTH/072016','P0150','1.00','110','',1,1),('009/PP-SMTH/072016','p0122','1.00','118','',1,1),('010/PP-SMTH/072016','V0038','2.00','121','',1,1),('010/PP-SMTH/072016','V0044','2.00','121','',1,1),('011/PP-SMTH/072016','S0077','30.00','118','',0,1),('012/PP-SMTH/072016','M0050','40.00','121','',0,1),('013/PP-SMTH/072016','K0093','60.00','101','',0,1),('013/PP-SMTH/072016','B0098','20.00','121','',1,1),('013/PP-SMTH/072016','B0095','20.00','121','',1,1),('014/PP-SMTH/072016','M0058','4.00','111','',1,1),('015/PP-SMTH/072016','B0093','2.00','121','',1,1),('016/PP-SMTH/072016','V0031','1.00','123','',1,1),('012/PP-ISGN/072016','B0093','2.00','121','',1,1),('013/PP-ISGN/072016','S0077','15.00','118','',0,1),('041/PP-ITRD/072016','T0074','1.00','113','3 botol warna, 2 botol hitam',0,1),('042/PP-ITRD/072016','J0051','1.00','157','',1,1),('042/PP-ITRD/072016','K0138','42.00','103','',1,1),('042/PP-ITRD/072016','C0030','1.00','121','',1,1),('043/PP-ITRD/072016','J0035','4.00','108','Bulan Juli 4 x pertemuan',1,1),('043/PP-ITRD/072016','J0036','4.00','108','Bulan Juli 4 x pertemuan',1,1),('044/PP-ITRD/072016','W0007','1.00','106','gantung dinding ukuran 90cm x 180 cm',1,1),('014/PP-ISGN/072016','P0168','2.00','107','',1,1),('014/PP-ISGN/072016','S0077','5.00','118','',1,1),('015/PP-ISGN/072016','P0169','1.00','107','',1,1),('015/PP-ISGN/072016','S0076','10.00','118','',0,1),('016/PP-ISGN/072016','S0076','5.00','118','',0,1),('016/PP-ISGN/072016','P0169','2.00','107','',0,1),('001/PP-PJSG/082016','N0010','5.00','116','Untuk sarana kerja',0,1),('001/PP-PJSG/082016','S0095','2.00','116','Untuk sarana kerja',0,1),('002/PP-PJSG/082016','M0058','6.00','111','Untuk sarana kerja produksi',0,1),('002/PP-PJSG/082016','S0082','5.00','111','untuk sarana kerja produksi',1,1),('002/PP-PJSG/082016','S0081','5.00','111','untuk sarana kerja produksi',1,1),('001/PP-ISGN/082016','S0081','4.00','111','',0,1),('001/PP-ISGN/082016','M0058','5.00','111','',0,1),('002/PP-ISGN/082016','P0130','5000.00','110','',0,1),('001/PP-ITNS/082016','S0109','1.00','108','STNK untuk Tronton 8 jatuh tempo pada tanggal 12 Agustus 2016.',0,1),('001/PP-ITRD/082016','L0070','1.00','108','Periode 1-30 Juli 2016',1,1),('001/PP-ITRD/082016','L0071','1.00','108','Periode 1-30 Juli 2016',1,1),('001/PP-ITRD/082016','I0018','1.00','108','Periode 1-30 Juli 2016',1,1),('002/PP-ITRD/082016','J0029','1.00','108','Service flexibel klakson dan airbag',1,1),('003/PP-ITRD/082016','G0021','8.00','101','',0,0),('004/PP-ITRD/082016','N0014','30.00','115','',1,0),('005/PP-ITRD/082016','N0014','30.00','156','untuk 4 minggu di bulan agustus',0,0),('006/PP-ITRD/082016','A0057','1.00','115','',1,1),('006/PP-ITRD/082016','S0085','30.00','115','',1,1),('006/PP-ITRD/082016','J0031','1.00','108','',1,1),('007/PP-ITRD/082016','P0147','2.00','111','',1,1),('008/PP-ITRD/082016','A0044','4.00','127','',0,0),('008/PP-ITRD/082016','A0045','3.00','129','',0,0),('009/PP-ITRD/082016','C0024','1.00','106','',0,0),('010/PP-ITRD/082016','T0074','1.00','113','',1,1),('011/PP-ITRD/082016','T0083','1.00','112','',1,1),('011/PP-ITRD/082016','G0021','1.00','101','',1,1),('012/PP-ITRD/082016','B0115','1.00','111','',1,1),('012/PP-ITRD/082016','B0116','1.00','111','',1,1),('013/PP-ITRD/082016','K0102','1.00','114','',0,0),('013/PP-ITRD/082016','K0101','1.00','114','',0,0),('013/PP-ITRD/082016','B0114','1.00','111','',1,1),('013/PP-ITRD/082016','B0121','1.00','111','',1,1),('003/PP-ISGN/082016','K0132','4.00','121','',1,1),('004/PP-ISGN/082016','D0027','1.00','106','',1,1),('005/PP-ISGN/082016','B0148','1.00','118','',1,1),('001/PP-ISGC/082016','d0016','1.00','106','',0,1),('001/PP-SMNC/082016','P0172','20.00','118','tebal 2 mm, lebar 15 mm, panjang 6000 mm',1,1),('001/PP-SMTH/082016','O0018','2.00','121','untuk cadangan mesin',0,1),('001/PP-SMTH/082016','O0019','2.00','121','untuk cadangan mesin',0,1),('001/PP-SMTH/082016','O0020','2.00','121','untuk cadangan mesin',0,1),('001/PP-SMTH/082016','O0021','2.00','121','untuk cadangan mesin',0,1),('002/PP-SMTH/082016','B0091','2.00','121','',1,1),('002/PP-SMTH/082016','S0080','2.00','121','',1,1),('002/PP-ITNS/082016','P0152','1.00','108','Pulsa XL 50 = 3 X untuk Operasional Pak Kim. Pulsa XL 50 = 2 X untuk Administrasi.',0,0),('014/PP-ITRD/082016','S0096','1.00','106','',1,1),('015/PP-ITRD/082016','K0117','1.00','112','',1,1),('015/PP-ITRD/082016','T0083','1.00','112','',1,1),('003/PP-PJSG/082016','S0109','2.00','108','Untuk perpanjangan STNK colt diesel ( H 1964 EV ) dan L-300 ( H 1963 EV )',0,1),('016/PP-ITRD/082016','I0021','1.00','111','',1,1),('016/PP-ITRD/082016','K0116','2.00','116','',1,1),('017/PP-ITRD/082016','P0132','1.00','108','',0,1),('017/PP-ITRD/082016','P0135','1.00','108','',0,0),('006/PP-ISGN/082016','P0149','35.00','110','untuk tabung',1,1),('006/PP-ISGN/082016','P0139','2.00','110','untuk blower',0,1),('006/PP-ISGN/082016','P0187','2.00','110','untuk ayakan',0,1),('006/PP-ISGN/082016','K0140','4.00','118','UNTUK TRANSMISI',0,1),('006/PP-ISGN/082016','K0141','1.00','118','UNTUK GILINGAN',0,1),('006/PP-ISGN/082016','K0142','3.00','118','utk bahan baku masuk',0,1),('006/PP-ISGN/082016','K0143','10.00','118','utk tiang tabung',0,1),('006/PP-ISGN/082016','K0144','2.00','118','utk tiang katrol',0,1),('006/PP-ISGN/082016','S0120','10.00','118','tebal 5 mm',0,1),('018/PP-ITRD/082016','K0102','1.00','114','',0,0),('018/PP-ITRD/082016','K0101','1.00','114','',0,0),('019/PP-ITRD/082016','I0015','1.00','111','',1,1),('019/PP-ITRD/082016','I0017','1.00','105','',1,1),('019/PP-ITRD/082016','D0033','1.00','105','',1,1),('019/PP-ITRD/082016','B0120','4.00','116','',1,1),('004/PP-ITNS/082016','P0135','1.00','108','Pulsa Telkomsel 50 = 3 x untuk operasional Pak Kim. Pulsa Telkomsel 50 = 3 x untuk operasional Agung. Pulsa Telkomsel 50 = 1 x untuk Administrasi.',0,0),('020/PP-ITRD/082016','P0173','2.00','113','',1,1),('021/PP-ITRD/082016','M0067','20.00','105','',1,0),('007/PP-ISGN/082016','s0050','1.00','106','',0,1),('002/PP-SMNC/082016','d0016','1.00','106','',1,1),('005/PP-ITNS/082016','M0067','10.00','121','Materai untuk penagihan invoice dan administrasi kontrak kerja dengan customers',1,0),('022/PP-ITRD/082016','A0044','4.00','127','',0,0),('022/PP-ITRD/082016','A0045','3.00','129','',0,0),('023/PP-ITRD/082016','T0074','1.00','113','3 botol warna, 2 botol hitam',1,1),('004/PP-PJSG/082016','A0030','10.00','103','Untuk perawatan mesin',1,1),('004/PP-PJSG/082016','D0020','10.00','103','Untuk perawatan mesin',1,1),('004/PP-PJSG/082016','S0076','50.00','118','Untuk perawatan mesin',0,1),('005/PP-PJSG/082016','K0093','20.00','101','Untuk perawatan mesin',0,1),('006/PP-PJSG/082016','V0058','4.00','105','Untuk cadangan mesin',1,1),('008/PP-ISGN/082016','K0151','4.00','121','utk penutup mata,\nutk 2 mesin 2 shift',1,1),('008/PP-ISGN/082016','M0058','5.00','111','',1,1),('008/PP-ISGN/082016','S0081','8.00','111','',0,1),('009/PP-ISGN/082016','S0082','6.00','111','',0,1),('009/PP-ISGN/082016','K0139','2.00','121','',1,1),('010/PP-ISGN/082016','C0021','2.00','121','',0,1),('011/PP-ISGN/082016','D0020','3.00','124','',1,1),('012/PP-ISGN/082016','M0048','100.00','121','',0,1),('012/PP-ISGN/082016','M0049','100.00','121','',0,1),('012/PP-ISGN/082016','M0047','100.00','121','',0,1),('013/PP-ISGN/082016','T0063','4.00','121','',0,1),('013/PP-ISGN/082016','O0020','4.00','121','',0,1),('013/PP-ISGN/082016','T0062','2.00','121','',1,1),('014/PP-ISGN/082016','M0050','25.00','121','',1,1),('006/PP-ITNS/082016','P0135','2.00','108','Pulsa Telkomsel 50 = 3 x untuk operasional Pak Kim. Pulsa Telkomsel 50 = 3 x untuk operasional Agung. Pulsa Telkomsel 50 = 1 x untuk Administrasi.',0,1),('006/PP-ITNS/082016','P0152','2.00','108','Pulsa XL 50 = 3 X untuk Operasional Pak Kim. Pulsa XL 50 = 2 X untuk Administrasi.',1,1),('007/PP-ITNS/082016','P0135','1.00','108','Pulsa Telkomsel 50 = 3 x untuk operasional Pak Kim. Pulsa Telkomsel 50 = 3 x untuk operasional Cindy. Pulsa Telkomsel 50 = 1 x untuk Administrasi.',1,1),('008/PP-ITNS/082016','T0096','1.00','105','Terpal robek ketika perjalanan Semarang - Banyuwangi pada 22 Juni 2016 tepatnya di daerah Pantura, Jawa Tengah. Diperkirakan terpal robek karena ulah orang tidak dikenal karena bagian robek sampai ke muatan berupa terpung terigu.',1,1),('009/PP-ITNS/082016','K0126','1.00','108','KIR untuk Tronton 10 jatuh tempo pada tanggal 1 Agustus 2016.',1,1),('010/PP-ITNS/082016','S0122','9.00','110','3 sticker bertuliskan www.indratmatrans.com berukuran 162 x 12 cm untuk 3 kaca depan armada baru. Dan 6 sticker kecil untuk pintu armada.',1,1),('011/PP-ITNS/082016','S0122','15.00','121','Sticker nomor dengan ukuran 25 x 15 cm untuk keperluan branding tronton Indratma Trans. Nomor dimulai dari 101 - 115.',1,1),('012/PP-ITNS/082016','S0106','1.00','106','Sewa Mobil Untuk Operasional Kantor selama satu bulan',1,1),('013/PP-ITNS/082016','B0136','1.00','106','BAN DALAM 1000 GT   PASANG',1,1),('013/PP-ITNS/082016','J0029','1.00','106','GANTI SILL AS, SILL BURING, DAN SILL KOMPA',1,1),('014/PP-ITNS/082016','M0086','2.00','106','MARSET UNTUK  T10 (H 1858 EZ)',1,1),('015/PP-ITNS/082016','M0067','10.00','121','Materai untuk penagihan invoice dan administrasi kontrak kerja dengan customers',1,0),('015/PP-ISGN/082016','P0179','10.00','121','',0,1),('016/PP-ISGN/082016','P0186','1.00','121','2 jal;ur B AS 24 ml',0,1),('016/PP-ITNS/082016','P0160','1.00','108','Besi kanal C bagian tengah dekat chasis sudah retak. Pintu kedua dari depan bagian kanan terbuka dan tidak bisa dirapatkan kembali dan dinding bak bagian atas sudah bengkok. History pengelasan bak tronton terakhir pada 23 April 2016.',0,1),('003/PP-SMTH/082016','S0077','60.00','118','',0,1),('004/PP-SMTH/082016','M0058','4.00','111','',1,1),('004/PP-SMTH/082016','S0082','3.00','111','',1,1),('004/PP-SMTH/082016','S0081','3.00','111','',1,1),('017/PP-ITNS/082016','T0086','1.00','125','TALI TAMBANG SUDAH BNYK YG PUTUS,,HISTORY PEMBELIAN TERAKHIR 11-Aug-15 ',0,1),('017/PP-ITNS/082016','G0025','1.00','106','GEMBOK UNTUK BAN SEREP RUSAK,, PEMBELIAN TERAKHIR GEMBOK PANJANG 10-Aug-15',1,1),('018/PP-ITNS/082016','T0104','1.00','106','HISTORY PEMBELIAN TERPAL 20-May-15 UKURAN 7x14m (2bh)\n',0,1),('019/PP-ITNS/082016','T0104','1.00','106','HISTORY PEMBELIAN TERPAL 24-Nov-15, UKURAN 7x14m',0,1),('007/PP-PJSG/082016','S0076','35.00','118','untuk perawatan mesin',0,1),('020/PP-ITNS/082016','K0126','1.00','108','KIR untuk Tronton 8 jatuh tempo pada tanggal 17 Agustus 2016 2016.',1,1),('024/PP-ITRD/082016','N0014','35.00','156','untuk 4 minggu di bulan agustus',0,0),('008/PP-PJSG/082016','B0095','8.00','105','Untuk perawatan mesin',0,1),('009/PP-PJSG/082016','M0058','6.00','111','Untuk sarana kerja',0,1),('009/PP-PJSG/082016','S0081','5.00','111','Untuk sarana kerja',0,1),('025/PP-ITRD/082016','A0044','4.00','127','',0,1),('025/PP-ITRD/082016','A0045','2.00','129','',0,1),('026/PP-ITRD/082016','T0072','1.00','111','',0,1),('026/PP-ITRD/082016','W0009','1.00','112','',0,1),('026/PP-ITRD/082016','I0016','1.00','108','',1,1),('027/PP-ITRD/082016','K0145','15.00','118','',1,1),('027/PP-ITRD/082016','T0093','12.00','110','',1,1),('027/PP-ITRD/082016','K0147','10.00','101','',1,1),('027/PP-ITRD/082016','L0084','3.00','101','',1,1),('027/PP-ITRD/082016','P0189','0.50','101','',1,1),('027/PP-ITRD/082016','P0188','0.50','101','',1,1),('027/PP-ITRD/082016','P0192','1.00','101','',1,1),('027/PP-ITRD/082016','B0140','2.00','119','',1,1),('028/PP-ITRD/082016','C0026','1.50','123','',0,1),('029/PP-ITRD/082016','C0026','1.00','123','',1,1),('030/PP-ITRD/082016','K0157','1.00','105','',1,1),('030/PP-ITRD/082016','E0008','1.00','105','',1,1),('030/PP-ITRD/082016','B0106','7.00','118','',1,1),('030/PP-ITRD/082016','K0145','25.00','118','',0,1),('030/PP-ITRD/082016','T0093','25.00','110','',0,1),('030/PP-ITRD/082016','P0188','0.50','110','',0,1),('030/PP-ITRD/082016','P0192','1.00','101','',0,1),('030/PP-ITRD/082016','P0189','1.00','101','',0,1),('030/PP-ITRD/082016','P0191','0.25','101','',1,1),('030/PP-ITRD/082016','P0190','4.00','118','',1,1),('030/PP-ITRD/082016','B0137','1.00','101','',1,1),('030/PP-ITRD/082016','O0027','2.00','120','',1,1),('031/PP-ITRD/082016','C0034','1.00','101','',0,1),('031/PP-ITRD/082016','C0035','1.00','101','',0,1),('031/PP-ITRD/082016','C0036','1.00','101','',0,1),('031/PP-ITRD/082016','C0037','1.00','127','',0,1),('031/PP-ITRD/082016','C0038','1.00','123','',0,1),('031/PP-ITRD/082016','A0055','1.00','103','',1,1),('031/PP-ITRD/082016','I0017','10.00','105','',1,1),('021/PP-ITNS/082016','K0126','1.00','108','KIR T2',0,1),('022/PP-ITNS/082016','P0135','1.00','108','Pulsa Telkomsel 50 = 3 x untuk operasional Pak Kim. Pulsa Telkomsel 50 = 3 x untuk operasional Agung. Pulsa Telkomsel 50 = 1 x untuk Administrasi.',0,1),('023/PP-ITNS/082016','S0104','3.00','108','SPAN SCRUB (PENGAIT RANTAI),, BELI BARU',0,1),('017/PP-ISGN/082016','T0071','2.00','106','tang ampere yang di mesin 2 : rusak \ntang ampere bengkel minta ganti qualitas kurang OK',0,1),('018/PP-ISGN/082016','S0077','30.00','118','',0,1),('018/PP-ISGN/082016','S0076','20.00','118','',0,1),('018/PP-ISGN/082016','S0105','1000.00','121','',0,1),('018/PP-ISGN/082016','P0168','4.00','107','',0,1),('018/PP-ISGN/082016','P0169','4.00','107','',0,1),('019/PP-ISGN/082016','C0031','1.00','115','utk print out timbangan',0,1),('032/PP-ITRD/082016','C0024','1.00','106','',0,1),('033/PP-ITRD/082016','K0102','1.00','114','',0,1),('033/PP-ITRD/082016','K0101','1.00','114','',0,1),('020/PP-ISGN/082016','T0063','4.00','121','',0,1),('034/PP-ITRD/082016','N0014','35.00','156','untuk 4 minggu di bulan agustus',0,1),('005/PP-SMTH/082016','B0155','1.00','106','untuk pemisah sambungan listrik antara kantor dan bengkel',0,1),('006/PP-SMTH/082016','B0154','1.00','106','untuk cadangan panel mesin',0,1),('007/PP-SMTH/082016','G0024','1.00','106','untuk gear box bahan masuk',0,1),('008/PP-SMTH/082016','L0086','2.00','105','untuk bengkel dan mandor dipabrik cuma ada 1 untuk satpam',0,1),('021/PP-ISGN/082016','K0093','20.00','101','',0,1),('021/PP-ISGN/082016','B0095','5.00','121','',0,1),('021/PP-ISGN/082016','B0099','25.00','121','',0,1),('022/PP-ISGN/082016','M0079','1.00','106','',0,1);

/*Table structure for table `permintaanpembelian_detail_temp` */


CREATE TABLE `permintaanpembelian_detail_temp` (
  `userid` varchar(30) DEFAULT NULL,
  `kodebrg` varchar(5) DEFAULT NULL,
  `saldoawal` decimal(15,2) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `ket` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `permintaanpembelian_detail_temp` */

insert  into `permintaanpembelian_detail_temp`(userid,kodebrg,saldoawal,jml,kodesatuan,ket) values ('deroi','J0051','1.00','1.00','157',''),('deroi','K0138','42.00','42.00','103',''),('deroi','C0030','1.00','1.00','121','');

/*Table structure for table `permintaanpembelian_detail_temp_uckup` */


CREATE TABLE `permintaanpembelian_detail_temp_uckup` (
  `userid` varchar(30) DEFAULT NULL,
  `kodebrg` varchar(5) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `permintaanpembelian_detail_temp_uckup` */

/*Table structure for table `permohonanfee_detail` */


CREATE TABLE `permohonanfee_detail` (
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `jnspenerima` int(1) DEFAULT NULL,
  `penerima` varchar(20) DEFAULT NULL,
  `kodebank` varchar(5) DEFAULT NULL,
  `norek_tujuan` varchar(50) DEFAULT NULL,
  `kodecustomer` varchar(6) DEFAULT NULL,
  `kodearmada` varchar(6) DEFAULT NULL,
  `biayasewa` decimal(15,2) DEFAULT NULL,
  `ujs` decimal(15,2) DEFAULT NULL,
  `sewabersih` decimal(15,2) DEFAULT NULL,
  `fee` decimal(15,2) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `permohonanfee_detail` */

/*Table structure for table `permohonanfee_detail_temp` */


CREATE TABLE `permohonanfee_detail_temp` (
  `kodecustomer` varchar(6) DEFAULT NULL,
  `kodearmada` varchar(6) DEFAULT NULL,
  `biayasewa` decimal(15,2) DEFAULT NULL,
  `ujs` decimal(15,2) DEFAULT NULL,
  `sewabersih` decimal(15,2) DEFAULT NULL,
  `fee` decimal(15,2) DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `permohonanfee_detail_temp` */

/*Table structure for table `perusahaan` */


CREATE TABLE `perusahaan` (
  `index_perusahaan` int(2) DEFAULT NULL,
  `kode_perusahaan` varchar(5) NOT NULL DEFAULT '',
  `namaperusahaan` varchar(50) DEFAULT NULL,
  `tampilanlain` varchar(50) DEFAULT NULL,
  `alamat` varchar(80) DEFAULT NULL,
  `notelp` varchar(20) DEFAULT NULL,
  `kota` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `perusahaan` */

insert  into `perusahaan`(index_perusahaan,kode_perusahaan,namaperusahaan,tampilanlain,alamat,notelp,kota) values (2,'ISGN','INDRATMA SAHITAGUNA MIJEN','Indratma Sahitaguna Mijen','Jl. Raya Demak - Jepara KM 10 Mijen','0291-500000','Demak'),(3,'PJSG','INDRATMA SAHITAGUNA KARANGJATI','Indratma Sahitaguna Karangjati','Jl. Raya PTP XVIII Ngobo Bergas Karangjati','0298-525006','Ungaran'),(4,'SMTH','PT SINAR MATAHARI NASIONAL','PT Sinar Matahari Nasional','Jl. Tembus Ujung Batu RT 04/06 Pengkol','0291-593828','Jepara'),(1,'ITRD','INDRATMA CORPORATION','Indratma Corporation','Jl. Raya Kedungmundu 18C-D','024-76747916','Semarang'),(5,'ITNS','INDRATMA TRANS','Indratma Trans','Jl. Raya Kedungmundu 18C-D','024-76747916','Semarang'),(6,'ISGB','INDRATMA SAHITAGUNA BRIQUETTE','Indratma Sahitaguna Briquette','Jl. Raya PTP XVIII Ngobo Bergas Karangjati','0298-525006','Ungaran'),(7,'SMNC','PT SINAR MATAHARI NASIONAL COIL','PT Sinar Matahari Nasional Coil','Jl. Tembus Ujung Batu RT 04/06 Pengkol','0291-593828','Jepara');

/*Table structure for table `ponote` */


CREATE TABLE `ponote` (
  `nopo` varchar(20) DEFAULT NULL,
  `nourut` int(1) DEFAULT NULL,
  `ket` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ponote` */

/*Table structure for table `ponote_temp` */


CREATE TABLE `ponote_temp` (
  `nourut` int(1) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `ket` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ponote_temp` */

insert  into `ponote_temp`(nourut,userid,ket) values (1,'ayuproc',''),(2,'ayuproc',''),(3,'ayuproc',''),(1,'bagus',''),(2,'bagus',''),(3,'bagus',''),(1,'alika',''),(2,'alika',''),(3,'alika',''),(1,'admin',''),(2,'admin',''),(3,'admin',''),(1,'deroi',''),(2,'deroi',''),(3,'deroi','');

/*Table structure for table `purchaseorder` */


CREATE TABLE `purchaseorder` (
  `kodeperusahaan` varchar(4) DEFAULT NULL,
  `nopo` varchar(20) DEFAULT NULL,
  `tglpo` datetime DEFAULT NULL,
  `kodevendor` varchar(10) DEFAULT NULL,
  `creator` varchar(20) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `noref` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `purchaseorder` */

/*Table structure for table `purchaseorder_detail` */


CREATE TABLE `purchaseorder_detail` (
  `nopo` varchar(18) DEFAULT NULL,
  `kodebrg` varchar(5) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `ket` varchar(150) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtot` decimal(15,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `purchaseorder_detail` */

/*Table structure for table `purchaseorder_detail_temp` */


CREATE TABLE `purchaseorder_detail_temp` (
  `userid` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(10) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtot` decimal(15,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `purchaseorder_detail_temp` */

/*Table structure for table `returpembelian` */


CREATE TABLE `returpembelian` (
  `kodeperusahaan` varchar(20) DEFAULT NULL,
  `kodereturbeli` varchar(20) DEFAULT NULL,
  `kodepembelian` varchar(20) DEFAULT NULL,
  `kodetbtolak` varchar(20) DEFAULT NULL,
  `tglretur` datetime DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `returpembelian` */

/*Table structure for table `returpembelian_detail` */


CREATE TABLE `returpembelian_detail` (
  `kodereturbeli` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtot` decimal(15,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `returpembelian_detail` */

/*Table structure for table `returpembelian_detail_temp` */


CREATE TABLE `returpembelian_detail_temp` (
  `userid` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtot` decimal(15,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `returpembelian_detail_temp` */

/*Table structure for table `saldo_pengajuanbrg` */


CREATE TABLE `saldo_pengajuanbrg` (
  `lokasi` varchar(5) DEFAULT NULL,
  `kodetrx` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(5) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `saldo_pengajuanbrg` */

/*Table structure for table `satuan` */


CREATE TABLE `satuan` (
  `kodesatuan` varchar(3) DEFAULT NULL,
  `namasatuan` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `satuan` */

insert  into `satuan`(kodesatuan,namasatuan) values ('101','Kg'),('102','Gr'),('103','Meter'),('104','Liter'),('105','Buah'),('106','Unit'),('107','Set'),('108','X'),('109','Rit'),('110','Lembar'),('111','Pack'),('112','bgks'),('113','botol'),('114','rim'),('115','dus'),('116','buku'),('117','Pertemuan'),('118','batang'),('119','gulung'),('120','kaleng'),('121','PCS'),('122','tabung'),('123','pill'),('124','m'),('125','roll'),('126','gendel'),('127','galon'),('128','ribu'),('129','jerigen'),('130','tangki'),('131','plek'),('132','sachet'),('133','juta'),('134','sak'),('135','hari'),('136','kwh'),('137','batu kris'),('149','cm'),('150','krat'),('153','ikat'),('154','pasang'),('155','bulan'),('156','Box'),('157','Lot');

/*Table structure for table `setting_approval` */


CREATE TABLE `setting_approval` (
  `kodeperusahaan` varchar(4) DEFAULT NULL,
  `kddivisi_pemohon` varchar(3) DEFAULT NULL,
  `jenispengajuan` varchar(3) DEFAULT NULL,
  `kodeproses` int(1) DEFAULT NULL,
  `kodesign` varchar(3) DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `setting_approval` */

insert  into `setting_approval`(kodeperusahaan,kddivisi_pemohon,jenispengajuan,kodeproses,kodesign,tglentry,userid) values ('SMTH','206','4',1,'306','2016-06-11 10:13:27','whardah'),('SMTH','206','4',2,'102','2016-06-11 10:13:44','whardah'),('SMTH','206','4',3,'106','2016-06-11 10:13:54','whardah'),('SMTH','206','4',4,'109','2016-06-11 10:14:00','whardah'),('ISGB','206','4',1,'102','2016-06-11 10:15:15','whardah'),('ISGB','206','4',2,'106','2016-06-11 10:15:20','whardah'),('ISGB','206','4',3,'109','2016-06-11 10:15:24','whardah'),('PJSG','206','4',1,'102','2016-06-11 10:17:52','whardah'),('PJSG','206','4',2,'106','2016-06-11 10:17:59','whardah'),('PJSG','206','4',3,'109','2016-06-11 10:18:04','whardah'),('SMNC','206','4',1,'306','2016-06-11 10:19:10','whardah'),('SMNC','206','4',2,'102','2016-06-11 10:19:14','whardah'),('SMNC','206','4',3,'106','2016-06-11 10:19:22','whardah'),('SMNC','206','4',4,'177','2016-06-11 10:19:26','whardah'),('ISGN','206','4',1,'306','2016-06-11 10:20:22','whardah'),('ISGN','206','4',2,'102','2016-06-11 10:20:25','whardah'),('ISGN','206','4',3,'106','2016-06-11 10:20:29','whardah'),('ISGN','206','4',4,'177','2016-06-11 10:20:34','whardah'),('ITNS','206','4',1,'109','2016-06-11 10:21:06','whardah'),('ITRD','206','4',1,'106','2016-06-13 13:06:28','whardah'),('ITRD','206','4',2,'302','2016-06-13 13:06:33','whardah'),('ITRD','206','4',3,'101','2016-06-13 13:06:38','whardah'),('ITRD','206','5',1,'106','2016-06-13 13:31:01','admin'),('ITRD','206','5',2,'302','2016-06-13 13:31:08','admin'),('ITRD','206','5',3,'101','2016-06-13 13:31:12','admin'),('PJSG','206','5',1,'102','2016-06-14 08:06:05','admin'),('PJSG','206','5',2,'106','2016-06-14 08:06:31','admin'),('PJSG','206','5',3,'109','2016-06-14 08:06:36','admin'),('PJSG','206','5',4,'188','2016-06-14 08:06:44','admin'),('PJSG','206','5',5,'107','2016-06-14 08:06:57','admin'),('PJSG','206','5',6,'302','2016-06-14 08:07:06','admin'),('PJSG','206','5',7,'101','2016-06-14 08:07:14','admin'),('ISGB','206','5',1,'102','2016-06-14 08:07:56','admin'),('ISGB','206','5',2,'106','2016-06-14 08:08:01','admin'),('ISGB','206','5',3,'109','2016-06-14 08:08:12','admin'),('ISGB','206','5',4,'188','2016-06-14 08:08:17','admin'),('ISGB','206','5',5,'107','2016-06-14 08:08:28','admin'),('ISGB','206','5',6,'302','2016-06-14 08:08:44','admin'),('ISGB','206','5',7,'101','2016-06-14 08:08:51','admin'),('ISGN','206','5',1,'306','2016-06-14 08:09:28','admin'),('ISGN','206','5',2,'102','2016-06-14 08:09:34','admin'),('ISGN','206','5',3,'106','2016-06-14 08:09:39','admin'),('ISGN','206','5',4,'177','2016-06-14 08:09:45','admin'),('ISGN','206','5',5,'188','2016-06-14 08:09:52','admin'),('ISGN','206','5',6,'107','2016-06-14 08:10:00','admin'),('ISGN','206','5',7,'302','2016-06-14 08:10:07','admin'),('ISGN','206','5',8,'101','2016-06-14 08:10:13','admin'),('SMTH','206','5',1,'306','2016-06-14 08:18:12','admin'),('SMTH','206','5',2,'102','2016-06-14 08:18:19','admin'),('SMTH','206','5',3,'106','2016-06-14 08:18:25','admin'),('SMTH','206','5',4,'109','2016-06-14 08:18:31','admin'),('SMTH','206','5',5,'188','2016-06-14 08:18:35','admin'),('SMTH','206','5',6,'107','2016-06-14 08:18:42','admin'),('SMTH','206','5',7,'302','2016-06-14 08:19:04','admin'),('SMTH','206','5',8,'101','2016-06-14 08:19:10','admin'),('SMNC','206','5',1,'306','2016-06-14 08:19:50','admin'),('SMNC','206','5',2,'102','2016-06-14 08:19:55','admin'),('SMNC','206','5',3,'106','2016-06-14 08:20:00','admin'),('SMNC','206','5',4,'177','2016-06-14 08:20:07','admin'),('SMNC','206','5',5,'188','2016-06-14 08:20:10','admin'),('SMNC','206','5',6,'107','2016-06-14 08:20:16','admin'),('SMNC','206','5',7,'302','2016-06-14 08:20:24','admin'),('SMNC','206','5',8,'101','2016-06-14 08:20:30','admin'),('ISGB','206','4',4,'188','2016-06-15 09:09:53','admin'),('ISGB','206','4',5,'107','2016-06-15 09:10:08','admin'),('ISGB','206','4',6,'302','2016-06-15 09:10:15','admin'),('ISGB','206','4',7,'101','2016-06-15 09:10:20','admin'),('PJSG','206','4',4,'188','2016-06-15 09:10:59','admin'),('PJSG','206','4',5,'107','2016-06-15 09:11:05','admin'),('PJSG','206','4',6,'302','2016-06-15 09:11:20','admin'),('PJSG','206','4',7,'101','2016-06-15 09:11:24','admin'),('ISGN','206','4',5,'188','2016-06-15 09:12:03','admin'),('ISGN','206','4',6,'107','2016-06-15 09:12:17','admin'),('ISGN','206','4',7,'302','2016-06-15 09:12:24','admin'),('ISGN','206','4',8,'101','2016-06-15 09:12:29','admin'),('SMTH','206','4',5,'188','2016-06-15 09:13:09','admin'),('SMTH','206','4',6,'107','2016-06-15 09:13:18','admin'),('SMTH','206','4',7,'302','2016-06-15 09:13:23','admin'),('SMTH','206','4',8,'101','2016-06-15 09:13:27','admin'),('SMNC','206','4',5,'188','2016-06-15 09:13:56','admin'),('SMNC','206','4',6,'107','2016-06-15 09:14:03','admin'),('SMNC','206','4',7,'302','2016-06-15 09:14:16','admin'),('SMNC','206','4',8,'101','2016-06-15 09:14:20','admin'),('ITNS','206','5',1,'109','2016-06-15 10:18:40','admin'),('ITNS','206','4',2,'201','2016-08-01 10:46:09','admin'),('ITNS','206','4',3,'101','2016-08-01 10:46:15','admin'),('ITNS','206','4',4,'106','2016-08-01 10:46:22','admin'),('ITNS','206','4',5,'302','2016-08-01 10:46:28','admin'),('ITNS','206','4',6,'100','2016-08-01 10:46:33','admin'),('ITNS','206','5',2,'201','2016-08-01 10:48:03','admin'),('ITNS','206','5',3,'101','2016-08-01 10:48:08','admin'),('ITNS','206','5',4,'106','2016-08-01 10:48:18','admin'),('ITNS','206','5',5,'302','2016-08-01 10:48:31','admin'),('ITNS','206','5',6,'100','2016-08-01 10:48:43','admin'),('ISGB','206','6',1,'109','2016-08-05 13:15:05','whardah'),('ISGB','206','6',2,'303','2016-08-05 13:15:13','whardah'),('ISGB','206','6',3,'302','2016-08-05 13:15:18','whardah'),('PJSG','206','6',1,'109','2016-08-05 13:15:47','whardah'),('PJSG','206','6',2,'303','2016-08-05 13:15:51','whardah'),('PJSG','206','6',3,'302','2016-08-05 13:15:55','whardah'),('ISGN','206','6',1,'109','2016-08-05 13:16:11','whardah'),('ISGN','206','6',2,'303','2016-08-05 13:16:15','whardah'),('ISGN','206','6',3,'302','2016-08-05 13:16:18','whardah'),('SMTH','206','6',1,'109','2016-08-05 13:16:31','whardah'),('SMTH','206','6',2,'303','2016-08-05 13:16:35','whardah'),('SMTH','206','6',3,'302','2016-08-05 13:16:37','whardah'),('SMNC','206','6',1,'109','2016-08-05 13:16:52','whardah'),('SMNC','206','6',2,'303','2016-08-05 13:16:56','whardah'),('SMNC','206','6',3,'302','2016-08-05 13:16:59','whardah'),('ITRD','202','7',1,'311','2016-08-15 08:49:10','whardah'),('ITRD','202','7',2,'101','2016-08-15 08:49:13','whardah'),('ITRD','200','7',1,'311','2016-08-15 08:49:26','whardah'),('ITRD','200','7',2,'101','2016-08-15 08:49:29','whardah'),('ITRD','204','7',1,'311','2016-08-15 08:49:43','whardah'),('ITRD','204','7',2,'101','2016-08-15 08:49:46','whardah'),('ITRD','203','7',1,'311','2016-08-15 08:49:59','whardah'),('ITRD','203','7',2,'101','2016-08-15 08:50:02','whardah'),('ITRD','201','7',1,'311','2016-08-15 08:50:18','whardah'),('ITRD','201','7',2,'101','2016-08-15 08:50:22','whardah'),('ITNS','212','7',1,'311','2016-08-15 08:50:34','whardah'),('ITNS','212','7',2,'101','2016-08-15 08:50:38','whardah');

/*Table structure for table `signas` */


CREATE TABLE `signas` (
  `kodesign` varchar(20) DEFAULT NULL,
  `ket` varchar(50) DEFAULT NULL,
  `caption` varchar(50) DEFAULT NULL,
  `kddivisi` varchar(3) DEFAULT NULL,
  `leveljab` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `signas` */

insert  into `signas`(kodesign,ket,caption,kddivisi,leveljab) values ('101','Direktur','Direktur','000',1),('102','Kepala Pabrik','Ka Pabrik','000',2),('302','Divisi Finance','Ka Finance','000',4),('106','Divisi Procurement Kantor Pusat','Procurement Pusat','000',8),('104','Divisi Procurement Pabrik','Procurement Pabrik','000',9),('306','Kepala Produksi','Ka Produksi','000',11),('411','For All',NULL,NULL,NULL),('100','Komisaris','Komisaris','000',0),('307','Divisi Marketing','Manager Marketing','203',100),('308','Divisi IT','SPV Divisi IT','204',100),('309','Divisi Logistik','Ka Logistik','207',100),('310','Divisi Bengkel','Ka Bengkel','208',100),('108','SPV Divisi Accounting','SPV Accounting','000',6),('107','Chief Divisi Accounting','Chief Accounting','000',5),('103','Kepala Kantor Pusat','Ka Kantor','000',3),('109','Divisi Accounting','Accounting','000',7),('200','Divisi Management','Management','000',10),('199','Direktur Indratma Trans','Direktur','101',100),('188','Plh SPV Divisi Accounting','Plh SPV Accounting','000',12),('177','Plh Divisi Accounting','Plh Accounting','000',13),('201','Divisi Operasional','Ka Opersional','000',100),('303','Divisi Finance','Finance','000',4),('311','Divisi General Affair','Ka HRD&GA','000',100);

/*Table structure for table `signature` */


CREATE TABLE `signature` (
  `nik` varchar(20) DEFAULT NULL,
  `path` varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `signature` */

insert  into `signature`(nik,path) values ('ISGN20150717001','img/ISGN20150717001.jpg'),('ITNS20150101009','img/ITNS20150101009.jpg'),('ITRD20000101001','img/ITRD20000101001.jpg'),('ITRD20080101004','img/ITRD20080101004.jpg'),('ITRD20080101011','img/ITRD20080101011.jpg'),('ITRD20120101010','img/ITRD20120101010.jpg'),('ITRD20140101002','img/ITRD20140101002.jpg'),('ITRD20140523003','img/ITRD20140523003.jpg'),('ITRD20150601009','img/ITRD20150601009.jpg'),('ITRD20150608008','img/ITRD20150608008.jpg'),('ITRD20160114012','img/ITRD20160114012.jpg'),('PJSG20080101058','img/PJSG20080101058.jpg'),('SMTH20150101102','img/SMTH20150101102.jpg'),('SMTH20140117001','img/SMTH20140117001.jpg'),('ITRD20150301016','img/PJSG20080101058.jpg'),('PJSG20150615201','img/PJSG20150615201.jpg'),('ISGN20080601003','img/SMTH20150101102.jpg'),('SMTH20150701117','img/ITRD20150601009.jpg'),('ISGB20120101010','img/ITRD20120101010.jpg'),('ISGB20150615201','img/PJSG20150615201.jpg'),('ISGB20080101058','img/PJSG20080101058.jpg'),('ISGB20080101221','img/PJSG20080101058.jpg'),('ISGC20150101102','img/SMTH20150101102.jpg'),('SMTH20150615119','img/PJSG20150615201.jpg'),('SMNC20150615119','img/PJSG20150615201.jpg'),('ISGN20140601004','img/PJSG20080101058.jpg'),('SMNC20140601120','img/PJSG20080101058.jpg'),('ITNS20160601013','img/ITNS20160601013.jpg'),('ITRD20160801022','img/ITRD20160801022.jpg');

/*Table structure for table `signaturex` */


CREATE TABLE `signaturex` (
  `nik` varchar(20) DEFAULT NULL,
  `path` varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `signaturex` */

insert  into `signaturex`(nik,path) values ('ISGN20150717001','img/ISGN20150717001.jpg'),('ITNS20150101009','img/ITNS20150101009.jpg'),('ITRD20000101001','img/ITRD20000101001.jpg'),('ITRD20080101004','img/ITRD20080101004.jpg'),('ITRD20080101011','img/ITRD20080101011.jpg'),('ITRD20120101010','img/ITRD20120101010.jpg'),('ITRD20140101002','img/ITRD20140101002.jpg'),('ITRD20140523003','img/ITRD20140523003.jpg'),('ITRD20150601009','img/ITRD20150601009.jpg'),('ITRD20150608008','img/ITRD20150608008.jpg'),('ITRD20160114012','img/ITRD20160114012.jpg'),('PJSG20080101058','img/PJSG20080101058.jpg'),('SMTH20150101102','img/ITRD20120101010.jpg');

/*Table structure for table `supplier` */


CREATE TABLE `supplier` (
  `kode_perusahaan` varchar(4) DEFAULT NULL,
  `kode_supplier` varchar(6) DEFAULT NULL,
  `nama_supplier` varchar(50) DEFAULT NULL,
  `ktp` varchar(30) DEFAULT NULL,
  `alamat` varchar(50) DEFAULT NULL,
  `notelp` varchar(15) DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(15) DEFAULT NULL,
  `onview` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `supplier` */

insert  into `supplier`(kode_perusahaan,kode_supplier,nama_supplier,ktp,alamat,notelp,tglentry,userid,onview) values ('SMTH','SP0002','TARJO',NULL,'PURWOREJO','081199900','2015-10-04 20:24:59','deroi',1),('PJSG','SP0001','SAMITRO',NULL,'MADIUN JAWA TIMUR','2345','2015-10-04 20:18:47','deroi',1),('PJSG','SP0003','TATANG',NULL,'Cirebon','081111','2015-10-04 20:20:14','deroi',1),('PJSG','SP0004','P. Iwan',NULL,'','081','2015-11-19 13:38:20','putri',1),('PJSG','SP0005','P. Mufar Kertosono',NULL,'','0812','2015-11-19 13:39:00','putri',1),('PJSG','SP0006','P. Sugeng',NULL,'','0888','2015-11-19 13:39:39','putri',1),('PJSG','SP0007','Bu Halimah',NULL,'','08882','2015-11-19 13:40:00','putri',1),('PJSG','SP0008','Bu Susi',NULL,'','0812','2015-11-19 13:55:18','putri',1),('PJSG','SP0009','P. Zaenal',NULL,'','0888','2015-11-23 11:14:30','putri',1),('PJSG','SP0010','Mbk Nita',NULL,'','024','2015-11-23 11:17:19','putri',1),('PJSG','SP0011','P Rusiadi',NULL,'','0876','2015-11-23 11:21:01','putri',1),('PJSG','SP0012','P Fandi',NULL,'','0812','2015-11-23 11:29:18','putri',1),('PJSG','SP0013','P Agus',NULL,'','0888','2015-11-23 11:37:46','putri',1),('PJSG','SP0014','Bu Asromah',NULL,'Jl Lurus Km 5 Jogja','08889','2015-11-23 13:23:48','putri',1),('PJSG','SP0015','Pak Yatno',NULL,'','0821','2015-11-23 13:26:20','putri',1),('PJSG','SP0016','Bu Haji',NULL,'','0212','2015-11-23 13:54:23','putri',1),('PJSG','SP0017','P Heri',NULL,'','0888','2015-11-30 14:07:39','intan',1),('PJSG','SP0018','P Ali',NULL,'','0888','2015-11-30 14:15:44','intan',1),('PJSG','SP0019','Bu Sur',NULL,'','0888','2015-11-30 14:15:56','intan',1),('PJSG','SP0020','P Mufar Madura',NULL,'','0','2015-12-08 15:15:07','putri',1),('PJSG','SP0021','P Agus Blora',NULL,'','0','2015-12-08 15:19:34','putri',1),('PJSG','SP0022','P Munadi',NULL,'','0','2015-12-08 15:19:54','putri',1),('PJSG','SP0023','P Mufar Jombang',NULL,'','0','2015-12-08 15:21:58','putri',1),('PJSG','SP0024','P Mufar Situbondo',NULL,'','0','2015-12-08 15:22:18','putri',1),('PJSG','SP0025','Sragen',NULL,'','0','2015-12-08 15:22:40','putri',1),('PJSG','SP0026','AS',NULL,'AS','3232','2016-02-12 13:56:56','admin',0),('PJSG','SP0027','TATANG','2344','CIREBON','081111223344','2016-02-13 14:51:12','admin',1),('ITNS','SP0028','BU MALA (MARKET PT HUTOMO TATA MANDIRI)','81','TANGERANG','081','2016-04-01 09:15:00','yana',1),('SMTH','SP0029','MUHAMMAD ALI MAKSUM','3374047109780001','BANGET AYU WETAN RT 002 RW 004','0','2016-04-06 09:42:18','admin',1);

/*Table structure for table `terimabrg_ditolak` */


CREATE TABLE `terimabrg_ditolak` (
  `kodetbtolak` varchar(20) DEFAULT NULL,
  `kodepengiriman` varchar(20) DEFAULT NULL,
  `pengirim` varchar(20) DEFAULT NULL,
  `tglterima` date DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `kodetolak` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `terimabrg_ditolak` */

/*Table structure for table `terimabrg_ditolak_detail` */


CREATE TABLE `terimabrg_ditolak_detail` (
  `kodetbtolak` varchar(20) DEFAULT NULL,
  `kodepembelian` varchar(20) DEFAULT NULL,
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `terimabrg_ditolak_detail` */

/*Table structure for table `terimabrg_ganti` */


CREATE TABLE `terimabrg_ganti` (
  `kodetbganti` varchar(20) DEFAULT NULL,
  `kodereturbeli` varchar(20) DEFAULT NULL,
  `tglterima` date DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `pelaksana` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `terimabrg_ganti` */

/*Table structure for table `terimabrg_ganti_detail` */


CREATE TABLE `terimabrg_ganti_detail` (
  `kodetbganti` varchar(20) DEFAULT NULL,
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtot` decimal(15,2) DEFAULT NULL,
  `terkirim` varchar(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `terimabrg_ganti_detail` */

/*Table structure for table `terimabrg_ganti_detail_temp` */


CREATE TABLE `terimabrg_ganti_detail_temp` (
  `kodereturbeli` varbinary(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtot` decimal(15,2) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `terimabrg_ganti_detail_temp` */

/*Table structure for table `tolakpengiriman` */


CREATE TABLE `tolakpengiriman` (
  `kodepengajuan` varchar(20) DEFAULT NULL,
  `kodetolak` varchar(20) DEFAULT NULL,
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `kodepembelian` varchar(20) DEFAULT NULL,
  `kodepengiriman` varchar(20) DEFAULT NULL,
  `tgltolak` date DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tolakpengiriman` */

insert  into `tolakpengiriman`(kodepengajuan,kodetolak,kodepermintaan,kodepembelian,kodepengiriman,tgltolak,tglentry,userid) values ('016/PB-ISGN/082016','001/TL-ISGN/082016','013/PP-ISGN/082016','037/BL-ISGN/082016','014/SJ-ISGN/082016','2016-08-10','2016-08-12 13:34:42','nurul'),('048/PB-ISGN/062016','002/TL-ISGN/082016','016/PP-ISGN/072016','022/BL-ISGN/082016','011/SJ-ISGN/082016','2016-07-23','2016-08-12 13:38:44','nurul');

/*Table structure for table `tolakpengiriman_detail` */


CREATE TABLE `tolakpengiriman_detail` (
  `kodetolak` varchar(20) DEFAULT NULL,
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `kodepembelian` varchar(20) DEFAULT NULL,
  `kodebrg` varchar(6) DEFAULT NULL,
  `jml` decimal(15,2) DEFAULT NULL,
  `kodesatuan` varchar(3) DEFAULT NULL,
  `alasan` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tolakpengiriman_detail` */

insert  into `tolakpengiriman_detail`(kodetolak,kodepermintaan,kodepembelian,kodebrg,jml,kodesatuan,alasan) values ('001/TL-ISGN/082016','013/PP-ISGN/082016','037/BL-ISGN/082016','O0020','1.00','121','hanya menerima 3'),('002/TL-ISGN/082016','016/PP-ISGN/072016','022/BL-ISGN/082016','P0169','1.00','107','hny menerima 1 set');

/*Table structure for table `trxnote` */


CREATE TABLE `trxnote` (
  `notrx` varchar(20) DEFAULT NULL,
  `nourut` int(1) DEFAULT NULL,
  `ket` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `trxnote` */

/*Table structure for table `upload_files` */


CREATE TABLE `upload_files` (
  `kodepermintaan` varchar(20) DEFAULT NULL,
  `index_upload` varchar(4) DEFAULT NULL,
  `nama_file` varchar(200) DEFAULT NULL,
  `direktori_file` varchar(200) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `upload_files` */

insert  into `upload_files`(kodepermintaan,index_upload,nama_file,direktori_file,userid) values ('008/PB-ISGC/052016','1','IMG_20160601_0002.jpg','files/IMG_20160601_0002.jpg','nurulcoil'),('001/PD-SMNC/062016','1','..jpg','files/..jpg','ayu'),('033/PB-ITNS/062016','1','1.jpg','files/1.jpg','lina'),('033/PB-ITNS/062016','2','2.jpg','files/2.jpg','lina'),('033/PB-ITNS/062016','3','3.jpg','files/3.jpg','lina'),('039/PB-ITNS/062016','1','6.jpg','files/6.jpg','lina'),('039/PB-ITNS/062016','2','7.jpg','files/7.jpg','lina'),('039/PB-ITNS/062016','3','8.jpg','files/8.jpg','lina'),('039/PB-ITNS/062016','4','9.jpg','files/9.jpg','lina'),('041/PB-ITNS/062016','1','4.jpg','files/4.jpg','lina'),('041/PB-ITNS/062016','2','5.jpg','files/5.jpg','lina'),('054/PB-ISGN/062016','1','BA Dynamo.jpg','files/BA Dynamo.jpg','nurul'),('002/PD-SMNC/072016','1','Kode billing izin Percobaan COBRA 0.3 MC-1.jpg','files/Kode billing izin Percobaan COBRA 0.3 MC-1.jpg','ayu'),('012/PB-ITNS/072016','1','kwitansi isuzu.JPG','files/kwitansi isuzu.JPG','ayu'),('011/PB-ITNS/072016','1','kwitansi oli t.6.JPG','files/kwitansi oli t.6.JPG','ayu'),('021/PB-ITRD/072016','1','global 108.JPG','files/global 108.JPG','ayu'),('023/PB-ITRD/072016','1','KWITANSI XENIA.JPG','files/KWITANSI XENIA.JPG','ayu'),('027/PB-SMTH/072016','1','KWITANSI REWENDING.JPG','files/KWITANSI REWENDING.JPG','ayu'),('002/PD-ISGB/072016','1','genset.JPG','files/genset.JPG','ayu'),('026/PB-ITRD/072016','1','nota xenia.JPG','files/nota xenia.JPG','ayu'),('016/PB-ITNS/072016','1','kwitansi t.5.JPG','files/kwitansi t.5.JPG','ayu'),('023/PB-ITNS/072016','1','yana creiwis.JPG','files/yana creiwis.JPG','ayu'),('021/PB-ITNS/072016','1','.jpg','files/.jpg','ayu'),('021/PB-ITNS/072016','2','nota T2.jpg','files/nota T2.jpg','ayu'),('015/PB-ITNS/072016','1','kwitansi t.8.JPG','files/kwitansi t.8.JPG','ayu'),('001/PD-ISGB/082016','1','overweight.JPG','files/overweight.JPG','ayu'),('003/PB-ITNS/082016','1','BA mobil trans.JPG','files/BA mobil trans.JPG','ayu'),('020/PB-ITNS/082016','1','IMG-20160808-WA0003.jpg','files/IMG-20160808-WA0003.jpg','alfi'),('020/PB-ITNS/082016','2','IMG-20160808-WA0004.jpg','files/IMG-20160808-WA0004.jpg','alfi'),('021/PB-ITNS/082016','1','IMG-20160808-WA0000.jpg','files/IMG-20160808-WA0000.jpg','alfi'),('021/PB-ITNS/082016','2','IMG-20160808-WA0001.jpg','files/IMG-20160808-WA0001.jpg','alfi'),('026/PB-ITNS/082016','1','IMG-20160810-WA0000.jpg','files/IMG-20160810-WA0000.jpg','ayu'),('025/PB-ITNS/082016','1','t.4.JPG','files/t.4.JPG','ayu'),('017/PB-ITNS/082016','1','ban t.3.JPG','files/ban t.3.JPG','ayu'),('018/PB-ITNS/082016','1','stemplet t.6.JPG','files/stemplet t.6.JPG','ayu'),('001/PD-ISGN/082016','1','listrik mijen 3.JPG','files/listrik mijen 3.JPG','ayu'),('001/PD-ISGN/082016','2','listrik mijen .JPG','files/listrik mijen .JPG','ayu'),('001/PD-ISGN/082016','3','listrik mijen 1.JPG','files/listrik mijen 1.JPG','ayu'),('001/PD-ITRD/082016','1','invoice lampung.jpg','files/invoice lampung.jpg','ayu'),('001/PD-ITRD/082016','2','invoice lampung2.jpg','files/invoice lampung2.jpg','ayu'),('001/PD-ITRD/082016','3','mobil.JPG','files/mobil.JPG','ayu'),('001/PD-ITRD/082016','4','hotel.JPG','files/hotel.JPG','ayu');

/*Table structure for table `upload_files_temp` */


CREATE TABLE `upload_files_temp` (
  `index_upload` varchar(4) DEFAULT NULL,
  `nama_file` varchar(200) DEFAULT NULL,
  `direktori_file` varchar(200) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `upload_files_temp` */

/*Table structure for table `userapp` */


CREATE TABLE `userapp` (
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `nik` varchar(15) NOT NULL,
  `nama_lengkap` varchar(50) DEFAULT NULL,
  `signas` varchar(3) DEFAULT NULL,
  `level` varchar(30) NOT NULL DEFAULT '3',
  `blokir` enum('Y','N') NOT NULL DEFAULT 'N',
  `tglcreate` datetime DEFAULT NULL,
  `lastupdate` datetime DEFAULT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `ipaddress` varchar(50) DEFAULT NULL,
  `online` int(1) DEFAULT NULL,
  `idym` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`username`),
  UNIQUE KEY `username` (`username`),
  KEY `nik` (`nik`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `userapp` */

insert  into `userapp`(username,password,nik,nama_lengkap,signas,level,blokir,tglcreate,lastupdate,lastlogin,ipaddress,online,idym) values ('accountingbriket','fffa65c4f7d6e9952a67cb084da6bcbf','ISGB20080101221','ARI WINARSIH','109','user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2016-08-04 08:23:22','36.72.244.130',0,'putrajayagrup'),('accountingpjs','d52bc6fd7149f184fcedb4efba06cf20','PJSG20080101058','ARI WINARSIH','109','user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2016-08-19 09:00:20','192.168.2.47',0,'putrajayagrup'),('admin','396d70bdd1a9ccef2fef6e389347f48a','ITRD20160114012','Uswatun Khasanah','411','admin','N','2014-07-08 10:12:49','0000-00-00 00:00:00','2016-08-19 15:51:56','192.168.4.25',0,NULL),('agus','16396c160e8e5918d7d96a24cd6cc032','ITNS20160601013','AGUS SUDARYANTO','199','user','N','2016-03-08 10:07:01','0000-00-00 00:00:00','2016-08-19 15:46:30','192.168.4.62',0,'agus.indratma'),('alfi','058f8bcf52ff28864f2a5ddd01511428','ITNS20160801014','Muhamad Alfiyudin',NULL,'user','N','2015-07-02 08:30:08','0000-00-00 00:00:00','2016-08-19 15:42:43','192.168.4.93',0,NULL),('alika','4ec4b13a4e0f6a9542e5a2c65d6bdc38','ITRD20080101011','ALICA','106','user','N','2016-03-07 12:02:40','0000-00-00 00:00:00','2016-08-19 15:48:04','192.168.2.204',0,'purchasing_indratma'),('andar','e00cf25ad42683b3df678c61f42c6bda','ITNS20150901008','ANDAR ERTANTO',NULL,'admin','N','2015-09-21 10:44:15','0000-00-00 00:00:00','2016-03-16 08:56:04','192.168.2.101',0,NULL),('annisa','f67bf71add9d1688e72c58c708eaca8c','PJSG20160401220','ANNISA',NULL,'user','N','2016-03-11 16:02:00','0000-00-00 00:00:00','2016-08-16 13:08:28','36.72.252.197',0,NULL),('annisabriket','f67bf71add9d1688e72c58c708eaca8c','PJSG20160401220','ANNISA',NULL,'user','N','2016-03-11 16:02:00','0000-00-00 00:00:00','2016-04-07 10:56:35','192.168.2.251',0,NULL),('antiek','0e11198f8a431645c2ed58859f8bdb82','ITRD20140101002','ANTIEK YUNARNINGSIH','108','user','N','0000-00-00 00:00:00','0000-00-00 00:00:00','2016-06-08 10:58:45','192.168.2.141',0,'accounting_pjs'),('anwar','a4c02823479468208fc3dda3e4ae7207','PJSG20080101057','ANWAR','309','user','N','2016-03-07 16:05:59','0000-00-00 00:00:00','2016-03-07 16:28:14','192.168.2.121',0,NULL),('anwarbriket','a4c02823479468208fc3dda3e4ae7207','PJSG20080101057','ANWAR','309','user','N','2016-03-07 16:05:59','0000-00-00 00:00:00','2016-03-07 16:28:14','192.168.2.121',0,NULL),('ariwinarsih','1bf790f27ed371a090ced439a8245f28','PJSG20080101058','ARI WINARSIH','102','user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2016-08-16 14:18:16','180.254.247.197',0,'putrajayagrup'),('ariwinarsihcf','e5911e4c38ba2648734ef501c6c35581','ITRD20150301016','ARI WINARSIH','107','user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2016-08-15 14:50:13','192.168.2.47',0,'putrajayagrup'),('ariwinarsihspv','02015fcb011aaf52b817ff08c0f50d9c','ITRD20150301016','ARI WINARSIH','188','user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2016-08-19 09:04:58','192.168.2.47',0,'putrajayagrup'),('ayu','408d50f9a994d813165217765e4a2a6b','ITRD20150101010','AYU WULANDARI',NULL,'admin','N','2016-03-07 13:51:49','0000-00-00 00:00:00','2016-08-19 15:50:25','192.168.2.15',0,'procurement_indratma'),('ayuproc','5074ae6e5543e8757ba9282b8b863483','ITRD20150101010','AYU WULANDARI','106','admin','N','2016-03-07 13:51:49','0000-00-00 00:00:00','2016-08-19 13:54:36','192.168.2.15',0,'procurement_indratma'),('bagas','236f32fa709c1c3c872d77a32f4c299e','ITRD20140523003','Bagas Dwi Yulianto','411','admin','N','2015-06-27 08:45:10','0000-00-00 00:00:00','2016-06-07 15:49:45','192.168.2.111',0,NULL),('bagus','17b38fc02fd7e92f3edeb6318e3066d8','ITRD20160525019','Bagus Budi Setyawan','411','admin','N','2016-02-20 09:05:44','0000-00-00 00:00:00','2016-08-08 15:02:49','36.73.132.229',0,NULL),('deroi','396d70bdd1a9ccef2fef6e389347f48a','ITRD20140523003','Dedy Ananta','411','admin','N','2015-05-11 14:11:27','0000-00-00 00:00:00','2016-08-19 11:33:09','192.168.4.106',0,'it_indratma'),('editor','18c6d818ae35a3e8279b5330eda01498','PJSG20140519050','SRI FATRINI',NULL,'admin','N','2014-12-18 13:20:57','0000-00-00 00:00:00','2015-06-16 08:35:15','192.168.2.108',0,NULL),('editorbriket','18c6d818ae35a3e8279b5330eda01498','PJSG20140519050','SRI FATRINI',NULL,'admin','N','2014-12-18 13:20:57','0000-00-00 00:00:00','2015-06-16 08:35:15','192.168.2.108',0,NULL),('editorsm','24a0ea6c055be8e88be3390d71289255','SMTH20130225015','NURUL LUTFIYAH',NULL,'user','N','2015-06-04 16:43:15','0000-00-00 00:00:00','2015-06-05 09:23:59','36.79.23.226',0,NULL),('editorsmcoil','24a0ea6c055be8e88be3390d71289255','SMTH20130225015','NURUL LUTFIYAH',NULL,'user','N','2015-06-04 16:43:15','0000-00-00 00:00:00','2015-06-05 09:23:59','36.79.23.226',0,NULL),('evanuryana','60a4bc0d4056db2666c900428940361c','ITRD20131021007','Miss EVA NURYANA',NULL,'admin','N','2015-02-12 11:06:34','0000-00-00 00:00:00','2015-03-09 15:53:34','192.168.1.77',0,NULL),('fanny','b4b77bd31faee8d1538fff19acb6c205','ITRD20080101004','MOCH CHAIRUL FANY','302','user','N','2014-10-07 10:03:51','0000-00-00 00:00:00','2016-08-19 09:33:25','192.168.2.34',0,'chairul_smg'),('fannysuper','d9931d19ba533fc09338bd5b53d69872','ITRD20080101004','MOCH CHAIRUL FANY','411','admin','N','2016-03-31 08:20:23','0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,0,'chairul_smg'),('fathoni','9cac423dd6e0b45b2abb66d0c109e73c','ITRD20000101001','FATHONI','101','user','N','2014-08-11 16:40:01','0000-00-00 00:00:00','2016-08-19 15:33:12','36.73.143.113',0,'fathoni_smg'),('fathonisuper','47244a06aeb501151cbc5382a531175b','ITRD20000101001','Mr. FATHONI','411','admin','N','2016-03-31 08:21:36','0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,0,'fathoni_smg'),('fatkiya','824398bdd15f892ece9e7dd498b8c255','SMTH20160227118','FATKIYA',NULL,'user','N','2016-02-27 16:02:00','0000-00-00 00:00:00','2016-08-19 10:12:25','36.80.199.176',0,NULL),('fatkiyacoil','824398bdd15f892ece9e7dd498b8c255','SMTH20160227118','FATKIYA',NULL,'user','N','2016-02-27 16:02:00','0000-00-00 00:00:00','2016-04-07 16:25:39','36.80.192.92',0,NULL),('gilang','0358c82d547dfca07bea026103e15cfa','ITRD20150601009','GILANG ANIES','109','user','N','2015-07-13 08:49:15','0000-00-00 00:00:00','2016-06-14 14:47:37','180.246.41.18',0,'pjs.accounting'),('gilangcoil','892b1963c93fdfaa7570421290922656','SMTH20150701117','GILANG ANIES','109','user','N','2015-07-13 08:49:15','0000-00-00 00:00:00','2016-04-07 15:50:49','192.168.2.21',0,'pjs.accounting'),('gilangsm','892b1963c93fdfaa7570421290922656','SMTH20150701117','GILANG ANIES','109','user','N','2015-07-13 08:49:15','0000-00-00 00:00:00','2016-08-19 15:26:51','36.73.143.113',0,'pjs.accounting'),('giyono','d88f87eae76800f2be3ca60354c56567','PJSG20080101052','GIYONO','310','user','N','2016-03-07 16:07:10','0000-00-00 00:00:00','2016-03-07 16:28:54','192.168.2.121',0,NULL),('giyonobriket','d88f87eae76800f2be3ca60354c56567','PJSG20080101052','GIYONO','310','user','N','2016-03-07 16:07:10','0000-00-00 00:00:00','2016-03-07 16:28:54','192.168.2.121',0,NULL),('hana','c250e8547dda56eb99d96089f8dec523','ITRD20140523003','hana r','411','admin','N','2016-02-20 09:05:44','0000-00-00 00:00:00','2016-08-18 12:45:46','192.168.4.79',0,NULL),('hengky','66443bc210e6e2ab4582362ec8b4169a','PJSG20150615201','HENGKY','306','user','N','2016-03-07 16:04:30','0000-00-00 00:00:00','2016-05-25 13:20:50','180.246.102.201',0,NULL),('hengkybriket','66443bc210e6e2ab4582362ec8b4169a','ISGB20150615201','HENGKY','306','user','N','2016-03-07 16:04:30','0000-00-00 00:00:00','2016-04-30 13:10:39','36.80.132.156',0,NULL),('hengkycoil','66443bc210e6e2ab4582362ec8b4169a','SMNC20150615119','HENGKY','306','user','N','2016-03-07 16:04:30','0000-00-00 00:00:00','2016-08-19 13:54:52','36.79.88.230',0,NULL),('hengkysm','66443bc210e6e2ab4582362ec8b4169a','SMTH20150615119','HENGKY','306','user','N','2016-03-07 16:04:30','0000-00-00 00:00:00','2016-08-19 09:26:10','180.246.58.63',0,NULL),('intan','d263cf504c9b907df29a2c6e903e0c36','ITRD20140523003','Intan Rahmatika Rukmana',NULL,'admin','N','2015-07-28 11:44:24','0000-00-00 00:00:00','2015-11-30 13:47:01','192.168.2.112',0,NULL),('iqbal','eedae20fc3c7a6e9c5b1102098771c70','ITRD20160525018','Iqbal Musthofa Bariklana','411','admin','N','2016-02-20 09:05:44','0000-00-00 00:00:00','2016-08-03 11:40:36','122.129.192.98',0,NULL),('kapabrikbriket','1bf790f27ed371a090ced439a8245f28','ISGB20080101058','ARI WINARSIH','102','user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2016-08-03 09:54:48','36.80.204.130',0,'putrajayagrup'),('kaprodmijen','2e6b17be5d5ff44eefa66a331e99667b','ISGN20080601003','MOCH RIFAI','306','user','N','2016-03-07 16:04:30','0000-00-00 00:00:00','2016-08-19 11:27:04','36.73.143.113',0,NULL),('karyono','dfdfab5a363e8f63ef9d0c93a7474469','SMTH19900101004','KARYONO','310','user','N','2016-03-07 16:08:02','0000-00-00 00:00:00','2016-03-07 16:29:37','192.168.2.121',0,NULL),('karyonocoil','dfdfab5a363e8f63ef9d0c93a7474469','SMTH19900101004','KARYONO','310','user','N','2016-03-07 16:08:02','0000-00-00 00:00:00','2016-03-07 16:29:37','192.168.2.121',0,NULL),('kimkim','b4aadc0c64c57575d3b3023c595dd35d','ITNS20150101009','WIYANTO GUNAWAN','201','user','N','2016-03-08 10:07:01','0000-00-00 00:00:00','2016-08-19 15:42:45','192.168.4.181',0,'kimkim_trans'),('laporan','3d4c82c4735e8a60524aad4f577fedb8','ITRD20140523003','SEKARWATI',NULL,'user','N','2014-08-06 09:21:48','0000-00-00 00:00:00','2015-02-12 09:16:42','36.79.15.178',0,NULL),('lina','6cc974a21ed9f1521555088ee127bb46','ITNS20160418012','Linasari Hesti Pandini',NULL,'user','N','2015-07-02 08:30:08','0000-00-00 00:00:00','2016-07-15 13:04:55','192.168.2.44',0,NULL),('matnur','9a6ad9ae0876a9a4488124710270d08f','PJSG20140702043','MATNUR',NULL,'user','N','2014-07-15 10:21:02','0000-00-00 00:00:00','2014-08-14 20:31:59','25.115.238.102',0,NULL),('matnurbriket','9a6ad9ae0876a9a4488124710270d08f','PJSG20140702043','MATNUR',NULL,'user','N','2014-07-15 10:21:02','0000-00-00 00:00:00','2014-08-14 20:31:59','25.115.238.102',0,NULL),('nurul','815e5be5f86115a748d242de52c00b37','ISGN20130225002','NURUL LUTFIYAH',NULL,'user','N','2014-09-04 16:02:00','0000-00-00 00:00:00','2016-08-19 15:00:46','36.73.143.113',0,NULL),('nuruladm','9703b652ed790d5e17c0331148e31676','SMTH20130225015','NURUL LUTFIYAH',NULL,'user','N','2014-09-04 16:02:00','0000-00-00 00:00:00','2016-04-08 13:12:11','192.168.2.251',0,NULL),('nurulcoil','8b00597f5b6cda2c750f274ca7078104','ISGC20130225015','NURUL LUTFIYAH',NULL,'user','N','2014-09-04 16:02:00','0000-00-00 00:00:00','2016-08-19 13:50:24','36.73.143.113',0,NULL),('plhaccountingcoil','c9a30d704ef32e06c756791ff089e347','SMNC20140601120','ARI WINARSIH','177','user','N','0000-00-00 00:00:00','0000-00-00 00:00:00','2016-08-09 16:54:51','192.168.2.66',0,'putrajayagrup'),('plhaccountingmijen','e7677fc947cd291e5f108582fd4c6405','ISGN20140601004','ARI WINARSIH','177','user','N','0000-00-00 00:00:00','0000-00-00 00:00:00','2016-08-19 09:02:30','192.168.2.47',0,'putrajayagrup'),('putri','653a6aaa2c5d92ce323187d7764dc112','ITRD20140523003','Putri Artis Anjarwati',NULL,'admin','N','2015-06-27 08:40:24','0000-00-00 00:00:00','2015-11-30 13:07:38','192.168.2.106',0,NULL),('riadlotul','e172dd95f4feb21412a692e73929961e','ITRD20140523003','Riadlotul Itqoh',NULL,'admin','N','2015-06-27 10:30:44','0000-00-00 00:00:00','2015-12-02 10:38:59','192.168.2.109',0,NULL),('rifai','eb6cf68d1915ec5bfc3d9b47bac0e400','SMTH20150101102','MOCH RIFAI','102','user','N','2016-03-07 16:57:51','0000-00-00 00:00:00','2016-08-18 08:23:16','125.163.172.89',0,NULL),('rifai2','8bd2e4ba659e9071dac0124f6b8217f4','ISGN20080601003','MOCH RIFAI','102','user','N','2016-03-07 16:57:51','0000-00-00 00:00:00','2016-08-18 08:23:46','125.163.172.89',0,NULL),('rifaicoil','87dc63c08a3e137b2a367ccb91f6983b','ISGC20150101102','MOCH RIFAI','102','user','N','2016-03-07 16:57:51','0000-00-00 00:00:00','2016-08-16 10:03:52','125.163.172.89',0,NULL),('riniadm','de4cf79f65a91e3479df72f3aace2d3c','PJSG20140519050','SRI FATRINI',NULL,'user','N','2014-08-08 11:43:57','0000-00-00 00:00:00','2016-08-19 09:30:59','192.168.3.100',0,NULL),('rinibriket','051d4c8aecdd503b01ca5ba36a67629c','ISGB20140519050','SRI FATRINI',NULL,'user','N','2014-08-08 11:43:57','0000-00-00 00:00:00','2016-08-04 09:10:00','180.254.250.81',0,NULL),('ryan','707d803707c87747c71b0e5513ef73a9','PJSG20140601015','RYAN',NULL,'user','N','2014-07-01 23:46:56','0000-00-00 00:00:00','2014-09-16 10:43:58','25.46.159.133',0,NULL),('ryanbriket','707d803707c87747c71b0e5513ef73a9','PJSG20140601015','RYAN',NULL,'user','N','2014-07-01 23:46:56','0000-00-00 00:00:00','2014-09-16 10:43:58','25.46.159.133',0,NULL),('satrio','eec470e2f66e97a2ff82bcb62897375a','ITRD20160526020',' satrio bagas aji saputro','411','admin','N','2016-02-20 09:05:44','0000-00-00 00:00:00','2016-07-29 14:34:06','192.168.4.31',0,NULL),('sekar','4cd3fc81fa839a03d0485c37ab03f80d','ITRD20141110006','SEKAR PRASETYANING',NULL,'admin','N','2015-01-08 09:16:11','0000-00-00 00:00:00','2015-04-11 11:05:27','192.168.1.28',0,NULL),('tanti','407f03704d87563b7ad79f66483cdfde','ITRD20100301017','BU TANTI','303','user','N','2014-09-03 17:11:17','0000-00-00 00:00:00','2016-05-27 10:33:09','192.168.2.19',0,'tantiindratma'),('teguh','ecd6354536aa99337fb15e638940189d','ITRD20120101010','TEGUH RIYADI','104','user','N','2016-03-07 16:56:37','0000-00-00 00:00:00','2016-06-24 14:32:21','192.168.3.100',0,NULL),('teguhbriket','46b4e0fad4db81c4ccee7bb7e4d64a07','ISGB20120101010','TEGUH RIYADI','104','user','N','2016-03-07 16:56:37','0000-00-00 00:00:00','2016-05-11 14:19:17','36.79.55.80',0,NULL),('tian','1309a720b32b2273cb3519bebb9a2f8d','ITRD20160525021','Wahyu Titian Rizkiansyah','411','admin','N','2016-02-20 09:05:44','0000-00-00 00:00:00','2016-06-21 08:11:03','192.168.4.200',0,NULL),('tito','1e40a9dbaf52e78456cb09e1bd6ed0c3','ITNS20150824007','TITO FERRY ANGGRIYAWAN',NULL,'admin','N','2015-09-21 10:42:35','0000-00-00 00:00:00','2015-09-21 10:48:12','192.168.2.120',0,NULL),('totok','a433500c16cd2cb188d2a9468f5f2ac7','ITRD20160801022','TOTOK SUPRAPTO','311','user','N','2014-09-03 17:11:17','0000-00-00 00:00:00','2016-08-19 10:42:44','192.168.4.25',0,'hrd_indratma'),('tutun','535d6407d773a9d3269e593722dfa632','SMTH20140117001','MASYUROTUN','303','user','N','2014-09-03 17:11:17','0000-00-00 00:00:00','2016-08-18 08:35:26','192.168.2.21',0,'tutun_finance'),('whardah','4521ab6d0f3fa42bf3b55bdfe00b4de2','ITRD20140523003','whardah','411','admin','N','2016-02-20 09:05:44','0000-00-00 00:00:00','2016-08-19 14:53:10','192.168.4.193',0,NULL),('wildan','d3f67af9846733f9d21eb54852b977d5','ISGN20150717001','MUCHAMAD WILDAN PEBRIANTO',NULL,'user','N','2016-03-08 10:14:35','0000-00-00 00:00:00','2016-03-08 10:21:08','192.168.2.104',0,NULL),('yana','793987424885fd138a759ca1e8e77cf0','ITRD20150608008','Yana Kusuma A','109','user','N','2015-07-02 08:30:08','0000-00-00 00:00:00','2016-08-19 16:14:13','192.168.2.43',0,'accounting_indratmatrans'),('yanaadm','395e5fce483c540c26c24521ecef3b3f','ITNS20150608010','Yana Kusuma A',NULL,'user','N','2015-07-02 08:30:08','0000-00-00 00:00:00','2016-08-19 15:11:09','192.168.2.43',0,'accounting_indratmatrans');

/*Table structure for table `vendor` */


CREATE TABLE `vendor` (
  `kodevendor` varchar(10) DEFAULT NULL,
  `namavendor` varchar(30) DEFAULT NULL,
  `alamat` varchar(80) DEFAULT NULL,
  `kota` varchar(30) DEFAULT NULL,
  `notelp` varchar(20) DEFAULT NULL,
  `tglentry` datetime DEFAULT NULL,
  `userid` varchar(15) DEFAULT NULL,
  `onview` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `vendor` */

insert  into `vendor`(kodevendor,namavendor,alamat,kota,notelp,tglentry,userid,onview) values ('V0000001','PT. DATA UTAMA DINAMIKA','Jl. MT Haryono 579 A Semarang 50124','Semarang','024-8453481__','2016-04-04 13:46:49','ayu',1),('V0000002','PT.PROPAN RAYA','Jl. Soegiopranoto No .14 ','Semarang','024-3581023__','2016-04-08 11:43:58','alika',1),('V0000003','PAY TREN ( PAK KIM )','Semarang','Semarang','024-76747916_','2016-04-08 11:45:00','alika',1),('V0000004','TOKO BESI DAN CAT BANGUNAN ','Jl Fatmawati No.04 Semarang','Semarang','024-6724766__','2016-04-11 11:57:43','alika',1),('V0000005','KANTOR POS','Kedungmundu Raya','Semarang','024-_________','2016-04-11 12:03:25','alika',1),('V0000006','SUPERINDO','Jln Kedungmundu Raya ','Semarang','024-_________','2016-04-11 12:57:11','alika',1),('V0000007','SINAR MULIA SAKTI','Jl.fatmawati 222 B Semarang','Semarang','024-6722135__','2016-04-11 13:11:12','alika',1),('V0000008','EKA CATERING','Gaharu Utara No.93 Banyumanik','Semarang','024-_________','2016-04-11 13:51:56','alika',1),('V0000009','ABIQUA','GEMAH JAYA 1 NO 3','SEMARANG','085-103044922','2016-04-11 13:59:27','ayuproc',1),('V0000010','MIRAI JAYA','SEMARANG','SEMARANG','085-100428494','2016-04-11 14:00:18','ayuproc',1),('V0000011','AL-BARKAH SAUDARA','DEPAN PABRIK JARUM BANTAK SKARJATI JL. GOTRI WELAHAN ','JEPARA','085-200457959','2016-04-11 14:03:31','ayuproc',1),('V0000012','TB. SUMBER REJEKI BAROKAH','MAMBAK RT 02 RW 012 KM 5 SEBELAH UTARA POM BENSIN MAMBAK','JEPARA','081-22887119_','2016-04-11 14:05:33','ayuproc',1),('V0000013','MAKMUR JAYA','JL. H AGUS SALIM 49 KAV 7','SEMARANG','024-3550760__','2016-04-11 14:07:24','ayuproc',1),('V0000014','PT. RAGAM LOGAM','JL. DR. SETIABUDI 104','SEMARANG','01_-_________','2016-04-11 14:08:12','ayuproc',1),('V0000015','SATRIA PULAU GARAM','JL. BARITO RAYA 41','SEMARANG','024-3511286__','2016-04-11 14:08:54','ayuproc',1),('V0000016','CV. SUMBER TEKNIK','JL. H AGUS SALIM NO 49 KAV 15-16','SEMARANG','024-3550771__','2016-04-11 14:09:29','ayuproc',1),('V0000017','UD. GLUGU','SEBELAH TERMINAL WELAHAN','DEMAK','087-746191992','2016-04-11 14:10:21','ayuproc',1),('V0000018','BUMI DESIGN','JL. PENJARINGAN V NO 166','SEMARANG','024-3559398__','2016-04-11 14:10:51','ayuproc',1),('V0000019','IMMANUEL MUDA','JL. KARANGANYAR NO 200','SEMARANG','024-3517827__','2016-04-11 14:12:59','ayuproc',1),('V0000020','TOKO BESI DAN CAT \"BANGUNAN\"','JL. FATMAWATI NO 04 (DEPAN POM BENSIN KETILENG)','SEMARANG','024-6724766__','2016-04-11 14:14:28','ayuproc',1),('V0000021','FAJAR','JL. BARITO BLOK B NO 28','SEMARANG','024-8315470__','2016-04-11 14:23:23','ayuproc',1),('V0000022','ISTANA BESI','JL. H AGUS SALIM','SEMARANG','03_-_________','2016-04-11 14:24:08','ayuproc',1),('V0000023','ANEKA BEARING','JL. H AGUS SALIM','SEMARANG','024-3549456__','2016-04-11 14:25:46','ayuproc',1),('V0000024','BERKAH TEKNIK (PAK PUJI)','JEPARA','JEPARA','05_-_________','2016-04-11 14:27:15','ayuproc',1),('V0000025','GRAND INDO TECHNIK','JL. SOEKARNO-HATTA NO 46B','SEMARANG','024-6702828__','2016-04-11 14:28:41','ayuproc',1),('V0000026','KRESNA','JL. PANDA BARAT I NO 16 B2','SEMARANG','024-76583257_','2016-04-11 14:29:37','ayuproc',1),('V0000027','BANGKIT','JL. PTP NGOBO NO 4 KARANGJATI','KAB SEMARANG','029-8522392__','2016-04-11 14:30:53','ayuproc',1),('V0000028','TJAMAT PUTRA','JL. TANJUNG','TEGAL','081-215691191','2016-04-11 14:31:31','ayuproc',1),('V0000029','HH ELEKTRIK (EMA)','PENJARINGAN','SEMARANG','024-3575164__','2016-04-11 14:33:28','ayuproc',1),('V0000030','GEMA KOMPUTER','JL. TUSAM TIMUR RAYA NO 44','SEMARANG','024-7462212__','2016-04-11 14:35:10','ayuproc',1),('V0000031','TEKINDO (BU GUNARTI)','DARGO','SEMARANG','024-3520838__','2016-04-11 14:36:05','ayuproc',1),('V0000032','BENGKEL EKA TEHNIK','PONDOK RADEN PATAH JL. SUNAN KALIJOGO UTARA BLOK K2/NO 26 SAYUNG','DEMAK','024-6585120__','2016-04-11 14:38:22','ayuproc',1),('V0000033','ASIYAH','JL. CITARUM UTARA NO 36 BARITO A9','SEMARANG','024-3568512__','2016-04-11 14:39:19','ayuproc',1),('V0000034','TOKO BAROKAH (COPY)','JL. BENGKAL JAYA MIJEN','DEMAK','085-225498139','2016-04-11 14:40:28','ayuproc',1),('V0000035','UD WAHIB','DEPAN PASAR PRING KALIPUCANG WELAHAN','JEPARA','029-14256266_','2016-04-11 14:41:23','ayuproc',1),('V0000036','SUMBER AGUNG (BANGUNAN)','JL. RAYA WELAHAN','JEPARA','06_-_________','2016-04-11 14:42:09','ayuproc',1),('V0000037','DADI MULYO SERVICE','JL. A YANI 130 PASAR PENGKOL','JEPARA','029-1597018__','2016-04-11 14:43:07','ayuproc',1),('V0000038','APOTEK MIJEN','JL. RAYA MIJEN-DEMAK KM 1 MIJEN','DEMAK','085-292115588','2016-04-11 14:44:06','ayuproc',1),('V0000039','NUR JAYA','MIJEN DEMAK RT 3/1','DEMAK','085-200361808','2016-04-11 14:44:42','ayuproc',1),('V0000040','TOKO MENEER ELEKTRONIK','JL. DEPAN PASAR NO 101 WELAHAN','JEPARA','081-327249101','2016-04-11 14:45:41','ayuproc',1),('V0000041','PT. KARYA ZIRANG UTAMA','JL. CENDRAWASIH NO 55-56 ','SEMARANG','024-3568192__','2016-04-11 14:48:14','ayuproc',1),('V0000042','KIAT MAJU','JL. KARONSIH TIMUR IX RT 11/V NGALIYAN','SEMARANG','081-325234344','2016-04-11 14:49:16','ayuproc',1),('V0000043','BIRO JASA \"BUDI\"','ROGOJEMBANGAN  BARAT RT 04 RW 04','SEMARANG','085-225215007','2016-04-11 14:50:03','ayuproc',1),('V0000044','CV SUMBER HARAPAN','JL. MT HARYONO261 JAGALAN','SEMARANG','024-3542723__','2016-04-11 14:51:14','ayuproc',1),('V0000045','TAO','JL. MT HARYONO NO 496','SEMARANG','024-3512996__','2016-04-11 14:53:18','ayuproc',1),('V0000046','MARLIN JAYA PLASTIK','Semarang','Semarang','15_-_________','2016-04-19 16:16:55','ayuproc',1),('V0000047','LIE SON SENG','JL. PEKOJAN 31-33','SEMARANG','024-3540386__','2016-04-21 15:23:32','ayuproc',1),('V0000048','POS','KEDUNGMUNDU','SEMARANG','889-_________','2016-04-23 08:47:46','ayuproc',1),('V0000049','REKA','KEDUNGMUNDU','SEMARANG','55_-_________','2016-04-23 08:54:56','ayuproc',1),('V0000050','ALVINS VARIASI','SEMARANG','SEMARANG','082-221427244','2016-04-23 09:06:06','ayuproc',1),('V0000051','TOKO BERKAH','KETILENG RAYA 24','SEMARANG','081-56504996_','2016-04-23 11:16:10','ayuproc',1),('V0000052','HORISON','LAMPER TENGAH','SEMARANG','858-_________','2016-04-23 12:01:02','ayuproc',1),('V0000053','DINAN FOTOCOPY','KEDUNGMUNDU 27','SEMARANG','024-70941840_','2016-04-23 12:05:08','ayuproc',1),('V0000054','BUDI LUHUR','TEGAL KANGKUNG RAYA NO 15','SEMARANG','024-6717139__','2016-04-25 14:20:42','ayuproc',1),('V0000055','UMUM','SEMARANG','SEMARANG','000-889______','2016-04-25 14:24:49','ayuproc',1),('V0000056','JOKSI','KEDUNGMUNDU RAYA NO 24','SEMARANG','024-6719800__','2016-04-25 14:48:14','ayuproc',1),('V0000057','JM COMP','SCC LT5 NO17','SEMARANG','024-70154959_','2016-04-25 15:24:20','ayuproc',1),('V0000058','INDOMARET','Semarang','Semarang','024-899999___','2016-04-26 08:57:58','ayuproc',1),('V0000059','SINAR ABADI PACKAGING','SEMARANG','SEMARANG','024-888888888','2016-04-26 16:10:10','ayuproc',1),('V0000060','PAS PERKASA TOUR DAN TRAVEL','RUKO BANGKONG PLAZA C4, JL. MT HARYONO NO 846-866 SEMARANG 50242','SEMARANG','024-8456644__','2016-04-28 08:51:29','ayuproc',1),('V0000061','','','','','2016-04-28 08:51:29','ayuproc',1),('V0000062','DADI MULYO SERVICE','JL. A. YANI 130 PASAR PENGKOL JEPARA','JEPARA','029-1597018__','2016-04-28 09:02:39','ayuproc',1),('V0000063','SHEEL OLI VASELINE','JL.PIERE TENDEAN SEMARANG','SEMARANG','024-_________','2016-04-28 09:16:55','alika',1),('V0000064','TOKO SUMBER REJEKI ','JL.LAYUR NO.40-50 SMG','SEMARANG','024-3511157__','2016-04-28 09:23:05','alika',1),('V0000065','7VCLOUD','Semarang','Semarang','024-_________','2016-04-28 10:02:14','ayuproc',1),('V0000066','NAM BIE','JL. PEMUDA 41','SEMARANG','024-3546814__','2016-04-28 10:37:41','ayuproc',1),('V0000067','PT. CENDRAWASIH TEKNIK','SEMARANG','SEMARANG','024-00_______','2016-05-26 14:56:59','ayuproc',1),('V0000068','MARLIN JAYA PLASTIK','Semarang','Semarang','024-00000____','2016-05-27 15:22:37','ayuproc',1),('V0000069','BAJA KAROSERI','TERBOYO','SEMARANG','000-0033333__','2016-06-03 09:59:21','ayuproc',1),('V0000070','UD. ARTHA','JL. SUPRIYADI NO 12 KAV 11','SEMARANG','024-6725356__','2016-06-03 10:21:42','ayuproc',1),('V0000071','SUMBER HARAPAN','JL. MT HARYONO NO 261 SEMARANG','SEMARANG','024-3542723__','2016-06-03 11:41:04','ayuproc',1),('V0000072','TOP TRACKER','SEMARANG','SEMARANG','085-729111130','2016-06-04 10:24:55','ayuproc',1),('V0000073','ISUZU','Semarang','Semarang','024-0000_____','2016-06-08 14:39:06','ayuproc',1),('V0000074','ASRA OTOPARTS','Jl. Pegangsaan Dua Km2.2 Kelapa Gading Jakarta Utara','Jakarta','021-300000___','2016-06-08 14:45:51','ayuproc',1),('V0000075','RIHAN GROUP','Jl. Raya Deji-Tulis','Batang','024-00000000_','2016-06-10 08:51:52','ayuproc',1),('V0000076','GLOBAL INDO TEKNIK','Jl. Karang Ingas Barat No 14 (Depan SMP4)','Semarang','024-76729283_','2016-06-13 09:58:03','ayuproc',1),('V0000077','ID-WEBHOST','JL. PERINTIS KEMERDEKAAN NO 33 YOGYAKARTA','YOGYAKARTA','027-4415585__','2016-06-13 11:04:57','ayuproc',1),('V0000078','JM COMP','SCC PLAZA SIMPANG LIMA LT V NO 17 SEMARANG','SEMARANG','024-8416863__','2016-06-13 11:06:40','ayuproc',1),('V0000079','RUMAH KOMPUTER','JL. KEDUNGMUNDU RAYA NO 27 SEMARANG','SEMARANG','085-875392457','2016-06-13 13:27:18','ayuproc',1),('V0000080','RPS KOMPUTER','JL. MT HARYONO 95 SEMARANG','SEMARANG','024-3566588__','2016-06-13 14:53:13','ayuproc',1),('V0000081','LOTTE MART','JL. BRIGJEND SUDIARTO NO 132 GAYAMSARI','SEMARANG','024-00000____','2016-06-13 15:01:19','ayuproc',1),('V0000082','AAHRA','Jl. Kedungmundu Raya No 29 ','Semarang','024-6725152__','2016-06-14 11:26:53','ayuproc',1),('V0000083','ZAHRA AHASS','JL. KEDUNGMUNDU RAYA NO 29','SEMARANG','024-6725152__','2016-06-14 11:28:03','ayuproc',1),('V0000084','PT. CAHYA RUKMA (AGUSTA)','JL. PANDANARAN 62','SEMARANG','024-8447333__','2016-06-15 09:47:11','ayuproc',1),('V0000085','APOTIK PEDURUNGAN','JL FATMAWATI NO 79','SEMARANG','024-6700040__','2016-06-15 13:28:16','ayuproc',1),('V0000086','UD WIJAYA','JL. KAUMAN 31B SEMARANG','SEMARANG','024-3544074__','2016-06-17 13:10:15','ayuproc',1),('V0000087','ADA','MAJAPAHIT SEMARANG','SEMARANG','024-2222_____','2016-06-17 14:07:50','ayuproc',1),('V0000088','PT. DATA UTAMA DINAMIKA','JL. MT. HARYONO','SEMARANG','024-8453481__','2016-06-20 14:42:40','ayuproc',1),('V0000089','BIRAWA JAYA','SEMARANG','SEMARANG','024-000______','2016-06-20 15:11:51','ayuproc',1),('V0000090','ANDALAN LISTRIK','Jl. Hayam Wuruk Jakarta Barat','Jakarta','021-62303503_','2016-06-23 14:37:59','ayuproc',1),('V0000091','SORAYA MILADY ELECTRIC','Tirtomulto Mukti II/201','Semarang','085-869970294','2016-06-24 12:56:09','ayuproc',1),('V0000092','SUMBER REJEKI','JL. LAYUR NO 40-50','SEMARANG','351-1157_____','2016-06-28 09:43:15','ayuproc',1),('V0000093','ERLANGGA','LINGKAR ARTERI','KENDAL','081-328834648','2016-06-28 10:10:41','ayuproc',1),('V0000094','SUMBER BARU JAYA','JL. RAYA MRANAK','DEMAK','029-1686006__','2016-06-28 10:26:02','ayuproc',1),('V0000095','PT. MITRA ALVASTAR BUANA','JL.BUBAKAN NO 20-21B','SEMARANG','024-3568680__','2016-06-28 14:31:27','ayuproc',1),('V0000096','PT.CITRA TRI KENCANA','JAKARTA','JAKARTA','021-777777777','2016-06-28 14:36:07','ayuproc',1),('V0000097','TB.SUMBER REJEKI','JL KEDUNGMUNDU','SEMARANG','024-000000000','2016-06-28 14:44:43','ayuproc',1),('V0000098','USB GENUK','Genuk','Semarang','024-000000000','2016-06-29 11:28:50','ayuproc',1),('V0000099','ALFAMART','Jl. Kedungmundu 24A','Semarang','024-_________','2016-07-19 09:42:01','ayuproc',1),('V0000100','RIZQI MEBEL','JL PRIGI RT 0 RW 06 MRANGGEN','DEMAK','085-_________','2016-07-20 09:44:19','ayuproc',1),('V0000101','YAMAHA JADI SAKTI MOTOR','Jl. Raya Kedungmundu No 118','Semarang','024-6731599__','2016-07-20 14:45:54','ayuproc',1),('V0000102','FAUSTA CELL','JL KEDUNGMUNDU RAYA 27D','SEMARANG','024-76740184_','2016-07-20 14:55:45','ayuproc',1),('V0000103','SUMBER LISTRIK','JL DIPONEGORO NO 83','JEPARA','029-1591269__','2016-08-05 14:11:41','ayuproc',1),('V0000104','TRI JAYA','SEMBUNG HARJO RT06 RW02 GENUK','SEMARANG','085-865371716','2016-08-10 15:13:01','ayuproc',1),('V0000105','JAYA RENT CAR','GUNUNG TALANG NO 24','SEMARANG','085-10655758_','2016-08-10 15:57:15','ayuproc',1),('V0000106','ISTANA BEARING','JURNATAN','SEMARANG','000-_________','2016-08-11 14:45:26','ayuproc',1),('V0000107','AJBS HOME CENTRE','JL MAJAPAHIT NO 256-258','SEMARANG','024-6734111__','2016-08-18 11:28:31','ayuproc',1);

/*!50106 set global event_scheduler = 1*/;

/* Event structure for event `expired` */

/*!50106 DROP EVENT IF EXISTS `expired`*/;

DELIMITER $$

/*!50106 CREATE DEFINER=`root`@`%` EVENT `expired` ON SCHEDULE EVERY 1 DAY STARTS '2016-07-16 08:00:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
		update permintaan set expired=1 where ABS(TIMESTAMPDIFF(MONTH,tglentry,NOW()))=3;
	end */$$
DELIMITER ;

/* Event structure for event `session_out` */

/*!50106 DROP EVENT IF EXISTS `session_out`*/;

DELIMITER $$

/*!50106 CREATE DEFINER=`root`@`%` EVENT `session_out` ON SCHEDULE EVERY 5 MINUTE STARTS '2015-11-05 08:17:28' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE userapp SET online=0,lastupdate='0000-00-00 00:00:00' WHERE TIMEDIFF(SYSDATE(),lastupdate)>'00:03:00' */$$
DELIMITER ;

/* Event structure for event `ymnotification` */

/*!50106 DROP EVENT IF EXISTS `ymnotification`*/;

DELIMITER $$

/*!50106 CREATE DEFINER=`deroi`@`%` EVENT `ymnotification` ON SCHEDULE EVERY 1 HOUR STARTS '2016-08-18 16:32:19' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN 
	
	DECLARE m_kodeprshn VARCHAR(4);
	DECLARE m_kodesign VARCHAR(6);
	DECLARE m_username varchar(30);
	DECLARE m_idym VARCHAR(30);
	DECLARE m_kirim int(1);	
	DECLARE m_durasi int(6);	
	DECLARE m_ada int(6);	
	DECLARE exit_loop BOOLEAN;
	
	DECLARE getdata_pr CURSOR FOR
		SELECT b.kodeperusahaan,f.approveby,c.username,c.idym FROM approval a
		LEFT JOIN permintaan b ON b.kodepermintaan=a.kodepermintaan 
		LEFT JOIN pengesahan f ON f.kodepermintaan=a.kodepermintaan AND f.kodeproses=a.kodeproses
		LEFT JOIN userapp c ON c.signas=f.approveby
		WHERE b.tglmohon<=DATE_FORMAT(SYSDATE(),'%Y-%m-%d') AND COALESCE(a.result,'')='' AND COALESCE(c.idym,'')!=''
		GROUP BY c.username ORDER BY b.tglentry ASC;
	
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET exit_loop = TRUE;
	
	
	SET exit_loop=FALSE;
	OPEN getdata_pr;  
	xx: LOOP
		FETCH getdata_pr INTO m_kodeprshn,m_kodesign,m_username,m_idym;
						
		IF exit_loop THEN
			CLOSE getdata_pr;
			LEAVE xx;
		ELSE	
			set m_durasi=0;	
			SET m_ada=0;
			SET m_kirim=0;
				
			SELECT COUNT(*) As ada FROM logym 
			WHERE kodeperusahaan=m_kodeprshn AND kodedivisi=m_kodesign and username=m_username into m_ada;		
			
			if m_ada>0 then	
									
				SELECT TIME_TO_SEC(TIMEDIFF(SYSDATE(),MAX(lastupdate))) AS durasi FROM logym 
				WHERE kodeperusahaan=m_kodeprshn and kodedivisi=m_kodesign AND username=m_username INTO m_durasi;				
				
				IF m_durasi>900 THEN	
					SELECT COUNT(*) AS ada FROM ym_gateway.tbl_outbox 
					WHERE ym_msg=CONCAT('Ada permintaan approval baru yang masuk ke User ID Anda [',m_username,'] , mohon segera ditindaklanjuti di http://app.indratmacorp.com , Terima kasih.') 
					INTO m_ada;
					
					if m_ada>0 then
						set m_durasi =0;
					end if;							
				END IF;
				
				IF m_durasi>900 THEN	
					SELECT TIME_TO_SEC(TIMEDIFF(SYSDATE(),MAX(sent_at))) AS durasi FROM ym_gateway.tbl_sent 
					WHERE ym_msg=CONCAT('Ada permintaan approval baru yang masuk ke User ID Anda [',m_username,'] , mohon segera ditindaklanjuti di http://app.indratmacorp.com , Terima kasih.') 
					INTO m_durasi;	
				END IF;	
					
			end if;
					
			
			if m_ada=0 then
				set m_kirim=1;
			else
				if m_durasi>900 then
					set m_kirim=1;
				end if;	
			end if;	
					
			if m_kirim=1 then											
								
				INSERT INTO ym_gateway.tbl_outbox(send_to,ym_msg,entry_at) 
				VALUES(m_idym,
				CONCAT('Ada permintaan approval baru yang masuk ke User ID Anda [',m_username,'] , mohon segera ditindaklanjuti di http://app.indratmacorp.com , Terima kasih.'),
				SYSDATE());	
					
				insert into logym(kodeperusahaan,kodedivisi,username,lastupdate) 
				values(m_kodeprshn,m_kodesign,m_username,SYSDATE());						
				
			end if;
		END IF;		
	END LOOP xx;
	
	
END */$$
DELIMITER ;

/* Function  structure for function  `getdurasi` */

/*!50003 DROP FUNCTION IF EXISTS `getdurasi` */;
DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` FUNCTION `getdurasi`(tglawal VARCHAR(19), tglakhir VARCHAR(19)) RETURNS varchar(80) CHARSET latin1
BEGIN
	DECLARE durasi varchar(10);
	DECLARE hasil VARCHAR(80);	
	DECLARE cek int;
	DECLARE hari INT;
	DECLARE jam INT;
	DECLARE menit INT;
	DECLARE detik INT;
	
	set hasil='';
	
	select TIMEDIFF(DATE_FORMAT(tglakhir,'%Y-%m-%d %H:%i:%s'),
	DATE_FORMAT(tglawal,'%Y-%m-%d %H:%i:%s')) as xx into durasi;
	
	SET cek=TIME_FORMAT(durasi,'%H')/24;
	IF cek<1 THEN
		SET hari=0;		
	ELSE		
		SET hari=truncate(cek,0);		
		SET hasil=CONCAT(hari,' hari ');
	END IF;	
	
	set cek=TIME_FORMAT(durasi,'%H')-(hari*24);
	if cek<1 then
		set jam=0;		
	else		
		SET jam=cek;		
		SET hasil=CONCAT(hasil,jam,' jam ');
	end if;	
	
	SET cek=TIME_FORMAT(durasi,'%i');
	IF cek=0 THEN
		SET menit=0;		
	ELSE
		SET menit=cek;		
		SET hasil=CONCAT(hasil,menit,' menit ');
	END IF;	
	
	if hari=0 and jam=0 and menit=0 then
		SET hasil='0 menit';
	end if;	
			
	RETURN hasil; 	
	
END */$$
DELIMITER ;

