public function actionAjaxchart()
{
// master value
$fmShortDatePhp = DateTimeUtils::getDateFormat(DateTimeUtils::FM_KEY_PHP, null);
$searchTradeDateFrom = isset($_POST['trade_date_from']) ? DateTimeUtils::parse($_POST['trade_date_from'], $fmShortDatePhp, DateTimeUtils::FM_DB_DATE) : false;
$searchTradeDateTo = isset($_POST['trade_date_to']) ? DateTimeUtils::parse($_POST['trade_date_to'], $fmShortDatePhp, DateTimeUtils::FM_DB_DATE) : false;
$searchMaxItemsChart = isset($_POST['max_items_chart']) ? $_POST['max_items_chart'] : 10;
$dataQuery = OefNav::find()->where(['delete_flag' => MasterValueUtils::MV_FIN_FLG_DELETE_FALSE]);
if (!empty($searchTradeDateFrom)) {
$dataQuery->andWhere(['>=', 'trade_date', $searchTradeDateFrom]);
}
if (!empty($searchTradeDateTo)) {
$dataQuery->andWhere(['<=', 'trade_date', $searchTradeDateTo]);
}
$dataQuery->orderBy('trade_date DESC')->limit($searchMaxItemsChart);
$arrData = $dataQuery->all();
$count = count($arrData);
$arrDataChart = [];
$arrDataChartAlias = [];
$arrLabelChart = [];
while ($count > 0) {
$count--;
$data = $arrData[$count];
$arrDataChart[] = $data->nav_value;
$arrDataChartAlias[] = NumberUtils::format($data->nav_value, 2);
$arrLabelChart[] = DateTimeUtils::formatDateFromDB($data->trade_date, $fmShortDatePhp);
}
$renderData['chartData'] = count($arrDataChart) > 0 ? json_encode(['nav' => $arrDataChart, 'label' => $arrLabelChart, 'alias' => $arrDataChartAlias], JSON_NUMERIC_CHECK) : false;
return $this->renderPartial('ajaxchart', $renderData);
}
public function actionIndex()
{
// init value
$dataQuery = FinTotalInterestUnit::find()->orderBy('id DESC');
// chart data
$chartModels = FinTotalInterestUnit::find()->orderBy('id DESC')->limit(30)->all();
$arrLabelChart = [];
$arrInterestUnitDataChart = [];
$arrInterestUnitAliasDataChart = [];
foreach ($chartModels as $chartModel) {
$arrLabelChart[] = '';
$arrInterestUnitDataChart[] = $chartModel->interest_unit;
$arrInterestUnitAliasDataChart[] = NumberUtils::format($chartModel->interest_unit, 2);
}
$arrInterestUnitDataChart = array_reverse($arrInterestUnitDataChart);
$arrInterestUnitAliasDataChart = array_reverse($arrInterestUnitAliasDataChart);
$chartData = json_encode(['label' => $arrLabelChart, 'interestUnit' => $arrInterestUnitDataChart, 'interestUnitAlias' => $arrInterestUnitAliasDataChart], JSON_NUMERIC_CHECK);
// render GUI
$renderData = ['dataQuery' => $dataQuery, 'chartData' => $chartData];
return $this->render('index', $renderData);
}
} else {
$compareCreditConfig = ['template' => '<span class="{color}">{number}</span>', 'incColor' => 'text-blue', 'decColor' => 'text-red', 'incIcon' => 'fa-thumbs-o-up', 'decIcon' => 'fa-thumbs-o-down'];
$compareAssetsHtml = NumberUtils::getIncDecNumber($girdRow['compareAssets'], $compareCreditConfig);
}
$rowindex++;
?>
<tr class="<?php
echo $class;
?>
">
<td style="text-align: center"><?php
echo $monthStr;
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($girdRow['assets']);
?>
</td>
<td style="text-align: right"><?php
echo $compareAssetsHtml;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table></div></div>
</div>
</div><?php
}
<td style="vertical-align: middle; text-align: right"><?php
echo $item->share_unit;
?>
%</td>
<td style="vertical-align: middle; text-align: right"><?php
echo NumberUtils::format($item->share_value);
?>
</td>
</tr>
<?php
}
?>
<tr class="warning">
<th style="text-align: center" colspan="2"><?php
echo Yii::t('fin.grid', 'Total');
?>
</th>
<th style="text-align: right"><?php
echo $sumUnit;
?>
%</th>
<th style="text-align: right"><?php
echo NumberUtils::format($sumShared);
?>
</th>
</tr>
</tbody>
</table>
</div></div></div></div></div>
</div></div></div><?php
}
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('real_purchase');
?>
<span class="pull-right badge bg-blue"><?php
echo NumberUtils::format($model->real_purchase);
?>
</span>
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('nav');
?>
<span class="pull-right badge bg-red"><?php
echo NumberUtils::format($model->nav, 2);
?>
</span>
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('found_stock');
?>
<span class="pull-right badge bg-green"><?php
echo NumberUtils::format($model->found_stock, 2);
?>
</span>
</a></li>
</ul>
</div>
</div></div></div>
return ['style' => 'vertical-align: middle; text-align: left', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) use($arrFinAccount) {
return isset($arrFinAccount[$model->account_source]) ? $arrFinAccount[$model->account_source] : '';
}, 'footer' => $htmlFooterDebit], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'Debit Amount'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['colspan' => 0], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
$amount = $model->account_source == 0 ? '' : NumberUtils::format($model->entry_value);
return $amount;
}], ['label' => Yii::t('fin.grid', 'Credit Account'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right', 'colspan' => 2], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: left', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) use($arrFinAccount) {
return isset($arrFinAccount[$model->account_target]) ? $arrFinAccount[$model->account_target] : '';
}, 'footer' => $htmlFooterCredit], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'Credit Amount'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['colspan' => 0], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
$amount = $model->account_target == 0 ? '' : NumberUtils::format($model->entry_value);
return $amount;
}], ['attribute' => 'description', 'label' => Yii::t('fin.grid', 'Description'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: left', 'class' => MasterValueUtils::getColorRow($index)];
}, 'enableSorting' => false, 'value' => function ($model) use($arrEntryLog) {
$arrEntryLogVal = StringUtils::unserializeArr($model->description);
return StringUtils::showArrValueAsString($arrEntryLogVal, $arrEntryLog);
}], ['label' => Yii::t('fin.grid', 'Action'), 'headerOptions' => ['style' => 'text-align: center; width: 100px;'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model, $key, $index) {
$btnClass = MasterValueUtils::getColorRow($index);
$lblView = Yii::t('button', 'View');
$lblEdit = Yii::t('button', 'Edit');
$lblCopy = Yii::t('button', 'Copy');
$urlEdit = false;
$arrBtns = [];
return $html;
}], ['label' => Yii::t('fin.grid', 'Status'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: center'], 'format' => 'raw', 'value' => function ($model) use($arrCustomerStatus) {
$status = isset($arrCustomerStatus[$model->status]) ? $arrCustomerStatus[$model->status] : '';
$html = '<span>' . $status . '</span>';
$lblView = Yii::t('button', 'View');
$lblEdit = Yii::t('button', 'Edit');
$arrBtns = [];
$entryId = $model->id;
$urlEdit = BaseUrl::toRoute(['customer/update', 'id' => $entryId]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlEdit, $lblEdit]);
$urlView = BaseUrl::toRoute(['customer/view', 'id' => $entryId]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlView, $lblView]);
$html .= '<br/><div class="btn-group">';
$html .= Html::a($lblEdit, [$urlEdit], ['class' => 'btn btn-xs btn-info']);
$html .= '<button type="button" class="btn btn-xs btn-info dropdown-toggle" data-toggle="dropdown">';
$html .= '<span class="caret"></span><span class="sr-only">Toggle Dropdown</span>';
$html .= '</button>';
$html .= '<ul class="dropdown-menu" role="menu">';
$html .= implode('', $arrBtns);
$html .= '</ul></div>';
return $html;
}], ['label' => Yii::t('fin.grid', 'Balance'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'vertical-align: middle; text-align: right'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: right'], 'format' => 'raw', 'value' => function ($model) {
$labelClass = $model->balance < 0 ? 'label-danger' : 'label-info';
$labelValue = NumberUtils::format(abs($model->balance));
return StringUtils::format('{2}<br/><span class="label {0} pull-right">{1}</span>', [$labelClass, $labelValue, $model->name]);
}, 'footer' => NumberUtils::getIncDecNumber($sumCustomerValue['balance'], ['template' => '<span class="label pull-right {color}">{number}</span>', 'incColor' => 'label-info', 'decColor' => 'label-danger'])]]]);
Pjax::end();
?>
</div>
</div>
</div></div></div>
<th class="warning"><?php
echo $model->getAttributeLabel('interest_add');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->interest_add);
?>
</td>
</tr>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('entry_value');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->entry_value);
?>
</td>
</tr>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('add_flag');
?>
</th>
<td class="info"><?php
echo isset($arrTimedepositTrantype[$model->add_flag]) ? $arrTimedepositTrantype[$model->add_flag] : '';
?>
</td>
</tr>
<tr>
<th class="warning"><?php
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model) {
$interestRate = NumberUtils::format($model->interest_rate, 4) . ' %';
$interestUnit = NumberUtils::format($model->interest_unit, 4) . ' d';
return $interestRate . '<br/>' . $interestUnit;
}], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'Term'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['colspan' => 0], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model) use($phpFmShortDate) {
$openingDate = DateTimeUtils::htmlDateFormatFromDB($model->opening_date, DateTimeUtils::FM_VIEW_DATE, true);
$closingDate = DateTimeUtils::htmlDateFormatFromDB($model->closing_date, DateTimeUtils::FM_VIEW_DATE, true);
return $openingDate . '<br/>' . $closingDate;
}], ['label' => Yii::t('fin.grid', 'Principal'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model) {
$interestAdd = NumberUtils::format($model->interest_add);
$entryValue = NumberUtils::format($model->entry_value);
return $entryValue . '<br/>' . $interestAdd;
}, 'footer' => $htmlFooterInterest], ['label' => Yii::t('fin.grid', 'Amount Type'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) use($arrTimedepositTrantype) {
return isset($arrTimedepositTrantype[$model->add_flag]) ? $arrTimedepositTrantype[$model->add_flag] : '';
}], ['label' => Yii::t('fin.grid', 'Current Assets'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: left', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) use($arrCurrentAssets) {
return isset($arrCurrentAssets[$model->current_assets]) ? $arrCurrentAssets[$model->current_assets] : '';
}, 'footer' => $htmlFooterAdding], ['label' => Yii::t('fin.grid', 'Action'), 'headerOptions' => ['style' => 'text-align: center; width: 100px;'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model, $key, $index) {
$btnClass = MasterValueUtils::getColorRow($index);
$lblView = Yii::t('button', 'View');
$lblEdit = Yii::t('button', 'Edit');
$startDateStr = '';
$diffDays = '';
$diffFull = '';
if (!is_null($model->start_date)) {
$startDate = DateTimeUtils::parse($model->start_date, DateTimeUtils::FM_DB_DATETIME);
$startDateStr = DateTimeUtils::htmlDateTimeFormatFromDB($model->start_date, DateTimeUtils::FM_VIEW_DATE, true);
$interval = $currentDate->diff($startDate);
$diffDays = $interval->days;
$diffFull = $interval->format('%Y-%M-%D %H:%I:%S');
}
$costAll = '';
$costDay = '';
if (!is_null($model->costs)) {
$costAll = NumberUtils::format($model->costs);
if ($diffDays > 0) {
$costDay = NumberUtils::format($model->costs / $diffDays, 2);
}
}
?>
<tr class="<?php
echo $rowClass;
?>
">
<td style="vertical-align: middle; text-align: center; width: 80px"><?php
echo $rowindex;
?>
</td>
<td style="vertical-align: middle; text-align: left"><?php
echo $model->name;
?>
</td>
?>
</td>
<td style="text-align: right"><?php
echo $compareCreditHtml;
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($girdRow['credit']);
?>
</td>
<td style="text-align: right"><?php
echo $compareDebitHtml;
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($girdRow['debit']);
?>
</td>
<td style="text-align: right"><?php
echo $balanceHtml;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table></div></div></div>
<?php
}
?>
?>
<?php
$class = MasterValueUtils::getColorRow($rowindex);
$monthStr = $girdRow['month']->format($fmKeyPhp);
$arrNotermHtml = [];
$arrTermHtml = [];
$arrTotalHtml = [];
if ($rowindex > 0) {
$compareConfig = ['template' => '<span class="{color}">{number}</span>', 'incColor' => 'text-blue', 'decColor' => 'text-red'];
$arrNotermHtml[] = NumberUtils::getIncDecNumber($girdRow['compareNoterm'], $compareConfig);
$arrTermHtml[] = NumberUtils::getIncDecNumber($girdRow['compareTerm'], $compareConfig);
$arrTotalHtml[] = NumberUtils::getIncDecNumber($girdRow['compareTotal'], $compareConfig);
}
$arrNotermHtml[] = NumberUtils::format($girdRow['noterm']);
$arrTermHtml[] = NumberUtils::format($girdRow['term']);
$arrTotalHtml[] = NumberUtils::format($girdRow['total']);
$notermHtml = implode('<br/>', $arrNotermHtml);
$termHtml = implode('<br/>', $arrTermHtml);
$totalHtml = implode('<br/>', $arrTotalHtml);
$rowindex++;
?>
<tr class="<?php
echo $class;
?>
">
<td style="vertical-align: middle; text-align: center"><?php
echo $monthStr;
?>
</td>
<td style="vertical-align: middle; text-align: right"><?php
echo $termHtml;
}, 'footer' => $htmlFooterRealPurchase], ['label' => Yii::t('fin.grid', 'Stock'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format($model->found_stock, 2);
}, 'footer' => $htmlFooterFoundStock], ['label' => Yii::t('fin.grid', 'Sold'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format($model->found_stock_sold, 2);
}, 'footer' => $htmlFooterFoundStockSold], ['label' => Yii::t('fin.grid', 'Other Fee'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format($model->transfer_fee + $model->other_fee);
}, 'footer' => $htmlFooterOtherFee], ['label' => Yii::t('fin.grid', 'Investment'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format($model->purchase + $model->transfer_fee + $model->other_fee);
}, 'footer' => $htmlFooterInvestment], ['label' => Yii::t('fin.grid', 'Action'), 'headerOptions' => ['style' => 'text-align: center; width: 100px;'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model, $key, $index) {
$btnClass = MasterValueUtils::getColorRow($index);
$lblView = Yii::t('button', 'View');
$lblEdit = Yii::t('button', 'Edit');
$urlEdit = null;
$arrBtns = [];
$entryId = $model->id;
$urlEdit = BaseUrl::toRoute(['purchase/update', 'id' => $model->id]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlEdit, $lblEdit]);
$urlView = BaseUrl::toRoute(['purchase/view', 'id' => $entryId]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlView, $lblView]);
$html = '<div class="btn-group">';
$html .= Html::a($lblEdit, [$urlEdit], ['class' => 'btn btn-' . $btnClass]);
$html .= '<button type="button" class="btn btn-xs btn-info dropdown-toggle" data-toggle="dropdown">';
$html .= '<span class="caret"></span><span class="sr-only">Toggle Dropdown</span>';
$html .= '</button>';
$html .= '<ul class="dropdown-menu" role="menu">';
$html .= implode('', $arrBtns);
$html .= '</ul></div>';
return $html;
}, 'footer' => $htmlFooterDate], ['label' => Yii::t('fin.grid', 'Credit / Debit'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: left; min-width:162px'], 'format' => 'raw', 'value' => function ($model) use($arrFinAccount) {
$htmls = [];
$htmlCredit = isset($arrFinAccount[$model->account_target]) ? $arrFinAccount[$model->account_target] : '';
if (!empty($htmlCredit)) {
$amount = $model->account_target == 0 ? '' : NumberUtils::format($model->entry_value);
$htmlCredit .= '<span class="label label-info pull-right">' . $amount . '</span>';
$htmls[] = $htmlCredit;
}
$htmlDebit = isset($arrFinAccount[$model->account_source]) ? $arrFinAccount[$model->account_source] : '';
if (!empty($htmlDebit)) {
$amount = $model->account_source == 0 ? '' : NumberUtils::format($model->entry_value);
$htmlDebit .= '<span class="label label-danger pull-right">' . $amount . '</span>';
$htmls[] = $htmlDebit;
}
return implode('<br/>', $htmls);
}, 'footer' => $htmlFooterCreditDebit], ['attribute' => 'description', 'label' => Yii::t('fin.grid', 'Description'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: left'], 'enableSorting' => false, 'value' => function ($model) use($arrEntryLog) {
$arrEntryLogVal = StringUtils::unserializeArr($model->description);
return StringUtils::showArrValueAsString($arrEntryLogVal, $arrEntryLog);
}]]]);
Pjax::end();
?>
</div>
</div>
</div></div></div>
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model, $key, $index, $column) {
$pagination = $column->grid->dataProvider->pagination;
return $pagination->page * $pagination->pageSize + $index + 1;
}, 'footer' => Yii::t('fin.grid', 'Total')], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'ID'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['colspan' => 0], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return str_pad($model->share_id, 6, '0', STR_PAD_LEFT);
}], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'Share Date'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['colspan' => 0], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model) {
return DateTimeUtils::htmlDateFormatFromDB($model->share_date, DateTimeUtils::FM_VIEW_DATE, true);
}], ['label' => Yii::t('fin.grid', 'Share Value'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format($model->share_value);
}, 'footer' => $htmlFooterShareValue], ['label' => Yii::t('fin.grid', 'Description'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: left; max-width:280px', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return $model->description;
}], ['label' => Yii::t('fin.grid', 'Action'), 'headerOptions' => ['style' => 'text-align: center; width: 100px;'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model, $key, $index) {
$btnClass = MasterValueUtils::getColorRow($index);
$lblView = Yii::t('button', 'View');
$lblEdit = Yii::t('button', 'Edit');
$arrBtns = [];
$entryId = $model->share_id;
$urlEdit = BaseUrl::toRoute(['distribute/update', 'id' => $entryId]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlEdit, $lblEdit]);
$urlView = BaseUrl::toRoute(['distribute/view', 'id' => $entryId]);
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->transfer_fee);
?>
</td>
</tr>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('other_fee');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->other_fee);
?>
</td>
</tr>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('investment');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->investment);
?>
</td>
</tr>
</table>
</div></div></div>
</div><?php
}
?>
<?php
$class = MasterValueUtils::getColorRow($rowindex);
$monthStr = $girdRow['month']->format($fmKeyPhp);
$arrCreditHtml = [];
$arrDebitHtml = [];
$arrBalanceHtml = [];
if ($rowindex > 0) {
$compareCreditConfig = ['template' => '<span class="{color}">{number}</span>', 'incColor' => 'text-blue', 'decColor' => 'text-red'];
$arrCreditHtml[] = NumberUtils::getIncDecNumber($girdRow['compareCredit'], $compareCreditConfig);
$arrBalanceHtml[] = NumberUtils::getIncDecNumber($girdRow['compareBalance'], $compareCreditConfig);
$compareDebitConfig = ['template' => '<span class="{color}">{number}</span>', 'incColor' => 'text-red', 'decColor' => 'text-blue'];
$arrDebitHtml[] = NumberUtils::getIncDecNumber($girdRow['compareDebit'], $compareDebitConfig);
}
$arrCreditHtml[] = NumberUtils::format($girdRow['credit']);
$arrDebitHtml[] = NumberUtils::format($girdRow['debit']);
$arrBalanceHtml[] = NumberUtils::getIncDecNumber($girdRow['balance'], ['template' => '<span class="{color}">{number}</span>', 'incColor' => 'text-blue', 'decColor' => 'text-red']);
$creditHtml = implode('<br/>', $arrCreditHtml);
$debitHtml = implode('<br/>', $arrDebitHtml);
$balanceHtml = implode('<br/>', $arrBalanceHtml);
$rowindex++;
?>
<tr class="<?php
echo $class;
?>
">
<td style="vertical-align: middle; text-align: center"><?php
echo $monthStr;
?>
</td>
<td style="vertical-align: middle; text-align: right"><?php
}], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'Bill Date'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['colspan' => 0], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model) {
return DateTimeUtils::htmlDateFormatFromDB($model->bill_date, DateTimeUtils::FM_VIEW_DATE, true);
}], ['label' => Yii::t('fin.grid', 'Amount'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format($model->total);
}, 'footer' => $htmlFooterTotal], ['label' => Yii::t('fin.grid', 'Member'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return $model->member_num;
}], ['label' => Yii::t('fin.grid', 'Per Member'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: right', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) {
return NumberUtils::format(NumberUtils::rounds($model->total / $model->member_num, NumberUtils::NUM_CEIL));
}], ['label' => Yii::t('fin.grid', 'Member'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: left; max-width:280px', 'class' => MasterValueUtils::getColorRow($index)];
}, 'value' => function ($model) use($arrNetCustomer) {
$arrMemberListVal = StringUtils::unserializeArr($model->member_list);
return StringUtils::showArrValueAsString($arrMemberListVal, $arrNetCustomer);
}], ['label' => Yii::t('fin.grid', 'Action'), 'headerOptions' => ['style' => 'text-align: center; width: 100px;'], 'contentOptions' => function ($model, $key, $index) {
return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)];
}, 'format' => 'raw', 'value' => function ($model, $key, $index) {
$btnClass = MasterValueUtils::getColorRow($index);
$lblView = Yii::t('button', 'View');
$lblEdit = Yii::t('button', 'Edit');
$arrBtns = [];
$entryId = $model->id;
$urlEdit = BaseUrl::toRoute(['bill/update', 'id' => $entryId]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlEdit, $lblEdit]);
<th class="warning"><?php
echo $model->getAttributeLabel('entry_adjust');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->entry_adjust);
?>
</td>
</tr>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('entry_updated');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->entry_updated);
?>
</td>
</tr>
<?php
}
?>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('description');
?>
</th>
<td class="info"><?php
echo StringUtils::showArrValueAsString($model->arr_entry_log, $arrEntryLog);
?>
</td>
if ($model->credit > 0) {
?>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('credit');
?>
<span class="pull-right badge bg-aqua"><?php
echo NumberUtils::format($model->credit);
?>
</span>
</a></li><?php
}
?>
<?php
if ($model->debit > 0) {
?>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('debit');
?>
<span class="pull-right badge bg-red"><?php
echo NumberUtils::format($model->debit);
?>
</span>
</a></li><?php
}
?>
</ul>
</div>
</div></div></div><?php
}
<th class="warning"><?php
echo $model->getAttributeLabel('entry_date');
?>
</th>
<td class="info"><?php
echo DateTimeUtils::htmlDateFormat($model->entry_date, DateTimeUtils::FM_VIEW_DATE_WD, $fmShortDatePhp, true);
?>
</td>
</tr>
<tr>
<th class="warning"><?php
echo $model->getAttributeLabel('credit');
?>
</th>
<td class="info"><?php
echo NumberUtils::format($model->credit);
?>
</td>
</tr>
</table>
<div style="display: none">
<?php
echo $form->field($model, 'customer_id')->hiddenInput();
?>
<?php
echo $form->field($model, 'entry_date')->hiddenInput();
?>
<?php
echo $form->field($model, 'credit')->hiddenInput();
?>
</div>
return $html;
}, 'footer' => $htmlFooterInterest], ['label' => Yii::t('fin.grid', 'Principal'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: left; min-width:162px'], 'format' => 'raw', 'value' => function ($model) use($arrSavingAccount, $arrCurrentAssets) {
$htmls = [];
$htmlSavingAccount = isset($arrSavingAccount[$model->saving_account]) ? $arrSavingAccount[$model->saving_account] : '';
if (!empty($htmlSavingAccount)) {
$amount = NumberUtils::format($model->interest_add);
$htmlSavingAccount .= '<span class="label label-info pull-right">' . $amount . '</span>';
$htmls[] = $htmlSavingAccount;
}
$htmlCurrentAssets = isset($arrCurrentAssets[$model->current_assets]) ? $arrCurrentAssets[$model->current_assets] : '';
if (!empty($htmlCurrentAssets)) {
$amount = NumberUtils::format($model->entry_value);
if ($model->add_flag == MasterValueUtils::MV_FIN_TIMEDP_TRANTYPE_ADDING) {
$htmlCurrentAssets .= '<span class="label label-info pull-right">' . $amount . '</span>';
} else {
$htmlCurrentAssets .= '<span class="label label-danger pull-right">' . $amount . '</span>';
}
$htmls[] = $htmlCurrentAssets;
}
return implode('<br/>', $htmls);
}, 'footer' => $htmlFooterAdding], ['label' => Yii::t('fin.grid', 'Unit'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: right'], 'format' => 'raw', 'value' => function ($model) {
$interestRate = NumberUtils::format($model->interest_rate, 4) . ' %';
$interestUnit = NumberUtils::format($model->interest_unit, 4) . ' d';
return $interestRate . '<br/>' . $interestUnit;
}], ['label' => Yii::t('fin.grid', 'Closing'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: center'], 'format' => 'raw', 'value' => function ($model) {
return DateTimeUtils::htmlDateFormatFromDB($model->closing_date, DateTimeUtils::FM_VIEW_DATE, true);
}]]]);
Pjax::end();
?>
</div></div>
</div></div></div>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($otherFound->opening_balance);
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($otherFound->closing_balance);
?>
</td>
</tr><?php
}
?>
<tr class="danger">
<td style="text-align: left"><?php
echo Yii::t('fin.grid', 'Total');
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($sumTotal['opening_balance']);
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($sumTotal['closing_balance']);
?>
</td>
</tr>
</table></div></div>
</div></div>
</div>
?>
</td>
<td style="text-align: right"><?php
echo $account->share_unit;
?>
%</td>
<td style="text-align: right"><?php
echo NumberUtils::getIncDecNumber($account->useable_balance, $numberHtmlConfig);
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::getIncDecNumber($account->real_balance, $numberHtmlConfig);
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($account->real_balance - $account->useable_balance);
?>
</td>
<td style="text-align: left"><?php
echo $account->description;
?>
</td>
</tr>
<?php
}
?>
<tr class="warning">
<th colspan="2" style="text-align: center"><?php
echo Yii::t('fin.grid', 'Total');
?>
</th>
?>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('entry_adjust');
?>
<span class="pull-right badge bg-red"><?php
echo NumberUtils::format($model->entry_adjust);
?>
</span>
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('entry_update');
?>
<span class="pull-right badge bg-red"><?php
echo NumberUtils::format($model->entry_value + $model->entry_adjust);
?>
</span>
</a></li>
<?php
}
?>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('description');
?>
<span class="pull-right"><?php
echo $model->description;
?>
</span>
</a></li>
$arrBtns[] = StringUtils::format("<li><a href='javascript:void(0)' onclick='editBillItem(this);' data-maps='{0}'>{1}</a></li>", [$datasetDeleteStr, $lblDetele]);
$htmlAction = '<div class="btn-group">';
$htmlAction .= StringUtils::format("<a href='javascript:void(0)' onclick='editBillItem(this);' data-maps='{0}' class='btn btn-{1}'>{2}</a>", [$datasetUpdateStr, $btnClass, $lblEdit]);
$htmlAction .= '<button type="button" class="btn btn-' . $btnClass . ' dropdown-toggle" data-toggle="dropdown">';
$htmlAction .= '<span class="caret"></span><span class="sr-only">Toggle Dropdown</span>';
$htmlAction .= '</button>';
$htmlAction .= '<ul class="dropdown-menu" role="menu">';
$htmlAction .= implode('', $arrBtns);
$htmlAction .= '</ul></div>';
// show error columns
$colItemNameStyle = '';
$colPriceStyle = '';
$colPayDateStyle = '';
$colDescriptionStyle = '';
$htmlItemName = $item->item_name;
$htmlPrice = is_numeric($item->price) ? NumberUtils::format($item->price) : $item->price;
$htmlPayDate = empty($item->pay_date) ? '' : DateTimeUtils::htmlDateFormat($item->pay_date, DateTimeUtils::FM_VIEW_DATE_WD, $fmShortDatePhp, true);
$htmlDescription = $item->description;
if (!$item->is_valid) {
$errorItemName = $item->getErrors('item_name');
if (count($errorItemName) > 0) {
$colItemNameStyle = ' class="danger"';
$htmlItemName = '<i class="fa fa-question-circle" data-toggle="tooltip" data-placement="top" title="' . $errorItemName[0] . '"></i> ' . $htmlItemName;
}
$errorPrice = $item->getErrors('price');
if (count($errorPrice) > 0) {
$colPriceStyle = ' class="danger"';
$htmlPrice = '<i class="fa fa-question-circle" data-toggle="tooltip" data-placement="top" title="' . $errorPrice[0] . '"></i> ' . $htmlPrice;
}
$errorPayDate = $item->getErrors('pay_date');
if (count($errorPayDate) > 0) {
$urlView = BaseUrl::toRoute(['nav/view', 'id' => $entryId]);
$arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlView, $lblView]);
$html .= '<br/><div class="btn-group">';
$html .= Html::a($lblEdit, [$urlEdit], ['class' => 'btn btn-xs btn-info']);
$html .= '<button type="button" class="btn btn-xs btn-info dropdown-toggle" data-toggle="dropdown">';
$html .= '<span class="caret"></span><span class="sr-only">Toggle Dropdown</span>';
$html .= '</button>';
$html .= '<ul class="dropdown-menu" role="menu">';
$html .= implode('', $arrBtns);
$html .= '</ul></div>';
return $html;
}], ['label' => Yii::t('fin.grid', 'Nav / Prev'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: left;'], 'format' => 'raw', 'value' => function ($model) {
$htmls = [];
$navPrev = NumberUtils::format($model->nav_value_prev, 2);
$htmls[] = '<span class="label label-info pull-right">' . $navPrev . '</span>';
$nav = NumberUtils::format($model->nav_value, 2);
$htmls[] = '<span class="label label-info pull-right">' . $nav . '</span>';
return implode('<br/>', $htmls);
}], ['label' => Yii::t('fin.grid', 'Delta'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: left'], 'format' => 'raw', 'value' => function ($model) {
$config1 = ['template' => '<span class="label {color} pull-right">{number}</span>', 'incColor' => 'label-info', 'decColor' => 'label-danger'];
$config2 = ['template' => '<span class="label {color} pull-right">{number} %</span>', 'incColor' => 'label-info', 'decColor' => 'label-danger'];
$delta1 = $model->nav_value - $model->nav_value_prev;
$delta2 = 100 * $delta1 / $model->nav_value_prev;
$htmls = [];
$htmls[] = NumberUtils::getIncDecNumber($delta1, $config1, 2);
$htmls[] = NumberUtils::getIncDecNumber($delta2, $config2, 2);
return implode('<br/>', $htmls);
}]]]);
Pjax::end();
?>
</div>
$rowindex++;
?>
<tr class="<?php
echo $class;
?>
">
<td style="vertical-align: middle; text-align: center"><?php
echo $item->item_no;
?>
</td>
<td style="vertical-align: middle; text-align: left"><?php
echo $item->item_name;
?>
</td>
<td style="vertical-align: middle; text-align: right"><?php
echo NumberUtils::format($item->price);
?>
</td>
<td style="vertical-align: middle; text-align: left"><?php
echo DateTimeUtils::htmlDateFormat($item->pay_date, DateTimeUtils::FM_VIEW_DATE, DateTimeUtils::FM_DB_DATE, true);
?>
</td>
<td style="vertical-align: middle; text-align: left"><?php
echo $item->description;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('decide_date');
?>
<?php
echo DateTimeUtils::htmlDateFormatFromDB($model->decide_date, DateTimeUtils::FM_VIEW_DATE_WD, ['class' => 'pull-right']);
?>
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('nav_value');
?>
<span class="pull-right badge bg-red"><?php
echo NumberUtils::format($model->nav_value, 2);
?>
</span>
</a></li>
<li><a href="javascript:void(0);">
<?php
echo $model->getAttributeLabel('nav_value_prev');
?>
<span class="pull-right badge bg-red"><?php
echo NumberUtils::format($model->nav_value_prev, 2);
?>
</span>
</a></li>
</ul>
</div>
</div></div></div><?php
}
?>
</td>
<td style="text-align: right"><?php
echo $compareNotermHtml;
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($girdRow['noterm']);
?>
</td>
<td style="text-align: right"><?php
echo $compareTotalHtml;
?>
</td>
<td style="text-align: right"><?php
echo NumberUtils::format($girdRow['total']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table></div></div></div>
<?php
}
?>
</div>
<?php
ActiveForm::end();
?>
