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">
