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;
}
