File: hierarchy_utils.php

package info (click to toggle)
fusionforge 5.3.2%2B20141104-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 60,472 kB
  • sloc: php: 271,846; sql: 36,817; python: 14,575; perl: 6,406; sh: 5,980; xml: 4,294; pascal: 1,411; makefile: 911; cpp: 52; awk: 27
file content (70 lines) | stat: -rw-r--r-- 2,504 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php
/*
 * Copyright 2004 (c) GForge LLC
 * Copyright 2006 (c) Fabien Regnier - Sogeti
 * Copyright 2011, Franck Villaume - Capgemini
 *
 * This file is part of FusionForge. FusionForge is free software;
 * you can redistribute it and/or modify it under the terms of the
 * GNU General Public License as published by the Free Software
 * Foundation; either version 2 of the Licence, or (at your option)
 * any later version.
 *
 * FusionForge is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with FusionForge; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 */

function link_box($group_id, $name, $selected = 'xzxzxz') {
	global $link;
	if (!$link) {
		$link = db_query_params('SELECT group_id,group_name,register_time FROM groups
					WHERE status=$1
					AND type_id=1
					AND group_id != $2
					AND group_id NOT IN (SELECT sub_project_id FROM plugin_projects_hierarchy WHERE project_id = $2 )
					AND group_id NOT IN (SELECT project_id FROM plugin_projects_hierarchy WHERE sub_project_id = $2 )
					AND group_id IN (select group_id from group_plugin,plugins where group_plugin.plugin_id = plugins.plugin_id and plugins.plugin_name = $3);',
					array('A', $group_id, 'projects-hierarchy'));
	}
	return html_build_select_box($link, $name, $selected, false);
}

function type_son_box() {
	return "<select name='link_type' onchange=\"javascript:
if(this.value!= 0){
document.formson.son.disabled=false
}
else {
document.formson.son.disabled=true
}\">
\n<option value='0' selected=\"selected\" >"._('Link Type')."</option>\n
<option value='shar'>"._('Share')."</option>\n
<option value='navi' >"._('Navigation')."</option>\n
</select>";
}

//search all the family,all ancestor
function get_family($group_id, $family = '', $cpt = 0){
	$res = db_query_params('SELECT project_id FROM plugin_projects_hierarchy WHERE sub_project_id = $1',
				array($group_id))
		or die(db_error());
	if (!$res || db_numrows($res) < 1) {
		//return $family;
	} else {
		$row = db_fetch_array($res);
		$family[$cpt] = $row['project_id'];
		$cpt++;
		return get_family($row['project_id'], $family, $cpt);
	}
	return $family;
}
// Local Variables:
// mode: php
// c-file-style: "bsd"
// End: