static function get_bank_trans_view() { global $systypes_array; $bfw = Mt::get_balance_before_for_bank_account($_POST['trans_date_mulai'], $_POST['bank_act']); $arr['data'][] = array('type' => 'Saldo Awal - ' . sql2date($_POST['trans_date_mulai']), 'ref' => '', 'tgl' => '', 'debit' => $bfw >= 0 ? number_format($bfw, 2) : '', 'kredit' => $bfw < 0 ? number_format($bfw, 2) : '', 'neraca' => '', 'person' => ''); $credit = $debit = 0; $running_total = $bfw; if ($bfw > 0) { $debit += $bfw; } else { $credit += $bfw; } $result = Mt::get_bank_trans_for_bank_account($_POST['bank_act'], $_POST['trans_date_mulai'], $_POST['trans_date_sampai']); foreach ($result as $myrow) { $running_total += $myrow->amount; $jemaat = get_jemaat_from_user_id($myrow->users_id); $arr['data'][] = array('type' => $systypes_array[$myrow->type], 'ref' => $myrow->ref, 'tgl' => sql2date($myrow->trans_date), 'debit' => $myrow->amount >= 0 ? number_format($myrow->amount, 2) : '', 'kredit' => $myrow->amount < 0 ? number_format(-$myrow->amount, 2) : '', 'neraca' => number_format($running_total, 2), 'person' => $jemaat->real_name); if ($myrow->amount > 0) { $debit += $myrow->amount; } else { $credit += $myrow->amount; } } $arr['data'][] = array('type' => 'Saldo Akhir - ' . sql2date($_POST['trans_date_sampai']), 'ref' => '', 'tgl' => '', 'debit' => $running_total >= 0 ? number_format($running_total, 2) : '', 'kredit' => $running_total < 0 ? number_format(-$running_total, 2) : '', 'neraca' => '', 'person' => ''); return $arr; }
public function actionGetBalance() { if (!Yii::app()->request->isAjaxRequest) { return; } if (isset($_POST) && !empty($_POST)) { //$id = $_POST['id']; $amt = Mt::get_balance_before_for_bank_account(get_date_tomorrow(), $_POST['id']); echo CJSON::encode(array('success' => true, 'id' => $amt)); Yii::app()->end(); } }