Execute ($sqlang);
if (! $resultang->EOF) {
while (!$resultang->EOF) {
list ( $msg_id, $msg_lab ) = $resultang->fields;
$label = $arr_label[$msg_id];
$arr_label[$label] = clean_string($msg_lab);
$resultang->MoveNext();
}
}
}
$sql = stripslashes($_POST['sql']);
if (strpos($sql,"WHERE"))
$sql .= " AND ";
else
$sql .= " WHERE ";
// $sql .= " ( upper(".$_POST['desc'].") LIKE '%".strtoupper($_POST['dato'])."%' ) ";
switch($_POST['quien']){
case "sus_id":
case "sue_id":
/*
$sql .= " (
lower(".$_POST['desc'].") LIKE '%".strtolower($_POST['dato'])."%' OR
upper(".$_POST['desc'].") LIKE '%".strtoupper($_POST['dato'])."%'
OR ".$_POST['codigo']." LIKE '%".$_POST['dato']."%' OR
lower(".$_POST['buscar2'].") LIKE '%".strtolower($_POST['dato'])."%' OR
upper(".$_POST['buscar2'].") LIKE '%".strtoupper($_POST['dato'])."%'
)";
*/
//$sql .= " ({$_POST['desc']} ILIKE '%{$_POST['dato']}%'
//OR {$_POST['codigo']} ILIKE '%{$_POST['dato']}'
//OR {$_POST['buscar2']} ILIKE '%{$_POST['dato']}%')";
$sql .= " {$_POST['desc']} ILIKE '%{$_POST['dato']}%' ";
break;
case "vus_usr_id":
case "numsol_ef":
$sql .= " ({$_POST['desc']} ILIKE '%{$_POST['dato']}%' ";
if (intval($_POST['dato']) > 0)
$sql .= " OR {$_POST['codigo']} = ".intval($_POST['dato'])." ";
$sql .= ")";
case "prod_id":
$sqluser="SELECT vus_usr_emp_rif FROM vus_usuarios WHERE vus_usr_id='".$_SESSION['usuario_id']."'";
$result = $connection->Execute($sqluser);
if (!$result->EOF){
$operadot = $result->fields;
$codemp=$operadot[0];
}
$sql =" SELECT adm_ef_numreg, adm_ef_nomprod, adm_ef_presenta FROM ctg_productos_{$_POST['idpro']} INNER JOIN \"ctg_productos_ef_EMPRESAS\" ON adm_ef_numreg = \"adm_efEMP_numreg\" WHERE adm_ef_tpr_id = '02' AND \"adm_efEMP_rif\" = '".$codemp."' AND adm_ef_id_est = '01' ";
$sql .= " AND (adm_ef_nomprod ILIKE '%{$_POST['dato']}%' ";
if (intval($_POST['dato']) > 0)
$sql .= " OR adm_ef_numreg = ".intval($_POST['dato'])." ";
$sql .= ")";
break;
default:
/*
$sql .= " (
lower(".$_POST['desc'].") LIKE '%".strtolower($_POST['dato'])."%' OR
upper(".$_POST['desc'].") LIKE '%".strtoupper($_POST['dato'])."%' OR
".$_POST['codigo']." LIKE '%".$_POST['dato']."%'
) ";
*/
$sql .= " ({$_POST['desc']} ILIKE '%{$_POST['dato']}%'
OR {$_POST['codigo']} ILIKE '%{$_POST['dato']}%') ";
break;
}
if (!empty($_POST['orden']))
$sql .= " ORDER BY ".$_POST['orden'];
else
$sql .= " ORDER BY ".$_POST['codigo'];
// echo $sql." ";
// echo "(quien=".$_POST['quien'].")";
// echo "(id=".$_POST['id'].")";
// echo "(".$_POST['siguiente'].")";
// echo "(".$_POST['dato'].")";
// echo "(".$_POST['idpro'].")";
$i = 0;
switch($_POST['quien']){
case "cate_id":
case "ctg_geo_dep_id":
case "ctg_geo_mun_id":
case "ctg_geo_id":
case "ctg_geo_id1":
case "ctg_geo_id2":
case "ctg_geo_id3":
case "geo_id":
case "ctg_geo_id_ext":
case "farm_id":
case "ctg_env_id":
case "gt_env_id":
case "gt_clas_id":
case "numreg": //2013-07-20 donde lo llama para adm, para que catalogo, hoy 2013-09-21 se descomenta para uso en vus
case "prod_id": //2013-07-20 donde lo llama para adm, para que catalogo, hoy 2013-09-21 se descomenta para uso en vus
case "rif":
case "clp_id_ven":
case "clp_id_cma":
case "clp_id_clase":
case "clp_id_subclase":
case "forma":
case "via":
case "nomgen_id":
case "perval":
case "perval_id":
case "clp_id":
case "ban_id":
case "ci":
// case "clp_id_variedad":
case "ume_id":
case "ume_ids":
case "sus_id":
case "sue_id":
case "tipvac_id":
case "mea_id":
case "mea_id0":
case "mea_id1":
case "mea_id2":
case "mea_id3":
case "mea_id4":
case "mea_ume_id":
case "sue_ume_id":
case "dispen":
case "atc_id":
case "este":
case "rango":
case "condalma":
case "condalm":
case "condalma1":
case "condalma2a":
case "condalma2b":
case "condalma3a":
case "condalma3b":
case "condalma4a":
case "condalma4b":
case "farm_elab_id":
case "color_id":
case "eta_geo_id":
case "numreg[0]":
case "numreg[1]":
case "numreg[2]":
case "numreg[3]":
case "numreg[4]":
case "numreg[5]":
case "numreg[6]":
case "numreg[7]":
case "numreg[8]":
case "numreg[9]":
case "rif[0]":
case "rif[1]":
case "rif[2]":
case "rif[3]":
case "rif[4]":
case "rif[5]":
case "rif[6]":
case "rif[7]":
case "rif[8]":
case "rif[9]":
case "numadmi":
case "farm_geo_id":
case "ide":
case "env_pri":
case "env_sec":
case "aspe":
case "fun"://2012-10-26
case "mod_venta"://2013-02-21
case "tip_autor"://2013-02-21
case "tpc_id"://2013-02-25
case "ctg_eml_numlic":
case "gt_rm_paifabr":
case "gt_rm_paiori":
case "env1_id_0":
case "env1_id_1":
case "env1_id_2":
case "env1_id_3":
case "env1_id_4":
case "env1_id_5":
case "env1_id_6":
case "env1_id_7":
case "env1_id_8":
case "env1_id_9":
case "env2_id_0":
case "env2_id_1":
case "env2_id_2":
case "env2_id_3":
case "env2_id_4":
case "env2_id_5":
case "env2_id_6":
case "env2_id_7":
case "env2_id_8":
case "env2_id_9":
case "uni_id_0":
case "uni_id_1":
case "uni_id_2":
case "uni_id_3":
case "uni_id_4":
case "uni_id_5":
case "uni_id_6":
case "uni_id_7":
case "uni_id_8":
case "uni_id_9":
case "env1_id_0_0":
case "env1_id_0_1":
case "env1_id_0_2":
case "env1_id_0_3":
case "env1_id_1_0":
case "env1_id_1_1":
case "env1_id_1_2":
case "env1_id_1_3":
case "env1_id_2_0":
case "env1_id_2_1":
case "env1_id_2_2":
case "env1_id_2_3":
case "env1_id_3_0":
case "env1_id_3_1":
case "env1_id_3_2":
case "env1_id_3_3":
case "env1_id_4_0":
case "env1_id_4_1":
case "env1_id_4_2":
case "env1_id_4_3":
case "env2_id_0_0":
case "env2_id_0_1":
case "env2_id_0_2":
case "env2_id_0_3":
case "env2_id_1_0":
case "env2_id_1_1":
case "env2_id_1_2":
case "env2_id_1_3":
case "env2_id_2_0":
case "env2_id_2_1":
case "env2_id_2_2":
case "env2_id_2_3":
case "env2_id_3_0":
case "env2_id_3_1":
case "env2_id_3_2":
case "env2_id_3_3":
case "env2_id_4_0":
case "env2_id_4_1":
case "env2_id_4_2":
case "env2_id_4_3":
case "mat_id_0_0":
case "mat_id_0_1":
case "mat_id_0_2":
case "mat_id_0_3":
case "mat_id_1_0":
case "mat_id_1_1":
case "mat_id_1_2":
case "mat_id_1_3":
case "mat_id_2_0":
case "mat_id_2_1":
case "mat_id_2_2":
case "mat_id_2_3":
case "mat_id_3_0":
case "mat_id_3_1":
case "mat_id_3_2":
case "mat_id_3_3":
case "mat_id_4_0":
case "mat_id_4_1":
case "mat_id_4_2":
case "mat_id_4_3":
case "lc_prof_id":
case "numlic7":
case "numlic9":
case "category":
case "farm_ci":
iniciarConexionADM();
$result=$connectionADM->Execute($sql);
break;
default:
$result=$connection->Execute($sql);
break;
}
if ($result->_numOfRows > 150) {
if (strlen($_POST['dato']) < 3)
$result->EOF = true;
}
if (!$result->EOF) {
if($_POST['quien'] == "sus_id" || $_POST['quien'] == "sue_id") {
echo "