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 ('F225040854491','kasir','1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJXD-3-T','KL SANTA MODEL HATI CAT MATA VAR HW 8K ','OL','2.210','1','100.00','2210000','0','0','15000','2232000','0','11000','0','2243000','NS','T0073817','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXD-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJXD-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225040854491','2025-11-04','2.210','2025-11-04','08:54:50','PLG0074385','2232000','2232000','11000','2243000','2243000','kasir','2025-11-04 08:54:49','F22504085449');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040854491','2025-11-04','08:54:50','NS','2243000','11000');
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-251104-0002','D','2025-11-04','08:54:50','kasir','PENJUALAN','F225040854491','2253971000','2243000','2256214000');
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 ('F225040901291','kasir','1',' TAA0 X DG ','TOKO','TBK-A','A0TA-YJBH-29-T','AT X JERSY POLOS DG 17K ','OL','1.010','1','100.00','1727000','0','0','15000','1735000','0','7000','0','1742000','TJ','T0074511','A0TA','0','0','-','0','1710000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YJBH-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A0TA-YJBH-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225040901291','2025-11-04','1.010','2025-11-04','09:01:30','PLG0074386','1735000','1735000','7000','1742000','1742000','kasir','2025-11-04 09:01:29','F22504090129');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040901291','2025-11-04','09:01:30','TJ','1742000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251104-0003','D','2025-11-04','09:01:30','kasir','PENJUALAN','F225040901291','2256214000','1742000','2257956000');
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 ('F225040901571','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YJCX-27-T','KL TRIXIE MODEL PITA KRAWANG VAR UB 8K ','OL','2.660','1','100.00','2660000','0','0','15000','2687000','0','13000','0','2700000','TJ','T0074731','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCX-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.660',berat_jual_asli=berat_jual_asli+'2.660',stock_jual='1',berat_akhir=berat_akhir-'2.660',berat_akhir_asli=berat_akhir_asli-'2.660',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJCX-27-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 ('F225040901571','2025-11-04','2.660','2025-11-04','09:01:58','PLG0074387','2687000','2687000','13000','2700000','2700000','kasir','2025-11-04 09:01:57','F22504090157');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040901571','2025-11-04','09:01:58','TJ','2700000','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-251104-0004','D','2025-11-04','09:01:58','kasir','PENJUALAN','F225040901571','2257956000','2700000','2260656000');
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 ('F225040934081','kasir','1',' MFF3 10K B','TOKO','SMBK-F','F3F-YJCA-18-T','GL TRIXIE MODEL DAUN PASIR VAR BG 8K','OL','1.420','1','100.00','1448000','0','0','15000','1460000','0','10000','0','1470000','RTA','T0074749','F3F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJCA-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3F-YJCA-18-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 ('F225040934081','2025-11-04','1.420','2025-11-04','09:34:09','PLG0074388','1460000','1460000','10000','1470000','1470000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934081','2025-11-04','09:34:09','RTA','1470000','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-251104-0005','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934081','2260656000','1470000','2262126000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1470000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934081' 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 ('F225040934082','kasir',' 1',' MEH1 15K Y','TOKO','SMBK-H','H1E-YJBI-56-T','KL NORY ANAK BONEKA CAT VAR YT 8K ','OL','1.850','1','100.00','1850000','0','0','15000','1863000','0','15000','0','1878000','RTA','T0074616','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBI-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJBI-56-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 ('F225040934082','2025-11-04','1.850','2025-11-04','09:34:09','PLG0074389','1863000','1863000','15000','1878000','1878000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934082','2025-11-04','09:34:09','RTA','1878000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0006','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934082','2262126000','1878000','2264004000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1878000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934082' 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 ('F225040934083','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJBI-3-T','KL SANTA MODEL BUNGA CLOVER CAT HW 8K ','OL','2.140','1','100.00','2140000','0','0','15000','2161000','0','11000','0','2172000','RTA','T0074563','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBI-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJBI-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225040934083','2025-11-04','2.140','2025-11-04','09:34:09','PLG0074390','2161000','2161000','11000','2172000','2172000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934083','2025-11-04','09:34:09','RTA','2172000','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-251104-0007','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934083','2264004000','2172000','2266176000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2172000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934083' 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 ('F225040934084','kasir',' 1',' MDE2 HW 17','TOKO','SMBK-E','E2D-YJBE-9-T','CC COR MODEL PAKU MATA HW 8K ','OL','1.080','1','100.00','1058000','0','0','15000','1091000','0','5000','0','1096000','RTA','T0074482','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBE-9-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='2025-11-04' AND kode_barang='E2D-YJBE-9-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 ('F225040934084','2025-11-04','1.080','2025-11-04','09:34:09','PLG0074391','1091000','1091000','5000','1096000','1096000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934084','2025-11-04','09:34:09','RTA','1096000','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-251104-0008','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934084','2266176000','1096000','2267272000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1096000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934084' 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 ('F225040934085','kasir',' 1',' MDE2 HW 13','TOKO','SMBK-E','E2D-YJBE-4-T','CC COR MODEL PAKU MATA HW 8K ','OL','1.040','1','100.00','1019000','0','0','15000','1051000','0','5000','0','1056000','RTA','T0074477','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBE-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2D-YJBE-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225040934085','2025-11-04','1.040','2025-11-04','09:34:09','PLG0074392','1051000','1051000','5000','1056000','1056000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934085','2025-11-04','09:34:09','RTA','1056000','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-251104-0009','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934085','2267272000','1056000','2268328000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1056000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934085' 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 ('F225040934086','kasir',' 1',' MDE2 HW 15','TOKO','SMBK-E','E2D-YJBE-7-T','CC COR MODEL PAKU MATA HW 8K ','OL','1.080','1','100.00','1058000','0','0','15000','1091000','0','5000','0','1096000','RTA','T0074480','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBE-7-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='2025-11-04' AND kode_barang='E2D-YJBE-7-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 ('F225040934086','2025-11-04','1.080','2025-11-04','09:34:09','PLG0074393','1091000','1091000','5000','1096000','1096000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934086','2025-11-04','09:34:09','RTA','1096000','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-251104-0010','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934086','2268328000','1096000','2269424000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1096000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934086' 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 ('F225040934087','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YJBC-81-0','CC X MODEL MATA HITAM CM 14 8K ','OL','0.740','1','100.00','740000','0','0','15000','751000','0','5000','0','756000','RTA','00374399','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBC-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2E-YJBC-81-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 ('F225040934087','2025-11-04','0.740','2025-11-04','09:34:09','PLG0074394','751000','751000','5000','756000','756000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934087','2025-11-04','09:34:09','RTA','756000','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-251104-0011','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934087','2269424000','756000','2270180000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='756000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934087' 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 ('F225040934088','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJBC-78-0','CC X MODEL MATA CM 12 8K ','OL','1.080','1','100.00','1058000','0','0','15000','1091000','0','5000','0','1096000','RTA','00374396','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-78-0' 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='2025-11-04' AND kode_barang='E2D-YJBC-78-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 ('F225040934088','2025-11-04','1.080','2025-11-04','09:34:09','PLG0074395','1091000','1091000','5000','1096000','1096000','kasir','2025-11-04 09:34:08','F22504093408');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040934088','2025-11-04','09:34:09','RTA','1096000','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-251104-0012','D','2025-11-04','09:34:09','kasir','PENJUALAN','F225040934088','2270180000','1096000','2271276000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1096000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040934088' 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 ('F225040936391','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJBC-99-0','CC X MODEL LISTEING MATA CM 14 8K ','OL','0.800','1','100.00','784000','0','0','15000','812000','0','5000','0','817000','RTA','00374417','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2D-YJBC-99-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 ('F225040936391','2025-11-04','0.800','2025-11-04','09:36:39','PLG0074396','812000','812000','5000','817000','817000','kasir','2025-11-04 09:36:39','F22504093639');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040936391','2025-11-04','09:36:39','RTA','817000','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-251104-0013','D','2025-11-04','09:36:39','kasir','PENJUALAN','F225040936391','2271276000','817000','2272093000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='817000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040936391' 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 ('F225040936392','kasir',' 1',' MEE1 AY 17','TOKO','SMBK-E','E1E-YHXG-13-T','CC MODEL PITA VAR AY 17 8K ','OL','0.610','1','100.00','610000','0','0','15000','620000','0','5000','0','625000','RTA','T0072000','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXG-13-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='2025-11-04' AND kode_barang='E1E-YHXG-13-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 ('F225040936392','2025-11-04','0.610','2025-11-04','09:36:39','PLG0074397','620000','620000','5000','625000','625000','kasir','2025-11-04 09:36:39','F22504093639');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040936392','2025-11-04','09:36:39','RTA','625000','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-251104-0014','D','2025-11-04','09:36:39','kasir','PENJUALAN','F225040936392','2272093000','625000','2272718000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='625000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040936392' 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 ('F225040936393','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-YJAH-93-T','LT CHARM BALOK HURUF A BG 8K ','OL','0.550','1','100.00','561000','0','0','15000','570000','0','5000','0','575000','RTA','T0074306','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAH-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1F-YJAH-93-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 ('F225040936393','2025-11-04','0.550','2025-11-04','09:36:39','PLG0074398','570000','570000','5000','575000','575000','kasir','2025-11-04 09:36:39','F22504093639');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040936393','2025-11-04','09:36:39','RTA','575000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0015','D','2025-11-04','09:36:39','kasir','PENJUALAN','F225040936393','2272718000','575000','2273293000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040936393' 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 ('F225040936394','kasir',' 1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAH-86-T','LT FINE GOLD LG 8K ','OL','0.500','1','100.00','500000','0','0','15000','508000','0','5000','0','513000','RTA','T0074299','D1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAH-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1E-YJAH-86-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 ('F225040936394','2025-11-04','0.500','2025-11-04','09:36:39','PLG0074399','508000','508000','5000','513000','513000','kasir','2025-11-04 09:36:39','F22504093639');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040936394','2025-11-04','09:36:39','RTA','513000','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-251104-0016','D','2025-11-04','09:36:39','kasir','PENJUALAN','F225040936394','2273293000','513000','2273806000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040936394' 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 ('F225040936395','kasir',' 1',' MEB1E BW ','TOKO','SMBK-B','B1E-YJBA-41-T','GW TUSUK MODEL BUNGA BW 8K ','OL','0.450','1','100.00','450000','0','0','15000','457000','0','5000','0','462000','RTA','T0074362','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBA-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YJBA-41-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 ('F225040936395','2025-11-04','0.450','2025-11-04','09:36:39','PLG0074400','457000','457000','5000','462000','462000','kasir','2025-11-04 09:36:39','F22504093639');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040936395','2025-11-04','09:36:39','RTA','462000','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-251104-0017','D','2025-11-04','09:36:39','kasir','PENJUALAN','F225040936395','2273806000','462000','2274268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040936395' 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 ('F225041005231','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-YIBB-12-T','CC WEDDING MATA CM 12 8K ','','1.700','1','100.00','1666000','0','0','15000','1666000','0','10000','0','1676000','TIN','T0073148','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-12-T' 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='2025-11-04' AND kode_barang='E2D-YIBB-12-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 ('F225041005231','2025-11-04','1.700','2025-11-04','10:05:24','PLG0074401','1666000','1666000','10000','1676000','1676000','kasir','2025-11-04 10:05:23','F22504100523');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041005231','2025-11-04','10:05:24','TIN','1676000','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-251104-0018','D','2025-11-04','10:05:24','kasir','PENJUALAN','F225041005231','2274268000','1676000','2275944000');
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 ('F225041005551','kasir','1',' MCB0 DG ','TOKO','SMBK-B','B0C-YKXC-24-T','GW TUSUK MRICAN POLOS DG 8K ','','0.500','1','100.00','480000','0','0','15000','480000','0','0','0','480000','NS','T0074937','B0C','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-YKXC-24-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='2025-11-04' AND kode_barang='B0C-YKXC-24-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 ('F225041005551','2025-11-04','0.500','2025-11-04','10:05:55','PLG0074402','480000','480000','0','480000','480000','kasir','2025-11-04 10:05:55','F22504100555');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041005551','2025-11-04','10:05:55','NS','480000','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-251104-0019','D','2025-11-04','10:05:55','kasir','PENJUALAN','F225041005551','2275944000','480000','2276424000');
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 ('F225041008471','kasir','1',' MFH1F KH 4','TOKO','SMBK-H','H1F-YJBD-106-T','KL KOREA KH 44CM 8K ','','3.080','1','100.00','3142000','0','0','15000','3142000','0','0','0','3142000','TJ','T0074456','H1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBD-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1F-YJBD-106-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 ('F225041008471','2025-11-04','3.080','2025-11-04','10:08:48','PLG0074403','3142000','3142000','0','3142000','3142000','kasir','2025-11-04 10:08:47','F22504100847');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041008471','2025-11-04','10:08:48','TJ','3142000','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-251104-0020','D','2025-11-04','10:08:48','kasir','PENJUALAN','F225041008471','2276424000','3142000','2279566000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3142000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041008471' 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 ('F225041008472','kasir',' 1',' MDE1 BW 23','TOKO','SMBK-E','E1D-YBXD-7-T','CC BANGKOK SLEP VAR BW 23 8K ','','1.080','1','100.00','1058000','0','0','15000','1058000','0','0','0','1058000','TJ','T0066509','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YBXD-7-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='2025-11-04' AND kode_barang='E1D-YBXD-7-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 ('F225041008472','2025-11-04','1.080','2025-11-04','10:08:48','PLG0074404','1058000','1058000','0','1058000','1058000','kasir','2025-11-04 10:08:47','F22504100847');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041008472','2025-11-04','10:08:48','TJ','1058000','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-251104-0021','D','2025-11-04','10:08:48','kasir','PENJUALAN','F225041008472','2279566000','1058000','2280624000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1058000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041008472' 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 ('F225041008473','kasir',' 1',' MEF1 UB D6','TOKO','SMBK-F','F1E-YEAG-14-T','GL OVAL MODEL C UB D65 8K ','','2.560','1','100.00','2560000','0','0','15000','2560000','0','0','0','2560000','TJ','T0069333','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YEAG-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F1E-YEAG-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 ('F225041008473','2025-11-04','2.560','2025-11-04','10:08:48','PLG0074405','2560000','2560000','0','2560000','2560000','kasir','2025-11-04 10:08:47','F22504100847');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041008473','2025-11-04','10:08:48','TJ','2560000','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-251104-0022','D','2025-11-04','10:08:48','kasir','PENJUALAN','F225041008473','2280624000','2560000','2283184000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2560000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041008473' 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 ('F225041011071','kasir','1',' MEE2 LG 11','TOKO','SMBK-E','E2E-YIXH-38-T','CC MODEL MATA VAR LG 11 8K ','OL','0.560','1','100.00','560000','0','0','15000','568000','0','5000','0','573000','NS','T0073047','E2E','0','0','-','0','1000000');
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 ('F225041011311','kasir','1',' MEE2 LG 11','TOKO','SMBK-E','E2E-YIXH-38-T','CC MODEL MATA VAR LG 11 8K ','OL','0.560','1','100.00','560000','0','0','15000','568000','0','5000','0','573000','NS','T0073047','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXH-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2E-YIXH-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041011311','2025-11-04','0.560','2025-11-04','10:11:32','PLG0074407','568000','568000','5000','573000','573000','kasir','2025-11-04 10:11:31','F22504101131');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041011311','2025-11-04','10:11:32','NS','573000','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-251104-0023','D','2025-11-04','10:11:32','kasir','PENJUALAN','F225041011311','2283184000','573000','2283757000');
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 ('F225041020251','kasir','1',' TAA0 DW ','TOKO','TBK-A','A0TA-UDXI-133-T','AT MODEL HATI DW ','','1.000','1','100.00','1710000','0','0','15000','1710000','0','0','0','1710000','RHM','T0003628','A0TA','0','0','-','0','1710000');
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 ('F225041022481','kasir','1',' TAA0 DW ','TOKO','TBK-A','A0TA-UDXI-133-T','AT MODEL HATI DW ','','1.000','1','100.00','1710000','0','0','15000','1710000','0','0','0','1710000','RHM','T0003628','A0TA','0','0','-','0','1710000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-UDXI-133-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='2025-11-04' AND kode_barang='A0TA-UDXI-133-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041022481','2025-11-04','1.000','2025-11-04','10:22:49','PLG0074409','1710000','1710000','0','1710000','1710000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022481','2025-11-04','10:22:49','RHM','1710000','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-251104-0024','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022481','2283757000','1710000','2285467000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1710000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022481' 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 ('F225041022482','kasir',' 1',' TEA1 X OR ','TOKO','TBK-A','A1TE-YDAH-2-T','AT X KLIP BANGKOK PASIR SLEP OR 17K ','','2.020','1','100.00','3656000','0','0','15000','3656000','0','0','0','3656000','RHM','T0068688','A1TE','0','0','-','0','1810000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YDAH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1TE-YDAH-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041022482','2025-11-04','2.020','2025-11-04','10:22:49','PLG0074410','3656000','3656000','0','3656000','3656000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022482','2025-11-04','10:22:49','RHM','3656000','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-251104-0025','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022482','2285467000','3656000','2289123000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022482' 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 ('F225041022483','kasir',' 1',' TDD1 X MJ ','TOKO','TBK-D','D1TD-YFBF-60-T','LT X MODEL KRAWANG SLEP VAR MJ 17K ','','2.100','1','100.00','3759000','0','0','15000','3760000','0','0','0','3760000','RHM','T0070427','D1TD','0','0','-','0','1790000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TD-YFBF-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1TD-YFBF-60-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225041022483','2025-11-04','2.100','2025-11-04','10:22:49','PLG0074411','3760000','3760000','0','3760000','3760000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022483','2025-11-04','10:22:49','RHM','3760000','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-251104-0026','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022483','2289123000','3760000','2292883000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3760000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022483' 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 ('F225041022484','kasir',' 1',' TGH1 HW 44','TOKO','TBK-H','H1TG-WKBC-10-T','KL MILANO HW 44CM ','','8.130','1','100.00','15041000','0','0','15000','15040000','0','0','0','15040000','RHM','T0050846','H1TG','0','0','-','1','1850000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TG-WKBC-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.130',berat_jual_asli=berat_jual_asli+'8.130',stock_jual='1',berat_akhir=berat_akhir-'8.130',berat_akhir_asli=berat_akhir_asli-'8.130',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1TG-WKBC-10-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 ('F225041022484','2025-11-04','8.130','2025-11-04','10:22:49','PLG0074412','15040000','15040000','0','15040000','15040000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022484','2025-11-04','10:22:49','RHM','15040000','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-251104-0027','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022484','2292883000','15040000','2307923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='15040000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022484' 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 ('F225041022485','kasir',' 1',' TFF3 47K B','TOKO','TBK-F','F3TF-YJBH-73-T','GL KREPYAK MODEL PASIR VAR BG 17K ','','6.700','1','100.00','12261000','0','0','15000','12261000','0','47000','0','12308000','RHM','T0074555','F3TF','0','0','-','0','1830000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YJBH-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.700',berat_jual_asli=berat_jual_asli+'6.700',stock_jual='1',berat_akhir=berat_akhir-'6.700',berat_akhir_asli=berat_akhir_asli-'6.700',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3TF-YJBH-73-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 ('F225041022485','2025-11-04','6.700','2025-11-04','10:22:49','PLG0074413','12261000','12261000','47000','12308000','12308000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022485','2025-11-04','10:22:49','RHM','12308000','47000');
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-251104-0028','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022485','2307923000','12308000','2320231000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='12308000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022485' 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 ('F225041022486','kasir',' 1',' TEE2 X BM ','TOKO','TBK-E','E2TE-VAAB-36-T','CC X MODEL MATA BIRU BM 18 ','','7.830','1','100.00','14172000','0','0','15000','14172000','0','20000','0','14192000','RHM','T0026743','E2TE','0','0','-','0','1810000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-VAAB-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.830',berat_jual_asli=berat_jual_asli+'7.830',stock_jual='1',berat_akhir=berat_akhir-'7.830',berat_akhir_asli=berat_akhir_asli-'7.830',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2TE-VAAB-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041022486','2025-11-04','7.830','2025-11-04','10:22:49','PLG0074414','14172000','14172000','20000','14192000','14192000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022486','2025-11-04','10:22:49','RHM','14192000','20000');
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-251104-0029','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022486','2320231000','14192000','2334423000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='14192000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022486' 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 ('F225041022487','kasir',' 1',' TAE0 X DG ','TOKO','TBK-E','E0TA-YJBH-48-T','CC X WARU DG 20 17K ','','1.970','1','100.00','3369000','0','0','15000','3369000','0','0','0','3369000','RHM','T0074530','E0TA','0','0','-','0','1710000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-YJBH-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E0TA-YJBH-48-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 ('F225041022487','2025-11-04','1.970','2025-11-04','10:22:49','PLG0074415','3369000','3369000','0','3369000','3369000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022487','2025-11-04','10:22:49','RHM','3369000','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-251104-0030','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022487','2334423000','3369000','2337792000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3369000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022487' 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 ('F225041022488','kasir',' 1',' TFB1 7K BG','TOKO','TBK-B','B1TF-YJXF-127-T','GW TUSUK KUPU PASIR BG PE 17K ','','0.770','1','100.00','1409000','0','0','15000','1409000','0','7000','0','1416000','RHM','T0074025','B1TF','0','0','-','0','1830000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-YJXF-127-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1TF-YJXF-127-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041022488','2025-11-04','0.770','2025-11-04','10:22:49','PLG0074416','1409000','1409000','7000','1416000','1416000','kasir','2025-11-04 10:22:48','F22504102248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041022488','2025-11-04','10:22:49','RHM','1416000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0031','D','2025-11-04','10:22:49','kasir','PENJUALAN','F225041022488','2337792000','1416000','2339208000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1416000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041022488' 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 ('F225041031511','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YGAH-161-T','GL MODEL FLIK UB 8K ','OL','1.410','1','100.00','1410000','0','0','15000','1424000','0','7000','0','1431000','RTA','T0071192','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGAH-161-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YGAH-161-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 ('F225041031511','2025-11-04','1.410','2025-11-04','10:31:51','PLG0074417','1424000','1424000','7000','1431000','1431000','kasir','2025-11-04 10:31:51','F22504103151');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041031511','2025-11-04','10:31:51','RTA','1431000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0032','D','2025-11-04','10:31:51','kasir','PENJUALAN','F225041031511','2339208000','1431000','2340639000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1431000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041031511' 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 ('F225041031512','kasir',' 1',' MFF3 10K B','TOKO','SMBK-F','F3F-YJCA-20-T','GL TRIXIE MODEL DAUN PASIR VAR BG 8K ','OL','1.540','1','100.00','1571000','0','0','15000','1585000','0','10000','0','1595000','RTA','T0074751','F3F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJCA-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3F-YJCA-20-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 ('F225041031512','2025-11-04','1.540','2025-11-04','10:31:51','PLG0074418','1585000','1585000','10000','1595000','1595000','kasir','2025-11-04 10:31:51','F22504103151');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041031512','2025-11-04','10:31:51','RTA','1595000','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-251104-0033','D','2025-11-04','10:31:51','kasir','PENJUALAN','F225041031512','2340639000','1595000','2342234000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041031512' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041031511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041031511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041031511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041031512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041031512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041031512';
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 ('F225041048441','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-YJBD-104-T','KL HOLLOW KH 44CM 8K ','OL','2.080','1','100.00','2080000','0','0','15000','2102000','0','10000','0','2112000','NS','T0074454','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBD-104-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJBD-104-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 ('F225041048441','2025-11-04','2.080','2025-11-04','10:48:45','PLG0074419','2102000','2102000','10000','2112000','2112000','kasir','2025-11-04 10:48:44','F22504104844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041048441','2025-11-04','10:48:45','NS','2112000','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-251104-0034','D','2025-11-04','10:48:45','kasir','PENJUALAN','F225041048441','2342234000','2112000','2344346000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2112000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041048441' 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 ('F225041048442','kasir',' 1',' MED1E 5K L','TOKO','SMBK-D','D1E-YJBC-23-T','LT MODEL FINE GOLD LG 8K ','OL','0.550','1','100.00','550000','0','0','15000','558000','0','5000','0','563000','NS','T0074396','D1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJBC-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1E-YJBC-23-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 ('F225041048442','2025-11-04','0.550','2025-11-04','10:48:45','PLG0074420','558000','558000','5000','563000','563000','kasir','2025-11-04 10:48:44','F22504104844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041048442','2025-11-04','10:48:45','NS','563000','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-251104-0035','D','2025-11-04','10:48:45','kasir','PENJUALAN','F225041048442','2344346000','563000','2344909000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='563000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041048442' 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 ('F225041056141','kasir','1',' MEA1E UB ','TOKO','SMBK-A','A1E-YJBC-44-T','AT KLIP SLEP UB 8K ','','0.720','1','100.00','720000','0','0','15000','720000','0','0','0','720000','RTA','T0074417','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBC-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1E-YJBC-44-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 ('F225041056141','2025-11-04','0.720','2025-11-04','10:56:14','PLG0074421','720000','720000','0','720000','720000','kasir','2025-11-04 10:56:14','F22504105614');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041056141','2025-11-04','10:56:14','RTA','720000','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-251104-0036','D','2025-11-04','10:56:14','kasir','PENJUALAN','F225041056141','2344909000','720000','2345629000');
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 ('F225041059061','kasir','1',' MCB0 X DG ','TOKO','SMBK-B','B0C-YJXD-154-0','GW X MRICAN DG 8K ','','0.530','1','100.00','497000','0','0','15000','510000','0','0','0','510000','NS','00372134','B0C','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-YJXD-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B0C-YJXD-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041059061','2025-11-04','0.530','2025-11-04','10:59:07','PLG0074422','510000','510000','0','510000','510000','kasir','2025-11-04 10:59:06','F22504105906');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041059061','2025-11-04','10:59:07','NS','510000','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-251104-0037','D','2025-11-04','10:59:07','kasir','PENJUALAN','F225041059061','2345629000','510000','2346139000');
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 ('F225041120421','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YJCA-50-T','LT SLOBOK HATI PASIR BG 8K ','','0.400','1','100.00','408000','0','0','15000','415000','0','5000','0','420000','TJ','T0074781','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJCA-50-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='2025-11-04' AND kode_barang='D1F-YJCA-50-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 ('F225041120421','2025-11-04','0.400','2025-11-04','11:20:43','PLG0074423','415000','415000','5000','420000','420000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120421','2025-11-04','11:20:43','TJ','420000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0038','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120421','2346139000','420000','2346559000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120421' 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 ('F225041120422','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YJCA-49-T','LT SLOBOK HATI PASIR BG 8K ','OL','0.570','1','100.00','581000','0','0','15000','590000','0','5000','0','595000','TJ','T0074780','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJCA-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1F-YJCA-49-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 ('F225041120422','2025-11-04','0.570','2025-11-04','11:20:43','PLG0074424','590000','590000','5000','595000','595000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120422','2025-11-04','11:20:43','TJ','595000','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-251104-0039','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120422','2346559000','595000','2347154000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120422' 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 ('F225041120423','kasir',' 1',' MGD1 5K HW','TOKO','SMBK-D','D1G-YJAF-82-T','LT MODEL CAT HW 8K ','OL','0.350','1','100.00','364000','0','0','15000','369000','0','5000','0','374000','TJ','T0074208','D1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJAF-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1G-YJAF-82-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 ('F225041120423','2025-11-04','0.350','2025-11-04','11:20:43','PLG0074425','369000','369000','5000','374000','374000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120423','2025-11-04','11:20:43','TJ','374000','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-251104-0040','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120423','2347154000','374000','2347528000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='374000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120423' 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 ('F225041120424','kasir',' 1',' MFD1 UB ','TOKO','SMBK-D','D1F-YJBI-116-T','LT MODEL BOLA ARESO UB 8K ','OL','0.510','1','100.00','520000','0','0','15000','528000','0','5000','0','533000','TJ','T0074676','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJBI-116-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D1F-YJBI-116-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 ('F225041120424','2025-11-04','0.510','2025-11-04','11:20:43','PLG0074426','528000','528000','5000','533000','533000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120424','2025-11-04','11:20:43','TJ','533000','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-251104-0041','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120424','2347528000','533000','2348061000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120424' 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 ('F225041120425','kasir',' 1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAH-89-T','LT FINE GOLD LG 8K ','OL','0.520','1','100.00','520000','0','0','15000','528000','0','5000','0','533000','TJ','T0074302','D1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAH-89-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='2025-11-04' AND kode_barang='D1E-YJAH-89-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 ('F225041120425','2025-11-04','0.520','2025-11-04','11:20:43','PLG0074427','528000','528000','5000','533000','533000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120425','2025-11-04','11:20:43','TJ','533000','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-251104-0042','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120425','2348061000','533000','2348594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120425' 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 ('F225041120426','kasir',' 1',' MEE1E HW 1','TOKO','SMBK-E','E1E-YJBC-5-T','CC MODEL DAUN SLEP HW 13 8K ','OL','0.510','1','100.00','510000','0','0','15000','518000','0','5000','0','523000','TJ','T0074378','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBC-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E1E-YJBC-5-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 ('F225041120426','2025-11-04','0.510','2025-11-04','11:20:43','PLG0074428','518000','518000','5000','523000','523000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120426','2025-11-04','11:20:43','TJ','523000','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-251104-0043','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120426','2348594000','523000','2349117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120426' 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 ('F225041120427','kasir',' 1',' MEE1 LG 12','TOKO','SMBK-E','E1E-YJXF-37-T','CC MODEL DAUN VAR LG 12 8K ','OL','0.450','1','100.00','450000','0','0','15000','457000','0','5000','0','462000','TJ','T0073935','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJXF-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E1E-YJXF-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041120427','2025-11-04','0.450','2025-11-04','11:20:43','PLG0074429','457000','457000','5000','462000','462000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120427','2025-11-04','11:20:43','TJ','462000','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-251104-0044','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120427','2349117000','462000','2349579000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120427' 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 ('F225041120428','kasir',' 1',' MDE1 CM 16','TOKO','SMBK-E','E1D-YJBI-77-T','CC MODEL KEPANG VAR CM 16 8K ','OL','1.330','1','100.00','1303000','0','0','15000','1343000','0','7000','0','1350000','TJ','T0074637','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBI-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E1D-YJBI-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041120428','2025-11-04','1.330','2025-11-04','11:20:43','PLG0074430','1343000','1343000','7000','1350000','1350000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120428','2025-11-04','11:20:43','TJ','1350000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0045','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120428','2349579000','1350000','2350929000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120428' 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 ('F225041120429','kasir',' 1',' MDE2 HW 17','TOKO','SMBK-E','E2D-YJBI-58-T','CC MODEL PAKU MATA VAR HW 17 8K ','OL','1.120','1','100.00','1098000','0','0','15000','1131000','0','6000','0','1137000','TJ','T0074618','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBI-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2D-YJBI-58-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 ('F225041120429','2025-11-04','1.120','2025-11-04','11:20:43','PLG0074431','1131000','1131000','6000','1137000','1137000','kasir','2025-11-04 11:20:42','F22504112042');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041120429','2025-11-04','11:20:43','TJ','1137000','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-251104-0046','D','2025-11-04','11:20:43','kasir','PENJUALAN','F225041120429','2350929000','1137000','2352066000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1137000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041120429' 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 ('F225041123341','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YJXB-50-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.470','1','100.00','470000','0','0','15000','477000','0','5000','0','482000','RHM','T0073630','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXB-50-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='2025-11-04' AND kode_barang='B1E-YJXB-50-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 ('F225041123341','2025-11-04','0.470','2025-11-04','11:23:34','PLG0074432','477000','477000','5000','482000','482000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123341','2025-11-04','11:23:34','RHM','482000','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-251104-0047','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123341','2352066000','482000','2352548000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='482000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123341' 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 ('F225041123342','kasir',' 1',' MEB1E X LG','TOKO','SMBK-B','B1E-YJBA-102-0','GW X MODEL SLEP LG PE 8K ','OL','0.480','1','100.00','480000','0','0','15000','487000','0','5000','0','492000','RHM','00373979','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBA-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YJBA-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041123342','2025-11-04','0.480','2025-11-04','11:23:34','PLG0074433','487000','487000','5000','492000','492000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123342','2025-11-04','11:23:34','RHM','492000','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-251104-0048','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123342','2352548000','492000','2353040000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='492000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123342' 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 ('F225041123343','kasir',' 1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YJBI-41-T','GW TUSUK MODEL VAR CM PE 8K ','OL','0.780','1','100.00','780000','0','0','15000','792000','0','5000','0','797000','RHM','T0074601','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBI-41-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='2025-11-04' AND kode_barang='B1E-YJBI-41-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 ('F225041123343','2025-11-04','0.780','2025-11-04','11:23:34','PLG0074434','792000','792000','5000','797000','797000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123343','2025-11-04','11:23:34','RHM','797000','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-251104-0049','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123343','2353040000','797000','2353837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='797000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123343' 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 ('F225041123344','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-YJCA-46-T','GW TRIXIE PANJANG MODEL MATA VAR LG 8K ','OL','0.550','1','100.00','550000','0','0','15000','558000','0','5000','0','563000','RHM','T0074777','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJCA-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YJCA-46-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 ('F225041123344','2025-11-04','0.550','2025-11-04','11:23:34','PLG0074435','558000','558000','5000','563000','563000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123344','2025-11-04','11:23:34','RHM','563000','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-251104-0050','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123344','2353837000','563000','2354400000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='563000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123344' 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 ('F225041123345','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-YJBI-14-T','GW TRIXIE PANJANG PITA MATA LG 8K ','OL','0.560','1','100.00','560000','0','0','15000','568000','0','5000','0','573000','RHM','T0074574','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBI-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YJBI-14-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 ('F225041123345','2025-11-04','0.560','2025-11-04','11:23:34','PLG0074436','568000','568000','5000','573000','573000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123345','2025-11-04','11:23:34','RHM','573000','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-251104-0051','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123345','2354400000','573000','2354973000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123345' 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 ('F225041123346','kasir',' 1',' MEA1E X LG','TOKO','SMBK-A','A1E-YJBA-92-0','AT X GYPSY ANAK SLEP LG 8K ','OL','0.500','1','100.00','500000','0','0','15000','508000','0','5000','0','513000','RHM','00373969','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBA-92-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='2025-11-04' AND kode_barang='A1E-YJBA-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041123346','2025-11-04','0.500','2025-11-04','11:23:34','PLG0074437','508000','508000','5000','513000','513000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123346','2025-11-04','11:23:34','RHM','513000','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-251104-0052','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123346','2354973000','513000','2355486000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123346' 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 ('F225041123347','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YJCX-8-T','GL RANTAI HOLLOW FLIK VAR HW 8K ','OL','1.300','1','100.00','1300000','0','0','15000','1313000','0','7000','0','1320000','RHM','T0074712','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCX-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YJCX-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 ('F225041123347','2025-11-04','1.300','2025-11-04','11:23:34','PLG0074438','1313000','1313000','7000','1320000','1320000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123347','2025-11-04','11:23:34','RHM','1320000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0053','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123347','2355486000','1320000','2356806000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1320000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123347' 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 ('F225041123348','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YJCX-10-T','GL RANTAI HOLLOW FLIK VAR HW 8K ','OL','1.350','1','100.00','1350000','0','0','15000','1363000','0','7000','0','1370000','RHM','T0074714','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCX-10-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='2025-11-04' AND kode_barang='F3E-YJCX-10-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 ('F225041123348','2025-11-04','1.350','2025-11-04','11:23:34','PLG0074439','1363000','1363000','7000','1370000','1370000','kasir','2025-11-04 11:23:34','F22504112334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041123348','2025-11-04','11:23:34','RHM','1370000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0054','D','2025-11-04','11:23:34','kasir','PENJUALAN','F225041123348','2356806000','1370000','2358176000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1370000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041123348' 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 ('F225041125531','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-YJCA-24-T','KL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL ','2.020','1','100.00','2020000','0','0','15000','2040000','0','10000','0','2050000','RHM','T0074755','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJCA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041125531','2025-11-04','2.020','2025-11-04','11:25:54','PLG0074440','2040000','2040000','10000','2050000','2050000','kasir','2025-11-04 11:25:53','F22504112553');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041125531','2025-11-04','11:25:54','RHM','2050000','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-251104-0055','D','2025-11-04','11:25:54','kasir','PENJUALAN','F225041125531','2358176000','2050000','2360226000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041125531' 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 ('F225041125532','kasir',' 1',' MFH1F UB 4','TOKO','SMBK-H','H1F-YJBD-121-T','KL KOREA UB 46CM 8K ','OL ','0.980','1','100.00','1000000','0','0','15000','1009000','0','5000','0','1014000','RHM','T0074471','H1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBD-121-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='2025-11-04' AND kode_barang='H1F-YJBD-121-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 ('F225041125532','2025-11-04','0.980','2025-11-04','11:25:54','PLG0074441','1009000','1009000','5000','1014000','1014000','kasir','2025-11-04 11:25:53','F22504112553');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041125532','2025-11-04','11:25:54','RHM','1014000','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-251104-0056','D','2025-11-04','11:25:54','kasir','PENJUALAN','F225041125532','2360226000','1014000','2361240000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1014000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041125532' 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 ('F225041125533','kasir',' 1',' MJH2J KH 4','TOKO','SMBK-H','H2J-YJAF-27-T','KL SIEM COBRA KH 42 9K ','OL ','1.320','1','100.00','1452000','0','0','15000','1465000','0','7000','0','1472000','RHM','T0074153','H2J','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJAF-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H2J-YJAF-27-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 ('F225041125533','2025-11-04','1.320','2025-11-04','11:25:54','PLG0074442','1465000','1465000','7000','1472000','1472000','kasir','2025-11-04 11:25:53','F22504112553');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041125533','2025-11-04','11:25:54','RHM','1472000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251104-0057','D','2025-11-04','11:25:54','kasir','PENJUALAN','F225041125533','2361240000','1472000','2362712000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1472000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041125533' 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 ('F225041125534','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-YJAF-40-T','KL JEDAR UB 42 8K ','OL ','0.990','1','100.00','990000','0','0','15000','1000000','0','5000','0','1005000','RHM','T0074166','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJAF-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.990',berat_jual_asli=berat_jual_asli+'0.990',stock_jual='1',berat_akhir=berat_akhir-'0.990',berat_akhir_asli=berat_akhir_asli-'0.990',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJAF-40-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 ('F225041125534','2025-11-04','0.990','2025-11-04','11:25:54','PLG0074443','1000000','1000000','5000','1005000','1005000','kasir','2025-11-04 11:25:53','F22504112553');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041125534','2025-11-04','11:25:54','RHM','1005000','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-251104-0058','D','2025-11-04','11:25:54','kasir','PENJUALAN','F225041125534','2362712000','1005000','2363717000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1005000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041125534' 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 ('F225041128151','kasir','1',' MGE1 HW 15','TOKO','SMBK-E','E1G-YKXA-9-T','CC LISTRING GELOMBANG SLEP HW 15 8K ','OL ','0.380','1','100.00','395000','0','0','15000','401000','0','5000','0','406000','RHM','T0074804','E1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E1G-YKXA-9-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 ('F225041128151','2025-11-04','0.380','2025-11-04','11:28:16','PLG0074444','401000','401000','5000','406000','406000','kasir','2025-11-04 11:28:15','F22504112815');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041128151','2025-11-04','11:28:16','RHM','406000','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-251104-0059','D','2025-11-04','11:28:16','kasir','PENJUALAN','F225041128151','2363717000','406000','2364123000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041128151' 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 ('F225041128152','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YJAH-98-T','LT CHARM BALOK HURUF J BG 8K ','OL ','0.420','1','100.00','428000','0','0','15000','435000','0','5000','0','440000','RHM','T0074311','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAH-98-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='2025-11-04' AND kode_barang='D1F-YJAH-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041128152','2025-11-04','0.420','2025-11-04','11:28:16','PLG0074445','435000','435000','5000','440000','440000','kasir','2025-11-04 11:28:15','F22504112815');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041128152','2025-11-04','11:28:16','RHM','440000','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-251104-0060','D','2025-11-04','11:28:16','kasir','PENJUALAN','F225041128152','2364123000','440000','2364563000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='440000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041128152' 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 ('F225041128153','kasir',' 1',' MHA1 HK ','TOKO','SMBK-A','A1H-YJXC-82-T','AT TINDIK BABY HK 8K ','OL ','0.270','1','100.00','286000','0','0','15000','290000','0','5000','0','295000','RHM','T0073803','A1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YJXC-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1H-YJXC-82-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 ('F225041128153','2025-11-04','0.270','2025-11-04','11:28:16','PLG0074446','290000','290000','5000','295000','295000','kasir','2025-11-04 11:28:15','F22504112815');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041128153','2025-11-04','11:28:16','RHM','295000','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-251104-0061','D','2025-11-04','11:28:16','kasir','PENJUALAN','F225041128153','2364563000','295000','2364858000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='295000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041128153' 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 ('F225041128154','kasir',' 1',' MIH2 X UB ','TOKO','SMBK-H','H2I-YHXG-451-0','KL X SANTA UB 38 9K ','OL ','1.940','1','100.00','2095000','0','0','15000','2114000','0','10000','0','2124000','RHM','00364501','H2I','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YHXG-451-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H2I-YHXG-451-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 ('F225041128154','2025-11-04','1.940','2025-11-04','11:28:16','PLG0074447','2114000','2114000','10000','2124000','2124000','kasir','2025-11-04 11:28:15','F22504112815');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041128154','2025-11-04','11:28:16','RHM','2124000','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-251104-0062','D','2025-11-04','11:28:16','kasir','PENJUALAN','F225041128154','2364858000','2124000','2366982000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2124000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225041128154' 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 ('F225041129471','kasir','1',' MFH1F UB 4','TOKO','SMBK-H','H1F-YJBD-100-T','KL MILANO UB 40 8K ','OL ','2.100','1','100.00','2142000','0','0','15000','2163000','0','11000','0','2174000','RHM','T0074450','H1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBD-100-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1F-YJBD-100-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 ('F225041129471','2025-11-04','2.100','2025-11-04','11:29:47','PLG0074448','2163000','2163000','11000','2174000','2174000','kasir','2025-11-04 11:29:47','F22504112947');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041129471','2025-11-04','11:29:47','RHM','2174000','11000');
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-251104-0063','D','2025-11-04','11:29:47','kasir','PENJUALAN','F225041129471','2366982000','2174000','2369156000');
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 ('F225041134231','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YJCX-11-T','GL RANTAI HOLLOW FLIK VAR HW 8K ','OL ','1.370','1','100.00','1370000','0','0','15000','1384000','0','7000','0','1391000','RHM','T0074715','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCX-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YJCX-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 ('F225041134231','2025-11-04','1.370','2025-11-04','11:34:24','PLG0074449','1384000','1384000','7000','1391000','1391000','kasir','2025-11-04 11:34:23','F22504113423');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041134231','2025-11-04','11:34:24','RHM','1391000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251104-0064','D','2025-11-04','11:34:24','kasir','PENJUALAN','F225041134231','2369156000','1391000','2370547000');
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 ('F225041139241','kasir','1',' MEA1 BW ','TOKO','SMBK-A','A1E-YJXC-78-T','AT MODEL ITALY PANJANG VAR BW 8K ','','0.520','1','100.00','520000','0','0','15000','520000','0','0','0','520000','NS','T0073799','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXC-78-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='2025-11-04' AND kode_barang='A1E-YJXC-78-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 ('F225041139241','2025-11-04','0.520','2025-11-04','11:39:25','PLG0074450','520000','520000','0','520000','520000','kasir','2025-11-04 11:39:24','F22504113924');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041139241','2025-11-04','11:39:25','NS','520000','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-251104-0065','D','2025-11-04','11:39:25','kasir','PENJUALAN','F225041139241','2370547000','520000','2371067000');
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 ('F225041229031','kasir','1',' TGPE X MT ','TOKO','TBK-P','PETG-WLAC-52-T','CC X WEDDING MATA MT 14 ','','2.000','1','100.00','3700000','0','0','15000','3700000','0','10000','0','3710000','NS','T0051850','PETG','0','0','-','0','1850000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PETG-WLAC-52-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='2025-11-04' AND kode_barang='PETG-WLAC-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225041229031','2025-11-04','2.000','2025-11-04','12:29:04','PLG0074451','3700000','3700000','10000','3710000','3710000','kasir','2025-11-04 12:29:03','F22504122903');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225041229031','2025-11-04','12:29:04','NS','3710000','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-251104-0066','D','2025-11-04','12:29:04','kasir','PENJUALAN','F225041229031','2371067000','3710000','2374777000');
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 ('F225040104481','kasir','1',' MFB1 UB ','TOKO','SMBK-B','B1F-YKXC-22-T','GW TOGE MODEL HATI ARESO UB 8K ','','0.400','1','100.00','408000','0','0','15000','408000','0','0','0','408000','NS','T0074935','B1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YKXC-22-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='2025-11-04' AND kode_barang='B1F-YKXC-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 ('F225040104481','2025-11-04','0.400','2025-11-04','13:04:49','PLG0074452','408000','408000','0','408000','408000','kasir','2025-11-04 13:04:48','F22504010448');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040104481','2025-11-04','13:04:49','NS','408000','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-251104-0067','D','2025-11-04','13:04:49','kasir','PENJUALAN','F225040104481','2374777000','408000','2375185000');
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 ('F225040125051','kasir','1',' MHA1 LG ','TOKO','SMBK-A','A1H-YKXA-25-T','AT MODEL DAISY MATA LG 8K','OL','0.250','1','100.00','265000','0','0','15000','269000','0','5000','0','274000','RTA','T0074820','A1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YKXA-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1H-YKXA-25-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 ('F225040125051','2025-11-04','0.250','2025-11-04','13:25:05','PLG0074453','269000','269000','5000','274000','274000','kasir','2025-11-04 13:25:05','F22504012505');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040125051','2025-11-04','13:25:05','RTA','274000','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-251104-0068','D','2025-11-04','13:25:05','kasir','PENJUALAN','F225040125051','2375185000','274000','2375459000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='274000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040125051' 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 ('F225040125052','kasir',' 1',' MHA1 LG ','TOKO','SMBK-A','A1H-YKXA-24-T','AT MODEL DAISY MATA LG 8K','OL','0.250','1','100.00','265000','0','0','15000','269000','0','5000','0','274000','RTA','T0074819','A1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YKXA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1H-YKXA-24-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 ('F225040125052','2025-11-04','0.250','2025-11-04','13:25:05','PLG0074454','269000','269000','5000','274000','274000','kasir','2025-11-04 13:25:05','F22504012505');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040125052','2025-11-04','13:25:05','RTA','274000','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-251104-0069','D','2025-11-04','13:25:05','kasir','PENJUALAN','F225040125052','2375459000','274000','2375733000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='274000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040125052' 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 ('F225040125053','kasir',' 1',' MEH1 HW ','TOKO','SMBK-H','H1E-YJCA-21-T','KL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL','1.970','1','100.00','1970000','0','0','15000','1990000','0','10000','0','2000000','RTA','T0074752','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCA-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YJCA-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225040125053','2025-11-04','1.970','2025-11-04','13:25:05','PLG0074455','1990000','1990000','10000','2000000','2000000','kasir','2025-11-04 13:25:05','F22504012505');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040125053','2025-11-04','13:25:05','RTA','2000000','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-251104-0070','D','2025-11-04','13:25:05','kasir','PENJUALAN','F225040125053','2375733000','2000000','2377733000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040125053' 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 ('F225040128161','kasir','1',' MGB1 BW ','TOKO','SMBK-B','B1G-YKXA-106-T','GW TUSUK BUNGA PASIR 2C BW 8K ','OL','0.450','1','100.00','468000','0','0','15000','475000','0','5000','0','480000','NS','T0074901','B1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YKXA-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1G-YKXA-106-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 ('F225040128161','2025-11-04','0.450','2025-11-04','13:28:17','PLG0074456','475000','475000','5000','480000','480000','kasir','2025-11-04 13:28:16','F22504012816');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040128161','2025-11-04','13:28:17','NS','480000','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-251104-0071','D','2025-11-04','13:28:17','kasir','PENJUALAN','F225040128161','2377733000','480000','2378213000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040128161' 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 ('F225040128162','kasir',' 1',' MGB1 BW ','TOKO','SMBK-B','B1G-YKXA-104-T','GW TUSUK BUNGA PASIR 2C BW 8K ','OL','0.450','1','100.00','468000','0','0','15000','475000','0','5000','0','480000','NS','T0074899','B1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YKXA-104-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1G-YKXA-104-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 ('F225040128162','2025-11-04','0.450','2025-11-04','13:28:17','PLG0074457','475000','475000','5000','480000','480000','kasir','2025-11-04 13:28:16','F22504012816');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040128162','2025-11-04','13:28:17','NS','480000','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-251104-0072','D','2025-11-04','13:28:17','kasir','PENJUALAN','F225040128162','2378213000','480000','2378693000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040128162' 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 ('F225040129021','kasir','1',' MEH1 KH 42','TOKO','SMBK-H','H1E-YKXC-41-T','KL SANTA KH 42CM 8K ','','2.070','1','100.00','2070000','0','0','15000','2070000','0','0','0','2070000','TJ','T0074954','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXC-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YKXC-41-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 ('F225040129021','2025-11-04','2.070','2025-11-04','13:29:03','PLG0074458','2070000','2070000','0','2070000','2070000','kasir','2025-11-04 13:29:02','F22504012902');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040129021','2025-11-04','13:29:03','TJ','2070000','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-251104-0073','D','2025-11-04','13:29:03','kasir','PENJUALAN','F225040129021','2378693000','2070000','2380763000');
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 ('F225040129561','kasir','1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YKXC-21-T','GW TUSUK MODEL DOLLAR CM PE 8K ','OL','0.550','1','100.00','550000','0','0','15000','558000','0','5000','0','563000','NS','T0074934','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXC-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YKXC-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 ('F225040129561','2025-11-04','0.550','2025-11-04','13:29:56','PLG0074459','558000','558000','5000','563000','563000','kasir','2025-11-04 13:29:56','F22504012956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040129561','2025-11-04','13:29:56','NS','563000','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-251104-0074','D','2025-11-04','13:29:56','kasir','PENJUALAN','F225040129561','2380763000','563000','2381326000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='563000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040129561' 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 ('F225040129562','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YKXA-74-T','GL MODEL FLIK CAPELA VAR HW 8K ','OL','1.650','1','100.00','1650000','0','0','15000','1667000','0','8000','0','1675000','NS','T0074869','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXA-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YKXA-74-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 ('F225040129562','2025-11-04','1.650','2025-11-04','13:29:56','PLG0074460','1667000','1667000','8000','1675000','1675000','kasir','2025-11-04 13:29:56','F22504012956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040129562','2025-11-04','13:29:56','NS','1675000','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-251104-0075','D','2025-11-04','13:29:56','kasir','PENJUALAN','F225040129562','2381326000','1675000','2383001000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1675000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040129562' 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 ('F225040129563','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-YKXA-16-T','GW TRIXIE PANJANG HATI CAT HW 8K ','OL','0.510','1','100.00','510000','0','0','15000','518000','0','5000','0','523000','NS','T0074811','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXA-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YKXA-16-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 ('F225040129563','2025-11-04','0.510','2025-11-04','13:29:56','PLG0074461','518000','518000','5000','523000','523000','kasir','2025-11-04 13:29:56','F22504012956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040129563','2025-11-04','13:29:56','NS','523000','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-251104-0076','D','2025-11-04','13:29:56','kasir','PENJUALAN','F225040129563','2383001000','523000','2383524000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040129563' 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 ('F225040242191','kasir','1',' MEA1E X YT','TOKO','SMBK-A','A1E-WKXC-229-0','AT X HUGGIES CD VAR YT ','','1.370','1','100.00','1370000','0','0','15000','1370000','0','0','0','1370000','RHM','00262413','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-WKXC-229-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1E-WKXC-229-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225040242191','2025-11-04','1.370','2025-11-04','14:42:19','PLG0074462','1370000','1370000','0','1370000','1370000','kasir','2025-11-04 14:42:19','F22504024219');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040242191','2025-11-04','14:42:19','RHM','1370000','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-251104-0077','D','2025-11-04','14:42:19','kasir','PENJUALAN','F225040242191','2383524000','1370000','2384894000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1370000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040242191' 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 ('F225040242192','kasir',' 1',' MEF3E 10K ','TOKO','SMBK-F','F3E-YJAH-63-T','GL MODEL SPECTRA HITAM YT 8K ','','1.110','1','100.00','1110000','0','0','15000','1110000','0','10000','0','1120000','RHM','T0074276','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAH-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YJAH-63-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 ('F225040242192','2025-11-04','1.110','2025-11-04','14:42:19','PLG0074463','1110000','1110000','10000','1120000','1120000','kasir','2025-11-04 14:42:19','F22504024219');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-04','F225040242192','2025-11-04','14:42:19','RHM','1120000','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-251104-0078','D','2025-11-04','14:42:19','kasir','PENJUALAN','F225040242192','2384894000','1120000','2386014000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1120000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225040242192' 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-00004796','X-00004796','GL OVAL MODEL C TD D56 8K','GR','---','F1E','BELI','BELI001','3676000','2025-11-04','4.700','1','kasir','2025-11-04 15:17:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00004796','X-00004796');
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-251104-0001','F225180204311','RTA','1','BELI','BELI001','F1E', 'X-00004796', 'GL OVAL MODEL C TD D56 8K','4.700','4.700','100.00','4085000','3676000','782128','1000000','1','3676000','3676000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.700',berat_beli_asli=berat_beli_asli+'4.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.700',berat_akhir_asli=berat_akhir_asli+'4.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-251104-0001','2025-11-04','2025-11-04','15:17:49','RTA','---','4.700','3676000','3676000','3676000','3676000','3676000','kasir','2025-11-04 15:17:49','FB-251104-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0001','RAHAYU','POKO JAMBON','','','088296764869','kasir','2025-11-04 15:17:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0079','K','2025-11-04','15:17:49','kasir','PEMBELIAN UMUM','FB-251104-0001','2386014000','3676000','2382338000');
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-00004797','X-00004797','GL KAKI RANTAI HOLLOW UB 8K','GR','---','F3F','BELI','BELI001','370000','2025-11-04','0.510','1','kasir','2025-11-04 15:18:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004797','X-00004797');
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-251104-0002','F225060131081','NS','1','BELI','BELI001','F3F', 'X-00004797', 'GL KAKI RANTAI HOLLOW UB 8K','0.510','0.510','100.00','463000','370000','725490','1020000','1','370000','370000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-251104-0002','2025-11-04','2025-11-04','15:18:09','NS','---','0.510','370000','370000','370000','370000','370000','kasir','2025-11-04 15:18:09','FB-251104-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0002','ANIK','SAWOO','','','','kasir','2025-11-04 15:18:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0080','K','2025-11-04','15:18:09','kasir','PEMBELIAN UMUM','FB-251104-0002','2382338000','370000','2381968000');
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-00004798','X-00004798','LT X MODEL HATI MATA VAR LG 17K','GR','---','D2TD','BELI','BELI001','2005000','2025-11-04','1.500','1','kasir','2025-11-04 15:18:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TD';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TD','X-00004798','X-00004798');
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-251104-0003','F225301218161','RHM','1','BELI','BELI001','D2TD', 'X-00004798', 'LT X MODEL HATI MATA VAR LG 17K','1.500','1.500','100.00','2180000','2005000','1336667','1790000','1','2005000','2005000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TD' 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-251104-0003','2025-11-04','2025-11-04','15:18:25','RHM','---','1.500','2005000','2005000','2005000','2005000','2005000','kasir','2025-11-04 15:18:25','FB-251104-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0003','WULAN','TUNGGAR 2/2 JRAKAH SAMBIT','','','081370260460','kasir','2025-11-04 15:18:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0081','K','2025-11-04','15:18:25','kasir','PEMBELIAN UMUM','FB-251104-0003','2381968000','2005000','2379963000');
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-00004799','X-00004799','GL X RANTAI HOLLOW P4 SLEP VAR KH 8K','GR','---','F3E','BELI','BELI001','3024000','2025-11-04','3.970','1','kasir','2025-11-04 15:18:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004799','X-00004799');
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-251104-0004','F225030901591','NS','1','BELI','BELI001','F3E', 'X-00004799', 'GL X RANTAI HOLLOW P4 SLEP VAR KH 8K','3.970','3.970','100.00','3287000','3024000','761713','1000000','1','3024000','3024000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.970',berat_beli_asli=berat_beli_asli+'3.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.970',berat_akhir_asli=berat_akhir_asli+'3.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251104-0004','2025-11-04','2025-11-04','15:18:49','NS','---','3.970','3024000','3024000','3024000','3024000','3024000','kasir','2025-11-04 15:18:50','FB-251104-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0004','BU RULIK','SEMANDING KAUMAN','','','081335757818','kasir','2025-11-04 15:18:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0082','K','2025-11-04','15:18:49','kasir','PEMBELIAN UMUM','FB-251104-0004','2379963000','3024000','2376939000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040104481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040104481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040104481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040125051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040125051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040125051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040125052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040125052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040125052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040125053' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040125053' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040125053';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040128161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040128161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040128161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040128162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040128162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040128162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040129021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040129561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040129562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129563' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040129563' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040129563';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040242191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040242191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040242191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040242192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040242192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040242192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040854491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040854491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040854491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040901291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040901291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040901291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040901571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040901571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040901571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934083' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934083' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934083';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934084' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934084' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934084';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934085' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934085' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934085';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934086' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934086' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934086';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934087' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934087' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934087';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934088' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040934088' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040934088';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040936391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040936392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936393' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936393' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040936393';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936394' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936394' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040936394';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936395' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225040936395' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225040936395';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041005231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041005231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041005231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041005551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041005551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041005551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041008471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041008471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041008471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041008472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041008472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041008472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041008473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041008473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041008473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041011311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041011311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041011311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022485' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022485' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022485';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022486' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022486' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022486';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022487' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022487' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022487';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022488' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041022488' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041022488';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041048441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041048441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041048441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041048442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041048442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041048442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041056141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041056141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041056141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041059061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041059061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041059061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120423' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120423' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120423';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120424' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120424' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120424';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120425' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120425' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120425';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120426' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120426' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120426';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120427' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120427' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120427';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120428' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120428' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120428';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120429' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041120429' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041120429';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123345' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123345' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123345';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123346' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123346' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123346';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123347' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123347' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123347';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123348' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041123348' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041123348';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041125531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041125532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125533' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125533' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041125533';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125534' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041125534' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041125534';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041128151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041128152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128153' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128153' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041128153';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128154' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041128154' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041128154';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041129471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041129471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041129471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041134231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041134231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041134231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041139241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041139241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041139241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225041229031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225041229031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225041229031';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-04';
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='2025-11-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-04' 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-251105-0001','D','2025-11-05','16:05:26','SYSTEM','SALDO AWAL','SALDO AWAL','0','2376939000','2376939000');
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-251105-0001','D','2025-11-05','16:05:26','','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-251105-0001','D','2025-11-05','16:05:26','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-251105-0001','D','2025-11-05','16:05:26','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-251105-0001','D','2025-11-05','16:05:26','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-251105-0001','D','2025-11-05','16:05:26','BCA','SALDO AWAL','SALDO AWAL','0','4115435888','4115435888');
UPDATE tp_system SET tgl_system='2025-11-05';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','F3TE-YFAA-87-T','1','3.050','3.050','TOKO','TBK-F','TOKO','TBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-F',tgl_last_beli='2025-11-05 16:21:33' WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:21:33','TOKO','TBK-F','F3TE','F3TE-YFAA-87-T','1','3.050','3.050','1','3.050','3.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-YFAA-87-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-YFAA-87-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251105-0001','2025-11-05','16:21','3.050','input','2025-11-04 16:21:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','B1D-YJBI-82-0','1','0.800','0.800','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-YJBI-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-YJBI-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-11-05 16:59:17' WHERE kode_barang='B1D-YJBI-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-YJBI-82-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:17','TOKO','SMBK-B','B1D','B1D-YJBI-82-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-YJBI-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-YJBI-82-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251105-0001','2025-11-05','16:59','0.800','input','2025-11-04 16:59:16');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','E2D-YKXD-27-0','1','1.050','1.050','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKXD-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKXD-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-05 16:59:32' WHERE kode_barang='E2D-YKXD-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKXD-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:32','TOKO','SMBK-E','E2D','E2D-YKXD-27-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKXD-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKXD-27-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','E2D-YKXD-35-0','1','0.830','0.830','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKXD-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKXD-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-05 16:59:32' WHERE kode_barang='E2D-YKXD-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKXD-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:32','TOKO','SMBK-E','E2D','E2D-YKXD-35-0','1','0.830','0.830','1','0.830','0.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKXD-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKXD-35-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','E2E-YKXD-48-0','1','0.530','0.530','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YKXD-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YKXD-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-05 16:59:32' WHERE kode_barang='E2E-YKXD-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YKXD-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:32','TOKO','SMBK-E','E2E','E2E-YKXD-48-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YKXD-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YKXD-48-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','E2E-YKXD-51-0','1','0.700','0.700','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YKXD-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YKXD-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-05 16:59:32' WHERE kode_barang='E2E-YKXD-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YKXD-51-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:32','TOKO','SMBK-E','E2E','E2E-YKXD-51-0','1','0.700','0.700','1','0.700','0.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YKXD-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YKXD-51-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251105-0001','2025-11-05','16:59','3.110','input','2025-11-04 16:59:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','F3E-YKXD-89-0','1','2.450','2.450','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-11-05 16:59:46' WHERE kode_barang='F3E-YKXD-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:46','TOKO','SMBK-F','F3E','F3E-YKXD-89-0','1','2.450','2.450','1','2.450','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YKXD-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-89-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','F4I-YKXD-96-0','1','1.120','1.120','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F4I-YKXD-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4I-YKXD-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-11-05 16:59:46' WHERE kode_barang='F4I-YKXD-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4I-YKXD-96-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 16:59:46','TOKO','SMBK-F','F4I','F4I-YKXD-96-0','1','1.120','1.120','1','1.120','1.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4I-YKXD-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4I-YKXD-96-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251105-0001','2025-11-05','16:59','3.570','input','2025-11-04 16:59:46');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251105-0001','1','H2I-YKXD-120-0','1','1.950','1.950','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YKXD-120-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YKXD-120-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-05 17:00:02' WHERE kode_barang='H2I-YKXD-120-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YKXD-120-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-05 17:00:02','TOKO','SMBK-H','H2I','H2I-YKXD-120-0','1','1.950','1.950','1','1.950','1.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YKXD-120-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YKXD-120-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251105-0001','2025-11-05','16:59','1.950','input','2025-11-04 17:00:01');