public function getPlaces($id)
{
$street = Street::find($id);
if ($street) {
return $street->hasPlaces;
} else {
return $this->notFoundResponse();
}
}
public function __construct(Request $request)
{
$this->areas = Area::all('id', 'name');
$this->streets = Street::all('id', 'name');
$this->request = $request;
}
/**
* Function get place by street
*
* @param $id id of street
* @return array|\Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
*/
public function getPlacesByStreet($id)
{
$area = Street::find($id);
if ($area) {
$places = $area->hasPlaces;
$json_result = array();
foreach ($places as $place) {
$place = $this->show($place['id']);
array_push($json_result, $place);
}
return $json_result;
} else {
return $this->notFoundResponse();
}
}
/**
* Remove the specified resource from storage.
*
* @return \Illuminate\Http\Response
*/
public function postDestroy()
{
if ($this->request->ajax()) {
$id = $this->request['id'] ?: '';
$data = Street::find($id);
if ($data) {
$data->delete();
}
$response = array('url' => route('street.index'));
return $response;
}
}
public function actionAjaxSearch()
{
if (Yii::$app->request->getIsAjax()) {
$params = Yii::$app->request->getQueryParams();
$list = [];
switch ($params['t']) {
case "lastname":
$list = ArrayHelper::getColumn(Lastname::find()->where(['like', 'lastname', $params['term'] . "%", false])->limit(100)->asArray()->all(), 'lastname');
break;
case "firstname":
$list = ArrayHelper::getColumn(Firstname::find()->where(['like', 'firstname', $params['term'] . "%", false])->limit(100)->asArray()->all(), 'firstname');
break;
case "midname":
$list = ArrayHelper::getColumn(Midname::find()->where(['like', 'midname', $params['term'] . "%", false])->limit(100)->asArray()->all(), 'midname');
break;
case "city":
$list = ArrayHelper::getColumn(City::find()->where(['like', 'city', $params['term']])->limit(100)->asArray()->all(), 'city');
break;
case "street":
$list = ArrayHelper::getColumn(Street::find()->where(['like', 'street', $params['term']])->limit(100)->asArray()->all(), 'street');
break;
}
return $this->renderAjax('ajax-search', ['list' => $list]);
} else {
throw new NotFoundHttpException('');
}
}
