<?php
session_start();
include('connection.php');
error_reporting(0);

$firm_name=$_POST['firm_id'];    echo $firm_name;
$email=$_POST['email'];
$whatsapp=$_POST['whatsapp'];
$method=$_POST['method'];
$priority=$_POST['priority'];
$status=$_POST['status'];
$mnri_status=$_POST['mnri_status'];
$remarks=$_POST['remarks'];
$quatation=$_POST['quatation'];
$id=$_SESSION["userid"];
$date=date("Y-m-d");
$time=date("h:i a");
$dob=$_POST['dob'];

$follow_date=$_POST['follow_date'];
$follow_time=$_POST['follow_time'];

$followup_person_name=$_POST['followup_person_name'];
$followup_designation=$_POST['followup_designation'];
$followup_number=$_POST['followup_number'];
$activity_name=$_POST['activity_name'];

$contact_name1=$_POST['contact_name1'];
$designation1=$_POST['designation1'];
$contact_no1=$_POST['contact_no1'];
$excecutive=$_POST['excecutive'];

$source=$_POST['source'];
$source_name=$_POST['source_name'];
$consumer=$_POST['consumer'];

$target_file ='uploads/'.$date."-".$_FILES["quatation"]["name"];
move_uploaded_file($_FILES["quatation"]["tmp_name"], $target_file);

if(isset($_REQUEST['submit']))
{
	$sql="insert into marketing_activities(lid,date,time,method,email,whatsapp,contact_name1,designation1,number1,followup_person_name,followup_designation,followup_number,activity_name,followup_excecutive,lead_priority,lead_status,quatation_pdf,user_id,follow_date,follow_time,remarks,consumer,mnri_status,dob) values('$firm_name','$date','$time','$method','$email','$whatsapp','$contact_name1','$designation1','$contact_no1','$followup_person_name','$followup_designation','$followup_number','$activity_name','$excecutive','$priority','$status','$target_file','$id','$follow_date','$follow_time','$remarks','$consumer','$mnri_status','$dob')";	
       mysqli_query($con,$sql);
//echo $sql;	
	header('location:marketing_activities.php?log=insert');
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=marketing_activities.php?log=insert">'; 
}

if(isset($_REQUEST['customer']))
{
	$sql1="select * from leads where lid=$firm_name";
	$result1=mysqli_query($con,$sql1)or die(mysqli_error());
	$row1=mysqli_fetch_array($result1);
	$address=$row1['address'];
	$name_firm2=$row1['name_firm'];
	//echo $sql1."<br>";
	$sql="insert into marketing_activities(lid,date,time,method,email,whatsapp,contact_name1,designation1,number1,followup_person_name,followup_designation,followup_number,activity_name,followup_excecutive,lead_priority,lead_status,quatation_pdf,user_id,follow_date,follow_time,remarks,mnri_status,dob) values('$firm_name','$date','$time','$method','$email','$whatsapp','$contact_name1','$designation1','$contact_no1','$followup_person_name','$followup_designation','$followup_number','$activity_name','$excecutive','$priority','Customer','$target_file','$id','$follow_date','$follow_time','$remarks','$mnri_status','$dob')";
	mysqli_query($con,$sql);
    //echo $sql."<br><br><br>";

	$sqlc="insert into customer_details(lid,customer,address) values('$firm_name','$name_firm2','$address')";	
	mysqli_query($con,$sqlc);
	//echo "ffffffffffffff".$sqlc;

     header('location:customer_add.php?id='.$firm_name);
	 echo '<META HTTP-EQUIV="Refresh" Content="0; URL=customer_add.php?id='.$firm_name.'">'; 
}
if(isset($_REQUEST['End_followup']))
{	
	$sql="insert into marketing_activities(lid,date,method,email,whatsapp,contact_name1,designation1,number1,followup_person_name,followup_designation,followup_number,activity_name,followup_excecutive,lead_priority,lead_status,quatation_pdf,user_id,follow_date,follow_time,remarks,mnri_status,dob) values('$firm_name','$date','$method','$email','$whatsapp','$contact_name1','$designation1','$contact_no1','$followup_person_name','$followup_designation','$followup_number','$activity_name','$excecutive','$priority','Lost Lead','$target_file','$id','$follow_date','$follow_time','$remarks','$mnri_status','$dob')";
	
	mysqli_query($con,$sql);
	
	header('location:marketing_activities.php?log=insert');
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=marketing_activities.php?log=insert">'; 
}
?>