Code Coverage |
||||||||||
Lines |
Functions and Methods |
Classes and Traits |
||||||||
| Total | |
0.00% |
0 / 3 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 1 |
| SeniorOrdersIntegration | |
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\SeniorQueryExecute; |
| 6 | use Domain\StockIO\DTOs\SeniorOrdersSummarysDTO; |
| 7 | |
| 8 | readonly class SeniorOrdersIntegration |
| 9 | { |
| 10 | |
| 11 | public function get(SeniorOrdersSummarysDTO $seniorOrdersDTO): array |
| 12 | { |
| 13 | return (new SeniorQueryExecute())->execute($this->query($seniorOrdersDTO->codref)); |
| 14 | } |
| 15 | |
| 16 | /** |
| 17 | * @param string $coref |
| 18 | * @return string |
| 19 | */ |
| 20 | private function query(string $coref): string |
| 21 | { |
| 22 | return "SELECT |
| 23 | e120ped.codemp as e120ped_codemp, |
| 24 | e120ped.codfil as e120ped_codfil, |
| 25 | e120ped.numped as e120ped_numped, |
| 26 | e120ped.tipped as e120ped_tipped, |
| 27 | e120ped.datemi as e120ped_datemi, |
| 28 | e120ped.codcli as e120ped_codcli, |
| 29 | replace(replace(e085cli.nomcli,chr(10),' ') ,chr(13),' ') e085cli_nomcli, |
| 30 | e120ped.catcli as e120ped_catcli, |
| 31 | e120ped.pedcli as e120ped_pedcli, |
| 32 | e120ped.codrep as e120ped_codrep, |
| 33 | replace(replace(e090rep.nomrep,chr(10),' ') ,chr(13),' ') as e090rep_nomrep, |
| 34 | e120ped.codmoe as e120ped_codmoe, |
| 35 | e120ped.codcpg as e120ped_codcpg, |
| 36 | e028cpg.descpg as e028cpg_descpg, |
| 37 | e120ped.codfpg as e120ped_codfpg, |
| 38 | e120ped.codtra as e120ped_codtra, |
| 39 | e120ped.sitped as e120ped_sitped, |
| 40 | e120ipd.seqipd as e120ipd_seqipd, |
| 41 | e120ipd.codpro as e120ipd_codpro, |
| 42 | e120ipd.codder as e120ipd_codder, |
| 43 | replace(replace(e120ipd.cplipd,chr(10),' ') ,chr(13),' ') e120ipd_cplipd, |
| 44 | e120ipd.qtdped as e120ipd_qtdped, |
| 45 | e120ipd.qtdaen as e120ipd_qtdaen, |
| 46 | e120ipd.qtdpoc as e120ipd_qtdpoc, |
| 47 | e120ipd.qtdfat as e120ipd_qtdfat, |
| 48 | e120ipd.qtdcan as e120ipd_qtdcan, |
| 49 | e120ipd.qtdabe as e120ipd_qtdabe, |
| 50 | e120ipd.qtdrae as e120ipd_qtdrae, |
| 51 | e120ipd.qtdnlp as e120ipd_qtdnlp, |
| 52 | e120ipd.qtdres as e120ipd_qtdres, |
| 53 | e120ipd.unimed as e120ipd_unimed, |
| 54 | e120ipd.datent as e120ipd_datent, |
| 55 | e120ipd.preuni as e120ipd_preuni, |
| 56 | e120ipd.preven as e120ipd_preven, |
| 57 | e120ipd.sitipd as e120ipd_sitipd, |
| 58 | replace(replace(e075pro.despro,chr(10),' ') ,chr(13),' ') as e075pro_despro, |
| 59 | e075pro.cplpro as e075pro_cplpro, |
| 60 | replace(replace(e075pro.desnfv,chr(10),' ') ,chr(13),' ') as e075pro_desnfv, |
| 61 | e075pro.codfam as e075pro_codfam, |
| 62 | e075pro.unimed as e075pro_unimed, |
| 63 | e075pro.unime2 as e075pro_unime2, |
| 64 | e075pro.tippro as e075pro_tippro, |
| 65 | e075pro.codori as e075pro_codori, |
| 66 | e075der.codref as e075der_codref, |
| 67 | e075der.desder as e075der_desder, |
| 68 | e075der.codba2 as e075der_codba2 |
| 69 | FROM e120ped |
| 70 | INNER JOIN e120ipd |
| 71 | ON e120ipd.codemp = e120ped.codemp |
| 72 | AND e120ipd.codfil = e120ped.codfil |
| 73 | AND e120ipd.numped = e120ped.numped |
| 74 | LEFT JOIN e075der |
| 75 | ON e075der.codemp = e120ipd.codemp |
| 76 | AND e075der.codpro = e120ipd.codpro |
| 77 | AND e075der.codder = e120ipd.codder |
| 78 | LEFT JOIN e075pro |
| 79 | ON e075pro.codemp = e120ipd.codemp |
| 80 | AND e075pro.codpro = e120ipd.codpro |
| 81 | INNER JOIN e028cpg |
| 82 | ON e028cpg.codemp = e120ped.codemp |
| 83 | AND e028cpg.codcpg = e120ped.codcpg |
| 84 | INNER JOIN e085cli |
| 85 | ON e085cli.codcli = e120ped.codcli |
| 86 | INNER JOIN e090rep |
| 87 | ON e090rep.codrep = e120ped.codrep |
| 88 | LEFT JOIN r996lsf |
| 89 | ON r996lsf.lstnam = 'LSitPed' |
| 90 | AND r996lsf.keynam = CAST(e120ped.sitped AS VARCHAR(30)) |
| 91 | WHERE e120ped.codemp=1 |
| 92 | AND e120ped.codfil=1 |
| 93 | AND e120ped.sitped NOT IN (5) |
| 94 | AND e120ipd.sitipd IN (1,2,6,8) |
| 95 | AND e075der.CODREF = '$coref'"; |
| 96 | // --AND e120ped.datemi BETWEEN '01/04/2024' AND '30/04/2024' |
| 97 | // --AND e120ped.tnspro = '90100' |
| 98 | // --AND e120ped.NUMPED = 9165231 |
| 99 | } |
| 100 | } |