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); }