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 ('F226280824161','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YLAE-152-0','CC X MODEL MATA CM 14 8K ','','1.050','1','100.00','1176000','0','0','15000','1166000','0','0','0','1166000','RTA','00381130','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLAE-152-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E2D-YLAE-152-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 ('F226280824161','2026-03-28','1.050','2026-03-28','08:24:16','PLG0078521','1166000','1166000','0','1166000','1166000','kasir','2026-03-28 08:24:16','F22628082416');
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-03-28','F226280824161','2026-03-28','08:24:16','RTA','1166000','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-260328-0002','D','2026-03-28','08:24:16','kasir','PENJUALAN','F226280824161','7652550000','1166000','7653716000');
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 ('F226280834301','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZCBG-4-T','GL MODEL GENIA UB 8K ','OL','0.480','1','100.00','547000','0','0','15000','547000','0','5000','0','552000','TIN','T0078320','F3E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBG-4-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-03-28' AND kode_barang='F3E-ZCBG-4-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 ('F226280834301','2026-03-28','0.480','2026-03-28','08:34:30','PLG0078522','547000','547000','5000','552000','552000','kasir','2026-03-28 08:34:30','F22628083430');
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-03-28','F226280834301','2026-03-28','08:34:30','TIN','552000','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-260328-0003','D','2026-03-28','08:34:30','kasir','PENJUALAN','F226280834301','7653716000','552000','7654268000');
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 ('F226280843161','kasir','1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZCXG-46-T','CC MODEL DAUN SLEP VAR LG 12 8K ','','0.430','1','100.00','490000','0','0','15000','486000','0','0','0','486000','RTA','T0077917','E1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E1E-ZCXG-46-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 ('F226280843161','2026-03-28','0.430','2026-03-28','08:43:16','PLG0078523','486000','486000','0','486000','486000','kasir','2026-03-28 08:43:16','F22628084316');
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-03-28','F226280843161','2026-03-28','08:43:16','RTA','486000','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-260328-0004','D','2026-03-28','08:43:16','kasir','PENJUALAN','F226280843161','7654268000','486000','7654754000');
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 ('F226280919251','kasir','1',' TAB0 X DW ','TOKO','TBK-B','B0TA-YLBF-20-T','GW X MRICAN SLEP DW 17K ','','1.000','1','100.00','2000000','0','0','15000','1950000','0','0','0','1950000','NS','T0076190','B0TA','0','0','-','1','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0TA-YLBF-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='B0TA-YLBF-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226280919251','2026-03-28','1.000','2026-03-28','09:19:25','PLG0078524','1950000','1950000','0','1950000','1950000','kasir','2026-03-28 09:19:25','F22628091925');
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-03-28','F226280919251','2026-03-28','09:19:25','NS','1950000','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-260328-0005','D','2026-03-28','09:19:25','kasir','PENJUALAN','F226280919251','7654754000','1950000','7656704000');
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 ('F226280926401','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZCXE-125-T','CC MODEL BUNGA SLEP VAR CM 16 8K ','','1.100','1','100.00','1232000','0','0','15000','1200000','0','0','0','1200000','NS','T0077801','E1D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXE-125-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E1D-ZCXE-125-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 ('F226280926401','2026-03-28','1.100','2026-03-28','09:26:41','PLG0078525','1200000','1200000','0','1200000','1200000','kasir','2026-03-28 09:26:40','F22628092640');
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-03-28','F226280926401','2026-03-28','09:26:41','NS','1200000','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-260328-0006','D','2026-03-28','09:26:41','kasir','PENJUALAN','F226280926401','7656704000','1200000','7657904000');
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 ('F226280959451','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YHXI-225-0','CC X MODEL MATA CM 14 8K ','','1.430','1','100.00','1602000','0','0','15000','1587000','0','7000','0','1594000','TIN','00365089','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHXI-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E2D-YHXI-225-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 ('F226280959451','2026-03-28','1.430','2026-03-28','09:59:45','PLG0078526','1587000','1587000','7000','1594000','1594000','kasir','2026-03-28 09:59:45','F22628095945');
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-03-28','F226280959451','2026-03-28','09:59:45','TIN','1594000','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-260328-0007','D','2026-03-28','09:59:45','kasir','PENJUALAN','F226280959451','7657904000','1594000','7659498000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1594000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280959451' 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 ('F226280959452','kasir',' 1',' MDE2 X BM ','TOKO','SMBK-E','E2D-ZCXB-49-0','CC X MODEL MATA BM 18 8K ','','0.860','1','100.00','963000','0','0','15000','955000','0','0','0','955000','TIN','00391472','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-49-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-03-28' AND kode_barang='E2D-ZCXB-49-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 ('F226280959452','2026-03-28','0.860','2026-03-28','09:59:45','PLG0078527','955000','955000','0','955000','955000','kasir','2026-03-28 09:59:45','F22628095945');
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-03-28','F226280959452','2026-03-28','09:59:45','TIN','955000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260328-0008','D','2026-03-28','09:59:45','kasir','PENJUALAN','F226280959452','7659498000','955000','7660453000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='955000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280959452' 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 ('F226281006371','kasir','1',' MDA1 UB ','TOKO','SMBK-A','A1D-ZCBX-16-T','AT KLIP MODEL C UB 8K ','','1.120','1','100.00','1254000','0','0','15000','1243000','0','0','0','1243000','TJ','T0078226','A1D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCBX-16-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-03-28' AND kode_barang='A1D-ZCBX-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226281006371','2026-03-28','1.120','2026-03-28','10:06:38','PLG0078528','1243000','1243000','0','1243000','1243000','kasir','2026-03-28 10:06:37','F22628100637');
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-03-28','F226281006371','2026-03-28','10:06:38','TJ','1243000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260328-0009','D','2026-03-28','10:06:38','kasir','PENJUALAN','F226281006371','7660453000','1243000','7661696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1243000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281006371' 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 ('F226281006372','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCXE-50-T','CC WEDDING MATA CM 18 8K ','','1.530','1','100.00','1714000','0','0','15000','1698000','0','10000','0','1708000','TJ','T0077726','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E2D-ZCXE-50-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 ('F226281006372','2026-03-28','1.530','2026-03-28','10:06:38','PLG0078529','1698000','1698000','10000','1708000','1708000','kasir','2026-03-28 10:06:37','F22628100637');
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-03-28','F226281006372','2026-03-28','10:06:38','TJ','1708000','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-260328-0010','D','2026-03-28','10:06:38','kasir','PENJUALAN','F226281006372','7661696000','1708000','7663404000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1708000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281006372' 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 ('F226281040141','kasir','1',' MEH1 KH 32','TOKO','SMBK-H','H1E-ZCXE-139-T','KL ANAK SIEM COBRA KH 32CM 8K ','','1.030','1','100.00','1174000','0','0','15000','1164000','0','0','0','1164000','TJ','T0077815','H1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXE-139-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-03-28' AND kode_barang='H1E-ZCXE-139-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 ('F226281040141','2026-03-28','1.030','2026-03-28','10:40:14','PLG0078530','1164000','1164000','0','1164000','1164000','kasir','2026-03-28 10:40:14','F22628104014');
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-03-28','F226281040141','2026-03-28','10:40:14','TJ','1164000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260328-0011','D','2026-03-28','10:40:14','kasir','PENJUALAN','F226281040141','7663404000','1164000','7664568000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1164000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281040141' 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 ('F226281040142','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZCXE-132-T','LT MODEL PITA VAR LG 8K ','','0.510','1','100.00','581000','0','0','15000','576000','0','0','0','576000','TJ','T0077808','D1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXE-132-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-03-28' AND kode_barang='D1E-ZCXE-132-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 ('F226281040142','2026-03-28','0.510','2026-03-28','10:40:14','PLG0078531','576000','576000','0','576000','576000','kasir','2026-03-28 10:40:14','F22628104014');
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-03-28','F226281040142','2026-03-28','10:40:14','TJ','576000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260328-0012','D','2026-03-28','10:40:14','kasir','PENJUALAN','F226281040142','7664568000','576000','7665144000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='576000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281040142' 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 ('F226281046411','kasir','1',' MEE1 X UB ','TOKO','SMBK-E','E1E-ZCXB-186-0','CC X BABY PLAT UB 8K ','','0.700','1','100.00','798000','0','0','15000','791000','0','0','0','791000','RTA','00391609','E1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXB-186-0' 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-03-28' AND kode_barang='E1E-ZCXB-186-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 ('F226281046411','2026-03-28','0.700','2026-03-28','10:46:41','PLG0078532','791000','791000','0','791000','791000','kasir','2026-03-28 10:46:41','F22628104641');
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-03-28','F226281046411','2026-03-28','10:46:41','RTA','791000','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-260328-0013','D','2026-03-28','10:46:41','kasir','PENJUALAN','F226281046411','7665144000','791000','7665935000');
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 ('F226281059331','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZCXB-26-T','LT SLOBOK BULAT HURUF BG I 8K ','OL','0.390','1','100.00','460000','0','0','15000','462000','0','5000','0','467000','RTA','T0077660','D1G','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCXB-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='D1G-ZCXB-26-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 ('F226281059331','2026-03-28','0.390','2026-03-28','10:59:33','PLG0078533','462000','462000','5000','467000','467000','kasir','2026-03-28 10:59:33','F22628105933');
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-03-28','F226281059331','2026-03-28','10:59:33','RTA','467000','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-260328-0014','D','2026-03-28','10:59:33','kasir','PENJUALAN','F226281059331','7665935000','467000','7666402000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='467000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281059331' 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 ('F226281059332','kasir',' 1',' MDE1 CM 12','TOKO','SMBK-E','E1D-ZCXE-123-T','CC MODEL HATI SLEP VAR CM 12 8K ','OL','1.200','1','100.00','1344000','0','0','15000','1344000','0','6000','0','1350000','RTA','T0077799','E1D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXE-123-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E1D-ZCXE-123-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 ('F226281059332','2026-03-28','1.200','2026-03-28','10:59:33','PLG0078534','1344000','1344000','6000','1350000','1350000','kasir','2026-03-28 10:59:33','F22628105933');
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-03-28','F226281059332','2026-03-28','10:59:33','RTA','1350000','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-260328-0015','D','2026-03-28','10:59:33','kasir','PENJUALAN','F226281059332','7666402000','1350000','7667752000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281059332' 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 ('F226281101451','kasir','1',' TFE1 LG ','TOKO','TBK-E','E1TF-VIAI-42-T','CC BONEKA ANAK CAT LG ','OL','0.510','1','100.00','1081000','0','0','15000','1063000','0','7000','0','1070000','RTA','T0038044','E1TF','0','0','-','1','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TF-VIAI-42-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-03-28' AND kode_barang='E1TF-VIAI-42-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 ('F226281101451','2026-03-28','0.510','2026-03-28','11:01:46','PLG0078535','1063000','1063000','7000','1070000','1070000','kasir','2026-03-28 11:01:45','F22628110145');
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-03-28','F226281101451','2026-03-28','11:01:46','RTA','1070000','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-260328-0016','D','2026-03-28','11:01:46','kasir','PENJUALAN','F226281101451','7667752000','1070000','7668822000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1070000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281101451' 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 ('F226281101452','kasir',' 1',' TEF1 10K L','TOKO','TBK-F','F1TE-XHXH-1-T','GL OSROT ANAK BONEKA CAT VAR LG 17K ','OL','2.060','1','100.00','4326000','0','0','15000','4240000','0','14000','0','4254000','RTA','T0060238','F1TE','0','0','-','1','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-XHXH-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='F1TE-XHXH-1-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 ('F226281101452','2026-03-28','2.060','2026-03-28','11:01:46','PLG0078536','4240000','4240000','14000','4254000','4254000','kasir','2026-03-28 11:01:45','F22628110145');
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-03-28','F226281101452','2026-03-28','11:01:46','RTA','4254000','14000');
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-260328-0017','D','2026-03-28','11:01:46','kasir','PENJUALAN','F226281101452','7668822000','4254000','7673076000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4254000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281101452' 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 ('F226281120351','kasir','1',' MEH1 KH ','TOKO','SMBK-H','H1E-ZCAB-3-T','KL SIEM COBRA MODEL MATA VAR KH 8K ','','1.980','1','100.00','2257000','0','0','15000','2219000','0','0','0','2219000','TJ','T0078074','H1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAB-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='H1E-ZCAB-3-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 ('F226281120351','2026-03-28','1.980','2026-03-28','11:20:36','PLG0078537','2219000','2219000','0','2219000','2219000','kasir','2026-03-28 11:20:35','F22628112035');
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-03-28','F226281120351','2026-03-28','11:20:36','TJ','2219000','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-260328-0018','D','2026-03-28','11:20:36','kasir','PENJUALAN','F226281120351','7673076000','2219000','7675295000');
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 ('F226281128401','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZCAB-7-T','GL OVAL MODEL C TD D52 8K ','','4.800','1','100.00','5472000','0','0','15000','5424000','0','0','0','5424000','RTA','T0078078','F1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAB-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.800',berat_jual_asli=berat_jual_asli+'4.800',stock_jual='1',berat_akhir=berat_akhir-'4.800',berat_akhir_asli=berat_akhir_asli-'4.800',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='F1E-ZCAB-7-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 ('F226281128401','2026-03-28','4.800','2026-03-28','11:28:40','PLG0078538','5424000','5424000','0','5424000','5424000','kasir','2026-03-28 11:28:40','F22628112840');
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-03-28','F226281128401','2026-03-28','11:28:40','RTA','5424000','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-260328-0019','D','2026-03-28','11:28:40','kasir','PENJUALAN','F226281128401','7675295000','5424000','7680719000');
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 ('F226281135261','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZCBD-100-0','LT X SLOBOK HURUF BG N 8K ','OL','0.450','1','100.00','522000','0','0','15000','525000','0','5000','0','530000','TIN','00396580','D1F','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZCBD-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='D1F-ZCBD-100-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 ('F226281135261','2026-03-28','0.450','2026-03-28','11:35:27','PLG0078539','525000','525000','5000','530000','530000','kasir','2026-03-28 11:35:26','F22628113526');
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-03-28','F226281135261','2026-03-28','11:35:27','TIN','530000','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-260328-0020','D','2026-03-28','11:35:27','kasir','PENJUALAN','F226281135261','7680719000','530000','7681249000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281135261' 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 ('F226281135262','kasir',' 1',' MDD2 HW N ','TOKO','SMBK-D','D2D-ZAAG-11-T','LT MODEL HURUF MATA HW N 8K ','OL','0.840','1','100.00','941000','0','0','15000','945000','0','5000','0','950000','TIN','T0076605','D2D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZAAG-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='D2D-ZAAG-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 ('F226281135262','2026-03-28','0.840','2026-03-28','11:35:27','PLG0078540','945000','945000','5000','950000','950000','kasir','2026-03-28 11:35:26','F22628113526');
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-03-28','F226281135262','2026-03-28','11:35:27','TIN','950000','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-260328-0021','D','2026-03-28','11:35:27','kasir','PENJUALAN','F226281135262','7681249000','950000','7682199000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='950000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281135262' 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 ('F226281135263','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAX-17-T','GL MODEL SIEM SLEP UB 8K ','OL','0.790','1','100.00','901000','0','0','15000','905000','0','5000','0','910000','TIN','T0077132','F3E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.790',berat_jual_asli=berat_jual_asli+'0.790',stock_jual='1',berat_akhir=berat_akhir-'0.790',berat_akhir_asli=berat_akhir_asli-'0.790',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='F3E-ZBAX-17-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 ('F226281135263','2026-03-28','0.790','2026-03-28','11:35:27','PLG0078541','905000','905000','5000','910000','910000','kasir','2026-03-28 11:35:26','F22628113526');
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-03-28','F226281135263','2026-03-28','11:35:27','TIN','910000','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-260328-0022','D','2026-03-28','11:35:27','kasir','PENJUALAN','F226281135263','7682199000','910000','7683109000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='910000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281135263' 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 ('F226281135561','kasir','1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZCBG-17-T','KL NORY UB 45CM 8K ','OL','1.010','1','100.00','1151000','0','0','15000','1146000','0','5000','0','1151000','TIN','T0078333','H1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCBG-17-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-03-28' AND kode_barang='H1E-ZCBG-17-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 ('F226281135561','2026-03-28','1.010','2026-03-28','11:35:56','PLG0078542','1146000','1146000','5000','1151000','1151000','kasir','2026-03-28 11:35:56','F22628113556');
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-03-28','F226281135561','2026-03-28','11:35:56','TIN','1151000','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-260328-0023','D','2026-03-28','11:35:56','kasir','PENJUALAN','F226281135561','7683109000','1151000','7684260000');
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 ('F226281137161','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-YIBC-253-0','LT X MODEL HURUF MATA LG B 8K ','OL','0.580','1','100.00','661000','0','0','15000','661000','0','5000','0','666000','TIN','00370224','D2E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIBC-253-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='D2E-YIBC-253-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 ('F226281137161','2026-03-28','0.580','2026-03-28','11:37:16','PLG0078543','661000','661000','5000','666000','666000','kasir','2026-03-28 11:37:16','F22628113716');
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-03-28','F226281137161','2026-03-28','11:37:16','TIN','666000','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-260328-0024','D','2026-03-28','11:37:16','kasir','PENJUALAN','F226281137161','7684260000','666000','7684926000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='666000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281137161' 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 ('F226281137162','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZBXF-205-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.250','1','100.00','1400000','0','0','15000','1390000','0','10000','0','1400000','TIN','00388787','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBXF-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E2D-ZBXF-205-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 ('F226281137162','2026-03-28','1.250','2026-03-28','11:37:16','PLG0078544','1390000','1390000','10000','1400000','1400000','kasir','2026-03-28 11:37:16','F22628113716');
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-03-28','F226281137162','2026-03-28','11:37:16','TIN','1400000','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-260328-0025','D','2026-03-28','11:37:16','kasir','PENJUALAN','F226281137162','7684926000','1400000','7686326000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226281137162' 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 ('F226281150181','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZCBX-2-T','GL OVAL MODEL C UB D52 8K ','','2.210','1','100.00','2519000','0','0','15000','2497000','0','0','0','2497000','NS','T0078212','F1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='F1E-ZCBX-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 ('F226281150181','2026-03-28','2.210','2026-03-28','11:50:18','PLG0078545','2497000','2497000','0','2497000','2497000','kasir','2026-03-28 11:50:18','F22628115018');
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-03-28','F226281150181','2026-03-28','11:50:18','NS','2497000','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-260328-0026','D','2026-03-28','11:50:18','kasir','PENJUALAN','F226281150181','7686326000','2497000','7688823000');
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 ('F226281151061','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZCAX-27-T','GW TUSUK DEASY MATA LG 8K ','OL','0.310','1','100.00','366000','0','0','15000','367000','0','5000','0','372000','TIN','T0077968','B1G','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZCAX-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='B1G-ZCAX-27-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 ('F226281151061','2026-03-28','0.310','2026-03-28','11:51:07','PLG0078546','367000','367000','5000','372000','372000','kasir','2026-03-28 11:51:06','F22628115106');
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-03-28','F226281151061','2026-03-28','11:51:07','TIN','372000','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-260328-0027','D','2026-03-28','11:51:07','kasir','PENJUALAN','F226281151061','7688823000','372000','7689195000');
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 ('F226281200451','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-ZABH-58-0','LT X MODEL HURUF MATA LG N 8K ','','0.480','1','100.00','547000','0','0','15000','542000','0','0','0','542000','RTA','00386916','D2E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZABH-58-0' 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-03-28' AND kode_barang='D2E-ZABH-58-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 ('F226281200451','2026-03-28','0.480','2026-03-28','12:00:45','PLG0078547','542000','542000','0','542000','542000','kasir','2026-03-28 12:00:45','F22628120045');
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-03-28','F226281200451','2026-03-28','12:00:45','RTA','542000','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-260328-0028','D','2026-03-28','12:00:45','kasir','PENJUALAN','F226281200451','7689195000','542000','7689737000');
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 ('F226281216081','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZCAX-28-T','GW TUSUK DEASY MATA LG 8K ','OL','0.310','1','100.00','366000','0','0','15000','366000','0','5000','0','371000','NS','T0077969','B1G','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZCAX-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='B1G-ZCAX-28-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 ('F226281216081','2026-03-28','0.310','2026-03-28','12:16:09','PLG0078548','366000','366000','5000','371000','371000','kasir','2026-03-28 12:16:08','F22628121608');
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-03-28','F226281216081','2026-03-28','12:16:09','NS','371000','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-260328-0029','D','2026-03-28','12:16:09','kasir','PENJUALAN','F226281216081','7689737000','371000','7690108000');
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 ('F226281239461','kasir','1',' MEF1 YT 58','TOKO','SMBK-F','F1E-YLXD-43-T','GL COR MODEL C 58 YT 8K ','','3.510','1','100.00','4001000','0','0','15000','3966000','0','0','0','3966000','RTA','T0075511','F1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLXD-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='F1E-YLXD-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 ('F226281239461','2026-03-28','3.510','2026-03-28','12:39:47','PLG0078549','3966000','3966000','0','3966000','3966000','kasir','2026-03-28 12:39:46','F22628123946');
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-03-28','F226281239461','2026-03-28','12:39:47','RTA','3966000','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-260328-0030','D','2026-03-28','12:39:47','kasir','PENJUALAN','F226281239461','7690108000','3966000','7694074000');
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 ('F226280102581','kasir','1',' TDE1 X LG ','TOKO','TBK-E','E1TD-YFBF-72-T','CC X MODEL SLEP VAR LG 11 17K ','','1.530','1','100.00','3182000','0','0','15000','3106000','0','0','0','3106000','TJ','T0070439','E1TD','0','0','-','1','2080000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YFBF-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E1TD-YFBF-72-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 ('F226280102581','2026-03-28','1.530','2026-03-28','13:02:58','PLG0078550','3106000','3106000','0','3106000','3106000','kasir','2026-03-28 13:02:58','F22628010258');
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-03-28','F226280102581','2026-03-28','13:02:58','TJ','3106000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260328-0031','D','2026-03-28','13:02:58','kasir','PENJUALAN','F226280102581','7694074000','3106000','7697180000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3106000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280102581' 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 ('F226280102582','kasir',' 1',' TFB1 CM ','TOKO','TBK-B','B1TF-YJXC-19-T','GW TOGE HATI ARESO CM 17K ','','0.920','1','100.00','1950000','0','0','15000','1905000','0','0','0','1905000','TJ','T0073740','B1TF','0','0','-','1','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-YJXC-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='B1TF-YJXC-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226280102582','2026-03-28','0.920','2026-03-28','13:02:58','PLG0078551','1905000','1905000','0','1905000','1905000','kasir','2026-03-28 13:02:58','F22628010258');
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-03-28','F226280102582','2026-03-28','13:02:58','TJ','1905000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260328-0032','D','2026-03-28','13:02:58','kasir','PENJUALAN','F226280102582','7697180000','1905000','7699085000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1905000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280102582' 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 ('F226280136381','kasir','1',' MED1 UB ','TOKO','SMBK-D','D1E-ZBAX-53-T','LT MODEL BOLA ARESO UB 8K ','OLS KHSMK','0.520','1','100.00','593000','0','0','15000','601000','0','70000','0','671000','RHM','T0077168','D1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAX-53-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-03-28' AND kode_barang='D1E-ZBAX-53-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 ('F226280136381','2026-03-28','0.520','2026-03-28','13:36:39','PLG0078552','601000','601000','70000','671000','671000','kasir','2026-03-28 13:36:38','F22628013638');
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-03-28','F226280136381','2026-03-28','13:36:39','RHM','671000','70000');
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-260328-0033','D','2026-03-28','13:36:39','kasir','PENJUALAN','F226280136381','7699085000','671000','7699756000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='671000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280136381' 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 ('F226280136382','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZCAH-5-T','KL SANTA KH 42CM 8K ','OLS KHSMK','2.030','1','100.00','2314000','0','0','15000','2315000','0','127000','0','2442000','RHM','T0078193','H1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAH-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='H1E-ZCAH-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226280136382','2026-03-28','2.030','2026-03-28','13:36:39','PLG0078553','2315000','2315000','127000','2442000','2442000','kasir','2026-03-28 13:36:38','F22628013638');
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-03-28','F226280136382','2026-03-28','13:36:39','RHM','2442000','127000');
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-260328-0034','D','2026-03-28','13:36:39','kasir','PENJUALAN','F226280136382','7699756000','2442000','7702198000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2442000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280136382' 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 ('F226280148561','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZCXE-87-T','AT KLIP MODEL MATA VAR LG 8K ','OL','1.000','1','100.00','1120000','0','0','15000','1120000','0','0','0','1120000','RTA','T0077763','A1D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCXE-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='A1D-ZCXE-87-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 ('F226280148561','2026-03-28','1.000','2026-03-28','13:48:57','PLG0078554','1120000','1120000','0','1120000','1120000','kasir','2026-03-28 13:48:56','F22628014856');
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-03-28','F226280148561','2026-03-28','13:48:57','RTA','1120000','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-260328-0035','D','2026-03-28','13:48:57','kasir','PENJUALAN','F226280148561','7702198000','1120000','7703318000');
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 ('F226280224271','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZCXE-87-T','AT KLIP MODEL MATA VAR LG 8K ','OL','1.000','1','100.00','1120000','0','0','15000','1115000','0','5000','0','1120000','RTA','T0077763','A1D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCXE-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='A1D-ZCXE-87-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 ('F226280224271','2026-03-28','1.000','2026-03-28','14:24:27','PLG0078555','1115000','1115000','5000','1120000','1120000','kasir','2026-03-28 14:24:27','F22628022427');
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-03-28','F226280224271','2026-03-28','14:24:27','RTA','1120000','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-260328-0037','D','2026-03-28','14:24:27','kasir','PENJUALAN','F226280224271','7702198000','1120000','7703318000');
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 ('F226280243361','kasir','1',' MDE2 X YT ','TOKO','SMBK-E','E2D-YJBC-98-0','CC X MODEL LISTEING MATA YT 8 8K ','','0.950','1','100.00','1064000','0','0','15000','1055000','0','5000','0','1060000','RTA','00374416','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E2D-YJBC-98-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 ('F226280243361','2026-03-28','0.950','2026-03-28','14:43:37','PLG0078556','1055000','1055000','5000','1060000','1060000','kasir','2026-03-28 14:43:36','F22628024336');
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-03-28','F226280243361','2026-03-28','14:43:37','RTA','1060000','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-260328-0038','D','2026-03-28','14:43:37','kasir','PENJUALAN','F226280243361','7703318000','1060000','7704378000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1060000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280243361' 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 ('F226280243362','kasir',' 1',' MDE2 5K LG','TOKO','SMBK-E','E2D-YFAC-17-T','CC ANAK OSROT BONEKA CAT MATA LG 8K ','','1.000','1','100.00','1120000','0','0','15000','1110000','0','5000','0','1115000','RTA','T0069998','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAC-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='E2D-YFAC-17-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 ('F226280243362','2026-03-28','1.000','2026-03-28','14:43:37','PLG0078557','1110000','1110000','5000','1115000','1115000','kasir','2026-03-28 14:43:36','F22628024336');
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-03-28','F226280243362','2026-03-28','14:43:37','RTA','1115000','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-260328-0039','D','2026-03-28','14:43:37','kasir','PENJUALAN','F226280243362','7704378000','1115000','7705493000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1115000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226280243362' 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 ('F226280254321','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZCBG-2-T','GL MODEL GENIA UB 8K ','','0.480','1','100.00','547000','0','0','15000','542000','0','0','0','542000','RTA','T0078318','F3E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBG-2-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-03-28' AND kode_barang='F3E-ZCBG-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 ('F226280254321','2026-03-28','0.480','2026-03-28','14:54:33','PLG0078558','542000','542000','0','542000','542000','kasir','2026-03-28 14:54:32','F22628025432');
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-03-28','F226280254321','2026-03-28','14:54:33','RTA','542000','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-260328-0040','D','2026-03-28','14:54:33','kasir','PENJUALAN','F226280254321','7705493000','542000','7706035000');
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 ('F226280259221','kasir','1',' MDB1 UB PE','TOKO','SMBK-B','B1D-ZCAC-9-T','GW TUSUK MODEL HATI VAR UB PE 8K ','OL','0.980','1','100.00','1098000','0','0','15000','1098000','0','5000','0','1103000','RTA','T0078122','B1D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZCAC-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='B1D-ZCAC-9-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 ('F226280259221','2026-03-28','0.980','2026-03-28','14:59:22','PLG0078559','1098000','1098000','5000','1103000','1103000','kasir','2026-03-28 14:59:22','F22628025922');
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-03-28','F226280259221','2026-03-28','14:59:22','RTA','1103000','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-260328-0041','D','2026-03-28','14:59:22','kasir','PENJUALAN','F226280259221','7706035000','1103000','7707138000');
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 ('F226280302221','kasir','1',' TFF3 UB ','TOKO','TBK-F','F3TF-YHXG-110-T','GL RANTAI HOLLOW UB 17K ','','0.540','1','100.00','1145000','0','0','15000','1118000','0','0','0','1118000','NS','T0072097','F3TF','0','0','-','1','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YHXG-110-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-03-28' AND kode_barang='F3TF-YHXG-110-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 ('F226280302221','2026-03-28','0.540','2026-03-28','15:02:23','PLG0078560','1118000','1118000','0','1118000','1118000','kasir','2026-03-28 15:02:22','F22628030222');
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-03-28','F226280302221','2026-03-28','15:02:23','NS','1118000','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-260328-0042','D','2026-03-28','15:02:23','kasir','PENJUALAN','F226280302221','7707138000','1118000','7708256000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280102581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280102581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280102581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280102582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280102582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280102582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280136381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280136381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280136381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280136382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280136382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280136382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280224271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280224271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280224271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280243361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280243361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280243361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280243362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280243362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280243362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280254321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280254321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280254321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280259221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280259221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280259221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280302221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280302221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280302221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280824161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280824161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280824161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280834301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280834301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280834301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280843161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280843161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280843161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280919251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280919251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280919251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280926401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280926401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280926401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280959451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280959451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280959451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280959452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280959452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280959452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281006371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281006371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281006371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281006372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281006372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281006372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281040141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281040141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281040141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281040142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281040142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281040142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281046411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281046411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281046411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281059331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281059331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281059331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281059332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281059332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281059332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281101451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281101451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281101451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281101452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281101452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281101452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281120351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281120351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281120351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281128401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281128401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281128401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281135261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281135262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135263' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135263' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281135263';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281135561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281135561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281137161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281137161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281137161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281137162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281137162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281137162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281150181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281150181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281150181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281151061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281151061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281151061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281200451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281200451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281200451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281216081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281216081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281216081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226281239461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226281239461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226281239461';
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 ('F226280343051','kasir','1',' MFD1 8K BG','TOKO','SMBK-D','D1F-ZCBG-14-T','LT MODEL BUNGA PASIR BG 8K ','OL','1.200','1','100.00','1392000','0','0','15000','1384000','0','8000','0','1392000','NS','T0078330','D1F','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZCBG-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='D1F-ZCBG-14-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 ('F226280343051','2026-03-28','1.200','2026-03-28','15:43:06','PLG0078561','1384000','1384000','8000','1392000','1392000','kasir','2026-03-28 15:43:05','F22628034305');
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-03-28','F226280343051','2026-03-28','15:43:06','NS','1392000','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-260328-0043','D','2026-03-28','15:43:06','kasir','PENJUALAN','F226280343051','7708256000','1392000','7709648000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226280343051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226280343051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226280343051';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-28';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-28' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','16:29:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','7709648000','7709648000');
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-260329-0001','D','2026-03-29','16:29:12','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','16:29:12','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','16:29:12','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','16:29:12','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','16:29:12','BCA','SALDO AWAL','SALDO AWAL','0','4318451888','4318451888');
UPDATE tp_system SET tgl_system='2026-03-29';