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 ('F326280903571','input','1',' MFE1F KH 1','TOKO','PM-E','E1F-ZIBA-287-0','CC MODEL SPECTRA SLEP KH 12 8K ','','0.350','1','100.00','373000','0','0','15000','373000','0','0','0','373000','FIT','00424831','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIBA-287-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='2026-09-28' AND kode_barang='E1F-ZIBA-287-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 ('F326280903571','2026-09-28','0.350','2026-09-28','09:03:58','PLG0031564','373000','373000','0','373000','373000','input','2026-09-28 09:03:57','F32628090357');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280903571','2026-09-28','09:03:58','FIT','373000','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-260928-0002','D','2026-09-28','09:03:58','input','PENJUALAN','F326280903571','7639134000','373000','7639507000');
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 ('F326280942041','input','1',' MEF1 PM D4','TOKO','PM-F','F1E-YKBH-92-0','GL ANAK PIPA MODEL DAUN VAR PM D40 8K ','','2.080','1','100.00','2174000','0','0','15000','2175000','0','0','0','2175000','FIT','00378953','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKBH-92-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='2026-09-28' AND kode_barang='F1E-YKBH-92-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 ('F326280942041','2026-09-28','2.080','2026-09-28','09:42:04','PLG0031565','2175000','2175000','0','2175000','2175000','input','2026-09-28 09:42:04','F32628094204');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280942041','2026-09-28','09:42:04','FIT','2175000','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-260928-0003','D','2026-09-28','09:42:04','input','PENJUALAN','F326280942041','7639507000','2175000','7641682000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2175000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280942041' 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 ('F326280942042','input',' 1',' MEA1E LG ','TOKO','PM-A','A1E-ZHBG-215-0','AT GYPSY MATA SLEP LG 8K ','','0.520','1','100.00','543000','0','0','15000','543000','0','0','0','543000','FIT','00420881','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHBG-215-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='A1E-ZHBG-215-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 ('F326280942042','2026-09-28','0.520','2026-09-28','09:42:04','PLG0031566','543000','543000','0','543000','543000','input','2026-09-28 09:42:04','F32628094204');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280942042','2026-09-28','09:42:04','FIT','543000','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-260928-0004','D','2026-09-28','09:42:04','input','PENJUALAN','F326280942042','7641682000','543000','7642225000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280942042' 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 ('F326281119101','input','1',' MGF3G X UB','TOKO','PM-F','F3G-ZEBH-41-0','GL X BORSALINO UB 8K ','OLW','0.350','1','100.00','380000','0','0','15000','383000','0','5000','0','388000','SIN','00405259','F3G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-ZEBH-41-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='2026-09-28' AND kode_barang='F3G-ZEBH-41-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 ('F326281119101','2026-09-28','0.350','2026-09-28','11:19:10','PLG0031567','383000','383000','5000','388000','388000','input','2026-09-28 11:19:10','F32628111910');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326281119101','2026-09-28','11:19:10','SIN','388000','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-260928-0005','D','2026-09-28','11:19:10','input','PENJUALAN','F326281119101','7642225000','388000','7642613000');
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 ('F326281235181','input','1',' MEF1 UB D5','TOKO','PM-F','F1E-ZIBF-328-0','GL OVAL MODEL C UB D52 8K ','','2.180','1','100.00','2300000','0','0','15000','2278000','0','0','0','2278000','SIN','00425946','F1E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBF-328-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='F1E-ZIBF-328-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 ('F326281235181','2026-09-28','2.180','2026-09-28','12:35:19','PLG0031568','2278000','2278000','0','2278000','2278000','input','2026-09-28 12:35:18','F32628123518');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326281235181','2026-09-28','12:35:19','SIN','2278000','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-260928-0006','D','2026-09-28','12:35:19','input','PENJUALAN','F326281235181','7642613000','2278000','7644891000');
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-00020349','X-00020349','AT COR 8K','GR','---','A1E','BELI','BELI001','780000','2026-09-28','1.070','1','kasir','2026-09-28 13:20:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020349','X-00020349');
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-260928-0001','F323091041331','LIS','1','BELI','BELI001','A1E', 'X-00020349', 'AT COR 8K','1.070','1.070','100.00','522000','780000','728972','1055000','1','780000','780000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0001','2026-09-28','2026-09-28','13:20:07','LIS','---','1.070','780000','780000','780000','780000','780000','kasir','2026-09-28 13:20:08','FB-260928-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0001','VIVI','GADUNGAN KISMANTORO','','','','kasir','2026-09-28 13:20:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0007','K','2026-09-28','13:20:07','kasir','PEMBELIAN UMUM','FB-260928-0001','7644891000','780000','7644111000');
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-00020350','X-00020350','GL PIPA ANAK CAT UB 40 8K','GR','---','F1E','BELI','BELI001','1120000','2026-09-28','1.350','1','kasir','2026-09-28 13:21:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020350','X-00020350');
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-260928-0002','F326030247231','FIT','1','BELI','BELI001','F1E', 'X-00020350', 'GL PIPA ANAK CAT UB 40 8K','1.350','1.350','100.00','1493000','1120000','829630','1055000','1','1120000','1120000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0002','2026-09-28','2026-09-28','13:21:14','FIT','---','1.350','1120000','1120000','1120000','1120000','1120000','kasir','2026-09-28 13:21:15','FB-260928-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0002','NAFIDA','KISMANTORO','','','081226824074','kasir','2026-09-28 13:21:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0008','K','2026-09-28','13:21:14','kasir','PEMBELIAN UMUM','FB-260928-0002','7644111000','1120000','7642991000');
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-00020351','X-00020351','CC MODEL MATA HW 14 8K','GR','---','E2E','BELI','BELI001','390000','2026-09-28','0.430','1','kasir','2026-09-28 13:24:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020351','X-00020351');
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-260928-0003','F325241059141','SIN','1','BELI','BELI001','E2E', 'X-00020351', 'CC MODEL MATA HW 14 8K','0.430','0.430','100.00','435000','390000','906977','1055000','1','390000','390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0003','2026-09-28','2026-09-28','13:24:00','SIN','---','0.430','390000','390000','390000','390000','390000','kasir','2026-09-28 13:24:00','FB-260928-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0003','DINA','PURWANTORO','','','081390003903','kasir','2026-09-28 13:24:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0009','K','2026-09-28','13:24:00','kasir','PEMBELIAN UMUM','FB-260928-0003','7642991000','390000','7642601000');
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-00020352','X-00020352','CC MODEL SLEP HT 18 8K','GR','---','E1E','BELI','BELI001','630000','2026-09-28','0.650','1','kasir','2026-09-28 13:24:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020352','X-00020352');
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-260928-0004','F326221031591','SIN','2','BELI','BELI001','E1E', 'X-00020352', 'CC MODEL SLEP HT 18 8K','0.650','0.650','100.00','685000','630000','969231','1055000','1','630000','630000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0004','2026-09-28','2026-09-28','13:24:00','SIN','---','0.650','630000','630000','630000','630000','630000','kasir','2026-09-28 13:24:00','FB-260928-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0004','SUGIYANTI','BAKALAN','','','','kasir','2026-09-28 13:24:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0010','K','2026-09-28','13:24:00','kasir','PEMBELIAN UMUM','FB-260928-0004','7642601000','630000','7641971000');
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-00020353','X-00020353','GL BANGKOK HOLLOW SLEP PM 56 8K','GR','---','F1E','BELI','BELI001','3895000','2026-09-28','4.050','1','kasir','2026-09-28 13:25:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020353','X-00020353');
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-260928-0005','F326131012581','LIS','1','BELI','BELI001','F1E', 'X-00020353', 'GL BANGKOK HOLLOW SLEP PM 56 8K','4.050','4.050','100.00','4233000','3895000','961728','1055000','1','3895000','3895000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.050',berat_beli_asli=berat_beli_asli+'4.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.050',berat_akhir_asli=berat_akhir_asli+'4.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0005','2026-09-28','2026-09-28','13:25:02','LIS','---','4.050','3895000','3895000','3895000','3895000','3895000','kasir','2026-09-28 13:25:03','FB-260928-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0005','RATINI','GAMBIRANOM','','','','kasir','2026-09-28 13:25:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0011','K','2026-09-28','13:25:02','kasir','PEMBELIAN UMUM','FB-260928-0005','7641971000','3895000','7638076000');
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 ('F326280209411','input','1',' MEF3 XXX H','TOKO','PM-F','F3E-ZFXH-156-0','GL XXX CAPELLA CD VAR HW 8K ','','1.570','1','100.00','1641000','0','0','15000','1595000','0','0','0','1595000','LIS','00408017','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXH-156-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='F3E-ZFXH-156-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 ('F326280209411','2026-09-28','1.570','2026-09-28','14:09:41','PLG0031569','1595000','1595000','0','1595000','1595000','input','2026-09-28 14:09:41','F32628020941');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280209411','2026-09-28','14:09:41','LIS','1595000','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-260928-0012','D','2026-09-28','14:09:41','input','PENJUALAN','F326280209411','7638076000','1595000','7639671000');
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 ('F326280211141','input','1',' MEB1E CM ','TOKO','PM-B','B1E-YLBX-270-0','GW PANJANG DAUN SLEP CM 8K ','','0.630','1','100.00','658000','0','0','15000','658000','0','0','0','658000','SIN','00382150','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLBX-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='B1E-YLBX-270-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280211141','2026-09-28','0.630','2026-09-28','14:11:15','PLG0031570','658000','658000','0','658000','658000','input','2026-09-28 14:11:14','F32628021114');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280211141','2026-09-28','14:11:15','SIN','658000','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-260928-0013','D','2026-09-28','14:11:15','input','PENJUALAN','F326280211141','7639671000','658000','7640329000');
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 ('F326280223271','input','1',' MEE2 X PM ','TOKO','PM-E','E2E-ZGXI-289-0','CC X MODEL MATA PM 10 8K ','','0.580','1','100.00','606000','0','0','15000','605000','0','0','0','605000','SIN','00413008','E2E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXI-289-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='E2E-ZGXI-289-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 ('F326280223271','2026-09-28','0.580','2026-09-28','14:23:28','PLG0031571','605000','605000','0','605000','605000','input','2026-09-28 14:23:27','F32628022327');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280223271','2026-09-28','14:23:28','SIN','605000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260928-0014','D','2026-09-28','14:23:28','input','PENJUALAN','F326280223271','7640329000','605000','7640934000');
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-00020354','X-00020354','CC MODEL MATA VAR YT 20 8K','GR','---','E2E','BELI','BELI001','517000','2026-09-28','0.670','1','kasir','2026-09-28 14:30:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020354','X-00020354');
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-260928-0006','F325211013361','FIT','1','BELI','BELI001','E2E', 'X-00020354', 'CC MODEL MATA VAR YT 20 8K','0.670','0.670','100.00','556000','517000','771642','1055000','1','517000','517000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.670',berat_beli_asli=berat_beli_asli+'0.670',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.670',berat_akhir_asli=berat_akhir_asli+'0.670',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0006','2026-09-28','2026-09-28','14:30:08','FIT','---','0.670','517000','517000','517000','517000','517000','kasir','2026-09-28 14:30:08','FB-260928-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0006','BETTY','KISMANTORO','','','','kasir','2026-09-28 14:30:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0015','K','2026-09-28','14:30:08','kasir','PEMBELIAN UMUM','FB-260928-0006','7640934000','517000','7640417000');
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 ('F326280238361','kasir','1',' MEF1 LT D6','TOKO','PM-F','F1E-ZIBA-426-0','GL OVAL MODEL CLOVER SLEP LT D60 8K ','','3.440','1','100.00','3595000','0','0','15000','3595000','0','0','0','3595000','SIN','00424970','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBA-426-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.440',berat_jual_asli=berat_jual_asli+'3.440',stock_jual='1',berat_akhir=berat_akhir-'3.440',berat_akhir_asli=berat_akhir_asli-'3.440',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='F1E-ZIBA-426-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 ('F326280238361','2026-09-28','3.440','2026-09-28','14:38:37','PLG0031572','3595000','3595000','0','3595000','3595000','kasir','2026-09-28 14:38:36','F32628023836');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280238361','2026-09-28','14:38:37','SIN','3595000','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-260928-0016','D','2026-09-28','14:38:37','kasir','PENJUALAN','F326280238361','7640417000','3595000','7644012000');
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 ('F326280242121','kasir','1',' MDD2D X LG','TOKO','PM-D','D2D-YLBI-79-0','LT X MODEL MATA VAR LG 8K ','','1.060','1','100.00','1086000','0','0','15000','1086000','0','0','0','1086000','LIS','00383231','D2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YLBI-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='D2D-YLBI-79-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 ('F326280242121','2026-09-28','1.060','2026-09-28','14:42:13','PLG0031573','1086000','1086000','0','1086000','1086000','kasir','2026-09-28 14:42:12','F32628024212');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280242121','2026-09-28','14:42:13','LIS','1086000','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-260928-0017','D','2026-09-28','14:42:13','kasir','PENJUALAN','F326280242121','7644012000','1086000','7645098000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1086000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280242121' 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 ('F326280242122','kasir',' 1',' MDD2 XXX U','TOKO','PM-D','D2D-ZIXI-176-0','LT XXX MODEL MATA UB 8K ','','1.070','1','100.00','1097000','0','0','15000','1065000','0','0','0','1065000','LIS','00422714','D2D','0','0','-','1','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZIXI-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-09-28' AND kode_barang='D2D-ZIXI-176-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 ('F326280242122','2026-09-28','1.070','2026-09-28','14:42:13','PLG0031574','1065000','1065000','0','1065000','1065000','kasir','2026-09-28 14:42:12','F32628024212');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-28','F326280242122','2026-09-28','14:42:13','LIS','1065000','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-260928-0018','D','2026-09-28','14:42:13','kasir','PENJUALAN','F326280242122','7645098000','1065000','7646163000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1065000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280242122' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020355','X-00020355','CC MODEL MATA KH 14 8K','GR','---','E2E','BELI','BELI001','485000','2026-09-28','0.500','1','kasir','2026-09-28 14:52:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020355','X-00020355');
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-260928-0007','F326061100341','SIN','1','BELI','BELI001','E2E', 'X-00020355', 'CC MODEL MATA KH 14 8K','0.500','0.500','100.00','535000','485000','970000','1055000','1','485000','485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0007','2026-09-28','2026-09-28','14:52:37','SIN','---','0.500','485000','485000','485000','485000','485000','kasir','2026-09-28 14:52:38','FB-260928-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0007','NOVITA','BITING BADEGAN','','','081318551308','kasir','2026-09-28 14:52:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0019','K','2026-09-28','14:52:37','kasir','PEMBELIAN UMUM','FB-260928-0007','7646163000','485000','7645678000');
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-00020356','X-00020356','CC MODEL MATA SLEP VAR CM 20 8K','GR','---','E2D','BELI','BELI001','1357000','2026-09-28','1.460','1','kasir','2026-09-28 14:55:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020356','X-00020356');
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-260928-0008','F326141044211','SIN','1','BELI','BELI001','E2D', 'X-00020356', 'CC MODEL MATA SLEP VAR CM 20 8K','1.460','1.460','100.00','1475000','1357000','929452','1035000','1','1357000','1357000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.460',berat_beli_asli=berat_beli_asli+'1.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.460',berat_akhir_asli=berat_akhir_asli+'1.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-28' 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-260928-0008','2026-09-28','2026-09-28','14:55:29','SIN','---','1.460','1357000','1357000','1357000','1357000','1357000','kasir','2026-09-28 14:55:29','FB-260928-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260928-0008','ENDAH','BITING JATISARI','','','','kasir','2026-09-28 14:55:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-28' 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-260928-0020','K','2026-09-28','14:55:29','kasir','PEMBELIAN UMUM','FB-260928-0008','7645678000','1357000','7644321000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260928-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260928-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280209411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280209411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280209411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280211141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280211141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280211141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280223271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280223271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280223271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280238361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280238361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280238361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280242121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280242121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280242121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280242122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280242122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280242122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280903571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280903571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280903571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280942041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280942041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280942041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280942042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280942042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280942042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281119101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281119101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281119101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281235181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281235181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281235181';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-28';
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='2026-09-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-28' 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-260929-0001','D','2026-09-29','15:12:11','SYSTEM','SALDO AWAL','SALDO AWAL','0','7644321000','7644321000');
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-260929-0001','D','2026-09-29','15:12:11','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-260929-0001','D','2026-09-29','15:12:11','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-260929-0001','D','2026-09-29','15:12:11','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
UPDATE tp_system SET tgl_system='2026-09-29';