function newai_search($fields) { global $common_html, $html_etc; global $return_sql_line, $db; global $action_add, $action_model; global $_POST, $_GET, $ROWS_PAGE; global $file_ini, $columns; global $SYSTEM_ADD_SQL; global $SYSTEM_ADVANCE_SEARCH_TO_DEFINE; //$SYSTEM_ADD_SQL = "and 星期='2'"; $tablename = $fields['table']['name']; //得到高级搜索相关配置文件信息 $EXPORT_ADV = $file_ini['exportadv_default']; //print_R($EXPORT_ADV); $showlistfieldlist = $EXPORT_ADV['showlistfieldlist']; $showlistfieldfilter = $EXPORT_ADV['showlistfieldfilter']; $showlistfieldlistArray = explode(",", $showlistfieldlist); $showlistfieldfilterArray = explode(",", $showlistfieldfilter); print "\n\t\t<fieldset style=\"width:100%;\n\t\tpadding-left:5px;\n\t\tpadding-right:5px;\n\t\tpadding-top:5px;\n\t\tpadding-bottom:5px;\">\n\t\t\t <legend class=\"small\" align=left>\n\t\t\t <b>高级查询</b>\n\t\t </legend>\n"; print "\n\t\t<table class=\"TableList\" align=\"left\" width=\"100%\">\n\t\t <form action=\"?\" method=\"get\" name=\"form1\">\n"; //print_R($columns); for ($i = 0; $i < sizeof($showlistfieldlistArray); $i++) { $listIndex = $showlistfieldlistArray[$i]; $listIndexName = $columns[$listIndex]; $fieldfilter = $showlistfieldfilterArray[$i]; $listLangName = $html_etc[$tablename][$listIndexName]; $fieldfilter_array = explode(':', $fieldfilter); $fieldfilter = trim($fieldfilter_array[0]); if ($i % 4 == 0) { print "<TR>"; } if ($fieldfilter != "notshow") { print "<td nowrap class=\"TableData\"> " . $listLangName . $listFilter . ": </td><td nowrap class=\"TableData\">\n"; } else { print "<td nowrap class=\"TableData\"> </td><td nowrap class=\"TableData\">\n"; } switch ($fieldfilter) { case 'datetime': print "<SCRIPT src=\"../../Enginee/WdatePicker/WdatePicker.js\"></SCRIPT>\n"; print "<SCRIPT>\n\t\t\t\t\t\tfunction td_calendar(fieldname) {\n\t\t\t\t\t\tmyleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\n\t\t\t\t\t\tmytop=document.body.scrollTop+event.clientY-event.offsetY+140;\n\t\t\t\t\t\twindow.showModalDialog(fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:200px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\n\t\t\t\t\t\t}\n\t\t\t\t\t\t</SCRIPT>\n"; $sql = "select max(" . $listIndexName . ") AS 最大值,min(" . $listIndexName . ") AS 最小值 from {$tablename}"; $rsX = $db->Execute($sql); $rsX_a = $rsX->GetArray(); $最大值 = $rsX_a[0]['最大值']; $最小值 = $rsX_a[0]['最小值']; $BEGIN_DATE = $最小值; $END_DATE = $最大值; $GetValue开始时间 = $_GET[$listIndexName . "_开始时间"]; $GetValue结束时间 = $_GET[$listIndexName . "_结束时间"]; if ($GetValue开始时间 != "") { $BEGIN_DATE = $GetValue开始时间; } if ($GetValue结束时间 != "") { $END_DATE = $GetValue结束时间; } print "<INPUT class=SmallInput size=19 name=\"" . $listIndexName . "_开始时间\" value=\"{$BEGIN_DATE}\" onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})\" readonly> -\n\t\t\t\t\n"; print "<INPUT class=SmallInput size=19 name=\"" . $listIndexName . "_结束时间\" value=\"{$END_DATE}\" onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})\" readonly>\n\t\t\t\t\n"; break; case 'date': print "<SCRIPT src=\"../../Enginee/WdatePicker/WdatePicker.js\"></SCRIPT>\n"; print "<SCRIPT>\n\t\t\t\t\t\tfunction td_calendar(fieldname) {\n\t\t\t\t\t\tmyleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\n\t\t\t\t\t\tmytop=document.body.scrollTop+event.clientY-event.offsetY+140;\n\t\t\t\t\t\twindow.showModalDialog(fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:200px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\n\t\t\t\t\t\t}\n\t\t\t\t\t\t</SCRIPT>"; $sql = "select max(" . $listIndexName . ") AS 最大值,min(" . $listIndexName . ") AS 最小值 from {$tablename}"; $rsX = $db->Execute($sql); $rsX_a = $rsX->GetArray(); $最大值 = $rsX_a[0]['最大值']; $最小值 = $rsX_a[0]['最小值']; $BEGIN_DATE = $最小值; $END_DATE = $最大值; $GetValue开始时间 = $_GET[$listIndexName . "_开始时间"]; $GetValue结束时间 = $_GET[$listIndexName . "_结束时间"]; if ($GetValue开始时间 != "") { $BEGIN_DATE = $GetValue开始时间; } if ($GetValue结束时间 != "") { $END_DATE = $GetValue结束时间; } print "<INPUT class=SmallInput size=19 name=\"" . $listIndexName . "_开始时间\" value=\"{$BEGIN_DATE}\" onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd'})\" readonly> -\n\t\t\t\t\n"; print "<INPUT class=SmallInput size=19 name=\"" . $listIndexName . "_结束时间\" value=\"{$END_DATE}\" onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd'})\" readonly>\n\t\t\t\t\n"; break; case 'number': case 'money': $sql = "select max(" . $listIndexName . ") AS 最大值,min(" . $listIndexName . ") AS 最小值 from {$tablename}"; $rsX = $db->Execute($sql); $rsX_a = $rsX->GetArray(); $最大值 = round($rsX_a[0]['最大值'], 2); $最小值 = round($rsX_a[0]['最小值'], 2); $GetValue最小值 = $_GET[$listIndexName . "_最小值"]; $GetValue最大值 = $_GET[$listIndexName . "_最大值"]; if ($GetValue最小值 != "") { $最小值 = $GetValue最小值; } if ($GetValue最大值 != "") { $最大值 = $GetValue最大值; } print "<INPUT class=SmallInput size=6 name=\"" . $listIndexName . "_最小值\" value=\"{$最小值}\">(最小)\n\t\t\t\t"; print "<INPUT class=SmallInput size=6 name=\"" . $listIndexName . "_最大值\" value=\"{$最大值}\">(最大)\n\t\t\t\t"; break; case 'tablefilter': case 'tablefiltercolor': case 'radiofilter': case 'radiofiltercolor': $ChildTablename = $fieldfilter_array[1]; $ChildColumns = returntablecolumn($ChildTablename); $ChildFieldValueIndex = $fieldfilter_array[2]; $ChildFieldNameIndex = $fieldfilter_array[3]; $ChildFieldValue = $ChildColumns[$ChildFieldValueIndex]; $ChildFieldName = $ChildColumns[$ChildFieldNameIndex]; //print_R($columns); //当两个值相同时,只进行一条SQL判断 if ($ChildFieldValue == $ChildFieldName) { $sql = "select distinct {$listIndexName} AS {$ChildFieldName} from {$tablename} where {$listIndexName}!='' order by {$ChildFieldName}"; } else { $sql = "select distinct {$listIndexName} from {$tablename} where {$listIndexName}!='' order by {$listIndexName}"; $rsX = $db->CacheExecute(150, $sql); $rsX_a = $rsX->GetArray(); $中间过滤数组 = array(); for ($X = 0; $X < sizeof($rsX_a); $X++) { $中间过滤数组[] = $rsX_a[$X][$listIndexName]; } $中间过滤数组TEXT = "'" . join("','", $中间过滤数组) . "'"; $sql = "select {$ChildFieldValue},{$ChildFieldName} from {$ChildTablename} where {$ChildFieldValue} in ({$中间过滤数组TEXT})"; } //print $sql; $rsX = $db->CacheExecute(150, $sql); $rsX_a = $rsX->GetArray(); print "<select class=\"SmallSelect\" name=\"" . $listIndexName . "\">"; print "<option value=''>所有" . $listLangName . "</option>\n"; for ($X = 0; $X < sizeof($rsX_a); $X++) { if ($_GET[$listIndexName] == $rsX_a[$X][$ChildFieldValue]) { $temp = 'selected'; } else { $temp = ''; } print "<option value=\"" . $rsX_a[$X][$ChildFieldValue] . "\" {$temp}>" . $rsX_a[$X][$ChildFieldName] . "</option>\n"; } print "</select>\n"; break; case '': case 'input': default: print "<input type=\"text\" title='模糊查询' name=\"" . $listIndexName . "\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"" . $_GET[$listIndexName] . "\">"; break; } print "</td>"; } //http://localhost/general/EDU/Interface/EDU/dorm_liusu_huijia_shengguan_newai.php?action=export_default_data&exportfield=0,1,2,3,4,5,6,7,8,9,10,11,12&tablename=dorm_liusu&searchfield=&searchvalue=&说明= //得到初始经状态下面的所有字段的列表 $showlistfieldlist_init = $file_ini['export_default']['showlistfieldlist']; // if ($SYSTEM_ADVANCE_SEARCH_TO_DEFINE == "1") { $return = FormPageAction2("action", "export_default", "actionadv", "exportadv_default", "{$delete}", "exportfield", $showlistfieldlist_init, "tablename", $tablename); } else { $return = FormPageAction2("action", "export_default_data", "actionadv", "exportadv_default", "{$delete}", "exportfield", $showlistfieldlist_init, "tablename", $tablename); } //print $return; //edu_renshi_newai.php?action=export_default_data&actionadv=exportadv_default&exportfield=0,1,29,2,3,4,7,22,5,9,10,8,11,12,13,14,15,24,17,16,19,26,27,25,18,20,23,6&tablename=edu_renshi&searchfield=&searchvalue=&单位=郑东新区信息中心&出生年月_最小值=1951.09&出生年月_最大值=1985.12&任同职级时间_最小值=0.00&任同职级时间_最大值=0.00 print "<script>function ResultExportXLS(LOCALURL)\t{\n\t\t\t\t\turl=\"?XX=XX&\"+LOCALURL;\n\t\t\t\t\t//alert(url);\n\t\t\t\t\tlocation=url;\n\t\t\t\t\t}\n\t\t\t</script>\n\t\t <tr>\n\t\t\t<td nowrap class=\"TableData\" colspan=\"8\" >\n\t\t\t \n\t\t\t<input class=\"SmallButton\" value=\"查询\" type=\"submit\" title=\"查询\" name=\"快速查询\"> \n\t\t\t<input class=\"SmallButton\" value=\"返回\" type=\"button\" title=\"返回\" name=\"快速返回\" onClick=\"location='?'\"> \n\t\t\t<input class=\"SmallButton\" value=\"导出\" type=\"button\" title=\"导出\" name=\"结果导出\" onClick=\"ResultExportXLS('{$return}')\"> \n\n\t\t\t<input value=\"exportadv_default\" type=\"hidden\" name=\"actionadv\">\n\t\t </td>\n\t\t </tr>\n\t\t</form>\n\t\t</table>\n\t\t</fieldset>\n\t\t<BR>\n\t\t"; }
function print_search_element_array($name, $value, $mark = 'default', $affixation = array(), $affixation_index) { global $common_html, $db, $action_model, $action_search, $location_title; global $read_type, $email_filter, $sms_filter, $_GET, $html_etc, $tablename; global $primarykey_index; global $fields; echo $action = "init_" . $mark . "_search"; if (isset($action_search)) { form_begin('Form2', "{$action}", 'get'); print "<THEAD >\n"; print "<TR>"; print "<TD noWrap colspan=" . $fields['table']['colspan'] . ">\n"; print "<table width=100% class=Small border=0><THEAD ><tr ><td noWrap>"; if (isset($action_model)) { show_new_element($action_model, $location_title); } //此函数在本文件中定义,第一个参数来源于xx_newai.ini配置文件,用来控制按钮的类型,第二个参数在newai_control.php中定义为'sunshine_inside' //print $common_html['common_html']['search'].":\n"; $addtext = $affixation[0]['index_name']; //print_R($affixation);&&$_GET['actionadv']=='' //当高级搜索打开时,此部分不进行显示,高级搜索关闭时,此部分显示 if ($_GET['actionadv'] == '') { print "<input type=hidden name=action value={$action}>"; // print "<input type=hidden name='".$addtext."' value='".$_GET[$addtext]."'>"; print "<select class=\"SmallSelect\" name=\"searchfield\" onkeydown=\"if(event.keyCode==13)event.keyCode=9\" >\n"; //当GETSEARCHFIELD不为空时,进行SESSION注册操作 if ($_GET['searchfield'] != "") { //session_register("SYSTEM_INITVIEW_SEARCH_LIST_DEFAULT"); $_SESSION['SYSTEM_INITVIEW_SEARCH_LIST_DEFAULT'] = $_GET['searchfield']; //session_register("SYSTEM_INITVIEW_SEARCH_VALUE_DEFAULT"); $_SESSION['SYSTEM_INITVIEW_SEARCH_VALUE_DEFAULT'] = $_GET['searchvalue']; } for ($i = 0; $i < sizeof($name); $i++) { if ($_SESSION['SYSTEM_INITVIEW_SEARCH_LIST_DEFAULT'] == $value[$i]) { $temp = "selected"; } else { $temp = ""; } print "<option value=\"" . $value[$i] . "\" {$temp}>" . $name[$i] . "</option>\n"; } print "</select>\n"; print "<INPUT type=\"text\" class=\"SmallInput\" maxLength=200 size=\"12\" name=\"searchvalue\" value=\"" . $_SESSION['SYSTEM_INITVIEW_SEARCH_VALUE_DEFAULT'] . "\">\n"; print "<INPUT class=SmallButton title=\"" . $common_html['common_html']['accesskey'] . ":ALT+F\"\" type=submit accesskey=\"f\" value=\"" . $common_html['common_html']['search'] . "\" name=button>\n"; } //高级搜索部分判断结束 //print_R($affixation); global $SYTEM_CONFIG_TABLE; $SYTEM_CONFIG_TABLE != "" ? $tablename = $SYTEM_CONFIG_TABLE : ''; if (is_array($affixation) && sizeof($affixation) > 0) { foreach ($affixation as $list) { switch ($list['attribute']) { case 'text': print "<select class=\"SmallSelect\" >\n"; print "<option value=\"\" >" . $affixation_index . "</option>\n"; print "</select>\n"; break; case 'hidden': break; case 'fixed': break; default: //$return=returnpageaction($mode='group_filter',array('index_name'=>$list['index_name'],'index_id'=>'')); //print $_GET['DEPT_ID_NAME'];; $FormPageAction = FormPageAction2("action", $_GET[action], '', '', $list['index_name']); //print "<font color=black>".$html_etc[$tablename][$list['index_name']].":</font> "; print "<select class=\"SmallSelect\" onChange=\"var jmpURL='?" . $FormPageAction . "&" . $list['index_name'] . "=' + this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}\" name=\"" . $list['index_name'] . "\" >\n"; //print "<option value=\"\" >".$common_html['common_html']['allrecords']."</option>\n"; print "<option value=\"\" >" . $html_etc[$tablename][$list['index_name']] . "[" . $common_html['common_html']['allrecords'] . "]</option>\n"; for ($i = 0; $i < sizeof($list['fieldid']); $i++) { print "<option value=\"" . $list['fieldid'][$i] . "\" " . $list['selected'][$i] . ">" . $list['fieldname'][$i] . "</option>\n"; } print "</select>\n"; } //end switch } //end foreach } //end if if ($email_filter != "") { $temp = $email_filter; } else { if ($sms_filter != '') { $temp = $sms_filter; } else { $temp = ''; } } if ($temp) { $array_filter = explode(',', $temp); if ($_GET['action'] == 'init_default') { $_GET['action'] == 'init_inbox'; } print "<select class=\"SmallSelect\" onChange=\"var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}\" name=\"" . $list['index_name'] . "_NAME\" >\n"; for ($i = 0; $i < sizeof($array_filter); $i++) { if ("init_" . $array_filter[$i] == $_GET['action']) { $selected = 'selected'; } else { $selected = ''; } print "<option value=\"?action=init_" . $array_filter[$i] . "\" {$selected}>" . $common_html['common_html'][(string) $array_filter[$i]] . "</option>\n"; } print "</select>\n"; } global $增加对查询日期快捷方式的支持_是否启用; if ($增加对查询日期快捷方式的支持_是否启用 == 1 && $_SESSION['增加对查询日期快捷方式的支持'] == '设置为0') { print " <a href='?" . FormPageAction("增加对查询日期快捷方式的支持GET", "设置为1") . "'><font color=gray title=\"启用'增加对查询日期快捷方式的支持'功能\">打开查询日期显示</font></a>"; } //提示信息显示 print "</td>\n"; print "<td nowrap width=60%><DIV class=InputError id=Searchvalue_CSS></DIV></td>\n"; print "</tr></THEAD></table>"; print "</TD></TR>\n"; print "</THEAD>\n"; form_end(); //############################################################################### //############################################################################### //############################################################################### global $USER_DEFINE_FUNCTION_PAGE_NAME; if ($USER_DEFINE_FUNCTION_PAGE_NAME != "") { $USER_DEFINE_FUNCTION_PAGE_NAME(); } } }