class MeasureController < ApplicationController
  	
  # Авторизация (файл: controllers/application.rb)
  before_filter :isAuthorization

  # Права доступа (файл: controllers/application.rb)
  around_filter :isAccessAdmin
  
  
  def index
		@result = MeasureDB.find_by_sql("SELECT * FROM measures")
  end
	

	def addmeasure
		@title=''
		@link=''
		@sort = 500
		begin
			MeasureDB.find(params[:id].to_i)
		rescue
			print 'Куда полез?'
		else
			# get data work
			@id = params[:id].to_s
			@result = MeasureDB.find_by_sql("SELECT * FROM measures WHERE id="+@id+"")
			@title = @result[0]['name'].to_s
			@link = @result[0]['link'].to_s
			@sort = @result[0]['sort'].to_s
			@description = @result[0]['description'].to_s
		end
		
	end

	def savemeasure
		if(params[:id].to_i>0)
			id = params[:id].to_i
			sv_work = MeasureDB.find(id)
		else
			sv_work = MeasureDB.new
		end
		# get
		sv_work.name = Check.isText(params[:title])
		sv_work.link = Check.isText(params[:link])
		sv_work.sort = Check.intval(params[:sort])
		sv_work.description = Check.isText(params[:description])
		# save
		sv_work.save
		#redirect
		redirect_to :action => "index"
	end
	
	def delmeasure
		if(params[:id].to_i>0)
			id = params[:id].to_i
			begin
				MeasureDB.find(id)
			rescue	
				print 'Такого идентификатора - НЕТ.'
			else 	
				# delete
				MeasureDB.delete(id)
				# redirect
				redirect_to :action => "index"
			end
		end
	end


	# end Work
end


class MeasureDB < ActiveRecord::Base
	self.table_name = "measures"
end