<?php

namespace App\Models;

use CodeIgniter\Model;

class TahunajaranModel extends Model
{
   protected $DBGroup              = 'default';
   protected $table                = 'tahun_ajaran';
   protected $primaryKey           = 'id';
   protected $useAutoIncrement     = true;
   protected $insertID             = 0;
   protected $returnType           = 'array';
   protected $useSoftDeletes       = false;
   protected $protectFields        = false;
   protected $allowedFields        = [];

   // Dates
   protected $useTimestamps        = true;
   protected $dateFormat           = 'datetime';
   protected $createdField         = 'created_at';
   protected $updatedField         = 'updated_at';
   protected $deletedField         = '';

   // Validation
   protected $validationRules      = [];
   protected $validationMessages   = [];
   protected $skipValidation       = false;
   protected $cleanValidationRules = true;

   // Callbacks
   protected $allowCallbacks       = true;
   protected $beforeInsert         = [];
   protected $afterInsert          = [];
   protected $beforeUpdate         = [];
   protected $afterUpdate          = [];
   protected $beforeFind           = [];
   protected $afterFind            = [];
   protected $beforeDelete         = [];
   protected $afterDelete          = [];

   public function activeStatus($data, $id)
   {
      $db      = \Config\Database::connect();
      $builder = $db->table('tahun_ajaran');
      $builder->set('status', 1);
      $builder->where('id', $id);
      $builder->update($data);
   }

   public function resetStatus()
   {
      $this->db->table('tahun_ajaran')->update(['status' => null]);
   }
}
