<?php

namespace App\Services\TpCreator\DocumentProcessors;

use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class DocumentProcedureTpProcessor extends AbstractTpDocumentProcessor
{
    public function process(
        array $lineData,
        array $document,
        Worksheet $sheet,
        int $currentRow,
        int $rowNo,
        string $fullFolder,
        string $testPackageNo,
        bool $override
    ): int {
        $docTitle = $document['title2'] ?? '';
        $docPath = $document['path'];
        
        $documentProcedure = db("document_procedures")->where("document_no", $docTitle)->first();
        
        if($documentProcedure) {
            $search = $this->alternativeGlob("storage/documents/{$docPath}/*{$docTitle}*.pdf");
            $docDate = $documentProcedure->publish_date;
            $document['title2'] = $documentProcedure->description;
            
            $this->addRow($search, $document, $fullFolder, $documentProcedure->document_no, $docDate, $rowNo, $sheet, $currentRow, $override);
            
            return $rowNo + 1;
        }
        
        return $rowNo;
    }
}