" ;
$user = wp_get_current_user();
$id=$user->ID ;
global $wpdb;
$user_id=$id;
if (isset($_REQUEST['user_id'])) {
$user_id = sanitize_text_field($_REQUEST['user_id']);
}
echo "
Full Attendance sheet of the company (Recent 60 Records )
" ;
$table_name = $wpdb->prefix . 'attendance';
$result = $wpdb->get_results("SELECT distinct display_name,user_id FROM $table_name order by id desc");
$i=0;
echo '
' ;
foreach($result as $display_name){
$i=$i+1;
$url=admin_url( 'admin.php?page=aistore2030_full_attendance&user_id='.$display_name->user_id );
echo "| ".$display_name->display_name." | " ;
if($i==3)
{
echo "
" ;
$i=0;
}
}
echo "
" ;
$table_name = $wpdb->prefix . 'attendance';
$result = $wpdb->get_results( $wpdb->prepare( "SELECT * , TIMESTAMPDIFF(HOUR, entrytime, entrytime) AS hours_different FROM $table_name where user_id=%d limit 60",$user_id));
?>
| id |
Date |
Name |
Entry Time |
Entry IP Address |
Exit Time |
Exit IP Address |
Hours Different |
";
echo "".$wp_formmaker_submits->id." | ";
echo "".$wp_formmaker_submits->adate." | ";
echo "".$wp_formmaker_submits->display_name." | ";
echo "".$wp_formmaker_submits->entrytime." | ";
echo "".$wp_formmaker_submits->entry_ip_address." | ";
echo "".$wp_formmaker_submits->exittime." | ";
echo "".$wp_formmaker_submits->exit_ip_address." | ";
echo "".$wp_formmaker_submits->hours_different." | ";
echo "";
}
echo "
";
}
function aistore2030_punch_in_punch_out()
{
global $wpdb;
$table_name = $wpdb->prefix . 'attendance';
$user = wp_get_current_user();
$id=$user->ID ;
$display_name=$user->display_name ;
$ip_address=aistore_getRealIpAddr();
if (
! isset( $_POST['punch_nonce'] )
|| ! wp_verify_nonce( $_POST['punch_nonce'], 'punch_nonce' )
) {
} else {
$type = sanitize_text_field($_REQUEST['type']);
if($type=="in")
{
$wpdb->query( $wpdb->prepare( "INSERT INTO $table_name (user_id,adate,
display_name,entrytime,entry_ip_address ) VALUES (%d,date(now()),%s,now() ,%s)",array($id, $display_name,$ip_address )));
}
elseif($type=="out")
{
$wpdb->query( $wpdb->prepare( "update $table_name
set
exittime= now() ,
exit_ip_address = %s
where
user_id = %d and
adate= date(now())
" ,array( $ip_address, $id) )
);
}
}
?>
Attendance sheet
| Name |
Entry time |
Exit time |
get_results("SELECT * FROM wp1f_attendance WHERE DATE(entrytime) = CURDATE() order by id desc");
foreach($result as $wp_formmaker_submits){
echo "";
echo "| ".$wp_formmaker_submits->display_name." | ";
echo "".$wp_formmaker_submits->entrytime." (";
echo "".$wp_formmaker_submits->entry_ip_address." ) | ";
echo "".$wp_formmaker_submits->exittime." ( ";
echo "".$wp_formmaker_submits->exit_ip_address." ) | ";
echo "
";
}
echo "
";
}
function aistore_getRealIpAddr()
{
if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
{
$ip=$_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
{
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
}
else
{
$ip=$_SERVER['REMOTE_ADDR'];
}
return $ip;
}
?>