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 ('F325310834061','input','1',' MEF3 HW ','TOKO','PM-F','F3E-YCBI-300-0','GL MODEL CAPELA VAR HW 8K ','','2.830','1','100.00','2445000','0','0','15000','2445000','0','0','0','2445000','FIT','00347241','F3E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCBI-300-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2025-08-31' AND kode_barang='F3E-YCBI-300-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 ('F325310834061','2025-08-31','2.830','2025-08-31','08:34:06','PLG0024770','2445000','2445000','0','2445000','2445000','input','2025-08-31 08:34:06','F32531083406');
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-31','F325310834061','2025-08-31','08:34:06','FIT','2445000','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-250831-0002','D','2025-08-31','08:34:06','input','PENJUALAN','F325310834061','10695000','2445000','13140000');
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 ('F325310900191','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-YGAA-205-0','CC X MODEL MATA LG 12 8K ','','0.480','1','100.00','415000','0','0','15000','415000','0','0','0','415000','AAT','00360758','E2E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGAA-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-08-31' AND kode_barang='E2E-YGAA-205-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 ('F325310900191','2025-08-31','0.480','2025-08-31','09:00:20','PLG0024771','415000','415000','0','415000','415000','input','2025-08-31 09:00:19','F32531090019');
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-31','F325310900191','2025-08-31','09:00:20','AAT','415000','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-250831-0003','D','2025-08-31','09:00:20','input','PENJUALAN','F325310900191','13140000','415000','13555000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325310900191' 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 ('F325310900192','input',' 1',' MEF3 LT ','TOKO','PM-F','F3E-YHXF-95-0','GL SIEM MODEL HATI VAR LT 8K ','','1.210','1','100.00','1045000','0','0','15000','1045000','0','0','0','1045000','AAT','00364072','F3E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHXF-95-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-31' AND kode_barang='F3E-YHXF-95-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 ('F325310900192','2025-08-31','1.210','2025-08-31','09:00:20','PLG0024772','1045000','1045000','0','1045000','1045000','input','2025-08-31 09:00:19','F32531090019');
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-31','F325310900192','2025-08-31','09:00:20','AAT','1045000','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-250831-0004','D','2025-08-31','09:00:20','input','PENJUALAN','F325310900192','13555000','1045000','14600000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1045000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325310900192' 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 ('F325310922431','input','1',' TEE1 X BM ','TOKO','PT-E','E1TE-WJAG-94-T','CC X MODEL SLEP BM 22 ','','1.500','1','100.00','2280000','0','0','15000','2280000','0','0','0','2280000','AAT','T0049678','E1TE','0','0','-','0','1520000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-WJAG-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-08-31' AND kode_barang='E1TE-WJAG-94-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 ('F325310922431','2025-08-31','1.500','2025-08-31','09:22:43','PLG0024773','2280000','2280000','0','2280000','2280000','input','2025-08-31 09:22:43','F32531092243');
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-31','F325310922431','2025-08-31','09:22:43','AAT','2280000','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-250831-0005','D','2025-08-31','09:22:43','input','PENJUALAN','F325310922431','14600000','2280000','16880000');
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 ('F325311016341','input','1',' TEE1 X YT ','TOKO','PT-E','E1TE-WHAB-110-T','CC X MODEL SLEP YT 18 ','','3.400','1','100.00','5168000','0','0','15000','5170000','0','0','0','5170000','AAT','T0047411','E1TE','0','0','-','0','1520000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-WHAB-110-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2025-08-31' AND kode_barang='E1TE-WHAB-110-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 ('F325311016341','2025-08-31','3.400','2025-08-31','10:16:34','PLG0024774','5170000','5170000','0','5170000','5170000','input','2025-08-31 10:16:34','F32531101634');
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-31','F325311016341','2025-08-31','10:16:34','AAT','5170000','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-250831-0006','D','2025-08-31','10:16:34','input','PENJUALAN','F325311016341','16880000','5170000','22050000');
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 ('F325311017391','input','1',' MEA1 5K LG','TOKO','PM-A','A1E-YGBB-160-0','AT MODEL BONEKA CAT MATA VAR LG 8K ','','0.550','1','100.00','475000','0','0','15000','475000','0','5000','0','480000','SIN','00362169','A1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGBB-160-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-08-31' AND kode_barang='A1E-YGBB-160-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 ('F325311017391','2025-08-31','0.550','2025-08-31','10:17:40','PLG0024775','475000','475000','5000','480000','480000','input','2025-08-31 10:17:39','F32531101739');
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-31','F325311017391','2025-08-31','10:17:40','SIN','480000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250831-0007','D','2025-08-31','10:17:40','input','PENJUALAN','F325311017391','22050000','480000','22530000');
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 ('F325311039181','input','1',' MDE2 UB 22','TOKO','PM-E','E2D-YBAI-16-0','CC MODEL MATA UB 22 8K ','','2.080','1','100.00','1762000','0','0','15000','1763000','0','0','0','1763000','FIT','00339961','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YBAI-16-0' 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-08-31' AND kode_barang='E2D-YBAI-16-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 ('F325311039181','2025-08-31','2.080','2025-08-31','10:39:18','PLG0024776','1763000','1763000','0','1763000','1763000','input','2025-08-31 10:39:18','F32531103918');
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-31','F325311039181','2025-08-31','10:39:18','FIT','1763000','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-250831-0008','D','2025-08-31','10:39:18','input','PENJUALAN','F325311039181','22530000','1763000','24293000');
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 ('F325311103201','input','1',' MGD1G X BG','TOKO','PM-D','D1G-YGBA-21-0','LT X SLOBOK BOLA SLEP BG 8K','','0.350','1','100.00','314000','0','0','15000','315000','0','25000','0','340000','FIT','00361902','D1G','0','0','-','0','898000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YGBA-21-0' 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-08-31' AND kode_barang='D1G-YGBA-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325311103201','2025-08-31','0.350','2025-08-31','11:03:21','PLG0024777','315000','315000','25000','340000','340000','input','2025-08-31 11:03:20','F32531110320');
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-31','F325311103201','2025-08-31','11:03:21','FIT','340000','25000');
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-250831-0009','D','2025-08-31','11:03:21','input','PENJUALAN','F325311103201','24293000','340000','24633000');
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-00016865','X-00016865','CC X MODEL MATA VAR CM 16 8K','GR','---','E2E','BELI','BELI001','675000','2025-08-31','1.210','1','kasir','2025-08-31 11:12:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00016865','X-00016865');
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-250831-0001','F324311130071','FIT','1','BELI','BELI001','E2E', 'X-00016865', 'CC X MODEL MATA VAR CM 16 8K','1.210','1.210','100.00','725000','675000','557851','864000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' 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-250831-0001','2025-08-31','2025-08-31','11:12:23','FIT','---','1.210','675000','675000','675000','675000','675000','kasir','2025-08-31 11:12:24','FB-250831-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0001','SRI','KISMANTORO','','','','kasir','2025-08-31 11:12:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0010','K','2025-08-31','11:12:23','kasir','PEMBELIAN UMUM','FB-250831-0001','24633000','675000','23958000');
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-00016866','X-00016866','LT X MODEL MATA ROSE UB','GR','---','D2E','BELI','BELI001','1095000','2025-08-31','1.830','1','kasir','2025-08-31 11:12:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00016866','X-00016866');
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-250831-0002','F324250123322','SIN','1','BELI','BELI001','D2E', 'X-00016866', 'LT X MODEL MATA ROSE UB','1.830','1.830','100.00','1165000','1095000','598361','864000','1','1095000','1095000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.830',berat_beli_asli=berat_beli_asli+'1.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.830',berat_akhir_asli=berat_akhir_asli+'1.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-250831-0002','2025-08-31','2025-08-31','11:12:56','SIN','---','1.830','1095000','1095000','1095000','1095000','1095000','kasir','2025-08-31 11:12:56','FB-250831-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0002','SUDARSI','TRITIS TEGALREJO','','','','kasir','2025-08-31 11:12:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0011','K','2025-08-31','11:12:56','kasir','PEMBELIAN UMUM','FB-250831-0002','23958000','1095000','22863000');
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-00016867','X-00016867','AT X GYPSY SLEP VAR LG 8K','GR','---','A1E','BELI','BELI001','420000','2025-08-31','0.550','1','kasir','2025-08-31 11:13:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00016867','X-00016867');
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-250831-0003','F325261050051','SIN','1','BELI','BELI001','A1E', 'X-00016867', 'AT X GYPSY SLEP VAR LG 8K','0.550','0.550','100.00','458000','420000','763636','864000','1','420000','420000','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-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-250831-0003','2025-08-31','2025-08-31','11:13:31','SIN','---','0.550','420000','420000','420000','420000','420000','kasir','2025-08-31 11:13:31','FB-250831-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0003','WULAN','KEPYAR','','','','kasir','2025-08-31 11:13:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0012','K','2025-08-31','11:13:31','kasir','PEMBELIAN UMUM','FB-250831-0003','22863000','420000','22443000');
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-00016868','X-00016868','GL X MODEL CAPELA VAR UB 8K','GR','---','F3E','BELI','BELI001','2235000','2025-08-31','3.530','1','kasir','2025-08-31 11:14:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016868','X-00016868');
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-250831-0004','F325171115112','FIT','1','BELI','BELI001','F3E', 'X-00016868', 'GL X MODEL CAPELA VAR UB 8K','3.530','3.530','100.00','2540000','2235000','633144','864000','1','2235000','2235000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.530',berat_beli_asli=berat_beli_asli+'3.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.530',berat_akhir_asli=berat_akhir_asli+'3.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' 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-250831-0004','2025-08-31','2025-08-31','11:14:08','FIT','---','3.530','2235000','2235000','2235000','2235000','2235000','kasir','2025-08-31 11:14:08','FB-250831-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0004','BILY','TANJUNG BULUKERTO','','','','kasir','2025-08-31 11:14:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0013','K','2025-08-31','11:14:08','kasir','PEMBELIAN UMUM','FB-250831-0004','22443000','2235000','20208000');
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-00016869','X-00016869','LT X MODEL MATA MJ 8K','GR','---','D2E','BELI','BELI001','347000','2025-08-31','0.450','1','kasir','2025-08-31 11:15:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00016869','X-00016869');
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-250831-0005','F325130229422','SIN','1','BELI','BELI001','D2E', 'X-00016869', 'LT X MODEL MATA MJ 8K','0.450','0.450','100.00','375000','347000','771111','864000','1','347000','347000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-250831-0005','2025-08-31','2025-08-31','11:15:12','SIN','---','0.450','347000','347000','347000','347000','347000','kasir','2025-08-31 11:15:13','FB-250831-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0005','BU NENI','PURWANTORO','','','081398422122','kasir','2025-08-31 11:15:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0014','K','2025-08-31','11:15:12','kasir','PEMBELIAN UMUM','FB-250831-0005','20208000','347000','19861000');
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-00016870','X-00016870','KL X FLAMINGO KH 42 9K','GR','---','H2I','BELI','BELI001','1690000','2025-08-31','2.030','1','kasir','2025-08-31 11:15:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00016870','X-00016870');
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-250831-0006','F325130229421','SIN','2','BELI','BELI001','H2I', 'X-00016870', 'KL X FLAMINGO KH 42 9K','2.030','2.030','100.00','1820000','1690000','832512','932000','1','1690000','1690000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-250831-0006','2025-08-31','2025-08-31','11:15:12','SIN','---','2.030','1690000','1690000','1690000','1690000','1690000','kasir','2025-08-31 11:15:13','FB-250831-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0006','BU NENI','PURWANTORO','','','081398422122','kasir','2025-08-31 11:15:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0015','K','2025-08-31','11:15:12','kasir','PEMBELIAN UMUM','FB-250831-0006','19861000','1690000','18171000');
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-00016871','X-00016871','CC ANAK BONEKA CAT MATA VAR LG 8K','GR','---','E2D','BELI','BELI001','657000','2025-08-31','0.900','1','kasir','2025-08-31 11:15:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00016871','X-00016871');
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-250831-0007','F325170158221','FIT','1','BELI','BELI001','E2D', 'X-00016871', 'CC ANAK BONEKA CAT MATA VAR LG 8K','0.900','0.900','100.00','715000','657000','730000','847000','1','657000','657000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' 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-250831-0007','2025-08-31','2025-08-31','11:15:51','FIT','---','0.900','657000','657000','657000','657000','657000','kasir','2025-08-31 11:15:51','FB-250831-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0007','HARNI','BULING BULUKERTO','','','','kasir','2025-08-31 11:15:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0016','K','2025-08-31','11:15:51','kasir','PEMBELIAN UMUM','FB-250831-0007','18171000','657000','17514000');
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 ('F325310208241','input','1',' MDE2 5K LG','TOKO','PM-E','E2D-YFAF-126-0','CC ANAK OSROT BONEKA CAT MATA VAR LG 8K','','1.030','1','100.00','872000','0','0','15000','872000','0','5000','0','877000','SIN','00357768','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAF-126-0' 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-08-31' AND kode_barang='E2D-YFAF-126-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 ('F325310208241','2025-08-31','1.030','2025-08-31','14:08:24','PLG0024778','872000','872000','5000','877000','877000','input','2025-08-31 14:08:24','F32531020824');
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-31','F325310208241','2025-08-31','14:08:24','SIN','877000','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-250831-0017','D','2025-08-31','14:08:24','input','PENJUALAN','F325310208241','17514000','877000','18391000');
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 ('F325310211231','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YGAI-124-0','GL X SANTA ARESO VAR SERUT UB 8K ','','2.360','1','100.00','2039000','0','0','15000','1993000','0','0','0','1993000','FIT','00361877','F3E','0','0','-','1','864000');
UPDATE tm_barang SET tgl_last_jual='2025-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGAI-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2025-08-31' AND kode_barang='F3E-YGAI-124-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 ('F325310211231','2025-08-31','2.360','2025-08-31','14:11:23','PLG0024779','1993000','1993000','0','1993000','1993000','input','2025-08-31 14:11:23','F32531021123');
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-31','F325310211231','2025-08-31','14:11:23','FIT','1993000','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-250831-0018','D','2025-08-31','14:11:23','input','PENJUALAN','F325310211231','18391000','1993000','20384000');
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-00016872','X-00016872','GL Q10 SANTA ARESO VAR UB 9K','GR','---','F4J','BELI','BELI001','1120000','2025-08-31','1.800','1','kasir','2025-08-31 14:24:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-F4J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F4J','X-00016872','X-00016872');
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-250831-0008','F324220255522','FIT','1','BELI','BELI001','F4J', 'X-00016872', 'GL Q10 SANTA ARESO VAR UB 9K','1.800','1.800','100.00','972000','1120000','622222','949000','1','1120000','1120000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.800',berat_beli_asli=berat_beli_asli+'1.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.800',berat_akhir_asli=berat_akhir_asli+'1.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' 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-250831-0008','2025-08-31','2025-08-31','14:24:34','FIT','---','1.800','1120000','1120000','1120000','1120000','1120000','kasir','2025-08-31 14:24:35','FB-250831-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0008','MAHREN','JERUK PACITAN','','','','kasir','2025-08-31 14:24:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0019','K','2025-08-31','14:24:34','kasir','PEMBELIAN UMUM','FB-250831-0008','20384000','1120000','19264000');
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-00016873','X-00016873','AT Q10 HUGGIES BOLA PASIR UB','GR','---','A1G','BELI','BELI001','827000','2025-08-31','1.320','1','kasir','2025-08-31 14:25:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1G','X-00016873','X-00016873');
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-250831-0009','F324220200491','SIN','1','BELI','BELI001','A1G', 'X-00016873', 'AT Q10 HUGGIES BOLA PASIR UB','1.320','1.320','100.00','900000','827000','626515','898000','1','827000','827000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.320',berat_beli_asli=berat_beli_asli+'1.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.320',berat_akhir_asli=berat_akhir_asli+'1.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1G' 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-250831-0009','2025-08-31','2025-08-31','14:25:19','SIN','---','1.320','827000','827000','827000','827000','827000','kasir','2025-08-31 14:25:19','FB-250831-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250831-0009','NURUL','PURWANTORO','','','','kasir','2025-08-31 14:25:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-31' 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-250831-0020','K','2025-08-31','14:25:19','kasir','PEMBELIAN UMUM','FB-250831-0009','19264000','827000','18437000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325310208241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325310208241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325310208241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325310211231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325310211231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325310211231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325310834061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325310834061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325310834061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325310900191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325310900191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325310900191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325310900192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325310900192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325310900192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325310922431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325310922431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325310922431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325311016341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325311016341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325311016341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325311017391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325311017391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325311017391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325311039181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325311039181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325311039181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325311103201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325311103201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325311103201';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250831-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250831-0009';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-31';
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-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-31';
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-09-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-31' 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-250901-0001','D','2025-09-01','15:11:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','18437000','18437000');
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-250901-0001','D','2025-09-01','15:11:25','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-250901-0001','D','2025-09-01','15:11:25','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-250901-0001','D','2025-09-01','15:11:25','BCA','SALDO AWAL','SALDO AWAL','0','684746000','684746000');
UPDATE tp_system SET tgl_system='2025-09-01';