async function handler({ userId, page = 1, limit = 10 }) { try { console.log(`getUserForksFixed called with userId=${userId}, page=${page}, limit=${limit}`); if (!userId) { console.error("Error: Missing userId parameter"); return { success: false, error: "ユーザーIDが必要です", message: "ユーザーIDが必要です" }; } const offset = (page - 1) * limit; console.log(`Fetching forks for user: ${userId}, page: ${page}, limit: ${limit}, offset: ${offset}`); // 数値に変換 const userIdNum = parseInt(userId, 10); const userIdStr = userId.toString(); const pageNum = parseInt(page, 10); const limitNum = parseInt(limit, 10); const offsetNum = parseInt(offset, 10); console.log(`Converted params: userIdNum=${userIdNum}, userIdStr=${userIdStr}, pageNum=${pageNum}, limitNum=${limitNum}, offsetNum=${offsetNum}`); // まず投稿の総数を取得 const countQuery = ` SELECT COUNT(*) as total FROM forks WHERE temp_user_id = $1 OR user_id = $2 `; console.log("Executing count query"); const totalCount = await sql(countQuery, [ userIdNum, userIdStr ]); console.log(`Count query result:`, totalCount); const total = parseInt(totalCount[0]?.total || 0); console.log(`Total forks: ${total}`); // 投稿を取得 const forksQuery = ` SELECT f.*, (SELECT COUNT(*) FROM likes WHERE fork_id = f.id) as like_count, (SELECT COUNT(*) FROM comments WHERE fork_id = f.id) as comment_count, ARRAY( SELECT t.name FROM tags t JOIN fork_tags ft ON t.id = ft.tag_id WHERE ft.fork_id = f.id ) as tags FROM forks f WHERE f.temp_user_id = $1 OR f.user_id = $2 ORDER BY f.created_at DESC LIMIT $3 OFFSET $4 `; console.log("Executing forks query"); const forks = await sql(forksQuery, [ userIdNum, userIdStr, limitNum, offsetNum ]); console.log(`Forks query result: ${forks.length} forks found`); if (!forks) { console.error("Error: Forks query returned null or undefined"); return { success: false, error: "投稿の取得に失敗しました", message: "データベースクエリが失敗しました" }; } const totalPages = Math.ceil(total / limitNum); console.log(`Pagination: total=${total}, page=${pageNum}, limit=${limitNum}, totalPages=${totalPages}`); return { success: true, forks, pagination: { total, page: pageNum, limit: limitNum, totalPages } }; } catch (error) { console.error("Error fetching user forks:", error); return { success: false, error: "ユーザーの投稿取得中にエラーが発生しました", message: error.message, details: error.stack }; } } function MainComponent() { const [email, setEmail] = useState(""); const [password, setPassword] = useState(""); const [loading, setLoading] = useState(false); const [error, setError] = useState(""); const [passwordErrors, setPasswordErrors] = useState([]); const { signUpWithCredentials, signInWithGoogle } = useAuth(); // パスワードのバリデーション関数 const validatePassword = (pass)=>{ const errors = []; if (pass.length < 8) { errors.push("パスワードは8文字以上である必要があります"); } if (!/\d/.test(pass)) { errors.push("数字を含める必要があります"); } if (!/[A-Z]/.test(pass)) { errors.push("大文字を含める必要があります"); } return errors; }; // パスワード入力時のバリデーション const handlePasswordChange = (e)=>{ const newPassword = e.target.value; setPassword(newPassword); setPasswordErrors(validatePassword(newPassword)); }; const handleSubmit = async (e)=>{ e.preventDefault(); setError(""); if (!email || !password) { setError("メールアドレスとパスワードを入力してください"); return; } // パスワードポリシーの最終チェック const errors = validatePassword(password); if (errors.length > 0) { setPasswordErrors(errors); return; } try { setLoading(true); await signUpWithCredentials({ email, password, callbackUrl: "/create-profile", redirect: true }); } catch (err) { console.error("Registration error:", err); setError("登録中にエラーが発生しました。もう一度お試しください。"); setLoading(false); } }; const handleGoogleSignIn = async ()=>{ try { setLoading(true); await signInWithGoogle({ callbackUrl: "/create-profile", redirect: true }); } catch (err) { console.error("Google sign in error:", err); setError("Googleログイン中にエラーが発生しました。もう一度お試しください。"); setLoading(false); } }; return /*#__PURE__*/ React.createElement("div", { className: "min-h-screen bg-gray-50 flex items-center justify-center py-12 px-4", __source: { fileName: "", lineNumber: 186, columnNumber: 5 }, __self: this }, /*#__PURE__*/ React.createElement("script", { async: true, src: "https://www.googletagmanager.com/gtag/js?id=G-HEQ3RFVT7N", __source: { fileName: "", lineNumber: 188, columnNumber: 7 }, __self: this }), /*#__PURE__*/ React.createElement("script", { __source: { fileName: "", lineNumber: 192, columnNumber: 7 }, __self: this }, ` window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-HEQ3RFVT7N'); `), /*#__PURE__*/ React.createElement("div", { className: "max-w-md w-full bg-white rounded-lg shadow-md p-8", __source: { fileName: "", lineNumber: 199, columnNumber: 7 }, __self: this }, /*#__PURE__*/ React.createElement("h1", { className: "text-2xl font-bold text-gray-800 mb-6 text-center", __source: { fileName: "", lineNumber: 200, columnNumber: 9 }, __self: this }, "新規アカウント登録"), error && /*#__PURE__*/ React.createElement("div", { className: "mb-4 p-3 bg-red-100 text-red-700 rounded-md", __source: { fileName: "", lineNumber: 205, columnNumber: 11 }, __self: this }, error), /*#__PURE__*/ React.createElement("form", { onSubmit: handleSubmit, className: "space-y-6", __source: { fileName: "", lineNumber: 210, columnNumber: 9 }, __self: this }, /*#__PURE__*/ React.createElement("div", { __source: { fileName: "", lineNumber: 211, columnNumber: 11 }, __self: this }, /*#__PURE__*/ React.createElement("label", { htmlFor: "email", className: "block text-sm font-medium text-gray-700 mb-1", __source: { fileName: "", lineNumber: 212, columnNumber: 13 }, __self: this }, "メールアドレス"), /*#__PURE__*/ React.createElement("input", { type: "email", id: "email", value: email, onChange: (e)=>setEmail(e.target.value), className: "w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-indigo-500", required: true, __source: { fileName: "", lineNumber: 218, columnNumber: 13 }, __self: this })), /*#__PURE__*/ React.createElement("div", { __source: { fileName: "", lineNumber: 228, columnNumber: 11 }, __self: this }, /*#__PURE__*/ React.createElement("label", { htmlFor: "password", className: "block text-sm font-medium text-gray-700 mb-1", __source: { fileName: "", lineNumber: 229, columnNumber: 13 }, __self: this }, "パスワード"), /*#__PURE__*/ React.createElement("input", { type: "password", id: "password", value: password, onChange: handlePasswordChange, className: `w-full px-3 py-2 border ${passwordErrors.length > 0 ? "border-red-300" : "border-gray-300"} rounded-md focus:outline-none focus:ring-2 focus:ring-indigo-500`, required: true, __source: { fileName: "", lineNumber: 235, columnNumber: 13 }, __self: this }), /*#__PURE__*/ React.createElement("div", { className: "mt-2 space-y-1", __source: { fileName: "", lineNumber: 246, columnNumber: 13 }, __self: this }, /*#__PURE__*/ React.createElement("p", { className: "text-sm text-gray-600", __source: { fileName: "", lineNumber: 247, columnNumber: 15 }, __self: this }, "パスワードの要件:"), /*#__PURE__*/ React.createElement("ul", { className: "text-sm space-y-1", __source: { fileName: "", lineNumber: 248, columnNumber: 15 }, __self: this }, /*#__PURE__*/ React.createElement("li", { className: `flex items-center ${password.length >= 8 ? "text-green-600" : "text-gray-500"}`, __source: { fileName: "", lineNumber: 249, columnNumber: 17 }, __self: this }, /*#__PURE__*/ React.createElement("span", { className: "mr-2", __source: { fileName: "", lineNumber: 252, columnNumber: 19 }, __self: this }, password.length >= 8 ? "✓" : "•"), "8文字以上"), /*#__PURE__*/ React.createElement("li", { className: `flex items-center ${/\d/.test(password) ? "text-green-600" : "text-gray-500"}`, __source: { fileName: "", lineNumber: 257, columnNumber: 17 }, __self: this }, /*#__PURE__*/ React.createElement("span", { className: "mr-2", __source: { fileName: "", lineNumber: 260, columnNumber: 19 }, __self: this }, /\d/.test(password) ? "✓" : "•"), "数字を含む"), /*#__PURE__*/ React.createElement("li", { className: `flex items-center ${/[A-Z]/.test(password) ? "text-green-600" : "text-gray-500"}`, __source: { fileName: "", lineNumber: 265, columnNumber: 17 }, __self: this }, /*#__PURE__*/ React.createElement("span", { className: "mr-2", __source: { fileName: "", lineNumber: 268, columnNumber: 19 }, __self: this }, /[A-Z]/.test(password) ? "✓" : "•"), "大文字を含む")))), /*#__PURE__*/ React.createElement("button", { type: "submit", disabled: loading || passwordErrors.length > 0, className: "w-full bg-indigo-600 text-white py-2 px-4 rounded-md hover:bg-indigo-700 disabled:opacity-50 disabled:cursor-not-allowed", __source: { fileName: "", lineNumber: 277, columnNumber: 11 }, __self: this }, loading ? "登録中..." : "アカウントを作成")), /*#__PURE__*/ React.createElement("div", { className: "mt-4", __source: { fileName: "", lineNumber: 286, columnNumber: 9 }, __self: this }, /*#__PURE__*/ React.createElement("div", { className: "relative", __source: { fileName: "", lineNumber: 287, columnNumber: 11 }, __self: this }, /*#__PURE__*/ React.createElement("div", { className: "absolute inset-0 flex items-center", __source: { fileName: "", lineNumber: 288, columnNumber: 13 }, __self: this }, /*#__PURE__*/ React.createElement("div", { className: "w-full border-t border-gray-300", __source: { fileName: "", lineNumber: 289, columnNumber: 15 }, __self: this })), /*#__PURE__*/ React.createElement("div", { className: "relative flex justify-center text-sm", __source: { fileName: "", lineNumber: 291, columnNumber: 13 }, __self: this }, /*#__PURE__*/ React.createElement("span", { className: "px-2 bg-white text-gray-500", __source: { fileName: "", lineNumber: 292, columnNumber: 15 }, __self: this }, "または")))), /*#__PURE__*/ React.createElement("div", { className: "mt-6 text-center", __source: { fileName: "", lineNumber: 297, columnNumber: 9 }, __self: this }, /*#__PURE__*/ React.createElement("p", { className: "text-sm text-gray-600", __source: { fileName: "", lineNumber: 298, columnNumber: 11 }, __self: this }, "すでにアカウントをお持ちですか？", " ", /*#__PURE__*/ React.createElement("a", { href: "/account/signin", className: "text-indigo-600 hover:text-indigo-800", __source: { fileName: "", lineNumber: 300, columnNumber: 13 }, __self: this }, "ログイン"))))); }