public function getCity(Request $req)
{
$state = State::find($req->id);
$city = City::where('state_code', $state->code)->get();
$html = '<option value="" selected>Choose Option</option>';
foreach ($city as $cities) {
$html .= '<option value="' . $cities->id . '">' . $cities->name . '</option>';
}
echo $html;
}
public function cityAutocompleteAction()
{
$c = $this->query->get('c');
$cities = City::where('active', '=', 1)->where('name', '=', $c);
//
// $cities = $this->em->getRepository('PoiskRabotyMainBundle:City')->get(array(
// 'enabled' => true,
// 'search_start' => $c,
// ));
$json = array();
foreach ($cities as $city) {
$json[] = array('value' => $this->helper->getTranslation($city, 'title'), 'label' => $this->helper->getTranslation($city, 'title'));
}
return new JsonResponse($json);
}
public function getCity($country = null)
{
try {
$response = [];
$statusCode = 200;
//$city = City::all();
$city = City::where('city_accent', 'like', '%' . $country . '%')->take(10)->get();
foreach ($city as $c) {
$response[] = ['id' => $c->id, 'city_accent' => $c->city_accent . ' (' . $c->country_id . ')'];
}
} catch (Exception $e) {
$statusCode = 404;
} finally {
return Response::json($response, $statusCode);
}
}
public function locations($state_id, $city_key)
{
$city = City::where("estado_id", $state_id)->where("clave", $city_key)->first();
$locations = Location::where("municipio_id", $city->id)->get();
return response()->json($locations)->header('Access-Control-Allow-Origin', '*');
}
function result($id)
{
$blueprint = Blueprint::with(["questions.options"])->find($id);
$test = function ($question_type, $inegi_key) {
if (!$inegi_key) {
return "-";
}
switch ($question_type) {
case "location-a":
$key = substr($inegi_key->text_value, 0, 2);
$name = !empty($key) ? $this->states[$key] : "-";
break;
case "location-b":
$state_key = substr($inegi_key->text_value, 0, 2);
$state_name = !empty($state_key) ? $this->states[$state_key] : "-";
$city_key = substr($inegi_key->text_value, 2, 3);
$city = !empty($city_key) ? City::where("clave", $city_key)->where("estado_id", (int) $state_key)->first() : null;
$city_name = $city ? $city->nombre : "-";
$name = $city_name . ", " . $state_name;
break;
case "location-c":
$state_key = substr($inegi_key->text_value, 0, 2);
$state_name = !empty((int) $state_key) ? $this->states[$state_key] : "-";
$city_key = substr($inegi_key->text_value, 2, 3);
$city = !empty($city_key) ? City::where("clave", $city_key)->where("estado_id", (int) $state_key)->first() : null;
$city_name = $city ? $city->nombre : "-";
$location_key = substr($inegi_key->text_value, 5, 4);
$location = !empty((int) $location_key) ? Location::where("clave", $location_key)->where("municipio_id", $city->id)->first() : null;
$location_name = $location ? $location->nombre : "-";
$name = $location_name . ", " . $city_name . ", " . $state_name;
break;
default:
$name = "-";
break;
}
return $name;
};
if (!$blueprint) {
die("Este formulario no existe!");
}
$data = [];
$data['blueprint'] = $blueprint;
$data['title'] = 'Resultados | Tú Evalúas';
$data['description'] = 'Resultados de cuestionarios en Tú Evalúas';
$data['body_class'] = 'results';
$data['test'] = $test;
return view("frontend.result_survey")->with($data);
}
public static function getCity($id)
{
$cities = City::where('state_id', '=', $id)->get(['name', 'id']);
//echo ($cities);
return response()->json($cities);
}
private function find_location($question_type, $inegi_key)
{
if (!$inegi_key) {
return "-";
}
switch ($question_type) {
case "location-a":
$key = substr($inegi_key->text_value, 0, 2);
$name = !empty($key) ? $this->states[$key] : "-";
break;
case "location-b":
$state_key = substr($inegi_key->text_value, 0, 2);
$state_name = !empty($state_key) ? $this->states[$state_key] : "-";
$city_key = substr($inegi_key->text_value, 2, 3);
$city = !empty($city_key) ? City::where("clave", $city_key)->where("estado_id", (int) $state_key)->first() : null;
$city_name = $city ? $city->nombre : "-";
$name = $city_name . ", " . $state_name;
break;
case "location-c":
$state_key = substr($inegi_key->text_value, 0, 2);
$state_name = !empty($state_key) ? $this->states[$state_key] : "-";
$city_key = substr($inegi_key->text_value, 2, 3);
$city = !empty($city_key) ? City::where("clave", $city_key)->where("estado_id", (int) $state_key)->first() : null;
$city_name = $city ? $city->nombre : "-";
$location_key = substr($inegi_key->text_value, 5, 4);
$location = !empty($location_key) ? Location::where("clave", $location_key)->where("municipio_id", $city->id)->first() : null;
$location_name = $location ? $location->nombre : "-";
$name = $location_name . ", " . $city_name . ", " . $state_name;
break;
default:
$name = "-";
break;
}
return $name;
}
public function getTakeCity()
{
$state_id = \Request::input('province_id');
$emptyData = [];
if (empty($state_id)) {
return $emptyData;
}
$queryCity = Md\City::where('state_id', '=', $state_id);
$sites = $queryCity->lists('name', 'city_id');
return $sites;
}
public function getCity (Request $request)
{
$province = $request->input('province');
$cities = City::where('province_code', '=', $province)
->where('active', '=', 1)
->get();
$html = $this->cityList($cities);
return $this->successResponse('res', $html);
}
