/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ArrayDataProvider
*/
public function search($params = [])
{
$query = IngredientEntity::find()->select(['(\'' . IngredientEntity::TYPE_WEIGHT . '\') AS type', 'p.id', 'p.name', 'dp.weight', '`dp`.`weight` * `p`.`calories` AS `calories`', '`dp`.`weight` * `p`.`protein` AS `protein`', '`dp`.`weight` * `p`.`fat` AS `fat`', '`dp`.`weight` * `p`.`carbohydrate` AS `carbohydrate`'])->from(['dp' => Diary::diary2productsTableName()])->leftJoin(['p' => Product::tableName()], 'p.id = dp.product_id')->where(['dp.diary_id' => $this->id])->orderBy('calories DESC');
$dataProvider = new ArrayDataProvider(['allModels' => $query->all(), 'sort' => ['attributes' => ['name', 'weight', 'calories', 'protein', 'fat', 'carbohydrate'], 'defaultOrder' => ['name' => SORT_ASC]], 'pagination' => false]);
return $dataProvider;
}
/**
* @param integer $id
* @return Query
*/
public static function getProductsWeightQuery($id)
{
return (new Query())->select('SUM(`dprod`.`weight`) AS `weight`')->from(Diary::diary2productsTableName() . ' `dprod`')->where("`dprod`.`diary_id` = {$id}");
}
/**
* @return \yii\db\ActiveQuery
*/
public function getDiaries()
{
return $this->hasMany(Diary::className(), ['id' => 'diary_id'])->viaTable(Diary::diary2productsTableName(), ['product_id' => 'id']);
}
