<?
require_once 'Zend/Loader/Autoloader.php';
$autoloader = Zend_Loader_Autoloader::getInstance();
$autoloader = new Zend_Application_Module_Autoloader(array(
            'namespace' => 'Default',
            'basePath'  => dirname(__FILE__)
));
class camp_roche_cumulativemail
{
	var $mysqlconfig;
	var $mysqldb;
	var $data_grid;
		var $from;

	function camp_roche_cumulativemail()
	{
		$this->from="it.support@metropoliscustomers.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 getZone($zone)
	{
			
			$validator = new Zend_Validate_EmailAddress();
		//	$sql="SELECT email_id FROM users_zone a,users b WHERE a.uid=b.uid and zone='$zone';";
			$sql="SELECT email_id FROM sponcerer_heads WHERE SPON_ID='5' and zone='$zone' and uid not in ('6','27')";
			$mum_users=$this->fetchAll($sql);
			foreach($mum_users as $k=>$email)
				{
					if ($validator->isValid(trim($email['email_id']))) 
					{
						array_push($this->cc,$email['email_id']);
					}
				}
			return $this->cc;
				
	}
	
	
//	function getLab($data_grid)
//	{
//		$validator = new Zend_Validate_EmailAddress();
//		foreach($data_grid as $k=>$rdata)
//				{
//					$hq_id=$rdata['hq_id'];
//					$sql="SELECT a.uid,b.email_id FROM users_hq_id a, users b WHERE a.uid=b.uid and a.hq_id='$hq_id';";
//					$hq_id_users=$this->fetchAll($sql);
//					foreach($hq_id_users as $k=>$email)
//					{
//						if ($validator->isValid(trim($email['email_id']))) 
//						{
//							array_push($this->to,$email['email_id']);
//						}
//					}
//				}
//	}
	
	
		function getLab($headquarters)
		{
			
			$validator = new Zend_Validate_EmailAddress();
			$sql="SELECT a.email_id from alkem_sisterlabusers a
															inner join alkemsister_hq_id b on (a.uid=b.uid) WHERE b.hq_id='$headquarters'";			
			$lab_users=$this->fetchAll($sql);
			foreach($lab_users as $k=>$email)
				{
					if ($validator->isValid(trim($email['email_id']))) 
					{
						array_push($this->cc,$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) 
		{
			//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 preparetablenocamp()
	{

		$table="Dear All,<br>No camps are scheduled for tomorrow.";
		return $table;
	}
	function preparetable()
	{

		$table="<table border= 2><tr bgcolor='#FFCC99'><th><font color='#RRGGBB'>ZONE</font></th>
												<th><font color='#RRGGBB'>REGION</font></th>
												<th><font color='#RRGGBB'>HEADQUARTERS</font></th>
												<th><font color='#RRGGBB'>DOCTOR NAME</font></th>
												<th><font color='#RRGGBB'>CAMP TYPE</font></th>												
												<th><font color='#RRGGBB'>CAMP DATE & TIME</font></th>
												<th><font color='#RRGGBB'>VENUE ADDRESS</font></th>
												<th><font color='#RRGGBB'>PHLEBOTOMIST DETAILS</font></th>
										</tr>";
				foreach($this->data_grid as $k=>$rdata)
				{
					
					$zone=$rdata['zone'];
					$region=$rdata['region'];
					$headquarters=$rdata['headquarters'];
					$doctor_name=$rdata['doctor_name'];
					$camp_date=$rdata['camp_date'];
					$camp_type=$rdata['camp_type'];
					$intimation_date=$rdata['intimation_date'];
					$intimation_days=$rdata['intimation_days'];
					$venue_address=$rdata['venue_address'];
					$no_of_patients=$rdata['no_of_patients'];
				
					$phlebotomist_name=$rdata['phle'];
					$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.="<tr>
											<td align='center'>$zone</td>
												<td align='center'>$region</td>
											<td align='center'>$headquarters</td>
											<td align='center'>$doctor_name</td>
											<td align='center'><b>$camp_type</b></td>
											<td align='center'>$camp_date</td>
											
											<td align='center'>$venue_address</td>
											<td align='center'>$phlebotomist_name</td>
											
											</tr>";
				}
				$table.="</table>";
				
			
//				$table.="<p>In case you do not receive it kindly get back to us on the below mentioned numbers.</p>";
//				if($zone=='WEST'){$format="<p>Ms. Swati Shinde<br/>
//											 Deputy Manager - Clinical Research<br/>
//											 02230840738/ 02233143266</p>";}
//				if($zone=='NORTH'){$format="<p>Ms. Sayli Rane<br/>
//											  - Clinical Research<br/>
//											 02230840737 /02233143255</p>";}
//				if($zone=='EAST'){$format="<p>Ms. Kamakshi Desai<br/>
//											  - Clinical Research<br/>
//											 02230840740 /02233143288</p>";}
//			
//				
//			/	$table.=$format;
				
				return $table;
	}

	function camp_roche_intimation()
	{

		
			$this->to=array();
			$this->cc=array();
			$subject="CUMULATIVE MAIL ";
//			$to=$this->getFTM($camp_id);
			$sql="SELECT 
							c.zone,
							c.region,
							c.headquarters,
							a.doctor_name,
							a.camp_type,
							date_format(a.camp_date,'%d-%M-%Y %h:%i %p') as camp_date,
							date_format(a.camp_intimation,'%d-%M-%Y %h:%i %p') as intimation_date,
							DATEDIFF(a.camp_date,a.camp_intimation) as intimation_days,
							CONCAT(a.venue_address,' Pincode: ',a.pincode) as venue_address,
							a.no_of_patients,
							CONCAT(a.phlebotomist_name,'-',a.phlebotomist_number) as phle,
							CONCAT(a.me_name,'-',a.contact_no_of_me) as pa,
							CONCAT(a.name_of_asm,'-',a.contact_no_of_asm) as abn
							FROM roche_camps a
							INNER JOIN masters_roche b ON (a.headquarters=b.hq_id)
							INNER JOIN roche_headquarters c ON (b.headquarters=c.headquarters)
						WHERE a.freeze=1
						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'];
						//	$cc=$this->getZone($zone);
						//	$cc=$this->getLab($headquarters);

				
							$bodyhtml="<p>Dear Team,</p>
													 <p>Please be informed that the below listed Roche Hepatitis Camps have been scheduled for tomorrow.</p>";			
							$new_body=$this->preparetable();
							$bodyhtml.=$new_body;
							array_push($this->to,"roche@metropolisiSndia.com");
//			array_push($this->cc,"roche@metropolisindia.com");
			array_push($this->cc,"aquil.faruqui@metropolisindia.com");
			array_push($this->cc,"it.support@metropolisindia.com");
	

						}	
						else
						{
						
							$new_body=$this->preparetablenocamp();
							$bodyhtml.=$new_body;
			array_push($this->to,"roche@metropolisiSndia.com");
			array_push($this->cc,"aquil.faruqui@metropolisindia.com");
			array_push($this->cc,"it.support@metropolisindia.com");
	//		array_push($this->cc,"himanshu.bhatia@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' => '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_roche_cumulativemail();
$lm->camp_roche_intimation();

//$lm->camp_kartavya_intimation();
//$lm->camp_remainder();
//$lm->camp_last_remainder();
//$lm->camp_last_remainder1();
echo "End Ok...!";
?>