<?php

namespace App\Controllers\Store;

use \App\Controllers\Ps\PS_Controller;
use CodeIgniter\HTTP\RequestInterface;
use CodeIgniter\HTTP\ResponseInterface;
use Psr\Log\LoggerInterface;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

class Storeadjuststockfgi extends PS_Controller
{
    private $id_column_name = '';

    public function initController(RequestInterface $request, ResponseInterface $response, LoggerInterface $logger)
    {
        parent::initController($request, $response, $logger); // TODO: Change the autogenerated stub
        parent::setPageTitleBreadcrumb(true, 'Penyesuaian Stok FGI', array('l1' => 'Laporan', 'l2' => 'Penyesuaian Stok FGI'));
        parent::setURLActionTable($this->class);
        parent::setContentView($this->class);
        parent::setBaseContAndModel($this->class, 'ReportBahanbaku');
        $this->validation_input = $this->validation->setRules([
            "role_name" => ['label' => 'Role', 'rules' => 'required']
        ]);
    }

    public function index()
    {
        parent::filterStoreLoad();
        $this->session->set('trash', false);
        $this->session->set('keyword', '');

        if ($_POST) {
            // if ($_POST['rpt'] == 'show') {
                // $this->exportpdf($_POST);
            // }
        }
        
        $pob = new  \App\Models\MasterPob();
        $this->view_data['_pob'] = $pob->where('deleted_at', null)->findAll();

        $fgi = new  \App\Models\MasterBulumata();
        $this->view_data['_fgi'] = $fgi->where('deleted_at', null)->findAll();

        $barang = new  \App\Models\MasterBarang();
        $this->view_data['_barang'] = $barang->where('deleted_at', null)->findAll();
        $this->render->viewAdmin($this->content_views['table_view'], $this);
    }

    public function savestock()
    {
        if(isset($_POST)){
            $fgi = $_POST['fgi'];
            $pob = $_POST['pob'];
            $mb_id = $_POST['id'];
            $ms_stok_minus = $_POST['ms_stok_minus'] ?? 0;
            $ms_stok_plus = $_POST['ms_stok_plus'] ?? 0;
            $ms_stok_plus2 = $_POST['ms_stok_plus2'] ?? 0;
            $ms_stok_minus2 = $_POST['ms_stok_minus2'] ?? 0;
            $ms_stok_alasan = $_POST['ms_stok_alasan'] ?? '';
            


            // MASUK HASIL PRODUKSI
            if($ms_stok_minus > 0){
                $stok = new  \App\Models\MasterStokbulumata();
                $datamodel = array(                        
                    'mbm_id' => $fgi,
                    'msb_pob' => $pob,
                    'msb_stok' => -(int)$ms_stok_minus,
                    'is_adjusted' => 1,
                );
                $stok->save($datamodel);
            }
            if($ms_stok_plus > 0){
                $stok = new  \App\Models\MasterStokbulumata();
                $datamodel = array(                        
                    'mbm_id' => $fgi,
                    'msb_pob' => $pob,
                    'msb_stok' => (int)$ms_stok_plus,
                    'is_adjusted' => 1,
                );
                $stok->save($datamodel);
            }

            // MASUK HASIL PERAKITAN
            //update stok minus
            if($ms_stok_minus2 > 0){
                $stok = new  \App\Models\MasterStok();
                $datamodel = array( 
                    'mb_id' => $mb_id,
                    'ms_stok_fgi' => -(int)$ms_stok_minus2,
                    'is_adjusted' => 1,
                    'ms_alasan' => $ms_stok_alasan,
                );
                $stok->save($datamodel);
            }
            //update stok plus
            if($ms_stok_plus2 > 0){
                $stok = new  \App\Models\MasterStok();
                $datamodel = array(  
                    'mb_id' => $mb_id,
                    'ms_stok_fgi' => (int)$ms_stok_plus2,
                    'is_adjusted' => 1,
                    'ms_alasan' => $ms_stok_alasan,
                );
                $stok->save($datamodel);
            }

            echo json_encode(array(
                "statusCode"=>200
            ));
        }else{
            echo json_encode(array(
                "statusCode"=>201
            ));
        }
    }
        public function cekstok(){
        if(isset($_POST)){
            $fgi=$_POST['fgi'];
            $ms_stok_minus=$_POST['ms_stok_minus'];
            $ms_stok_plus=$_POST['ms_stok_plus'];

            $bm = new  \App\Models\MasterBulumata();
            $_bm = $bm->where('mbm_id', $fgi)->first();
            $konversi = $_bm->mbm_konversi ?? 1;

            $qtyInputMinus = 0;
            $qtyInputPlus = 0;

            if((int)$ms_stok_minus > 0){
                $qtyInputMinus = $ms_stok_minus*$konversi;
            }
            if((int)$ms_stok_plus > 0){
                $qtyInputPlus = $ms_stok_plus*$konversi;

            }
                echo json_encode(array(
                    "statusCode"=>200,
                    "ms_stok_minus"=>$qtyInputMinus,
                    "ms_stok_plus"=>$qtyInputPlus
                ));
        }

    } 

}