public static function pay($params, $currentUser, $con) { // check role's permission $permission = RolePermissionQuery::create()->select('pay_credit')->findOneById($currentUser->role_id, $con); if (!$permission || $permission != 1) { throw new \Exception('Akses ditolak. Anda tidak mempunyai izin untuk melakukan operasi ini.'); } // make sure the credit is not fully paid already $credit = CreditQuery::create()->filterByStatus('Active')->filterById($params->credit_id)->withColumn('CONVERT(Credit.Total, SIGNED) - CONVERT(Credit.Paid, SIGNED)', 'Balance')->findOne($con); if (!$credit) { throw new \Exception('Data tidak ditemukan.'); } // if credit is already fully paid then stop paying if ($credit->getBalance() <= 0) { throw new \Exception('Piutang ini sudah dilunasi.'); } // create new payment $creditPayment = new CreditPayment(); $creditPayment->setDate($params->date)->setCreditId($params->credit_id)->setPaid($params->paid)->setCashierId($params->cashier)->setStatus('Active')->save($con); $payment = CreditPaymentQuery::create()->filterByStatus('Active')->filterByCreditId($params->credit_id)->withColumn('SUM(Paid)', 'paid')->select(array('paid'))->groupBy('CreditId')->findOne($con); $credit->setPaid($payment)->save($con); $results['success'] = true; $results['data'] = 'Yay'; return $results; }