handler.php

<?php
    
    require('socket.php');
    
    $key = 'AIzaSyAQycDst2P2OXWlWSnujvDHmX-h_R6o1tI';
    
    if(!empty($_POST['action'])) {
        switch($_POST['action']) {
            case 'makes':
                findCarMakes();
                break;
            case 'models':
                findCarModels($_POST['make']);
                break;
            case 'engines':
                findCarEngines($_POST['model']);
                break;
            case 'save':
                save($_POST);
                break;
            case 'geocode':
                getGeoCode($_POST['zipcode']);
                break;
            default:
                echo json_encode($_POST);
                break;
        }
    }
    
    function findCarMakes()
    {
        global $connection;
        
        $query = "SELECT * FROM makes";
        $result = mysqli_query($connection, $query);
        
        $makes = mysqli_fetch_all($result);
        
        echo json_encode($makes);
    }
    
    function findCarModels($make)
    {
        global $connection;
        
        $query = "SELECT * FROM models WHERE make=".$make;
        $result = mysqli_query($connection, $query);
        
        $models = mysqli_fetch_all($result);
        
        echo json_encode($models);
        
    }
    
    function findCarEngines($model)
    {
        global $connection;
        
        $query = "SELECT * FROM engines WHERE model=".$model;
        
        $result = mysqli_query($connection, $query);
        
        $engines = mysqli_fetch_all($result);
        
        echo json_encode($engines);
    }

    function save($post)
    {
        global $connection;
        
        $query = "SELECT makes.name AS Make, 
                models.name AS Model, 
                engines.size AS Engine
                FROM makes 
                INNER JOIN models
                ON makes.id = models.make
                INNER JOIN engines
                ON models.id = engines.model
                WHERE makes.id=".$post['make']." AND models.id=".$post['model']." AND engines.id=".$post['engine'];
        
        $result = mysqli_query($connection, $query);
        
        $selection = mysqli_fetch_assoc($result);
    
        $query = "INSERT INTO sales (id, name, phone, email, zip, contact, make, model, engine, creation_date)
                VALUES(
                '', 
                '".$_POST['name']."', 
                '".$_POST['phone']."', 
                '".$_POST['email']."', 
                '".$_POST['zip']."',
                '".$_POST['contact']."',
                '".$selection['Make']."',
                '".$selection['Model']."',
                '".$selection['Engine']."',
                NOW()
                )";
        
        $result = mysqli_query($connection, $query);
        
        if ($result) {
            $post['make'] = $selection['Make'];
            $post['model'] = $selection['Model'];
            $post['engine'] = $selection['Engine'];
            echo json_encode($post);
        } else {
            echo false;
        }
    }
    
   function getGeoCode($zip)
    {
        global $key;
        
        $url = "https://maps.googleapis.com/maps/api/geocode/json?address=$zip&key=$key";
        
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        $response = json_decode(curl_exec($ch), true);
        curl_close($ch);
        
        if ($response['status'] == 'OK') {
            $geometry = $response['results'][0]['geometry']['location'];
    
            // $result = array(
            //     'lat'     => $geometry['lat'],
            //     'lng'     => $geometry['lng'],
            // );
        
            $list = getDealerList($geometry['lat'], $geometry['lng']);
            
            echo json_encode($list);
        } else {
            echo 'false';
        }
    }
    
    function getDealerList($lat, $lng)
    {
        global $key;
        
        $url = "https://maps.googleapis.com/maps/api/place/radarsearch/json?location=$lat,$lng&radius=5000&types=car_dealer&key=$key";
        
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        $response = json_decode(curl_exec($ch), true);
        curl_close($ch);
        
        if ($response['status'] == 'OK') {
            
            $dealers = array_slice($response['results'], 0, 10, true);
            
            $dealerList = array();
            foreach ($dealers as $key => $dealer) {
                $dealerList[$key]['lat']     = $dealer['geometry']['location']['lat'];
                $dealerList[$key]['lng']     = $dealer['geometry']['location']['lng'];
                $dealerList[$key]['placeId'] = $dealer['place_id'];
                $dealerList[$key]['details'] = getDealerDetails($dealer['place_id']);
            }
            
            return $dealerList;
            
        }
    }
    
    function getDealerDetails($id)
    {
        $key = 'AIzaSyD004JCCd7ns_3WAJUPOCP3ngBa-L_djH8';
        
        $url = "https://maps.googleapis.com/maps/api/place/details/json?placeid=$id&key=$key";
        
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        $response = json_decode(curl_exec($ch), true);
        curl_close($ch);
        
        $result = array();
        
        if ($response['status'] == 'OK') {
            $result['name'] = $response['result']['name'];
            $result['address'] = $response['result']['formatted_address'];
            $result['phone'] = $response['result']['formatted_phone_number'];
            $result['rating'] = $response['result']['rating'];
            $result['url'] = $response['result']['website'];
        
            return $result;
        }
    }
    
?>