1 <?php
3 class divListUsers extends MultiSelectWindow
4 {
6 /* Current base */
7 var $selectedBase = "";
8 var $departments = array();
10 /* Regex */
11 var $Regex = "*";
13 /* CheckBoxes */
14 var $ShowTemplates ;
15 var $ShowFunctionalUsers;
16 var $ShowUnixUsers;
17 var $ShowMailUsers;
18 var $ShowSambaUsers;
19 var $ShowProxyUsers;
21 /* Subsearch checkbox */
22 var $SubSearch = false;
24 var $parent ;
25 var $ui ;
27 function divListUsers ($config,$parent)
28 {
29 MultiSelectWindow::MultiSelectWindow($config, "Users", "users");
31 $this->parent = $parent;
32 $this->ui = get_userinfo();
34 /* Set list strings */
35 $this->SetTitle(_("List of users"));
36 $this->SetSummary(_("List of users"));
38 /* Result page will look like a headpage */
39 $this->SetHeadpageMode();
40 $this->SetInformation(_("This menu allows you to create, edit and delete selected users. Having a great number of users, you may want to use the range selectors on top of the user list."));
42 $this->EnableAplhabet (true);
44 /* Disable buttonsm */
45 $this->EnableCloseButton(false);
46 $this->EnableSaveButton (false);
48 /* Dynamic action col, depending on snapshot icons */
49 $action_col_size = 104;
50 if($this->parent->snapshotEnabled()){
51 $action_col_size += 38;
52 }
54 /* set Page header */
55 $this->AddHeader(array("string"=>" ", "attach"=>"style='width:20px;'"));
56 $this->AddHeader(array("string"=>_("Username")." / "._("Department")));
57 $this->AddHeader(array("string"=>_("Properties"), "attach" => "style='width:152px;'"));
58 $this->AddHeader(array("string"=>_("Actions"), "attach" => "style='width:".$action_col_size."px;border-right:0px;text-align:right;'"));
60 $this->AddCheckBox("ShowTemplates" ,_("Select to see template pseudo users") ,_("Show templates") , false);
61 $this->AddCheckBox("ShowFunctionalUsers",_("Select to see users that have only a GOsa object"),_("Show functional users") , true);
62 $this->AddCheckBox("ShowUnixUsers" ,_("Select to see users that have posix settings") ,_("Show unix users") , true);
63 $this->AddCheckBox("ShowMailUsers" ,_("Select to see users that have mail settings") ,_("Show mail users") , true);
64 $this->AddCheckBox("ShowSambaUsers" ,_("Select to see users that have samba settings") ,_("Show samba users") , true);
65 $this->AddCheckBox("ShowProxyUsers" ,_("Select to see users that have proxy settings") ,_("Show proxy users") , true);
67 /* Add SubSearch checkbox */
68 $this->AddCheckBox(SEPERATOR);
69 $this->AddCheckBox("SubSearch", _("Select to search within subtrees"), _("Ignore subtrees"), false);
71 /* Name ,Text ,Default , Connect with alphabet */
72 $this->AddRegex ("Regex", _("Display users matching"),"*" , true);
73 }
76 function GenHeader()
77 {
78 /* Prepare departments,
79 which are shown in the listbox on top of the listbox
80 */
81 $options= "";
82 #print_a($this->config->idepartments);
83 #$ui= get_userinfo();
84 #$t= $ui->get_module_departments("users");
85 #print_a($t);
88 /* Get all departments within this subtree */
89 $base = $this->config->current['BASE'];
90 $deps= get_list("(&(|(ou=*)(description=*))(objectClass=gosaDepartment))", $this->module, $base,
91 array("ou", "description"), GL_SIZELIMIT | GL_SUBSEARCH);
93 $ids = $this->config->idepartments;
95 foreach($deps as $dep){
96 if(isset($ids[$dep['dn']])){
98 $value = $ids[$dep['dn']];
99 if ($this->selectedBase == $dep){
100 $options.= "<option selected='selected' value='$dep'>$value</option>";
101 } else {
102 $options.= "<option value='$dep'>$value</option>";
103 }
104 }
105 }
107 /* Get copy & paste icon */
108 if($this->parent->CopyPasteHandler){
109 $Copy_Paste = $this->parent->CopyPasteHandler->generatePasteIcon();
110 }else{
111 $Copy_Paste ="";
112 }
114 /* Create header with selected base */
115 $listhead = "<div style='background:#F0F0F9;padding:5px;'>".
116 " <input class='center' type='image' src='images/list_root.png' align='middle'
117 title='"._("Go to root department")."' name='dep_root' alt='"._("Root")."'> ".
118 " <input class='center' type='image' align='middle' src='images/list_back.png'
119 title='"._("Go up one department")."' alt='"._("Up")."' name='dep_back'> ".
120 " <input class='center' type='image' align='middle' src='images/list_home.png'
121 title='"._("Go to users department")."' alt='"._("Home")."' name='dep_home'> ".
122 " <input class='center' type='image' src='images/list_reload.png' align='middle'
123 title='"._("Reload list")."' name='submit_department' alt='"._("Submit")."'> ".
124 " <img class='center' src='images/list_seperator.png' align='middle' alt='-' height='16' width='1'> ";
125 $listhead .= $this->get_snapshot_header($this->selectedBase);
126 $listhead .= " <input class='center' type='image' align='middle' src='images/list_new_user.png'
127 title='"._("Create new user")."' alt='"._("New user")."' name='user_new'> ".
128 " <input class='center' type='image' align='middle' src='images/list_new.png'
129 title='"._("Create new template")."' alt='"._("New template")."' name='user_tplnew'> ".
130 $Copy_Paste.
131 " <img class='center' src='images/list_seperator.png' align='middle' alt='-' height='16' width='1'> ".
132 _("Base")." <select name='CurrentMainBase' onChange='mainform.submit()' class='center'>$options</select>".
133 " <input class='center' type='image' src='images/list_submit.png' align='middle'
134 title='"._("Submit department")."' name='submit_department' alt='". _("Submit")."'> ".
135 "</div>";
137 $this->SetListHeader($listhead);
138 }
140 /* so some basic settings */
141 function execute()
142 {
143 $this->ClearElementsList();
144 $this->GenHeader();
145 }
147 function setEntries($list)
148 {
149 /********************
150 Variable init
151 ********************/
153 /* Variable initialation */
154 $enviro = $posix = $maila = $faxac = $samba = $netatalk = "";
155 $empty = "<img class='center' src='images/empty.png' style='width:16px;height:16px;' alt='-'>";
156 $userimg = "<img class='center' src='images/select_user.png' alt='User' title='%s'>";
157 $tplimg = "<img class='center' src='images/select_template.png' alt='Template' title='%s'>";
158 $editlink = "<a href='?plug=".validate($_GET['plug'])."&id=%s&act=edit_entry'>%s</a>";
160 /* Dynamic action col, depending on snapshot icons */
161 $action_col_size = 104;
162 if($this->parent->snapshotEnabled()){
163 $action_col_size += 38;
164 }
166 /* Possilbe objectClass image combinations */
167 $possibleAccounts = array(
168 "posixAccount" => array("VAR"=>"posix" ,"IMG"=>"posiximg"),
169 "gotoEnvironment" => array("VAR"=>"enviro" ,"IMG"=>"eviroimg"),
170 "gosaMailAccount" => array("VAR"=>"maila" ,"IMG"=>"mailimg"),
171 "goFaxAccount" => array("VAR"=>"faxac" ,"IMG"=>"faximg"),
172 "sambaSamAccount" => array("VAR"=>"samba" ,"IMG"=>"sambaimg"),
173 "apple-user" => array("VAR"=>"netatalk" ,"IMG"=>"netatalkimg"));
175 /* Pictures for Extensions */
176 $usrimg ="<input class='center' type='image' src='images/select_user.png' alt='"._("GOsa")."'
177 name='user_edit_%KEY%-user' title='"._("Edit generic properties")."'>";
178 $posiximg = "<input class='center' type='image' src='images/penguin.png' alt='"._("Posix")."'
179 name='user_edit_%KEY%-posixAccount' title='"._("Edit UNIX properties")."'>";
180 $eviroimg = "<input class='center' type='image' src='images/smallenv.png' alt='"._("Environment")."'
181 name='user_edit_%KEY%-environment' title='"._("Edit environment properties")."'>";
182 $mailimg = "<input class='center' type='image' src='images/mailto.png' alt='"._("Mail")."'
183 name='user_edit_%KEY%-mailAccount' title='"._("Edit mail properties")."'>";
184 $fonimg = "<input class='center' type='image' src='images/%image%' alt='"._("Phone")."'
185 name='user_edit_%KEY%-phoneAccount' title='"._("Edit phone properties")."%title%'>";
186 $faximg = "<input class='center' type='image' src='images/fax_small.png' alt='"._("Fax")."'
187 name='user_edit_%KEY%-gofaxAccount' title='"._("Edit fax properies")."'>";
188 $sambaimg = "<input class='center' type='image' src='images/select_winstation.png' alt='"._("Samba")."'
189 name='user_edit_%KEY%-sambaAccount' title='"._("Edit samba properties")."'>";
190 $netatalkimg = "<input class='center' type='image' src='images/select_netatalk.png' alt='"._("Netatalk")."'
191 name='user_edit_%KEY%-netatalk' title='"._("Edit netatalk properties")."'>";
192 $tplcreateuserimg = "<input type='image' class='center' src='images/list_new.png' alt='"._("Create user from template")."'
193 name='userfrom_tpl_%KEY%' title='"._("Create user with this template")."'>";
195 /********************
196 END :: Variable init
197 ********************/
199 /* Get Configuration for goFon DB (if it is set), to connect to the asterisk tables.
200 * Read Sip Table for specified account (for each user with phoneAccount).
201 * Check the attributes ip port and regseconds.
202 * If regseconds is set and >0 , the phone is logged in.
203 * Else the phone is currently not logged.
204 * If we can't read any Data from the DB or there is no goFon DB specified
205 * show old style without status icons.
206 */
207 $r_db =false;
208 $r_con =false;
209 if (isset($_SESSION['config']->data['SERVERS']['FON'])){
210 $a_SETUP= $_SESSION['config']->data['SERVERS']['FON'];
211 $r_con = false;
212 $r_db = false;
213 if(is_callable("mysql_pconnect")){
214 $r_con= @mysql_pconnect($a_SETUP['SERVER'],$a_SETUP['LOGIN'],$a_SETUP['PASSWORD']);
215 // Check if we are connected correctly
216 if($r_con){
217 $r_db = @mysql_select_db($a_SETUP['DB'],$r_con);
218 }
219 }
220 }
223 /********************
224 Append entries to divlist
225 ********************/
227 // Test Every Entry and generate divlist Array
228 foreach($list as $key => $val){
230 /* Create action icons */
231 $action= "";
232 if($this->parent->CopyPasteHandler){
233 $action .= "<input class='center' type='image'
234 src='images/editcut.png' alt='"._("cut")."' name='cut_%KEY%' title='"._("Cut this entry")."'> ";
235 $action.= "<input class='center' type='image'
236 src='images/editcopy.png' alt='"._("copy")."' name='copy_%KEY%' title='"._("Copy this entry")."'> ";
237 }
238 $action.= "<input class='center' type='image' src='images/edit.png' alt='"._("edit")."'
239 name='user_edit_%KEY%' title='"._("Edit user")."'>";
240 $action.= "<input class='center' type='image' src='images/list_password.png' alt='"._("password")."'
241 name='user_chgpw_%KEY%' title='"._("Change password")."'>";
242 $action.= $this->GetSnapShotActions($val['dn']);
243 $action.= "<input class='center' type='image' src='images/edittrash.png' alt='"._("delete")."'
244 name='user_del_%KEY%' title='"._("Delete user")."'>";
247 /* Create phonaccopunt informationm, if conencted && is phoneAccount */
248 $connected = ""; // This string represents timestamp or offline status
249 $ip_port = ""; // String that will represent ip : port of the connected phone
250 if((in_array("goFonAccount" ,$val['objectClass']))){
252 /* Set defaults */
253 $fonac = preg_replace("/%image%/", "select_phone.png", $fonimg);
254 $fonac = preg_replace("/%KEY%/", "$key", $fonac);
255 $fonac = preg_replace("/%title%/", "", $fonac);
257 /* Database connection is ok ?*/
258 if(($r_db)&&(is_callable("mysql_query"))){
259 $res= @mysql_query("SELECT regseconds,name,port,ipaddr FROM ".$a_SETUP['SIP_TABLE']." WHERE (name='".$val['uid'][0]."')");
260 $mysql_entry = @mysql_fetch_row($res);
261 if(is_array($mysql_entry)){
262 if((isset($mysql_entry[0]))&&($mysql_entry[0]>1)){
263 $connected = " | "._("Online")." : ".gmdate("d.m.Y H:i:s",($mysql_entry[0]+(60*60)));
264 $fonac = preg_replace("/%image%/", "select_phone_connected.png", $fonimg);
265 $fonac = preg_replace("/%KEY%/", "$key", $fonac);
266 $fonac = preg_replace("/%title%/", $connected, $fonac);
267 $ip_port= " - ".$mysql_entry[3].":".$mysql_entry[2];
268 }
269 if((isset($mysql_entry[0]))&&($mysql_entry[0]==0)){
270 $connected = " | "._("Offline");
271 $fonac = preg_replace("/%image%/", "select_phone.png", $fonimg);
272 $fonac = preg_replace("/%KEY%/", "$key", $fonac);
273 $fonac = preg_replace("/%title%/", $connected, $fonac);
274 }
275 }
276 }
277 }else{
278 $fonac=$empty;
279 }
281 /* Set images for different types of objectClasses */
282 foreach($possibleAccounts as $objectClass => $Settigns){
283 if(in_array($objectClass ,$val['objectClass'])){
284 $$Settigns['VAR'] = preg_replace("/%KEY%/", "$key", $$Settigns['IMG']);
285 }else{
286 $$Settigns['VAR'] = $empty;
287 }
288 }
290 /* Create userimg */
291 if(in_array("gosaUserTemplate",$val['objectClass'])){
292 $tpl = preg_replace("/%KEY%/", "$key", $tplimg);
293 $s_img_create_from_template = preg_replace("/%KEY%/", "$key", $tplcreateuserimg);
294 }else{
295 $s_img_create_from_template = "";
296 $tpl = $userimg;
297 }
299 /* Insert key into userimg */
300 $usrimg2 = preg_replace("/%KEY%/", "$key", $usrimg);
302 // Generate caption for rows
303 if (isset($val["sn"]) && isset($val["givenName"])){
304 $display= $val["sn"][0].", ".$val["givenName"][0]." [".$val["uid"][0]."]";
305 } else {
306 $display= "[".$val["uid"][0]."]";
307 }
309 /* Connect all images */
310 $UseImg = $usrimg2." ".$posix." ".$enviro." ".$maila." ".$fonac." ".$faxac." ".$samba." ".$netatalk;
312 /* Create each field */
313 $field1 = array("string" => sprintf($tpl,$val['dn']), "attach" => "style='text-align:center;width:20px;'");
314 $field2 = array("string" => sprintf($editlink,$key,$display).$ip_port, "attach" => "style='' title='".preg_replace('/ /', ' ', @LDAP::fix($val['dn']))."'");
315 $field3 = array("string" => $UseImg, "attach" => "style='width:152px;'");
316 $field4 = array("string" => $s_img_create_from_template.preg_replace("/%KEY%/", "$key", $action),
317 "attach" => "style='width:".$action_col_size."px;border-right:0px; text-align:right;'");
318 /* Add to list */
319 $add = array($field1,$field2,$field3,$field4);
320 $this->AddElement($add);
322 // Template or User
323 if(in_array("gosaUserTemplate",$val['objectClass'])){
324 $tpls[strtolower( $val['sn']['0'].$val['uid']['0'])]=$add;
325 }else{
326 $users[strtolower( $val['sn']['0'].$val['uid']['0'])]=$add;
327 }
328 }
330 /* close database connection, if it was opened */
331 if(isset($r_con)){
332 if((is_callable("mysql_close"))&&($r_con)){
333 @mysql_close($r_con);
334 }
335 }
337 }
339 function Save()
340 {
341 MultiSelectWindow :: Save();
342 }
344 function save_object()
345 {
346 /* Save automatic created POSTs like regex, checkboxes */
347 MultiSelectWindow::save_object();
348 }
349 }
350 // vim:tabstop=2:expandtab:shiftwidth=2:filetype=php:syntax:ruler:
351 ?>