<?php
/**
* Created by Mediterranean Develup Solutions.
* User: Carlos.Rojas
* Date: 19/07/2017
* Time: 13:00
*/
namespace App\Controller;
use App\Entity\Cities;
use App\Entity\Provinces;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Session\Session;
use App\Entity\Regions;
class OperationsController extends AbstractController
{
/**
* @Route("/operations/getRegions", name="get_regions")
*/
public function regionAction(Request $request) {
$cod_pais = $request->request->get('pais');
$em = $this->getDoctrine()->getManager();
$regiones = $em->getRepository(Regions::class)->findBycountry_id($cod_pais);
foreach($regiones as $region){
$datos[] = array(
"code" => $region->getCode(),
"countryId" => $region->getCountryid(),
"id" => $region->getId(),
"name" => $region->getRegion(),
);
}
$return = array(
'regiones' => $datos,
);
$response = new JsonResponse($return);
return $response;
}
/**
* @Route("/operations/getProvinces", name="get_provinces")
*/
public function provincesAction(Request $request) {
$region = $request->request->get('region');
// $region = $_POST['region'];
$em = $this->getDoctrine()->getManager();
$provincias = $em->getRepository(Provinces::class)->findByRegionId($region);
$datos = array();
foreach($provincias as $provincia){
$datos[] = array(
"code" => $provincia->getCode(),
"countryId" => $provincia->getCountryid(),
"id" => $provincia->getId(),
"name" => $provincia->getName(),
);
}
$return = array(
'provinces' => $datos,
);
$response = new JsonResponse($return);
return $response;
}
/**
* @Route("/operations/getCities", name="get_cities")
*/
public function citiesAction(Request $request) {
// d($request);
// exit();
$cod_prov = $_POST['province'];
$em = $this->getDoctrine()->getManager();
$ciudades = $em->getRepository(Cities::class)->findByProvinceId($cod_prov);
$datos = array();
foreach($ciudades as $ciudad){
$datos[] = array(
"id" => $ciudad->getId(),
"latitude" => $ciudad->getLatitude(),
"longitude" => $ciudad->getLongitude(),
"name" => $ciudad->getCity(),
);
}
$return = array(
'ciudades' => $datos,
);
$response = new JsonResponse($return);
return $response;
}
}