public function reportAction() { $monthstartdate = $this->request->getParam('startdate'); $monthenddate = $this->request->getParam('enddate'); $searchvalue = ""; $yearmonth = $this->request->getParam('yearmonth'); // echo $monthstartdate."<>".$monthenddate; // exit; $filename = 'myreport'; $file_path = "/home/textm/textmunication.com/htdocs/public/reportdocs/{$filename}"; header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".csv"); header("Content-disposition: filename=" . $filename . ".csv"); echo "Accounts/Location/Folder,Total Keyword,Total Subscribers,Total Optsin,Total Optsout,Total Campaign,Total Campaign Message,Retention\r\n"; $reportObj = new Application_Model_Report(); $datareport = new Application_Model_DataReporting(); $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; $subUsersArray = $datareport->corporate_message_reporting($userid, $yearmonth, $monthstartdate, $monthenddate); $totalSubUsers = count($subUsersArray); if ($totalSubUsers > 0) { foreach ($subUsersArray as $key => $row) { $username[$key] = $row['username']; } } else { $subUsersArray = ''; } $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(); $arraystart = 0; $arrayend = $totalSubUsers; if (!empty($subUsersArray)) { for ($i = $arraystart; $i < $arrayend; $i++) { if (!empty($subUsersArray[$i])) { echo $allDetailsArray[$i] = $subUsersArray[$i]['firstname'] . " " . $subUsersArray[$i]['lastname']; echo "," . ($allDetailsArray[$i] = $subUsersArray[$i]['keywords']); echo "," . ($allDetailsArray[$i] = $subUsersArray[$i]['optin']); echo "," . ($allDetailsArray[$i] = $subUsersArray[$i]['subscribers']); echo "," . ($allDetailsArray[$i] = $subUsersArray[$i]['optout']); echo "," . ($allDetailsArray[$i] = $subUsersArray[$i]['campaign']); echo "," . ($allDetailsArray[$i] = $subUsersArray[$i]['sms']); if ($subUsersArray[$i]['optin'] != 0) { echo "," . $subUsersArray[$i]['subscribers'] / $subUsersArray[$i]['optin'] * 100; } else { echo "," . "0"; } echo "%"; echo "\r\n"; } } } else { $this->view->userTypeshowing = 'locations'; $subFoldersArray = $reportObj->findChildEntityList($userid, 4); //echo "<pre>"; print_r($subFoldersArray); echo exit; $totalSubUsers = count($subFoldersArray); } } else { $this->view->userTypeshowing = 'locations'; // $subFoldersArray = $reportObj->findChildEntityList($userid,4); //echo "<pre>"; print_r($subFoldersArray); echo exit; $subFoldersArray = $datareport->account_message_reporting($userid, $yearmonth, $monthstartdate, $monthenddate); $totalSubUsers = count($subFoldersArray); for ($i = 0; $i < $totalSubUsers; $i++) { if (!empty($subFoldersArray[$i])) { echo $allDetailsArray[$i] = $subFoldersArray[$i]['value']; echo "," . ($allDetailsArray[$i] = $subFoldersArray[$i]['keywords']); echo "," . ($allDetailsArray[$i] = $subFoldersArray[$i]['optin']); echo "," . ($allDetailsArray[$i] = $subFoldersArray[$i]['subscribers']); echo "," . ($allDetailsArray[$i] = $subFoldersArray[$i]['optout']); echo "," . ($allDetailsArray[$i] = $subFoldersArray[$i]['campaign']); echo "," . ($allDetailsArray[$i] = $subFoldersArray[$i]['total_messages']); if ($subFoldersArray[$i]['optin'] != 0) { echo "," . $subFoldersArray[$i]['subscribers'] / $subFoldersArray[$i]['optin'] * 100; } else { echo "," . "0"; } echo "%"; //echo "i am here"; echo "\r\n"; } } } exit; }
public function createAction() { $error = null; $message = null; $userid = $this->user->getId(); $username = $this->user->username(); $formObj = new Application_Model_Form(); $reportObj = new Application_Model_Report(); $webformListSubAccount = array(); if ($reportObj->checkAdminUser($userid)) { $subUsersArray = $reportObj->findChildEntityList($userid, 5, ""); //echo "<pre>"; print_r($subUsersArray); exit; foreach ($subUsersArray as $subuser) { $webformlistmerge = $formObj->webformList($subuser['childuserid']); if (!empty($webformlistmerge) and is_array($webformlistmerge)) { $webformListSubAccount = array_merge($webformListSubAccount, $webformlistmerge); } } //echo "<pre>"; print_r($webformListSubAccount); exit; } if ($this->request->isPost()) { //echo "<pre>"; print_r($this->_request->getParams()); exit; $postdataValue = $this->_request->getParams(); //echo '<pre>'; print_r($postdataValue);exit; $this->view->postedValues = $postdataValue; if ($this->request->getParam('formurl') == "") { $message['type'] = "error"; $message['body'] = "Atleast Unique URL is required"; } else { $createformfor = ""; if ($this->request->getParam('subacc') == "on") { $folderidArray = "subacc"; } else { $folderidArray = $this->request->getParam('folderid'); } // echo '<pre>'; print_r($folderidArray); exit; if (!empty($folderidArray)) { $webformUrlArray = array(); $weburl = trim($this->request->getParam('formurl')); $weburlfilter = preg_replace('/[^a-z0-9]/', '-', $weburl); if ($folderidArray == "subacc") { foreach ($subUsersArray as $subuser) { $userid = $subuser['childuserid']; $folderids = $this->user->getFolderElseCreate("weboptin", $userid); $webformUrlArray = array("entityid" => $userid, "urlname" => addslashes($weburlfilter), "thankumsg" => addslashes($this->request->getParam('thanku_message')), "descmsg" => addslashes($this->request->getParam('formdesc')), "folderid" => $folderids, "dobstatus" => addslashes($this->request->getParam('dobstatus')), "alertmessage" => addslashes($this->request->getParam('alertmessage')), "notifybysms" => $this->request->getParam('notifybysms'), "notifybyemail" => addslashes($this->request->getParam('notifybyemail'))); $webformAttbArray = $this->request->getParam('chkname'); //echo "<pre>"; print_r($webformAttbArray); $webformAttbTypeArray = $this->request->getParam('chktype'); //echo "<pre>"; print_r($webformAttbTypeArray); $webformAttbWeightage = $this->request->getParam('weightage'); //echo "<pre>"; print_r($webformAttbTypeArray); //echo "<pre>"; print_r($this->request->getParam('chk')); foreach ($this->request->getParam('chk') as $key => $checked) { $webformAttbArrayToinsert[$key]['weightage'] = addslashes($webformAttbWeightage[$checked]); $webformAttbArrayToinsert[$key]['attb'] = addslashes($webformAttbArray[$checked]); $webformAttbArrayToinsert[$key]['attbtype'] = addslashes($webformAttbTypeArray[$checked]); $webformAttbOptionArray = $this->request->getParam('chkvalue' . $checked); //echo "<pre>"; print_r($webformAttbOptionArray); if (!empty($webformAttbOptionArray)) { $webformAttbOptionString = implode(",", $webformAttbOptionArray); } else { $webformAttbOptionString = ""; } $webformAttbArrayToinsert[$key]['attboption'] = addslashes($webformAttbOptionString); } //echo "<pre>"; print_r($webformAttbArrayToinsert); exit; if (empty($webformAttbArrayToinsert)) { $message['type'] = "error"; $message['body'] = "Please check atleast one information field"; } elseif (empty($folderidArray)) { $message['type'] = "error"; $message['body'] = "Please choose atleast one folder"; } else { $dataInserted = $formObj->insertFormDetails($webformUrlArray, $webformAttbArrayToinsert); if ($dataInserted) { $message['type'] = "success"; $message['body'] = "Form created successfully"; } else { $message['type'] = "error"; $message['body'] = $formObj->getError(); } } } $this->_redirector->gotoUrl('/form/create/'); } else { $folderids = implode($folderidArray, ','); $webformUrlArray = array("entityid" => $userid, "urlname" => addslashes($weburlfilter), "thankumsg" => addslashes($this->request->getParam('thanku_message')), "descmsg" => addslashes($this->request->getParam('formdesc')), "folderid" => $folderids, "dobstatus" => addslashes($this->request->getParam('dobstatus')), "alertmessage" => addslashes($this->request->getParam('alertmessage')), "notifybysms" => $this->request->getParam('notifybysms'), "notifybyemail" => addslashes($this->request->getParam('notifybyemail'))); $webformAttbArray = $this->request->getParam('chkname'); //echo "<pre>"; print_r($webformAttbArray); $webformAttbTypeArray = $this->request->getParam('chktype'); //echo "<pre>"; print_r($webformAttbTypeArray); $webformAttbWeightage = $this->request->getParam('weightage'); //echo "<pre>"; print_r($webformAttbTypeArray); //echo "<pre>"; print_r($this->request->getParam('chk')); foreach ($this->request->getParam('chk') as $key => $checked) { $webformAttbArrayToinsert[$key]['weightage'] = addslashes($webformAttbWeightage[$checked]); $webformAttbArrayToinsert[$key]['attb'] = addslashes($webformAttbArray[$checked]); $webformAttbArrayToinsert[$key]['attbtype'] = addslashes($webformAttbTypeArray[$checked]); $webformAttbOptionArray = $this->request->getParam('chkvalue' . $checked); //echo "<pre>"; print_r($webformAttbOptionArray); if (!empty($webformAttbOptionArray)) { $webformAttbOptionString = implode(",", $webformAttbOptionArray); } else { $webformAttbOptionString = ""; } $webformAttbArrayToinsert[$key]['attboption'] = addslashes($webformAttbOptionString); } //echo "<pre>"; print_r($webformAttbArrayToinsert); exit; if (empty($webformAttbArrayToinsert)) { $message['type'] = "error"; $message['body'] = "Please check atleast one information field"; } elseif (empty($folderidArray)) { $message['type'] = "error"; $message['body'] = "Please choose atleast one folder"; } else { $dataInserted = $formObj->insertFormDetails($webformUrlArray, $webformAttbArrayToinsert); if ($dataInserted) { $message['type'] = "success"; $message['body'] = "Form created successfully"; } else { $message['type'] = "error"; $message['body'] = $formObj->getError(); } } } } else { $message['type'] = "error"; $message['body'] = "Please select atleast one folder from dropdown."; } } } $user = new Application_Model_User((int) $userid); $this->view->message = $message; $this->view->folders = $this->user->getFolders(); $this->view->webformlist = $formObj->webformList($userid); $this->view->webformlistSubaccount = $webformListSubAccount; $this->view->business = $user->businessname; $this->view->ainfo = $user->reward; $this->view->userid = $userid; }