| Server IP : 192.249.121.117 / Your IP : 216.73.216.251 Web Server : Apache System : Linux ded4606.inmotionhosting.com 3.10.0-1160.81.1.el7.x86_64 #1 SMP Fri Dec 16 17:29:43 UTC 2022 x86_64 User : oakben5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/oakben5/public_html/docsearch2/ |
Upload File : |
<?php
/**
* entityManagerClass - This class takes care of actions related to an entity
* @author JMJ (jimmy.bastine@gmail.com)
* @version 0.1
* @copyright EMRInfotech (14-Jan-2014)
* @since 14-Jan-2014
*/
class batchprgmanager {
var $db;
var $table;
/**
* Class constructor
* @param db
*/
public function __construct($db='') {
$this->db = $db;
$this->tableDept = 'wprg_pods_doctor_department';
$this->tableDrstableDrs = 'wprg_pods_doctor';
}
/**
* Get all depts
* @param $date-today
*/
public function getAllDepts() {
$this->db->connect();
if($this->db->errno == 0)
{
$sql = "SELECT * FROM wprg_pods_doctor_department where id IN (SELECT DISTINCT related_item_id FROM `wprg_podsrel`
where pod_id = '5118' and field_id='5124') Order by `fld_dept_name` ASC";
//echo $sql; exit;
$this->db->query($sql);
if($this->db->errno == 0)
{
$this->db->fetchArray();
$this->db->close();
return $this->db->resArr;
}
}
else
{
return $this->db->errno.$this->db->error;
}
}
public function getAllDrs($name,$dept) {
$this->db->connect();
$sqlW1 = "";
$sqlW2 = "";
$sqlorder = "order by fld_doctors_name ASC";
if($this->db->errno == 0)
{
$sql = "SELECT wprg_pods_doctor.*,wprg_pods_doctor.id as docid ,wprg_pods_doctor_department.fld_dept_name,guid FROM wprg_pods_doctor
LEFT JOIN wprg_podsrel p1 ON wprg_pods_doctor.id = p1.item_id and p1.pod_id = '5118' AND p1.field_id = '5124'
LEFT JOIN wprg_podsrel p2 ON wprg_pods_doctor.id = p2.item_id and p2.pod_id = '5118' AND p2.field_id = '6536'
LEFT JOIN wprg_pods_doctor_department ON wprg_pods_doctor_department.id = p1.related_item_id
LEFT JOIN wprg_posts ON p2.related_item_id = wprg_posts.ID ";
if(trim($name)!='')
$sqlW1 = " WHERE wprg_pods_doctor.fld_doctors_name LIKE '%$name%' ";
$mixedstr = explode(" ",$name);
foreach ($name as $value) {
$sqlW1 = $sqlW1. " AND wprg_pods_doctor.fld_doctors_name LIKE '%$value%' ";
//echo "$value <br>";
}
?>
if(trim($dept)!=0)
if(trim($name)!='')
$sqlW2 = " AND wprg_pods_doctor_department.id='$dept' ";
else
$sqlW2 = " WHERE wprg_pods_doctor_department.id='$dept' ";
$sql .= $sqlW1 . $sqlW2 .$sqlorder;
//echo $sql;die();
/* echo '<div class="modal"><a href="javascript:closeModalEvent();" class="close-modal">Close</a>';
echo $sql;
echo '</div>'; */
$this->db->query($sql);
if($this->db->errno == 0)
{
$this->db->fetchArray();
$this->db->close();
return $this->db->resArr;
}
}
else
{
return $this->db->errno.$this->db->error;
}
}
public function OldgetAllDrs($name,$dept) {
$this->db->connect();
$sqlW1 = "";
$sqlW2 = "";
if($this->db->errno == 0)
{
$sql = "SELECT wprg_pods_doctor.*,wprg_pods_doctor_department.* FROM ".$this->tableDrs;
$sql .= " LEFT JOIN " . $this->tableDept . " ON wprg_pods_doctor_department.id=fld_doctors_deptid";
if(trim($name)!='')
$sqlW1 = " fld_doctors_name LIKE '%$name%' ";
if(trim($dept)!=0)
$sqlW2 = " fld_doctors_deptid='$dept' ";
if(!($sqlW1=='' && $sqlW2==''))
$sql .= " WHERE ";
if($sqlW1!='' && $sqlW2!='')
$sql .= $sqlW1 . " AND " . $sqlW2;
else
$sql .= $sqlW1 . $sqlW2;
/* echo '<div class="modal"><a href="javascript:closeModalEvent();" class="close-modal">Close</a>';
echo $sql;
echo '</div>'; */
$this->db->query($sql);
if($this->db->errno == 0)
{
$this->db->fetchArray();
$this->db->close();
return $this->db->resArr;
}
}
else
{
return $this->db->errno.$this->db->error;
}
}
/**
* Get all emps with Driving license expiring today
* @param $date-today
*/
public function getEmpsDrvLcneExpToday($tdy) {
$this->db->connect();
if($this->db->errno == 0)
{
$sql = "SELECT * FROM ".$this->tableEmp." WHERE emp_dri_lice_exp_date='".$tdy."'";
$this->db->query($sql);
if($this->db->errno == 0)
{
$this->db->fetchArray();
$this->db->close();
return $this->db->resArr;
}
}
else
{
return $this->db->errno.$this->db->error;
}
}
/**
* Get all subscribers of license expiring notification
* @param notification-$id
*/
public function getAllSubscribers($id) {
$this->db->connect();
if($this->db->errno == 0)
{
$sql = "SELECT name,email FROM ".$this->tableSub.
" WHERE notification_id ='".$id."'";
$this->db->query($sql);
if($this->db->errno == 0)
{
$this->db->fetchArray();
$this->db->close();
return $this->db->resArr;
}
}
else
{
return $this->db->errno.$this->db->error;
}
}
/**
* Get all supervisior emails
* @param emp-$id
*/
public function getAllSuperiors($id) {
$this->db->connect();
if($this->db->errno == 0)
{
$sql = "SELECT * FROM ".$this->tableEmp." WHERE emp_number IN(SELECT erep_sup_emp_number FROM ".$this->tableSuperior.
" WHERE erep_sub_emp_number ='".$id."')";
$this->db->query($sql);
if($this->db->errno == 0)
{
$this->db->fetchArray();
$this->db->close();
return $this->db->resArr;
}
}
else
{
return $this->db->errno.$this->db->error;
}
}
/**
* Get email array
* @param array
*/
public function getEmailStr($arr,$fld) {
$emailArr = array();
foreach ($arr as $key=>$val) {
array_push($emailArr,trim($val[$fld]));
}
return $emailArr;
}
/**
* Get email array
* @param array
*/
public function getMailBody1($arr) {
$emailBody = '<!DOCTYPE html><html><body>';
$emailBody .= '<div style="font-family: Arial;">' .
'<div id="divheader" style="background-color:#439CC8;text-align:center;">' .
'<h2>OakbendHRM - License Expiry Notification</h2>' .
'<div id="divheader" style="background-color:#439CC8;"></span>' .
'</div>' .
'<div id="divmailbody" style="background-color:#E9EFF0;padding:15px;">' .
'<div style="background-color:#FFFFFF;text-align:justify;">' .
'<p>Hello,</p>' .
'<p>This is to inform that the '.$arr['name'].' license of Mr./Ms. '.$arr['emp_firstname'].' '.$arr['emp_lastname'].' expires today.</p>' .
'<p style="text-decoration:underline;">Employee and License details are as follows:</p>' .
'<p>Employee Id: '.$arr['employee_id'].'<br>' .
'Employee DOB: '.$arr['emp_birthday'].'<br>' .
'License No.: '.$arr['license_no'].'</p>' .
'Please do not hesitate to contact for any further assistance.' .
'<p>Thank you<br>' .
'OakbendHRM - Admin<br>' .
'oakbendhrm@gmail.com</p>' .
'</div>' .
'</div>' .
'<div id="divfooter" style="background-color:#F1F1F1;font-size:11px;text-align:justify;">' .
'Disclaimer: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.' .
'<br>Copyright � 2014, All rights reserved.' .
'</div>' .
'</div>';
$emailBody .= '</body></html>';
return $emailBody;
}
/**
* Get email array
* @param array
*/
public function getMailBody($arr) {
$emailBody = '';
$emailBody .= 'This is to inform that the '.$arr['name'].' license of Mr./Ms. '.$arr['emp_firstname'].' '.$arr['emp_lastname'].' expires today.<br><br>' .
'Employee and License details are as follows:<br>' .
'Employee Id: '.$arr['employee_id'].'<br>' .
'Employee DOB: '.$arr['emp_birthday'].'<br>' .
'License No.: '.$arr['license_no'].'<br><br>' .
'Please do not hesitate to contact for any further assistance.' .
'<br><br>Thank you<br>' .
'OakbendHRM - Admin<br>' .
'oakbendhrm@gmail.com<br>';
return $emailBody;
}
public function insertDoctor($dataArr) {
$this->db->connect($this->dbName);
try
{
$sql = "INSERT INTO ".$this->tableDrs." ";
$beginning = true;
$fldLst = "(";
$valueLst = " VALUES (";
foreach($dataArr as $key => $value)
{
$fldLst .= ($beginning) ? " ".$key :", ".$key;
$valueLst .= ($beginning) ? " "."'".$value."'" :", "."'".$value."'";
$beginning = false;
}
$fldLst .= ")";
$valueLst .= ")";
$sql .= $fldLst . $valueLst;
//echo $sql;die();
$id = $this->db->executeInsert($sql);
return $id;
}
catch (Exception $e)
{
return $this->db->errno." : ".$this->db->error." : ".$e->getMessage();
}
}
}//class
?>