-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `polmanka_datapelanggan`
--

-- --------------------------------------------------------

--
-- Table structure for table `datapelanggan`
--

CREATE TABLE `datapelanggan` (
  `id` int(11) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `nohp` varchar(13) NOT NULL,
  `jumlahtagihan` int(11) NOT NULL DEFAULT 150000,
  `ipaprouter` varchar(255) NOT NULL,
  `tglregistrasi` date NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `datapelanggan`
--

INSERT INTO `datapelanggan` (`id`, `nama`, `alamat`, `nohp`, `jumlahtagihan`, `ipaprouter`, `tglregistrasi`, `created_at`, `updated_at`) VALUES
(1, 'Nuar Fals', 'Samping Masjid Nurul Huda Takatidung', '08124148559', 150000, 'PPPOE 20.20.20.253', '2020-12-30', '2021-02-23 00:00:00', '2021-02-23 03:06:20'),
(2, 'Fitrah', 'Lorong Samping Masjid', '6285256362778', 150000, 'PPPOE 20.20.20.249', '2020-12-31', '2021-02-23 01:09:46', '2021-03-15 05:37:03'),
(3, 'Nur Aswad', 'Jln Andi Latanratu Dekat Masjid Nurulhuda Takatidung', '6282293371141', 150000, 'PPPOE 20.20.20.241', '2021-02-23', '2021-02-23 03:04:32', '2021-03-15 05:43:54'),
(4, 'Feby / Salim', 'Lorong Samping Masjid', '6282393825945', 150000, '192.168.30.6', '2020-11-04', '2021-02-23 03:05:26', '2021-03-15 05:34:05'),
(5, 'Andi Sari', 'Depan Masjid Nurulhuda Takatidung', '628124148559', 150000, '20.20.20.250', '2020-11-04', '2021-02-23 03:07:48', '2021-03-01 10:14:10'),
(6, 'Nurlina', 'Tanjung Dekat Kuburan', '6282352582051', 150000, '-', '2020-09-03', '2021-02-23 03:09:47', '2021-02-23 03:10:14'),
(7, 'Humaira', 'Tanjung Dekat Kuburan', '6282393592746', 150000, 'PPPOE 20.20.20.247', '2020-09-11', '2021-02-23 03:12:16', '2021-02-23 03:12:16'),
(8, 'Fahrezi', 'Eks TPI Takatidung', '6281342288823', 150000, '-', '2020-12-03', '2021-02-23 03:13:06', '2021-03-15 05:37:49'),
(9, 'Pratiwi / Salim', 'Mangeramba', '6281354723591', 150000, '-', '2020-12-10', '2021-02-23 03:14:07', '2021-02-23 03:14:07'),
(10, 'Aiman / Habib', 'Mangeramba', '6285242953854', 150000, 'PPPOE 20.20.20.248', '2020-08-12', '2021-02-23 03:15:44', '2021-02-23 03:20:36'),
(11, 'Halim', 'Mangeramba', '6285399233707', 150000, 'PPPOE 20.20.20.246', '2020-11-06', '2021-02-23 03:16:51', '2021-02-23 03:16:51'),
(12, 'Ayah Fathur / Ichal', 'Mangeramba', '6282344911048', 150000, 'PPPOE 20.20.20.251', '2020-11-12', '2021-02-23 03:18:26', '2021-02-23 03:18:26'),
(13, 'Golgo', 'Mangeramba Bara-Bara', '6285396926522', 150000, '-', '2020-10-08', '2021-02-23 03:22:16', '2021-03-15 05:35:31'),
(14, 'Gugun', 'Mangeramba', '628124148559', 150000, '-', '2021-01-01', '2021-02-23 03:24:24', '2021-02-23 03:24:24'),
(15, 'Cinta', 'Kamp. Pajala', '6282157522107', 150000, 'PPPOE 20.20.20.242', '2021-02-21', '2021-02-24 08:58:45', '2021-03-15 05:43:00'),
(16, 'Umar', 'Kandoa\'', '6282349713622', 150000, 'PPPOE 20.20.20.252', '2021-02-20', '2021-02-24 08:59:41', '2021-03-15 05:41:59'),
(17, 'Mira', 'Mangeramba', '6282192605107', 150000, '-', '2021-02-01', '2021-02-24 09:38:48', '2021-03-15 05:39:18'),
(18, 'Afni ', 'Tanjung', '6289671817587', 150000, '-', '2021-02-01', '2021-02-24 09:41:39', '2021-03-15 05:40:32'),
(19, 'Akhira', 'Tanjung', '6285394006485', 150000, '-', '2021-02-01', '2021-02-24 09:43:13', '2021-02-24 09:43:13'),
(20, 'ALMA', 'Mangeramba', '6285396921007', 150000, 'Huawei 192.168.50.211', '2021-03-09', '2021-03-09 10:27:37', '2021-03-15 05:45:54'),
(21, 'RAHMAN ', 'Mangeramba', '6282259467969', 150000, 'PPPOE ', '2021-03-09', '2021-03-09 10:28:45', '2021-03-15 05:47:28'),
(22, 'Aco Alma', 'Depan Lapangan Takatidung', '6281355799746', 150000, 'PPPOE acofadli', '2021-03-10', '2021-03-10 11:37:54', '2021-03-15 05:48:04'),
(23, 'Rapih', 'Depan mesjid nurul huda', '62', 150000, 'PPPOE ', '2021-03-17', '2021-03-22 09:34:32', '2021-03-22 09:34:32'),
(24, 'Selfi', 'Takatidung', '62', 150000, 'PPPOE ', '2021-03-19', '2021-03-22 09:36:55', '2021-03-22 09:36:55'),
(25, 'Ridu\'', 'Depan pabrik gabah', '62', 150000, 'PPPOE ', '2021-03-18', '2021-03-22 09:38:25', '2021-03-22 09:38:25'),
(26, 'Papa Kembar', 'Mangeramba', '62', 150000, '', '2021-04-01', '2021-04-13 09:14:03', '2021-04-13 09:14:03'),
(27, 'Nasma', 'Takatidung', '62', 150000, '', '2021-04-01', '2021-04-13 09:15:24', '2021-04-13 09:15:24'),
(28, 'Indah Kandoa', 'Kandoa', '62', 150000, '', '2021-04-13', '2021-04-13 09:15:58', '2021-04-13 09:15:58'),
(29, 'Nunu', 'Mangeramba', '62', 150000, 'PPPOE ', '2021-04-26', '2021-04-28 05:57:23', '2021-04-28 05:57:23'),
(30, 'ANHA', 'Tanjong', '6282195501267', 150000, 'Pppoe', '2021-05-08', '2021-05-09 01:48:52', '2021-05-09 01:48:52');

-- --------------------------------------------------------

--
-- Table structure for table `level`
--

CREATE TABLE `level` (
  `id` int(11) NOT NULL,
  `level` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `level`
--

INSERT INTO `level` (`id`, `level`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', '2021-02-17 00:00:00', '2021-02-18 09:32:12'),
(2, 'Admin', '2021-02-17 00:00:00', '2021-02-18 09:32:07'),
(3, 'Pengelola', '2021-02-17 00:00:00', '2021-02-18 09:32:10');

-- --------------------------------------------------------

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `id` int(11) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `status`) VALUES
(1, 'Belum Lunas'),
(2, 'Lunas');

-- --------------------------------------------------------

--
-- Table structure for table `tagihan`
--

CREATE TABLE `tagihan` (
  `id` int(11) NOT NULL,
  `pelanggan_id` int(11) NOT NULL,
  `jumlahtagihan` int(11) NOT NULL,
  `status_id` int(11) DEFAULT 2,
  `tanggalpenagihan` date NOT NULL,
  `keterangan` varchar(500) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tagihan`
--

INSERT INTO `tagihan` (`id`, `pelanggan_id`, `jumlahtagihan`, `status_id`, `tanggalpenagihan`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 1, 150000, 1, '2021-02-15', NULL, '2021-02-24 00:00:00', '2021-02-24 00:00:00'),
(2, 2, 150000, 1, '2021-02-15', NULL, '2021-02-24 00:00:00', '2021-02-24 00:00:00'),
(3, 10, 150000, 2, '2021-02-15', 'LUNAS', '2021-02-28 11:32:48', '2021-02-28 11:32:48'),
(4, 10, 150000, 2, '2021-01-15', '', '2021-02-28 11:52:03', '2021-02-28 11:52:03'),
(5, 10, 150000, 2, '2020-12-15', '', '2021-02-28 12:17:06', '2021-02-28 12:17:06'),
(6, 10, 150000, 2, '2020-11-15', '', '2021-02-28 12:19:10', '2021-02-28 12:19:10'),
(7, 10, 150000, 2, '2020-10-15', '', '2021-02-28 12:24:58', '2021-02-28 12:24:58'),
(8, 10, 150000, 2, '2020-09-15', '', '2021-02-28 12:25:31', '2021-02-28 12:25:31'),
(9, 6, 150000, 2, '2021-01-15', '', '2021-02-28 12:26:00', '2021-02-28 12:26:00'),
(10, 6, 150000, 2, '2021-02-15', '', '2021-02-28 12:26:13', '2021-02-28 12:26:13'),
(11, 19, 150000, 2, '2021-03-01', '', '2021-03-01 08:26:26', '2021-03-01 08:26:26'),
(12, 5, 150000, 2, '2021-01-15', '', '2021-03-01 10:12:39', '2021-03-01 10:12:39'),
(13, 4, 150000, 2, '2021-02-15', '', '2021-03-04 08:30:07', '2021-03-04 08:30:07'),
(14, 6, 150000, 2, '2021-03-07', '', '2021-03-08 06:49:37', '2021-03-08 06:49:37'),
(15, 7, 150000, 2, '2021-03-15', '', '2021-03-15 05:49:27', '2021-03-15 05:49:27'),
(16, 13, 150000, 2, '2021-03-15', '', '2021-03-15 05:50:15', '2021-03-15 05:50:15'),
(17, 4, 150000, 2, '2021-03-15', '', '2021-03-15 05:50:41', '2021-03-15 05:50:41'),
(18, 11, 150000, 2, '2021-03-15', '', '2021-03-15 05:51:10', '2021-03-15 05:51:10'),
(19, 8, 150000, 2, '2021-03-15', '', '2021-03-15 05:51:33', '2021-03-15 05:51:33'),
(20, 9, 150000, 2, '2021-03-15', '', '2021-03-15 05:51:52', '2021-03-15 05:51:52'),
(21, 2, 150000, 2, '2021-03-15', '', '2021-03-15 05:52:25', '2021-03-15 05:52:25'),
(22, 17, 150000, 2, '2021-03-15', '', '2021-03-15 05:52:55', '2021-03-15 05:52:55'),
(23, 18, 150000, 2, '2021-03-15', '', '2021-03-15 05:53:43', '2021-03-15 05:53:43'),
(24, 16, 150000, 2, '2021-03-15', '', '2021-03-15 05:54:16', '2021-03-15 05:54:16'),
(25, 15, 150000, 2, '2021-03-15', '', '2021-03-15 05:54:43', '2021-03-15 05:54:43'),
(26, 3, 150000, 2, '2021-03-15', '', '2021-03-15 05:55:05', '2021-03-15 05:55:05'),
(27, 10, 150000, 2, '2021-03-15', '', '2021-03-22 09:35:36', '2021-03-22 09:35:36'),
(28, 19, 150000, 2, '2021-04-01', '', '2021-03-31 11:11:26', '2021-03-31 11:11:26'),
(29, 6, 150000, 2, '2021-04-13', '', '2021-04-13 09:12:34', '2021-04-13 09:12:34'),
(30, 19, 150000, 2, '2021-05-15', '', '2021-05-12 11:51:10', '2021-05-12 11:51:10'),
(31, 6, 150000, 2, '2021-05-15', '', '2021-05-12 11:51:41', '2021-05-12 11:51:41'),
(32, 7, 150000, 2, '2021-04-15', '', '2021-05-12 10:40:07', '2021-05-12 10:40:07');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `datapelanggan`
--
ALTER TABLE `datapelanggan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `level`
--
ALTER TABLE `level`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `status`
--
ALTER TABLE `status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tagihan`
--
ALTER TABLE `tagihan`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `datapelanggan`
--
ALTER TABLE `datapelanggan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `level`
--
ALTER TABLE `level`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `status`
--
ALTER TABLE `status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tagihan`
--
ALTER TABLE `tagihan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
COMMIT;

