Execute($sql); if (!$result->EOF) { $user_level=$result->fields[0]; $user_alias=$result->fields[1]; } /* if ($_POST['id'] == '03020501' ) { //si es no conforme o conforme 2010-07-22 $disabled = " disabled "; $class = "text-view"; $window = true;//edicion de textarea ?>
".$arr_label['etapa']." ".$arr_label['evaluador']." ".$arr_label['estatus']." ".$arr_label['comentarios']." ".$arr_label['resultado_revision']." ".$arr_label['conforme']." ".$arr_label['comentarios']." "; */ echo ""; $arr_status["1"] = $arr_label['proceso']; $arr_status["2"] = $arr_label['boleta']; $arr_status["3"] = $arr_label['no_conforme']; $arr_status["4"] = $arr_label['conforme']; $arr_status["5"] = $arr_label['evaluador']; $sql="SELECT * 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']."' AND "; switch ($_POST['id']) { case '030205': $sql.="adm_coe_tpe_id BETWEEN '02' AND '042' ORDER BY adm_coe_tpe_orden"; break; case '0302B0501': $sql.="adm_coe_tpe_id BETWEEN '02' AND '04' ORDER BY adm_coe_tpe_orden"; break; case '0302A0501': $sql.="adm_coe_tpe_id BETWEEN '02' AND '03' ORDER BY adm_coe_tpe_orden"; break; case '03020701': case '03020702': case '03020703': case '030208': $sql.="adm_coe_tpe_id IN ('02','03','04','041','042','05') ORDER BY adm_coe_tpe_orden"; break; case '030207': $sql.="adm_coe_tpe_id IN ('02','03','04','041','042','05','06') ORDER BY adm_coe_tpe_orden"; break; default: $sql.="adm_coe_tpe_id IN ('02','03','04','041','042','05','07') ORDER BY adm_coe_tpe_orden"; break; } // echo $sql."
"; $result=$connection->Execute($sql); $error = $connection->ErrorMsg(); if (!$result->EOF) { while ( !$result->EOF ) { $operador = $result->fields; // echo "(".$operador["adm_coe_tpe_id"].")(".$operador['adm_coe_status'].")"; if ($_POST['id'] == "030205" || $_POST['id'] == "030208" || $_POST['id'] == "03020701" || $_POST['id'] == "03020702" || $_POST['id'] == "03020703" || $_POST['id'] == "03020A5" || $_POST['id'] == "0302A06" || $_POST['id'] == "0302A0701" || $_POST['id'] == "0302A0702" || $_POST['id'] == "0302B05" || $_POST['id'] == "0302B06" || $_POST['id'] == "0302B0701" || $_POST['id'] == "0302B0702") //echo "operador (".$operador['adm_coe_tpe_id'].") substr (".substr($_POST['id'],4,2).")"; //if ($operador['adm_coe_tpe_id'] >= substr($_POST['id'],4,2)) // break; $_POST['arr_res_final1'] = ""; $_POST['arr_res_final2'] = ""; /* $sql="SELECT * 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']."' AND adm_coe_tpe_id = '".$operador["adm_coe_tpe_id"]."'"; //echo $sql."
"; $result2=$connection->Execute($sql); if (!$result2->EOF) { $operador2 = $result2->fields; */ if ($operador["adm_coe_rf_status"] == '4') $_POST['arr_res_final1'] = " checked "; if ($operador["adm_coe_rf_status"] == '3') $_POST['arr_res_final2'] = " checked "; $_POST['arr_obs_final'] = $operador['adm_coe_rf_obs']; /* } */ $sql="SELECT * FROM ctg_tipo_tramites_etapas WHERE ctg_tpr_id = '".$operador["adm_coe_tpr_id"]."' AND ctg_tpt_id = '".$operador["adm_coe_tpt_id"]."' AND ctg_tte_id = '".$operador["adm_coe_tpe_id"]."'"; // echo $sql."
"; $result5=$connection->Execute($sql); if (!$result5->EOF) { $operador5 = $result5->fields; $_POST['adm_coe_etapa_desc'] = $operador5['ctg_tte_desc']; } $_POST['adm_coe_estatus_desc'] = "..."; $_POST['adm_coe_tec_name'] = ""; switch ($operador["adm_coe_tpe_id"]) { case '02': case '03': case '04': case '041': switch ($operador['adm_coe_status']) { case '1': case '0': $_POST['adm_coe_estatus_desc']=$arr_label['proceso']; break; case '5': $_POST['adm_coe_estatus_desc']=$arr_label['preboleta']; break; case '2': $_POST['adm_coe_estatus_desc']=$arr_label['boleta']; break; case '3': $_POST['adm_coe_estatus_desc']=$arr_label['no_conforme']; break; case '4': $_POST['adm_coe_estatus_desc']=$arr_label['conforme']; break; default: $_POST['adm_coe_estatus_desc']="N/A"; break; } break; case '042': switch ($operador['adm_coe_status']) { case '1': case '0': $_POST['adm_coe_estatus_desc']=$arr_label['qc_notappli']; break; case '3': $_POST['adm_coe_estatus_desc']=$arr_label['qc_fail']; break; case '4': $_POST['adm_coe_estatus_desc']=$arr_label['qc_pass']; break; default: $_POST['adm_coe_estatus_desc']="N/A"; break; } break; case '05': switch ($operador['adm_coe_status']) { case '1': case '0': $_POST['adm_coe_estatus_desc']=$arr_label['proceso']; break; case '2': $_POST['adm_coe_estatus_desc']=$arr_label['send-loq']; break; case '4': $_POST['adm_coe_estatus_desc']=$arr_label['conforme']; break; case '3': $_POST['adm_coe_estatus_desc']=$arr_label['no_conforme']; break; default: $_POST['adm_coe_estatus_desc']="N/A"; break; } break; } $sql = "SELECT * FROM adm_usuarios WHERE adm_usr_ci = '".$operador['adm_coe_tec_id']."'"; $result1=$connection->Execute($sql); if (!$result1->EOF) { $_POST['adm_coe_tec_name'] = $result1->fields[6]; } if ($disabled == "") $ver = "false"; else $ver = "true"; $onClick = " title=\"Click para revisar Expediente: ".$_POST['adm_coe_etapa_desc']."\" onClick=\"selecciona_etapa('".$_POST['adm_coe_tec_id']."','".$_POST['adm_coe_etapa_desc']."','".$_POST['ctg_tpr_id']."','".$_POST['ctg_tpt_id']."','".$_POST['codigo']."','".$_POST['tipo']."','0302".$operador["adm_coe_tpe_id"]."','$ver');\""; echo ""; if ($_POST['id']) $disabled=" Disabled "; $fec = substr(fecha_usr($operador["adm_coe_res_dt"]),0,10); if (empty($disabled)) { echo ""; echo "
$fec"; } else { if (!empty($_POST['arr_res_final1'])) echo $arr_label['si']." ".$fec; if (!empty($_POST['arr_res_final2'])) echo $arr_label['no']." ".$fec; } switch ($operador['adm_coe_tpe_id']) { case '02': $intcode="ADM"; break; case '03': $intcode="QUA"; break; case '04': $intcode="CLI"; break; case '041': $intcode="QCL"; break; case '042': $intcode="NCLI"; break; case '05': $intcode="QUA"; break; } $adm_coe_pdf=''; $view_etapas=''; $sqle="SELECT * FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_docs WHERE adm_cod_numsol = '".$_POST['codigo']."' AND adm_cod_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_cod_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_cod_ttc_id = '".$intcode."' "; $resulte=$connection->Execute($sqle); if (!$resulte->EOF) { $adm_coe_pdf='yes'; } $viewetapas='yes'; // $sqlve="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_DOCs\" WHERE // \"vus_{$_POST['tipo']}DOC_numsol\" = '".$_POST['codigo']."' AND // \"vus_{$_POST['tipo']}DOC_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND // \"vus_{$_POST['tipo']}DOC_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND // \"vus_{$_POST['tipo']}DOC_ttc_id\" = '".$intcode."' "; // $resultve=$connectionVUS->Execute($sqlve); // if (!$resultve->EOF) { // // $viewetapas='yes'; // } $varecho=""; switch ($operador["adm_coe_tpe_id"]) { case '05': case '042': case '07': $varecho .= " */ $result->MoveNext (); } $sql="SELECT * 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']."'"; //echo $sql; $result7=$connection->Execute($sql); if (!$result7->EOF) { $operador7 = $result7->fields; switch ($_POST['id']) { case '03020702': if ($operador7['adm_con_dec1_st']=='3') $status_desc=$arr_label['dnapprove']; else if ($operador7['adm_con_dec1_st']=='4') $status_desc=$arr_label['approve']; else $status_desc=$arr_label['proceso']; echo "
".$arr_label['etapa']." ".$arr_label['evaluador']." ".$arr_label['estatus']." ".$arr_label['comentarios']."
".$_POST['adm_coe_etapa_desc']." ".$_POST['adm_coe_tec_name']." ". $_POST['adm_coe_estatus_desc']." "; if (!empty($viewetapas)){ $varecho .=" "; $varecho .= "
"; } $varecho .= "		".(empty($adm_coe_pdf) ? "" : "")."
"; break; default: $varecho .= "		 "; if (!empty($viewetapas)){ $varecho .=" "; $varecho .= " "; $varecho .= "
"; } $varecho .= "		".(empty($adm_coe_pdf) ? "" : "")."
"; break; } echo $varecho; /* este iba antes de la comilla con el punto y coma
Outcome of assessment ".$_POST['adm_coe_tec_name']." ".$status_desc." ".fecha_usr(substr($operador7['adm_con_dec1_dt'],0,10))." ".substr($operador7['adm_con_dec1_dt'],11,10)." "; echo "
"; break; case '03020703': if ($operador7['adm_con_dec1_st']=='3') $status_desc=$arr_label['dnapprove']; else if ($operador7['adm_con_dec1_st']=='4') $status_desc=$arr_label['approve']; else $status_desc=$arr_label['proceso']; echo "
Outcome of assessment ".$_POST['adm_coe_tec_name']." ".$status_desc." ".fecha_usr(substr($operador7['adm_con_dec1_dt'],0,10))." ".substr($operador7['adm_con_dec1_dt'],11,10)." "; echo "
"; if ($operador7['adm_con_dec2_st']=='3') $status_desc=$arr_label['dnapprove']; else if ($operador7['adm_con_dec2_st']=='4') $status_desc=$arr_label['approve']; else if ($operador7['adm_con_dec2_st']=='7') $status_desc=$arr_label['reassess']; else $status_desc=$arr_label['proceso']; echo "
   Verification of outcome ".$_POST['adm_coe_tec_name']." ".$status_desc." ".fecha_usr(substr($operador7['adm_con_dec2_dt'],0,10))." ".substr($operador7['adm_con_dec2_dt'],11,10)." "; echo "
"; break; case '030208': if ($operador7['adm_con_dec1_st']=='3') $status_desc=$arr_label['no-conform']; else if ($operador7['adm_con_dec1_st']=='4') $status_desc='Conform'; else $status_desc='Unselect'; echo "
Outcome of assessment ".$_POST['adm_coe_tec_name']." ".$status_desc." ".fecha_usr(substr($operador7['adm_con_dec1_dt'],0,10))." ".substr($operador7['adm_con_dec1_dt'],11,10)." "; echo "
"; if ($operador7['adm_con_dec2_st']=='3') $status_desc=$arr_label['dnapprove']; else if ($operador7['adm_con_dec2_st']=='4') $status_desc=$arr_label['approve']; else if ($operador7['adm_con_dec2_st']=='7') $status_desc=$arr_label['reassess']; else $status_desc=$arr_label['proceso']; echo "
   Verification of outcome ".$_POST['adm_coe_tec_name']." ".$status_desc." ".fecha_usr(substr($operador7['adm_con_dec2_dt'],0,10))." ".substr($operador7['adm_con_dec2_dt'],11,10)." "; echo "
"; if ($operador7['adm_con_dec3_st']=='3') $status_desc=$arr_label['dnapprove']; else if ($operador7['adm_con_dec3_st']=='7') $status_desc=$arr_label['reassess']; else $status_desc=$arr_label['proceso']; echo "
      Final decision ".$_POST['adm_coe_tec_name']." ".$status_desc." ".fecha_usr(substr($operador7['adm_con_dec3_dt'],0,10))." ".substr($operador7['adm_con_dec3_dt'],11,10)." "; echo "
"; break; } } echo "
"; } else { echo ""; echo "".$arr_label['no_data'].""; } ?> '7') { ?>
Document name
Execute($sql); if (!$result2->EOF) { $operador2 = $result2->fields; if ($operador2["adm_con_rf_status"] == '4') $_POST['res_final1'] = " checked "; if ($operador2["adm_con_rf_status"] == '3') $_POST['res_final2'] = " checked "; $_POST['obs_final'] = $operador2['adm_con_rf_obs']; $rd_dt = substr($operador2['adm_con_rf_dt'],0,10); $rd_usr = $operador2['adm_con_rf_usr']; $adm_con_cdv = $operador2['adm_con_cdv']; $cod_verif=$operador2['adm_con_cdv']; $adm_con_certxt1 = trim($operador2['adm_con_certxt1']); $adm_con_certxt2 = trim($operador2['adm_con_certxt2']); $adm_con_cerlins = $operador2['adm_con_cerlins']; $adm_con_nomprod = trim($operador2['adm_con_nomprod']); $adm_con_dacdate = $operador2['adm_con_dacdate']; $fec_aprob = date("d/m/Y",strtotime($operador2['adm_con_issdate'])); $adm_con_salescat = $operador2['adm_con_salescat']; $adm_con_inicon = $operador2['adm_con_inicon']; $adm_con_dci = $operador2['adm_con_dci']; $adm_con_rdv=$operador2["adm_con_rdv"]; $adm_con_calma=$operador2["adm_con_calma"]; $adm_con_sec=$operador2["adm_con_sec"]; $adm_con_perva =$operador2["adm_con_perval"]; $adm_con_preapro =$operador2["adm_con_preapro"]; /* $adm_con_dirname1 = $operador2['adm_con_dirname1']; $designation1 = $operador2['adm_con_dirdesi1']; $adm_con_dirname2 = $operador2['adm_con_dirname2']; $designation2 = $operador2['adm_con_dirdesi2']; */ } /* if (empty($adm_con_dirname)) $adm_con_dirname1=$adm_cnf_firma; if (empty($adm_con_dirname2)) $adm_con_dirname2=$adm_cnf_firma; if (empty($designation1)) $designation1=$adm_cnf_desig1; if (empty($designation2)) $designation2=$adm_cnf_desig2; */ $adm_con_dirname1=$adm_cnf_firma; $adm_con_dirname2=$adm_cnf_firma2; $designation1=$adm_cnf_desig1; $designation2=$adm_cnf_desig2; if (empty($rd_dt)) $rd_dt = date("d/m/Y"); if (empty($rd_usr)) $rd_usr = $_SESSION['ADMusuario_id']; $sql = "SELECT * FROM adm_usuarios WHERE adm_usr_ci = '$rd_usr'"; //echo $sql."
"; $result1=$connection->Execute($sql); if (!$result1->EOF) { $rd_usr = $result1->fields[6]; } ?> Execute ( $sql ); if (!$result->EOF) { if (intval($result->fields['adm_coe_status']) == 3 || intval($result->fields['adm_coe_status']) == 4) { if ($result->fields['adm_coe_status'] == 4) $_POST['res_final1'] = " checked "; if ($result->fields['adm_coe_status'] == 3) $_POST['res_final2'] = " checked "; } else { $_POST['obs_final'] = $result->fields['adm_coe_obs']; $rd_dt = $result->fields['adm_coe_dt']; $window = false; $class = "text-input"; $disabled = ""; ?>
fields[0]; $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']}'"; $result2=$connection->Execute($sql); $accion = intval($result2->fields[0]); ?> Execute($sql); //echo $sql; if (!$result_->EOF) { if ($result_->fields["vus_{$_POST['tipo']}_est_id"]=='9') $numreg = $result_->fields["vus_{$_POST['tipo']}_numreg"]; else $numreg = $result_->fields["vus_{$_POST['tipo']}_numsol"]; $formid = $result_->fields["vus_{$_POST['tipo']}_forma"]; $classid = $result_->fields["vus_{$_POST['tipo']}_gt_clas_id"]; } // echo $sql."
no reg ".$numreg; $sql="SELECT ctg_clp_desc FROM ctg_clasif_productos WHERE ctg_clp_id = '$classid'"; $result_f=$connection->Execute($sql); if (!$result_f->EOF) $clas_desc = $result_f->fields[0]; $row['064theracate'] = $clas_desc; $sql="SELECT * FROM ctg_productos_{$_POST['tipo']} WHERE adm_{$_POST['tipo']}_numreg = '$numreg' "; // echo $sql."
no reg ".$numreg; $result_=$connection->Execute($sql); if (!$result_->EOF) { $fecha = $result_->fields["adm_{$_POST['tipo']}_autori"]; //APPROVAL DATE $dispenid = $result_->fields["adm_{$_POST['tipo']}_dispen"]; //SALES CATEGORY $fec_aprob = substr($fecha,8,2)."-".substr($fecha,5,2)."-".substr($fecha,0,4); $pervalid=$result_->fields["adm_{$_POST['tipo']}_perval1"]; $condalmaid=$result_->fields["adm_{$_POST['tipo']}_condalma1"]; if ($cod_verif=="") $cod_verif = $result_->fields["adm_{$_POST['tipo']}_cdv"]; } if ( $adm_con_rdv == "") { $sql="SELECT ctg_mve_desc, ctg_mve_obs FROM ctg_mod_venta WHERE ctg_mve_id = '$dispenid'"; $result_f=$connection->Execute($sql); if (!$result_f->EOF) { $adm_con_rdv = $result_f->fields[0]; // $disp_obs = $result_f->fields[1]; } } if ( $adm_con_perval == "") { $sql="SELECT ctg_pva_desc FROM ctg_per_validez WHERE ctg_pva_id = '$pervalid'"; $result_f=$connection->Execute($sql); if (!$result_f->EOF) { $adm_con_perval = $result_f->fields[0]; // $disp_obs = $result_f->fields[1]; } } if ( $adm_con_calma == "") { $sql="SELECT ctg_cal_desc FROM ctg_cond_almacenamiento WHERE ctg_cal_id = '$condalmaid'"; $result_f=$connection->Execute($sql); if (!$result_f->EOF) { $adm_con_calma = $result_f->fields[0]; // $disp_obs = $result_f->fields[1]; } } // ACTUALIZO CAMPOS EN ADM_CONTROL $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET adm_con_dacdate = '".$adm_con_dacdate."', adm_con_issdate = '".$fec_aprob."', adm_con_dirname1 = '".$adm_cnf_firma."', adm_con_dirdesi1 = '".$designation1."', adm_con_dirname2 = '".$adm_cnf_firma2."', adm_con_dirdesi2 = '".$designation2."', adm_con_salescat = '".$adm_con_salescat."' 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(); //// BEGIN OF GENERATE FORMULA $sql="SELECT ctg_for_desc FROM ctg_formas WHERE ctg_for_id = '$formid'"; $result_f=$connection->Execute($sql); if (!$result_f->EOF) $form_desc .= $result_f->fields[0]; // if ($adm_con_certxt1==""){ // $formula = ""; // $formula1 = ""; // $formula2 = ""; // $numfor=0; // $numings=0; // $arr_for = array(); // $nomgenerico = "Each ".$form_desc." Contains"; // $sql = "SELECT COUNT(*) AS numing FROM ctg_productos_{$_POST['tipo']}_formula WHERE \"adm_{$_POST['tipo']}FOR_numreg\" = '{$numreg}' AND \"adm_{$_POST['tipo']}FOR_tipo\" = '1' "; // $result_=$connection->Execute($sql); // $numings=$result_->fields[0]; // $sql = "SELECT \"adm_{$_POST['tipo']}FOR_sus_nom\", \"adm_{$_POST['tipo']}FOR_unit_desc\", \"adm_{$_POST['tipo']}FOR_can\", \"adm_{$_POST['tipo']}FOR_cominfo\", \"adm_{$_POST['tipo']}FOR_ume_id\", \"adm_{$_POST['tipo']}FOR_ume_oth\", \"adm_{$_POST['tipo']}FOR_id\", \"adm_{$_POST['tipo']}FOR_atc_id\" FROM ctg_productos_{$_POST['tipo']}_formula WHERE \"adm_{$_POST['tipo']}FOR_numreg\" = '{$numreg}' AND (\"adm_{$_POST['tipo']}FOR_tipo\" = '1' OR \"adm_{$_POST['tipo']}FOR_sus_nom\" LIKE '%WATER FOR INJECTION%') ORDER BY \"adm_{$_POST['tipo']}FOR_id\", \"adm_{$_POST['tipo']}FOR_sus_nom\" "; // $result_=$connection->Execute($sql); // while ( !$result_->EOF ) { // if ($result_->fields[6] != $numfor) { // $numfor=$result_->fields[6]; // $atc_id=$result_->fields[7]; // if (empty($adm_con_dci)){ // $sql2 = "SELECT ctg_cla_desc FROM ctg_clasif_atc WHERE ctg_cla_id= '{$atc_id}'"; // echo $sql2; // die(); // $result_2=$connection->Execute($sql2); // if (!$result_2->EOF ){ // $adm_con_dci=$result_2->fields[0]; // } // } // $sql2 = "SELECT adm_{$_POST['tipo']}_refe{$result_->fields[6]} FROM ctg_productos_{$_POST['tipo']} WHERE adm_{$_POST['tipo']}_numreg = '{$numreg}'"; // $result_2=$connection->Execute($sql2); // $arr_for[] = "Cada " . (empty($result_2->fields[0]) ? $form_desc : $result_2->fields[0]) . " contains:"; // if ($numfor == 1){ // $formula1 .= "Cada " . (empty($result_2->fields[0]) ? $form_desc : $result_2->fields[0]) . " contains: "; // $formula2 = ""; // } else { // $formula1 .= $formula2."

"; // $formula1 .= "Cada " . (empty($result_2->fields[0]) ? $form_desc : $result_2->fields[0]) . " contains: "; // $formula2 = ""; // } // } // $txt = ''; // if (!empty($formula)) // $formula .= ", "; // $valor = $result_->fields[2]; // $valor = floatval($valor); // $txt .= $result_->fields[0]." ".$result_->fields[3]." ".$valor; // $unimed=$result_->fields[4]; // switch ($unimed) { // case '1': // $txt .= 'mg'; break; // case '2': // $txt .= 'mcg'; break; // case '3': // $txt .= 'IU'; break; // case '4': // $txt .= $result_->fields[5]; break; // } // $formula .= $txt; // if (!empty($formula2)) // $formula2 .= ", "; // $formula2 .= $txt; // $arr_for[] = "{$txt},"; // $result_->MoveNext (); // } // $formula1 .= $formula2; // $adm_con_certxt1="";//$formula1; // } if (empty($adm_con_dci)){ $sql = "SELECT \"adm_{$_POST['tipo']}FOR_atc_id\" FROM ctg_productos_{$_POST['tipo']}_formula WHERE \"adm_{$_POST['tipo']}FOR_numreg\" = '{$numreg}' AND \"adm_{$_POST['tipo']}FOR_tipo\" = '1' AND \"adm_{$_POST['tipo']}FOR_atc_id\"<>''"; $result_=$connection->Execute($sql); if ( !$result_->EOF ) { $atc_id=$result_->fields[0]; $sql2 = "SELECT ctg_cla_desc FROM ctg_clasif_atc WHERE ctg_cla_id= '{$atc_id}'"; $result_2=$connection->Execute($sql2); if (!$result_2->EOF ){ $adm_con_dci=$result_2->fields[0]; } } } if (substr($_POST['id'],0,6) == "03020902" || substr($_POST['id'],0,7) == "0302A0902" || substr($_POST['id'],0,7) == "0302B0902" ) { // 2015-07-23 $disabled = ""; $class = "text-input"; $window = ""; } ?> Execute($sql); //if (!$result2->EOF) { //echo "({$result2->fields[0]})"; //if ($result2->fields[0] == 1) { if ($accion == 1 && ($_POST['id'] == "030208" || $_POST['id'] == "0302A08" || $_POST['id'] == "0302B08") ) { //$sql = "SELECT ctg_tpr_sig1 ||,|| ctg_tpr_sig2 ||,|| ctg_tpr_sig3 ||,|| ctg_tpr_sig4 ||,|| ctg_tpr_sig5 FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; $sql = "SELECT ctg_tpr_sig1||','||ctg_tpr_sig2||','||ctg_tpr_sig3||','|| ctg_tpr_sig4||','||ctg_tpr_sig5 FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}'"; //echo $sql; $result2=$connection->Execute($sql); if (!$result2->EOF) { $siglas = $result2->fields[0]; $arr_sgl = explode(",",$siglas); echo ""; } } ?>
onclick="revisa_noconforme()"> >
" : "")?>
Codigo de verificación
Ficha tecnica
DCI
Regimen de venta
Condiciones de almacenamiento
Sistema envase cierre
Periodo de Validez
Iniciales controladas
Referencia Junta Revisora
Fecha de emision
Nombre de Presidente(a) del INHRR
Descripcion de Presidente(a) del INHRR
{$arr_label['siglas']}
checked> >
  • '.$arr_label['generar'].' Email
    • '; $no = ''; ?>
    Execute($sql); if (!$result1->EOF) { if ($result1->fields[0]=="4"){ $final_status=strtoupper($arr_label['finaldec']); $final_status .=" ".strtoupper($arr_label['approve']).""; } else { $final_status=strtoupper($arr_label['finaldec']); $final_status .=" ".strtoupper($arr_label['dnapprove']).""; } $_POST['cdv'] = substr($result1->fields[1],2,33); } ?>
    "; $result=$connection->Execute($sql); while ( !$result->EOF ) { $operador = $result->fields; if ($operador['ctg_fmt_cer'] == 1) { $ttc = "DR"; $ctg_tpt_id = "AO"; } else { $ttc = "LE"; $ctg_tpt_id = $_POST['ctg_tpt_id']; } $sql = "SELECT vus_{$_POST['tipo']}_numreg, vus_{$_POST['tipo']}_fec_cre, vus_{$_POST['tipo']}_est_id, vus_{$_POST['tipo']}_numsol 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"]) { if ($ret->fields["vus_{$_POST['tipo']}_est_id"]==9) $numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"]; else $numreg = $ret->fields["vus_{$_POST['tipo']}_numsol"]; } $sent_email_dt=""; $name = ""; $email = ""; $img = ""; $sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_docs WHERE ".($operador['ctg_fmt_cer'] == 1 ? "adm_cod_numreg = '$numreg'" : "adm_cod_numsol = '{$_POST['numsol']}'")." AND adm_cod_tpt_id = '$ctg_tpt_id' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '$ttc' AND adm_cod_tmf_id = '{$operador['ctg_fmt_id']}' LIMIT 1"; // echo $sql."
    "; $result1=$connection->Execute($sql); if (!$result1->EOF) { $name = $result1->fields["adm_cod_path"].$result1->fields["adm_cod_file"]; $send = $result1->fields["adm_cod_email"]; $sent_email_dt=fecha_usr($result1->fields["adm_cod_email_sent"]); if ($sent_email_dt=='--') $sent_email_dt=''; switch ($ip_int) { case '72.55.131.78': $filename="/var/www/html/siverc".$location_adm.$name; $name = str_replace("/html","",$name); break; default: $filename="/var/www/html/siverc/adm".$name; break; } // echo "
    file name(".$filename; if (file_exists($filename)) { $email = ""; if ($ip_ext==$ip_int){ $url = $ip_ext."/".$location_adm.$name; $onclick = " href='https://".$url."' target='_blank' "; } else { $url = $ip_ext.$location_adm.$name; $onclick = " href='https://".$url."' target='_blank' "; } $img = ""; } else { $name = "No file"; } } if (is_file("includes/plantillas_pdf/{$pais}_{$operador['ctg_fmt_nom']}")) { // $onclick = ""; } else { //$onclick = "{$pais}_{$operador['ctg_fmt_nom']}"; $onclick = "No hay Plantilla"; } // echo " // // // // // // // // "; // Generar echo ""; $result->MoveNext (); } ?>
    ID PDF Ver Enviar Fecha enviado
    {$operador['ctg_fmt_id']}{$operador['ctg_fmt_desc']}{$operador['ctg_fmt_sig']}{$operador['ctg_fmt_obs']}$onclick$name$email
    {$operador['ctg_fmt_id']} {$operador['ctg_fmt_desc']} $img $email $sent_email_dt
    "; $ret=$connectionVUS->Execute($sql); if ($ret->fields["vus_{$_POST['tipo']}_fec_cre"]) { $numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"]; } ?>
    Execute($sql); if (!$result1->EOF) { if ($result1->fields[0]=="4"){ $final_status=strtoupper($arr_label['finaldec']); $final_status .=" ".strtoupper($arr_label['approve']).""; } else { $final_status=strtoupper($arr_label['finaldec']); $final_status .=" ".strtoupper($arr_label['dnapprove']).""; } $_POST['cdv'] = substr($result1->fields[1],2,33); } ?>
    "; $result=$connection->Execute($sql); while ( !$result->EOF ) { $operador = $result->fields; if ($operador['ctg_fmt_cer'] == 1) { $ttc = "DR"; $ctg_tpt_id = "AO"; } else { $ttc = "LE"; $ctg_tpt_id = $_POST['ctg_tpt_id']; } $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"]) { if ($result_->fields["vus_{$_POST['tipo']}_est_id"]=='9') $numreg = $result_->fields["vus_{$_POST['tipo']}_numreg"]; else $numreg = $result_->fields["vus_{$_POST['tipo']}_numsol"]; } $name = ""; $email = ""; $img = ""; $sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_docs WHERE ".($operador['ctg_fmt_cer'] == 1 ? "adm_cod_numreg = '$numreg'" : "adm_cod_numsol = '{$_POST['numsol']}'")." AND adm_cod_tpt_id = '$ctg_tpt_id' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '$ttc' AND adm_cod_tmf_id = '{$operador['ctg_fmt_id']}' LIMIT 1"; //echo $sql."
    "; $result1=$connection->Execute($sql); if (!$result1->EOF) { $name = $result1->fields["adm_cod_path"].$result1->fields["adm_cod_file"]; $send = $result1->fields["adm_cod_email"]; switch ($ip_int) { case '72.55.131.78': $filename="/var/www/html/siverc".$location_adm.$name; $name = str_replace("/html","",$name); break; default: $filename="/var/www/html/siverc/adm/".$name; break; } // echo "
    file name(".$filename; if (file_exists($filename)) { if ($ip_ext==$ip_int){ $url = $ip_ext."/".$location_adm.$name; $onclick = " href='https://".$url."' target='_blank' "; } else { $url = $ip_ext.$location_adm.$name; $onclick = " href='https://".$url."' target='_blank' "; } $img = ""; } else { $name = "No file"; } } if (is_file("includes/plantillas_pdf/{$pais}_{$operador['ctg_fmt_nom']}")) { // $onclick = ""; } else { //$onclick = "{$pais}_{$operador['ctg_fmt_nom']}"; $onclick = "No hay Plantilla"; } // echo " // // // // // // // // "; // Generar echo ""; $result->MoveNext (); } ?>
    ID Ver
    {$operador['ctg_fmt_id']}{$operador['ctg_fmt_desc']}{$operador['ctg_fmt_sig']}{$operador['ctg_fmt_obs']}$onclick$name$email
    {$operador['ctg_fmt_id']} {$operador['ctg_fmt_desc']} $img
    "; $ret=$connectionVUS->Execute($sql); if ($ret->fields["vus_{$_POST['tipo']}_fec_cre"]) { $numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"]; } ?>
    > > >
    > > > >
    > >