function delete_array_newai($element, $fields) { global $right_etc, $html_etc, $common_html; global $_POST, $_GET, $db; global $primarykey_index; global $delete_attribute, $delete_attribute; global $columns, $tablename; DoReferer(); $_GET[$primarykey_index] = $element; $return_sql_line = return_sql_line($fields); if (isset($delete_attribute) && $delete_attribute != '') { //$delete_attribute_array=explode(':',$delete_attribute); //$index_temp=$delete_attribute_array[0];print $index_temp; //$fieldvalue=gettablefield($tablename,$primarykey_index,$columns[$index_temp],$element);print $fieldvalue; //if($fieldvalue) // $SQL=$return_sql_line['delete_sql']; //else $SQL = $return_sql_line['update_fixed_field_sql']; } else { $SQL = $return_sql_line['delete_sql']; } //print $SQL;exit; //如果有附件,删除附件 for ($i = 0; $i < sizeof($fields['null']); $i++) { if ($fields['null'][$i]['inputfilter'] == 'tdoafile') { $fujianValue = returntablefield($tablename, $primarykey_index, $element, $fields['name'][$i]); $fujianValueArray = explode('||', $fujianValue); require_once 'lib/utility_file.php'; delete_attach($fujianValueArray[1], $fujianValueArray[0]); } if ($fields['null'][$i]['inputfilter'] == 'picturefile') { $fujianValue = returntablefield($tablename, $primarykey_index, $element, $fields['name'][$i]); require_once 'lib/utility_file.php'; delete_single_attach($fujianValue); } } //得到要删除的表的记录的值; $sql = "select * from {$tablename} where {$primarykey_index}='{$element}'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); $KEYS = @array_keys($rs_a[0]); $SQLTEXT = ''; for ($i = 0; $i < sizeof($KEYS); $i++) { $KEY = $KEYS[$i]; $SQLTEXT .= "{$KEY}:" . $rs_a[0][$KEY] . " "; } //print_R(); global $db, $html_etc, $tablename; $排除记录日志的页面 = array("/general/EDU/Interface/EDU/system_log_newai.php", "/general/EDU/Interface/CRM/system_log_newai.php", "/general/EDU/Interface/JIAOYUJU/system_log_newai.php"); if (!in_array($_SERVER['SCRIPT_NAME'], $排除记录日志的页面)) { system_log_input("删除" . $html_etc[$tablename][$tablename], $SQLTEXT . " <BR>" . $SQL); } $result = $db->Execute($SQL); if ($result->EOF) { return false; } else { return true; } }
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <?php require_once 'newai.lib.inc.php'; //生成全局变量 $fields = returnfields($tablename, $showlistfieldlist, $showlistfieldfilter, $showlistnull, $showlistfieldprivate); //echo '$friends'.'<br>';//by cwf //var_dump($fields);//by cwf //处理对SYSTEM_ADD_SQL的支持,用于高级搜索部分支持 newai_search_sql($fields); //生成所有SQL信息 $return_sql_line = return_sql_line($fields); //此函数在newai_license.php定义 //var_dump($return_sql_line); //logbegin('systemLogin'); //print_r($return_sql_line);exit; global $pagenums_model; global $FORM_SELECT_DISABLED; global $COLSPAN_SYSTEM; //过滤在SEARCH时有数据量可以显示。 $ActionArray = explode('_', $_GET['action']); if ($ActionArray[0] == "init" && $ActionArray[2] == "search") { if ($pagenums_model == 0) { $pagenums_model = 25; } } //一般情况下对每页显示数量设置 $ROWS_PAGE = isset($pagenums_model) ? $pagenums_model : 25; function returnfields($tablename, $showlistfieldlist, $showlistfieldfilter, $showlistnull, $showlistfieldprivate) { global $columns, $html_etc, $common_html; global $primarykey, $uniquekey, $tablename, $realtablename;
function newaiReport($fields, $list, $mode) { global $html_etc, $tablename, $common_html, $custom_type; global $db, $return_sql_line, $columns; global $_POST, $_GET, $returnmodel, $primarykey_index; global $action_submit, $merge, $form_attribute; //列表及数组转化区 global $showlistfieldlist, $showlistfieldfilter; $showlistfieldlistArray = explode(',', $showlistfieldlist); $showlistfieldfilterArray = explode(',', $showlistfieldfilter); //SQL语句初始化区 $fields['other']['title'] = $common_html['common_html'][$mode]; $_GET[$primarykey_index] = $list; $return_sql_line = return_sql_line($fields); $SQL = $return_sql_line['select_sql']; //print $SQL; //多项数据搜索部分 如果定义了外部SQL语句,即结果集为多数据时采用外部SQL语句 global $NEWAI_REPORT_SEARCH_SYSTEM; if (strlen($NEWAI_REPORT_SEARCH_SYSTEM) > 10 && $mode == "Multiple") { $SQL = $NEWAI_REPORT_SEARCH_SYSTEM; } //定义要显示的结果集,默认为30个结果集 global $totalnumber; $totalnumber == "" ? $totalnumber = 30 : ''; //执行SQL语言部分 $result = $db->CacheSelectLimit(15, $SQL, $totalnumber, 0); $rs_array = $result->GetArray(); //数据显示区,其含数据过滤部分 for ($h = 0; $h < sizeof($rs_array); $h++) { $ReportData = $rs_array[$h]; //数据过滤区 - Begin ################################################# for ($f = 0; $f < sizeof($showlistfieldlistArray); $f++) { $filterIndex = $showlistfieldlistArray[$f]; //索引列表值 $filterType = $showlistfieldfilterArray[$f]; //过滤列表值 $filterName = $columns[$filterIndex]; //列表名称 $TypeNameFilterArray = explode(':', $filterType); //对应的过滤数组 switch ($TypeNameFilterArray[0]) { case 'input': break; case 'boolean': $ReportData[$filterName] = returnboolean($ReportData[$filterName]); break; case 'tablefilter': $filterTableName = $TypeNameFilterArray[1]; $filterTableColumns = returntablecolumn($filterTableName); $filterTableFieldID = $filterTableColumns[(string) $TypeNameFilterArray[2]]; $filterTableFieldName = $filterTableColumns[(string) $TypeNameFilterArray[3]]; $filterResultText = returntablefield($filterTableName, $filterTableFieldID, $ReportData[$filterName], $filterTableFieldName); $ReportData[$filterName] = $filterResultText; break; case 'userdefine': $filtervalue = $fields['value'][$counter][$list_index]; $functionName = $TypeNameFilterArray[1]; $fileName = $functionName . ".php"; $fileName0 = "userdefine/{$fileName}"; $fileName = "../../Enginee/userdefine/{$fileName}"; if (file_exists($fileName0)) { require_once $fileName0; $functionName = $functionName . "_Value"; if (function_exists($functionName)) { $ReportData[$filterName] = $functionName($fields['value'][$counter][$list_index], $fields, $counter); } } else { if (file_exists($fileName)) { require_once $fileName; $functionName = $functionName . "_Value"; if (function_exists($functionName)) { $ReportData[$filterName] = $functionName($fields['value'][$counter][$list_index], $fields, $counter); } else { print "函数名称[{$functionName}]不存在!"; } } else { print "没有相应文件,文件名:{$fileName}"; } } break; } } //数据过滤区 - End ################################################## print "<BR>"; table_begin("80%"); print "<TR class=TableHeader>"; print "<TD noWrap colspan=4>" . $html_etc[$tablename][$tablename] . $common_html['common_html']['report'] . " </TD>"; print "</TR>"; $Counter = 0; for ($i = 0; $i < sizeof($showlistfieldlistArray); $i += 2) { $fieldName1 = (string) $columns[(string) $showlistfieldlistArray[$i]]; $k = $i + 1; $fieldName2 = (string) $columns[(string) $showlistfieldlistArray[$k]]; print "<TR class=TableData>"; print "<TD noWrap width=15%>" . $html_etc[$tablename][$fieldName1] . " </TD>"; print "<TD width=35%>" . $ReportData[$fieldName1] . " </TD>"; print "<TD noWrap width=15%>" . $html_etc[$tablename][$fieldName2] . " </TD>"; print "<TD width=35%>" . $ReportData[$fieldName2] . " </TD>"; print "</TR>"; } table_end(); } //end of rs_array //############################################################################## //实现子目录列表 global $child_tablename, $child_showlistfieldlist; global $child_partent, $child_showlistfieldfilter; //子目录列表开始 if ($child_tablename != "" && $child_showlistfieldlist != "") { $child_columns = returntablecolumn($child_tablename); $child_html_etc = returnsystemlang($child_tablename); table_begin("80%"); print "<TR class=TableHeader>"; print "<TD noWrap width=100% colspan=32>" . $child_html_etc[$child_tablename]["list" . $child_tablename] . " </td>"; print "</TR>"; print "<TR class=TableHeader>"; $child_showlistfieldlist_Array = explode(",", $child_showlistfieldlist); $child_showlistfieldfilter_Array = explode(",", $child_showlistfieldfilter); for ($i = 0; $i < sizeof($child_showlistfieldlist_Array); $i++) { $child_index = $child_showlistfieldlist_Array[$i]; $indexName = $child_columns[$child_index]; print "<TD noWrap>" . $child_html_etc[$child_tablename][$indexName] . " </td>"; } print "</TR>"; //子表与父表关联部分 $child_partent_Array = explode(":", $child_partent); $sql = "select * from {$child_tablename} where " . $child_columns[(string) $child_partent_Array[0]] . "='" . $list . "'"; $rs = $db->CacheExecute(150, $sql); $rs_a = $rs->GetArray(); for ($i = 0; $i < sizeof($rs_a); $i++) { print "<TR class=TableData>"; for ($j = 0; $j < sizeof($child_showlistfieldlist_Array); $j++) { $child_index = $child_showlistfieldlist_Array[$j]; $indexName = $child_columns[$child_index]; $ChildValue = $rs_a[$i][$indexName]; $filterType = $child_showlistfieldfilter_Array[$j]; $TypeNameFilterArray = explode(":", $filterType); switch ($TypeNameFilterArray[0]) { case 'input': break; case 'boolean': $ChildValue = returnboolean($ChildValue); break; case 'tablefilter': $filterTableName = $TypeNameFilterArray[1]; $filterTableColumns = returntablecolumn($filterTableName); $filterTableFieldID = $filterTableColumns[(string) $TypeNameFilterArray[2]]; $filterTableFieldName = $filterTableColumns[(string) $TypeNameFilterArray[3]]; $filterResultText = returntablefield($filterTableName, $filterTableFieldID, $ChildValue, $filterTableFieldName); $ChildValue = $filterResultText; break; } print "<TD noWrap>" . $ChildValue . " </td>"; } print "</TR>"; } UserDefineFunction($list); table_end(); print "<BR>"; print "<hr width=\"80%\" height=\"1\" align=\"{$align}\" color=\"white\">"; print "<BR>"; } //子目录列表结束 //############################################################################## }