FM / vendor-order-report

/var/www/vhosts/nabawater/backend/views/vendor-order-report/

/var/www/vhosts/nabawater/backend/views/vendor-order-report

Name	Size	Mode	Actions
index.php	7632	0644	edit dl rm
view.php	2128	0644	edit dl rm
_search.php	1229	0644	edit dl rm

Edit: /var/www/vhosts/nabawater/backend/views/vendor-order-report/index.php (7632B)

<?php

use backend\components\CGridView;
use backend\models\Order;
use yii\helpers\ArrayHelper;
use yii\helpers\Html;
use yii\helpers\Url;
use common\helpers\DateTimeHelper;
use common\helpers\Com;
use backend\models\Vendor;

/* @var $this \yii\web\View */
/* @var $model \backend\models\Order */
/* @var $searchModel \backend\models\VendorOrderReportSearch */
/* @var $dataProvider \yii\data\ActiveDataProvider */

$this->title = 'Vendor Order Details';

$columns = [
    ['class' => \yii\grid\SerialColumn::class],
    
    [
        'attribute' => 'vendor_name',
        'value' => function (Order $model) {
           $data =  Vendor::getVendorName($model->vendor_id);
           return $data->vendor_name;
        }
    ],
    [
        'attribute' => 'order_date',
        'value' => function (Order $model) {
           return $model->order_date;
        }
    ],

[
        'attribute' => 'order_total',
        'value' => function (Order $model) {
            if ($model->total_order_amount != '') {
                return round($model->total_order_amount, 2);
            } else {
                return '-';
            }
        }
    ],
    [
        'attribute' => 'total_discount_value',
        'value' => function (Order $model) {
            if ($model->total_discount_value != '') {
                return round($model->total_discount_value, 2);
            } else {
                return '-';
            }
        }
    ],
    [
        'attribute' => 'vendor_profit',
        'value' => function (Order $model) {
            if ($model->total_vendor_profit != '') {
                return round($model->total_vendor_profit, 2);
            } else {
                return '-';
            }
        }
    ],
    [
        'attribute' => 'admin_commission',
        'value' => function (Order $model) {
            if ($model->total_admin_commission != '') {
                return round($model->total_admin_commission, 2);
            } else {
                return '-';
            }
        }
    ],
    [
        'attribute' => 'no_of_orders',
        'value' => function (Order $model) {
            return $model->no_of_orders;
        }
    ],
    [
                'class' => \yii\grid\ActionColumn::className(),
                'header' => Yii::t('backend', 'Actions'),
                'template' => '{view}',
                'buttons' => [
                    'view' => function ($url, $model, $key) {    
                        return  Html::a('<i class="fa fa-eye"  title="Delete"></i>' ,'javascript:;',
                            [
                                'data-toggle'  => 'tooltip',
                                'class' => 'order-view',
                                'data-id' => $model->branch_id,
                                'data-date' => $model->order_date,
                            ]);
                    },

],
    ],
                  
];

?>
<div class="row">
            <div class="col-lg-3">
                <div class="card bg-success text-white text-center card-sty">
                    <div class="card-body">
                        <h4><?= yii::t('backend','Total Orders') ?></h4>
                        <h3><?= $dataProvider->query->count() ?></h3>
                        <i class="ti-shopping-cart"></i>
                    </div>
                </div>
            </div>
             <div class="col-lg-3">
                        <div class="card bg-info text-white text-center card-sty">
                            <div class="card-body">
                                <h4><?= yii::t('backend','Total Earnings') ?></h4>
                                <h3><?= Com::setPriceFormat($dataProvider->query->sum('total_vendor_profit')) ?></h3>
                                <i class="ti-user"></i>
                            </div>
                        </div>
            </div>
        </div>

<div class="card">
    <div class="card-body">
        <div class="d-flex">
            <div>
                <h4 class="card-title"><?= $this->title ?></h4>
            </div>
            <div class="ml-auto">
                <?= Html::a(
                    'Export',
                    ['export'],
                    ['class' => 'btn btn-info btn-sm']
                ) ?>
            </div>
        </div>
        <hr/>
        <?= $this->render('_search', ['model' => $searchModel]) ?>
    </div>
    <?= CGridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => $columns,
        'hideFilterRow' => true,
    ]); ?>
</div>

<div id="order_preview" class="modal fade" role="dialog" data-backdrop="static" >
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h4 class="modal-title"><b><?= yii::t('backend','Order Details' ) ?></b></h4>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
            </div>
            <div class="modal-body" id="print_content">
            </div>
            <div class="modal-footer">
                <button class="btn btn-danger" id ="cancel-order-modal"  data-dismiss="modal" ><?= Yii::t('backend', 'Cancel') ?></button>
            </div>
        </div>
    </div>
</div>

<div id="printpreview" class="modal fade" role="dialog" data-backdrop="static">
    <div class="modal-dialog modal-lg" >
        <div class="modal-content" style="width:110;">
            <div class="modal-header">
                <h4 class="modal-title"><b><?= yii::t('backend','Order Details' ) ?></b></h4>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
            </div>
            <div class="modal-body" id="print_content">
            </div>
            <div class="modal-footer">
                <button class="btn btn-danger" id ="cancel-order-modal"  data-dismiss="modal" ><?= Yii::t('backend', 'Cancel') ?></button>
            </div>
        </div>
    </div>
</div>
<script type="text/javascript">
    
runOnLoad(function () {
    $('body').on('click', '.order-view', function () {
        $this = $(this);
        Core.ajax({
            url  : '<?= Url::to(['vendor-order-report/quick-view']) ?>',
            data : { id : $(this).attr('data-id'),date: $this.attr('data-date')},
            done : function (json) {
                if ( parseInt(json.status) === 1 ) {
                    $('#order_preview .modal-body').html('');
                    $('#order_preview .modal-body').html(json.data);
                    $('#order_preview').modal('toggle');
                    return;
                }

Core.handleInvalidServerResponse(json);
            }
        });
    });

$('body').on('click', '.quick-view', function () {
        $this = $(this);
        Core.ajax({
            url  : '<?= Url::to(['order/quick-view']) ?>',
            data : { id : $this.attr('data-key')},
            done : function (json) {
                if ( parseInt(json.status) === 1 ) {
                    $('#printpreview').modal('toggle');
                    $('#printpreview .modal-body').html('');
                    $('#printpreview .modal-body').html(json.data);
                    return;
                }

Core.handleInvalidServerResponse(json);
            }
        });
    });
});
</script>

title = 'Vendor Order Details'; $columns = [ ['class' => \yii\grid\SerialColumn::class], [ 'attribute' => 'vendor_name', 'value' => function (Order $model) { $data = Vendor::getVendorName($model->vendor_id); return $data->vendor_name; } ], [ 'attribute' => 'order_date', 'value' => function (Order $model) { return $model->order_date; } ], [ 'attribute' => 'order_total', 'value' => function (Order $model) { if ($model->total_order_amount != '') { return round($model->total_order_amount, 2); } else { return '-'; } } ], [ 'attribute' => 'total_discount_value', 'value' => function (Order $model) { if ($model->total_discount_value != '') { return round($model->total_discount_value, 2); } else { return '-'; } } ], [ 'attribute' => 'vendor_profit', 'value' => function (Order $model) { if ($model->total_vendor_profit != '') { return round($model->total_vendor_profit, 2); } else { return '-'; } } ], [ 'attribute' => 'admin_commission', 'value' => function (Order $model) { if ($model->total_admin_commission != '') { return round($model->total_admin_commission, 2); } else { return '-'; } } ], [ 'attribute' => 'no_of_orders', 'value' => function (Order $model) { return $model->no_of_orders; } ], [ 'class' => \yii\grid\ActionColumn::className(), 'header' => Yii::t('backend', 'Actions'), 'template' => '{view}', 'buttons' => [ 'view' => function ($url, $model, $key) { return Html::a('' ,'javascript:;', [ 'data-toggle' => 'tooltip', 'class' => 'order-view', 'data-id' => $model->branch_id, 'data-date' => $model->order_date, ]); }, ], ], ]; ?>

query->count() ?>

query->sum('total_vendor_profit')) ?>

title ?>

'btn btn-info btn-sm'] ) ?>

render('_search', ['model' => $searchModel]) ?>

$dataProvider, 'filterModel' => $searchModel, 'columns' => $columns, 'hideFilterRow' => true, ]); ?>