<?php
include_once(ROOT . FOLDER_CORE . '/auth.php'); 
include_once(ROOT . FOLDER_CORE . '/class.php'); 

date_default_timezone_set('Europe/Madrid');


if ($auth == 1) {

    //Get external code 
    if(isset($_POST['code_ext'])){
        if(!empty($_POST['code_ext'])) {
            $Schema = new Schema($bd_conn);
            $code_ext = Statics::SafeInput($bd_conn, $_POST['code_ext']);
            if(isset($_POST['portal'])) {
                if(!empty($_POST['portal'])) {

                    $portal = Statics::SafeInput($bd_conn, $_POST['portal']);
        
                    //CREATE ASSOCIATIVE MULTIDIMENSIONAL ARRAY
                    $key_portal = [];
                    $sql_array = 'SELECT * FROM VEHICULOS_PORTALES';
                    $res_array = $bd_conn->query($sql_array);
                    while($row_array = $res_array->fetch_array()) {
                        $key_portal[$row_array['ALIAS']] = [];
                        array_push($key_portal[$row_array['ALIAS']], $row_array['CODIGO'], $row_array['DESCRIPCION']);
                    }
                    $res = $Schema->executeQuery('SELECT V.* 
                    FROM VEHICULOS V
                    INNER JOIN VEHICULOS_PUBLICACIONES P ON V.CODIGO = P.VEHICULO
                    AND P.ACTIVO = ?
                    AND P.PORTAL = ?
                    WHERE V.CODE_EXT = ?', 'iis', [1, $key_portal[$portal][0], $code_ext]);
                    if($res->num_rows) {
                        $nr = 0;
                        while($row = $res->fetch_array()) {
                            $nr++;
                            $date = date('Y-m-d H:i:s');
                            $Schema->executeQuery('UPDATE VEHICULOS_PUBLICACIONES SET FIN = ?, ACTIVO = ? WHERE PORTAL = ? AND VEHICULO = ?', 'siii', [$date, 0, $key_portal[$portal][0], $row['CODIGO']]);
                        }
                        $data = [
                            'status'            =>  'Successful',
                            'message'           =>  'Number of vehicles updated: ' . $nr
                        ];
                    } else {
                        $data = [
                            'status'            =>  'Warning',
                            'message'           =>  'No vehicles with external code: ' . $code_ext
                        ];
                    }
                    
                } else {
                    $data = [
                        'status'            =>  'Error',
                        'message'           =>  'Portal key are empty'
                    ];
                }
            } else {
                $data = [
                    'status'            =>  'Error',
                    'message'           =>  'Portal key not found'
                ];
            }

        } else {
            $data = [
                'status'            =>  'Error',
                'message'           =>  'External code is empty'
            ];
        }
    } else {
        $data = [
            'status'            =>  'Error',
            'message'           =>  'External code not found'
        ];
    }
    
}elseif ($auth == 0) {
    $data = [
        "code"      =>      "unauthorized_client",
        "message"   =>      "Invalid authorization token"
    ];
    
}
$bd_conn->close();

header("Content-type: application/json; charset=utf-8");
echo json_encode($data);



?>