public function messagemonthyearoldAction()
{
$this->_helper->layout->disableLayout();
$this->view->msg_limit = $this->user->messagelimit;
$this->view->key_limit = $this->user->keywordlimit;
$key_used = $this->user->getKeywordsCount();
$key_deleted = $this->user->getDeletedKeywordsCount();
$this->view->key_used = $key_used - $key_deleted;
$this->view->key_percent = sprintf("%d", $this->view->key_used / $this->view->key_limit * 100);
// Large graph
$dayrange = 30;
$daystep = 2;
$this->view->graphrange = $dayrange;
$this->view->graphstep = $daystep;
$optins = $this->user->getTotalSubscriberCountByDay($dayrange, 'asc');
$optouts = $this->user->getDailyOptoutsByDay($dayrange, 'asc');
$this->view->graphoptins = $optins;
$this->view->graphoptouts = $optouts;
$rmonth = $this->request->getParam('rmonth');
$ryear = $this->request->getParam('ryear');
if ($rmonth == '0' or $rmonth == '0') {
$rmonth = date('n');
$ryear = date('Y');
}
$userid = $this->user->getId();
$messageObj = new Application_Model_Report();
//*********** Calculate startdate and end date................
$rmonth = date('m');
$ryear = date('Y');
$daysInMonth = cal_days_in_month(CAL_GREGORIAN, $rmonth, $ryear);
// echo 'rmstart-'.$monthstartdate = $ryear."-".$rmonth."-1 00:00:00"; echo '<br>';
//echo 'rmend-'.$monthenddate = $ryear."-".$rmonth."-30 00:00:00";
$monthstartdate = $ryear . "-" . $rmonth . "-1 00:00:00";
$monthenddate = $ryear . "-" . $rmonth . "-" . $daysInMonth . " 00:00:00";
// End of Script
//$this->view->msg_used = $messageObj->reportCountTotalMessagesByUserId($userid);
$this->view->msg_used = $messageObj->reportCountTotalMessagesByUserId($userid, $monthstartdate, $monthenddate);
//reportCountTotalMessagesByUserId($userid,$monthstartdate,$monthenddate)
$msgpercent = $this->view->msg_used / $this->view->msg_limit * 100;
if ($msgpercent >= 100) {
$msgpercent = 100;
}
$this->view->msg_percent = sprintf("%d", $msgpercent);
//$totalOptIns = $messageObj->getTotalOptIns($userid);
$totalOptIns = $messageObj->reportCountTotalOptinsByUserId($userid);
//$totalOptOuts = $messageObj->getTotalOptOuts($userid);
$totalOptOuts = $messageObj->reportCountTotalOptoutsByUserId($userid);
//$totalSubscribers = $messageObj->getTotalSubscribers($userid);
$totalSubscribers = $messageObj->reportCountTotalSubscribersByUserId($userid, $monthstartdate, $monthenddate);
$this->view->totalOptIns = $totalOptIns;
$this->view->totalOptOuts = $totalOptOuts;
$this->view->totalSubscribers = $totalSubscribers;
//$this->view->totalCampaignMessages = $messageObj->getTotalCampaignMessagesCountByuser($userid);
$this->view->totalCampaignMessages = $messageObj->reportCountTotalCampaignMessagesByUserId($userid, $monthstartdate, $monthenddate);
// $this->view->totalCampaigns = $messageObj->getTotalCampaignCountByuser($userid);
$this->view->totalCampaigns = $messageObj->reportCountTotalCampaignsByUserId($userid, $monthstartdate, $monthenddate);
$monthstartdate = strtotime($ryear . "-" . $rmonth . "-01");
$todaydate = strtotime(date("Y-m-d"));
$currmonthperiod = round(($todaydate - $monthstartdate) / 86400);
$topThreeFolderArray = $messageObj->listTopthreeFolders($userid);
if (!empty($topThreeFolderArray)) {
foreach ($topThreeFolderArray as $key => $topThreeFolder) {
//$topThreeFolderArray[$key]['totalsubscriber'] = $messageObj->getTotalSubscriberByFolder($topThreeFolder['folderid']);
$topThreeFolderArray[$key]['totalsubscriber'] = $messageObj->totalSubscribersByFolder($topThreeFolder['folderid']);
//$topThreeFolderArray[$key]['totaloptins'] = $topThreeFolder['total']; //$messageObj->totalOptinsByFolder($topThreeFolder['folderid']);
$topThreeFolderArray[$key]['totaloptins'] = $messageObj->totalOptinsByFolder($topThreeFolder['folderid']);
$topThreeFolderArray[$key]['totaloptouts'] = $messageObj->totalOptoutsByFolder($topThreeFolder['folderid']);
//$topThreeFolderArray[$key]['totaloptouts'] = $messageObj->totalOptoutsByFolder($topThreeFolder['folderid']);
$topThreeFolderArray[$key]['totalcampaign'] = $messageObj->totalCampaignByFolder($topThreeFolder['folderid']);
}
//echo "<pre>"; print_r($topThreeFolderArray); exit;
}
// $topThreeKeywordArray = $messageObj->listTopthreeKeywords($userid);
$topThreeKeywordArray = $messageObj->listTopthreeKeywordsFilterDeleted($userid);
// new to restrict deleted keyword
if (!empty($topThreeKeywordArray)) {
foreach ($topThreeKeywordArray as $key => $topThreeKeyword) {
$topThreeKeywordArray[$key]['totalsubscriber'] = $messageObj->totalSubscribersByFolder($topThreeKeyword['folderid']);
$topThreeKeywordArray[$key]['totaloptins'] = $messageObj->totalOptinsByFolder($topThreeKeyword['folderid']);
//$messageObj->totalOptinsByKeyword($topThreeKeyword['keywordid']);
$topThreeKeywordArray[$key]['totaloptouts'] = $messageObj->totalOptoutsByFolder($topThreeKeyword['folderid']);
$topThreeKeywordArray[$key]['totalcampaign'] = $messageObj->totalCampaignByFolder($topThreeKeyword['folderid']);
}
}
$this->view->topThreeFolderDetails = $topThreeFolderArray;
$this->view->topThreeKeywordArray = $topThreeKeywordArray;
############ Calculating Start Date and End Date for Report ##################
$todate = date("Y-m-d h:i:s");
####Last Seven Days
$fromdate7 = strtotime('-6 day', strtotime($todate));
$fromdate7 = date('Y-m-d', $fromdate7);
####Last Fourteen Days
$fromdate14 = strtotime('-13 day', strtotime($todate));
$fromdate14 = date('Y-m-d', $fromdate14);
###Last Thirty Days
$fromdate30 = strtotime('-29 day', strtotime($todate));
$fromdate30 = date('Y-m-d', $fromdate30);
###Last Ninty Days
$fromdate90 = strtotime('-89 day', strtotime($todate));
$fromdate90 = date('Y-m-d', $fromdate90);
###Last 1 Year
$fromdate365 = strtotime('-364 day', strtotime($todate));
$fromdate365 = date('Y-m-d', $fromdate365);
##################### End of Calculation ####################################
// $this->view->totalOptIns_seven = $messageObj->getTotalOptInsPeriod($userid,6);
$this->view->totalOptIns_seven = $messageObj->reportCountTotalOptinsByUserId($userid, $fromdate7, $todate);
// $this->view->totalOptIns_forteen = $messageObj->getTotalOptInsPeriod($userid,13);
$this->view->totalOptIns_forteen = $messageObj->reportCountTotalOptinsByUserId($userid, $fromdate14, $todate);
//$this->view->totalOptIns_thirty = $messageObj->getTotalOptInsPeriod($userid,29);
$this->view->totalOptIns_thirty = $messageObj->reportCountTotalOptinsByUserId($userid, $fromdate30, $todate);
// $this->view->totalOptIns_ninty = $messageObj->getTotalOptInsPeriod($userid,89);
$this->view->totalOptIns_ninty = $messageObj->reportCountTotalOptinsByUserId($userid, $fromdate90, $todate);
//$this->view->totalOptIns_lastyear = $messageObj->getTotalOptInsPeriod($userid,364);
//$this->view->totalOptIns_lastyear = $messageObj->reportCountTotalOptinsByUserId($userid,$fromdate365,$todate);
$this->view->totalOptIns_lastyear = $messageObj->reportCountTotalOptinsByUserId($userid);
//$this->view->totalOptOuts_seven = $messageObj->getTotalOptOutsPeriod($userid,6);
$this->view->totalOptOuts_seven = $messageObj->reportCountTotalOptoutsByUserId($userid, $fromdate7, $todate);
//$this->view->totalOptOuts_forteen = $messageObj->getTotalOptOutsPeriod($userid,13);
$this->view->totalOptOuts_forteen = $messageObj->reportCountTotalOptoutsByUserId($userid, $fromdate14, $todate);
// $this->view->totalOptOuts_thirty = $messageObj->getTotalOptOutsPeriod($userid,29);
$this->view->totalOptOuts_thirty = $messageObj->reportCountTotalOptoutsByUserId($userid, $fromdate30, $todate);
//$this->view->totalOptOuts_ninty = $messageObj->getTotalOptOutsPeriod($userid,89);
$this->view->totalOptOuts_ninty = $messageObj->reportCountTotalOptoutsByUserId($userid, $fromdate90, $todate);
//$this->view->totalOptOuts_lastyear = $messageObj->getTotalOptOutsPeriod($userid,364);
//$this->view->totalOptOuts_lastyear = $messageObj->reportCountTotalOptoutsByUserId($userid,$fromdate365,$todate);
$this->view->totalOptOuts_lastyear = $messageObj->reportCountTotalOptoutsByUserId($userid);
//$this->view->totalCampaign_currmonth = $totalCampaign_currmonth;
// $this->view->totalCampaign_seven = $messageObj->totalCampaignByUser($userid,7);
$this->view->totalCampaign_seven = $messageObj->reportCountTotalCampaignsByUserId($userid, $fromdate7, $todate);
// $this->view->totalCampaign_forteen = $messageObj->totalCampaignByUser($userid,14);
$this->view->totalCampaign_forteen = $messageObj->reportCountTotalCampaignsByUserId($userid, $fromdate14, $todate);
//$this->view->totalCampaign_thirty = $messageObj->totalCampaignByUser($userid,30);
$this->view->totalCampaign_thirty = $messageObj->reportCountTotalCampaignsByUserId($userid, $fromdate30, $todate);
//$this->view->totalCampaign_ninty = $messageObj->totalCampaignByUser($userid,90);
$this->view->totalCampaign_ninty = $messageObj->reportCountTotalCampaignsByUserId($userid, $fromdate90, $todate);
//$this->view->totalCampaign_lastyear = $messageObj->totalCampaignByUser($userid,365);
//$this->view->totalCampaign_lastyear = $messageObj->reportCountTotalCampaignsByUserId($userid,$fromdate365,$todate);
$this->view->totalCampaign_lastyear = $messageObj->reportCountTotalCampaignsByUserId($userid);
}
