(22635,'2025-08-20','N',284,'08:00','08:30','2025-08-19 18:36:10','Dalkot','Stand By',NULL,'2301490011','M BALYAN MULKAN','088287932720','','2025-08-19 18:36:10','BUSINESS SUPPORT AREA',0,0,0,NULL,NULL,108010,'569','112',''),(22636,'2025-08-20','N',285,'08:00','16:30','2025-08-19 19:03:45','OTS','Closing',NULL,'1896510066','JULIAN ADITYA SAPUTRA','081271312234','PIC Pak Taufik','2025-08-20 08:32:42','CONSUMER LOAN AREA ',5,5,5,'2025-08-20 17:39:37','2025-08-20 17:32:40',108011,'473','112','driver'),(22637,'2025-08-20','N',283,'09:00','17:30','2025-08-19 19:14:17','OTS Region','Keep',NULL,'2398494467','MUHAMMAD HATTA','085357956569','PIC Pak Edo','2025-09-03 07:57:20','CONSUMER LOAN AREA ',0,0,0,NULL,NULL,108012,'565','112',''),(22638,'2025-08-20','N',287,'09:00','17:30','2025-08-20 08:41:06','kayuagung','Closing',NULL,'1694624016','YOSSIE YOLANDA','082177773363','marina','2025-08-20 20:58:30','SME AREA',5,5,5,'2025-08-21 10:38:50','2025-08-20 20:58:33',108013,'476','112','driver'),(22639,'2025-08-20','N',286,'09:15','18:00','2025-08-20 08:42:09','tugumulyo','Stand By',NULL,'2298758970','DEVI TRI REFINA','081271210598','risma','2025-08-20 08:42:09','SME AREA',0,0,0,NULL,NULL,108014,'568','112',''),(22653,'2025-08-25','N',284,'08:00','16:30','2025-08-24 21:20:16','gandus','Stand By',NULL,'1694624016','YOSSIE YOLANDA','082177773363','fina','2025-08-24 21:20:16','SME AREA',0,0,0,NULL,NULL,108027,'476','112',''),(22654,'2025-08-25','N',283,'08:15','18:00','2025-08-24 21:20:53','kayuagung','Stand By',NULL,'2298758970','DEVI TRI REFINA','081271210598','althaf','2025-08-24 21:20:53','SME AREA',0,0,0,NULL,NULL,108028,'568','112',''),(22643,'2025-08-21','N',285,'07:30','16:30','2025-08-20 11:22:19','lubuk seberuk ots nasabah koperasi merah putih','Closing',NULL,'1694624016','YOSSIE YOLANDA','082177773363','marina','2025-08-24 21:21:58','SME AREA',5,5,5,'2025-08-26 07:36:48','2025-08-24 21:22:01',108017,'476','112','driver'),(22644,'2025-08-21','N',224,'09:00','17:30','2025-08-20 11:23:26','baturaja','Stand By',NULL,'2298758970','DEVI TRI REFINA','081271210598','risma','2025-08-20 11:23:26','SME AREA',0,0,0,NULL,NULL,108018,'568','112',''),(22645,'2025-08-21','N',287,'08:00','18:00','2025-08-20 12:48:47','suryaadi','Keep',NULL,'2301490100','PUTRI ASI SUGMA WIJAYA','085279708992','nopri','2025-08-20 20:58:36','SME AREA',0,0,0,NULL,NULL,108019,'562','112',''),(22646,'2025-08-21','N',286,'08:00','17:15','2025-08-20 17:33:31','OTS Region','Stand By',NULL,'2398494467','MUHAMMAD HATTA','085357956569','PIC Pak Taufik','2025-08-20 17:33:31','CONSUMER LOAN AREA ',0,0,0,NULL,NULL,108020,'565','112',''),(22647,'2025-08-21','N',284,'07:00','16:00','2025-08-20 17:39:49','OTS','Keep',NULL,'1896510066','JULIAN ADITYA SAPUTRA','081271312234','PIC Pak Taufik','2025-08-21 14:40:44','CONSUMER LOAN AREA ',0,0,0,NULL,NULL,108021,'473','112',''),(22648,'2025-08-22','N',285,'08:00','17:00','2025-08-21 10:38:00','kayuagung','Closing',NULL,'2301490100','PUTRI ASI SUGMA WIJAYA','085279708992','ots nasabah an garuda bhinneka','2025-08-24 21:22:03','SME AREA',5,5,5,'2025-08-24 21:22:56','2025-08-24 21:22:05',108022,'562','112','driver'),(22649,'2025-08-22','N',284,'10:00','16:30','2025-08-21 10:42:12','gandus dan km 14','Keep',NULL,'1694624016','YOSSIE YOLANDA','082177773363','ots nasabah pt karyawaja, developer satria indo tama','2025-08-21 14:40:32','SME AREA',0,0,0,NULL,NULL,108023,'476','112',''),(22650,'2025-08-22','N',224,'09:30','15:15','2025-08-21 18:39:36','indralaya','Stand By',NULL,'2298758970','DEVI TRI REFINA','081271210598','gita dan martin','2025-08-21 18:39:36','SME AREA',0,0,0,NULL,NULL,108024,'568','112',''),(22664,'2025-08-29','N',285,'09:00','17:30','2025-08-29 08:58:50','PK ','Keep',NULL,'2301490100','PUTRI ASI SUGMA WIJAYA','085279708992','syefira','2025-09-03 07:58:29','SME AREA',0,0,0,NULL,NULL,108038,'562','112',''),(22659,'2025-08-26','N',283,'08:00','16:30','2025-08-26 07:37:15','follow up ke cabang','Stand By',NULL,'1694624016','YOSSIE YOLANDA','082177773363','all tim sme','2025-08-26 07:37:15','SME AREA',0,0,0,NULL,NULL,108033,'476','112',''),(22660,'2025-08-27','N',284,'08:30','16:30','2025-08-27 07:20:50','indralaya dan kayuagung','Stand By',NULL,'1694624016','YOSSIE YOLANDA','082177773363','yopie & althaf','2025-08-27 07:20:50','SME AREA',0,0,0,NULL,NULL,108034,'476','112',''),(22661,'2025-08-27','N',285,'09:00','16:30','2025-08-27 07:21:35','gandus','Keep',NULL,'2298758970','DEVI TRI REFINA','081271210598','finesa','2025-09-03 07:58:33','SME AREA',0,0,0,NULL,NULL,108035,'568','112',''),(22662,'2025-08-28','N',284,'08:30','17:00','2025-08-28 07:44:36','rri dan plaju','Stand By',NULL,'2301490100','PUTRI ASI SUGMA WIJAYA','085279708992','emil dan agus','2025-08-28 07:44:36','SME AREA',0,0,0,NULL,NULL,108036,'562','112',''),(22663,'2025-08-28','N',285,'09:00','15:30','2025-08-28 07:45:16','celentang','Keep',NULL,'1694624016','YOSSIE YOLANDA','082177773363','risma','2025-09-03 07:58:19','SME AREA',0,0,0,NULL,NULL,108037,'476','112',''),(22666,'2025-08-29','N',279,'11:00','16:30','2025-08-29 10:39:32','Visit Merchant','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Marketing','2025-08-29 11:01:33','CREDIT CARD AREA',5,5,5,'2025-09-02 09:00:48','2025-09-02 07:56:58',108040,'326','113','driver'),(22667,'2025-09-01','N',283,'08:00','17:00','2025-09-01 07:46:42','celentang','Keep',NULL,'1694624016','YOSSIE YOLANDA','082177773363','risma','2025-09-03 07:57:26','SME AREA',0,0,0,NULL,NULL,108041,'476','112',''),(22668,'2025-09-01','N',285,'09:00','15:30','2025-09-01 07:48:24','kauuagung','Keep',NULL,'2301490100','PUTRI ASI SUGMA WIJAYA','085279708992','althaf','2025-09-03 07:58:21','SME AREA',0,0,0,NULL,NULL,108042,'562','112',''),(22669,'2025-09-02','N',283,'09:00','15:30','2025-09-02 07:37:02','talang kelapa','Stand By',NULL,'1694624016','YOSSIE YOLANDA','082177773363','raka','2025-09-02 07:37:02','SME AREA',0,0,0,NULL,NULL,108043,'476','112',''),(22670,'2025-09-02','N',284,'09:30','15:00','2025-09-02 07:37:34','pusri','Stand By',NULL,'2298758970','DEVI TRI REFINA','081271210598','nopri','2025-09-02 07:37:34','SME AREA',0,0,0,NULL,NULL,108044,'568','112',''),(22671,'2025-09-02','N',279,'09:15','14:00','2025-09-02 09:01:41','Cek ATM','Closing',NULL,'admin113','Admin AREA PALEMBANG ARIEF','081111','Cek Fisik ATM','2025-09-02 09:04:36','AREA PALEMBANG ARIEF',5,5,5,'2025-09-04 08:08:04','2025-09-03 09:59:55',108045,'313','113','driver'),(22672,'2025-09-02','N',275,'10:15','13:00','2025-09-02 10:05:37','ke sukamto','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi','2025-09-02 13:09:36','AREA TRANSACTION FUNDING',5,5,5,'2025-09-03 09:43:04','2025-09-03 09:41:11',108046,'557','113','driver'),(22673,'2025-09-03','N',268,'09:00','16:30','2025-09-02 18:26:16','Ots agunan','Closing',NULL,'0278184379','RAHMALIA','08117186278','Agunan kkp dan kpr','2025-09-03 08:12:43','CONSUMER LOAN AREA ',5,5,5,'2025-09-04 08:15:49','2025-09-04 08:12:02',108047,'328','113','driver'),(22674,'2025-09-03','N',279,'10:00','13:30','2025-09-03 08:53:11','Cabang Plg Sukajadi','Closing',NULL,'9974099483','MARYATI','08127828724','Review','2025-09-03 09:59:59','AREA BUSINESS CONTROL',5,5,5,'2025-09-04 10:48:50','2025-09-04 08:11:03',108048,'342','113','driver'),(22675,'2025-09-03','N',276,'13:30','16:30','2025-09-03 09:23:55','OTS dan penyerahan sertifikat','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Citraland, cgc, region (WOC)','2025-09-04 08:11:42','CONSUMER LOAN AREA ',5,5,5,'2025-09-04 10:48:46','2025-09-04 08:11:45',108049,'546','113','driver'),(22676,'2025-09-03','N',275,'10:00','13:00','2025-09-03 09:43:24','ke green resort','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi bill reminder','2025-09-03 09:45:49','AREA TRANSACTION FUNDING',5,5,5,'2025-09-04 08:25:03','2025-09-04 08:11:30',108050,'557','113','driver'),(22677,'2025-09-04','N',275,'09:30','14:00','2025-09-04 09:10:45','ke rs ar rasyid','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi','2025-09-04 09:14:24','AREA TRANSACTION FUNDING',5,5,5,'2025-09-11 09:18:44','2025-09-11 08:11:09',108051,'557','113','driver'),(22678,'2025-09-04','N',276,'10:00','16:00','2025-09-04 09:20:22','Ots agunan','Closing',NULL,'0278184379','RAHMALIA','08117186278','Ots agunan','2025-09-04 09:30:02','CONSUMER LOAN AREA ',5,5,5,'2025-09-22 11:20:32','2025-09-22 09:57:39',108052,'328','113','driver'),(22679,'2025-09-04','N',268,'11:00','13:00','2025-09-04 10:49:39','Drop ke cabang uniba','Closing',NULL,'admin113','Admin AREA PALEMBANG ARIEF','081111','Cabang banggau','2025-09-08 11:04:29','AREA PALEMBANG ARIEF',5,5,5,'2025-09-08 11:59:03','2025-09-08 11:04:33',108053,'313','113','driver'),(22681,'2025-09-08','N',279,'10:00','16:30','2025-09-08 09:14:49','Visit Merchant','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Marketing','2025-09-08 09:16:53','CREDIT CARD AREA',5,5,5,'2025-09-15 08:29:52','2025-09-12 09:02:45',108054,'326','113','driver'),(22682,'2025-09-08','N',268,'10:00','12:00','2025-09-08 10:00:13','Alang alang lebar','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ots agunan','2025-09-08 12:35:10','CONSUMER LOAN AREA ',5,5,5,'2025-09-22 08:49:00','2025-09-22 07:34:58',108055,'546','113','driver'),(22683,'2025-09-10','N',275,'10:00','16:30','2025-09-10 07:40:45','Citraland, t. Kelapa dan RCO','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','OTS agunan, retensi dan RCO','2025-09-10 07:46:46','CONSUMER LOAN AREA ',5,5,5,'2025-09-11 09:18:41','2025-09-11 08:11:11',108056,'546','113','driver'),(22684,'2025-09-11','N',279,'14:00','16:00','2025-09-11 13:25:12','ke highscope','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi','2025-09-12 09:02:38','AREA TRANSACTION FUNDING',5,5,5,'2025-09-15 08:29:48','2025-09-12 09:02:48',108057,'557','113','driver'),(22689,'2025-09-16','N',268,'13:00','16:00','2025-09-16 11:28:46','ke green resort','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi br','2025-09-22 07:35:00','AREA TRANSACTION FUNDING',5,5,5,'2025-09-23 14:38:51','2025-09-23 10:01:39',108059,'557','113','driver'),(22690,'2025-09-17','N',275,'09:30','16:00','2025-09-17 07:05:41','ke cgc','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi','2025-09-22 07:29:50','AREA TRANSACTION FUNDING',5,5,5,'2025-09-22 08:48:47','2025-09-22 07:29:53',108060,'557','113','driver'),(22688,'2025-09-16','N',275,'10:00','16:00','2025-09-16 09:13:23','Talang Keramat dan KM 12','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ots Agunan','2025-09-22 07:29:54','CONSUMER LOAN AREA ',5,5,5,'2025-09-22 08:48:57','2025-09-22 07:29:55',108058,'546','113','driver'),(22691,'2025-09-22','N',276,'10:00','15:00','2025-09-22 09:56:41','Kcp Burlian','Closing',NULL,'1896510135','BUDI FIRMANSYAH','083173480280','Pasang printer','2025-09-22 09:57:42','BUSINESS SUPPORT',5,5,5,'2025-09-25 07:43:36','2025-09-25 07:38:40',108061,'401','113','driver'),(22692,'2025-09-22','N',254,'14:00','16:30','2025-09-22 10:14:26','Km5 dan kenten','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ots retensi','2025-09-22 10:17:35','CONSUMER LOAN AREA ',5,5,5,'2025-09-23 14:38:48','2025-09-23 07:57:08',108062,'546','113','driver'),(22693,'2025-09-22','N',268,'11:30','16:30','2025-09-22 11:21:47','Ots agunan, ots developer','Closing',NULL,'0278184379','RAHMALIA','08117186278','Plaju dan bukit baru','2025-09-23 10:01:43','CONSUMER LOAN AREA ',5,5,5,'2025-09-23 14:38:45','2025-09-23 10:01:49',108063,'328','113','driver'),(22694,'2025-09-22','N',275,'15:00','18:00','2025-09-22 14:56:03','Visit Merchant','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Marketing','2025-09-22 15:34:28','CREDIT CARD AREA',5,5,5,'2025-09-23 14:38:42','2025-09-23 10:24:07',108064,'326','113','driver'),(22695,'2025-09-23','N',275,'10:00','14:00','2025-09-23 08:52:12','Cabang Sako Kenten','Closing',NULL,'9974099483','MARYATI','08127828724','Review ','2025-09-23 10:24:15','AREA BUSINESS CONTROL',5,5,5,'2025-09-29 09:13:50','2025-09-29 07:57:22',108065,'342','113','driver'),(22696,'2025-09-24','N',274,'09:00','16:30','2025-09-24 08:02:14','Ots agunan','Stand By',NULL,'0278184379','RAHMALIA','08117186278','Ots agunan','2025-09-24 08:02:14','CONSUMER LOAN AREA ',0,0,0,NULL,NULL,108066,'328','113',''),(22697,'2025-09-24','N',268,'12:00','16:30','2025-09-24 11:53:16','Visit Merchant','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Marketing','2025-09-25 07:43:27','CREDIT CARD AREA',5,5,5,'2025-10-15 08:09:10','2025-10-15 07:51:07',108067,'326','113','driver'),(22698,'2025-09-25','N',275,'10:00','16:00','2025-09-25 07:36:35','ke hotel all night','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi','2025-09-29 07:57:24','AREA TRANSACTION FUNDING',5,5,5,'2025-09-29 09:13:47','2025-09-29 07:57:26',108068,'557','113','driver'),(22699,'2025-09-25','N',276,'13:30','16:00','2025-09-25 07:37:48','Barangan','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ttd akad kredit','2025-09-25 07:38:42','CONSUMER LOAN AREA ',5,5,5,'2025-09-30 09:27:33','2025-09-29 09:17:28',108069,'546','113','driver'),(22705,'2025-10-01','N',254,'08:00','16:30','2025-10-01 07:58:27','Visit Merchant','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Marketing','2025-10-01 08:22:29','CREDIT CARD AREA',5,5,5,'2025-10-02 07:40:24','2025-10-01 15:37:14',108074,'326','113','driver'),(22706,'2025-10-02','N',275,'10:30','12:00','2025-10-02 09:48:10','CO region','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ambil berkas legal dan sertifikat','2025-10-02 10:49:26','CONSUMER LOAN AREA ',5,5,5,'2025-10-02 10:51:31','2025-10-02 10:49:28',108075,'546','113','driver'),(22702,'2025-09-30','N',275,'08:00','16:00','2025-09-30 07:44:24','Visit Merchant','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Marketing','2025-09-30 10:34:09','CREDIT CARD AREA',5,5,5,'2025-10-01 07:59:29','2025-10-01 07:58:25',108072,'326','113','driver'),(22703,'2025-09-30','N',254,'09:30','12:00','2025-09-30 07:58:03','Area Plg Sudirman','Closing',NULL,'9974099483','MARYATI','08127828724','Mengantar nota untuk PPATK','2025-09-30 10:27:51','AREA BUSINESS CONTROL',5,5,5,'2025-09-30 14:43:09','2025-09-30 13:54:01',108073,'342','113','driver'),(22707,'2025-10-02','N',275,'13:30','15:30','2025-10-02 10:52:05','CO Region','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ambil sertifikat dan berkas legal','2025-10-02 14:03:01','CONSUMER LOAN AREA ',4,4,4,'2025-10-03 13:47:49','2025-10-03 07:56:03',108076,'546','113','driver'),(22708,'2025-10-02','N',254,'14:30','16:30','2025-10-02 13:46:40','Area Plg Sudirman','Closing',NULL,'9974099483','MARYATI','08127828724','Pengambilan berkas OJK','2025-10-02 14:01:51','AREA BUSINESS CONTROL',5,5,5,'2025-10-03 12:50:57','2025-10-03 07:59:42',108077,'342','113','driver'),(22709,'2025-10-03','N',254,'08:15','16:30','2025-10-03 08:12:14','Marketing','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Visit merchant','2025-10-06 14:13:14','CREDIT CARD AREA',5,5,5,'2025-10-08 08:04:32','2025-10-06 14:13:18',108078,'326','113','driver'),(22710,'2025-10-03','N',275,'14:30','18:00','2025-10-03 12:51:33','Cabang Plg Bukit','Closing',NULL,'9974099483','MARYATI','08127828724','Review','2025-10-03 13:59:26','AREA BUSINESS CONTROL',5,5,5,'2025-10-06 11:34:27','2025-10-06 10:07:07',108079,'342','113','driver'),(22711,'2025-10-03','N',276,'14:00','16:00','2025-10-03 13:48:32','BNI bundaran masjid agung','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Ambil shm take over','2025-10-03 13:54:16','CONSUMER LOAN AREA ',5,5,5,'2025-10-06 11:34:24','2025-10-06 09:38:05',108080,'546','113','driver'),(22715,'2025-10-13','N',275,'10:15','16:30','2025-10-13 10:02:34','Marketing','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Visit merchant','2025-10-13 13:46:50','CREDIT CARD AREA',5,5,5,'2025-10-16 07:55:43','2025-10-15 13:12:24',108084,'326','113','driver'),(22713,'2025-10-06','N',275,'13:30','16:30','2025-10-06 08:20:21','KANWIL REGION ','Closing',NULL,'1492567169','CAHYA PURNAMA SEPTIANI','081221550002','Penyerahan dan Pengambilan Dokumen Legal','2025-10-06 10:07:15','CONSUMER LOAN AREA ',5,5,5,'2025-10-14 07:47:06','2025-10-13 10:05:37',108082,'546','113','driver'),(22714,'2025-10-06','N',276,'09:00','16:30','2025-10-06 08:45:59','Ots agunan','Keep',NULL,'0278184379','RAHMALIA','08117186278','Ots agunan','2025-10-06 09:38:08','CONSUMER LOAN AREA ',0,0,0,NULL,NULL,108083,'328','113',''),(22716,'2025-10-13','N',254,'14:00','16:00','2025-10-13 13:19:02','ke region','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','antar surat','2025-10-13 15:29:08','AREA TRANSACTION FUNDING',5,5,5,'2025-10-14 07:47:03','2025-10-13 17:08:50',108085,'557','113','driver'),(22717,'2025-10-15','N',268,'09:30','16:00','2025-10-15 08:05:00','ke nasabah','Closing',NULL,'2206100422','ULFA HASANAH','085960362255','sosialisasi','2025-10-20 08:13:16','AREA TRANSACTION FUNDING',5,5,5,'2025-10-21 07:41:37','2025-10-20 08:13:21',108086,'557','113','driver'),(22718,'2025-10-15','N',275,'09:00','16:30','2025-10-15 08:09:25','Marketing','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Visit merchant','2025-10-15 13:12:27','CREDIT CARD AREA',5,5,5,'2025-10-16 18:09:35','2025-10-16 10:10:03',108087,'326','113','driver'),(22720,'2025-10-16','N',275,'08:30','16:30','2025-10-16 08:30:35','Marketing','Closing',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Visit merchant','2025-10-16 10:10:05','CREDIT CARD AREA',5,5,5,'2025-10-17 08:11:21','2025-10-17 08:10:30',108088,'326','113','driver'),(22721,'2025-10-20','N',268,'08:15','16:30','2025-10-20 08:09:45','Marketing','Stand By',NULL,'1289444416','ACHMAD ARIEF HIDAYATULLAH','08117897771','Visit merchant','2025-10-20 08:09:45','CREDIT CARD AREA',0,0,0,NULL,NULL,108089,'326','113',''),(22722,'2025-10-20','N',275,'09:00','12:00','2025-10-20 08:59:45','Burlian','Closing',NULL,'1896510135','BUDI FIRMANSYAH','083173480280','Cek cctv','2025-10-21 07:06:27','BUSINESS SUPPORT',5,5,5,'2025-10-21 07:40:46','2025-10-21 07:06:29',108090,'401','113','driver');

--
-- Table structure for table `unita`
--

CREATE TABLE `unita` (
  `noma` int(11) unsigned NOT NULL,
  `unita` varchar(255) DEFAULT NULL,
  `unit` varchar(111) NOT NULL DEFAULT '',
  PRIMARY KEY (`noma`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `unita`
--

INSERT INTO `unita` VALUES (10,'MIKRO BANKING AREA','112'),(9,'E-CHANNEL OPERATIONS AREA','112'),(8,'CREDIT CARD AREA','112'),(7,'CONSUMER LOAN AREA ','112'),(6,'BUSINESS SUPPORT AREA','112'),(5,'BRANCH SALES PAL ATMO','112'),(4,'MMU PAL ATMO','112'),(3,'BRANCH PAL ATMO','112'),(2,'BRANCH SALES PAL SUDIRMAN','112'),(1,'MMU PAL SUDIRMAN','112'),(11,'AREA BUSINESS CONTROL','112'),(12,'AREA RETAIL FUNDING','112'),(13,'SME AREA','112'),(14,'AREA TRANSACTION FUNDING','112'),(15,'BRANCH PAL SUDIRMAN','112'),(16,'BUSINESS SUPPORT AREA','113'),(17,'E-CHANNEL OPERATIONS AREA','113'),(18,'BRANCH SALES PAL ARIEF','113'),(19,'BRANCH SALES PAL A. RIVAI','113'),(20,'BRANCH PAL GEDUNG KANWIL','113'),(21,'BRANCH SALES PAL GEDUNG KANWIL','113'),(22,'CONSUMER LOAN AREA ','113'),(23,'CREDIT CARD AREA','113'),(24,'MIKRO BANKING AREA','113'),(25,'AREA BUSINESS CONTROL','113'),(26,'AREA RETAIL FUNDING','113'),(27,'SME AREA','113'),(28,'AREA TRANSACTION FUNDING','113'),(29,'BRANCH PAL ARIEF','113'),(30,'MMU PAL ARIEF','113'),(31,'BRANCH PAL A. RIVAI','113'),(32,'MMU PAL A. RIVAI','113'),(33,'MMU PAL GEDUNG KANWIL','113'),(34,'Admin','reg2'),(35,'AREA BANDAR LAMPUNG','reg2'),(36,'AREA JAMBI','reg2'),(37,'AREA PADANG','reg2'),(38,'AREA PALEMBANG SUDIRMAN','reg2'),(39,'AREA PANGKALPINANG','reg2'),(40,'BUSINESS SUPPORT','reg2'),(41,'BUSSINESS SUPPORT','reg2'),(42,'CONSUMER LOAN','reg2'),(43,'CREDIT CARD','reg2'),(44,'E-CHANNEL OPERATIONS','reg2'),(45,'GOVERNMENT','reg2'),(46,'HC&GA','reg2'),(47,'LEGAL REGION','reg2'),(48,'MIKRO BANKING','reg2'),(49,'NMGA','reg2'),(50,'REGIONAL BUSINESS CONTROL','reg2'),(51,'REGIONAL CHIEF FINANCIAL','reg2'),(52,'RETAIL FUNDING','reg2'),(53,'SME REGION','reg2'),(54,'TB RETAIL','reg2'),(55,'TB WHOLESALE','reg2'),(56,'WEALTH BUSINESS','reg2');

--
-- Table structure for table `userid`
--

CREATE TABLE `userid` (
  `noma` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `masuk` varchar(100) DEFAULT '',
  `password` varchar(20) DEFAULT '',
  `oto` varchar(5) DEFAULT 'a1',
  `nama` varchar(255) DEFAULT NULL,
  `unit` varchar(100) NOT NULL DEFAULT '',
  `hp` varchar(55) NOT NULL DEFAULT '',
  `cop` varchar(1) NOT NULL DEFAULT 'n',
  `nopeg` varchar(12) NOT NULL DEFAULT '',
  `rega` varchar(12) NOT NULL DEFAULT 'reg3',
  `cab` varchar(11) NOT NULL DEFAULT '',
  `jmk` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`noma`)
) ENGINE=MyISAM AUTO_INCREMENT=1156 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `userid`
--

INSERT INTO `userid` VALUES (2,'admin','12345','a0','Admin','Admin','0811111111','n','101','reg2','',1),(3,'1288450406','123456','a0','AFIF HAMDI','Admin','085263205956','n','102','reg2','',1),(4,'1087372082','a3123','a1','ANDI AHMAD AMIRUDIN','BUSSINESS SUPPORT','08127166801','n','103','reg2','',1),(6,'1389529041','222000','a1','DERSY KARDOVA UTAMI AZHARI','NMGA','081366476119','n','105','reg2','',1),(7,'1086361219','12345','a1','DEVY AGUSTIAWAN','BUSSINESS SUPPORT','08127112758','n','106','reg2','',1),(8,'1896679040','ditnas96','a1','DITA NASNANIA','BUSSINESS SUPPORT','082269756491','n','107','reg2','',1),(1099,'','','a1','','','','','595','','',1),(1100,'','','a1','','','','','596','','',1),(1048,'0986348067','Mandiri123','a1','ERWIN DESRIANTO','BUSINESS SUPPORT','08117372258','n','544','reg2','',1),(11,'0884323767','32376','a1','FITRIA KARTIKA SARI','HC&GA','081283877139','n','110','reg2','',1),(13,'2096736913','Rohman1996','a1','HIDAYATUR ROHMAN','BUSSINESS SUPPORT','082337335034','n','112','reg2','',1),(16,'1995712445','123456','a1','M HASAN BASRI','REGIONAL BUSINESS CONTROL','+62 812-7322-422','n','115','reg2','',1),(17,'1290488097','mamautun','a1','MOCHAMMAD HARSADILI','BUSSINESS SUPPORT','082176601324','n','116','reg2','',1),(19,'1087381570','210787','a1','PANDU LESANPURA AJI','BUSSINESS SUPPORT','08114513513','n','118','reg2','',1),(20,'1387495369','Ratna2029','a1','RATNA DEWI ADELIYAH','BUSSINESS SUPPORT','081367520410','n','119','reg2','',1),(21,'0582279089','mandiri','a1','RENNY FEBRIANI','BUSSINESS SUPPORT','08127810300','n','120','reg2','',1),(1067,'1697030138','011997Taan','a1','ANDRE WIJAYA','AREA TRANSACTION FUNDING','08127737302','n','563','112','',1),(23,'9976059998','110775','a1','SUGENG RIYANTO','BUSSINESS SUPPORT','081288688309','n','122','reg2','',1),(24,'1389511429','hcsquad22','a1','TEGAR ARDIANSYAH','BUSSINESS SUPPORT','085382198882','n','123','reg2','',1),(25,'1692643547','triana','a1','TRIANA NOVITASARI','BUSSINESS SUPPORT','081366676628','n','124','reg2','',1),(26,'9975080375','123456','a1','WIDYA PUTRA','BUSSINESS SUPPORT','08117118779','n','125','reg2','',1),(27,'1289488033','121212','a1','YUDO HARDIANTO','NMGA','081977855810','n','126','reg2','',1),(28,'0078170453','Aliyyah1','a1','YULIANTI','BUSINESS SUPPORT','08127103707','n','127','reg2','',1),(29,'1187396502','ucuv1987','a1','YUSUF HIDAYATULLAH','BUSSINESS SUPPORT','081273604176','n','128','reg2','',1),(30,'0884318031','12345','a1','AFRIN','REGIONAL BUSINESS CONTROL','081367545283','n','129','reg2','',1),(31,'9974081168','9974081168','a1','BOBY RAHAYU SAFIYUDIN','REGIONAL BUSINESS CONTROL','085720027100','n','130','reg2','',1),(32,'9968087411','9968087411','a1','DEWI ASMARA ANGGERAINI','REGIONAL BUSINESS CONTROL','08127101222','n','131','reg2','',1),(33,'0280184201','0280184201','a1','DEWI FARMASARI','REGIONAL BUSINESS CONTROL','082181227766','n','132','reg2','',1),(34,'1795668425','mandiri','a1','DIDAN NUGRAHA','REGIONAL BUSINESS CONTROL','082281008560','n','133','reg2','',1),(35,'1389502782','dinda','a1','DINDA JULITA','REGIONAL BUSINESS CONTROL','085788405327','n','134','reg2','',1),(36,'1290444538','1290444538','a1','FEBRI SURYATI PUTRI','REGIONAL BUSINESS CONTROL','085268181379','n','135','reg2','',1),(37,'1087362042','123456','a1','FERRY NUGRAHA','REGIONAL BUSINESS CONTROL','085777675753','n','136','reg2','',1),(38,'1181421157','1181421157','a1','FRANSISKUS SARI PUTRA SINURAYA','REGIONAL BUSINESS CONTROL','081220192099','n','137','reg2','',1),(39,'1081380701','1081380701','a1','LINA TJHIN','REGIONAL BUSINESS CONTROL','08122120224','n','138','reg2','',1),(40,'9971082540','9971082540','a1','LINDASARY','REGIONAL BUSINESS CONTROL','081271766470','n','139','reg2','',1),(41,'0482256930','0482256930','a1','M IQBAL AMIN','REGIONAL BUSINESS CONTROL','','n','140','reg2','',1),(42,'0381199207','mandiri','a1','MONICA KESUMAWATY','REGIONAL BUSINESS CONTROL','081274419190','n','141','reg2','',1),(1043,'1389505314','1389505314','a1','RIDHO YULIAN PERDANA','BUSINESS SUPPORT','081286917637','n','539','reg2','',1),(45,'1082380577','1082380577','a1','USWATY MUSMAR','REGIONAL BUSINESS CONTROL','081373073737','n','144','reg2','',1),(637,'admin2','12345','a0','Admin2','Admin','081279201946','n','145','reg2','',1),(638,'admin1','99999','a0','Admin1','Admin','081279201946','n','146','reg2','',1),(803,'admin3','12345','a0','Admin3','Admin','08111111','n','305','reg2','',1),(647,'9970133062','133062','a1','AHMAD SYUKRI','NMGA','081279201946','n','148','reg2','',1),(648,'9966056079','Mandiri123','a1','MUHAMMAD SAINI','TB RETAIL','082298589319','n','149','reg2','',1),(650,'1489553859','696969','a1','PURWANTO','NMGA','085269692926','n','151','reg2','',1),(651,'9974116725','152535','a1','JULIARDY','BUSINESS SUPPORT','081369268548','n','152','reg2','',1),(652,'1788663532','1788663532','a1','ALEX HARIANTO','BUSINESS SUPPORT','081267067830','n','153','reg2','',1),(653,'984035062','984035062','a1','SIMON P. PASARIBU','BUSINESS SUPPORT','081264436856','n','154','reg2','',1),(654,'278184296','278184296','a1','RINI OCTAVIA','BUSINESS SUPPORT','08127145797','n','155','reg2','',1),(655,'2199510037','ramacakil','a1','MUHAMMAD AULIA RAMADHAN','BUSINESS SUPPORT','089669512045','n','156','reg2','',1),(656,'1897030004','1897030004','a1','TIARA NUR APRI YANA','CONSUMER LOAN','0','n','157','reg2','',1),(657,'1086367182','Chandra86','a1','CHANDRA AFRIANTINA','CONSUMER LOAN','081271536817','n','158','reg2','',1),(658,'1489566836','mayleni','a1','MAYLENI','CONSUMER LOAN','081373114367','n','159','reg2','',1),(659,'1493050181','123456','a1','DWITYA AGUNG NUGRAHA','CONSUMER LOAN','085357939193','n','160','reg2','',1),(660,'1591030716','1591030716','a1','MUHAMMAD RENDY HENDIKA','CONSUMER LOAN','089677704830','n','161','reg2','',1),(661,'75173856','197575','a1','YENNI ANDRIANI','CONSUMER LOAN','0811784275','n','162','reg2','',1),(662,'777035053','777035053','a1','USMAN','CONSUMER LOAN','085268231839','n','163','reg2','',1),(663,'580273282','580273282','a1','AUGUSTINUS PARULIAN','CONSUMER LOAN','08114892003','n','164','reg2','',1),(664,'984348367','region2','a1','DESSY OCTORA','CONSUMER LOAN','081278314303','n','165','reg2','',1),(665,'1690390099','060812','a1','HERVINA SABILLA','CONSUMER LOAN','085216353525','n','166','reg2','',1),(666,'370193104','370193104','a1','BAMBANG INDRO PANOYO','CREDIT CARD','08129233376','n','167','reg2','',1),(667,'679135033','679135033','a1','ROHIM APRIADI','CREDIT CARD','081271746569','n','168','reg2','',1),(668,'1185030586','1185030586','a1','FAUZI','CREDIT CARD','85380442813','n','169','reg2','',1),(669,'1489011029','1489011029','a1','RESIA DARNA','CREDIT CARD','081222400754','n','170','reg2','',1),(670,'1793390203','1793390203','a1','FEBRICHA HARDANITA','CREDIT CARD','085273224203','n','171','reg2','',1),(671,'1791410996','1791410996','a1','NINDRI WULANDARI','CREDIT CARD','081367758000','n','172','reg2','',1),(672,'1995510004','1995510004','a1','MUHAMMAD IHSANUDDIN','CREDIT CARD','0812176052794','n','173','reg2','',1),(673,'2096510034','kobebryant7','a1','M. WISNU WARDANI','CREDIT CARD','085832089552','n','174','reg2','',1),(674,'1996030104','1996030104','a1','PETI NUR SUKIANI','CREDIT CARD','085269531473','n','175','reg2','',1),(675,'2199030001','2199030001','a1','OCHA LANA GURNITA','CREDIT CARD','089518874391','n','176','reg2','',1),(676,'2197030107','2197030107','a1','NINDRI AINUN','CREDIT CARD','085368305370','n','177','reg2','',1),(677,'984025049','984025049','a1','ENDANG RAHAYU SIREGAR','CREDIT CARD','081273769079','n','178','reg2','',1),(678,'1085025056','1085025056','a1','DIAH KURNIATY','CREDIT CARD','082179984128','n','179','reg2','',1),(679,'1186020115','1186020115','a1','META AGUSTINA','CREDIT CARD','085273530707','n','180','reg2','',1),(680,'1090035044','1090035044','a1','ARIE RAMADHANI','CREDIT CARD','081377661824','n','181','reg2','',1),(681,'1187020110','1187020110','a1','MUKROMAH','CREDIT CARD','081930669320','n','182','reg2','',1),(682,'1287011296','1287011296','a1','TRI NULANDARI','CREDIT CARD','081271944559','n','183','reg2','',1),(683,'1591260073','1591260073','a1','LIA OKTASARI','CREDIT CARD','85367990092087','n','184','reg2','',1),(685,'1691410641','1691410641','a1','IRIN ARWIANI','CREDIT CARD','81254636640','n','186','reg2','',1),(686,'1893030001','1893030001','a1','SERLY OCTAVIANI','CREDIT CARD','082280700072','n','187','reg2','',1),(687,'1795411222','1795411222','a1','RIZKI NOVITA SARI','CREDIT CARD','08998410898','n','188','reg2','',1),(688,'1797390671','1797390671','a1','FEBRA MUZDALIFAH','CREDIT CARD','082280786002','n','189','reg2','',1),(689,'1894510002','1894510002','a1','KHOIRIYATUL UMAMI BAHAR','CREDIT CARD','082279454045','n','190','reg2','',1),(690,'2099510041','2099510041','a1','MIFTAHUL JANNAH','CREDIT CARD','081279478968','n','191','reg2','',1),(691,'1997510002','1997510002','a1','WAHYU FEBRIANTO','CREDIT CARD','085838864349','n','192','reg2','',1),(692,'1996030040','1996030040','a1','ANGGUN YULIANI SAPUTRI','CREDIT CARD','08973035017','n','193','reg2','',1),(693,'1996030063','1996030063','a1','MELITA FITRIANA','CREDIT CARD','085267722092','n','194','reg2','',1),(694,'1998510089','pranata02','a1','OVANDZA ARNALDHO PRANATA','CREDIT CARD','081377562265','n','195','reg2','',1),(695,'1998030103','1998030103','a1','MIRANDA SISWANTI SIREGAR','CREDIT CARD','082178919895','n','196','reg2','',1),(696,'2095030040','2095030040','a1','DINA ROSDIANA','CREDIT CARD','081288300884','n','197','reg2','',1),(697,'2198030116','2198030116','a1','WINDY JULAIHA FRAMESHELLA','CREDIT CARD','082280578122','n','198','reg2','',1),(698,'2199030106','2199030106','a1','CHELLA MARYSKHA PUTRI','CREDIT CARD','085273714408','n','199','reg2','',1),(699,'1490554714','Palembang2022','a1','RIDHA CINDIA YOSI','CREDIT CARD','085313141453','n','200','reg2','',1),(700,'378195465','kanwil22','a1','RIZAL YUDISTIRA','CREDIT CARD','0811711978','n','201','reg2','',1),(701,'681292348','681292348','a1','MINTO PRIYO LEKSONO','CREDIT CARD','08558637039','n','202','reg2','',1),(702,'1289010905','Gita2508','a1','GITA PUTRI SUDA','CREDIT CARD','082375283242','n','203','reg2','',1),(703,'1690643879','098765','a1','UMI MUSLIMAH','CREDIT CARD','082177350562','n','204','reg2','',1),(704,'1291488088','mandiri08','a1','NIDDYA SARI RISKI','CREDIT CARD','081278221330','n','205','reg2','',1),(705,'1391010881','1391010881','a1','INDAH PERMATASARI','CREDIT CARD','082374742177','n','206','reg2','',1),(706,'1592260021','1592260021','a1','DWI NAZTIA RANI','CREDIT CARD','081278282721','n','207','reg2','',1),(707,'1793390010','1793390010','a1','TRI HARTANTO','CREDIT CARD','081218531256','n','208','reg2','',1),(708,'1896030049','1896030049','a1','STEFANY YANHEL','CREDIT CARD','08980937227','n','209','reg2','',1),(709,'1794410607','1794410607','a1','FIRA SARI','CREDIT CARD','081271888821','n','210','reg2','',1),(710,'1692390275','090311','a1','NALITA PERMATASARI','CREDIT CARD','082177680495','n','211','reg2','',1),(711,'2197030029','2197030029','a1','HESTI DWI LESTARI','CREDIT CARD','081368000082','n','212','reg2','',1),(712,'9974096976','yarahman','a1','YAYAN MUKHARYANTO','E-CHANNEL OPERATIONS','081298653732','n','213','reg2','',1),(713,'9970082939','nakari01','a1','MULYADI','E-CHANNEL OPERATIONS','08127807856','n','214','reg2','',1),(714,'778035139','778035139','a1','SUDIRMAN K','E-CHANNEL OPERATIONS','81978376883','n','215','reg2','',1),(715,'986347869','alzarisma','a1','ALZAR AGUS PRATAMA','E-CHANNEL OPERATIONS','081367741133','n','216','reg2','',1),(716,'1190055441','1190055441','a1','AMRULLAH','E-CHANNEL OPERATIONS','81994818354','n','217','reg2','',1),(718,'2195747159','2195747159','a1','M. BAYU SURYA PRATAMA','E-CHANNEL OPERATIONS','081279481536','n','219','reg2','',1),(719,'1896510113','siskaeka','a1','SISKA EKA KURNIA','E-CHANNEL OPERATIONS','081958345145','n','220','reg2','',1),(720,'1996510020','mandirisekut','a1','HERU PRASETYO','E-CHANNEL OPERATIONS','082281832582','n','221','reg2','',1),(721,'2096510050','2096510050','a1','ATHIYAH SHALEHA MEILANY','E-CHANNEL OPERATIONS','082182986837','n','222','reg2','',1),(722,'2195510040','2195510040','a1','DESTI INDAH RISKI','E-CHANNEL OPERATIONS','0812794191550','n','223','reg2','',1),(723,'9969044916','demang2002','a1','KAHARUDIN','E-CHANNEL OPERATIONS','08127129669','n','224','reg2','',1),(724,'1489553982','beni1989','a1','BENI SETIAWAN AGUS','E-CHANNEL OPERATIONS','081293932721','n','225','reg2','',1),(725,'1084361104','renmen','a1','RENNY MANELI','E-CHANNEL OPERATIONS','081271010800','n','226','reg2','',1),(726,'1290051334','1290051334','a1','TRI HARDANI','E-CHANNEL OPERATIONS','089695971008','n','227','reg2','',1),(727,'1693260044','tigadua1','a1','MUHAMMAD SEPTHYADI ANANDAR','E-CHANNEL OPERATIONS','085383575794','n','228','reg2','',1),(728,'1693390096','011093','a1','AYU PERMATASARI','BUSSINESS SUPPORT','081293214625','n','229','reg2','',1),(729,'77169480','77169480','a1','DESSY DASTINI','GOVERNMENT','08127831977','n','230','reg2','',1),(730,'1187396981','Wina','a1','WINA SEPTIANI','GOVERNMENT','08117194444','n','231','reg2','',1),(731,'9974034027','9974034027','a1','IWAN SETIAWAN','GOVERNMENT','08118166100','n','232','reg2','',1),(732,'1591608013','Anggi','a1','DWI ANGGRAINI','GOVERNMENT','082176599442','n','233','reg2','',1),(733,'1584591291','1584591291','a1','MUHAMMAD DONY KELVIN','MIKRO BANKING','081367166655','n','234','reg2','',1),(734,'479259103','479259103','a1','ADE RIANTI','MIKRO BANKING','0811782048','n','235','reg2','',1),(735,'1086376134','Aisyah16','a1','WINDA NOPILIA','MIKRO BANKING','082181843322','n','236','reg2','',1),(736,'9967080623','123456','a1','ACEP ADIOSO','MIKRO BANKING','08127403909','n','237','reg2','',1),(737,'1389490053','mylifefio','a1','PUTRI FIONA RACHIM','MIKRO BANKING','08117232350','n','238','reg2','',1),(738,'1389492802','123456','a1','DIAN ASRI','MIKRO BANKING','08127947518','n','239','reg2','',1),(739,'1079379798','1079379798','a1','ACHMAD SIDDIQ','MIKRO BANKING','0816412379','n','240','reg2','',1),(740,'1592597686','mandiri1','a1','ALVI NEFRIZAR','MIKRO BANKING','081272878212','n','241','reg2','',1),(741,'1487060558','1487060558','a1','HENDI WIRYADI','MIKRO BANKING','82183008489','n','242','reg2','',1),(742,'1182055442','1182055442','a1','HAIRUL FIKRI','MIKRO BANKING','81270369582','n','243','reg2','',1),(743,'1385050068','1385050068','a1','JULI SUTRISNO','MIKRO BANKING','8980900469','n','244','reg2','',1),(744,'1794390258','1794390258','a1','DONNI SETYAWAN','MIKRO BANKING','08994293536','n','245','reg2','',1),(745,'1698390214','1698390214','a1','ROBI SAPUTRA','MIKRO BANKING','081377978727','n','246','reg2','',1),(746,'1489060371','12345','a1','SUPANTO ANDERSON','MIKRO BANKING','085369622689','n','247','reg2','',1),(747,'1387060466','12345','a1','OKA TRI ARIYANTO','MIKRO BANKING','081277','n','248','reg2','',1),(748,'1084367192','mandiri','a1','MUHAMMAD FERDI FEBRIAN','REGIONAL CHIEF FINANCIAL','08117877007','n','249','reg2','',1),(749,'1388496184','mandiri','a1','ROSALINA','REGIONAL CHIEF FINANCIAL','081271614378','n','250','reg2','',1),(750,'1390506426','Dike*2801','a1','DIKE BAKTI PIANSA','REGIONAL CHIEF FINANCIAL','085267667511','n','251','reg2','',1),(751,'684292477','684292477','a1','DENDI RIANDI','REGIONAL CHIEF FINANCIAL','08179828506','n','252','reg2','',1),(752,'1088352653','1088352653','a1','WAHYU UTAMI','REGIONAL CHIEF FINANCIAL','081373614271','n','253','reg2','',1),(753,'1389514886','1389514886','a1','PEBRI','REGIONAL CHIEF FINANCIAL','085267834754','n','254','reg2','',1),(754,'1392541561','1392541561','a1','DIYAS MAHILZAN','REGIONAL CHIEF FINANCIAL','08117874422','n','255','reg2','',1),(755,'1591585864','harris29','a1','K. HARRIS WARDHANA','REGIONAL CHIEF FINANCIAL','08114812922','n','256','reg2','',1),(758,'1387512395','123123','a1','VICKY YULVIAN RINALDI','RETAIL FUNDING','+62 821-8224-004','n','259','reg2','',1),(757,'1087362737','1087362737','a1','MUHAMMAD SHIDDIQ','RETAIL FUNDING','082279964459','n','258','reg2','',1),(759,'2096510008','retailfunding','a1','NATASHA NOVIA ANDIANI','RETAIL FUNDING','082148413311','n','260','reg2','',1),(760,'1491554002','1491554002','a1','ASMARULLAH AKBAR','RETAIL FUNDING','087897866638','n','261','reg2','',1),(761,'1691390272','retailfunding','a1','DIDI KUSUMA WIJAYA','RETAIL FUNDING','082148413311','n','262','reg2','',1),(762,'9971018650','9971018650','a1','IRMAYANI','RETAIL FUNDING','08127121971','n','263','reg2','',1),(763,'9972091110','9972091110','a1','SYAFRIN AMINULLAH T','SME REGION','081396964599','n','264','reg2','',1),(764,'9973051865','9973051865','a1','MARUDUR NAPITUPULU','SME REGION','08127819440','n','265','reg2','',1),(766,'1490554409','1490554409','a1','DENI BASTARI','SME REGION','081279720180','n','267','reg2','',1),(767,'1389536244','1389536244','a1','AEP SAEPUDIN','SME REGION','082190333229','n','268','reg2','',1),(768,'1587030212','1587030212','a1','MUHAMMAD REZA PADLY','SME REGION','08980880848','n','269','reg2','',1),(769,'1990510001','1990510001','a1','JULIET KURNIADI','SME REGION','081214866623','n','270','reg2','',1),(1034,'2199005847','2199005847k','a1','EGI SYAHPUTRA A','BUSSINESS SUPPORT','081368309438','n','530','reg2','',1),(772,'1088385661','1088385661','a1','RISMA EKA DESTITA','TB RETAIL','082281554440','n','273','reg2','',1),(773,'1694260052','Mandiri123','a1','NUGRAH MAULANA','TB RETAIL','081212129794','n','274','reg2','',1),(774,'1794390213','1794390213','a1','AHMAD CHAIRULLAH','TB RETAIL','081377879755','n','275','reg2','',1),(775,'1289431942','1289431942','a1','DENNISA SATRIAVI','TB RETAIL','081224509112','n','276','reg2','',1),(776,'1390514867','300590','a1','MEILAN DANI','TB RETAIL','081367185356','n','277','reg2','',1),(777,'1998510080','1998510080','a1','ALAM NUR HARUN','TB RETAIL','0819736782843','n','278','reg2','',1),(778,'1390502839','1390502839','a1','CHICI OKTAVIA','TB RETAIL','oK252525','n','279','reg2','',1),(779,'1591607106','1591607106','a1','JOBPIE AGUNG SASMITA','TB RETAIL','081375293309','n','280','reg2','',1),(780,'1692260032','1692260032','a1','FEBRY PERMANA','TB RETAIL','081994951707','n','281','reg2','',1),(781,'1593597057','12345','a1','AGUNG FUAD PAHLEVI','TB RETAIL','08126932222','n','282','reg2','',1),(782,'883310500','241283','a1','LINDA DESTIANTY WAWONDATU','TB WHOLESALE','0811879545','n','283','reg2','',1),(783,'9967073081','9967073081','a1','RIADI','TB WHOLESALE','081510600820','n','284','reg2','',1),(784,'1894673383','1894673383','a1','NORATIO VALENTINA','TB WHOLESALE','085267676939','n','285','reg2','',1),(785,'9972032916','9972032916','a1','MARTIAS DUTA MIMBI','TB WHOLESALE','082374160097','n','286','reg2','',1),(786,'1492557723','akumanis07','a1','ELECTRINA RAHMADANI','TB WHOLESALE','082377487118','n','287','reg2','',1),(787,'1086378791','Mandiri123','a1','M FEBRI SALEH','TB WHOLESALE','081267108560','n','288','reg2','',1),(788,'1488050027','1488050027','a1','ROBANI RAMA JAYA','TB WHOLESALE','081958483891','n','289','reg2','',1),(789,'1490551744','P@sword1','a1','M. RICHO ADITYA NUGRAHA','TB WHOLESALE','081366641644','n','290','reg2','',1),(790,'1187424486','Garfield17','a1','GARTIWA RIYADI','TB WHOLESALE','081278862551','n','291','reg2','',1),(791,'1494568660','always','a1','EMILY EDMONDA PUTRI','TB WHOLESALE','081286057402','n','292','reg2','',1),(792,'1895699098','1895699098','a1','REZKY ARTA AFRINA','TB WHOLESALE','081284239008','n','293','reg2','',1),(793,'1895690659','123456','a1','BREVITA','TB WHOLESALE','081273541054','n','294','reg2','',1),(794,'1688390332','1688390332','a1','JIMMY MANIYU','TB RETAIL','81273622901081','n','295','reg2','',1),(795,'887318269','887318269','a1','ASTRI RAHANDINI','TB WHOLESALE','08117801987','n','296','reg2','',1),(796,'9972083513','240378','a1','ROYKE BINTORO','TB WHOLESALE','08127108980','n','297','reg2','',1),(797,'78174224','78174224','a1','YUNIZA TRIANA','TB WHOLESALE','08117086341','n','298','reg2','',1),(798,'774035125','774035125','a1','SALAMUN ','TB WHOLESALE','081373606104','n','299','reg2','',1),(799,'9973045040','mandiri1','a1','LENNY MARLINA','WEALTH BUSINESS','081271814700','n','300','reg2','',1),(800,'1992510001','mandiri123','a1','M DENI JULIANSYAH','WEALTH BUSINESS','081368014009','n','301','reg2','',1),(801,'1592598767','1592598767','a1','ARIEF DWI HARTANTO','WEALTH BUSINESS','081958138718','n','302','reg2','',1),(805,'9975104043','757575','a1','RIDUANSYAH','BUSINESS SUPPORT','08125179288','n','307','reg2','',1),(804,'2100510062','Lebaran','a1','MUHAMMAD IQBAL ALFIYAN','BUSINESS SUPPORT','089620272582','n','306','reg2','',1),(811,'admin110','mandiri1','a0','Admin AREA JAMBI','AREA JAMBI','081111','n','310','110','',1),(812,'admin111','mandiri1','a0','Admin AREA PADANG','AREA PADANG','081111','n','311','111','',1),(813,'admin112','ga112','a0','Admin AREA PALEMBANG SUDIRMAN','AREA PALEMBANG SUDIRMAN','081111','n','312','112','',1),(814,'admin113','112233','a0','Admin AREA PALEMBANG ARIEF','AREA PALEMBANG ARIEF','081111','n','313','113','',1),(815,'admin114','mandiri1','a0','Admin AREA BANDAR LAMPUNG','AREA BANDAR LAMPUNG','081111','n','314','114','',1),(816,'admin169','mandiri1','a0','Admin AREA PANGKALPINANG','AREA PANGKALPINANG','081111','n','315','169','',1),(1115,'','','a1','','','','','611','','',1),(1116,'','','a1','','','','','612','','',1),(1035,'GA admin7','212212','a1','GA ADMIN7','NMGA','0581279429','n','531','reg2','',1),(1036,'GA admin8','212212','a1','GA ADMIN8','NMGA','082180412714','n','532','reg2','',1),(1037,'1289450983','140389','a1','M. HANDY KASTRIANTO','BUSINESS SUPPORT AREA','082373677774','n','533','112','',1),(1024,'0986347793','mandiri','a1','HARIS KURNIAWAN','REGIONAL BUSINESS CONTROL','085377101007','n','520','reg2','',1),(826,'1592607964','mandiri','a1','MUHAMMAD KHARISMA','AREA TRANSACTION FUNDING','08117878192','n','324','113','',1),(828,'1289444416','Mandiri113','a1','ACHMAD ARIEF HIDAYATULLAH','CREDIT CARD AREA','08117897771','n','326','113','',1),(830,'0278184379','Mandiri6','a1','RAHMALIA','CONSUMER LOAN AREA ','08117186278','n','328','113','',1),(1038,'1894675065','220820','a1','M RIFKY PAMUNGKAS ','LEGAL REGION','08117878101','n','534','reg2','',1),(1022,'GA admin4','212212','a1','GA ADMIN4','BUSINESS SUPPORT','082180412714','n','518','reg2','',1),(1049,'','','a1','','','','','545','','',1),(1050,'1492567169','Crm100','a1','CAHYA PURNAMA SEPTIANI','CONSUMER LOAN AREA ','081221550002','n','546','113','',1),(834,'1387495112','999999999999','a1','AMIR SYARIF','CONSUMER LOAN AREA ','081271700477','n','332','113','',1),(1062,'2309100660','112233','a1','DAFA HAYYUN OKTARIZA','BUSINESS SUPPORT AREA','08982013615','n','558','113','',1),(1040,'1793390670','aku112233','a1','MUHAMMAD JAMALUDIN HIDAYATULLAH','E-CHANNEL OPERATIONS','082279135140','n','536','reg2','',1),(1058,'2399019607','123456','a1','KINANTI QURNIA WI','BUSINESS SUPPORT','082175272441','n','554','reg2','',1),(1063,'1593597057','12345','a1','AGUNG FUAD PAHLEVI','BUSINESS SUPPORT','08126932222','n','559','reg2','',1),(839,'097734091','097734091','a1','M WILLY VIRDIAN','MIKRO BANKING AREA','082179706430','n','337','113','',1),(840,'','','a1','','','','','338','','',1),(844,'9974099483','ilhan2002','a1','MARYATI','AREA BUSINESS CONTROL','08127828724','n','342','113','',1),(1101,'','','a1','','','','','597','','',1),(1102,'','','a1','','','','','598','','',1),(1103,'','','a1','','','','','599','','',1),(1104,'','','a1','','','','','600','','',1),(1105,'','','a1','','','','','601','','',1),(1106,'','','a1','','','','','602','','',1),(848,'1285481131','654321','a1','KARMANIANTO','BUSINESS SUPPORT','081271224111','n','346','113','',1),(849,'9973123573','9973123573','a1','ERWIN TITO','BUSINESS SUPPORT','081369729611','n','347','113','',1),(1097,'','','a1','','','','','593','','',1),(1098,'','','a1','','','','','594','','',1),(1107,'','','a1','','','','','603','','',1),(1108,'','','a1','','','','','604','','',1),(853,'9974109860','mandiri123','a1','ERWIN RANGGA WIJAYA','BUSINESS SUPPORT AREA','081272625424','n','351','113','',1),(1113,'','','a1','','','','','609','','',1),(1114,'','','a1','','','','','610','','',1),(1059,'1591609144','051093','a1','OKTA META INTAN SARI','GOVERNMENT','081373699993','n','555','reg2','',1),(1064,'2406100854','Vivi25','a1','VIVIAN SHINTANA','BUSINESS SUPPORT AREA','085928036785','n','560','113','',1),(1041,'1289429764','1289429764','a1','ARIEFCO SAPUTRA','NMGA','082228885958','n','537','reg2','',1),(1023,'2299776443','1701051999','a1','DWIANZA','BUSINESS SUPPORT','082280244141','n','519','reg2','',1),(1042,'Hardiansyah','22102022','a1','HARDIANSYAH','NMGA','082180008797','n','538','reg2','',1),(1046,'2296758873','Mandiri@123','a1','GIOFHANI APRIYANSYAH','BUSINESS SUPPORT','087795498484','n','542','reg2','',1),(1047,'0885318311','ilzam','a1','ILZAM RAHMADI','WEALTH BUSINESS','08127112524','n','543','reg2','',1),(879,'098834802','098834802','a1','FITRY RAMEYDA','AREA BUSINESS CONTROL','081373280813','n','377','113','',1),(880,'1488563388','328181Nv','a1','M ABDULLAH','BRANCH PAL ARIEF','081368846886','n','378','113','',1),(1123,'','','a1','','','','','619','','',1),(1124,'','','a1','','','','','620','','',1),(1122,'','','a1','','','','','618','','',1),(1057,'2301494675','123456','a1','ANDRI PRAMANA','CREDIT CARD','085769709192','n','553','reg2','',1),(899,'2094510013','818288','a1','KHAIRUNISA DWI PRADESTI','BUSINESS SUPPORT','085219701345','n','397','113','',1),(1109,'','','a1','','','','','605','','',1),(1110,'','','a1','','','','','606','','',1),(1111,'','','a1','','','','','607','','',1),(1112,'','','a1','','','','','608','','',1),(903,'0776035380','181176','a1','MUHAMMAD HENDRY HAFIZ','BUSINESS SUPPORT','081294477072','n','400','113','',1),(904,'1896510135','budi1996','a1','BUDI FIRMANSYAH','BUSINESS SUPPORT','083173480280','n','401','113','',1),(1117,'','','a1','','','','','613','','',1),(1118,'','','a1','','','','','614','','',1),(1119,'','','a1','','','','','615','','',1),(1120,'','','a1','','','','','616','','',1),(1121,'','','a1','','','','','617','','',1),(907,'1589030468','101090','a1','AKBAR TANJUNG','BUSINESS SUPPORT','082176922010','n','404','113','',1),(993,'2298758913','mandiri','a1','ALAM NUR HARUN','REGIONAL CHIEF FINANCIAL','081271614378','n','490','reg2','',1),(1151,'','','a1','','','','','647','','',1),(1152,'','','a1','','','','','648','','',1),(1153,'','','a1','','','','','649','','',1),(1154,'','','a1','','','','','650','','',1),(1155,'','','a1','','','','','651','','',1),(1132,'','','a1','','','','','628','','',1),(1131,'','','a1','','','','','627','','',1),(1130,'','','a1','','','','','626','','',1),(1129,'','','a1','','','','','625','','',1),(1128,'','','a1','','','','','624','','',1),(1127,'','','a1','','','','','623','','',1),(1126,'','','a1','','','','','622','','',1),(1125,'','','a1','','','','','621','','',1),(1096,'','','a1','','','','','592','','',1),(1095,'','','a1','','','','','591','','',1),(1094,'','','a1','','','','','590','','',1),(1093,'','','a1','','','','','589','','',1),(1092,'','','a1','','','','','588','','',1),(1137,'','','a1','','','','','633','','',1),(1138,'','','a1','','','','','634','','',1),(1139,'','','a1','','','','','635','','',1),(1140,'','','a1','','','','','636','','',1),(1141,'','','a1','','','','','637','','',1),(1142,'','','a1','','','','','638','','',1),(1143,'','','a1','','','','','639','','',1),(1144,'','','a1','','','','','640','','',1),(1145,'','','a1','','','','','641','','',1),(1146,'','','a1','','','','','642','','',1),(1147,'','','a1','','','','','643','','',1),(1148,'','','a1','','','','','644','','',1),(1149,'','','a1','','','','','645','','',1),(1150,'','','a1','','','','','646','','',1),(935,'1895704765','amryllah95','a1','M. YASSER AMRYLLAH ARMAS','Business Support Area','081286007741','n','433','112','',1),(1066,'2301490100','Splunk7.','a1','PUTRI ASI SUGMA WIJAYA','SME AREA','085279708992','n','562','112','',1),(1068,'1897683546','Palsud22','a1','NAUFAL SHIDDIQ','AREA TRANSACTION FUNDING','082306392220','n','564','112','',1),(1069,'2398494467','Macantutul1','a1','MUHAMMAD HATTA','CONSUMER LOAN AREA ','085357956569','n','565','112','',1),(975,'1896510066','inter01','a1','JULIAN ADITYA SAPUTRA','CONSUMER LOAN AREA ','081271312234','n','473','112','',1),(1065,'1389539024','Sabun@234','a1','M RUDIANSYAH','BUSINESS SUPPORT AREA','082182887766','n','561','112','',1),(978,'1694624016','Splunk6.','a1','YOSSIE YOLANDA','SME AREA','082177773363','n','476','112','',1),(1070,'2301490100','Splunk7.','a1','PUTRI ASI SUGMA WIJAYA','SME AREA','085279708992','n','566','112','',1),(1071,'1694624016','Splunk6.','a1','YOSSIE YOLANDA','SME AREA','082177773363','n','567','112','',1),(1072,'2298758970','Splunk1.','a1','DEVI TRI REFINA','SME AREA','081271210598','n','568','112','',1),(1073,'2301490011','balyan1812','a1','M BALYAN MULKAN','BUSINESS SUPPORT AREA','088287932720','n','569','112','',1),(1076,'1492562715','mandiri','a1','AFIFI WIDAYANI','BRANCH PAL SUDIRMAN','085263621117','n','572','112','',1),(1075,'0985328533','abc112','a1','HENDRY FIRMANSYAH','AREA BUSINESS CONTROL','081373400185','n','571','112','',1),(1078,'','','a1','','','','','574','','',1),(1079,'','','a1','','','','','575','','',1),(1080,'','','a1','','','','','576','','',1),(1081,'','','a1','','','','','577','','',1),(1082,'','','a1','','','','','578','','',1),(1083,'','','a1','','','','','579','','',1),(1084,'','','a1','','','','','580','','',1),(1085,'','','a1','','','','','581','','',1),(1086,'','','a1','','','','','582','','',1),(1087,'','','a1','','','','','583','','',1),(1088,'','','a1','','','','','584','','',1),(1089,'','','a1','','','','','585','','',1),(1090,'','','a1','','','','','586','','',1),(1091,'','','a1','','','','','587','','',1),(1136,'','','a1','','','','','632','','',1),(1135,'','','a1','','','','','631','','',1),(1134,'','','a1','','','','','630','','',1),(1133,'','','a1','','','','','629','','',1),(989,'admin179','mandiri1','a0','Admin AREA BENGKULU','AREA BENGKULU','0811111','n','','179','',1),(991,'1289444416','Mandiri113','a1','A ARIEF H','AREA TRANSACTION FUNDING','08117897771','n','488','113','',1),(996,'2298510004','Yugaganteng123','a1','YUGA ALFIQIH','CREDIT CARD','0895610940652','n','493','reg2','',1),(1044,'2298776501','gilogilo123','a1','FAREL SATRIO SUDIHARTO','BUSINESS SUPPORT','082183844277','n','540','reg2','',1),(1045,'0078169059','08197872749','a1','NANI TRIANA','CONSUMER LOAN','08197872749','n','541','reg2','',1),(1000,'1188397004','Ramadanu2','a1','BRORY WAHYUDI','WEALTH BUSINESS','085267818088','n','497','reg2','',1),(1007,'1892675166','Mandiri1','a1','ADIEB WIJAKSONO','NMGA','085279740075','n','504','reg2','',1),(1008,'2299765651','givt030999','a1','HELVANDA','BUSSINESS SUPPORT','082280621659','n','505','reg2','',1),(1010,'1593593056','1593593056','a1','LINTANG DAMARJATI','BUSSINESS SUPPORT','082176574977','n','507','reg2','',1),(1017,'0581279429','212212','a1','MARDIANSYAH','BUSSINESS SUPPORT','082180412714','n','513','reg2','',1),(1019,'GA Training','212212','a1','GA ADMIN','BUSSINESS SUPPORT','082180412714','n','515','reg2','',1),(1020,'GA Training2','212212','a1','GA ADMIN2','BUSINESS SUPPORT','082180412714','n','516','reg2','',1),(1021,'GA admin3','212212','a1','GA ADMIN3','BUSINESS SUPPORT','082180412714','n','517','reg2','',1),(1027,'GA admin5','212212','a1','GA ADMIN5','BUSSINESS SUPPORT','082180412714','n','523','reg2','',1),(1028,'1491568093','qwerty','a1','TRI YUVITA UNIT CCO','E-CHANNEL OPERATIONS','082378927732','n','524','reg2','',1),(1029,'Admin3','Admin3','a0','YUDI ','Admin','082278199009','n','525','reg2','',1),(1030,'2397491964','yedhibaru123','a1','M SAYIDHI','CREDIT CARD','081273477306','n','526','reg2','',1),(1031,'Ga admin6','212212','a1','GA ADMIN6','HC&GA','082180412714','n','527','reg2','',1),(1032,'Dessy octora','mandiri123','a1','DESSY OCTORA','CONSUMER LOAN','081278314303','n','528','reg2','',1),(1077,'','','a1','','','','','573','','',1),(1051,'2198510070','merin1998','a1','MARINE MARLINDA INDRA PUTRI','BUSINESS SUPPORT AREA','082182640644','n','547','113','',1),(1053,'1694603523','940205','a1','TITA HAYUNINGTYAS','BUSSINESS SUPPORT','08113033702','n','549','reg2','',1),(1054,'1289439770','Mandiri11203','a1','RM TAHA ARYA REZKY','MIKRO BANKING','081373662747','n','550','reg2','',1),(1055,'2300797719','palembang123','a1','DIKY LEONARDI','HC&GA','082185507779','n','551','reg2','',1),(1056,'2300797503','Jantobat10','a1','PEBRY AJHRY','HC&GA','087731420909','n','552','reg2','',1),(1060,'2396804635','namaste','a1','IVON ANGGRI RIA','HC&GA','082176793311','n','556','reg2','',1),(1061,'2206100422','Kookie2013','a1','ULFA HASANAH','AREA TRANSACTION FUNDING','085960362255','n','557','113','',1);

--
-- Table structure for table `webdata`
--

CREATE TABLE `webdata` (
  `noma` int(10) unsigned NOT NULL,
  `tgl` datetime NOT NULL,
  `nomas` int(11) NOT NULL,
  `pile` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `webdata`
--

INSERT INTO `webdata` VALUES (1,'2019-07-17 01:29:25',20,'20_parkir_capture.jpg'),(2,'2019-07-17 01:31:26',20,'20_parkir_capture.jpg'),(3,'2019-07-17 01:32:40',20,'20_parkir_capture.jpg'),(4,'2019-07-17 01:32:57',20,'20_06-image_1541441930_5be0898ab9520.jpg'),(9,'2019-07-18 00:05:58',5,'5_IMG-20190717-WA0011.jpg'),(14,'2019-09-20 11:56:17',12,'12_90171613-C00F-45C6-831E-00DB714F020A.jpeg'),(13,'2019-08-21 18:13:27',10,'10_IMG-20190821-WA0025.jpg'),(15,'2019-10-23 14:49:01',13,'13_15718169198434653805663423454940.jpg'),(16,'2019-11-14 09:41:04',32,'32_30E4AC95-EF44-4F88-B55B-7BD2EE1F6DB5.jpeg'),(17,'2019-11-14 12:09:20',33,'33_7C0EB78E-82CB-4A73-85F6-A6AD8967745E.jpeg'),(18,'2019-11-14 12:13:18',34,'34_ED7C7AB3-FBA6-46EC-A857-C0391D157594.jpeg'),(19,'2019-11-14 12:36:32',35,'35_5BAE31CB-303C-4096-A36A-926792274993.jpeg'),(20,'2019-11-14 12:46:28',36,'36_08C9A4BD-62F4-42B8-891A-41B479E0EC08.jpeg'),(21,'2019-11-14 13:59:36',38,'38_C7069218-BC6B-400B-B0D3-3A13A453A96B.jpeg'),(22,'2019-11-14 14:30:58',39,'39_151A3E66-CD93-4D1A-A4FB-D00979EB5E33.jpeg');

--
-- Final view structure for view `datamobil`
--

/*!50001 DROP VIEW IF EXISTS `datamobil`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`regionpl`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `datamobil` AS select `c`.`tglb` AS `tglb`,coalesce(`b`.`kode`,'') AS `kode`,coalesce(`b`.`driver`,'') AS `driver`,coalesce(`a`.`mobil`,'') AS `mobil`,coalesce(`a`.`tgl_pesan`,'') AS `tgl_pesan`,count(`a`.`mobil`) AS `jmk`,`a`.`rega` AS `rega` from ((`tglb` `c` left join `trans` `a` on(`c`.`tglb` = `a`.`tgl_pesan`)) left join `mobil` `b` on(`b`.`kode` = `a`.`mobil`)) where `a`.`sts` = 'Closing' group by `b`.`kode`,`b`.`driver`,`a`.`mobil`,`a`.`tgl_pesan`,`c`.`tglb`,`a`.`rega` */;

--
-- Final view structure for view `dataunit`
--

/*!50001 DROP VIEW IF EXISTS `dataunit`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`regionpl`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `dataunit` AS select `c`.`tglb` AS `tglb`,coalesce(`b`.`kode`,'') AS `kode`,coalesce(`b`.`driver`,'') AS `driver`,coalesce(`a`.`unit`,'') AS `unit`,coalesce(`a`.`tgl_pesan`,'') AS `tgl_pesan`,count(`a`.`mobil`) AS `jmk`,`a`.`rega` AS `rega` from ((`tglb` `c` left join `trans` `a` on(`c`.`tglb` = `a`.`tgl_pesan`)) left join `mobil` `b` on(`b`.`kode` = `a`.`mobil`)) where `a`.`sts` = 'Closing' group by `b`.`kode`,`b`.`driver`,`a`.`mobil`,`a`.`tgl_pesan`,`c`.`tglb`,`a`.`rega` */;


