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); }