<?php

namespace FluentForm\App\Api;

use FluentForm\App\Helpers\Helper;
use FluentForm\Framework\Helpers\ArrayHelper;

class Form
{
    public function forms($atts = [], $withFields = false)
    {
        $defaultAtts = [
            'search' => '',
            'status' => 'all',
            'sort_column' => 'id',
	        'filter_by' => 'all',
	        'date_range' => [],
            'sort_by' => 'DESC',
            'per_page' => 10,
            'page' => 1
        ];

        $atts = wp_parse_args($atts, $defaultAtts);

        $perPage = ArrayHelper::get($atts, 'per_page', 10);
        $search = ArrayHelper::get($atts, 'search', '');
        $status = ArrayHelper::get($atts, 'status', 'all');
        $filter_by = ArrayHelper::get($atts, 'filter_by', 'all');
	    $dateRange = ArrayHelper::get($atts, 'date_range', []);
		$is_filter_by_conv_or_step_form = $filter_by && ($filter_by == 'conv_form' || $filter_by == 'step_form');

        $shortColumn = ArrayHelper::get($atts, 'sort_column', 'id');
        $sortBy = ArrayHelper::get($atts, 'sort_by', 'DESC');

        $query = wpFluent()->table('fluentform_forms')
            ->orderBy($shortColumn, $sortBy);

        if ($status && $status != 'all') {
            $query->where('status', $status);
        }

		if ($filter_by && !$is_filter_by_conv_or_step_form) {
			switch ($filter_by) {
				case 'published':
					$query->where('status', 'published');
					break;
				case 'unpublished':
					$query->where('status', 'unpublished');
					break;
				case 'post':
					$query->where('type', 'post');
					break;
				case 'is_payment':
					$query->where('has_payment', 1);
					break;
				default:
					break;
			}
		}

	    if ($dateRange) {
		    $query->where('created_at', '>=', $dateRange[0] . ' 00:00:01');
		    $query->where('created_at', '<=', $dateRange[1] . ' 23:59:59');
	    }

        if ($search) {
            $query->where(function ($q) use ($search) {
                $q->where('id', 'LIKE', '%' . $search . '%');
                $q->orWhere('title', 'LIKE', '%' . $search . '%');
            });
        }

        $currentPage = intval(ArrayHelper::get($atts, 'page', 1));
        $total = $query->count();
        $skip = $perPage * ($currentPage - 1);

		if ($is_filter_by_conv_or_step_form) {
			$data = (array) $query->select('*')->get();
		} else {
			$data = (array) $query->select('*')->limit($perPage)->offset($skip)->get();
		}

	    $conversationOrStepForms = [];
        foreach ($data as $form) {
			$is_conv_form = Helper::isConversionForm($form->id);

            //  skip form if filter by conversation form but form is not conversational form
            if ($filter_by == 'conv_form' && !$is_conv_form) {
				continue;
			}
            //  skip form if filter by step form but form is not step form
            if ($filter_by == 'step_form' && !Helper::isMultiStepForm($form->id)) {
				continue;
			}
            $formInstance = $this->form($form);
            $form->preview_url = Helper::getPreviewUrl($form->id, 'classic');
            $form->edit_url = Helper::getFormAdminPermalink('editor', $form);
            $form->settings_url = Helper::getFormSettingsUrl($form);
            $form->entries_url = Helper::getFormAdminPermalink('entries', $form);
            $form->analytics_url = Helper::getFormAdminPermalink('analytics', $form);
            $form->total_views = Helper::getFormMeta($form->id, '_total_views', 0);
            $form->total_Submissions = $formInstance->submissionCount();
            $form->unread_count = $formInstance->unreadCount();
            $form->conversion = $formInstance->conversionRate();
            if ($is_conv_form) {
                $form->conversion_preview = Helper::getPreviewUrl($form->id, 'conversational');
            }

            if(!$withFields) {
                unset($form->form_fields);
            }
            if ($is_filter_by_conv_or_step_form) {
                $conversationOrStepForms[] = $form;
            }
        }
	    if ($is_filter_by_conv_or_step_form) {
		    $total = count($conversationOrStepForms);
		    $conversationOrStepForms = array_slice($conversationOrStepForms, $skip, $perPage);
		    $dataCount = count($conversationOrStepForms);
	    } else {
		    $dataCount = count($data);
	    }

	    $from = $dataCount > 0 ? ($currentPage - 1) * $perPage + 1 : null;

	    $to = $dataCount > 0 ? $from + $dataCount - 1 : null;
	    $lastPage = (int) ceil($total / $perPage);
        return array(
		    'current_page'  => $currentPage,
		    'per_page'      => $perPage,
		    'from'          => $from,
		    'to'            => $to,
		    'last_page'     => $lastPage,
		    'total'         => $total,
		    'data'          => $is_filter_by_conv_or_step_form ? $conversationOrStepForms : $data,
	    );
    }

    public function find($formId)
    {
        return wpFluent()->table('fluentform_forms')->where('id', $formId)->first();
    }

    /**
     * get Form Properties instance
     * @param int|object $form
     * @return \FluentForm\App\Api\FormProperties
     */
    public function form($form)
    {
        if(is_numeric($form)) {
            $form = $this->find($form);
        }

        return (new FormProperties($form));
    }

    public function entryInstance($form)
    {
        if(is_numeric($form)) {
            $form = $this->find($form);
        }

        return (new Entry($form));
    }

}