</div> </div></div> <?php ActiveForm::end(); ?> </div> <div class="box-body-notool"> <div class="row"><?php Pjax::begin(); echo GridView::widget(['layout' => '{summary}<div class="table-responsive">{items}</div>{pager}', 'options' => ['class' => 'grid-view col-xs-12'], 'tableOptions' => ['class' => 'table table-bordered'], 'pager' => ['options' => ['class' => 'pagination pagination-bottom'], 'maxButtonCount' => 6], 'dataProvider' => new ActiveDataProvider(['query' => $dataQuery, 'pagination' => ['pagesize' => 20]]), 'columns' => [['label' => Yii::t('fin.grid', 'Ref'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: center'], 'format' => 'raw', 'value' => function ($model, $key, $index, $column) { $pagination = $column->grid->dataProvider->pagination; $html = $pagination->page * $pagination->pageSize + $index + 1; $html .= '<br/>' . str_pad($model->nav_id, 6, '0', STR_PAD_LEFT); return $html; }], ['label' => Yii::t('fin.grid', 'Trade'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: center'], 'format' => 'raw', 'value' => function ($model) { $html = DateTimeUtils::htmlDateFormatFromDB($model->trade_date, DateTimeUtils::FM_VIEW_DATE, true); $lblView = Yii::t('button', 'View'); $lblEdit = Yii::t('button', 'Edit'); $urlEdit = null; $arrBtns = []; $entryId = $model->nav_id; $urlEdit = BaseUrl::toRoute(['nav/update', 'id' => $entryId]); $arrBtns[] = StringUtils::format('<li><a href="{0}">{1}</a></li>', [$urlEdit, $lblEdit]); $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">';
</span> </a></li> <li><a href="javascript:void(0);"> <?php echo $model->getAttributeLabel('trade_date'); ?> <?php echo DateTimeUtils::htmlDateFormatFromDB($model->trade_date, DateTimeUtils::FM_VIEW_DATE_WD, ['class' => 'pull-right']); ?> </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'); ?>
</div> <div class="row"><?php Pjax::begin(); echo GridView::widget(['options' => ['class' => 'grid-view col-xs-12 table-responsive'], 'tableOptions' => ['class' => 'table table-bordered'], 'showFooter' => true, 'headerRowOptions' => ['class' => 'warning'], 'footerRowOptions' => ['class' => 'warning', 'style' => 'font-weight:bold'], 'dataProvider' => new ActiveDataProvider(['query' => $dataQuery, 'pagination' => ['pagesize' => 20]]), 'columns' => [['label' => Yii::t('fin.grid', 'No.'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right', 'colspan' => 2], 'contentOptions' => function ($model, $key, $index) { 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', 'Reference'), '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->entry_id, 6, '0', STR_PAD_LEFT); }], ['attribute' => 'entry_date', 'label' => Yii::t('fin.grid', 'Transaction Date'), 'headerOptions' => ['style' => 'text-align: center'], 'footerOptions' => ['style' => 'text-align: right'], 'contentOptions' => function ($model, $key, $index) { return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)]; }, 'format' => 'raw', 'value' => function ($model) use($phpFmShortDate) { return DateTimeUtils::htmlDateFormatFromDB($model->entry_date, DateTimeUtils::FM_VIEW_DATE, true); }, 'footer' => $htmlFooterCreditBalance], ['label' => Yii::t('fin.grid', 'Debit 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_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)];
<th class="warning"><?php echo $model->getAttributeLabel('opening_date'); ?> </th> <td class="info"><?php echo DateTimeUtils::htmlDateFormatFromDB($model->opening_date, DateTimeUtils::FM_VIEW_DATE_WD, true); ?> </td> </tr> <tr> <th class="warning"><?php echo $model->getAttributeLabel('closing_date'); ?> </th> <td class="info"><?php echo DateTimeUtils::htmlDateFormatFromDB($model->closing_date, DateTimeUtils::FM_VIEW_DATE_WD, true); ?> </td> </tr> <tr> <th class="warning"><?php echo $model->getAttributeLabel('interest_days'); ?> </th> <td class="info"><?php echo $dateDiff->days; ?> </td> </tr> <tr> <th class="warning"><?php
}, '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', 'Reference'), '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->id, 6, '0', STR_PAD_LEFT); }], ['class' => DataColumn::className(), 'label' => Yii::t('fin.grid', 'Transaction'), '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->purchase_date, DateTimeUtils::FM_VIEW_DATE, true); }], ['label' => Yii::t('fin.grid', 'Type'), '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) use($arrPurchaseType) { $html = $arrPurchaseType[$model->purchase_type]; $html .= is_null($model->sip_date) ? '' : ' ' . DateTimeUtils::htmlDateFormatFromDB($model->sip_date, DateTimeUtils::FM_VIEW_DATE, true); $html .= '<br/>' . NumberUtils::format($model->purchase); return $html; }, 'footer' => $htmlFooterRequest], ['label' => Yii::t('fin.grid', 'Fee Rate'), '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) { $totalFeeRate = $model->purchase_fee_rate * (100 - $model->discount_rate) / 100; $html = NumberUtils::format($totalFeeRate, 2); $html .= ' %<br/>' . NumberUtils::format($model->purchase_fee); return $html; }, 'footer' => $htmlFooterPurchaseFee], ['label' => Yii::t('fin.grid', 'NAV / Real'), '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) { $html = NumberUtils::format($model->nav, 2); $html .= '<br/>' . NumberUtils::format($model->purchase - $model->purchase_fee); return $html;
$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; }, 'footer' => $htmlFooterCredit], ['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'], 'format' => 'raw', 'value' => function ($model) { $htmls = []; if ($model->credit > 0) { $htmls[] = '<span class="label label-info pull-right">' . NumberUtils::format($model->credit) . '</span>'; } if ($model->debit > 0) { $htmls[] = '<span class="label label-danger pull-right">' . NumberUtils::format($model->debit) . '</span>'; } return implode('<br/>', $htmls); }, 'footer' => $htmlFooterDebit], ['label' => Yii::t('fin.grid', 'Bill Date'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => ['style' => 'vertical-align: middle; text-align: center'], 'format' => 'raw', 'value' => function ($model) { if ($model->order_id > 0 && !is_null($model->bill_date)) { $urlEdit = BaseUrl::toRoute(['bill/update', 'id' => $model->order_id]); return StringUtils::format('<a href="{0}">{1}</a>', [$urlEdit, DateTimeUtils::htmlDateFormatFromDB($model->bill_date, DateTimeUtils::FM_VIEW_DATE, true)]); } return ''; }]]]); 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; }], ['label' => Yii::t('fin.grid', 'Reference'), '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 str_pad($model->id, 6, '0', STR_PAD_LEFT); }], ['label' => Yii::t('fin.grid', 'Start Date'), 'headerOptions' => ['style' => 'text-align: center'], '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->start_date, DateTimeUtils::FM_VIEW_DATE, true); }], ['label' => Yii::t('fin.grid', 'End Date'), 'headerOptions' => ['style' => 'text-align: center'], 'contentOptions' => function ($model, $key, $index) { return ['style' => 'vertical-align: middle; text-align: center', 'class' => MasterValueUtils::getColorRow($index)]; }, 'format' => 'raw', 'value' => function ($model) { return is_null($model->end_date) ? '<span class="text-fuchsia">' . DateTimeUtils::getNow()->format(DateTimeUtils::FM_DB_DATE) . '</span>' : DateTimeUtils::htmlDateFormatFromDB($model->end_date, DateTimeUtils::FM_VIEW_DATE, true); }], ['label' => Yii::t('fin.grid', 'Unit'), '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($model->interest_unit, 2); }], ['label' => Yii::t('fin.grid', 'Days'), '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) { $startDate = DateTimeUtils::parse($model->start_date, DateTimeUtils::FM_DB_DATE); $endDate = is_null($model->end_date) ? DateTimeUtils::getNow() : DateTimeUtils::parse($model->end_date, DateTimeUtils::FM_DB_DATE); $interval = $endDate->diff($startDate); $days = ($interval->invert === 1 ? 1 : -1) * $interval->days + 1; return $days; }], ['label' => Yii::t('fin.grid', 'Interest'), '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) {