name = acym_getVar('string', 'list_name', '');
$listToAdd->color = '#'.substr(str_shuffle('ABCDEF0123456789'), 0, 6);
$listToAdd->visible = 1;
$listToAdd->active = 1;
$selectedListsIds[] = $listClass->save($listToAdd);
$entityHelper = new EntitySelectHelper();
$importHelper = new ImportHelper();
$entityHelper->entitySelect(
[
'display' => true,
'entity' => 'list',
'entityParams' => ['join' => 'join_lists-'.implode(',', $selectedListsIds)],
'columnsToDisplay' => $entityHelper->getColumnsForList('lists.list_id', true),
'additionalData' => $importHelper->additionalDataUsersImport($genericImport),
]
);
exit;
}
public function usersSummary(): void
{
$id = acym_getVar('int', 'list_id', 0);
$offset = acym_getVar('int', 'offset', 0);
$limit = acym_getVar('int', 'limit', 50);
$search = acym_getVar('string', 'modal_search', '');
if (empty($id)) {
acym_sendAjaxResponse(acym_translation('ACYM_COULD_NOT_RETRIEVE_DATA'), [], false);
}
$listClass = new ListClass();
if (!$listClass->hasUserAccess($id)) {
acym_sendAjaxResponse(acym_translation('ACYM_UNAUTHORIZED_ACCESS'), [], false);
}
acym_sendAjaxResponse('', ['users' => $listClass->getUsersForSummaryModal($id, $offset, $limit, $search)]);
}
public function setAjaxListing(): void
{
$showSelected = acym_getVar('string', 'show_selected');
$matchingListsData = new \stdClass();
$matchingListsData->ordering = 'name';
$matchingListsData->searchFilter = acym_getVar('string', 'search_lists');
$matchingListsData->listsPerPage = acym_getVar('int', 'listsPerPage', 20);
$matchingListsData->idsSelected = json_decode(acym_getVar('string', 'selectedLists'));
$matchingListsData->idsAlready = json_decode(acym_getVar('string', 'alreadyLists'));
$matchingListsData->page = acym_getVar('int', 'pagination_page_ajax');
if (empty($matchingListsData->page)) {
$matchingListsData->page = 1;
}
$matchingListsData->needDisplaySub = acym_getVar('int', 'needDisplaySub');
$matchingListsData->displayNonActive = acym_getVar('int', 'nonActive');
$params = [
'ordering' => $matchingListsData->ordering,
'search' => $matchingListsData->searchFilter,
'listsPerPage' => $matchingListsData->listsPerPage,
'offset' => ($matchingListsData->page - 1) * $matchingListsData->listsPerPage,
'already' => $matchingListsData->idsAlready,
];
if ($showSelected == 'true') {
$params['ids'] = $matchingListsData->idsSelected;
}
$listClass = new ListClass();
$lists = $listClass->getListsWithIdNameCount($params);
$return = '';
if (empty($lists['lists'])) {
$return .= ''.acym_translation('ACYM_NO_RESULTS_FOUND').'
';
}
foreach ($lists['lists'] as $list) {
if (!empty($matchingListsData->displayNonActive) && $list->active == 0) continue;
$return .= '';
}
$pagination = new PaginationHelper();
$pagination->setStatus($lists['total'], $matchingListsData->page, $matchingListsData->listsPerPage);
$return .= $pagination->displayAjax();
acym_sendAjaxResponse('', ['paginationListing' => $return]);
}
public function loadMoreSubscribers(): void
{
wp_verify_nonce(acym_getVar('cmd', '_wpnonce'), 'acymnonce') || die('Invalid Token');
$listClass = new ListClass();
$listId = acym_getVar('int', 'listId');
if (!acym_isAdmin()) {
$manageableLists = $listClass->getManageableLists();
if (!in_array($listId, $manageableLists)) {
die('Access denied for this list');
}
}
$offset = acym_getVar('int', 'offset');
$perCalls = acym_getVar('int', 'perCalls');
$status = acym_getVar('int', 'status');
$orderBy = acym_getVar('string', 'orderBy', 'id');
$orderingSortOrder = acym_getVar('string', 'orderByOrdering', 'desc');
$subscribers = $listClass->getSubscribersForList(
[
'listIds' => [$listId],
'offset' => $offset,
'limit' => $perCalls,
'status' => $status,
'orderBy' => $orderBy,
'orderBySort' => $orderingSortOrder,
]
);
foreach ($subscribers as &$oneSub) {
if ($oneSub->subscription_date == '0000-00-00 00:00:00') continue;
$oneSub->subscription_date = acym_date(strtotime($oneSub->subscription_date), acym_translation('ACYM_DATE_FORMAT_LC2'));
}
acym_sendAjaxResponse('', ['subscribers' => $subscribers]);
}
public function loadMostUsedLists(): void
{
$listClass = new ListClass();
if ($this->config->get('dashboard_last_update', 0) + 86400 < time()) {
$usersByList = $listClass->getListsSubscribersAndUnsubscribeUsersFromUserHasList();
foreach ($usersByList as $list) {
$subscriberEvolution = current($listClass->getSubscribersEvolutionByListIds([$list->list_id]));
$listClass->updateListsSubscribersAndUnsubscribeUsers(
$list->list_id,
$list->subscribers,
$list->unsubscribed_users,
$subscriberEvolution->newSub ?? 0,
$subscriberEvolution->newUnsub ?? 0
);
}
$this->config->saveConfig(['dashboard_last_update' => time()]);
}
$mostUsedList = $listClass->getMostUsedLists();
$ids = array_map(fn($obj) => $obj->list_id, $mostUsedList);
$listAndSubscribersData = $listClass->getMostUsedListsByIdsWithSubscribersData($ids);
acym_sendAjaxResponse('', ['listAndSubscribersData' => $listAndSubscribersData]);
}
}