1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / hrm.addobyte.com /
Filename : in_out_cron.php
back
<?php

$server = 'localhost';
$username = 'root';
$password = 's3cr37dbp455';
$database = 'hrm';

$conn = new mysqli($server,$username,$password,$database);

$date = date("Y-m-d",strtotime("-1 day"));

//$sql = "select * from users where status = 0 and user_group = 0 and uid not in(SELECT uid FROM in_out where date = '$date')";
$sql = "select * from users where status = 0 and user_group = 0 and (uid not in(SELECT uid FROM in_out where date = '$date') or uid in(SELECT uid FROM in_out where date = '$date' and (inTime = '00:00:00' or outTime = '00:00:00')))";


$result = $conn->query($sql);

$url = "https://api.sendgrid.com/api/mail.send.json";

if($result->num_rows){
	
	$message = "Hi,<br><br>";
	$message .= "You didn't update your In/Out time for the date ".date('d-m-Y',strtotime("-1 day"))."<br><br>";
	$message .= "Please update it ASAP<br><br>";
	$message .= "Thanks";
	
	while($row = $result->fetch_assoc()){		
	
		$email = $row['email'];
		$first_name = $row['first_name'];
		
		$ch = curl_init($url);
		
		$json = "api_user=addobyte&api_key=Pass@12#&to=$email&toname=$first_name&subject=Reminder:In/Out&html=$message&from=info@addobyte.com";


		curl_setopt($ch, CURLOPT_POST, TRUE);
		curl_setopt($ch, CURLOPT_POSTFIELDS, $json);
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

		// Send the request
		$response = curl_exec($ch);		
	}
	
}