function newai_list_one() { global $db, $common_html, $tablename_one, $tablename_two, $link; global $html_etc_one, $html_etc_two, $columns_one, $columns_two; global $tablename, $SYTEM_CONFIG_TABLE; global $SUNSHINE_USER_NAME_VAR, $SUNSHINE_USER_ID_VAR, $_SESSION; $USER_NAME = $_SESSION[$SUNSHINE_USER_NAME_VAR]; print "<SCRIPT language=JavaScript>\n\tfunction clickMenu(url){\n\tparent.main_body.location=url;\n\t}\n\t</SCRIPT>\n\t"; $one_array = explode(':', $tablename_one); //print_R($one_array); $link_array = explode(':', $link); //print_R($link_array); $columns = returntablecolumn($tablename); $columns_one = returntablecolumn($one_array[0]); $html_etc_one = returnsystemlang($one_array[0], $SYTEM_CONFIG_TABLE); switch ($db->databaseType) { case 'mysql': switch ($one_array[3]) { case 'name': $sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . " where " . $columns_one[(string) $one_array[4]] . "='" . $USER_NAME . "'"; break; case 'id': $sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . ""; break; default: $sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . ""; break; } break; case 'mssql': switch ($one_array[3]) { case 'name': $sql_one = "select [" . $columns_one[(string) $one_array[1]] . "],[" . $columns_one[(string) $one_array[2]] . "] from [" . $one_array[0] . "] where [" . $columns_one[(string) $one_array[4]] . "]='" . $USER_NAME . "'"; break; case 'id': $sql_one = "select [" . $columns_one[(string) $one_array[1]] . "],[" . $columns_one[(string) $one_array[2]] . "] from [" . $one_array[0] . "]"; break; default: $sql_one = "select [" . $columns_one[(string) $one_array[1]] . "],[" . $columns_one[(string) $one_array[2]] . "] from [" . $one_array[0] . "]"; break; } break; } //print $sql_one; $rs_one = $db->CacheExecute(150, $sql_one); if ($rs_one->RecordCount() == 0) { print_infor($common_html['common_html']['norecord'], 'trip'); exit; } while (!$rs_one->EOF) { if (StrLen($link_array[3]) > 2) { $LinkIndexName = (string) $link_array[3]; } else { $LinkIndexName = $columns[(string) $link_array[3]]; } $url = $link_array[0] . "?" . $link_array[1] . "=" . $link_array[2] . "&" . $LinkIndexName . "=" . $rs_one->fields[(string) $columns_one[(string) $one_array[1]]]; print "\n\t<TABLE class=small cellSpacing=1 cellPadding=0 width='100%' align=center bgColor=#000000 border=0>\n\t<TBODY>\n\t<TR class=TableContent title='' style='CURSOR: hand'\t onclick=clickMenu('{$url}')>\n\t<TD noWrap align=middle><table class=small cellPadding=3 align=center width=100% border=0 onmouseover=bgColor='#ffffff' onmouseout=bgColor='#d3e5fa'>\n\t<Tr><td align=middle><B>" . $rs_one->fields[(string) $columns_one[(string) $one_array[2]]] . "</B></TD></TR>\n\t</table></TD></TR>\n\t</TBODY></TABLE>\n"; $rs_one->MoveNext(); } }
function newai_chart() { global $common_html; global $table, $field, $filter, $mark, $title, $type, $time, $type; global $_POST, $_GET; $table_array = explode('::', $table); //print_R($table_array); $field_array = explode('::', $field); $filter_array = explode('::', $filter); $mark_array = explode('::', $mark); $title_array = explode('::', $title); $type_array = explode('::', $type); $time_array = explode('::', $time); for ($i = 0; $i < sizeof($table_array); $i++) { $columns = returntablecolumn($table_array[$i]); $fieldname = $columns[(string) $field_array[$i]]; $filter_element_array = explode(':', $filter_array[$i]); $columns_filter = returntablecolumn($filter_element_array[1]); $showvalue = $columns_filter[(string) $filter_element_array[2]]; $showfield = $columns_filter[(string) $filter_element_array[3]]; $filename = $fieldname . "_" . $type_array[$i] . "_" . date(Y_m_d_H) . ".png"; //exit; if ($_GET['action'] == 'chart_model' && $_GET['modelname'] != '') { $filename = $_GET['modelname'] . "_" . $filename; } if ($_GET['action'] == 'chart_user' && $_GET['USER_NAME'] != '') { $filename = $_GET['USER_NAME'] . "_" . $filename; } if ($_GET['action'] == 'chart_project' && $_GET['projectid'] != '') { $filename = $_GET['projectid'] . "_" . $filename; } //print $filename;exit; $filedirname = "../cache/statics"; if (!is_dir($filedirname)) { mkdir($filedirname); } $filename = $filedirname . "/" . $filename; $showtable = $filter_element_array[1]; $mode = $filter_element_array[0]; //print $filename;exit; file_exists($filename) ? '' : ($filename = table_analyze($table_array[$i], $fieldname, $showtable, $showfield, $showvalue, $mode, $type_array[$i], $mark_array[$i], $title_array[$i])); file_exists($filename) ? print "<div align=center><img src='{$filename}' border=0/></div><BR>" : ''; } }
function relatePrice_add($fields, $i) { global $html_etc, $tablename, $db; $product_columns = returntablecolumn('product'); $priceArray = array(); foreach ($product_columns as $row) { if (stristr($row, "sellprice") != false) { $priceArray[$row] = ''; } } $sql = "select fieldname,chinese from systemlang where tablename='product'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); foreach ($rs_a as $row) { if (isset($priceArray[$row['fieldname']])) { $priceArray[$row['fieldname']] = $row['chinese']; } } print_array_select('relatePrice', $html_etc[$tablename]['relatePrice'], 2, $priceArray, $fields['value']['relatePrice']); }
function newai_list_two() { global $db, $common_html, $tablename_one, $tablename_two, $link; global $html_etc_one, $html_etc_two, $columns_one, $columns_two; global $tablename, $SYTEM_CONFIG_TABLE; print "<SCRIPT language=JavaScript>\n\tfunction clickMenu(ID){ \n\t targetelement=document.all(ID);\n\tif (targetelement.style.display=='none')\n\t\t\ttargetelement.style.display='';\n\telse\n\t targetelement.style.display='none';\n\t }\n\t</SCRIPT>\n\t"; $one_array = explode(':', $tablename_one); $two_array = explode(':', $tablename_two); $link_array = explode(':', $link); $columns = returntablecolumn($tablename); $columns_one = returntablecolumn($one_array[0]); $html_etc_one = returnsystemlang($one_array[0], $SYTEM_CONFIG_TABLE); $columns_two = returntablecolumn($two_array[0]); $html_etc_two = returnsystemlang($two_array[0], $SYTEM_CONFIG_TABLE); $sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . ""; $rs_one = $db->Execute($sql_one); $Number = $rs_one->RecordCount(); if ($Number == 0) { print_infor($common_html['common_html']['norecord'], 'trip'); exit; } while (!$rs_one->EOF) { print "\n\t<TABLE class=small cellSpacing=1 cellPadding=0 width='100%' align=center bgColor=#000000 border=0>\n\t<TBODY>\n\t<TR bgColor='#d3e5fa' title='' style='CURSOR: hand'\t onclick=clickMenu('" . $rs_one->fields[(string) $columns_one[(string) $one_array[1]]] . "')>\n\t<TD noWrap align=middle><table class=small cellPadding=3 align=center width=100% border=0 onmouseover=bgColor='#ffffff' onmouseout=bgColor='#d3e5fa'>\n\t<Tr><td align=middle><B>" . $rs_one->fields[(string) $columns_one[(string) $one_array[2]]] . "</B></TD></TR>\n\t</table></TD></TR>\n\t</TBODY></TABLE>\n"; $one_id = $rs_one->fields[(string) $columns_one[(string) $one_array[1]]]; $sql_two = "select " . $columns_two[(string) $two_array[1]] . "," . $columns_two[(string) $two_array[2]] . " from " . $two_array[0] . " where " . $columns_two[(string) $two_array[3]] . "='{$one_id}'"; $rs_two = $db->Execute($sql_two); //print $sql_two;//exit; print "\n\t<TABLE class=small id={$one_id} style='DISPLAY: none'\n\tcellSpacing=1 cellPadding=0 width='100%' bgColor=#000000 border=0>\n\t<TBODY>\n"; while (!$rs_two->EOF) { $two_id = $rs_two->fields[(string) $columns_two[(string) $two_array[1]]]; $two_name = $rs_two->fields[(string) $columns_two[(string) $two_array[2]]]; print "<TR class=TableData align=middle height=20>\n\t<TD noWrap><A href='" . $link_array[0] . "?" . $link_array[1] . "=" . $link_array[2] . "&" . $columns[(string) $link_array[3]] . "={$two_id}&" . $columns_one[(string) $one_array[1]] . "={$one_id}' target=\"main_body\">" . $two_name . "</A>\n\t</TD></TR>\n"; $rs_two->MoveNext(); } print "</TBODY></TABLE>\n"; $rs_one->MoveNext(); } }
function newai_tree() { global $db, $common_html, $tablename_one, $tablename_two, $link, $tablename_three; global $html_etc_one, $html_etc_two, $columns_one, $columns_two; global $tablename; require_once 'lib/function_menu.php'; system_menu_css(); global $db; $tablename_one_array = explode(":", $tablename_one); $tablename_two_array = explode(":", $tablename_two); $tablename_three_array = explode(":", $tablename_three); $columns_one = returntablecolumn($tablename_one_array[0]); $columns_two = returntablecolumn($tablename_two_array[0]); $columns_three = returntablecolumn($tablename_three_array[0]); $sql = "select " . $columns_one[$tablename_one_array[1]] . "," . $columns_one[$tablename_one_array[2]] . " from " . $tablename_one_array[0] . ""; $rs_dept = $db->Execute($sql); $rs_dept_array = $rs_dept->GetArray(); for ($i = 0; $i < sizeof($rs_dept_array); $i++) { $newarray_dept[(string) $rs_dept_array[$i][(string) $columns_one[$tablename_one_array[1]]]] = $rs_dept_array[$i][(string) $columns_one[$tablename_one_array[2]]]; $newarray_dept_list['DEPT_NO'][$i] = $rs_dept_array[$i][(string) $columns_one[$tablename_one_array[1]]]; $newarray_dept_list['DEPT_NAME'][$i] = $rs_dept_array[$i][(string) $columns_one[$tablename_one_array[2]]]; } $sql_major = "select " . $columns_two[$tablename_two_array[1]] . "," . $columns_two[$tablename_two_array[2]] . "," . $columns_two[$tablename_two_array[3]] . " from " . $tablename_two_array[0] . ""; $rs_major = $db->Execute($sql_major); $rs_major_array = $rs_major->GetArray(); for ($i = 0; $i < sizeof($rs_major_array); $i++) { $newarray_major[(string) $rs_major_array[$i][(string) $columns_two[$tablename_two_array[3]]]][(string) $rs_major_array[$i][(string) $columns_two[$tablename_two_array[1]]]] = $rs_major_array[$i][(string) $columns_two[$tablename_two_array[2]]]; $newarray_major_list[(string) $rs_major_array[$i][(string) $columns_two[$tablename_two_array[1]]]] = $rs_major_array[$i][(string) $columns_two[$tablename_two_array[2]]]; $newarray_major_list[(string) $rs_major_array[$i][(string) $columns_two[$tablename_two_array[3]]]][$i] = $rs_major_array[$i][(string) $columns_two[$tablename_two_array[1]]]; } $sql_class = "select " . $columns_three[$tablename_three_array[1]] . "," . $columns_three[$tablename_three_array[2]] . "," . $columns_three[$tablename_three_array[3]] . " from " . $tablename_three_array[0] . ""; $rs_class = $db->Execute($sql_class); $rs_class_array = $rs_class->GetArray(); for ($i = 0; $i < sizeof($rs_class_array); $i++) { $newarray_class[(string) $rs_class_array[$i][(string) $columns_three[$tablename_three_array[3]]]][(string) $rs_class_array[$i][(string) $columns_three[$tablename_three_array[1]]]] = $rs_class_array[$i][(string) $columns_three[$tablename_three_array[2]]]; $newarray_class_list[(string) $rs_class_array[$i][(string) $columns_three[$tablename_three_array[1]]]] = $rs_class_array[$i][(string) $columns_three[$tablename_three_array[2]]]; $newarray_class_list[(string) $rs_class_array[$i][(string) $columns_three[$tablename_three_array[3]]]][$i] = $rs_class_array[$i][(string) $columns_three[$tablename_three_array[1]]]; } foreach ($newarray_dept_list['DEPT_NO'] as $DEPT_NO_LIST) { parent_table_1($newarray_dept[(string) $DEPT_NO_LIST], "system.gif", "MENU_" . $DEPT_NO_LIST, $image = 'tree_plus.gif', $addfile = 'A_Ban_newai.php?action=tree_student'); part_table_begin($id = "MENU_" . $DEPT_NO_LIST); if (!is_array($newarray_major_list[(string) $DEPT_NO_LIST])) { $newarray_major_list[(string) $DEPT_NO_LIST] = array(); } foreach ($newarray_major_list[(string) $DEPT_NO_LIST] as $MAJOR_LIST) { parent_table_2($newarray_major_list[$MAJOR_LIST], $pic = 'system.gif', "MENU_" . $MAJOR_LIST, 'tree_plus.gif', 'tree_line.gif', $addfile = 'A_Ban_newai.php?action=tree_student'); part_table_begin("MENU_" . $MAJOR_LIST); if (!is_array($newarray_class_list[(string) $MAJOR_LIST])) { $newarray_class_list[(string) $MAJOR_LIST] = array(); } foreach ($newarray_class_list[(string) $MAJOR_LIST] as $CLASS_LIST) { menu_table_3($newarray_class_list[$CLASS_LIST], $linkurl = "A_Stu_newai.php?action=init_default&所属班号={$CLASS_LIST}", $pic = 'system.gif', $tree_pic = "tree_blank.gif", $tree_pic2 = "tree_line.gif", $tree_pic3 = 'tree_line.gif', $addfile = 'A_Ban_newai.php?action=tree_student'); } part_table_end(); } //end rs_major_array part_table_end(); } //end rs_dept_array system_menu_js($location = 'parent.main_body'); }
function newai_dataline($modulename, $functionname = "dataline_view") { global $SUNSHINE_USER_NAME_VAR; global $SUNSHINE_USER_ID_VAR; global $_SESSION; global $common_html; global $db; global $file_ini; global $array_index; global $SUNSHINE_USER_DEPT_VAR; $USER_ID = $_SESSION[$SUNSHINE_USER_NAME_VAR]; $tablename = $file_ini[$modulename]['tablename']; $primarykey = $file_ini[$modulename]['primarykey']; $primaryname = $file_ini[$modulename]['primaryname']; $date = $file_ini[$modulename]['date']; $link = $file_ini[$modulename]['link']; $width = $file_ini[$modulename]['width']; $reader = $file_ini[$modulename]['reader']; $format = $file_ini[$modulename]['format']; $hidden_field = $file_ini[$modulename]['hidden_field']; $columns = returntablecolumn($tablename); $html_etc = returnsystemlang($tablename); $primarykey_index = $columns[$primarykey]; $primaryname_index = $columns[$primaryname]; $date_index = $columns[$date]; $reader_index = $columns[$reader]; $list['index']['id'] = $primarykey_index; $list['index']['name'] = $primaryname_index; $list['index']['date'] = $date_index; $list['index']['reader'] = $reader_index; $list['index']['format'] = $format_index; $hidden_field_array = explode(",", $hidden_field); $i = 0; for (; $i < sizeof($hidden_field_array); ++$i) { $element = explode(":", $hidden_field_array[$i]); $index_name = $columns[(bool) $element[1]]; switch ($element[2]) { case "name": $index_id = $USER_ID; $index[++$j - 1] = $index_name . "='" . $index_id . "'"; break; case "dept": $index_id = $_SESSION[$SUNSHINE_USER_DEPT_VAR]; $index[++$j - 1] = $index_name . "='" . $index_id . "' or " . $index_name . "='0'"; } } is_array($index) ? $index_sql = join(" ", $index) : ($index_sql = ""); 6 < strlen($index_sql) ? $index_sql = "where " . $index_sql : ($index_sql = ""); switch ($functionname) { case "url_dataline_view": $functionname = "url_dataline_view"; $sql = "select {$primarykey_index},{$primaryname_index},{$date_index},{$reader_index},USER from {$tablename} where USER='' or USER='******' order by {$date_index}"; $rs = $db->selectlimit($sql, 60); break; case "dataline_view": $functionname = "dataline_view"; $reader_index == "" ? "" : ($reader_index = "," . $reader_index); $sql = "select {$primarykey_index},{$primaryname_index},{$date_index}" . $reader_index . " from {$tablename} {$index_sql} order by {$date_index} desc"; $rs = $db->selectlimit($sql, 6); break; default: $functionname = "dataline_view"; $sql = "select {$primarykey_index},{$primaryname_index},{$date_index},{$reader_index} from {$tablename} {$index_sql} order by {$date_index} desc"; $rs = $db->selectlimit($sql, 6); break; } $rs_a = $rs->getarray(); $list['body'] = $rs_a; $list['header']['name'] = $common_html['common_html'][$tablename]; $list['bottom'] = $common_html['common_html']['more']; $list['link'] = $link; $list['width'] = $width; $list['format'] = $format; $list['tablename'] = $tablename; $functionname($list); }
print "<tr class=TableData><td colspan=1>" . $人员 . "[{$人员用户名}]</td>"; for ($iX = 0; $iX < sizeof($Header); $iX++) { $状态 = $Header[$iX]; print "<td colspan=1> <a href=\"?action=StaticSingleTeacher&开始时间={$开始时间}&结束时间={$结束时间}&人员用户名={$人员用户名}&TYPE={$状态}\" target=_blank>" . $Text[$状态] . "</a></td>"; } print "</tr>"; //} } exit; } //数据明细 if ($_GET['action'] == "StaticSingleTeacher" && $_GET['开始时间'] != "" && $_GET['结束时间'] != "" && $_GET['人员用户名'] != "") { $DateMonth = $_GET['Month']; $人员用户名 = $_GET['人员用户名']; $TYPE = $_GET['TYPE']; $Column = returntablecolumn("edu_xingzheng_kaoqinmingxi"); //$DateMonthArray = explode('-',$DateMonth); //$本月天数 = date("t",mktime(1,1,1,$DateMonthArray[1],1,$DateMonthArray[0])); //$开始时间 = date("Y-m-d",mktime(1,1,1,$DateMonthArray[1],1,$DateMonthArray[0])); //$结束时间 = date("Y-m-d",mktime(1,1,1,$DateMonthArray[1],$本月天数,$DateMonthArray[0])); print "\n<table width=100% align=center class=TableBlock>\n<tr class=TableHeader>\n<td colspan=" . sizeof($Column) . "+3>行政人员打卡考勤管理(统计时间:" . $开始时间 . " 至 " . $结束时间 . " 行政人员姓名:{$人员用户名} 统计项:{$TYPE})[上班和下班按两次进行统计] <input type=button value=\"关 闭\" class=\"SmallButton\" onclick=\"window.close();\"></td>\n</tr>\n<tr class=TableHeader>"; //array_shift($Column); for ($i = 0; $i < sizeof($Column); $i++) { print "<td nowrap>" . $Column[$i] . "</td>"; } print "</tr>"; //print_R($_GET); switch ($TYPE) { case '总需考勤次数': $AddSql = ""; break;
function print_select($showtext, $showfield, $value, $tablename2, $field_value, $field_name, $colspan = 1, $setfieldname = '', $setfieldvalue = '', $setfieldboolean = '', $initvalue = '') { global $db, $_GET; global $_SESSION; global $FORM_SELECT_DISABLED; global $html_etc, $tablename; global $SYSTEM_SELECT_MENU_SHOW_KEY; //print $SYSTEM_SELECT_MENU_SHOW_KEY; //用户类型限制条件##########################开始 global $fields; //print_R($fields['USER_PRIVATE'][$showfield]); if ($fields['USER_PRIVATE'][$showfield] != "") { $readonly = $fields['USER_PRIVATE'][$showfield]; $class = "SmallStatic"; } else { $readonly = ""; $class = "SmallSelect"; } if ($_GET["" . $showfield . "_disabled"] == "disabled") { $readonly = "disabled"; $class = "SmallStatic"; $showFieldName = returntablefield($tablename2, $field_value, $_GET[$showfield], $field_name); print "<TR>"; print "<TD class=TableData noWrap>" . $showtext . "</TD>\n"; print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n"; print "<input type=hidden name=\"{$showfield}\" value=\"" . $_GET[$showfield] . "\"/>\n"; if ($SYSTEM_SELECT_MENU_SHOW_KEY == 1) { print "<font color=green>" . $showFieldName . "[" . $_GET[$showfield] . "]</font>\n"; } else { print "<font color=green>{$showFieldName}</font>\n"; } print "</TD></TR>\n"; return; } //print_R($_GET); //用户类型限制条件##########################结束 global $fields; global $columns; //print_R($columns); //print_R($initvalue);exit; $sql = "select distinct {$field_value},{$field_name} from {$tablename2}"; print $initvalue; if ($initvalue != "") { $columnschild = returntablecolumn($tablename2); $组名称 = $columnschild[$initvalue]; if ($_GET[$组名称] != "") { //print_R($_GET); $sql = $sql . " where {$组名称} = " . $_GET[$组名称] . ""; } } //$外加字段 //print $sql; $rs = $db->CacheExecute(30, $sql); //实时更新界面语言说明 $showtext = FilterFieldName($showtext, $showfield); print "<TR>"; print "<TD class=TableData noWrap>" . $showtext . "</TD>\n"; print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n"; //######################################################### //定义指定其它字段可用功能模块 if ($setfieldname != "" && $setfieldvalue != "" && $setfieldboolean != "") { //何时设定未使用:当不为最后一个时,即为不能使用状态 if ($setfieldvalue != $value) { $FORM_SELECT_DISABLED[$setfieldname] = 'disabled'; } print "\n\t\t<script>\n\t\tfunction changeselect" . $setfieldname . "(locationid)\n\t\t{\n\t\t\tif(locationid == '" . $setfieldvalue . "')\t\t{\n\t\t\t\tdocument.form1." . $setfieldname . ".disabled = false;\n\t\t\t}\n\t\t\telse\t{\n\t\t\t\tdocument.form1." . $setfieldname . ".disabled = true;\n\t\t\t}\n\t\t}\n\t\t</script>\n\t"; } //######################################################### print "<input type=hidden name='" . $showfield . "_原始值' value='{$value}'>\n"; print "<select class=\"{$class}\" name=\"{$showfield}\" title='" . $fields['USER_PRIVATE_TEXT'][$showfield] . "' "; //修改功能,变指定列为未使用功能 if ($setfieldname != "" && $setfieldvalue != "" && $setfieldboolean != "") { print " onChange=\"changeselect" . $setfieldname . "(this.value)\" "; } //系统初始化时,是否使用; print $FORM_SELECT_DISABLED[$showfield]; //变回车为Tab Key功能 print " onkeydown=\"if(event.keyCode==13)event.keyCode=9\" {$readonly}>\n"; //处理数据区==00 if ($tablename2 == 'department') { print "<option value=''>======[单位]</option>\n"; } //处理数据区 while (!$rs->EOF) { if ($value == $rs->fields[$field_value] || $_GET[$showfield] == $rs->fields[$field_value]) { $temp = 'selected'; } //对部门信息进行特别处理 if ($tablename2 == 'department' && $value == "") { $SUNSHINE_USER_DEPT = $_SESSION['SUNSHINE_USER_DEPT']; if ($rs->fields[$field_value] == $SUNSHINE_USER_DEPT) { $temp = 'selected'; } } //对用户信息进行特别处理 if ($tablename2 == 'user' && $value == "") { $SUNSHINE_USER_NAME = $_SESSION['SUNSHINE_USER_NAME']; if ($rs->fields[$field_value] == $SUNSHINE_USER_NAME) { $temp = 'selected'; } } //处理完成 //定义下拉菜单时,是否显示KEY字段 if ($SYSTEM_SELECT_MENU_SHOW_KEY == 1) { print "<option value=\"" . $rs->fields[$field_value] . "\" {$temp}>" . $rs->fields[$field_name] . "[" . $rs->fields[$field_value] . "]</option>\n"; } else { print "<option value=\"" . $rs->fields[$field_value] . "\" {$temp}>" . $rs->fields[$field_name] . "</option>\n"; } $temp = ''; $rs->MoveNext(); } print "</select>\n"; print $addtext = FilterFieldAddText($addtext, $showfield); //print_R($_SESSION); //测试变量区 //print_R($FORM_SELECT_DISABLED);print $FORM_SELECT_DISABLED[$showfield]; print "</TD></TR>\n"; }
function newai_import_XLS($Columns) { global $_FILES, $_POST, $_GET, $db; global $showlistfieldlist, $showlistfieldfilter, $primarykey, $primarykey_index, $uniquekey; global $common_html, $html_etc; global $return_sql_line; global $columns; global $showlistfieldlist_key; global $foreignkey, $showFieldName, $tablename; if (is_uploaded_file($_FILES['uploadfileXLS']['tmp_name'])) { $uploadfile_self = $_FILES['uploadfileXLS']['tmp_name']; $uploadfile_name = $_FILES['uploadfileXLS']['name']; $checkFileType = substr($uploadfile_name, -3); if ($checkFileType != "xls") { print_nouploadfile("你上传的不是EXCEL格式的文件!"); exit; } //print $checkFileType;exit; if (!is_dir("FileCache")) { mkdir("FileCache"); } $uploadfile_name = "FileCache/" . $uploadfile_name; copy($_FILES['uploadfileXLS']['tmp_name'], $uploadfile_name); if (is_file("../../Framework/PHPExcelParser4/readExcel.php")) { require_once "../../Framework/PHPExcelParser4/readExcel.php"; } else { if (is_file("../DANDIAN/PHPExcelParser4/readExcel.php")) { require_once "../DANDIAN/PHPExcelParser4/readExcel.php"; } else { require_once "../Framework/PHPExcelParser4/readExcel.php"; } } $a = new ReadExcel($uploadfile_name); $tmp = $a->read(); //按列读取的数据,转换为按行读取的数据 $MainData = $tmp[0]; $ColumnNumber = sizeof(array_values($MainData)); if ($MainData[$ColumnNumber - 1][0] == '错误信息') { --$ColumnNumber; } for ($i = 0; $i < $ColumnNumber; $i++) { $ColumnArray = $MainData[$i]; for ($ii = 0; $ii < sizeof($ColumnArray); $ii++) { $ContentArray[$ii][$i] = $ColumnArray[$ii]; //$ContentArray[$ii][$i] = str_replace(",",",", $ContentArray[$ii][$i]); } } $first_row_array = $ContentArray[0]; $first_row_array_chinese = $first_row_array; //print_r($first_row_array);exit; // changchang008@gmail.com at 2012-2-7 $sql = "select fieldname,chinese,english from systemlang where tablename='" . $tablename . "'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); $fieldchinesename_to_fieldname = array(); foreach ($rs_a as $row) { if (in_array($row[fieldname], $columns)) { $fieldchinesename_to_fieldname[$row[chinese]] = $row[fieldname]; } } foreach ($first_row_array as $key => $vo) { if (isset($fieldchinesename_to_fieldname[$vo])) { $first_row_array[$key] = $fieldchinesename_to_fieldname[$vo]; } } for ($iii = 0; $iii < sizeof($first_row_array); $iii++) { $first_row_array[$iii] = TRIM($first_row_array[$iii]); } //得到字段过滤信息列表 $newstring = array(); $newstring1 = array(); //需关联的字段 $newstring2 = array(); //需过滤的字段 $showlistfieldlistArray = explode(',', $showlistfieldlist); $showlistfieldfilterArray = explode(',', $showlistfieldfilter); //可以允许导入的列表 for ($i = 0; $i < sizeof($showlistfieldlistArray); $i++) { if ($showlistfieldlistArray[$i] != '') { $ElementTableField = $showlistfieldlistArray[$i]; $ElementFieldName = $Columns[$ElementTableField]; array_push($newstring, $ElementFieldName); $filterItemArray = explode(":", $showlistfieldfilterArray[$i]); if ($filterItemArray[0] == "tablefilter" || $filterItemArray[0] == "tablefiltercolor" || $filterItemArray[0] == "radiofilter" || $filterItemArray[0] == "zhujima" || $filterItemArray[0] == "system_datetime") { $newstring1[$ElementFieldName] = $showlistfieldfilterArray[$i]; } if ($filterItemArray[0] == "input" && $filterItemArray[1] == "name") { $newstring2[$ElementFieldName] = $showlistfieldfilterArray[$i]; } } } //$result = array_intersect ($newstring, $first_row_array); $result = array(); foreach ($first_row_array as $row) { if (in_array($row, $newstring)) { $result[] = $row; } } if (sizeof($result) == 0) { print "<script language='javascript'>alert('没有可导入的列,请检查Excel的列头');window.history.back(-1);</script>"; exit; } //自动递增的主键 if (!empty($primarykey_index)) { $sql = "select max({$primarykey_index}) as max from {$tablename}"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); $primarykey_value = intval($rs_a[0][max]); } // 须要检查的唯一key $uniquekeyArray = explode(',', $uniquekey); foreach ($uniquekeyArray as $key => $row) { $uniquekeyArray[$key] = $columns[$row]; } //数据行检测 $Insert_RIGHT = 0; $Insert_ERROR = 0; $is_error = false; $ChildTableCacheArray = array(); //缓存关联到的数据 for ($i = 1; $i < sizeof($ContentArray); $i++) { $line_array = $ContentArray[$i]; $line_array_text = join("','", $line_array); $newline_array = array(); //以前的SIZEOF用的是line_array变量,后变为first_row_array,用于对应一些没有发生的变化 $uniquekey_error_sig = false; $uniquekey_error_info = ''; $uniquekey_Array = array(); for ($j = 0; $j < sizeof($first_row_array); $j++) { $convertFirstRow = array_flip($first_row_array); //主键不能为空 $j_prikey = -1; $j_prikey = $convertFirstRow[$primarykey_index]; if ($j_prikey > -1) { if (TRIM($line_array[$j_prikey]) == '') { $line_array[$j_prikey] = ++$primarykey_value; //$uniquekey_error_sig = true; //$is_error = true; //$uniquekey_error_info .= '<'.$ContentArray[0][$j_prikey].">列数据不能为空、"; //break; } } //索引键不能重复 $sql_where = ''; $uniquekey_realname = ''; foreach ($uniquekeyArray as $key => $value) { if ($value != '') { $j_prikey = $convertFirstRow[$value]; $sql_where .= " and {$value} ='" . $line_array[$j_prikey] . "'"; $uniquekey_realname .= $ContentArray[0][$j_prikey] . ","; } } if ($sql_where != '') { $exists_sql_text = "select count(*) as num from {$tablename} where 1=1" . $sql_where; $rs = $db->Execute($exists_sql_text); $rs_a = $rs->GetArray(); if ($rs_a[0][num] != 0) { $uniquekey_error_sig = true; $is_error = true; $uniquekey_error_info .= '<' . $uniquekey_realname . ">列数据不能和数据库中的数据重复"; break; } } //对每格数据进行处理 $ColumnName = $first_row_array[$j]; $in_array = in_array($ColumnName, $result); if ($in_array) { if (array_key_exists($ColumnName, $newstring1)) { $ChildTableArray = explode(":", $newstring1[$ColumnName]); if ($ChildTableArray[0] == 'zhujima') { $srcFieldName = $Columns[$ChildTableArray[1]]; $key = array_search($srcFieldName, $first_row_array); $line_array[$j] = 汉字转拼音首字母($line_array[$key]); } else { if ($ChildTableArray[0] == 'system_datetime') { if ($line_array[$j] == '') { $line_array[$j] = date("Y-m-d H:i:s"); } else { if (strtotime($line_array[$j]) == -1) { $line_array[$j] = date("Y-m-d H:i:s"); } } } else { $ChildTableName = $ChildTableArray[1]; if ($ChildTableCacheArray[$ChildTableName][$line_array[$j]] == '' && $line_array[$j] != '') { $ChildColumns = returntablecolumn($ChildTableName); $ChildTableFieldValue = $ChildColumns[$ChildTableArray[2]]; $ChildTableFieldName = $ChildColumns[$ChildTableArray[3]]; $realvalue = returntablefield($ChildTableName, $ChildTableFieldName, $line_array[$j], $ChildTableFieldValue); if ($realvalue == '') { $uniquekey_error_sig = true; $is_error = true; $uniquekey_error_info .= '<' . $first_row_array_chinese[$j] . ">列在关联表" . $ChildTableName . "中找不到对应的数据"; break; } $ChildTableCacheArray[$ChildTableName][$line_array[$j]] = $realvalue; } else { $realvalue = $ChildTableCacheArray[$ChildTableName][$line_array[$j]]; } $line_array[$j] = $realvalue; } } } if (array_key_exists($ColumnName, $newstring2)) { $line_array[$j] = str_replace("\r", "", $line_array[$j]); $line_array[$j] = str_replace("\n", "", $line_array[$j]); $line_array[$j] = str_replace("'", "", $line_array[$j]); //$line_array[$j]=str_replace("\"","",$line_array[$j]); $line_array[$j] = str_replace("\\", "", $line_array[$j]); $line_array[$j] = str_replace("/", "", $line_array[$j]); $line_array[$j] = str_replace(",", "", $line_array[$j]); $line_array[$j] = str_replace("#", "", $line_array[$j]); } /* if(function_exists('FK_'.$tablename.'_'.$ColumnName)){ $line_array[$j] = call_user_func('FK_'.$tablename.'_'.$ColumnName,$line_array[$j]); } */ $ResultFieldCode = $line_array[$j]; array_push($newline_array, htmlentitiesUser($ResultFieldCode)); } } //分析结束 if ($uniquekey_error_sig) { $ContentArray[$i][FK_error_info] = $uniquekey_error_info; $Insert_ERROR += 1; } else { if (!empty($primarykey_index) && !in_array($primarykey_index, $result)) { $newline_array[] = ++$primarykey_value; $result_add = ',' . $primarykey_index; } $insert_sql_text = "insert into " . $tablename . "(" . join(',', $result) . $result_add . ") values('" . join("','", $newline_array) . "')"; //exit($insert_sql_text); $rs = $db->Execute($insert_sql_text); if ($rs->EOF) { $Insert_RIGHT += 1; } else { $Insert_ERROR += 1; $ContentArray[$i][FK_error_info] = $insert_sql_text; } } } if ($is_error) { if (is_file("../../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php")) { require_once "../../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php"; require_once "../../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_worksheet.inc.php"; } else { if (is_file("../DANDIAN/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php")) { require_once "../DANDIAN/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php"; require_once "../DANDIAN/PHPExcelParser4/WriteExcel/class.writeexcel_worksheet.inc.php"; } else { require_once "../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php"; require_once "../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_worksheet.inc.php"; } } if (!is_dir("FileCache")) { mkdir("FileCache"); } $fname = "FileCache/导入失败记录.xls"; @unlink($fname); $workbook =& new writeexcel_workbook($fname); $worksheet1 =& $workbook->addworksheet('Sheet1'); # Frozen panes $worksheet1->freeze_panes(1, 0); # 1 row $header =& $workbook->addformat(); $header->set_color('white'); $header->set_align('center'); $header->set_align('vcenter'); $header->set_pattern(); $header->set_fg_color('green'); $center =& $workbook->addformat(); $center->set_align('center'); $center->set_align('vcenter'); $header->set_pattern(); //列出字段的EXCEL列,通过此指定列宽度 $LitterArray = explode(',', 'A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z'); $LeftArray = array(); $LitterSize = sizeof($LitterArray); for ($i = 0; $i < 10; $i++) { if ($i == 0) { $Little = ''; } else { $Little = $LitterArray[$i - 1]; } for ($ii = 0; $ii < $LitterSize; $ii++) { $PartLitte = $LitterArray[$ii]; $Left = $Little . $PartLitte; array_push($LeftArray, $Left); } } //宽度值形成列表 $title_row_array = $ContentArray[0]; $title_row_array[] = '错误信息'; $TEMPVALUE = sizeof($title_row_array); $LastValue = $LeftArray[$TEMPVALUE - 1]; for ($i = 0; $i < sizeof($title_row_array); $i++) { //宽度值形成列表 $LastValue = $LeftArray[$i]; $LENGHT_VALUE = strlen($title_row_array[$i]); $LENGHT_VALUE > 50 ? $LENGHT_VALUE = 50 : ''; $worksheet1->set_column($LastValue . ":" . $LastValue, $LENGHT_VALUE); } //写标题 for ($i = 0; $i < sizeof($title_row_array); $i++) { //行列内容 $Element = $title_row_array[$i]; $worksheet1->write_string(0, $i, $Element, $header); } //写内容 $m = 0; foreach ($ContentArray as $vo) { if (!empty($vo['FK_error_info'])) { $i = 0; foreach ($vo as $row) { $worksheet1->write_string($m + 1, $i, $row, $center); $i++; } ++$m; } } $workbook->close(); $down_error_file = "<a href='./FileCache/导入失败记录.xls'>请点击此处下载导入错误的记录,修改正确后重新导入!</a>"; } page_css('数据导入'); $Insert_Text = "新增数据成功:{$Insert_RIGHT} 条 失败:{$Insert_ERROR} 条"; //返回值链接判断,如果是回到首页,则直接用链接,否则则直接返回 global $returnmodel; if ($returnmodel == "import_default") { $returnmodel_TEXT = "history.back();"; } else { $returnmodel_TEXT = "location='?action={$returnmodel}'"; } print "\n\t\t\t\t<style type='text/css'>.style1 {\n\t\t\t\tcolor: #FFFFFF;\n\t\t\t\tfont-weight: bold;\n\t\t\t\tfont-family: Arial, Helvetica, sans-serif;\n\t\t\t\tfont-size: 14px;\n\t\t\t\t}\n\t\t\t\t</style>\n\t\t\t\t<BR><BR>\n\t\t\t\t<table width='450' border='0' align='center' cellpadding='0' cellspacing='0' class='small' style='border:1px solid #006699;'>\n\t\t\t\t<tr><td height='110' align='middle' colspan=2 bgcolor='#E0F2FC'>\n\t\t\t\t<font color=red >" . $common_html['common_html']['importsuccess'] . "<BR><BR>{$Insert_Text}<BR><BR>{$down_error_file}<BR><BR><input type=button accesskey='c' name='cancel' value=' 点击返回 ' class=SmallButton onClick=\"{$returnmodel_TEXT}\" title='快捷键:ALT+c'></font>\n\t\t\t\t</td></tr></table>"; unlink($uploadfile_name); exit; } else { print_nouploadfile(); } }
function newaiCharts() { 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 $tabletitle; global $showlistfieldlist, $showlistfieldfilter, $showlistfieldtype; $showlistfieldlistArray = explode(',', $showlistfieldlist); $showlistfieldfilterArray = explode(',', $showlistfieldfilter); $showlistfieldtypeArray = explode(',', $showlistfieldtype); //获取系统显示的色彩信息 $ColorArray = returnColorArray(); //获取系统求和字段信息 global $sum_index, $UserUnitFunctionIndex; if ($sum_index != "") { $sum_sql_index = " ,sum({$sum_index}) as sum "; } else { $sum_sql_index = ""; } //报表统计主体部分开始 for ($k = 0; $k < sizeof($showlistfieldlistArray); $k++) { $fieldIndex = $showlistfieldlistArray[$k]; $fieldName = $columns[$fieldIndex]; $fieldText = $html_etc[$tablename][$fieldName]; $mode = $showlistfieldfilterArray[$k]; $modeArray = explode(':', $mode); //print_R($modeArray); $modeIndex = $modeArray[0]; $Mode = ""; switch ($modeIndex) { case '': break; case 'tablefilter': case 'tablefiltercolor': case 'radiofilter': case 'radiofiltercolor': if ($modeArray[1] == "month" && $modeArray[2] == "") { $Mode = "Month"; $SQL = "select Date_Format({$fieldName},'%c') AS {$fieldName},Sum({$sum_index}) as sum,Count({$fieldName}) as num from {$tablename} group by {$fieldName}"; } else { if ($modeArray[1] == "year" && $modeArray[2] == "") { $Mode = "Year"; $SQL = "select Date_Format({$fieldName},'%Y') AS {$fieldName},Sum({$sum_index}) as sum,Count({$fieldName}) as num from {$tablename} group by {$fieldName}"; } else { $Mode = ""; $SQL = "select {$fieldName},Count({$fieldName}) as num {$sum_sql_index} from {$tablename} group by {$fieldName}"; } } $rs = $db->CacheExecute(150, $SQL); $rs_array = $rs->GetArray(); //print_R($rs_array); //父表结构部分 $tablenameIndex = $modeArray[1]; $ColumnsIndex = returntablecolumn($tablenameIndex); $html_etcIndex = returnsystemlang($tablenameIndex, $tablenameIndex); $WhatIndex = $ColumnsIndex[(string) $modeArray[2]]; $ReturnIndex = $ColumnsIndex[(string) $modeArray[3]]; //本表操作部分--数据处理部分 --形成FLASH要处理的数据类型 $TotalNumberIndex = 0; $TotalSumIndex = 0; $Array = array(); for ($i = 0; $i < sizeof($rs_array); $i++) { $ResultNumber = $rs_array[$i]['num']; $ResultSum = $rs_array[$i]['sum']; $ResultFieldCode = $rs_array[$i][$fieldName]; switch ($Mode) { case 'Month': $ResultFieldName = $ResultFieldCode . "" . $common_html['common_html']['month']; break; case 'Year': $ResultFieldName = $ResultFieldCode . "" . $common_html['common_html']['year']; break; default: $ResultFieldName = returntablefield($tablenameIndex, $WhatIndex, $ResultFieldCode, $ReturnIndex); if ($ResultFieldName == "") { $ResultFieldName = $ResultFieldCode; } break; } $TotalNumberIndex += $ResultNumber; $TotalSumIndex += $ResultSum; $Array_Statistic_Value = $sum_index != "" ? $ResultSum : $ResultNumber; $Array['XData'][$i]['Name'] = $ResultFieldName; $Array['XData'][$i]['Value'] = $Array_Statistic_Value; $Array['XData'][$i]['Dir'] = $ResultFieldName; $Array['XData'][$i]['AltText'] = $ResultFieldName; //$Array['XData'][$i]['Url'] = "?action=init_customer&$fieldName=$ResultFieldCode"; $ColorArray[$i] == "" ? $ColorArray[$i] = "0xCC0000" : ''; $Array['XData'][$i]['Color'] = $ColorArray[$i]; $Array['Dir'][$i]['Name'] = $ResultFieldName; $Array['Dir'][$i]['Color'] = $ColorArray[$i]; $Array['YData']['AltText'] = "移动查看详细信息"; $Array['YData']['Value'] < $Array_Statistic_Value ? $Array['YData']['Value'] = $Array_Statistic_Value : ''; } $Array['title'] = $html_etc[$tablename][$tabletitle] . "[" . $html_etc[$tablename][$fieldName] . "]"; $array_graphInfo = $Array['title'] . "[" . date("Y-m-d H:i:s") . "] " . $common_html['common_html']['totalrecords'] . ": " . $TotalNumberIndex; if ($sum_index != "") { $array_graphInfo .= " " . $common_html['common_html']['allnumbers'] . ": " . $TotalSumIndex . " " . $UserUnitFunctionIndex . "\n"; } $Array['graphInfo'] = $array_graphInfo; //print_R($FlashFileName); //本表操作部分--FALSH图表显示部分--显示FLASH图表的结果 table_begin("650"); $ChartMode = $showlistfieldtypeArray[$k]; //采用的图表类型选择 //print $tablename; switch ($ChartMode) { case 'vBarF': $FlashFileName = WriteXmlFilevBarF($Array, $tablename, $k); //Flash XML 数据写入文件区 $create_chart = create_chart("vBarF", $FlashFileName); //FLASH 图表读入XML数据处理以后的显示区 break; case 'hBarF': $FlashFileName = WriteXmlFilehBarF($Array, $tablename, $k); //Flash XML 数据写入文件区 $create_chart = create_chart("hBarF", $FlashFileName); //FLASH 图表读入XML数据处理以后的显示区 break; case 'pieF': $FlashFileName = WriteXmlFilePieF($Array, $tablename, $k); //Flash XML 数据写入文件区 $create_chart = create_chart("pieF", $FlashFileName); //FLASH 图表读入XML数据处理以后的显示区 break; default: $FlashFileName = WriteXmlFilevBarF($Array, $tablename, $k); //Flash XML 数据写入文件区 $create_chart = create_chart("vBarF", $FlashFileName); //FLASH 图表读入XML数据处理以后的显示区 break; } //HTML文体显示部分 print "<TR class=TableData>"; print "<TD noWrap width=100% align=center colspan=40>"; print "{$create_chart} </TD>"; print "</TR>"; //本文信息显示部分 //print_title($html_etc[$tablename][$tabletitle]."<font color=green>[".$html_etc[$tablename][$fieldName]."]</font>",40); print_title($html_etc[$tablename][$tabletitle] . "[" . $html_etc[$tablename][$fieldName] . "]", 6); for ($i = 0; $i < sizeof($rs_array); $i++) { $ResultNumber = $rs_array[$i][num]; $ResultSum = $rs_array[$i][sum]; $ResultFieldCode = $rs_array[$i][$fieldName]; $ResultFieldName = returntablefield($tablenameIndex, $WhatIndex, $ResultFieldCode, $ReturnIndex); if ($ResultFieldName == "") { $ResultFieldName = $ResultFieldCode; } print "<TR class=TableData>"; print "<TD noWrap width=15%>统计类别名称 </TD>"; print "<TD width=35%>" . $ResultFieldName . " </TD>"; if ($sum_index != "") { print "<TD noWrap width=15%>统计额度 </TD>"; print "<TD noWrap width=10%><font color=red>" . $ResultSum . " " . $UserUnitFunctionIndex . "</font></TD>"; } else { //print "<TD noWrap width=15%>统计类别代码 </TD>"; //print "<TD noWrap width=10%>".$ResultFieldCode." </TD>"; } print "<TD width=15%>统计记录数 </TD>"; print "<TD noWrap width=10%><font color=red>" . $ResultNumber . " 条</font></TD>"; print "</TR>"; } print "<TR class=TableData>"; print "<TD noWrap colspan = 40>\n"; print $common_html['common_html']['totalrecords'] . ": <font color=red>{$TotalNumberIndex} 条</font>\n"; if ($sum_index != "") { print $common_html['common_html']['allnumbers'] . ": <font color=red>{$TotalSumIndex} " . $UserUnitFunctionIndex . "</font>\n"; } print "</TD>"; print "</TR>"; table_end(); print "<BR>"; break; } } }
function StockOutToStore($Rowid, $flowState) { global $db; if ($Rowid == "") { exit; } $MainTable = "stockoutmain"; $DetailTable = "stockoutdetail"; $sql = "select * from {$MainTable} where ROWID='{$Rowid}'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); //print_R($rs_a); $tabledate = $rs_a[0]['tabledate']; $stockid = $rs_a[0]['stockid']; $stockiplaceid = $rs_a[0]['stockiplaceid']; $supplyid = $rs_a[0]['supplyid']; $tablecode = $rs_a[0]['tablecode']; $sql = "select * from {$DetailTable} where mainrowid='{$Rowid}'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); //print_R($rs_a); $stockinpersion = $SUNSHINE_USER_NAME; $Columns = returntablecolumn($DetailTable); for ($i = 0; $i < sizeof($rs_a); $i++) { for ($j = 0; $j < sizeof($Columns); $j++) { $Element = $Columns[$j]; ${$Element} = $rs_a[$i][$Element]; } $plannum == "" ? $plannum = 0 : ''; //第一:把入库单据转换为库存 //INSERT INTO `store` ( `productid` , `stocknum` , `storemaxnum` , `storeminnum` , `storesign` , `signtype` , `ROWID` , `mobilesign` , `stock` , `standard` , `mode` , `freenum` , `allnum` , `price` , `amt` ) //VALUES ( //'', '0', '', '', '', '0', '', '0', '', '', '', '0', '0', '0', '0' //); $sql = "select stocknum,ROWID from store where productid='{$productid}'"; $rss = $db->Execute($sql); $rss_a = $rss->GetArray(); //print $rss_a[0]['NUM'];exit; $allnum = $rss_a[0]['stocknum']; if ($rss_a[0]['ROWID'] != "") { $sql = "update store set stocknum = stocknum - {$plannum} , allnum = allnum - {$plannum}, standard='{$standard}' , mode='{$mode}' ,price='{$price}' where productid='{$productid}'"; } //else { //$sql = "INSERT INTO `store` ( `productid` , `stocknum` , `storemaxnum` , `storeminnum` , `storesign` , `signtype` , `ROWID` , `mobilesign` , `stock` , `standard` , `mode` , `freenum` , `allnum` , `price` , `amt` ) //VALUES ( '$productid' , '$plannum' , '$storemaxnum' , '$storeminnum' , '$storesign' , '$stockintype' , '' , '$mobilesign' , '$stockid' , '$standard' , '$mode' , '$freenum' , '$allnum' , '$price' , '$storeamt' ); //"; //} if ($flowState == "1") { $db->Execute($sql); ////print $sql."<HR>"; } else { if ($flowState == "-1") { $sql = "update store set stocknum = stocknum + {$plannum} , allnum = allnum + {$plannum} , standard='{$standard}' , mode='{$mode}' ,price='{$price}' where productid='{$productid}'"; $db->Execute($sql); ////print $sql."<HR>"; } } //完成库存数量更新部分 //stockoutmain : tablecode tabledate stockoutpersion stockoutsign stockouttype userexplian stockpersion stockid stockiplaceid stockstate ROWID fillindate state exampersion supplyid user_id amt sellmess sellmobile outmess outmobile outtype flowState payamt factpayamt isfax issend sellman payment chinaAmt sendAmt rebate noFaxAmt fromRowId fromModuleId datascope invoice customerPO fromModuleId2 fromRowId2 tableNo //stockoutdetail : stockoutcode receivecode ordercode productid plannum stockoutfactnum price money profitmoney costmoney stockoutdetailsign ROWID state stockouttype toreturn user_id mainrowid standard mode freenum allnum storenum //第二:把入库单据转换为库存明细 $storeamt = $plannum * $price; $sql = "INSERT INTO `storedetail` ( \n\t\t\t`productid` , `stockinfactnum` , `storefactnum` , `stockoutfactnum` ,\n\t\t\t`stockincode` , `stockoutcode` , `storedetailsign` , `signtype` ,\n\t\t\t`ROWID` , `storecode` , `stockinfactprice` , `stockinpersion` ,\n\t\t\t`stockinmaincode` , `stockindate` , `user_id` , `stock` , \n\t\t\t`stockplace` , `standard` , `mode` , `exchrowid` , \n\t\t\t`freenum` , `allnum` , `storeamt` ) \n\t\t\tVALUES (\n\t\t\t'{$productid}' , '{$plannum}' , '{$allnum}' , '{$stockoutfactnum}' ,\n\t\t\t'{$stockincode}' , '{$tablecode}' , '{$stockoutdetailsign}' , '{$stockouttype}' ,\n\t\t\t'' , '{$storecode}' , '{$price}' , '{$stockinpersion}' ,\n\t\t\t'{$Rowid}' , '{$tabledate}' , '{$user_id}' , '{$stockid}' , \n\t\t\t'{$stockiplaceid}' , '{$standard}' , '{$mode}' , '{$exchrowid}' , \n\t\t\t'{$freenum}' , '{$allnum}' , '{$storeamt}' \n\t\t);\n\t\t"; if ($flowState == "1") { $db->Execute($sql); ////print $sql."<HR>"; } } $sql = "delete from storedetail where stockoutcode='{$tablecode}'"; if ($flowState == "-1") { $db->Execute($sql); ////print $sql."<HR>"; } }
function viewChildTableList($subtable, $parent_value) { global $db; $maintable_key = $subtable['maintable_key']; $table_title = $subtable['subtable_title']; $tablename2 = $subtable['subtable_name']; $childkey2 = $subtable['subtable_key']; $where2 = $subtable['subtable_where']; $where2 = str_replace("(", "(", $where2); $where2 = str_replace(")", ")", $where2); $showlistfieldlist2 = $subtable['subtable_showlistfieldlist']; $columns2 = returntablecolumn($tablename2); $html_etc2 = returnsystemlang($tablename2); $showlistfieldlistArray2 = explode(",", $showlistfieldlist2); $iniFilename = "Model/" . $tablename2 . "_newai.ini"; if (!file_exists($iniFilename)) { $iniFilename = "../JXC/Model/" . $tablename2 . "_newai.ini"; } if (!file_exists($iniFilename)) { $iniFilename = "../CRM/Model/" . $tablename2 . "_newai.ini"; } if (!file_exists($iniFilename)) { $iniFilename = "../Framework/Model/" . $tablename2 . "_newai.ini"; } $file_ini2 = parse_ini_file($iniFilename, true); $org_showlistfieldlist = explode(",", $file_ini2['view_default']['showlistfieldlist']); $org_showlistfieldfilter = explode(",", $file_ini2['view_default']['showlistfieldfilter']); $showlistfieldfilterArray2 = array(); for ($i = 0; $i < sizeof($org_showlistfieldlist); $i++) { if (in_array($org_showlistfieldlist[$i], $showlistfieldlistArray2)) { $showlistfieldfilterArray2[$org_showlistfieldlist[$i]] = $org_showlistfieldfilter[$i]; } } //构建SQL语句 $SQLText = ""; for ($i = 0; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; if ($SQLText != "") { $SQLText .= ","; } $SQLText .= $listIndexName; } if (is_array($parent_value)) { $childkey2Array = explode(",", $childkey2); $mainkey2Array = explode(",", $maintable_key); $SQL_Select = "select {$SQLText} from {$tablename2} where 1=1 "; $i = 0; foreach ($mainkey2Array as $row) { $SQL_Select = $SQL_Select . "and " . $childkey2Array[$i] . "='" . $parent_value[$row] . "' "; $i++; } } else { $SQL_Select = "select {$SQLText} from {$tablename2} where {$childkey2} = '" . $parent_value . "'"; } if ($where2 != '') { $where2 = str_replace(":", "=", $where2); $where2 = str_replace("\\", "", $where2); $SQL_Select .= " and " . $where2; } $rs = $db->Execute($SQL_Select); $rs_a = $rs->GetArray(); //print_R($rs_a);print_R($showlistfieldlistArray2); print "<tr ><td colspan=6 nowrap width=100%>\n"; table_begin("100%"); //标题显示部分 if ($table_title != "") { $url_filename = $tablename2 . "_newai.php"; if (file_exists("../JXC/" . $url_filename)) { $url_filename = "../JXC/" . $url_filename; } else { if (file_exists("../CRM/" . $url_filename)) { $url_filename = "../CRM/" . $url_filename; } else { $url_filename = ""; } } if ($url_filename != '') { $table_title = "<a href='{$url_filename}' target='_blank'>{$table_title}</a>"; } print "<tr><td class=TableHeader align=center colspan=" . sizeof($showlistfieldlistArray2) . ">{$table_title}</td></tr>"; } print "<tr class=TableContent>\n"; for ($i = 0; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; $listFilter = $showlistfieldfilterArray2[$listIndex]; $listFilterArray = explode(":", $listFilter); if (stristr($listFilterArray[0], "tablefilter") && $listFilterArray[1] == $tablename2) { $TempColumns = returntablecolumn($listFilterArray[1]); $showText = $html_etc2[$tablename2][$TempColumns[$listFilterArray[3]]]; } else { $showText = $html_etc2[$tablename2][$listIndexName]; } print "<td nowrap>" . $showText . "</td>"; } print "</tr>"; $allnum = array(); $allmoney = array(); //数据窗口部分 for ($j = 0; $j < sizeof($rs_a); $j++) { print "<tr class=TableData>\n"; for ($i = 0; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; $listFilter = $showlistfieldfilterArray2[$listIndex]; //数据过滤区 $listFilterArray = explode(":", $listFilter); if (stristr($listFilterArray[0], 'color')) { $hascolor = true; } else { $hascolor = false; } $nowrap = ""; if (strlen($rs_a[$j][$listIndexName]) < 20) { $nowrap = "nowrap"; } switch ($listFilterArray[0]) { case 'tablefilter': case 'tablefiltercolor': $TempColumns = returntablecolumn($listFilterArray[1]); $DataElement = returntablefieldColorFilterGray($listFilterArray[1], $TempColumns[(string) $listFilterArray[2]], $rs_a[$j][$listIndexName], $TempColumns[(string) $listFilterArray[3]], '', '', '', $hascolor); break; case 'radiofilter': $TempColumns = returntablecolumn($listFilterArray[1]); $DataElement = returntablefield($listFilterArray[1], $TempColumns[(string) $listFilterArray[2]], $rs_a[$j][$listIndexName], $TempColumns[(string) $listFilterArray[3]]); break; case 'radiofiltergroup': $TempColumns = returntablecolumn($listFilterArray[1]); $DataElement = returntablefield($listFilterArray[1], $TempColumns[(string) $listFilterArray[2]], $rs_a[$j][$listIndexName], $TempColumns[(string) $listFilterArray[3]]); break; case 'select_sex': $DataElement = returnsex($rs_a[$j][$listIndexName]); break; case 'boolean': $DataElement = returnboolean($rs_a[$j][$listIndexName]); break; case 'datetime': if ($rs_a[$j][$listIndexName] == '0000-00-00 00:00:00') { $DataElement = ''; } else { $DataElement = $rs_a[$j][$listIndexName]; } break; /* case 'input': $DataElement=cutStr($rs_a[$j][$listIndexName],15); if($DataElement!=$rs_a[$j][$listIndexName]) $DataElement="<span title='".$rs_a[$j][$listIndexName]."'>".$DataElement."..</span>"; else $DataElement = $rs_a[$j][$listIndexName]; break; case 'textarea': if(cutStr($rs_a[$j][$listIndexName],30)!=$rs_a[$j][$listIndexName]) $DataElement = "<div title='".$rs_a[$j][$listIndexName]."'>".cutStr($rs_a[$j][$listIndexName],30)."...</div>"; else $DataElement = $rs_a[$j][$listIndexName]; break; */ /* case 'input': $DataElement=cutStr($rs_a[$j][$listIndexName],15); if($DataElement!=$rs_a[$j][$listIndexName]) $DataElement="<span title='".$rs_a[$j][$listIndexName]."'>".$DataElement."..</span>"; else $DataElement = $rs_a[$j][$listIndexName]; break; case 'textarea': if(cutStr($rs_a[$j][$listIndexName],30)!=$rs_a[$j][$listIndexName]) $DataElement = "<div title='".$rs_a[$j][$listIndexName]."'>".cutStr($rs_a[$j][$listIndexName],30)."...</div>"; else $DataElement = $rs_a[$j][$listIndexName]; break; */ case 'qq': $DataElement = !empty($rs_a[$j][$listIndexName]) ? "<a target=\"_blank\" href=\"http://wpa.qq.com/msgrd?v=3&uin=" . $rs_a[$j][$listIndexName] . "&site=qq&menu=yes\"><img border=\"0\" src=\"http://wpa.qq.com/pa?p=2:" . $rs_a[$j][$listIndexName] . ":45\" onerror=\"this.src='" . ROOT_DIR . "general/ERP/Framework/images/help3.gif';this.title='此QQ号码可能不存在'\" title=\"点击这里发消息\">" . $rs_a[$j][$listIndexName] . "</a>" : ''; break; case 'mobile': $addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0348.gif' title='点击号码发送短信'>"; if ($rs_a[$j][$listIndexName] != '') { $DataElement = "<a href='../JXC/sms_sendlist_newai.php?" . base64_encode("action=add_default&sendlist=" . $rs_a[$j][$listIndexName]) . "' target='_blank'>" . $addicon . $rs_a[$j][$listIndexName] . "</a>"; } else { $DataElement = $rs_a[$j][$listIndexName]; } break; case 'email': $linkman = ''; $fromsrc = ''; if ($tablename2 == 'linkman') { $fromsrc = 'customer'; $linkman = gettablefield($tablename2, 'email', 'rowid', $rs_a[$j][$listIndexName]); } else { if ($tablename2 == 'supplylinkman') { $fromsrc = 'supply'; $linkman = gettablefield($tablename2, 'email', 'rowid', $rs_a[$j][$listIndexName]); } else { $linkman = $rs_a[$j][$listIndexName]; $fromsrc = ''; } } $addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0037.gif' title='点击链接发送邮件'>"; if ($rs_a[$j][$listIndexName] != '') { $DataElement = "<a href='../CRM/email_newai.php?" . base64_encode("action=add_default&sendlist=" . $linkman . "&fromsrc=" . $fromsrc) . "' target='_blank' >" . $addicon . $rs_a[$j][$listIndexName] . "</a>"; } break; case 'picturefile': global $ifincludemaginfier; $PicturePath = $rs_a[$j][$listIndexName]; if ($PicturePath != "" && strlen($PicturePath) > 10) { if (!$ifincludemaginfier) { print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>"; print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.magnifier.js\"></script>"; $ifincludemaginfier = true; } $DataElement = "<img src='" . $PicturePath . "' width=32 class=\"magnify\" data-magnifyto=\"500\" onmouseover=\"this.style.cursor='pointer';this.style.cursor='hand'\" onmouseout=\"this.style.cursor='default'\">"; //$file_path="<a href='$PicturePath'><img src='".$PicturePath."' border=0 width=120></a>"; } else { $DataElement = ""; } break; case 'userdefine': $functionName = trim($listFilterArray[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)) { $DataElement = $functionName($rs_a[$j][$listIndexName], $rs_a, $j); } } else { $DataElement = $rs_a[$j][$listIndexName]; } break; case 'tdoafile': require_once 'lib/utility_file.php'; //形成通达OA下载文件所需要的变量格式 $var_value_array = explode('||', $rs_a[$j][$listIndexName]); $ATTACHMENT_ID = $var_value_array[1]; $ATTACHMENT_NAME = $var_value_array[0]; if (strlen($rs_a[$j][$listIndexName]) < 3) { $file_path = "无附件"; } else { $file_path = attach_link($ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 0, 0, 1, 1, 0); } //print_R($ATTACHMENT_NAME);exit; print "<script src=\"../../Enginee/lib/attach.js\"></script>"; print "\n\t\t\t\t\t<input type=\"hidden\" name=\"ATTACHMENT_ID_OLD\" value=\"{$ATTACHMENT_ID}\">\n\t\t\t\t\t<input type=\"hidden\" name=\"ATTACHMENT_NAME_OLD\" value=\"{$ATTACHMENT_NAME}\">"; $DataElement = $file_path; break; default: $DataElement = $rs_a[$j][$listIndexName]; break; } if ($listIndexName == 'zhekou') { $DataElement = $DataElement * 100 . "%"; } $tip = ''; if ((stristr($tablename2, "detail") || $tablename2 == "store_product") && $listIndexName == 'num') { $tablename3 = $tablename2 . "_color"; if ($tablename2 == "store_product") { $tablename3 = "store_color"; } $sql = "SELECT COUNT(*) as allnum FROM information_schema.TABLES WHERE TABLE_NAME='{$tablename3}'"; $rs = $db->Execute($sql); if ($rs->fields['allnum'] == 1) { $sql = "select id,{$SQLText} from {$tablename2} where {$childkey2} = '" . $parent_value . "'"; $rs = $db->Execute($sql); $rs_id = $rs->GetArray(); $id = $rs_id[$j][id]; $sql = "select a.num,b.name from {$tablename3} a inner join productcolor b on a.color=b.id where a.id={$id}"; $rs = $db->Execute($sql); $rs_color = $rs->GetArray(); foreach ($rs_color as $row) { $tip .= $row[name] . ":" . $row[num] . "\r\n"; } if ($tip != '') { $tip = " <span title='{$tip}'><img src='" . ROOT_DIR . "general/ERP/Framework/images/sepan.gif'></span>"; } } } print "<td {$nowrap}>" . $DataElement . $tip . "</td>"; if (stristr($html_etc2[$tablename2][$listIndexName], "数量")) { $allnum[$html_etc2[$tablename2][$listIndexName]] = $allnum[$html_etc2[$tablename2][$listIndexName]] + $rs_a[$j][$listIndexName]; } else { if (stristr($html_etc2[$tablename2][$listIndexName], "金额")) { $allmoney[$html_etc2[$tablename2][$listIndexName]] = $allmoney[$html_etc2[$tablename2][$listIndexName]] + $rs_a[$j][$listIndexName]; } } } print "</tr>"; } if (sizeof($allnum) > 0 || sizeof($allmoney) > 0) { print "<tr class=TableData><td align=center><b>合计</b></td>"; for ($i = 1; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; if (array_key_exists($html_etc2[$tablename2][$listIndexName], $allnum)) { print "<td nowrap>" . $allnum[$html_etc2[$tablename2][$listIndexName]] . "</td>"; } else { if (array_key_exists($html_etc2[$tablename2][$listIndexName], $allmoney)) { print "<td nowrap>" . $allmoney[$html_etc2[$tablename2][$listIndexName]] . "</td>"; } else { print "<td nowrap></td>"; } } } print "</tr>"; } if (sizeof($rs_a) == 0) { print "<tr class=TableData><td align=center nowrap colspan=" . sizeof($showlistfieldlistArray2) . "><font color=gray>无此项记录</font></td>"; print "</tr>"; } table_end(); print "</td></tr>"; }
</table> </div> <div id="dataId"> <?php $dataCount = sizeof($rs_a2); if ($dataCount == 0) { $rs_a2[0] = ""; $dataCount = 1; $MarkName = ""; } else { print "<input type=hidden name=dataDealMethod value=update>"; print "<input type=hidden name=updateDataMax value=" . $dataCount . ">"; print "<input type=hidden name=updateRowid value=" . $_GET['ROWID'] . ">"; } //print_R($rs_a2); $ChildColumns = returntablecolumn("stockoutdetail"); for ($i = 0; $i < sizeof($rs_a2); $i++) { $MarkID = $i + 1; $MarkName = "_" . $MarkID; $Element = $rs_a2[$i]; for ($childID = 0; $childID < sizeof($ChildColumns); $childID++) { $ColumnName = $ChildColumns[$childID]; ${$ColumnName} = $Element[$ColumnName]; } ?> <table width="95%" class="TableBlock"> <tr> <td nowrap width="40" align="center" class="TableContent"> <input type="hidden" name="dataNo" value="<?php echo $MarkID; ?>
function StockInToRefer($Rowid) { global $db; $tablecode = returntablefield("stockinmain", "ROWID", $Rowid, "tablecode"); ?> <link rel="stylesheet" type="text/css" href="<?php echo ROOT_DIR; ?> theme/3/style.css"> <html> <head> <title>入库退货管理窗口</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <script> function stockBack(num) { var backNum; var backNumStr="backnum"; var backAmtStr="backamt"; var countNum=0; var countAmt=0; for (i=1;i<=num;i++){ backNumStr="backnum"+i; //alert(backNumStr); backNum=document.all(backNumStr).value; //document.all(backNumStr).value if (backNum!=""&&backNum!=null){ countNum=countNum+parseFloat(backNum); } } if (countNum==0){ alert("请确定退货数量!"); return (false); } frm.flag.value="stockBack"; frm.submit(); } function checkNum(numNo) { var num1=document.frm("1"+numNo).value; var num2=document.frm("2"+numNo).value; var numIn=document.frm("backnum"+numNo).value; var numPrice=document.frm("backprice"+numNo).value; //alert("numPrice"+numPrice); // if (isNaN(backprice)){ //backprice=num2; //document.frm("backprice"+numNo).value=num2; //} var moduleId=document.frm("ModuleId").value; //alert("moduleId"+moduleId); if (moduleId=="S03"){ var stockNum=document.frm("stock_"+numNo).value; //alert("stockNum"+stockNum); if (stockNum<parseFloat(numIn)){ alert("退货数量大于该批次商品的库存数量"); document.frm("backamt"+numNo).value=""; document.frm("backnum"+numNo).value=""; return (false); } } //alert("numIn"+numIn); if (numIn!=""&&numIn!=null){ if (parseFloat(num1)<parseFloat(numIn)){ alert("退货数量大于提货数量"); document.frm("backamt"+numNo).value=""; document.frm("backnum"+numNo).value=""; return (false); }else{ var numIn=document.frm("backamt"+numNo).value=parseFloat(numIn)*parseFloat(numPrice); } } } var isNS4 = (navigator.appName=="Netscape")?1:0; function check_input_num(num_type) { if(num_type=="NUMBER") { if(!isNS4) { if((event.keyCode < 48 || event.keyCode > 57)&&event.keyCode != 46) event.returnValue = false; } else { if((event.which < 48 || event.which > 57)&&event.keyCode != 46) return false; } } else if(num_type=="MONEY") { if(!isNS4) { if((event.keyCode < 45 || event.keyCode > 57)&&event.keyCode != 47) event.returnValue = false; } else { if((event.which < 45 || event.which > 57)&&event.which != 47) return false; } } } </script> </head> <body class="bodycolor"> <div align="center"> <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small"> <tr> </td> </tr> </table> <form name="frm" action="?action=edit_default3_data&ROWID=<?php echo $Rowid; ?> " method="post"> <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3"> <tr align="left" > <td nowrap class="TableContent" colspan=8>入库单据号码:<?php echo $tablecode; ?> </td> </tr> <tr align="center" > <td nowrap class="TableHeader" >商品名称</td> <td nowrap class="TableHeader" >入库数量</td> <td nowrap class="TableHeader" >单价</td> <td nowrap class="TableHeader" >金额</td> <td nowrap class="TableHeader" >备注</td> <td nowrap class="TableHeader" >退货数量</td> <td nowrap class="TableHeader" >退货单价</td> <td nowrap class="TableHeader" >退货金额</td> </tr> <?php $sql = "select * from stockindetail where mainrowid='{$Rowid}'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); $Columns = returntablecolumn("stockindetail"); for ($i = 0; $i < sizeof($rs_a); $i++) { for ($j = 0; $j < sizeof($Columns); $j++) { $Element = $Columns[$j]; ${$Element} = $rs_a[$i][$Element]; } $productname = returntablefield("product", "productid", $productid, "productname"); $ii = $i + 1; $plannum_ALL += $plannum; $money_ALL += $money; ?> <tr class="TableLine1" id="TR<?php echo $ii; ?> " > <input type="hidden" name="productid<?php echo $ii; ?> " value="<?php echo $productid; ?> "> <td align="left" ><input readonly type="text" name="0<?php echo $ii; ?> " value="<?php echo $productname; ?> " size="10" maxlength="54" class="SmallInput2"></td> <td align="left" ><input readonly type="text" name="1<?php echo $ii; ?> " value="<?php echo $plannum; ?> " size="10" maxlength="54" class="SmallInput2"></td> <td align="right" ><input readonly type="text" name="2<?php echo $ii; ?> " value="<?php echo $price; ?> " size="10" maxlength="54" class="SmallInput2"></td> <td align="right" ><input readonly type="text" name="3<?php echo $ii; ?> " value="<?php echo $money; ?> " size="10" maxlength="54" class="SmallInput2"></td> <td align="left" ><input readonly type="text" name="4<?php echo $ii; ?> " value="<?php echo $stockindetailsign; ?> " size="10" maxlength="54" class="SmallInput2"></td> <td ><input type="text" name="backnum<?php echo $ii; ?> " size="10" maxlength="54" onblur="checkNum('<?php echo $ii; ?> ')" onkeypress="check_input_num('NUMBER')" class="SmallInput2"></td> <td ><input type="text" name="backprice<?php echo $ii; ?> " size="10" maxlength="54" onblur="checkNum('<?php echo $ii; ?> ')" onkeypress="check_input_num('NUMBER')" value="0" class="SmallInput2"></td> <td ><input type="text" readonly name="backamt<?php echo $ii; ?> " size="10" maxlength="54" class="SmallInput2"></td> </tr> <input type="hidden" name="ROWID_<?php echo $ii; ?> " value="<?php echo $ROWID; ?> "> <input type="hidden" name="stock_<?php echo $ii; ?> " value="<?php echo $plannum; ?> "> <?php } ?> <tr class="TableLine1" id="TR" style="cursor:pointer;"> <td class="TableHeader">合计</td> <td class="TableHeader" align="right"><?php echo $plannum_ALL; ?> </td> <td class="TableHeader" align="right"></td> <td class="TableHeader" align="right"><?php echo $money_ALL; ?> </td> <td class="TableHeader" align="left"> </td> <td class="TableHeader" align="left" > </td> <td class="TableHeader" align="left"> </td> <td class="TableHeader" align="left" > </td> </tr> </table> <input type="hidden" name="rowid" value="<?php echo $Rowid; ?> "> <input type="hidden" name="num" value="<?php echo sizeof($rs_a); ?> "> <input type="hidden" name="ModuleId" value="S03"> <input type="hidden" name="flag"> </form> <br> <input type="button" name="close" id="close" class="SmallButton" value="保存" onClick="javascript:stockBack('<?php echo sizeof($rs_a); ?> ');"> <INPUT class=SmallButton id=close onclick=javascript:history.back(); type=button value=返回 name=close> </body> </html> <?php }
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>"; } //子目录列表结束 //############################################################################## }
if (isset($sellone_columns[$val]) && isset($page_foot_fields[$sellone_columns[$val]])) { $page_foot_fields[$sellone_columns[$val]]['filter'] = $showlistfieldfilter[$key]; } } //过滤后的值 foreach ($page_foot_fields as $key => $val) { $filterArray = explode(":", $val['filter']); if ($filterArray[0] == "tablefilter" || $filterArray[0] == "tablefiltercolor") { $relationTable_columns = returntablecolumn($filterArray[1]); $page_foot_fields[$key]['value'] = returntablefield($filterArray[1], $relationTable_columns[$filterArray[2]], $page_foot_fields[$key]['value'], $relationTable_columns[$filterArray[3]]); } } foreach ($page_head_fields as $key => $val) { $filterArray = explode(":", $val['filter']); if ($filterArray[0] == "tablefilter" || $filterArray[0] == "tablefiltercolor") { $relationTable_columns = returntablecolumn($filterArray[1]); $page_head_fields[$key]['value'] = returntablefield($filterArray[1], $relationTable_columns[$filterArray[2]], $page_head_fields[$key]['value'], $relationTable_columns[$filterArray[3]]); } } //输出表头 echo "<div id='head'><table border=0 style='width:" . ($print_paper_width - 9) . "mm;margin:0;padding:0;font-size:12px;'>\n\t<tr><td colspan=2 align=center><H2>" . $page_head_fields['billid']['value'] . "</H2></td></tr>"; foreach ($page_head_fields as $key => $val) { if ($key == "billid") { continue; } echo "<tr><td nowrap valign=top width=20%>" . $val['name'] . ":</td><td valign=top>" . $val['value'] . "</td></tr>"; } echo "</table></div>"; //单据明细表头 $page_main_fields = array(); foreach ($sell_order_detail_field_config as $key => $val) {
require_once 'newai.php'; newai_tree(); break; case 'framework': $tablename = $file_ini[$action]['tablename']; $SYTEM_CONFIG_TABLE != "" ? $tablename = $SYTEM_CONFIG_TABLE : ''; $columns = returntablecolumn($tablename); $html_etc = returnsystemlang($tablename, $SYTEM_CONFIG_TABLE); $menu_top = $file_ini[$action]['menu_top']; $primary = $file_ini[$action]['primary']; project_framework($mode = 'project_framework'); break; case 'menutop': $tablename = $file_ini[$action]['tablename']; $SYTEM_CONFIG_TABLE != "" ? $tablename = $SYTEM_CONFIG_TABLE : ''; $columns = returntablecolumn($tablename); $html_etc = returnsystemlang($tablename, $SYTEM_CONFIG_TABLE); $menu_top = $file_ini[$action]['menu_top']; $primary = $file_ini[$action]['primary']; project_framework($mode = 'project_fw_menu'); break; } $ExecTimeEnd = getmicrotime(); $ExecTime = $ExecTimeEnd - $ExecTimeBegin; //print substr($ExecTime,0,8)." S"; $PHP_SELF_ARRAY = explode('/', $_SERVER['PHP_SELF']); $PHP_SELF_TEXT = array_pop($PHP_SELF_ARRAY); //print "<a href='StudentFileNew.php?dir=.&editfile=$PHP_SELF_TEXT&n=1' class=OrgAdd target=_blank>$PHP_SELF_TEXT</a>"; //注册提示 @(require_once "lib/version.php"); //定义显示文本
print "<script>\n\t\tfunction SetParentValue()\t{\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value ='" . $_GET['sectionName'] . "';\n\t\t\t//parent.window.form1." . $_GET['parentName'] . ".value = " . $_GET['sectionName'] . ";\n\t\t}\n\t\tfunction SetParentValue2()\t{\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value ='" . $_GET['sectionName'] . "';\n\t\t\twindow.opener =window.self;\n\t\t\twindow.close();\n\t\t}\n\t\tfunction SetParentValue_UserDefine(ParaUserDefine)\t{\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value = 'userdefine:'+ParaUserDefine;\n\t\t\twindow.opener =window.self;\n\t\t\twindow.close();\n\t\t}\n\t\tfunction SetParentValue_define(ReturnText)\t{\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value = ReturnText;\n\t\t\twindow.opener =window.self;\n\t\t\twindow.close();\n\t\t}\n\t\t</script>"; print "<BR><BR><div align=center><input type=Button class=SmallButton name=inputSelect onclick='SetParentValue();' value='点击确定'> <input type=Button class=SmallButton name=inputSelect onclick='SetParentValue2();' value='确定并关闭'></div>"; break; case 'userdefine': print "<script>\n\t\tfunction SetParentValue_UserDefine(ParaUserDefine)\t{\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value = 'userdefine:'+ParaUserDefine;\n\t\t\twindow.opener =window.self;\n\t\t\twindow.close();\n\t\t}\n\t\t</script>"; break; case 'select_input': $filter = 'select_input'; case 'radiofilter': $filter = 'radiofilter'; case 'tablefilter': $filter == "" ? $filter = "tablefilter" : ""; print "<script>\n\t\tfunction LoadSection()\t{\n\t\t\tvar InputSelectName = \"\";\n\t\t\tInputSelectName = document.form1.inputName.value;\n\t\t\tURL=\"?action=" . $_GET['action'] . "§ionName=" . $_GET['sectionName'] . "&parentName=" . $_GET['parentName'] . "&Tablename=\"+InputSelectName+\"\";\n\t\t\tlocation = URL;\n\t\t}\n\t\tfunction SetParentValue()\t{\n\t\t\tvar SelectName = document.form1.SelectName.options[document.form1.SelectName.selectedIndex].value;\n\t\t\tvar SelectValue = document.form1.SelectValue.options[document.form1.SelectValue.selectedIndex].value;\n\t\t\tvar ReturnText = \"{$filter}:" . $_GET['Tablename'] . ":\"+SelectValue+\":\"+SelectName;\n\t\t\t//Text.innerHTML = ReturnText;\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value = ReturnText;\n\t\t}\n\t\tfunction SetParentValue2()\t{\n\t\t\tvar parent_window = parent.dialogArguments;\n\n\t\t\tvar SelectName = document.form1.SelectName.options[document.form1.SelectName.selectedIndex].value;\n\t\t\tvar SelectValue = document.form1.SelectValue.options[document.form1.SelectValue.selectedIndex].value;\n\t\t\tvar ReturnText = \"{$filter}:" . $_GET['Tablename'] . ":\"+SelectValue+\":\"+SelectName;\n\t\t\t//Text.innerHTML = ReturnText;\n\n\t\t\tparent_window.form1." . $_GET['parentName'] . ".value = ReturnText;\n\t\t\twindow.opener =window.self;\n\t\t\twindow.close();\n\t\t}\n\n\t\t</script>"; print "输入需要关连的表名:<input type=text class=SmallInput name=inputName size=15\n\t\tonkeydown=\"if(event.keyCode==13) event.keyCode=9\" value='" . $_GET['Tablename'] . "'> <input type=Button class=SmallButton name=inputSelect onclick='LoadSection();'\n\t\tvalue='选择'>"; if ($_GET['Tablename'] != "") { $columns = returntablecolumn($_GET['Tablename']); $html_etc = returnsystemlang($_GET['Tablename']); print "<BR><BR>菜单显示名:"; print "<select class=\"SmallSelect\" name=\"SelectName\" onkeydown=\"if(event.keyCode==13)event.keyCode=9\" >\n"; for ($i = 0; $i < sizeof($columns); $i++) { print "<option value=\"{$i}\" {$temp}>" . $html_etc[(string) $_GET['Tablename']][(string) $columns[$i]] . "[" . $columns[$i] . "]</option>\n"; $temp = ''; } print "</select>\n"; print "<BR><BR>菜单显示值:"; print "<select class=\"SmallSelect\" name=\"SelectValue\" onkeydown=\"if(event.keyCode==13)event.keyCode=9\" >\n"; for ($i = 0; $i < sizeof($columns); $i++) { print "<option value=\"{$i}\" {$temp}>" . $html_etc[(string) $_GET['Tablename']][(string) $columns[$i]] . "[" . $columns[$i] . "]</option>\n"; $temp = ''; } print "</select>\n";
function StockInToStore($Rowid, $flowState) { global $db; if ($Rowid == "") { exit; } $MainTable = "stockinmain"; $DetailTable = "stockindetail"; $sql = "select * from {$MainTable} where ROWID='{$Rowid}'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); //print_R($rs_a); $tabledate = $rs_a[0]['tabledate']; $stockid = $rs_a[0]['stockid']; $stockiplaceid = $rs_a[0]['stockiplaceid']; $supplyid = $rs_a[0]['supplyid']; $tablecode = $rs_a[0]['tablecode']; $sql = "select * from {$DetailTable} where mainrowid='{$Rowid}'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); //print_R($rs_a); $stockinpersion = $SUNSHINE_USER_NAME; $Columns = returntablecolumn($DetailTable); for ($i = 0; $i < sizeof($rs_a); $i++) { for ($j = 0; $j < sizeof($Columns); $j++) { $Element = $Columns[$j]; ${$Element} = $rs_a[$i][$Element]; } $plannum == "" ? $plannum = 0 : ''; //print_R($Columns); //第一:把入库单据转换为库存 //INSERT INTO `store` ( `productid` , `stocknum` , `storemaxnum` , `storeminnum` , `storesign` , `signtype` , `ROWID` , `mobilesign` , `stock` , `standard` , `mode` , `freenum` , `allnum` , `price` , `amt` ) //VALUES ( //'', '0', '', '', '', '0', '', '0', '', '', '', '0', '0', '0', '0' //); $sql = "select stocknum,ROWID from store where productid='{$productid}'"; $rss = $db->Execute($sql); $rss_a = $rss->GetArray(); //print $rss_a[0]['NUM'];exit; $allnum = $rss_a[0]['stocknum']; if ($rss_a[0]['ROWID'] != "") { $sql = "update store set stocknum = stocknum + {$plannum}, allnum = allnum + {$plannum} , standard='{$standard}' , mode='{$mode}' ,price='{$price}' where productid='{$productid}'"; } else { $sql = "INSERT INTO `store` ( `productid` , `stocknum` , `storemaxnum` , `storeminnum` , `storesign` , `signtype` , `ROWID` , `mobilesign` , `stock` , `standard` , `mode` , `freenum` , `allnum` , `price` , `amt` ) \n\t\t\tVALUES ( '{$productid}' , '{$plannum}' , '{$storemaxnum}' , '{$storeminnum}' , '{$storesign}' , '{$stockintype}' , '' , '{$mobilesign}' , '{$stockid}' , '{$standard}' , '{$mode}' , '{$freenum}' , '{$allnum}' , '{$price}' , '{$storeamt}' );\n\t\t\t"; } if ($flowState == "1") { $db->Execute($sql); ////print $sql."<HR>"; } else { if ($flowState == "-1") { $sql = "update store set stocknum = stocknum - {$plannum}, allnum = allnum - {$plannum} , standard='{$standard}' , mode='{$mode}' ,price='{$price}' where productid='{$productid}'"; $db->Execute($sql); ////print $sql."<HR>"; } } //完成库存数量更新部分 //INSERT INTO `stockindetail` ( `stockincode` , `receivecode` , `ordercode` , `productid` , `plannum` , `stockinfactnum` , `price` , `money` , `stockindetailsign` , `ROWID` , `state` , `stockintype` , `toreturn` , `user_id` , `mainrowid` , `standard` , `mode` , `freenum` , `allnum` , `fromRowId` , `fromModuleId` , `storenum` ) //第二:把入库单据转换为库存明细 $storeamt = $plannum * $price; $sql = "INSERT INTO `storedetail` ( \n\t\t\t`productid` , `stockinfactnum` , `storefactnum` , `stockoutfactnum` ,\n\t\t\t`stockincode` , `stockoutcode` , `storedetailsign` , `signtype` ,\n\t\t\t`ROWID` , `storecode` , `stockinfactprice` , `stockinpersion` ,\n\t\t\t`stockinmaincode` , `stockindate` , `user_id` , `stock` , \n\t\t\t`stockplace` , `standard` , `mode` , `exchrowid` , \n\t\t\t`freenum` , `allnum` , `storeamt` ) \n\t\t\tVALUES (\n\t\t\t'{$productid}' , '{$plannum}' , '{$allnum}' , '{$stockoutfactnum}' ,\n\t\t\t'{$tablecode}' , '{$stockoutcode}' , '{$stockindetailsign}' , '{$stockintype}' ,\n\t\t\t'' , '{$storecode}' , '{$price}' , '{$stockinpersion}' ,\n\t\t\t'{$Rowid}' , '{$tabledate}' , '{$user_id}' , '{$stockid}' , \n\t\t\t'{$stockiplaceid}' , '{$standard}' , '{$mode}' , '{$exchrowid}' , \n\t\t\t'{$freenum}' , '{$allnum}' , '{$storeamt}' \n\t\t);\n\t\t"; if ($flowState == "1") { $db->Execute($sql); //print $sql."<HR>"; } } $sql = "delete from storedetail where stockincode='{$tablecode}'"; if ($flowState == "-1") { $db->Execute($sql); //print $sql."<HR>"; } //exit; }
function newaiinit_view($fields) { global $common_html, $html_etc; //print_R($html_etc); global $return_sql_line, $db; global $columns, $mark, $_GET; global $read_type, $edit_attribute; global $row_userpriv, $_SESSION, $SUNSHINE_USER_NAME_VAR; global $export_port_arrribute; global $sessionkey, $tabletitle; switch ($db->databaseType) { case 'mysql': case 'mssql': default: break; case 'oracle': $tabletitle = strtoupper($tabletitle); break; } //print_R($fields['value']); $row_element_counter_array = array("1", "2", "3", "4", "5", "6", "7", "8", "9", "0", "!", "@", "#", "\$", "%", "^", "&", "*", "(", ")", "[", "]", "{", "}", ";", ":"); global $departprivte; //用户角色级别权限判断 print $departprivte; if ($departprivte != "") { $departprivteSQLArray = array(); $departprivteArray = explode('::', $departprivte); for ($i = 0; $i < sizeof($departprivteArray); $i++) { $privText = $departprivteArray[$i]; $privTextArray = explode(':', $privText); switch ($privTextArray[0]) { case 'user': $ColumnIndex1 = $privTextArray[1]; $USER_NAME = $_SESSION[$SUNSHINE_USER_NAME_VAR]; $ColumnName1 = $columns[$ColumnIndex1]; break; } //end swtich } //end for } //-- $USER_ID = $_SESSION[$SUNSHINE_USER_NAME_VAR]; $row_userpriv_array = explode(':', $row_userpriv); $tablename = $fields['table']['name']; $SQL = $fields['sql']['SQL']; //print $tablename; print "<THEAD class=TableHeader>\n"; print "<TR><TD colspan=" . $fields['table']['colspan'] . " class=TableHeader> " . $html_etc[$tablename][$tabletitle] . "</TD></TR>"; print "<TR class=\"TableHeader\">\n"; global $bottom_element, $row_element; $bottom_array = explode(',', $bottom_element); $row_array = explode(',', $row_element); if ($export_port_arrribute != 'hidden') { //$linkurl="?action=export_default_data&sessionkey=$sessionkey&method=get&tablename=$tablename"; //$ondblclick_url="ondblclick=\"location='$linkurl'\""; //$linktext="<a href=\"$linkurl\" target=_blank><img alt=\"".$common_html['common_html']['exportdata']."\" src=\"images/arrow_up.gif\" border=0></a>"; //$linktext = "<img alt=\"".$common_html['common_html']['exportdata']."\" title = '".$common_html['common_html']['choose'].$common_html['common_html']['record']."' src=\"images/arrow_up.gif\" align=\"absmiddle\" border=0>"; } else { //$linktext="<img alt=\"".$common_html['common_html']['exportdata']."\" src=\"images/arrow_up.gif\" border=0>"; } $row_array[0] != "" || sizeof($bottom_array) > 1 ? print "<TD class=TableHeader noWrap align=middle {$ondblclick_url} title = '" . $common_html['common_html']['choose'] . $common_html['common_html']['record'] . "'>" . $common_html['common_html']['choose'] . "{$linktext}</TD>\n" : ''; $i = 0; $init = $_GET['action']; $init_array = explode('_', $init); $init = $init_array[0] . "_" . $init_array[1]; foreach ($fields['name'] as $list) { $fieldname = $fields['name'][$i]; $fieldfilter = $fields['filter'][$i]; $i++; $doubletime = $_GET['doubletime'] + 1; //$_GET['action'] = $init; $return = FormPageAction("ordername", $list, "doubletime", $doubletime); $ondblclick = "ondblclick=\"location='?{$return}'\""; //判断是否要进行字段进行排序 无排序时则不显示双击事件 global $NEWAIINIT_VALUE_SYSTEM; if (strlen($NEWAIINIT_VALUE_SYSTEM) > 10) { $ondblclick = ""; } //print $ondblclick; //print $fieldfilter; //判断字段类型情况,定义是否显示双击事件 if ($fieldfilter == "ajaxinputhidden") { //$ondblclick = ""; } if ($fieldfilter == "nowshow" || $fieldfilter == "notshow") { continue; } $inputtext = $fields['INPUT_TEXT'][$fieldname]; $inputsize = $fields['inputsize'][$fieldname]; if ($inputtext == "private") { $grade = str_split($inputsize); if (!in_array($_SESSION['LOGIN_USER_PRIV'], $grade)) { continue; } } print "<TD noWrap class=TableHeader align=middle {$ondblclick} title=\"" . $common_html['common_html']['dbclick'] . "" . $common_html['common_html']['order'] . " : " . $html_etc[$tablename][$fieldname] . "\">" . $html_etc[$tablename][$list] . "\n"; //判断是否要进行字段进行排序 无排序时则不显示相应图片 global $NEWAIINIT_VALUE_SYSTEM; if (strlen($NEWAIINIT_VALUE_SYSTEM) > 10) { } else { $ordername = $_GET['ordername']; //&&$ordername==$fieldname //print_R($_GET); if ($fieldname == $ordername) { if ($doubletime % 2 == 0 && $doubletime > 1) { print "<a href=\"?{$return}\"><img alt=\"" . $common_html['common_html']['order'] . " : " . $html_etc[$tablename][$fieldname] . "\" src=\"images/arrow_down.gif\" border=0></a>\n"; } else { if ($doubletime % 2 == 1 && $doubletime > 1) { print "<a href=\"?{$return}\"><img alt=\"" . $common_html['common_html']['order'] . " : " . $html_etc[$tablename][$fieldname] . "\" src=\"images/arrow_up.gif\" border=0></a>\n"; } } } } print "</td>"; } //选择部分HEADER部分显示的控制 if ($row_array[0] != "") { //显示表格中最后一列中的‘操作’ by cwf print "<TD noWrap class=TableHeader align=middle>" . $common_html['common_html']['operation'] . "</TD>\n"; } print "</TR>"; print "</THEAD>"; //-- group begin global $group_user; isset($group_user) ? parent_group() : ''; //-- group end if ($read_type == 'read') { $disabled = 'disabled'; } $primarykey = $fields['table']['primarykey']; $primarykey_index = $columns[$primarykey]; //print $primarykey; $i = 1; global $row_element, $_GET; $row_array = explode(',', $row_element); //############################################################ //此部分设计为含子项目的模块设计,决定每项父目录点击之后进入子目录 //范式设计:传入参数:表名:联接方式 // global $child_filter; $child_filter_array = explode(":", $child_filter); if (sizeof($child_filter_array) == 3) { $child_tablename = $child_filter_array[1]; $child_columns = returntablecolumn($child_tablename); $child_filename = $child_tablename . "_newai.php"; $child_primarykey = $child_filter_array[0]; $child_primarykeyIndex = $columns[$child_primarykey]; $child_foreignkey = $child_filter_array[2]; $child_foreignkeyIndex = $child_columns[$child_foreignkey]; print "<SCRIPT>\n\t\tfunction JumpToDetail(Value)\t \t{\n\t\turl=\"" . $child_filename . "?" . $child_foreignkeyIndex . "=\"+Value;\n\t\tparent.Detail.location=url;\n\t\t}\n\t\t</SCRIPT>\n\t\t"; } else { } //############################################################ //此部分设计为权限部分设计:事业部总监和营销专员的的权限设计 $SYSTEM_FILTER_ARRAY = returnPrivateTwoInit(); $USER_PRIV_ID = $_SESSION['SUNSHINE_USER_PRIV']; $DEPT_INFOR = $_SESSION['SUNSHINE_USER_DEPT']; $USER_INFOR = $_SESSION['SUNSHINE_USER_NAME']; $RecordDEPT = $SYSTEM_FILTER_ARRAY['CheckFieldNameDEPT']; $RecordDEPT = $columns[$RecordDEPT]; $RecordUser = $SYSTEM_FILTER_ARRAY['CheckFieldNameUSER']; $RecordUser = $columns[$RecordUser]; //$USER_PRIV = returntablefield("user_priv","USER_PRIV",$USER_PRIV_ID,"PRIV_NO"); //print $USER_PRIV=6; //print_R("USER_PRIV:".$USER_PRIV); $row_element_counter = 0; //############################################################ //############################################################ //print_R($fields['value']); global $ondblclick_config; $ondblclick_config_array = explode(':', $ondblclick_config); foreach ($fields['value'] as $list) { $ondblclick_config = $ondblclick_config_array[0]; //得到原始的,没有过滤的各种字段的值 $list2 = $fields['value2'][$row_element_counter]; // var_dump($list2);//by cwf //原数据处理开始 $linkvalue = $fields['elementlink'][$i - 1][$primarykey_index]; if ($list[$primarykey_index] != '') { $linkvalue = $list2[$primarykey_index]; } //print $linkvalue; //判断是否要弹出窗口显示子表明细 $openWindowForChild = 0; switch ($ondblclick_config) { case 'init_view': default: $ondblclick = 'init_view'; $actionValue = explode("_", $_GET['action']); //创建一个子表的明细窗口 $child_table_name = $ondblclick_config_array[1]; $child_table_foreignkey = $ondblclick_config_array[2]; $child_table_foreignkey_backupfield = $ondblclick_config_array[3]; if ($child_table_name != "" && $child_table_foreignkey != "") { $actionValueText = "view" . $actionValueText; $child_columns_ = returntablecolumn($child_table_name); $child_columns_foreignkeyName = $child_columns_[$child_table_foreignkey]; $child_table_name_file = $child_table_name . "_newai.php"; //判断用户在自定义文件和表时的参数传递 if ($child_columns_foreignkeyName == "") { $child_columns_foreignkeyName = $child_table_foreignkey_backupfield; } $return = "action=init_default&{$child_columns_foreignkeyName}={$linkvalue}&action_close=close"; $return = base64_encode($return); $return = str_replace('==', '', $return); //$return = base64_encode($return); $openWindowForChild = 1; } else { $actionValueText = ""; for ($m = 1; $m < 2; $m++) { $actionValueText .= "_" . $actionValue[$m]; } $openWindowForChild = 0; $child_table_name_file = ""; $actionValueText = "view" . $actionValueText; $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, '', "selectid", ''); } break; case 'init_edit': $ondblclick = 'init_edit'; $actionValue = explode("_", $_GET['action']); $actionValueText = ""; for ($m = 1; $m < sizeof($actionValue); $m++) { $actionValueText .= "_" . $actionValue[$m]; } $actionValueText = "edit" . $actionValueText; $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, '', "selectid", ''); break; case 'init_project': $ondblclick = 'init_project'; $actionValue = explode("_", $_GET['action']); $actionValueText = ""; for ($m = 1; $m < sizeof($actionValue); $m++) { $actionValueText .= "_" . $actionValue[$m]; } $actionValueText = "project" . $actionValueText; $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, '', "selectid", ''); break; } //$return=returnpageaction($ondblclick,array('index_name'=>$primarykey_index,'index_id'=>$linkvalue,'index_name2'=>'selectid','index_id2'=>'')); //判断是双击进入还是双击弹出窗口 if ($openWindowForChild == "1") { $ondblclick_window = "window.open('" . $child_table_name_file . "?" . $return . "','Detail','height=450,width=800,status=yes,toolbar=yes,menubar=no,scrollbars=yes,resizable=yes,location=no')"; $ondblclick = "title='" . $common_html['common_html']['ondblclick'] . "' ondblclick=\"{$ondblclick_window}\""; //open("Webpage.asp?",Derek,"height=100,width=100,status=yes,toolbar=yes,menubar=no,location=no"); $ondblclick = $row_array[0] != "" ? $ondblclick : ''; $ondblclick_config != "" ? '' : ($ondblclick = ''); } else { $ondblclick = "ondblclick=\"location='{$child_table_name_file}?{$return}'\""; $ondblclick = $row_array[0] != "" ? $ondblclick : ''; $ondblclick_config != "" ? '' : ($ondblclick = ''); } //############################################################ //此部分设计为含子项目的模块设计,决定每项父目录点击之后进入子目录 if (sizeof($child_filter_array) > 1) { $onclick = " onClick=\"JumpToDetail(" . $list[$child_primarykeyIndex] . ");\""; } else { $onclick = ""; } //############################################################ //变量$SYSTEM_RECORD_EDIT_PRIV说明:控制EDIT、DELETE行记录行为 print_r($ColumnName1); if ($list2[$ColumnName1] != "" && $ColumnName1 != "") { if ($USER_NAME == $list2[$ColumnName1] || $USER_PRIV == 1 || $USER_PRIV == 2 || $USER_PRIV == 3) { // || $USER_PRIV==1 || $USER_PRIV==2 || $USER_PRIV==3 $SYSTEM_RECORD_VIEW_PRIV = 1; $SYSTEM_RECORD_EDIT_PRIV = 1; $SYSTEM_RECORD_DELETE_PRIV = 1; $SYSTEM_RECORD_SHENHE_PRIV = 1; $SYSTEM_RECORD_FLOW_PRIV = 1; $SYSTEM_RECORD_NEXT_PRIV = 1; $checkboxname = "selectid"; $disabled = ""; } else { $SYSTEM_RECORD_VIEW_PRIV = 0; $SYSTEM_RECORD_EDIT_PRIV = 0; $SYSTEM_RECORD_DELETE_PRIV = 0; $SYSTEM_RECORD_SHENHE_PRIV = 0; $SYSTEM_RECORD_FLOW_PRIV = 0; $SYSTEM_RECORD_NEXT_PRIV = 0; $disabled = "disabled"; $checkboxname = "selectid"; } } else { $SYSTEM_RECORD_VIEW_PRIV = 1; $SYSTEM_RECORD_EDIT_PRIV = 1; $SYSTEM_RECORD_DELETE_PRIV = 1; $SYSTEM_RECORD_SHENHE_PRIV = 1; $SYSTEM_RECORD_FLOW_PRIV = 1; $SYSTEM_RECORD_NEXT_PRIV = 1; $disabled = ""; $checkboxname = "selectid"; } //下面权限增加为外部分权限系统调用,在外部控制这一部分权限的调用 //一般情况下为用户自定义文件中定义相关的权限信息,调用方法为:"主体_PRIV"的格式 //print_R($fields['edit_priv']); if ($fields['view_priv'][$row_element_counter] == 1) { $SYSTEM_RECORD_VIEW_PRIV = 0; $disabled = "disabled"; $checkboxname = "selectid"; } if ($fields['edit_priv'][$row_element_counter] == 1) { $SYSTEM_RECORD_EDIT_PRIV = 0; $disabled = "disabled"; $checkboxname = "selectid"; } if ($fields['delete_priv'][$row_element_counter] == 1) { $disabled = "disabled"; $checkboxname = "selectid"; $SYSTEM_RECORD_DELETE_PRIV = 0; } if ($fields['shenhe_priv'][$row_element_counter] == 1) { //$disabled = "disabled"; $checkboxname = "selectid"; $SYSTEM_RECORD_SHENHE_PRIV = 0; } if ($fields['flow_priv'][$row_element_counter] == 1) { //$disabled = "disabled"; $checkboxname = "selectid"; $SYSTEM_RECORD_FLOW_PRIV = 0; } if ($fields['next_priv'][$row_element_counter] == 1) { //$disabled = "disabled"; $checkboxname = "selectid"; $SYSTEM_RECORD_NEXT_PRIV = 0; } //print $list_index; //print_R($fields['userdefine']); //print $SYSTEM_RECORD_DELETE_PRIV; ////SYSTEM_RECORD_EDIT_PRIV 为0时不显示选项,为1时显示选项 //############################################################ //############################################################ //数据移植区,原本在下面,现调为上面########################## //############################################################ $DataRowOperation = ""; $row_value_array = explode(',', $row_userpriv_text[$row_element_counter]); if (in_array($USER_ID, $row_value_array) || sizeof($row_value_array) <= 1) { $DataRowOperationArray = array(); for ($i = 0; $i < sizeof($row_array); $i++) { $element_array = explode(':', $row_array[$i]); switch ($element_array[0]) { case 'view': //$ondblclick='init_view'; if ($SYSTEM_RECORD_VIEW_PRIV == 1) { $actionValueText = ""; //显示动作语言重载 $title1 = $common_html['common_html']['view']; $title2 = $element_array[1]; if ($html_etc[$tablename][$title2] == "") { $titleText = $title1; } else { $titleText = $html_etc[$tablename][$title2]; } $actionValue = explode("_", $_GET['action']); if (sizeof($actionValue) > 2) { array_pop($actionValue); } array_shift($actionValue); $actionValueText = join("_", $actionValue); $actionValueText = $element_array[1]; $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, "selectid"); //数据区操作,如需要则要进行弹出一个明细窗口,一般情况下会跳转查看页面。2007-4-24 14:42 if ($openWindowForChild == "1") { //$DataRowOperation .= "<a href=\"#\" onClick=\"javascript:$ondblclick_window\" title=\"".$titleText."\">".$titleText."</a>  \n"; $BooleanViewRow = $ondblclick_window; } else { //$DataRowOperation .= "<a href=\"?$return\" title=\"".$titleText."\">".$titleText."</a>  \n"; $BooleanViewRow = $return; } } else { $BooleanViewRow = ""; } break; case 'edit': //$ondblclick='init_edit'; $actionValueText = ""; $actionValue = explode("_", $_GET['action']); //={'init','default'} by cwf if (sizeof($actionValue) > 2) { array_pop($actionValue); } array_shift($actionValue); //删除数组中的第一个元素,并返回被删除元素的值 by cwf $actionValueText = join("_", $actionValue); //=default by cwf //用新的LINK ACTION替换旧的从网页GET变量直接继承的做法 $actionValueText = $element_array[1]; //=edit_default //从上面的作法考虑以前方法的兼容性 if ($actionValueText == "edit") { $actionValueText = "edit_default"; } if ($SYSTEM_RECORD_EDIT_PRIV == 1) { //显示动作语言重载 $title1 = $common_html['common_html']['edit']; $title2 = $element_array[1]; if ($html_etc[$tablename][$title2] == "") { $titleText = $title1; } else { $titleText = $html_etc[$tablename][$title2]; } $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, "selectid"); //生成加密的变量字符串 by cwf $BooleanEditRow = $return; //=cGFnZWlkPTEmYWN0aW9uPWVkaXRfZGVmYXVsdCZpZD0x by cwf if ($actionValueText != 'edit_default') { $DataRowOperation .= "<a href=\"?{$return}\" title=\"" . $titleText . "\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "?{$return}", "text" => $titleText)); } } else { $BooleanEditRow = ""; } break; case 'userdefine': //print_R($element_array); $actionValueText = $element_array[1]; $actionValuePage = $element_array[2]; //显示动作语言重载 $title1 = $common_html['common_html']['edit']; $title2 = $element_array[1]; if ($html_etc[$tablename][$title2] == "") { $titleText = $title1; } else { $titleText = $html_etc[$tablename][$title2]; } $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, "selectid"); //$BooleanEditRow = $return; $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "?{$actionValuePage}", "text" => $titleText)); break; case 'shenhe': if ($SYSTEM_RECORD_SHENHE_PRIV == 1) { $actionValueText = $element_array[1]; $actionValuePage = $element_array[2]; $target = $element_array[3]; //显示动作语言重载 $title1 = $common_html['common_html']['edit']; $title2 = $element_array[1]; if ($html_etc[$tablename][$title2] == "") { $titleText = $title1; } else { $titleText = $html_etc[$tablename][$title2]; } $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, "selectid"); //$BooleanEditRow = $return; if ($target != "") { $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\" target=\"{$target}\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "{$actionValuePage}?{$return}", "text" => $titleText, "target" => $target)); } else { $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "{$actionValuePage}?{$return}", "text" => $titleText)); } } break; case 'flow': if ($SYSTEM_RECORD_FLOW_PRIV == 1) { $actionValueText = $element_array[1]; $actionValuePage = $element_array[2]; $target = $element_array[3]; //显示动作语言重载 $title1 = $common_html['common_html']['edit']; $title2 = $element_array[1]; if ($html_etc[$tablename][$title2] == "") { $titleText = $title1; } else { $titleText = $html_etc[$tablename][$title2]; } $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, "selectid"); if ($target != "") { $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\" target=\"{$target}\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "{$actionValuePage}?{$return}", "text" => $titleText, "target" => $target)); } else { $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "{$actionValuePage}?{$return}", "text" => $titleText)); } } break; case 'next': if ($SYSTEM_RECORD_NEXT_PRIV == 1) { $actionValueText = $element_array[1]; $actionValuePage = $element_array[2]; $target = $element_array[3]; //显示动作语言重载 $title1 = $common_html['common_html']['edit']; $title2 = $element_array[1]; if ($html_etc[$tablename][$title2] == "") { $titleText = $title1; } else { $titleText = $html_etc[$tablename][$title2]; } $return = FormPageAction("action", $actionValueText, $primarykey_index, $linkvalue, "selectid"); //$BooleanEditRow = $return; if ($target != "") { $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\" target=\"{$target}\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "{$actionValuePage}?{$return}", "text" => $titleText, "target" => $target)); } else { $DataRowOperation .= "<a href=\"{$actionValuePage}?{$return}\" title=\"" . $titleText . "\">" . $titleText . "</a> \n"; array_push($DataRowOperationArray, array("href" => "{$actionValuePage}?{$return}", "text" => $titleText)); } } break; case 'delete': //2011-11-08进行外键判断,看是不是需要提供删除功能 global $ForeignKeyIndex, $columns; if ($ForeignKeyIndex != '') { $ForeignKeyIndexFORArray = explode(',', $ForeignKeyIndex); for ($xx = 0; $xx < sizeof($ForeignKeyIndexFORArray); $xx++) { $ForeignKeyIndexX = $ForeignKeyIndexFORArray[$xx]; $ForeignKeyIndexArray = explode(':', $ForeignKeyIndexX); $ForeignKeyIndexFieldIndex = $ForeignKeyIndexArray[0]; $ForeignKeyIndexTableName = $ForeignKeyIndexArray[1]; $ForeignKeyIndexTableIndex = $ForeignKeyIndexArray[2]; $ForeignKeyIndexFieldName = $columns[$ForeignKeyIndexFieldIndex]; $ForeignKeyIndexFieldValue = $list2[$ForeignKeyIndexFieldName]; $child_columns_index = returntablecolumn($ForeignKeyIndexTableName); $ForeignKeyIndexTableFieldName = $child_columns_index[$ForeignKeyIndexTableIndex]; $sql = "select COUNT(*) AS NUMX from {$ForeignKeyIndexTableName} where {$ForeignKeyIndexTableFieldName}='{$ForeignKeyIndexFieldValue}'"; //print $sql; $rs = $db->CacheExecute(150, $sql); $NUMX = $rs->fields['NUMX']; if ($NUMX > 0) { $TEMP_VAR_SHOP_DELETE = 1; //存在数据,不允许出现删除按钮 break; } else { $TEMP_VAR_SHOP_DELETE = 0; //没有数据,正常提供删除按钮 } //print $ForeignKeyIndexTableFieldName; //print_R($child_columns_index); } } $temp_array = explode('_', $element_array[1]); sizeof($temp_array) == 1 ? $element_array[1] = 'delete_array' : ''; $actionValue = $element_array[1]; $actionValue != "" ? '' : ($actionValue = "delete_array"); if ($SYSTEM_RECORD_DELETE_PRIV == 1 && $TEMP_VAR_SHOP_DELETE == 0) { $return = FormPageAction("action", $actionValue, "selectid", $linkvalue, $primarykey_index); $DataRowOperation .= "<a href=\"javascript:if(confirm('" . $common_html['common_html']['reallydelete'] . "'))location='?{$return}'\" title=\"" . $common_html['common_html']['delete'] . "\">" . $common_html['common_html']['delete'] . "</a> \n"; array_push($DataRowOperationArray, array("href" => "javascript:if(confirm('" . $common_html['common_html']['reallydelete'] . "'))location='?{$return}'", "text" => $common_html['common_html']['delete'])); } elseif ($SYSTEM_RECORD_DELETE_PRIV == 1 && $TEMP_VAR_SHOP_DELETE == 1) { $ForeignKeyIndexTableNameMEMO = returntablefield("systemlang", "tablename", $ForeignKeyIndexTableName, "chinese", "fieldname", $ForeignKeyIndexTableName); $return = FormPageAction("action", $actionValue, "selectid", $linkvalue, $primarykey_index); $DataRowOperation .= "<font color=gray title='如需删除此记录,请先在与之相关的明细表中即:[" . $ForeignKeyIndexTableNameMEMO . "]模块中删除与当前记录相关的数据,涉及数据:" . $NUMX . "条.'>" . $common_html['common_html']['delete'] . "</font> \n"; } break; } // --end switch } // --end for } // --end row_userpriv //############################################################ //底部功能,原本在下面,现加入弹出菜单中########################## //############################################################ global $bottom_element; $bottom_array = explode(',', $bottom_element); for ($i = 0; $i < sizeof($bottom_array); $i++) { $element_array = explode(':', $bottom_array[$i]); $index_name = $element_array[1] == '' ? $element_array[0] : $element_array[1]; if ($element_array[0] == 'operation') { $lastactionname = "action=operation_" . $element_array[1] . "&selectid={$linkvalue}"; $lastactionname = "?" . base64_encode($lastactionname); if ($element_array[3] != "") { array_push($DataRowOperationArray, array("href" => $lastactionname, "text" => $common_html['common_html'][$index_name], "target" => $element_array[3])); } else { array_push($DataRowOperationArray, array("href" => $lastactionname, "text" => $common_html['common_html'][$index_name])); } } } //############################################################ //单击行记录函数定义########################################## //############################################################ global $onclick_config; if ($onclick_config != "") { $functionName = $onclick_config; $fileName = $onclick_config . ".php"; $fileName0 = "userdefine/{$fileName}"; $fileName = "../../Enginee/userdefine/{$fileName}"; if (file_exists($fileName0)) { require_once $fileName0; $functionName = $functionName . "_Value"; if (function_exists($functionName)) { $onclick_text = $functionName($fields['value'][$row_element_counter][$list_index], $fields, $row_element_counter); } } else { if (file_exists($fileName)) { require_once $fileName; $functionName = $functionName . "_Value"; if (function_exists($functionName)) { $onclick_text = $functionName($fields['value'][$row_element_counter][$list_index], $fields, $row_element_counter); } else { print "函数名称[{$functionName}]不存在!"; } } else { print "没有相应文件,文件名:{$fileName}"; } } } //print $onclick_text; //############################################################ //开始判断是否进行[改]操作-开始############################## //############################################################ if (is_file("images/edit1.gif")) { $EditImagePath1 = "images/edit1.gif"; $EditImagePath2 = "images/edit2.gif"; $ViewImagePath = "images/view.gif"; $DropImagePath = "images/drop.gif"; } else { if (is_file("../Framework/images/edit1.gif")) { $EditImagePath1 = "../Framework/images/edit1.gif"; $EditImagePath2 = "../Framework/images/edit2.gif"; $ViewImagePath = "../Framework/images/view.gif"; $DropImagePath = "../Framework/images/drop.gif"; } else { if (is_file("../../../Framework/images/edit1.gif")) { $EditImagePath1 = "../../../Framework/images/edit1.gif"; $EditImagePath2 = "../../../Framework/images/edit2.gif"; $ViewImagePath = "../../../Framework/images/view.gif"; $DropImagePath = "../../../Framework/images/drop.gif"; } else { $EditImagePath1 = "../../Framework/images/edit1.gif"; $EditImagePath2 = "../../Framework/images/edit2.gif"; $ViewImagePath = "../../Framework/images/view.gif"; $DropImagePath = "../../Framework/images/drop.gif"; } } } //编辑操作文本显示 if ($BooleanEditRow != "") { $CheckboxImage = " <a href=\"?{$BooleanEditRow}\"><img src=\"{$EditImagePath1}\" title=\"" . $common_html['common_html']['edit'] . $common_html['common_html']['record'] . "\" border=0></a>"; } else { //$CheckboxImage = " <img src=\"$EditImagePath2\" title=\"".$common_html['common_html']['edit'].$common_html['common_html']['record']."\" border=0>"; $CheckboxImage = ""; } //查看操作文本显示 $pathViewShow = "<img src=\"{$ViewImagePath}\" title=\"" . $common_html['common_html']['view'] . $common_html['common_html']['record'] . "\" border=0>"; if ($openWindowForChild == "1") { $CheckboxImage .= " <a href=\"#\" onClick=\"javascript:{$BooleanViewRow}\" title=\"" . $common_html['common_html']['view'] . $common_html['common_html']['record'] . "\">" . $pathViewShow . "</a>\n"; $BooleanViewRow = $ondblclick_window; } else { if ($BooleanViewRow != "") { $CheckboxImage .= " <a href=\"?{$BooleanViewRow}\" title=\"" . $common_html['common_html']['view'] . $common_html['common_html']['record'] . "\">" . $pathViewShow . "</a>\n"; } } if (sizeof($DataRowOperationArray) > 0) { $CheckboxImage .= "<span id='divTest{$row_element_counter}' style='cursor:pointer;' ><img src='{$DropImagePath}' border=0 title='更多操作'></span>\n"; print "<script type='text/javascript'>\n\t\t\t\$(function() {\n\t\t\t\$('#divTest{$row_element_counter}').powerFloat({\n\t\t\t\t\t\n\t\t\t \teventType: \"click\",\n\t\t\t\t\ttarget: [\n\t\t\t\t\t\t"; foreach ($DataRowOperationArray as $DataRowlist) { print "{\n\t\t\t\t\t\t\thref:\"" . $DataRowlist['href'] . "\",\n\t\t\t\t\t\t\ttarget:\"" . $DataRowlist['target'] . "\",\n\t\t\t\t\t\t\ttext:\"" . $DataRowlist['text'] . " \"\t\n\t\t\t\t\t\t},"; } print "\n\t\t\t\t\t],\n\t\t\t\t\ttargetMode: \"list\"\t\n\t\t\t\t});\n\t\t\t});\n\t\t\t </script>"; } //############################################################ //开始判断是否进行[改]操作-结束############################## //############################################################ $just_row_array = explode(":", $row_array[0]); //print_R($bottom_array); if ($row_element_counter % 2 == 1) { $TDBgColor = "#e9f5fa"; $TDonMouseOut = "#e9f5fa"; $TDonMouseOver = "#d0ecfa"; $ClassHeader = "TableLine1"; } else { $TDBgColor = "#FFFFFF"; $TDonMouseOut = "#FFFFFF"; $TDonMouseOver = "#d0ecfa"; $ClassHeader = "TableLine2"; } //onMouseOver=bgColor='".$TDonMouseOver."' onMouseOut=bgColor='".$TDonMouseOut."' bgColor='".$TDBgColor."' print "<TR class={$ClassHeader} {$onclick_text} name='maindata'>\n"; //判断CHECKBOX部分的选择 if ($row_array[0] != "" || sizeof($bottom_array) > 1) { print "<TD noWrap align=middle>"; } //CHECKBOX部分:编辑选项及全选部分打开 //print_R($just_row_array); //if(($row_array[0]!=""&&$just_row_array[0]!="view")||$bottom_array[0]!="") { if ($bottom_array[0] != "") { print "<input accesskey='" . $row_element_counter_array[$row_element_counter] . "' {$disabled} type=\"checkbox\" title=\"" . $common_html['common_html']['choose'] . "" . $common_html['common_html']['this'] . "" . $common_html['common_html']['record'] . " " . $common_html['common_html']['accesskey'] . ":ALT+" . $row_element_counter_array[$row_element_counter] . "\" name=\"{$checkboxname}\" value=\"" . Trim($linkvalue) . "\">"; } //编辑选项及查看选项 if ($row_array[0] != "" || sizeof($bottom_array) > 1) { print $CheckboxImage; } if ($row_array[0] != "" || sizeof($bottom_array) > 1) { print "</TD>"; } //print $primarykey_index; $xxx = 0; foreach ($fields['name'] as $list_header) { //print_R($SYSTEM_FILTER_ARRAY); //过滤要显示的内容元素 //数据显示区 //$ShowElement = returnPrivateTwoArray($SYSTEM_FILTER_ARRAY,$USER_PRIV,$list_header,$list[$list_header],$list2[$RecordDEPT],$list2[$RecordUser]); $inputtext = $fields['INPUT_TEXT'][$list_header]; $inputsize = $fields['inputsize'][$list_header]; if ($inputtext == "private") { $grade = str_split($inputsize); if (!in_array($_SESSION['LOGIN_USER_PRIV'], $grade)) { continue; } } $ShowElement = $list[$list_header]; //判断字段类型情况,定义是否显示双击事件 $fieldfilter = $fields['filter'][$xxx]; $xxx += 1; if ($fieldfilter == "notshow" || $fieldfilter == "nowshow") { continue; } if ($fieldfilter == "ajaxinputhidden") { //$ondblclick_Text2 = ""; } else { //$ondblclick_Text2 = $ondblclick ; } //在此判断TEXTAREABR属于是否进行NOWRAP属性较验 if ($fieldfilter == "textareabr") { $trnowrap = ""; } else { $trnowrap = "noWrap"; } print "<TD {$trnowrap} align=left {$ondblclick} >" . $ShowElement . "</TD>\n"; switch ($list_header) { case $row_userpriv_array[1]: $row_userpriv_text[$row_element_counter] = $row_userpriv_text[$row_element_counter] . "," . $list[$list_header]; case $row_userpriv_array[2]: $row_userpriv_text[$row_element_counter] = $row_userpriv_text[$row_element_counter] . "," . $list[$list_header]; break; } } $i++; $row_array[0] != "" ? print "<TD noWrap align=middle>{$DataRowOperation}</TD>\n" : ''; //数据显示区,形成区域在上面部分 print "</TR>"; $row_element_counter++; } return $fields; }
function edit_record_newai() { global $db, $html_etc, $tablename; global $_POST, $_GET; global $return_sql_line, $isrechecked; DoReferer(); $SQL = $return_sql_line['update_sql']; //print $SQL;exit; //print_R($_POST);exit; $result = $db->Execute($SQL); global $db, $html_etc, $tablename, $primarykey, $columns, $showlistfieldlist, $showlistfieldfilter; system_log_input("更新" . $html_etc[$tablename][$tablename], $SQL); $primarykey_index = $columns[$primarykey]; $sql = "select * from {$tablename} where {$primarykey_index}=" . $_GET[$primarykey_index]; $showlistfieldlistArray = explode(",", $showlistfieldlist); $showlistfieldfilterArray = explode(",", $showlistfieldfilter); $modifycontent = ""; for ($i = 0; $i < sizeof($showlistfieldlistArray); $i++) { $fieldname = $columns[$showlistfieldlistArray[$i]]; if ($_POST[$fieldname] != $_POST[$fieldname . "_原始值"] && array_key_exists($fieldname . "_原始值", $_POST)) { $filterArray = explode(":", $showlistfieldfilterArray[$i]); if ($filterArray[0] == 'radiofilter' || $filterArray[0] == 'tablefiltercolor' || $filterArray[0] == 'tablefilter') { $columns1 = returntablecolumn($filterArray[1]); $oldvalue = returntablefield($filterArray[1], $columns1[$filterArray[2]], $_POST[$fieldname . "_原始值"], $columns1[$filterArray[3]]); $newvalue = returntablefield($filterArray[1], $columns1[$filterArray[2]], $_POST[$fieldname], $columns1[$filterArray[3]]); } else { $oldvalue = $_POST[$fieldname . "_原始值"]; $newvalue = $_POST[$fieldname]; } $modifycontent .= $html_etc[$tablename][$fieldname] . ":" . $oldvalue . " 改为 " . $newvalue . " "; } } if ($modifycontent != '') { modify_log_input($modifycontent, $tablename, $primarykey_index, $_GET[$primarykey_index]); } if ($result->EOF) { return false; } else { return true; } }
</table> </div> <div id="dataId"> <?php $dataCount = sizeof($rs_a2); if ($dataCount == 0) { $rs_a2[0] = ""; $dataCount = 1; $MarkName = ""; } else { print "<input type=hidden name=dataDealMethod value=update>"; print "<input type=hidden name=updateDataMax value=" . $dataCount . ">"; print "<input type=hidden name=updateRowid value=" . $_GET['ROWID'] . ">"; } //print_R($rs_a2); $ChildColumns = returntablecolumn("getdetail"); for ($i = 0; $i < sizeof($rs_a2); $i++) { $MarkID = $i + 1; //if($i==0) $MarkName = "_0"; //else $MarkName = "_" . $MarkID; $Element = $rs_a2[$i]; for ($childID = 0; $childID < sizeof($ChildColumns); $childID++) { $ColumnName = $ChildColumns[$childID]; ${$ColumnName} = $Element[$ColumnName]; } ?> <table width="95%" class="TableBlock"> <tr> <td nowrap width="40" align="center" class="TableContent">
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"; }
foreach ($sellplanmain_showlistfieldlist as $row) { if (isset($sellplanmain_columns[$row])) { $printfieldlist[$row] = $sellplanmain_columns[$row]; } } $printfieldlist = array_flip($printfieldlist); global $db; $sql = "select fieldname,chinese from systemlang where tablename='v_sellone'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); foreach ($rs_a as $row) { if (isset($printfieldlist[$row['fieldname']])) { $printfieldlist[$row['fieldname']] = $row['chinese']; } } $product_columns = returntablecolumn('sellplanmain_detail'); @($sellplanmain_ini_file = @parse_ini_file('../JXC/Model/sellplanmain_detail_newai.ini', true)); $product_showlistfieldlist = explode(',', $sellplanmain_ini_file['view_default']['showlistfieldlist']); $pro_printfieldlist = array(); foreach ($product_showlistfieldlist as $row) { if (isset($product_columns[$row])) { $pro_printfieldlist[$row] = $product_columns[$row]; } } $pro_printfieldlist = array_flip($pro_printfieldlist); global $db; $sql = "select fieldname,chinese from systemlang where tablename='sellplanmain_detail'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); foreach ($rs_a as $row) { if (isset($pro_printfieldlist[$row['fieldname']])) {
function dataDeal_edit() { global $_SESSION, $_GET, $_POST, $db; $tablename = "getmain"; $childtablename = "getdetail"; $Columns = returntablecolumn($tablename); $ChildColumns = returntablecolumn($childtablename); $sql = ""; $FieldArray = array(); $ValueArray = array(); $updateSQL = array(); for ($i = 0; $i < sizeof($Columns); $i++) { $Element = $Columns[$i]; $Value = $_POST[$Element]; if ($Value != "") { //array_push($FieldArray,$Element); switch ($Element) { case 'amt': case 'payamt': case 'factpayamt': case 'money': $Value = ereg_replace(',', '', $Value); $Value = (double) $Value; break; } //array_push($ValueArray,$Value); $updateText = "{$Element} = '" . $Value . "'"; array_push($updateSQL, $updateText); } } $BodyText = join(',', $updateSQL); //形成主表SQL插入 $sql = "update {$tablename} set {$BodyText} where ROWID='" . $_POST['updateRowid'] . "';"; $rs = $db->Execute($sql); $MainID = $_POST['updateRowid']; //print $sql."<BR>"; //print_R($Columns); //######################################################################### //从表字段插入SQL语句形成################################################## //######################################################################### $sql = ""; $MaxValue = 10; if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 20; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 30; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 40; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 50; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 60; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 70; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 80; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 90; } if ($_POST['stockoutid_id_' . $MaxValue] != "") { $MaxValue = 100; } //更新部分 //明细列表 //$MainID = 9;//主键值 $sql = "delete from {$childtablename} where mainrowid='{$MainID}'"; $rs = $db->Execute($sql); //print $sql; for ($m = 0; $m < $MaxValue; $m++) { $FieldArray = array(); $ValueArray = array(); //明细单项判断 if ($_POST['stockoutid_id_' . $m] != "") { //明细SQL语句形成 for ($i = 0; $i < sizeof($ChildColumns); $i++) { $Element = $ChildColumns[$i]; switch ($Element) { case 'productid': $Element = "productid_id"; break; } if ($m == 0) { $Value = $_POST[$Element]; } else { $Value = $_POST[$Element . "_" . $m]; } switch ($Element) { case 'amt': case 'payamt': case 'money': case 'factpayamt': case 'noFaxAmt': $Value = ereg_replace(',', '', $Value); $Value = (double) $Value; break; case 'productid': $Element = "productid_id"; break; } //if($Value=="1,332") exit; if ($Value != "") { array_push($FieldArray, $ChildColumns[$i]); array_push($ValueArray, $Value); } } $FieldText = join(',', $FieldArray); $ValueText = join("','", $ValueArray); //形成主表SQL插入 $sql = "insert into {$childtablename} ( " . $FieldText . ",mainrowid ) values ( '" . $ValueText . "','" . $MainID . "' );"; $rs = $db->Execute($sql); //print $sql."<BR>"; } } //print_R($FieldArray); }
<?php /* 版权归属:郑州单点科技软件有限公司; 联系方式:0371-69663266; 公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南; 公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术(包括通信技术)的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中,全面提供具有自主知识产权的教育管理软件、服务与解决方案,是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务; 软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品; 发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索; 特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明; */ require_once "include.inc.php"; $filetablename = "sms"; $sessionkey = returnsesskey(); $GLOBAL_SESSION = returnsession(); $ExecTimeBegin = getmicrotime(); $lang = returnsystemlang(); $columns = returntablecolumn($filetablename); $html_etc = returnsystemlang($filetablename); $common_html = returnsystemlang("common_html"); if ($_GET['action'] == "sms_send") { $user_number = addslashes($_POST['user_number']); $msg_content = addslashes($_POST['msg_content']); $file = readfile("mobile_sendsms.php?action=sms_send&user_number={$user_number}&msg_content={$msg_content}"); print_r($file); } else { require_once "lib/html/mobile_sms.html"; }
function show_search_element($mark) { global $common_html, $html_etc; global $action_search, $columns, $tablename; global $group_filter, $db, $action_model; $action_search_array = explode(',', $action_search); for ($i = 0; $i < sizeof($action_search_array); $i++) { $index = $action_search_array[$i]; $value[$i] = $columns[$index]; $index_name = $value[$i]; $name[$i] = $html_etc[$tablename][$index_name]; } if ($group_filter != '') { $group_filter_array = explode(',', $group_filter); for ($i = 0; $i < sizeof($group_filter_array); $i++) { $temp_array = explode(':', $group_filter_array[$i]); $index_name = $columns["" . $temp_array[0] . ""]; //print_r($index_name); //得到实际用到的字段值列表--开始 $sql_parent = "select DISTINCT {$index_name} from {$tablename} order by {$index_name}"; //增加对老师GROUP_FILTER的支持 $markSQL = $temp_array[4]; if ($markSQL == "teachersession") { //print_R($_SESSION); $sunshine_teacher_code = $_SESSION['sunshine_teacher_code']; if ($sunshine_teacher_code != "") { $sql_parent = "select DISTINCT 班号 from edu_student,edu_banji where edu_student.班号=edu_banji.班级名称 and edu_banji.教师编码='{$sunshine_teacher_code}'"; //print $sql_parent; } } $PHP_SELF_ARRAY = explode('/', $_SERVER['PHP_SELF']); $FILE_SELF_NAME = array_pop($PHP_SELF_ARRAY); $FileDirName = array_pop($PHP_SELF_ARRAY); //&&$FileDirName=="Teacher" 只有在Teacher目录下面使用 2010-9-25 正常使用 //用于PGSQL下面不进行数据较验 //print $_SESSION['LOGIN_USER_ID']; //如果强制GET变量已经进行过预定义,那么沿用预定义内容进行 2010-9-2 $GET参数值 = explode(',', $_GET[$index_name]); global $_GET权限限制变量值; //2010-9-25定义权限限制变量名称 $GET参数值_权限限制变量值 = explode(',', $_GET权限限制变量值[$index_name]); //如果GET的值只有一个,则沿用GET的值,如果GET的值为两个及以上,则用系统值 if ($GET参数值[1] != "") { $附加判断条件Array = explode(',', $_GET[$index_name]); $附加判断条件 = "'" . join("','", $附加判断条件Array) . "'"; $sql_parent = "select DISTINCT {$index_name} from {$tablename} where {$index_name} in ({$附加判断条件}) order by {$index_name}"; } else { if ($GET参数值_权限限制变量值[0] != '') { $附加判断条件Array = explode(',', $_GET权限限制变量值[$index_name]); $附加判断条件 = "'" . join("','", $附加判断条件Array) . "'"; $sql_parent = "select DISTINCT {$index_name} from {$tablename} where {$index_name} in ({$附加判断条件}) order by {$index_name}"; } } //print $sql_parent."<BR>";exit; //以下数据形成从已经有的数据里面生成 $rs_parent = $db->Execute($sql_parent); $rs_parent_Array = $rs_parent->GetArray(); //得到实际用到的字段值列表--结束 $tablename2 = $temp_array[1]; $attribute = $temp_array[4]; //exit; if ($temp_array[2] == "" && $temp_array[3] == "") { $fieldname = $index_name; $fieldid = $index_name; $tablename2 = $tablename; } else { $columns_ = returntablecolumn($tablename2); $fieldid = $columns_["" . $temp_array[2] . ""]; $fieldname = $columns_["" . $temp_array[3] . ""]; } //############################################################################## //2008-10-30$temp_array[4]和$temp_array[5]的使用用途已经遗忘,记起来时则补回来. //############################################################################## if ($tablename2 != "") { if ($temp_array[4] != "" && $temp_array[5] != "" && strlen($temp_array[5]) > 3) { $columns_add = returntablecolumn($temp_array[5]); $fieldname_add = $columns_add[(string) $temp_array[6]]; if ($_GET[$fieldname_add] != "") { $sql = "select distinct {$fieldid},{$fieldname} from {$tablename2} where " . $columns_["" . $temp_array[4] . ""] . "='" . $_GET[$fieldname_add] . "'"; } else { $sql = "select distinct {$fieldid},{$fieldname} from {$tablename2}"; } } else { $sql = "select distinct {$fieldid},{$fieldname} from {$tablename2}"; } //print $sql."<BR>"; //############################################################################## //2008-10-30追加代码----------开始 KEY4优先级应比KEY5优级级高 //############################################################################## //print_R($columns_); if ($temp_array[4] != "") { $fieldname_add4 = $columns_[(string) $temp_array[4]]; if ($temp_array[5] != "" && strlen($temp_array[5]) <= 3) { //5值不为空,并且不代表数据表名称,代表KEY索引时 $fieldname_add4 = $columns_[(string) $temp_array[4]]; $fieldname_add5 = $columns_[(string) $temp_array[5]]; if ($_GET[$fieldname_add5] != "" && $_GET[$fieldname_add4] == "") { $sql = "select {$fieldid},{$fieldname} from {$tablename2} where " . $fieldname_add5 . "='" . $_GET[$fieldname_add5] . "'"; } else { if ($_GET[$fieldname_add4] != "") { $sql = "select {$fieldid},{$fieldname} from {$tablename2} where " . $fieldname_add4 . "='" . $_GET[$fieldname_add4] . "'"; } else { $sql = "select {$fieldid},{$fieldname} from {$tablename2}"; } } } else { if ($_GET[$fieldname_add4] != "") { $sql = "select {$fieldid},{$fieldname} from {$tablename2} where " . $fieldname_add4 . "='" . $_GET[$fieldname_add4] . "'"; } else { $sql = "select {$fieldid},{$fieldname} from {$tablename2}"; } } if ($_GET[$fieldname_add4] != "") { $sql = "select distinct {$fieldid},{$fieldname} from {$tablename2} where " . $fieldname_add4 . "='" . $_GET[$fieldname_add4] . "' order by {$fieldname}"; } else { $sql = "select distinct {$fieldid},{$fieldname} from {$tablename2} order by {$fieldname}"; } } else { $sql = "select distinct {$fieldid},{$fieldname} from {$tablename2} order by {$fieldname}"; } //print "<BR>".$sql."<BR>"; //######################################################################## //2008-10-30追加代码----------结束 //######################################################################## $rs = $db->CacheExecute(50, $sql); $rs_a = $rs->GetArray(); //键值转换 $NewKeyValue = array(); for ($nn = 0; $nn < sizeof($rs_a); $nn++) { $NewValue = TRIM($rs_a[$nn][$fieldid]); $NewName = TRIM($rs_a[$nn][$fieldname]); $NewKeyValue[$NewValue] = $NewName; } } //其它信息列表 $affixation[$i]['tablename'] = $tablename2; $affixation[$i]['index_name'] = $index_name; $affixation[$i]['attribute'] = $attribute; $j = 0; //print_R($index_name); //print_R($rs_parent_Array); //2009-5-26日判断如果$_GET进来的值是一个数组,那么不对数据表里面的值进行提取,转而提取数组里面的值 //主要用途:用于解决权限内部分值列表用于$_GET列表显示时,把权限值限于权限之内,如果不是数组,那么可以用HIDDEN属性,或着不限制 global $_GET2; //从外部获取变量值 if ($_GET2[$index_name] != "") { //外部传入参数存在 $权限值数组较验 = explode(',', $_GET2[$index_name]); if ($权限值数组较验[1] != "") { //并且传入参数是数组 $rs_parent_Array = array(); for ($ix = 0; $ix < count($权限值数组较验); $ix++) { $rs_parent_Array[]['班号'] = $权限值数组较验[$ix]; } } } //实际使用 for ($gg = 0; $gg < sizeof($rs_parent_Array); $gg++) { $NewValue = $rs_parent_Array[$gg][$index_name]; //print "<BR>"; if ($tablename2 != "") { $NewName = $NewKeyValue[(string) $NewValue]; } else { $NewName = $rs_parent_Array[$gg][$index_name]; } if ($NewName != "") { //####################################################################################### //2008-10-30把NewValue换为NewName值判断,目的:使为了GROUP_FILTER组列表可以动态的发生变化,更加符合实际的应用. //####################################################################################### $indexid = trim($NewValue); $indexname = trim($NewName); $affixation[$i]['fieldid'][$j] = trim($NewValue); //2009-5-26如果VALUE和NAME的值一样,那么只显示一条记录 if (trim($NewName) == trim($NewValue)) { $affixation[$i]['fieldname'][$j] = trim($NewName); } else { //$affixation[$i]['fieldname'][$j]=trim($NewName)."[".trim($NewValue)."]"; $affixation[$i]['fieldname'][$j] = trim($NewName); } if ($_GET[$index_name] == $affixation[$i]['fieldid'][$j]) { $affixation[$i]['selected'][$j] = 'selected'; $affixation_index = $indexname; } $j++; } } //以前使用的显示全部数据时所用到的方式 /* while(!$rs->EOF) { $indexid=trim($rs->fields[$fieldid]); $indexname=trim($rs->fields[$fieldname]); $affixation[$i]['fieldid'][$j]=trim($rs->fields[$fieldid]); $affixation[$i]['fieldname'][$j]=trim($rs->fields[$fieldname])."[".trim($rs->fields[$fieldid])."]"; $affixation[$i]['tablename']=$tablename2; $affixation[$i]['index_name']=$index_name; $affixation[$i]['attribute']=$attribute; if($_GET[$index_name]==$affixation[$i]['fieldid'][$j]) { $affixation[$i]['selected'][$j]='selected'; $affixation_index=$indexname; } $j++; $rs->MoveNext(); //}*/ } //end for } //end if print_search_element_array($name, $value, $mark, $affixation, $affixation_index); //输出按钮,此函数在html_element.php中定义 }
$js_code .= 'LODOP.ADD_PRINT_TEXT(' . $top . ',' . $l4 . ',' . $w2 . ',' . $h . ',"' . $order_info[0][$key] . '");'; $top += $h; } // 样式 $js_code .= 'LODOP.SET_PRINT_STYLEA(' . $style_number . ',"FontSize",10);'; $js_code .= 'LODOP.SET_PRINT_STYLEA(' . $style_number++ . ',"Bold",1);'; $js_code .= 'LODOP.SET_PRINT_STYLEA(' . $style_number . ',"FontSize",10);'; $js_code .= 'LODOP.SET_PRINT_STYLEA(' . $style_number++ . ',"Bold",1);'; $i++; } } $sql = 'SELECT * FROM sellplanmain_detail a WHERE a.mainrowid=' . $_GET['billid']; $rs = $db->Execute($sql); $detail = $rs->GetArray(); // 销售单明细打印字段配置 $customer_columns = returntablecolumn('sellplanmain_detail'); @($customer_ini_file = @parse_ini_file('./Model/sellplanmain_detail_newai.ini', true)); $customer_showlistfieldlist = explode(',', $customer_ini_file['view_default']['showlistfieldlist']); // 排除view_default中不存在或不允许显示的字段 $printfieldlist = array(); foreach ($customer_showlistfieldlist as $row) { if (isset($customer_columns[$row])) { $printfieldlist[$customer_columns[$row]] = $row; } } // 获取销售单明细打印字段中文名 $sql = "select fieldname,chinese from systemlang where tablename='sellplanmain_detail'"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); foreach ($rs_a as $row) { if (isset($printfieldlist[$row['fieldname']])) {
function newai_export($fields, $mode = 'table') { global $common_html, $html_etc; global $return_sql_line, $db; global $columns; //print_R($_GET); global $showlistfieldlist, $group_filter; $tablename = $fields['table']['name']; $SQL = $fields['sql']['SQL']; $init = explode('_', $_GET['action']); $mark = $init[1]; global $tablewidth; $tablewidth = $tablewidth != "" ? $tablewidth : 450; if ($group_filter != "") { $group_filter_Array = explode(':', $group_filter); $TableFieldIndex = $group_filter_Array[0]; $KeyName = $columns[$TableFieldIndex]; $ChildTableName = $group_filter_Array[1]; $ChildTableFieldValueIndex = $group_filter_Array[2]; $ChildTableFieldNameIndex = $group_filter_Array[3]; $ChildColumns = returntablecolumn($ChildTableName); $ChildTableFieldValue = $ChildColumns[$ChildTableFieldValueIndex]; $ChildTableFieldName = $ChildColumns[$ChildTableFieldNameIndex]; $Childhtml_etc = returnsystemlang($ChildTableName, $SYTEM_CONFIG_TABLE); //print_R($Childhtml_etc); $ChildTableFieldHTMLValue = $Childhtml_etc[$ChildTableName][$ChildTableFieldValue]; $ChildTableFieldHTMLName = $Childhtml_etc[$ChildTableName][$ChildTableFieldName]; } else { $KeyName = "说明"; } print "<script>\n\t//CSV\n\tfunction selectid_str_init_CSV(mark)\n\t{\n\tselectid_str = \"\";\n\tfor(i=0;i<document.all(\"selectid\").length-1;i++)\n\t\t{\n\n\t\tel = document.all(\"selectid\").item(i);\n\t\tif(el.checked)\n\t\t{\tval = el.value;\n\t\t\tif(val !=\"\")\t{\n\t\t\t\tselectid_str += val + \",\";\n\t\t\t}\n\t\t}\n\t}\n\n\tell = document.all(\"selectid\").item(document.all(\"selectid\").length-1);\n\tif(ell.checked)\n\t{\tval = ell.value;\n\t\tif(val !=\"\")\t{\n\t\t\tselectid_str += val ;\n\t\t}\n\t}\n\n\ttablename_\t\t=\tdocument.form1.tablename.value;\n\tsearchfield_\t=\tdocument.form1.searchfield.value;\n\tsearchvalue_\t=\tdocument.form1.searchvalue.value;\n\tAdvanceSearch_\t=\tdocument.form1.AdvanceSearch.value;\n\texportfield= selectid_str;\n\n\n\t"; if ($_GET['actionadv'] == "exportadv_default") { //不用显示或得到SELECTID的值 print "\turl=\"?action=export_\"+mark+\"_data&method=CSV&actionadv=exportadv_default&exportfield=\"+exportfield+\"&tablename=\"+tablename_+\"&searchfield=\"+searchfield_+\"&searchvalue=\"+searchvalue_+AdvanceSearch_"; } else { print "\tvar " . $KeyName . "SelectValue = document.form1." . $KeyName . ".options[document.form1." . $KeyName . ".selectedIndex].value;\n\t\t"; print "\turl=\"?action=export_\"+mark+\"_data&method=CSV&exportfield=\"+exportfield+\"&tablename=\"+tablename_+\"&searchfield=\"+searchfield_+\"&searchvalue=\"+searchvalue_+\"&" . $KeyName . "=\"+" . $KeyName . "SelectValue+AdvanceSearch_"; } print "\n\t//alert(url);\n\tlocation=url;\n\t}\n\t//XLS\n\tfunction selectid_str_init_XLS(mark)\n\t{\n\tselectid_str = \"\";\n\tfor(i=0;i<document.all(\"selectid\").length-1;i++)\n\t\t{\n\n\t\tel = document.all(\"selectid\").item(i);\n\t\tif(el.checked)\n\t\t{\tval = el.value;\n\t\t\tif(val !=\"\")\t{\n\t\t\t\tselectid_str += val + \",\";\n\t\t\t}\n\t\t}\n\t}\n\n\tell = document.all(\"selectid\").item(document.all(\"selectid\").length-1);\n\tif(ell.checked)\n\t{\tval = ell.value;\n\t\tif(val !=\"\")\t{\n\t\t\tselectid_str += val ;\n\t\t}\n\t}\n\n\ttablename_\t\t=\tdocument.form1.tablename.value;\n\tsearchfield_\t=\tdocument.form1.searchfield.value;\n\tsearchvalue_\t=\tdocument.form1.searchvalue.value;\n\tAdvanceSearch_\t=\tdocument.form1.AdvanceSearch.value;\n\texportfield= selectid_str;\n\t"; if ($_GET['actionadv'] == "exportadv_default") { //不用显示或得到SELECTID的值 print "\turl=\"?action=export_\"+mark+\"_data&actionadv=exportadv_default&exportfield=\"+exportfield+\"&tablename=\"+tablename_+\"&searchfield=\"+searchfield_+\"&searchvalue=\"+searchvalue_+AdvanceSearch_"; } else { print "\tvar " . $KeyName . "SelectValue = document.form1." . $KeyName . ".options[document.form1." . $KeyName . ".selectedIndex].value;\n\t\t"; print "\turl=\"?action=export_\"+mark+\"_data&exportfield=\"+exportfield+\"&tablename=\"+tablename_+\"&searchfield=\"+searchfield_+\"&searchvalue=\"+searchvalue_+\"&" . $KeyName . "=\"+" . $KeyName . "SelectValue+AdvanceSearch_"; } print "\n\t//url\n\t//alert(url);\n\tlocation=url;\n\t}\n\t</script>"; form_begin("form1"); table_begin($tablewidth); switch ($mode) { case 'table': print_title($common_html['common_html']['tableexport'], 3); print "<TR class=TableData>\n"; print "<TD noWrap align=middle>选择</TD>\n"; print "<TD width=200>字段描述</TD>\n"; print "<TD width=200>字段名称</TD>\n"; print "</TR>\n"; for ($i = 0; $i < sizeof($columns); $i++) { $list = $columns[$i]; print "<TR class=TableData>\n"; print "<TD noWrap align=middle width=20><input type=\"checkbox\" checked name=\"selectfield\" value=\"{$list}\"></TD>\n"; print "<TD>" . $html_etc[$tablename][$list] . "</TD>\n"; print "<TD>{$list}</TD>\n"; print "</TR>\n"; $temp_function = 'selectfield_str'; } break; case 'content': print_title($common_html['common_html']['contentexport'], 3); print "<TR class=TableData>\n"; print "<TD noWrap align=center width=30>选择</TD>\n"; print "<TD width=100>字段描述</TD>\n"; print "<TD width=150>字段名称</TD>\n"; print "</TR>\n"; //附加组数据导出--开始 //print_R($group_filter_Array); if ($group_filter != "" && $_GET['actionadv'] != "exportadv_default") { //如果强制GET变量已经进行过预定义,那么沿用预定义内容进行 2010-9-2 $TableFieldIndex = $group_filter_Array[0]; $KeyName = $columns[$TableFieldIndex]; $PHP_SELF_ARRAY = explode('/', $_SERVER['PHP_SELF']); $FILE_SELF_NAME = array_pop($PHP_SELF_ARRAY); $FileDirName = array_pop($PHP_SELF_ARRAY); //用于PGSQL下面不进行数据较验 //print $_SESSION['LOGIN_USER_ID']; //如果强制GET变量已经进行过预定义,那么沿用预定义内容进行 2010-9-2 //&&$FileDirName=="Teacher" 只有在Teacher目录下面使用 2010-9-25 正常使用 if ($_GET[$KeyName] != "") { //$ChildTableName = $group_filter_Array[1]; //$ChildTableFieldValueIndex = $group_filter_Array[2]; //$ChildTableFieldNameIndex = $group_filter_Array[3]; //print $KeyName; $附加判断条件Array = explode(',', $_GET[$KeyName]); $附加判断条件 = "'" . join("','", $附加判断条件Array) . "'"; $sql = "\n\t\t\t\t\tselect {$ChildTableFieldValue},{$ChildTableFieldName}\n\t\t\t\t\tfrom {$ChildTableName}\n\t\t\t\t\twhere ( {$ChildTableFieldValue} in ({$附加判断条件})\n\t\t\t\t\t\t\tor\n\t\t\t\t\t\t\t{$ChildTableFieldName} in ({$附加判断条件})\n\t\t\t\t\t\t\t)\n\t\t\t\t\torder by {$ChildTableFieldName}"; // } else { $sql = "select {$ChildTableFieldValue},{$ChildTableFieldName} from {$ChildTableName} order by {$ChildTableFieldName}"; } //print $sql; //print $index_name;print_R($_GET); $rs = $db->CacheExecute(150, $sql); $rs_a = $rs->GetArray(); if ($Childhtml_etc[$ChildTableName][$ChildTableFieldName] != "") { $ShowText = "按" . $html_etc[$tablename][$KeyName] . "过滤"; //$ShowText = "按".$Childhtml_etc[$ChildTableName][$ChildTableFieldName]."过滤"; } else { $ShowText = "按" . $html_etc[$tablename][$KeyName] . "过滤"; } print "<TR class=TableData>\n"; print "<TD noWrap align=middle><input type=\"checkbox\" checked name=\"selectidtemp\" disabled value=\"{$index}\"></TD>\n"; print "<TD width=120 nowrap>" . $ShowText . "</TD>\n"; print "<TD width=150 nowrap>"; //print_R($_GET); //print $KeyName; //如果隐藏的话就显示为只读 if ($group_filter_Array[4] == "hidden") { //如果隐藏的话就显示为只读 $显示名称 = returntablefield($ChildTableName, $ChildTableFieldValue, $_GET[$KeyName], $ChildTableFieldName); print "<select class=\"SmallSelect\" name=\"" . $KeyName . "\">\n"; print "<option value=\"" . $_GET[$KeyName] . "\" >" . $显示名称 . "[" . $_GET[$KeyName] . "]</option>\n"; print "</select>\n"; } else { //显示成为列表 print "<select class=\"SmallSelect\" name=\"" . $KeyName . "\" >\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"; //2009-12-24加入对列表组的过滤 for ($i = 0; $i < sizeof($rs_a); $i++) { if ($_GET[$KeyName] == $rs_a[$i][$ChildTableFieldValue]) { $CheckedX = "selected"; } else { $CheckedX = ""; } print "<option value=\"" . $rs_a[$i][$ChildTableFieldValue] . "\" {$CheckedX} >" . $rs_a[$i][$ChildTableFieldName] . "[" . $rs_a[$i][$ChildTableFieldValue] . "]</option>\n"; } print "</select>\n"; } //2009-12-24加入对搜索属性的支持 print "<input type=hidden name='searchfield' value='" . $_GET['searchfield'] . "'>\n"; print "<input type=hidden name='searchvalue' value='" . $_GET['searchvalue'] . "'>\n"; print "<input type=hidden name='tablename' value='{$tablename}'>\n"; print "<input type=hidden name='AdvanceSearch' value='{$ADD_SEARCH_VALUE}'>\n"; print "</TD></TR>\n"; } else { //高级搜索时出现的隐藏变量 if ($_GET['actionadv'] == "exportadv_default") { print "<TR class=TableData>\n"; print "<TD noWrap align=middle><input type=\"checkbox\" checked name=\"selectidtemp\" disabled value=\"{$index}\"></TD>\n"; print "<TD width=90% colspan=2>高级搜索:\n"; //print "<select class=\"SmallSelect\" name=\"".$KeyName."\" disabled>\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"; //print "</select>\n"; $showlistfieldlist_array = explode(',', $showlistfieldlist); //print_R($showlistfieldlist_array); for ($i = 0; $i < sizeof($showlistfieldlist_array); $i++) { $index = $showlistfieldlist_array[$i]; $list = $columns[$index]; if ($_GET[$list] != "") { $ADD_SEARCH_VALUE .= "&{$list}=" . $_GET[$list]; $ADD_SEARCH_TEXT .= " {$list}:" . $_GET[$list]; } else { if ($_GET[$list . "_最小值"] != "" && $_GET[$list . "_最大值"] != "") { $ADD_SEARCH_VALUE .= "&" . $list . "_最小值=" . $_GET[$list . "_最小值"] . "&" . $list . "_最大值=" . $_GET[$list . "_最大值"] . ""; $ADD_SEARCH_TEXT .= " " . $list . "最小值:" . $_GET[$list . "_最小值"] . " " . $list . "最大值:" . $_GET[$list . "_最大值"] . ""; } else { if ($_GET[$list . "_开始时间"] != "" && $_GET[$list . "_结束时间"] != "") { $ADD_SEARCH_VALUE .= "&" . $list . "_开始时间=" . $_GET[$list . "_开始时间"] . "&" . $list . "_结束时间=" . $_GET[$list . "_结束时间"] . ""; $ADD_SEARCH_TEXT .= " " . $list . "开始时间:" . $_GET[$list . "_开始时间"] . " " . $list . "结束时间:" . $_GET[$list . "_结束时间"] . ""; } } } } print $ADD_SEARCH_TEXT; //print $ADD_SEARCH_VALUE; print "<input type=hidden name='{$KeyName}' value='" . $_GET['searchfield'] . "'>\n"; print "<input type=hidden name='searchfield' value='" . $_GET['searchfield'] . "'>\n"; print "<input type=hidden name='searchvalue' value='" . $_GET['searchvalue'] . "'>\n"; print "<input type=hidden name='tablename' value='{$tablename}'>\n"; print "<input type=hidden name='AdvanceSearch' value='{$ADD_SEARCH_VALUE}'>\n"; print "</TD></TR>\n"; } else { print "<TR class=TableData>\n"; print "<TD noWrap align=middle><input type=\"checkbox\" checked name=\"selectidtemp\" disabled value=\"{$index}\"></TD>\n"; print "<TD width=120 disabled>数据过滤</TD>\n"; print "<TD width=150 nowrap>"; print "<select class=\"SmallSelect\" name=\"" . $KeyName . "\" disabled>\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"; print "</select>\n"; print "<input type=hidden name='searchfield' value='" . $_GET['searchfield'] . "'>\n"; print "<input type=hidden name='searchvalue' value='" . $_GET['searchvalue'] . "'>\n"; print "<input type=hidden name='tablename' value='{$tablename}'>\n"; print "<input type=hidden name='AdvanceSearch' value='{$ADD_SEARCH_VALUE}'>\n"; print "</TD></TR>\n"; } } //附加组数据导出--结束 $showlistfieldlist_array = explode(',', $showlistfieldlist); //print_R($showlistfieldlist_array); for ($i = 0; $i < sizeof($showlistfieldlist_array); $i++) { $index = $showlistfieldlist_array[$i]; $list = $columns[$index]; print "<TR class=TableData>\n"; print "<TD noWrap align=middle><input type=\"checkbox\" checked name=\"selectid\" value=\"{$index}\"></TD>\n"; print "<TD >" . $html_etc[$tablename][$list] . "</TD>\n"; print "<TD >{$list}</TD>\n"; print "</TR>\n"; $temp_function = 'selectid_str_init'; } break; } global $returnmodel; $returnmodelArray = explode(',', $returnmodel); if ($returnmodelArray[1] != "") { $returnmodelURL = $returnmodelArray[1]; } else { $returnmodelURL = "?"; } print "<tr align=\"center\" class=\"TableControl\">\n<td colspan=\"3\" nowrap>\n<div align=\"center\">\n\n\t<input type=\"button\" value=\"" . $common_html['common_html']['export'] . "CSV\" accesskey='v' title=\"" . $common_html['common_html']['accesskey'] . ":ALT+V\" class=\"SmallButton\" onClick=\"selectid_str_init_CSV('{$mark}');\">\n\t<input type=\"button\" value=\" " . $common_html['common_html']['export'] . "EXCEL \" accesskey='x' title=\"" . $common_html['common_html']['accesskey'] . ":ALT+X\" class=\"SmallButton\" onClick=\"selectid_str_init_XLS('{$mark}');\">\n\t<input type=\"button\" accesskey='c' title=\"" . $common_html['common_html']['accesskey'] . ":ALT+C\" value=\"" . $common_html['common_html']['cancel'] . "\" class=\"SmallButton\" onClick=\"location='{$returnmodelURL}'\"></div>\n</td></tr>\n"; table_end(); form_end(); print "<BR>"; }
</table> </div> <div id="dataId"> <?php $dataCount = sizeof($rs_a2); if ($dataCount == 0) { $rs_a2[0] = ""; $dataCount = 1; $MarkName = ""; } else { print "<input type=hidden name=dataDealMethod value=update>"; print "<input type=hidden name=updateDataMax value=" . $dataCount . ">"; print "<input type=hidden name=updateRowid value=" . $_GET['ROWID'] . ">"; } //print_R($rs_a2); $ChildColumns = returntablecolumn("paydetail"); for ($i = 0; $i < sizeof($rs_a2); $i++) { $MarkID = $i + 1; //if($i==0) $MarkName = "_0"; //else $MarkName = "_" . $MarkID; $Element = $rs_a2[$i]; for ($childID = 0; $childID < sizeof($ChildColumns); $childID++) { $ColumnName = $ChildColumns[$childID]; ${$ColumnName} = $Element[$ColumnName]; } ?> <table width="95%" class="TableBlock"> <tr> <td nowrap width="40" align="center" class="TableContent">