echo "---" . $line . "件目---\n"; echo "利用者ID:" . $aryExt['user_id']; echo "\n"; foreach ($fields_value as $key => $title) { echo $title . ":" . $aryExt[$key]; echo "\n"; } } echo "---以上" . $line . "件---\n\n"; } $dir = "import/"; $ido_file = 'idodata.csv'; $fields_value = array('cteiinkb' => '定員区分', 'cteiinnm' => '定員区分名称', 'cshainno' => '職員番号', 'dhtreingb_dte' => '発令年月日(西暦)', 'nnmn_ido_cde' => '任免異動種目コード', 'nnmn_ido_nme' => '任免異動種目', 'cnamekna' => 'カナ氏名', 'cnameknj' => '漢字氏名', 'kyu_kn_nme' => '旧姓使用カナ氏名', 'kyu_kj_nme' => '旧姓使用漢字氏名', 'seibetu_kbn' => '性別区分', 'seibetu_nme' => '性別', 'dbirth_dte' => '生年月日(西暦)', 'dsaiyo_dte' => '国家公務員採用日(西暦)', 'dninyo_dte' => '任用年月日(西暦)', 'kkn_cde' => '機関コード', 'kkn_nme' => '機関名称', 'szk_cde' => '所属コード', 'szk_nme' => '所属名称', 'bkyk_cde' => '部局コード', 'bkyk_nme' => '部局名称', 'kkrkoza_cde' => '掛・講座コード', 'kkrkoza_nme' => '掛・講座名称', 'knmei_cde' => '官名コード', 'knmei_nme' => '官名名称', 'syksy_cde' => '職種コード', 'syksy_nme' => '職種名称', 'hjksyk_skin_cde' => '非常勤職員職員コード', 'hjksyk_skin_nme' => '非常勤職員職員', 'hjksyk_misy_cde' => '非常勤職員名称コード', 'hjksyk_misy_nme' => '非常勤職員名称', 'dnnki_mr_dte' => '任期満了年月日(西暦)', 'djosin_prt_dte' => '上申書印刷日(西暦)', 'djirei_prt_dte' => '辞令印刷日(西暦)', 'getuji_flg' => '月次更新フラグ'); $fields = array_keys($fields_value); $has_error = false; $oMgr = new users_detail_mgr(); // // ファイルをチェック // if ($data = file_get_contents($dir . $ido_file, FILE_USE_INCLUDE_PATH)) { //ここから削除 // // 未存在チェックフラグを一旦1に更新(退職処理済みは除く) // $sql = "update idodata set notexist_flg = '1' where retire_fin_flg = '0'"; // // $ret = $oMgr->oDb->query($sql); // // if (!$ret) // { // echo "初期処理に失敗しました。"; // exit; // }
<?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)) {
/********************************************************** * File : retry_user_ad_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"; require_once "sql/users_detail_sql.inc.php"; $dir = "import/"; $ido_file = 'idodata.csv'; $fields = array('cteiinkb', 'cteiinnm', 'cshainno', 'dhtreingb_dte', 'nnmn_ido_cde', 'nnmn_ido_nme', 'cnamekna', 'cnameknj', 'kyu_kn_nme', 'kyu_kj_nme', 'seibetu_kbn', 'seibetu_nme', 'dbirth_dte', 'dsaiyo_dte', 'dninyo_dte', 'kkn_cde', 'kkn_nme', 'szk_cde', 'szk_nme', 'bkyk_cde', 'bkyk_nme', 'kkrkoza_cde', 'kkrkoza_nme', 'knmei_cde', 'knmei_nme', 'syksy_cde', 'syksy_nme', 'hjksyk_skin_cde', 'hjksyk_skin_nme', 'hjksyk_misy_cde', 'hjksyk_misy_nme', 'dnnki_mr_dte', 'djosin_prt_dte', 'djirei_prt_dte', 'getuji_flg'); $has_error = false; $oMgr = new users_detail_mgr(); // // ファイルをチェック // if ($data = file_get_contents($dir . $ido_file, FILE_USE_INCLUDE_PATH)) { // 未存在チェックフラグを一旦1に更新(退職処理済みは除く) $sql = "update idodata set notexist_flg = '1' where retire_fin_flg = '0'"; $ret = $oMgr->oDb->query($sql); if (!$ret) { echo "初期処理に失敗しました。"; exit; } $data = mb_convert_encoding($data, "UTF-8", "SJIS, sjis-win"); $aryData = explode("\n", $data); $cnt = 0; foreach ($aryData as $body) {
/********************************************************** * File : ido_data_import.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"; require_once "sql/users_detail_sql.inc.php"; $dir = "import/"; $ido_file = 'idodata_update2.csv'; $fields_value = array('cteiinkb' => '定員区分', 'cteiinnm' => '定員区分名称', 'cshainno' => '職員番号', 'dhtreingb_dte' => '発令年月日(西暦)', 'nnmn_ido_cde' => '任免異動種目コード', 'nnmn_ido_nme' => '任免異動種目', 'cnamekna' => 'カナ氏名', 'cnameknj' => '漢字氏名', 'kyu_kn_nme' => '旧姓使用カナ氏名', 'kyu_kj_nme' => '旧姓使用漢字氏名', 'seibetu_kbn' => '性別区分', 'seibetu_nme' => '性別', 'dbirth_dte' => '生年月日(西暦)', 'dsaiyo_dte' => '国家公務員採用日(西暦)', 'dninyo_dte' => '任用年月日(西暦)', 'kkn_cde' => '機関コード', 'kkn_nme' => '機関名称', 'szk_cde' => '所属コード', 'szk_nme' => '所属名称', 'bkyk_cde' => '部局コード', 'bkyk_nme' => '部局名称', 'kkrkoza_cde' => '掛・講座コード', 'kkrkoza_nme' => '掛・講座名称', 'knmei_cde' => '官名コード', 'knmei_nme' => '官名名称', 'syksy_cde' => '職種コード', 'syksy_nme' => '職種名称', 'hjksyk_skin_cde' => '非常勤職員職員コード', 'hjksyk_skin_nme' => '非常勤職員職員', 'hjksyk_misy_cde' => '非常勤職員名称コード', 'hjksyk_misy_nme' => '非常勤職員名称', 'dnnki_mr_dte' => '任期満了年月日(西暦)', 'djosin_prt_dte' => '上申書印刷日(西暦)', 'djirei_prt_dte' => '辞令印刷日(西暦)', 'getuji_flg' => '月次更新フラグ'); $fields = array_keys($fields_value); $has_error = false; $oMgr = new users_detail_mgr(); // // ファイルをチェック // if ($data = file_get_contents($dir . $ido_file, FILE_USE_INCLUDE_PATH)) { $data = mb_convert_encoding($data, "UTF-8", "SJIS, sjis-win"); $aryData = explode("\n", $data); $cnt = 0; foreach ($aryData as $body) { $cnt++; if ($cnt == 1) { // 1行目はタイトル continue; } if ($body == "") { // 空行
echo "---" . $line . "件目---\n"; echo "利用者ID:" . $aryExt['user_id']; echo "\n"; foreach ($fields_value as $key => $title) { echo $title . ":" . $aryExt[$key]; echo "\n"; } } echo "---以上" . $line . "件---\n\n"; } $dir = "import/"; $ido_file = 'king.csv'; $fields_value = array('cshainno' => '職員ID', 'ckaishibi' => '有効開始日', 'csyuryou' => '有効終了日', 'cactive' => 'アクティブフラグ', 'cnameknj' => '職員名'); $fields = array_keys($fields_value); $has_error = false; $oMgr = new users_detail_mgr(); // // ファイルをチェック // if ($data = file_get_contents($dir . $ido_file, FILE_USE_INCLUDE_PATH)) { $data = mb_convert_encoding($data, "UTF-8", "SJIS, sjis-win"); $aryData = explode("\n", $data); $cnt = 0; foreach ($aryData as $body) { $cnt++; if ($cnt == 1) { // 1行目はタイトル continue; } $aryBody = explode(",", $body); $user_exists = false;
/********************************************************** * File : daily_data_import.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"; require_once "sql/users_detail_sql.inc.php"; $dir = "import/"; $ido_file = $argv[1]; $fields_value = array('cteiinkb' => '定員区分', 'cteiinnm' => '定員区分名称', 'cshainno' => '職員番号', 'dhtreingb_dte' => '発令年月日(西暦)', 'nnmn_ido_cde' => '任免異動種目コード', 'nnmn_ido_nme' => '任免異動種目', 'cnamekna' => 'カナ氏名', 'cnameknj' => '漢字氏名', 'kyu_kn_nme' => '旧姓使用カナ氏名', 'kyu_kj_nme' => '旧姓使用漢字氏名', 'seibetu_kbn' => '性別区分', 'seibetu_nme' => '性別', 'dbirth_dte' => '生年月日(西暦)', 'dsaiyo_dte' => '国家公務員採用日(西暦)', 'dninyo_dte' => '任用年月日(西暦)', 'kkn_cde' => '機関コード', 'kkn_nme' => '機関名称', 'szk_cde' => '所属コード', 'szk_nme' => '所属名称', 'bkyk_cde' => '部局コード', 'bkyk_nme' => '部局名称', 'kkrkoza_cde' => '掛・講座コード', 'kkrkoza_nme' => '掛・講座名称', 'knmei_cde' => '官名コード', 'knmei_nme' => '官名名称', 'syksy_cde' => '職種コード', 'syksy_nme' => '職種名称', 'hjksyk_skin_cde' => '非常勤職員職員コード', 'hjksyk_skin_nme' => '非常勤職員職員', 'hjksyk_misy_cde' => '非常勤職員名称コード', 'hjksyk_misy_nme' => '非常勤職員名称', 'dnnki_mr_dte' => '任期満了年月日(西暦)', 'djosin_prt_dte' => '上申書印刷日(西暦)', 'djirei_prt_dte' => '辞令印刷日(西暦)', 'getuji_flg' => '月次更新フラグ'); $fields = array_keys($fields_value); $has_error = false; $oMgr = new users_detail_mgr(); // // ファイルをチェック // if ($data = file_get_contents($dir . $ido_file, FILE_USE_INCLUDE_PATH)) { $data = mb_convert_encoding($data, "UTF-8", "SJIS, sjis-win"); $aryData = explode("\n", $data); $cnt = 0; foreach ($aryData as $body) { $cnt++; if ($cnt == 1) { // 1行目はタイトル continue; } $aryBody = explode(",", $body); $user_exists = false;
<?php /********************************************************** * File : reserve_his_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(); $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'];
<?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 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を立てる