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 ('F226140847511','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZDBC-69-T','GW TUSUK DEASY MATA LG 8K ','OL','0.300','1','100.00','351000','0','0','15000','357000','0','5000','0','362000','NS','T0078950','B1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZDBC-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1G-ZDBC-69-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 ('F226140847511','2026-05-14','0.300','2026-05-14','08:47:51','PLG0079997','357000','357000','5000','362000','362000','kasir','2026-05-14 08:47:51','F22614084751');
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-05-14','F226140847511','2026-05-14','08:47:51','NS','362000','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-260514-0002','D','2026-05-14','08:47:51','kasir','PENJUALAN','F226140847511','9553641000','362000','9554003000');
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 ('F226140918401','kasir','1',' MHD1 LG ','TOKO','SMBK-D','D1H-ZEAC-10-T','LT MODEL DAUN VAR LG 8K ','OL','0.180','1','100.00','214000','0','0','15000','216000','0','5000','0','221000','NS','T0079415','D1H','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZEAC-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D1H-ZEAC-10-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 ('F226140918401','2026-05-14','0.180','2026-05-14','09:18:40','PLG0079998','216000','216000','5000','221000','221000','kasir','2026-05-14 09:18:40','F22614091840');
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-05-14','F226140918401','2026-05-14','09:18:40','NS','221000','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-260514-0003','D','2026-05-14','09:18:40','kasir','PENJUALAN','F226140918401','9554003000','221000','9554224000');
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 ('F226140919291','kasir','1',' MHD1 LG ','TOKO','SMBK-D','D1H-ZEAC-7-T','LT MODEL DAUN VAR LG 8K ','OL','0.180','1','100.00','214000','0','0','15000','216000','0','5000','0','221000','RTA','T0079412','D1H','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZEAC-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D1H-ZEAC-7-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 ('F226140919291','2026-05-14','0.180','2026-05-14','09:19:29','PLG0079999','216000','216000','5000','221000','221000','kasir','2026-05-14 09:19:29','F22614091929');
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-05-14','F226140919291','2026-05-14','09:19:29','RTA','221000','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-260514-0004','D','2026-05-14','09:19:29','kasir','PENJUALAN','F226140919291','9554224000','221000','9554445000');
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 ('F226140924041','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZEAB-8-T','GL OVAL MODEL C TD D54 8K 8K ','OL','3.040','1','100.00','3435000','0','0','15000','3451000','0','15000','0','3466000','NS','T0079366','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAB-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-ZEAB-8-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 ('F226140924041','2026-05-14','3.040','2026-05-14','09:24:04','PLG0080000','3451000','3451000','15000','3466000','3466000','kasir','2026-05-14 09:24:04','F22614092404');
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-05-14','F226140924041','2026-05-14','09:24:04','NS','3466000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260514-0005','D','2026-05-14','09:24:04','kasir','PENJUALAN','F226140924041','9554445000','3466000','9557911000');
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 ('F226140957061','kasir','1',' TAE0TA DW ','TOKO','TBK-E','E0TA-UCBH-21-T','CC BANGKOK POLOS DW 16','OLS E59M','1.000','1','100.00','1940000','0','0','15000','1965000','0','133000','0','2098000','RHM','T0002380','E0TA','0','0','-','0','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-UCBH-21-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-05-14' AND kode_barang='E0TA-UCBH-21-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 ('F226140957061','2026-05-14','1.000','2026-05-14','09:57:06','PLG0080001','1965000','1965000','133000','2098000','2098000','kasir','2026-05-14 09:57:06','F22614095706');
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-05-14','F226140957061','2026-05-14','09:57:06','RHM','2098000','133000');
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-260514-0006','D','2026-05-14','09:57:06','kasir','PENJUALAN','F226140957061','9557911000','2098000','9560009000');
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 ('F226140958401','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZEXF-7-T','GL OVAL MODEL C TD D54 8K ','OLS M9PM','3.040','1','100.00','3435000','0','0','15000','3435000','0','224000','0','3659000','RHM','T0079168','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEXF-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-ZEXF-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 ('F226140958401','2026-05-14','3.040','2026-05-14','09:58:40','PLG0080002','3435000','3435000','224000','3659000','3659000','kasir','2026-05-14 09:58:40','F22614095840');
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-05-14','F226140958401','2026-05-14','09:58:40','RHM','3659000','224000');
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-260514-0007','D','2026-05-14','09:58:40','kasir','PENJUALAN','F226140958401','9560009000','3659000','9563668000');
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 ('F226141000051','kasir','1',' MEF1 10K U','TOKO','SMBK-F','F1E-YJBI-53-T','GL OVAL ODEL BUNGA PASIR VAR UB D55 8K ','OLS FYY3','2.150','1','100.00','2429000','0','0','15000','2430000','0','261000','0','2691000','RHM','T0074613','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBI-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-YJBI-53-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 ('F226141000051','2026-05-14','2.150','2026-05-14','10:00:05','PLG0080003','2430000','2430000','261000','2691000','2691000','kasir','2026-05-14 10:00:05','F22614100005');
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-05-14','F226141000051','2026-05-14','10:00:05','RHM','2691000','261000');
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-260514-0008','D','2026-05-14','10:00:05','kasir','PENJUALAN','F226141000051','9563668000','2691000','9566359000');
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 ('F226141001191','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YLBI-185-0','GL X TIFF SPECTRA HITAM HW 8K ','OLS 5PW2','1.700','1','100.00','1921000','0','0','15000','1938000','0','212000','0','2150000','RHM','00383337','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBI-185-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-YLBI-185-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141001191','2026-05-14','1.700','2026-05-14','10:01:20','PLG0080004','1938000','1938000','212000','2150000','2150000','kasir','2026-05-14 10:01:19','F22614100119');
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-05-14','F226141001191','2026-05-14','10:01:20','RHM','2150000','212000');
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-260514-0009','D','2026-05-14','10:01:20','kasir','PENJUALAN','F226141001191','9566359000','2150000','9568509000');
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 ('F226141002331','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZCAF-7-T','GL MODEL FANCY VAR KH 8K ','OLS SRUG','1.570','1','100.00','1774000','0','0','15000','1774000','0','200000','0','1974000','RHM','T0078166','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAF-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZCAF-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 ('F226141002331','2026-05-14','1.570','2026-05-14','10:02:34','PLG0080005','1774000','1774000','200000','1974000','1974000','kasir','2026-05-14 10:02:33','F22614100233');
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-05-14','F226141002331','2026-05-14','10:02:34','RHM','1974000','200000');
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-260514-0010','D','2026-05-14','10:02:34','kasir','PENJUALAN','F226141002331','9568509000','1974000','9570483000');
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 ('F226141004061','kasir','1',' TDE2 X MJ ','TOKO','TBK-E','E2TD-YLAA-39-T','CC X COR MODEL MATA 12 MJ 17K ','OLS XFX7','1.350','1','100.00','2727000','0','0','15000','2728000','0','170000','0','2898000','RHM','T0075697','E2TD','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YLAA-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E2TD-YLAA-39-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 ('F226141004061','2026-05-14','1.350','2026-05-14','10:04:06','PLG0080006','2728000','2728000','170000','2898000','2898000','kasir','2026-05-14 10:04:06','F22614100406');
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-05-14','F226141004061','2026-05-14','10:04:06','RHM','2898000','170000');
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-260514-0011','D','2026-05-14','10:04:06','kasir','PENJUALAN','F226141004061','9570483000','2898000','9573381000');
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 ('F226141005041','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZCXF-22-T','GW TOGE MRICAN POLOS LG 8K ','OLS NSDY','0.300','1','100.00','351000','0','0','15000','356000','0','40000','0','396000','RHM','T0077844','B1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZCXF-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1G-ZCXF-22-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 ('F226141005041','2026-05-14','0.300','2026-05-14','10:05:04','PLG0080007','356000','356000','40000','396000','396000','kasir','2026-05-14 10:05:04','F22614100504');
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-05-14','F226141005041','2026-05-14','10:05:04','RHM','396000','40000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260514-0012','D','2026-05-14','10:05:04','kasir','PENJUALAN','F226141005041','9573381000','396000','9573777000');
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 ('F226141015041','kasir','1',' MGF3G X UB','TOKO','SMBK-F','F3G-ZDBX-137-0','GL X BORSALINO UB 8K ','','0.350','1','100.00','409000','0','0','15000','410000','0','0','0','410000','NS','00400074','F3G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-ZDBX-137-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3G-ZDBX-137-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141015041','2026-05-14','0.350','2026-05-14','10:15:05','PLG0080008','410000','410000','0','410000','410000','kasir','2026-05-14 10:15:04','F22614101504');
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-05-14','F226141015041','2026-05-14','10:15:05','NS','410000','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-260514-0013','D','2026-05-14','10:15:05','kasir','PENJUALAN','F226141015041','9573777000','410000','9574187000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141015041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141015041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141015041';
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 ('F226141018561','kasir','1',' TEH1 X HW ','TOKO','TBK-H','H1TE-ZCBC-30-T','KL X SANTA BUNGA CLOVER SLEP HW 17K ','OL','2.500','1','100.00','5100000','0','0','15000','5107000','0','18000','0','5125000','RTA','T0078265','H1TE','0','0','-','0','2040000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='H1TE-ZCBC-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141018561','2026-05-14','2.500','2026-05-14','10:18:57','PLG0080009','5107000','5107000','18000','5125000','5125000','kasir','2026-05-14 10:18:56','F22614101856');
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-05-14','F226141018561','2026-05-14','10:18:57','RTA','5125000','18000');
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-260514-0014','D','2026-05-14','10:18:57','kasir','PENJUALAN','F226141018561','9574187000','5125000','9579312000');
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 ('F226141019431','kasir','1',' MDE1 CM 20','TOKO','SMBK-E','E1D-ZDXG-28-T','CC POLOS CM 20 8K ','OL','1.000','1','100.00','1110000','0','0','15000','1115000','0','5000','0','1120000','RTA','T0078568','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDXG-28-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-05-14' AND kode_barang='E1D-ZDXG-28-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 ('F226141019431','2026-05-14','1.000','2026-05-14','10:19:43','PLG0080010','1115000','1115000','5000','1120000','1120000','kasir','2026-05-14 10:19:43','F22614101943');
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-05-14','F226141019431','2026-05-14','10:19:43','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-260514-0015','D','2026-05-14','10:19:43','kasir','PENJUALAN','F226141019431','9579312000','1120000','9580432000');
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 ('F226141021031','kasir','1',' MEH1 X YT ','TOKO','SMBK-H','H1E-ZBXE-312-0','KL X TIFF SPECTRA HITAM YT 8K ','OL','2.350','1','100.00','2655000','0','0','15000','2668000','0','12000','0','2680000','RTA','00388580','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBXE-312-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='H1E-ZBXE-312-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141021031','2026-05-14','2.350','2026-05-14','10:21:03','PLG0080011','2668000','2668000','12000','2680000','2680000','kasir','2026-05-14 10:21:03','F22614102103');
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-05-14','F226141021031','2026-05-14','10:21:03','RTA','2680000','12000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260514-0016','D','2026-05-14','10:21:03','kasir','PENJUALAN','F226141021031','9580432000','2680000','9583112000');
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 ('F226141021531','kasir','1',' MEE2 X HT ','TOKO','SMBK-E','E2E-ZCXB-142-0','CC X PIPA MATA HT 16 8K ','','0.500','1','100.00','565000','0','0','15000','565000','0','0','0','565000','TIN','00391565','E2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCXB-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E2E-ZCXB-142-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 ('F226141021531','2026-05-14','0.500','2026-05-14','10:21:53','PLG0080012','565000','565000','0','565000','565000','kasir','2026-05-14 10:21:53','F22614102153');
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-05-14','F226141021531','2026-05-14','10:21:53','TIN','565000','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-260514-0017','D','2026-05-14','10:21:53','kasir','PENJUALAN','F226141021531','9583112000','565000','9583677000');
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 ('F226141022191','kasir','1',' TFF3 UB ','TOKO','TBK-F','F3TF-YHXG-111-T','GL RANTAI HOLLOW UB 17K ','','0.540','1','100.00','1112000','0','0','15000','1113000','0','0','0','1113000','NS','T0072098','F3TF','0','0','-','0','2060000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YHXG-111-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-05-14' AND kode_barang='F3TF-YHXG-111-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 ('F226141022191','2026-05-14','0.540','2026-05-14','10:22:20','PLG0080013','1113000','1113000','0','1113000','1113000','kasir','2026-05-14 10:22:19','F22614102219');
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-05-14','F226141022191','2026-05-14','10:22:20','NS','1113000','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-260514-0018','D','2026-05-14','10:22:20','kasir','PENJUALAN','F226141022191','9583677000','1113000','9584790000');
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 ('F226141035161','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZEXG-17-T','LT MODEL HATI POLOS LG 8K ','','0.500','1','100.00','565000','0','0','15000','565000','0','0','0','565000','TJ','T0079282','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXG-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D1E-ZEXG-17-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 ('F226141035161','2026-05-14','0.500','2026-05-14','10:35:17','PLG0080014','565000','565000','0','565000','565000','kasir','2026-05-14 10:35:16','F22614103516');
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-05-14','F226141035161','2026-05-14','10:35:17','TJ','565000','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-260514-0019','D','2026-05-14','10:35:17','kasir','PENJUALAN','F226141035161','9584790000','565000','9585355000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141035161' 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 ('F226141035162','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZDAC-35-T','KL SANTA KH 42CM 8K ','','1.560','1','100.00','1763000','0','0','15000','1763000','0','0','0','1763000','TJ','T0078654','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='H1E-ZDAC-35-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 ('F226141035162','2026-05-14','1.560','2026-05-14','10:35:17','PLG0080015','1763000','1763000','0','1763000','1763000','kasir','2026-05-14 10:35:16','F22614103516');
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-05-14','F226141035162','2026-05-14','10:35:17','TJ','1763000','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-260514-0020','D','2026-05-14','10:35:17','kasir','PENJUALAN','F226141035162','9585355000','1763000','9587118000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1763000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141035162' 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 ('F226141211141','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZEXA-19-T','AT TINDIK BABY LG 8K ','OL','0.470','1','100.00','531000','0','0','15000','538000','0','5000','0','543000','NS','T0079131','A1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEXA-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='A1E-ZEXA-19-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 ('F226141211141','2026-05-14','0.470','2026-05-14','12:11:15','PLG0080016','538000','538000','5000','543000','543000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211141','2026-05-14','12:11:15','NS','543000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0021','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211141','9587118000','543000','9587661000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211141' 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 ('F226141211142','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEXH-18-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL ','0.470','1','100.00','531000','0','0','15000','538000','0','5000','0','543000','NS','T0079317','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXH-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1E-ZEXH-18-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 ('F226141211142','2026-05-14','0.470','2026-05-14','12:11:15','PLG0080017','538000','538000','5000','543000','543000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211142','2026-05-14','12:11:15','NS','543000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0022','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211142','9587661000','543000','9588204000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211142' 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 ('F226141211143','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEXH-17-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.470','1','100.00','531000','0','0','15000','538000','0','5000','0','543000','NS','T0079316','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXH-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1E-ZEXH-17-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 ('F226141211143','2026-05-14','0.470','2026-05-14','12:11:15','PLG0080018','538000','538000','5000','543000','543000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211143','2026-05-14','12:11:15','NS','543000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0023','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211143','9588204000','543000','9588747000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211143' 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 ('F226141211144','kasir',' 1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDCX-25-T','GW TUSUK KUPU PASIR BW 8K ','OL','0.470','1','100.00','531000','0','0','15000','538000','0','5000','0','543000','NS','T0079094','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDCX-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1E-ZDCX-25-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 ('F226141211144','2026-05-14','0.470','2026-05-14','12:11:15','PLG0080019','538000','538000','5000','543000','543000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211144','2026-05-14','12:11:15','NS','543000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0024','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211144','9588747000','543000','9589290000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211144' 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 ('F226141211145','kasir',' 1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDCX-21-T','GW TUSUK KUPU PASIR BW 8K ','OL','0.470','1','100.00','531000','0','0','15000','538000','0','5000','0','543000','NS','T0079090','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDCX-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='B1E-ZDCX-21-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 ('F226141211145','2026-05-14','0.470','2026-05-14','12:11:15','PLG0080020','538000','538000','5000','543000','543000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211145','2026-05-14','12:11:15','NS','543000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0025','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211145','9589290000','543000','9589833000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211145' 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 ('F226141211146','kasir',' 1',' MGD1 5K BW','TOKO','SMBK-D','D1G-ZEXH-7-T','LT MODEL PEANUT PASIR VAR BW 8K ','OL','0.310','1','100.00','363000','0','0','15000','367000','0','5000','0','372000','NS','T0079306','D1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXH-7-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-05-14' AND kode_barang='D1G-ZEXH-7-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 ('F226141211146','2026-05-14','0.310','2026-05-14','12:11:15','PLG0080021','367000','367000','5000','372000','372000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211146','2026-05-14','12:11:15','NS','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,status_valid) VALUES ('KM-260514-0026','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211146','9589833000','372000','9590205000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='372000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211146' 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 ('F226141211147','kasir',' 1',' MDE2 LG R ','TOKO','SMBK-D','D2E-ZBAI-40-T','LT MODEL HURUF MATA LG R 8K ','OL','0.600','1','100.00','678000','0','0','15000','687000','0','5000','0','692000','NS','T0077572','D2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBAI-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D2E-ZBAI-40-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 ('F226141211147','2026-05-14','0.600','2026-05-14','12:11:15','PLG0080022','687000','687000','5000','692000','692000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211147','2026-05-14','12:11:15','NS','692000','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-260514-0027','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211147','9590205000','692000','9590897000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='692000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211147' 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 ('F226141211148','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZEAB-26-T','LT MODEL FINE GOLD BAR LG 8K ','OL','0.520','1','100.00','588000','0','0','15000','595000','0','5000','0','600000','NS','T0079384','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEAB-26-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-05-14' AND kode_barang='D1E-ZEAB-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 ('F226141211148','2026-05-14','0.520','2026-05-14','12:11:15','PLG0080023','595000','595000','5000','600000','600000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211148','2026-05-14','12:11:15','NS','600000','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-260514-0028','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211148','9590897000','600000','9591497000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211148' 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 ('F226141211149','kasir',' 1',' MDE1 CM 12','TOKO','SMBK-E','E1D-ZDBC-34-T','CC MODEL C CM 12 8K ','OL','1.050','1','100.00','1165000','0','0','15000','1176000','0','5000','0','1181000','NS','T0078915','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBC-34-T' 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-05-14' AND kode_barang='E1D-ZDBC-34-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 ('F226141211149','2026-05-14','1.050','2026-05-14','12:11:15','PLG0080024','1176000','1176000','5000','1181000','1181000','kasir','2026-05-14 12:11:14','F22614121114');
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-05-14','F226141211149','2026-05-14','12:11:15','NS','1181000','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-260514-0029','D','2026-05-14','12:11:15','kasir','PENJUALAN','F226141211149','9591497000','1181000','9592678000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1181000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141211149' 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 ('F226141212481','kasir','1',' MDE2 CM 18','TOKO','SMBK-E','E2D-ZEXH-57-T','CC MODEL MATA SLEP VAR CM 18 8K ','OL','1.210','1','100.00','1343000','0','0','15000','1355000','0','6000','0','1361000','NS','T0079356','E2D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXH-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E2D-ZEXH-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141212481','2026-05-14','1.210','2026-05-14','12:12:48','PLG0080025','1355000','1355000','6000','1361000','1361000','kasir','2026-05-14 12:12:48','F22614121248');
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-05-14','F226141212481','2026-05-14','12:12:48','NS','1361000','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-260514-0030','D','2026-05-14','12:12:48','kasir','PENJUALAN','F226141212481','9592678000','1361000','9594039000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1361000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141212481' 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 ('F226141212482','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZDBE-39-T','GL MODEL FANCY VAR HW 8K ','OL','0.780','1','100.00','881000','0','0','15000','893000','0','5000','0','898000','NS','T0079008','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBE-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZDBE-39-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 ('F226141212482','2026-05-14','0.780','2026-05-14','12:12:48','PLG0080026','893000','893000','5000','898000','898000','kasir','2026-05-14 12:12:48','F22614121248');
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-05-14','F226141212482','2026-05-14','12:12:48','NS','898000','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-260514-0031','D','2026-05-14','12:12:48','kasir','PENJUALAN','F226141212482','9594039000','898000','9594937000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='898000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141212482' 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 ('F226141212483','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZEXF-84-T','KL RANTAI HOLLOW UB 45CM 8K ','OL','1.030','1','100.00','1164000','0','0','15000','1174000','0','5000','0','1179000','NS','T0079245','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-84-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-05-14' AND kode_barang='H1E-ZEXF-84-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 ('F226141212483','2026-05-14','1.030','2026-05-14','12:12:48','PLG0080027','1174000','1174000','5000','1179000','1179000','kasir','2026-05-14 12:12:48','F22614121248');
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-05-14','F226141212483','2026-05-14','12:12:48','NS','1179000','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-260514-0032','D','2026-05-14','12:12:48','kasir','PENJUALAN','F226141212483','9594937000','1179000','9596116000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1179000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141212483' 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 ('F226141212484','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEXF-14-T','GL FLIK MODEL BINTANG VAR HW 8K ','OL','1.580','1','100.00','1785000','0','0','15000','1801000','0','8000','0','1809000','NS','T0079175','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZEXF-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141212484','2026-05-14','1.580','2026-05-14','12:12:48','PLG0080028','1801000','1801000','8000','1809000','1809000','kasir','2026-05-14 12:12:48','F22614121248');
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-05-14','F226141212484','2026-05-14','12:12:48','NS','1809000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0033','D','2026-05-14','12:12:48','kasir','PENJUALAN','F226141212484','9596116000','1809000','9597925000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1809000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141212484' 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 ('F226141242031','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZEXG-3-T','GL OVAL MODEL C GELOMBANG TD D54 8K ','OL','2.780','1','100.00','3141000','0','0','15000','3156000','0','14000','0','3170000','RTA','T0079268','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEXG-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-ZEXG-3-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 ('F226141242031','2026-05-14','2.780','2026-05-14','12:42:03','PLG0080029','3156000','3156000','14000','3170000','3170000','kasir','2026-05-14 12:42:03','F22614124203');
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-05-14','F226141242031','2026-05-14','12:42:03','RTA','3170000','14000');
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-260514-0034','D','2026-05-14','12:42:03','kasir','PENJUALAN','F226141242031','9597925000','3170000','9601095000');
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 ('F226141242571','kasir','1',' MEE1 CM 12','TOKO','SMBK-E','E1E-ZDBE-35-T','CC MODEL BUNGA CLOVER CAT CM 12 8K ','OL','0.420','1','100.00','475000','0','0','15000','480000','0','5000','0','485000','RTA','T0079004','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBE-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E1E-ZDBE-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141242571','2026-05-14','0.420','2026-05-14','12:42:58','PLG0080030','480000','480000','5000','485000','485000','kasir','2026-05-14 12:42:57','F22614124257');
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-05-14','F226141242571','2026-05-14','12:42:58','RTA','485000','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-260514-0035','D','2026-05-14','12:42:58','kasir','PENJUALAN','F226141242571','9601095000','485000','9601580000');
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 ('F226141243391','kasir','1',' MEE1 CM 12','TOKO','SMBK-E','E1E-ZDBE-31-T','CC MODEL AUREL POLOS CM 12 8K ','OL','0.470','1','100.00','531000','0','0','15000','536000','0','5000','0','541000','RTA','T0079000','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBE-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E1E-ZDBE-31-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 ('F226141243391','2026-05-14','0.470','2026-05-14','12:43:40','PLG0080031','536000','536000','5000','541000','541000','kasir','2026-05-14 12:43:39','F22614124339');
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-05-14','F226141243391','2026-05-14','12:43:40','RTA','541000','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-260514-0036','D','2026-05-14','12:43:40','kasir','PENJUALAN','F226141243391','9601580000','541000','9602121000');
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 ('F226141250211','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEAB-11-T','GL KOREA UB 8K ','','0.880','1','100.00','994000','0','0','15000','994000','0','0','0','994000','NS','T0079369','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAB-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZEAB-11-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 ('F226141250211','2026-05-14','0.880','2026-05-14','12:50:22','PLG0080032','994000','994000','0','994000','994000','kasir','2026-05-14 12:50:21','F22614125021');
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-05-14','F226141250211','2026-05-14','12:50:22','NS','994000','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-260514-0037','D','2026-05-14','12:50:22','kasir','PENJUALAN','F226141250211','9602121000','994000','9603115000');
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 ('F226140107501','kasir','1',' MFD1 5K BW','TOKO','SMBK-D','D1F-ZEAB-35-T','LT MODEL PEANUT PASIR VAR BW 8K ','OL','0.370','1','100.00','425000','0','0','15000','431000','0','5000','0','436000','RTA','T0079393','D1F','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEAB-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D1F-ZEAB-35-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 ('F226140107501','2026-05-14','0.370','2026-05-14','13:07:51','PLG0080033','431000','431000','5000','436000','436000','kasir','2026-05-14 13:07:50','F22614010750');
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-05-14','F226140107501','2026-05-14','13:07:51','RTA','436000','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-260514-0038','D','2026-05-14','13:07:51','kasir','PENJUALAN','F226140107501','9603115000','436000','9603551000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='436000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140107501' 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 ('F226140107502','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-16-T','GL RANTAI HOLLOW DOUBLE UB 8K ','OL','2.000','1','100.00','2260000','0','0','15000','2280000','0','10000','0','2290000','RTA','T0079177','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZEXF-16-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 ('F226140107502','2026-05-14','2.000','2026-05-14','13:07:51','PLG0080034','2280000','2280000','10000','2290000','2290000','kasir','2026-05-14 13:07:50','F22614010750');
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-05-14','F226140107502','2026-05-14','13:07:51','RTA','2290000','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-260514-0039','D','2026-05-14','13:07:51','kasir','PENJUALAN','F226140107502','9603551000','2290000','9605841000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2290000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140107502' 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 ('F226140107503','kasir',' 1',' MEF1 X CM ','TOKO','SMBK-F','F1E-YFBX-127-0','GL X OSROT MATA ANAK CM 8K ','OL','2.250','1','100.00','2542000','0','0','15000','2565000','0','11000','0','2576000','RTA','00358212','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YFBX-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-YFBX-127-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140107503','2026-05-14','2.250','2026-05-14','13:07:51','PLG0080035','2565000','2565000','11000','2576000','2576000','kasir','2026-05-14 13:07:50','F22614010750');
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-05-14','F226140107503','2026-05-14','13:07:51','RTA','2576000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260514-0040','D','2026-05-14','13:07:51','kasir','PENJUALAN','F226140107503','9605841000','2576000','9608417000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2576000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140107503' 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 ('F226140107504','kasir',' 1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZEXF-99-T','KL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL','2.030','1','100.00','2294000','0','0','15000','2315000','0','10000','0','2325000','RTA','T0079260','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-99-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-05-14' AND kode_barang='H1E-ZEXF-99-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 ('F226140107504','2026-05-14','2.030','2026-05-14','13:07:51','PLG0080036','2315000','2315000','10000','2325000','2325000','kasir','2026-05-14 13:07:50','F22614010750');
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-05-14','F226140107504','2026-05-14','13:07:51','RTA','2325000','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-260514-0041','D','2026-05-14','13:07:51','kasir','PENJUALAN','F226140107504','9608417000','2325000','9610742000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2325000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140107504' 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 ('F226140110491','kasir','1',' MEF1 10K U','TOKO','SMBK-F','F1E-ZACX-23-T','GL ANAK PIPA BONEKA CAT VAR UB D40 8K ','OL','1.480','1','100.00','1672000','0','0','15000','1677000','0','10000','0','1687000','RTA','T0076937','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZACX-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-ZACX-23-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 ('F226140110491','2026-05-14','1.480','2026-05-14','13:10:49','PLG0080037','1677000','1677000','10000','1687000','1687000','kasir','2026-05-14 13:10:49','F22614011049');
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-05-14','F226140110491','2026-05-14','13:10:49','RTA','1687000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260514-0042','D','2026-05-14','13:10:49','kasir','PENJUALAN','F226140110491','9610742000','1687000','9612429000');
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 ('F226140140041','kasir','1',' MEH1 KH ','TOKO','SMBK-H','H1E-ZDAF-2-T','KL SANTA MODEL KUNCI MATA VAR KH 8K ','OL','2.640','1','100.00','2983000','0','0','15000','3010000','0','13000','0','3023000','TIN','T0078668','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAF-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='H1E-ZDAF-2-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 ('F226140140041','2026-05-14','2.640','2026-05-14','13:40:05','PLG0080038','3010000','3010000','13000','3023000','3023000','kasir','2026-05-14 13:40:04','F22614014004');
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-05-14','F226140140041','2026-05-14','13:40:05','TIN','3023000','13000');
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-260514-0043','D','2026-05-14','13:40:05','kasir','PENJUALAN','F226140140041','9612429000','3023000','9615452000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140140041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140140041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140140041';
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 ('F226140147011','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEXG-32-T','GL MODEL FANCY SLEP VAR HW 8K ','','1.450','1','100.00','1638000','0','0','15000','1640000','0','0','0','1640000','NS','T0079297','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZEXG-32-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 ('F226140147011','2026-05-14','1.450','2026-05-14','13:47:02','PLG0080039','1640000','1640000','0','1640000','1640000','kasir','2026-05-14 13:47:01','F22614014701');
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-05-14','F226140147011','2026-05-14','13:47:02','NS','1640000','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-260514-0044','D','2026-05-14','13:47:02','kasir','PENJUALAN','F226140147011','9615452000','1640000','9617092000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1640000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140147011' 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 ('F226140147012','kasir',' 1',' MEE2E CM 2','TOKO','SMBK-E','E2E-ZBAC-35-T','CC WEDDING MATA CM 20 8K ','','1.080','1','100.00','1220000','0','0','15000','1220000','0','10000','0','1230000','NS','T0077244','E2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E2E-ZBAC-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140147012','2026-05-14','1.080','2026-05-14','13:47:02','PLG0080040','1220000','1220000','10000','1230000','1230000','kasir','2026-05-14 13:47:01','F22614014701');
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-05-14','F226140147012','2026-05-14','13:47:02','NS','1230000','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-260514-0045','D','2026-05-14','13:47:02','kasir','PENJUALAN','F226140147012','9617092000','1230000','9618322000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1230000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140147012' 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 ('F226140147013','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZDBB-28-T','AS EXTENSION LG 8K ','','0.200','1','100.00','234000','0','0','15000','238000','0','0','0','238000','NS','T0078818','S1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZDBB-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='S1G-ZDBB-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140147013','2026-05-14','0.200','2026-05-14','13:47:02','PLG0080041','238000','238000','0','238000','238000','kasir','2026-05-14 13:47:01','F22614014701');
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-05-14','F226140147013','2026-05-14','13:47:02','NS','238000','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-260514-0046','D','2026-05-14','13:47:02','kasir','PENJUALAN','F226140147013','9618322000','238000','9618560000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='238000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140147013' 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 ('F226140148161','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZEAB-7-T','GL OVAL MODEL C TD D56 8K 8K ','','3.170','1','100.00','3582000','0','0','15000','3582000','0','0','0','3582000','RTA','T0079365','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAB-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F1E-ZEAB-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 ('F226140148161','2026-05-14','3.170','2026-05-14','13:48:16','PLG0080042','3582000','3582000','0','3582000','3582000','kasir','2026-05-14 13:48:16','F22614014816');
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-05-14','F226140148161','2026-05-14','13:48:16','RTA','3582000','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-260514-0047','D','2026-05-14','13:48:16','kasir','PENJUALAN','F226140148161','9618560000','3582000','9622142000');
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 ('F226140238141','kasir','1',' MED2 5K UB','TOKO','SMBK-D','D2E-YAAF-9-T','LT MODEL BONEKA CAT MATA VAR UB 8K ','OL','0.610','1','100.00','689000','0','0','15000','695000','0','5000','0','700000','RTA','T0066127','D2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YAAF-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D2E-YAAF-9-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 ('F226140238141','2026-05-14','0.610','2026-05-14','14:38:14','PLG0080043','695000','695000','5000','700000','700000','kasir','2026-05-14 14:38:14','F22614023814');
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-05-14','F226140238141','2026-05-14','14:38:14','RTA','700000','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-260514-0048','D','2026-05-14','14:38:14','kasir','PENJUALAN','F226140238141','9622142000','700000','9622842000');
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 ('F226140243541','kasir','1',' MDE1 X OR ','TOKO','SMBK-E','E1D-ZDBI-128-0','CC X VELG SLEP OR 18 8K ','','1.010','1','100.00','1121000','0','0','15000','1122000','0','0','0','1122000','RTA','00401774','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBI-128-0' 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-05-14' AND kode_barang='E1D-ZDBI-128-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 ('F226140243541','2026-05-14','1.010','2026-05-14','14:43:55','PLG0080044','1122000','1122000','0','1122000','1122000','kasir','2026-05-14 14:43:54','F22614024354');
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-05-14','F226140243541','2026-05-14','14:43:55','RTA','1122000','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-260514-0049','D','2026-05-14','14:43:55','kasir','PENJUALAN','F226140243541','9622842000','1122000','9623964000');
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 ('F226140251221','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZEXF-47-T','LT SLOBOK BOLA ARESO LG 8K ','OL','0.400','1','100.00','452000','0','0','15000','456000','0','5000','0','461000','TIN','T0079208','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXF-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D1E-ZEXF-47-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 ('F226140251221','2026-05-14','0.400','2026-05-14','14:51:22','PLG0080045','456000','456000','5000','461000','461000','kasir','2026-05-14 14:51:22','F22614025122');
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-05-14','F226140251221','2026-05-14','14:51:22','TIN','461000','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-260514-0050','D','2026-05-14','14:51:22','kasir','PENJUALAN','F226140251221','9623964000','461000','9624425000');
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 ('F226140309081','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-27-T','GL LONG LING UB 8K ','','0.980','1','100.00','1107000','0','0','15000','1107000','0','0','0','1107000','TIN','T0079188','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-27-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-05-14' AND kode_barang='F3E-ZEXF-27-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 ('F226140309081','2026-05-14','0.980','2026-05-14','15:09:09','PLG0080046','1107000','1107000','0','1107000','1107000','kasir','2026-05-14 15:09:08','F22614030908');
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-05-14','F226140309081','2026-05-14','15:09:09','TIN','1107000','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-260514-0051','D','2026-05-14','15:09:09','kasir','PENJUALAN','F226140309081','9624425000','1107000','9625532000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1107000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140309081' 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 ('F226140309082','kasir',' 1',' MFE1 X CM ','TOKO','SMBK-E','E1F-ZEXE-86-0','CC X MODEL SLEP CM 10 8K ','','0.350','1','100.00','402000','0','0','15000','403000','0','0','0','403000','TIN','00402259','E1F','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZEXE-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='E1F-ZEXE-86-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 ('F226140309082','2026-05-14','0.350','2026-05-14','15:09:09','PLG0080047','403000','403000','0','403000','403000','kasir','2026-05-14 15:09:08','F22614030908');
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-05-14','F226140309082','2026-05-14','15:09:09','TIN','403000','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-260514-0052','D','2026-05-14','15:09:09','kasir','PENJUALAN','F226140309082','9625532000','403000','9625935000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='403000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140309082' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005351','X-00005351','GL X WG OVAL C GELOMBANG YT 54 8K','GR','---','PFG','BELI','BELI001','3267000','2026-05-14','3.130','1','kasir','2026-05-14 15:29:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-PFG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PFG','X-00005351','X-00005351');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260514-0001','F226300241271','RTA','1','BELI','BELI001','PFG', 'X-00005351', 'GL X WG OVAL C GELOMBANG YT 54 8K','3.130','3.130','100.00','3631000','3267000','1043770','1170000','1','3267000','3267000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.130',berat_beli_asli=berat_beli_asli+'3.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.130',berat_akhir_asli=berat_akhir_asli+'3.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PFG' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260514-0001','2026-05-14','2026-05-14','15:29:21','RTA','---','3.130','3267000','3267000','3267000','3267000','3267000','kasir','2026-05-14 15:29:22','FB-260514-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260514-0001','ERLINDA','PACITAN','','','','kasir','2026-05-14 15:29:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-14' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260514-0053','K','2026-05-14','15:29:21','kasir','PEMBELIAN UMUM','FB-260514-0001','9625935000','3267000','9622668000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260514-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260514-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140107501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140107502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107503' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107503' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140107503';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107504' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140107504' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140107504';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140110491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140110491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140110491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140147011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140147011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140147011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140147012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140147012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140147012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140147013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140147013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140147013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140148161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140148161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140148161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140238141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140238141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140238141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140243541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140243541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140243541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140251221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140251221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140251221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140309081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140309081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140309081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140309082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140309082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140309082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140847511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140847511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140847511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140918401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140918401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140918401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140919291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140919291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140919291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140924041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140924041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140924041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140957061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140957061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140957061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140958401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140958401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140958401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141000051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141000051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141000051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141001191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141001191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141001191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141002331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141002331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141002331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141004061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141004061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141004061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141005041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141005041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141005041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141018561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141018561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141018561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141019431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141019431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141019431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141021031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141021031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141021031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141021531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141021531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141021531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141022191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141022191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141022191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141035161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141035161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141035161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141035162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141035162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141035162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211143' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211143' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211143';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211144' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211144' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211144';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211145' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211145' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211145';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211146' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211146' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211146';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211147' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211147' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211147';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211148' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211148' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211148';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211149' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141211149' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141211149';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141212481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141212482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141212483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141212484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141212484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141242031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141242031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141242031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141242571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141242571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141242571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141243391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141243391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141243391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141250211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141250211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141250211';
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 ('F226140342471','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEXF-21-T','GL MODEL CAPELA VAR HW 8K ','','1.180','1','100.00','1333000','0','0','15000','1333000','0','0','0','1333000','RHM','T0079182','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F3E-ZEXF-21-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 ('F226140342471','2026-05-14','1.180','2026-05-14','15:42:47','PLG0080048','1333000','1333000','0','1333000','1333000','kasir','2026-05-14 15:42:47','F22614034247');
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-05-14','F226140342471','2026-05-14','15:42:47','RHM','1333000','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-260514-0054','D','2026-05-14','15:42:47','kasir','PENJUALAN','F226140342471','9622668000','1333000','9624001000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1333000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140342471' 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 ('F226140342472','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-3-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','0.320','1','100.00','374000','0','0','15000','374000','0','5000','0','379000','RHM','T0079155','D1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='D1G-ZEXB-3-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 ('F226140342472','2026-05-14','0.320','2026-05-14','15:42:47','PLG0080049','374000','374000','5000','379000','379000','kasir','2026-05-14 15:42:47','F22614034247');
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-05-14','F226140342472','2026-05-14','15:42:47','RHM','379000','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-260514-0055','D','2026-05-14','15:42:47','kasir','PENJUALAN','F226140342472','9624001000','379000','9624380000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='379000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140342472' 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 ('F226140403371','kasir','1',' MEF2 UB D5','TOKO','SMBK-F','F2E-ZAAG-40-T','GL PIPA MODEL MATA VAR UB D54 8K ','','3.050','1','100.00','3446000','0','0','15000','3447000','0','0','0','3447000','TJ','T0076634','F2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZAAG-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-05-14' AND kode_barang='F2E-ZAAG-40-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 ('F226140403371','2026-05-14','3.050','2026-05-14','16:03:37','PLG0080050','3447000','3447000','0','3447000','3447000','kasir','2026-05-14 16:03:37','F22614040337');
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-05-14','F226140403371','2026-05-14','16:03:37','TJ','3447000','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-260514-0056','D','2026-05-14','16:03:37','kasir','PENJUALAN','F226140403371','9624380000','3447000','9627827000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140342471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140342471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140342471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140342472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140342472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140342472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140403371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140403371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140403371';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-14';
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-05-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-14' 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-260515-0001','D','2026-05-15','16:22:46','SYSTEM','SALDO AWAL','SALDO AWAL','0','9627827000','9627827000');
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-260515-0001','D','2026-05-15','16:22:46','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-260515-0001','D','2026-05-15','16:22:46','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-260515-0001','D','2026-05-15','16:22:46','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-260515-0001','D','2026-05-15','16:22:46','','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-260515-0001','D','2026-05-15','16:22:46','BCA','SALDO AWAL','SALDO AWAL','0','4432433888','4432433888');
UPDATE tp_system SET tgl_system='2026-05-15';