Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php namespace Webkul\Admin\DataGrids\Sales; use Illuminate\Support\Facades\DB; use Web..
Decoded Output download
<?php
namespace Webkul\Admin\DataGrids\Sales;
use Illuminate\Support\Facades\DB;
use Webkul\DataGrid\DataGrid;
use Webkul\Sales\Models\OrderAddress;
class OrderShipmentDataGrid extends DataGrid
{
/**
* Shipment Id.
*
* @var string
*/
protected $primaryColumn = 'shipment_id';
/**
* Prepare query builder.
*
* @return \Illuminate\Database\Query\Builder
*/
public function prepareQueryBuilder()
{
$queryBuilder = DB::table('shipments')
->leftJoin('addresses as order_address_shipping', function ($leftJoin) {
$leftJoin->on('order_address_shipping.order_id', '=', 'shipments.order_id')
->where('order_address_shipping.address_type', OrderAddress::ADDRESS_TYPE_SHIPPING);
})
->leftJoin('orders', 'shipments.order_id', '=', 'orders.id')
->leftJoin('inventory_sources', 'shipments.inventory_source_id', '=', 'inventory_sources.id')
->select(
'shipments.id as shipment_id',
'orders.increment_id as shipment_order_id',
'shipments.total_qty as shipment_total_qty',
'orders.created_at as order_date',
'shipments.created_at as shipment_created_at'
)
->addSelect(DB::raw('CONCAT('.DB::getTablePrefix().'order_address_shipping.first_name, " ", '.DB::getTablePrefix().'order_address_shipping.last_name) as shipped_to'))
->selectRaw('IF('.DB::getTablePrefix().'shipments.inventory_source_id IS NOT NULL,'.DB::getTablePrefix().'inventory_sources.name, '.DB::getTablePrefix().'shipments.inventory_source_name) as inventory_source_name');
$this->addFilter('shipment_id', 'shipments.id');
$this->addFilter('shipment_order_id', 'orders.increment_id');
$this->addFilter('shipment_total_qty', 'shipments.total_qty');
$this->addFilter('inventory_source_name', DB::raw('IF('.DB::getTablePrefix().'shipments.inventory_source_id IS NOT NULL,'.DB::getTablePrefix().'inventory_sources.name, '.DB::getTablePrefix().'shipments.inventory_source_name)'));
$this->addFilter('order_date', 'orders.created_at');
$this->addFilter('shipment_created_at', 'shipments.created_at');
$this->addFilter('shipped_to', DB::raw('CONCAT('.DB::getTablePrefix().'order_address_shipping.first_name, " ", '.DB::getTablePrefix().'order_address_shipping.last_name)'));
return $queryBuilder;
}
/**
* Add Columns.
*
* @return void
*/
public function prepareColumns()
{
$this->addColumn([
'index' => 'shipment_id',
'label' => trans('admin::app.sales.shipments.index.datagrid.id'),
'type' => 'integer',
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipment_order_id',
'label' => trans('admin::app.sales.shipments.index.datagrid.order-id'),
'type' => 'string',
'searchable' => true,
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipment_total_qty',
'label' => trans('admin::app.sales.shipments.index.datagrid.total-qty'),
'type' => 'integer',
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'inventory_source_name',
'label' => trans('admin::app.sales.shipments.index.datagrid.inventory-source'),
'type' => 'string',
'searchable' => true,
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipped_to',
'label' => trans('admin::app.sales.shipments.index.datagrid.shipment-to'),
'type' => 'string',
'searchable' => true,
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'order_date',
'label' => trans('admin::app.sales.shipments.index.datagrid.order-date'),
'type' => 'date',
'filterable' => true,
'filterable_type' => 'date_range',
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipment_created_at',
'label' => trans('admin::app.sales.shipments.index.datagrid.shipment-date'),
'type' => 'date',
'filterable' => true,
'filterable_type' => 'date_range',
'sortable' => true,
]);
}
/**
* Prepare actions.
*
* @return void
*/
public function prepareActions()
{
if (bouncer()->hasPermission('sales.shipments.view')) {
$this->addAction([
'icon' => 'icon-view',
'title' => trans('admin::app.sales.shipments.index.datagrid.view'),
'method' => 'GET',
'url' => function ($row) {
return route('admin.sales.shipments.view', $row->shipment_id);
},
]);
}
}
}
?>
Did this file decode correctly?
Original Code
<?php
namespace Webkul\Admin\DataGrids\Sales;
use Illuminate\Support\Facades\DB;
use Webkul\DataGrid\DataGrid;
use Webkul\Sales\Models\OrderAddress;
class OrderShipmentDataGrid extends DataGrid
{
/**
* Shipment Id.
*
* @var string
*/
protected $primaryColumn = 'shipment_id';
/**
* Prepare query builder.
*
* @return \Illuminate\Database\Query\Builder
*/
public function prepareQueryBuilder()
{
$queryBuilder = DB::table('shipments')
->leftJoin('addresses as order_address_shipping', function ($leftJoin) {
$leftJoin->on('order_address_shipping.order_id', '=', 'shipments.order_id')
->where('order_address_shipping.address_type', OrderAddress::ADDRESS_TYPE_SHIPPING);
})
->leftJoin('orders', 'shipments.order_id', '=', 'orders.id')
->leftJoin('inventory_sources', 'shipments.inventory_source_id', '=', 'inventory_sources.id')
->select(
'shipments.id as shipment_id',
'orders.increment_id as shipment_order_id',
'shipments.total_qty as shipment_total_qty',
'orders.created_at as order_date',
'shipments.created_at as shipment_created_at'
)
->addSelect(DB::raw('CONCAT('.DB::getTablePrefix().'order_address_shipping.first_name, " ", '.DB::getTablePrefix().'order_address_shipping.last_name) as shipped_to'))
->selectRaw('IF('.DB::getTablePrefix().'shipments.inventory_source_id IS NOT NULL,'.DB::getTablePrefix().'inventory_sources.name, '.DB::getTablePrefix().'shipments.inventory_source_name) as inventory_source_name');
$this->addFilter('shipment_id', 'shipments.id');
$this->addFilter('shipment_order_id', 'orders.increment_id');
$this->addFilter('shipment_total_qty', 'shipments.total_qty');
$this->addFilter('inventory_source_name', DB::raw('IF('.DB::getTablePrefix().'shipments.inventory_source_id IS NOT NULL,'.DB::getTablePrefix().'inventory_sources.name, '.DB::getTablePrefix().'shipments.inventory_source_name)'));
$this->addFilter('order_date', 'orders.created_at');
$this->addFilter('shipment_created_at', 'shipments.created_at');
$this->addFilter('shipped_to', DB::raw('CONCAT('.DB::getTablePrefix().'order_address_shipping.first_name, " ", '.DB::getTablePrefix().'order_address_shipping.last_name)'));
return $queryBuilder;
}
/**
* Add Columns.
*
* @return void
*/
public function prepareColumns()
{
$this->addColumn([
'index' => 'shipment_id',
'label' => trans('admin::app.sales.shipments.index.datagrid.id'),
'type' => 'integer',
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipment_order_id',
'label' => trans('admin::app.sales.shipments.index.datagrid.order-id'),
'type' => 'string',
'searchable' => true,
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipment_total_qty',
'label' => trans('admin::app.sales.shipments.index.datagrid.total-qty'),
'type' => 'integer',
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'inventory_source_name',
'label' => trans('admin::app.sales.shipments.index.datagrid.inventory-source'),
'type' => 'string',
'searchable' => true,
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipped_to',
'label' => trans('admin::app.sales.shipments.index.datagrid.shipment-to'),
'type' => 'string',
'searchable' => true,
'filterable' => true,
'sortable' => true,
]);
$this->addColumn([
'index' => 'order_date',
'label' => trans('admin::app.sales.shipments.index.datagrid.order-date'),
'type' => 'date',
'filterable' => true,
'filterable_type' => 'date_range',
'sortable' => true,
]);
$this->addColumn([
'index' => 'shipment_created_at',
'label' => trans('admin::app.sales.shipments.index.datagrid.shipment-date'),
'type' => 'date',
'filterable' => true,
'filterable_type' => 'date_range',
'sortable' => true,
]);
}
/**
* Prepare actions.
*
* @return void
*/
public function prepareActions()
{
if (bouncer()->hasPermission('sales.shipments.view')) {
$this->addAction([
'icon' => 'icon-view',
'title' => trans('admin::app.sales.shipments.index.datagrid.view'),
'method' => 'GET',
'url' => function ($row) {
return route('admin.sales.shipments.view', $row->shipment_id);
},
]);
}
}
}
Function Calls
None |
Stats
MD5 | c5f9b5f73fc63f17afdd8f1cc5edd128 |
Eval Count | 0 |
Decode Time | 108 ms |