def projectmanagerlist

    @title = "Statistics"
    @pro = Project.all
    @efforts = Effort.all
    @data = []


    @pro.each do |projectlist|
      projdata = :name =>  projectlist.project_name.to_s,
      :values => [] }

      ['Pre-Sales','Project','Fault Fixing','Support','Out Of Hours', 'Sick', 'Toil', 'Leave'].each do |taskname|

      @records = Effort.joins( :project_task, :user ).
                where( "project_tasks.project_id = ? AND project_tasks = ?", taskname, projectlist.id).
                group( :full_name).
                order( :taskType ).
                sum( :hours )

      Project.where("manager_user_id = ? OR account_manager = ?", current_user.id, current_user.id)


      projdata[ :values ].push( record )
   end
   @data.push( projdata )

    end
  end
 end