Query Builder

Good everning. I have a method on Yii1 version and i need it to rewrite on Yii2.

It takes an array of parameters like this:


[["name" => "attr_daete_end", "jointype" => "left join", "id_attr" => 84, "id_tree" => 10, "select" => "text", "condition" => "[text]>NOW()"]]

and builds a query.

Method:




foreach ($attributes as $item) {

             

                        $criteria = new CDbCriteria;


                        $criteria->select = (!is_array($this->getDbCriteria()->select) ? $this->getDbCriteria()->select : '') . ", " . $item['name'] . "." .          $item['select'] . " as " . $item['name'];

                        $criteria->join = " " . $item['jointype'] . " cms_attributes_values " . $item['name'] . " on " . $item['name'] . ".id_obj=t.id AND " . $item['name'] . ".id_attr=" . $item['id_attr'] . " AND " . $item['name'] . ".id_tree=" . $item['id_tree'] . ($item['condition'] ? ' AND ' . str_replace("[id_variant]", $item['name'] . ".id_variant", str_replace("[id_val]", $item['name'] . ".id_val", str_replace("[text]", $item['name'] . ".text", $item['condition']))) : '');


                        $this->getDbCriteria()->mergeWith($criteria);

                }


                return $this;



yet I write like




$query = new Query();

                        $query->select = (!is_array($query->select) ? $query->select : '') . ", " . $item['name'] . "." . $item['select'] . " as " . $item['name'];

                        $query->join = " " . $item['jointype'] . " cms_attributes_values " . $item['name'] . " on " . $item['name'] . ".id_obj=t.id AND " . $item['name'] . ".id_attr=" . $item['id_attr'] . " AND " . $item['name'] . ".id_tree=" . $item['id_tree'] . ($item['condition'] ? ' AND ' . str_replace("[id_variant]", $item['name'] . ".id_variant", str_replace("[id_val]", $item['name'] . ".id_val", str_replace("[text]", $item['name'] . ".text", $item['condition']))) : '');

                        $query->createCommand();



but it doens`t work… Please, help