class Line !!!1139589.php!!! define(inout orm : ORM = null) return parent::define($orm) ->setClass('Line') ->setTable('LINEAS') ->addField('id', 'LINEA', ORMDefinition::STRING, 255, 0, false) ->setKey('id') // ->addField('line', 'LINEA', ORMDefinition::STRING, 255, 0, false) ->addField('description', 'DESCRIPCION', ORMDefinition::STRING, 255, null, true) ->addField('status', 'ESTADO', ORMDefinition::INTEGER, 2, 0, false) ->addField('created', 'FE_ALTA', ORMDefinition::DATE, null, null, false) ->addField('modified', 'FE_MODIFICACION', ORMDefinition::DATE, null, null, true) ->addField('disabled', 'FE_BAJA', ORMDefinition::DATE, null, null, true) ->addField('registered', 'REGISTRADO', ORMDefinition::INTEGER, 2, 0, true) ->addField('userAgent', 'USER_AGENT', ORMDefinition::STRING, 512, null, true) ->addField('ip', 'IP', ORMDefinition::STRING, 50, null, true) ->addField('port', 'PUERTO', ORMDefinition::STRING, 10, null, true) ->addInstance('lineType', 'T_LINEA_ID', 'LineType') ->addField('interno', 'NRO_INTERNO', ORMDefinition::STRING, 255, null, true) ->addField('passwordSip', 'PASSWORD_SIP', ORMDefinition::STRING, 255, null, true) ->addField('vpnVoiceEnabled', 'VPN_VOICE', ORMDefinition::INTEGER, 1, 0, true) ->addField('outlookIntegrationEnabled', 'INTEGRACION_OUTLOOK', ORMDefinition::INTEGER, 1, 0, true) ->addField('cfnrEnabled', 'SERVICIO_CFRM', ORMDefinition::INTEGER, 1, 0, true) ->addField('webDetailEnabled', 'DETALLE_WEB', ORMDefinition::INTEGER, 1, 0, true) ->addField('voiceMailEnabled', 'VOICE_MAIL', ORMDefinition::INTEGER, 1, 0, true) ->addField('callCenter', 'LICENCIA_CALLCENTER', ORMDefinition::INTEGER, 1, 0, true) ->addField('subscription', 'SUBSCRIPTION', ORMDefinition::INTEGER, null, null, true) ->addField('ssi', 'ENRUTAMIENTO_SSI', ORMDefinition::INTEGER, 10, 0, true) ->addField('mac', 'MAC_ADDRESS', ORMDefinition::STRING, 50, 0, true) ->addField('hardwareState', 'ESTADO_HW', ORMDefinition::INTEGER, 2, 0, true) ->addField('hardwareDate', 'FE_HW', ORMDefinition::DATE, null, null, true) ->addField('hardwareFile', 'FILE_HW', ORMDefinition::STRING, 255, null, true) ->addField('hardwareModel', 'MOD_HW_ID', ORMDefinition::INTEGER, 3, 0, true) ->addInstance('recepcionist', 'T_RECEPCIONISTA_ID', 'RecepcionistType', true, null, ORM_LOAD_STYLE::LAZY_LOAD) ->addInstance('site', 'SITIO_ID', 'Site', true, null, ORM_LOAD_STYLE::LAZY_LOAD) ->addInstance('servicePack', 'T_LICENCIA_ID', 'ServicePack', true, null, ORM_LOAD_STYLE::LAZY_LOAD) ; !!!1234821.php!!! save(inout orm : ORM = null) : bool $orm = ($orm === null) ? $this->orm : $orm; $this->orm = $orm; $params["p_user_id"] = 1; $params["p_subscription"] = $this->getSubscription(); $params["p_linea"] = $this->getLine();//$this->getLine(); $params["p_descripcion"] = $this->getDescription(); $params["p_sitio_id"] = $this->getSite()->getId(); $params["p_t_licencia_id"] = (is_a($this->getServicePack(), 'ServicePack')) ? $this->getServicePack()->getId() : null; $params["p_user_agent"] = $this->getUserAgent(); $params["p_ip"] = $this->getIp(); $params["p_puerto"] = $this->getPort(); $params["p_t_linea_id"] = $this->getLineType()->getId(); $params["p_nro_interno"] = $this->getInterno(); $params["p_password_sip"] = $this->getPasswordSip(); $params["p_vpn_voice"] = $this->getVpnVoiceEnabled(); $params["p_integracion_outlook"] = $this->getOutlookIntegrationEnabled(); $params["p_t_recepcionista_id"] = (is_a($this->getRecepcionist(), 'RecepcionistType')) ? $this->getRecepcionist()->getId() : null; $params["p_servicio_cfrm"] = $this->getCfnrEnabled(); $params["p_licencia_callcenter"] = $this->getCallCenter(); $params["p_enrutamiento_ssi"] = $this->getSsi(); $params["p_detalle_web"] = $this->getWebDetailEnabled(); $params["p_voice_mail"] = $this->getVoiceMailEnabled(); $db = $orm->getDatabase()->getConnection(); if ($this->id === null) { $db->executeFunction("FU_LINEAS_INS", $params); } else { $db->executeFunction("FU_LINEAS_UPD", $params); } //Hacer Clear de cache xd !!!1234949.php!!! delete() : bool $orm = ($orm === null) ? $this->orm : $orm; $this->orm = $orm; $params["p_user_id"] = 1; $params["p_linea"] = $this->getId();//$this->getLine(); $db = $orm->getDatabase()->getConnection(); $db->executeFunction("FU_LINEAS_DEL", $params); //FU_LINEAS_DEL(p_user_id IN NUMBER, p_linea IN VARCHAR2