OwlCyberSecurity - MANAGER

Edit File: EventsModel.php

<?php

namespace WP_Statistics\Models;

use WP_Statistics\Abstracts\BaseModel;
use WP_STATISTICS\Admin_Template;
use WP_Statistics\Components\DateTime;
use WP_Statistics\Utils\Query;

class EventsModel extends BaseModel
{
    public function countEvents($args = [])
    {
        $args = $this->parseArgs($args, [
            'event_name'    => '',
            'event_target'  => '',
            'author_id'     => '',
            'post_type'     => '',
            'post_id'       => '',
            'date'          => '',
            'group_by'      => '',
            'field'         => '',
            'not_null'      => ''
        ]);

$field = !empty($args['field']) ? $args['field'] : '*';

$query = Query::select("COUNT($field)")
            ->from('events')
            ->where('event_name', 'IN', $args['event_name'])
            ->where('events.page_id', '=', $args['post_id'])
            ->whereJson('event_data', 'target_url', '=', $args['event_target'])
            ->whereDate('events.date', $args['date'])
            ->groupBy($args['group_by']);

if (!empty($args['author_id']) || !empty($args['post_type'])) {
            $query
                ->join('posts', ['events.page_id', 'posts.ID'])
                ->where('posts.post_type', 'IN', $args['post_type'])
                ->where('posts.post_author', '=', $args['author_id']);
        }

$result = $query->getVar();

return $result ?? 0;
    }

public function getInitialEventDate($args = [])
    {
        $args = $this->parseArgs($args, [
            'event_name' => ''
        ]);

$result = Query::select('MIN(events.date) as date')
            ->from('events')
            ->where('event_name', '=', $args['event_name'])
            ->allowCaching()
            ->getVar();

return $result;
    }

public function getEvents($args = [])
    {
        $args = $this->parseArgs($args, [
            'fields'        => '*',
            'page'          => 1,
            'per_page'      => Admin_Template::$item_per_page,
            'event_name'    => '',
            'event_target'  => '',
            'author_id'     => '',
            'post_type'     => '',
            'post_id'       => '',
            'date'          => '',
            'decorator'     => '',
            'order'         => 'date',
            'order_by'      => 'DESC',
        ]);

$query = Query::select($args['fields'])
            ->from('events')
            ->where('event_name', 'IN', $args['event_name'])
            ->where('events.page_id', '=', $args['post_id'])
            ->whereJson('event_data', 'target_url', '=', $args['event_target'])
            ->whereDate('events.date', $args['date'])
            ->orderBy($args['order'], $args['order_by'])
            ->perPage($args['page'], $args['per_page'])
            ->decorate($args['decorator']);

if (!empty($args['author_id']) || !empty($args['post_type']) || !empty($args['post_id'])) {
            $query
                ->join('posts', ['events.page_id', 'posts.ID'])
                ->where('posts.post_type', '=', $args['post_type'])
                ->where('posts.post_author', '=', $args['author_id']);
        }

return $query->getAll();
    }

public function countDailyEvents($args = [])
    {
        $args = $this->parseArgs($args, [
            'event_name'    => '',
            'event_target'  => '',
            'author_id'     => '',
            'post_type'     => '',
            'post_id'       => '',
            'date'          => '',
            'decorator'     => '',
            'order'         => 'date',
            'order_by'      => 'DESC',
        ]);

$query = Query::select('COUNT(events.ID) as count, DATE(events.date) as date')
            ->from('events')
            ->where('event_name', 'IN', $args['event_name'])
            ->where('events.page_id', '=', $args['post_id'])
            ->whereJson('event_data', 'target_url', '=', $args['event_target'])
            ->whereDate('events.date', $args['date'])
            ->orderBy($args['order'], $args['order_by'])
            ->groupBy('Date(events.date)')
            ->decorate($args['decorator']);

return $query->getAll();
    }

public function countEventsByPage($args = [])
    {
        $args = $this->parseArgs($args, [
            'event_name'    => '',
            'event_target'  => '',
            'author_id'     => '',
            'post_type'     => '',
            'post_id'       => '',
            'date'          => '',
            'decorator'     => '',
            'per_page'      => '',
            'page'          => 1,
            'order'         => 'count',
            'order_by'      => 'DESC',
        ]);

$query = Query::select('COUNT(events.ID) as count, events.page_id, events.event_data')
            ->from('events')
            ->where('event_name', 'IN', $args['event_name'])
            ->where('events.page_id', '=', $args['post_id'])
            ->whereJson('event_data', 'target_url', '=', $args['event_target'])
            ->whereDate('events.date', $args['date'])
            ->orderBy($args['order'], $args['order_by'])
            ->groupBy('events.page_id')
            ->decorate($args['decorator'])
            ->whereNotNull('events.page_id')
            ->perPage($args['page'], $args['per_page']);

return $query->getAll();
    }

public function countEventVisitorsByPage($args = [])
    {
        $args = $this->parseArgs($args, [
            'event_name'    => '',
            'author_id'     => '',
            'post_type'     => '',
            'post_id'       => '',
            'date'          => '',
            'per_page'      => 10,
            'page'          => 1,
            'order'         => 'visitors',
            'order_by'      => 'DESC',
        ]);

$query = Query::select('COUNT(DISTINCT events.visitor_id) as visitors, events.page_id as post_id, posts.post_title as title')
            ->from('events')
            ->join('posts', ['events.page_id', 'posts.ID'])
            ->where('events.page_id', '=', $args['post_id'])
            ->where('posts.post_type', '=', $args['post_type'])
            ->where('posts.post_author', '=', $args['author_id'])
            ->where('event_name', 'IN', $args['event_name'])
            ->whereDate('events.date', $args['date'])
            ->orderBy($args['order'], $args['order_by'])
            ->groupBy('events.page_id')
            ->whereNotNull('events.page_id')
            ->perPage($args['page'], $args['per_page']);

return $query->getAll();
    }

public function getTopEvents($args = [])
    {
        $args = $this->parseArgs($args, [
            'date'      => '',
            'post_id'   => '',
            'post_type' => '',
            'author_id' => '',
            'page'      => 1,
            'per_page'  => Admin_Template::$item_per_page,
            'event_name'=> '',
            'decorator' => ''
        ]);

$query = Query::select([
                "JSON_UNQUOTE(JSON_EXTRACT(`event_data`, '$.target_url')) AS target_url",
                "event_data",
                "COUNT(*) AS count"
            ])
            ->from('events')
            ->where('event_name', 'IN', $args['event_name'])
            ->where('events.page_id', '=', $args['post_id'])
            ->whereDate('events.date', $args['date'])
            ->orderBy('count', 'DESC')
            ->perPage($args['page'], $args['per_page'])
            ->groupBy('target_url')
            ->decorate($args['decorator']);

return $query->getAll();
    }

public function countTopEvents($args = [])
    {
        $args = $this->parseArgs($args, [
            'event_name'    => '',
            'author_id'     => '',
            'post_type'     => '',
            'post_id'       => '',
            'date'          => '',
        ]);

$subQuery = Query::select("JSON_UNQUOTE(JSON_EXTRACT(`event_data`, '$.target_url')) AS url")
            ->from('events')
            ->where('event_name', 'IN', $args['event_name'])
            ->where('events.page_id', '=', $args['post_id'])
            ->whereDate('events.date', $args['date'])
            ->groupBy('url');

if (!empty($args['author_id']) || !empty($args['post_type']) || !empty($args['post_id'])) {
            $subQuery
                ->join('posts', ['events.page_id', 'posts.ID'])
                ->where('posts.post_type', '=', $args['post_type'])
                ->where('posts.post_author', '=', $args['author_id']);
        }

$result = Query::select('COUNT(url)')
            ->fromQuery($subQuery->getQuery())
            ->getVar();

return $result;
    }

public function insertEvent($args)
    {
        $data = [
            'date'       => DateTime::get('now', 'Y-m-d H:i:s'),
            'page_id'    => $args['page_id'],
            'visitor_id' => $args['visitor_id'],
            'user_id'    => $args['user_id'] ?? null,
            'event_name' => $args['event_name'],
            'event_data' => json_encode($args['event_data'])
        ];

$result = Query::insert('events')
            ->set($data)
            ->execute();

return $result;
    }

public function deleteEvents($args)
    {
        $args = $this->parseArgs($args, [
            'event_name' => ''
        ]);

$result = Query::delete('events')
            ->where('event_name', '=', $args['event_name'])
            ->execute();

return $result;
    }
}