public function subscribersAction()
{
$rmonth = "";
$ryear = "";
$seereportby = $this->request->getParam('reportby');
if ($this->request->getParam('searchvaluehide') != '') {
$searchvalue = $this->request->getParam('searchvaluehide');
} else {
$searchvalue = $this->request->getParam('searchvalue');
}
if ($seereportby == "month") {
$rmonth = $this->request->getParam('monthMessageReport');
$ryear = $this->request->getParam('yearMessageReport');
if ($rmonth == 0 or $ryear == 0) {
$monthstartdate = 0;
$monthenddate = 0;
} else {
$monthstartdate = $ryear . "-" . $rmonth . "-1 00:00:00";
$monthenddate = $ryear . "-" . $rmonth . "-30 00:00:00";
}
} elseif ($seereportby == "date") {
$monthstartdate = date("Y-m-d", strtotime($this->request->getParam('starttime')));
$monthenddate = date("Y-m-d", strtotime($this->request->getParam('endtime')));
} elseif ($seereportby == "") {
$monthstartdate = date('Y') . "-" . date('m') . "-1 00:00:00";
$monthenddate = date('Y') . "-" . date('m') . "-30 00:00:00";
}
$reportObj = new Application_Model_Report();
$pagenum = $this->request->getParam('page');
if ($pagenum == '' or $pagenum == 0) {
$pagenum = 1;
}
$arraystart = $pagenum * 5 - 5;
$arrayend = $pagenum * 5;
if ($this->request->getParam('reportuserid') != '') {
$userid = $this->request->getParam('reportuserid');
} else {
$userid = $this->user->getId();
}
if ($reportObj->checkAdminUser($userid)) {
$this->view->userTypeshowing = 'users';
$subUsersArray = $reportObj->findChildEntityList($userid, 5, $searchvalue);
//echo "<pre>"; print_r($subUsersArray); exit;
$totalSubUsers = count($subUsersArray);
foreach ($subUsersArray as $key => $row) {
$username[$key] = $row['username'];
}
$orderby = $this->request->getParam('orderby');
if ($orderby == 'ASC') {
array_multisort($username, SORT_ASC, $subUsersArray);
} elseif ($orderby == 'DESC') {
array_multisort($username, SORT_DESC, $subUsersArray);
}
//echo "<pre>"; print_r($subUsersArray); exit;
$this->view->sortOrderBy = $orderby;
//$this->view->userlist = $subUsersArray;
$allDetailsArray = array();
foreach ($subUsersArray as $subUser) {
$allDetailsArray[$subUser['childuserid']]['username'] = $subUser['username'];
$allDetailsArray[$subUser['childuserid']]['totalKeywords'] = $reportObj->reportCountTotalKeywordByUserId($subUser['childuserid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subUser['childuserid']]['totalSubscribers'] = $reportObj->reportCountTotalSubscribersByUserId($subUser['childuserid']['childuserid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subUser['childuserid']]['totalOptins'] = $reportObj->reportCountTotalOptinsByUserId($subUser['childuserid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subUser['childuserid']]['totalOptouts'] = $reportObj->reportCountTotalOptoutsByUserId($subUser['childuserid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subUser['childuserid']]['totalCampaigns'] = $reportObj->reportCountTotalCampaignsByUserId($subUser['childuserid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subUser['childuserid']]['totalCampaignMessages'] = $reportObj->reportCountTotalCampaignMessagesByUserId($subUser['childuserid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subUser['childuserid']]['totaloutboundmessage'] = $reportObj->reportCountTotalMessagesByUserId($subUser['childuserid'], $monthstartdate, $monthenddate);
}
//echo "<pre>"; print_r($allDetailsArray); exit;
} else {
$this->view->userTypeshowing = 'locations';
$subFoldersArray = $reportObj->findChildEntityList($userid, 4);
//echo "<pre>"; print_r($subFoldersArray); echo exit;
$totalSubUsers = count($subFoldersArray);
for ($i = $arraystart; $i < $arrayend; $i++) {
if (!empty($subFoldersArray[$i])) {
$allDetailsArray[$subFoldersArray[$i]['folderid']]['username'] = $subFoldersArray[$i]['foldername'];
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totalKeywords'] = $subFoldersArray[$i]['totalkeywords'];
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totalSubscribers'] = $reportObj->totalSubscribersByFolder($subFoldersArray[$i]['folderid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totalOptins'] = $reportObj->totalOptinsByFolder($subFoldersArray[$i]['folderid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totalOptouts'] = $reportObj->totalOptoutsByFolder($subFoldersArray[$i]['folderid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totalCampaigns'] = $reportObj->totalCampaignByFolder($subFoldersArray[$i]['folderid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totalCampaignMessages'] = $reportObj->getTotalCampaignMessagesByFolder($subFoldersArray[$i]['folderid'], $monthstartdate, $monthenddate);
$allDetailsArray[$subFoldersArray[$i]['folderid']]['totaloutboundmessage'] = $reportObj->getTotalOutboundMessages($subFoldersArray[$i]['folderid'], $monthstartdate, $monthenddate);
}
}
}
if (!empty($allDetailsArray)) {
$allDetailsArray['total']['username'] = '******';
$allDetailsArray['total']['totalKeywords'] = '<b>' . $reportObj->reportCountTotalKeywordByUserId($userid, $monthstartdate, $monthenddate) . '</b>';
$allDetailsArray['total']['totalSubscribers'] = '<b>' . $reportObj->reportCountTotalSubscribersByUserId($userid, $monthstartdate, $monthenddate) . '</b>';
$allDetailsArray['total']['totalOptins'] = '<b>' . $reportObj->reportCountTotalOptinsByUserId($userid, $monthstartdate, $monthenddate) . '</b>';
$allDetailsArray['total']['totalOptouts'] = '<b>' . $reportObj->reportCountTotalOptoutsByUserId($userid, $monthstartdate, $monthenddate) . '</b>';
$allDetailsArray['total']['totalCampaignMessages'] = '<b>' . $reportObj->reportCountTotalCampaignMessagesByUserId($userid, $monthstartdate, $monthenddate) . '</b>';
$allDetailsArray['total']['totaloutboundmessage'] = '<b>' . $reportObj->reportCountTotalMessagesByUserId($userid, $monthstartdate, $monthenddate) . '</b>';
}
//echo "<pre>"; print_r($allDetailsArray); exit;
$this->view->seeReportBy = $seereportby;
$this->view->totalSubUsers = $totalSubUsers;
$this->view->allDetailsArray = $allDetailsArray;
$this->view->searchvalue = $searchvalue;
$this->view->reportuserid = $userid;
$this->view->starttime = $this->request->getParam('starttime');
$this->view->endtime = $this->request->getParam('endtime');
if ($this->request->getParam('shownumlist') != '') {
$this->view->showNumList = $this->request->getParam('shownumlist');
} else {
$this->view->showNumList = 10;
}
if ($rmonth == '' or $ryear == '') {
$this->view->monthSelected = date('m');
$this->view->yearSelected = date('Y');
} else {
$this->view->monthSelected = $rmonth;
$this->view->yearSelected = $ryear;
}
}
