X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_doubler.php;h=190be0268fb1c9786c0527a9a3769f7600160a94;hp=867a408900926205f540df789a8c4011ffe8e0b2;hb=596c8ab32594401ca84abfbfe35513ddfff31bec;hpb=cca98f57dff720b174d21d071cee8303462485d7 diff --git a/inc/modules/admin/what-list_doubler.php b/inc/modules/admin/what-list_doubler.php index 867a408900..190be0268f 100644 --- a/inc/modules/admin/what-list_doubler.php +++ b/inc/modules/admin/what-list_doubler.php @@ -1,7 +1,7 @@ ".$cnt.""); - } - $result = SQL_QUERY("SELECT COUNT(id) FROM `{!MYSQL_PREFIX!}_doubler` WHERE completed='Y' AND is_ref='Y'", __FILE__, __LINE__); - list($cnt) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if ((empty($cnt)) || ($cnt == "0")) - { - // Nothing payed out so far - define('__DOUBLER_ALREADY_REF_LINK', "0"); - } - else - { - // Something was payed out - $SUM_ALREADY += $cnt; - define('__DOUBLER_ALREADY_REF_LINK', "".$cnt.""); - } - define('__DOUBLER_ALREADY_ALL_LINK', "".$SUM_ALREADY.""); - - // And the same for waiting pouts (direct and referal) - $result = SQL_QUERY("SELECT COUNT(id) FROM `{!MYSQL_PREFIX!}_doubler` WHERE completed='N' AND is_ref='N'", __FILE__, __LINE__); - list($cnt) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if ((empty($cnt)) || ($cnt == "0")) - { - // Nothing payed out so far - define('__DOUBLER_WAITING_DIRECT_LINK', "0"); - } - else - { - // Something was payed out - $SUM_WAITING += $cnt; - define('__DOUBLER_WAITING_DIRECT_LINK', "".$cnt.""); - } - $result = SQL_QUERY("SELECT COUNT(id) FROM `{!MYSQL_PREFIX!}_doubler` WHERE completed='N' AND is_ref='Y'", __FILE__, __LINE__); - list($cnt) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if ((empty($cnt)) || ($cnt == "0")) - { - // Nothing payed out so far - define('__DOUBLER_WAITING_REF_LINK', "0"); - } - else - { - // Something was payed out - $SUM_WAITING += $cnt; - define('__DOUBLER_WAITING_REF_LINK', "".$cnt.""); - } - define('__DOUBLER_WAITING_ALL_LINK', "".$SUM_WAITING.""); - - // All data is loaded here... - break; -} +switch (getRequestElement('do')) { + case 'already': // Already payed out points + break; + + case 'overview': // General overview page + // Prepare links + foreach (array('already_direct','already_ref','waiting_direct','waiting_ref') as $entry) { + $content[$entry . '_link'] = '0'; + } // END - switch + + // Init sums + $sumAlready = '0'; $sumWaiting = '0'; + + // Number of direct already payouts and referral + $count = countSumTotalData('Y', 'doubler', 'id', 'completed', TRUE, " AND `is_ref`='N'"); + + if ($count > 0) { + // Something was payed out + $sumAlready += $count; + $content['already_direct_link'] = '' . $count . ''; + } // END - if + + $count = countSumTotalData('Y', 'doubler', 'id', 'completed', TRUE, " AND `is_ref`='Y'"); + + if ($count > 0) { + // Something was payed out + $sumAlready += $count; + $content['already_ref_link'] = '' . $count . ''; + } // END - if + + // And the same for waiting pouts (direct and referral) + $count = countSumTotalData('N', 'doubler', 'id', 'completed', TRUE, " AND `is_ref`='N'"); + + if ($count > 0) { + // Something was payed out + $sumWaiting += $count; + $content['waiting_direct_link'] = '' . $count . ''; + } // END - if + + $count = countSumTotalData('N', 'doubler', 'id', 'completed', TRUE, " AND `is_ref`='Y'"); + + if ($count > 0) { + // Something was payed out + $sumWaiting += $count; + $content['waiting_ref_link'] = '' . $count . ''; + } // END - if + + // Links for all + $content['already_all_link'] = '' . $sumAlready . ''; + $content['waiting_all_link'] = '' . $sumWaiting . ''; + + // All data is loaded here... + break; +} // END - switch // Load mode template -LOAD_TEMPLATE("admin_list_doubler_".$_GET['mode']); +loadTemplate('admin_list_doubler_' . getRequestElement('do'), FALSE, $content); -// +// [EOF] ?>