"; echo "({$_POST['tipo']})({$_POST['ctg_tpt_id']})({$_POST['codigo']})({$_POST['ctg_tpr_id']})
"; if ($ip_ext == $ip_int) local_download($_POST['tipo'],$_POST['ctg_tpt_id'],$_POST['codigo'],$_POST['ctg_tpr_id'],""); else ftp_download($_POST['tipo'],$_POST['ctg_tpt_id'],$_POST['codigo'],$_POST['ctg_tpr_id'],""); die(); */ if (strpos("***".$_POST['tabla'],"adm")) $_POST['tabla'] = $_POST['tabla'].$_POST['tipo'].$_SESSION['dtb_adm']; else $_POST['tabla'] = $_POST['tabla'].$_POST['tipo'].$_SESSION['dtb_vus']; //echo "(dtb_vus=".$_SESSION['dtb_vus'].")"; if (isset($_POST['GuardarComentario_res_obs'])) { $res = array(); switch($_POST['id']){ case '010101':$etapa_inf=10; break; //verificacion escribe 2 al estatus case '010102':$etapa_inf=1; break; //verificacion escribe 2 al estatus case '010103':$etapa_inf=3; break; //pre chequeo case '010105':$etapa_inf=3; break; //chequeo genera numero de admision } $sql="UPDATE \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKinf\" SET \"vus_{$_POST['tipo']}CHKi_res_obs\" = '{$_POST['res_obs']}',\"vus_{$_POST['tipo']}CHKi_sta\" = '2', \"vus_{$_POST['tipo']}CHKi_usr\" = '{$_SESSION['ADMusuario_id']}', \"vus_{$_POST['tipo']}CHKi_dt\" = now() WHERE \"vus_{$_POST['tipo']}CHKi_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}CHKi_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}CHKi_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}CHKi_etapa\" = '{$etapa_inf}'"; $result = $connectionVUS->Execute($sql); $res['sql'] = $sql; $res['Affected'] = $connectionVUS->Affected_Rows(); $res['session_vus'] = $_POST['session_vus']; echo json_encode($res); die(); } if (isset($_POST['OpenChklsObs'])) { //2015-02-17 $res = array(); $arr_label[315]='estatus'; $arr_label[508]='dias'; $arr_label[277]='fecha'; $arr_label[4]='usuario'; $arr_label[14]='comentarios'; $arr_label[137]='edita'; $arr_label[51]='no_data'; $arr_label[498]='etapa'; $arr_lang = "315,508,277,4,14,137,51,498"; include('form_language.php'); $html = ""; $html .= ""; //$html .= ""; $html .= ""; $html .= ""; $html .= ""; if (substr($_POST['id'],0,4) == "0101") { $u = 1; $str = "'010101','010102','010103','010105'"; } if (substr($_POST['id'],0,4) == "0302") { $u = 4; $str = "'030202','030203','030204','0302041','030205','030206','030207'"; } $sql = "SELECT * FROM \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}CHK_ttc_id\" = '{$_POST['cat_id']}' AND \"vus_{$_POST['tipo']}CHK_ttd_id\" = '{$_POST['doc_id']}' AND \"vus_{$_POST['tipo']}CHK_ttl_part\" = '{$_POST['part_id']}'"; $res['sql'] = $sql; //echo $sql."
"; $result2=$connectionVUS->Execute($sql); if (!$result2->EOF) { $sql = "SELECT ctg_men_id, ctg_men_desc FROM ctg_menus WHERE ctg_men_id IN ($str) ORDER BY ctg_men_id"; $result3=$connection->Execute($sql); if (!$result3->EOF) { while (!$result3->EOF) { $operador3 = $result3->fields; $id = $operador3['ctg_men_id']; $arr_ids[] = $id; $arr_label[$id] = $operador3['ctg_men_desc']; $result3->MoveNext(); } } $operador2 = $result2->fields; for ($i=0;$i" : "").$arr_label[$arr_ids[$i]].($arr_ids[$i] == $_POST['id'] ? "" : "").""; for ($j=0;$j<6;$j++) { switch($j) { case 2: $operador2[$ii+$j] = date("d/m/Y",strtotime($operador2[$ii+$j])); break; case 3: $sql = "SELECT adm_usr_nombre FROM adm_usuarios WHERE adm_usr_ci = '{$operador2[$ii+$j]}'"; $result4=$connection->Execute($sql); if (!$result4->EOF) { $operador2[$ii+$j] = $result4->fields[0]; } break; case 4: break; } if ($j >= 2 && $j <=4) $html .= ""; //$html .= ""; } $html .= ""; } } else { $html .= ""; } $html .= ""; $html .= "
{$arr_label['etapa']}{$arr_label['estatus']}{$arr_label['dias']}{$arr_label['fecha']}{$arr_label['usuario']}{$arr_label['comentarios']}{$arr_label['edita']}
{$arr_label['etapa']} {$arr_label['fecha']}{$arr_label['usuario']}{$arr_label['comentarios']}
".($arr_ids[$i] == $_POST['id'] ? "" : "").$operador2[$ii+$j].($arr_ids[$i] == $_POST['id'] ? "" : "")."(".($ii+$j).")".$operador2[$ii+$j]."
{$arr_label['no_data']}
"; $res['html'] = $html; echo json_encode($res); die(); } if (isset($_POST['ajax'])) { //2012-11-24 viene de watch_vus_tramites_docs.php cuando pierde el foco de los areatext //echo "(".$_POST['id'].")({$_POST['tipo']})({$_POST['ctg_tpr_id']})({$_POST['ctg_tpt_id']}({$_POST['codigo']})(".$_POST['cat_id'].")(".$_POST['doc_id'].")(". $_POS['part_id'].")(". $_POST['obs'].")(". $_POST['dias'].")"; switch($_POST['id']){ case '010101':$campo=10; break; //2015-10-14 case '010102':$campo=1; break; //verificacion escribe 2 al estatus case '010103':$campo=3; break; //pre chequeo case '010105':$campo=3; break; //chequeo genera numero de admision case '030202'://Evaluacion 4 case '030203'://Asesoria 5 case '030204'://Calidad 6 case '030205'://Coordinacion II 7 case '030206'://Junta revisoria 8 case '030207'://comision tecnica 9 //case '030208'://Resultado final puede que tambien entre aca 2015-10-14 //case '030209'://Coordinacion III puede que tambien entre aca 2015-10-14 $campo = intval(substr($_POST['id'],5,1)) + 2; break; //este viend de form_adm_control_etapa_evaluacion.php case '0302041'://Calidad 6 $campo = 10; break; //este viend de form_adm_control_etapa_evaluacion.php } echo "(_POST['res']=".$_POST['res'].")"; $res = intval($_POST['res']); /*for ($l=1;$l<10;$l++) { //ahora si es inteligente inicializa para los 4 checklist 1,2,3,4 $res_st[$l] = '0'; $res_dt[$l] = '1900-01-01 00:00:00'; $res_ds[$l] = '0'; $res_us[$l] = ''; $res_obs[$l] = ''; $res_aut[$l] = '0'; }*/ if ($campo > 3) $ds = 0; else $ds = $_POST['dias']; if($res==0) $aut='1'; else $aut='0'; $new_res_st = $res; $new_res_dt = date("Y-m-d H:i:s"); $new_res_ds = $ds; $new_res_us = $_SESSION['ADMusuario_id']; $new_res_obs = $_POST['obs']; $new_res_aut = $aut; $cat_id = $_POST['cat_id']; $doc_id = $_POST['doc_id']; $part_id = $_POST['part_id']; $res = array(); $sql = "SELECT \"vus_{$_POST['tipo']}CHK_res{$campo}_st\", \"vus_{$_POST['tipo']}CHK_res{$campo}_obs\", \"vus_{$_POST['tipo']}CHK_res{$campo}_dt\", \"vus_{$_POST['tipo']}CHK_res{$campo}_us\", \"vus_{$_POST['tipo']}CHK_res{$campo}_ds\" FROM \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKl\" WHERE \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}CHK_ttc_id\" = '$cat_id' AND \"vus_{$_POST['tipo']}CHK_ttd_id\" = '$doc_id' AND \"vus_{$_POST['tipo']}CHK_ttl_part\" = '$part_id'"; echo "$sql
"; $result2=$connectionVUS->Execute($sql); if (!$result2->EOF) { $operador2 = $result2->fields; echo "(".$operador2[0].")"; $sql="UPDATE \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKl\" SET \"vus_{$_POST['tipo']}CHK_res{$campo}_st\" = '{$new_res_st}', \"vus_{$_POST['tipo']}CHK_res{$campo}_dt\" = '{$new_res_dt}', \"vus_{$_POST['tipo']}CHK_res{$campo}_ds\" = '{$new_res_ds}', \"vus_{$_POST['tipo']}CHK_res{$campo}_us\" = '{$new_res_us}', \"vus_{$_POST['tipo']}CHK_res{$campo}_obs\" = '{$new_res_obs}', \"vus_{$_POST['tipo']}CHK_res{$campo}_aut\" = '{$new_res_aut}', \"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['codigo']}' AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}CHK_ttc_id\" = '$cat_id' AND \"vus_{$_POST['tipo']}CHK_ttd_id\" = '$doc_id' AND \"vus_{$_POST['tipo']}CHK_ttl_part\" = '$part_id'"; } else { $sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKl\" ( \"vus_{$_POST['tipo']}CHK_numsol\", \"vus_{$_POST['tipo']}CHK_tpt_id\", \"vus_{$_POST['tipo']}CHK_tpr_id\", \"vus_{$_POST['tipo']}CHK_ttc_id\", \"vus_{$_POST['tipo']}CHK_ttd_id\", \"vus_{$_POST['tipo']}CHK_ttl_part\", \"vus_{$_POST['tipo']}CHK_res{$campo}_st\",\"vus_{$_POST['tipo']}CHK_res{$campo}_dt\",\"vus_{$_POST['tipo']}CHK_res{$campo}_ds\",\"vus_{$_POST['tipo']}CHK_res{$campo}_us\",\"vus_{$_POST['tipo']}CHK_res{$campo}_obs\", \"vus_{$_POST['tipo']}CHK_res{$campo}_aut\", \"vus_{$_POST['tipo']}CHK_sta\", \"vus_{$_POST['tipo']}CHK_usr\", \"vus_{$_POST['tipo']}CHK_dt\" ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '$cat_id', '$doc_id', '$part_id', '{$new_res_st}','{$new_res_dt}','{$new_res_ds}','{$new_res_us}','{$new_res_obs}','{$new_res_aut}', '1', '".$_SESSION['ADMusuario_id']."', now());"; } //echo $sql."
"; $result2=$connectionVUS->Execute($sql); //file_put_contents ("testo.txt","\n".$sql."\n".$connectionVUS->Affected_Rows()."Error : \n[".$connectionVUS->ErrorMsg()."]"); //$error = $connectionVUS->ErrorMsg(); //ob_end_clean(); /* if ($connectionVUS->Affected_Rows() == 1) echo 1; else echo $error; */ $res['sql'] = $sql; $res['affected'] = $connectionVUS->Affected_Rows(); $res['error'] = $connectionVUS->ErrorMsg(); echo json_encode($res); die; } switch($_POST['id']){ case '040100': case '03020101': //distribucion de muestras watch_vus_tramites_asignacion.php if ($_POST['op'] == "borra_distribucion") { /* borrar ensayos */ $sql="DELETE FROM lab_control_pa_ensayos WHERE lab_coe_numsol = '{$_POST['codigo']}' AND lab_coe_tpr_id = '{$_POST['ctg_tpr_id']}' AND lab_coe_tpt_id = '{$_POST['ctg_tpt_id']}' AND lab_coe_arm_id = '".$_POST["ctg_arm_id"]."' AND lab_coe_esa_id= '".$_POST['ctg_esa_id_del']."'"; $result = $connection->Execute ( $sql ); if ($connection->Affected_Rows() > 0) $info = $arr_label['datos_borrados']; $error = $connection->ErrorMsg(); echo "
transac ".$sql."
[".$error."] [".$info."] (".$connection->Affected_Rows().")

"; /* borrar tecnicos */ $sql="DELETE FROM lab_control_pa_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_id_del']."'"; $result = $connection->Execute ( $sql ); if ($connection->Affected_Rows() > 0) $info = $arr_label['datos_borrados']; $error = $connection->ErrorMsg(); echo "
transac ".$sql."
[".$error."] [".$info."] (".$connection->Affected_Rows().")

"; $sql="SELECT ctg_art_cant_ent, ctg_art_cant_sal FROM ctg_muestras_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id = '".$_POST['ctg_esa_id_del']."'"; echo $sql."
"; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $cant_sal=$operador['ctg_art_cant_ent']; if($_POST['id']=='040100'){ $cant_sal=$operador['ctg_art_cant_sal']; } } if($_POST['id']=='040100'){ $sql="UPDATE ctg_muestras_transac SET ctg_art_cant_sal = ctg_art_cant_sal-".$cant_sal.", ctg_art_sta = '2', ctg_art_usr = '".$_SESSION['ADMusuario_id']."', ctg_art_dt =now() WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id='".$_SESSION['ADMnivel']."'"; }else{ $sql="UPDATE ctg_muestras_transac SET ctg_art_cant_sal = ctg_art_cant_sal-".$cant_sal.", ctg_art_sta = '2', ctg_art_usr = '".$_SESSION['ADMusuario_id']."', ctg_art_dt =now() WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id='0106{$_POST['ctg_tpr_id']}'"; } $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); echo "
update
".$sql."
[".$error."]
[".$info."]
"; $sql="DELETE FROM ctg_muestras_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id = '".$_POST['ctg_esa_id_del']."'"; $result = $connection->Execute ( $sql ); if ($connection->Affected_Rows() > 0) $info = $arr_label['datos_borrados']; $error = $connection->ErrorMsg(); echo "
transac ".$sql."
[".$error."] [".$info."] (".$connection->Affected_Rows().")
"; if ($error == "") { if($_POST['id']!='040100'){ $new_saldo = $_POST['ctg_ari_cant_saldo'] + $cant_sal; $sql="UPDATE ctg_muestras_inven SET ctg_ari_cant_saldo = '".$new_saldo."', ctg_ari_cant_sal = ctg_ari_cant_sal-".$cant_sal.", ctg_ari_sta = '2', ctg_ari_usr = '".$_SESSION['ADMusuario_id']."', ctg_ari_dt =now() WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."'"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_borrados']; //echo $sql."
[".$error."]
[".$info."]
"; } if ($error == "") { $sql = "DELETE FROM lab_control_{$_POST['tipo']} WHERE lab_con_numsol = '{$_POST['codigo']}' AND lab_con_tpt_id = '{$_POST['ctg_tpt_id']}' AND lab_con_tpr_id = '{$_POST['ctg_tpr_id']}' AND lab_con_arm_id = '".$_POST["ctg_arm_id"]."' AND lab_con_esa_id = '".$_POST['ctg_esa_id_del']."'"; $result = $connection->Execute ( $sql ); if ($connection->Affected_Rows() > 0) $info = $arr_label['datos_borrados']; $error = $connection->ErrorMsg(); echo "
lab ".$sql."
[".$error."] [".$info."] (".$connection->Affected_Rows().")
"; } } if($_POST['id']=='040100'){ /////regresar el id lab vus_tramites echo "

regresar el id lab vus_tramites
"; $sql="SELECT ctg_art_cant_ent, ctg_art_cant_sal FROM ctg_muestras_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id='".$_SESSION['ADMnivel']."'"; echo $sql."

"; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; if($operador['ctg_art_cant_sal']=='' || $operador['ctg_art_cant_sal']=='0'){ iniciarConexionVUS(); $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_lab_est = '1', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); } } } } if ($_POST['op'] == "graba_distribucion") { //$_POST['ctg_art_cant_sal'] = clean_num ($_POST['ctg_art_cant_sal']); $sql="INSERT INTO lab_control_{$_POST['tipo']} ( lab_con_numsol, lab_con_tpt_id, lab_con_tpr_id, lab_con_arm_id, lab_con_esa_id, lab_con_asi_dt, lab_con_asi_mue, lab_con_asi_usr, lab_con_asi_obs, lab_con_ini_dt, lab_con_exp_dt, lab_con_fin_dt, lab_con_res1, lab_con_res2, lab_con_res3, lab_con_res4, lab_con_sta, lab_con_usr, lab_con_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '".$_POST["ctg_arm_id"]."', '".$_POST['ctg_esa_id']."', '1900-01-01 00:00:00', '".$_POST['ctg_art_cant_sal']."', '', '".$_POST['obs']."', '1900-01-01 00:00:00', '1900-01-01', '1900-01-01 00:00:00', '0', '0', '0', '0', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; if ($error == ""){ $sql="SELECT * FROM ctg_muestras_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id = '".$_POST['ctg_esa_id']."'"; echo $sql."
"; $id_corr = 0; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $id_corr = $operador['ctg_art_id']; } $id_corr++; if($_POST['id']=='040100'){ $sal=$_POST['ctg_art_cant_sal']; $ent=0; } else{ $ent=$_POST['ctg_art_cant_sal']; $sal=0; } $sql="INSERT INTO ctg_muestras_transac ( ctg_numsol_id, ctg_tpr_id, ctg_tpt_id, ctg_arm_id, ctg_esa_id, ctg_art_id, ctg_art_opeusr, ctg_art_opedt, ctg_art_tpoope, ctg_art_motivo, ctg_art_cant_ent, ctg_art_cant_sal, ctg_art_sta, ctg_art_usr, ctg_art_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpr_id']}', '{$_POST['ctg_tpt_id']}', '".$_POST["ctg_arm_id"]."', '".$_POST['ctg_esa_id']."', '".$id_corr."', '".$_SESSION['ADMusuario_id']."', now(), '2', 'Distribucion de muestras', '".$ent."', '".$sal."', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; if($_POST['id']=='040100'){ $sql="UPDATE ctg_muestras_transac SET ctg_art_cant_sal = ctg_art_cant_sal+".$_POST['ctg_art_cant_sal'].", ctg_art_sta = '2', ctg_art_usr = '".$_SESSION['ADMusuario_id']."', ctg_art_dt =now() WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id='".$_SESSION['ADMnivel']."'"; }else{ $sql="UPDATE ctg_muestras_transac SET ctg_art_cant_sal = ctg_art_cant_sal+".$_POST['ctg_art_cant_sal'].", ctg_art_sta = '2', ctg_art_usr = '".$_SESSION['ADMusuario_id']."', ctg_art_dt =now() WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id='0106{$_POST['ctg_tpr_id']}'"; } $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; $new_saldo = $_POST['ctg_ari_cant_saldo'] - $_POST['ctg_art_cant_sal']; echo "[".$_POST['ctg_ari_cant_saldo']."][".$_POST['ctg_art_cant_sal']."][$new_saldo]
"; if($_POST['id']!='040100'){ $sql="UPDATE ctg_muestras_inven SET ctg_ari_cant_saldo = '".$new_saldo."', ctg_ari_cant_sal = ctg_ari_cant_sal+".$_POST['ctg_art_cant_sal'].", ctg_ari_sta = '2', ctg_ari_usr = '".$_SESSION['ADMusuario_id']."', ctg_ari_dt =now() WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_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']=='040100'){ /////crear el id lab vus_tramites echo "

crear el id lab vus_tramites
"; $sql="SELECT ctg_art_cant_ent, ctg_art_cant_sal FROM ctg_muestras_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id='".$_SESSION['ADMnivel']."'"; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; if($operador['ctg_art_cant_sal']!='' || $operador['ctg_art_cant_sal']!='0'){ iniciarConexionVUS(); $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_lab_est = '2', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); } } } } break; case '03020102'://asignacion de procesos case '030501': //re asignacion de procesos //if ($_POST['op'] == "graba_asignacion"){ //ya no porque le graba_load lo hace todo!!! y saca a pantalla de listado if ($_POST['op'] == "distribucion"){ $arr_label[554]='falta_distribucion'; $arr_lang = "554"; include ('form_language.php'); /* $sql="SELECT ctg_tpt_req_muestra FROM ctg_tipo_tramites WHERE ctg_tpt_id='{$_POST['ctg_tpt_id']}' AND ctg_tpr_id='{$_POST['ctg_tpr_id']}'"; $result = $connection->Execute ($sql); if ($result->fields[0] != "") { if($result->fields[0]=='1'){ */ $sql="SELECT * FROM lab_control_{$_POST['tipo']} WHERE lab_con_numsol = '{$_POST['codigo']}' AND lab_con_tpr_id = '{$_POST['ctg_tpr_id']}' AND lab_con_tpt_id = '{$_POST['ctg_tpt_id']}'"; //echo $sql."
"; $result = $connection->Execute ($sql); if ($result->fields[0] != "") { $reqmue='no'; } else { $reqmue='si'; } /* }else{ $reqmue='no'; } } */ //esta es la respuesta ajax que se introdujo para aprovechar el codigo //if ($_POST['op'] == "distribucion"){ //viene de la tabla para validar si tiene distribucion 2012-09-08 //ob_clean(); //limpiar buffer para respuesta ajax if($reqmue == 'no') echo "ok"; else echo $arr_label['falta_distribucion']; die(); } //if($reqmue=='no') { $sql="DELETE FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas WHERE adm_coe_numsol = '{$_POST['codigo']}' AND adm_coe_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_coe_tpt_id = '{$_POST['ctg_tpt_id']}'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() > 0) $info = $arr_label['datos_borrados']."(".$connection->Affected_Rows().")"; echo $sql."
[".$error."]
[".$info."]
"; //aqui estaba el delte del adm control y el insert del mismo y se traslado a watch_vus_tramites_op.php en elm omento de admitir $c = 0; $dias = 0; $fecha = date("Y-m-d"); $fecha_ant = $fecha; $etapa = ""; $q = explode(",",$_POST['str_check']); $x=count($q); $r=0; while($r<$x) { $sql="SELECT * 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='".$q[$r]."' ORDER BY ctg_tte_id"; echo "
ctg_tipo_tramites_etapas
".$sql."
"; $result = $connection->Execute ($sql); if (! $result->EOF) { //$fecha = date("Y-m-d"); while (!$result->EOF) { $operador = $result->fields; $inipro_dt = $fecha; $fecha = suma_fechas($fecha,$operador['ctg_tte_duracion']); echo "
fecha ant ".$fecha_ant."
"; echo "
dias ".$operador['ctg_tte_duracion']."
"; echo "
fecha actual".$fecha."
"; $c++; $finpro_dt = $fecha; $status = "0"; list($usr_tec) = explode(",",$operador["ctg_tte_usrs"]); if (empty($usr_tec)) $usr_tec = "''"; if ($c == 1) { //$usr_tec = "'".$_SESSION['ADMusuario_id']."'"; //$inipro_dt = date("Y-m-d H:i:s"); $finpro_dt = date("Y-m-d H:i:s"); $status = "4"; $etapa = $operador['ctg_tte_id']; } $dias += $operador['ctg_tte_duracion']; $sql1="INSERT INTO adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas ( adm_coe_numsol, adm_coe_tpt_id, adm_coe_tpr_id, adm_coe_tpe_id, adm_coe_tpe_orden, adm_coe_esa_id, adm_coe_tec_id, adm_coe_inipro_dt, adm_coe_dura, adm_coe_finpro, adm_coe_inicio, adm_coe_fin, adm_coe_bol, adm_coe_bolespres, adm_coe_bolresdt, adm_coe_res_dt, adm_coe_status, adm_coe_obs, adm_coe_docgen, adm_coe_docgen_ubi, adm_coe_sta, adm_coe_usr, adm_coe_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '".$operador['ctg_tte_id']."', '$c', '01{$_POST['ctg_tpr_id']}', $usr_tec, '".$fecha_ant."', '".$operador['ctg_tte_duracion']."', '".$fecha."', '".$fecha_ant."', '".$fecha."', '0', '0', '1900-01-01', '1900-01-01', '$status', '".$_POST['obs']."', '', '', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result1=$connection->Execute($sql1); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql1."
[".$error."]
[".$info."]
"; $fecha_ant = $fecha; //$fecha=$fecha_ant; $result->MoveNext(); if ($r == 0) { } } } $r++; } if ($error == "") { $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_etasig = '1', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '{$_SESSION['ADMusuario_id']}', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); //aca finaliza la etapa inicial 01 automaticamente al asignar las etapas $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET adm_con_dura = '$dias', adm_con_final_espe = '$fecha', adm_con_estatus = '0', adm_con_etapa = '$etapa', adm_con_obs = '".$_POST['obs']."', 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."]
"; if ($error == "") { iniciarConexionVUS(); /* //el update opcion 03020103 esta en form_adm_control_sel_evaluadores.php if ($_POST['op'] == "graba"){ $_POST['catalogo_prefijo'] = $_POST['catalogo_prefijo'].$_POST['tipo']."_"; $sql="UPDATE ".$_POST['tabla']." SET ".$_POST['catalogo_prefijo']."est_id = '8', ".$_POST['catalogo_prefijo']."sta = '2', ".$_POST['catalogo_prefijo']."usr = '".$_SESSION['ADMusuario_id']."', ".$_POST['catalogo_prefijo']."dt = now() WHERE ".$_POST['catalogo_prefijo']."numsol = '{$_POST['codigo']}' AND ".$_POST['catalogo_prefijo']."tpr_id = '{$_POST['ctg_tpr_id']}' AND ".$_POST['catalogo_prefijo']."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."]
"; if ($error == "") { */ $sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_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\" ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '8', now(), '".$_POST['obs']."', '".$_SESSION['ADMusuario_id']."', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connectionVUS->Execute($sql); /* $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; */ //} } } //} else $info = $arr_label['falta_distribucion']; break; case '030503': //re asignacion de procesos /* $sql="DELETE FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas WHERE adm_coe_numsol = '{$_POST['codigo']}' AND adm_coe_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_coe_tpt_id = '{$_POST['ctg_tpt_id']}'"; $result = $connection->Execute ( $sql ); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() > 0) $info = $arr_label['datos_borrados']."(".$connection->Affected_Rows().")"; echo $sql."
[".$error."]
[".$info."]
"; //aqui estaba el delte del adm control y el insert del mismo y se traslado a watch_vus_tramites_op.php en elm omento de admitir $c = 0; $dias = 0; $fecha = date("Y-m-d H:i:s"); $fecha_ant = $fecha; $etapa = ""; */ echo "
";
//print_r($_POST);
echo "
"; $q = explode(",",$_POST['str_check']); $x=count($q); $r=0; while($r<$x) { $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET adm_coe_status = 0, adm_coe_sta = '2', adm_coe_usr = '".$_SESSION['ADMusuario_id']."', adm_coe_dt = now() 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 = '".$q[$r]."'"; $result = $connection->Execute ( $sql ); echo "$sql
"; $error = $connection->ErrorMsg(); echo "Affected=".$connection->Affected_Rows()."
"; //if ($connection->Affected_Rows() > 0) //$info = $arr_label['datos_borrados']."(".$connection->Affected_Rows().")"; $r++; } if (empty($error)) $info = $arr_label['datos_grabados']; break; case '010109'://asignacion de procesos iniciarConexionVUS(); $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_est_id = '".$_POST['tts_id']."', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; $result=$connectionVUS->Execute($sql); $error =$connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; $arr_label[368]='se_cambio_status'; $arr_label[574]='estatus_actual'; $arr_label[1008]='estatus_ant'; $arr_label[10]='tipo_producto'; $arr_label[54]='tipo_tramite'; $arr_label[317]='tramite_no'; $arr_label[84]='nombre_producto'; $arr_label[14]='comentarios'; $arr_lang = "368,574,1008,10,54,317,84,14"; include ('form_language.php'); $comments = ""; if (!empty($_POST['obs'])) $comments .= "
".$arr_label['comentarios']."

".nl2br($_POST['obs'])."

"; //$comments .= "".$arr_label['se_cambio_status']."
".$arr_label['estatus_actual']." \"".$_POST['tts_desc_actual']."\"
". //$arr_label['estatus_ant']." \"".$_POST['tts_desc_ant']."\"
"; /* $body = "".$arr_label['informacion_tramite']."
".$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 = "Myanmar."; /* $body = $arr_label['tramite_no']." : ".$_POST['codigo']."
"; $body .= $arr_label['nombre_producto']." : ".$_POST['nomprod99']."
"; //$body .= "

".$fisico.$muestras.$texto."
".$comments."

"; //.$tabla_faltantes; $body .= "

".$soporte."
"; */ $subject = $arr_label['se_cambio_status']." ".$arr_label['tramite_no']." ".$_POST['codigo']; $headers = "From: $soporte <$company_email3>\nReply-To: $soporte <$company_email3>\nContent-Type: text/html; charset=UTF-8"; /* en linea 2466 se envia el email, ya no es necesario aca, solo arma el body $content = email_tpl($_POST['titulo_anterior'], $body,"../"); //2013-08-07 $send = mail($_POST['email'], $subject, $content, $headers); insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod99'],$_POST['email'],$subject,$body,$send,$_POST['id']); if ($send) $info .= "
".$arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio']; else $info .= "
".$arr_label['no_envio_correo']." ".$_POST['email']; */ break; default: iniciarConexionVUS(); $_POST['catalogo_prefijo1'] = $_POST['catalogo_prefijo']; if (strpos("***".$_POST['tabla'],"adm")) $_POST['catalogo_prefijo'] = $_POST['catalogo_prefijo']; else $_POST['catalogo_prefijo'] = $_POST['catalogo_prefijo'].$_POST['tipo']."_"; echo "
tabla=(".$_POST['tabla'].")catalogo_prefijo=(".$_POST['catalogo_prefijo'].")
";//2012-11-29 echo "[".$_POST['id']."][".$_POST['vus_est_id']."]"; $est_id = $_POST['vus_est_id']; switch($_POST['id']){ case '010101':$campo=10; $est_id_new = 1;break; //verificacion escribe 2 al estatus case '010102':$campo=1; $est_id_new = 2;break; //verificacion escribe 2 al estatus case '010103':$campo=3; if (intval($_POST['res_st']) == 3) $est_id_new = 7; else $est_id_new = 5; break; //pre chequeo case '010104': $est_id_new = 6;break; //recepcion expediente fisico case '010105':$campo=3; $est_id_new = 5;break; //chequeo genera numero de admision case '010106': $est_id_new = 6;break; //recepcion muestras para analisis // case '010107': $est_id_new = 8;break; //envio de resultados FINAL AUN NO PROGRAMADO case '030509': $est_id_new = 7;break; //rechazo // case '010109': $est_id_new = 7;break; //cambio de estatus para supervisor AUN NO PROGRAMADO } $etapa_inf = $campo; switch($_POST['id']){ case '030202'://Evaluacion case '030203'://Asesoria case '030204'://Calidad case '030205'://Coordinacion II case '030206'://Junta revisoria case '030207'://comision tecnica case '030208'://Resultado final puede que tambien entre aca case '030209'://Coordinacion III puede que tambien entre aca $etapa_inf = substr($_POST['id'],4,2); $ventanilla = 0; echo "000000000000000000"; $campo = intval(substr($_POST['id'],5,1)) + 2; break; //este viend de form_adm_control_etapa_evaluacion.php case '0302041'://Calidad $etapa_inf = '10'; $ventanilla = 0; echo "000000000000000000"; $campo = 10; break; //este viend de form_adm_control_etapa_evaluacion.php default :/* //OBTENER LEYENDAS DE ESTATUS ANTERIOR Y ACTUAL esto se movio hata abajo justo antes de mandar el email $i=0; $sql="SELECT ctg_tts_id,ctg_tts_desc FROM ctg_tipo_tramites_estatus WHERE ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND (ctg_tts_id In ('".$est_id."','".$est_id_new."'))"; //echo $sql."
"; $result = $connection->Execute ($sql); if (! $result->EOF) { while (!$result->EOF) { $i++; $des[$i] = $result->fields[1]; $result->MoveNext(); } } $dias_proc = 0; //OBTENER FECHA DE ESTATUS ANTERIOR $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}"_ESTATUS\" WHERE \"vus_{$_POST['tipo']}EST_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}EST_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}EST_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}EST_tts_id\" = '".$est_id."'"; echo $sql."
"; $result = $connectionVUS->Execute ($sql); if (! $result->EOF) { $operador = $result->fields; list($fecha,$hora) = explode(" ",$operador["vus_{$_POST['tipo']}EST_estatus_dt"]); // echo $operador["vus_{$_POST['tipo']}EST_estatus_dt"]."*".$fecha."***"; $dias_proc = resta_fechas($fecha,date("d-m-Y")); } $subject = $company." ".$arr_label['no'].". {$_POST['codigo']} ".$des[2]; $comments = "".$arr_label['se_cambio_status']."
". $arr_label['estatus_actual']." \"".$des[1]."\" ".fecha_usr($fecha)."
". $arr_label['estatus_anterior']." \"".$des[2]."\"
". $arr_label['dias_proceso']." ".$dias_proc; */ break; } switch($_POST['id']){ case '010104': //recepcion expediente fisico case '010106': //recepcion muestras para analisis case '010107': //envio de resultados FINAL case '030509': //rechazo $faltante_str = $_POST['catalogo_prefijo']."est_id = '".$est_id_new."',"; $cambio_status = true; if ($_POST['id'] == '010104'){ //recepcion expediente fisico /* $arr_label[649]='desc_fis'; $arr_label[650]='cantidad_fis'; $arr_label[651]='cds'; $arr_label[652]='cantidad_cds'; $arr_label[654]='ingreso_fisico'; $arr_lang = "649,650,651,652,654"; include ('form_language.php'); $a = $_POST['cds'] ? $arr_label['si'] : $arr_label['no']; $fisico = "
".$arr_label['desc_fis']."".$_POST['FIS_desc']."
".$arr_label['cantidad_fis']."".$_POST['FIS_cant']."
Reception date:".$a."
Reception number: ".$_POST['cds_cant']."
"; */ $sql="SELECT * FROM ctg_archivo_fisico WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arf_parent = '0'"; //echo $sql."
"; $_POST["ctg_arf_id"] = ""; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $_POST["ctg_arf_id"] = $operador['ctg_arf_id']; } $sql="INSERT INTO ctg_archivo_inven ( ctg_numsol_id, ctg_tpr_id, ctg_tpt_id, ctg_arf_id, ctg_afi_crea, ctg_afi_desc, ctg_afi_cant_ent, ctg_afi_cant_sal, ctg_afi_cant_saldo, ctg_afi_cds, ctg_afi_cds_ent, ctg_afi_cds_sal, ctg_afi_cds_saldo, ctg_afi_sta, ctg_afi_usr, ctg_afi_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpr_id']}', '{$_POST['ctg_tpt_id']}', '".$_POST["ctg_arf_id"]."', now(), '".$_POST['FIS_desc']."', '".$_POST['FIS_cant']."', '0', '".$_POST['FIS_cant']."', '".$_POST['cds']."', '".intval($_POST['cds_cant'])."', '0', '".intval($_POST['cds_cant'])."', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; $sql="SELECT * FROM ctg_archivo_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_arf_id = '".$_POST["ctg_arf_id"]."' AND ctg_esa_id = '0106{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $_POST['ctg_aft_id'] = 0; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $_POST['ctg_aft_id'] = $operador['ctg_aft_id']; } $_POST['ctg_aft_id']++; if ($_POST['cds'] == '1') $motivo = $arr_label['cds']; else $motivo = ""; $sql="INSERT INTO ctg_archivo_transac ( ctg_numsol_id, ctg_tpr_id, ctg_tpt_id, ctg_arf_id, ctg_esa_id, ctg_aft_id, ctg_aft_opeusr, ctg_aft_opedt, ctg_aft_tpoope, ctg_aft_motivo, ctg_aft_cant_ent, ctg_aft_cant_sal, ctg_aft_sta, ctg_aft_usr, ctg_aft_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpr_id']}', '{$_POST['ctg_tpt_id']}', '".$_POST["ctg_arf_id"]."', '0106{$_POST['ctg_tpr_id']}', '".$_POST['ctg_aft_id']."', '".$_SESSION['ADMusuario_id']."', now(), '1', '".$arr_label['ingreso_fisico']." ".$motivo."', '".$_POST['FIS_cant']."', '0', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } if ($_POST['id'] == '010106'){ //recepcion muestras para analisis /* $arr_label[653]='ingreso_muestra'; $arr_lang = "653"; include ('form_language.php'); $muestras = " "; */ ob_start(); include("watch_vus_tramites_muestras.php"); $muestras .= ob_get_contents(); ob_end_clean(); //$muestras .= "
"; $sql="SELECT * FROM ctg_muestras_archivo WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_arm_parent = '0'"; //echo $sql."
"; $_POST["ctg_arm_id"] = ""; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $_POST["ctg_arm_id"] = $operador['ctg_arm_id']; } $sql="INSERT INTO ctg_muestras_inven ( ctg_numsol_id, ctg_tpr_id, ctg_tpt_id, ctg_arm_id, ctg_ari_crea, ctg_ari_desc, ctg_ari_cant_ent, ctg_ari_cant_sal, ctg_ari_cant_saldo, ctg_ari_sta, ctg_ari_usr, ctg_ari_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpr_id']}', '{$_POST['ctg_tpt_id']}', '".$_POST["ctg_arm_id"]."', now(), '".$_POST['MUE_desc']."', '".$_POST['MUE_cant']."', '0', '".$_POST['MUE_cant']."', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; $sql="SELECT * FROM ctg_muestras_transac WHERE ctg_numsol_id = '{$_POST['codigo']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_arm_id = '".$_POST["ctg_arm_id"]."' AND ctg_esa_id = '0106{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $_POST['ctg_art_id'] = 0; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $_POST['ctg_art_id'] = $operador['ctg_art_id']; } $_POST['ctg_art_id']++; $sql="INSERT INTO ctg_muestras_transac ( ctg_numsol_id, ctg_tpr_id, ctg_tpt_id, ctg_arm_id, ctg_esa_id, ctg_art_id, ctg_art_opeusr, ctg_art_opedt, ctg_art_tpoope, ctg_art_motivo, ctg_art_cant_ent, ctg_art_cant_sal, ctg_art_sta, ctg_art_usr, ctg_art_dt ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpr_id']}', '{$_POST['ctg_tpt_id']}', '".$_POST["ctg_arm_id"]."', '0106{$_POST['ctg_tpr_id']}', '".$_POST['ctg_art_id']."', '".$_SESSION['ADMusuario_id']."', now(), '1', '".$arr_label['ingreso_muestra']."', '".$_POST['MUE_cant']."', '0', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; } break; case '010101'://verificacion case '010102'://verificacion case '010103'://pre chequeo case '010105'://chequeo admision case '030202'://Evaluacion case '030203'://Asesoria case '030204'://Calidad case '0302041'://Calidad case '030205'://Coordinacion II case '030206'://Junta revisoria case '030207'://comision tecnica ob_start(); echo "///////////////////////////////////////////////////////////////////////////////////////////////////////
"; echo "///////////////////////////".date("d/m/Y h:i:s")."////////////////////////////////////////////////////////////////////////////
"; echo "//////////////////////////// numsol = ".$_POST['codigo']."///////////////////////////////////////////////////////////////////////////
"; echo "//////////////////////////// menu = ".$_POST['id']."///////////////////////////////////////////////////////////////////////////
"; echo "
**************************************************** ".$_POST['id']."
"; /******************************************************* NUEVO ARCHIVO INF ********************************************************************************************/ $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKinf\" WHERE \"vus_{$_POST['tipo']}CHKi_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}CHKi_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}CHKi_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}CHKi_etapa\" = '".$etapa_inf."'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if (!$result->EOF) { $sql="UPDATE \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKinf\" SET \"vus_{$_POST['tipo']}CHKi_res_st\" = '".intval($_POST['res_st'])."', \"vus_{$_POST['tipo']}CHKi_res_ds\" = '".intval($_POST['res_ds'])."', \"vus_{$_POST['tipo']}CHKi_res_dt\" = now(), \"vus_{$_POST['tipo']}CHKi_res_us\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}CHKi_res_obs\" = '".$_POST['res_obs']."', \"vus_{$_POST['tipo']}CHKi_sta\" = '2', \"vus_{$_POST['tipo']}CHKi_usr\" = '".$_SESSION['ADMusuario_id']."', \"vus_{$_POST['tipo']}CHKi_dt\" =now() WHERE \"vus_{$_POST['tipo']}CHKi_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}CHKi_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}CHKi_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}CHKi_etapa\" = '".$etapa_inf."'"; } else { $sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_CHKinf\" ( \"vus_{$_POST['tipo']}CHKi_numsol\", \"vus_{$_POST['tipo']}CHKi_tpt_id\", \"vus_{$_POST['tipo']}CHKi_tpr_id\", \"vus_{$_POST['tipo']}CHKi_etapa\", \"vus_{$_POST['tipo']}CHKi_res_st\", \"vus_{$_POST['tipo']}CHKi_res_ds\", \"vus_{$_POST['tipo']}CHKi_res_dt\", \"vus_{$_POST['tipo']}CHKi_res_us\", \"vus_{$_POST['tipo']}CHKi_res_obs\", \"vus_{$_POST['tipo']}CHKi_sta\", \"vus_{$_POST['tipo']}CHKi_usr\", \"vus_{$_POST['tipo']}CHKi_dt\" ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '".$etapa_inf."', '".intval($_POST['res_st'])."', '".intval($_POST['res_ds'])."', now(), '".$_SESSION['ADMusuario_id']."', '".$_POST['res_obs']."', '1', '".$_SESSION['ADMusuario_id']."', now());"; } $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; echo $sql."
[".$error."]
[".$info."]
"; $arr_label[220]='categoria'; $arr_label[316]='doc_nombre'; $arr_label[14]='comentarios'; $arr_label[324]='parte'; $arr_label[1183]='comentarios_neg'; $arr_lang = "220, 316, 14, 324, 1183"; include ('form_language.php'); include_once('tabla_docs_html.php'); if ($ventanilla == 1) {//todos menos los de evaluacion if ($_POST['res_st'] == "2") { //2015-02-16 $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_numfal = COALESCE(vus_{$_POST['tipo']}_numfal,0) + 1, vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); } $vus_usr_id = 0; $_POST['numfal'] = 0; $sql="SELECT vus_{$_POST['tipo']}_numfal, vus_{$_POST['tipo']}_usr_id FROM vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); if (!$result->EOF) { $_POST['numfal'] = $result->fields[0];//2014-08-12 $vus_usr_id = $result->fields[1]; } $faltante = $_POST['numfal']; $tabla_faltantes .= "
"; $error = trim($error); echo "[$c][".$_POST['num_total']."] faltantes en mensaje=[$faltante]
"; //if ($c != $_POST['num_total'] || $_POST['res_st'] == "2" || $faltante > $adm_cnf_numfal) {//PASA DE ESTATUS if ($_POST['res_st'] == "2") {//PASA DE ESTATUS $hay_rechazo = 1; $cambio_status = false; $faltante_str = $_POST['catalogo_prefijo']."faltante = '1',"; //tiene faltante //$faltante_str = ""; esto era para que no le ponga faltante y me la deje en mi pantalla pruebas $tipo_mensaje = 1; //echo "(campo=$campo)(faltante=$faltante)(adm_cnf_numfal=$adm_cnf_numfal)"; //if ($campo == 3 || $faltante >= $adm_cnf_numfal) { 2017-10-28 if ($faltante >= $adm_cnf_numfal) { $hay_rechazo = 1; $cambio_status = true; $est_id_new = 7; //$faltante_str = $_POST['catalogo_prefijo']."faltante = '0',".$_POST['catalogo_prefijo']."est_id = '".$est_id_new."',";//quita el faltante $faltante_str = $_POST['catalogo_prefijo']."est_id = '".$est_id_new."',"; } if ($c == 0) $comments = "no tiene ni una sola respuesta de los documentos, avisar si sale este texto 09/12/2014";//creo que esto nunca deberia suceder pero por si acaso else $comments = $tabla_faltantes; if ($c == $_POST['num_total'] && $_POST['res_st'] == "2") $comments = ""; } if ($_POST['res_st'] == "3") {//rechaza desde 010105 //2018-01-09 $cambio_status = true; $faltante_str = $_POST['catalogo_prefijo']."est_id = '".$est_id_new."',"; $tipo_mensaje = 0; if ($campo == 3) { //2018-01-09 $dtb_vus = 1; } } echo $faltante_str."
"; //if ($c == $_POST['num_total'] && $_POST['res_st'] == "1") {//PASA DE ESTATUS if ($_POST['res_st'] == "1") {//PASA DE ESTATUS $cambio_status = true; $faltante_str = $_POST['catalogo_prefijo']."faltante = '0',".$_POST['catalogo_prefijo']."est_id = '".$est_id_new."',";//quita el faltante $tipo_mensaje = 0; if ($campo == 3) {// case '010105':$campo=3; $est_id_new = 5;break; //chequeo genera numero de admision //PROCESO DE ADMISION PARA ADM Y PARA VUS /* se paso hasta abajo cuando ya hizo el update y ejecuto los triggers $connectionADM1 = $connection; $connectionVUS1 = $connectionVUS; $usuario = $_SESSION['ADMusuario_id']; include("admitir_tramite.php"); */ $dtb_vus = 1; } //2017-10-22 if ($_POST['id'] == "010103" && $est_id_new = 5 ){ echo "GENERO CODIGO INTERNO
"; $sql="SELECT Extract(month from current_date) as mes, Extract(dow from current_date) as dia, cast(to_char(current_timestamp, 'HH24MISS') as integer) as hora, cast(to_char(current_timestamp, 'HH24MISS') as integer) + 240870 as hrs, 'DCDFDAV' || chr(cast( Extract(month from current_date) as integer)+ 64) || cast(cast(Extract(dow from current_date) as integer) + 1 as text) || cast(cast(to_char(current_timestamp, 'HH24MISS') as integer) + 240870 as text) as adm_con_codidoc"; $adm_con_codidoc = ""; echo $sql."
"; $result=$connection->Execute($sql); if (!$result->EOF) { $adm_con_codidoc = $result->fields['adm_con_codidoc'].$_POST['codigo']; } $faltante_str .= $_POST['catalogo_prefijo']."codidoc = '$adm_con_codidoc',"; file_put_contents("hhh.txt",$sql."\n".$faltante_str); } } } break; } $comments = ""; $arr_label[576]='dias_proceso'; $arr_label[368]='se_cambio_status'; $arr_label[574]='estatus_actual'; $arr_label[575]='estatus_anterior'; $arr_label[502]="resultado"; $arr_label[10]='tipo_producto'; $arr_label[54]='tipo_tramite'; $arr_label[317]='tramite_no'; $arr_label[84]='nombre_producto'; $arr_label[1377]='faltante'; $arr_label[505]='no_conforme'; $arr_label[323]='conforme'; $arr_label[14]='comentarios'; $arr_label[1237] = 'saludo_faltante'; $arr_label[1238] = 'saludo_faltante1'; $arr_label[1239] = 'saludo_faltante2'; $arr_label[1342] = 'model10_part1'; $arr_label[1343] = 'model10_part2'; $arr_label[1344] = 'model10_part3'; $arr_label[1345] = 'model10_part4'; $arr_label[1346] = 'model10_part5'; $arr_label[1347] = 'model9_part1'; $arr_label[1348] = 'model9_part2'; $arr_label[1349] = 'model9_part3'; $arr_label[1350] = 'model9_part4'; $arr_label[1351] = 'model12_part1'; $arr_label[1352] = 'model12_part2'; $arr_label[1353] = 'model12_part3'; $arr_label[1354] = 'model11_part1'; $arr_label[1355] = 'model11_part2'; $arr_label[1353] = 'model11_part3'; $arr_label[1356] = 'model13_part1'; $arr_label[1357] = 'model13_part2'; $arr_label[1358] = 'model131_part1'; $arr_lang = "576,368,574,575,502,10,54,317,84,367,505,323,14,1237,1238, 1239, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350,1351,1352,1353,1354,1355,1356,1357,1358,1377"; include ('form_language.php'); switch($_POST['id']){ case '030202'://Evaluacion case '030203'://Asesoria case '030204'://Calidad case '0302041'://Calidad case '030205'://Coordinacion II case '030206'://Junta revisoria case '030207'://comision tecnica case '030208': //Resultado final puede que tambien entre aca case '010109': //Resultado final puede que tambien entre aca break; //este viend de form_adm_control_etapa_evaluacion.php default : //OBTENER LEYENDAS DE ESTATUS ANTERIOR Y ACTUAL $sql="SELECT ctg_tts_id,ctg_tts_desc FROM ctg_tipo_tramites_estatus WHERE ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND (ctg_tts_id In ('".$est_id."','".$est_id_new."'))"; echo $sql."
"; $result = $connection->Execute ($sql); if (! $result->EOF) { while (!$result->EOF) { $des[] = $result->fields[1]; $result->MoveNext(); } } if ($cambio_status) { $subject = $des[1]." ".$arr_label['no'].". ".$_POST['codigo']; //OBTENER FECHA DE ESTATUS ANTERIOR /* $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_ESTATUS\" WHERE \"vus_{$_POST['tipo']}EST_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}EST_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}EST_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}EST_tts_id\" = '".$est_id."'"; echo $sql."
"; $dias = ""; $dias_proc = 0; $result = $connectionVUS->Execute ($sql); if (! $result->EOF) { $operador = $result->fields; list($fecha,$hora) = explode(" ",$operador["vus_{$_POST['tipo']}EST_estatus_dt"]); $dias_proc = resta_fechas($fecha,date("d-m-Y")); } if ($dias_proc > 0) $dias = $arr_label['dias_proceso']." ".$dias_proc."
"; */ //$comments = "
".$arr_label['se_cambio_status']."
". //$arr_label['estatus_anterior']." \"".$des[0]."\" ".fecha_usr($fecha)."
". //$arr_label['estatus_anterior']." \"".$des[0]."\"
". //$arr_label['estatus_actual']." \"".$des[1]."\"

"; // dias=(".$dias.")".$comments; } else $subject = $des[0]." ".$arr_label['no'].". ".$_POST['codigo']; if ($tipo_mensaje == 1) { if ($faltante=1){ // $subject .= " (".$arr_label['faltante']." $faltante)"; // $subject2 .= " (".$arr_label['faltante']." $faltante)"; $subject .= " ".$arr_label['faltante']; $subject2 .= " ".$arr_label['faltante']; } } break; } echo "(campo=$campo)(res_obs={$_POST['res_obs']})(cambio_estatus=$cambio_status)(INFORMACION=$faltante_str)
"; /* if (!empty($_POST['res_obs'])) $comments .= "
".nl2br($_POST['res_obs']); */ if(($_POST['id']=='010104' OR $_POST['id']=='010103' OR $_POST['id']=='010105' OR $_POST['id']=='010403') && $est_id_new == 5 && $_POST['res_st'] == "1"){ //traido aqui desde admitir_tramite.php $sql="SELECT ctg_tpt_req_formula, ctg_tpt_sigadm FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; $result = $connection->Execute ($sql); if (!$result->EOF) { $operador = $result->fields; $ctg_tpt_sigadm = $operador['ctg_tpt_sigadm']; } $sql="SELECT ctg_tpr_coradm FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; // echo$sql."
"; $numadmi = 0; $result=$connection->Execute($sql); if (!$result->EOF) { $operador = $result->fields; $numadmi = intval($operador['ctg_tpr_coradm']); } $numadmi++; $sql="UPDATE ctg_tipo_productos SET ctg_tpr_coradm='".$numadmi."', ctg_tpr_sta = '2', ctg_tpr_usr = '".$_SESSION['ADMusuario_id']."', ctg_tpr_dt = now() WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; // echo$sql."
"; $result = $connection->Execute ( $sql ); echo "(numadmi=$numadmi)(ctg_tpt_sigadm=$ctg_tpt_sigadm)(tipo={$_POST['tipo']})(y=".date("y").")"; //$numadmi = strtoupper($_POST['tipo']) . "-" . date("y") . "-" . sprintf("%05d",$numadmi); $numadmi = sprintf("%05d",$numadmi); if (!empty($ctg_tpt_sigadm)) $numadmi = $ctg_tpt_sigadm . "-" . $numadmi; echo "(numadmi=$numadmi)
"; if (!empty($faltante_str)) { $faltante_str .= $_POST['catalogo_prefijo']."numadmi = '".$numadmi."', ".$_POST['catalogo_prefijo']."fecadmi = '".date("Y-m-d")."', ".$_POST['catalogo_prefijo']."usradmi_id = '".$_SESSION['ADMusuario_id']."',"; } } if ($ventanilla == 1) {//todos menos los de evaluacion $texto = ""; if ($_POST['res_st'] == '1') { $texto = "(No hay texto en emails db) catalogo = [".$_POST['id']."]"; $sql="SELECT ctg_ema_obs FROM ctg_emails WHERE (ctg_tpr_id = '{$_POST['ctg_tpr_id']}') AND (ctg_ema_id = '".$_POST['id']."')"; $result = $connection->Execute ($sql); $error = $connection->ErrorMsg(); if (! $result->EOF) $texto = "
".$result->fields[0]; } $table_info .= ""; $table_info .= "Date: ".date("d-m-Y")."

"; $table_info .= "
".$arr_label['estimado']; $table_info .= "
".$_POST['nombre']; $table_info .= "

"; //$table_info .= "
".$arr_label['informacion_general'].""; /*$table_info .= "
".$arr_label['tipo_producto']." :".$_POST['ctg_tpr_desc']." (".$_POST['titulo_anterior'].")"; $table_info .= "
".$arr_label['tipo_tramite']." :".$_POST['ctg_tpt_desc']; */ $table_info .= "
".$arr_label['tramite_no']." :".$_POST['codigo']; $table_info .= "
".$arr_label['nombre_producto'].":".$_POST['nomprod99'].", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta']; $table_info .= "
"; /* $body = "".$arr_label['informacion_tramite']."
".$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['nomprod99']; $body .= "
"; */ if ($hay_rechazo == 1 && $est_id_new == 7) { /// ESTE ES EL RECHAZO AUTOMATICO // if ($_POST['res_st'] == '2') { $body = $table_info; switch($_POST['id']){ case '010101': case '010102': case '010103': $body .= "
".$arr_label['model11_part1']." ".fecha_usr($_POST['fecha'])."

".$arr_label['model11_part2']."

".$arr_label['model11_part3']; break; case '010104': case '010106': $body .= "
".$arr_label['model12_part1']."

".$arr_label['model12_part2']."

".$arr_label['model12_part3']; break; } // $headers = "From: $soporte <$company_email3>\nReply-To: $soporte <$company_email3>\nContent-Type: text/html; charset=UTF-8"; /* en linea 2466 se envia el email, ya no es necesario aca, solo arma el body $content = email_tpl($arr_label['informacion_tramite'],$body); $send = mail($_POST['email'], $subject2, $content, $headers); insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod99'],$_POST['email'],$subject2,$body,$send,$_POST['id']); */ $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_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_sta\", \"vus_{$_POST['tipo']}MSG_usr\", \"vus_{$_POST['tipo']}MSG_dt\", \"vus_{$_POST['tipo']}MSG_fecven\", \"vus_{$_POST['tipo']}MSG_fecfal\", \"vus_{$_POST['tipo']}MSG_falsta\", \"vus_{$_POST['tipo']}MSG_nomprod\" ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '".$tipo_mensaje."', now(), '".$subject."', '".$body."', '".$vus_usr_id."', '".$_SESSION['ADMnivel']."', '1', '".$_SESSION['ADMusuario_id']."', now(), '".$_POST['fecha']."', now(), '1', '{$_POST['nomprod99']}');"; echo "($sql)"; $result=$connectionVUS->Execute($sql); echo "//////////////////////////////////////////
"; echo $content; echo "//////////////////////////////////////////
"; } else { $body = $table_info; switch($_POST['id']){ case '010101': case '010102': case '010103': switch($_POST['res_st']){ case 1:{ //aqui la fecha es la del sistema mas 2 meses $_POST['fechaven'] = suma_fechas($_POST['fecha'],60);//recibe en formato d-m-Y y retorna Y-m-d $body .= "
".$arr_label['model9_part1']." ".fecha_usr($_POST['fechaven'])."

".$arr_label['model9_part2']."".$arr_label['model9_part3']."
".$arr_label['model9_part4']; $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_fislim ='".$_POST['fechaven']."', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); } break; case 2:{// aqui la fecha es la de vencimiento del faltante, o sea la fecha del sistema + los dias que le dara el evaluador en days for response $dias = intval($_POST['res_ds']); if ($dias > 0) $_POST['fechaven'] = suma_fechas($_POST['fecha'],$dias);//recibe en formato d-m-Y y retorna Y-m-d $body .= "
".$arr_label['model10_part1']." ".fecha_usr($_POST['fechaven'])."

".$arr_label['model10_part2']."
".$arr_label['model10_part3']."
".$arr_label['model10_part4']."
"; $body .= $arr_label['model10_part5']."
"; if (!empty($_POST['res_obs'])) $body .= nl2br($_POST['res_obs']); $body .= "

".$tabla_docs_obs; //2013-03-12 } break; case 3: $body .= "
".$arr_label['model12_part1']."

".$arr_label['model12_part2']."

".$arr_label['model12_part3']; break; } break; case '010104': $body .= "
".$arr_label['model13_part1']."

".$arr_label['model13_part2']; break; case '010106': $body .= "
".$arr_label['model131_part1']; break; } } // if ($_POST['res_st'] == '2') // $body .= "
".$arr_label['saludo_faltante1']; //$body .= "

".$soporte."
"; // if (!$cambio_status) revisar cuantos mensaje hay de faltante anteriormente si ya hay 3 sacarla o retirarla estatus 7 // ya esta hecho en linea 1771 //ACTUALIZA LA TABLA DE TRAMITES if (!empty($faltante_str)) { if (strpos("***".$_POST['tabla'],"adm")) { $_POST['catalogo_prefijo'] = $_POST['catalogo_prefijo1']; } $sql="UPDATE ".$_POST['tabla']." SET $faltante_str ".$_POST['catalogo_prefijo']."sta = '2', ".$_POST['catalogo_prefijo']."usr = '".$_SESSION['ADMusuario_id']."', ".$_POST['catalogo_prefijo']."dt = now() WHERE ".$_POST['catalogo_prefijo']."numsol = '{$_POST['codigo']}' AND ".$_POST['catalogo_prefijo']."tpr_id = '{$_POST['ctg_tpr_id']}' AND ".$_POST['catalogo_prefijo']."tpt_id = '{$_POST['ctg_tpt_id']}' "; //echo $sql."
"; if (strpos("***".$_POST['tabla'],"adm")) { echo "entro
"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if ($connection->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; } else { //$sql .= " AND ".$_POST['catalogo_prefijo']."est_id = '".$est_id."'"; $result=$connectionVUS->Execute($sql); $error = $connectionVUS->ErrorMsg(); if ($connectionVUS->Affected_Rows() == 1) $info = $arr_label['datos_grabados']; } echo $sql."
[".$error."]
[".$info."]
"; } if ($error == "") { if ($cambio_status) { $sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}_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\" ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '".$est_id_new."', now(), '".$_POST['obs']."', '".$_SESSION['ADMusuario_id']."', '1', '".$_SESSION['ADMusuario_id']."', now());"; $result=$connectionVUS->Execute($sql); echo $sql."
"; //2018-01-09 } if ($hay_rechazo == 1) { //2014-07-19 $_POST['fecha'] = date("Y-m-d"); $dias = intval($_POST['res_ds']); if ($dias > 0) $_POST['fecha'] = suma_fechas($_POST['fecha'],$dias);//recibe en formato d-m-Y y retorna Y-m-d // echo "
[fecha=".$_POST['fecha']."][$dias]*
(fecha_bol={$_POST['bolresdt']})"; /* $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET vus_{$_POST['tipo']}_numfal = COALESCE(vus_{$_POST['tipo']}_numfal,0) + 1, vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."', vus_{$_POST['tipo']}_dt =now() WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); $vus_usr_id = 0; $sql="SELECT vus_{$_POST['tipo']}_numfal, vus_{$_POST['tipo']}_usr_id FROM vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); if (!$result->EOF) { $_POST['numfal'] = $result->fields[0];//2014-08-12 $vus_usr_id = $result->fields[1]; } */ $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_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_sta\", \"vus_{$_POST['tipo']}MSG_usr\", \"vus_{$_POST['tipo']}MSG_dt\", \"vus_{$_POST['tipo']}MSG_fecven\", \"vus_{$_POST['tipo']}MSG_fecfal\", \"vus_{$_POST['tipo']}MSG_falsta\", \"vus_{$_POST['tipo']}MSG_nomprod\" ) VALUES ( '{$_POST['codigo']}', '{$_POST['ctg_tpt_id']}', '{$_POST['ctg_tpr_id']}', '".$tipo_mensaje."', now(), '".$subject."', '".$body."', '".$vus_usr_id."', '".$_SESSION['ADMnivel']."', '1', '".$_SESSION['ADMusuario_id']."', now(), '".$_POST['fecha']."', now(), '1', '{$_POST['nomprod99']}');"; echo "($sql)"; $result=$connectionVUS->Execute($sql); } } if ($error != '') { echo "error = (1)[$error]
"; include_once ("send_error_mail.php"); $error = 1; $info = ""; } else { //echo "2015-02-17 (email={$_POST['email']})
"; if (trim($_POST['email']) != "") { //de donde viene este email 18/11/2010 $email_empresa = ""; $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}{$dtb_vus}_EMPRESAS\" WHERE \"vus_{$_POST['tipo']}EMP_numsol\" = '{$_POST['codigo']}' AND \"vus_{$_POST['tipo']}EMP_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}EMP_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}EMP_repr\" = '1'"; echo $sql."
"; $result=$connectionVUS->Execute($sql); if (!$result->EOF) { while ( !$result->EOF ) { $operador = $result->fields; //if ($email_empresa != "") $email_empresa .= ","; if (!empty($operador["vus_{$_POST['tipo']}EMP_email1"])) $email_empresa[]=$operador["vus_{$_POST['tipo']}EMP_email1"]; else $email_empresa[] = $operador["vus_{$_POST['tipo']}EMP_email2"]; $email_nombre[] = $operador["vus_{$_POST['tipo']}EMP_nombre"]." ".trim($operador["vus_{$_POST['tipo']}EMP_nom1"]." ".$operador["vus_{$_POST['tipo']}EMP_nom2"]." ".$operador["vus_{$_POST['tipo']}EMP_ape1"]." ".$operador["vus_{$_POST['tipo']}EMP_ape2"]); $result->MoveNext(); } } //$company_email3="info@siamedweb.com"; $headers = "From: $soporte <$company_email3>\nReply-To: $soporte <$company_email3>\nContent-Type: text/html; charset=UTF-8"; $content = email_tpl($arr_label['informacion_tramite'],$body); //$_POST['email'] = "monterrosow@gmail.com"; $send = mail($_POST['email'], $subject, $content, $headers); insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod99'],$_POST['email'],$subject,$body,$send,$_POST['id']); echo "


email ".$_POST['email']."

"; /* if ($email_empresa != "") { //$body .= "
se envia copia a estos correos de empresas :
$email_empresa
"; //$body2 = "".$arr_label['informacion_tramite']."
".$arr_label['estimado']." ".$_POST['nombre'].":
"; $body2 = "".$arr_label['informacion_tramite']."
".$_POST['nombre'].":
"; foreach ($email_nombre as $key => $value) { $body1 = str_replace($_POST['nombre'], $value, $body2); $body1 .="
esta es una copia del correo

"; $body1 .=$body; $send = mail($email_empresa[$key], $subject, $body1, $headers);//copia ya no quiero copias echo "
[
".$email_empresa[$key]." ".$value."
]
"; } } */ if ($send) $info .= "
".$arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio']; else $info .= "
".$arr_label['no_envio_correo']." ".$_POST['email']; //$error = 2;//"no pudo enviar correo a ".$_POST['email']; } else $error = 3;//"No se encontro cuenta de correo"; } } //echo $sql."
[".$error."]
[".$info."]
"; }//este es del switch de hasta arriba //sleep(1); echo "error = [$error]
"; echo "id=".$_POST['id']." est_id_new=".$est_id_new."
"; if(($_POST['id']=='010104' OR $_POST['id']=='010103' OR $_POST['id']=='010105') && $est_id_new == 5){ $connectionADM1 = $connection; $connectionVUS1 = $connectionVUS; $usuario = $_SESSION['ADMusuario_id']; //$_POST['tipo'] = $_POST['tipo']; //$_POST['ctg_tpr_id'] = $_POST['ctg_tpr_id']; ob_start(); include("admitir_tramite.php"); echo "

******* COPIAR INGREDIENTES ******

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

******* COPIAR EMPRESAS ******

"; include_once ('admitir_empresas.php'); //if ($ip_ext == $ip_int) local_download($_POST['tipo'],$_POST['ctg_tpt_id'],$_POST['codigo'],$_POST['ctg_tpr_id'],1); //else // ftp_download($_POST['tipo'],$_POST['ctg_tpt_id'],$_POST['codigo'],$_POST['ctg_tpr_id'],1); //echo "

******* COPIAR REGENTE ******

"; //include_once ('copiar_regente.php'); $out1 = ob_get_contents(); ob_end_clean(); file_put_contents("admitir_tramite.txt",$out1); } $log = ob_get_contents(); ob_end_clean(); $log_1 = ""; if (is_file("boleta_guarda_docs.txt")) $log_1 = file_get_contents("boleta_guarda_docs.txt"); $log_1 = str_replace("
","\n",$log) . $log_1; file_put_contents("boleta_guarda_docs.txt",$log_1); echo "($ventanilla)"; if ($ventanilla == 1) { //todos menos los de evaluacion porque todavia tiene que hacer otro submit en form_adm_control_etapa_evaluacion linea 2 $codigo = $_POST['codigo']; if ($error != "" && $error != "1") { include_once ("send_error_mail.php"); //$error = 1; $info = ""; } echo "(hay_faltante=$hay_rechazo)(faltante={$_POST['numfal']})(adm_cnf_numfal=$adm_cnf_numfal)($info)($est_id_new)";//2014-07-24 if ($hay_rechazo == 1 && $_POST['numfal'] >= $adm_cnf_numfal && $est_id_new == 7 && $info != "") { $info .= "
".$arr_label['rechazada_faltas']; } ?>