<?php

class Marketing_CampaignController extends Catabatic_ValidateGtx
{
    public $baseUrl;
    private $intLoggedinUserId;
    private $intLoggedinUserAgencySysId;
    public $marketingMdl;

    public function init()
    {
        parent::init();
        $aConfig = $this->getInvokeArg('bootstrap')->getOptions();
        $BootStrap = $aConfig['bootstrap'];
        $this->baseUrl = $BootStrap['siteUrl'];
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
        $this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
    }

    public function indexAction()
    {
        $id = $this->getRequest()->getParam('id');
        $tempId = $this->getRequest()->getParam('tempId');
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $this->view->agencyTitle = $agencyTitle = $sessionLogin_user->agencyDetails['Title'];
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();

        $getAllCampaignData = $this->marketingMdl->GetAllMarkrtingCampaignDataDefault(0, $agencySysId);

        //echo "<pre>";print_r($getAllCampaignData);exit;
        $campaignDataArray = array();
        $TitleName = '';
        foreach ($getAllCampaignData as $campKey => $campValue) {
            $scheduleDate = (isset($campValue['ScheduleDate']) && $campValue['ScheduleDate'] != '') ? $campValue['ScheduleDate']->format("d-m-Y") : '';
            $campaignDataArray[] = [
                'ListSysId' => $campValue['ListSysId'],
                'CampaignSysId' => $campValue['CampaignSysId'],
                'TemplateSysId' => $campValue['TemplateSysId'],
                'TemplateCategoryId' => $campValue['TemplateCategoryId'],
                'Title' => $campValue['Title'],
                'CampaignRunDate' => ($campValue['CampaignRunDate'] != '') ? $campValue['CampaignRunDate']->format("d/m/Y H:i") : '--',
                'CampaignlaunchStatus' => ($campValue['CampaignlaunchStatus'] != '') ? $campValue['CampaignlaunchStatus'] : '--',
                'EmailStatus' => $campValue['EmailStatus'],
                'NoofContact' => $campValue['NoofContact'],
                'Recipients' => $campValue['Recipients'],
                'Failed' => $campValue['Failed'],
                'Delivered' => $campValue['Delivered'],
                'Pending' => $campValue['Pending'],
                'Opened' => $campValue['Opened'],
                'Clicked' => $campValue['Clicked'],
                'Unsubscribed' => $campValue['Unsubscribed'],
                'Abusereports' => $campValue['Abusereports'],
                'IsPersonalized' => $campValue['IsPersonalized'],
                'listTitle' => ($campValue['listTitle'] != '') ? $campValue['listTitle'] : '--',
                'TemplateName' => ($campValue['TemplateName'] != '' && $campValue['TemplateIsMarkForDelete'] == 0) ? $campValue['TemplateName'] : '',
                'scheduleDate' => (isset($scheduleDate) && $scheduleDate !='01-01-1900' && $scheduleDate != '') ? $campValue['ScheduleDate']->format("d-M-y H:i") : ($campValue['CampaignlaunchStatus']!= 1 ? '--' : date('d-M-y H:i')),
            ];
        }
        if (isset($id)) {
            $getCountAllContactByIdArr = $this->marketingMdl->GetCountAllContactById($agencySysId, base64_decode($id));
            $this->view->AllContact = $getCountAllContactByIdArr[0]['rows'];
        }
        $paginator = Zend_Paginator::factory($campaignDataArray);
        $pageNumber = $this->_getParam('page', 1);
        $paginator->setCurrentPageNumber($pageNumber);
        $paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
        $this->view->campaignDataArray = $paginator;
        $this->view->baseUrl = $this->baseUrl;
        $this->view->id = $id;
        $this->view->tempId = $tempId;
    }

    public function createCampaignAction()
    {
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $this->view->agencyTitle = $agencyTitle = $sessionLogin_user->agencyDetails['Title'];
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $id = $this->getRequest()->getParam('id');
        $mode = $this->getRequest()->getParam('mode');
        $campId = $this->getRequest()->getParam('campId');
        $tempId = $this->getRequest()->getParam('tempId');
        $this->view->id = $id;
        $this->view->campId = $campId;
        $this->view->mode = $mode;
        $this->view->tempId = !empty($tempId)?base64_decode($tempId):null;
        $this->marketingMdl = new Marketing_Model_Marketing();
        $getAllListData = $this->marketingMdl->GetAllMarkrtingListDataForCampaign($agencySysId);
        if (isset($campId)) {
            $getAllCampaignDataById = $this->marketingMdl->GetAllMarkrtingCampaignData($agencySysId, base64_decode($campId));
            $this->view->getAllCampaignDataById = $getAllCampaignDataById;
        }
        if (isset($id)) {
            $getCountAllContactByIdArr = $this->marketingMdl->GetCountAllContactById($agencySysId, base64_decode($id));
            $this->view->AllContact = $getCountAllContactByIdArr[0]['rows'];
        }
        //        echo "<pre>";print_r($getAllCampaignDataById);die;
        $listDataArray = array();
        $campaignUserArray = array();
        foreach ($getAllListData as $listKey => $listValue) {
            $listDataArray[] = [
                'ListSysId' => $listValue['ListSysId'],
                'AgencySysId' => $listValue['AgencySysId'],
                'Title' => $listValue['Title'],
                'FromEmailId' => $listValue['FromEmailId'],
                'FromEmailName' => $listValue['FromEmailName'],
            ];
        }

        if ($this->getRequest()->isPost()) {
            $param = $this->getRequest()->getParams();

            if ($param['NoofContact'] > 0) {
                $checkLaunchStatus = $this->marketingMdl->GetAllMarkrtingCampaignDataCheckLaunch($agencySysId,  base64_decode($campId));
                if (empty($checkLaunchStatus)) {
                    $editDataArray['IsMarkForDelete'] = 1;
                    $updateCamp = $this->marketingMdl->updateTable("TB_Agency_Marketing_Campaign", $editDataArray, ['CampaignSysId =?' => base64_decode($campId)]);
                }

                $saveDataArray = [
                    'MasterCampaignSysId' => 0,
                    'AgencySysId' => $agencySysId,
                    'ListSysId' => $param['selectedList'],
                    'TemplateSysId' => 0,
                    'Title' => $param['landingPageName'],
                    'FromEmailId' => trim($param['campaignFromEmailAddress']),
                    'FromEmailName' => $param['campaignFromName'],
                    'CreatedDate' => date('Y-m-d H:i:s'),
                    'CampaignRunDate' => '',
                    'NoofContact' => $param['NoofContact'],
                    'CampaignlaunchStatus' => 0,
                    'IsActive' => 1,
                    'IsMarkForDelete' => 0,
                    'IsPersonalized' => 0,
                ];
                $CampaignSysId = $this->marketingMdl->insertTable("TB_Agency_Marketing_Campaign", $saveDataArray);

                //                $contactListArray = $this->marketingMdl->GetAllSubscribedContactListDataById($agencySysId, $param['selectedList']);
                //                if ($CampaignSysId != '') {
                //                    foreach ($contactListArray as $contKey => $contValue) {
                //
                //                        $campaignUserArray = [
                //                            'AgencySysId' => $agencySysId,
                //                            'CampaignSysId' => $CampaignSysId,
                //                            'CustomerSysId' => $contValue['CustSysId'],
                //                            'CreatedDate' => date('Y-m-d H:i:s'),
                //                            'SentStatus' => 0,
                //                            'EmailTackCode' => 0,
                //                            'EmailTackStatus' => 0,
                //                            'IsActive' => 1,
                //                            'IsMarkForDelete' => 0,
                //                        ];
                //                        $CampaignMapUserSysId[] = $this->marketingMdl->insertTable("TB_Agency_Marketing_Campaign_User", $campaignUserArray);
                //                    }
                //                }

                if ($CampaignSysId != '') {
                    $this->marketingMdl->copyDataFromListToCampaign((int) $agencySysId, (int) $param['selectedList'], (int) $CampaignSysId);
                    $this->_redirect($this->baseUrl . 'marketing/template/index/id/' . base64_encode($param['selectedList']) . '/campId/' . base64_encode($CampaignSysId));
                }
            } else {
                $this->_redirect($this->baseUrl . 'marketing/list/import-members-setup/id/' . base64_encode($param['selectedList']) . '?type=copyPaste');
            }
        }




        $this->view->listDataArray = $listDataArray;
        $this->view->baseUrl = $this->baseUrl;
    }

    public function getListDetailByIdAction()
    {
        $this->view->layout()->disableLayout();
        $this->_helper->viewRenderer->setNoRender(true);
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();
        if ($this->getRequest()->isPost()) {
            $param = $this->getRequest()->getParams();
            $listId = $param['listId'];
            $getAllListDataByIdArr = array();
            //$getAllListDataByIdArr = $this->marketingMdl->GetAllMarkrtingListDataByLeadId($agencySysId, $listId);
            $getCountAllContactByIdArr = $this->marketingMdl->GetCountAllContactById($agencySysId, $listId);
            $secureCode = Catabatic_ValidateCustomer::secureCode(base64_encode(trim($listId)), 1);
            echo json_encode(array('status' => true, 'listId' => $listId, 'secureCode' => $secureCode, 'data' => $getAllListDataByIdArr, 'count' => $getCountAllContactByIdArr[0]['rows']));
            exit;
        } else {
            echo json_encode(array('status' => false));
            exit;
        }
    }

    public function reportAction()
    {
        $this->view->baseUrl = $this->baseUrl;
        $param = $this->getRequest()->getParams();
        $campaignSysId = base64_decode($param['id']);
        $this->marketingMdl = new Marketing_Model_Marketing();
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $getAllCampaignData = $this->marketingMdl->GetAllMarkrtingCampaignData($agencySysId, $campaignSysId);
        $this->view->campaignDataArray = $getAllCampaignData;
    }

    public function getUserDataFromCampaignAction()
    {
        $param = $this->getRequest()->getParams();
        $campaignSysId = $param['id'];
        $statusSysId = $param['status'];
        $this->view->baseUrl = $this->baseUrl;
        $this->marketingMdl = new Marketing_Model_Marketing();
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $getAllCampaignDataReport = $this->marketingMdl->GetAllMarkrtingCampaignData($agencySysId, $campaignSysId);
        $this->view->campaignDataArray1 = $getAllCampaignDataReport;
        $getAllCampaignData = $this->marketingMdl->getUserInCampaingn($agencySysId, $campaignSysId, $statusSysId);
        $perpageCount = 100;
        if ($statusSysId == 'RmFpbGVk') {
            $perpageCount = 1000;
        }
        $paginator = Zend_Paginator::factory($getAllCampaignData);
        $pageNumber = $this->_getParam('page', 1);
        $paginator->setCurrentPageNumber($pageNumber);
        $paginator->setItemCountPerPage($perpageCount);
        // $this->view->contactListArray = $paginator;

        $this->view->currentPage = $pageNumber;
        $this->view->campaignSysId = $campaignSysId;
        $this->view->campaignDataArray = $paginator;
    }

    public function updateEmailStatusAction()
    {
        $this->view->layout()->disableLayout();
        $this->_helper->viewRenderer->setNoRender(true);
        if ($this->getRequest()->isPost()) {
            $param = $this->getRequest()->getParams();
            $CampaignSysId = (int) $param['CampaignSysId'];
            $IsPersonalized = 1;
            $getReort = $this->getEmailStatus($CampaignSysId, $IsPersonalized);
            $this->_redirect('marketing/campaign/report/status/' . $getReort . '/id/' . base64_encode($param['CampaignSysId']));
            exit;
        }
    }

    public function updateEmailStatusAjaxAction()
    {
        $this->view->layout()->disableLayout();
        $this->_helper->viewRenderer->setNoRender(true);
        if ($this->getRequest()->isPost()) {
            $param = $this->getRequest()->getParams();
            $CampaignSysId = (int) $param['CampaignSysId'];
            $IsPersonalized = 2;
            $this->getEmailStatusGetDetail($CampaignSysId, $IsPersonalized);
            echo $response = json_encode(array("status" => true));
            exit;
        }
    }

    private function getEmailStatus($CampaignSysId, $IsPersonalized)
    {
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();
        $currencyModel = new Gtxwebservices_Model_Currency();
        $data = $this->marketingMdl->getEmailTrackStatusFromCampData($agencySysId, $CampaignSysId);
        if (!empty($data)) {
            $showData = $currencyModel->getEmailStatusForMarketing($data['EmailTackCode']);
            $result = json_decode($showData);
            //echo "<pre>";print_r($showData);exit;
            if ($result->status != FALSE) {
                $updateArray = [
                    'EmailStatus' => $result->status,
                    'Recipients' => (int) $result->recipients,
                    'Failed' => (int) $result->failed,
                    'Delivered' => (int) $result->delivered,
                    'Pending' => (int) $result->pending,
                    'Opened' => 0,
                    'Clicked' => 0,
                    'Unsubscribed' => 0,
                    'Abusereports' => 0,
                ];
                $updateCamp = $this->marketingMdl->updateTable("TB_Agency_Marketing_Campaign", $updateArray, ['EmailTackCode =?' => $data['EmailTackCode']]);
                return true;
            } else {
                return false;
            }
        } else {
            return false;
        }
    }

    private function getEmailStatusGetDetail($CampaignSysId, $IsPersonalized)
    {
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();
        $currencyModel = new Gtxwebservices_Model_Currency();
        $data = $this->marketingMdl->getEmailTrackStatusFromCampData($agencySysId, $CampaignSysId);
        if (!empty($data)) {
            $showData = $currencyModel->getEmailStatusForMarketingShowDetails($data['EmailTackCode']);
            $result = json_decode($showData);
            //echo "<pre>";print_r($showData);exit;
            if ($result->status != FALSE) {
                $updateArray = [
                    'EmailStatus' => $result->status,
                    'Recipients' => (int) $result->recipients,
                    'Failed' => (int) $result->failed,
                    'Delivered' => (int) $result->delivered,
                    'Pending' => (int) $result->pending,
                    'Opened' => (int) $result->opened,
                    'Clicked' => (int) $result->clicked,
                    'Unsubscribed' => (int) $result->unsubscribed,
                    'Abusereports' => (int) $result->abusereports,
                ];
                //echo "<pre>";print_r($updateArray); exit;
                $this->updateCampaignUserWiseData($data['EmailTackCode'], $updateArray, $CampaignSysId, $agencySysId);
                $updateCamp = $this->marketingMdl->updateTable("TB_Agency_Marketing_Campaign", $updateArray, ['EmailTackCode =?' => $data['EmailTackCode']]);
                return true;
            } else {
                return false;
            }
        } else {
            return false;
        }
    }

    public function updateCampaignUserWiseData($emailTrackCode, $trackArray, $CampaignSysId, $agencySysId)
    {
        $modelCurrency = new Gtxwebservices_Model_Currency();
        $modelMarketing = new Marketing_Model_Marketing();
        if (!empty($trackArray) && (isset($trackArray['EmailStatus']) && ($trackArray['EmailStatus'] == "complete" || $trackArray['EmailStatus'] == "in_progress"))) {
            if (isset($trackArray['Delivered']) && $trackArray['Delivered'] > 0) {
                $showDeliveredData = $modelCurrency->getEmailStatusForMarketingShowDetails($emailTrackCode, "delivered");
                $resultDelivered = json_decode($showDeliveredData);
                //echo "<pre>";print_r($resultDelivered);exit;
                if (isset($resultDelivered->delivered->address) && !empty($resultDelivered->delivered->address)) {
                    if (is_array($resultDelivered->delivered->address)) {
                        $Delivered = "Delivered";
                        $emailIdArray = $resultDelivered->delivered->address;
                        $arrayChunk = array_chunk($emailIdArray, 1000);
                        for ($ch = 0; $ch < count($arrayChunk); $ch++) {
                            $modelMarketing->updateCampaignUserWiseDataModel($arrayChunk[$ch], $CampaignSysId, $agencySysId, $Delivered);
                        }
                    } else {
                        if ((isset($resultDelivered->delivered->address)) && ($resultDelivered->delivered->address != "")) {
                            $Delivered = "Delivered";
                            $emailIdArray = array($resultDelivered->delivered->address);
                            $modelMarketing->updateCampaignUserWiseDataModel($emailIdArray, $CampaignSysId, $agencySysId, $Delivered);
                        }
                    }
                }
            }
            if (isset($trackArray['Opened']) && $trackArray['Opened'] > 0) {
                $showDeliveredData = $modelCurrency->getEmailStatusForMarketingShowDetails($emailTrackCode, "opened");
                $resultDelivered = json_decode($showDeliveredData);
                if (isset($resultDelivered->opened->address) && !empty($resultDelivered->opened->address)) {
                    if (is_array($resultDelivered->opened->address)) {
                        $Delivered = "Opened";
                        $emailIdArray = $resultDelivered->opened->address;
                        $arrayChunk = array_chunk($emailIdArray, 1000);
                        for ($ch = 0; $ch < count($arrayChunk); $ch++) {
                            $modelMarketing->updateCampaignUserWiseDataModel($arrayChunk[$ch], $CampaignSysId, $agencySysId, $Delivered);
                        }
                    } else {
                        if ($resultDelivered->opened->address != "") {
                            $Delivered = "Opened";
                            $emailIdArray = array($resultDelivered->opened->address);
                            $modelMarketing->updateCampaignUserWiseDataModel($emailIdArray, $CampaignSysId, $agencySysId, $Delivered);
                        }
                    }
                }
            }
            if (isset($trackArray['Clicked']) && $trackArray['Clicked'] > 0) {
                $showDeliveredData = $modelCurrency->getEmailStatusForMarketingShowDetails($emailTrackCode, "clicked");
                $resultDelivered = json_decode($showDeliveredData);
                if (isset($resultDelivered->clicked->address) && !empty($resultDelivered->clicked->address)) {
                    if (is_array($resultDelivered->clicked->address)) {
                        $Delivered = "Clicked";
                        $emailIdArray = $resultDelivered->clicked->address;
                        $arrayChunk = array_chunk($emailIdArray, 1000);
                        for ($ch = 0; $ch < count($arrayChunk); $ch++) {
                            $modelMarketing->updateCampaignUserWiseDataModel($arrayChunk[$ch], $CampaignSysId, $agencySysId, $Delivered);
                        }
                    } else {
                        if ((isset($resultDelivered->clicked->address)) && ($resultDelivered->clicked->address != "")) {
                            $Delivered = "Clicked";
                            $emailIdArray = array($resultDelivered->clicked->address);
                            $modelMarketing->updateCampaignUserWiseDataModel($emailIdArray, $CampaignSysId, $agencySysId, $Delivered);
                        }
                    }
                }
            }
            if (isset($trackArray['Failed']) && $trackArray['Failed'] > 0) {
                $showDeliveredData = $modelCurrency->getEmailStatusForMarketingShowDetails($emailTrackCode, "failed");
                $resultDelivered = json_decode($showDeliveredData);
                if (isset($resultDelivered->failed->address) && !empty($resultDelivered->failed->address)) {
                    if (is_array($resultDelivered->failed->address)) {
                        $Delivered = "Failed";
                        $emailIdArray = $resultDelivered->failed->address;
                        $arrayChunk = array_chunk($emailIdArray, 1000);
                        for ($ch = 0; $ch < count($arrayChunk); $ch++) {
                            $modelMarketing->updateCampaignUserWiseDataModel($arrayChunk[$ch], $CampaignSysId, $agencySysId, $Delivered);
                        }
                    } else {
                        if ((isset($resultDelivered->failed->address)) && ($resultDelivered->failed->address != "")) {
                            $Delivered = "Failed";
                            $emailIdArray = array($resultDelivered->failed->address);
                            $modelMarketing->updateCampaignUserWiseDataModel($emailIdArray, $CampaignSysId, $agencySysId, $Delivered);
                        }
                    }
                }
            }
            if (isset($trackArray['Unsubscribed']) && $trackArray['Unsubscribed'] > 0) {
                $showDeliveredData = $modelCurrency->getEmailStatusForMarketingShowDetails($emailTrackCode, "unsubscribed");
                $resultDelivered = json_decode($showDeliveredData);
                if (isset($resultDelivered->unsubscribed->address) && !empty($resultDelivered->unsubscribed->address)) {
                    if (is_array($resultDelivered->unsubscribed->address)) {
                        $Delivered = "Unsubscribed";
                        $emailIdArray = $resultDelivered->unsubscribed->address;
                        $arrayChunk = array_chunk($emailIdArray, 1000);
                        for ($ch = 0; $ch < count($arrayChunk); $ch++) {
                            $modelMarketing->updateCampaignUserWiseDataModel($arrayChunk[$ch], $CampaignSysId, $agencySysId, $Delivered);
                        }
                    } else {
                        if ((isset($resultDelivered->unsubscribed->address)) && ($resultDelivered->unsubscribed->address != "")) {
                            $Delivered = "Unsubscribed";
                            $emailIdArray = array($resultDelivered->unsubscribed->address);
                            $modelMarketing->updateCampaignUserWiseDataModel($emailIdArray, $CampaignSysId, $agencySysId, $Delivered);
                        }
                    }
                }
            }
        }
    }

    public function deleteCampaignAction()
    {

        $this->view->layout()->disableLayout();
        $this->_helper->viewRenderer->setNoRender(true);
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $agencysysID = $sessionLogin_user->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();
        $CampaignSysIds = $this->getRequest()->getParam('data');

        if (!empty($CampaignSysIds)) {
            for ($m = 0; $m < count($CampaignSysIds); $m++) {
                $id = $CampaignSysIds[$m];
                $editDataArray = [
                    'IsMarkForDelete' => 1
                ];
                $updateArray[] = $this->marketingMdl->updateTable("TB_Agency_Marketing_Campaign", $editDataArray, ['CampaignSysId =?' => $id]);
            }
        }

        if (!empty($updateArray)) {
            echo json_encode(array('status' => 'success', 'CampaignSysId' => $CampaignSysIds, 'count' => count($CampaignSysIds)));
            exit;
        }
    }

    public function defaultCampaignAction()
    {
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $this->view->agencyTitle = $agencyTitle = $sessionLogin_user->agencyDetails['Title'];
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();
        $id = $this->getRequest()->getParam('id');
        $filterdata = $this->getRequest()->getParam('filter');
        if (isset($filterdata) && $filterdata != '') {
            $this->view->filterCampaign = $filterdata;
            $this->marketingMdl->filterCampaign = $filterdata;
        }
        $getAllCampaignData = $this->marketingMdl->GetAllMarkrtingCampaignDataDefault(1, $agencySysId);
       
        $campaignDataArray = array();
        $TitleName = '';
        foreach ($getAllCampaignData as $campKey => $campValue) {
            $campaignDataArray[] = [
                'ListSysId' => $campValue['ListSysId'],
                'CampaignSysId' => $campValue['CampaignSysId'],
                'TemplateSysId' => $campValue['TemplateSysId'],
                'TemplateCategoryId' => $campValue['TemplateCategoryId'],
                'Title' => $campValue['Title'],
                'CampaignRunDate' => ($campValue['CampaignRunDate'] != '') ? $campValue['CampaignRunDate']->format("d/m/Y H:i") : '--',
                'CampaignlaunchStatus' => ($campValue['CampaignlaunchStatus'] != '') ? $campValue['CampaignlaunchStatus'] : '--',
                'EmailStatus' => $campValue['EmailStatus'],
                'NoofContact' => $campValue['NoofContact'],
                'Recipients' => $campValue['Recipients'],
                'Failed' => $campValue['Failed'],
                'Delivered' => $campValue['Delivered'],
                'Pending' => $campValue['Pending'],
                'Opened' => $campValue['Opened'],
                'Clicked' => $campValue['Clicked'],
                'Unsubscribed' => $campValue['Unsubscribed'],
                'Abusereports' => $campValue['Abusereports'],
                'IsPersonalized' => $campValue['IsPersonalized'],
                'listTitle' => ($campValue['listTitle'] != '') ? $campValue['listTitle'] : '--',
                'TemplateName' => ($campValue['TemplateName'] != '' && $campValue['TemplateIsMarkForDelete'] == 0) ? $campValue['TemplateName'] : '--'
            ];
        }
        if (isset($id)) {
            $getCountAllContactByIdArr = $this->marketingMdl->GetCountAllContactById($agencySysId, base64_decode($id));
            $this->view->AllContact = $getCountAllContactByIdArr[0]['rows'];
        }
        $paginator = Zend_Paginator::factory($campaignDataArray);
        $pageNumber = $this->_getParam('page', 1);
        $paginator->setCurrentPageNumber($pageNumber);
        $paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
        $this->view->campaignDataArray = $paginator;
        $this->view->baseUrl = $this->baseUrl;
        $this->view->id = $id;
    }

    public function campaignReportAction()
    {

        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $this->view->agencyTitle = $agencyTitle = $sessionLogin_user->agencyDetails['Title'];
        $agencySysId = $this->intLoggedinUserAgencySysId;
        $this->marketingMdl = new Marketing_Model_Marketing();

        $getAllCampaignData = $this->marketingMdl->GetAllMarkrtingCampaignDataReport($agencySysId);

        //echo "<pre>";print_r($getAllCampaignData);exit;
        $campaignDataArray = array();
        $TitleName = '';
        foreach ($getAllCampaignData as $campKey => $campValue) {
            $campaignDataArray[] = [
                'ListSysId' => $campValue['ListSysId'],
                'CampaignSysId' => $campValue['CampaignSysId'],
                'TemplateSysId' => $campValue['TemplateSysId'],
                'TemplateCategoryId' => $campValue['TemplateCategoryId'],
                'Title' => $campValue['Title'],
                'CampaignRunDate' => ($campValue['CampaignRunDate'] != '') ? $campValue['CampaignRunDate']->format("d/m/Y H:i") : '--',
                'CampaignlaunchStatus' => ($campValue['CampaignlaunchStatus'] != '') ? $campValue['CampaignlaunchStatus'] : '--',
                'EmailStatus' => $campValue['EmailStatus'],
                'NoofContact' => $campValue['NoofContact'],
                'Recipients' => $campValue['Recipients'],
                'Failed' => $campValue['Failed'],
                'Delivered' => $campValue['Delivered'],
                'Pending' => $campValue['Pending'],
                'Opened' => $campValue['Opened'],
                'Clicked' => $campValue['Clicked'],
                'Unsubscribed' => $campValue['Unsubscribed'],
                'Abusereports' => $campValue['Abusereports'],
                'IsPersonalized' => $campValue['IsPersonalized'],
                'listTitle' => ($campValue['listTitle'] != '') ? $campValue['listTitle'] : '--',
                'TemplateName' => ($campValue['TemplateName'] != '' && $campValue['TemplateIsMarkForDelete'] == 0) ? $campValue['TemplateName'] : ''
            ];
        }

        $paginator = Zend_Paginator::factory($campaignDataArray);
        $pageNumber = $this->_getParam('page', 1);
        $paginator->setCurrentPageNumber($pageNumber);
        $paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
        $this->view->campaignDataArray = $paginator;
        $this->view->baseUrl = $this->baseUrl;
    }
}