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); }