<?php

namespace Modules\Platform\Core\Helper;


use Torzer\Awesome\Landlord\Facades\Landlord;
use Illuminate\Support\Facades\Cache;
use Modules\Platform\User\Entities\Group;
use Modules\Platform\User\Entities\User;

/**
 * DataTable helper
 *
 * Class DataTableHelper
 * @package Modules\Platform\Core\Helper
 */
class DataTableHelper
{
    const FILTER_DROP_DOWN_CACHE = 1440;


    /**
     * Get Datatable translation files
     * @return string
     */
    public static function translations()
    {
        try {


            return \File::get(public_path('bap/js/trans/datatable/' . app()->getLocale() . '.json'));

        } catch (\Exception $exception) {
            return '{}';
        }
    }

    public static function buttons($title = 'Exported records', $customActions = [])
    {
        $result = [

            [
                'extend' => 'reset',
                'text' => trans('core::core.reset'),
            ],
            [
                'extend' => 'copy',
                'title' => $title,
                'text' => trans('core::core.copy'),
                'exportOptions' => [
                    'format' => [
                        'header' => "function(mDataProp,columnIdx) { 
                                var htmlText = '<span>' + mDataProp + '</span>';
                                var jHtmlObject = jQuery(htmlText);
                                jHtmlObject.find('div').remove();
                                var newHtml = jHtmlObject.text();
                                return newHtml;
                                }"
                    ]
                ]
            ],
            [
                'extend' => 'print',
                'title' => $title,
                'text' => trans('core::core.print'),
                'exportOptions' => [
                    'format' => [
                        'header' => "function(mDataProp,columnIdx) { 
                                var htmlText = '<span>' + mDataProp + '</span>';
                                var jHtmlObject = jQuery(htmlText);
                                jHtmlObject.find('div').remove();
                                var newHtml = jHtmlObject.text();
                                return newHtml;
                                }"
                    ]
                ]
            ],
            [
                'extend' => 'excel',
                'title' => $title,
                'text' => trans('core::core.excel'),
                'exportOptions' => [
                    'format' => [
                        'header' => "function(mDataProp,columnIdx) { 
                                var htmlText = '<span>' + mDataProp + '</span>';
                                var jHtmlObject = jQuery(htmlText);
                                jHtmlObject.find('div').remove();
                                var newHtml = jHtmlObject.text();
                                return newHtml;
                                }"
                    ]
                ]
            ],
            [
                'extend' => 'pdfHtml5',
                'title' => $title,
                'text' => trans('core::core.pdf'),
                'orientation' => 'landscape',
                'exportOptions' => [
                    'format' => [
                        'header' => "function(mDataProp,columnIdx) { 
                                var htmlText = '<span>' + mDataProp + '</span>';
                                var jHtmlObject = jQuery(htmlText);
                                jHtmlObject.find('div').remove();
                                var newHtml = jHtmlObject.text();
                                return newHtml;
                                }"
                    ]
                ]
            ]];


        $result = array_merge($result, $customActions);

        return $result;
    }

    /**
     *
     * @return array
     */
    public static function filterOwnerDropdown()
    {


        if (!empty(Landlord::getTenants()->first())) {

            $tenantId = Landlord::getTenants()->first();

            $users = Cache::remember('users_for_company_' . $tenantId, 60, function () {
                return User::where('company_id', '=', Landlord::getTenants()->first())->get();
            });

            $groups = Cache::remember('groups_for_company_' . $tenantId, 60, function () {
                return Group::where('company_id', '=', Landlord::getTenants()->first())->get();
            });
        } else {
            $users = User::all();
            $groups = Group::all();
        }

        $result = [];

        foreach ($users as $user) {
            $result[] = [
                'value' => $user->name,
                'label' => $user->name
            ];
        }

        foreach ($groups as $group) {
            $result[] = [
                'value' => $group->name,
                'label' => $group->name
            ];
        }


        return $result;
    }

    public static function queryCauser($query, $keyword)
    {
        $users = User::where('name', 'LIKE', '%' . $keyword . '%')->get()->pluck('id')->toArray();

        if (count($users) > 0) {
            $query->whereIn('causer_id', $users);
        }
    }

    /**
     * @param $query
     * @param $keyword
     * @param null $tableName - Use this where joining with others table
     */
    public static function queryOwner($query, $keyword, $tableName = null)
    {
        $users = User::where('name', 'LIKE', '%' . $keyword . '%')->get()->pluck('id')->toArray();
        $groups = Group::where('name', 'LIKE', '%' . $keyword . '%')->get()->pluck('id')->toArray();

        if ($tableName != null) {
            $tableName = $tableName . '.';
        }

        if (count($users) > 0 && count($groups) > 0) {
            $query->where(function ($q) use ($tableName) {
                $q->where($tableName . 'owned_by_type', Group::class);
                $q->orWhere($tableName . 'owned_by_type', User::class);
            });
        } else {
            if (count($users) > 0) {
                $query->where(function ($q) use ($tableName) {
                    $q->orWhere($tableName . 'owned_by_type', User::class);
                });
            } else {
                if (count($groups) > 0) {
                    $query->where(function ($q) use ($tableName) {
                        $q->orWhere($tableName . 'owned_by_type', Group::class);
                    });
                }
            }
        }

        $array = array_merge($users, $groups);
        $query->whereIn($tableName . 'owned_by_id', $array);
    }

    public static function getNumbersFromFilters($keyword)
    {


        if (strpos($keyword, '-') !== false) {
            $numbers = str_replace('yadcf_delim', '', $keyword);

            $numbers = explode("--", $numbers);

            return $numbers;
        }
    }

    /**
     * Apply simple link
     * @param $text
     * @param $url
     * @return string
     */
    public static function applyLink($text, $url)
    {

        return '<a href="' . $url . '">' . $text . '</a>';

    }

    /**
     * Whether a custom field type is filtered through the datatable date
     * range picker (same widget used by the created_at / updated_at columns).
     *
     * @param string|null $type Custom field type from the field settings
     * @return bool
     */
    public static function isDateCustomFieldType($type)
    {
        return in_array($type, ['date', 'datetime'], true);
    }

    /**
     * @param $keyword
     * @return array|mixed
     */
    public static function getDatesForFilter($keyword)
    {
        if (strpos($keyword, ' - ') !== false) {
            $dates = str_replace('%%', '', $keyword);

            $dates = explode(" - ", $dates);

            if ($dates[0] != '') {
                $dates[0] = DateHelper::formatDateToUTC($dates[0] . ' 00:00:00');
            }
            if ($dates[1] != '') {
                $dates[1] = DateHelper::formatDateToUTC($dates[1] . ' 23:59:59');
            }

            return $dates;
        }
    }


    /**
     * Cache of generated record urls, keyed by route name and record id.
     *
     * renderLink() runs once per column per row, so generating the same url
     * over and over costs several seconds on wide tables with large pages.
     *
     * @var array
     */
    private static $recordUrlCache = [];

    /**
     * Render column link
     *
     * @param $column
     * @param $record
     * @param $columnProperties
     * @param $route
     * @return string
     */
    public static function renderLink($column, $record, $columnProperties, $route)
    {
        $displayColumn = $record->$column;

        if ($route != '') {
            $cacheKey = $route . '|' . $record->id;

            if (!array_key_exists($cacheKey, self::$recordUrlCache)) {
                self::$recordUrlCache[$cacheKey] = route($route, $record->id);
            }

            $href = self::$recordUrlCache[$cacheKey];
        } else {
            $href = '';
        }

        $datatype = 'text';

        if (isset($columnProperties['data_type'])) {
            $datatype = $columnProperties['data_type'];
        }

        if ($datatype == 'boolean') {
            $displayColumn = trans('core::core.yes_no.' . $displayColumn);
        }
        if ($datatype == 'image') {
            if (!empty($displayColumn)) {

                $displayColumn = "<img class='datatable_image' src='" . asset($displayColumn) . "' />";

                if (!empty($href)) {
                    return '<a data-column="' . strip_tags($column) . '" title="' . strip_tags($displayColumn) . '" href="' . $href . '"> ' . ($displayColumn) . '</a>';
                }
                return $displayColumn;

            }
        }

        if ($datatype == 'none') {
            return $displayColumn;
        }
        if ($datatype == 'datetime') {
            $displayColumn = UserHelper::formatUserDateTime($displayColumn);
        }
        if ($datatype == 'assigned_to') {
            if ($record->owned_by != null) {
                $displayColumn = $record->owned_by->name;
            }
        }

        if ($datatype == 'email') {
            $href = 'mailto:' . $record->$column;
        }
        if ($datatype == 'date') {
            $displayColumn = UserHelper::formatUserDate($displayColumn);
        }

        if (is_array($displayColumn)) {
            $displayColumn = implode(",", $displayColumn);
        }

        $oldDisplayColumn = (string) ($displayColumn ?? '');

        $title = $oldDisplayColumn;

        $maxDisplayTextSize = config('datatables.max_display_text_size');

        if (isset($columnProperties['max_display_text_size'])) {
            $maxDisplayTextSize = $columnProperties['max_display_text_size'];
        }

        if (mb_strlen($oldDisplayColumn, 'UTF-8') >= $maxDisplayTextSize) {
            $displayColumn = mb_substr($oldDisplayColumn, 0, $maxDisplayTextSize, 'UTF-8') . '...';
        } else {
            $displayColumn = $oldDisplayColumn;
        }

        if (!empty($href)) {
            $link = '<a data-column="' . strip_tags((string) $column) . '" title="' . strip_tags((string) $title) . '" href="' . $href . '"> ' . strip_tags((string) $displayColumn) . '</a>';
        } else {
            $link = strip_tags((string) $displayColumn);
        }


        return $link;
    }
}