1#@!#!123s

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

$server = 'localhost';
$username = 'root';
$password = '@ccountsp455';
$database = 'hrm';

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

$date = date("Y-m-d");

if(date("N") != '7'){

	$sql = "select * from users where status = 0 and uid <> 2 and uid not in(select uid from in_out where date = '$date')";

	$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 <b>In time</b> for the date ".date('d-m-Y')."<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);		
		}
		
	}

}