PHP DataBase::ConsultaInsertReturnId方法代码示例

 public function InsertHistorical($content, $IdUser, $id_detalle, $id_validacion, $ruta_xml, $ruta_pdf, $tipo_archivo)
 {
     $DB = new DataBase();
     $q = "INSERT INTO historial_{$content} SET id_detalle={$id_detalle},id_validacion={$id_validacion},id_usuario={$IdUser}" . ",fecha_hora=now(),ruta_xml='{$ruta_xml}', ruta_pdf='{$ruta_pdf}', tipo_archivo='{$tipo_archivo}'";
     $NewIdHistorical = $DB->ConsultaInsertReturnId("CFDI", $q);
     if (!($NewIdHistorical > 0)) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al insertar el registro en el histórico</p><br>Detalles:<br><br>{$NewIdHistorical}");
         return 0;
     }
     return $NewIdHistorical;
 }

 private function NewEnterpriseSystem()
 {
     $DB = new DataBase();
     $IdUser = filter_input(INPUT_POST, "IdUser");
     $UserName = filter_input(INPUT_POST, "UserName");
     $ManagerEnterpriseAlias = filter_input(INPUT_POST, "EnterpriseAlias");
     $EnterpriseAlias = filter_input(INPUT_POST, "NewEnterpriseAlias");
     $EnterpriseName = filter_input(INPUT_POST, "NewNameEnterprise");
     $EnterpriseRFC = filter_input(INPUT_POST, "NewRfcEnterprise");
     $EnterprisePassword = filter_input(INPUT_POST, "NewPasswordEnterprise");
     $IdVolume = filter_input(INPUT_POST, "IdVolume");
     $AssignedMemory = filter_input(INPUT_POST, "AssignedMemory");
     $Volume = filter_input(INPUT_POST, "Volume");
     $RoutFile = filter_input(INPUT_SERVER, "DOCUMENT_ROOT");
     /* /var/services/web */
     $CheckVersion = Version::CheckVersion();
     if ($CheckVersion == 0) {
         return 0;
     }
     $QueryDuplicated = "SELECT *FROM Enterprises WHERE Alias COLLATE utf8_bin = '{$EnterpriseAlias}'";
     $ResultDuplicated = $DB->ConsultaSelect($ManagerEnterpriseAlias, $QueryDuplicated);
     if ($ResultDuplicated['Estado'] != 1) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al comprobar la no existencia de la nueva empresa</p><br>Detalles:<br><br>" . $ResultDuplicated['Estado']);
         return 0;
     }
     if (count($ResultDuplicated['ArrayDatos']) > 0) {
         XML::XmlResponse("DuplicatedEnterprise", 0, "El alias de la empresa ya existe");
         return 0;
     }
     if (!($ResultCopy = copy("{$RoutFile}/index.html", "{$RoutFile}/{$EnterpriseAlias}.html"))) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al generar el documento html de la nueva empresa</p>");
         return 0;
     }
     if ($CreateEnterprise = $DB->CreateEnterpriseInstance($EnterpriseAlias) != 1) {
         $DB->DeleteDataBase($EnterpriseAlias);
         return 0;
     }
     $Now = date("Y-m-d H:i:s");
     $QInsertEnterprise = "INSERT INTO Enterprises (Alias, EnterpriseName, RFC, Password, DischargeDate , IdVolume, AvailableMemory, TotalMemory) VALUES " . "('{$EnterpriseAlias}', '{$EnterpriseName}', '{$EnterpriseRFC}', '{$EnterprisePassword}', '{$Now}',  '{$IdVolume}', {$AssignedMemory} ,{$AssignedMemory})";
     $IdEnterprise = $DB->ConsultaInsertReturnId('Manager', $QInsertEnterprise);
     if (!($IdEnterprise > 0)) {
         $DB->DeleteDataBase($EnterpriseAlias);
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al registrar la nueva empresa</p><br>Detalles:<br><br>{$IdEnterprise}");
         return 0;
     }
     $UpdateMemory = "UPDATE Volumes SET Used = Used + {$AssignedMemory}, Available = Available - {$AssignedMemory} WHERE IdVolume = {$IdVolume}";
     if (($ResultUpdate = $DB->ConsultaQuery('Manager', $UpdateMemory)) != 1) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al actualizar el espacio disponible en el volúmen {$Volume}</p><br>Detalles:<br><br>{$ResultUpdate}");
         return 0;
     }
     $doc = new DOMDocument('1.0', 'utf-8');
     $doc->formatOutput = true;
     $root = $doc->createElement("NewEnterprise");
     $doc->appendChild($root);
     $mensaje_ = $doc->createElement('Mensaje', "Empresa {$EnterpriseName} dada de alta con éxito");
     $root->appendChild($mensaje_);
     $IdEnterpriseXml = $doc->createElement("IdEnterprise", $IdEnterprise);
     $root->appendChild($IdEnterpriseXml);
     $EnterpriseAliasXml = $doc->createElement("EnterpriseAlias", $EnterpriseAlias);
     $root->appendChild($EnterpriseAliasXml);
     $EnterpriseNameXml = $doc->createElement("EnterpriseName", $EnterpriseName);
     $root->appendChild($EnterpriseNameXml);
     $RFCXml = $doc->createElement("RFC", $EnterpriseRFC);
     $root->appendChild($RFCXml);
     $DischargeDateXml = $doc->createElement("DischargeDate", $Now);
     $root->appendChild($DischargeDateXml);
     $TotalMemory = $doc->createElement("TotalMemory", $AssignedMemory);
     $root->appendChild($TotalMemory);
     $VolumeXml = $doc->createElement("Volume", $Volume);
     $root->appendChild($VolumeXml);
     $OccupiedMemory = $doc->createElement("OccupiedMemory", 0);
     $root->appendChild($OccupiedMemory);
     $FreeMemory = $doc->createElement("FreeMemory", $AssignedMemory);
     $root->appendChild($FreeMemory);
     header("Content-Type:text/xml");
     echo $doc->saveXML();
 }

 private function NewUser()
 {
     $DB = new DataBase();
     $EnterpriseAlias = filter_input(INPUT_POST, "EnterpriseAlias");
     $NewUserName = filter_input(INPUT_POST, "NewUsername");
     $LastName = filter_input(INPUT_POST, "LastName");
     $MLastName = filter_input(INPUT_POST, "MLastName");
     $SystemUsername = filter_input(INPUT_POST, "SystemUsername");
     $Password = filter_input(INPUT_POST, "Password");
     $Repeated = "SELECT * FROM Users WHERE UserName COLLATE utf8_bin = '{$SystemUsername}'";
     $ResultRepetaed = $DB->ConsultaSelect($EnterpriseAlias, $Repeated);
     if ($ResultRepetaed['Estado'] != 1) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al comprobar que el usuario no estuviera registrado previamente</p><br>Detalles:<br><br>" . $ResultRepetaed['Estado']);
         return;
     }
     if (count($ResultRepetaed['ArrayDatos']) > 0) {
         XML::XmlResponse("RepeatedUser", 1, "El usuario '{$NewUserName}' ya existe");
         return 0;
     }
     $now = date('Y-m-d');
     $Insert = "INSERT INTO Users (UserName, Password, Name, LastName, MLastName, DischargeDate)\n        VALUES ('{$SystemUsername}', '{$Password}', '{$NewUserName}', '{$LastName}', '{$MLastName}', '{$now}')";
     $IdUser = $DB->ConsultaInsertReturnId($EnterpriseAlias, $Insert);
     if (!$IdUser > 0) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al registrar el nuevo usuario</p><br>Detalles:<br><br>{$ResultInsert}");
         return 0;
     }
     $doc = new DOMDocument('1.0', 'utf-8');
     $doc->formatOutput = true;
     $root = $doc->createElement("NewUser");
     $doc->appendChild($root);
     $mensaje_ = $doc->createElement('Mensaje', "Usuario '{$NewUserName}' registrado con éxito");
     $root->appendChild($mensaje_);
     $IdUserXml = $doc->createElement("IdUser", $IdUser);
     $root->appendChild($IdUserXml);
     $NewUsernameSystemXml = $doc->createElement("SystemUsername", $SystemUsername);
     $root->appendChild($NewUsernameSystemXml);
     $UserName = $doc->createElement("UserName", $NewUserName);
     $root->appendChild($UserName);
     $LastNameXml = $doc->createElement("LastName", $LastName);
     $root->appendChild($LastNameXml);
     $MLastNameXml = $doc->createElement("MLastName", $MLastName);
     $root->appendChild($MLastNameXml);
     $DischargeDate = $doc->createElement("DischargeDate", $now);
     $root->appendChild($DischargeDate);
     header("Content-Type:text/xml");
     echo $doc->saveXML();
 }

 private function ProcessingEnterpriseEmail()
 {
     $DB = new DataBase();
     $EnterpriseAlias = filter_input(INPUT_POST, "EnterpriseAlias");
     $IdUser = filter_input(INPUT_POST, "IdUser");
     $UserName = filter_input(INPUT_POST, "UserName");
     $UserNameEmail = filter_input(INPUT_POST, "UserNameEmail");
     $EmailTitle = filter_input(INPUT_POST, "EmailTitle");
     $EmailPassword = filter_input(INPUT_POST, "EmailPassword");
     $Smtp = filter_input(INPUT_POST, "Smtp");
     $SmtpPort = filter_input(INPUT_POST, "SmtpPort");
     $SmtpAuth = filter_input(INPUT_POST, "SmtpAuth");
     $SmtpSecure = filter_input(INPUT_POST, "SmtpSecure");
     $Imap = filter_input(INPUT_POST, "Imap");
     $ImapPort = filter_input(INPUT_POST, "ImapPort");
     $ImapSecure = filter_input(INPUT_POST, "ImapSecure");
     if (strcasecmp($ImapSecure, "ssl") == 0 or strcasecmp($ImapSecure, "tls") == 0) {
         $ImapSecure .= "/";
     } else {
         $ImapSecure = '';
     }
     $Email = array("EnterpriseAlias" => $EnterpriseAlias, "IdUser" => $IdUser, "UserName" => $UserName, "UserNameEmail" => $UserNameEmail, "EmailPassword" => $EmailPassword, "Smtp" => $Smtp, "EmailTitle" => $EmailTitle, "SmtpPort" => $SmtpPort, "SmtpAuth" => $SmtpAuth, "SmtpSecure" => $SmtpSecure, "Imap" => $Imap, "ImapPort" => $ImapPort, "ImapSecure" => $ImapSecure);
     $CheckIfExist = "SELECT *FROM EmailEngine WHERE User COLLATE utf8_bin = '{$UserNameEmail}'";
     $CheckIfExistRes = $DB->ConsultaSelect($EnterpriseAlias, $CheckIfExist);
     if ($CheckIfExistRes['Estado'] != 1) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al comprobar existencia del nuevo correo electrónico</p><br>Detalles:<br><br>" . $CheckIfExistRes['Estado']);
         return 0;
     }
     if (count($CheckIfExistRes['ArrayDatos'])) {
         XML::XmlResponse("Duplicated", 1, "<p>El correo electrónico {$UserNameEmail} ya se encuentra registrado</p>");
         return;
     }
     /* Prueba de envio (Envió de email) */
     $Recipients = array();
     $Recipients[] = array("Addressee" => $Email['UserNameEmail'], "Title" => $Email['EmailTitle']);
     $Subject = "Alta de correo electrónico en CSDocs CFDI";
     $Message = "Ha dado de alta su correo electrónico en el sistema CSDocs CFDI, ya puede realizar descargas de <b>Comprobantes Fiscales Digitales por Internet</b> y almacenarlos de forma segura.";
     if (($SendEmail = $this->SendEmail($Email, $Recipients, $Subject, $Message)) != 1) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al realizar la prueba de envio de correo electrónico: <br><br>{$SendEmail}</p>");
         return 0;
     }
     $ImapPath = "{" . $Imap . ":" . $ImapPort . "/imap/" . $ImapSecure . "novalidate-cert}";
     if ($mbox = imap_open($ImapPath, $UserNameEmail, $EmailPassword)) {
         imap_close($mbox);
     } else {
         XML::XmlResponse("Error", 0, "<p>Ocurrió el siguiente error. " . imap_last_error() . ". <p>Revise que sus datos sean correctos</p>");
         return 0;
     }
     $InsertEmail = "INSERT INTO EmailEngine " . "(User, Password, Title, Smtp, SmtpPort, SmtpAuth, SmtpSecure, Imap, ImapPort, ImapSecure, EmailType, EmailServerName) " . "VALUES ('{$UserNameEmail}', '{$EmailPassword}', '{$EmailTitle}', '{$Smtp}', {$SmtpPort}, '{$SmtpAuth}', '{$SmtpSecure}', '{$Imap}', {$ImapPort}, '{$ImapSecure}', 'Enterprise', 'otro')";
     $InsertEmailResult = $DB->ConsultaInsertReturnId($EnterpriseAlias, $InsertEmail);
     if (!($InsertEmailResult > 0)) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al registrar el correo electrónico</p><br>Detalles:<br><br>{$InsertEmailResult}");
         return 0;
     }
     $doc = new DOMDocument('1.0', 'utf-8');
     $doc->formatOutput = true;
     $root = $doc->createElement("NewEmail");
     $doc->appendChild($root);
     $Mensaje = $doc->createElement("Mensaje", "El correo {$UserNameEmail} fué dado de alta con éxito");
     $root->appendChild($Mensaje);
     $EmailXml = $doc->createElement("UserNameEmail", $UserNameEmail);
     $root->appendChild($EmailXml);
     $IdEmail = $doc->createElement("IdEmail", $InsertEmailResult);
     $root->appendChild($IdEmail);
     header("Content-Type:text/xml");
     echo $doc->saveXML();
 }

 function InsertValidationCfdi($EnterpriseAlias, $content, $validacion, $ReceiptPath)
 {
     $DB = new DataBase();
     $webService = $validacion->getElementsByTagName("WebService")->item(0)->nodeValue;
     $EmisorRfc = $validacion->getElementsByTagName("EmisorRfc")->item(0)->nodeValue;
     $ReceptorRfc = $validacion->getElementsByTagName("ReceptorRFC")->item(0)->nodeValue;
     $FechaHoraEnvio = $validacion->getElementsByTagName("FechaHoraEnvio")->item(0)->nodeValue;
     $FechaHoraRespuesta = $validacion->getElementsByTagName("FechaHoraRespuesta")->item(0)->nodeValue;
     $TotalFactura = $validacion->getElementsByTagName("TotalFactura")->item(0)->nodeValue;
     $uuid = $validacion->getElementsByTagName("UUID")->item(0)->nodeValue;
     $CodigoEstatus = $validacion->getElementsByTagName("CodigoEstatus")->item(0)->nodeValue;
     $Estado = $validacion->getElementsByTagName("Estado")->item(0)->nodeValue;
     $md5 = $validacion->getElementsByTagName("AcuseRecibo")->item(0)->nodeValue;
     $q = "INSERT INTO validacion_{$content} (FechaHora_envio, FechaHora_respuesta, emisor_rfc," . "receptor_rfc, total_factura, uuid, codigo_estatus, estado, md5, web_service, ruta_acuse)" . " VALUES ('{$FechaHoraEnvio}', '{$FechaHoraRespuesta}', '{$EmisorRfc}', '{$ReceptorRfc}'" . ", {$TotalFactura}, '{$uuid}', '{$CodigoEstatus}', '{$Estado}', '{$md5}', '{$webService}', '{$ReceiptPath}')";
     $NewIdReceipt = $DB->ConsultaInsertReturnId($EnterpriseAlias, $q);
     if (!$NewIdReceipt > 0) {
         XML::XmlResponse("Error", 0, "<p><b>Error</b> al registrar la validación del nuevo Cfdi</p><br>Detalles:<br><br>{$NewIdReceipt}");
         return 0;
     }
     return $NewIdReceipt;
 }

 private function InsertReceptor($EnterpriseAlias, $ReceiverRfc, $ReceiverName, $CfdiPath)
 {
     $DB = new DataBase();
     $IdReceptor = 0;
     $CheckExistReceiver = "SELECT IdReceptor FROM Receptor WHERE RFC COLLATE utf8_bin = '{$ReceiverRfc}'";
     $CheckExistReceiverResult = $DB->ConsultaSelect($EnterpriseAlias, $CheckExistReceiver);
     if ($CheckExistReceiverResult['Estado'] != 1) {
         echo "\n Error al comprobar existencia del receptor en el documento " . basename($CfdiPath) . ". Error: " . $CheckExistReceiverResult['Estado'];
         return 0;
     }
     if (count($CheckExistReceiverResult['ArrayDatos']) == 0) {
         $InsertReceiver = "INSERT INTO Receptor (RFC, Nombre) VALUES ('{$ReceiverRfc}', '{$ReceiverName}')";
         if (!($InsertReceiverResult = $DB->ConsultaInsertReturnId($EnterpriseAlias, $InsertReceiver)) > 0) {
             echo "\n Error al intentar insertar el Receptor del documento " . basename($CfdiPath) . ". Error: {$InsertReceiverResult}";
             return 0;
         }
     } else {
         $IdReceptor = $CheckExistReceiverResult['ArrayDatos'][0]['IdReceptor'];
     }
     return $IdReceptor;
 }