* Authors : mie tsutsui * Date : 2013.01.10 * 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(); $sql = "\nSELECT\n user_id,\n list_no,\n staffcode,\n wardcode,\n professioncode,\n gradecode,\n kananame,\n kanjiname,\n password,\n TO_CHAR(validstartdate, 'YYYY/MM/DD') AS validstartdate,\n TO_CHAR(validenddate, 'YYYY/MM/DD') AS validenddate,\n deptcode,\n appcode,\n deptgroupcode,\n history_note,\n his_history_kbn,\n make_id,\n update_id\nFROM\n user_his_reserve\nWHERE\n del_flg = '0' AND\n send_date <= now()::date\n"; $aryRsv = $oMgr->oDb->getAll($sql); if (is_array($aryRsv)) { foreach ($aryRsv as $aryData) { $aryData['edit_mode'] = ""; $aryData['immediate_flg'] = "1"; if ($aryData['password'] != "") { $aryData['password'] = $oMgr->passwordDecrypt($aryData['password']); } // 更新 $ret = $oMgr->updateUserHisData($aryData); if (!$ret) { Debug_Trace("HIS連携予約データ反映に失敗しました。", 521); Debug_Trace($aryData); exit; } $oMgr->oDb->begin(); // 削除フラグ1を立てる $sql = "UPDATE user_his_reserve SET del_flg = '1' WHERE user_id = " . $aryData['user_id'] . " AND list_no = " . $aryData['list_no']; $oMgr->oDb->query($sql); $oMgr->oDb->end(); } }