# -*- coding: utf-8 -*-
class MaterialDetailsController < ApplicationController
  layout 'contracts'
  # Авторизация (файл: controllers/application.rb)
  before_filter :isAuthorization

  # Права доступа (файл: controllers/application.rb)
  before_filter :construct

  def construct

    # Устанавливаем сессионную куку.
    cookies[:sys_dep] = { :value => 'mod' }
    # Сотрудники
    $employeesAll = EmployeesDB.getEmployees("*")
    $employeesGroup = EmployeesDB.getEmployees(session[:user_department])
    
    # Формируем сессию
    params.each { |key, value| session[""+key+""] = value }
    $session = session

  end


 def index
   @details = DoneMaterial.find_by_sql("SELECT dm.material_id AS id, dm.material_name AS name, m.section AS section, m.number AS number, IF((IFNULL(m.show, 1)) = 1, 'true', 'false') AS m_show, m.sum AS sum  FROM done_materials dm  LEFT OUTER JOIN material_details m ON dm.material_id = m.id WHERE dm.date > '#{Date.today.last_year}' GROUP BY dm.material_id, dm.material_name ORDER BY m.section DESC, m.number DESC, dm.material_name ")
 end


 def update_det   
   det = MaterialDetail.find_or_create_by_id(params[:id])
   name = (DoneMaterial.find_by_material_id params[:id]).material_name
   if det.update_attributes(:name => name, params[:attr_name].to_sym => params[:attr_val])
     status = 'OK'
   else
     status = 'error'
   end
   render(:json => {:status => status})   
 end


end