<?php namespace App\Http\Controllers;

use App\Models\Realbiayalkp;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Validator, Input, Redirect;

class RealbiayalkpController extends Controller
{
    protected $layout = "layouts.main";
    protected $data = array();	
    public $module = 'realbiayalkp';
    static $per_page = '50';

    public function __construct()
    {
        parent::__construct();
        $this->model = new Realbiayalkp();
        $this->info = $this->model->makeInfo($this->module);
        $this->access = array();

        $this->data = array_merge(array(
            'pageTitle' => $this->info['title'],
            'pageNote' => $this->info['note'],
            'pageModule' => 'realbiayalkp',
            'return' => self::returnUrl()
        ), $this->data);
    }

    public function index(Request $request)
    {
    // Validasi input tanggal
    $request->validate([
        'start_date' => 'nullable|date',
        'end_date' => 'nullable|date|after_or_equal:start_date',
    ]);

    // Ambil start_date dan end_date dari request, jika tidak ada, set default
    $startDate = $request->input('start_date',"2024-12-31");
    $endDate = $request->input('end_date',"2025-12-31");

    // Call stored procedure Get_BIAYALKP dengan filter tanggal
    $results = DB::select('CALL Get_BIAYALKP2(?, ?)', [$startDate, $endDate]);

    // Menggabungkan variabel data dan hasil ke view
    return view('realbiayalkp.index', array_merge($this->data, compact('results')));
}

    public function show(Request $request, $id)
    {
        /* Handle import, export, and view */
        $task = $id;
        switch ($task) {
            case 'export':
                return $this->getExport($request);
                break;
        }
    }
    
    
    
    
    
    
    
}