[{"_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",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_119":-5,"_20":120,"_22":121,"_122":123,"_124":125,"_25":126,"_24":-5,"_127":-5,"_128":-5,"_129":53,"_130":131,"_132":53,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","jinhakproscrap","name","apply-scraper","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","d069f8f0-25d2-431c-97c3-40ef2048438e","main.ts","fileId","650c11c2-8be6-11f1-9363-1607ee4eb77e","parentId","branchId","ab40a1c6-cfd2-496a-a9c2-34e63f89a917","branchVersion",12,"latest",true,"createdAt",["D",1785458275699],9,"fileType","interval","content","// Val Town cron val — 진학프로 즉시지원 공고 스크래퍼\n// 15분마다 실행되어 신규 즉시지원 공고를 아래 4개 시트에 기록합니다.\n// 1) 즉시지원 리스트 : 공고ID, 기관명, 공고명, 공고 링크, 이메일 발송여부(미발송)\n// 2) 광고배너 등록 : 공고ID, 제목, 내용, 로고 이미지 파일, 배경색, 링크, 배너운영기간\n// 3) 오카방 메시지 : 공고ID, [기관명]공고명, 링크\n// 4) 소셜발행 : idx, org_name, recr_title, major_1~8, major_etc_txt, degree, apply_end, region, dday, facebookLink\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// GMAIL_USER - 발신 Gmail 주소 (예: jinhakapplyhelp@gmail.com)\n// GMAIL_APP_PASSWORD - Gmail 앱 비밀번호 (16자리)\n// EMAIL_RECIPIENTS - (선택) 신규 공고 알림 수신자 이메일, 콤마로 구분. 미설정 시 기본 수신자 사용\n// D3_EMAIL_RECIPIENTS - (선택) D-3 마감 알림 수신자 이메일, 콤마로 구분. 미설정 시 cgh@jinhakapply.com\n\nimport nodemailer from \"npm:nodemailer@6.9.14\";\n\nconst JINHAKPRO_LIST_API =\n \"https://www.jinhakpro.com/api/applicant/recruit/sub-list?isOnlyOnlineApply=true&bookmarkSortType=1&majorCategoryCode=&recruitTypeCode=&sortType=1\";\nconst JINHAKPRO_DETAIL_API = (recruitIdx: number | string) =>\n `https://www.jinhakpro.com/api/applicant/recruit/recruit-detail/${recruitIdx}`;\n\nconst SHEET_LIST = \"즉시지원 리스트\";\nconst SHEET_AD = \"광고배너 등록\";\nconst SHEET_CHAT = \"오카방 메시지\";\nconst SHEET_SOCIAL = \"소셜발행\";\nconst SHEET_COLOR_DB = \"배너 배경색 DB\";\nconst SHEET_CONTRACT = \"광고배너 계약 여부\";\n\nconst DEFAULT_EMAIL_RECIPIENTS =\n \"cgh@jinhakapply.com, magi77@jinhakapply.com, yjkim1014@jinhakapply.com, psj@jinhakapply.com\";\nconst DEFAULT_D3_RECIPIENTS = \"cgh@jinhakapply.com\";\n\nconst SHEETS_SCOPE = \"https://www.googleapis.com/auth/spreadsheets\";\n\nconst EDU_LEVEL_MAP: Record = {\n H: \"고졸\",\n J: \"전문학사\",\n B: \"학사\",\n M: \"석사\",\n D: \"박사\",\n};\n\nconst SOCIAL_HEADERS = [\n \"idx\",\n \"org_name\",\n \"recr_title\",\n \"major_1\",\n \"major_2\",\n \"major_3\",\n \"major_4\",\n \"major_5\",\n \"major_6\",\n \"major_7\",\n \"major_8\",\n \"major_etc_txt\",\n \"degree\",\n \"apply_end\",\n \"region\",\n \"dday\",\n \"facebookLink\",\n];\n\nconst UA =\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\ninterface RecruitListItem {\n recruitIdx: number;\n organName: string;\n recruitTitle: string;\n}\n\n/* ========== base64url / RSA JWT ========== */\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 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\n/* ========== 진학프로 API ========== */\n\nasync function fetchImmediateApplyList(): Promise {\n const res = await fetch(JINHAKPRO_LIST_API, {\n headers: { \"User-Agent\": UA },\n });\n if (!res.ok) throw new Error(`진학프로 목록 API 호출 실패: ${res.status}`);\n return await res.json();\n}\n\nasync function fetchRecruitDetail(recruitIdx: number | string): Promise {\n const res = await fetch(JINHAKPRO_DETAIL_API(recruitIdx), {\n headers: { \"User-Agent\": UA },\n });\n if (!res.ok) {\n throw new Error(\n `진학프로 상세 API 호출 실패 (${recruitIdx}): ${res.status}`,\n );\n }\n return await res.json();\n}\n\n/* ========== 구글 시트 헬퍼 ========== */\n\nasync function getSheetValues(\n sheetId: string,\n accessToken: string,\n range: string,\n): Promise {\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${\n encodeURIComponent(range)\n }`,\n { headers: { Authorization: `Bearer ${accessToken}` } },\n );\n if (!res.ok) {\n throw new Error(\n `시트 조회 실패 (${range}): ${res.status} ${await res.text()}`,\n );\n }\n const data = await res.json();\n return data.values ?? [];\n}\n\nasync function appendToSheet(\n sheetId: string,\n accessToken: string,\n sheetName: string,\n rows: (string | number)[][],\n) {\n if (rows.length === 0) return;\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${\n encodeURIComponent(sheetName)\n }: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(\n `시트 추가 실패 (${sheetName}): ${res.status} ${await res.text()}`,\n );\n }\n}\n\nasync function updateSheetRange(\n sheetId: string,\n accessToken: string,\n range: string,\n rows: (string | number)[][],\n) {\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${\n encodeURIComponent(range)\n }?valueInputOption=USER_ENTERED`,\n {\n method: \"PUT\",\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(\n `시트 갱신 실패 (${range}): ${res.status} ${await res.text()}`,\n );\n }\n}\n\nasync function ensureSocialHeaders(sheetId: string, accessToken: string) {\n const existing = await getSheetValues(\n sheetId,\n accessToken,\n `${SHEET_SOCIAL}!A1:Q1`,\n );\n if (existing.length > 0 && existing[0].some((v) => String(v).trim())) return;\n await updateSheetRange(sheetId, accessToken, `${SHEET_SOCIAL}!A1:Q1`, [\n SOCIAL_HEADERS,\n ]);\n}\n\n/* ========== 가공 헬퍼 (기존 crawl.gs 로직 포팅) ========== */\n\nfunction stripOrgFromTitle(title: string, org: string): string {\n const t = String(title || \"\").trim();\n if (!org) return t;\n const escaped = org.replace(/[.*+?^${}()|[\\]\\\\]/g, \"\\\\$&\");\n let out = t;\n out = out.replace(\n new RegExp(`^\\\\s*\\\\[\\\\s*${escaped}\\\\s*\\\\]\\\\s*[-–—·:]*\\\\s*`, \"i\"),\n \"\",\n );\n out = out.replace(new RegExp(`^\\\\s*${escaped}\\\\s*[-–—·:]*\\\\s*`, \"i\"), \"\");\n out = out.replace(new RegExp(`\\\\s+${escaped}\\\\s+`, \"ig\"), \" \");\n return out.replace(/\\s{2,}/g, \" \").trim();\n}\n\nfunction toDotDate(iso: string): string {\n const m = String(iso).match(/(\\d{4})-(\\d{2})-(\\d{2})/);\n return m ? `${m[1]}.${m[2]}.${m[3]}` : String(iso);\n}\n\nfunction toDotDateDisplay(iso: string): string {\n const m = String(iso).match(/(\\d{4})-(\\d{2})-(\\d{2})/);\n return m ? `${m[1]}. ${m[2]}. ${m[3]}` : String(iso);\n}\n\nfunction buildDdayText(applyEndISO: string): string {\n if (!applyEndISO) return \"\";\n const today = new Date();\n today.setHours(0, 0, 0, 0);\n const deadline = new Date(applyEndISO);\n deadline.setHours(0, 0, 0, 0);\n const diff = Math.round((deadline.getTime() - today.getTime()) / 86400000);\n return diff > 0 ? `마감 D-${diff}` : diff === 0 ? \"마감일 D-day\" : \"마감\";\n}\n\n/* ========== 이메일 발송 (기존 email.gs / email_template.html 포팅) ========== */\n\nconst EMAIL_TEMPLATE_HTML = `\n\n\n

\n\n \n

🔔 신규 즉시지원 공고 알림

새로운 즉시지원 공고가 등록되었습니다. 야호~

\n\n

\n\n \n

공고 정보

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

기관명
공고명
공고ID
링크

\n\n \n

1. 오픈카톡방 메시지

※ 방금 뜬 따끈한 즉시지원 공고 배달드립니다 ※ 오직 진학프로에서만 지원 가능!

\n\n \n

2. 광고 배너 등록

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

제목
내용
로고 이미지
배경색
이동 링크
배너 운영 기간

\n\n \n

\n 3. 소셜 발행\n [META 바로가기]\n

1분 전에 뜬 따끈한 즉시지원 공고 배달드립니다♨️ 오직 진학프로에서만 지원 가능!

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

모집전공
지원자격
접수마감	\n \n \n
근무지역

\n\n \n \n \n \n \n

소셜발행 공고ID

\n\n

진학프로(@jinhakpro) 팔로우하고 석사·박사를 위한 고급 채용 정보를 받아 보세요.

\n\n \n \n \n \n \n \n

캐치 공고등록도 잊지 마세요 ^^

\n\n

\n\n\n`;\n\ninterface EmailData {\n 공고ID: string;\n 기관명: string;\n 공고명: string;\n 공고링크: string;\n bannerContract: string;\n 오카방제목: string;\n 오카방링크: string;\n 광고제목: string;\n 광고내용: string;\n 로고이미지파일: string;\n 광고배경색: string;\n 광고링크: string;\n 배너운영기간: string;\n 소셜기관명: string;\n 소셜공고명: string;\n facebookLink: string;\n majorsText: string;\n degree: string;\n applyEnd: string;\n region: string;\n dday: string;\n 소셜공고ID: string;\n}\n\nfunction buildEmailHtml(d: EmailData): string {\n let html = EMAIL_TEMPLATE_HTML;\n\n html = html\n .replace(\n /]*data-type=\"즉시지원 리스트_기관명\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.기관명}`,\n )\n .replace(\n /]*data-type=\"즉시지원 리스트_공고명\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.공고명}`,\n )\n .replace(\n /]*data-type=\"즉시지원 리스트_공고ID\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.공고ID}`,\n )\n .replace(\n /]*data-type=\"즉시지원 리스트_링크\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.공고링크}`,\n );\n\n html = html.replace(\n /]*data-type=\"광고배너_계약여부\"[^>]*>[\\s\\S]*?<\\/p>/,\n `

${d.bannerContract}

`,\n );\n\n html = html\n .replace(\n /]*data-type=\"오카방 메시지_\\[기관명\\]공고명\"[^>]*>[\\s\\S]*?<\\/p>/,\n `

${d.오카방제목 || `[${d.기관명}] ${d.공고명}`}

`,\n )\n .replace(\n /]*data-type=\"오카방 메시지_링크\"[^>]*>[\\s\\S]*?<\\/p>/,\n `

${\n d.오카방링크 || d.공고링크\n }

`,\n );\n\n html = html\n .replace(\n /]*data-type=\"광고배너 등록_제목\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.광고제목 || \"\"}`,\n )\n .replace(\n /]*data-type=\"광고배너 등록_내용\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.광고내용 || \"\"}`,\n )\n .replace(\n /]*data-type=\"광고배너 등록_로고이미지파일\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${\n d.로고이미지파일 || \"\"\n }`,\n )\n .replace(\n /]*data-type=\"광고배너 등록_배경색\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.광고배경색 || \"\"}`,\n )\n .replace(\n /]*data-type=\"광고배너 등록_이동 링크\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${\n d.광고링크 || d.공고링크\n }`,\n )\n .replace(\n /]*data-type=\"광고배너 등록_배너운영기간\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.배너운영기간 || \"\"}`,\n );\n\n html = html\n .replace(\n /]*data-type=\"소셜발행_기관명_공고명\"[^>]*>[\\s\\S]*?<\\/p>/,\n `

[${d.소셜기관명}] ${d.소셜공고명}

`,\n )\n .replace(\n /]*data-type=\"소셜발행_facebook링크\"[^>]*>[\\s\\S]*?<\\/p>/,\n `

${d.facebookLink}

`,\n )\n .replace(\n /<(td|span)[^>]*data-type=\"소셜발행_모집전공\"[^>]*>[\\s\\S]*?<\\/\\1>/,\n `<$1>${d.majorsText || \"\"}`,\n )\n .replace(\n /<(td|span)[^>]*data-type=\"소셜발행_학력\"[^>]*>[\\s\\S]*?<\\/\\1>/,\n `<$1>${d.degree || \"\"}`,\n )\n .replace(\n /<(td|span)[^>]*data-type=\"소셜발행_지역\"[^>]*>[\\s\\S]*?<\\/\\1>/,\n `<$1>${d.region || \"\"}`,\n )\n .replace(\n /<(td|span)[^>]*data-type=\"소셜발행_접수마감일\"[^>]*>[\\s\\S]*?<\\/\\1>/,\n `<$1>${d.applyEnd || \"\"}`,\n )\n .replace(\n /<(td|span)[^>]*data-type=\"소셜발행_DDAY\"[^>]*>[\\s\\S]*?<\\/\\1>/,\n `<$1>${d.dday || \"\"}`,\n );\n\n html = html.replace(\n /]*data-type=\"소셜발행_공고ID\"[^>]*>[\\s\\S]*?<\\/td>/,\n `${d.소셜공고ID}`,\n );\n\n return html;\n}\n\nasync function sendEmail(\n gmailUser: string,\n gmailAppPassword: string,\n to: string,\n subject: string,\n html: string,\n) {\n const transporter = nodemailer.createTransport({\n service: \"gmail\",\n auth: { user: gmailUser, pass: gmailAppPassword },\n });\n await transporter.sendMail({ from: gmailUser, to, subject, html });\n}\n\nasync function checkAndSendEmails(sheetId: string, accessToken: string) {\n const gmailUser = Deno.env.get(\"GMAIL_USER\");\n const gmailAppPassword = Deno.env.get(\"GMAIL_APP_PASSWORD\");\n if (!gmailUser || !gmailAppPassword) {\n console.log(\n \"GMAIL_USER / GMAIL_APP_PASSWORD 미설정 — 이메일 발송 단계를 건너뜁니다.\",\n );\n return;\n }\n const recipients = Deno.env.get(\"EMAIL_RECIPIENTS\") ||\n DEFAULT_EMAIL_RECIPIENTS;\n\n const [listRows, adRows, chatRows, socialRows, contractRows] = await Promise\n .all([\n getSheetValues(sheetId, accessToken, `${SHEET_LIST}!A2:G`),\n getSheetValues(sheetId, accessToken, `${SHEET_AD}!A2:G`),\n getSheetValues(sheetId, accessToken, `${SHEET_CHAT}!A2:C`),\n getSheetValues(sheetId, accessToken, `${SHEET_SOCIAL}!A2:Q`),\n getSheetValues(sheetId, accessToken, `${SHEET_CONTRACT}!A2:B`),\n ]);\n\n const byId = (rows: string[][]) => {\n const map = new Map();\n for (const row of rows) if (row[0]) map.set(String(row[0]).trim(), row);\n return map;\n };\n const adMap = byId(adRows);\n const chatMap = byId(chatRows);\n const socialMap = byId(socialRows);\n\n const contractMap = new Map();\n for (const row of contractRows) {\n if (row[0]) contractMap.set(String(row[0]).trim(), String(row[1] ?? \"\"));\n }\n\n let sentCount = 0;\n\n for (let i = 0; i < listRows.length; i++) {\n const row = listRows[i];\n const 공고ID = String(row[0] || \"\").trim();\n if (!공고ID) continue;\n const status = String(row[4] || \"\").trim();\n if (status !== \"미발송\") continue;\n\n const 기관명 = String(row[1] || \"\").trim();\n const 공고명 = String(row[2] || \"\").trim();\n const 공고링크 = String(row[3] || \"\").trim();\n if (!기관명 || !공고명 || !공고링크) {\n console.warn(`필수값 부족으로 발송 보류: 공고ID=${공고ID}`);\n continue;\n }\n\n const rowNumber = i + 2; // A2부터 시작\n\n try {\n const contractYn = (contractMap.get(기관명) || \"\").trim();\n const bannerContract = contractYn === \"Y\" ? \"배너 등록O\" : \"배너 등록X\";\n\n const ad = adMap.get(공고ID) || [];\n const [\n ,\n 광고제목,\n 광고내용,\n 로고이미지파일,\n 광고배경색,\n 광고링크,\n 배너운영기간,\n ] = ad;\n\n const chat = chatMap.get(공고ID) || [];\n const [, 오카방제목, 오카방링크] = chat;\n\n const social = socialMap.get(공고ID) || [];\n const 소셜기관명 = social[1] || \"\";\n const 소셜공고명 = social[2] || \"\";\n const majorsArr = social.slice(3, 11).map((v) => String(v || \"\").trim())\n .filter(Boolean);\n const majorEtc = String(social[11] || \"\").trim();\n const degree = String(social[12] || \"\").trim();\n const applyEnd = String(social[13] || \"\").trim();\n const region = String(social[14] || \"\").trim();\n const dday = String(social[15] || \"\").trim();\n const facebookLink = String(social[16] || \"\").trim();\n const majorsText = [...majorsArr, majorEtc].filter(Boolean).join(\", \");\n\n const html = buildEmailHtml({\n 공고ID,\n 기관명,\n 공고명,\n 공고링크,\n bannerContract,\n 오카방제목: 오카방제목 || \"\",\n 오카방링크: 오카방링크 || \"\",\n 광고제목: 광고제목 || \"\",\n 광고내용: 광고내용 || \"\",\n 로고이미지파일: 로고이미지파일 || \"\",\n 광고배경색: 광고배경색 || \"\",\n 광고링크: 광고링크 || \"\",\n 배너운영기간: 배너운영기간 || \"\",\n 소셜기관명,\n 소셜공고명,\n facebookLink,\n majorsText,\n degree,\n applyEnd,\n region,\n dday,\n 소셜공고ID: social[0] || 공고ID,\n });\n\n await sendEmail(\n gmailUser,\n gmailAppPassword,\n recipients,\n `[즉시지원 알림] ${기관명} ${공고명}`,\n html,\n );\n\n await updateSheetRange(\n sheetId,\n accessToken,\n `${SHEET_LIST}!E${rowNumber}`,\n [[\"발송완료\"]],\n );\n sentCount++;\n } catch (err) {\n console.error(\n `이메일 발송 실패 (공고ID: ${공고ID}):`,\n err instanceof Error ? err.message : err,\n );\n }\n }\n\n console.log(`이메일 발송 완료: ${sentCount}건`);\n}\n\n/* ========== D-3 마감 알림 (기존 \"D-3 email.gs\" 포팅) ========== */\n\ninterface D3Target {\n id: string;\n org: string;\n title: string;\n link: string;\n rowNumber: number;\n}\n\nfunction buildD3Html(targets: D3Target[]): string {\n let html = `\n

📢 즉시지원 마감 D-3 알림

스펙통계 소셜발행할 타이밍~

\n `;\n\n for (const item of targets) {\n html += `\n

\n 📌 공고 정보\n

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

기관명	${item.org}
공고명	${item.title}
링크	\n \n ${item.link}\n \n
MOA 통계 다운로드	바로가기
구글시트	바로가기

\n\n

\n `;\n }\n\n html += `

`;\n return html;\n}\n\nasync function sendD3Reminders(sheetId: string, accessToken: string) {\n const gmailUser = Deno.env.get(\"GMAIL_USER\");\n const gmailAppPassword = Deno.env.get(\"GMAIL_APP_PASSWORD\");\n if (!gmailUser || !gmailAppPassword) {\n console.log(\n \"GMAIL_USER / GMAIL_APP_PASSWORD 미설정 — D-3 알림 단계를 건너뜁니다.\",\n );\n return;\n }\n const recipient = Deno.env.get(\"D3_EMAIL_RECIPIENTS\") ||\n DEFAULT_D3_RECIPIENTS;\n\n const rows = await getSheetValues(sheetId, accessToken, `${SHEET_LIST}!A2:G`);\n\n const today = new Date();\n today.setHours(0, 0, 0, 0);\n\n const targets: D3Target[] = [];\n\n rows.forEach((row, index) => {\n const [id, org, title, link, , deadlineStr, status] = row;\n\n if (!deadlineStr || !status) return;\n if (String(status).trim() !== \"미발송\") return;\n\n const deadline = new Date(String(deadlineStr));\n if (Number.isNaN(deadline.getTime())) return;\n deadline.setHours(0, 0, 0, 0);\n\n const sendDate = new Date(deadline);\n sendDate.setDate(sendDate.getDate() - 3);\n sendDate.setHours(0, 0, 0, 0);\n while (sendDate.getDay() === 0 || sendDate.getDay() === 6) {\n sendDate.setDate(sendDate.getDate() - 1);\n }\n\n if (sendDate.getTime() === today.getTime()) {\n targets.push({\n id: String(id || \"\"),\n org: String(org || \"\"),\n title: String(title || \"\"),\n link: String(link || \"\"),\n rowNumber: index + 2,\n });\n }\n });\n\n if (targets.length === 0) {\n console.log(\"D-3 대상 없음\");\n return;\n }\n\n const html = buildD3Html(targets);\n await sendEmail(\n gmailUser,\n gmailAppPassword,\n recipient,\n \"즉시지원 마감 D-3 자동 알림\",\n html,\n );\n\n for (const t of targets) {\n await updateSheetRange(\n sheetId,\n accessToken,\n `${SHEET_LIST}!G${t.rowNumber}`,\n [[\"발송완료\"]],\n );\n }\n\n console.log(`D-3 이메일 발송 완료: ${targets.length}건`);\n}\n\n/* ========== 메인 ========== */\n\nasync function main() {\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 if (!clientEmail || !privateKey || !sheetId) {\n throw new Error(\n \"환경변수 GOOGLE_SERVICE_ACCOUNT_EMAIL / GOOGLE_PRIVATE_KEY / GOOGLE_SHEET_ID 를 설정해주세요.\",\n );\n }\n\n const accessToken = await getAccessToken(clientEmail, privateKey);\n\n const [items, existingIdRows, colorDbRows] = await Promise.all([\n fetchImmediateApplyList(),\n getSheetValues(sheetId, accessToken, `${SHEET_LIST}!A2:A`),\n getSheetValues(sheetId, accessToken, `${SHEET_COLOR_DB}!A2:B`),\n ]);\n\n const existingIds = new Set(\n existingIdRows.map((r) => String(r[0]).trim()).filter(Boolean),\n );\n const colorMap = new Map();\n for (const row of colorDbRows) {\n if (row[0]) {\n colorMap.set(String(row[0]).trim(), String(row[1] ?? \"#000000\"));\n }\n }\n\n await ensureSocialHeaders(sheetId, accessToken);\n\n const newItems = items.filter((item) =>\n !existingIds.has(String(item.recruitIdx))\n );\n\n let successCount = 0;\n\n for (const item of newItems) {\n const recruitIdx = String(item.recruitIdx);\n const 공고링크 = `https://www.jinhakpro.com/recruit/${recruitIdx}`;\n\n let detail: any = null;\n let applyEndISO = \"\";\n try {\n detail = await fetchRecruitDetail(recruitIdx);\n applyEndISO = String(\n detail?.recruitDetail?.recruitData?.apply_end_date || \"\",\n ).trim();\n } catch (err) {\n console.error(\n `상세 조회 실패 (공고ID: ${recruitIdx}):`,\n err instanceof Error ? err.message : err,\n );\n }\n\n // 1) 즉시지원 리스트 (상세 API 실패해도 최소한 이 행은 남긴다)\n await appendToSheet(sheetId, accessToken, SHEET_LIST, [\n [\n recruitIdx,\n item.organName,\n item.recruitTitle,\n 공고링크,\n \"미발송\",\n applyEndISO,\n \"미발송\",\n ],\n ]);\n\n if (!detail?.recruitDetail) continue;\n\n try {\n const rd = detail.recruitDetail;\n\n const rData = rd.recruitData || {};\n const wc = rData.work_condition || {};\n\n const 기관명 = String(rd.organName || \"\").trim();\n const 원본공고명 = String(rd.recruitTitle || \"\").trim();\n const 정제공고명 = stripOrgFromTitle(원본공고명, 기관명);\n\n const majorList = rData.major_data?.major_list || [];\n const majorIrrelevant = rData.major_data?.major_irrelevant;\n const majors: string[] = majorIrrelevant\n ? [\"전공 무관\"]\n : majorList.map((m: any) => String(m.major_name || \"\").trim()).filter(\n Boolean,\n );\n const majorFields = Array.from({ length: 8 }, (_, i) => majors[i] || \"\");\n const majorEtc = majors.length > 8 ? `외 ${majors.length - 8}개` : \"\";\n\n const eduLabel = EDU_LEVEL_MAP[wc.highest_education_level_code] || \"\";\n const degree = eduLabel\n ? wc.is_prospective_graduate\n ? `${eduLabel} 이상, 예비졸업자 가능`\n : `${eduLabel} 이상`\n : \"\";\n\n const applyStartISO = String(rData.apply_start_date || \"\").trim();\n const 배너운영기간Text = applyStartISO && applyEndISO\n ? `${toDotDate(applyStartISO)} ~ ${toDotDate(applyEndISO)}`\n : \"\";\n\n const ddayText = buildDdayText(applyEndISO);\n\n const region = [\n ...new Set(\n (rd.regionData || []).map((r: any) => String(r.region || \"\").trim())\n .filter(Boolean),\n ),\n ].join(\", \");\n\n const 로고URL = rd.logoFileName\n ? `https://image.jinhakapply.com/trecruit/logo/${rd.logoFileName}${\n rd.logoFileExt || \"\"\n }`\n : \"\";\n\n const 배경색 = colorMap.get(기관명) || \"#000000\";\n const utm링크 =\n `${공고링크}?utm_source=kakaotalk&utm_medium=referral&utm_campaign=openchat&utm_content=ojp`;\n const fb링크 =\n `${공고링크}?utm_source=facebook&utm_medium=referral&utm_campaign=facebook&utm_content=ojp`;\n\n // 2) 광고배너 등록\n await appendToSheet(sheetId, accessToken, SHEET_AD, [\n [\n recruitIdx,\n 정제공고명,\n 배너운영기간Text,\n 로고URL,\n 배경색,\n 공고링크,\n 배너운영기간Text,\n ],\n ]);\n\n // 3) 오카방 메시지\n await appendToSheet(sheetId, accessToken, SHEET_CHAT, [\n [recruitIdx, `[${기관명}] ${정제공고명}`, utm링크],\n ]);\n\n // 4) 소셜발행\n await appendToSheet(sheetId, accessToken, SHEET_SOCIAL, [\n [\n recruitIdx,\n 기관명,\n 정제공고명,\n ...majorFields,\n majorEtc,\n degree,\n toDotDateDisplay(applyEndISO),\n region,\n ddayText,\n fb링크,\n ],\n ]);\n\n successCount++;\n } catch (err) {\n console.error(\n `상세 처리 실패 (공고ID: ${recruitIdx}):`,\n err instanceof Error ? err.message : err,\n );\n }\n }\n\n console.log(\n `조회 ${items.length}건 중 신규 ${newItems.length}건, 상세 처리 성공 ${successCount}건 (${\n new Date().toISOString()\n })`,\n );\n\n await checkAndSendEmails(sheetId, accessToken);\n await sendD3Reminders(sheetId, accessToken);\n}\n\nexport default main;","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1785458275699],"children",[],[35],"5461a472-3eb0-4aec-9078-69e2095e712b",["D",1785395707777],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","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",{"_11":12,"_118":114},"org",{"_11":12,"_111":112,"_113":114,"_70":71,"_115":116,"_117":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","JINHAKPRO진학프로","avatar","https://lh3.googleusercontent.com/a/ACg8ocJJHCLJdaXxt4Zt5JwFN3dPSn7GeRRiyCk-G3WKEyDe3VfWFiI=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":153,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":154,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":155,"_98":156,"_100":157,"_102":53},[150],"files",[150],"counts",{"_139":77,"_140":141,"_142":77,"_31":143,"_144":145},[137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":138},[35],"pulls","branches",1,"forks",{"_146":148,"_149":77},"connections",{"_146":77,"_147":77},"count","unfilledCount",5,"emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":151,"_18":152},[],[35],["D",1785395707777],["D",1789455078571],{"_11":12,"_118":114},{"_11":12,"_111":112,"_113":114,"_70":71,"_115":116,"_117":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_134":191,"_192":193,"_194":195,"_196":53,"_197":53,"_198":53,"_199":44,"_200":-5,"_201":-7,"_202":-7,"_203":77,"_204":53,"_205":53,"_206":-5,"_207":53,"_208":53,"_209":53,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":16,"_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","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]