//------------------------------------------------------
// Sheet1 : 인적사항
//------------------------------------------------------

$students = [];

$sheet1 = $spreadsheet->getSheet(0);

$highestRow1 = $sheet1->getHighestRow();
$highestColumn1 = $sheet1->getHighestColumn();

$header1 = $sheet1->rangeToArray(
    "A10:{$highestColumn1}10",
    null,
    true,
    true,
    false
)[0];

$map1 = [];

foreach ($header1 as $idx => $title) {

    $title = trim((string)$title);

    if ($title != '') {
        $map1[$title] = $idx;
    }
}

for ($row = 11; $row <= $highestRow1; $row++) {

    $data = $sheet1->rangeToArray(
        "A{$row}:{$highestColumn1}{$row}",
        null,
        true,
        true,
        false
    )[0];

    $name = trim((string)($data[$map1['이름']] ?? ''));

    if ($name == '') {
        continue;
    }

    $students[] = [

        'school'        => trim((string)($data[$map1['학교']] ?? '')),
        'name'          => $name,
        'birth'         => trim((string)($data[$map1['생년월일']] ?? '')),
        'grade'         => trim((string)($data[$map1['학년']] ?? '')),
        'address'       => trim((string)($data[$map1['주소']] ?? '')),
        'parent_phone'  => preg_replace('/[^0-9]/', '', (string)($data[$map1['부모전번']] ?? '')),
        'student_phone' => preg_replace('/[^0-9]/', '', (string)($data[$map1['학생전번']] ?? '')),
        'teacher'       => trim((string)($data[$map1['T']] ?? '')),
        'status'        => trim((string)($data[$map1['진행사항']] ?? '')),
        'weekday'       => trim((string)($data[$map1['요일']] ?? '')),
        'class_name'    => trim((string)($data[$map1['반명']] ?? ''))

    ];

}

// ===== 테스트 =====

echo "<pre>";
print_r(array_slice($students, 0, 5));
echo "</pre>";
exit;<?xml version="1.0" encoding="UTF-8"?><rss version="2.0">
	<channel>
		<title>과천 M108스터디 학원</title>
		<link>https://m108study.co.kr</link>
		<description>수능, 내신, 과제연구 학생별 맞춤 지도</description>
		
				<item>
			<title><![CDATA[[고1] 이은찬 숙제]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1042]]></link>
			<description><![CDATA[<p>40번부터 100번까지 입니다.</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Thu, 12 Feb 2026 16:26:14 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[2026년 고3-O반] 학습노트]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1041]]></link>
			<description><![CDATA[<h2><a href="https://share.goodnotes.com/s/u4ttYLdC7UPJBueYiqHt9m">김민준 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/83KAx7uy11ysllXnAFir5n">김준현 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/2EyKeovN0k93MQshEJwDng">박민석 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/JwHEGUip4fdFq4tm9A1haj">안기주 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/vZXhMhZgo1sTWWKymt6K7H">엄현서 학습노트</a><br /><br /></h2>
<h2><a href="https://share.goodnotes.com/s/u49U2fjkI3ktqvFuSpGOPt">이은준 학습노트</a><br /><br /></h2>
<h2><a href="https://share.goodnotes.com/s/WizCXhmtRZfh6UHSaw1uV1">정현준 학습노트</a><br /><br /></h2>
<h2> </h2>
<h2> </h2>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 21 Jan 2026 17:26:47 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[2026년 고1-O반] 학습노트]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1040]]></link>
			<description><![CDATA[<h2><a href="https://share.goodnotes.com/s/TgHmlV4hlhD98jlBgWOzCF">강수아 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/Isd6FV0v2M50TmqezcGxC5">김하람 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/MaZRzzTqmQ9kjHJ6XJtmp4">김재원 학습노트</a></h2>
<p> </p>
<h2><a href="https://share.goodnotes.com/s/3zqwibufHRJdP7n6eqWHVx">윤건우 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/kdpNhFF0U2QKWvFoeQ5ve2">윤준기 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/sfMbZsj0byMZhn9OQRBgIL">유재훈 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/vvIGlBaZuDRgmLAvuWakNB">이수민 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/cONuiBRpDOiobfcMO2F7cX">이은찬 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/9uQ1gP4wLWXBhmS8ApuPj2">주동연 학습노트</a><br /><br /></h2>
<h2><a href="https://share.goodnotes.com/s/sB5e2bmNntKqYwruy8obld">차서우 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/W91orkPzIlB6kBlrKSkKTi">허린 학습노트</a></h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2> </h2>
<h2><br /><br /></h2>
<h2> </h2>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 21 Jan 2026 17:26:29 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[2026년 중3-O반] 학습노트]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1039]]></link>
			<description><![CDATA[<h2><a href="https://share.goodnotes.com/s/nA1y8xDeHxTULK0kHQKpK8">박연후 학습노트</a><br /><br /></h2>
<h2><a href="https://share.goodnotes.com/s/epAaOV1Hnbrss6Pv771kcP">오하림 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://share.goodnotes.com/s/CpXDdHZ2iWhGH7DqvxLmBG">최지원 학습노트</a></h2>
<p> </p>
<p> </p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 21 Jan 2026 17:20:01 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[2026년 고2-O반] 학습노트]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1038]]></link>
			<description><![CDATA[<h2><a href="https://web.goodnotes.com/s/FmdtuIh03AJfXH5mCUH7YG">김도훈 학습노트</a></h2>
<h2> </h2>
<h2><a href="https://web.goodnotes.com/s/DpSY2s885bf7yW6YuSa7md">성영수 학습노트</a></h2>
<p> </p>
<h2><a href="https://share.goodnotes.com/s/w1VGgrTKKrsqt2PFkcvWUL">이산호 학습노트</a></h2>
<p> </p>
<h2><a href="https://share.goodnotes.com/s/NI3j9kX4fW5B8hnYNsLyAb">양예은 학습노트</a></h2>
<p> </p>
<p> </p>
<p> </p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 21 Jan 2026 11:56:19 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[예비고1] 주동연 숙제 20260120]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1037]]></link>
			<description><![CDATA[<p>[pdf id='2719']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Tue, 20 Jan 2026 17:12:41 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[예비고1] 주동연 20260119 숙제]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1036]]></link>
			<description><![CDATA[<p>[pdf id='2716']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Mon, 19 Jan 2026 16:15:07 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[원생 게시판] 과 [원생자료실]의 사용은 학원으로 문의 바랍니다.]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1035]]></link>
			<description><![CDATA[<h2>원생인 경우에 학생에게 사용법을 <strong><em>문자</em></strong>로 보내드립니다. </h2>]]></description>
			<author><![CDATA[M108RND]]></author>
			<pubDate>Tue, 13 Jan 2026 17:15:03 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=7"><![CDATA[공지사항]]></category>
		</item>
				<item>
			<title><![CDATA[[게시글]을 올릴 때는 학년과 이름을 꼭 적어야합니다.]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1034]]></link>
			<description><![CDATA[]]></description>
			<author><![CDATA[M108RND]]></author>
			<pubDate>Tue, 13 Jan 2026 17:12:08 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[학년과 이름이 없는 경우에는 알림 없이 그냥 삭제합니다.]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1033]]></link>
			<description><![CDATA[]]></description>
			<author><![CDATA[M108RND]]></author>
			<pubDate>Tue, 13 Jan 2026 17:10:32 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중3] 윤건우 TEST 25년 12월 30일]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1030]]></link>
			<description><![CDATA[<p>[pdf id='2698']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Tue, 30 Dec 2025 16:20:28 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중3] 차서우 테스트]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1027]]></link>
			<description><![CDATA[<p>[pdf id='2684']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Mon, 15 Dec 2025 22:40:05 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중2] 중3 선행 숙제 전체 - 빠른정답]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1026]]></link>
			<description><![CDATA[<p>[pdf id='2676']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:32:27 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중2] 고등 선행 숙제 전체 - 빠른정답]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1025]]></link>
			<description><![CDATA[<p>[pdf id='2673']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:31:24 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중3] 고등 선행 숙제 전체 - 빠른정답]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1024]]></link>
			<description><![CDATA[<p>[pdf id='2670']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:30:01 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중2] 중3 선행 숙제 2차]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1023]]></link>
			<description><![CDATA[<p>[pdf id='2667']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:25:30 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중2] 중3 선행 숙제 1차]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1022]]></link>
			<description><![CDATA[<p>[pdf id='2664']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:24:27 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중2] 고등 선행 2차 숙제]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1021]]></link>
			<description><![CDATA[<p>[pdf id='2661']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:19:24 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중2] 고등 선행 1차 숙제]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1020]]></link>
			<description><![CDATA[<p>[pdf id='2658']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:18:38 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
				<item>
			<title><![CDATA[[중3]  고등 선행 숙제 4차]]></title>
			<link><![CDATA[https://m108study.co.kr/?kboard_content_redirect=1019]]></link>
			<description><![CDATA[<p>[pdf id='2655']</p>]]></description>
			<author><![CDATA[M108연구실]]></author>
			<pubDate>Wed, 01 Oct 2025 12:15:16 +0000</pubDate>
			<category domain="https://m108study.co.kr/?kboard_redirect=26"><![CDATA[학원생 통합게시판]]></category>
		</item>
			</channel>
</rss>