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 ('F226040830131','kasir','1',' MED2 LG S ','TOKO','SMBK-D','D2E-YLBD-1-T','LT MODEL MATA HURUF S LG 8K ','OLS 8119','0.530','1','100.00','647000','0','0','15000','684000','0','92000','0','776000','TIN','T0076163','D2E','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YLBD-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='D2E-YLBD-1-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 ('F226040830131','2026-02-04','0.530','2026-02-04','08:30:13','PLG0077081','684000','684000','92000','776000','776000','kasir','2026-02-04 08:30:13','F22604083013');
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-02-04','F226040830131','2026-02-04','08:30:13','TIN','776000','92000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0002','D','2026-02-04','08:30:13','kasir','PENJUALAN','F226040830131','5710043000','776000','5710819000');
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 ('F226040844021','kasir','1',' MDD2 X LG ','TOKO','SMBK-D','D2D-ZAXI-255-0','LT X SLOBOK BOLA MATA LG 8K ','OL','1.050','1','100.00','1281000','0','0','15000','1282000','0','10000','0','1292000','TIN','00384632','D2D','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZAXI-255-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='D2D-ZAXI-255-0' 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 ('F226040844021','2026-02-04','1.050','2026-02-04','08:44:02','PLG0077082','1282000','1282000','10000','1292000','1292000','kasir','2026-02-04 08:44:02','F22604084402');
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-02-04','F226040844021','2026-02-04','08:44:02','TIN','1292000','10000');
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-260204-0003','D','2026-02-04','08:44:02','kasir','PENJUALAN','F226040844021','5710819000','1292000','5712111000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1292000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844021' 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 ('F226040844022','kasir',' 1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZAAG-44-T','GL MODEL FANCY VAR KH 8K ','OL','2.100','1','100.00','2562000','0','0','15000','2614000','0','11000','0','2625000','TIN','T0076638','F3E','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAAG-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='F3E-ZAAG-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226040844022','2026-02-04','2.100','2026-02-04','08:44:02','PLG0077083','2614000','2614000','11000','2625000','2625000','kasir','2026-02-04 08:44:02','F22604084402');
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-02-04','F226040844022','2026-02-04','08:44:02','TIN','2625000','11000');
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-260204-0004','D','2026-02-04','08:44:02','kasir','PENJUALAN','F226040844022','5712111000','2625000','5714736000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2625000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844022' 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 ('F226040948221','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-YJXF-1-T','GW TUSUK DAISY MATA LG 8K ','','0.300','1','100.00','378000','0','0','15000','392000','0','0','0','392000','RTA','T0073899','B1G','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YJXF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='B1G-YJXF-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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 ('F226040948221','2026-02-04','0.300','2026-02-04','09:48:23','PLG0077084','392000','392000','0','392000','392000','kasir','2026-02-04 09:48:22','F22604094822');
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-02-04','F226040948221','2026-02-04','09:48:23','RTA','392000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0005','D','2026-02-04','09:48:23','kasir','PENJUALAN','F226040948221','5714736000','392000','5715128000');
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 ('F226041031231','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZACX-58-T','CC SOLITAIRE MATA VAR CM 16 8K ','OL','0.960','1','100.00','1152000','0','0','15000','1215000','0','10000','0','1225000','NS','T0076972','E2D','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZACX-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='E2D-ZACX-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226041031231','2026-02-04','0.960','2026-02-04','10:31:24','PLG0077085','1215000','1215000','10000','1225000','1225000','kasir','2026-02-04 10:31:23','F22604103123');
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-02-04','F226041031231','2026-02-04','10:31:24','NS','1225000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0006','D','2026-02-04','10:31:24','kasir','PENJUALAN','F226041031231','5715128000','1225000','5716353000');
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 ('F226041033191','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZAAE-27-T','GL OVAL MODEL C TD D56 8K ','OL','5.080','1','100.00','6198000','0','0','15000','6503000','0','25000','0','6528000','NS','T0076589','F1E','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAE-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.080',berat_jual_asli=berat_jual_asli+'5.080',stock_jual='1',berat_akhir=berat_akhir-'5.080',berat_akhir_asli=berat_akhir_asli-'5.080',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='F1E-ZAAE-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226041033191','2026-02-04','5.080','2026-02-04','10:33:19','PLG0077086','6503000','6503000','25000','6528000','6528000','kasir','2026-02-04 10:33:19','F22604103319');
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-02-04','F226041033191','2026-02-04','10:33:19','NS','6528000','25000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0007','D','2026-02-04','10:33:19','kasir','PENJUALAN','F226041033191','5716353000','6528000','5722881000');
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 ('F226041115081','kasir','1',' MEF1 TD D6','TOKO','SMBK-F','F1E-ZAAE-22-T','GL OVAL MODEL C TD D60 8K ','','3.510','1','100.00','4282000','0','0','15000','4475000','0','0','0','4475000','NS','T0076584','F1E','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAE-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='F1E-ZAAE-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226041115081','2026-02-04','3.510','2026-02-04','11:15:08','PLG0077087','4475000','4475000','0','4475000','4475000','kasir','2026-02-04 11:15:08','F22604111508');
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-02-04','F226041115081','2026-02-04','11:15:08','NS','4475000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0008','D','2026-02-04','11:15:08','kasir','PENJUALAN','F226041115081','5722881000','4475000','5727356000');
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 ('F226040131441','kasir','1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZAXH-79-T','CC MODEL PITA VAR CM 14 8K ','','1.480','1','100.00','1776000','0','0','15000','1865000','0','0','0','1865000','NS','T0076402','E1D','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='E1D-ZAXH-79-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226040131441','2026-02-04','1.480','2026-02-04','13:31:44','PLG0077088','1865000','1865000','0','1865000','1865000','kasir','2026-02-04 13:31:44','F22604013144');
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-02-04','F226040131441','2026-02-04','13:31:44','NS','1865000','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-260204-0009','D','2026-02-04','13:31:44','kasir','PENJUALAN','F226040131441','5727356000','1865000','5729221000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040131441' 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 ('F226040131442','kasir',' 1',' MEF3E X KH','TOKO','SMBK-F','F3E-YLBX-230-0','GL X RANTAI HOLLOW KH 8K ','','3.030','1','100.00','3697000','0','0','15000','3878000','0','0','0','3878000','NS','00382110','F3E','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBX-230-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='F3E-YLBX-230-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226040131442','2026-02-04','3.030','2026-02-04','13:31:44','PLG0077089','3878000','3878000','0','3878000','3878000','kasir','2026-02-04 13:31:44','F22604013144');
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-02-04','F226040131442','2026-02-04','13:31:44','NS','3878000','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-260204-0010','D','2026-02-04','13:31:44','kasir','PENJUALAN','F226040131442','5729221000','3878000','5733099000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3878000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040131442' 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 ('F226040146061','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZACX-69-T','CC MODEL HATI SLEP VAR CM 18 8K ','OL','1.230','1','100.00','1476000','0','0','15000','1562000','0','6000','0','1568000','TIN','T0076983','E1D','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZACX-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='E1D-ZACX-69-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226040146061','2026-02-04','1.230','2026-02-04','13:46:06','PLG0077090','1562000','1562000','6000','1568000','1568000','kasir','2026-02-04 13:46:06','F22604014606');
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-02-04','F226040146061','2026-02-04','13:46:06','TIN','1568000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0011','D','2026-02-04','13:46:06','kasir','PENJUALAN','F226040146061','5733099000','1568000','5734667000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040131441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040131441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040131441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040131442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040131442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040131442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040146061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040146061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040146061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040830131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040830131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040830131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040948221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040948221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040948221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041031231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041031231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041031231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041033191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041033191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041033191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041115081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041115081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041115081';
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 ('F226040246431','kasir','1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZACX-61-T','CC VELG POLOS CM 14 8K ','OL','1.050','1','100.00','1260000','0','0','15000','1335000','0','5000','0','1340000','RTA','T0076975','E1D','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-02-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZACX-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-02-04' AND kode_barang='E1D-ZACX-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226040246431','2026-02-04','1.050','2026-02-04','14:46:43','PLG0077091','1335000','1335000','5000','1340000','1340000','kasir','2026-02-04 14:46:43','F22604024643');
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-02-04','F226040246431','2026-02-04','14:46:43','RTA','1340000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260204-0012','D','2026-02-04','14:46:43','kasir','PENJUALAN','F226040246431','5734667000','1340000','5736007000');
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-00005070','X-00005070','GL FLIK MODEL BOLA ARESO YT 8K','GR','---','F3E','BELI','BELI001','2587000','2026-02-04','2.500','1','kasir','2026-02-04 15:05:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005070','X-00005070');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260204-0001','F226140408111','TIN','1','BELI','BELI001','F3E', 'X-00005070', 'GL FLIK MODEL BOLA ARESO YT 8K','2.500','2.500','100.00','2875000','2587000','1034800','1220000','1','2587000','2587000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.500',berat_beli_asli=berat_beli_asli+'2.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.500',berat_akhir_asli=berat_akhir_asli+'2.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-260204-0001','2026-02-04','2026-02-04','15:05:32','TIN','---','2.500','2587000','2587000','2587000','2587000','2587000','kasir','2026-02-04 15:05:33','FB-260204-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260204-0001','ERLIKA','NGLEWAN SAMBIT','','','08565556661599','kasir','2026-02-04 15:05:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-04' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260204-0013','K','2026-02-04','15:05:32','kasir','PEMBELIAN UMUM','FB-260204-0001','5736007000','2587000','5733420000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260204-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260204-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040246431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040246431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040246431';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-04';
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-02-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-04' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260205-0001','D','2026-02-05','16:01:48','SYSTEM','SALDO AWAL','SALDO AWAL','0','5733420000','5733420000');
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-260205-0001','D','2026-02-05','16:01:48','BCA','SALDO AWAL','SALDO AWAL','0','4253713888','4253713888');
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-260205-0001','D','2026-02-05','16:01:48','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260205-0001','D','2026-02-05','16:01:48','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
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-260205-0001','D','2026-02-05','16:01:48','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
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-260205-0001','D','2026-02-05','16:01:48','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-02-05';
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-20260205-0001','1','F3E-ZACA-82-0','1','1.810','1.810','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZACA-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZACA-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-02-05 16:47:38' WHERE kode_barang='F3E-ZACA-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZACA-82-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-05 16:47:38','TOKO','SMBK-F','F3E','F3E-ZACA-82-0','1','1.810','1.810','1','1.810','1.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZACA-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZACA-82-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260205-0001','1','F3E-ZBXD-526-0','1','1.220','1.220','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBXD-526-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBXD-526-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-02-05 16:47:38' WHERE kode_barang='F3E-ZBXD-526-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBXD-526-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-02-05 16:47:38','TOKO','SMBK-F','F3E','F3E-ZBXD-526-0','1','1.220','1.220','1','1.220','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZBXD-526-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBXD-526-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260205-0001','2026-02-05','16:47','3.030','input','2026-02-04 16:47:38');
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-20260205-0001','1','H1E-ZBXD-545-0','1','2.010','2.010','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBXD-545-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBXD-545-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-05 16:47:52' WHERE kode_barang='H1E-ZBXD-545-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBXD-545-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-02-05 16:47:52','TOKO','SMBK-H','H1E','H1E-ZBXD-545-0','1','2.010','2.010','1','2.010','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZBXD-545-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBXD-545-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260205-0001','1','H1E-ZBXD-546-0','1','2.080','2.080','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBXD-546-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBXD-546-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-05 16:47:52' WHERE kode_barang='H1E-ZBXD-546-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBXD-546-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-02-05 16:47:52','TOKO','SMBK-H','H1E','H1E-ZBXD-546-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZBXD-546-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBXD-546-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260205-0001','1','H1E-ZBXD-547-0','1','1.540','1.540','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBXD-547-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBXD-547-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-05 16:47:52' WHERE kode_barang='H1E-ZBXD-547-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBXD-547-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-02-05 16:47:52','TOKO','SMBK-H','H1E','H1E-ZBXD-547-0','1','1.540','1.540','1','1.540','1.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZBXD-547-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBXD-547-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260205-0001','2026-02-05','16:47','5.630','input','2026-02-04 16:47:51');