<?php

namespace App\Models;

use CodeIgniter\Model;
use Config\Database;

class MasterStok extends Model
{
    protected $DBGroup = 'default';
    protected $table = 'master_stok';
    protected $primaryKey = 'ms_id';
    protected $useAutoIncrement = true;
    protected $insertID = 0;
    protected $returnType = 'object';
    protected $useSoftDeletes = true;
    protected $protectFields = true;
    protected $allowedFields = ['mb_id','ms_stok_bahanbaku','ms_stok_wip','ms_stok_bbwip_transit','ms_stok_wip_transit','ms_stok_fgi_transit','ms_stok_bahanbaku_transit','ms_stok_fgi','ms_stok_waste', 'deleted_at'];

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

    // 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 fieldExist($field_name)
    {
        $db = \Config\Database::connect();
        return $db->fieldExists($field_name, 'master_stok');
    }
    public function get_sum_stok_fgi($mb_id)
    {
        $db = \Config\Database::connect();
        $builder = $db->table('master_stok');
        $builder->select('SUM(ms_stok_fgi) as stok');
        $builder->where('mb_id', $mb_id);
        $builder->where('deleted_at', null);
        return $builder->get()->getFirstRow();
    }
    public function get_sum_stok_bahanbaku($mb_id)
    {
        $db = \Config\Database::connect();
        $builder = $db->table('master_stok');
        $builder->select('SUM(ms_stok_bahanbaku) as stok');
        $builder->where('mb_id', $mb_id);
        $builder->where('deleted_at', null);
        return $builder->get()->getFirstRow();
    }
    public function get_sum_stok_bahanbaku_transit($mb_id)
    {
        $db = \Config\Database::connect();
        $builder = $db->table('master_stok');
        $builder->select('SUM(ms_stok_bahanbaku-ms_stok_bbwip_transit) as stok');
        $builder->where('mb_id', $mb_id);
        $builder->where('deleted_at', null);
        return $builder->get()->getFirstRow();
    }
    public function get_sum_stok_wip_n_transit($mb_id)
    {
        $db = \Config\Database::connect();
        $builder = $db->table('master_stok');
        $builder->select('SUM(ms_stok_wip-ms_stok_wip_transit) as stok');
        $builder->where('mb_id', $mb_id);
        $builder->where('deleted_at', null);
        return $builder->get()->getFirstRow();
    }
    public function get_sum_stok_wip($mb_id)
    {
        $db = \Config\Database::connect();
        $builder = $db->table('master_stok');
        $builder->select('SUM(ms_stok_wip) as stok');
        $builder->where('mb_id', $mb_id);
        $builder->where('deleted_at', null);
        return $builder->get()->getFirstRow();
    }
    public function get_sum_stok_waste($mb_id)
    {
        $db = \Config\Database::connect();
        $builder = $db->table('master_stok');
        $builder->select('SUM(ms_stok_waste) as stok');
        $builder->where('mb_id', $mb_id);
        $builder->where('deleted_at', null);
        return $builder->get()->getFirstRow();
    }
}