Skip to content

Instantly share code, notes, and snippets.

@devifr
Last active December 31, 2019 12:02
Show Gist options
  • Save devifr/5de171a189b58fc932f0e0d03d99ed29 to your computer and use it in GitHub Desktop.
Save devifr/5de171a189b58fc932f0e0d03d99ed29 to your computer and use it in GitHub Desktop.
site_ids = [{site_id: 'BTSE0017', username: 'teambanten1'},{site_id: 'BTSE0020', username: 'teambanten1'},{site_id: 'BTSE0018', username: 'teambanten1'},{site_id: 'BTSE0013', username: 'teambanten1'},{site_id: 'BTSR0012', username: 'teambanten1'},{site_id: 'BTSR0077', username: 'teambanten1'},{site_id: 'BTSR0069', username: 'teambanten1'},{site_id: 'BTSR0046', username: 'teambanten1'},{site_id: 'BTLB0047', username: 'teambanten4'},{site_id: 'BTCI0001', username: 'teambanten2'},{site_id: 'BTCI0004', username: 'teambanten2'},{site_id: 'BTCI0006', username: 'teambanten2'},{site_id: 'BTCI0010', username: 'teambanten2'},{site_id: 'BTCI0015', username: 'teambanten2'},{site_id: 'BTCI0021', username: 'teambanten2'},{site_id: 'BTCI0026', username: 'teambanten2'},{site_id: 'BTCI0029', username: 'teambanten2'},{site_id: 'BTCI0035', username: 'teambanten2'},{site_id: 'BTSE0001', username: 'teambanten2'},{site_id: 'BTPD0028', username: 'teambanten2'},{site_id: 'BTPD0030', username: 'teambanten2'},{site_id: 'BTPD0036', username: 'teambanten2'},{site_id: 'JBKR0032', username: 'teambanten5'}]
# Smart
site_ids = [{site_id: 'JKJB0098',username: 'Dodi B / M Fauzi'}]
site_ids = [{site_id: 'JIBJ0024', work_date: '1-Dec-19', username: 'techaps59'},{site_id: 'JIGR0052', work_date: '8-Dec-19', username: 'techaps17'},{site_id: 'JIMK0027', username: '2-Dec-19', username: 'techaps57'},{site_id: 'JIBJ0022', username: '2-Dec-19', username: 'techaps18'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CSMA003').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL
site_ids = [{site_id: 'JTSM0061',username: 'Budi Siswanto'}]
site_ids = [{site_id: 'SI.JIPC0001',username: 'techaps23'},{site_id: 'SI.JING0001',username: 'techaps70'}]
site_ids = [{site_id: 'JIBN0032', work_date: '5-Dec', username: 'techaps39'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# TSEL
site_ids = [{site_id: 'JISK0026',username: 'mssby01'},{site_id: 'JISK0081',username: 'mssby01'},{site_id: 'JISK0069',username: 'mssby01'},{site_id: 'JKJT0108',username: 'Agung / Solihin'},{site_id: 'JISI0052',username: 'AKHMAD MUKHSINIIN'},{site_id: 'JISK0072',username: 'AKHMAD MUKHSINIIN'},{site_id: 'JISK0068',username: 'AKHMAD MUKHSINIIN'},{site_id: 'BTTK0010',username: 'Babar / Iqbal'},{site_id: 'JBBD0028',username: 'Engineer Region Bandung'},{site_id: 'SMC.JIBA0023',username: 'IRWAN TRI'},{site_id: 'JIML0006',username: 'ISMAWANTO'},{site_id: 'SMC.JIBA0021',username: 'ISMAWANTO'},{site_id: 'SMC.JIBA0020',username: 'ISMAWANTO'},{site_id: 'SMC.JIKI0009',username: 'KHOIRUL ANAM'},{site_id: 'SMC.JIKI0010',username: 'KHOIRUL ANAM'},{site_id: 'JIKI0007',username: 'KHOIRUL ANAM'},{site_id: 'BTCI0010',username: 'Nandang/M Qoimudin'},{site_id: 'JISU0046',username: 'safii tmb'},{site_id: 'JISK0022',username: 'TEGUH SUHERNANTO'},{site_id: 'JIML0027',username: 'WAHYU'},{site_id: 'JIML0028',username: 'WAHYU'},{site_id: 'SMC.JIBA0019',username: 'WAHYU'},{site_id: 'SMC.JIBA0017',username: 'WAHYU'},{site_id: 'JIMB0032',username: 'WINARKO'}]
data = {site_id: '41230104',username: 'ms07'}
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL & Smart
site_ids = [{site_id: 'JISI0019',username: 'mssby01'}]
site_ids = [{site_id: 'JISI0009',username: 'mssby01'},{site_id: 'JISK0002',username: 'mssby01'},{site_id: 'JISI0007',username: 'mssby01'},{site_id: 'JISR0001',username: 'mssby01'},{site_id: 'JISK0070',username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# TSEL & SMART & HCPT
site_ids = [{site_id: 'JISI0047',username: 'mssby02'}]
site_ids = [{site_id: 'JISI0044',username: 'mssby01'},{site_id: 'JISI0043',username: 'mssby02'},{site_id: 'JISK0028',username: 'mssby02'},{site_id: 'JISI0046',username: 'mssby02'},{site_id: 'JIMB0024',username: 'techaps35'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
tenant3 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL & XL
site_ids = [{site_id: 'JIMB0034',username: 'techaps02'}]
site_ids = [{site_id: 'JISR0051', username: 'mssby02'},{site_id: 'JISR0047', username: 'mssby02'},{site_id: 'JISK0063', username: 'mssby02'},{site_id: 'JISI0036', username: 'mssby02'},{site_id: 'BTCI0024', username: 'teambanten2'},{site_id: 'JIML0023', username: 'techaps02'},{site_id: 'JIML0025', username: 'techaps04'},{site_id: 'JIST0003', username: 'techaps40'},{site_id: 'JISA0021', username: 'techaps53'},{site_id: 'JISA0022', username: 'techaps54'},{site_id: 'BTCI0005', username: 'teambanten2'},{site_id: 'BTCI0009', username: 'teambanten2'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL & HCPT
site_ids = [{site_id: 'JISI0049',username: 'mssby02'},{site_id: 'JIPS0036',username: 'techaps30'},{site_id: '41240066',username: 'ms13'}]
{site_id: 'JISK0009',username: 'mssby02'}
site_ids = [{site_id: 'JILA0023', work_date: '2-Dec-19', username: 'khoirultmb'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
created = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
created << data
end
# TSEL & ISAT
site_ids = [{site_id: 'JISK0073',username: 'mssby02'},{site_id: 'JIMU0024',username: 'techaps24'},{site_id: 'JIKI0006',username: 'techaps28'},{site_id: 'JIMK0015',username: 'techaps57'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
created = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CIND002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
created << data
end
#TSEL & SMART & ISAT
site_ids = [{site_id: 'JISK0071',username: 'mssby01'},{site_id: 'JISI0048',username: 'mssby02'}]
site_ids = [{site_id: 'SI.JIMG0003',work_date: '6-Dec-19',username: 'techaps02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
tenant3 = Operator.where(code: 'CIND002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL, SMART, HCPT & ISAT
site_ids = [{site_id: 'JISI0010', username: 'mssby01'},{site_id: 'JIMB0016', username: 'techaps35'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL, ISAT, HCPT
site_ids = [{site_id: 'JISI0008',username: 'mssby01'},{site_id: 'JISI0002',username: 'mssby01'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'HCPT').first
tenant3 = Operator.where(code: 'CIND002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL & HCPT
site_ids = [{site_id: 'JIBA0012',username: 'techaps35'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
created = []
tenant = Operator.where(code: 'HCPT').first
tenant2 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
created << data
end
#TSEL, HCPT, XL
site_ids = [{site_id: 'JISI0004', username: 'mssby01'},{site_id: 'JISR0038', username: 'mssby01'},{site_id: 'JISK0027', username: 'mssby02'},{site_id: 'JIML0024', username: 'techaps02'},{site_id: 'JISU0030', username: 'techaps19'},{site_id: 'JITR0003', username: 'techaps26'},{site_id: 'JIKI0004', username: 'techaps28'},{site_id: 'JIST0001', username: 'techaps40'},{site_id: 'JISU0019', username: 'techaps51'},{site_id: 'JISU0022', username: 'techaps51'},{site_id: 'JISU0023', username: 'techaps51'},{site_id: 'BTCI0003', username: 'teambanten2'}]
site_ids = [{site_id: 'JISI0004', username: 'mssby01'},{site_id: 'JISK0027', username: 'mssby02'},{site_id: 'JIML0024', username: 'techaps02'},{site_id: 'JISU0030', username: 'techaps19'},{site_id: 'JITR0003', username: 'techaps26'},{site_id: 'JIKI0004', username: 'techaps28'},{site_id: 'JIST0001', username: 'techaps40'},{site_id: 'JISU0019', username: 'techaps51'},{site_id: 'JISU0022', username: 'techaps51'},{site_id: 'JISU0023', username: 'techaps51'},{site_id: 'BTCI0003', username: 'teambanten2'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'HCPT').first
tenant3 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL & SMART
site_ids = [{site_id: 'JISK0024',username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CSMA003').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL & DMT
site_ids = [{site_id: 'JISU0029', username: 'techaps19'},{site_id: 'JISU0031', username: 'techaps19'},{site_id: 'JISA0031', username: 'techaps56'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: '0002000001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL, DMT, HCPT
site_ids = [{site_id: 'JISU0024',username: 'techaps51'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: '0002000001').first
tenant2 = Operator.where(code: 'HCPT').first
tenant3 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL, DMT, SMART, HCPT
site_ids = [{site_id: 'JISK0051', username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: '0002000001').first
tenant3 = Operator.where(code: 'CSMA003').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL,DMT,ISAT,HCPT
site_ids = [{site_id: 'JISI0035', username: 'mssby02'},{site_id: 'JISI0033', username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: '0002000001').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL, PAB
site_ids = [{site_id: 'JIST0015', username: 'techaps40'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002PAB').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL, PAB, HCPT, SMART
site_ids = [{site_id: 'JTSH0012', username: 'msjateng05'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002PAB').first
tenant3 = Operator.where(code: 'CSMA003').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL, PAB, HCPT
site_ids = [{site_id: 'JISU0045', username: 'techaps19'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002PAB').first
tenant2 = Operator.where(code: 'HCPT').first
tenant3 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL, PAB, HCPT, ISAT
site_ids = [{site_id: 'JISI0041', username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002PAB').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL,PAB,ISAT,SMART,HCPT
site_ids = [{site_id: 'JIKB0020', username: 'techaps28'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002PAB').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'CSMA003').first
tenant5 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
check_op5 = sch.schedule_operators.where(operator_id: tenant5.id)
if check_op5.blank?
sch.schedule_operators.create(operator_id: tenant5.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
check_op5 = sch.schedule_operators.where(operator_id: tenant5.id)
if check_op5.blank?
sch.schedule_operators.create(operator_id: tenant5.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
check_op5 = sch.schedule_operators.where(operator_id: tenant5.id)
if check_op5.blank?
sch.schedule_operators.create(operator_id: tenant5.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL, TSEL, ISAT
site_ids = [{site_id: 'JISK0046', username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CIND002').first
tenant3 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL, TSEL, ISAT, HCPT
site_ids = [{site_id: 'JISI0042', username: 'mssby02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL, TSEL, HCPT, SMART
site_ids = [{site_id: 'JIPS0013',username: 'techaps30'}]
site_ids = [{site_id: 'JISR0048',username: 'mssby01'},{site_id: 'JISK0008',username: 'mssby02'},{site_id: 'JIPS0013',username: 'techaps30'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002').first
tenant3 = Operator.where(code: 'CSMA003').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL, TSEL, HCPT, ISAT
site_ids = [{site_id: 'JITR0004', username: 'techaps26'},{site_id: 'JISU0017', username: 'techaps51'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL,TSEL,SMART
site_ids = [{site_id: 'JISI0021', username: 'mssby01'},{site_id: 'JISI0012', username: 'mssby01'},{site_id: 'JISI0031', username: 'mssby02'},{site_id: 'JISI0017', username: 'mssby02'},{site_id: 'JIML0005', username: 'techaps34'},{site_id: 'JISA0028', username: 'techaps54'},{site_id: 'JITB0007', username: 'techaps59'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
tenant3 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL,TSEL,SMART,ISAT,HCPT
site_ids = [{site_id: 'JISI0032', username: 'mssby02'},{site_id: 'JIML0008', username: 'techaps02'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
tenant2 = Operator.where(code: 'CTEL002').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'CSMA003').first
tenant5 = Operator.where(code: 'HCPT').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
check_op5 = sch.schedule_operators.where(operator_id: tenant5.id)
if check_op5.blank?
sch.schedule_operators.create(operator_id: tenant5.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
check_op5 = sch.schedule_operators.where(operator_id: tenant5.id)
if check_op5.blank?
sch.schedule_operators.create(operator_id: tenant5.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
check_op5 = sch.schedule_operators.where(operator_id: tenant5.id)
if check_op5.blank?
sch.schedule_operators.create(operator_id: tenant5.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL,TSEL,SMART,ISAT
site_ids = [{site_id: 'JIPS0019', username: 'techaps30'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL,TSEL,ISAT
site_ids = [{site_id: 'JIMB0002', username: 'techaps35'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CXLA001').first
tenant3 = Operator.where(code: 'CIND002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#XL,TSEL,ISAT,SMART
site_ids = [{site_id: 'JISI0016', username: 'mssby01'},{site_id: 'JIMB0037', username: 'techaps44'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
tenant2 = Operator.where(code: 'CSMA003').first
tenant3 = Operator.where(code: 'CIND002').first
tenant4 = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
check_op2 = sch.schedule_operators.where(operator_id: tenant2.id)
if check_op2.blank?
sch.schedule_operators.create(operator_id: tenant2.id, status: 'Created')
end
check_op3 = sch.schedule_operators.where(operator_id: tenant3.id)
if check_op3.blank?
sch.schedule_operators.create(operator_id: tenant3.id, status: 'Created')
end
check_op4 = sch.schedule_operators.where(operator_id: tenant4.id)
if check_op4.blank?
sch.schedule_operators.create(operator_id: tenant4.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# NO TENANT
site_ids = [{site_id: 'JISK0006', username: 'mssby01'},{site_id: 'JISK0034', username: 'mssby01'},{site_id: 'JISR0003', username: 'mssby01'},{site_id: 'JISI0001', username: 'mssby01'},{site_id: 'JISK0029', username: 'mssby01'},{site_id: 'JISR0015', username: 'mssby01'},{site_id: 'JISR0014', username: 'mssby01'},{site_id: 'JISR0022', username: 'mssby02'},{site_id: 'JISR0017', username: 'mssby02'},{site_id: 'JISU0005', username: 'techaps19'},{site_id: 'JISU0006', username: 'techaps19'},{site_id: 'JIPS0003', username: 'techaps30'},{site_id: 'JIPS0017', username: 'techaps30'},{site_id: 'BTCI0017', username: 'teambanten2'},{site_id: '41020075', username: 'ms07'},{site_id: '41030125', username: 'teambogor1'},{site_id: '41240069', username: 'teambogor1'},{site_id: '31050344', username: 'ms13'},{site_id: '31030206', username: 'ms10'},{site_id: '31030207', username: 'ms10'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CSOL001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 40, work_type_id: 26,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 40, work_type_id: 26,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL => BTSH
site_ids = [{site_id: 'HO.JKJS0001', username: 'ms202'},{site_id: 'HO.JKJU0002', username: 'ms72'},{site_id: 'HO.JKJP0002', username: 'ciatech03'},{site_id: 'HO.JKJT0002', username: 'ptcbungur'},{site_id: 'HO.JKJT0001', username: 'ptcbungur'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 46, work_type_id: 30,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 46, work_type_id: 30,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL => BTSH
site_ids = [{site_id: 'HO.JKJS0002', username: 'ms202'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 46, work_type_id: 30,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 46, work_type_id: 30,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# XL => ODC
site_ids = [{site_id: 'HO.JKJU0008', username: 'ms72'},{site_id: 'HO.JKJP0013', username: 'ciatech03'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CXLA001').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 47, work_type_id: 29,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 47, work_type_id: 29,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# BIT => ODC
site_ids = [{site_id: 'HO.JKJS0030', username: 'ms202'},{site_id: 'HO.JKJS0037', username: 'ms202'},{site_id: 'HO.JKJU0018', username: 'ms72'},{site_id: 'HO.JKJB0012', username: 'ms72'},{site_id: 'HO.JKJB0011', username: 'ms72'},{site_id: 'HO.JKJB0019', username: 'ms72'},{site_id: 'HO.JKJP0010', username: 'ciatech03'},{site_id: 'HO.JKJS0029', username: 'ciatech03'},{site_id: 'HO.JKJS0062', username: 'ciatech03'},{site_id: 'HO.JKJU0024', username: 'ptcbungur'},{site_id: 'HO.JKJT0023', username: 'ptcbungur'},{site_id: 'HO.JKJB0028', username: 'ptcbungur'},{site_id: 'HO.JKJT0009', username: 'ptcbungur'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: '8388').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 47, work_type_id: 29,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 47, work_type_id: 29,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# ISAT => ODC
site_ids = [{site_id: 'HO.JKJS0004', username: 'ms202'},{site_id: 'HO.JKJS0008', username: 'ms202'},{site_id: 'HO.JKJS0010', username: 'ms202'},{site_id: 'HO.JKJS0017', username: 'ms202'},{site_id: 'HO.JKJS0032', username: 'ms202'},{site_id: 'HO.JKJS0035', username: 'ms202'},{site_id: 'HO.JKJS0039', username: 'ms202'},{site_id: 'HO.JKJS0045', username: 'ms202'},{site_id: 'HO.JKJS0066', username: 'ms202'},{site_id: 'HO.JKJS0067', username: 'ms202'},{site_id: 'HO.JKJT0025', username: 'ms202'},{site_id: 'HO.JKJB0034', username: 'ms72'},{site_id: 'HO.JKJP0027', username: 'ms72'},{site_id: 'HO.JKJP0030', username: 'ms72'},{site_id: 'HO.JKJP0022', username: 'ciatech03'},{site_id: 'HO.JKJP0029', username: 'ciatech03'},{site_id: 'HO.JKJP0032', username: 'ciatech03'},{site_id: 'HO.JKJP0033', username: 'ciatech03'},{site_id: 'HO.JKJS0054', username: 'ciatech03'},{site_id: 'HO.JKJS0063', username: 'ciatech03'},{site_id: 'HO.JKJS0064', username: 'ciatech03'},{site_id: 'HO.JKJS0065', username: 'ciatech03'},{site_id: 'HO.JKJB0036', username: 'ciatech03'},{site_id: 'HO.JKJP0004', username: 'ptcbungur'},{site_id: 'HO.JKJP0020', username: 'ptcbungur'},{site_id: 'HO.JKJP0021', username: 'ptcbungur'},{site_id: 'HO.JKJP0028', username: 'ptcbungur'},{site_id: 'HO.JKJT0033', username: 'ptcbungur'},{site_id: 'HO.JKJU0015', username: 'ptcbungur'},{site_id: 'HO.JKJU0021', username: 'ptcbungur'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CIND002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 47, work_type_id: 29,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 47, work_type_id: 29,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
# TSEL => ODC
site_ids = [{site_id: 'HO.JKJS0019', username: 'ms202'},{site_id: 'HO.JKJS0025', username: 'ms202'},{site_id: 'HO.JKJS0028', username: 'ms202'},{site_id: 'HO.JKJS0038', username: 'ms202'},{site_id: 'HO.JKJS0040', username: 'ms202'},{site_id: 'HO.JKJS0005', username: 'ms202'},{site_id: 'HO.JKJS0006', username: 'ms202'},{site_id: 'HO.JKJS0031', username: 'ms202'},{site_id: 'HO.JKJS0044', username: 'ms202'},{site_id: 'HO.JKJT0004', username: 'ms202'},{site_id: 'HO.JKJB0002', username: 'ms72'},{site_id: 'HO.JKJB0003', username: 'ms72'},{site_id: 'HO.JKJB0004', username: 'ms72'},{site_id: 'HO.JKJB0005', username: 'ms72'},{site_id: 'HO.JKJB0006', username: 'ms72'},{site_id: 'HO.JKJB0009', username: 'ms72'},{site_id: 'HO.JKJB0023', username: 'ms72'},{site_id: 'HO.JKJB0029', username: 'ms72'},{site_id: 'HO.JKJB0033', username: 'ms72'},{site_id: 'HO.JKJU0003', username: 'ms72'},{site_id: 'HO.JKJU0016', username: 'ms72'},{site_id: 'HO.JKJU0023', username: 'ms72'},{site_id: 'HO.JKJP0017', username: 'ms72'},{site_id: 'HO.JKJB0007', username: 'ciatech03'},{site_id: 'HO.JKJB0025', username: 'ciatech03'},{site_id: 'HO.JKJP0008', username: 'ciatech03'},{site_id: 'HO.JKJP0011', username: 'ciatech03'},{site_id: 'HO.JKJP0012', username: 'ciatech03'},{site_id: 'HO.JKJP0018', username: 'ciatech03'},{site_id: 'HO.JKJS0014', username: 'ciatech03'},{site_id: 'HO.JKJS0027', username: 'ciatech03'},{site_id: 'HO.JKJS0034', username: 'ciatech03'},{site_id: 'HO.JKJS0041', username: 'ciatech03'},{site_id: 'HO.JKJS0050', username: 'ciatech03'},{site_id: 'HO.JKJS0052', username: 'ciatech03'},{site_id: 'HO.JKJS0053', username: 'ciatech03'},{site_id: 'HO.JKJB0022', username: 'ciatech03'},{site_id: 'HO.JKJB0032', username: 'ciatech03'},{site_id: 'HO.JKJS0051', username: 'ciatech03'},{site_id: 'HO.JKJT0003', username: 'ptcbungur'},{site_id: 'HO.JKJT0005', username: 'ptcbungur'},{site_id: 'HO.JKJT0010', username: 'ptcbungur'},{site_id: 'HO.JKJT0011', username: 'ptcbungur'},{site_id: 'HO.JKJT0027', username: 'ptcbungur'},{site_id: 'HO.JKJU0007', username: 'ptcbungur'},{site_id: 'HO.JKJP0019', username: 'ptcbungur'},{site_id: 'HO.JKJP0024', username: 'ptcbungur'},{site_id: 'HO.JKJT0014', username: 'ptcbungur'},{site_id: 'HO.JKJU0001', username: 'ptcbungur'},{site_id: 'HO.JKJU0010', username: 'ptcbungur'},{site_id: 'HO.JKJU0012', username: 'ptcbungur'},{site_id: 'HO.JKJU0022', username: 'ptcbungur'},{site_id: 'HO.JKJT0015', username: 'ptcbungur'},{site_id: 'HO.JKJT0008', username: 'ptcbungur'},{site_id: 'HO.JKJT0024', username: 'ptcbungur'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 47, work_type_id: 29,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 47, work_type_id: 29,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#BIT => MCP
site_ids = [{site_id: 'MCP.JKJS0114', username: 'ms202'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: '8388').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 32, work_type_id: 21,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 32, work_type_id: 21,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#ISAT => MCP
site_ids = [{site_id: 'MCP.JKJS0131', username: 'ms202'},{site_id: 'MCP.JKJT0002', username: 'ms202'},{site_id: 'MCP.JKJS0014', username: 'ms202'},{site_id: 'MCP.JKJS0015', username: 'ms202'},{site_id: 'MCP.JKJS0017', username: 'ms202'},{site_id: 'MCP.JKJS0018', username: 'ms202'},{site_id: 'MCP.JKJS0019', username: 'ms202'},{site_id: 'MCP.JKJS0033', username: 'ms202'},{site_id: 'MCP.JKJS0110', username: 'ms202'},{site_id: 'MCP.JKJS0119', username: 'ms202'},{site_id: 'MCP.JKJS0133', username: 'ms202'},{site_id: 'MCP.JKJS0136', username: 'ms202'},{site_id: 'MCP.JKJS0137', username: 'ms202'},{site_id: 'MCP.JKJS0138', username: 'ms202'},{site_id: 'MCP.JKJS0139', username: 'ms202'},{site_id: 'MCP.JKJS0217', username: 'ms202'},{site_id: 'MCP.JKJT0084', username: 'ms202'},{site_id: 'MCP.JKJB0002', username: 'ms72'},{site_id: 'MCP.JKJP0022', username: 'ms72'},{site_id: 'MCP.JKJU0113', username: 'ms72'},{site_id: 'MCP.JKJU0008', username: 'ms72'},{site_id: 'MCP.JKJU0018', username: 'ms72'},{site_id: 'MCP.JKJU0076', username: 'ms72'},{site_id: 'MCP.JKJU0111', username: 'ms72'},{site_id: 'MCP.JKJU0115', username: 'ms72'},{site_id: 'MCP.JKJS0101', username: 'ms72'},{site_id: 'MCP.JKJP0006', username: 'ciatech03'},{site_id: 'MCP.JKJP0018', username: 'ciatech03'},{site_id: 'MCP.JKJP0058', username: 'ciatech03'},{site_id: 'MCP.JKJP0069', username: 'ciatech03'},{site_id: 'MCP.JKJP0086', username: 'ciatech03'},{site_id: 'MCP.JKJS0002', username: 'ciatech03'},{site_id: 'MCP.JKJS0010', username: 'ciatech03'},{site_id: 'MCP.JKJS0115', username: 'ciatech03'},{site_id: 'MCP.JKJP0016', username: 'ciatech03'},{site_id: 'MCP.JKJS0008', username: 'ciatech03'},{site_id: 'MCP.JKJS0024', username: 'ciatech03'},{site_id: 'MCP.JKJS0034', username: 'ciatech03'},{site_id: 'MCP.JKJS0113', username: 'ciatech03'},{site_id: 'MCP.JKJS0283', username: 'ciatech03'},{site_id: 'MCP.JKJP0019', username: 'ptcbungur'},{site_id: 'MCP.JKJP0021', username: 'ptcbungur'},{site_id: 'MCP.JKJP0070', username: 'ptcbungur'},{site_id: 'MCP.JKJU0001', username: 'ptcbungur'},{site_id: 'MCP.JKJU0002', username: 'ptcbungur'},{site_id: 'MCP.JKJU0017', username: 'ptcbungur'},{site_id: 'MCP.JKJU0024', username: 'ptcbungur'},{site_id: 'MCP.JKJU0108', username: 'ptcbungur'},{site_id: 'MCP.JKJU0109', username: 'ptcbungur'},{site_id: 'MCP.JKJP0071', username: 'ptcbungur'},{site_id: 'MCP.JKJP0090', username: 'ptcbungur'},{site_id: 'MCP.JKJT0048', username: 'ptcbungur'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CIND002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 32, work_type_id: 21,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 32, work_type_id: 21,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
#TSEL => MCP
site_ids = [{site_id: 'MCP.JKJS0200', username: 'ms202'},{site_id: 'MCP.JKJT0001', username: 'ms202'},{site_id: 'MCP.JKJT0026', username: 'ms202'},{site_id: 'MCP.JKJP0231', username: 'ms202'},{site_id: 'MCP.JKJP0233', username: 'ms202'},{site_id: 'MCP.JKJP0234', username: 'ms202'},{site_id: 'MCP.JKJP0237', username: 'ms202'},{site_id: 'MCP.JKJS0012', username: 'ms202'},{site_id: 'MCP.JKJS0016', username: 'ms202'},{site_id: 'MCP.JKJS0020', username: 'ms202'},{site_id: 'MCP.JKJS0021', username: 'ms202'},{site_id: 'MCP.JKJS0026', username: 'ms202'},{site_id: 'MCP.JKJS0032', username: 'ms202'},{site_id: 'MCP.JKJS0035', username: 'ms202'},{site_id: 'MCP.JKJS0039', username: 'ms202'},{site_id: 'MCP.JKJS0040', username: 'ms202'},{site_id: 'MCP.JKJS0061', username: 'ms202'},{site_id: 'MCP.JKJS0088', username: 'ms202'},{site_id: 'MCP.JKJS0090', username: 'ms202'},{site_id: 'MCP.JKJS0093', username: 'ms202'},{site_id: 'MCP.JKJS0094', username: 'ms202'},{site_id: 'MCP.JKJS0158', username: 'ms202'},{site_id: 'MCP.JKJS0180', username: 'ms202'},{site_id: 'MCP.JKJS0196', username: 'ms202'},{site_id: 'MCP.JKJS0218', username: 'ms202'},{site_id: 'MCP.JKJS0219', username: 'ms202'},{site_id: 'MCP.JKJS0220', username: 'ms202'},{site_id: 'MCP.JKJS0221', username: 'ms202'},{site_id: 'MCP.JKJS0222', username: 'ms202'},{site_id: 'MCP.JKJS0223', username: 'ms202'},{site_id: 'MCP.JKJS0228', username: 'ms202'},{site_id: 'MCP.JKJS0230', username: 'ms202'},{site_id: 'MCP.JKJS0281', username: 'ms202'},{site_id: 'MCP.JKJS0285', username: 'ms202'},{site_id: 'MCP.JKJS0288', username: 'ms202'},{site_id: 'MCP.JKJS0289', username: 'ms202'},{site_id: 'MCP.JKJS0298', username: 'ms202'},{site_id: 'MCP.JKJS0301', username: 'ms202'},{site_id: 'MCP.JKJB0007', username: 'ms72'},{site_id: 'MCP.JKJB0008', username: 'ms72'},{site_id: 'MCP.JKJB0009', username: 'ms72'},{site_id: 'MCP.JKJB0014', username: 'ms72'},{site_id: 'MCP.JKJB0028', username: 'ms72'},{site_id: 'MCP.JKJB0034', username: 'ms72'},{site_id: 'MCP.JKJB0035', username: 'ms72'},{site_id: 'MCP.JKJB0037', username: 'ms72'},{site_id: 'MCP.JKJB0038', username: 'ms72'},{site_id: 'MCP.JKJB0039', username: 'ms72'},{site_id: 'MCP.JKJB0040', username: 'ms72'},{site_id: 'MCP.JKJB0116', username: 'ms72'},{site_id: 'MCP.JKJB0118', username: 'ms72'},{site_id: 'MCP.JKJB0120', username: 'ms72'},{site_id: 'MCP.JKJB0122', username: 'ms72'},{site_id: 'MCP.JKJB0123', username: 'ms72'},{site_id: 'MCP.JKJB0124', username: 'ms72'},{site_id: 'MCP.JKJB0125', username: 'ms72'},{site_id: 'MCP.JKJB0173', username: 'ms72'},{site_id: 'MCP.JKJB0175', username: 'ms72'},{site_id: 'MCP.JKJB0176', username: 'ms72'},{site_id: 'MCP.JKJB0177', username: 'ms72'},{site_id: 'MCP.JKJB0178', username: 'ms72'},{site_id: 'MCP.JKJB0181', username: 'ms72'},{site_id: 'MCP.JKJB0183', username: 'ms72'},{site_id: 'MCP.JKJP0052', username: 'ms72'},{site_id: 'MCP.JKJP0160', username: 'ms72'},{site_id: 'MCP.JKJS0226', username: 'ms72'},{site_id: 'MCP.JKJP0011', username: 'ms72'},{site_id: 'MCP.JKJP0023', username: 'ms72'},{site_id: 'MCP.JKJP0035', username: 'ms72'},{site_id: 'MCP.JKJP0081', username: 'ms72'},{site_id: 'MCP.JKJP0092', username: 'ms72'},{site_id: 'MCP.JKJP0106', username: 'ms72'},{site_id: 'MCP.JKJP0161', username: 'ms72'},{site_id: 'MCP.JKJP0164', username: 'ms72'},{site_id: 'MCP.JKJP0169', username: 'ms72'},{site_id: 'MCP.JKJB0033', username: 'ms72'},{site_id: 'MCP.JKJP0080', username: 'ms72'},{site_id: 'MCP.JKJP0229', username: 'ms72'},{site_id: 'MCP.JKJU0003', username: 'ms72'},{site_id: 'MCP.JKJU0005', username: 'ms72'},{site_id: 'MCP.JKJU0007', username: 'ms72'},{site_id: 'MCP.JKJU0019', username: 'ms72'},{site_id: 'MCP.JKJU0033', username: 'ms72'},{site_id: 'MCP.JKJU0062', username: 'ms72'},{site_id: 'MCP.JKJU0063', username: 'ms72'},{site_id: 'MCP.JKJU0251', username: 'ms72'},{site_id: 'MCP.JKJU0258', username: 'ms72'},{site_id: 'MCP.JKJT0011', username: 'ms72'},{site_id: 'MCP.JKJB0001', username: 'ms72'},{site_id: 'MCP.JKJP0247', username: 'ms72'},{site_id: 'MCP.JKJU0257', username: 'ms72'},{site_id: 'MCP.JKJB0031', username: 'ciatech03'},{site_id: 'MCP.JKJB0121', username: 'ciatech03'},{site_id: 'MCP.JKJP0157', username: 'ciatech03'},{site_id: 'MCP.JKJB0043', username: 'ciatech03'},{site_id: 'MCP.JKJP0005', username: 'ciatech03'},{site_id: 'MCP.JKJP0007', username: 'ciatech03'},{site_id: 'MCP.JKJP0009', username: 'ciatech03'},{site_id: 'MCP.JKJP0020', username: 'ciatech03'},{site_id: 'MCP.JKJP0029', username: 'ciatech03'},{site_id: 'MCP.JKJP0033', username: 'ciatech03'},{site_id: 'MCP.JKJP0034', username: 'ciatech03'},{site_id: 'MCP.JKJP0036', username: 'ciatech03'},{site_id: 'MCP.JKJP0037', username: 'ciatech03'},{site_id: 'MCP.JKJP0038', username: 'ciatech03'},{site_id: 'MCP.JKJP0075', username: 'ciatech03'},{site_id: 'MCP.JKJP0076', username: 'ciatech03'},{site_id: 'MCP.JKJP0079', username: 'ciatech03'},{site_id: 'MCP.JKJP0085', username: 'ciatech03'},{site_id: 'MCP.JKJP0094', username: 'ciatech03'},{site_id: 'MCP.JKJP0095', username: 'ciatech03'},{site_id: 'MCP.JKJP0096', username: 'ciatech03'},{site_id: 'MCP.JKJP0097', username: 'ciatech03'},{site_id: 'MCP.JKJP0098', username: 'ciatech03'},{site_id: 'MCP.JKJP0100', username: 'ciatech03'},{site_id: 'MCP.JKJP0120', username: 'ciatech03'},{site_id: 'MCP.JKJP0162', username: 'ciatech03'},{site_id: 'MCP.JKJP0163', username: 'ciatech03'},{site_id: 'MCP.JKJP0214', username: 'ciatech03'},{site_id: 'MCP.JKJP0224', username: 'ciatech03'},{site_id: 'MCP.JKJS0009', username: 'ciatech03'},{site_id: 'MCP.JKJS0013', username: 'ciatech03'},{site_id: 'MCP.JKJS0208', username: 'ciatech03'},{site_id: 'MCP.JKJS0299', username: 'ciatech03'},{site_id: 'MCP.JKJS0296', username: 'ciatech03'},{site_id: 'MCP.JKJT0152', username: 'ciatech03'},{site_id: 'MCP.JKJP0015', username: 'ciatech03'},{site_id: 'MCP.JKJS0028', username: 'ciatech03'},{site_id: 'MCP.JKJS0029', username: 'ciatech03'},{site_id: 'MCP.JKJS0100', username: 'ciatech03'},{site_id: 'MCP.JKJS0103', username: 'ciatech03'},{site_id: 'MCP.JKJS0104', username: 'ciatech03'},{site_id: 'MCP.JKJS0107', username: 'ciatech03'},{site_id: 'MCP.JKJS0201', username: 'ciatech03'},{site_id: 'MCP.JKJS0202', username: 'ciatech03'},{site_id: 'MCP.JKJS0204', username: 'ciatech03'},{site_id: 'MCP.JKJS0206', username: 'ciatech03'},{site_id: 'MCP.JKJS0207', username: 'ciatech03'},{site_id: 'MCP.JKJS0224', username: 'ciatech03'},{site_id: 'MCP.JKJS0227', username: 'ciatech03'},{site_id: 'MCP.JKJS0282', username: 'ciatech03'},{site_id: 'MCP.JKJS0291', username: 'ciatech03'},{site_id: 'MCP.JKJS0297', username: 'ciatech03'},{site_id: 'MCP.JKJB0029', username: 'ptcbungur'},{site_id: 'MCP.JKJP0013', username: 'ptcbungur'},{site_id: 'MCP.JKJP0030', username: 'ptcbungur'},{site_id: 'MCP.JKJP0039', username: 'ptcbungur'},{site_id: 'MCP.JKJP0059', username: 'ptcbungur'},{site_id: 'MCP.JKJP0063', username: 'ptcbungur'},{site_id: 'MCP.JKJP0065', username: 'ptcbungur'},{site_id: 'MCP.JKJP0082', username: 'ptcbungur'},{site_id: 'MCP.JKJP0147', username: 'ptcbungur'},{site_id: 'MCP.JKJP0165', username: 'ptcbungur'},{site_id: 'MCP.JKJP0166', username: 'ptcbungur'},{site_id: 'MCP.JKJP0170', username: 'ptcbungur'},{site_id: 'MCP.JKJP0215', username: 'ptcbungur'},{site_id: 'MCP.JKJP0216', username: 'ptcbungur'},{site_id: 'MCP.JKJT0039', username: 'ptcbungur'},{site_id: 'MCP.JKJP0062', username: 'ptcbungur'},{site_id: 'MCP.JKJP0222', username: 'ptcbungur'},{site_id: 'MCP.JKJP0223', username: 'ptcbungur'},{site_id: 'MCP.JKJP0227', username: 'ptcbungur'},{site_id: 'MCP.JKJP0228', username: 'ptcbungur'},{site_id: 'MCP.JKJP0241', username: 'ptcbungur'},{site_id: 'MCP.JKJT0038', username: 'ptcbungur'},{site_id: 'MCP.JKJU0025', username: 'ptcbungur'},{site_id: 'MCP.JKJU0041', username: 'ptcbungur'},{site_id: 'MCP.JKJU0064', username: 'ptcbungur'},{site_id: 'MCP.JKJU0078', username: 'ptcbungur'},{site_id: 'MCP.JKJU0079', username: 'ptcbungur'},{site_id: 'MCP.JKJU0080', username: 'ptcbungur'},{site_id: 'MCP.JKJU0081', username: 'ptcbungur'},{site_id: 'MCP.JKJU0083', username: 'ptcbungur'},{site_id: 'MCP.JKJU0084', username: 'ptcbungur'},{site_id: 'MCP.JKJU0085', username: 'ptcbungur'},{site_id: 'MCP.JKJU0086', username: 'ptcbungur'},{site_id: 'MCP.JKJU0103', username: 'ptcbungur'},{site_id: 'MCP.JKJU0107', username: 'ptcbungur'},{site_id: 'MCP.JKJU0110', username: 'ptcbungur'},{site_id: 'MCP.JKJU0117', username: 'ptcbungur'},{site_id: 'MCP.JKJU0186', username: 'ptcbungur'},{site_id: 'MCP.JKJU0187', username: 'ptcbungur'},{site_id: 'MCP.JKJU0188', username: 'ptcbungur'},{site_id: 'MCP.JKJU0195', username: 'ptcbungur'},{site_id: 'MCP.JKJU0197', username: 'ptcbungur'},{site_id: 'MCP.JKJU0246', username: 'ptcbungur'},{site_id: 'MCP.JKJU0247', username: 'ptcbungur'},{site_id: 'MCP.JKJU0248', username: 'ptcbungur'},{site_id: 'MCP.JKJU0249', username: 'ptcbungur'},{site_id: 'MCP.JKJP0225', username: 'ptcbungur'},{site_id: 'MCP.JKJP0226', username: 'ptcbungur'},{site_id: 'MCP.JKJP0232', username: 'ptcbungur'},{site_id: 'MCP.JKJP0235', username: 'ptcbungur'},{site_id: 'MCP.JKJS0044', username: 'ptcbungur'},{site_id: 'MCP.JKJS0049', username: 'ptcbungur'},{site_id: 'MCP.JKJT0009', username: 'ptcbungur'},{site_id: 'MCP.JKJT0019', username: 'ptcbungur'},{site_id: 'MCP.JKJT0025', username: 'ptcbungur'},{site_id: 'MCP.JKJT0027', username: 'ptcbungur'},{site_id: 'MCP.JKJT0030', username: 'ptcbungur'},{site_id: 'MCP.JKJT0037', username: 'ptcbungur'},{site_id: 'MCP.JKJT0042', username: 'ptcbungur'},{site_id: 'MCP.JKJT0044', username: 'ptcbungur'},{site_id: 'MCP.JKJT0045', username: 'ptcbungur'},{site_id: 'MCP.JKJT0055', username: 'ptcbungur'},{site_id: 'MCP.JKJT0064', username: 'ptcbungur'},{site_id: 'MCP.JKJT0092', username: 'ptcbungur'},{site_id: 'MCP.JKJT0099', username: 'ptcbungur'},{site_id: 'MCP.JKJT0100', username: 'ptcbungur'},{site_id: 'MCP.JKJT0102', username: 'ptcbungur'},{site_id: 'MCP.JKJT0103', username: 'ptcbungur'},{site_id: 'MCP.JKJT0148', username: 'ptcbungur'},{site_id: 'MCP.JKJT0149', username: 'ptcbungur'},{site_id: 'MCP.JKJT0151', username: 'ptcbungur'},{site_id: 'MCP.JKJT0154', username: 'ptcbungur'},{site_id: 'MCP.JKJT0155', username: 'ptcbungur'}]
gagal = []
present = []
site_blank = []
user_blank = []
not_authorized = []
tenant = Operator.where(code: 'CTEL002').first
site_ids.each do |data|
site = Site.where("code = ? OR site_id_customer = ? OR site_id_sap = ?",data[:site_id],data[:site_id],data[:site_id]).first
if site.blank?
site_blank << data[:site_id]
next
end
user = User.where(username: data[:username]).first
if user.blank?
user = User.where(username: 'rindang').first
user_blank << [data[:username], data[:site_id]]
end
check = Schedule.where(form_id: 32, work_type_id: 21,site_id: site.id).where("DATE(work_date) >= DATE(?)",'2019-12-01')
if check.blank?
sch = Schedule.new(work_date: '2019-12-16',user_id: user.id,form_id: 32, work_type_id: 21,site_id: site.id, status: 'New',periode: 'Des-2019')
sch.client_id = 1
if sch.save
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
else
if sch.errors.full_messages.include?("Site is not authorized for selected engineer")
sch.user_id = User.where(username: 'user_1').first.id
sch.save
not_authorized << data[:site_id]
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
else
gagal << [data,sch.errors.full_messages]
end
end
else
sch = check.first
check_op = sch.schedule_operators.where(operator_id: tenant.id)
if check_op.blank?
sch.schedule_operators.create(operator_id: tenant.id, status: 'Created')
end
present << [data[:site_id], check.first.id]
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment