} // 非常勤の場合役職コードに文字列を付与(特殊処理) if ($fields[$key] == "hjksyk_skin_cde") { if ($joukin_kbn == JOUKIN_KBN_PARTTIME) { $val = "HJK_" . $val; } } // 掛講座が「000000」の場合、空にする if ($fields[$key] == "kkrkoza_cde") { if ($val == "000000") { $val = ""; } } $vals[$fields[$key]] = $val; } $sqlCshainno = $oMgr->sqlItemChar($vals['cshainno']); $sqlCnameknj = $oMgr->sqlItemChar($vals['cnameknj']); $sqlDbirthDte = $oMgr->sqlItemChar($vals['dbirth_dte']); $sqlSeibetuKbn = $oMgr->sqlItemChar($vals['seibetu_kbn']); // 共通WHERE句 $where1 = <<<SQL WHERE staff_id = {$sqlCshainno}; SQL; $where2 = <<<SQL WHERE kanjisei || ' ' || kanjimei = {$sqlCnameknj}; SQL; $where3 = <<<SQL WHERE kanjisei || ' ' || kanjimei = {$sqlCnameknj} and
} // 非常勤の場合役職コードに文字列を付与(特殊処理) if ($fields[$key] == "hjksyk_skin_cde") { if ($joukin_kbn == JOUKIN_KBN_PARTTIME) { $val = "HJK_" . $val; } } // 掛講座が「000000」の場合、空にする if ($fields[$key] == "kkrkoza_cde") { if ($val == "000000") { $val = ""; } } $vals[$fields[$key]] = $val; } $sqlCshainno = $oMgr->sqlItemChar($vals['cshainno']); $sqlCnameknj = $oMgr->sqlItemChar($vals['cnameknj']); $sqlCnamekna = $oMgr->sqlItemChar($vals['cnamekna']); $sqlDbirthDte = $oMgr->sqlItemChar($vals['dbirth_dte']); $sqlSeibetuKbn = $oMgr->sqlItemChar($vals['seibetu_kbn']); // 旧姓姓 $aryKyusei = explode(" ", $vals['kyu_kj_nme']); $sqlKyuKjSei = $oMgr->sqlItemChar($aryKyusei[0]); // カナ名 $aryCnameKna = explode(" ", $vals['cnamekna']); $sqlCnameknamei = $oMgr->sqlItemChar($aryCnameKna[1]); // 共通WHERE句 $where1 = <<<SQL WHERE staff_id = {$sqlCshainno}; SQL;
if ($fields[$key] == "hjksyk_skin_cde") { if ($joukin_kbn == JOUKIN_KBN_PARTTIME) { $val = "HJK_" . $val; } } // 掛講座が「000000」の場合、空にする if ($fields[$key] == "kkrkoza_cde") { if ($val == "000000") { $val = ""; } } $vals[$fields[$key]] = $val; } $cnameknjArray = explode(" ", $vals['cnameknj']); $cnameknaArray = explode(" ", $vals['cnamekna']); $sqlKanjisei = $oMgr->sqlItemChar($cnameknjArray[0]); $sqlKanjimei = $oMgr->sqlItemChar($cnameknjArray[1]); $sqlKanasei = $oMgr->sqlItemChar($cnameknaArray[0]); $sqlKanamei = $oMgr->sqlItemChar($cnameknaArray[1]); if ($vals['seibetu_kbn'] == 1) { $sqlSeibetuKbn = $oMgr->sqlItemChar("0"); } else { $sqlSeibetuKbn = $oMgr->sqlItemChar("1"); } $sqlDbirthDte = $oMgr->sqlItemChar($vals['dbirth_dte']); $sqlBelongChgId = $oMgr->sqlItemChar($vals['kkrkoza_cde']); if ($vals['kkrkoza_cde'] == "") { $sqlBelongChgId = $oMgr->sqlItemChar($vals['szk_cde']); } if ($joukin_kbn == JOUKIN_KBN_FULLTIME) { $sqlPostId = $oMgr->sqlItemChar($vals['syksy_cde']);
$val = str_replace(" ", " ", $val); } // 非常勤の場合役職コードに文字列を付与(特殊処理) if ($fields[$key] == "hjksyk_skin_cde") { if ($joukin_kbn == JOUKIN_KBN_PARTTIME) { $val = "HJK_" . $val; } } $vals[$fields[$key]] = $val; } // // 既存か新規かチェック // if ($cshainno != "") { $err_msg = "[社員番号:" . $cshainno . "]"; $sql = "select * from idodata where cshainno = " . $oMgr->sqlItemChar($cshainno); $aryRet = $oMgr->oDb->getRow($sql); $user_id = $aryRet['user_id']; if ($aryRet['cshainno'] != "") { // 変更があるかチェック $has_change_data = false; foreach ($fields as $key => $col) { if ($aryRet[$col] != $vals[$col]) { // あり $has_change_data = true; break; } } $sql = "update idodata set update_time = now()"; if ($has_change_data) { // 変更がある場合はデータ更新+処理状況=更新あり(1)に変更
$cnt++; if ($cnt == 1) { // 1行目はタイトル continue; } $aryBody = explode(",", $body); $user_exists = false; $vals = array(); foreach ($aryBody as $key => $val) { $val = trim($val); $val = trim($val, "\""); $vals[$fields[$key]] = $val; } //echo $vals['cshainno'];///////////////////////////////////////////////////test//////////////// //echo $vals['cnameknj'];///////////////////////////////////////////////////test//////////////// $sqlCshainno = $oMgr->sqlItemChar($vals['cshainno']); $sqlCnameknj = $oMgr->sqlItemChar($vals['cnameknj']); // 共通WHERE句 $where1 = <<<SQL WHERE staff_id = {$sqlCshainno}; SQL; $where2 = <<<SQL WHERE kanjisei || ' ' || kanjimei = {$sqlCnameknj}; SQL; $where3 = <<<SQL WHERE kanjisei || ' ' || kanjimei = {$sqlCnameknj} and staff_id = {$sqlCshainno}; SQL;
} // 非常勤の場合役職コードに文字列を付与(特殊処理) if ($fields[$key] == "hjksyk_skin_cde") { if ($joukin_kbn == JOUKIN_KBN_PARTTIME) { $val = "HJK_" . $val; } } // 掛講座が「000000」の場合、空にする if ($fields[$key] == "kkrkoza_cde") { if ($val == "000000") { $val = ""; } } $vals[$fields[$key]] = $val; } $sqlCshainno = $oMgr->sqlItemChar($vals['cshainno']); // 共通WHERE句 $where = <<<SQL WHERE retire_fin_flg = '0' and cshainno = {$sqlCshainno}; SQL; // 職員番号がなければ取り込めない(暫定) if ($vals['cshainno'] == "") { continue; } // 所属、職種等のコードを補完 if ($vals['szk_nme'] != "") { $sql = "select belong_sec_code from belong_sec_mst where blong_sec_name = " . $oMgr->sqlItemChar($vals['szk_nme']) . " and del_flg = '0'"; $vals['szk_cde'] = $oMgr->oDb->getOne($sql); }