[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","650c11c2-8be6-11f1-9363-1607ee4eb77e","name","fileType","script","content","// Val Town cron val — 진학프로 즉시지원 공고 스크래퍼\n// 15분마다 실행되어 신규 즉시지원 공고를 구글 시트에 추가합니다.\n//\n// 필요한 Val Town 환경변수:\n// GOOGLE_SERVICE_ACCOUNT_EMAIL - 서비스 계정 client_email\n// GOOGLE_PRIVATE_KEY - 서비스 계정 private_key (PEM, \\n 포함 그대로)\n// GOOGLE_SHEET_ID - 스프레드시트 ID\n// (https://docs.google.com/spreadsheets/d/<이 부분>/edit)\n\nconst JINHAKPRO_API =\n \"https://www.jinhakpro.com/api/applicant/recruit/sub-list?isOnlyOnlineApply=true&bookmarkSortType=1&majorCategoryCode=&recruitTypeCode=&sortType=1\";\n\nconst SHEET_NAME = \"즉시지원 리스트\";\nconst SHEETS_SCOPE = \"https://www.googleapis.com/auth/spreadsheets\";\n\ninterface RecruitItem {\n recruitIdx: number;\n organName: string;\n recruitTitle: string;\n}\n\nfunction base64url(bytes: ArrayBuffer | Uint8Array): string {\n const arr = bytes instanceof Uint8Array ? bytes : new Uint8Array(bytes);\n let str = \"\";\n for (const b of arr) str += String.fromCharCode(b);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n}\n\nfunction pemToArrayBuffer(pem: string): ArrayBuffer {\n const clean = pem\n .replace(/-----BEGIN PRIVATE KEY-----/, \"\")\n .replace(/-----END PRIVATE KEY-----/, \"\")\n .replace(/\\s+/g, \"\");\n const binary = atob(clean);\n const bytes = new Uint8Array(binary.length);\n for (let i = 0; i < binary.length; i++) bytes[i] = binary.charCodeAt(i);\n return bytes.buffer;\n}\n\nasync function getAccessToken(\n clientEmail: string,\n privateKeyPem: string,\n): Promise {\n const now = Math.floor(Date.now() / 1000);\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const claim = {\n iss: clientEmail,\n scope: SHEETS_SCOPE,\n aud: \"https://oauth2.googleapis.com/token\",\n exp: now + 3600,\n iat: now,\n };\n\n const encoder = new TextEncoder();\n const signingInput = base64url(encoder.encode(JSON.stringify(header))) +\n \".\" +\n base64url(encoder.encode(JSON.stringify(claim)));\n\n const key = await crypto.subtle.importKey(\n \"pkcs8\",\n pemToArrayBuffer(privateKeyPem.replace(/\\\\n/g, \"\\n\")),\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n key,\n encoder.encode(signingInput),\n );\n\n const jwt = `${signingInput}.${base64url(signature)}`;\n\n const res = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"urn:ietf:params:oauth:grant-type:jwt-bearer\",\n assertion: jwt,\n }),\n });\n\n if (!res.ok) {\n throw new Error(`Google 토큰 발급 실패: ${res.status} ${await res.text()}`);\n }\n const data = await res.json();\n return data.access_token as string;\n}\n\nasync function fetchImmediateApplyList(): Promise {\n const res = await fetch(JINHAKPRO_API, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36\",\n },\n });\n if (!res.ok) {\n throw new Error(`진학프로 API 호출 실패: ${res.status}`);\n }\n return await res.json();\n}\n\nasync function getExistingIds(\n sheetId: string,\n accessToken: string,\n): Promise> {\n const range = encodeURIComponent(`${SHEET_NAME}!A2:A`);\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${range}`,\n { headers: { Authorization: `Bearer ${accessToken}` } },\n );\n if (!res.ok) {\n throw new Error(`시트 조회 실패: ${res.status} ${await res.text()}`);\n }\n const data = await res.json();\n const rows: string[][] = data.values ?? [];\n return new Set(rows.map((r) => String(r[0]).trim()).filter(Boolean));\n}\n\nasync function appendRows(\n sheetId: string,\n accessToken: string,\n rows: (string | number)[][],\n) {\n if (rows.length === 0) return;\n const range = encodeURIComponent(`${SHEET_NAME}!A:D`);\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${range}:append?valueInputOption=USER_ENTERED`,\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ values: rows }),\n },\n );\n if (!res.ok) {\n throw new Error(`시트 추가 실패: ${res.status} ${await res.text()}`);\n }\n}\n\nexport default async function () {\n try {\n console.log(\"1. 시작\");\n\n const clientEmail = Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT_EMAIL\");\n const privateKey = Deno.env.get(\"GOOGLE_PRIVATE_KEY\");\n const sheetId = Deno.env.get(\"GOOGLE_SHEET_ID\");\n\n console.log(\"2. 환경변수 확인\", {\n hasEmail: !!clientEmail,\n hasKey: !!privateKey,\n hasSheetId: !!sheetId,\n });\n\n if (!clientEmail || !privateKey || !sheetId) {\n throw new Error(\n \"환경변수 GOOGLE_SERVICE_ACCOUNT_EMAIL / GOOGLE_PRIVATE_KEY / GOOGLE_SHEET_ID 를 설정해주세요.\",\n );\n }\n\n console.log(\"3. 구글 액세스 토큰 발급 시도\");\n const accessToken = await getAccessToken(clientEmail, privateKey);\n console.log(\"4. 토큰 발급 성공\");\n\n console.log(\"5. 진학프로 API + 기존 시트 데이터 조회 시도\");\n const [items, existingIds] = await Promise.all([\n fetchImmediateApplyList(),\n getExistingIds(sheetId, accessToken),\n ]);\n console.log(\"6. 조회 성공\", {\n itemCount: items.length,\n existingCount: existingIds.size,\n });\n\n const newRows = items\n .filter((item) => !existingIds.has(String(item.recruitIdx)))\n .map((item) => [\n item.recruitIdx,\n item.organName,\n item.recruitTitle,\n `https://www.jinhakpro.com/recruit/${item.recruitIdx}`,\n ]);\n\n console.log(\"7. 신규 행 추가 시도\", { newRowCount: newRows.length });\n await appendRows(sheetId, accessToken, newRows);\n\n console.log(\n `8. 완료: 조회 ${items.length}건 중 신규 ${newRows.length}건 추가 (${\n new Date().toISOString()\n })`,\n );\n } catch (err) {\n console.error(\"에러 발생:\", err instanceof Error ? err.message : err);\n throw err;\n }\n}","// Val Town cron val — 진학프로 즉시지원 공고 스크래퍼\n// 15분마다 실행되어 신규 즉시지원 공고를 구글 시트에 추가합니다.\n//\n// 필요한 Val Town 환경변수:\n// GOOGLE_SERVICE_ACCOUNT_EMAIL - 서비스 계정 client_email\n// GOOGLE_PRIVATE_KEY - 서비스 계정 private_key (PEM, \\n 포함 그대로)\n// GOOGLE_SHEET_ID - 스프레드시트 ID\n// (https://docs.google.com/spreadsheets/d/<이 부분>/edit)\n\nconst JINHAKPRO_API =\n \"https://www.jinhakpro.com/api/applicant/recruit/sub-list?isOnlyOnlineApply=true&bookmarkSortType=1&majorCategoryCode=&recruitTypeCode=&sortType=1\";\n\nconst SHEET_NAME = \"즉시지원 리스트\";\nconst SHEETS_SCOPE = \"https://www.googleapis.com/auth/spreadsheets\";\n\ninterface RecruitItem {\n recruitIdx: number;\n organName: string;\n recruitTitle: string;\n}\n\nfunction base64url(bytes: ArrayBuffer | Uint8Array): string {\n const arr = bytes instanceof Uint8Array ? bytes : new Uint8Array(bytes);\n let str = \"\";\n for (const b of arr) str += String.fromCharCode(b);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n}\n\nfunction pemToArrayBuffer(pem: string): ArrayBuffer {\n const clean = pem\n .replace(/-----BEGIN PRIVATE KEY-----/, \"\")\n .replace(/-----END PRIVATE KEY-----/, \"\")\n .replace(/\\s+/g, \"\");\n const binary = atob(clean);\n const bytes = new Uint8Array(binary.length);\n for (let i = 0; i < binary.length; i++) bytes[i] = binary.charCodeAt(i);\n return bytes.buffer;\n}\n\nasync function getAccessToken(\n clientEmail: string,\n privateKeyPem: string,\n): Promise {\n const now = Math.floor(Date.now() / 1000);\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const claim = {\n iss: clientEmail,\n scope: SHEETS_SCOPE,\n aud: \"https://oauth2.googleapis.com/token\",\n exp: now + 3600,\n iat: now,\n };\n\n const encoder = new TextEncoder();\n const signingInput = base64url(encoder.encode(JSON.stringify(header))) +\n \".\" +\n base64url(encoder.encode(JSON.stringify(claim)));\n\n const key = await crypto.subtle.importKey(\n \"pkcs8\",\n pemToArrayBuffer(privateKeyPem.replace(/\\\\n/g, \"\\n\")),\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n key,\n encoder.encode(signingInput),\n );\n\n const jwt = `${signingInput}.${base64url(signature)}`;\n\n const res = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"urn:ietf:params:oauth:grant-type:jwt-bearer\",\n assertion: jwt,\n }),\n });\n\n if (!res.ok) {\n throw new Error(`Google 토큰 발급 실패: ${res.status} ${await res.text()}`);\n }\n const data = await res.json();\n return data.access_token as string;\n}\n\nasync function fetchImmediateApplyList(): Promise {\n const res = await fetch(JINHAKPRO_API, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36\",\n },\n });\n if (!res.ok) {\n throw new Error(`진학프로 API 호출 실패: ${res.status}`);\n }\n return await res.json();\n}\n\nasync function getExistingIds(\n sheetId: string,\n accessToken: string,\n): Promise> {\n const range = encodeURIComponent(`${SHEET_NAME}!A2:A`);\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${range}`,\n { headers: { Authorization: `Bearer ${accessToken}` } },\n );\n if (!res.ok) {\n throw new Error(`시트 조회 실패: ${res.status} ${await res.text()}`);\n }\n const data = await res.json();\n const rows: string[][] = data.values ?? [];\n return new Set(rows.map((r) => String(r[0]).trim()).filter(Boolean));\n}\n\nasync function appendRows(\n sheetId: string,\n accessToken: string,\n rows: (string | number)[][],\n) {\n if (rows.length === 0) return;\n const range = encodeURIComponent(`${SHEET_NAME}!A:D`);\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${range}:append?valueInputOption=USER_ENTERED`,\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ values: rows }),\n },\n );\n if (!res.ok) {\n throw new Error(`시트 추가 실패: ${res.status} ${await res.text()}`);\n }\n}\n\nasync function main() {\n try {\n console.log(\"1. 시작\");\n\n const clientEmail = Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT_EMAIL\");\n const privateKey = Deno.env.get(\"GOOGLE_PRIVATE_KEY\");\n const sheetId = Deno.env.get(\"GOOGLE_SHEET_ID\");\n\n console.log(\"2. 환경변수 확인\", {\n hasEmail: !!clientEmail,\n hasKey: !!privateKey,\n hasSheetId: !!sheetId,\n });\n\n if (!clientEmail || !privateKey || !sheetId) {\n throw new Error(\n \"환경변수 GOOGLE_SERVICE_ACCOUNT_EMAIL / GOOGLE_PRIVATE_KEY / GOOGLE_SHEET_ID 를 설정해주세요.\",\n );\n }\n\n console.log(\"3. 구글 액세스 토큰 발급 시도\");\n const accessToken = await getAccessToken(clientEmail, privateKey);\n console.log(\"4. 토큰 발급 성공\");\n\n console.log(\"5. 진학프로 API + 기존 시트 데이터 조회 시도\");\n const [items, existingIds] = await Promise.all([\n fetchImmediateApplyList(),\n getExistingIds(sheetId, accessToken),\n ]);\n console.log(\"6. 조회 성공\", {\n itemCount: items.length,\n existingCount: existingIds.size,\n });\n\n const newRows = items\n .filter((item) => !existingIds.has(String(item.recruitIdx)))\n .map((item) => [\n item.recruitIdx,\n item.organName,\n item.recruitTitle,\n `https://www.jinhakpro.com/recruit/${item.recruitIdx}`,\n ]);\n\n console.log(\"7. 신규 행 추가 시도\", { newRowCount: newRows.length });\n await appendRows(sheetId, accessToken, newRows);\n\n console.log(\n `8. 완료: 조회 ${items.length}건 중 신규 ${newRows.length}건 추가 (${\n new Date().toISOString()\n })`,\n );\n } catch (err) {\n console.error(\"에러 발생:\", err instanceof Error ? err.message : err);\n throw err;\n }\n}\n\nawait main();\n\nexport default main;","createdAt",["D",1785396743201],"branchVersion","branchId","ab40a1c6-cfd2-496a-a9c2-34e63f89a917","id","5461a472-3eb0-4aec-9078-69e2095e712b","apply-scraper",["D",1785395707777],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","23ef44b6-0322-429f-82d4-c6c5c9ed07bd","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fab59-fa19-74a9-8c48-b3ba8908f9cd","tursoName","5461a4723eb04aec907869e2095e712b","tursoHostname","5461a4723eb04aec907869e2095e712b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789455078571],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jinhakproscrap","handle","displayName","JINHAKPRO진학프로","avatar","https://lh3.googleusercontent.com/a/ACg8ocJJHCLJdaXxt4Zt5JwFN3dPSn7GeRRiyCk-G3WKEyDe3VfWFiI=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":154,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":155,"_82":156,"_84":157,"_86":25},"tree",[148],"files",[148],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"406bf35e-40f6-4286-8027-b6be3f2444ae","parentId","latest",["D",1785396743201],3,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":146,"_147":61},"connections",{"_144":61,"_145":61},"count","unfilledCount",5,"emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":149,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_150":151,"_27":152},["D",1785396743201],"children",[],[28],["D",1785395707777],["D",1789455078571],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_125":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":200,"_201":-5,"_202":-7,"_203":-7,"_204":61,"_205":25,"_206":25,"_207":-5,"_208":25,"_209":25,"_210":25,"_211":-5},"ENV",{"_162":163,"_164":165,"_166":88,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6