public function excel()
{
if (($_SESSION["s"]["per"] & $this->settings->permission1) != $this->settings->permission1) {
header("Location: /");
}
$this->layout = "";
$res = $this->Members->list_(1, 100000);
$len_res = sizeof($res);
header("Content-type: application/octet-stream; charset=euc-kr");
header("Content-Disposition: attachment; filename=memberList.xls");
header("Content-Description: PHP4 Generated Data");
print "<Meta Http-Equiv=\"Content-Type\" Content=\"Application/Vnd.Ms-Excel; Charset=UTF-8\">";
echo "\n <table>\n <tr>\n <td>id</td>\n <td>회원등급</td>\n <td>아이디</td>\n <td>이름</td>\n <td>이메일</td>\n <td>전화번호</td>\n <td>메일수신여부</td>\n <td>SMS수신여부</td>\n <td>상태(0:승인대기,1:승인,2:탈퇴)</td>\n <td>생성일</td>\n <td>관심지역</td>\n <td>업무분야</td>\n <td>업무역량</td>\n </tr>\n ";
for ($i = 0; $i < $len_res; $i++) {
if ($res[$i]["email_rec"]) {
$res[$i]["email_r"] = "Y";
} else {
$res[$i]["email_r"] = "N";
}
if ($res[$i]["sms_rec"]) {
$res[$i]["sms_r"] = "Y";
} else {
$res[$i]["sms_r"] = "N";
}
$res_lo = $this->Member_local->get_by_member_c($res[$i]["id"]);
$res_sk = $this->Member_skill->get_by_member_c($res[$i]["id"]);
$res_in = $this->Member_interist->get_by_member_c($res[$i]["id"]);
echo "<tr><td>" . $res[$i]["id"] . "</td><td>" . $res[$i]["gname"] . "</td><td>" . $res[$i]["ids"] . "</td><td>" . $res[$i]["name"] . "</td><td>" . $res[$i]["email"] . "</td><td>" . $res[$i]["tel"] . "</td><td>" . $res[$i]["email_r"] . "</td><td>" . $res[$i]["sms_r"] . "</td><td>" . $res[$i]["state"] . "</td><td>" . $res[$i]["date_created"] . "</td><td>" . get_value_in_arr($res_lo, "_value") . "</td><td>" . get_value_in_arr($res_in, "_value") . "</td><td>" . get_value_in_arr($res_sk, "_value") . "</td></tr>";
// echo "<tr><td>".$res[$i]["id"]."</td><td>".$res[$i]["gname"]."</td><td>".$res[$i]["ids"]."</td><td>".$res[$i]["name"]."</td><td>".$res[$i]["email"]."</td><td>".$res[$i]["tel"]."</td><td>".$res[$i]["email_r"]."</td><td>".$res[$i]["sms_r"]."</td><td>".$res[$i]["state"]."</td><td>".$res[$i]["date_created"]."</td></tr>";
}
echo "\n </table>\n ";
exit(1);
}
public function excel()
{
$this->layout = "";
$res = $this->Startup->list_(1, 10000000);
$len_res = sizeof($res);
header("Content-type: application/vnd.ms-excel; charset=euc-kr");
header("Content-Disposition: attachment; filename=startupList.xls");
header("Content-Description: PHP4 Generated Data");
print "<Meta Http-Equiv=\"Content-Type\" Content=\"Application/Vnd.Ms-Excel; Charset=UTF-8\">";
echo "\n <table>\n <tr>\n <td>id</td>\n <td>회사명</td>\n <td>한줄설명</td>\n <td>창립일</td>\n <td>규모</td>\n <td>웹사이트</td>\n <td>블로그</td>\n <td>twitter</td>\n <td>facebook</td>\n <td>이메일</td>\n <td>전화번호</td>\n <td>주소</td>\n <td>상태(0:승인대기,1:승인,2:비공개)</td>\n <td>dateCreated</td>\n <td>사업분야</td>\n <td>핵심기술</td>\n </tr>\n ";
for ($i = 0; $i < $len_res; $i++) {
$res_in = $this->Startup_bussiness->get_by_member_c($res[$i]["id"]);
$res_sk = $this->Startup_tech->get_by_member_c($res[$i]["id"]);
echo "<tr><td>" . $res[$i]["id"] . "</td><td>" . $res[$i]["name"] . "</td><td>" . $res[$i]["bio"] . "</td><td>" . $res[$i]["founded"] . "</td><td>" . $res[$i]["number"] . "</td><td>" . $res[$i]["website"] . "</td><td>" . $res[$i]["blog"] . "</td><td>" . $res[$i]["twitter"] . "</td><td>" . $res[$i]["facebook"] . "</td><td>" . $res[$i]["email"] . "</td><td>" . $res[$i]["tel"] . "</td><td>" . $res[$i]["addr"] . "</td><td>" . $res[$i]["state"] . "</td><td>" . $res[$i]["date_created"] . "</td><td>" . get_value_in_arr($res_in, "_value") . "</td><td>" . get_value_in_arr($res_sk, "_value") . "</td></tr>";
}
echo "\n </table>\n ";
exit(1);
}
