/**
* @return mixed
*/
public function store()
{
$input = \Request::all();
$validator = \Validator::make($input, ['owner_id' => 'required', 'property_name' => 'required|max:255']);
if ($validator->fails()) {
\App::abort(400, $validator->messages()->first());
}
$property = new Property($input);
$owner = Owner::find($input['owner_id']);
$property = $owner->Properties()->save($property);
return \Response::json(['success' => true, 'message' => 'Property Created.', 'data' => $property]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Owner::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->joinWith(['images', 'images.tags']);
$query->groupBy(['owner.id']);
$query->andFilterWhere(['owner.id' => $this->id, 'image.id' => $this->image_id, 'tag.id' => $this->tag_id]);
$query->andFilterWhere(['like', 'dns', $this->dns]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Owner::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->setSort(['attributes' => ['id', 'fullName' => ['asc' => ['first_name' => SORT_ASC, 'last_name' => SORT_ASC], 'desc' => ['first_name' => SORT_DESC, 'last_name' => SORT_DESC], 'default' => SORT_ASC], 'license', 'state_id', 'city', 'zip_code', 'email', 'vehicleName' => ['asc' => ['Vehicle.make' => SORT_ASC, 'Vehicle.model' => SORT_ASC], 'desc' => ['Vehicle.make' => SORT_DESC, 'Vehicle.model' => SORT_DESC], 'default' => SORT_ASC]]]);
if (!($this->load($params) && $this->validate())) {
$query->joinWith(['vehicle']);
return $dataProvider;
}
$query->andWhere('first_name LIKE "%' . $this->fullName . '%" ' . 'OR last_name LIKE "%' . $this->fullName . '%"');
$query->andFilterWhere(['id' => $this->id, 'state_id' => $this->state_id]);
$query->andFilterWhere(['like', 'license', $this->license])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'zip_code', $this->zip_code])->andFilterWhere(['like', 'email', $this->email]);
$query->joinWith(['vehicle' => function ($query) {
$query->where('Vehicle.make LIKE "%' . $this->vehicleName . '%"' . 'OR Vehicle.model LIKE "%' . $this->vehicleName . '%"');
}]);
return $dataProvider;
}
/**
* Register any other events for your application.
*
* @param \Illuminate\Contracts\Events\Dispatcher $events
* @return void
*/
public function boot(DispatcherContract $events)
{
parent::boot($events);
\App\Models\Owner::saving(function ($owner) {
if (empty($owner->owner_name)) {
$owner->owner_name = null;
}
$owner->org_id = \Auth::User()->org_id;
return $owner;
});
\App\Models\Property::saving(function ($property) {
if (empty($property->property_name)) {
$property->property_name = null;
}
$property->org_id = \Auth::User()->org_id;
return $property;
});
\App\Models\Unit::saving(function ($unit) {
if (empty($unit->unit_name)) {
$unit->unit_name = null;
}
$unit->org_id = \Auth::User()->org_id;
return $unit;
});
\App\Models\Tenant::saving(function ($tenant) {
if (empty($tenant->tenant_name)) {
$tenant->tenant_name = null;
}
$tenant->org_id = \Auth::User()->org_id;
return $tenant;
});
\App\Models\Transaction::saving(function ($transaction) {
$transaction->org_id = \Auth::User()->org_id;
return $transaction;
});
}
/**
* @return \yii\db\ActiveQuery
*/
public function getOwner()
{
return $this->hasOne(Owner::className(), ['id' => 'owner_id']);
}
/**
* Deletes an existing Owner model.
* If deletion is successful, the browser will be redirected to the 'manage' page.
* @param integer $id
* @return mixed
*/
public function actionDelete($id)
{
$this->findModel(Owner::className(), $id)->delete();
return $this->redirect(['manage']);
}
/**
*
* @param $id
* @return Response
*/
public function destroy($id)
{
$transaction = Owner::findOrFail($id);
$transaction->delete();
return \Response::json(['success' => true, 'message' => 'Owner Deleted.', 'data' => []]);
}
/**
* Finds the Owner model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Owner the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Owner::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
