12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121 |
- <?php
- define('GROUP_PERMISSION_OPEN' , '1');
- define('GROUP_PERMISSION_CLOSED', '2');
- define('GROUP_USER_PERMISSION_ADMIN' ,'1');
- define('GROUP_USER_PERMISSION_READER' ,'2');
- define('GROUP_USER_PERMISSION_PENDING_INVITATION' ,'3');
- define('GROUP_USER_PERMISSION_PENDING_INVITATION_SENT_BY_USER' ,'4');
- define('GROUP_USER_PERMISSION_MODERATOR' ,'5');
- define('GROUP_USER_PERMISSION_ANONYMOUS' ,'6');
- define('GROUP_USER_PERMISSION_HRM', '7');
- define('GROUP_IMAGE_SIZE_ORIGINAL', 1);
- define('GROUP_IMAGE_SIZE_BIG', 2);
- define('GROUP_IMAGE_SIZE_MEDIUM', 3);
- define('GROUP_IMAGE_SIZE_SMALL', 4);
- define('GROUP_TITLE_LENGTH', 50);
- class GroupPortalManager {
-
- public static function add($name, $description, $url, $visibility, $picture='') {
- $tms = time();
- $table = Database :: get_main_table(TABLE_MAIN_GROUP);
- $sql = "INSERT INTO $table
- SET name = '".Database::escape_string($name)."',
- description = '".Database::escape_string($description)."',
- picture_uri = '".Database::escape_string($picture)."',
- url = '".Database::escape_string($url)."',
- visibility = '".Database::escape_string($visibility)."',
- created_on = FROM_UNIXTIME(".$tms."),
- updated_on = FROM_UNIXTIME(".$tms.")";
- $result = Database::query($sql);
- $return = Database::insert_id();
- return $return;
- }
-
- public static function update($group_id, $name, $description, $url, $visibility, $picture_uri) {
- $group_id = intval($group_id);
- $table = Database::get_main_table(TABLE_MAIN_GROUP);
- $tms = time();
- $sql = "UPDATE $table
- SET name = '".Database::escape_string($name)."',
- description = '".Database::escape_string($description)."',
- picture_uri = '".Database::escape_string($picture_uri)."',
- url = '".Database::escape_string($url)."',
- visibility = '".Database::escape_string($visibility)."',
- updated_on = FROM_UNIXTIME(".$tms.")
- WHERE id = '$group_id'";
- $result = Database::query($sql);
- return $result;
- }
-
- public static function delete($id)
- {
- $id = intval($id);
- $table = Database :: get_main_table(TABLE_MAIN_GROUP);
- $sql= "DELETE FROM $table WHERE id = ".Database::escape_string($id);
- $result = Database::query($sql);
-
- self::delete_users($id);
-
- self::delete_group_picture($id);
- return $result;
- }
-
- public static function get_all_group_data($visibility = GROUP_PERMISSION_OPEN, $from=0, $number_of_items=10)
- {
- $table = Database :: get_main_table(TABLE_MAIN_GROUP);
- $visibility = intval($visibility);
- $user_condition = '';
- $sql = "SELECT name, description, picture_uri FROM $table WHERE visibility = $visibility ";
- $res = Database::query($sql);
- $data = array ();
- while ($item = Database::fetch_array($res)) {
- $data[] = $item;
- }
- return $data;
- }
-
- public static function get_groups_list($without_this_one = NULL ) {
- $where='';
- if ( isset($without_this_one) && (intval($without_this_one) == $without_this_one) ) {
- $where = "WHERE id <> $without_this_one";
- }
- $table = Database :: get_main_table(TABLE_MAIN_GROUP);
- $sql = "SELECT id, name FROM $table $where order by name";
- $res = Database::query($sql);
- $list = array ();
- while ($item = Database::fetch_assoc($res)) {
- $list[$item['id']] = $item['name'];
- }
- return $list;
- }
-
- public static function get_group_data($group_id)
- {
- $table = Database :: get_main_table(TABLE_MAIN_GROUP);
- $group_id = intval($group_id);
- $user_condition = '';
- $sql = "SELECT id, name, description, picture_uri, url, visibility FROM $table WHERE id = $group_id ";
- $res = Database::query($sql);
- $item = array();
- if (Database::num_rows($res)>0) {
- $item = Database::fetch_array($res,'ASSOC');
- }
- return $item;
- }
-
-
- public static function set_parent_group($group_id, $parent_group_id, $relation_type = 1){
- $table = Database :: get_main_table(TABLE_MAIN_GROUP_REL_GROUP);
- $group_id = intval($group_id);
- $parent_group_id = intval($parent_group_id);
- if ($parent_group_id == 0) {
- $sql = "DELETE FROM $table WHERE subgroup_id = $group_id";
- } else {
- $sql = "SELECT group_id FROM $table WHERE subgroup_id = $group_id";
- $res = Database::query($sql);
- if (Database::num_rows($res)==0) {
- $sql = "INSERT INTO $table SET group_id = $parent_group_id, subgroup_id = $group_id, relation_type = $relation_type";
- } else {
- $sql = "UPDATE $table SET group_id = $parent_group_id, relation_type = $relation_type WHERE subgroup_id = $group_id";
- }
- }
- $res = Database::query($sql);
- return($res);
- }
-
- public static function get_parent_group($group_id, $relation_type=1) {
- $table = Database :: get_main_table(TABLE_MAIN_GROUP_REL_GROUP);
- $group_id=intval($group_id);
- $parent_group_id=intval($parent_group_id);
- $sql = "SELECT group_id FROM $table WHERE subgroup_id = $group_id";
- $res = Database::query($sql);
- if (Database::num_rows($res)==0) {
- return 0;
- } else {
- $arr = Database::fetch_assoc($res);
- return $arr['group_id'];
- }
- }
- public static function get_subgroups($root, $level) {
- $t_group = Database::get_main_table(TABLE_MAIN_GROUP);
- $t_rel_group = Database :: get_main_table(TABLE_MAIN_GROUP_REL_GROUP);
- $select_part = "SELECT ";
- $cond_part='';
- for ($i=1; $i <= $level; $i++) {
- $g_number=$i;
- $rg_number=$i-1;
- if ( $i == $level) {
- $select_part .= "g$i.id as id_$i, g$i.name as name_$i ";
- } else {
- $select_part .="g$i.id as id_$i, g$i.name name_$i, ";
- }
- if ($i == 1) {
- $cond_part .= "FROM $t_group g1 JOIN $t_rel_group rg0 on g1.id = rg0.subgroup_id and rg0.group_id = $root ";
- } else {
- $cond_part .= "LEFT JOIN $t_rel_group rg$rg_number on g$rg_number.id = rg$rg_number.group_id ";
- $cond_part .= "LEFT JOIN $t_group g$g_number on rg$rg_number.subgroup_id = g$g_number.id ";
- }
- }
- $sql = $select_part.' '. $cond_part;
- $res = Database::query($sql);
- $toreturn = array();
- while ($item = Database::fetch_assoc($res)) {
- foreach ($item as $key => $value ){
- if ($key == 'id_1') {
- $toreturn[$value]['name'] = $item['name_1'];
- } else {
- $temp = explode('_',$key);
- $index_key = $temp[1];
- $string_key = $temp[0];
- $previous_key = $string_key.'_'.$index_key-1;
- if ( $string_key == 'id' && isset($item[$key]) ) {
- $toreturn[$item[$previous_key]]['hrms'][$index_key]['name'] = $item['name_'.$index_id];
- }
- }
- }
- }
- return $toreturn;
- }
- public static function get_parent_groups($group_id) {
- $t_rel_group = Database :: get_main_table(TABLE_MAIN_GROUP_REL_GROUP);
- $max_level = 10;
- $select_part = "SELECT ";
- $cond_part='';
- for ($i=1; $i <= $max_level; $i++) {
- $g_number=$i;
- $rg_number=$i-1;
- if ( $i == $max_level) {
- $select_part .= "rg$rg_number.group_id as id_$rg_number ";
- } else {
- $select_part .="rg$rg_number.group_id as id_$rg_number, ";
- }
- if ($i == 1) {
- $cond_part .= "FROM $t_rel_group rg0 LEFT JOIN $t_rel_group rg$i on rg$rg_number.group_id = rg$i.subgroup_id ";
- } else {
- $cond_part .= " LEFT JOIN $t_rel_group rg$i on rg$rg_number.group_id = rg$i.subgroup_id ";
- }
- }
- $sql = $select_part.' '. $cond_part . "WHERE rg0.subgroup_id='$group_id'";
- $res = Database::query($sql);
- $temp_arr = Database::fetch_array($res, 'NUM');
- $toreturn = array();
- if (is_array($temp_arr)) {
- foreach ($temp_arr as $elt) {
- if (isset($elt)) {
- $toreturn[] = $elt;
- }
- }
- }
- return $toreturn;
- }
-
- public static function get_group_tags($group_id, $show_tag_links = true)
- {
- $tag = Database :: get_main_table(TABLE_MAIN_TAG);
- $table_group_rel_tag = Database :: get_main_table(TABLE_MAIN_GROUP_REL_TAG);
- $group_id = intval($group_id);
- $user_condition = '';
- $sql = "SELECT tag FROM $tag t INNER JOIN $table_group_rel_tag gt ON (gt.tag_id= t.id) WHERE gt.group_id = $group_id ";
- $res = Database::query($sql);
- $tags = array();
- if (Database::num_rows($res)>0) {
- while ($row = Database::fetch_array($res,'ASSOC')) {
- $tags[] = $row;
- }
- }
- if ($show_tag_links) {
- if (is_array($tags) && count($tags)>0) {
- foreach ($tags as $tag) {
- $tag_tmp[] = '<a href="'.api_get_path(WEB_PATH).'main/social/search.php?q='.$tag['tag'].'">'.$tag['tag'].'</a>';
- }
- if (is_array($tags) && count($tags)>0) {
- $tags= implode(', ',$tag_tmp);
- }
- } else {
- $tags = '';
- }
- }
- return $tags;
- }
-
- public static function get_groups_by_user($user_id = '', $relation_type = GROUP_USER_PERMISSION_READER, $with_image = false) {
- $where = '';
- $table_group_rel_user = Database::get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $tbl_group = Database::get_main_table(TABLE_MAIN_GROUP);
- $user_id = intval($user_id);
- if ($relation_type == 0) {
- $where_relation_condition = '';
- } else {
- $relation_type = intval($relation_type);
- $where_relation_condition = "AND gu.relation_type = $relation_type ";
- }
- $sql = "SELECT g.picture_uri, g.name, g.description, g.id , gu.relation_type
- FROM $tbl_group g
- INNER JOIN $table_group_rel_user gu
- ON gu.group_id = g.id WHERE gu.user_id = $user_id $where_relation_condition ORDER BY created_on desc ";
- $result=Database::query($sql);
- $array = array();
- if (Database::num_rows($result) > 0) {
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- if ($with_image) {
- $picture = self::get_picture_group($row['id'], $row['picture_uri'],80);
- $img = '<img src="'.$picture['file'].'" />';
- $row['picture_uri'] = $img;
- }
- $array[$row['id']] = $row;
- }
- }
- return $array;
- }
-
- public static function get_groups_by_popularity($num = 6, $with_image = true) {
- $where = '';
- $table_group_rel_user = Database::get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $tbl_group = Database::get_main_table(TABLE_MAIN_GROUP);
- if (empty($num)) {
- $num = 6;
- } else {
- $num = intval($num);
- }
-
- $where_relation_condition = " WHERE gu.relation_type IN ('".GROUP_USER_PERMISSION_ADMIN."' , '".GROUP_USER_PERMISSION_READER."', '".GROUP_USER_PERMISSION_HRM."') ";
- $sql = "SELECT DISTINCT count(user_id) as count, g.picture_uri, g.name, g.description, g.id
- FROM $tbl_group g
- INNER JOIN $table_group_rel_user gu
- ON gu.group_id = g.id $where_relation_condition GROUP BY g.id ORDER BY count DESC LIMIT $num";
- $result=Database::query($sql);
- $array = array();
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- if ($with_image) {
- $picture = self::get_picture_group($row['id'], $row['picture_uri'],80);
- $img = '<img src="'.$picture['file'].'" />';
- $row['picture_uri'] = $img;
- }
- if (empty($row['id'])) {
- continue;
- }
- $array[$row['id']] = $row;
- }
- return $array;
- }
-
- public static function get_groups_by_age($num = 6, $with_image = true) {
- $where = '';
- $table_group_rel_user = Database::get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $tbl_group = Database::get_main_table(TABLE_MAIN_GROUP);
- if (empty($num)) {
- $num = 6;
- } else {
- $num = intval($num);
- }
- $where_relation_condition = " WHERE gu.relation_type IN ('".GROUP_USER_PERMISSION_ADMIN."' , '".GROUP_USER_PERMISSION_READER."', '".GROUP_USER_PERMISSION_HRM."') ";
- $sql = "SELECT DISTINCT count(user_id) as count, g.picture_uri, g.name, g.description, g.id
- FROM $tbl_group g INNER JOIN $table_group_rel_user gu ON gu.group_id = g.id
- $where_relation_condition
- ORDER BY created_on desc LIMIT $num ";
-
- $result=Database::query($sql);
- $array = array();
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- if ($with_image) {
- $picture = self::get_picture_group($row['id'], $row['picture_uri'],80);
- $img = '<img src="'.$picture['file'].'" />';
- $row['picture_uri'] = $img;
- }
- if (empty($row['id'])) {
- continue;
- }
- $array[$row['id']] = $row;
- }
- return $array;
- }
-
- public static function get_users_by_group($group_id, $with_image = false, $relation_type = array(), $from = null, $limit = null, $image_conf = array('size'=>USER_IMAGE_SIZE_MEDIUM,'height'=>80)) {
- $where = '';
- $table_group_rel_user = Database::get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
- $group_id = intval($group_id);
-
- if (empty($group_id)){
- return array();
- }
- $limit_text = '';
- if (isset($from) && isset($limit)) {
- $from = intval($from);
- $limit = intval($limit);
- $limit_text = "LIMIT $from, $limit";
- }
- if (count($relation_type) == 0) {
- $where_relation_condition = '';
- } else {
- $new_relation_type = array();
- foreach($relation_type as $rel) {
- $rel = intval($rel);
- $new_relation_type[] ="'$rel'";
- }
- $relation_type = implode(',', $new_relation_type);
- if (!empty($relation_type))
- $where_relation_condition = "AND gu.relation_type IN ($relation_type) ";
- }
- $sql = "SELECT picture_uri as image, u.user_id, u.firstname, u.lastname, relation_type
- FROM $tbl_user u INNER JOIN $table_group_rel_user gu
- ON (gu.user_id = u.user_id)
- WHERE gu.group_id= $group_id $where_relation_condition
- ORDER BY relation_type, firstname $limit_text";
- $result = Database::query($sql);
- $array = array();
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- if ($with_image) {
- $image_path = UserManager::get_user_picture_path_by_id($row['user_id'], 'web', false, true);
- $picture = UserManager::get_picture_user($row['user_id'], $image_path['file'], $image_conf['height'], $image_conf['size']);
- $row['image'] = '<img src="'.$picture['file'].'" '.$picture['style'].' />';
- }
- $array[$row['user_id']] = $row;
- }
- return $array;
- }
-
- public static function get_all_users_by_group($group_id)
- {
- $table_group_rel_user = Database::get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
- $group_id = intval($group_id);
- if (empty($group_id)){
- return array();
- }
- $sql="SELECT u.user_id, u.firstname, u.lastname, relation_type FROM $tbl_user u
- INNER JOIN $table_group_rel_user gu
- ON (gu.user_id = u.user_id) WHERE gu.group_id= $group_id ORDER BY relation_type, firstname";
- $result=Database::query($sql);
- $array = array();
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- $array[$row['user_id']] = $row;
- }
- return $array;
- }
-
- public static function get_user_group_role($user_id, $group_id)
- {
- $table_group_rel_user= Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $return_value = 0;
- if (!empty($user_id) && !empty($group_id)) {
- $sql = "SELECT relation_type FROM $table_group_rel_user WHERE group_id = ".intval($group_id)." AND user_id = ".intval($user_id)." ";
- $result = Database::query($sql);
- if (Database::num_rows($result)>0) {
- $row = Database::fetch_array($result,'ASSOC');
- $return_value = $row['relation_type'];
- }
- }
- return $return_value;
- }
-
- public static function add_user_to_group($user_id, $group_id, $relation_type = GROUP_USER_PERMISSION_READER) {
- $table_url_rel_group = Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- if (!empty($user_id) && !empty($group_id)) {
- $role = self::get_user_group_role($user_id,$group_id);
- if ($role == 0) {
- $sql = "INSERT INTO $table_url_rel_group
- SET user_id = ".intval($user_id).", group_id = ".intval($group_id).", relation_type = ".intval($relation_type);
- $result = Database::query($sql);
- } elseif ($role == GROUP_USER_PERMISSION_PENDING_INVITATION) {
-
- self::update_user_role($user_id, $group_id, GROUP_USER_PERMISSION_READER);
- }
- }
- return $result;
- }
-
- public static function add_users_to_groups($user_list, $group_list, $relation_type = GROUP_USER_PERMISSION_READER) {
- $table_url_rel_group = Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $result_array = array();
- $relation_type = intval($relation_type);
- if (is_array($user_list) && is_array($group_list)) {
- foreach ($group_list as $group_id) {
- foreach ($user_list as $user_id) {
- $role = self::get_user_group_role($user_id,$group_id);
- if ($role == 0) {
- $sql = "INSERT INTO $table_url_rel_group
- SET user_id = ".intval($user_id).", group_id = ".intval($group_id).", relation_type = ".intval($relation_type);
- $result = Database::query($sql);
- if ($result)
- $result_array[$group_id][$user_id]=1;
- else
- $result_array[$group_id][$user_id]=0;
- }
- }
- }
- }
- return $result_array;
- }
-
- public static function delete_users($group_id,$relation_type='')
- {
- $table_ = Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $condition_relation = "";
- if (!empty($relation_type)) {
- $relation_type = intval($relation_type);
- $condition_relation = " AND relation_type = '$relation_type'";
- }
- $sql = "DELETE FROM $table_ WHERE group_id = ".intval($group_id).$condition_relation;
- $result = Database::query($sql);
- return $result;
- }
-
- public static function delete_user_rel_group($user_id, $group_id) {
- $table = Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $sql= "DELETE FROM $table WHERE user_id = ".intval($user_id)." AND group_id=".intval($group_id)." ";
- $result = Database::query($sql);
- return $result;
- }
-
- public static function update_user_role($user_id, $group_id, $relation_type = GROUP_USER_PERMISSION_READER)
- {
- $table_group_rel_user = Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $group_id = intval($group_id);
- $user_id = intval($user_id);
- $sql = "UPDATE $table_group_rel_user
- SET relation_type = ".intval($relation_type)." WHERE user_id = $user_id AND group_id = $group_id" ;
- $result = Database::query($sql);
- }
- public static function get_group_admin_list($user_id, $group_id)
- {
- $table_group_rel_user = Database :: get_main_table(TABLE_MAIN_USER_REL_GROUP);
- $group_id = intval($group_id);
- $user_id = intval($user_id);
- $sql = "SELECT user_id FROM $table_group_rel_user WHERE
- relation_type = ".GROUP_USER_PERMISSION_ADMIN." AND user_id = $user_id AND group_id = $group_id" ;
- $result = Database::query($sql);
- }
- public static function get_all_group_tags($tag, $from=0, $number_of_items=10) {
-
- $group_table = Database::get_main_table(TABLE_MAIN_GROUP);
- $table_tag = Database::get_main_table(TABLE_MAIN_TAG);
- $table_group_tag_values = Database::get_main_table(TABLE_MAIN_GROUP_REL_TAG);
-
- $field_id = 5;
- $tag = Database::escape_string($tag);
- $from = intval($from);
- $number_of_items = intval($number_of_items);
-
- $sql = "SELECT g.id, g.name, g.description, g.picture_uri FROM $table_tag t INNER JOIN $table_group_tag_values tv ON (tv.tag_id=t.id)
- INNER JOIN $group_table g ON(tv.group_id =g.id)
- WHERE tag LIKE '$tag%' AND field_id= $field_id ORDER BY tag";
- $sql .= " LIMIT $from,$number_of_items";
- $result = Database::query($sql);
- $return = array();
- if (Database::num_rows($result)> 0) {
- while ($row = Database::fetch_array($result,'ASSOC')) {
- $return[$row['id']] = $row;
- }
- }
- $keyword = $tag;
- $sql = "SELECT g.id, g.name, g.description, g.url, g.picture_uri FROM $group_table g";
-
-
-
- if (isset ($keyword)) {
- $sql .= " WHERE (g.name LIKE '%".$keyword."%' OR g.description LIKE '%".$keyword."%' OR g.url LIKE '%".$keyword."%' )";
- }
- $direction = 'ASC';
- if (!in_array($direction, array('ASC','DESC'))) {
- $direction = 'ASC';
- }
-
- $from = intval($from);
- $number_of_items = intval($number_of_items);
-
- $sql .= " LIMIT $from,$number_of_items";
- $res = Database::query($sql);
- if (Database::num_rows($res)> 0) {
- while ($row = Database::fetch_array($res,'ASSOC')) {
- if (!in_array($row['id'], $return)) {
- $return[$row['id']] = $row;
- }
- }
- }
- return $return;
- }
-
- public static function update_group_picture($group_id, $file = null, $source_file = null) {
-
- if (empty($group_id)) {
- return false;
- }
- $delete = empty($file);
- if (empty($source_file)) {
- $source_file = $file;
- }
-
- require_once api_get_path(CONFIGURATION_PATH).'profile.conf.php';
-
- $path_info = self::get_group_picture_path_by_id($group_id, 'system', true);
- $path = $path_info['dir'];
-
- if (!file_exists($path)) {
- @mkdir($path, api_get_permissions_for_new_directories(), true);
- }
-
- $old_file = $path_info['file'];
-
- if (!empty($old_file)) {
- if (KEEP_THE_OLD_IMAGE_AFTER_CHANGE) {
- $prefix = 'saved_'.date('Y_m_d_H_i_s').'_'.uniqid('').'_';
- @rename($path.'small_'.$old_file, $path.$prefix.'small_'.$old_file);
- @rename($path.'medium_'.$old_file, $path.$prefix.'medium_'.$old_file);
- @rename($path.'big_'.$old_file, $path.$prefix.'big_'.$old_file);
- @rename($path.$old_file, $path.$prefix.$old_file);
- } else {
- @unlink($path.'small_'.$old_file);
- @unlink($path.'medium_'.$old_file);
- @unlink($path.'big_'.$old_file);
- @unlink($path.$old_file);
- }
- }
-
- if ($delete) {
- return '';
- }
-
- $allowed_types = array('jpg', 'jpeg', 'png', 'gif');
- $file = str_replace('\\', '/', $file);
- $filename = (($pos = strrpos($file, '/')) !== false) ? substr($file, $pos + 1) : $file;
- $extension = strtolower(substr(strrchr($filename, '.'), 1));
- if (!in_array($extension, $allowed_types)) {
- return false;
- }
-
- if (KEEP_THE_NAME_WHEN_CHANGE_IMAGE && !empty($old_file)) {
- $old_extension = strtolower(substr(strrchr($old_file, '.'), 1));
- $filename = in_array($old_extension, $allowed_types) ? substr($old_file, 0, -strlen($old_extension)) : $old_file;
- $filename = (substr($filename, -1) == '.') ? $filename.$extension : $filename.'.'.$extension;
- } else {
- $filename = replace_dangerous_char($filename);
- if (PREFIX_IMAGE_FILENAME_WITH_UID) {
- $filename = uniqid('').'_'.$filename;
- }
-
-
-
- $filename = $group_id.'_'.$filename;
- }
-
- $small = self::resize_picture($source_file, 22);
- $medium = self::resize_picture($source_file, 85);
- $normal = self::resize_picture($source_file, 200);
- $big = new Image($source_file);
- $ok = false;
- $ok = $small->send_image($path.'small_'.$filename)
- && $medium->send_image($path.'medium_'.$filename)
- && $normal->send_image($path.'big_'.$filename)
- && $big->send_image($path.$filename);
- return $ok ? $filename : false;
- }
-
- public static function get_group_picture_path_by_id($id, $type = 'none', $preview = false, $anonymous = false) {
- switch ($type) {
- case 'system':
- $base = api_get_path(SYS_CODE_PATH);
- break;
- case 'rel':
- $base = api_get_path(REL_CODE_PATH);
- break;
- case 'web':
- $base = api_get_path(WEB_CODE_PATH);
- break;
- case 'none':
- default:
- $base = '';
- }
- if (empty($id) || empty($type)) {
- return $anonymous ? array('dir' => $base.'img/', 'file' => 'unknown.jpg') : array('dir' => '', 'file' => '');
- }
- $id = intval($id);
- $group_table = Database :: get_main_table(TABLE_MAIN_GROUP);
- $sql = "SELECT picture_uri FROM $group_table WHERE id=".$id;
- $res = Database::query($sql);
- if (!Database::num_rows($res)) {
- return $anonymous ? array('dir' => $base.'img/', 'file' => 'unknown.jpg') : array('dir' => '', 'file' => '');
- }
- $user = Database::fetch_array($res);
- $picture_filename = trim($user['picture_uri']);
- if (api_get_setting('split_users_upload_directory') === 'true') {
- if (!empty($picture_filename)) {
- $dir = $base.'upload/users/groups/'.substr($picture_filename, 0, 1).'/'.$id.'/';
- } elseif ($preview) {
- $dir = $base.'upload/users/groups/'.substr((string)$id, 0, 1).'/'.$id.'/';
- } else {
- $dir = $base.'upload/users/groups/'.$id.'/';
- }
- } else {
- $dir = $base.'upload/users/groups/'.$id.'/';
- }
- if (empty($picture_filename) && $anonymous) {
- return array('dir' => $base.'img/', 'file' => 'unknown.jpg');
- }
- return array('dir' => $dir, 'file' => $picture_filename);
- }
-
- public static function resize_picture($file, $max_size_for_picture) {
- $temp = new image($file);
- $picture_infos = api_getimagesize($file);
- if ($picture_infos['width'] > $max_size_for_picture) {
- $thumbwidth = $max_size_for_picture;
- if (empty($thumbwidth) or $thumbwidth == 0) {
- $thumbwidth = $max_size_for_picture;
- }
- $new_height = round(($thumbwidth / $picture_infos['width']) * $picture_infos['height']);
- if ($new_height > $max_size_for_picture)
- $new_height = $thumbwidth;
- $temp->resize($thumbwidth, $new_height, 0);
- }
- return $temp;
- }
-
- public static function get_picture_group($id, $picture_file, $height, $size_picture = GROUP_IMAGE_SIZE_MEDIUM , $style = '') {
- $patch_profile = 'upload/users/groups/';
- $picture = array();
- $picture['style'] = $style;
- if ($picture_file == 'unknown.jpg') {
- $picture['file'] = api_get_path(WEB_CODE_PATH).'img/'.$picture_file;
- return $picture;
- }
- switch ($size_picture) {
- case GROUP_IMAGE_SIZE_ORIGINAL :
- $size_picture = '';
- break;
- case GROUP_IMAGE_SIZE_BIG :
- $size_picture = 'big_';
- break;
- case GROUP_IMAGE_SIZE_MEDIUM :
- $size_picture = 'medium_';
- break;
- case GROUP_IMAGE_SIZE_SMALL :
- $size_picture = 'small_';
- break;
- default:
- $size_picture = 'medium_';
- }
- $image_array_sys = self::get_group_picture_path_by_id($id, 'system', false, true);
- $image_array = self::get_group_picture_path_by_id($id, 'web', false, true);
- $file = $image_array_sys['dir'].$size_picture.$picture_file;
- if (file_exists($file)) {
- $picture['file'] = $image_array['dir'].$size_picture.$picture_file;
- $picture['style'] = '';
- if ($height > 0) {
- $dimension = api_getimagesize($picture['file']);
- $margin = (($height - $dimension['width']) / 2);
-
- $picture['style'] = ' style="padding-top:'.$margin.'px; width:'.$dimension['width'].'px; height:'.$dimension['height'].';" ';
- }
- } else {
-
- $file = $image_array_sys['dir'].$picture_file;
- if (file_exists($file) && !is_dir($file)) {
- $picture['file'] = $image_array['dir'].$picture_file;
- } else {
- $picture['file'] = api_get_path(WEB_CODE_PATH).'img/unknown_group.png';
- }
- }
- return $picture;
- }
- public static function delete_group_picture($group_id) {
- return self::update_group_picture($group_id);
- }
- public static function is_group_admin($group_id, $user_id = 0) {
- if (empty($user_id)) {
- $user_id = api_get_user_id();
- }
- $user_role = GroupPortalManager::get_user_group_role($user_id, $group_id);
- if (in_array($user_role, array(GROUP_USER_PERMISSION_ADMIN))) {
- return true;
- } else {
- return false;
- }
- }
- public static function is_group_moderator($group_id, $user_id = 0) {
- if (empty($user_id)) {
- $user_id = api_get_user_id();
- }
- $user_role = GroupPortalManager::get_user_group_role($user_id, $group_id);
- if (in_array($user_role, array(GROUP_USER_PERMISSION_ADMIN, GROUP_USER_PERMISSION_MODERATOR))) {
- return true;
- } else {
- return false;
- }
- }
- public static function is_group_member($group_id, $user_id = 0) {
- if (empty($user_id)) {
- $user_id = api_get_user_id();
- }
- $user_role = GroupPortalManager::get_user_group_role($user_id, $group_id);
- if (in_array($user_role, array(GROUP_USER_PERMISSION_ADMIN, GROUP_USER_PERMISSION_MODERATOR, GROUP_USER_PERMISSION_READER, GROUP_USER_PERMISSION_HRM))) {
- return true;
- } else {
- return false;
- }
- }
-
- public static function show_group_column_information($group_id, $user_id, $show = '') {
- global $relation_group_title, $my_group_role;
- $html = '';
- $group_info = GroupPortalManager::get_group_data($group_id);
- $picture = GroupPortalManager::get_picture_group($group_id, $group_info['picture_uri'],160,GROUP_IMAGE_SIZE_MEDIUM);
- $big_image = GroupPortalManager::get_picture_group($group_id, $group_info['picture_uri'],'',GROUP_IMAGE_SIZE_BIG);
- $tags = GroupPortalManager::get_group_tags($group_id, true);
-
- $groups_by_user = GroupPortalManager::get_groups_by_user($user_id, 0);
-
- $my_group_role = self::get_user_group_role($user_id, $group_id);
-
- $html .= '<style>
- #group_members { width:270px; height:300px; overflow-x:none; overflow-y: auto;}
- .group_member_item { width:100px; height:130px; float:left; margin:5px 5px 15px 5px; }
- .group_member_picture { display:block;
- margin:0;
- overflow:hidden; };
- </style>';
-
-
- $links = '';
- switch ($my_group_role) {
- case GROUP_USER_PERMISSION_READER:
-
- $relation_group_title = get_lang('IAmAReader');
-
-
- $links .= '<li><a href="group_invitation.php?id='.$group_id.'">'. Display::return_icon('invitation_friend.png', get_lang('InviteFriends'), array('hspace'=>'6')).'<span class="'.($show=='invite_friends'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('InviteFriends').'</span></a></li>';
-
- $links .= '<li><a href="groups.php?id='.$group_id.'&action=leave&u='.api_get_user_id().'">'. Display::return_icon('group_leave.png', get_lang('LeaveGroup'), array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('LeaveGroup').'</span></a></li>';
- break;
- case GROUP_USER_PERMISSION_ADMIN:
- $relation_group_title = get_lang('IAmAnAdmin');
-
-
- $links .= '<li><a href="group_edit.php?id='.$group_id.'">'. Display::return_icon('group_edit.png', get_lang('EditGroup'), array('hspace'=>'6')).'<span class="'.($show=='group_edit'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('EditGroup').'</span></a></li>';
-
-
- $links .= '<li><a href="group_waiting_list.php?id='.$group_id.'">'. Display::return_icon('waiting_list.png', get_lang('WaitingList'), array('hspace'=>'6')).'<span class="'.($show=='waiting_list'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('WaitingList').'</span></a></li>';
-
- $links .= '<li><a href="group_invitation.php?id='.$group_id.'">'. Display::return_icon('invitation_friend.png', get_lang('InviteFriends'), array('hspace'=>'6')).'<span class="'.($show=='invite_friends'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('InviteFriends').'</span></a></li>';
- break;
- case GROUP_USER_PERMISSION_PENDING_INVITATION:
- break;
- case GROUP_USER_PERMISSION_PENDING_INVITATION_SENT_BY_USER:
- $relation_group_title = get_lang('WaitingForAdminResponse');
- break;
- case GROUP_USER_PERMISSION_MODERATOR:
- $relation_group_title = get_lang('IAmAModerator');
-
-
-
- if ($group_info['visibility'] == GROUP_PERMISSION_CLOSED) {
- $links .= '<li><a href="group_waiting_list.php?id='.$group_id.'">'. Display::return_icon('waiting_list.png', get_lang('WaitingList'), array('hspace'=>'6')).'<span class="'.($show=='waiting_list'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('WaitingList').'</span></a></li>';
- }
- $links .= '<li><a href="group_invitation.php?id='.$group_id.'">'. Display::return_icon('invitation_friend.png', get_lang('InviteFriends'), array('hspace'=>'6')).'<span class="'.($show=='invite_friends'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('InviteFriends').'</span></a></li>';
- break;
- case GROUP_USER_PERMISSION_HRM:
- $relation_group_title = get_lang('IAmAHRM');
- $links .= '<li><a href="'.api_get_path(WEB_CODE_PATH).'social/message_for_group_form.inc.php?view_panel=1&height=400&width=610&&user_friend='.api_get_user_id().'&group_id='.$group_id.'&action=add_message_group" class="thickbox" title="'.get_lang('ComposeMessage').'">'.Display::return_icon('compose_message.png', get_lang('NewTopic'), array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('NewTopic').'</span></a></li>';
- $links .= '<li><a href="groups.php?id='.$group_id.'">'. Display::return_icon('message_list.png', get_lang('MessageList'), array('hspace'=>'6')).'<span class="'.($show=='messages_list'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('MessageList').'</span></a></li>';
- $links .= '<li><a href="group_invitation.php?id='.$group_id.'">'. Display::return_icon('invitation_friend.png', get_lang('InviteFriends'), array('hspace'=>'6')).'<span class="'.($show=='invite_friends'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('InviteFriends').'</span></a></li>';
- $links .= '<li><a href="group_members.php?id='.$group_id.'">'. Display::return_icon('member_list.png', get_lang('MemberList'), array('hspace'=>'6')).'<span class="'.($show=='member_list'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('MemberList').'</span></a></li>';
- $links .= '<li><a href="groups.php?id='.$group_id.'&action=leave&u='.api_get_user_id().'">'. Display::return_icon('delete_data.gif', get_lang('LeaveGroup'), array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('LeaveGroup').'</span></a></li>';
- break;
- default:
-
- break;
- }
- if (!empty($links)) {
- $html .= '<ul class="social-menu-groups">';
- if (!empty($group_info['description'])) {
- $html .= Display::tag('li', Security::remove_XSS($group_info['description'], STUDENT, true), array('class'=>'group_description'));
- }
- $html .= $links;
- $html .= '</ul>';
- }
- return $html;
- }
-
- function delete_topic($group_id, $topic_id) {
- $table_message = Database::get_main_table(TABLE_MESSAGE);
- $topic_id = intval($topic_id);
- $group_id = intval($group_id);
- $sql = "UPDATE $table_message SET msg_status=3 WHERE group_id = $group_id AND (id = '$topic_id' OR parent_id = $topic_id) ";
- Database::query($sql);
- }
- }
|