INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','08:32:25');
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-20261006-0001','1','PMM-ZJXE-33-0','1','2.910','2.910','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZJXE-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJXE-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJXE-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-06 08:32:43' WHERE kode_barang='PMM-ZJXE-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJXE-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-10-06 08:32:43','TOKO','MMPER','PMM','PMM-ZJXE-33-0','1','2.910','2.910','1','2.910','2.910','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-ZJXE-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0001','1','PMM-ZJXE-34-0','1','3.690','3.690','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZJXE-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJXE-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJXE-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-06 08:32:43' WHERE kode_barang='PMM-ZJXE-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJXE-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-10-06 08:32:43','TOKO','MMPER','PMM','PMM-ZJXE-34-0','1','3.690','3.690','1','3.690','3.690','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-ZJXE-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0001','1','PMM-ZJXE-35-0','1','3.160','3.160','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZJXE-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJXE-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJXE-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-06 08:32:43' WHERE kode_barang='PMM-ZJXE-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJXE-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-10-06 08:32:43','TOKO','MMPER','PMM','PMM-ZJXE-35-0','1','3.160','3.160','1','3.160','3.160','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-ZJXE-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:32','9.760','kasir','2026-10-06 08:32:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','10:55:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-06 ','10:59:16');
UPDATE tt_service_head SET tgl_selesai='2026-10-06',  status ='DONE' WHERE no_service='SV-02261';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02261';
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-10-06',  status ='CLOS' WHERE no_service='SV-02261';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02261';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','11:21:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-06 ','11:31: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-261006-0001','kasirbip','1',' DP-03923DU','TOKO','DUPSN','PSPRT-ZIBI-23-0','CINCIN PERAK SR03 YL01 ','','3.510','1','100.00','359000','0','0','17800','950000','0','0','0','950000','PUT','00047762','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPRT-ZIBI-23-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-261006-0001','2026-10-06','3.510','2026-10-06','11:32:06','PLG0016990','950000','950000','0','950000','0','kasirbip','2026-10-06 11:32:06','FJ-261006-0001','DP-03923','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-10-06','FJ-261006-0001','2026-10-06','11:32:06','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-261006-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','11:33:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-06 ','11:38:26');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0001';
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-04430','ADL','1','PER','WEDDRING','','','4.000','','925.00','2','100000','0','1600000','0','1600000','sz cwo 16 sz cwe 11 5','gf Yesava : Farid...Retno','warna white','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-261006-0001','2026-10-06','2026-10-06 11:41:07','PESANAN : DP-04430','-','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-261006-0002','D','2026-10-06','11:41:07','TBC','PESANAN','DP-04430','28961008964','1600000','28962608964','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-04430','2026-10-06','2026-10-06','11:41:07','PLG0016991','ADL','2026-10-28','jogja','2026-10-06 11:41:07','4.000','0','0','0','1600000','0','0','1600000','1600000','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-04431','KUR','1','GOLD','WED RING','','','3.500','','37.50','1','2300000','1400000','0','1000000','5900000','sz 19.5 putih glossy 18 zirkon','font brush script grf Arianto','EXPRESS 100.000 bayar diakhir','180000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261006-0002','2026-10-06','2026-10-06 11:47:29','PESANAN : DP-04431','.','TBC','4860000','4860000');
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-261006-0003','D','2026-10-06','11:47:29','TBC','PESANAN','DP-04431','28962608964','4860000','28967468964','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-04431','2026-10-06','2026-10-06','11:47:29','PLG0016992','KUR','2026-10-19','kasirbip','2026-10-06 11:47:29','3.500','0','0','0','4860000','0','1000000','6080000','6080000','1220000');
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-04432','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz 18 putih doff semprot','font brush script grf Santi 25-10-2026','EXPRESS 100.000 bayar diakhir','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261006-0003','2026-10-06','2026-10-06 11:49:58','PESANAN : DP-04432','.','TBC','1480000','1480000');
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-261006-0004','D','2026-10-06','11:49:58','TBC','PESANAN','DP-04432','28967468964','1480000','28968948964','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-04432','2026-10-06','2026-10-06','11:49:58','PLG0016993','KUR','2026-10-19','kasirbip','2026-10-06 11:49:58','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','13:01:31');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261006-0002','kasir','1',' TFKMR75-91','TOKO','TFKMP','TFKMR-XAAX-25-0','THIFA KALUNG MAS RG ','','3.080','1','91.00','6795000','0','0','17800','6880000','0','0','0','6880000','RISIANA','00025699','TFKMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFKMR-XAAX-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='TFKMR-XAAX-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFKMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261006-0002','2026-10-06','3.080','2026-10-06','13:07:14','PLG0016994','6880000','6880000','0','6880000','0','kasir','2026-10-06 13:07:14','FJ-261006-0002','','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-10-06','FJ-261006-0002','2026-10-06','13:07:14','RISIANA','6880000','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-261006-0004','2026-10-06','2026-10-06 13:07:14','PENJUALAN : FJ-261006-0002','.','TBC','6880000','6880000','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-261006-0005','D','2026-10-06','13:07:14','TBC','PENJUALAN','FJ-261006-0002','28968948964','6880000','28975828964','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='6880000' WHERE no_faktur_jual='FJ-261006-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','13:09:03');
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-261006-0003','kasirbip','1',' 850K-18-00','TOKO','DUPERBDG','LXPER-ZGBA-68-0','CINCIN SILVER 925 ','','3.430','1','100.00','350000','0','0','17800','950000','0','0','0','950000','PUT','00045461','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGBA-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.430',berat_jual_asli=berat_jual_asli+'3.430',stock_jual='1',berat_akhir=berat_akhir-'3.430',berat_akhir_asli=berat_akhir_asli-'3.430',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='LXPER-ZGBA-68-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-261006-0003','2026-10-06','3.430','2026-10-06','13:19:54','PLG0016995','950000','950000','0','950000','0','kasirbip','2026-10-06 13:19:54','FJ-261006-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','FJ-261006-0003','2026-10-06','13:19:54','PUT','950000','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-261006-0005','2026-10-06','2026-10-06 13:19:54','PENJUALAN : FJ-261006-0003','.','TBC','950000','950000','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-261006-0006','D','2026-10-06','13:19:54','TBC','PENJUALAN','FJ-261006-0003','28975828964','950000','28976778964','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='950000' WHERE no_faktur_jual='FJ-261006-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-06 ','13:41:47');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-06 ','13:50:23');
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-261006-0004','kasirbip','1',' DP-03913BI','TOKO','BIPPSN','PSPRT-ZIBE-4-0','CINCIN PERAK ','','2.220','1','100.00','227000','0','0','17800','900000','0','0','0','900000','KUR','00047584','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBE-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPRT-ZIBE-4-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-261006-0004','2026-10-06','2.220','2026-10-06','13:50:58','PLG0016996','900000','900000','0','900000','0','kasirbip','2026-10-06 13:50:57','FJ-261006-0004','DP-03913','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-10-06','FJ-261006-0004','2026-10-06','13:50:58','KUR','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-261006-0004' LIMIT 1;
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-05';
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-10-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','13:55:14');
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-261006-0005','kasir','1',' 1.2K-16-80','TOKO','MMPER','PMM-ZBAA-7-0','CINCIN SILVER 925 ','','2.470','1','100.00','253000','0','0','17800','1250000','0','0','0','1250000','ELLA','00041496','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBAA-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.470',berat_jual_asli=berat_jual_asli+'2.470',stock_jual='1',berat_akhir=berat_akhir-'2.470',berat_akhir_asli=berat_akhir_asli-'2.470',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PMM-ZBAA-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261006-0005','2026-10-06','2.470','2026-10-06','13:56:57','PLG0016997','1250000','1250000','0','1250000','0','kasir','2026-10-06 13:56:56','FJ-261006-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','FJ-261006-0005','2026-10-06','13:56:57','ELLA','1250000','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-261006-0006','2026-10-06','2026-10-06 13:56:56','PENJUALAN : FJ-261006-0005','0','TBC','1250000','1250000','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-261006-0007','D','2026-10-06','13:56:57','TBC','PENJUALAN','FJ-261006-0005','28976778964','1250000','28978028964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1250000' WHERE no_faktur_jual='FJ-261006-0005' 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-261006-0006','kasir',' 1',' 750K-16-12','TOKO','MMPER','PMM-ZIBH-61-0','CINCIN SILVER 925 ','','2.640','1','100.00','270000','0','0','17800','850000','0','0','0','850000','ELLA','00047725','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZIBH-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PMM-ZIBH-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261006-0006','2026-10-06','2.640','2026-10-06','13:56:57','PLG0016998','850000','850000','0','850000','0','kasir','2026-10-06 13:56:56','FJ-261006-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','FJ-261006-0006','2026-10-06','13:56:57','ELLA','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-261006-0007','2026-10-06','2026-10-06 13:56:56','PENJUALAN : FJ-261006-0006','0','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-261006-0008','D','2026-10-06','13:56:57','TBC','PENJUALAN','FJ-261006-0006','28978028964','850000','28978878964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2100000' WHERE no_faktur_jual='FJ-261006-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0006';
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-20261006-0002','1','LXPER-ZJXE-25-0','1','3.320','3.320','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJXE-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJXE-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJXE-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-06 14:31:52' WHERE kode_barang='LXPER-ZJXE-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJXE-25-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-10-06 14:31:52','TOKO','DUPERBDG','LXPER','LXPER-ZJXE-25-0','1','3.320','3.320','1','3.320','3.320','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-ZJXE-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0002','1','LXPER-ZJXE-26-0','1','2.880','2.880','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJXE-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJXE-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJXE-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-06 14:31:52' WHERE kode_barang='LXPER-ZJXE-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJXE-26-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-10-06 14:31:52','TOKO','DUPERBDG','LXPER','LXPER-ZJXE-26-0','1','2.880','2.880','1','2.880','2.880','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-ZJXE-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0002','1','LXPER-ZJXE-27-0','1','3.990','3.990','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJXE-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJXE-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJXE-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-06 14:31:52' WHERE kode_barang='LXPER-ZJXE-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJXE-27-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-10-06 14:31:52','TOKO','DUPERBDG','LXPER','LXPER-ZJXE-27-0','1','3.990','3.990','1','3.990','3.990','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-ZJXE-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0002','1','LXPER-ZJXE-28-0','1','3.720','3.720','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJXE-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJXE-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJXE-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-06 14:31:52' WHERE kode_barang='LXPER-ZJXE-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJXE-28-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-10-06 14:31:52','TOKO','DUPERBDG','LXPER','LXPER-ZJXE-28-0','1','3.720','3.720','1','3.720','3.720','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-ZJXE-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0002','1','LXPER-ZJXE-42-0','1','1.980','1.980','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJXE-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJXE-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJXE-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-06 14:31:52' WHERE kode_barang='LXPER-ZJXE-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJXE-42-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-10-06 14:31:52','TOKO','DUPERBDG','LXPER','LXPER-ZJXE-42-0','1','1.980','1.980','1','1.980','1.980','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-ZJXE-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0002','1','LXPER-ZJXE-43-0','1','2.250','2.250','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJXE-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJXE-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJXE-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-06 14:31:52' WHERE kode_barang='LXPER-ZJXE-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJXE-43-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-10-06 14:31:52','TOKO','DUPERBDG','LXPER','LXPER-ZJXE-43-0','1','2.250','2.250','1','2.250','2.250','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-ZJXE-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJXE-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0002','2026-10-06','14:28','18.140','kasirbip','2026-10-06 14:31:52');
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-20261006-0003','1','PSPRT-ZJXE-8-0','1','3.200','3.200','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXE-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXE-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXE-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-06 14:38:35' WHERE kode_barang='PSPRT-ZJXE-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXE-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 14:38:35','TOKO','DUPSN','PSPRT','PSPRT-ZJXE-8-0','1','3.200','3.200','1','3.200','3.200','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-ZJXE-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0003','2026-10-06','14:37','3.200','kasirbip','2026-10-06 14:38:35');
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-261006-0007','kasirbip','1',' DP-03850BI','TOKO','BIPPSN','PSGT-ZIBI-4-0','CINCIN EMAS ','','2.040','1','57.00','2728000','0','0','17800','4592000','0','0','0','4592000','SULIS','00047743','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBI-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSGT-ZIBI-4-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-261006-0007','2026-10-06','2.040','2026-10-06','14:54:48','PLG0016999','4592000','4592000','0','4592000','0','kasirbip','2026-10-06 14:54:48','FJ-261006-0007','DP-03850','4336000');
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-10-06','FJ-261006-0007','2026-10-06','14:54:48','SULIS','4592000','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-261006-0008','2026-10-06','2026-10-06 14:54:48','PENJUALAN : FJ-261006-0007','.','TBC','256000','256000','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-261006-0009','D','2026-10-06','14:54:48','TBC','PENJUALAN','FJ-261006-0007','28978878964','256000','28979134964','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='256000' WHERE no_faktur_jual='FJ-261006-0007' 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-261006-0008','kasirbip',' 1',' DP-03849BI','TOKO','BIPPSN','PSPRT-ZIBE-7-0','CINCIN PERAK ','','3.750','1','100.00','383000','0','0','17800','900000','0','0','0','900000','SULIS','00047587','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBE-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.750',berat_jual_asli=berat_jual_asli+'3.750',stock_jual='1',berat_akhir=berat_akhir-'3.750',berat_akhir_asli=berat_akhir_asli-'3.750',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPRT-ZIBE-7-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-261006-0008','2026-10-06','3.750','2026-10-06','14:54:48','PLG0017000','900000','900000','0','900000','0','kasirbip','2026-10-06 14:54:48','FJ-261006-0007','DP-03849','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-10-06','FJ-261006-0008','2026-10-06','14:54:48','SULIS','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='256000' WHERE no_faktur_jual='FJ-261006-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0008';
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-261006-0009','kasirbip','1',' 800K-21-00','TOKO','DUPERBDG','LXPER-ZJXE-28-0','CINCIN SILVER 925 ','','3.720','1','100.00','380000','0','0','17800','950000','0','0','0','950000','MIL','00047913','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJXE-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.720',berat_jual_asli=berat_jual_asli+'3.720',stock_jual='1',berat_akhir=berat_akhir-'3.720',berat_akhir_asli=berat_akhir_asli-'3.720',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='LXPER-ZJXE-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-261006-0009','2026-10-06','3.720','2026-10-06','15:07:27','PLG0017001','950000','950000','0','950000','0','kasirbip','2026-10-06 15:07:27','FJ-261006-0009','','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-10-06','FJ-261006-0009','2026-10-06','15:07:27','MIL','950000','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-261006-0009','2026-10-06','2026-10-06 15:07:27','PENJUALAN : FJ-261006-0009','.','TBC','950000','950000','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-261006-0010','D','2026-10-06','15:07:27','TBC','PENJUALAN','FJ-261006-0009','28979134964','950000','28980084964','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='950000' WHERE no_faktur_jual='FJ-261006-0009' 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-261006-0010','kasirbip',' 1',' 850K-12-00','TOKO','DUPERBDG','LXPER-ZEXF-47-0','CINCIN SILVER 925 ','','2.130','1','100.00','218000','0','0','17800','950000','0','0','0','950000','MIL','00043341','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEXF-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='LXPER-ZEXF-47-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-261006-0010','2026-10-06','2.130','2026-10-06','15:07:27','PLG0017002','950000','950000','0','950000','0','kasirbip','2026-10-06 15:07:27','FJ-261006-0009','','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-10-06','FJ-261006-0010','2026-10-06','15:07:27','MIL','950000','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-261006-0010','2026-10-06','2026-10-06 15:07:27','PENJUALAN : FJ-261006-0010','.','TBC','950000','950000','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-261006-0011','D','2026-10-06','15:07:27','TBC','PENJUALAN','FJ-261006-0010','28980084964','950000','28981034964','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='1900000' WHERE no_faktur_jual='FJ-261006-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0010';
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-04433','PUT','1','PLD','WEDRING','','','2.000','','10.00','1','1200000','350000','0','750000','1450000','sz cwe 10 crom putih glosy','grf Ahmad ..... Ainie','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-261006-0011','2026-10-06','2026-10-06 15:42:58','PESANAN : DP-04433','.','TBC','1160000','1160000');
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-261006-0012','D','2026-10-06','15:42:58','TBC','PESANAN','DP-04433','28981034964','1160000','28982194964','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-04433','2026-10-06','2026-10-06','15:42:58','PLG0017003','PUT','2026-10-28','kasirbip','2026-10-06 15:42:58','2.000','0','0','0','1160000','0','750000','1450000','1450000','290000');
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-04434','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwo 17 crom putih doff semprot','grf Ahmad ..... Ainie','font Berkshire CP.03','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-261006-0012','2026-10-06','2026-10-06 15:45:25','PESANAN : DP-04434','.','TBC','1440000','1440000');
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-261006-0013','D','2026-10-06','15:45:25','TBC','PESANAN','DP-04434','28982194964','1440000','28983634964','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-04434','2026-10-06','2026-10-06','15:45:25','PLG0017004','PUT','2026-10-28','kasirbip','2026-10-06 15:45:25','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-06 ','16:07:14');
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-04435','DIL','1','GOLD','WEDD RING WANITA','','','2.500','','37.50','1','2300000','1400000','0','850000','4350000','PERMATA 7 BUTIR','SIZE 15 GRF: Yogi Pramudya ?? (VINTAGE)','EMAS PUTIH','70000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261006-0013','2026-10-06','2026-10-06 16:11:46','PESANAN : DP-04435','-','TBC','2500000','2500000');
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-261006-0014','D','2026-10-06','16:11:46','TBC','PESANAN','DP-04435','28983634964','2500000','28986134964','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-04435','2026-10-06','2026-10-06','16:11:46','PLG0017005','DIL','2026-10-28','sby','2026-10-06 16:11:46','2.500','0','0','0','2500000','0','850000','4420000','4420000','1920000');
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-20261006-0004','1','PSGT-ZJXE-3-0','1','2.040','2.040','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJXE-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJXE-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJXE-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXE-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-06 16:29:04' WHERE kode_barang='PSGT-ZJXE-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJXE-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 16:29:04','TOKO','BIPPSN','PSGT','PSGT-ZJXE-3-0','1','2.040','2.040','1','2.040','2.040','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJXE-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXE-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0004','1','PSPRL-ZJXE-4-0','1','1.920','1.920','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRL-ZJXE-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRL-ZJXE-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRL-ZJXE-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRL-ZJXE-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-06 16:29:04' WHERE kode_barang='PSPRL-ZJXE-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRL-ZJXE-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 16:29:04','TOKO','BIPPSN','PSPRL','PSPRL-ZJXE-4-0','1','1.920','1.920','1','1.920','1.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRL' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRL' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRL-ZJXE-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRL-ZJXE-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0004','1','PSPRT-ZJXE-5-0','1','2.710','2.710','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXE-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXE-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXE-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-06 16:29:04' WHERE kode_barang='PSPRT-ZJXE-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXE-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 16:29:04','TOKO','BIPPSN','PSPRT','PSPRT-ZJXE-5-0','1','2.710','2.710','1','2.710','2.710','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-ZJXE-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0004','1','PSPLT-ZJXE-6-0','1','3.470','3.470','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJXE-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXE-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJXE-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXE-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-06 16:29:04' WHERE kode_barang='PSPLT-ZJXE-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJXE-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 16:29:04','TOKO','BIPPSN','PSPLT','PSPLT-ZJXE-6-0','1','3.470','3.470','1','3.470','3.470','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJXE-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXE-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0004','1','PSPLT-ZJXE-7-0','1','2.110','2.110','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJXE-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXE-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJXE-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXE-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-06 16:29:04' WHERE kode_barang='PSPLT-ZJXE-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJXE-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 16:29:04','TOKO','BIPPSN','PSPLT','PSPLT-ZJXE-7-0','1','2.110','2.110','1','2.110','2.110','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJXE-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXE-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0004','1','PSPLT-ZJXE-20-0','1','4.150','4.150','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJXE-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXE-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJXE-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXE-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-06 16:29:04' WHERE kode_barang='PSPLT-ZJXE-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJXE-20-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-10-06 16:29:04','TOKO','BIPPSN','PSPLT','PSPLT-ZJXE-20-0','1','4.150','4.150','1','4.150','4.150','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJXE-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXE-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0004','2026-10-06','16:28','16.400','kasirbip','2026-10-06 16:29:04');
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-20261006-0005','1','PBDG-ZJXE-21-0','1','2.930','2.930','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXE-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXE-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXE-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-06 16:29:36' WHERE kode_barang='PBDG-ZJXE-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXE-21-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-10-06 16:29:36','TOKO','BIPPER','PBDG','PBDG-ZJXE-21-0','1','2.930','2.930','1','2.930','2.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXE-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0005','1','PBDG-ZJXE-22-0','1','2.630','2.630','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXE-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXE-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXE-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-06 16:29:36' WHERE kode_barang='PBDG-ZJXE-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXE-22-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-10-06 16:29:36','TOKO','BIPPER','PBDG','PBDG-ZJXE-22-0','1','2.630','2.630','1','2.630','2.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXE-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0005','1','PBDG-ZJXE-23-0','1','3.640','3.640','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXE-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXE-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXE-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-06 16:29:36' WHERE kode_barang='PBDG-ZJXE-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXE-23-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-10-06 16:29:36','TOKO','BIPPER','PBDG','PBDG-ZJXE-23-0','1','3.640','3.640','1','3.640','3.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXE-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0005','1','PBDG-ZJXE-24-0','1','3.830','3.830','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXE-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXE-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXE-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-06 16:29:36' WHERE kode_barang='PBDG-ZJXE-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXE-24-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-10-06 16:29:36','TOKO','BIPPER','PBDG','PBDG-ZJXE-24-0','1','3.830','3.830','1','3.830','3.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXE-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXE-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0005','2026-10-06','16:29','13.030','kasirbip','2026-10-06 16:29:36');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0006','1','PLBDG-ZJXE-9-0','1','2.630','2.630','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-ZJXE-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-ZJXE-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-ZJXE-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-ZJXE-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2026-10-06 16:30:26' WHERE kode_barang='PLBDG-ZJXE-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-ZJXE-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 16:30:26','TOKO','BIPPLD','PLBDG','PLBDG-ZJXE-9-0','1','2.630','2.630','1','2.630','2.630','17.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-ZJXE-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZJXE-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0006','2026-10-06','16:29','2.630','kasirbip','2026-10-06 16:30:25');
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-261006-0011','sby','1',' DP-03943SB','TOKO','SBYPSN','PSPRT-ZICX-9-0','CINCIN PERAK ','','2.950','1','100.00','301000','0','0','17800','800000','0','0','0','800000','VAN','00047795','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZICX-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPRT-ZICX-9-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-261006-0011','2026-10-06','2.950','2026-10-06','17:06:19','PLG0017006','800000','800000','0','800000','0','sby','2026-10-06 17:06:19','FJ-261006-0011','DP-03943','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-10-06','FJ-261006-0011','2026-10-06','17:06:19','VAN','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-261006-0011' 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-261006-0012','sby',' 1',' DP-03944SB','TOKO','SBYPSN','PSPRT-ZIBI-46-0','CINCIN PERAK ','','1.810','1','100.00','185000','0','0','17800','950000','0','0','0','950000','VAN','00047785','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPRT-ZIBI-46-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-261006-0012','2026-10-06','1.810','2026-10-06','17:06:19','PLG0017007','950000','950000','0','950000','0','sby','2026-10-06 17:06:19','FJ-261006-0011','DP-03944','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-10-06','FJ-261006-0012','2026-10-06','17:06:19','VAN','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-261006-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-261006-0013','kasirbip','1',' 800K-20-29','TOKO','BIPPER','PBDG-ZIBB-10-0','CINCIN SILVER 925 ','','3.880','1','100.00','396000','0','0','17800','900000','0','0','0','900000','KUR','00047443','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBB-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PBDG-ZIBB-10-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-261006-0013','2026-10-06','3.880','2026-10-06','17:09:53','PLG0017008','900000','900000','0','900000','0','kasirbip','2026-10-06 17:09:53','FJ-261006-0013','','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-10-06','FJ-261006-0013','2026-10-06','17:09:53','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-261006-0014','2026-10-06','2026-10-06 17:09:53','PENJUALAN : FJ-261006-0013','.','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-261006-0015','D','2026-10-06','17:09:53','TBC','PENJUALAN','FJ-261006-0013','28986134964','900000','28987034964','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-261006-0013' 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-261006-0014','kasirbip',' 1',' 750K-175-2','TOKO','BIPPER','PBDG-ZFAF-32-0','CINCIN SILVER 925 ','','1.990','1','100.00','203000','0','0','17800','850000','0','0','0','850000','KUR','00044462','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAF-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PBDG-ZFAF-32-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-261006-0014','2026-10-06','1.990','2026-10-06','17:09:53','PLG0017009','850000','850000','0','850000','0','kasirbip','2026-10-06 17:09:53','FJ-261006-0013','','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-10-06','FJ-261006-0014','2026-10-06','17:09:53','KUR','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-261006-0015','2026-10-06','2026-10-06 17:09:53','PENJUALAN : FJ-261006-0014','.','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-261006-0016','D','2026-10-06','17:09:53','TBC','PENJUALAN','FJ-261006-0014','28987034964','850000','28987884964','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='1750000' WHERE no_faktur_jual='FJ-261006-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0014';
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-04436','DEW','1','PER','WEDDINGRING','','','4.000','','925.00','2','100000','0','1300000','0','1300000','sz cwo 18 sz cwo 18','gf Vintage : Cwe: Rian... Cwo: Ari...','oversize cwe 18','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-261006-0016','2026-10-06','2026-10-06 18:38:36','PESANAN : DP-04436','-','TBC','1300000','1300000');
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-261006-0017','D','2026-10-06','18:38:36','TBC','PESANAN','DP-04436','28987884964','1300000','28989184964','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-04436','2026-10-06','2026-10-06','18:38:36','PLG0017010','DEW','2026-10-29','jogja','2026-10-06 18:38:36','4.000','0','0','0','1300000','0','0','1300000','1300000','0');
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-20261006-0007','1','PSBY-ZJXE-11-0','1','2.270','2.270','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-11-0','1','2.270','2.270','1','2.270','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-12-0','1','1.620','1.620','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-12-0','1','1.620','1.620','1','1.620','1.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-13-0','1','2.760','2.760','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-13-0','1','2.760','2.760','1','2.760','2.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-14-0','1','1.190','1.190','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-14-0','1','1.190','1.190','1','1.190','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-15-0','1','2.320','2.320','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-15-0','1','2.320','2.320','1','2.320','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-16-0','1','1.400','1.400','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-16-0','1','1.400','1.400','1','1.400','1.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-17-0','1','1.500','1.500','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-17-0','1','1.500','1.500','1','1.500','1.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-18-0','1','2.270','2.270','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-18-0','1','2.270','2.270','1','2.270','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-19-0','1','2.100','2.100','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-19-0','1','2.100','2.100','1','2.100','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-36-0','1','2.840','2.840','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-36-0','1','2.840','2.840','1','2.840','2.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-37-0','1','3.860','3.860','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-37-0','1','3.860','3.860','1','3.860','3.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' 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-20261006-0007','1','PSBY-ZJXE-38-0','1','3.490','3.490','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJXE-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJXE-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJXE-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-06 18:41:56' WHERE kode_barang='PSBY-ZJXE-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJXE-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-10-06 18:41:56','TOKO','SBYPER','PSBY','PSBY-ZJXE-38-0','1','3.490','3.490','1','3.490','3.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' 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='PSBY-ZJXE-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJXE-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0007','2026-10-06','18:33','27.620','sby','2026-10-06 18:41:56');
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-20261006-0008','1','PLSBY-ZJXE-10-0','1','2.130','2.130','TOKO','SBYPLD','TOKO','SBYPLD');
DELETE FROM tm_barang WHERE kode_barang='PLSBY-ZJXE-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLSBY-ZJXE-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLSBY-ZJXE-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLSBY-ZJXE-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPLD',tgl_last_beli='2026-10-06 18:43:18' WHERE kode_barang='PLSBY-ZJXE-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLSBY-ZJXE-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 18:43:18','TOKO','SBYPLD','PLSBY','PLSBY-ZJXE-10-0','1','2.130','2.130','1','2.130','2.130','17.00');
DELETE FROM tm_dept WHERE kode_dept='PLSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLSBY-ZJXE-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLSBY-ZJXE-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-06' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0008','2026-10-06','18:42','2.130','sby','2026-10-06 18:43:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','18:59:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-06 ','19:03:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-06 ','19:07:49');
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-261006-0015','kasir','1',' TFKMR75-82','TOKO','TFKMP','TFKMR-YLXD-21-0','THIFA KALUNG MAS RG ','','1.980','1','82.00','3975000','0','0','17800','4100000','0','0','0','4100000','RISIANA','00040201','TFKMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFKMR-YLXD-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='TFKMR-YLXD-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFKMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261006-0015','2026-10-06','1.980','2026-10-06','19:08:51','PLG0017011','4100000','4100000','0','4100000','0','kasir','2026-10-06 19:08:50','FJ-261006-0015','','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-10-06','FJ-261006-0015','2026-10-06','19:08:51','RISIANA','4100000','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-261006-0017','2026-10-06','2026-10-06 19:08:50','PENJUALAN : FJ-261006-0015','.','TBC','4100000','4100000','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-261006-0018','D','2026-10-06','19:08:51','TBC','PENJUALAN','FJ-261006-0015','28989184964','4100000','28993284964','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='4100000' WHERE no_faktur_jual='FJ-261006-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-261006-0016','kasir',' 1',' TFLMR75-83','TOKO','TFLMPK','TFLMR-XAAI-37-0','THIFA LIONTIN MAS RG ','','1.950','1','83.00','3924000','0','0','17800','4100000','0','0','0','4100000','RISIANA','00026060','TFLMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFLMR-XAAI-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='TFLMR-XAAI-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLMPK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261006-0016','2026-10-06','1.950','2026-10-06','19:08:51','PLG0017012','4100000','4100000','0','4100000','0','kasir','2026-10-06 19:08:50','FJ-261006-0015','','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-10-06','FJ-261006-0016','2026-10-06','19:08:51','RISIANA','4100000','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-261006-0018','2026-10-06','2026-10-06 19:08:50','PENJUALAN : FJ-261006-0016','.','TBC','4100000','4100000','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-261006-0019','D','2026-10-06','19:08:51','TBC','PENJUALAN','FJ-261006-0016','28993284964','4100000','28997384964','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='8200000' WHERE no_faktur_jual='FJ-261006-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0016';
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-04437','MIL','1','PER','WEDRING','','','5.000','','925.00','1','100000','0','1600000','0','1600000','sz cwe 13 grf Nanda Yusuf S','sz cwo 15.5 grf Dallia Aftiani R','font vladimir CP.07','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-261006-0019','2026-10-06','2026-10-06 19:33:11','PESANAN : DP-04437','.','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-261006-0020','D','2026-10-06','19:33:11','TBC','PESANAN','DP-04437','28997384964','1600000','28998984964','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-04437','2026-10-06','2026-10-06','19:33:11','PLG0017013','MIL','2026-10-28','kasirbip','2026-10-06 19:33:11','5.000','0','0','0','1600000','0','0','1600000','1600000','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-261006-0017','kasirbip','1',' PLBDG-0012','TOKO','BIPPLD','PLBDG-ZAAE-24-0','CINCIN PALADIUM PLBDG-00124 ','','2.300','1','5.00','313000','0','0','17800','1555000','0','0','0','1555000','SULIS','00040909','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZAAE-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PLBDG-ZAAE-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-261006-0017','2026-10-06','2.300','2026-10-06','19:34:33','PLG0017014','1555000','1555000','0','1555000','0','kasirbip','2026-10-06 19:34:32','FJ-261006-0017','','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-10-06','FJ-261006-0017','2026-10-06','19:34:33','SULIS','1555000','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-261006-0020','2026-10-06','2026-10-06 19:34:32','PENJUALAN : FJ-261006-0017','.','TBC','1555000','1555000','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-261006-0021','D','2026-10-06','19:34:33','TBC','PENJUALAN','FJ-261006-0017','28998984964','1555000','29000539964','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='1555000' WHERE no_faktur_jual='FJ-261006-0017' 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-261006-0018','kasirbip',' 1',' 800K-18-30','TOKO','BIPPER','PBDG-ZJXE-22-0','CINCIN SILVER 925 ','','2.630','1','100.00','269000','0','0','17800','950000','0','0','0','950000','SULIS','00047907','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZJXE-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PBDG-ZJXE-22-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-261006-0018','2026-10-06','2.630','2026-10-06','19:34:33','PLG0017015','950000','950000','0','950000','0','kasirbip','2026-10-06 19:34:32','FJ-261006-0017','','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-10-06','FJ-261006-0018','2026-10-06','19:34:33','SULIS','950000','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-261006-0021','2026-10-06','2026-10-06 19:34:32','PENJUALAN : FJ-261006-0018','.','TBC','950000','950000','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-261006-0022','D','2026-10-06','19:34:33','TBC','PENJUALAN','FJ-261006-0018','29000539964','950000','29001489964','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='2505000' WHERE no_faktur_jual='FJ-261006-0018' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02283','SULIS','1','PLD DAN SILVER','CWE PUTIH DOFF SEMPROT CWO PUTIH DOFF SEMPROT SZ 15 FONT VLADIMIR','4.900','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02283','2026-10-06','2026-10-06','19:36:13','PLG0017016','kasirbip','2026-10-15','kasirbip','2026-10-06 19:36:13','4.900','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-06 ','19:36:35');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0018';
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-04438','ALIKA','1','PER','PROMO CP 10 SILVER','','','3.000','','925.00','1','100000','0','0','0','1400000','cewe size 20 grf Apri crom putih upsize 100k','cowo size 18.5 grf Dakhtia crom 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-261006-0022','2026-10-06','2026-10-06 19:50:30','PESANAN : DP-04438','.','TBC','1400000','1400000');
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-261006-0023','D','2026-10-06','19:50:30','TBC','PESANAN','DP-04438','29001489964','1400000','29002889964','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-04438','2026-10-06','2026-10-06','19:50:30','PLG0017017','ALIKA','2026-10-28','kasir','2026-10-06 19:50:30','3.000','0','0','0','1400000','0','0','1400000','1400000','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-261006-0019','sby','1',' DP-03986SB','TOKO','SBYPSN','PSPLT-ZJXB-50-0','CINCIN PALADIUM ','','1.460','1','17.00','328000','0','0','17800','1641000','0','0','0','1641000','DIL','00047869','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPLT-ZJXB-50-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-261006-0019','2026-10-06','1.460','2026-10-06','19:52:19','PLG0017018','1641000','1641000','0','1641000','0','sby','2026-10-06 19:52:19','FJ-261006-0019','DP-03986','1400000');
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-10-06','FJ-261006-0019','2026-10-06','19:52:19','DIL','1641000','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-261006-0023','2026-10-06','2026-10-06 19:52:19','PENJUALAN : FJ-261006-0019','','TBC','241000','241000','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-261006-0024','D','2026-10-06','19:52:19','TBC','PENJUALAN','FJ-261006-0019','29002889964','241000','29003130964','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='241000' WHERE no_faktur_jual='FJ-261006-0019' 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-261006-0020','sby',' 1',' DP-03985SB','TOKO','SBYPSN','PSPRT-ZJXB-49-0','CINCIN PERAK ','','2.420','1','100.00','247000','0','0','17800','850000','0','0','0','850000','DIL','00047868','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXB-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='PSPRT-ZJXB-49-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-261006-0020','2026-10-06','2.420','2026-10-06','19:52:19','PLG0017019','850000','850000','0','850000','0','sby','2026-10-06 19:52:19','FJ-261006-0019','DP-03985','850000');
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-10-06','FJ-261006-0020','2026-10-06','19:52:19','DIL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='241000' WHERE no_faktur_jual='FJ-261006-0020' LIMIT 1;
UPDATE tt_service_head SET tgl_selesai='2026-10-06',  status ='DONE' WHERE no_service='SV-02268';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02268';
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-10-06',  status ='CLOS' WHERE no_service='SV-02268';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02268';
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-04439','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwe sz 13.5 up size 100.000 grf Hendarsyah','cwo sz 19 grf Hikmah','SR-02 & YL-01 font monotype corsiva','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261006-0024','2026-10-06','2026-10-06 20:23:05','PESANAN : DP-04439','.','TBC','950000','950000');
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-261006-0025','D','2026-10-06','20:23:05','TBC','PESANAN','DP-04439','29003130964','950000','29004080964','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-04439','2026-10-06','2026-10-06','20:23:05','PLG0017020','SULIS','2026-10-22','kasirbip','2026-10-06 20:23:05','2.000','0','0','0','950000','0','0','950000','950000','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-04440','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 27 putih glosy 1 zircon','font berkshire swash grf Ananda','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261006-0025','2026-10-06','2026-10-06 20:34:30','PESANAN : DP-04440','.','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-261006-0026','D','2026-10-06','20:34:30','TBC','PESANAN','DP-04440','29004080964','900000','29004980964','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-04440','2026-10-06','2026-10-06','20:34:30','PLG0017021','SAL','2026-11-05','kasirbip','2026-10-06 20:34:30','2.000','0','0','0','900000','0','0','900000','900000','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-04441','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 11 putih glosy. model spt contoh','font berkshire swash grf Amanda 17.01.27','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261006-0026','2026-10-06','2026-10-06 20:36:12','PESANAN : DP-04441','.','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-261006-0027','D','2026-10-06','20:36:12','TBC','PESANAN','DP-04441','29004980964','1000000','29005980964','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-04441','2026-10-06','2026-10-06','20:36:12','PLG0017022','SAL','2026-11-05','kasirbip','2026-10-06 20:36:12','2.000','0','0','0','1000000','0','0','1000000','1000000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261006-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261006-0020';
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-04442','VAN','1','PER','WEDDRING SEPAKET','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE WANITA: 13 SIZE PRIA: 12.5','GRF WANITA: ELKY?? GRF PRIA: TESA??','FONT: BERKSHIRE FINISHING : PUTIH GLOSSY','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-261006-0027','2026-10-06','2026-10-06 20:56:55','PESANAN : DP-04442','-','TBC','950000','950000');
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-261006-0028','D','2026-10-06','20:56:55','TBC','PESANAN','DP-04442','29005980964','950000','29006930964','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-04442','2026-10-06','2026-10-06','20:56:55','PLG0017023','VAN','2026-10-29','sby','2026-10-06 20:56:55','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-06';
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-10-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-06' 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-261007-0001','D','2026-10-07','21:07:31','TBC','SALDO AWAL','SALDO AWAL','0','29006930964','29006930964');
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-261007-0001','D','2026-10-07','21:07:31','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500');
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-261007-0001','D','2026-10-07','21:07:31','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
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-261007-0001','D','2026-10-07','21:07:31','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-261007-0001','D','2026-10-07','21:07:31','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-261007-0001','D','2026-10-07','21:07:31','','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-261007-0001','D','2026-10-07','21:07:31','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261007-0001','D','2026-10-07','21:07:31','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-261007-0001','D','2026-10-07','21:07:31','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-261007-0001','D','2026-10-07','21:07:31','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-261007-0001','D','2026-10-07','21:07:31','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-261007-0001','D','2026-10-07','21:07:31','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
UPDATE tp_system SET tgl_system='2026-10-07';