人肉打咭機

Purpose: To record different employee’s in and out times.

Challenge: To save the timestamp and also prevent the repeat in and repeat out scenario.

<form id="puncher" name="puncher">
<label>小名
<select id="human" name="human">
<option value="jason_po">Jason Po</option>
<option value="kevin_tse">Kevin Tse</option>
<option value="felix_ng">Felix Ng</option>
<option value="marco_pun">Marco Pun</option>
</select>
</label>
<span><input type="submit" id="inTime" name="inTime" value="插入" /></span>
<span><input type="submit" id="outTime" name="outTime" value="抽出" /></span>
</form>

$(function() {
	$('.error').hide();

	$("#inTime").click(function() {
		// first hide any error messages
		$('.error').hide();
		var name = $("#human").val();
		var event = "in";
		var date = returntoday();
		var dataString = 'name='+ name + '&event=' + event + '&date=' + date ;

	$.ajax({
		type: "POST",
		url: "punch.php",
		data: dataString,
		success: function(data) {
		$('#savemessage').html(data);

		}
     });
    return false;
	});

	$("#outTime").click(function() {
		// first hide any error messages
		$('.error').hide();
		var name = $("#human").val();
		var event = "out";
		var date = returntoday();
		var dataString = 'name='+ name + '&event=' + event + '&date=' + date ;

	$.ajax({
		type: "POST",
		url: "punch.php",
		data: dataString,
		success: function(data) {
		$('#savemessage').html(data);

		}
     });
    return false;
	});

});

// read last action
$query="SELECT * FROM `punch_tbl` WHERE `staffname`='{$name}' ORDER BY `spottime` DESC LIMIT 1";
//

$result=mysql_query($query) or die(mysql_error("Errors at reading database"));
$stafflast = mysql_fetch_row($result);

$flag = 0;
if (($stafflast[3] == 'in') && ($event == 'in'))
{
	echo "<p>你已於" . $stafflast[4] . "插入，而並未抽出。</p>";
	$flag = 1;
}
if (($stafflast[3] == 'out') && ($event == 'out'))
{
	echo "<p>你已於" . $stafflast[4] . "抽出，不能重複抽出。</p>";
	$flag = 1;
}

if ($flag == 0) {

// save example in wword database
$query="INSERT INTO `punch_tbl` (`staffname`,`inorout`,`date`) values ('" . $name . "','" . $event . "','" . $date . "')";
$result=mysql_query($query) or die(mysql_error("Errors at writing wordinfo into database"));

if ($event == "in") echo "<p>歡迎" . $name . "上班，記得下班時抽出。</p>";
if ($event == "out") echo $name . "辛苦了，再見，記得上班時要插入。";

mysql_close($con);

}