ikan Uploader :
Directory : /var/www/html/shardahospital.org/cronjobs/
Upload File : |
| Current File : /var/www/html/shardahospital.org/cronjobs/alertemployeeAttendance.php |
<?php
error_reporting(E_ALL);
date_default_timezone_set("Asia/Calcutta");
//ini_set('display_errors', '1');
define('DB_SERVER','academic-portal.cluster-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com');
define('DB_USERNAME','campus_user');
define('DB_PASSWORD' ,"sPV@bM2hhR6&");
define('DB_DATABASE', 'sharda_campus_db');
define('COMPANY', "ShardaTech pvt ltd.");
/* Connect to MySQL and select the database. */
$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if (!$conn) {
mysqli_connect_error();
}
mysqli_set_charset($conn, "utf8");
$attendanceDate = date("Y-m-d");
$records = getallRecords($conn,$attendanceDate);
// Send Confirmation Email
sendAlertEmail(count($records), $attendanceDate);
$currentAttendance = date('d-M-y',strtotime($attendanceDate));
echo 'Total Records =>' . count($records) . '<br/>';
echo '<br>';
exit();
/*
* Function : getallRecords
* Description :
* Date:
* Created By:
*/
function getallRecords($conn,$days_ago)
{
//$days_ago = date("Y-m-d", strtotime("-2 day"));
$sql = "select * from tbl_employeeattendance where attendance_date like'".$days_ago."%'";
$result = mysqli_query($conn, $sql);
$results = array();
while($row = mysqli_fetch_array($result))
{
$results[$row['id']] = $row;
}
return $results;
}
/*
* Function : sendAlertEmail
*/
function sendAlertEmail($totalrecords, $attendanceDate)
{
$to_emails = 'amit.verma@sharda.ac.in';
//$to_emails = 'amit.verma@sharda.ac.in';
$subject = 'Alert Successful Execution : Employee Attendance Cronjob - '.date('Y-m-d H:i:s');
$message = emailTemplate($totalrecords, $attendanceDate);
$resp = send_email_pepipost($to_emails, $subject, $message);
return $resp;
}
/*
* Function : send_email_pepipost
* Description : Send Email
*/
function send_email_pepipost($to_emails, $subject, $message, $fromname='', $fromemail='', $replyto=''){
$fromname=$fromname?$fromname:'Ezone Cronjob Alert';
$fromemail=$fromemail?$fromemail:'alerts@shardauniversity.com'; //Change This Email ID;
$replyto=$replyto?$replyto:'noreply@sharda.ac.in'; //Change the Email ID;
//$to_emails = 'amit.verma@shardatech.org';
if(!$to_emails){
return;
}
if(is_string($to_emails)){
$to_emails=explode(",", $to_emails);
}
foreach($to_emails as $to){
$d=array (
'personalizations' => array (0 => array ('recipient' => $to)),
'from' => array ('fromEmail' => $fromemail, 'fromName' => $fromname),
'replyToId'=>$replyto,
'subject' => $subject,
'content' => $message,
);
$email_jason_data=json_encode($d);
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => "https://api.pepipost.com/v2/sendEmail",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => $email_jason_data,
CURLOPT_HTTPHEADER => array(
"api_key: c77184012dcf9bd5cd1886b4e0a2bb89",
// "api_key: aab3f77715e90569034f0c6e5d912714",
"content-type: application/json"
),
));
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
}
// else {
// echo $response;
// }
// die;
}
//EOF
//EOF
}
/*
* Function : emailTemplate
*
*/
function emailTemplate($totalrecords=0, $attendanceDate='')
{
$template='';
$template.='<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<title>Sharda E-Zone</title>
<style type="text/css">
#outlook a {padding:0;}
body{width:100% !important; -webkit-text-size-adjust:100%; -ms-text-size-adjust:100%; margin:0; padding:0;}
.ExternalClass {width:100%;}
.ExternalClass, .ExternalClass p, .ExternalClass span, .ExternalClass font, .ExternalClass td, .ExternalClass div {line-height: 100%;}
#backgroundTable {margin:0; padding:0; width:100% !important; line-height: 100% !important;}
img {outline:none; text-decoration:none;border:none; -ms-interpolation-mode: bicubic;}
a img {border:none;}
.image_fix {display:block;}
p {margin: 0px 0px !important;}
table td {border-collapse: collapse;}
table { border-collapse:collapse; mso-table-lspace:0pt; mso-table-rspace:0pt; }
a {color: #1d83aa;text-decoration: none;text-decoration:none!important;}
/*STYLES*/
table[class=full] { width: 100%; clear: both; }
/*IPAD STYLES*/
@media only screen and (max-width: 640px) {
a[href^="tel"], a[href^="sms"] {
text-decoration: none;
color: #33b9ff;
pointer-events: none;
cursor: default;
}
.mobile_link a[href^="tel"], .mobile_link a[href^="sms"] {
text-decoration: default;
color: #33b9ff !important;
pointer-events: auto;
cursor: default;
}
table[class=devicewidth] {width: 440px!important;text-align:center!important;}
table[class=devicewidth] td{text-align:center!important;}
table[class=devicewidth] td.left{text-align:left!important;}
table[class=devicewidthinner] {width: 420px!important;text-align:center!important;}
img[class=banner] {width: 440px!important;height:177px!important;}
img[class=colimg2] {width: 440px!important;height:177px!important;}
}
/*IPHONE STYLES*/
@media only screen and (max-width: 480px) {
a[href^="tel"], a[href^="sms"] {
text-decoration: none;
color: #ffffff; /* or whatever your want */
pointer-events: none;
cursor: default;
}
.mobile_link a[href^="tel"], .mobile_link a[href^="sms"] {
text-decoration: default;
color: #ffffff !important;
pointer-events: auto;
cursor: default;
}
table[class=devicewidth] {width: 350px!important;text-align:center!important;}
table[class=devicewidthinner] {width: 350px!important;text-align:center!important;}
img[class=banner] {width: 350px!important;height:140px!important;}
img[class=colimg2] {width: 350px!important;height:140px!important;}
td[class="padding-top15"]{padding-top:15px!important;}
.full-width{ width:100% !important; text-align:center !important; }
.full-width img{ margin:0 auto !important; }
}
@media only screen and (min-width:481px) and (max-width:599px) {
table[class=wrapper] {
width: 100% !important;
}
table[class=main_table] {
width: 100% !important;
}
td[class=pad_side] {
padding-left: 14px !important;
padding-right: 14px !important;
}
td[class=hide], br[class=hide] {
display: none !important;
}
img[class=full_img] {
width: 100% !important;
height: auto !important;
}
td[class=text], td[class=black], td[class=black2], td[class=red], td[class=white], td[class=white1], td[class=white2], td[class=grey] {
text-align: center !important;
}
td[class=pad_bottom] {
padding-bottom: 20px !important;
}
td[class=pad_top] {
padding-top: 20px !important;
}
td[class=fix_height] {
height: 20px !important;
}
td[class=video] img {
width: 100% !important;
height: auto !important;
}
}
@media only screen and (max-width:480px) {
table[class=wrapper] {
width: 100% !important;
}
table[class=main_table] {
width: 100% !important;
}
td[class=pad_side] {
padding-left: 14px !important;
padding-right: 14px !important;
}
td[class=hide], br[class=hide] {
display: none !important;
}
img[class=full_img] {
width: 100% !important;
height: auto !important;
}
td[class=text], td[class=black], td[class=black2], td[class=red], td[class=white], td[class=white1], td[class=white2], td[class=grey] {
text-align: center !important;
}
td[class=pad_bottom] {
padding-bottom: 20px !important;
}
td[class=pad_top] {
padding-top: 20px !important;
}
td[class=fix_height] {
height: 20px !important;
}
td[class=video] img {
width: 100% !important;
height: auto !important;
}
}
</style>
</head>
<body>
<!-- Start of header -->
<table width="100%" bgcolor="#ffffff" cellpadding="0" cellspacing="0" border="0" id="backgroundTable" st-sortable="header">
<tbody>
<tr>
<td align="center">
<table width="650" cellpadding="0" cellspacing="0" border="0" align="center" class="devicewidth">
<tbody>
<tr>
<td width="100%" align="center">
<table bgcolor="#fff" width="650" cellpadding="0" cellspacing="0" border="0" align="center" class="devicewidth" style="border-left: 1px solid #e1e1e1; border-right: 1px solid #e1e1e1">
<tbody>
<!-- Spacing -->
<tr>
<td height="5" style="font-size:1px; line-height:1px; mso-line-height-rule: exactly;"> </td>
</tr>
<!-- Spacing -->
<tr>
<td>
<!-- logo -->
<table width="100" align="left" border="0" cellpadding="0" cellspacing="0" class="devicewidth">
<tbody>
<tr>
<td width="160" height="60" align="center">
<div class="imgpop" align="center"><a target="_blank" href="http://ezone.sharda.ac.in/" title="Sharda E-Zone"><img src="https://www.sharda.ac.in/attachments/site_logo/logo22.png" alt="Sharda E-Zone" border="0" height="50" style="display:block; border:none; outline:none; text-decoration:none;" /></a></div> </td>
</tr>
</tbody>
</table>
<!-- end of logo -->
</td>
</tr>
<!-- Spacing -->
<tr>
<td height="5" style="font-size:1px; line-height:1px; mso-line-height-rule: exactly;"> </td>
</tr>
<!-- Spacing -->
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<!-- End of Header -->
<table width="650" bgcolor="#fff" border="0" cellspacing="0" cellpadding="0" class="wrapper" align="center" mc:repeatable mc:variant="Right IMAGE + Left(TITLE + DESC + READ MORE)" style="table-layout:fixed;font-family:Arial, sans-serif; border-left: 1px solid #e1e1e1; border-right: 1px solid #e1e1e1; border-bottom: 1px solid #e1e1e1">
<tr>
<td height="15" style="line-height:1px;font-size:1px;"> </td>
</tr>
<tr>
<td class="pad_side">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="left" class="wrapper">
<tr>
<td align="center" valign="top">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="1" style="line-height:1px;font-size:1px;" class="fix_height"> </td>
</tr>
<tr>
<td valign="top">
<div class="padding" style="padding: 0 0;font-size:14px;color:#414141;text-align:left;line-height:22px;">
<p style="text-transform:uppercase;font-size:18px;padding:5px 0 15px 0;font-weight:bold;">Dear All,</p>
<p>We are pleased to inform you that the cronjob, <b>Employee Attendance Cronjob</b>, executed successfully as scheduled. This email serves as confirmation that the task was completed without any issues.</p>
</div>
<div class="padding" style="font-size:14px;color:#000000;text-align:left;line-height:22px;">
<p style="padding: 10px 0;"> Here are the details of the successful execution:<br/><br/>
Cronjob Name: Employee Attendance Cronjob<br/>
Execution Date/Time: '.date("Y-m-d H:i:s").'<br/>
Attendance Date/Time: <b style="font-size:18px;color:#FF0000;">'.$attendanceDate.'</b><br/>
Task Description: Total <b style="font-size:18px;color:#0000FF;">'.$totalrecords.'</b> records added.<br/>
Server/Environment: Sharda Academic Portal </p>
</div>
<div class="padding" style="font-size:14px;color:#414141;text-align:left;line-height:22px;"><p style="padding: 10px 0">The successful completion of this cronjob signifies that the desired operations have been carried out as intended, ensuring the smooth functioning of our systems and processes.</p>
<p style="padding: 10px 0">If you have any questions or concerns regarding this cronjob or its execution, please feel free to reach out to us. We are here to assist you and provide any necessary information.</p>
<p style="padding: 10px 0">Thank you for your attention, and please don\'t hesitate to contact us if you require further assistance.</p>
</div>
<div class="padding" style="font-size:14px;color:#414141;text-align:left;line-height:22px;padding-top:20px;">
<p>Best regards,<br/>
Sharda Academic Portal </p>
</div>
</td>
</tr>
<tr>
<td height="30"></td>
</tr>
<tr>
<td align="center" style="font-weight: bold; border: 1px solid #ebebeb; padding: 4px 10px;font-size: 16px;">Visit Website to Explore <a href="https://ezone.sharda.ac.in/ezone-2022/"><span style="color: #00a3e4">https://ezone.sharda.ac.in</span></a></td>
</tr>
<tr>
<td height="15" style="line-height:1px;font-size:1px;" class="fix_height"> </td>
</tr>
</table>
</td>
<td width="0" class="hide"> </td>
</tr>
</table>
</td>
</tr>
</table>
<!-- end of footer -->
</body>
</html>';
return $template;
}
Kontol Shell Bypass