INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-12-24 ','09:25:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','10:32:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','10:48:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','12:14:11');
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-01531','SULIS','1','GOLD','WED RING','','','2.000','','75.00','1','2365000','2185000','0','750000','5120000','23 zircon crom rosegold glosy','sz 11 font berkshire swash grf Luthfi','','230000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251224-0002','2025-12-24','2025-12-24 12:15:59','PESANAN : DP-01531','.','TBC','4280000','4280000');
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-251224-0003','D','2025-12-24','12:15:59','TBC','PESANAN','DP-01531','18849436114','4280000','18853716114','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-01531','2025-12-24','2025-12-24','12:15:59','PLG0008457','SULIS','2026-01-24','kasir','2025-12-24 12:15:59','2.000','0','0','0','4280000','0','750000','5350000','5350000','1070000');
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-01532','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','2306000','300000','0','700000','1600000','1 zircon rosegold glosy','sz 18.5 font berkshire swash','grf Reva','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251224-0003','2025-12-24','2025-12-24 12:19:53','PESANAN : DP-01532','.','TBC','800000','800000');
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-251224-0004','D','2025-12-24','12:19:53','TBC','PESANAN','DP-01532','18853716114','800000','18854516114','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-01532','2025-12-24','2025-12-24','12:19:53','PLG0008458','SULIS','2026-01-24','kasir','2025-12-24 12:19:53','3.000','0','0','0','800000','0','700000','1600000','1600000','800000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','13:11:36');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0001','1','PBDG-YLBD-12-0','1','1.740','1.740','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YLBD-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YLBD-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YLBD-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-12-24 13:11:47' WHERE kode_barang='PBDG-YLBD-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YLBD-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:11:47','TOKO','BIPPER','PBDG','PBDG-YLBD-12-0','1','1.740','1.740','1','1.740','1.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YLBD-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0001','1','PBDG-YLBD-13-0','1','1.770','1.770','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YLBD-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YLBD-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YLBD-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-12-24 13:11:47' WHERE kode_barang='PBDG-YLBD-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YLBD-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:11:47','TOKO','BIPPER','PBDG','PBDG-YLBD-13-0','1','1.770','1.770','1','1.770','1.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YLBD-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-13-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0001','1','PBDG-YLBD-14-0','1','1.980','1.980','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YLBD-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YLBD-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YLBD-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-12-24 13:11:47' WHERE kode_barang='PBDG-YLBD-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YLBD-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:11:47','TOKO','BIPPER','PBDG','PBDG-YLBD-14-0','1','1.980','1.980','1','1.980','1.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YLBD-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-14-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0001','1','PBDG-YLBD-15-0','1','2.110','2.110','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YLBD-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YLBD-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YLBD-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-12-24 13:11:47' WHERE kode_barang='PBDG-YLBD-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YLBD-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:11:47','TOKO','BIPPER','PBDG','PBDG-YLBD-15-0','1','2.110','2.110','1','2.110','2.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YLBD-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YLBD-15-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251224-0001','2025-12-24','13:11','7.600','kasir','2025-12-24 13:11:47');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0002','1','PLBDG-YLBD-8-0','1','1.960','1.960','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YLBD-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YLBD-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YLBD-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-12-24 13:12:11' WHERE kode_barang='PLBDG-YLBD-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YLBD-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:11','TOKO','BIPPLD','PLBDG','PLBDG-YLBD-8-0','1','1.960','1.960','1','1.960','1.960','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YLBD-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-8-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0002','1','PLBDG-YLBD-9-0','1','1.590','1.590','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YLBD-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YLBD-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YLBD-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-12-24 13:12:11' WHERE kode_barang='PLBDG-YLBD-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YLBD-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:11','TOKO','BIPPLD','PLBDG','PLBDG-YLBD-9-0','1','1.590','1.590','1','1.590','1.590','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YLBD-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-9-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0002','1','PLBDG-YLBD-10-0','1','2.510','2.510','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YLBD-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YLBD-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YLBD-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-12-24 13:12:11' WHERE kode_barang='PLBDG-YLBD-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YLBD-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:11','TOKO','BIPPLD','PLBDG','PLBDG-YLBD-10-0','1','2.510','2.510','1','2.510','2.510','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YLBD-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-10-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0002','1','PLBDG-YLBD-11-0','1','1.620','1.620','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YLBD-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YLBD-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YLBD-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-12-24 13:12:11' WHERE kode_barang='PLBDG-YLBD-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YLBD-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:11','TOKO','BIPPLD','PLBDG','PLBDG-YLBD-11-0','1','1.620','1.620','1','1.620','1.620','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YLBD-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YLBD-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251224-0002','2025-12-24','13:12','7.680','kasir','2025-12-24 13:12:11');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSPRT-YLBD-1-0','1','4.350','4.350','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YLBD-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YLBD-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBD-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSPRT-YLBD-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YLBD-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSPRT','PSPRT-YLBD-1-0','1','4.350','4.350','1','4.350','4.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YLBD-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSGT-YLBD-2-0','1','1.970','1.970','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YLBD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YLBD-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YLBD-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YLBD-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSGT-YLBD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YLBD-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSGT','PSGT-YLBD-2-0','1','1.970','1.970','1','1.970','1.970','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YLBD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YLBD-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSGT-YLBD-3-0','1','2.060','2.060','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YLBD-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YLBD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YLBD-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YLBD-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSGT-YLBD-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YLBD-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSGT','PSGT-YLBD-3-0','1','2.060','2.060','1','2.060','2.060','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YLBD-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YLBD-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSGT-YLBD-4-0','1','3.160','3.160','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YLBD-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YLBD-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YLBD-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YLBD-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSGT-YLBD-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YLBD-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSGT','PSGT-YLBD-4-0','1','3.160','3.160','1','3.160','3.160','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YLBD-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YLBD-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSPRT-YLBD-5-0','1','3.980','3.980','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YLBD-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YLBD-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBD-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSPRT-YLBD-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YLBD-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSPRT','PSPRT-YLBD-5-0','1','3.980','3.980','1','3.980','3.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YLBD-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-5-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSPRT-YLBD-6-0','1','2.380','2.380','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YLBD-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YLBD-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBD-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSPRT-YLBD-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YLBD-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSPRT','PSPRT-YLBD-6-0','1','2.380','2.380','1','2.380','2.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YLBD-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-6-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251224-0003','1','PSPRT-YLBD-7-0','1','3.700','3.700','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YLBD-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YLBD-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBD-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-12-24 13:12:34' WHERE kode_barang='PSPRT-YLBD-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YLBD-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-24 13:12:34','TOKO','BIPPSN','PSPRT','PSPRT-YLBD-7-0','1','3.700','3.700','1','3.700','3.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YLBD-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBD-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-24' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251224-0003','2025-12-24','13:12','21.600','kasir','2025-12-24 13:12:34');
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-251224-0002','D','2025-12-24','14:17:49','kasir','TAMBAH KAS','BAYAR SERVICE SV01598','1951100','250000','2201100');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-12-24 ','14:23:31');
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-251224-0001','kasir','1',' 700K-135-0','TOKO','MMPER','PMM-YIXH-24-0','CINCIN SILVER 925 ','','1.360','1','100.00','35000','0','0','16800','700000','0','0','0','700000','NAD','00038618','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='PMM-YIXH-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-251224-0001','2025-12-24','1.360','2025-12-24','15:09:59','PLG0008459','700000','700000','0','700000','0','kasir','2025-12-24 15:09:58','FJ-251224-0001','','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-12-24','FJ-251224-0001','2025-12-24','15:09:59','NAD','700000','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-251224-0004','2025-12-24','2025-12-24 15:09:58','PENJUALAN : FJ-251224-0001','.','TBC','700000','700000','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-251224-0005','D','2025-12-24','15:09:59','TBC','PENJUALAN','FJ-251224-0001','18854516114','700000','18855216114','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='700000' WHERE no_faktur_jual='FJ-251224-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-251224-0002','kasir','1',' DP-01507BI','TOKO','BIPPSN','PSGT-YLBB-10-0','CINCIN EMAS ','','2.110','1','58.00','2928000','0','0','16800','4698000','0','0','0','4698000','HELMI','00040660','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YLBB-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='PSGT-YLBB-10-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-251224-0002','2025-12-24','2.110','2025-12-24','16:06:01','PLG0008460','4698000','4698000','0','4698000','0','kasir','2025-12-24 16:06:00','FJ-251224-0002','DP-01507','3600000');
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-12-24','FJ-251224-0002','2025-12-24','16:06:01','HELMI','4698000','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-251224-0005','2025-12-24','2025-12-24 16:06:00','PENJUALAN : FJ-251224-0002','.','TBC','1098000','1098000','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-251224-0006','D','2025-12-24','16:06:01','TBC','PENJUALAN','FJ-251224-0002','18855216114','1098000','18856314114','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='1098000' WHERE no_faktur_jual='FJ-251224-0002' 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-251224-0003','kasir',' 1',' DP-01508BI','TOKO','BIPPSN','PSPRT-YLBB-11-0','CINCIN PERAK ','','2.350','1','100.00','144000','0','0','16800','700000','0','0','0','700000','HELMI','00040661','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YLBB-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='PSPRT-YLBB-11-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-251224-0003','2025-12-24','2.350','2025-12-24','16:06:01','PLG0008461','700000','700000','0','700000','0','kasir','2025-12-24 16:06:00','FJ-251224-0002','DP-01508','700000');
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-12-24','FJ-251224-0003','2025-12-24','16:06:01','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1098000' WHERE no_faktur_jual='FJ-251224-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','17:09:19');
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-251224-0004','kasir','1',' TFC-21411 ','TOKO','TFCBR','TFC-YKAX-11-0','TFC-21411 GIA 7508375608 ','','4.880','1','75.00','25098000','14159500','843','16800','30000000','0','0','0','30000000','FAISAL','00039535','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-YKAX-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.880',berat_jual_asli=berat_jual_asli+'4.880',stock_jual='1',berat_akhir=berat_akhir-'4.880',berat_akhir_asli=berat_akhir_asli-'4.880',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='TFC-YKAX-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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-251224-0004','2025-12-24','4.880','2025-12-24','17:12:09','PLG0008462','30000000','30000000','0','30000000','7615000','kasir','2025-12-24 17:12:08','FJ-251224-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-12-24','FJ-251224-0004','2025-12-24','17:12:09','FAISAL','30000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251224-0003','D','2025-12-24','17:12:09','kasir','PENJUALAN BERLIAN','FJ-251224-0004','2201100','7615000','9816100','OPEN');
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-251224-0006','2025-12-24','2025-12-24 17:12:08','PENJUALAN : FJ-251224-0004','.','TBC','22385000','22385000','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-251224-0007','D','2025-12-24','17:12:09','TBC','PENJUALAN BERLIAN','FJ-251224-0004','18856314114','22385000','18878699114','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='7615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='22385000' WHERE no_faktur_jual='FJ-251224-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0004';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01614','FAISAL','1','CBR','JADI SIZE 16 KRUM KOMBINASI HARGA KONFIRMASI','4.880','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01614','2025-12-24','2025-12-24','17:16:05','PLG0008463','kasir','2025-12-27','kasir','2025-12-24 17:16:05','4.880','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','17:25:44');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000333','X-00000333','THIFA CINCIN','GR','---','TFC','BELI','BELI001','7615000','2025-12-24','2.820','1','kasir','2025-12-24 17:26:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFC';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000333','X-00000333');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251224-0001','-','FAISAL','1','BELI','BELI001','TFC', 'X-00000333', 'THIFA CINCIN','2.820','2.820','75.00','10300000','7615000','2700355','1','7615000','7615000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.820',berat_beli_asli=berat_beli_asli+'2.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.820',berat_akhir_asli=berat_akhir_asli+'2.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFC' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-251224-0001','2025-12-24','2025-12-24','17:26:56','FAISAL','---','2.820','7615000','7615000','7615000','7615000','7615000','kasir','2025-12-24 17:26:57','FB-251224-0001','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251224-0001','TRACEY','JKT','','JKT','0','kasir','2025-12-24 17:26:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-24' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-251224-0004','K','2025-12-24','17:26:56','kasir','PEMBELIAN UMUM','FB-251224-0001','9816100','7615000','2201100','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251224-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251224-0001';
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-251224-0005','kasir','1',' 700K-205-1','TOKO','BIPPER','PBDG-YKBE-122-0','CINCIN SILVER 925 ','','2.200','1','100.00','135000','0','0','16800','700000','0','0','0','700000','HELMI','00039954','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-122-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='PBDG-YKBE-122-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-251224-0005','2025-12-24','2.200','2025-12-24','17:59:46','PLG0008464','700000','700000','0','700000','0','kasir','2025-12-24 17:59:46','FJ-251224-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-12-24','FJ-251224-0005','2025-12-24','17:59:46','HELMI','700000','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-251224-0007','2025-12-24','2025-12-24 17:59:46','PENJUALAN : FJ-251224-0005','.','TBC','700000','700000','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-251224-0008','D','2025-12-24','17:59:46','TBC','PENJUALAN','FJ-251224-0005','18878699114','700000','18879399114','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='700000' WHERE no_faktur_jual='FJ-251224-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0005';
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-251224-0006','kasir','1',' 700K-14-63','TOKO','MMPER','PMM-YLXD-135-0','CINCIN SILVER 925 ','','1.150','1','100.00','71000','0','0','16800','299000','0','0','0','299000','NAD','00040315','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLXD-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='PMM-YLXD-135-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-251224-0006','2025-12-24','1.150','2025-12-24','18:46:21','PLG0008465','299000','299000','0','299000','0','kasir','2025-12-24 18:46:20','FJ-251224-0006','','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-12-24','FJ-251224-0006','2025-12-24','18:46:21','NAD','299000','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-251224-0008','2025-12-24','2025-12-24 18:46:20','PENJUALAN : FJ-251224-0006','.','TBC','299000','299000','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-251224-0009','D','2025-12-24','18:46:21','TBC','PENJUALAN','FJ-251224-0006','18879399114','299000','18879698114','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='299000' WHERE no_faktur_jual='FJ-251224-0006' 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-251224-0007','kasir','1',' 500K-17-00','TOKO','MMPER','PMM-YIAF-16-0','CINCIN SILVER 925 ','','2.060','1','100.00','53000','0','0','16800','500000','0','0','0','500000','NIS','00038761','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIAF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='PMM-YIAF-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-251224-0007','2025-12-24','2.060','2025-12-24','18:46:42','PLG0008466','500000','500000','0','500000','0','kasir','2025-12-24 18:46:42','FJ-251224-0007','','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-12-24','FJ-251224-0007','2025-12-24','18:46:42','NIS','500000','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-251224-0009','2025-12-24','2025-12-24 18:46:42','PENJUALAN : FJ-251224-0007','.','TBC','500000','500000','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-251224-0010','D','2025-12-24','18:46:42','TBC','PENJUALAN','FJ-251224-0007','18879698114','500000','18880198114','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='500000' WHERE no_faktur_jual='FJ-251224-0007' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01615','NAD','1','2PCS SLV','CEWE GRF BOBI DAN COWO GRF YUNI REIZE KE 20','3.210','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01615','2025-12-24','2025-12-24','18:49:40','PLG0008467','kasir','2025-12-25','kasir','2025-12-24 18:49:40','3.210','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251224-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251224-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-24';
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-12-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-24' 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-251225-0001','D','2025-12-25','20:07:34','TBC','SALDO AWAL','SALDO AWAL','0','18880198114','18880198114');
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-251225-0001','D','2025-12-25','20:07:34','BCK','SALDO AWAL','SALDO AWAL','0','1940208000','1940208000');
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-251225-0001','D','2025-12-25','20:07:34','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
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-251225-0001','D','2025-12-25','20:07:34','BCD','SALDO AWAL','SALDO AWAL','0','1342321000','1342321000');
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-251225-0001','D','2025-12-25','20:07:34','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251225-0001','D','2025-12-25','20:07:34','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-251225-0001','D','2025-12-25','20:07:34','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-251225-0001','D','2025-12-25','20:07:34','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-251225-0001','D','2025-12-25','20:07:34','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-251225-0001','D','2025-12-25','20:07:34','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-251225-0001','D','2025-12-25','20:07:34','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-12-25';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-24 ','20:12:17');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01616','SULIS','1','CC SILVER','SZ 14 5 JANGAN DIBUAT TIPIS FONT VINTAGE ROTTER','2.000','1','50000','50000');
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-251225-0001','2025-12-25','2025-12-24 20:14:14','SERVICE : SV-01616','.','TBC','50000','50000','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-251225-0002','D','2025-12-25','20:14:14','TBC','SERVICE','SV-01616','18880198114','50000','18880248114','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01616','2025-12-25','2025-12-25','20:14:14','PLG0008468','kasir','2026-01-09','kasir','2025-12-24 20:14:14','2.000','0','0','0','50000','0','50000','50000','0');