[795] | 1 | <?php |
---|
| 2 | |
---|
| 3 | /** |
---|
| 4 | * @package Workflow |
---|
| 5 | * @license http://www.gnu.org/copyleft/gpl.html GPL |
---|
| 6 | * @author Sidnei Augusto Drovetto Jr. - drovetto@gmail.com |
---|
| 7 | */ |
---|
| 8 | class so_userinterface |
---|
| 9 | { |
---|
| 10 | /** |
---|
| 11 | * @var object database object |
---|
| 12 | * @access public |
---|
| 13 | */ |
---|
| 14 | var $db; |
---|
| 15 | |
---|
| 16 | /** |
---|
| 17 | * Constructor |
---|
| 18 | * @access public |
---|
| 19 | * @return object |
---|
| 20 | */ |
---|
| 21 | function so_userinterface() |
---|
| 22 | { |
---|
[2591] | 23 | $this->db =& Factory::getInstance('WorkflowObjects')->getDBWorkflow()->Link_ID; |
---|
[795] | 24 | $this->db->SetFetchMode(ADODB_FETCH_ASSOC); |
---|
| 25 | } |
---|
| 26 | |
---|
| 27 | /** |
---|
| 28 | * Obtain the subnet of an IP Address based on the numer of bits of the subnet |
---|
| 29 | * @param string $ip The IP Address |
---|
| 30 | * @param int $bits Number of bits of the subnet |
---|
| 31 | * @return string The subnet of the IP |
---|
| 32 | * @access private |
---|
| 33 | */ |
---|
| 34 | private function getSubnet($ip, $bits) |
---|
| 35 | { |
---|
| 36 | $octets = explode('.', $ip); |
---|
| 37 | $output = array(); |
---|
| 38 | for ($i = 0; $i < 4; $i++) |
---|
| 39 | { |
---|
| 40 | if ($bits >= 8) |
---|
| 41 | { |
---|
| 42 | $output[] = $octets[$i]; |
---|
| 43 | $bits -= 8; |
---|
| 44 | continue; |
---|
| 45 | } |
---|
| 46 | $output[] = $octets[$i] & bindec(str_repeat('1', $bits) . str_repeat('0',8 - $bits)); |
---|
| 47 | $bits = 0; |
---|
| 48 | } |
---|
| 49 | return implode('.', $output); |
---|
| 50 | } |
---|
| 51 | |
---|
| 52 | /** |
---|
| 53 | * Get External Applications |
---|
| 54 | * @access public |
---|
| 55 | * @return array list of external applications |
---|
| 56 | */ |
---|
| 57 | function getExternalApplications() |
---|
| 58 | { |
---|
| 59 | /* load the intranet subnetworks */ |
---|
| 60 | $oldDB = $GLOBALS['phpgw']->db; |
---|
| 61 | $GLOBALS['phpgw']->db = $GLOBALS['ajax']->db; |
---|
[2591] | 62 | $config = &Factory::getInstance('config', 'workflow'); |
---|
[795] | 63 | $configValues = $config->read_repository(); |
---|
| 64 | $submasksString = $configValues['intranet_subnetworks']; |
---|
| 65 | $GLOBALS['phpgw']->db = $oldDB; |
---|
| 66 | |
---|
| 67 | $userIP = getenv('REMOTE_ADDR'); |
---|
| 68 | if (getenv('HTTP_X_FORWARDED_FOR')) |
---|
| 69 | { |
---|
| 70 | $tmpIP = explode(',', getenv('HTTP_X_FORWARDED_FOR')); |
---|
| 71 | $userIP = $tmpIP[0]; |
---|
| 72 | } |
---|
| 73 | |
---|
| 74 | /* check if the user has access to intranet applications, i.e., is in the intranet */ |
---|
| 75 | $showIntranetApplications = false; |
---|
| 76 | $submasks = explode(';', $submasksString); |
---|
| 77 | foreach ($submasks as $submask) |
---|
| 78 | { |
---|
| 79 | list($ip,$bits) = explode('/', trim($submask) . '/32', 2); |
---|
| 80 | if ($this->getSubnet($ip, $bits) == $this->getSubnet($userIP, $bits)) |
---|
| 81 | { |
---|
| 82 | $showIntranetApplications = true; |
---|
| 83 | break; |
---|
| 84 | } |
---|
| 85 | } |
---|
| 86 | |
---|
| 87 | $preOutput = array(); |
---|
| 88 | $output = array(); |
---|
| 89 | |
---|
| 90 | /* select the sites that the user can access */ |
---|
| 91 | $externalApplicationsID = $GLOBALS['ajax']->acl->getUserGroupPermissions('APX', $_SESSION['phpgw_info']['workflow']['account_id']); |
---|
| 92 | if (!empty($externalApplicationsID)) |
---|
| 93 | { |
---|
[2591] | 94 | $result = Factory::getInstance('WorkflowObjects')->getDBGalaxia()->Link_ID->query("SELECT DISTINCT external_application_id, name, address, image, authentication, intranet_only FROM egw_wf_external_application WHERE (external_application_id IN (" . implode(', ', $externalApplicationsID) . ")) ORDER BY name"); |
---|
[795] | 95 | $preOutput = $result->GetArray(-1); |
---|
| 96 | |
---|
| 97 | /* keep only associative elments and check if the user can access an intranet application */ |
---|
| 98 | for ($i = 0; $i < count($preOutput); $i++) |
---|
| 99 | { |
---|
| 100 | if (($preOutput[$i]['intranet_only'] == '1') && (!$showIntranetApplications)) |
---|
| 101 | continue; |
---|
| 102 | |
---|
| 103 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 104 | unset($preOutput[$i][$j]); |
---|
| 105 | $output[] = $preOutput[$i]; |
---|
| 106 | } |
---|
| 107 | } |
---|
| 108 | |
---|
| 109 | return $output; |
---|
| 110 | } |
---|
| 111 | |
---|
| 112 | /** |
---|
| 113 | * Get User Organization ID |
---|
| 114 | * @param int $userID User identifier |
---|
| 115 | * @return mixed Informações sobre a organização ou false em caso de erro. |
---|
| 116 | * @access public |
---|
| 117 | */ |
---|
| 118 | function getUserOrganization($userID) |
---|
| 119 | { |
---|
| 120 | $query = "SELECT o.organizacao_id, o.nome, o.descricao, o.url_imagem, o.ativa FROM funcionario f, organizacao o WHERE (o.organizacao_id = f.organizacao_id) AND (f.funcionario_id = ?)"; |
---|
| 121 | $result = $this->db->query($query, array((int) $userID)); |
---|
| 122 | |
---|
| 123 | $output = $result->fetchRow(DB_FETCHMODE_ASSOC); |
---|
| 124 | if (!$output) |
---|
| 125 | return false; |
---|
| 126 | |
---|
| 127 | for ($i = 0; $i < $result->_numOfFields; $i++) |
---|
| 128 | unset($output[$i]); |
---|
| 129 | |
---|
| 130 | return $output; |
---|
| 131 | } |
---|
| 132 | |
---|
| 133 | /** |
---|
| 134 | * Get cost center list |
---|
| 135 | * @param int $organizationID The organization ID |
---|
| 136 | * @return array Lista de centros de custo |
---|
| 137 | * @access public |
---|
| 138 | */ |
---|
| 139 | function getCostCenters($organizationID) |
---|
| 140 | { |
---|
| 141 | $result = $this->db->query("SELECT nm_centro_custo, grupo, descricao FROM centro_custo WHERE (organizacao_id = ?) ORDER BY descricao", array($organizationID)); |
---|
| 142 | |
---|
| 143 | $output = $result->GetArray(-1); |
---|
| 144 | for ($i = 0; $i < count($output); $i++) |
---|
| 145 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 146 | unset($output[$i][$j]); |
---|
| 147 | |
---|
| 148 | return $output; |
---|
| 149 | } |
---|
| 150 | |
---|
| 151 | /** |
---|
| 152 | * Get hierarchical Area |
---|
| 153 | * @return array |
---|
| 154 | * @access public |
---|
| 155 | */ |
---|
| 156 | function getHierarchicalArea($organizationID, $parent = null, $depth = 0) |
---|
| 157 | { |
---|
| 158 | if (is_null($parent)){ |
---|
| 159 | $query = "SELECT a.area_id, a.sigla, a.titular_funcionario_id FROM area a"; |
---|
| 160 | $query .=" INNER JOIN area_status a_s ON (a_s.area_status_id = a.area_status_id)"; |
---|
| 161 | $query .=" WHERE (a.superior_area_id IS NULL) AND (a.organizacao_id = ?) AND (a.ativa = 'S') ORDER BY a_s.nivel, a.sigla"; |
---|
| 162 | $result = $this->db->query($query, array($organizationID)); |
---|
| 163 | } else { |
---|
| 164 | $query = "SELECT a.area_id, a.sigla, a.titular_funcionario_id FROM area a"; |
---|
| 165 | $query .=" INNER JOIN area_status a_s ON (a_s.area_status_id = a.area_status_id)"; |
---|
| 166 | $query .=" WHERE (a.superior_area_id = ?) AND (a.ativa = 'S') ORDER BY a_s.nivel, a.sigla"; |
---|
| 167 | $result = $this->db->query($query, array($parent)); |
---|
| 168 | } |
---|
| 169 | |
---|
| 170 | $output = $result->GetArray(-1); |
---|
| 171 | for ($i = 0; $i < count($output); $i++) |
---|
| 172 | { |
---|
| 173 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 174 | unset($output[$i][$j]); |
---|
| 175 | |
---|
| 176 | $output[$i]['children'] = $this->getHierarchicalArea($organizationID, $output[$i]['area_id'], $depth + 1); |
---|
| 177 | $output[$i]['depth'] = $depth; |
---|
| 178 | } |
---|
| 179 | |
---|
| 180 | return $output; |
---|
| 181 | } |
---|
| 182 | |
---|
| 183 | /** |
---|
| 184 | * Get organization area list |
---|
| 185 | * @return array |
---|
| 186 | * @access public |
---|
| 187 | */ |
---|
| 188 | function getAreaList($organizationID) |
---|
| 189 | { |
---|
| 190 | $result = $this->db->query("SELECT area_id, sigla FROM area WHERE (organizacao_id = ?) AND (ativa = 'S') ORDER BY sigla", array($organizationID)); |
---|
| 191 | |
---|
| 192 | $output = $result->GetArray(-1); |
---|
| 193 | for ($i = 0; $i < count($output); $i++) |
---|
| 194 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 195 | unset($output[$i][$j]); |
---|
| 196 | |
---|
| 197 | return $output; |
---|
| 198 | } |
---|
| 199 | |
---|
| 200 | /** |
---|
| 201 | * Get organization categories list |
---|
| 202 | * @param int $organizationID The organization ID |
---|
| 203 | * @return array The categories list |
---|
| 204 | * @access public |
---|
| 205 | */ |
---|
| 206 | function getCategoriesList($organizationID) |
---|
| 207 | { |
---|
| 208 | $output = $this->db->query('SELECT funcionario_categoria_id, descricao FROM funcionario_categoria WHERE (organizacao_id = ?)', array($organizationID))->GetArray(); |
---|
| 209 | $numerOfEmployees = $this->db->GetAssoc('SELECT COALESCE(f.funcionario_categoria_id, 0) AS funcionario_categoria_id, COUNT(*) FROM funcionario f, funcionario_status fs WHERE (f.organizacao_id = ?) AND (f.funcionario_status_id = fs.funcionario_status_id) AND (fs.exibir = \'S\') GROUP BY funcionario_categoria_id', array($organizationID)); |
---|
| 210 | |
---|
| 211 | $output[] = array( |
---|
| 212 | 'funcionario_categoria_id' => 0, |
---|
| 213 | 'descricao' => 'Sem Vínculo' |
---|
| 214 | ); |
---|
| 215 | |
---|
| 216 | foreach ($output as &$row) |
---|
| 217 | $row['contagem'] .= (isset($numerOfEmployees[$row['funcionario_categoria_id']]) ? $numerOfEmployees[$row['funcionario_categoria_id']] : 0); |
---|
| 218 | |
---|
| 219 | return $output; |
---|
| 220 | } |
---|
| 221 | |
---|
| 222 | /** |
---|
| 223 | * Get Area Employees |
---|
| 224 | * @param int $areaID |
---|
| 225 | * @param int $organizationID |
---|
| 226 | * @return array |
---|
| 227 | * @access public |
---|
| 228 | */ |
---|
| 229 | function getAreaEmployees($areaID, $organizationID) |
---|
| 230 | { |
---|
| 231 | $organizationID = (int) $organizationID; |
---|
| 232 | $areaID = (int) $areaID; |
---|
| 233 | |
---|
| 234 | /* gather some info from the area */ |
---|
[2056] | 235 | $areaInfo = $this->db->query('SELECT COALESCE(a.titular_funcionario_id, -1) AS titular_funcionario_id, COALESCE(s.funcionario_id, -1) AS substituto_funcionario_id FROM area a LEFT OUTER JOIN substituicao s ON ((a.area_id = s.area_id) AND (CURRENT_DATE BETWEEN s.data_inicio AND s.data_fim)) WHERE (a.organizacao_id = ?) AND (a.area_id = ?)', array($organizationID, $areaID))->GetArray(-1); |
---|
[795] | 236 | if (empty($areaInfo)) |
---|
| 237 | return false; |
---|
| 238 | $areaInfo = $areaInfo[0]; |
---|
| 239 | $supervisors = '{' . implode(', ', $areaInfo) . '}'; |
---|
| 240 | |
---|
| 241 | /* load the employees from the area */ |
---|
| 242 | $query = "SELECT f.funcionario_id, f.organizacao_id, f.area_id, COALESCE(f.funcionario_categoria_id, 0) AS funcionario_categoria_id FROM funcionario f, funcionario_status s WHERE ((f.area_id = ?) OR (f.funcionario_id = ANY (?))) AND (f.funcionario_status_id = s.funcionario_status_id) AND (s.exibir = ?)"; |
---|
| 243 | $result = $this->db->query($query, array($areaID, $supervisors, 'S')); |
---|
| 244 | |
---|
| 245 | $employees = $result->GetArray(-1); |
---|
[2591] | 246 | $cachedLDAP = Factory::newInstance('CachedLDAP'); |
---|
[1310] | 247 | $cachedLDAP->setOperationMode($cachedLDAP->OPERATION_MODE_NORMAL); |
---|
[795] | 248 | $categoriesCount = array(); |
---|
| 249 | for ($i = 0; $i < count($employees); $i++) |
---|
| 250 | { |
---|
| 251 | /* remove numeric fields */ |
---|
| 252 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 253 | unset($employees[$i][$j]); |
---|
| 254 | |
---|
| 255 | $employees[$i]['cn'] = ''; |
---|
| 256 | $employees[$i]['telephoneNumber'] = ''; |
---|
| 257 | if (in_array($employees[$i]['funcionario_id'], $areaInfo)) |
---|
| 258 | $employees[$i]['chief'] = ($employees[$i]['funcionario_id'] == $areaInfo['titular_funcionario_id']) ? 1 : 2; |
---|
| 259 | |
---|
| 260 | /* try to find the telephone number */ |
---|
| 261 | $entry = $cachedLDAP->getEntryByID($employees[$i]['funcionario_id']); |
---|
| 262 | if ($entry) |
---|
| 263 | { |
---|
| 264 | $employees[$i]['telephoneNumber'] = is_null($entry['telephonenumber']) ? '' : $entry['telephonenumber']; |
---|
| 265 | $employees[$i]['cn'] = is_null($entry['cn']) ? '' : $entry['cn']; |
---|
| 266 | $employees[$i]['removed'] = is_null($entry['last_update']); |
---|
| 267 | } |
---|
| 268 | |
---|
| 269 | /* count the number of employees in each category */ |
---|
| 270 | $categoryID = $employees[$i]['funcionario_categoria_id']; |
---|
| 271 | if (isset($categoriesCount[$categoryID])) |
---|
| 272 | $categoriesCount[$categoryID]++; |
---|
| 273 | else |
---|
| 274 | $categoriesCount[$categoryID] = 1; |
---|
| 275 | } |
---|
| 276 | $usedCategories = array_keys($categoriesCount); |
---|
| 277 | $availableCategories = $this->getCategoriesList($organizationID); |
---|
| 278 | $output = array(); |
---|
| 279 | $output['employees'] = $employees; |
---|
| 280 | $output['categories'] = array(); |
---|
| 281 | foreach ($availableCategories as $category) |
---|
| 282 | { |
---|
| 283 | if (!in_array($category['funcionario_categoria_id'], $usedCategories)) |
---|
| 284 | continue; |
---|
| 285 | |
---|
| 286 | $category['contagem'] = $categoriesCount[$category['funcionario_categoria_id']]; |
---|
| 287 | $output['categories'][] = $category; |
---|
| 288 | } |
---|
| 289 | |
---|
| 290 | usort($output['employees'], create_function('$a,$b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);')); |
---|
| 291 | |
---|
| 292 | return $output; |
---|
| 293 | } |
---|
| 294 | |
---|
| 295 | /** |
---|
| 296 | * Get employees from a specific category |
---|
| 297 | * @param int $categoryID The category ID |
---|
| 298 | * @param int $organizationID The organization ID |
---|
| 299 | * @return array The list o employees of that category |
---|
| 300 | * @access public |
---|
| 301 | */ |
---|
| 302 | function getCategoryEmployees($categoryID, $organizationID) |
---|
| 303 | { |
---|
| 304 | $organizationID = (int) $organizationID; |
---|
| 305 | |
---|
| 306 | /* load the employees from the area */ |
---|
| 307 | if ($categoryID == 0) |
---|
| 308 | { |
---|
| 309 | $query = "SELECT f.funcionario_id, f.organizacao_id, a.area_id, a.sigla AS area FROM funcionario f, funcionario_status s, area a WHERE (f.funcionario_status_id = s.funcionario_status_id) AND (f.area_id = a.area_id) AND (f.funcionario_categoria_id IS NULL) AND (s.exibir = ?) AND (f.organizacao_id = ?)"; |
---|
| 310 | $result = $this->db->query($query, array('S', $organizationID)); |
---|
| 311 | } |
---|
| 312 | else |
---|
| 313 | { |
---|
| 314 | $query = "SELECT f.funcionario_id, f.organizacao_id, a.area_id, a.sigla AS area FROM funcionario f, funcionario_status s, area a WHERE (f.funcionario_status_id = s.funcionario_status_id) AND (f.area_id = a.area_id) AND (f.funcionario_categoria_id = ?) AND (s.exibir = ?) AND (f.organizacao_id = ?)"; |
---|
| 315 | $result = $this->db->query($query, array((int)$categoryID, 'S', $organizationID)); |
---|
| 316 | } |
---|
| 317 | |
---|
| 318 | $employees = $result->GetArray(-1); |
---|
[2591] | 319 | $cachedLDAP = Factory::newInstance('CachedLDAP'); |
---|
[1310] | 320 | $cachedLDAP->setOperationMode($cachedLDAP->OPERATION_MODE_NORMAL); |
---|
[795] | 321 | for ($i = 0; $i < count($employees); $i++) |
---|
| 322 | { |
---|
| 323 | /* remove numeric fields */ |
---|
| 324 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 325 | unset($employees[$i][$j]); |
---|
| 326 | |
---|
| 327 | $employees[$i]['cn'] = ''; |
---|
| 328 | $employees[$i]['telephoneNumber'] = ''; |
---|
| 329 | |
---|
| 330 | /* try to find the telephone number */ |
---|
| 331 | $entry = $cachedLDAP->getEntryByID($employees[$i]['funcionario_id']); |
---|
| 332 | if ($entry) |
---|
| 333 | { |
---|
| 334 | $employees[$i]['telephoneNumber'] = is_null($entry['telephonenumber']) ? '' : $entry['telephonenumber']; |
---|
[2809] | 335 | $employees[$i]['cn'] = is_null($entry['cn']) ? '' : $entry['cn'] . (is_null($entry['last_update']) ? ' <font color="red">(inativo)</font>' : ''); |
---|
[795] | 336 | } |
---|
| 337 | } |
---|
| 338 | |
---|
| 339 | $output = array('employees' => $employees); |
---|
| 340 | return $output; |
---|
| 341 | } |
---|
| 342 | |
---|
| 343 | /** |
---|
[2085] | 344 | * Search Employee by Name |
---|
[795] | 345 | * @param int $searchTerm term to search |
---|
| 346 | * @param int $organizationID Id of organization |
---|
| 347 | * @return array employee data information |
---|
| 348 | * @access public |
---|
| 349 | */ |
---|
[2085] | 350 | function searchEmployeeByName($searchTerm, $organizationID) |
---|
[795] | 351 | { |
---|
[2085] | 352 | /* get ldap connection */ |
---|
[2591] | 353 | $ldap = &Factory::getInstance('WorkflowObjects')->getLDAP(); |
---|
[1446] | 354 | |
---|
[1465] | 355 | $searchTermExploded = explode(" ", $searchTerm); |
---|
| 356 | $fullSearch = false; |
---|
| 357 | |
---|
[2085] | 358 | if (count($searchTermExploded) > 0){ |
---|
| 359 | for ($i=1; $i<count($searchTermExploded); $i++) { |
---|
| 360 | if (strlen($searchTermExploded[$i]) > 2) { |
---|
[1465] | 361 | $fullSearch = true; |
---|
| 362 | } |
---|
| 363 | } |
---|
| 364 | |
---|
[2085] | 365 | if ($fullSearch){ |
---|
[1465] | 366 | $searchTerm = implode("*", $searchTermExploded); |
---|
| 367 | } |
---|
| 368 | } |
---|
| 369 | |
---|
[2085] | 370 | /* searching employees by name in the ldap server */ |
---|
[2591] | 371 | $list = @ldap_search($ldap, Factory::getInstance('WorkflowLDAP')->getLDAPContext(), ('(&(cn=*' . $searchTerm . '*)(phpgwaccounttype=u))'), array('uidNumber', 'cn', 'telephoneNumber')); |
---|
[795] | 372 | if ($list === false) |
---|
| 373 | return false; |
---|
| 374 | |
---|
[2085] | 375 | /* parsing ldap result */ |
---|
[795] | 376 | $entries = ldap_get_entries($ldap, $list); |
---|
[2085] | 377 | $ldapResult = array(); |
---|
| 378 | |
---|
[795] | 379 | for ($i = 0; $i < $entries['count']; $i++) |
---|
| 380 | $ldapResult[$entries[$i]['uidnumber'][0]] = array('cn' => $entries[$i]['cn'][0], 'telephoneNumber' => $entries[$i]['telephonenumber'][0]); |
---|
| 381 | |
---|
[2085] | 382 | /* no records found. bye. */ |
---|
| 383 | if (count($ldapResult) == 0) |
---|
| 384 | return array(); |
---|
| 385 | |
---|
[1446] | 386 | $uids = implode( ',', array_keys( $ldapResult ) ); |
---|
| 387 | |
---|
[2085] | 388 | /* searching for aditional employee information */ |
---|
| 389 | $query = "SELECT "; |
---|
| 390 | $query .= " f.funcionario_id AS funcionario_id, f.area_id AS area_id, a.sigla AS area "; |
---|
| 391 | $query .= " FROM "; |
---|
| 392 | $query .= " funcionario f "; |
---|
| 393 | $query .= " INNER JOIN "; |
---|
| 394 | $query .= " area a USING (area_id) "; |
---|
| 395 | $query .= " INNER JOIN "; |
---|
| 396 | $query .= " funcionario_status s ON ((f.funcionario_status_id = s.funcionario_status_id) AND (s.exibir = 'S')) "; |
---|
| 397 | $query .= " WHERE "; |
---|
| 398 | $query .= " (f.organizacao_id = ?) "; |
---|
| 399 | $query .= " AND "; |
---|
| 400 | $query .= " (f.funcionario_id IN ({$uids})) "; |
---|
[795] | 401 | |
---|
[2085] | 402 | $result = $this->db->query($query, array($organizationID))->GetArray(-1); |
---|
| 403 | $employees = array(); |
---|
[1446] | 404 | |
---|
[2085] | 405 | /* filling return array with employee's information */ |
---|
| 406 | for ($i = 0; $i < count($result); $i++) { |
---|
| 407 | $employees []= array( |
---|
| 408 | 'area' => $result[$i]['area'], |
---|
| 409 | 'area_id' => $result[$i]['area_id'], |
---|
| 410 | 'funcionario_id' => $result[$i]['funcionario_id'], |
---|
| 411 | 'cn' => $ldapResult[$result[$i]['funcionario_id']]['cn'], |
---|
| 412 | 'telephoneNumber' => empty($ldapResult[$result[$i]['funcionario_id']]['telephoneNumber']) ? '': $ldapResult[$result[$i]['funcionario_id']]['telephoneNumber'] |
---|
| 413 | ); |
---|
| 414 | } |
---|
[1446] | 415 | |
---|
[2085] | 416 | /* sorting by name (cn) */ |
---|
| 417 | $sort_function = create_function('$a, $b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);'); |
---|
| 418 | usort($employees, $sort_function ); |
---|
[1446] | 419 | |
---|
[2085] | 420 | return $employees; |
---|
| 421 | } |
---|
[1446] | 422 | |
---|
[2085] | 423 | /** |
---|
| 424 | * Search Employee by Area |
---|
| 425 | * @param int $searchTerm term to search |
---|
| 426 | * @param int $organizationID Id of organization |
---|
| 427 | * @return array employee data information |
---|
| 428 | * @access public |
---|
| 429 | */ |
---|
| 430 | function searchEmployeeByArea($searchTerm, $organizationID) |
---|
| 431 | { |
---|
| 432 | /* get ldap connection */ |
---|
[2591] | 433 | $ldap = &Factory::getInstance('WorkflowObjects')->getLDAP(); |
---|
[1446] | 434 | |
---|
[2085] | 435 | /* makes no sense search for an area if the string has more than one word */ |
---|
| 436 | if (count(explode(" ", $searchTerm)) > 1) |
---|
| 437 | return array(); |
---|
| 438 | |
---|
| 439 | /* searching for employees in areas that match 'searchTerm' */ |
---|
| 440 | $query = "SELECT "; |
---|
| 441 | $query .= " f.funcionario_id AS funcionario_id, f.area_id AS area_id, a.sigla AS area "; |
---|
| 442 | $query .= " FROM "; |
---|
| 443 | $query .= " funcionario f "; |
---|
| 444 | $query .= " INNER JOIN "; |
---|
| 445 | $query .= " area a USING (area_id) "; |
---|
| 446 | $query .= " INNER JOIN "; |
---|
| 447 | $query .= " funcionario_status s ON ((f.funcionario_status_id = s.funcionario_status_id) AND (s.exibir = 'S')) "; |
---|
| 448 | $query .= " WHERE "; |
---|
| 449 | $query .= " (f.organizacao_id = ?) "; |
---|
| 450 | $query .= " AND "; |
---|
| 451 | $query .= " (UPPER(a.sigla) LIKE UPPER(?)) "; |
---|
| 452 | |
---|
| 453 | $result = $this->db->query($query, array($organizationID, '%'.$searchTerm.'%'))->GetArray(-1); |
---|
| 454 | |
---|
| 455 | /* no records found. bye */ |
---|
| 456 | if (count($result) == 0) |
---|
| 457 | return array(); |
---|
| 458 | |
---|
| 459 | /* creating the ldap query */ |
---|
| 460 | $ldap_query = '(&(|'; |
---|
| 461 | for ($i = 0; $i < count($result); $i++) { |
---|
| 462 | $ldap_query .= '(uidNumber=' . $result[$i]['funcionario_id'] . ')'; |
---|
[795] | 463 | } |
---|
[2085] | 464 | $ldap_query .= ')(phpgwAccountType=u))'; |
---|
[795] | 465 | |
---|
[2085] | 466 | /* executing it */ |
---|
[2591] | 467 | $list = @ldap_search($ldap, Factory::getInstance('WorkflowLDAP')->getLDAPContext(), $ldap_query, array('uidNumber', 'cn', 'telephoneNumber')); |
---|
[2085] | 468 | $entries = ldap_get_entries($ldap, $list); |
---|
[1446] | 469 | |
---|
[2085] | 470 | /* parsing result */ |
---|
| 471 | $ldapResult = array(); |
---|
| 472 | for ($i = 0; $i < $entries['count']; $i++) |
---|
| 473 | $ldapResult[$entries[$i]['uidnumber'][0]] = array('cn' => $entries[$i]['cn'][0], 'telephoneNumber' => $entries[$i]['telephonenumber'][0]); |
---|
[1446] | 474 | |
---|
[2094] | 475 | /* we will need to search into database 'cache' for users deleted in ldap */ |
---|
[2591] | 476 | $cachedLDAP = Factory::newInstance( 'CachedLDAP' ); |
---|
[2094] | 477 | $cachedLDAP -> setOperationMode( $cachedLDAP -> OPERATION_MODE_DATABASE ); |
---|
| 478 | |
---|
[2085] | 479 | /* filling return array with employee's information */ |
---|
| 480 | $employees = array(); |
---|
| 481 | for ($i = 0; $i < count($result); $i++) { |
---|
[2094] | 482 | |
---|
| 483 | $employee = array(); |
---|
| 484 | |
---|
| 485 | /* user deleted in ldap. Let's try to find him into database 'cache' */ |
---|
| 486 | if (empty($ldapResult[$result[$i]['funcionario_id']]['cn'])) { |
---|
| 487 | $entry = $cachedLDAP->getEntryByID($result[$i]['funcionario_id']); |
---|
| 488 | |
---|
| 489 | $employee['removed'] = is_null($entry['last_update']); |
---|
| 490 | |
---|
| 491 | if ($entry && !empty($entry['cn'])) |
---|
| 492 | $employee['cn'] = $entry['cn']; |
---|
| 493 | /* we cant find it anywhere */ |
---|
| 494 | else |
---|
| 495 | $employee['cn'] = $result[$i]['funcionario_id']; |
---|
| 496 | } |
---|
| 497 | else |
---|
| 498 | $employee['cn'] = $ldapResult[$result[$i]['funcionario_id']]['cn']; |
---|
| 499 | |
---|
| 500 | $employee['area'] = $result[$i]['area']; |
---|
| 501 | $employee['area_id'] = $result[$i]['area_id']; |
---|
| 502 | $employee['funcionario_id'] = $result[$i]['funcionario_id']; |
---|
| 503 | $employee['telephoneNumber'] = empty($ldapResult[$result[$i]['funcionario_id']]['telephoneNumber']) ? '': $ldapResult[$result[$i]['funcionario_id']]['telephoneNumber']; |
---|
| 504 | |
---|
| 505 | $employees []= $employee; |
---|
[1446] | 506 | } |
---|
| 507 | |
---|
[2085] | 508 | /* sorting by name (cn) */ |
---|
| 509 | $sort_function = create_function('$a, $b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);'); |
---|
| 510 | usort($employees, $sort_function ); |
---|
[1446] | 511 | |
---|
[2085] | 512 | return $employees; |
---|
[795] | 513 | } |
---|
| 514 | |
---|
| 515 | /** |
---|
[2085] | 516 | * Search Employee by Telephone |
---|
| 517 | * @param int $searchTerm term to search |
---|
| 518 | * @param int $organizationID Id of organization |
---|
| 519 | * @return array employee data information |
---|
| 520 | * @access public |
---|
| 521 | */ |
---|
| 522 | function searchEmployeeByTelephone($searchTerm, $organizationID) |
---|
| 523 | { |
---|
| 524 | /* we will just excute it if we just get numbers and '-' */ |
---|
| 525 | if (!preg_match('/^[0-9-]+$/', $searchTerm)) |
---|
| 526 | return array(); |
---|
| 527 | |
---|
| 528 | /* get ldap connection */ |
---|
[2591] | 529 | $ldap = &Factory::getInstance('WorkflowObjects')->getLDAP(); |
---|
[2085] | 530 | |
---|
| 531 | /* searching employees by telephoneNumber in the ldap server */ |
---|
[2591] | 532 | $list = @ldap_search($ldap, Factory::getInstance('WorkflowLDAP')->getLDAPContext(), ('(&(telephoneNumber=*' . $searchTerm . '*)(phpgwaccounttype=u))'), array('uidNumber', 'cn', 'telephoneNumber')); |
---|
[2085] | 533 | |
---|
| 534 | if (!$list) return false; |
---|
| 535 | |
---|
| 536 | /* parsing ldap result */ |
---|
| 537 | $entries = ldap_get_entries($ldap, $list); |
---|
| 538 | $ldapResult = array(); |
---|
| 539 | |
---|
| 540 | for ($i = 0; $i < $entries['count']; $i++) |
---|
| 541 | $ldapResult[$entries[$i]['uidnumber'][0]] = array('cn' => $entries[$i]['cn'][0], 'telephoneNumber' => $entries[$i]['telephonenumber'][0]); |
---|
| 542 | |
---|
| 543 | /* no records found. bye. */ |
---|
| 544 | if (count($ldapResult) == 0) |
---|
| 545 | return array(); |
---|
| 546 | |
---|
| 547 | $uids = implode( ',', array_keys( $ldapResult ) ); |
---|
| 548 | |
---|
| 549 | /* searching for aditional employee information */ |
---|
| 550 | $query = "SELECT "; |
---|
| 551 | $query .= " f.funcionario_id AS funcionario_id, f.area_id AS area_id, a.sigla AS area "; |
---|
| 552 | $query .= " FROM "; |
---|
| 553 | $query .= " funcionario f "; |
---|
| 554 | $query .= " INNER JOIN "; |
---|
| 555 | $query .= " area a USING (area_id) "; |
---|
| 556 | $query .= " INNER JOIN "; |
---|
| 557 | $query .= " funcionario_status s ON ((f.funcionario_status_id = s.funcionario_status_id) AND (s.exibir = 'S')) "; |
---|
| 558 | $query .= " WHERE "; |
---|
| 559 | $query .= " (f.organizacao_id = ?) "; |
---|
| 560 | $query .= " AND "; |
---|
| 561 | $query .= " (f.funcionario_id IN ({$uids})) "; |
---|
| 562 | |
---|
| 563 | $result = $this->db->query($query, array($organizationID))->GetArray(-1); |
---|
| 564 | $employees = array(); |
---|
| 565 | |
---|
| 566 | /* filling return array with employee's information */ |
---|
| 567 | for ($i = 0; $i < count($result); $i++) { |
---|
| 568 | $employees []= array( |
---|
| 569 | 'area' => $result[$i]['area'], |
---|
| 570 | 'area_id' => $result[$i]['area_id'], |
---|
| 571 | 'funcionario_id' => $result[$i]['funcionario_id'], |
---|
| 572 | 'cn' => $ldapResult[$result[$i]['funcionario_id']]['cn'], |
---|
| 573 | 'telephoneNumber' => empty($ldapResult[$result[$i]['funcionario_id']]['telephoneNumber']) ? '': $ldapResult[$result[$i]['funcionario_id']]['telephoneNumber'] |
---|
| 574 | ); |
---|
| 575 | } |
---|
| 576 | |
---|
| 577 | /* sorting by name (cn) */ |
---|
| 578 | $sort_function = create_function('$a, $b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);'); |
---|
| 579 | usort($employees, $sort_function ); |
---|
| 580 | |
---|
| 581 | return $employees; |
---|
| 582 | } |
---|
| 583 | |
---|
| 584 | |
---|
| 585 | /** |
---|
[795] | 586 | * Busca informações sobre um funcionário. |
---|
| 587 | * @param array $params Uma array contendo o ID do funcionário cujas informações serão extraídas e de sua organização (Ajax). |
---|
| 588 | * @param int $employeeID O ID do funcionário. |
---|
| 589 | * @param int $organizationID O ID da organização. |
---|
| 590 | * @return array Informações sobre o funcionário. |
---|
| 591 | * @access public |
---|
| 592 | */ |
---|
| 593 | function getEmployeeInfo($employeeID, $organizationID) |
---|
| 594 | { |
---|
[2591] | 595 | $SOOrgchart = &Factory::getInstance('so_orgchart'); |
---|
[795] | 596 | $SOOrgchart->setExternalCalls(true); |
---|
| 597 | $output = $SOOrgchart->getEmployeeInfo($employeeID, $organizationID); |
---|
| 598 | $SOOrgchart->setExternalCalls(false); |
---|
| 599 | |
---|
| 600 | return $output; |
---|
| 601 | } |
---|
| 602 | |
---|
| 603 | /** |
---|
| 604 | * Busca informações sobre uma área. |
---|
| 605 | * @param array $params Uma array contendo o ID da área cujas informações serão extraídas e de sua organização (Ajax). |
---|
| 606 | * @param int $areaID O ID da área. |
---|
| 607 | * @param int $organizationID O ID da organização. |
---|
| 608 | * @return array Informações sobre a área. |
---|
| 609 | * @access public |
---|
| 610 | */ |
---|
| 611 | function getAreaInfo($areaID, $organizationID) |
---|
| 612 | { |
---|
[2591] | 613 | $SOOrgchart = &Factory::getInstance('so_orgchart'); |
---|
[795] | 614 | $SOOrgchart->setExternalCalls(true); |
---|
| 615 | $output = $SOOrgchart->getAreaInfo($areaID, $organizationID); |
---|
| 616 | $SOOrgchart->setExternalCalls(false); |
---|
| 617 | |
---|
| 618 | return $output; |
---|
| 619 | } |
---|
[1245] | 620 | |
---|
| 621 | /** |
---|
| 622 | * Get useful phones list |
---|
| 623 | * @param int $organizationID The organization ID |
---|
| 624 | * @return array Useful phones list |
---|
| 625 | * @access public |
---|
| 626 | */ |
---|
| 627 | function getUsefulPhones( $organizationID ) |
---|
| 628 | { |
---|
| 629 | $result = $this -> db -> query( "SELECT descricao, numero FROM telefone WHERE (organizacao_id = ?) ORDER BY descricao", array( $organizationID ) ); |
---|
| 630 | |
---|
| 631 | $output = $result->GetArray(-1); |
---|
| 632 | for ($i = 0; $i < count($output); $i++) |
---|
| 633 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 634 | unset($output[$i][$j]); |
---|
| 635 | |
---|
| 636 | return $output; |
---|
| 637 | } |
---|
| 638 | |
---|
| 639 | /** |
---|
| 640 | * Get areas with substitute boss |
---|
| 641 | * @param int $organizationID The organization ID |
---|
| 642 | * @return array areas with substitute boss |
---|
| 643 | * @access public |
---|
| 644 | */ |
---|
| 645 | function getAreaWithSubtituteBoss( $organizationID ) |
---|
| 646 | { |
---|
[2056] | 647 | $result = $this -> db -> query( "SELECT a.sigla as area, a.titular_funcionario_id as titular, s.funcionario_id as substituto, s.data_inicio, s.data_fim FROM area a INNER JOIN substituicao s ON ((a.area_id = s.area_id) AND (CURRENT_DATE BETWEEN s.data_inicio AND s.data_fim)) WHERE (organizacao_id = ?) ORDER BY area", array( $organizationID ) ); |
---|
[1245] | 648 | |
---|
[2591] | 649 | $cachedLDAP = Factory::newInstance( 'CachedLDAP' ); |
---|
[1245] | 650 | $cachedLDAP -> setOperationMode( $cachedLDAP -> OPERATION_MODE_LDAP_DATABASE ); |
---|
| 651 | |
---|
| 652 | $output = $result->GetArray(-1); |
---|
| 653 | for ( $i = 0; $i < count($output); $i++ ) |
---|
| 654 | { |
---|
| 655 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 656 | unset($output[$i][$j]); |
---|
| 657 | |
---|
| 658 | $entry = $cachedLDAP -> getEntryByID( $output[ $i ][ 'titular' ] ); |
---|
| 659 | if ( $entry && ( ! is_null( $entry[ 'cn' ] ) ) ) |
---|
| 660 | $output[ $i ][ 'titular' ] = $entry[ 'cn' ]; |
---|
| 661 | |
---|
| 662 | $entry = $cachedLDAP -> getEntryByID( $output[ $i ][ 'substituto' ] ); |
---|
| 663 | if ( $entry && ( ! is_null( $entry[ 'cn' ] ) ) ) |
---|
| 664 | $output[ $i ][ 'substituto' ] = $entry[ 'cn' ]; |
---|
[2042] | 665 | |
---|
| 666 | $output[$i]['data_inicio'] = implode('/', array_reverse(explode('-', $output[$i]['data_inicio']))); |
---|
| 667 | $output[$i]['data_fim'] = implode('/', array_reverse(explode('-', $output[$i]['data_fim']))); |
---|
[1245] | 668 | } |
---|
| 669 | |
---|
| 670 | return $output; |
---|
| 671 | } |
---|
[1266] | 672 | |
---|
| 673 | /** |
---|
| 674 | * Get manning list |
---|
| 675 | * @param int $organizationID The organization ID |
---|
| 676 | * @return array The manning list |
---|
| 677 | * @access public |
---|
| 678 | */ |
---|
| 679 | function getManning( $organizationID ) |
---|
| 680 | { |
---|
| 681 | $result = $this -> db -> query( 'SELECT localidade_id, descricao FROM localidade WHERE (organizacao_id = ?) ORDER BY descricao', array( $organizationID ) ); |
---|
| 682 | |
---|
| 683 | $output = $result->GetArray( -1 ); |
---|
| 684 | for ( $i = 0; $i < count($output); $i++ ) |
---|
| 685 | for ($j = 0; $j < $result->_numOfFields; $j++) |
---|
| 686 | unset($output[$i][$j]); |
---|
| 687 | |
---|
| 688 | return $output; |
---|
| 689 | } |
---|
| 690 | |
---|
| 691 | /** |
---|
| 692 | * Get employees from a specific location |
---|
| 693 | * @param int $categoryID The category ID |
---|
| 694 | * @param int $organizationID The organization ID |
---|
| 695 | * @return array The list o employees of that location |
---|
| 696 | * @access public |
---|
| 697 | */ |
---|
| 698 | function getManningEmployees( $locationID, $organizationID ) |
---|
| 699 | { |
---|
| 700 | $organizationID = ( int ) $organizationID; |
---|
| 701 | $locationID = ( int ) $locationID; |
---|
| 702 | |
---|
| 703 | // load the employees from the location |
---|
| 704 | $query = "SELECT f.funcionario_id, f.organizacao_id, f.area_id, a.sigla AS area," |
---|
| 705 | . " COALESCE(f.funcionario_categoria_id, 0) AS funcionario_categoria_id" |
---|
| 706 | . " FROM funcionario f, funcionario_status s, area a" |
---|
| 707 | . " WHERE (f.area_id = a.area_id)" |
---|
| 708 | . " AND (f.funcionario_status_id = s.funcionario_status_id)" |
---|
[1269] | 709 | . " AND (f.organizacao_id = ?)" |
---|
[1266] | 710 | . " AND (f.localidade_id = ?)" |
---|
| 711 | . " AND (s.exibir = ?)"; |
---|
| 712 | |
---|
[1269] | 713 | $result = $this -> db -> query( $query, array( $organizationID, $locationID, 'S' ) ); |
---|
[1266] | 714 | |
---|
| 715 | $employees = $result -> GetArray( -1 ); |
---|
[2591] | 716 | $cachedLDAP = Factory::newInstance( 'CachedLDAP' ); |
---|
[1310] | 717 | $cachedLDAP -> setOperationMode( $cachedLDAP -> OPERATION_MODE_NORMAL ); |
---|
[1266] | 718 | |
---|
| 719 | $categoriesCount = array( ); |
---|
| 720 | for ( $i = 0; $i < count( $employees ); $i++ ) |
---|
| 721 | { |
---|
| 722 | // remove numeric fields |
---|
| 723 | for ( $j = 0; $j < $result -> _numOfFields; $j++ ) |
---|
| 724 | unset( $employees[ $i ][ $j ] ); |
---|
| 725 | |
---|
| 726 | $employees[ $i ][ 'cn' ] = ''; |
---|
| 727 | $employees[ $i ][ 'telephoneNumber' ] = ''; |
---|
| 728 | |
---|
| 729 | // try to find the telephone number |
---|
| 730 | $entry = $cachedLDAP -> getEntryByID( $employees[ $i ][ 'funcionario_id' ] ); |
---|
| 731 | if ( $entry ) |
---|
| 732 | { |
---|
| 733 | $employees[ $i ][ 'telephoneNumber' ] = is_null( $entry[ 'telephonenumber' ] ) ? '' : $entry[ 'telephonenumber' ]; |
---|
| 734 | $employees[ $i ][ 'cn' ] = is_null( $entry[ 'cn' ] ) ? '' : $entry[ 'cn' ]; |
---|
| 735 | $employees[ $i ][ 'removed' ] = is_null( $entry[ 'last_update' ] ); |
---|
| 736 | } |
---|
| 737 | |
---|
| 738 | // count the number of employees in each category |
---|
| 739 | $categoryID = $employees[ $i ][ 'funcionario_categoria_id' ]; |
---|
| 740 | if ( isset( $categoriesCount[ $categoryID ] ) ) |
---|
| 741 | $categoriesCount[ $categoryID ]++; |
---|
| 742 | else |
---|
| 743 | $categoriesCount[ $categoryID ] = 1; |
---|
| 744 | } |
---|
| 745 | |
---|
| 746 | $usedCategories = array_keys( $categoriesCount ); |
---|
| 747 | $availableCategories = $this -> getCategoriesList( $organizationID ); |
---|
| 748 | $output = array( ); |
---|
| 749 | $output[ 'employees' ] = $employees; |
---|
| 750 | $output[ 'categories' ] = array( ); |
---|
| 751 | foreach ( $availableCategories as $category ) |
---|
| 752 | { |
---|
| 753 | if ( ! in_array( $category[ 'funcionario_categoria_id' ], $usedCategories ) ) |
---|
| 754 | continue; |
---|
| 755 | |
---|
| 756 | $category[ 'contagem' ] = $categoriesCount[ $category[ 'funcionario_categoria_id' ] ]; |
---|
| 757 | $output[ 'categories' ][ ] = $category; |
---|
| 758 | } |
---|
| 759 | |
---|
| 760 | usort( $output[ 'employees' ], create_function( '$a,$b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);' ) ); |
---|
| 761 | |
---|
| 762 | return $output; |
---|
| 763 | } |
---|
[1269] | 764 | |
---|
| 765 | /** |
---|
| 766 | * Return the list of employees in alphabetical order |
---|
| 767 | * @param int $organizationID The organization ID |
---|
| 768 | * @return array The list o employees |
---|
| 769 | * @access public |
---|
| 770 | */ |
---|
| 771 | function getAlphabeticalEmployees( $organizationID ) |
---|
| 772 | { |
---|
| 773 | $organizationID = ( int ) $organizationID; |
---|
| 774 | |
---|
| 775 | // load the employees from the location |
---|
| 776 | $query = "SELECT f.funcionario_id, f.organizacao_id, f.area_id, a.sigla AS area," |
---|
| 777 | . " COALESCE(f.funcionario_categoria_id, 0) AS funcionario_categoria_id" |
---|
| 778 | . " FROM funcionario f, funcionario_status s, area a" |
---|
| 779 | . " WHERE (f.area_id = a.area_id)" |
---|
| 780 | . " AND (f.funcionario_status_id = s.funcionario_status_id)" |
---|
| 781 | . " AND (f.organizacao_id = ?)" |
---|
| 782 | . " AND (s.exibir = ?)"; |
---|
| 783 | |
---|
| 784 | $result = $this -> db -> query( $query, array( $organizationID, 'S' ) ); |
---|
| 785 | |
---|
| 786 | $employees = $result -> GetArray( -1 ); |
---|
[1276] | 787 | |
---|
[2591] | 788 | $cachedLDAP = Factory::newInstance( 'CachedLDAP' ); |
---|
[1310] | 789 | $cachedLDAP -> setOperationMode( $cachedLDAP -> OPERATION_MODE_NORMAL ); |
---|
[1269] | 790 | |
---|
| 791 | $categoriesCount = array( ); |
---|
| 792 | for ( $i = 0; $i < count( $employees ); $i++ ) |
---|
| 793 | { |
---|
| 794 | // remove numeric fields |
---|
| 795 | for ( $j = 0; $j < $result -> _numOfFields; $j++ ) |
---|
| 796 | unset( $employees[ $i ][ $j ] ); |
---|
| 797 | |
---|
| 798 | $employees[ $i ][ 'cn' ] = ''; |
---|
| 799 | $employees[ $i ][ 'telephoneNumber' ] = ''; |
---|
| 800 | |
---|
| 801 | // try to find the telephone number |
---|
| 802 | $entry = $cachedLDAP -> getEntryByID( $employees[ $i ][ 'funcionario_id' ] ); |
---|
| 803 | if ( $entry ) |
---|
| 804 | { |
---|
| 805 | $employees[ $i ][ 'telephoneNumber' ] = is_null( $entry[ 'telephonenumber' ] ) ? '' : $entry[ 'telephonenumber' ]; |
---|
| 806 | $employees[ $i ][ 'cn' ] = is_null( $entry[ 'cn' ] ) ? '' : $entry[ 'cn' ]; |
---|
| 807 | $employees[ $i ][ 'removed' ] = is_null( $entry[ 'last_update' ] ); |
---|
| 808 | } |
---|
| 809 | |
---|
[1276] | 810 | } |
---|
| 811 | |
---|
| 812 | usort( $employees, create_function( '$a,$b', 'return strcasecmp($a[\'cn\'],$b[\'cn\']);' ) ); |
---|
| 813 | |
---|
[2591] | 814 | $paging = Factory::newInstance('Paging', 50, $_POST); |
---|
[1276] | 815 | $employees = $paging->restrictItems( $employees ); |
---|
| 816 | |
---|
| 817 | // count the number of employees in each category |
---|
| 818 | for ( $i = 0; $i < count( $employees ); $i++ ) |
---|
| 819 | { |
---|
[1269] | 820 | $categoryID = $employees[ $i ][ 'funcionario_categoria_id' ]; |
---|
| 821 | if ( isset( $categoriesCount[ $categoryID ] ) ) |
---|
| 822 | $categoriesCount[ $categoryID ]++; |
---|
| 823 | else |
---|
| 824 | $categoriesCount[ $categoryID ] = 1; |
---|
| 825 | } |
---|
| 826 | |
---|
| 827 | $usedCategories = array_keys( $categoriesCount ); |
---|
| 828 | $availableCategories = $this -> getCategoriesList( $organizationID ); |
---|
| 829 | $output = array( ); |
---|
[1276] | 830 | |
---|
| 831 | $output['employees'] = $employees; |
---|
| 832 | $output['categories'] = array( ); |
---|
| 833 | $output['paging_links'] = $paging -> commonLinks(); |
---|
| 834 | |
---|
[1269] | 835 | foreach ( $availableCategories as $category ) |
---|
| 836 | { |
---|
| 837 | if ( ! in_array( $category[ 'funcionario_categoria_id' ], $usedCategories ) ) |
---|
| 838 | continue; |
---|
| 839 | |
---|
| 840 | $category[ 'contagem' ] = $categoriesCount[ $category[ 'funcionario_categoria_id' ] ]; |
---|
| 841 | $output[ 'categories' ][ ] = $category; |
---|
| 842 | } |
---|
| 843 | |
---|
| 844 | return $output; |
---|
| 845 | } |
---|
[795] | 846 | } |
---|
| 847 | ?> |
---|