/**
* Renders default subscriptions report
*
* @return string
*/
public function renderSubscribtionsReportDaily()
{
$result = '';
$defaultDateTo = strtotime(curdate()) + 86400;
$defaultDateTo = date("Y-m-d", $defaultDateTo);
$inputs = wf_DatePickerPreset('datefrom', date("Y-m") . '-01', true);
$inputs .= wf_DatePickerPreset('dateto', $defaultDateTo, true);
$inputs .= wf_Submit(__('Show'));
$result .= wf_Form('', 'POST', $inputs, 'glamour');
$dateFrom = wf_CheckPost(array('datefrom')) ? mysql_real_escape_string($_POST['datefrom']) : date("Y-m") . '-01';
$dateTo = wf_CheckPost(array('dateto')) ? mysql_real_escape_string($_POST['dateto']) : $defaultDateTo;
$query = "SELECT * from `payments` WHERE `date` BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "' AND `note` LIKE 'MEGOGO:%';";
$raw = simple_queryall($query);
$totalSumm = 0;
$tmpArr = array();
if (!empty($raw)) {
foreach ($raw as $io => $each) {
$tariffId = explode(':', $each['note']);
$tariffId = $tariffId[1];
if (isset($tmpArr[$tariffId])) {
$tmpArr[$tariffId]['summ'] = $tmpArr[$tariffId]['summ'] + abs($each['summ']);
$tmpArr[$tariffId]['count']++;
//try&buy user
if ($each['summ'] == 0) {
$tmpArr[$tariffId]['freeperiod']++;
}
} else {
$tmpArr[$tariffId]['summ'] = abs($each['summ']);
$tmpArr[$tariffId]['count'] = 1;
//try&buy user
if ($each['summ'] == 0) {
$tmpArr[$tariffId]['freeperiod'] = 1;
} else {
$tmpArr[$tariffId]['freeperiod'] = 0;
}
}
}
if (!empty($tmpArr)) {
$cells = wf_TableCell(__('Tariff'));
$cells .= wf_TableCell(__('Fee') . ' / ' . __('month'));
$cells .= wf_TableCell(__('days'));
$cells .= wf_TableCell(__('Free period'));
$cells .= wf_TableCell(__('Total payments'));
$cells .= wf_TableCell(__('Profit'));
$rows = wf_TableRow($cells, 'row1');
foreach ($tmpArr as $io => $each) {
$cells = wf_TableCell(@$this->allTariffs[$io]['name']);
$cells .= wf_TableCell(@$this->allTariffs[$io]['fee']);
$cells .= wf_TableCell($each['count']);
$cells .= wf_TableCell($each['freeperiod']);
$cells .= wf_TableCell($each['summ']);
$cells .= wf_TableCell(zb_Percent($each['summ'], $this->altCfg['MG_PERCENT']));
$rows .= wf_TableRow($cells, 'row3');
$totalSumm = $totalSumm + $each['summ'];
}
$cells = wf_TableCell(wf_tag('b') . __('Total') . wf_tag('b', true));
$cells .= wf_TableCell('');
$cells .= wf_TableCell('');
$cells .= wf_TableCell('');
$cells .= wf_TableCell($totalSumm);
$cells .= wf_TableCell(zb_Percent($totalSumm, $this->altCfg['MG_PERCENT']));
$rows .= wf_TableRow($cells, 'row2');
$result .= wf_TableBody($rows, '100%', 0, '');
}
} else {
$result .= $this->messages->getStyledMessage(__('Nothing found'), 'info');
}
return $result;
}
/**
* Performs friends yesterday payments processing
*
* @return void
*/
public function friendsDailyProcessing()
{
$this->loadDailyPayments();
if (!empty($this->rawPayments)) {
foreach ($this->rawPayments as $paymentId => $eachPayment) {
if (isset($this->allFriends[$eachPayment['login']])) {
$friendLogin = $eachPayment['login'];
$parentLogin = $this->allFriends[$eachPayment['login']];
$originalSum = $eachPayment['summ'];
$percent = zb_Percent($originalSum, $this->percent);
zb_CashAdd($parentLogin, $percent, 'add', $this->payid, 'FRIENDSHIP:' . $eachPayment['id']);
}
}
}
}
