protected function gridPaymentColumn($data, $row) { $criteria = new CDbCriteria(); $criteria->select = 'SUM(amount_paid) as amount_paid'; $criteria->condition = 'invoice_id= :invoiceId'; $criteria->params = array(':invoiceId' => $data->id); $invoice_payment = InvoicePayment::model()->find($criteria); print_r(Yii::app()->numberFormatter->formatDecimal($invoice_payment->amount_paid)); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = InvoicePayment::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }