<?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 Storeadjuststockwip 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 WIP', array('l1' => 'Transaksi', 'l2' => 'Penyesuaian Stok WIP'));
        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();
        
        $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)){
            $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_alasan = $_POST['ms_stok_alasan'] ?? '';
            
            //update stok minus
            if($ms_stok_minus > 0){
                $stok = new  \App\Models\MasterStok();
                $datamodel = array(                        
                    'ms_pob' => $pob,
                    'mb_id' => $mb_id,
                    'ms_stok_wip' => -(int)$ms_stok_minus,
                    'is_adjusted' => 1,
                    'ms_alasan' => $ms_stok_alasan,
                );
                $stok->save($datamodel);
            }
            //update stok plus
            if($ms_stok_plus > 0){
                $stok = new  \App\Models\MasterStok();
                $datamodel = array(                        
                    'ms_pob' => $pob,
                    'mb_id' => $mb_id,
                    'ms_stok_wip' => (int)$ms_stok_plus,
                    'is_adjusted' => 1,
                    'ms_alasan' => $ms_stok_alasan,
                );
                $stok->save($datamodel);
            }

            echo json_encode(array(
                "statusCode"=>200
            ));
        }else{
            echo json_encode(array(
                "statusCode"=>201
            ));
        }
    }

}