File: usersel.php

package info (click to toggle)
webcalendar 0.9.45-4sarge7
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 2,888 kB
  • ctags: 4,775
  • sloc: php: 16,990; sql: 1,272; perl: 777; sh: 120; makefile: 45
file content (105 lines) | stat: -rw-r--r-- 3,006 bytes parent folder | download
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php
include_once 'includes/init.php';

// input args in URL
// users: list of comma-separated users
// form: name of form on parent page
// listid: element id of user selection object in form
//   ... to be used like form.elements[$listid]
if ( empty ( $form ) ) {
  echo "Program Error: No form specified!"; exit;
}
if ( empty ( $listid ) ) {
  echo "Program Error: No listid specified!"; exit;
}

// parse $users
$exp = split ( ",", $users );
$selected = array ();
for ( $i = 0; $i < count ( $exp ); $i++ ) {
  $selected[$exp[$i]] = 1;
}

// load list of groups
if ( $user_sees_only_his_groups == "Y" ) {
  $sql =
    "SELECT webcal_group.cal_group_id, webcal_group.cal_name " .
    "FROM webcal_group, webcal_group_user " .
    "WHERE webcal_group.cal_group_id = webcal_group_user.cal_group_id " .
    "AND webcal_group_user.cal_login = '$login' " .
    "ORDER BY webcal_group.cal_name";
} else {
  // show all groups
  $sql = "SELECT cal_group_id, cal_name FROM webcal_group " .
    "ORDER BY cal_name";
}

$res = dbi_query ( $sql );
$groups = array ();
if ( $res ) {
  while ( $row = dbi_fetch_row ( $res ) ) {
    $groups[] = array (
      "cal_group_id" => $row[0],
      "cal_name" => $row[1]
      );
  }
  dbi_free_result ( $res );
}

$INC = array('js/usersel.php');
print_header($INC,'','',true);
?>

<center>
<form action="#">
<table style="border-width:0px; width:100%;">
<tr><td style="vertical-align:top;">
<b><?php etranslate("Users"); ?>:</b><br />
<select name="users" size="15" multiple="multiple">
<?php

$users = get_my_users ();
if ($nonuser_enabled == "Y" ) {
  $nonusers = get_nonuser_cals ();
  $users = ($nonuser_at_top == "Y") ? array_merge($nonusers, $users) : array_merge($users, $nonusers);
}

for ( $i = 0; $i < count ( $users ); $i++ ) {
  $u = $users[$i]['cal_login'];
  echo "<option value=\"$u\"";
  if ( ! empty ( $selected[$u] ) )
    echo " selected=\"selected\"";
  echo ">" . $users[$i]['cal_fullname'] . "</option>\n";
}
?>
</select><br />
<input type="button" value="<?php etranslate("All");?>" onclick="selectAll()" />
<input type="button" value="<?php etranslate("None");?>" onclick="selectNone()" />
<input type="reset" value="<?php etranslate("Reset");?>" />
</td>

<td valign="top">
<b><?php etranslate("Groups"); ?>:</b><br />
<select name="groups" size="15">
<?php
for ( $i = 0; $i < count ( $groups ); $i++ ) {
  echo "<option value=\"" . $groups[$i]['cal_group_id'] .
      "\">" . $groups[$i]['cal_name'] . "</option>\n";
}
?>
</select><br />
<input type="button" value="<?php etranslate("Add");?>" onclick="selectGroupMembers();" />
<input type="button" value="<?php etranslate("Remove");?>" onclick="deselectGroupMembers();" />
</td></tr>

<tr><td style="text-align:center;" colspan="2">
<br /><br />
<input type="button" value="<?php etranslate("Ok");?>" onclick="OkButton()" />
<input type="button" value="<?php etranslate("Cancel");?>" onclick="window.close()" />
</td></tr>

</table>

<?php print_trailer ( false, true, true ); ?>
</body>
</html>