function parent_group()
{
global $common_html, $db, $group_user, $_GET;
global $SUNSHINE_USER_NAME_VAR, $SUNSHINE_USER_ID_VAR, $_SESSION;
$group_array = return_parent_group();
//print_R($group_array['sql_text']);
$array_pop = array_pop($group_array['sql_text']);
switch ($db->databaseType) {
case 'mssql':
$select_text = "[" . join('],[', $group_array['sql_text']) . "]";
break;
case 'mysql':
default:
$select_text = join(',', $group_array['sql_text']);
break;
}
//end switch
$user_session = $_SESSION[$SUNSHINE_USER_NAME_VAR];
$parentvalue = isset($parentvalue) ? $parentvalue : $_GET[(string) $group_array['sql_text'][id]];
$parentvalue = isset($parentvalue) ? $parentvalue : 0;
$_GET['GROUP_TWO'] = isset($_GET['GROUP_TWO']) ? $_GET['GROUP_TWO'] : 0;
switch ($array_pop) {
case 'user':
break;
case 'group':
$temp_field = $group_array['sql_text'][user];
$user_session = $_GET[$temp_field];
$add_text_group = $group_array['sql_text'][user] . "=" . $user_session . "";
break;
default:
break;
}
//print_R($group_array);
//$sql="select $select_text from ".$group_array['tablename']." where ".$group_array['sql_text'][user]."='$user_session' and ".$group_array['sql_text'][parent]."='$parentvalue'";
switch ($db->databaseType) {
case 'mssql':
$sql = "select {$select_text} from [" . $group_array['tablename'] . "] where [" . $group_array['sql_text'][user] . "]='{$user_session}' and [" . $group_array['sql_text'][parent] . "]='{$parentvalue}'";
break;
case 'mysql':
default:
$sql = "select {$select_text} from " . $group_array['tablename'] . " where " . $group_array['sql_text'][user] . "='{$user_session}' and " . $group_array['sql_text'][parent] . "='{$parentvalue}'";
break;
}
//end switch
$rs = $db->Execute($sql);
$navigation = return_parent_group_all($group_array, $select_text, $user_session);
$navigation['index_name'][0] = 'Root';
$navigation_name = $_GET[(string) $group_array['sql_text'][id]];
$navigation_name = isset($navigation_name) ? $navigation_name : 0;
$nav_array = return_navigation($navigation, $navigation_name);
print "<TR bgColor='#FFFFFF' onMouseOut=bgColor='#FFFFFF' onMouseOver=bgColor='#E6F2FF'>\n";
print "<TD noWrap align=left colspan=32> \n";
for ($i = 0; $i < sizeof($nav_array); $i++) {
$return_parent = FormPageAction($group_array['sql_text'][id], $nav_array[$i]);
//$return_parent=returnpageaction($mode='group_filter',array('index_name'=>$group_array['sql_text'][id],'index_id'=>$nav_array[$i]));
//if($i!=sizeof($nav_array)-1) {
print "<a href=\"?{$return_parent}\">" . $navigation['index_name'][(string) $nav_array[$i]] . "</a> >> ";
//}
//else {
// print $navigation['index_name'][(string)$nav_array[$i]];
//}
}
print "</TD></TR>\n";
global $row_element;
while (!$rs->EOF) {
$counter++;
print "<TR bgColor='#FFFFFF' onMouseOut=bgColor='#FFFFFF' onMouseOver=bgColor='#E6F2FF'>\n";
print "<TD noWrap align=left colspan=32> \n";
//$return=returnpageaction($mode='group_filter',array('index_name'=>$group_array['sql_text'][id],'index_id'=>$rs->fields[(string)$group_array['sql_text'][id]]));
$return = FormPageAction($group_array['sql_text'][id], $rs->fields[(string) $group_array['sql_text'][id]]);
print "<a href=\"?{$return}\">" . $rs->fields[(string) $group_array['sql_text'][name]] . "</a>\n";
if ($row_element != '') {
print "¡¡[<a href='?action=edit_group&" . $group_array['sql_text'][id] . "=" . $rs->fields[(string) $group_array['sql_text'][id]] . "&" . $group_array['sql_text'][parent] . "=" . $rs->fields[(string) $group_array['sql_text'][parent]] . "&{$add_text_group}'>" . $common_html['common_html']['edit'] . "</a>\n";
print "<a href=\"javascript:if(confirm('" . $common_html['common_html']['reallydeletefolder'] . "'))location='?action=delete_group&" . $group_array['sql_text'][id] . "=" . $rs->fields[(string) $group_array['sql_text'][id]] . "&" . $group_array['sql_text'][parent] . "=" . $rs->fields[(string) $group_array['sql_text'][parent]] . "&{$add_text_group}'\">" . $common_html['common_html']['delete'] . "</a>]\n";
}
//end if--row_element
print "</TD>\n";
print "</TR>\n";
$rs->MoveNext();
}
}
function exist_group_user()
{
global $db, $group_user;
global $_GET, $_POST, $common_html;
global $fields;
global $SUNSHINE_USER_NAME_VAR, $SUNSHINE_USER_ID_VAR, $_SESSION;
DoReferer();
$group_user_array = explode(':', $group_user);
$parent_group = return_parent_group();
//print_R($parent_group);
$tablename = $group_user_array[0];
switch ($parent_group['sql_text']['type']) {
case 'group':
$temp_user_value = $_GET[(string) $parent_group['sql_text']['user']];
break;
default:
$temp_user_value = $_SESSION[$SUNSHINE_USER_NAME_VAR];
break;
}
$sql = "select count(" . $parent_group['sql_text'][parent] . ") as num from {$tablename} where " . $parent_group['sql_text'][parent] . "='" . $_GET[(string) $parent_group['sql_text'][parent]] . "' and " . $parent_group['sql_text'][user] . "='" . $temp_user_value . "'";
$rs = $db->Execute($sql);
//print $sql;exit;
if ($rs->fields[num] >= 1) {
print_infor($common_html['common_html']['notnullinfolder'], 'trip', "history.back();");
exit;
} else {
delete_array_newai($_GET[(string) $parent_group[parent]], $fields);
}
}
function show_new_element($action_model, $location_title = '')
{
global $common_html, $action_model, $_GET, $tablename;
global $group_user, $_SESSION;
//权限体系分配；
$USER_PRIV_ID = $_SESSION['SUNSHINE_USER_PRIV'];
$USER_PRIV = returntablefield("user_priv", "USER_PRIV", $USER_PRIV_ID, "PRIV_Name");
$action_model_array = explode(',', $action_model);
// var_dump($action_model_array);//by cwf ={'add_default','new','n'}
for ($i = 0; $i < sizeof($action_model_array); $i++) {
$model_index_array = explode(':', $action_model_array[$i]);
// var_dump($model_index_array);//---by cwf
$index_mid = $model_index_array[0];
//=add_default ---by cwf
$index = $model_index_array[1];
//=new ---by cwf
if ($index == 'export' && $_SESSION['LOGIN_USER_PRIV'] == 3) {
continue;
}
if ($index == '') {
$index_array = explode('_', $index_mid);
$index = $index_array[0];
}
//得到系统文件分配权限
$USER_PRIV_USER = $model_index_array[3];
if ($USER_PRIV_USER == "" || ($USER_PRIV_USER == $USER_PRIV || $USER_PRIV == '1' || $USER_PRIV == '2')) {
switch ($index) {
case 'set':
//$url="?action=".$index_mid."&table_name=$tablename&table_action=".$_GET['action'];
$actionValue = explode("_", $_GET['action']);
$actionValueText = "";
for ($m = 1; $m < sizeof($actionValue); $m++) {
$actionValueText .= "_" . $actionValue[$m];
}
$actionValueText = "set" . $actionValueText;
$return = FormPageAction("action", $actionValueText, "table_name", $tablename, '', "table_action", $_GET['action'], "returnmodel", $_GET['action']);
$url = "?" . $url;
break;
case 'setlang':
$url = "systemlang.php?action=init_default&tablename={$tablename}";
break;
case 'exportadv':
$return = FormPageAction("actionadv", $index_mid);
//$return=returnpageaction($mode='init_exportadv',array('index_name'=>'action','index_id'=>$index_mid));
$url = "?{$return}";
break;
case 'export':
$return = FormPageAction("action", $index_mid);
//$return=returnpageaction($mode='init_exportadv',array('index_name'=>'action','index_id'=>$index_mid));
$url = "?{$return}";
break;
default:
$group_array = return_parent_group();
//此函数在newai.php中定义
// var_dump($group_array);//返回group_user相关的信息 ---by cwf
if (sizeof($group_array['sql_text']) > 1) {
$temp_get_parent = isset($_GET[(string) $group_array['sql_text']['parent']]) ? $_GET[(string) $group_array['sql_text']['parent']] : 0;
$temp_get = $_GET[(string) $group_array['sql_text']['id']];
$temp_get = isset($temp_get) ? $temp_get : 0;
switch ($group_array['sql_text']['type']) {
case 'group':
$sql_text_user = $group_array['sql_text']['user'] . "=" . $_GET[(string) $group_array['sql_text']['user']];
break;
case 'user':
$sql_text_user = '';
break;
default:
$sql_text_user = '';
break;
}
} else {
//$return=FormPageAction("action",$index_mid);
//exit($return);
$return = base64_encode("action=" . $index_mid);
//$return=returnpageaction($mode='init_add',array('index_name'=>'action','index_id'=>$index_mid));
$url = "?{$return}";
}
break;
}
//if($index!='init')
$array[$i]['value'] = " " . $common_html['common_html'][$index] . " ";
$array[$i]['title'] = " " . $common_html['common_html'][$index] . " ";
$array[$i]['url'] = $url;
$array[$i]['shortcut'] = $model_index_array[2];
$array[$i]['class'] = 'SmallButton';
//}
}
//end switch
}
//end 用户权限划分
//系统调试模式
global $systemmode;
if ($systemmode == 'test') {
$array[$i + 1]['value'] = " " . $common_html['common_html']['setlang'] . " ";
$array[$i + 1]['title'] = " " . $common_html['common_html']['setlang'] . " ";
$array[$i + 1]['url'] = "systemlang_newai.php?action=init_default&tablename={$tablename}";
$array[$i + 1]['shortcut'] = 't';
$array[$i + 1]['class'] = 'SmallButton';
}
// print_R($array);
print_new_element_array($array, $location_title);
}
