<?php
	include_once("../../cfg/db.php");;
	include_once("../../api/controllers/affiliations.php");
	include_once("../../api/controllers/cis.php");
	include_once("../../api/controllers/utility.php");

	$affiliations = new Affiliations(); 
	$cis = new CIS(); 
	$utility = new Utility(); 

	$generated_id = $db -> select("SELECT UUID_SHORT()");

	$type = $db->escape(trim($_POST['type']));
	$source = $db->escape(trim($_POST['source']));
	$first_name = $db->escape(trim($_POST['first_name']));
    $middle_name = $db->escape(trim($_POST['middle_name']));
    $last_name = $db->escape(trim($_POST['last_name']));
    $suffix_name = $db->escape(trim($_POST['suffix_name']));
    $corp_name = $db->escape(trim($_POST['corp_name']));
    $birth_date = $db->escape(trim($_POST['birth_date']));
    $gender = $db->escape(trim($_POST['gender']));

	$insert_lead_query = "
		INSERT INTO lms_leads (`id`, `source_id`, `first_name`, `middle_name`, `last_name`, `suffix_id`, `corporation_name`, `date_of_birth`, 
			`gender_id`, `type`) 
		VALUES('$generated_id', '$source', '$first_name', '$middle_name', '$last_name', '$suffix_name', 
			'$corp_name', '$birth_date', '$gender', '$type')";

	$insert = $db->sql_query_num_inserted($insert_lead_query);

	if($insert == 0){
		$arr['status'] = 0;
		$arr['message'] = "Something went wrong";
		
		echo json_encode($arr);
	}
	else {
		$arr['status'] = 1;
		$arr['message'] = "Lead details submitted";

		echo json_encode($arr);
	}
?>