work_note.php

一个很不错的oa系统,简单好用,数据库是用mysql5,所以大家要注意,不要因为数据导入而带来问题

<?php
	session_start();
	include "../inc/chec.php";
	include "../conn/conn.php";
	include "../inc/func.php";
?>
<link href="../css/style.css" rel="stylesheet" />
<script src="../js/client_js.js"></script>
<table width="765" border="1" cellpadding="0" cellspacing="0" class="big_td">
	<tr>
		<td height="33" background="../images/list.jpg" id="list">
		<?php echo read_field($conn,"tb_list","f_name",$_GET[u_id]); ?>
		</td>
	</tr>
</table>
<table width="765" border="0" cellpadding="0" cellspacing="0" bgcolor="#DEEBEF">
<form method="post" action="#">
	<tr>
		<td colspan="5" height="30" align="center" valign="middle">
		<a href="#" onclick="javascript:openWin=open('p_login.php?r_id=<?php echo $_GET[u_id]; ?>' ,'','width=420,height=260,scrollbars=no');">
<?php
	if($_GET[u_id] == 14){
		echo "上下班登记";
	}else if($_GET[u_id] == 15){
		echo "病事假登记";
	}else if($_GET[u_id] == 16){
		echo "加班登记";		
	}
?>
		</a></td>
	</tr>
	<tr>
		<td width="100" height="20" align="center" valign="middle">日期</td>
		<td width="100" height="20" align="center" valign="middle">登记时间</td>
		<td width="100" align="center" valign="middle">登记类型</td>
		<td width="100" align="center" valign="middle">登记状态</td>
		<td  align="center" valign="middle">备注</td>
	</tr>
<?php
	$sqlstr = "select id,r_date,r_time,r_type,r_state,r_remark from tb_register where r_id = ".$_GET[u_id]." and p_id = ".$_SESSION[id]." order by id desc";
	$result = mysql_query($sqlstr,$conn);
	while($rows = mysql_fetch_array($result)){
?>
	<tr>
		<td height="25" align="center" valign="middle"><?php echo $rows[r_date]; ?></td>
		<td height="25" align="center" valign="middle"><?php echo $rows[r_time]; ?></td>
		<td height="25" align="center" valign="middle">
		
		<?php 
			switch($rows[r_type]){
				case 0:
					echo  "下班";
					break;
				case 1:
					echo "上班";
					break;
				case 2:
					echo "加班签到";
					break;
				case 3:
					echo "加班签退";
					break;
				case 4:
					echo "病假";
					break;
				case 5:
					echo "事假";
					break;
			}
		?>
		
		</td>
		<td height="25" align="center" valign="middle">
		<?php
			switch($rows[r_type]){
				case 1:
					echo ($rows[r_state] == 0)?"正点上班":"迟到"; 
					break;
				case 0:
					echo ($rows[r_state] == 0)?"早退":"正点下班"; 
				    break;
				case 2:
					echo ($rows[r_state] == 0)?"正点加班":"晚点加班";
					break;
				case 3:
					echo ($rows[r_state] == 0)?"早退":"正点下班";
				    break;
				case 4:
					echo ($rows[r_state] == 0)?"病假":"事假";
					break;
			}
		?>
		</td>
		<td height="25" align="center" valign="middle"><?php echo ($rows[r_remark] != null)?$rows[r_remark]:无; ?></td>
	</tr>
<?php	
	}
?>
</form>
</table>