CON008_1.php 20.6 KB
<?php 
//*****************************************************************************
//* 
//* プログラム名:社員情報入力画面(新規・修正併用)
//* プログラムID:CON008_1
//* 機能        :社員情報を入力する
//* 作成者      :
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//***************************
//* インクルードファイル
//***************************
include("./include/session_start.inc");			//セッション開始
include("./include/SessionChk.inc");				//セッションチェック
include("./include/dbcon.inc");							//DB接続

//***************************
//* 画面制御
//***************************
include("./inc/header.inc");								//
include("./include/input_chk.inc");					//
include("./inc/CON008_1.inc");                //
include("menu_opacity.php");								//メニュー

$strSyainCode     = "";		//社員コード
$strSyainId       = "";		//社員ID
$strSyainPwd      = "";		//パスワード
$strNameSeiKj     = "";		//姓漢字
$strNameMeiKj     = "";		//名漢字
$strNameSeiKn     = "";		//姓カナ
$strNameMeiKn     = "";		//名カナ
$strSex           = "t";	//性別
$strBirthDateY    = "";		//生年月日年
$strBirthDateM    = "";		//生年月日月
$strBirthDateD    = "";		//生年月日日
$strNyusyaDateY   = "";		//入社年月日年
$strNyusyaDateM   = "";		//入社年月日月
$strNyusyaDateD   = "";		//入社年月日日
$strMailAdrAcount = "";		//メールアドレスアカウント
$strMailAdrDomain = "";		//メールアドレスドメイン
$strNaisen        = "";		//内線番号
$strYubinMae      = "";		//郵便番号前
$strYubinAto      = "";		//郵便番号後
$strJyusyoSikugun = "";		//住所(市区郡)
$strJyusyoBanti   = "";		//住所(町名・番地)
$strJyusyoApart   = "";		//住所(アパート)
$strTellSigai     = "";		//電話(市外)
$strTellSinai     = "";		//電話(市内)
$strTellKyoku     = "";		//電話(局番)
$strKeitai1       = "";		//携帯電話
$strKeitai2       = "";		//携帯電話
$strKeitai3       = "";		//携帯電話

$strSql = "SELECT syuugyou_type,type_name ";
$strSql = $strSql."FROM mst_syuugyou_type ORDER BY disp_rank";
$rsSyuugyouRecset = pg_exec($pg_con,$strSql);
$intSyuugyouRsCnt = pg_numrows($rsSyuugyouRecset);

$strSql = "SELECT syozoku_cd,bumon_name ";
$strSql = $strSql."FROM mst_bumon Where del_flg=0 ORDER BY disp_rank";
$rsBumonRecset = pg_exec($pg_con,$strSql);
$intBumonRsCnt = pg_numrows($rsBumonRecset);


switch ($sinki_edit_flg) {
	case "sinki":
		if ($intBumonRsCnt==0){
			echo "<center>社員登録の前に部門登録を行ってください<BR>";
			echo "<input type =\"button\" value=\" 戻 る \" onclick=\"return modoru()\"></a></center><br>";
			exit;
		}
		break;

	case "edit":
		$strSql = "SELECT syain_cd,syain_id,password,name_kj_sei,name_kj_mei,name_kn_sei,name_kn_mei,";
		$strSql = $strSql."syugyo_type,sex,birthday,nyusya_date,mail_addr,extension_no,yubin_no,";
		$strSql = $strSql."addr_pref,addr_city,addr_banti,addr_apart,tel_no,keitai_no,del_flg,disp_rank ";
		$strSql = $strSql."FROM syain_tbl WHERE syain_cd = '".$syain_cd."'";
		//echo $strSql;
		$rsRecset = pg_exec($pg_con,$strSql);
		$strSyainCode     = pg_result($rsRecset,0,"syain_cd");				//社員コード
		$strSyainId       = pg_result($rsRecset,0,"syain_id");				//社員ID
		$strSyainPwd      = pg_result($rsRecset,0,"password");				//パスワード
		$strNameSeiKj     = htmlspecialchars(pg_result($rsRecset,0,"name_kj_sei"));			//姓漢字
		$strNameMeiKj     = htmlspecialchars(pg_result($rsRecset,0,"name_kj_mei"));			//名漢字
		$strNameSeiKn     = pg_result($rsRecset,0,"name_kn_sei");			//姓カナ
		$strNameMeiKn     = pg_result($rsRecset,0,"name_kn_mei");			//名カナ
		$strSyuugyouType  = pg_result($rsRecset,0,"syugyo_type");			//就業形態
		$strSex           = pg_result($rsRecset,0,"sex");					//性別
		$strBirthDate     = split("/",pg_result($rsRecset,0,"birthday"));
		$strBirthDateY    = $strBirthDate[0];								//生年月日年
		$strBirthDateM    = $strBirthDate[1];								//生年月日月
		$strBirthDateD    = $strBirthDate[2];								//生年月日日
		$strNyusyaDate    = split("/",pg_result($rsRecset,0,"nyusya_date"));
		$strNyusyaDateY   = $strNyusyaDate[0];								//入社年月日年
		$strNyusyaDateM   = $strNyusyaDate[1];								//入社年月日月
		$strNyusyaDateD   = $strNyusyaDate[2];								//入社年月日日
		$strMailAdr       = split("@",pg_result($rsRecset,0,"mail_addr"));
		$strMailAdrAcount = $strMailAdr[0];									//メールアドレスアカウント
		$strMailAdrDomain = $strMailAdr[1];									//メールアドレスドメイン
		$strNaisen        = pg_result($rsRecset,0,"extension_no");			//内線番号
		$strYubin         = pg_result($rsRecset,0,"yubin_no");
		$strYubinMae      = substr($strYubin,0,3);							//郵便番号前
		$strYubinAto      = substr($strYubin,3,4);							//郵便番号後
		$strJyusyoPref    = pg_result($rsRecset,0,"addr_pref");				//住所(都道府県)
		$strJyusyoSikugun = htmlspecialchars(pg_result($rsRecset,0,"addr_city"));				//住所(市区郡)
		$strJyusyoBanti   = htmlspecialchars(pg_result($rsRecset,0,"addr_banti"));			//住所(町名・番地)
		$strJyusyoApart   = htmlspecialchars(pg_result($rsRecset,0,"addr_apart"));			//住所(アパート)
		$strTell          = split("-",pg_result($rsRecset,0,"tel_no"));
		$strTellSigai     = $strTell[0];									//電話(市外)
		$strTellSinai     = $strTell[1];									//電話(市内)
		$strTellKyoku     = $strTell[2];									//電話(局番)
		$strKeitai        = split("-",pg_result($rsRecset,0,"keitai_no"));
		$strKeitai1       = $strKeitai[0];									//携帯電話
		$strKeitai2       = $strKeitai[1];									//携帯電話
		$strKeitai3       = $strKeitai[2];									//携帯電話
		break;
}


?>
<form name="e_gru">
	<?php  if ($PHP_BIT[0]==1){ ?>
		<table width="100%" border="0" cellspacing="0">
			<tr>
				<td class="midashi">
					<table width="100%" border="0" cellpadding="0" cellspacing="0">
						<tr>
							<th width="50%" scope="col"><div align="left"><img src="image/t_kanri.gif" border="0"> 社員情報設定</div></th>
							<th width="50%" scope="col"><div align="right"><a href='javascript:Disp_Help("CON008HLP.htm")'><img src="image/help.gif" border="0"></a> <a href='javascript:Disp_Help("CON008HLP.htm")'>ヘルプ</a></div></th>
						</tr>
					</table>
					<div align="right"></div>
				</td>
			</tr>
		</table>
		<br>
		<!--個人情報入力ー-->
		<span class="Chufont"></span><span class="Normalfont">は入力必須項目です</span>
		<table width="902" border="0" cellspacing="1" cellpadding="1" class="mainColor">
			<tr>
				<td>
					<table width="900" cellSpacing="1" cellPadding="1" border="0">
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">社員番号</span><span class="Chufont"></span></td>
							<td><input maxlength="10" size="20" value="<?php  echo $strSyainId ?>" name="syain_id"><span class="Normalfont">(半角英数字10文字以内)</span></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">パスワード</span><span class="Chufont"></span></td>
							<td><input maxlength="10" size="20" value="<?php  echo $strSyainPwd ?>" name="syain_pwd"><span class="Normalfont">(半角英数字10文字以内)</span></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">氏名(漢字)</span><span class="Chufont"></span></td>
							<td><span class="Normalfont"></span><input maxlength="10" size="20" value="<?php  echo $strNameSeiKj ?>" name="sei_kj"> <span class="Normalfont"></span><input maxlength="10" size="20" value="<?php  echo $strNameMeiKj ?>" name="mei_kj"></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">氏名(フリガナ)</span><span class="Chufont"></span></td>
							<td><input maxlength="20" size="40" value="<?php  echo $strNameSeiKn ?>" name="sei_kn"> <input maxlength="20" size="40" value="<?php  echo $strNameMeiKn ?>" name="mei_kn"><span class="Normalfont">(全角カタカナ)</span></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">就業形態</span></td>
							<td>
								<SELECT name="work_type">
									<option value=0>----</option>
									<?php 
											for ($i = 0 ; $i <= $intSyuugyouRsCnt-1 ; $i++) {
												if ($strSyuugyouType == pg_result($rsSyuugyouRecset,$i,"syuugyou_type")) {
													echo "<option value=\"".pg_result($rsSyuugyouRecset,$i,"syuugyou_type")."\" selected>".pg_result($rsSyuugyouRecset,$i,"type_name")."</option>\n";
												}else{
													echo "<option value=\"".pg_result($rsSyuugyouRecset,$i,"syuugyou_type")."\">".pg_result($rsSyuugyouRecset,$i,"type_name")."</option>\n";
												}
											}
									?>
								</SELECT>
							</td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">所属部門</span><span class="Chufont"></span></td>
							<td>
								<?php 
											for ($i = 0 ; $i <= $intBumonRsCnt-1 ; $i++) {
												//該当部門に所属しているか
												if ($sinki_edit_flg=="edit") {
													$strSql2="SELECT syain_cd,syozoku_cd FROM syozoku_tbl WHERE syain_cd = '".$syain_cd."' AND syozoku_cd = ".pg_result($rsBumonRecset,$i,"syozoku_cd");
													$rsSyozokuRecset = pg_exec($pg_con,$strSql2);
													if (pg_numrows($rsSyozokuRecset)==1) {
														echo "<input type=\"checkbox\" name=\"bumon\" value=\"".pg_result($rsBumonRecset,$i,"syozoku_cd")."\" checked><span class=\"Normalfont\">".pg_result($rsBumonRecset,$i,"bumon_name")."</span><br>\n";
													}else{
														echo "<input type=\"checkbox\" name=\"bumon\" value=\"".pg_result($rsBumonRecset,$i,"syozoku_cd")."\"><span class=\"Normalfont\">".pg_result($rsBumonRecset,$i,"bumon_name")."</span><br>\n";
													}
												}else{
														echo "<input type=\"checkbox\" name=\"bumon\" value=\"".pg_result($rsBumonRecset,$i,"syozoku_cd")."\"><span class=\"Normalfont\">".pg_result($rsBumonRecset,$i,"bumon_name")."</span><br>\n";
												}
											}
								?>
							</td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">性別</span></td>
							<td>
								<input type="radio"<?php 	if ($strSex=="t") {	echo " CHECKED" ;	}	?> value="t" name="sex"><span class="Normalfont"></span> 
								<input type="radio"<?php 	if ($strSex=="f") {	echo " CHECKED" ;	}	?> value="f" name="sex"><span class="Normalfont"></span>
							</td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">生年月日</span></td>
							<td>
								<span class="Normalfont">西暦</span>
								<input maxlength="4" size="6" value="<?php  echo $strBirthDateY ?>" name="birth_y"><span class="Normalfont"></span>
								<select name="birth_m">
									<option value="">--月</option>
									<?php 
											for ($i = 1 ; $i <= 12 ; $i++) {
												if ($strBirthDateM == $i) {
													echo "		<option value=\"".$i."\" selected>".$i."月</option>\n";
												}else{
													echo "		<option value=\"".$i."\">".$i."月</option>\n";
												}
											}
									?>
								</select>
								<select name="birth_d">
									<option value="">--日</option>
									<?php 
											for ($i = 1 ; $i <= 31 ; $i++) {
												if ($strBirthDateD == $i) {
													echo "		<option value=\"".$i."\" selected>".$i."日</option>\n";
												}else{
													echo "		<option value=\"".$i."\">".$i."日</option>\n";
												}
											}
									?>
								</select>
							</td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">入社日</span></td>
							<td>
								<span class="Normalfont">西暦</span>
								<input maxlength="4" size="6" value="<?php  echo $strNyusyaDateY ?>" name="nyusya_y"><span class="Normalfont"></span>
								<select name="nyusya_m">
									<option value="">--月</option>
									<?php 
											for ($i = 1 ; $i <= 12 ; $i++) {
												if ($strNyusyaDateM == $i) {
													echo "		<option value=\"".$i."\" selected>".$i."月</option>\n";
												}else{
													echo "		<option value=\"".$i."\">".$i."月</option>\n";
												}
											}
									?>
								</select>
								<select name="nyusya_d">
									<option value="">--日</option>
									<?php 
											for ($i = 1 ; $i <= 31 ; $i++) {
												if ($strNyusyaDateD == $i) {
													echo "		<option value=\"".$i."\" selected>".$i."日</option>\n";
												}else{
													echo "		<option value=\"".$i."\">".$i."日</option>\n";
												}
											}
									?>
								</select>
							</td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">メールアドレス</span></td>
							<td><input maxlength="50" size="80" value="<?php echo $strMailAdrAcount ?>" name="email1">@<input maxlength="30" size="50" value="<?php echo $strMailAdrDomain ?>" name="email2"></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">内線番号</span></td>
							<td><input maxlength="4" size="6" value="<?php  echo $strNaisen ?>" name="naisen_no"></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td valign="top" class="toneDown" rowspan="5"><span class="Normalfont">住所</span><BR>
							<td><input type="text" maxlength="3" size="3" value="<?php  echo $strYubinMae ?>" name="yubin_no1">-<input type="text" maxlength="4" size="4" value="<?php  echo $strYubinAto ?>" name="yubin_no2"></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td>
								<select name="address1"><option value="">------</option>
								<option value="北海道" <?php  if ($strJyusyoPref == "北海道"){ echo("selected");} ?>>北海道</option>
								<option value="青森県" <?php  if ($strJyusyoPref == "青森県"){ echo("selected");} ?>>青森県</option>
								<option value="岩手県" <?php  if ($strJyusyoPref == "岩手県"){ echo("selected");} ?>>岩手県</option>
								<option value="宮城県" <?php  if ($strJyusyoPref == "宮城県"){ echo("selected");} ?>>宮城県</option>
								<option value="秋田県" <?php  if ($strJyusyoPref == "秋田県"){ echo("selected");} ?>>秋田県</option>
								<option value="山形県" <?php  if ($strJyusyoPref == "山形県"){ echo("selected");} ?>>山形県</option>
								<option value="福島県" <?php  if ($strJyusyoPref == "福島県"){ echo("selected");} ?>>福島県</option>
								<option value="茨城県" <?php  if ($strJyusyoPref == "茨城県"){ echo("selected");} ?>>茨城県</option>
								<option value="栃木県" <?php  if ($strJyusyoPref == "栃木県"){ echo("selected");} ?>>栃木県</option>
								<option value="群馬県" <?php  if ($strJyusyoPref == "群馬県"){ echo("selected");} ?>>群馬県</option>
								<option value="埼玉県" <?php  if ($strJyusyoPref == "埼玉県"){ echo("selected");} ?>>埼玉県</option>
								<option value="千葉県" <?php  if ($strJyusyoPref == "千葉県"){ echo("selected");} ?>>千葉県</option>
								<option value="東京都" <?php  if ($strJyusyoPref == "東京都"){ echo("selected");} ?>>東京都</option>
								<option value="神奈川県" <?php  if ($strJyusyoPref == "神奈川県"){ echo("selected");} ?>>神奈川県</option>
								<option value="山梨県" <?php  if ($strJyusyoPref == "山梨県"){ echo("selected");} ?>>山梨県</option>
								<option value="長野県" <?php  if ($strJyusyoPref == "長野県"){ echo("selected");} ?>>長野県</option>
								<option value="新潟県" <?php  if ($strJyusyoPref == "新潟県"){ echo("selected");} ?>>新潟県</option>
								<option value="富山県" <?php  if ($strJyusyoPref == "富山県"){ echo("selected");} ?>>富山県</option>
								<option value="石川県" <?php  if ($strJyusyoPref == "石川県"){ echo("selected");} ?>>石川県</option>
								<option value="福井県" <?php  if ($strJyusyoPref == "福井県"){ echo("selected");} ?>>福井県</option>
								<option value="岐阜県" <?php  if ($strJyusyoPref == "岐阜県"){ echo("selected");} ?>>岐阜県</option>
								<option value="静岡県" <?php  if ($strJyusyoPref == "静岡県"){ echo("selected");} ?>>静岡県</option>
								<option value="愛知県" <?php  if ($strJyusyoPref == "愛知県"){ echo("selected");} ?>>愛知県</option>
								<option value="三重県" <?php  if ($strJyusyoPref == "三重県"){ echo("selected");} ?>>三重県</option>
								<option value="滋賀県" <?php  if ($strJyusyoPref == "滋賀県"){ echo("selected");} ?>>滋賀県</option>
								<option value="京都府" <?php  if ($strJyusyoPref == "京都府"){ echo("selected");} ?>>京都府</option>
								<option value="大阪府" <?php  if ($strJyusyoPref == "大阪府"){ echo("selected");} ?>>大阪府</option>
								<option value="兵庫県" <?php  if ($strJyusyoPref == "兵庫県"){ echo("selected");} ?>>兵庫県</option>
								<option value="奈良県" <?php  if ($strJyusyoPref == "奈良県"){ echo("selected");} ?>>奈良県</option>
								<option value="和歌山県" <?php  if ($strJyusyoPref == "和歌山県"){ echo("selected");} ?>>和歌山県</option>
								<option value="鳥取県" <?php  if ($strJyusyoPref == "鳥取県"){ echo("selected");} ?>>鳥取県</option>
								<option value="島根県" <?php  if ($strJyusyoPref == "島根県"){ echo("selected");} ?>>島根県</option>
								<option value="岡山県" <?php  if ($strJyusyoPref == "岡山県"){ echo("selected");} ?>>岡山県</option>
								<option value="広島県" <?php  if ($strJyusyoPref == "広島県"){ echo("selected");} ?>>広島県</option>
								<option value="山口県" <?php  if ($strJyusyoPref == "山口県"){ echo("selected");} ?>>山口県</option>
								<option value="徳島県" <?php  if ($strJyusyoPref == "徳島県"){ echo("selected");} ?>>徳島県</option>
								<option value="香川県" <?php  if ($strJyusyoPref == "香川県"){ echo("selected");} ?>>香川県</option>
								<option value="愛媛県" <?php  if ($strJyusyoPref == "愛媛県"){ echo("selected");} ?>>愛媛県</option>
								<option value="高知県" <?php  if ($strJyusyoPref == "高知県"){ echo("selected");} ?>>高知県</option>
								<option value="福岡県" <?php  if ($strJyusyoPref == "福岡県"){ echo("selected");} ?>>福岡県</option>
								<option value="佐賀県" <?php  if ($strJyusyoPref == "佐賀県"){ echo("selected");} ?>>佐賀県</option>
								<option value="長崎県" <?php  if ($strJyusyoPref == "長崎県"){ echo("selected");} ?>>長崎県</option>
								<option value="熊本県" <?php  if ($strJyusyoPref == "熊本県"){ echo("selected");} ?>>熊本県</option>
								<option value="大分県" <?php  if ($strJyusyoPref == "大分県"){ echo("selected");} ?>>大分県</option>
								<option value="宮崎県" <?php  if ($strJyusyoPref == "宮崎県"){ echo("selected");} ?>>宮崎県</option>
								<option value="鹿児島県" <?php  if ($strJyusyoPref == "鹿児島県"){ echo("selected");} ?>>鹿児島県</option>
								<option value="沖縄県" <?php  if ($strJyusyoPref == "沖縄県"){ echo("selected");} ?>>沖縄県</option></select><BR>
							</td>
						</tr>
						<tr bgcolor="#ffffff">
							<td><input maxlength="10" size="23" value="<?php  echo $strJyusyoSikugun ?>" name="address2"><span class="Normalfont">(市区郡)</span></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td><input maxlength="20" size="46" value="<?php  echo $strJyusyoBanti ?>" name="address3"><span class="Normalfont">(町名、番地)</span></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td><input maxlength="20" size="46" value="<?php  echo $strJyusyoApart ?>" name="address4"><span class="Normalfont">(マンション・アパート名)</span></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">自宅電話番号</span></td>
							<td><input maxlength="4" size="4" value="<?php  echo $strTellSigai ?>" name="telno1">-<input maxlength="4" size="4" value="<?php  echo $strTellSinai ?>" name="telno2">-<input maxlength="4" size="4" value="<?php  echo $strTellKyoku ?>" name="telno3"></td>
						</tr>
						<tr bgcolor="#ffffff">
							<td class="toneDown"><span class="Normalfont">携帯電話番号</span></td>
							<td><input maxlength="4" size="4" value="<?php  echo $strKeitai1 ?>" name="keitaiNo1">-<input maxlength="4" size="4" value="<?php  echo $strKeitai2 ?>" name="keitaiNo2">-<input maxlength="4" size="4" value="<?php  echo $strKeitai3 ?>" name="keitaiNo3"></td>
						</tr>
					</table>
				</td>
			</tr>
		</table>
		<br>

		<table width="902" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td height="40"align="left"><input type="button" onclick="return chk();" value=" 設 定 "name="kosin"></td>
				<td height="40"align="center"><input type="reset" value="ク リ ア"></td>
				<?php if($sinki_edit_flg != "sinki") {?>
				<td height="40"align="center">
					<input type="button" onclick="dell_chk();"value=" 削 除 ">
				</td>
				<?php } ?>
				<td height="40"align="right"><input type="button" onclick="return back();" value=" 戻 る "name="modoru"></td>
			</tr>
		</table>

		<input type="hidden" name="sinki_edit_flg" value="<?php echo $sinki_edit_flg?>">
		<input type="hidden" name="syain_code" value="<?php  echo $strSyainCode ?>">
		<input type="hidden" name="bumon_num" value="">
		<input type="hidden" name="stradd" value="">
	<?php }else{?>
		<a href="TOP000.php"><span class="Normalfont">マスタ変更権限がありません</span></a>
	<?php  } ?>
</form>
<?php 
//コピーライト
include("include/copyright.inc");
?>