public function prepareQueryAfterCount(xPDOQuery $c) { $c = parent::prepareQueryAfterCount($c); $contractor = $this->getProperty('contractor'); $c->leftJoin('OrderProduct', 'OrderProducts'); $c->select(array("count(*) as positions", "sum(OrderProducts.quantity) as total", "sum(OrderProducts.price*OrderProducts.quantity) as sum")); $c->where(array(array("createdby" => $contractor, "status_id" => 1), "OR:contractor:=" => $contractor)); $c->where(array("status_id:!=" => 1)); $c->groupby("`{$this->classKey}`.id"); return $c; }