PriorityModelAbstract.php

<?php
/**
 * Copyright Maarch since 2008 under licence GPLv3.
 * See LICENCE.txt file at the root folder for more details.
 * This file is part of Maarch software.
 *
 */

/**
 * @brief Priority Abstract Model
 * @author dev@maarch.org
 */

namespace Priority\models;

use SrcCore\models\ValidatorModel;
use SrcCore\models\DatabaseModel;

abstract class PriorityModelAbstract
{
    public static function get(array $aArgs = [])
    {
        ValidatorModel::arrayType($aArgs, ['select']);

        $aReturn = DatabaseModel::select([
            'select'    => empty($aArgs['select']) ? ['*'] : $aArgs['select'],
            'table'     => ['priorities'],
        ]);

        return $aReturn;
    }

    public static function getById(array $aArgs)
    {
        ValidatorModel::notEmpty($aArgs, ['id']);
        ValidatorModel::stringType($aArgs, ['id']);
        ValidatorModel::arrayType($aArgs, ['select']);

        $aPriority = DatabaseModel::select([
            'select'    => empty($aArgs['select']) ? ['*'] : $aArgs['select'],
            'table'     => ['priorities'],
            'where'     => ['id = ?'],
            'data'      => [$aArgs['id']]
        ]);

        if (empty($aPriority[0])) {
            return [];
        }

        return $aPriority[0];
    }

    public static function create(array $aArgs)
    {
        ValidatorModel::notEmpty($aArgs, ['label', 'color', 'working_days', 'default_priority']);
        ValidatorModel::stringType($aArgs, ['label', 'color', 'working_days', 'default_priority']);
        ValidatorModel::intVal($aArgs, ['delays']);

        //working_days => true (monday to friday) => false (monday to sunday)
        $id = DatabaseModel::uniqueId();
        DatabaseModel::insert([
            'table'         => 'priorities',
            'columnsValues' => [
                'id'                => $id,
                'label'             => $aArgs['label'],
                'color'             => $aArgs['color'],
                'working_days'      => $aArgs['working_days'],
                'delays'            => $aArgs['delays'],
                'default_priority'  => $aArgs['default_priority'],
            ]
        ]);

        return $id;
    }

    public static function update(array $aArgs)
    {
        ValidatorModel::notEmpty($aArgs, ['id', 'label', 'color', 'working_days', 'default_priority']);
        ValidatorModel::stringType($aArgs, ['id', 'label', 'color', 'working_days', 'default_priority']);
        ValidatorModel::intVal($aArgs, ['delays']);

        //working_days => true (monday to friday) => false (monday to sunday)
        DatabaseModel::update([
            'table'     => 'priorities',
            'set'       => [
                'label'             => $aArgs['label'],
                'color'             => $aArgs['color'],
                'working_days'      => $aArgs['working_days'],
                'delays'            => $aArgs['delays'],
                'default_priority'  => $aArgs['default_priority']
            ],
            'where'     => ['id = ?'],
            'data'      => [$aArgs['id']]
        ]);

        return true;
    }

    public static function resetDefaultPriority()
    {
        DatabaseModel::update([
            'table'     => 'priorities',
            'set'       => [
                'default_priority'  => 'false'
            ],
            'where'     => ['default_priority = ?'],
            'data'      => ['true']
        ]);

        return true;
    }

    public static function delete(array $aArgs)
    {
        ValidatorModel::notEmpty($aArgs, ['id']);
        ValidatorModel::stringType($aArgs, ['id']);

        DatabaseModel::delete([
            'table' => 'priorities',
            'where' => ['id = ?'],
            'data'  => [$aArgs['id']]
        ]);
        
        return true;
    }   
    
}