34require
'../main.inc.php';
35require_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
36require_once DOL_DOCUMENT_ROOT.
'/core/lib/socialnetwork.lib.php';
37require_once DOL_DOCUMENT_ROOT.
'/core/modules/modSocialNetworks.class.php';
38require_once DOL_DOCUMENT_ROOT.
'/core/class/infobox.class.php';
39require_once DOL_DOCUMENT_ROOT.
'/core/class/fediverseparser.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/core/boxes/box_fediverse.php';
51$langs->loadLangs(array(
'admin',
'users',
'dict'));
53$action =
GETPOST(
'action',
'aZ09');
64$oauthservices = array();
66foreach (
$conf->global as $key => $val) {
67 if (!empty($val) && preg_match(
'/^OAUTH_.*_ID$/', $key)) {
68 $key = preg_replace(
'/^OAUTH_/',
'', $key);
69 $key = preg_replace(
'/_ID$/',
'', $key);
70 if (preg_match(
'/^.*-/', $key)) {
71 $name = preg_replace(
'/^.*-/',
'', $key);
73 $name = $langs->trans(
"NoName");
75 $provider = preg_replace(
'/-.*$/',
'', $key);
76 $provider = ucfirst(strtolower($provider));
78 $oauthservices[$key] = $name.
" (".$provider.
")";
86if ($action ==
'add') {
89 if (empty(
GETPOST(
'socialnetwork_name')) || empty(
GETPOST(
'socialnetwork_url'))) {
93 $socialNetworkName =
GETPOST(
'socialnetwork_name',
'alpha');
94 $socialNetworkUrl =
GETPOST(
'socialnetwork_url',
'alpha');
100 $paramNames =
GETPOST(
'param_name',
'array');
101 $paramValues =
GETPOST(
'param_value',
'array');
103 $additionalParams = [];
104 if (!empty($paramNames) && is_array($paramNames)) {
105 foreach ($paramNames as $index => $paramName) {
106 if (!empty($paramName) && isset($paramValues[$index])) {
107 $additionalParams[$paramName] = $paramValues[$index];
114 $socialNetworkData = array(
115 'title' => $socialNetworkName,
116 'url' => $socialNetworkUrl
119 $socialNetworkData = array_merge($socialNetworkData, $additionalParams);
121 $boxlabel =
'(SocialNetwoksInformations)';
123 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"boxes_def (file, note, entity)";
124 $sql .=
" VALUES ('box_fediverse.php', '".$db->escape($socialNetworkName).
"', ".((int)
$conf->entity).
")";
126 if (!$db->query($sql)) {
127 dol_print_error($db);
130 $jsonData = json_encode($socialNetworkData);
131 $result =
dolibarr_set_const($db,
"SOCIAL_NETWORKS_DATA_".$socialNetworkName, $jsonData,
'chaine', 0,
'',
$conf->entity);
134 setEventMessages($langs->trans(
"ErrorInputRequired"),
null,
'errors');
140 header(
"Location: ".$_SERVER[
"PHP_SELF"]);
144 dol_print_error($db);
148if ($action ==
'confirm_delete' &&
GETPOST(
'confirm') ==
'yes') {
150 $key =
GETPOST(
'key',
'alpha');
152 $sqlgetName =
"SELECT note FROM ".MAIN_DB_PREFIX.
"boxes_def WHERE rowid = ".((int) $key).
" AND file = 'box_fediverse.php' AND entity = ".((int)
$conf->entity);
154 $resqName = $db->query($sqlgetName);
156 $objName = $db->fetch_object($resqName);
157 $name = $objName->note;
162 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"boxes";
163 $sql .=
" WHERE entity = ".((int)
$conf->entity);
164 $sql .=
" AND box_id = ".((int) $key);
165 $resql1 = $db->query($sql);
167 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"boxes_def";
168 $sql .=
" WHERE rowid = ".((int) $key);
169 $sql .=
" AND file = 'box_fediverse.php' AND entity = ".((int)
$conf->entity);
170 $resql2 = $db->query($sql);
172 if (!$resql1 || !$resql2) {
174 dol_print_error($db,
"sql=".$sql);
180 header(
"Location: ".$_SERVER[
"PHP_SELF"]);
184 dol_print_error($db);
189if ($action ==
'updatesocialnetwork') {
192 $url =
GETPOST(
'socialnetwork_url',
'alpha');
195 $resqName = $db->query(
"SELECT note FROM ".MAIN_DB_PREFIX.
"boxes_def WHERE rowid = ".((
int)
$id).
" AND file = 'box_fediverse.php' AND entity = ".((
int)
$conf->entity));
196 if ($resqName && ($objName = $db->fetch_object($resqName))) {
197 $name = $objName->note;
199 $paramsKey =
GETPOST(
'paramsKey',
'array');
200 $paramsVal =
GETPOST(
'paramsVal',
'array');
204 $socialNetworkData = json_decode($result,
true);
206 foreach ($paramsKey as $index => $key) {
207 if (empty($key) || empty($paramsVal[$index])) {
212 foreach ($socialNetworkData as $key => $value) {
213 if ($key !=
'title' && $key !=
'url') {
214 unset($socialNetworkData[$key]);
219 $mergedParams = array();
220 foreach ($paramsKey as $index => $key) {
221 if (isset($paramsVal[$index])) {
222 $mergedParams[$key] = $paramsVal[$index];
227 foreach ($mergedParams as $newKey => $newValue) {
228 if (!isset($socialNetworkData[$newKey]) || $socialNetworkData[$newKey] !== $newValue) {
229 $socialNetworkData[$newKey] = $newValue;
232 if (empty($name) || !is_array($socialNetworkData)) {
234 } elseif (!empty($url)) {
235 $socialNetworkData[
'url'] = $url;
238 $newData = json_encode($socialNetworkData);
242 header(
"Location: ".$_SERVER[
"PHP_SELF"]);
246 dol_print_error($db);
249 setEventMessages($langs->trans(
"ErrorInputRequired"),
null,
'errors');
250 header(
"Location: ".$_SERVER[
"PHP_SELF"].
'?action=editsocialnetwork&token='.
newToken().
'&key='.
$id);
255if ($action ==
'editsocialnetwork' &&
GETPOST(
'confirm') ==
'yes') {
256 $paramKey =
GETPOST(
'paramkey',
'alpha');
257 $key =
GETPOST(
'key',
'alpha');
262 $socialNetworkData = json_decode($result,
true);
264 unset($socialNetworkData[$paramKey]);
265 $newData = json_encode($socialNetworkData);
270 header(
"Location: ".$_SERVER[
"PHP_SELF"].
'?action=editsocialnetwork&token='.
newToken().
'&key='.urlencode($key));
274 dol_print_error($db);
284$form =
new Form($db);
286llxHeader(
'', $langs->trans(
"FediverseSetup"),
'',
'', 0, 0,
'',
'',
'',
'mod-admin page-dict');
288$head = socialnetwork_prepare_head();
290$linkback =
'<a href="'.dolBuildUrl(DOL_URL_ROOT.
'/admin/modules.php', [
'restore_lastsearch_values' => 1]).
'">'.img_picto($langs->trans(
"BackToModuleList"),
'back',
'class="pictofixedwidth"').
'<span class="hideonsmartphone">'.$langs->trans(
"BackToModuleList").
'</span></a>';
292print
dol_get_fiche_head($head,
'divers', $langs->trans(
'MenuDict'), -1,
'user', 0, $linkback,
'', 0,
'', 0);
294$title = $langs->trans(
"ConfigImportSocialNetwork");
296print_barre_liste($title, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', -1,
'',
'tools', 0,
'',
'', -1, 0, 0, 0,
'');
299print
'<form action="'.$_SERVER[
"PHP_SELF"].
'" method="post" spellcheck="false">';
300print
'<input type="hidden" name="token" value="'.newToken().
'">';
302print
'<div class="div-table-responsive-no-min">';
303print
'<table class="noborder centpercent">';
305print
'<tr class="liste_titre">';
306print
'<td colspan="2">'.$langs->trans(
"NewSocialNetwork").
'</td>';
307print
'<td>'.$langs->trans(
"Example").
'</td>';
310print
'<tr class="oddeven">';
311print
'<td>'.$langs->trans(
"Title").
'</td>';
312print
'<td><input type="text" class="flat minwidth300" name="socialnetwork_name"></td>';
313print
'<td>Mastodon</td>';
316print
'<tr class="oddeven">';
317print
'<td>'.$langs->trans(
'SocialNetworkUrl').
'</td>';
318print
'<td><input type="text" class="flat minwidth300" name="socialnetwork_url"></td>';
319print
'<td>https://mastodon.social/api/v1/accounts/id_user</td>';
321$vartosmtpstype =
'MAIN_MAIL_SMTPS_AUTH_TYPE_EMAILING';
324$(document).ready(function() {
325 function toggleOAuthServiceDisplay() {
326 if ($("#radio_oauth").is(":checked")) {
327 $("#oauth_service_div").show();
329 $("#oauth_service_div").hide();
333 toggleOAuthServiceDisplay();
335 $("input[name=\"'.$vartosmtpstype.
'\"]").change(function() {
336 toggleOAuthServiceDisplay();
342print
'<tr><td>'.$langs->trans(
"MAIN_MAIL_SMTPS_AUTH_TYPE").
'</td>';
344print
'<input type="radio" id="radio_oauth" name="'.$vartosmtpstype.
'" value="XOAUTH2"'.(
getDolGlobalString($vartosmtpstype) ==
'XOAUTH2' ?
' checked' :
'').(
isModEnabled(
'oauth') ?
'' :
' disabled').
'>';
345print
'<label for="radio_oauth">'.$form->textwithpicto($langs->trans(
"UseOauth"), $langs->trans(
"OauthNotAvailableForAllAndHadToBeCreatedBefore")).
'</label>';
347 print
' <a href="'.DOL_URL_ROOT.
'/admin/modules.php?search_keyword=oauth">'.$langs->trans(
"EnableModuleX",
"OAuth").
'</a>';
349 print
' <a href="'.DOL_URL_ROOT.
'/admin/oauth.php">'.$langs->trans(
"SetupModuleX",
" OAuth").
'</a>';
354print
'<tr class="oddeven" id="oauth_service_div" style="display: none;">';
355print
'<td>'.$langs->trans(
"MAIN_MAIL_SMTPS_OAUTH_SERVICE").
'</td>';
358$oauthservicesStringKeys = [];
359foreach ($oauthservices as $key => $value) {
360 $key = (string) $key;
361 $oauthservicesStringKeys[$key] = $value;
365if (!
isModEnabled(
'multicompany') || ($user->admin && !$user->entity)) {
366 print $form->selectarray(
'OAUTH_SERVICE_SOCIAL_NETWORK', $oauthservicesStringKeys, (
string)
getDolGlobalString(
"OAUTH_SERVICE_SOCIAL_NETWORK"));
369 $text = isset($oauthservicesStringKeys[$selectedKey]) ? $oauthservicesStringKeys[$selectedKey][
'label'] :
'';
371 $text = $langs->trans(
"Undefined");
373 $htmltext = $langs->trans(
"ContactSuperAdminForChange");
374 print $form->textwithpicto($text, $htmltext, 1,
'superadmin');
375 print
'<input type="hidden" name="OAUTH_SERVICE_SOCIAL_NETWORK" value="'.$selectedKey.
'">';
380print
'<tr class="oddeven" id="add_param_row"><td>';
381print $form->textwithpicto($langs->trans(
"Others"), $langs->trans(
"AddMoreParams"));
382print
'</td><td><button type="button" id="addParamButton">'.img_picto($langs->trans(
"AddMoreParams"),
'add',
'pictofixedwidth').
'</button></td>';
383print
'<td>Token : ****<br>Cookie : ****</td>';
386print
'<tr class="oddeven">';
387print
'<td colspan="2">';
388print
'<div id="additionalParams"></div>';
398print $form->buttonsSaveCancel(
"Add",
'');
399print
'<input type="hidden" name="action" value="add">';
400print
'<script type="text/javascript">
401 $(document).ready(function() {
402 function toggleOAuthServiceDisplay() {
403 if ($("#radio_oauth").is(":checked")) {
404 $("#oauth_service_div").show(); // Show the OAuth selector
406 $("#oauth_service_div").hide(); // Hide the OAuth selector
410 function toggleAddParamRow() {
411 if ($("#radio_oauth").is(":checked")) {
412 $("#add_param_row").hide(); // Hide the entire line
414 $("#add_param_row").show(); // Show the entire line
418 toggleOAuthServiceDisplay();
421 $("input[name=\"'.$vartosmtpstype.
'\"]").change(function() {
422 toggleOAuthServiceDisplay();
426 $("#addParamButton").click(function() {
427 var container = $("#additionalParams");
428 var index = container.children().length;
429 var newParam = $("<div class=\'pair-group\'><input type=\'text\' class=\'flat minwidth300\' name=\'param_name[]\' placeholder=\''.$langs->trans(
"ParamName").
'\' class=\
'flat\' /> <input type=\'text\' class=\'flat minwidth300\' name=\'param_value[]\' placeholder=\''.$langs->trans(
"ParamValue").
'\' class=\
'flat\' /></div>");
430 container.append(newParam);
437print
'<span class="opacitymedium">'.$langs->trans(
'SocialNetworksNote').
'</span>';
439print
'<a href="'.DOL_URL_ROOT.
'/admin/boxes.php?backtopage='.urlencode($_SERVER[
"PHP_SELF"]).
'">'.$langs->trans(
'JumpToBoxes').
'</a>';
443if ($action ==
'deletesocialnetwork') {
444 $formconfirm = $form->formconfirm(
445 $_SERVER[
"PHP_SELF"].
'?key='.urlencode(
GETPOST(
'key',
'alpha')),
446 $langs->trans(
'Delete'),
447 $langs->trans(
'ConfirmDeleteSocialNetwork',
GETPOST(
'key',
'alpha')),
456if ($action ==
'editsocialnetwork' &&
GETPOST(
'paramkey',
'alpha')) {
457 $paramKey =
GETPOST(
'paramkey',
'alpha');
458 $name =
GETPOST(
'name',
'alpha');
460 $formconfirm = $form->formconfirm(
461 $_SERVER[
"PHP_SELF"].
'?key='.urlencode(
GETPOST(
'key',
'alpha')).
'¶mkey='.urlencode($paramKey).
'&name='.urlencode($name),
462 $langs->trans(
'Delete'),
463 $langs->trans(
'ConfirmDeleteParamOfSocialNetwork', $paramKey),
471$sql =
"SELECT rowid, file, note FROM ".MAIN_DB_PREFIX.
"boxes_def";
472$sql .=
" WHERE file = 'box_fediverse.php'";
473$sql .=
" AND entity = ".((int)
$conf->entity);
474$sql .=
" ORDER BY note";
476dol_syslog(
"select socialnetworks boxes", LOG_DEBUG);
477$resql = $db->query($sql);
480 $num = $db->num_rows($resql);
483 $obj = $db->fetch_object($resql);
487 $socialNetworkData = json_decode($jsonData,
true);
489 $socialNetworkTitle = $socialNetworkData[
'title'];
490 $socialNetworkUrl = $socialNetworkData[
'url'];
491 $socialNetworkId = $obj->rowid;
493 $path_fediverse = DOL_DATA_ROOT.
'/fediverse/temp/'.$socialNetworkTitle;
497 foreach ($socialNetworkData as $key => $value) {
498 if ($key !==
'title' && $key !==
'url') {
499 $authParams[$key] = $value;
504 $result = $fediverseparser->fetchPosts($socialNetworkUrl, 5, 300, $path_fediverse, $authParams);
507 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'" method="post" spellcheck="false">'.
"\n";
508 print
'<input type="hidden" name="token" value="'.newToken().
'">'.
"\n";
510 print
'<table class="noborder centpercent">'.
"\n";
512 print
'<tr class="liste_titre">';
513 print
"<td>".$langs->trans(
"SocialNetworks").
" ".($i + 1).
"</td>";
514 print
'<td class="right">';
515 print
'<a class="viewfielda reposition marginleftonly marginrighttonly showInputBtn" href="'.$_SERVER[
"PHP_SELF"].
'?action=editsocialnetwork&token='.
newToken().
'&key='.urlencode($socialNetworkId).
'">'.img_edit().
'</a>';
516 print
'<a class="deletefielda reposition marginleftonly right" href="'.$_SERVER[
"PHP_SELF"].
'?action=deletesocialnetwork&token='.
newToken().
'&key='.urlencode($socialNetworkId).
'">'.img_delete().
'</a>';
517 print
'<input type="hidden" name="id" value="'.$socialNetworkId.
'">';
521 print
'<tr class="oddeven">';
522 print
'<td>'.$langs->trans(
"Title").
"</td>";
523 print
'<td><input type="text" class="flat minwidth300" name="socialnetwork_name" value="'.dol_escape_htmltag($socialNetworkTitle).
'" disabled></td>';
526 print
'<tr class="oddeven">';
527 print
"<td>".$langs->trans(
"URL").
"</td>";
528 print
'<td><input type="text" class="flat minwidth300" name="socialnetwork_url" value="'.dol_escape_htmltag($socialNetworkUrl).
'" '.($action !=
"editsocialnetwork" ?
'disabled' :
'').
'></td>';
531 print
'<tr class="oddeven">';
532 print
"<td>".$langs->trans(
"Status").
"</td>";
534 if ($result > 0 && empty($fediverseparser->error)) {
535 print
'<span class="ok">'.img_picto($langs->trans(
"Online"),
'tick',
'class="pictofixedwidth"').$langs->trans(
"Online").
'</div>';
537 print
'<span class="error">'.$langs->trans(
"Offline");
538 $langs->load(
"errors");
539 if ($fediverseparser->error) {
540 print
' - '.$langs->trans($fediverseparser->error);
550 print
'<tr class="oddeven">';
551 print
'<td>'.$langs->trans(
'WidgetAvailable').
'</td>';
552 print
'<td>'.yn($active);
553 print
' - <a href="'.DOL_URL_ROOT.
'/admin/boxes.php?backtopage='.urlencode($_SERVER[
"PHP_SELF"]).
'">';
554 print $langs->trans(
"JumpToBoxes");
559 if ($action ==
'editsocialnetwork' && $socialNetworkId ==
GETPOST(
'key')) {
560 foreach ($socialNetworkData as $k => $val) {
561 if ($k !=
'title' && $k !=
'url') {
562 print
'<tr class="oddeven">';
563 print
'<td><input type="text" class="flat minwidth200" name="paramsKey[]" value="'.dol_escape_htmltag($k).
'"</td>';
564 if ($k ==
'password') {
565 print
'<td><input type="password" class="flat minwidth300" name="paramsVal[]" value="'.dol_escape_htmltag($val).
'" />';
567 print
'<td><input type="text" class="flat minwidth300" name="paramsVal[]" value="'.dol_escape_htmltag($val).
'" />';
569 print
'<button type="button" class="delete-param-btn" data-paramkey="'.htmlspecialchars($k).
'">'.img_delete().
'</button>';
576 print
'<tr class="oddeven">';
577 print
'<td><input type="hidden" name="action" value="updatesocialnetwork" /></td>';
578 print
'<td><input class="button " type="submit" name="update" value="'.$langs->trans(
'Modify').
'" /></td>';
582 $(document).ready(function() {
583 $(\'.delete-param-btn\').on(\'click\', function() {
584 var paramKey = $(this).data(\'paramkey\');
585 var socialNetworkId = \''.htmlspecialchars($socialNetworkId).
'\';
586 var socialNetworkName = \
''.htmlspecialchars($socialNetworkTitle).
'\';
587 window.location.href = \
''.$_SERVER[
"PHP_SELF"].
'?action=editsocialnetwork&token='.
newToken().
'¶mkey=\' + encodeURIComponent(paramKey) + \'&key=\' + encodeURIComponent(socialNetworkId) + \'&name=\' + encodeURIComponent(socialNetworkName);
593 print
'</table>'.
"\n";
600 dol_print_error($db);
617 foreach ($boxlist as $box) {
618 if ($box->boxcode ===
"lastfediverseinfos" && (
int) $box->box_id ===
$id) {
$id
Support class for third parties, contacts, members, users or resources.
dolibarr_set_const($db, $name, $value, $type='chaine', $visible=0, $note='', $entity=1)
Insert a parameter (key,value) into database (delete old key then insert it again).
dolibarr_del_const($db, $name, $entity=1)
Delete a constant.
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
static listBoxes($dbs, $mode, $zone, $user=null, $excludelist=array(), $includehidden=1)
Return array of boxes qualified for area and user.
Class to manage Social network posts.
_isInBoxListFediverse(int $id, array $boxlist)
Check if the given fediverse feed if inside the list of boxes/widgets.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.