(276,42,'donation-list','','donation-list','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\nif (!isModEnabled(\'don\') || !getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') || !getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')) {\n    redirectToContainer(\'index\');\n}\n\n\n$data = array();\n\n$sql = \"SELECT d.rowid, d.datedon as datec, s.nom as societe, d.firstname, d.lastname, p.title, d.amount\";\n$sql .= \" FROM \".MAIN_DB_PREFIX.\"don as d LEFT JOIN \".MAIN_DB_PREFIX.\"projet AS p\";\n$sql .= \" ON p.rowid = d.fk_projet\";\n$sql .= \" LEFT JOIN \" . MAIN_DB_PREFIX . \"societe AS s ON s.rowid = d.fk_soc\";\n$sql .= \" WHERE d.entity IN (\". getEntity(\'donation\') . \")\";\n$sql .= \" AND d.fk_statut IN (2)\";\n$sql .= \" AND d.paid = 1\";\n$sql .= \" AND d.public = 1\";\n$sql .= \" AND p.public = 1\";\n$sql .= $db->order(\"datedon\", \"DESC\");\n    \n$resql = $db->query($sql);\nif ($resql) {\n    while ($obj = $db->fetch_object($resql)) {\n        $data[] = array(\n			\'firstname\' => $obj->firstname,\n			\'lastname\' => $obj->lastname,\n			\'societe\' => $obj->societe,\n			\'datec\' => $obj->datec,\n			\'project\' => $obj->title,\n			\'amount\' => $obj->amount,\n		);\n    }\n}\n/*print \"<pre>\";\nprint_r ($data);\nprint \"</pre>\";*/\ndefine(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"listOfPublicDonations\")); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 0;\">\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n\n		\n\n<div class=\"col-md-8\">\n    <div class=\"section-title\">\n      <div class=\"line left-line\"></div>\n      <h1><?php print $weblangs->trans(\"listOfPublicDonations\"); ?></h1>\n      <div class=\"line right-line\"></div>\n    </div>\n            \n    <table id=\"membersTable\" class=\"table table-striped\">\n        <thead>\n            <tr>\n                <th>#</th>\n                <th><?php echo $weblangs->trans(\"Firstname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Lastname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Company\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Date\"); ?></th>\n                \n                <th><?php echo $weblangs->trans(\"project\"); ?></th>\n                <th><?php echo $weblangs->trans(\"amount\"); ?></th>\n            </tr>\n        </thead>\n        <tbody>\n            <?php if (!empty($data) && is_array($data)): ?>\n                <?php foreach ($data as $index => $row): ?>\n                    <tr>\n                        <td><?php echo (int)($index + 1); ?></td>\n                        <td><?php echo !empty($row[\'firstname\']) ? htmlspecialchars($row[\'firstname\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>\n                        <td><?php echo !empty($row[\'lastname\']) ? htmlspecialchars($row[\'lastname\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>\n                        <td><?php echo !empty($row[\'societe\']) ? htmlspecialchars($row[\'societe\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>\n                        <td><?php echo dol_print_date($row[\'datec\'], \'daytext\', \'tzuser\', $weblangs); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'project\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo price(price2num($row[\'amount\'], \'MT\'), 1, \'\', 1, -1); ?> €</td>\n                    </tr>\n                <?php endforeach; ?>\n            <?php endif; ?>\n        </tbody>\n    </table>\n    <script>\n        $(document).ready(function() {\n            $(\'#membersTable\').DataTable({\n                language: {\n                    url: \"https://cdn.datatables.net/plug-ins/1.13.6/i18n/<?php print str_replace(\'_\', \'-\', $_SESSION[\'lang\'][\'code\']); ?>.json\"\n                }\n            });\n        });\n    </script>\n</div>\n\n\n\n	    <?php includeContainer(\'sidebar\'); ?>\n		\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',0,'2025-04-29 17:00:33',NULL,'2025-05-07 08:33:20',NULL,NULL,'page','',NULL,'','<!-- DataTables CSS/JS -->\n<link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\">\n<script src=\"https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js\"></script>',NULL,'','',0,NULL,NULL),
(277,42,'events','','events','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$showDonationLink = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {\n    $showDonationLink = 1;\n}\n\n$showEventGoalRaised = 0;\nif (isModEnabled(\'don\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {\n    $showEventGoalRaised = 1;\n}\n\n$showParticipateLink = 0;\nif (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {\n    $showParticipateLink = 1;\n}\n?>\n<div class=\"container-fluid causes\">\n    <div class=\"container\">\n        <div class=\"section-title\" id=\"section-events\" style=\"scroll-margin-top: 100px;\">\n          <div class=\"line left-line\"></div>\n          <h1><?php echo $weblangs->trans(\"actionsEvents\"); ?></h1>\n          <div class=\"line right-line\"></div>\n        </div>\n        <div class=\"row g-4\">\n\n            <?php \n            $maxevents = GETPOSTINT(\'maxevents\') ? GETPOSTINT(\'maxevents\') : 3;\n            $countofevents = 0;\n            $sqlCount = \"SELECT count(p.rowid) as countofevents \n                    FROM \".MAIN_DB_PREFIX.\"projet as p \n                    WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                    ORDER BY p.datec DESC \";\n            $resqlCount = $db->query($sqlCount);\n            if ($resqlCount) {\n                $objCount = $db->fetch_object($resqlCount);\n                $countofevents = $objCount->countofevents ? $objCount->countofevents : 0;\n            }\n        \n            $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n                    FROM \".MAIN_DB_PREFIX.\"projet as p \n                    WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                    ORDER BY p.datec DESC \n                    LIMIT \".$maxevents;\n            $resql = $db->query($sql);\n            if ($resql) {\n                $countofblogs = $db->num_rows($resql);\n                $i=1;\n                while ($obj = $db->fetch_object($resql)) {\n                    ?>\n                    <div class=\"col-lg-6 col-xl-4 event-item\" id=\"event-<?php echo $i; ?>\">\n                        <div class=\"causes-item\">\n                            <div class=\"causes-img\">\n                                <?php\n                                    $urlforimage = getImageFromHtmlContent($obj->description ? $obj->description : \"\");\n                                    if (empty($urlforimage)) {\n                                        $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                                    }\n                                ?>\n                                <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                                <div class=\"causes-link pb-2 px-3\">\n                                    <?php\n                                        $progress = 100;\n                                        if ($obj->budget_amount > 0 && $showEventGoalRaised) {\n                                            $sqlCollected = \"SELECT SUM(amount) as total_collected \n                                                             FROM \".MAIN_DB_PREFIX.\"don \n                                                             WHERE fk_projet = \".$obj->rowid;\n                                            $resqlCollected = $db->query($sqlCollected);\n                                            $collected = 0;\n                                            if ($resqlCollected) {\n                                                $objCollected = $db->fetch_object($resqlCollected);\n                                                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n                                            }\n                                            $progress = round(($collected / $obj->budget_amount) * 100, 2);\n                                        }\n                                    ?>\n                                    <?php if ($showEventGoalRaised) { ?>\n                                        <small class=\"text-white\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($obj->budget_amount, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                        <small class=\"text-white\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($collected, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                    <?php } ?>    \n                                </div>\n                                <div class=\"causes-dination p-2\">\n                                    <?php if ($showDonationLink) { ?>\n                                        <?php if (getDolGlobalInt(\'WS_\' . strtoupper($website->ref) . \'_PAYMENT_IN_FRAME\')) { ?>\n                                            <a href=\"page.php?donation=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                        <?php } else { ?>\n                                            <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                        <?php } ?>\n                                    <?php } ?>\n                                    \n                                    <?php if ($showParticipateLink) { ?>\n                                        <?php $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\'); ?>\n                                        <a href=\"<?php echo $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"Participate\"); ?></a>\n                                    <?php } ?>\n                                </div>\n                            </div>\n                            \n                            \n                            <div class=\"progress\">\n                              <div class=\"progress-bar\" role=\"progressbar\" style=\"width: <?php echo $progress; ?>%;\" aria-valuenow=\"<?php echo $progress; ?>\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                                <?php if ($showEventGoalRaised) { ?>\n                                <span><?php echo $progress; ?>%</span>\n                                <?php } ?>\n                              </div>\n                            </div>\n\n                            \n                            <div class=\"causes-content p-4\">\n                                <span class=\"text-body\">\n                                    <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($obj->datec, \'daytext\', \'tzuser\', $weblangs); ?>\n                                </span>\n                                <h4 class=\"py-3\"><?php echo $obj->title; ?></h4>\n\n                                <a href=\"page.php?id=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                            </div>\n                        </div>\n                    </div>\n                    <?php\n                    $i++;\n                }\n            }\n            ?>\n        </div>\n        \n        <?php if ($maxevents <= $countofevents) { ?>\n            <div class=\"row\">\n                <div class=\"col-lg-7 text-center py-5 section-title\">\n                    <div class=\"line left-line left-gradient\"></div>\n                    <a href=\"javascript:void(0);\" class=\"btn flat-button text-white bgmaincolor\" id=\"loadMoreEventsBtn\"><?php echo $weblangs->trans(\"loadMore\"); ?> (<?php echo $maxevents; ?>/<?php echo $countofevents; ?>)</a>\n                    <div class=\"line right-line right-gradient\"></div>\n                </div>\n            </div>\n        <?php } ?>\n        <script>\n            document.getElementById(\'loadMoreEventsBtn\').addEventListener(\'click\', function() {\n            const currentUrl = new URL(window.location.href);\n            const maxEventsParam = <?php echo $maxevents; ?>;\n            const newMaxEvents = parseInt(maxEventsParam) + 3;\n            currentUrl.searchParams.set(\'maxevents\', newMaxEvents);\n            currentUrl.hash = \'#event-\' + (parseInt(maxEventsParam) + 1).toString();\n            window.location.href = currentUrl.toString();\n            });\n        </script>\n    </div>\n</div>',0,'2025-04-14 14:16:40',NULL,'2025-05-06 16:10:57',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(278,42,'footer','','footer','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid\" style=\"margin:0; padding:0;\">\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"<?php print getDolGlobalString(\'WS_\' . strtoupper($website->ref) . \'_MAIN_COLOR\') ?: \'#5d5b6a\'; ?>\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n</div>\n<div class=\"container-fluid footer text-body\">\n    \n    <div class=\"container py-5\">\n        <div class=\"row g-5\">\n            \n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"presentation\"); ?></h4>\n                    <a href=\"/index#section-overview\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"missionVision\"); ?></a>\n                    <a href=\"rgpd.php\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"rgpd\"); ?></a>\n                </div>\n            </div>\n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"newsEvents\"); ?></h4>\n                    <a href=\"index#section-news\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"news\"); ?></a>\n                    <?php if (isModEnabled(\'eventorganization\') && !getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')): ?>\n                        <a href=\"index#section-events\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"actionsEvents\"); ?></a>\n                    <?php endif; ?>\n                </div>\n            </div>\n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"volunteer\"); ?></h4>\n                        <?php if (isModEnabled(\'webportal\') && getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')): ?>\n                          <?php\n                          if (getDolGlobalString(\'WEBPORTAL_ROOT_URL\')) {\n                            $url = getDolGlobalString(\'WEBPORTAL_ROOT_URL\');\n                          } else {\n                            if (isModEnabled(\'multicompany\')) {\n                              $entity_qr = \'?entity=\' . ((int) $conf->entity);\n                            } else {\n                              $entity_qr = \'\';\n                            }\n            \n                            $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));\n                            $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;\n                            $url = $urlwithroot . \'/public/webportal/index.php\' . $entity_qr;\n                          }\n                          ?>\n                          <a href=\"<?php echo $url; ?>\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"memberArea\"); ?></a>\n                        <?php endif; ?>\n                        \n                    <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')): ?>\n                        <a href=\"members-list.php\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"directory\"); ?></a>\n                    <?php endif; ?>\n                    \n                    <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                        <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"becomeMember\"); ?></a>\n                    <?php endif; ?>\n                    \n                    <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\')): ?>\n                        <a href=\"<?php print $socInfo[\'link_donation\']; ?>\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"makeDonation\"); ?></a>\n                    <?php endif; ?>\n                </div>\n            </div>\n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"socials\"); ?></h4>\n                    <div class=\"social\">\n                        <?php\n                            $socialIcons = [\n                              \'facebook\' => \'fa-facebook-f\',\n                              \'twitter\' => \'fa-x-twitter\',\n                              \'linkedin\' => \'fa-linkedin-in\',\n                              \'instagram\' => \'fa-instagram\',\n                              \'youtube\' => \'fa-youtube\',\n                              \'skype\' => \'fa-skype\',\n                              \'whatsapp\' => \'fa-whatsapp\',\n                              \'snapchat\' => \'fa-snapchat-ghost\',\n                            ];\n                \n                            foreach ($socialIcons as $key => $icon) {\n                              if (!empty($socInfo[$key])) {\n                                echo \'<a href=\"\' . htmlspecialchars($socInfo[$key]) . \'\" target=\"_blank\" class=\"btn-hover-color btn-square text-white me-2\"><i class=\"fa-brands \' . $icon . \'\"></i></a>\';\n                              }\n                            }\n                        ?>\n                    </div>\n                </div>\n            </div>\n            <!--<div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\">RGPD</h4>\n                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Politique de Confidentialité</a>\n                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Gestion des Données</a>\n                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Droits des Utilisateurs</a>\n\n                </div>\n            </div>-->\n        </div>\n    </div>\n</div>',0,'2025-04-08 14:37:00',NULL,'2025-05-15 13:24:35',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(279,42,'highlights','','highlights','','','<div class=\"col-lg-3 stats section\" id=\"stats\">\n                \n    <div class=\"section-title\">\n      <div class=\"line left-line\"></div>\n      <h1><?php echo $weblangs->trans(\"highlights\"); ?></h1>\n      <div class=\"line right-line\"></div>\n    </div>\n\n    <div class=\"container aos-init aos-animate\" data-aos=\"fade-up\" data-aos-delay=\"100\">\n\n        <div class=\"row gy-4\">\n            \n            <!--<div class=\"col-lg-12 counter-box\">\n                <i class=\"fas fa-users fa-4x text-white\"></i>\n                <div class=\"stats-item\">\n                  <span data-purecounter-start=\"0\" data-purecounter-end=\"232\" data-purecounter-duration=\"0\" class=\"purecounter\">000</span>\n                  <p><?php echo $weblangs->trans(\"volunteer\"); ?></p>\n                </div>\n            </div><!-- End Stats Item -->\n            \n            <?php if (isModEnabled(\'member\')): ?>\n                <div class=\"col-lg-12 counter-box\">\n                    <i class=\"fas fa-user-friends fa-4x text-white\"></i>\n                    <div class=\"stats-item\">\n                      <?php\n                      $sql = \"SELECT COUNT(rowid) as total_members FROM llx_adherent WHERE statut = 1 AND public = 1\";\n                      $resql = $db->query($sql);\n                      $total_members = 0;\n                      if ($resql) {\n                        $obj = $db->fetch_object($resql);\n                        if ($obj) {\n                          $total_members = $obj->total_members;\n                        }\n                      }\n                      ?>\n                      <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_members; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php echo $total_members; ?></span>\n                      <p><?php echo $weblangs->trans(\"member\"); ?></p>\n                    </div>\n                </div><!-- End Stats Item -->\n            <?php endif; ?>\n            \n            <?php if (isModEnabled(\'eventorganization\')): ?>\n            <div class=\"col-lg-12 counter-box\">\n              <i class=\"fas fa-hands-helping fa-4x text-white\"></i>\n              <div class=\"stats-item\">\n              <?php\n                $sql = \"SELECT COUNT(rowid) as total_events FROM \".MAIN_DB_PREFIX.\"projet as p WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1)\";\n              $resql = $db->query($sql);\n              $total_events = 0;\n              if ($resql) {\n                $obj = $db->fetch_object($resql);\n                if ($obj) {\n                $total_events = $obj->total_events;\n                }\n              }\n              ?>\n              <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_events; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php echo $total_events; ?></span>\n              <p><?php echo $weblangs->trans(\"actions\"); ?></p>\n              </div>\n            </div><!-- End Stats Item -->\n            <?php endif; ?>\n\n            <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') && getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>\n                <div class=\"col-lg-12 counter-box\">\n                    <i class=\"fas fa-hands-helping fa-4x text-white\"></i>\n                    <div class=\"stats-item\">\n                      <?php\n                        $sql = \"SELECT count(amount) as count_funds FROM llx_don WHERE paid = 1\";\n                        $resql = $db->query($sql);\n                        $count_funds = 0;\n                        if ($resql) {\n                        $obj = $db->fetch_object($resql);\n                        if ($obj) {\n                          $count_funds = $obj->count_funds;\n                        }\n                        }\n                        ?>\n                        <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $count_funds; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php print $count_funds; ?></span>\n                        <p><?php echo $weblangs->trans(\"Donation\"); ?></p>\n                    </div>\n                </div><!-- End Stats Item -->\n            <?php endif; ?>\n            \n            <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') && getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>\n                <div class=\"col-lg-12 counter-box\">\n                    <i class=\"fas fa-file-invoice-dollar fa-4x text-white\"></i>\n                    <div class=\"stats-item\">\n                      <?php\n                        $sql = \"SELECT SUM(amount) as total_funds FROM llx_don WHERE paid = 1\";\n                        $resql = $db->query($sql);\n                        $total_funds = 0;\n                        if ($resql) {\n                        $obj = $db->fetch_object($resql);\n                        if ($obj) {\n                          $total_funds = $obj->total_funds;\n                        }\n                        }\n                        ?>\n                        <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_funds; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php print intval($total_funds); ?> €</span>\n                        <p><?php echo $weblangs->trans(\"fundsCollected\"); ?></p>\n                    </div>\n                </div><!-- End Stats Item -->\n            <?php endif; ?>\n\n        </div>\n    \n      </div>\n</div>',0,'2025-04-14 10:49:38',NULL,'2025-05-06 16:23:42',NULL,NULL,'banner','en',NULL,'','',NULL,'','',0,NULL,NULL),
(280,42,'index','','Index','','','<?php includeContainer(\'navbar\'); ?>\n\n<?php includeContainer(\'slider\'); ?>\n\n<?php \nif ($_SESSION[\'lang\'][\'shortcode\'] != \"en\" && array_key_exists($_SESSION[\'lang\'][\'shortcode\'], getAvailableLangs()[\'langs\'])) {\n    includeContainer(\'overview-\'.$_SESSION[\'lang\'][\'shortcode\']);\n} else {\n    includeContainer(\'overview\');\n}\n?>\n\n<?php includeContainer(\'news\'); ?>\n\n<?php\nif (!getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\') && isModEnabled(\'eventorganization\')) {\n    includeContainer(\'events\'); \n}\n?>\n\n<?php includeContainer(\'contact\'); ?>\n\n<?php includeContainer(\'footer\'); ?>',0,'2025-03-21 15:58:56',NULL,'2025-05-07 12:57:29',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(281,42,'members-list','','members-list','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\nif (!getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')) {\n    redirectToContainer(\'index\');\n}\n\n$data = array();\n$sql = \"SELECT rowid, firstname, lastname, societe, zip, town, email, birth, photo, datec\";\n\n$sqlfields = $sql;\n\n$sql .= \" FROM \".MAIN_DB_PREFIX.\"adherent\";\n$sql .= \" WHERE entity = 1\";\n$sql .= \" AND statut = 1\";\n$sql .= \" AND public = 1\";\n$sql .= $db->order(\"datec\", \"DESC\");\n    \n$resql = $db->query($sql);\nif ($resql) {\n    while ($obj = $db->fetch_object($resql)) {\n        $data[] = array(\n			\'firstname\' => $obj->firstname,\n			\'lastname\' => $obj->lastname,\n			\'societe\' => $obj->societe,\n			\'datec\' => $obj->datec,\n		);\n    }\n}\n/*print \"<pre>\";\nprint_r ($data);\nprint \"</pre>\";*/\ndefine(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"ListOfValidatedPublicMembers\")); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 0;\">\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n\n		\n\n<div class=\"col-md-8\">\n    <div class=\"section-title\">\n      <div class=\"line left-line\"></div>\n      <h1><?php print $weblangs->trans(\"ListOfValidatedPublicMembers\"); ?></h1>\n      <div class=\"line right-line\"></div>\n    </div>\n            \n    <table id=\"membersTable\" class=\"table table-striped\">\n        <thead>\n            <tr>\n                <th>#</th>\n                <th><?php echo $weblangs->trans(\"Firstname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Lastname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Company\"); ?></th>\n                <th><?php echo $weblangs->trans(\"DateSubscription\"); ?></th>\n            </tr>\n        </thead>\n        <tbody>\n            <?php if (!empty($data) && is_array($data)): ?>\n                <?php foreach ($data as $index => $row): ?>\n                    <tr>\n                        <td><?php echo (int)($index + 1); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'firstname\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'lastname\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'societe\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo dol_print_date($row[\'datec\'], \'daytext\', \'tzuser\', $weblangs); ?></td>\n                    </tr>\n                <?php endforeach; ?>\n            <?php endif; ?>\n        </tbody>\n    </table>\n    <script>\n        $(document).ready(function() {\n            $(\'#membersTable\').DataTable({\n                language: {\n                    url: \"https://cdn.datatables.net/plug-ins/1.13.6/i18n/<?php print str_replace(\'_\', \'-\', $_SESSION[\'lang\'][\'code\']); ?>.json\"\n                }\n            });\n        });\n    </script>\n</div>\n\n\n\n	    <?php includeContainer(\'sidebar\'); ?>\n		\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',0,'2025-04-29 15:02:20',NULL,'2025-05-07 08:33:57',NULL,NULL,'page','',NULL,'','<!-- DataTables CSS/JS -->\n<link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\">\n<script src=\"https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js\"></script>',NULL,'','',0,NULL,NULL),
(282,42,'navbar','','navbar','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n// Get available langs for the website\n$website_langs = getAvailableLangs();\n$available_langs = $website_langs[\'langs\'];\nif (getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\')) {\n    $used_langs = explode(\',\', getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\'));\n    foreach ($available_langs as $key => $value) {\n        if (!in_array($key, $used_langs)) {\n            unset($available_langs[$key]);\n        }\n    }\n}\n\n$langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];\n\n//$weblangs->load(\"website\", \"languages\");\n//$langs->load(\"website\", \"languages\");\n?>\n<div class=\"site-mobile-menu site-navbar-target\">\n  <div class=\"site-mobile-menu-header\">\n    <div class=\"site-mobile-menu-close mt-3\">\n      <span class=\"icon-close2 js-menu-toggle\"></span>\n    </div>\n  </div>\n  <div class=\"site-mobile-menu-body\"></div>\n</div>\n\n<header class=\"site-navbar js-sticky-header js-sticky-header-blog site-navbar-target\" role=\"banner\">\n\n  <div class=\"container\">\n    <div class=\"row align-items-center\">\n      \n      <div class=\"col-6 col-xl-2\">\n        <?php\n            if(getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'USE_TEXT_LOGO\')) {\n                $html_logo = $mysoc->name . \'<span class=\"text-secondary-color\">.</span>\';\n            } else {\n                $path = getImageFileNameForSize($mysoc->logo_squarred ? $mysoc->logo_squarred : $mysoc->logo, \'_small\');\n                $html_logo = \'<img class=\"logo img-responsive-logo img-responsive\" alt=\"\" height=\"42\" src=\"\' . DOL_URL_ROOT . \'/viewimage.php?modulepart=mycompany&file=\'.urlencode(\'logos/\'.$path).\'\">\'; \n            }\n          \n            \n        ?>\n        <h1 class=\"mb-0 site-logo\"><a href=\"/index\"><?php print $html_logo; ?> </a></h1>\n      </div>\n\n      <div class=\"col-12 col-md-10 d-none d-xl-block\">\n        <nav class=\"site-navigation position-relative text-right\" role=\"navigation\">\n\n        <ul class=\"site-menu main-menu js-clone-nav mr-auto d-none d-lg-block\" style=\"float: right;\">\n            <li class=\"has-children\">\n                <a class=\"nav-link\"><?php echo $weblangs->trans(\"presentation\"); ?></a>\n                <ul class=\"dropdown\">\n                    <li><a href=\"/index#section-overview\" class=\"nav-link\"><?php echo $weblangs->trans(\"missionVision\"); ?></a></li>\n                    <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')): ?>\n                        <li><a href=\"members-list.php\" class=\"nav-link\"><?php echo $weblangs->trans(\"directory\"); ?></a></li>\n                    <?php endif; ?>\n                </ul>\n            </li>\n            <li class=\"has-children\">\n                <a class=\"nav-link\"><?php echo $weblangs->trans(\"newsEvents\"); ?></a>\n                <ul class=\"dropdown\">\n                    <li><a href=\"index#section-news\" class=\"nav-link\"><?php echo $weblangs->trans(\"news\"); ?></a></li>\n                    <?php if (isModEnabled(\'eventorganization\') && !getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')): ?>\n                        <li><a href=\"index#section-events\" class=\"nav-link\"><?php echo $weblangs->trans(\"actionsEvents\"); ?></a></li>\n                    <?php endif; ?>\n                </ul>\n            </li>\n            <li class=\"has-children\">\n                <a class=\"nav-link\"><?php echo $weblangs->trans(\"commitmentSupport\"); ?></a>\n                <ul class=\"dropdown\">\n                    <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                        <li><a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"nav-link\"><?php echo $weblangs->trans(\"becomeMember\"); ?></a></li>\n                    <?php endif; ?>\n                    \n                    <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\')): ?>\n                        <li><a href=\"<?php print $socInfo[\'link_donation\']; ?>\" target=\"new\" class=\"nav-link\"><?php echo $weblangs->trans(\"makeDonation\"); ?></a></li>\n                        <?php if (getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>\n                            <li><a href=\"donation-list.php\" class=\"nav-link\"><?php echo $weblangs->trans(\"listOfPublicDonations\"); ?></a></li>\n                        <?php endif; ?>\n                    <?php endif; ?>\n                </ul>\n            </li>\n            <li>\n                <a href=\"index#section-contact\" class=\"nav-link\"><?php echo $weblangs->trans(\"contact\"); ?></a>\n            </li>\n            \n            <?php if (isModEnabled(\'webportal\') && getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')): ?>\n              <?php\n              if (getDolGlobalString(\'WEBPORTAL_ROOT_URL\')) {\n                $url = getDolGlobalString(\'WEBPORTAL_ROOT_URL\');\n              } else {\n                if (isModEnabled(\'multicompany\')) {\n                  $entity_qr = \'?entity=\' . ((int) $conf->entity);\n                } else {\n                  $entity_qr = \'\';\n                }\n\n                $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));\n                $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;\n                $url = $urlwithroot . \'/public/webportal/index.php\' . $entity_qr;\n              }\n              ?>\n              <li>\n                <a href=\"<?php echo $url; ?>\" target=\"new\" class=\"nav-link\"><i class=\"fa-solid fa-user\"></i> <?php echo $weblangs->trans(\"memberArea\"); ?></a>\n              </li>\n            <?php endif; ?>\n            \n            <?php\n                $socialIcons = [\n                  \'facebook\' => \'fa-facebook-f\',\n                  \'twitter\' => \'fa-x-twitter\',\n                  \'linkedin\' => \'fa-linkedin-in\',\n                  \'instagram\' => \'fa-instagram\',\n                  \'youtube\' => \'fa-youtube\',\n                  \'skype\' => \'fa-skype\',\n                  \'whatsapp\' => \'fa-whatsapp\',\n                  \'snapchat\' => \'fa-snapchat-ghost\',\n                ];\n    \n                foreach ($socialIcons as $key => $icon) {\n                  if (!empty($socInfo[$key])) {\n                    echo \'<li class=\"social\"><a href=\"\' . htmlspecialchars($socInfo[$key]) . \'\" target=\"_blank\" class=\"nav-link\"><i class=\"fa-brands \' . $icon . \'\"></i></a></li>\';\n                  }\n                }\n            ?>\n            \n            <li class=\"has-children\">\n                <a href=\"#language-section\" class=\"nav-link\"><?php print trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$_SESSION[\'lang\'][\'shortcode\']]))[0]); ?></a>\n                <!--<a href=\"#language-section\" class=\"nav-link\"><?php print $_SESSION[\'lang\'][\'shortcode\']; ?></a>-->\n                <ul class=\"dropdown lang-menu\">\n                    <?php if (count($available_langs) > 1): ?>\n                        <?php foreach ($available_langs as $key => $value) : ?>\n                            <?php $value = trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$key]))[0]); ?>\n                            <?php if ($key != $_SESSION[\'lang\'][\'shortcode\']): ?>\n                        		<li>\n                                  <form id=\"languageForm-<?php print $key; ?>\" method=\"post\" action=\"#\">\n                                    <input type=\"hidden\" name=\"l\" value=\"<?php print $key; ?>\">\n                                    <a href=\"#\" class=\"nav-link\" title=\"<?php print $langs->trans(\"Language_\".$langs_code_shortcode[$key]); ?>\" onclick=\"\n                                           const form = document.getElementById(\'languageForm-<?php print $key; ?>\');\n                                           const parser = document.createElement(\'a\');\n                                           parser.href = form.action || window.location.href;\n                                           const params = new URLSearchParams(parser.search);\n                                           params.delete(\'l\');\n                                           parser.search = params.toString();\n                                           form.action = parser.href;\n                                           form.submit();\n                                           return false;\n                                       \">    \n                                      <?php print $value ; ?>\n                                    </a>\n                                  </form>\n                                </li>\n                        	<?php endif ?>\n                        <?php endforeach ?>\n                    <?php endif ?>\n                </ul>\n            </li>\n            \n        </ul>\n        </nav>\n      </div>\n\n\n      <div class=\"col-6 d-inline-block d-xl-none ml-md-0 py-3\" style=\"position: relative; top: 3px;\">\n        <a href=\"#\" class=\"site-menu-toggle js-menu-toggle float-right\">\n            <i class=\"fas fa-bars\"></i>\n        </a>\n      </div>\n\n    </div>\n  </div>\n  \n</header>',0,'2025-04-08 14:20:56',NULL,'2025-05-15 13:06:32',NULL,NULL,'menu','',NULL,'','',NULL,'','',0,NULL,NULL),
(283,42,'news','','news','','','<div class=\"container-fluid causes\">\n    <div class=\"container py-5\">\n        <div class=\"section-title\" id=\"section-news\" style=\"scroll-margin-top: 100px;\">\n          <div class=\"line left-line\"></div>\n          <h1><?php echo $weblangs->trans(\"news\"); ?></h1>\n          <div class=\"line right-line\"></div>\n        </div>\n        <div class=\"row g-4\">\n        <?php \n        $MAXNEWS = GETPOSTINT(\'maxnews\') ? GETPOSTINT(\'maxnews\') : 3;\n        $allblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 0, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n        $countofblogs = count($allblogs);\n        $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', $MAXNEWS, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n        $i=1;\n        foreach($arrayofblogs as $blog)\n        {\n        ?>\n            <div class=\"col-lg-6 col-xl-4 blog-item\" id=\"blog-<?php echo $i; ?>\">\n                <div class=\"causes-item\">\n                    <div class=\"causes-img\">\n                        <?php\n                            $urlforimage = getImageFromHtmlContent($blog->content);\n                            if (empty($urlforimage)) {\n                                $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                            }\n                        ?>\n                        <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                    </div>\n                    <div class=\"progress progress-news\">\n                      <div class=\"progress-bar\" role=\"progressbar\" style=\"width: 100%;\" aria-valuenow=\"100\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                      </div>\n                    </div>\n                    <div class=\"causes-content p-4\">\n                        <span class=\"text-body\">\n                            <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($blog->date_creation, \'daytext\', \'tzuser\', $weblangs); ?>\n                            <span class=\"author-span\"><i class=\"fas fa-user me-2\"></i> <?php echo ($blog->author_alias ? $blog->author_alias : \'anonymous\'); ?></span>\n                        </span>\n                        <h4 class=\"py-3\"><?php echo $blog->title; ?></h4>\n                        <hr>\n                        <p class=\"mb-4 truncate3\"><?php echo $blog->description; ?></p>\n                        <a href=\"page.php?ref=<?php print $blog->pageurl; ?>&blog=<?php print $blog->id; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                    </div>\n                </div>\n            </div>\n            <?php \n            $i++;\n        }\n        ?>\n        </div>\n        \n        <?php if ($MAXNEWS <= $countofblogs) { ?>\n            <div class=\"row\">\n                <div class=\"col-lg-7 text-center py-5 section-title\">\n                    <div class=\"line left-line left-gradient\"></div>\n                    <a href=\"javascript:void(0);\" class=\"btn flat-button text-white bgmaincolor\" id=\"loadMoreNewsBtn\"><?php echo $weblangs->trans(\"loadMore\"); ?>...</a>\n                    <div class=\"line right-line right-gradient\"></div>\n                </div>\n            </div>\n        <?php } ?>\n        <script>\n            document.getElementById(\'loadMoreNewsBtn\').addEventListener(\'click\', function() {\n            const currentUrl = new URL(window.location.href);\n            const maxNewsParam = <?php echo $MAXNEWS; ?>;\n            const newMaxNews = parseInt(maxNewsParam) + 3;\n            currentUrl.searchParams.set(\'maxnews\', newMaxNews);\n            currentUrl.hash = \'#blog-\' + (parseInt(maxNewsParam) + 1).toString();\n            window.location.href = currentUrl.toString();\n            });\n        </script>\n            \n            \n    </div>\n</div>',0,'2025-04-14 14:16:15',NULL,'2025-05-15 16:03:52',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(284,42,'our-company-is-now-on-dolibarr-erp-crm','','Our company is now on Dolibarr ERP CRM','Like several thousands of companies, our company (DMNA) has moved all its information system to Dolibarr ERP CRM. More than 20 applications have been replaced by only one.','','<article>\n    <div id=\"article\" contenteditable=\"true\">\n        Like several thousands of companies, our company (<?php echo $mysoc->name ?>) has moved all its information system to <a href=\"https://www.dolibarr.org\">Dolibarr ERP CRM</a>. More than 20 applications have been replaced by only one, easier to use and fully integrated.\n        This is an important step in improving all of our services.\n        \n        <br><br><br>\n        \n        <figure>\n        <img src=\"/viewimage.php?modulepart=medias&file=image/exemple/background_dolibarr.webp\">\n        <br><br>\n        <figcaption style=\"opacity: 0.5; text-align: center;\">Screenshot of our new Open Source solution</figcaption>\n        </figure>\n    </div>\n</article>',1,'2025-04-14 15:39:29',NULL,'2025-05-07 08:24:39',NULL,NULL,'blogpost','',NULL,'','',NULL,'','',0,NULL,NULL),
(285,42,'our-new-web-site-has-been-launched','','Our new web site has been launched','Now it is modern and directly integrated with the internal management tools of the company. Many new online services will be available for our customers','','<article>\n    <div id=\"article\" contenteditable=\"true\">\n            Our new website, based on Dolibarr CMS, has been launched. <br>\n            Now it is modern and directly integrated with the internal management tools of the company. Many new online services will be available for our customers...\n            <br><br>\n            <figure>\n            <img src=\"/viewimage.php?modulepart=medias&file=image/test5/5.jpg\">\n            <br><br>\n            <figcaption style=\"opacity: 0.5; text-align: center;\">Theme of our new web site</figcaption>\n            </figure>\n    </div>\n</article>',1,'2025-04-08 14:18:29',NULL,'2025-05-07 08:25:04',NULL,NULL,'blogpost','',NULL,'','',NULL,'','',0,NULL,NULL),
(286,42,'overview','','overview','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid volunteer\">\n    <div class=\"container py-5\">\n\n        <div class=\"row g-5\">\n            \n            <div class=\"col-lg-9\">\n\n              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">\n                <div class=\"line left-line\"></div>\n                <h1>Mission & Vision</h1>\n                <div class=\"line right-line\"></div>\n              </div>\n            \n              <p class=\"mb-4\">\n                Our association is committed to making a positive impact by supporting initiatives that contribute to collective well-being and a sustainable future. We emphasize collaboration and shared values to move forward together toward common goals.\n              </p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Foster cooperation and solidarity among members.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Encourage responsible and sustainable practices.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Support projects that have a positive impact on society.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Promote inclusion and equal opportunities.</p>\n              <p class=\"text-dark mb-5\"><i class=\"fa fa-check secondary-color me-2\"></i> Raise awareness about social, environmental, or cultural issues.</p>\n              \n                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>\n                <?php endif; ?>\n            </div>\n\n            \n            <?php includeContainer(\'highlights\'); ?>\n        </div>\n    </div>\n</div>',0,'2025-04-08 14:30:11',NULL,'2025-05-06 14:35:02',NULL,NULL,'banner','en',NULL,'','',NULL,'','',0,NULL,NULL),
(287,42,'overview-de','','overview-de','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid volunteer\">\n    <div class=\"container py-5\">\n\n        <div class=\"row g-5\">\n            \n            <div class=\"col-lg-9\">\n\n              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">\n                <div class=\"line left-line\"></div>\n                <h1>Mission & Vision</h1>\n                <div class=\"line right-line\"></div>\n              </div>\n            \n              <p class=\"mb-4\">\n                Unser Verein setzt sich dafür ein, einen positiven Beitrag zu leisten, indem er Initiativen unterstützt, die zum gemeinsamen Wohl und zu einer nachhaltigen Zukunft beitragen. Wir legen Wert auf Zusammenarbeit und gemeinsame Werte, um gemeinsam auf gemeinsame Ziele hinzuarbeiten.\n              </p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Förderung von Zusammenarbeit und Solidarität unter den Mitgliedern.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Ermutigung zu verantwortungsbewusstem und nachhaltigem Handeln.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Unterstützung von Projekten mit positivem Einfluss auf die Gesellschaft.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Förderung von Inklusion und Chancengleichheit.</p>\n              <p class=\"text-dark mb-5\"><i class=\"fa fa-check secondary-color me-2\"></i> Sensibilisierung für soziale, ökologische und kulturelle Themen.</p>\n            \n              <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\">Tritt uns bei</a>\n                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>\n                <?php endif; ?>\n            </div>\n\n\n            \n            <?php includeContainer(\'highlights\'); ?>\n        </div>\n    </div>\n</div>',0,'2025-04-14 13:27:14',NULL,'2025-05-06 14:35:29',NULL,NULL,'page','de',286,'','',NULL,'','',0,NULL,NULL),
(288,42,'overview-es','','overview-es','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid volunteer\">\n    <div class=\"container py-5\">\n\n        <div class=\"row g-5\">\n            \n            <div class=\"col-lg-9\">\n\n              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">\n                <div class=\"line left-line\"></div>\n                <h1>Misión y Visión</h1>\n                <div class=\"line right-line\"></div>\n              </div>\n            \n              <p class=\"mb-4\">\n                Nuestra asociación está comprometida con generar un impacto positivo apoyando iniciativas que contribuyan al bienestar colectivo y a un futuro sostenible. Damos prioridad a la colaboración y a los valores compartidos para avanzar juntos hacia objetivos comunes.\n              </p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Fomentar la cooperación y la solidaridad entre los miembros.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Promover prácticas responsables y sostenibles.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Apoyar proyectos que generen un impacto positivo en la sociedad.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Promover la inclusión y la igualdad de oportunidades.</p>\n              <p class=\"text-dark mb-5\"><i class=\"fa fa-check secondary-color me-2\"></i> Concienciar sobre cuestiones sociales, medioambientales y culturales.</p>\n            \n                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>\n                <?php endif; ?>\n            </div>\n\n\n\n            \n            <?php includeContainer(\'highlights\'); ?>\n        </div>\n    </div>\n</div>',0,'2025-04-14 13:30:19',NULL,'2025-05-06 14:36:01',NULL,NULL,'page','es',286,'','',NULL,'','',0,NULL,NULL),
(289,42,'overview-fr','','overview-fr','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid volunteer\">\n    <div class=\"container py-5\">\n\n        <div class=\"row g-5\">\n            \n            <div class=\"col-lg-9\">\n\n              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">\n                <div class=\"line left-line\"></div>\n                <h1>Mission & Vision</h1>\n                <div class=\"line right-line\"></div>\n              </div>\n            \n              <p class=\"mb-4\">\n                Notre association s\'engage à avoir un impact positif en soutenant des initiatives qui contribuent au bien-être collectif et à un avenir durable. Nous mettons l\'accent sur la collaboration et les valeurs partagées pour avancer ensemble vers des objectifs communs.\n              </p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Favoriser la coopération et la solidarité entre les membres.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Encourager des pratiques responsables et durables.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Soutenir des projets ayant un impact positif sur la société.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Promouvoir l\'inclusion et l\'égalité des chances.</p>\n              <p class=\"text-dark mb-5\"><i class=\"fa fa-check secondary-color me-2\"></i> Sensibiliser aux enjeux sociaux, environnementaux ou culturels.</p>\n            \n                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>\n                <?php endif; ?>\n            </div>\n\n            \n            <?php includeContainer(\'highlights\'); ?>\n        </div>\n    </div>\n</div>',0,'2025-04-14 13:06:31',NULL,'2025-05-06 14:36:27',NULL,NULL,'page','fr',286,'','',NULL,'','',0,NULL,NULL),
(290,42,'overview-it','','overview-it','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid volunteer\">\n    <div class=\"container py-5\">\n\n        <div class=\"row g-5\">\n            \n            <div class=\"col-lg-9\">\n\n              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">\n                <div class=\"line left-line\"></div>\n                <h1>Missione e Visione</h1>\n                <div class=\"line right-line\"></div>\n              </div>\n            \n              <p class=\"mb-4\">\n                La nostra associazione si impegna a generare un impatto positivo sostenendo iniziative che contribuiscano al benessere collettivo e a un futuro sostenibile. Diamo importanza alla collaborazione e ai valori condivisi per avanzare insieme verso obiettivi comuni.\n              </p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Promuovere la cooperazione e la solidarietà tra i membri.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Incentivare pratiche responsabili e sostenibili.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Sostenere progetti con un impatto positivo sulla società.</p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> Promuovere l\'inclusione e le pari opportunità.</p>\n              <p class=\"text-dark mb-5\"><i class=\"fa fa-check secondary-color me-2\"></i> Sensibilizzare su temi sociali, ambientali e culturali.</p>\n            \n                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>\n                <?php endif; ?>\n            </div>\n\n\n\n\n            \n            <?php includeContainer(\'highlights\'); ?>\n        </div>\n    </div>\n</div>',0,'2025-04-14 13:31:59',NULL,'2025-05-06 14:36:50',NULL,NULL,'page','it',286,'','',NULL,'','',0,NULL,NULL),
(291,42,'page','','page','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$pageId = GETPOSTINT(\'blog\');\n$eventId = GETPOSTINT(\'id\');\n$donationForId = GETPOSTINT(\'donation\');\n\nif ((!$pageId && !$eventId && !$donationForId) || ($pageId && $eventId)) {\n    redirectToContainer(\'index\');\n}\n\n$showEventGoalRaised = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {\n    $showEventGoalRaised = 1;\n}\n\n$showDonationLink = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {\n    $showDonationLink = 1;\n}\n\n$showParticipateLink = 0;\nif (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {\n    $showParticipateLink = 1;\n}\n\n$data = array();\nif ($pageId) {\n    $type = \"blogpage\";\n    $blog = $websitepage->fetch($pageId);\n    if ($blog < 0) {\n        redirectToContainer(\'index\');\n    } else {\n        $data[\'date_creation\'] = $websitepage->date_creation;\n        $data[\'author_alias\'] = ($websitepage->author_alias ? $websitepage->author_alias : \'\');\n        $data[\'title\'] = $websitepage->title;\n        $data[\'content\'] = $websitepage->content;\n        $data[\'budget_amount\'] = 0;\n        $data[\'collected\'] = 0;\n        $data[\'type\'] = $type;\n    }\n}\n\nif ($eventId) {\n    if (!isModEnabled(\'eventorganization\') || getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')) {\n        redirectToContainer(\'index\');\n    }\n    $type = \"eventpage\";\n    \n    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n        FROM \".MAIN_DB_PREFIX.\"projet as p \n        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $eventId;\n        \n    $resql = $db->query($sql);\n    if ($resql) {\n        $obj = $db->fetch_object($resql);\n        $collected = 0;\n        if ($obj->budget_amount > 0) {\n            $sqlCollected = \"SELECT SUM(amount) as total_collected \n                             FROM \".MAIN_DB_PREFIX.\"don \n                             WHERE fk_projet = \".$obj->rowid;\n            $resqlCollected = $db->query($sqlCollected);\n            \n            if ($resqlCollected) {\n                $objCollected = $db->fetch_object($resqlCollected);\n                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n            }\n        }\n        \n        $data[\'date_creation\'] = $obj->datec;\n        $data[\'author_alias\'] = \"\";\n        $data[\'title\'] = $obj->title;\n        $data[\'content\'] = $obj->description;\n        $data[\'budget_amount\'] = $obj->budget_amount;\n        $data[\'collected\'] = $collected;\n        $data[\'type\'] = $type;\n       \n    } else {\n        redirectToContainer(\'index\');\n    }\n}\n\nif ($donationForId) {\n    $type = \"donationpage\";\n    \n    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n        FROM \".MAIN_DB_PREFIX.\"projet as p \n        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $donationForId;\n        \n    $resql = $db->query($sql);\n    if ($resql) {\n        $obj = $db->fetch_object($resql);\n        $collected = 0;\n        if ($obj->budget_amount > 0) {\n            $sqlCollected = \"SELECT SUM(amount) as total_collected \n                             FROM \".MAIN_DB_PREFIX.\"don \n                             WHERE fk_projet = \".$obj->rowid;\n            $resqlCollected = $db->query($sqlCollected);\n            \n            if ($resqlCollected) {\n                $objCollected = $db->fetch_object($resqlCollected);\n                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n            }\n        }\n        \n        $data[\'date_creation\'] = $obj->datec;\n        $data[\'author_alias\'] = \"\";\n        $data[\'title\'] = $obj->title;\n        $data[\'content\'] = \'<div id=\"iframe-container\"><iframe id=\"donationFrame\" frameborder=\"0\" style=\"overflow:hidden;width:100%;height:100%;\" src=\"\' . $socInfo[\'link_donation\'] . \'?project_id=\' . urlencode($donationForId) . \'&ws=\' . urlencode($website->id) . \'\"\n></iframe></div>\';\n        $data[\'budget_amount\'] = $obj->budget_amount;\n        $data[\'collected\'] = $collected;\n        $data[\'type\'] = $type;\n       \n    } else {\n        redirectToContainer(\'index\');\n    }\n}\n\n/*print \"<pre>\";\nprint_r ($data);\nprint \"</pre>\";*/\ndefine(\"__SEO_PAGE_TITLE__\", $data[\'title\']); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 190px;\">\n    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 190px;\">\n        <div class=\"col-lg-12 text-center breadcrumb-box\">\n            \n            <ol class=\"breadcrumb justify-content-center mb-3 lead\">\n				<li class=\"breadcrumb-item\"><a href=\"/\" class=\"text-decoration-none\"><?php echo $weblangs->trans(\"home\"); ?></a></li>\n				<li class=\"breadcrumb-item\">\n				    <a href=\"/events\" class=\"text-decoration-none\">\n				        <?php echo $weblangs->trans($data[\'type\'] === \"blogpage\" ? \"news\" : \"actionsEvents\"); ?>\n				    </a>\n				</li>\n			</ol>\n			\n            <h1 class=\"mb-3\"><?php print $data[\'title\']; ?></h1>\n            <span>\n                <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($data[\'date_creation\'], \'daytext\', \'tzuser\', $weblangs); ?>\n                \n                <?php if ($data[\'type\'] == \"blogpage\") { ?>\n                    <span class=\"author-span ms-3\"><i class=\"fas fa-user me-2\"></i> \n                        <?php \n                            if ($data[\'author_alias\']) { \n                                echo $data[\'author_alias\']; \n                            } else { \n                                echo $weblangs->trans(\"anonymous\");\n                            } \n                        ?> \n                    </span>\n                <?php } ?>\n                \n                <?php if ($data[\'budget_amount\'] && $showEventGoalRaised) { ?>\n                    <span class=\"text-white ms-3\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($data[\'budget_amount\'], \'MT\'), 1, \'\', 1, -1); ?> €</span>\n                <?php } ?>\n                \n                <?php if ($data[\'budget_amount\'] && $showEventGoalRaised) { ?>\n                    <span class=\"text-white ms-3\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($data[\'collected\'], \'MT\'), 1, \'\', 1, -1); ?> €</span>\n                <?php } ?>\n            </span>\n        </div>\n    </div>\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n  \n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n\n		<div class=\"<?php echo $data[\'type\'] === \'donationpage\' ? \'col-md-12\' : \'col-md-8\'; ?>\" style=\"min-height:1200px;\">\n			<article id=\"content\">\n				<?php print html_entity_decode($data[\'content\']); ?>\n			</article>\n		</div>\n		\n		<?php if ($data[\'type\'] !== \"donationpage\") { ?>\n		    <?php includeContainer(\'sidebar\'); ?>\n		<?php } ?>\n		\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',0,'2025-04-16 10:10:24',NULL,'2025-05-07 08:31:33',NULL,NULL,'page','',NULL,'','',NULL,'','',0,NULL,NULL),
(292,42,'rgpd','','rgpd','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n\ndefine(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"RGPD\")); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 190px;\">\n    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 190px;\">\n        <div class=\"col-lg-12 text-center breadcrumb-box\">\n            \n            <ol class=\"breadcrumb justify-content-center mb-3 lead\">\n				<li class=\"breadcrumb-item\"><a href=\"/\" class=\"text-decoration-none\"><?php echo $weblangs->trans(\"home\"); ?></a></li>\n				<li class=\"breadcrumb-item\">\n				    <a href=\"/events\" class=\"text-decoration-none\">\n				        <?php echo $weblangs->trans(\"RGPD\"); ?>\n				    </a>\n				</li>\n			</ol>\n			\n            <h1 class=\"mb-3\"><?php echo $weblangs->trans(\"RGPD\"); ?></h1>\n        </div>\n    </div>\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n  \n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n		<div class=\"col-md-12\" style=\"min-height:1200px;\">\n			<p>\n              We are committed to respecting your privacy and protecting any personal information you choose to share with us.  \n              Your data is handled responsibly, securely, and in accordance with applicable data protection laws.  \n              We believe in transparency, accountability, and safeguarding your rights at every step.\n            </p>\n		</div>\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',0,'2025-05-05 13:44:30',NULL,'2025-05-07 08:35:08',NULL,NULL,'page','en',NULL,'','',NULL,'','',0,NULL,NULL),
(293,42,'sidebar','','sidebar','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$pageId = GETPOSTINT(\'blog\');\n$eventId = GETPOSTINT(\'id\');\n\n$showDonationLink = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {\n    $showDonationLink = 1;\n}\n\n$showEventGoalRaised = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {\n    $showEventGoalRaised = 1;\n}\n\n$showParticipateLink = 0;\nif (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {\n    $showParticipateLink = 1;\n}\n\n$link_participation = \'\';\n\nif ($eventId) {\n    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n        FROM \".MAIN_DB_PREFIX.\"projet as p \n        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $eventId;\n        \n    $resql = $db->query($sql);\n    if ($resql) {\n        $obj = $db->fetch_object($resql);\n        $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\');\n        $link_participation = $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey);\n    }\n}\n\n?>\n<div class=\"col-md-4\">\n\n	\n	<div class=\"container-fluid causes sidebar-joinus\">\n        <div class=\"container\">\n            <div class=\"section-title\">\n              <div class=\"line left-line\"></div>\n              <h1><?php echo $weblangs->trans(\"joinUs\"); ?></h1>\n              <div class=\"line right-line\"></div>\n            </div>\n            <div class=\"row g-4\">\n                <?php if ($showDonationLink) { ?>\n                    <?php if ($eventId) { ?>\n                        <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-donate\"></i> <?php echo $weblangs->trans(\"donateNow\"); ?> </a>\n                    <?php } else { ?>\n                        <a href=\"<?php echo $socInfo[\'link_donation\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-donate\"></i> <?php echo $weblangs->trans(\"donateNow\"); ?> </a>\n                    <?php } ?>\n                    \n                <?php } ?>\n                <?php if ($link_participation && $showParticipateLink) { ?>\n                    <a href=\"<?php echo $link_participation; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-user-plus\"></i> <?php echo $weblangs->trans(\"Participate\"); ?> </a>\n                <?php } ?>\n            </div>\n        </div>\n    </div>\n	\n	<div class=\"container-fluid causes\">\n        <div class=\"container py-5\">\n            <div class=\"section-title\">\n              <div class=\"line left-line\"></div>\n              <h1><?php echo $weblangs->trans(\"news\"); ?></h1>\n              <div class=\"line right-line\"></div>\n            </div>\n            <div class=\"row g-4\">\n            <?php \n            $MAXNEWS = 2;\n            $allblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 0, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n            $countofblogs = count($allblogs);\n            $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', $MAXNEWS, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n            foreach($arrayofblogs as $blog)\n            {\n            ?>\n                <div class=\"col-12-12\">\n                    <div class=\"causes-item\">\n                        <div class=\"causes-img\">\n                            <?php\n                                $urlforimage = getImageFromHtmlContent($blog->content);\n                                if (empty($urlforimage)) {\n                                    $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                                }\n                            ?>\n                            <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                        </div>\n                        <div class=\"progress progress-news\">\n                          <div class=\"progress-bar\" role=\"progressbar\" style=\"width: 100%;\" aria-valuenow=\"100\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                          </div>\n                        </div>\n                        <div class=\"causes-content p-4\">\n                            <span class=\"text-body\">\n                                <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($blog->date_creation, \'daytext\', \'tzuser\', $weblangs); ?>\n                                <span class=\"author-span\"><i class=\"fas fa-user me-2\"></i> <?php echo ($blog->author_alias ? $blog->author_alias : \'anonymous\'); ?></span>\n                            </span>\n                            <h4 class=\"py-3\"><?php echo $blog->title; ?></h4>\n                            <hr>\n                            <p class=\"mb-4 truncate3\"><?php echo $blog->description; ?></p>\n                            <a href=\"page.php?ref=<?php print $blog->pageurl; ?>&blog=<?php print $blog->id; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                        </div>\n                    </div>\n                </div>\n                <?php \n            }\n            ?>\n            </div>\n                \n        </div>\n    </div>\n    \n    \n    <div class=\"container-fluid causes\">\n        <div class=\"container\">\n            <div class=\"section-title\">\n              <div class=\"line left-line\"></div>\n              <h1><?php echo $weblangs->trans(\"actions\"); ?></h1>\n              <div class=\"line right-line\"></div>\n            </div>\n            <div class=\"row g-4\">\n    \n                <?php \n                $maxevents = 2;\n                $countofevents = 0;\n                $sqlCount = \"SELECT count(p.rowid) as countofevents \n                        FROM \".MAIN_DB_PREFIX.\"projet as p \n                        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                        ORDER BY p.datec DESC \";\n                $resqlCount = $db->query($sqlCount);\n                if ($resqlCount) {\n                    $objCount = $db->fetch_object($resqlCount);\n                    $countofevents = $objCount->countofevents ? $objCount->countofevents : 0;\n                }\n            \n                $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n                        FROM \".MAIN_DB_PREFIX.\"projet as p \n                        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                        ORDER BY p.datec DESC \n                        LIMIT \".$maxevents;\n                $resql = $db->query($sql);\n                if ($resql) {\n                    $countofblogs = $db->num_rows($resql);\n                    while ($obj = $db->fetch_object($resql)) {\n                        ?>\n                        <div class=\"col-xs-12\">\n                            <div class=\"causes-item\">\n                                <div class=\"causes-img\">\n                                    <?php\n                                        $urlforimage = getImageFromHtmlContent($obj->description ? $obj->description : \"\");\n                                        if (empty($urlforimage)) {\n                                            $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                                        }\n                                    ?>\n                                    <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                                    <div class=\"causes-link pb-2 px-3\">\n                                        <?php\n                                            $progress = 100;\n                                            if ($obj->budget_amount > 0 && $showEventGoalRaised) {\n                                                $sqlCollected = \"SELECT SUM(amount) as total_collected \n                                                                 FROM \".MAIN_DB_PREFIX.\"don \n                                                                 WHERE fk_projet = \".$obj->rowid;\n                                                $resqlCollected = $db->query($sqlCollected);\n                                                $collected = 0;\n                                                if ($resqlCollected) {\n                                                    $objCollected = $db->fetch_object($resqlCollected);\n                                                    $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n                                                }\n                                                $progress = round(($collected / $obj->budget_amount) * 100, 2);\n                                            }\n                                        ?>\n                                        \n                                        <?php if ($showEventGoalRaised) { ?>\n                                            <small class=\"text-white\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($obj->budget_amount, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                            <small class=\"text-white\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($collected, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                        <?php } ?>  \n                                    </div>\n                                    <div class=\"causes-dination p-2\">\n                                        <?php if ($showDonationLink) { ?>\n                                            <?php if (getDolGlobalInt(\'WS_\' . strtoupper($website->ref) . \'_PAYMENT_IN_FRAME\')) { ?>\n                                                <a href=\"page.php?donation=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                            <?php } else { ?>\n                                                <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                            <?php } ?>\n                                        <?php } ?>\n                                        \n                                        <?php if ($showParticipateLink) { ?>\n                                            <?php $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\'); ?>\n                                            <a href=\"<?php echo $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"Participate\"); ?></a>\n                                        <?php } ?>\n\n                                    </div>\n                                </div>\n                                \n                                <div class=\"progress\">\n                                  <div class=\"progress-bar\" role=\"progressbar\" style=\"width: <?php echo $progress; ?>%;\" aria-valuenow=\"<?php echo $progress; ?>\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                                    <?php if ($showEventGoalRaised) { ?>\n                                    <span><?php echo $progress; ?>%</span>\n                                    <?php } ?>\n                                  </div>\n                                </div>\n                                <div class=\"causes-content p-4\">\n                                    <span class=\"text-body\">\n                                        <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($obj->datec, \'daytext\', \'tzuser\', $weblangs); ?>\n                                    </span>\n                                    <h4 class=\"py-3\"><?php echo $obj->title; ?></h4>\n    \n                                    <a href=\"page.php?id=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                                </div>\n                            </div>\n                        </div>\n                        <?php\n                    }\n                }\n                ?>\n            </div>\n\n        </div>\n    </div>\n	\n</div>',0,'2025-04-16 11:08:11',NULL,'2025-05-15 16:04:21',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(294,42,'slider','','slider','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\n//setSessionLang();\n$socInfo = getSocInfo();\n?>\n\n<section class=\"slogan has-section-divider\">\n  \n    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 460px;\">\n        <div class=\"col-lg-8 text-center\">\n            <h1 class=\"mb-3\"><?php print $socInfo[\'slogan\']; ?></h1>\n            <p class=\"lead\"><?php print $socInfo[\'description\']; ?></p>\n            <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                <p><a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button\">Devenir Membre</a></p>\n            <?php endif; ?>\n        </div>\n    </div>\n  \n  \n  <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"var(--light-secondary-color)\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n  \n</section>',0,'2025-04-08 14:25:00',NULL,'2025-05-07 12:59:21',NULL,NULL,'other','',NULL,'','',NULL,'','',0,NULL,NULL),
(295,42,'_library_lib','','lib','','','<?php\n/**\n * Set session language based on:\n * - Cookie \'lang\' (if exists)\n * - Browser language (if not present among website languages, use website main language)\n * - Form field \'language\' (if present)\n *\n * The function also updates the product labels of the products in the session\n * to match the current language.\n *\n * @return bool\n */\nfunction setSessionLang() {\n   global $langs, $website, $weblangs, $db;\n    // Get available langs for the website\n    $website_langs = getAvailableLangs();\n    $available_langs = $website_langs[\'langs\'];\n    $langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];\n\n    // If no language is set or if a new language is selected (via form field)\n    if (!isset($_COOKIE[\'lang\']) || GETPOST(\'l\', \'alpha\')) {\n        // Get browser language\n        $browser_lang = $weblangs->getDefaultLang(1);\n\n        // Change used lang\n        $new_lang = GETPOST(\'l\', \'alpha\');\n        if ($new_lang && array_key_exists ($new_lang, $available_langs)) {\n            setcookie(\'lang\', $new_lang, time() + (86400 * 30), \'/\');\n            $session_lang = $new_lang;\n        }\n\n        // If no language is set in cookie and browser language is not present among available languages\n        // use website main language as default\n        if (!isset($_COOKIE[\'lang\'])) {\n            if (array_key_exists ($browser_lang, $available_langs)){\n                // The browser language is present among the available languages\n                setcookie(\'lang\', $browser_lang, time() + (86400 * 30), \'/\');\n                $session_lang = $browser_lang;\n            } else {\n                // The browser language is not present among the available languages\n                setcookie(\'lang\', $website->lang, time() + (86400 * 30), \'/\');\n                $session_lang = $website->lang;\n            }\n        }\n\n        // Set session lang\n        if (!empty($session_lang)) {\n            $_SESSION[\'lang\'][\'shortcode\'] = $session_lang;\n            $_SESSION[\'lang\'][\'code\'] = $langs_code_shortcode[$session_lang];\n        }\n\n    }\n\n    // If session language is not set, use cookie language\n    if (empty($_SESSION[\'lang\'][\'shortcode\']) || empty($_SESSION[\'lang\'][\'code\'])) {\n        $_SESSION[\'lang\'][\'shortcode\'] = $_COOKIE[\'lang\'];\n        $_SESSION[\'lang\'][\'code\'] = $langs_code_shortcode[$_COOKIE[\'lang\']];\n    }\n\n    // Set Dolibarr default language\n    $langs->setDefaultLang($_SESSION[\'lang\'][\'code\']);\n    $weblangs->setDefaultLang($_SESSION[\'lang\'][\'code\']);\n    $langs->loadLangs(array(\"main\", \"website\", \"languages\", \"members\", \"admin\", \"donations\", \"companies\"));\n    $weblangs->loadLangs(array(\"main\", \"website\", \"languages\", \"members\", \"admin\", \"donations\", \"companies\"));\n\n    return true;\n}\n\n/**\n * The function loops through the languages of the website configuration and\n * checks if they exist in the list of supported languages. If they do, they\n * are added to the $available_langs array, along with their corresponding\n * shortcode in the $langs_code_shortcode array.\n *\n * The function returns an array with two keys: \'langs\' containing the list\n * of available languages and \'langs_code_shortcode\' containing the list\n * of corresponding shortcodes.\n *\n * @return array\n */\nfunction getAvailableLangs() {\n    global $website, $weblangs;\n\n    $available_langs = array();\n    $langs_code_shortcode = array();\n    $ws_langs_list = explode(\',\', $website->lang.\',\'.$website->otherlang);\n    $dol_available_langs = $weblangs->get_available_languages(DOL_DOCUMENT_ROOT, 1, 2, 1);\n    foreach ($ws_langs_list as $lang) {\n        foreach ($dol_available_langs as $key => $value) {\n            if (strpos($key, $lang) === 0) {\n                $available_langs[$lang] = $value;\n                $langs_code_shortcode[$lang] = $key;\n                break;\n            }\n        }\n    }\n    \n    return array(\'langs\' => $available_langs, \'langs_code_shortcode\' => $langs_code_shortcode);\n}\n\n/**\n * Get societe information from Dolibarr configuration.\n *\n * This function retrieves the societe information from the global $conf object\n * and returns it as an associative array.\n *\n * @return array\n */\nfunction getSocInfo() {\n    global $conf, $mysoc, $weblangs, $website;\n    $weblangs->load(\"admin\");\n\n    $societe_info = array(\n        \'name\' => !empty($mysoc->name) ? html_entity_decode($mysoc->name) : \'\',\n        \'address\' => !empty($mysoc->getFullAddress(1)) ? html_entity_decode($mysoc->getFullAddress(1)) : \'\',\n        \'zip\' => !empty($mysoc->zip) ? html_entity_decode($mysoc->zip) : \'\',\n        \'town\' => !empty($mysoc->town) ? html_entity_decode($mysoc->town) : \'\',\n        \'country\' => !empty($mysoc->country) ? html_entity_decode($mysoc->country) : \'\',\n        \'phone\' => !empty($mysoc->phone) ? html_entity_decode($mysoc->phone) : \'\',\n        \'fax\' => !empty($mysoc->fax) ? html_entity_decode($mysoc->fax) : \'\',\n        \'email\' => !empty($mysoc->email) ? html_entity_decode($mysoc->email) : \'\',\n        \'slogan\' => getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\') \n                ? html_entity_decode(getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\')) \n                : (!empty($mysoc->name) \n                    ? html_entity_decode($mysoc->name) \n                    : html_entity_decode($weblangs->trans(\"noCompanyInfoSlogan\"))),\n        \'description\' => getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\') \n                ? html_entity_decode(getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\')) \n                : (!empty($mysoc->socialobject) \n                    ? html_entity_decode($mysoc->socialobject) \n                    : html_entity_decode($weblangs->trans(\"noCompanyInfoDescription\", $weblangs->trans(\"CompanyObject\"))))\n    );\n\n    // Add social networks if they are set\n    foreach($mysoc->socialnetworks as $key => $value) {\n        if (!empty($value)) {\n            $societe_info[$key] = preg_match(\'/^http/\', $value) ? $value : \'https://www.\'.$key.\'.com/\'.$value;\n        }\n    }\n    \n    // Add link to subscription\n    if (isModEnabled(\'multicompany\')) {\n      $entity_qr = \'?entity=\' . ((int) $conf->entity);\n    } else {\n      $entity_qr = \'\';\n    }\n    $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));\n    $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;\n    $societe_info[\'subscription_link\'] = $urlwithroot . \'/public/members/new.php\'.$entity_qr;\n    \n    // Add participation link\n    $link_participation = $urlwithroot.\'/public/eventorganization/attendee_new.php?type=global\';\n	$societe_info[\'link_participation\'] = $link_participation;\n	\n	// Add donation link\n    $link_donation = $urlwithroot.\'/public/donations/new.php\';\n	$societe_info[\'link_donation\'] = $link_donation;\n\n    return $societe_info;\n}',0,'2025-04-11 10:57:25',NULL,'2025-05-02 12:11:20',NULL,NULL,'library','',NULL,'','',NULL,'','',0,NULL,NULL),
(296,43,'config','','config','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$message = \'\';\nif (!isModEnabled(\'eventorganization\') || !isModEnabled(\'member\') || !isModEnabled(\'don\') || !isModEnabled(\'webportal\')) {\n    $message = $langs->trans(\"TEMPLATE_MODULES_NOTICE\") .\"<br><br>\";\n}\n\n\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'USE_TEXT_LOGO\')->setAsYesNo();\n$item->nameText = $langs->trans(\"USE_TEXT_LOGO\");\n\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\');\n$item->nameText = $langs->trans(\"CUSTOM_SLOGAN\");\n$item->cssClass = \'minwidth500\';\n\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\');\n$item->nameText = $langs->trans(\"CUSTOM_DESCRIPTION\");\n$item->cssClass = \'minwidth500\';\n\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_LANG_SELECTOR\')->setAsYesNo();\n$item->nameText = $langs->trans(\"SHOW_LANG_SELECTOR\");\n\n// Get available langs for the website\n$TField = array();\n$website_langs = getAvailableLangs();\n$available_langs = $website_langs[\'langs\'];\n$langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];\nforeach ($available_langs as $key => $value) {\n    $TField[$key] = trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$key]))[0]);\n}\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\');\n$item->nameText = $langs->trans(\"SUPPORTED_LANGS\");\n$item->setAsMultiSelect($TField);\n\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'MAIN_COLOR\');\n$item->nameText = $langs->trans(\"MAIN_COLOR\");\n$item->cssClass = \'minwidth500\';\n\n$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SECONDARY_COLOR\');\n$item->nameText = $langs->trans(\"SECONDARY_COLOR\");\n$item->cssClass = \'minwidth500\';\n\nif (isModEnabled(\'member\')) {\n    $formSetup->newItem(\'membersArea\')->setAsTitle();\n    \n    $item = $formSetup->newItem(\'MEMBER_ENABLE_PUBLIC\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"ENABLE_MEMBER_REGISTRATION_PAGE\");\n    \n    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"ENABLE_MEMBER_LIST_PAGE\");\n    \n    if (isModEnabled(\'webportal\')) {\n        $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')->setAsYesNo();\n        $item->nameText = $langs->trans(\"ENABLE_MEMBER_AREA_PAGE\");\n    }\n}\n\nif (isModEnabled(\'eventorganization\')) {\n    $formSetup->newItem(\'eventsArea\')->setAsTitle();\n    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"DISABLE_EVENTS_SECTION\");\n    \n    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"SHOW_EVENT_PARTICIPATE_LINK\");\n    \n    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"SHOW_EVENT_GOAL_RAISED_AMOUNTS\");\n}\n\nif (isModEnabled(\'don\')) {\n    $formSetup->newItem(\'DonationsArea\')->setAsTitle();\n    $item = $formSetup->newItem(\'DONATION_ENABLE_PUBLIC\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"ENABLE_DONATION_PAGE\");\n    \n    $item = $formSetup->newItem(\'DONATION_COUNTERS_ARE_PUBLIC\')->setAsYesNo();\n    $item->nameText = $langs->trans(\"DONATION_COUNTERS_ARE_PUBLIC\");\n}\n\n?>\n',0,'2025-04-30 09:05:35',NULL,'2025-05-16 12:06:30',NULL,NULL,'setup','',NULL,'','',NULL,'','',0,NULL,NULL),
(297,43,'contact','','contact','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\nif (GETPOST(\'action\') == \'sendmail\') {\n    include_once DOL_DOCUMENT_ROOT.\'/core/class/CMailFile.class.php\';\n    \n    // Set message language\n	$emaillang = new Translate(\'\', $conf);\n	if ($mysoc->default_lang) {\n	    $emaillang->setDefaultLang($mysoc->default_lang);\n	    $emaillang->loadLangs(array(\"main\", \"website\"));\n	}\n	\n\n    $from = GETPOST(\'email\', \'alpha\');\n    $to = $mysoc->email;\n    $subject = html_entity_decode ($emaillang->trans(\"contactFormReceived\", $website->ref));\n\n    $firstname = GETPOST(\'firstname\', \'alpha\');\n    $phone = GETPOST(\'phone\', \'alpha\');\n    $usersubject = GETPOST(\'subject\', \'alpha\');\n    $messageContent = GETPOST(\'message\', \'alpha\');\n\n    $message = html_entity_decode ($emaillang->trans(\"contactFormReceived\", $website->ref)) . \"\\n\\n\";\n    $message .= html_entity_decode ($emaillang->trans(\"contactFormName\")) . \": $firstname\\n\";\n    $message .= html_entity_decode ($emaillang->trans(\"contactFormEmail\")) . \": $from\\n\";\n    $message .= html_entity_decode ($emaillang->trans(\"contactFormPhone\")) . \": \" . (!empty($phone) ? $phone : \"N/A\") . \"\\n\";\n    $message .= html_entity_decode ($emaillang->trans(\"contactFormSubjectEntered\")) . \": $usersubject\\n\\n\";\n    $message .= html_entity_decode ($emaillang->trans(\"contactFormMessageLabel\")) . \":\\n$messageContent\\n\";\n\n    $cmail = new CMailFile($subject, $to, $from, $message);\n\n    if ($cmail->sendfile()) {\n        ?>\n        <script>\n            alert(\"<?php echo html_entity_decode ($emaillang->trans(\"contactFormSuccessAlert\")); ?>\");\n        </script>\n        <?php\n    } else {\n        echo html_entity_decode ($langs->trans(\"ErrorFailedToSendMail\", $from, $to)) . \'. \' . $cmail->error;\n    }\n}\n\n\n\n?>\n<div class=\"container-fluid\">\n    <div class=\"container py-5\">\n        \n        <div class=\"container-fluid contact py-5\">\n            <div class=\"row g-4\">\n                <div class=\"col-xl-5\">\n                    \n                    <div class=\"section-title\" id=\"section-contact\" style=\"scroll-margin-top: 130px;\">\n                      <div class=\"line left-line\"></div>\n                      <h1><?php echo $weblangs->trans(\"contactTitle\"); ?></h1>\n                      <div class=\"line right-line\"></div>\n                    </div>\n        \n                    <p class=\"mb-4\"><?php echo $weblangs->trans(\"contactMessage\"); ?></p>\n                    <form method=\"post\" action=\"#\">\n                        <div class=\"row gx-4 gy-3\">\n                            <div class=\"col-xl-6\">\n                                <input type=\"text\" name=\"firstname\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelFirstName\"); ?>\" required>\n                            </div>\n                            <div class=\"col-xl-6\">\n                                <input type=\"email\" name=\"email\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelEmail\"); ?>\" required>\n                            </div>\n                            <div class=\"col-xl-6\">\n                                <input type=\"text\" name=\"phone\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelPhone\"); ?>\">\n                            </div>\n                            <div class=\"col-xl-6\">\n                                <input type=\"text\" name=\"subject\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelSubject\"); ?>\" required>\n                            </div>\n                            <div class=\"col-12\">\n                                <textarea name=\"message\" class=\"form-control bg-white border-0 py-3 px-4\" rows=\"7\" cols=\"10\" placeholder=\"<?php echo $weblangs->trans(\"labelMessage\"); ?>\" required></textarea>\n                            </div>\n                            <div class=\"col-12\">\n                                <button class=\"btn flat-button text-white py-2 px-3 float-end\" type=\"submit\" name=\"action\" value=\"sendmail\"><?php echo $weblangs->trans(\"submit\"); ?></button>\n                            </div>\n                        </div>\n                    </form>\n                </div>\n                <div class=\"col-xl-7\">\n                    <div>\n                        <div class=\"row g-4\">\n                            <div class=\"col-lg-6\">\n                                <div class=\"bg-white p-2 text-center\">\n                                    <i class=\"fas fa-map-marker-alt fa-2x secondary-color mb-2\"></i>\n                                    <h4><?php echo $weblangs->trans(\"labelAddress\"); ?></h4>\n                                    <p class=\"mb-0\"><?php echo $socInfo[\'address\']; ?></p>\n                                </div>\n                            </div>\n                            <div class=\"col-lg-6\">\n                                <div class=\"bg-white p-2 text-center\">\n                                    <i class=\"fas fa-envelope fa-2x secondary-color mb-2\"></i>\n                                    <h4><?php echo $weblangs->trans(\"labelEmail\"); ?></h4>\n                                    <p class=\"mb-0\">\n                                        <a href=\"mailto:<?php echo htmlspecialchars($socInfo[\'email\']); ?>\">\n                                            <?php echo htmlspecialchars($socInfo[\'email\']); ?>\n                                        </a>\n                                    </p>\n                                </div>\n                            </div>\n                            <!--<div class=\"col-lg-4\">\n                                <div class=\"bg-white p-2 text-center\">\n                                    <i class=\"fa fa-phone-alt fa-2x secondary-color mb-2\"></i>\n                                    <h4><?php echo $weblangs->trans(\"labelPhone\"); ?></h4>\n                                    <p class=\"mb-0\"><?php echo $socInfo[\'phone\']; ?></p>\n                                </div>\n                            </div>-->\n                            <div class=\"col-lg-12\">\n                                <iframe class=\"w-100\" style=\"height: 412px; margin-bottom: -6px;\" src=\"https://maps.google.com/maps?q=<?php echo urlencode($mysoc->getFullAddress()); ?>&t=&z=13&ie=UTF8&iwloc=&output=embed\" \n                                    loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>\n                            </div>\n                        </div>\n                    </div>\n                </div>\n            </div>\n        </div>\n    </div>\n</div>',1,'2025-04-08 14:35:43',NULL,'2025-05-16 12:25:23',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(298,43,'donation-list','','donation-list','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\nif (!isModEnabled(\'don\') || !getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') || !getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')) {\n    redirectToContainer(\'index\');\n}\n\n\n$data = array();\n\n$sql = \"SELECT d.rowid, d.datedon as datec, s.nom as societe, d.firstname, d.lastname, p.title, d.amount\";\n$sql .= \" FROM \".MAIN_DB_PREFIX.\"don as d LEFT JOIN \".MAIN_DB_PREFIX.\"projet AS p\";\n$sql .= \" ON p.rowid = d.fk_projet\";\n$sql .= \" LEFT JOIN \" . MAIN_DB_PREFIX . \"societe AS s ON s.rowid = d.fk_soc\";\n$sql .= \" WHERE d.entity IN (\". getEntity(\'donation\') . \")\";\n$sql .= \" AND d.fk_statut IN (2)\";\n$sql .= \" AND d.paid = 1\";\n$sql .= \" AND d.public = 1\";\n$sql .= \" AND p.public = 1\";\n$sql .= $db->order(\"datedon\", \"DESC\");\n    \n$resql = $db->query($sql);\nif ($resql) {\n    while ($obj = $db->fetch_object($resql)) {\n        $data[] = array(\n			\'firstname\' => $obj->firstname,\n			\'lastname\' => $obj->lastname,\n			\'societe\' => $obj->societe,\n			\'datec\' => $obj->datec,\n			\'project\' => $obj->title,\n			\'amount\' => $obj->amount,\n		);\n    }\n}\n/*print \"<pre>\";\nprint_r ($data);\nprint \"</pre>\";*/\ndefine(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"listOfPublicDonations\")); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 0;\">\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n\n		\n\n<div class=\"col-md-8\">\n    <div class=\"section-title\">\n      <div class=\"line left-line\"></div>\n      <h1><?php print $weblangs->trans(\"listOfPublicDonations\"); ?></h1>\n      <div class=\"line right-line\"></div>\n    </div>\n            \n    <table id=\"membersTable\" class=\"table table-striped\">\n        <thead>\n            <tr>\n                <th>#</th>\n                <th><?php echo $weblangs->trans(\"Firstname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Lastname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Company\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Date\"); ?></th>\n                \n                <th><?php echo $weblangs->trans(\"project\"); ?></th>\n                <th><?php echo $weblangs->trans(\"amount\"); ?></th>\n            </tr>\n        </thead>\n        <tbody>\n            <?php if (!empty($data) && is_array($data)): ?>\n                <?php foreach ($data as $index => $row): ?>\n                    <tr>\n                        <td><?php echo (int)($index + 1); ?></td>\n                        <td><?php echo !empty($row[\'firstname\']) ? htmlspecialchars($row[\'firstname\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>\n                        <td><?php echo !empty($row[\'lastname\']) ? htmlspecialchars($row[\'lastname\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>\n                        <td><?php echo !empty($row[\'societe\']) ? htmlspecialchars($row[\'societe\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>\n                        <td><?php echo dol_print_date($row[\'datec\'], \'daytext\', \'tzuser\', $weblangs); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'project\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo price(price2num($row[\'amount\'], \'MT\'), 1, \'\', 1, -1); ?> €</td>\n                    </tr>\n                <?php endforeach; ?>\n            <?php endif; ?>\n        </tbody>\n    </table>\n    <script>\n        $(document).ready(function() {\n            $(\'#membersTable\').DataTable({\n                language: {\n                    url: \"https://cdn.datatables.net/plug-ins/1.13.6/i18n/<?php print str_replace(\'_\', \'-\', $_SESSION[\'lang\'][\'code\']); ?>.json\"\n                }\n            });\n        });\n    </script>\n</div>\n\n\n\n	    <?php includeContainer(\'sidebar\'); ?>\n		\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',1,'2025-04-29 17:00:33',NULL,'2025-05-16 12:26:52',NULL,NULL,'page','',NULL,'','<!-- DataTables CSS/JS -->\n<link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\">\n<script src=\"https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js\"></script>',NULL,'','',0,NULL,NULL),
(299,43,'events','','events','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$showDonationLink = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {\n    $showDonationLink = 1;\n}\n\n$showEventGoalRaised = 0;\nif (isModEnabled(\'don\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {\n    $showEventGoalRaised = 1;\n}\n\n$showParticipateLink = 0;\nif (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {\n    $showParticipateLink = 1;\n}\n?>\n<div class=\"container-fluid causes\">\n    <div class=\"container\">\n        <div class=\"section-title\" id=\"section-events\" style=\"scroll-margin-top: 100px;\">\n          <div class=\"line left-line\"></div>\n          <h1><?php echo $weblangs->trans(\"actionsEvents\"); ?></h1>\n          <div class=\"line right-line\"></div>\n        </div>\n        <div class=\"row g-4\">\n\n            <?php \n            $maxevents = GETPOSTINT(\'maxevents\') ? GETPOSTINT(\'maxevents\') : 3;\n            $countofevents = 0;\n            $sqlCount = \"SELECT count(p.rowid) as countofevents \n                    FROM \".MAIN_DB_PREFIX.\"projet as p \n                    WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                    ORDER BY p.datec DESC \";\n            $resqlCount = $db->query($sqlCount);\n            if ($resqlCount) {\n                $objCount = $db->fetch_object($resqlCount);\n                $countofevents = $objCount->countofevents ? $objCount->countofevents : 0;\n            }\n        \n            $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n                    FROM \".MAIN_DB_PREFIX.\"projet as p \n                    WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                    ORDER BY p.datec DESC \n                    LIMIT \".$maxevents;\n            $resql = $db->query($sql);\n            if ($resql) {\n                $countofblogs = $db->num_rows($resql);\n                $i=1;\n                while ($obj = $db->fetch_object($resql)) {\n                    ?>\n                    <div class=\"col-lg-6 col-xl-4 event-item\" id=\"event-<?php echo $i; ?>\">\n                        <div class=\"causes-item\">\n                            <div class=\"causes-img\">\n                                <?php\n                                    $urlforimage = getImageFromHtmlContent($obj->description ? $obj->description : \"\");\n                                    if (empty($urlforimage)) {\n                                        $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                                    }\n                                ?>\n                                <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                                <div class=\"causes-link pb-2 px-3\">\n                                    <?php\n                                        $progress = 100;\n                                        if ($obj->budget_amount > 0 && $showEventGoalRaised) {\n                                            $sqlCollected = \"SELECT SUM(amount) as total_collected \n                                                             FROM \".MAIN_DB_PREFIX.\"don \n                                                             WHERE fk_projet = \".$obj->rowid;\n                                            $resqlCollected = $db->query($sqlCollected);\n                                            $collected = 0;\n                                            if ($resqlCollected) {\n                                                $objCollected = $db->fetch_object($resqlCollected);\n                                                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n                                            }\n                                            $progress = round(($collected / $obj->budget_amount) * 100, 2);\n                                        }\n                                    ?>\n                                    <?php if ($showEventGoalRaised) { ?>\n                                        <small class=\"text-white\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($obj->budget_amount, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                        <small class=\"text-white\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($collected, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                    <?php } ?>    \n                                </div>\n                                <div class=\"causes-dination p-2\">\n                                    <?php if ($showDonationLink) { ?>\n                                        <?php if (getDolGlobalInt(\'WS_\' . strtoupper($website->ref) . \'_PAYMENT_IN_FRAME\')) { ?>\n                                            <a href=\"page.php?donation=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                        <?php } else { ?>\n                                            <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                        <?php } ?>\n                                    <?php } ?>\n                                    \n                                    <?php if ($showParticipateLink) { ?>\n                                        <?php $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\'); ?>\n                                        <a href=\"<?php echo $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"Participate\"); ?></a>\n                                    <?php } ?>\n                                </div>\n                            </div>\n                            \n                            \n                            <div class=\"progress\">\n                              <div class=\"progress-bar\" role=\"progressbar\" style=\"width: <?php echo $progress; ?>%;\" aria-valuenow=\"<?php echo $progress; ?>\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                                <?php if ($showEventGoalRaised) { ?>\n                                <span><?php echo $progress; ?>%</span>\n                                <?php } ?>\n                              </div>\n                            </div>\n\n                            \n                            <div class=\"causes-content p-4\">\n                                <span class=\"text-body\">\n                                    <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($obj->datec, \'daytext\', \'tzuser\', $weblangs); ?>\n                                </span>\n                                <h4 class=\"py-3\"><?php echo $obj->title; ?></h4>\n\n                                <a href=\"page.php?id=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                            </div>\n                        </div>\n                    </div>\n                    <?php\n                    $i++;\n                }\n            }\n            ?>\n        </div>\n        \n        <?php if ($maxevents <= $countofevents) { ?>\n            <div class=\"row\">\n                <div class=\"col-lg-7 text-center py-5 section-title\">\n                    <div class=\"line left-line left-gradient\"></div>\n                    <a href=\"javascript:void(0);\" class=\"btn flat-button text-white bgmaincolor\" id=\"loadMoreEventsBtn\"><?php echo $weblangs->trans(\"loadMore\"); ?> (<?php echo $maxevents; ?>/<?php echo $countofevents; ?>)</a>\n                    <div class=\"line right-line right-gradient\"></div>\n                </div>\n            </div>\n        <?php } ?>\n        <script>\n            document.getElementById(\'loadMoreEventsBtn\').addEventListener(\'click\', function() {\n            const currentUrl = new URL(window.location.href);\n            const maxEventsParam = <?php echo $maxevents; ?>;\n            const newMaxEvents = parseInt(maxEventsParam) + 3;\n            currentUrl.searchParams.set(\'maxevents\', newMaxEvents);\n            currentUrl.hash = \'#event-\' + (parseInt(maxEventsParam) + 1).toString();\n            window.location.href = currentUrl.toString();\n            });\n        </script>\n    </div>\n</div>',1,'2025-04-14 14:16:40',NULL,'2025-05-16 12:25:29',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(300,43,'footer','','footer','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid\" style=\"margin:0; padding:0;\">\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"<?php print getDolGlobalString(\'WS_\' . strtoupper($website->ref) . \'_MAIN_COLOR\') ?: \'#5d5b6a\'; ?>\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n</div>\n<div class=\"container-fluid footer text-body\">\n    \n    <div class=\"container py-5\">\n        <div class=\"row g-5\">\n            \n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"presentation\"); ?></h4>\n                    <a href=\"/index#section-overview\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"missionVision\"); ?></a>\n                    <a href=\"rgpd.php\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"rgpd\"); ?></a>\n                </div>\n            </div>\n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"newsEvents\"); ?></h4>\n                    <a href=\"index#section-news\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"news\"); ?></a>\n                    <?php if (isModEnabled(\'eventorganization\') && !getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')): ?>\n                        <a href=\"index#section-events\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"actionsEvents\"); ?></a>\n                    <?php endif; ?>\n                </div>\n            </div>\n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"volunteer\"); ?></h4>\n                        <?php if (isModEnabled(\'webportal\') && getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')): ?>\n                          <?php\n                          if (getDolGlobalString(\'WEBPORTAL_ROOT_URL\')) {\n                            $url = getDolGlobalString(\'WEBPORTAL_ROOT_URL\');\n                          } else {\n                            if (isModEnabled(\'multicompany\')) {\n                              $entity_qr = \'?entity=\' . ((int) $conf->entity);\n                            } else {\n                              $entity_qr = \'\';\n                            }\n            \n                            $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));\n                            $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;\n                            $url = $urlwithroot . \'/public/webportal/index.php\' . $entity_qr;\n                          }\n                          ?>\n                          <a href=\"<?php echo $url; ?>\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"memberArea\"); ?></a>\n                        <?php endif; ?>\n                        \n                    <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')): ?>\n                        <a href=\"members-list.php\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"directory\"); ?></a>\n                    <?php endif; ?>\n                    \n                    <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                        <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"becomeMember\"); ?></a>\n                    <?php endif; ?>\n                    \n                    <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\')): ?>\n                        <a href=\"<?php print $socInfo[\'link_donation\']; ?>\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"makeDonation\"); ?></a>\n                    <?php endif; ?>\n                </div>\n            </div>\n            <div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item\">\n                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"socials\"); ?></h4>\n                    <div class=\"social\">\n                        <?php\n                            $socialIcons = [\n                              \'facebook\' => \'fa-facebook-f\',\n                              \'twitter\' => \'fa-x-twitter\',\n                              \'linkedin\' => \'fa-linkedin-in\',\n                              \'instagram\' => \'fa-instagram\',\n                              \'youtube\' => \'fa-youtube\',\n                              \'skype\' => \'fa-skype\',\n                              \'whatsapp\' => \'fa-whatsapp\',\n                              \'snapchat\' => \'fa-snapchat-ghost\',\n                            ];\n                \n                            foreach ($socialIcons as $key => $icon) {\n                              if (!empty($socInfo[$key])) {\n                                echo \'<a href=\"\' . htmlspecialchars($socInfo[$key]) . \'\" target=\"_blank\" class=\"btn-hover-color btn-square text-white me-2\"><i class=\"fa-brands \' . $icon . \'\"></i></a>\';\n                              }\n                            }\n                        ?>\n                    </div>\n                </div>\n            </div>\n            <!--<div class=\"col-md-6 col-lg-6 col-xl-3\">\n                <div class=\"footer-item d-flex flex-column\">\n                    <h4 class=\"mb-4 text-white\">RGPD</h4>\n                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Politique de Confidentialité</a>\n                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Gestion des Données</a>\n                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Droits des Utilisateurs</a>\n\n                </div>\n            </div>-->\n        </div>\n    </div>\n</div>',1,'2025-04-08 14:37:00',NULL,'2025-05-16 12:25:35',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(301,43,'highlights','','highlights','','','<div class=\"col-lg-3 stats section\" id=\"stats\">\n                \n    <div class=\"section-title\">\n      <div class=\"line left-line\"></div>\n      <h1><?php echo $weblangs->trans(\"highlights\"); ?></h1>\n      <div class=\"line right-line\"></div>\n    </div>\n\n    <div class=\"container aos-init aos-animate\" data-aos=\"fade-up\" data-aos-delay=\"100\">\n\n        <div class=\"row gy-4\">\n            \n            <!--<div class=\"col-lg-12 counter-box\">\n                <i class=\"fas fa-users fa-4x text-white\"></i>\n                <div class=\"stats-item\">\n                  <span data-purecounter-start=\"0\" data-purecounter-end=\"232\" data-purecounter-duration=\"0\" class=\"purecounter\">000</span>\n                  <p><?php echo $weblangs->trans(\"volunteer\"); ?></p>\n                </div>\n            </div><!-- End Stats Item -->\n            \n            <?php if (isModEnabled(\'member\')): ?>\n                <div class=\"col-lg-12 counter-box\">\n                    <i class=\"fas fa-user-friends fa-4x text-white\"></i>\n                    <div class=\"stats-item\">\n                      <?php\n                      $sql = \"SELECT COUNT(rowid) as total_members FROM llx_adherent WHERE statut = 1 AND public = 1\";\n                      $resql = $db->query($sql);\n                      $total_members = 0;\n                      if ($resql) {\n                        $obj = $db->fetch_object($resql);\n                        if ($obj) {\n                          $total_members = $obj->total_members;\n                        }\n                      }\n                      ?>\n                      <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_members; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php echo $total_members; ?></span>\n                      <p><?php echo $weblangs->trans(\"member\"); ?></p>\n                    </div>\n                </div><!-- End Stats Item -->\n            <?php endif; ?>\n            \n            <?php if (isModEnabled(\'eventorganization\')): ?>\n            <div class=\"col-lg-12 counter-box\">\n              <i class=\"fas fa-hands-helping fa-4x text-white\"></i>\n              <div class=\"stats-item\">\n              <?php\n                $sql = \"SELECT COUNT(rowid) as total_events FROM \".MAIN_DB_PREFIX.\"projet as p WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1)\";\n              $resql = $db->query($sql);\n              $total_events = 0;\n              if ($resql) {\n                $obj = $db->fetch_object($resql);\n                if ($obj) {\n                $total_events = $obj->total_events;\n                }\n              }\n              ?>\n              <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_events; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php echo $total_events; ?></span>\n              <p><?php echo $weblangs->trans(\"actions\"); ?></p>\n              </div>\n            </div><!-- End Stats Item -->\n            <?php endif; ?>\n\n            <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') && getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>\n                <div class=\"col-lg-12 counter-box\">\n                    <i class=\"fas fa-hands-helping fa-4x text-white\"></i>\n                    <div class=\"stats-item\">\n                      <?php\n                        $sql = \"SELECT count(amount) as count_funds FROM llx_don WHERE paid = 1\";\n                        $resql = $db->query($sql);\n                        $count_funds = 0;\n                        if ($resql) {\n                        $obj = $db->fetch_object($resql);\n                        if ($obj) {\n                          $count_funds = $obj->count_funds;\n                        }\n                        }\n                        ?>\n                        <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $count_funds; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php print $count_funds; ?></span>\n                        <p><?php echo $weblangs->trans(\"Donation\"); ?></p>\n                    </div>\n                </div><!-- End Stats Item -->\n            <?php endif; ?>\n            \n            <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') && getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>\n                <div class=\"col-lg-12 counter-box\">\n                    <i class=\"fas fa-file-invoice-dollar fa-4x text-white\"></i>\n                    <div class=\"stats-item\">\n                      <?php\n                        $sql = \"SELECT SUM(amount) as total_funds FROM llx_don WHERE paid = 1\";\n                        $resql = $db->query($sql);\n                        $total_funds = 0;\n                        if ($resql) {\n                        $obj = $db->fetch_object($resql);\n                        if ($obj) {\n                          $total_funds = $obj->total_funds;\n                        }\n                        }\n                        ?>\n                        <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_funds; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php print intval($total_funds); ?> €</span>\n                        <p><?php echo $weblangs->trans(\"fundsCollected\"); ?></p>\n                    </div>\n                </div><!-- End Stats Item -->\n            <?php endif; ?>\n\n        </div>\n    \n      </div>\n</div>',1,'2025-04-14 10:49:38',NULL,'2025-05-16 12:25:42',NULL,NULL,'banner','en',NULL,'','',NULL,'','',0,NULL,NULL),
(302,43,'index','','Index','','','<?php includeContainer(\'navbar\'); ?>\n\n<?php includeContainer(\'slider\'); ?>\n\n<?php \nincludeContainer(\'overview\');\n?>\n\n<?php includeContainer(\'news\'); ?>\n\n<?php\nif (!getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\') && isModEnabled(\'eventorganization\')) {\n    includeContainer(\'events\'); \n}\n?>\n\n<?php includeContainer(\'contact\'); ?>\n\n<?php includeContainer(\'footer\'); ?>',1,'2025-03-21 15:58:56',NULL,'2025-05-16 12:25:48',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(303,43,'members-list','','members-list','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\nif (!getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')) {\n    redirectToContainer(\'index\');\n}\n\n$data = array();\n$sql = \"SELECT rowid, firstname, lastname, societe, zip, town, email, birth, photo, datec\";\n\n$sqlfields = $sql;\n\n$sql .= \" FROM \".MAIN_DB_PREFIX.\"adherent\";\n$sql .= \" WHERE entity = 1\";\n$sql .= \" AND statut = 1\";\n$sql .= \" AND public = 1\";\n$sql .= $db->order(\"datec\", \"DESC\");\n    \n$resql = $db->query($sql);\nif ($resql) {\n    while ($obj = $db->fetch_object($resql)) {\n        $data[] = array(\n			\'firstname\' => $obj->firstname,\n			\'lastname\' => $obj->lastname,\n			\'societe\' => $obj->societe,\n			\'datec\' => $obj->datec,\n		);\n    }\n}\n/*print \"<pre>\";\nprint_r ($data);\nprint \"</pre>\";*/\ndefine(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"ListOfValidatedPublicMembers\")); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 0;\">\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n\n		\n\n<div class=\"col-md-8\">\n    <div class=\"section-title\">\n      <div class=\"line left-line\"></div>\n      <h1><?php print $weblangs->trans(\"ListOfValidatedPublicMembers\"); ?></h1>\n      <div class=\"line right-line\"></div>\n    </div>\n            \n    <table id=\"membersTable\" class=\"table table-striped\">\n        <thead>\n            <tr>\n                <th>#</th>\n                <th><?php echo $weblangs->trans(\"Firstname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Lastname\"); ?></th>\n                <th><?php echo $weblangs->trans(\"Company\"); ?></th>\n                <th><?php echo $weblangs->trans(\"DateSubscription\"); ?></th>\n            </tr>\n        </thead>\n        <tbody>\n            <?php if (!empty($data) && is_array($data)): ?>\n                <?php foreach ($data as $index => $row): ?>\n                    <tr>\n                        <td><?php echo (int)($index + 1); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'firstname\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'lastname\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo htmlspecialchars($row[\'societe\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>\n                        <td><?php echo dol_print_date($row[\'datec\'], \'daytext\', \'tzuser\', $weblangs); ?></td>\n                    </tr>\n                <?php endforeach; ?>\n            <?php endif; ?>\n        </tbody>\n    </table>\n    <script>\n        $(document).ready(function() {\n            $(\'#membersTable\').DataTable({\n                language: {\n                    url: \"https://cdn.datatables.net/plug-ins/1.13.6/i18n/<?php print str_replace(\'_\', \'-\', $_SESSION[\'lang\'][\'code\']); ?>.json\"\n                }\n            });\n        });\n    </script>\n</div>\n\n\n\n	    <?php includeContainer(\'sidebar\'); ?>\n		\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',1,'2025-04-29 15:02:20',NULL,'2025-05-16 12:27:14',NULL,NULL,'page','',NULL,'','<!-- DataTables CSS/JS -->\n<link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\">\n<script src=\"https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js\"></script>',NULL,'','',0,NULL,NULL),
(304,43,'navbar','','navbar','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n// Get available langs for the website\n$website_langs = getAvailableLangs();\n$available_langs = $website_langs[\'langs\'];\nif (getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\')) {\n    $used_langs = explode(\',\', getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\'));\n    foreach ($available_langs as $key => $value) {\n        if (!in_array($key, $used_langs)) {\n            unset($available_langs[$key]);\n        }\n    }\n}\n\n$langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];\n\n//$weblangs->load(\"website\", \"languages\");\n//$langs->load(\"website\", \"languages\");\n?>\n<div class=\"site-mobile-menu site-navbar-target\">\n  <div class=\"site-mobile-menu-header\">\n    <div class=\"site-mobile-menu-close mt-3\">\n      <span class=\"icon-close2 js-menu-toggle\"></span>\n    </div>\n  </div>\n  <div class=\"site-mobile-menu-body\"></div>\n</div>\n\n<header class=\"site-navbar js-sticky-header js-sticky-header-blog site-navbar-target\" role=\"banner\">\n\n  <div class=\"container\">\n    <div class=\"row align-items-center\">\n      \n      <div class=\"col-6 col-xl-2\">\n        <?php\n            if(getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'USE_TEXT_LOGO\')) {\n                $html_logo = $mysoc->name . \'<span class=\"text-secondary-color\">.</span>\';\n            } else {\n                $path = getImageFileNameForSize($mysoc->logo_squarred ? $mysoc->logo_squarred : $mysoc->logo, \'_small\');\n                $html_logo = \'<img class=\"logo img-responsive-logo img-responsive\" alt=\"\" height=\"42\" src=\"\' . DOL_URL_ROOT . \'/viewimage.php?modulepart=mycompany&file=\'.urlencode(\'logos/\'.$path).\'\">\'; \n            }\n          \n            \n        ?>\n        <h1 class=\"mb-0 site-logo\"><a href=\"/index\"><?php print $html_logo; ?> </a></h1>\n      </div>\n\n      <div class=\"col-12 col-md-10 d-none d-xl-block\">\n        <nav class=\"site-navigation position-relative text-right\" role=\"navigation\">\n\n        <ul class=\"site-menu main-menu js-clone-nav mr-auto d-none d-lg-block\" style=\"float: right;\">\n            <li class=\"has-children\">\n                <a class=\"nav-link\"><?php echo $weblangs->trans(\"presentation\"); ?></a>\n                <ul class=\"dropdown\">\n                    <li><a href=\"/index#section-overview\" class=\"nav-link\"><?php echo $weblangs->trans(\"missionVision\"); ?></a></li>\n                    <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')): ?>\n                        <li><a href=\"members-list.php\" class=\"nav-link\"><?php echo $weblangs->trans(\"directory\"); ?></a></li>\n                    <?php endif; ?>\n                </ul>\n            </li>\n            <li class=\"has-children\">\n                <a class=\"nav-link\"><?php echo $weblangs->trans(\"newsEvents\"); ?></a>\n                <ul class=\"dropdown\">\n                    <li><a href=\"index#section-news\" class=\"nav-link\"><?php echo $weblangs->trans(\"news\"); ?></a></li>\n                    <?php if (isModEnabled(\'eventorganization\') && !getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')): ?>\n                        <li><a href=\"index#section-events\" class=\"nav-link\"><?php echo $weblangs->trans(\"actionsEvents\"); ?></a></li>\n                    <?php endif; ?>\n                </ul>\n            </li>\n            <li class=\"has-children\">\n                <a class=\"nav-link\"><?php echo $weblangs->trans(\"commitmentSupport\"); ?></a>\n                <ul class=\"dropdown\">\n                    <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                        <li><a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"nav-link\"><?php echo $weblangs->trans(\"becomeMember\"); ?></a></li>\n                    <?php endif; ?>\n                    \n                    <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\')): ?>\n                        <li><a href=\"<?php print $socInfo[\'link_donation\']; ?>\" target=\"new\" class=\"nav-link\"><?php echo $weblangs->trans(\"makeDonation\"); ?></a></li>\n                        <?php if (getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>\n                            <li><a href=\"donation-list.php\" class=\"nav-link\"><?php echo $weblangs->trans(\"listOfPublicDonations\"); ?></a></li>\n                        <?php endif; ?>\n                    <?php endif; ?>\n                </ul>\n            </li>\n            <li>\n                <a href=\"index#section-contact\" class=\"nav-link\"><?php echo $weblangs->trans(\"contact\"); ?></a>\n            </li>\n            \n            <?php if (isModEnabled(\'webportal\') && getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')): ?>\n              <?php\n              if (getDolGlobalString(\'WEBPORTAL_ROOT_URL\')) {\n                $url = getDolGlobalString(\'WEBPORTAL_ROOT_URL\');\n              } else {\n                if (isModEnabled(\'multicompany\')) {\n                  $entity_qr = \'?entity=\' . ((int) $conf->entity);\n                } else {\n                  $entity_qr = \'\';\n                }\n\n                $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));\n                $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;\n                $url = $urlwithroot . \'/public/webportal/index.php\' . $entity_qr;\n              }\n              ?>\n              <li>\n                <a href=\"<?php echo $url; ?>\" target=\"new\" class=\"nav-link\"><i class=\"fa-solid fa-user\"></i> <?php echo $weblangs->trans(\"memberArea\"); ?></a>\n              </li>\n            <?php endif; ?>\n            \n            <?php\n                $socialIcons = [\n                  \'facebook\' => \'fa-facebook-f\',\n                  \'twitter\' => \'fa-x-twitter\',\n                  \'linkedin\' => \'fa-linkedin-in\',\n                  \'instagram\' => \'fa-instagram\',\n                  \'youtube\' => \'fa-youtube\',\n                  \'skype\' => \'fa-skype\',\n                  \'whatsapp\' => \'fa-whatsapp\',\n                  \'snapchat\' => \'fa-snapchat-ghost\',\n                ];\n    \n                foreach ($socialIcons as $key => $icon) {\n                  if (!empty($socInfo[$key])) {\n                    echo \'<li class=\"social\"><a href=\"\' . htmlspecialchars($socInfo[$key]) . \'\" target=\"_blank\" class=\"nav-link\"><i class=\"fa-brands \' . $icon . \'\"></i></a></li>\';\n                  }\n                }\n            ?>\n            \n            <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_LANG_SELECTOR\')): ?>\n            <li class=\"has-children\">\n                <a href=\"#language-section\" class=\"nav-link\"><?php print trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$_SESSION[\'lang\'][\'shortcode\']]))[0]); ?></a>\n                <!--<a href=\"#language-section\" class=\"nav-link\"><?php print $_SESSION[\'lang\'][\'shortcode\']; ?></a>-->\n                <ul class=\"dropdown lang-menu\">\n                    <?php if (count($available_langs) > 1): ?>\n                        <?php foreach ($available_langs as $key => $value) : ?>\n                            <?php $value = trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$key]))[0]); ?>\n                            <?php if ($key != $_SESSION[\'lang\'][\'shortcode\']): ?>\n                        		<li>\n                                  <form id=\"languageForm-<?php print $key; ?>\" method=\"post\" action=\"#\">\n                                    <input type=\"hidden\" name=\"l\" value=\"<?php print $key; ?>\">\n                                    <a href=\"#\" class=\"nav-link\" title=\"<?php print $langs->trans(\"Language_\".$langs_code_shortcode[$key]); ?>\" onclick=\"\n                                           const form = document.getElementById(\'languageForm-<?php print $key; ?>\');\n                                           const parser = document.createElement(\'a\');\n                                           parser.href = form.action || window.location.href;\n                                           const params = new URLSearchParams(parser.search);\n                                           params.delete(\'l\');\n                                           parser.search = params.toString();\n                                           form.action = parser.href;\n                                           form.submit();\n                                           return false;\n                                       \">    \n                                      <?php print $value ; ?>\n                                    </a>\n                                  </form>\n                                </li>\n                        	<?php endif ?>\n                        <?php endforeach ?>\n                    <?php endif ?>\n                </ul>\n            </li>\n            <?php endif; ?>\n            \n        </ul>\n        </nav>\n      </div>\n\n\n      <div class=\"col-6 d-inline-block d-xl-none ml-md-0 py-3\" style=\"position: relative; top: 3px;\">\n        <a href=\"#\" class=\"site-menu-toggle js-menu-toggle float-right\">\n            <i class=\"fas fa-bars\"></i>\n        </a>\n      </div>\n\n    </div>\n  </div>\n  \n</header>',1,'2025-04-08 14:20:56',NULL,'2025-05-16 12:26:37',NULL,NULL,'menu','',NULL,'','',NULL,'','',0,NULL,NULL),
(305,43,'news','','news','','','<div class=\"container-fluid causes\">\n    <div class=\"container py-5\">\n        <div class=\"section-title\" id=\"section-news\" style=\"scroll-margin-top: 100px;\">\n          <div class=\"line left-line\"></div>\n          <h1><?php echo $weblangs->trans(\"news\"); ?></h1>\n          <div class=\"line right-line\"></div>\n        </div>\n        <div class=\"row g-4\">\n        <?php \n        $MAXNEWS = GETPOSTINT(\'maxnews\') ? GETPOSTINT(\'maxnews\') : 3;\n        $allblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 0, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n        $countofblogs = count($allblogs);\n        $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', $MAXNEWS, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n        $i=1;\n        foreach($arrayofblogs as $blog)\n        {\n        ?>\n            <div class=\"col-lg-6 col-xl-4 blog-item\" id=\"blog-<?php echo $i; ?>\">\n                <div class=\"causes-item\">\n                    <div class=\"causes-img\">\n                        <?php\n                            $urlforimage = getImageFromHtmlContent($blog->content);\n                            if (empty($urlforimage)) {\n                                $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                            }\n                        ?>\n                        <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                    </div>\n                    <div class=\"progress progress-news\">\n                      <div class=\"progress-bar\" role=\"progressbar\" style=\"width: 100%;\" aria-valuenow=\"100\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                      </div>\n                    </div>\n                    <div class=\"causes-content p-4\">\n                        <span class=\"text-body\">\n                            <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($blog->date_creation, \'daytext\', \'tzuser\', $weblangs); ?>\n                            <span class=\"author-span\"><i class=\"fas fa-user me-2\"></i> <?php echo ($blog->author_alias ? $blog->author_alias : \'anonymous\'); ?></span>\n                        </span>\n                        <h4 class=\"py-3\"><?php echo $blog->title; ?></h4>\n                        <hr>\n                        <p class=\"mb-4 truncate3\"><?php echo $blog->description; ?></p>\n                        <a href=\"page.php?ref=<?php print $blog->pageurl; ?>&blog=<?php print $blog->id; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                    </div>\n                </div>\n            </div>\n            <?php \n            $i++;\n        }\n        ?>\n        </div>\n        \n        <?php if ($MAXNEWS <= $countofblogs) { ?>\n            <div class=\"row\">\n                <div class=\"col-lg-7 text-center py-5 section-title\">\n                    <div class=\"line left-line left-gradient\"></div>\n                    <a href=\"javascript:void(0);\" class=\"btn flat-button text-white bgmaincolor\" id=\"loadMoreNewsBtn\"><?php echo $weblangs->trans(\"loadMore\"); ?>...</a>\n                    <div class=\"line right-line right-gradient\"></div>\n                </div>\n            </div>\n        <?php } ?>\n        <script>\n            document.getElementById(\'loadMoreNewsBtn\').addEventListener(\'click\', function() {\n            const currentUrl = new URL(window.location.href);\n            const maxNewsParam = <?php echo $MAXNEWS; ?>;\n            const newMaxNews = parseInt(maxNewsParam) + 3;\n            currentUrl.searchParams.set(\'maxnews\', newMaxNews);\n            currentUrl.hash = \'#blog-\' + (parseInt(maxNewsParam) + 1).toString();\n            window.location.href = currentUrl.toString();\n            });\n        </script>\n            \n            \n    </div>\n</div>',1,'2025-04-14 14:16:15',NULL,'2025-05-16 12:25:57',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(306,43,'our-company-is-now-on-dolibarr-erp-crm','','Our company is now on Dolibarr ERP CRM','Like several thousands of companies, our company (DMNA) has moved all its information system to Dolibarr ERP CRM. More than 20 applications have been replaced by only one.','','<article>\n    <div id=\"article\" contenteditable=\"true\">\n        Like several thousands of companies, our company (<?php echo $mysoc->name ?>) has moved all its information system to <a href=\"https://www.dolibarr.org\">Dolibarr ERP CRM</a>. More than 20 applications have been replaced by only one, easier to use and fully integrated.\n        This is an important step in improving all of our services.\n        \n        <br><br><br>\n        \n        <figure>\n        <img src=\"/viewimage.php?modulepart=medias&file=image/exemple/background_dolibarr.webp\">\n        <br><br>\n        <figcaption style=\"opacity: 0.5; text-align: center;\">Screenshot of our new Open Source solution</figcaption>\n        </figure>\n    </div>\n</article>',1,'2025-04-14 15:39:29',NULL,'2025-05-07 08:24:39',NULL,NULL,'blogpost','',NULL,'','',NULL,'','',0,NULL,NULL),
(307,43,'our-new-web-site-has-been-launched','','Our new web site has been launched','Now it is modern and directly integrated with the internal management tools of the company. Many new online services will be available for our customers','','<article>\n    <div id=\"article\" contenteditable=\"true\">\n            Our new website, based on Dolibarr CMS, has been launched. <br>\n            Now it is modern and directly integrated with the internal management tools of the company. Many new online services will be available for our customers...\n            <br><br>\n            <figure>\n            <img src=\"/viewimage.php?modulepart=medias&file=image/test6/5.jpg\">\n            <br><br>\n            <figcaption style=\"opacity: 0.5; text-align: center;\">Theme of our new web site</figcaption>\n            </figure>\n    </div>\n</article>',1,'2025-04-08 14:18:29',NULL,'2025-05-07 08:25:04',NULL,NULL,'blogpost','',NULL,'','',NULL,'','',0,NULL,NULL),
(308,43,'overview','','overview','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n?>\n<div class=\"container-fluid volunteer\">\n    <div class=\"container py-5\">\n\n        <div class=\"row g-5\">\n            \n            <div class=\"col-lg-9\">\n\n              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">\n                <div class=\"line left-line\"></div>\n                <h1><?php echo $weblangs->trans(\"missionVision\"); ?></h1>\n                <div class=\"line right-line\"></div>\n              </div>\n            \n              <p class=\"mb-4\">\n                <?php echo $weblangs->trans(\"missionVisionDesc\"); ?>\n              </p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> <?php echo $weblangs->trans(\"SampleGoalOne\"); ?></p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> <?php echo $weblangs->trans(\"SampleGoaltwo\"); ?></p>\n              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> <?php echo $weblangs->trans(\"SampleGoalthree\"); ?></p>\n              \n                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>\n                <?php endif; ?>\n            </div>\n\n            \n            <?php includeContainer(\'highlights\'); ?>\n        </div>\n    </div>\n</div>',1,'2025-04-08 14:30:11',NULL,'2025-05-16 12:26:04',NULL,NULL,'banner','en',NULL,'','',NULL,'','',0,NULL,NULL),
(309,43,'page','','page','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$pageId = GETPOSTINT(\'blog\');\n$eventId = GETPOSTINT(\'id\');\n$donationForId = GETPOSTINT(\'donation\');\n\nif ((!$pageId && !$eventId && !$donationForId) || ($pageId && $eventId)) {\n    redirectToContainer(\'index\');\n}\n\n$showEventGoalRaised = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {\n    $showEventGoalRaised = 1;\n}\n\n$showDonationLink = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {\n    $showDonationLink = 1;\n}\n\n$showParticipateLink = 0;\nif (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {\n    $showParticipateLink = 1;\n}\n\n$data = array();\nif ($pageId) {\n    $type = \"blogpage\";\n    $blog = $websitepage->fetch($pageId);\n    if ($blog < 0) {\n        redirectToContainer(\'index\');\n    } else {\n        $data[\'date_creation\'] = $websitepage->date_creation;\n        $data[\'author_alias\'] = ($websitepage->author_alias ? $websitepage->author_alias : \'\');\n        $data[\'title\'] = $websitepage->title;\n        $data[\'content\'] = $websitepage->content;\n        $data[\'budget_amount\'] = 0;\n        $data[\'collected\'] = 0;\n        $data[\'type\'] = $type;\n    }\n}\n\nif ($eventId) {\n    if (!isModEnabled(\'eventorganization\') || getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')) {\n        redirectToContainer(\'index\');\n    }\n    $type = \"eventpage\";\n    \n    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n        FROM \".MAIN_DB_PREFIX.\"projet as p \n        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $eventId;\n        \n    $resql = $db->query($sql);\n    if ($resql) {\n        $obj = $db->fetch_object($resql);\n        $collected = 0;\n        if ($obj->budget_amount > 0) {\n            $sqlCollected = \"SELECT SUM(amount) as total_collected \n                             FROM \".MAIN_DB_PREFIX.\"don \n                             WHERE fk_projet = \".$obj->rowid;\n            $resqlCollected = $db->query($sqlCollected);\n            \n            if ($resqlCollected) {\n                $objCollected = $db->fetch_object($resqlCollected);\n                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n            }\n        }\n        \n        $data[\'date_creation\'] = $obj->datec;\n        $data[\'author_alias\'] = \"\";\n        $data[\'title\'] = $obj->title;\n        $data[\'content\'] = $obj->description;\n        $data[\'budget_amount\'] = $obj->budget_amount;\n        $data[\'collected\'] = $collected;\n        $data[\'type\'] = $type;\n       \n    } else {\n        redirectToContainer(\'index\');\n    }\n}\n\nif ($donationForId) {\n    $type = \"donationpage\";\n    \n    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n        FROM \".MAIN_DB_PREFIX.\"projet as p \n        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $donationForId;\n        \n    $resql = $db->query($sql);\n    if ($resql) {\n        $obj = $db->fetch_object($resql);\n        $collected = 0;\n        if ($obj->budget_amount > 0) {\n            $sqlCollected = \"SELECT SUM(amount) as total_collected \n                             FROM \".MAIN_DB_PREFIX.\"don \n                             WHERE fk_projet = \".$obj->rowid;\n            $resqlCollected = $db->query($sqlCollected);\n            \n            if ($resqlCollected) {\n                $objCollected = $db->fetch_object($resqlCollected);\n                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n            }\n        }\n        \n        $data[\'date_creation\'] = $obj->datec;\n        $data[\'author_alias\'] = \"\";\n        $data[\'title\'] = $obj->title;\n        $data[\'content\'] = \'<div id=\"iframe-container\"><iframe id=\"donationFrame\" frameborder=\"0\" style=\"overflow:hidden;width:100%;height:100%;\" src=\"\' . $socInfo[\'link_donation\'] . \'?project_id=\' . urlencode($donationForId) . \'&ws=\' . urlencode($website->id) . \'\"\n></iframe></div>\';\n        $data[\'budget_amount\'] = $obj->budget_amount;\n        $data[\'collected\'] = $collected;\n        $data[\'type\'] = $type;\n       \n    } else {\n        redirectToContainer(\'index\');\n    }\n}\n\n/*print \"<pre>\";\nprint_r ($data);\nprint \"</pre>\";*/\ndefine(\"__SEO_PAGE_TITLE__\", $data[\'title\']); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 190px;\">\n    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 190px;\">\n        <div class=\"col-lg-12 text-center breadcrumb-box\">\n            \n            <ol class=\"breadcrumb justify-content-center mb-3 lead\">\n				<li class=\"breadcrumb-item\"><a href=\"/\" class=\"text-decoration-none\"><?php echo $weblangs->trans(\"home\"); ?></a></li>\n				<li class=\"breadcrumb-item\">\n				    <a href=\"/events\" class=\"text-decoration-none\">\n				        <?php echo $weblangs->trans($data[\'type\'] === \"blogpage\" ? \"news\" : \"actionsEvents\"); ?>\n				    </a>\n				</li>\n			</ol>\n			\n            <h1 class=\"mb-3\"><?php print $data[\'title\']; ?></h1>\n            <span>\n                <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($data[\'date_creation\'], \'daytext\', \'tzuser\', $weblangs); ?>\n                \n                <?php if ($data[\'type\'] == \"blogpage\") { ?>\n                    <span class=\"author-span ms-3\"><i class=\"fas fa-user me-2\"></i> \n                        <?php \n                            if ($data[\'author_alias\']) { \n                                echo $data[\'author_alias\']; \n                            } else { \n                                echo $weblangs->trans(\"anonymous\");\n                            } \n                        ?> \n                    </span>\n                <?php } ?>\n                \n                <?php if ($data[\'budget_amount\'] && $showEventGoalRaised) { ?>\n                    <span class=\"text-white ms-3\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($data[\'budget_amount\'], \'MT\'), 1, \'\', 1, -1); ?> €</span>\n                <?php } ?>\n                \n                <?php if ($data[\'budget_amount\'] && $showEventGoalRaised) { ?>\n                    <span class=\"text-white ms-3\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($data[\'collected\'], \'MT\'), 1, \'\', 1, -1); ?> €</span>\n                <?php } ?>\n            </span>\n        </div>\n    </div>\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n  \n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n\n		<div class=\"<?php echo $data[\'type\'] === \'donationpage\' ? \'col-md-12\' : \'col-md-8\'; ?>\" style=\"min-height:1200px;\">\n			<article id=\"content\">\n				<?php print html_entity_decode($data[\'content\']); ?>\n			</article>\n		</div>\n		\n		<?php if ($data[\'type\'] !== \"donationpage\") { ?>\n		    <?php includeContainer(\'sidebar\'); ?>\n		<?php } ?>\n		\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',1,'2025-04-16 10:10:24',NULL,'2025-05-16 12:27:25',NULL,NULL,'page','',NULL,'','',NULL,'','',0,NULL,NULL),
(310,43,'rgpd','','rgpd','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n\ndefine(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"RGPD\")); \n?>\n    \n<?php includeContainer(\'navbar\'); ?>\n\n<div class=\"js-sticky-header-blog\"></div>\n\n<section class=\"slogan has-section-divider\" style=\"min-height: 190px;\">\n    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 190px;\">\n        <div class=\"col-lg-12 text-center breadcrumb-box\">\n            \n            <ol class=\"breadcrumb justify-content-center mb-3 lead\">\n				<li class=\"breadcrumb-item\"><a href=\"/\" class=\"text-decoration-none\"><?php echo $weblangs->trans(\"home\"); ?></a></li>\n				<li class=\"breadcrumb-item\">\n				    <a href=\"/events\" class=\"text-decoration-none\">\n				        <?php echo $weblangs->trans(\"RGPD\"); ?>\n				    </a>\n				</li>\n			</ol>\n			\n            <h1 class=\"mb-3\"><?php echo $weblangs->trans(\"RGPD\"); ?></h1>\n        </div>\n    </div>\n    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n  \n</section>\n        \n<div class=\"container mt-5\">\n	<div class=\"row\">\n		<div class=\"col-md-12\" style=\"min-height:1200px;\">\n			<p>\n              We are committed to respecting your privacy and protecting any personal information you choose to share with us.  \n              Your data is handled responsibly, securely, and in accordance with applicable data protection laws.  \n              We believe in transparency, accountability, and safeguarding your rights at every step.\n            </p>\n		</div>\n	</div>\n</div>\n\n<?php includeContainer(\'footer\'); ?>',1,'2025-05-05 13:44:30',NULL,'2025-05-16 12:27:32',NULL,NULL,'page','en',NULL,'','',NULL,'','',0,NULL,NULL),
(311,43,'sidebar','','sidebar','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\nsetSessionLang();\n$socInfo = getSocInfo();\n\n$pageId = GETPOSTINT(\'blog\');\n$eventId = GETPOSTINT(\'id\');\n\n$showDonationLink = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {\n    $showDonationLink = 1;\n}\n\n$showEventGoalRaised = 0;\nif (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {\n    $showEventGoalRaised = 1;\n}\n\n$showParticipateLink = 0;\nif (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {\n    $showParticipateLink = 1;\n}\n\n$link_participation = \'\';\n\nif ($eventId) {\n    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n        FROM \".MAIN_DB_PREFIX.\"projet as p \n        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $eventId;\n        \n    $resql = $db->query($sql);\n    if ($resql) {\n        $obj = $db->fetch_object($resql);\n        $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\');\n        $link_participation = $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey);\n    }\n}\n\n?>\n<div class=\"col-md-4\">\n\n	\n	<div class=\"container-fluid causes sidebar-joinus\">\n        <div class=\"container\">\n            <div class=\"section-title\">\n              <div class=\"line left-line\"></div>\n              <h1><?php echo $weblangs->trans(\"joinUs\"); ?></h1>\n              <div class=\"line right-line\"></div>\n            </div>\n            <div class=\"row g-4\">\n                <?php if ($showDonationLink) { ?>\n                    <?php if ($eventId) { ?>\n                        <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-donate\"></i> <?php echo $weblangs->trans(\"donateNow\"); ?> </a>\n                    <?php } else { ?>\n                        <a href=\"<?php echo $socInfo[\'link_donation\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-donate\"></i> <?php echo $weblangs->trans(\"donateNow\"); ?> </a>\n                    <?php } ?>\n                    \n                <?php } ?>\n                <?php if ($link_participation && $showParticipateLink) { ?>\n                    <a href=\"<?php echo $link_participation; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-user-plus\"></i> <?php echo $weblangs->trans(\"Participate\"); ?> </a>\n                <?php } ?>\n            </div>\n        </div>\n    </div>\n	\n	<div class=\"container-fluid causes\">\n        <div class=\"container py-5\">\n            <div class=\"section-title\">\n              <div class=\"line left-line\"></div>\n              <h1><?php echo $weblangs->trans(\"news\"); ?></h1>\n              <div class=\"line right-line\"></div>\n            </div>\n            <div class=\"row g-4\">\n            <?php \n            $MAXNEWS = 2;\n            $allblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 0, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n            $countofblogs = count($allblogs);\n            $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', $MAXNEWS, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));\n            foreach($arrayofblogs as $blog)\n            {\n            ?>\n                <div class=\"col-12-12\">\n                    <div class=\"causes-item\">\n                        <div class=\"causes-img\">\n                            <?php\n                                $urlforimage = getImageFromHtmlContent($blog->content);\n                                if (empty($urlforimage)) {\n                                    $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                                }\n                            ?>\n                            <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                        </div>\n                        <div class=\"progress progress-news\">\n                          <div class=\"progress-bar\" role=\"progressbar\" style=\"width: 100%;\" aria-valuenow=\"100\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                          </div>\n                        </div>\n                        <div class=\"causes-content p-4\">\n                            <span class=\"text-body\">\n                                <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($blog->date_creation, \'daytext\', \'tzuser\', $weblangs); ?>\n                                <span class=\"author-span\"><i class=\"fas fa-user me-2\"></i> <?php echo ($blog->author_alias ? $blog->author_alias : \'anonymous\'); ?></span>\n                            </span>\n                            <h4 class=\"py-3\"><?php echo $blog->title; ?></h4>\n                            <hr>\n                            <p class=\"mb-4 truncate3\"><?php echo $blog->description; ?></p>\n                            <a href=\"page.php?ref=<?php print $blog->pageurl; ?>&blog=<?php print $blog->id; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                        </div>\n                    </div>\n                </div>\n                <?php \n            }\n            ?>\n            </div>\n                \n        </div>\n    </div>\n    \n    \n    <div class=\"container-fluid causes\">\n        <div class=\"container\">\n            <div class=\"section-title\">\n              <div class=\"line left-line\"></div>\n              <h1><?php echo $weblangs->trans(\"actions\"); ?></h1>\n              <div class=\"line right-line\"></div>\n            </div>\n            <div class=\"row g-4\">\n    \n                <?php \n                $maxevents = 2;\n                $countofevents = 0;\n                $sqlCount = \"SELECT count(p.rowid) as countofevents \n                        FROM \".MAIN_DB_PREFIX.\"projet as p \n                        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                        ORDER BY p.datec DESC \";\n                $resqlCount = $db->query($sqlCount);\n                if ($resqlCount) {\n                    $objCount = $db->fetch_object($resqlCount);\n                    $countofevents = $objCount->countofevents ? $objCount->countofevents : 0;\n                }\n            \n                $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut \n                        FROM \".MAIN_DB_PREFIX.\"projet as p \n                        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) \n                        ORDER BY p.datec DESC \n                        LIMIT \".$maxevents;\n                $resql = $db->query($sql);\n                if ($resql) {\n                    $countofblogs = $db->num_rows($resql);\n                    while ($obj = $db->fetch_object($resql)) {\n                        ?>\n                        <div class=\"col-xs-12\">\n                            <div class=\"causes-item\">\n                                <div class=\"causes-img\">\n                                    <?php\n                                        $urlforimage = getImageFromHtmlContent($obj->description ? $obj->description : \"\");\n                                        if (empty($urlforimage)) {\n                                            $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';\n                                        }\n                                    ?>\n                                    <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">\n                                    <div class=\"causes-link pb-2 px-3\">\n                                        <?php\n                                            $progress = 100;\n                                            if ($obj->budget_amount > 0 && $showEventGoalRaised) {\n                                                $sqlCollected = \"SELECT SUM(amount) as total_collected \n                                                                 FROM \".MAIN_DB_PREFIX.\"don \n                                                                 WHERE fk_projet = \".$obj->rowid;\n                                                $resqlCollected = $db->query($sqlCollected);\n                                                $collected = 0;\n                                                if ($resqlCollected) {\n                                                    $objCollected = $db->fetch_object($resqlCollected);\n                                                    $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;\n                                                }\n                                                $progress = round(($collected / $obj->budget_amount) * 100, 2);\n                                            }\n                                        ?>\n                                        \n                                        <?php if ($showEventGoalRaised) { ?>\n                                            <small class=\"text-white\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($obj->budget_amount, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                            <small class=\"text-white\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($collected, \'MT\'), 1, \'\', 1, -1); ?> €</small>\n                                        <?php } ?>  \n                                    </div>\n                                    <div class=\"causes-dination p-2\">\n                                        <?php if ($showDonationLink) { ?>\n                                            <?php if (getDolGlobalInt(\'WS_\' . strtoupper($website->ref) . \'_PAYMENT_IN_FRAME\')) { ?>\n                                                <a href=\"page.php?donation=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                            <?php } else { ?>\n                                                <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>\n                                            <?php } ?>\n                                        <?php } ?>\n                                        \n                                        <?php if ($showParticipateLink) { ?>\n                                            <?php $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\'); ?>\n                                            <a href=\"<?php echo $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"Participate\"); ?></a>\n                                        <?php } ?>\n\n                                    </div>\n                                </div>\n                                \n                                <div class=\"progress\">\n                                  <div class=\"progress-bar\" role=\"progressbar\" style=\"width: <?php echo $progress; ?>%;\" aria-valuenow=\"<?php echo $progress; ?>\" aria-valuemin=\"0\" aria-valuemax=\"100\">\n                                    <?php if ($showEventGoalRaised) { ?>\n                                    <span><?php echo $progress; ?>%</span>\n                                    <?php } ?>\n                                  </div>\n                                </div>\n                                <div class=\"causes-content p-4\">\n                                    <span class=\"text-body\">\n                                        <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($obj->datec, \'daytext\', \'tzuser\', $weblangs); ?>\n                                    </span>\n                                    <h4 class=\"py-3\"><?php echo $obj->title; ?></h4>\n    \n                                    <a href=\"page.php?id=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>\n                                </div>\n                            </div>\n                        </div>\n                        <?php\n                    }\n                }\n                ?>\n            </div>\n\n        </div>\n    </div>\n	\n</div>',1,'2025-04-16 11:08:11',NULL,'2025-05-16 12:26:11',NULL,NULL,'banner','',NULL,'','',NULL,'','',0,NULL,NULL),
(312,43,'slider','','slider','','','<?php\nincludeContainer(\'_library_lib.php\', 1);\n//setSessionLang();\n$socInfo = getSocInfo();\n?>\n\n<section class=\"slogan has-section-divider\">\n  \n    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 460px;\">\n        <div class=\"col-lg-8 text-center\">\n            <h1 class=\"mb-3\"><?php print $socInfo[\'slogan\']; ?></h1>\n            <p class=\"lead\"><?php print $socInfo[\'description\']; ?></p>\n            <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>\n                <p><a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button\">Devenir Membre</a></p>\n            <?php endif; ?>\n        </div>\n    </div>\n  \n  \n  <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"var(--light-secondary-color)\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>\n  \n</section>',1,'2025-04-08 14:25:00',NULL,'2025-05-16 12:26:45',NULL,NULL,'other','',NULL,'','',NULL,'','',0,NULL,NULL),
(313,43,'_library_lib','','lib','','','<?php\n/**\n * Set session language based on:\n * - Cookie \'lang\' (if exists)\n * - Browser language (if not present among website languages, use website main language)\n * - Form field \'language\' (if present)\n *\n * The function also updates the product labels of the products in the session\n * to match the current language.\n *\n * @return bool\n */\nfunction setSessionLang() {\n   global $langs, $website, $weblangs, $db;\n    // Get available langs for the website\n    $website_langs = getAvailableLangs();\n    $available_langs = $website_langs[\'langs\'];\n    $langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];\n\n    // If no language is set or if a new language is selected (via form field)\n    if (!isset($_COOKIE[\'lang\']) || GETPOST(\'l\', \'alpha\')) {\n        // Get browser language\n        $browser_lang = $weblangs->getDefaultLang(1);\n\n        // Change used lang\n        $new_lang = GETPOST(\'l\', \'alpha\');\n        if ($new_lang && array_key_exists ($new_lang, $available_langs)) {\n            setcookie(\'lang\', $new_lang, time() + (86400 * 30), \'/\');\n            $session_lang = $new_lang;\n        }\n\n        // If no language is set in cookie and browser language is not present among available languages\n        // use website main language as default\n        if (!isset($_COOKIE[\'lang\'])) {\n            if (array_key_exists ($browser_lang, $available_langs)){\n                // The browser language is present among the available languages\n                setcookie(\'lang\', $browser_lang, time() + (86400 * 30), \'/\');\n                $session_lang = $browser_lang;\n            } else {\n                // The browser language is not present among the available languages\n                setcookie(\'lang\', $website->lang, time() + (86400 * 30), \'/\');\n                $session_lang = $website->lang;\n            }\n        }\n\n        // Set session lang\n        if (!empty($session_lang)) {\n            $_SESSION[\'lang\'][\'shortcode\'] = $session_lang;\n            $_SESSION[\'lang\'][\'code\'] = $langs_code_shortcode[$session_lang];\n        }\n\n    }\n\n    // If session language is not set, use cookie language\n    if (empty($_SESSION[\'lang\'][\'shortcode\']) || empty($_SESSION[\'lang\'][\'code\'])) {\n        $_SESSION[\'lang\'][\'shortcode\'] = $_COOKIE[\'lang\'];\n        $_SESSION[\'lang\'][\'code\'] = $langs_code_shortcode[$_COOKIE[\'lang\']];\n    }\n\n    // Set Dolibarr default language\n    $langs->setDefaultLang($_SESSION[\'lang\'][\'code\']);\n    $weblangs->setDefaultLang($_SESSION[\'lang\'][\'code\']);\n    $langs->loadLangs(array(\"main\", \"website\", \"languages\", \"members\", \"admin\", \"donations\", \"companies\"));\n    $weblangs->loadLangs(array(\"main\", \"website\", \"languages\", \"members\", \"admin\", \"donations\", \"companies\"));\n\n    return true;\n}\n\n/**\n * The function loops through the languages of the website configuration and\n * checks if they exist in the list of supported languages. If they do, they\n * are added to the $available_langs array, along with their corresponding\n * shortcode in the $langs_code_shortcode array.\n *\n * The function returns an array with two keys: \'langs\' containing the list\n * of available languages and \'langs_code_shortcode\' containing the list\n * of corresponding shortcodes.\n *\n * @return array\n */\nfunction getAvailableLangs() {\n    global $website, $weblangs;\n\n    $available_langs = array();\n    $langs_code_shortcode = array();\n    $ws_langs_list = explode(\',\', $website->lang.\',\'.$website->otherlang);\n    $dol_available_langs = $weblangs->get_available_languages(DOL_DOCUMENT_ROOT, 1, 2, 1);\n    foreach ($ws_langs_list as $lang) {\n        foreach ($dol_available_langs as $key => $value) {\n            if (strpos($key, $lang) === 0) {\n                $available_langs[$lang] = $value;\n                $langs_code_shortcode[$lang] = $key;\n                break;\n            }\n        }\n    }\n    \n    return array(\'langs\' => $available_langs, \'langs_code_shortcode\' => $langs_code_shortcode);\n}\n\n/**\n * Get societe information from Dolibarr configuration.\n *\n * This function retrieves the societe information from the global $conf object\n * and returns it as an associative array.\n *\n * @return array\n */\nfunction getSocInfo() {\n    global $conf, $mysoc, $weblangs, $website;\n    $weblangs->load(\"admin\");\n\n    $societe_info = array(\n        \'name\' => !empty($mysoc->name) ? html_entity_decode($mysoc->name) : \'\',\n        \'address\' => !empty($mysoc->getFullAddress(1)) ? html_entity_decode($mysoc->getFullAddress(1)) : \'\',\n        \'zip\' => !empty($mysoc->zip) ? html_entity_decode($mysoc->zip) : \'\',\n        \'town\' => !empty($mysoc->town) ? html_entity_decode($mysoc->town) : \'\',\n        \'country\' => !empty($mysoc->country) ? html_entity_decode($mysoc->country) : \'\',\n        \'phone\' => !empty($mysoc->phone) ? html_entity_decode($mysoc->phone) : \'\',\n        \'fax\' => !empty($mysoc->fax) ? html_entity_decode($mysoc->fax) : \'\',\n        \'email\' => !empty($mysoc->email) ? html_entity_decode($mysoc->email) : \'\',\n        \'slogan\' => getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\') \n                ? html_entity_decode(getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\')) \n                : (!empty($mysoc->name) \n                    ? html_entity_decode($mysoc->name) \n                    : html_entity_decode($weblangs->trans(\"noCompanyInfoSlogan\"))),\n        \'description\' => getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\') \n                ? html_entity_decode(getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\')) \n                : (!empty($mysoc->socialobject) \n                    ? html_entity_decode($mysoc->socialobject) \n                    : html_entity_decode($weblangs->trans(\"noCompanyInfoDescription\", $weblangs->trans(\"CompanyObject\"))))\n    );\n\n    // Add social networks if they are set\n    foreach($mysoc->socialnetworks as $key => $value) {\n        if (!empty($value)) {\n            $societe_info[$key] = preg_match(\'/^http/\', $value) ? $value : \'https://www.\'.$key.\'.com/\'.$value;\n        }\n    }\n    \n    // Add link to subscription\n    if (isModEnabled(\'multicompany\')) {\n      $entity_qr = \'?entity=\' . ((int) $conf->entity);\n    } else {\n      $entity_qr = \'\';\n    }\n    $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));\n    $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;\n    $societe_info[\'subscription_link\'] = $urlwithroot . \'/public/members/new.php\'.$entity_qr;\n    \n    // Add participation link\n    $link_participation = $urlwithroot.\'/public/eventorganization/attendee_new.php?type=global\';\n	$societe_info[\'link_participation\'] = $link_participation;\n	\n	// Add donation link\n    $link_donation = $urlwithroot.\'/public/donations/new.php\';\n	$societe_info[\'link_donation\'] = $link_donation;\n\n    return $societe_info;\n}',1,'2025-04-11 10:57:25',NULL,'2025-05-16 12:26:30',NULL,NULL,'library','',NULL,'','',NULL,'','',0,NULL,NULL);

--
-- Table structure for table `llx_workstation_workstation`
--

CREATE TABLE `llx_workstation_workstation` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) NOT NULL DEFAULT '(PROV)',
  `label` varchar(255) DEFAULT NULL,
  `type` varchar(7) DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `entity` int(11) DEFAULT 1,
  `note_private` text DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `status` smallint(6) NOT NULL,
  `nb_operators_required` int(11) DEFAULT NULL,
  `thm_operator_estimated` double DEFAULT NULL,
  `thm_machine_estimated` double DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_workstation_workstation_rowid` (`rowid`),
  KEY `idx_workstation_workstation_ref` (`ref`),
  KEY `fk_workstation_workstation_fk_user_creat` (`fk_user_creat`),
  KEY `idx_workstation_workstation_status` (`status`),
  CONSTRAINT `fk_workstation_workstation_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `llx_workstation_workstation`
--

INSERT INTO `llx_workstation_workstation` VALUES
(1,'WKSTATION-0001','Workshop 1','HUMAN',NULL,1,NULL,'2023-08-13 15:45:44','2024-12-13 16:37:18',12,12,NULL,0,NULL,10,22),
(2,'WKSTATION-0002','Workshop 2','HUMAN',NULL,1,NULL,'2023-08-13 15:46:02','2024-12-13 16:37:11',12,12,NULL,1,2,11,12),
(3,'WKSTATION-0003','Workshop 3','BOTH',NULL,1,NULL,'2023-08-13 15:46:34','2023-08-13 15:46:34',12,NULL,NULL,1,3,NULL,NULL);

--
-- Table structure for table `llx_workstation_workstation_resource`
--

CREATE TABLE `llx_workstation_workstation_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_resource` int(11) DEFAULT NULL,
  `fk_workstation` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `llx_workstation_workstation_resource`
--

INSERT INTO `llx_workstation_workstation_resource` VALUES
(1,'2023-08-13 15:46:34',1,3),
(2,'2023-08-13 15:46:34',4,3);

--
-- Table structure for table `llx_workstation_workstation_usergroup`
--

CREATE TABLE `llx_workstation_workstation_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_usergroup` int(11) DEFAULT NULL,
  `fk_workstation` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `llx_workstation_workstation_usergroup`
--


--
-- Table structure for table `llx_zapier_hook`
--

CREATE TABLE `llx_zapier_hook` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `url` varchar(255) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `module` varchar(128) DEFAULT NULL,
  `action` varchar(128) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `fk_user` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `llx_zapier_hook`
--



