public static function field($data)
{
$model_add = new Model_Jobadd();
$model_rec = new Model_Jobrecruit();
$arr_json = array();
$arr_phone_number = array();
$arr_db = $data;
if (isset($arr_db['csv'])) {
$arr_json = json_decode($arr_db['csv'], true);
}
if (isset($arr_db['phone_number1'])) {
$arr_phone_number = explode(',', trim($arr_db['phone_number1'], ','));
}
$config_add['where'][] = array('job_id', '=', $arr_db['job_id']);
$list_add = $model_add->get_list_data($config_add);
$config_rec['where'][] = array('job_id', '=', $arr_db['job_id']);
$arr_add = array();
$arr_rec = array();
$i = 0;
foreach ($list_add as $row) {
$arr_add[$i]['sub_title'] = $row['sub_title'];
$arr_add[$i]['text'] = $row['text'];
++$i;
}
$arr_add = array_pad($arr_add, 4, array('sub_title' => '', 'text' => ''));
$list_rec = $model_rec->get_list_data($config_rec);
$i = 0;
foreach ($list_rec as $row) {
$arr_rec[$i]['sub_title'] = $row['sub_title'];
$arr_rec[$i]['text'] = $row['text'];
++$i;
}
$arr_rec = array_pad($arr_rec, 9, array('sub_title' => '', 'text' => ''));
$arr_employment_mark = array();
foreach (Constants::$employment_mark as $key => $val) {
if (substr_count($arr_db['employment_mark'], ',' . $key . ',')) {
$arr_employment_mark[] = '[' . $val . ']';
}
}
$arr_employment_mark = array_pad($arr_employment_mark, 6, '');
$def = ' ';
$trouble_check = '●';
return array('No' => self::get_field_json('No', $arr_json), 'WEB得＆HP' => self::get_field_json('WEB得＆HP', $arr_json), '自由入力②' => self::get_field_json('自由入力②', $arr_json), '自由入力③' => self::get_field_json('自由入力③', $arr_json), '自由入力④' => self::get_field_json('自由入力④', $arr_json), '自由入力⑤' => $arr_db['job_id'], '◆HOPE進行No' => self::get_field_json('◆HOPE進行No', $arr_json), '●商品CD' => self::get_field_json('●商品CD', $arr_json), '●掲載開始号CD' => self::get_field_json('●掲載開始号CD', $arr_json), '●制作企画CD' => self::get_field_json('●制作企画CD', $arr_json), '●明細CD' => self::get_field_json('●明細CD', $arr_json), '▲メモ' => self::get_field_json('▲メモ', $arr_json), '文字_1' => $def, '●営業担当CD' => self::get_field_json('●営業担当CD', $arr_json), '●制作担当CD' => self::get_field_json('●制作担当CD', $arr_json), '●受注先顧客コード' => self::get_field_json('●受注先顧客コード', $arr_json), '●掲載先顧客コード' => self::get_field_json('●掲載先顧客コード', $arr_json), '●掲載社名' => $arr_db['post_company_name'], '文字_2' => $def, '▲ホームページリンク' => $arr_db['url_home_page'], '▲郵便番号' => $arr_db['zipcode'], '●掲載住所' => $arr_db['location'], '文字_3' => $def, '●交通' => $arr_db['traffic'], '文字_4' => $def, '店舗名（紹介の場合）' => $arr_db['store_name'], '●勤務地 表示方式CD' => Constants::$job_work_location_display_type[$arr_db['work_location_display_type']], '勤務地 （派遣・契約の場合）' => $arr_db['work_location'], '文字_50' => $def, '▲勤務地カセット式タイトル' => $arr_db['work_location_title'], '文字_5' => $def, '▲（勤）地図補足' => self::get_field_json('▲（勤）地図補足', $arr_json), '文字_6' => $def, '●雇用形態CD' => Constants::$employment_type[(string) $arr_db['employment_type']], '雇用形態マーク※プルダウンで選択_1' => $arr_employment_mark['0'], '雇用形態マーク※プルダウンで選択_2' => $arr_employment_mark['1'], '雇用形態マーク※プルダウンで選択_3' => $arr_employment_mark['2'], '雇用形態マーク※プルダウンで選択_4' => $arr_employment_mark['3'], '雇用形態マーク※プルダウンで選択_5' => $arr_employment_mark['4'], '雇用形態マーク※プルダウンで選択_6' => $arr_employment_mark['5'], '職種' => $arr_db['job_category'], '文字_7' => $def, '●職種CD 大項目' => $arr_db['occupation'] == 10 ? Constants::$occupation[$arr_db['occupation'] == 0 ? '' : $arr_db['occupation']] : '', '●職種CD 小項目' => self::get_field_json('●職種CD 小項目', $arr_json), 'FAナビ検索職種(大)' => self::get_field_json('FAナビ検索職種(大)', $arr_json), 'FAナビ検索職種(小)' => self::get_field_json('FAナビ検索職種(小)', $arr_json), '●給与形態CD' => Constants::$salary_type[$arr_db['salary_type'] == 0 ? '' : $arr_db['salary_type']], '●給与' => $arr_db['salary_des'], '文字_8' => $def, '◆最低給与金額' => $arr_db['salary_min'], '●キャッチ' => $arr_db['catch_copy'], '文字_9' => $def, '●リード' => $arr_db['lead'], '文字_10' => $def, '◆勤務時間帯 朝（7～12）' => substr_count($arr_db['work_time_view'], ',1,') ? '表示' : '表示しない', '◆勤務時間帯 昼（12～17）' => substr_count($arr_db['work_time_view'], ',2,') ? '表示' : '表示しない', '◆勤務時間帯 夕方・夜（17～22）' => substr_count($arr_db['work_time_view'], ',3,') ? '表示' : '表示しない', '◆勤務時間帯 深夜・早朝（22～7）' => substr_count($arr_db['work_time_view'], ',4,') ? '表示' : '表示しない', '▲週あたり最低勤務日数' => (int) $arr_db['work_day_week'] . '日', '●勤務曜日・時間' => $arr_db['work_time_des'], '文字_11' => $def, '▲資格' => $arr_db['qualification'], '文字_12' => $def, '●採用予定人数CD' => Constants::$employment_people[$arr_db['employment_people'] == 0 ? '' : $arr_db['employment_people']], '◆採用予定人数指定' => $arr_db['employment_people_num'], '▲採用予定人数本文' => $arr_db['employment_people_des'], '文字_13' => $def, '●勤務期間CD' => Constants::$work_period[$arr_db['work_period'] == 0 ? '' : $arr_db['work_period']], '▲勤務期間本文_入力欄' => self::get_field_json('▲勤務期間本文_入力欄', $arr_json), '紹介予定派遣の場合' => $arr_db['employment_type'] == '9' ? '※紹介予定派遣は派遣先と本人の同意が得られた場合のみ紹介/派遣期間：最長6ヵ月' : '', '▲勤務期間本文＋紹介予定派遣' => self::get_field_json('▲勤務期間本文＋紹介予定派遣', $arr_json), '文字_14' => $def, '▲募集追加（1）見出し' => $arr_rec['0']['sub_title'], '文字_15' => $def, '待遇' => $arr_rec['0']['text'], '文字_16' => $def, '▲募集追加（2）見出し' => $arr_rec['1']['sub_title'], '文字_17' => $def, '◆募集追加（2）本文' => $arr_rec['1']['text'], '文字_18' => $def, '▲募集追加（3）見出し' => $arr_rec['2']['sub_title'], '文字_19' => $def, '◆募集追加（3）本文' => $arr_rec['2']['text'], '文字_20' => $def, '▲募集追加（4）見出し' => $arr_rec['3']['sub_title'], '文字_21' => $def, '◆募集追加（4）本文' => $arr_rec['3']['text'], '文字_22' => $def, '▲募集追加（5）見出し' => $arr_rec['4']['sub_title'], '文字_23' => $def, '◆募集追加（5）本文' => $arr_rec['4']['text'], '文字_24' => $def, '▲募集追加（6）見出し' => $arr_rec['5']['sub_title'], '文字_25' => $def, '◆募集追加（6）本文' => $arr_rec['5']['text'], '文字_26' => $def, '▲募集追加（7）見出し' => $arr_rec['6']['sub_title'], '文字_27' => $def, '◆募集追加（7）本文' => $arr_rec['6']['text'], '文字_28' => $def, '▲募集追加（8）見出し' => $arr_rec['7']['sub_title'], '文字_29' => $def, '◆募集追加（8）本文' => $arr_rec['7']['text'], '文字_30' => $def, '▲募集追加（9）見出し' => $arr_rec['8']['sub_title'], '文字_31' => $def, '◆募集追加（9）本文' => $arr_rec['8']['text'], '文字_32' => $def, '募集情報合計行数' => $def, '●仕事内容' => $arr_db['job_description'], '文字_33' => $def, '▲仕事追加（1）見出し' => $arr_add['0']['sub_title'], '文字_34' => $def, '◆仕事追加（1）本文' => $arr_add['0']['text'], '文字_35' => $def, '▲仕事追加（2）見出し' => $arr_add['1']['sub_title'], '文字_36' => $def, '◆仕事追加（2）本文' => $arr_add['1']['text'], '文字' => $def, '▲仕事追加（3）見出し' => $arr_add['2']['sub_title'], '文字_51' => $def, '◆仕事追加（3）本文' => $arr_add['2']['text'], '文字_37' => $def, '▲仕事追加（4）見出し' => $arr_add['3']['sub_title'], '文字_38' => $def, '◆仕事追加（4）本文' => $arr_add['3']['text'], '文字_39' => $def, '仕事情報合計行数' => $def, '●事業内容' => $arr_db['business_description'], '文字_40' => $def, '▲面接地・他タイトル' => self::get_field_json('▲面接地・他タイトル', $arr_json), '文字_41' => $def, '面接地' => $arr_db['interview_location'], '▲（面）地図補足' => self::get_field_json('▲（面）地図補足', $arr_json), '文字_42' => $def, '●応募方法' => self::get_field_json('●応募方法', $arr_json), '●応募後のプロセス' => self::get_field_json('●応募後のプロセス', $arr_json), '文字_43' => $def, '◆携帯版電話応募ボタンCD' => self::get_field_json('◆携帯版電話応募ボタンCD', $arr_json), '●代表電話（1）名称' => $arr_db['phone_name1'], '文字_44' => $def, '●代表電話（1）（市外局番）' => isset($arr_phone_number['0']) ? (string) $arr_phone_number['0'] : '', '●代表電話（1）（市内局番）' => isset($arr_phone_number['1']) ? (string) $arr_phone_number['1'] : '', '●代表電話（1）（加入者番号）' => isset($arr_phone_number['2']) ? (string) $arr_phone_number['2'] : '', '▲代表電話（2）名称' => self::get_field_json('▲代表電話（2）名称', $arr_json), '文字_45' => $def, '▲代表電話（2）（市外局番）' => self::get_field_json('▲代表電話（2）（市外局番）', $arr_json), '◆代表電話（2）（市内局番）' => self::get_field_json('◆代表電話（2）（市内局番）', $arr_json), '◆代表電話（2）（加入者番号）' => self::get_field_json('◆代表電話（2）（加入者番号）', $arr_json), '▲問合せ補足' => self::get_field_json('▲問合せ補足', $arr_json), '文字_46' => $def, '●WEB応募受付CD' => self::get_field_json('●WEB応募受付CD', $arr_json), '応募先' => self::get_field_json('応募先', $arr_json), '◆応募シートタイプCD' => self::get_field_json('◆応募シートタイプCD', $arr_json), '▲応募シート自由質問' => self::get_field_json('▲応募シート自由質問', $arr_json), '文字_47' => $def, '◆自動返信メールCD' => self::get_field_json('◆自動返信メールCD', $arr_json), '◆自動返信メール件名' => self::get_field_json('◆自動返信メール件名', $arr_json), '文字_48' => $def, '◆自動返信メール本文' => self::get_field_json('◆自動返信メール本文', $arr_json), '文字_49' => $def, '交通費支給' => substr_count($arr_db['trouble'], ',23,') ? $trouble_check : '', 'シフト制' => substr_count($arr_db['trouble'], ',24,') ? $trouble_check : '', '社員登用あり' => substr_count($arr_db['trouble'], ',25,') ? $trouble_check : '', 'オープニング' => substr_count($arr_db['trouble'], ',26,') ? $trouble_check : '', '駅チカ･駅ナカ' => substr_count($arr_db['trouble'], ',1,') ? $trouble_check : '', '車・バイクOK' => substr_count($arr_db['trouble'], ',2,') ? $trouble_check : '', '未経験OK' => substr_count($arr_db['trouble'], ',3,') ? $trouble_check : '', '大学生歓迎' => substr_count($arr_db['trouble'], ',4,') ? $trouble_check : '', 'まかない・食事' => substr_count($arr_db['trouble'], ',5,') ? $trouble_check : '', '服装自由' => substr_count($arr_db['trouble'], ',6,') ? $trouble_check : '', '高校生可' => substr_count($arr_db['trouble'], ',7,') ? $trouble_check : '', '髪型自由' => substr_count($arr_db['trouble'], ',8,') ? $trouble_check : '', '日払い・週払い' => substr_count($arr_db['trouble'], ',9,') ? $trouble_check : '', '土日祝日のみ' => substr_count($arr_db['trouble'], ',10,') ? $trouble_check : '', '即日勤務OK' => substr_count($arr_db['trouble'], ',11,') ? $trouble_check : '', 'フリーター歓迎' => substr_count($arr_db['trouble'], ',12,') ? $trouble_check : '', '高収入' => substr_count($arr_db['trouble'], ',13,') ? $trouble_check : '', '英語を使う' => substr_count($arr_db['trouble'], ',14,') ? $trouble_check : '', '主婦・主夫歓迎' => substr_count($arr_db['trouble'], ',15,') ? $trouble_check : '', '副業OK' => substr_count($arr_db['trouble'], ',16,') ? $trouble_check : '', 'こだわり条件数' => $def, '●プレビューアクセス番号（市外局番）' => self::get_field_json('プレビューアクセス番号（市外局番）', $arr_json), '●プレビューアクセス番号（市内局番）' => self::get_field_json('●プレビューアクセス番号（市内局番）', $arr_json), '●プレビューアクセス番号（加入者番号）' => self::get_field_json('●プレビューアクセス番号（加入者番号）', $arr_json));
}
public function update_csv($file)
{
$data = $this->get_file_csv($file);
//array_shift($data);
if (!count($data)) {
return false;
}
$model_job = new Model_Job();
$model_add = new Model_Jobadd();
$model_rec = new Model_Jobrecruit();
$k = 1;
\DB::start_transaction();
$check = true;
$no_update = array();
try {
foreach ($data as $row) {
if (!$check) {
break;
}
$data = self::data_once_csv($row);
$validate_field = $this->validate($data['job'], $data['job_add'], $data['job_rec'], $k);
$res = $model_job->update_data_csv($data['job'], $data['job']['job_id'], $validate_field, $no_update, $k);
if ($res === -1) {
$this->error[$k]['job_id'] = $k . '行目:求人情報が存在していません。';
$check = false;
} else {
if ($res && $validate_field) {
$res_delete_add = $model_add->delete_data($data['job']['job_id']);
if ($res_delete_add >= 0) {
if (count($data['job_add']) && !$model_add->insert_multi_data($data['job_add'], $model_job)) {
$check = false;
}
}
$res_delete_rec = $model_rec->delete_data($data['job']['job_id']);
if ($res_delete_rec >= 0) {
if (count($data['job_rec']) && !$model_rec->insert_multi_data($data['job_rec'], $model_job)) {
$check = false;
}
}
} else {
$check = false;
}
}
++$k;
}
if (!$check) {
\DB::rollback_transaction();
} else {
\DB::commit_transaction();
}
} catch (Exception $e) {
// rollback pending transactional queries
\DB::rollback_transaction();
throw $e;
}
$this->no_update = $no_update;
return $check;
}
public function approve_data($id)
{
try {
$obj = static::forge()->find_by_pk($id);
$data = array();
if (count($obj)) {
$data_old = $obj->_data;
$data_job_add = array();
$data_job_rec = array();
if ($data_old['edit_data']) {
$data = json_decode($data_old['edit_data'], true);
if (!Model_Sssale::find_by_pk($data['sssale_id'])) {
return 0;
}
$data_job_add = Utility::set_data_job_add_recruit($data, $id);
$data_job_rec = Utility::set_data_job_add_recruit($data, $id, 'job_recruit_sub_title', 'job_recruit_text');
$data = Utility::set_standard_data_job($data, true, $this->_data_default);
} else {
$data['updated_at'] = date('Y-m-d H:i');
$data['status'] = 1;
$obj->set($data);
$obj->is_new(false);
return (bool) $obj->save();
}
DB::start_transaction();
$data['is_available'] = $data_old['is_available'];
$data['status'] = 1;
$data['edit_data'] = null;
$obj->set($data);
$obj->is_new(false);
$res = (bool) $obj->save();
if ($res) {
$obj_add = new Model_Jobadd();
$obj_rec = new Model_Jobrecruit();
$res_flag = false;
if ($obj_add->delete_data($id) >= 0) {
$res_flag = true;
}
if ($res_flag && $obj_add->insert_multi_data($data_job_add, $this) === false) {
$res_flag = false;
}
if ($res_flag && $obj_rec->delete_data($id) >= 0) {
$res_flag = true;
} else {
$res_flag = false;
}
if ($res_flag && $obj_rec->insert_multi_data($data_job_rec, $this) === false) {
$res_flag = false;
}
if ($res_flag) {
\DB::commit_transaction();
return true;
} else {
\DB::rollback_transaction();
return false;
}
}
return false;
}
return false;
} catch (Exception $e) {
\DB::rollback_transaction();
throw $e;
return false;
}
}