INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090825011','input','1',' MEB1 LG ','TOKO','PM-B','B1E-YJCA-48-T','GW TRIXIE PANJANG MODEL MATA VAR LG 8K ','','0.540','1','100.00','540000','0','0','15000','535000','0','0','0','535000','FIT','T0074779','B1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJCA-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='B1E-YJCA-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090825011','2025-11-09','0.540','2025-11-09','08:25:01','PLG0025596','535000','535000','0','535000','535000','input','2025-11-09 08:25:01','F32509082501');
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-09','F325090825011','2025-11-09','08:25:01','FIT','535000','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-251109-0002','D','2025-11-09','08:25:01','input','PENJUALAN','F325090825011','587561000','535000','588096000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090825491','input','1',' MHB1 CM ','TOKO','PM-B','B1H-YGXD-29-T','GW TUSUK DAISY MATA CM 8K ','','0.270','1','100.00','286000','0','0','15000','285000','0','0','0','285000','FIT','T0070779','B1H','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YGXD-29-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-09' AND kode_barang='B1H-YGXD-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090825491','2025-11-09','0.270','2025-11-09','08:25:50','PLG0025597','285000','285000','0','285000','285000','input','2025-11-09 08:25:49','F32509082549');
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-09','F325090825491','2025-11-09','08:25:50','FIT','285000','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-251109-0003','D','2025-11-09','08:25:50','input','PENJUALAN','F325090825491','588096000','285000','588381000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090857231','input','1',' MEA1 5K LG','TOKO','PM-A','A1E-YKXC-484-0','AT ANAK BONEKA CAT MATA VAR LG 8K ','','0.510','1','100.00','505000','0','0','15000','505000','0','5000','0','510000','ARF','00376414','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKXC-484-0' 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-09' AND kode_barang='A1E-YKXC-484-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090857231','2025-11-09','0.510','2025-11-09','08:57:23','PLG0025598','505000','505000','5000','510000','510000','input','2025-11-09 08:57:23','F32509085723');
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-09','F325090857231','2025-11-09','08:57:23','ARF','510000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251109-0004','D','2025-11-09','08:57:23','input','PENJUALAN','F325090857231','588381000','510000','588891000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090935091','input','1',' MDE2 10K C','TOKO','PM-E','E2D-YJXF-60-0','CC WEDDING MATA CM 18 8K ','','1.500','1','100.00','1455000','0','0','15000','1455000','0','10000','0','1465000','ARF','00372357','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXF-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YJXF-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090935091','2025-11-09','1.500','2025-11-09','09:35:09','PLG0025599','1455000','1455000','10000','1465000','1465000','input','2025-11-09 09:35:09','F32509093509');
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-09','F325090935091','2025-11-09','09:35:09','ARF','1465000','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-251109-0005','D','2025-11-09','09:35:09','input','PENJUALAN','F325090935091','588891000','1465000','590356000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1465000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325090935091' 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 ('F325090935092','input',' 1',' MEF3E X UB','TOKO','PM-F','F3E-YKXD-101-0','GL X CASTELI SLEP UB 8K ','','1.330','1','100.00','1317000','0','0','15000','1318000','0','0','0','1318000','ARF','00376637','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXD-101-0' 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-09' AND kode_barang='F3E-YKXD-101-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090935092','2025-11-09','1.330','2025-11-09','09:35:09','PLG0025600','1318000','1318000','0','1318000','1318000','input','2025-11-09 09:35:09','F32509093509');
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-09','F325090935092','2025-11-09','09:35:09','ARF','1318000','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-251109-0006','D','2025-11-09','09:35:09','input','PENJUALAN','F325090935092','590356000','1318000','591674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1318000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325090935092' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090935092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090935092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090935092';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090942511','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-YKXD-101-0','GL X CASTELI SLEP UB 8K ','','1.330','1','100.00','1317000','0','0','15000','1318000','0','0','0','1318000','ARF','00376637','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXD-101-0' 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-09' AND kode_barang='F3E-YKXD-101-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090942511','2025-11-09','1.330','2025-11-09','09:42:51','PLG0025601','1318000','1318000','0','1318000','1318000','kasir','2025-11-09 09:42:51','F32509094251');
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-09','F325090942511','2025-11-09','09:42:51','ARF','1318000','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-251109-0008','D','2025-11-09','09:42:51','kasir','PENJUALAN','F325090942511','590356000','1318000','591674000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090945061','kasir','1',' MEE1 X BM ','TOKO','PM-E','E1E-YJAC-189-0','CC X MODEL SLEP BM 13 8K ','','0.720','1','100.00','713000','0','0','15000','713000','0','0','0','713000','FIT','00372919','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAC-189-0' 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-09' AND kode_barang='E1E-YJAC-189-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090945061','2025-11-09','0.720','2025-11-09','09:45:06','PLG0025602','713000','713000','0','713000','713000','kasir','2025-11-09 09:45:06','F32509094506');
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-09','F325090945061','2025-11-09','09:45:06','FIT','713000','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-251109-0009','D','2025-11-09','09:45:06','kasir','PENJUALAN','F325090945061','591674000','713000','592387000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090952441','kasir','1',' MDE2 5K LG','TOKO','PM-E','E2D-YFAF-125-0','CC ANAK OSROT BONEKA CAT MATA VAR LG 8K','','1.070','1','100.00','1038000','0','0','15000','1038000','0','5000','0','1043000','FIT','00357767','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAF-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YFAF-125-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090952441','2025-11-09','1.070','2025-11-09','09:52:45','PLG0025603','1038000','1038000','5000','1043000','1043000','kasir','2025-11-09 09:52:44','F32509095244');
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-09','F325090952441','2025-11-09','09:52:45','FIT','1043000','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-251109-0010','D','2025-11-09','09:52:45','kasir','PENJUALAN','F325090952441','592387000','1043000','593430000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091009131','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-YJBG-124-0','CC WEDDING MATA CM 10 8K ','','1.520','1','100.00','1474000','0','0','15000','1475000','0','10000','0','1485000','ARF','00374916','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBG-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YJBG-124-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091009131','2025-11-09','1.520','2025-11-09','10:09:13','PLG0025604','1475000','1475000','10000','1485000','1485000','kasir','2025-11-09 10:09:13','F32509100913');
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-09','F325091009131','2025-11-09','10:09:13','ARF','1485000','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-251109-0011','D','2025-11-09','10:09:13','kasir','PENJUALAN','F325091009131','593430000','1485000','594915000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091049551','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-YKXH-178-0','CC X MODEL MATA CM 12 8K ','','0.910','1','100.00','892000','0','0','15000','883000','0','0','0','883000','ARF','00376961','E2D','0','0','-','1','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKXH-178-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YKXH-178-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091049551','2025-11-09','0.910','2025-11-09','10:49:55','PLG0025605','883000','883000','0','883000','883000','kasir','2025-11-09 10:49:55','F32509104955');
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-09','F325091049551','2025-11-09','10:49:55','ARF','883000','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-251109-0012','D','2025-11-09','10:49:55','kasir','PENJUALAN','F325091049551','594915000','883000','595798000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091059091','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-YJXF-61-0','CC WEDDING MATA CM 18 8K ','','1.520','1','100.00','1474000','0','0','15000','1475000','0','10000','0','1485000','FIT','00372358','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXF-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YJXF-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091059091','2025-11-09','1.520','2025-11-09','10:59:10','PLG0025606','1475000','1475000','10000','1485000','1485000','kasir','2025-11-09 10:59:09','F32509105909');
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-09','F325091059091','2025-11-09','10:59:10','FIT','1485000','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-251109-0013','D','2025-11-09','10:59:10','kasir','PENJUALAN','F325091059091','595798000','1485000','597283000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091112051','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-YEAF-6-0','KL X NORY UB 42 8K ','','2.060','1','100.00','2039000','0','0','15000','2040000','0','0','0','2040000','ARF','00354246','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YEAF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='H1E-YEAF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091112051','2025-11-09','2.060','2025-11-09','11:12:05','PLG0025607','2040000','2040000','0','2040000','2040000','kasir','2025-11-09 11:12:05','F32509111205');
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-09','F325091112051','2025-11-09','11:12:05','ARF','2040000','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-251109-0014','D','2025-11-09','11:12:05','kasir','PENJUALAN','F325091112051','597283000','2040000','599323000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091115591','kasir','1',' MEE1 X HW ','TOKO','PM-E','E1E-YHXI-213-0','CC X MODEL SLEP HW 13 8K ','','0.610','1','100.00','604000','0','0','15000','605000','0','0','0','605000','FIT','00365077','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXI-213-0' 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-09' AND kode_barang='E1E-YHXI-213-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091115591','2025-11-09','0.610','2025-11-09','11:15:59','PLG0025608','605000','605000','0','605000','605000','kasir','2025-11-09 11:15:59','F32509111559');
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-09','F325091115591','2025-11-09','11:15:59','FIT','605000','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-251109-0015','D','2025-11-09','11:15:59','kasir','PENJUALAN','F325091115591','599323000','605000','599928000');
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-00017421','X-00017421','GL TRIXIE BUNGA ARESO VAR YT 8K','GR','---','F3E','BELI','BELI001','930000','2025-11-09','1.210','1','kasir','2025-11-09 11:30:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017421','X-00017421');
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-251109-0001','F325030841401','ARF','1','BELI','BELI001','F3E', 'X-00017421', 'GL TRIXIE BUNGA ARESO VAR YT 8K','1.210','1.210','100.00','1002000','930000','768595','1000000','1','930000','930000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-09' 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-251109-0001','2025-11-09','2025-11-09','11:30:38','ARF','---','1.210','930000','930000','930000','930000','930000','kasir','2025-11-09 11:30:39','FB-251109-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0001','ALBRE','SENDANG','','','','kasir','2025-11-09 11:30:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0016','K','2025-11-09','11:30:38','kasir','PEMBELIAN UMUM','FB-251109-0001','599928000','930000','598998000');
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-00017422','X-00017422','LT X BONEKA ANAK CAT LG 8K','GR','---','D1F','BELI','BELI001','215000','2025-11-09','0.400','1','kasir','2025-11-09 11:31:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00017422','X-00017422');
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-251109-0002','F324171043231','FIT','1','BELI','BELI001','D1F', 'X-00017422', 'LT X BONEKA ANAK CAT LG 8K','0.400','0.400','100.00','250000','215000','537500','1020000','1','215000','215000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-251109-0002','2025-11-09','2025-11-09','11:31:02','FIT','---','0.400','215000','215000','215000','215000','215000','kasir','2025-11-09 11:31:02','FB-251109-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0002','FELLYCIA ALEXANDRIA S','JATISARI BITING PURWANTORO','','','','kasir','2025-11-09 11:31:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0017','K','2025-11-09','11:31:02','kasir','PEMBELIAN UMUM','FB-251109-0002','598998000','215000','598783000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091144401','kasir','1',' MFE2 X UB ','TOKO','PM-E','E2F-YEAI-248-0','CC X MODEL SLEP UB 10 8K ','','0.450','1','100.00','454000','0','0','15000','455000','0','0','0','455000','FIT','00354732','E2F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-YEAI-248-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2F-YEAI-248-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091144401','2025-11-09','0.450','2025-11-09','11:44:41','PLG0025609','455000','455000','0','455000','455000','kasir','2025-11-09 11:44:40','F32509114440');
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-09','F325091144401','2025-11-09','11:44:41','FIT','455000','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-251109-0018','D','2025-11-09','11:44:41','kasir','PENJUALAN','F325091144401','598783000','455000','599238000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091145501','kasir','1',' MDE2 YT 16','TOKO','PM-E','E2D-YDXD-17-0','CC MODEL MATA SLEP YT 16 8K ','','0.830','1','100.00','805000','0','0','15000','805000','0','0','0','805000','ARF','00347910','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YDXD-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YDXD-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091145501','2025-11-09','0.830','2025-11-09','11:45:51','PLG0025610','805000','805000','0','805000','805000','kasir','2025-11-09 11:45:50','F32509114550');
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-09','F325091145501','2025-11-09','11:45:51','ARF','805000','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-251109-0019','D','2025-11-09','11:45:51','kasir','PENJUALAN','F325091145501','599238000','805000','600043000');
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-00017423','X-00017423','CC COR T 8K','GR','---','E1D','BELI','BELI001','620000','2025-11-09','0.930','1','kasir','2025-11-09 11:50:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017423','X-00017423');
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-251109-0003','t0065909','ARF','1','BELI','BELI001','E1D', 'X-00017423', 'CC COR T 8K','0.930','0.930','100.00','701000','620000','666667','980000','1','620000','620000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251109-0003','2025-11-09','2025-11-09','11:50:26','ARF','---','0.930','620000','620000','620000','620000','620000','kasir','2025-11-09 11:50:26','FB-251109-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0003','NIA YUYUN','-','','','','kasir','2025-11-09 11:50:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0020','K','2025-11-09','11:50:26','kasir','PEMBELIAN UMUM','FB-251109-0003','600043000','620000','599423000');
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-00017424','X-00017424','GW X MODEL MATA LG PE 8K','GR','---','B1F','BELI','BELI001','140000','2025-11-09','0.290','1','kasir','2025-11-09 11:51:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017424','X-00017424');
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-251109-0004','F324270244162','ARF','1','BELI','BELI001','B1F', 'X-00017424', 'GW X MODEL MATA LG PE 8K','0.560','0.290','100.00','378000','140000','482759','1020000','1','140000','140000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.290',berat_beli_asli=berat_beli_asli+'0.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.290',berat_akhir_asli=berat_akhir_asli+'0.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251109-0004','2025-11-09','2025-11-09','11:51:50','ARF','---','0.290','140000','140000','140000','140000','140000','kasir','2025-11-09 11:51:50','FB-251109-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0004','KENAYU','JATISARI BITING','','','','kasir','2025-11-09 11:51:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0021','K','2025-11-09','11:51:50','kasir','PEMBELIAN UMUM','FB-251109-0004','599423000','140000','599283000');
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-00017425','X-00017425','GL X BANGKOK TIMBUL SLEP PM 58 8K','GR','---','F1E','BELI','BELI001','4938000','2025-11-09','6.000','1','kasir','2025-11-09 11:52:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017425','X-00017425');
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-251109-0005','F325130221501','ARF','1','BELI','BELI001','F1E', 'X-00017425', 'GL X BANGKOK TIMBUL SLEP PM 58 8K','6.000','6.000','100.00','5310000','4938000','823000','1000000','1','4938000','4938000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.000',berat_beli_asli=berat_beli_asli+'6.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.000',berat_akhir_asli=berat_akhir_asli+'6.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-09' 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-251109-0005','2025-11-09','2025-11-09','11:52:29','ARF','---','6.000','4938000','4938000','4938000','4938000','4938000','kasir','2025-11-09 11:52:30','FB-251109-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0005','MARTINI','SUKOMANGU','','','','kasir','2025-11-09 11:52:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0022','K','2025-11-09','11:52:29','kasir','PEMBELIAN UMUM','FB-251109-0005','599283000','4938000','594345000');
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-00017426','X-00017426','GL COR T 8K','GR','---','F1E','BELI','BELI001','3990000','2025-11-09','5.020','1','kasir','2025-11-09 11:54:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017426','X-00017426');
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-251109-0006','00364764','ARF','1','BELI','BELI001','F1E', 'X-00017426', 'GL COR T 8K','5.020','5.020','100.00','4338000','3990000','794821','1000000','1','3990000','3990000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.020',berat_beli_asli=berat_beli_asli+'5.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.020',berat_akhir_asli=berat_akhir_asli+'5.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-09' 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-251109-0006','2025-11-09','2025-11-09','11:54:06','ARF','---','5.020','3990000','3990000','3990000','3990000','3990000','kasir','2025-11-09 11:54:06','FB-251109-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0006','ENDANG','BULUKERTO','','','081578073566','kasir','2025-11-09 11:54:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0023','K','2025-11-09','11:54:06','kasir','PEMBELIAN UMUM','FB-251109-0006','594345000','3990000','590355000');
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-00017427','X-00017427','GW TOGE MODEL MATA VAR LG 8K','GR','---','B1F','BELI','BELI001','440000','2025-11-09','0.470','1','kasir','2025-11-09 11:54:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017427','X-00017427');
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-251109-0007','F325210843471','ARF','1','BELI','BELI001','B1F', 'X-00017427', 'GW TOGE MODEL MATA VAR LG 8K','0.470','0.470','100.00','520000','440000','936170','1020000','1','440000','440000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251109-0007','2025-11-09','2025-11-09','11:54:49','ARF','---','0.470','440000','440000','440000','440000','440000','kasir','2025-11-09 11:54:50','FB-251109-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0007','MITA','STREN LEMAHBANG','','','','kasir','2025-11-09 11:54:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0024','K','2025-11-09','11:54:49','kasir','PEMBELIAN UMUM','FB-251109-0007','590355000','440000','589915000');
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-00017428','X-00017428','CC MODEL SLEP BM 16 8K','GR','---','E1D','BELI','BELI001','945000','2025-11-09','1.240','1','kasir','2025-11-09 12:03:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017428','X-00017428');
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-251109-0008','F325250801231','ARF','1','BELI','BELI001','E1D', 'X-00017428', 'CC MODEL SLEP BM 16 8K','1.240','1.240','100.00','1020000','945000','762097','980000','1','945000','945000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.240',berat_beli_asli=berat_beli_asli+'1.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.240',berat_akhir_asli=berat_akhir_asli+'1.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251109-0008','2025-11-09','2025-11-09','12:03:21','ARF','---','1.240','945000','945000','945000','945000','945000','kasir','2025-11-09 12:03:22','FB-251109-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251109-0008','SUKIYEM','PUHNUNGGAL GAMBIRANOM','','','','kasir','2025-11-09 12:03:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251109-0025','K','2025-11-09','12:03:21','kasir','PEMBELIAN UMUM','FB-251109-0008','589915000','945000','588970000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325091255391','kasir','1',' MDD2D X YT','TOKO','PM-D','D2D-YKXC-342-0','LT X MODEL MATA YT 8K ','','0.810','1','100.00','786000','0','0','15000','786000','0','0','0','786000','FIT','00376270','D2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YKXC-342-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='D2D-YKXC-342-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091255391','2025-11-09','0.810','2025-11-09','12:55:40','PLG0025611','786000','786000','0','786000','786000','kasir','2025-11-09 12:55:39','F32509125539');
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-09','F325091255391','2025-11-09','12:55:40','FIT','786000','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-251109-0026','D','2025-11-09','12:55:40','kasir','PENJUALAN','F325091255391','588970000','786000','589756000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='786000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325091255391' 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 ('F325091255392','kasir',' 1',' MEH1 KH 44','TOKO','PM-H','H1E-YKXC-373-0','KL NORY KH 44CM 8K ','','3.070','1','100.00','3039000','0','0','15000','3039000','0','0','0','3039000','FIT','00376301','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXC-373-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='H1E-YKXC-373-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325091255392','2025-11-09','3.070','2025-11-09','12:55:40','PLG0025612','3039000','3039000','0','3039000','3039000','kasir','2025-11-09 12:55:39','F32509125539');
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-09','F325091255392','2025-11-09','12:55:40','FIT','3039000','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-251109-0027','D','2025-11-09','12:55:40','kasir','PENJUALAN','F325091255392','589756000','3039000','592795000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3039000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325091255392' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091255392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091255392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091255392';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090101001','kasir','1',' MEH1 KH 44','TOKO','PM-H','H1E-YKXC-373-0','KL NORY KH 44CM 8K ','','3.070','1','100.00','3039000','0','0','15000','3039000','0','0','0','3039000','FIT','00376301','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXC-373-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='H1E-YKXC-373-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090101001','2025-11-09','3.070','2025-11-09','13:01:00','PLG0025613','3039000','3039000','0','3039000','3039000','kasir','2025-11-09 13:01:00','F32509010100');
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-09','F325090101001','2025-11-09','13:01:00','FIT','3039000','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-251109-0029','D','2025-11-09','13:01:00','kasir','PENJUALAN','F325090101001','589756000','3039000','592795000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090101001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090101001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090101001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090106531','kasir','1',' MEH1 KH 44','TOKO','PM-H','H1E-YKXC-373-0','KL NORY KH 44CM 8K ','','3.070','1','100.00','3039000','0','0','15000','3039000','0','0','0','3039000','ARF','00376301','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXC-373-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='H1E-YKXC-373-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090106531','2025-11-09','3.070','2025-11-09','13:06:54','PLG0025614','3039000','3039000','0','3039000','3039000','kasir','2025-11-09 13:06:53','F32509010653');
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-09','F325090106531','2025-11-09','13:06:54','ARF','3039000','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-251109-0031','D','2025-11-09','13:06:54','kasir','PENJUALAN','F325090106531','589756000','3039000','592795000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090120141','kasir','1',' MDE2 5K PM','TOKO','PM-E','E2D-XKBH-188-0','CC MODEL MATA VAR PM 14 8K ','','1.010','1','100.00','980000','0','0','15000','980000','0','5000','0','985000','FIT','00327740','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-XKBH-188-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-XKBH-188-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090120141','2025-11-09','1.010','2025-11-09','13:20:15','PLG0025615','980000','980000','5000','985000','985000','kasir','2025-11-09 13:20:14','F32509012014');
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-09','F325090120141','2025-11-09','13:20:15','FIT','985000','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-251109-0032','D','2025-11-09','13:20:15','kasir','PENJUALAN','F325090120141','592795000','985000','593780000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090204411','kasir','1',' MEF3E LT ','TOKO','PM-F','F3E-YJBA-263-0','GL VERONICA SLEP LT 8K ','','1.060','1','100.00','1049000','0','0','15000','1050000','0','0','0','1050000','FIT','00374140','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBA-263-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='F3E-YJBA-263-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090204411','2025-11-09','1.060','2025-11-09','14:04:41','PLG0025616','1050000','1050000','0','1050000','1050000','kasir','2025-11-09 14:04:41','F32509020441');
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-09','F325090204411','2025-11-09','14:04:41','FIT','1050000','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-251109-0033','D','2025-11-09','14:04:41','kasir','PENJUALAN','F325090204411','593780000','1050000','594830000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090222041','input','1',' MEA1E X UB','TOKO','PM-A','A1E-YIAE-14-0','AT X ITALY SLEP VAR UB 8K ','','1.000','1','100.00','990000','0','0','15000','990000','0','0','0','990000','FIT','00369465','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YIAE-14-0' 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-09' AND kode_barang='A1E-YIAE-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090222041','2025-11-09','1.000','2025-11-09','14:22:04','PLG0025617','990000','990000','0','990000','990000','input','2025-11-09 14:22:04','F32509022204');
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-09','F325090222041','2025-11-09','14:22:04','FIT','990000','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-251109-0034','D','2025-11-09','14:22:04','input','PENJUALAN','F325090222041','594830000','990000','595820000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090222421','input','1',' MDE1 X YS ','TOKO','PM-E','E1D-YJBC-178-0','CC X VELG SLEP YS 16 8K ','','1.000','1','100.00','970000','0','0','15000','970000','0','0','0','970000','FIT','00374496','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBC-178-0' 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-09' AND kode_barang='E1D-YJBC-178-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090222421','2025-11-09','1.000','2025-11-09','14:22:42','PLG0025618','970000','970000','0','970000','970000','input','2025-11-09 14:22:42','F32509022242');
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-09','F325090222421','2025-11-09','14:22:42','FIT','970000','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-251109-0035','D','2025-11-09','14:22:42','input','PENJUALAN','F325090222421','595820000','970000','596790000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090234461','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-YFAA-41-0','CC X MODEL MATA LG 16 8K ','','0.960','1','100.00','931000','0','0','15000','931000','0','0','0','931000','FIT','00357003','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAA-41-0' 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-11-09' AND kode_barang='E2D-YFAA-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090234461','2025-11-09','0.960','2025-11-09','14:34:47','PLG0025619','931000','931000','0','931000','931000','input','2025-11-09 14:34:46','F32509023446');
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-09','F325090234461','2025-11-09','14:34:47','FIT','931000','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-251109-0036','D','2025-11-09','14:34:47','input','PENJUALAN','F325090234461','596790000','931000','597721000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090236211','input','1',' MDE2 X UB ','TOKO','PM-E','E2D-YEXA-210-0','CC X MODEL MATA UB 16 8K ','','1.210','1','100.00','1174000','0','0','15000','1175000','0','10000','0','1185000','ARF','00351803','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEXA-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='E2D-YEXA-210-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090236211','2025-11-09','1.210','2025-11-09','14:36:22','PLG0025620','1175000','1175000','10000','1185000','1185000','input','2025-11-09 14:36:21','F32509023621');
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-09','F325090236211','2025-11-09','14:36:22','ARF','1185000','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-251109-0037','D','2025-11-09','14:36:22','input','PENJUALAN','F325090236211','597721000','1185000','598906000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325090238371','input','1',' MEB1 X LG ','TOKO','PM-B','B1E-XHXE-90-0','GW X DAISY MATA LG PE 8K ','','1.610','1','100.00','1594000','0','0','15000','1594000','0','10000','0','1604000','FIT','00310583','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-XHXE-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-11-09' AND kode_barang='B1E-XHXE-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325090238371','2025-11-09','1.610','2025-11-09','14:38:38','PLG0025621','1594000','1594000','10000','1604000','1604000','input','2025-11-09 14:38:37','F32509023837');
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-09','F325090238371','2025-11-09','14:38:38','FIT','1604000','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-251109-0038','D','2025-11-09','14:38:38','input','PENJUALAN','F325090238371','598906000','1604000','600510000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090106531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090106531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090106531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090120141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090120141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090120141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090204411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090204411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090204411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090222041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090222041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090222041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090222421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090222421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090222421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090234461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090234461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090234461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090236211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090236211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090236211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090238371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090238371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090238371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090825011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090825011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090825011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090825491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090825491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090825491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090857231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090857231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090857231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090935091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090935091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090935091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090942511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090942511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090942511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090945061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090945061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090945061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325090952441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325090952441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325090952441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091009131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091009131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091009131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091049551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091049551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091049551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091059091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091059091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091059091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091112051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091112051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091112051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091115591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091115591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091115591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091144401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091144401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091144401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091145501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091145501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091145501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325091255391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325091255391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325091255391';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251109-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251109-0008';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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-11-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-09';
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-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-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-251110-0001','D','2025-11-10','16:05:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','600510000','600510000');
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-251110-0001','D','2025-11-10','16:05:03','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-251110-0001','D','2025-11-10','16:05:03','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-251110-0001','D','2025-11-10','16:05:03','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-11-10';