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();
}
}
}
