21include_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
55 public $file_source_url;
82 public $dolistore_api_url;
86 public $dolistore_api_key;
91 public $dolistoreApiStatus;
96 public $dolistoreApiError;
101 public $githubFileStatus;
106 public $githubFileError;
116 public $numberOfProviders;
126 public $numberTotalOfProducts;
131 public $numberTotalOfPages;
136 public $numberOfProducts;
147 $this->debug_api = $debug;
149 $this->url = DOL_URL_ROOT.
'/admin/modules.php?mode=marketplace';
152 $this->dolistore_api_url =
getDolGlobalString(
'MAIN_MODULE_DOLISTORE_API_SRV',
'https://www.dolistore.com/api/');
153 $this->dolistore_api_key =
getDolGlobalString(
'MAIN_MODULE_DOLISTORE_API_KEY',
'dolistorepublicapi');
154 $this->shop_url =
getDolGlobalString(
'MAIN_MODULE_DOLISTORE_SHOP_URL',
'https://www.dolistore.com');
157 $this->file_source_url =
"https://raw.githubusercontent.com/Dolibarr/dolibarr-community-modules/refs/heads/main/index.yaml";
158 $this->cache_file = DOL_DATA_ROOT.
'/admin/temp/remote_github_modules_file.yaml';
160 $lang = $langs->defaultlang;
161 $lang_array = array(
'en_US',
'fr_FR',
'es_ES',
'it_IT',
'de_DE');
162 if (!in_array($lang, $lang_array)) {
178 $cachedelayforgithubrepo =
getDolGlobalInt(
'MAIN_REMOTE_GITHUBREPO_CACHE_DELAY', 86400);
182 $this->githubFileError = $this->error;
183 $this->githubFileStatus =
dol_is_file($this->cache_file) ? 1 : 0;
192 $this->numberOfProviders = $this->dolistoreApiStatus + $this->githubFileStatus;
202 public function callApi($resource, $options =
false)
205 if (empty($this->dolistore_api_key) || empty($this->dolistore_api_url)) {
206 return array(
'status_code' => 0,
'response' =>
null);
213 $httpheader = array(
'DOLAPIKEY: '.$this->dolistore_api_key);
214 if ($basicAuthLogin) {
215 $httpheader[] =
'Authorization: Basic '.base64_encode($basicAuthLogin.
':'.$basicAuthPassword);
218 $url = $this->dolistore_api_url . (preg_match(
'/\/$/', $this->dolistore_api_url) ?
'' :
'/') . $resource;
220 $options[
'apikey'] = $this->dolistore_api_key;
223 $url .=
'?' . http_build_query($options);
226 $response =
getURLContent($url,
'GET',
'', 1, $httpheader, array(
'https'), 0, -1, 5, 5);
228 $status_code = $response[
'http_code'];
231 if ($status_code == 200) {
232 $body = $response[
'content'];
233 $body = json_decode($body,
true);
234 $returnarray = array(
235 'status_code' => $status_code,
239 $returnarray = array(
240 'status_code' => $status_code,
243 if (!empty($response[
'curl_error_no'])) {
244 $returnarray[
'curl_error_no'] = $response[
'curl_error_no'];
246 if (!empty($response[
'curl_error_msg'])) {
247 $returnarray[
'curl_error_msg'] = $response[
'curl_error_msg'];
264 if (!empty($this->cache_file) && file_exists($this->cache_file)) {
265 dol_syslog(__METHOD__ .
" - Loading cache file: " . $this->cache_file, LOG_DEBUG);
267 $content = file_get_contents($this->cache_file);
268 if ($content !==
false) {
269 $modules = $this->
readYaml($content);
271 dol_syslog(__METHOD__ .
" - Error reading cache file", LOG_ERR);
286 $organized_tree = array();
290 'lang' => $this->lang
295 $resCategories = $this->
callApi(
'categories', $data);
296 if (isset($resCategories[
'response']) && is_array($resCategories[
'response'])) {
297 $organized_tree = $resCategories[
'response'];
303 foreach ($organized_tree as $key => $value) {
304 if ($value[
'label'] !=
"Versions" && $value[
'label'] !=
"Specials") {
305 $html .=
'<li' . ($current == $value[
'rowid'] ?
' class="active"' :
'') .
'>';
306 $html .=
'<a href="?mode=marketplace&categorie=' . $value[
'rowid'] .
'">' . $value[
'label'] .
'</a>';
307 if (isset($value[
'children'])) {
309 usort($value[
'children'], $this->
buildSorter(
'position'));
310 foreach ($value[
'children'] as $key_children => $value_children) {
311 $html .=
'<li' . ($current == $value_children[
'rowid'] ?
' class="active"' :
'') .
'>';
312 $html .=
'<a href="?mode=marketplace&categorie=' . $value_children[
'rowid'] .
'" title="' .
dol_escape_htmltag(strip_tags($value_children[
'description'])) .
'">' . $value_children[
'label'] .
'</a>';
334 $langs->load(
"products");
337 $last_month =
dol_now() - (30 * 24 * 60 * 60);
338 $dolibarrversiontouse = DOL_VERSION;
340 $this->products = array();
343 $installedModules = array();
344 if (is_array($modules)) {
345 foreach ($modules as $objMod) {
346 if (is_object($objMod) && $objMod->isCoreOrExternalModule() !=
'core') {
347 $moduleName = strtolower($objMod->name);
348 $moduleVersion = $objMod->getVersion(0);
349 $installedModules[$moduleName] = $moduleVersion;
354 $this->categorie = $options[
'categorie'] ?? 0;
355 $this->per_page = $options[
'per_page'] ?? 11;
356 $this->no_page = $options[
'no_page'] ?? 1;
357 $this->search = $options[
'search'] ??
'';
359 $this->per_page = 11;
362 if (!empty($this->search) && strlen(str_replace(
' ',
'', (
string) $this->search)) < 2) {
363 $html .=
'<tr class=""><td colspan="3" class="center">';
365 $html .= $langs->trans(
"SearchStringMinLength").
'...';
367 $html .=
'</td></tr>';
372 'categorieid' => $this->categorie,
373 'limit' => $this->per_page,
374 'page' => $this->no_page,
375 'search' => $this->search,
376 'lang' => $this->lang
380 $this->numberTotalOfProducts = 0;
383 if ($this->categorie == 87) {
384 $html =
'<div class="shop-container">
385 <div class="shop-image">
386 <a href="https://merch.dolibarr.org/" target="_blank">
387 <img src="https://www.dolistore.com/medias/image/marketplace/img/goodies-shop.jpg" width="50%" alt="DoliStore Merch and Gifts" />
388 <div class="shop-overlay">
389 <button target="new" class="shop-button">'.$langs->trans(
"GoodiesButtonTitle").
' <i class="icon-chevron-right"></i></button>
400 $dolistoreProducts = array();
401 $dolistoreProductsTotal = 0;
402 if ($this->dolistoreApiStatus > 0 &&
getDolGlobalInt(
'MAIN_ENABLE_EXTERNALMODULES_DOLISTORE')) {
403 $getDolistoreProducts = $this->
callApi(
'products', $data);
405 if (!isset($getDolistoreProducts[
'response']) || !is_array($getDolistoreProducts[
'response']) || ($getDolistoreProducts[
'status_code'] != 200 && $getDolistoreProducts[
'status_code'] != 201)) {
406 $dolistoreProducts = array();
407 $dolistoreProductsTotal = 0;
409 $dolistoreProducts = $this->
adaptData($getDolistoreProducts[
'response'][
'products'],
'dolistore');
410 $dolistoreProductsTotal = (int) $getDolistoreProducts[
'response'][
'total'];
411 $this->numberTotalOfProducts += $dolistoreProductsTotal;
417 $fileProducts = array();
418 $fileProductsTotal = 0;
419 if (!empty($this->githubFileStatus) &&
getDolGlobalInt(
'MAIN_ENABLE_EXTERNALMODULES_COMMUNITY')) {
422 $fileProducts = $this->
adaptData($fileProducts,
'githubcommunity');
424 $fileProducts = $this->
applyFilters($fileProducts, $data);
426 $fileProductsTotal = $fileProducts[
'total'];
428 $this->numberTotalOfProducts += $fileProductsTotal;
430 $fileProducts = $fileProducts[
'data'];
434 $this->numberTotalOfPages = (int) ceil(max($fileProductsTotal / $this->per_page, $dolistoreProductsTotal / $this->per_page));
437 $this->products = $dolistoreProducts;
438 foreach ($fileProducts as $fileProduct) {
439 $id = $fileProduct[
'id'];
441 if (empty($this->products[
$id])) {
442 array_unshift($this->products, $fileProduct);
444 $this->products[
$id] = $fileProduct;
445 $this->products[
$id][
'category'] = $fileProduct[
'category'];
448 array_unshift($this->products, $fileProduct);
454 foreach ($this->products as $product) {
459 if ($last_month < strtotime($product[
'datec']) && $product[
"status"] !=
'soon' && $product[
"status"] !=
'development' && $product[
"status"] !=
'experimental') {
460 $newapp .=
'<span class="newApp" title="'.$product[
'tms'].
'">'.$langs->trans(
'New').
'</span> ';
464 if ($newapp ==
'' && $last_month < strtotime($product[
'tms']) && $product[
"status"] !=
'soon' && $product[
"status"] !=
'development' && $product[
"status"] !=
'experimental') {
465 $newapp .=
'<span class="updatedApp" title="'.$product[
'tms'].
'">'.$langs->trans(
'UpdatedRecently').
'</span> ';
469 if ($product[
"cover_photo_url"] !=
'' && $product[
"cover_photo_url"] !=
'#') {
470 $images =
'<a href="'.$product[
"cover_photo_url"].
'" class="documentpreview" target="_blank" rel="noopener noreferrer" mime="image/png" title="'.
dol_escape_htmltag($product[
"label"].
', '.$langs->trans(
'Version').
' '.$product[
"module_version"]).
'">';
471 $images .=
'<img class="imgstore" src="'.$product[
"cover_photo_url"].
'" alt="" /></a>';
473 $images =
'<img class="imgstore" src="'.DOL_URL_ROOT.
'/public/theme/common/nophoto.png" />';
479 if ($product[
"status"] ==
'soon' || $product[
"status"] ==
'development' || $product[
"status"] ==
'experimental') {
480 $version =
'<span class="warning">'.$langs->trans(
"NotYetAvailable").
' - '.$langs->trans(
"StillInDevelopment").
'</span>';
481 $compatible =
'NotCompatible';
484 $minknown = (!empty($product[
"dolibarr_min"]) && !in_array($product[
"dolibarr_min"], array(
'auto',
'unknown')));
485 $maxknown = (!empty($product[
"dolibarr_max"]) && !in_array($product[
"dolibarr_max"], array(
'auto',
'unknown')));
487 if ($minknown && $this->
versionCompare($product[
"dolibarr_min"], $dolibarrversiontouse) > 0) {
489 $version =
'<span class="compatibleafterupdate">'.$langs->trans(
490 'CompatibleAfterUpdate',
491 $dolibarrversiontouse,
492 $product[
"dolibarr_min"],
493 $product[
"dolibarr_max"]
495 $compatible =
'NotCompatible';
496 } elseif ($maxknown && $this->
versionCompare($product[
"dolibarr_max"], $dolibarrversiontouse) >= 0) {
498 $version =
'<span class="compatible hideonsmartphone">'.$langs->trans(
500 $dolibarrversiontouse,
501 $product[
"dolibarr_min"],
502 $product[
"dolibarr_max"]
507 $version =
'<span class="warning">'.$langs->trans(
509 $dolibarrversiontouse,
510 $product[
"dolibarr_min"],
511 $product[
"dolibarr_max"]
513 $compatible =
'NotCompatible';
519 if (array_key_exists(
'price_ht', $product) &&
price2num($product[
"price_ht"]) > 0) {
520 $price =
'<h3>'.price(
price2num($product[
"price_ht"],
'MT'), 0, $langs, 1, -1, -1,
'EUR').
' '.$langs->trans(
"HT").
'</h3>';
522 $download_link =
'<a class="paddingleft paddingright valignmiddle" target="_blank" title="'.$langs->trans(
"View").
'" href="'.$this->shop_url.
'/product.php?id='.((int) $product[
'id']).
'">';
523 $download_link .=
img_picto(
'',
'url',
'class="size2x paddingright"');
524 $download_link .=
'</a>';
526 $download_link =
'#';
527 if ($product[
'source'] ===
'dolistore') {
528 $urlview = $this->shop_url.
'/product.php?id='.((int) $product[
"id"]);
529 $price =
'<h3><a href="'.$urlview.
'" target="_blank">'.$langs->trans(
'SeeOnDoliStore').
'</a></h3>';
530 } elseif ($product[
'source'] ===
'githubcommunity') {
531 if (array_key_exists(
'price_ht', $product) && empty($product[
'price_ht'])) {
532 if ($product[
'status'] ==
'soon') {
533 $price =
'<h3>'.$langs->trans(
'StillInDevelopment').
'</h3>';
535 $price =
'<h3>'.$langs->trans(
'Free').
'</h3>';
538 if ($product[
"dolistore-download"]) {
539 $price =
'<h3><a href="'.$product[
"dolistore-download"].
'" target="_blank">'.$langs->trans(
'SeeOnDoliStore').
'</a></h3>';
541 $price =
'<h3>'.$langs->trans(
'Unknown').
'</h3>';
545 $price =
'<h3>'.$langs->trans(
'Unknown').
'</h3>';
548 if ($product[
'source'] ===
'githubcommunity') {
549 $download_link =
'<a class="paddingleft paddingright valignmiddle" target="_blank" title="'.$langs->trans(
"Sources").
'" href="'.$product[
"link"].
'">';
550 $download_link .=
img_picto(
'',
'file-code',
'class="size2x paddingright colorgrey"');
551 $download_link .=
'</a>';
553 $urlview = $product[
"dolistore-download"];
555 $download_link .=
'<a class="paddingleft paddingright valignmiddle" target="_blank" title="'.$langs->trans(
"View").
'" href="'.$urlview.
'" rel="noopener noreferrer">';
556 $download_link .=
img_picto(
'',
'url',
'class="size2x"');
557 $download_link .=
'</a>';
560 if (!empty($product[
'direct-download']) && $product[
'direct-download'] ==
'yes') {
562 if (preg_match(
'/https:.*\?id=(\d+)$/', $urlview, $reg)) {
563 $urldownload =
'https://www.dolistore.com/_service_download.php?t=free&p='.$reg[1];
564 $download_link .=
'<a class="paddingleft paddingright valignmiddle" target="_blank" title="'.$langs->trans(
"Download").
'" href="'.$urldownload.
'" rel="noopener noreferrer">';
565 $download_link .=
img_picto(
'',
'download',
'class="size2x paddingright"');
567 $download_link .=
'</a>';
570 } elseif ($product[
'source'] ===
'dolistore') {
571 $urlview = $this->shop_url.
'/product.php?id='.((int) $product[
"id"]);
572 $urldownload =
'https://www.dolistore.com/_service_download.php?t=free&p=' . $product[
'id'];
573 $download_link =
'<a class="paddingleft paddingright valignmiddle" target="_blank" title="'.$langs->trans(
"View").
'" href="'.$urlview.
'">';
574 $download_link .=
img_picto(
'',
'url',
'class="size2x"');
575 $download_link .=
'</a>';
576 $download_link .=
'<a class="paddingleft paddingright valignmiddle" target="_blank" title="'.$langs->trans(
"Download").
'" href="'.$urldownload.
'" rel="noopener noreferrer">';
577 $download_link .=
img_picto(
'',
'download',
'class="size2x paddingright"');
579 $download_link .=
'</a>';
583 if ((!empty($product[
'direct-download']) && in_array($product[
'direct-download'], array(
'yes',
'dolistore'))) || $product[
'source'] ===
'dolistore') {
586 if ($product[
'source'] ===
'githubcommunity') {
587 $current_version = $product[
'module_version'] ??
'';
588 $module_name = strtolower(preg_replace(
'/@.*$/',
'', $product[
'ref'] ??
''));
591 $module_name = preg_replace(
'/-' . preg_quote($current_version,
'/') .
'$/',
'', $module_name);
593 $urldownload =
'https://github.com/Dolibarr/dolibarr-community-modules/raw/refs/heads/main/dev/build/bin/module_' . $module_name .
'-' . $current_version .
'.zip';
596 $urlview = $product[
"dolistore-download"];
600 if (($product[
"direct-download"] ??
'') ==
'dolistore' ||
getDolGlobalString(
"MAIN_DOWNLOAD_FROM_DOLISTORE_IN_PRIORITY")) {
601 if (preg_match(
'/https:.*\?id=(\d+)$/', $urlview, $reg)) {
602 $urldownload =
'https://www.dolistore.com/_service_download.php?t=free&p='.$reg[1];
606 if ($product[
'source'] ===
'dolistore') {
607 $urldownload =
'https://www.dolistore.com/_service_download.php?t=free&p=' . $product[
'id'];
611 $disableInstall = ($compatible ===
'NotCompatible') && !
getDolGlobalInt(
'MAIN_FEATURES_LEVEL');
614 $fields = [
'action' =>
'install',
'token' =>
newToken()];
615 foreach ($product as $key => $value) {
616 $fields[
'producttoinstall['.$key.
']'] = $value;
619 $installConfirmMessage = $langs->transnoentities(
620 "extModuleConfirmInstallText",
621 $product[
'label'] ??
'',
622 $product[
'module_version'] ??
'',
623 $product[
'ref'] ??
'',
624 !empty($product[
'tms']) ?
dol_print_date($product[
'tms'],
'%d/%m/%Y') :
''
626 $installConfirmMessage .= $langs->trans(
"Path").
' : '.$urldownload;
629 $buttonLabel = $langs->trans(
"Install");
630 $remoteVersion = $product[
'module_version'] ??
'';
631 $remoteModuleName = strtolower(preg_replace(
'/@.*$/',
'', $product[
'ref'] ??
''));
633 $remoteModuleName = preg_replace(
'/-' . preg_quote($remoteVersion,
'/') .
'$/',
'', $remoteModuleName);
634 if (!empty($installedModules[$remoteModuleName]) && $remoteVersion && $remoteVersion !=
'unknown') {
635 $localVersion = $installedModules[$remoteModuleName];
637 if ($localVersion !=
'unknown') {
638 $versionDiff = $this->
versionCompare($localVersion, $remoteVersion);
639 if ($versionDiff < 0) {
640 $buttonLabel = $langs->trans(
"Upgrade");
641 } elseif ($versionDiff == 0) {
642 $buttonLabel = $langs->trans(
"ReInstall");
647 $install_link =
'<button class="valignmiddle ' . ($disableInstall ?
'butActionRefused' :
'butAction') .
' paddingleft paddingright"'
649 . (!$disableInstall ?
' data-confirm' :
'')
650 . (!$disableInstall ?
' data-fields="' .
dol_escape_htmltag(json_encode($fields)) .
'"' :
'')
652 . (!$disableInstall ?
' data-confirm-title="' .
dol_escape_htmltag($langs->trans(
"extModuleConfirmInstallTitle")) .
'"' :
'')
653 . (!$disableInstall ?
' data-confirm-text="' .
dol_escape_htmltag($installConfirmMessage) .
'"' :
'')
654 . (!$disableInstall ?
' data-confirm-label="' .
dol_escape_htmltag($buttonLabel) .
'"' :
'')
655 .
'>' . $buttonLabel .
'</button>';
660 $html .=
'<tr class="'.(getDolOptimizeSmallScreen() ?
'app' :
'app app2').
' oddeven nohover '.
dol_escape_htmltag($compatible).
'">';
663 $html .=
'<td class="center width150"><div class="newAppParent">';
664 $html .= $newapp.$images;
665 $html .=
'</div></td>';
668 $html .=
'<td class="margeCote minwidth400imp"><h2 class="appTitle">';
670 if (!empty($product[
'author']) && $product[
'author'] !=
'unkownauthor') {
671 $html .=
'<span class="small"> - '.img_picto(
'',
'company',
'class="pictofixedwidth"');
672 if (!empty($product[
'author_url'])) {
673 $html .=
'<a href="'.$product[
'author_url'].
'" target="_blank">'.$product[
'author'].
'</a>';
675 $html .= $product[
'author'];
679 $html .=
'<br><span class="small">';
684 $html .=
'<small class="appDateCreation appRef"> ';
685 if (empty($product[
'tms'])) {
686 $html .=
img_picto($langs->trans(
'DateCreation'),
'calendar',
'class="pictofixedwidth"').
'<span class="opacitymedium"><span class="hideonsmartphone">'.$langs->trans(
"DateCreation").
': </span>';
689 $html .=
img_picto($langs->trans(
'DateModification'),
'calendar',
'class="pictofixedwidth"').
'<span class="opacitymedium">'.
dol_print_date(
dol_stringtotime($product[
'tms']),
'day').
'</span>';
691 $html .=
' ';
693 $html .=
'<div class="appSource inline-block valigntop">';
694 if ($product[
"source"] ==
'dolistore') {
695 $html .=
'<img border="0" title="'.dolPrintHTML($langs->trans(
'Source').
": DoliStore").
'" class="imgautosize valignmiddle inline-block pictofixedwidth" style="height: 14px" src="'.DOL_URL_ROOT.
'/theme/dolistore_squarred.svg">';
696 } elseif ($product[
"source"] ==
'githubcommunity') {
697 $html .=
img_picto($langs->trans(
'Source').
': GitHub community repo',
'group',
'class="pictofixedwidth valignmiddle"');
699 $html .=
img_picto($langs->trans(
'Source').
': '.$langs->trans(
'Other'),
'generic',
'class="pictofixedwidth"');
703 $html .= $langs->trans(
'Ref').
' '.
dolPrintHTML(preg_replace(
'/@.*$/',
'', $product[
"ref"]));
704 $html .=
'</small><br>';
708 if (!empty($product[
'phpmin']) && $product[
'phpmin'] !=
'unknown') {
709 $html .=
' <span class="badge-secondary small" style="padding: 3px; border-radius: 5px">PHP min '.$product[
'phpmin'].
'</span>';
711 if (!empty($product[
'phpmax']) && $product[
'phpmax'] !=
'unknown') {
712 $html .=
' <span class="badge-secondary small" style="padding: 3px; border-radius: 5px">PHP max '.$product[
'phpmax'].
'</span>';
717 $html .=
'<div class="storedesc">'.dolPrintHTML(
dol_string_nohtmltag($product[
"description"])).
'</div>';
721 $html .=
'</tr><tr class="app2 oddeven nohover borderbottom '.dol_escape_htmltag($compatible).
'">';
725 $html .=
'<td class="margeCote center amount'.(getDolOptimizeSmallScreen() ?
' left" colspan="2"' :
'"').
'>';
727 if ((!empty($product[
'direct-download']) && in_array($product[
'direct-download'], array(
'yes',
'dolistore'))) || ($product[
'source'] ===
'dolistore' && empty((
float) $product[
'price_ht']))) {
729 $html .= $install_link;
735 $html .=
'<td class="margeCote nowraponall">';
739 $html .= $download_link;
745 if (empty($this->products)) {
747 $langs->load(
"website");
749 $html .=
'<tr class=""><td colspan="'.$colspan.
'" class="center">';
751 $html .= $langs->trans(
"noResultsWereFound").
'...';
753 $html .=
'</td></tr>';
757 $confirmLabel = $langs->trans(
"Install");
758 $cancelLabel = $langs->trans(
"Cancel");
760 $(document).on("click","[data-confirm]",function(){
761 var button = $(this);
762 var confirmTitle = button.data("confirm-title");
763 var confirmText = button.data("confirm-text");
765 buttons[button.data("confirm-label")||\'' .
dol_escape_js($confirmLabel) .
'\'] =
function(){
766 var form = $(
"<form method=\'POST\' style=\'display:none\'>").attr(
"action",
button.data(
"url"));
767 $.each(
button.data(
"fields"),
function(
name, value){
768 form.append($(
"<input type=\'hidden\'>").attr(
"name", name).val(value));
770 $(
"body").append(form);
772 $(
this).dialog(
"close");
774 buttons[\
'' .
dol_escape_js($cancelLabel) .
'\'] =
function(){$(
this).dialog(
"close");};
775 $(
"<div>").html(confirmText).dialog({
784 $this->numberOfProducts = count($this->products);
795 public function buildSorter(string $key): Closure
803 function (array $a, array $b) use ($key) {
804 $valA = isset($a[$key]) && is_scalar($a[$key]) ? (string) $a[$key] : '
';
805 $valB = isset($b[$key]) && is_scalar($b[$key]) ? (string) $b[$key] : '';
807 return strnatcmp($valA, $valB);
818 public function versionCompare($v1, $v2)
821 $v1 = str_replace(array('v
', 'V
'), '', $v1);
822 $v2 = str_replace(array('v
', 'V
'), '', $v2);
824 $v1 = explode('.
', $v1);
825 $v2 = explode('.
', $v2);
828 $count1 = count($v1);
829 $count2 = count($v2);
830 $maxcount = max($count1, $count2);
831 while ($level < $maxcount) {
832 $operande1 = isset($v1[$level]) ? $v1[$level] : 'x
';
833 $operande2 = isset($v2[$level]) ? $v2[$level] : 'x
';
835 if (strtoupper($operande1) == 'X
' || strtoupper($operande2) == 'X
' || $operande1 == '*
' || $operande2 == '*
') {
838 if ($operande1 < $operande2) {
842 if ($operande1 > $operande2) {
847 //print join('.
',$versionarray1).'(
'.count($versionarray1).') /
'.join('.
',$versionarray2).'(
'.count($versionarray2).') =>
'.$ret.'<br>
'."\n";
851 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
858 public function get_previous_link($text = '<<
')
861 return '<a href=
"'.$this->get_previous_url().'" class=
"button">
'.dol_escape_htmltag($text).'</a>
';
864 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
871 public function get_next_link($text = '>>
')
874 return '<a href=
"'.$this->get_next_url().'" class=
"button">
'.dol_escape_htmltag($text).'</a>
';
877 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
883 public function get_previous_url()
886 $param_array = array();
887 if ($this->no_page > 1) {
892 if (!empty($this->search)) {
893 $param_array['search_keyword
'] = $this->search;
895 $param_array['no_page
'] = $this->no_page - $sub;
896 if ($this->categorie != 0) {
897 $param_array['categorie
'] = $this->categorie;
899 $param = http_build_query($param_array);
900 return $this->url."&".$param;
903 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
909 public function get_next_url()
912 $param_array = array();
913 if ($this->products !== null && count($this->products) < $this->per_page) {
918 if (!empty($this->search)) {
919 $param_array['search_keyword
'] = $this->search;
921 $param_array['no_page
'] = $this->no_page + $add;
922 if ($this->categorie != 0) {
923 $param_array['categorie
'] = $this->categorie;
925 $param = http_build_query($param_array);
926 return $this->url."&".$param;
934 public function getPagination()
939 $page = $this->no_page;
940 $limit = $this->per_page;
941 $totalnboflines = $this->numberTotalOfProducts ?: 0;
942 $num = $this->numberOfProducts;
946 // Show navigation bar
948 if ($page > 0 || $num > $limit) {
949 if ($totalnboflines) {
951 $nbpages = $this->numberTotalOfPages;
956 // Show previous page
958 $pagelist .= '<li
class=
"pagination paginationpage paginationpageleft"><a
class=
"paginationprevious reposition" href=
"'.$this->get_previous_url().'"><i
class=
"fa fa-chevron-left" title=
"'.dol_escape_htmltag($langs->trans("Previous
")).'"></i></a></li>
';
961 $pagelist .= '<li
class=
"pagination">
';
962 $pagelist .= '<label
for=
"page_input">Page </label>
';
963 if ($this->categorie != 0) {
964 $pagelist .= '<input
type=
"hidden" name=
"categorie" value=
"' . $this->categorie . '">
';
966 // URL to go to another page (without no_page). Used when pressing Enter into the page input field.
967 $param_array = array();
968 if (!empty($this->search)) {
969 $param_array['search_keyword
'] = $this->search;
971 if ($this->categorie != 0) {
972 $param_array['categorie
'] = $this->categorie;
974 $urlforpage = $this->url.($param_array ? '&
'.http_build_query($param_array) : '');
975 $pagelist .= '<input
type=
"text" id=
"page_input" name=
"no_page" value=
"'.($page).'" min=
"1" max=
"'.$nbpages.'" class=
"width40 page_input right" data-url=
"'.dol_escape_htmltag($urlforpage).'"';
976 $pagelist .= ' oninput=
"if(this.value > '.$nbpages.') this.value='.$nbpages.'"';
977 $pagelist .= ' onkeydown=
"if (event.key === \'Enter\') { event.preventDefault(); var p = parseInt(this.value, 10); if (isNaN(p) || p < 1) { p = 1; } window.location.href = this.dataset.url + \'&no_page=\' + p; }">
';
978 $pagelist .= ' /
'.$nbpages;
979 $pagelist .= '</li>
';
982 if ($page < $nbpages) {
983 $pagelist .= '<li
class=
"pagination paginationpage paginationpageright"><a
class=
"paginationnext reposition" href=
"'.$this->get_next_url().'"><i
class=
"fa fa-chevron-right" title=
"'.dol_escape_htmltag($langs->trans("Next
")).'"></i></a></li>
';
988 if ($limit || $pagelist) {
989 $html .= '<div
class=
"pagination" style=
"padding: 7px;">
';
996 $html .= ajax_autoselect('.page_input
');
1007 protected function checkStatusCode($request)
1009 // Define error messages
1011 204 => 'No content
',
1012 400 => 'Bad Request
',
1013 401 => 'Unauthorized
',
1015 405 => 'Method Not Allowed
',
1016 500 => 'Internal Server Error
',
1019 // If status code is 200 or 201, return an empty string
1020 if ($request['status_code
'] === 200 || $request['status_code
'] === 201) {
1024 // Get the predefined error message or use a default one
1025 $error_message = $error_messages[$request['status_code
']] ?? 'Unexpected HTTP
status:
' . $request['status_code
'];
1027 // Append error details if available
1028 if (!empty($request['response
']) && isset($request['response
']['errors
']) && is_array($request['response
']['errors
'])) {
1029 foreach ($request['response
']['errors
'] as $error) {
1030 $error_message .= ' - (Code
' . $error['code
'] . '):
' . $error['message
'];
1034 if (!empty($request['curl_error_msg
'])) {
1035 $error_message .= ' -
' . $request['curl_error_msg
'];
1038 // Return the formatted error message
1039 return sprintf('This call to the API failed and returned an HTTP
status of %d. That means: %s.
', $request['status_code
'], $error_message);
1049 public function getRemoteYamlFile($file_source_url, $cache_time)
1052 $cache_file = $this->cache_file;
1053 $cache_folder = dirname($cache_file);
1055 // Check if cache directory exists
1056 if (!dol_is_dir($cache_folder)) {
1057 dol_mkdir($cache_folder, DOL_DATA_ROOT);
1060 if (!file_exists($cache_file) || filemtime($cache_file) < (dol_now() - $cache_time)) {
1061 // We get remote url
1062 $addheaders = array();
1063 $result = getURLContent($file_source_url, 'GET
', '', 1, $addheaders); // TODO Force timeout to 5 s on both connect and response.
1064 if (!empty($result) && $result['http_code
'] == 200) {
1065 $yaml = $result['content
'];
1066 $result = file_put_contents($cache_file, $yaml);
1067 if ($result === false) {
1068 $this->error = 'Failed to create cache file:
' . $cache_file;
1070 dolChmod($cache_file);
1074 $yaml = file_get_contents($cache_file);
1087 public function readYaml($yaml)
1090 $currentPackage = null;
1091 $currentSection = null;
1093 foreach (explode("\n", trim($yaml)) as $line) {
1094 $trimmedLine = trim($line);
1096 // Ignore empty lines and comments
1097 if ($trimmedLine === '
' || strpos($trimmedLine, '#
') === 0) {
1101 // Match a new package entry (e.g., "- modulename: 'helloasso
'") - Found a break in file.
1103 if (preg_match('/^\s*-\s*modulename:\s*[
"\']?(.*?)["\
']?$/', $trimmedLine, $matches)) {
1104 if ($currentPackage !==
null) {
1106 if (!empty($currentPackage[
'status']) && in_array($currentPackage[
'status'], array(
'enabled',
'soon'))) {
1107 $data[] = $currentPackage;
1110 $currentPackage = [
'modulename' => $matches[1]];
1111 $currentSection =
null;
1116 if (!preg_match(
'/^\s*(fr|en|es|it|de):\s*["\']?(.*?)["\']?$/', $trimmedLine)) {
1117 $currentSection =
null;
1121 if (preg_match(
'/^(\w[\w-]*):\s*["\']?(.*?)["\']?$/', $trimmedLine, $matches)) {
1122 if ($currentPackage !==
null) {
1123 if ($currentSection) {
1125 $currentPackage[$currentSection][$matches[1]] = $matches[2] ===
'' ? null : $matches[2];
1128 $currentPackage[$matches[1]] = $matches[2] ===
'' ? null : $matches[2];
1133 if (preg_match(
'/^\s*(label|description):\s*$/', $trimmedLine, $matches)) {
1134 $currentSection = $matches[1];
1135 $currentPackage[$currentSection] = [];
1143 if ($currentPackage !==
null) {
1144 if (!empty($currentPackage[
'status']) && in_array($currentPackage[
'status'], array(
'enabled',
'soon'))) {
1145 $data[] = $currentPackage;
1163 if (!is_array($data) || empty($data) || empty($source)) {
1164 return $adaptedData;
1167 if ($source ===
'githubcommunity') {
1168 foreach ($data as $package) {
1169 if (empty($package[
'modulename'])) {
1176 if (!empty($package[
'dolistore-download']) && preg_match(
'/www\.dolistore\.com\/product\.php\?id=(\d+)/', (
string) $package[
'dolistore-download'], $reg)) {
1182 'ref' => str_replace(
' ',
'', $package[
'modulename'] .
'-' . $package[
'current_version'] .
'@' .
1183 (array_key_exists(
'author', $package) ? $package[
'author'] :
'unkownauthor')),
1184 'label' => !empty($package[
'label'][substr($this->lang, 0, 2)])
1185 ? $package[
'label'][substr($this->lang, 0, 2)]
1186 : (!empty($package[
'label'][
'en']) ? $package[
'label'][
'en'] : $package[
'modulename']),
1187 'description' => !empty($package[
'description'][substr($this->lang, 0, 2)])
1188 ? $package[
'description'][substr($this->lang, 0, 2)]
1189 : (!empty($package[
'description'][
'en']) ? $package[
'description'][
'en'] :
''),
1190 'datec' => (!empty($package[
'created_at']) && is_string($package[
'created_at']))
1191 ?
date(
'Y-m-d H:i:s', strtotime($package[
'created_at']))
1193 'tms' => (!empty($package[
'last_updated_at']) && is_string($package[
'last_updated_at']))
1194 ?
date(
'Y-m-d H:i:s', strtotime($package[
'last_updated_at']))
1196 'author' => array_key_exists(
'author', $package) ? $package[
'author'] :
'',
1197 'author_url' => array_key_exists(
'author_url', $package) ? $package[
'author_url'] :
'',
1198 'dolibarr_min' => !empty($package[
'dolibarrmin'])
1199 ? $package[
'dolibarrmin']
1201 'dolibarr_max' => !empty($package[
'dolibarrmax'])
1202 ? $package[
'dolibarrmax']
1204 'phpmin' => !empty($package[
'phpmin'])
1205 ? $package[
'phpmin']
1207 'phpmax' => !empty($package[
'phpmax'])
1208 ? $package[
'phpmax']
1210 'module_version' => !empty($package[
'current_version'])
1211 ? $package[
'current_version']
1213 'cover_photo_url' => !empty($package[
'cover'])
1216 'category' => (!empty($package[
'category']) && is_string($package[
'category']))
1217 ? explode(
',', str_replace(
' ',
'', (
string) $package[
'category']))
1219 'link' => !empty($package[
'git'])
1222 'source' =>
'githubcommunity',
1223 'status' => !empty($package[
'status']) ? $package[
'status'] :
'',
1224 'direct-download' => !empty($package[
'direct-download'])
1225 ? $package[
'direct-download']
1227 'dolistore-download' => !empty($package[
'dolistore-download'])
1228 ? $package[
'dolistore-download']
1233 if (array_key_exists(
'price', $package) && $package[
'price'] !=
null) {
1234 $adaptedPackage[
'price_ht'] = $package[
'price'];
1237 $adaptedData[] = $adaptedPackage;
1241 if ($source ===
'dolistore') {
1242 foreach ($data as $package) {
1243 $urlphoto = $this->shop_url.$package[
'cover_photo_url'];
1245 if (preg_match(
'/^\/?wrapper\.php\?hashp=/', $package[
'cover_photo_url']) && !preg_match(
'/attachment=/', $package[
'cover_photo_url'])) {
1246 $urlphoto .=
'&attachment=0';
1250 'id' => $package[
'id'],
1251 'ref' => $package[
'ref'],
1252 'label' => $package[
'label'],
1253 'description' => $package[
'description'],
1254 'datec' => $package[
'datec'],
1255 'tms' => $package[
'tms'],
1256 'author' => array_key_exists(
'author', $package) ? $package[
'author'] :
'',
1257 'author_url' => array_key_exists(
'author_url', $package) ? $package[
'author_url'] :
'',
1258 'price_ttc' => $package[
'price_ttc'],
1259 'price_ht' => $package[
'price_ht'],
1260 'dolibarr_min' => $package[
'dolibarr_min'],
1261 'dolibarr_max' => $package[
'dolibarr_max'],
1262 'phpmin' => empty($package[
'phpmin']) ?
'' : $package[
'phpmin'],
1263 'phpmax' => empty($package[
'phpmax']) ?
'' : $package[
'phpmax'],
1264 'module_version' => $package[
'module_version'],
1265 'cover_photo_url' => $urlphoto,
1266 'source' =>
'dolistore',
1267 'status' => empty($package[
'status']) ?
'' : $package[
'status'],
1268 'direct-download' =>
'',
1271 $adaptedData[$package[
'id']] = $adaptedPackage;
1275 return $adaptedData;
1287 $filteredData = $list;
1299 static function ($a, $b) {
1300 return strtotime($b[
'datec'] ??
'0') - strtotime($a[
'datec'] ??
'0');
1304 if (!empty($options[
'search'])) {
1305 $filteredData = array_filter(
1314 static function ($package) use ($options) {
1315 return stripos($package[
'label'], $options[
'search']) !==
false || stripos($package[
'description'], $options[
'search']) !==
false;
1320 if (!empty($options[
'categorieid'])) {
1321 $filteredData = array_filter(
1330 static function ($package) use ($options) {
1331 return in_array($options[
'categorieid'], $package[
'category']);
1336 $total = count($filteredData);
1339 $filteredData = array_values($filteredData);
1340 $filteredData = array_slice($filteredData, ($options[
'page'] - 1) * $options[
'limit'], $options[
'limit']);
1342 return [
'total' => $total,
'data' => $filteredData];
1353 $testRequest = $this->callApi(
'categories');
1355 if (!isset($testRequest[
'response']) || !is_array($testRequest[
'response']) || ($testRequest[
'status_code'] != 200 && $testRequest[
'status_code'] != 201)) {
1356 $this->dolistoreApiError = $this->checkStatusCode($testRequest);
1371 public function libStatus($status, $mode = 3, $moretext =
'')
1375 $statusType =
'status4';
1377 $statusType =
'status3';
1381 $labelStatusShort = [];
1383 $labelStatus[0] = $langs->transnoentitiesnoconv(
"NotConnected");
1384 $labelStatus[1] = $langs->transnoentitiesnoconv(
"online");
1385 $labelStatusShort[0] = $langs->transnoentitiesnoconv(
"NotConnected");
1386 $labelStatusShort[1] = $langs->transnoentitiesnoconv(
"online");
1388 return dolGetStatus($labelStatus[$status], $labelStatusShort[$status],
'', $statusType, $mode,
'', array(
'badgeParams' => array(
'attr' => array(
'class' =>
'classfortooltip',
'title' => $labelStatusShort[$status].$moretext))));
1403 if (!function_exists(
'curl_init')) {
1404 dol_syslog(__METHOD__ .
': cURL is not available', LOG_ERR);
1409 if (empty($producttoinstall[
'ref'])) {
1410 dol_syslog(__METHOD__ .
': Missing producttoinstall', LOG_ERR);
1414 $current_version = $producttoinstall[
'module_version'] ??
'';
1415 $module_name = strtolower(preg_replace(
'/@.*$/',
'', $producttoinstall[
'ref'] ??
''));
1418 $module_name = preg_replace(
'/-' . preg_quote($current_version,
'/') .
'$/',
'', $module_name);
1420 if (empty($module_name) || empty($current_version) || $current_version ==
'unknown') {
1421 dol_syslog(__METHOD__ .
': Missing or unknown module name/version for product', LOG_ERR);
1426 $tmpdir =
$conf->admin->dir_temp .
'/remotestoredl';
1429 $downloaded =
false;
1430 switch ($producttoinstall[
'source']) {
1432 if ($producttoinstall[
'id'] > 0) {
1433 $source_url =
'https://www.dolistore.com/_service_download.php?t=free&p=' . $producttoinstall[
'id'];
1434 $downloaded = $this->_downloadFile($source_url, $tmpdir);
1436 dol_syslog(__METHOD__ .
': Dolistore download failed: ' . $source_url, LOG_ERR);
1440 dol_syslog(__METHOD__ .
': Invalid product ID for Dolistore download: ' . $producttoinstall[
'id'], LOG_ERR);
1444 case 'githubcommunity':
1445 if (!empty($producttoinstall[
'direct-download']) && in_array($producttoinstall[
'direct-download'], array(
'yes',
'dolistore'))) {
1446 $source_url =
'https://github.com/Dolibarr/dolibarr-community-modules/raw/refs/heads/main/dev/build/bin/module_' . $module_name .
'-' . $current_version .
'.zip';
1447 $downloaded = $this->_downloadFile($source_url, $tmpdir);
1449 dol_syslog(__METHOD__ .
': GitHub community module download failed: ' . $source_url .
', Try to find a Dolistore link', LOG_WARNING);
1450 if ($producttoinstall[
'id'] > 0) {
1451 $source_url =
'https://www.dolistore.com/_service_download.php?t=free&p=' . $producttoinstall[
'id'];
1452 $downloaded = $this->_downloadFile($source_url, $tmpdir);
1454 dol_syslog(__METHOD__ .
': Dolistore download failed: ' . $source_url, LOG_ERR);
1458 dol_syslog(__METHOD__ .
': No direct download available for this GitHub community module', LOG_ERR);
1463 dol_syslog(__METHOD__ .
': No direct download available for this GitHub community module', LOG_ERR);
1468 dol_syslog(__METHOD__ .
': Unsupported source type: ' . $producttoinstall[
'source'], LOG_ERR);
1472 dol_syslog(__METHOD__ .
': Module downloaded successfully to: ' . $downloaded, LOG_DEBUG);
1490 if (!empty($head[
'header'])) {
1491 if (preg_match_all(
'/Content-Disposition:.*filename=["\']?([^"\';\r\n]+)/i', $head[
'header'], $m)) {
1492 $filename = trim(end($m[1]),
" \t\"'");
1497 if (empty($filename)) {
1498 $filename = basename(parse_url($url, PHP_URL_PATH));
1502 if (empty($filename) || !preg_match(
'/^module_[a-z0-9_]+-[0-9]+\.[0-9]+\.[0-9]+\.zip$/i', $filename)) {
1503 dol_syslog(__METHOD__ .
': Cannot determine filename from URL: ' . $url, LOG_ERR);
1509 if (empty($response[
'content']) || (isset($response[
'http_code']) && $response[
'http_code'] !== 200)) {
1511 __METHOD__ .
': Download failed — HTTP ' . ($response[
'http_code'] ??
'unknown') .
' — ' . $url,
1518 $dest_file = $dest_path .
'/' . $filename;
1523 $writtenfile = file_put_contents(
dol_osencode($dest_file), $response[
'content']);
1524 if ($writtenfile ===
false || $writtenfile === 0) {
1525 dol_syslog(__METHOD__ .
': Cannot write file: ' . $dest_file, LOG_ERR);
1530 dol_syslog(__METHOD__ .
': Downloaded successfully to: ' . $dest_file, LOG_DEBUG);
$id
Support class for third parties, contacts, members, users or resources.
__construct($debug=false)
Constructor.
libStatus($status, $mode=3, $moretext='')
Retrieve the status icon.
checkApiStatus()
Check if an Dolistore API is up.
getProducts($options, $modules=array())
Generate HTML for products.
versionCompare($v1, $v2)
version compare
getRemoteYamlFile($file_source_url, $cache_time)
Get YAML file from remote source and put it into the cache file.
buildSorter(string $key)
Sort an array by a key.
getModuleZIP($producttoinstall=array())
Download a Dolibarr module from a Git repository URL or Dolistore download URL.
getCategories($active=0)
Generate HTML for categories and their children.
applyFilters($list, $options)
Apply filters to the data.
fetchModulesFromFile($options=array())
Fetch modules from a cache YAML file.
_downloadFile(string $url, string $dest_path)
Download a remote URL to a local file using getURLContent (native Dolibarr).
readYaml($yaml)
Read a YAML string and convert it to an array.
callApi($resource, $options=false)
Test if we can access to remote Dolistore market place.
adaptData($data, $source)
Adapter data fetched from github remote source to the expected format.
loadRemoteSources($debug=false)
loadRemoteSources
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
dol_stringtotime($string, $gm=1)
Convert a string date into a GM Timestamps date Warning: YYYY-MM-DDTHH:MM:SS+02:00 (RFC3339) is not s...
dol_is_file($pathoffile)
Return if path is a file.
dol_now($mode='gmt')
Return date for now.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
dolPrintHTML($s, $allowiframe=0, $moreallowedtags=array())
Return a string (that can be on several lines) ready to be output on a HTML page.
dol_osencode($str)
Return a string encoded into OS filesystem encoding.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
getDolOptimizeSmallScreen()
Return if render must be optimized for small screen.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_escape_js($stringtoescape, $mode=0, $noescapebackslashn=0)
Returns text escaped for inclusion into JavaScript code.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
getURLContent($url, $postorget='GET', $param='', $followlocation=1, $addheaders=array(), $allowedschemes=array('http', 'https'), $localurl=0, $ssl_verifypeer=-1, $timeoutconnect=0, $timeoutresponse=0, $otherCurlOptions=array(), $morelogsuffix='')
Function to get a content from an URL (use proxy if proxy defined).
multi select button
0 = Do not include form tag and submit button -1 = Do not include form tag but include submit button
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
$conf db name
Only used if Module[ID]Name translation string is not found.