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(); } } $sq12="SELECT ctg_ttc_id, ctg_ttc_desc FROM ctg_tipo_tramites_categorias WHERE ctg_tpt_id='".$tpt_id."' AND ctg_tpr_id='".$tpr_id."'"; // echo "tte id (".$_POST['tte_id']."))"; switch ($tte_id) { case '02': $selecct="SELECT DISTINCT \"vus_".$tipo_pro."CHK_ttc_id\" FROM \"vus_tramites_{$tipo_pro}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_".$tipo_pro."CHK_numsol\"='".$solnum."' AND \"vus_".$tipo_pro."CHK_tpt_id\"='".$tpt_id."' AND \"vus_".$tipo_pro."CHK_tpr_id\"='".$tpr_id."' AND (\"vus_".$tipo_pro."CHK_res4_obs\" IS NOT NULL AND \"vus_".$tipo_pro."CHK_res4_obs\" <> '') ORDER BY \"vus_".$tipo_pro."CHK_ttc_id\""; break; case '03': $selecct="SELECT DISTINCT \"vus_".$tipo_pro."CHK_ttc_id\" FROM \"vus_tramites_{$tipo_pro}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_".$tipo_pro."CHK_numsol\"='".$solnum."' AND \"vus_".$tipo_pro."CHK_tpt_id\"='".$tpt_id."' AND \"vus_".$tipo_pro."CHK_tpr_id\"='".$tpr_id."' AND (\"vus_".$tipo_pro."CHK_res5_obs\" IS NOT NULL AND \"vus_".$tipo_pro."CHK_res5_obs\" <> '') ORDER BY \"vus_".$tipo_pro."CHK_ttc_id\""; break; case '04': $selecct="SELECT DISTINCT \"vus_".$tipo_pro."CHK_ttc_id\" FROM \"vus_tramites_{$tipo_pro}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_".$tipo_pro."CHK_numsol\"='".$solnum."' AND \"vus_".$tipo_pro."CHK_tpt_id\"='".$tpt_id."' AND \"vus_".$tipo_pro."CHK_tpr_id\"='".$tpr_id."' AND (\"vus_".$tipo_pro."CHK_res6_obs\" IS NOT NULL AND \"vus_".$tipo_pro."CHK_res6_obs\" <> '') ORDER BY \"vus_".$tipo_pro."CHK_ttc_id\""; break; default: $selecct="SELECT DISTINCT \"vus_".$tipo_pro."CHK_ttc_id\" FROM \"vus_tramites_{$tipo_pro}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_".$tipo_pro."CHK_numsol\"='".$solnum."' AND \"vus_".$tipo_pro."CHK_tpt_id\"='".$tpt_id."' AND \"vus_".$tipo_pro."CHK_tpr_id\"='".$tpr_id."' ORDER BY \"vus_".$tipo_pro."CHK_ttc_id\""; break; } // echo $selecct."
"; $cates=""; $resultt=$connection->Execute($selecct); if (!$resultt->EOF){ while (!$resultt->EOF) { // echo "[".$resultt->fields[0]."]"; if (!empty($cates)) $cates .= ",'".$resultt->fields[0]."'"; else $cates .= "'".$resultt->fields[0]."'"; $resultt->MoveNext(); } $sq12.=" AND ctg_ttc_eva IS NOT NULL AND ctg_ttc_id IN (".$cates.")"; } else { $sq12.=" AND ctg_ttc_eva IS NOT NULL AND substr(ctg_ttc_id,1,3) <> 'LOQ'"; } // echo "((".$sq12.")"; $sq12.=" ORDER BY ctg_ttc_desc"; ?> = '{$respuesta['first']} 00:00:00' AND vus_{$_POST['tipo_pro']}_fec_env <= '{$respuesta['last']} 23:59:59'"; $respuesta['sql'] = $sql; $result=$connection->Execute($sql); $respuesta['count'] = intval($result->fields[0]); echo json_encode($respuesta); die(); } if ($_POST['op'] == "hay_vus_tramites2") { ob_clean(); $respuesta = array(); $respuesta['res'] = 0; iniciarConexionVUS(); $sql = "SELECT vus_{$_POST['tipo']}_numreg FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_{$_POST['tipo']}_numsol='{$_POST['numsol']}' AND vus_{$_POST['tipo']}_tpt_id='{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id='{$_POST['ctg_tpr_id']}'"; //echo $sql."
"; $respuesta['sql'] = $sql; $ret=$connectionVUS->Execute($sql); if (!$ret->EOF) { $respuesta['res'] = 1; } echo json_encode($respuesta); die(); } if ($_POST['op'] == "valida_doc") { ob_clean(); $respuesta = array(); $respuesta['res'] = 0; iniciarConexionVUS(); //numreg tipo prod + tipo tramite (AO) + cat (DR) + id del formato ( 01 ) ( 01.1 ) //adm_productos_{$_POST['tipo']}_DOCs $sql = "SELECT * FROM ctg_tipo_tramites_documentos WHERE ctg_ttd_id = '{$_POST['id']}' AND ctg_ttc_id = '{$_POST['ttc_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' LIMIT 1"; $ret=$connection->Execute($sql); $respuesta['sql1'] = $sql; if (!$ret->EOF) { $respuesta['res'] = 1; } echo json_encode($respuesta); die(); } if ($_POST['op'] == "CambiosPostRegistro") { //caso especifico resultado_final_4_4.php ob_clean(); $respuesta = array(); //$_POST['adm_con_certxt1'] = htmlspecialchars($_POST['adm_con_certxt1']); //$_POST['adm_con_certxt2'] = htmlspecialchars($_POST['adm_con_certxt2']); $sql="UPDATE adm_control_{$_POST['tipo']}1 SET adm_con_certxt1 = '{$_POST['adm_con_certxt1']}', adm_con_certxt2 = '{$_POST['adm_con_certxt2']}', adm_con_cerlins = '{$_POST['adm_con_cerlins']}' WHERE adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_con_tpr_id = '{$_POST['ctg_tpr_id']}'"; //echo $sql."
"; $result = $connection->Execute ($sql); $respuesta['sql'] = $sql; $respuesta['affected'] = $connection->Affected_Rows(); $respuesta['error'] = $connection->ErrorMsg(); /* $respuesta['token'] = strtotime("now"); $texto = $_POST["per"] . "**||**" . $_POST["con"]; file_put_contents($respuesta['token'],$texto); */ echo json_encode($respuesta); die(); } if ($_POST['op'] == "certificado_docname") { ob_clean(); $respuesta = array(); $respuesta['nombre'] = ""; $respuesta['parte'] = ""; iniciarConexionVUS(); $sql = "SELECT vus_{$_POST['tipo']}_numreg, vus_{$_POST['tipo']}_fec_cre, vus_{$_POST['tipo']}_est_id FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_{$_POST['tipo']}_numsol='{$_POST['numsol']}'"; //echo $sql."
"; $ret=$connectionVUS->Execute($sql); if ($ret->fields["vus_{$_POST['tipo']}_fec_cre"]) { list($fecha,$hora) = explode(" ",$ret->fields["vus_{$_POST['tipo']}_fec_cre"]); list($anio,$mes,$dia) = explode("-",$fecha); $numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"]; } $respuesta['numreg'] = $numreg; $parte = 1; $adm_cod_tmf_cor = 1; $registro = ""; $sql="SELECT * FROM ctg_tipo_tramites_formato WHERE ctg_tpd_id = '{$_POST['id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['tpt_id']}'"; //echo $sql."
"; $result_=$connection->Execute($sql); if (!$result_->EOF) { $sql = "SELECT ctg_fmt_sig, ctg_fmt_cor, ctg_fmt_nom, ctg_fmt_fec, ctg_fmt_ver FROM ctg_tipo_formatos WHERE ctg_fmt_id = '{$_POST['id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; $result_=$connection->Execute($sql); if (!$result_->EOF) { $adm_cod_tmf_cor = intval($result_->fields["ctg_fmt_cor"]) + 1; $respuesta['registro'] = "{$result_->fields["ctg_fmt_sig"]}
{$result_->fields["ctg_fmt_fec"]}
{$result_->fields["ctg_fmt_ver"]}"; } } $path = ""; //if ($_POST["ip_int"] != "190.56.146.14") //$path = "/var/www"; 2015-10-14 if ($_POST['EsCertificado'] == 1) { $path .= "/{$_POST['location_adm']}/docs/{$_POST['tipo']}"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); $path .= "/$numreg"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); $path .= "/0"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); $sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_DOCs WHERE adm_cod_numreg = '$numreg' AND adm_cod_numsol = '{$_POST['numsol']}' AND adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '{$_POST['ttc_id']}' AND adm_cod_tmf_id = '{$_POST['id']}'"; //echo $sql."
"; //$respuesta['este_es'] = $sql; $respuesta['sql'] = $sql; $result=$connection->Execute($sql); if (intval($result->fields["adm_cod_part"]) > 0) { $parte = intval($result->fields["adm_cod_part"]); $adm_cod_tmf_cor = $result->fields["adm_cod_tmf_cor"]; } else { $sql = "SELECT \"adm_{$_POST['tipo']}DOC_part\" FROM \"ctg_productos_{$_POST['tipo']}_DOCs\" WHERE \"adm_{$_POST['tipo']}DOC_numreg\" = '$numreg' AND \"adm_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"adm_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"adm_{$_POST['tipo']}DOC_numsol\" = '0' AND \"adm_{$_POST['tipo']}DOC_id\" = '{$_POST['id']}' ORDER BY \"adm_{$_POST['tipo']}DOC_part\" DESC LIMIT 1"; //echo $sql."
"; $ret=$connection->Execute($sql); $respuesta['sql1'] = $sql; if (!$ret->EOF) { $adm_cod_part = intval($ret->fields["adm_{$_POST['tipo']}DOC_part"])+1; } } $respuesta['path'] = "$path"; $respuesta['nombre'] = "{$_POST['tipo']}_{$numreg}_{$_POST['ttc_id']}-{$_POST['id']}_$parte.pdf"; } else { ///docsserver/prodali/docs_tramites/pa/2015/07/ $path .= "/".str_replace("adm", "", $_POST['location_adm']); $sql="SELECT ctg_tpr_resu_loc FROM ctg_tipo_productos WHERE ctg_tpr_id='{$_POST['ctg_tpr_id']}'"; //echo $sql."
"; $respuesta['sql2'] = $sql; $row=$connection->Execute($sql); if (!$row->EOF) { $path .= $row->fields['ctg_tpr_resu_loc']; } $path .= "docs_tramites"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); $path .= "/{$_POST['tipo']}"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); //echo "($files_path)
"; $path .= "/$anio"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); //echo "($files_path)
"; $path .= "/$mes"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); //echo "($files_path)
"; $path .= "/{$_POST['ctg_tpt_id']}_{$_POST['numsol']}"; @ mkdir("/var/www$path",7777); shell_exec("chmod 7777 /var/www$path"); //echo "($files_path)
"; $respuesta['path'] = "$path"; $respuesta['nombre'] = "{$_POST['tipo']}_{$_POST['ctg_tpt_id']}_{$_POST['numsol']}_{$_POST['ttc_id']}_{$_POST['id']}_1.pdf"; } $respuesta['parte'] = $parte; $respuesta['adm_cod_tmf_cor'] = $adm_cod_tmf_cor; $respuesta['is_dir'] = is_dir("/var/www$path"); echo json_encode($respuesta); die(); } if ($_POST['op'] == "certificado_docname_save") { ob_clean(); $respuesta = array(); $respuesta['error'] = 0; $inserta = false; $update = false; function tamano_archivo($peso, $decimales = 2 ) { $clase = array(" Bytes", " KB", " MB", " GB", " TB"); try { $res = round($peso/pow(1024,($i = floor(log($peso, 1024)))),$decimales ); //$clase[$i]; } catch (Exception $e) { $res = 0; } return $res; } if (is_file("/var/www".$_POST['path']."/".$_POST['name'])) $peso_archivo = filesize("/var/www".$_POST['path']."/".$_POST['name']); // obtenemos su peso en bytes else { $respuesta['file'] = "/var/www".$_POST['path']."/".$_POST['name']; $respuesta['error'] = 1; echo json_encode($respuesta); die(); } $_POST['size'] = tamano_archivo($peso_archivo); if ($_POST['EsCertificado'] == 1) { //$_POST['numsol'] = 0; $sql = "SELECT * FROM \"ctg_productos_{$_POST['tipo']}_DOCs\" WHERE \"adm_{$_POST['tipo']}DOC_numreg\" = '{$_POST['numreg']}' AND \"adm_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"adm_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"adm_{$_POST['tipo']}DOC_numsol\" = '0' AND \"adm_{$_POST['tipo']}DOC_id\" = '{$_POST['id']}' AND \"adm_{$_POST['tipo']}DOC_part\" = '{$_POST['parte']}'"; //echo $sql."
"; $respuesta['sql'] = $sql; $result=$connection->Execute($sql); if (!$result->EOF) { $sql = "UPDATE \"ctg_productos_{$_POST['tipo']}_DOCs\" SET \"adm_{$_POST['tipo']}DOC_doc_name\" = '{$_POST['name']}', \"adm_{$_POST['tipo']}DOC_doc_desc\" = '{$_POST['name_desc']}', \"adm_{$_POST['tipo']}DOC_docubi\" = '{$_POST['path']}', \"adm_{$_POST['tipo']}DOC_size\" = '{$_POST['size']}', \"adm_{$_POST['tipo']}DOC_sta\" = 2, \"adm_{$_POST['tipo']}DOC_usr\" = '{$_SESSION['ADMusuario_id']}', \"adm_{$_POST['tipo']}DOC_dt\" = now() WHERE \"adm_{$_POST['tipo']}DOC_numreg\" = '{$_POST['numreg']}' AND \"adm_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"adm_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"adm_{$_POST['tipo']}DOC_numsol\" = '0' AND \"adm_{$_POST['tipo']}DOC_id\" = '{$_POST['id']}' AND \"adm_{$_POST['tipo']}DOC_part\" = '{$_POST['parte']}'"; $respuesta['sql1'] = $sql; $result=$connection->Execute($sql); $respuesta['error1'] = $connection->ErrorMsg(); $respuesta['affected1'] = $connection->Affected_Rows(); if ($respuesta['affected1'] == 1) $update = true; } else { $sql = "INSERT INTO \"ctg_productos_{$_POST['tipo']}_DOCs\" ( \"adm_{$_POST['tipo']}DOC_numreg\", \"adm_{$_POST['tipo']}DOC_tpt_id\", \"adm_{$_POST['tipo']}DOC_tpr_id\", \"adm_{$_POST['tipo']}DOC_ttc_id\", \"adm_{$_POST['tipo']}DOC_numsol\", \"adm_{$_POST['tipo']}DOC_id\", \"adm_{$_POST['tipo']}DOC_part\", \"adm_{$_POST['tipo']}DOC_doc_name\", \"adm_{$_POST['tipo']}DOC_doc_desc\", \"adm_{$_POST['tipo']}DOC_docubi\", \"adm_{$_POST['tipo']}DOC_size\", \"adm_{$_POST['tipo']}DOC_sta\", \"adm_{$_POST['tipo']}DOC_usr\", \"adm_{$_POST['tipo']}DOC_dt\" ) VALUES ( '{$_POST['numreg']}','{$_POST['ctg_tpt_id']}','{$_POST['ctg_tpr_id']}','{$_POST['ttc_id']}','0','{$_POST['id']}','{$_POST['parte']}','{$_POST['name']}','{$_POST['name_desc']}','{$_POST['path']}','{$_POST['size']}','1','{$_SESSION['ADMusuario_id']}',now())"; $respuesta['sql1'] = $sql; $result=$connection->Execute($sql); $respuesta['error1'] = $connection->ErrorMsg(); $respuesta['affected1'] = $connection->Affected_Rows(); if ($respuesta['affected1'] == 1) $inserta = true; } } else { iniciarConexionVUS(); $sql = "SELECT * FROM \"vus_tramites_{$_POST['tipo']}2_DOCs\" WHERE \"vus_{$_POST['tipo']}DOC_numsol\" = '{$_POST['numsol']}' AND \"vus_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"vus_{$_POST['tipo']}DOC_ttd_id\" = '{$_POST['id']}' AND \"vus_{$_POST['tipo']}DOC_ttd_part\" = '{$_POST['parte']}'"; $respuesta['sql'] = $sql; $result=$connectionVUS->Execute($sql); if (!$result->EOF) { $sql = "UPDATE \"vus_tramites_{$_POST['tipo']}2_DOCs\" SET \"vus_{$_POST['tipo']}DOC_doc_name\" = '{$_POST['name']}', \"vus_{$_POST['tipo']}DOC_doc_desc\" = '{$_POST['name_desc']}', \"vus_{$_POST['tipo']}DOC_docubi\" = '{$_POST['path']}', \"vus_{$_POST['tipo']}DOC_size\" = '{$_POST['size']}', \"vus_{$_POST['tipo']}DOC_sta\" = '2', \"vus_{$_POST['tipo']}DOC_usr\" = '{$_SESSION['ADMusuario_id']}', \"vus_{$_POST['tipo']}DOC_dt\" = now() WHERE \"vus_{$_POST['tipo']}DOC_numsol\" = '{$_POST['numsol']}' AND \"vus_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"vus_{$_POST['tipo']}DOC_ttd_id\" = '{$_POST['id']}' AND \"vus_{$_POST['tipo']}DOC_ttd_part\" = '{$_POST['parte']}'"; $respuesta['sql2'] = $sql; $result=$connectionVUS->Execute($sql); $respuesta['error2'] = $connectionVUS->ErrorMsg(); $respuesta['affected2'] = $connectionVUS->Affected_Rows(); if ($respuesta['affected2'] == 1) $update = true; $respuesta['update'] = $update; } else { $sql = "INSERT INTO \"vus_tramites_{$_POST['tipo']}2_DOCs\" ( \"vus_{$_POST['tipo']}DOC_numsol\", \"vus_{$_POST['tipo']}DOC_tpt_id\", \"vus_{$_POST['tipo']}DOC_tpr_id\", \"vus_{$_POST['tipo']}DOC_ttc_id\", \"vus_{$_POST['tipo']}DOC_ttd_id\", \"vus_{$_POST['tipo']}DOC_ttd_part\", \"vus_{$_POST['tipo']}DOC_doc_name\", \"vus_{$_POST['tipo']}DOC_doc_desc\", \"vus_{$_POST['tipo']}DOC_docubi\", \"vus_{$_POST['tipo']}DOC_size\", \"vus_{$_POST['tipo']}DOC_sta\", \"vus_{$_POST['tipo']}DOC_usr\", \"vus_{$_POST['tipo']}DOC_dt\" ) VALUES ( '{$_POST['numsol']}','{$_POST['ctg_tpt_id']}','{$_POST['ctg_tpr_id']}','{$_POST['ttc_id']}','{$_POST['id']}','{$_POST['parte']}','{$_POST['name']}','{$_POST['name_desc']}','{$_POST['path']}','{$_POST['size']}','1','{$_SESSION['ADMusuario_id']}',now()) "; $respuesta['sql2'] = $sql; $result=$connectionVUS->Execute($sql); $respuesta['error2'] = $connectionVUS->ErrorMsg(); $respuesta['affected2'] = $connectionVUS->Affected_Rows(); if ($respuesta['affected2'] == 1) $inserta = true; } } if ($inserta == true) { $sql = "INSERT INTO adm_control_{$_POST['tipo']}1_docs ( adm_cod_numsol, adm_cod_numreg, adm_cod_tpr_id, adm_cod_tpt_id, adm_cod_ttc_id, adm_cod_tmf_id, adm_cod_tmf_cor, adm_cod_part, adm_cod_path, adm_cod_file, adm_cod_sta, adm_cod_usr, adm_cod_dt ) VALUES ( '{$_POST['numsol']}','{$_POST['numreg']}','{$_POST['ctg_tpr_id']}','{$_POST['ctg_tpt_id']}','{$_POST['ttc_id']}','{$_POST['id']}','{$_POST['adm_cod_tmf_cor']}','{$_POST['parte']}','{$_POST['path']}','{$_POST['name']}','1','{$_SESSION['ADMusuario_id']}',now())"; $respuesta['sql3'] = $sql; $result=$connection->Execute($sql); $respuesta['error3'] = $connection->ErrorMsg(); $respuesta['affected3'] = $connection->Affected_Rows(); $sql = "UPDATE ctg_tipo_formatos SET ctg_fmt_cor = {$_POST['adm_cod_tmf_cor']} WHERE ctg_fmt_id = '{$_POST['id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; $respuesta['sql4'] = $sql; $result=$connection->Execute($sql); $respuesta['error4'] = $connection->ErrorMsg(); $respuesta['affected4'] = $connection->Affected_Rows(); } if ($update == true) { $sql = "UPDATE adm_control_{$_POST['tipo']}1_docs SET adm_cod_path = '{$_POST['path']}', adm_cod_file = '{$_POST['name']}', adm_cod_sta = '2', adm_cod_usr = '{$_SESSION['ADMusuario_id']}', adm_cod_dt = now() WHERE adm_cod_numsol = '{$_POST['numsol']}' AND adm_cod_numreg = '{$_POST['numreg']}' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_cod_ttc_id = '{$_POST['ttc_id']}' AND adm_cod_tmf_id = '{$_POST['id']}' AND adm_cod_part = '{$_POST['parte']}' "; $respuesta['sql3'] = $sql; $result=$connection->Execute($sql); $respuesta['error3'] = $connection->ErrorMsg(); $respuesta['affected3'] = $connection->Affected_Rows(); } echo json_encode($respuesta); die(); } if ($_POST['op'] == "certificado_send") { ob_clean(); $respuesta = array(); $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 = '{$_POST['ctg_tpr_id']}'"; $respuesta["sql1"] = $sql; $res1=$connection->Execute($sql); if (!$res1->EOF) { $_POST['ctg_tpr_desc'] = $res1->fields[1]; $_POST['ctg_tpr_email'] = ""; if (!empty($res1->fields[2])) $_POST['ctg_tpr_email'] .= $res1->fields[2].","; if (!empty($res1->fields[3])) $_POST['ctg_tpr_email'] .= $res1->fields[3].","; if (!empty($res1->fields[4])) $_POST['ctg_tpr_email'] .= $res1->fields[4].","; if (!empty($res1->fields[5])) $_POST['ctg_tpr_email'] .= $res1->fields[5].","; if (!empty($res1->fields[6])) $_POST['ctg_tpr_email'] .= $res1->fields[6].","; if (!empty($_POST['ctg_tpr_email'])) $_POST['ctg_tpr_email'] = substr($_POST['ctg_tpr_email'],0,-1); } iniciarConexionVUS(); $sql = "SELECT * FROM vus_tramites_{$_POST["tipo"]}2 WHERE vus_{$_POST["tipo"]}_numsol = '".$_POST["codigo"]."' AND vus_{$_POST["tipo"]}_tpt_id = '".$_POST["tpt_id"]."' AND vus_{$_POST["tipo"]}_tpr_id = '".$_POST["ctg_tpr_id"]."'"; //echo "$sql
"; $respuesta["sql2"] = $sql; $result_1=$connectionVUS->Execute($sql); if (!$result_1->EOF) { $operador_1 = $result_1->fields; $_POST['nomprod'] = $operador_1["vus_{$_POST["tipo"]}_nomprod"]; $sql = "SELECT ctg_tpt_id, ctg_tpt_desc FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$operador_1["vus_{$_POST["tipo"]}_tpt_id"]}' AND ctg_tpr_id = '{$operador_1["vus_{$_POST["tipo"]}_tpr_id"]}'"; $respuesta["sql3"] = $sql; $res1=$connection->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_{$_POST["tipo"]}_usr_id"]}'"; $respuesta["sql4"] = $sql; $res1=$connectionVUS->Execute($sql); $respuesta["sql2"] = $sql; if (!$res1->EOF) { $_POST['nombre'] = $res1->fields[0]; $_POST['email'] = $res1->fields[1]; } } //lenguaje para email $arr_label[317]='tramite_no'; $arr_label[10]='tipo_producto'; $arr_label[54]='tipo_tramite'; $arr_label[316]='doc_nombre'; $arr_label[14]='comentarios'; $arr_label[324]='parte'; $arr_label[366]='cambio_status'; $arr_label[367]='faltante'; $arr_label[368]='se_cambio_status'; $arr_label[369]='a'; $arr_label[84]='nombre_producto'; $arr_label[511] = 'genero_boleta'; $arr_lang = "317,10,54,316,14,324,366,367,368,369,84,511"; include ('form_language.php'); $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; $comments = "Resultado Final
"; $comments .= nl2br($_POST['obs_final']); $body = $arr_label['estimado']." ".$_POST['nombre'].":
"; $body .= "
".$arr_label['informacion_general'].""; $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']." (".$_POST['titulo_anterior'].")"; $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $body .= "
".$arr_label['nombre_producto'].date("d/m/Y H:i:s").":".$_POST['nomprod']; $body .= "

".$comments; $body .= "

";//.$arr_label['atentamente']."
".$soporte."
".$company; //manda email if ($error != '') { //include_once ("send_error_mail.php"); $error = 1; $info = ""; } else { if (trim($_POST['email']) != "") { $content = email_tpl($arr_label['informacion_tramite'],$body); //$company_email3="info@siamedweb.com"; $headers = "From: $soporte $company <$company_email3>\nReply-To: $soporte $company<$company_email3>\nContent-Type: text/html; charset=UTF-8"; $send = mail($_POST['email'], $subject, $content, $headers); $res = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body,$send,$_POST['id']); echo $res."
"; if ($send) $info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio']; else $error = 2;//"no pudo enviar correo a ".$_POST['email']; } else $error = 3;//"No se encontro cuenta de correo"; } echo json_encode($respuesta); die(); } //ctg_tipo_tramites_documentos if ($_POST['op'] == "certificado_send_save") { ob_clean(); $respuesta = array(); iniciarConexionVUS(); $sql = "SELECT vus_{$_POST['tipo']}_numreg, vus_{$_POST['tipo']}_fec_cre, vus_{$_POST['tipo']}_est_id FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_{$_POST['tipo']}_numsol='{$_POST['codigo']}'"; //echo $sql."
"; $ret=$connectionVUS->Execute($sql); if ($ret->fields["vus_{$_POST['tipo']}_fec_cre"]) { $numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"]; } $sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_DOCs WHERE adm_cod_numreg = '$numreg' AND adm_cod_numsol = '{$_POST['codigo']}' AND adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '{$_POST['ttc_id']}' AND adm_cod_tmf_id = '{$_POST['id']}'"; // AND adm_cod_part = '{$_POST['parte']}' //echo $sql."
"; //$respuesta['este_es'] = $sql; $respuesta['sql'] = $sql; $result=$connection->Execute($sql); if (intval($result->fields["adm_cod_part"]) > 0) { $sql = "UPDATE adm_control_{$_POST['tipo']}1_docs SET adm_cod_email = 1 WHERE adm_cod_numreg = '$numreg' AND adm_cod_numsol = '{$_POST['codigo']}' AND adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '{$_POST['ttc_id']}' AND adm_cod_tmf_id = '{$_POST['id']}'"; $respuesta['sql3'] = $sql; $result=$connection->Execute($sql); $respuesta['error3'] = $connection->ErrorMsg(); $respuesta['affected3'] = $connection->Affected_Rows(); } echo json_encode($respuesta); die(); } if ($_POST['op'] == "firmae"){ ob_clean(); $respuesta = array(); $sql="SELECT adm_cnf_cdvcor FROM adm_config"; //echo $sql."
"; $result = $connection->Execute ($sql); $corr = intval($result->fields[0]) + 1; $respuesta['correlativo'] = $corr; $corr = sprintf("%06d",$corr); $respuesta['codigo'] = "#".strtoupper($_POST['ctg_tpt_id'] . $corr[0] . $_POST['pais'][0] . $corr[1] . $_POST['tipo'] . $corr[2] . $_POST['pais'][1] . $corr[3] . $_POST['codigo'] . $corr[4] . $_POST['pais'][2] . $corr[5] . date("Y"))."#"; echo json_encode($respuesta); die(); } if ($_POST['op'] == "guarda_firmae"){ ob_clean(); $respuesta = array(); $sql="UPDATE adm_control_{$_POST['tipo']}1 SET adm_con_cdv = '{$_POST['firmae_cod']}' WHERE adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_con_tpr_id = '{$_POST['ctg_tpr_id']}'"; //echo $sql."
"; $result = $connection->Execute ($sql); $sql="UPDATE adm_config SET adm_cnf_cdvcor = '{$_POST['firmae_cor']}'"; //echo $sql."
"; $result = $connection->Execute ($sql); $respuesta['sql'] = $sql; $respuesta['affected'] = $connection->Affected_Rows(); $respuesta['error'] = $connection->ErrorMsg(); echo json_encode($respuesta); die(); } if ($_POST['op'] == "GuardaDatosCosultaEmails") { //2015-12-07 ob_clean(); $respuesta = array(); iniciarConexionVUS(); switch ($_POST['opcion']) { case "03050501": //a. Extension de Plazo de vencimiento case "03050601": //a. Extension de Plazo de vencimiento $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\" SET \"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."', \"vus_{$_POST['tipo']}MSG_sta\" = '2', \"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}MSG_dt\" = now() WHERE \"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}' AND \"vus_{$_POST['tipo']}MSG_falsta\" = '2' AND \"vus_{$_POST['tipo']}MSG_tipo\" = '{$_POST['msg_tipo']}'"; $connectionVUS->Execute($sql); $respuesta['sql'] = $sql; $respuesta['error'] = $connectionVUS->ErrorMsg(); $respuesta['Affected'] = $connectionVUS->Affected_Rows(); break; case "03050502": //b. Recuperar Rechazadas $sql="UPDATE vus_tramites_{$_POST['tipo']}3 SET vus_{$_POST['tipo']}_faltante = '1', vus_{$_POST['tipo']}_est_id = '2', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' "; $connectionVUS->Execute($sql); $respuesta['sql'] = $sql; $respuesta['error'] = $connectionVUS->ErrorMsg(); $respuesta['Affected'] = $connectionVUS->Affected_Rows(); break; case "03050602": //b. Recuperar rechazadas $sql="UPDATE vus_tramites_{$_POST['tipo']}3 SET vus_{$_POST['tipo']}_boleta = '1', vus_{$_POST['tipo']}_est_id = '8', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' "; $connectionVUS->Execute($sql); $respuesta['sql'] = $sql; $respuesta['error'] = $connectionVUS->ErrorMsg(); $respuesta['Affected'] = $connectionVUS->Affected_Rows(); break; case "03050503": //c. Habilitar cerrados faltantes $sql="UPDATE vus_tramites_{$_POST['tipo']} SET vus_{$_POST['tipo']}_faltante = '1', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' "; $connectionVUS->Execute($sql); $respuesta['sql'] = $sql; $respuesta['error'] = $connectionVUS->ErrorMsg(); $respuesta['Affected'] = $connectionVUS->Affected_Rows(); $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\" SET \"vus_{$_POST['tipo']}MSG_falsta\" = '1', \"vus_{$_POST['tipo']}MSG_sta\" = '2', \"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}MSG_dt\" = now() WHERE \"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}' AND \"vus_{$_POST['tipo']}MSG_tipo\" = '{$_POST['msg_tipo']}'"; $connectionVUS->Execute($sql); $respuesta['sql1'] = $sql; $respuesta['error1'] = $connectionVUS->ErrorMsg(); $respuesta['Affected1'] = $connectionVUS->Affected_Rows(); $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_CHKl\" SET \"vus_{$_POST['tipo']}CHK_res1_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_res2_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_res10_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_sta\" = '2', \"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}CHK_dt\" = now() WHERE \"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'"; $connectionVUS->Execute($sql); $respuesta['sql3'] = $sql; $respuesta['error3'] = $connectionVUS->ErrorMsg(); $respuesta['Affected3'] = $connectionVUS->Affected_Rows(); break; case "03050603": //c. Habilitar cerradas boleta $sql="UPDATE vus_tramites_{$_POST['tipo']}1 SET vus_{$_POST['tipo']}_boleta = '1', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' "; $connectionVUS->Execute($sql); $respuesta['sql'] = $sql; $respuesta['error'] = $connectionVUS->ErrorMsg(); $respuesta['Affected'] = $connectionVUS->Affected_Rows(); $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\" SET \"vus_{$_POST['tipo']}MSG_falsta\" = '1', \"vus_{$_POST['tipo']}MSG_sta\" = '2', \"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}MSG_dt\" = now() WHERE \"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}' AND \"vus_{$_POST['tipo']}MSG_tipo\" = '{$_POST['msg_tipo']}' AND \"vus_{$_POST['tipo']}MSG_tpe_id\" = '{$_POST['etapa']}' "; $connectionVUS->Execute($sql); $respuesta['sql1'] = $sql; $respuesta['error1'] = $connectionVUS->ErrorMsg(); $respuesta['Affected1'] = $connectionVUS->Affected_Rows(); $sql = "UPDATE adm_control_{$_POST['tipo']}_etapas SET adm_coe_bolespres = 1 WHERE adm_coe_numsol = '{$_POST['etapa_numsol']}' AND adm_coe_tpt_id = '{$_POST['etapa_tpt']}' AND adm_coe_tpr_id = '{$_POST['etapa_tpr']}' AND adm_coe_tpe_id = '{$_POST['etapa']}'"; $connection->Execute($sql); $respuesta['sql2'] = $sql; $respuesta['error2'] = $connection->ErrorMsg(); $respuesta['Affected2'] = $connection->Affected_Rows(); $sql="UPDATE \"vus_tramites_{$_POST['tipo']}1_CHKl\" SET \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_sta\" = '2', \"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}CHK_dt\" = now() WHERE \"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'"; $connectionVUS->Execute($sql); $respuesta['sql3'] = $sql; $respuesta['error3'] = $connectionVUS->ErrorMsg(); $respuesta['Affected3'] = $connectionVUS->Affected_Rows(); /*etapa == 02 res4 etapa == 03 res5 etapa == 04 res6*/ break; case "03050504": //d. Habilitar documentos FALTANTES $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_CHKl\" SET \"vus_{$_POST['tipo']}CHK_res1_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_res2_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_res10_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_sta\" = '2', \"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}CHK_dt\" = now() WHERE \"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'"; $connectionVUS->Execute($sql); $respuesta['sql3'] = $sql; $respuesta['error3'] = $connectionVUS->ErrorMsg(); $respuesta['Affected3'] = $connectionVUS->Affected_Rows(); break; case "03050604": //d. Habilitar documentos BOLETAS $sql="UPDATE \"vus_tramites_{$_POST['tipo']}1_CHKl\" SET \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE 1 END END, \"vus_{$_POST['tipo']}CHK_sta\" = '2', \"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}CHK_dt\" = now() WHERE \"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}' AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'"; $connectionVUS->Execute($sql); $respuesta['sql3'] = $sql; $respuesta['error3'] = $connectionVUS->ErrorMsg(); $respuesta['Affected3'] = $connectionVUS->Affected_Rows(); break; } echo json_encode($respuesta); die(); } //es llamada de watch_vus_tramites_docs.php & form_ctg_botones.php if ($_POST['op'] == "texto_eval"){ // es una llamada #.post ob_clean(); $sql_txt_look = "SELECT ctg_txt_obs FROM ctg_textos_evaluacion WHERE ctg_txt_id='".$_POST['ide']."' AND ctg_tpr_id = '".$_POST['ctg_tpr_id']."'"; $result=$connection->Execute($sql_txt_look); echo $result->fields['ctg_txt_obs']; // echo $sql_txt_look; die(); } if ($_POST['op'] == "texto_docs") { $respuesta = array(); $texto_docs = "tabla_docs_obs{$_SESSION['ADMusuario_id']}.txt"; $c=0; while (!file_exists($texto_docs)) { $c++; } $respuesta['c'] = $c; echo json_encode($respuesta); die(); } //usuario propietario de solicitud $vus_sol_usr_id = 0; $sql="SELECT adm_con_usr_id FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'"; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $vus_sol_usr_id = $operador['adm_con_usr_id']; } switch ($_POST['id']){ case "030205": case "030206": case "030207": //update a revision de c onforme $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET adm_coe_status = '".$_POST['res_final']."', adm_coe_obs = '".$_POST['obs_final']."', adm_coe_sta = '2', adm_coe_usr = '".$_SESSION['ADMusuario_id']."', adm_coe_dt = '".date("Y-m-d H:i:s")."' WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".substr($_POST['id'],4,2)."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; if ($_POST['id'] == "030205") { $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET adm_con_cii = 1, adm_con_sta='2', adm_con_usr='".$_SESSION['ADMusuario_id']."', adm_con_dt=now() WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } else { if ($_POST['res_final'] == 3) { $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET adm_coe_jun = ".($_POST['id'] == "030206" ? "1" : "adm_coe_jun" ).", adm_coe_com = ".($_POST['id'] == "030207" ? "1" : "adm_coe_com" ).", adm_coe_sta = '2', adm_coe_usr = '".$_SESSION['ADMusuario_id']."', adm_coe_dt = '".date("Y-m-d H:i:s")."' WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '05'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } } break; case "040101"://selecion de tecnicos, laboratorio if ($_POST['op'] == "graba_sel_evaluadores") { $sql="DELETE FROM lab_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_tecnicos WHERE lab_cot_numsol = '".$_POST['codigo']."' AND lab_cot_tpr_id = '".$_POST['ctg_tpr_id']."' AND lab_cot_tpt_id = '".$_POST['ctg_tpt_id']."' AND lab_cot_arm_id = '".$_POST['ctg_arm_id']."' AND lab_cot_esa_id = '".$_POST['ctg_esa_id1']."'"; $result = $connection->Execute ( $sql ); $sql="INSERT INTO lab_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_tecnicos ( lab_cot_numsol, lab_cot_tpt_id, lab_cot_tpr_id, lab_cot_arm_id, lab_cot_esa_id, lab_cot_usr_id, lab_cot_asi_dt, lab_cot_asi_mue, lab_cot_asi_usr, lab_cot_asi_obs, lab_cot_ini_dt, lab_cot_exp_dt, lab_cot_fin_dt, lab_cot_res, lab_cot_sup_usr, lab_cot_sup_dt, lab_cot_sup_obs, lab_cot_sta, lab_cot_usr, lab_cot_dt ) VALUES ( '".$_POST['codigo']."', '".$_POST['ctg_tpt_id']."', '".$_POST['ctg_tpr_id']."', '".$_POST['ctg_arm_id']."', '".$_POST['ctg_esa_id1']."', '".$_SESSION['ADMusuario_id']."', '".date("Y-m-d H:i:s")."', '".$_POST['lab_cot_asi_mue']."', '".$_POST['lab_cot_usr_id']."', '".$_POST['obs']."', '1900-01-01 00:00:00', '1900-01-01', '1900-01-01 00:00:00', '0', '', '1900-01-01', '', '1', '".$_SESSION['ADMusuario_id']."', '".date("Y-m-d H:i:s")."');"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } break; /* case "030202"://evaluacion case "030203": case "030204": case "030205": case "030206": case "030207": */ case "030504": //rechazo 2015-11-10 //update control $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET adm_con_rf_status = '7', adm_con_rf_dt = '".fecha_srv($_POST['adm_con_rf_dt'])."', adm_con_rf_usr = '".$_SESSION['ADMusuario_id']."', adm_con_rf_obs = '".$_POST['adm_con_rf_obs']."', adm_con_sta='2', adm_con_usr='".$_SESSION['ADMusuario_id']."', adm_con_dt=now() WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'"; // AND ctg_esa_id = '".$_POST['ctg_esa_id']."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) { $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; iniciarConexionVUS(); //update tramite $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_est_id = 7, vus_{$_POST['tipo']}_est_dt = '".fecha_srv($_POST['adm_con_rf_dt'])."', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_obs = '".$_POST['adm_con_rf_obs']."', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = now() WHERE vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'"; $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } break; default: if($_POST['id']!='030201'){ iniciarConexionVUS(); echo "ssss ({$_SESSION['rsf']})
"; if($_SESSION['rsf']=='1'){ if ($_POST['arr_res_final']) foreach ($_POST['arr_res_final'] as $key => $value) { //update a revision de c onforme $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET adm_coe_status = '".$value."', adm_coe_obs = '".$_POST['arr_obs_final'][$key]."', adm_coe_sta = '2', adm_coe_usr = '".$_SESSION['ADMusuario_id']."', adm_coe_dt = '".date("Y-m-d H:i:s")."' WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".$key."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } //update a resultado final general $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET adm_con_etapa = '".$_POST['etapa']."', adm_con_estatus = '".$_POST['res_final']."', adm_con_rf_status = '".$_POST['res_final']."', adm_con_rf_dt = '".date("Y-m-d H:i:s")."', adm_con_rf_usr = '".$_SESSION['ADMusuario_id']."', adm_con_rf_obs = '".$_POST['obs_final']."', adm_con_sta='2', adm_con_usr='".$_SESSION['ADMusuario_id']."', adm_con_dt='".date("Y-m-d H:i:s")."' WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'"; // AND ctg_esa_id = '".$_POST['ctg_esa_id']."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."))))
[".$error."]
[".$info."]
"; //if($_POST['id']!='030208'){ echo "RESULTADO ".$_POST['res_final']; if($_POST['res_final']=='4'){ //$_POST['siglas']; $ctg_tpr_correg = 0; $validez = 0; $sql= "SELECT ctg_tpr_expe_loc, ctg_tpr_coradm, ctg_tpr_correg, ctg_tpr_validez FROM ctg_tipo_productos WHERE ctg_tpr_id='".$_POST['ctg_tpr_id']."'"; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $ctg_tpr_expe_loc=$operador['ctg_tpr_expe_loc']; $validez = $operador['ctg_tpr_validez']; $ctg_tpr_correg=$operador['ctg_tpr_correg']; } echo "(ctg_tpr_correg=$ctg_tpr_correg)"; //2015-03-20 $sql="SELECT ctg_tpt_accion FROM ctg_tipo_tramites WHERE ctg_tpt_id='{$_POST['ctg_tpt_id']}' AND ctg_tpr_id='{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result = $connection->Execute ($sql); echo "(accion={$result->fields[0]})"; switch ($result->fields[0]) { case 1://nuevo registro echo "

******* ADMITIR EL RESULTADO FINAL ******

"; include_once ('admitir_nuevo_registro.php'); echo "

******* ADMITIR DOCUMENTOS ******

"; include_once ('admitir_docs.php'); break; case 2://renovacion //solo GT //ren_res_no pendiente el input de numero de resolucion //ren_res_dt pendiente el input la fecha de resolucion //select adm_ef_vencim, to_char(adm_ef_vencim + interval '2 year','yyyy-mm-dd') as otro from adm_productos_ef include_once ('admitir_renovacion.php'); break; case 3://cambios post registro //admitir_cambios break; case 9://renovacion y cambios include_once ('admitir_renovacion.php'); //admitir_cambios break; } $est_id = 9; } if($_POST['res_final']=='3') $est_id = 10; if($_POST['id'] == '030208' && ($est_id == 9 || $est_id == 10) ) { //update tramite con boleta $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_est_id = ".$est_id.", vus_{$_POST['tipo']}_est_dt = '".date("Y-m-d H:i:s")."', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = '".date("Y-m-d H:i:s")."' WHERE vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'"; $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo "///////////////////////////////////////////////////////////////////"; echo $sql."
[".$error."]
[".$info."]
"; } if($_POST['id'] == '030208') { /* //lenguaje para email $arr_label[317]='tramite_no'; $arr_label[10]='tipo_producto'; $arr_label[54]='tipo_tramite'; $arr_label[316]='doc_nombre'; $arr_label[14]='comentarios'; $arr_label[324]='parte'; $arr_label[366]='cambio_status'; $arr_label[367]='faltante'; $arr_label[368]='se_cambio_status'; $arr_label[369]='a'; $arr_label[84]='nombre_producto'; $arr_label[511] = 'genero_boleta'; $arr_lang = "317,10,54,316,14,324,366,367,368,369,84,511"; include ('form_language.php'); $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; $comments = "Resultado Final
"; $comments .= nl2br($_POST['obs_final']); $body = $arr_label['estimado']." ".$_POST['nombre'].":
"; $body .= "
".$arr_label['informacion_general'].""; $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']." (".$_POST['titulo_anterior'].")"; $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $body .= "
".$arr_label['nombre_producto'].date("d/m/Y H:i:s").":".$_POST['nomprod']; $body .= "

".$comments; $body .= "

".$arr_label['atentamente']."
".$soporte."
".$company; //manda email if ($error != '') { //include_once ("send_error_mail.php"); $error = 1; $info = ""; } else { if (trim($_POST['email']) != "") { $content = email_tpl($arr_label['informacion_tramite'],$body); //$company_email3="info@siamedweb.com"; $headers = "From: $soporte $company <$company_email3>\nReply-To: $soporte $company<$company_email3>\nContent-Type: text/html; charset=UTF-8"; $send = mail($_POST['email'], $subject, $content, $headers); $res = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body,$send,$_POST['id']); echo $res."
"; if ($send) $info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio']; else $error = 2;//"no pudo enviar correo a ".$_POST['email']; } else $error = 3;//"No se encontro cuenta de correo"; } */ /* //insertar mensaje $sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}_MENSAJES\" ( \"vus_{$_POST['tipo']}MSG_numsol\", \"vus_{$_POST['tipo']}MSG_tpt_id\", \"vus_{$_POST['tipo']}MSG_tpr_id\", \"vus_{$_POST['tipo']}MSG_nomprod\", \"vus_{$_POST['tipo']}MSG_tipo\", \"vus_{$_POST['tipo']}MSG_fecha\", \"vus_{$_POST['tipo']}MSG_asunto\", \"vus_{$_POST['tipo']}MSG_mensaje\", \"vus_{$_POST['tipo']}MSG_usr_id\", \"vus_{$_POST['tipo']}MSG_esa_id\", \"vus_{$_POST['tipo']}MSG_fecven\", \"vus_{$_POST['tipo']}MSG_fecfal\", \"vus_{$_POST['tipo']}MSG_falsta\", \"vus_{$_POST['tipo']}MSG_sta\", \"vus_{$_POST['tipo']}MSG_usr\", \"vus_{$_POST['tipo']}MSG_dt\", \"vus_{$_POST['tipo']}MSG_tpe_id\" ) VALUES ( '".$_POST['codigo']."', '".$_POST['ctg_tpt_id']."', '".$_POST['ctg_tpr_id']."', '".$_POST['nomprod']."', '3', now(), '".$subject."', '".str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body)."', '".$vus_sol_usr_id."', '".$_SESSION['ADMnivel']."', '".fecha_srv($_POST['bolresdt'])."', now(), '1', '1', '".$_SESSION['ADMusuario_id']."', now(), '".substr($_POST['id'],strlen($_POST['id'])-2,2)."' );"; //if ($_POST['status'] == "2" && $_POST['numbol'] >= $adm_cnf_numbol) { //2014-07-31 //} else { $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[error=".$error."*****]

[info=".$info."]
"; */ echo "[$error]"; } }else if($_SESSION['ntf']=='1'){ }else{ //$rf = ""; echo "(numbol=".$_POST['numbol'].")(adm_cnf_numbol=$adm_cnf_numbol)"; //2014-07-31 /*se usara para rechazar tramites if ($_POST['status'] == "2" && $_POST['numbol'] == $adm_cnf_numbol) { //$_POST['status'] = 7; $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET adm_con_etapa = '".$_POST['etapa']."', adm_con_estatus = '4', adm_con_sta='2', adm_con_rf_status = 3, adm_con_rf_dt = now(), adm_con_rf_usr = {$_SESSION['ADMusuario_id']}, adm_con_rf_obs = '{$_POST['obs']}', adm_con_usr='".$_SESSION['ADMusuario_id']."', adm_con_dt='".date("Y-m-d H:i:s")."' WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";// AND ctg_esa_id = '".$_POST['ctg_esa_id']."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } */ //lenguaje para email $arr_label[317]='tramite_no'; $arr_label[10]='tipo_producto'; $arr_label[54]='tipo_tramite'; $arr_label[316]='doc_nombre'; $arr_label[14]='comentarios'; $arr_label[324]='parte'; $arr_label[366]='cambio_status'; $arr_label[367]='faltante'; $arr_label[368]='se_cambio_status'; $arr_label[369]='a'; $arr_label[84]='nombre_producto'; $arr_label[511] = 'genero_boleta'; $arr_label[323] = 'conforme'; $arr_label[505] = 'no_conforme'; $arr_label[1276] = 'limite_boleta'; $arr_label[1277] = 'limite_boleta2'; $arr_lang = "317,10,54,316,14,324,366,367,368,369,84,511, 323, 505, 1276, 1277"; include ('form_language.php'); $comments = "No encontro estatus!!!
"; if ($_POST['status'] == "3" && $_POST['id'] == '030205' && $_POST['numbol'] == $adm_cnf_numbol) { $comp = "adm_coe_obs = '{$arr_label['limite_boleta2']}',"; } else { $comp = "adm_coe_obs = '".$_POST['obs']."',"; } switch ($_POST['status']){ case "1"://en proceso no genera email $comp .= "adm_coe_inipro_dt = '".date("Y-m-d H:i:s")."',"; //etapas break; case "2"://con PRE-boleta /* $comp .= "adm_coe_bol = '1',"; $comp .= "adm_coe_bolespres = '1',"; $comp .= "adm_coe_boldias = '".intval($_POST['dias'])."',"; //etapas $comp .= "adm_coe_bolresdt = '".fecha_srv($_POST['bolresdt'])."',"; //etapas if ($_POST['numbol'] == $adm_cnf_numbol) { $comments = "".$arr_label['limite_boleta2']."
"; } else { $comp .= "adm_coe_bolnum = COALESCE(adm_coe_bolnum,0) + 1,"; $comments = "".$arr_label['genero_boleta']."
"; } //update tramite con boleta 2014-07-30 $sql = "UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET "; /* ya no tiene tiene limite porque ahora es por etapa if ($_POST['numbol'] == $adm_cnf_numbol) { //2014-07-31 $sql .= "vus_{$_POST['tipo']}_est_id = '7', vus_{$_POST['tipo']}_est_dt = now(), vus_{$_POST['tipo']}_obs = '{$arr_label['limite_boleta2']}',"; $comments = "".$arr_label['limite_boleta']."
"; } else { $sql .= " vus_{$_POST['tipo']}_boleta = '1', vus_{$_POST['tipo']}_numbol = COALESCE(vus_{$_POST['tipo']}_numbol,0) + 1,"; //} $sql .= "vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = '".date("Y-m-d H:i:s")."' WHERE vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'"; $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; */ //generar boleta pdf //para luego contar las boletas hasta tres break; case "3" AND $_POST['id'] == '030205'://con boleta $comp .= "adm_coe_bol = '1',"; $comp .= "adm_coe_bolespres = '1',"; $comp .= "adm_coe_boldias = '".intval($_POST['dias'])."',"; //etapas $comp .= "adm_coe_bolresdt = '".fecha_srv($_POST['bolresdt'])."',"; //etapas if ($_POST['numbol'] == $adm_cnf_numbol) { $comments = "".$arr_label['limite_boleta2']."
"; } else { $comp .= "adm_coe_bolnum = COALESCE(adm_coe_bolnum,0) + 1,"; $comments = "".$arr_label['genero_boleta']."
"; } //update tramite con boleta 2014-07-30 $sql = "UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET "; /* ya no tiene tiene limite porque ahora es por etapa if ($_POST['numbol'] == $adm_cnf_numbol) { //2014-07-31 $sql .= "vus_{$_POST['tipo']}_est_id = '7', vus_{$_POST['tipo']}_est_dt = now(), vus_{$_POST['tipo']}_obs = '{$arr_label['limite_boleta2']}',"; $comments = "".$arr_label['limite_boleta']."
"; } else { */ $sql .= " vus_{$_POST['tipo']}_boleta = '1', vus_{$_POST['tipo']}_numbol = COALESCE(vus_{$_POST['tipo']}_numbol,0) + 1,"; //} $sql .= "vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt = '".date("Y-m-d H:i:s")."' WHERE vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'"; $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; //generar boleta pdf //para luego contar las boletas hasta tres break; case "4"://no conforme $comp .= "adm_coe_finpro = '".date("Y-m-d H:i:s")."',"; //etapas $comments = "".$arr_label['no_conforme']."
"; break; case "5"://conforme $comp .= "adm_coe_finpro = '".date("Y-m-d H:i:s")."',"; //etapas $comments = "".$arr_label['conforme']."
"; break; } /////////////////proceso de mandar correo y agregar los documentos que tienen problemas///////// if ($_POST['status'] > 1) { $sql= "SELECT ctg_tte_email FROM ctg_tipo_tramites_etapas WHERE ctg_tpr_id='".$_POST['ctg_tpr_id']."' AND ctg_tpt_id='".$_POST['ctg_tpt_id']."' AND ctg_tte_id = '".substr($_POST['id'],4,2)."'"; echo "($sql)"; $result=$connection->Execute($sql); if (!$result->EOF) { $oper = $result->fields; $tte_email=$oper['ctg_tte_email']; } $texto_docs = "tabla_docs_obs{$_SESSION['ADMusuario_id']}.txt"; //elabora email $subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo']." \"".$company."\""; $comments .= nl2br($_POST['obs']); $body = $arr_label['estimado']." ".$_POST['nombre'].":
"; $body .= "
".$arr_label['informacion_general'].""; $body .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']." (".$_POST['titulo_anterior'].")"; $body .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; $body .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $body .= "
".$arr_label['nombre_producto'].":".$_POST['nomprod']; $body .= "

".$comments; $body .= "#*tabla_docs*#"; $body .= "

";//.$arr_label['atentamente']."
".$soporte."
".$company; //if ($_POST['status'] == 2) { //si es boleta //2015-04-14 //insertar mensaje $sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}_MENSAJES\" ( \"vus_{$_POST['tipo']}MSG_numsol\", \"vus_{$_POST['tipo']}MSG_tpt_id\", \"vus_{$_POST['tipo']}MSG_tpr_id\", \"vus_{$_POST['tipo']}MSG_nomprod\", \"vus_{$_POST['tipo']}MSG_tipo\", \"vus_{$_POST['tipo']}MSG_fecha\", \"vus_{$_POST['tipo']}MSG_asunto\", \"vus_{$_POST['tipo']}MSG_mensaje\", \"vus_{$_POST['tipo']}MSG_usr_id\", \"vus_{$_POST['tipo']}MSG_esa_id\", \"vus_{$_POST['tipo']}MSG_fecven\", \"vus_{$_POST['tipo']}MSG_fecfal\", \"vus_{$_POST['tipo']}MSG_falsta\", \"vus_{$_POST['tipo']}MSG_sta\", \"vus_{$_POST['tipo']}MSG_usr\", \"vus_{$_POST['tipo']}MSG_dt\", \"vus_{$_POST['tipo']}MSG_tpe_id\" ) VALUES ( '".$_POST['codigo']."', '".$_POST['ctg_tpt_id']."', '".$_POST['ctg_tpr_id']."', '".$_POST['nomprod']."', '2', now(), '".$subject."', '".str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body)."', '".$vus_sol_usr_id."', '".$_SESSION['ADMnivel']."', '".fecha_srv($_POST['bolresdt'])."', now(), '1', '1', '".$_SESSION['ADMusuario_id']."', now(), '".substr($_POST['id'],strlen($_POST['id'])-2,2)."' );"; //if ($_POST['status'] == "2" && $_POST['numbol'] >= $adm_cnf_numbol) { //2014-07-31 //} else { $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[error=".$error."*****]

[info=".$info."]
"; //} //} echo "***************************
"; //manda email if ($error != '') { //include_once ("send_error_mail.php"); //$error = 1; $info = ""; } else { $send = 0; if ($tte_email == 1 || $_POST['status'] == 2) { //si manda email o es PRE-BOLETA $_POST['email']="assessment@dcdfdamm.online"; if (trim($_POST['email']) != "") { $body1 = str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body); $content = email_tpl($arr_label['informacion_tramite'],$body1); $headers = "From: $soporte $company <$company_email3>\nReply-To: $soporte $company<$company_email3>\nContent-Type: text/html; charset=UTF-8"; $send = mail($_POST['email'], $subject, $content, $headers); if ($send) $info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio']; else $error = 2;//"no pudo enviar correo a ".$_POST['email']; } else $error = 3;//"No se encontro cuenta de correo"; } else echo "El tte_email no es marcado en tipo_tramites_etapas"; if ($tte_email == 1 || $_POST['status'] == 3 || $_POST['id'] == '030205') { //si manda email o es BOLETA if (trim($_POST['email']) != "") { $body1 = str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body); $content = email_tpl($arr_label['informacion_tramite'],$body1); $headers = "From: $soporte $company <$company_email3>\nReply-To: $soporte $company<$company_email3>\nContent-Type: text/html; charset=UTF-8"; $send = mail($_POST['email'], $subject, $content, $headers); if ($send) $info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio']; else $error = 2;//"no pudo enviar correo a ".$_POST['email']; } else $error = 3;//"No se encontro cuenta de correo"; } else echo "El tte_email no es marcado en tipo_tramites_etapas"; $res = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body1,$send,$_POST['id']); echo "$res
"; } unlink($texto_docs); } if ($error == "") { // adm_coe_res_dt = '".$_POST['res_dt']."', $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET adm_coe_status = '".$_POST['status']."', $comp adm_coe_sta = '2', adm_coe_usr = '".$_SESSION['ADMusuario_id']."', adm_coe_dt = '".date("Y-m-d H:i:s")."' WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".$_POST['etapa']."'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) { if ($info == "") $info = $arr_label['datos_grabados']; } echo "[".$sql."]
[".$error."]
[".$info."]
"; $quien=1; } else echo "hay error
"; } if ($error == "") { /*2014-10-23 temporalmente if ($_POST['gendocx'] == '1') { echo "

********** GENERA DOCUMENTO ***********

"; include("genera_resultado_evaluacion_pdf.php");//2012-09-18 echo "

********** fin ***********

"; $archivo_1="../".$location.$archivo; $info .= "


Abrir PDF"; } else echo "no genera pdf"; */ echo "******************************paso por aqui
"; } else echo "hay error
"; } /* case "030208": break; case "030209": break; */ break; } //echo "sql=({$sql})"; if ($error != "") { include_once ("send_error_mail.php"); //$error = 1; 2012-07-14 $info = ""; } $res_final = ""; if ($_POST["res_final"] == 3 || $_POST["res_final"] == 4) $res_final = "{$_POST['tipo']}|{$_POST['codigo']}|{$_POST['ctg_tpt_id']}|{$_POST['ctg_tpr_id']}|{$_POST["res_final"]}"; $codigo = $_POST['codigo']; echo "
$codigo
quien ".$quien; ?>