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