INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-28 ','08:33:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','09:51:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','10:15:32');
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-260828-0001','kasirbip','1',' DP-03250BI','TOKO','BIPPSN','PSPRT-ZHBF-70-0','CINCIN PERAK ','','3.350','1','100.00','342000','0','0','17800','900000','0','0','0','900000','SULIS','00046576','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-70-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-260828-0001','2026-08-28','3.350','2026-08-28','10:26:59','PLG0015002','900000','900000','0','900000','0','kasirbip','2026-08-28 10:26:58','FJ-260828-0001','DP-03250','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0001','2026-08-28','10:26:59','SULIS','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-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-260828-0002','kasirbip',' 1',' DP-03249BI','TOKO','BIPPSN','PSPRT-ZHBF-60-0','CINCIN PERAK ','','1.410','1','100.00','144000','0','0','17800','950000','0','0','0','950000','SULIS','00046566','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-60-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-260828-0002','2026-08-28','1.410','2026-08-28','10:26:59','PLG0015003','950000','950000','0','950000','0','kasirbip','2026-08-28 10:26:58','FJ-260828-0001','DP-03249','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0002','2026-08-28','10:26:59','SULIS','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','10:39:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','10:40:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','11:19:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','13:15:31');
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-03663','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','1500000','0','1500000','EXPRESS 200.000 font BERKSHIRE','cwe sz 11.5 CP.06 grf FAF ','','','','');
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-03663','PUT','2','','','','','','','','','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-03663','PUT','3','0','0','','','','','','','0','','','','','','','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0001','2026-08-28','2026-08-28 13:31:26','PESANAN : DP-03663','.','TBC','1500000','1500000');
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-260828-0002','D','2026-08-28','13:31:26','TBC','PESANAN','DP-03663','26899520064','1500000','26901020064','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-03663','2026-08-28','2026-08-28','13:31:26','PLG0015004','PUT','2026-09-03','kasirbip','2026-08-28 13:31:26','4.000','0','0','0','1500000','0','0','1500000','1500000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','13:31:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','13:35:01');
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-260828-0003','kasirbip','1',' DP-03440DU','TOKO','DUPSN','PSPRT-ZHBF-6-0','CINCIN PERAK SR03 YL01 ','','2.930','1','100.00','299000','0','0','17800','950000','0','0','0','950000','PUT','00046512','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260828-0003','2026-08-28','2.930','2026-08-28','14:00:01','PLG0015005','950000','950000','0','950000','0','kasirbip','2026-08-28 14:00:01','FJ-260828-0003','DP-03440','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0003','2026-08-28','14:00:01','PUT','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-28 ','14:13:59');
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-03664','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','950000','0','950000','UKIR NAMA DI LUAR MENYUSUL','GRF DALAM: 10.10.26 SIZE: 16.5','FONT:TIMES NEW PUTIH GLOSSY','50000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0002','2026-08-28','2026-08-28 14:16:47','PESANAN : DP-03664','-','TBC','1000000','1000000');
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-260828-0003','D','2026-08-28','14:16:47','TBC','PESANAN','DP-03664','26901020064','1000000','26902020064','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-03664','2026-08-28','2026-08-28','14:16:47','PLG0015006','VAN','2026-09-20','sby','2026-08-28 14:16:47','3.000','0','0','0','1000000','0','0','1000000','1000000','0');
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-260828-0004','sby','1',' 750K-195-0','TOKO','SBYPER','PSBY-ZGBB-33-0','CINCIN SILVER 925 ','','2.250','1','100.00','230000','0','0','17800','850000','0','0','0','850000','DIL','00045524','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSBY-ZGBB-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260828-0004','2026-08-28','2.250','2026-08-28','15:24:14','PLG0015007','850000','850000','0','850000','0','sby','2026-08-28 15:24:13','FJ-260828-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('2026-08-28','FJ-260828-0004','2026-08-28','15:24:14','DIL','850000','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-260828-0003','2026-08-28','2026-08-28 15:24:13','PENJUALAN : FJ-260828-0004','','TBC','850000','850000','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-260828-0004','D','2026-08-28','15:24:14','TBC','PENJUALAN','FJ-260828-0004','26902020064','850000','26902870064','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='850000' WHERE no_faktur_jual='FJ-260828-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-260828-0005','sby',' 1',' 750K-12-00','TOKO','SBYPER','PSBY-ZEXE-77-0','CINCIN SILVER 925 ','','1.730','1','100.00','177000','0','0','17800','850000','0','0','0','850000','DIL','00043273','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSBY-ZEXE-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260828-0005','2026-08-28','1.730','2026-08-28','15:24:14','PLG0015008','850000','850000','0','850000','0','sby','2026-08-28 15:24:13','FJ-260828-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('2026-08-28','FJ-260828-0005','2026-08-28','15:24:14','DIL','850000','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-260828-0004','2026-08-28','2026-08-28 15:24:13','PENJUALAN : FJ-260828-0005','','TBC','850000','850000','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-260828-0005','D','2026-08-28','15:24:14','TBC','PENJUALAN','FJ-260828-0005','26902870064','850000','26903720064','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='1700000' WHERE no_faktur_jual='FJ-260828-0005' LIMIT 1;
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03663';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03663';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03663';
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-260828-0002','K','2026-08-28','15:25:32','kasirbip','PESANAN BATAL','DP-03663','16875300','0','16875300');
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-03665','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','1500000','0','1500000','EXPRESS 200.000 font Berkshire','cwe 11.5 CP.06grf FAF ','','','','');
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-03665','PUT','2','','','','','','','','','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-03665','PUT','3','0','0','','','','','','','0','','','','','','','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0005','2026-08-28','2026-08-28 15:41:50','PESANAN : DP-03665','.','TBC','1500000','1500000');
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-260828-0006','D','2026-08-28','15:41:50','TBC','PESANAN','DP-03665','26903720064','1500000','26905220064','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-03665','2026-08-28','2026-08-28','15:41:50','PLG0015009','PUT','2026-09-03','kasirbip','2026-08-28 15:41:50','4.000','0','0','0','1500000','0','0','1500000','1500000','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-03666','PUT','1','PLD','WEDDRING','','','3.000','','25.00','1','1200000','550000','0','750000','2400000','sz 18 model LX-2526','grf Wulan font Vladimir','zircon 25','0','0','250000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0006','2026-08-28','2026-08-28 15:49:04','PESANAN : DP-03666','.','TBC','2120000','2120000');
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-260828-0007','D','2026-08-28','15:49:04','TBC','PESANAN','DP-03666','26905220064','2120000','26907340064','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-03666','2026-08-28','2026-08-28','15:49:04','PLG0015010','PUT','2026-09-03','kasirbip','2026-08-28 15:49:04','3.000','0','0','0','2120000','0','750000','2650000','2650000','530000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','15:50:13');
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-03667','PUT','1','PLD','WEDDRING','','','3.000','','25.00','1','1200000','550000','0','750000','2400000','sz 18 model LX-2526','grf Lukman font Vladimir','EXPRESS 200.000','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0007','2026-08-28','2026-08-28 15:54:06','PESANAN : DP-03667','.','TBC','1920000','1920000');
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-260828-0008','D','2026-08-28','15:54:06','TBC','PESANAN','DP-03667','26907340064','1920000','26909260064','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-03667','2026-08-28','2026-08-28','15:54:06','PLG0015011','PUT','2026-09-03','kasirbip','2026-08-28 15:54:06','3.000','0','0','0','1920000','0','750000','2400000','2400000','480000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','15:55:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','16:47:55');
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-260828-0006','kasirbip','1',' 900K-10-28','TOKO','BIPPER','PBDG-ZHAC-15-0','CINCIN SILVER 925 ','','1.720','1','100.00','176000','0','0','17800','1000000','0','0','0','1000000','KUR','00046129','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHAC-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PBDG-ZHAC-15-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-260828-0006','2026-08-28','1.720','2026-08-28','16:52:12','PLG0015012','1000000','1000000','0','1000000','0','kasirbip','2026-08-28 16:52:12','FJ-260828-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('2026-08-28','FJ-260828-0006','2026-08-28','16:52:12','KUR','1000000','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-260828-0008','2026-08-28','2026-08-28 16:52:12','PENJUALAN : FJ-260828-0006','.','TBC','1000000','1000000','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-260828-0009','D','2026-08-28','16:52:12','TBC','PENJUALAN','FJ-260828-0006','26909260064','1000000','26910260064','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='1000000' WHERE no_faktur_jual='FJ-260828-0006' LIMIT 1;
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-03668','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','800000','0','800000','sz 16.5 putih glosy','font yesefa one grf Farhan','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0009','2026-08-28','2026-08-28 17:23:19','PESANAN : DP-03668','.','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-260828-0010','D','2026-08-28','17:23:19','TBC','PESANAN','DP-03668','26910260064','800000','26911060064','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-03668','2026-08-28','2026-08-28','17:23:19','PLG0015013','SULIS','2026-09-22','kasirbip','2026-08-28 17:23:19','2.000','0','0','0','800000','0','0','800000','800000','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-03669','NAD','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','850000','0','850000','size 14 crom putih glossy','Grf Ara & Raka Font Vintage','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0010','2026-08-28','2026-08-28 17:24:22','PESANAN : DP-03669','.','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-260828-0011','D','2026-08-28','17:24:22','TBC','PESANAN','DP-03669','26911060064','850000','26911910064','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-03669','2026-08-28','2026-08-28','17:24:22','PLG0015014','NAD','2026-09-19','kasirbip','2026-08-28 17:24:22','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-03670','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','800000','0','800000','sz 24 putih glosy model tanpa mata','font yeseva one grf Dea','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0011','2026-08-28','2026-08-28 17:24:39','PESANAN : DP-03670','.','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-260828-0012','D','2026-08-28','17:24:39','TBC','PESANAN','DP-03670','26911910064','800000','26912710064','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-03670','2026-08-28','2026-08-28','17:24:39','PLG0015015','SULIS','2026-09-22','kasirbip','2026-08-28 17:24:39','2.000','0','0','0','800000','0','0','800000','800000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0006';
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-260828-0007','sby','1',' 800K-19-00','TOKO','SBYPER','PSBY-ZHAC-22-0','CINCIN SILVER 925 ','','3.230','1','100.00','330000','0','0','17800','900000','0','0','0','900000','DIL','00046136','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZHAC-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSBY-ZHAC-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260828-0007','2026-08-28','3.230','2026-08-28','17:25:01','PLG0015016','900000','900000','0','900000','0','sby','2026-08-28 17:25:01','FJ-260828-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('2026-08-28','FJ-260828-0007','2026-08-28','17:25:01','DIL','900000','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-260828-0012','2026-08-28','2026-08-28 17:25:01','PENJUALAN : FJ-260828-0007','','TBC','900000','900000','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-260828-0013','D','2026-08-28','17:25:01','TBC','PENJUALAN','FJ-260828-0007','26912710064','900000','26913610064','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='900000' WHERE no_faktur_jual='FJ-260828-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0007';
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-20260828-0001','1','PJOG-ZHBF-44-0','1','2.190','2.190','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-44-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-44-0','1','2.190','2.190','1','2.190','2.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-45-0','1','2.160','2.160','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-45-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-45-0','1','2.160','2.160','1','2.160','2.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-45-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-46-0','1','2.210','2.210','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-46-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-46-0','1','2.210','2.210','1','2.210','2.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-46-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-47-0','1','1.710','1.710','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-47-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-47-0','1','1.710','1.710','1','1.710','1.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-47-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-48-0','1','1.310','1.310','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-48-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-48-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-48-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-48-0','1','1.310','1.310','1','1.310','1.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-48-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-49-0','1','1.750','1.750','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-49-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-49-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-49-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-49-0','1','1.750','1.750','1','1.750','1.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-49-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-50-0','1','3.620','3.620','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-50-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-50-0','1','3.620','3.620','1','3.620','3.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-50-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-51-0','1','2.600','2.600','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-51-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-51-0','1','2.600','2.600','1','2.600','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-51-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-52-0','1','1.620','1.620','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-52-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-52-0','1','1.620','1.620','1','1.620','1.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-52-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0001','1','PJOG-ZHBF-53-0','1','1.280','1.280','TOKO','JOGPER','PST','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBF-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBF-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBF-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 17:34:38' WHERE kode_barang='PJOG-ZHBF-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBF-53-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 ('2026-08-28 17:34:38','PST','JOGPER','PJOG','PJOG-ZHBF-53-0','1','1.280','1.280','1','1.280','1.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBF-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBF-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0001','2026-08-28','17:33','20.450','jogja','2026-08-28 17:34:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','17:41:02');
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-20260828-0002','1','PMM-ZHBH-70-0','1','2.180','2.180','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-70-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-70-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-70-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:16' WHERE kode_barang='PMM-ZHBH-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-70-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 ('2026-08-28 17:41:16','TOKO','MMPER','PMM','PMM-ZHBH-70-0','1','2.180','2.180','1','2.180','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-70-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-71-0','1','3.400','3.400','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-71-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-71-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-71-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:16' WHERE kode_barang='PMM-ZHBH-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-71-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 ('2026-08-28 17:41:16','TOKO','MMPER','PMM','PMM-ZHBH-71-0','1','3.400','3.400','1','3.400','3.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-71-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-72-0','1','2.360','2.360','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-72-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-72-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-72-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:16' WHERE kode_barang='PMM-ZHBH-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-72-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 ('2026-08-28 17:41:16','TOKO','MMPER','PMM','PMM-ZHBH-72-0','1','2.360','2.360','1','2.360','2.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-72-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-73-0','1','4.280','4.280','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-73-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-73-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-73-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:16' WHERE kode_barang='PMM-ZHBH-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-73-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 ('2026-08-28 17:41:16','TOKO','MMPER','PMM','PMM-ZHBH-73-0','1','4.280','4.280','1','4.280','4.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-73-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-74-0','1','4.680','4.680','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-74-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-74-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-74-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:16' WHERE kode_barang='PMM-ZHBH-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-74-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 ('2026-08-28 17:41:16','TOKO','MMPER','PMM','PMM-ZHBH-74-0','1','4.680','4.680','1','4.680','4.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-74-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-75-0','1','1.310','1.310','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-75-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-75-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-75-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:17' WHERE kode_barang='PMM-ZHBH-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-75-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 ('2026-08-28 17:41:17','TOKO','MMPER','PMM','PMM-ZHBH-75-0','1','1.310','1.310','1','1.310','1.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-75-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-76-0','1','1.150','1.150','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-76-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-76-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-76-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:17' WHERE kode_barang='PMM-ZHBH-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-76-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 ('2026-08-28 17:41:17','TOKO','MMPER','PMM','PMM-ZHBH-76-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-76-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-77-0','1','1.170','1.170','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-77-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-77-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-77-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:17' WHERE kode_barang='PMM-ZHBH-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-77-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 ('2026-08-28 17:41:17','TOKO','MMPER','PMM','PMM-ZHBH-77-0','1','1.170','1.170','1','1.170','1.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-77-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-78-0','1','2.180','2.180','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-78-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-78-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-78-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:17' WHERE kode_barang='PMM-ZHBH-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-78-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 ('2026-08-28 17:41:17','TOKO','MMPER','PMM','PMM-ZHBH-78-0','1','2.180','2.180','1','2.180','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-78-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0002','1','PMM-ZHBH-79-0','1','2.600','2.600','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHBH-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-79-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHBH-79-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHBH-79-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-28 17:41:17' WHERE kode_barang='PMM-ZHBH-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHBH-79-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 ('2026-08-28 17:41:17','TOKO','MMPER','PMM','PMM-ZHBH-79-0','1','2.600','2.600','1','2.600','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' 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='PMM-ZHBH-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHBH-79-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0002','2026-08-28','17:41','25.310','kasir','2026-08-28 17:41:16');
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-20260828-0003','1','PSPRT-ZHBH-16-0','1','2.460','2.460','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-16-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-16-0','1','2.460','2.460','1','2.460','2.460','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-ZHBH-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-17-0','1','3.680','3.680','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-17-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-17-0','1','3.680','3.680','1','3.680','3.680','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-ZHBH-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-18-0','1','3.240','3.240','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-18-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-18-0','1','3.240','3.240','1','3.240','3.240','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-ZHBH-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-19-0','1','3.040','3.040','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-19-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-19-0','1','3.040','3.040','1','3.040','3.040','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-ZHBH-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-80-0','1','4.540','4.540','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-80-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-80-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-80-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-80-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-80-0','1','4.540','4.540','1','4.540','4.540','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-ZHBH-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-80-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-81-0','1','4.010','4.010','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-81-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-81-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-81-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-81-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-81-0','1','4.010','4.010','1','4.010','4.010','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-ZHBH-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-81-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-82-0','1','3.270','3.270','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-82-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-82-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-82-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-82-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-82-0','1','3.270','3.270','1','3.270','3.270','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-ZHBH-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-82-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0003','1','PSPRT-ZHBH-83-0','1','3.050','3.050','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHBH-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-83-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHBH-83-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHBH-83-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-28 17:42:04' WHERE kode_barang='PSPRT-ZHBH-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHBH-83-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 ('2026-08-28 17:42:04','TOKO','MMPSN','PSPRT','PSPRT-ZHBH-83-0','1','3.050','3.050','1','3.050','3.050','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-ZHBH-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHBH-83-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0003','2026-08-28','17:41','27.290','kasir','2026-08-28 17:42:03');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-08-28',  status ='CLOS' WHERE no_service='SV-02217';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02217';
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-03671','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','sz 9 putih glossy 19 zirkon','font yeseva one grf Zufar','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0013','2026-08-28','2026-08-28 17:58:30','PESANAN : DP-03671','.','TBC','1000000','1000000');
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-260828-0014','D','2026-08-28','17:58:30','TBC','PESANAN','DP-03671','26913610064','1000000','26914610064','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-03671','2026-08-28','2026-08-28','17:58:30','PLG0015017','KUR','2026-09-27','kasirbip','2026-08-28 17:58:30','3.000','0','0','0','1000000','0','0','1000000','1000000','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-03671','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','sz 9 putih glossy 19 zirkon','font yeseva one grf Zufar','','0','0','');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','17:58:53');
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-03672','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 21 putih doff amplas','font yeseva one grf Sheryl','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0014','2026-08-28','2026-08-28 18:02:31','PESANAN : DP-03672','.','TBC','900000','900000');
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-260828-0015','D','2026-08-28','18:02:31','TBC','PESANAN','DP-03672','26914610064','900000','26915510064','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-03672','2026-08-28','2026-08-28','18:02:31','PLG0015019','KUR','2026-09-27','kasirbip','2026-08-28 18:02:31','3.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','18:02:46');
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-260828-0008','kasirbip','1',' DP-03226DU','TOKO','DUPSN','PSPRT-ZHBF-4-0','CINCIN PERAK ','','2.210','1','100.00','226000','0','0','17800','900000','0','0','0','900000','KUR','00046510','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260828-0008','2026-08-28','2.210','2026-08-28','18:07:02','PLG0015020','900000','900000','0','900000','0','kasirbip','2026-08-28 18:07:02','FJ-260828-0008','DP-03226','400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0008','2026-08-28','18:07:02','KUR','900000','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-260828-0015','2026-08-28','2026-08-28 18:07:02','PENJUALAN : FJ-260828-0008','.','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-260828-0016','D','2026-08-28','18:07:02','TBC','PENJUALAN','FJ-260828-0008','26915510064','500000','26916010064','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-260828-0008' 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-260828-0009','kasirbip',' 1',' DP-03227DU','TOKO','DUPSN','PSPRT-ZHBF-1-0','CINCIN PERAK ','','3.300','1','100.00','337000','0','0','17800','800000','0','0','0','800000','KUR','00046507','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.300',berat_jual_asli=berat_jual_asli+'3.300',stock_jual='1',berat_akhir=berat_akhir-'3.300',berat_akhir_asli=berat_akhir_asli-'3.300',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260828-0009','2026-08-28','3.300','2026-08-28','18:07:02','PLG0015021','800000','800000','0','800000','0','kasirbip','2026-08-28 18:07:02','FJ-260828-0008','DP-03227','500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0009','2026-08-28','18:07:02','KUR','800000','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-260828-0016','2026-08-28','2026-08-28 18:07:02','PENJUALAN : FJ-260828-0009','.','TBC','300000','300000','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-260828-0017','D','2026-08-28','18:07:02','TBC','PENJUALAN','FJ-260828-0009','26916010064','300000','26916310064','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='800000' WHERE no_faktur_jual='FJ-260828-0009' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','18:19:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','18:21:43');
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-20260828-0004','1','LXPER-ZHBH-30-0','1','2.040','2.040','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-30-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-30-0','1','2.040','2.040','1','2.040','2.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-31-0','1','3.810','3.810','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-31-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-31-0','1','3.810','3.810','1','3.810','3.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-32-0','1','2.840','2.840','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-32-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-32-0','1','2.840','2.840','1','2.840','2.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-33-0','1','1.660','1.660','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-33-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-33-0','1','1.660','1.660','1','1.660','1.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-34-0','1','4.240','4.240','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-34-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-34-0','1','4.240','4.240','1','4.240','4.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-35-0','1','3.030','3.030','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-35-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-35-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-36-0','1','4.090','4.090','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-36-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-36-0','1','4.090','4.090','1','4.090','4.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-37-0','1','1.840','1.840','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-37-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-37-0','1','1.840','1.840','1','1.840','1.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-38-0','1','1.220','1.220','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-38-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-38-0','1','1.220','1.220','1','1.220','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0004','1','LXPER-ZHBH-39-0','1','2.370','2.370','TOKO','DUPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHBH-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHBH-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHBH-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:25:03' WHERE kode_barang='LXPER-ZHBH-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHBH-39-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 ('2026-08-28 18:25:03','TOKO','JOGPER','LXPER','LXPER-ZHBH-39-0','1','2.370','2.370','1','2.370','2.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZHBH-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHBH-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0004','2026-08-28','18:24','27.140','jogja','2026-08-28 18:25:03');
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-20260828-0005','1','PJOG-ZHBH-50-0','1','2.710','2.710','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-50-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-50-0','1','2.710','2.710','1','2.710','2.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-50-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-51-0','1','2.320','2.320','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-51-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-51-0','1','2.320','2.320','1','2.320','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-51-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-52-0','1','2.680','2.680','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-52-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-52-0','1','2.680','2.680','1','2.680','2.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-52-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-53-0','1','4.780','4.780','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-53-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-53-0','1','4.780','4.780','1','4.780','4.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-54-0','1','3.170','3.170','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-54-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-54-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-54-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-54-0','1','3.170','3.170','1','3.170','3.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-54-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-55-0','1','2.800','2.800','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-55-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-55-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-55-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-55-0','1','2.800','2.800','1','2.800','2.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-55-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-56-0','1','1.720','1.720','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-56-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-56-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-56-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-56-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-56-0','1','1.720','1.720','1','1.720','1.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-56-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-57-0','1','1.480','1.480','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-57-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-57-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-57-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-57-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-57-0','1','1.480','1.480','1','1.480','1.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-57-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-58-0','1','2.580','2.580','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-58-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-58-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-58-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-58-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-58-0','1','2.580','2.580','1','2.580','2.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZHBH-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-58-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' 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-20260828-0005','1','PJOG-ZHBH-59-0','1','1.880','1.880','TOKO','JOGPER','TOKO','JOGPER');
DELETE FROM tm_barang WHERE kode_barang='PJOG-ZHBH-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-59-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZHBH-59-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZHBH-59-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-08-28 18:26:20' WHERE kode_barang='PJOG-ZHBH-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZHBH-59-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 ('2026-08-28 18:26:20','TOKO','JOGPER','PJOG','PJOG-ZHBH-59-0','1','1.880','1.880','1','1.880','1.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','18:26:43');
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PJOG-ZHBH-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZHBH-59-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0005','2026-08-28','18:26','26.120','jogja','2026-08-28 18:26:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','18:27:33');
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-260828-0010','kasirbip','1',' DP-03178DU','TOKO','DUPSN','PSPRT-ZHBD-2-0','CINCIN PERAK YL01 ','','1.870','1','100.00','191000','0','0','17800','650000','0','0','0','650000','PUT','00046320','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBD-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBD-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260828-0010','2026-08-28','1.870','2026-08-28','18:27:44','PLG0015022','650000','650000','0','650000','0','kasirbip','2026-08-28 18:27:43','FJ-260828-0010','DP-03178','650000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0010','2026-08-28','18:27:44','PUT','650000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0010' 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-260828-0011','kasirbip',' 1',' DP-03179DU','TOKO','DUPSN','PSPRT-ZHBD-3-0','CINCIN PERAK YL01 ','','2.000','1','100.00','204000','0','0','17800','650000','0','0','0','650000','PUT','00046321','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBD-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBD-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260828-0011','2026-08-28','2.000','2026-08-28','18:27:44','PLG0015023','650000','650000','0','650000','0','kasirbip','2026-08-28 18:27:43','FJ-260828-0010','DP-03179','650000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0011','2026-08-28','18:27:44','PUT','650000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0011' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','18:32:57');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0011';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','19:03:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','19:04:28');
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-260828-0012','jogja','1',' 500K-21-00','TOKO','JOGPER','PJOG-ZHBF-44-0','CINCIN SILVER 925 YL01 ','','2.190','1','100.00','224000','0','0','17800','650000','0','0','0','650000','ADL','00046550','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZHBF-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PJOG-ZHBF-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-260828-0012','2026-08-28','2.190','2026-08-28','19:09:22','PLG0015024','650000','650000','0','650000','0','jogja','2026-08-28 19:09:22','FJ-260828-0012','','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('2026-08-28','FJ-260828-0012','2026-08-28','19:09:22','ADL','650000','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-260828-0017','2026-08-28','2026-08-28 19:09:22','PENJUALAN : FJ-260828-0012','','TBC','650000','650000','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-260828-0018','D','2026-08-28','19:09:22','TBC','PENJUALAN','FJ-260828-0012','26916310064','650000','26916960064','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='650000' WHERE no_faktur_jual='FJ-260828-0012' 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-260828-0013','kasirbip','1',' DP-03454DU','TOKO','DUPSN','PSPRT-ZHBF-66-0','1PS CINCIN PERAK ','','5.770','1','100.00','589000','0','0','17800','1500000','0','0','0','1500000','PUT','00046572','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.770',berat_jual_asli=berat_jual_asli+'5.770',stock_jual='1',berat_akhir=berat_akhir-'5.770',berat_akhir_asli=berat_akhir_asli-'5.770',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-66-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260828-0013','2026-08-28','5.770','2026-08-28','19:26:40','PLG0015025','1500000','1500000','0','1500000','0','kasirbip','2026-08-28 19:26:39','FJ-260828-0013','DP-03454','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0013','2026-08-28','19:26:40','PUT','1500000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0013';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','19:28:40');
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-03673','NAD','1','GOLD','WEDRING','','','2.000','','37.50','1','2400000','1400000','0','800000','3600000','size 10.5 crom putih glossy','Grf Aditya Font Berkshire','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0018','2026-08-28','2026-08-28 19:34:03','PESANAN : DP-03673','.','TBC','2880000','2880000');
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-260828-0019','D','2026-08-28','19:34:03','TBC','PESANAN','DP-03673','26916960064','2880000','26919840064','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-03673','2026-08-28','2026-08-28','19:34:03','PLG0015026','NAD','2026-09-22','kasirbip','2026-08-28 19:34:03','2.000','0','0','0','2880000','0','800000','3600000','3600000','720000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-28 ','19:38:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-28 ','19:44:27');
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-260828-0014','sby','1',' DP-03277SB','TOKO','SBYPSN','PSPRT-ZHBF-68-0','CINCIN PERAK ','','2.870','1','100.00','293000','0','0','17800','800000','0','0','0','800000','DIL','00046574','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-68-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260828-0014','2026-08-28','2.870','2026-08-28','19:47:55','PLG0015027','800000','800000','0','800000','0','sby','2026-08-28 19:47:55','FJ-260828-0014','DP-03277','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0014','2026-08-28','19:47:55','DIL','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0014' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','19:52:21');
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-260828-0015','sby','1',' DP-03270SB','TOKO','SBYPSN','PSPRT-ZHBF-8-0','1PS CINCIN PERAK ','','3.470','1','100.00','354000','0','0','17800','1600000','0','0','0','1600000','DIL','00046514','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='PSPRT-ZHBF-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260828-0015','2026-08-28','3.470','2026-08-28','19:59:28','PLG0015028','1600000','1600000','0','1600000','0','sby','2026-08-28 19:59:28','FJ-260828-0015','DP-03270','1600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','FJ-260828-0015','2026-08-28','19:59:28','DIL','1600000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260828-0015' 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-260828-0016','kasirbip','1',' 750K-125 ','TOKO','BIPCMP','BDCM-ZFAE-16-0','CINCIN EMAS ','','1.720','1','45.00','1896000','0','0','17800','3158000','0','0','0','3158000','SAL','00044423','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZFAE-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='BDCM-ZFAE-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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-260828-0016','2026-08-28','1.720','2026-08-28','20:12:23','PLG0015029','3158000','3158000','0','3158000','0','kasirbip','2026-08-28 20:12:23','FJ-260828-0016','','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('2026-08-28','FJ-260828-0016','2026-08-28','20:12:23','SAL','3158000','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-260828-0019','2026-08-28','2026-08-28 20:12:23','PENJUALAN : FJ-260828-0016','.','TBC','3158000','3158000','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-260828-0020','D','2026-08-28','20:12:23','TBC','PENJUALAN','FJ-260828-0016','26919840064','3158000','26922998064','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='3158000' WHERE no_faktur_jual='FJ-260828-0016' LIMIT 1;
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-03674','VAN','1','PER','WEDDRING SEPAKET CP11','','','3.000','','925.00','1','100000','0','1600000','0','1600000','SIZE WANITA:13 SIZE PRIA:19.5','GRF WANITA: Rian?? GRF PRIA:Ica??','FONT: YESEVA PUTIH','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260828-0020','2026-08-28','2026-08-28 20:22:25','PESANAN : DP-03674','-','TBC','1600000','1600000');
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-260828-0021','D','2026-08-28','20:22:25','TBC','PESANAN','DP-03674','26922998064','1600000','26924598064','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-03674','2026-08-28','2026-08-28','20:22:25','PLG0015030','VAN','2026-09-17','sby','2026-08-28 20:22:25','3.000','0','0','0','1600000','0','0','1600000','1600000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260828-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260828-0016';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-28 ','20:58:24');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-28';
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='2026-08-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-28' 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-260829-0001','D','2026-08-29','21:07:29','TBC','SALDO AWAL','SALDO AWAL','0','26924598064','26924598064');
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-260829-0001','D','2026-08-29','21:07:29','BCD','SALDO AWAL','SALDO AWAL','0','1454669500','1454669500');
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-260829-0001','D','2026-08-29','21:07:29','BCK','SALDO AWAL','SALDO AWAL','0','2007408000','2007408000');
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-260829-0001','D','2026-08-29','21:07:29','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-260829-0001','D','2026-08-29','21:07:29','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-260829-0001','D','2026-08-29','21:07:29','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-260829-0001','D','2026-08-29','21:07:29','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
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-260829-0001','D','2026-08-29','21:07:29','','SALDO AWAL','SALDO AWAL','0','250000','250000');
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-260829-0001','D','2026-08-29','21:07:29','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-260829-0001','D','2026-08-29','21:07:29','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
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-260829-0001','D','2026-08-29','21:07:29','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-260829-0001','D','2026-08-29','21:07:29','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
UPDATE tp_system SET tgl_system='2026-08-29';