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 ('F325120828051','input','1',' MEE2 X AY ','TOKO','PM-E','E2E-YJXB-61-0','CC X MODEL MATA AY 18 8K ','','0.770','1','100.00','774000','0','0','15000','775000','0','0','0','775000','FIT','00371645','E2E','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='E2E-YJXB-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325120828051','2025-10-12','0.770','2025-10-12','08:28:06','PLG0025223','775000','775000','0','775000','775000','input','2025-10-12 08:28:05','F32512082805');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325120828051','2025-10-12','08:28:06','FIT','775000','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-251012-0002','D','2025-10-12','08:28:06','input','PENJUALAN','F325120828051','272721000','775000','273496000');
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 ('F325120850501','input','1',' MDE1 CM 12','TOKO','PM-E','E1D-YIXH-33-0','CC MODEL DAUN VAR CM 12 8K ','','0.920','1','100.00','906000','0','0','15000','905000','0','0','0','905000','AAT','00368589','E1D','0','0','-','1','985000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIXH-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='E1D-YIXH-33-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 ('F325120850501','2025-10-12','0.920','2025-10-12','08:50:51','PLG0025224','905000','905000','0','905000','905000','input','2025-10-12 08:50:50','F32512085050');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325120850501','2025-10-12','08:50:51','AAT','905000','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-251012-0003','D','2025-10-12','08:50:51','input','PENJUALAN','F325120850501','273496000','905000','274401000');
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 ('F325120948371','input','1',' MEF3E X HW','TOKO','PM-F','F3E-YIAE-230-0','GL X SANTA ARESO SERUT VAR HW 8K ','','2.500','1','100.00','2512000','0','0','15000','2515000','0','0','0','2515000','AAT','00369681','F3E','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAE-230-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='F3E-YIAE-230-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 ('F325120948371','2025-10-12','2.500','2025-10-12','09:48:38','PLG0025225','2515000','2515000','0','2515000','2515000','input','2025-10-12 09:48:37','F32512094837');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325120948371','2025-10-12','09:48:38','AAT','2515000','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-251012-0004','D','2025-10-12','09:48:38','input','PENJUALAN','F325120948371','274401000','2515000','276916000');
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 ('F325121008241','input','1',' TDE1 X YS ','TOKO','PT-E','E1TD-XJAB-130-T','CC X VELG KACA YS 13 17K ','','1.020','1','100.00','1800000','0','0','15000','1800000','0','0','0','1800000','AAT','T0062991','E1TD','0','0','-','0','1765000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-XJAB-130-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='E1TD-XJAB-130-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 ('F325121008241','2025-10-12','1.020','2025-10-12','10:08:25','PLG0025226','1800000','1800000','0','1800000','1800000','input','2025-10-12 10:08:24','F32512100824');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325121008241','2025-10-12','10:08:25','AAT','1800000','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-251012-0005','D','2025-10-12','10:08:25','input','PENJUALAN','F325121008241','276916000','1800000','278716000');
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 ('F325121053461','input','1',' MEF1 UB D5','TOKO','PM-F','F1E-YGBB-154-0','GL OVAL MODEL BOLA ARESO VAR UB D56 8K ','','3.120','1','100.00','3136000','0','0','15000','3135000','0','0','0','3135000','SIN','00362163','F1E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YGBB-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='F1E-YGBB-154-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 ('F325121053461','2025-10-12','3.120','2025-10-12','10:53:47','PLG0025227','3135000','3135000','0','3135000','3135000','input','2025-10-12 10:53:46','F32512105346');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325121053461','2025-10-12','10:53:47','SIN','3135000','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-251012-0006','D','2025-10-12','10:53:47','input','PENJUALAN','F325121053461','278716000','3135000','281851000');
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 ('F325121120411','input','1',' MEF3 YT ','TOKO','PM-F','F3E-YJXF-173-0','GL SANTA SERUT MODEL DAUN VAR YT 8K ','','1.990','1','100.00','2000000','0','0','15000','2000000','0','0','0','2000000','SIN','00372470','F3E','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='F3E-YJXF-173-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 ('F325121120411','2025-10-12','1.990','2025-10-12','11:20:41','PLG0025228','2000000','2000000','0','2000000','2000000','input','2025-10-12 11:20:41','F32512112041');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325121120411','2025-10-12','11:20:41','SIN','2000000','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-251012-0007','D','2025-10-12','11:20:41','input','PENJUALAN','F325121120411','281851000','2000000','283851000');
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 ('F325121134001','input','1',' MEE2 HTM 1','TOKO','PM-E','E2E-YJXF-42-0','CC PIPA MODEL MATA VAR HTM 19 8K ','','0.550','1','100.00','553000','0','0','15000','553000','0','0','0','553000','FIT','00372339','E2E','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='E2E-YJXF-42-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 ('F325121134001','2025-10-12','0.550','2025-10-12','11:34:00','PLG0025229','553000','553000','0','553000','553000','input','2025-10-12 11:34:00','F32512113400');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325121134001','2025-10-12','11:34:00','FIT','553000','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-251012-0008','D','2025-10-12','11:34:00','input','PENJUALAN','F325121134001','283851000','553000','284404000');
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 ('F325121209381','input','1',' MHA1H DG ','TOKO','PM-A','A1H-YIAB-279-0','AT BABY TINDIK SLEP DG 8K ','','0.250','1','100.00','266000','0','0','15000','265000','0','0','0','265000','SIN','00369056','A1H','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YIAB-279-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='A1H-YIAB-279-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 ('F325121209381','2025-10-12','0.250','2025-10-12','12:09:39','PLG0025230','265000','265000','0','265000','265000','input','2025-10-12 12:09:38','F32512120938');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325121209381','2025-10-12','12:09:39','SIN','265000','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-251012-0009','D','2025-10-12','12:09:39','input','PENJUALAN','F325121209381','284404000','265000','284669000');
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-00017206','X-00017206','GW COR 17K','GR','---','B1TE','BELI','BELI001','1990000','2025-10-12','1.650','1','kasir','2025-10-12 12:24:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1TE','X-00017206','X-00017206');
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-251012-0001','F323211102421','AAT','1','BELI','BELI001','B1TE', 'X-00017206', 'GW COR 17K','1.800','1.650','100.00','1530000','1990000','1206061','1785000','1','1990000','1990000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.650',berat_beli_asli=berat_beli_asli+'1.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.650',berat_akhir_asli=berat_akhir_asli+'1.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1TE' 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-251012-0001','2025-10-12','2025-10-12','12:24:42','AAT','---','1.650','1990000','1990000','1990000','1990000','1990000','kasir','2025-10-12 12:24:42','FB-251012-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0001','ABEL','KISMANTORO','','','','kasir','2025-10-12 12:24:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0010','K','2025-10-12','12:24:42','kasir','PEMBELIAN UMUM','FB-251012-0001','284669000','1990000','282679000');
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-00017207','X-00017207','AS EXTENSION DG 8K','GR','---','S1G','BELI','BELI001','285000','2025-10-12','0.360','1','kasir','2025-10-12 12:25:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-S1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-S1G','X-00017207','X-00017207');
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-251012-0002','F325110312451','FIT','1','BELI','BELI001','S1G', 'X-00017207', 'AS EXTENSION DG 8K','0.360','0.360','100.00','310000','285000','791667','1045000','1','285000','285000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='S1G' 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-251012-0002','2025-10-12','2025-10-12','12:25:27','FIT','---','0.360','285000','285000','285000','285000','285000','kasir','2025-10-12 12:25:28','FB-251012-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0002','VIKA','DANGKRANG','','','','kasir','2025-10-12 12:25:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0011','K','2025-10-12','12:25:27','kasir','PEMBELIAN UMUM','FB-251012-0002','282679000','285000','282394000');
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-00017208','X-00017208','CC MODEL DAUN SLEP VAR LG 12 8K','GR','---','E1E','BELI','BELI001','370000','2025-10-12','0.480','1','kasir','2025-10-12 12:26:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017208','X-00017208');
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-251012-0003','F325020935501','AAT','1','BELI','BELI001','E1E', 'X-00017208', 'CC MODEL DAUN SLEP VAR LG 12 8K','0.480','0.480','100.00','403000','370000','770833','1005000','1','370000','370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' 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-251012-0003','2025-10-12','2025-10-12','12:25:59','AAT','---','0.480','370000','370000','370000','370000','370000','kasir','2025-10-12 12:26:00','FB-251012-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0003','IKA','BAKALAN','','','','kasir','2025-10-12 12:26:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0012','K','2025-10-12','12:25:59','kasir','PEMBELIAN UMUM','FB-251012-0003','282394000','370000','282024000');
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-00017209','X-00017209','CC X MODEL SOLITAIRE MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1050000','2025-10-12','1.410','1','kasir','2025-10-12 12:26:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017209','X-00017209');
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-251012-0004','F325291203031','FIT','1','BELI','BELI001','E2D', 'X-00017209', 'CC X MODEL SOLITAIRE MATA CM 16 8K','1.410','1.410','100.00','1130000','1050000','744681','985000','1','1050000','1050000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.410',berat_beli_asli=berat_beli_asli+'1.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.410',berat_akhir_asli=berat_akhir_asli+'1.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' 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-251012-0004','2025-10-12','2025-10-12','12:26:21','FIT','---','1.410','1050000','1050000','1050000','1050000','1050000','kasir','2025-10-12 12:26:21','FB-251012-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0004','ANNA','TALESAN','','','','kasir','2025-10-12 12:26:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0013','K','2025-10-12','12:26:21','kasir','PEMBELIAN UMUM','FB-251012-0004','282024000','1050000','280974000');
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-00017210','X-00017210','CC X MODEL MATA HITAM YT 10 8K','GR','---','E2D','BELI','BELI001','490000','2025-10-12','0.820','1','kasir','2025-10-12 12:27:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017210','X-00017210');
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-251012-0005','F325111139471','FIT','1','BELI','BELI001','E2D', 'X-00017210', 'CC X MODEL MATA HITAM YT 10 8K','0.820','0.820','100.00','586000','490000','597561','985000','1','490000','490000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' 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-251012-0005','2025-10-12','2025-10-12','12:27:02','FIT','---','0.820','490000','490000','490000','490000','490000','kasir','2025-10-12 12:27:03','FB-251012-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0005','VIKA','PAKIS BARU','','','','kasir','2025-10-12 12:27:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0014','K','2025-10-12','12:27:02','kasir','PEMBELIAN UMUM','FB-251012-0005','280974000','490000','280484000');
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-00017211','X-00017211','CC VELG POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','730000','2025-10-12','1.000','1','kasir','2025-10-12 12:27:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017211','X-00017211');
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-251012-0006','F325180842223','AAT','1','BELI','BELI001','E1D', 'X-00017211', 'CC VELG POLOS CM 14 8K','1.000','1.000','100.00','793000','730000','730000','985000','1','730000','730000','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-10-12' 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-251012-0006','2025-10-12','2025-10-12','12:27:38','AAT','---','1.000','730000','730000','730000','730000','730000','kasir','2025-10-12 12:27:38','FB-251012-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0006','KARTI','SANGGRONG TEGALREJO','','','','kasir','2025-10-12 12:27:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0015','K','2025-10-12','12:27:38','kasir','PEMBELIAN UMUM','FB-251012-0006','280484000','730000','279754000');
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-00017212','X-00017212','KL ANAK MILANO BONEKA CAT VAR UB 9K','GR','---','H3J','BELI','BELI001','1830000','2025-10-12','2.480','1','kasir','2025-10-12 12:28:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-H3J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H3J','X-00017212','X-00017212');
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-251012-0007','F324100958032','SIN','1','BELI','BELI001','H3J', 'X-00017212', 'KL ANAK MILANO BONEKA CAT VAR UB 9K','2.480','2.480','100.00','1780000','1830000','737903','1105000','1','1830000','1830000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.480',berat_beli_asli=berat_beli_asli+'2.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.480',berat_akhir_asli=berat_akhir_asli+'2.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H3J' 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-251012-0007','2025-10-12','2025-10-12','12:28:54','SIN','---','2.480','1830000','1830000','1830000','1830000','1830000','kasir','2025-10-12 12:28:54','FB-251012-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0007','KALILAH','KLUNGGEN SLOGOHIMO','','','','kasir','2025-10-12 12:28:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0016','K','2025-10-12','12:28:54','kasir','PEMBELIAN UMUM','FB-251012-0007','279754000','1830000','277924000');
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-00017213','X-00017213','CC SALANG LEWAT DW','GR','---','E0TA','BELI','BELI001','1295000','2025-10-12','1.000','1','kasir','2025-10-12 12:29:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00017213','X-00017213');
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-251012-0008','F325021112491','AAT','1','BELI','BELI001','E0TA', 'X-00017213', 'CC SALANG LEWAT DW','1.000','1.000','100.00','1370000','1295000','1295000','1700000','1','1295000','1295000','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-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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-251012-0008','2025-10-12','2025-10-12','12:29:32','AAT','---','1.000','1295000','1295000','1295000','1295000','1295000','kasir','2025-10-12 12:29:33','FB-251012-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0008','MARIMAH','GAMBIRANOM KISMANTORO','','','','kasir','2025-10-12 12:29:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0017','K','2025-10-12','12:29:32','kasir','PEMBELIAN UMUM','FB-251012-0008','277924000','1295000','276629000');
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-00017214','X-00017214','GL X OVAL C GELOMBANG YT 54','GR','---','F1E','BELI','BELI001','2220000','2025-10-12','3.220','1','kasir','2025-10-12 12:30:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017214','X-00017214');
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-251012-0009','F324110122291','FIT','1','BELI','BELI001','F1E', 'X-00017214', 'GL X OVAL C GELOMBANG YT 54','3.220','3.220','100.00','1680000','2220000','689441','1005000','1','2220000','2220000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.220',berat_beli_asli=berat_beli_asli+'3.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.220',berat_akhir_asli=berat_akhir_asli+'3.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' 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-251012-0009','2025-10-12','2025-10-12','12:30:09','FIT','---','3.220','2220000','2220000','2220000','2220000','2220000','kasir','2025-10-12 12:30:09','FB-251012-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0009','ERNAWATI','SAMBITILENG','','','','kasir','2025-10-12 12:30:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0018','K','2025-10-12','12:30:09','kasir','PEMBELIAN UMUM','FB-251012-0009','276629000','2220000','274409000');
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 ('F325120108391','kasir','1',' MEF1 YT D5','TOKO','PM-F','F1E-YJXD-262-0','GL OVAL MODEL C YT D52 8K ','','2.270','1','100.00','2281000','0','0','15000','2280000','0','0','0','2280000','SIN','00372242','F1E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJXD-262-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='F1E-YJXD-262-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 ('F325120108391','2025-10-12','2.270','2025-10-12','13:08:39','PLG0025231','2280000','2280000','0','2280000','2280000','kasir','2025-10-12 13:08:39','F32512010839');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','F325120108391','2025-10-12','13:08:39','SIN','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-251012-0019','D','2025-10-12','13:08:39','kasir','PENJUALAN','F325120108391','274409000','2280000','276689000');
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-00017215','X-00017215','AT COR 8K','GR','---','A1F','BELI','BELI001','490000','2025-10-12','0.800','1','kasir','2025-10-12 14:02:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017215','X-00017215');
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-251012-0010','F323090206241','FIT','1','BELI','BELI001','A1F', 'X-00017215', 'AT COR 8K','0.800','0.800','100.00','395000','490000','612500','1025000','1','490000','490000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.800',berat_beli_asli=berat_beli_asli+'0.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.800',berat_akhir_asli=berat_akhir_asli+'0.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-251012-0010','2025-10-12','2025-10-12','14:02:05','FIT','---','0.800','490000','490000','490000','490000','490000','kasir','2025-10-12 14:02:06','FB-251012-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251012-0010','RISKA','SOKOBOYO','','','','kasir','2025-10-12 14:02:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-12' 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-251012-0020','K','2025-10-12','14:02:05','kasir','PEMBELIAN UMUM','FB-251012-0010','276689000','490000','276199000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120108391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120108391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120108391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120828051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120828051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120828051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120850501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120850501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120850501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120948371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120948371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120948371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121008241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121008241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121008241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121053461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121053461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121053461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121120411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121120411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121120411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121134001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121134001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121134001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121209381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121209381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121209381';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251012-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251012-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-12';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-12' 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-251013-0001','D','2025-10-13','15:12:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','276199000','276199000');
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-251013-0001','D','2025-10-13','15:12:51','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251013-0001','D','2025-10-13','15:12:51','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-251013-0001','D','2025-10-13','15:12:51','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-10-13';