Last active
December 31, 2019 12:02
-
-
Save devifr/5de171a189b58fc932f0e0d03d99ed29 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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