'Default',
'basePath' => dirname(__FILE__)
));
class camp_lupins_mails
{
var $mysqlconfig;
var $mysqldb;
var $data_grid;
var $from;
function camp_lupins_mails()
{
$this->from="lupinarogya@metropolisindia.com";
$this->mysqlconfig = new Zend_Config(
array(
'database' => array(
'adapter' => 'Pdo_Mysql',
'params' => array(
'host' => 'localhost',
'dbname' => 'ctcamps',
'username' => 'root',
'password' => 'metropolisitteam',
)
)
)
);
$this->mysqldb = Zend_Db::factory($this->mysqlconfig->database);
$this->mysqldb->setFetchMode(Zend_Db::FETCH_ASSOC);
}
function fetchAll($sql)
{
//var_dump($sql);
$rec=$this->mysqldb->fetchAll($sql);
return $rec;
}
function execute($sql)
{
// var_dump($sql);
$this->mysqldb->query($sql);
}
function get_asm_users($camp_id)
{
$validator = new Zend_Validate_EmailAddress();
$sql1="SELECT DISTINCT email_id_of_me FROM lupins_camps WHERE camp_id='camp_id'";
$me_rec=$this->fetchAll($sql);
foreach($me_rec as $k=>$email)
{
if ($validator->isValid(trim($email['email_id_of_me'])))
{
array_push($this->to,$email['email_id_of_me']);
}
}
$sql="SELECT DISTINCT email_id_of_asm FROM lupins_camps WHERE camp_id='$camp_id'";
$asm_rec=$this->fetchAll($sql);
foreach($asm_rec as $k=>$email)
{
if ($validator->isValid(trim($email['email_id_of_asm'])))
{
array_push($this->to,$email['email_id_of_asm']);
}
}
// return $this->to;
}
function get_head_users($zone)
{
$validator = new Zend_Validate_EmailAddress();
$sql="SELECT email_id FROM sponcerer_heads WHERE SPON_ID='6' and zone = '$zone' and uid not in ('4','54','2')";
$mum_users=$this->fetchAll($sql);
foreach($mum_users as $k=>$email)
{
if ($validator->isValid(trim($email['email_id'])))
{
array_push($this->to,$email['email_id']);
}
}
// return $this->cc;
}
function get_sister_users($hq_id)
{
$validator = new Zend_Validate_EmailAddress();
$sql="SELECT a.email_id from users a
inner join lupinssister_headquarters b on (a.uid=b.uid) WHERE b.headquarters='$hq_id'";
$lab_users=$this->fetchAll($sql);
foreach($lab_users as $k=>$email)
{
if ($validator->isValid(trim($email['email_id'])))
{
array_push($this->to,$email['email_id']);
}
}
// return $this->cc;
}
function send_mail($subject,$from,$to,$cc,$htmlbody,$textbody)
{
$config = array('auth' => 'login',
'username' => 'it.support@metropolisindia.com',
'password' => 'ItDvlp@2015',
'ssl' => 'tls');
$tr = new Zend_Mail_Transport_Smtp('192.168.23.66' , $config);
Zend_Mail::setDefaultTransport($tr);
$mail = new Zend_Mail();
$mail->setFrom((string)$from);
foreach ($to as &$value)
{
$mail->addTo((string)$value);
}
if (isset($cc))
{
foreach ($cc as &$value)
{
$mail->addCc((string)$value);
}
}
$mail->setSubject((string)$subject);
$mail->setBodyText((string)$textbody);
$mail->setBodyHtml((string)$htmlbody);
try
{
$mail->send($tr);
}
catch (Exception $e)
{
array_push($to,"aquil.faruqui@metropolisindia.com");
foreach ($to as &$value)
{
$mail->addTo((string)$value);
}
$subject="Mail Not Sent Due to Incorrect Email";
$mail->send($tr);
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
function adddetails($zone)
{
$details="Kindly revert on the below mentioned numbers incase of any queries or clarifications
";
if($zone=='WEST')
{
$details.="Ms. Swati Shinde
Deputy Manager - Clinical Research
02230840738 / 02233143266
";
}
else if($zone=='EAST')
{
$details.="Ms. Kamakshi Desai
Deputy Manager - Clinical Research
02230840740 / 02233143288
";
}
else if($zone=='SOUTH')
{
// var_dump($zone);
$details.="Ms. Mugdha Hule
Deputy Manager - Clinical Research
02230840739 / 02233143277";
}
else{}
$details.="
Mr. Siddhesh Chavan
Team Lead
02230840737 / 02233143255
Ms. Sayli Rane
Deputy Manager - Clinical Research
02230840737 / 02233143255
This Is An Auto Generated Email. Kindly Do Not Reply
";
//var_dump($bodyhtml);exit;
return $details;
}
function prepare_table_hqwise($hq_id, $phlebo, $reason)
{
$bodyhtml="
| ZONE |
REGION |
HEAD QUARTERS |
DOCTOR NAME |
CAMP DATE & TIME |
INTIMATION DATE & TIME |
INTIMATION DAYS |
CAMP ADDRESS | ";
if($phlebo==1){$bodyhtml.="PHLEBOTOMIST NAME & NUMBER | ";}
if($reason==1){$bodyhtml.="REASON FOR CHANGE IN SCHEDULE | ";}
$bodyhtml.="TOTAL PATIENTS |
ME NAME & NUMBER |
ASM NAME & NUMBER |
";
$sql="
SELECT
c.zone,
c.region,
c.headquarters,
a.doctor_name,
date_format(a.camp_date,'%d-%b-%Y %h:%i %p') as camp_date,
date_format(a.camp_intimation,'%d-%b-%Y %h:%i %p') as intimation_date,
DATEDIFF(a.camp_date,a.camp_intimation) as intimation_days,
a.venue_address as venue_address,
a.no_of_patients,
CONCAT(a.phlebotomist_name,'-','0',SUBSTRING(a.phlebotomist_number, -10)) as phle,
a.comments,
CONCAT(a.me_name,'-','0',SUBSTRING(a.contact_no_of_me, -10)) as pa,
CONCAT(a.name_of_asm,'-','0',SUBSTRING(a.contact_no_of_asm, -10)) as asm
FROM lupins_camps a
INNER JOIN masters_lupins b ON (a.headquarters=b.id)
INNER JOIN lupins_headquarters c ON (b.hq_id=c.hq_id)
WHERE b.hq_id='$hq_id'
and date(a.camp_date)= ADDDATE(CURDATE(),INTERVAL 1 DAY)
ORDER BY c.headquarters ";
// var_dump($sql);
// exit;
$newrec=$this->fetchAll($sql);
foreach($newrec as $m=>$data)
{
$zone=$data['zone'];
$region=$data['region'];
$headquarters=$data['headquarters'];
$doctor_name=$data['doctor_name'];
$camp_date=$data['camp_date'];
$intimation_date=$data['intimation_date'];
$intimation_days=$data['intimation_days'];
$venue_address=$data['venue_address'];
$no_of_patients=$data['no_of_patients'];
if($phlebo==1){$phle=$data['phle'];}
if($reason==1){$comments=$data['comments'];}
$pa=$data['pa'];
$asm=$data['asm'];
$bodyhtml.="
| $zone |
$region |
$headquarters |
$doctor_name |
$camp_date |
$intimation_date |
$intimation_days |
$venue_address |
";
if($phlebo==1){$bodyhtml.="$phle | ";}
if($reason==1){$bodyhtml.="$comments | ";}
$bodyhtml.="$no_of_patients |
$pa |
$asm |
";
}
$bodyhtml.="
";
return $bodyhtml;
}
function prepare_table_zonewise($zone, $phlebo, $reason)
{
$bodyhtml="
| ZONE |
REGION |
HEAD QUARTERS |
DOCTOR NAME |
CAMP DATE & TIME |
INTIMATION DATE & TIME |
INTIMATION DAYS |
CAMP ADDRESS | ";
if($phlebo==1){$bodyhtml.="PHLEBOTOMIST NAME & NUMBER | ";}
if($reason==1){$bodyhtml.="REASON FOR CHANGE IN SCHEDULE | ";}
$bodyhtml.="TOTAL PATIENTS |
ME NAME & NUMBER |
ASM NAME & NUMBER |
";
$sql="
SELECT
c.zone,
c.region,
c.headquarters,
a.doctor_name,
date_format(a.camp_date,'%d-%b-%Y %h:%i %p') as camp_date,
date_format(a.camp_intimation,'%d-%b-%Y %h:%i %p') as intimation_date,
DATEDIFF(a.camp_date,a.camp_intimation) as intimation_days,
a.venue_address as venue_address,
a.no_of_patients,
CONCAT(a.phlebotomist_name,'-','0',SUBSTRING(a.phlebotomist_number, -10)) as phle,
a.comments,
CONCAT(a.me_name,'-','0',SUBSTRING(a.contact_no_of_me, -10)) as pa,
CONCAT(a.name_of_asm,'-','0',SUBSTRING(a.contact_no_of_asm, -10)) as asm
FROM lupins_camps a
INNER JOIN masters_lupins b ON (a.headquarters=b.id)
INNER JOIN lupins_headquarters c ON (b.hq_id=c.hq_id)
WHERE c.zone='$zone'
and date(a.camp_date)= ADDDATE(CURDATE(),INTERVAL 1 DAY)
ORDER BY c.headquarters ";
// var_dump($sql);
// exit;
$newrec=$this->fetchAll($sql);
foreach($newrec as $m=>$data)
{
$zone=$data['zone'];
$region=$data['region'];
$headquarters=$data['headquarters'];
$doctor_name=$data['doctor_name'];
$camp_date=$data['camp_date'];
$intimation_date=$data['intimation_date'];
$intimation_days=$data['intimation_days'];
$venue_address=$data['venue_address'];
$no_of_patients=$data['no_of_patients'];
if($phlebo==1){$phle=$data['phle'];}
if($reason==1){$comments=$data['comments'];}
$pa=$data['pa'];
$asm=$data['asm'];
$bodyhtml.="
| $zone |
$region |
$headquarters |
$doctor_name |
$camp_date |
$intimation_date |
$intimation_days |
$venue_address |
";
if($phlebo==1){$bodyhtml.="$phle | ";}
if($reason==1){$bodyhtml.="$comments | ";}
$bodyhtml.="$no_of_patients |
$pa |
$asm |
";
}
$bodyhtml.="
";
return $bodyhtml;
}
function camp_lupins_reminder()
{
$sql="SELECT DISTINCT c.zone
FROM lupins_camps a
INNER JOIN masters_lupins b ON (a.headquarters=b.id)
INNER JOIN lupins_headquarters c ON (b.hq_id=c.hq_id)
WHERE a.freeze=1
and date(a.camp_date)= ADDDATE(CURDATE(),INTERVAL 1 DAY)
ORDER BY c.headquarters ";
//echo $sql;
// var_dump($sql);
// exit;
$rec=$this->fetchAll($sql);
foreach($rec as $k=>$row)
{
$this->to=array();
$this->cc=array();
$camp_id=$row['camp_id'];
$zone=$row['zone'];
// $to=$this->get_asm_users($camp_id);
//echo $zone;
//echo count($rec);
// if(count($rec)>0)
// {
$subject="Lupin Camp Reminder email for - $zone";
$bodyhtml="Dear Lupin Team,
This is reminder mail for tommorows Lupin camp.
";
$bodyhtml.=$this->prepare_table_zonewise($zone,0,0);
$bodyhtml.=$this->adddetails($zone);
// $this->get_asm_users($camp_id);
// $this->get_sister_users($hq_id);
$this->get_head_users($zone);
// $asm_users=implode(",",$this->get_asm_users($camp_id));
// $sister_users=implode(",",$this->get_sister_users($hq_id));
// $head_users=implode(",",$this->get_head_users($zone));
//
// $bodyhtml.=" $asm_users ".$asm_users."
// $sister_users ".$sister_users."
// $head_users ".$head_users."
";
array_push($this->cc,"it.support@metropolisindia.com");
//echo $this->from;
//echo $this->to;
// }
$this->send_mail($subject,$this->from,$this->to,$this->cc,$bodyhtml,$textbody);
}
}
function camp_sisterlab_reminder()
{
$sql="SELECT DISTINCT c.zone,c.headquarters AS headquarters,b.hq_id as hq_id
FROM lupins_camps a
INNER JOIN masters_lupins b ON (a.headquarters=b.id)
INNER JOIN lupins_headquarters c ON (b.hq_id=c.hq_id)
WHERE a.freeze=1
and date(a.camp_date)= ADDDATE(CURDATE(),INTERVAL 1 DAY)
ORDER BY c.headquarters ";
//echo $sql;
// var_dump($sql);
// exit;
$rec=$this->fetchAll($sql);
foreach($rec as $k=>$row)
{
$this->to=array();
$this->cc=array();
$camp_id=$row['camp_id'];
$zone=$row['zone'];
$headquarters=$row['headquarters'];
$hq_id=$row['hq_id'];
// $to=$this->get_asm_users($camp_id);
//echo $zone;
//echo count($rec);
// if(count($rec)>0)
// {
$subject="Lupin Camp - Reminder email for - $headquarters";
$bodyhtml="Dear Metropolis Team,
This is reminder mail for tommorows Lupin camp.
";
$bodyhtml.=$this->prepare_table_hqwise($hq_id,0,0);
$bodyhtml.=$this->adddetails($zone);
$this->get_sister_users($hq_id);
// $this->get_head_users($zone);
// $asm_users=implode(",",$this->get_asm_users($camp_id));
// $sister_users=implode(",",$this->get_sister_users($hq_id));
// $head_users=implode(",",$this->get_head_users($zone));
//
// $bodyhtml.=" $asm_users ".$asm_users."
// $sister_users ".$sister_users."
// $head_users ".$head_users."
";
array_push($this->cc,"sayli.rane@metropolisindia.com","siddhesh.chavan@metropolisindia.com");
// array_push($this->cc,"it.support@metropolisindia.com");
echo $this->from;
echo $this->to;
// }
$this->send_mail($subject,$this->from,$this->to,$this->cc,$bodyhtml,$textbody);
}
}
function send_mail1($subject,$from,$to,$cc,$htmlbody,$textbody)
{
$config = array('auth' => 'login',
'username' => 'it.support@metropolisindia.com',
'password' => 'metropolis',
'ssl' => 'tls');
$tr = new Zend_Mail_Transport_Smtp('192.168.23.66' , $config);
Zend_Mail::setDefaultTransport($tr);
$mail = new Zend_Mail();
$mail->setFrom((string)$from);
foreach ($to as &$value)
{
$mail->addTo((string)$value);
}
if (isset($cc))
{
foreach ($cc as &$value)
{
$mail->addCc((string)$value);
}
}
/// array_push($cc,"aquil.faruqui@metropolisindia.com");
// $mail->addBcc("tina.makhija@kartavyahealtheon.com");
// $mail->addBcc("manpreetkaur.gill@kartavyahealtheon.com");
// $mail->addBcc("harshada.haldankar@kartavyahealtheon.com");
$mail->setSubject((string)$subject);
$mail->setBodyText((string)$textbody);
$mail->setBodyHtml((string)$htmlbody);
try {
$mail->send($tr);
} catch (Exception $e)
{
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
}
$lm=new camp_lupins_mails();
$lm->camp_lupins_reminder();
$lm->camp_sisterlab_reminder();
echo "End Ok...!";
?>