(6436,97421,88,125000,NULL,'2026-06-23 07:19:21',0,'Otomatis',NULL,1,'bayar'),(6437,97093,88,166500,NULL,'2026-06-23 08:00:38',1,'Input Manual',NULL,1,'bayar'),(6438,97389,88,150000,NULL,'2026-06-23 08:04:46',1,'Input Manual',NULL,1,'bayar'),(6439,100926,88,166500,NULL,'2026-06-23 10:32:41',1,'Input Manual',NULL,1,'bayar'),(6440,97174,88,166500,NULL,'2026-06-23 10:38:10',1,'Input Manual',NULL,1,'bayar'),(6441,97212,88,166500,NULL,'2026-06-23 10:38:35',1,'Input Manual',NULL,1,'bayar'),(6442,97081,88,166500,NULL,'2026-06-23 16:17:48',1,'Input Manual',NULL,1,'bayar'),(6443,97107,88,166500,NULL,'2026-06-24 03:25:42',1,'Input Manual',NULL,1,'bayar'),(6444,97218,88,166500,NULL,'2026-06-24 03:28:59',1,'Input Manual',NULL,1,'bayar'),(6445,97214,88,125000,NULL,'2026-06-24 06:30:03',1,'Input Manual',NULL,1,'bayar'),(6446,97285,88,125000,NULL,'2026-06-25 02:42:19',1,'Input Manual',NULL,1,'bayar'),(6447,97213,88,125000,NULL,'2026-06-25 02:43:38',0,'Input Manual',NULL,1,'bayar'),(6448,97094,88,166500,NULL,'2026-06-25 05:13:43',1,'Input Manual',NULL,1,'bayar'),(6449,97234,88,166500,NULL,'2026-06-25 05:53:10',1,'Input Manual',NULL,1,'bayar'),(6450,97275,88,188000,NULL,'2026-06-25 05:55:05',1,'Input Manual',NULL,1,'bayar'),(6451,97079,88,166500,NULL,'2026-06-25 05:56:50',1,'Input Manual',NULL,1,'bayar'),(6452,97104,88,222000,NULL,'2026-06-25 05:58:50',1,'Input Manual',NULL,1,'bayar'),(6453,97120,88,125000,NULL,'2026-06-25 05:59:53',1,'Input Manual',NULL,1,'bayar'),(6454,97124,88,166500,NULL,'2026-06-25 06:01:16',1,'Input Manual',NULL,1,'bayar'),(6455,97147,88,166500,NULL,'2026-06-25 06:03:39',1,'Input Manual',NULL,1,'bayar'),(6456,97223,88,222000,NULL,'2026-06-25 06:04:39',1,'Input Manual',NULL,1,'bayar'),(6457,97091,88,166500,NULL,'2026-06-25 06:06:03',1,'Input Manual',NULL,1,'bayar'),(6458,97173,88,125000,NULL,'2026-06-25 06:08:18',1,'Input Manual',NULL,1,'bayar'),(6459,97099,88,166500,NULL,'2026-06-25 06:09:48',1,'Input Manual',NULL,1,'bayar'),(6460,97308,88,150000,NULL,'2026-06-25 06:11:03',1,'Input Manual',NULL,1,'bayar'),(6461,97260,88,166500,NULL,'2026-06-25 06:12:05',1,'Input Manual',NULL,1,'bayar'),(6462,93578,88,275000,NULL,'2026-06-25 10:07:00',0,'Input Manual',NULL,1,'bayar'),(6463,92932,88,166500,NULL,'2026-06-25 10:07:37',0,'Input Manual',NULL,1,'bayar'),(6465,97933,102,125000,NULL,'2026-06-25 13:17:44',1,'Input Manual',NULL,1,'bayar'),(6466,97346,88,222000,NULL,'2026-06-25 13:48:09',1,'Input Manual',NULL,1,'bayar'),(6467,97149,88,166500,NULL,'2026-06-26 02:00:14',1,'Input Manual',NULL,1,'bayar'),(6468,97380,88,125000,NULL,'2026-06-26 02:01:59',1,'Input Manual',NULL,1,'bayar'),(6469,97357,88,275000,NULL,'2026-06-26 16:42:56',0,'Input Manual',NULL,1,'bayar'),(6470,97292,88,166500,NULL,'2026-06-27 05:35:43',1,'Input Manual',NULL,1,'bayar'),(6471,97186,88,125000,NULL,'2026-06-27 05:38:41',1,'Input Manual',NULL,1,'bayar'),(6472,97171,88,125000,NULL,'2026-06-27 05:42:11',1,'Input Manual',NULL,1,'bayar'),(6473,97199,88,166500,NULL,'2026-06-27 05:44:08',1,'Input Manual',NULL,1,'bayar'),(6474,97103,88,222000,NULL,'2026-06-27 05:49:08',1,'Input Manual',NULL,1,'bayar'),(6475,97156,88,125000,NULL,'2026-06-27 05:50:28',1,'Input Manual',NULL,1,'bayar'),(6476,97134,88,125000,NULL,'2026-06-27 05:51:21',1,'Input Manual',NULL,1,'bayar'),(6477,97101,88,166500,NULL,'2026-06-27 05:57:02',1,'Input Manual',NULL,1,'bayar'),(6478,97075,88,222000,NULL,'2026-06-27 05:57:38',1,'Input Manual',NULL,1,'bayar'),(6479,97182,88,166500,NULL,'2026-06-27 05:58:00',1,'Input Manual',NULL,1,'bayar'),(6480,97203,88,166500,NULL,'2026-06-27 05:59:06',1,'Input Manual',NULL,1,'bayar'),(6481,97343,88,166500,NULL,'2026-06-27 06:00:14',1,'Input Manual',NULL,1,'bayar'),(6482,97414,88,200000,NULL,'2026-06-27 06:01:58',1,'Input Manual',NULL,1,'bayar'),(6483,97137,88,166500,NULL,'2026-06-27 06:05:51',1,'Input Manual',NULL,1,'bayar'),(6484,97133,88,166500,NULL,'2026-06-27 06:15:34',1,'Input Manual',NULL,1,'bayar'),(6485,97153,88,166500,NULL,'2026-06-27 06:16:50',1,'Input Manual',NULL,1,'bayar'),(6486,97305,88,166500,NULL,'2026-06-27 06:19:11',1,'Input Manual',NULL,1,'bayar'),(6487,97146,88,166500,NULL,'2026-06-27 06:20:12',1,'Input Manual',NULL,1,'bayar'),(6488,97129,88,188000,NULL,'2026-06-27 06:22:06',1,'Input Manual',NULL,1,'bayar'),(6489,97360,88,125000,NULL,'2026-06-27 09:40:01',0,'Input Manual',NULL,1,'bayar'),(6490,97130,88,125000,NULL,'2026-06-27 09:40:31',1,'Input Manual',NULL,1,'bayar'),(6491,97944,102,100000,NULL,'2026-06-27 17:12:09',1,'Input Manual',NULL,1,'bayar'),(6492,97939,102,125000,NULL,'2026-06-27 17:12:12',1,'Input Manual',NULL,1,'bayar'),(6493,97926,102,130000,NULL,'2026-06-27 17:12:14',1,'Input Manual',NULL,1,'bayar'),(6494,97906,102,130000,NULL,'2026-06-27 17:12:17',1,'Input Manual',NULL,1,'bayar'),(6495,97294,88,166500,NULL,'2026-06-28 03:55:27',1,'Input Manual',NULL,1,'bayar'),(6496,97408,88,166500,NULL,'2026-06-28 03:57:09',1,'Input Manual',NULL,1,'bayar'),(6497,100931,126,150000,NULL,'2026-06-28 06:25:23',0,'Input Manual',NULL,1,'bayar'),(6498,97396,88,125000,NULL,'2026-06-28 10:14:39',1,'Input Manual',NULL,1,'bayar'),(6499,97115,88,166500,NULL,'2026-06-28 11:17:47',1,'Input Manual',NULL,1,'bayar'),(6500,100932,102,160000,NULL,'2026-06-29 03:37:01',1,'Input Manual',NULL,1,'bayar'),(6501,97336,88,166500,NULL,'2026-06-29 05:46:13',1,'Input Manual',NULL,1,'bayar'),(6502,99063,151,150000,NULL,'2026-06-29 07:24:31',0,'Input Manual',NULL,1,'bayar'),(6503,100936,102,166500,NULL,'2026-06-29 08:11:13',1,'Input Manual',NULL,1,'bayar'),(6504,97128,88,166500,NULL,'2026-06-29 10:22:59',1,'Input Manual',NULL,1,'bayar'),(6505,97290,88,166500,NULL,'2026-06-29 12:17:07',1,'Input Manual',NULL,1,'bayar'),(6506,97390,88,200000,NULL,'2026-06-29 12:26:45',1,'Input Manual',NULL,1,'bayar'),(6507,97387,88,188000,NULL,'2026-06-29 12:29:18',1,'Input Manual',NULL,1,'bayar'),(6508,97098,88,166500,NULL,'2026-06-29 12:30:28',1,'Input Manual',NULL,1,'bayar'),(6509,97108,88,166500,NULL,'2026-06-29 12:33:18',1,'Input Manual',NULL,1,'bayar'),(6510,97413,88,200000,NULL,'2026-06-29 12:34:24',1,'Input Manual',NULL,1,'bayar'),(6511,97183,88,166500,NULL,'2026-06-29 12:35:40',1,'Input Manual',NULL,1,'bayar'),(6512,97411,88,166500,NULL,'2026-06-29 12:36:58',0,'Input Manual',NULL,1,'bayar'),(6513,97231,88,125000,NULL,'2026-06-29 12:38:33',1,'Input Manual',NULL,1,'bayar'),(6514,97288,88,166500,NULL,'2026-06-29 12:41:09',1,'Input Manual',NULL,1,'bayar'),(6515,97185,88,166500,NULL,'2026-06-29 15:36:17',1,'Input Manual',NULL,1,'bayar'),(6516,98948,126,150000,NULL,'2026-06-29 16:17:53',0,'Input Manual',NULL,1,'bayar'),(6517,96293,126,150000,NULL,'2026-06-29 16:18:15',0,'Input Manual',NULL,1,'bayar'),(6518,98953,126,150000,NULL,'2026-06-29 16:18:23',0,'Input Manual',NULL,1,'bayar'),(6519,99015,126,150000,NULL,'2026-06-29 16:19:02',0,'Input Manual',NULL,1,'bayar'),(6520,99014,126,150000,NULL,'2026-06-29 16:19:37',0,'Input Manual',NULL,1,'bayar'),(6521,99013,126,150000,NULL,'2026-06-29 16:20:03',0,'Input Manual',NULL,1,'bayar'),(6522,99010,126,347000,NULL,'2026-06-29 16:20:33',0,'Input Manual',NULL,1,'bayar'),(6524,93843,126,150000,NULL,'2026-06-29 16:21:16',0,'Input Manual',NULL,1,'bayar'),(6525,96363,126,300000,NULL,'2026-06-29 16:21:31',0,'Input Manual',NULL,1,'bayar'),(6526,100938,126,150000,NULL,'2026-06-29 16:21:47',0,'Input Manual',NULL,1,'bayar'),(6527,97125,88,166500,NULL,'2026-06-30 00:09:32',1,'Input Manual',NULL,1,'bayar'),(6528,97358,88,166500,NULL,'2026-06-30 03:58:15',1,'Input Manual',NULL,1,'bayar'),(6529,97333,88,166500,NULL,'2026-06-30 05:38:30',1,'Input Manual',NULL,1,'bayar'),(6530,97286,88,166500,NULL,'2026-06-30 09:28:46',0,'Input Manual',NULL,1,'bayar'),(6531,97215,88,125000,NULL,'2026-06-30 10:00:19',1,'Input Manual',NULL,1,'bayar'),(6532,97184,88,166500,NULL,'2026-06-30 10:02:52',1,'Input Manual',NULL,1,'bayar'),(6533,93942,88,166500,NULL,'2026-06-30 10:09:26',1,'Input Manual',NULL,1,'bayar'),(6534,97258,88,166500,NULL,'2026-06-30 10:17:58',0,'Input Manual',NULL,1,'bayar'),(6535,97078,88,166500,NULL,'2026-06-30 10:18:20',1,'Input Manual',NULL,1,'bayar'),(6536,97945,102,200000,NULL,'2026-06-30 11:25:29',1,'Input Manual',NULL,1,'bayar'),(6537,97909,102,166500,NULL,'2026-06-30 11:26:26',1,'Input Manual',NULL,1,'bayar'),(6538,97159,88,222000,NULL,'2026-06-30 12:01:44',1,'Input Manual',NULL,1,'bayar'),(6539,97189,88,166500,NULL,'2026-06-30 12:56:52',1,'Input Manual',NULL,1,'bayar'),(6540,100939,102,100000,NULL,'2026-06-30 13:28:22',NULL,'Input Manual',NULL,1,'bayar'),(6541,97382,88,166500,NULL,'2026-06-30 16:03:56',1,'Input Manual',NULL,1,'bayar'),(6542,97256,88,222000,NULL,'2026-06-30 16:05:21',1,'Input Manual',NULL,1,'bayar'),(6543,97084,88,166500,NULL,'2026-06-30 16:06:32',1,'Input Manual',NULL,1,'bayar'),(6544,97353,88,166500,NULL,'2026-06-30 16:08:03',1,'Input Manual',NULL,1,'bayar'),(6545,97229,88,166500,NULL,'2026-06-30 16:08:51',1,'Input Manual',NULL,1,'bayar'),(6546,97163,88,166500,NULL,'2026-06-30 16:10:34',1,'Input Manual',NULL,1,'bayar'),(6547,97195,88,125000,NULL,'2026-06-30 16:13:16',1,'Input Manual',NULL,1,'bayar'),(6548,97364,88,125000,NULL,'2026-06-30 16:30:42',0,'Input Manual',NULL,1,'bayar'),(6549,97127,88,166500,NULL,'2026-06-30 16:58:50',1,'Input Manual',NULL,1,'bayar'),(6550,101422,NULL,0,NULL,'2026-06-30 23:04:49',NULL,'Saldo',NULL,1,'bayar'),(6551,101463,NULL,0,NULL,'2026-06-30 23:04:50',NULL,'Saldo',NULL,1,'bayar'),(6552,101464,NULL,0,NULL,'2026-06-30 23:04:50',NULL,'Saldo',NULL,1,'bayar'),(6553,101473,NULL,0,NULL,'2026-06-30 23:04:50',NULL,'Saldo',NULL,1,'bayar'),(6554,101492,NULL,0,NULL,'2026-06-30 23:04:50',NULL,'Saldo',NULL,1,'bayar'),(6555,101499,NULL,0,NULL,'2026-06-30 23:04:50',NULL,'Saldo',NULL,1,'bayar'),(6556,101502,NULL,0,NULL,'2026-06-30 23:04:50',NULL,'Saldo',NULL,1,'bayar'),(6557,101513,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6558,101529,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6559,101538,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6560,101551,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6561,101552,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6562,101559,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6563,101571,NULL,0,NULL,'2026-06-30 23:04:51',NULL,'Saldo',NULL,1,'bayar'),(6564,101600,NULL,0,NULL,'2026-06-30 23:04:52',NULL,'Saldo',NULL,1,'bayar'),(6565,101618,NULL,166500,NULL,'2026-06-30 23:04:52',NULL,'Saldo',NULL,1,'bayar'),(6566,101625,NULL,0,NULL,'2026-06-30 23:04:52',NULL,'Saldo',NULL,1,'bayar'),(6567,101630,NULL,0,NULL,'2026-06-30 23:04:52',NULL,'Saldo',NULL,1,'bayar'),(6568,101634,NULL,0,NULL,'2026-06-30 23:04:52',NULL,'Saldo',NULL,1,'bayar'),(6569,101683,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6570,101694,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6571,101695,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6572,101697,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6573,101698,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6574,101699,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6575,101700,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6576,101701,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6577,101702,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6578,101703,NULL,0,NULL,'2026-06-30 23:04:53',NULL,'Saldo',NULL,1,'bayar'),(6579,101705,NULL,0,NULL,'2026-06-30 23:04:54',NULL,'Saldo',NULL,1,'bayar'),(6580,101706,NULL,0,NULL,'2026-06-30 23:04:54',NULL,'Saldo',NULL,1,'bayar'),(6581,101709,NULL,0,NULL,'2026-06-30 23:04:54',NULL,'Saldo',NULL,1,'bayar'),(6582,101711,NULL,0,NULL,'2026-06-30 23:04:54',NULL,'Saldo',NULL,1,'bayar'),(6583,101712,NULL,0,NULL,'2026-06-30 23:04:54',NULL,'Saldo',NULL,1,'bayar'),(6584,101747,NULL,0,NULL,'2026-06-30 23:04:54',NULL,'Saldo',NULL,1,'bayar'),(6585,101779,NULL,0,NULL,'2026-06-30 23:04:55',NULL,'Saldo',NULL,1,'bayar'),(6586,101783,NULL,0,NULL,'2026-06-30 23:04:55',NULL,'Saldo',NULL,1,'bayar'),(6587,101789,NULL,0,NULL,'2026-06-30 23:04:55',NULL,'Saldo',NULL,1,'bayar'),(6588,101794,NULL,0,NULL,'2026-06-30 23:04:55',NULL,'Saldo',NULL,1,'bayar'),(6589,102161,NULL,0,NULL,'2026-06-30 23:05:00',NULL,'Saldo',NULL,1,'bayar'),(6590,102175,NULL,0,NULL,'2026-06-30 23:05:00',NULL,'Saldo',NULL,1,'bayar'),(6591,102200,NULL,0,NULL,'2026-06-30 23:05:01',NULL,'Saldo',NULL,1,'bayar'),(6592,102225,NULL,0,NULL,'2026-06-30 23:05:01',NULL,'Saldo',NULL,1,'bayar'),(6593,102712,NULL,0,NULL,'2026-06-30 23:05:08',NULL,'Saldo',NULL,1,'bayar'),(6594,102719,NULL,0,NULL,'2026-06-30 23:05:08',NULL,'Saldo',NULL,1,'bayar'),(6595,102724,NULL,0,NULL,'2026-06-30 23:05:08',NULL,'Saldo',NULL,1,'bayar'),(6596,102726,NULL,0,NULL,'2026-06-30 23:05:08',NULL,'Saldo',NULL,1,'bayar'),(6597,102762,NULL,0,NULL,'2026-06-30 23:05:09',NULL,'Saldo',NULL,1,'bayar'),(6598,102763,NULL,0,NULL,'2026-06-30 23:05:09',NULL,'Saldo',NULL,1,'bayar'),(6599,103784,NULL,0,NULL,'2026-06-30 23:05:24',NULL,'Saldo',NULL,1,'bayar'),(6600,103796,NULL,0,NULL,'2026-06-30 23:05:25',NULL,'Saldo',NULL,1,'bayar'),(6601,103823,NULL,0,NULL,'2026-06-30 23:05:25',NULL,'Saldo',NULL,1,'bayar'),(6602,103837,NULL,0,NULL,'2026-06-30 23:05:25',NULL,'Saldo',NULL,1,'bayar'),(6603,103920,NULL,0,NULL,'2026-06-30 23:05:27',NULL,'Saldo',NULL,1,'bayar'),(6604,103929,NULL,0,NULL,'2026-06-30 23:05:27',NULL,'Saldo',NULL,1,'bayar'),(6605,103949,NULL,0,NULL,'2026-06-30 23:05:27',NULL,'Saldo',NULL,1,'bayar'),(6606,103950,NULL,0,NULL,'2026-06-30 23:05:27',NULL,'Saldo',NULL,1,'bayar'),(6607,101615,88,125000,NULL,'2026-07-01 04:29:01',0,'Otomatis',NULL,1,'bayar'),(6608,102793,102,100000,NULL,'2026-07-01 05:33:15',0,'Input Manual',NULL,1,'bayar'),(6609,102722,102,130000,NULL,'2026-07-01 05:33:16',0,'Input Manual',NULL,1,'bayar'),(6610,97239,88,125000,NULL,'2026-07-01 05:54:58',0,'Input Manual',NULL,1,'bayar'),(6611,97340,88,125000,NULL,'2026-07-01 05:55:17',0,'Input Manual',NULL,1,'bayar'),(6612,99070,151,166498,NULL,'2026-07-01 06:04:56',0,'Input Manual',NULL,1,'bayar'),(6613,99066,151,166498,NULL,'2026-07-01 06:07:17',1,'Input Manual',NULL,1,'bayar'),(6614,99069,151,99999,NULL,'2026-07-01 06:07:37',1,'Input Manual',NULL,1,'bayar'),(6615,103930,151,129999,NULL,'2026-07-01 06:19:50',1,'Input Manual',NULL,1,'bayar'),(6616,103927,151,166498,NULL,'2026-07-01 06:23:23',1,'Input Manual',NULL,1,'bayar'),(6617,97095,88,166500,NULL,'2026-07-01 07:07:16',0,'Input Manual',NULL,1,'bayar'),(6618,97113,88,125000,NULL,'2026-07-01 09:26:54',0,'Input Manual',NULL,1,'bayar'),(6619,102770,102,166500,NULL,'2026-07-01 09:27:26',0,'Input Manual',NULL,1,'bayar'),(6620,97106,88,166500,NULL,'2026-07-01 10:35:24',0,'Input Manual',NULL,1,'bayar'),(6621,104025,88,125000,NULL,'2026-07-01 10:52:51',0,'Input Manual',NULL,1,'bayar'),(6622,97205,88,166500,NULL,'2026-07-01 12:00:59',0,'Input Manual',NULL,1,'bayar'),(6623,103925,151,166498,NULL,'2026-07-01 12:15:55',1,'Input Manual',NULL,1,'bayar'),(6624,97329,88,166500,NULL,'2026-07-01 12:28:11',0,'Input Manual',NULL,1,'bayar'),(6625,103932,151,188000,NULL,'2026-07-01 14:00:17',1,'Input Manual',NULL,1,'bayar'),(6626,102767,102,150000,NULL,'2026-07-02 05:28:38',0,'Input Manual',NULL,1,'bayar'),(6627,103974,151,199000,NULL,'2026-07-02 05:30:21',1,'Input Manual',NULL,1,'bayar'),(6628,103919,151,188000,NULL,'2026-07-02 05:31:22',1,'Input Manual',NULL,1,'bayar'),(6629,99019,151,166498,NULL,'2026-07-02 05:32:53',1,'Input Manual',NULL,1,'bayar'),(6630,99029,151,166498,NULL,'2026-07-02 05:33:16',1,'Input Manual',NULL,1,'bayar'),(6631,102734,102,180000,NULL,'2026-07-02 06:28:37',1,'Input Manual',NULL,1,'bayar'),(6632,104028,126,150000,NULL,'2026-07-02 12:50:34',0,'Input Manual',NULL,1,'bayar'),(6633,97158,88,125000,NULL,'2026-07-02 13:46:28',1,'Input Manual',NULL,1,'bayar'),(6634,97297,88,166500,NULL,'2026-07-03 01:34:55',1,'Input Manual',NULL,1,'bayar'),(6635,97402,88,166500,NULL,'2026-07-03 01:48:46',1,'Input Manual',NULL,1,'bayar'),(6636,97086,88,166500,NULL,'2026-07-03 01:50:29',1,'Input Manual',NULL,1,'bayar'),(6637,97252,88,166500,NULL,'2026-07-03 01:52:10',1,'Input Manual',NULL,1,'bayar'),(6638,97356,88,188000,NULL,'2026-07-03 01:55:34',1,'Input Manual',NULL,1,'bayar'),(6639,97299,88,166500,NULL,'2026-07-03 01:57:38',1,'Input Manual',NULL,1,'bayar'),(6640,97177,88,130000,NULL,'2026-07-03 01:59:20',1,'Input Manual',NULL,1,'bayar'),(6641,97143,88,166500,NULL,'2026-07-03 02:03:13',1,'Input Manual',NULL,1,'bayar'),(6642,97254,88,188000,NULL,'2026-07-03 02:04:54',1,'Input Manual',NULL,1,'bayar'),(6643,97100,88,166500,NULL,'2026-07-03 02:09:39',1,'Input Manual',NULL,1,'bayar'),(6644,97400,88,188000,NULL,'2026-07-03 02:12:55',1,'Input Manual',NULL,1,'bayar'),(6645,97111,88,125000,NULL,'2026-07-03 02:15:26',1,'Input Manual',NULL,1,'bayar'),(6646,97157,88,125000,NULL,'2026-07-03 02:19:25',1,'Input Manual',NULL,1,'bayar'),(6647,97303,88,125000,NULL,'2026-07-03 02:21:55',1,'Input Manual',NULL,1,'bayar'),(6648,97259,88,166500,NULL,'2026-07-03 02:23:57',1,'Input Manual',NULL,1,'bayar'),(6649,97131,88,166500,NULL,'2026-07-03 02:24:48',1,'Input Manual',NULL,1,'bayar'),(6650,97142,88,125000,NULL,'2026-07-03 02:26:04',1,'Input Manual',NULL,1,'bayar'),(6651,97222,88,166500,NULL,'2026-07-03 02:27:28',1,'Input Manual',NULL,1,'bayar'),(6652,97337,88,166500,NULL,'2026-07-03 05:40:54',0,'Input Manual',NULL,1,'bayar'),(6653,103941,151,188000,NULL,'2026-07-03 06:33:37',1,'Input Manual',NULL,1,'bayar'),(6654,103961,151,199000,NULL,'2026-07-03 06:34:00',1,'Input Manual',NULL,1,'bayar'),(6655,103931,151,166498,NULL,'2026-07-03 08:09:05',1,'Input Manual',NULL,1,'bayar'),(6656,102746,102,188000,NULL,'2026-07-03 09:54:55',1,'Input Manual',NULL,1,'bayar'),(6657,97307,88,125000,NULL,'2026-07-03 10:34:49',0,'Input Manual',NULL,1,'bayar'),(6658,97227,88,125000,NULL,'2026-07-03 10:35:17',1,'Input Manual',NULL,1,'bayar'),(6659,97263,88,125000,NULL,'2026-07-03 10:35:46',1,'Input Manual',NULL,1,'bayar'),(6660,97225,88,125000,NULL,'2026-07-03 10:36:07',0,'Input Manual',NULL,1,'bayar'),(6661,97287,88,150000,NULL,'2026-07-03 11:52:07',1,'Input Manual',NULL,1,'bayar'),(6662,102116,96,120000,NULL,'2026-07-03 12:48:26',0,'Input Manual',NULL,1,'bayar'),(6663,102114,96,120000,NULL,'2026-07-03 12:57:00',0,'Input Manual',NULL,1,'bayar'),(6664,101813,96,100000,NULL,'2026-07-03 12:58:05',0,'Input Manual',NULL,1,'bayar'),(6665,97283,88,166500,NULL,'2026-07-03 13:24:45',1,'Input Manual',NULL,1,'bayar'),(6666,102038,96,220000,NULL,'2026-07-03 13:27:12',0,'Input Manual',143,0,'bayar'),(6667,101883,96,240000,NULL,'2026-07-03 13:42:11',0,'Input Manual',143,0,'bayar'),(6668,101750,88,250000,NULL,'2026-07-04 01:39:24',0,'Input Manual',NULL,1,'bayar'),(6669,101750,88,250000,NULL,'2026-07-04 01:39:28',0,'Input Manual',NULL,1,'bayar'),(6670,101759,88,125000,NULL,'2026-07-04 03:45:08',1,'Input Manual',NULL,1,'bayar'),(6671,97164,88,166500,NULL,'2026-07-04 05:59:45',1,'Input Manual',NULL,1,'bayar'),(6672,103964,151,150000,NULL,'2026-07-04 06:06:38',1,'Input Manual',NULL,1,'bayar'),(6673,102787,102,166500,NULL,'2026-07-04 06:07:10',1,'Input Manual',NULL,1,'bayar'),(6674,103955,151,150000,NULL,'2026-07-04 06:07:34',1,'Input Manual',NULL,1,'bayar'),(6675,102787,102,166500,NULL,'2026-07-04 06:07:44',0,'Input Manual',NULL,1,'bayar'),(6676,102757,102,160000,NULL,'2026-07-04 06:07:52',1,'Input Manual',NULL,1,'bayar'),(6677,102713,102,130000,NULL,'2026-07-04 06:08:09',1,'Input Manual',NULL,1,'bayar'),(6678,103934,151,200000,NULL,'2026-07-04 06:08:35',1,'Input Manual',NULL,1,'bayar'),(6679,103966,151,188000,NULL,'2026-07-04 06:09:41',1,'Input Manual',NULL,1,'bayar'),(6680,97077,88,166500,NULL,'2026-07-04 10:19:31',1,'Input Manual',NULL,1,'bayar'),(6681,97392,88,125000,NULL,'2026-07-04 10:20:47',1,'Input Manual',NULL,1,'bayar'),(6682,97217,88,125000,NULL,'2026-07-04 10:21:28',0,'Input Manual',NULL,1,'bayar'),(6683,97209,88,125000,NULL,'2026-07-04 10:22:13',1,'Input Manual',NULL,1,'bayar'),(6684,97255,88,166500,NULL,'2026-07-04 10:22:47',1,'Input Manual',NULL,1,'bayar'),(6685,97341,88,166500,NULL,'2026-07-04 10:24:23',1,'Input Manual',NULL,1,'bayar'),(6686,100915,88,166500,NULL,'2026-07-04 10:25:26',1,'Input Manual',NULL,1,'bayar'),(6687,97270,88,166500,NULL,'2026-07-04 10:25:47',1,'Input Manual',NULL,1,'bayar'),(6688,97155,88,125000,NULL,'2026-07-04 10:52:31',1,'Input Manual',NULL,1,'bayar'),(6689,102748,102,130000,NULL,'2026-07-04 12:31:32',1,'Input Manual',NULL,1,'bayar'),(6690,97090,88,166500,NULL,'2026-07-04 12:41:52',1,'Input Manual',NULL,1,'bayar'),(6691,97243,88,188000,NULL,'2026-07-04 13:00:24',1,'Input Manual',NULL,1,'bayar'),(6692,97334,88,165499,NULL,'2026-07-04 13:54:42',1,'Input Manual',NULL,1,'bayar'),(6693,103928,151,166498,NULL,'2026-07-04 15:58:52',1,'Input Manual',NULL,1,'bayar'),(6694,101810,96,150000,NULL,'2026-07-05 01:29:15',0,'Input Manual',NULL,1,'bayar'),(6695,101808,96,200000,NULL,'2026-07-05 01:29:48',0,'Input Manual',NULL,1,'bayar'),(6696,101819,96,100000,NULL,'2026-07-05 01:30:07',0,'Input Manual',NULL,1,'bayar'),(6697,101845,96,120000,NULL,'2026-07-05 01:30:34',0,'Input Manual',NULL,1,'bayar'),(6698,97175,88,125000,NULL,'2026-07-05 04:42:16',1,'Input Manual',NULL,1,'bayar'),(6699,97176,88,125000,NULL,'2026-07-05 04:43:35',1,'Input Manual',NULL,1,'bayar'),(6700,97330,88,125000,NULL,'2026-07-05 04:44:00',0,'Input Manual',NULL,1,'bayar'),(6701,97168,88,166500,NULL,'2026-07-05 04:44:37',1,'Input Manual',NULL,1,'bayar'),(6702,97138,88,125000,NULL,'2026-07-05 04:45:26',1,'Input Manual',NULL,1,'bayar'),(6703,97192,88,166500,NULL,'2026-07-05 05:06:47',1,'Input Manual',NULL,1,'bayar'),(6704,97187,88,166500,NULL,'2026-07-05 05:07:16',1,'Input Manual',NULL,1,'bayar'),(6705,97154,88,166500,NULL,'2026-07-05 05:09:14',1,'Input Manual',NULL,1,'bayar'),(6706,101530,88,550000,NULL,'2026-07-05 05:11:16',0,'Input Manual',NULL,1,'bayar'),(6707,101525,88,365499,NULL,'2026-07-05 05:11:35',1,'Input Manual',NULL,1,'bayar'),(6708,97145,88,166500,NULL,'2026-07-05 05:12:39',1,'Input Manual',NULL,1,'bayar'),(6709,97296,88,166500,NULL,'2026-07-05 05:15:02',1,'Input Manual',NULL,1,'bayar'),(6710,97295,88,166500,NULL,'2026-07-05 05:15:28',0,'Input Manual',NULL,1,'bayar'),(6711,97398,88,125000,NULL,'2026-07-05 05:16:07',1,'Input Manual',NULL,1,'bayar'),(6712,97087,88,166500,NULL,'2026-07-05 06:50:59',1,'Input Manual',NULL,1,'bayar'),(6713,97092,88,166500,NULL,'2026-07-05 06:57:26',1,'Input Manual',NULL,1,'bayar'),(6714,97284,88,166500,NULL,'2026-07-05 09:35:27',0,'Input Manual',NULL,1,'bayar'),(6715,97230,88,166500,NULL,'2026-07-05 10:51:51',0,'Input Manual',NULL,1,'bayar'),(6716,101596,88,166500,NULL,'2026-07-05 10:53:39',1,'Input Manual',NULL,1,'bayar'),(6717,97407,88,166500,NULL,'2026-07-05 10:54:38',1,'Input Manual',NULL,1,'bayar'),(6718,97374,88,125000,NULL,'2026-07-05 11:35:13',1,'Input Manual',NULL,1,'bayar'),(6719,97391,88,166500,NULL,'2026-07-05 11:35:32',0,'Input Manual',NULL,1,'bayar'),(6720,97368,88,125000,NULL,'2026-07-05 11:35:57',1,'Input Manual',NULL,1,'bayar'),(6721,97395,88,125000,NULL,'2026-07-05 11:36:33',1,'Input Manual',NULL,1,'bayar'),(6722,97403,88,166500,NULL,'2026-07-05 14:56:22',1,'Input Manual',NULL,1,'bayar'),(6723,97247,88,166500,NULL,'2026-07-05 14:59:09',1,'Input Manual',NULL,1,'bayar'),(6724,97208,88,166500,NULL,'2026-07-06 01:59:48',1,'Input Manual',NULL,1,'bayar'),(6725,101800,88,125000,NULL,'2026-07-06 04:31:09',1,'Input Manual',NULL,1,'bayar'),(6726,97279,88,125000,NULL,'2026-07-06 05:48:31',0,'Input Manual',NULL,1,'bayar'),(6727,101669,88,166500,NULL,'2026-07-06 06:46:11',0,'Input Manual',NULL,1,'bayar'),(6728,97893,102,130000,NULL,'2026-07-06 07:12:14',0,'Input Manual',NULL,1,'bayar'),(6729,97418,88,166500,NULL,'2026-07-06 09:27:09',0,'Input Manual',NULL,1,'bayar'),(6730,97377,88,150000,NULL,'2026-07-06 09:28:17',1,'Input Manual',NULL,1,'bayar'),(6731,103951,151,150000,NULL,'2026-07-06 10:07:45',1,'Input Manual',NULL,1,'bayar'),(6732,97335,88,166500,NULL,'2026-07-06 12:37:04',1,'Input Manual',NULL,1,'bayar'),(6733,102794,102,130000,NULL,'2026-07-06 12:39:54',1,'Input Manual',NULL,1,'bayar'),(6734,97361,88,166500,NULL,'2026-07-06 12:43:15',0,'Input Manual',NULL,1,'bayar'),(6735,97339,88,166500,NULL,'2026-07-06 13:19:14',1,'Input Manual',NULL,1,'bayar'),(6736,103923,151,150000,NULL,'2026-07-06 15:07:59',1,'Input Manual',NULL,1,'bayar'),(6737,97110,88,166500,NULL,'2026-07-07 03:22:46',1,'Input Manual',NULL,1,'bayar'),(6738,102758,102,188000,NULL,'2026-07-07 05:09:55',0,'Input Manual',NULL,1,'bayar'),(6739,103933,151,188000,NULL,'2026-07-07 08:16:17',1,'Input Manual',NULL,1,'bayar'),(6740,103924,151,166498,NULL,'2026-07-07 08:18:34',1,'Input Manual',NULL,1,'bayar'),(6741,97119,88,125000,NULL,'2026-07-08 06:46:34',1,'Input Manual',NULL,1,'bayar'),(6742,97323,88,166500,NULL,'2026-07-08 07:30:19',0,'Input Manual',NULL,1,'bayar'),(6743,104042,88,125000,NULL,'2026-07-08 12:39:57',NULL,'Input Manual',NULL,1,'bayar'),(6744,97393,88,125000,NULL,'2026-07-09 09:48:39',0,'Input Manual',NULL,1,'bayar'),(6745,104045,102,125000,NULL,'2026-07-09 13:27:54',NULL,'Input Manual',NULL,1,'bayar'),(6746,104041,102,125000,NULL,'2026-07-09 14:41:22',1,'Input Manual',NULL,1,'bayar'),(6747,102795,102,200000,NULL,'2026-07-09 14:41:25',1,'Input Manual',NULL,1,'bayar'),(6748,102773,102,130000,NULL,'2026-07-09 14:41:31',1,'Input Manual',NULL,1,'bayar'),(6749,102766,102,199000,NULL,'2026-07-09 14:41:35',1,'Input Manual',NULL,1,'bayar'),(6750,102759,102,100000,NULL,'2026-07-09 14:41:38',1,'Input Manual',NULL,1,'bayar'),(6751,102743,102,166500,NULL,'2026-07-09 14:41:41',1,'Input Manual',NULL,1,'bayar'),(6752,102740,102,166500,NULL,'2026-07-09 14:41:45',1,'Input Manual',NULL,1,'bayar'),(6753,102739,102,130000,NULL,'2026-07-09 14:41:48',1,'Input Manual',NULL,1,'bayar'),(6754,102717,102,222000,NULL,'2026-07-09 14:41:54',1,'Input Manual',NULL,1,'bayar'),(6755,97281,88,166500,NULL,'2026-07-10 02:53:22',0,'Input Manual',NULL,1,'bayar'),(6756,97257,88,166500,NULL,'2026-07-10 10:14:44',0,'Input Manual',NULL,1,'bayar'),(6757,101710,88,166500,NULL,'2026-07-10 11:40:50',0,'Input Manual',NULL,1,'bayar'),(6758,101953,96,100000,NULL,'2026-07-10 13:44:51',0,'Input Manual',NULL,1,'bayar'),(6759,102094,96,120000,NULL,'2026-07-10 13:47:13',0,'Input Manual',NULL,1,'bayar'),(6760,101791,88,125000,NULL,'2026-07-10 14:01:10',0,'Input Manual',NULL,1,'bayar'),(6761,103967,151,150000,NULL,'2026-07-11 06:10:20',0,'Input Manual',NULL,1,'bayar'),(6762,103937,151,150000,NULL,'2026-07-11 06:10:21',0,'Input Manual',NULL,1,'bayar'),(6763,103936,151,150000,NULL,'2026-07-11 06:10:22',0,'Input Manual',NULL,1,'bayar'),(6764,103922,151,166498,NULL,'2026-07-11 06:10:23',0,'Input Manual',NULL,1,'bayar'),(6765,102780,102,150000,NULL,'2026-07-11 06:18:37',0,'Input Manual',NULL,1,'bayar'),(6766,104047,102,100000,NULL,'2026-07-11 06:21:36',1,'Input Manual',NULL,1,'bayar'),(6767,97306,88,275000,NULL,'2026-07-12 12:41:34',0,'Input Manual',NULL,1,'bayar'),(6768,101486,88,166500,NULL,'2026-07-12 12:43:06',0,'Input Manual',NULL,1,'bayar'),(6769,101734,88,166500,NULL,'2026-07-12 12:52:23',1,'Input Manual',NULL,1,'bayar'),(6770,101540,88,200000,NULL,'2026-07-12 13:08:33',1,'Input Manual',NULL,1,'bayar'),(6771,102768,102,199000,NULL,'2026-07-12 16:29:01',1,'Input Manual',NULL,1,'bayar'),(6772,102727,102,130000,NULL,'2026-07-12 16:29:16',1,'Input Manual',NULL,1,'bayar'),(6773,104049,126,150000,NULL,'2026-07-12 19:51:03',0,'Input Manual',NULL,1,'bayar'),(6774,104048,126,166000,NULL,'2026-07-12 19:51:16',0,'Input Manual',NULL,1,'bayar'),(6775,104046,126,150000,NULL,'2026-07-12 19:51:47',0,'Input Manual',NULL,1,'bayar'),(6776,101610,88,166500,NULL,'2026-07-13 14:20:34',1,'Input Manual',NULL,1,'bayar'),(6777,104050,88,125000,NULL,'2026-07-13 15:03:06',1,'Input Manual',NULL,1,'bayar');

--
-- Table structure for table `tbl_tagihan_cicilan_hapus`
--

CREATE TABLE `tbl_tagihan_cicilan_hapus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_tagihan` int(11) DEFAULT NULL,
  `nominal_bayar` int(11) DEFAULT NULL,
  `bukti_transfer` text DEFAULT NULL,
  `tgl` timestamp NULL DEFAULT NULL,
  `status_notif` int(1) DEFAULT NULL,
  `sumber` varchar(100) DEFAULT 'Input Manual',
  `id_biller` int(11) DEFAULT NULL,
  `status_terima` int(11) DEFAULT 1,
  `status` varchar(100) NOT NULL DEFAULT 'bayar',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_tagihan_cicilan_hapus`
--


--
-- Table structure for table `tbl_tagihan_hapus`
--

CREATE TABLE `tbl_tagihan_hapus` (
  `id_tagihan` int(11) NOT NULL AUTO_INCREMENT,
  `id_paket` int(10) DEFAULT NULL,
  `id_area` varchar(10) DEFAULT NULL,
  `tgl_pembayaran` date DEFAULT NULL,
  `tagihan_asli` bigint(20) DEFAULT NULL,
  `tunggakan` bigint(20) DEFAULT NULL,
  `dis` bigint(20) DEFAULT NULL,
  `addons` bigint(20) DEFAULT NULL,
  `jml_tagihan` varchar(100) DEFAULT NULL,
  `status_tagihan` varchar(10) DEFAULT NULL,
  `id_pelanggan` int(10) DEFAULT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `id_admin` int(10) DEFAULT NULL,
  `tgl_tagihan` datetime DEFAULT NULL,
  `modifiedby` varchar(20) DEFAULT NULL,
  `bukti_pembayaran` text DEFAULT NULL,
  `id_biller` int(11) DEFAULT NULL,
  `transactionId` varchar(255) DEFAULT NULL,
  `faktur_pdf` text DEFAULT NULL,
  PRIMARY KEY (`id_tagihan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_tagihan_hapus`
--


--
-- Table structure for table `tbl_tagihan_item`
--

CREATE TABLE `tbl_tagihan_item` (
  `id_tagihan_item` int(11) NOT NULL AUTO_INCREMENT,
  `id_tagihan` int(11) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `nominal` bigint(20) DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `id_pelanggan` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_tagihan_item`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_tagihan_item`
--

INSERT INTO `tbl_tagihan_item` VALUES (1,79115,'Tagihan IPIN',60000,98,1959),(2,97073,'1',125000,88,416),(3,97346,'1',222000,88,4196),(4,97346,'2',53000,88,4196),(5,97195,'1',125000,88,1858),(6,101643,'1',188000,88,3940),(7,101587,'1',166500,88,1861);

--
-- Table structure for table `tbl_tagihan_mitra`
--

CREATE TABLE `tbl_tagihan_mitra` (
  `id_tagihan` int(11) NOT NULL AUTO_INCREMENT,
  `tgl_pembayaran` date DEFAULT NULL,
  `tagihan_asli` bigint(20) DEFAULT NULL,
  `tunggakan` bigint(20) DEFAULT NULL,
  `hukuman` bigint(20) DEFAULT NULL,
  `jml_tagihan` bigint(20) DEFAULT NULL,
  `status_tagihan` int(10) DEFAULT NULL,
  `tgl_tagihan` datetime DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `modifiedby` varchar(20) DEFAULT NULL,
  `bukti_pembayaran` text DEFAULT NULL,
  PRIMARY KEY (`id_tagihan`)
) ENGINE=InnoDB AUTO_INCREMENT=430 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_tagihan_mitra`
--

INSERT INTO `tbl_tagihan_mitra` VALUES (59,NULL,5800000,0,NULL,5800000,1,'2024-05-20 00:00:00',89,NULL,NULL),(60,NULL,13000000,0,NULL,13000000,1,'2024-05-20 00:00:00',96,NULL,NULL),(61,NULL,20000000,0,NULL,20000000,1,'2024-05-20 00:00:00',97,NULL,NULL),(62,NULL,5000000,0,NULL,5000000,1,'2024-05-20 00:00:00',98,NULL,NULL),(63,NULL,10000000,0,NULL,10000000,1,'2024-05-20 00:00:00',99,NULL,NULL),(64,NULL,7700000,0,NULL,7700000,1,'2024-05-20 00:00:00',100,NULL,NULL),(65,NULL,6095000,0,NULL,6095000,1,'2024-05-20 00:00:00',101,NULL,NULL),(66,NULL,4500000,0,NULL,4500000,1,'2024-05-20 00:00:00',102,NULL,NULL),(71,NULL,1000000,NULL,NULL,1000000,0,'2024-05-20 00:00:00',0,NULL,NULL),(75,NULL,0,0,NULL,0,0,'2024-06-01 00:00:00',87,NULL,NULL),(76,NULL,1,0,NULL,1,0,'2024-06-01 00:00:00',88,NULL,NULL),(77,NULL,5800000,0,NULL,5800000,1,'2024-06-01 00:00:00',89,NULL,NULL),(78,NULL,13000000,0,180000,13000000,1,'2024-06-01 00:00:00',96,NULL,NULL),(79,NULL,20000000,0,NULL,20000000,1,'2024-06-01 00:00:00',97,NULL,NULL),(80,NULL,5000000,0,NULL,5000000,1,'2024-06-01 00:00:00',98,NULL,NULL),(81,NULL,10000000,0,NULL,10000000,1,'2024-06-01 00:00:00',99,NULL,NULL),(82,NULL,7700000,0,NULL,7700000,1,'2024-06-01 00:00:00',100,NULL,NULL),(83,NULL,6095000,0,NULL,6095000,1,'2024-06-01 00:00:00',101,NULL,NULL),(84,NULL,4500000,0,NULL,4500000,1,'2024-06-01 00:00:00',102,NULL,NULL),(92,NULL,0,0,0,0,0,'2024-07-01 00:00:00',87,NULL,NULL),(93,NULL,1,1,0,2,0,'2024-07-01 00:00:00',88,NULL,NULL),(94,NULL,5800000,0,NULL,5800000,1,'2024-07-01 00:00:00',89,NULL,NULL),(95,NULL,13000000,0,NULL,13000000,1,'2024-07-01 00:00:00',96,NULL,NULL),(96,NULL,20000000,534000,NULL,20000000,2,'2024-07-01 00:00:00',97,NULL,NULL),(97,NULL,5000000,0,NULL,5000000,1,'2024-07-01 00:00:00',98,NULL,NULL),(98,NULL,10000000,0,NULL,10000000,1,'2024-07-01 00:00:00',99,NULL,NULL),(99,NULL,7700000,0,NULL,7700000,1,'2024-07-01 00:00:00',100,NULL,NULL),(100,NULL,6095000,0,NULL,6095000,1,'2024-07-01 00:00:00',101,NULL,NULL),(101,NULL,4500000,0,NULL,4500000,1,'2024-07-01 00:00:00',102,NULL,NULL),(109,NULL,27500000,19166700,NULL,27500000,2,'2024-07-22 00:00:00',118,NULL,NULL),(110,NULL,7400000,NULL,NULL,7400000,0,'2024-07-22 00:00:00',0,NULL,NULL),(111,NULL,7400000,NULL,NULL,7400000,0,'2024-07-22 00:00:00',0,NULL,NULL),(113,NULL,0,0,0,0,0,'2024-08-01 00:00:00',87,NULL,NULL),(114,NULL,1,2,0,3,0,'2024-08-01 00:00:00',88,NULL,NULL),(115,NULL,5800000,0,NULL,5800000,1,'2024-08-01 00:00:00',89,NULL,NULL),(116,NULL,13000000,0,NULL,13000000,1,'2024-08-01 00:00:00',96,NULL,NULL),(118,NULL,5000000,0,NULL,5000000,1,'2024-08-01 00:00:00',98,NULL,NULL),(119,NULL,10000000,0,NULL,10000000,1,'2024-08-01 00:00:00',99,NULL,NULL),(120,NULL,7700000,0,NULL,7700000,1,'2024-08-01 00:00:00',100,NULL,NULL),(121,NULL,6095000,521000,NULL,6095000,1,'2024-08-01 00:00:00',101,NULL,NULL),(122,NULL,4500000,0,NULL,4500000,1,'2024-08-01 00:00:00',102,NULL,NULL),(136,NULL,10300000,NULL,NULL,10300000,0,'2024-08-07 00:00:00',121,NULL,NULL),(138,NULL,20000000,0,NULL,20000000,1,'2024-08-18 00:00:00',97,NULL,NULL),(139,NULL,27500000,19166600,NULL,27500000,1,'2024-08-18 00:00:00',118,NULL,NULL),(140,NULL,5250000,NULL,NULL,5250000,0,'2024-08-29 00:00:00',0,NULL,NULL),(141,NULL,5250000,NULL,NULL,5250000,0,'2024-08-29 00:00:00',0,NULL,NULL),(142,NULL,5250000,NULL,NULL,5250000,0,'2024-08-29 00:00:00',0,NULL,NULL),(144,NULL,0,0,0,0,0,'2024-09-01 00:00:00',87,NULL,NULL),(145,NULL,1,3,0,4,0,'2024-09-01 00:00:00',88,NULL,NULL),(146,NULL,5800000,0,NULL,5800000,1,'2024-09-01 00:00:00',89,NULL,NULL),(147,NULL,13000000,0,NULL,13000000,1,'2024-09-01 00:00:00',96,NULL,NULL),(148,NULL,20000000,0,NULL,20000000,1,'2024-09-01 00:00:00',97,NULL,NULL),(149,NULL,5000000,0,NULL,5000000,1,'2024-09-01 00:00:00',98,NULL,NULL),(150,NULL,10000000,0,NULL,10000000,1,'2024-09-01 00:00:00',99,NULL,NULL),(151,NULL,7700000,0,NULL,7700000,1,'2024-09-01 00:00:00',100,NULL,NULL),(152,NULL,6095000,0,547100,6095000,1,'2024-09-01 00:00:00',101,NULL,NULL),(153,NULL,4500000,0,NULL,4500000,1,'2024-09-01 00:00:00',102,NULL,NULL),(159,NULL,27500000,0,4416660,27500000,1,'2024-09-01 00:00:00',118,NULL,NULL),(161,NULL,1610400,0,NULL,1610400,1,'2024-09-01 00:00:00',122,NULL,NULL),(163,NULL,0,0,0,0,0,'2024-10-01 00:00:00',87,NULL,NULL),(164,NULL,1,4,0,5,0,'2024-10-01 00:00:00',88,NULL,NULL),(165,NULL,5800000,0,NULL,5800000,1,'2024-10-01 00:00:00',89,NULL,NULL),(166,NULL,13000000,0,NULL,13000000,1,'2024-10-01 00:00:00',96,NULL,NULL),(167,NULL,20000000,0,NULL,20000000,1,'2024-10-01 00:00:00',97,NULL,NULL),(168,NULL,5000000,0,NULL,5000000,1,'2024-10-01 00:00:00',98,NULL,NULL),(169,NULL,10000000,0,NULL,10000000,1,'2024-10-01 00:00:00',99,NULL,NULL),(170,NULL,7700000,0,NULL,7700000,1,'2024-10-01 00:00:00',100,NULL,NULL),(171,NULL,6095000,0,NULL,6095000,1,'2024-10-01 00:00:00',101,NULL,NULL),(172,NULL,4500000,0,210000,4500000,1,'2024-10-01 00:00:00',102,NULL,NULL),(178,NULL,27500000,0,NULL,27500000,1,'2024-10-01 00:00:00',118,NULL,NULL),(180,NULL,1610400,0,NULL,1610400,1,'2024-10-01 00:00:00',122,NULL,NULL),(181,NULL,0,0,0,0,0,'2024-11-01 00:00:00',87,NULL,NULL),(182,NULL,1,5,1,7,0,'2024-11-01 00:00:00',88,NULL,NULL),(183,NULL,5800000,0,NULL,5800000,1,'2024-11-01 00:00:00',89,NULL,NULL),(184,NULL,13000000,0,NULL,13000000,1,'2024-11-01 00:00:00',96,NULL,NULL),(185,NULL,20000000,0,NULL,20000000,1,'2024-11-01 00:00:00',97,NULL,NULL),(186,NULL,5000000,0,NULL,5000000,1,'2024-11-01 00:00:00',98,NULL,NULL),(187,NULL,10000000,0,NULL,10000000,1,'2024-11-01 00:00:00',99,NULL,NULL),(188,NULL,7700000,0,NULL,7700000,1,'2024-11-01 00:00:00',100,NULL,NULL),(189,NULL,6095000,0,NULL,6095000,1,'2024-11-01 00:00:00',101,NULL,NULL),(190,NULL,4500000,0,40000,4500000,1,'2024-11-01 00:00:00',102,NULL,NULL),(195,NULL,27500000,0,2500000,27500000,0,'2024-11-01 00:00:00',118,NULL,NULL),(197,NULL,1610400,0,NULL,1610400,1,'2024-11-01 00:00:00',122,NULL,NULL),(198,NULL,1700000,NULL,NULL,1700000,0,'2024-11-05 00:00:00',0,NULL,NULL),(199,NULL,1500000,NULL,NULL,1500000,0,'2024-11-20 00:00:00',0,NULL,NULL),(200,NULL,25000000,NULL,NULL,25000000,0,'2024-11-21 00:00:00',0,NULL,NULL),(201,NULL,3750000,0,NULL,7930000,1,'2024-11-23 00:00:00',126,NULL,NULL),(202,NULL,0,0,0,0,0,'2024-12-01 00:00:00',87,NULL,NULL),(203,NULL,1,7,1,9,0,'2024-12-01 00:00:00',88,NULL,NULL),(204,NULL,5800000,0,NULL,5800000,1,'2024-12-01 00:00:00',89,NULL,NULL),(205,NULL,13000000,0,NULL,13000000,1,'2024-12-01 00:00:00',96,NULL,NULL),(206,NULL,20000000,0,NULL,20000000,1,'2024-12-01 00:00:00',97,NULL,NULL),(207,NULL,5000000,0,NULL,5000000,1,'2024-12-01 00:00:00',98,NULL,NULL),(208,NULL,10000000,0,NULL,10000000,1,'2024-12-01 00:00:00',99,NULL,NULL),(209,NULL,7700000,0,NULL,7700000,1,'2024-12-01 00:00:00',100,NULL,NULL),(210,NULL,6095000,0,NULL,6095000,1,'2024-12-01 00:00:00',101,NULL,NULL),(211,NULL,4500000,0,NULL,4500000,1,'2024-12-01 00:00:00',102,NULL,NULL),(216,NULL,27500000,7500000,2500000,27500000,0,'2024-12-01 00:00:00',118,NULL,NULL),(218,NULL,1610400,0,NULL,1610400,1,'2024-12-01 00:00:00',122,NULL,NULL),(219,NULL,3500000,0,NULL,3500000,1,'2024-12-01 00:00:00',125,NULL,NULL),(220,NULL,3750000,0,NULL,7930000,1,'2024-12-01 00:00:00',126,NULL,NULL),(221,NULL,0,NULL,NULL,0,0,'2024-12-14 00:00:00',0,NULL,NULL),(223,NULL,1750000,NULL,NULL,1750000,0,'2024-12-25 00:00:00',0,NULL,NULL),(224,NULL,0,0,0,0,0,'2025-01-01 00:00:00',87,NULL,NULL),(225,NULL,1,9,1,11,0,'2025-01-01 00:00:00',88,NULL,NULL),(226,NULL,5800000,0,NULL,5800000,1,'2025-01-01 00:00:00',89,NULL,NULL),(227,NULL,13000000,0,NULL,13000000,1,'2025-01-01 00:00:00',96,NULL,NULL),(228,NULL,20000000,0,NULL,20000000,1,'2025-01-01 00:00:00',97,NULL,NULL),(229,NULL,5000000,0,NULL,5000000,1,'2025-01-01 00:00:00',98,NULL,NULL),(230,NULL,10000000,0,NULL,10000000,1,'2025-01-01 00:00:00',99,NULL,NULL),(231,NULL,7700000,0,NULL,7700000,1,'2025-01-01 00:00:00',100,NULL,NULL),(232,NULL,6095000,0,NULL,6095000,1,'2025-01-01 00:00:00',101,NULL,NULL),(233,NULL,4500000,0,NULL,4500000,1,'2025-01-01 00:00:00',102,NULL,NULL),(238,NULL,27500000,25000000,3500000,27500000,0,'2025-01-01 00:00:00',118,NULL,NULL),(240,NULL,1610400,0,NULL,1610400,1,'2025-01-01 00:00:00',122,NULL,NULL),(241,NULL,3500000,0,NULL,3500000,1,'2025-01-01 00:00:00',125,NULL,NULL),(242,NULL,3750000,0,150000,7930000,1,'2025-01-01 00:00:00',126,NULL,NULL),(244,NULL,0,NULL,NULL,0,0,'2025-01-12 00:00:00',0,NULL,NULL),(245,NULL,0,0,0,0,0,'2025-02-01 00:00:00',87,NULL,NULL),(246,NULL,1,11,1,13,0,'2025-02-01 00:00:00',88,NULL,NULL),(247,NULL,5800000,0,NULL,5800000,1,'2025-02-01 00:00:00',89,NULL,NULL),(248,NULL,13000000,0,NULL,13000000,1,'2025-02-01 00:00:00',96,NULL,NULL),(249,NULL,20000000,0,NULL,20000000,1,'2025-02-01 00:00:00',97,NULL,NULL),(250,NULL,5000000,0,NULL,5000000,1,'2025-02-01 00:00:00',98,NULL,NULL),(251,NULL,10000000,0,NULL,10000000,1,'2025-02-01 00:00:00',99,NULL,NULL),(252,NULL,7700000,0,NULL,7700000,1,'2025-02-01 00:00:00',100,NULL,NULL),(253,NULL,6095000,0,NULL,6095000,1,'2025-02-01 00:00:00',101,NULL,NULL),(254,NULL,4500000,0,210000,4500000,1,'2025-02-01 00:00:00',102,NULL,NULL),(259,NULL,27500000,3500000,5350000,27500000,0,'2025-02-01 00:00:00',118,NULL,NULL),(261,NULL,1610400,0,NULL,1610400,1,'2025-02-01 00:00:00',122,NULL,NULL),(262,NULL,3500000,0,NULL,3500000,1,'2025-02-01 00:00:00',125,NULL,NULL),(263,NULL,3750000,0,165000,7930000,1,'2025-02-01 00:00:00',126,NULL,NULL),(266,NULL,3500000,NULL,NULL,3500000,0,'2025-02-01 00:00:00',0,NULL,NULL),(268,NULL,0,0,0,0,0,'2025-03-01 00:00:00',87,NULL,NULL),(269,NULL,1,13,1,15,0,'2025-03-01 00:00:00',88,NULL,NULL),(270,NULL,5800000,0,NULL,5800000,1,'2025-03-01 00:00:00',89,NULL,NULL),(271,NULL,13000000,0,100000,13000000,1,'2025-03-01 00:00:00',96,NULL,NULL),(272,NULL,20000000,0,NULL,20000000,1,'2025-03-01 00:00:00',97,NULL,NULL),(273,NULL,5000000,0,NULL,5000000,1,'2025-03-01 00:00:00',98,NULL,NULL),(274,NULL,10000000,0,NULL,10000000,1,'2025-03-01 00:00:00',99,NULL,NULL),(275,NULL,7700000,0,NULL,7700000,1,'2025-03-01 00:00:00',100,NULL,NULL),(276,NULL,6095000,0,NULL,6095000,1,'2025-03-01 00:00:00',101,NULL,NULL),(277,NULL,4500000,0,NULL,4500000,1,'2025-03-01 00:00:00',102,NULL,NULL),(282,NULL,27500000,8850000,3385000,27500000,0,'2025-03-01 00:00:00',118,NULL,NULL),(284,NULL,1610400,0,NULL,1610400,1,'2025-03-01 00:00:00',122,NULL,NULL),(285,NULL,3500000,0,NULL,3500000,1,'2025-03-01 00:00:00',125,NULL,NULL),(286,NULL,3750000,0,150000,7930000,0,'2025-03-01 00:00:00',126,NULL,NULL),(289,NULL,0,0,0,0,0,'2025-04-01 00:00:00',87,NULL,NULL),(290,NULL,1,15,2,18,0,'2025-04-01 00:00:00',88,NULL,NULL),(291,NULL,5800000,0,NULL,5800000,1,'2025-04-01 00:00:00',89,NULL,NULL),(292,NULL,13000000,0,NULL,13000000,1,'2025-04-01 00:00:00',96,NULL,NULL),(293,NULL,20000000,0,NULL,20000000,1,'2025-04-01 00:00:00',97,NULL,NULL),(294,NULL,5000000,0,NULL,5000000,1,'2025-04-01 00:00:00',98,NULL,NULL),(295,NULL,10000000,0,NULL,10000000,1,'2025-04-01 00:00:00',99,NULL,NULL),(296,NULL,7700000,0,NULL,7700000,1,'2025-04-01 00:00:00',100,NULL,NULL),(297,NULL,6095000,0,NULL,6095000,1,'2025-04-01 00:00:00',101,NULL,NULL),(298,NULL,4500000,0,NULL,4500000,1,'2025-04-01 00:00:00',102,NULL,NULL),(303,NULL,27500000,37235000,3723500,27500000,0,'2025-04-01 00:00:00',118,NULL,NULL),(305,NULL,1610400,0,NULL,1610400,1,'2025-04-01 00:00:00',122,NULL,NULL),(306,NULL,3500000,0,NULL,3500000,1,'2025-04-01 00:00:00',125,NULL,NULL),(307,NULL,3750000,1650000,165000,7930000,0,'2025-04-01 00:00:00',126,NULL,NULL),(310,NULL,3500000,NULL,NULL,3500000,0,'2025-04-03 00:00:00',0,NULL,NULL),(312,NULL,1500000,NULL,NULL,1500000,0,'2025-04-30 00:00:00',0,NULL,NULL),(313,NULL,0,0,0,0,0,'2025-05-01 00:00:00',87,NULL,NULL),(314,NULL,1,18,2,21,0,'2025-05-01 00:00:00',88,NULL,NULL),(315,NULL,5800000,0,NULL,5800000,1,'2025-05-01 00:00:00',89,NULL,NULL),(316,NULL,13000000,0,NULL,13000000,0,'2025-05-01 00:00:00',96,NULL,NULL),(317,NULL,20000000,0,NULL,20000000,1,'2025-05-01 00:00:00',97,NULL,NULL),(318,NULL,5000000,0,NULL,5000000,0,'2025-05-01 00:00:00',98,NULL,NULL),(319,NULL,10000000,0,NULL,10000000,1,'2025-05-01 00:00:00',99,NULL,NULL),(320,NULL,7700000,0,NULL,7700000,1,'2025-05-01 00:00:00',100,NULL,NULL),(321,NULL,6095000,0,NULL,6095000,1,'2025-05-01 00:00:00',101,NULL,NULL),(322,NULL,4500000,0,NULL,4500000,0,'2025-05-01 00:00:00',102,NULL,NULL),(327,NULL,27500000,65958500,6595850,27500000,0,'2025-05-01 00:00:00',118,NULL,NULL),(329,NULL,1610400,0,NULL,1610400,1,'2025-05-01 00:00:00',122,NULL,NULL),(330,NULL,3500000,0,NULL,3500000,1,'2025-05-01 00:00:00',125,NULL,NULL),(331,NULL,3750000,1815000,331500,7930000,0,'2025-05-01 00:00:00',126,NULL,NULL),(335,NULL,1500000,0,NULL,1500000,1,'2025-05-01 00:00:00',147,NULL,NULL),(336,NULL,0,0,NULL,0,0,'2026-04-13 00:00:00',87,NULL,NULL),(337,NULL,1,0,NULL,1,0,'2026-04-13 00:00:00',88,NULL,NULL),(338,NULL,5800000,0,NULL,5800000,1,'2026-04-13 00:00:00',89,NULL,NULL),(339,NULL,13000000,0,NULL,13000000,1,'2026-04-13 00:00:00',96,NULL,NULL),(340,NULL,20000000,0,NULL,20000000,1,'2026-04-13 00:00:00',97,NULL,NULL),(341,NULL,5000000,0,NULL,5000000,1,'2026-04-13 00:00:00',98,NULL,NULL),(342,NULL,10000000,0,NULL,10000000,1,'2026-04-13 00:00:00',99,NULL,NULL),(343,NULL,7700000,0,NULL,7700000,1,'2026-04-13 00:00:00',100,NULL,NULL),(344,NULL,6095000,0,NULL,6095000,1,'2026-04-13 00:00:00',101,NULL,NULL),(345,NULL,4500000,0,NULL,4500000,1,'2026-04-13 00:00:00',102,NULL,NULL),(350,NULL,27500000,0,NULL,27500000,1,'2026-04-13 00:00:00',118,NULL,NULL),(352,NULL,1610400,0,NULL,1610400,1,'2026-04-13 00:00:00',122,NULL,NULL),(353,NULL,3500000,0,NULL,3500000,1,'2026-04-13 00:00:00',125,NULL,NULL),(354,NULL,3750000,0,NULL,7930000,0,'2026-04-13 00:00:00',126,NULL,NULL),(358,NULL,1500000,0,NULL,1500000,1,'2026-04-13 00:00:00',147,NULL,NULL),(359,NULL,300000,NULL,NULL,300000,0,'2026-04-14 00:00:00',0,NULL,NULL),(360,NULL,2000000,NULL,NULL,2000000,0,'2026-04-14 00:00:00',0,NULL,NULL),(361,NULL,300000,0,NULL,300000,1,'2026-04-14 00:00:00',148,NULL,NULL),(362,NULL,2000000,0,NULL,2000000,1,'2026-04-14 00:00:00',149,NULL,NULL),(363,NULL,1320000,NULL,NULL,1320000,0,'2026-04-14 00:00:00',0,NULL,NULL),(364,NULL,1320000,0,NULL,1320000,1,'2026-04-14 00:00:00',150,NULL,NULL),(365,NULL,0,NULL,NULL,0,0,'2026-05-01 00:00:00',0,NULL,NULL),(366,NULL,0,NULL,NULL,0,0,'2026-05-01 00:00:00',0,NULL,NULL),(367,NULL,0,0,0,0,0,'2026-05-01 00:00:00',87,NULL,NULL),(368,NULL,1,1,0,2,0,'2026-05-01 00:00:00',88,NULL,NULL),(369,NULL,5800000,0,580000,6380000,0,'2026-05-01 00:00:00',89,NULL,NULL),(370,NULL,13000000,0,NULL,13000000,1,'2026-05-01 00:00:00',96,NULL,NULL),(371,NULL,20000000,0,NULL,20000000,1,'2026-05-01 00:00:00',97,NULL,NULL),(372,NULL,5000000,0,NULL,5000000,1,'2026-05-01 00:00:00',98,NULL,NULL),(373,NULL,10000000,0,NULL,10000000,1,'2026-05-01 00:00:00',99,NULL,NULL),(374,NULL,7700000,0,NULL,7700000,1,'2026-05-01 00:00:00',100,NULL,NULL),(375,NULL,6095000,0,NULL,6095000,1,'2026-05-01 00:00:00',101,NULL,NULL),(376,NULL,4500000,0,225000,4500000,1,'2026-05-01 00:00:00',102,NULL,NULL),(377,NULL,27500000,0,NULL,27500000,1,'2026-05-01 00:00:00',118,NULL,NULL),(378,NULL,1610400,0,NULL,1610400,1,'2026-05-01 00:00:00',122,NULL,NULL),(379,NULL,3500000,0,NULL,3500000,1,'2026-05-01 00:00:00',125,NULL,NULL),(380,NULL,3750000,500000,300000,7930000,0,'2026-05-01 00:00:00',126,NULL,NULL),(381,NULL,1500000,0,NULL,1500000,1,'2026-05-01 00:00:00',147,NULL,NULL),(382,NULL,300000,0,NULL,300000,1,'2026-05-01 00:00:00',148,NULL,NULL),(383,NULL,2000000,0,NULL,2000000,1,'2026-05-01 00:00:00',149,NULL,NULL),(384,NULL,1320000,0,132000,1452000,1,'2026-05-01 00:00:00',150,NULL,NULL),(385,NULL,0,0,NULL,0,1,'2026-05-01 00:00:00',151,NULL,NULL),(386,NULL,0,0,NULL,0,0,'2026-05-01 00:00:00',152,NULL,NULL),(387,NULL,0,NULL,NULL,0,0,'2026-05-30 00:00:00',0,NULL,NULL),(388,NULL,0,0,0,0,0,'2026-06-01 00:00:00',87,NULL,NULL),(389,NULL,1,2,0,3,0,'2026-06-01 00:00:00',88,NULL,NULL),(390,NULL,5800000,580000,638000,7018000,0,'2026-06-01 00:00:00',89,NULL,NULL),(391,NULL,13000000,0,NULL,13000000,1,'2026-06-01 00:00:00',96,NULL,NULL),(392,NULL,20000000,0,NULL,20000000,1,'2026-06-01 00:00:00',97,NULL,NULL),(393,NULL,5000000,0,NULL,5000000,1,'2026-06-01 00:00:00',98,NULL,NULL),(394,NULL,10000000,0,NULL,10000000,1,'2026-06-01 00:00:00',99,NULL,NULL),(395,NULL,7700000,0,NULL,7700000,1,'2026-06-01 00:00:00',100,NULL,NULL),(396,NULL,6095000,0,NULL,6095000,1,'2026-06-01 00:00:00',101,NULL,NULL),(397,NULL,4500000,0,472500,4500000,1,'2026-06-01 00:00:00',102,NULL,NULL),(398,NULL,27500000,0,300000,27800000,1,'2026-06-01 00:00:00',118,NULL,NULL),(399,NULL,1610400,0,NULL,1610400,1,'2026-06-01 00:00:00',122,NULL,NULL),(400,NULL,3500000,0,NULL,3500000,1,'2026-06-01 00:00:00',125,NULL,NULL),(401,NULL,3750000,800000,380000,4930000,0,'2026-06-01 00:00:00',126,NULL,NULL),(402,NULL,1500000,0,NULL,1500000,1,'2026-06-01 00:00:00',147,NULL,NULL),(403,NULL,300000,0,NULL,300000,1,'2026-06-01 00:00:00',148,NULL,NULL),(404,NULL,2000000,0,NULL,2000000,1,'2026-06-01 00:00:00',149,NULL,NULL),(405,NULL,1320000,0,NULL,1320000,0,'2026-06-01 00:00:00',150,NULL,NULL),(406,NULL,0,0,NULL,0,1,'2026-06-01 00:00:00',151,NULL,NULL),(407,NULL,0,0,0,0,0,'2026-06-01 00:00:00',152,NULL,NULL),(408,NULL,0,0,NULL,0,0,'2026-06-01 00:00:00',153,NULL,NULL),(409,NULL,0,0,0,0,0,'2026-07-01 00:00:00',87,NULL,NULL),(410,NULL,1,3,0,4,0,'2026-07-01 00:00:00',88,NULL,NULL),(411,NULL,5800000,1218000,701800,7719800,0,'2026-07-01 00:00:00',89,NULL,NULL),(412,NULL,13000000,0,400000,13400000,0,'2026-07-01 00:00:00',96,NULL,NULL),(413,NULL,20000000,0,NULL,20000000,0,'2026-07-01 00:00:00',97,NULL,NULL),(414,NULL,5000000,0,NULL,5000000,0,'2026-07-01 00:00:00',98,NULL,NULL),(415,NULL,10000000,0,NULL,10000000,0,'2026-07-01 00:00:00',99,NULL,NULL),(416,NULL,7700000,0,NULL,7700000,0,'2026-07-01 00:00:00',100,NULL,NULL),(417,NULL,6095000,0,NULL,6095000,0,'2026-07-01 00:00:00',101,NULL,NULL),(418,NULL,4500000,0,NULL,4500000,0,'2026-07-01 00:00:00',102,NULL,NULL),(419,NULL,27500000,0,960000,28460000,0,'2026-07-01 00:00:00',118,NULL,NULL),(420,NULL,1610400,0,NULL,1610400,0,'2026-07-01 00:00:00',122,NULL,NULL),(421,NULL,3500000,0,NULL,3500000,0,'2026-07-01 00:00:00',125,NULL,NULL),(422,NULL,3750000,4930000,493000,9173000,0,'2026-07-01 00:00:00',126,NULL,NULL),(423,NULL,1500000,0,NULL,1500000,0,'2026-07-01 00:00:00',147,NULL,NULL),(424,NULL,300000,0,NULL,300000,1,'2026-07-01 00:00:00',148,NULL,NULL),(425,NULL,2000000,0,NULL,2000000,0,'2026-07-01 00:00:00',149,NULL,NULL),(426,NULL,1320000,1320000,132000,2772000,0,'2026-07-01 00:00:00',150,NULL,NULL),(427,NULL,0,0,NULL,0,0,'2026-07-01 00:00:00',151,NULL,NULL),(428,NULL,0,0,0,0,0,'2026-07-01 00:00:00',152,NULL,NULL),(429,NULL,0,0,0,0,0,'2026-07-01 00:00:00',153,NULL,NULL);

--
-- Table structure for table `tbl_tagihan_mitra_cicilan`
--

CREATE TABLE `tbl_tagihan_mitra_cicilan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_tagihan` int(11) DEFAULT NULL,
  `nominal_bayar` bigint(20) DEFAULT NULL,
  `bukti_transfer` text DEFAULT NULL,
  `tgl` timestamp NULL DEFAULT NULL,
  `status_notif` int(1) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Manual',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_tagihan_mitra_cicilan`
--

INSERT INTO `tbl_tagihan_mitra_cicilan` VALUES (2,59,5800000,NULL,'2024-05-20 03:11:02',0,'','Manual'),(3,61,12000000,NULL,'2024-05-20 03:12:55',0,'','Manual'),(4,62,3200000,NULL,'2024-05-20 03:13:36',0,'','Manual'),(5,63,4000000,NULL,'2024-05-20 03:13:47',0,'','Manual'),(6,64,4000000,NULL,'2024-05-20 03:14:15',0,'','Manual'),(7,66,2100000,NULL,'2024-05-20 03:14:35',0,'','Manual'),(8,NULL,4000000,NULL,'2024-05-20 03:16:53',0,'','Manual'),(9,NULL,1500000,NULL,'2024-05-20 03:17:04',NULL,'','Manual'),(10,68,3000000,NULL,'2024-05-20 03:17:04',0,'','Manual'),(11,69,2000000,NULL,'2024-05-20 03:28:02',0,'','Manual'),(12,70,750000,NULL,'2024-05-20 03:28:19',0,'','Manual'),(13,72,6000000,NULL,'2024-05-20 03:28:26',0,'','Manual'),(14,65,4950000,NULL,'2024-05-20 04:06:25',0,'','Manual'),(15,60,7000000,NULL,'2024-05-21 05:16:08',0,'','Manual'),(16,73,1000000,NULL,'2024-05-24 22:44:01',0,'Pelunasan BW Bulan Mei 2024','Manual'),(17,60,3200000,NULL,'2024-05-25 02:32:55',0,'','Manual'),(18,62,800000,NULL,'2024-05-27 05:02:14',0,'Pelunasan','Manual'),(19,68,3250000,NULL,'2024-05-31 19:13:23',0,'','Manual'),(20,89,1000000,NULL,'2024-05-31 19:58:27',0,'','Manual'),(21,84,2100000,NULL,'2024-06-09 17:09:17',0,'','Manual'),(22,60,1800000,NULL,'2024-06-10 07:58:05',NULL,'','Manual'),(23,78,380000,NULL,'2024-06-10 07:58:06',0,'','Manual'),(24,87,750000,NULL,'2024-06-11 22:07:12',0,'','Manual'),(25,79,12000000,NULL,'2024-06-17 21:33:10',0,'','Manual'),(26,83,4950000,NULL,'2024-06-19 03:57:35',0,'','Manual'),(27,81,4000000,NULL,'2024-06-19 06:28:35',0,'','Manual'),(28,82,4000000,NULL,'2024-06-19 17:39:04',0,'','Manual'),(29,86,2000000,NULL,'2024-06-19 18:38:17',0,'','Manual'),(30,68,4250000,NULL,'2024-06-19 21:16:12',NULL,'','Manual'),(31,85,750000,NULL,'2024-06-19 21:16:13',0,'','Manual'),(32,80,4000000,NULL,'2024-06-20 05:37:34',0,'','Manual'),(33,78,11800000,NULL,'2024-06-23 06:33:01',0,'','Manual'),(34,77,5800000,NULL,'2024-06-24 16:47:01',0,'','Manual'),(35,85,5000000,NULL,'2024-06-25 23:31:39',0,'','Manual'),(36,106,1000000,NULL,'2024-06-30 21:50:41',0,'','Manual'),(37,86,500000,NULL,'2024-06-30 21:54:17',0,'','Manual'),(38,101,2100000,NULL,'2024-07-01 10:43:47',0,'','Manual'),(39,94,5800000,NULL,'2024-07-10 17:26:07',0,'','Manual'),(40,79,534000,NULL,'2024-07-16 04:13:10',0,'','Manual'),(41,99,4000000,NULL,'2024-07-17 09:46:05',0,'','Manual'),(42,98,4000000,NULL,'2024-07-18 07:12:27',0,'','Manual'),(43,86,500000,NULL,'2024-07-19 16:40:15',0,'','Manual'),(44,79,534000,NULL,'2024-07-19 16:40:35',0,'','Manual'),(45,97,4000000,NULL,'2024-07-19 21:06:42',0,'','Manual'),(46,95,5000000,NULL,'2024-07-21 19:35:26',0,'','Manual'),(47,100,4950000,NULL,'2024-07-21 21:35:30',0,'','Manual'),(48,95,7000000,NULL,'2024-07-26 07:01:28',0,'','Manual'),(49,85,5500000,NULL,'2024-07-31 08:06:11',NULL,'','Manual'),(50,102,4550000,NULL,'2024-07-31 08:06:13',0,'','Manual'),(51,127,1000000,NULL,'2024-07-31 21:05:49',0,'','Manual'),(52,135,7400000,NULL,'2024-07-31 21:12:26',0,'','Manual'),(53,103,2500000,NULL,'2024-08-10 10:26:39',NULL,'','Manual'),(54,124,2250000,NULL,'2024-08-10 10:26:41',0,'','Manual'),(55,104,750000,NULL,'2024-08-11 05:49:08',NULL,'','Manual'),(56,125,825000,NULL,'2024-08-11 05:49:10',0,'','Manual'),(57,115,5800000,NULL,'2024-08-11 16:24:34',0,'','Manual'),(58,120,4000000,NULL,'2024-08-17 18:28:19',0,'','Manual'),(59,122,2100000,NULL,'2024-08-17 18:28:54',0,'','Manual'),(60,138,12534000,NULL,'2024-08-19 03:04:47',0,'','Manual'),(61,119,4000000,NULL,'2024-08-19 06:40:26',0,'','Manual'),(62,118,4000000,NULL,'2024-08-20 05:21:13',0,'','Manual'),(63,100,521000,NULL,'2024-08-20 07:17:44',0,'','Manual'),(64,116,10000000,NULL,'2024-08-23 22:04:03',0,'','Manual'),(65,116,2000000,NULL,'2024-08-31 08:38:15',0,'','Manual'),(66,121,5471000,NULL,'2024-08-31 19:33:57',NULL,'Koreksi Pembayaran','Manual'),(67,152,547100,NULL,'2024-08-31 19:34:00',0,'Koreksi Pembayaran','Manual'),(68,123,16415000,NULL,'2024-08-31 19:36:22',0,'Koreksi Saldo tagihan ','Manual'),(69,160,7400000,NULL,'2024-08-31 19:39:44',0,'','Manual'),(70,157,1000000,NULL,'2024-09-01 22:25:42',0,'','Manual'),(71,124,500000,NULL,'2024-09-02 18:16:04',0,'','Manual'),(72,161,5250000,NULL,'2024-09-04 04:50:21',0,'Pelunasan BW CDN Bulan September 2024','Manual'),(73,156,750000,NULL,'2024-09-10 06:51:59',0,'','Manual'),(74,146,5800000,NULL,'2024-09-10 09:15:50',0,'','Manual'),(75,151,4000000,NULL,'2024-09-17 07:46:02',0,'','Manual'),(76,150,4000000,NULL,'2024-09-18 09:58:57',0,'','Manual'),(77,152,5471000,NULL,'2024-09-19 03:19:02',0,'','Manual'),(78,139,19166600,NULL,'2024-09-19 16:54:50',0,'','Manual'),(79,139,25000000,NULL,'2024-09-19 18:47:14',0,'','Manual'),(80,148,12534000,NULL,'2024-09-19 23:39:06',0,'','Manual'),(81,149,3500000,NULL,'2024-09-20 07:16:38',0,'','Manual'),(82,149,200000,NULL,'2024-09-20 07:19:41',0,'','Manual'),(83,149,300000,NULL,'2024-09-22 03:46:22',0,'','Manual'),(84,147,9000000,NULL,'2024-09-23 20:11:20',0,'','Manual'),(85,147,3000000,NULL,'2024-09-26 22:54:28',0,'','Manual'),(86,124,500000,NULL,'2024-09-27 19:48:14',0,'','Manual'),(87,159,29416660,NULL,'2024-09-28 19:00:20',0,'','Manual'),(88,155,2250000,NULL,'2024-09-30 16:08:26',0,'','Manual'),(89,176,1000000,NULL,'2024-09-30 16:18:07',0,'','Manual'),(90,179,7400000,NULL,'2024-09-30 16:18:27',0,'','Manual'),(91,180,5250000,NULL,'2024-10-04 18:32:28',0,'','Manual'),(92,153,2100000,NULL,'2024-10-05 04:11:30',NULL,'','Manual'),(93,172,1910000,NULL,'2024-10-05 04:11:32',0,'','Manual'),(94,155,250000,NULL,'2024-10-09 08:05:36',NULL,'','Manual'),(95,174,2250000,NULL,'2024-10-09 08:05:37',0,'','Manual'),(96,165,5800000,NULL,'2024-10-10 08:27:20',0,'','Manual'),(97,170,4000000,NULL,'2024-10-18 19:18:12',0,'','Manual'),(98,169,4000000,NULL,'2024-10-19 06:34:48',0,'','Manual'),(99,167,12534000,NULL,'2024-10-20 03:59:53',0,'','Manual'),(100,168,3000000,NULL,'2024-10-20 04:35:51',0,'','Manual'),(101,168,1000000,NULL,'2024-10-21 16:14:05',0,'','Manual'),(102,171,5471000,NULL,'2024-10-22 18:09:50',0,'','Manual'),(103,166,6000000,NULL,'2024-10-23 21:17:01',0,'','Manual'),(104,175,750000,NULL,'2024-10-24 04:51:36',0,'','Manual'),(105,166,6000000,NULL,'2024-10-28 09:37:01',0,'','Manual'),(106,196,8500000,NULL,'2024-10-31 18:27:24',0,'','Manual'),(107,178,17500000,NULL,'2024-10-31 18:28:45',0,'','Manual'),(108,193,1000000,NULL,'2024-10-31 22:40:54',0,'','Manual'),(109,178,7500000,NULL,'2024-11-01 07:26:08',NULL,'','Manual'),(110,195,2500000,NULL,'2024-11-01 07:26:10',0,'','Manual'),(111,172,400000,NULL,'2024-11-04 07:42:05',NULL,'','Manual'),(112,190,2140000,NULL,'2024-11-04 07:42:06',0,'','Manual'),(113,197,5250000,NULL,'2024-11-04 23:00:14',0,'','Manual'),(114,183,5800000,NULL,'2024-11-10 16:39:43',0,'','Manual'),(115,191,2500000,NULL,'2024-11-11 01:00:51',0,'','Manual'),(116,188,4000000,NULL,'2024-11-15 18:17:06',0,'','Manual'),(117,187,4000000,NULL,'2024-11-19 00:18:19',0,'','Manual'),(118,192,750000,NULL,'2024-11-19 00:34:56',0,'','Manual'),(119,186,4000000,NULL,'2024-11-20 06:19:25',0,'','Manual'),(120,185,13334000,NULL,'2024-11-21 16:41:18',0,'','Manual'),(121,189,5471000,NULL,'2024-11-22 04:36:05',0,'','Manual'),(122,184,7000000,NULL,'2024-11-23 05:23:23',0,'','Manual'),(123,201,1500000,NULL,'2024-11-23 08:34:30',0,'','Manual'),(124,184,5000000,NULL,'2024-11-29 08:19:30',0,'','Manual'),(125,214,1000000,NULL,'2024-12-01 04:32:06',0,'','Manual'),(126,212,2500000,NULL,'2024-12-01 05:41:03',0,'','Manual'),(127,219,1700000,NULL,'2024-12-01 07:31:45',0,'','Manual'),(128,217,8500000,NULL,'2024-12-01 18:49:33',0,'','Manual'),(129,218,5250000,NULL,'2024-12-04 00:11:59',0,'','Manual'),(130,213,750000,NULL,'2024-12-09 18:00:37',0,'','Manual'),(131,211,2100000,NULL,'2024-12-09 20:06:30',0,'','Manual'),(132,204,5800000,NULL,'2024-12-10 10:33:38',0,'','Manual'),(133,208,4000000,NULL,'2024-12-18 07:26:04',0,'','Manual'),(134,209,4000000,NULL,'2024-12-18 17:25:00',0,'','Manual'),(135,210,5471000,NULL,'2024-12-20 19:11:21',0,'','Manual'),(136,207,4000000,NULL,'2024-12-21 06:08:24',0,'','Manual'),(137,205,7000000,NULL,'2024-12-23 20:19:21',0,'','Manual'),(138,206,13334000,NULL,'2024-12-26 06:19:56',0,'','Manual'),(139,205,5000000,NULL,'2024-12-27 05:46:56',0,'','Manual'),(140,195,17500000,NULL,'2024-12-31 09:05:52',0,'','Manual'),(141,239,8500000,NULL,'2024-12-31 20:12:14',0,'','Manual'),(142,234,2500000,NULL,'2024-12-31 20:45:07',0,'','Manual'),(143,241,1700000,NULL,'2025-01-01 09:05:05',0,'','Manual'),(144,240,5250000,NULL,'2025-01-03 18:46:36',0,'','Manual'),(145,236,1000000,NULL,'2025-01-08 20:45:44',0,'','Manual'),(146,216,10000000,NULL,'2025-01-10 07:56:12',0,'','Manual'),(147,226,5800000,NULL,'2025-01-10 08:11:57',0,'','Manual'),(148,235,750000,NULL,'2025-01-10 09:11:00',0,'','Manual'),(149,231,5300000,NULL,'2025-01-16 07:49:36',0,'','Manual'),(150,230,4000000,NULL,'2025-01-19 06:42:16',0,'','Manual'),(151,229,3500000,NULL,'2025-01-20 06:17:33',0,'','Manual'),(152,228,13334000,NULL,'2025-01-20 06:21:32',0,'','Manual'),(153,229,500000,NULL,'2025-01-20 18:16:28',0,'','Manual'),(154,232,5471000,NULL,'2025-01-21 05:43:27',0,'','Manual'),(155,220,1500000,NULL,'2025-01-23 16:30:19',0,'','Manual'),(156,227,9000000,NULL,'2025-01-25 19:54:10',0,'','Manual'),(157,243,1750000,NULL,'2025-01-26 06:16:21',0,'','Manual'),(158,227,3000000,NULL,'2025-01-30 23:23:30',0,'','Manual'),(159,260,8500000,NULL,'2025-01-31 21:48:57',0,'','Manual'),(160,262,2550000,NULL,'2025-02-01 08:26:31',0,'','Manual'),(161,261,5250000,NULL,'2025-02-04 18:47:18',0,'','Manual'),(162,256,750000,NULL,'2025-02-05 23:57:07',0,'','Manual'),(163,247,5800000,NULL,'2025-02-09 22:37:57',0,'','Manual'),(164,233,1700000,NULL,'2025-02-13 07:37:32',0,'','Manual'),(165,267,3500000,NULL,'2025-02-15 03:08:28',0,'','Manual'),(166,252,5300000,NULL,'2025-02-16 06:08:41',0,'','Manual'),(167,251,4000000,NULL,'2025-02-19 06:15:53',0,'','Manual'),(168,257,1000000,NULL,'2025-02-19 22:32:25',0,'','Manual'),(169,249,13334000,NULL,'2025-02-20 05:53:17',0,'','Manual'),(170,250,3800000,NULL,'2025-02-20 08:27:10',0,'','Manual'),(171,253,5471000,NULL,'2025-02-22 06:57:03',0,'','Manual'),(172,250,200000,NULL,'2025-02-23 18:31:58',0,'','Manual'),(173,242,1650000,NULL,'2025-02-24 07:22:12',NULL,'','Manual'),(174,263,165000,NULL,'2025-02-24 07:22:12',0,'','Manual'),(175,233,400000,NULL,'2025-02-24 07:25:46',NULL,'','Manual'),(176,254,3210000,NULL,'2025-02-24 07:25:47',0,'','Manual'),(177,238,25000000,NULL,'2025-02-24 17:20:14',0,'','Manual'),(178,248,11000000,NULL,'2025-02-25 19:43:21',0,'','Manual'),(179,255,2500000,NULL,'2025-02-26 20:51:08',0,'','Manual'),(180,238,25000000,NULL,'2025-02-27 20:29:07',0,'','Manual'),(181,283,8500000,NULL,'2025-03-01 00:58:28',0,'','Manual'),(182,285,2550000,NULL,'2025-03-02 07:19:50',0,'','Manual'),(183,285,2550000,NULL,'2025-03-02 07:23:46',1,'','Manual'),(184,284,5250000,NULL,'2025-03-05 02:17:20',0,'','Manual'),(185,248,1000000,NULL,'2025-03-06 23:49:19',NULL,'','Manual'),(186,271,100000,NULL,'2025-03-06 23:49:20',0,'','Manual'),(187,270,5800000,NULL,'2025-03-10 06:19:13',0,'','Manual'),(188,277,3000000,NULL,'2025-03-10 10:26:36',0,'','Manual'),(189,279,750000,NULL,'2025-03-14 20:18:34',0,'','Manual'),(190,275,5300000,NULL,'2025-03-16 22:48:37',0,'','Manual'),(191,274,4000000,NULL,'2025-03-19 03:59:03',0,'','Manual'),(192,272,13334000,NULL,'2025-03-19 09:47:21',0,'','Manual'),(193,273,2650000,NULL,'2025-03-20 05:08:44',0,'','Manual'),(194,276,5471000,NULL,'2025-03-20 09:15:11',0,'','Manual'),(195,271,7000000,NULL,'2025-03-22 00:19:16',0,'','Manual'),(196,273,1350000,NULL,'2025-03-23 08:32:51',0,'','Manual'),(197,263,1500000,NULL,'2025-03-24 07:40:31',0,'','Manual'),(198,278,2500000,NULL,'2025-03-28 13:48:21',0,'','Manual'),(199,271,5000000,NULL,'2025-03-29 08:01:46',0,'','Manual'),(200,259,25000000,NULL,'2025-03-30 14:40:40',0,'','Manual'),(201,300,750000,NULL,'2025-04-01 00:18:45',0,'','Manual'),(202,304,9300000,NULL,'2025-04-01 04:45:02',0,'','Manual'),(203,306,2550000,NULL,'2025-04-02 03:05:25',0,'','Manual'),(204,311,3500000,NULL,'2025-04-03 07:31:34',0,'Pembayaran Pra Bayar Internet CDN Dedicated 100mbps ','Manual'),(205,280,1000000,NULL,'2025-04-04 04:54:40',NULL,'Pembayaran Internet Dedicated CDN ','Manual'),(206,301,100000,NULL,'2025-04-04 04:54:41',0,'Pembayaran Internet Dedicated CDN ','Manual'),(207,305,5250000,NULL,'2025-04-04 21:25:41',0,'','Manual'),(208,291,5800000,NULL,'2025-04-10 07:52:33',0,'','Manual'),(209,287,1750000,NULL,'2025-04-13 04:05:41',0,'','Manual'),(210,298,3000000,NULL,'2025-04-15 16:46:24',0,'','Manual'),(211,296,5300000,NULL,'2025-04-18 04:58:32',0,'','Manual'),(212,295,4600000,NULL,'2025-04-19 06:54:30',0,'','Manual'),(213,297,5471000,NULL,'2025-04-20 06:32:43',0,'','Manual'),(214,294,3700000,NULL,'2025-04-21 02:48:00',0,'','Manual'),(215,294,300000,NULL,'2025-04-21 05:33:47',0,'','Manual'),(216,299,2500000,NULL,'2025-04-21 17:51:06',0,'','Manual'),(217,293,13334000,NULL,'2025-04-23 05:06:17',0,'','Manual'),(218,292,8000000,NULL,'2025-04-25 05:29:41',0,'','Manual'),(219,292,4000000,NULL,'2025-04-27 00:34:37',0,'','Manual'),(220,307,1500000,NULL,'2025-04-30 18:24:17',0,'','Manual'),(221,309,6000000,NULL,'2025-04-30 22:43:29',0,'','Manual'),(222,308,1750000,NULL,'2025-04-30 23:06:09',0,'','Manual'),(223,328,9300000,NULL,'2025-05-01 08:54:31',0,'','Manual'),(224,330,2550000,NULL,'2025-05-02 05:07:29',0,'','Manual'),(225,329,5250000,NULL,'2025-05-04 21:29:58',0,'','Manual'),(226,322,3500000,NULL,'2025-05-09 09:29:56',0,'','Manual'),(227,315,5800000,NULL,'2025-05-10 23:26:38',0,'','Manual'),(228,335,1500000,NULL,'2025-05-14 17:25:48',0,'','Manual'),(229,324,750000,NULL,'2025-05-18 03:01:21',0,'','Manual'),(230,320,5300000,NULL,'2025-05-18 06:50:46',0,'','Manual'),(231,319,4600000,NULL,'2025-05-19 05:48:48',0,'','Manual'),(232,317,13334000,NULL,'2025-05-19 06:23:49',0,'','Manual'),(233,321,6095000,NULL,'2025-05-20 07:12:58',0,'','Manual'),(234,318,2100000,NULL,'2025-05-20 17:21:48',0,'','Manual'),(235,318,1500000,NULL,'2025-05-20 20:29:10',0,'','Manual'),(236,361,300000,NULL,'2026-04-14 02:53:32',0,'','Manual'),(237,352,2930400,NULL,'2026-04-14 13:17:58',0,'','Manual'),(238,358,1500000,NULL,'2026-04-20 01:45:39',0,'','Manual'),(239,362,2000000,NULL,'2026-04-20 02:01:02',0,'','Manual'),(240,353,3000000,NULL,'2026-04-20 02:01:25',0,'','Manual'),(241,344,6095000,NULL,'2026-04-20 02:05:19',0,'','Manual'),(242,345,3000000,NULL,'2026-04-20 04:58:03',0,'','Manual'),(243,343,7700000,NULL,'2026-04-20 12:41:12',0,'','Manual'),(244,340,17000000,NULL,'2026-04-20 12:59:23',0,'','Manual'),(245,342,7000000,NULL,'2026-04-21 09:30:05',0,'','Manual'),(246,341,4000000,NULL,'2026-04-21 13:13:16',0,'','Manual'),(247,341,500000,NULL,'2026-04-23 11:59:43',0,'','Manual'),(248,353,500000,NULL,'2026-04-27 04:03:13',0,'','Manual'),(249,339,9000000,NULL,'2026-04-27 15:08:19',0,'','Manual'),(250,350,27500000,NULL,'2026-04-29 12:24:00',0,'','Manual'),(251,339,4000000,NULL,'2026-04-30 14:15:15',0,'','Manual'),(252,379,3000000,NULL,'2026-05-04 05:15:27',0,'','Manual'),(253,364,1320000,NULL,'2026-05-05 01:01:26',NULL,'','Manual'),(254,384,132000,NULL,'2026-05-05 01:01:30',0,'','Manual'),(255,354,2500000,NULL,'2026-05-07 00:33:29',0,'','Manual'),(256,338,5800000,NULL,'2026-05-10 14:59:10',0,'','Manual'),(257,378,1610400,NULL,'2026-05-11 13:45:37',0,'','Manual'),(258,385,2250000,NULL,'2026-05-17 13:59:08',0,'','Manual'),(259,345,2250000,NULL,'2026-05-18 07:35:16',NULL,'','Manual'),(260,376,750000,NULL,'2026-05-18 07:35:19',0,'','Manual'),(261,375,6095000,NULL,'2026-05-19 00:35:00',0,'','Manual'),(262,382,300000,NULL,'2026-05-19 02:01:37',0,'','Manual'),(263,383,2000000,NULL,'2026-05-19 02:09:30',0,'','Manual'),(264,381,1500000,NULL,'2026-05-19 12:58:11',0,'','Manual'),(265,374,7700000,NULL,'2026-05-20 02:24:11',0,'','Manual'),(266,371,17000000,NULL,'2026-05-20 08:41:02',0,'','Manual'),(267,373,7000000,NULL,'2026-05-20 12:35:21',0,'','Manual'),(268,372,2900000,NULL,'2026-05-21 12:58:28',0,'','Manual'),(269,384,1320000,NULL,'2026-05-25 06:46:11',0,'','Manual'),(270,370,8000000,NULL,'2026-05-26 14:49:32',0,'','Manual'),(271,379,500000,NULL,'2026-05-29 01:44:37',0,'','Manual'),(272,372,1600000,NULL,'2026-05-30 04:54:14',0,'','Manual'),(273,377,24500000,NULL,'2026-05-31 11:08:27',0,'','Manual'),(274,370,5000000,NULL,'2026-05-31 13:15:23',0,'','Manual'),(275,377,3000000,NULL,'2026-06-04 00:25:58',NULL,'','Manual'),(276,398,300000,NULL,'2026-06-04 00:26:01',0,'','Manual'),(277,400,3000000,NULL,'2026-06-04 11:12:58',0,'','Manual'),(278,404,2000000,NULL,'2026-06-04 14:32:01',0,'','Manual'),(279,376,4500000,NULL,'2026-06-05 06:47:30',0,'','Manual'),(280,380,3000000,NULL,'2026-06-05 12:09:22',0,'','Manual'),(281,399,1610400,NULL,'2026-06-10 08:32:06',0,'','Manual'),(282,369,5800000,NULL,'2026-06-11 00:11:05',0,'','Manual'),(283,403,300000,NULL,'2026-06-14 06:35:39',0,'','Manual'),(284,376,225000,NULL,'2026-06-14 14:52:35',NULL,'','Manual'),(285,397,5722500,NULL,'2026-06-14 14:52:38',0,'','Manual'),(286,406,2250000,NULL,'2026-06-14 14:52:50',0,'','Manual'),(287,392,17000000,NULL,'2026-06-17 09:11:18',0,'','Manual'),(288,402,1500000,NULL,'2026-06-19 11:03:44',0,'','Manual'),(289,396,6095000,NULL,'2026-06-20 06:56:57',0,'','Manual'),(290,394,7000000,NULL,'2026-06-20 15:20:40',0,'','Manual'),(291,393,3000000,NULL,'2026-06-21 03:34:59',0,'','Manual'),(292,395,7700000,NULL,'2026-06-23 06:52:11',0,'','Manual'),(293,391,9000000,NULL,'2026-06-26 14:36:10',0,'','Manual'),(294,393,1500000,NULL,'2026-06-29 14:15:15',0,'','Manual'),(295,400,500000,NULL,'2026-06-30 05:45:32',0,'','Manual'),(296,398,17900000,NULL,'2026-06-30 16:57:38',0,'','Manual'),(299,391,4000000,NULL,'2026-07-02 13:55:07',NULL,'','Manual'),(300,412,400000,NULL,'2026-07-02 13:55:10',0,'','Manual'),(301,398,9600000,NULL,'2026-07-02 13:59:42',NULL,'','Manual'),(302,419,960000,NULL,'2026-07-02 13:59:45',0,'','Manual'),(303,421,2000000,NULL,'2026-07-04 02:58:52',0,'','Manual'),(304,390,5800000,NULL,'2026-07-10 14:43:03',0,'','Manual'),(305,424,300000,NULL,'2026-07-13 05:49:06',0,'','Manual');

--
-- Table structure for table `tbl_tagihan_mitra_item`
--

CREATE TABLE `tbl_tagihan_mitra_item` (
  `id_tagihan_item` int(11) NOT NULL AUTO_INCREMENT,
  `id_tagihan` int(11) NOT NULL,
  `keterangan` text NOT NULL,
  `nominal` bigint(20) NOT NULL,
  `id_admin` int(11) NOT NULL,
  `tgl` timestamp NOT NULL DEFAULT current_timestamp(),
  `id_pinjaman` int(11) DEFAULT NULL,
  `tipe` varchar(100) NOT NULL DEFAULT 'Regular',
  PRIMARY KEY (`id_tagihan_item`)
) ENGINE=InnoDB AUTO_INCREMENT=654 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_tagihan_mitra_item`
--

INSERT INTO `tbl_tagihan_mitra_item` VALUES (69,36,'Mitra Kedokan Gabus',13000000,96,'2024-05-20 02:53:59',NULL,'Regular'),(70,37,'Mitra Cibereng Blok 2',20000000,97,'2024-05-20 02:55:15',NULL,'Regular'),(71,38,'Mitra Rancaipik',5000000,98,'2024-05-20 02:56:30',NULL,'Regular'),(72,39,'Mitra Kendayakan',10000000,99,'2024-05-20 02:57:20',NULL,'Regular'),(73,40,'Mitra Rajaiang',7700000,100,'2024-05-20 02:58:22',NULL,'Regular'),(74,41,'MItra Suketbaju',6095000,101,'2024-05-20 02:59:15',NULL,'Regular'),(75,42,'MItra Banjar Wangunan',4500000,102,'2024-05-20 03:01:28',NULL,'Regular'),(76,43,'Mitra Rancaipik',1,103,'2024-05-20 03:02:57',NULL,'Regular'),(77,44,'MItra Sodikin',0,86,'2024-05-20 03:05:47',NULL,'Regular'),(78,45,'MItra Rachmat',0,87,'2024-05-20 03:05:47',NULL,'Regular'),(79,46,'Cirebon Kota',1,88,'2024-05-20 03:05:47',NULL,'Regular'),(80,47,'Cipto Cirebon Kota',5800000,89,'2024-05-20 03:05:47',NULL,'Regular'),(81,48,'Mitra Kedokan Gabus',13000000,96,'2024-05-20 03:05:47',NULL,'Regular'),(82,49,'Mitra Cibereng Blok 2',20000000,97,'2024-05-20 03:05:47',NULL,'Regular'),(83,50,'Mitra Rancaipik',5000000,98,'2024-05-20 03:05:47',NULL,'Regular'),(84,51,'Mitra Kendayakan',10000000,99,'2024-05-20 03:05:47',NULL,'Regular'),(85,52,'Mitra Rajaiang',7700000,100,'2024-05-20 03:05:47',NULL,'Regular'),(86,53,'MItra Suketbaju',6095000,101,'2024-05-20 03:05:47',NULL,'Regular'),(87,54,'MItra Banjar Wangunan',4500000,102,'2024-05-20 03:05:47',NULL,'Regular'),(88,55,'Mitra Rancaipik',1,103,'2024-05-20 03:05:47',NULL,'Regular'),(92,59,'Cipto Cirebon Kota',5800000,89,'2024-05-20 03:10:28',NULL,'Regular'),(93,60,'Mitra Kedokan Gabus',13000000,96,'2024-05-20 03:10:28',NULL,'Regular'),(94,61,'Mitra Cibereng Blok 2',20000000,97,'2024-05-20 03:10:28',NULL,'Regular'),(95,62,'Mitra Rancaipik',5000000,98,'2024-05-20 03:10:28',NULL,'Regular'),(96,63,'Mitra Kendayakan',10000000,99,'2024-05-20 03:10:28',NULL,'Regular'),(97,64,'Mitra Rajaiang',7700000,100,'2024-05-20 03:10:28',NULL,'Regular'),(98,65,'MItra Suketbaju',6095000,101,'2024-05-20 03:10:28',NULL,'Regular'),(99,66,'MItra Banjar Wangunan',4500000,102,'2024-05-20 03:10:28',NULL,'Regular'),(101,68,'Mitra Rancaipik',10500000,103,'2024-05-20 03:16:04',NULL,'Regular'),(102,69,'Mitra Cibereng',2000000,104,'2024-05-20 03:21:03',NULL,'Regular'),(103,70,'Mitra Tempel',750000,105,'2024-05-20 03:22:22',NULL,'Regular'),(104,71,'Mitra Mundak',1000000,0,'2024-05-20 03:26:53',NULL,'Regular'),(105,72,'Mitra Puntang',6000000,106,'2024-05-20 03:27:52',NULL,'Regular'),(106,73,'MItra Mundak Jaya',1000000,107,'2024-05-20 03:29:23',NULL,'Regular'),(107,74,'MItra Sodikin',0,86,'2024-05-31 10:01:02',NULL,'Regular'),(108,75,'MItra Rachmat',0,87,'2024-05-31 10:01:02',NULL,'Regular'),(109,76,'Cirebon Kota',1,88,'2024-05-31 10:01:02',NULL,'Regular'),(110,77,'Cipto Cirebon Kota',5800000,89,'2024-05-31 10:01:02',NULL,'Regular'),(111,78,'Mitra Kedokan Gabus',13000000,96,'2024-05-31 10:01:02',NULL,'Regular'),(112,78,'Tunggakan',13000000,96,'2024-05-31 10:01:02',NULL,'Regular'),(113,78,'Punishment',13000000,96,'2024-05-31 10:01:02',NULL,'Regular'),(114,79,'Mitra Cibereng Blok 2',20000000,97,'2024-05-31 10:01:02',NULL,'Regular'),(115,80,'Mitra Rancaipik',5000000,98,'2024-05-31 10:01:02',NULL,'Regular'),(116,81,'Mitra Kendayakan',10000000,99,'2024-05-31 10:01:02',NULL,'Regular'),(117,82,'Mitra Rajaiang',7700000,100,'2024-05-31 10:01:02',NULL,'Regular'),(118,83,'MItra Suketbaju',6095000,101,'2024-05-31 10:01:02',NULL,'Regular'),(119,84,'MItra Banjar Wangunan',4500000,102,'2024-05-31 10:01:02',NULL,'Regular'),(120,85,'Mitra Rancaipik',10500000,103,'2024-05-31 10:01:02',NULL,'Regular'),(121,85,'Tunggakan',7500000,103,'2024-05-31 10:01:02',NULL,'Regular'),(122,85,'Punishment',750000,103,'2024-05-31 10:01:02',NULL,'Regular'),(123,86,'Mitra Cibereng',2000000,104,'2024-05-31 10:01:02',NULL,'Regular'),(124,87,'Mitra Tempel',750000,105,'2024-05-31 10:01:02',NULL,'Regular'),(126,89,'MItra Mundak Jaya',1000000,107,'2024-05-31 10:01:02',NULL,'Regular'),(127,90,'Mikrotik Ibad',0,114,'2024-06-04 06:06:49',NULL,'Regular'),(128,91,'MItra Sodikin',0,86,'2024-06-30 10:01:02',NULL,'Regular'),(129,91,'Tunggakan',0,86,'2024-06-30 10:01:02',NULL,'Regular'),(130,91,'Punishment',0,86,'2024-06-30 10:01:02',NULL,'Regular'),(131,92,'MItra Rachmat',0,87,'2024-06-30 10:01:02',NULL,'Regular'),(132,92,'Tunggakan',0,87,'2024-06-30 10:01:02',NULL,'Regular'),(133,92,'Punishment',0,87,'2024-06-30 10:01:02',NULL,'Regular'),(134,93,'Cirebon Kota',1,88,'2024-06-30 10:01:02',NULL,'Regular'),(135,93,'Tunggakan',1,88,'2024-06-30 10:01:02',NULL,'Regular'),(136,93,'Punishment',0,88,'2024-06-30 10:01:02',NULL,'Regular'),(137,94,'Cipto Cirebon Kota',5800000,89,'2024-06-30 10:01:02',NULL,'Regular'),(138,95,'Mitra Kedokan Gabus',13000000,96,'2024-06-30 10:01:02',NULL,'Regular'),(139,96,'Mitra Cibereng Blok 2',20000000,97,'2024-06-30 10:01:02',NULL,'Regular'),(140,97,'Mitra Rancaipik',5000000,98,'2024-06-30 10:01:02',NULL,'Regular'),(141,98,'Mitra Kendayakan',10000000,99,'2024-06-30 10:01:02',NULL,'Regular'),(142,99,'Mitra Rajaiang',7700000,100,'2024-06-30 10:01:02',NULL,'Regular'),(143,100,'MItra Suketbaju',6095000,101,'2024-06-30 10:01:02',NULL,'Regular'),(144,101,'MItra Banjar Wangunan',4500000,102,'2024-06-30 10:01:02',NULL,'Regular'),(145,102,'Mitra Rancaipik',10500000,103,'2024-06-30 10:01:02',NULL,'Regular'),(146,102,'Tunggakan',5500000,103,'2024-06-30 10:01:02',NULL,'Regular'),(147,102,'Punishment',550000,103,'2024-06-30 10:01:02',NULL,'Regular'),(148,103,'Mitra Cibereng',2000000,104,'2024-06-30 10:01:02',NULL,'Regular'),(149,104,'Mitra Tempel',750000,105,'2024-06-30 10:01:02',NULL,'Regular'),(151,106,'MItra Mundak Jaya',1000000,107,'2024-06-30 10:01:02',NULL,'Regular'),(152,107,'Mikrotik Ibad',0,114,'2024-06-30 10:01:02',NULL,'Regular'),(153,107,'Tunggakan',0,114,'2024-06-30 10:01:02',NULL,'Regular'),(154,107,'Punishment',0,114,'2024-06-30 10:01:02',NULL,'Regular'),(156,109,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-07-21 19:27:04',NULL,'Regular'),(157,110,'Pembayaran Internet Dedicated CDN ',7400000,0,'2024-07-21 19:32:51',NULL,'Regular'),(158,111,'Pembayaran Internet Dedicated CDN ',7400000,0,'2024-07-21 19:34:16',NULL,'Regular'),(159,112,'Mitra Cirebon Kota',7400000,119,'2024-07-21 21:38:23',NULL,'Regular'),(160,113,'MItra Rachmat',0,87,'2024-07-31 10:01:02',NULL,'Regular'),(161,113,'Tunggakan',0,87,'2024-07-31 10:01:02',NULL,'Regular'),(162,113,'Punishment',0,87,'2024-07-31 10:01:02',NULL,'Regular'),(163,114,'Cirebon Kota',1,88,'2024-07-31 10:01:02',NULL,'Regular'),(164,114,'Tunggakan',2,88,'2024-07-31 10:01:02',NULL,'Regular'),(165,114,'Punishment',0,88,'2024-07-31 10:01:02',NULL,'Regular'),(166,115,'Cipto Cirebon Kota',5800000,89,'2024-07-31 10:01:02',NULL,'Regular'),(167,116,'Mitra Kedokan Gabus',13000000,96,'2024-07-31 10:01:02',NULL,'Regular'),(171,118,'Mitra Rancaipik',5000000,98,'2024-07-31 10:01:02',NULL,'Regular'),(172,119,'Mitra Kendayakan',10000000,99,'2024-07-31 10:01:02',NULL,'Regular'),(173,120,'Mitra Rajaiang',7700000,100,'2024-07-31 10:01:02',NULL,'Regular'),(174,121,'MItra Suketbaju',6095000,101,'2024-07-31 10:01:02',NULL,'Regular'),(175,122,'MItra Banjar Wangunan',4500000,102,'2024-07-31 10:01:02',NULL,'Regular'),(176,123,'Mitra Rancaipik',10500000,103,'2024-07-31 10:01:02',NULL,'Regular'),(177,123,'Tunggakan',6500000,103,'2024-07-31 10:01:02',NULL,'Regular'),(178,123,'Punishment',650000,103,'2024-07-31 10:01:02',NULL,'Regular'),(179,124,'Mitra Cibereng',2000000,104,'2024-07-31 10:01:02',NULL,'Regular'),(180,124,'Tunggakan',2500000,104,'2024-07-31 10:01:02',NULL,'Regular'),(181,124,'Punishment',250000,104,'2024-07-31 10:01:02',NULL,'Regular'),(182,125,'Mitra Tempel',750000,105,'2024-07-31 10:01:02',NULL,'Regular'),(183,125,'Tunggakan',750000,105,'2024-07-31 10:01:02',NULL,'Regular'),(184,125,'Punishment',75000,105,'2024-07-31 10:01:02',NULL,'Regular'),(186,127,'MItra Mundak Jaya',1000000,107,'2024-07-31 10:01:02',NULL,'Regular'),(187,128,'Mikrotik Ibad',0,114,'2024-07-31 10:01:02',NULL,'Regular'),(188,128,'Tunggakan',0,114,'2024-07-31 10:01:02',NULL,'Regular'),(189,128,'Punishment',0,114,'2024-07-31 10:01:02',NULL,'Regular'),(203,135,'Pembayaran Internet Dedicated CDN ',9300000,120,'2024-07-31 21:10:53',NULL,'Regular'),(204,136,'Terisi',10300000,121,'2024-08-06 19:34:13',NULL,'Regular'),(206,138,'Mitra Cibereng Blok 2',20000000,97,'2024-08-17 18:32:29',NULL,'Regular'),(207,139,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-08-17 18:32:29',NULL,'Regular'),(208,140,'Pembayaran Internet Dedicated CDN ',5250000,0,'2024-08-29 09:05:21',NULL,'Regular'),(209,141,'Pembayaran Internet Dedicated CDN ',5250000,0,'2024-08-29 09:17:58',NULL,'Regular'),(210,142,'Pembayaran Internet Dedicated CDN ',5250000,0,'2024-08-29 09:30:53',NULL,'Regular'),(211,143,'Sodikin',0,86,'2024-08-31 10:01:02',NULL,'Regular'),(212,144,'MItra Rachmat',0,87,'2024-08-31 10:01:02',NULL,'Regular'),(213,144,'Tunggakan',0,87,'2024-08-31 10:01:02',NULL,'Regular'),(214,144,'Punishment',0,87,'2024-08-31 10:01:02',NULL,'Regular'),(215,145,'Cirebon Kota',1,88,'2024-08-31 10:01:02',NULL,'Regular'),(216,145,'Tunggakan',3,88,'2024-08-31 10:01:02',NULL,'Regular'),(217,145,'Punishment',0,88,'2024-08-31 10:01:02',NULL,'Regular'),(218,146,'Cipto Cirebon Kota',5800000,89,'2024-08-31 10:01:02',NULL,'Regular'),(219,147,'Mitra Kedokan Gabus',13000000,96,'2024-08-31 10:01:02',NULL,'Regular'),(220,148,'Mitra Cibereng Blok 2',20000000,97,'2024-08-31 10:01:02',NULL,'Regular'),(221,149,'Mitra Rancaipik',5000000,98,'2024-08-31 10:01:02',NULL,'Regular'),(222,150,'Mitra Kendayakan',10000000,99,'2024-08-31 10:01:02',NULL,'Regular'),(223,151,'Mitra Rajaiang',7700000,100,'2024-08-31 10:01:02',NULL,'Regular'),(224,152,'MItra Suketbaju',6095000,101,'2024-08-31 10:01:02',NULL,'Regular'),(225,152,'Tunggakan',6095000,101,'2024-08-31 10:01:02',NULL,'Regular'),(226,152,'Punishment',6095000,101,'2024-08-31 10:01:02',NULL,'Regular'),(227,153,'MItra Banjar Wangunan',4500000,102,'2024-08-31 10:01:02',NULL,'Regular'),(228,154,'Mitra Rancaipik',10500000,103,'2024-08-31 10:01:02',NULL,'Regular'),(229,154,'Tunggakan',17650000,103,'2024-08-31 10:01:02',NULL,'Regular'),(230,154,'Punishment',1765000,103,'2024-08-31 10:01:02',NULL,'Regular'),(231,155,'Mitra Cibereng',2000000,104,'2024-08-31 10:01:02',NULL,'Regular'),(232,156,'Mitra Tempel',750000,105,'2024-08-31 10:01:02',NULL,'Regular'),(233,157,'MItra Mundak Jaya',1000000,107,'2024-08-31 10:01:02',NULL,'Regular'),(234,158,'Mikrotik Ibad',0,114,'2024-08-31 10:01:02',NULL,'Regular'),(235,158,'Tunggakan',0,114,'2024-08-31 10:01:02',NULL,'Regular'),(236,158,'Punishment',0,114,'2024-08-31 10:01:02',NULL,'Regular'),(237,159,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-08-31 10:01:02',NULL,'Regular'),(238,159,'Tunggakan',27500000,118,'2024-08-31 10:01:02',NULL,'Regular'),(239,159,'Punishment',27500000,118,'2024-08-31 10:01:02',NULL,'Regular'),(240,160,'Pembayaran Internet Dedicated CDN ',9300000,120,'2024-08-31 10:01:02',NULL,'Regular'),(241,161,'Pembayaran Internet Dedicated CDN ',1610400,122,'2024-08-31 10:01:02',NULL,'Regular'),(245,163,'MItra Rachmat',0,87,'2024-09-30 10:01:03',NULL,'Regular'),(246,163,'Tunggakan',0,87,'2024-09-30 10:01:03',NULL,'Regular'),(247,163,'Punishment',0,87,'2024-09-30 10:01:03',NULL,'Regular'),(248,164,'Cirebon Kota',1,88,'2024-09-30 10:01:03',NULL,'Regular'),(249,164,'Tunggakan',4,88,'2024-09-30 10:01:03',NULL,'Regular'),(250,164,'Punishment',0,88,'2024-09-30 10:01:03',NULL,'Regular'),(251,165,'Cipto Cirebon Kota',5800000,89,'2024-09-30 10:01:03',NULL,'Regular'),(252,166,'Mitra Kedokan Gabus',13000000,96,'2024-09-30 10:01:03',NULL,'Regular'),(253,167,'Mitra Cibereng Blok 2',20000000,97,'2024-09-30 10:01:03',NULL,'Regular'),(254,168,'Mitra Rancaipik',5000000,98,'2024-09-30 10:01:03',NULL,'Regular'),(255,169,'Mitra Kendayakan',10000000,99,'2024-09-30 10:01:03',NULL,'Regular'),(256,170,'Mitra Rajaiang',7700000,100,'2024-09-30 10:01:03',NULL,'Regular'),(257,171,'MItra Suketbaju',6095000,101,'2024-09-30 10:01:03',NULL,'Regular'),(258,172,'MItra Banjar Wangunan',4500000,102,'2024-09-30 10:01:03',NULL,'Regular'),(259,172,'Tunggakan',4500000,102,'2024-09-30 10:01:03',NULL,'Regular'),(260,172,'Punishment',4500000,102,'2024-09-30 10:01:03',NULL,'Regular'),(264,174,'Mitra Cibereng',2000000,104,'2024-09-30 10:01:03',NULL,'Regular'),(265,174,'Tunggakan',2500000,104,'2024-09-30 10:01:03',NULL,'Regular'),(266,174,'Punishment',250000,104,'2024-09-30 10:01:03',NULL,'Regular'),(267,175,'Mitra Tempel',750000,105,'2024-09-30 10:01:03',NULL,'Regular'),(268,176,'MItra Mundak Jaya',1000000,107,'2024-09-30 10:01:03',NULL,'Regular'),(269,177,'Mikrotik Ibad',0,114,'2024-09-30 10:01:03',NULL,'Regular'),(270,177,'Tunggakan',0,114,'2024-09-30 10:01:03',NULL,'Regular'),(271,177,'Punishment',0,114,'2024-09-30 10:01:03',NULL,'Regular'),(272,178,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-09-30 10:01:03',NULL,'Regular'),(273,179,'Pembayaran Internet Dedicated CDN ',9300000,120,'2024-09-30 10:01:03',NULL,'Regular'),(274,180,'Pembayaran Internet Dedicated CDN ',1610400,122,'2024-09-30 10:01:03',NULL,'Regular'),(275,181,'MItra Rachmat',0,87,'2024-10-31 10:01:03',NULL,'Regular'),(276,181,'Tunggakan',0,87,'2024-10-31 10:01:03',NULL,'Regular'),(277,181,'Punishment',0,87,'2024-10-31 10:01:03',NULL,'Regular'),(278,182,'Cirebon Kota',1,88,'2024-10-31 10:01:03',NULL,'Regular'),(279,182,'Tunggakan',5,88,'2024-10-31 10:01:03',NULL,'Regular'),(280,182,'Punishment',1,88,'2024-10-31 10:01:03',NULL,'Regular'),(281,183,'Cipto Cirebon Kota',5800000,89,'2024-10-31 10:01:03',NULL,'Regular'),(282,184,'Mitra Kedokan Gabus',13000000,96,'2024-10-31 10:01:03',NULL,'Regular'),(283,185,'Mitra Cibereng Blok 2',20000000,97,'2024-10-31 10:01:03',NULL,'Regular'),(284,186,'Mitra Rancaipik',5000000,98,'2024-10-31 10:01:03',NULL,'Regular'),(285,187,'Mitra Kendayakan',10000000,99,'2024-10-31 10:01:03',NULL,'Regular'),(286,188,'Mitra Rajaiang',7700000,100,'2024-10-31 10:01:03',NULL,'Regular'),(287,189,'MItra Suketbaju',6095000,101,'2024-10-31 10:01:03',NULL,'Regular'),(288,190,'MItra Banjar Wangunan',4500000,102,'2024-10-31 10:01:03',NULL,'Regular'),(289,190,'Tunggakan',4500000,102,'2024-10-31 10:01:03',NULL,'Regular'),(290,190,'Punishment',4500000,102,'2024-10-31 10:01:03',NULL,'Regular'),(291,191,'Mitra Cibereng',2500000,104,'2024-10-31 10:01:03',NULL,'Regular'),(292,192,'Mitra Tempel',750000,105,'2024-10-31 10:01:03',NULL,'Regular'),(293,193,'MItra Mundak Jaya',1000000,107,'2024-10-31 10:01:03',NULL,'Regular'),(294,194,'Mikrotik Ibad',0,114,'2024-10-31 10:01:03',NULL,'Regular'),(295,194,'Tunggakan',0,114,'2024-10-31 10:01:03',NULL,'Regular'),(296,194,'Punishment',0,114,'2024-10-31 10:01:03',NULL,'Regular'),(297,195,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-10-31 10:01:03',NULL,'Regular'),(298,195,'Tunggakan',27500000,118,'2024-10-31 10:01:03',NULL,'Regular'),(299,195,'Punishment',27500000,118,'2024-10-31 10:01:03',NULL,'Regular'),(300,196,'Pembayaran Internet Dedicated CDN ',9300000,120,'2024-10-31 10:01:03',NULL,'Regular'),(301,197,'Pembayaran Internet Dedicated CDN ',1610400,122,'2024-10-31 10:01:03',NULL,'Regular'),(302,198,'dedicated 50mb',1700000,0,'2024-11-05 06:50:49',NULL,'Regular'),(303,199,'Ciperna',1500000,0,'2024-11-20 00:53:20',NULL,'Regular'),(304,200,'Temiyang',25000000,0,'2024-11-21 07:11:00',NULL,'Regular'),(305,201,'Ciperna',3750000,126,'2024-11-23 08:34:06',NULL,'Regular'),(306,202,'MItra Rachmat',0,87,'2024-11-30 10:01:03',NULL,'Regular'),(307,202,'Tunggakan',0,87,'2024-11-30 10:01:03',NULL,'Regular'),(308,202,'Punishment',0,87,'2024-11-30 10:01:03',NULL,'Regular'),(309,203,'Cirebon Kota',1,88,'2024-11-30 10:01:03',NULL,'Regular'),(310,203,'Tunggakan',7,88,'2024-11-30 10:01:03',NULL,'Regular'),(311,203,'Punishment',1,88,'2024-11-30 10:01:03',NULL,'Regular'),(312,204,'Cipto Cirebon Kota',5800000,89,'2024-11-30 10:01:03',NULL,'Regular'),(313,205,'Mitra Kedokan Gabus',13000000,96,'2024-11-30 10:01:03',NULL,'Regular'),(314,206,'Mitra Cibereng Blok 2',20000000,97,'2024-11-30 10:01:03',NULL,'Regular'),(315,207,'Mitra Rancaipik',5000000,98,'2024-11-30 10:01:03',NULL,'Regular'),(316,208,'Mitra Kendayakan',10000000,99,'2024-11-30 10:01:03',NULL,'Regular'),(317,209,'Mitra Rajaiang',7700000,100,'2024-11-30 10:01:03',NULL,'Regular'),(318,210,'MItra Suketbaju',6095000,101,'2024-11-30 10:01:03',NULL,'Regular'),(319,211,'MItra Banjar Wangunan',4500000,102,'2024-11-30 10:01:03',NULL,'Regular'),(320,212,'Mitra Cibereng',2500000,104,'2024-11-30 10:01:03',NULL,'Regular'),(321,213,'Mitra Tempel',750000,105,'2024-11-30 10:01:03',NULL,'Regular'),(322,214,'MItra Mundak Jaya',1000000,107,'2024-11-30 10:01:03',NULL,'Regular'),(323,215,'Mikrotik Ibad',0,114,'2024-11-30 10:01:03',NULL,'Regular'),(324,215,'Tunggakan',0,114,'2024-11-30 10:01:03',NULL,'Regular'),(325,215,'Punishment',0,114,'2024-11-30 10:01:03',NULL,'Regular'),(326,216,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-11-30 10:01:03',NULL,'Regular'),(327,216,'Tunggakan',27500000,118,'2024-11-30 10:01:03',NULL,'Regular'),(328,216,'Punishment',27500000,118,'2024-11-30 10:01:03',NULL,'Regular'),(329,217,'Pembayaran Internet Dedicated CDN ',9300000,120,'2024-11-30 10:01:03',NULL,'Regular'),(330,218,'Pembayaran Internet Dedicated CDN ',1610400,122,'2024-11-30 10:01:03',NULL,'Regular'),(331,219,'dedicated 50mb',3500000,125,'2024-11-30 10:01:03',NULL,'Regular'),(332,220,'Ciperna',3750000,126,'2024-11-30 10:01:03',NULL,'Regular'),(333,221,'Mitra Candra',0,0,'2024-12-13 17:46:00',NULL,'Regular'),(334,222,'Mitra Candra',0,131,'2024-12-24 22:51:18',NULL,'Regular'),(335,223,'POP Ranjeng',1750000,0,'2024-12-25 04:16:13',NULL,'Regular'),(336,224,'MItra Rachmat',0,87,'2024-12-31 10:01:04',NULL,'Regular'),(337,224,'Tunggakan',0,87,'2024-12-31 10:01:04',NULL,'Regular'),(338,224,'Punishment',0,87,'2024-12-31 10:01:04',NULL,'Regular'),(339,225,'Cirebon Kota',1,88,'2024-12-31 10:01:04',NULL,'Regular'),(340,225,'Tunggakan',9,88,'2024-12-31 10:01:04',NULL,'Regular'),(341,225,'Punishment',1,88,'2024-12-31 10:01:04',NULL,'Regular'),(342,226,'Cipto Cirebon Kota',5800000,89,'2024-12-31 10:01:04',NULL,'Regular'),(343,227,'Mitra Kedokan Gabus',13000000,96,'2024-12-31 10:01:04',NULL,'Regular'),(344,228,'Mitra Cibereng Blok 2',20000000,97,'2024-12-31 10:01:04',NULL,'Regular'),(345,229,'Mitra Rancaipik',5000000,98,'2024-12-31 10:01:04',NULL,'Regular'),(346,230,'Mitra Kendayakan',10000000,99,'2024-12-31 10:01:04',NULL,'Regular'),(347,231,'Mitra Rajaiang',7700000,100,'2024-12-31 10:01:04',NULL,'Regular'),(348,232,'MItra Suketbaju',6095000,101,'2024-12-31 10:01:04',NULL,'Regular'),(349,233,'MItra Banjar Wangunan',4500000,102,'2024-12-31 10:01:04',NULL,'Regular'),(350,234,'Mitra Cibereng',2500000,104,'2024-12-31 10:01:04',NULL,'Regular'),(351,235,'Mitra Tempel',750000,105,'2024-12-31 10:01:04',NULL,'Regular'),(352,236,'MItra Mundak Jaya',1000000,107,'2024-12-31 10:01:04',NULL,'Regular'),(353,237,'Mikrotik Ibad',0,114,'2024-12-31 10:01:04',NULL,'Regular'),(354,237,'Tunggakan',0,114,'2024-12-31 10:01:04',NULL,'Regular'),(355,237,'Punishment',0,114,'2024-12-31 10:01:04',NULL,'Regular'),(356,238,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2024-12-31 10:01:04',NULL,'Regular'),(357,238,'Tunggakan',27500000,118,'2024-12-31 10:01:04',NULL,'Regular'),(358,238,'Punishment',27500000,118,'2024-12-31 10:01:04',NULL,'Regular'),(359,239,'Pembayaran Internet Dedicated CDN ',9300000,120,'2024-12-31 10:01:04',NULL,'Regular'),(360,240,'Pembayaran Internet Dedicated CDN ',1610400,122,'2024-12-31 10:01:04',NULL,'Regular'),(361,241,'dedicated 50mb',3500000,125,'2024-12-31 10:01:04',NULL,'Regular'),(362,242,'Ciperna',3750000,126,'2024-12-31 10:01:04',NULL,'Regular'),(363,242,'Tunggakan',3750000,126,'2024-12-31 10:01:04',NULL,'Regular'),(364,242,'Punishment',3750000,126,'2024-12-31 10:01:04',NULL,'Regular'),(365,243,'POP Ranjeng',1750000,138,'2024-12-31 10:01:04',NULL,'Regular'),(366,244,'Mitra Santing',0,0,'2025-01-11 20:34:43',NULL,'Regular'),(367,245,'MItra Rachmat',0,87,'2025-01-31 15:29:44',NULL,'Regular'),(368,245,'Tunggakan',0,87,'2025-01-31 15:29:44',NULL,'Regular'),(369,245,'Punishment',0,87,'2025-01-31 15:29:44',NULL,'Regular'),(370,246,'Cirebon Kota',1,88,'2025-01-31 15:29:44',NULL,'Regular'),(371,246,'Tunggakan',11,88,'2025-01-31 15:29:44',NULL,'Regular'),(372,246,'Punishment',1,88,'2025-01-31 15:29:44',NULL,'Regular'),(373,247,'Cipto Cirebon Kota',5800000,89,'2025-01-31 15:29:44',NULL,'Regular'),(374,248,'Mitra Kedokan Gabus',13000000,96,'2025-01-31 15:29:45',NULL,'Regular'),(375,249,'Mitra Cibereng Blok 2',20000000,97,'2025-01-31 15:29:45',NULL,'Regular'),(376,250,'Mitra Rancaipik',5000000,98,'2025-01-31 15:29:45',NULL,'Regular'),(377,251,'Mitra Kendayakan',10000000,99,'2025-01-31 15:29:45',NULL,'Regular'),(378,252,'Mitra Rajaiyang',7700000,100,'2025-01-31 15:29:45',NULL,'Regular'),(379,253,'MItra Suketbaju',6095000,101,'2025-01-31 15:29:45',NULL,'Regular'),(380,254,'MItra Banjar Wangunan',4500000,102,'2025-01-31 15:29:45',NULL,'Regular'),(381,254,'Tunggakan',4500000,102,'2025-01-31 15:29:45',NULL,'Regular'),(382,254,'Punishment',4500000,102,'2025-01-31 15:29:45',NULL,'Regular'),(383,255,'Mitra Cibereng',2500000,104,'2025-01-31 15:29:45',NULL,'Regular'),(384,256,'Mitra Tempel',750000,105,'2025-01-31 15:29:45',NULL,'Regular'),(385,257,'MItra Mundak Jaya',1000000,107,'2025-01-31 15:29:45',NULL,'Regular'),(386,258,'Mikrotik Ibad',0,114,'2025-01-31 15:29:45',NULL,'Regular'),(387,258,'Tunggakan',0,114,'2025-01-31 15:29:45',NULL,'Regular'),(388,258,'Punishment',0,114,'2025-01-31 15:29:45',NULL,'Regular'),(389,259,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2025-01-31 15:29:45',NULL,'Regular'),(390,259,'Tunggakan',27500000,118,'2025-01-31 15:29:45',NULL,'Regular'),(391,259,'Punishment',27500000,118,'2025-01-31 15:29:45',NULL,'Regular'),(392,260,'Pembayaran Internet Dedicated CDN ',9300000,120,'2025-01-31 15:29:45',NULL,'Regular'),(393,261,'Pembayaran Internet Dedicated CDN ',1610400,122,'2025-01-31 15:29:45',NULL,'Regular'),(394,262,'dedicated 50mb',3500000,125,'2025-01-31 15:29:45',NULL,'Regular'),(395,263,'Ciperna',3750000,126,'2025-01-31 15:29:45',NULL,'Regular'),(396,263,'Tunggakan',3750000,126,'2025-01-31 15:29:45',NULL,'Regular'),(397,263,'Punishment',3750000,126,'2025-01-31 15:29:45',NULL,'Regular'),(398,264,'POP Ranjeng',1750000,138,'2025-01-31 15:29:45',NULL,'Regular'),(399,265,'Mitra Santing',0,141,'2025-01-31 15:29:45',NULL,'Regular'),(400,266,'Pembayaran Internet Dedicated CDN ',3500000,0,'2025-01-31 21:03:25',NULL,'Regular'),(401,267,'Pembayaran Internet Dedicated CDN ',3500000,144,'2025-01-31 21:04:33',NULL,'Regular'),(402,268,'MItra Rachmat',0,87,'2025-02-28 12:32:25',NULL,'Regular'),(403,268,'Tunggakan',0,87,'2025-02-28 12:32:25',NULL,'Regular'),(404,268,'Punishment',0,87,'2025-02-28 12:32:25',NULL,'Regular'),(405,269,'Cirebon Kota',1,88,'2025-02-28 12:32:25',NULL,'Regular'),(406,269,'Tunggakan',13,88,'2025-02-28 12:32:25',NULL,'Regular'),(407,269,'Punishment',1,88,'2025-02-28 12:32:25',NULL,'Regular'),(408,270,'Cipto Cirebon Kota',5800000,89,'2025-02-28 12:32:25',NULL,'Regular'),(409,271,'Mitra Kedokan Gabus',13000000,96,'2025-02-28 12:32:25',NULL,'Regular'),(410,271,'Tunggakan',13000000,96,'2025-02-28 12:32:25',NULL,'Regular'),(411,271,'Punishment',13000000,96,'2025-02-28 12:32:25',NULL,'Regular'),(412,272,'Mitra Cibereng Blok 2',20000000,97,'2025-02-28 12:32:25',NULL,'Regular'),(413,273,'Mitra Rancaipik',5000000,98,'2025-02-28 12:32:25',NULL,'Regular'),(414,274,'Mitra Kendayakan',10000000,99,'2025-02-28 12:32:25',NULL,'Regular'),(415,275,'Mitra Rajaiyang',7700000,100,'2025-02-28 12:32:25',NULL,'Regular'),(416,276,'MItra Suketbaju',6095000,101,'2025-02-28 12:32:25',NULL,'Regular'),(417,277,'MItra Banjar Wangunan',4500000,102,'2025-02-28 12:32:25',NULL,'Regular'),(418,278,'Mitra Cibereng',2500000,104,'2025-02-28 12:32:25',NULL,'Regular'),(419,279,'Mitra Tempel',750000,105,'2025-02-28 12:32:25',NULL,'Regular'),(420,280,'MItra Mundak Jaya',1000000,107,'2025-02-28 12:32:25',NULL,'Regular'),(421,281,'Mikrotik Ibad',0,114,'2025-02-28 12:32:25',NULL,'Regular'),(422,281,'Tunggakan',0,114,'2025-02-28 12:32:25',NULL,'Regular'),(423,281,'Punishment',0,114,'2025-02-28 12:32:25',NULL,'Regular'),(424,282,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2025-02-28 12:32:25',NULL,'Regular'),(425,282,'Tunggakan',27500000,118,'2025-02-28 12:32:25',NULL,'Regular'),(426,282,'Punishment',27500000,118,'2025-02-28 12:32:25',NULL,'Regular'),(427,283,'Pembayaran Internet Dedicated CDN ',9300000,120,'2025-02-28 12:32:25',NULL,'Regular'),(428,284,'Pembayaran Internet Dedicated CDN ',1610400,122,'2025-02-28 12:32:25',NULL,'Regular'),(429,285,'pembayaran internet dedicated 75mb',3500000,125,'2025-02-28 12:32:25',NULL,'Regular'),(430,286,'Ciperna',3750000,126,'2025-02-28 12:32:25',NULL,'Regular'),(431,286,'Tunggakan',3750000,126,'2025-02-28 12:32:25',NULL,'Regular'),(432,286,'Punishment',3750000,126,'2025-02-28 12:32:25',NULL,'Regular'),(433,287,'POP Ranjeng',1750000,138,'2025-02-28 12:32:25',NULL,'Regular'),(434,287,'Tunggakan',1750000,138,'2025-02-28 12:32:25',NULL,'Regular'),(435,287,'Punishment',175000,138,'2025-02-28 12:32:25',NULL,'Regular'),(436,288,'Pembayaran Internet Dedicated CDN ',3500000,144,'2025-02-28 12:32:25',NULL,'Regular'),(437,289,'MItra Rachmat',0,87,'2025-03-31 17:31:32',NULL,'Regular'),(438,289,'Tunggakan',0,87,'2025-03-31 17:31:32',NULL,'Regular'),(439,289,'Punishment',0,87,'2025-03-31 17:31:32',NULL,'Regular'),(440,290,'Cirebon Kota',1,88,'2025-03-31 17:31:32',NULL,'Regular'),(441,290,'Tunggakan',15,88,'2025-03-31 17:31:32',NULL,'Regular'),(442,290,'Punishment',2,88,'2025-03-31 17:31:32',NULL,'Regular'),(443,291,'Cipto Cirebon Kota',5800000,89,'2025-03-31 17:31:32',NULL,'Regular'),(444,292,'Mitra Kedokan Gabus',13000000,96,'2025-03-31 17:31:32',NULL,'Regular'),(445,293,'Mitra Cibereng Blok 2',20000000,97,'2025-03-31 17:31:32',NULL,'Regular'),(446,294,'Mitra Rancaipik',5000000,98,'2025-03-31 17:31:32',NULL,'Regular'),(447,295,'Mitra Kendayakan',10000000,99,'2025-03-31 17:31:32',NULL,'Regular'),(448,296,'Mitra Rajaiyang',7700000,100,'2025-03-31 17:31:32',NULL,'Regular'),(449,297,'MItra Suketbaju',6095000,101,'2025-03-31 17:31:32',NULL,'Regular'),(450,298,'MItra Banjar Wangunan',4500000,102,'2025-03-31 17:31:32',NULL,'Regular'),(451,299,'Mitra Cibereng',2500000,104,'2025-03-31 17:31:32',NULL,'Regular'),(452,300,'Mitra Tempel',750000,105,'2025-03-31 17:31:32',NULL,'Regular'),(453,301,'MItra Mundak Jaya',1000000,107,'2025-03-31 17:31:32',NULL,'Regular'),(454,301,'Tunggakan',1000000,107,'2025-03-31 17:31:32',NULL,'Regular'),(455,301,'Punishment',100000,107,'2025-03-31 17:31:32',NULL,'Regular'),(456,302,'Mikrotik Ibad',0,114,'2025-03-31 17:31:32',NULL,'Regular'),(457,302,'Tunggakan',0,114,'2025-03-31 17:31:32',NULL,'Regular'),(458,302,'Punishment',0,114,'2025-03-31 17:31:32',NULL,'Regular'),(459,303,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2025-03-31 17:31:32',NULL,'Regular'),(460,303,'Tunggakan',27500000,118,'2025-03-31 17:31:32',NULL,'Regular'),(461,303,'Punishment',27500000,118,'2025-03-31 17:31:32',NULL,'Regular'),(462,304,'Pembayaran Internet Dedicated CDN ',9300000,120,'2025-03-31 17:31:32',NULL,'Regular'),(463,305,'Pembayaran Internet Dedicated CDN ',1610400,122,'2025-03-31 17:31:32',NULL,'Regular'),(464,306,'pembayaran internet dedicated 75mb',3500000,125,'2025-03-31 17:31:32',NULL,'Regular'),(465,307,'Ciperna',3750000,126,'2025-03-31 17:31:32',NULL,'Regular'),(466,307,'Tunggakan',3750000,126,'2025-03-31 17:31:32',NULL,'Regular'),(467,307,'Punishment',3750000,126,'2025-03-31 17:31:32',NULL,'Regular'),(468,308,'POP Ranjeng',1750000,138,'2025-03-31 17:31:32',NULL,'Regular'),(469,308,'Tunggakan',3675000,138,'2025-03-31 17:31:32',NULL,'Regular'),(470,308,'Punishment',367500,138,'2025-03-31 17:31:32',NULL,'Regular'),(471,309,'Pembayaran Internet Dedicated CDN ',3500000,144,'2025-03-31 17:31:32',NULL,'Regular'),(472,309,'Tunggakan',3500000,144,'2025-03-31 17:31:32',NULL,'Regular'),(473,309,'Punishment',350000,144,'2025-03-31 17:31:32',NULL,'Regular'),(474,310,'Pembayaran Internet Dedicated CDN',3500000,0,'2025-04-03 07:26:54',NULL,'Regular'),(475,311,'Pembayaran Internet Dedicated CDN',3500000,146,'2025-04-03 07:27:18',NULL,'Regular'),(476,312,'Pembayaran Internet 50mbps Dedicated CDN ',1500000,0,'2025-04-29 21:15:12',NULL,'Regular'),(477,313,'MItra Rachmat',0,87,'2025-04-30 13:54:05',NULL,'Regular'),(478,313,'Tunggakan',0,87,'2025-04-30 13:54:05',NULL,'Regular'),(479,313,'Punishment',0,87,'2025-04-30 13:54:05',NULL,'Regular'),(480,314,'Cirebon Kota',1,88,'2025-04-30 13:54:05',NULL,'Regular'),(481,314,'Tunggakan',18,88,'2025-04-30 13:54:05',NULL,'Regular'),(482,314,'Punishment',2,88,'2025-04-30 13:54:05',NULL,'Regular'),(483,315,'Bang Kaji Cipto  Argasunya Cirebon Kota',5800000,89,'2025-04-30 13:54:05',NULL,'Regular'),(484,316,'Mitra Kedokan Gabus',13000000,96,'2025-04-30 13:54:05',NULL,'Regular'),(485,317,'Mitra Cibereng Blok 2',20000000,97,'2025-04-30 13:54:05',NULL,'Regular'),(486,318,'Mitra Rancaipik',5000000,98,'2025-04-30 13:54:05',NULL,'Regular'),(487,319,'Pembayaran wifi dedicated CDN ',10000000,99,'2025-04-30 13:54:05',NULL,'Regular'),(488,320,'Mitra Rajaiyang',7700000,100,'2025-04-30 13:54:05',NULL,'Regular'),(489,321,'MItra Suketbaju',6095000,101,'2025-04-30 13:54:05',NULL,'Regular'),(490,322,'MItra Banjar Wangunan',4500000,102,'2025-04-30 13:54:05',NULL,'Regular'),(491,323,'Mitra Cibereng',2500000,104,'2025-04-30 13:54:05',NULL,'Regular'),(492,324,'Mitra Tempel',750000,105,'2025-04-30 13:54:05',NULL,'Regular'),(493,325,'Pembayaran Internet Dedicated ',1000000,107,'2025-04-30 13:54:05',NULL,'Regular'),(494,325,'Tunggakan',1000000,107,'2025-04-30 13:54:05',NULL,'Regular'),(495,325,'Punishment',100000,107,'2025-04-30 13:54:05',NULL,'Regular'),(496,326,'Mikrotik Ibad',0,114,'2025-04-30 13:54:05',NULL,'Regular'),(497,326,'Tunggakan',0,114,'2025-04-30 13:54:05',NULL,'Regular'),(498,326,'Punishment',0,114,'2025-04-30 13:54:05',NULL,'Regular'),(499,327,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2025-04-30 13:54:05',NULL,'Regular'),(500,327,'Tunggakan',27500000,118,'2025-04-30 13:54:05',NULL,'Regular'),(501,327,'Punishment',27500000,118,'2025-04-30 13:54:05',NULL,'Regular'),(502,328,'Pembayaran Internet Dedicated CDN ',9300000,120,'2025-04-30 13:54:05',NULL,'Regular'),(503,329,'Pembayaran Internet Dedicated CDN ',1610400,122,'2025-04-30 13:54:05',NULL,'Regular'),(504,330,'pembayaran internet dedicated 75mb',3500000,125,'2025-04-30 13:54:05',NULL,'Regular'),(505,331,'Ciperna',3750000,126,'2025-04-30 13:54:05',NULL,'Regular'),(506,331,'Tunggakan',3750000,126,'2025-04-30 13:54:05',NULL,'Regular'),(507,331,'Punishment',3750000,126,'2025-04-30 13:54:05',NULL,'Regular'),(508,332,'POP Ranjeng',1750000,138,'2025-04-30 13:54:05',NULL,'Regular'),(509,332,'Tunggakan',4042500,138,'2025-04-30 13:54:05',NULL,'Regular'),(510,332,'Punishment',404250,138,'2025-04-30 13:54:05',NULL,'Regular'),(511,333,'Pembayaran Internet Dedicated CDN ',3500000,144,'2025-04-30 13:54:05',NULL,'Regular'),(512,333,'Tunggakan',7350000,144,'2025-04-30 13:54:05',NULL,'Regular'),(513,333,'Punishment',735000,144,'2025-04-30 13:54:05',NULL,'Regular'),(514,334,'Pembayaran Internet Dedicated CDN',3500000,146,'2025-04-30 13:54:05',NULL,'Regular'),(515,335,'Pembayaran Internet 50mbps Dedicated CDN ',1500000,147,'2025-04-30 13:54:05',NULL,'Regular'),(516,336,'MItra Rachmat',0,87,'2026-04-13 15:39:15',NULL,'Regular'),(517,337,'Cirebon Kota',1,88,'2026-04-13 15:39:15',NULL,'Regular'),(518,338,'Bang Kaji Cipto  Argasunya Cirebon Kota',5800000,89,'2026-04-13 15:39:15',NULL,'Regular'),(519,339,'Mitra Kedokan Gabus',13000000,96,'2026-04-13 15:39:15',NULL,'Regular'),(520,340,'Mitra Cibereng Blok 2',20000000,97,'2026-04-13 15:39:15',NULL,'Regular'),(521,341,'Mitra Rancaipik Kedokangabus',5000000,98,'2026-04-13 15:39:15',NULL,'Regular'),(522,342,'Pembayaran wifi dedicated CDN ',10000000,99,'2026-04-13 15:39:15',NULL,'Regular'),(523,343,'Mitra Rajaiyang',7700000,100,'2026-04-13 15:39:15',NULL,'Regular'),(524,344,'Mitra Suketbaju - Plosokerep - Trisi',6095000,101,'2026-04-13 15:39:15',NULL,'Regular'),(525,345,'Pembayaran Internet Dedicated CDN',4500000,102,'2026-04-13 15:39:15',NULL,'Regular'),(526,346,'Mitra Cibereng',2500000,104,'2026-04-13 15:39:15',NULL,'Regular'),(527,347,'Mitra Tempel Cikedung',750000,105,'2026-04-13 15:39:15',NULL,'Regular'),(528,348,'Pembayaran Internet Dedicated ',1000000,107,'2026-04-13 15:39:15',NULL,'Regular'),(529,349,'Mikrotik Ibad',0,114,'2026-04-13 15:39:15',NULL,'Regular'),(530,350,'Paket Intermet Dedicated CDN 1.000mbps',27500000,118,'2026-04-13 15:39:15',NULL,'Regular'),(531,351,'Pembayaran Internet Dedicated CDN ',9300000,120,'2026-04-13 15:39:15',NULL,'Regular'),(532,352,'Pembayaran Internet Dedicated CDN ',1610400,122,'2026-04-13 15:39:15',NULL,'Regular'),(533,353,'pembayaran internet dedicated 75mb',3500000,125,'2026-04-13 15:39:15',NULL,'Regular'),(534,354,'Pembayaran Internet Dedicated CDN',3750000,126,'2026-04-13 15:39:15',NULL,'Regular'),(535,355,'POP Ranjeng',1750000,138,'2026-04-13 15:39:15',NULL,'Regular'),(536,356,'Pembayaran Internet Dedicated CDN ',3500000,144,'2026-04-13 15:39:15',NULL,'Regular'),(537,357,'Pembayaran Internet Dedicated CDN',3500000,146,'2026-04-13 15:39:15',NULL,'Regular'),(538,358,'Pembayaran Internet 50mbps Dedicated CDN ',1500000,147,'2026-04-13 15:39:15',NULL,'Regular'),(539,359,'Pembayaran Internet Dedicated CDN ',300000,0,'2026-04-14 02:44:01',NULL,'Regular'),(540,360,'Pembayaran Internet 55mbps Dedicated CDN ',2000000,0,'2026-04-14 02:46:18',NULL,'Regular'),(541,361,'Pembayaran Internet Dedicated CDN ',300000,148,'2026-04-14 02:53:06',NULL,'Regular'),(542,362,'Pembayaran Internet 55mbps Dedicated CDN ',2000000,149,'2026-04-14 02:53:14',NULL,'Regular'),(543,363,'Pembayaran Internet Dedicated CDN ',1320000,0,'2026-04-14 13:19:47',NULL,'Regular'),(544,364,'Pembayaran Internet Dedicated CDN ',1320000,150,'2026-04-14 13:20:28',NULL,'Regular'),(545,365,'Sirandu',0,0,'2026-04-30 21:18:46',NULL,'Regular'),(546,366,'Ibad',0,0,'2026-04-30 21:28:21',NULL,'Regular'),(547,367,'MItra Rachmat',0,87,'2026-04-30 21:39:23',NULL,'Regular'),(548,367,'Tunggakan',0,87,'2026-04-30 21:39:23',NULL,'Regular'),(549,367,'Punishment',0,87,'2026-04-30 21:39:23',NULL,'Regular'),(550,368,'Cirebon Kota',1,88,'2026-04-30 21:39:23',NULL,'Regular'),(551,368,'Tunggakan',1,88,'2026-04-30 21:39:23',NULL,'Regular'),(552,368,'Punishment',0,88,'2026-04-30 21:39:23',NULL,'Regular'),(553,369,'Bang Kaji Cipto  Argasunya Cirebon Kota',5800000,89,'2026-04-30 21:39:23',NULL,'Regular'),(554,369,'Tunggakan',5800000,89,'2026-04-30 21:39:23',NULL,'Regular'),(555,369,'Punishment',580000,89,'2026-04-30 21:39:23',NULL,'Regular'),(556,370,'Mitra Kedokan Gabus',13000000,96,'2026-04-30 21:39:23',NULL,'Regular'),(557,371,'Mitra Cibereng Blok 2',20000000,97,'2026-04-30 21:39:23',NULL,'Regular'),(558,372,'Mitra Rancaipik Kedokangabus',5000000,98,'2026-04-30 21:39:23',NULL,'Regular'),(559,373,'Pembayaran wifi dedicated CDN ',10000000,99,'2026-04-30 21:39:23',NULL,'Regular'),(560,374,'Mitra Rajaiyang',7700000,100,'2026-04-30 21:39:23',NULL,'Regular'),(561,375,'Mitra Suketbaju - Plosokerep - Trisi',6095000,101,'2026-04-30 21:39:23',NULL,'Regular'),(562,376,'Pembayaran Internet Dedicated CDN',4500000,102,'2026-04-30 21:39:23',NULL,'Regular'),(563,376,'Tunggakan',4500000,102,'2026-04-30 21:39:23',NULL,'Regular'),(564,376,'Punishment',4500000,102,'2026-04-30 21:39:23',NULL,'Regular'),(565,377,'Paket Intermet Dedicated CDN ',27500000,118,'2026-04-30 21:39:23',NULL,'Regular'),(566,378,'Pembayaran Internet Dedicated CDN ',1610400,122,'2026-04-30 21:39:23',NULL,'Regular'),(567,379,'pembayaran internet dedicated 75mb',3500000,125,'2026-04-30 21:39:23',NULL,'Regular'),(568,380,'Pembayaran Internet Dedicated CDN',3750000,126,'2026-04-30 21:39:23',NULL,'Regular'),(569,380,'Tunggakan',3750000,126,'2026-04-30 21:39:23',NULL,'Regular'),(570,380,'Punishment',3750000,126,'2026-04-30 21:39:24',NULL,'Regular'),(571,381,'Pembayaran Internet 50mbps Dedicated CDN ',1500000,147,'2026-04-30 21:39:24',NULL,'Regular'),(572,382,'Pembayaran Internet Dedicated CDN ',300000,148,'2026-04-30 21:39:24',NULL,'Regular'),(573,383,'Pembayaran Internet 55mbps Dedicated CDN ',2000000,149,'2026-04-30 21:39:24',NULL,'Regular'),(574,384,'Pembayaran Internet Dedicated CDN ',1320000,150,'2026-04-30 21:39:24',NULL,'Regular'),(575,384,'Tunggakan',1320000,150,'2026-04-30 21:39:24',NULL,'Regular'),(576,384,'Punishment',132000,150,'2026-04-30 21:39:24',NULL,'Regular'),(577,385,'Sirandu',0,151,'2026-04-30 21:39:24',NULL,'Regular'),(578,386,'Ibad',0,152,'2026-04-30 21:39:24',NULL,'Regular'),(579,387,'Gabuswetan',0,0,'2026-05-30 10:16:38',NULL,'Regular'),(580,388,'MItra Rachmat',0,87,'2026-05-31 19:54:33',NULL,'Regular'),(581,388,'Tunggakan',0,87,'2026-05-31 19:54:33',NULL,'Regular'),(582,388,'Punishment',0,87,'2026-05-31 19:54:33',NULL,'Regular'),(583,389,'Cirebon Kota',1,88,'2026-05-31 19:54:33',NULL,'Regular'),(584,389,'Tunggakan',2,88,'2026-05-31 19:54:33',NULL,'Regular'),(585,389,'Punishment',0,88,'2026-05-31 19:54:33',NULL,'Regular'),(586,390,'Bang Kaji Cipto  Argasunya Cirebon Kota',5800000,89,'2026-05-31 19:54:33',NULL,'Regular'),(587,390,'Tunggakan',6380000,89,'2026-05-31 19:54:33',NULL,'Regular'),(588,390,'Punishment',638000,89,'2026-05-31 19:54:33',NULL,'Regular'),(589,391,'Mitra Kedokan Gabus',13000000,96,'2026-05-31 19:54:33',NULL,'Regular'),(590,392,'Mitra Cibereng Blok 2',20000000,97,'2026-05-31 19:54:33',NULL,'Regular'),(591,393,'Mitra Rancaipik Kedokangabus',5000000,98,'2026-05-31 19:54:33',NULL,'Regular'),(592,394,'Pembayaran wifi dedicated CDN ',10000000,99,'2026-05-31 19:54:33',NULL,'Regular'),(593,395,'Mitra Rajaiyang',7700000,100,'2026-05-31 19:54:33',NULL,'Regular'),(594,396,'Mitra Suketbaju - Plosokerep - Trisi',6095000,101,'2026-05-31 19:54:33',NULL,'Regular'),(595,397,'Pembayaran Internet Dedicated CDN',4500000,102,'2026-05-31 19:54:33',NULL,'Regular'),(596,397,'Tunggakan',4500000,102,'2026-05-31 19:54:33',NULL,'Regular'),(597,397,'Punishment',4500000,102,'2026-05-31 19:54:33',NULL,'Regular'),(598,398,'Paket Intermet Dedicated CDN ',27500000,118,'2026-05-31 19:54:33',NULL,'Regular'),(599,398,'Tunggakan',3000000,118,'2026-05-31 19:54:33',NULL,'Regular'),(600,398,'Punishment',300000,118,'2026-05-31 19:54:33',NULL,'Regular'),(601,399,'Pembayaran Internet Dedicated CDN ',1610400,122,'2026-05-31 19:54:33',NULL,'Regular'),(602,400,'pembayaran internet dedicated 75mb',3500000,125,'2026-05-31 19:54:33',NULL,'Regular'),(603,401,'Pembayaran Internet Dedicated CDN',3750000,126,'2026-05-31 19:54:33',NULL,'Regular'),(604,401,'Tunggakan',3750000,126,'2026-05-31 19:54:33',NULL,'Regular'),(605,401,'Punishment',3750000,126,'2026-05-31 19:54:33',NULL,'Regular'),(606,402,'Pembayaran Internet 50mbps Dedicated CDN ',1500000,147,'2026-05-31 19:54:33',NULL,'Regular'),(607,403,'Pembayaran Internet Dedicated CDN ',300000,148,'2026-05-31 19:54:33',NULL,'Regular'),(608,404,'Pembayaran Internet 55mbps Dedicated CDN ',2000000,149,'2026-05-31 19:54:33',NULL,'Regular'),(609,405,'Pembayaran Internet Dedicated CDN ',1320000,150,'2026-05-31 19:54:34',NULL,'Regular'),(610,406,'Sirandu',0,151,'2026-05-31 19:54:34',NULL,'Regular'),(611,407,'Ibad',0,152,'2026-05-31 19:54:34',NULL,'Regular'),(612,407,'Tunggakan',0,152,'2026-05-31 19:54:34',NULL,'Regular'),(613,407,'Punishment',0,152,'2026-05-31 19:54:34',NULL,'Regular'),(614,408,'Gabuswetan',0,153,'2026-05-31 19:54:34',NULL,'Regular'),(615,409,'MItra Rachmat',0,87,'2026-06-30 23:08:22',NULL,'Regular'),(616,409,'Tunggakan',0,87,'2026-06-30 23:08:22',NULL,'Regular'),(617,409,'Punishment',0,87,'2026-06-30 23:08:22',NULL,'Regular'),(618,410,'Cirebon Kota',1,88,'2026-06-30 23:08:22',NULL,'Regular'),(619,410,'Tunggakan',3,88,'2026-06-30 23:08:22',NULL,'Regular'),(620,410,'Punishment',0,88,'2026-06-30 23:08:22',NULL,'Regular'),(621,411,'Bang Kaji Cipto  Argasunya Cirebon Kota',5800000,89,'2026-06-30 23:08:22',NULL,'Regular'),(622,411,'Tunggakan',7018000,89,'2026-06-30 23:08:22',NULL,'Regular'),(623,411,'Punishment',701800,89,'2026-06-30 23:08:22',NULL,'Regular'),(624,412,'Mitra Kedokan Gabus',13000000,96,'2026-06-30 23:08:22',NULL,'Regular'),(625,412,'Tunggakan',4000000,96,'2026-06-30 23:08:22',NULL,'Regular'),(626,412,'Punishment',400000,96,'2026-06-30 23:08:22',NULL,'Regular'),(627,413,'Mitra Cibereng Blok 2',20000000,97,'2026-06-30 23:08:22',NULL,'Regular'),(628,414,'Mitra Rancaipik Kedokangabus',5000000,98,'2026-06-30 23:08:22',NULL,'Regular'),(629,415,'Pembayaran wifi dedicated CDN ',10000000,99,'2026-06-30 23:08:22',NULL,'Regular'),(630,416,'Mitra Rajaiyang',7700000,100,'2026-06-30 23:08:22',NULL,'Regular'),(631,417,'Mitra Suketbaju - Plosokerep - Trisi',6095000,101,'2026-06-30 23:08:22',NULL,'Regular'),(632,418,'Pembayaran Internet Dedicated CDN',4500000,102,'2026-06-30 23:08:22',NULL,'Regular'),(633,419,'Paket Intermet Dedicated CDN ',27500000,118,'2026-06-30 23:08:22',NULL,'Regular'),(634,419,'Tunggakan',9600000,118,'2026-06-30 23:08:22',NULL,'Regular'),(635,419,'Punishment',960000,118,'2026-06-30 23:08:22',NULL,'Regular'),(636,420,'Pembayaran Internet Dedicated CDN ',1610400,122,'2026-06-30 23:08:22',NULL,'Regular'),(637,421,'pembayaran internet dedicated 75mb',3500000,125,'2026-06-30 23:08:22',NULL,'Regular'),(638,422,'Pembayaran Internet Dedicated CDN',3750000,126,'2026-06-30 23:08:22',NULL,'Regular'),(639,422,'Tunggakan',4930000,126,'2026-06-30 23:08:22',NULL,'Regular'),(640,422,'Punishment',493000,126,'2026-06-30 23:08:22',NULL,'Regular'),(641,423,'Pembayaran Internet 50mbps Dedicated CDN ',1500000,147,'2026-06-30 23:08:22',NULL,'Regular'),(642,424,'Pembayaran Internet Dedicated CDN ',300000,148,'2026-06-30 23:08:22',NULL,'Regular'),(643,425,'Pembayaran Internet 55mbps Dedicated CDN ',2000000,149,'2026-06-30 23:08:22',NULL,'Regular'),(644,426,'Pembayaran Internet Dedicated CDN ',1320000,150,'2026-06-30 23:08:22',NULL,'Regular'),(645,426,'Tunggakan',1320000,150,'2026-06-30 23:08:22',NULL,'Regular'),(646,426,'Punishment',132000,150,'2026-06-30 23:08:22',NULL,'Regular'),(647,427,'Sirandu',0,151,'2026-06-30 23:08:22',NULL,'Regular'),(648,428,'Ibad',0,152,'2026-06-30 23:08:23',NULL,'Regular'),(649,428,'Tunggakan',0,152,'2026-06-30 23:08:23',NULL,'Regular'),(650,428,'Punishment',0,152,'2026-06-30 23:08:23',NULL,'Regular'),(651,429,'Gabuswetan',0,153,'2026-06-30 23:08:23',NULL,'Regular'),(652,429,'Tunggakan',0,153,'2026-06-30 23:08:23',NULL,'Regular'),(653,429,'Punishment',0,153,'2026-06-30 23:08:23',NULL,'Regular');

--
-- Table structure for table `tbl_teknisi`
--

CREATE TABLE `tbl_teknisi` (
  `id_teknisi` int(5) NOT NULL AUTO_INCREMENT,
  `nama_teknisi` varchar(50) DEFAULT NULL,
  `no_hp_teknisi` varchar(20) DEFAULT NULL,
  `id_telegram_teknisi` varchar(20) NOT NULL,
  PRIMARY KEY (`id_teknisi`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_teknisi`
--


--
-- Table structure for table `tbl_template_pesan`
--

CREATE TABLE `tbl_template_pesan` (
  `id_template` int(11) NOT NULL AUTO_INCREMENT,
  `id_admin` int(11) DEFAULT NULL,
  `judul` varchar(255) DEFAULT NULL,
  `pesan` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id_template`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_template_pesan`
--

INSERT INTO `tbl_template_pesan` VALUES (2,98,'Tanya kendala pelanggan','Assalamu\'alaikum,\n\nBpk/ibu kami ingin mengkonfirmasikan, apakah internetnya mengalami kendala/ gangguan ??\n\nKontak Teknisi :\n- 083195991998 ( Teknisi 1 )\n- 089520438562 ( Teknisi 2 )\n- 085157257740 ( Admin )\n\n\n_Mohon konfirmasi pesan kami pada teknisi_\n\n\n*PT. ANUGERAH CIMANUK RAYA*\nISP : CDN\nBrand : NassivaNET\nwww.nassivanet.my.id','2024-06-04 07:08:30','2024-07-01 17:50:42'),(3,98,'pengaktifan kembali internet pelanggan','Pelanggan Yth,\nUntuk mengaktifkan kembali layanan internet anda, Silahkan *terlebih dahulu untuk melakukan pembayaran* sesuai paket internet yang anda gunakan.\nkemudian konfirmasi ke *Admin*\n\nTerimakasih atas perhatiannya.\n\nPT.Anugerah CImanuk Raya\nISP CDN.\nBrand : Nassivanet\nwebsite : www.nassivanet.my.id','2024-06-07 17:23:00','2024-06-07 17:24:23'),(4,98,'penagihan ke2 hari ini','Assalamualaikum\n \nIni adalah konfirmasi penagihan keliling WiFi ke 2 untuk bulan ini. Kami telah mencoba mengunjungi rumah sebelumnya namun tidak ada orang.\n\n* Karena itu kami akan mencoba *Keliling kembali* ke rumah anda pada *HARI INI ( SORE )* \n\n* Mohon Konfirmasi *jika tidak ada di Rumah* . \n\n* Cara Lain untuk pembayarannya bisa dengan Cara Transfer ke Rekening:\nBRI. \nAn. DEDEN KURNIYAWAN\n4231 0101 7772 536\n( Konfirmasi ke nomer 085157257740 )\n\n*Atau Pembayaran langsung ke Agen terdekat.\n\nMohon kerjasamanya dan segera konfirmasi.\nTerima kasih atas perhatiannya!\n \nSalam,\n*NassivaNET*\nwww.nassivanet.my.id','2024-07-19 23:38:39','2024-07-19 23:38:39'),(5,98,'penagihan ke2 BESOK','Assalamualaikum\n \nIni adalah konfirmasi penagihan keliling WiFi ke 2 untuk bulan ini. Kami telah mencoba mengunjungi rumah sebelumnya namun tidak ada orang.\n\n* Karena itu kami akan mencoba *Keliling kembali* ke rumah anda pada *BESOK ( SORE )* \n\n* Mohon Konfirmasi *jika tidak ada di Rumah* . \n\n* Cara Lain untuk pembayarannya bisa dengan Cara Transfer ke Rekening:\nBRI. \nAn. DEDEN KURNIYAWAN\n4231 0101 7772 536\n( Konfirmasi ke nomer 085157257740 )\n\n*Atau Pembayaran langsung ke Agen terdekat.\n\nMohon kerjasamanya dan segera konfirmasi.\nTerima kasih atas perhatiannya!\n \nSalam,\n*NassivaNET*\nwww.nassivanet.my.id','2024-07-19 23:39:07','2024-07-19 23:39:07'),(6,98,'Undang Chanel Whatsapp','Hallo, Kami Admin *NassivaNET* \n\nMengundang anda untuk join CHanel whatsapp kami, Chanel ini berisi menganai informasi Jaringan Seperti\n\n*Gangguan Jaringnan\n*Informasi Up Down Server\n\nklik link di bawah ini untuk mengikuti,\nhttps://whatsapp.com/channel/0029Vb3daFh5PO11o0cB2v42\n\ndi harapkan mengikuti Chanel kami agar saat gangguan bisa tau.\nTerimakasih atas perhatiannya.\n\n\n_Admin NassivaNET_','2024-08-05 08:46:35','2025-01-23 08:12:11'),(7,98,'Internet UP Client','Internet sudah mulai UP\n\n\nSilahkan cek kembali koneksi anda secara berkala.\nJika belum terkoneksi, silahkan cek :\n1. Cabut dan tancapkan kembali adator router anda\n2. Pastikan kabel terhubung ke perangkat \n3. Pastikan internet pusat normal\n\nHubungi teknisi jika masih error.\n\nMohon maaf atas ketidaknyamanannya, terimakasih.\n\n_Jangan lupa ikuti Saluran Whatsapp kami untuk mendapatkan informasi status jaringan, klik link dibawah ini_\nhttps://whatsapp.com/channel/0029Vb3daFh5PO11o0cB2v42','2024-08-31 23:27:17','2025-01-23 00:13:25'),(8,98,'FU Pengambilan Router','Hai [nama], kami mendeteksi ibu/bpk sudah tidak berlangganan internet selama 2bulan lebih.\n\nApakah ada rencana perpanjangan lagi dalam waktu dekat ini ??\n\nJika tidak melakukan perpanjangan paket, kami akan melakukan pengambilan ROUTER, \n\n','2024-09-22 19:48:11','2024-09-22 19:48:11'),(9,98,'SP1 Tunggakan','*SP1*\nPermisi Bpk/Ibu *[nama]* *[kode]*\ndi *[alamat]*\n\nKami mendeteksi tagihan anda sudah melebihi masa tempo 1 bulan. Sesuai kebijakan yang ada. Kami akan melakukan Tindakan isolir.\n\nDetail tagihan\n*Tagihan Rp. [jumlah]*\n\n\nMohon segera di lunasi agar terhindar dari isolir.\n\nRentan waktu yang di berikan *1 minggu* setelah pesan SP1 terkirim.\n\nTerimakasih atas perhatiannya.\n\nNassivaNET.\n_www.nassivanet.my.id_\n','2024-12-13 01:42:17','2024-12-13 01:51:25'),(10,98,'SP1 OK','*SP1*\nPermisi Yth Bpk/Ibu \n\nKami mendeteksi tagihan anda sudah melebihi masa tempo 1 bulan. Sesuai kebijakan yang ada. Kami akan melakukan Tindakan isolir.\n\nMohon segera di lunasi agar terhindar dari isolir.\n\n*Metode Pembayaran*\n*DANA* 085157257740\n*BRI* 423101017772536 An. DEDEN KURNIYAWAN\n\n*QRIS* klik link di bawah menampilkan qris\nhttps://www.nassivanet.my.id/p/pembayaran.html\n\nRentan waktu yang di berikan *3 hari* setelah pesan SP1 terkirim.\n\n\nTerimakasih atas perhatiannya.\n\nNassivaNET.\n\n','2024-12-17 16:51:36','2024-12-17 16:53:17'),(11,98,'Notif Jatuh Tempo','Pelanggan Yth,\n\nAnda memiliki tagihan Wifi yang belum di bayarkan.\nMohon untuk membayar tepat waktu agar terhindar dari ISOLIR / pemutusan internet!\n\n*Pembayaran bisa melalui* :\n*BRI*\n423101017772536\nDEDEN KURNIYAWAN\n\n*DANA* \n085157257740\n\n*QRIS*\n_klik disini untuk melihat QRIS_ >> https://www.nassivanet.my.id/p/pembayaran.html\n\n\njangan lupa konfirmasi pada admin ( 085157257740 ) . terimakasih atas perhatiannya..\n\nNassivaNET\n\n_pesan ini dikirim otomatiso oleh sistem billing_','2024-12-18 18:27:09','2024-12-18 19:33:29'),(12,98,'NOTIF PRA ISOLIR','Pelanggan Yth,\n\nAnda memiliki tagihan Wifi yang belum di bayarkan.\nMohon untuk membayar tepat waktu agar terhindar dari ISOLIR / pemutusan internet!\n\nMohon konfirmasi sebelum jam 20:00 WIB hari ini.\n\nTerimakasih \n\n*Pembayaran bisa melalui* :\n*BRI*\n423101017772536\nDEDEN KURNIYAWAN\n\n*DANA* \n085157257740\n\n*QRIS*\n_klik disini untuk melihat QRIS_ >> https://www.nassivanet.my.id/p/pembayaran.html\n\n\njangan lupa konfirmasi pada admin ( 085157257740 ) . terimakasih atas perhatiannya..\n\nNassivaNET\n\n_pesan ini dikirim otomatiso oleh sistem billing_','2024-12-31 21:06:04','2024-12-31 21:06:04'),(13,98,'FO Pelanggan Nunggak isolir','Pelanggan Yth,\nSaat ini anda masih memiliki tunggakan yang belum di bayar.\n\nMohon untuk segera melakukan konfirmasi pembayaran.\n\n*Pembayaran bisa melalui* :\n*BRI*\n423101017772536\nDEDEN KURNIYAWAN\n\n*DANA* \n085157257740\n\n*QRIS*\n_klik disini untuk melihat QRIS_ >> https://www.nassivanet.my.id/p/pembayaran.html\n\n\njangan lupa konfirmasi pada admin ( 085157257740 ) . terimakasih atas perhatiannya..\n\nNassivaNET\n\n_pesan ini dikirim otomatiso oleh sistem billing_','2025-01-04 18:10:46','2025-01-04 18:11:46'),(14,102,'Pembayaran WIFI KASAPA.NET CDN','Pelanggan CDN Yth. untuk pembayaran tagihan bisa melalui jualan cappucino sebelah martabak sigombang. jangan sampai melewati tanggal 5 di karenakan terjadinya isolir.\n\nlokasi:\nhttps://maps.app.goo.gl/ZtoGwBhoaApxcJRi9?g_st=aw\n\nUntuk pembayaran bisa lewat dana/rekening BCA BRI A/N AGI RIYANTO\nDANA: 082120734678\nBCA: 1342787538\nBRI: 4130 0102 3960 507\n\nTerima Kasih.','2025-02-03 13:54:54','2025-02-04 10:00:31');

--
-- Table structure for table `tbl_template_voucher`
--

CREATE TABLE `tbl_template_voucher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_admin` int(11) DEFAULT NULL,
  `brand` varchar(100) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `logo` text DEFAULT NULL,
  `tgl_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_template_voucher`
--

INSERT INTO `tbl_template_voucher` VALUES (1,86,'do@net','Info pemasangan dan voucher|\n085220129723\n** syarat dan ketentuan berlaku',NULL,'2024-05-04 18:31:32'),(2,98,'NassivaNET','Harga Rakyat Kualitas Pejabar','24052508173750_thumb.png','2024-05-24 19:08:56'),(3,102,'KASAPA.NET','1 bulan',NULL,'2024-09-30 02:53:25');

--
-- Table structure for table `tbl_tiang`
--

CREATE TABLE `tbl_tiang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_admin` int(11) DEFAULT NULL,
  `tikor` text DEFAULT NULL,
  `foto` text DEFAULT NULL,
  `tgl` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_tiang`
--


--
-- Table structure for table `tbl_todo_list`
--

CREATE TABLE `tbl_todo_list` (
  `id_todo_list` int(11) NOT NULL AUTO_INCREMENT,
  `id_area` int(11) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `penyebab` text NOT NULL,
  `tanggal_input` datetime NOT NULL,
  `id_admin` int(11) NOT NULL,
  `status` varchar(100) NOT NULL,
  `no_tiket` int(20) NOT NULL,
  `tanggal_selesai` datetime NOT NULL,
  `catatan` text NOT NULL,
  `konfirmasi_admin` varchar(100) NOT NULL,
  `teknisi` text NOT NULL,
  `durasi` text NOT NULL,
  `bukti` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_todo_list`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_todo_list`
--


--
-- Table structure for table `tbl_transaksi`
--

CREATE TABLE `tbl_transaksi` (
  `transaksi_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaksi_tanggal` date NOT NULL,
  `transaksi_jenis` enum('Pengeluaran','Pemasukan') NOT NULL,
  `transaksi_kategori` int(11) NOT NULL,
  `transaksi_nominal` int(11) NOT NULL,
  `transaksi_keterangan` text NOT NULL,
  `transaksi_bank` int(11) NOT NULL,
  PRIMARY KEY (`transaksi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_transaksi`
--


--
-- Table structure for table `tbl_tripay_riwayat`
--

CREATE TABLE `tbl_tripay_riwayat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_admin` int(11) DEFAULT NULL,
  `nominal` text DEFAULT NULL,
  `jenis` text DEFAULT NULL,
  `status` int(1) DEFAULT 0,
  `tgl` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_tripay_riwayat`
--


--
-- Current Database: `wilayah`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wilayah` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `wilayah`;

--
-- Table structure for table `RECOVER_YOUR_DATA_info`
--

CREATE TABLE `RECOVER_YOUR_DATA_info` (
  `READ_ME` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `RECOVER_YOUR_DATA_info`
--

INSERT INTO `RECOVER_YOUR_DATA_info` VALUES ('Dear Sir/Madam,\r\n\r\nWe hope this message finds you well.\r\n\r\nWe would like to inform you that we\r\nhave backed up your databases/tables.\r\nWe keep them for 30 days and then\r\nwill be publicly disclosed and\r\npermanently delete them\r\nfrom our servers.\r\n\r\nWe offer two options:\r\n\r\nOption 1.: recovery service + leak protection\r\n\r\nif you want to recover your corrupted\r\nor incomplete databases/tables and\r\nyou want to prevent it from being\r\nleaked, simply transfer\r\n0.018 BTC to this address:\r\n\r\n18kboxGVGUNjUbve1vXqGXaMGCtd6s5qJX\r\n\r\nThis address is assigned to your\r\ndatabase credentials (host + user:\r\nsv107.cimanuk.co.id + admin2).\r\nWe will know when you have paid.\r\n\r\nAfter payment confirmation, our\r\nprogram will restore the entire\r\ndatabases/tables automatically, so\r\nplease do not change your database\r\nlogin details and make sure the\r\ndatabase is still accessible from\r\noutside the local network.\r\nDon not worry. All your databases and\r\ntables will be restored. (If the\r\nrestore fails the current field will\r\nbe modified and provide links for you\r\nto download your datas). The saved\r\nfiles will be immediately deleted\r\nfrom our servers.\r\n\r\nOption 2.: leak protection only\r\n\r\nIf you don not need to restore your\r\ndatabases but you want to prevent it\r\nfrom being leaked, send\r\n0.007 BTC to this address:\r\n\r\n18kboxGVGUNjUbve1vXqGXaMGCtd6s5qJX\r\n\r\nIn this case, your data will not be\r\nmade public and will be deleted from\r\nour servers immediately, without\r\nany further recovery service.\r\n\r\n\r\n-------------\r\nPlease take note of the following:\r\n\r\nAfter 30 days, we cannot guarantee\r\nthe restoration of your data.\r\n\r\nThe only way to recover your data\r\n(and prevent it from being leaked)\r\nis by making the payment.\r\n\r\nData leaks can have serious\r\nconsequences. Rest assured,\r\nyour data is protected.\r\n\r\nOnce your payment is completed,\r\nall your data will be deleted from\r\nour servers. Currently, government\r\nagencies, competitors, contractors,\r\nand local media remain unaware of\r\nthe incident. Upon receiving your\r\npayment, we guarantee that these\r\nentities will not be contacted about\r\nthis matter, ensuring your privacy\r\nand the confidentiality of the\r\nsituation are maintained.\r\n\r\nPay now, and we guarantee that your\r\ndata will not be sold on dark web\r\nresources or used to attack your\r\ncompany, employees, or counterparties\r\nin the future. The full database dump\r\nwill be restored, and all other data\r\nwill be immediately deleted from our\r\nservers.\r\n\r\nIf you do not send the requested\r\namount within 30 days from the date\r\nof the incident, we will consider the\r\ntransaction incomplete. Your data\r\nwill then be sent to any interested\r\nparties. This is your responsibility.\r\n\r\nAfter payment confirmation, our\r\nsystem will automatically restore the\r\nentire databases/tables, so please do\r\nnot change your database login\r\ndetails and make sure the database is\r\nstill accessible from outside the\r\nlocal network.\r\n\r\n-------------\r\nThe only accepted payment method is\r\nBitcoin. To the wallet specified above.\r\n\r\nBe advised: PayPal, WeTransfer,\r\nAlipay, credit cards, and other\r\nmethods will not be accepted.\r\n\r\nIf you do not have Bitcoin, you can\r\npurchase it using a credit card from\r\nthe following websites:\r\n\r\nCoinbase: https://www.coinbase.com/\r\nMoonPay: https://www.moonpay.com/buy\r\nPaybis: https://paybis.com/\r\nChangelly: https://changelly.com/buy\r\nAqua: https://aqua.net/\r\nCEX: https://cex.io/\r\nHodlHodl: https://hodlhodl.com\r\n\r\nAlternatively, you can buy Bitcoin\r\nusing other payment methods from the\r\nfollowing platforms (some of them\r\nwork in China):\r\n\r\nCoinbase: https://www.coinbase.com/\r\nPaxful: https://paxful.com/\r\nBinance: https://www.binance.com/\r\nCrypto.com: https://www.crypto.com/\r\nHuobi: https://www.huobi.com/\r\nOKCoin: https://www.okcoin.com/\r\nBTCC: https://www.btcc.com/\r\nPaybis: https://paybis.com/\r\nCoinmama: https://coinmama.com/\r\nBitfinex: https://www.bitfinex.com/\r\n\r\nFor users in China, Bitcoin can be\r\npurchased with Alipay from:\r\n\r\nCoinCola:\r\nhttps://www.coincola.com/?lang=zh-HK\r\nBitValve:\r\nhttps://www.bitvalve.com/buy-bitcoin/alipay\r\n\r\nThank you for your time and\r\nconsideration. Good luck.\r\n\r\n');


