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-20261117-0001','1','H2TE-ZJCX-24-T','1','1.330','1.330','TOKO','TBK-H','TOKO','TBK-H'); DELETE FROM tm_barang WHERE kode_barang='H2TE-ZJCX-24-T' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2TE-ZJCX-24-T' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-H',tgl_last_beli='2026-11-17 07:57:07' WHERE kode_barang='H2TE-ZJCX-24-T' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H2TE-ZJCX-24-T' 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-11-17 07:57:07','TOKO','TBK-H','H2TE','H2TE-ZJCX-24-T','1','1.330','1.330','1','1.330','1.330','100.00'); DELETE FROM tm_dept WHERE kode_dept='H2TE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2TE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2TE-ZJCX-24-T'; DELETE FROM tm_barang_export WHERE kode_barang='H2TE-ZJCX-24-T'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261117-0001','2026-11-17','07:56','1.330','input','2026-11-17 07:57:06'); 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,status_otorisasi,harga_skrg) VALUES ('F226170854031','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZJAG-20-T','KL NORY UB 44CM 8K ','','0.970','1','100.00','996000','0','0','15000','997000','0','0','0','997000','NS','T0086587','H1E','0','0','-','0','1027000'); UPDATE tm_barang SET tgl_last_jual='2026-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAG-20-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-11-17' AND kode_barang='H1E-ZJAG-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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) VALUES ('F226170854031','2026-11-17','0.970','2026-11-17','08:54:03','PLG0089431','997000','997000','0','997000','997000','kasir','2026-11-17 08:54:03','F22617085403'); 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-11-17','F226170854031','2026-11-17','08:54:03','NS','997000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261117-0002','D','2026-11-17','08:54:03','kasir','PENJUALAN','F226170854031','19256863000','997000','19257860000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='997000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170854031' 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,status_otorisasi,harga_skrg) VALUES ('F226170854032','kasir',' 1',' MED1 HW ','TOKO','SMBK-D','D1E-ZKAB-141-T','LT MODEL BUNGA CLOVER SLEP HW 8K ','','0.560','1','100.00','575000','0','0','15000','575000','0','0','0','575000','NS','T0088146','D1E','0','0','-','0','1027000'); UPDATE tm_barang SET tgl_last_jual='2026-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZKAB-141-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-11-17' AND kode_barang='D1E-ZKAB-141-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F226170854032','2026-11-17','0.560','2026-11-17','08:54:03','PLG0089432','575000','575000','0','575000','575000','kasir','2026-11-17 08:54:03','F22617085403'); 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-11-17','F226170854032','2026-11-17','08:54:03','NS','575000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261117-0003','D','2026-11-17','08:54:03','kasir','PENJUALAN','F226170854032','19257860000','575000','19258435000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170854032' LIMIT 1;