X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=83150be3e37d825c1db78dc6b40cdc1825eaab14;hb=29157685184b9aa2ddbf42e9d2e49141af95f7e2;hp=2a765f9b3a9e51704413552e869d92f09f2cff78;hpb=43885129ac24cee5545a8a5ad51e90aa182fdf46;p=mailer.git diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php index 2a765f9b3a..83150be3e3 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, getConfig('mails_page'), 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 } -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) / getConfig('mails_page') + 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, getConfig('mails_page'), false, 3, true); - // Output footer - OUTPUT_HTML("
- ".ADMIN_BONUS_CONTENT." -
- ".EMAIL_SUBJECT.":
- ".$bonus[1]." - 		- ".EMAIL_TEXT.":
- ".$bonus[2]." -
- ".EMAIL_POINTS.":
- ".$bonus[4]." ".POINTS." - 		- ".EMAIL_SECONDS.":
- ".$bonus[5]." ".SECS." - 		- ".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." -
-
"); + // Prepare content + $content['rows'] = $OUT; + + // 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.""); -} -// + loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_MAILS_IN_POOL--}'); +} // END - if + +// [EOF] ?>