UsersController::ajax_activity PHP Method

    function ajax_activity()
    {
        $this->layout = 'ajax';
        $limit1 = $this->params['data']['limit1'];
        $limit2 = $this->params['data']['limit2'];
        $project_id = $this->params['data']['projid'];
        if ($project_id == 'all') {
            $cond = '';
        } else {
            $cond = "AND `Project`.`uniq_id` = '" . $project_id . "'";
        }
        $sql = "SELECT SQL_CALC_FOUND_ROWS `Easycase`.*,`User`.name,`User`.short_name,`User`.photo,`Project`.id,`Project`.uniq_id,`Project`.name FROM `easycases` AS `Easycase` inner JOIN users AS `User` ON (`Easycase`.`user_id` = `User`.`id`) inner JOIN projects AS `Project` ON (`Easycase`.`project_id` = `Project`.`id`) inner JOIN project_users AS `ProjectUser` ON (`Easycase`.`project_id` = `ProjectUser`.`project_id` AND `ProjectUser`.`user_id` = '" . SES_ID . "' AND `ProjectUser`.`company_id` = '" . SES_COMP . "') WHERE Project.isactive='1' AND Easycase.isactive='1' {$cond} ORDER BY Easycase.actual_dt_created DESC LIMIT {$limit1},{$limit2}";
        $activity = $this->User->query($sql);
        $tot = $this->User->query("SELECT FOUND_ROWS() as total");
        $total = $tot[0][0]['total'];
        //This section is meant for json loading.
        //Load the helpers
        $view = new View($this);
        $tz = $view->loadHelper('Tmzone');
        $dt = $view->loadHelper('Datetime');
        $csq = $view->loadHelper('Casequery');
        $fmt = $view->loadHelper('Format');
        if ($total != 0) {
            $frmtActivity['activity'] = array();
            $frmtActivity = $this->User->formatActivities($activity, $total, $fmt, $dt, $tz, $csq);
            //Making one array to send in json format.
            $lastDate = '';
            $repeatDate = $frmtActivity['activity']['0']['Easycase']['lastDate'];
            $cnt = 0;
            foreach ($frmtActivity['activity'] as $key => $value) {
                $lastDate = $value['Easycase']['lastDate'];
                if ($repeatDate != $lastDate) {
                    $cnt++;
                }
                $ajax_activity['activity'][$cnt][] = $value;
                $repeatDate = $lastDate;
            }
            //$ajax_activity['activity'] = $frmtActivity['activity'];
            $ajax_activity['total'] = $frmtActivity['total'];
        } else {
            $ajax_activity['activity'] = "";
            $ajax_activity['total'] = $total;
        }
        $this->set('ajax_activity', json_encode($ajax_activity));
        //End
    }