INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260918-0001','1','E2TE-ZIAG-101-T','1','0.580','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TE-ZIAG-101-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TE-ZIAG-101-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E2TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E2TE-ZIAG-101-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.580',berat_out_asli='0.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.580',berat_akhir_asli =berat_akhir_asli-'0.580' WHERE kode_barang='E2TE-ZIAG-101-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260918-0001','2','E2TE-ZIAG-102-T','1','0.540','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TE-ZIAG-102-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TE-ZIAG-102-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E2TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E2TE-ZIAG-102-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.540',berat_out_asli='0.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.540',berat_akhir_asli =berat_akhir_asli-'0.540' WHERE kode_barang='E2TE-ZIAG-102-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260918-0001','3','E1TE-ZIAG-103-T','1','0.500','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZIAG-103-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1TE-ZIAG-103-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1TE-ZIAG-103-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='E1TE-ZIAG-103-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260918-0001','2026-09-18','2026-09-18','08:03','0.500','input','260918');
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 ('F226180817051','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZIAF-52-T','CC MODEL RING 3 SLEP LG 16 8K ','OL','0.510','1','100.00','534000','0','0','15000','540000','0','5000','0','545000','NS','T0083814','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAF-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E1E-ZIAF-52-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 ('F226180817051','2026-09-18','0.510','2026-09-18','08:17:05','PLG0085270','540000','540000','5000','545000','545000','kasir','2026-09-18 08:17:05','F22618081705');
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-09-18','F226180817051','2026-09-18','08:17:05','NS','545000','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-260918-0002','D','2026-09-18','08:17:05','kasir','PENJUALAN','F226180817051','15299672000','545000','15300217000');
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 ('F226180827521','kasir','1',' MED2 LG G ','TOKO','SMBK-D','D2E-WLBE-171-T','LT MODEL HURUF MATA LG G 8K ','OLS VSAU8','0.470','1','100.00','492000','0','0','15000','519000','0','92000','0','611000','DIN','T0052657','D2E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-WLBE-171-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-09-18' AND kode_barang='D2E-WLBE-171-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 ('F226180827521','2026-09-18','0.470','2026-09-18','08:27:53','PLG0085271','519000','519000','92000','611000','611000','kasir','2026-09-18 08:27:52','F22618082752');
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-09-18','F226180827521','2026-09-18','08:27:53','DIN','611000','92000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260918-0003','D','2026-09-18','08:27:53','kasir','PENJUALAN','F226180827521','15300217000','611000','15300828000');
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 ('F226180928501','kasir','1',' MFE2 KH 18','TOKO','SMBK-E','E2F-ZIAF-77-T','CC MODEL PAKU MATA VAR KH 18 8K ','OL','0.400','1','100.00','427000','0','0','15000','436000','0','5000','0','441000','LUS','T0083839','E2F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIAF-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2F-ZIAF-77-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 ('F226180928501','2026-09-18','0.400','2026-09-18','09:28:51','PLG0085272','436000','436000','5000','441000','441000','kasir','2026-09-18 09:28:50','F22618092850');
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-09-18','F226180928501','2026-09-18','09:28:51','LUS','441000','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-260918-0004','D','2026-09-18','09:28:51','kasir','PENJUALAN','F226180928501','15300828000','441000','15301269000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='441000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180928501' 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 ('F226180928502','kasir',' 1',' MDE1 LG 18','TOKO','SMBK-E','E1D-ZIXH-19-T','CC MODEL ISYANA LG 18 8K ','OL','1.120','1','100.00','1150000','0','0','15000','1170000','0','6000','0','1176000','LUS','T0083166','E1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIXH-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E1D-ZIXH-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180928502','2026-09-18','1.120','2026-09-18','09:28:51','PLG0085273','1170000','1170000','6000','1176000','1176000','kasir','2026-09-18 09:28:50','F22618092850');
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-09-18','F226180928502','2026-09-18','09:28:51','LUS','1176000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0005','D','2026-09-18','09:28:51','kasir','PENJUALAN','F226180928502','15301269000','1176000','15302445000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1176000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180928502' 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 ('F226180929301','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZIAF-42-T','GL FLIK BOLA ARESO VAR HW 8K ','OL','1.780','1','100.00','1864000','0','0','15000','1896000','0','9000','0','1905000','LUS','T0083804','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAF-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZIAF-42-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 ('F226180929301','2026-09-18','1.780','2026-09-18','09:29:30','PLG0085274','1896000','1896000','9000','1905000','1905000','kasir','2026-09-18 09:29:30','F22618092930');
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-09-18','F226180929301','2026-09-18','09:29:30','LUS','1905000','9000');
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-260918-0006','D','2026-09-18','09:29:30','kasir','PENJUALAN','F226180929301','15302445000','1905000','15304350000');
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 ('F226180931041','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZIAG-2-T','GL FLIK BUNGA ARESO VAR HW 8K ','OL','1.970','1','100.00','2063000','0','0','15000','2098000','0','10000','0','2108000','LUS','T0083905','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAG-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZIAG-2-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 ('F226180931041','2026-09-18','1.970','2026-09-18','09:31:04','PLG0085275','2098000','2098000','10000','2108000','2108000','kasir','2026-09-18 09:31:04','F22618093104');
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-09-18','F226180931041','2026-09-18','09:31:04','LUS','2108000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260918-0007','D','2026-09-18','09:31:04','kasir','PENJUALAN','F226180931041','15304350000','2108000','15306458000');
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 ('F226180932571','kasir','1',' TEF1 UB D6','TOKO','TBK-F','F1TE-ZIXC-112-T','GL OVAL MODEL C UB D65 17K ','OL','3.610','1','100.00','6967000','0','0','15000','7051000','0','25000','0','7076000','LUS','T0082959','F1TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZIXC-112-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.610',berat_jual_asli=berat_jual_asli+'3.610',stock_jual='1',berat_akhir=berat_akhir-'3.610',berat_akhir_asli=berat_akhir_asli-'3.610',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F1TE-ZIXC-112-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180932571','2026-09-18','3.610','2026-09-18','09:32:58','PLG0085276','7051000','7051000','25000','7076000','7076000','kasir','2026-09-18 09:32:57','F22618093257');
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-09-18','F226180932571','2026-09-18','09:32:58','LUS','7076000','25000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260918-0008','D','2026-09-18','09:32:58','kasir','PENJUALAN','F226180932571','15306458000','7076000','15313534000');
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 ('F226180934161','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZIAA-102-T','AT JERSY SLEP LG 8K ','OL','1.010','1','100.00','1037000','0','0','15000','1056000','0','5000','0','1061000','LUS','T0083400','A1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIAA-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='A1D-ZIAA-102-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 ('F226180934161','2026-09-18','1.010','2026-09-18','09:34:17','PLG0085277','1056000','1056000','5000','1061000','1061000','kasir','2026-09-18 09:34:16','F22618093416');
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-09-18','F226180934161','2026-09-18','09:34:17','LUS','1061000','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-260918-0009','D','2026-09-18','09:34:17','kasir','PENJUALAN','F226180934161','15313534000','1061000','15314595000');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1D-ZDBE-23-T','T0078992','T0078992','CC MODEL BANGKOK SLEP CM 18 8K ','CC MODEL BANGKOK SLEP CM 18 8K','','','1181500','1181500',' 0','0','input','2026-09-18 09:38:46');
UPDATE tm_barang SET nama_barang='CC MODEL BANGKOK SLEP CM 18 8K' ,nama_atribut='' ,kode_intern='MDE1 CM 18 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1D-ZDBE-23-T' 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 ('F226180940261','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZDBE-23-T','CC MODEL BANGKOK SLEP CM 18 8K','OL','1.150','1','100.00','1181000','0','0','15000','1202000','0','6000','0','1208000','LUS','T0078992','E1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBE-23-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-09-18' AND kode_barang='E1D-ZDBE-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 ('F226180940261','2026-09-18','1.150','2026-09-18','09:40:27','PLG0085278','1202000','1202000','6000','1208000','1208000','kasir','2026-09-18 09:40:26','F22618094026');
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-09-18','F226180940261','2026-09-18','09:40:27','LUS','1208000','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-260918-0010','D','2026-09-18','09:40:27','kasir','PENJUALAN','F226180940261','15314595000','1208000','15315803000');
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 ('F226180941281','kasir','1',' TEE1 KH 18','TOKO','TBK-E','E1TE-ZIAG-95-T','CC MODEL KUPU SLEP VAR KH 18 17K ','OL','0.500','1','100.00','965000','0','0','15000','980000','0','7000','0','987000','DIN','T0083998','E1TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZIAG-95-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-09-18' AND kode_barang='E1TE-ZIAG-95-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 ('F226180941281','2026-09-18','0.500','2026-09-18','09:41:28','PLG0085279','980000','980000','7000','987000','987000','kasir','2026-09-18 09:41:28','F22618094128');
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-09-18','F226180941281','2026-09-18','09:41:28','DIN','987000','7000');
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-260918-0011','D','2026-09-18','09:41:28','kasir','PENJUALAN','F226180941281','15315803000','987000','15316790000');
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 ('F226180941571','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZIAF-136-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.250','1','100.00','272000','0','0','15000','278000','0','5000','0','283000','DIN','T0083898','B1G','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZIAF-136-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='B1G-ZIAF-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 ('F226180941571','2026-09-18','0.250','2026-09-18','09:41:58','PLG0085280','278000','278000','5000','283000','283000','kasir','2026-09-18 09:41:57','F22618094157');
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-09-18','F226180941571','2026-09-18','09:41:58','DIN','283000','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-260918-0012','D','2026-09-18','09:41:58','kasir','PENJUALAN','F226180941571','15316790000','283000','15317073000');
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 ('F226181034381','kasir','1',' TGPE X MT ','TOKO','TBK-P','PETG-WFXA-12-T','CC X WG WEDDING MATA MT 16 ','','2.100','1','100.00','4137000','0','0','15000','4179000','0','10000','0','4189000','HAN','T0044770','PETG','0','0','-','0','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PETG-WFXA-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='PETG-WFXA-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-P' 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 ('F226181034381','2026-09-18','2.100','2026-09-18','10:34:39','PLG0085281','4179000','4179000','10000','4189000','4189000','kasir','2026-09-18 10:34:38','F22618103438');
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-09-18','F226181034381','2026-09-18','10:34:39','HAN','4189000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260918-0013','D','2026-09-18','10:34:39','kasir','PENJUALAN','F226181034381','15317073000','4189000','15321262000');
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 ('F226181039441','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZIAF-43-T','GL RANTAI HOLLOW P4 SLEP HW 8K ','OL','1.880','1','100.00','1968000','0','0','15000','2003000','0','9000','0','2012000','LUS','T0083805','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAF-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZIAF-43-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 ('F226181039441','2026-09-18','1.880','2026-09-18','10:39:44','PLG0085282','2003000','2003000','9000','2012000','2012000','kasir','2026-09-18 10:39:44','F22618103944');
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-09-18','F226181039441','2026-09-18','10:39:44','LUS','2012000','9000');
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-260918-0014','D','2026-09-18','10:39:44','kasir','PENJUALAN','F226181039441','15321262000','2012000','15323274000');
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 ('F226181046021','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZIAA-167-T','CC MODEL ISYANA LG 16 8K ','','0.520','1','100.00','544000','0','0','15000','551000','0','0','0','551000','RHM','T0083465','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAA-167-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-09-18' AND kode_barang='E1E-ZIAA-167-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 ('F226181046021','2026-09-18','0.520','2026-09-18','10:46:02','PLG0085283','551000','551000','0','551000','551000','kasir','2026-09-18 10:46:02','F22618104602');
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-09-18','F226181046021','2026-09-18','10:46:02','RHM','551000','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-260918-0015','D','2026-09-18','10:46:02','kasir','PENJUALAN','F226181046021','15323274000','551000','15323825000');
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 ('F226181051171','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-ZHCA-111-0','AT X GYPSY SLEP ANAK LG 8K ','OL ','0.470','1','100.00','492000','0','0','15000','505000','0','5000','0','510000','RHM','00421399','A1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHCA-111-0' 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-09-18' AND kode_barang='A1E-ZHCA-111-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226181051171','2026-09-18','0.470','2026-09-18','10:51:18','PLG0085284','505000','505000','5000','510000','510000','kasir','2026-09-18 10:51:17','F22618105117');
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-09-18','F226181051171','2026-09-18','10:51:18','RHM','510000','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-260918-0016','D','2026-09-18','10:51:18','kasir','PENJUALAN','F226181051171','15323825000','510000','15324335000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='510000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181051171' 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 ('F226181051172','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZIAE-83-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL ','0.480','1','100.00','503000','0','0','15000','516000','0','5000','0','521000','RHM','T0083682','B1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIAE-83-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-09-18' AND kode_barang='B1E-ZIAE-83-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 ('F226181051172','2026-09-18','0.480','2026-09-18','10:51:18','PLG0085285','516000','516000','5000','521000','521000','kasir','2026-09-18 10:51:17','F22618105117');
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-09-18','F226181051172','2026-09-18','10:51:18','RHM','521000','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-260918-0017','D','2026-09-18','10:51:18','kasir','PENJUALAN','F226181051172','15324335000','521000','15324856000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='521000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181051172' 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 ('F226181051173','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZIAE-86-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL ','0.500','1','100.00','523000','0','0','15000','538000','0','5000','0','543000','RHM','T0083685','B1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIAE-86-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-09-18' AND kode_barang='B1E-ZIAE-86-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 ('F226181051173','2026-09-18','0.500','2026-09-18','10:51:18','PLG0085286','538000','538000','5000','543000','543000','kasir','2026-09-18 10:51:17','F22618105117');
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-09-18','F226181051173','2026-09-18','10:51:18','RHM','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-260918-0018','D','2026-09-18','10:51:18','kasir','PENJUALAN','F226181051173','15324856000','543000','15325399000','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='F226181051173' 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 ('F226181051174','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZIAD-60-T','LT MODEL LUCKY CAT VAR LG 8K ','OL ','0.530','1','100.00','555000','0','0','15000','570000','0','5000','0','575000','RHM','T0083554','D1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIAD-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1E-ZIAD-60-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 ('F226181051174','2026-09-18','0.530','2026-09-18','10:51:18','PLG0085287','570000','570000','5000','575000','575000','kasir','2026-09-18 10:51:17','F22618105117');
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-09-18','F226181051174','2026-09-18','10:51:18','RHM','575000','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-260918-0019','D','2026-09-18','10:51:18','kasir','PENJUALAN','F226181051174','15325399000','575000','15325974000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181051174' 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 ('F226181056141','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZIAD-97-T','CC MODEL PITA PASIR VAR CM 16 8K ','OL ','0.850','1','100.00','890000','0','0','15000','910000','0','5000','0','915000','RHM','T0083591','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAD-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E1E-ZIAD-97-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 ('F226181056141','2026-09-18','0.850','2026-09-18','10:56:14','PLG0085288','910000','910000','5000','915000','915000','kasir','2026-09-18 10:56:14','F22618105614');
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-09-18','F226181056141','2026-09-18','10:56:14','RHM','915000','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-260918-0020','D','2026-09-18','10:56:14','kasir','PENJUALAN','F226181056141','15325974000','915000','15326889000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='915000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181056141' 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 ('F226181056142','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZHXG-176-0','GL X HARLEY DOBEL SLEP HW 8K ','OL ','3.100','1','100.00','3246000','0','0','15000','3301000','0','16000','0','3317000','RHM','00417595','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXG-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZHXG-176-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 ('F226181056142','2026-09-18','3.100','2026-09-18','10:56:14','PLG0085289','3301000','3301000','16000','3317000','3317000','kasir','2026-09-18 10:56:14','F22618105614');
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-09-18','F226181056142','2026-09-18','10:56:14','RHM','3317000','16000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0021','D','2026-09-18','10:56:14','kasir','PENJUALAN','F226181056142','15326889000','3317000','15330206000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3317000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181056142' 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 ('F226181109491','kasir','1',' MFE1 KH 16','TOKO','SMBK-E','E1F-ZIAF-70-T','CC MODEL TINJU TETES VAR KH 16 8K ','OL ','0.360','1','100.00','384000','0','0','15000','392000','0','5000','0','397000','RHM','T0083832','E1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAF-70-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-09-18' AND kode_barang='E1F-ZIAF-70-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 ('F226181109491','2026-09-18','0.360','2026-09-18','11:09:50','PLG0085290','392000','392000','5000','397000','397000','kasir','2026-09-18 11:09:49','F22618110949');
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-09-18','F226181109491','2026-09-18','11:09:50','RHM','397000','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-260918-0022','D','2026-09-18','11:09:50','kasir','PENJUALAN','F226181109491','15330206000','397000','15330603000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='397000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181109491' 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 ('F226181109492','kasir',' 1',' MEE2 X HW ','TOKO','SMBK-E','E2E-ZGCX-175-0','CC X MODEL MATA HW 17 8K ','OL ','0.520','1','100.00','544000','0','0','15000','556000','0','5000','0','561000','RHM','00416074','E2E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGCX-175-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-09-18' AND kode_barang='E2E-ZGCX-175-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 ('F226181109492','2026-09-18','0.520','2026-09-18','11:09:50','PLG0085291','556000','556000','5000','561000','561000','kasir','2026-09-18 11:09:49','F22618110949');
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-09-18','F226181109492','2026-09-18','11:09:50','RHM','561000','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-260918-0023','D','2026-09-18','11:09:50','kasir','PENJUALAN','F226181109492','15330603000','561000','15331164000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='561000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181109492' 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 ('F226181109493','kasir',' 1',' MEH1 UB ','TOKO','SMBK-H','H1E-ZIXH-85-T','KL TRIXIE BUNGA CLOVER SLEP VAR UB 8K','OL ','3.490','1','100.00','3654000','0','0','15000','3717000','0','17000','0','3734000','RHM','T0083232','H1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXH-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.490',berat_jual_asli=berat_jual_asli+'3.490',stock_jual='1',berat_akhir=berat_akhir-'3.490',berat_akhir_asli=berat_akhir_asli-'3.490',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='H1E-ZIXH-85-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 ('F226181109493','2026-09-18','3.490','2026-09-18','11:09:50','PLG0085292','3717000','3717000','17000','3734000','3734000','kasir','2026-09-18 11:09:49','F22618110949');
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-09-18','F226181109493','2026-09-18','11:09:50','RHM','3734000','17000');
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-260918-0024','D','2026-09-18','11:09:50','kasir','PENJUALAN','F226181109493','15331164000','3734000','15334898000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3734000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181109493' 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 ('F226181110351','kasir','1',' MEE1 HTM 1','TOKO','SMBK-E','E1E-ZIXI-66-T','CC PIPA MODEL DAUN VAR HTM 17 8K ','OL ','0.480','1','100.00','503000','0','0','15000','515000','0','5000','0','520000','RHM','T0083321','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXI-66-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-09-18' AND kode_barang='E1E-ZIXI-66-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 ('F226181110351','2026-09-18','0.480','2026-09-18','11:10:36','PLG0085293','515000','515000','5000','520000','520000','kasir','2026-09-18 11:10:35','F22618111035');
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-09-18','F226181110351','2026-09-18','11:10:36','RHM','520000','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-260918-0025','D','2026-09-18','11:10:36','kasir','PENJUALAN','F226181110351','15334898000','520000','15335418000');
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 ('F226181111101','kasir','1',' MEF3 LT ','TOKO','SMBK-F','F3E-ZIAF-115-T','GL MODEL VERONA VAR LT 8K ','OL ','1.500','1','100.00','1570000','0','0','15000','1597000','0','8000','0','1605000','RHM','T0083877','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAF-115-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZIAF-115-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 ('F226181111101','2026-09-18','1.500','2026-09-18','11:11:10','PLG0085294','1597000','1597000','8000','1605000','1605000','kasir','2026-09-18 11:11:10','F22618111110');
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-09-18','F226181111101','2026-09-18','11:11:10','RHM','1605000','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-260918-0026','D','2026-09-18','11:11:10','kasir','PENJUALAN','F226181111101','15335418000','1605000','15337023000');
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 ('F226181121401','kasir','1',' MFE2 KH 14','TOKO','SMBK-E','E2F-ZIAE-127-T','CC MODEL PAKU MATA VAR KH 14 8K ','','0.400','1','100.00','427000','0','0','15000','432000','0','0','0','432000','HAN','T0083726','E2F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIAE-127-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2F-ZIAE-127-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 ('F226181121401','2026-09-18','0.400','2026-09-18','11:21:40','PLG0085295','432000','432000','0','432000','432000','kasir','2026-09-18 11:21:40','F22618112140');
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-09-18','F226181121401','2026-09-18','11:21:40','HAN','432000','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-260918-0027','D','2026-09-18','11:21:40','kasir','PENJUALAN','F226181121401','15337023000','432000','15337455000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260918-0001','1','F1E-ZIAD-10-T','1','0.780','0.780','TOKO','SMBK-F','TOKO','PMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PMBK-F' WHERE kode_barang='F1E-ZIAD-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-18','TOKO','PMBK-F','F1E','F1E-ZIAD-10-T','100.00','1','0.780','0.780','1','0.780','0.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.780',berat_out_asli=berat_out_asli+'0.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-18' AND kode_barang='F1E-ZIAD-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260918-0001','2026-09-18','2026-09-18','11:40','0.78','admin','2026-09-18 11:41:11');
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 ('F226181148551','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIAE-6-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.340','1','100.00','363000','0','0','15000','371000','0','5000','0','376000','LUS','T0083605','D1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIAE-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1F-ZIAE-6-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 ('F226181148551','2026-09-18','0.340','2026-09-18','11:48:55','PLG0085296','371000','371000','5000','376000','376000','kasir','2026-09-18 11:48:55','F22618114855');
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-09-18','F226181148551','2026-09-18','11:48:55','LUS','376000','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-260918-0028','D','2026-09-18','11:48:55','kasir','PENJUALAN','F226181148551','15337455000','376000','15337831000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='376000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181148551' 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 ('F226181148552','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIAE-11-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.350','1','100.00','373000','0','0','15000','382000','0','5000','0','387000','LUS','T0083610','D1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIAE-11-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-09-18' AND kode_barang='D1F-ZIAE-11-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 ('F226181148552','2026-09-18','0.350','2026-09-18','11:48:55','PLG0085297','382000','382000','5000','387000','387000','kasir','2026-09-18 11:48:55','F22618114855');
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-09-18','F226181148552','2026-09-18','11:48:55','LUS','387000','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-260918-0029','D','2026-09-18','11:48:55','kasir','PENJUALAN','F226181148552','15337831000','387000','15338218000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181148552' 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 ('F226181149511','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZIXC-103-T','LT PLAT FINE GOLD LG 8K ','OL','0.530','1','100.00','555000','0','0','15000','567000','0','5000','0','572000','LUS','T0082950','D1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIXC-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1E-ZIXC-103-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 ('F226181149511','2026-09-18','0.530','2026-09-18','11:49:52','PLG0085298','567000','567000','5000','572000','572000','kasir','2026-09-18 11:49:51','F22618114951');
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-09-18','F226181149511','2026-09-18','11:49:52','LUS','572000','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-260918-0030','D','2026-09-18','11:49:52','kasir','PENJUALAN','F226181149511','15338218000','572000','15338790000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='572000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181149511' 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 ('F226181149512','kasir',' 1',' MEH1E KH 3','TOKO','SMBK-H','H1E-ZHXH-21-T','KL ITALY ANAK KH 36 8K ','OL','1.650','1','100.00','1728000','0','0','15000','1758000','0','8000','0','1766000','LUS','T0082140','H1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXH-21-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-09-18' AND kode_barang='H1E-ZHXH-21-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 ('F226181149512','2026-09-18','1.650','2026-09-18','11:49:52','PLG0085299','1758000','1758000','8000','1766000','1766000','kasir','2026-09-18 11:49:51','F22618114951');
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-09-18','F226181149512','2026-09-18','11:49:52','LUS','1766000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0031','D','2026-09-18','11:49:52','kasir','PENJUALAN','F226181149512','15338790000','1766000','15340556000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1766000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181149512' 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 ('F226181222561','kasir','1',' MFE1 KH 14','TOKO','SMBK-E','E1F-ZIAF-64-T','CC MODEL TINJU TETES VAR KH 14 8K ','OL','0.380','1','100.00','405000','0','0','15000','415000','0','5000','0','420000','NS','T0083826','E1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAF-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E1F-ZIAF-64-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 ('F226181222561','2026-09-18','0.380','2026-09-18','12:22:57','PLG0085300','415000','415000','5000','420000','420000','kasir','2026-09-18 12:22:56','F22618122256');
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-09-18','F226181222561','2026-09-18','12:22:57','NS','420000','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-260918-0032','D','2026-09-18','12:22:57','kasir','PENJUALAN','F226181222561','15340556000','420000','15340976000');
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 ('F226181223141','kasir','1',' MED1 HW ','TOKO','SMBK-D','D1E-ZIAG-16-T','LT MODEL BUNGA CLOVER SLEP HW 8K ','OL','0.540','1','100.00','565000','0','0','15000','578000','0','5000','0','583000','NS','T0083919','D1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIAG-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1E-ZIAG-16-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 ('F226181223141','2026-09-18','0.540','2026-09-18','12:23:14','PLG0085301','578000','578000','5000','583000','583000','kasir','2026-09-18 12:23:14','F22618122314');
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-09-18','F226181223141','2026-09-18','12:23:14','NS','583000','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-260918-0033','D','2026-09-18','12:23:14','kasir','PENJUALAN','F226181223141','15340976000','583000','15341559000');
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 ('F226181223341','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAE-80-T','LT CHARM MODEL DAUN LG 8K ','OL','0.220','1','100.00','239000','0','0','15000','245000','0','5000','0','250000','NS','T0083679','D1G','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAE-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1G-ZIAE-80-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 ('F226181223341','2026-09-18','0.220','2026-09-18','12:23:34','PLG0085302','245000','245000','5000','250000','250000','kasir','2026-09-18 12:23:34','F22618122334');
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-09-18','F226181223341','2026-09-18','12:23:34','NS','250000','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-260918-0034','D','2026-09-18','12:23:34','kasir','PENJUALAN','F226181223341','15341559000','250000','15341809000');
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 ('F226181223571','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAE-77-T','LT CHARM MODEL DAUN LG 8K ','OL','0.220','1','100.00','239000','0','0','15000','245000','0','5000','0','250000','NS','T0083676','D1G','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAE-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1G-ZIAE-77-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 ('F226181223571','2026-09-18','0.220','2026-09-18','12:23:57','PLG0085303','245000','245000','5000','250000','250000','kasir','2026-09-18 12:23:57','F22618122357');
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-09-18','F226181223571','2026-09-18','12:23:57','NS','250000','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-260918-0035','D','2026-09-18','12:23:57','kasir','PENJUALAN','F226181223571','15341809000','250000','15342059000');
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 ('F226181224141','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAE-75-T','LT CHARM MODEL DAUN LG 8K ','OL','0.220','1','100.00','239000','0','0','15000','245000','0','5000','0','250000','NS','T0083674','D1G','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAE-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1G-ZIAE-75-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 ('F226181224141','2026-09-18','0.220','2026-09-18','12:24:14','PLG0085304','245000','245000','5000','250000','250000','kasir','2026-09-18 12:24:14','F22618122414');
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-09-18','F226181224141','2026-09-18','12:24:14','NS','250000','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-260918-0036','D','2026-09-18','12:24:14','kasir','PENJUALAN','F226181224141','15342059000','250000','15342309000');
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 ('F226181224291','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAE-76-T','LT CHARM MODEL DAUN LG 8K ','OL','0.220','1','100.00','239000','0','0','15000','245000','0','5000','0','250000','NS','T0083675','D1G','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAE-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1G-ZIAE-76-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 ('F226181224291','2026-09-18','0.220','2026-09-18','12:24:30','PLG0085305','245000','245000','5000','250000','250000','kasir','2026-09-18 12:24:29','F22618122429');
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-09-18','F226181224291','2026-09-18','12:24:30','NS','250000','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-260918-0037','D','2026-09-18','12:24:30','kasir','PENJUALAN','F226181224291','15342309000','250000','15342559000');
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 ('F226181245401','kasir','1',' MFE2 KH 16','TOKO','SMBK-E','E2F-ZIAE-131-T','CC MODEL PAKU MATA VAR KH 16 8K ','','0.400','1','100.00','427000','0','0','15000','432000','0','0','0','432000','HAN','T0083730','E2F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIAE-131-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2F-ZIAE-131-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 ('F226181245401','2026-09-18','0.400','2026-09-18','12:45:41','PLG0085306','432000','432000','0','432000','432000','kasir','2026-09-18 12:45:40','F22618124540');
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-09-18','F226181245401','2026-09-18','12:45:41','HAN','432000','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-260918-0038','D','2026-09-18','12:45:41','kasir','PENJUALAN','F226181245401','15342559000','432000','15342991000');
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 ('F226180101041','kasir','1',' MEE2 KH 14','TOKO','SMBK-E','E2E-ZIAE-143-T','CC MODEL SNAKE MATA VAR KH 14 8K ','OL','0.500','1','100.00','523000','0','0','15000','535000','0','5000','0','540000','NS','T0083742','E2E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIAE-143-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-09-18' AND kode_barang='E2E-ZIAE-143-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 ('F226180101041','2026-09-18','0.500','2026-09-18','13:01:05','PLG0085307','535000','535000','5000','540000','540000','kasir','2026-09-18 13:01:04','F22618010104');
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-09-18','F226180101041','2026-09-18','13:01:05','NS','540000','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-260918-0039','D','2026-09-18','13:01:05','kasir','PENJUALAN','F226180101041','15342991000','540000','15343531000');
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 ('F226180104431','kasir','1',' TEE2 KH 12','TOKO','TBK-E','E2TE-ZIAG-96-T','CC MODEL PAKU MATA VAR KH 12 17K ','OL','0.570','1','100.00','1100000','0','0','15000','1218000','0','7000','0','1225000','DIN','T0083999','E2TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-ZIAG-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2TE-ZIAG-96-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 ('F226180104431','2026-09-18','0.570','2026-09-18','13:04:44','PLG0085308','1218000','1218000','7000','1225000','1225000','kasir','2026-09-18 13:04:43','F22618010443');
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-09-18','F226180104431','2026-09-18','13:04:44','DIN','1225000','7000');
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-260918-0040','D','2026-09-18','13:04:44','kasir','PENJUALAN','F226180104431','15343531000','1225000','15344756000');
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 ('F226180115091','kasir','1',' MFB1 Y LG ','TOKO','SMBK-B','B1F-XLAI-81-T','GW TUSUK MODEL HURUF MATA Y LG PE 8K ','OL','0.560','1','100.00','598000','0','0','15000','610000','0','5000','0','615000','LUS','T0065117','B1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-XLAI-81-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-09-18' AND kode_barang='B1F-XLAI-81-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 ('F226180115091','2026-09-18','0.560','2026-09-18','13:15:09','PLG0085309','610000','610000','5000','615000','615000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115091','2026-09-18','13:15:09','LUS','615000','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-260918-0041','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115091','15344756000','615000','15345371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115091' 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 ('F226180115092','kasir',' 1',' MDB1 X HW ','TOKO','SMBK-B','B1D-ZIXI-146-0','GW X MODEL MATA HW PE 8K ','OL','0.860','1','100.00','883000','0','0','15000','903000','0','5000','0','908000','LUS','00422684','B1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZIXI-146-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='B1D-ZIXI-146-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 ('F226180115092','2026-09-18','0.860','2026-09-18','13:15:09','PLG0085310','903000','903000','5000','908000','908000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115092','2026-09-18','13:15:09','LUS','908000','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-260918-0042','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115092','15345371000','908000','15346279000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='908000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115092' 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 ('F226180115093','kasir',' 1',' MFE1 KH 10','TOKO','SMBK-E','E1F-ZIXG-73-T','CC MODEL BUNGA CLOVER SLEP KH 10 8K ','OL','0.350','1','100.00','373000','0','0','15000','382000','0','5000','0','387000','LUS','T0083132','E1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXG-73-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-09-18' AND kode_barang='E1F-ZIXG-73-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 ('F226180115093','2026-09-18','0.350','2026-09-18','13:15:09','PLG0085311','382000','382000','5000','387000','387000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115093','2026-09-18','13:15:09','LUS','387000','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-260918-0043','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115093','15346279000','387000','15346666000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115093' 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 ('F226180115094','kasir',' 1',' MFE1 KH 12','TOKO','SMBK-E','E1F-ZIXH-25-T','CC MODEL BUNGA CLOVER SLEP KH 12 8K ','OL','0.350','1','100.00','373000','0','0','15000','382000','0','5000','0','387000','LUS','T0083172','E1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXH-25-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-09-18' AND kode_barang='E1F-ZIXH-25-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 ('F226180115094','2026-09-18','0.350','2026-09-18','13:15:09','PLG0085312','382000','382000','5000','387000','387000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115094','2026-09-18','13:15:09','LUS','387000','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-260918-0044','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115094','15346666000','387000','15347053000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115094' 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 ('F226180115095','kasir',' 1',' MDE2D CM 1','TOKO','SMBK-E','E2D-ZHCA-26-T','CC SOLITAIRE MATA SLEP CM 14 8K ','OL','0.830','1','100.00','852000','0','0','15000','872000','0','5000','0','877000','LUS','T0082815','E2D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHCA-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2D-ZHCA-26-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 ('F226180115095','2026-09-18','0.830','2026-09-18','13:15:09','PLG0085313','872000','872000','5000','877000','877000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115095','2026-09-18','13:15:09','LUS','877000','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-260918-0045','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115095','15347053000','877000','15347930000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='877000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115095' 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 ('F226180115096','kasir',' 1',' MDE1 LG 21','TOKO','SMBK-E','E1D-ZHAA-116-T','CC COR MODEL ISYANA 21 LG 8K','OL','1.470','1','100.00','1510000','0','0','15000','1537000','0','7000','0','1544000','LUS','T0082256','E1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHAA-116-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E1D-ZHAA-116-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 ('F226180115096','2026-09-18','1.470','2026-09-18','13:15:09','PLG0085314','1537000','1537000','7000','1544000','1544000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115096','2026-09-18','13:15:09','LUS','1544000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0046','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115096','15347930000','1544000','15349474000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1544000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115096' 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 ('F226180115097','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZIAD-101-T','GL MODEL FLIK CLOVER ARESO VAR HW 8K ','OL','1.940','1','100.00','2031000','0','0','15000','2066000','0','10000','0','2076000','LUS','T0083595','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIAD-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZIAD-101-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 ('F226180115097','2026-09-18','1.940','2026-09-18','13:15:09','PLG0085315','2066000','2066000','10000','2076000','2076000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115097','2026-09-18','13:15:09','LUS','2076000','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-260918-0047','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115097','15349474000','2076000','15351550000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2076000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115097' 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 ('F226180115098','kasir',' 1',' MDD2D X CM','TOKO','SMBK-D','D2D-ZIXI-160-0','LT X MODEL MATA CM 8K ','OL','1.060','1','100.00','1089000','0','0','15000','1103000','0','10000','0','1113000','LUS','00422698','D2D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZIXI-160-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-09-18' AND kode_barang='D2D-ZIXI-160-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180115098','2026-09-18','1.060','2026-09-18','13:15:09','PLG0085316','1103000','1103000','10000','1113000','1113000','kasir','2026-09-18 13:15:09','F22618011509');
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-09-18','F226180115098','2026-09-18','13:15:09','LUS','1113000','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-260918-0048','D','2026-09-18','13:15:09','kasir','PENJUALAN','F226180115098','15351550000','1113000','15352663000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1113000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180115098' 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 ('F226180117121','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZIAA-101-T','AT JERSY SLEP LG 8K ','OL','1.030','1','100.00','1058000','0','0','15000','1077000','0','5000','0','1082000','LUS','T0083399','A1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIAA-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='A1D-ZIAA-101-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 ('F226180117121','2026-09-18','1.030','2026-09-18','13:17:12','PLG0085317','1077000','1077000','5000','1082000','1082000','kasir','2026-09-18 13:17:12','F22618011712');
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-09-18','F226180117121','2026-09-18','13:17:12','LUS','1082000','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-260918-0049','D','2026-09-18','13:17:12','kasir','PENJUALAN','F226180117121','15352663000','1082000','15353745000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1082000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180117121' 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 ('F226180117122','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAE-73-T','LT CHARM MODEL DAUN LG 8K ','OL','0.220','1','100.00','239000','0','0','15000','245000','0','5000','0','250000','LUS','T0083672','D1G','0','0','-','1','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAE-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1G-ZIAE-73-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 ('F226180117122','2026-09-18','0.220','2026-09-18','13:17:12','PLG0085318','245000','245000','5000','250000','250000','kasir','2026-09-18 13:17:12','F22618011712');
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-09-18','F226180117122','2026-09-18','13:17:12','LUS','250000','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-260918-0050','D','2026-09-18','13:17:12','kasir','PENJUALAN','F226180117122','15353745000','250000','15353995000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='250000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180117122' 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 ('F226180117123','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIAE-78-T','LT CHARM MODEL DAUN LG 8K ','OL','0.210','1','100.00','228000','0','0','15000','233000','0','5000','0','238000','LUS','T0083677','D1G','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIAE-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.210',berat_jual_asli=berat_jual_asli+'0.210',stock_jual='1',berat_akhir=berat_akhir-'0.210',berat_akhir_asli=berat_akhir_asli-'0.210',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1G-ZIAE-78-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 ('F226180117123','2026-09-18','0.210','2026-09-18','13:17:12','PLG0085319','233000','233000','5000','238000','238000','kasir','2026-09-18 13:17:12','F22618011712');
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-09-18','F226180117123','2026-09-18','13:17:12','LUS','238000','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-260918-0051','D','2026-09-18','13:17:12','kasir','PENJUALAN','F226180117123','15353995000','238000','15354233000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='238000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180117123' 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 ('F226180120471','kasir','1',' TDE2 10K C','TOKO','TBK-E','E2TD-ZIXC-124-T','CC WEDDING MATA CM 20 17K ','OL','1.020','1','100.00','1948000','0','0','15000','1973000','0','7000','0','1980000','LUS','T0082971','E2TD','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZIXC-124-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-09-18' AND kode_barang='E2TD-ZIXC-124-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 ('F226180120471','2026-09-18','1.020','2026-09-18','13:20:47','PLG0085320','1973000','1973000','7000','1980000','1980000','kasir','2026-09-18 13:20:47','F22618012047');
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-09-18','F226180120471','2026-09-18','13:20:47','LUS','1980000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0052','D','2026-09-18','13:20:47','kasir','PENJUALAN','F226180120471','15354233000','1980000','15356213000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180120471' 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 ('F226180120472','kasir',' 1',' TEE2 KH 16','TOKO','TBK-E','E2TE-ZIAG-99-T','CC MODEL PAKU MATA VAR KH 16 17K ','OL','0.550','1','100.00','1061000','0','0','15000','1078000','0','7000','0','1085000','LUS','T0084002','E2TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-ZIAG-99-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-09-18' AND kode_barang='E2TE-ZIAG-99-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 ('F226180120472','2026-09-18','0.550','2026-09-18','13:20:47','PLG0085321','1078000','1078000','7000','1085000','1085000','kasir','2026-09-18 13:20:47','F22618012047');
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-09-18','F226180120472','2026-09-18','13:20:47','LUS','1085000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0053','D','2026-09-18','13:20:47','kasir','PENJUALAN','F226180120472','15356213000','1085000','15357298000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1085000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180120472' 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 ('F226180120473','kasir',' 1',' TDE2 10K C','TOKO','TBK-E','E2TD-ZIXC-126-T','CC WEDDING MATA CM 24 17K ','OL','1.010','1','100.00','1929000','0','0','15000','1953000','0','7000','0','1960000','LUS','T0082973','E2TD','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZIXC-126-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2TD-ZIXC-126-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 ('F226180120473','2026-09-18','1.010','2026-09-18','13:20:47','PLG0085322','1953000','1953000','7000','1960000','1960000','kasir','2026-09-18 13:20:47','F22618012047');
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-09-18','F226180120473','2026-09-18','13:20:47','LUS','1960000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260918-0054','D','2026-09-18','13:20:47','kasir','PENJUALAN','F226180120473','15357298000','1960000','15359258000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180120473' 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 ('F226180121261','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZHBF-103-0','GL X CASTELI CAPELLA VAR HW 8K ','','1.700','1','100.00','1780000','0','0','15000','1802000','0','0','0','1802000','TJ','00420475','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBF-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZHBF-103-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 ('F226180121261','2026-09-18','1.700','2026-09-18','13:21:27','PLG0085323','1802000','1802000','0','1802000','1802000','kasir','2026-09-18 13:21:26','F22618012126');
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-09-18','F226180121261','2026-09-18','13:21:27','TJ','1802000','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-260918-0055','D','2026-09-18','13:21:27','kasir','PENJUALAN','F226180121261','15359258000','1802000','15361060000');
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 ('F226180123541','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZIAA-111-T','LT MODEL PITA VAR LG 8K ','OL','0.500','1','100.00','523000','0','0','15000','535000','0','5000','0','540000','NS','T0083409','D1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIAA-111-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-09-18' AND kode_barang='D1E-ZIAA-111-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 ('F226180123541','2026-09-18','0.500','2026-09-18','13:23:55','PLG0085324','535000','535000','5000','540000','540000','kasir','2026-09-18 13:23:54','F22618012354');
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-09-18','F226180123541','2026-09-18','13:23:55','NS','540000','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-260918-0056','D','2026-09-18','13:23:55','kasir','PENJUALAN','F226180123541','15361060000','540000','15361600000');
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 ('F226180206511','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZHAA-76-T','LT MODEL PITA SLEP LG 8K ','','0.400','1','100.00','419000','0','0','15000','425000','0','0','0','425000','NOV','T0082216','D1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHAA-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1E-ZHAA-76-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 ('F226180206511','2026-09-18','0.400','2026-09-18','14:06:52','PLG0085325','425000','425000','0','425000','425000','kasir','2026-09-18 14:06:51','F22618020651');
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-09-18','F226180206511','2026-09-18','14:06:52','NOV','425000','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-260918-0057','D','2026-09-18','14:06:52','kasir','PENJUALAN','F226180206511','15361600000','425000','15362025000');
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 ('F226180207561','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZHAA-77-T','LT MODEL PITA SLEP LG 8K ','','0.400','1','100.00','419000','0','0','15000','425000','0','0','0','425000','NOV','T0082217','D1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHAA-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1E-ZHAA-77-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 ('F226180207561','2026-09-18','0.400','2026-09-18','14:07:56','PLG0085326','425000','425000','0','425000','425000','kasir','2026-09-18 14:07:56','F22618020756');
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-09-18','F226180207561','2026-09-18','14:07:56','NOV','425000','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-260918-0058','D','2026-09-18','14:07:56','kasir','PENJUALAN','F226180207561','15362025000','425000','15362450000');
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 ('F226180214401','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZIXI-259-0','GL X CAPELLA SLEP HW 8K ','','3.610','1','100.00','3780000','0','0','15000','3827000','0','0','0','3827000','LUS','00422797','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXI-259-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.610',berat_jual_asli=berat_jual_asli+'3.610',stock_jual='1',berat_akhir=berat_akhir-'3.610',berat_akhir_asli=berat_akhir_asli-'3.610',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZIXI-259-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 ('F226180214401','2026-09-18','3.610','2026-09-18','14:14:41','PLG0085327','3827000','3827000','0','3827000','3827000','kasir','2026-09-18 14:14:40','F22618021440');
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-09-18','F226180214401','2026-09-18','14:14:41','LUS','3827000','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-260918-0059','D','2026-09-18','14:14:41','kasir','PENJUALAN','F226180214401','15362450000','3827000','15366277000');
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 ('F226180246161','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZIAF-126-T','KL RANTAI HOLLOW UB 44CM 8K ','OL','1.010','1','100.00','1057000','0','0','15000','1081000','0','5000','0','1086000','TJ','T0083888','H1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAF-126-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='H1E-ZIAF-126-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 ('F226180246161','2026-09-18','1.010','2026-09-18','14:46:17','PLG0085328','1081000','1081000','5000','1086000','1086000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246161','2026-09-18','14:46:17','TJ','1086000','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-260918-0060','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246161','15366277000','1086000','15367363000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1086000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180246161' 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 ('F226180246162','kasir',' 1',' MDA1D X CM','TOKO','SMBK-A','A1D-ZGAG-4-0','AT X HUGGIES KLIP DAUN SLEP CM 8K ','OL','1.070','1','100.00','1099000','0','0','15000','1124000','0','5000','0','1129000','TJ','00413840','A1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGAG-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='A1D-ZGAG-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180246162','2026-09-18','1.070','2026-09-18','14:46:17','PLG0085329','1124000','1124000','5000','1129000','1129000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246162','2026-09-18','14:46:17','TJ','1129000','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-260918-0061','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246162','15367363000','1129000','15368492000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1129000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180246162' 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 ('F226180246163','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZIAF-49-T','CC MODEL RING 3 SLEP LG 14 8K ','OL','0.500','1','100.00','523000','0','0','15000','538000','0','5000','0','543000','TJ','T0083811','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAF-49-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-09-18' AND kode_barang='E1E-ZIAF-49-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 ('F226180246163','2026-09-18','0.500','2026-09-18','14:46:17','PLG0085330','538000','538000','5000','543000','543000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246163','2026-09-18','14:46:17','TJ','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-260918-0062','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246163','15368492000','543000','15369035000','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='F226180246163' 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 ('F226180246164','kasir',' 1',' MEE1 LG 18','TOKO','SMBK-E','E1E-ZIAF-56-T','CC MODEL RING 3 SLEP LG 18 8K ','OL','0.550','1','100.00','576000','0','0','15000','591000','0','5000','0','596000','TJ','T0083818','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIAF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E1E-ZIAF-56-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 ('F226180246164','2026-09-18','0.550','2026-09-18','14:46:17','PLG0085331','591000','591000','5000','596000','596000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246164','2026-09-18','14:46:17','TJ','596000','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-260918-0063','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246164','15369035000','596000','15369631000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='596000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180246164' 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 ('F226180246165','kasir',' 1',' MED2 LG S ','TOKO','SMBK-D','D2E-ZIAA-106-T','LT MODEL HURUF LG S 8K ','OL','0.550','1','100.00','576000','0','0','15000','591000','0','5000','0','596000','TJ','T0083404','D2E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZIAA-106-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-09-18' AND kode_barang='D2E-ZIAA-106-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 ('F226180246165','2026-09-18','0.550','2026-09-18','14:46:17','PLG0085332','591000','591000','5000','596000','596000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246165','2026-09-18','14:46:17','TJ','596000','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-260918-0064','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246165','15369631000','596000','15370227000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='596000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180246165' 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 ('F226180246166','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIAF-85-T','LT SLOBOK BAMBU BUNGA PASIR VAR BG 8K ','OL','0.620','1','100.00','662000','0','0','15000','679000','0','5000','0','684000','TJ','T0083847','D1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIAF-85-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-09-18' AND kode_barang='D1F-ZIAF-85-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 ('F226180246166','2026-09-18','0.620','2026-09-18','14:46:17','PLG0085333','679000','679000','5000','684000','684000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246166','2026-09-18','14:46:17','TJ','684000','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-260918-0065','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246166','15370227000','684000','15370911000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='684000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180246166' 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 ('F226180246167','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZIAF-87-T','LT SLOBOK BAMBU BUNGA PASIR VAR BG 8K ','OL','0.850','1','100.00','907000','0','0','15000','931000','0','5000','0','936000','TJ','T0083849','D1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIAF-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1F-ZIAF-87-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 ('F226180246167','2026-09-18','0.850','2026-09-18','14:46:17','PLG0085334','931000','931000','5000','936000','936000','kasir','2026-09-18 14:46:16','F22618024616');
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-09-18','F226180246167','2026-09-18','14:46:17','TJ','936000','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-260918-0066','D','2026-09-18','14:46:17','kasir','PENJUALAN','F226180246167','15370911000','936000','15371847000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='936000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180246167' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZHAA-59-T','T0082199','T0082199','LT CHARM BULAT HURUF E BG 8K ','LT CHARM BULAT HURUF E BG 8K','','','747000','747000',' 0','0','input','2026-09-18 15:10:52');
UPDATE tm_barang SET nama_barang='LT CHARM BULAT HURUF E BG 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG E ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZHAA-59-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZGBD-106-T','T0081533','T0081533','LT SLOBOK NULAT HURUF BG D 8K ','LT SLOBOK NULAT HURUF BG D 8K','','','747000','747000',' 0','0','input','2026-09-18 15:11:08');
UPDATE tm_barang SET nama_barang='LT SLOBOK NULAT HURUF BG D 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG D ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZGBD-106-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZGBD-106-T','T0081533','T0081533','LT SLOBOK NULAT HURUF BG D 8K','LT SLOBOK BULAT HURUF BG D 8K','','','747000','747000',' 0','0','input','2026-09-18 15:11:17');
UPDATE tm_barang SET nama_barang='LT SLOBOK BULAT HURUF BG D 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG D ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZGBD-106-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZGBD-106-T','T0081533','T0081533','LT SLOBOK NULAT HURUF BG D 8K','LT SLOBOK BULAT HURUF BG D 8K','','','747000','747000',' 0','0','input','2026-09-18 15:11:17');
UPDATE tm_barang SET nama_barang='LT SLOBOK BULAT HURUF BG D 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG D ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZGBD-106-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZHAA-59-T','T0082199','T0082199','LT CHARM BULAT HURUF E BG 8K','LT SLOBOK BULAT HURUF BG E 8K','','','747000','747000',' 0','0','input','2026-09-18 15:11:43');
UPDATE tm_barang SET nama_barang='LT SLOBOK BULAT HURUF BG E 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG E ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZHAA-59-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZHAA-59-T','T0082199','T0082199','LT SLOBOK BULAT HURUF BG E 8K','LT SLOBOK BULAT HURUF BG E 8K','','','747000','747000',' 0','0','input','2026-09-18 15:12:38');
UPDATE tm_barang SET nama_barang='LT SLOBOK BULAT HURUF BG E 8K' ,nama_atribut='' ,kode_intern='MFD1 5K BG E ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZHAA-59-T' 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 ('F226180313351','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZGBD-106-T','LT SLOBOK BULAT HURUF BG D 8K','OL','0.700','1','100.00','747000','0','0','15000','763000','0','5000','0','768000','NS','T0081533','D1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGBD-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1F-ZGBD-106-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 ('F226180313351','2026-09-18','0.700','2026-09-18','15:13:35','PLG0085335','763000','763000','5000','768000','768000','kasir','2026-09-18 15:13:35','F22618031335');
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-09-18','F226180313351','2026-09-18','15:13:35','NS','768000','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-260918-0067','D','2026-09-18','15:13:35','kasir','PENJUALAN','F226180313351','15371847000','768000','15372615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='768000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180313351' 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 ('F226180313352','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZHAA-59-T','LT SLOBOK BULAT HURUF BG E 8K','OL','0.700','1','100.00','747000','0','0','15000','763000','0','5000','0','768000','NS','T0082199','D1F','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHAA-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='D1F-ZHAA-59-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 ('F226180313352','2026-09-18','0.700','2026-09-18','15:13:35','PLG0085336','763000','763000','5000','768000','768000','kasir','2026-09-18 15:13:35','F22618031335');
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-09-18','F226180313352','2026-09-18','15:13:35','NS','768000','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-260918-0068','D','2026-09-18','15:13:35','kasir','PENJUALAN','F226180313352','15372615000','768000','15373383000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='768000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180313352' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005729','X-00005729','CC MODEL DAUN SLEP VAR HW 15 8K','GR','---','E1D','BELI','BELI001','992000','2026-09-18','1.060','1','kasir','2026-09-18 15:24:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005729','X-00005729');
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-260918-0001','F226141213341','TJ','1','BELI','BELI001','E1D', 'X-00005729', 'CC MODEL DAUN SLEP VAR HW 15 8K','1.060','1.060','100.00','1235000','992000','935849','1027000','1','992000','992000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260918-0001','2026-09-18','2026-09-18','15:24:37','TJ','---','1.060','992000','992000','992000','992000','992000','kasir','2026-09-18 15:24:37','FB-260918-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260918-0001','MIA DEWI','TRANJANG. SIMAN','','','082231777377','kasir','2026-09-18 15:24:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-18' 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-260918-0069','K','2026-09-18','15:24:37','kasir','PEMBELIAN UMUM','FB-260918-0001','15373383000','992000','15372391000');
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-00005730','X-00005730','CC X MODEL MATA CM 18 8K','GR','---','E1D','BELI','BELI001','908000','2026-09-18','0.950','1','kasir','2026-09-18 15:24:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005730','X-00005730');
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-260918-0002','F226041125481','TJ','2','BELI','BELI001','E1D', 'X-00005730', 'CC X MODEL MATA CM 18 8K','0.950','0.950','100.00','1040000','908000','955789','1027000','1','908000','908000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260918-0002','2026-09-18','2026-09-18','15:24:37','TJ','---','0.950','908000','908000','908000','908000','908000','kasir','2026-09-18 15:24:37','FB-260918-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260918-0002','MIADEWI','TRANJANG SIMAN','','','082231777377','kasir','2026-09-18 15:24:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-18' 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-260918-0070','K','2026-09-18','15:24:37','kasir','PEMBELIAN UMUM','FB-260918-0002','15372391000','908000','15371483000');
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-00005731','X-00005731','CC MODEL SNACK SLEP KH 20 8K','GR','---','E1E','BELI','BELI001','477000','2026-09-18','0.500','1','kasir','2026-09-18 15:26:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005731','X-00005731');
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-260918-0003','F226251005391','RHM','1','BELI','BELI001','E1E', 'X-00005731', 'CC MODEL SNACK SLEP KH 20 8K','0.500','0.500','100.00','540000','477000','954000','1047000','1','477000','477000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260918-0003','2026-09-18','2026-09-18','15:26:33','RHM','---','0.500','477000','477000','477000','477000','477000','kasir','2026-09-18 15:26:34','FB-260918-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260918-0003','RENCY','PERUM GRISIMEY JL BUDI U','','','083834384900','kasir','2026-09-18 15:26:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-18' 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-260918-0071','K','2026-09-18','15:26:33','kasir','PEMBELIAN UMUM','FB-260918-0003','15371483000','477000','15371006000');
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-00005732','X-00005732','LT MODEL SLEP VAR HTM 8K','GR','---','D1E','BELI','BELI001','665000','2026-09-18','0.700','1','kasir','2026-09-18 15:39:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00005732','X-00005732');
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-260918-0004','F226101109381','DIN','1','BELI','BELI001','D1E', 'X-00005732', 'LT MODEL SLEP VAR HTM 8K','0.700','0.700','100.00','739000','665000','950000','1047000','1','665000','665000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-260918-0004','2026-09-18','2026-09-18','15:39:07','DIN','---','0.700','665000','665000','665000','665000','665000','kasir','2026-09-18 15:39:08','FB-260918-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260918-0004','LEONA','BARENG BABADAN','','','082232346540','kasir','2026-09-18 15:39:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-18' 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-260918-0072','K','2026-09-18','15:39:07','kasir','PEMBELIAN UMUM','FB-260918-0004','15371006000','665000','15370341000');
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-00005733','X-00005733','GW TUSUK VAR SLEP CM 8K','GR','---','B1E','BELI','BELI001','503000','2026-09-18','0.530','1','kasir','2026-09-18 15:39:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00005733','X-00005733');
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-260918-0005','F226101111191','DIN','2','BELI','BELI001','B1E', 'X-00005733', 'GW TUSUK VAR SLEP CM 8K','0.530','0.530','100.00','559000','503000','949057','1047000','1','503000','503000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260918-0005','2026-09-18','2026-09-18','15:39:07','DIN','---','0.530','503000','503000','503000','503000','503000','kasir','2026-09-18 15:39:08','FB-260918-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260918-0005','LEONA','MBARENG BABADAN','','','082232346540','kasir','2026-09-18 15:39:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-18' 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-260918-0073','K','2026-09-18','15:39:07','kasir','PEMBELIAN UMUM','FB-260918-0005','15370341000','503000','15369838000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180101041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180101041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180101041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180104431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180104431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180104431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115093' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115093' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115093';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115094' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115094' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115094';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115095' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115095' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115095';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115096' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115096' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115096';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115097' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115097' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115097';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115098' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180115098' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180115098';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180117121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180117121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180117121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180117122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180117122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180117122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180117123' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180117123' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180117123';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180120471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180120471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180120471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180120472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180120472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180120472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180120473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180120473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180120473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180121261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180121261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180121261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180123541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180123541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180123541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180206511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180206511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180206511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180207561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180207561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180207561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180214401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180214401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180214401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246163' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246163' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246163';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246164' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246164' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246164';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246165' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246165' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246165';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246166' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246166' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246166';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246167' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180246167' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180246167';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180313351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180313351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180313351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180313352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180313352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180313352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180817051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180817051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180817051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180827521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180827521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180827521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180928501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180928501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180928501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180928502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180928502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180928502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180929301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180929301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180929301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180931041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180931041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180931041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180932571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180932571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180932571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180934161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180934161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180934161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180940261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180940261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180940261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180941281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180941281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180941281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180941571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180941571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180941571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181034381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181034381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181034381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181039441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181039441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181039441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181046021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181046021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181046021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181051171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181051172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051173' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051173' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181051173';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051174' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181051174' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181051174';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181056141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181056141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181056141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181056142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181056142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181056142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181109491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181109491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181109491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181109492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181109492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181109492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181109493' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181109493' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181109493';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181110351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181110351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181110351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181111101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181111101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181111101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181121401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181121401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181121401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181148551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181148551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181148551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181148552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181148552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181148552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181149511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181149511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181149511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181149512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181149512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181149512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181222561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181222561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181222561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181223141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181223141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181223141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181223341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181223341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181223341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181223571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181223571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181223571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181224141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181224141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181224141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181224291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181224291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181224291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181245401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181245401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181245401';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260918-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260918-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260918-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260918-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260918-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260918-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260918-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260918-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260918-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260918-0005';
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 ('F226180351581','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZHCA-37-T','GL KAKI CASTELI VAR SLEP UB 8K ','OL','1.900','1','100.00','1989000','0','0','15000','2023000','0','10000','0','2033000','TJ','T0082826','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHCA-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='F3E-ZHCA-37-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 ('F226180351581','2026-09-18','1.900','2026-09-18','15:51:58','PLG0085337','2023000','2023000','10000','2033000','2033000','kasir','2026-09-18 15:51:58','F22618035158');
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-09-18','F226180351581','2026-09-18','15:51:58','TJ','2033000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260918-0074','D','2026-09-18','15:51:58','kasir','PENJUALAN','F226180351581','15369838000','2033000','15371871000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180351581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180351581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180351581';
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 ('F226180417041','kasir','1',' TEE2 KH 12','TOKO','TBK-E','E2TE-ZIAG-96-T','CC MODEL PAKU MATA VAR KH 12 17K ','OL','0.570','1','100.00','1100000','0','0','15000','1118000','0','7000','0','1125000','DIN','T0083999','E2TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-ZIAG-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-09-18' AND kode_barang='E2TE-ZIAG-96-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 ('F226180417041','2026-09-18','0.570','2026-09-18','16:17:04','PLG0085338','1118000','1118000','7000','1125000','1125000','kasir','2026-09-18 16:17:04','F22618041704');
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-09-18','F226180417041','2026-09-18','16:17:04','DIN','1125000','7000');
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-260918-0076','D','2026-09-18','16:17:04','kasir','PENJUALAN','F226180417041','15370646000','1125000','15371771000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180417041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180417041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180417041';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-18';
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-09-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-18' 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-260919-0001','D','2026-09-19','16:44:47','SYSTEM','SALDO AWAL','SALDO AWAL','0','15371771000','15371771000');
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-260919-0001','D','2026-09-19','16:44:47','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-260919-0001','D','2026-09-19','16:44:47','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-260919-0001','D','2026-09-19','16:44:47','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-260919-0001','D','2026-09-19','16:44:47','','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-260919-0001','D','2026-09-19','16:44:47','BCA','SALDO AWAL','SALDO AWAL','0','4829093888','4829093888');
UPDATE tp_system SET tgl_system='2026-09-19';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260919-0001','1','F1E-ZIAD-10-T','1','0.780','TOKO','PMBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIAD-10-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F1E-ZIAD-10-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PMBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PMBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F1E-ZIAD-10-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.780',berat_out_asli='0.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.780',berat_akhir_asli =berat_akhir_asli-'0.780' WHERE kode_barang='F1E-ZIAD-10-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260919-0001','2026-09-19','2026-09-19','17:20','0.780','input','260919');