function MainComponent() { const [candidates, setCandidates] = React.useState([]); const [editingId, setEditingId] = React.useState(null); const [formData, setFormData] = React.useState({ number: '', name: '', supporters: '', policy: '', profile: '' }); React.useEffect(()=>{ fetchCandidates(); }, []); const fetchCandidates = async ()=>{ const response = await fetch('/api/db/db-49', { method: 'POST', body: JSON.stringify({ query: 'SELECT * FROM `ldp_presidential_candidates` ORDER BY `number`' }) }); const data = await response.json(); setCandidates(data); }; const handleInputChange = (e)=>{ setFormData({ ...formData, [e.target.name]: e.target.value }); }; const handleSubmit = async (e)=>{ e.preventDefault(); if (editingId) { await fetch('/api/db/db-49', { method: 'POST', body: JSON.stringify({ query: 'UPDATE `ldp_presidential_candidates` SET `number` = ?, `name` = ?, `supporters` = ?, `policy` = ?, `profile` = ? WHERE `id` = ?', values: [ formData.number, formData.name, formData.supporters, formData.policy, formData.profile, editingId ] }) }); setEditingId(null); } else { await fetch('/api/db/db-49', { method: 'POST', body: JSON.stringify({ query: 'INSERT INTO `ldp_presidential_candidates` (`number`, `name`, `supporters`, `policy`, `profile`) VALUES (?, ?, ?, ?, ?)', values: [ formData.number, formData.name, formData.supporters, formData.policy, formData.profile ] }) }); } setFormData({ number: '', name: '', supporters: '', policy: '', profile: '' }); fetchCandidates(); }; const handleEdit = (candidate)=>{ setEditingId(candidate.id); setFormData(candidate); }; const handleDelete = async (id)=>{ await fetch('/api/db/db-49', { method: 'POST', body: JSON.stringify({ query: 'DELETE FROM `ldp_presidential_candidates` WHERE `id` = ?', values: [ id ] }) }); fetchCandidates(); }; const handleFileUpload = async (e)=>{ const file = e.target.files[0]; if (file) { const formData = new FormData(); formData.append('inputFile', file); formData.append('outputType', 'html'); const response = await fetch('/integrations/file-converter/convert', { method: 'POST', body: formData }); const htmlContent = await response.text(); const parser = new DOMParser(); const doc = parser.parseFromString(htmlContent, 'text/html'); const rows = doc.querySelectorAll('tr'); for(let i = 1; i < rows.length; i++){ const cells = rows[i].querySelectorAll('td'); if (cells.length === 5) { await fetch('/api/db/db-49', { method: 'POST', body: JSON.stringify({ query: 'INSERT INTO `ldp_presidential_candidates` (`number`, `name`, `supporters`, `policy`, `profile`) VALUES (?, ?, ?, ?, ?)', values: [ cells[0].textContent, cells[1].textContent, cells[2].textContent, cells[3].textContent, cells[4].textContent ] }) }); } } fetchCandidates(); } }; return /*#__PURE__*/ React.createElement("div", { className: "container mx-auto p-4 font-sans", __source: { fileName: "", lineNumber: 111, columnNumber: 5 }, __self: this }, /*#__PURE__*/ React.createElement("h1", { className: "text-3xl font-bold mb-6 text-center", __source: { fileName: "", lineNumber: 112, columnNumber: 7 }, __self: this }, "自民党総裁選挙候補者管理"), /*#__PURE__*/ React.createElement("form", { onSubmit: handleSubmit, className: "mb-8 bg-gray-100 p-6 rounded-lg shadow-md", __source: { fileName: "", lineNumber: 114, columnNumber: 7 }, __self: this }, /*#__PURE__*/ React.createElement("div", { className: "grid grid-cols-1 md:grid-cols-2 gap-4", __source: { fileName: "", lineNumber: 115, columnNumber: 9 }, __self: this }, /*#__PURE__*/ React.createElement("input", { type: "text", name: "number", value: formData.number, onChange: handleInputChange, placeholder: "所見番号", className: "w-full px-3 py-2 border rounded", required: true, __source: { fileName: "", lineNumber: 116, columnNumber: 11 }, __self: this }), /*#__PURE__*/ React.createElement("input", { type: "text", name: "name", value: formData.name, onChange: handleInputChange, placeholder: "候補者名", className: "w-full px-3 py-2 border rounded", required: true, __source: { fileName: "", lineNumber: 125, columnNumber: 11 }, __self: this }), /*#__PURE__*/ React.createElement("input", { type: "text", name: "supporters", value: formData.supporters, onChange: handleInputChange, placeholder: "推薦議員", className: "w-full px-3 py-2 border rounded", __source: { fileName: "", lineNumber: 134, columnNumber: 11 }, __self: this }), /*#__PURE__*/ React.createElement("textarea", { name: "policy", value: formData.policy, onChange: handleInputChange, placeholder: "政策", className: "w-full px-3 py-2 border rounded", rows: "3", __source: { fileName: "", lineNumber: 142, columnNumber: 11 }, __self: this }), /*#__PURE__*/ React.createElement("textarea", { name: "profile", value: formData.profile, onChange: handleInputChange, placeholder: "プロフィール等", className: "w-full px-3 py-2 border rounded", rows: "3", __source: { fileName: "", lineNumber: 150, columnNumber: 11 }, __self: this })), /*#__PURE__*/ React.createElement("button", { type: "submit", className: "mt-4 bg-blue-500 text-white px-4 py-2 rounded hover:bg-blue-600", __source: { fileName: "", lineNumber: 159, columnNumber: 9 }, __self: this }, editingId ? '更新' : '追加')), /*#__PURE__*/ React.createElement("div", { className: "mb-4", __source: { fileName: "", lineNumber: 164, columnNumber: 7 }, __self: this }, /*#__PURE__*/ React.createElement("label", { htmlFor: "fileUpload", className: "bg-green-500 text-white px-4 py-2 rounded hover:bg-green-600 cursor-pointer", __source: { fileName: "", lineNumber: 165, columnNumber: 9 }, __self: this }, "エクセルファイルをアップロード"), /*#__PURE__*/ React.createElement("input", { id: "fileUpload", type: "file", accept: ".xlsx,.xls", onChange: handleFileUpload, className: "hidden", __source: { fileName: "", lineNumber: 168, columnNumber: 9 }, __self: this })), /*#__PURE__*/ React.createElement("div", { className: "overflow-x-auto", __source: { fileName: "", lineNumber: 177, columnNumber: 7 }, __self: this }, /*#__PURE__*/ React.createElement("table", { className: "w-full bg-white shadow-md rounded-lg overflow-hidden", __source: { fileName: "", lineNumber: 178, columnNumber: 9 }, __self: this }, /*#__PURE__*/ React.createElement("thead", { className: "bg-gray-200", __source: { fileName: "", lineNumber: 179, columnNumber: 11 }, __self: this }, /*#__PURE__*/ React.createElement("tr", { __source: { fileName: "", lineNumber: 180, columnNumber: 13 }, __self: this }, /*#__PURE__*/ React.createElement("th", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 181, columnNumber: 15 }, __self: this }, "所見番号"), /*#__PURE__*/ React.createElement("th", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 182, columnNumber: 15 }, __self: this }, "候補者名"), /*#__PURE__*/ React.createElement("th", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 183, columnNumber: 15 }, __self: this }, "推薦議員"), /*#__PURE__*/ React.createElement("th", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 184, columnNumber: 15 }, __self: this }, "政策"), /*#__PURE__*/ React.createElement("th", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 185, columnNumber: 15 }, __self: this }, "プロフィール等"), /*#__PURE__*/ React.createElement("th", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 186, columnNumber: 15 }, __self: this }, "操作"))), /*#__PURE__*/ React.createElement("tbody", { __source: { fileName: "", lineNumber: 189, columnNumber: 11 }, __self: this }, candidates.map((candidate)=>/*#__PURE__*/ React.createElement("tr", { key: candidate.id, className: "border-b", __source: { fileName: "", lineNumber: 191, columnNumber: 15 }, __self: this }, /*#__PURE__*/ React.createElement("td", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 192, columnNumber: 17 }, __self: this }, candidate.number), /*#__PURE__*/ React.createElement("td", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 193, columnNumber: 17 }, __self: this }, candidate.name), /*#__PURE__*/ React.createElement("td", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 194, columnNumber: 17 }, __self: this }, candidate.supporters), /*#__PURE__*/ React.createElement("td", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 195, columnNumber: 17 }, __self: this }, candidate.policy), /*#__PURE__*/ React.createElement("td", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 196, columnNumber: 17 }, __self: this }, candidate.profile), /*#__PURE__*/ React.createElement("td", { className: "px-4 py-2", __source: { fileName: "", lineNumber: 197, columnNumber: 17 }, __self: this }, /*#__PURE__*/ React.createElement("button", { onClick: ()=>handleEdit(candidate), className: "bg-yellow-500 text-white px-2 py-1 rounded mr-2 hover:bg-yellow-600", __source: { fileName: "", lineNumber: 198, columnNumber: 19 }, __self: this }, /*#__PURE__*/ React.createElement("i", { className: "fas fa-edit", __source: { fileName: "", lineNumber: 202, columnNumber: 21 }, __self: this }), " 編集"), /*#__PURE__*/ React.createElement("button", { onClick: ()=>handleDelete(candidate.id), className: "bg-red-500 text-white px-2 py-1 rounded hover:bg-red-600", __source: { fileName: "", lineNumber: 204, columnNumber: 19 }, __self: this }, /*#__PURE__*/ React.createElement("i", { className: "fas fa-trash-alt", __source: { fileName: "", lineNumber: 208, columnNumber: 21 }, __self: this }), " 削除")))))))); }

自民党総裁選挙 候補者管理

自民党総裁選挙候補者管理