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 ('F226220829201','kasir','1',' MEA1E PM ','TOKO','SMBK-A','A1E-ZFAF-16-T','AT ITALY VAR SLEP PM 8K','OL','0.550','1','100.00','588000','0','0','15000','616000','0','5000','0','621000','LUS','T0080451','A1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFAF-16-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-08-22' AND kode_barang='A1E-ZFAF-16-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 ('F226220829201','2026-08-22','0.550','2026-08-22','08:29:20','PLG0083847','616000','616000','5000','621000','621000','kasir','2026-08-22 08:29:20','F22622082920');
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-08-22','F226220829201','2026-08-22','08:29:20','LUS','621000','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-260822-0002','D','2026-08-22','08:29:20','kasir','PENJUALAN','F226220829201','13926165000','621000','13926786000');
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 ('F226220830371','kasir','1',' MDA1D CM ','TOKO','SMBK-A','A1D-ZHBA-46-T','AT KLIP VERONA SLEP CM 8K ','OL','1.020','1','100.00','1071000','0','0','15000','1117000','0','5000','0','1122000','LUS','T0082338','A1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHBA-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='A1D-ZHBA-46-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 ('F226220830371','2026-08-22','1.020','2026-08-22','08:30:38','PLG0083848','1117000','1117000','5000','1122000','1122000','kasir','2026-08-22 08:30:37','F22622083037');
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-08-22','F226220830371','2026-08-22','08:30:38','LUS','1122000','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-260822-0003','D','2026-08-22','08:30:38','kasir','PENJUALAN','F226220830371','13926786000','1122000','13927908000');
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 ('F226220839411','kasir','1',' MEE2E KH 2','TOKO','SMBK-E','E2E-ZHBA-32-T','CC MODEL SNACK MATA SLEP KH 20 8K ','OL','0.500','1','100.00','580000','0','0','15000','560000','0','5000','0','565000','TIN','T0082324','E2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-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-08-22' AND kode_barang='E2E-ZHBA-32-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 ('F226220839411','2026-08-22','0.500','2026-08-22','08:39:42','PLG0083849','560000','560000','5000','565000','565000','kasir','2026-08-22 08:39:41','F22622083941');
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-08-22','F226220839411','2026-08-22','08:39:42','TIN','565000','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-260822-0004','D','2026-08-22','08:39:42','kasir','PENJUALAN','F226220839411','13927908000','565000','13928473000');
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 ('F226220844421','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZHBA-33-T','CC MODEL SLEP CM 12 8K ','OL','0.550','1','100.00','638000','0','0','15000','619000','0','5000','0','624000','DIN','T0082325','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-33-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-08-22' AND kode_barang='E1E-ZHBA-33-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 ('F226220844421','2026-08-22','0.550','2026-08-22','08:44:42','PLG0083850','619000','619000','5000','624000','624000','kasir','2026-08-22 08:44:42','F22622084442');
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-08-22','F226220844421','2026-08-22','08:44:42','DIN','624000','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-260822-0005','D','2026-08-22','08:44:42','kasir','PENJUALAN','F226220844421','13928473000','624000','13929097000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='624000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220844421' 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 ('F226220844422','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZHBA-36-T','CC MODEL SLEP CM 14 8K ','OL','0.560','1','100.00','650000','0','0','15000','630000','0','5000','0','635000','DIN','T0082328','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-36-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-08-22' AND kode_barang='E1E-ZHBA-36-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 ('F226220844422','2026-08-22','0.560','2026-08-22','08:44:42','PLG0083851','630000','630000','5000','635000','635000','kasir','2026-08-22 08:44:42','F22622084442');
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-08-22','F226220844422','2026-08-22','08:44:42','DIN','635000','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-260822-0006','D','2026-08-22','08:44:42','kasir','PENJUALAN','F226220844422','13929097000','635000','13929732000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220844422' 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 ('F226220844423','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZHBA-38-T','CC MODEL SLEP CM 16 8K ','OL','0.600','1','100.00','696000','0','0','15000','675000','0','5000','0','680000','DIN','T0082330','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-38-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-08-22' AND kode_barang='E1E-ZHBA-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 ('F226220844423','2026-08-22','0.600','2026-08-22','08:44:42','PLG0083852','675000','675000','5000','680000','680000','kasir','2026-08-22 08:44:42','F22622084442');
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-08-22','F226220844423','2026-08-22','08:44:42','DIN','680000','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-260822-0007','D','2026-08-22','08:44:42','kasir','PENJUALAN','F226220844423','13929732000','680000','13930412000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='680000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220844423' 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 ('F226220844424','kasir',' 1',' MDA1D UB ','TOKO','SMBK-A','A1D-ZHXG-1-T','AT ITALY VAR SLEP UB 8K ','OL','0.910','1','100.00','955000','0','0','15000','1006000','0','5000','0','1011000','DIN','T0082054','A1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHXG-1-T' 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-08-22' AND kode_barang='A1D-ZHXG-1-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 ('F226220844424','2026-08-22','0.910','2026-08-22','08:44:42','PLG0083853','1006000','1006000','5000','1011000','1011000','kasir','2026-08-22 08:44:42','F22622084442');
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-08-22','F226220844424','2026-08-22','08:44:42','DIN','1011000','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-260822-0008','D','2026-08-22','08:44:42','kasir','PENJUALAN','F226220844424','13930412000','1011000','13931423000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1011000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220844424' 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 ('F226220845421','kasir','1',' MEE1E 5K C','TOKO','SMBK-E','E1E-ZHBA-99-T','CC MODEL SLEP CM 16 8K ','OL','0.600','1','100.00','696000','0','0','15000','663000','0','5000','0','668000','LUS','T0082391','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-99-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-08-22' AND kode_barang='E1E-ZHBA-99-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 ('F226220845421','2026-08-22','0.600','2026-08-22','08:45:42','PLG0083854','663000','663000','5000','668000','668000','kasir','2026-08-22 08:45:42','F22622084542');
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-08-22','F226220845421','2026-08-22','08:45:42','LUS','668000','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-260822-0009','D','2026-08-22','08:45:42','kasir','PENJUALAN','F226220845421','13931423000','668000','13932091000');
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 ('F226220859401','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZHXG-210-0','KL X TIFF SLEP VAR UB 8K ','OL','1.180','1','100.00','1263000','0','0','15000','1316000','0','6000','0','1322000','DIN','00417629','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXG-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='H1E-ZHXG-210-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 ('F226220859401','2026-08-22','1.180','2026-08-22','08:59:41','PLG0083855','1316000','1316000','6000','1322000','1322000','kasir','2026-08-22 08:59:40','F22622085940');
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-08-22','F226220859401','2026-08-22','08:59:41','DIN','1322000','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-260822-0010','D','2026-08-22','08:59:41','kasir','PENJUALAN','F226220859401','13932091000','1322000','13933413000');
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 ('F226220916301','kasir','1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBA-29-T','CC MODEL SNACK MATA SLEP KH 14 8K ','OL','0.470','1','100.00','545000','0','0','15000','526000','0','5000','0','531000','LUS','T0082321','E2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E2E-ZHBA-29-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 ('F226220916301','2026-08-22','0.470','2026-08-22','09:16:31','PLG0083856','526000','526000','5000','531000','531000','kasir','2026-08-22 09:16:30','F22622091630');
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-08-22','F226220916301','2026-08-22','09:16:31','LUS','531000','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-260822-0011','D','2026-08-22','09:16:31','kasir','PENJUALAN','F226220916301','13933413000','531000','13933944000');
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 ('F226220918501','kasir','1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZHXE-136-T','GW TUSUK DAISY MATA SLEP LG 8K ','OL','0.320','1','100.00','349000','0','0','15000','365000','0','5000','0','370000','TIN','T0082049','B1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZHXE-136-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='B1F-ZHXE-136-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 ('F226220918501','2026-08-22','0.320','2026-08-22','09:18:51','PLG0083857','365000','365000','5000','370000','370000','kasir','2026-08-22 09:18:50','F22622091850');
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-08-22','F226220918501','2026-08-22','09:18:51','TIN','370000','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-260822-0012','D','2026-08-22','09:18:51','kasir','PENJUALAN','F226220918501','13933944000','370000','13934314000');
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 ('F226220923261','kasir','1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZHXG-5-T','AT TINDIK BABY CM 8K ','OL','0.270','1','100.00','300000','0','0','15000','313000','0','5000','0','318000','LUS','T0082058','A1G','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZHXG-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='A1G-ZHXG-5-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 ('F226220923261','2026-08-22','0.270','2026-08-22','09:23:27','PLG0083858','313000','313000','5000','318000','318000','kasir','2026-08-22 09:23:26','F22622092326');
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-08-22','F226220923261','2026-08-22','09:23:27','LUS','318000','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-260822-0013','D','2026-08-22','09:23:27','kasir','PENJUALAN','F226220923261','13934314000','318000','13934632000');
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 ('F226220926361','kasir','1',' MEF3E KH ','TOKO','SMBK-F','F3E-ZHXD-47-T','GL KAKI TIFF VAR SLEP KH 8K ','OL','2.050','1','100.00','2193000','0','0','15000','2296000','0','10000','0','2306000','DIN','T0081885','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXD-47-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-08-22' AND kode_barang='F3E-ZHXD-47-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 ('F226220926361','2026-08-22','2.050','2026-08-22','09:26:37','PLG0083859','2296000','2296000','10000','2306000','2306000','kasir','2026-08-22 09:26:36','F22622092636');
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-08-22','F226220926361','2026-08-22','09:26:37','DIN','2306000','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-260822-0014','D','2026-08-22','09:26:37','kasir','PENJUALAN','F226220926361','13934632000','2306000','13936938000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2306000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220926361' 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 ('F226220926362','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZHAI-59-0','GL X CASTELLY ARESO VAR SLEEP HW 8K ','OL','3.040','1','100.00','3526000','0','0','15000','3405000','0','15000','0','3420000','DIN','00419459','F3E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAI-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='F3E-ZHAI-59-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 ('F226220926362','2026-08-22','3.040','2026-08-22','09:26:37','PLG0083860','3405000','3405000','15000','3420000','3420000','kasir','2026-08-22 09:26:36','F22622092636');
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-08-22','F226220926362','2026-08-22','09:26:37','DIN','3420000','15000');
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-260822-0015','D','2026-08-22','09:26:37','kasir','PENJUALAN','F226220926362','13936938000','3420000','13940358000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220926362' 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 ('F226220926363','kasir',' 1',' MFS1F X DG','TOKO','SMBK-S','S1F-ZHXH-1-0','AS X EXTENTION SLEP DG 8K ','OL','0.360','1','100.00','392000','0','0','15000','412000','0','5000','0','417000','DIN','00417730','S1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1F-ZHXH-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='S1F-ZHXH-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226220926363','2026-08-22','0.360','2026-08-22','09:26:37','PLG0083861','412000','412000','5000','417000','417000','kasir','2026-08-22 09:26:36','F22622092636');
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-08-22','F226220926363','2026-08-22','09:26:37','DIN','417000','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-260822-0016','D','2026-08-22','09:26:37','kasir','PENJUALAN','F226220926363','13940358000','417000','13940775000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='417000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220926363' 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 ('F226220944541','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXA-23-T','CC MODEL MATA VAR CM 14 8K ','','0.750','1','100.00','802000','0','0','15000','833000','0','0','0','833000','LUS','T0073515','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXA-23-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-08-22' AND kode_barang='E2E-YJXA-23-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 ('F226220944541','2026-08-22','0.750','2026-08-22','09:44:54','PLG0083862','833000','833000','0','833000','833000','kasir','2026-08-22 09:44:54','F22622094454');
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-08-22','F226220944541','2026-08-22','09:44:54','LUS','833000','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-260822-0017','D','2026-08-22','09:44:54','kasir','PENJUALAN','F226220944541','13940775000','833000','13941608000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='833000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220944541' 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 ('F226220944542','kasir',' 1',' MEF3E YT ','TOKO','SMBK-F','F3E-ZHXD-13-T','GL KOREA SLEP YT 8K ','','0.980','1','100.00','1049000','0','0','15000','1088000','0','0','0','1088000','LUS','T0081851','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXD-13-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-08-22' AND kode_barang='F3E-ZHXD-13-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 ('F226220944542','2026-08-22','0.980','2026-08-22','09:44:54','PLG0083863','1088000','1088000','0','1088000','1088000','kasir','2026-08-22 09:44:54','F22622094454');
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-08-22','F226220944542','2026-08-22','09:44:54','LUS','1088000','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-260822-0018','D','2026-08-22','09:44:54','kasir','PENJUALAN','F226220944542','13941608000','1088000','13942696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1088000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220944542' 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 ('F226220958461','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZHBA-4-T','CC MODEL SPECTRA SLEP KH 14 8K ','OL','0.350','1','100.00','381000','0','0','15000','399000','0','5000','0','404000','DIN','T0082296','E1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBA-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1F-ZHBA-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 ('F226220958461','2026-08-22','0.350','2026-08-22','09:58:47','PLG0083864','399000','399000','5000','404000','404000','kasir','2026-08-22 09:58:46','F22622095846');
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-08-22','F226220958461','2026-08-22','09:58:47','DIN','404000','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-260822-0019','D','2026-08-22','09:58:47','kasir','PENJUALAN','F226220958461','13942696000','404000','13943100000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='404000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220958461' 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 ('F226220958462','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZHAE-202-0','CC X MODEL DAUN SLEP LG 14 8K ','OL','0.430','1','100.00','460000','0','0','15000','482000','0','5000','0','487000','DIN','00419223','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHAE-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1E-ZHAE-202-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 ('F226220958462','2026-08-22','0.430','2026-08-22','09:58:47','PLG0083865','482000','482000','5000','487000','487000','kasir','2026-08-22 09:58:46','F22622095846');
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-08-22','F226220958462','2026-08-22','09:58:47','DIN','487000','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-260822-0020','D','2026-08-22','09:58:47','kasir','PENJUALAN','F226220958462','13943100000','487000','13943587000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='487000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220958462' 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 ('F226220958463','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZHXE-10-T','CC MODEL DAUN SLEP LG 12 8K ','OL','0.480','1','100.00','514000','0','0','15000','538000','0','5000','0','543000','DIN','T0081923','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXE-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1E-ZHXE-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 ('F226220958463','2026-08-22','0.480','2026-08-22','09:58:47','PLG0083866','538000','538000','5000','543000','543000','kasir','2026-08-22 09:58:46','F22622095846');
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-08-22','F226220958463','2026-08-22','09:58:47','DIN','543000','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-260822-0021','D','2026-08-22','09:58:47','kasir','PENJUALAN','F226220958463','13943587000','543000','13944130000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220958463' 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 ('F226221000401','kasir','1',' MEE1 LG 18','TOKO','SMBK-E','E1E-ZHAA-104-T','CC COR MODEL DAUN VAR 18 LG 8K ','OL','0.500','1','100.00','535000','0','0','15000','560000','0','5000','0','565000','DIN','T0082244','E1E','0','0','-','0','1160000');
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 ('F226221002351','kasir','1',' MEE1 LG 18','TOKO','SMBK-E','E1E-ZHAA-104-T','CC COR MODEL DAUN VAR 18 LG 8K ','OL','0.500','1','100.00','535000','0','0','15000','560000','0','5000','0','565000','DIN','T0082244','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHAA-104-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-08-22' AND kode_barang='E1E-ZHAA-104-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 ('F226221002351','2026-08-22','0.500','2026-08-22','10:02:36','PLG0083868','560000','560000','5000','565000','565000','kasir','2026-08-22 10:02:35','F22622100235');
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-08-22','F226221002351','2026-08-22','10:02:36','DIN','565000','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-260822-0022','D','2026-08-22','10:02:36','kasir','PENJUALAN','F226221002351','13944130000','565000','13944695000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221002351' 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 ('F226221002352','kasir',' 1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBA-41-T','CC MODEL SNACK MATA SLEP KH 18 8K ','OL','0.520','1','100.00','603000','0','0','15000','582000','0','5000','0','587000','DIN','T0082333','E2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-41-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-08-22' AND kode_barang='E2E-ZHBA-41-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 ('F226221002352','2026-08-22','0.520','2026-08-22','10:02:36','PLG0083869','582000','582000','5000','587000','587000','kasir','2026-08-22 10:02:35','F22622100235');
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-08-22','F226221002352','2026-08-22','10:02:36','DIN','587000','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-260822-0023','D','2026-08-22','10:02:36','kasir','PENJUALAN','F226221002352','13944695000','587000','13945282000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='587000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221002352' 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 ('F226221003261','kasir','1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBA-23-T','CC MODEL SNACK MATA SLEP KH 12 8K ','OL','0.500','1','100.00','580000','0','0','15000','560000','0','5000','0','565000','DIN','T0082315','E2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-23-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-08-22' AND kode_barang='E2E-ZHBA-23-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 ('F226221003261','2026-08-22','0.500','2026-08-22','10:03:27','PLG0083870','560000','560000','5000','565000','565000','kasir','2026-08-22 10:03:26','F22622100326');
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-08-22','F226221003261','2026-08-22','10:03:27','DIN','565000','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-260822-0024','D','2026-08-22','10:03:27','kasir','PENJUALAN','F226221003261','13945282000','565000','13945847000');
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 ('F226221003571','kasir','1',' MEB1E X LG','TOKO','SMBK-B','B1E-ZHAE-44-0','GW X TOGE MODEL SLEEP LG 8K ','OL','0.520','1','100.00','556000','0','0','15000','582000','0','5000','0','587000','DIN','00419065','B1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHAE-44-0' 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-08-22' AND kode_barang='B1E-ZHAE-44-0' 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 ('F226221003571','2026-08-22','0.520','2026-08-22','10:03:58','PLG0083871','582000','582000','5000','587000','587000','kasir','2026-08-22 10:03:57','F22622100357');
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-08-22','F226221003571','2026-08-22','10:03:58','DIN','587000','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-260822-0025','D','2026-08-22','10:03:58','kasir','PENJUALAN','F226221003571','13945847000','587000','13946434000');
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 ('F226221022001','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZCCX-476-0','CC X MODEL MATA CM 14 8K ','','1.060','1','100.00','1113000','0','0','15000','1155000','0','0','0','1155000','NOV','00397130','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-476-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E2D-ZCCX-476-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 ('F226221022001','2026-08-22','1.060','2026-08-22','10:22:00','PLG0083872','1155000','1155000','0','1155000','1155000','kasir','2026-08-22 10:22:00','F22622102200');
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-08-22','F226221022001','2026-08-22','10:22:00','NOV','1155000','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-260822-0026','D','2026-08-22','10:22:00','kasir','PENJUALAN','F226221022001','13946434000','1155000','13947589000');
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 ('F226221024281','kasir','1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZHXC-98-T','LT MODEL SLOBOK BINTANG SLEP LG 8K ','','0.360','1','100.00','392000','0','0','15000','409000','0','0','0','409000','DIN','T0081827','D1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHXC-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='D1F-ZHXC-98-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 ('F226221024281','2026-08-22','0.360','2026-08-22','10:24:29','PLG0083873','409000','409000','0','409000','409000','kasir','2026-08-22 10:24:28','F22622102428');
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-08-22','F226221024281','2026-08-22','10:24:29','DIN','409000','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-260822-0027','D','2026-08-22','10:24:29','kasir','PENJUALAN','F226221024281','13947589000','409000','13947998000');
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 ('F226221031091','kasir','1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZHXG-107-0','CC X MODEL ARESO SLEP KH 14 8K ','OL','0.330','1','100.00','360000','0','0','15000','376000','0','5000','0','381000','TIN','00417526','E1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHXG-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1F-ZHXG-107-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 ('F226221031091','2026-08-22','0.330','2026-08-22','10:31:10','PLG0083874','376000','376000','5000','381000','381000','kasir','2026-08-22 10:31:09','F22622103109');
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-08-22','F226221031091','2026-08-22','10:31:10','TIN','381000','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-260822-0028','D','2026-08-22','10:31:10','kasir','PENJUALAN','F226221031091','13947998000','381000','13948379000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='381000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221031091' 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 ('F226221031092','kasir',' 1',' MEF3 10K Y','TOKO','SMBK-F','F3E-ZHAA-351-0','GL TIFF SPECTRA HITAM VAR YT 8K ','OL','1.410','1','100.00','1509000','0','0','15000','1569000','0','10000','0','1579000','TIN','00418880','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAA-351-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='F3E-ZHAA-351-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 ('F226221031092','2026-08-22','1.410','2026-08-22','10:31:10','PLG0083875','1569000','1569000','10000','1579000','1579000','kasir','2026-08-22 10:31:09','F22622103109');
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-08-22','F226221031092','2026-08-22','10:31:10','TIN','1579000','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-260822-0029','D','2026-08-22','10:31:10','kasir','PENJUALAN','F226221031092','13948379000','1579000','13949958000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1579000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221031092' 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 ('F226221032261','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YHAB-58-T','GL MODEL FANCY VAR HW 8K ','','1.650','1','100.00','1765000','0','0','15000','1832000','0','0','0','1832000','LUS','T0072265','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHAB-58-T' 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-08-22' AND kode_barang='F3E-YHAB-58-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 ('F226221032261','2026-08-22','1.650','2026-08-22','10:32:27','PLG0083876','1832000','1832000','0','1832000','1832000','kasir','2026-08-22 10:32:26','F22622103226');
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-08-22','F226221032261','2026-08-22','10:32:27','LUS','1832000','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-260822-0030','D','2026-08-22','10:32:27','kasir','PENJUALAN','F226221032261','13949958000','1832000','13951790000');
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 ('F226221036401','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZHXH-361-0','CC X MODEL MATA CM 12 8K ','','0.650','1','100.00','695000','0','0','15000','722000','0','0','0','722000','NOV','00418091','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHXH-361-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E2E-ZHXH-361-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 ('F226221036401','2026-08-22','0.650','2026-08-22','10:36:40','PLG0083877','722000','722000','0','722000','722000','kasir','2026-08-22 10:36:40','F22622103640');
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-08-22','F226221036401','2026-08-22','10:36:40','NOV','722000','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-260822-0031','D','2026-08-22','10:36:40','kasir','PENJUALAN','F226221036401','13951790000','722000','13952512000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='722000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221036401' 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 ('F226221036402','kasir',' 1',' MEE1 X UB ','TOKO','SMBK-E','E1E-ZHAE-198-0','CC X MODEL SLEP UB 12 8K ','','0.710','1','100.00','760000','0','0','15000','788000','0','0','0','788000','NOV','00419219','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHAE-198-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1E-ZHAE-198-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 ('F226221036402','2026-08-22','0.710','2026-08-22','10:36:40','PLG0083878','788000','788000','0','788000','788000','kasir','2026-08-22 10:36:40','F22622103640');
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-08-22','F226221036402','2026-08-22','10:36:40','NOV','788000','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-260822-0032','D','2026-08-22','10:36:40','kasir','PENJUALAN','F226221036402','13952512000','788000','13953300000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='788000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221036402' 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 ('F226221130141','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZHBA-35-T','CC MODEL SLEP CM 14 8K ','OL','0.580','1','100.00','673000','0','0','15000','650000','0','5000','0','655000','TIN','T0082327','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1E-ZHBA-35-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 ('F226221130141','2026-08-22','0.580','2026-08-22','11:30:14','PLG0083879','650000','650000','5000','655000','655000','kasir','2026-08-22 11:30:14','F22622113014');
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-08-22','F226221130141','2026-08-22','11:30:14','TIN','655000','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-260822-0033','D','2026-08-22','11:30:14','kasir','PENJUALAN','F226221130141','13953300000','655000','13953955000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='655000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221130141' 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 ('F226221130142','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZHBA-37-T','CC MODEL SLEP CM 16 8K ','OL','0.620','1','100.00','719000','0','0','15000','694000','0','5000','0','699000','TIN','T0082329','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E1E-ZHBA-37-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 ('F226221130142','2026-08-22','0.620','2026-08-22','11:30:14','PLG0083880','694000','694000','5000','699000','699000','kasir','2026-08-22 11:30:14','F22622113014');
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-08-22','F226221130142','2026-08-22','11:30:14','TIN','699000','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-260822-0034','D','2026-08-22','11:30:14','kasir','PENJUALAN','F226221130142','13953955000','699000','13954654000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='699000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221130142' 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 ('F226221140101','kasir','1',' TEB1 X LG ','TOKO','TBK-B','B1TE-ZDXD-119-T','GW X TUSUK MODEL PITA LG PE 17K ','','0.470','1','100.00','931000','0','0','15000','950000','0','0','0','950000','LUS','T0078406','B1TE','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-ZDXD-119-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='B1TE-ZDXD-119-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226221140101','2026-08-22','0.470','2026-08-22','11:40:10','PLG0083881','950000','950000','0','950000','950000','kasir','2026-08-22 11:40:10','F22622114010');
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-08-22','F226221140101','2026-08-22','11:40:10','LUS','950000','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-260822-0035','D','2026-08-22','11:40:10','kasir','PENJUALAN','F226221140101','13954654000','950000','13955604000');
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 ('F226221224491','kasir','1',' TEH1 HW 44','TOKO','TBK-H','H1TE-ZGBI-62-T','KL RANTAI HOLLOW SLEP HW 44 17K ','OL','2.130','1','100.00','4217000','0','0','15000','4266000','0','15000','0','4281000','TIN','T0081721','H1TE','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZGBI-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='H1TE-ZGBI-62-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 ('F226221224491','2026-08-22','2.130','2026-08-22','12:24:50','PLG0083882','4266000','4266000','15000','4281000','4281000','kasir','2026-08-22 12:24:49','F22622122449');
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-08-22','F226221224491','2026-08-22','12:24:50','TIN','4281000','15000');
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-260822-0036','D','2026-08-22','12:24:50','kasir','PENJUALAN','F226221224491','13955604000','4281000','13959885000');
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 ('F226221237281','kasir','1',' MDA1D CM ','TOKO','SMBK-A','A1D-ZHBA-47-T','AT KLIP VERONA SLEP CM 8K ','OL','1.000','1','100.00','1050000','0','0','15000','1095000','0','5000','0','1100000','TIN','T0082339','A1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHBA-47-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-08-22' AND kode_barang='A1D-ZHBA-47-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 ('F226221237281','2026-08-22','1.000','2026-08-22','12:37:29','PLG0083883','1095000','1095000','5000','1100000','1100000','kasir','2026-08-22 12:37:28','F22622123728');
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-08-22','F226221237281','2026-08-22','12:37:29','TIN','1100000','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-260822-0037','D','2026-08-22','12:37:29','kasir','PENJUALAN','F226221237281','13959885000','1100000','13960985000');
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 ('F226221239241','kasir','1',' TDE2 X UB ','TOKO','TBK-E','E2TD-YIXD-106-T','CC X MODEL MATA VAR UB 9 17K ','OL','1.710','1','100.00','3352000','0','0','15000','3425000','0','12000','0','3437000','TIN','T0072958','E2TD','0','0','-','0','1960000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXD-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='E2TD-YIXD-106-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 ('F226221239241','2026-08-22','1.710','2026-08-22','12:39:24','PLG0083884','3425000','3425000','12000','3437000','3437000','kasir','2026-08-22 12:39:24','F22622123924');
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-08-22','F226221239241','2026-08-22','12:39:24','TIN','3437000','12000');
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-260822-0038','D','2026-08-22','12:39:24','kasir','PENJUALAN','F226221239241','13960985000','3437000','13964422000');
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 ('F226221243591','kasir','1',' TEH2 X HW ','TOKO','TBK-H','H2TE-ZGBH-33-T','KL X TIFF SOLITAIRE MATA VAR SLEP HW 42 17K ','OL','2.680','1','100.00','5306000','0','0','15000','5421000','0','19000','0','5440000','TIN','T0081633','H2TE','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TE-ZGBH-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='H2TE-ZGBH-33-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 ('F226221243591','2026-08-22','2.680','2026-08-22','12:43:59','PLG0083885','5421000','5421000','19000','5440000','5440000','kasir','2026-08-22 12:43:59','F22622124359');
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-08-22','F226221243591','2026-08-22','12:43:59','TIN','5440000','19000');
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-260822-0039','D','2026-08-22','12:43:59','kasir','PENJUALAN','F226221243591','13964422000','5440000','13969862000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5440000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221243591' 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 ('F226221243592','kasir',' 1',' TEH1 X UB ','TOKO','TBK-H','H1TE-ZDXD-158-T','KL X SANTA BOLA PASIR MATA VAR UB 17K ','OL','3.520','1','100.00','6970000','0','0','15000','7121000','0','25000','0','7146000','TIN','T0078445','H1TE','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZDXD-158-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.520',berat_jual_asli=berat_jual_asli+'3.520',stock_jual='1',berat_akhir=berat_akhir-'3.520',berat_akhir_asli=berat_akhir_asli-'3.520',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='H1TE-ZDXD-158-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 ('F226221243592','2026-08-22','3.520','2026-08-22','12:43:59','PLG0083886','7121000','7121000','25000','7146000','7146000','kasir','2026-08-22 12:43:59','F22622124359');
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-08-22','F226221243592','2026-08-22','12:43:59','TIN','7146000','25000');
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-260822-0040','D','2026-08-22','12:43:59','kasir','PENJUALAN','F226221243592','13969862000','7146000','13977008000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7146000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221243592' 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 ('F226221250161','kasir','1',' TEH2 X HW ','TOKO','TBK-H','H2TE-ZGBH-33-T','KL X TIFF SOLITAIRE MATA VAR SLEP HW 42 17K ','OL','2.680','1','100.00','5306000','0','0','15000','5421000','0','19000','0','5440000','TIN','T0081633','H2TE','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TE-ZGBH-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='H2TE-ZGBH-33-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 ('F226221250161','2026-08-22','2.680','2026-08-22','12:50:16','PLG0083887','5421000','5421000','19000','5440000','5440000','kasir','2026-08-22 12:50:16','F22622125016');
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-08-22','F226221250161','2026-08-22','12:50:16','TIN','5440000','19000');
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-260822-0042','D','2026-08-22','12:50:16','kasir','PENJUALAN','F226221250161','13971568000','5440000','13977008000');
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 ('F226220200011','kasir','1',' MEE1E HT 1','TOKO','SMBK-E','E1E-ZGAD-68-T','CC MODEL BANGKOK VAR SLEP HT 18 8K ','','0.500','1','100.00','535000','0','0','15000','548000','0','0','0','548000','LUS','T0081145','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAD-68-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-08-22' AND kode_barang='E1E-ZGAD-68-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 ('F226220200011','2026-08-22','0.500','2026-08-22','14:00:01','PLG0083888','548000','548000','0','548000','548000','kasir','2026-08-22 14:00:01','F22622020001');
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-08-22','F226220200011','2026-08-22','14:00:01','LUS','548000','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-260822-0043','D','2026-08-22','14:00:01','kasir','PENJUALAN','F226220200011','13977008000','548000','13977556000');
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 ('F226220234311','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZHBA-79-T','GL CASTELI SPECTRA SLEP HW 8K ','OL','1.560','1','100.00','1810000','0','0','15000','1716000','0','8000','0','1724000','DIN','T0082371','F3E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBA-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='F3E-ZHBA-79-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 ('F226220234311','2026-08-22','1.560','2026-08-22','14:34:31','PLG0083889','1716000','1716000','8000','1724000','1724000','kasir','2026-08-22 14:34:31','F22622023431');
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-08-22','F226220234311','2026-08-22','14:34:31','DIN','1724000','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-260822-0044','D','2026-08-22','14:34:31','kasir','PENJUALAN','F226220234311','13977556000','1724000','13979280000');
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 ('F226220242351','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZHAI-58-0','GL X KAKI GUCCI SLEEP UB 8K ','OL','0.820','1','100.00','951000','0','0','15000','906000','0','5000','0','911000','TIN','00419458','F3E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAI-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='F3E-ZHAI-58-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 ('F226220242351','2026-08-22','0.820','2026-08-22','14:42:36','PLG0083890','906000','906000','5000','911000','911000','kasir','2026-08-22 14:42:35','F22622024235');
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-08-22','F226220242351','2026-08-22','14:42:36','TIN','911000','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-260822-0045','D','2026-08-22','14:42:36','kasir','PENJUALAN','F226220242351','13979280000','911000','13980191000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='911000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220242351' 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 ('F226220242352','kasir',' 1',' MEF2E UB 5','TOKO','SMBK-F','F2E-ZHBA-77-T','GL OVAL PAKU MATA SLEP UB 54 8K ','OL','2.230','1','100.00','2587000','0','0','15000','2453000','0','11000','0','2464000','TIN','T0082369','F2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZHBA-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='F2E-ZHBA-77-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 ('F226220242352','2026-08-22','2.230','2026-08-22','14:42:36','PLG0083891','2453000','2453000','11000','2464000','2464000','kasir','2026-08-22 14:42:35','F22622024235');
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-08-22','F226220242352','2026-08-22','14:42:36','TIN','2464000','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-260822-0046','D','2026-08-22','14:42:36','kasir','PENJUALAN','F226220242352','13980191000','2464000','13982655000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2464000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220242352' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220829201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220829201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220829201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220830371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220830371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220830371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220839411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220839411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220839411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220844421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220844422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844423' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844423' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220844423';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844424' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220844424' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220844424';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220845421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220845421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220845421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220859401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220859401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220859401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220916301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220916301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220916301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220918501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220918501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220918501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220923261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220923261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220923261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220926361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220926362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220926363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220944541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220944541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220944541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220944542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220944542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220944542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220958461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220958461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220958461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220958462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220958462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220958462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220958463' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220958463' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220958463';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220200011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220200011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220200011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220234311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220234311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220234311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220242351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220242352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221002351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221002351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221002351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221002352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221002352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221002352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221003261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221003261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221003261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221003571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221003571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221003571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221022001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221022001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221022001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221024281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221024281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221024281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221031091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221031091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221031091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221031092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221031092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221031092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221032261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221032261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221032261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221036401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221036401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221036401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221036402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221036402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221036402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221130141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221130142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221140101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221140101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221140101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221224491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221224491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221224491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221237281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221237281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221237281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221239241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221239241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221239241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221243592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221243592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221243592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221250161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221250161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221250161';
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 ('F226220311331','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZHXC-12-T','KL SIEM UB 42 8K ','','1.150','1','100.00','1230000','0','0','15000','1260000','0','0','0','1260000','LUS','T0081741','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXC-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='H1E-ZHXC-12-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 ('F226220311331','2026-08-22','1.150','2026-08-22','15:11:34','PLG0083892','1260000','1260000','0','1260000','1260000','kasir','2026-08-22 15:11:33','F22622031133');
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-08-22','F226220311331','2026-08-22','15:11:34','LUS','1260000','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-260822-0047','D','2026-08-22','15:11:34','kasir','PENJUALAN','F226220311331','13982655000','1260000','13983915000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220311331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220311331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220311331';
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-00005650','X-00005650','AT X MODEL ARESO SLEP HW 8K','GR','---','A1E','BELI','BELI001','614000','2026-08-22','0.630','1','admin','2026-08-22 15:20:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005650','X-00005650');
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-260822-0001','F226100923501','DIN','1','BELI','BELI001','A1E', 'X-00005650', 'AT X MODEL ARESO SLEP HW 8K','0.630','0.630','100.00','668000','614000','974603','1160000','1','614000','614000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260822-0001','2026-08-22','2026-08-22','15:20:12','DIN','---','0.630','614000','614000','614000','614000','614000','admin','2026-08-22 15:20:12','FB-260822-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260822-0001','BU ATIK','BAOSAN LOR. NGRAYUN','','','085800844915','admin','2026-08-22 15:20:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-22' 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-260822-0048','K','2026-08-22','15:20:12','admin','PEMBELIAN UMUM','FB-260822-0001','13983915000','614000','13983301000');
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-00005651','X-00005651','CC X MODEL MATA AY 20','GR','---','E2TE','BELI','BELI001','1466000','2026-08-22','0.900','1','admin','2026-08-22 15:21:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00005651','X-00005651');
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-260822-0002','F222021124401','NOV','1','BELI','BELI001','E2TE', 'X-00005651', 'CC X MODEL MATA AY 20','1.030','0.900','100.00','773000','1466000','1628889','1980000','1','1466000','1466000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260822-0002','2026-08-22','2026-08-22','15:21:56','NOV','---','0.900','1466000','1466000','1466000','1466000','1466000','admin','2026-08-22 15:21:57','FB-260822-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260822-0002','HANI','JL LET JEN SUPRAPTO GG 3','','','','admin','2026-08-22 15:21:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-22' 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-260822-0049','K','2026-08-22','15:21:56','admin','PEMBELIAN UMUM','FB-260822-0002','13983301000','1466000','13981835000');
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-00005652','X-00005652','CC RG MODEL SOLITAIRE MATA AY 18','GR','---','E2TG','BELI','BELI001','1304000','2026-08-22','0.800','1','admin','2026-08-22 15:21:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TG','X-00005652','X-00005652');
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-260822-0003','F222021124402','NOV','2','BELI','BELI001','E2TG', 'X-00005652', 'CC RG MODEL SOLITAIRE MATA AY 18','0.930','0.800','100.00','716000','1304000','1630000','2020000','1','1304000','1304000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.800',berat_beli_asli=berat_beli_asli+'0.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.800',berat_akhir_asli=berat_akhir_asli+'0.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TG' 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-260822-0003','2026-08-22','2026-08-22','15:21:56','NOV','---','0.800','1304000','1304000','1304000','1304000','1304000','admin','2026-08-22 15:21:57','FB-260822-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260822-0003','HANI','JL LET JEN SUPRAPTO GG 3','','','','admin','2026-08-22 15:21:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-22' 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-260822-0050','K','2026-08-22','15:21:56','admin','PEMBELIAN UMUM','FB-260822-0003','13981835000','1304000','13980531000');
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-00005653','X-00005653','CC MODEL MATA VAR CM 16 8K','GR','---','E2E','BELI','BELI001','700000','2026-08-22','0.710','1','admin','2026-08-22 15:22:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005653','X-00005653');
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-260822-0004','F226270144381','LUS','1','BELI','BELI001','E2E', 'X-00005653', 'CC MODEL MATA VAR CM 16 8K','0.710','0.710','100.00','788000','700000','985915','1160000','1','700000','700000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.710',berat_beli_asli=berat_beli_asli+'0.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.710',berat_akhir_asli=berat_akhir_asli+'0.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' 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-260822-0004','2026-08-22','2026-08-22','15:22:46','LUS','---','0.710','700000','700000','700000','700000','700000','admin','2026-08-22 15:22:46','FB-260822-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260822-0004','ERFANA NURCAHYANTO','KAB.PONOROGO','','','','admin','2026-08-22 15:22:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-22' 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-260822-0051','K','2026-08-22','15:22:46','admin','PEMBELIAN UMUM','FB-260822-0004','13980531000','700000','13979831000');
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-00005654','X-00005654','GL MODEL FANCY CLOVER SLEP 3C VAR HW 8K','GR','---','F3E','BELI','BELI001','1620000','2026-08-22','2.120','1','admin','2026-08-22 15:22:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005654','X-00005654');
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-260822-0005','F224120951311','LUS','2','BELI','BELI001','F3E', 'X-00005654', 'GL MODEL FANCY CLOVER SLEP 3C VAR HW 8K','2.180','2.120','100.00','1456000','1620000','764151','1160000','1','1620000','1620000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.120',berat_beli_asli=berat_beli_asli+'2.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.120',berat_akhir_asli=berat_akhir_asli+'2.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260822-0005','2026-08-22','2026-08-22','15:22:46','LUS','---','2.120','1620000','1620000','1620000','1620000','1620000','admin','2026-08-22 15:22:46','FB-260822-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260822-0005','SURYANI','','','','','admin','2026-08-22 15:22:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-22' 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-260822-0052','K','2026-08-22','15:22:46','admin','PEMBELIAN UMUM','FB-260822-0005','13979831000','1620000','13978211000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260822-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260822-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260822-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260822-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260822-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260822-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260822-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260822-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260822-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260822-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-22';
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-08-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-22' 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-260823-0001','D','2026-08-23','16:01:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','13978211000','13978211000');
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-260823-0001','D','2026-08-23','16:01:12','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
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-260823-0001','D','2026-08-23','16:01:12','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-260823-0001','D','2026-08-23','16:01:12','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-260823-0001','D','2026-08-23','16:01:12','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-260823-0001','D','2026-08-23','16:01:12','BCA','SALDO AWAL','SALDO AWAL','0','4752062888','4752062888');
UPDATE tp_system SET tgl_system='2026-08-23';
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-20260823-0001','1','E2TD-YIXE-13-T','1','1.250','1.250','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-YIXE-13-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-13-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TD-YIXE-13-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-YIXE-13-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TD','E2TD-YIXE-13-T','1','1.250','1.250','1','1.250','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-YIXE-13-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-13-T';
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-20260823-0001','1','E2TD-XJAB-152-T','1','1.880','1.880','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-XJAB-152-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-XJAB-152-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TD-XJAB-152-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-XJAB-152-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TD','E2TD-XJAB-152-T','1','1.880','1.880','1','1.880','1.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-XJAB-152-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-XJAB-152-T';
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-20260823-0001','1','E2TE-WEAC-52-T','1','3.650','3.650','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TE-WEAC-52-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TE-WEAC-52-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TE-WEAC-52-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TE-WEAC-52-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TE','E2TE-WEAC-52-T','1','3.650','3.650','1','3.650','3.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TE-WEAC-52-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TE-WEAC-52-T';
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-20260823-0001','1','E2TE-XBBF-28-T','1','1.510','1.510','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TE-XBBF-28-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TE-XBBF-28-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TE-XBBF-28-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TE-XBBF-28-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TE','E2TE-XBBF-28-T','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TE-XBBF-28-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TE-XBBF-28-T';
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-20260823-0001','1','E2TE-XGAI-127-T','1','1.850','1.850','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TE-XGAI-127-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TE-XGAI-127-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TE-XGAI-127-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TE-XGAI-127-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TE','E2TE-XGAI-127-T','1','1.850','1.850','1','1.850','1.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TE-XGAI-127-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TE-XGAI-127-T';
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-20260823-0001','1','E2TD-XJAB-139-T','1','1.160','1.160','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-XJAB-139-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-XJAB-139-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TD-XJAB-139-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-XJAB-139-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TD','E2TD-XJAB-139-T','1','1.160','1.160','1','1.160','1.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-XJAB-139-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-XJAB-139-T';
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-20260823-0001','1','E2TD-YFBF-138-T','1','0.960','0.960','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-YFBF-138-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-YFBF-138-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E2TD-YFBF-138-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-YFBF-138-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E2TD','E2TD-YFBF-138-T','1','0.960','0.960','1','0.960','0.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-YFBF-138-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YFBF-138-T';
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-20260823-0001','1','E1TD-YFBF-143-T','1','1.260','1.260','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-YFBF-143-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-YFBF-143-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E1TD-YFBF-143-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-YFBF-143-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E1TD','E1TD-YFBF-143-T','1','1.260','1.260','1','1.260','1.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-YFBF-143-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-YFBF-143-T';
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-20260823-0001','1','E1TE-ZDXF-33-T','1','0.650','0.650','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E1TE','E1TE-ZDXF-33-T','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-ZDXF-33-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZDXF-33-T';
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-20260823-0001','1','E1TE-ZGAG-54-T','1','0.730','0.730','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-ZGAG-54-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-ZGAG-54-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E1TE-ZGAG-54-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-ZGAG-54-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E1TE','E1TE-ZGAG-54-T','1','0.730','0.730','1','0.730','0.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-ZGAG-54-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZGAG-54-T';
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-20260823-0001','1','E1TE-ZGAG-56-T','1','0.610','0.610','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-ZGAG-56-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-ZGAG-56-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-08-23 16:47:14' WHERE kode_barang='E1TE-ZGAG-56-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-ZGAG-56-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-23 16:47:14','TOKO','TBK-E','E1TE','E1TE-ZGAG-56-T','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-ZGAG-56-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZGAG-56-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260823-0001','2026-08-23','16:46','15.510','input','2026-08-22 16:47:14');