INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-08-25 ','08:10:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','10:26:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','11:09:52');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250825-0001','kasir','1',' DP-00885BI','TOKO','BIPPSN','PSGT-YGCX-43-0','CINCIN EMAS ','','2.510','1','83.00','3703000','0','0','16500','4766200','0','0','0','4766200','SUL','00037782','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YGCX-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2025-08-25' AND kode_barang='PSGT-YGCX-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250825-0001','2025-08-25','2.510','2025-08-25','11:11:23','PLG0005985','4766200','4766200','0','4766200','0','kasir','2025-08-25 11:11:23','FJ-250825-0001','DP-00885','3800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-25','FJ-250825-0001','2025-08-25','11:11:23','SUL','4766200','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250825-0004','2025-08-25','2025-08-25 11:11:23','PENJUALAN : FJ-250825-0001','.','TBC','966200','966200','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250825-0005','D','2025-08-25','11:11:23','TBC','PENJUALAN','FJ-250825-0001','15929536364','966200','15930502564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='966200' WHERE no_faktur_jual='FJ-250825-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250825-0002','kasir',' 1',' DP-00886BI','TOKO','BIPPSN','PSPLT-YGBI-47-0','CINCIN PALADIUM ','','2.290','1','7.00','308000','0','0','16500','1272500','0','0','0','1272500','SUL','00037683','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YGBI-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2025-08-25' AND kode_barang='PSPLT-YGBI-47-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250825-0002','2025-08-25','2.290','2025-08-25','11:11:23','PLG0005986','1272500','1272500','0','1272500','0','kasir','2025-08-25 11:11:23','FJ-250825-0001','DP-00886','725000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-25','FJ-250825-0002','2025-08-25','11:11:23','SUL','1272500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250825-0005','2025-08-25','2025-08-25 11:11:23','PENJUALAN : FJ-250825-0002','.','TBC','547500','547500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250825-0006','D','2025-08-25','11:11:23','TBC','PENJUALAN','FJ-250825-0002','15930502564','547500','15931050064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1513700' WHERE no_faktur_jual='FJ-250825-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250825-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250825-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-08-25 ','14:20:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','14:35:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-08-25 ','14:54:53');
UPDATE tm_user SET nama_lkp='SPV',pass_key='|krpxp5',type='MGR' WHERE user_id='spv';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-08-25 ','14:56:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-08-25 ','14:56:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-08-25 ','14:58:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-08-25 ','14:59:16');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-01007';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-01007';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-01007';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250825-0002','K','2025-08-25','14:59:48','Nagatech','PESANAN BATAL','DP-01007','436600','0','436600');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','15:01:20');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250825-0003','kasir','1',' 750K-12-15','TOKO','BIPPER','PBDG-YHAB-14-0','CINCIN SILVER 925 ','','2.260','1','100.00','59000','0','0','16500','750000','0','0','0','750000','SUL','00037941','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHAB-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2025-08-25' AND kode_barang='PBDG-YHAB-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250825-0003','2025-08-25','2.260','2025-08-25','15:10:32','PLG0005987','750000','750000','0','750000','0','kasir','2025-08-25 15:10:32','FJ-250825-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-25','FJ-250825-0003','2025-08-25','15:10:32','SUL','750000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250825-0006','2025-08-25','2025-08-25 15:10:32','PENJUALAN : FJ-250825-0003','.','TBC','750000','750000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250825-0007','D','2025-08-25','15:10:32','TBC','PENJUALAN','FJ-250825-0003','15931050064','750000','15931800064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='750000' WHERE no_faktur_jual='FJ-250825-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250825-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250825-0004','kasir','1',' TFLMR75-91','TOKO','TFLMPK','TFLMR-XAAX-46-0','THIFA LIONTIN MAS RG ','','1.200','1','91.00','1920000','0','0','16500','2000000','0','0','0','2000000','RISIANA','00025720','TFLMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFLMR-XAAX-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2025-08-25' AND kode_barang='TFLMR-XAAX-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLMPK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250825-0004','2025-08-25','1.200','2025-08-25','15:19:32','PLG0005988','2000000','2000000','0','2000000','0','kasir','2025-08-25 15:19:32','FJ-250825-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-25','FJ-250825-0004','2025-08-25','15:19:32','RISIANA','2000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250825-0007','2025-08-25','2025-08-25 15:19:32','PENJUALAN : FJ-250825-0004','.','TBC','2000000','2000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250825-0008','D','2025-08-25','15:19:32','TBC','PENJUALAN','FJ-250825-0004','15931800064','2000000','15933800064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2000000' WHERE no_faktur_jual='FJ-250825-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250825-0005','kasir','1',' TFKMR75-91','TOKO','TFKMP','TFKMR-XAAX-26-0','THIFA KALUNG MAS RG ','','6.550','1','91.00','10476000','0','0','16500','11000000','0','0','0','11000000','ILU','00025700','TFKMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFKMR-XAAX-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.550',berat_jual_asli=berat_jual_asli+'6.550',stock_jual='1',berat_akhir=berat_akhir-'6.550',berat_akhir_asli=berat_akhir_asli-'6.550',stock_akhir='0' WHERE tanggal='2025-08-25' AND kode_barang='TFKMR-XAAX-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFKMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250825-0005','2025-08-25','6.550','2025-08-25','16:07:39','PLG0005989','11000000','11000000','0','11000000','11000000','kasir','2025-08-25 16:07:39','FJ-250825-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-25','FJ-250825-0005','2025-08-25','16:07:39','ILU','11000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250825-0003','D','2025-08-25','16:07:39','kasir','PENJUALAN','FJ-250825-0005','436600','11000000','11436600');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250825-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250825-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250825-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','18:33:24');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250825-0004','K','2025-08-25','18:34:11','kasir','KAS BESAR','STOR UANG KE REK NADA','11436600','11400000','36600');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-25';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','TBC','SALDO AWAL','SALDO AWAL','0','15933800064','15933800064');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','KET','SALDO AWAL','SALDO AWAL','0','134183000','134183000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','MANDIRI','SALDO AWAL','SALDO AWAL','0','44680000','44680000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250826-0001','D','2025-08-26','20:04:19','BCD','SALDO AWAL','SALDO AWAL','0','1329371000','1329371000');
UPDATE tp_system SET tgl_system='2025-08-26';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','20:15:44');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01019','NAD','1','PLD','CINCIN NIKAH','','','5.000','','25.00','1','1736000','450000','','700000','2950000','permata 1 zirkon','size 19 grafir yuli & dermawan','berat max 5 grm jgn lbh','10000','','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250826-0001','2025-08-26','2025-08-25 20:20:18','PESANAN : DP-01019','.','TBC','2368000','2368000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250826-0002','D','2025-08-26','20:20:18','TBC','PESANAN','DP-01019','15933800064','2368000','15936168064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01019','2025-08-26','2025-08-26','20:20:18','PLG0005990','NAD','2025-09-09','kasir','2025-08-25 20:20:18','5.000','0','0','0','2368000','0','700000','2960000','2960000','592000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-25 ','20:31:29');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01020','SULIS','1','PER','WEDDING RING','','','2.000','','925.00','1','25000','0','850000','0','850000','sz 7 crom putih glosy','font vladimir grf Fajar & Azki','model seperti contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250826-0002','2025-08-26','2025-08-25 20:35:50','PESANAN : DP-01020','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250826-0003','D','2025-08-26','20:35:50','TBC','PESANAN','DP-01020','15936168064','850000','15937018064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01020','2025-08-26','2025-08-26','20:35:50','PLG0005991','SULIS','2025-09-16','kasir','2025-08-25 20:35:50','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01021','SULIS','1','PER','WEDDING RING','','','2.000','','925.00','1','25000','0','700000','0','700000','sz 12.5 crom putih doff semprot','font vladimir grf Fajar & Azki','1 zircon. model spt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250826-0003','2025-08-26','2025-08-25 20:41:02','PESANAN : DP-01021','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250826-0004','D','2025-08-26','20:41:02','TBC','PESANAN','DP-01021','15937018064','700000','15937718064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01021','2025-08-26','2025-08-26','20:41:02','PLG0005992','SULIS','2025-09-16','kasir','2025-08-25 20:41:02','2.000','0','0','0','700000','0','0','700000','700000','0');