Execute($sql); if (!$result->EOF) { $operador = $result->fields; $anio=$operador['ctg_tpr_validez']; $fecha_db = $_POST['fecha']; //d - m - Y $fecha_db = explode("-",$fecha_db); $fecha_cambiada = mktime(0,0,0,$fecha_db[1],$fecha_db[0],$fecha_db[2]+$anio); // m d Y $fecha = date("d-m-Y", $fecha_cambiada); $respuesta['fecha'] = $fecha; } echo json_encode($respuesta); die(); } if (isset($_POST['ayuda'])) { for ($i=0; $i<1;$i++) { if ($i == 0) $params = $_POST['form'].$_POST['param']; else $params = $_POST['form']; $sql = "SELECT * FROM vus_ayuda WHERE UPPER(vus_ayu_form) = '".trim(strtoupper($params))."'"; echo $i."
"; echo $sql."
"; $result = $connection->Execute ( $sql ); if (!$resul->EOF) { $operador = $result->fields; // echo "(".$operador['vus_ayu_content'].")
"; $text = trim(nl2br($operador['vus_ayu_content'])); if ($text != "") { $sql="SELECT A.vus_ayu_desc, B.vus_ayu_form2 FROM vus_ayuda_also B, vus_ayuda A WHERE A.vus_ayu_form = B.vus_ayu_form2 AND B.vus_ayu_form1 = '".$operador['vus_ayu_form']."' ORDER BY B.vus_ayu_form2"; echo $sql."
"; $pngString = ob_get_contents(); ob_end_clean(); $respuesta = array(); $respuesta['retorna'] = " "; if (!empty($_POST['retorna'])) { $sql1 = "SELECT vus_ayu_desc FROM vus_ayuda WHERE vus_ayu_form = '".$_POST['retorna']."'"; $result1 = $connection->Execute ( $sql1 ); if (!$resul1->EOF) { $operador1 = $result1->fields; $respuesta['retorna'] = ' Regresar
'; } } $p = strpos($text,""); $respuesta['titulo'] = substr($text,0,$p+7); $text = substr($text,$p+7); $links = " "; $c = 64; $resu=$connection->Execute($sql); if (!$resu->EOF) { $links = "

Ver también :
"; //$links .= ""; } file_put_contents("../html_output.html", $text.$links); echo json_encode($respuesta); die(); } } } } if (isset($_POST['login'])) { $estado = 0; $respuesta = array(); $verify=trim(strtoupper($clave_login)); if ($verify=='MASTER') { $sql = "SELECT vus_usr_id, vus_usr_alias, vus_usr_nombre, vus_usr_tipcta, vus_usr_estatus, COALESCE(NOT vus_usr_pasw_asist LIKE '%/".trim($_POST['clave_login'])."/%', 't') as tipo, vus_usr_pasw_asist, vus_usr_emp_rif FROM vus_usuarios WHERE UPPER(vus_usr_alias) = '".trim(strtoupper($_POST['usuario_login']))."' OR UPPER(vus_usr_nombre) = '".trim(strtoupper($_POST['usuario_login']))."' "; } else { $sql = "SELECT vus_usr_id, vus_usr_alias, vus_usr_nombre, vus_usr_tipcta, vus_usr_estatus, COALESCE(NOT vus_usr_pasw_asist LIKE '%/".trim($_POST['clave_login'])."/%', 't') as tipo, vus_usr_pasw_asist, vus_usr_emp_rif FROM vus_usuarios WHERE (UPPER(vus_usr_alias) = '".trim(strtoupper($_POST['usuario_login']))."') AND (vus_usr_password = '".trim($_POST['clave_login'])."' OR vus_usr_pasw_asist LIKE '%/".trim($_POST['clave_login'])."/%') "; } // echo $sql; $result = $connection->Execute ( $sql ); if (!empty($result->fields[0])) { $operador = $result->fields; $estado = $operador['vus_usr_estatus']; $tipocuenta = $operador['vus_usr_tipcta']; $rifempresa = $operador['vus_usr_emp_rif']; $continua=1; if ($tipocuenta==2){ // if ($rifempresa!='J-407887750' && $rifempresa!='J-000215367' && $rifempresa!='J-299478695' && $rifempresa!='J-406080357' && $rifempresa!='J-000215278' && $rifempresa!='J-306866396' && $rifempresa!='J-000214956' && $rifempresa!='J-304305354' && $rifempresa!='J-000215006' && $rifempresa!='J-003441570' && $rifempresa!='G-200001011' && $rifempresa!='J-500407076') { // $continua=0; // $estado='9'; // } } if ($estado == 1 && $continua=1) { $_SESSION['usuario_main'] = ($operador['tipo'] == 't' ? true : false); $_SESSION['usuario_alias'] = $operador['vus_usr_alias']; $_SESSION['usuario_id'] = $operador['vus_usr_id']; $_SESSION['usuario_name'] = $operador['vus_usr_nombre']; $_SESSION['usuario_cta'] = $operador['vus_usr_tipcta']; $_SESSION['hora'] = time(); $_SESSION['tiempo'] = 3600; $asistente = ""; if ($_SESSION['usuario_main'] == false) { $asistentes_arr = explode("\n",$operador['vus_usr_pasw_asist']); //print_r($asistentes_arr); foreach ($asistentes_arr as $asis_d){ $asistente_arr = explode(",",$asis_d); if ("/".trim($_POST['clave_login'])."/" == $asistente_arr[1]) $asistente = $asistente_arr[0]; } } $_SESSION['usuario_asist'] = $asistente; //PGUSER=#usr# PGPASSWORD=#pss# pg_dump --host localhost --port 5432 --format custom --blobs --encoding UTF8 --verbose --file "/home/skyreg/siamedweb_backup/#bck#" "#dbn#" $today_log = date("Y-m-d").".log"; if (!is_file($today_log)) { // si no esta el archivo.log se ejecuta el proceso para revisar las notas atrasadas // //////////////// BORRO LOGICAMENTE SOLICITUDES CON MAS DE DIAS DE PREPARACION EN DRAFT //////////////////////// $sql = "SELECT ctg_tpa_siglas, ctg_tpa_tpr_id FROM ctg_tipo_productos_areas WHERE ctg_tpa_tpr_id < '07' AND ctg_tpa_sta = '1' ORDER BY ctg_tpa_tpr_id"; $respuesta['sql0'] = $sql; $res=$connectionADM->Execute($sql); if (!$res->EOF) { while ( !$res->EOF ) { $ope = $res->fields; $tpr = $ope['ctg_tpa_siglas']; $_POST['tipo'] = $ope['ctg_tpa_siglas']; $sql = "SELECT ctg_tpr_id FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$ope['ctg_tpa_tpr_id']}'"; $res1=$connectionADM->Execute($sql); if (!$res1->EOF) { $_POST['ctg_tpr_id'] = $res1->fields[0]; } $sql_d = "SELECT vus_{$tpr}_numsol, vus_{$tpr}_est_dt, (CURRENT_TIMESTAMP - vus_{$tpr}_fec_cre) as dias, vus_{$tpr}_tpt_id, vus_{$tpr}_tpr_id FROM vus_tramites_{$tpr} WHERE vus_{$tpr}_est_id = '0' AND vus_{$tpr}_usr_id > '2' ORDER BY vus_{$tpr}_est_dt "; // echo "
".$sql_d."
"; $result_d=$connection->Execute($sql_d); if (!$result_d->EOF) { while (!$result_d->EOF) { $operadord=$result_d->fields; // echo "
(".$result_d->fields['dias'].")
"; if (strpos($result_d->fields['dias'], 'days') !== false) { $dias_pasados=intval($result_d->fields['dias']); $tpt_id=$operadord["vus_".$tpr."_tpt_id"]; $numsol=$result_d->fields[0]; $dias_tramite=5; $sqltpt = "SELECT ctg_tpt_dpre FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$tpt_id}' AND ctg_tpr_id = '{$result_d->fields[4]}' "; // echo "
".$sqltpt."
"; $restpt=$connectionADM->Execute($sqltpt); if (!$restpt->EOF) { $dias_tramite = intval($restpt->fields[0])+2; } // echo "
dias (".$dias_pasados.") (".$dias_tramite.") solicitud ".$numsol."
"; if ($dias_pasados > $dias_tramite){ $sqltra= "UPDATE vus_tramites_{$tpr}{$_SESSION['dtb_vus']} SET vus_{$tpr}_est_id='12', vus_{$tpr}_sta='3', vus_{$tpr}_usr='MASTER', vus_{$tpr}_dt=now() WHERE vus_{$tpr}_numsol='{$numsol}'"; // echo "
".$sqltra; $resutra=$connection->Execute($sqltra); } } $result_d->MoveNext(); } } $res->MoveNext(); } } // //////////////// F I N BORRO LOGICAMENTE SOLICITUDES CON MAS DE DIAS DE PREPARACION EN DRAFT //////////////////////// //////////////// BORRO FISICAMENTE SOLICITUDES CON MAS DE 30 DIAS DE HABER SIDO BORRADAS LOGICAMENTE //////////////////////// $deledata=0; if ($deledate==1){ $sql = "SELECT ctg_tpa_siglas, ctg_tpa_tpr_id FROM ctg_tipo_productos_areas WHERE ctg_tpa_tpr_id < '07' AND ctg_tpa_sta = '1' ORDER BY ctg_tpa_tpr_id"; //echo "$sql
"; $respuesta['sql0'] = $sql; $res=$connectionADM->Execute($sql); if (!$res->EOF) { while ( !$res->EOF ) { $ope = $res->fields; $tpr = $ope['ctg_tpa_siglas']; $_POST['tipo'] = $ope['ctg_tpa_siglas']; $sql = "SELECT ctg_tpr_id FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$ope['ctg_tpa_tpr_id']}'"; $res1=$connectionADM->Execute($sql); if (!$res1->EOF) { $_POST['ctg_tpr_id'] = $res1->fields[0]; } $sql_d = "SELECT vus_{$tpr}_numsol, vus_{$tpr}_est_dt, (CURRENT_TIMESTAMP - vus_{$tpr}_est_dt) as dias FROM vus_tramites_{$tpr} WHERE vus_{$tpr}_est_id = '12' AND (CURRENT_TIMESTAMP - vus_{$tpr}_est_dt) > '30 days' order by vus_{$tpr}_est_dt "; $result_d=$connection->Execute($sql_d); //echo "$sql
"; if (!$result_d->EOF) { while (!$result_d->EOF) { $operadord=$result_d->fields; $numsol=$operadord['vus_{$tpr}_numsol']; $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_ESTATUS\" WHERE \"vus_{$tpr}EST_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_CHKinf\" WHERE \"vus_{$tpr}CHKi_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_{$tpr}CHK_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_DCI\" WHERE \"vus_{$tpr}DCI_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_DOCs\" WHERE \"vus_{$tpr}DOC_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_EMPRESAS\" WHERE \"vus_{$tpr}EMP_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_MENSAJES\" WHERE \"vus_{$tpr}MSG_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_MUESTRAS\" WHERE \"vus_{$tpr}MUE_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_PAGOs\" WHERE \"vus_{$tpr}PAG_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_PRORROGAS\" WHERE \"vus_{$tpr}PRO_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_SEC\" WHERE \"vus_{$tpr}SEC_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_SECinf\" WHERE \"vus_{$tpr}SECi_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_FALLAS\" WHERE \"vus_{$tpr}FAL_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_formula WHERE \"vus_{$tpr}FOR_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sq4="DELETE FROM \"vus_tramites_{$tpr}{$_SESSION['dtb_vus']}_VAR\" WHERE \"vus_{$tpr}VAR_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $sql= "SELECT vus_{$tpr}_fec_cre, vus_{$tpr}_tpt_id FROM vus_tramites_{$tpr}{$_SESSION['dtb_vus']} WHERE vus_{$tpr}_numsol={$numsol}"; $resu=$connection->Execute($sql); if (!$resu->EOF) { $operad = $resu->fields; list($fecha,$hora) = explode(" ",$operad['vus_'.$tpr.'_fec_cre']); list($anio,$mes,$dia) = explode("-",$fecha); $tpt_id=$operad["vus_{$tpr}_tpt_id"]; } $e=1; $a=0; $ed=0; while($e<6){ $destination_path = "../docs/{$tpr}/".$anio."/".$mes."/".$tpt_id."_{$numsol}/"; $jpg = $tpr."_".$tpt_id."_{$numsol}_".$e.".jpg"; $tif = $tpr."_".$tpt_id."_{$numsol}_".$e.".png"; $pdf = $tpr."_".$tpt_id."_{$numsol}_".$e.".pdf"; if (is_file($destination_path.$jpg)){ $tipo='jpg'; }else{ $tipo='png'; } $target_path = $tpr."_".$tpt_id."_{$numsol}_".$e.".".$tipo.""; if (is_file($destination_path.$jpg)){ unlink ($destination_path.$jpg); } if (is_file($destination_path.$tif)){ unlink ($destination_path.$tif); } if (is_file($destination_path.$pdf)){ unlink ($destination_path.$pdf); } $e++; } /////////////// //imagenes $sql= "SELECT vus_{$tpr}_fec_cre, vus_{$tpr}_tpt_id FROM vus_tramites_{$tpr}{$_SESSION['dtb_vus']} WHERE vus_{$tpr}_numsol={$numsol}"; $resx=$connection->Execute($sql); if (!$resx->EOF) { $operx = $resx->fields; list($fecha,$hora) = explode(" ",$operx['vus_'.$tpr.'_fec_cre']); list($anio,$mes,$dia) = explode("-",$fecha); $_POST['tpt_id']=$operad['vus_'.$tpr.'_tpt_id']; } $i=0; while($i<2){ if($i==0) $tipo='jpg'; if($i==1) $tipo='png'; $c=1; while($c<6){ $img = $tpr."_".$_POST['tpt_id']."_{$_POST['numsol']}_".$c.".".$tipo.""; $local="../docs/{$tpr}/".$anio."/".$mes."/".$_POST['tpt_id']."_{$numsol}/".$img; if(is_file($local)){ unlink($local); } $c++; } $i++; } $sq4="DELETE FROM \"vus_tramites_{$tpr}\" WHERE \"vus_{$tpr}_numsol\" IN ({$numsol})"; $result = $connection->Execute ($sq4); $result_d->MoveNext(); } } $res->MoveNext(); } } } /////////////// FIN DE BORRO SOLICITUDES FISICAMENTE ///////////////////////////////////////////////////////////////////////// $file_backup = "vus_".date("D").".backup"; if ($vus_cnf_backup == 1) { $file_backup = "user_".date("Y-m-d").".backup"; $cmd = file_get_contents("backup_vus.sh"); $cmd = str_replace("#usr#",$config['db']['username'],$cmd); $cmd = str_replace("#pss#",$config['db']['password'],$cmd); $cmd = str_replace("#dbn#",$config['db']['dbname'],$cmd); $cmd = str_replace("#bck#",$file_backup,$cmd); file_put_contents("backup.sh",$cmd); $res = shell_exec ( "sh backup.sh" ); @ unlink("backup.sh"); $comm = "rm -rf *.log"; shell_exec($comm); file_put_contents($today_log,"."); /// VERIFICO VALOR DEL PETRO $petrodate = date("Y-m-d H:i:00",time()); $petrovalor = 0.00; $conn = new mysqli("172.16.0.22", "sivercc", "InhRR*2023", "citas"); // Revisamos el estado de la conexion en caso de errores. if($conn) { // echo "AVISO: Se conecto correctamente a la base de datos de CITAS
"; $var_consulta="SELECT * FROM tblPTR_valor_diario WHERE DATE(fecha_actualizacion)='".substr($petrodate,0,10)."' LIMIT 1"; $qTMP = mysqli_query($conn, $var_consulta); while ($rTMP = mysqli_fetch_assoc($qTMP)) { $valpet=$rTMP["valor_ptr"]; } mysqli_free_result($qTMP); } $petrovalor = $valpet; $sql= "SELECT * FROM ctg_config_petro WHERE DATE(ctg_pet_date)='".substr($petrodate,0,10)."' "; // echo $sql; $result=$connection->Execute($sql); if ($result->EOF) { $sql= "INSERT INTO ctg_config_petro (ctg_pet_date, ctg_pet_valor, ctg_pet_sta, ctg_pet_usr, ctg_pet_dt) VALUES ( '".$petrodate."', '".$petrovalor."', '1', '803223', now());"; $result=$connection->Execute($sql); } else { $sql= "UPDATE ctg_config_petro SET ctg_pet_date='".$petrodate."', ctg_pet_valor='".$petrovalor."', ctg_pet_sta='2', ctg_pet_usr='803223', ctg_pet_dt=now();"; $result=$connection->Execute($sql); } $conn->Close(); } $error=''; // $adm_cnf_revfalbol=0; if ($adm_cnf_revfalbol == 1) { //rechazo de tramites atrasados //necesita otros updates a adm_control y enviar email iniciarConexionADM(); $arr_label[361]="estimado"; $arr_label[584]="atentamente"; $arr_label[363]='informacion_tramite'; $arr_label[364]='informacion_general'; $arr_label[317]='tramite_no'; $arr_label[10]='tipo_producto'; $arr_label[54]='tipo_tramite'; $arr_label[14]='comentarios'; $arr_label[84]='nombre_producto'; $arr_label[1354] = 'model11_part1'; $arr_label[1355] = 'model11_part2'; $arr_label[1648] = 'model11_part21'; $arr_label[1353] = 'model11_part3'; $arr_label[1447] = 'subject_1'; $arr_label[1448] = 'subject_2'; $arr_label[1649] = 'model12_part1'; $arr_label[1650] = 'model12_part2'; $arr_lang = "361,584,363,364,317,10,54,14,84,1354,1355,1353,1447,1448,1648,1649,1650"; $sql="SELECT adm_msg_id, adm_msg_desc FROM adm_mensajes WHERE (adm_msg_id In ($arr_lang))"; //echo $sql; $result = $connectionADM->Execute ($sql); if (! $result->EOF) { while (!$result->EOF) { list ( $msg_id, $msg_lab ) = $result->fields; $label = $arr_label[$msg_id]; $arr_label[$label] = clean_string($msg_lab); $result->MoveNext(); } } $sql="SELECT * FROM adm_config"; $result = $connectionADM->Execute ($sql); if (! $result->EOF) { $reg = $result->fields; $company = $reg['sistema_siglas']; $company_email3 = $reg['adm_cnf_email3']; $soporte = "Soporte"; $company_email1 = $reg['adm_cnf_email1']; } $error=''; $sql = "SELECT ctg_tpa_siglas, ctg_tpa_tpr_id FROM ctg_tipo_productos_areas WHERE ctg_tpa_tpr_id < '07' AND ctg_tpa_siglas = 'ef' ORDER BY ctg_tpa_tpr_id"; $bccmails=''; // echo "MAIN SQL ".$sql."
"; $respuesta['sql0'] = $sql; $res=$connectionADM->Execute($sql); if (!$res->EOF) { while ( !$res->EOF ) { $ope = $res->fields; $tpr = $ope['ctg_tpa_siglas']; $_POST['tipo'] = $ope['ctg_tpa_siglas']; $sql = "SELECT ctg_tpr_id, ctg_tpr_desc, ctg_tpr_email, ctg_tpr_email1, ctg_tpr_email2, ctg_tpr_email3, ctg_tpr_email4 FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$ope['ctg_tpa_tpr_id']}'"; $res1=$connectionADM->Execute($sql); if (!$res1->EOF) { $_POST['ctg_tpr_id'] = $res1->fields[0]; $_POST['ctg_tpr_desc'] = $res1->fields[1]; $bccmails = ""; if (!empty($res1->fields[2])) $bccmails .= $res1->fields[2].","; if (!empty($res1->fields[3])) $bccmails .= $res1->fields[3].","; if (!empty($res1->fields[4])) $bccmails .= $res1->fields[4].","; if (!empty($res1->fields[5])) $bccmails .= $res1->fields[5].","; if (!empty($res1->fields[6])) $bccmails .= $res1->fields[6].","; if (!empty($bccmails)) $bccmails = substr($_POST['ctg_tpr_email'],0,-1); } $from_name = ""; $from_mail = $company_email3; $replyto = $company_email3; // REVISION DE NOTAS SCREENING Y ASSESSMENT $sql = "SELECT * FROM \"vus_tramites_{$tpr}_MENSAJES\" WHERE \"vus_{$tpr}MSG_fecven\" < CURRENT_DATE AND \"vus_{$tpr}MSG_falsta\" = '1' AND \"vus_{$tpr}MSG_tipo\" IN ('1','2') AND \"vus_{$tpr}MSG_autrej\" = '0' ORDER BY \"vus_{$tpr}MSG_numsol\" "; // echo "00.".$sql."
"; //2018-01-09 // die(); $result=$connection->Execute($sql); if (!$result->EOF) { $respuesta['sql'][] = $sql; while ( !$result->EOF ) { $operador = $result->fields; $extended=$operador["vus_".$tpr."MSG_extended"]; if ($operador["vus_{$tpr}MSG_tipo"] == 1) { $db = ""; $str = "el FALTANTE no cumplido"; } if ($operador["vus_{$tpr}MSG_tipo"] == 2) { $db = "1"; $str = "la BOLETA no cumplida";} // $extended=1; // if ($extended==0 && intval($operador["vus_{$tpr}MSG_tipo"]) == 1){ // $sql = "SELECT vus_{$tpr}_usr_id FROM vus_tramites_{$tpr} WHERE // vus_{$tpr}_numsol = '".$operador["vus_{$tpr}MSG_numsol"]."' AND // vus_{$tpr}_tpt_id = '".$operador["vus_{$tpr}MSG_tpt_id"]."' AND // vus_{$tpr}_tpr_id = '".$operador["vus_{$tpr}MSG_tpr_id"]."'"; // $result_2=$connection->Execute($sql); // echo "$sql
"; // if (!$result_2->EOF) { // $operador_2 = $result_2->fields; // } // $sql = "SELECT vus_usr_nombre, vus_usr_email FROM vus_usuarios WHERE vus_usr_id = '{$operador_2["vus_{$tpr}_usr_id"]}'"; // $res1=$connection->Execute($sql); // if (!$res1->EOF) { // $_POST['nombre'] = $res1->fields[0]; // $_POST['email'] = $res1->fields[1]; // } // $sql = "SELECT ctg_tpt_id, ctg_tpt_desc FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$operador["vus_{$tpr}MSG_tpt_id"]}' AND ctg_tpr_id = '{$operador["vus_{$tpr}MSG_tpr_id"]}'"; // $res1=$connectionADM->Execute($sql); // if (!$res1->EOF) { // $_POST['ctg_tpt_id'] = $res1->fields[0]; // $_POST['ctg_tpt_desc'] = $res1->fields[1]; // } // $fechaven = suma_fechas($operador["vus_".$tpr."MSG_fecven"],10); // $fecha_venc=$operador["vus_{$tpr}MSG_fecven"]; // $fechahoy=date("Y-m-d"); // if ( $fechaven < $fechahoy ){ //ACTUALIZO MARCA DE EXTENDIDA // $sql = "UPDATE \"vus_tramites_{$tpr}_MENSAJES\" SET // \"vus_{$tpr}MSG_extended\" = '1' // WHERE // \"vus_{$tpr}MSG_numsol\" = '".$operador["vus_{$tpr}MSG_numsol"]."' AND // \"vus_{$tpr}MSG_tpt_id\" = '".$operador["vus_{$tpr}MSG_tpt_id"]."' AND // \"vus_{$tpr}MSG_tpr_id\" = '".$operador["vus_{$tpr}MSG_tpr_id"]."' AND // \"vus_{$tpr}MSG_tipo\" = '".$operador["vus_{$tpr}MSG_tipo"]."' AND // \"vus_{$tpr}MSG_fecha\" = '".$operador["vus_{$tpr}MSG_fecha"]."'"; // $rs=$connection->Execute($sql); // $fecha_venc=$operador["vus_{$tpr}MSG_fecven"]; // $comments = "
".$arr_label['model11_part1']." ".fecha_usr($fecha_venc)."

".$arr_label['model11_part21']."

".$arr_label['model11_part3']; // /////////////////////////////// SECCION DE EMAIL DE AVISO DE LOS 10 DIAS // $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; // $body = "Date: ".date("d-m-Y")."

"; // $body .= $arr_label['estimado']." ".$_POST['nombre'].":
"; // $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']; // $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; // $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; // $body .= "
".$arr_label['nombre_producto'].":".$_POST['nomprod99']; // $body .= "

".$comments; // $body .= "

";//.$arr_label['atentamente']."
".$soporte."
".$company; // $content = email_tpl($arr_label['informacion_tramite'],$body); // $headers = "From: <$company_email3>\nReply-To: <$company_email3>\nContent-Type: text/html; charset=UTF-8"; // if (!empty($_POST['email'])) { // //$send = mail($_POST['email'].",".$_POST['ctg_tpr_email'], $subject, $content, $headers); // $envio = mail_attachment("", "", $_POST['email'], $_POST['ctg_tpr_email'], $from_name, $replyto, $subject, $content); // // if ($send == false) // // $send = mail($company_email1, "NO ENVIO:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); // // } else { // // $send = mail($company_email1, "NO EMAIL:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); // } // $sql = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod99'],$_POST['email'],$subject,$body,$send,$operador["vus_{$tpr}MSG_tipo"]); // $respuesta['body'][] = $body; // $respuesta['subject'][] = $subject; // $respuesta['headers'][] = $headers; // $respuesta['file'][] = $sql; // } // } else { /// VALIDACION DE FALTANTES if (intval($operador["vus_{$tpr}MSG_tipo"]) == 1){ $sql = "SELECT * FROM vus_tramites_{$tpr}{$db} WHERE vus_{$tpr}_numsol = '".$operador["vus_{$tpr}MSG_numsol"]."' AND vus_{$tpr}_tpt_id = '".$operador["vus_{$tpr}MSG_tpt_id"]."' AND vus_{$tpr}_tpr_id = '".$operador["vus_{$tpr}MSG_tpr_id"]."'"; $result_1=$connection->Execute($sql); // echo "$sql
"; if (!$result_1->EOF) { $operador_1 = $result_1->fields; $_POST['codigo'] = $operador_1["vus_{$tpr}_numsol"]; $_POST['nomprod99'] = $operador_1["vus_{$tpr}_nomprod"]; $sql = "SELECT ctg_tpt_id, ctg_tpt_desc FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$operador_1["vus_{$tpr}_tpt_id"]}' AND ctg_tpr_id = '{$operador_1["vus_{$tpr}_tpr_id"]}'"; $res1=$connectionADM->Execute($sql); if (!$res1->EOF) { $_POST['ctg_tpt_id'] = $res1->fields[0]; $_POST['ctg_tpt_desc'] = $res1->fields[1]; } $sql = "SELECT vus_usr_nombre, vus_usr_email FROM vus_usuarios WHERE vus_usr_id = '{$operador_1["vus_{$tpr}_usr_id"]}'"; $res1=$connection->Execute($sql); if (!$res1->EOF) { $_POST['nombre'] = $res1->fields[0]; $_POST['email'] = $res1->fields[1]; } } $fecha_venc=$operador["vus_{$tpr}MSG_fecven"]; $comments = "
".$arr_label['model11_part1'];//." ".fecha_usr($fecha_venc)."

".$arr_label['model11_part2']."

".$arr_label['model11_part3']; $sql = "UPDATE vus_tramites_{$tpr} SET vus_{$tpr}_est_id = '7', vus_{$tpr}_autrej = '1', vus_{$tpr}_est_dt = now(), vus_{$tpr}_obs = '$comments', vus_{$tpr}_sta = 2, vus_{$tpr}_usr = 'MASTER', vus_{$tpr}_dt = now() WHERE vus_{$tpr}_numsol = '".$operador["vus_{$tpr}MSG_numsol"]."' AND vus_{$tpr}_tpt_id = '".$operador["vus_{$tpr}MSG_tpt_id"]."' AND vus_{$tpr}_tpr_id = '".$operador["vus_{$tpr}MSG_tpr_id"]."'"; // echo "ACTUALIZA tramites CON FALTANTE $sql
"; $rs=$connection->Execute($sql); ?> "; $rs=$connection->Execute($sql); ?> (".$_POST['codigo'].")(".$_POST['nomprod99'].")(".$_POST['ctg_tpt_desc'].")"; $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; $body = "Date: ".date("d-m-Y")."

"; $body .= $arr_label['estimado']." ".$_POST['nombre'].":
"; $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']; $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $body .= "
".$arr_label['nombre_producto'].":".$_POST['nomprod99']; $body .= "

".$comments; $body .= "

";//.$arr_label['atentamente']."
".$soporte."
".$company; $content = email_tpl($arr_label['informacion_tramite'],$body); $headers = "From: <$company_email3>\nReply-To: <$company_email3>\nContent-Type: text/html; charset=UTF-8"; if (!empty($_POST['email'])) { // $send = mail($_POST['email'].",".$_POST['ctg_tpr_email'], $subject, $content, $headers); $send = mail_attachment("", "", $_POST['email'], $_POST['ctg_tpr_email'], $from_name, $replyto, $subject, $content); // if ($send == false) // $send = mail($company_email1, "NO ENVIO:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); // } else { // $send = mail($company_email1, "NO EMAIL:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); } $sql = insert_email($_POST['tipo'],$operador["vus_{$tpr}MSG_numsol"],$operador["vus_{$tpr}MSG_tpt_id"],$operador["vus_{$tpr}MSG_tpr_id"],$_POST['nomprod99'],$_POST['email'],$subject,$content,$send,$operador["vus_{$tpr}MSG_tipo"]); $respuesta['body'][] = $body; $respuesta['subject'][] = $subject; $respuesta['headers'][] = $headers; $respuesta['file'][] = $sql; $sqlchk = "SELECT * FROM \"vus_tramites_{$tpr}_ESTATUS\" WHERE \"vus_{$_POST['tipo']}EST_numsol\"='{$operador["vus_{$tpr}MSG_numsol"]}' AND \"vus_{$_POST['tipo']}EST_tts_id\" = '7' "; // echo "03. sql chk ".$sqlchk."
"; $resultchk=$connection->Execute($sqlchk); if ($resultchk->EOF) { $sql="INSERT INTO \"vus_tramites_{$tpr}_ESTATUS\" ( \"vus_{$_POST['tipo']}EST_numsol\", \"vus_{$_POST['tipo']}EST_tpt_id\", \"vus_{$_POST['tipo']}EST_tpr_id\", \"vus_{$_POST['tipo']}EST_tts_id\", \"vus_{$_POST['tipo']}EST_estatus_dt\", \"vus_{$_POST['tipo']}EST_obs\", \"vus_{$_POST['tipo']}EST_usr_id\", \"vus_{$_POST['tipo']}EST_sta\", \"vus_{$_POST['tipo']}EST_usr\", \"vus_{$_POST['tipo']}EST_dt\", \"vus_{$_POST['tipo']}EST_autrej\" ) VALUES ( '{$operador["vus_{$tpr}MSG_numsol"]}', '{$operador["vus_{$tpr}MSG_tpt_id"]}', '{$operador["vus_{$tpr}MSG_tpr_id"]}', '7', now(), 'Automatic', 'MASTER', '1', 'MASTER', now(), '1' );"; $result2=$connection->Execute($sql); // echo "2.".$sql."
"; //2018-01-09 } } /// VALIDACION DE BOLETAS if (intval($operador["vus_{$tpr}MSG_tipo"]) == 6) { //boleta $sql = "UPDATE vus_tramites_{$tpr}{$db} SET vus_{$tpr}_est_id = '7', vus_{$tpr}_autrej = '1', vus_{$tpr}_est_dt = now(), vus_{$tpr}_obs = '$comments', vus_{$tpr}_sta = 2, vus_{$tpr}_usr = 'MASTER', vus_{$tpr}_dt = now() WHERE vus_{$tpr}_numsol = '".$operador["vus_{$tpr}MSG_numsol"]."' AND vus_{$tpr}_tpt_id = '".$operador["vus_{$tpr}MSG_tpt_id"]."' AND vus_{$tpr}_tpr_id = '".$operador["vus_{$tpr}MSG_tpr_id"]."'"; $rs=$connection->Execute($sql); //echo "$sql
"; ?> Execute($sql); $sql="INSERT INTO \"vus_tramites_{$tpr}_ESTATUS\" ( \"vus_{$_POST['tipo']}EST_numsol\", \"vus_{$_POST['tipo']}EST_tpt_id\", \"vus_{$_POST['tipo']}EST_tpr_id\", \"vus_{$_POST['tipo']}EST_tts_id\", \"vus_{$_POST['tipo']}EST_estatus_dt\", \"vus_{$_POST['tipo']}EST_obs\", \"vus_{$_POST['tipo']}EST_usr_id\", \"vus_{$_POST['tipo']}EST_sta\", \"vus_{$_POST['tipo']}EST_usr\", \"vus_{$_POST['tipo']}EST_dt\", \"vus_{$_POST['tipo']}EST_autrej\" ) VALUES ( '{$operador["vus_{$tpr}MSG_numsol"]}', '{$operador["vus_{$tpr}MSG_tpt_id"]}', '{$operador["vus_{$tpr}MSG_tpr_id"]}', '7', now(), 'Automatic', 'MASTER', '1', 'MASTER', now(), '1' );"; $result2=$connection->Execute($sql); // echo "2.".$sql."
"; //2018-01-09 /////////////////////////////// SECCION DE EMAIL /////////////////////////////////////////////////// $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; $body = "Date: ".date("d-m-Y")."

"; $body .= $arr_label['estimado']." ".$_POST['nombre'].":
"; $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']; $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $body .= "
".$arr_label['nombre_producto'].":".$_POST['nomprod99']; $body .= "

".$comments; $body .= "

";//.$arr_label['atentamente']."
".$soporte."
".$company; $content = email_tpl($arr_label['informacion_tramite'],$body); $headers = "From: <$company_email3>\nReply-To: <$company_email3>\nContent-Type: text/html; charset=UTF-8"; if (!empty($_POST['email'])) { // $send = mail($_POST['email'].",".$_POST['ctg_tpr_email'], $subject, $content, $headers); $send = mail_attachment("", "", $_POST['email'], $_POST['ctg_tpr_email'], $from_name, $replyto, $subject, $content); // if ($send == false) // $send = mail($company_email1, "NO ENVIO:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); // } else { // $send = mail($company_email1, "NO EMAIL:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); } // $sql = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod99'],$_POST['email'],$subject,$body,$send,$operador["vus_{$tpr}MSG_tipo"]); $respuesta['body'][] = $body; $respuesta['subject'][] = $subject; $respuesta['headers'][] = $headers; $respuesta['file'][] = $sql; } $result->MoveNext(); } } $error=''; // echo "// REVISION DE DOSSIER FISICO RECIBIDO ///

"; $sql = "SELECT * FROM vus_tramites_{$tpr}1 WHERE vus_{$tpr}_fislim < CURRENT_DATE AND vus_{$tpr}_est_id = '15' ORDER BY vus_{$tpr}_numsol "; // echo "01.".$sql."
"; //2018-01-09 $result=$connection->Execute($sql); if (!$result->EOF) { $respuesta['sql'][] = $sql; while ( !$result->EOF ) { $operador = $result->fields; $_POST['codigo'] = $operador["vus_{$tpr}_numsol"]; $_POST['nomprod99'] = $operador["vus_{$tpr}_nomprod"]; $sql = "SELECT ctg_tpt_id, ctg_tpt_desc FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$operador["vus_{$tpr}_tpt_id"]}' AND ctg_tpr_id = '{$operador["vus_{$tpr}_tpr_id"]}'"; $res1=$connectionADM->Execute($sql); if (!$res1->EOF) { $_POST['ctg_tpt_id'] = $res1->fields[0]; $_POST['ctg_tpt_desc'] = $res1->fields[1]; } $sql = "SELECT vus_usr_nombre, vus_usr_email FROM vus_usuarios WHERE vus_usr_id = '{$operador["vus_{$tpr}_usr_id"]}'"; $res1=$connection->Execute($sql); if (!$res1->EOF) { $_POST['nombre'] = $res1->fields[0]; $_POST['email'] = $res1->fields[1]; } $fecha_fislim=$operador["vus_{$tpr}_fislim"]; $comments = "
".$arr_label['model12_part1']." ".fecha_usr($fecha_fislim)."

".$arr_label['model12_part2']."

".$arr_label['model11_part3']; $sqlchk = "SELECT * FROM \"vus_tramites_{$tpr}_ESTATUS\" WHERE \"vus_{$_POST['tipo']}EST_numsol\"='{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}EST_tts_id\" = '7' "; // echo "dossier sql check
$sqlchk
"; $resultchk=$connection->Execute($sqlchk); if ($resultchk->EOF) { $sql = "UPDATE vus_tramites_{$tpr}{$db} SET vus_{$tpr}_est_id = '7', vus_{$tpr}_autrej = '1', vus_{$tpr}_est_dt = now(), vus_{$tpr}_obs = '$comments', vus_{$tpr}_sta = 2, vus_{$tpr}_usr = 'MASTER', vus_{$tpr}_dt = now() WHERE vus_{$tpr}_numsol = '".$operador["vus_{$tpr}_numsol"]."' AND vus_{$tpr}_tpt_id = '".$operador["vus_{$tpr}_tpt_id"]."' AND vus_{$tpr}_tpr_id = '".$operador["vus_{$tpr}_tpr_id"]."'"; $rs=$connection->Execute($sql); // echo "actualizo por dossier fisico no enviado
$sql
"; $sql="INSERT INTO \"vus_tramites_{$tpr}_ESTATUS\" ( \"vus_{$_POST['tipo']}EST_numsol\", \"vus_{$_POST['tipo']}EST_tpt_id\", \"vus_{$_POST['tipo']}EST_tpr_id\", \"vus_{$_POST['tipo']}EST_tts_id\", \"vus_{$_POST['tipo']}EST_estatus_dt\", \"vus_{$_POST['tipo']}EST_obs\", \"vus_{$_POST['tipo']}EST_usr_id\", \"vus_{$_POST['tipo']}EST_sta\", \"vus_{$_POST['tipo']}EST_usr\", \"vus_{$_POST['tipo']}EST_dt\", \"vus_{$_POST['tipo']}EST_fislim\" ) VALUES ( '{$_POST['codigo']}', '{$operador["vus_{$tpr}_tpt_id"]}', '{$operador["vus_{$tpr}_tpr_id"]}', '7', now(), 'Automatic', 'MASTER', '1', 'MASTER', now(), '1' );"; $result4=$connection->Execute($sql); // echo "2.".$sql."
"; //2018-01-09 /////////////////////////////// SECCION DE EMAIL /////////////////////////////////////////////////// // echo "
(".$_POST['codigo'].")(".$_POST['nomprod99'].")(".$_POST['ctg_tpt_desc'].")"; $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; $body = "Date: ".date("d-m-Y")."

"; $body .= $arr_label['estimado']." ".$_POST['nombre'].":
"; $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']; $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $body .= "
".$arr_label['nombre_producto'].":".$_POST['nomprod99']; $body .= "

".$comments; $body .= "

";//.$arr_label['atentamente']."
".$soporte."
".$company; $content = email_tpl($arr_label['informacion_tramite'],$body); $headers = "From: <$company_email3>\nReply-To: <$company_email3>\nContent-Type: text/html; charset=UTF-8"; if (!empty($_POST['email'])) { $send = mail_attachment("", "", $_POST['email'], $_POST['ctg_tpr_email'], $from_name, $replyto, $subject, $content); // $send = mail($_POST['email'].",".$_POST['ctg_tpr_email'], $subject, $content, $headers); // if ($send == false) // $send = mail($company_email1, "NO ENVIO:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); // } else { // $send = mail($company_email1, "NO EMAIL:".$subject, "Email:{$_POST['email']}; Contactos:{$_POST['ctg_tpr_email']}
".$content, $headers); } $sql = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod99'],$_POST['email'],$subject,$content,$send,'0'); $respuesta['body'][] = $body; $respuesta['subject'][] = $subject; $respuesta['headers'][] = $headers; $respuesta['file'][] = $sql; } $result->MoveNext(); } } $res->MoveNext(); } } $estado=1; file_put_contents($today_log,json_encode($respuesta)); } } } } else { $sq1 = "SELECT vus_solreg_estatus FROM vus_usuarios_solicitud_registro WHERE (UPPER(vus_solreg_alias) = '".trim(strtoupper($_POST['usuario_login']))."') AND (vus_solreg_password = '".trim($_POST['clave_login'])."')"; //echo $sq1."(2)"; //0:no evaluado 1:autorizado 2:rechazado 3:borrada $resul = $connection->Execute ($sq1); if (!$resul->EOF) { $operador = $resul->fields; $estado = $operador['vus_solreg_estatus'] + 5; } } $respuesta['stat'] = $estado; echo json_encode($respuesta); die(); } if ($_POST['recuperar'] == 1) { $respuesta = array(); $estado = '0'; $headers = "From: <".$company_email3.">\nReply-To: PASSWORD RECOVERTITULO <".$company_email3.">\nContent-Type: text/html; charset=UTF-8"; if ($_POST['cuenta'] == 2) $sql = "SELECT * FROM vus_usuarios WHERE vus_usr_tipcta = ".$_POST['cuenta']." AND UPPER(vus_usr_alias) = '".trim(strtoupper($_POST['alias']))."' AND UPPER(vus_usr_emp_rif) = '".trim(strtoupper($_POST['ide']))."' "; else $sql = "SELECT * FROM vus_usuarios WHERE vus_usr_tipcta = ".$_POST['cuenta']." AND UPPER(vus_usr_alias) = '".trim(strtoupper($_POST['alias']))."' AND UPPER(vus_usr_ci) = '".trim(strtoupper($_POST['ide']))."' "; // echo $sql; $result = $connection->Execute ( $sql ); if (!$resul->EOF) { $operador = $result->fields; $estado = $operador['vus_usr_estatus']; if ($estado == 1) { $subject = $arr_label['informacion_acceso']; $body.= "".$arr_label['estimado']." ".$operador['vus_usr_nombre'].",

Respondiendo a su solicitud, estamos enviando credenciales de acceso al sistema.

Si no envió dicha solicitud, háganoslo saber ($company_email3 ) y cambie su contraseña.

". $arr_label['id_usuario']." :".$operador['vus_usr_alias']."
". $arr_label['contrasena']." :".$operador['vus_usr_password']."

"; $tpr_email = ""; if (trim($operador['vus_usr_email']) != "") $tpr_email = trim($operador['vus_usr_email']); $content = email_tpl($arr_label['informacion_acceso'],$body); // $body = ""; // $body .= ""; // $body .= ""; // $body .= "
".$arr_label['nombre'].":".$_POST['nombre']." - ".$user_alias." //
".$arr_label['fecha'].":".date("d-m-Y")." //
".$arr_label['tel'].":".$_POST['tel']." //
".$arr_label['email'].":".$_POST['email']." //
".$arr_label['unidad'].":".$tpr_id." - ".$tpr_desc." //
".$arr_label['tramite_no'].":".$_POST['appnr']." //
".$arr_label['nombre_producto'].":".$_POST['prodname']; // $body .= "
".$arr_label['asunto']."
".$_POST['asunto']."
"; $content1 = email_tpl_contact($arr_label['informacion_acceso'],$body,"../"); // echo $content1; $filename =""; $file = ""; $from_name = ""; $from_mail = $company_email3; $replyto = $company_email3; // $subject = $arr_label['contacto']." ".$_POST['nombre']." ".date("F j, Y, g:i a"); if ($tpr_email != ""){ $envio = mail_attachment($filename, $file, $tpr_email, $from_mail, $from_name, $replyto, $subject, $content1); // if ($email != ""){ // $envio = mail($email, $subject, $content, $headers); } } } $respuesta['sql'] = $sql; $respuesta['estado'] = $estado; $respuesta['email'] = $email; $respuesta['body'] = $body; echo json_encode($respuesta); die(); } ?>