';
// print_r($decoded);
$i=0;
$dbhost = 'localhost';
$dbuser = 'techwyse_stream';
$dbpassword = '@,9#w8Z)~*Nk';
$dbname = 'techwyse_streamline';
$con=mysqli_connect($dbhost,$dbuser,$dbpassword,$dbname);
if($decoded['submissions'])
{
//For checking yahoo link for organic medium
include_once('reference_site_url.php');
foreach($decoded['submissions'] as $order1)
{
$date_tochk=$order1['date'];
$date_tocheckadluge=$order1['date'];
//echo 'time- '.strtotime($date_tocheckadluge).'
';
$data_time= strtotime($date_tochk);
$exp = explode(" ",$date_tochk);
$date_tochk=$exp[0];
$yest = date('Y-m-d',strtotime("-0 days"));
if($date_tochk == $yest)
{
echo "innnnn
";
$reference_var_url=$order1['referer'];
$formhost=$order1['formhost'];
$adroll_source="";
$explode_array=explode('/',$reference_var_url);
$var_reference=get_reference_source(@$explode_array[2]);
if(preg_match("/utm_source=cpc-Google/",$reference_var_url,$match) )
{
$var_reference="Paid";
$source_wow="cpc-Google";
$match=1;
}
elseif(preg_match("/utm_source=cpc-google/",$reference_var_url,$match) )
{
$var_reference="Paid";
$source_wow="cpc-Google";
$match=1;
}
elseif(preg_match("/www.googleadservices.com/",$reference_var_url) )
{
$var_reference="Paid";
}
elseif(preg_match("/utm_source=cpc-Google/",$formhost,$match) )
{
$var_reference="Paid";
$source_wow="cpc-Google";
$match=1;
}
elseif(preg_match("/utm_source=cpc-google/",$formhost,$match) )
{
$var_reference="Paid";
$source_wow="cpc-Google";
$match=1;
}
elseif(preg_match("/www.googleadservices.com/",$formhost) )
{
$var_reference="Paid";
}
//check for direct medium
elseif(@$explode_array[2]=="www.streamlinemortgages.ca" ||@$explode_array[2]=="streamlinemortgages.ca" || empty($explode_array[2]) )
{
$adroll_url=@$explode_array[2];
$adroll_url_array=explode('&',$adroll_url);
$adroll_source=@$adroll_url_array[2];
$adroll_medium=@$adroll_url_array[1];
$adroll_campaign=@$adroll_url_array[2];
/* if($adroll_source=="utm_source=cpc-Google")
{
$var_reference="Paid";
} */
if($adroll_campaign=="utm_campaign=NewsFeed")
{
$var_reference="Paid";
}
else
{
$var_reference = "Direct";
}
}
else if(!empty($var_reference))
{
//echo $var_reference;
}
else
{
//echo $explode_array[2];
//exit;
if(strpos(@$explode_array[2],'doubleclick.net') !== false)
{
$var_reference="Paid";
}
else
{
$var_reference = "Referral";
}
}
$i++;
foreach($order1['fields'] as $key=>$fields)
{
if(@$fields['fieldid']==30836897)
{
$name = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30835396)
{
$phone = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30834702)
{
$email = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==31084863)
{
$postal = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30835200)
{
$comments = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30834833)
{
$other_fields['Credit Rating'] = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30834991)
{
$other_fields['Income Type'] = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30834749)
{
$other_fields['Purpose'] = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==31084612)
{
$other_fields['Amount Requested'] = @$fields['fieldvalue'];
}
if(@$fields['fieldid']==30834868)
{
$other_fields['Income Range'] = @$fields['fieldvalue'];
}
}
$newt=explode("-",$order1['date']);
$ntime = date("H:i:s", strtotime($newt[0]));
if($match!=1)
{
$adroll_source_lwr=strtolower($adroll_source);
if($adroll_source=="utm_source=cpc-google")
{
$source_wow="cpc-Google";
$var_reference="Paid";
}
else if(($var_reference=="Paid"))
{
$source_wow="doubleclick";
}
else
{
if(strpos(@$explode_array[2],'www') !== false)
{
$vit_source = explode(".",@$explode_array[2]);
$source_wow=$vit_source[1];
if($var_reference=="Referral")
{
if(strpos(@$explode_array[2],'.search.yahoo.com') !== false)
{
$vit_source = explode(".com",@$explode_array[2]);
$source_wow=$vit_source[0];
}
}
}
else
{
$vit_source = explode(".",@$explode_array[2]);
$source_wow=$vit_source[0];
if($var_reference=="Referral")
{
if(strpos(@$explode_array[2],'.search.yahoo.com') !== false)
{
$vit_source = explode(".com",@$explode_array[2]);
$source_wow=$vit_source[0];
}
}
}
}
if(strpos(@$explode_array[2],'facebook') !== false)
{
$source_wow="Facebook";
}
else if(strpos(@$explode_array[2],'twitter') !== false)
{
$source_wow="twitter";
}
}
// For viewing purpose just commented
echo "
".$i;
echo "
Reference-site :".$order1['referer']."
";
// echo "
Reference-site :".$reff."
";
//echo "
After Explode :".@$explode_array[2]."
";
// echo "Current date:".date('Y-m-d', strtotime("-4 days"));
// echo "mktime".date("Y-m-d", mktime(0, 0, 0, date("m") , date("d")-4,date("Y")));
$match=0;
$row = mysqli_query($con,"SELECT `leads_time` FROM `Form_Leads`");
// echo "SELECT `leads_time` FROM `Form_Leads`";
while($row1 = mysqli_fetch_array($row)) {
$previous_leads[] =$row1['leads_time'];
}
//Insert to Adluge
if(!in_array(strtotime($date_tocheckadluge),$previous_leads) ) {
if($source_wow !=""){ echo "
Source :".$source_wow."
"; }
echo "
Medim :".$var_reference."
";
echo "Name: ".$name;
echo "
";
echo "Email: ".$email;
echo "
";
echo "Phone: ".$phone;
echo "
";
echo "Time: ".$ntime;
echo "
";
echo "Comments: ".$comments;
echo "
";
echo "Postal: ".$postal;
echo "
";
echo '
';
echo date('Y-m-d h:i:s', strtotime("-0 days $newt[0]"));
echo "
-------------------------------------
";
if($var_reference !="")
{
$other_fields['medium'] = $var_reference;
}
echo "Others: ";
print_r($other_fields);
echo 'ifff :'.$date_tocheckadluge = strtotime($date_tocheckadluge);
$insert_results=mysqli_query($con,"INSERT INTO `Form_Leads`( `leads_time`) VALUES ('$date_tocheckadluge')");
if($order1['referer']){ $ref= $order1['referer']; }else{ $ref=$order1['formhost']; }
$lead = new clientcenter();
$lead->client_code="iz2517cflw4gb91"; // mandatory
$lead->tag="Wix Leads";
$lead->fname=$name;
if($source_wow !=""){ $lead->vitaly_source = $source_wow; }
$lead->email=$email;
//$lead->email='sujeesh@techwyseintl.com'; // for testing purpose
$lead->useragent= $order1['useragent'] ;//user_agent
$lead->remote_ip= $order1['ip'];//browser_ip
$lead->referrer= $ref ;//referring_site
$lead->contact_date=date('Y-m-d h:i:s', strtotime("-0 days $newt[0]"));// Paid
$lead->adl_ref=$ref; //referring_site
//$lead->medium= $var_reference;
$lead->phone=$phone;
$lead->postalcode=$postal;
$lead->comments=$comments;
$lead->other_fields=json_encode($other_fields);
$lead->budget="";
$lead->domain="";
$lead->status=1; // 1 =>Not spam. 0 => "spam"
$lead->send_to_adluge=true; // Set to true If you are sending leads to adluge //default true
$lead->send();
//mail("shilpa@techwyseintl.com","Test subject", $i);
}
}
}
}
else {
$issue="No order tracked on \n";
$myfile = fopen("issues.txt", "a") or die("Unable to open file!");
fwrite($myfile, $issue);
fclose($myfile);
}
?>