<?php /********************************************************** * File : reserve_base_data_relation.php * 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(); $oMgr->sessionStart(); $sql = "\nSELECT\n user_id,\n staff_id,\n staff_id_flg,\n kanjisei,\n kanjimei,\n kanasei,\n kanamei,\n eijisei,\n eijimei,\n kanjisei_real,\n kanjimei_real,\n kanasei_real,\n kanamei_real,\n kyusei,\n sex,\n date_part('year', birthday) AS birth_year,\n date_part('month', birthday) AS birth_mon,\n date_part('day', birthday) AS birth_day,\n belong_chg_id,\n post_id,\n job_id,\n naisen,\n pbno,\n joukin_kbn,\n note,\n make_id,\n update_id,\n TO_CHAR(retire_date, 'YYYY/MM/DD') AS retire_date\nFROM\n user_base_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) { $aryTmp = $oMgr->getSubBelongData($aryData['user_id'], true); if (is_array($aryTmp)) { foreach ($aryTmp as $no => $data) { $aryData['sub_belong_chg_id'][$no] = $data['sub_belong_chg_id']; } } $aryTmp = $oMgr->getSubJobData($aryData['user_id'], true); if (is_array($aryTmp)) { foreach ($aryTmp as $no => $data) { $aryData['sub_job_id'][$no] = $data['sub_job_id']; } } $aryTmp = $oMgr->getSubPostData($aryData['user_id'], true); if (is_array($aryTmp)) {