\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","label",[116],"pulls",1,"forks","envVars",{"_140":142,"_143":52},"connections",{"_140":52,"_141":52},"count","unfilledCount",5,"emptyCount",{"_20":115,"_13":116,"_117":118,"_119":-5,"_120":21,"_121":30,"_122":123,"_22":145,"_29":125,"_126":127,"_128":129,"_130":38,"_131":-5,"_146":147,"_92":148},["D",1785458275699],"children",[],[116],["D",1785395707777],["D",1789455078571],{"_11":12,"_90":86},{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"ctx",{"_71":-5,"_111":187,"_188":189,"_190":191,"_192":38,"_193":38,"_194":38,"_195":123,"_196":-5,"_197":-7,"_198":-7,"_199":52,"_200":38,"_201":38,"_202":-5,"_203":38,"_204":38,"_205":38,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":26,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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"]

Branches1

Branches
1