<?php
    include_once("../../cfg/db.php");

    $type = $db->escape($_POST['type']);

    if($type == 1){ // add dealer
        $return_arr = array();
        $contact_person = $db->escape($_POST['contact_person']);
        $dealer_id = $db->escape($_POST['dealer_id']);
        $contact_1 = $db->escape($_POST['contact_1']);
        $contact_2 = $db->escape($_POST['contact_2']);
        $email = $db->escape($_POST['email']);
        $current_user = $_SESSION['user']['first_name'] . " " . $_SESSION['user']['last_name'];

        if(intval($db->select("SELECT COUNT(1) FROM source_lto_dealer_contacts WHERE dealer_id = '$dealer_id'")) > 0){
            $return_arr['status'] = 2; //duplicate dealer name
            echo json_encode($return_arr);
        }
        else {
            $current_date = $db->select("SELECT DATE_FORMAT(NOW(), '%M %d, %Y / %h:%i:%s %p') AS date");
            $added_by = $current_user . " (" . $current_date . ")";
            $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `contact1`, `contact2`, `email`, `added_by`, `modified_by`, `active`, `status`) 
                        VALUES('$contact_person', '$dealer_id', '$contact_1', '$contact_2', '$email', '$added_by', '', 1, 1)";
            // if($contact_1 == ""){
            //     if($contact_2 == ""){
            //         $added_by = $current_user . " (" . $current_date . ")";
            //         $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `added_by`, `modified_by`, `status`) VALUES('$contact_person', '$dealer_id', '$added_by', '', 1)";
            //         // echo $query; return;
            //         $db->sql_query($query);
            //     } 
            //     else {
            //         $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `contact2`, `added_by`, `modified_by`, `status`) VALUES('$contact_person', '$dealer_id', '$contact_2', '$current_user', '', 1)";
            //         // echo $query; return;
            //         $db->sql_query($query);
            //     }
            // } 
            // else {
            //     if($mobile_2 == ""){
            //         $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `contact1`, `added_by`, `last_modified_by`, `status`) VALUES('$contact_person', '$dealer_id', '$contact1', '$current_user', '', 1)";
            //         // echo $query; return;
            //         $db->sql_query($query);
            //     } 
            //     else {
            //         $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `mobile_number`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$mobile_1', '$current_user', '$current_user', '$current_date', 1)";
            //         // echo $query; return;
            //         $db->sql_query($query);
            //         $db->sql_query("INSERT INTO `source_dealer_mobile_contact_finance` (`contact_name`, `dealer_id`, `mobile_number`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$mobile_2', '$current_user', '$current_user', '$current_date', 1)");
            //     }
            // }

            $update_query_execute = $db->sql_query_num_inserted($query);

            if($update_query_execute > 0){
                $return_arr['status'] = 1;
                echo json_encode($return_arr);
            } 
            else {
                $return_arr['status'] = 0;
                echo json_encode($return_arr);
            }
        }
    } 
    else if($type == 2){ // reload / load dealer contact
        $dealer_id = $db->escape($_POST['dealer_id']);

        $details = "SELECT sldc.contact_person, sldc.contact1, sldc.contact2, sldc.email, sldc.added_by, sldc.modified_by, sldc.status 
            FROM source_lto_dealer_contacts sldc 
            INNER JOIN source_dealer sd ON sd.id = sldc.dealer_id 
            WHERE sldc.dealer_id = '$dealer_id' LIMIT 1"; // echo $details; exit;
        
        $details_list = $db->sql_query($details);

        foreach($details_list AS $data){
            $arr['contact_person'] = $data['contact_person'];
            $arr['contact1'] = $data['contact1'];
            $arr['contact2'] = $data['contact2'];
            $arr['email'] = $data['email'];
            $arr['added_by'] = $data['added_by'];
            $arr['modified_by'] = $data['modified_by'];
            $arr['status'] = $data['status'];
        }

        echo json_encode($arr);
    } 
    else if($type == 3){ // update dealer contact
        $dealer_id = $db->escape($_POST['dealer_id']);
        $new_contact_person = $db->escape(trim($_POST['new_contact_person']));
        $new_contact_1 = $db->escape($_POST['new_contact_1']);
        $new_contact_2 = $db->escape($_POST['new_contact_2']);
        $new_email = $db->escape($_POST['new_email']);

        $current_user = $_SESSION['user']['first_name'] . " " . $_SESSION['user']['last_name'];
        $current_date = $db->select("SELECT DATE_FORMAT(NOW(), '%M %d, %Y / %h:%i:%s %p') AS date");
        $modified_by = $current_user . " (" . $current_date . ")";

        // $set_status = 0;
        // $current_user = $_SESSION['user']['id'];

        // if($status == "true"){
        //     $set_status = 1;
        // }
        $update_query = "UPDATE `source_lto_dealer_contacts` SET `contact_person` = '$new_contact_person', `contact1` = '$new_contact_1', `contact2` = '$new_contact_2', `email` = '$new_email', `modified_by` = '$modified_by' 
                            WHERE `dealer_id` = '$dealer_id '";

        $update_query_execute = $db->sql_query_num_inserted($update_query);

        if($update_query_execute > 0){
            $arr['status'] = 1; //success update
            echo json_encode($arr);
        } 
        else {
            $arr['status'] = 0; //success failed
            echo json_encode($arr);
        }
    } 
    else if($type == 4){ // get selected dealer name in selected dealer in list (add dealer)
        // $companies = $db->escape($_POST['companies']);

        $query = "SELECT sldc.dealer_id, sd.name AS dealer 
            FROM source_lto_dealer_contacts sldc 
            INNER JOIN source_dealer sd ON sd.id = sldc.dealer_id 
            GROUP BY sldc.dealer_id 
            ORDER BY sd.name ASC";

        // echo $query; return;
		$dealer = $db->return_result($query); //echo $query; return;

		foreach($dealer as $data){
			echo "<option value='{$data['dealer_id']}'>".$data['dealer']."</option>";
		}
    } 
    else if($type == 5){ // search function
        $search_item = $db->escape(trim($_POST['search_item']));
    
	    $search_query = "SELECT sldc.dealer_id, sd.name AS dealer 
            FROM source_lto_dealer_contacts sldc 
            INNER JOIN source_dealer sd ON sd.id = sldc.dealer_id 
            WHERE (sd.name LIKE '%%$search_item%%') AND sldc.id != 0 GROUP BY sldc.dealer_id ORDER BY sd.name ASC";
	    // echo $search_query; return;
	    
	    $result = $db->sql_query($search_query);
	    //echo $search_query; return;

	    while($row = $result->fetch_assoc()) {
	        echo '<option value="'.$row['dealer_id'].'">'.$row["dealer"].'</option>';
	    }
    }
?>