ikan Uploader :
Directory : /var/www/html/shardahospital.org/incident/application/controllers/
Upload File : |
| Current File : /var/www/html/shardahospital.org/incident/application/controllers/Cron.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Cron extends MY_Controller
{
public function __construct()
{
parent::__construct();
$this->load->library('form_validation','session');
$this->load->Model('Common_model');
}
/*
* Function: index
*/
public function index($page = 0)
{
$data = array();
$head = array();
$head['title'] = @$arrSeo['title']!=''? $arrSeo['title'] : 'New User Registration - Sharda Grievance Portal';
$head['description'] = @$arrSeo['description'];
$head['keywords'] = str_replace(" ", ",", $head['title']);
$this->load->view('_parts/empty_adminheader', $head);
$this->load->view('registration', $data);
$this->load->view('_parts/footer');
}
/*
* Function : academicgrievance
* Description : Send L2 Level email
* More Than 5 Day
* 50 8 * * * wget https://grievance.sharda.ac.in/cron/academicgrievance
*/
public function academicgrievance()
{
$data = array();
$head = array();
// School Array
$schoolArray = $this->Common_model->getSchoolList('su_schools');
// Department Array
$departmentArray = $this->Common_model->getDepartmentList('su_departments');
$i=0;
foreach($schoolArray as $skey=>$srow) {
$lastUpdationDate = date("Y-m-d", strtotime("-5 day"));
$lastUpdationMaxDate = date("Y-m-d", strtotime("-15 day"));
$responseArray = $this->Common_model->getAllAcademicComplaintsRecords('tblcomplaints','*', array('tblcomplaints.school_id'=>$skey), $lastUpdationDate, $lastUpdationMaxDate);
$academicArray = array();
$k=0;
foreach($responseArray as $row) {
$academicArray[$k]['complaintNumber'] = $row['complaintNumber'];
$academicArray[$k]['compNumber'] = $row['compNumber'];
$academicArray[$k]['userId'] = $row['userId'];
$academicArray[$k]['category'] = $row['category'];
$academicArray[$k]['school_name'] = $schoolArray[$row['school_id']];
$academicArray[$k]['department_name'] = $departmentArray[$row['department_id']];
$academicArray[$k]['complaindetails'] = $row['complaindetails'];
$academicArray[$k]['complaint_doc'] = $row['complaint_doc'];
$academicArray[$k]['status'] = $row['status'];
$academicArray[$k]['lastUpdationDate'] = $row['lastUpdationDate'];
$academicArray[$k]['grievance_name'] = $row['grievance_name'];
$k++;
}
if(!empty($responseArray)){
$l2Records = $this->Common_model->getSingleRecord('admin','*', array('school_id'=>$skey,'user_level'=>'L2','status'=>'1'));
$to_email = $l2Records['username'];
$this->sendLevelTwoEmail($to_email, $academicArray);
$i++;
}
continue;
}
// Send All pending grievance to super admin Email Id
if($i>0)
{
$lastUpdationDate = date("Y-m-d", strtotime("-5 day"));
$lastUpdationMaxDate = date("Y-m-d", strtotime("-15 day"));
$responseNewArray = $this->Common_model->getAllAcademicComplaintsRecords('tblcomplaints','*', NULL, $lastUpdationDate, $lastUpdationMaxDate);
$newacademicArray = array();
foreach($responseNewArray as $row) {
$newacademicArray[$k]['complaintNumber'] = $row['complaintNumber'];
$newacademicArray[$k]['compNumber'] = $row['compNumber'];
$newacademicArray[$k]['userId'] = $row['userId'];
$newacademicArray[$k]['category'] = $row['category'];
$newacademicArray[$k]['school_name'] = $schoolArray[$row['school_id']];
$newacademicArray[$k]['department_name'] = $departmentArray[$row['department_id']];
$newacademicArray[$k]['complaindetails'] = $row['complaindetails'];
$newacademicArray[$k]['complaint_doc'] = $row['complaint_doc'];
$newacademicArray[$k]['status'] = $row['status'];
$newacademicArray[$k]['lastUpdationDate'] = $row['lastUpdationDate'];
$newacademicArray[$k]['grievance_name'] = $row['grievance_name'];
$k++;
}
$this->sendLevelTwoEmail('director.iqac@sharda.ac.in', $newacademicArray);
$this->sendLevelTwoEmail('grievance@sharda.ac.in', $newacademicArray);
}
echo $i.' Email Send Successfully.';
exit();
exit();
}
/*
* Function : sendLevelTwoEmail
* Send Email Alert
*/
private function sendLevelTwoEmail($email_id, $params)
{
$data = array();
$data['grievanceArray'] = $params;
if($email_id!='')
{
$template = $this->load->view('email_template/level_two_mailer', $data, true);
$subject = 'Pending Grievance';
$this->sendCommonEmail($email_id, $subject, $template);
}
}
/*
* Function : nonacademicgrievance
* Desc : L2 Level
* 48 8 * * * wget https://grievance.sharda.ac.in/cron/nonacademicgrievance
*
*/
public function nonacademicgrievance()
{
$data = array();
$head = array();
$lastUpdationDate = date("Y-m-d", strtotime("-5 day"));
$lastUpdationMaxDate = date("Y-m-d", strtotime("-15 day"));
$responseArray = $this->Common_model->getAllNonAcademicComplaintsRecords('tblcomplaints','*', NULL, $lastUpdationDate,$lastUpdationMaxDate);
$total = 0;
if(!empty($responseArray)) {
$l2Records = $this->Common_model->getSingleRecord('admin','*', array('school_id'=>'99','user_level'=>'L2','status'=>'1'));
//$to_email = 'amit.verma@shardatech.org';
$to_email = $l2Records['username'];
$this->sendLevelTwoNonAcademicEmail($to_email, $responseArray);
// Send a Copy to Super Admin
$this->sendLevelTwoNonAcademicEmail('director.iqac@sharda.ac.in', $responseArray);
$this->sendLevelTwoNonAcademicEmail('grievance@sharda.ac.in', $responseArray);
$total++;
}
echo $total.' Email Send Successfully.';
exit();
}
/*
* Function : sendLevelTwoNonAcademicEmail
*/
private function sendLevelTwoNonAcademicEmail($email_id, $params)
{
$data = array();
$data['grievanceArray'] = $params;
if($email_id!='')
{
$template = $this->load->view('email_template/level_two_nonacademic_mailer', $data, true);
$subject = 'Pending Grievance';
$this->sendCommonEmail($email_id, $subject, $template);
}
}
/*
* Function : academicgrievancelevelthree
* Description : Send L3 Level email
* More Than or Equal 15 Day
* 55 8 * * * wget https://grievance.sharda.ac.in/cron/academicgrievancelevelthree
*
*/
public function academicgrievancelevelthree()
{
$data = array();
$head = array();
// School Array
$schoolArray = $this->Common_model->getSchoolList('su_schools');
// Department Array
$departmentArray = $this->Common_model->getDepartmentList('su_departments');
$i=0;
$lastUpdationDate = date("Y-m-d", strtotime("-15 day"));
$responseArray = $this->Common_model->getAllAcademicComplaintsRecords('tblcomplaints','*', NULL, $lastUpdationDate);
$academicArray = array();
$k=0;
foreach($responseArray as $row) {
$academicArray[$k]['complaintNumber'] = $row['complaintNumber'];
$academicArray[$k]['compNumber'] = $row['compNumber'];
$academicArray[$k]['userId'] = $row['userId'];
$academicArray[$k]['category'] = $row['category'];
$academicArray[$k]['school_name'] = $schoolArray[$row['school_id']];
$academicArray[$k]['department_name'] = $departmentArray[$row['department_id']];
$academicArray[$k]['complaindetails'] = $row['complaindetails'];
$academicArray[$k]['complaint_doc'] = $row['complaint_doc'];
$academicArray[$k]['status'] = $row['status'];
$academicArray[$k]['lastUpdationDate'] = $row['lastUpdationDate'];
$academicArray[$k]['grievance_name'] = $row['grievance_name'];
$k++;
}
if(!empty($academicArray)){
$l3Records = $this->Common_model->getSingleRecord('admin','*', array('school_id'=>'99','user_level'=>'L3','status'=>'1'));
$to_email = $l3Records['username'];
$this->sendLevelThreeEmail($to_email, $academicArray);
// Send Copy to Super Admin
$this->sendLevelThreeEmail('director.iqac@sharda.ac.in', $academicArray);
$this->sendLevelThreeEmail('grievance@sharda.ac.in', $academicArray);
$i++;
}
echo $i.' Email Send Successfully.';
exit();
exit();
}
/*
* Function : sendLevelThreeEmail
* Send Email Alert
*/
private function sendLevelThreeEmail($email_id, $params)
{
$data = array();
$data['grievanceArray'] = $params;
if($email_id!='')
{
$template = $this->load->view('email_template/level_three_mailer', $data, true);
$subject = '*Urgent - Pending Grievance (Academic)';
$this->sendCommonEmail($email_id, $subject, $template);
}
}
/*
* Function : nonacademiclevelthree
* Desc : L3 level email alert
* 53 8 * * * wget https://grievance.sharda.ac.in/cron/nonacademiclevelthree
*/
public function nonacademiclevelthree()
{
$data = array();
$head = array();
$lastUpdationDate = date("Y-m-d", strtotime("-15 day"));
$responseArray = $this->Common_model->getAllNonAcademicComplaintsRecords('tblcomplaints','*', NULL, $lastUpdationDate);
$total = 0;
if(!empty($responseArray))
{
$l3Records = $this->Common_model->getSingleRecord('admin','*', array('school_id'=>'99','user_level'=>'L3','status'=>'1'));
$to_email = $l3Records['username'];
$this->sendLevelThreeNonAcademicEmail($to_email, $responseArray);
// Send a Copy to Super Admin
$this->sendLevelThreeNonAcademicEmail('director.iqac@sharda.ac.in', $responseArray);
$this->sendLevelThreeNonAcademicEmail('grievance@sharda.ac.in', $responseArray);
$total++;
}
echo $total.' Email Send Successfully.';
exit();
}
/*
* Function : sendLevelThreeNonAcademicEmail
*/
private function sendLevelThreeNonAcademicEmail($email_id, $params)
{
$data = array();
$data['grievanceArray'] = $params;
if($email_id!='')
{
$template = $this->load->view('email_template/level_three_nonacademic_mailer', $data, true);
$subject = '*Urgent - Pending Grievance (Non-Academic)';
$this->sendCommonEmail($email_id, $subject, $template);
}
}
/*
* Function : sendAlertToHod
* Description : Grievances pending science last 2 days send reminder to respactive HOD
* Return : Total email send
*/
public function sendAlertToHod()
{
$data = array();
$head = array();
// School Array
$schoolArray = $this->Common_model->getSchoolList('su_schools');
// Department Array
$departmentArray = $this->Common_model->getFullDepartmentList('su_departments');
$lastUpdationDate = date("Y-m-d", strtotime("-2 day"));
$responseArray = $this->Common_model->getAllPendingComplaintsRecords('tblcomplaints','*', NULL, $lastUpdationDate);
$academicArray = array();
$k=0;
foreach($responseArray as $row) {
if(!array_key_exists($row['department_id'],$academicArray)) { $k=0; }
$academicArray[$row['department_id']][$k]['complaintNumber'] = $row['complaintNumber'];
$academicArray[$row['department_id']][$k]['compNumber'] = $row['compNumber'];
$academicArray[$row['department_id']][$k]['userId'] = $row['userId'];
$academicArray[$row['department_id']][$k]['category'] = $row['category'];
$academicArray[$row['department_id']][$k]['school_name'] = $schoolArray[$row['school_id']];
$academicArray[$row['department_id']][$k]['department_name'] = $departmentArray[$row['department_id']]['name'];
$academicArray[$row['department_id']][$k]['complaindetails'] = $row['complaindetails'];
$academicArray[$row['department_id']][$k]['complaint_doc'] = $row['complaint_doc'];
$academicArray[$row['department_id']][$k]['status'] = $row['status'];
$academicArray[$row['department_id']][$k]['lastUpdationDate'] = $row['lastUpdationDate'];
$academicArray[$row['department_id']][$k]['grievance_name'] = $row['grievance_name'];
$academicArray[$row['department_id']][$k]['hod_name'] = $departmentArray[$row['department_id']]['hod_name'];
$academicArray[$row['department_id']][$k]['hod_email'] = $departmentArray[$row['department_id']]['hod_email'];
$academicArray[$row['department_id']][$k]['hod_mobile'] = $departmentArray[$row['department_id']]['hod_mobile'];
$k++;
}
$email_count = $this->sendToHOD($academicArray);
echo 'Total '.$email_count.' Email Send Successfully.';
exit();
exit();
}
/*
* Function : sendToHOD
* Description :
* Createdon :
*/
private function sendToHOD($params)
{
$k=0;
if(!empty($params))
{
foreach($params as $key=>$row)
{
$k++;
$data = array();
$data['grievanceArray'] = $row;
$key = count($row)-1;
$email_id = $row[$key]['hod_email'];
if($email_id!='')
{
$template = $this->load->view('email_template/hod_level_mailer', $data, true);
$subject = 'Grievance Pending Last 2 Days on Grievance Redressal Online Portal';
$this->sendCommonEmail($email_id, $subject, $template);
sleep(3);
}
}
}
return $k;
}
/*
* Function : sendCommonEmail
*/
private function sendCommonEmail($to, $subject, $message)
{
$resp = send_email_pepipost($to, $subject, $message);
return $resp;
/*$CI =& get_instance();
$CI->load->library('email');
$mail=$CI->email;
$mail->clear();
$from_email = 'grievance@sharda.ac.in';
$from_name = 'Sharda University Grievance Redressal Online Portal';
$config['charset'] = 'utf-8';
$config['wordwrap'] = TRUE;
$config['mailtype'] = 'html';
$config['protocol'] = "smtp";
$config['smtp_host'] = 'ssl://smtp.gmail.com';
$config['smtp_user'] = 'grievance@sharda.ac.in';
$config['smtp_pass'] = 'grievance@2020';
$config['smtp_port'] = '465';
$config['_auth_smtp'] = TRUE;
$config['newline'] = "\r\n";
$config['crlf'] = "\r\n";
$mail->initialize($config);
$mail->from($from_email, $from_name);
$mail->to($to);
$mail->reply_to($from_email, $from_name);
$mail->subject($subject);
$mail->message($message);
return $mail->send();*/
}
/*
* Function : sendCommonEmail_old
*/
private function sendCommonEmail_old($email, $subject, $body)
{
$urlshow = base_url();
$config = Array(
'protocol' => 'sendmail',
'mailtype' => 'html',
'charset' => 'utf-8',
'wordwrap' => TRUE
);
$to_email = $email;
$this->load->library('email',$config);
$from_email = "grievance@sharda.ac.in";
$this->email->from($from_email, 'Sharda University');
$this->email->to($to_email);
$this->email->subject($subject);
$this->email->message($body);
if($mailg = $this->email->send()){
return true;
} else {
return true;
}
}
}
Kontol Shell Bypass