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 ('F225070950341','kasir','1',' MEH1 15K H','TOKO','SMBK-H','H1E-YJXB-42-T','KL SANTA MODEL BOLA PASIR VAR HW 8K ','OL ','2.180','1','100.00','2130000','0','0','15000','2158000','0','15000','0','2173000','RHM','T0073622','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXB-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='H1E-YJXB-42-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 ('F225070950341','2025-10-07','2.180','2025-10-07','09:50:34','PLG0073385','2158000','2158000','15000','2173000','2173000','kasir','2025-10-07 09:50:34','F22507095034');
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-07','F225070950341','2025-10-07','09:50:34','RHM','2173000','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-251007-0002','D','2025-10-07','09:50:34','kasir','PENJUALAN','F225070950341','1163632000','2173000','1165805000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2173000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070950341' 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 ('F225070950342','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJXB-46-T','KL SANTA MODEL HATI PASIR VAR HW 8K ','OL ','1.950','1','100.00','1905000','0','0','15000','1934000','0','10000','0','1944000','RHM','T0073626','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXB-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='H1E-YJXB-46-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 ('F225070950342','2025-10-07','1.950','2025-10-07','09:50:34','PLG0073386','1934000','1934000','10000','1944000','1944000','kasir','2025-10-07 09:50:34','F22507095034');
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-07','F225070950342','2025-10-07','09:50:34','RHM','1944000','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-251007-0003','D','2025-10-07','09:50:34','kasir','PENJUALAN','F225070950342','1165805000','1944000','1167749000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1944000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070950342' 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 ('F225070955311','kasir','1',' MEF1 YT D5','TOKO','SMBK-F','F1E-YJXC-71-T','GL OVAL MODEL HATI SLEP YT D54 8K ','OL ','1.690','1','100.00','1648000','0','0','15000','1677000','0','8000','0','1685000','RHM','T0073792','F1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJXC-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.690',berat_jual_asli=berat_jual_asli+'1.690',stock_jual='1',berat_akhir=berat_akhir-'1.690',berat_akhir_asli=berat_akhir_asli-'1.690',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F1E-YJXC-71-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 ('F225070955311','2025-10-07','1.690','2025-10-07','09:55:32','PLG0073387','1677000','1677000','8000','1685000','0','kasir','2025-10-07 09:55:31','F22507095531');
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-07','F225070955311','2025-10-07','09:55:32','RHM','1685000','8000');
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-251007-0001','2025-10-07','2025-10-07 09:55:31','PENJUALAN : F225070955311','6586538636838','BCA','1685000','1685000','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-251007-0002','D','2025-10-07','09:55:32','BCA','PENJUALAN','F225070955311','4027844888','1685000','4029529888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('6586538636838','HHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1685000' WHERE no_faktur_jual='F225070955311' 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 ('F225071001321','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-90-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073670','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-90-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXB-90-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001321','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073388','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001321','2025-10-07','10:01:32','RHM','401000','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-251007-0004','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001321','1167749000','401000','1168150000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001321' 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 ('F225071001322','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-91-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073671','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXB-91-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001322','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073389','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001322','2025-10-07','10:01:32','RHM','401000','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-251007-0005','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001322','1168150000','401000','1168551000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001322' 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 ('F225071001323','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-92-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073672','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXB-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001323','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073390','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001323','2025-10-07','10:01:32','RHM','401000','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-251007-0006','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001323','1168551000','401000','1168952000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001323' 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 ('F225071001324','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-93-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073673','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXB-93-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001324','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073391','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001324','2025-10-07','10:01:32','RHM','401000','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-251007-0007','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001324','1168952000','401000','1169353000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001324' 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 ('F225071001325','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-94-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073674','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXB-94-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001325','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073392','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001325','2025-10-07','10:01:32','RHM','401000','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-251007-0008','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001325','1169353000','401000','1169754000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001325' 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 ('F225071001326','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXC-87-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073808','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXC-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXC-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001326','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073393','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001326','2025-10-07','10:01:32','RHM','401000','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-251007-0009','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001326','1169754000','401000','1170155000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001326' 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 ('F225071001327','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXC-88-T','AS EXTENSION UB 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073809','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXC-88-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXC-88-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071001327','2025-10-07','0.380','2025-10-07','10:01:32','PLG0073394','396000','396000','5000','401000','401000','kasir','2025-10-07 10:01:32','F22507100132');
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-07','F225071001327','2025-10-07','10:01:32','RHM','401000','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-251007-0010','D','2025-10-07','10:01:32','kasir','PENJUALAN','F225071001327','1170155000','401000','1170556000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071001327' 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 ('F225071008471','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXC-91-T','AS EXTENSION UB 8K ','OL ','0.450','1','100.00','458000','0','0','15000','469000','0','5000','0','474000','RHM','T0073812','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXC-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='S1G-YJXC-91-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071008471','2025-10-07','0.450','2025-10-07','10:08:48','PLG0073395','469000','469000','5000','474000','474000','kasir','2025-10-07 10:08:47','F22507100847');
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-07','F225071008471','2025-10-07','10:08:48','RHM','474000','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-251007-0011','D','2025-10-07','10:08:48','kasir','PENJUALAN','F225071008471','1170556000','474000','1171030000');
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 ('F225071015031','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-85-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073665','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-85-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-07' AND kode_barang='S1G-YJXB-85-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015031','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073396','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015031','2025-10-07','10:15:03','RHM','484000','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-251007-0012','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015031','1171030000','484000','1171514000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015031' 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 ('F225071015032','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-86-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073666','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-86-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-07' AND kode_barang='S1G-YJXB-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015032','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073397','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015032','2025-10-07','10:15:03','RHM','484000','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-251007-0013','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015032','1171514000','484000','1171998000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015032' 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 ('F225071015033','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-87-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073667','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-87-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-07' AND kode_barang='S1G-YJXB-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015033','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073398','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015033','2025-10-07','10:15:03','RHM','484000','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-251007-0014','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015033','1171998000','484000','1172482000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015033' 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 ('F225071015034','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-88-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073668','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-88-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-07' AND kode_barang='S1G-YJXB-88-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015034','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073399','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015034','2025-10-07','10:15:03','RHM','484000','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-251007-0015','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015034','1172482000','484000','1172966000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015034' 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 ('F225071015035','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXB-89-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073669','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXB-89-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-07' AND kode_barang='S1G-YJXB-89-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015035','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073400','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015035','2025-10-07','10:15:03','RHM','484000','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-251007-0016','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015035','1172966000','484000','1173450000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015035' 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 ('F225071015036','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXC-90-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073811','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXC-90-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-07' AND kode_barang='S1G-YJXC-90-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015036','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073401','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015036','2025-10-07','10:15:03','RHM','484000','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-251007-0017','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015036','1173450000','484000','1173934000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015036' 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 ('F225071015037','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXC-92-T','AS EXTENSION UB 8K ','OL ','0.460','1','100.00','468000','0','0','15000','479000','0','5000','0','484000','RHM','T0073813','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXC-92-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-07' AND kode_barang='S1G-YJXC-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071015037','2025-10-07','0.460','2025-10-07','10:15:03','PLG0073402','479000','479000','5000','484000','484000','kasir','2025-10-07 10:15:03','F22507101503');
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-07','F225071015037','2025-10-07','10:15:03','RHM','484000','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-251007-0018','D','2025-10-07','10:15:03','kasir','PENJUALAN','F225071015037','1173934000','484000','1174418000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='484000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071015037' 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 ('F225071016231','kasir','1',' MEF3 40K H','TOKO','SMBK-F','F3E-YJXF-68-T','GL PREMIER BOLA HATI VAR HW 8K ','OL ','4.020','1','100.00','3928000','0','0','15000','3988000','0','40000','0','4028000','RHM','T0073966','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YJXF-68-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 ('F225071016231','2025-10-07','4.020','2025-10-07','10:16:24','PLG0073403','3988000','3988000','40000','4028000','4028000','kasir','2025-10-07 10:16:23','F22507101623');
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-07','F225071016231','2025-10-07','10:16:24','RHM','4028000','40000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251007-0019','D','2025-10-07','10:16:24','kasir','PENJUALAN','F225071016231','1174418000','4028000','1178446000');
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 ('F225071020141','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-13-T','AT KLIP BANGKOK SLEP LG 8K ','OL ','0.600','1','100.00','585000','0','0','15000','600000','0','5000','0','605000','RHM','T0073827','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='A1E-YJXD-13-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 ('F225071020141','2025-10-07','0.600','2025-10-07','10:20:14','PLG0073404','600000','600000','5000','605000','605000','kasir','2025-10-07 10:20:14','F22507102014');
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-07','F225071020141','2025-10-07','10:20:14','RHM','605000','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-251007-0020','D','2025-10-07','10:20:14','kasir','PENJUALAN','F225071020141','1178446000','605000','1179051000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071020141' 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 ('F225071020142','kasir',' 1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-14-T','AT KLIP BANGKOK SLEP LG 8K ','OL ','0.600','1','100.00','585000','0','0','15000','600000','0','5000','0','605000','RHM','T0073828','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='A1E-YJXD-14-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 ('F225071020142','2025-10-07','0.600','2025-10-07','10:20:14','PLG0073405','600000','600000','5000','605000','605000','kasir','2025-10-07 10:20:14','F22507102014');
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-07','F225071020142','2025-10-07','10:20:14','RHM','605000','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-251007-0021','D','2025-10-07','10:20:14','kasir','PENJUALAN','F225071020142','1179051000','605000','1179656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071020142' 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 ('F225071022361','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXF-83-T','LT SLOBOK BALOK HURUF BG N 8K ','OL S S4CB','0.420','1','100.00','427000','0','0','15000','442000','0','82000','0','524000','RHM','T0073981','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXF-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1G-YJXF-83-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 ('F225071022361','2025-10-07','0.420','2025-10-07','10:22:36','PLG0073406','442000','442000','82000','524000','524000','kasir','2025-10-07 10:22:36','F22507102236');
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-07','F225071022361','2025-10-07','10:22:36','RHM','524000','82000');
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-251007-0022','D','2025-10-07','10:22:36','kasir','PENJUALAN','F225071022361','1179656000','524000','1180180000');
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 ('F225071024011','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-YJXB-57-T','AT JERSY SLEP CM 8K ','OL ','0.500','1','100.00','488000','0','0','15000','499000','0','5000','0','504000','RHM','T0073637','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXB-57-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-07' AND kode_barang='A1E-YJXB-57-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 ('F225071024011','2025-10-07','0.500','2025-10-07','10:24:01','PLG0073407','499000','499000','5000','504000','0','kasir','2025-10-07 10:24:01','F22507102401');
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-07','F225071024011','2025-10-07','10:24:01','RHM','504000','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-251007-0002','2025-10-07','2025-10-07 10:24:01','PENJUALAN : F225071024011','67337537637643734','BCA','504000','504000','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-251007-0003','D','2025-10-07','10:24:01','BCA','PENJUALAN','F225071024011','4029529888','504000','4030033888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('67337537637643734','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='504000' WHERE no_faktur_jual='F225071024011' 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 ('F225071058331','kasir','1',' MDE2 CM 22','TOKO','SMBK-E','E2D-YIBI-140-0','CC MODEL MATA VAR CM 22 8K ','OLH','2.130','1','100.00','2045000','0','0','15000','2113000','0','21000','0','2134000','RTA','00371011','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBI-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E2D-YIBI-140-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 ('F225071058331','2025-10-07','2.130','2025-10-07','10:58:34','PLG0073408','2113000','2113000','21000','2134000','0','kasir','2025-10-07 10:58:33','F22507105833');
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-07','F225071058331','2025-10-07','10:58:34','RTA','2134000','21000');
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-251007-0003','2025-10-07','2025-10-07 10:58:33','PENJUALAN : F225071058331','98089877665','BCA','2134000','2134000','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-251007-0004','D','2025-10-07','10:58:34','BCA','PENJUALAN','F225071058331','4030033888','2134000','4032167888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('98089877665','YULI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2134000' WHERE no_faktur_jual='F225071058331' 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 ('F225071059101','kasir','1',' MEB1 CM ','TOKO','SMBK-B','B1E-YJXD-79-T','GW SUMPING MODEL DAUN VAR CM 8K ','OLH','0.650','1','100.00','634000','0','0','15000','651000','0','8000','0','659000','RTA','T0073893','B1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-79-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-07' AND kode_barang='B1E-YJXD-79-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071059101','2025-10-07','0.650','2025-10-07','10:59:10','PLG0073409','651000','651000','8000','659000','0','kasir','2025-10-07 10:59:10','F22507105910');
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-07','F225071059101','2025-10-07','10:59:10','RTA','659000','8000');
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-251007-0004','2025-10-07','2025-10-07 10:59:10','PENJUALAN : F225071059101','878787766765','BCA','659000','659000','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-251007-0005','D','2025-10-07','10:59:10','BCA','PENJUALAN','F225071059101','4032167888','659000','4032826888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('878787766765','YULI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='659000' WHERE no_faktur_jual='F225071059101' 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 ('F225071130341','kasir','1',' MDE2 10K U','TOKO','SMBK-E','E2D-YHXE-73-T','CC MODEL MATA VAR UB 13 8K ','','1.300','1','100.00','1183000','0','0','15000','1257000','0','10000','0','1267000','TIN','T0071862','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHXE-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E2D-YHXE-73-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 ('F225071130341','2025-10-07','1.300','2025-10-07','11:30:34','PLG0073410','1257000','1257000','10000','1267000','1267000','kasir','2025-10-07 11:30:34','F22507113034');
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-07','F225071130341','2025-10-07','11:30:34','TIN','1267000','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-251007-0023','D','2025-10-07','11:30:34','kasir','PENJUALAN','F225071130341','1180180000','1267000','1181447000');
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 ('F225071143451','kasir','1',' MEF3 10K H','TOKO','SMBK-F','F3E-YICX-12-T','GL SANTA MODEL HATI PASIR HW 8K ','OL ','1.430','1','100.00','1356000','0','0','15000','1423000','0','10000','0','1433000','RHM','T0073424','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YICX-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YICX-12-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 ('F225071143451','2025-10-07','1.430','2025-10-07','11:43:45','PLG0073411','1423000','1423000','10000','1433000','1433000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143451','2025-10-07','11:43:45','RHM','1433000','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-251007-0024','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143451','1181447000','1433000','1182880000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1433000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143451' 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 ('F225071143452','kasir',' 1',' MIF4I X UB','TOKO','SMBK-F','F4I-XAAB-98-0','GL X KAKI SANTA UB 9K ','OL ','4.710','1','100.00','4978000','0','0','15000','5072000','0','24000','0','5096000','RHM','00274471','F4I','0','0','-','0','1057000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-XAAB-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.710',berat_jual_asli=berat_jual_asli+'4.710',stock_jual='1',berat_akhir=berat_akhir-'4.710',berat_akhir_asli=berat_akhir_asli-'4.710',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F4I-XAAB-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071143452','2025-10-07','4.710','2025-10-07','11:43:45','PLG0073412','5072000','5072000','24000','5096000','5096000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143452','2025-10-07','11:43:45','RHM','5096000','24000');
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-251007-0025','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143452','1182880000','5096000','1187976000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5096000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143452' 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 ('F225071143453','kasir',' 1',' MFF3 27K B','TOKO','SMBK-F','F3F-YJXB-2-T','GL KREPYAK PASIR BG 8K ','OL ','5.310','1','100.00','5294000','0','0','15000','5400000','0','27000','0','5427000','RHM','T0073582','F3F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJXB-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.310',berat_jual_asli=berat_jual_asli+'5.310',stock_jual='1',berat_akhir=berat_akhir-'5.310',berat_akhir_asli=berat_akhir_asli-'5.310',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3F-YJXB-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071143453','2025-10-07','5.310','2025-10-07','11:43:45','PLG0073413','5400000','5400000','27000','5427000','5427000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143453','2025-10-07','11:43:45','RHM','5427000','27000');
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-251007-0026','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143453','1187976000','5427000','1193403000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5427000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143453' 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 ('F225071143454','kasir',' 1',' MEF3 5K HW','TOKO','SMBK-F','F3E-YJXA-11-T','GL SANTA SERUT HATI CAT VAR HW 8K ','OL ','1.460','1','100.00','1384000','0','0','15000','1456000','0','7000','0','1463000','RHM','T0073503','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXA-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YJXA-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071143454','2025-10-07','1.460','2025-10-07','11:43:45','PLG0073414','1456000','1456000','7000','1463000','1463000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143454','2025-10-07','11:43:45','RHM','1463000','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-251007-0027','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143454','1193403000','1463000','1194866000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1463000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143454' 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 ('F225071143455','kasir',' 1',' MEF3E X UB','TOKO','SMBK-F','F3E-YJXA-288-0','GL X TIFF RIBBON VAR SERUT UB ','OL ','1.390','1','100.00','1358000','0','0','15000','1386000','0','7000','0','1393000','RHM','00371533','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXA-288-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YJXA-288-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071143455','2025-10-07','1.390','2025-10-07','11:43:45','PLG0073415','1386000','1386000','7000','1393000','1393000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143455','2025-10-07','11:43:45','RHM','1393000','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-251007-0028','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143455','1194866000','1393000','1196259000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1393000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143455' 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 ('F225071143456','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-YJXA-287-0','GL X TIFF SLEP HW 8K ','OL ','1.430','1','100.00','1397000','0','0','15000','1426000','0','7000','0','1433000','RHM','00371532','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXA-287-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YJXA-287-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071143456','2025-10-07','1.430','2025-10-07','11:43:45','PLG0073416','1426000','1426000','7000','1433000','1433000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143456','2025-10-07','11:43:45','RHM','1433000','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-251007-0029','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143456','1196259000','1433000','1197692000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1433000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143456' 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 ('F225071143457','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-YJXA-286-0','GL X TIFF SPECTRA HTAM VAR YT 8K ','OL ','1.200','1','100.00','1172000','0','0','15000','1196000','0','6000','0','1202000','RHM','00371531','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXA-286-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YJXA-286-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071143457','2025-10-07','1.200','2025-10-07','11:43:45','PLG0073417','1196000','1196000','6000','1202000','1202000','kasir','2025-10-07 11:43:45','F22507114345');
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-07','F225071143457','2025-10-07','11:43:45','RHM','1202000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251007-0030','D','2025-10-07','11:43:45','kasir','PENJUALAN','F225071143457','1197692000','1202000','1198894000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1202000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071143457' 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 ('F225071145061','kasir','1',' MFF3 10K B','TOKO','SMBK-F','F3F-YIBI-10-T','GL TRIXIE MODEL PASIR VAR BG 8K ','OL ','2.080','1','100.00','2013000','0','0','15000','2116000','0','10000','0','2126000','RHM','T0073323','F3F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YIBI-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3F-YIBI-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071145061','2025-10-07','2.080','2025-10-07','11:45:06','PLG0073418','2116000','2116000','10000','2126000','2126000','kasir','2025-10-07 11:45:06','F22507114506');
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-07','F225071145061','2025-10-07','11:45:06','RHM','2126000','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-251007-0031','D','2025-10-07','11:45:06','kasir','PENJUALAN','F225071145061','1198894000','2126000','1201020000');
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 ('F225071152251','kasir','1',' MEH1 UB 45','TOKO','SMBK-H','H1E-YHXF-54-T','KL RANTAI HOLLOW UB 45CM 8K ','OL ','0.860','1','100.00','797000','0','0','15000','862000','0','5000','0','867000','RHM','T0071946','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXF-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='H1E-YHXF-54-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 ('F225071152251','2025-10-07','0.860','2025-10-07','11:52:26','PLG0073419','862000','862000','5000','867000','867000','kasir','2025-10-07 11:52:25','F22507115225');
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-07','F225071152251','2025-10-07','11:52:26','RHM','867000','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-251007-0032','D','2025-10-07','11:52:26','kasir','PENJUALAN','F225071152251','1201020000','867000','1201887000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='867000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071152251' 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 ('F225071152252','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-YJXF-49-T','KL RANTAI HOLLOW UB 42CM 8K ','OL ','0.800','1','100.00','782000','0','0','15000','802000','0','5000','0','807000','RHM','T0073947','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXF-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='H1E-YJXF-49-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 ('F225071152252','2025-10-07','0.800','2025-10-07','11:52:26','PLG0073420','802000','802000','5000','807000','807000','kasir','2025-10-07 11:52:25','F22507115225');
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-07','F225071152252','2025-10-07','11:52:26','RHM','807000','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-251007-0033','D','2025-10-07','11:52:26','kasir','PENJUALAN','F225071152252','1201887000','807000','1202694000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='807000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071152252' 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 ('F225071152253','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJXB-40-T','KL SANTA HATI CAT MATA VAR HW 8K ','OL ','2.210','1','100.00','2159000','0','0','15000','2203000','0','11000','0','2214000','RHM','T0073620','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXB-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='H1E-YJXB-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071152253','2025-10-07','2.210','2025-10-07','11:52:26','PLG0073421','2203000','2203000','11000','2214000','2214000','kasir','2025-10-07 11:52:25','F22507115225');
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-07','F225071152253','2025-10-07','11:52:26','RHM','2214000','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-251007-0034','D','2025-10-07','11:52:26','kasir','PENJUALAN','F225071152253','1202694000','2214000','1204908000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2214000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071152253' 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 ('F225071152254','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJXC-66-T','KL SANTA MODEL HATI PASIR HW 8K ','OL ','1.950','1','100.00','1901000','0','0','15000','1944000','0','10000','0','1954000','RHM','T0073787','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXC-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='H1E-YJXC-66-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 ('F225071152254','2025-10-07','1.950','2025-10-07','11:52:26','PLG0073422','1944000','1944000','10000','1954000','1954000','kasir','2025-10-07 11:52:25','F22507115225');
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-07','F225071152254','2025-10-07','11:52:26','RHM','1954000','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-251007-0035','D','2025-10-07','11:52:26','kasir','PENJUALAN','F225071152254','1204908000','1954000','1206862000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1954000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071152254' 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 ('F225071153161','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YHXH-36-T','GL MODEL SANTA KLINTING VAR UB 8K ','OL ','2.070','1','100.00','1919000','0','0','15000','2064000','0','10000','0','2074000','RHM','T0072136','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHXH-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='F3E-YHXH-36-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 ('F225071153161','2025-10-07','2.070','2025-10-07','11:53:16','PLG0073423','2064000','2064000','10000','2074000','2074000','kasir','2025-10-07 11:53:16','F22507115316');
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-07','F225071153161','2025-10-07','11:53:16','RHM','2074000','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-251007-0036','D','2025-10-07','11:53:16','kasir','PENJUALAN','F225071153161','1206862000','2074000','1208936000');
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 ('F225071156421','kasir','1',' MDB1 X YT ','TOKO','SMBK-B','B1D-YJXA-31-0','GW X MODEL SPECTRA HITAM YT PE 8K ','OL ','0.810','1','100.00','775000','0','0','15000','812000','0','5000','0','817000','RHM','00371276','B1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YJXA-31-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-10-07' AND kode_barang='B1D-YJXA-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071156421','2025-10-07','0.810','2025-10-07','11:56:43','PLG0073424','812000','812000','5000','817000','817000','kasir','2025-10-07 11:56:42','F22507115642');
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-07','F225071156421','2025-10-07','11:56:43','RHM','817000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251007-0037','D','2025-10-07','11:56:43','kasir','PENJUALAN','F225071156421','1208936000','817000','1209753000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='817000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071156421' 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 ('F225071156422','kasir',' 1',' MDE1 X BM ','TOKO','SMBK-E','E1D-YHBI-124-0','CC X VELG C SLEP BM 16 8K ','OL ','1.020','1','100.00','928000','0','0','15000','1017000','0','5000','0','1022000','RHM','00367365','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YHBI-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1D-YHBI-124-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 ('F225071156422','2025-10-07','1.020','2025-10-07','11:56:43','PLG0073425','1017000','1017000','5000','1022000','1022000','kasir','2025-10-07 11:56:42','F22507115642');
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-07','F225071156422','2025-10-07','11:56:43','RHM','1022000','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-251007-0038','D','2025-10-07','11:56:43','kasir','PENJUALAN','F225071156422','1209753000','1022000','1210775000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1022000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071156422' 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 ('F225071156423','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXA-17-T','CC MODEL MATA VAR CM 14 8K ','OL ','0.670','1','100.00','635000','0','0','15000','671000','0','5000','0','676000','RHM','T0073509','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXA-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E2E-YJXA-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071156423','2025-10-07','0.670','2025-10-07','11:56:43','PLG0073426','671000','671000','5000','676000','676000','kasir','2025-10-07 11:56:42','F22507115642');
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-07','F225071156423','2025-10-07','11:56:43','RHM','676000','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-251007-0039','D','2025-10-07','11:56:43','kasir','PENJUALAN','F225071156423','1210775000','676000','1211451000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='676000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071156423' 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 ('F225071159431','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXB-20-T','CC PIPA MODEL MATA HTM 15 8K ','OL ','0.470','1','100.00','459000','0','0','15000','471000','0','5000','0','476000','RHM','T0073600','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-20-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-07' AND kode_barang='E2E-YJXB-20-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 ('F225071159431','2025-10-07','0.470','2025-10-07','11:59:44','PLG0073427','471000','471000','5000','476000','476000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159431','2025-10-07','11:59:44','RHM','476000','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-251007-0040','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159431','1211451000','476000','1211927000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='476000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159431' 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 ('F225071159432','kasir',' 1',' MDE1 CM 14','TOKO','SMBK-E','E1D-YJXA-60-T','CC MODEL DAUN VAR CM 14 8K ','OL ','1.030','1','100.00','958000','0','0','15000','1027000','0','5000','0','1032000','RHM','T0073552','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXA-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1D-YJXA-60-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 ('F225071159432','2025-10-07','1.030','2025-10-07','11:59:44','PLG0073428','1027000','1027000','5000','1032000','1032000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159432','2025-10-07','11:59:44','RHM','1032000','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-251007-0041','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159432','1211927000','1032000','1212959000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1032000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159432' 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 ('F225071159433','kasir',' 1',' MGE2 AY 13','TOKO','SMBK-E','E2G-YICX-50-T','CC MODEL MATA VAR AY 13 8K ','OL ','0.350','1','100.00','349000','0','0','15000','365000','0','5000','0','370000','RHM','T0073462','E2G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2G-YICX-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E2G-YICX-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071159433','2025-10-07','0.350','2025-10-07','11:59:44','PLG0073429','365000','365000','5000','370000','370000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159433','2025-10-07','11:59:44','RHM','370000','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-251007-0042','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159433','1212959000','370000','1213329000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='370000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159433' 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 ('F225071159434','kasir',' 1',' MGE2 AY 11','TOKO','SMBK-E','E2G-YICX-43-T','CC MODEL MATA VAR AY 11 8K ','OL ','0.330','1','100.00','329000','0','0','15000','345000','0','5000','0','350000','RHM','T0073455','E2G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2G-YICX-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E2G-YICX-43-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 ('F225071159434','2025-10-07','0.330','2025-10-07','11:59:44','PLG0073430','345000','345000','5000','350000','350000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159434','2025-10-07','11:59:44','RHM','350000','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-251007-0043','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159434','1213329000','350000','1213679000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159434' 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 ('F225071159435','kasir',' 1',' MEE1 CM 12','TOKO','SMBK-E','E1E-YIBB-14-T','CC MODEL DAUN VAR CM 12 8K ','OL ','0.720','1','100.00','667000','0','0','15000','721000','0','5000','0','726000','RHM','T0073150','E1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIBB-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1E-YIBB-14-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 ('F225071159435','2025-10-07','0.720','2025-10-07','11:59:44','PLG0073431','721000','721000','5000','726000','726000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159435','2025-10-07','11:59:44','RHM','726000','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-251007-0044','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159435','1213679000','726000','1214405000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='726000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159435' 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 ('F225071159436','kasir',' 1',' MDE1 CM 18','TOKO','SMBK-E','E1D-YJXD-35-T','CC MODEL DAUN VAR CM 18 8K ','OL ','1.300','1','100.00','1241000','0','0','15000','1296000','0','7000','0','1303000','RHM','T0073849','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXD-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1D-YJXD-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071159436','2025-10-07','1.300','2025-10-07','11:59:44','PLG0073432','1296000','1296000','7000','1303000','1303000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159436','2025-10-07','11:59:44','RHM','1303000','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-251007-0045','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159436','1214405000','1303000','1215708000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1303000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159436' 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 ('F225071159437','kasir',' 1',' MDE1 CM 12','TOKO','SMBK-E','E1D-YJXA-61-T','CC MODEL DAUN VAR CM 12 8K ','OL ','0.930','1','100.00','865000','0','0','15000','932000','0','5000','0','937000','RHM','T0073553','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXA-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1D-YJXA-61-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 ('F225071159437','2025-10-07','0.930','2025-10-07','11:59:44','PLG0073433','932000','932000','5000','937000','937000','kasir','2025-10-07 11:59:43','F22507115943');
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-07','F225071159437','2025-10-07','11:59:44','RHM','937000','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-251007-0046','D','2025-10-07','11:59:44','kasir','PENJUALAN','F225071159437','1215708000','937000','1216645000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='937000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071159437' 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 ('F225071206171','kasir','1',' MED1 CM ','TOKO','SMBK-D','D1E-YIBI-79-T','LT MODEL BUNGA VAR CM 8K ','OL ','0.600','1','100.00','569000','0','0','15000','601000','0','5000','0','606000','RHM','T0073392','D1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YIBI-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1E-YIBI-79-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 ('F225071206171','2025-10-07','0.600','2025-10-07','12:06:18','PLG0073434','601000','601000','5000','606000','606000','kasir','2025-10-07 12:06:17','F22507120617');
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-07','F225071206171','2025-10-07','12:06:18','RHM','606000','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-251007-0047','D','2025-10-07','12:06:18','kasir','PENJUALAN','F225071206171','1216645000','606000','1217251000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='606000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071206171' 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 ('F225071206172','kasir',' 1',' MED1 CM ','TOKO','SMBK-D','D1E-YJXB-69-T','LT MODEL DAUN VAR CM 8K ','OL ','0.700','1','100.00','684000','0','0','15000','701000','0','5000','0','706000','RHM','T0073649','D1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXB-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1E-YJXB-69-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 ('F225071206172','2025-10-07','0.700','2025-10-07','12:06:18','PLG0073435','701000','701000','5000','706000','706000','kasir','2025-10-07 12:06:17','F22507120617');
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-07','F225071206172','2025-10-07','12:06:18','RHM','706000','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-251007-0048','D','2025-10-07','12:06:18','kasir','PENJUALAN','F225071206172','1217251000','706000','1217957000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='706000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071206172' 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 ('F225071206173','kasir',' 1',' MED2 LG K ','TOKO','SMBK-D','D2E-YIBB-81-T','LT MODEL HURUF MATA LG K 8K ','OL ','0.600','1','100.00','556000','0','0','15000','601000','0','5000','0','606000','RHM','T0073217','D2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIBB-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D2E-YIBB-81-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 ('F225071206173','2025-10-07','0.600','2025-10-07','12:06:18','PLG0073436','601000','601000','5000','606000','606000','kasir','2025-10-07 12:06:17','F22507120617');
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-07','F225071206173','2025-10-07','12:06:18','RHM','606000','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-251007-0049','D','2025-10-07','12:06:18','kasir','PENJUALAN','F225071206173','1217957000','606000','1218563000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='606000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071206173' 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 ('F225071206174','kasir',' 1',' MGD1 5K HW','TOKO','SMBK-D','D1G-YJXF-87-T','LT SLOBOK MODEL H CAT VAR HW 8K ','OL ','0.380','1','100.00','386000','0','0','15000','396000','0','5000','0','401000','RHM','T0073985','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXF-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1G-YJXF-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 ('F225071206174','2025-10-07','0.380','2025-10-07','12:06:18','PLG0073437','396000','396000','5000','401000','401000','kasir','2025-10-07 12:06:17','F22507120617');
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-07','F225071206174','2025-10-07','12:06:18','RHM','401000','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-251007-0050','D','2025-10-07','12:06:18','kasir','PENJUALAN','F225071206174','1218563000','401000','1218964000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='401000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071206174' 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 ('F225071207401','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-YIAE-87-0','LT X MODEL HURUF MATA LG A 8K ','OL ','0.470','1','100.00','436000','0','0','15000','471000','0','5000','0','476000','RHM','00369538','D2E','0','0','-','0','977000');
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 ('F225071209441','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-YIAE-87-0','LT X MODEL HURUF MATA LG A 8K ','OL ','0.470','1','100.00','436000','0','0','15000','471000','0','5000','0','476000','RHM','00369538','D2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIAE-87-0' 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-07' AND kode_barang='D2E-YIAE-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071209441','2025-10-07','0.470','2025-10-07','12:09:45','PLG0073439','471000','471000','5000','476000','476000','kasir','2025-10-07 12:09:44','F22507120944');
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-07','F225071209441','2025-10-07','12:09:45','RHM','476000','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-251007-0051','D','2025-10-07','12:09:45','kasir','PENJUALAN','F225071209441','1218964000','476000','1219440000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='476000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071209441' 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 ('F225071209442','kasir',' 1',' MFD2F LG I','TOKO','SMBK-D','D2F-WJCA-288-0','LT MODEL HURUF MATA LG I ','OL ','0.500','1','100.00','472000','0','0','15000','501000','0','5000','0','506000','RHM','00261837','D2F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-WJCA-288-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-07' AND kode_barang='D2F-WJCA-288-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071209442','2025-10-07','0.500','2025-10-07','12:09:45','PLG0073440','501000','501000','5000','506000','506000','kasir','2025-10-07 12:09:44','F22507120944');
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-07','F225071209442','2025-10-07','12:09:45','RHM','506000','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-251007-0052','D','2025-10-07','12:09:45','kasir','PENJUALAN','F225071209442','1219440000','506000','1219946000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='506000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071209442' 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 ('F225071209443','kasir',' 1',' MED2 LG T ','TOKO','SMBK-D','D2E-YHAI-77-T','LT MODEL HURUF MATA LG T 8K ','OL ','0.600','1','100.00','556000','0','0','15000','601000','0','5000','0','606000','RHM','T0072417','D2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YHAI-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D2E-YHAI-77-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 ('F225071209443','2025-10-07','0.600','2025-10-07','12:09:45','PLG0073441','601000','601000','5000','606000','606000','kasir','2025-10-07 12:09:44','F22507120944');
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-07','F225071209443','2025-10-07','12:09:45','RHM','606000','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-251007-0053','D','2025-10-07','12:09:45','kasir','PENJUALAN','F225071209443','1219946000','606000','1220552000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='606000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071209443' 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 ('F225071212321','kasir','1',' MDE1 CM 12','TOKO','SMBK-E','E1D-YJXD-36-T','CC MODEL DAUN VAR CM 12 8K ','OL ','0.930','1','100.00','888000','0','0','15000','937000','0','5000','0','942000','RHM','T0073850','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXD-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1D-YJXD-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 ('F225071212321','2025-10-07','0.930','2025-10-07','12:12:33','PLG0073442','937000','937000','5000','942000','942000','kasir','2025-10-07 12:12:32','F22507121232');
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-07','F225071212321','2025-10-07','12:12:33','RHM','942000','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-251007-0054','D','2025-10-07','12:12:33','kasir','PENJUALAN','F225071212321','1220552000','942000','1221494000');
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 ('F225070124061','kasir','1',' MFD1F BM ','TOKO','SMBK-D','D1F-YFBA-153-0','LT LETTERA COIN POLOS BM 8K ','OL','0.960','1','100.00','906000','0','0','15000','981000','0','5000','0','986000','TJ','00358427','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YFBA-153-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-10-07' AND kode_barang='D1F-YFBA-153-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225070124061','2025-10-07','0.960','2025-10-07','13:24:06','PLG0073443','981000','981000','5000','986000','0','kasir','2025-10-07 13:24:06','F22507012406');
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-07','F225070124061','2025-10-07','13:24:06','TJ','986000','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-251007-0005','2025-10-07','2025-10-07 13:24:06','PENJUALAN : F225070124061','837938098309','BCA','986000','986000','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-251007-0006','D','2025-10-07','13:24:06','BCA','PENJUALAN','F225070124061','4032826888','986000','4033812888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('837938098309','MAYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='986000' WHERE no_faktur_jual='F225070124061' 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 ('F225070150311','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJXC-93-T','AS EXTENSION UB 8K ','OLH','0.430','1','100.00','437000','0','0','15000','450000','0','8000','0','458000','RTA','T0073814','S1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJXC-93-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-07' AND kode_barang='S1G-YJXC-93-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225070150311','2025-10-07','0.430','2025-10-07','13:50:31','PLG0073444','450000','450000','8000','458000','0','kasir','2025-10-07 13:50:31','F22507015031');
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-07','F225070150311','2025-10-07','13:50:31','RTA','458000','8000');
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-251007-0006','2025-10-07','2025-10-07 13:50:31','PENJUALAN : F225070150311','999000998877','BCA','458000','458000','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-251007-0007','D','2025-10-07','13:50:31','BCA','PENJUALAN','F225070150311','4033812888','458000','4034270888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('999000998877','YULI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='458000' WHERE no_faktur_jual='F225070150311' 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 ('F225070152381','kasir','1',' MEA1 UB ','TOKO','SMBK-A','A1E-YJXD-32-T','AT MODEL ITALY PANJANG VAR UB 8K ','OL','0.960','1','100.00','936000','0','0','15000','967000','0','5000','0','972000','TIN','T0073846','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-32-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-07' AND kode_barang='A1E-YJXD-32-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 ('F225070152381','2025-10-07','0.960','2025-10-07','13:52:39','PLG0073445','967000','967000','5000','972000','972000','kasir','2025-10-07 13:52:38','F22507015238');
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-07','F225070152381','2025-10-07','13:52:39','TIN','972000','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-251007-0055','D','2025-10-07','13:52:39','kasir','PENJUALAN','F225070152381','1221494000','972000','1222466000');
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 ('F225070209011','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXF-15-T','CC MODEL HATI MATA CM 14 8K ','OL','0.650','1','100.00','635000','0','0','15000','655000','0','5000','0','660000','TIN','T0073913','E2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-15-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-07' AND kode_barang='E2E-YJXF-15-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 ('F225070209011','2025-10-07','0.650','2025-10-07','14:09:02','PLG0073446','655000','655000','5000','660000','660000','kasir','2025-10-07 14:09:01','F22507020901');
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-07','F225070209011','2025-10-07','14:09:02','TIN','660000','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-251007-0056','D','2025-10-07','14:09:02','kasir','PENJUALAN','F225070209011','1222466000','660000','1223126000');
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 ('F225070219441','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-YIXH-39-T','CC POLOS CM 16 8K ','','1.510','1','100.00','1374000','0','0','15000','1468000','0','0','0','1468000','TJ','T0073048','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIXH-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E1D-YIXH-39-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 ('F225070219441','2025-10-07','1.510','2025-10-07','14:19:44','PLG0073447','1468000','1468000','0','1468000','1468000','kasir','2025-10-07 14:19:44','F22507021944');
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-07','F225070219441','2025-10-07','14:19:44','TJ','1468000','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-251007-0057','D','2025-10-07','14:19:44','kasir','PENJUALAN','F225070219441','1223126000','1468000','1224594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1468000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070219441' 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 ('F225070219442','kasir',' 1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YGAH-29-T','GW TUSUK MODEL HATI VAR CM PE 8K ','','0.610','1','100.00','565000','0','0','15000','605000','0','0','0','605000','TJ','T0071060','B1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YGAH-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='B1E-YGAH-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225070219442','2025-10-07','0.610','2025-10-07','14:19:44','PLG0073448','605000','605000','0','605000','605000','kasir','2025-10-07 14:19:44','F22507021944');
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-07','F225070219442','2025-10-07','14:19:44','TJ','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,status_valid) VALUES ('KM-251007-0058','D','2025-10-07','14:19:44','kasir','PENJUALAN','F225070219442','1224594000','605000','1225199000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070219442' 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 ('F225070225081','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-YGAI-32-T','GW TUSUK DAISY MATA CM 8K ','OL','0.260','1','100.00','254000','0','0','15000','276000','0','5000','0','281000','RTA','T0071269','B1H','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YGAI-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='B1H-YGAI-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225070225081','2025-10-07','0.260','2025-10-07','14:25:09','PLG0073449','276000','276000','5000','281000','0','kasir','2025-10-07 14:25:08','F22507022508');
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-07','F225070225081','2025-10-07','14:25:09','RTA','281000','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-251007-0007','2025-10-07','2025-10-07 14:25:08','PENJUALAN : F225070225081','8987877667','BCA','281000','281000','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-251007-0008','D','2025-10-07','14:25:09','BCA','PENJUALAN','F225070225081','4034270888','281000','4034551888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8987877667','WULAN');
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 ('F225070226201','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YECA-4-T','AT TINDIK BABY POLOS LG 8K ','OL','0.470','1','100.00','436000','0','0','15000','471000','0','5000','0','476000','RTA','T0069715','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YECA-4-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-07' AND kode_barang='A1E-YECA-4-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 ('F225070226201','2025-10-07','0.470','2025-10-07','14:26:21','PLG0073450','471000','471000','5000','476000','0','kasir','2025-10-07 14:26:20','F22507022620');
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-07','F225070226201','2025-10-07','14:26:21','RTA','476000','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-251007-0008','2025-10-07','2025-10-07 14:26:20','PENJUALAN : F225070226201','8987877667','BCA','476000','476000','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-251007-0009','D','2025-10-07','14:26:21','BCA','PENJUALAN','F225070226201','4034551888','476000','4035027888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8987877667','WULAN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070225081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070225081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070225081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070226201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070226201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070226201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070124061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070124061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070124061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070150311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070150311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070150311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070152381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070152381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070152381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070209011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070209011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070209011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070219441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070219441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070219441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070219442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070219442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070219442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070950341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070950341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070950341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070950342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070950342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070950342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070955311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070955311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070955311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001323' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001323' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001323';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001324' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001324' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001324';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001325' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001325' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001325';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001326' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001326' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001326';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001327' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071001327' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071001327';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071008471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071008471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071008471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015034';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015035';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015036';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071015037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071015037';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071016231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071016231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071016231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071020141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071020141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071020141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071020142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071020142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071020142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071022361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071022361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071022361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071024011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071024011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071024011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071058331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071058331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071058331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071059101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071059101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071059101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071130341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071130341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071130341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143453' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143453' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143453';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143454' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143454' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143454';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143455' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143455' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143455';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143456' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143456' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143456';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143457' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071143457' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071143457';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071145061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071145061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071145061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071152251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071152252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152253' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152253' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071152253';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152254' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071152254' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071152254';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071153161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071153161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071153161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071156421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071156421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071156421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071156422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071156422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071156422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071156423' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071156423' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071156423';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159433' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159433' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159433';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159434' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159434' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159434';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159435' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159435' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159435';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159436' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159436' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159436';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159437' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071159437' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071159437';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071206171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071206172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206173' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206173' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071206173';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206174' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071206174' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071206174';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071209441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071209441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071209441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071209442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071209442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071209442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071209443' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071209443' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071209443';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071212321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071212321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071212321';
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 ('F225070246491','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YFBA-127-0','CC X SOLITARE MATA CM 18 8K ','','1.880','1','100.00','1711000','0','0','15000','1828000','0','10000','0','1838000','TJ','00358401','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFBA-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='E2D-YFBA-127-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 ('F225070246491','2025-10-07','1.880','2025-10-07','14:46:49','PLG0073451','1828000','1828000','10000','1838000','1838000','kasir','2025-10-07 14:46:49','F22507024649');
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-07','F225070246491','2025-10-07','14:46:49','TJ','1838000','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-251007-0059','D','2025-10-07','14:46:49','kasir','PENJUALAN','F225070246491','1225199000','1838000','1227037000');
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-00004718','X-00004718','CC Q55 CERAMIC GOLD SPECTRA VAR UB 16','GR','---','E1F','BELI','BELI001','229000','2025-10-07','0.330','1','kasir','2025-10-07 15:08:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00004718','X-00004718');
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-251007-0001','F224110135091','RHM','1','BELI','BELI001','E1F', 'X-00004718', 'CC Q55 CERAMIC GOLD SPECTRA VAR UB 16','0.430','0.330','100.00','230000','229000','693939','1005000','1','229000','229000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.330',berat_beli_asli=berat_beli_asli+'0.330',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.330',berat_akhir_asli=berat_akhir_asli+'0.330',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-251007-0001','2025-10-07','2025-10-07','15:08:04','RHM','---','0.330','229000','229000','229000','229000','229000','kasir','2025-10-07 15:08:05','FB-251007-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251007-0001','WINDA','SEKODOK NGEBEL','','','089618621101','kasir','2025-10-07 15:08:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-07' 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-251007-0060','K','2025-10-07','15:08:04','kasir','PEMBELIAN UMUM','FB-251007-0001','1227037000','229000','1226808000');
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-00004719','X-00004719','GL JEDAR KH 9K','GR','---','F4J','BELI','BELI001','396000','2025-10-07','0.550','1','kasir','2025-10-07 15:08:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-F4J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F4J','X-00004719','X-00004719');
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-251007-0002','F224300104501','RHM','2','BELI','BELI001','F4J', 'X-00004719', 'GL JEDAR KH 9K','0.620','0.550','100.00','403000','396000','720000','1053000','1','396000','396000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F4J' 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-251007-0002','2025-10-07','2025-10-07','15:08:04','RHM','---','0.550','396000','396000','396000','396000','396000','kasir','2025-10-07 15:08:05','FB-251007-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251007-0002','WINDA','SEKODOK NGEBEL','','','089618621101','kasir','2025-10-07 15:08:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-07' 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-251007-0061','K','2025-10-07','15:08:04','kasir','PEMBELIAN UMUM','FB-251007-0002','1226808000','396000','1226412000');
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-00004720','X-00004720','LT X MODEL HURUF MATA LG D 8K','GR','---','D2F','BELI','BELI001','515000','2025-10-07','0.580','1','kasir','2025-10-07 15:08:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00004720','X-00004720');
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-251007-0003','F225241118172','RHM','1','BELI','BELI001','D2F', 'X-00004720', 'LT X MODEL HURUF MATA LG D 8K','0.580','0.580','100.00','560000','515000','887931','1005000','1','515000','515000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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-251007-0003','2025-10-07','2025-10-07','15:08:44','RHM','---','0.580','515000','515000','515000','515000','515000','kasir','2025-10-07 15:08:44','FB-251007-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251007-0003','HENI SUSANTI','BANGUNREJO SUKOREJO','','','081211337587','kasir','2025-10-07 15:08:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-07' 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-251007-0062','K','2025-10-07','15:08:44','kasir','PEMBELIAN UMUM','FB-251007-0003','1226412000','515000','1225897000');
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-00004721','X-00004721','KL MILANO UB 42CM 8K','GR','---','H1F','BELI','BELI001','1790000','2025-10-07','2.060','1','kasir','2025-10-07 15:08:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00004721','X-00004721');
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-251007-0004','F225241118171','RHM','2','BELI','BELI001','H1F', 'X-00004721', 'KL MILANO UB 42CM 8K','2.060','2.060','100.00','1988000','1790000','868932','1005000','1','1790000','1790000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.060',berat_beli_asli=berat_beli_asli+'2.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.060',berat_akhir_asli=berat_akhir_asli+'2.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-251007-0004','2025-10-07','2025-10-07','15:08:44','RHM','---','2.060','1790000','1790000','1790000','1790000','1790000','kasir','2025-10-07 15:08:44','FB-251007-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251007-0004','HENI SUSANTI','BANGUNREJO SUKOREJO','','','081211337587','kasir','2025-10-07 15:08:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-07' 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-251007-0063','K','2025-10-07','15:08:44','kasir','PEMBELIAN UMUM','FB-251007-0004','1225897000','1790000','1224107000');
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-00004722','X-00004722','GL LEMES 8K','GR','---','F3H','BELI','BELI001','1020000','2025-10-07','1.470','1','kasir','2025-10-07 15:09:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3H','X-00004722','X-00004722');
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-251007-0005','F223171003351','TJ','1','BELI','BELI001','F3H', 'X-00004722', 'GL LEMES 8K','1.570','1.470','100.00','766000','1020000','693878','1037000','1','1020000','1020000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.470',berat_beli_asli=berat_beli_asli+'1.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.470',berat_akhir_asli=berat_akhir_asli+'1.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3H' 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-251007-0005','2025-10-07','2025-10-07','15:09:37','TJ','---','1.470','1020000','1020000','1020000','1020000','1020000','kasir','2025-10-07 15:09:38','FB-251007-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251007-0005','RISNA','-','','','','kasir','2025-10-07 15:09:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-07' 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-251007-0064','K','2025-10-07','15:09:37','kasir','PEMBELIAN UMUM','FB-251007-0005','1224107000','1020000','1223087000');
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-00004723','X-00004723','AT X TINDIK BABY HK 17K','GR','---','A1TI','BELI','BELI001','345000','2025-10-07','0.270','1','kasir','2025-10-07 15:12:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TI';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TI','X-00004723','X-00004723');
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-251007-0006','F225191229461','RHM','1','BELI','BELI001','A1TI', 'X-00004723', 'AT X TINDIK BABY HK 17K','0.270','0.270','100.00','375000','345000','1277778','1708000','1','345000','345000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.270',berat_beli_asli=berat_beli_asli+'0.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.270',berat_akhir_asli=berat_akhir_asli+'0.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TI' 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-251007-0006','2025-10-07','2025-10-07','15:12:43','RHM','---','0.270','345000','345000','345000','345000','345000','kasir','2025-10-07 15:12:44','FB-251007-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251007-0006','RIMA','PACITAN','','','081371630411','kasir','2025-10-07 15:12:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-07' 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-251007-0065','K','2025-10-07','15:12:43','kasir','PEMBELIAN UMUM','FB-251007-0006','1223087000','345000','1222742000');
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 ('F225070314521','kasir','1',' MGD1 5K AY','TOKO','SMBK-D','D1G-YJXF-79-T','LT SLOBOK HATI PASIR AY 8K ','OL','0.310','1','100.00','315000','0','0','15000','325000','0','5000','0','330000','TIN','T0073977','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXF-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1G-YJXF-79-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 ('F225070314521','2025-10-07','0.310','2025-10-07','15:14:53','PLG0073452','325000','325000','5000','330000','330000','kasir','2025-10-07 15:14:52','F22507031452');
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-07','F225070314521','2025-10-07','15:14:53','TIN','330000','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-251007-0066','D','2025-10-07','15:14:53','kasir','PENJUALAN','F225070314521','1222742000','330000','1223072000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='330000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070314521' 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 ('F225070314522','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-YJXF-97-T','LT MODEL FINE GOLD LG 8K ','OL','0.530','1','100.00','518000','0','0','15000','534000','0','5000','0','539000','TIN','T0073995','D1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXF-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1E-YJXF-97-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 ('F225070314522','2025-10-07','0.530','2025-10-07','15:14:53','PLG0073453','534000','534000','5000','539000','539000','kasir','2025-10-07 15:14:52','F22507031452');
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-07','F225070314522','2025-10-07','15:14:53','TIN','539000','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-251007-0067','D','2025-10-07','15:14:53','kasir','PENJUALAN','F225070314522','1223072000','539000','1223611000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='539000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070314522' 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 ('F225070314523','kasir',' 1',' MDD1 LG ','TOKO','SMBK-D','D1D-YJXF-110-T','LT MODEL SLEP VAR LG 8K ','OL','1.270','1','100.00','1215000','0','0','15000','1273000','0','6000','0','1279000','TIN','T0074008','D1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-YJXF-110-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='D1D-YJXF-110-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 ('F225070314523','2025-10-07','1.270','2025-10-07','15:14:53','PLG0073454','1273000','1273000','6000','1279000','1279000','kasir','2025-10-07 15:14:52','F22507031452');
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-07','F225070314523','2025-10-07','15:14:53','TIN','1279000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251007-0068','D','2025-10-07','15:14:53','kasir','PENJUALAN','F225070314523','1223611000','1279000','1224890000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1279000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225070314523' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070246491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070246491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070246491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070314521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070314521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070314521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070314522' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070314522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070314522';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070314523' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070314523' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070314523';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251007-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251007-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251007-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251007-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251007-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251007-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251007-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251007-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251007-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251007-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251007-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251007-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-07';
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-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-07';
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-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-07' 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-251008-0001','D','2025-10-08','16:03:29','SYSTEM','SALDO AWAL','SALDO AWAL','0','1224890000','1224890000');
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-251008-0001','D','2025-10-08','16:03:29','BCA','SALDO AWAL','SALDO AWAL','0','4035027888','4035027888');
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-251008-0001','D','2025-10-08','16:03:29','','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-251008-0001','D','2025-10-08','16:03:29','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-251008-0001','D','2025-10-08','16:03:29','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-251008-0001','D','2025-10-08','16:03:29','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-10-08';