}
// 非常勤の場合役職コードに文字列を付与（特殊処理）
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) {
// 変更がある場合はデータ更新＋処理状況＝更新あり（１）に変更
$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);
}
