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 ('F226280831141','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YLAH-5-T','GL KAKI RANTE HOLLOW UB 8K ','OL H','0.510','1','100.00','648000','0','0','15000','653000','0','10000','0','663000','NS','T0075934','F3F','0','0','-','0','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YLAH-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='F3F-YLAH-5-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 ('F226280831141','2026-01-28','0.510','2026-01-28','08:31:14','PLG0076892','653000','653000','10000','663000','663000','kasir','2026-01-28 08:31:14','F22628083114');
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-01-28','F226280831141','2026-01-28','08:31:14','NS','663000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260128-0002','D','2026-01-28','08:31:14','kasir','PENJUALAN','F226280831141','5432466000','663000','5433129000','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='F226280831141' 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 ('F226280831142','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZABA-113-T','KL SANTA KH 42CM 8K ','OL H','1.550','1','100.00','1937000','0','0','15000','1954000','0','16000','0','1970000','NS','T0076886','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZABA-113-T' 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-01-28' AND kode_barang='H1E-ZABA-113-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 ('F226280831142','2026-01-28','1.550','2026-01-28','08:31:14','PLG0076893','1954000','1954000','16000','1970000','1970000','kasir','2026-01-28 08:31:14','F22628083114');
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-01-28','F226280831142','2026-01-28','08:31:14','NS','1970000','16000');
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-260128-0003','D','2026-01-28','08:31:14','kasir','PENJUALAN','F226280831142','5433129000','1970000','5435099000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280831142' 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 ('F226280909431','kasir','1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZABA-111-T','KL KOREA UB 45CM 8K ','OL ','1.400','1','100.00','1750000','0','0','15000','1806000','0','7000','0','1813000','RHM','T0076884','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZABA-111-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='H1E-ZABA-111-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 ('F226280909431','2026-01-28','1.400','2026-01-28','09:09:43','PLG0076894','1806000','1806000','7000','1813000','1813000','kasir','2026-01-28 09:09:43','F22628090943');
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-01-28','F226280909431','2026-01-28','09:09:43','RHM','1813000','7000');
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-260128-0004','D','2026-01-28','09:09:43','kasir','PENJUALAN','F226280909431','5435099000','1813000','5436912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1813000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280909431' 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 ('F226280909432','kasir',' 1',' MFF3 KH ','TOKO','SMBK-F','F3F-YJXF-57-T','GL KAKI KOREA VAR KH 8K ','OL ','2.100','1','100.00','2667000','0','0','15000','2751000','0','11000','0','2762000','RHM','T0073955','F3F','0','0','-','0','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJXF-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='F3F-YJXF-57-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 ('F226280909432','2026-01-28','2.100','2026-01-28','09:09:43','PLG0076895','2751000','2751000','11000','2762000','2762000','kasir','2026-01-28 09:09:43','F22628090943');
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-01-28','F226280909432','2026-01-28','09:09:43','RHM','2762000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260128-0005','D','2026-01-28','09:09:43','kasir','PENJUALAN','F226280909432','5436912000','2762000','5439674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2762000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280909432' 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 ('F226280924071','kasir','1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZAAG-24-T','KL KOREA UB 45CM 8K ','OL TW','1.000','1','100.00','1250000','0','0','15000','1295000','0','10000','0','1305000','NS','T0076618','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAG-24-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-01-28' AND kode_barang='H1E-ZAAG-24-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 ('F226280924071','2026-01-28','1.000','2026-01-28','09:24:08','PLG0076896','1295000','1295000','10000','1305000','1305000','kasir','2026-01-28 09:24:07','F22628092407');
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-01-28','F226280924071','2026-01-28','09:24:08','NS','1305000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260128-0006','D','2026-01-28','09:24:08','kasir','PENJUALAN','F226280924071','5439674000','1305000','5440979000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1305000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280924071' 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 ('F226280924072','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZAAC-32-T','LT MODEL FINE GOLD LG 8K ','OL TW','0.500','1','100.00','625000','0','0','15000','648000','0','10000','0','658000','NS','T0076554','D1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZAAC-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='D1E-ZAAC-32-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 ('F226280924072','2026-01-28','0.500','2026-01-28','09:24:08','PLG0076897','648000','648000','10000','658000','658000','kasir','2026-01-28 09:24:07','F22628092407');
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-01-28','F226280924072','2026-01-28','09:24:08','NS','658000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260128-0007','D','2026-01-28','09:24:08','kasir','PENJUALAN','F226280924072','5440979000','658000','5441637000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='658000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280924072' 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 ('F226280930521','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZAAG-26-T','KL KOREA UB 44CM 8K ','OL ','1.000','1','100.00','1250000','0','0','15000','1295000','0','5000','0','1300000','RHM','T0076620','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAG-26-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-01-28' AND kode_barang='H1E-ZAAG-26-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 ('F226280930521','2026-01-28','1.000','2026-01-28','09:30:52','PLG0076898','1295000','1295000','5000','1300000','0','kasir','2026-01-28 09:30:52','F22628093052');
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-01-28','F226280930521','2026-01-28','09:30:52','RHM','1300000','5000');
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-260128-0001','2026-01-28','2026-01-28 09:30:52','PENJUALAN : F226280930521','765485887478464','BCA','1300000','1300000','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-260128-0002','D','2026-01-28','09:30:52','BCA','PENJUALAN','F226280930521','4245897888','1300000','4247197888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('765485887478464','HHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1300000' WHERE no_faktur_jual='F226280930521' 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 ('F226280931301','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZAAC-30-T','LT MODEL FINE GOLD LG 8K ','OL ','0.500','1','100.00','625000','0','0','15000','650000','0','5000','0','655000','RHM','T0076552','D1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZAAC-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='D1E-ZAAC-30-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 ('F226280931301','2026-01-28','0.500','2026-01-28','09:31:32','PLG0076899','650000','650000','5000','655000','0','kasir','2026-01-28 09:31:30','F22628093130');
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-01-28','F226280931301','2026-01-28','09:31:32','RHM','655000','5000');
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-260128-0002','2026-01-28','2026-01-28 09:31:30','PENJUALAN : F226280931301','653653836746745646','BCA','655000','655000','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-260128-0003','D','2026-01-28','09:31:32','BCA','PENJUALAN','F226280931301','4247197888','655000','4247852888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('653653836746745646','HHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='655000' WHERE no_faktur_jual='F226280931301' 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 ('F226281114591','kasir','1',' MFD1 HW ','TOKO','SMBK-D','D1F-YIBB-90-T','LT LETTERA BULAT HW 8K ','OLSBABU','0.600','1','100.00','762000','0','0','15000','795000','0','194000','0','989000','TIN','T0073226','D1F','0','0','-','0','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YIBB-90-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-01-28' AND kode_barang='D1F-YIBB-90-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 ('F226281114591','2026-01-28','0.600','2026-01-28','11:14:59','PLG0076900','795000','795000','194000','989000','989000','kasir','2026-01-28 11:14:59','F22628111459');
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-01-28','F226281114591','2026-01-28','11:14:59','TIN','989000','194000');
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-260128-0008','D','2026-01-28','11:14:59','kasir','PENJUALAN','F226281114591','5441637000','989000','5442626000');
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 ('F226281116071','kasir','1',' TEF1 X UB ','TOKO','TBK-F','F1TE-YLBF-52-T','GL X SHOGUN SLEP UB D56 17K ','','4.550','1','100.00','10283000','0','0','15000','10580000','0','0','0','10580000','NS','T0076222','F1TE','0','0','-','0','2260000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-YLBF-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.550',berat_jual_asli=berat_jual_asli+'4.550',stock_jual='1',berat_akhir=berat_akhir-'4.550',berat_akhir_asli=berat_akhir_asli-'4.550',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='F1TE-YLBF-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226281116071','2026-01-28','4.550','2026-01-28','11:16:07','PLG0076901','10580000','10580000','0','10580000','10580000','kasir','2026-01-28 11:16:07','F22628111607');
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-01-28','F226281116071','2026-01-28','11:16:07','NS','10580000','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-260128-0009','D','2026-01-28','11:16:07','kasir','PENJUALAN','F226281116071','5442626000','10580000','5453206000');
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 ('F226281202241','kasir','1',' MDA1D X HW','TOKO','SMBK-A','A1D-ZABC-23-0','AT X MODEL ARESO SLEP HW 8K ','OL','0.910','1','100.00','1119000','0','0','15000','1170000','0','5000','0','1175000','RTA','00386653','A1D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZABC-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='A1D-ZABC-23-0' 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 ('F226281202241','2026-01-28','0.910','2026-01-28','12:02:25','PLG0076902','1170000','1170000','5000','1175000','1175000','kasir','2026-01-28 12:02:24','F22628120224');
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-01-28','F226281202241','2026-01-28','12:02:25','RTA','1175000','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-260128-0010','D','2026-01-28','12:02:25','kasir','PENJUALAN','F226281202241','5453206000','1175000','5454381000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1175000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281202241' 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 ('F226281202242','kasir',' 1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZABC-19-T','CC BANGKOK PASIR UB 15 8K ','OL','0.560','1','100.00','700000','0','0','15000','731000','0','5000','0','736000','RTA','T0076909','E1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZABC-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='E1E-ZABC-19-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 ('F226281202242','2026-01-28','0.560','2026-01-28','12:02:25','PLG0076903','731000','731000','5000','736000','736000','kasir','2026-01-28 12:02:24','F22628120224');
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-01-28','F226281202242','2026-01-28','12:02:25','RTA','736000','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-260128-0011','D','2026-01-28','12:02:25','kasir','PENJUALAN','F226281202242','5454381000','736000','5455117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='736000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281202242' 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 ('F226281218511','kasir','1',' MIH2I KH 4','TOKO','SMBK-H','H2I-YLBX-22-T','KL JEDAR KH 42 8K ','OL','1.200','1','100.00','1596000','0','0','15000','1656000','0','6000','0','1662000','TIN','T0076007','H2I','0','0','-','0','1330000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YLBX-22-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-01-28' AND kode_barang='H2I-YLBX-22-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 ('F226281218511','2026-01-28','1.200','2026-01-28','12:18:52','PLG0076904','1656000','1656000','6000','1662000','1662000','kasir','2026-01-28 12:18:51','F22628121851');
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-01-28','F226281218511','2026-01-28','12:18:52','TIN','1662000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260128-0012','D','2026-01-28','12:18:52','kasir','PENJUALAN','F226281218511','5455117000','1662000','5456779000');
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 ('F226281226341','kasir','1',' MEF1 X TD ','TOKO','SMBK-F','F1E-ZAXH-195-0','GL X OVAL C SLEP TD 56 8K ','','3.170','1','100.00','3962000','0','0','15000','4090000','0','0','0','4090000','NS','00384281','F1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXH-195-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='F1E-ZAXH-195-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 ('F226281226341','2026-01-28','3.170','2026-01-28','12:26:35','PLG0076905','4090000','4090000','0','4090000','4090000','kasir','2026-01-28 12:26:34','F22628122634');
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-01-28','F226281226341','2026-01-28','12:26:35','NS','4090000','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-260128-0013','D','2026-01-28','12:26:35','kasir','PENJUALAN','F226281226341','5456779000','4090000','5460869000');
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 ('F226280120081','kasir','1',' TDE1 UB 17','TOKO','TBK-E','E1TD-YHBG-7-T','CC MODEL DAUN SLEP UB 17 17K ','','0.950','1','100.00','2128000','0','0','15000','2200000','0','0','0','2200000','NS','T0072599','E1TD','0','0','-','0','2240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='E1TD-YHBG-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226280120081','2026-01-28','0.950','2026-01-28','13:20:08','PLG0076906','2200000','2200000','0','2200000','2200000','kasir','2026-01-28 13:20:08','F22628012008');
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-01-28','F226280120081','2026-01-28','13:20:08','NS','2200000','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-260128-0014','D','2026-01-28','13:20:08','kasir','PENJUALAN','F226280120081','5460869000','2200000','5463069000');
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 ('F226280253471','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YLAA-36-T','CC X COR MODEL MATA 12 CM 17K ','','1.220','1','100.00','2733000','0','0','15000','2818000','0','5000','0','2823000','TIN','T0075694','E2TD','0','0','-','0','2240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YLAA-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='E2TD-YLAA-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226280253471','2026-01-28','1.220','2026-01-28','14:53:47','PLG0076907','2818000','2818000','5000','2823000','2823000','kasir','2026-01-28 14:53:47','F22628025347');
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-01-28','F226280253471','2026-01-28','14:53:47','TIN','2823000','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-260128-0015','D','2026-01-28','14:53:47','kasir','PENJUALAN','F226280253471','5463069000','2823000','5465892000');
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 ('F226280257421','kasir','1',' TEH1 UB 42','TOKO','TBK-H','H1TE-YGBD-84-T','KL NORY UB 42CM 17K ','','2.120','1','100.00','4791000','0','0','15000','4982000','0','0','0','4982000','RTA','T0071512','H1TE','0','0','-','0','2260000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-YGBD-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-01-28' AND kode_barang='H1TE-YGBD-84-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226280257421','2026-01-28','2.120','2026-01-28','14:57:43','PLG0076908','4982000','4982000','0','4982000','4982000','kasir','2026-01-28 14:57:42','F22628025742');
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-01-28','F226280257421','2026-01-28','14:57:43','RTA','4982000','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-260128-0016','D','2026-01-28','14:57:43','kasir','PENJUALAN','F226280257421','5465892000','4982000','5470874000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4982000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280257421' 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 ('F226280257422','kasir',' 1',' TFA1 UB ','TOKO','TBK-A','A1TF-YGAH-191-T','AT MODEL HATI ARESO UB 17K ','','1.000','1','100.00','2280000','0','0','15000','2370000','0','0','0','2370000','RTA','T0071222','A1TF','0','0','-','0','2280000');
UPDATE tm_barang SET tgl_last_jual='2026-01-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-YGAH-191-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-01-28' AND kode_barang='A1TF-YGAH-191-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226280257422','2026-01-28','1.000','2026-01-28','14:57:43','PLG0076909','2370000','2370000','0','2370000','2370000','kasir','2026-01-28 14:57:42','F22628025742');
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-01-28','F226280257422','2026-01-28','14:57:43','RTA','2370000','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-260128-0017','D','2026-01-28','14:57:43','kasir','PENJUALAN','F226280257422','5470874000','2370000','5473244000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2370000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280257422' LIMIT 1;
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-00005055','X-00005055','CC MODEL DAUN SLEP VAR LG 16 8K','GR','---','E1D','BELI','BELI001','860000','2026-01-28','0.970','1','admin','2026-01-28 15:34:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005055','X-00005055');
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-260128-0001','F225020928481','RTA','1','BELI','BELI001','E1D', 'X-00005055', 'CC MODEL DAUN SLEP VAR LG 16 8K','1.010','0.970','100.00','830000','860000','886598','1230000','1','860000','860000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260128-0001','2026-01-28','2026-01-28','15:34:46','RTA','---','0.970','860000','860000','860000','860000','860000','admin','2026-01-28 15:34:46','FB-260128-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260128-0001','ULYA','JL PEMANAHAN KADIPATEN','','','','admin','2026-01-28 15:34:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-28' 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-260128-0018','K','2026-01-28','15:34:46','admin','PEMBELIAN UMUM','FB-260128-0001','5473244000','860000','5472384000');
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-00005056','X-00005056','KL RANTAI HOLLOW HW 46CM','GR','---','H1TE','BELI','BELI001','5820000','2026-01-28','3.000','1','admin','2026-01-28 15:37:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TE','X-00005056','X-00005056');
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-260128-0002','F224151134281','RHM','1','BELI','BELI001','H1TE', 'X-00005056', 'KL RANTAI HOLLOW HW 46CM','3.100','3.000','100.00','2650000','5820000','1940000','2260000','1','5820000','5820000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TE' 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-260128-0002','2026-01-28','2026-01-28','15:37:14','RHM','---','3.000','5820000','5820000','5820000','5820000','5820000','admin','2026-01-28 15:37:14','FB-260128-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260128-0002','WELASATI','JINGGLONG','','','','admin','2026-01-28 15:37:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-28' 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-260128-0019','K','2026-01-28','15:37:14','admin','PEMBELIAN UMUM','FB-260128-0002','5472384000','5820000','5466564000');
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-00005057','X-00005057','LT MODEL HATI MATA CM','GR','---','D2TE','BELI','BELI001','1940000','2026-01-28','1.000','1','admin','2026-01-28 15:38:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00005057','X-00005057');
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-260128-0003','F224151135201','RHM','1','BELI','BELI001','D2TE', 'X-00005057', 'LT MODEL HATI MATA CM','1.100','1.000','100.00','940000','1940000','1940000','2260000','1','1940000','1940000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' 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-260128-0003','2026-01-28','2026-01-28','15:38:10','RHM','---','1.000','1940000','1940000','1940000','1940000','1940000','admin','2026-01-28 15:38:11','FB-260128-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260128-0003','WELASATI','JINGGLONG','','','','admin','2026-01-28 15:38:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-28' 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-260128-0020','K','2026-01-28','15:38:10','admin','PEMBELIAN UMUM','FB-260128-0003','5466564000','1940000','5464624000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260128-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260128-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260128-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260128-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260128-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260128-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280120081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280120081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280120081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280253471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280253471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280253471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280257421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280257421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280257421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280257422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280257422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280257422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280831141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280831141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280831141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280831142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280831142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280831142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280909431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280909431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280909431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280909432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280909432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280909432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280924071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280924071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280924071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280924072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280924072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280924072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280930521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280930521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280930521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280931301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280931301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280931301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281114591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281114591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281114591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281116071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281116071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281116071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281202241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281202241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281202241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281202242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281202242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281202242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281218511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281218511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281218511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281226341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281226341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281226341';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-28';
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-01-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-28' 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-260129-0001','D','2026-01-29','16:00:17','SYSTEM','SALDO AWAL','SALDO AWAL','0','5464624000','5464624000');
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-260129-0001','D','2026-01-29','16:00:17','BCA','SALDO AWAL','SALDO AWAL','0','4247852888','4247852888');
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-260129-0001','D','2026-01-29','16:00:17','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-260129-0001','D','2026-01-29','16:00:17','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-260129-0001','D','2026-01-29','16:00:17','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-260129-0001','D','2026-01-29','16:00:17','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-01-29';
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-20260129-0001','1','A1D-ZABH-15-0','1','1.000','1.000','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZABH-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZABH-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-01-29 16:55:25' WHERE kode_barang='A1D-ZABH-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZABH-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-29 16:55:25','TOKO','SMBK-A','A1D','A1D-ZABH-15-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-ZABH-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZABH-15-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260129-0001','2026-01-29','16:55','1.000','input','2026-01-28 16:55:25');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260129-0001','1','B1E-ZABH-27-0','1','0.560','0.560','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZABH-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZABH-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-01-29 16:55:43' WHERE kode_barang='B1E-ZABH-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZABH-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-29 16:55:43','TOKO','SMBK-B','B1E','B1E-ZABH-27-0','1','0.560','0.560','1','0.560','0.560','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-ZABH-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZABH-27-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-20260129-0001','1','B1E-ZABH-28-0','1','0.610','0.610','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZABH-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZABH-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-01-29 16:55:43' WHERE kode_barang='B1E-ZABH-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZABH-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-29 16:55:43','TOKO','SMBK-B','B1E','B1E-ZABH-28-0','1','0.610','0.610','1','0.610','0.610','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-ZABH-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZABH-28-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260129-0001','2026-01-29','16:55','1.170','input','2026-01-28 16:55:43');
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-20260129-0001','1','D2E-ZABH-58-0','1','0.480','0.480','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZABH-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZABH-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-01-29 16:55:57' WHERE kode_barang='D2E-ZABH-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZABH-58-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-01-29 16:55:57','TOKO','SMBK-D','D2E','D2E-ZABH-58-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' 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='D2E-ZABH-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZABH-58-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-20260129-0001','1','D2E-ZABH-59-0','1','0.610','0.610','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZABH-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZABH-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-01-29 16:55:57' WHERE kode_barang='D2E-ZABH-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZABH-59-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-01-29 16:55:57','TOKO','SMBK-D','D2E','D2E-ZABH-59-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' 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='D2E-ZABH-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZABH-59-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260129-0001','2026-01-29','16:55','1.090','input','2026-01-28 16:55:57');
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-20260129-0001','1','E1D-ZABH-257-0','1','0.900','0.900','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZABH-257-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZABH-257-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-29 16:56:11' WHERE kode_barang='E1D-ZABH-257-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZABH-257-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-01-29 16:56:11','TOKO','SMBK-E','E1D','E1D-ZABH-257-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZABH-257-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZABH-257-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-20260129-0001','1','E1D-ZABH-258-0','1','1.170','1.170','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZABH-258-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZABH-258-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-29 16:56:11' WHERE kode_barang='E1D-ZABH-258-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZABH-258-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-01-29 16:56:11','TOKO','SMBK-E','E1D','E1D-ZABH-258-0','1','1.170','1.170','1','1.170','1.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZABH-258-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZABH-258-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260129-0001','2026-01-29','16:56','2.070','input','2026-01-28 16:56:10');
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-20260129-0001','1','F3E-ZABH-107-0','1','4.960','4.960','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZABH-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZABH-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-01-29 16:56:25' WHERE kode_barang='F3E-ZABH-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZABH-107-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-01-29 16:56:25','TOKO','SMBK-F','F3E','F3E-ZABH-107-0','1','4.960','4.960','1','4.960','4.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZABH-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZABH-107-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-20260129-0001','1','F3E-ZABH-108-0','1','2.940','2.940','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZABH-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZABH-108-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-01-29 16:56:25' WHERE kode_barang='F3E-ZABH-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZABH-108-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-01-29 16:56:25','TOKO','SMBK-F','F3E','F3E-ZABH-108-0','1','2.940','2.940','1','2.940','2.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZABH-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZABH-108-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260129-0001','2026-01-29','16:56','7.900','input','2026-01-28 16:56:24');
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-20260129-0001','1','H1E-ZABH-135-0','1','1.910','1.910','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZABH-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZABH-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-01-29 16:56:40' WHERE kode_barang='H1E-ZABH-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZABH-135-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-01-29 16:56:40','TOKO','SMBK-H','H1E','H1E-ZABH-135-0','1','1.910','1.910','1','1.910','1.910','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-ZABH-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZABH-135-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260129-0001','2026-01-29','16:56','1.910','input','2026-01-28 16:56:40');