<?php

use AcyMailing\Helpers\TabHelper;

trait TheEventsCalendarInsertion
{
    public function getStandardStructure(string &$customView): void
    {
        $tag = new stdClass();
        $tag->id = 0;

        $format = new stdClass();
        $format->tag = $tag;
        $format->title = '{title}';
        $format->afterTitle = acym_translation('ACYM_PRICE').': {price}';
        $format->afterArticle = acym_translation('ACYM_DATE').': {date} <br> '.acym_translation('ACYM_LOCATION').': {location}';
        $format->imagePath = '{image}';
        $format->description = '{intro}';
        $format->link = '{link}';
        $format->customFields = [];
        $customView = '<div class="acymailing_content">'.$this->pluginHelper->getStandardDisplay($format).'</div>';
    }

    public function initReplaceOptionsCustomView(): void
    {
        $this->replaceOptions = [
            'link' => ['ACYM_LINK'],
            'picthtml' => ['ACYM_IMAGE'],
            'startdate' => ['ACYM_START_DATE'],
            'enddate' => ['ACYM_END_DATE'],
            'simplestartdate' => ['ACYM_START_DATE_SIMPLE'],
            'simpleenddate' => ['ACYM_END_DATE_SIMPLE'],
        ];
    }

    public function initElementOptionsCustomView(): void
    {
        $query = 'SELECT post.*, occurrence.start_date, occurrence.start_date_utc, occurrence.end_date, occurrence.end_date_utc 
                FROM #__tec_occurrences AS occurrence 
                JOIN #__posts AS post ON post.ID = occurrence.post_id
                WHERE post.post_type = "tribe_events" 
                    AND post.post_status = "publish"';
        $element = acym_loadObject($query);
        if (empty($element)) return;
        foreach ($element as $key => $value) {
            $this->elementOptions[$key] = [$key];
        }
    }

    public function insertionOptions(?object $defaultValues = null): void
    {
        $this->defaultValues = $defaultValues;
        $this->prepareWPCategories('tribe_events_cat');

        $tabHelper = new TabHelper();
        $identifier = $this->name;
        $tabHelper->startTab(acym_translation('ACYM_ONE_BY_ONE'), !empty($this->defaultValues->defaultPluginTab) && $identifier === $this->defaultValues->defaultPluginTab);

        $displayOptions = [
            [
                'title' => 'ACYM_DISPLAY',
                'type' => 'checkbox',
                'name' => 'display',
                'options' => $this->displayOptions,
            ],
            [
                'title' => 'ACYM_CLICKABLE_TITLE',
                'type' => 'boolean',
                'name' => 'clickable',
                'default' => true,
            ],
            [
                'title' => 'ACYM_CLICKABLE_IMAGE',
                'type' => 'boolean',
                'name' => 'clickableimg',
                'default' => false,
            ],
            [
                'title' => 'ACYM_TRUNCATE',
                'type' => 'intextfield',
                'isNumber' => 1,
                'name' => 'wrap',
                'text' => 'ACYM_TRUNCATE_AFTER',
                'default' => 0,
            ],
            [
                'title' => 'ACYM_READ_MORE',
                'type' => 'boolean',
                'name' => 'readmore',
                'default' => true,
            ],
            [
                'title' => 'ACYM_DISPLAY_PICTURES',
                'type' => 'pictures',
                'name' => 'pictures',
            ],
            [
                'title' => '',
                'type' => 'custom',
                'name' => 'version',
                'output' => '',
                'js' => 'otherinfo += "| version:2";',
            ],
        ];

        $zoneContent = $this->getFilteringZone().$this->prepareListing();
        $this->displaySelectionZone($zoneContent);
        $this->pluginHelper->displayOptions($displayOptions, $identifier, 'individual', $this->defaultValues);

        $tabHelper->endTab();
        $identifier = 'auto'.$this->name;
        $tabHelper->startTab(acym_translation('ACYM_BY_CATEGORY'), !empty($this->defaultValues->defaultPluginTab) && $identifier === $this->defaultValues->defaultPluginTab);

        $catOptions = [
            [
                'title' => 'ACYM_ORDER_BY',
                'type' => 'select',
                'name' => 'order',
                'options' => [
                    'ID' => 'ACYM_DATE_CREATED',
                    'occurrence.start_date' => 'ACYM_DATE',
                    'post_title' => 'ACYM_TITLE',
                    'menu_order' => 'ACYM_MENU_ORDER',
                    'rand' => 'ACYM_RANDOM',
                ],
                'default' => 'startdate.meta_value',
                'defaultdir' => 'asc',
            ],
        ];

        $this->autoContentOptions($catOptions, 'event');
        $this->autoCampaignOptions($catOptions);

        $displayOptions = array_merge($displayOptions, $catOptions);

        $this->displaySelectionZone($this->getCategoryListing());
        $this->pluginHelper->displayOptions($displayOptions, $identifier, 'grouped', $this->defaultValues);

        $tabHelper->endTab();

        $tabHelper->display('plugin');
    }

    public function prepareListing(): string
    {
        $this->querySelect = 'SELECT occurrence.occurrence_id, post.ID, post.post_title, occurrence.start_date, occurrence.start_date_utc ';
        $this->query = 'FROM #__posts AS post ';
        $this->query .= 'JOIN #__tec_occurrences AS occurrence ON post.ID = occurrence.post_id ';
        $this->filters = [];
        $this->filters[] = 'post.post_type = "tribe_events"';
        $this->filters[] = 'post.post_status = "publish"';
        $this->searchFields = ['post.ID', 'post.post_title'];
        $this->pageInfo->order = 'occurrence.start_date';
        $this->elementIdTable = 'post';
        $this->elementIdColumn = 'ID';

        if ($this->getParam('hidepast', '1') === '1') {
            $this->filters[] = 'occurrence.`start_date` >= '.acym_escapeDB(gmdate('Y-m-d H:i:s'));
        }

        parent::prepareListing();

        //if a category is selected
        if (!empty($this->pageInfo->filter_cat)) {
            $this->query .= 'JOIN #__term_relationships AS cat ON post.ID = cat.object_id';
            $this->filters[] = 'cat.term_taxonomy_id = '.intval($this->pageInfo->filter_cat);
        }

        $listingOptions = [
            'header' => [
                'post_title' => [
                    'label' => 'ACYM_TITLE',
                    'size' => '7',
                ],
                'start_date_utc' => [
                    'label' => 'ACYM_START_DATE',
                    'size' => '4',
                    'type' => 'date',
                ],
                'ID' => [
                    'label' => 'ACYM_ID',
                    'size' => '1',
                    'class' => 'text-center',
                ],
            ],
            'id' => 'occurrence_id',
            'rows' => $this->getElements(),
        ];

        return $this->getElementsListing($listingOptions);
    }

    public function replaceContent(object &$email): void
    {
        $this->replaceMultiple($email);
        $this->replaceOne($email);
    }

    public function generateByCategory(object &$email): object
    {
        $tags = $this->pluginHelper->extractTags($email, 'auto'.$this->name);
        $this->tags = [];

        if (empty($tags)) return $this->generateCampaignResult;

        $time = time();

        foreach ($tags as $oneTag => $parameter) {
            if (isset($this->tags[$oneTag])) {
                continue;
            }

            if (empty($parameter->from)) {
                $parameter->from = gmdate('Y-m-d H:i:s', $time);
            } else {
                $parameter->from = acym_date(acym_replaceDate($parameter->from), 'Y-m-d H:i:s');
            }

            if (!empty($parameter->to)) {
                $parameter->to = acym_date(acym_replaceDate($parameter->to), 'Y-m-d H:i:s');
            }

            $query = 'SELECT DISTINCT occurrence.occurrence_id 
                    FROM #__tec_occurrences AS occurrence
                    JOIN #__posts AS post ON post.ID = occurrence.post_id ';

            $where = [];

            $selectedArea = $this->getSelectedArea($parameter);
            if (!empty($selectedArea)) {
                $query .= 'JOIN #__term_relationships AS cat ON post.ID = cat.object_id ';
                $where[] = 'cat.term_taxonomy_id IN ('.implode(',', $selectedArea).')';
            }

            $where[] = 'post.post_type = "tribe_events"';
            $where[] = 'post.post_status = "publish"';
            $where[] = 'occurrence.`start_date` >= '.acym_escapeDB($parameter->from);

            if (!empty($parameter->to)) {
                $where[] = 'occurrence.`start_date` <= '.acym_escapeDB($parameter->to).' AND occurrence.`start_date` != "0000-00-00 00:00:00"';
            }

            if (!empty($parameter->onlynew)) {
                $lastGenerated = $this->getLastGenerated($email->id);
                if (!empty($lastGenerated)) {
                    $where[] = 'post.`post_date` > '.acym_escapeDB(acym_date($lastGenerated, 'Y-m-d H:i:s', false));
                }
            }

            $query .= ' WHERE ('.implode(') AND (', $where).')';

            $this->tags[$oneTag] = $this->finalizeCategoryFormat($query, $parameter, 'post');
        }

        return $this->generateCampaignResult;
    }

    public function replaceIndividualContent(object $tag): string
    {
        $columnId = empty($tag->version) ? 'post.ID' : 'occurrence.occurrence_id';
        $query = 'SELECT post.*, occurrence.* 
                FROM #__tec_occurrences AS occurrence 
                JOIN #__posts AS post ON post.ID = occurrence.post_id
                WHERE post.post_type = "tribe_events" 
                    AND post.post_status = "publish"
                    AND '.$columnId.' = '.intval($tag->id);

        $element = $this->initIndividualContent($tag, $query);

        if (empty($element)) {
            return '';
        }

        $varFields = $this->getCustomLayoutVars($element);

        $properties = acym_loadObjectList('SELECT meta_key, meta_value AS `value` FROM #__postmeta WHERE post_id = '.intval($element->ID), 'meta_key');
        foreach ($properties as $name => $property) {
            $varFields['{'.$name.'}'] = $property->value;
        }

        $eventPermalink = get_permalink($element->ID);
        if (empty($element->has_recurrence)) {
            $varFields['{link}'] = $eventPermalink;
        } else {
            $eventPermalink = substr($eventPermalink, 0, strlen($eventPermalink) - 11);
            $occurrenceDate = substr($element->start_date_utc, 0, 10).'/';
            $varFields['{link}'] = $eventPermalink.$occurrenceDate;
        }

        $title = '';
        $afterTitle = '';
        $afterArticle = '';
        $imagePath = '';
        $contentText = '';
        $customFields = [];

        $varFields['{title}'] = $element->post_title;
        if (in_array('title', $tag->display)) {
            $title = $varFields['{title}'];
        }

        $imageId = get_post_thumbnail_id($element->ID);
        if (!empty($imageId)) {
            $imagePath = get_the_post_thumbnail_url($element->ID);
        }
        $varFields['{image}'] = $imagePath;
        // phpcs:ignore PluginCheck.CodeAnalysis.ImageFunctions.NonEnqueuedImage
        $varFields['{picthtml}'] = '<img alt="" src="'.$imagePath.'">';
        if (!in_array('image', $tag->display)) {
            $imagePath = '';
        }

        $varFields['{full}'] = $this->cleanExtensionContent($element->post_content);
        $varFields['{intro}'] = $this->cleanExtensionContent($this->getIntro($element->post_content));
        if (in_array('full', $tag->display)) {
            $contentText .= $varFields['{full}'];
        } elseif (in_array('intro', $tag->display)) {
            $contentText .= $varFields['{intro}'];
        }

        $allday = !empty($properties['_EventAllDay']->value) && $properties['_EventAllDay']->value === 'yes';

        $varFields['{startdate}'] = tribe_format_date($element->start_date, true);
        $varFields['{enddate}'] = tribe_format_date($element->end_date, true);

        $varFields['{simplestartdate}'] = tribe_format_date($element->start_date, false);
        $varFields['{simpleenddate}'] = tribe_format_date($element->end_date, false);

        $varFields['{date}'] = $allday ? $varFields['{simplestartdate}'] : $varFields['{startdate}'];
        if (($allday && $varFields['{simplestartdate}'] !== $varFields['{simpleenddate}']) || (!$allday && $element->start_date !== $element->end_date)) {
            if ($allday) {
                $endDateDisplay = $varFields['{simpleenddate}'];
            } else {
                if ($varFields['{simplestartdate}'] === $varFields['{simpleenddate}']) {
                    $endDateDisplay = acym_date($element->end_date, get_option('time_format', 'H:i'), false);
                } else {
                    $endDateDisplay = $varFields['{enddate}'];
                }
            }

            $varFields['{date}'] .= ' - '.$endDateDisplay;
        }

        if (in_array('date', $tag->display)) {
            $customFields[] = [
                $varFields['{date}'],
                acym_translation('ACYM_DATE'),
            ];
        }

        $varFields['{location}'] = '';
        if (!empty($properties['_EventVenueID']->value)) {
            $locationData = acym_loadObjectList('SELECT meta_key, meta_value AS `value` FROM #__postmeta WHERE post_id = '.intval($properties['_EventVenueID']->value), 'meta_key');

            if (!empty($locationData)) {
                $locationName = acym_loadResult('SELECT post_title FROM #__posts WHERE ID = '.intval($properties['_EventVenueID']->value));

                $googleMapsSearch = [];
                if (!empty($locationData['_VenueAddress']->value)) $googleMapsSearch[] = $locationData['_VenueAddress']->value;
                if (!empty($locationData['_VenueZip']->value)) $googleMapsSearch[] = $locationData['_VenueZip']->value;
                if (!empty($locationData['_VenueCity']->value)) $googleMapsSearch[] = $locationData['_VenueCity']->value;
                if (!empty($locationData['_VenueCountry']->value)) $googleMapsSearch[] = $locationData['_VenueCountry']->value;

                $gmapQuery = implode(' ', $googleMapsSearch);
                $varFields['{location}'] = '<a href="https://maps.google.com/?q='.urlencode($gmapQuery).'" target="_blank">'.$locationName.'</a>';
            }
            if (in_array('location', $tag->display) && !empty($properties['_EventVenueID']->value)) {
                $customFields[] = [
                    $varFields['{location}'],
                    acym_translation('ACYM_LOCATION'),
                ];
            }
        }

        if (empty($properties['_EventCost']->value)) {
            $varFields['{price}'] = acym_translation('ACYM_FREE');
        } else {
            $price = $properties['_EventCost']->value;
            $symbol = empty($properties['_EventCurrencySymbol']->value) ? '' : $properties['_EventCurrencySymbol']->value;

            if (empty($properties['_EventCurrencyPosition']->value) || $properties['_EventCurrencyPosition']->value === 'suffix') {
                $price .= $symbol;
            } else {
                $price = $symbol.$price;
            }
            $varFields['{price}'] = $price;
        }

        if (in_array('price', $tag->display)) {
            $customFields[] = [
                $varFields['{price}'],
                acym_translation('ACYM_PRICE'),
            ];
        }

        $varFields['{website}'] = empty($properties['_EventURL']->value) ? ''
            : '<a target="_blank" href="'.$properties['_EventURL']->value.'">'.$properties['_EventURL']->value.'</a>';
        if (in_array('website', $tag->display) && !empty($properties['_EventURL']->value)) {
            $customFields[] = [
                $varFields['{website}'],
                // phpcs:ignore WordPress.WP.I18n.TextDomainMismatch
                __('Event Website', 'the-events-calendar'),
            ];
        }

        $varFields['{cats}'] = get_the_term_list($element->ID, 'tribe_events_cat', '', ', ');
        if (in_array('cats', $tag->display) && !empty($varFields['{cats}'])) {
            $customFields[] = [
                $varFields['{cats}'],
                acym_translation('ACYM_CATEGORIES'),
            ];
        }

        $varFields['{tags}'] = get_the_term_list($element->ID, 'post_tag', '', ', ');
        if (in_array('tags', $tag->display) && !empty($varFields['{tags}'])) {
            $customFields[] = [
                $varFields['{tags}'],
                acym_translation('ACYM_TAGS'),
            ];
        }

        $varFields['{readmore}'] = '<a class="acymailing_readmore_link" style="text-decoration:none;" target="_blank" href="'.$varFields['{link}'].'"><span class="acymailing_readmore">';
        $varFields['{readmore}'] .= acym_translation('ACYM_READ_MORE');
        $varFields['{readmore}'] .= '</span></a>';

        if ($tag->readmore === '1') {
            $afterArticle .= $varFields['{readmore}'];
        }

        $format = new stdClass();
        $format->tag = $tag;
        $format->title = $title;
        $format->afterTitle = $afterTitle;
        $format->afterArticle = $afterArticle;
        $format->imagePath = $imagePath;
        $format->description = $contentText;
        $format->link = empty($tag->clickable) && empty($tag->clickableimg) ? '' : $varFields['{link}'];
        $format->customFields = $customFields;
        $result = '<div class="acymailing_content">'.$this->pluginHelper->getStandardDisplay($format).'</div>';

        return $this->finalizeElementFormat($result, $tag, $varFields);
    }
}