'Default',
'basePath' => dirname(__FILE__)
));
class camp_alkem_cronpopupmails
{
var $mysqlconfig;
var $mysqldb;
var $data_grid;
var $from;
function camp_alkem_cronpopupmails()
{
$this->from="alkemcamps@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 getFTM($camp_id)
{
$validator = new Zend_Validate_EmailAddress();
$sql="SELECT DISTINCT email_id_of_me FROM alkem_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 alkem_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 head_users($zone)
{
// var_dump($zone);
$sql="SELECT email_id FROM sponcerer_heads WHERE SPON_ID='5' and zone='$zone' and uid not in ('6','27')";
$rec=$this->fetchAll($sql);
$validator = new Zend_Validate_EmailAddress();
foreach($rec as $k=>$email)
{
if ($validator->isValid(trim($email['email_id'])))
{
array_push($this->to,$email['email_id']);
// array_push($this->cc,"sneha.anaokar@metropolisindia.com");
}
}
array_push($this->cc,"aquil.faruqui@metropolisindia.com");
array_push($this->cc,"swati.shinde@metropolisindia.com");
//array_push($this->cc,"snehal.bhosale@metropolisindia.com");
array_push($this->cc,"it.support@metropolisindia.com");
// array_push($this->cc,"aquil.faruqui@metropolisindia.com","swati.shinde@metropolisindia.com","snehal.bhosale@metropolisindia.com","it.support@metropolisindia.com");
}
function send_mail($subject,$from,$to,$cc,$htmlbody,$textbody)
{
$config = array('auth' => 'login',
'username' => 'alkemcamps@metropolisindia.com',
'password' => 'Alk@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)
{
//var_dump($to);
//var_dump($cc);
// 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 preparetable()
{
$table="| ZONE |
REGION |
HEADQUARTERS |
DOCTOR NAME |
CAMP TYPE |
CAMP DATE & TIME |
VENUE ADDRESS |
|---|
";
foreach($this->data_grid as $k=>$rdata)
{
$zone=$rdata['zone'];
$region=$rdata['region'];
$headquarters=$rdata['headquarters'];
$doctor_name=$rdata['doctor_name'];
$test_type=$rdata['test_type'];
$camp_date=$rdata['camp_date'];
$venue_address=$rdata['venue_address'];
$phlebotomist_name=$rdata['phlebotomist_name'];
$phlebotomist_number=$rdata['phlebotomist_number'];
$contact_no_of_ram=$rdata['contact_no_of_ram'];
$name_of_asm=$rdata['name_of_asm'];
$contact_no_of_asm=$rdata['contact_no_of_asm'];
$email_id_of_asm=$rdata['email_id_of_asm'];
$me_name=$rdata['me_name'];
$contact_no_of_me=$rdata['contact_no_of_me'];
$email_id_of_me=$rdata['email_id_of_me'];
$table.="
| $zone |
$region |
$headquarters |
$doctor_name |
$test_type |
$camp_date |
$venue_address |
";
}
$table.="
";
//
// $table.="In case you do not receive it kindly get back to us on the below mentioned numbers.
";
// if($zone=='WEST'){$format.="Ms. Swati Shinde
// Deputy Manager - Clinical Research
// 02230840738/ 02233143266
";}
// if($zone=='NORTH'){$format.="Ms. Sayli Rane
// - Clinical Research
// 02230840737 /02233143255
";}
// if($zone=='EAST'){$format.="Ms. Kamakshi Desai
// - Clinical Research
// 02230840740 /02233143288
";
// //var_dump($format);}
// $table.=$format;
return $table;
}
function camp_alkem_intimation()
{
$this->to=array();
$this->cc=array();
// $to=$this->getFTM($camp_id);
$sql="SELECT DISTINCT
a.camp_id,
c.zone,
c.region,
c.headquarters,
Case
when a.test_type = 1 then 'HbA1C'
when a.test_type = 2 then 'Lipid'
END As test_type,
a.name_of_asm,
a.contact_no_of_asm,
a.email_id_of_asm,
a.me_name,
a.contact_no_of_me,
a.email_id_of_me,
a.doctor_name,
a.doctor_contact_number,
a.doctor_email,
date_format(a.camp_date,'%d %M,%Y %h:%i %p') as camp_date,
a.venue_address
FROM alkem_camps a
INNER JOIN masters_alkem b ON (a.headquarters=b.hq_id)
INNER JOIN alkem_headquarters c ON (b.headquarters=c.id)
WHERE a.freeze=1
AND a.pfreeze=0
and date_format(camp_date,'%Y-%m-%d') = CURDATE() + INTERVAL 1 DAY";
$this->data_grid=$this->fetchAll($sql);
if(count($this->data_grid)>0)
{
$zone=$this->data_grid[0]['zone'];
$subject="Reminder for Phlebotomist details";
$bodyhtml="Dear Team,
Gentle Reminder
Kindly consider this as a gentle reminder to fill the Phlebotomist details for below mentioned Alkem camp on the following link:http://support.metropolisindia.com/camps/ .
";
$new_body=$this->preparetable();
$bodyhtml.=$new_body;
//$this->head_users($zone);
// var_dump($this->cc);
// var_dump($this->to);
//array_push($this->cc,"himanshu.bhatia@metropolisindia.com");
array_push($this->to,"hemant.dandekar@metropolisindia.com");
array_push($this->to,"namdeo.gorule@metropolisindia.com");
array_push($this->to,"deepika.zende@metropolisindia.com");
array_push($this->to,"sneha.kulkarni@metropolisindia.com");
array_push($this->to,"nikunj.badeliya@metropolisindia.com");
array_push($this->to,"urmila.kadam@metropolisindia.com");
array_push($this->cc,"aquil.faruqui@metropolisindia.com");
array_push($this->cc,"swati.shinde@metropolisindia.com");
array_push($this->cc,"sayli.rane@metropolisindia.com");
array_push($this->cc,"mugdha.hule@metropolisindia.com");
array_push($this->cc,"it.support@metropolisindia.com");
$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' => 'alkemcamps@metropolisindia.com',
'password' => 'alk@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);
}
}
/// 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_alkem_cronpopupmails();
$lm->camp_alkem_intimation();
//$lm->camp_kartavya_intimation();
//$lm->camp_remainder();
//$lm->camp_last_remainder();
//$lm->camp_last_remainder1();
echo "End Ok...!";
?>