<?php

namespace App\Models;

use CodeIgniter\Model;
use Config\Database;
use Config\Services;

class ReportPengeluaranhasilproduksi extends Model
{
    protected $DBGroup = 'default';
    protected $table = '';
    protected $primaryKey = '';
    protected $useAutoIncrement = true;
    protected $insertID = 0;
    protected $returnType = 'object';
    protected $useSoftDeletes = true;
    protected $protectFields = true;
    protected $allowedFields = [];

    // 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 static function get_report_store($start, $end)
    {
        if ($start == NULL && $end == NULL) {
            $start = date('Y-m-01');
            $end = date('Y-m-t');
        }
        $session = Services::session();
        $db = Database::connect();
        $builder = $db->table('transaksi_kirimbarang_fgi_ic');
        $builder->select('*');
        $builder->where('tkb_fgiic_status', 1);
        $builder->where('tkb_fgiic_status_mkt', 1);
        $builder->where('tkb_fgiic_status_sc', 1);
        $builder->where('date(created_at) >=', $start);
        $builder->where('date(created_at) <=', $end);

        return $builder->get()->getResult();
    }

}