(select post_id from post_mst where post_code = {$post_code_nm}) as post_id, (select job_id from job_mst where job_code = {$job_code_nm}) as job_id, '{$joukin_kbn}' as joukin_kbn, '1' as user_type_id, to_char(now(),'yyyy/MM/dd hh24:mm:ss') as start_date FROM idodata {$where} SQL; $request = $oMgr->oDb->getRow($sql); list($y, $m, $d) = explode("/", $request['birthday']); $request['birth_year'] = $y; $request['birth_mon'] = $m; $request['birth_day'] = $d; // 新規 $ret = $oMgr->insertUserData(&$request); if (!$ret) { echo $err_msg . "利用者情報新規登録に失敗しました。"; continue; } // 中間テーブルのユーザIDを更新 $sql = "update idodata set user_id = " . $request['user_id'] . $where; $ret = $oMgr->oDb->query($sql); if (!$ret) { echo "中継テーブルの更新に失敗しました。\n"; continue; } //職員番号でも氏名でも一致しなかった場合は、新規登録 $message = "新規登録:" . "[職員番号:" . $vals['cshainno'] . "、氏名:" . $vals['cnameknj'] . "、生年月日:" . $vals['dbirth_dte'] . "、性別:" . $vals['seibetu_nme'] . "]"; echo $message . PHP_EOL; file_put_contents("/var/www/phplib/import/" . "sinki_toroku.csv", $body, FILE_APPEND);