<?php

namespace App\User;

use Qs_ConfigStaticTrait;
use Qs_Db;
use Qs_Db_Table;
use Zend_Db_Expr;

class Model
{
    use Qs_ConfigStaticTrait;

    public static function getFullNameDbExpr($alias = 'User')
    {
        return new Zend_Db_Expr("CONCAT_WS(' ', `{$alias}`.`firstName`, `{$alias}`.`middleName`, `{$alias}`.`lastName`)");
    }

    public static function getFullestNameDbExpr()
    {
        return new Zend_Db_Expr(
            'CONCAT_WS(", ", '
            . 'CONCAT_WS(" ", `User`.`prefix`, `User`.`firstName`, `User`.`middleName`, `User`.`lastName`)'
            . ', `User`.`suffix`, `User`.`credentials`)'
        );
    }

    public static function getFullNameWithPositionDbExpr()
    {
        $leadershipPosition = 'IF(leadershipPosition != "", CONCAT(" (", leadershipPosition, ") "), "")';
        return new Zend_Db_Expr('CONCAT(firstName, " ", lastName, ' . $leadershipPosition . ')');
    }

    public static function getMembershipExpiredExpr($alias = null)
    {
        $prefix = empty($alias) ? '' : "`{$alias}`.";
        return new Zend_Db_Expr("IF({$prefix}`expiredOn` IS NULL OR {$prefix}`expiredOn` >= CURDATE(), 'n', 'y')");
    }

    public static function getMembershipGracePeriodExpiredExpr()
    {
        $days = self::getConfig('membershipGracePeriod', 14);
        return new Zend_Db_Expr(
            "IF(`expiredOn` IS NULL OR DATE_ADD(`expiredOn`, INTERVAL {$days} DAY) >= CURDATE(), 'n', 'y')"
        );
    }

    public static function unreadMessagesCountExpr()
    {
        $select = Qs_Db::getSelect();
        $select->from(Qs_Db::getPair('UserWebMail', 'uwm'), 'COUNT(*)');
        $select->where('`uwm`.`toUserId` = `User`.`id`');
        $select->where('`uwm`.`read` = "n"');
        return new Zend_Db_Expr('(' . $select . ')');
    }

    public static function likeToReceivePm($userId)
    {
        $user = (new Qs_Db_Table('User'))->searchBy([
            'id'        => $userId,
            'status'    => Entity::STATUS_ACTIVE,
            'pmEnabled' => 'y',
        ]);
        return !empty($user);
    }
}