public function sum($type, $date_from, $date_to) { //$date_from = "01-01-$yaer 00:00:00"; //$date_to = "31-12-$yaer 23:59:59"; $query = new \yii\db\Query(); $query->select("sum(`leadsum`) AS lead,{{%transactions}}.type,{{%transactions}}.valuedate")->from('{{%transactions}}'); $query->join = [['LEFT JOIN', '{{%accounts}}', '{{%accounts}}.id=account_id']]; $query->groupBy = "{{%accounts}}.type"; $query->where("{{%accounts}}.type = :type"); $query->andWhere("valuedate>=:date_from"); $query->andWhere("valuedate<=:date_to"); $query->params([':date_from' => $date_from, ':date_to' => $date_to, ':type' => $type]); $command = $query->createCommand(); return $command->queryScalar(); }