FrameAppWS

<back to all web services

EjecutaScriptBDRQ

<?php namespace dtos;

use DateTime;
use Exception;
use DateInterval;
use JsonSerializable;
use ServiceStack\{IReturn,IReturnVoid,IGet,IPost,IPut,IDelete,IPatch,IMeta,IHasSessionId,IHasBearerToken,IHasVersion};
use ServiceStack\{ICrud,ICreateDb,IUpdateDb,IPatchDb,IDeleteDb,ISaveDb,AuditBase,QueryDb,QueryDb2,QueryData,QueryData2,QueryResponse};
use ServiceStack\{ResponseStatus,ResponseError,EmptyResponse,IdResponse,ArrayList,KeyValuePair2,StringResponse,StringsResponse,Tuple2,Tuple3,ByteArray};
use ServiceStack\{JsonConverters,Returns,TypeContext};


// @DataContract
class LogScriptsBD implements JsonSerializable
{
    public function __construct(
        // @DataMember
        /** @var float */
        public float $CodigoServidor=0.0,

        // @DataMember
        /** @var float */
        public float $CodigoDetalle=0.0,

        // @DataMember
        /** @var float */
        public float $CodigoLog=0.0,

        // @DataMember
        /** @var float */
        public float $CodigoScript=0.0,

        // @DataMember
        /** @var string|null */
        public ?string $SQL=null,

        // @DataMember
        /** @var string|null */
        public ?string $SQLAnt=null,

        // @DataMember
        /** @var string|null */
        public ?string $NombreServidor=null,

        // @DataMember
        /** @var string|null */
        public ?string $Mensaje=null,

        // @DataMember
        /** @var DateTime */
        public DateTime $FechaEjecucion=new DateTime(),

        // @DataMember
        /** @var string|null */
        public ?string $LoginAplica=null,

        // @DataMember
        /** @var string|null */
        public ?string $Estado=null
    ) {
    }

    /** @throws Exception */
    public function fromMap($o): void {
        if (isset($o['CodigoServidor'])) $this->CodigoServidor = $o['CodigoServidor'];
        if (isset($o['CodigoDetalle'])) $this->CodigoDetalle = $o['CodigoDetalle'];
        if (isset($o['CodigoLog'])) $this->CodigoLog = $o['CodigoLog'];
        if (isset($o['CodigoScript'])) $this->CodigoScript = $o['CodigoScript'];
        if (isset($o['SQL'])) $this->SQL = $o['SQL'];
        if (isset($o['SQLAnt'])) $this->SQLAnt = $o['SQLAnt'];
        if (isset($o['NombreServidor'])) $this->NombreServidor = $o['NombreServidor'];
        if (isset($o['Mensaje'])) $this->Mensaje = $o['Mensaje'];
        if (isset($o['FechaEjecucion'])) $this->FechaEjecucion = JsonConverters::from('DateTime', $o['FechaEjecucion']);
        if (isset($o['LoginAplica'])) $this->LoginAplica = $o['LoginAplica'];
        if (isset($o['Estado'])) $this->Estado = $o['Estado'];
    }
    
    /** @throws Exception */
    public function jsonSerialize(): mixed
    {
        $o = [];
        if (isset($this->CodigoServidor)) $o['CodigoServidor'] = $this->CodigoServidor;
        if (isset($this->CodigoDetalle)) $o['CodigoDetalle'] = $this->CodigoDetalle;
        if (isset($this->CodigoLog)) $o['CodigoLog'] = $this->CodigoLog;
        if (isset($this->CodigoScript)) $o['CodigoScript'] = $this->CodigoScript;
        if (isset($this->SQL)) $o['SQL'] = $this->SQL;
        if (isset($this->SQLAnt)) $o['SQLAnt'] = $this->SQLAnt;
        if (isset($this->NombreServidor)) $o['NombreServidor'] = $this->NombreServidor;
        if (isset($this->Mensaje)) $o['Mensaje'] = $this->Mensaje;
        if (isset($this->FechaEjecucion)) $o['FechaEjecucion'] = JsonConverters::to('DateTime', $this->FechaEjecucion);
        if (isset($this->LoginAplica)) $o['LoginAplica'] = $this->LoginAplica;
        if (isset($this->Estado)) $o['Estado'] = $this->Estado;
        return empty($o) ? new class(){} : $o;
    }
}

class EjecutaScriptBDRS implements JsonSerializable
{
    public function __construct(
        /** @var array<LogScriptsBD>|null */
        public ?array $LogScript=null,
        /** @var string|null */
        public ?string $Error=null
    ) {
    }

    /** @throws Exception */
    public function fromMap($o): void {
        if (isset($o['LogScript'])) $this->LogScript = JsonConverters::fromArray('LogScriptsBD', $o['LogScript']);
        if (isset($o['Error'])) $this->Error = $o['Error'];
    }
    
    /** @throws Exception */
    public function jsonSerialize(): mixed
    {
        $o = [];
        if (isset($this->LogScript)) $o['LogScript'] = JsonConverters::toArray('LogScriptsBD', $this->LogScript);
        if (isset($this->Error)) $o['Error'] = $this->Error;
        return empty($o) ? new class(){} : $o;
    }
}

class EjecutaScriptBDRQ implements JsonSerializable
{
    public function __construct(
        /** @var float */
        public float $CodigoScript=0.0
    ) {
    }

    /** @throws Exception */
    public function fromMap($o): void {
        if (isset($o['CodigoScript'])) $this->CodigoScript = $o['CodigoScript'];
    }
    
    /** @throws Exception */
    public function jsonSerialize(): mixed
    {
        $o = [];
        if (isset($this->CodigoScript)) $o['CodigoScript'] = $this->CodigoScript;
        return empty($o) ? new class(){} : $o;
    }
}

PHP EjecutaScriptBDRQ DTOs

POST /Utilidades/EjecutaScriptBD HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<EjecutaScriptBDRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <CodigoScript>0</CodigoScript>
</EjecutaScriptBDRQ>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaScriptBDRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <Error>String</Error>
  <LogScript xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Contexto">
    <d2p1:LogScriptsBD>
      <d2p1:CodigoDetalle>0</d2p1:CodigoDetalle>
      <d2p1:CodigoLog>0</d2p1:CodigoLog>
      <d2p1:CodigoScript>0</d2p1:CodigoScript>
      <d2p1:CodigoServidor>0</d2p1:CodigoServidor>
      <d2p1:Estado>String</d2p1:Estado>
      <d2p1:FechaEjecucion>0001-01-01T00:00:00</d2p1:FechaEjecucion>
      <d2p1:LoginAplica>String</d2p1:LoginAplica>
      <d2p1:Mensaje>String</d2p1:Mensaje>
      <d2p1:NombreServidor>String</d2p1:NombreServidor>
      <d2p1:SQL>String</d2p1:SQL>
      <d2p1:SQLAnt>String</d2p1:SQLAnt>
    </d2p1:LogScriptsBD>
  </LogScript>
</EjecutaScriptBDRS>