Formatowanie wartości finansowych

Entity – usuwanie spacji, zamiana przecinków na kropki

protected function _setNetto($netto) {
   $netto = str_replace(',', '.', $netto);
   return trim($netto);
}

protected function _setBrutto($brutto) {
   $brutto = str_replace(',', '.', $brutto);
   return trim($brutto);
}

Kontroler  – pobieranie sumy pozycji

$query = $this->Invoices->find();

$query->enableAutoFields()
      ->select([
          'total_netto'  => $query->func()->sum('Positions.netto'),
          'total_brutto' => $query->func()->sum('Positions.brutto'),
          'total_pos'    => $query->func()->count('Positions.id')
       ]);

$query->leftJoinWith('Positions');

$query->group(['Invoices.id']);

$query->order(['Invoices.id' => 'DESC'])
      ->all();

View /

<?= number_format($brutto, 2, ".", " ") ?>