# -*- coding: utf-8 -*-
class AddDocFromMasterToReports < ActiveRecord::Migration
  def self.up
    #work_time -> get_money_status ДЕНЬГИ ПОЛУЧЕНЫ, ЖДЕМ, ОТКАЗАЛИС
    #weld -> get_docs ДОКУМЕНТЫ ОТПРАВЛЕНЫ, ПОЛУЧЕНЫ, НЕ БУДЕТ
    #get_docs_from_master ДОКУМЕНТЫ ОТ МАСТЕРА
    #com_buh КОММЕНТАРИЙ БУХГАЛТЕРА

    add_column :reports, :get_docs_from_master, :boolean, :default => false
    add_column :reports, :get_docs, :integer, :default => 0
    add_column :reports, :get_money_status, :integer, :default => 0
    add_column :reports, :com_buh, :string
    
    Report.connection.execute("UPDATE reports r SET r.get_docs = r.weld, get_docs_from_master = true WHERE r.department = 'soft' AND weld IS NOT NULL AND weld != 0")
    Report.connection.execute("UPDATE reports r SET r.get_money_status = r.work_time WHERE r.department = 'soft' AND work_time IS NOT NULL AND work_time != 0")
    Report.connection.execute("UPDATE reports r SET r.com_buh = r.com_get_money WHERE r.department = 'soft' AND com_get_money IS NOT NULL AND com_get_money != ''")
  end
  
  def self.down
    remove_column :reports, :get_docs_from_master
    remove_column :reports, :get_docs
    remove_column :reports, :get_money_status
    remove_column :reports, :com_buh
    
  end
end