Advertisement
Guest User

Untitled

a guest
Jul 19th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.82 KB | None | 0 0
  1. class AssignedFiltersUpdate < ActiveRecord::Migration[5.1]
  2. def change
  3. AssignedFilter.destroy_all
  4.  
  5.  
  6. AssignedFilter.create(name: 'Received Express PO', filters: {"phase":[{"type":"Installation","status":"receiving"}],"flag":[{"name":"Express Job"}]}, position: 'Installation Supervisor');
  7. AssignedFilter.create(name: 'Received PO', filters: {"phase":[{"type":"Installation","status":"receiving"}]}, position: 'Installation Supervisor');
  8. AssignedFilter.create(name: 'Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Installation","status":"hold"}]}, position: 'Installation Supervisor');
  9. AssignedFilter.create(name: 'Exceptions', filters: {"flag":[{"name":"Issue","suboption":"Labor"}]}, position: 'Installation Supervisor');
  10. AssignedFilter.create(name: 'Refigures', filters: {"phase":[{"type":"Assessment","status":"refiguring"}]}, position: 'Installation Supervisor');
  11. AssignedFilter.create(name: 'Appointment Confirmation', filters: {"flag":[{"name":"Appointment Confirmation"}]}, position: 'Installation Supervisor');
  12. AssignedFilter.create(name: 'Product Confirmation', filters: {"flag":[{"name":"Product Confirmation"}]}, position: 'Installation Supervisor');
  13. AssignedFilter.create(name: 'Express Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}],"flag":[{"name":"Express Job"}]}, position: 'Installation Supervisor');
  14. AssignedFilter.create(name: 'Sent to Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}]}, position: 'Installation Supervisor');
  15. AssignedFilter.create(name: 'Install Scheduled', filters: {"phase":[{"type":"Installation","status":"awaiting_install"}]}, position: 'Installation Supervisor');
  16. AssignedFilter.create(name: 'Customer Not Ready', filters: {"phase":[{"type":"Installation","status":"customer_not_ready"}]}, position: 'Installation Supervisor');
  17. AssignedFilter.create(name: 'Dispatch', filters: {"task":["install_dispatched"]}, position: 'Installation Supervisor');
  18. AssignedFilter.create(name: 'In Progress', filters: {"task":["install_in_progress"]}, position: 'Installation Supervisor');
  19. AssignedFilter.create(name: 'Installing Today', filters: {"phase":[{"type":"Installation","status":"installing"}]}, position: 'Installation Supervisor');
  20. AssignedFilter.create(name: 'Follow Up Required', filters: {"phase":[{"type":"Installation","status":"follow_up"}]}, position: 'Installation Supervisor');
  21. AssignedFilter.create(name: 'Need IB/COC', filters: {"task":["installer_paysheet_attached","coc_attached"]}, position: 'Installation Supervisor');
  22. AssignedFilter.create(name: 'WO-Received', filters: {"phase":[{"type":"Workorder","status":"receiving"}]}, position: 'Installation Supervisor');
  23. AssignedFilter.create(name: 'WO-Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Workorder","status":"cpo"}]}, position: 'Installation Supervisor');
  24. AssignedFilter.create(name: 'WO-Materials', filters: {"phase":[{"type":"Workorder","status":"materials"}],"task":["workorder_materials_requested","workorder_materials_received"]}, position: 'Installation Supervisor');
  25. AssignedFilter.create(name: 'WO-Scheduling', filters: {"phase":[{"type":"Workorder","status":"scheduling"}]}, position: 'Installation Supervisor');
  26. AssignedFilter.create(name: 'WO-Scheduled', filters: {"phase":[{"type":"Workorder","status":"awaiting_workorder"}]}, position: 'Installation Supervisor');
  27. AssignedFilter.create(name: 'WO-Customer Not Ready', filters: {"phase":[{"type":"Workorder","status":"customer_not_ready"}]}, position: 'Installation Supervisor');
  28. AssignedFilter.create(name: 'WO-Dispatch', filters: {"task":["workorder_dispatched"]}, position: 'Installation Supervisor');
  29. AssignedFilter.create(name: 'WO-In Progress', filters: {"task":["workorder_in_progress"]}, position: 'Installation Supervisor');
  30. AssignedFilter.create(name: 'WO-Follow Up Required', filters: {"phase":[{"type":"Workorder","status":"follow_up"}]}, position: 'Installation Supervisor');
  31. AssignedFilter.create(name: 'WO-Upload Signed Documents', filters: {"task":["workorder_upload_docs"]}, position: 'Installation Supervisor');
  32. AssignedFilter.create(name: 'Poor Score/Potential Issues', filters: {"flag":[{"name":"Poor Score"}]}, position: 'Installation Supervisor');
  33.  
  34.  
  35. AssignedFilter.create(name: 'Received Express PO', filters: {"phase":[{"type":"Installation","status":"receiving"}],"flag":[{"name":"Express Job"}]}, position: 'Regional Service Manager');
  36. AssignedFilter.create(name: 'Received PO', filters: {"phase":[{"type":"Installation","status":"receiving"}]}, position: 'Regional Service Manager');
  37. AssignedFilter.create(name: 'Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Installation","status":"hold"}]}, position: 'Regional Service Manager');
  38. AssignedFilter.create(name: 'Exceptions', filters: {"flag":[{"name":"Issue","suboption":"Labor"}]}, position: 'Regional Service Manager');
  39. AssignedFilter.create(name: 'Refigures', filters: {"phase":[{"type":"Assessment","status":"refiguring"}]}, position: 'Regional Service Manager');
  40. AssignedFilter.create(name: 'Appointment Confirmation', filters: {"flag":[{"name":"Appointment Confirmation"}]}, position: 'Regional Service Manager');
  41. AssignedFilter.create(name: 'Product Confirmation', filters: {"flag":[{"name":"Product Confirmation"}]}, position: 'Regional Service Manager');
  42. AssignedFilter.create(name: 'Express Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}],"flag":[{"name":"Express Job"}]}, position: 'Regional Service Manager');
  43. AssignedFilter.create(name: 'Sent to Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}]}, position: 'Regional Service Manager');
  44. AssignedFilter.create(name: 'Install Scheduled', filters: {"phase":[{"type":"Installation","status":"awaiting_install"}]}, position: 'Regional Service Manager');
  45. AssignedFilter.create(name: 'Customer Not Ready', filters: {"phase":[{"type":"Installation","status":"customer_not_ready"}]}, position: 'Regional Service Manager');
  46. AssignedFilter.create(name: 'Dispatch', filters: {"task":["install_dispatched"]}, position: 'Regional Service Manager');
  47. AssignedFilter.create(name: 'In Progress', filters: {"task":["install_in_progress"]}, position: 'Regional Service Manager');
  48. AssignedFilter.create(name: 'Installing Today', filters: {"phase":[{"type":"Installation","status":"installing"}]}, position: 'Regional Service Manager');
  49. AssignedFilter.create(name: 'Follow Up Required', filters: {"phase":[{"type":"Installation","status":"follow_up"}]}, position: 'Regional Service Manager');
  50. AssignedFilter.create(name: 'Need IB/COC', filters: {"task":["installer_paysheet_attached","coc_attached"]}, position: 'Regional Service Manager');
  51. AssignedFilter.create(name: 'WO-Received', filters: {"phase":[{"type":"Workorder","status":"receiving"}]}, position: 'Regional Service Manager');
  52. AssignedFilter.create(name: 'WO-Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Workorder","status":"cpo"}]}, position: 'Regional Service Manager');
  53. AssignedFilter.create(name: 'WO-Materials', filters: {"phase":[{"type":"Workorder","status":"materials"}],"task":["workorder_materials_requested","workorder_materials_received"]}, position: 'Regional Service Manager');
  54. AssignedFilter.create(name: 'WO-Scheduling', filters: {"phase":[{"type":"Workorder","status":"scheduling"}]}, position: 'Regional Service Manager');
  55. AssignedFilter.create(name: 'WO-Scheduled', filters: {"phase":[{"type":"Workorder","status":"awaiting_workorder"}]}, position: 'Regional Service Manager');
  56. AssignedFilter.create(name: 'WO-Customer Not Ready', filters: {"phase":[{"type":"Workorder","status":"customer_not_ready"}]}, position: 'Regional Service Manager');
  57. AssignedFilter.create(name: 'WO-Dispatch', filters: {"task":["workorder_dispatched"]}, position: 'Regional Service Manager');
  58. AssignedFilter.create(name: 'WO-In Progress', filters: {"task":["workorder_in_progress"]}, position: 'Regional Service Manager');
  59. AssignedFilter.create(name: 'WO-Follow Up Required', filters: {"phase":[{"type":"Workorder","status":"follow_up"}]}, position: 'Regional Service Manager');
  60. AssignedFilter.create(name: 'WO-Upload Signed Documents', filters: {"task":["workorder_upload_docs"]}, position: 'Regional Service Manager');
  61. AssignedFilter.create(name: 'Poor Score/Potential Issues', filters: {"flag":[{"name":"Poor Score"}]}, position: 'Regional Service Manager');
  62.  
  63.  
  64. AssignedFilter.create(name: 'Express Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}],"flag":[{"name":"Express Job"}]}, position: 'Scheduling Coordinator');
  65. AssignedFilter.create(name: 'Sent to Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}]}, position: 'Scheduling Coordinator');
  66. AssignedFilter.create(name: 'Customer Not Ready', filters: {"phase":[{"type":"Installation","status":"customer_not_ready"}]}, position: 'Scheduling Coordinator');
  67. AssignedFilter.create(name: 'WO-Sent to Scheduling', filters: {"phase":[{"type":"Workorder","status":"scheduling"}]}, position: 'Scheduling Coordinator');
  68. AssignedFilter.create(name: 'WO-Customer Not Ready', filters: {"phase":[{"type":"Workorder","status":"customer_not_ready"}]}, position: 'Scheduling Coordinator');
  69. AssignedFilter.create(name: 'Product Confirmation', filters: {"flag":[{"name":"Product Confirmation"}]}, position: 'Scheduling Coordinator');
  70. AssignedFilter.create(name: 'Poor Score/Potential Issues', filters: {"flag":[{"name":"Poor Score"}]}, position: 'Scheduling Coordinator');
  71.  
  72.  
  73. AssignedFilter.create(name: 'Received Express PO', filters: {"phase":[{"type":"Installation","status":"receiving"}],"flag":[{"name":"Express Job"}]}, position: 'Production Coordinator');
  74. AssignedFilter.create(name: 'Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Installation","status":"hold"}]}, position: 'Production Coordinator');
  75. AssignedFilter.create(name: 'Verification Not Completed', filters: {"phase":[{"type":"Installation","status":"receiving"}]}, position: 'Production Coordinator');
  76. AssignedFilter.create(name: 'Poor Score', filters: {"flag":[{"name":"Poor Score"}]}, position: 'Production Coordinator');
  77. AssignedFilter.create(name: 'Exceptions', filters: {"flag":[{"name":"Issue","suboption":"Labor"}],"phase":[{"type":"Installation"}]}, position: 'Production Coordinator');
  78. AssignedFilter.create(name: 'Refigures', filters: {"phase":[{"type":"Assessment","status":"refiguring"}],"task":["refigure_assessment"]}, position: 'Production Coordinator');
  79. AssignedFilter.create(name: 'Received PO', filters: {"task":["start_contract_verification"]}, position: 'Production Coordinator');
  80.  
  81.  
  82. AssignedFilter.create(name: 'Poor Score/Potential Issues', filters: {"flag":[{"name":"Poor Score"}]}, position: 'Customer Care Specialist');
  83. AssignedFilter.create(name: 'Follow Up Call', filters: {"task":["customer_survey_completed"]}, position: 'Customer Care Specialist');
  84. AssignedFilter.create(name: 'Appointment Confirmation', filters: {"flag":[{"name":"Appointment Confirmation"}],"phase":[{"type":"Installation","status":"awaiting_install"},{"type":"Workorder","status":"awaiting_workorder"}]}, position: 'Customer Care Specialist');
  85.  
  86.  
  87. AssignedFilter.create(name: 'Assessment to be Scheduled', filters: {"phase":[{"type":"Assessment","status":"receiving"}]}, position: 'Estimator');
  88. AssignedFilter.create(name: 'Today\'s Estimations', filters: {"phase":[{"type":"Assessment","status":"measuring"}]}, position: 'Estimator');
  89.  
  90.  
  91. AssignedFilter.create(name: 'Setup', filters: {"phase":[{"type":"Assessment","status":"setup"}]}, position: 'Installation Coordinator');
  92. AssignedFilter.create(name: 'Assessment to be Scheduled', filters: {"phase":[{"type":"Assessment","status":"receiving"}]}, position: 'Installation Coordinator');
  93. AssignedFilter.create(name: 'Assessment-Customer Not Ready', filters: {"phase":[{"type":"Assessment","status":"customer_not_ready"}]}, position: 'Installation Coordinator');
  94. AssignedFilter.create(name: 'Needs Appointment', filters: {"flag":[{"name":"Needs Appointment","suboption":"Assessment"}]}, position: 'Installation Coordinator');
  95. AssignedFilter.create(name: 'Estimator Inquiry', filters: {"flag":[{"name":"Estimator Inquiry"}]}, position: 'Installation Coordinator');
  96. AssignedFilter.create(name: 'Assessment Awaiting Measure', filters: {"phase":[{"type":"Assessment","status":"awaiting_measure"}]}, position: 'Installation Coordinator');
  97. AssignedFilter.create(name: 'Measuring', filters: {"phase":[{"type":"Assessment","status":"measuring"}]}, position: 'Installation Coordinator');
  98. AssignedFilter.create(name: 'Assessment Complete-Awaiting Approval', filters: {"phase":[{"type":"Assessment","status":"reviewing"}]}, position: 'Installation Coordinator');
  99. AssignedFilter.create(name: 'Commercial Complete-Awaiting Approval', filters: {"phase":[{"type":"Assessment","status":"reviewing"}], "flag":[{"name":"Commercial"}]}, position: 'Installation Coordinator');
  100. AssignedFilter.create(name: 'Refigure', filters: {"phase":[{"type":"Assessment","status":"refiguring"}]}, position: 'Installation Coordinator');
  101. AssignedFilter.create(name: 'Accounting Issue', filters: {"flag":[{"name":"Accounting","suboption":"Issue"}],"phase":[{"type":"Assessment"}]}, position: 'Installation Coordinator');
  102. AssignedFilter.create(name: 'No Coverage', filters: {"flag":[{"name":"No Coverage"}]}, position: 'Installation Coordinator');
  103. AssignedFilter.create(name: 'Received Express PO', filters: {"phase":[{"type":"Installation","status":"receiving"}],"flag":[{"name":"Express Job"}]}, position: 'Installation Coordinator');
  104. AssignedFilter.create(name: 'Received PO', filters: {"phase":[{"type":"Installation","status":"receiving"}]}, position: 'Installation Coordinator');
  105. AssignedFilter.create(name: 'Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Installation","status":"hold"}]}, position: 'Installation Coordinator');
  106. AssignedFilter.create(name: 'Exceptions', filters: {"flag":[{"name":"Issue","suboption":"Labor"}]}, position: 'Installation Coordinator');
  107. AssignedFilter.create(name: 'Express Sent to Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}],"flag":[{"name":"Express Job"}]}, position: 'Installation Coordinator');
  108. AssignedFilter.create(name: 'Sent to Scheduling', filters: {"phase":[{"type":"Installation","status":"scheduling"}]}, position: 'Installation Coordinator');
  109. AssignedFilter.create(name: 'Customer Not Ready', filters: {"phase":[{"type":"Installation","status":"customer_not_ready"}]}, position: 'Installation Coordinator');
  110. AssignedFilter.create(name: 'Product Confirmation', filters: {"flag":[{"name":"Product Confirmation"}]}, position: 'Installation Coordinator');
  111. AssignedFilter.create(name: 'Appointment Confirmation', filters: {"flag":[{"name":"Appointment Confirmation"}]}, position: 'Installation Coordinator');
  112. AssignedFilter.create(name: 'Dispatch', filters: {"task":["install_dispatched"]}, position: 'Installation Coordinator');
  113. AssignedFilter.create(name: 'In Progress', filters: {"task":["install_in_progress"]}, position: 'Installation Coordinator');
  114. AssignedFilter.create(name: 'Installation Complete', filters: {"phase":[{"type":"Installation","status":"installing"}],"task":["install_complete"]}, position: 'Installation Coordinator');
  115. AssignedFilter.create(name: 'Poor Score', filters: {"flag":[{"name":"Poor Score"}]}, position: 'Installation Coordinator');
  116. AssignedFilter.create(name: 'Follow Up Required', filters: {"phase":[{"type":"Installation","status":"follow_up"}]}, position: 'Installation Coordinator');
  117. AssignedFilter.create(name: 'Need IB/COC', filters: {"task":["installer_paysheet_attached","coc_attached"]}, position: 'Installation Coordinator');
  118. AssignedFilter.create(name: 'WO-Received', filters: {"phase":[{"type":"Workorder","status":"receiving"}]}, position: 'Installation Coordinator');
  119. AssignedFilter.create(name: 'WO-Issue-Waiting on Lowe\'s', filters: {"phase":[{"type":"Workorder","status":"cpo"}]}, position: 'Installation Coordinator');
  120. AssignedFilter.create(name: 'WO-Materials', filters: {"phase":[{"type":"Workorder","status":"materials"}],"task":["workorder_materials_requested","workorder_materials_received"]}, position: 'Installation Coordinator');
  121. AssignedFilter.create(name: 'WO-Scheduling', filters: {"phase":[{"type":"Workorder","status":"scheduling"}]}, position: 'Installation Coordinator');
  122. AssignedFilter.create(name: 'WO-Customer Not Ready', filters: {"phase":[{"type":"Workorder","status":"customer_not_ready"}]}, position: 'Installation Coordinator');
  123. AssignedFilter.create(name: 'WO-In Progress', filters: {"task":["workorder_in_progress"]}, position: 'Installation Coordinator');
  124. AssignedFilter.create(name: 'WO-Follow Up', filters: {"phase":[{"type":"Workorder","status":"follow_up"}]}, position: 'Installation Coordinator');
  125.  
  126. end
  127. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement