public function graphdetails($postarray) { if (isset($postarray['userid']) && $postarray['userid'] != '') { $where = ''; if (isset($postarray['eventid']) && $postarray['eventid'] != '') { $eventId = $postarray['eventid']; $where .= ' AND ue.event_id = ' . $eventId; } else { $eventId = ''; $where = ''; } //Getting all KO's. $eventsModel = new User_Model_Events(); if (isset($postarray['type']) && $postarray['type'] != '') { $methodtype = $postarray['type']; if ($methodtype == 'decision') { $type = ucfirst($methodtype); } else { if ($methodtype == 'submission') { $type = ucfirst($methodtype); } else { if ($methodtype == 'ko') { $type = ucwords($methodtype); } else { if ($methodtype == 'tko') { $type = ucwords($methodtype); } else { $userDetJson = array('status' => '0', 'message' => 'Invalid Type', 'result' => ''); } } } } if ($type == 'Decision') { $where .= " AND ed.method NOT IN ('KO','TKO','Submission')"; } else { $where .= " AND ed.method = '" . $type . "'"; } $methodDetails = $eventsModel->getMethodByUserId($postarray['userid'], $where); $data = array(); for ($i = 0; $i < sizeof($methodDetails); $i++) { $data[] = htmlentities($methodDetails[$i]['method1']); } $result = array_count_values($data); $userDetJson = array('status' => '1', 'message' => 'Success', 'result' => $result); } else { $userDetJson = array('status' => '0', 'message' => 'Not mentioned type of details you need.', 'result' => ''); } } else { $userDetJson = array('status' => '0', 'message' => 'User Id should not be empty.', 'result' => ''); } return $userDetJson; }
public function tracklistAction() { $postarray = $this->getRequest()->getParams(); if (isset($postarray['userid']) && $postarray['userid'] != '') { // total event details $alleventsModel = new User_Model_Events(); $alleventdetails = $alleventsModel->userEventDetails($postarray['userid'], ''); $this->view->alleventdetails = $alleventdetails; /* Queries for Friends */ $Friendseventdetails = array(); $trackModel = new User_Model_Tracks(); $trackDataCount = $trackModel->getCountOfUserTrack($postarray['userid']); $alleventdetails[0]['total_frnds_cnt'] = $trackDataCount[0]['count']; if (isset($postarray['pageno']) && $postarray['pageno'] != '') { $pageno = $postarray['pageno']; } else { $pageno = 1; } $perpagecnt = 10; $trackData = $trackModel->servcetogetUserTrackDetailsByID($postarray['userid'], $pageno, $perpagecnt); $trackUsers = ''; for ($i = 0; $i < sizeof($trackData); $i++) { $trackUsers .= $trackData[$i]['tracked_user_id'] . ','; } $trackUsers = trim($trackUsers, ','); if ($trackUsers != '') { $Friendseventdetails = $alleventsModel->trackedUserStats($trackUsers); } $final_arr = array(); $final_arr['user'] = $alleventdetails; $final_arr['friends'] = $Friendseventdetails; //echo "<pre>";print_r($final_arr);exit; $userDetJson = array('status' => '1', 'message' => 'Success', 'result' => $final_arr); } else { $userDetJson = array('status' => '0', 'message' => 'User Id should not be empty.', 'result' => ''); } $this->_helper->json($userDetJson); }