ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / laindinois / wp-content / plugins / wiloke-listing-tools / app / Models

<?php
namespace WilokeListingTools\Models;

use WilokeListingTools\AlterTable\AlterTableEventsData;
use WilokeListingTools\Framework\Helpers\GetSettings;
use WilokeListingTools\Framework\Helpers\Time;

class EventModel
{
    public static $aCache = [];
    
    public static function getEventDate($postID)
    {
        if (isset(self::$aCache['event_date_'.$postID])) {
            return self::$aCache['event_date_'.$postID];
        }
        
        $aEventDate = self::getEventData($postID);
        if (empty($aEventDate) || empty($aEventDate['startsOn']) || empty($aEventDate['endsOn'])) {
            return false;
        }
        
        $dateFormat        = get_option('date_format');
        $timeFormat        = get_option('time_format');
        $startsOnTimestamp = strtotime($aEventDate['startsOn']);
        $endsOnTimestamp   = strtotime($aEventDate['endsOn']);
        
        self::$aCache['event_date_'.$postID] = [
            'startsOn'       => date_i18n($dateFormat, $startsOnTimestamp),
            'openAt'         => date_i18n($timeFormat, $startsOnTimestamp),
            'endsOn'         => date_i18n($dateFormat, $endsOnTimestamp),
            'closedAt'       => date_i18n($timeFormat, $endsOnTimestamp),
            'start'          => date_i18n($dateFormat.' '.$timeFormat, $startsOnTimestamp),
            'end'            => date_i18n($dateFormat.' '.$timeFormat, $endsOnTimestamp),
            'startTimestamp' => $startsOnTimestamp,
            'endTimestamp'   => $endsOnTimestamp
        ];
        
        return self::$aCache['event_date_'.$postID];
    }
    
    public static function countUnpaidEvents($authorID)
    {
        global $wpdb;
        $eventTbl = $wpdb->prefix.AlterTableEventsData::$tblName;
        $postTbl  = $wpdb->posts;
        
        $sql =
            "SELECT COUNT($postTbl.ID) FROM $postTbl LEFT JOIN $eventTbl ON ($eventTbl.objectID = $postTbl.ID) WHERE $postTbl.post_status='unpaid' AND $postTbl.post_author=%d AND $postTbl.post_type='event'";
        
        $count = $wpdb->get_var($wpdb->prepare(
            $sql,
            $authorID
        ));
        
        return empty($count) ? 0 : abs($count);
    }
    
    public static function countUpcomingEventsOfAuthor($authorID)
    {
        global $wpdb;
        $eventTbl = $wpdb->prefix.AlterTableEventsData::$tblName;
        $postTbl  = $wpdb->posts;
        $now      = Time::mysqlDateTime(current_time('timestamp', true));
        
        $sql =
            "SELECT COUNT($postTbl.ID) FROM $postTbl LEFT JOIN $eventTbl ON ($eventTbl.objectID = $postTbl.ID) WHERE $postTbl.post_status='publish' AND $postTbl.post_author=%d AND $postTbl.post_type='event' AND $eventTbl.startsOnUTC > '".
            $now."'";
        
        $count = $wpdb->get_var($wpdb->prepare(
            $sql,
            $authorID
        ));
        
        return empty($count) ? 0 : abs($count);
    }
    
    public static function countOnGoingEventsOfAuthor($authorID)
    {
        global $wpdb;
        $eventTbl = $wpdb->prefix.AlterTableEventsData::$tblName;
        $postTbl  = $wpdb->posts;
        $now      = Time::mysqlDateTime(current_time('timestamp', true));
        
        $sql =
            "SELECT COUNT($postTbl.ID) FROM $postTbl LEFT JOIN $eventTbl ON ($eventTbl.objectID = $postTbl.ID) WHERE $postTbl.post_status='publish' AND $postTbl.post_author=%d AND $postTbl.post_type='event' AND $eventTbl.startsOnUTC <= '".
            $now."' AND $eventTbl.endsOnUTC >= '".$now."' AND $postTbl.post_status ='publish'";
        
        $count = $wpdb->get_var($wpdb->prepare(
            $sql,
            $authorID
        ));
        
        return empty($count) ? 0 : abs($count);
    }
    
    public static function countExpiredEventsOfAuthor($authorID)
    {
        global $wpdb;
        $eventTbl = $wpdb->prefix.AlterTableEventsData::$tblName;
        $postTbl  = $wpdb->posts;
        $now      = Time::mysqlDateTime(current_time('timestamp', true));
        
        $sql =
            "SELECT COUNT($postTbl.ID) FROM $postTbl LEFT JOIN $eventTbl ON ($eventTbl.objectID = $postTbl.ID) WHERE $postTbl.post_author=%d AND $postTbl.post_type='event' AND ($eventTbl.endsOnUTC <= '".
            $now.
            "' OR $eventTbl.endsOnUTC <= $eventTbl.startsOnUTC || $eventTbl.startsOnUTC IS NULL) AND ($postTbl.post_status ='publish' || $postTbl.post_status ='expired')";
        
        $count = $wpdb->get_var($wpdb->prepare(
            $sql,
            $authorID
        ));
        
        return empty($count) ? 0 : abs($count);
    }
    
    /*
     * $objectID int required
     * $aData array: type, startsGMT, endsOn, openingAt, closedAt, timezone, lat, lng, googleAddress
     * $parentID int It's listing ID
     */
    public static function setEventData($aRawData)
    {
        global $wpdb;
        $tblName = $wpdb->prefix.AlterTableEventsData::$tblName;
        
        $aKeys     = [
            'objectID',
            'parentID',
            'frequency',
            'specifyDays',
            'startsOn',
            'endsOn',
            'startsOnUTC',
            'endsOnUTC',
            'timezone'
        ];
        $aPrepares = ['%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s'];
        
        $aData = [];
        foreach ($aKeys as $key) {
            $aData[$key] = isset($aRawData['values'][$key]) ? sanitize_text_field($aRawData['values'][$key]) : '';
        }
        
        $status = $wpdb->insert(
            $tblName,
            $aData,
            $aPrepares
        );
        
        if (!$status) {
            return false;
        }
        
        return $wpdb->insert_id;
    }
    
    public static function isEventDataExists($objectID)
    {
        global $wpdb;
        $tblName = $wpdb->prefix.AlterTableEventsData::$tblName;
        
        return $wpdb->get_var(
            $wpdb->prepare(
                "SELECT ID FROM $tblName WHERE objectID=%d",
                $objectID
            )
        );
    }
    
    public static function updateEventData($objectID, $aUpdates)
    {
        global $wpdb;
        $tblName = $wpdb->prefix.AlterTableEventsData::$tblName;
        if (isset($aUpdates['values']['specifyDays'])) {
            $aDays = $aUpdates['values']['specifyDays'];
            unset($aUpdates['values']['specifyDays']);
            $aUpdates['values']['specifyDays'] = is_array($aDays) ? implode(',', $aDays) : $aDays;
        } else {
            $aUpdates['values']['specifyDays'] = 'always';
            $aUpdates['prepares'][]            = '%s';
        }
        
        foreach ($aUpdates['values'] as $key => $val) {
            $aUpdates['values'][$key] = sanitize_text_field($val);
        }
        
        $timeFormat = Time::getTimeFormat();
        $dateFormat = get_option('date_format');
        $dateFormat = Time::convertJSDateFormatToPHPDateFormat($dateFormat);
        
        if (!empty($aUpdates['values']['openingAt'])) {
            $dateFormat = $dateFormat.' '.Time::getTimeFormat();
            $openingAt  = strtotime($aUpdates['values']['openingAt']);
            $startsOn   = $aUpdates['values']['starts'].' '.date($timeFormat, $openingAt);
            $startsOn   = Time::toTimestamp($dateFormat, $startsOn);
        } else {
            $startsOn = Time::toTimestamp($dateFormat, $aUpdates['values']['starts']);
        }
        
        if (!isset($aUpdates['values']['timezone']) || empty($aUpdates['values']['timezone'])) {
            $aUpdates['values']['timezone'] = get_option('timezone_string');
        }
        
        if (!empty($aUpdates['values']['closedAt'])) {
            $closedAt = strtotime($aUpdates['values']['closedAt']);
            $endsOn   = $aUpdates['values']['endsOn'].' '.date($timeFormat, $closedAt);
            $endsOn   = Time::toTimestamp($dateFormat, $endsOn);
        } else {
            $endsOn = Time::toTimestamp($dateFormat, $aUpdates['values']['endsOn']);
        }
        
        $startsOn = Time::mysqlDateTime($startsOn, "UTC");
        $endsOn   = Time::mysqlDateTime($endsOn, "UTC");
        
        $startsOnUTC = Time::convertToNewDateFormat(strtotime($startsOn), 'Y-m-d H:i:s', 'UTC');
        $endsOnUTC   = Time::convertToNewDateFormat(strtotime($endsOn), 'Y-m-d H:i:s', 'UTC');
        
        $aUpdates['values']['startsOn']    = $startsOn;
        $aUpdates['values']['endsOn']      = $endsOn;
        $aUpdates['values']['startsOnUTC'] = $startsOnUTC;
        $aUpdates['values']['endsOnUTC']   = $endsOnUTC;
        $aUpdates['prepares'][]            = '%s';
        $aUpdates['prepares'][]            = '%s';
        $aUpdates['prepares'][]            = '%s';
        $aUpdates['prepares'][]            = '%s';
      
        if ($ID = self::isEventDataExists($objectID)) {
            $wpdb->update(
                $tblName,
                [
                    'frequency'   => $aUpdates['values']['frequency'],
                    'specifyDays' => $aUpdates['values']['specifyDays'],
                    'startsOn'    => $aUpdates['values']['startsOn'],
                    'endsOn'      => $aUpdates['values']['endsOn'],
                    'startsOnUTC' => $aUpdates['values']['startsOnUTC'],
                    'endsOnUTC'   => $aUpdates['values']['endsOnUTC'],
                    'timezone'    => $aUpdates['values']['timezone']
                ],
                [
                    'ID' => abs($ID)
                ],
                [
                    '%s',
                    '%s',
                    '%s',
                    '%s',
                    '%s',
                    '%s',
                    '%s'
                ],
                [
                    '%d'
                ]
            );
            $status = true;
            do_action('wilcity/wiloke-listing-tools/updated-event-data', $objectID, $aUpdates, $ID);
        } else {
            $aUpdates['objectID'] = $ID;
            if (!isset($aUpdates['parentID'])) {
                $aUpdates['parentID'] = '';
            }
            $status = self::setEventData($aUpdates);
            if (empty($status)) {
                return false;
            }
            
            $eventID = $wpdb->insert_id;
            do_action('wilcity/wiloke-listing-tools/inserted-event-data', $objectID, $aUpdates, $eventID);
            
            return $eventID;
        }
        
        return $status;
    }
    
    public static function getField($fieldName, $eventID)
    {
        if (isset(self::$aCache[$fieldName.$eventID])) {
            return self::$aCache[$fieldName.$eventID];
        }
        
        global $wpdb;
        $tblName = $wpdb->prefix.AlterTableEventsData::$tblName;
        
        self::$aCache[$fieldName.$eventID] = $wpdb->get_var(
            $wpdb->prepare(
                "SELECT $fieldName FROM $tblName WHERE objectID=%d",
                $eventID
            )
        );
        
        return self::$aCache[$fieldName.$eventID];
    }
    
    public static function getEventData($postID)
    {
        if (isset(self::$aCache['eventData_'.$postID])) {
            return self::$aCache['eventData_'.$postID];
        }
        
        global $wpdb;
        $tblName = $wpdb->prefix.AlterTableEventsData::$tblName;
        $aData   = $wpdb->get_row(
            $wpdb->prepare(
                "SELECT * FROM $tblName WHERE objectID=%d",
                $postID
            ),
            ARRAY_A
        );
        
        $aData = empty($aData) ? [] : $aData;
        
        $video = GetSettings::getPostMeta($postID, 'video');
        if (empty($video) && empty($aData)) {
            return false;
        } else {
            $aData          = empty($aData) ? [] : $aData;
            $aData['video'] = $video;
        }
        
        self::$aCache['eventData_'.$postID] = $aData;
        
        return $aData;
    }
}

[+] ..
[-] InvoiceMetaModel.php [edit]
[-] PaymentMetaModel.php [edit]
[-] ViewStatistic.php [edit]
[-] WooCommerceModel.php [edit]
[-] FavoriteStatistic.php [edit]
[-] ReviewMetaModel.php [edit]
[-] MessageModel.php [edit]
[-] PlanRelationshipModel.php [edit]
[-] ReviewModel.php [edit]
[-] NotificationsModel.php [edit]
[-] AbstractUserPlan.php [edit]
[-] Coupon.php [edit]
[-] PostModel.php [edit]
[-] BookingCom.php [edit]
[-] ListingModel.php [edit]
[-] BusinessHourMeta.php [edit]
[-] PromotionModel.php [edit]
[-] SharesStatistic.php [edit]
[-] ReportModel.php [edit]
[-] InvoiceModel.php [edit]
[-] RemainingItems.php [edit]
[-] PaymentModel.php [edit]
[-] PayPalMetaModel.php [edit]
[-] PostMetaModel.php [edit]
[-] FollowerModel.php [edit]
[-] UserModel.php [edit]
[-] EventModel.php [edit]