<?php
/**
 * @author       Aicha Vack
 * @package      Joomla.Administrator
 * @subpackage   com_visforms
 * @link         https://www.vi-solutions.de
 * @license      GNU General Public License version 2 or later; see license.txt
 * @copyright    2021 vi-solutions
 * @since        Joomla 1.6
 */

namespace Visolutions\Plugin\Content\Vfdataview\Helper;
// No direct access
defined('_JEXEC') or die;

use Joomla\CMS\Factory;
use Joomla\CMS\Plugin\PluginHelper;
// use Visolutions\Component\Visforms\Site\Model\VisformsdataModel; // only necessary if we want to instantiate a Visforms Site Model with new
use Joomla\CMS\Uri\Uri;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Filter\InputFilter;
use Joomla\CMS\User\CurrentUserInterface;
use Joomla\CMS\User\CurrentUserTrait;
use Joomla\Event\DispatcherInterface;
use Visolutions\Component\Visforms\Site\Event\Visforms\VisformsAddWebAssetsEvent;
use Visolutions\Plugin\Content\Vfdataview\Extension\Vfdataview;
use Joomla\CMS\HTML\HTMLHelper;

include_once JPATH_ADMINISTRATOR . '/components/com_visforms/include.php';

class Vfdataviewmodel implements CurrentUserInterface {
    use CurrentUserTrait;
	private $pparams;
	private $form;
	private $fields;
	private $items;
	private $index;
	private $ccontext;
	private $visforms_version;
	public $filterForm;
	public $activeFilters;
	public $context;
	public $state;
	public $showFilter;
	// variables used in local class
	private $hiddenFields;
	private $counterOffest;
	private $rawContext;
	private $mid;
	private $pagination;
	private $total;
	private $canDo;
	private $mvcFactory;
	// variables used in: plugins/content/vfdataview/tmpl/default.php
	private $labelHtmlTag;
	private $valueHtmlTag;
	private $labelClass;
	private $valueClass;
	private $extension;
	private $viewType;
	private $unSortable;
    private $singleRecordPdfTmplDisplay = array();
    private $singleRecordPdfTmplDisplay_list = array();
    private $singleRecordPdfTmplDisplay_detail = array();
    private $pdfTemplates;
    private $hdnParams;

	public function __construct($params, $context, $index, $mvcFactory) {
	    if (is_null($params)) {
            $params = array();
        }
        if (is_null($context)) {
            $context = '';
        }
        if (is_null($index)) {
            $index = 0;
        }
		$this->setParams($params);
		$this->index = $index;
		$this->ccontext = $context;
		$this->mvcFactory = $mvcFactory;
		// make Visforms HTML Helper available (used in view files)
		Factory::getApplication()->bootComponent('com_visforms');
		$this->visforms_version = Vfdataview::checkVisforms();
	}

	public function getHtml() {
		$html = "";
		if (!isset($this->pparams['formid'])) {
			return $html;
		}
		if (!isset($this->pparams['fieldlist']) || ($this->pparams['fieldlist']) == "") {
			return $html;
		}
        $wa = Factory::getApplication()->getDocument()->getWebAssetManager();
		$formid = isset($this->pparams['formid']) ? $this->pparams['formid'] : 0;
        $this->fixInvalidSortFields();
        $this->hdnParams = HTMLHelper::_('visforms.base64_url_encode', \VisformsHelper::registryStringFromArray($this->pparams));
		$context = 'plgvfdataview.' . $this->ccontext . '.' . $formid . '.' . $this->index;
		$this->rawContext = $context;
		// Get an instance of the generic visforms data model: variante a: new Operator
        // $model = new VisformsdataModel(array('context' => $context, 'formid' => $formid, 'pparams' => $this->pparams));
        // variante b: use mvcFactory
        $model = $this->mvcFactory->createModel('Visformsdata', 'Site', ['context' => $context, 'formid' => $formid, 'pparams' => $this->pparams]);
		$model->setId($formid);
		$this->mid = $model->getMenuId();
		$this->form = $model->getForm();
		$allowfedv = (isset($this->form->allowfedv) && $this->form->allowfedv == 1) ? true : false;
		if ($allowfedv == false) {
			return $html;
		}
		// check if user access level allows view
		$user = $this->getCurrentUser();
		$groups = $user->getAuthorisedViewLevels();
		$access = (isset($this->form->frontendaccess) && in_array($this->form->frontendaccess, $groups)) ? true : false;
		if ($access == false) {
			return $html;
		}
		$this->items = $model->getItems();
        $error = $model->getError();
        if (!empty($error)) {
            Factory::getApplication()->enqueueMessage(Text::_('PLG_CONTENT_VFDATAVIEW_INVALID_PLUGIN_STRING') . $error, 'error');
            return '';
        }
		$this->pagination = $model->getPagination();
		$this->showFilter = (isset($this->pparams['show_filter']) && ($this->pparams['show_filter'] == "true"));
		if ($this->showFilter) {
			$this->filterForm = $model->getFilterForm();
			$this->activeFilters = $model->getActiveFilters();
		}
		$this->context = $model->getContext();
		$this->hiddenFields = array_map('trim', explode(",", $this->pparams['hidden_fields']));
		$this->state = $model->getState();
		$this->fields = $model->getDatafields();
		//remove fields, that are not selected by plugin parameters from field list
		$this->getFieldList();
		$this->counterOffest = $model->getStart();
		$this->total = $model->getTotal();
		$this->canDo = \VisformsHelper::getActions($this->form->id);
		$this->pdfTemplates = $model->getPdfTemplates();
        // foreach single record pdf template: provide an array with a list of all items for which the user can download this pdf (so it may be empty)
        if (!empty($this->form->singleRecordPdfTemplate)) {
            foreach ($this->form->singleRecordPdfTemplate as $id) {
                $itemsWithPdf = array();
                $itemsWithPdf_list = array();
                $itemsWithPdf_detail = array();
                if (!empty($this->items)) {
                    $itemsWithPdf = array();
                    foreach ($this->items as $row) {
                        // can create pdf
                        if (($user->authorise('core.create.pdf', 'com_visforms.visform.' . (int) $this->form->id . '.vispdf.' . (int)$id)) ||
                            (($user->authorise('core.create.own.pdf', 'com_visforms.visform.' . (int) $this->form->id . '.vispdf.' . (int)$id)) && ($row->created_by === $user->id))) {
                            if (!empty($this->form->displaypdfexportbutton_list)) {
                                $itemsWithPdf_list[] = $row->id;
                            }
                            if (!empty($this->form->displaypdfexportbutton_detail)) {
                                $itemsWithPdf_detail[] = $row->id;
                            }
                            $itemsWithPdf[] = $row->id;
                        };
                    }
                }
                // code currently only uses singleRecordPdfTmplDisplay_list and singleRecordPdfTmplDisplay_detail
                $this->singleRecordPdfTmplDisplay[$id] = $itemsWithPdf;
                $this->singleRecordPdfTmplDisplay_list[$id] = $itemsWithPdf_list;
                $this->singleRecordPdfTmplDisplay_detail[$id] = $itemsWithPdf_detail;
            }
        }
        // add form specific frontend web assets to data views
        PluginHelper::importPlugin('visforms');
        $visformsAddWebAssetsEvent = new VisformsAddWebAssetsEvent('onVisformsAddWebAssets', [
            'context' => 'com_visforms.form.datas',
            'fid' => $formid
        ]);
        Factory::getContainer()->get(DispatcherInterface::class)->dispatch('onVisformsAddWebAssets', $visformsAddWebAssetsEvent);
        // Include data web assets if plugin an form both allow it
        if (isset($this->pparams['displaydetail']) && $this->pparams['displaydetail'] == 'true' && isset($this->form->displaydetail) && $this->form->displaydetail == 1) {
            $visformsAddWebAssetsEvent = new VisformsAddWebAssetsEvent('onVisformsAddWebAssets', [
                'context' => 'com_visforms.form.data',
                'fid' => $formid
            ]);
            Factory::getContainer()->get(DispatcherInterface::class)->dispatch('onVisformsAddWebAssets', $visformsAddWebAssetsEvent);
        }
		if (isset($this->pparams['layout'])) {
			$path = PluginHelper::getLayoutPath('content', 'vfdataview', $this->pparams['layout']);
		}
		else {
			$path = PluginHelper::getLayoutPath('content', 'vfdataview');
		}
		ob_start();
		include $path;
		$html = ob_get_clean();
		return $html;
	}

    private function fixInvalidSortFields() {
        $db = Factory::getDbo();
        $tn = '#__visforms_' . $this->pparams['formid'];
        try {
            $tableFields = $db->getTableColumns( $tn, false);
            if (!array_key_exists($this->pparams['sortorder'], $tableFields) && !array_key_exists('F' . $this->pparams['sortorder'], $tableFields)) {
                $this->pparams['sortorder'] = 'id';
            }
        }
        catch (\Exception $ex) {
            // nothing to do
        }
    }

	private function setParams($params) {
	    // allowed values 'true' or 'false'
		$defaultsettings = array(
			"showlabel" => "true",
			"show_page_heading" => "true",
			"displayid" => "true",
			"displayip" => "false",
			"displayismfd" => "false",
			"displaycreated" => "false",
			"displaycreatedby" => "false",
			"displaycreatedtime" => "false",
			"show_filter" => 'false',
			"displaydetail" => 'false',
			"displaydetailtitle" => 'false',
			"displaymodifiedat" => "false",
			"displaymodifiedattime" => "false",
            "displaymodifiedby" => "false",
			"displaycounter" => "false",
			"displaypdfexportbutton" => "false",
			"show_filter_created" => "false"
		);
		$defaultsettingsNum = array(
		    "formid" => "0",
            "display_num" => "20",
            "maxtextlength" => "0");
		$defaultsettingsString = array(
            "hidden_fields" => "",
            "fieldorder" => "",
        );
		$defaultsettingsCustom = array(
            "sortorder" => "id",
            "sortdirection" => "asc"
        );
		if (count($params) > 0) {
            // sanitize Plugin parameter
		    foreach ($params as $name => $value) {
		        if (array_key_exists($name, $defaultsettings)) {
		            if (!in_array(strtolower($value), array('true', 'false'))) {
		                unset($params[$name]);
                    }
                }
                else if (array_key_exists($name, $defaultsettingsNum)) {
                    $regex = '/^\d+$/';
                    if (!preg_match($regex, $value)) {
                        unset($params[$name]);
                    }
                }
                else if (array_key_exists($name, $defaultsettingsString)) {
                    $params[$name] = InputFilter::getInstance()->clean($value);
                }
                else if ($name === 'sortdirection') {
                    if (!in_array(strtolower($value), array('asc', 'desc'))) {
                        unset($params[$name]);
                    }
                }
            }
			if (isset($params['fieldselect']) && is_array($params['fieldselect'])) {
			    // fieldselect can either be 'created' or a numeric field id
				foreach ($params['fieldselect'] as $fname => $fselect) {
				    if ($fname === 'created' && $fselect === 'currentdate') {
				        continue;
                    }
				    if (!is_numeric($fname)) {
				        unset($params['fieldselect'][$fname]);
				        continue;
                    }
					$replacedFSelect = $this->replacePlaceholder($fselect);
					$params['fieldselect'][$fname] = $replacedFSelect;
				}
			}
		}
		if (count($params) > 0) {
            $this->pparams = array_merge($defaultsettings, $defaultsettingsNum, $defaultsettingsString, $defaultsettingsCustom, $params);
        }
		else {
			$this->pparams = array_merge($defaultsettings, $defaultsettingsNum, $defaultsettingsString, $defaultsettingsCustom);
		}
	}

	//only use the fields specified in the fieldlist parameter
	private function getFieldList() {
		$fieldlist = array_map('trim', explode(",", $this->pparams['fieldlist']));
		$n = is_array($this->fields) ? count($this->fields) : 0;
		$newFieldList = array();
		for ($i = 0; $i < $n; $i++) {
			if ((in_array($this->fields[$i]->id, $fieldlist)) && (isset($this->fields[$i]->frontdisplay) && ($this->fields[$i]->frontdisplay == 1 || $this->fields[$i]->frontdisplay == 2 || $this->fields[$i]->frontdisplay == 3))) {
				array_push($newFieldList, $this->fields[$i]);
			}
		}
		$this->fields = $newFieldList;
	}

	private function replacePlaceholder($placeholder = null) {
		if (isset($placeholder)) {
			$user = Factory::getApplication()->getIdentity();
			$userId = $user->get('id');
			switch ($placeholder) {
				case "[_url]" :
					$url = Uri::getInstance()->__toString();
					$placeholder = $url;
					break;
				case "[_name]":
					if ($userId != 0) {
						$placeholder = $user->get('name');
					}
					break;
				case "[_username]":
					if ($userId != 0) {
						$placeholder = $user->get('username');
					}
					break;
				case "[_email]":
					if ($userId != 0) {
						$placeholder = $user->get('email');
					}
					break;
				default;
				$placeholder = InputFilter::getInstance()->clean($placeholder);
					break;
			}
		}
		return $placeholder;
	}
}