<?php

namespace Modules\GlobalApplication\Repository;

use Helpers\QueryBuilder\AbsRepository;

class Planning extends AbsRepository
{

    
    /**
     * getPlanningDA
     * @param string $id
     * @param string $noPo
     * @return array<mixed>
     */
    public function getPlanningDA(string $id, string $noPo) : ?array
    {
        $req = "SELECT DTE_LIV, QTE_DEMAN QTE 
            FROM DA_PLANN with (nolock) 
            WHERE NO_DA = :id AND NO_PO = :noPo";
        
        $arrayReq = [
            ':id' => $id,
            ':noPo' => $noPo,
        ];
        
        return $this->fetchAssocAll($req, $arrayReq);
    }
}
