X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=428a6be1e112d9a70f0f98d2f62f7a9741923763;hp=afe6ac45435ce9d4bc8154585a0ce97c145bc384;hb=6f9f29d5caee60a2cceae33a7a53e1b4c7319a0c;hpb=0369c36aaab5af6ed44da1e13a53baef285f79b4 diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php index afe6ac4543..428a6be1e1 100644 --- a/inc/modules/admin/what-email_details.php +++ b/inc/modules/admin/what-email_details.php @@ -1,7 +1,7 @@ 0) -{ - // Mail orders are in pool so we can display them - OUTPUT_HTML("
- - - -"); - - // Add navigation (with change box and colspan=3) - if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], false, "3"); +if (!SQL_HASZERONUMS($result_list)) { + // Init rows + $OUT = ''; - while ($pool = SQL_FETCHROW($result_list)) - { + // Walk through all entries + while ($content = SQL_FETCHARRAY($result_list)) { // Unconfirmed mails and sent mails - $result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%s LIMIT 1", - array(bigintval($pool[0])), __FILE__, __LINE__); - list($sent, $clicks) = SQL_FETCHROW($result_uncon); + $result_uncon = SQL_QUERY_ESC("SELECT (`max_rec` - `clicks`) AS `unconfirmed` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1", + array(bigintval($content['id'])), __FILE__, __LINE__); + + // Load and merge data + $content = merge_array($content, SQL_FETCHARRAY($result_uncon)); + + // Free result SQL_FREERESULT($result_uncon); // Unconfirmed mails - $unconfirmed = $sent - $clicks; - if ($unconfirmed > 0) - { - // Add link to list_unconfirmed what-file - $unconfirmed = "".$unconfirmed.""; - } - elseif ($unconfirmed < 0) - { - // Sometimes rarely displayed minus values will be "fixed" to zero - $unconfirmed = 0; - } - - // List mail - OUTPUT_HTML(" - - - - - - - - - - - - - - - - - - - - - - - -"); - } + $content['unconfirmed'] = generateUnconfirmedAdminLink($content['id'], ($content['unconfirmed']), 'mid'); + + // Prepare content + $content['timestamp'] = generateDateTime($content['timestamp'], 0); + + // Load row template + $OUT .= loadTemplate('admin_list_emails_row', true, $content); + } // END - while // Free memory SQL_FREERESULT($result_list); - // Add navigation (without change box but with colspan=3) - if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], false, "3"); + // Add navigation (with change box and colspan=3) + $content['nav'] = addEmailNavigation($numPages, getMailsPage(), false, 3, true); + + // Prepare content + $content['rows'] = $OUT; + $content['who'] = $WHO; + + // Mail orders are in pool so we can display them + loadTemplate('admin_list_emails', false, $content); - // Output footer - OUTPUT_HTML("
- ".ADMIN_POOL_CONTENT." (".$WHO.") -
- ".EMAIL_SENDER.":
- ".ADMIN_USER_PROFILE_LINK($pool[1])." - 		- ".EMAIL_SUBJECT.":
- ".COMPILE_CODE($pool[2])." - 		- ".EMAIL_TEXT.":
- ".COMPILE_CODE($pool[3])." -
- ".EMAIL_PAYMENT.":
- ".GET_PAYMENT($pool[5])." - 		- ".EMAIL_CATEGORY.":
- ".GET_CATEGORY($pool[10])." -
- ".EMAIL_RECEIVERS.":
- ".$sent." (".EMAIL_RUIDS.": ".str_replace(";", ", ", $pool[4]).") - 		- ".USERS_LINKS.":
- ".$unconfirmed." - 		- ".EMAIL_POOL_TYPE.":
- ".GET_POOL_TYPE($pool[6])." -
- ".EMAIL_TSEND.":
- ".$pool[9]." - 		- ".EMAIL_URL.":
- ".ADMIN_TEST_URL." - 		- ".EMAIL_TIMESTAMP.":
- ".MAKE_DATETIME($pool[7], "0")." -
- ".ADMIN_DELETE_NORMAL_MAIL." -
-
"); $MAIL = true; - if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL)) - { - // Check only if bonus extension is active - if (SQL_NUMROWS($result_bonus) > 0) OUTPUT_HTML("

"); - } -} + if ((isExtensionActive('bonus')) && (empty($WHO))) { + // Only check if bonus extension is active + if (!SQL_HASZERONUMS($result_bonus)) outputHtml('

'); + } // END - if +} // END - if -if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL)) -{ +if ((isExtensionActive('bonus')) && (empty($WHO))) { // Load bonus mails only when extension is active - if (SQL_NUMROWS($result_bonus) > 0) - { - // Mail orders are in pool so we can display them - OUTPUT_HTML("
- - - -"); + if (!SQL_HASZERONUMS($result_bonus)) { // Calculate pages - $PAGES = round(SQL_NUMROWS($result_bonus) / $_CONFIG['mails_page'] + 0.5); - - // Add navigation (with change box and colspan=3) - if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], true, "3"); + $numPages = round(SQL_NUMROWS($result_bonus) / getMailsPage() + 0.5); // List emails - while ($bonus = SQL_FETCHROW($result_bonus)) - { - // Unconfirmed mails - $unconfirmed = $bonus[11] - $bonus[12]; - if ($unconfirmed > 0) - { - // Add link to list_unconfirmed what-file - $unconfirmed = "".$unconfirmed.""; - } - - OUTPUT_HTML(" - - - - - - - - - - - - - - - - - - - - - - - -"); - } + $OUT = ''; + while ($content = SQL_FETCHARRAY($result_bonus)) { + // Add link to list_unconfirmed what-file + $content['unconfirmed'] = generateUnconfirmedAdminLink($content['id'], $content['unconfirmed']); + + // Prepare content + $content['timestamp'] = generateDateTime($content['timestamp'], 0); + + // Load row template + $OUT .= loadTemplate('admin_list_bonus_emails_row', true, $content); + } // END - while // Add navigation (without change box but with colspan=3) - if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], false, "3"); + $content['nav'] = addEmailNavigation($numPages, getMailsPage(), false, 3, true); + + // Prepare content + $content['rows'] = $OUT; - // Output footer - OUTPUT_HTML("
- ".ADMIN_BONUS_CONTENT." -
- ".EMAIL_SUBJECT.":
- ".$bonus[1]." - 		- ".EMAIL_TEXT.":
- ".$bonus[2]." -
- ".EMAIL_POINTS.":
- ".$bonus[4]." ".POINTS." - 		- ".EMAIL_SECONDS.":
- ".$bonus[5]." "._SECONDS." - 		- ".EMAIL_CATEGORY.":
- ".GET_CATEGORY($bonus[9])." -
- ".EMAIL_RECEIVERS.":
- ".$bonus[11]." (".EMAIL_RUIDS.": ".str_replace(";", ", ", $bonus[3]).") - 		- ".USERS_LINKS.":
- ".$unconfirmed." - 		- ".EMAIL_POOL_TYPE.":
- ".GET_POOL_TYPE($bonus[6])." -
- ".EMAIL_TSEND.":
- ".$bonus[10]." - 		- ".EMAIL_URL.":
- ".ADMIN_TEST_URL." - 		- ".EMAIL_TIMESTAMP.":
- ".MAKE_DATETIME($bonus[7], "0")." -
- ".ADMIN_DELETE_BONUS_MAIL." -
-
"); + // Load main template + loadTemplate('admin_list_bonus_emails', false, $content); $MAIL = true; - } -} + } // END - if +} // END - if -if (!$MAIL) -{ +if ($MAIL === false) { // No mail orders fond - OUTPUT_HTML("".ADMIN_NO_MAILS_IN_POOL.""); -} -// + displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}'); +} // END - if + +// [EOF] ?>