Exemplos de users_detail_mgr::getSubJobData em PHP

Exemplo n.º 1

Arquivo: reserve_base_data_relation.php Projeto: honda-kyoto/UMS-Kyoto

***********************************************************/
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)) {
            foreach ($aryTmp as $no => $data) {
                $aryData['sub_post_id'][$no] = $data['sub_post_id'];
            }
        }
        $aryTmp = $oMgr->getSubStaffIdData($aryData['user_id'], true);
        if (is_array($aryTmp)) {
            foreach ($aryTmp as $no => $data) {
                $aryData['sub_staff_id'][$no] = $data['sub_staff_id'];