/**
* Finds the CsServicesTranslation model based on its translated title.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return CsServices the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModelByTitle($title)
{
if (($model = CsProducts::find()->where('name=:name', [':name' => str_replace('-', ' ', $title)])->one()) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Displays a single CsObjects model.
* @param string $id
* @return mixed
*/
public function actionView($id)
{
$model = $this->findModel($id);
$query = \common\models\CsObjectProperties::find()->where(['object_id' => $model->id]);
if ($model->getPath($model)) {
foreach ($model->getPath($model) as $key => $objectpp) {
if ($objectPropertiespp = $objectpp->objectProperties) {
foreach ($objectPropertiespp as $objectPropertypp) {
if ($objectPropertypp->property_class != 'private') {
$query->orWhere(['object_id' => $objectpp->id]);
}
}
}
}
}
return $this->render('view', ['model' => $model, 'products' => new ActiveDataProvider(['query' => \common\models\CsProducts::find()->where(['object_id' => $model->id])]), 'issues' => new ActiveDataProvider(['query' => \common\models\CsObjectIssues::find()->where(['object_id' => $model->id])]), 'properties' => new ActiveDataProvider(['query' => $query->orderBy('property_type')->groupBy('id')]), 'methods' => new ActiveDataProvider(['query' => \common\models\CsServices::find()->where(['object_id' => $model->id])])]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = CsProducts::find();
$query->joinWith(['object', 'objectProperty']);
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'object_id' => $this->object_id, 'object_property_id' => $this->object_property_id, 'product_id' => $this->product_id, 'base_product_id' => $this->base_product_id, 'predecessor_id' => $this->predecessor_id, 'successor_id' => $this->successor_id]);
$query->andFilterWhere(['like', 'cs_products.name', $this->name])->andFilterWhere(['like', 'cs_products.level', $this->level])->andFilterWhere(['like', 'cs_products.class', $this->class])->andFilterWhere(['like', 'cs_products.description', $this->description]);
return $dataProvider;
}
