INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-11 ','08:21:08');
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-20260911-0001','1','PSPRT-ZIAX-4-0','1','2.630','2.630','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAX-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAX-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAX-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-11 08:21:28' WHERE kode_barang='PSPRT-ZIAX-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAX-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-09-11 08:21:28','TOKO','MMPSN','PSPRT','PSPRT-ZIAX-4-0','1','2.630','2.630','1','2.630','2.630','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-ZIAX-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0001','1','PSPRT-ZIAX-5-0','1','3.910','3.910','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAX-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAX-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAX-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-11 08:21:28' WHERE kode_barang='PSPRT-ZIAX-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAX-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-09-11 08:21:28','TOKO','MMPSN','PSPRT','PSPRT-ZIAX-5-0','1','3.910','3.910','1','3.910','3.910','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-ZIAX-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260911-0001','2026-09-11','08:21','6.540','kasir','2026-09-11 08:21:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-11 ','10:52:42');
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-09-11',  status ='CLOS' WHERE no_service='SV-02231';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02231';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-11 ','10:54:27');
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-03971','VAN','1','PER','WEDDRING SEPAKET CP 11','','','3.000','','925.00','1','100000','0','1600000','0','1600000','SIZE WANITA: 19 SIZE PRIA: 22','GRF WANITA: Anggelo?? GRF PRIA: Ulfa??','FONT: BERKSHIRE FINISHING: PUTIH','200000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260911-0001','2026-09-11','2026-09-11 10:58:09','PESANAN : DP-03971','-','TBC','1800000','1800000');
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-260911-0002','D','2026-09-11','10:58:09','TBC','PESANAN','DP-03971','27637931464','1800000','27639731464','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-03971','2026-09-11','2026-09-11','10:58:09','PLG0015695','VAN','2026-10-03','sby','2026-09-11 10:58:09','3.000','0','0','0','1800000','0','0','1800000','1800000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-11 ','13:01:28');
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-03972','SULIS','1','GOLD','WED RING','','','8.000','','75.00','1','2400000','2250000','0','1500000','19500000','54 zircon size 29.5','warna stacking rosegold glosy warna cincin tengah putih glos','','540000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260911-0002','2026-09-11','2026-09-11 13:03:29','PESANAN : DP-03972','.','TBC','16032000','16032000');
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-260911-0003','D','2026-09-11','13:03:29','TBC','PESANAN','DP-03972','27639731464','16032000','27655763464','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-03972','2026-09-11','2026-09-11','13:03:29','PLG0015696','SULIS','2026-10-11','kasirbip','2026-09-11 13:03:29','8.000','0','0','0','16032000','0','1500000','20040000','20040000','4008000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-11 ','13:05:45');
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-260911-0001','kasir','1',' TFGRR75-76','TOKO','TFGLR','TFGRR-ZIXH-17-0','THIFA GELANG RANTAI RG ','','3.390','1','76.00','6308000','0','0','17800','6800000','0','0','0','6800000','IQB','00047030','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-ZIXH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='TFGRR-ZIXH-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-260911-0001','2026-09-11','3.390','2026-09-11','13:27:04','PLG0015697','6800000','6800000','0','6800000','0','kasir','2026-09-11 13:27:03','FJ-260911-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-11','FJ-260911-0001','2026-09-11','13:27:04','IQB','6800000','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-260911-0003','2026-09-11','2026-09-11 13:27:03','PENJUALAN : FJ-260911-0001','.','TBC','6800000','6800000','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-260911-0004','D','2026-09-11','13:27:04','TBC','PENJUALAN','FJ-260911-0001','27655763464','6800000','27662563464','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='6800000' WHERE no_faktur_jual='FJ-260911-0001' 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-02244','SAL','1','CCN SILVER','SZ 12 PUTIH GLOSY GRF JGN HILANG','2.000','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-02244','2026-09-11','2026-09-11','13:32:59','PLG0015698','kasirbip','2026-09-26','kasirbip','2026-09-11 13:32:59','2.000','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-11 ','13:33:13');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000383','X-00000383','CINCIN TFC-21260','GR','---','TFC','BELI','BELI001','1440000','2026-09-11','0.590','1','kasir','2026-09-11 13:34:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFC';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000383','X-00000383');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260911-0001','FJ-241108-0002','ILUNG','1','BELI','BELI001','TFC', 'X-00000383', 'CINCIN TFC-21260','0.590','0.590','83.00','1800000','1440000','2440678','1','1440000','1440000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.590',berat_beli_asli=berat_beli_asli+'0.590',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.590',berat_akhir_asli=berat_akhir_asli+'0.590',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFC' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260911-0001','2026-09-11','2026-09-11','13:34:48','ILUNG','---','0.590','1440000','1440000','1440000','1440000','1440000','kasir','2026-09-11 13:34:49','FB-260911-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260911-0001','HANIFA DWI ANANDA PUTRI','JKT','','','0','kasir','2026-09-11 13:34:49');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260911-0004','2026-09-11','2026-09-11 13:34:49','PEMBELIAN UMUM : FB-260911-0001','.','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 ('KK-260911-0005','K','2026-09-11','13:34:48','TBC','PEMBELIAN UMUM','FB-260911-0001','27662563464','1440000','27661123464','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260911-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260911-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-11 ','13:43:56');
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-260911-0002','sby','1',' DP-03485SB','TOKO','SBYPSN','PSPLT-ZIXD-83-0','CINCIN PALADIUM ','','2.350','1','17.00','528000','0','0','17800','1913000','0','0','0','1913000','VAN','00046946','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPLT-ZIXD-83-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-260911-0002','2026-09-11','2.350','2026-09-11','13:48:02','PLG0015699','1913000','1913000','0','1913000','0','sby','2026-09-11 13:48:01','FJ-260911-0002','DP-03485','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-11','FJ-260911-0002','2026-09-11','13:48:02','VAN','1913000','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-260911-0005','2026-09-11','2026-09-11 13:48:01','PENJUALAN : FJ-260911-0002','','TBC','413000','413000','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-260911-0006','D','2026-09-11','13:48:02','TBC','PENJUALAN','FJ-260911-0002','27661123464','413000','27661536464','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='413000' WHERE no_faktur_jual='FJ-260911-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260911-0003','sby',' 1',' DP-03484SB','TOKO','SBYPSN','PSPRT-ZIXI-26-0','CINCIN PERAK ','','2.050','1','100.00','210000','0','0','17800','850000','0','0','0','850000','VAN','00047092','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXI-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPRT-ZIXI-26-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-260911-0003','2026-09-11','2.050','2026-09-11','13:48:02','PLG0015700','850000','850000','0','850000','0','sby','2026-09-11 13:48:01','FJ-260911-0002','DP-03484','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-09-11','FJ-260911-0003','2026-09-11','13:48:02','VAN','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='413000' WHERE no_faktur_jual='FJ-260911-0003' 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-260911-0004','sby','1',' DP-03657SB','TOKO','SBYPSN','PSGT-ZIXD-95-0','CINCIN EMAS ','','2.640','1','83.00','5365000','0','0','17800','6980000','0','0','0','6980000','VAN','00046958','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIXD-95-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-09-11' AND kode_barang='PSGT-ZIXD-95-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-260911-0004','2026-09-11','2.640','2026-09-11','14:06:59','PLG0015701','6980000','6980000','0','6980000','0','sby','2026-09-11 14:06:59','FJ-260911-0004','DP-03657','4500000');
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-09-11','FJ-260911-0004','2026-09-11','14:06:59','VAN','6980000','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-260911-0006','2026-09-11','2026-09-11 14:06:59','PENJUALAN : FJ-260911-0004','','TBC','2480000','2480000','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-260911-0007','D','2026-09-11','14:06:59','TBC','PENJUALAN','FJ-260911-0004','27661536464','2480000','27664016464','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='2480000' WHERE no_faktur_jual='FJ-260911-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-11 ','14:30:03');
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-03973','NAD','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','850000','0','850000','size 12.5 crom putih doff semprot','Grf Egi & Rani 20.10.26','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-260911-0007','2026-09-11','2026-09-11 14:34:06','PESANAN : DP-03973','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260911-0008','D','2026-09-11','14:34:06','TBC','PESANAN','DP-03973','27664016464','850000','27664866464','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-03973','2026-09-11','2026-09-11','14:34:06','PLG0015702','NAD','2026-10-08','kasirbip','2026-09-11 14:34:06','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03974','NAD','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','size 18.5 crom putih doff semprot','Grf Rani & Egi 20.10.26','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-260911-0008','2026-09-11','2026-09-11 14:35:55','PESANAN : DP-03974','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260911-0009','D','2026-09-11','14:35:55','TBC','PESANAN','DP-03974','27664866464','850000','27665716464','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-03974','2026-09-11','2026-09-11','14:35:55','PLG0015703','NAD','2026-10-08','kasirbip','2026-09-11 14:35:55','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0004';
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-20260911-0002','1','LXPLD-ZIXI-22-0','1','4.320','4.320','TOKO','DUPLD','TOKO','DUPLD');
DELETE FROM tm_barang WHERE kode_barang='LXPLD-ZIXI-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPLD-ZIXI-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPLD-ZIXI-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPLD-ZIXI-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPLD',tgl_last_beli='2026-09-11 14:54:46' WHERE kode_barang='LXPLD-ZIXI-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPLD-ZIXI-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-09-11 14:54:46','TOKO','DUPLD','LXPLD','LXPLD-ZIXI-22-0','1','4.320','4.320','1','4.320','4.320','17.00');
DELETE FROM tm_dept WHERE kode_dept='LXPLD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPLD' 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='LXPLD-ZIXI-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPLD-ZIXI-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0002','1','LXPLD-ZIXI-23-0','1','3.420','3.420','TOKO','DUPLD','TOKO','DUPLD');
DELETE FROM tm_barang WHERE kode_barang='LXPLD-ZIXI-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPLD-ZIXI-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPLD-ZIXI-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPLD-ZIXI-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPLD',tgl_last_beli='2026-09-11 14:54:46' WHERE kode_barang='LXPLD-ZIXI-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPLD-ZIXI-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-09-11 14:54:46','TOKO','DUPLD','LXPLD','LXPLD-ZIXI-23-0','1','3.420','3.420','1','3.420','3.420','17.00');
DELETE FROM tm_dept WHERE kode_dept='LXPLD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPLD' 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='LXPLD-ZIXI-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPLD-ZIXI-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260911-0002','2026-09-11','14:54','7.740','kasirbip','2026-09-11 14:54:46');
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-20260911-0003','1','PSPRT-ZIAX-7-0','1','3.710','3.710','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAX-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAX-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAX-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-11 14:56:41' WHERE kode_barang='PSPRT-ZIAX-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAX-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-09-11 14:56:41','TOKO','DUPSN','PSPRT','PSPRT-ZIAX-7-0','1','3.710','3.710','1','3.710','3.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-ZIAX-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0003','1','PSPLT-ZIAX-8-0','1','2.080','2.080','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAX-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAX-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAX-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAX-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-11 14:56:41' WHERE kode_barang='PSPLT-ZIAX-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAX-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-09-11 14:56:41','TOKO','DUPSN','PSPLT','PSPLT-ZIAX-8-0','1','2.080','2.080','1','2.080','2.080','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-ZIAX-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAX-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0003','1','PSGT-ZIAX-9-0','1','1.570','1.570','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIAX-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIAX-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIAX-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIAX-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-11 14:56:41' WHERE kode_barang='PSGT-ZIAX-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIAX-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-09-11 14:56:41','TOKO','DUPSN','PSGT','PSGT-ZIAX-9-0','1','1.570','1.570','1','1.570','1.570','45.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-ZIAX-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIAX-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0003','1','PSPLT-ZIAX-10-0','1','3.360','3.360','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAX-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAX-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAX-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAX-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-11 14:56:41' WHERE kode_barang='PSPLT-ZIAX-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAX-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-09-11 14:56:41','TOKO','DUPSN','PSPLT','PSPLT-ZIAX-10-0','1','3.360','3.360','1','3.360','3.360','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-ZIAX-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAX-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0003','1','PSPRT-ZIAX-11-0','1','3.640','3.640','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAX-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAX-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAX-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-11 14:56:41' WHERE kode_barang='PSPRT-ZIAX-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAX-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-09-11 14:56:41','TOKO','DUPSN','PSPRT','PSPRT-ZIAX-11-0','1','3.640','3.640','1','3.640','3.640','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-ZIAX-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260911-0003','2026-09-11','14:54','14.360','kasirbip','2026-09-11 14:56:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-11 ','15:07:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-11 ','15:22:54');
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-03975','ADL','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','670000','0','670000','size cwo 195','ukirnama font Yeseva: Zusron Westani 031026','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260911-0009','2026-09-11','2026-09-11 15:31:01','PESANAN : DP-03975','-','TBC','670000','670000');
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-260911-0010','D','2026-09-11','15:31:01','TBC','PESANAN','DP-03975','27665716464','670000','27666386464','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-03975','2026-09-11','2026-09-11','15:31:01','PLG0015704','ADL','2026-10-04','jogja','2026-09-11 15:31:01','2.000','0','0','0','670000','0','0','670000','670000','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-260911-0005','kasirbip','1',' DP-03432DU','TOKO','DUPSN','PSPLT-ZIXD-103-0','CINCIN PALADIUM ','','2.240','1','17.00','503000','0','0','17800','1534000','0','0','0','1534000','PUT','00046966','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPLT-ZIXD-103-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-260911-0005','2026-09-11','2.240','2026-09-11','15:53:32','PLG0015705','1534000','1534000','0','1534000','0','kasirbip','2026-09-11 15:53:31','FJ-260911-0005','DP-03432','1300000');
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-09-11','FJ-260911-0005','2026-09-11','15:53:32','PUT','1534000','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-260911-0010','2026-09-11','2026-09-11 15:53:31','PENJUALAN : FJ-260911-0005','.','TBC','234000','234000','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-260911-0011','D','2026-09-11','15:53:32','TBC','PENJUALAN','FJ-260911-0005','27666386464','234000','27666620464','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='234000' WHERE no_faktur_jual='FJ-260911-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-260911-0006','kasirbip',' 1',' DP-03430DU','TOKO','DUPSN','PSPLT-ZIAX-8-0','CINCIN PALADIUM ','','2.080','1','17.00','467000','0','0','17800','1568000','0','0','0','1568000','PUT','00047107','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAX-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPLT-ZIAX-8-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-260911-0006','2026-09-11','2.080','2026-09-11','15:53:32','PLG0015706','1568000','1568000','0','1568000','0','kasirbip','2026-09-11 15:53:31','FJ-260911-0005','DP-03430','1372000');
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-09-11','FJ-260911-0006','2026-09-11','15:53:32','PUT','1568000','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-260911-0011','2026-09-11','2026-09-11 15:53:31','PENJUALAN : FJ-260911-0006','.','TBC','196000','196000','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-260911-0012','D','2026-09-11','15:53:32','TBC','PENJUALAN','FJ-260911-0006','27666620464','196000','27666816464','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='430000' WHERE no_faktur_jual='FJ-260911-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260911-0007','jogja','1',' DP-03698JO','TOKO','JOGPSN','PSPLT-ZIXH-46-0','CINCIN PALADIUM ','','3.280','1','17.00','737000','0','0','17800','1148000','0','800000','0','1948000','ADL','00047059','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXH-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPLT-ZIXH-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-260911-0007','2026-09-11','3.280','2026-09-11','16:44:20','PLG0015707','1148000','1148000','800000','1948000','0','jogja','2026-09-11 16:44:19','FJ-260911-0007','DP-03698','1012500');
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-09-11','FJ-260911-0007','2026-09-11','16:44:20','ADL','1948000','800000');
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-260911-0012','2026-09-11','2026-09-11 16:44:19','PENJUALAN : FJ-260911-0007','','TBC','935500','935500','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-260911-0013','D','2026-09-11','16:44:20','TBC','PENJUALAN','FJ-260911-0007','27666816464','935500','27667751964','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='935500' WHERE no_faktur_jual='FJ-260911-0007' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-11 ','17:43:50');
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-260911-0008','kasir','1',' DP-03489MM','TOKO','MMPSN','PSPRT-ZIAX-5-0','CINCIN PERAK YL01 ','','3.910','1','100.00','399000','0','0','17800','1200000','0','0','0','1200000','ELLA','00047104','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAX-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPRT-ZIAX-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260911-0008','2026-09-11','3.910','2026-09-11','17:44:29','PLG0015708','1200000','1200000','0','1200000','0','kasir','2026-09-11 17:44:29','FJ-260911-0008','DP-03489','1200000');
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-09-11','FJ-260911-0008','2026-09-11','17:44:29','ELLA','1200000','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-260911-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260911-0009','kasirbip','1',' DP-03380DU','TOKO','DUPSN','PSPRT-ZIAX-7-0','CINCIN PERAK SR02 YL01 ','','3.710','1','100.00','379000','0','0','17800','950000','0','0','0','950000','NAD','00047106','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.710',berat_jual_asli=berat_jual_asli+'3.710',stock_jual='1',berat_akhir=berat_akhir-'3.710',berat_akhir_asli=berat_akhir_asli-'3.710',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPRT-ZIAX-7-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-260911-0009','2026-09-11','3.710','2026-09-11','18:03:25','PLG0015709','950000','950000','0','950000','0','kasirbip','2026-09-11 18:03:24','FJ-260911-0009','DP-03380','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-09-11','FJ-260911-0009','2026-09-11','18:03:25','NAD','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-260911-0009' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-11 ','18:23:32');
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-20260911-0004','1','PSPLT-ZIAA-2-0','1','3.320','3.320','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-11 18:23:49' WHERE kode_barang='PSPLT-ZIAA-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-11 18:23:49','TOKO','MMPSN','PSPLT','PSPLT-ZIAA-2-0','1','3.320','3.320','1','3.320','3.320','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-ZIAA-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260911-0004','2026-09-11','18:23','3.320','kasir','2026-09-11 18:23: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-260911-0010','kasirbip','1',' 800K-105-0','TOKO','DUPERBDG','LXPER-ZCXB-39-0','CINCIN SILVER 925 ','','2.400','1','100.00','245000','0','0','17800','900000','0','0','0','900000','NAD','00042100','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='LXPER-ZCXB-39-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-260911-0010','2026-09-11','2.400','2026-09-11','18:44:15','PLG0015710','900000','900000','0','900000','0','kasirbip','2026-09-11 18:44:14','FJ-260911-0010','','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-09-11','FJ-260911-0010','2026-09-11','18:44:15','NAD','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-260911-0013','2026-09-11','2026-09-11 18:44:14','PENJUALAN : FJ-260911-0010','.','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-260911-0014','D','2026-09-11','18:44:15','TBC','PENJUALAN','FJ-260911-0010','27667751964','900000','27668651964','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-260911-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260911-0011','kasir','1',' DP-03449MM','TOKO','MMPSN','PSGT-ZIXH-4-0','CINCIN EMAS ','','1.980','1','45.00','2182000','0','0','17800','3892000','0','0','0','3892000','ALIKA','00047017','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIXH-4-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-09-11' AND kode_barang='PSGT-ZIXH-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260911-0011','2026-09-11','1.980','2026-09-11','18:48:06','PLG0015711','3892000','3892000','0','3892000','0','kasir','2026-09-11 18:48:06','FJ-260911-0011','DP-03449','3696000');
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-09-11','FJ-260911-0011','2026-09-11','18:48:06','ALIKA','3892000','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-260911-0014','2026-09-11','2026-09-11 18:48:06','PENJUALAN : FJ-260911-0011','0','TBC','196000','196000','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-260911-0015','D','2026-09-11','18:48:06','TBC','PENJUALAN','FJ-260911-0011','27668651964','196000','27668847964','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='196000' WHERE no_faktur_jual='FJ-260911-0011' LIMIT 1;
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02240';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02240';
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02238';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02238';
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02235';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02235';
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02233';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02233';
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02232';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02232';
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02239';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02239';
UPDATE tt_service_head SET tgl_selesai='2026-09-11',  status ='DONE' WHERE no_service='SV-02234';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02234';
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-20260911-0005','1','PLBDG-ZIXI-20-0','1','3.550','3.550','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-ZIXI-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-ZIXI-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-ZIXI-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-ZIXI-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2026-09-11 18:55:03' WHERE kode_barang='PLBDG-ZIXI-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-ZIXI-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-09-11 18:55:03','TOKO','BIPPLD','PLBDG','PLBDG-ZIXI-20-0','1','3.550','3.550','1','3.550','3.550','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-ZIXI-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZIXI-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0005','1','PLBDG-ZIXI-21-0','1','4.280','4.280','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-ZIXI-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-ZIXI-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-ZIXI-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-ZIXI-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2026-09-11 18:55:03' WHERE kode_barang='PLBDG-ZIXI-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-ZIXI-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-09-11 18:55:03','TOKO','BIPPLD','PLBDG','PLBDG-ZIXI-21-0','1','4.280','4.280','1','4.280','4.280','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-ZIXI-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZIXI-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260911-0005','2026-09-11','18:54','7.830','kasirbip','2026-09-11 18:55:02');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260911-0006','1','PSPRT-ZIAX-6-0','1','2.350','2.350','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAX-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAX-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAX-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSPRT-ZIAX-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAX-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-09-11 18:56:10','TOKO','BIPPSN','PSPRT','PSPRT-ZIAX-6-0','1','2.350','2.350','1','2.350','2.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIAX-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAX-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSGT-ZIAA-3-0','1','3.000','3.000','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIAA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIAA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIAA-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIAA-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSGT-ZIAA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIAA-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-09-11 18:56:10','TOKO','BIPPSN','PSGT','PSGT-ZIAA-3-0','1','3.000','3.000','1','3.000','3.000','57.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-ZIAA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIAA-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-4-0','1','6.030','6.030','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSPRT-ZIAA-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-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-09-11 18:56:10','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-4-0','1','6.030','6.030','1','6.030','6.030','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-ZIAA-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPLT-ZIAA-5-0','1','4.160','4.160','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSPLT-ZIAA-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-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-09-11 18:56:10','TOKO','BIPPSN','PSPLT','PSPLT-ZIAA-5-0','1','4.160','4.160','1','4.160','4.160','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-ZIAA-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-6-0','1','2.120','2.120','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSPRT-ZIAA-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-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-09-11 18:56:10','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-6-0','1','2.120','2.120','1','2.120','2.120','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-ZIAA-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-7-0','1','1.150','1.150','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSPRT-ZIAA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-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-09-11 18:56:10','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-7-0','1','1.150','1.150','1','1.150','1.150','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-ZIAA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-32-0','1','1.450','1.450','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:10' WHERE kode_barang='PSPRT-ZIAA-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-11 18:56:10','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-32-0','1','1.450','1.450','1','1.450','1.450','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-ZIAA-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-33-0','1','3.570','3.570','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPRT-ZIAA-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-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-09-11 18:56:11','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-33-0','1','3.570','3.570','1','3.570','3.570','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-ZIAA-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPLT-ZIAA-34-0','1','3.010','3.010','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPLT-ZIAA-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-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-09-11 18:56:11','TOKO','BIPPSN','PSPLT','PSPLT-ZIAA-34-0','1','3.010','3.010','1','3.010','3.010','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-ZIAA-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-35-0','1','3.250','3.250','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPRT-ZIAA-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-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-09-11 18:56:11','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-35-0','1','3.250','3.250','1','3.250','3.250','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-ZIAA-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-36-0','1','3.400','3.400','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPRT-ZIAA-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-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-09-11 18:56:11','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-36-0','1','3.400','3.400','1','3.400','3.400','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-ZIAA-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPLT-ZIAA-37-0','1','2.510','2.510','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPLT-ZIAA-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-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-09-11 18:56:11','TOKO','BIPPSN','PSPLT','PSPLT-ZIAA-37-0','1','2.510','2.510','1','2.510','2.510','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-ZIAA-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPLT-ZIAA-38-0','1','2.140','2.140','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPLT-ZIAA-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-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-09-11 18:56:11','TOKO','BIPPSN','PSPLT','PSPLT-ZIAA-38-0','1','2.140','2.140','1','2.140','2.140','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-ZIAA-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' 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-20260911-0006','1','PSPRT-ZIAA-39-0','1','3.320','3.320','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-11 18:56:11' WHERE kode_barang='PSPRT-ZIAA-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-39-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-11 18:56:11','TOKO','BIPPSN','PSPRT','PSPRT-ZIAA-39-0','1','3.320','3.320','1','3.320','3.320','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-ZIAA-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260911-0006','2026-09-11','18:55','41.460','kasirbip','2026-09-11 18:56:10');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0011';
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-03976','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','850000','0','850000','sz 21 crom putih doff semprot','grf Ainul Laisatun Nadifah','Font Yeseva','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-260911-0015','2026-09-11','2026-09-11 19:11:01','PESANAN : DP-03976','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260911-0016','D','2026-09-11','19:11:01','TBC','PESANAN','DP-03976','27668847964','850000','27669697964','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-03976','2026-09-11','2026-09-11','19:11:01','PLG0015712','PUT','2026-10-09','kasirbip','2026-09-11 19:11:01','4.000','0','0','0','850000','0','0','850000','850000','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-260911-0012','kasir','1',' 500K-21-11','TOKO','MMPER','PMM-ZHAI-25-0','CINCIN SILVER 925 YL01 ','','2.000','1','100.00','204000','0','0','17800','600000','0','0','0','600000','ELLA','00046229','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAI-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PMM-ZHAI-25-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-260911-0012','2026-09-11','2.000','2026-09-11','19:11:07','PLG0015713','600000','600000','0','600000','0','kasir','2026-09-11 19:11:06','FJ-260911-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-11','FJ-260911-0012','2026-09-11','19:11:07','ELLA','600000','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-260911-0016','2026-09-11','2026-09-11 19:11:06','PENJUALAN : FJ-260911-0012','0','TBC','600000','600000','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-260911-0017','D','2026-09-11','19:11:07','TBC','PENJUALAN','FJ-260911-0012','27669697964','600000','27670297964','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='600000' WHERE no_faktur_jual='FJ-260911-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-260911-0013','kasir',' 1',' 800K-95-94','TOKO','MMPER','PMM-ZDAF-10-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17800','900000','0','0','0','900000','ELLA','00042605','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDAF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PMM-ZDAF-10-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-260911-0013','2026-09-11','2.270','2026-09-11','19:11:07','PLG0015714','900000','900000','0','900000','0','kasir','2026-09-11 19:11:06','FJ-260911-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-11','FJ-260911-0013','2026-09-11','19:11:07','ELLA','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-260911-0017','2026-09-11','2026-09-11 19:11:06','PENJUALAN : FJ-260911-0013','0','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-260911-0018','D','2026-09-11','19:11:07','TBC','PENJUALAN','FJ-260911-0013','27670297964','900000','27671197964','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='1500000' WHERE no_faktur_jual='FJ-260911-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0013';
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-03977','NAD','1','PER','WEDRING','','','7.000','','925.00','1','100000','0','900000','0','900000','size 28 crom putih doff amplas','Grf Imel & Idam Font Lovelo','','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-260911-0018','2026-09-11','2026-09-11 19:41:33','PESANAN : DP-03977','.','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-260911-0019','D','2026-09-11','19:41:33','TBC','PESANAN','DP-03977','27671197964','900000','27672097964','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-03977','2026-09-11','2026-09-11','19:41:33','PLG0015715','NAD','2026-10-08','kasirbip','2026-09-11 19:41:33','7.000','0','0','0','900000','0','0','900000','900000','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-260911-0014','kasirbip','1',' 700K-11-00','TOKO','DUPERBDG','LXPER-ZBBC-58-0','CINCIN SILVER 925 ','','1.390','1','100.00','142000','0','0','17800','800000','0','0','0','800000','NAD','00041719','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='LXPER-ZBBC-58-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-260911-0014','2026-09-11','1.390','2026-09-11','19:43:27','PLG0015716','800000','800000','0','800000','0','kasirbip','2026-09-11 19:43:27','FJ-260911-0014','','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-09-11','FJ-260911-0014','2026-09-11','19:43:27','NAD','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260911-0019','2026-09-11','2026-09-11 19:43:27','PENJUALAN : FJ-260911-0014','.','TBC','800000','800000','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-260911-0020','D','2026-09-11','19:43:27','TBC','PENJUALAN','FJ-260911-0014','27672097964','800000','27672897964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260911-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0014';
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-260911-0015','kasirbip','1',' DP-03443BI','TOKO','BIPPSN','PSPRT-ZIXA-31-0','CINCIN PERAK SR01 YL01 ','','3.010','1','100.00','308000','0','0','17800','950000','0','0','0','950000','KUR','00046801','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXA-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-09-11' AND kode_barang='PSPRT-ZIXA-31-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-260911-0015','2026-09-11','3.010','2026-09-11','20:13:14','PLG0015717','950000','950000','0','950000','0','kasirbip','2026-09-11 20:13:14','FJ-260911-0015','DP-03443','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-09-11','FJ-260911-0015','2026-09-11','20:13:14','KUR','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-260911-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260911-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260911-0015';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-11';
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-09-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-11' 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-260912-0001','D','2026-09-12','21:07:17','TBC','SALDO AWAL','SALDO AWAL','0','27672897964','27672897964');
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-260912-0001','D','2026-09-12','21:07:17','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','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-260912-0001','D','2026-09-12','21:07:17','BCD','SALDO AWAL','SALDO AWAL','0','1459469500','1459469500');
UPDATE tp_system SET tgl_system='2026-09-12';