public function __construct()
{
//sets display year
if (wf_CheckPost(array('setyear'))) {
$this->curyear = vf($_POST['setyear'], 3);
} else {
$this->curyear = curyear();
}
//load actual month data
$this->loadData();
//load user tariffs
$this->loadTariffs();
}
/**
* Return Year select Web From element
*
* @param string $name name of element
* @param string $label text label for input
* @param bool $br append new line
* @param int $year selected year
*
* @return string
*
*/
function wf_YearSelectorPreset($name, $label = '', $br = false, $year = '')
{
$curyear = curyear();
$inputid = wf_InputId();
$count = 9;
$selected = '';
if ($br) {
$newline = '<br>';
} else {
$newline = '';
}
$selector = '<select name="' . $name . '" id="' . $inputid . '">';
for ($i = 0; $i < $count; $i++) {
$selected = $curyear - $i == $year ? 'SELECTED' : '';
$selector .= '<option value="' . ($curyear - $i) . '" ' . $selected . '>' . ($curyear - $i) . '</option>';
}
$selector .= '</select>';
if ($label != '') {
$selector .= '<label for="' . $inputid . '">' . __($label) . '</label>';
}
$selector .= $newline;
return $selector;
}
<?php
if (cfr('REPORTFINANCE')) {
if (!wf_CheckGet(array('analytics'))) {
if (!wf_CheckPost(array('yearsel'))) {
$show_year = curyear();
} else {
$show_year = $_POST['yearsel'];
}
$altcfg = $ubillingConfig->getAlter();
$dateSelectorPreset = wf_CheckPost(array('showdatepayments')) ? $_POST['showdatepayments'] : curdate();
$dateinputs = wf_DatePickerPreset('showdatepayments', $dateSelectorPreset);
$dateinputs .= wf_Submit(__('Show'));
$dateform = wf_Form("?module=report_finance", 'POST', $dateinputs, 'glamour');
$yearinputs = wf_YearSelector('yearsel');
$yearinputs .= wf_Submit(__('Show'));
$yearform = wf_Form("?module=report_finance", 'POST', $yearinputs, 'glamour');
$controlcells = wf_TableCell(wf_tag('h3', false, 'title') . __('Year') . wf_tag('h3', true));
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Payments by date') . wf_tag('h3', true));
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Payment search') . wf_tag('h3', true));
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Analytics') . wf_tag('h3', true));
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('ARPU') . wf_tag('h3', true));
if ($altcfg['AGENTS_ASSIGN'] == '2') {
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Agent payments') . wf_tag('h3', true));
}
$controlrows = wf_TableRow($controlcells);
$controlcells = wf_TableCell($yearform);
$controlcells .= wf_TableCell($dateform);
$controlcells .= wf_TableCell(wf_Link("?module=payfind", web_icon_search() . ' ' . __('Find'), false, 'ubButton'));
$controlcells .= wf_TableCell(wf_Link("?module=report_finance&analytics=true", wf_img('skins/icon_stats.gif') . ' ' . __('Show'), false, 'ubButton'));
$controlcells .= wf_TableCell(wf_Link("?module=report_arpu", wf_img('skins/ukv/report.png') . ' ' . __('Show'), false, 'ubButton'));
/**
* Renders tickets calendar view widget
*
* @return string
*/
function web_TicketsCalendar()
{
$curyear = curyear();
$query = "SELECT * from `ticketing` WHERE `to` IS NULL AND `replyid` IS NULL AND `date` LIKE '" . $curyear . "-%' ORDER BY `date` ASC";
$all = simple_queryall($query);
$allAddress = zb_AddressGetFulladdresslistCached();
$result = '';
$calendarData = '';
if (!empty($all)) {
foreach ($all as $io => $each) {
$timestamp = strtotime($each['date']);
$date = date("Y, n-1, j", $timestamp);
$rawTime = date("H:i:s", $timestamp);
if ($each['status'] == 0) {
$coloring = "className : 'undone',";
} else {
$coloring = '';
}
$calendarData .= "\n {\n title: '" . $rawTime . ' ' . @$allAddress[$each['from']] . "',\n url: '?module=ticketing&showticket=" . $each['id'] . "',\n start: new Date(" . $date . "),\n end: new Date(" . $date . "),\n " . $coloring . " \n },\n ";
}
}
$result = wf_FullCalendar($calendarData);
return $result;
}
//set payment may be zero
if ($_POST['optype'] == 'set') {
if (isset($_POST['newpayment'])) {
catv_CashSet($userid, $_POST['date'], $_POST['newpayment'], $_POST['from_month'], $_POST['from_year'], $_POST['to_month'], $_POST['to_year'], $_POST['notes']);
}
}
rcms_redirect("?module=catv_addcash&userid=" . $userid);
}
//if someone delete payment
if (wf_CheckGet(array('deletepayment'))) {
catv_CashPaymentDelete($_GET['deletepayment']);
rcms_redirect("?module=catv_addcash&userid=" . $userid);
}
//if someone delete payment
if (wf_CheckGet(array('editpayment'))) {
$paymentid = vf($_GET['editpayment'], 3);
if (isset($_POST['editpayment'])) {
catv_CashEdit($paymentid, $_POST['editdate'], $_POST['editpayment'], $_POST['editfrom_month'], $_POST['editfrom_year'], $_POST['editto_month'], $_POST['editto_year'], $_POST['editnotes']);
rcms_redirect("?module=catv_addcash&userid=" . $userid);
}
show_window(__('Edit') . ' ' . __('Payment'), catv_CashEditForm($paymentid));
}
if (!wf_CheckGet(array('editpayment'))) {
show_window(__('Manual receipt of payments'), catv_CashAddForm($userid));
}
catv_UserStatsByYear($userid, curyear());
catv_ProfileBack($userid);
}
} else {
show_error(__('You cant control this module'));
}
/**
* Renders dead switches top
*
* @return string
*/
function web_DeadSwitchesTop()
{
$topThreshold = 10;
$result = '';
$cyear = curyear();
$query = "SELECT `id`,`date`,`timestamp`,`swdead` from `switchdeadlog` WHERE `date` LIKE '" . $cyear . "-%' ORDER BY `id` ASC";
$rawData = simple_queryall($query);
$topTmp = array();
$totalCount = 0;
if (!empty($rawData)) {
foreach ($rawData as $io => $each) {
if (!empty($each['swdead'])) {
$deadData = unserialize($each['swdead']);
if (!empty($deadData)) {
foreach ($deadData as $eachDeadIp => $eachDeadName) {
if (isset($topTmp[$eachDeadIp])) {
$topTmp[$eachDeadIp]['count']++;
} else {
$topTmp[$eachDeadIp]['count'] = 1;
$topTmp[$eachDeadIp]['name'] = $eachDeadName;
}
$totalCount++;
}
}
}
}
}
if (!empty($topTmp)) {
$cells = wf_TableCell(__('IP'));
$cells .= wf_TableCell(__('Location'));
$cells .= wf_TableCell(__('Count'));
$cells .= wf_TableCell(__('Visual'));
$rows = wf_TableRow($cells, 'row1');
foreach ($topTmp as $io => $each) {
if ($each['count'] > $topThreshold) {
$cells = wf_TableCell($io);
$cells .= wf_TableCell($each['name']);
$cells .= wf_TableCell($each['count']);
$cells .= wf_TableCell(web_bar($each['count'], $totalCount));
$rows .= wf_TableRow($cells, 'row3');
}
}
$result = wf_TableBody($rows, '100%', 0, 'sortable');
}
return $result;
}
function catv_FinanceReport()
{
if (!isset($_POST['yearsel'])) {
$show_year = curyear();
} else {
$show_year = $_POST['yearsel'];
}
$dateform = '
<form action="?module=catv&action=reports&showreport=finance" method="POST">
' . web_CalendarControl('showdatepayments') . '
<input type="submit" value="' . __('Show') . '">
</form>
<br>
';
$yearform = '
<form action="?module=catv&action=reports&showreport=finance" method="POST">
' . web_year_selector() . '
<input type="submit" value="' . __('Show') . '">
</form>
';
show_window(__('Year'), $yearform);
show_window(__('Payments by date'), $dateform);
catv_PaymentsShowGraph($show_year);
if (!isset($_GET['month'])) {
// payments by somedate
if (isset($_POST['showdatepayments'])) {
$paydate = mysql_real_escape_string($_POST['showdatepayments']);
//deb($paydate);
show_window(__('Payments by date') . ' ' . $paydate, catv_PaymentsShow("SELECT * from `catv_payments` WHERE `date` LIKE '" . $paydate . "%'"));
} else {
// today payments
$today = curdate();
show_window(__('Today payments'), catv_PaymentsShow("SELECT * from `catv_payments` WHERE `date` LIKE '" . $today . "%'"));
}
} else {
// show monthly payments
$paymonth = mysql_real_escape_string($_GET['month']);
show_window(__('Month payments'), catv_PaymentsShow("SELECT * from `catv_payments` WHERE `date` LIKE '" . $paymonth . "%'"));
}
}
public function loadAllPreviousAlerts()
{
//select year to load
if (wf_CheckPost(array('alertsyearsel'))) {
$curYear = vf($_POST['alertsyearsel'], 3);
} else {
$curYear = curyear();
}
$query = "SELECT `id`,`date`,`event` from `weblogs` WHERE `event` LIKE 'WATCHDOG NOTIFY THAT%' AND `date` LIKE '" . $curYear . "-%';";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->previousAlerts[$each['id']]['id'] = $each['id'];
$this->previousAlerts[$each['id']]['date'] = $each['date'];
$event = str_replace('WATCHDOG NOTIFY THAT', '', $each['event']);
$event = str_replace('`', '', $event);
$this->previousAlerts[$each['id']]['event'] = $event;
}
}
}
/**
* renders available signups data in calendar view
*
* @return void
*/
public function renderCalendar()
{
$curyear = curyear();
$query = "SELECT * from `sigreq` WHERE `date` LIKE '" . $curyear . "-%' ORDER BY `date` ASC";
$all = simple_queryall($query);
$result = '';
$calendarData = '';
if (!empty($all)) {
foreach ($all as $io => $each) {
$timestamp = strtotime($each['date']);
$date = date("Y, n-1, j", $timestamp);
$rawTime = date("H:i:s", $timestamp);
if ($each['state'] == 0) {
$coloring = "className : 'undone',";
} else {
$coloring = '';
}
$calendarData .= "\n {\n title: '" . $rawTime . ' ' . $each['street'] . ' ' . $each['build'] . '/' . $each['apt'] . "',\n url: '?module=sigreq&showreq=" . $each['id'] . "',\n start: new Date(" . $date . "),\n end: new Date(" . $date . "),\n " . $coloring . " \n },\n ";
}
}
$result = wf_FullCalendar($calendarData);
//check database configuration table
if (zb_CheckTableExists('sigreqconf')) {
$confControl = wf_Link('?module=sigreq&settings=true', wf_img('skins/settings.png', __('Settings')), false) . ' ';
} else {
$confControl = '';
}
$viewControl = wf_Link('?module=sigreq', wf_img('skins/icon_table.png', __('Grid view')), false, '');
show_window($confControl . __('Available signup requests') . ' ' . $viewControl, $result);
}
/**
* Renders printable HTML sales slip
*
* @param int $paymentid
* @return string
*/
function zb_PrintCheck($paymentid)
{
$paymentdata = zb_PaymentGetData($paymentid);
$login = $paymentdata['login'];
$templatebody = zb_PrintCheckLoadTemplate();
$allfioz = zb_UserGetAllRealnames();
$alladdress = zb_AddressGetFullCityaddresslist();
$useraddress = $alladdress[$login];
$agent_data = zb_AgentAssignedGetDataFast($login, $useraddress);
$cassnames = zb_PrintCheckLoadCassNames();
$cday = date("d");
$cmonth = date("m");
$month_array = months_array();
$cmonth_name = $month_array[$cmonth];
$cyear = curyear();
$morph = new UBMorph();
//forming template data
@($templatedata['{PAYID}'] = $paymentdata['id']);
@($templatedata['{PAYIDENC}'] = zb_NumEncode($paymentdata['id']));
@($templatedata['{PAYDATE}'] = $paymentdata['date']);
@($templatedata['{PAYSUMM}'] = $paymentdata['summ']);
@($templatedata['{PAYSUMM_LIT}'] = $morph->sum2str($paymentdata['summ']));
// omg omg omg
@($templatedata['{REALNAME}'] = $allfioz[$login]);
@($templatedata['{BUHNAME}'] = 'а відки я знаю?');
@($templatedata['{CASNAME}'] = $cassnames[whoami()]);
@($templatedata['{PAYTARGET}'] = 'Оплата за послуги / ' . $paymentdata['date']);
@($templatedata['{FULLADDRESS}'] = $useraddress);
@($templatedata['{CDAY}'] = $cday);
@($templatedata['{CMONTH}'] = rcms_date_localise($cmonth_name));
@($templatedata['{CYEAR}'] = $cyear);
@($templatedata['{DAYPAYID}'] = zb_PrintCheckGetDayNum($paymentdata['id'], $paymentdata['date']));
//contragent full data
@($templatedata['{AGENTEDRPO}'] = $agent_data['edrpo']);
@($templatedata['{AGENTNAME}'] = $agent_data['contrname']);
@($templatedata['{AGENTID}'] = $agent_data['id']);
@($templatedata['{AGENTBANKACC}'] = $agent_data['bankacc']);
@($templatedata['{AGENTBANKNAME}'] = $agent_data['bankname']);
@($templatedata['{AGENTBANKCODE}'] = $agent_data['bankcode']);
@($templatedata['{AGENTIPN}'] = $agent_data['ipn']);
@($templatedata['{AGENTLICENSE}'] = $agent_data['licensenum']);
@($templatedata['{AGENTJURADDR}'] = $agent_data['juraddr']);
@($templatedata['{AGENTPHISADDR}'] = $agent_data['phisaddr']);
@($templatedata['{AGENTPHONE}'] = $agent_data['phone']);
//parsing result
$result = zb_ExportParseTemplate($templatebody, $templatedata);
return $result;
}
if (!empty($beggar)) {
$corps = new Corps();
$funds = new FundsFlow();
//all that we need
$corpsData = $corps->getCorps();
$corpUsers = $corps->getUsers();
$allUserContracts = zb_UserGetAllContracts();
$allUsersCash = zb_UserGetAllBalance();
$allUserTariffs = zb_TariffsGetAllUsers();
$allTariffPrices = zb_TariffGetPricesAll();
$rows = '';
$count = 0;
//showing date search form
show_window(__('Corporate users') . ' - ' . __('Funds flow'), $funds->renderCorpsFlowsDateForm());
if (!wf_CheckPost(array('yearsel', 'monthsel'))) {
$needYear = curyear();
$needMonth = date("m");
} else {
$needYear = $_POST['yearsel'];
$needMonth = $_POST['monthsel'];
}
//setting date filter
$date = $needYear . '-' . $needMonth . '-';
if (!empty($corpUsers)) {
$rows = $funds->renderCorpsFlowsHeaders($needYear, $needMonth);
//contragent filter
if (wf_CheckPost(array('agentsel'))) {
$agentFilter = $_POST['agentsel'];
$allassigns = zb_AgentAssignGetAllData();
$allassignsStrict = zb_AgentAssignStrictGetAllData();
$alladdress = zb_AddressGetFulladdresslistCached();
/**
* Renders default subscriptions report
*
* @return string
*/
public function renderSubscribtionsReportMonthly()
{
$result = '';
$selectedMonth = wf_CheckPost(array('monthsel')) ? $_POST['monthsel'] : date("m");
$inputs = wf_YearSelector('yearsel', __('Year'), false) . ' ';
$inputs .= wf_MonthSelector('monthsel', __('Month'), $selectedMonth, false) . ' ';
$inputs .= wf_Submit(__('Show'));
$result .= wf_Form('', 'POST', $inputs, 'glamour');
$curYear = wf_CheckPost(array('yearsel')) ? vf($_POST['yearsel'], 3) : curyear();
$curMonth = wf_CheckPost(array('monthsel')) ? vf($_POST['monthsel'], 3) : date("m");
$query = "SELECT * from `payments` WHERE `date` LIKE '" . $curYear . "-" . $curMonth . "%' AND `note` LIKE 'MEGOGO:%';";
$raw = simple_queryall($query);
$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'));
$cells .= wf_TableCell(__('Users'));
$cells .= wf_TableCell(__('Free period'));
$cells .= wf_TableCell(__('Total payments'));
$cells .= wf_TableCell(__('Profit'));
$rows = wf_TableRow($cells, 'row1');
$totalUsers = 0;
$totalFree = 0;
$totalSumm = 0;
foreach ($tmpArr as $io => $each) {
$totalUsers = $totalUsers + $each['count'];
$totalFree = $totalFree + $each['freeperiod'];
$totalSumm = $totalSumm + $each['summ'];
$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');
}
$cells = wf_TableCell(wf_tag('b') . __('Total') . wf_tag('b', true));
$cells .= wf_TableCell('');
$cells .= wf_TableCell($totalUsers);
$cells .= wf_TableCell($totalFree);
$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;
}
/**
* Returns dead switches json data for timemachine calendar view
*
* @return string
*/
function ub_JGetSwitchDeadLog()
{
$cyear = curyear();
$query = "SELECT `id`,`date`,`timestamp`,`swdead` from `switchdeadlog` WHERE `date` LIKE '" . $cyear . "-%' ORDER BY `id` ASC";
$alldead = simple_queryall($query);
$i = 1;
$logcount = sizeof($alldead);
$result = '';
if (!empty($alldead)) {
foreach ($alldead as $io => $eachdead) {
if ($i != $logcount) {
$thelast = ',';
} else {
$thelast = '';
}
$startdate = strtotime($eachdead['date']);
$startdate = date("Y, n-1, j", $startdate);
$deadData_raw = $eachdead['swdead'];
$deadData = unserialize($deadData_raw);
$deadcount = sizeof($deadData);
$result .= "\n {\n title: '" . date("H:i:s", $eachdead['timestamp']) . " - (" . $deadcount . ")',\n start: new Date(" . $startdate . "),\n end: new Date(" . $startdate . "),\n className : 'undone',\n url: '?module=switches&timemachine=true&snapshot=" . $eachdead['id'] . "'\n\t\t }\n " . $thelast;
$i++;
}
}
return $result;
}
$exportFilename = 'exports/cardreport_' . $year . '-' . $month . '.csv';
$csvdata = iconv('utf-8', 'windows-1251', $csvdata);
file_put_contents($exportFilename, $csvdata);
$exportLink = wf_Link('?module=cardreport&dloadcsv=' . base64_encode($exportFilename), wf_img('skins/excel.gif', __('Export')), false, '');
} else {
$exportLink = '';
}
$result = wf_TableBody($tablerows, '100%', '0', 'sortable');
$result .= __('Total') . ': ' . $totalcount . ' ' . __('payments') . ', ' . __('with total amount') . ': ' . $totalsumm;
show_window(__('Payment cards usage report') . ' ' . $exportLink, $result);
}
web_CardShowDateForm();
//selecting month and date
if (wf_CheckPost(array('yearsel', 'monthsel'))) {
$needyear = $_POST['yearsel'];
$needmonth = $_POST['monthsel'];
} else {
$needyear = curyear();
$needmonth = date("m");
}
//download exported search
if (wf_CheckGet(array('dloadcsv'))) {
zb_DownloadFile(base64_decode($_GET['dloadcsv']), 'docx');
}
web_CardShowUsageByMonth($needyear, $needmonth);
} else {
show_error(__('This module is disabled'));
}
} else {
show_error(__('You cant control this module'));
}
/**
*
* Return Year select Web From element
*
* @param $name name of element
* @param $label text label for input
* @param $br append new line - bool
* @return string
*
*/
function la_YearSelector($name, $label = '', $br = false)
{
$curyear = curyear();
$inputid = la_InputId();
$count = 5;
if ($br) {
$newline = '<br>';
} else {
$newline = '';
}
$selector = '<select name="' . $name . '">';
for ($i = 0; $i < $count; $i++) {
$selector .= '<option value="' . ($curyear - $i) . '">' . ($curyear - $i) . '</option>';
}
$selector .= '</select>';
if ($label != '') {
$selector .= '<label for="' . $inputid . '">' . __($label) . '</label>';
}
$selector .= $newline;
return $selector;
}
<?php
if (cfr('PLDETAILS')) {
if (isset($_GET['username'])) {
$login = $_GET['username'];
$userdata = zb_UserGetStargazerData($login);
$cyear = curyear();
$cmonth = date("m");
$tablename = 'detailstat_' . $cmonth . '_' . $cyear . '';
function ds_CheckTable()
{
global $tablename;
$query = "SELECT CASE WHEN (SELECT COUNT(*) AS STATUS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = (SELECT DATABASE()) AND TABLE_NAME = '" . $tablename . "') = 1 THEN (SELECT 1) ELSE (SELECT 0) END AS result;";
$result = simple_query($query);
return $result['result'];
}
function ds_GetDays()
{
global $tablename;
$query = "SELECT DISTINCT `day` from `" . $tablename . "`";
$alldays = simple_queryall($query);
return $alldays;
}
function ds_GetDayStats($login, $day, $page = 0)
{
global $tablename;
$pagelimit = 100;
$page = vf($page);
$login = mysql_real_escape_string($login);
$dey = vf($day);
$query = "SELECT * from `" . $tablename . "` WHERE `login`='" . $login . "' AND `day`='" . $day . "' ORDER by `starttime` DESC";
/**
* renders users signup report
*
* @return void
*/
public function reportSignup()
{
$regdates = array();
$months = months_array();
$monthCount = array();
$showYear = wf_CheckPost(array('showyear')) ? vf($_POST['showyear'], 3) : curyear();
$showMonth = wf_CheckGet(array('month')) ? mysql_real_escape_string($_GET['month']) : curmonth();
$yearCount = 0;
if (!empty($this->users)) {
foreach ($this->users as $io => $each) {
if (!empty($each['regdate'])) {
$dateTime = explode(' ', $each['regdate']);
$regdates[$dateTime[0]][] = $each['id'];
}
}
}
// show year selector
$yearInputs = wf_YearSelector('showyear', ' ', false);
$yearInputs .= wf_Submit(__('Show'));
$yearForm = wf_Form('', 'POST', $yearInputs, 'glamour');
show_window(__('Year'), $yearForm);
//extract year signup count data
foreach ($months as $eachMonth => $monthName) {
$sigcount = 0;
if (!empty($regdates)) {
foreach ($regdates as $eachRegDate => $userIds) {
$dateMark = $showYear . '-' . $eachMonth;
if (ispos($eachRegDate, $dateMark)) {
$sigcount = $sigcount + count($regdates[$eachRegDate]);
}
$monthCount[$eachMonth] = $sigcount;
}
$yearCount = $yearCount + $sigcount;
}
}
//render per year grid
$cells = wf_TableCell('');
$cells .= wf_TableCell(__('Month'));
$cells .= wf_TableCell(__('Signups'));
$cells .= wf_TableCell(__('Visual'));
$rows = wf_TableRow($cells, 'row1');
foreach ($months as $eachMonth => $monthName) {
$cells = wf_TableCell($eachMonth);
$monthLink = wf_Link(self::URL_REPORTS_MGMT . 'reportSignup&month=' . $showYear . '-' . $eachMonth, rcms_date_localise($monthName), false);
$cells .= wf_TableCell($monthLink);
$cells .= wf_TableCell($monthCount[$eachMonth]);
$cells .= wf_TableCell(web_bar($monthCount[$eachMonth], $yearCount));
$rows .= wf_TableRow($cells, 'row3');
}
$result = wf_TableBody($rows, '100%', 0, 'sortable');
$result .= __('Total') . ': ' . $yearCount;
show_window(__('User signups by year') . ' ' . $showYear, $result);
//render per month registrations
$cells = wf_TableCell(__('ID'));
$cells .= wf_TableCell(__('Date'));
$cells .= wf_TableCell(__('Full address'));
$cells .= wf_TableCell(__('Real Name'));
$cells .= wf_TableCell(__('Tariff'));
$rows = wf_TableRow($cells, 'row1');
if (!empty($regdates)) {
foreach ($regdates as $eachRegDate => $eachRegUsers) {
if (ispos($eachRegDate, $showMonth)) {
foreach ($eachRegUsers as $ix => $eachUserId) {
$cells = wf_TableCell($eachUserId);
$cells .= wf_TableCell($this->users[$eachUserId]['regdate']);
$userLink = wf_Link(self::URL_USERS_PROFILE . $eachUserId, web_profile_icon() . ' ', false);
$cells .= wf_TableCell($userLink . $this->userGetFullAddress($eachUserId));
$cells .= wf_TableCell($this->users[$eachUserId]['realname']);
$cells .= wf_TableCell(@$this->tariffs[$this->users[$eachUserId]['tariffid']]['tariffname']);
$rows .= wf_TableRow($cells, 'row3');
}
}
}
}
$result = wf_TableBody($rows, '100%', '0', 'sortable');
if ($showMonth == curmonth()) {
$monthTitle = __('Current month user signups');
} else {
$monthTitle = __('User signups by month') . ' ' . $showMonth;
}
show_window($monthTitle, $result);
}
$tablecells .= wf_TableCell(__('Count'));
$tablecells .= wf_TableCell(__('Visual'));
$tablerows = wf_TableRow($tablecells, 'row1');
if (!empty($tcount)) {
foreach ($tcount as $sigtariff => $eachcount) {
$tablecells = wf_TableCell($sigtariff);
$tablecells .= wf_TableCell($eachcount);
$tablecells .= wf_TableCell(web_bar($eachcount, sizeof($allsignups)), '', '', 'sorttable_customkey="' . $eachcount . '"');
$tablerows .= wf_TableRow($tablecells, 'row3');
}
}
$result = wf_TableBody($tablerows, '100%', '0', 'sortable');
show_window(__('Tariffs report'), $result);
}
if (!isset($_POST['yearsel'])) {
$year = curyear();
} else {
$year = $_POST['yearsel'];
}
$yearinputs = wf_YearSelector('yearsel');
$yearinputs .= wf_Submit(__('Show'));
$yearform = wf_Form('?module=report_signup', 'POST', $yearinputs, 'glamour');
$yearform .= wf_CleanDiv();
web_SignupsShowToday();
show_window(__('Year'), $yearform);
web_SignupsGraphYear($year);
web_SignupGraph();
if ($altercfg['CEMETERY_ENABLED']) {
$cemetery = new Cemetery();
show_window('', $cemetery->renderChart());
}
<?php
// check for right of current admin on this module
if (cfr('CATVSTATS')) {
catv_GlobalControlsShow();
if (wf_CheckGet(array('userid'))) {
$userid = vf($_GET['userid'], 3);
$userdata = catv_UserGetData($userid);
$realname = $userdata['realname'];
$address = $userdata['street'] . ' ' . $userdata['build'] . '/' . $userdata['apt'];
//target year selection
$yearforminputs = wf_YearSelector('yearselect', 'Year', false);
$yearforminputs .= ' ';
$yearforminputs .= wf_Submit('Show');
$yearform = wf_Form('', 'POST', $yearforminputs, 'glamour', '');
show_window($address . ' ' . $realname, $yearform . '<div style="clear: both;"></div>');
if (wf_CheckPost(array('yearselect'))) {
$target_year = $_POST['yearselect'];
} else {
$target_year = curyear();
}
catv_UserStatsByYear($userid, $target_year);
catv_DecoderShowAllChanges($userid);
catv_ActivityShowAll($userid);
catv_ProfileBack($userid);
}
} else {
show_error(__('You cant control this module'));
}
/**
* Returns count of undone tasks only for current admin login - used by DarkVoid
*
* @return int
*/
function ts_GetUndoneCountersMy()
{
$result = 0;
$curdate = curdate();
$curyear = curyear();
$mylogin = whoami();
$adminQuery = "SELECT `id` from `employee` WHERE `admlogin`='" . $mylogin . "'";
$adminId = simple_query($adminQuery);
if (!empty($adminId)) {
$adminId = $adminId['id'];
$query = "SELECT `id` from `taskman` WHERE `employee`='" . $adminId . "' AND `status` = '0' AND `startdate` <= '" . $curdate . "' AND `date` LIKE '" . $curyear . "-%';";
$allundone = simple_queryall($query);
if (!empty($allundone)) {
$result = sizeof($allundone);
}
}
return $result;
}
