<?php

namespace Modules\Sms\Datatables;

use Modules\Platform\Core\Datatable\PlatformDataTable;
use Modules\Platform\Core\Helper\DataTableHelper;
use Modules\Platform\Core\QueryBuilderParser\QueryBuilderParser;
use Modules\Sms\Entities\Sms;
use Modules\Sms\Entities\SmsSender;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class SmsDatatable extends PlatformDataTable
{
    const SHOW_URL_ROUTE = 'sms.sms.show';

    // protected $editRoute = 'sms.sms.edit';

    public static function availableQueryFilters()
    {
        return [
            
            [
                'id' => 'sms_msg.receiver',
                'label' => trans('sms::sms.form.receiver'),
                'type' => 'string'
            ],
            [
                'id' => 'sms_msg.senttime',
                'label' => trans('sms::sms.form.senttime'),
                'type' => 'date',
                'input_event' => 'dp.change',
                'plugin' => 'datetimepicker',
                'plugin_config' => [
                    'locale' => app()->getLocale(),
                    'calendarWeeks' => true,
                    'showClear' => true,
                    'showTodayButton' => true,
                    'showClose' => true,
                    'format' => \Modules\Platform\Core\Helper\UserHelper::userJsDateFormat()
                ]
            ],
            [
                'id' => 'sms_msg.status',
                'label' => trans('sms::sms.form.status'),
                'type' => 'string',
            ],
            [
                'id' => 'sms.sms_sender_id',
                'label' => 'Sender Name',
                'type' => 'integer',
                'input' => 'select',
                'multiple' => true,
                'plugin' => 'select2',
                'plugin_config' => [
                    'multiple' => 'multiple',
                    'width' => '300px',
                ],
                'values' => SmsSender::pluck('name', 'id'),
                'operators' => [
                    'in',
                    'not_in',
                    'is_null',
                    'is_not_null'
                ]
            ],
            [
                'id' => 'sms_msg.smstype',
                'label' => trans('sms::sms.form.smstype'),
                'type' => 'string'
            ],
            [
                'id' => 'sms_msg.smsLength',
                'label' => trans('sms::sms.form.smsLength'),
                'type' => 'integer',
            ],
            [
                'id' => 'sms_msg.smsCost',
                'label' => trans('sms::sms.form.smsCost'),
                'type' => 'double',
            ],
            [
                'id' => 'sms_msg.created_at',
                'label' => trans('core::core.table.created_at'),
                'type' => 'date',
                'input_event' => 'dp.change',
                'plugin' => 'datetimepicker',
                'plugin_config' => [
                    'locale' => app()->getLocale(),
                    'calendarWeeks' => true,
                    'showClear' => true,
                    'showTodayButton' => true,
                    'showClose' => true,
                    'format' => \Modules\Platform\Core\Helper\UserHelper::userJsDateFormat()
                ]
            ],
            [
                'id' => 'sms_msg.updated_at',
                'label' => trans('core::core.table.updated_at'),
                'type' => 'date',
                'input_event' => 'dp.change',
                'plugin' => 'datetimepicker',
                'plugin_config' => [
                    'locale' => app()->getLocale(),
                    'calendarWeeks' => true,
                    'showClear' => true,
                    'showTodayButton' => true,
                    'showClose' => true,
                    'format' => \Modules\Platform\Core\Helper\UserHelper::userJsDateFormat()
                ]
            ],
            [
                'id' => 'sms_msg.notes',
                'label' => trans('sms::sms.form.notes'),
                'type' => 'string'
            ],
        ];
    }

    public static function availableColumns()
    {
        return
            [
                
                'receiver' => [
                    'data' => 'receiver',
                    'title' => trans('sms::sms.form.receiver'),
                    'data_type' => 'text',
                    'filter_type' => 'text'
                ],
                'senttime' => [
                    'data' => 'senttime',
                    'title' => trans('sms::sms.form.senttime'),
                    'data_type' => 'datetime',
                    'filter_type' => 'bap_date_range_picker'
                ],
                'status' => [
                    'data' => 'status',
                    'title' => trans('sms::sms.form.status'),
                    'data_type' => 'text',
                    'filter_type' => 'text',
                ],
                'smsLength' => [
                    'data' => 'smsLength',
                    'title' => trans('sms::sms.form.smsLength'),
                    'data_type' => 'text',
                    'filter_type' => 'text'
                ],
                'smsCost' => [
                    'data' => 'smsCost',
                    'title' => trans('sms::sms.form.smsCost'),
                    'data_type' => 'text',
                    'filter_type' => 'text'
                ],
                'smstype' => [
                    'data' => 'smstype',
                    'title' => trans('sms::sms.form.smstype'),
                    'data_type' => 'text',
                    'filter_type' => 'text'
                ],
                'sender' => [
                    'name' => 'sms_dict_sender.name',
                    'data' => 'sender',
                    'title' => trans('sms::sms.form.sms_sender_id'),
                    'data_type' => 'text',
                    'filter_type' => 'text'
                ],
                'created_at' => [
                    'data' => 'created_at',
                    'title' => trans('core::core.table.created_at'),
                    'data_type' => 'datetime',
                    'filter_type' => 'bap_date_range_picker',
                ],
                'updated_at' => [
                    'data' => 'updated_at',
                    'title' => trans('core::core.table.updated_at'),
                    'data_type' => 'datetime',
                    'filter_type' => 'bap_date_range_picker',
                ],
            ];
    }

    protected function setFilterDefinition()
    {
        $this->filterDefinition = self::availableQueryFilters();
    }

    /**
     * Build DataTable class.
     *
     * @param mixed $query Results from query() method.
     * @return \Yajra\DataTables\DataTableAbstract
     */
    public function dataTable($query)
    {

        $dataTable = new EloquentDataTable($query);

        $this->applyLinks($dataTable, self::SHOW_URL_ROUTE);

        // $dataTable->filterColumn('owner', function ($query, $keyword) {
        //     DataTableHelper::queryOwner($query, $keyword, 'leads');
        // });

        // $dataTable->editColumn('status', function ($record) {

        //     $text = "<span class='badge badge-default $record->status_color'>$record->status</span>";
        //     return DataTableHelper::applyLink($text,route(self::SHOW_URL_ROUTE,$record->id));
        // });

        // $dataTable->editColumn('email', function ($record) {
        //     return $record->email;
        // });
        
        // $dataTable->filterColumn('email', function($query,$keyword){

        //     $query->whereHas('leadEmails', function ($query) use ($keyword) {
        //         $query->where('email', 'LIKE', "%$keyword%");
        //     })->get();

        // });

        $dataTable->filterColumn('created_at', function ($query, $keyword) {
            $dates = DataTableHelper::getDatesForFilter($keyword);

            if ($dates != null) {
                $query->whereBetween('sms_msg.created_at', array($dates[0], $dates[1]));
            }
        });
        $dataTable->filterColumn('updated_at', function ($query, $keyword) {
            $dates = DataTableHelper::getDatesForFilter($keyword);

            if ($dates != null) {
                $query->whereBetween('sms_msg.updated_at', array($dates[0], $dates[1]));
            }
        });

        $dataTable->filterColumn('senttime', function ($query, $keyword) {

            $dates = DataTableHelper::getDatesForFilter($keyword);

            if ($dates != null) {
                $query->whereBetween('sms_msg.senttime', array($dates[0], $dates[1]));
            }
        });

        // $dataTable->filterColumn('birth_date', function ($query, $keyword) {

        //     $dates = DataTableHelper::getDatesForFilter($keyword);

        //     if ($dates != null) {
        //         $query->whereBetween('leads.birth_date', array($dates[0], $dates[1]));
        //     }
        // });

        return $dataTable;
    }

    /**
     * Get query source of dataTable.
     *
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function query(Sms $model)
    {

        $query = $model->newQuery()
            ->leftJoin('sms_dict_sender', 'sms_msg.sms_sender_id', '=', 'sms_dict_sender.id')
            ->select(
                'sms_msg.*',
                'sms_dict_sender.name as sender',
            );

        if (!empty($this->filterRules)) {

            $filterRules = json_decode($this->filterRules);

            $filterRules = json_encode($filterRules);

            $queryBuilderParser = new  QueryBuilderParser();

            $queryBuilder = $queryBuilderParser->parse($filterRules, $query);

            return $queryBuilder;
        }

        return $query;
    }

    /**
     * Optional method if you want to use html builder.
     *
     * @return \Yajra\DataTables\Html\Builder
     */
    public function html()
    {
        return $this->builder()
            ->columns($this->getColumns())
            ->setTableAttribute('class', 'table table-hover')
            ->parameters([
                'dom' => 'lBfrtip',
                'responsive' => false,
                'stateSave' => false,
                'order' => [[1, 'desc']],
                'filterDefinitions' => $this->getFilterDefinition(),
                'filterRules' => $this->filterRules,
                'headerFilters' => true,
                'buttons' => DataTableHelper::buttons(),
                'regexp' => true
            ]);
    }

    /**
     * @return array
     */
    protected function getColumns()
    {
        if (!empty($this->advancedView)) {
            $result = [];
            if ($this->allowSelect) {
                $result = $this->btnCheck_selection;
            }
            return $result + $this->advancedView;
        }

        $columns = self::availableColumns();


        $result = [];

        // if ($this->allowSelect) {
        //     $result = $this->btnCheck_selection;
        // }
        // if ($this->allowUnlink) {
        //     $result = $this->btnUnlink;
        // }
        // if ($this->allowQuickEdit) {
        //     $result = $result + $this->btnQuick_edit;;
        // }

        $result = $result + $columns;

        return $result;
    }
}