{$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; if ($user_id != "") { // 既存 $ret = $oMgr->updateUserBaseData($request); if (!$ret) { echo $err_msg . "利用者基本情報更新に失敗しました。"; $has_error = true; continue; } $ret = $oMgr->updateUserNcvcData($request); if (!$ret) { echo $err_msg . "利用者NCVC情報更新に失敗しました。"; $has_error = true; continue; } } else { // 新規 $ret = $oMgr->insertUserData(&$request); if (!$ret) { echo $err_msg . "利用者情報新規登録に失敗しました。"; $has_error = true; continue; } // 中間テーブルのユーザIDを更新 $sql = "update idodata set user_id = " . $request['user_id'] . $where;
* Last Update : 2013.01.10 * Copyright : ***********************************************************/ set_include_path('.:/usr/share/pear:/var/www/phplib'); require_once "mgr/users_detail_mgr.class.php"; $oMgr = new users_detail_mgr(); $oMgr->sessionStart(); $sql = "\nSELECT\n user_id,\n login_id,\n login_passwd,\n eijisei,\n eijimei,\n mail_disused_flg,\n mail_acc,\n TO_CHAR(start_date, 'YYYY/MM/DD') AS start_date,\n TO_CHAR(end_date, 'YYYY/MM/DD') AS end_date,\n garoon_disused_flg,\n mlist_disused_flg,\n update_id\nFROM\n user_ncvc_reserve\nWHERE\n complete_flg = '0' AND\n reflect_date <= now()::date\n"; $aryRsv = $oMgr->oDb->getAll($sql); if (is_array($aryRsv)) { foreach ($aryRsv as $aryData) { $aryData['password'] = $oMgr->passwordDecrypt($aryData['password']); $aryTmp = $oMgr->getRoleData($aryData['user_id'], true); $aryData['user_type_id'] = $aryTmp['user_type_id']; $aryData['user_role_id'] = $aryTmp['user_role_id']; $_SESSION['LOGIN_USER_ID'] = $aryData['update_id']; // 更新 $ret = $oMgr->updateUserNcvcData($aryData); if (!$ret) { Debug_Trace("NCVC予約データ反映に失敗しました。", 721); Debug_Trace($aryData); exit; } $oMgr->oDb->begin(); // 完了フラグ1を立てる $sql = "UPDATE user_ncvc_reserve SET complete_flg = '1' WHERE user_id = " . $aryData['user_id']; $oMgr->oDb->query($sql); $oMgr->oDb->end(); } } exit;