Code Coverage |
||||||||||
Lines |
Functions and Methods |
Classes and Traits |
||||||||
| Total | |
0.00% |
0 / 3 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 1 |
| SeniorPreOrdersIntegration | |
0.00% |
0 / 3 |
|
0.00% |
0 / 2 |
6 | |
0.00% |
0 / 1 |
| get | |
0.00% |
0 / 1 |
|
0.00% |
0 / 1 |
2 | |||
| query | |
0.00% |
0 / 2 |
|
0.00% |
0 / 1 |
2 | |||
| 1 | <?php |
| 2 | |
| 3 | namespace Domain\StockIO\Integrations; |
| 4 | |
| 5 | use Domain\Shared\Integrations\Senior\Exceptions\IntegrationSoapSeniorException; |
| 6 | use Domain\Shared\Integrations\Senior\SeniorQueryExecute; |
| 7 | use Domain\StockIO\DTOs\SeniorOrdersSummarysDTO; |
| 8 | use SoapFault; |
| 9 | |
| 10 | readonly class SeniorPreOrdersIntegration |
| 11 | { |
| 12 | /** |
| 13 | * @param SeniorOrdersSummarysDTO $seniorOrdersDTO |
| 14 | * @return array |
| 15 | * @throws IntegrationSoapSeniorException |
| 16 | * @throws SoapFault |
| 17 | */ |
| 18 | public function get(SeniorOrdersSummarysDTO $seniorOrdersDTO): array |
| 19 | { |
| 20 | return (new SeniorQueryExecute())->execute($this->query($seniorOrdersDTO->codref)); |
| 21 | } |
| 22 | |
| 23 | /** |
| 24 | * @param string $coref |
| 25 | * @return string |
| 26 | */ |
| 27 | private function query(string $coref): string |
| 28 | { |
| 29 | return "select |
| 30 | e135pfa.codemp as e135pfa_codemp, |
| 31 | e135pfa.codfil as e135pfa_codfil, |
| 32 | e135pfa.numane as e135pfa_numane, |
| 33 | e135pfa.numpfa as e135pfa_numpfa, |
| 34 | e135pfa.sitpfa as e135pfa_sitpfa, |
| 35 | e135pfa.codcli as e135pfa_codcli, |
| 36 | e135pfa.usuger as e135pfa_usuger, |
| 37 | e135pfa.datger as e135pfa_datger, |
| 38 | e135pes.seqpes as e135pes_seqpes, |
| 39 | e135pes.filped as e135pes_filped, |
| 40 | e135pes.numped as e135pes_numped, |
| 41 | e135pes.seqipd as e135pes_seqipd, |
| 42 | e135pes.seqisp as e135pes_seqisp, |
| 43 | e135pes.codpro as e135pes_codpro, |
| 44 | e135pes.codder as e135pes_codder, |
| 45 | e135pes.cplpes as e135pes_cplpes, |
| 46 | e135pes.codfam as e135pes_codfam, |
| 47 | e135pes.qtdped as e135pes_qtdped, |
| 48 | e135pes.qtdppf as e135pes_qtdppf, |
| 49 | e135pes.unimed as e135pes_unimed, |
| 50 | e135pes.pesbru as e135pes_pesbru, |
| 51 | e135pes.pesliq as e135pes_pesliq, |
| 52 | e135pes.volpes as e135pes_volpes, |
| 53 | e135pes.preuni as e135pes_preuni, |
| 54 | e135pes.prebas as e135pes_prebas, |
| 55 | e135pes.univen as e135pes_univen, |
| 56 | e135pes.qtdven as e135pes_qtdven, |
| 57 | e085cli.nomcli as e085cli_nomcli |
| 58 | from e135pfa |
| 59 | inner join e085cli |
| 60 | on e085cli.codcli = e135pfa.codcli |
| 61 | inner join e135pes |
| 62 | on e135pes.codemp = e135pfa.codemp |
| 63 | and e135pes.codfil = e135pfa.codfil |
| 64 | and e135pes.numane = e135pfa.numane |
| 65 | and e135pes.numpfa = e135pfa.numpfa |
| 66 | inner JOIN e075pro |
| 67 | ON e075pro.CODEMP = E135PES.CODEMP |
| 68 | AND e075pro.codpro = E135PES.codpro |
| 69 | inner JOIN e075der |
| 70 | ON E075DER.CODEMP = E075PRO.CODEMP |
| 71 | AND E075DER.CODPRO = E075PRO.CODPRO |
| 72 | AND E075DER.CODder = E135PES.codder |
| 73 | where e135pfa.codemp=1 |
| 74 | and e135pfa.codfil=1 |
| 75 | and e135pfa.numnfv = 0 |
| 76 | and e135pfa.sitpfa not in (4,9) |
| 77 | AND e075der.CODREF = '$coref'"; |
| 78 | } |
| 79 | } |