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 ('F226250820011','kasir','1',' MED2 CM ','TOKO','SMBK-D','D2E-ZBAF-36-T','LT MODEL HATI MATA VAR CM 8K ','OL','0.770','1','100.00','966000','0','0','15000','978000','0','5000','0','983000','RTA','T0077415','D2E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBAF-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D2E-ZBAF-36-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 ('F226250820011','2026-02-25','0.770','2026-02-25','08:20:02','PLG0077628','978000','978000','5000','983000','983000','kasir','2026-02-25 08:20:01','F22625082001');
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-25','F226250820011','2026-02-25','08:20:02','RTA','983000','5000');
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-260225-0002','D','2026-02-25','08:20:02','kasir','PENJUALAN','F226250820011','6425162000','983000','6426145000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='983000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250820011' 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 ('F226250820012','kasir',' 1',' MDB1 HW PE','TOKO','SMBK-B','B1D-ZACX-41-T','GW TUSUK MODEL HATI MATA VAR HW PE 8K ','OL','0.810','1','100.00','1000000','0','0','15000','1013000','0','5000','0','1018000','RTA','T0076955','B1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZACX-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='B1D-ZACX-41-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 ('F226250820012','2026-02-25','0.810','2026-02-25','08:20:02','PLG0077629','1013000','1013000','5000','1018000','1018000','kasir','2026-02-25 08:20:01','F22625082001');
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-25','F226250820012','2026-02-25','08:20:02','RTA','1018000','5000');
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-260225-0003','D','2026-02-25','08:20:02','kasir','PENJUALAN','F226250820012','6426145000','1018000','6427163000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1018000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250820012' 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 ('F226250822271','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAI-14-T','GL SANTA SERUT BUNGA CLOVER SLEP UB 8K ','OL HK','2.050','1','100.00','2573000','0','0','15000','2593000','0','21000','0','2614000','TIN','T0077546','F3E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-14-T' 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-02-25' AND kode_barang='F3E-ZBAI-14-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 ('F226250822271','2026-02-25','2.050','2026-02-25','08:22:28','PLG0077630','2593000','2593000','21000','2614000','2614000','kasir','2026-02-25 08:22:27','F22625082227');
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-25','F226250822271','2026-02-25','08:22:28','TIN','2614000','21000');
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-260225-0004','D','2026-02-25','08:22:28','kasir','PENJUALAN','F226250822271','6427163000','2614000','6429777000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2614000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250822271' 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 ('F226250822272','kasir',' 1',' MEF1 TD 56','TOKO','SMBK-F','F1E-ZBAG-56-0','GL OVAL C GELOMBANG SLEP TD 56 8K ','OL HK','3.030','1','100.00','3818000','0','0','15000','3833000','0','30000','0','3863000','TIN','00390348','F1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBAG-56-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-25' AND kode_barang='F1E-ZBAG-56-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 ('F226250822272','2026-02-25','3.030','2026-02-25','08:22:28','PLG0077631','3833000','3833000','30000','3863000','3863000','kasir','2026-02-25 08:22:27','F22625082227');
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-25','F226250822272','2026-02-25','08:22:28','TIN','3863000','30000');
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-260225-0005','D','2026-02-25','08:22:28','kasir','PENJUALAN','F226250822272','6429777000','3863000','6433640000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3863000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250822272' 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 ('F226250903241','kasir','1',' MDE1 X BM ','TOKO','SMBK-E','E1D-ZBAD-353-0','CC X VELG C SLEP BM 14 8K ','OLS RN308','1.070','1','100.00','1321000','0','0','15000','1328000','0','145000','0','1473000','RHM','00389959','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-353-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1D-ZBAD-353-0' 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 ('F226250903241','2026-02-25','1.070','2026-02-25','09:03:24','PLG0077632','1328000','1328000','145000','1473000','1473000','kasir','2026-02-25 09:03:24','F22625090324');
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-25','F226250903241','2026-02-25','09:03:24','RHM','1473000','145000');
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-260225-0006','D','2026-02-25','09:03:24','kasir','PENJUALAN','F226250903241','6433640000','1473000','6435113000');
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 ('F226250904221','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLXD-56-T','LT SLOBOK BALOK HURUF D BG 8K ','OLS JDA68','0.550','1','100.00','701000','0','0','15000','712000','0','54000','0','766000','RHM','T0075524','D1F','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLXD-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D1F-YLXD-56-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 ('F226250904221','2026-02-25','0.550','2026-02-25','09:04:23','PLG0077633','712000','712000','54000','766000','766000','kasir','2026-02-25 09:04:22','F22625090422');
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-25','F226250904221','2026-02-25','09:04:23','RHM','766000','54000');
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-260225-0007','D','2026-02-25','09:04:23','kasir','PENJUALAN','F226250904221','6435113000','766000','6435879000');
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 ('F226250905241','kasir','1',' MIH2I KH 4','TOKO','SMBK-H','H2I-YLBX-23-T','KL JEDAR KH 42 8K ','OLS VFWT6','1.200','1','100.00','1602000','0','0','15000','1608000','0','92000','0','1700000','RHM','T0076008','H2I','0','0','-','0','1335000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YLBX-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='H2I-YLBX-23-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 ('F226250905241','2026-02-25','1.200','2026-02-25','09:05:24','PLG0077634','1608000','1608000','92000','1700000','1700000','kasir','2026-02-25 09:05:24','F22625090524');
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-25','F226250905241','2026-02-25','09:05:24','RHM','1700000','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-260225-0008','D','2026-02-25','09:05:24','kasir','PENJUALAN','F226250905241','6435879000','1700000','6437579000');
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 ('F226250920081','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZBAG-18-T','KL KOREA UB 44CM 8K ','','1.480','1','100.00','1857000','0','0','15000','1850000','0','0','0','1850000','TIN','T0077460','H1E','0','0','-','1','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAG-18-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-25' AND kode_barang='H1E-ZBAG-18-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 ('F226250920081','2026-02-25','1.480','2026-02-25','09:20:09','PLG0077635','1850000','1850000','0','1850000','1850000','kasir','2026-02-25 09:20:08','F22625092008');
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-25','F226250920081','2026-02-25','09:20:09','TIN','1850000','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-260225-0009','D','2026-02-25','09:20:09','kasir','PENJUALAN','F226250920081','6437579000','1850000','6439429000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1850000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250920081' 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 ('F226250920082','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-82-T','LT SLOBOK BALOK HURUF BG P 8K ','','0.380','1','100.00','492000','0','0','15000','490000','0','5000','0','495000','TIN','T0073662','D1G','0','0','-','1','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D1G-YJXB-82-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 ('F226250920082','2026-02-25','0.380','2026-02-25','09:20:09','PLG0077636','490000','490000','5000','495000','495000','kasir','2026-02-25 09:20:08','F22625092008');
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-25','F226250920082','2026-02-25','09:20:09','TIN','495000','5000');
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-260225-0010','D','2026-02-25','09:20:09','kasir','PENJUALAN','F226250920082','6439429000','495000','6439924000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250920082' 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 ('F226251019371','kasir','1',' MDD2 CM ','TOKO','SMBK-D','D2D-ZACX-49-T','LT MODEL SANDAL MATA VAR CM 8K ','OL','1.000','1','100.00','1235000','0','0','15000','1235000','0','5000','0','1240000','RTA','T0076963','D2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZACX-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D2D-ZACX-49-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 ('F226251019371','2026-02-25','1.000','2026-02-25','10:19:38','PLG0077637','1235000','1235000','5000','1240000','1240000','kasir','2026-02-25 10:19:37','F22625101937');
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-25','F226251019371','2026-02-25','10:19:38','RTA','1240000','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-260225-0011','D','2026-02-25','10:19:38','kasir','PENJUALAN','F226251019371','6439924000','1240000','6441164000');
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 ('F226251033361','kasir','1',' MDE2 X LG ','TOKO','SMBK-E','E2D-ZBXF-206-0','CC X MODEL MATA LG 16 8K ','','0.970','1','100.00','1198000','0','0','15000','1193000','0','0','0','1193000','TIN','00388788','E2D','0','0','-','1','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBXF-206-0' 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-02-25' AND kode_barang='E2D-ZBXF-206-0' 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 ('F226251033361','2026-02-25','0.970','2026-02-25','10:33:36','PLG0077638','1193000','1193000','0','1193000','1193000','kasir','2026-02-25 10:33:36','F22625103336');
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-25','F226251033361','2026-02-25','10:33:36','TIN','1193000','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-260225-0015','D','2026-02-25','10:33:36','kasir','PENJUALAN','F226251033361','6437225000','1193000','6438418000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1193000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251033361' 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 ('F226251033362','kasir',' 1',' MHB1 HK ','TOKO','SMBK-B','B1H-ZBAF-63-T','GW TUSUK MRICAN SLEP HK 8K ','','0.260','1','100.00','342000','0','0','15000','341000','0','0','0','341000','TIN','T0077442','B1H','0','0','-','1','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZBAF-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='B1H-ZBAF-63-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 ('F226251033362','2026-02-25','0.260','2026-02-25','10:33:37','PLG0077639','341000','341000','0','341000','341000','kasir','2026-02-25 10:33:36','F22625103336');
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-25','F226251033362','2026-02-25','10:33:37','TIN','341000','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-260225-0016','D','2026-02-25','10:33:37','kasir','PENJUALAN','F226251033362','6438418000','341000','6438759000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='341000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251033362' 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 ('F226251038591','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLXD-56-T','LT SLOBOK BALOK HURUF D BG 8K ','OLS JDA68','0.550','1','100.00','701000','0','0','15000','712000','0','74000','0','786000','RHM','T0075524','D1F','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLXD-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D1F-YLXD-56-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 ('F226251038591','2026-02-25','0.550','2026-02-25','10:39:00','PLG0077640','712000','712000','74000','786000','786000','kasir','2026-02-25 10:38:59','F22625103859');
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-25','F226251038591','2026-02-25','10:39:00','RHM','786000','74000');
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-260225-0017','D','2026-02-25','10:39:00','kasir','PENJUALAN','F226251038591','6438759000','786000','6439545000');
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 ('F226251041101','kasir','1',' MIH2I KH 4','TOKO','SMBK-H','H2I-YLBX-23-T','KL JEDAR KH 42 8K ','OLS VFWT6','1.200','1','100.00','1602000','0','0','15000','1608000','0','122000','0','1730000','RHM','T0076008','H2I','0','0','-','0','1335000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YLBX-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='H2I-YLBX-23-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 ('F226251041101','2026-02-25','1.200','2026-02-25','10:41:11','PLG0077641','1608000','1608000','122000','1730000','1730000','kasir','2026-02-25 10:41:10','F22625104110');
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-25','F226251041101','2026-02-25','10:41:11','RHM','1730000','122000');
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-260225-0018','D','2026-02-25','10:41:11','kasir','PENJUALAN','F226251041101','6439545000','1730000','6441275000');
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 ('F226251042421','kasir','1',' MDE1 X BM ','TOKO','SMBK-E','E1D-ZBAD-353-0','CC X VELG C SLEP BM 14 8K ','OLS RN308','1.070','1','100.00','1321000','0','0','15000','1328000','0','175000','0','1503000','RHM','00389959','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-353-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1D-ZBAD-353-0' 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 ('F226251042421','2026-02-25','1.070','2026-02-25','10:42:42','PLG0077642','1328000','1328000','175000','1503000','1503000','kasir','2026-02-25 10:42:42','F22625104242');
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-25','F226251042421','2026-02-25','10:42:42','RHM','1503000','175000');
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-260225-0019','D','2026-02-25','10:42:42','kasir','PENJUALAN','F226251042421','6441275000','1503000','6442778000');
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 ('F226251048161','kasir','1',' MEH1 X YT ','TOKO','SMBK-H','H1E-YABB-425-0','KL X TRIXI NAGITA HURUF YT C 8K ','OLS VT4AJ','1.650','1','100.00','2071000','0','0','15000','2079000','0','245000','0','2324000','RHM','00335800','H1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YABB-425-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='H1E-YABB-425-0' 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 ('F226251048161','2026-02-25','1.650','2026-02-25','10:48:17','PLG0077643','2079000','2079000','245000','2324000','2324000','kasir','2026-02-25 10:48:16','F22625104816');
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-25','F226251048161','2026-02-25','10:48:17','RHM','2324000','245000');
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-260225-0020','D','2026-02-25','10:48:17','kasir','PENJUALAN','F226251048161','6442778000','2324000','6445102000');
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 ('F226251053431','kasir','1',' MGB1 CM ','TOKO','SMBK-B','B1G-ZBAF-54-T','GW TOGE MODEL HATI VAR CM 8K ','','0.310','1','100.00','401000','0','0','15000','400000','0','0','0','400000','RTA','T0077433','B1G','0','0','-','1','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZBAF-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='B1G-ZBAF-54-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 ('F226251053431','2026-02-25','0.310','2026-02-25','10:53:44','PLG0077644','400000','400000','0','400000','0','kasir','2026-02-25 10:53:43','F22625105343');
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-25','F226251053431','2026-02-25','10:53:44','RTA','400000','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-260225-0001','2026-02-25','2026-02-25 10:53:43','PENJUALAN : F226251053431','9888776665','BCA','400000','400000','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-260225-0002','D','2026-02-25','10:53:44','BCA','PENJUALAN','F226251053431','4288030888','400000','4288430888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('9888776665','SELA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='400000' WHERE no_faktur_jual='F226251053431' 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 ('F226251109071','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZBAI-58-T','AT MODEL TETES ARESO CM 8K ','ol','0.530','1','100.00','665000','0','0','15000','670000','0','5000','0','675000','RTA','T0077590','A1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAI-58-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-25' AND kode_barang='A1E-ZBAI-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226251109071','2026-02-25','0.530','2026-02-25','11:09:07','PLG0077645','670000','670000','5000','675000','675000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109071','2026-02-25','11:09:07','RTA','675000','5000');
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-260225-0021','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109071','6445102000','675000','6445777000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='675000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109071' 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 ('F226251109072','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-ZBAI-61-T','AT MODEL ITALY PANJANG VAR BW 8K ','ol','0.600','1','100.00','753000','0','0','15000','759000','0','5000','0','764000','RTA','T0077593','A1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAI-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='A1E-ZBAI-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226251109072','2026-02-25','0.600','2026-02-25','11:09:07','PLG0077646','759000','759000','5000','764000','764000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109072','2026-02-25','11:09:07','RTA','764000','5000');
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-260225-0022','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109072','6445777000','764000','6446541000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='764000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109072' 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 ('F226251109073','kasir',' 1',' MED1 HW ','TOKO','SMBK-D','D1E-ZBAI-44-T','LT LETTERA PANJANG HW 8K ','ol','0.750','1','100.00','941000','0','0','15000','949000','0','5000','0','954000','RTA','T0077576','D1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAI-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D1E-ZBAI-44-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 ('F226251109073','2026-02-25','0.750','2026-02-25','11:09:07','PLG0077647','949000','949000','5000','954000','954000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109073','2026-02-25','11:09:07','RTA','954000','5000');
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-260225-0023','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109073','6446541000','954000','6447495000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='954000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109073' 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 ('F226251109074','kasir',' 1',' MDE2 X BM ','TOKO','SMBK-E','E2D-ZBAA-139-0','CC X MODEL MATA BM 16 8K ','ol','0.960','1','100.00','1186000','0','0','15000','1195000','0','5000','0','1200000','RTA','00389285','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBAA-139-0' 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-25' AND kode_barang='E2D-ZBAA-139-0' 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 ('F226251109074','2026-02-25','0.960','2026-02-25','11:09:07','PLG0077648','1195000','1195000','5000','1200000','1200000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109074','2026-02-25','11:09:07','RTA','1200000','5000');
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-260225-0024','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109074','6447495000','1200000','6448695000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1200000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109074' 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 ('F226251109075','kasir',' 1',' MEE1 BW 12','TOKO','SMBK-E','E1E-ZBAH-57-T','CC BANGKOK PASIR BW 12 8K ','ol','0.610','1','100.00','766000','0','0','15000','772000','0','5000','0','777000','RTA','T0077502','E1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAH-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1E-ZBAH-57-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 ('F226251109075','2026-02-25','0.610','2026-02-25','11:09:07','PLG0077649','772000','772000','5000','777000','777000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109075','2026-02-25','11:09:07','RTA','777000','5000');
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-260225-0025','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109075','6448695000','777000','6449472000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='777000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109075' 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 ('F226251109076','kasir',' 1',' MDE1 8K UB','TOKO','SMBK-E','E1D-ZBAD-5-T','CC MODEL BUNGA PASIR 3C UB 14 8K','ol','1.030','1','100.00','1272000','0','0','15000','1274000','0','8000','0','1282000','RTA','T0077294','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1D-ZBAD-5-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 ('F226251109076','2026-02-25','1.030','2026-02-25','11:09:07','PLG0077650','1274000','1274000','8000','1282000','1282000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109076','2026-02-25','11:09:07','RTA','1282000','8000');
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-260225-0026','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109076','6449472000','1282000','6450754000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1282000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109076' 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 ('F226251109077','kasir',' 1',' MDE1 8K UB','TOKO','SMBK-E','E1D-ZBAD-4-T','CC MODEL BUNGA PASIR 3C UB 12 8K','ol','0.980','1','100.00','1210000','0','0','15000','1220000','0','5000','0','1225000','RTA','T0077293','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1D-ZBAD-4-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 ('F226251109077','2026-02-25','0.980','2026-02-25','11:09:07','PLG0077651','1220000','1220000','5000','1225000','1225000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109077','2026-02-25','11:09:07','RTA','1225000','5000');
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-260225-0027','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109077','6450754000','1225000','6451979000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1225000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109077' 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 ('F226251109078','kasir',' 1',' MEE1 AY 16','TOKO','SMBK-E','E1E-ZBAD-12-T','CC AUREL MODEL UNTIR AY 16 8K ','ol','0.550','1','100.00','690000','0','0','15000','696000','0','5000','0','701000','RTA','T0077301','E1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAD-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1E-ZBAD-12-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 ('F226251109078','2026-02-25','0.550','2026-02-25','11:09:07','PLG0077652','696000','696000','5000','701000','701000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109078','2026-02-25','11:09:07','RTA','701000','5000');
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-260225-0028','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109078','6451979000','701000','6452680000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='701000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109078' 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 ('F226251109079','kasir',' 1',' MEE1 AY 14','TOKO','SMBK-E','E1E-ZBAD-10-T','CC AUREL MODEL UNTIR AY 14 8K ','ol','0.520','1','100.00','653000','0','0','15000','658000','0','5000','0','663000','RTA','T0077299','E1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAD-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E1E-ZBAD-10-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 ('F226251109079','2026-02-25','0.520','2026-02-25','11:09:07','PLG0077653','658000','658000','5000','663000','663000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F226251109079','2026-02-25','11:09:07','RTA','663000','5000');
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-260225-0029','D','2026-02-25','11:09:07','kasir','PENJUALAN','F226251109079','6452680000','663000','6453343000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251109079' 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 ('F2262511090710','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZBAI-92-T','GL MODEL FANCY VAR HW 8K ','ol','1.280','1','100.00','1606000','0','0','15000','1614000','0','6000','0','1620000','RTA','T0077624','F3E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='F3E-ZBAI-92-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 ('F2262511090710','2026-02-25','1.280','2026-02-25','11:09:07','PLG0077654','1614000','1614000','6000','1620000','1620000','kasir','2026-02-25 11:09:07','F22625110907');
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-25','F2262511090710','2026-02-25','11:09:07','RTA','1620000','6000');
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-260225-0030','D','2026-02-25','11:09:07','kasir','PENJUALAN','F2262511090710','6453343000','1620000','6454963000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1620000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F2262511090710' 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 ('F226251125361','kasir','1',' MHB1 HK ','TOKO','SMBK-B','B1H-ZBAF-62-T','GW TUSUK MRICAN SLEP HK 8K ','','0.250','1','100.00','329000','0','0','15000','328000','0','0','0','328000','NS','T0077441','B1H','0','0','-','1','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZBAF-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='B1H-ZBAF-62-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 ('F226251125361','2026-02-25','0.250','2026-02-25','11:25:37','PLG0077655','328000','328000','0','328000','328000','kasir','2026-02-25 11:25:36','F22625112536');
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-25','F226251125361','2026-02-25','11:25:37','NS','328000','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-260225-0031','D','2026-02-25','11:25:37','kasir','PENJUALAN','F226251125361','6454963000','328000','6455291000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='328000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251125361' 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 ('F226251125362','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-YLBC-61-T','AT MODEL ITALY PANJANG VAR BW 8K ','','0.530','1','100.00','665000','0','0','15000','663000','0','0','0','663000','NS','T0076123','A1E','0','0','-','1','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBC-61-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-25' AND kode_barang='A1E-YLBC-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226251125362','2026-02-25','0.530','2026-02-25','11:25:37','PLG0077656','663000','663000','0','663000','663000','kasir','2026-02-25 11:25:36','F22625112536');
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-25','F226251125362','2026-02-25','11:25:37','NS','663000','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-260225-0032','D','2026-02-25','11:25:37','kasir','PENJUALAN','F226251125362','6455291000','663000','6455954000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251125362' 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 ('F226251246581','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YLAG-229-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.040','1','100.00','1284000','0','0','15000','1285000','0','10000','0','1295000','NS','00381583','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLAG-229-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='E2D-YLAG-229-0' 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 ('F226251246581','2026-02-25','1.040','2026-02-25','12:46:58','PLG0077657','1285000','1285000','10000','1295000','1295000','kasir','2026-02-25 12:46:58','F22625124658');
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-25','F226251246581','2026-02-25','12:46:58','NS','1295000','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-260225-0033','D','2026-02-25','12:46:58','kasir','PENJUALAN','F226251246581','6455954000','1295000','6457249000');
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 ('F226250123571','kasir','1',' MDD2D UB ','TOKO','SMBK-D','D2D-YDBI-31-0','LT MODEL MATA UB 8K ','OL','1.550','1','100.00','1914000','0','0','15000','1914000','0','8000','0','1922000','TIN','00351128','D2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YDBI-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='D2D-YDBI-31-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 ('F226250123571','2026-02-25','1.550','2026-02-25','13:23:58','PLG0077658','1914000','1914000','8000','1922000','1922000','kasir','2026-02-25 13:23:57','F22625012357');
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-25','F226250123571','2026-02-25','13:23:58','TIN','1922000','8000');
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-260225-0034','D','2026-02-25','13:23:58','kasir','PENJUALAN','F226250123571','6457249000','1922000','6459171000');
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 ('F226250130151','kasir','1',' MJH2 X KH ','TOKO','SMBK-H','H2J-WJAC-80-0','KL X MILANO KH 44 ','OL','10.110','1','100.00','13699000','0','0','15000','13710000','0','40000','0','13750000','TIN','00258948','H2J','0','0','-','0','1355000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-WJAC-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.110',berat_jual_asli=berat_jual_asli+'10.110',stock_jual='1',berat_akhir=berat_akhir-'10.110',berat_akhir_asli=berat_akhir_asli-'10.110',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='H2J-WJAC-80-0' 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 ('F226250130151','2026-02-25','10.110','2026-02-25','13:30:16','PLG0077659','13710000','13710000','40000','13750000','13750000','kasir','2026-02-25 13:30:15','F22625013015');
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-25','F226250130151','2026-02-25','13:30:16','TIN','13750000','40000');
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-260225-0035','D','2026-02-25','13:30:16','kasir','PENJUALAN','F226250130151','6459171000','13750000','6472921000');
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 ('F226250131371','kasir','1',' MEH1 UB 42','TOKO','SMBK-H','H1E-YLAF-5-T','KL RANTE HOLLOW 42 UB 8K ','OL','0.800','1','100.00','1004000','0','0','15000','1012000','0','5000','0','1017000','NS','T0075825','H1E','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAF-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='H1E-YLAF-5-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 ('F226250131371','2026-02-25','0.800','2026-02-25','13:31:37','PLG0077660','1012000','1012000','5000','1017000','1017000','kasir','2026-02-25 13:31:37','F22625013137');
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-25','F226250131371','2026-02-25','13:31:37','NS','1017000','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-260225-0036','D','2026-02-25','13:31:37','kasir','PENJUALAN','F226250131371','6472921000','1017000','6473938000');
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 ('F226250223381','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-YIAG-90-0','GL X RANTAI HOLLOW VAR KH 8K ','','1.980','1','100.00','2485000','0','0','15000','2475000','0','0','0','2475000','NS','00369872','F3E','0','0','-','1','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAG-90-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-02-25' AND kode_barang='F3E-YIAG-90-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 ('F226250223381','2026-02-25','1.980','2026-02-25','14:23:39','PLG0077661','2475000','2475000','0','2475000','2475000','kasir','2026-02-25 14:23:38','F22625022338');
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-25','F226250223381','2026-02-25','14:23:39','NS','2475000','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-260225-0037','D','2026-02-25','14:23:39','kasir','PENJUALAN','F226250223381','6473938000','2475000','6476413000');
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 ('F226250242391','kasir','1',' MCE0 DG 18','TOKO','SMBK-E','E0C-YKXC-38-T','CC SALANG LEWAT DG 18 8K ','OL','2.000','1','100.00','200000','0','0','15000','2440000','0','10000','0','2450000','TIN','T0074951','E0C','0','0','-','0','100000');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0C-YKXC-38-T' 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-02-25' AND kode_barang='E0C-YKXC-38-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 ('F226250242391','2026-02-25','2.000','2026-02-25','14:42:39','PLG0077662','2440000','2440000','10000','2450000','2450000','kasir','2026-02-25 14:42:39','F22625024239');
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-25','F226250242391','2026-02-25','14:42:39','TIN','2450000','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-260225-0038','D','2026-02-25','14:42:39','kasir','PENJUALAN','F226250242391','6476413000','2450000','6478863000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250123571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250123571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250123571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250130151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250130151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250130151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250131371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250131371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250131371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250223381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250223381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250223381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250242391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250242391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250242391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250820011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250820011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250820011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250820012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250820012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250820012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250822271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250822271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250822271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250822272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250822272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250822272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250920081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250920081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250920081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250920082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250920082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250920082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251019371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251019371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251019371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251033361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251033362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251038591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251038591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251038591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251041101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251042421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251042421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251042421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251048161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251048161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251048161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251053431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251053431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251053431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F2262511090710' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F2262511090710' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F2262511090710';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109073' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109073' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109073';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109074' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109074' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109074';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109075' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109075' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109075';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109076' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109076' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109076';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109077' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109077' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109077';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109078' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109078' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109078';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109079' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251109079' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251109079';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251125361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251125361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251125361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251125362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251125362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251125362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251246581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251246581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251246581';
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-00005127','X-00005127','GL X WG HARLEY HW 17K','GR','---','PFTI','BELI','BELI001','5485000','2026-02-25','3.010','1','kasir','2026-02-25 15:11:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-PFTI';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PFTI','X-00005127','X-00005127');
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-260225-0001','F225210412321','RTA','1','BELI','BELI001','PFTI', 'X-00005127', 'GL X WG HARLEY HW 17K','3.010','3.010','100.00','6095000','5485000','1822259','2365000','1','5485000','5485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.010',berat_beli_asli=berat_beli_asli+'3.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.010',berat_akhir_asli=berat_akhir_asli+'3.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PFTI' 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-260225-0001','2026-02-25','2026-02-25','15:11:51','RTA','---','3.010','5485000','5485000','5485000','5485000','5485000','kasir','2026-02-25 15:11:52','FB-260225-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260225-0001','NADIA','BABADAN','','','','kasir','2026-02-25 15:11:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-25' 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-260225-0039','K','2026-02-25','15:11:51','kasir','PEMBELIAN UMUM','FB-260225-0001','6478863000','5485000','6473378000');
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-00005128','X-00005128','CC MODEL RANTAI SLEP CM 15 8K','GR','---','E1E','BELI','BELI001','675000','2026-02-25','0.600','1','kasir','2026-02-25 15:12:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005128','X-00005128');
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-260225-0002','F226200132101','TJ','1','BELI','BELI001','E1E', 'X-00005128', 'CC MODEL RANTAI SLEP CM 15 8K','0.600','0.600','100.00','750000','675000','1125000','1260000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260225-0002','2026-02-25','2026-02-25','15:12:21','TJ','---','0.600','675000','675000','675000','675000','675000','kasir','2026-02-25 15:12:22','FB-260225-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260225-0002','ARUM','JL IMAM BONJOL','','','','kasir','2026-02-25 15:12:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-25' 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-260225-0040','K','2026-02-25','15:12:21','kasir','PEMBELIAN UMUM','FB-260225-0002','6473378000','675000','6472703000');
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-00005129','X-00005129','CC MODEL MATA VAR LG 14 8K','GR','---','E2E','BELI','BELI001','365000','2026-02-25','0.480','1','kasir','2026-02-25 15:12:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005129','X-00005129');
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-260225-0003','F225191112367','RTA','1','BELI','BELI001','E2E', 'X-00005129', 'CC MODEL MATA VAR LG 14 8K','0.480','0.480','100.00','407000','365000','760417','1260000','1','365000','365000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260225-0003','2026-02-25','2026-02-25','15:12:40','RTA','---','0.480','365000','365000','365000','365000','365000','kasir','2026-02-25 15:12:40','FB-260225-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260225-0003','LS','','','','','kasir','2026-02-25 15:12:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-25' 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-260225-0041','K','2026-02-25','15:12:40','kasir','PEMBELIAN UMUM','FB-260225-0003','6472703000','365000','6472338000');
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-00005130','X-00005130','KL SIEM COBRA BOLA ARESO VAR UB 8K','GR','---','H1F','BELI','BELI001','1375000','2026-02-25','1.310','1','kasir','2026-02-25 15:13:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00005130','X-00005130');
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-260225-0004','F226170307062','TIN','1','BELI','BELI001','H1F', 'X-00005130', 'KL SIEM COBRA BOLA ARESO VAR UB 8K','1.310','1.310','100.00','1529000','1375000','1049618','1275000','1','1375000','1375000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.310',berat_beli_asli=berat_beli_asli+'1.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.310',berat_akhir_asli=berat_akhir_asli+'1.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-260225-0004','2026-02-25','2026-02-25','15:13:07','TIN','---','1.310','1375000','1375000','1375000','1375000','1375000','kasir','2026-02-25 15:13:07','FB-260225-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260225-0004','WENTY','BLORA','','','081325557273','kasir','2026-02-25 15:13:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-25' 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-260225-0042','K','2026-02-25','15:13:07','kasir','PEMBELIAN UMUM','FB-260225-0004','6472338000','1375000','6470963000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260225-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260225-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260225-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260225-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260225-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260225-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260225-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260225-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-25';
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-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-25';
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-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-25' 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-260226-0001','D','2026-02-26','16:13:54','SYSTEM','SALDO AWAL','SALDO AWAL','0','6470963000','6470963000');
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-260226-0001','D','2026-02-26','16:13:54','BCA','SALDO AWAL','SALDO AWAL','0','4288430888','4288430888');
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-260226-0001','D','2026-02-26','16:13:54','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260226-0001','D','2026-02-26','16:13:54','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-260226-0001','D','2026-02-26','16:13:54','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-260226-0001','D','2026-02-26','16:13:54','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-02-26';
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-20260226-0001','1','B1E-ZBBE-122-0','1','0.510','0.510','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZBBE-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZBBE-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-02-26 16:36:17' WHERE kode_barang='B1E-ZBBE-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZBBE-122-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-26 16:36:17','TOKO','SMBK-B','B1E','B1E-ZBBE-122-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' 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='B1E-ZBBE-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZBBE-122-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-20260226-0001','1','B1E-ZBBE-123-0','1','0.580','0.580','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZBBE-123-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZBBE-123-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-02-26 16:36:17' WHERE kode_barang='B1E-ZBBE-123-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZBBE-123-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-26 16:36:17','TOKO','SMBK-B','B1E','B1E-ZBBE-123-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' 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='B1E-ZBBE-123-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZBBE-123-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-20260226-0001','1','B1D-ZBBE-124-0','1','1.100','1.100','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZBBE-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZBBE-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-02-26 16:36:17' WHERE kode_barang='B1D-ZBBE-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZBBE-124-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-26 16:36:17','TOKO','SMBK-B','B1D','B1D-ZBBE-124-0','1','1.100','1.100','1','1.100','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-ZBBE-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZBBE-124-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260226-0001','2026-02-26','16:36','2.190','input','2026-02-25 16:36:17');
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-20260226-0001','1','D1G-ZBBX-51-0','1','0.320','0.320','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZBBX-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZBBX-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-26 16:36:36' WHERE kode_barang='D1G-ZBBX-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZBBX-51-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-26 16:36:36','TOKO','SMBK-D','D1G','D1G-ZBBX-51-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZBBX-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZBBX-51-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-20260226-0001','1','D1G-ZBBX-53-0','1','0.320','0.320','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZBBX-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZBBX-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-26 16:36:36' WHERE kode_barang='D1G-ZBBX-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZBBX-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-26 16:36:36','TOKO','SMBK-D','D1G','D1G-ZBBX-53-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZBBX-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZBBX-53-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-20260226-0001','1','D1F-ZBBE-111-0','1','0.560','0.560','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZBBE-111-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZBBE-111-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-26 16:36:36' WHERE kode_barang='D1F-ZBBE-111-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZBBE-111-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-26 16:36:36','TOKO','SMBK-D','D1F','D1F-ZBBE-111-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZBBE-111-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZBBE-111-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-20260226-0001','1','D1G-ZBBE-112-0','1','0.360','0.360','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZBBE-112-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZBBE-112-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-26 16:36:36' WHERE kode_barang='D1G-ZBBE-112-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZBBE-112-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-26 16:36:36','TOKO','SMBK-D','D1G','D1G-ZBBE-112-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZBBE-112-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZBBE-112-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-20260226-0001','1','D1D-ZBBE-113-0','1','0.910','0.910','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1D-ZBBE-113-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1D-ZBBE-113-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-26 16:36:36' WHERE kode_barang='D1D-ZBBE-113-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1D-ZBBE-113-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-26 16:36:36','TOKO','SMBK-D','D1D','D1D-ZBBE-113-0','1','0.910','0.910','1','0.910','0.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1D-ZBBE-113-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1D-ZBBE-113-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260226-0001','2026-02-26','16:36','2.470','input','2026-02-25 16:36:35');
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-20260226-0001','1','E1E-ZBAD-339-0','1','0.520','0.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAD-339-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAD-339-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E1E-ZBAD-339-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAD-339-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-26 16:36:51','TOKO','SMBK-E','E1E','E1E-ZBAD-339-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZBAD-339-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAD-339-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-20260226-0001','1','E1E-ZBAH-146-0','1','0.520','0.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAH-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAH-146-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E1E-ZBAH-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAH-146-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-26 16:36:51','TOKO','SMBK-E','E1E','E1E-ZBAH-146-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZBAH-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAH-146-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-20260226-0001','1','E2E-ZBAI-164-0','1','0.520','0.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZBAI-164-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZBAI-164-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E2E-ZBAI-164-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZBAI-164-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-26 16:36:51','TOKO','SMBK-E','E2E','E2E-ZBAI-164-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZBAI-164-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZBAI-164-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-20260226-0001','1','E2E-ZBAI-166-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZBAI-166-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZBAI-166-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E2E-ZBAI-166-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZBAI-166-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-26 16:36:51','TOKO','SMBK-E','E2E','E2E-ZBAI-166-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZBAI-166-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZBAI-166-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-20260226-0001','1','E1E-ZBBE-98-0','1','0.490','0.490','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBBE-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBBE-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E1E-ZBBE-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBBE-98-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-26 16:36:51','TOKO','SMBK-E','E1E','E1E-ZBBE-98-0','1','0.490','0.490','1','0.490','0.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZBBE-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBBE-98-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-20260226-0001','1','E2D-ZBBE-99-0','1','1.030','1.030','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBBE-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBBE-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E2D-ZBBE-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBBE-99-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-26 16:36:51','TOKO','SMBK-E','E2D','E2D-ZBBE-99-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZBBE-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBBE-99-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-20260226-0001','1','E2D-ZBBE-100-0','1','1.010','1.010','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBBE-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBBE-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-26 16:36:51' WHERE kode_barang='E2D-ZBBE-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBBE-100-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-26 16:36:51','TOKO','SMBK-E','E2D','E2D-ZBBE-100-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZBBE-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBBE-100-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260226-0001','2026-02-26','16:36','4.600','input','2026-02-25 16:36:51');
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-20260226-0001','1','F1E-ZBBE-64-0','1','2.530','2.530','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBBE-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBBE-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-02-26 16:37:07' WHERE kode_barang='F1E-ZBBE-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBBE-64-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-26 16:37:07','TOKO','SMBK-F','F1E','F1E-ZBBE-64-0','1','2.530','2.530','1','2.530','2.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' 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='F1E-ZBBE-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBBE-64-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-20260226-0001','1','F1E-ZBBE-65-0','1','3.070','3.070','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBBE-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBBE-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-02-26 16:37:07' WHERE kode_barang='F1E-ZBBE-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBBE-65-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-26 16:37:07','TOKO','SMBK-F','F1E','F1E-ZBBE-65-0','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' 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='F1E-ZBBE-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBBE-65-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260226-0001','2026-02-26','16:37','5.600','input','2026-02-25 16:37:07');
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-20260226-0001','1','H1E-ZBBE-16-0','1','2.090','2.090','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBBE-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBBE-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-26 16:37:21' WHERE kode_barang='H1E-ZBBE-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBBE-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-26 16:37:21','TOKO','SMBK-H','H1E','H1E-ZBBE-16-0','1','2.090','2.090','1','2.090','2.090','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-ZBBE-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBBE-16-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260226-0001','2026-02-26','16:37','2.090','input','2026-02-25 16:37:20');