21,887
社区成员
发帖
与我相关
我的任务
分享
if (isset($cur_yf) && $cur_yf!==""){
$cur_yf=iconv( "UTF-8", "gb2312//IGNORE" , $cur_yf) ;
$sele_yf_short=substr($cur_yf,0,4).substr($cur_yf,5);
$kqdataPatharr=array("kqdata","kqrt","kqxz");
$kqdataPath=$kqdataPatharr[$fenchang];
//$table_name="..".DIRECTORY_SEPARATOR.$kqdataPath.DIRECTORY_SEPARATOR."Kx".$sele_yf_short;
$table_file_name=vfp_db_root_str.DIRECTORY_SEPARATOR.$kqdataPath.DIRECTORY_SEPARATOR."kq".$sele_yf_short.".dbf";
if(!file_exists($table_file_name)){
$ret_arr['tablename']="gh";
$sql_str = 'SELECT gh,yg_name FROM '.$table_name.' where '.$sql_where.' order by gh ';
}else{
//echo $table_file_name;
//$table_name="./lisheng/gh";
$table_name=".".DIRECTORY_SEPARATOR.$kqdataPath.DIRECTORY_SEPARATOR."kx".$sele_yf_short;
if ($bm==""){
$sql_str = 'SELECT DISTINCT gh,yg_name FROM '.$table_name.' order by gh ';
}else{
$sql_str = 'SELECT DISTINCT gh,yg_name FROM '.$table_name.'where bm="'.$bm.'" order by gh ';
}
$ret_arr['tablename']="kx";
}
}else{
$sql_str = 'SELECT gh,yg_name FROM '.$table_name.' where '.$sql_where.' order by gh ';
$ret_arr['tablename']="noqq";
}
//echo $sql_str;