INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325240855311','input','1',' MEF2 XXX U','TOKO','PM-F','F2E-YGBD-74-0','GL XXX PIPA MATA UB 56 8K ','','3.070','1','100.00','2554000','0','0','15000','2555000','0','0','0','2555000','AAT','00362312','F2E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YGBD-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='F2E-YGBD-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325240855311','2025-08-24','3.070','2025-08-24','08:55:31','PLG0024709','2555000','2555000','0','2555000','2555000','input','2025-08-24 08:55:31','F32524085531');
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-08-24','F325240855311','2025-08-24','08:55:31','AAT','2555000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0002','D','2025-08-24','08:55:31','input','PENJUALAN','F325240855311','2361829000','2555000','2364384000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240855311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240855311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240855311';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325240858291','kasir','1',' MEF2 XXX U','TOKO','PM-F','F2E-YGBD-74-0','GL XXX PIPA MATA UB 56 8K ','','3.070','1','100.00','2554000','0','0','15000','2555000','0','0','0','2555000','AAT','00362312','F2E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YGBD-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='F2E-YGBD-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325240858291','2025-08-24','3.070','2025-08-24','08:58:29','PLG0024710','2555000','2555000','0','2555000','2555000','kasir','2025-08-24 08:58:29','F32524085829');
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-08-24','F325240858291','2025-08-24','08:58:29','AAT','2555000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0004','D','2025-08-24','08:58:29','kasir','PENJUALAN','F325240858291','2361829000','2555000','2364384000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325240859411','kasir','1',' MEA1E X BW','TOKO','PM-A','A1E-YBBF-157-0','AT X MODEL MATA BW 8K ','','0.630','1','100.00','524000','0','0','15000','525000','0','0','0','525000','AAT','00340549','A1E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YBBF-157-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='A1E-YBBF-157-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325240859411','2025-08-24','0.630','2025-08-24','08:59:42','PLG0024711','525000','525000','0','525000','525000','kasir','2025-08-24 08:59:41','F32524085941');
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-08-24','F325240859411','2025-08-24','08:59:42','AAT','525000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0005','D','2025-08-24','08:59:42','kasir','PENJUALAN','F325240859411','2364384000','525000','2364909000');
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-00016797','X-00016797','GL COR T 8K','GR','---','F1E','BELI','BELI001','1225000','2025-08-24','2.220','1','kasir','2025-08-24 09:51:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016797','X-00016797');
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-250824-0001','00327913','FIT','1','BELI','BELI001','F1E', 'X-00016797', 'GL COR T 8K','2.220','2.220','100.00','1443000','1225000','551802','832000','1','1225000','1225000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.220',berat_beli_asli=berat_beli_asli+'2.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.220',berat_akhir_asli=berat_akhir_asli+'2.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0001','2025-08-24','2025-08-24','09:51:46','FIT','---','2.220','1225000','1225000','1225000','1225000','1225000','kasir','2025-08-24 09:51:47','FB-250824-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0001','FENTY','PACITAN','','','','kasir','2025-08-24 09:51:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0006','K','2025-08-24','09:51:46','kasir','PEMBELIAN UMUM','FB-250824-0001','2364909000','1225000','2363684000');
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-00016798','X-00016798','CC X MODEL MATA CAT BM 14 8K','GR','---','E2D','BELI','BELI001','560000','2025-08-24','0.930','1','kasir','2025-08-24 09:52:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00016798','X-00016798');
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-250824-0002','F324301232264','FIT','1','BELI','BELI001','E2D', 'X-00016798', 'CC X MODEL MATA CAT BM 14 8K','0.930','0.930','100.00','595000','560000','602151','815000','1','560000','560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250824-0002','2025-08-24','2025-08-24','09:52:05','FIT','---','0.930','560000','560000','560000','560000','560000','kasir','2025-08-24 09:52:06','FB-250824-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0002','FENTI','JERUK','','','','kasir','2025-08-24 09:52:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0007','K','2025-08-24','09:52:05','kasir','PEMBELIAN UMUM','FB-250824-0002','2363684000','560000','2363124000');
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-00016799','X-00016799','CC X MODEL CAT SLEP YT 14','GR','---','E1E','BELI','BELI001','562000','2025-08-24','1.000','1','kasir','2025-08-24 09:52:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00016799','X-00016799');
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-250824-0003','F324170301021','FIT','1','BELI','BELI001','E1E', 'X-00016799', 'CC X MODEL CAT SLEP YT 14','1.000','1.000','100.00','593000','562000','562000','832000','1','562000','562000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-250824-0003','2025-08-24','2025-08-24','09:52:26','FIT','---','1.000','562000','562000','562000','562000','562000','kasir','2025-08-24 09:52:26','FB-250824-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0003','DEVI KARTIKA','KEPYAR','','','','kasir','2025-08-24 09:52:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0008','K','2025-08-24','09:52:26','kasir','PEMBELIAN UMUM','FB-250824-0003','2363124000','562000','2362562000');
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-00016800','X-00016800','CC BANGKOK PASIR VAR BW 16 8K','GR','---','E1E','BELI','BELI001','450000','2025-08-24','0.630','1','kasir','2025-08-24 09:52:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00016800','X-00016800');
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-250824-0004','F325291041122','FIT','1','BELI','BELI001','E1E', 'X-00016800', 'CC BANGKOK PASIR VAR BW 16 8K','0.630','0.630','100.00','490000','450000','714286','832000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-250824-0004','2025-08-24','2025-08-24','09:52:50','FIT','---','0.630','450000','450000','450000','450000','450000','kasir','2025-08-24 09:52:50','FB-250824-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0004','DEVI','SUMBER KEPYAR','','','','kasir','2025-08-24 09:52:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0009','K','2025-08-24','09:52:50','kasir','PEMBELIAN UMUM','FB-250824-0004','2362562000','450000','2362112000');
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-00016801','X-00016801','GL BANGKOK C ANAK SLEP TD 34 8K','GR','---','F1E','BELI','BELI001','1045000','2025-08-24','1.960','1','kasir','2025-08-24 09:53:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016801','X-00016801');
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-250824-0005','F324041219081','AAT','1','BELI','BELI001','F1E', 'X-00016801', 'GL BANGKOK C ANAK SLEP TD 34 8K','1.980','1.960','100.00','1175000','1045000','533163','832000','1','1045000','1045000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.960',berat_beli_asli=berat_beli_asli+'1.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.960',berat_akhir_asli=berat_akhir_asli+'1.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0005','2025-08-24','2025-08-24','09:53:27','AAT','---','1.960','1045000','1045000','1045000','1045000','1045000','kasir','2025-08-24 09:53:27','FB-250824-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0005','ANIS KRISTANTI','MIRI KISMANTORO','','','085647111980','kasir','2025-08-24 09:53:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0010','K','2025-08-24','09:53:27','kasir','PEMBELIAN UMUM','FB-250824-0005','2362112000','1045000','2361067000');
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-00016802','X-00016802','CC X LISTERING MATA YS 16 8K','GR','---','E2D','BELI','BELI001','535000','2025-08-24','0.810','1','kasir','2025-08-24 09:53:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00016802','X-00016802');
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-250824-0006','F325170226511','AAT','1','BELI','BELI001','E2D', 'X-00016802', 'CC X LISTERING MATA YS 16 8K','0.810','0.810','100.00','575000','535000','660494','815000','1','535000','535000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.810',berat_beli_asli=berat_beli_asli+'0.810',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.810',berat_akhir_asli=berat_akhir_asli+'0.810',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250824-0006','2025-08-24','2025-08-24','09:53:47','AAT','---','0.810','535000','535000','535000','535000','535000','kasir','2025-08-24 09:53:47','FB-250824-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0006','ANIS','MIRI KISMANTORO','','','','kasir','2025-08-24 09:53:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0011','K','2025-08-24','09:53:47','kasir','PEMBELIAN UMUM','FB-250824-0006','2361067000','535000','2360532000');
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-00016803','X-00016803','KL X NORY KH 42 8K','GR','---','H1E','BELI','BELI001','1450000','2025-08-24','2.110','1','kasir','2025-08-24 09:54:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00016803','X-00016803');
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-250824-0007','F325110228391','FIT','1','BELI','BELI001','H1E', 'X-00016803', 'KL X NORY KH 42 8K','2.110','2.110','100.00','1560000','1450000','687204','832000','1','1450000','1450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.110',berat_beli_asli=berat_beli_asli+'2.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.110',berat_akhir_asli=berat_akhir_asli+'2.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-250824-0007','2025-08-24','2025-08-24','09:54:07','FIT','---','2.110','1450000','1450000','1450000','1450000','1450000','kasir','2025-08-24 09:54:08','FB-250824-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0007','RENI','NAWANGAN PACITAN','','','','kasir','2025-08-24 09:54:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0012','K','2025-08-24','09:54:07','kasir','PEMBELIAN UMUM','FB-250824-0007','2360532000','1450000','2359082000');
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-00016804','X-00016804','GL TRIXIE MODEL BUNGA CLOVER VAR YT 8K','GR','---','F3E','BELI','BELI001','750000','2025-08-24','1.100','1','kasir','2025-08-24 09:54:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016804','X-00016804');
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-250824-0008','F325091037001','AAT','1','BELI','BELI001','F3E', 'X-00016804', 'GL TRIXIE MODEL BUNGA CLOVER VAR YT 8K','1.100','1.100','100.00','815000','750000','681818','832000','1','750000','750000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0008','2025-08-24','2025-08-24','09:54:36','AAT','---','1.100','750000','750000','750000','750000','750000','kasir','2025-08-24 09:54:37','FB-250824-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0008','FADILA','SENAYU BITING','','','','kasir','2025-08-24 09:54:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0013','K','2025-08-24','09:54:36','kasir','PEMBELIAN UMUM','FB-250824-0008','2359082000','750000','2358332000');
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-00016805','X-00016805','CC MODEL MATA VAR CM 14 8K','GR','---','E2D','BELI','BELI001','1115000','2025-08-24','1.470','1','kasir','2025-08-24 09:55:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00016805','X-00016805');
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-250824-0009','F325201107091','AAT','1','BELI','BELI001','E2D', 'X-00016805', 'CC MODEL MATA VAR CM 14 8K','1.470','1.470','100.00','1215000','1115000','758503','815000','1','1115000','1115000','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-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250824-0009','2025-08-24','2025-08-24','09:55:16','AAT','---','1.470','1115000','1115000','1115000','1115000','1115000','kasir','2025-08-24 09:55:16','FB-250824-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0009','SEPTIANI','JERUK','','','','kasir','2025-08-24 09:55:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0014','K','2025-08-24','09:55:16','kasir','PEMBELIAN UMUM','FB-250824-0009','2358332000','1115000','2357217000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325241006061','kasir','1',' MEE2 X LG ','TOKO','PM-E','E2E-YHXI-221-0','CC X MODEL MATA LG 10 8K ','','0.460','1','100.00','383000','0','0','15000','383000','0','0','0','383000','FIT','00365085','E2E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXI-221-0' 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-08-24' AND kode_barang='E2E-YHXI-221-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241006061','2025-08-24','0.460','2025-08-24','10:06:06','PLG0024712','383000','383000','0','383000','383000','kasir','2025-08-24 10:06:06','F32524100606');
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-08-24','F325241006061','2025-08-24','10:06:06','FIT','383000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0015','D','2025-08-24','10:06:06','kasir','PENJUALAN','F325241006061','2357217000','383000','2357600000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325241010001','kasir','1',' MDE1 HW 15','TOKO','PM-E','E1D-YHAB-107-0','CC MODEL SLEP VAR HW 15 8K ','','1.050','1','100.00','856000','0','0','15000','856000','0','0','0','856000','AAT','00365362','E1D','0','0','-','0','815000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YHAB-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='E1D-YHAB-107-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241010001','2025-08-24','1.050','2025-08-24','10:10:01','PLG0024713','856000','856000','0','856000','856000','kasir','2025-08-24 10:10:00','F32524101000');
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-08-24','F325241010001','2025-08-24','10:10:01','AAT','856000','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-250824-0016','D','2025-08-24','10:10:01','kasir','PENJUALAN','F325241010001','2357600000','856000','2358456000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='856000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241010001' 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 ('F325241010002','kasir',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-YBXA-204-0','CC X SOLITAIRE MATA CM 16 8K ','','1.210','1','100.00','986000','0','0','15000','986000','0','0','0','986000','AAT','00337080','E2D','0','0','-','0','815000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YBXA-204-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='E2D-YBXA-204-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241010002','2025-08-24','1.210','2025-08-24','10:10:01','PLG0024714','986000','986000','0','986000','986000','kasir','2025-08-24 10:10:00','F32524101000');
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-08-24','F325241010002','2025-08-24','10:10:01','AAT','986000','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-250824-0017','D','2025-08-24','10:10:01','kasir','PENJUALAN','F325241010002','2358456000','986000','2359442000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='986000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241010002' 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 ('F325241010003','kasir',' 1',' MDB1 HW PE','TOKO','PM-B','B1D-YHAC-23-0','GW TUSUK MODEL MATA VAR HW PE 8K ','','0.840','1','100.00','685000','0','0','15000','685000','0','0','0','685000','AAT','00365393','B1D','0','0','-','0','815000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YHAC-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='B1D-YHAC-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241010003','2025-08-24','0.840','2025-08-24','10:10:01','PLG0024715','685000','685000','0','685000','685000','kasir','2025-08-24 10:10:00','F32524101000');
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-08-24','F325241010003','2025-08-24','10:10:01','AAT','685000','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-250824-0018','D','2025-08-24','10:10:01','kasir','PENJUALAN','F325241010003','2359442000','685000','2360127000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='685000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241010003' 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 ('F325241034341','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2E-YFBA-98-0','CC X METRO MATA LG 18 8K','','1.100','1','100.00','915000','0','0','15000','895000','0','0','0','895000','FIT','00358372','E2E','0','0','-','1','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YFBA-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='E2E-YFBA-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241034341','2025-08-24','1.100','2025-08-24','10:34:35','PLG0024716','895000','895000','0','895000','895000','kasir','2025-08-24 10:34:34','F32524103434');
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-08-24','F325241034341','2025-08-24','10:34:35','FIT','895000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0019','D','2025-08-24','10:34:35','kasir','PENJUALAN','F325241034341','2360127000','895000','2361022000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325241112271','kasir','1',' TEE2 X UB ','TOKO','PT-E','E2TE-XBBF-20-T','CC X MODEL MATA VAR UB 11 ','','1.850','1','100.00','2738000','0','0','15000','2740000','0','0','0','2740000','AAT','T0054319','E2TE','0','0','-','0','1480000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-XBBF-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='E2TE-XBBF-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325241112271','2025-08-24','1.850','2025-08-24','11:12:27','PLG0024717','2740000','2740000','0','2740000','2740000','kasir','2025-08-24 11:12:27','F32524111227');
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-08-24','F325241112271','2025-08-24','11:12:27','AAT','2740000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0020','D','2025-08-24','11:12:27','kasir','PENJUALAN','F325241112271','2361022000','2740000','2363762000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325241122531','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YHXE-169-0','GL FANCY MODEL DAUN SLEP VAR UB 8K ','','3.200','1','100.00','2662000','0','0','15000','2615000','0','0','0','2615000','FIT','00363956','F3E','0','0','-','1','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHXE-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='F3E-YHXE-169-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241122531','2025-08-24','3.200','2025-08-24','11:22:54','PLG0024718','2615000','2615000','0','2615000','2615000','kasir','2025-08-24 11:22:53','F32524112253');
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-08-24','F325241122531','2025-08-24','11:22:54','FIT','2615000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250824-0021','D','2025-08-24','11:22:54','kasir','PENJUALAN','F325241122531','2363762000','2615000','2366377000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325241213261','kasir','1',' MEF1 X YT ','TOKO','PM-F','F1E-XFAX-279-0','GL X OVAL MODEL C YT D60 8K ','','3.430','1','100.00','2854000','0','0','15000','2854000','0','0','0','2854000','FIT','00301877','F1E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XFAX-279-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.430',berat_jual_asli=berat_jual_asli+'3.430',stock_jual='1',berat_akhir=berat_akhir-'3.430',berat_akhir_asli=berat_akhir_asli-'3.430',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='F1E-XFAX-279-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241213261','2025-08-24','3.430','2025-08-24','12:13:27','PLG0024719','2854000','2854000','0','2854000','2854000','kasir','2025-08-24 12:13:26','F32524121326');
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-08-24','F325241213261','2025-08-24','12:13:27','FIT','2854000','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-250824-0022','D','2025-08-24','12:13:27','kasir','PENJUALAN','F325241213261','2366377000','2854000','2369231000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2854000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241213261' 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 ('F325241213262','kasir',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-YEAE-420-0','CC X MODEL MATA CM 14 8K ','','1.350','1','100.00','1100000','0','0','15000','1100000','0','0','0','1100000','FIT','00354192','E2D','0','0','-','0','815000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEAE-420-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='E2D-YEAE-420-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241213262','2025-08-24','1.350','2025-08-24','12:13:27','PLG0024720','1100000','1100000','0','1100000','1100000','kasir','2025-08-24 12:13:26','F32524121326');
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-08-24','F325241213262','2025-08-24','12:13:27','FIT','1100000','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-250824-0023','D','2025-08-24','12:13:27','kasir','PENJUALAN','F325241213262','2369231000','1100000','2370331000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1100000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241213262' 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 ('F325241213263','kasir',' 1',' MEF3 HW ','TOKO','PM-F','F3E-YFXD-36-0','GL MODEL FLIK VAR HW 8K ','','2.410','1','100.00','2005000','0','0','15000','2005000','0','0','0','2005000','FIT','00356356','F3E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFXD-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='F3E-YFXD-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241213263','2025-08-24','2.410','2025-08-24','12:13:27','PLG0024721','2005000','2005000','0','2005000','2005000','kasir','2025-08-24 12:13:26','F32524121326');
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-08-24','F325241213263','2025-08-24','12:13:27','FIT','2005000','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-250824-0024','D','2025-08-24','12:13:27','kasir','PENJUALAN','F325241213263','2370331000','2005000','2372336000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2005000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241213263' 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 ('F325241213264','kasir',' 1',' MEH1 UB ','TOKO','PM-H','H1E-YHXH-267-0','KL TRIXIE MODEL DAUN SLEP VAR UB 8K ','','1.800','1','100.00','1498000','0','0','15000','1498000','0','0','0','1498000','FIT','00364795','H1E','0','0','-','0','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXH-267-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-08-24' AND kode_barang='H1E-YHXH-267-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241213264','2025-08-24','1.800','2025-08-24','12:13:27','PLG0024722','1498000','1498000','0','1498000','1498000','kasir','2025-08-24 12:13:26','F32524121326');
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-08-24','F325241213264','2025-08-24','12:13:27','FIT','1498000','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-250824-0025','D','2025-08-24','12:13:27','kasir','PENJUALAN','F325241213264','2372336000','1498000','2373834000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1498000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241213264' 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 ('F325241221361','kasir','1',' MHB1H X AV','TOKO','PM-B','B1H-YHXH-87-0','GW X TUSUK MRICAN SSLEP AV 8K ','','0.260','1','100.00','230000','0','0','15000','230000','0','0','0','230000','AAT','00364615','B1H','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YHXH-87-0' 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-08-24' AND kode_barang='B1H-YHXH-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241221361','2025-08-24','0.260','2025-08-24','12:21:36','PLG0024723','230000','230000','0','230000','230000','kasir','2025-08-24 12:21:36','F32524122136');
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-08-24','F325241221361','2025-08-24','12:21:36','AAT','230000','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-250824-0026','D','2025-08-24','12:21:36','kasir','PENJUALAN','F325241221361','2373834000','230000','2374064000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='230000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241221361' 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 ('F325241221362','kasir',' 1',' MEB1 X CM ','TOKO','PM-B','B1E-XKAI-66-0','GW X DAISY MATA CM PE 8K ','','0.500','1','100.00','416000','0','0','15000','415000','0','5000','0','420000','AAT','00326872','B1E','0','0','-','1','832000');
UPDATE tm_barang SET tgl_last_jual='2025-08-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-XKAI-66-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-08-24' AND kode_barang='B1E-XKAI-66-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325241221362','2025-08-24','0.500','2025-08-24','12:21:36','PLG0024724','415000','415000','5000','420000','420000','kasir','2025-08-24 12:21:36','F32524122136');
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-08-24','F325241221362','2025-08-24','12:21:36','AAT','420000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250824-0027','D','2025-08-24','12:21:36','kasir','PENJUALAN','F325241221362','2374064000','420000','2374484000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325241221362' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00016806','X-00016806','KL X SANTA AUREL MATA HW 42 8K','GR','---','H1F','BELI','BELI001','1340000','2025-08-24','2.310','1','kasir','2025-08-24 12:29:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00016806','X-00016806');
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-250824-0010','F324110253321','AAT','1','BELI','BELI001','H1F', 'X-00016806', 'KL X SANTA AUREL MATA HW 42 8K','2.310','2.310','100.00','1425000','1340000','580087','849000','1','1340000','1340000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.310',berat_beli_asli=berat_beli_asli+'2.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.310',berat_akhir_asli=berat_akhir_asli+'2.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' 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-250824-0010','2025-08-24','2025-08-24','12:29:48','AAT','---','2.310','1340000','1340000','1340000','1340000','1340000','kasir','2025-08-24 12:29:49','FB-250824-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0010','SANTI','PURWANTORO','','','','kasir','2025-08-24 12:29:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0028','K','2025-08-24','12:29:48','kasir','PEMBELIAN UMUM','FB-250824-0010','2374484000','1340000','2373144000');
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-00016807','X-00016807','CC MODEL SOLITAIRE MATA VAR LG 13 8K','GR','---','E2E','BELI','BELI001','410000','2025-08-24','0.530','1','kasir','2025-08-24 12:30:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00016807','X-00016807');
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-250824-0011','F325101103072','FIT','1','BELI','BELI001','E2E', 'X-00016807', 'CC MODEL SOLITAIRE MATA VAR LG 13 8K','0.530','0.530','100.00','445000','410000','773585','832000','1','410000','410000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0011','2025-08-24','2025-08-24','12:30:21','FIT','---','0.530','410000','410000','410000','410000','410000','kasir','2025-08-24 12:30:21','FB-250824-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0011','FEBRI','GENENG SUKOBOYO SLOGOHIMO','','','','kasir','2025-08-24 12:30:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0029','K','2025-08-24','12:30:21','kasir','PEMBELIAN UMUM','FB-250824-0011','2373144000','410000','2372734000');
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-00016808','X-00016808','GL TRIXIE SERUT MODEL PITA MATA VAR UB 8K','GR','---','F3E','BELI','BELI001','1052000','2025-08-24','1.360','1','kasir','2025-08-24 12:30:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016808','X-00016808');
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-250824-0012','F325101103071','FIT','1','BELI','BELI001','F3E', 'X-00016808', 'GL TRIXIE SERUT MODEL PITA MATA VAR UB 8K','1.360','1.360','100.00','1145000','1052000','773529','832000','1','1052000','1052000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.360',berat_beli_asli=berat_beli_asli+'1.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.360',berat_akhir_asli=berat_akhir_asli+'1.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0012','2025-08-24','2025-08-24','12:30:55','FIT','---','1.360','1052000','1052000','1052000','1052000','1052000','kasir','2025-08-24 12:30:55','FB-250824-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0012','FEBRI','GENENG SUKOBOYO SLOGOHIMO','','','','kasir','2025-08-24 12:30:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0030','K','2025-08-24','12:30:55','kasir','PEMBELIAN UMUM','FB-250824-0012','2372734000','1052000','2371682000');
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-00016809','X-00016809','GL OVAL MODEL C UB D62 8K','GR','---','F1E','BELI','BELI001','1550000','2025-08-24','2.470','1','kasir','2025-08-24 12:31:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016809','X-00016809');
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-250824-0013','F325071023232','FIT','1','BELI','BELI001','F1E', 'X-00016809', 'GL OVAL MODEL C UB D62 8K','2.470','2.470','100.00','1825000','1550000','627530','832000','1','1550000','1550000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.470',berat_beli_asli=berat_beli_asli+'2.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.470',berat_akhir_asli=berat_akhir_asli+'2.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0013','2025-08-24','2025-08-24','12:31:32','FIT','---','2.470','1550000','1550000','1550000','1550000','1550000','kasir','2025-08-24 12:31:32','FB-250824-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0013','FEBRI','GENENG SUKOBOYO SLOGOHIMO','','','','kasir','2025-08-24 12:31:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0031','K','2025-08-24','12:31:32','kasir','PEMBELIAN UMUM','FB-250824-0013','2371682000','1550000','2370132000');
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-00016810','X-00016810','CC X MODEL C GELOMBANG TD 20','GR','---','E1E','BELI','BELI001','1100000','2025-08-24','1.600','1','kasir','2025-08-24 12:32:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00016810','X-00016810');
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-250824-0014','F325071023231','FIT','1','BELI','BELI001','E1E', 'X-00016810', 'CC X MODEL C GELOMBANG TD 20','1.600','1.600','100.00','1183000','1100000','687500','832000','1','1100000','1100000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-250824-0014','2025-08-24','2025-08-24','12:32:25','FIT','---','1.600','1100000','1100000','1100000','1100000','1100000','kasir','2025-08-24 12:32:26','FB-250824-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0014','FEBRI','GENENG SUKOBOYO SLOGOHIMO','','','','kasir','2025-08-24 12:32:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0032','K','2025-08-24','12:32:25','kasir','PEMBELIAN UMUM','FB-250824-0014','2370132000','1100000','2369032000');
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-00016811','X-00016811','CC MODEL SLEP VAR UB 14 8K','GR','---','E1D','BELI','BELI001','900000','2025-08-24','1.520','1','kasir','2025-08-24 12:32:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00016811','X-00016811');
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-250824-0015','F324130944391','FIT','1','BELI','BELI001','E1D', 'X-00016811', 'CC MODEL SLEP VAR UB 14 8K','1.520','1.520','100.00','910000','900000','592105','815000','1','900000','900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.520',berat_beli_asli=berat_beli_asli+'1.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.520',berat_akhir_asli=berat_akhir_asli+'1.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0015','2025-08-24','2025-08-24','12:32:50','FIT','---','1.520','900000','900000','900000','900000','900000','kasir','2025-08-24 12:32:51','FB-250824-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0015','RINI KENZHO','SIGERENG','','','','kasir','2025-08-24 12:32:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0033','K','2025-08-24','12:32:50','kasir','PEMBELIAN UMUM','FB-250824-0015','2369032000','900000','2368132000');
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-00016812','X-00016812','GL X PIPA ANAK BOLA MATA HW 40','GR','---','F2E','BELI','BELI001','1662000','2025-08-24','2.180','1','kasir','2025-08-24 12:33:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00016812','X-00016812');
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-250824-0016','F325010226151','FIT','1','BELI','BELI001','F2E', 'X-00016812', 'GL X PIPA ANAK BOLA MATA HW 40','2.180','2.180','100.00','1788000','1662000','762385','832000','1','1662000','1662000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.180',berat_beli_asli=berat_beli_asli+'2.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.180',berat_akhir_asli=berat_akhir_asli+'2.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-250824-0016','2025-08-24','2025-08-24','12:33:41','FIT','---','2.180','1662000','1662000','1662000','1662000','1662000','kasir','2025-08-24 12:33:41','FB-250824-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0016','SAFA','TEGALREJO','','','','kasir','2025-08-24 12:33:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0034','K','2025-08-24','12:33:41','kasir','PEMBELIAN UMUM','FB-250824-0016','2368132000','1662000','2366470000');
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-00016813','X-00016813','CC X VELG KACA YS 14 8K','GR','---','E1D','BELI','BELI001','720000','2025-08-24','1.010','1','kasir','2025-08-24 13:55:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00016813','X-00016813');
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-250824-0017','F325300854241','AAT','1','BELI','BELI001','E1D', 'X-00016813', 'CC X VELG KACA YS 14 8K','1.010','1.010','100.00','775000','720000','712871','815000','1','720000','720000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250824-0017','2025-08-24','2025-08-24','13:55:29','AAT','---','1.010','720000','720000','720000','720000','720000','kasir','2025-08-24 13:55:29','FB-250824-0017');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250824-0017','SRI MULYANI','PLOSO KISMANTORO','','','','kasir','2025-08-24 13:55:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-24' 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-250824-0035','K','2025-08-24','13:55:29','kasir','PEMBELIAN UMUM','FB-250824-0017','2366470000','720000','2365750000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240858291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240858291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240858291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240859411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240859411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240859411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241006061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241006061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241006061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241010001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241010001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241010001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241010002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241010002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241010002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241010003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241010003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241010003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241034341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241034341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241034341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241112271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241112271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241112271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241122531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241122531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241122531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241213261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241213262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213263' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213263' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241213263';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213264' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241213264' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241213264';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241221361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241221361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241221361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241221362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241221362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241221362';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0016';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250824-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250824-0017';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-24';
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-08-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-24' 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-250825-0001','D','2025-08-25','15:12:53','SYSTEM','SALDO AWAL','SALDO AWAL','0','2365750000','2365750000');
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-250825-0001','D','2025-08-25','15:12:53','BCA','SALDO AWAL','SALDO AWAL','0','684746000','684746000');
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-250825-0001','D','2025-08-25','15:12:53','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-250825-0001','D','2025-08-25','15:12:53','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-08-25';
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-250825-0002','K','2025-08-25','21:32:47','irgosa','BELANJA','BENERIN SALAH TULIS KEBANYAKAN NOL','2365750000','2365750000','0');