debugging = true; //$ap->assign('_smarty_debug_output', ''); ini_set( 'display_errors', 0 ); $act = $_REQUEST["act"]; $data["top"] = TOP; $data["top_url"] = TOP_URL; $data["gmap_key"] = GMAP_KEY; //季節 if ( ( date('m') == 3) || ( date('m') == 4) || ( date('m') == 5) ) { //春 $data["season"] = 1; } else if ( ( date('m') == 6) || ( date('m') == 7) || ( date('m') == 8) ) { // 夏 $data["season"] = 2; } else if ( ( date('m') == 9) || ( date('m') == 10) || ( date('m') == 11) ) { // 秋 $data["season"] = 3; } else if ( ( date('m') == 12) || ( date('m') == 1) || ( date('m') == 2) ) { // 冬 $data["season"] = 4; } // Pref -> City if ($ap->act == "get_city") { $id = $_REQUEST["id"]; if ($id) { if ($_REQUEST["use"]) { $sql = "SELECT city_cd,city FROM address WHERE substring(city_cd, 1, 2)={$id} and city is not null and city<>'' and count>0"; } else { $sql = "SELECT city_cd,city FROM address WHERE substring(city_cd, 1, 2)={$id} and city is not null and city<>''"; } $ret = $ap->inst->search_sql($sql); $list = $ret["data"]; } echo "{"; if ($list) { foreach ($list as $val) { echo "'" . $val["city_cd"] . "':'" . $val["city"] . "',"; } } //echo "'':''}"; echo "}"; exit; } // 都道府県から市区町村リスト取得（該当求人件数取得） if ($ap->act == "get_city2") { $id = $_REQUEST["id"]; if ($id) { if ($_REQUEST["use"]) { $sql = "SELECT city_cd,city FROM address WHERE substring(city_cd, 1, 2)={$id} and city is not null and city<>'' and count>0"; } else { //$sql = "SELECT city_cd,city FROM address WHERE substring(city_cd, 1, 2)={$id} and city is not null and city<>''"; $sql = "SELECT city_cd,city FROM address WHERE pref_cd={$id} and city is not null and city<>''"; } $ret = $ap->inst->search_sql($sql); $list = $ret["data"]; } echo "{"; if ($list) { foreach ($list as $val) { //echo "'" . $val["city_cd"] . "':'" . $val["city"] . "',"; // 該当件数取得 // $db = new Kyujin(); // $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 // $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 //// $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // // $db->search[] = array("field" => "kinmu", "value" => $id, "cond" => "="); //都道府県 // //$db->search[] = array("field" => "kinmu_city", "value" => (int)$val["city_cd"], "cond" => "="); //市区町村 // $db->search[] = array("field" => "kinmu_city", "value" => "%".(int)$val["city_cd"]."%", "cond" => "like"); // $count = $db->getCount(); $db = new Kyujin(); if ($_SESSION["serach_tmp"]) { $db->search = $_SESSION["serach_tmp"]; } else { $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 170927 企業アカウントの公開可能日判定はcronで処理 // // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // } $db->search[] = array("field" => "kinmu", "value" => $id, "cond" => "="); //都道府県 $db->search[] = array("field" => "kinmu_city", "value" => "%".(int)$val["city_cd"]."%", "cond" => "like"); $count = $db->getCount(); echo "'" . $val["city_cd"] . "':['" . $val["city"] . "','" . $count . "'],"; } } //echo "'':''}"; echo "}"; exit; } // 市区町村コードから市区町村名取得 if ($ap->act == "get_city_name") { $id = $_REQUEST["id"]; $sql = "select * from address where `city_cd`={$id}"; $ret = $ap->inst->search_sql($sql); $list = $ret["data"]; if ($list) { foreach ($list as $val) { echo $val["city"]; } } echo ""; exit; } if ($act == "ajax_eki") { $ensen = $_REQUEST["id"]; if ($ensen) { $sql = "select * from ekis where use_flag=1 AND ensen_cd='{$ensen}' order by eki_cd"; $inst = DBConnection::getConnection($DB_URI); //求人に登録されている駅のみ取得 20121112 sakai//////////////////////////// $eki_array = ""; $sql2 = "select eki1 from `kyujin` where ensen1=".$ensen.""; $ret2 = $inst->search_sql($sql2); if ($ret2["count"]) { $list2 = array(); foreach ($ret2["data"] as $val) { $list2[] = $val["eki1"]; } $eki_array = implode(",",$list2); // $list2="eki1" に当てはまる"eki_cd" } $eki_array2 = ""; $sql3 = "select eki2 from `kyujin` where ensen2=".$ensen.""; $ret3 = $inst->search_sql($sql3); if ($ret3["count"]) { $list3 = array(); foreach ($ret3["data"] as $val) { $list3[] = $val["eki2"]; } $eki_array2 = implode(",",$list3); // $list3="eki2" に当てはまる"eki_cd" } if (($eki_array) && ($eki_array2)) { $list4 = $eki_array.",".$eki_array2; } else if (($eki_array) && !($eki_array2)) { $list4 = $eki_array; } else if (!($eki_array) && ($eki_array2)) { $list4 = $eki_array2; } $eki_array3 = " and `eki_cd` IN(".$list4.")"; $sql = "select * from ekis where ( use_flag=1 AND ensen_cd='{$ensen}'{$eki_array3} ) order by eki_cd"; //求人に登録されている駅のみ取得 20121112 sakai//////////////////////////// $ret = $inst->search_sql($sql); if ($ret["count"]) { $list = $ret["data"]; $i = 0; foreach ($list as $val) { if ($i++) echo ","; echo $val["eki_cd"] . ":" . $val["name"]; } exit; } } echo ""; exit; } // 141215 新・沿線、駅検索ロジック用（駅一覧をチェックボックスで表示） if ($act == "ajax_eki2") { $ensen = $_REQUEST["id"]; $check_eki = $_REQUEST["check"]; //チェックされている駅リスト if ($ensen) { $sql = "select * from ekis where use_flag=1 AND ensen_cd='{$ensen}' order by eki_cd"; $inst = DBConnection::getConnection($DB_URI); //求人に登録されている駅のみ取得 20121112 sakai//////////////////////////// $eki_array = ""; $sql2 = "select eki1 from `kyujin` where ensen1=".$ensen.""; $ret2 = $inst->search_sql($sql2); if ($ret2["count"]) { $list2 = array(); foreach ($ret2["data"] as $val) { $list2[] = $val["eki1"]; } $eki_array = implode(",",$list2); // $list2="eki1" に当てはまる"eki_cd" } $eki_array2 = ""; $sql3 = "select eki2 from `kyujin` where ensen2=".$ensen.""; $ret3 = $inst->search_sql($sql3); if ($ret3["count"]) { $list3 = array(); foreach ($ret3["data"] as $val) { $list3[] = $val["eki2"]; } $eki_array2 = implode(",",$list3); // $list3="eki2" に当てはまる"eki_cd" } if (($eki_array) && ($eki_array2)) { $list4 = $eki_array.",".$eki_array2; } else if (($eki_array) && !($eki_array2)) { $list4 = $eki_array; } else if (!($eki_array) && ($eki_array2)) { $list4 = $eki_array2; } $eki_array3 = " and `eki_cd` IN(".$list4.")"; $sql = "select * from ekis where ( use_flag=1 AND ensen_cd='{$ensen}'{$eki_array3} ) order by eki_cd"; //求人に登録されている駅のみ取得 20121112 sakai//////////////////////////// $ret = $inst->search_sql($sql); if ($ret["count"]) { $list = $ret["data"]; $i = 0; if($check_eki) { foreach ($list as $val1) { foreach ($check_eki as $val2) { if ($val1["eki_cd"] == $val2) { $check_flg = 1; break; } } if ($check_flg) { echo "

" . $val1["name"] . "

"; } else { echo "

" . $val1["name"] . "

"; } $check_flg = ""; } } else { foreach ($list as $val1) { echo "

" . $val1["name"] . "

"; } } exit; } } echo "沿線を選択して下さい"; exit; } //------------------------------------- //給与表示 if ($act == "ajax_kyuyo") { $kyuyo = $_REQUEST["id"]; $item = get_info_item($kyuyo); $val = array(); $val[] = $item["kyuyo1"] . ":" . yen_format($item["kyuyo1"]); $val[] = $item["kyuyo2"] . ":" . yen_format($item["kyuyo2"]); $val[] = $item["kyuyo3"] . ":" . yen_format($item["kyuyo3"]); $val[] = $item["kyuyo4"] . ":" . yen_format($item["kyuyo4"]); $val[] = $item["kyuyo5"] . ":" . yen_format($item["kyuyo5"]); $val[] = $item["kyuyo6"] . ":" . yen_format($item["kyuyo6"]); echo join(";", $val); exit; } //------------------------------------ // 駅データJPテスト if ($ap->act == "ekidata") { $pref = $_REQUEST["pref"]; header("Content-Type: text/html; charset=UTF-8"); $ekidata = new MyEkiDataJP(); //$ekidata = new MyEkiDataJP(array('cache_file_path' => '.')); $lines = $ekidata->getLinesByPrefId($pref); foreach ( $lines->line as $line ) { echo "◆{$line->line_name} ({$line->line_cd})
"; $stations = $ekidata->getStationsByPrefIdAndLineId($pref, (string)$line->line_cd); foreach ( $stations as $s ) { echo " {$s->station->station_name} ({$s->station->station_cd})
"; } } exit; } //------------------------------------ // 路線選択リスト作成（新） if ($act == "ajax_rosen") { $pref = $_REQUEST["pref"]; if ($pref > 47 || $pref == "") { echo ""; exit; } $ekidata = new MyEkiDataJP(); $lines = $ekidata->getLinesByPrefId($pref); $i = 0; foreach ( $lines->line as $line ){ if ($i++) echo ","; echo "{$line->line_cd}:{$line->line_name}"; } exit; } //------------------------------------ // 駅選択リスト作成（新）求人作成時用 if ($act == "ajax_eki_make") { $pref = $_REQUEST["pref"]; $ensen = $_REQUEST["ensen"]; if ($pref > 47 || $pref == "") { echo ""; exit; } if ($ensen == "") { echo ""; exit; } $ekidata = new MyEkiDataJP(); $stations = $ekidata->getStationsByPrefIdAndLineId($pref, $ensen); $i = 0; foreach ( $stations as $s ){ if ($i++) echo ","; echo "{$s->station->station_cd}:{$s->station->station_name}"; } exit; } //------------------------------------ // 路線選択リスト作成（新）求人検索用 if ($act == "ajax_rosen_search") { $pref = $_REQUEST["pref"]; $ensen = $_REQUEST["ensen"]; //選択された項目を得る if ($pref > 47 || $pref == "") { echo ""; exit; } $ekidata = new MyEkiDataJP(); $lines = $ekidata->getLinesByPrefId($pref); $i = 0; foreach ( $lines->line as $line ){ //駅の求人数計測 // $sql = "select count(*) from kyujin where status=2 and del_flag=0 and kinmu = ".$pref." and (ensen1 = {$line->line_cd} or ensen2 = {$line->line_cd} )"; // $inst = DBConnection::getConnection($DB_URI); // $ret = $inst->search_sql($sql); // 170926 $db = new Kyujin(); if ($_SESSION["serach_tmp"]) { $db->search = $_SESSION["serach_tmp"]; foreach ($db->search as $key => $value) { if ($value["nest"][0]["field"] == "ensen1") { unset($db->search[$key]); break; } } } else { $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // } $db->search[] = array("field" => "kinmu", "value" => $pref, "cond" => "="); unset($nest); $nest[] = array("field" => "ensen1", "value" => $line->line_cd, "cond" => "=", "relation" => "or"); $nest[] = array("field" => "ensen2", "value" => $line->line_cd, "cond" => "=", "relation" => "or"); $db->search[] = array("nest" => $nest); $count = $db->getCount(); //$list = $db->getList(); // $flg = 0; if ($i++) echo ","; if (is_array($ensen)) { foreach($ensen as $val) { if ($val == $line->line_cd) { $flg = 1; } } if ($flg) { // echo "{$line->line_cd}:{$line->line_name}:".$ret["data"][0]["count(*)"].":sel"; echo "{$line->line_cd}:{$line->line_name}:".$count.":sel"; } else { // echo "{$line->line_cd}:{$line->line_name}:".$ret["data"][0]["count(*)"]; echo "{$line->line_cd}:{$line->line_name}:".$count; } } else { if ($ensen == $line->line_cd) { // echo "{$line->line_cd}:{$line->line_name}:".$ret["data"][0]["count(*)"].":sel"; echo "{$line->line_cd}:{$line->line_name}:".$count.":sel"; } else { // echo "{$line->line_cd}:{$line->line_name}:".$ret["data"][0]["count(*)"]; echo "{$line->line_cd}:{$line->line_name}:".$count; } } } exit; } //------------------------------------ // 駅選択リスト作成（新）求人検索用 if ($act == "ajax_eki_search") { $pref = $_REQUEST["pref"]; $ensen = $_REQUEST["ensen"]; $eki = $_REQUEST["eki"]; if ($pref > 47 || $pref == "") { echo ""; exit; } if ($ensen == "") { echo ""; exit; } header("Content-Type: text/html; charset=UTF-8"); $ekidata = new MyEkiDataJP(); $stations = $ekidata->getStationsByPrefIdAndLineId($pref, $ensen); $i = 0; foreach ( $stations as $s ){ //駅の求人数計測 // $sql = "select count(*) from kyujin where status=2 and del_flag=0 and (eki1 = {$s->station->station_cd} or eki2 = {$s->station->station_cd} )"; // $inst = DBConnection::getConnection($DB_URI); // $ret = $inst->search_sql($sql); $db = new Kyujin(); if ($_SESSION["serach_tmp"]) { $db->search = $_SESSION["serach_tmp"]; } else { $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // } unset($nest); $nest[] = array("field" => "eki1", "value" => $s->station->station_cd, "cond" => "=", "relation" => "or"); $nest[] = array("field" => "eki2", "value" => $s->station->station_cd, "cond" => "=", "relation" => "or"); $db->search[] = array("nest" => $nest); $count = $db->getCount(); //$list = $db->getList(); $flg = 0; if ($i++) echo ","; if (is_array($eki)) { foreach($eki as $val) { if ($val == $s->station->station_cd) { $flg = 1; } } if ($flg) { // echo "{$s->station->station_cd}:{$s->station->station_name}:".$ret["data"][0]["count(*)"].":sel"; echo "{$s->station->station_cd}:{$s->station->station_name}:".$count.":sel"; } else { // echo "{$s->station->station_cd}:{$s->station->station_name}:".$ret["data"][0]["count(*)"]; echo "{$s->station->station_cd}:{$s->station->station_name}:".$count; } } else { if ($eki == $s->station->station_cd) { // echo "{$s->station->station_cd}:{$s->station->station_name}:".$ret["data"][0]["count(*)"].":sel"; echo "{$s->station->station_cd}:{$s->station->station_name}:".$count.":sel"; } else { // echo "{$s->station->station_cd}:{$s->station->station_name}:".$ret["data"][0]["count(*)"]; echo "{$s->station->station_cd}:{$s->station->station_name}:".$count; } } } exit; } //------------------------------------- // 設定情報 if (!$_SESSION["SETUP"]) { $setup = get_setup(); if ($setup) { $_SESSION["SETUP"] = $setup; } } else { //$setup = $_SESSION["SETUP"]; $setup = get_setup(); if ($setup) { $_SESSION["SETUP"] = $setup; } } $_SESSION["SETUP"] = $setup; $data["setup"] = $setup; // footer 都道府県リンク 用 $db = new AreaKyujinCount(); $list = $db->getList(); $data["foot_pref_list"] = $list; // 最新求人日付 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->order[] = array("field" => "up_date", "desc" => "1"); $db->page = 0; $db->limit = 1; $list = $db->getList(); if ($list) { $data["new_info"] = date_format2($list[0]["up_date"]); } /* define("INFO_SETUP", 1); // 設定 define("INFO_AREA", 2); // 勤務地 1 define("INFO_KYUYO", 3); // 給与 2 define("INFO_KOYOU", 4); // 雇用形態 3 define("INFO_GYOSHU", 5); // 業種 4 define("INFO_SHOKUSYU", 6); // 職種 5 define("INFO_SKILL", 7); // スキル 6 define("INFO_SHIKAKU", 8); // 保有資格 7 define("INFO_RIREKI", 9); // 履歴書用職種 8 define("INFO_ENSEN", 10); // 沿線 9 define("INFO_EKI", 11); // 駅名 10 define("INFO_MAIL", 12); // メールテンプレート 11 define("INFO_UNEI", 13); // 運営会社情報 13 define("INFO_HELP", 14); // ヘルプカテゴリ 14 define("INFO_KAKIN", 15); // 課金 15 define("INFO_GYOMU", 16); // 業務 16 define("INFO_SKILLRANK", 17); // スキル状態 */ // -------------------------------- // 写真表示 if ($act == "get_image") { $id = htmlspecialchars($_REQUEST["id"]); $file = htmlspecialchars($_REQUEST["file"]); $size = htmlspecialchars($_REQUEST["size"]); // sizeで指定した矩形の切り取り $tx = htmlspecialchars($_REQUEST["x"]); // x,yで指定した矩形の切り取り $ty = htmlspecialchars($_REQUEST["y"]); // x,yで指定した矩形の切り取り $pv = htmlspecialchars($_REQUEST["pv"]); if ($id || $file) { if ($tx || $ty) { $sx = 0; $sy = 0; if ($tx) { $sx = $tx; } if ($ty) { $sy = $ty; } } else if ($size) { $sx = $size; $sy = $size; } else { $sx = 0; $sy = 0; } get_image($id, $file, $sx, $sy, $pv); } exit; } // ------------------------------------ // 応募フォーム メール重複処理用 if ($_SESSION["entry_email_jyuhuku"]) { if ( $act != "detail-form" ) { unset($_SESSION["entry_email_jyuhuku"]); } } // -------------------------------- // 各ページの処理 //$html = &htmltemplate::getInstance(); // -------------------------------- // ピックアップ情報の取得 //$db = new Pickup(); //$db->search[] = array("field" => "status", "value" => "1", "cond" => "="); //$db->search[] = array("expression" => "start_date <= now()"); //$db->search[] = array("expression" => "end_date >= now()"); //$list = $db->getList(); unset($list); $inst = DBConnection::getConnection($DB_URI); $sql = "select * from pickup where status = '1' and start_date <= CAST( DATE(sysdate()) AS DATE ) and end_date >= CAST( DATE(sysdate()) AS DATE )"; $list = $inst->search_sql($sql); if ($list) { $list = $list["data"]; shuffle($list); // ランダムに並べる // 5件以上なら5件選択 if (count($list) > 8) { $list = array_slice($list, 0, 8); } foreach ($list as $key => $val) { $company = Company::getData($val["company_id"]); $list[$key]["company_name"] = $company["company_name"]; $list[$key]["url"] = TOP_URL . "s/&company_id=" . $val["company_id"]; unset($cond); $cond["city_cd"] = $company["city"]; $cityname = Address::findData($cond); $list[$key]["address"] = $preficture_list[$company['pref']] . $cityname[0]['city']; } $list[count($list)-1]["last"] = "1"; // 最終データ $data["pickup"] = $list; } /* // -------------------------------- // 最近見た求人の取得 unset($list); if($_SESSION["LOGIN"]["kyushoku_id"]){ $where = " and kyushoku_id=".$_SESSION["LOGIN"]["kyushoku_id"]; }else{ $where = ""; } //$sql = "select kyujin_rireki.kyujin_id from kyujin_rireki, kyujin where kyujin_rireki.kyujin_id=kyujin.kyujin_id and kyujin_start<=date(now()) and kyujin_end>=date(now()) and status=2 order by kyujin_rireki.reg_date desc limit 0,20"; $sql = "select kyujin_rireki.kyujin_id from kyujin_rireki, kyujin where kyujin_rireki.kyujin_id=kyujin.kyujin_id and hellowork_flg <>1 and status=2 order by kyujin_rireki.reg_date desc limit 0,20"; $inst = DBConnection::getConnection($DB_URI); $ret = $inst->search_sql($sql); if ($ret["count"]) { $list = $ret["data"]; } if ($list) { $kyujin_id = array(); $num = 0; foreach ($list as $val) { if (!$kyujin_id[$val['kyujin_id']]) { $item = Kyujin::getData($val['kyujin_id'], array("kyujin_id", "company_id", "title", "pr1", "pr2", "kinmu", "main_image")); $company_name = Company::getData($item['company_id'], array("company_name")); $item["company_name"] = $company_name["company_name"]; $item["kinmu"] = $preficture_list[$item["kinmu"]]; $data["check"][] = $item; $kyujin_id[$val['kyujin_id']] = "1"; if (++$num >= 8) break; } } } */ // -------------------------------- // 掲載中求人数取得 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 //$db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $data["activ_kyujin_count"] = $db->getCount(); // 新着求人件数取得 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 //$db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("expression" => "up_date >= date(date_sub(now(), interval 14 day))"); // 2週間以内 $data["new_kyujin_count"] = $db->getCount(); // -------------------------------- // コンテンツページ if ($act == "page") { $id = $_REQUEST["id"]; if ($id) { // 230605 WPへリダイレクト if ($id == 13) { header("HTTP/1.1 301 Moved Permanently"); header("location: https://jobloom.jp/job-change/university-staff/"); exit; } $item = Page::getData($id); $item["contents"] = html_entity_decode($item["contents"]); $data["item"] = $item; } $ap->view("page.html", $data); exit; } // ログイン if ($act == "login") { if ($_REQUEST["email"] && $_REQUEST["passwd"]) { $email = htmlspecialchars($_REQUEST["email"]); $passwd = htmlspecialchars($_REQUEST["passwd"]); $cond["email"] = $email; $cond["passwd"] = Encode($passwd); $cond["del_flag"] = "0"; $ret = Kyushoku::findData($cond); if (count($ret) == 1) { $user = $ret[0]; $_SESSION["LOGIN"] = $user; // if ($_REQUEST["auto_login"]) { setLoginCookie("X", $user["kyushoku_id"], LOGIN_COOKIE1); } // if (isset($_SESSION['NEXT_URL'])) { $url = $_SESSION['NEXT_URL']; unset($_SESSION['NEXT_URL']); header("location: " . $url); } else { // MyPageへ header("location: ./myuser/"); } exit; } $data["message"] = "ログインできません。IDとパスワードを確認してください。"; $data["email"] = $email; $data["passwd"] = $passwd; } else { $data["message"] = $_SESSION['LOGIN_MESSAGE']; } unset($_SESSION['LOGIN_MESSAGE']); $ap->view("login.html", $data); exit; } if ($act == "logout") { // ログアウト unset($_SESSION["LOGIN"]); } // -------------------------------- // ログイン成功後の処理の継続の場合 if ($act == 'logined') { $_REQUEST = $_SESSION['REQUEST']; unset($_SESSION['REQUEST']); $act = htmlspecialchars($_REQUEST['act']); } //----------------------------------- if (isset($_SESSION["LOGIN"])) { $data["login"] = 1; } else { $ret = isLogin(LOGIN_COOKIE1); if ($ret) { $id = $ret["user_id"]; $user = Kyushoku::getData($id); if ($user) { $_SESSION["LOGIN"] = $user; if (isset($_SESSION['NEXT_URL'])) { $url = $_SESSION['NEXT_URL']; unset($_SESSION['NEXT_URL']); header("location: " . $url); exit; } $data["login"] = 1; } else { $data['logout'] = 1; } } else { $data['logout'] = 1; } } // 企業の自動ログインチェック if (!$_SESSION["COMPANY_LOGIN"]) { if (($ret = isLogin(LOGIN_COOKIE2))) { $id = $ret["user_id"]; $user = Company::getData($id); if ($user) { $_SESSION["COMPANY_LOGIN"] = $user; if (isset($_SESSION['NEXT_URL'])) { $url = $_SESSION['NEXT_URL']; unset($_SESSION['NEXT_URL']); header("location: " . $url); exit; } } } } else { // $data[company_login] = "1"; // php7系対応 $data["company_login"] = "1"; } // 検討中に保存 if ($act == "bookmark") { login_check("ログインしてください"); // 削除 if ($_REQUEST["del"]) { foreach ($_REQUEST["del"] as $val) { unset($cond); $cond["seq"] = $val; $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = Bookmark::findData($cond); if ($ret) { Bookmark::deleteData($val); } } } // 追加 if ($_REQUEST["id"]) { $ok = true; $id = $_REQUEST["id"]; // 検討中に登録済み unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $cond["kyujin_id"] = $id; $ret = Bookmark::findData($cond); if ($ret) { $data["error"] = "この求人はすでに検討中に登録済みです。"; $ok = false; } // 応募済み unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $cond["kyujin_id"] = $id; $ret = Oubo::findData($cond); if ($ret) { $data["error"] = "この求人にはすでに応募しています。"; $ok = false; } if ($ok) { unset($item); $item["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $item["kyujin_id"] = $id; Bookmark::addData($item); // 追加 } } unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = Bookmark::findData($cond); if ($ret) { $list = array(); foreach ($ret as $key => $val) { $item = Kyujin::getData($val["kyujin_id"]); if ($item) { $item["seq"] = $val["seq"]; // 内容200字まで // 企業情報 // 新着 // 更新日 $item["reg_date"] = date_format2($item["reg_date"]); $list[] = disp_kyujin($item); } } $data["total"] = count($list); $data["list"] = $list; } $ap->view("bookmark.html", $data); exit; } if ($act == "company") { $ap->view("company.html", $data); exit; } //-------------------------------------------- // お問合せ $contact_check = array( // フォーム項目名 文字種 最大文字数 必須 表示名称 array("company_name", "*", "", false, "会社名"), array("name", "*", "", true, "お名前"), array("email", "MAIL", "", true, "メールアドレス"), array("email2", "MAIL", "", true, "メールアドレス確認"), array('tel', "TEL", "", false, "電話番号"), array('kind', "*", "", true, "お問合せ内容"), array('comment', "*", "", true, "詳細"), array("mode", "*", "", true, "モード"), ); if ($act == "contact") { $form = FormCheck::get_form($contact_check, $_REQUEST); if ($form) { $msg = FormCheck::check($form, $contact_check); // メールアドレス重複 if ($form["email"] && $form["email2"]) { if ($form["email"] != $form["email2"]) { $msg["email"] = "メールアドレスが一致していません"; } } $data["form"] = $form; // if ($msg) { foreach ($msg as $key => $v) { $data["error"][$key] = $v; $data["message"][] = $v; } } else { $_SESSION["contact"] = $form; $data["form"]["kind"] = $contact_list[$form["kind"]]; $ap->view("contact-confirm.html", $data); exit; } } if ($_SESSION["contact"]) { $data["form"] = $_SESSION["contact"]; } // お問い合わせ種別設定用 if ($_REQUEST["k"]) { $data["form"]["kind"] = $_REQUEST["k"]; } $data["contact_list"] = $contact_list; $ap->view("contact.html", $data); exit; } if ($act == "contact-confirm") { if ($_REQUEST["mode"]) { if ($_SESSION["contact"]) { $form = $_SESSION["contact"]; unset($_SESSION["contact"]); unset($item); $item["company_name"] = $form["company_name"]; $item["name"] = $form["name"]; $item["email"] = $form["email"]; $item["tel"] = $form["tel"]; $item["kind"] = $form["kind"]; $item["comment"] = $form["comment"]; Contact::addData($item); // メール送信 $form["kind"] = $contact_list[$form["kind"]]; $info = array("form" => $form, "setup" => $setup); // メール送信(確認） template_mail($form["email"], "inquire_user_subject", "inquire_user_body", $info, ""); // メール送信(管理者） $mail = get_setup(INFO_MAIL); template_mail($mail["admin_mail_replay"], "inquire_admin_subject", "inquire_admin_body", $info, ""); // $data["complete"] = "1"; $data["form"] = $form; $ap->view("contact-thankyou.html", $data); exit; } else { header("location: ./"); exit; } } $data["form"] = $_SESSION["contact"]; $data["form"]["kind"] = $contact_list[$data["form"]["kind"]]; $ap->view("contact-confirm.html", $data); exit; } //-------------------------------------------- // 電話応募 $entry_tel_check = array( // フォーム項目名 文字種 最大文字数 必須 表示名称 array("name", "*", "", true, "氏名"), array("name_kana", "*", "", true, "氏名フリガナ"), array('tel', "TEL", "", false, "電話番号"), array('mobile', "TEL", "", false, "携帯電話番号"), array("email", "MAIL", "", false, "メールアドレス"), array("mode", "*", "", true, "モード"), ); if ($act == "entry_tel") { $id = $_REQUEST["id"]; if (!$id) { // 求人が選択されていない header("location: ./"); exit; } // $item = Kyujin::getData($id); //求人データ取得 // 期限切れ、終了チェック if ( ($item["status"] == 2) && ( (strtotime(date('Y-m-d')) >= strtotime($item["kyujin_start"]) ) && (strtotime(date('Y-m-d')) <= strtotime($item["kyujin_end"]) ) ) ) { //ok } else { header("location: ./"); exit; } // $data["item"] = disp_kyujin($item); // ログインユーザーの応募済みチェック if ($_SESSION["LOGIN"]) { unset($cond); $cond['kyujin_id'] = $id; $cond['kyushoku_id'] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = EntryTel::findData($cond); if ($ret) { $data["oubo_message"] = "この求人には、".date('Y年n月j日 G時i分', strtotime($ret[0]["reg_date"]))."に表示済みです。
電話番号を再度表示する場合は、入力内容を確認の上「電話番号を表示する」ボタンをクリックして下さい。"; $data["completed"] = 1; //既にエントリー済み } } // $form = FormCheck::get_form($entry_tel_check, $_REQUEST); if ($form) { $msg = FormCheck::check($form, $entry_tel_check); $data["form"] = $form; if ($form["tel"] || $form["mobile"]) { // } else { $msg["tel"] = "電話番号が記入されていません"; } // if ($msg) { foreach ($msg as $key => $v) { $data["error"][$key] = $v; $data["message"][] = $v; } /* } else { //確認ページへ $_SESSION["entry_tel"] = $form; $ap->view("entry_tel_confirm.html", $data); exit; } */ } else { //ログインユーザー以外の応募済みチェック if (!$_SESSION["LOGIN"]) { unset($cond); $cond['kyujin_id'] = $id; $cond['name'] = $form["name"]; $cond['name_kana'] = $form["name_kana"]; $ret = EntryTel::findData($cond); if ($ret) { foreach($ret as $val) { if ( ( $val["tel"] && ( $val["tel"] == $form["tel"] ) ) || ( $val["mobile"] && ( $val["mobile"] == $form["mobile"] ) ) ) { $data["oubo_message"] = "この求人には、".date('Y年n月j日 G時i分', strtotime($val["reg_date"]))."に表示済みです。"; break; } } $data["completed"] = 1; //既にエントリー済み } } else if ($data["completed"] == 1) { //ログインユーザーの応募済みメッセージ設定 $data["oubo_message"] = str_replace('
電話番号を再度表示する場合は、入力内容を確認の上「電話番号を表示する」ボタンをクリックして下さい。', '', $data["oubo_message"]); } // if ($data["completed"] != 1) { // 登録 unset($item); $item['kyujin_id'] = $id; $item['kyushoku_id'] = (isset($_SESSION["LOGIN"]["kyushoku_id"])) ? $_SESSION["LOGIN"]["kyushoku_id"] : 0; $item['name'] = $form["name"]; $item['name_kana'] = $form["name_kana"]; $item['email'] = $form["email"]; $item['tel'] = $form["tel"]; $item['mobile'] = $form["mobile"]; EntryTel::addData($item); // 電話応募メール（求職者向け） $info = array("setup" => $setup, "form" => $form, "kyujin" => $data["item"]); if ($form["email"]) { template_mail($form["email"], "tel_entry_user_subject", "tel_entry_user_body", $info, "admin_mail_noreplay"); } // 電話応募メール（会社向け） $company = Company::getData($data["item"]["company_id"]); $info = array("setup" => $setup, "form" => $form, "kyujin" => $data["item"], "company" => $company); template_mail($company["email"], "tel_entry_company_subject", "tel_entry_company_body", $info, "admin_mail_noreplay"); // } //unset($_SESSION["form"]); //$_SESSION["form"] = "entry_tel"; $ap->view("entry_tel_thankyou.html", $data); exit; } } else if ($_SESSION["LOGIN"]["kyushoku_id"]) { unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = Rirekisyo::findData($cond); if ($ret) { $form = $ret[0]; $form["name_kana"] = $form["kana"]; if ($form["email"]) { $form["email2"] = $form["email"]; } $data["form"] = $form; } else { $form = $_SESSION["LOGIN"]; $form["name_kana"] = $form["kana"]; $form["email2"] = $form["email"]; $data["form"] = $form; } } $ap->view("entry_tel.html", $data); exit; } if ($act == "entry_tel_thankyou") { header("location: ./"); exit; } //-------------------------------------------- // 応募 $oubo1_check = array( // フォーム項目名 文字種 最大文字数 必須 表示名称 array("name", "*", "", true, "氏名"), array("kana", "*", "", true, "フリガナ"), array("email", "MAIL", "", true, "メールアドレス"), array("email2", "MAIL", "", true, "メールアドレス確認"), array('birthday_year', "*", "", true, "生年月日"), array('birthday_month', "*", "", true, "生年月日"), array('birthday_day', "*", "", true, "生年月日"), array('image', "*", "", false, "写真"), array('sex', "*", "", true, "性別"), array('zip1', "N", "", false, "郵便番号"), array('zip2', "N", "", false, "郵便番号"), array('pref', "*", "", true, "都道府県"), array('address1', "*", "", true, "住所１"), array('address2', "*", "", true, "住所２"), array('tel', "TEL", "", false, "自宅電話"), array('mobile', "TEL", "", false, "携帯電話"), array('school', "*", "", true, "最終学歴"), array('gakubu', "*", "", false, "学部"), array('school_year', "*", "", true, "学歴年"), array('school_status', "*", "", true, "学歴状況"), array('passwd', "AN", "", false, "パスワード"), array('passwd2', "AN", "", false, "パスワード確認"), array("mode", "*", "", true, "モード"), ); if ($act == "detail-form") { $id = $_REQUEST["id"]; if (!$id) { // 求人が選択されていない header("location: ./"); exit; } // $item = Kyujin::getData($id); //求人データ取得 // 期限切れ、終了チェック if ( ($item["status"] == 2) ) { //ok } else { header("location: ./"); exit; } // $data["item"] = disp_kyujin($item); // 応募済みチェック unset($cond); $cond['kyujin_id'] = $id; $cond['kyushoku_id'] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = Oubo::findData($cond); if ($ret) { $data["oubo_error"] = "この求人には、応募済みです。"; $ap->view("detail-form.html", $data); exit; } // $form = FormCheck::get_form($oubo1_check, $_REQUEST); if ($form) { $msg = FormCheck::check($form, $oubo1_check); if (!$_SESSION["LOGIN"]) { // ログインしていないで応募 if (!$form["passwd"]) { $msg["passwd"] = "パスワードが入力されていません。"; } if (!$form["passwd2"]) { $msg["passwd2"] = "パスワード確認が入力されていません。"; } if ($form["passwd"] && $form["passwd2"]) { if ($form["passwd"] != $form["passwd2"]) { $msg["passwd"] = "パスワードが一致していません。"; } } } // 写真 $img = form_image("image", $msg); if ($msg["image"]) { $msg["image"] = "写真の" . $msg["image"]; } else { if ($img) { $form["image"] = $img; } } $data["form"] = $form; // メールアドレス重複 if ($form["email"] && $form["email2"]) { if ($form["email"] != $form["email2"]) { $msg["email"] = "メールアドレスが一致していません"; } else if (!$_SESSION["LOGIN"]["kyushoku_id"]) { // 新規の場合は登録済みチェックをする unset($cond); $cond["email"] = $form["email"]; $ret = Kyushoku::findData($cond); if ($ret) { $msg["email"] = "このメールアドレスは登録済みです"; // 150527 メール登録済みの場合、ログイン導線を表示、そこからのログインにてフォーム情報を保持したまま戻る $data["entry_email_jyuhuku"] = "1"; $_SESSION["entry_email_jyuhuku"] = $form; $_SESSION["entry_email_jyuhuku"]["kyujin_id"] = $id; } } else { unset($cond); $cond["email"] = $form["email"]; $ret = Kyushoku::findData($cond); if ($ret) { foreach ($ret as $val) { if ($val["kyushoku_id"] != $_SESSION["LOGIN"]["kyushoku_id"]) { $msg["email"] = "このメールアドレスは登録済みです"; // 150527 メール登録済みの場合、ログイン導線を表示、そこからのログインにてフォーム情報を保持したまま戻る $data["entry_email_jyuhuku"] = "1"; $_SESSION["entry_email_jyuhuku"] = $form; $_SESSION["entry_email_jyuhuku"]["kyujin_id"] = $id; break; } } } } } if ($form["tel"] || $form["mobile"]) { // } else { $msg["tel"] = "電話番号が記入されていません"; } // 郵便番号 if ($form["zip1"] && $form["zip2"]) { // } else { $msg["zip"] = "郵便番号が記入されていません"; } // $m = set_error_msg($msg["pref"], $msg["address1"], $msg["address2"]); if ($m) { unset($msg["pref"]); unset($msg["address1"]); unset($msg["address2"]); $msg["address"] = $m; } $m = set_error_msg($msg["birthday_year"], $msg["birthday_month"], $msg["birthday_day"]); if ($m) { unset($msg["birthday_year"]); unset($msg["birthday_month"]); unset($msg["birthday_day"]); $msg["birthday"] = $m; } // 資格 $shikaku = $_REQUEST["shikaku"]; /* $shikaku = array(); $shikaku_sel = array(); if ($_REQUEST["shikaku"]) { foreach ($_REQUEST["shikaku"] as $val) { $shikaku[$val] = $val; } } */ $form["shikaku"] = $shikaku; // スキル $skill = array(); if ($_REQUEST["skill"]) { foreach ($_REQUEST["skill"] as $key => $val) { $skill[$key] = $val; } } $form["skill"] = $skill; // if ($msg) { foreach ($msg as $key => $v) { $data["error"][$key] = $v; $data["message"][] = $v; } } else { $_SESSION["detail1"] = $form; $act = "detail-form-2"; } // $data["skill"] = get_info(INFO_SKILL); $data["skillrank"] = get_info(INFO_SKILLRANK); foreach ($data["skill"] as $key => $val) { foreach ($data["skillrank"] as $val2) { if ($skill[$val["info_id"]] == $val2["info_id"]) { $val2["sel"] = "checked"; } $data["skill"][$key]["skillrank"][] = $val2; } } $data["shikaku"] = get_info_select(INFO_SHIKAKU, $shikaku, "checked"); } else if ($_SESSION["detail1"]) { // 戻ってきた場合 $form = $_SESSION["detail1"]; if ($form["email"]) { $form["email2"] = $form["email"]; } $data["form"] = $form; // $skill = $form["skill"]; $shikaku = $form["shikaku"]; } else if ($_SESSION["LOGIN"]["kyushoku_id"]) { // 150527 入力したメールが登録済みの場合、ログイン導線を表示、そこからのログインにてフォーム情報を保持したまま戻る if ($_SESSION["entry_email_jyuhuku"]) { unset($_SESSION["entry_email_jyuhuku"]); } // ログインしていれば、現在の登録データを取り出す unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = Rirekisyo::findData($cond); if ($ret) { $form = $ret[0]; if ($form["email"]) { $form["email2"] = $form["email"]; } $data["form"] = $form; // 職歴初期化 for ($i = 0; $i < 10; $i++) { unset($item); if ($i > 0) { $item["body"] = "none"; $item["tab"] = "block"; } $item["id"] = $i + 1; $item['from_year'] = year_select(date('Y'), 1930); $item['to_year'] = year_select(date('Y'), 1930); $data["syoku"][$i] = $item; } // /* unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $cond["oubo_id"] = "0"; $ret = Syokureki::findData($cond); */ $ret = getSyokureki($_SESSION["LOGIN"]["kyushoku_id"], "0"); if ($ret) { $i = 0; foreach ($ret as $val) { unset($item); if ($i > 0) { $item["body"] = "block"; $item["tab"] = "none"; } $item["id"] = $i + 1; $item['company'] = $val["company_name"]; $item['from_year'] = year_select(date('Y'), 1930, substr($val["priod_start"], 0, 4)); $item['from_month' . intval(substr($val["priod_start"], 5, 2))] = "selected"; $item['to_year'] = year_select(date('Y'), 1930, substr($val["priod_end"], 0, 4)); $item['to_month' . intval(substr($val["priod_end"], 5, 2))] = "selected"; $item['syokusyu' . $val["syokusyu"]] = "selected"; $item['koyou' . $val["koyou"]] = "selected"; $item['shokumu'] = $val["kinmu"]; $data["syoku"][$i++] = $item; } } // スキル unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $cond["oubo_id"] = "0"; $ret = Skill::findData($cond); $skill = array(); if ($ret) { foreach ($ret as $val) { $skill[$val["skill_id"]] = $val["status"]; } } // 資格 $ret = Shikaku::findData($cond); $shikaku = array(); if ($ret) { foreach ($ret as $val) { $shikaku[] = $val["shikaku_id"]; } } } else { $form = $_SESSION["LOGIN"]; $form["email2"] = $form["email"]; $data["form"] = $form; } } // if ($form["sex"]) { $data["sex". $form["sex"]] = "checked"; } if ($form["birthday"]) { $y = substr($form["birthday"], 0, 4); $m = intval(substr($form["birthday"], 5, 2)); $d = intval(substr($form["birthday"], 8, 2)); // $data["birthday_year" . $y] = "selected"; $data["birthday_year"] = year_select(date('Y')-16, 1930, $y); $data["birthday_month" . $m] = "selected"; $data["birthday_day" . $d] = "selected"; } else if ($form["birthday_year"]) { $data["birthday_year"] = year_select(date('Y')-16, 1930, $form["birthday_year"]); $data["birthday_month" . $form["birthday_month"]] = "selected"; $data["birthday_day" . $form["birthday_day"]] = "selected"; } else { $data["birthday_year"] = year_select(date('Y')-16, 1930); } if ($form["pref"]) { $data["pref" . $form["pref"]] = "selected"; } //add hana +5 111101 $data["school_year"] = year_select(date('Y')+5, 1950, $form["school_year"]); if ($form["school_status"]) { $data["school_status" . $form["school_status"]] = "selected"; } // $data["skill"] = get_info(INFO_SKILL); $data["skillrank"] = get_info(INFO_SKILLRANK); foreach ($data["skill"] as $key => $val) { foreach ($data["skillrank"] as $val2) { if ($skill[$val["info_id"]] == $val2["info_id"]) { $val2["sel"] = "checked"; } $data["skill"][$key]["skillrank"][] = $val2; } } $data["shikaku"] = get_info_select(INFO_SHIKAKU, $shikaku, "checked"); /* if ($data["shikaku"]) { foreach ($data["shikaku"] as $key => $val) { if ($shikaku[$val["info_id"]]) { $data["shikaku"][$key]["sel"] = "checked"; } } } */ if ($act == "detail-form") { $ap->view("detail-form.html", $data); exit; } } if ($act == "detail-form-2") { $id = $_REQUEST["id"]; if (!$id) { // 求人が選択されていない header("location: ./"); exit; } $item = Kyujin::getData($id); $data["item"] = disp_kyujin($item); $pr = htmlspecialchars($_REQUEST["pr"]); // if ($_REQUEST["mode"] == "form2") { // 職歴保存 for ($i = 1; $i <= 10; $i++) { $company = htmlspecialchars($_REQUEST['syoku' . $i . '_company']); $from_year = $_REQUEST['syoku' . $i . '_from_year']; $from_month = $_REQUEST['syoku' . $i . '_from_month']; $to_year = $_REQUEST['syoku' . $i . '_to_year']; $to_month = $_REQUEST['syoku' . $i . '_to_month']; $syokusyu = $_REQUEST['syoku' . $i . '_syokusyu']; $koyou = $_REQUEST['syoku' . $i . '_koyou']; $shokumu = htmlspecialchars($_REQUEST['syoku' . $i . '_shokumu']); // 文字数カウント用　改行コード変換 $tmp_count = str_replace("\r\n", "\n", $_REQUEST['syoku' . $i . '_shokumu']); // if ( mb_strlen( $tmp_count, "UTF-8" ) > 2000 ) { $msg['syoku' . $i . '_shokumu'] = "職歴" . $i . "の職務内容が2000文字を超えています。"; } // if ($company || $from_year || $from_month || $to_year || $to_month || $syokusyu || $koyou || $shokumu) { if ($company && $from_year && $from_month && $to_year && $to_month && $syokusyu && $koyou && $shokumu) { // } else { $msg["shoku" . $i] = "職歴は全ての項目を入力してください"; } } unset($item); $item["company"] = $company; $item["from_year"] = $from_year; $item["from_month"] = $from_month; $item["to_year"] = $to_year; $item["to_month"] = $to_month; $item["syokusyu"] = $syokusyu; $item["koyou"] = $koyou; $item["shokumu"] = $shokumu; $syoku[] = $item; } if ($msg) { foreach ($msg as $key => $v) { $data["error"][$key] = $v; } $_SESSION["detail2"]["syoku"] = $syoku; $_SESSION["detail2"]["pr"] = $pr; } else { $_SESSION["detail2"]["syoku"] = $syoku; $_SESSION["detail2"]["pr"] = $pr; $act = "detail-form-confirm"; } } if ($act == "detail-form-2") { // 職歴初期化 for ($i = 0; $i < 10; $i++) { unset($item); if ($i > 0) { $item["body"] = "none"; $item["tab"] = "block"; } $item["id"] = $i + 1; $item['from_year'] = year_select(date('Y'), 1930); $item['to_year'] = year_select(date('Y'), 1930); $item['syokureki'] = get_info_select(INFO_RIREKI); $item['koyou'] = get_info_select(INFO_RIREKIKOYOU); $data["syoku"][$i] = $item; } // if ($_SESSION["detail2"]) { $syoku = $_SESSION["detail2"]["syoku"]; if ($syoku) { $i = 0; foreach ($syoku as $val) { if ($val["company"]) { unset($item); if ($i > 0) { $item["body"] = "block"; $item["tab"] = "none"; } $item["id"] = $i + 1; $item['company'] = $val["company"]; $item['from_year'] = year_select(date('Y'), 1930, $val["from_year"]); $item['from_month' . intval($val["from_month"])] = "selected"; $item['to_year'] = year_select(date('Y'), 1930, $val["to_year"]); $item['to_month' . intval($val["to_month"])] = "selected"; $item['syokureki'] = get_info_select(INFO_RIREKI, $val["syokusyu"]); $item['koyou'] = get_info_select(INFO_RIREKIKOYOU, $val["koyou"]); $item['shokumu'] = $val["shokumu"]; $data["syoku"][$i++] = $item; } } } $data["form"]["pr"] = $_SESSION["detail2"]["pr"]; } else if ($_SESSION["LOGIN"]["kyushoku_id"]) { /* unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $cond["oubo_id"] = "0"; $ret = Syokureki::findData($cond); */ $ret = getSyokureki($_SESSION["LOGIN"]["kyushoku_id"], "0"); if ($ret) { $i = 0; foreach ($ret as $val) { unset($item); if ($i > 0) { $item["body"] = "block"; $item["tab"] = "none"; } $item["id"] = $i + 1; $item['company'] = $val["company_name"]; $item['from_year'] = year_select(date('Y'), 1930, substr($val["priod_start"], 0, 4)); $item['from_month' . intval(substr($val["priod_start"], 5, 2))] = "selected"; $item['to_year'] = year_select(date('Y'), 1930, substr($val["priod_end"], 0, 4)); $item['to_month' . intval(substr($val["priod_end"], 5, 2))] = "selected"; $item['syokureki'] = get_info_select(INFO_RIREKI, $val["syokusyu"]); $item['koyou'] = get_info_select(INFO_RIREKIKOYOU, $val["koyou"]); $item['shokumu'] = $val["kinmu"]; $data["syoku"][$i++] = $item; } } // $user = Kyushoku::getData($_SESSION["LOGIN"]["kyushoku_id"]); unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = Rirekisyo::findData($cond); if ($ret) { $data["form"]["pr"] = $ret[0]["pr"]; } } else { $form = $_SESSION["LOGIN"]; $form["passwd2"] = $form["passwd"]; $data["form"] = $form; } $ap->view("detail-form-2.html", $data); exit; } } if ($act == "detail-form-confirm") { $id = $_REQUEST["id"]; if (!$id) { // 求人が選択されていない header("location: ./"); exit; } $kyujin = Kyujin::getData($id); $data["item"] = disp_kyujin($kyujin); // if ((!$_SESSION["detail1"]) || (!$_SESSION["detail2"])) { header("location: ./"); exit; } // if ($_REQUEST["mode"] == "form3") { // 保存 $form = $_SESSION["detail1"]; $syoku = $_SESSION["detail2"]["syoku"]; $pr = $_SESSION["detail2"]["pr"]; // 利用者登録がまだなら、利用者登録を先に行う if (!$_SESSION["LOGIN"]["kyushoku_id"]) { unset($item); $item['name'] = $form["name"]; $item['kana'] = $form["kana"]; $item['email'] = $form["email"]; $item['passwd'] = Encode($form["passwd"]); $item['pr'] = $pr; $kyushoku_id = Kyushoku::addData($item); // 登録完了メール $info = array("setup" => $setup, "form" => $form); template_mail($form["email"], "regist_subject", "regist_body", $info, "admin_mail_noreplay"); // 150527 利用者登録がまだの方が応募した後は、強制ログインさせる $cond["email"] = $item["email"]; $cond["passwd"] = $item["passwd"]; $cond["del_flag"] = "0"; $ret = Kyushoku::findData($cond); if (count($ret) == 1) { $_SESSION["LOGIN"] = $ret[0]; } $data["login"] = 1; //ログインフラグ // // 履歴書保存 unset($item); $item['kyushoku_id'] = $kyushoku_id; $item['name'] = $form["name"]; $item['kana'] = $form["kana"]; $item['sex'] = $form["sex"]; $item['birthday'] = $form["birthday_year"] ."-". $form["birthday_month"] ."-". $form["birthday_day"]; $item['zip1'] = $form["zip1"]; $item['zip2'] = $form["zip2"]; $item['pref'] = $form["pref"]; $item['address1'] = $form["address1"]; $item['address2'] = $form["address2"]; $item['tel'] = $form["tel"]; $item['mobile'] = $form["mobile"]; $item['email'] = $form["email"]; $item['school'] = $form["school"]; // 2012/01/18 酒井追加　ここから $item['gakubu'] = $form["gakubu"]; // 2012/01/18 酒井追加　ここまで $item['school_year'] = $form["school_year"]; $item['school_status'] = $form["school_status"]; $item['pr'] = $pr; $rirekisyo_id = Rirekisyo::addData($item); } else { $kyushoku_id = $_SESSION["LOGIN"]["kyushoku_id"]; // 履歴書保存 unset($item); $item['kyushoku_id'] = $kyushoku_id; $item['name'] = $form["name"]; $item['kana'] = $form["kana"]; $item['sex'] = $form["sex"]; $item['birthday'] = $form["birthday_year"] ."-". $form["birthday_month"] ."-". $form["birthday_day"]; $item['zip1'] = $form["zip1"]; $item['zip2'] = $form["zip2"]; $item['pref'] = $form["pref"]; $item['address1'] = $form["address1"]; $item['address2'] = $form["address2"]; $item['tel'] = $form["tel"]; $item['mobile'] = $form["mobile"]; $item['email'] = $form["email"]; $item['school'] = $form["school"]; $item['gakubu'] = $form["gakubu"]; $item['school_year'] = $form["school_year"]; $item['school_status'] = $form["school_status"]; // $item['pr'] = $pr; // unset($cond); $cond['kyushoku_id'] = $kyushoku_id; $ret = Rirekisyo::findData($cond); if ($ret) { $rirekisyo_id = $ret[0]["rirekisyo_id"]; Rirekisyo::updateData($rirekisyo_id, $item); } else { $rirekisyo_id = Rirekisyo::addData($item); } // スキル、資格、職歴削除 unset($cond); $cond['kyushoku_id'] = $kyushoku_id; $cond["oubo_id"] = "0"; $ret = Skill::findData($cond); if ($ret) { foreach ($ret as $val) { Skill::deleteData($val["seq"]); } } $ret = Shikaku::findData($cond); if ($ret) { foreach ($ret as $val) { Shikaku::deleteData($val["seq"]); } } //$ret = Syokureki::findData($cond); $ret = getSyokureki($kyushoku_id, "0"); if ($ret) { foreach ($ret as $val) { Syokureki::deleteData($val["seq"]); } } } unset($item); $item['kyujin_id'] = $id; $item['kyushoku_id'] = $kyushoku_id; // $item['koyou'] = $form["koyou"]; $item['name'] = $form["name"]; $item['sex'] = $form["sex"]; $item['birthday'] = $form["birthday_year"] ."-". $form["birthday_month"] ."-". $form["birthday_day"]; //Ouboには郵便番号は無い //$item['zip1'] = $form["zip1"]; //$item['zip2'] = $form["zip2"]; $item['pref'] = $form["pref"]; $item['address1'] = $form["address1"]; $item['address2'] = $form["address2"]; $item['tel'] = $form["tel"]; $item['email'] = $form["email"]; $item['school'] = $form["school"]; $item['school_year'] = $form["school_year"]; $item['school_status'] = $form["school_status"]; $item['passwd'] = $form["passwd"]; $item['pr'] = $pr; $item['last_message'] = "0"; // 返事待ち $oubo_id = Oubo::addData($item); if ($oubo_id) { // スキル $skill = $form["skill"]; if ($skill) { foreach ($skill as $key => $val) { unset($item); $item["kyushoku_id"] = $kyushoku_id; $item["oubo_id"] = $oubo_id; $item["skill_id"] = $key; $item["status"] = $val; Skill::addData($item); // if (!$_SESSION["LOGIN"]["kyushoku_id"]) { // 履歴書用 $item["oubo_id"] = "0"; Skill::addData($item); // } } } // 資格 $shikaku = $form["shikaku"]; if ($shikaku) { foreach ($shikaku as $val) { unset($item); $item["kyushoku_id"] = $kyushoku_id; $item["oubo_id"] = $oubo_id; $item["shikaku_id"] = $val; Shikaku::addData($item); // if (!$_SESSION["LOGIN"]["kyushoku_id"]) { // 履歴書用 $item["oubo_id"] = "0"; Shikaku::addData($item); // } } } // 職歴 if ($syoku) { $i = 1; foreach ($syoku as $val) { if ($val['company']) { unset($item); $item["kyushoku_id"] = $kyushoku_id; $item["oubo_id"] = $oubo_id; $item["company_name"] = $val['company']; $item["priod_start"] = $val['from_year'] . "-" . $val['from_month'] . "-01"; $item["priod_end"] = $val['to_year'] . "-" . $val['to_month'] . "-01"; $item["syokusyu"] = $val['syokusyu']; $item["koyou"] = $val['koyou']; $item["kinmu"] = $val['shokumu']; $item["ord"] = $i++; Syokureki::addData($item); // if (!$_SESSION["LOGIN"]["kyushoku_id"]) { // 履歴書用 $item["oubo_id"] = "0"; Syokureki::addData($item); // } } } } // 応募数カウント $sql = "update kyujin set oubo_count=oubo_count+1 where kyujin_id=" . $id; $inst = DBConnection::getConnection($DB_URI); $ret = $inst->db_exec($sql); // 応募課金情報保存 kakin(KAKIN_OUBO, $kyujin["company_id"], $oubo_id, $_SESSION["LOGIN"]["kyushoku_id"]); // 応募メール（求職者向け） $info = array("setup" => $setup, "form" => $form, "kyujin" => disp_kyujin($kyujin)); if ($form["email"]) { template_mail($form["email"], "oubo_user_subject", "oubo_user_body", $info, "admin_mail_noreplay"); } $user = Kyushoku::getData($kyushoku_id); if ($user["mobile_mail"]) { template_mail($user["mobile_mail"], "oubo_user_subject", "oubo_user_body", $info, "admin_mail_noreplay"); } // 応募メール（会社向け） $company = Company::getData($kyujin["company_id"]); $info = array("setup" => $setup, "form" => $form, "kyujin" => disp_kyujin($kyujin), "company" => $company); template_mail($company["email"], "oubo_company_subject", "oubo_company_body", $info, "admin_mail_noreplay"); // この求人に関連付いているアカウントの全メールへ送信 $db = new CompanyAccount(); $db->search[] = array("field" => "company_id", "value" => $company["company_id"], "cond" => "="); $db->search[] = array("field" => "CONCAT(',',kanren,',')", "value" => "%,".$id.",%", "cond" => "like"); $account_list = $db->getList(); if ($account_list) { foreach($account_list as $val) { if ($val["mail1"]) { template_mail($val["mail1"], "oubo_company_subject", "oubo_company_body", $info, "admin_mail_noreplay"); } if ($val["mail2"]) { template_mail($val["mail2"], "oubo_company_subject", "oubo_company_body", $info, ""); } if ($val["mail3"]) { template_mail($val["mail3"], "oubo_company_subject", "oubo_company_body", $info, ""); } if ($val["mail4"]) { template_mail($val["mail4"], "oubo_company_subject", "oubo_company_body", $info, ""); } if ($val["mail5"]) { template_mail($val["mail5"], "oubo_company_subject", "oubo_company_body", $info, ""); } } } // $data["complete"] = "1"; // 終了 // ブックマーク済みチェック if ($_SESSION["LOGIN"]["kyushoku_id"]) { unset($cond); $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $cond["kyujin_id"] = $id; $ret = Bookmark::findData($cond); if ($ret) { foreach ($ret as $val) { Bookmark::deleteData($val["seq"]); } } } } } // $form = $_SESSION["detail1"]; $data["form"] = disp_oubo($form); // $idx = get_info_idx(INFO_SKILL); $skill_rank = get_info_idx(INFO_SKILLRANK); foreach ($form["skill"] as $key => $val) { // $data["skill"][] = $idx[$key] . "($val)"; $data["skill"][] = $idx[$key] . " " . $skill_rank[$val]; } $idx = get_info_idx(INFO_SHIKAKU); if (is_array($form["shikaku"])) { foreach ($form["shikaku"] as $key => $val) { $data["shikaku"][] = $idx[$val]; } } // $syokusyu_idx = get_info_idx(INFO_RIREKI); $koyou_idx = get_info_idx(INFO_RIREKIKOYOU); $num = 0; foreach ($_SESSION["detail2"]["syoku"] as $val) { if ($val['company']) { $val["num"] = $num + 1; $val["syokusyu"] = $syokusyu_idx[$val["syokusyu"]]; $val["koyou"] = $koyou_idx[$val["koyou"]]; $data["syoku"][] = $val; } $num++; } if ($_SESSION["detail2"]["pr"]) { $data["pr"] = $_SESSION["detail2"]["pr"]; } // 完了の場合はセッション情報削除 if ($data["complete"]) { unset($_SESSION["detail1"]); unset($_SESSION["detail2"]); } // // 利用規約 $info = get_setup(INFO_KIYAKU1); $data["kiyaku1"] = $info["kiyaku1"]; $ap->view("detail-form-confirm.html", $data); exit; } //-------------------------------------------- // 求人詳細画面 if ($act == "detail") { unset($_SESSION["detail1"]); $id = $_REQUEST["id"]; if ($id) { $item = Kyujin::getData($id); if (!$item || $item["del_flag"]) { // 削除済 $data["delete"] = "1"; $ap->view("detail.html", $data); exit; } if ($item["status"] == "2") { $data["valid"] = "1"; } $data["item"] = disp_kyujin($item); if ($data["item"]["movietag"]) $data["item"]["movietag"] = html_entity_decode($data["item"]["movietag"]); // 閲覧数カウント $sql = "update kyujin set view_count=view_count+1 where kyujin_id=".$id; $inst = DBConnection::getConnection($DB_URI); $ret = $inst->db_exec($sql); // 履歴保存 $flag = 1; if ($_SESSION["LOGIN"]["kyushoku_id"]) { /* unset($cond); $cond["kyujin_id"] = $id; $cond["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; $ret = KyujinRireki::findData($cond); */ $db = new KyujinRireki(); $db->search[] = array("field" => "kyujin_id", "value" => $id, "cond" => "="); $db->search[] = array("field" => "kyushoku_id", "value" => $_SESSION["LOGIN"]["kyushoku_id"], "cond" => "="); $db->search[] = array("expression" => "reg_date >= date_sub(now(), interval 1 DAY)"); //1日以内 $db->order[] = array("field" => "reg_date", "desc" => "1"); $ret = $db->getList(); if ($ret) { // (1日以内に)すでに閲覧してる場合は、閲覧日を最新に。1日以上経過している場合は新たに履歴に追加 $upd["reg_date"] = "now()"; KyujinRireki::updateData($ret[0]["seq"], $upd); $flag = 0; } } if ($flag) { unset($item); $item["kyujin_id"] = $id; $item["company_id"] = $data["item"]["company_id"]; $item["hellowork_flg"] = $data["item"]["hellowork_flg"]; // ハローワークフラグ保存 if ($_SESSION["LOGIN"]["kyushoku_id"]) { $item["kyushoku_id"] = $_SESSION["LOGIN"]["kyushoku_id"]; } KyujinRireki::addData($item); // 求人情報内のアクセス数も更新 $db = new KyujinRireki(); $db->search[] = array("field" => "kyujin_id", "value" => $id, "cond" => "="); $count = $db->getCount(); unset($upd); $upd["access_count"] = $count; Kyujin::updateData($id, $upd); } // $ap->view("detail.html", $data); exit; } } if ($act == "detail-map") { $id = $_REQUEST["id"]; if ($id) { $item = Kyujin::getData($id); // 150804 地図表示を勤務地に変更 /* if (!$item['mensetsu_address']) { $item['mensetsu_address'] = $item['kinmu_address']; } */ if ($item["status"] == "2") { $data["valid"] = "1"; } $data["item"] = disp_kyujin($item); // // 150804 地図表示を勤務地に変更 $map_tmp_02 = $data["item"]["kinmu"] . $data["item"]["kinmu_city"] . $data["item"]["kinmu_address"]; // $data["gmap_key"] = GMAP_KEY; //141205 緯度経度による地図表示方法変更 //if ($item['map']) { if (substr($item['map'], 0, 1) != "," && $item['map']) { $map_tmp = explode(",", $item['map']); //150222 if ($map_tmp[0] && $map_tmp[1]) { $data['map_lat'] = $map_tmp[0]; $data['map_lon'] = $map_tmp[1]; } else { // 150804 地図表示を勤務地に変更 //$map_str_key = explode(" ",$item['mensetsu_address']); $map_str_key = explode(" ",$map_tmp_02); // if(strlen($map_str_key[1]) > 0){ //$map_str_key[1] = "(".$map_str_key[1].")"; $map_str_key[1] = ""; } // $data['map_str'] = $map_str_key[0].$map_str_key[1]; //関数の追加 $latlng = GetGeocode($map_str_key[0].$map_str_key[1]); if ($latlng) { $data['map_url'] = $latlng[0]; $data['map_lat'] = $latlng[1]; $data['map_lon'] = $latlng[2]; } } } else { // 全角スペースを半角スペースに変換 $str = mb_convert_kana($map_tmp_02,"s","UTF-8"); // $map_str_key = explode(" ",$str); //150908 空欄の配列は削除 foreach($map_str_key as $key => $val) { if (!$val) { unset($map_str_key[$key]); } } // //150908 住所データ結合 /* foreach($map_str_key as $key => $val) { $map_str_key_tmp[0] .= $val; } */ $map_str_key_tmp[0] = implode("%20", $map_str_key); // $data['map_str'] = $map_str_key[0].$map_str_key[1]; //関数の追加 //$latlng = GetGeocode($map_str_key[0].$map_str_key[1]); $latlng = GetGeocode($map_str_key_tmp[0]); if ($latlng) { $data['map_url'] = $latlng[0]; $data['map_lat'] = $latlng[1]; $data['map_lon'] = $latlng[2]; } } /* if ($item['mensetsu_lat'] && $item['mensetsu_lon']) { $data['map_lat'] = $item['mensetsu_lat']; $data['map_lon'] = $item['mensetsu_lon']; } else { $map_str_key = explode(" ",$item['mensetsu_address']); if(strlen($map_str_key[1]) > 0){ //$map_str_key[1] = "(".$map_str_key[1].")"; $map_str_key[1] = ""; } // $data['map_str'] = $map_str_key[0].$map_str_key[1]; //関数の追加 $latlng = GetGeocode ($map_str_key[0].$map_str_key[1]); if ($latlng) { $data['map_url'] = $latlng[0]; $data['map_lat'] = $latlng[1]; $data['map_lon'] = $latlng[2]; } } */ $ap->view("detail-map.html", $data); exit; } if ($_REQUEST["preview"]) { // 作成中のプレビュー $data["preview"] = "1"; $item = $_SESSION["make-confirm"]; if (!$item['mensetsu_address']) { $item['mensetsu_address'] = $item['kinmu_address']; } $data["item"] = disp_kyujin($item); $data["gmap_key"] = GMAP_KEY; $ap->view("detail-map.html", $data); exit; } } if ($act == "detail-map2") { $id = $_REQUEST["id"]; if ($id) { $item = Kyujin::getData($id); // 面接地が勤務地と同じだった場合 if ( $item["mensetsu"] == 1 ) { if ($item['map']) { $map_code = $item['map']; } } if (!$item['mensetsu_address']) { $item['mensetsu_address'] = $item['kinmu_address']; } if ($item["status"] == "2") { $data["valid"] = "1"; } $data["item"] = disp_kyujin($item); // $data["gmap_key"] = GMAP_KEY; //141205 緯度経度による地図表示方法変更 //if ($map_code) { if (substr($map_code, 0, 1) != "," && $map_code) { $map_tmp = explode(",", $map_code); if ($map_tmp[0] && $map_tmp[1]) { $data['map_lat'] = $map_tmp[0]; $data['map_lon'] = $map_tmp[1]; } else { $map_str_key = explode(" ",$item['mensetsu_address']); if(strlen($map_str_key[1]) > 0){ $map_str_key[1] = ""; } $latlng = GetGeocode($map_str_key[0].$map_str_key[1]); if ($latlng) { $data['map_url'] = $latlng[0]; $data['map_lat'] = $latlng[1]; $data['map_lon'] = $latlng[2]; } } } else { // 全角スペースを半角スペースに変換 $str = mb_convert_kana($item['mensetsu_address'],"s","UTF-8"); // //$map_str_key = explode(" ",$item['mensetsu_address']); $map_str_key = explode(" ",$str); //150908 空欄の配列は削除 foreach($map_str_key as $key => $val) { if (!$val) { unset($map_str_key[$key]); } } // $map_str_key_tmp[0] = implode("%20", $map_str_key); /* if(strlen($map_str_key[1]) > 0){ $map_str_key[1] = ""; } */ //$latlng = GetGeocode($map_str_key[0].$map_str_key[1]); $latlng = GetGeocode($map_str_key_tmp[0]); if ($latlng) { $data['map_url'] = $latlng[0]; $data['map_lat'] = $latlng[1]; $data['map_lon'] = $latlng[2]; } } /* $map_str_key = explode(" ",$item['mensetsu_address']); if(strlen($map_str_key[1]) > 0){ //$map_str_key[1] = "(".$map_str_key[1].")"; $map_str_key[1] = ""; } // $data['map_str'] = $map_str_key[0].$map_str_key[1]; //関数の追加 $latlng = GetGeocode($map_str_key[0].$map_str_key[1]); if ($latlng) { $data['map_url'] = $latlng[0]; $data['map_lat'] = $latlng[1]; $data['map_lon'] = $latlng[2]; } */ $ap->view("detail-map2.html", $data); exit; } if ($_REQUEST["preview"]) { // 作成中のプレビュー $data["preview"] = "1"; $item = $_SESSION["make-confirm"]; if (!$item['mensetsu_address']) { $item['mensetsu_address'] = $item['kinmu_address']; } $data["item"] = disp_kyujin($item); $data["gmap_key"] = GMAP_KEY; $ap->view("detail-map.html", $data); exit; } } //-------------------------------------------- // 新規登録 $regist_check = array( // フォーム項目名 文字種 最大文字数 必須 表示名称 array("name", "*", "", true, "氏名"), array("kana", "*", "", true, "フリガナ"), array("email", "MAIL", "", true, "メールアドレス"), array("email2", "MAIL", "", true, "メールアドレス確認"), array("passwd", "AN", "", true, "パスワード"), array("passwd2", "AN", "", true, "パスワード確認"), array("mode", "*", "", true, "モード"), ); if ($act == "register") { $form = FormCheck::get_form($regist_check, $_REQUEST); if ($form && $_SESSION["form"]) { $msg = FormCheck::check($form, $regist_check); // メールアドレス重複 if ($form["email"] && $form["email2"]) { if ($form["email"] != $form["email2"]) { $msg["email"] = "メールアドレスが一致していません"; } else { unset($cond); $cond["email"] = $form["email"]; $ret = Kyushoku::findData($cond); if ($ret) { $msg["email"] = "このメールアドレスは登録済みのためご利用いただけません"; } } } if ($msg["passwd"]) { } else if ($form["passwd"] && $form["passwd2"]) { if ($form["passwd"] != $form["passwd2"]) { $msg["passwd"] = "パスワードが一致していません"; } else { if ((strlen($form["passwd"]) < 6)||(strlen($form["passwd"]) > 20)) { $msg["passwd"] = "半角英数字(0～9、A～Z)、6～20文字で入力してください。"; } } } $data["form"] = $form; if ($msg) { foreach ($msg as $key => $v) { $data["error"][$key] = $v; $data["message"][] = $v; } } else { unset($_SESSION["form"]); // 登録処理 unset($item); $item["name"] = $form["name"]; $item["kana"] = $form["kana"]; $item["email"] = $form["email"]; $item["passwd"] = Encode($form["passwd"]); //agent if (!empty($_COOKIE[banner_landing_id])) { $banner = Banner_landing::getData($_COOKIE[banner_landing_id]); $item["agent_id"] = $banner[agent_id]; } $id = Kyushoku::addData($item); if ($id) { // 登録メール送信 $info = array("setup" => $setup, "form" => $form); template_mail($form["email"], "regist_subject", "regist_body", $info, "admin_mail_noreplay"); // //agent if (!empty($_COOKIE[banner_landing_id])) { unset($item); $item[agent_id] = $banner[agent_id]; $item[banner_type] = $banner[banner_type]; $item[id] = $id; $item[banner_landing_id] = $_COOKIE[banner_landing_id]; banner_conversion::addData($item); } $ap->view("register-thankyou.html", $data); exit; } } } $_SESSION["form"] = "register"; // 利用規約 $info = get_setup(INFO_KIYAKU1); $data["kiyaku1"] = $info["kiyaku1"]; $ap->view("register.html", $data); exit; } if ($act == "register-thankyou") { header("location: ./"); exit; } //-------------------------------------------- // スカウト if ($act == "scout") { $ap->view("scout.html", $data); exit; } /* //-------------------------------------------- // 新着求人一覧 if ($act == "new") { $page = $_REQUEST["page"]; if (!$page) { $page = 0; } // $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 $db->search[] = array("expression" => "kyujin_start >= date(date_sub(now(), interval 14 day))"); // 2週間以内 $db->order[] = array("field" => "kyujin_start", "desc" => "1"); $db->page = $page; $db->limit = 20; $count = $db->getCount(); $pages = intval(($count + $db->limit - 1) / $db->limit); if ($pages > 1) { $data["pager"] = page_index2($page, $pages); } $list = $db->getList(); if ($list) { $data["total"] = $count; // 総件数 $data["list_start"] = $page * 20 + 1; $data["list_end"] = $page * 20 + count($list); foreach ($list as $key => $val) { // 内容200字まで // 企業情報 // 新着 // 更新日 $val["reg_date"] = date_format2($val["reg_date"]); $list[$key] = disp_kyujin($val); } $data["list"] = $list; } $ap->view("new.html", $data); exit; } */ //-------------------------------------------- // 検索/RSS出力 if (($act == "search")||($act == "get_rss") || ($act == "new")) { ini_set("max_execution_time", 0); // 170926 検索条件クリア unset($_SESSION["serach_tmp"]); $page = $_REQUEST["page"]; // 検索条件を引き継いで来た場合 if ($_REQUEST["condition"]) { $data["condition"] = $_REQUEST["condition"]; } // 新着ページの場合 if ($act == "new") { $data["new"] = 1; } // if (!$page) { $page = "0"; } if ($act == "get_rss") { $no = $_REQUEST["no"]; $val = Search::getData($no); //$keyword = $val["keyword"]; $keyword = explode(" ", $val['keyword']); $area = explode(",", $val['area']); $city = explode(",", $val['city']); $syokusyu = explode(",", $val['syokusyu']); //$gyomu = explode(",", $val['gyomu']); //141209 $category01 = explode(",", $val['category01']); $category02 = explode(",", $val['category02']); $category03 = explode(",", $val['category03']); $category04 = explode(",", $val['category04']); $category05 = explode(",", $val['category05']); $category06 = explode(",", $val['category06']); $category07 = explode(",", $val['category07']); $category08 = explode(",", $val['category08']); $category09 = explode(",", $val['category09']); $category10 = explode(",", $val['category10']); // if ($val['ensen']) { $ensen = $val['ensen']; } if ($val['eki']) { $eki = explode(",", $val['eki']); } //$eki = $val['eki']; $koyou = explode(",", $val['koyou']); list($kyuyo, $kyuyo_type) = explode(",", $val['kyuyo']); $new = $val['new_flag']; $beginer = $val['beginer']; //$gyomu = sel_normalize($gyomu); //141209 $category01 = sel_normalize($category01); $category02 = sel_normalize($category02); $category03 = sel_normalize($category03); $category04 = sel_normalize($category04); $category05 = sel_normalize($category05); $category06 = sel_normalize($category06); $category07 = sel_normalize($category07); $category08 = sel_normalize($category08); $category09 = sel_normalize($category09); $category10 = sel_normalize($category10); // $area = sel_normalize($area); $city = sel_normalize($city); $syokusyu = sel_normalize($syokusyu); $koyou = sel_normalize($koyou); } else { // //$gyomu = sel_normalize($_REQUEST["gyomu"]); // $category01 = sel_normalize($_REQUEST["category01"]); $category02 = sel_normalize($_REQUEST["category02"]); $category03 = sel_normalize($_REQUEST["category03"]); $category04 = sel_normalize($_REQUEST["category04"]); $category05 = sel_normalize($_REQUEST["category05"]); $category06 = sel_normalize($_REQUEST["category06"]); $category07 = sel_normalize($_REQUEST["category07"]); $category08 = sel_normalize($_REQUEST["category08"]); $category09 = sel_normalize($_REQUEST["category09"]); $category10 = sel_normalize($_REQUEST["category10"]); // $area = sel_normalize($_REQUEST['area']); $city = sel_normalize($_REQUEST['city']); $syokusyu = sel_normalize($_REQUEST['syokusyu']); $koyou = sel_normalize($_REQUEST['koyou']); // //$keyword = $_REQUEST["keyword"]; if (strpos($_REQUEST["keyword"], " ") === FALSE) { $keyword = htmlspecialchars($_REQUEST["keyword"]); } else { $keyword = explode(" ", htmlspecialchars($_REQUEST["keyword"])); } // $kyuyo_type = $_REQUEST["kyuyo_type"]; $kyuyo = $_REQUEST["kyuyo"]; $ensen = $_REQUEST["ensen"]; $eki = sel_normalize($_REQUEST['eki']); //$eki = $_REQUEST["eki"]; // 新着の場合 if ($act == "new") { $new = 1; } else { $new = $_REQUEST['new']; } // 並び順 if ($_REQUEST["ord"]) { $ord = $_REQUEST["ord"]; } else { $ord = 1; } $beginer = $_REQUEST['beginer']; $company_id = $_REQUEST['company_id']; $special_id = $_REQUEST['special_id']; if ($_REQUEST["pref"]) { // 地図から $area = array($_REQUEST["pref"]); } } // if ($_REQUEST["w"]) { $data["wc"] = "block"; // 詳細検索条件を開く $data["wo"] = "none"; // 詳細検索条件を開く /* } else { $data["wc"] = "none"; // 詳細検索条件を開く $data["wo"] = "block"; // 詳細検索条件を開く } */ // 検索実行 // $search = ""; // 検索条件表示 $search = array(); // php7系対応 $search2 = ""; // 検索条件表示2（メタ・title用） $search3 = array(); // 検索条件表示3（メタ・keyword,description用） $db = new Kyujin(); // $db->order[] = array("field" => "plan", "desc" => "1"); //プラン（0：スタンダード　1:プレミアム） // $db->order[] = array("field" => "ord", "asc" => "1"); //並び順（数値が小さい順） // $db->order[] = array("field" => "reg_date", "desc" => "1"); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // if ($company_id) { $db->search[] = array("field" => "company_id", "value" => $company_id, "cond" => "="); // 会社 $data["company_id"] = $company_id; $tmp = Company::getData($company_id); $search[] = "【企業】 " . $tmp["company_name"] ." の求人一覧"; $search2 .= $tmp["company_name"]; $search3[] = $tmp["company_name"]; } if ($special_id) { $db->search[] = array("field" => "CONCAT(',',special,',')", "value" => "%,".$special_id.",%", "cond" => "like"); $data["special_id"] = $special_id; unset($tmp); $tmp = Special::getData($special_id); $search[] = "【特集】 " . $tmp["name"] ." の求人一覧"; $search2 .= $tmp["name"]; $search3[] = $tmp["name"]; $data["special_cover_image"] = $tmp["image"]; //画像 $data["special_name"] = $tmp["name"]; //特集名 $data["special_text"] = $tmp["text"]; //特集名 } /* if ($gyomu) { // $db->search[] = array("field" => "gyomu", "value" => $gyomu, "cond" => "in"); $c_gyomu[] = array("field" => "name", "value" => "gyomu", "cond" => "="); $c_gyomu[] = array("field" => "value", "value" => $gyomu, "cond" => "in"); $db->search[] = array("field" => "kyujin_id", "cond" => "in", "select" => array("table" => "kyujin_profile", "where" => $c_gyomu, "fields" => array("distinct kyujin_id"))); $tmp = array(); $idx = get_info_idx(INFO_GYOMU); foreach ($gyomu as $val) { $tmp[] = $idx[$val]; } if ($search) { $search[] = "  "; } $search[] = join("・", $tmp); } */ if ($area) { if (is_array($area)) { foreach($area as $val) { $c_area[] = array("field" => "kinmu", "value" => $val, "cond" => "=", "relation" => "or"); } $db->search[] = array("nest" => $c_area); } else { $db->search[] = array("field" => "kinmu", "value" => $area, "cond" => "="); } $tmp = array(); // $idx = get_info_idx(INFO_AREA); foreach ($area as $val) { $tmp[] = $preficture_list[$val]; } if ($city) { $search[] = "【都道府県】 " . join("・", $tmp); $search2 .= join("・", $tmp); } else { $search[] = "【都道府県】 " . join("・", $tmp) ."　"; $search2 .= join("・", $tmp) ."の"; } $search3[] = join(",", $tmp); $seo_pref = $tmp; $data["area"] = $area; // 170926 選択都道府県名,code（単一前提） $data["area_name"] = $preficture_list[$area[0]]; $data["area_cd"] = $area[0]; } if ($city) { $db->search[] = array("field" => "kinmu_city", "value" => $city, "cond" => "in"); $tmp = array(); // $idx = get_info_idx(INFO_AREA); foreach ($city as $val) { $tmp[] = get_city_name($val); } if ($area) { $search[] = "【市区町村】 " . join("・", $tmp); } else { $search[] = "【市区町村】 " . join("・", $tmp); } $search2 .= join("・", $tmp) ."の"; $search3[] = join(",", $tmp); $data["city"] = join(",", $city); $data["city_list"] = $city; } if ($syokusyu) { // 170913 TOPページmultipleselectにて「全選択」を行うと'on'という値が送信される事の対策 $syokusyu = array_diff($syokusyu, array('on')); // $db->search[] = array("field" => "syokusyu", "value" => $syokusyu, "cond" => "in"); $tmp = array(); $idx = get_info_idx(INFO_SHOKUSYU); foreach ($syokusyu as $val) { $tmp[] = $idx[$val]; } $search[] = "【職種】 " . join("・", $tmp); $search2 .= "職種「".join("・", $tmp)."」、"; $search3[] = join(",", $tmp); } if ($koyou) { // 170913 TOPページmultipleselectにて「全選択」を行うと'on'という値が送信される事の対策 $koyou = array_diff($koyou, array('on')); // $db->search[] = array("field" => "koyou", "value" => $koyou, "cond" => "in"); $tmp = array(); $idx = get_info_idx(INFO_KOYOU); foreach ($koyou as $val) { $tmp[] = $idx[$val]; } $search[] = "【雇用形態】 " . join("・", $tmp); $search2 .= "雇用形態「".join("・", $tmp)."」、"; $search3[] = join(",", $tmp); } if ($category01) { // 170913 TOPページmultipleselectにて「全選択」を行うと'on'という値が送信される事の対策 $category01 = array_diff($category01, array('on')); // foreach($category01 as $val) { $c_cate[] = array("field" => "CONCAT(',',category01,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category01,1); $search[] = $category_name; $search2_catetmp[0] = disp_category2($category01,1); } if ($category02) { foreach($category02 as $val) { $c_cate[] = array("field" => "CONCAT(',',category02,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category02,2); $search[] = $category_name; $search2_catetmp[1] = disp_category2($category02,2); } if ($category03) { foreach($category03 as $val) { $c_cate[] = array("field" => "CONCAT(',',category03,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category03,3); $search[] = $category_name; $search2_catetmp[2] = disp_category2($category03,3); } if ($category04) { foreach($category04 as $val) { $c_cate[] = array("field" => "CONCAT(',',category04,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category04,4); $search[] = $category_name; $search2_catetmp[3] = disp_category2($category04,4); } if ($category05) { foreach($category05 as $val) { $c_cate[] = array("field" => "CONCAT(',',category05,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category05,5); $search[] = $category_name; $search2_catetmp[4] = disp_category2($category05,5); } if ($category06) { foreach($category06 as $val) { $c_cate[] = array("field" => "CONCAT(',',category06,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category06,6); $search[] = $category_name; $search2_catetmp[5] = disp_category2($category06,6); } if ($category07) { foreach($category07 as $val) { $c_cate[] = array("field" => "CONCAT(',',category07,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category07,7); $search[] = $category_name; $search2_catetmp[6] = disp_category2($category07,7); } if ($category08) { foreach($category08 as $val) { $c_cate[] = array("field" => "CONCAT(',',category08,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category08,8); $search[] = $category_name; $search2_catetmp[7] = disp_category2($category08,8); } if ($category09) { foreach($category09 as $val) { $c_cate[] = array("field" => "CONCAT(',',category09,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category09,9); $search[] = $category_name; $search2_catetmp[8] = disp_category2($category09,9); } if ($category10) { foreach($category10 as $val) { $c_cate[] = array("field" => "CONCAT(',',category10,',')", "value" => "%,".$val.",%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_cate); $category_name = disp_category($category10,10); $search[] = $category_name; $search2_catetmp[9] = disp_category2($category10,10); } if($category01 || $category02 || $category03 || $category04 || $category05 || $category06 || $category07 || $category08 || $category09 || $category10) { $search2_catetmp2 = join("、", $search2_catetmp); $search2 .= $search2_catetmp2 . "を含む"; $search3[] = join(",", $search2_catetmp); } if ($kyuyo_type && $kyuyo) { $db->search[] = array("field" => "kyuyo", "value" => $kyuyo_type, "cond" => "="); unset($kyuyo_tmp); $kyuyo_tmp[] = array("field" => "kyuyo_max", "value" => $kyuyo, "cond" => ">=", "relation" => "or"); $kyuyo_tmp[] = array("field" => "kyuyo_min", "value" => $kyuyo, "cond" => ">=", "relation" => "or"); $db->search[] = array("nest" => $kyuyo_tmp); // $db->search[] = array("field" => "kyuyo_min", "value" => $kyuyo, "cond" => "<="); // $db->search[] = array("field" => "kyuyo_max", "value" => $kyuyo, "cond" => ">="); $idx = get_info_idx(INFO_KYUYO); $search[] = "【給与】 " . $idx[$kyuyo_type] . " " . $kyuyo . "円以上"; $search2 .= $idx[$kyuyo_type] . " " . $kyuyo . "円以上の"; $search3[] = $idx[$kyuyo_type] . " " . $kyuyo . "円以上"; // $db->search[] = array("field" => "", "value" => "", "cond" => ""); $data["kyuyo"] = $kyuyo; } if ($keyword) { if (is_array($keyword)) { $keyword_tmp = $keyword; $data["keyword"] = implode(" ", $keyword); } else { $keyword_tmp[] = $keyword; $data["keyword"] = $keyword; } foreach($keyword_tmp as $val) { $where = array(); $where[] = array("field" => "title", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $where[] = array("field" => "naiyou", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $where[] = array("field" => "taisyo", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $where[] = array("field" => "c_name", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "pr1", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "pr2", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "kyuyo_info", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "kinmu_time", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "taiguu", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "kyujitsu", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "access_info", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image1_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image2_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image3_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image4_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image5_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image6_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image7_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "image8_text", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "message_title", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $where[] = array("field" => "message", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // //職種 // $where1[] = array("field" => "title", "value" => "%".$val."%", "cond" => "like"); // $where1[] = array("field" => "kind", "value" => INFO_SHOKUSYU, "cond" => "="); // $where[] = array("field" => "syokusyu", "cond" => "in", // "select" => array("table" => "info", "where" => $where1, "fields" => array("distinct info_id")), "relation" => "or"); // //雇用形態 // $where2[] = array("field" => "title", "value" => "%".$val."%", "cond" => "like"); // $where2[] = array("field" => "kind", "value" => INFO_KOYOU, "cond" => "="); // $where[] = array("field" => "koyou", "cond" => "in", // "select" => array("table" => "info", "where" => $where2, "fields" => array("distinct info_id")), "relation" => "or"); // //こだわり // $where[] = array("cond" => "find_in_set", "opt" => "(SELECT DISTINCT seq FROM category WHERE name LIKE '%".$val."%'), category01", "relation" => "or"); // //企業名 // $where3[] = array("field" => "company_name", "value" => "%".$val."%", "cond" => "like"); // $where[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where3, "fields" => array("distinct company_id")), "relation" => "or"); $db->search[] = array("nest" => $where); // // //職種・こだわり・雇用形態・企業名 // $where[] = array("field" => "word", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); // $db->search[] = array("nest" => $where); // 職種・こだわり・雇用形態・企業名 // $db->search[] = array("field" => "word", "value" => "%".$val."%", "cond" => "like"); // // 171019 全文検索 // include_once("ngram_converter.php"); // $ngram = new NgramConverter(); // if ($val) { // $db->search[] = array("expression" => $ngram->make_match_sql($val, 'word', 4)); //// $db->search[] = array("expression" => $ngram->make_match_sql(mb_eregi_replace("[　|《|》|（|）|\[|\]|＜|＞|\||｜|「|」|…|、|・|。|＃|！|？|：|［| ］]", "", $val), 'word', 4)); // } } //$data["keyword"] = implode(" ", $keyword); $search[] = "【キーワード】 " . $data["keyword"]; $search2 .= "キーワード「" . $data["keyword"] . "」を含む"; $search3[] = $data["keyword"]; } /* if ($city) { $db->search[] = array("field" => "kinmu_address", "value" => "%".$city."%", "cond" => "like"); $data["city"] = $city; if ($search) { $search[] = "  "; } $search[] = "勤務市区町村：" . $city; } */ /////////////// 20120313 酒井SQL分の修正 /* if ($ensen) { //$cond_ensen[] = array("field" => "ensen1", "value" => $ensen, "cond" => "=", "relation" => "or"); //$cond_ensen[] = array("field" => "ensen2", "value" => $ensen, "cond" => "=", "relation" => "or"); $cond_ensen[] = array("field" => "CONCAT( ensen1, eki1 )", "value" => $ensen.$eki."%", "cond" => "like", "relation" => "or"); $cond_ensen[] = array("field" => "CONCAT( ensen2, eki2 )", "value" => $ensen.$eki."%", "cond" => "like", "relation" => "or"); $db->search[] = array("nest" => $cond_ensen); $search[] = "【沿線】 " . get_ensen($ensen) ."
"; } */ ////////////// 20120313 酒井　上記ensenに統合 if ($ensen) { $cond_ensen[] = array("field" => "ensen1", "value" => $ensen, "cond" => "=", "relation" => "or"); $cond_ensen[] = array("field" => "ensen2", "value" => $ensen, "cond" => "=", "relation" => "or"); $db->search[] = array("nest" => $cond_ensen); if ($eki) { //$search[] = "【沿線】 " . get_ensen($ensen) ."／"; $search2 .= get_ensen($ensen) ."沿い、"; } else { $search[] = "【沿線】 " . get_ensen($ensen); $search2 .= get_ensen($ensen) ."沿いの"; } $search3[] = get_ensen($ensen); $seo_ensen = get_ensen($ensen); } // 141215 駅複数選択可 if ($eki) { $eki_tmp = ""; if(is_array($eki)) { foreach($eki as $val) { $cond_eki[] = array("field" => "eki1", "value" => $val, "cond" => "=", "relation" => "or"); $cond_eki[] = array("field" => "eki2", "value" => $val, "cond" => "=", "relation" => "or"); $eki_tmp .= get_eki($ensen,$val) . "駅・"; } } else { $cond_eki[] = array("field" => "eki1", "value" => $eki, "cond" => "=", "relation" => "or"); $cond_eki[] = array("field" => "eki2", "value" => $eki, "cond" => "=", "relation" => "or"); $eki_tmp .= get_eki($ensen,$eki) . "駅・"; } $db->search[] = array("nest" => $cond_eki); $eki_tmp = mb_substr($eki_tmp, 0, -1, "UTF-8"); //$search[] = "【沿線】 " . $eki_tmp; if ($ensen) { $search[] = "【沿線】 " . get_ensen($ensen) ."／".$eki_tmp; } else { $search[] = "【駅】 " . $eki_tmp; } $search2 .= $eki_tmp ."周辺の"; $search3[] = $eki_tmp; } if ($new) { //$db->search[] = array("field" => "kyujin_start", "value" => "date(date_sub(now(), interval 14 day))", "cond" => ">="); // $db->search[] = array("expression" => "kyujin_start >= date(date_sub(now(), interval 14 day))"); $db->search[] = array("expression" => "up_date >= date(date_sub(now(), interval 14 day))"); $search[] = "【新着】 "; if($beginer) { $search2 .= "新着、"; } else { $search2 .= "新着の"; } $search3[] = "新着"; $data["new1"] = "checked"; } if ($beginer) { //$db->search[] = array("field" => "beginer", "value" => $beginer, "cond" => "="); $db->search[] = array("field" => "CONCAT(',',category01,',')", "value" => "%34%", "cond" => "like"); $search[] = "【未経験歓迎】 "; if($new) { $search2 .= "未経験歓迎の"; } else { $search2 .= "未経験歓迎、"; } $data["beginer1"] = "checked"; } if ($act == "new") { $serach_tmp = $db->search; $_SESSION["serach_tmp"] = $db->search; $db->order[] = array("field" => "up_date", "desc" => "1"); } else { // 170419 ハローワーク求人は下位表示------------- // 1.ハローワーク以外の求人を取得 if ($ord) { if ($ord == 1) { //標準:おすすめ順(アクセス数少ない順＞ランダム) //$db->order[] = array("field" => "kyujin_point", "desc" => "1"); $db->order[] = array("field" => "access_count", "asc" => "1"); $db->order[] = array("rand" => "1"); } else if ($ord == 2) { //新着・更新順 $db->order[] = array("field" => "up_date", "desc" => "1"); } else if ($ord == 3) { //時給順 $db->search[] = array("field" => "kyuyo", "value" => 60, "cond" => "="); $db->order[] = array("field" => "kyuyo_max", "desc" => "1"); $db->order[] = array("field" => "kyuyo_min", "desc" => "1"); $db->order[] = array("rand" => "1"); } else if ($ord == 4) { //日給順 $db->search[] = array("field" => "kyuyo", "value" => 178, "cond" => "="); $db->order[] = array("field" => "kyuyo_max", "desc" => "1"); $db->order[] = array("field" => "kyuyo_min", "desc" => "1"); $db->order[] = array("rand" => "1"); } else if ($ord == 5) { //月給順 $db->search[] = array("field" => "kyuyo", "value" => 98, "cond" => "="); $db->order[] = array("field" => "kyuyo_max", "desc" => "1"); $db->order[] = array("field" => "kyuyo_min", "desc" => "1"); $db->order[] = array("rand" => "1"); } else if ($ord == 6) { //年俸順 $db->search[] = array("field" => "kyuyo", "value" => 99, "cond" => "="); $db->order[] = array("field" => "kyuyo_max", "desc" => "1"); $db->order[] = array("field" => "kyuyo_min", "desc" => "1"); $db->order[] = array("rand" => "1"); } else if ($ord == 7) { //人気順(アクセス数多い順＞ランダム) $db->order[] = array("field" => "access_count", "desc" => "1"); //アクセス多い順 $db->order[] = array("rand" => "1"); } $data["ord"] = $ord; } $serach_tmp = $db->search; $_SESSION["serach_tmp"] = $db->search; $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 $fields = array("0" => "kyujin_id" ); $list_tmp1 = $db->getList($fields); if ($list_tmp1) { foreach($list_tmp1 as $val) { $field_tmp[] = $val["kyujin_id"]; } } // 2.ハローワーク求人を取得 $db = new Kyujin(); $db->search = $serach_tmp; $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "="); // ハローワーク $db->order[] = array("rand" => "1"); $fields = array("0" => "kyujin_id" ); $list_tmp2 = $db->getList($fields); if ($list_tmp2) { foreach($list_tmp2 as $val) { $field_tmp[] = $val["kyujin_id"]; } } if ($field_tmp) { $field_tmp2 = implode(",",$field_tmp); } // 結合 $db = new Kyujin(); $db->search = $serach_tmp; if ($field_tmp2) { $db->order[] = array("field" => $field_tmp2, "field_sort" => "1", "key" => "kyujin_id"); } // ----------------------------------------- } $db->page = $page; $db->limit = 20; $count = $db->getCount(); $pages = intval(($count + $db->limit - 1) / $db->limit); if ($pages > 1) { $data["pager"] = page_index2($page, $pages); } // $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" , "13" => "kinmu_city" , "14" => "kinmu_address" , "15" => "category01" , "16" => "kinmu_time" , "17" => "access_info" , "18" => "naiyou" ); // $list = $db->getList($fields); $list = $db->getList(); if ($list) { $data["total"] = $count; // 総件数 $data["list_start"] = $page * 20 + 1; $data["list_end"] = $page * 20 + count($list); foreach ($list as $key => $val) { // 内容200字まで // 企業情報 // 新着 // 更新日 $val["reg_date"] = date_format2($val["reg_date"]); $list[$key] = disp_kyujin($val); } $data["list"] = $list; } if ($act == "get_rss") { $rss = array(); foreach ($list as $val) { unset($item); $item["url"] = TOP_URL . "detail.html&id=" . $val["kyujin_id"]; $item["title"] = $val["title"]; $item["creator"] = $val["company"]["company_name"]; $item["category"] = $val["koyou"]; $item["description"] = $val["pr1"]; //$item["date"] = $val["kyujin_start"]; $tm = mktime(0, 0, 0, substr($val["kyujin_start"], 5, 2), substr($val["kyujin_start"], 8, 2), substr($val["kyujin_start"], 0, 4)); $item["date"] = date('Y-m-d\TH:i:s+09:00', $tm); $rss[] = $item; } unset($val); $val["about"] = $setup["site_name"]; $val["title"] = $setup["site_name"]; $val["url"] = TOP_URL; $val["link"] = TOP_URL; $val["description"] = $setup["description"]; $val["creator"] = $setup["site_name"]; $val["rights"] = $setup["site_name"]; $val["date"] = $item["date"] = date('Y-m-d\TH:i:s+09:00', time()); $val["rss"] = $rss; // RSS出力 /* header('content-type: text/xml; charset=utf-8'); $data = htmltemplate::t_buffer("rss.xml", $val); echo mb_convert_encoding($data, 'utf8', SCRIPT_ENCODING); */ print_r($rss); exit; } // if ($search) { $data["search"] = $search; } if ($search2) { //$data["search3"] = $search2; $search2 .= "求人情報を全".$count."件表示しています。"; $data["search2"] = $search2; } if ($search3) { $data["search3"] = implode(",", $search3); } if ($seo_pref) { $data["seo_pref"] = $seo_pref; } if ($seo_ensen) { $data["seo_ensen"] = $seo_ensen; } // 勤務地 // $data["area"] = get_info_select(INFO_AREA, $area); if ($area) { foreach ($area as $val) { $data["area" . $val] = "selected"; } } // 沿線 if ($ensen) { $data["ensen_sel"] = $ensen; } // 駅 if ($eki) { $data["eki_sel"] = $eki; } // 都道府県 foreach($preficture_list as $key => $val) { $db = new Kyujin(); $db->search = $serach_tmp; if ($serach_tmp) { foreach ($db->search as $key2 => $val2) { if ($val2["nest"][0]["field"] == "kinmu") { unset($db->search[$key2]); } if ($val2["field"] == "kinmu_city") { unset($db->search[$key2]); } if ($val2["nest"][0]["field"] == "ensen1") { unset($db->search[$key2]); } if ($val2["nest"][0]["field"] == "eki1") { unset($db->search[$key2]); } } } // $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 // $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 //// 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); //// $db->search[] = array("field" => "kinmu", "value" => $key, "cond" => "="); //都道府県 $count = $db->getCount(); $data["pref_list"][$key]["name"] = $val; $data["pref_list"][$key]["count"] = $count; } // 職種 選択肢取得 $data["syokusyu"] = get_info_select(INFO_SHOKUSYU, $syokusyu ,"checked"); //第3引数にて選択時付与情報付与 "selected" or "checked" foreach($data["syokusyu"] as $key => $val) { $db = new Kyujin(); $db->search = $serach_tmp; // $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 // $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "syokusyu", "value" => $val["info_id"], "cond" => "in"); $count = $db->getCount(); $data["syokusyu"][$key]["count"] = $count; } // 雇用形態 選択肢取得 $data["koyou"] = get_info_select(INFO_KOYOU, $koyou ,"checked"); foreach($data["koyou"] as $key => $val) { $db = new Kyujin(); $db->search = $serach_tmp; // $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 // $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 //// 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); //// $db->search[] = array("field" => "koyou", "value" => $val["info_id"], "cond" => "in"); $count = $db->getCount(); $data["koyou"][$key]["count"] = $count; } // 業務 (廃止) //$data["gyomu"] = get_info_select(INFO_GYOMU, $gyomu); // 給与 選択肢取得 $data["kyuyo_type"] = get_info_select(INFO_KYUYO, $kyuyo_type); // 変動カテゴリ $db = new Category(); $db->search[] = array("field" => "level", "value" => 1, "cond" => "="); $db->order[] = array("field" => "ord", "asc" => "1"); $cate_tit = $db->getList(); // カテゴリ名（親）取得（seq => カテゴリid , name => カテゴリ名 , level => カテゴリ階層（1 = 親） , ord => カテゴリ並び順 ） $db = new Category(); $db->search[] = array("field" => "level", "value" => 2, "cond" => "="); $db->order[] = array("field" => "ord", "asc" => "1"); $db->order[] = array("field" => "parents_ord", "asc" => "1"); $cate_tmp = $db->getList(); // カテゴリ項目（子）取得（seq => カテゴリid , name => カテゴリ名 , level => カテゴリ階層（2 = 子） , ord => カテゴリ並び順 , parents_ord => 親の並び順 , parents => 親ID ） //form選択項目セット $cate_tmp_sel["category01"] = $category01; $cate_tmp_sel["category02"] = $category02; $cate_tmp_sel["category03"] = $category03; $cate_tmp_sel["category04"] = $category04; $cate_tmp_sel["category05"] = $category05; $cate_tmp_sel["category06"] = $category06; $cate_tmp_sel["category07"] = $category07; $cate_tmp_sel["category08"] = $category08; $cate_tmp_sel["category09"] = $category09; $cate_tmp_sel["category10"] = $category10; foreach($cate_tit as $val1) { for ($i = 1; $i < 11; $i++){ //カテゴリは最大10個までしか登録できない(運営側) $category_ii = "category" . sprintf("%02d", $i); //カテゴリ名セット if ($val1["ord"] == $i) { //親の並び順が$iだったら foreach($cate_tmp as $val2) { if ($val2["parents_ord"] == $i) { //子に指定されている親の並び順が$iだったら $data[$category_ii]["title"] = $val1["name"]; //カテゴリタイトル（親の名前）セット $data_tmp["info_id"] = $val2["seq"]; //項目ID（子ID）セット $data_tmp["contents"] = $val2["name"]; //項目名（子の名前）セット // 求人登録数カウント $db = new Kyujin(); $db->search = $serach_tmp; // $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 // $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // $db->search[] = array("field" => "CONCAT(','," . $category_ii . ",',')", "value" => "%".$val2["seq"]."%", "cond" => "like"); $count = $db->getCount(); $data_tmp["count"] = $count; //form選択項目をループ foreach($cate_tmp_sel[$category_ii] as $val3) { //form選択項目をループ if ($val3 == $data_tmp["info_id"]) { $data_tmp["sel"] = "checked"; } } $data[$category_ii]["list"][] = $data_tmp; unset($data_tmp); } } } } } // if (!$kyuyo_type) { // $data["kyuyo_type"][0]["sel"] = "selected"; $item = get_info_item($data["kyuyo_type"][0]["info_id"]); } else { $item = get_info_item($kyuyo_type); } /* if (!$kyuyo) { $kyuyo = $item['kyuyo1']; } */ $data["kyuyo"] = array(); if ($kyuyo == $item['kyuyo1']) { $data["kyuyo"][] = array("value" => $item['kyuyo1'], "name" => yen_format($item['kyuyo1']), "sel" => "selected"); } else { $data["kyuyo"][] = array("value" => $item['kyuyo1'], "name" => yen_format($item['kyuyo1'])); } if ($kyuyo == $item['kyuyo2']) { $data["kyuyo"][] = array("value" => $item['kyuyo2'], "name" => yen_format($item['kyuyo2']), "sel" => "selected"); } else { $data["kyuyo"][] = array("value" => $item['kyuyo2'], "name" => yen_format($item['kyuyo2'])); } if ($kyuyo == $item['kyuyo3']) { $data["kyuyo"][] = array("value" => $item['kyuyo3'], "name" => yen_format($item['kyuyo3']), "sel" => "selected"); } else { $data["kyuyo"][] = array("value" => $item['kyuyo3'], "name" => yen_format($item['kyuyo3'])); } if ($kyuyo == $item['kyuyo4']) { $data["kyuyo"][] = array("value" => $item['kyuyo4'], "name" => yen_format($item['kyuyo4']), "sel" => "selected"); } else { $data["kyuyo"][] = array("value" => $item['kyuyo4'], "name" => yen_format($item['kyuyo4'])); } if ($kyuyo == $item['kyuyo5']) { $data["kyuyo"][] = array("value" => $item['kyuyo5'], "name" => yen_format($item['kyuyo5']), "sel" => "selected"); } else { $data["kyuyo"][] = array("value" => $item['kyuyo5'], "name" => yen_format($item['kyuyo5'])); } if ($kyuyo == $item['kyuyo6']) { $data["kyuyo"][] = array("value" => $item['kyuyo6'], "name" => yen_format($item['kyuyo6']), "sel" => "selected"); } else { $data["kyuyo"][] = array("value" => $item['kyuyo6'], "name" => yen_format($item['kyuyo6'])); } // // $data["ensen"] = get_ensen_select_use($ensen); //$data["eki"] = get_eki_select($ensen, $eki); //141215 複数用 // $data["eki"] = get_eki_select2($ensen, $eki); // if ($act == "new") { $ap->view("new.html", $data); } else { $ap->view("search.html", $data); } exit; } //-------------------------------------------- // 注目の求人 if ($act == "attension") { $page = $_REQUEST["page"]; if (!$page) { $page = 0; } // $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->order[] = array("field" => "oubo_count", "desc" => "1"); $db->page = $page; $db->limit = 20; $count = $db->getCount(); $pages = intval(($count + $db->limit - 1) / $db->limit); if ($pages > 1) { $data["pager"] = page_index2($page, $pages); } $list = $db->getList(); if ($list) { $data["total"] = $count; // 総件数 $data["list_start"] = $page * 20 + 1; $data["list_end"] = $page * 20 + count($list); foreach ($list as $key => $val) { // 内容200字まで // 企業情報 // 新着 // 更新日 $val["reg_date"] = date_format2($val["reg_date"]); $list[$key] = disp_kyujin($val); } $data["list"] = $list; } $ap->view("attension.html", $data); exit; } if ($act == "base2") { $ap->view("base2.html", $data); exit; } //-------------------------------------------- if ($act == "help-company-p") { $id = $_REQUEST["id"]; if ($id) { $item = Help::getData($id); $item["title_short"] = mb_strimwidth($item["title"], 0, 20, "..."); $data["item"] = $item; $ap->view("help-company-p.html", $data); exit; } $act = "help-company"; } if ($act == "help-company") { $keyword = $_REQUEST["keyword"]; if ($keyword) { $db = new Help(); $db->search[] = array("field" => "kind", "value" => "2", "cond" => "="); $db->search[] = array("field" => "comment", "value" => "%" . $keyword . "%", "cond" => "like"); $db->page = 0; $db->limit = 0; $list = $db->getList(); if ($list) { $list2 = array(); foreach ($list as $val) { $list2[$val["category_id"]][] = $val; } unset($cond); $cond["kind"] = INFO_HELP; $ret = Info::findData($cond, null, null, array(array("field" => "ord"))); if ($ret) { foreach ($ret as $val) { $item["items"] = $list2[$val["info_id"]]; $help[] = $item; } } } if ($help) { foreach ($help as $val) { if ($val["items"]) { $data["help"][] = $val; } } } $data["keyword"] = $keyword; } else { unset($cond); $cond["kind"] = INFO_HELP; $ret = Info::findData($cond, null, null, array(array("field" => "ord"))); if ($ret) { foreach ($ret as $val) { $item = get_info_item($val["info_id"]); if ($item["kinds"] == "2") { unset($cond); $cond["category_id"] = $val["info_id"]; $ret = Help::findData($cond); $item["items"] = $ret; $help[] = $item; } } } $data["help"] = $help; } //dump($help); $ap->view("help-company.html", $data); exit; } if ($act == "help-user-p") { $id = $_REQUEST["id"]; if ($id) { $item = Help::getData($id); $item["title_short"] = mb_strimwidth($item["title"], 0, 20, "..."); $data["item"] = $item; $ap->view("help-user-p.html", $data); exit; } $act = "help-user"; } if ($act == "help-user") { $keyword = $_REQUEST["keyword"]; if ($keyword) { $db = new Help(); $db->search[] = array("field" => "kind", "value" => "1", "cond" => "="); $db->search[] = array("field" => "comment", "value" => "%" . $keyword . "%", "cond" => "like"); $db->page = 0; $db->limit = 0; $list = $db->getList(); if ($list) { $list2 = array(); foreach ($list as $val) { $list2[$val["category_id"]][] = $val; } unset($cond); $cond["kind"] = INFO_HELP; $ret = Info::findData($cond, null, null, array(array("field" => "ord"))); if ($ret) { foreach ($ret as $val) { $val["items"] = $list2[$val["info_id"]]; $help[] = $val; } } } if ($help) { foreach ($help as $val) { if ($val["items"]) { $data["help"][] = $val; } } } $data["keyword"] = $keyword; } else { unset($cond); $cond["kind"] = INFO_HELP; $ret = Info::findData($cond, null, null, array(array("field" => "ord"))); if ($ret) { foreach ($ret as $val) { $item = get_info_item($val["info_id"]); if ($item["kinds"] == "1") { unset($cond); $cond["category_id"] = $val["info_id"]; $ret = Help::findData($cond); $item["items"] = $ret; $help[] = $item; } } } $data["help"] = $help; } $ap->view("help-user.html", $data); exit; } if ($act == "event_calendar") { //パラメータがあるかないか、ないなら現在の日付を代入 if (isset($_GET['d'])) { $data["d"] = $_GET['d']; } else { $data["d"] = date("Y-m"); } //『-』を区切り文字にして分解する、分解したものをlist()関数で代入していく。 list($data['year'], $data['month']) = explode("-", $data['d']); //checkdate()でインジェクション対策。 if(!checkdate($data['month'],1,$data['year'])){ $data['date_err'] = "不正な日付です"; exit; } $data['prev'] = date("Y-m", mktime(0, 0, 0, $data['month']-1, 1, $data['year']) ); $data['next'] = date("Y-m", mktime(0, 0, 0, $data['month']+1, 1, $data['year']) ); $year = $data['year']; $month = $data['month']; $fd = date("w", strtotime("$year-$month-1") );//今月の１日の曜日を知る 2014年7月の初めは2、つまり火曜日。0から6まで取得できる $ld = date("t", strtotime("$year-$month-1") );//今月の最後の日数を取得する 2014年7月の終わりの日は31。 28から31の数字を取得できる。 $y = $fd;//曜日の初期値 //日付を作る 日曜日($y = 0)の時はセル文字を赤く、土曜日($y) for($i = 1;$i<=$ld;$i++){ switch($y){ case 0:$data['day'][$i]['youbi'] = "日"; break; case 1:$data['day'][$i]['youbi'] = "月"; break; case 2:$data['day'][$i]['youbi'] = "火"; break; case 3:$data['day'][$i]['youbi'] = "水"; break; case 4:$data['day'][$i]['youbi'] = "木"; break; case 5:$data['day'][$i]['youbi'] = "金"; break; case 6:$data['day'][$i]['youbi'] = "土"; break; default:$data['day'][$i]['youbi'] = ""; break; } $y++; $y = $y % 7; } //イベント情報取得 foreach($data['day'] as $key => $val) { $search_date = $year."-".sprintf('%02d', $month)."-".sprintf('%02d', $key); $db = new Event(); $db->search[] = array("field" => "disp_date", "value" => $search_date, "cond" => "="); $db->order[] = array("field" => "start_time", "asc" => "1"); $ret = $db->getList(); if ($ret) { $data['day'][$key]['event'] = $ret; } } $ap->view("event_calendar.html", $data); exit; } /* if ($act == "crontest") { if ($_REQUEST["crontest"] == 1) { exec('/usr/bin/php5.2 -f /home/kaigo-at/kaigo-at.jp/public_html/bin/mailproc.php'); //exec('/usr/bin/php5.2 /home/mansion-q/test-reqruit.info/public_html/bin/mailmag.php'); } elseif ($_REQUEST["crontest"] == 2) { $data["msg"] = "未実装"; } $data["pass"] = dirname(__FILE__); $ap->view("crontest.html", $data); exit; } */ /* if ($act == "help") { $ap->view("help.html", $data); exit; } if ($act == "iwaikin") { $ap->view("iwaikin.html", $data); exit; } if ($act == "sitemap") { $ap->view("sitemap.html", $data); exit; } */ if ($act == "kiyaku") { $info = get_setup(INFO_KIYAKU1); $data["kiyaku1"] = $info["kiyaku1"]; $ap->view("kiyaku.html", $data); exit; } if ($act == "kiyaku2") { $info = get_setup(INFO_KIYAKU2); $data["kiyaku2"] = $info["kiyaku2"]; $ap->view("kiyaku2.html", $data); exit; } if ($act == "search2") { $data["area"][] = $_REQUEST["area"]; // 都道府県 foreach($preficture_list as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "kinmu", "value" => $key, "cond" => "="); //都道府県 $count = $db->getCount(); $data["pref_list"][$key]["name"] = $val; $data["pref_list"][$key]["count"] = $count; } $ap->view("search2.html", $data); exit; } if ($act == "search3") { $data["area"][] = $_REQUEST["area"]; // 都道府県 foreach($preficture_list as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "kinmu", "value" => $key, "cond" => "="); //都道府県 $count = $db->getCount(); $data["pref_list"][$key]["name"] = $val; $data["pref_list"][$key]["count"] = $count; } $ap->view("search3.html", $data); exit; } //-------------------------------------------- $ap->fix_template(); //-------------------------------------------- // トップページ2 if ($ap->template == "index2.html") { // お知らせ $db = new News(); $db->page = 0; $db->limit = 5; $db->order[] = array("field" => "disp_date", "desc" => "1"); $ret = $db->getList(); if ($ret) { $data["news"] = $ret; } // 勤務地 //$data["area"] = get_info(INFO_AREA); // 都道府県 //$data["pref_list"] = $preficture_list; // 都道府県 foreach($preficture_list as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "kinmu", "value" => $key, "cond" => "="); //都道府県 $count = $db->getCount(); $data["pref_list"][$key]["name"] = $val; $data["pref_list"][$key]["count"] = $count; } // 職種 選択肢取得 $data["syokusyu"] = get_info_select(INFO_SHOKUSYU, $syokusyu ,"checked"); //第3引数にて選択時付与情報付与 "selected" or "checked" foreach($data["syokusyu"] as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "syokusyu", "value" => $val["info_id"], "cond" => "in"); $count = $db->getCount(); $data["syokusyu"][$key]["count"] = $count; } // 雇用形態 選択肢取得 $data["koyou"] = get_info_select(INFO_KOYOU, $koyou ,"checked"); foreach($data["koyou"] as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "koyou", "value" => $val["info_id"], "cond" => "in"); $count = $db->getCount(); $data["koyou"][$key]["count"] = $count; } // 閲覧数の多い求人 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->order[] = array("field" => "view_count", "asc" => "1"); $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" ); $look_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($look_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $look_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $look_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $look_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $look_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $look_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $look_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $look_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $look_list_tmp[$key]["title"] = $val["title"]; $look_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["look_list"] = $look_list_tmp; // // 特集 // アクティブな特集リスト $db = new Special(); $db->search[] = array("field" => "status", "value" => 1, "cond" => "="); //有効 $db->search[] = array("field" => "start", "value" => date("Y-m-d"), "cond" => "<="); //開始日以降 $db->search[] = array("field" => "end", "value" => date("Y-m-d"), "cond" => ">="); //終了日が過ぎていない $db->order[] = array("rand" => "1"); $data["sp_list"] = $db->getList(); /* // 運営ピックアップ求人 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 // 企業アカウントの公開可能日判定 unset($where_start); $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); $db->search[] = array("field" => "company_id", "cond" => "in", "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "admin_pickup", "value" => "1", "cond" => "="); // 運営ピックアップフラグ $db->order[] = array("rand" => "1"); // 8件ランダム抽出 $db->limit = 8; $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" ); $adpick_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($adpick_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $adpick_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $adpick_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $adpick_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $adpick_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $adpick_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $adpick_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $adpick_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $adpick_list_tmp[$key]["title"] = $val["title"]; $adpick_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["adpick_list"] = $adpick_list_tmp; // */ // 全国の求人（ランダム） $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 $db->order[] = array("rand" => "1"); // 8件ランダム抽出 $db->limit = 8; $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" ); $rand_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($rand_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $rand_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $rand_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $rand_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $rand_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $rand_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $rand_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $rand_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $rand_list_tmp[$key]["title"] = $val["title"]; $rand_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["rand_list"] = $rand_list_tmp; // // 新着求人 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 $db->order[] = array("field" => "up_date", "desc" => "1"); $db->limit = 8; $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" , "13" => "kinmu_city" ); $new_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($new_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $new_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $new_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $new_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $new_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $new_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $new_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $new_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $new_list_tmp[$key]["title"] = $val["title"]; $new_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["new_list"] = $new_list_tmp; // // 周辺地域から探す if ($_REQUEST["areaname"]) { if (strpos($_REQUEST["areaname"], " ") === FALSE) { // $areaname = $_REQUEST["areaname"]; $rcd = preg_match('/(東京都|北海道|(?:京都|大阪)府|.{6,9}県)((?:四日市|廿日市|野々市|臼杵|かすみがうら|つくばみらい|いちき串木野)市|(?:杵島郡大町|余市郡余市|高市郡高取)町|.{3,12}市.{3,12}区|.{3,9}区|.{3,15}市(?=.*市)|.{3,15}市|.{6,27}町(?=.*町)|.{6,27}町|.{9,24}村(?=.*村)|.{9,24}村)(.*)/', $_REQUEST["areaname"], $result); if ($rcd == 1) { array_shift($result); // resultの1個目（元のワード）を削除 $areaname = $result; } else { $areaname = $_REQUEST["areaname"]; } } else { $areaname = explode(" ", $_REQUEST["areaname"]); } } $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // if ($areaname) { unset($c_area); if (!is_array($areaname)) { $areaname2[] = $areaname; $areaname = $areaname2; } foreach($areaname as $val) { $c_area[] = array("field" => "kinmu_val", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $c_area[] = array("field" => "kinmu_city_val", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $c_area[] = array("field" => "kinmu_address", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_area); $data["areaname"] = implode(" ", $areaname); $data["zoom"] = 12; $latlng1 = GetGeocode2($areaname[0] . $areaname[1] . $areaname[2]); if ($latlng1) { $data['map_lat'] = $latlng1[1]; $data['map_lon'] = $latlng1[2]; } } $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" , "13" => "kinmu_city" , "14" => "kinmu_address" , "15" => "map" , "16" => "g_map_url" , "17" => "g_map_lat" , "18" => "g_map_lon" ); $area_list_tmp = $db->getList($fields); if ($area_list_tmp) { foreach($area_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $area_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $area_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $area_list_tmp[$key]["kinmu_city"] = get_city_name($val["kinmu_city"]); $area_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $area_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $area_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $area_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $area_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $area_list_tmp[$key]["title"] = $val["title"]; $area_list_tmp[$key]["pr1"] = $val["pr1"]; if ($area_list_tmp[$key]["g_map_lat"] && $area_list_tmp[$key]["g_map_lon"]) { // エリアベースの配列生成 unset($map_key); $map_key = $area_list_tmp[$key]['g_map_lat'] . $area_list_tmp[$key]['g_map_lon']; $map_key = str_replace(".","",$map_key); $address_list[$map_key][] = $area_list_tmp[$key]; } } } else { $data["map_err"] = "求人が見つかりませんでした。"; } $data["area_list2"] = $address_list; $data["area_list"] = json_encode($address_list, JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); //トップページ沿線リスト unset($ensen_list_tmp); $taiou_pref_list = array("0" => 13 , "1" => 14 , "2" => 11 , "3" => 12); // この求人サイトの対応都道府県を定義 (東京、神奈川、埼玉、千葉)、キーの昇順にリスト表示される 不要な場合はコメントアウト if ($taiou_pref_list) { //対応都道府県指定がある場合は指定都道府県のみの沿線取得 foreach ($preficture_list as $key => $val) { foreach ($taiou_pref_list as $key2 => $val2) { if ($key == $val2) { //指定した対応都道府県コードに合致する場合 $ekidata = new MyEkiDataJP(); $lines = $ekidata->getLinesByPrefId($key); $ensen_list_tmp[$key2]["pref_cd"] = $key; $ensen_list_tmp[$key2]["pref"] = $val; foreach ( $lines->line as $line ) { $line_tmp = get_object_vars($line); //SimpleXMLObjectを配列に展開 $ensen_list_tmp[$key2]["ensen"][$line_tmp["line_cd"]] = $line_tmp["line_name"]; } } } } } else { //対応都道府県指定が無い場合は全国の沿線取得 foreach ($preficture_list as $key => $val) { if ($key > 47) { //北海道(1)～沖縄(47)まで 海外(48)はEkiDataJPでは取得できないためエラーとなる break; } $ekidata = new MyEkiDataJP(); $lines = $ekidata->getLinesByPrefId($key); $ensen_list_tmp[$key]["pref_cd"] = $key; $ensen_list_tmp[$key]["pref"] = $val; foreach ( $lines->line as $line ) { $line_tmp = get_object_vars($line); //SimpleXMLObjectを配列に展開 $ensen_list_tmp[$key]["ensen"][$line_tmp["line_cd"]] = $line_tmp["line_name"]; } } } if ($ensen_list_tmp) { ksort($ensen_list_tmp); } $data["ensen_list"] = $ensen_list_tmp; // // 変動カテゴリ $db = new Category(); $db->search[] = array("field" => "level", "value" => 1, "cond" => "="); $db->order[] = array("field" => "ord", "asc" => "1"); $cate_tit = $db->getList(); $db = new Category(); $db->search[] = array("field" => "level", "value" => 2, "cond" => "="); $db->order[] = array("field" => "parents_ord", "asc" => "1"); $cate_tmp = $db->getList(); if($cate_tit) { foreach($cate_tit as $val1) { for ($i = 1; $i < 11; $i++){ //カテゴリは最大10個までしか登録できない(運営側) $category_ii = "category" . sprintf("%02d", $i); if ($val1["ord"] == $i) { foreach($cate_tmp as $val2) { if ($val2["parents_ord"] == $i) { $data[$category_ii]["title"] = $val1["name"]; $data_tmp["info_id"] = $val2["seq"]; $data_tmp["contents"] = $val2["name"]; $data[$category_ii]["list"][] = $data_tmp; unset($data_tmp); } } } } } } // $ap->view("index2.html", $data); exit; } //-------------------------------------------- // トップページ if ($ap->template == "index.html") { // お知らせ $db = new News(); $db->page = 0; $db->limit = 5; $db->order[] = array("field" => "disp_date", "desc" => "1"); $ret = $db->getList(); if ($ret) { $data["news"] = $ret; } // 勤務地 //$data["area"] = get_info(INFO_AREA); // 都道府県 //$data["pref_list"] = $preficture_list; // 都道府県 foreach($preficture_list as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "kinmu", "value" => $key, "cond" => "="); //都道府県 $count = $db->getCount(); $data["pref_list"][$key]["name"] = $val; $data["pref_list"][$key]["count"] = $count; } // 職種 選択肢取得 $data["syokusyu"] = get_info_select(INFO_SHOKUSYU, $syokusyu ,"checked"); //第3引数にて選択時付与情報付与 "selected" or "checked" foreach($data["syokusyu"] as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "syokusyu", "value" => $val["info_id"], "cond" => "in"); $count = $db->getCount(); $data["syokusyu"][$key]["count"] = $count; } // 雇用形態 選択肢取得 $data["koyou"] = get_info_select(INFO_KOYOU, $koyou ,"checked"); foreach($data["koyou"] as $key => $val) { $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "koyou", "value" => $val["info_id"], "cond" => "in"); $count = $db->getCount(); $data["koyou"][$key]["count"] = $count; } /* // 閲覧数の多い求人 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 //unset($where_start); //$where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); //$db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->order[] = array("field" => "view_count", "asc" => "1"); $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" ); $look_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($look_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $look_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $look_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $look_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $look_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $look_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $look_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $look_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $look_list_tmp[$key]["title"] = $val["title"]; $look_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["look_list"] = $look_list_tmp; // */ // 特集 // アクティブな特集リスト $db = new Special(); $db->search[] = array("field" => "status", "value" => 1, "cond" => "="); //有効 $db->search[] = array("field" => "start", "value" => date("Y-m-d"), "cond" => "<="); //開始日以降 $db->search[] = array("field" => "end", "value" => date("Y-m-d"), "cond" => ">="); //終了日が過ぎていない $db->order[] = array("rand" => "1"); $data["sp_list"] = $db->getList(); /* // 運営ピックアップ求人 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 // 企業アカウントの公開可能日判定 unset($where_start); $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); $db->search[] = array("field" => "company_id", "cond" => "in", "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // $db->search[] = array("field" => "admin_pickup", "value" => "1", "cond" => "="); // 運営ピックアップフラグ $db->order[] = array("rand" => "1"); // 8件ランダム抽出 $db->limit = 8; $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" ); $adpick_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($adpick_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $adpick_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $adpick_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $adpick_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $adpick_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $adpick_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $adpick_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $adpick_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $adpick_list_tmp[$key]["title"] = $val["title"]; $adpick_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["adpick_list"] = $adpick_list_tmp; // */ // 全国の求人（ランダム） → おすすめの求人（アクセス数少ない順 → ランダム）へ変更 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 $db->order[] = array("field" => "access_count", "asc" => "1"); $db->order[] = array("rand" => "1"); // 8件ランダム抽出 $db->limit = 8; $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" , "13" => "kinmu_city" ); $rand_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($rand_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $rand_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $rand_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $rand_list_tmp[$key]["kinmu_city"] = get_city_name($val["kinmu_city"]); $rand_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $rand_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $rand_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $rand_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $rand_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $rand_list_tmp[$key]["title"] = $val["title"]; $rand_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["rand_list"] = $rand_list_tmp; // // 新着求人 $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 $db->search[] = array("field" => "hellowork_flg", "value" => 1, "cond" => "<>"); // ハローワーク以外 // 170927 企業アカウントの公開可能日判定はcronで処理 // 企業アカウントの公開可能日判定 // unset($where_start); // $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); // $db->search[] = array("field" => "company_id", "cond" => "in", // "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // // $db->search[] = array("expression" => "kyujin_start<=date(now()) and kyujin_end>=date(now())"); // 公開期間内 $db->order[] = array("field" => "up_date", "desc" => "1"); $db->limit = 8; $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "5" => "category01" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" , "13" => "kinmu_city" ); $new_list_tmp = $db->getList($fields); $idx = get_info_idx(INFO_SHOKUSYU); $idx2 = get_info_idx(INFO_KOYOU); $idx3 = get_info_idx(INFO_KYUYO); foreach($new_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $new_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; $new_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; $new_list_tmp[$key]["kinmu_city"] = get_city_name($val["kinmu_city"]); $new_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; $new_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; $new_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; $new_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; $new_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $new_list_tmp[$key]["title"] = $val["title"]; $new_list_tmp[$key]["pr1"] = $val["pr1"]; } $data["new_list"] = $new_list_tmp; // 周辺地域から探す /* if ($_REQUEST["areaname"]) { if (strpos($_REQUEST["areaname"], " ") === FALSE) { // $areaname = $_REQUEST["areaname"]; $rcd = preg_match('/(東京都|北海道|(?:京都|大阪)府|.{6,9}県)((?:四日市|廿日市|野々市|臼杵|かすみがうら|つくばみらい|いちき串木野)市|(?:杵島郡大町|余市郡余市|高市郡高取)町|.{3,12}市.{3,12}区|.{3,9}区|.{3,15}市(?=.*市)|.{3,15}市|.{6,27}町(?=.*町)|.{6,27}町|.{9,24}村(?=.*村)|.{9,24}村)(.*)/', $_REQUEST["areaname"], $result); if ($rcd == 1) { array_shift($result); // resultの1個目（元のワード）を削除 $areaname = $result; } else { $areaname = $_REQUEST["areaname"]; } } else { $areaname = explode(" ", $_REQUEST["areaname"]); } } $data["areaname2"] = $areaname; */ $text = htmlspecialchars($_REQUEST["areaname"],ENT_QUOTES); $data["areaname2"] = $text?$text:''; /* $db = new Kyujin(); $db->search[] = array("field" => "del_flag", "value" => "0", "cond" => "="); // 有効 $db->search[] = array("field" => "status", "value" => "2", "cond" => "="); // 公開 // 企業アカウントの公開可能日判定 unset($where_start); $where_start[] = array("expression" => "kyujin_start <= '" . date("Y-m-d") . "' and kikan_end >= '" . date("Y-m-d") . "'"); $db->search[] = array("field" => "company_id", "cond" => "in", "select" => array("table" => "company", "where" => $where_start, "fields" => array("distinct company_id"))); // //if ($areaname) { if (FALSE) { unset($c_area); if (!is_array($areaname)) { $areaname2[] = $areaname; $areaname = $areaname2; } foreach($areaname as $val) { $c_area[] = array("field" => "kinmu_val", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $c_area[] = array("field" => "kinmu_city_val", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); $c_area[] = array("field" => "kinmu_address", "value" => "%".$val."%", "cond" => "like", "relation" => "or"); } $db->search[] = array("nest" => $c_area); $data["areaname"] = implode(" ", $areaname); $data["zoom"] = 12; $latlng1 = GetGeocode2($areaname[0] . $areaname[1] . $areaname[2]); if ($latlng1) { $data['map_lat'] = $latlng1[1]; $data['map_lon'] = $latlng1[2]; } } //$fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "syokusyu" , "4" => "koyou" , "6" => "pr1" , "7" => "kinmu" , "8" => "main_image" , "10" => "kyuyo" , "11" => "kyuyo_min" , "12" => "kyuyo_max" , "13" => "kinmu_city" , "14" => "kinmu_address" , "15" => "map" , "16" => "g_map_url" , "17" => "g_map_lat" , "18" => "g_map_lon" ); $area_list_tmp = $db->getList($fields); $fields = array("0" => "kyujin_id" , "1" => "company_id" , "2" => "title" , "3" => "g_map_lat" , "4" => "g_map_lon" ); if ($area_list_tmp) { foreach($area_list_tmp as $key => $val) { unset($cond); $cond["company_id"] = $val["company_id"]; $ret = Company::findData($cond); $area_list_tmp[$key]["company_name"] = $ret[0]["company_name"]; //$area_list_tmp[$key]["kinmu"] = $preficture_list[$val["kinmu"]]; //$area_list_tmp[$key]["kinmu_city"] = get_city_name($val["kinmu_city"]); //$area_list_tmp[$key]["syokusyu"] = $idx[$val["syokusyu"]]; //$area_list_tmp[$key]["koyou"] = $idx2[$val["koyou"]]; //$area_list_tmp[$key]["kyuyo_min"] = $val["kyuyo_min"]; //$area_list_tmp[$key]["kyuyo_max"] = $val["kyuyo_max"]; //$area_list_tmp[$key]["kyuyo"] = $idx3[$val["kyuyo"]]; $area_list_tmp[$key]["title"] = $val["title"]; //$area_list_tmp[$key]["pr1"] = $val["pr1"]; if ($area_list_tmp[$key]["g_map_lat"] && $area_list_tmp[$key]["g_map_lon"]) { // エリアベースの配列生成 unset($map_key); $map_key = $area_list_tmp[$key]['g_map_lat'] . $area_list_tmp[$key]['g_map_lon']; $map_key = str_replace(".","",$map_key); $address_list[$map_key][] = $area_list_tmp[$key]; } } } else { $data["map_err"] = "求人が見つかりませんでした。"; } $data["area_list2"] = $address_list; $data["area_list"] = json_encode($address_list, JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); //$data["area_list3"] = json_decode(json_encode($address_list), true); */ /* //トップページ沿線リスト unset($ensen_list_tmp); //$taiou_pref_list = array("0" => 13 , "1" => 14 , "2" => 11 , "3" => 12); // この求人サイトの対応都道府県を定義 (東京、神奈川、埼玉、千葉)、キーの昇順にリスト表示される 不要な場合はコメントアウト if ($taiou_pref_list) { //対応都道府県指定がある場合は指定都道府県のみの沿線取得 foreach ($preficture_list as $key => $val) { foreach ($taiou_pref_list as $key2 => $val2) { if ($key == $val2) { //指定した対応都道府県コードに合致する場合 $ekidata = new MyEkiDataJP(); $lines = $ekidata->getLinesByPrefId($key); $ensen_list_tmp[$key2]["pref_cd"] = $key; $ensen_list_tmp[$key2]["pref"] = $val; foreach ( $lines->line as $line ) { $line_tmp = get_object_vars($line); //SimpleXMLObjectを配列に展開 $ensen_list_tmp[$key2]["ensen"][$line_tmp["line_cd"]] = $line_tmp["line_name"]; } } } } } else { //対応都道府県指定が無い場合は全国の沿線取得 foreach ($preficture_list as $key => $val) { if ($key > 47) { //北海道(1)～沖縄(47)まで 海外(48)はEkiDataJPでは取得できないためエラーとなる break; } $ekidata = new MyEkiDataJP(); $lines = $ekidata->getLinesByPrefId($key); $ensen_list_tmp[$key]["pref_cd"] = $key; $ensen_list_tmp[$key]["pref"] = $val; foreach ( $lines->line as $line ) { $line_tmp = get_object_vars($line); //SimpleXMLObjectを配列に展開 $ensen_list_tmp[$key]["ensen"][$line_tmp["line_cd"]] = $line_tmp["line_name"]; } } } if ($ensen_list_tmp) { ksort($ensen_list_tmp); } $data["ensen_list"] = $ensen_list_tmp; // */ // 変動カテゴリ $db = new Category(); $db->search[] = array("field" => "level", "value" => 1, "cond" => "="); $db->order[] = array("field" => "ord", "asc" => "1"); $cate_tit = $db->getList(); $db = new Category(); $db->search[] = array("field" => "level", "value" => 2, "cond" => "="); $db->order[] = array("field" => "parents_ord", "asc" => "1"); $cate_tmp = $db->getList(); if($cate_tit) { foreach($cate_tit as $val1) { for ($i = 1; $i < 11; $i++){ //カテゴリは最大10個までしか登録できない(運営側) $category_ii = "category" . sprintf("%02d", $i); if ($val1["ord"] == $i) { foreach($cate_tmp as $val2) { if ($val2["parents_ord"] == $i) { $data[$category_ii]["title"] = $val1["name"]; $data_tmp["info_id"] = $val2["seq"]; $data_tmp["contents"] = $val2["name"]; $data[$category_ii]["list"][] = $data_tmp; unset($data_tmp); } } } } } } // // -------------------------------- // 最近見た求人の取得 unset($list); //if($_SESSION["LOGIN"]["kyushoku_id"]){ // $where = " and kyushoku_id=".$_SESSION["LOGIN"]["kyushoku_id"]; //}else{ // $where = ""; //} //$sql = "select kyujin_rireki.kyujin_id from kyujin_rireki, kyujin where kyujin_rireki.kyujin_id=kyujin.kyujin_id and hellowork_flg <>1 and status=2 order by kyujin_rireki.reg_date desc limit 0,20"; $sql = "select kyujin_id from kyujin_rireki where hellowork_flg != 1 order by reg_date desc limit 0,20"; $inst = DBConnection::getConnection($DB_URI); $ret = $inst->search_sql($sql); if ($ret["count"]) { $list = $ret["data"]; } if ($list) { $kyujin_id = array(); $num = 0; foreach ($list as $val) { if (!$kyujin_id[$val['kyujin_id']]) { $item = Kyujin::getData($val['kyujin_id'], array("kyujin_id", "company_id", "title", "pr1", "pr2", "kinmu", "kinmu_city", "main_image")); $company_name = Company::getData($item['company_id'], array("company_name")); $item["company_name"] = $company_name["company_name"]; $item["kinmu"] = $preficture_list[$item["kinmu"]]; $item["kinmu_city"] = get_city_name($item["kinmu_city"]); $data["check"][] = $item; $kyujin_id[$val['kyujin_id']] = "1"; if (++$num >= 8) break; } } } // -------------------------------- $ap->view("index.html", $data); } else { // スタティックページ $ap->view($ap->template, $data); } exit; //-------------------------------------------- // ログインしていなければ、ログインフォームを表示し、ログイン後もとの処理へ function login_check($msg) { global $sid; // ログイン確認 if (!isset($_SESSION["LOGIN"])) { // ログイン後の飛び先（戻る場所） $_SESSION['NEXT_URL'] = TOP . './logined.html&sid=' . $sid; // 現在のパラメータを保存 $_SESSION['REQUEST'] = $_REQUEST; $_SESSION['LOGIN_MESSAGE'] = $msg; // ログイン処理へ header("Location: ./myuser/login.html&sid=" . $sid); exit; } } function set_row($ary, $cnt) { $num = 0; $col = 0; $data = array(); $row = array(); foreach ($ary as $val) { $row[] = $val; if (++$col == $cnt) { $data[$num]["num"] = $num + 1; $data[$num++]["row"] = $row; $row = array(); $col = 0; } } if ($row) { $data[$num]["num"] = $num + 1; $data[$num++]["row"] = $row; } return $data; } function sel_normalize($items) { if ($items) { if (is_array($items)) { $data = array(); foreach ($items as $val) { if ($val) { $data[] = $val; } } return $data; } else { return array($items); } } return array(); } //map用に整形 hatta 121115//////////////////////////////////////////////// function GetGeocode ($add){ require_once('../lib/JSON.php'); $latlng =array(); $str = ""; $url = "http://maps.google.com/maps/api/geocode/json?address=".$add."&sensor=false"; //echo $url; // レスポンスを取得 $res = file_get_contents($url); //var_dump($res); // JSON形式から連想配列へ変換 $json = new Services_JSON(); $res_array = $json->decode($res); $results = $res_array->results; $lat = $results[0]->geometry->location->lat; $lng = $results[0]->geometry->location->lng; if($lat){ $str = ""; } return array($str,$lat,$lng); /* require_once('lib/JSON.php'); $latlng =array(); $str = ""; $url = "http://maps.google.com/maps/api/geocode/json?address='".$add."'&sensor=false"; // レスポンスを取得 $res = file_get_contents($url); // JSON形式から連想配列へ変換 $json = new Services_JSON(); $res_array = $json->decode($res); $results = $res_array->results; $lat = $results[0]->geometry->location->lat; $lng = $results[0]->geometry->location->lng; return array($lat,$lng); */ } //map用に整形 hatta 121115//////////////////////////////////////////////// // TOPページ 周辺地域から探す用 function GetGeocode2 ($add){ require_once('../lib/JSON.php'); $latlng =array(); $str = ""; $url = "http://maps.google.com/maps/api/geocode/json?address=".$add."&sensor=false"; // レスポンスを取得 $res = file_get_contents($url); // JSON形式から連想配列へ変換 $json = new Services_JSON(); $res_array = $json->decode($res); $results = $res_array->results; $lat = $results[0]->geometry->location->lat; $lng = $results[0]->geometry->location->lng; return array($str,$lat,$lng); } ?>