INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090815481','kasir','1',' MDE1 CM 14','TOKO','SMBK-E','E1D-YGAH-103-T','CC POLOS CM 14 8K ','OLH','1.530','1','100.00','1392000','0','0','15000','1554000','0','15000','0','1569000','TJ','T0071134','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YGAH-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E1D-YGAH-103-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 ('F225090815481','2025-10-09','1.530','2025-10-09','08:15:48','PLG0073480','1554000','1554000','15000','1569000','1569000','kasir','2025-10-09 08:15:48','F22509081548');
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-10-09','F225090815481','2025-10-09','08:15:48','TJ','1569000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251009-0002','D','2025-10-09','08:15:48','kasir','PENJUALAN','F225090815481','1248871000','1569000','1250440000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090817471','kasir','1',' TGPE X UB ','TOKO','TBK-P','PETG-WBXH-74-T','CC X WG MODEL KUPU MATA VAR UB 14 ','OLH','1.770','1','100.00','2963000','0','0','15000','3265000','0','18000','0','3283000','TJ','T0042149','PETG','0','0','-','0','1674000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PETG-WBXH-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='PETG-WBXH-74-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 ('F225090817471','2025-10-09','1.770','2025-10-09','08:17:47','PLG0073481','3265000','3265000','18000','3283000','3283000','kasir','2025-10-09 08:17:47','F22509081747');
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-10-09','F225090817471','2025-10-09','08:17:47','TJ','3283000','18000');
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-251009-0003','D','2025-10-09','08:17:47','kasir','PENJUALAN','F225090817471','1250440000','3283000','1253723000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3283000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090817471' 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 ('F225090817472','kasir',' 1',' TEH1 HW 42','TOKO','TBK-H','H1TE-YGBD-91-T','KL RANTAI HOLLOW HW 42CM 17K ','OLH','3.060','1','100.00','5018000','0','0','15000','5523000','0','31000','0','5554000','TJ','T0071519','H1TE','0','0','-','0','1640000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-YGBD-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='H1TE-YGBD-91-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 ('F225090817472','2025-10-09','3.060','2025-10-09','08:17:47','PLG0073482','5523000','5523000','31000','5554000','5554000','kasir','2025-10-09 08:17:47','F22509081747');
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-10-09','F225090817472','2025-10-09','08:17:47','TJ','5554000','31000');
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-251009-0004','D','2025-10-09','08:17:47','kasir','PENJUALAN','F225090817472','1253723000','5554000','1259277000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090817472' 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 ('F225090817473','kasir',' 1',' TDD2 LG N ','TOKO','TBK-D','D2TD-YGBD-79-T','LT MODEL HURUF MATA LG N 17K ','OLH','1.050','1','100.00','1704000','0','0','15000','1895000','0','11000','0','1906000','TJ','T0071507','D2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TD-YGBD-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='D2TD-YGBD-79-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 ('F225090817473','2025-10-09','1.050','2025-10-09','08:17:47','PLG0073483','1895000','1895000','11000','1906000','1906000','kasir','2025-10-09 08:17:47','F22509081747');
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-10-09','F225090817473','2025-10-09','08:17:47','TJ','1906000','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-251009-0005','D','2025-10-09','08:17:47','kasir','PENJUALAN','F225090817473','1259277000','1906000','1261183000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1906000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090817473' 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 ('F225090831241','kasir','1',' TEF3 X LT ','TOKO','TBK-F','F3TE-YJXB-118-T','GL X RANTAI HOLLOW P3 SLEP LT 17K ','OL','2.050','1','100.00','3362000','0','0','15000','3697000','0','14000','0','3711000','RTA','T0073698','F3TE','0','0','-','0','1640000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YJXB-118-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='F3TE-YJXB-118-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 ('F225090831241','2025-10-09','2.050','2025-10-09','08:31:25','PLG0073484','3697000','3697000','14000','3711000','0','kasir','2025-10-09 08:31:24','F22509083124');
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-10-09','F225090831241','2025-10-09','08:31:25','RTA','3711000','14000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251009-0001','2025-10-09','2025-10-09 08:31:24','PENJUALAN : F225090831241','878777667678','BCA','3711000','3711000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251009-0002','D','2025-10-09','08:31:25','BCA','PENJUALAN','F225090831241','4043018888','3711000','4046729888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('878777667678','LILIS');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3711000' WHERE no_faktur_jual='F225090831241' 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 ('F225090909011','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YHAB-55-T','GL MODEL FANCY VAR HW 8K ','OL','1.780','1','100.00','1650000','0','0','15000','1807000','0','9000','0','1816000','TIN','T0072262','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHAB-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='F3E-YHAB-55-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 ('F225090909011','2025-10-09','1.780','2025-10-09','09:09:02','PLG0073485','1807000','1807000','9000','1816000','1816000','kasir','2025-10-09 09:09:01','F22509090901');
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-10-09','F225090909011','2025-10-09','09:09:02','TIN','1816000','9000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251009-0006','D','2025-10-09','09:09:02','kasir','PENJUALAN','F225090909011','1261183000','1816000','1262999000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090941301','kasir','1',' MFH1 UB 40','TOKO','SMBK-H','H1F-YHXE-52-T','KL MILANO UB 40CM 8K ','OL','3.010','1','100.00','2841000','0','0','15000','3130000','0','15000','0','3145000','RTA','T0071841','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YHXE-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='H1F-YHXE-52-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 ('F225090941301','2025-10-09','3.010','2025-10-09','09:41:31','PLG0073486','3130000','3130000','15000','3145000','3145000','kasir','2025-10-09 09:41:30','F22509094130');
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-10-09','F225090941301','2025-10-09','09:41:31','RTA','3145000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251009-0007','D','2025-10-09','09:41:31','kasir','PENJUALAN','F225090941301','1262999000','3145000','1266144000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090959121','kasir','1',' MEE2 UB 16','TOKO','SMBK-E','E2E-YJXD-54-T','CC MODEL HATI MATA VAR UB 16 8K','OL','0.650','1','100.00','634000','0','0','15000','666000','0','5000','0','671000','RTA','T0073868','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E2E-YJXD-54-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 ('F225090959121','2025-10-09','0.650','2025-10-09','09:59:13','PLG0073487','666000','666000','5000','671000','671000','kasir','2025-10-09 09:59:12','F22509095912');
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-10-09','F225090959121','2025-10-09','09:59:13','RTA','671000','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-251009-0008','D','2025-10-09','09:59:13','kasir','PENJUALAN','F225090959121','1266144000','671000','1266815000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225091137331','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-YJXF-100-T','LT MODEL PLAT DOLLAR LG 8K ','OL','0.510','1','100.00','498000','0','0','15000','520000','0','5000','0','525000','RTA','T0073998','D1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXF-100-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-10-09' AND kode_barang='D1E-YJXF-100-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 ('F225091137331','2025-10-09','0.510','2025-10-09','11:37:34','PLG0073488','520000','520000','5000','525000','0','kasir','2025-10-09 11:37:33','F22509113733');
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-10-09','F225091137331','2025-10-09','11:37:34','RTA','525000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251009-0002','2025-10-09','2025-10-09 11:37:33','PENJUALAN : F225091137331','898777665','BCA','525000','525000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251009-0003','D','2025-10-09','11:37:34','BCA','PENJUALAN','F225091137331','4046729888','525000','4047254888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('898777665','ENI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225091137331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225091137331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225091137331';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225091144471','kasir','1',' MFD1 BW ','TOKO','SMBK-D','D1F-YJXF-93-T','LT MODEL LETTERA PLAT BW 8K ','OL','0.400','1','100.00','399000','0','0','15000','418000','0','5000','0','423000','TJ','T0073991','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJXF-93-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-10-09' AND kode_barang='D1F-YJXF-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 ('F225091144471','2025-10-09','0.400','2025-10-09','11:44:47','PLG0073489','418000','418000','5000','423000','423000','kasir','2025-10-09 11:44:47','F22509114447');
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-10-09','F225091144471','2025-10-09','11:44:47','TJ','423000','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-251009-0009','D','2025-10-09','11:44:47','kasir','PENJUALAN','F225091144471','1266815000','423000','1267238000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225091202511','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIBB-104-T','LT SLOBOK BULAT HURUF BG A 8K ','','0.500','1','100.00','480000','0','0','15000','525000','0','5000','0','530000','RHM','T0073240','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIBB-104-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='D1G-YIBB-104-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 ('F225091202511','2025-10-09','0.500','2025-10-09','12:02:51','PLG0073490','525000','525000','5000','530000','530000','kasir','2025-10-09 12:02:51','F22509120251');
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-10-09','F225091202511','2025-10-09','12:02:51','RHM','530000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251009-0010','D','2025-10-09','12:02:51','kasir','PENJUALAN','F225091202511','1267238000','530000','1267768000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225091233351','kasir','1',' MEE2 X UB ','TOKO','SMBK-E','E2E-YJXD-56-0','CC X MODEL MATA UB 16 8K ','OL','0.550','1','100.00','537000','0','0','15000','561000','0','5000','0','566000','TJ','00372036','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-56-0' 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-10-09' AND kode_barang='E2E-YJXD-56-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 ('F225091233351','2025-10-09','0.550','2025-10-09','12:33:35','PLG0073491','561000','561000','5000','566000','566000','kasir','2025-10-09 12:33:35','F22509123335');
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-10-09','F225091233351','2025-10-09','12:33:35','TJ','566000','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-251009-0011','D','2025-10-09','12:33:35','kasir','PENJUALAN','F225091233351','1267768000','566000','1268334000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225091252131','kasir','1',' MEE1 5K HW','TOKO','SMBK-E','E1E-YHAC-155-T','CC LISTRING GELOMBANG CAT HW 13 8K ','OL','0.630','1','100.00','584000','0','0','15000','643000','0','5000','0','648000','TJ','T0072295','E1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHAC-155-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E1E-YHAC-155-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 ('F225091252131','2025-10-09','0.630','2025-10-09','12:52:14','PLG0073492','643000','643000','5000','648000','0','kasir','2025-10-09 12:52:13','F22509125213');
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-10-09','F225091252131','2025-10-09','12:52:14','TJ','648000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251009-0003','2025-10-09','2025-10-09 12:52:13','PENJUALAN : F225091252131','7942698470494','BCA','648000','648000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251009-0004','D','2025-10-09','12:52:14','BCA','PENJUALAN','F225091252131','4047254888','648000','4047902888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('7942698470494','NARITA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='648000' WHERE no_faktur_jual='F225091252131' 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 ('F225090115081','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-24-T','AT MODEL MATA VAR LG 8K ','OL','0.570','1','100.00','556000','0','0','15000','584000','0','5000','0','589000','TIN','T0073838','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-24-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-10-09' AND kode_barang='A1E-YJXD-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 ('F225090115081','2025-10-09','0.570','2025-10-09','13:15:09','PLG0073493','584000','584000','5000','589000','589000','kasir','2025-10-09 13:15:08','F22509011508');
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-10-09','F225090115081','2025-10-09','13:15:09','TIN','589000','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-251009-0012','D','2025-10-09','13:15:09','kasir','PENJUALAN','F225090115081','1268334000','589000','1268923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='589000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090115081' 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 ('F225090115082','kasir',' 1',' MEA1 UB ','TOKO','SMBK-A','A1E-YJXD-31-T','AT MODEL ITALY PANJANG VAR UB 8K ','OL','0.960','1','100.00','936000','0','0','15000','984000','0','5000','0','989000','TIN','T0073845','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='A1E-YJXD-31-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 ('F225090115082','2025-10-09','0.960','2025-10-09','13:15:09','PLG0073494','984000','984000','5000','989000','989000','kasir','2025-10-09 13:15:08','F22509011508');
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-10-09','F225090115082','2025-10-09','13:15:09','TIN','989000','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-251009-0013','D','2025-10-09','13:15:09','kasir','PENJUALAN','F225090115082','1268923000','989000','1269912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='989000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090115082' 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 ('F225090115083','kasir',' 1',' MEH1 15K H','TOKO','SMBK-H','H1E-YJXB-43-T','KL SANTA MODEL BOLA PASIR VAR HW 8K ','OL','2.220','1','100.00','2169000','0','0','15000','2261000','0','15000','0','2276000','TIN','T0073623','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXB-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='H1E-YJXB-43-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 ('F225090115083','2025-10-09','2.220','2025-10-09','13:15:09','PLG0073495','2261000','2261000','15000','2276000','2276000','kasir','2025-10-09 13:15:08','F22509011508');
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-10-09','F225090115083','2025-10-09','13:15:09','TIN','2276000','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-251009-0014','D','2025-10-09','13:15:09','kasir','PENJUALAN','F225090115083','1269912000','2276000','1272188000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2276000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090115083' 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 ('F225090159551','kasir','1',' MDE1 CM 22','TOKO','SMBK-E','E1D-YJXA-70-T','CC MODEL DAUN VAR CM 22 8K ','','1.160','1','100.00','1079000','0','0','15000','1150000','0','0','0','1150000','TJ','T0073562','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXA-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E1D-YJXA-70-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225090159551','2025-10-09','1.160','2025-10-09','13:59:55','PLG0073496','1150000','1150000','0','1150000','1150000','kasir','2025-10-09 13:59:55','F22509015955');
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-10-09','F225090159551','2025-10-09','13:59:55','TJ','1150000','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-251009-0015','D','2025-10-09','13:59:55','kasir','PENJUALAN','F225090159551','1272188000','1150000','1273338000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090213311','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-YJXC-81-T','AT MODEL HATI MATA VAR CM 8K ','OL','0.460','1','100.00','448000','0','0','15000','470000','0','5000','0','475000','TJ','T0073802','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXC-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='A1E-YJXC-81-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 ('F225090213311','2025-10-09','0.460','2025-10-09','14:13:31','PLG0073497','470000','470000','5000','475000','0','kasir','2025-10-09 14:13:31','F22509021331');
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-10-09','F225090213311','2025-10-09','14:13:31','TJ','475000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251009-0004','2025-10-09','2025-10-09 14:13:31','PENJUALAN : F225090213311','89479479583634','BCA','475000','475000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251009-0005','D','2025-10-09','14:13:31','BCA','PENJUALAN','F225090213311','4047902888','475000','4048377888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89479479583634','ANINDYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='475000' WHERE no_faktur_jual='F225090213311' 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 ('F225090215111','kasir','1',' MDA1D X YT','TOKO','SMBK-A','A1D-YBXH-70-0','AT X HUGGIES MATA YT 8K ','OL','0.920','1','100.00','837000','0','0','15000','943000','0','5000','0','948000','TIN','00338133','A1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YBXH-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='A1D-YBXH-70-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 ('F225090215111','2025-10-09','0.920','2025-10-09','14:15:12','PLG0073498','943000','943000','5000','948000','948000','kasir','2025-10-09 14:15:11','F22509021511');
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-10-09','F225090215111','2025-10-09','14:15:12','TIN','948000','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-251009-0016','D','2025-10-09','14:15:12','kasir','PENJUALAN','F225090215111','1273338000','948000','1274286000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090215471','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-YJXD-11-T','AT KLIP BANGKOK SLEP LG 8K ','OL','0.980','1','100.00','936000','0','0','15000','1005000','0','5000','0','1010000','TIN','T0073825','A1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJXD-11-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-10-09' AND kode_barang='A1D-YJXD-11-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 ('F225090215471','2025-10-09','0.980','2025-10-09','14:15:48','PLG0073499','1005000','1005000','5000','1010000','1010000','kasir','2025-10-09 14:15:47','F22509021547');
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-10-09','F225090215471','2025-10-09','14:15:48','TIN','1010000','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-251009-0017','D','2025-10-09','14:15:48','kasir','PENJUALAN','F225090215471','1274286000','1010000','1275296000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1010000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090215471' 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 ('F225090215472','kasir',' 1',' MDA1 LG ','TOKO','SMBK-A','A1D-YJXD-10-T','AT KLIP BANGKOK SLEP LG 8K ','OL','1.000','1','100.00','955000','0','0','15000','1020000','0','5000','0','1025000','TIN','T0073824','A1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJXD-10-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-10-09' AND kode_barang='A1D-YJXD-10-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 ('F225090215472','2025-10-09','1.000','2025-10-09','14:15:48','PLG0073500','1020000','1020000','5000','1025000','1025000','kasir','2025-10-09 14:15:47','F22509021547');
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-10-09','F225090215472','2025-10-09','14:15:48','TIN','1025000','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-251009-0018','D','2025-10-09','14:15:48','kasir','PENJUALAN','F225090215472','1275296000','1025000','1276321000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1025000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090215472' 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 ('F225090216341','kasir','1',' MEE1 LG 12','TOKO','SMBK-E','E1E-YJXF-36-T','CC MODEL DAUN VAR LG 12 8K ','OL','0.430','1','100.00','420000','0','0','15000','441000','0','5000','0','446000','TIN','T0073934','E1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJXF-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E1E-YJXF-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225090216341','2025-10-09','0.430','2025-10-09','14:16:34','PLG0073501','441000','441000','5000','446000','446000','kasir','2025-10-09 14:16:34','F22509021634');
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-10-09','F225090216341','2025-10-09','14:16:34','TIN','446000','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-251009-0019','D','2025-10-09','14:16:34','kasir','PENJUALAN','F225090216341','1276321000','446000','1276767000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090217021','kasir','1',' MEE2 X UB ','TOKO','SMBK-E','E2E-YEAI-276-0','CC X MODEL MATA UB 14 8K ','OL','0.500','1','100.00','463000','0','0','15000','513000','0','5000','0','518000','TIN','00354760','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YEAI-276-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-10-09' AND kode_barang='E2E-YEAI-276-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 ('F225090217021','2025-10-09','0.500','2025-10-09','14:17:03','PLG0073502','513000','513000','5000','518000','518000','kasir','2025-10-09 14:17:02','F22509021702');
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-10-09','F225090217021','2025-10-09','14:17:03','TIN','518000','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-251009-0020','D','2025-10-09','14:17:03','kasir','PENJUALAN','F225090217021','1276767000','518000','1277285000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090219331','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YGXA-30-T','LT SLOBOK BULAT HURUF BG M 8K ','','0.470','1','100.00','452000','0','0','15000','494000','0','5000','0','499000','TIN','T0070550','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YGXA-30-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-10-09' AND kode_barang='D1G-YGXA-30-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 ('F225090219331','2025-10-09','0.470','2025-10-09','14:19:34','PLG0073503','494000','494000','5000','499000','499000','kasir','2025-10-09 14:19:33','F22509021933');
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-10-09','F225090219331','2025-10-09','14:19:34','TIN','499000','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-251009-0021','D','2025-10-09','14:19:34','kasir','PENJUALAN','F225090219331','1277285000','499000','1277784000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='499000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090219331' 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 ('F225090219332','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIBI-87-T','LT SLOBOK BALOK HURUF BG A 8K ','','0.570','1','100.00','548000','0','0','15000','599000','0','5000','0','604000','TIN','T0073400','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIBI-87-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-10-09' AND kode_barang='D1G-YIBI-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225090219332','2025-10-09','0.570','2025-10-09','14:19:34','PLG0073504','599000','599000','5000','604000','604000','kasir','2025-10-09 14:19:33','F22509021933');
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-10-09','F225090219332','2025-10-09','14:19:34','TIN','604000','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-251009-0022','D','2025-10-09','14:19:34','kasir','PENJUALAN','F225090219332','1277784000','604000','1278388000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='604000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090219332' 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 ('F225090219333','kasir',' 1',' MEE2 CM 12','TOKO','SMBK-E','E2E-YJXF-16-T','CC MODEL HATI MATA CM 12 8K ','','0.660','1','100.00','645000','0','0','15000','667000','0','0','0','667000','TIN','T0073914','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E2E-YJXF-16-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 ('F225090219333','2025-10-09','0.660','2025-10-09','14:19:34','PLG0073505','667000','667000','0','667000','667000','kasir','2025-10-09 14:19:33','F22509021933');
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-10-09','F225090219333','2025-10-09','14:19:34','TIN','667000','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-251009-0023','D','2025-10-09','14:19:34','kasir','PENJUALAN','F225090219333','1278388000','667000','1279055000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='667000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090219333' 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 ('F225090222401','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YGAA-190-0','CC X MODEL MATA LG 14 8K ','OL','0.500','1','100.00','463000','0','0','15000','513000','0','5000','0','518000','TIN','00360743','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGAA-190-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-10-09' AND kode_barang='E2E-YGAA-190-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 ('F225090222401','2025-10-09','0.500','2025-10-09','14:22:41','PLG0073506','513000','513000','5000','518000','518000','kasir','2025-10-09 14:22:40','F22509022240');
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-10-09','F225090222401','2025-10-09','14:22:41','TIN','518000','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-251009-0024','D','2025-10-09','14:22:41','kasir','PENJUALAN','F225090222401','1279055000','518000','1279573000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='518000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090222401' 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 ('F225090222402','kasir',' 1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YGBD-52-T','CC PIPA MODEL MATA VAR HTM 14 8K ','OL','0.510','1','100.00','473000','0','0','15000','523000','0','5000','0','528000','TIN','T0071480','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGBD-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E2E-YGBD-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225090222402','2025-10-09','0.510','2025-10-09','14:22:41','PLG0073507','523000','523000','5000','528000','528000','kasir','2025-10-09 14:22:40','F22509022240');
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-10-09','F225090222402','2025-10-09','14:22:41','TIN','528000','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-251009-0025','D','2025-10-09','14:22:41','kasir','PENJUALAN','F225090222402','1279573000','528000','1280101000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='528000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090222402' 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 ('F225090223531','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXF-22-T','CC PIPA MODEL HATI MATA HTM 11 8K ','OL','0.550','1','100.00','537000','0','0','15000','564000','0','5000','0','569000','TIN','T0073920','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-22-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-10-09' AND kode_barang='E2E-YJXF-22-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 ('F225090223531','2025-10-09','0.550','2025-10-09','14:23:53','PLG0073508','564000','564000','5000','569000','569000','kasir','2025-10-09 14:23:53','F22509022353');
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-10-09','F225090223531','2025-10-09','14:23:53','TIN','569000','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-251009-0026','D','2025-10-09','14:23:53','kasir','PENJUALAN','F225090223531','1280101000','569000','1280670000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='569000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090223531' 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 ('F225090223532','kasir',' 1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXF-27-T','CC PIPA MODEL HATI MATA HTM 17 8K ','OL','0.560','1','100.00','547000','0','0','15000','574000','0','5000','0','579000','TIN','T0073925','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-27-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-10-09' AND kode_barang='E2E-YJXF-27-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 ('F225090223532','2025-10-09','0.560','2025-10-09','14:23:53','PLG0073509','574000','574000','5000','579000','579000','kasir','2025-10-09 14:23:53','F22509022353');
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-10-09','F225090223532','2025-10-09','14:23:53','TIN','579000','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-251009-0027','D','2025-10-09','14:23:53','kasir','PENJUALAN','F225090223532','1280670000','579000','1281249000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='579000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090223532' 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 ('F225090224191','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXB-28-T','CC PIPA MODEL MATA HTM 14 8K ','OL','0.550','1','100.00','537000','0','0','15000','564000','0','5000','0','569000','TIN','T0073608','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-28-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-10-09' AND kode_barang='E2E-YJXB-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225090224191','2025-10-09','0.550','2025-10-09','14:24:20','PLG0073510','564000','564000','5000','569000','569000','kasir','2025-10-09 14:24:19','F22509022419');
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-10-09','F225090224191','2025-10-09','14:24:20','TIN','569000','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-251009-0028','D','2025-10-09','14:24:20','kasir','PENJUALAN','F225090224191','1281249000','569000','1281818000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090225051','kasir','1',' MDE2 YT 18','TOKO','SMBK-E','E2D-YGBB-124-T','CC MODEL MATA VAR YT 18 8K','OL','0.920','1','100.00','837000','0','0','15000','943000','0','5000','0','948000','TIN','T0071396','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGBB-124-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='E2D-YGBB-124-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 ('F225090225051','2025-10-09','0.920','2025-10-09','14:25:05','PLG0073511','943000','943000','5000','948000','948000','kasir','2025-10-09 14:25:05','F22509022505');
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-10-09','F225090225051','2025-10-09','14:25:05','TIN','948000','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-251009-0029','D','2025-10-09','14:25:05','kasir','PENJUALAN','F225090225051','1281818000','948000','1282766000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='948000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090225051' 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 ('F225090225052','kasir',' 1',' MDE2 CM 18','TOKO','SMBK-E','E2D-YIBB-67-T','CC MODEL MATA VAR CM 18 8K ','OL','1.350','1','100.00','1228000','0','0','15000','1377000','0','7000','0','1384000','TIN','T0073203','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-67-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-10-09' AND kode_barang='E2D-YIBB-67-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 ('F225090225052','2025-10-09','1.350','2025-10-09','14:25:05','PLG0073512','1377000','1377000','7000','1384000','1384000','kasir','2025-10-09 14:25:05','F22509022505');
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-10-09','F225090225052','2025-10-09','14:25:05','TIN','1384000','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-251009-0030','D','2025-10-09','14:25:05','kasir','PENJUALAN','F225090225052','1282766000','1384000','1284150000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225090225052' 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 ('F225090236591','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YJXF-67-T','GL RANTRAI HOLLOW PLAT SLEP HW 8K ','','1.940','1','100.00','1895000','0','0','15000','1960000','0','0','0','1960000','TJ','T0073965','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='F3E-YJXF-67-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 ('F225090236591','2025-10-09','1.940','2025-10-09','14:36:59','PLG0073513','1960000','1960000','0','1960000','0','kasir','2025-10-09 14:36:59','F22509023659');
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-10-09','F225090236591','2025-10-09','14:36:59','TJ','1960000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251009-0005','2025-10-09','2025-10-09 14:36:59','PENJUALAN : F225090236591','783629870924704','BCA','1960000','1960000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251009-0006','D','2025-10-09','14:36:59','BCA','PENJUALAN','F225090236591','4048377888','1960000','4050337888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('783629870924704','YAYUK');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1960000' WHERE no_faktur_jual='F225090236591' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090115081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090115081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090115081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090115082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090115082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090115082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090115083' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090115083' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090115083';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090159551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090159551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090159551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090213311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090213311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090213311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090215111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090215111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090215111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090215471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090215471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090215471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090215472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090215472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090215472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090216341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090216341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090216341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090217021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090217021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090217021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090219331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090219331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090219331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090219332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090219332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090219332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090219333' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090219333' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090219333';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090222401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090222401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090222401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090222402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090222402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090222402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090223531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090223531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090223531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090223532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090223532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090223532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090224191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090224191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090224191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090225051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090225051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090225051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090225052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090225052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090225052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090236591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090236591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090236591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090815481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090815481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090815481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090817471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090817471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090817471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090817472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090817472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090817472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090817473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090817473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090817473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090831241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090831241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090831241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090909011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090909011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090909011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090941301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090941301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090941301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090959121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090959121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090959121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225091144471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225091144471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225091144471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225091202511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225091202511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225091202511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225091233351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225091233351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225091233351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225091252131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225091252131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225091252131';
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-00004728','X-00004728','GW X SANTA AUREL MATA HW 8K','GR','---','B1F','BELI','BELI001','445000','2025-10-09','0.650','1','kasir','2025-10-09 15:19:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00004728','X-00004728');
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-251009-0001','F224290405201','RHM','1','BELI','BELI001','B1F', 'X-00004728', 'GW X SANTA AUREL MATA HW 8K','0.750','0.650','100.00','450000','445000','684615','1005000','1','445000','445000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-251009-0001','2025-10-09','2025-10-09','15:19:59','RHM','---','0.650','445000','445000','445000','445000','445000','kasir','2025-10-09 15:19:59','FB-251009-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251009-0001','NESYA','JL. LAWU GANG SATE','','','087858756878','kasir','2025-10-09 15:19:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-09' 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-251009-0031','K','2025-10-09','15:19:59','kasir','PEMBELIAN UMUM','FB-251009-0001','1284150000','445000','1283705000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225090402111','kasir','1',' MFA1F X UB','TOKO','SMBK-A','A1F-YHBB-1-0','AT X MODEL BOLA PASIR UB 8K ','','0.970','1','100.00','916000','0','0','15000','999000','0','5000','0','1004000','TJ','00366614','A1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YHBB-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-10-09' AND kode_barang='A1F-YHBB-1-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 ('F225090402111','2025-10-09','0.970','2025-10-09','16:02:12','PLG0073514','999000','999000','5000','1004000','1004000','kasir','2025-10-09 16:02:11','F22509040211');
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-10-09','F225090402111','2025-10-09','16:02:12','TJ','1004000','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-251009-0032','D','2025-10-09','16:02:12','kasir','PENJUALAN','F225090402111','1283705000','1004000','1284709000');
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-00004729','X-00004729','CC X LISTRING MATA LG 14','GR','---','E2E','BELI','BELI001','630000','2025-10-09','0.900','1','kasir','2025-10-09 16:11:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004729','X-00004729');
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-251009-0002','F222230839571','TIN','1','BELI','BELI001','E2E', 'X-00004729', 'CC X LISTRING MATA LG 14','1.110','0.900','100.00','484000','630000','700000','977000','1','630000','630000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251009-0002','2025-10-09','2025-10-09','16:11:46','TIN','---','0.900','630000','630000','630000','630000','630000','kasir','2025-10-09 16:11:46','FB-251009-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251009-0002','BAPAK PAIMAN','PONOROGO','','','','kasir','2025-10-09 16:11:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-09' 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-251009-0033','K','2025-10-09','16:11:46','kasir','PEMBELIAN UMUM','FB-251009-0002','1284709000','630000','1284079000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225090402111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225090402111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225090402111';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251009-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251009-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251009-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251009-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-09';
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-10-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-09' 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-251010-0001','D','2025-10-10','16:15:10','SYSTEM','SALDO AWAL','SALDO AWAL','0','1284079000','1284079000');
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-251010-0001','D','2025-10-10','16:15:10','BCA','SALDO AWAL','SALDO AWAL','0','4050337888','4050337888');
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-251010-0001','D','2025-10-10','16:15:10','','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-251010-0001','D','2025-10-10','16:15:10','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-251010-0001','D','2025-10-10','16:15:10','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-251010-0001','D','2025-10-10','16:15:10','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-10-10';
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-20251010-0001','1','E1E-YGAG-184-0','1','0.480','0.480','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YGAG-184-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YGAG-184-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-10 16:45:03' WHERE kode_barang='E1E-YGAG-184-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YGAG-184-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-10-10 16:45:03','TOKO','SMBK-E','E1E','E1E-YGAG-184-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-YGAG-184-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YGAG-184-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251010-0001','2025-10-10','16:44','0.480','input','2025-10-09 16:45:02');
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-20251010-0001','1','F3E-YIAE-203-0','1','2.730','2.730','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YIAE-203-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YIAE-203-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-10-10 16:45:20' WHERE kode_barang='F3E-YIAE-203-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YIAE-203-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-10-10 16:45:20','TOKO','SMBK-F','F3E','F3E-YIAE-203-0','1','2.730','2.730','1','2.730','2.730','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-YIAE-203-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YIAE-203-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251010-0001','2025-10-10','16:45','2.730','input','2025-10-09 16:45:19');