'Default',
'basePath' => dirname(__FILE__)
));
$mysqlconfig = new Zend_Config(
array(
'database' => array(
'adapter' => 'pdo_mysql',
'params' => array(
'host' => 'localhost',
'dbname' => 'intranet',
'username' => 'root',
'password' => 'metropolisitteam',
)
)
)
);
$mysqldb = Zend_Db::factory($mysqlconfig->database);
$mysqldb->setFetchMode(Zend_Db::FETCH_ASSOC);
$leadid =htmlspecialchars(stripslashes($_GET['leadid']));// 14
if(isset($_GET['leadtype'])){$leadtype =htmlspecialchars(stripslashes($_GET['leadtype']));}else{$leadtype="";}// 20
if(isset($_GET['prefix'])){$prefix =htmlspecialchars(stripslashes($_GET['prefix']));}else{$prefix="";}// 20
if(isset($_GET['name'])){$name =htmlspecialchars(stripslashes($_GET['name']));}else{$name="";}// 100
if(isset($_GET['mobile'])){$mobile =htmlspecialchars(stripslashes($_GET['mobile']));}else{$mobile="";}// 20
if(isset($_GET['phone'])){$phone =htmlspecialchars(stripslashes($_GET['phone']));}else{$phone="";}// 20
if(isset($_GET['email'])){$email =htmlspecialchars(stripslashes($_GET['email']));}else{$email="";}// 100
if(isset($_GET['date'])){$date =htmlspecialchars(stripslashes($_GET['date']));}else{$date="";}//
if(isset($_GET['category'])){$category =htmlspecialchars(stripslashes($_GET['category']));}else{$category="";}// 100
if(isset($_GET['area'])){$area =htmlspecialchars(stripslashes($_GET['area']));}else{$area="";}// 100
if(isset($_GET['city'])){$city =htmlspecialchars(stripslashes($_GET['city']));}else{$city="";}// 100
if(isset($_GET['brancharea'])){$brancharea =htmlspecialchars(stripslashes($_GET['brancharea']));}else{$brancharea="";}// 100
if(isset($_GET['dncmobile'])){$dncmobile =htmlspecialchars(stripslashes($_GET['dncmobile']));}else{$dncmobile="";}// 20
if(isset($_GET['dncphone'])){$dncphone =htmlspecialchars(stripslashes($_GET['dncphone']));}else{$dncphone="";}// 20
if(isset($_GET['company'])){$company =htmlspecialchars(stripslashes($_GET['company']));}else{$company="";}// 20
if(isset($_GET['pincode'])){$pincode =htmlspecialchars(stripslashes($_GET['pincode']));}else{$pincode="";}// 6
if(isset($_GET['time'])){$time =htmlspecialchars(stripslashes($_GET['time']));}else{$time="";}//
if(isset($_GET['branchpin'])){$branchpin =htmlspecialchars(stripslashes($_GET['branchpin']));}else{$branchpin="";}// 100
$leaddate=date("Y-m-d",strtotime("now"));
//var_dump($leaddate);
//exit;
$leadid =$mysqldb->quote(addslashes($leadid));
$leadtype =$mysqldb->quote(addslashes($leadtype));
$prefix =$mysqldb->quote(addslashes($prefix));
$name =$mysqldb->quote(addslashes($name));
$mobile =$mysqldb->quote(addslashes($mobile));
$phone =$mysqldb->quote(addslashes($phone));
$email =$mysqldb->quote(addslashes($email));
$date =$mysqldb->quote(addslashes($date));
$category =$mysqldb->quote(addslashes($category));
$area =$mysqldb->quote(addslashes($area));
$city =$mysqldb->quote(addslashes($city));
$brancharea=$mysqldb->quote(addslashes($brancharea));
$dncmobile =$mysqldb->quote(addslashes($dncmobile));
$dncphone =$mysqldb->quote(addslashes($dncphone));
$company =$mysqldb->quote(addslashes($company));
$pincode =$mysqldb->quote(addslashes($pincode));
$time =$mysqldb->quote(addslashes($time));
$branchpin =$mysqldb->quote(addslashes($branchpin));
//var_dump($booking_status) ;
// exit;
$sql="INSERT INTO jd_lead_2014(
leaddate,
leadid,
leadtype,
prefix,
name,
mobile,
phone,
email,
`date`,
requirement,
city,
area,
brancharea,
dncmobile,
dncphone,
company_name,
pincode,
`time`,
branch_pin,
URL_TYPE,
leadSource
)
VALUES
(
' $leaddate',
$leadid,
$leadtype,
$prefix,
$name,
$mobile,
$phone,
$email,
$date,
$category,
$city,
$area,
$brancharea,
$dncmobile,
$dncphone,
$company,
$pincode,
$time,
$branchpin,
'Lead',
'JustDial')
;";
try
{
//var_dump($sql);
//exit;
$mysqldb->query($sql);
$leadid =htmlspecialchars(stripslashes($_GET['leadid']));
$leadtype =htmlspecialchars(stripslashes($_GET['leadtype']));
$prefix =htmlspecialchars(stripslashes($_GET['prefix']));
$name =htmlspecialchars(stripslashes($_GET['name']));
$mobile =htmlspecialchars(stripslashes($_GET['mobile']));
$phone =htmlspecialchars(stripslashes($_GET['phone']));
$email =htmlspecialchars(stripslashes($_GET['email']));
$date =htmlspecialchars(stripslashes($_GET['date']));
$category =htmlspecialchars(stripslashes($_GET['category']));
$city =htmlspecialchars(stripslashes($_GET['city']));
$area =htmlspecialchars(stripslashes($_GET['area']));
$brancharea =htmlspecialchars(stripslashes($_GET['brancharea']));
$dncmobile =htmlspecialchars(stripslashes($_GET['dncmobile']));
if($dncmobile==1){$dncmobile="Yes";}else{$dncmobile="No";}
$dncphone =htmlspecialchars(stripslashes($_GET['dncphone']));
if($dncphone==1){$dncphone="Yes";}else{$dncphone="No";}
$company =htmlspecialchars(stripslashes($_GET['company']));
$pincode =htmlspecialchars(stripslashes($_GET['pincode']));
$time =htmlspecialchars(stripslashes($_GET['time']));
$branch_pin =htmlspecialchars(stripslashes($_GET['branch_pin']));
$leaddate=date("Y-m-d",strtotime("now"));
$subject="New Lead from Pan Just Dial By- ".$name;
//var_dump($company);
//exit;
$body="Dear Team,
| lead Id | : | ".$leadid." |
| Leadtype | : | ".$leadtype." |
| Caller Prifix | : | ".$prefix." |
| Caller Name | : | ".$name." |
| Caller Mobile | : | ".$mobile." |
| Caller Phone | : | ".$phone." |
| Caller Email | : | ".$email." |
| Booking Date | : | ".$date." |
| Caller's requirement | : | ".$category." |
| Caller's city | : | ".$city." |
| Caller's area | : | ".$area." |
| Branch Area | : | ".$brancharea." |
| DNC Mobile | : | ".$dncmobile." |
| DNC Phone | : | ".$dncphone." |
| Company Name | : | ".$company." |
| Caller's Pincode | : | ".$pincode." |
| Branch pin | : | ".$branch_pin." |
| Lead generated TimeStamp | : | ".$time." |
Click Here To View Form
With Regards,
IT Team
";
// echo $body;
// var_dump($body);
// exit;
// http://support.metropolisindia.com/mhl/JustDialLead.php?leadid=1113&leadtype=44444&prefix=12345679&name=Dummy user1&mobile=9077655465&phone=234636547&email=sneha@metropolisindia.com&date=2014-06-21&category=dummy category&area=dummy area&city=dummy city&brancharea=dummy brancharea&dncmobile=9845745747&dncphone=34345657&company=dummy company&pincode=423355&time=&branchpin=456735
// http://support.metropolisindia.com/mhl/JustDialLead.php?leadid=1133&leadtype=44467&prefix=Mr&name=Dummy user Himanshu&mobile=9664752055&phone=234636547&email=himanshu.bhatiya@metropolisindia.com&date=2014-08-12&category=dummy category&area=dummy area&city=Surat&brancharea=dummy brancharea&dncmobile=9845745747&dncphone=34345657&company=dummy company&pincode=423355&time=&branchpin=456735
// http://support.metropolisindia.com/mhl/JustDialLead.php?leadid=1134&leadtype=44468&prefix=Ms&name=Dummy user &mobile=7506166932&phone=234636547&email=sneha.anaokar@metropolisindia.com&date=2014-08-12&category=dummy category&area=dummy area&city=Bangalore&brancharea=dummy brancharea&dncmobile=9845745747&dncphone=34345657&company=dummy company&pincode=423355&time=&branchpin=456735
//Click Here To View Form
$to=array();
// $sql=" SELECT location_id from pan_jd_location WHERE location_name = '$city' ; ";
//// $sql=" SELECT location_id from pan_jd_location WHERE location_name = '$city' and location_name != 'Mumbai' ; ";
//
// $rec = $mysqldb->fetchall($sql) ;
// $location_id =$rec[0]["location_id"];
//
// if(isset($location_id))
// {
// $sql="SELECT a.email
// from pan_jd_location_user a
// inner join pan_jd_location b on (a.location_id=b.location_id)
// WHERE b.location_name='$city' and a.email_flag ='1';";
// $rsarr = $mysqldb->fetchall($sql) ;
// foreach($rsarr as $k=>$row)
// {
// array_push($to,$row['email']);
// }
// }
// else
// {
// $to=array("santosh.kumbhar@metropolisindia.com");
// }
//if($city=='Mumbai'){
//$to=array("sneha.anaokar@metropolisindia.com");}
//else if($city=='Bangalore'){
//$to=array("sneha.anaokar@metropolisindia.com");}
//else if($city=='Chennai'){
//$to=array("sneha.anaokar@metropolisindia.com");}
//else if($city=='Surat'){
//$to=array("sneha.anaokar@metropolisindia.com");}
//else if($city=='Ahmedabad'){
//$to=array("sneha.anaokar@metropolisindia.com");}
//else {$to=array("santosh.kumbhar@metropolisindia.com");}
$sql="SELECT distinct emailid from users where emailflag=1 and userid like '%s2sagent%' ; ";
$rsarr = $mysqldb->fetchall($sql) ;
foreach($rsarr as $k=>$row)
{
array_push($to,$row['emailid']);
// var_dump($to);
}
$cc=array("it.support@metropolisindia.com"); //to be commented after ward
$from="it.support@metropolisindia.com";
if($dnc==0){
send_mail($subject,$from,$to,$cc,$body,$textbody);}
}
catch (Exception $e)
{
//var_dump($e);
$sql="INSERT INTO jd_booking_log_error(
'leaddate',
leadid,
ref_num,
name,
mobile,
phone,
email,
date,
address,
company_name,
city,
area,
branch_pin,
company_phone,
time,
servicemode,
dncmobile,
dncphone,
leadSource
)
VALUES
(
$leaddate,
$leadid,
$ref_num,
$name,
$mobile,
$phone,
$email,
$date,
$address,
$company_name,
$city,
$area,
$branch_pin,
$company_phone,
$time,
$servicemode,
$dncmobile,
$dncphone,
'JustDial')
;";
$mysqldb->query($sql);
}
//echo $sql."
";
echo "Success";
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);
if($textbody=='')
{
$mail->setBodyHtml((string)$htmlbody);
}
if($htmlbody=='')
{
$mail->setBodyText((string)$textbody);
}
try {
$mail->send($tr);
} catch (Exception $e)
{
echo 'Caught exception: ', $e->getMessage(), "\n";
}
}
?>