123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384 |
- <?php
- /* For licensing terms, see /license.txt */
- use ChamiloSession as Session;
- use Zend\Feed\Reader\Entry\Rss;
- use Zend\Feed\Reader\Reader;
- /**
- * Class SocialManager.
- *
- * This class provides methods for the social network management.
- * Include/require it in your code to use its features.
- *
- * @package chamilo.social
- */
- class SocialManager extends UserManager
- {
- const DEFAULT_WALL_POSTS = 10;
- const DEFAULT_SCROLL_NEW_POST = 5;
- /**
- * Constructor.
- */
- public function __construct()
- {
- }
- /**
- * Allow to see contacts list.
- *
- * @author isaac flores paz
- *
- * @return array
- */
- public static function show_list_type_friends()
- {
- $table = Database::get_main_table(TABLE_MAIN_USER_FRIEND_RELATION_TYPE);
- $sql = 'SELECT id, title FROM '.$table.'
- WHERE id<>6
- ORDER BY id ASC';
- $result = Database::query($sql);
- $friend_relation_list = [];
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- $friend_relation_list[] = $row;
- }
- $count_list = count($friend_relation_list);
- if ($count_list == 0) {
- $friend_relation_list[] = get_lang('Unknown');
- } else {
- return $friend_relation_list;
- }
- }
- /**
- * Get relation type contact by name.
- *
- * @param string names of the kind of relation
- *
- * @return int
- *
- * @author isaac flores paz
- */
- public static function get_relation_type_by_name($relation_type_name)
- {
- $list_type_friend = self::show_list_type_friends();
- foreach ($list_type_friend as $value_type_friend) {
- if (strtolower($value_type_friend['title']) == $relation_type_name) {
- return $value_type_friend['id'];
- }
- }
- }
- /**
- * Get the kind of relation between contacts.
- *
- * @param int user id
- * @param int user friend id
- * @param string
- *
- * @return int
- *
- * @author isaac flores paz
- */
- public static function get_relation_between_contacts($user_id, $user_friend)
- {
- $table = Database::get_main_table(TABLE_MAIN_USER_FRIEND_RELATION_TYPE);
- $userRelUserTable = Database::get_main_table(TABLE_MAIN_USER_REL_USER);
- $sql = 'SELECT rt.id as id
- FROM '.$table.' rt
- WHERE rt.id = (
- SELECT uf.relation_type
- FROM '.$userRelUserTable.' uf
- WHERE
- user_id='.((int) $user_id).' AND
- friend_user_id='.((int) $user_friend).' AND
- uf.relation_type <> '.USER_RELATION_TYPE_RRHH.'
- LIMIT 1
- )';
- $res = Database::query($sql);
- if (Database::num_rows($res) > 0) {
- $row = Database::fetch_array($res, 'ASSOC');
- return $row['id'];
- } else {
- return USER_UNKNOWN;
- }
- }
- /**
- * Get count of friends from user.
- *
- * @param int $userId
- *
- * @return int
- */
- public static function getCountFriends($userId)
- {
- $table = Database::get_main_table(TABLE_MAIN_USER_REL_USER);
- $userId = (int) $userId;
- if (empty($userId)) {
- return 0;
- }
- $sql = 'SELECT count(friend_user_id) count
- FROM '.$table.'
- WHERE
- relation_type NOT IN ('.USER_RELATION_TYPE_DELETED.', '.USER_RELATION_TYPE_RRHH.') AND
- friend_user_id<>'.$userId.' AND
- user_id='.$userId;
- $res = Database::query($sql);
- if (Database::num_rows($res)) {
- $row = Database::fetch_array($res, 'ASSOC');
- return (int) $row['count'];
- }
- return 0;
- }
- /**
- * Gets friends id list.
- *
- * @param int user id
- * @param int group id
- * @param string name to search
- * @param bool true will load firstname, lastname, and image name
- *
- * @return array
- *
- * @author Julio Montoya <gugli100@gmail.com> Cleaning code, function renamed, $load_extra_info option added
- * @author isaac flores paz
- */
- public static function get_friends(
- $user_id,
- $id_group = null,
- $search_name = null,
- $load_extra_info = true
- ) {
- $user_id = (int) $user_id;
- $tbl_my_friend = Database::get_main_table(TABLE_MAIN_USER_REL_USER);
- $tbl_my_user = Database::get_main_table(TABLE_MAIN_USER);
- $sql = 'SELECT friend_user_id FROM '.$tbl_my_friend.'
- WHERE
- relation_type NOT IN ('.USER_RELATION_TYPE_DELETED.', '.USER_RELATION_TYPE_RRHH.') AND
- friend_user_id<>'.$user_id.' AND
- user_id='.$user_id;
- if (isset($id_group) && $id_group > 0) {
- $sql .= ' AND relation_type='.$id_group;
- }
- if (isset($search_name)) {
- $search_name = trim($search_name);
- $search_name = str_replace(' ', '', $search_name);
- $sql .= ' AND friend_user_id IN (
- SELECT user_id FROM '.$tbl_my_user.'
- WHERE
- firstName LIKE "%'.Database::escape_string($search_name).'%" OR
- lastName LIKE "%'.Database::escape_string($search_name).'%" OR
- '.(api_is_western_name_order() ? 'concat(firstName, lastName)' : 'concat(lastName, firstName)').' LIKE concat("%","'.Database::escape_string($search_name).'","%")
- ) ';
- }
- $res = Database::query($sql);
- $list = [];
- while ($row = Database::fetch_array($res, 'ASSOC')) {
- if ($load_extra_info) {
- $userInfo = api_get_user_info($row['friend_user_id']);
- $list[] = [
- 'friend_user_id' => $row['friend_user_id'],
- 'firstName' => $userInfo['firstName'],
- 'lastName' => $userInfo['lastName'],
- 'username' => $userInfo['username'],
- 'image' => $userInfo['avatar'],
- 'user_info' => $userInfo,
- ];
- } else {
- $list[] = $row;
- }
- }
- return $list;
- }
- /**
- * get web path of user invitate.
- *
- * @author isaac flores paz
- * @author Julio Montoya setting variable array
- *
- * @param int user id
- *
- * @return array
- */
- public static function get_list_web_path_user_invitation_by_user_id($user_id)
- {
- $list_ids = self::get_list_invitation_of_friends_by_user_id($user_id);
- $list = [];
- foreach ($list_ids as $values_ids) {
- $list[] = UserManager::get_user_picture_path_by_id(
- $values_ids['user_sender_id'],
- 'web'
- );
- }
- return $list;
- }
- /**
- * Sends an invitation to contacts.
- *
- * @param int user id
- * @param int user friend id
- * @param string title of the message
- * @param string content of the message
- *
- * @return bool
- *
- * @author isaac flores paz
- * @author Julio Montoya <gugli100@gmail.com> Cleaning code
- */
- public static function send_invitation_friend(
- $user_id,
- $friend_id,
- $message_title,
- $message_content
- ) {
- $tbl_message = Database::get_main_table(TABLE_MESSAGE);
- $user_id = (int) $user_id;
- $friend_id = (int) $friend_id;
- //Just in case we replace the and \n and \n\r while saving in the DB
- $message_content = str_replace(["\n", "\n\r"], '<br />', $message_content);
- $clean_message_content = Database::escape_string($message_content);
- $now = api_get_utc_datetime();
- $sql = 'SELECT COUNT(*) AS count FROM '.$tbl_message.'
- WHERE
- user_sender_id='.$user_id.' AND
- user_receiver_id='.$friend_id.' AND
- msg_status IN('.MESSAGE_STATUS_INVITATION_PENDING.', '.MESSAGE_STATUS_INVITATION_ACCEPTED.', '.MESSAGE_STATUS_INVITATION_DENIED.');
- ';
- $res_exist = Database::query($sql);
- $row_exist = Database::fetch_array($res_exist, 'ASSOC');
- if ($row_exist['count'] == 0) {
- $params = [
- 'user_sender_id' => $user_id,
- 'user_receiver_id' => $friend_id,
- 'msg_status' => MESSAGE_STATUS_INVITATION_PENDING,
- 'send_date' => $now,
- 'title' => $message_title,
- 'content' => $message_content,
- 'group_id' => 0,
- 'parent_id' => 0,
- 'update_date' => $now,
- ];
- $messageId = Database::insert($tbl_message, $params);
- $senderInfo = api_get_user_info($user_id);
- $notification = new Notification();
- $notification->saveNotification(
- $messageId,
- Notification::NOTIFICATION_TYPE_INVITATION,
- [$friend_id],
- $message_title,
- $message_content,
- $senderInfo
- );
- return true;
- } else {
- // invitation already exist
- $sql = 'SELECT COUNT(*) AS count, id FROM '.$tbl_message.'
- WHERE user_sender_id='.$user_id.' AND user_receiver_id='.$friend_id.' AND msg_status = 7';
- $res_if_exist = Database::query($sql);
- $row_if_exist = Database::fetch_array($res_if_exist, 'ASSOC');
- if ($row_if_exist['count'] == 1) {
- $sql = 'UPDATE '.$tbl_message.' SET
- msg_status=5, content = "'.$clean_message_content.'"
- WHERE user_sender_id='.$user_id.' AND user_receiver_id='.$friend_id.' AND msg_status = 7 ';
- Database::query($sql);
- return true;
- } else {
- return false;
- }
- }
- }
- /**
- * Get number messages of the inbox.
- *
- * @author isaac flores paz
- *
- * @param int $userId user receiver id
- *
- * @return int
- */
- public static function get_message_number_invitation_by_user_id($userId)
- {
- $table = Database::get_main_table(TABLE_MESSAGE);
- $userId = (int) $userId;
- $sql = 'SELECT COUNT(*) as count_message_in_box FROM '.$table.'
- WHERE
- user_receiver_id='.$userId.' AND
- msg_status='.MESSAGE_STATUS_INVITATION_PENDING;
- $res = Database::query($sql);
- $row = Database::fetch_array($res, 'ASSOC');
- if ($row) {
- return (int) $row['count_message_in_box'];
- }
- return 0;
- }
- /**
- * Get number of messages sent to other users.
- *
- * @param int $userId
- *
- * @return int
- */
- public static function getCountMessagesSent($userId)
- {
- $userId = (int) $userId;
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'SELECT COUNT(*) FROM '.$table.'
- WHERE
- user_sender_id='.$userId.' AND
- msg_status < 5';
- $res = Database::query($sql);
- $row = Database::fetch_row($res);
- return $row[0];
- }
- /**
- * Get number of messages received from other users.
- *
- * @param int $receiver_id
- *
- * @return int
- */
- public static function getCountMessagesReceived($receiver_id)
- {
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'SELECT COUNT(*) FROM '.$table.'
- WHERE
- user_receiver_id='.intval($receiver_id).' AND
- msg_status < 4';
- $res = Database::query($sql);
- $row = Database::fetch_row($res);
- return $row[0];
- }
- /**
- * Get number of messages posted on own wall.
- *
- * @param int $userId
- *
- * @return int
- */
- public static function getCountWallPostedMessages($userId)
- {
- $userId = (int) $userId;
- if (empty($userId)) {
- return 0;
- }
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'SELECT COUNT(*)
- FROM '.$table.'
- WHERE
- user_sender_id='.$userId.' AND
- (msg_status = '.MESSAGE_STATUS_WALL.' OR
- msg_status = '.MESSAGE_STATUS_WALL_POST.') AND
- parent_id = 0';
- $res = Database::query($sql);
- $row = Database::fetch_row($res);
- return $row[0];
- }
- /**
- * Get invitation list received by user.
- *
- * @author isaac flores paz
- *
- * @param int $userId
- * @param int $limit
- *
- * @return array
- */
- public static function get_list_invitation_of_friends_by_user_id($userId, $limit = 0)
- {
- $userId = (int) $userId;
- $limit = (int) $limit;
- if (empty($userId)) {
- return [];
- }
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'SELECT user_sender_id, send_date, title, content
- FROM '.$table.'
- WHERE
- user_receiver_id = '.$userId.' AND
- msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;
- if ($limit != null && $limit > 0) {
- $sql .= ' LIMIT '.$limit;
- }
- $res = Database::query($sql);
- $list = [];
- while ($row = Database::fetch_array($res, 'ASSOC')) {
- $list[] = $row;
- }
- return $list;
- }
- /**
- * Get invitation list sent by user.
- *
- * @author Julio Montoya <gugli100@gmail.com>
- *
- * @param int $userId
- *
- * @return array
- */
- public static function get_list_invitation_sent_by_user_id($userId)
- {
- $userId = (int) $userId;
- if (empty($userId)) {
- return [];
- }
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'SELECT user_receiver_id, send_date,title,content
- FROM '.$table.'
- WHERE
- user_sender_id = '.$userId.' AND
- msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;
- $res = Database::query($sql);
- $list = [];
- while ($row = Database::fetch_array($res, 'ASSOC')) {
- $list[$row['user_receiver_id']] = $row;
- }
- return $list;
- }
- /**
- * Get count invitation sent by user.
- *
- * @author Julio Montoya <gugli100@gmail.com>
- *
- * @param int $userId
- *
- * @return int
- */
- public static function getCountInvitationSent($userId)
- {
- $userId = (int) $userId;
- if (empty($userId)) {
- return 0;
- }
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'SELECT count(user_receiver_id) count
- FROM '.$table.'
- WHERE
- user_sender_id = '.$userId.' AND
- msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;
- $res = Database::query($sql);
- if (Database::num_rows($res)) {
- $row = Database::fetch_array($res, 'ASSOC');
- return (int) $row['count'];
- }
- return 0;
- }
- /**
- * Accepts invitation.
- *
- * @param int $user_send_id
- * @param int $user_receiver_id
- *
- * @return bool
- *
- * @author isaac flores paz
- * @author Julio Montoya <gugli100@gmail.com> Cleaning code
- */
- public static function invitation_accepted($user_send_id, $user_receiver_id)
- {
- if (empty($user_send_id) || empty($user_receiver_id)) {
- return false;
- }
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = "UPDATE $table
- SET msg_status = ".MESSAGE_STATUS_INVITATION_ACCEPTED."
- WHERE
- user_sender_id = ".((int) $user_send_id)." AND
- user_receiver_id=".((int) $user_receiver_id)." AND
- msg_status = ".MESSAGE_STATUS_INVITATION_PENDING;
- Database::query($sql);
- return true;
- }
- /**
- * Denies invitation.
- *
- * @param int user sender id
- * @param int user receiver id
- *
- * @return bool
- *
- * @author isaac flores paz
- * @author Julio Montoya <gugli100@gmail.com> Cleaning code
- */
- public static function invitation_denied($user_send_id, $user_receiver_id)
- {
- if (empty($user_send_id) || empty($user_receiver_id)) {
- return false;
- }
- $table = Database::get_main_table(TABLE_MESSAGE);
- $sql = 'DELETE FROM '.$table.'
- WHERE
- user_sender_id = '.((int) $user_send_id).' AND
- user_receiver_id='.((int) $user_receiver_id).' AND
- msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;
- Database::query($sql);
- return true;
- }
- /**
- * Allow attaching to group.
- *
- * @author Isaac Flores Paz
- *
- * @param int $id_friend_qualify User to qualify
- * @param int $type_qualify Kind of rating
- *
- * @deprecated 2017-03
- */
- public static function qualify_friend($id_friend_qualify, $type_qualify)
- {
- $table = Database::get_main_table(TABLE_MAIN_USER_REL_USER);
- $user_id = api_get_user_id();
- $sql = 'UPDATE '.$table.' SET relation_type='.((int) $type_qualify).'
- WHERE user_id = '.$user_id.' AND friend_user_id='.(int) $id_friend_qualify;
- Database::query($sql);
- }
- /**
- * Get user's feeds.
- *
- * @param int $user User ID
- * @param int $limit Limit of posts per feed
- *
- * @return string HTML section with all feeds included
- *
- * @author Yannick Warnier
- *
- * @since Dokeos 1.8.6.1
- */
- public static function getUserRssFeed($user, $limit = 5)
- {
- $feed = UserManager::get_extra_user_data_by_field($user, 'rssfeeds');
- if (empty($feed)) {
- return '';
- }
- $feeds = explode(';', $feed['rssfeeds']);
- if (count($feeds) == 0) {
- return '';
- }
- $res = '';
- foreach ($feeds as $url) {
- if (empty($url)) {
- continue;
- }
- try {
- $channel = Reader::import($url);
- $i = 1;
- if (!empty($channel)) {
- $iconRss = '';
- if (!empty($feed)) {
- $iconRss = Display::url(
- Display::return_icon('social_rss.png', '', [], 22),
- Security::remove_XSS($feed['rssfeeds']),
- ['target' => '_blank']
- );
- }
- $res .= '<h3 class="title-rss">'.$iconRss.' '.$channel->getTitle().'</h3>';
- $res .= '<div class="rss-items">';
- /** @var Rss $item */
- foreach ($channel as $item) {
- if ($limit >= 0 and $i > $limit) {
- break;
- }
- $res .= '<h4 class="rss-title"><a href="'.$item->getLink().'">'.$item->getTitle().'</a></h4>';
- $res .= '<div class="rss-date">'.api_get_local_time($item->getDateCreated()).'</div>';
- $res .= '<div class="rss-content"><p>'.$item->getDescription().'</p></div>';
- $i++;
- }
- $res .= '</div>';
- }
- } catch (Exception $e) {
- error_log($e->getMessage());
- }
- }
- return $res;
- }
- /**
- * Sends invitations to friends.
- *
- * @param int $userId
- * @param string $subject
- * @param string $content
- *
- * @return bool
- */
- public static function sendInvitationToUser($userId, $subject = '', $content = '')
- {
- $user_info = api_get_user_info($userId);
- $success = get_lang('MessageSentTo');
- $success .= ' : '.api_get_person_name($user_info['firstName'], $user_info['lastName']);
- if (isset($subject) && isset($content) && isset($userId)) {
- $result = MessageManager::send_message($userId, $subject, $content);
- if ($result) {
- Display::addFlash(
- Display::return_message($success, 'normal', false)
- );
- } else {
- Display::addFlash(
- Display::return_message(get_lang('ErrorSendingMessage'), 'error', false)
- );
- }
- return false;
- } elseif (isset($userId) && !isset($subject)) {
- if (isset($userId) && $userId > 0) {
- $count = self::send_invitation_friend(
- api_get_user_id(),
- $userId,
- get_lang('Invitation'),
- $content
- );
- if ($count) {
- Display::addFlash(
- Display::return_message(
- api_htmlentities(get_lang('InvitationHasBeenSent')),
- 'normal',
- false
- )
- );
- } else {
- Display::addFlash(
- Display::return_message(
- api_htmlentities(get_lang('YouAlreadySentAnInvitation')),
- 'warning',
- false
- )
- );
- }
- }
- }
- }
- /**
- * Helper functions definition.
- */
- public static function get_logged_user_course_html($my_course, $count)
- {
- $result = '';
- $count = (int) $count;
- // Table definitions
- $main_user_table = Database::get_main_table(TABLE_MAIN_USER);
- $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
- $course_directory = $my_course['course_info']['directory'];
- $course_title = $my_course['course_info']['title'];
- $course_visibility = $my_course['course_info']['visibility'];
- $user_in_course_status = CourseManager::getUserInCourseStatus(
- api_get_user_id(),
- $my_course['course_info']['real_id']
- );
- $course_path = api_get_path(SYS_COURSE_PATH).$course_directory; // course path
- if (api_get_setting('course_images_in_courses_list') === 'true') {
- if (file_exists($course_path.'/course-pic85x85.png')) {
- $image = $my_course['course_info']['course_image'];
- $imageCourse = Display::img($image, $course_title, ['class' => 'img-course']);
- } else {
- $imageCourse = Display::return_icon(
- 'session_default_small.png',
- $course_title,
- ['class' => 'img-course']
- );
- }
- } else {
- $imageCourse = Display::return_icon(
- 'course.png',
- get_lang('Course'),
- ['class' => 'img-default']
- );
- }
- //display course entry
- if (api_get_setting('course_images_in_courses_list') === 'true') {
- $result .= '<li id="course_'.$count.'" class="list-group-item" style="min-height:65px;">';
- } else {
- $result .= '<li id="course_'.$count.'" class="list-group-item" style="min-height:44px;">';
- }
- $result .= $imageCourse;
- //show a hyperlink to the course, unless the course is closed and user is not course admin
- if ($course_visibility != COURSE_VISIBILITY_HIDDEN &&
- ($course_visibility != COURSE_VISIBILITY_CLOSED || $user_in_course_status == COURSEMANAGER)
- ) {
- $result .= '<span class="title">'.$course_title.'<span>';
- } else {
- $result .= $course_title.' '.get_lang('CourseClosed');
- }
- $result .= '</li>';
- $session = '';
- if (!empty($my_course['session_name']) && !empty($my_course['id_session'])) {
- // Request for the name of the general coach
- $sql = 'SELECT lastname, firstname
- FROM '.$tbl_session.' ts
- LEFT JOIN '.$main_user_table.' tu
- ON ts.id_coach = tu.user_id
- WHERE ts.id='.(int) $my_course['id_session'].' LIMIT 1';
- $rs = Database::query($sql);
- $sessioncoach = Database::store_result($rs);
- $sessioncoach = $sessioncoach[0];
- $session = [];
- $session['title'] = $my_course['session_name'];
- if ($my_course['access_start_date'] == '0000-00-00') {
- $session['dates'] = get_lang('WithoutTimeLimits');
- if (api_get_setting('show_session_coach') === 'true') {
- $session['coach'] = get_lang('GeneralCoach').': '.
- api_get_person_name($sessioncoach['firstname'], $sessioncoach['lastname']);
- }
- } else {
- $session['dates'] = ' - '.get_lang('From').' '.$my_course['access_start_date'].' '.get_lang('To').' '.$my_course['access_end_date'];
- if (api_get_setting('show_session_coach') === 'true') {
- $session['coach'] = get_lang('GeneralCoach').': '.
- api_get_person_name($sessioncoach['firstname'], $sessioncoach['lastname']);
- }
- }
- }
- $my_course['id_session'] = isset($my_course['id_session']) ? $my_course['id_session'] : 0;
- $output = [
- $my_course['user_course_cat'],
- $result,
- $my_course['id_session'],
- $session,
- ];
- return $output;
- }
- /**
- * Shows the avatar block in social pages.
- *
- * @param string $show highlight link possible values:
- * group_add,
- * home,
- * messages,
- * messages_inbox,
- * messages_compose,
- * messages_outbox,
- * invitations,
- * shared_profile,
- * friends,
- * groups search
- * @param int $group_id
- * @param int $user_id
- */
- public static function show_social_avatar_block($show = '', $group_id = 0, $user_id = 0)
- {
- $user_id = (int) $user_id;
- $group_id = (int) $group_id;
- if (empty($user_id)) {
- $user_id = api_get_user_id();
- }
- $show_groups = [
- 'groups',
- 'group_messages',
- 'messages_list',
- 'group_add',
- 'mygroups',
- 'group_edit',
- 'member_list',
- 'invite_friends',
- 'waiting_list',
- 'browse_groups',
- ];
- $template = new Template(null, false, false, false, false, false);
- if (in_array($show, $show_groups) && !empty($group_id)) {
- // Group image
- $userGroup = new UserGroup();
- $group_info = $userGroup->get($group_id);
- $userGroupImage = $userGroup->get_picture_group(
- $group_id,
- $group_info['picture'],
- 128,
- GROUP_IMAGE_SIZE_BIG
- );
- $template->assign('show_group', true);
- $template->assign('group_id', $group_id);
- $template->assign('user_group_image', $userGroupImage);
- $template->assign(
- 'user_is_group_admin',
- $userGroup->is_group_admin(
- $group_id,
- api_get_user_id()
- )
- );
- } else {
- $template->assign('show_group', false);
- $template->assign('show_user', true);
- $template->assign(
- 'user_image',
- [
- 'big' => UserManager::getUserPicture(
- $user_id,
- USER_IMAGE_SIZE_BIG
- ),
- 'normal' => UserManager::getUserPicture(
- $user_id,
- USER_IMAGE_SIZE_MEDIUM
- ),
- ]
- );
- }
- $skillBlock = $template->get_template('social/avatar_block.tpl');
- return $template->fetch($skillBlock);
- }
- /**
- * Shows the right menu of the Social Network tool.
- *
- * @param string $show highlight link possible values:
- * group_add,
- * home,
- * messages,
- * messages_inbox,
- * messages_compose ,
- * messages_outbox,
- * invitations,
- * shared_profile,
- * friends,
- * groups search
- * @param int $group_id group id
- * @param int $user_id user id
- * @param bool $show_full_profile show profile or not (show or hide the user image/information)
- * @param bool $show_delete_account_button
- */
- public static function show_social_menu(
- $show = '',
- $group_id = 0,
- $user_id = 0,
- $show_full_profile = false,
- $show_delete_account_button = false
- ) {
- $user_id = (int) $user_id;
- $group_id = (int) $group_id;
- if (empty($user_id)) {
- $user_id = api_get_user_id();
- }
- $usergroup = new UserGroup();
- $show_groups = [
- 'groups',
- 'group_messages',
- 'messages_list',
- 'group_add',
- 'mygroups',
- 'group_edit',
- 'member_list',
- 'invite_friends',
- 'waiting_list',
- 'browse_groups',
- ];
- // get count unread message and total invitations
- $count_unread_message = MessageManager::getNumberOfMessages(true);
- $count_unread_message = !empty($count_unread_message) ? Display::badge($count_unread_message) : null;
- $number_of_new_messages_of_friend = self::get_message_number_invitation_by_user_id(api_get_user_id());
- $group_pending_invitations = $usergroup->get_groups_by_user(
- api_get_user_id(),
- GROUP_USER_PERMISSION_PENDING_INVITATION,
- false
- );
- $group_pending_invitations = count($group_pending_invitations);
- $total_invitations = $number_of_new_messages_of_friend + $group_pending_invitations;
- $total_invitations = (!empty($total_invitations) ? Display::badge($total_invitations) : '');
- $filesIcon = Display::return_icon('sn-files.png', get_lang('MyFiles'), null, ICON_SIZE_SMALL);
- $friendsIcon = Display::return_icon('sn-friends.png', get_lang('Friends'), null, ICON_SIZE_SMALL);
- $groupsIcon = Display::return_icon('sn-groups.png', get_lang('SocialGroups'), null, ICON_SIZE_SMALL);
- $homeIcon = Display::return_icon('sn-home.png', get_lang('Home'), null, ICON_SIZE_SMALL);
- $invitationsIcon = Display::return_icon('sn-invitations.png', get_lang('Invitations'), null, ICON_SIZE_SMALL);
- $messagesIcon = Display::return_icon('sn-message.png', get_lang('Messages'), null, ICON_SIZE_SMALL);
- $sharedProfileIcon = Display::return_icon('sn-profile.png', get_lang('ViewMySharedProfile'));
- $searchIcon = Display::return_icon('sn-search.png', get_lang('Search'), null, ICON_SIZE_SMALL);
- $portfolioIcon = Display::return_icon('wiki_task.png', get_lang('Portfolio'));
- $personalDataIcon = Display::return_icon('database.png', get_lang('PersonalDataReport'));
- $forumCourseId = api_get_configuration_value('global_forums_course_id');
- $groupUrl = api_get_path(WEB_CODE_PATH).'social/groups.php';
- if (!empty($forumCourseId)) {
- $courseInfo = api_get_course_info_by_id($forumCourseId);
- if (!empty($courseInfo)) {
- $groupUrl = api_get_path(WEB_CODE_PATH).'forum/index.php?cidReq='.$courseInfo['code'];
- }
- }
- $html = '';
- $active = null;
- if (!in_array(
- $show,
- ['shared_profile', 'groups', 'group_edit', 'member_list', 'waiting_list', 'invite_friends']
- )) {
- $links = '<ul class="nav nav-pills nav-stacked">';
- $active = $show === 'home' ? 'active' : null;
- $links .= '
- <li class="home-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/home.php">
- '.$homeIcon.' '.get_lang('Home').'
- </a>
- </li>';
- $active = $show == 'messages' ? 'active' : null;
- $links .= '
- <li class="messages-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'messages/inbox.php">
- '.$messagesIcon.' '.get_lang('Messages').$count_unread_message.'
- </a>
- </li>';
- // Invitations
- $active = $show == 'invitations' ? 'active' : null;
- $links .= '
- <li class="invitations-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/invitations.php">
- '.$invitationsIcon.' '.get_lang('Invitations').$total_invitations.'
- </a>
- </li>';
- // Shared profile and groups
- $active = $show == 'shared_profile' ? 'active' : null;
- $links .= '
- <li class="shared-profile-icon'.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/profile.php">
- '.$sharedProfileIcon.' '.get_lang('ViewMySharedProfile').'
- </a>
- </li>';
- $active = $show == 'friends' ? 'active' : null;
- $links .= '
- <li class="friends-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/friends.php">
- '.$friendsIcon.' '.get_lang('Friends').'
- </a>
- </li>';
- $active = $show === 'browse_groups' ? 'active' : null;
- $links .= '
- <li class="browse-groups-icon '.$active.'">
- <a href="'.$groupUrl.'">
- '.$groupsIcon.' '.get_lang('SocialGroups').'
- </a>
- </li>';
- // Search users
- $active = $show == 'search' ? 'active' : null;
- $links .= '
- <li class="search-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/search.php">
- '.$searchIcon.' '.get_lang('Search').'
- </a>
- </li>';
- // My files
- $active = $show == 'myfiles' ? 'active' : null;
- $myFiles = '
- <li class="myfiles-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/myfiles.php">
- '.$filesIcon.' '.get_lang('MyFiles').'
- </a>
- </li>';
- if (api_get_setting('allow_my_files') === 'false') {
- $myFiles = '';
- }
- $links .= $myFiles;
- if (api_get_configuration_value('allow_portfolio_tool')) {
- $links .= '
- <li class="portoflio-icon '.($show == 'portfolio' ? 'active' : '').'">
- <a href="'.api_get_path(WEB_CODE_PATH).'portfolio/index.php">
- '.$portfolioIcon.' '.get_lang('Portfolio').'
- </a>
- </li>
- ';
- }
- if (!api_get_configuration_value('disable_gdpr')) {
- $active = $show == 'personal-data' ? 'active' : null;
- $personalData = '
- <li class="personal-data-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/personal_data.php">
- '.$personalDataIcon.' '.get_lang('PersonalDataReport').'
- </a>
- </li>';
- $links .= $personalData;
- $links .= '</ul>';
- }
- $html .= Display::panelCollapse(
- get_lang('SocialNetwork'),
- $links,
- 'social-network-menu',
- null,
- 'sn-sidebar',
- 'sn-sidebar-collapse'
- );
- }
- if (in_array($show, $show_groups) && !empty($group_id)) {
- $html .= $usergroup->show_group_column_information(
- $group_id,
- api_get_user_id(),
- $show
- );
- }
- if ($show === 'shared_profile') {
- $links = '<ul class="nav nav-pills nav-stacked">';
- // My own profile
- if ($show_full_profile && $user_id == intval(api_get_user_id())) {
- $links .= '
- <li class="home-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/home.php">
- '.$homeIcon.' '.get_lang('Home').'
- </a>
- </li>
- <li class="messages-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'messages/inbox.php">
- '.$messagesIcon.' '.get_lang('Messages').$count_unread_message.'
- </a>
- </li>';
- $active = $show === 'invitations' ? 'active' : null;
- $links .= '
- <li class="invitations-icon'.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/invitations.php">
- '.$invitationsIcon.' '.get_lang('Invitations').$total_invitations.'
- </a>
- </li>';
- $links .= '
- <li class="shared-profile-icon active">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/profile.php">
- '.$sharedProfileIcon.' '.get_lang('ViewMySharedProfile').'
- </a>
- </li>
- <li class="friends-icon">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/friends.php">
- '.$friendsIcon.' '.get_lang('Friends').'
- </a>
- </li>';
- $links .= '<li class="browse-groups-icon">
- <a href="'.$groupUrl.'">
- '.$groupsIcon.' '.get_lang('SocialGroups').'
- </a>
- </li>';
- $active = $show == 'search' ? 'active' : null;
- $links .= '
- <li class="search-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/search.php">
- '.$searchIcon.' '.get_lang('Search').'
- </a>
- </li>';
- $active = $show == 'myfiles' ? 'active' : null;
- $myFiles = '
- <li class="myfiles-icon '.$active.'">
- <a href="'.api_get_path(WEB_CODE_PATH).'social/myfiles.php">
- '.$filesIcon.' '.get_lang('MyFiles').'
- </a>
- </li>';
- if (api_get_setting('allow_my_files') === 'false') {
- $myFiles = '';
- }
- $links .= $myFiles;
- if (api_get_configuration_value('allow_portfolio_tool')) {
- $links .= '
- <li class="portoflio-icon '.($show == 'portfolio' ? 'active' : '').'">
- <a href="'.api_get_path(WEB_CODE_PATH).'portfolio/index.php">
- '.$portfolioIcon.' '.get_lang('Portfolio').'
- </a>
- </li>
- ';
- }
- }
- // My friend profile.
- if ($user_id != api_get_user_id()) {
- $sendMessageText = get_lang('SendMessage');
- $sendMessageIcon = Display::return_icon(
- 'new-message.png',
- $sendMessageText
- );
- $sendMessageUrl = api_get_path(WEB_AJAX_PATH).'user_manager.ajax.php?'.http_build_query([
- 'a' => 'get_user_popup',
- 'user_id' => $user_id,
- ]);
- $links .= '<li>';
- $links .= Display::url(
- "$sendMessageIcon $sendMessageText",
- $sendMessageUrl,
- [
- 'class' => 'ajax',
- 'title' => $sendMessageText,
- 'data-title' => $sendMessageText,
- ]
- );
- $links .= '</li>';
- if (api_get_configuration_value('allow_portfolio_tool')) {
- $links .= '
- <li class="portoflio-icon '.($show == 'portfolio' ? 'active' : '').'">
- <a href="'.api_get_path(WEB_CODE_PATH).'portfolio/index.php?user='.$user_id.'">
- '.$portfolioIcon.' '.get_lang('Portfolio').'
- </a>
- </li>
- ';
- }
- }
- // Check if I already sent an invitation message
- $invitation_sent_list = self::get_list_invitation_sent_by_user_id(api_get_user_id());
- if (isset($invitation_sent_list[$user_id]) && is_array($invitation_sent_list[$user_id]) &&
- count($invitation_sent_list[$user_id]) > 0
- ) {
- $links .= '<li><a href="'.api_get_path(WEB_CODE_PATH).'social/invitations.php">'.
- Display::return_icon('invitation.png', get_lang('YouAlreadySentAnInvitation'))
- .' '.get_lang('YouAlreadySentAnInvitation').'</a></li>';
- } else {
- if (!$show_full_profile) {
- $links .= '<li>
- <a class="btn-to-send-invitation" href="#" data-send-to="'.$user_id.'" title="'.get_lang('SendInvitation').'">'.
- Display::return_icon('invitation.png', get_lang('SocialInvitationToFriends')).' '.get_lang('SendInvitation').
- '</a></li>';
- }
- }
- $links .= '</ul>';
- $html .= Display::panelCollapse(
- get_lang('SocialNetwork'),
- $links,
- 'social-network-menu',
- null,
- 'sn-sidebar',
- 'sn-sidebar-collapse'
- );
- if ($show_full_profile && $user_id == intval(api_get_user_id())) {
- $personal_course_list = UserManager::get_personal_session_course_list($user_id);
- $course_list_code = [];
- $i = 1;
- if (is_array($personal_course_list)) {
- foreach ($personal_course_list as $my_course) {
- if ($i <= 10) {
- $course_list_code[] = ['code' => $my_course['code']];
- } else {
- break;
- }
- $i++;
- }
- // To avoid repeated courses
- $course_list_code = array_unique_dimensional($course_list_code);
- }
- // Announcements
- $my_announcement_by_user_id = intval($user_id);
- $announcements = [];
- foreach ($course_list_code as $course) {
- $course_info = api_get_course_info($course['code']);
- if (!empty($course_info)) {
- $content = AnnouncementManager::get_all_annoucement_by_user_course(
- $course_info['code'],
- $my_announcement_by_user_id
- );
- if (!empty($content)) {
- $url = Display::url(
- Display::return_icon(
- 'announcement.png',
- get_lang('Announcements')
- ).$course_info['name'].' ('.$content['count'].')',
- api_get_path(WEB_CODE_PATH).'announcements/announcements.php?cidReq='.$course['code']
- );
- $announcements[] = Display::tag('li', $url);
- }
- }
- }
- if (!empty($announcements)) {
- $html .= '<div class="social_menu_items">';
- $html .= '<ul>';
- foreach ($announcements as $announcement) {
- $html .= $announcement;
- }
- $html .= '</ul>';
- $html .= '</div>';
- }
- }
- }
- if ($show_delete_account_button) {
- $html .= '<div class="panel panel-default"><div class="panel-body">';
- $html .= '<ul class="nav nav-pills nav-stacked"><li>';
- $url = api_get_path(WEB_CODE_PATH).'auth/unsubscribe_account.php';
- $html .= Display::url(
- Display::return_icon(
- 'delete.png',
- get_lang('Unsubscribe'),
- [],
- ICON_SIZE_TINY
- ).get_lang('Unsubscribe'),
- $url
- );
- $html .= '</li></ul>';
- $html .= '</div></div>';
- }
- $html .= '';
- return $html;
- }
- /**
- * Displays a sortable table with the list of online users.
- *
- * @param array $user_list The list of users to be shown
- * @param bool $wrap Whether we want the function to wrap the spans list in a div or not
- *
- * @return string HTML block or null if and ID was defined
- * @assert (null) === false
- */
- public static function display_user_list($user_list, $wrap = true)
- {
- $html = '';
- if (isset($_GET['id']) || count($user_list) < 1) {
- return false;
- }
- $course_url = '';
- if (isset($_GET['cidReq']) && strlen($_GET['cidReq']) > 0) {
- $course_url = '&cidReq='.Security::remove_XSS($_GET['cidReq']);
- }
- $hide = api_get_configuration_value('hide_complete_name_in_whoisonline');
- foreach ($user_list as $uid) {
- $user_info = api_get_user_info($uid, true);
- $lastname = $user_info['lastname'];
- $firstname = $user_info['firstname'];
- $completeName = $firstname.', '.$lastname;
- $user_rol = $user_info['status'] == 1 ? Display::return_icon('teacher.png', get_lang('Teacher'), null, ICON_SIZE_TINY) : Display::return_icon('user.png', get_lang('Student'), null, ICON_SIZE_TINY);
- $status_icon_chat = null;
- if (isset($user_info['user_is_online_in_chat']) && $user_info['user_is_online_in_chat'] == 1) {
- $status_icon_chat = Display::return_icon('online.png', get_lang('Online'));
- } else {
- $status_icon_chat = Display::return_icon('offline.png', get_lang('Offline'));
- }
- $userPicture = $user_info['avatar'];
- $officialCode = '';
- if (api_get_setting('show_official_code_whoisonline') == 'true') {
- $officialCode .= '<div class="items-user-official-code"><p style="min-height: 30px;" title="'.get_lang('OfficialCode').'">'.$user_info['official_code'].'</p></div>';
- }
- if ($hide === true) {
- $completeName = '';
- $firstname = '';
- $lastname = '';
- }
- $img = '<img class="img-responsive img-circle" title="'.$completeName.'" alt="'.$completeName.'" src="'.$userPicture.'">';
- $url = null;
- // Anonymous users can't have access to the profile
- if (!api_is_anonymous()) {
- if (api_get_setting('allow_social_tool') === 'true') {
- $url = api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$uid.$course_url;
- } else {
- $url = '?id='.$uid.$course_url;
- }
- } else {
- $url = null;
- }
- $name = '<a href="'.$url.'">'.$firstname.'<br>'.$lastname.'</a>';
- $html .= '<div class="col-xs-6 col-md-2">
- <div class="items-user">
- <div class="items-user-avatar"><a href="'.$url.'">'.$img.'</a></div>
- <div class="items-user-name">
- '.$name.'
- </div>
- '.$officialCode.'
- <div class="items-user-status">'.$status_icon_chat.' '.$user_rol.'</div>
- </div>
- </div>';
- }
- return $html;
- }
- /**
- * Displays the information of an individual user.
- *
- * @param int $user_id
- *
- * @return string
- */
- public static function display_individual_user($user_id)
- {
- global $interbreadcrumb;
- $safe_user_id = (int) $user_id;
- $currentUserId = api_get_user_id();
- $user_table = Database::get_main_table(TABLE_MAIN_USER);
- $sql = "SELECT * FROM $user_table WHERE user_id = ".$safe_user_id;
- $result = Database::query($sql);
- $html = null;
- if (Database::num_rows($result) == 1) {
- $user_object = Database::fetch_object($result);
- $userInfo = api_get_user_info($user_id);
- $alt = $userInfo['complete_name'].($currentUserId == $user_id ? ' ('.get_lang('Me').')' : '');
- $status = get_status_from_code($user_object->status);
- $interbreadcrumb[] = ['url' => 'whoisonline.php', 'name' => get_lang('UsersOnLineList')];
- $html .= '<div class ="thumbnail">';
- $fullurl = $userInfo['avatar'];
- $html .= '<img src="'.$fullurl.'" alt="'.$alt.'" />';
- if (!empty($status)) {
- $html .= '<div class="caption">'.$status.'</div>';
- }
- $html .= '</div>';
- if (api_get_setting('show_email_addresses') == 'true') {
- $html .= Display::encrypted_mailto_link($user_object->email, $user_object->email).'<br />';
- }
- if ($user_object->competences) {
- $html .= Display::page_subheader(get_lang('MyCompetences'));
- $html .= '<p>'.$user_object->competences.'</p>';
- }
- if ($user_object->diplomas) {
- $html .= Display::page_subheader(get_lang('MyDiplomas'));
- $html .= '<p>'.$user_object->diplomas.'</p>';
- }
- if ($user_object->teach) {
- $html .= Display::page_subheader(get_lang('MyTeach'));
- $html .= '<p>'.$user_object->teach.'</p>';
- }
- self::display_productions($user_object->user_id);
- if ($user_object->openarea) {
- $html .= Display::page_subheader(get_lang('MyPersonalOpenArea'));
- $html .= '<p>'.$user_object->openarea.'</p>';
- }
- } else {
- $html .= '<div class="actions-title">';
- $html .= get_lang('UsersOnLineList');
- $html .= '</div>';
- }
- return $html;
- }
- /**
- * Display productions in who is online.
- *
- * @param int $user_id User id
- */
- public static function display_productions($user_id)
- {
- $webdir_array = UserManager::get_user_picture_path_by_id($user_id, 'web');
- $sysdir = UserManager::getUserPathById($user_id, 'system');
- $webdir = UserManager::getUserPathById($user_id, 'web');
- if (!is_dir($sysdir)) {
- mkdir($sysdir, api_get_permissions_for_new_directories(), true);
- }
- $productions = UserManager::get_user_productions($user_id);
- if (count($productions) > 0) {
- echo '<dt><strong>'.get_lang('Productions').'</strong></dt>';
- echo '<dd><ul>';
- foreach ($productions as $file) {
- // Only display direct file links to avoid browsing an empty directory
- if (is_file($sysdir.$file) && $file != $webdir_array['file']) {
- echo '<li><a href="'.$webdir.urlencode($file).'" target=_blank>'.$file.'</a></li>';
- }
- // Real productions are under a subdirectory by the User's id
- if (is_dir($sysdir.$file)) {
- $subs = scandir($sysdir.$file);
- foreach ($subs as $my => $sub) {
- if (substr($sub, 0, 1) != '.' && is_file($sysdir.$file.'/'.$sub)) {
- echo '<li><a href="'.$webdir.urlencode($file).'/'.urlencode($sub).'" target=_blank>'.$sub.'</a></li>';
- }
- }
- }
- }
- echo '</ul></dd>';
- }
- }
- /**
- * @param string $content
- * @param string $span_count
- *
- * @return string
- */
- public static function social_wrapper_div($content, $span_count)
- {
- $span_count = (int) $span_count;
- $html = '<div class="span'.$span_count.'">';
- $html .= '<div class="well_border">';
- $html .= $content;
- $html .= '</div></div>';
- return $html;
- }
- /**
- * Dummy function.
- */
- public static function get_plugins($place = SOCIAL_CENTER_PLUGIN)
- {
- $content = '';
- switch ($place) {
- case SOCIAL_CENTER_PLUGIN:
- $social_plugins = [1, 2];
- if (is_array($social_plugins) && count($social_plugins) > 0) {
- $content .= '<div id="social-plugins">';
- foreach ($social_plugins as $plugin) {
- $content .= '<div class="social-plugin-item">';
- $content .= $plugin;
- $content .= '</div>';
- }
- $content .= '</div>';
- }
- break;
- case SOCIAL_LEFT_PLUGIN:
- break;
- case SOCIAL_RIGHT_PLUGIN:
- break;
- }
- return $content;
- }
- /**
- * Sends a message to someone's wall.
- *
- * @param int $userId id of author
- * @param int $friendId id where we send the message
- * @param string $messageContent of the message
- * @param int $messageId id parent
- * @param string $messageStatus status type of message
- *
- * @return int
- *
- * @author Yannick Warnier
- */
- public static function sendWallMessage(
- $userId,
- $friendId,
- $messageContent,
- $messageId = 0,
- $messageStatus = ''
- ) {
- $tblMessage = Database::get_main_table(TABLE_MESSAGE);
- $userId = (int) $userId;
- $friendId = (int) $friendId;
- $messageId = (int) $messageId;
- if (empty($userId) || empty($friendId)) {
- return 0;
- }
- // Just in case we replace the and \n and \n\r while saving in the DB
- $messageContent = str_replace(["\n", "\n\r"], '<br />', $messageContent);
- $now = api_get_utc_datetime();
- $attributes = [
- 'user_sender_id' => $userId,
- 'user_receiver_id' => $friendId,
- 'msg_status' => $messageStatus,
- 'send_date' => $now,
- 'title' => '',
- 'content' => $messageContent,
- 'parent_id' => $messageId,
- 'group_id' => 0,
- 'update_date' => $now,
- ];
- return Database::insert($tblMessage, $attributes);
- }
- /**
- * Send File attachment (jpg,png).
- *
- * @author Anibal Copitan
- *
- * @param int $userId id user
- * @param array $fileAttach
- * @param int $messageId id message (relation with main message)
- * @param string $fileComment description attachment file
- *
- * @return bool|int
- */
- public static function sendWallMessageAttachmentFile(
- $userId,
- $fileAttach,
- $messageId,
- $fileComment = ''
- ) {
- $safeFileName = Database::escape_string($fileAttach['name']);
- $extension = strtolower(substr(strrchr($safeFileName, '.'), 1));
- $allowedTypes = api_get_supported_image_extensions();
- $allowedTypes[] = 'mp4';
- $allowedTypes[] = 'webm';
- $allowedTypes[] = 'ogg';
- if (in_array($extension, $allowedTypes)) {
- return MessageManager::saveMessageAttachmentFile($fileAttach, $fileComment, $messageId, $userId);
- }
- return false;
- }
- /**
- * Gets all messages from someone's wall (within specific limits).
- *
- * @param int $userId id of wall shown
- * @param int|string $parentId id message (Post main)
- * @param int|array $groupId
- * @param int|array $friendId
- * @param string $startDate Date from which we want to show the messages, in UTC time
- * @param int $start Limit for the number of parent messages we want to show
- * @param int $length Wall message query offset
- * @param bool $getCount
- * @param array $threadList
- *
- * @return array|int
- *
- * @author Yannick Warnier
- */
- public static function getWallMessages(
- $userId,
- $parentId = 0,
- $groupId = 0,
- $friendId = 0,
- $startDate = '',
- $start = 0,
- $length = 10,
- $getCount = false,
- $threadList = []
- ) {
- $tblMessage = Database::get_main_table(TABLE_MESSAGE);
- $parentId = (int) $parentId;
- $userId = (int) $userId;
- $start = (int) $start;
- $length = (int) $length;
- $startDate = Database::escape_string($startDate);
- $select = " SELECT
- id,
- user_sender_id,
- user_receiver_id,
- send_date,
- content,
- parent_id,
- msg_status,
- group_id,
- '' as forum_id,
- '' as thread_id,
- '' as c_id
- ";
- if ($getCount) {
- $select = ' SELECT count(id) count ';
- }
- $sql = "$select
- FROM $tblMessage tm
- WHERE
- msg_status <> ".MESSAGE_STATUS_WALL_DELETE.' AND ';
- // My own posts
- $userReceiverCondition = ' (
- user_receiver_id = '.$userId.' AND
- msg_status IN ('.MESSAGE_STATUS_WALL_POST.', '.MESSAGE_STATUS_WALL.') AND
- parent_id = '.$parentId.'
- )';
- // User condition
- $sql .= $userReceiverCondition;
- // Get my group posts
- $groupCondition = '';
- if (!empty($groupId)) {
- if (is_array($groupId)) {
- $groupId = array_map('intval', $groupId);
- $groupId = implode("','", $groupId);
- $groupCondition = " OR ( group_id IN ('$groupId') ";
- } else {
- $groupId = (int) $groupId;
- $groupCondition = " OR ( group_id = '$groupId' ";
- }
- $groupCondition .= ' AND msg_status IN ('.MESSAGE_STATUS_NEW.', '.MESSAGE_STATUS_UNREAD.')) ';
- }
- $friendCondition = '';
- // Get my friend posts
- if (!empty($friendId)) {
- if (is_array($friendId)) {
- $friendId = array_map('intval', $friendId);
- $friendId = implode("','", $friendId);
- $friendCondition = " OR ( user_receiver_id IN ('$friendId') ";
- } else {
- $friendId = (int) $friendId;
- $friendCondition = " OR ( user_receiver_id = '$friendId' ";
- }
- $friendCondition .= ' AND msg_status IN ('.MESSAGE_STATUS_WALL_POST.') AND parent_id = 0) ';
- }
- if (!empty($groupCondition) || !empty($friendCondition)) {
- $sql .= " $groupCondition $friendCondition ";
- }
- if (!empty($threadList)) {
- if ($getCount) {
- $select = ' SELECT count(iid) count ';
- } else {
- $select = " SELECT
- iid,
- poster_id,
- '' as user_receiver_id,
- post_date,
- post_text,
- '' as parent_id,
- ".MESSAGE_STATUS_FORUM.",
- '' as group_id,
- forum_id,
- thread_id,
- c_id
- ";
- }
- $threadList = array_map('intval', $threadList);
- $threadList = implode("','", $threadList);
- $condition = " thread_id IN ('$threadList') ";
- $sql .= "
- UNION (
- $select
- FROM c_forum_post
- WHERE $condition
- )
- ";
- }
- if ($getCount) {
- $res = Database::query($sql);
- $row = Database::fetch_array($res);
- return (int) $row['count'];
- }
- $sql .= ' ORDER BY send_date DESC ';
- $sql .= " LIMIT $start, $length ";
- $messages = [];
- $res = Database::query($sql);
- $em = Database::getManager();
- if (Database::num_rows($res) > 0) {
- $repo = $em->getRepository('ChamiloCourseBundle:CForumPost');
- $repoThread = $em->getRepository('ChamiloCourseBundle:CForumThread');
- $groups = [];
- $forums = [];
- $userGroup = new UserGroup();
- $urlGroup = api_get_path(WEB_CODE_PATH).'social/group_view.php?id=';
- while ($row = Database::fetch_array($res, 'ASSOC')) {
- $row['group_info'] = [];
- if (!empty($row['group_id'])) {
- if (!in_array($row['group_id'], $groups)) {
- $group = $userGroup->get($row['group_id']);
- $group['url'] = $urlGroup.$group['id'];
- $groups[$row['group_id']] = $group;
- $row['group_info'] = $group;
- } else {
- $row['group_info'] = $groups[$row['group_id']];
- }
- }
- // forums
- $row['post_title'] = '';
- $row['forum_title'] = '';
- $row['thread_url'] = '';
- if ($row['msg_status'] == MESSAGE_STATUS_FORUM) {
- /** @var \Chamilo\CourseBundle\Entity\CForumPost $post */
- $post = $repo->find($row['id']);
- /** @var \Chamilo\CourseBundle\Entity\CForumThread $thread */
- $thread = $repoThread->find($row['thread_id']);
- if ($post && $thread) {
- $courseInfo = api_get_course_info_by_id($post->getCId());
- $row['post_title'] = $post->getForumId();
- $row['forum_title'] = $thread->getThreadTitle();
- $row['thread_url'] = api_get_path(WEB_CODE_PATH).'forum/viewthread.php?'.http_build_query([
- 'cidReq' => $courseInfo['code'],
- 'forum' => $post->getForumId(),
- 'thread' => $post->getThreadId(),
- 'post_id' => $post->getIid(),
- ]).'#post_id_'.$post->getIid();
- }
- }
- $messages[] = $row;
- }
- }
- return $messages;
- }
- /**
- * Gets all messages from someone's wall (within specific limits), formatted.
- *
- * @param int $userId USER ID of the person's wall
- * @param array $messageInfo
- * @param string $start Start date (from when we want the messages until today)
- * @param int $limit Limit to the number of messages we want
- * @param int $offset Wall messages offset
- *
- * @return string HTML formatted string to show messages
- */
- public static function getWallPostComments(
- $userId,
- $messageInfo,
- $start = null,
- $limit = 10,
- $offset = 0
- ) {
- $messageId = $messageInfo['id'];
- $messages = MessageManager::getMessagesByParent($messageInfo['id'], 0, $offset, $limit);
- $formattedList = '<div class="sub-mediapost row">';
- $users = [];
- // The messages are ordered by date descendant, for comments we need ascendant
- krsort($messages);
- foreach ($messages as $message) {
- $userIdLoop = $message['user_sender_id'];
- if (!isset($users[$userIdLoop])) {
- $users[$userIdLoop] = api_get_user_info($userIdLoop);
- }
- $media = self::processPostComment($message, $users);
- $formattedList .= $media;
- }
- $formattedList .= '</div>';
- $formattedList .= '<div class="mediapost-form">';
- $formattedList .= '<form class="form-horizontal" id="form_comment_'.$messageId.'" name="post_comment" method="POST">
- <div class="col-sm-9">
- <label for="comment" class="hide">'.get_lang('SocialWriteNewComment').'</label>
- <input type="hidden" name = "messageId" value="'.$messageId.'" />
- <textarea rows="3" class="form-control" placeholder="'.get_lang('SocialWriteNewComment').'" name="comment" rows="1" ></textarea>
- </div>
- <div class="col-sm-3">
- <a onclick="submitComment('.$messageId.');" href="javascript:void(0);" name="social_wall_new_msg_submit" class="btn btn-default btn-post">
- <em class="fa fa-pencil"></em> '.get_lang('Post').'
- </a>
- </div>
- </form>';
- $formattedList .= '</div>';
- return $formattedList;
- }
- /**
- * @param array $message
- * @param array $users
- *
- * @return string
- */
- public static function processPostComment($message, $users = [])
- {
- if (empty($message)) {
- return false;
- }
- $date = Display::dateToStringAgoAndLongDate($message['send_date']);
- $currentUserId = api_get_user_id();
- $userIdLoop = $message['user_sender_id'];
- $receiverId = $message['user_receiver_id'];
- $urlImg = api_get_path(WEB_IMG_PATH);
- if (!isset($users[$userIdLoop])) {
- $users[$userIdLoop] = api_get_user_info($userIdLoop);
- }
- $iconStatus = '';
- $userStatus = (int) $users[$userIdLoop]['status'];
- $isAdmin = self::is_admin($users[$userIdLoop]['id']);
- if ($userStatus === 5) {
- if ($users[$userIdLoop]['has_certificates']) {
- $iconStatus = '<img src="'.$urlImg.'icons/svg/identifier_graduated.svg" width="22px" height="22px">';
- } else {
- $iconStatus = '<img src="'.$urlImg.'icons/svg/identifier_student.svg" width="22px" height="22px">';
- }
- } else {
- if ($userStatus === 1) {
- if ($isAdmin) {
- $iconStatus = '<img src="'.$urlImg.'icons/svg/identifier_admin.svg" width="22px" height="22px">';
- } else {
- $iconStatus = '<img src="'.$urlImg.'icons/svg/identifier_teacher.svg" width="22px" height="22px">';
- }
- }
- }
- $nameComplete = $users[$userIdLoop]['complete_name'];
- $url = api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$userIdLoop;
- $comment = '<div class="rep-post col-md-12">';
- $comment .= '<div class="col-md-2 col-xs-2 social-post-answers">';
- $comment .= '<div class="user-image pull-right">';
- $comment .= '<a href="'.$url.'">
- <img src="'.$users[$userIdLoop]['avatar'].'"
- alt="'.$users[$userIdLoop]['complete_name'].'"
- class="avatar-thumb">
- </a>';
- $comment .= '</div>';
- $comment .= '</div>';
- $comment .= '<div class="col-md-7 col-xs-7 social-post-answers">';
- $comment .= '<div class="user-data">';
- $comment .= $iconStatus;
- $comment .= '<div class="username"><a href="'.$url.'">'.$nameComplete.'</a>
- <span>'.Security::remove_XSS($message['content']).'</span>
- </div>';
- $comment .= '<div>'.$date.'</div>';
- $comment .= '<br />';
- $comment .= '</div>';
- $comment .= '</div>';
- $comment .= '<div class="col-md-3 col-xs-3 social-post-answers">';
- $comment .= '<div class="pull-right btn-group btn-group-sm">';
- $comment .= MessageManager::getLikesButton(
- $message['id'],
- $currentUserId
- );
- $isOwnWall = $currentUserId == $userIdLoop || $currentUserId == $receiverId;
- if ($isOwnWall) {
- $comment .= Display::url(
- Display::returnFontAwesomeIcon('trash', '', true),
- 'javascript:void(0)',
- [
- 'id' => 'message_'.$message['id'],
- 'title' => get_lang('SocialMessageDelete'),
- 'onclick' => 'deleteComment('.$message['id'].')',
- 'class' => 'btn btn-default',
- ]
- );
- }
- $comment .= '</div>';
- $comment .= '</div>';
- $comment .= '</div>';
- return $comment;
- }
- /**
- * @param array $message
- *
- * @return array
- */
- public static function getAttachmentPreviewList($message)
- {
- $messageId = $message['id'];
- $list = [];
- if (empty($message['group_id'])) {
- $files = MessageManager::getAttachmentList($messageId);
- if ($files) {
- $downloadUrl = api_get_path(WEB_CODE_PATH).'social/download.php?message_id='.$messageId;
- foreach ($files as $row_file) {
- $url = $downloadUrl.'&attachment_id='.$row_file['id'];
- $display = Display::fileHtmlGuesser($row_file['filename'], $url);
- $list[] = $display;
- }
- }
- } else {
- $list = MessageManager::getAttachmentLinkList($messageId);
- }
- return $list;
- }
- /**
- * @param array $message
- *
- * @return string
- */
- public static function getPostAttachment($message)
- {
- $previews = self::getAttachmentPreviewList($message);
- if (empty($previews)) {
- return '';
- }
- return implode('', $previews);
- }
- /**
- * @param array $messages
- *
- * @return array
- */
- public static function formatWallMessages($messages)
- {
- $data = [];
- $users = [];
- foreach ($messages as $key => $message) {
- $userIdLoop = $message['user_sender_id'];
- $userFriendIdLoop = $message['user_receiver_id'];
- if (!isset($users[$userIdLoop])) {
- $users[$userIdLoop] = api_get_user_info($userIdLoop);
- }
- if (!isset($users[$userFriendIdLoop])) {
- $users[$userFriendIdLoop] = api_get_user_info($userFriendIdLoop);
- }
- $html = self::headerMessagePost(
- $users[$userIdLoop],
- $users[$userFriendIdLoop],
- $message
- );
- $data[$key] = $message;
- $data[$key]['html'] = $html;
- }
- return $data;
- }
- /**
- * get html data with OpenGrap passing the URL.
- *
- * @param $link url
- *
- * @return string data html
- */
- public static function readContentWithOpenGraph($link)
- {
- if (strpos($link, "://") === false && substr($link, 0, 1) != "/") {
- $link = "http://".$link;
- }
- $graph = OpenGraph::fetch($link);
- $link = parse_url($link);
- $host = $link['host'] ? strtoupper($link['host']) : $link['path'];
- if (!$graph) {
- return false;
- }
- $url = $graph->url;
- $image = $graph->image;
- $description = $graph->description;
- $title = $graph->title;
- $html = '<div class="thumbnail social-thumbnail">';
- $html .= empty($image) ? '' : '<a target="_blank" href="'.$url.'">
- <img class="img-responsive social-image" src="'.$image.'" /></a>';
- $html .= '<div class="social-description">';
- $html .= '<a target="_blank" href="'.$url.'"><h5 class="social-title"><b>'.$title.'</b></h5></a>';
- $html .= empty($description) ? '' : '<span>'.$description.'</span>';
- $html .= empty($host) ? '' : '<p>'.$host.'</p>';
- $html .= '</div>';
- $html .= '</div>';
- return $html;
- }
- /**
- * verify if Url Exist - Using Curl.
- *
- * @param $uri url
- *
- * @return bool
- */
- public static function verifyUrl($uri)
- {
- $curl = curl_init($uri);
- curl_setopt($curl, CURLOPT_FAILONERROR, true);
- curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true);
- curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
- curl_setopt($curl, CURLOPT_TIMEOUT, 15);
- curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
- curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
- curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']);
- $response = curl_exec($curl);
- curl_close($curl);
- if (!empty($response)) {
- return true;
- }
- return false;
- }
- /**
- * Soft delete a message and his chidren.
- *
- * @param int $id id message to delete
- *
- * @return bool status query
- */
- public static function deleteMessage($id)
- {
- $id = (int) $id;
- $messageInfo = MessageManager::get_message_by_id($id);
- if (!empty($messageInfo)) {
- // Delete comments too
- $messages = MessageManager::getMessagesByParent($id);
- if (!empty($messages)) {
- foreach ($messages as $message) {
- self::deleteMessage($message['id']);
- }
- }
- // Soft delete message
- $tblMessage = Database::get_main_table(TABLE_MESSAGE);
- $statusMessage = MESSAGE_STATUS_WALL_DELETE;
- $sql = "UPDATE $tblMessage SET msg_status = '$statusMessage' WHERE id = '{$id}' ";
- Database::query($sql);
- MessageManager::delete_message_attachment_file($id, $messageInfo['user_sender_id']);
- MessageManager::delete_message_attachment_file($id, $messageInfo['user_receiver_id']);
- return true;
- }
- return false;
- }
- /**
- * Generate the social block for a user.
- *
- * @param Template $template
- * @param int $userId The user id
- * @param string $groupBlock Optional. Highlight link possible values:
- * group_add, home, messages, messages_inbox, messages_compose,
- * messages_outbox, invitations, shared_profile, friends, groups, search
- * @param int $groupId Optional. Group ID
- * @param bool $show_full_profile
- *
- * @return string The HTML code with the social block
- */
- public static function setSocialUserBlock(
- Template $template,
- $userId,
- $groupBlock = '',
- $groupId = 0,
- $show_full_profile = true
- ) {
- if (api_get_setting('allow_social_tool') != 'true') {
- return '';
- }
- $currentUserId = api_get_user_id();
- $userId = (int) $userId;
- $userRelationType = 0;
- $socialAvatarBlock = self::show_social_avatar_block(
- $groupBlock,
- $groupId,
- $userId
- );
- $profileEditionLink = null;
- if ($currentUserId === $userId) {
- $profileEditionLink = Display::getProfileEditionLink($userId);
- } else {
- $userRelationType = self::get_relation_between_contacts($currentUserId, $userId);
- }
- $options = api_get_configuration_value('profile_fields_visibility');
- if (isset($options['options'])) {
- $options = $options['options'];
- }
- $vCardUserLink = Display::getVCardUserLink($userId);
- if (isset($options['vcard']) && $options['vcard'] === false) {
- $vCardUserLink = '';
- }
- $userInfo = api_get_user_info($userId, true, false, true, true);
- if (isset($options['firstname']) && $options['firstname'] === false) {
- $userInfo['firstname'] = '';
- }
- if (isset($options['lastname']) && $options['lastname'] === false) {
- $userInfo['lastname'] = '';
- }
- if (isset($options['email']) && $options['email'] === false) {
- $userInfo['email'] = '';
- }
- // Ofaj
- $hasCertificates = Certificate::getCertificateByUser($userId);
- $userInfo['has_certificates'] = 0;
- if (!empty($hasCertificates)) {
- $userInfo['has_certificates'] = 1;
- }
- $userInfo['is_admin'] = UserManager::is_admin($userId);
- $languageId = api_get_language_id($userInfo['language']);
- $languageInfo = api_get_language_info($languageId);
- if ($languageInfo) {
- $userInfo['language'] = [
- 'label' => $languageInfo['original_name'],
- 'value' => $languageInfo['english_name'],
- 'code' => $languageInfo['isocode'],
- ];
- }
- if (isset($options['language']) && $options['language'] === false) {
- $userInfo['language'] = '';
- }
- if (isset($options['photo']) && $options['photo'] === false) {
- $socialAvatarBlock = '';
- }
- $extraFieldBlock = self::getExtraFieldBlock($userId, true);
- $showLanguageFlag = api_get_configuration_value('social_show_language_flag_in_profile');
- $template->assign('user', $userInfo);
- $template->assign('show_language_flag', $showLanguageFlag);
- $template->assign('extra_info', $extraFieldBlock);
- $template->assign('social_avatar_block', $socialAvatarBlock);
- $template->assign('profile_edition_link', $profileEditionLink);
- //Added the link to export the vCard to the Template
- //If not friend $show_full_profile is False and the user can't see Email Address and Vcard Download Link
- if ($show_full_profile) {
- $template->assign('vcard_user_link', $vCardUserLink);
- }
- if (api_get_setting('gamification_mode') === '1') {
- $gamificationPoints = GamificationUtils::getTotalUserPoints(
- $userId,
- $userInfo['status']
- );
- $template->assign('gamification_points', $gamificationPoints);
- }
- $chatEnabled = api_is_global_chat_enabled();
- if (isset($options['chat']) && $options['chat'] === false) {
- $chatEnabled = '';
- }
- $template->assign('chat_enabled', $chatEnabled);
- $template->assign('user_relation', $userRelationType);
- $template->assign('user_relation_type_friend', USER_RELATION_TYPE_FRIEND);
- $template->assign('show_full_profile', $show_full_profile);
- $templateName = $template->get_template('social/user_block.tpl');
- if (in_array($groupBlock, ['groups', 'group_edit', 'member_list'])) {
- $templateName = $template->get_template('social/group_block.tpl');
- }
- $template->assign('social_avatar_block', $template->fetch($templateName));
- }
- /**
- * @param int $user_id
- * @param $link_shared
- * @param $show_full_profile
- *
- * @return string
- */
- public static function listMyFriends($user_id, $link_shared, $show_full_profile)
- {
- // SOCIALGOODFRIEND , USER_RELATION_TYPE_FRIEND, USER_RELATION_TYPE_PARENT
- $friends = self::get_friends($user_id, USER_RELATION_TYPE_FRIEND);
- $number_of_images = 30;
- $number_friends = count($friends);
- $friendHtml = '';
- if ($number_friends != 0) {
- if ($number_friends > $number_of_images) {
- if (api_get_user_id() == $user_id) {
- $friendHtml .= ' <span><a href="friends.php">'.get_lang('SeeAll').'</a></span>';
- } else {
- $friendHtml .= ' <span>'
- .'<a href="'.api_get_path(WEB_CODE_PATH).'social/profile_friends_and_groups.inc.php'
- .'?view=friends&height=390&width=610&user_id='.$user_id.'"'
- .'class="ajax" data-title="'.get_lang('SeeAll').'" title="'.get_lang('SeeAll').'" >'.get_lang('SeeAll').'</a></span>';
- }
- }
- $friendHtml .= '<ul class="nav nav-list">';
- $j = 1;
- for ($k = 0; $k < $number_friends; $k++) {
- if ($j > $number_of_images) {
- break;
- }
- if (isset($friends[$k])) {
- $friend = $friends[$k];
- $name_user = api_get_person_name($friend['firstName'], $friend['lastName']);
- $user_info_friend = api_get_user_info($friend['friend_user_id'], true);
- if ($user_info_friend['user_is_online']) {
- $statusIcon = Display::span('', ['class' => 'online_user_in_text']);
- } else {
- $statusIcon = Display::span('', ['class' => 'offline_user_in_text']);
- }
- $friendHtml .= '<li>';
- $friendHtml .= '<div>';
- // the height = 92 must be the same in the image_friend_network span style in default.css
- $friends_profile = UserManager::getUserPicture(
- $friend['friend_user_id'],
- USER_IMAGE_SIZE_SMALL
- );
- $friendHtml .= '<img src="'.$friends_profile.'" id="imgfriend_'.$friend['friend_user_id'].'" title="'.$name_user.'"/>';
- $link_shared = (empty($link_shared)) ? '' : '&'.$link_shared;
- $friendHtml .= $statusIcon.'<a href="profile.php?'.'u='.$friend['friend_user_id'].$link_shared.'">'.$name_user.'</a>';
- $friendHtml .= '</div>';
- $friendHtml .= '</li>';
- }
- $j++;
- }
- $friendHtml .= '</ul>';
- } else {
- $friendHtml .= '<div class="">'.get_lang('NoFriendsInYourContactList').'<br />
- <a class="btn btn-primary" href="'.api_get_path(WEB_PATH).'whoisonline.php">
- <em class="fa fa-search"></em> '.get_lang('TryAndFindSomeFriends').'</a></div>';
- }
- $friendHtml = Display::panel($friendHtml, get_lang('SocialFriend').' ('.$number_friends.')');
- return $friendHtml;
- }
- /**
- * @param int $user_id
- * @param $link_shared
- * @param bool $showLinkToChat
- *
- * @return string
- */
- public static function listMyFriendsBlock($user_id, $link_shared = '', $showLinkToChat = false)
- {
- //SOCIALGOODFRIEND , USER_RELATION_TYPE_FRIEND, USER_RELATION_TYPE_PARENT
- $friends = self::get_friends($user_id, USER_RELATION_TYPE_FRIEND);
- $numberFriends = count($friends);
- $friendHtml = '';
- if (!empty($numberFriends)) {
- $friendHtml .= '<div class="list-group contact-list">';
- $j = 1;
- usort(
- $friends,
- function ($a, $b) {
- return strcmp($b['user_info']['user_is_online_in_chat'], $a['user_info']['user_is_online_in_chat']);
- }
- );
- foreach ($friends as $friend) {
- if ($j > $numberFriends) {
- break;
- }
- $name_user = api_get_person_name($friend['firstName'], $friend['lastName']);
- $user_info_friend = api_get_user_info($friend['friend_user_id'], true);
- $statusIcon = Display::return_icon('statusoffline.png', get_lang('Offline'));
- $status = 0;
- if (!empty($user_info_friend['user_is_online_in_chat'])) {
- $statusIcon = Display::return_icon('statusonline.png', get_lang('Online'));
- $status = 1;
- }
- $friendAvatarMedium = UserManager::getUserPicture(
- $friend['friend_user_id'],
- USER_IMAGE_SIZE_MEDIUM
- );
- $friendAvatarSmall = UserManager::getUserPicture(
- $friend['friend_user_id'],
- USER_IMAGE_SIZE_SMALL
- );
- $friend_avatar = '<img src="'.$friendAvatarMedium.'" id="imgfriend_'.$friend['friend_user_id'].'" title="'.$name_user.'" class="user-image"/>';
- $relation = self::get_relation_between_contacts(
- $friend['friend_user_id'],
- api_get_user_id()
- );
- if ($showLinkToChat) {
- $friendHtml .= '<a onclick="javascript:chatWith(\''.$friend['friend_user_id'].'\', \''.$name_user.'\', \''.$status.'\',\''.$friendAvatarSmall.'\')" href="javascript:void(0);" class="list-group-item">';
- $friendHtml .= $friend_avatar.' <span class="username">'.$name_user.'</span>';
- $friendHtml .= '<span class="status">'.$statusIcon.'</span>';
- } else {
- $link_shared = empty($link_shared) ? '' : '&'.$link_shared;
- $friendHtml .= '<a href="profile.php?'.'u='.$friend['friend_user_id'].$link_shared.'" class="list-group-item">';
- $friendHtml .= $friend_avatar.' <span class="username">'.$name_user.'</span>';
- $friendHtml .= '<span class="status">'.$statusIcon.'</span>';
- }
- $friendHtml .= '</a>';
- $j++;
- }
- $friendHtml .= '</div>';
- } else {
- $friendHtml = Display::return_message(get_lang('NoFriendsInYourContactList'), 'warning');
- }
- return $friendHtml;
- }
- /**
- * @return string Get the JS code necessary for social wall to load open graph from URLs.
- */
- public static function getScriptToGetOpenGraph()
- {
- return '<script>
- $(function() {
- $("[name=\'social_wall_new_msg_main\']").on("paste", function(e) {
- $.ajax({
- contentType: "application/x-www-form-urlencoded",
- beforeSend: function() {
- $("[name=\'wall_post_button\']").prop( "disabled", true );
- $(".panel-preview").hide();
- $(".spinner").html("'
- .'<div class=\'text-center\'>'
- .'<em class=\'fa fa-spinner fa-pulse fa-1x\'></em>'
- .'<p>'.get_lang('Loading').' '.get_lang('Preview').'</p>'
- .'</div>'
- .'");
- },
- type: "POST",
- url: "'.api_get_path(WEB_AJAX_PATH).'social.ajax.php?a=read_url_with_open_graph",
- data: "social_wall_new_msg_main=" + e.originalEvent.clipboardData.getData("text"),
- success: function(response) {
- $("[name=\'wall_post_button\']").prop("disabled", false);
- if (!response == false) {
- $(".spinner").html("");
- $(".panel-preview").show();
- $(".url_preview").html(response);
- $("[name=\'url_content\']").val(response);
- $(".url_preview img").addClass("img-responsive");
- } else {
- $(".spinner").html("");
- }
- }
- });
- });
- });
- </script>';
- }
- /**
- * @param string $urlForm
- *
- * @return string
- */
- public static function getWallForm($urlForm)
- {
- $userId = isset($_GET['u']) ? '?u='.intval($_GET['u']) : '';
- $form = new FormValidator(
- 'social_wall_main',
- 'post',
- $urlForm.$userId,
- null,
- ['enctype' => 'multipart/form-data'],
- FormValidator::LAYOUT_HORIZONTAL
- );
- $socialWallPlaceholder = isset($_GET['u']) ? get_lang('SocialWallWriteNewPostToFriend') : get_lang(
- 'SocialWallWhatAreYouThinkingAbout'
- );
- $form->addTextarea(
- 'social_wall_new_msg_main',
- null,
- [
- 'placeholder' => $socialWallPlaceholder,
- 'cols-size' => [1, 10, 1],
- 'aria-label' => $socialWallPlaceholder,
- ]
- );
- $form->addHtml('<div class="form-group">');
- $form->addHtml('<div class="col-sm-4 col-md-offset-1">');
- $form->addFile('picture', get_lang('UploadFile'), ['custom' => true]);
- $form->addHtml('</div>');
- $form->addHtml('<div class="col-sm-6">');
- $form->addButtonSend(
- get_lang('Post'),
- 'wall_post_button',
- false,
- [
- 'cols-size' => [1, 10, 1],
- 'custom' => true,
- ]
- );
- $form->addHtml('</div>');
- $form->addHtml('</div>');
- $form->addHidden('url_content', '');
- $html = Display::panel($form->returnForm(), get_lang('SocialWall'));
- return $html;
- }
- /**
- * @param int $userId
- * @param int $start
- * @param int $length
- * @param array $threadList
- *
- * @return array
- */
- public static function getMyWallMessages($userId, $start = 0, $length = 10, $threadList = [])
- {
- $userGroup = new UserGroup();
- $groups = $userGroup->get_groups_by_user($userId, [GROUP_USER_PERMISSION_READER, GROUP_USER_PERMISSION_ADMIN]);
- $groupList = [];
- if (!empty($groups)) {
- $groupList = array_column($groups, 'id');
- }
- $friends = self::get_friends($userId, USER_RELATION_TYPE_FRIEND);
- $friendList = [];
- if (!empty($friends)) {
- $friendList = array_column($friends, 'friend_user_id');
- }
- $messages = self::getWallMessages(
- $userId,
- 0,
- $groupList,
- $friendList,
- '',
- $start,
- $length,
- false,
- $threadList
- );
- $countPost = self::getCountWallMessagesByUser($userId, $groupList, $friendList, $threadList);
- $messages = self::formatWallMessages($messages);
- $html = '';
- foreach ($messages as $message) {
- $post = $message['html'];
- $comments = '';
- if ($message['msg_status'] == MESSAGE_STATUS_WALL_POST) {
- $comments = self::getWallPostComments($userId, $message);
- }
- $html .= self::wrapPost($message, $post.$comments);
- }
- return [
- 'posts' => $html,
- 'count' => $countPost,
- ];
- }
- /**
- * @param string $message
- * @param string $content
- *
- * @return string
- */
- public static function wrapPost($message, $content)
- {
- return Display::panel($content, '',
- '',
- 'default',
- '',
- 'post_'.$message['id']
- );
- }
- /**
- * @param int $userId
- *
- * @return int
- */
- public static function getCountWallMessagesByUser($userId, $groupList = [], $friendList = [], $threadList = [])
- {
- $count = self::getWallMessages(
- $userId,
- 0,
- $groupList,
- $friendList,
- '',
- 0,
- 0,
- true,
- $threadList
- );
- return $count;
- }
- /**
- * @param int $userId
- *
- * @return string
- */
- public static function getWallMessagesByUser($userId)
- {
- $messages = self::getWallMessages($userId);
- $messages = self::formatWallMessages($messages);
- $html = '';
- foreach ($messages as $message) {
- $post = $message['html'];
- $comments = self::getWallPostComments($userId, $message);
- $html .= self::wrapPost($message, $post.$comments);
- }
- return $html;
- }
- /**
- * Get HTML code block for user skills.
- *
- * @param int $userId The user ID
- * @param string $orientation
- *
- * @return string
- */
- public static function getSkillBlock($userId, $orientation = 'horizontal')
- {
- if (Skill::isAllowed($userId, false) === false) {
- return '';
- }
- $skill = new Skill();
- $ranking = $skill->getUserSkillRanking($userId);
- $template = new Template(null, false, false, false, false, false);
- $template->assign('ranking', $ranking);
- $template->assign('orientation', $orientation);
- $template->assign('skills', $skill->getUserSkillsTable($userId, 0, 0, false)['skills']);
- $template->assign('user_id', $userId);
- $template->assign('show_skills_report_link', api_is_student() || api_is_student_boss() || api_is_drh());
- $skillBlock = $template->get_template('social/skills_block.tpl');
- return $template->fetch($skillBlock);
- }
- /**
- * @param int $user_id
- *
- * @return string|array
- */
- public static function getExtraFieldBlock($user_id, $isArray = false)
- {
- $fieldVisibility = api_get_configuration_value('profile_fields_visibility');
- $fieldVisibilityKeys = [];
- if (isset($fieldVisibility['options'])) {
- $fieldVisibility = $fieldVisibility['options'];
- $fieldVisibilityKeys = array_keys($fieldVisibility);
- }
- $t_ufo = Database::get_main_table(TABLE_EXTRA_FIELD_OPTIONS);
- $extra_user_data = UserManager::get_extra_user_data($user_id);
- $extra_information = '';
- if (is_array($extra_user_data) && count($extra_user_data) > 0) {
- $extra_information_value = '';
- $extraField = new ExtraField('user');
- $listType = [];
- $extraFieldItem = [];
- foreach ($extra_user_data as $key => $data) {
- if (empty($data)) {
- continue;
- }
- if (in_array($key, $fieldVisibilityKeys) && $fieldVisibility[$key] === false) {
- continue;
- }
- // Avoiding parameters
- if (in_array(
- $key,
- [
- 'mail_notify_invitation',
- 'mail_notify_message',
- 'mail_notify_group_message',
- ]
- )) {
- continue;
- }
- // get display text, visibility and type from user_field table
- $field_variable = str_replace('extra_', '', $key);
- $extraFieldInfo = $extraField->get_handler_field_info_by_field_variable(
- $field_variable
- );
- if (in_array($extraFieldInfo['variable'], ['skype', 'linkedin_url'])) {
- continue;
- }
- // if is not visible skip
- if ($extraFieldInfo['visible_to_self'] != 1) {
- continue;
- }
- // if is not visible to others skip also
- if ($extraFieldInfo['visible_to_others'] != 1) {
- continue;
- }
- if (is_array($data)) {
- switch ($extraFieldInfo['field_type']) {
- case ExtraField::FIELD_TYPE_RADIO:
- $objEfOption = new ExtraFieldOption('user');
- $value = $data['extra_'.$extraFieldInfo['variable']];
- $optionInfo = $objEfOption->get_field_option_by_field_and_option(
- $extraFieldInfo['id'],
- $value
- );
- if ($optionInfo && isset($optionInfo[0])) {
- $optionInfo = $optionInfo[0];
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $optionInfo['display_text'],
- ];
- } else {
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => implode(',', $data),
- ];
- }
- break;
- default:
- $extra_information_value .=
- '<li class="list-group-item">'.ucfirst($extraFieldInfo['display_text']).' '
- .' '.implode(',', $data).'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => implode(',', $data),
- ];
- break;
- }
- } else {
- switch ($extraFieldInfo['field_type']) {
- case ExtraField::FIELD_TYPE_RADIO:
- $objEfOption = new ExtraFieldOption('user');
- $optionInfo = $objEfOption->get_field_option_by_field_and_option($extraFieldInfo['id'], $extraFieldInfo['value']);
- break;
- case ExtraField::FIELD_TYPE_GEOLOCALIZATION_COORDINATES:
- case ExtraField::FIELD_TYPE_GEOLOCALIZATION:
- $data = explode('::', $data);
- $data = $data[0];
- $extra_information_value .= '<li class="list-group-item">'.ucfirst($extraFieldInfo['display_text']).': '.$data.'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $data,
- ];
- break;
- case ExtraField::FIELD_TYPE_DOUBLE_SELECT:
- $id_options = explode('::', $data);
- $value_options = [];
- // get option display text from user_field_options table
- foreach ($id_options as $id_option) {
- $sql = "SELECT display_text
- FROM $t_ufo
- WHERE id = '$id_option'";
- $res_options = Database::query($sql);
- $row_options = Database::fetch_row($res_options);
- $value_options[] = $row_options[0];
- }
- $extra_information_value .= '<li class="list-group-item">'.ucfirst($extraFieldInfo['display_text']).': '
- .' '.implode(' ', $value_options).'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $value_options,
- ];
- break;
- case ExtraField::FIELD_TYPE_TAG:
- $user_tags = UserManager::get_user_tags($user_id, $extraFieldInfo['id']);
- $tag_tmp = '';
- foreach ($user_tags as $tags) {
- $tag_tmp .= '<a class="label label_tag"'
- .' href="'.api_get_path(WEB_PATH).'main/social/search.php?q='.$tags['tag'].'">'
- .$tags['tag']
- .'</a>';
- }
- if (is_array($user_tags) && count($user_tags) > 0) {
- $extra_information_value .= '<li class="list-group-item">'.ucfirst($extraFieldInfo['display_text']).': '
- .' '.$tag_tmp.'</li>';
- }
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $tag_tmp,
- ];
- break;
- case ExtraField::FIELD_TYPE_SOCIAL_PROFILE:
- $icon_path = UserManager::get_favicon_from_url($data);
- if (self::verifyUrl($icon_path) == false) {
- break;
- }
- $bottom = '0.2';
- //quick hack for hi5
- $domain = parse_url($icon_path, PHP_URL_HOST);
- if ($domain == 'www.hi5.com' || $domain == 'hi5.com') {
- $bottom = '-0.8';
- }
- $data = '<a href="'.$data.'">'
- .'<img src="'.$icon_path.'" alt="icon"'
- .' style="margin-right:0.5em;margin-bottom:'.$bottom.'em;" />'
- .$extraFieldInfo['display_text']
- .'</a>';
- $extra_information_value .= '<li class="list-group-item">'.$data.'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $data,
- ];
- break;
- case ExtraField::FIELD_TYPE_SELECT_WITH_TEXT_FIELD:
- $parsedData = explode('::', $data);
- if (!$parsedData) {
- break;
- }
- $objEfOption = new ExtraFieldOption('user');
- $optionInfo = $objEfOption->get($parsedData[0]);
- $extra_information_value .= '<li class="list-group-item">'
- .$optionInfo['display_text'].': '
- .$parsedData[1].'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $parsedData[1],
- ];
- break;
- case ExtraField::FIELD_TYPE_TRIPLE_SELECT:
- $optionIds = explode(';', $data);
- $optionValues = [];
- foreach ($optionIds as $optionId) {
- $objEfOption = new ExtraFieldOption('user');
- $optionInfo = $objEfOption->get($optionId);
- $optionValues[] = $optionInfo['display_text'];
- }
- $extra_information_value .= '<li class="list-group-item">'
- .ucfirst($extraFieldInfo['display_text']).': '
- .implode(' ', $optionValues).'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => implode(' ', $optionValues),
- ];
- break;
- default:
- // Ofaj
- // Converts "Date of birth" into "age"
- if ($key === 'terms_datedenaissance') {
- $dataArray = date_to_str_ago($data, 'UTC', true);
- $dataToString = isset($dataArray['years']) && !empty($dataArray['years']) ? $dataArray['years'] : 0;
- if (!empty($dataToString)) {
- $data = $dataToString;
- $extraFieldInfo['display_text'] = get_lang('Age');
- }
- }
- $extra_information_value .= '<li class="list-group-item">'.ucfirst($extraFieldInfo['display_text']).': '.$data.'</li>';
- $extraFieldItem = [
- 'variable' => $extraFieldInfo['variable'],
- 'label' => ucfirst($extraFieldInfo['display_text']),
- 'value' => $data,
- ];
- break;
- }
- }
- $listType[] = $extraFieldItem;
- }
- if ($isArray) {
- return $listType;
- } else {
- // if there are information to show
- if (!empty($extra_information_value)) {
- $extra_information_value = '<ul class="list-group">'.$extra_information_value.'</ul>';
- $extra_information .= Display::panelCollapse(
- get_lang('ExtraInformation'),
- $extra_information_value,
- 'sn-extra-information',
- null,
- 'sn-extra-accordion',
- 'sn-extra-collapse'
- );
- }
- }
- }
- return $extra_information;
- }
- /**
- * @param string $url
- */
- public static function handlePosts($url)
- {
- $friendId = isset($_GET['u']) ? (int) $_GET['u'] : api_get_user_id();
- $url = Security::remove_XSS($url);
- // Main post
- if (!empty($_POST['social_wall_new_msg_main']) || !empty($_FILES['picture']['tmp_name'])) {
- $messageContent = $_POST['social_wall_new_msg_main'];
- if (!empty($_POST['url_content'])) {
- $messageContent = $_POST['social_wall_new_msg_main'].'<br /><br />'.$_POST['url_content'];
- }
- $messageId = self::sendWallMessage(
- api_get_user_id(),
- $friendId,
- $messageContent,
- 0,
- MESSAGE_STATUS_WALL_POST
- );
- if ($messageId && !empty($_FILES['picture']['tmp_name'])) {
- self::sendWallMessageAttachmentFile(
- api_get_user_id(),
- $_FILES['picture'],
- $messageId
- );
- }
- Display::addFlash(Display::return_message(get_lang('MessageSent')));
- header('Location: '.$url);
- exit;
- }
- }
- /**
- * @param int $countPost
- * @param array $htmlHeadXtra
- */
- public static function getScrollJs($countPost, &$htmlHeadXtra)
- {
- // $ajax_url = api_get_path(WEB_AJAX_PATH).'message.ajax.php';
- $socialAjaxUrl = api_get_path(WEB_AJAX_PATH).'social.ajax.php';
- $javascriptDir = api_get_path(LIBRARY_PATH).'javascript/';
- $locale = api_get_language_isocode();
- // Add Jquery scroll pagination plugin
- $htmlHeadXtra[] = api_get_js('jscroll/jquery.jscroll.js');
- // Add Jquery Time ago plugin
- $htmlHeadXtra[] = api_get_asset('jquery-timeago/jquery.timeago.js');
- $timeAgoLocaleDir = $javascriptDir.'jquery-timeago/locales/jquery.timeago.'.$locale.'.js';
- if (file_exists($timeAgoLocaleDir)) {
- $htmlHeadXtra[] = api_get_js('jquery-timeago/locales/jquery.timeago.'.$locale.'.js');
- }
- if ($countPost > self::DEFAULT_WALL_POSTS) {
- $htmlHeadXtra[] = '<script>
- $(function() {
- var container = $("#wallMessages");
- container.jscroll({
- loadingHtml: "<div class=\"well_border\">'.get_lang('Loading').' </div>",
- nextSelector: "a.nextPage:last",
- contentSelector: "",
- callback: timeAgo
- });
- });
- </script>';
- }
- $htmlHeadXtra[] = '<script>
- function deleteMessage(id)
- {
- $.ajax({
- url: "'.$socialAjaxUrl.'?a=delete_message" + "&id=" + id,
- success: function (result) {
- if (result) {
- $("#message_" + id).parent().parent().parent().parent().html(result);
- }
- }
- });
- }
-
- function deleteComment(id)
- {
- $.ajax({
- url: "'.$socialAjaxUrl.'?a=delete_message" + "&id=" + id,
- success: function (result) {
- if (result) {
- $("#message_" + id).parent().parent().parent().html(result);
- }
- }
- });
- }
-
- function submitComment(messageId)
- {
- var data = $("#form_comment_"+messageId).serializeArray();
- $.ajax({
- type : "POST",
- url: "'.$socialAjaxUrl.'?a=send_comment" + "&id=" + messageId,
- data: data,
- success: function (result) {
- if (result) {
- $("#post_" + messageId + " textarea").val("");
- $("#post_" + messageId + " .sub-mediapost").prepend(result);
- $("#post_" + messageId + " .sub-mediapost").append(
- $(\'<div id=result_\' + messageId +\'>'.addslashes(get_lang('Saved')).'</div>\')
- );
-
- $("#result_" + messageId + "").fadeIn("fast", function() {
- $("#result_" + messageId + "").delay(1000).fadeOut("fast", function() {
- $(this).remove();
- });
- });
- }
- }
- });
- }
-
- $(function() {
- timeAgo();
-
- /*$(".delete_message").on("click", function() {
- var id = $(this).attr("id");
- id = id.split("_")[1];
- $.ajax({
- url: "'.$socialAjaxUrl.'?a=delete_message" + "&id=" + id,
- success: function (result) {
- if (result) {
- $("#message_" + id).parent().parent().parent().parent().html(result);
- }
- }
- });
- });
-
-
- $(".delete_comment").on("click", function() {
- var id = $(this).attr("id");
- id = id.split("_")[1];
- $.ajax({
- url: "'.$socialAjaxUrl.'?a=delete_message" + "&id=" + id,
- success: function (result) {
- if (result) {
- $("#message_" + id).parent().parent().parent().html(result);
- }
- }
- });
- });
- */
- });
-
- function timeAgo() {
- $(".timeago").timeago();
- }
- </script>';
- }
- /**
- * @param int $userId
- * @param int $countPost
- *
- * @return string
- */
- public static function getAutoExtendLink($userId, $countPost)
- {
- $userId = (int) $userId;
- $socialAjaxUrl = api_get_path(WEB_AJAX_PATH).'social.ajax.php';
- $socialAutoExtendLink = '';
- if ($countPost > self::DEFAULT_WALL_POSTS) {
- $socialAutoExtendLink = Display::url(
- get_lang('SeeMore'),
- $socialAjaxUrl.'?u='.$userId.'&a=list_wall_message&start='.
- self::DEFAULT_WALL_POSTS.'&length='.self::DEFAULT_SCROLL_NEW_POST,
- [
- 'class' => 'nextPage next',
- ]
- );
- }
- return $socialAutoExtendLink;
- }
- /**
- * @param int $userId
- *
- * @return array
- */
- public static function getThreadList($userId)
- {
- $forumCourseId = api_get_configuration_value('global_forums_course_id');
- require_once api_get_path(SYS_CODE_PATH).'forum/forumfunction.inc.php';
- $threads = [];
- if (!empty($forumCourseId)) {
- $courseInfo = api_get_course_info_by_id($forumCourseId);
- getNotificationsPerUser($userId, true, $forumCourseId);
- $notification = Session::read('forum_notification');
- Session::erase('forum_notification');
- $threadUrlBase = api_get_path(WEB_CODE_PATH).'forum/viewthread.php?'.http_build_query([
- 'cidReq' => $courseInfo['code'],
- ]).'&';
- if (isset($notification['thread']) && !empty($notification['thread'])) {
- $threadList = array_filter(array_unique($notification['thread']));
- $em = Database::getManager();
- $repo = $em->getRepository('ChamiloCourseBundle:CForumThread');
- foreach ($threadList as $threadId) {
- /** @var \Chamilo\CourseBundle\Entity\CForumThread $thread */
- $thread = $repo->find($threadId);
- if ($thread) {
- $threadUrl = $threadUrlBase.http_build_query([
- 'forum' => $thread->getForumId(),
- 'thread' => $thread->getIid(),
- ]);
- $threads[] = [
- 'id' => $threadId,
- 'url' => Display::url(
- $thread->getThreadTitle(),
- $threadUrl
- ),
- 'name' => Display::url(
- $thread->getThreadTitle(),
- $threadUrl
- ),
- 'description' => '',
- ];
- }
- }
- }
- }
- return $threads;
- }
- /**
- * @param int $userId
- *
- * @return string
- */
- public static function getGroupBlock($userId)
- {
- $threadList = self::getThreadList($userId);
- $userGroup = new UserGroup();
- $forumCourseId = api_get_configuration_value('global_forums_course_id');
- $courseInfo = null;
- if (!empty($forumCourseId)) {
- $courseInfo = api_get_course_info_by_id($forumCourseId);
- }
- $social_group_block = '';
- if (!empty($courseInfo)) {
- if (!empty($threadList)) {
- $social_group_block .= '<div class="list-group">';
- foreach ($threadList as $group) {
- $social_group_block .= ' <li class="list-group-item">';
- $social_group_block .= $group['name'];
- $social_group_block .= '</li>';
- }
- $social_group_block .= '</div>';
- }
- $social_group_block .= Display::url(
- get_lang('SeeAllCommunities'),
- api_get_path(WEB_CODE_PATH).'forum/index.php?cidReq='.$courseInfo['code']
- );
- if (!empty($social_group_block)) {
- $social_group_block = Display::panelCollapse(
- get_lang('MyCommunities'),
- $social_group_block,
- 'sm-groups',
- null,
- 'grups-acordion',
- 'groups-collapse'
- );
- }
- } else {
- // Load my groups
- $results = $userGroup->get_groups_by_user(
- $userId,
- [
- GROUP_USER_PERMISSION_ADMIN,
- GROUP_USER_PERMISSION_READER,
- GROUP_USER_PERMISSION_MODERATOR,
- GROUP_USER_PERMISSION_HRM,
- ]
- );
- $myGroups = [];
- if (!empty($results)) {
- foreach ($results as $result) {
- $id = $result['id'];
- $result['description'] = Security::remove_XSS($result['description'], STUDENT, true);
- $result['name'] = Security::remove_XSS($result['name'], STUDENT, true);
- $group_url = "group_view.php?id=$id";
- $link = Display::url(
- api_ucwords(cut($result['name'], 40, true)),
- $group_url
- );
- $result['name'] = $link;
- $picture = $userGroup->get_picture_group(
- $id,
- $result['picture'],
- null,
- GROUP_IMAGE_SIZE_BIG
- );
- $result['picture'] = '<img class="img-responsive" src="'.$picture['file'].'" />';
- $group_actions = '<div class="group-more"><a class="btn btn-default" href="groups.php?#tab_browse-2">'.
- get_lang('SeeMore').'</a></div>';
- $group_info = '<div class="description"><p>'.cut($result['description'], 120, true)."</p></div>";
- $myGroups[] = [
- 'url' => Display::url(
- $result['picture'],
- $group_url
- ),
- 'name' => $result['name'],
- 'description' => $group_info.$group_actions,
- ];
- }
- $social_group_block .= '<div class="list-group">';
- foreach ($myGroups as $group) {
- $social_group_block .= ' <li class="list-group-item">';
- $social_group_block .= $group['name'];
- $social_group_block .= '</li>';
- }
- $social_group_block .= '</div>';
- $form = new FormValidator(
- 'find_groups_form',
- 'get',
- api_get_path(WEB_CODE_PATH).'social/search.php?search_type=2',
- null,
- null,
- FormValidator::LAYOUT_BOX_NO_LABEL
- );
- $form->addHidden('search_type', 2);
- $form->addText(
- 'q',
- get_lang('Search'),
- false,
- [
- 'aria-label' => get_lang('Search'),
- 'custom' => true,
- 'placeholder' => get_lang('Search'),
- ]
- );
- $social_group_block .= $form->returnForm();
- if (!empty($social_group_block)) {
- $social_group_block = Display::panelCollapse(
- get_lang('MyGroups'),
- $social_group_block,
- 'sm-groups',
- null,
- 'grups-acordion',
- 'groups-collapse'
- );
- }
- }
- }
- return $social_group_block;
- }
- /**
- * Returns the formatted header message post.
- *
- * @param int $authorInfo
- * @param int $receiverInfo
- * @param array $message Message data
- *
- * @return string $html The formatted header message post
- */
- private static function headerMessagePost($authorInfo, $receiverInfo, $message)
- {
- $currentUserId = api_get_user_id();
- $iconStatus = null;
- $authorId = (int) $authorInfo['user_id'];
- $receiverId = (int) $receiverInfo['user_id'];
- $userStatus = (int) $authorInfo['status'];
- $urlImg = api_get_path(WEB_IMG_PATH);
- $isAdmin = self::is_admin($authorId);
- if ($userStatus === 5) {
- if ($authorInfo['has_certificates']) {
- $iconStatus = '<img class="pull-left" src="'.$urlImg.'icons/svg/identifier_graduated.svg" width="22px" height="22px">';
- } else {
- $iconStatus = '<img class="pull-left" src="'.$urlImg.'icons/svg/identifier_student.svg" width="22px" height="22px">';
- }
- } else {
- if ($userStatus === 1) {
- if ($isAdmin) {
- $iconStatus = '<img class="pull-left" src="'.$urlImg.'icons/svg/identifier_admin.svg" width="22px" height="22px">';
- } else {
- $iconStatus = '<img class="pull-left" src="'.$urlImg.'icons/svg/identifier_teacher.svg" width="22px" height="22px">';
- }
- }
- }
- $date = Display::dateToStringAgoAndLongDate($message['send_date']);
- $avatarAuthor = $authorInfo['avatar'];
- $urlAuthor = api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$authorId;
- $nameCompleteAuthor = $authorInfo['complete_name'];
- $urlReceiver = api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$receiverId;
- $nameCompleteReceiver = $receiverInfo['complete_name'];
- $htmlReceiver = '';
- if ($authorId !== $receiverId) {
- $htmlReceiver = ' > <a href="'.$urlReceiver.'">'.$nameCompleteReceiver.'</a> ';
- }
- if (!empty($message['group_info'])) {
- $htmlReceiver = ' > <a href="'.$message['group_info']['url'].'">'.$message['group_info']['name'].'</a> ';
- }
- $canEdit = ($currentUserId == $authorInfo['user_id'] || $currentUserId == $receiverInfo['user_id']) && empty($message['group_info']);
- if (!empty($message['thread_id'])) {
- $htmlReceiver = ' > <a href="'.$message['thread_url'].'">'.$message['forum_title'].'</a> ';
- $canEdit = false;
- }
- $postAttachment = self::getPostAttachment($message);
- $html = '';
- $html .= '<div class="top-mediapost" >';
- $html .= '<div class="pull-right btn-group btn-group-sm">';
- $html .= MessageManager::getLikesButton(
- $message['id'],
- $currentUserId,
- !empty($message['group_info']['id']) ? (int) $message['group_info']['id'] : 0
- );
- if ($canEdit) {
- $htmlDelete = Display::url(
- Display::returnFontAwesomeIcon('trash', '', true),
- 'javascript:void(0)',
- [
- 'id' => 'message_'.$message['id'],
- 'title' => get_lang('SocialMessageDelete'),
- 'onclick' => 'deleteMessage('.$message['id'].')',
- 'class' => 'btn btn-default',
- ]
- );
- $html .= $htmlDelete;
- }
- $html .= '</div>';
- $html .= '<div class="user-image" >';
- $html .= '<a href="'.$urlAuthor.'">
- <img class="avatar-thumb" src="'.$avatarAuthor.'" alt="'.$nameCompleteAuthor.'"></a>';
- $html .= '</div>';
- $html .= '<div class="user-data">';
- $html .= $iconStatus;
- $html .= '<div class="username"><a href="'.$urlAuthor.'">'.$nameCompleteAuthor.'</a>'.$htmlReceiver.'</div>';
- $html .= '<div class="post-date">'.$date.'</div>';
- $html .= '</div>';
- $html .= '<div class="msg-content">';
- if (!empty($postAttachment)) {
- $html .= '<div class="post-attachment thumbnail">';
- $html .= $postAttachment;
- $html .= '</div>';
- }
- $html .= '<div>'.Security::remove_XSS($message['content']).'</div>';
- $html .= '</div>';
- $html .= '</div>'; // end mediaPost
- // Popularity post functionality
- $html .= '<div class="popularity-mediapost"></div>';
- return $html;
- }
- }
|