INSERT INTO `s_transaction` VALUES (392277,'T25004613','2025-07-02',5,10,NULL,36000,2,153753200,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392277.jpg','pembelian materai (01 juli)',9,9,'2025-07-02 13:13:00','2025-07-02 13:13:02'),(392278,'T25004614','2025-07-02',5,63,NULL,37160000,2,116593200,'widia',4,NULL,'pindah ke kas management closingan (01 juli)',9,9,'2025-07-02 13:14:48','2025-07-02 13:14:49'),(392279,'T25004615','2025-07-02',5,64,NULL,61929500,2,54663700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392279.jpg','setor tunai (02 juli)',9,9,'2025-07-02 13:17:16','2025-07-02 13:17:18'),(392280,'T25004616','2025-07-02',5,64,NULL,52915000,2,1748700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392280.jpg','setor tunai (02 juli)',9,9,'2025-07-02 13:18:08','2025-07-02 13:18:09'),(392281,'T25004617','2025-07-02',5,19,NULL,7500,2,1741200,'widia',4,NULL,'parkir mobil recehan dani,rizal,adis (02 juli)',9,9,'2025-07-02 13:19:06','2025-07-02 13:19:06'),(392282,'T25004618','2025-07-02',5,23,NULL,80000,2,1661200,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392282.jpg','bensin motor pagi rival,wahyu,ade,ojt (02 juli)',9,9,'2025-07-02 13:20:01','2025-07-02 13:20:03'),(392283,'T25004619','2025-07-02',5,7,NULL,60000,2,1601200,'widia',4,NULL,'upah pegawai harian (02 juli)',9,9,'2025-07-02 13:23:11','2025-07-02 13:23:11'),(392284,'T25004620','2025-07-02',8,4,NULL,2000000,1,35081784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392284.jpg','pembayaran tk. aligra-cidahu (02 juli)',9,9,'2025-07-02 13:30:13','2025-07-02 13:30:15'),(392285,'T25004621','2025-07-02',8,4,NULL,1000000,1,36081784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392285.jpg','pembayaran tk. ko andi-ciapus mulyaharja (02 juli)',9,9,'2025-07-02 13:30:46','2025-07-02 13:30:48'),(392286,'T25004622','2025-07-02',8,4,NULL,500000,1,36581784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392286.jpg','pembayaran tk. merry-ps ciampea (02 juli)',9,9,'2025-07-02 13:31:29','2025-07-02 13:31:30'),(392287,'T25004623','2025-07-02',8,4,NULL,637500,1,37219284.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392287.jpg','pembayaran tk. pak jay safana pakan-sawangan (02 juli)',9,9,'2025-07-02 13:32:31','2025-07-02 13:32:32'),(392288,'T25004624','2025-07-02',8,4,NULL,277000,1,37496284.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392288.jpg','pembayaran tk. widya-ciremai ujung (02 juli)',9,9,'2025-07-02 13:56:31','2025-07-02 13:56:33'),(392289,'T25004625','2025-07-02',8,4,NULL,2045500,1,39541784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392289.jpg','pembayaran tk. gampang ingat permai-ruko sawangan (02 juli)',9,9,'2025-07-02 14:20:26','2025-07-02 14:20:28'),(392290,'T25004626','2025-07-02',63,39,NULL,61929500,1,65684527,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392290.jpg','setor tunai (02 juli)',9,9,'2025-07-02 14:32:45','2025-07-02 14:32:46'),(392291,'T25004627','2025-07-02',63,39,NULL,52915000,1,118599527,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392291.jpg','setor tunai (02 juli)',9,9,'2025-07-02 14:33:20','2025-07-02 14:33:20'),(392292,'T25004628','2025-07-02',8,4,NULL,600000,1,40141784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392292.jpg','pembayaran tk. akbar-cigombong (02 juli)',9,9,'2025-07-02 14:51:08','2025-07-02 14:51:10'),(392293,'T25004629','2025-07-02',8,4,NULL,1000000,1,41141784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392293.jpg','pembayaran tk. habibi-leweungkolot (02 juli)',9,9,'2025-07-02 15:07:08','2025-07-02 15:07:18'),(392294,'T25004630','2025-07-02',8,4,NULL,1925000,1,43066784.400002,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.392294.jpg','pembayaran tk. plastik bang bewok-kalisuren (02 juli)',9,9,'2025-07-02 15:34:04','2025-07-02 15:34:06');

--
-- Table structure for table `s_user`
--

CREATE TABLE `s_user` (
  `id` int(1) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL DEFAULT '',
  `jwt_key` text DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `mobile` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `level` tinyint(3) NOT NULL DEFAULT 1 COMMENT '1=admin,2=SPV,3=manager,4=Superadmin',
  `status` tinyint(1) unsigned DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `access_payroll` tinyint(3) NOT NULL DEFAULT 0,
  `access_cashbon` tinyint(3) NOT NULL DEFAULT 0,
  `access_asset` tinyint(3) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `s_user`
--

INSERT INTO `s_user` VALUES (1,'abdul.r4hman@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Abdul Rahman','081318227996','',4,1,'2018-01-26 13:39:56','2018-01-26 13:39:56',1,0,0),(2,'r4cheem@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Abdul Rahim','081320325846','',4,1,'2018-01-26 13:39:56','2018-01-26 13:39:56',1,0,0),(3,'srifitriah.jtk11@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Sri Fitriah','08996161700','',4,1,'2018-01-16 17:23:54','2018-01-16 17:23:54',1,0,0),(4,'sastra.afandi@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Setia Darmawan Afandi','','',4,1,'2018-01-16 17:23:54','2018-01-16 17:23:54',1,0,0),(5,'febby.jefany@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Febby Olivia Jefany','085271644554','',1,0,'2018-01-29 22:04:57','2018-01-29 22:04:57',0,0,0),(6,'vc.ganesha@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Staff Keuangan','081320325846','',2,1,'2018-07-14 11:02:54','2018-07-14 11:02:54',0,0,0),(7,'delfcode@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Superadmin','628','',4,1,'2021-07-30 09:27:33','2021-07-30 09:27:33',1,0,0),(8,'widi@agroka.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','widi','62','',2,1,'2022-02-05 02:24:24','2022-02-05 02:24:24',0,0,0),(9,'widia@agroka.com','$2y$12$fumGY5kai96.hlgKaQ8HbOoJny0fwWQ3RhWlnJmAPp1TzNDUoYFNa','','widia','62','',2,1,'2022-02-05 02:31:23','2024-07-04 10:36:56',0,0,0);

--
-- Table structure for table `s_user_account`
--

CREATE TABLE `s_user_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `transaction_account_id` int(11) NOT NULL DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `s_user_account`
--

INSERT INTO `s_user_account` VALUES (1,1,1,'2020-01-15 19:36:19',1),(2,1,3,'2020-01-15 19:36:19',1),(3,1,4,'2020-01-15 19:36:19',1),(4,1,2,'2020-01-15 19:36:19',1),(5,1,5,'2020-01-15 19:36:19',1),(11,2,1,'2020-01-15 19:47:01',2),(12,2,3,'2020-01-15 19:47:02',2),(13,2,4,'2020-01-15 19:47:02',2),(14,2,2,'2020-01-15 19:47:02',2),(15,2,5,'2020-01-15 19:47:02',2),(17,3,1,'2020-02-03 13:12:42',3),(18,3,3,'2020-02-03 13:12:42',3),(19,3,4,'2020-02-03 13:12:42',3),(20,3,2,'2020-02-03 13:12:42',3),(21,3,5,'2020-02-03 13:12:42',3),(30,6,3,'2022-02-05 02:26:38',4),(31,6,5,'2022-02-05 02:26:38',4),(32,6,7,'2022-02-05 02:26:38',4),(36,4,1,'2022-02-15 11:41:33',4),(37,4,2,'2022-02-15 11:41:33',4),(38,4,3,'2022-02-15 11:41:33',4),(39,4,5,'2022-02-15 11:41:33',4),(40,4,6,'2022-02-15 11:41:33',4),(41,4,7,'2022-02-15 11:41:33',4),(42,4,8,'2022-02-15 11:41:33',4),(43,9,3,'2022-02-15 11:41:45',4),(44,9,5,'2022-02-15 11:41:45',4),(45,9,7,'2022-02-15 11:41:45',4),(46,9,8,'2022-02-15 11:41:45',4),(385,9,63,'2024-07-11 13:51:25',4);


