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 newaiadd($mode)
{
global $fields;
global $html_etc, $common_html, $custom_type;
global $db, $return_sql_line, $columns;
global $_POST, $_GET, $returnmodel;
global $action_submit, $merge, $form_attribute;
global $primary_key, $primarykey_index;
global $_SESSION, $SUNSHINE_USER_NAME_VAR;
$fields['other']['title'] = $common_html['common_html'][$mode];
//print_R($html_etc);
//如果为编辑和查看模型，则进行数据的初始化操作
global $ADDINIT;
if ($mode != 'add') {
$SQL = $return_sql_line['select_sql'];
//print_R($columns);exit;
//print_R($html_etc['application']);
//检测是否进行外来SQL语言执行
global $NEWAIADD_VALUE_SYSTEM;
if (strlen($NEWAIADD_VALUE_SYSTEM) > 10) {
$SQL = $NEWAIADD_VALUE_SYSTEM;
}
//print $SQL;
$result = $db->Execute($SQL);
$rs_array = $result->GetArray();
if (count($rs_array) == 0) {
print_infor("找不到记录，可能已删除", 'trip', "close", "", 0);
exit;
}
$fields['value'] = $rs_array[0];
} else {
$fields['value'] = $ADDINIT;
}
global $departprivte;
//用户角色级别权限判断，如果是用户自身的记录则可以修改，
//如果不是，那么沿用PRIVATE的权限进行管理
//此区域部分在NEWAI_SQL部分有所复制
if ($departprivte != "") {
$departprivteSQLArray = array();
$departprivteArray = explode('::', $departprivte);
//print_R($departprivteArray);
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];
if ($ColumnName1 != "" && $fields['value'][$ColumnName1] != "") {
if ($USER_NAME == $fields['value'][$ColumnName1]) {
$SYSTEM_PRIVATE_USER_DEFINE_CONTROL = 0;
} else {
$SYSTEM_PRIVATE_USER_DEFINE_CONTROL = 1;
}
} else {
$SYSTEM_PRIVATE_USER_DEFINE_CONTROL = 0;
}
break;
}
//end swtich
}
//end for
}
//exit;
//print $SYSTEM_PRIVATE_USER_DEFINE_CONTROL;
//print $fields['value'][$ColumnName1];
//print_R($fields['USER_PRIVATE']);
//-------------------------------------------------------------------
//附加的EMAIL控制部分，可以删除
switch ($_GET['action']) {
case 'edit_reply':
$fields['form']['action'] = 'action=add_outbox_data';
break;
case 'edit_forward':
$fields['form']['action'] = 'action=add_outbox_data';
break;
}
//加载JS的条件判断代码，主要用于数据新增和编辑时较验数据的格式是否合格
$tablename = $fields['table']['name'];
$realtablename = $fields['realtable'];
if ($form_attribute != 'hidden') {
if (is_file("../../Enginee/lib/CheckValue.js")) {
print "<script language = \"JavaScript\"> ";
print join('', file("../../Enginee/lib/CheckValue.js"));
print "</script>";
} else {
print "<script language = \"JavaScript\"> ";
print join('', file("../Enginee/lib/CheckValue.js"));
print "</script>";
}
form_begin($fields['form']['name'], $fields['form']['action'], 'post', $fields['null']);
//单位修改界面表单 by cwf
//<form name=$name id=form onsubmit=\"return FormCheck();\" \n action=\"$PHP_SELF?$action&pageid=".$_GET['pageid']."\" method=$method encType=multipart/form-data>
// echo $fields['form']['action'];//by cwf 'pageid=1&action=edit_default_data&id=1'
}
global $tablewidth;
$tablewidth = $tablewidth != "" ? $tablewidth : 450;
table_begin($tablewidth);
switch ($_GET['action']) {
case 'edit_reply':
$fields['other']['title'] = $common_html['common_html']['reply'] . " " . $common_html['common_html'][$tablename];
break;
case 'edit_forward':
$fields['other']['title'] = $common_html['common_html']['reply'] . " " . $common_html['common_html'][$tablename];
break;
default:
$fields['other']['title'] = $fields['other']['title'] . " " . $common_html['common_html'][$tablename];
}
global $tabletitle;
switch ($db->databaseType) {
case 'mysql':
case 'mssql':
default:
break;
case 'oracle':
$tabletitle = strtoupper($tabletitle);
break;
}
global $print_title;
$print_title = $tabletitle != "" ? $html_etc[$tablename][$tabletitle] : $fields['other']['title'];
print_title($print_title, 6);
//操作按钮提交
switch ($mode) {
case 'add':
case 'edit':
show_submit_element($action_submit, 'left');
//“保存”和“返回”按钮，此函数定义在newai.php中
break;
case 'view':
show_submit_element($action_submit, 'left');
break;
}
//数据的下载及合并,用途：FILE操作部分，可以删除
//merge -- begin
if ($merge != '') {
$merge_array = explode(':', $merge);
//print $merge;
$index_array_temp = explode(',', $merge_array[1]);
$id = $columns['' . $index_array_temp[0] . ''];
$name = $columns['' . $index_array_temp[1] . ''];
$array_pop = array_pop($fields['name']);
$fields['value'][$id] = returnfileurl($fields['value'][$id], $fields['value'][$name]);
}
//merge -- end
//此部分设计为权限部分设计：事业部总监和营销专员的的权限设计
$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=5;
//print_R($fields['USER_PRIVATE']);
//############################################################
//是否引入图片放大
$ifincludemaginfier = false;
global $colflag;
//print_R($fields['USER_PRIVATE']);
//数据显示区域部分，用于整个数据的主体部分
$colflag = 0;
for ($i = 0; $i < sizeof($fields['name']); $i++) {
$fieldname = trim($fields['name'][$i]);
$fieldfilter = trim($fields['filter'][$i]);
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$colflag = $colflag + 1;
if ($colflag > 2) {
$colflag = 1;
}
//上一行是单元格
if ($colflag == 2 && $i > 0 && ($fields['filter'][$i - 1] == "htmlarea" || $fields['filter'][$i - 1] == "textarea")) {
$colflag = 1;
}
//处在最后一行左边
if ($colflag == 1 && $i == sizeof($fields['name']) - 1) {
$colflag = 0;
}
//下一行是宽单元格
if ($colflag == 1 && $i < sizeof($fields['name']) - 1 && ($fields['filter'][$i + 1] == "htmlarea" || $fields['filter'][$i + 1] == "textarea")) {
$colflag = 0;
}
$fieldfilter_array = explode(':', $fieldfilter);
$fieldfilter = trim($fieldfilter_array[0]);
//用户定义角色权限，是否为只读(可写)选项
//如用用户定义可写，那么重新调整为可写， 如果非自身记录，则沿用系统设定
if ($ColumnName1 != "") {
//判断是否要对用户验证进行操作
$SYSTEM_PRIVATE_USER_DEFINE_CONTROL == 0 ? $fields['USER_PRIVATE'][$fieldname] = '' : '';
}
//数据过滤行为
//$ShowElement = returnPrivateTwoArray($SYSTEM_FILTER_ARRAY,$USER_PRIV,$fieldname,$fields['value'][$fieldname],$fields['value'][$RecordDEPT],$fields['value'][$RecordUser]);
//if($ShowElement!="***") {
if (1) {
//2010-6-14 11:20替换以前旧的判断方式
switch (TRIM($fieldfilter)) {
case 'email':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "email");
break;
case 'view':
$linkman = '';
$fromsrc = '';
if ($fields['tablename'] == 'linkman') {
$fromsrc = 'customer';
$linkman = gettablefield($fields['tablename'], 'email', 'rowid', $fields['value'][$fieldname]);
} else {
if ($fields['tablename'] == 'supplylinkman') {
$fromsrc = 'supply';
$linkman = gettablefield($fields['tablename'], 'email', 'rowid', $fields['value'][$fieldname]);
} else {
$linkman = $fields['value'][$fieldname];
$fromsrc = '';
}
}
$addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0037.gif' title='点击链接发送邮件'>";
if ($fields['value'][$fieldname] != '') {
$fields['value'][$fieldname] = "<a href='../CRM/email_newai.php?" . base64_encode("action=add_default&sendlist=" . $linkman . "&fromsrc=" . $fromsrc) . "' target='_blank' >" . $addicon . $fields['value'][$fieldname] . "</a>";
}
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'mobile':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "mobile");
break;
case 'view':
$addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0348.gif' title='点击号码发送短信'>";
if ($fields['value'][$fieldname] != '') {
$fields['value'][$fieldname] = "<a href='../JXC/sms_sendlist_newai.php?" . base64_encode("action=add_default&sendlist=" . $fields['value'][$fieldname]) . "' target='_blank'>" . $addicon . $fields['value'][$fieldname] . "</a>";
}
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'barcode':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "barcode");
break;
case 'view':
$addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0348.gif' title='点击号码发送短信'>";
if ($fields['value'][$fieldname] != '') {
$fields['value'][$fieldname] = "<a href='../JXC/sms_sendlist_newai.php?" . base64_encode("action=add_default&sendlist=" . $fields['value'][$fieldname]) . "' target='_blank'>" . $addicon . $fields['value'][$fieldname] . "</a>";
}
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'qq':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "qq");
break;
case 'view':
$fields['value'][$fieldname] = !empty($fields['value'][$fieldname]) ? "<a target=\"_blank\" href=\"http://wpa.qq.com/msgrd?v=3&uin=" . $fields['value'][$fieldname] . "&site=qq&menu=yes\"><img border=\"0\" src=\"http://wpa.qq.com/pa?p=2:" . $fields['value'][$fieldname] . ":45\" onerror=\"this.src='" . ROOT_DIR . "general/ERP/Framework/images/help3.gif';this.title='此QQ号码可能不存在'\" title=\"点击这里发消息\">" . $fields['value'][$fieldname] . "</a>" : '';
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'url':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "url");
break;
case 'view':
$urlwangzhi = $fields['value'][$fieldname];
$flag = stripos($fields['value'][$fieldname], "http://");
if ($flag === false) {
$urlwangzhi = "http://" . $urlwangzhi;
}
$addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0668.gif' title='点击链接打开网址'>";
if ($fields['value'][$fieldname] != '') {
$fields['value'][$fieldname] = "<a href='" . $urlwangzhi . "' target='_blank'>" . $addicon . $fields['value'][$fieldname] . "</a>";
}
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'city':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_city($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
case 'view':
$shengcode = substr($fields['value'][$fieldname], 0, 2);
$shengcode .= "0000";
$shengcode = returntablefield("customerarea", "rowid", $shengcode, "name");
$citycode = substr($fields['value'][$fieldname], 0, 4);
$citycode .= "00";
$citycode = returntablefield("customerarea", "rowid", $citycode, "name");
$towncode = returntablefield("customerarea", "rowid", $fields['value'][$fieldname], "name");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $shengcode . $citycode . $towncode);
break;
}
break;
case 'account':
switch ($mode) {
case 'add':
case 'edit':
print_account($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
}
break;
case '':
case 'input':
switch ($mode) {
case 'add':
case 'edit':
$pattern = $fields['INPUT_TEXT'][$fieldname];
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, $pattern);
//exit;
break;
case 'view':
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'hidden':
switch ($mode) {
case 'add':
case 'edit':
//print_R($fields['inputsize']);exit;
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_notshow($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1);
//exit;
break;
case 'view':
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan, $system_picture_line, $notnulltext);
break;
}
break;
case 'nowshow':
case 'notshow':
break;
case 'bigrmb':
switch ($mode) {
case 'add':
case 'edit':
break;
case 'view':
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
$MoneyValue = trim($fields['value'][$fieldname]);
if ($MoneyValue == 0) {
$FieldValueTemp = "<font color=green>0</font>";
} else {
$FieldValueTemp = "<font color=red>" . $MoneyValue . "</font> (" . num2rmb($MoneyValue) . ")";
}
print_text_tr($html_etc[$tablename][$fieldname] . ":", $FieldValueTemp, $colspan);
break;
}
break;
case 'number':
switch ($mode) {
case 'add':
$_GET[$fieldname] = $fields['INPUT_TEXT'][$fieldname];
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "Number");
$custom_type = "";
break;
case 'view':
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan);
break;
}
break;
case 'money':
switch ($mode) {
case 'add':
$_GET[$fieldname] = $fields['INPUT_TEXT'][$fieldname];
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "Money");
$custom_type = "";
break;
case 'view':
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan);
break;
}
break;
case 'autoincrement':
switch ($mode) {
case 'add':
case 'edit':
print_tr_auto_increment($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputcols']);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]));
break;
}
break;
case 'autoincrementdate':
switch ($mode) {
case 'add':
print_tr_auto_incrementdate($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $fields['INPUT_TEXT'][$fieldname]);
break;
case 'edit':
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]));
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan);
break;
}
break;
case 'readonly':
switch ($mode) {
case 'add':
case 'edit':
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols'], 'SmallStatic', "", 'text', 'readonly');
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $colspan);
break;
}
break;
case 'readonlytextarea':
switch ($mode) {
case 'add':
case 'edit':
//print_R($fields['other']['textarea']);
//print $notnulltext;
print_textarea_readonly($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['textarea'][$fieldname]['rows'], $fields['other']['textarea'][$fieldname]['cols'], $fields['other']['inputcols'], $notnulltext);
break;
case 'view':
print_text_text($html_etc[$tablename][$fieldname] . ":", nl2br(stripslashes(trim($fields['value'][$fieldname]))));
break;
}
break;
case 'readonlymulti':
switch ($mode) {
case 'edit':
//print_R($fields['other']['textarea']);
//print $notnulltext;
print_textarea_mluti_readonly($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['textarea'][$fieldname]['rows'], $fields['other']['textarea'][$fieldname]['cols'], $fields['other']['inputcols'], $notnulltext);
break;
}
break;
case 'password':
case 'password_simple':
switch ($mode) {
case 'add':
case 'edit':
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'] + 4, $fields['other']['inputcols'], $fields['other']['class'], "", 'password');
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", "******", $colspan);
break;
}
break;
case 'textarea':
switch ($mode) {
case 'add':
case 'edit':
//print_R($fields['other']['textarea']);
print_textarea($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['textarea'][$fieldname]['rows'], $fields['other']['textarea'][$fieldname]['cols'], $fields['other']['inputcols'], $notnulltext, $fields['other']['textarea'][$fieldname]['other']);
break;
case 'view':
print_text_text($html_etc[$tablename][$fieldname] . ":", nl2br(stripslashes(trim($fields['value'][$fieldname]))));
break;
}
break;
case 'spacetime':
switch ($mode) {
case 'add':
case 'edit':
print_select_spacetime($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
case 'view':
print_select_spacetime($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
}
break;
case 'htmlarea':
switch ($mode) {
case 'add':
case 'edit':
print_htmlarea($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['textarea']['rows'], $fields['other']['textarea']['cols'], $fields['other']['inputcols']);
break;
case 'view':
print_text_html($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]));
break;
}
break;
case 'idtoname_user':
switch ($mode) {
case 'add':
case 'edit':
break;
case 'view':
$filtervalue = idtoname(trim($fields['value'][$fieldname]), 'user');
print_text_tr($html_etc[$tablename][$fieldname] . ":", $filtervalue, $colspan);
break;
}
break;
case 'purview':
switch ($mode) {
case 'add':
case 'edit':
print_purview($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['textarea']['rows'], $fields['other']['textarea']['cols'], $fields['other']['inputcols']);
break;
case 'view':
break;
}
break;
case 'avatar':
switch ($mode) {
case 'add':
case 'edit':
print_avatar($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols'], $fields['other']['class'], "");
break;
case 'view':
print_text_avatar($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), 2);
break;
}
break;
case 'file':
switch ($mode) {
case 'add':
print_file($html_etc[$tablename][$fieldname] . ":", $fieldname);
break;
case 'edit':
//print_file($html_etc[$tablename][$fieldname].":",$fieldname);
break;
case 'view':
break;
}
break;
case 'singlefile':
switch ($mode) {
case 'add':
print_singlefile($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'edit':
print_singlefile($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'view':
$var_value = trim($fields['value'][$fieldname]);
if ($var_value != "") {
$var_value = ereg_replace("&", "&", $var_value);
//print $var_value;
$parse_url = parse_url($var_value);
$query = $parse_url['query'];
parse_str($query, $output);
$attachmentid = $output['attachmentid'];
$attachmentname = $output['attachmentname'];
//$attachmentid = $output['attachmentname'];
//print_R($parse_url);
$filename_newfile = "../../attachment/{$attachmentid}/{$attachmentname}";
if (is_file($filename_newfile)) {
$filtervalue = trim($fields['value'][$fieldname]);
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filtervalue = "<a href='" . $filtervalue . "'>{$filename}</a>";
}
}
//print $downloadfile = trim($fields['value'][$fieldname]);
//if(is_file($downloadfile)) {
//print $file_path="<img src=\"../../Framework/images/downloads.gif\" border=0 width=172>\n";
//print "<a href='$downloadfile'>下载文件</a>";
//$nopicture_path="<img src=\"images/logo_sndg.gif\" border=0 width=172>\n";
//is_file(trim($fields['value'][$fieldname]))?$system_picture_line=$file_path:$system_picture_line=$nopicture_path;
//}
print_text_tr($html_etc[$tablename][$fieldname] . ":", $filtervalue);
break;
}
//idnumfile
break;
case 'picturefile':
switch ($mode) {
case 'add':
print_picturefile($html_etc[$tablename][$fieldname] . ":", $fieldname, '', $fields['other']['inputsize']);
break;
case 'edit':
print_picturefile($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'view':
$PicturePath = $fields['value'][$fieldname];
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;
}
$file_path = "<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 {
$file_path = "";
}
print_image_view($html_etc[$tablename][$fieldname], $file_path, $width = '120');
break;
}
//idnumfile
break;
case 'tdoafile':
require_once 'lib/utility_file.php';
//print $fields['other']['inputcols'];
switch ($mode) {
case 'add':
print_tdoafile($html_etc[$tablename][$fieldname] . ":", $fieldname, '', $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'edit':
print_tdoafile($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'view':
//形成通达OA下载文件所需要的变量格式
$var_value_array = explode('||', $fields['value'][$fieldname]);
$ATTACHMENT_ID = $var_value_array[1];
$ATTACHMENT_NAME = $var_value_array[0];
if (strlen($fields['value'][$fieldname]) < 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}\">";
print_image_view($html_etc[$tablename][$fieldname], $file_path, $width = '120', $fields['other']['inputcols']);
break;
}
//idnumfile
break;
case 'binaryfile':
switch ($mode) {
case 'add':
print_binaryfile($html_etc[$tablename][$fieldname] . ":", $fieldname, $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'edit':
print_binaryfile($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['other']['inputsize'], $fields['other']['inputcols']);
break;
case 'view':
global $sessionkey;
$filepath = trim($fields['value'][$fieldname]);
if (is_file($filepath)) {
$file_path = "<img src=\"{$filepath}\" border=0 width=172>\n";
} else {
$file_path = "<img src=\"images/logo_sndg.gif\" border=0 width=172>\n";
}
print_text_tr($html_etc[$tablename][$fieldname] . ":", $file_path, $colspan);
break;
}
//idnumfile
break;
case 'idnumfile':
switch ($mode) {
case 'view':
$file_path = "<img src=\"idnumimage/" . trim($fields['value'][$fieldname]) . ".jpg\" border=0 width=172>\n";
$nopicture_path = "<img src=\"images/logo_sndg.gif\" border=0 width=172>\n";
is_file("idnumimage/" . trim($fields['value'][$fieldname]) . ".jpg") ? $system_picture_line = $file_path : ($system_picture_line = $nopicture_path);
break;
}
break;
case 'colorselect':
switch ($mode) {
case 'add':
case 'edit':
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
print_colorselect($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $notnulltext);
break;
case 'view':
print "<div style=\"border:1px double #000000;width:16px;height:16px;background-color:" . $fields['value'][$fieldname] . ";overflow:hidden;\"></div>";
break;
}
break;
case 'date0':
switch ($mode) {
case 'add':
case 'edit':
print_date_js();
print_date($html_etc[$tablename][$fieldname] . ":", $fieldname, "./sms_index/calendar_begin.php?datetime={$fieldname}", trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $notnulltext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returndate(trim($fields['value'][$fieldname]), 1));
break;
}
break;
case 'date':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = date("Y-m-d");
case 'edit':
print_date_js();
print_date($html_etc[$tablename][$fieldname] . ":", $fieldname, "./sms_index/calendar_begin.php?datetime={$fieldname}", trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $notnulltext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returndate(trim($fields['value'][$fieldname]), 1));
break;
}
break;
case 'date1':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = date("Y-m-d", mktime(0, 0, 0, date(m) + 1, date(d), date(Y)));
case 'edit':
print_date_js();
print_date($html_etc[$tablename][$fieldname] . ":", $fieldname, "./sms_index/calendar_begin.php?datetime={$fieldname}", trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $notnulltext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returndate(trim($fields['value'][$fieldname]), 1));
break;
}
break;
case 'datetime':
switch ($mode) {
case 'add':
if ($fields['value'][$fieldname] == '') {
$fields['value'][$fieldname] = date("Y-m-d H:i:s");
}
case 'edit':
$pattern = $fields['INPUT_TEXT'][$fieldname];
print_datetime($html_etc[$tablename][$fieldname] . ":", $fieldname, "./sms_index/calendar_begin.php?datetime={$fieldname}", trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $notnulltext, $pattern);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returndate(trim($fields['value'][$fieldname]), 1));
break;
}
break;
case 'datetime0':
switch ($mode) {
case 'add':
case 'edit':
print_date_js();
print_datetime($html_etc[$tablename][$fieldname] . ":", $fieldname, "./sms_index/calendar_begin.php?datetime={$fieldname}", trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $notnulltext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returndate(trim($fields['value'][$fieldname]), 1));
break;
}
break;
case 'datetimecheckbox':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = date("Y-m-d H:i:s");
case 'edit':
print_date_js();
print_datetimecheckbox($html_etc[$tablename][$fieldname] . ":", $fieldname, "./sms_index/calendar_begin.php?datetime={$fieldname}", trim($fields['value'][$fieldname]), $fields['other']['inputcols'], $notnulltext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returndate(trim($fields['value'][$fieldname]), 1));
break;
}
break;
case 'boolean':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['boolean'][$i]['value'];
case 'edit':
//$fields['value'][$fieldname]=1;
print_boolean($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $size = "25", $colspan = 2, "SmallSelect", $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returnboolean(trim($fields['value'][$fieldname])));
break;
}
break;
case 'select_sex':
case 'sex':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 1;
case 'edit':
print_sex($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), "SmallSelect", $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returnsex(trim($fields['value'][$fieldname])));
break;
}
break;
case 'checkbox':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
print_checkbox($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
case 'view':
print_checkbox($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
}
break;
case 'mulcheckbox':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
$subtablename = $fields['INPUT_TEXT'][$fieldname];
$subkey = $fields['inputsize'][$fieldname];
$subval = $fields['inputother'][$fieldname];
print_mulcheckbox($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $subtablename, $subkey, $subval);
break;
case 'view':
$subtablename = $fields['INPUT_TEXT'][$fieldname];
$subkey = $fields['inputsize'][$fieldname];
$subval = $fields['inputother'][$fieldname];
$subcolums = returntablecolumn($subtablename);
$subkey = $subcolums[$subkey];
$subval = $subcolums[$subval];
$fieldValueArray = explode(",", $fields['value'][$fieldname]);
array_pop($fieldValueArray);
$fieldValueArrayTEXT = join("','", $fieldValueArray);
$sql = "select {$subval} from {$subtablename} where {$subkey} in ('{$fieldValueArrayTEXT}')";
$rsxx = $db->CacheExecute(5, $sql);
$rsxxA = $rsxx->GetArray();
$fieldValueNameText = '';
for ($iD = 0; $iD < sizeof($rsxxA); $iD++) {
$fieldValueNameText .= $rsxxA[$iD][$subval] . ",";
}
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fieldValueNameText);
break;
}
break;
case 'radio':
switch ($mode) {
case 'add':
if ($fields['value'][$fieldname] == '') {
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
}
case 'edit':
print_radio($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], 2, $fields['select'][$i]['initvalue']);
break;
case 'view':
print_select_text($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $fieldname, $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field']);
break;
}
break;
case 'radiogroup':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
print_radio($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], 1, $fields['select'][$i]['initvalue'], $fields['select'][$i]['groupfield'], $fields['select'][$i]['groupvalue']);
break;
case 'view':
print_select_text($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $fieldname, $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], $fields['select'][$i]['groupfield'], $fields['select'][$i]['groupvalue']);
break;
}
break;
//JUMPUSERINFOR,弹出窗口的用户名和用户ID
//JUMPUSERINFOR,弹出窗口的用户名和用户ID
case 'usertoid':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
//$colspan = $fields['other']['inputcols'];
$fieldnameID = $fieldname . "_ID";
$fieldValueName = returntablefield("user", "USER_ID", $fieldValue, "USER_NAME");
$PRIV_OP = $fields['INPUT_TEXT'][$fieldname];
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectTeacherSingle('{$PRIV_OP}','{$fieldname}', '{$fieldnameID}')\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldname}', '{$fieldnameID}')\" title=\"清空\">清空</a>";
print " {$notnulltext}</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returntablefield("user", "USER_ID", $fields['value'][$fieldname], "USER_NAME"), $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//JUMPUSERINFOR,弹出窗口的用户名和用户ID
//JUMPUSERINFOR,弹出窗口的用户名和用户ID
case 'usertoname':
$colspan = 2;
//print_R($_GET);;
switch ($mode) {
case 'add':
$fieldValue = $_GET[$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
$fieldValueName = returntablefield("user", "USER_NAME", $fieldValue, "USER_ID");
$PRIV_OP = $fields['INPUT_TEXT'][$fieldname];
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectTeacherSingle('{$PRIV_OP}','{$fieldnameID}', '{$fieldname}')\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldnameID}', '{$fieldname}')\" title=\"清空\">清空</a>";
//print $addtext = FilterFieldAddText($addtext,$fieldname);
print "</TD></TR>\n";
break;
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
$fieldValueName = returntablefield("user", "USER_NAME", $fieldValue, "USER_ID");
$PRIV_OP = $fields['INPUT_TEXT'][$fieldname];
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectTeacherSingle('{$PRIV_OP}','{$fieldnameID}', '{$fieldname}','{$PRIV_OP}')\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldnameID}', '{$fieldname}')\" title=\"清空\">清空</a>";
//print $addtext = FilterFieldAddText($addtext,$fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//JUMPUSERLISTINFOR,弹出窗口的用户名和用户ID,多用户模式
//JUMPUSERLISTINFOR,弹出窗口的用户名和用户ID,多用户模式
case 'usertonamelist':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
$fieldValueArray = explode(",", $fieldValue);
for ($idddd = 0; $idddd < sizeof($fieldValueArray); $idddd++) {
$fieldValueArrayValue = $fieldValueArray[$idddd];
if ($fieldValueArrayValue != "") {
$fieldValueNameText .= returntablefield("user", "USER_ID", $fieldValueArrayValue, "USER_NAME") . ",";
}
}
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
//print "<input type=\"text\" name=\"$fieldnameID\" value=\"$fieldValueName\" readonly class=\"SmallStatic\" size=\"40\">\n";
print "<textarea style=\"width:380px;\" name=\"{$fieldnameID}\" id=\"{$fieldnameID}\" rows=\"3\" style=\"overflow-y:auto;\" class=\"BigStatic\" wrap=\"yes\" readonly>{$fieldValueNameText}</textarea>";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUser('" . $fields['INPUT_TEXT']['zhixingren'] . "','{$fieldname}', '{$fieldnameID}');\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldname}', '{$fieldnameID}')\" title=\"清空\">清空</a> ";
print " {$notnulltext}";
print "</TD></TR>\n";
break;
case 'view':
$fieldValueArray = explode(",", $fields['value'][$fieldname]);
$fields['value'][$fieldname] = '';
for ($idddd = 0; $idddd < sizeof($fieldValueArray); $idddd++) {
$fieldValueArrayValue = $fieldValueArray[$idddd];
if ($fieldValueArrayValue != "") {
$userInfo = returntablefield("user", "USER_ID", $fieldValueArrayValue, "UID,USER_NAME");
$fields['value'][$fieldname] .= "<a target='_blank' href='../Framework/user_newai.php?action=view_default&UID=" . $userInfo['UID'] . "'>" . $userInfo['USER_NAME'] . "</a>,";
}
}
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//JUMPDEPTINFOR,弹出窗口的部门名和部门ID
//JUMPDEPTINFOR,弹出窗口的部门名和部门ID
case 'depttoid':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
//$colspan = $fields['other']['inputcols'];
$fieldnameID = $fieldname . "_ID";
$fieldValueName = returntablefield("department", "DEPT_ID", $fieldValue, "DEPT_NAME");
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDeptSingle('','{$fieldname}', '{$fieldnameID}')\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldname}', '{$fieldnameID}')\" title=\"清空\">清空</a>";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", returntablefield("department", "DEPT_ID", $fields['value'][$fieldname], "DEPT_NAME"), $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//JUMPDEPTINFOR,弹出窗口的部门名和部门ID
//JUMPDEPTINFOR,弹出窗口的部门名和部门ID
case 'depttoname':
$colspan = 2;
switch ($mode) {
case 'add':
//print_R($_GET);
$fieldValue = $_GET[$fieldname];
$fieldValueName = returntablefield("department", "DEPT_NAME", $fieldValue, "DEPT_ID");
$fieldnameID = $fieldname . "_ID";
$showtext = $html_etc[$tablename][$fieldname];
$PRIV_OP = $fields['INPUT_TEXT'][$fieldname];
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDeptSingle('','{$fieldnameID}', '{$fieldname}','{$PRIV_OP}')\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldnameID}', '{$fieldname}')\" title=\"清空\">清空</a>";
//print $addtext = FilterFieldAddText($addtext,$fieldname);
print "</TD></TR>\n";
break;
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
$fieldValueName = returntablefield("department", "DEPT_NAME", $fieldValue, "DEPT_ID");
$PRIV_OP = $fields['INPUT_TEXT'][$fieldname];
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDeptSingle('','{$fieldnameID}', '{$fieldname}','{$PRIV_OP}')\">选择</a>\n";
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldnameID}', '{$fieldname}')\" title=\"清空\">清空</a>";
//print $addtext = FilterFieldAddText($addtext,$fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出课程的窗口
//弹出课程的窗口
case 'jumpcourse':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectCourseSingle('','{$fieldnameID}', '{$fieldname}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出教材的窗口
//弹出教材的窗口
case 'jumpjiaocai':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"25\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectAllInforSingle('../../Enginee/Module/jiaocai_admin_select_single/index.php','','{$fieldnameID}', '{$fieldname}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出客户的窗口
//弹出客户的窗口
case 'jumpkehu':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
$fieldValueNAME = returntablefield("customer", "ROWID", $fieldValue, "supplyname");
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValueNAME}\" readonly class=\"SmallStatic\" size=\"30\">\n";
print "<input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onClick=\"SelectAllInforSingle('../../Enginee/Module/kehu_select_single/index.php','','{$fieldnameID}', '{$fieldname}')\">\n";
print " " . $notnulltext;
print "</TD></TR>\n";
break;
case 'view':
$fieldValueNAME = returntablefield("customer", "ROWID", $fields['value'][$fieldname], "supplyname");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fieldValueNAME, $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出客户的多选窗口
//弹出客户的多选窗口
case 'jumpkehumulti':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldnameID = $fieldname . "_ID";
$fieldnameArray = explode(",", $fieldValue);
$fieldValueNAME = "";
for ($j = 0; $j < count($fieldnameArray); $j++) {
if ($fieldnameArray[$j] != '') {
$fieldValueNAME = $fieldValueNAME . returntablefield("customer", "ROWID", $fieldnameArray[$j], "supplyname") . ",";
}
}
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<textarea name='{$fieldnameID}' class=\"SmallInput\" rows=" . $fields['other']['textarea'][$fieldname]["rows"] . " cols=" . $fields['other']['textarea'][$fieldname]["cols"] . " readonly>{$fieldValueNAME}</textarea>";
print " " . $notnulltext . "<br>";
print "<a href='#' onClick=\"SelectAllInforSingle('../../Enginee/Module/kehu_select_multi/index.php','','{$fieldnameID}', '{$fieldname}')\"><u>选择客户</u></a>\n";
print "</TD></TR>\n";
break;
case 'view':
$fieldValueNAME = returntablefield("customer", "ROWID", $fields['value'][$fieldname], "supplyname");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fieldValueNAME, $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出客户联系人的多选窗口
//弹出客户联系人的多选窗口
case 'jumplinkmanmulti':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldnameID = $fieldname . "_ID";
$fieldnameArray = explode(",", $fieldValue);
$other = $fields['other']['textarea'][$fieldname]['other'];
for ($i = 0; $i < count($fieldnameArray); $i++) {
if ($fieldnameArray[$i] != '') {
$fieldValueNAME = $fieldValueNAME . returntablefield("linkman", "ROWID", $fieldnameArray[$i], "{$other}") . ",";
}
}
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<textarea name='{$fieldnameID}' class=\"SmallInput\" rows=" . $fields['other']['textarea'][$fieldname]["rows"] . " cols=" . $fields['other']['textarea'][$fieldname]["cols"] . " readonly>{$fieldValueNAME}</textarea>";
print " " . $notnulltext . "<br>";
print "<a href='#' onClick=\"SelectAllInforSingle('../../Enginee/Module/linkman_select_multi/index.php','','{$fieldnameID}', '{$fieldname}','{$other}')\"><u>选择客户联系人</u></a>\n";
print "</TD></TR>\n";
break;
case 'view':
$other = $fields['other']['textarea'][$FieldNameIndex]['other'];
$fieldValueNAME = returntablefield("linkman", "ROWID", $fields['value'][$fieldname], "{$other}");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fieldValueNAME, $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出供应商联系人的多选窗口
//弹出供应商联系人的多选窗口
case 'jumpsupplylinkmanmulti':
$colspan = 2;
$hasPriv = false;
$menuid = returntablefield("sys_function", "unimenu", "供应商", "func_Id");
$menuStr = explode(",", $_SESSION['LOGIN_FUNC_ID_STR']);
if (in_array($menuid, $menuStr)) {
$hasPriv = true;
}
if (!$hasPriv) {
continue;
}
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
$fieldnameID = $fieldname . "_ID";
$fieldnameArray = explode(",", $fieldValue);
$other = $fields['other']['textarea'][$fieldname]['other'];
for ($j = 0; $j < count($fieldnameArray); $j++) {
if ($fieldnameArray[$j] != '') {
$fieldValueNAME = $fieldValueNAME . returntablefield("supplylinkman", "ROWID", $fieldnameArray[$j], "{$other}") . ",";
}
}
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<textarea name='{$fieldnameID}' class=\"SmallInput\" rows=" . $fields['other']['textarea'][$fieldname]["rows"] . " cols=" . $fields['other']['textarea'][$fieldname]["cols"] . " readonly>{$fieldValueNAME}</textarea>";
print " " . $notnulltext . "<br>";
print "<a href='#' onClick=\"SelectAllInforSingle('../../Enginee/Module/supplylinkman_select_multi/index.php','','{$fieldnameID}', '{$fieldname}','{$other}')\"><u>选择供应商联系人</u></a>\n";
print "</TD></TR>\n";
break;
case 'view':
$other = $fields['other']['textarea'][$FieldNameIndex]['other'];
$fieldValueNAME = returntablefield("supplylinkman", "ROWID", $fields['value'][$fieldname], "{$other}");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fieldValueNAME, $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出供应商的单选窗口
//弹出供应商的单选窗口
case 'jumpsupply':
$colspan = 2;
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $_GET[$fieldname];
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
$fieldValueNAME = returntablefield("supply", "ROWID", $fieldValue, "supplyname");
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValueNAME}\" readonly class=\"SmallStatic\" size=\"30\">\n";
print "<input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onClick=\"SelectAllInforSingle('../../Enginee/Module/supply_select_single/index.php','','{$fieldnameID}', '{$fieldname}')\">\n";
print " " . $notnulltext . "</TD></TR>\n";
break;
case 'view':
$fieldValueNAME = returntablefield("supply", "ROWID", $fields['value'][$fieldname], "supplyname");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fieldValueNAME, $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出产品类别的窗口
//弹出产品类别的窗口
case 'jumpproducttype':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
if ($fields['INPUT_TEXT'][$fieldname] == '1') {
$rec_prod_id = $fields['value']['ROWID'];
}
//本身的主键，过滤到本身
$showfoldorsub = $fields['inputsize'][$fieldname];
//空=全部，1=仅显示文件夹，2=只能选择子类
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldValueName = returntablefield("producttype", "ROWID", $fieldValue, "name");
$fieldnameID = $fieldname . "_ID";
$notnull = trim($fields['null'][$i]['inputtype']);
$notnull == 'notnull' ? $notnulltext = $common_html['common_html']['mustinput'] : ($notnulltext = '');
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . ":</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\" readonly class=\"SmallStatic\" size=\"25\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectAllInforSingle('../../Enginee/Module/prodtype_select_single/index.php','{$rec_prod_id}','{$fieldname}', '{$fieldnameID}','{$showfoldorsub}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldnameID}', '{$fieldname}')\" title=\"清空\">清空</a>";
print " " . $notnulltext . "</TD></TR>\n";
print "</TD></TR>\n";
break;
case 'view':
$val = returntablefield("producttype", "rowid", $fields['value'][$fieldname], "name");
print_text_tr($html_etc[$tablename][$fieldname] . ":", $val, $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出产品窗口
//弹出产品窗口
case 'jumpproduct':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldValueName = returntablefield("product", "productid", $fieldValue, "productname");
$fieldnameID = $fieldname . "_ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . ":</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValueName}\" readonly class=\"SmallStatic\" size=\"30\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectAllInforSingle('../../Enginee/Module/product_select_single/index.php','{$fieldValue}','{$fieldname}', '{$fieldnameID}','{$showfoldorsub}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "<a href=\"#\" class=\"orgClear\" onClick=\"ClearUser('{$fieldnameID}', '{$fieldname}')\" title=\"清空\">清空</a>";
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出宿舍的窗口
//弹出宿舍的窗口
case 'jumpdorm':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$床位号 = $fields['value']['床位号'];
$性别 = $fields['value']['性别'];
$fieldValue = $fields['value'][$fieldname] . " " . $床位号 . "号床位";
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"30\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectAllInforSingle('../../Enginee/Module/dorm_room_admin_select_single/index.php','','{$fieldname}', '{$fieldnameID}','{$性别}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出班级的窗口
//弹出班级的窗口
case 'jumpbanji':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectBanJiSingle('','{$fieldnameID}', '{$fieldname}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出教室的窗口
//弹出教室的窗口
case 'jumpclassroom':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "_ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldname}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldnameID}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectClassroomSingle('','{$fieldname}', '{$fieldnameID}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
//弹出所有学生的窗口
//弹出所有学生的窗口
case 'jumpstudentall':
$colspan = 2;
switch ($mode) {
case 'add':
case 'edit':
$fieldValue = $fields['value'][$fieldname];
$showtext = $html_etc[$tablename][$fieldname];
$fieldnameID = $fieldname . "ID";
print "<TR>";
print "<TD class=TableData noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
print "<input type=\"hidden\" name=\"{$fieldnameID}\" value=\"{$fieldValue}\">\n";
print "<input type=\"text\" name=\"{$fieldname}\" value=\"{$fieldValue}\" readonly class=\"SmallStatic\" size=\"20\">\n";
print "<a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectAllStudentSingle('','{$fieldnameID}', '{$fieldname}')\">选择</a>\n";
print $addtext = FilterFieldAddText($addtext, $fieldname);
print "</TD></TR>\n";
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", $fields['value'][$fieldname], $colspan, $system_picture_line, $notnulltext);
break;
}
//idnumfile
break;
case 'select':
case 'selectcolor':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
print_select($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], $fields['other']['inputcols'], $fields['select'][$i]['setfieldname'], $fields['select'][$i]['setfieldvalue'], $fields['select'][$i]['setfieldboolean'], $fields['select'][$i]['initvalue']);
break;
case 'view':
if ($tablename == $fields['select'][$i]['tablename']) {
$showText = $html_etc[$tablename][$fields['select'][$i]['field']];
} else {
$showText = $html_etc[$tablename][$fieldname];
}
print_select_text($showText . ":", trim($fields['value'][$fieldname]), $fieldname, $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], $fieldfilter);
break;
}
break;
case 'selectpriv':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
print_selectpriv($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]));
break;
case 'view':
print_select_text($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $fieldname, "user_priv", "USER_PRIV", "PRIV_NAME");
break;
}
break;
case 'select2':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
$lastFieldName = $fields['name'][$i - 1];
print_select2($html_etc[$tablename][$lastFieldName] . ":", $fieldname, $fields['name'][$i - 1], trim($fields['value'][$fieldname]), $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field']);
break;
case 'view':
print_select_text($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]), $fieldname, $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field']);
break;
}
break;
case 'tablefilter6':
switch ($mode) {
case 'add':
print_select_four_address('', $tablename);
break;
case 'edit':
print_select_four_address($fields['value'], $tablename);
break;
}
break;
case 'tablefilter3':
switch ($mode) {
case 'add':
if (file_exists("../../Framework/system_config.ini")) {
$iniFile = parse_ini_file("../../Framework/system_config.ini");
} else {
if (file_exists("../Framework/system_config.ini")) {
$iniFile = parse_ini_file("../Framework/system_config.ini");
} else {
if (file_exists("Framework/system_config.ini")) {
$iniFile = parse_ini_file("Framework/system_config.ini");
}
}
}
print_select_countryCode($iniFile['provinces'], $fields);
break;
case 'edit':
$fieldname = $fields['name'][$i + 2];
print_select_countryCode($fields['value'][$fieldname], $fields);
break;
}
break;
case 'select_two':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
$fieldname2 = $fields['name'][$i + 1];
print_select_two($html_etc[$tablename][$fieldname] . ":", $fieldname, $html_etc[$tablename][$fieldname2] . ":", $fieldname2, trim($fields['value'][$fieldname]), $fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], $fields['select'][$i]['where'], $fields['select'][$i]['where_value'], $fields['select'][$i]['where_table'], $fields['select'][$i]['where_table_value'], $fields['select'][$i]['where_table_name'], 1, trim($fields['value'][$fieldname2]), $notnulltext);
break;
case 'view':
break;
}
break;
case 'select_select_input':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = $fields['select'][$i]['initvalue'];
case 'edit':
$fieldname2 = $fields['name'][$i + 1];
//print_select_menu_product($showtext,$showFieldName,$showFieldID,$showtext2,$showFieldName2,$showFieldValue,$tableName,$colspan=1)
print_select_menu_product($html_etc[$tablename][$fieldname] . ":", $fields['select'][$i]['field'], $fields['select'][$i]['value'], $html_etc[$tablename][$fieldname2] . ":", $fields['select'][$i]['secondIndexName'], trim($fields['value'][$fieldname]), $fields['select'][$i]['tablename'], $fieldname, $fieldname2, 2);
break;
case 'view':
break;
}
break;
case 'select_input':
switch ($mode) {
case 'add':
$filtervalue_name_backup_id = isset($_GET[$fieldname]) ? $_GET[$fieldname] : '';
$filtervalue_name_backup_name = isset($_GET[$fieldname . "name"]) ? $_GET[$fieldname . "name"] : '';
case 'edit':
$filtervalue_name = gettablefield($fields['select'][$i]['tablename'], $fields['select'][$i]['value'], $fields['select'][$i]['field'], trim($fields['value'][$fieldname]));
$filename = "frame_depart_notify.php?title=" . $common_html['common_html']['select_record'] . "&tablename=" . $fields['select'][$i]['tablename'] . "&fieldid=" . $fields['select'][$i]['value'] . "&fieldname=" . $fields['select'][$i]['field'] . "&field={$fieldname}&AddUserField=" . $fields['select'][$i]['userField'] . "";
//print $fields['select'][$i]['userField'];
$temp_id_name = trim($fields['value'][$fieldname]);
$filtervalue_id = isset($temp_id_name) ? $temp_id_name : $filtervalue_name_backup_id;
$filtervalue_name = isset($filtervalue_name) ? $filtervalue_name : $filtervalue_name_backup_name;
global $systemlang;
if ($filtervalue_name == '' && $tablename == 'notify') {
$filtervalue_name = $common_html['common_html']['AllDepartment'];
$filtervalue_id = '0';
}
select_form('input', $html_etc[$tablename][$fieldname] . ":", $fieldname, $fieldname . "name", $filename, $filtervalue_id, $filtervalue_name, $_GET['fixed']);
unset($filename);
break;
case 'view':
break;
}
break;
case 'select_textarea':
switch ($mode) {
case 'add':
if ($fields['select'][$i]['tablename'] != "" && $fields['select'][$i]['field'] != "" && $fields['select'][$i]['value'] != "") {
$filtervalue_name = idtoname(trim($fields['value'][$fieldname]), $mode = 'dept');
$filename = "frame_depart_notify.php?title=" . $common_html['common_html']['select_record'] . "&tablename=" . $fields['select'][$i]['tablename'] . "&type=1&fieldid=" . $fields['select'][$i]['value'] . "&fieldname=" . $fields['select'][$i]['field'] . "&field={$fieldname}";
} else {
$filtervalue_name = isset($filtervalue_name) ? $filtervalue_name : trim($fields['value'][$fieldname]);
$filename = "frame_user.php?title=" . $common_html['common_html']['select_record'] . "&TO_ID=" . $fieldname . "&TO_NAME=" . $fieldname . "name";
}
//print $fieldname;
$filtervalue_id = isset($_GET[$fieldname]) ? $_GET[$fieldname] . "," : '';
$filtervalue_name = isset($_GET[$fieldname . "name"]) ? $_GET[$fieldname . "name"] . "," : '';
select_form('textarea', $html_etc[$tablename][$fieldname] . ":", $fieldname, $fieldname . "name", $filename, $filtervalue_id, $filtervalue_name);
unset($filename);
break;
case 'edit':
switch ($_GET['action']) {
case 'edit_reply':
$fields['value'][$fieldname] = $global_hidden_field;
break;
case 'edit_forward':
$fields['value'][$fieldname] = '';
break;
}
if ($fields['select'][$i]['tablename'] != "" && $fields['select'][$i]['field'] != "" && $fields['select'][$i]['value'] != "") {
$filtervalue_name = idtoname(trim($fields['value'][$fieldname]), $mode = 'dept');
$filename = "frame_depart_notify.php?title=" . $common_html['common_html']['select_record'] . "&tablename=" . $fields['select'][$i]['tablename'] . "&type=1&fieldid=" . $fields['select'][$i]['value'] . "&fieldname=" . $fields['select'][$i]['field'] . "&field={$fieldname}";
} else {
$filtervalue_name = isset($filtervalue_name) ? $filtervalue_name : trim($fields['value'][$fieldname]);
$filename = "frame_user.php?title=" . $common_html['common_html']['select_record'] . "&TO_ID=" . $fieldname . "&TO_NAME=" . $fieldname . "name";
}
$temp_id_name = trim($fields['value'][$fieldname]);
$filtervalue_id = isset($temp_id_name) ? $temp_id_name : $filtervalue_name_backup_id;
$filtervalue_name = isset($filtervalue_name) ? $filtervalue_name : $filtervalue_name_backup_name;
select_form('textarea', $html_etc[$tablename][$fieldname] . ":", $fieldname, $fieldname . "name", $filename, $filtervalue_id, $filtervalue_name);
unset($filename);
break;
case 'view':
break;
}
break;
case 'select_sms':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 1;
case 'edit':
//$fields['value'][$fieldname]=1;
print_select_single($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 'select_sms', $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", return_select_filter('select_sms', trim($fields['value'][$fieldname])));
break;
}
break;
case 'select_education':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 5;
case 'edit':
//$fields['value'][$fieldname]=5;
print_select_single($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 'select_education', $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", return_select_filter('select_education', trim($fields['value'][$fieldname])));
break;
}
break;
case 'select_marriage':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 0;
case 'edit':
print_select_single($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 'select_marriage', $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", return_select_filter('select_marriage', trim($fields['value'][$fieldname])));
break;
}
break;
case 'select_politics':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 1;
case 'edit':
print_select_single($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 'select_politics', $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", return_select_filter('select_politics', trim($fields['value'][$fieldname])));
break;
}
break;
case 'select_worklog':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 1;
case 'edit':
print_select_single($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 'select_worklog', $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", return_select_filter('select_worklog', trim($fields['value'][$fieldname])));
break;
}
break;
case 'userlang':
switch ($mode) {
case 'add':
$fields['value'][$fieldname] = 'zh';
case 'edit':
print_select_single($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 'userlang', $addtext);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", return_select_filter('userlang', trim($fields['value'][$fieldname])));
break;
}
break;
case 'edit_move':
switch ($mode) {
case 'add':
select_return_navigation($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 1);
case 'edit':
select_return_navigation($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), 1);
break;
case 'view':
break;
}
break;
case 'mobile':
switch ($mode) {
case 'add':
case 'edit':
$inputsize = $fields['inputsize'][$fieldname];
if ($inputsize == "" || $inputsize == 0) {
$inputsize = $fields['other']['inputsize'];
}
print_tr($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $inputsize, $fields['other']['inputcols'], $fields['other']['class'], $notnulltext, 'text', '', $i + 1, "mobile");
$custom_type = "";
break;
case 'view':
$i < 5 ? $colspan = 2 : ($colspan = 2);
$i == 1 ? '' : ($system_picture_line = '');
$var = trim($fields['value'][$fieldname]);
$var = "<a href='../JXC/sms_sendlist_newai.php?action=add_default&sendlist=" . $var . "' target='_blank'>{$var}</a>";
print_text_tr($html_etc[$tablename][$fieldname] . ":", $var, $colspan);
break;
}
break;
case 'multiselect':
switch ($mode) {
case 'add':
print_select_classtable($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['multiselect'][$i]);
break;
case 'edit':
print_select_classtable($html_etc[$tablename][$fieldname] . ":", $fieldname, trim($fields['value'][$fieldname]), $fields['multiselect'][$i]);
break;
case 'view':
$filtervalue = idtoname($fields['value'][$fieldname], $mode = 'course');
print_text_tr($html_etc[$tablename][$fieldname] . ":", $filtervalue);
break;
}
break;
case 'hidden_field':
$hiddenid = $fields['hidden_field'][$i]['hiddenid'];
$hiddenname = $fieldname;
global $SUNSHINE_USER_NAME_VAR, $SUNSHINE_USER_DEPT_VAR, $SUNSHINE_USER_DEPT_VAR, $SUNSHINE_USER_ID_VAR, $_SESSION, $SUNSHINE_USER_DEPT_VAR;
switch ($fields['hidden_field'][$i]['hiddentype']) {
case 'dept':
$fields['value'][$fieldname] = $_SESSION['USER_DEPT'];
break;
case 'name':
$fields['value'][$fieldname] = $_SESSION['LOGIN_USER_ID'];
break;
case 'realname':
$fields['value'][$fieldname] = $_SESSION['LOGIN_USER_NAME'];
break;
case 'id':
$fields['value'][$fieldname] = $_SESSION['LOGIN_USER_ID'];
break;
case 'value':
$fields['value'][$fieldname] = $hiddenid;
break;
case 'get':
$fields['value'][$fieldname] = $_GET[$fieldname];
break;
case 'post':
$fields['value'][$fieldname] = $_POST[$fieldname];
break;
case 'field':
//$fields['value'][$fieldname]=$fields['value'][$fieldname];
break;
}
//print $SUNSHINE_USER_NAME_VAR;
//print $fields['value'][$fieldname];
switch ($mode) {
case 'add':
case 'edit':
switch ($_GET['action']) {
case 'edit_reply':
print_hidden($_SESSION[$SUNSHINE_USER_NAME_VAR], $hiddenname);
break;
case 'edit_forward':
print_hidden($fields['value'][$hiddenname], $hiddenname);
break;
default:
print_hidden($fields['value'][$hiddenname], $hiddenname);
}
break;
case 'view':
break;
}
$global_hidden_field = $fields['value'][$hiddenname];
break;
case 'system_datetime':
switch ($mode) {
case 'add':
case 'edit':
print_hidden(date("Y-m-d H:i:s"), $fieldname);
break;
case 'view':
print_text_tr($html_etc[$tablename][$fieldname] . ":", trim($fields['value'][$fieldname]));
break;
}
break;
case 'attchmentid':
switch ($mode) {
case 'add':
print_file($html_etc[$tablename][$fieldname] . ":", $fieldname);
break;
case 'edit':
$attachmentid_merge = trim($fields['value'][$fieldname]);
print_hidden($attachmentid_merge, $fieldname);
//print_file($html_etc[$tablename][$fieldname].":",$fieldname);
break;
case 'view':
break;
}
break;
case 'attchmentname':
switch ($mode) {
case 'add':
print_hidden('', $fieldname);
break;
case 'edit':
//判断文件所在路径
$PHP_SELF_ARRAY = explode('/', $_SERVER['PHP_SELF']);
$IndexNumber = sizeof($PHP_SELF_ARRAY) - 2;
$DirNameSelf = $PHP_SELF_ARRAY[$IndexNumber];
if ($DirNameSelf != "Framework") {
$DirFilePath = "../../Framework/";
} else {
$DirFilePath = "./";
}
//判断结束
$attachmentname_merge = trim($fields['value'][$fieldname]);
$fileurl = returnfileurl($attachmentid_merge, $attachmentname_merge);
$span = "<SPAN id=new_file></SPAN><BR>\n";
$index_html = $span . "<iframe name=uploadfile frameborder=0 width=100% height=40 scrolling=no src=" . $DirFilePath . "uploadfile.php></iframe>\n";
print_text_tr($html_etc[$tablename][$fieldname] . ":", $index_html);
print_hidden($attachmentname_merge, $fieldname);
print "<script>\n";
print "new_file.innerHTML+=\"{$fileurl}\";\n";
print "</script>\n";
break;
case 'view':
break;
}
break;
case 'userdefine':
switch ($mode) {
case 'add':
case 'edit':
$functionName = trim($fields['userdefine'][$i]);
$fileName = $functionName . ".php";
$fileName0 = "userdefine/{$fileName}";
$fileName = "../../Enginee/userdefine/{$fileName}";
if (file_exists($fileName0)) {
require_once $fileName0;
$functionName = $functionName . "_add";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields, $i);
print $filtervalue;
}
} else {
if (file_exists($fileName)) {
require_once $fileName;
$functionName = $functionName . "_add";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields, $i);
print $filtervalue;
} else {
print "函数名称[{$functionName}]不存在！";
}
} else {
print "没有相应文件,文件名：{$fileName}";
}
}
break;
case 'view':
if ($colflag == 0) {
$colspan = 5;
}
if ($colflag == 1 || $colflag == 0) {
print "<tr>\n";
}
$functionName = trim($fields['userdefine'][$i]);
$fileName = $functionName . ".php";
$fileName0 = "userdefine/{$fileName}";
$fileName = "../../Enginee/userdefine/{$fileName}";
if (file_exists($fileName0)) {
require_once $fileName0;
$functionName = $functionName . "_view";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields, $i);
print $filtervalue;
}
} else {
if (file_exists($fileName)) {
require_once $fileName;
$functionName = $functionName . "_view";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields, $i);
print $filtervalue;
} else {
print "函数名称[{$functionName}]不存在！";
}
} else {
print "没有相应文件,文件名：{$fileName}";
}
}
if ($colflag == 2 || $colflag == 0) {
print "</tr>\n";
}
break;
}
//end userdefine
}
//end switch
} else {
}
}
//光标定位
//print_R($fields['filter']);
for ($i = 0; $i < sizeof($fields['filter']); $i++) {
if ($fields['filter'][$i] == '') {
$index = $i;
break;
}
}
$focusname = $fields['name'][$index];
switch ($mode) {
case 'add':
case 'edit':
if ($focusname != "") {
print "<script>\n\t\tfunction Object_focus(Object)\n\t\t{\n\t\t var strFloat=Object.legth;\n\t\t Object.focus();\n\t\t}\n\t\tObject_focus(" . $fields['form']['name'] . "." . $focusname . ");\n\t\t</script>";
}
break;
case 'view':
break;
}
//记录子表选项列表模块
global $subtableArray;
//Foreign Key Value
$parent_value = $_GET[$primarykey_index];
if ($mode == "view") {
for ($i = 0; $i < sizeof($subtableArray); $i++) {
$mainkey2 = $subtableArray[$i]['maintable_key'];
if ($mainkey2 != '') {
$parent_valueX = returntablefield($tablename, $primarykey_index, $parent_value, $mainkey2);
} else {
$parent_valueX = $parent_value;
}
ViewChildTableList($subtableArray[$i], $parent_valueX);
}
}
//表单提交按钮部分模块
switch ($mode) {
case 'add':
case 'edit':
show_submit_element($action_submit, 'left');
// echo $action_submit;//by cwf
break;
case 'view':
show_submit_element($action_submit, 'left');
break;
}
table_end();
if ($form_attribute != 'hidden') {
form_end();
}
global $parse_filename, $tablename;
//用户自定义设计部分,此部分允许自己定义某些显示特性
$允许自定义的类型列表 = array("init_default", "init_customer", "add_default", "edit_default", "view_default");
if (in_array($_GET['action'], $允许自定义的类型列表) && $_SESSION['LOGIN_USER_ID'] == 'admin') {
if ($parse_filename == "") {
$parse_filename = $tablename;
}
$PHP_SELF_ARRAY = explode('/', $_SERVER['PHP_SELF']);
//print_R($PHP_SELF_ARRAY);
$FILE_SELF_NAME = array_pop($PHP_SELF_ARRAY);
$FileDirName = array_pop($PHP_SELF_ARRAY);
$是否是接口目录 = array_pop($PHP_SELF_ARRAY);
if ($是否是接口目录 == "Interface" && $FileDirName != "PGSQL") {
//print "<BR><div align=center><a href=\"../CONFIG/config.php?XX=XX&action=".$_GET['action']."&Tablename=$tablename&FileIniname=$parse_filename&FileDirName=$FileDirName&actionconfig=config&GOBACKFILENAME=$FILE_SELF_NAME\" title='配置当前页面显示参数 $执行时间TEXT'>配置当前页面显示参数</a> <a href=\"http://www.tongda2000.com/edu/book/index.php?action=add\" target=_blank title='将问题反馈给开发商进行解决'>问题反馈</a></div>";
}
}
}
