assign user manual

site_ids = [{site_id: 'JIBA0003', username: 'techaps61'},{site_id: 'JIPA0005', username: 'techaps52'},{site_id: 'JITR0004', username: 'techaps26'},{site_id: 'BTSE0022', username: 'teambanten1'},{site_id: 'BTSE0021', username: 'teambanten1'},{site_id: 'BTSE0019', username: 'teambanten1'},{site_id: 'BTSE0015', username: 'teambanten1'},{site_id: 'BTSR0084', username: 'teambanten1'},{site_id: 'BTSR0083', username: 'teambanten1'},{site_id: 'BTSR0082', username: 'teambanten1'},{site_id: 'BTSR0079', username: 'teambanten1'},{site_id: 'BTSR0078', username: 'teambanten1'},{site_id: 'BTSR0075', username: 'teambanten1'},{site_id: 'BTSR0074', username: 'teambanten1'},{site_id: 'BTSR0072', username: 'teambanten1'},{site_id: 'BTSR0068', username: 'teambanten1'},{site_id: 'BTSR0066', username: 'teambanten1'},{site_id: 'BTSR0065', username: 'teambanten1'},{site_id: 'BTSR0060', username: 'teambanten1'},{site_id: 'BTSR0058', username: 'teambanten1'},{site_id: 'BTSR0056', username: 'teambanten1'},{site_id: 'BTSR0055', username: 'teambanten1'},{site_id: 'BTSR0053', username: 'teambanten1'},{site_id: 'BTSR0052', username: 'teambanten1'},{site_id: 'BTSR0048', username: 'teambanten1'},{site_id: 'BTSR0042', username: 'teambanten1'},{site_id: 'BTSR0040', username: 'teambanten1'},{site_id: 'BTSR0038', username: 'teambanten1'},{site_id: 'BTSR0037', username: 'teambanten1'},{site_id: 'BTSR0008', username: 'teambanten1'},{site_id: 'BTSR0007', username: 'teambanten1'},{site_id: 'BTSR0005', username: 'teambanten1'},{site_id: 'BTSE0010', username: 'teambanten1'},{site_id: 'BTSR0012', username: 'teambanten1'},{site_id: 'BTSE0020', username: 'teambanten1'},{site_id: 'BTSE0018', username: 'teambanten1'},{site_id: 'BTSE0017', username: 'teambanten1'},{site_id: 'BTSE0016', username: 'teambanten1'},{site_id: 'BTSE0014', username: 'teambanten1'},{site_id: 'BTSE0013', username: 'teambanten1'},{site_id: 'BTTG0112', username: 'teambanten1'},{site_id: 'BTTG0109', username: 'teambanten1'},{site_id: 'BTSR0077', username: 'teambanten1'},{site_id: 'BTSR0076', username: 'teambanten1'},{site_id: 'BTSR0069', username: 'teambanten1'},{site_id: 'BTSR0064', username: 'teambanten1'},{site_id: 'BTSR0046', username: 'teambanten1'},{site_id: 'BTSR0043', username: 'teambanten1'},{site_id: 'BTSR0041', username: 'teambanten1'},{site_id: 'BTSR0039', username: 'teambanten1'},{site_id: 'BTSR0036', username: 'teambanten1'},{site_id: 'BTSR0035', username: 'teambanten1'},{site_id: 'BTSR0034', username: 'teambanten1'},{site_id: 'BTSR0033', username: 'teambanten1'},{site_id: 'BTSR0032', username: 'teambanten1'},{site_id: 'BTSR0030', username: 'teambanten1'},{site_id: 'BTSR0028', username: 'teambanten1'},{site_id: 'BTSR0027', username: 'teambanten1'},{site_id: 'BTSR0026', username: 'teambanten1'},{site_id: 'BTSR0025', username: 'teambanten1'},{site_id: 'BTSR0024', username: 'teambanten1'},{site_id: 'BTSR0023', username: 'teambanten1'},{site_id: 'BTSR0022', username: 'teambanten1'},{site_id: 'BTSR0017', username: 'teambanten1'},{site_id: 'BTSR0015', username: 'teambanten1'},{site_id: 'BTSR0013', username: 'teambanten1'},{site_id: 'BTSE0004', username: 'teambanten1'},{site_id: 'BTSE0003', username: 'teambanten1'},{site_id: 'JBCN0006', username: 'rizqanbr'},{site_id: 'JBBD0276', username: 'techbum07'},{site_id: 'JBTA0045', username: 'techbum03'},{site_id: 'JBTA0043', username: 'techbum03'},{site_id: 'JBTA0042', username: 'techbum03'},{site_id: 'JBTA0017', username: 'techbum03'},{site_id: 'JBTA0007', username: 'techbum03'},{site_id: 'JBTA0005', username: 'techbum03'},{site_id: 'JBTA0049', username: 'techbum03'},{site_id: 'JBTA0048', username: 'techbum03'},{site_id: 'JBTA0046', username: 'techbum03'},{site_id: 'JBTA0032', username: 'techbum03'},{site_id: 'JBTA0024', username: 'techbum03'},{site_id: 'JBTA0018', username: 'techbum03'},{site_id: 'JBTA0015', username: 'techbum03'},{site_id: 'JBTA0014', username: 'techbum03'},{site_id: 'JBTA0003', username: 'techbum03'},{site_id: 'JBTA0001', username: 'techbum03'},{site_id: 'SI.JBTA0008', username: 'techbum03'},{site_id: 'SI.JBTA0014', username: 'techbum03'},{site_id: 'SI.JBTA0012', username: 'techbum03'},{site_id: 'BTPD0052', username: 'teambanten4'},{site_id: 'BTPD0050', username: 'teambanten4'},{site_id: 'BTPD0047', username: 'teambanten4'},{site_id: 'BTPD0046', username: 'teambanten4'},{site_id: 'BTPD0044', username: 'teambanten4'},{site_id: 'BTPD0042', username: 'teambanten4'},{site_id: 'BTPD0024', username: 'teambanten4'},{site_id: 'BTLB0066', username: 'teambanten4'},{site_id: 'BTLB0064', username: 'teambanten4'},{site_id: 'BTLB0063', username: 'teambanten4'},{site_id: 'BTLB0062', username: 'teambanten4'},{site_id: 'BTLB0059', username: 'teambanten4'},{site_id: 'BTLB0058', username: 'teambanten4'},{site_id: 'BTLB0057', username: 'teambanten4'},{site_id: 'BTLB0056', username: 'teambanten4'},{site_id: 'BTLB0054', username: 'teambanten4'},{site_id: 'BTLB0052', username: 'teambanten4'},{site_id: 'BTLB0050', username: 'teambanten4'},{site_id: 'BTLB0036', username: 'teambanten4'},{site_id: 'BTLB0033', username: 'teambanten4'},{site_id: 'BTLB0031', username: 'teambanten4'},{site_id: 'BTLB0030', username: 'teambanten4'},{site_id: 'BTLB0027', username: 'teambanten4'},{site_id: 'BTLB0022', username: 'teambanten4'},{site_id: 'BTLB0020', username: 'teambanten4'},{site_id: 'BTLB0019', username: 'teambanten4'},{site_id: 'BTLB0007', username: 'teambanten4'},{site_id: 'BTLB0004', username: 'teambanten4'},{site_id: 'BTLB0003', username: 'teambanten4'},{site_id: 'BTLB0001', username: 'teambanten4'},{site_id: 'BTPD0049', username: 'teambanten4'},{site_id: 'BTPD0020', username: 'teambanten4'},{site_id: 'BTPD0019', username: 'teambanten4'},{site_id: 'BTPD0017', username: 'teambanten4'},{site_id: 'BTPD0016', username: 'teambanten4'},{site_id: 'BTPD0015', username: 'teambanten4'},{site_id: 'BTPD0014', username: 'teambanten4'},{site_id: 'BTLB0055', username: 'teambanten4'},{site_id: 'BTLB0047', username: 'teambanten4'},{site_id: 'BTLB0044', username: 'teambanten4'},{site_id: 'BTLB0040', username: 'teambanten4'},{site_id: 'BTLB0039', username: 'teambanten4'},{site_id: 'BTLB0026', username: 'teambanten4'},{site_id: 'BTLB0018', username: 'teambanten4'},{site_id: 'BTLB0017', username: 'teambanten4'},{site_id: 'BTLB0016', username: 'teambanten4'},{site_id: 'BTLB0015', username: 'teambanten4'},{site_id: 'BTLB0014', username: 'teambanten4'},{site_id: 'BTLB0009', username: 'teambanten4'},{site_id: 'BTLB0008', username: 'teambanten4'},{site_id: 'BTLB0006', username: 'teambanten4'},{site_id: 'BTJB0001', username: 'teambanten4'},{site_id: 'JIJE0021', username: 'techaps32'},{site_id: 'JIJE0018', username: 'techaps32'},{site_id: 'JIBA0012', username: 'techaps35'},{site_id: 'JIMB0016', username: 'techaps35'},{site_id: 'SMC.JIKI0010', username: 'techaps28'},{site_id: 'JIKI0006', username: 'techaps28'},{site_id: 'JIKI0002', username: 'techaps28'},{site_id: 'JIKB0031', username: 'techaps28'},{site_id: 'JIKB0012', username: 'techaps28'},{site_id: 'JTRM0012', username: 'msjateng06'},{site_id: 'JTRM0009', username: 'msjateng06'},{site_id: 'JTRM0007', username: 'msjateng06'},{site_id: 'JTPT0012', username: 'msjateng06'},{site_id: 'JTPT0011', username: 'msjateng06'},{site_id: 'JTPT0009', username: 'msjateng06'},{site_id: 'JTPT0008', username: 'msjateng06'},{site_id: 'JTGR0002', username: 'msjateng06'},{site_id: 'JTGB0004', username: 'msjateng06'},{site_id: 'JTGB0002', username: 'msjateng06'},{site_id: 'JTGB0001', username: 'msjateng06'},{site_id: 'JTWG0022', username: 'tsmtech20'},{site_id: 'JIML0008', username: 'techaps02'},{site_id: 'JTCL0028', username: 'tsmtech22'},{site_id: 'JTCL0027', username: 'tsmtech22'},{site_id: 'JTCL0026', username: 'tsmtech22'},{site_id: 'JTCL0014', username: 'tsmtech22'},{site_id: 'JTCL0013', username: 'tsmtech22'},{site_id: 'JTCL0011', username: 'tsmtech22'},{site_id: 'JTBY0011', username: 'tsmtech22'},{site_id: 'JTBR0023', username: 'tsmtech22'},{site_id: 'JTBR0004', username: 'tsmtech22'},{site_id: 'JTBR0001', username: 'tsmtech22'},{site_id: 'JTBM0031', username: 'tsmtech22'},{site_id: 'JTBM0027', username: 'tsmtech22'},{site_id: 'JTBM0026', username: 'tsmtech22'},{site_id: 'JTBM0018', username: 'tsmtech22'},{site_id: 'BTSE0007', username: 'teambanten2'},{site_id: 'BTCI0042', username: 'teambanten2'},{site_id: 'BTCI0040', username: 'teambanten2'},{site_id: 'BTCI0039', username: 'teambanten2'},{site_id: 'BTCI0025', username: 'teambanten2'},{site_id: 'BTCI0023', username: 'teambanten2'},{site_id: 'BTSR0049', username: 'teambanten2'},{site_id: 'BTCI0041', username: 'teambanten2'},{site_id: 'BTSE0006', username: 'teambanten2'},{site_id: 'BTPD0041', username: 'teambanten2'},{site_id: 'BTPD0040', username: 'teambanten2'},{site_id: 'BTPD0039', username: 'teambanten2'},{site_id: 'BTPD0035', username: 'teambanten2'},{site_id: 'BTPD0029', username: 'teambanten2'},{site_id: 'BTPD0025', username: 'teambanten2'},{site_id: 'BTPD0023', username: 'teambanten2'},{site_id: 'BTPD0022', username: 'teambanten2'},{site_id: 'BTPD0008', username: 'teambanten2'},{site_id: 'BTPD0007', username: 'teambanten2'},{site_id: 'BTPD0001', username: 'teambanten2'},{site_id: 'BTTK0044', username: 'teambanten2'},{site_id: 'BTSE0001', username: 'teambanten2'},{site_id: 'BTCI0036', username: 'teambanten2'},{site_id: 'BTCI0035', username: 'teambanten2'},{site_id: 'BTCI0032', username: 'teambanten2'},{site_id: 'BTCI0029', username: 'teambanten2'},{site_id: 'BTCI0028', username: 'teambanten2'},{site_id: 'BTCI0026', username: 'teambanten2'},{site_id: 'BTCI0021', username: 'teambanten2'},{site_id: 'BTCI0019', username: 'teambanten2'},{site_id: 'BTCI0015', username: 'teambanten2'},{site_id: 'BTCI0014', username: 'teambanten2'},{site_id: 'BTCI0013', username: 'teambanten2'},{site_id: 'BTCI0006', username: 'teambanten2'},{site_id: 'BTCI0004', username: 'teambanten2'},{site_id: 'BTCI0001', username: 'teambanten2'},{site_id: 'BTSR0021', username: 'teambanten2'},{site_id: 'BTSR0020', username: 'teambanten2'},{site_id: 'BTSR0016', username: 'teambanten2'},{site_id: 'BTSR0014', username: 'teambanten2'},{site_id: 'BTCI0008', username: 'teambanten2'},{site_id: 'BTPD0054', username: 'teambanten2'},{site_id: 'BTPD0036', username: 'teambanten2'},{site_id: 'BTPD0030', username: 'teambanten2'},{site_id: 'BTPD0028', username: 'teambanten2'},{site_id: 'BTPD0012', username: 'teambanten2'},{site_id: 'BTPD0005', username: 'teambanten2'},{site_id: 'BTPD0004', username: 'teambanten2'},{site_id: 'BTPD0003', username: 'teambanten2'},{site_id: 'BTPD0002', username: 'teambanten2'},{site_id: 'JTSM0050', username: 'msjateng05'},{site_id: 'JTTE0002', username: 'tsmtech25'},{site_id: 'JTTE0010', username: 'tsmtech25'},{site_id: 'JTTE0008', username: 'tsmtech25'},{site_id: 'JTTE0005', username: 'tsmtech25'},{site_id: 'JTTB0004', username: 'tsmtech25'},{site_id: 'JTTB0003', username: 'tsmtech25'},{site_id: 'JTTB0001', username: 'tsmtech25'},{site_id: 'JTBR0025', username: 'tsmtech25'},{site_id: 'JTBR0009', username: 'tsmtech25'},{site_id: 'JTBR0007', username: 'tsmtech25'},{site_id: 'JTBR0003', username: 'tsmtech25'},{site_id: 'SI.JTTK0001', username: 'tsmtech25'},{site_id: 'JBSD0032', username: 'engbndngpeb'},{site_id: 'JBSD0031', username: 'engbndngpeb'},{site_id: 'JBSD0030', username: 'engbndngpeb'},{site_id: 'JBSD0029', username: 'engbndngpeb'},{site_id: 'JBSD0023', username: 'engbndngpeb'},{site_id: 'JBSD0022', username: 'engbndngpeb'},{site_id: 'JBSD0021', username: 'engbndngpeb'},{site_id: 'JBSD0020', username: 'engbndngpeb'},{site_id: 'JBSD0019', username: 'engbndngpeb'},{site_id: 'JBSD0017', username: 'engbndngpeb'},{site_id: 'JBSD0015', username: 'engbndngpeb'},{site_id: 'JBSD0013', username: 'engbndngpeb'},{site_id: 'JBSD0012', username: 'engbndngpeb'},{site_id: 'JBSD0007', username: 'engbndngpeb'},{site_id: 'JBSD0006', username: 'engbndngpeb'},{site_id: 'JBSD0005', username: 'engbndngpeb'},{site_id: 'SI.JBCR0008', username: 'engbndngpeb'},{site_id: 'JBSD0036', username: 'engbndngpeb'},{site_id: 'JBSD0035', username: 'engbndngpeb'},{site_id: 'JBSD0026', username: 'engbndngpeb'},{site_id: 'JBSD0024', username: 'engbndngpeb'},{site_id: 'JBSD0018', username: 'engbndngpeb'},{site_id: 'JBSD0016', username: 'engbndngpeb'},{site_id: 'JBSD0008', username: 'engbndngpeb'},{site_id: 'JBSD0004', username: 'engbndngpeb'},{site_id: 'JBSD0001', username: 'engbndngpeb'},{site_id: 'SI.JBBD0020', username: 'engbndngpeb'},{site_id: 'BTTG0110', username: 'teambanten3'},{site_id: 'BTTK0095', username: 'teambanten3'},{site_id: 'BTTK0104', username: 'teambanten3'},{site_id: 'BTTK0103', username: 'teambanten3'},{site_id: 'BTTG0175', username: 'teambanten3'},{site_id: 'BTTG0168', username: 'teambanten3'},{site_id: 'BTTG0158', username: 'teambanten3'},{site_id: 'BTTG0153', username: 'teambanten3'},{site_id: 'BTTG0152', username: 'teambanten3'},{site_id: 'BTTG0151', username: 'teambanten3'},{site_id: 'BTTG0149', username: 'teambanten3'},{site_id: 'BTTG0144', username: 'teambanten3'},{site_id: 'BTTG0123', username: 'teambanten3'},{site_id: 'BTTG0111', username: 'teambanten3'},{site_id: 'BTTG0107', username: 'teambanten3'},{site_id: 'BTTG0106', username: 'teambanten3'},{site_id: 'BTTG0105', username: 'teambanten3'},{site_id: 'BTTG0103', username: 'teambanten3'},{site_id: 'BTTG0102', username: 'teambanten3'},{site_id: 'BTTG0101', username: 'teambanten3'},{site_id: 'BTTG0099', username: 'teambanten3'},{site_id: 'BTTG0098', username: 'teambanten3'},{site_id: 'BTTG0096', username: 'teambanten3'},{site_id: 'BTTG0095', username: 'teambanten3'},{site_id: 'BTTG0094', username: 'teambanten3'},{site_id: 'BTTG0093', username: 'teambanten3'},{site_id: 'BTTG0092', username: 'teambanten3'},{site_id: 'BTTG0091', username: 'teambanten3'},{site_id: 'BTTG0090', username: 'teambanten3'},{site_id: 'BTTG0089', username: 'teambanten3'},{site_id: 'BTTG0088', username: 'teambanten3'},{site_id: 'BTTG0087', username: 'teambanten3'},{site_id: 'BTTG0086', username: 'teambanten3'},{site_id: 'BTTG0085', username: 'teambanten3'},{site_id: 'BTTG0084', username: 'teambanten3'},{site_id: 'BTTG0083', username: 'teambanten3'},{site_id: 'BTTG0076', username: 'teambanten3'},{site_id: 'BTTG0070', username: 'teambanten3'},{site_id: 'BTTG0069', username: 'teambanten3'},{site_id: 'BTTG0068', username: 'teambanten3'},{site_id: 'BTTG0056', username: 'teambanten3'},{site_id: 'BTTG0055', username: 'teambanten3'},{site_id: 'BTTG0048', username: 'teambanten3'},{site_id: 'BTTG0046', username: 'teambanten3'},{site_id: 'BTTG0041', username: 'teambanten3'},{site_id: 'BTTG0040', username: 'teambanten3'},{site_id: 'BTTG0013', username: 'teambanten3'},{site_id: 'JBCR0003', username: 'restubum'},{site_id: 'JBMJ0006', username: 'restubum'},{site_id: 'JBIM0042', username: 'restubum'},{site_id: 'JBIM0040', username: 'restubum'},{site_id: 'JBIM0036', username: 'restubum'},{site_id: 'JBIM0026', username: 'restubum'},{site_id: 'JBIM0016', username: 'restubum'},{site_id: 'JBIM0010', username: 'restubum'},{site_id: 'SI.JBCR0001', username: 'restubum'},{site_id: 'SI.JBIM0003', username: 'restubum'},{site_id: 'SI.JBCR0022', username: 'restubum'},{site_id: 'SI.JBCR0016', username: 'restubum'},{site_id: 'JIMB0076', username: 'techaps44'},{site_id: 'JIJO0015', username: 'techaps57'},{site_id: 'JIJO0002', username: 'techaps57'},{site_id: 'JIMK0015', username: 'techaps57'},{site_id: 'JIMK0027', username: 'techaps57'},{site_id: 'YOKP0010', username: 'tsmtech26'},{site_id: 'YOKP0009', username: 'tsmtech26'},{site_id: 'YOKP0006', username: 'tsmtech26'},{site_id: 'YOKP0005', username: 'tsmtech26'},{site_id: 'JTKP0001', username: 'tsmtech26'},{site_id: 'YOSL0032', username: 'tsmtech26'},{site_id: 'YOSL0027', username: 'tsmtech26'},{site_id: 'JTMG0044', username: 'tsmtech26'},{site_id: 'JBMJ0005', username: 'techbum13'},{site_id: 'JBCR0014', username: 'techbum13'},{site_id: 'JBCR0012', username: 'techbum13'},{site_id: 'JTPK0006', username: 'tsmtech07'},{site_id: 'JTTE0013', username: 'tsmtech07'},{site_id: 'JTTE0012', username: 'tsmtech07'},{site_id: 'JTTE0009', username: 'tsmtech07'},{site_id: 'JTTE0007', username: 'tsmtech07'},{site_id: 'JTTE0006', username: 'tsmtech07'},{site_id: 'JTTB0006', username: 'tsmtech07'},{site_id: 'JTTB0002', username: 'tsmtech07'},{site_id: 'JTPE0014', username: 'tsmtech07'},{site_id: 'JTPE0013', username: 'tsmtech07'},{site_id: 'JTPE0012', username: 'tsmtech07'},{site_id: 'JTPE0009', username: 'tsmtech07'},{site_id: 'JTPE0008', username: 'tsmtech07'},{site_id: 'JTPK0011', username: 'tsmtech07'},{site_id: 'SI.JTPE0002', username: 'tsmtech07'},{site_id: 'SI.JTPE0001', username: 'tsmtech07'},{site_id: 'JISU0035', username: 'techaps19'},{site_id: 'JISU0028', username: 'techaps19'},{site_id: 'JKJB0203', username: 'ms01'},{site_id: 'JKJT0161', username: 'ms01'},{site_id: 'JKJU0187', username: 'ms01'},{site_id: 'JKJU0173', username: 'ms01'},{site_id: 'JKJU0170', username: 'ms01'},{site_id: 'JKJU0126', username: 'ms01'},{site_id: 'JKJU0120', username: 'ms01'},{site_id: 'JKJU0069', username: 'ms01'},{site_id: 'JKJU0051', username: 'ms01'},{site_id: 'JKJU0046', username: 'ms01'},{site_id: 'JKJU0042', username: 'ms01'},{site_id: 'JKJU0015', username: 'ms01'},{site_id: 'JKJP0171', username: 'ms01'},{site_id: 'JKJP0168', username: 'ms01'},{site_id: 'JKJP0167', username: 'ms01'},{site_id: 'JKJP0160', username: 'ms01'},{site_id: 'JKJP0154', username: 'ms01'},{site_id: 'JKJP0152', username: 'ms01'},{site_id: 'JKJP0150', username: 'ms01'},{site_id: 'JKJP0132', username: 'ms01'},{site_id: 'JKJP0129', username: 'ms01'},{site_id: 'JKJP0087', username: 'ms01'},{site_id: 'JKJP0073', username: 'ms01'},{site_id: 'JKJB0228', username: 'ms01'},{site_id: 'JKJB0227', username: 'ms01'},{site_id: 'JKJB0225', username: 'ms01'},{site_id: 'JKJB0222', username: 'ms01'},{site_id: 'JKJB0219', username: 'ms01'},{site_id: 'JKJB0218', username: 'ms01'},{site_id: 'JKJB0214', username: 'ms01'},{site_id: 'JKJB0210', username: 'ms01'},{site_id: 'JKJB0207', username: 'ms01'},{site_id: 'JKJB0205', username: 'ms01'},{site_id: 'JKJB0199', username: 'ms01'},{site_id: 'JKJB0189', username: 'ms01'},{site_id: 'JKJB0165', username: 'ms01'},{site_id: 'JKJB0131', username: 'ms01'},{site_id: 'JKJB0117', username: 'ms01'},{site_id: 'JKJB0089', username: 'ms01'},{site_id: 'JKJB0088', username: 'ms01'},{site_id: 'JKJB0021', username: 'ms01'},{site_id: 'JKJS0275', username: 'ms01'},{site_id: 'JKJS0093', username: 'ms01'},{site_id: 'SMC.JKJP0001', username: 'ms01'},{site_id: 'JKJU0053', username: 'ms01'},{site_id: 'JKJU0049', username: 'ms01'},{site_id: 'JKJU0047', username: 'ms01'},{site_id: 'JKJU0035', username: 'ms01'},{site_id: 'JKJP0170', username: 'ms01'},{site_id: 'JKJP0134', username: 'ms01'},{site_id: 'JKJP0133', username: 'ms01'},{site_id: 'JKJP0077', username: 'ms01'},{site_id: 'JKJP0067', username: 'ms01'},{site_id: 'JKJP0049', username: 'ms01'},{site_id: 'JKJP0037', username: 'ms01'},{site_id: 'JKJP0021', username: 'ms01'},{site_id: 'JKJP0008', username: 'ms01'},{site_id: 'JKJP0006', username: 'ms01'},{site_id: 'JKJS0019', username: 'ms01'},{site_id: 'JKJP0034', username: 'ms01'},{site_id: 'JKJB0231', username: 'ms01'},{site_id: 'JKJB0212', username: 'ms01'},{site_id: 'JKJB0204', username: 'ms01'},{site_id: 'JKJB0193', username: 'ms01'},{site_id: 'JKJB0192', username: 'ms01'},{site_id: 'JKJB0158', username: 'ms01'},{site_id: 'JKJB0151', username: 'ms01'},{site_id: 'JKJB0141', username: 'ms01'},{site_id: 'JKJB0139', username: 'ms01'},{site_id: 'JKJB0133', username: 'ms01'},{site_id: 'JKJB0116', username: 'ms01'},{site_id: 'JKJB0113', username: 'ms01'},{site_id: 'JKJB0112', username: 'ms01'},{site_id: 'JKJB0110', username: 'ms01'},{site_id: 'JKJB0108', username: 'ms01'},{site_id: 'JKJB0105', username: 'ms01'},{site_id: 'JKJB0076', username: 'ms01'},{site_id: 'JKJB0074', username: 'ms01'},{site_id: 'JKJB0057', username: 'ms01'},{site_id: 'JKJB0055', username: 'ms01'},{site_id: 'JKJB0034', username: 'ms01'},{site_id: 'JKJB0002', username: 'ms01'},{site_id: 'JIPS0019', username: 'techaps30'},{site_id: 'JIPS0034', username: 'techaps30'},{site_id: 'JIPS0004', username: 'techaps30'},{site_id: 'JIBN0032', username: 'techaps39'},{site_id: 'JIBN0034', username: 'techaps39'},{site_id: 'JTSK0005', username: 'tsmtech27'},{site_id: 'JTSH0016', username: 'tsmtech27'},{site_id: 'JTSH0014', username: 'tsmtech27'},{site_id: 'JTSH0010', username: 'tsmtech27'},{site_id: 'JTSH0009', username: 'tsmtech27'},{site_id: 'JTSH0007', username: 'tsmtech27'},{site_id: 'JTSH0006', username: 'tsmtech27'},{site_id: 'JTSH0004', username: 'tsmtech27'},{site_id: 'JTKL0013', username: 'tsmtech27'},{site_id: 'JTSR0018', username: 'tsmtech27'},{site_id: 'JTSR0017', username: 'tsmtech27'},{site_id: 'JTSR0016', username: 'tsmtech27'},{site_id: 'JTSH0002', username: 'tsmtech27'},{site_id: 'SI.JIMG0002', username: 'techaps04'},{site_id: 'SI.JIML0008', username: 'techaps04'},{site_id: 'SI.JIML0007', username: 'techaps04'},{site_id: 'JIBG0015', username: 'techaps55'},{site_id: 'JBBD0139', username: 'wahyudibr'},{site_id: 'JBCN0062', username: 'wahyudibr'},{site_id: 'JKJP0146', username: 'ms10'},{site_id: 'JKJP0002', username: 'ms10'},{site_id: 'JKJT0187', username: 'ms10'},{site_id: 'JKJT0162', username: 'ms10'},{site_id: 'JKJT0063', username: 'ms10'},{site_id: 'JKJT0035', username: 'ms10'},{site_id: 'JKJU0172', username: 'ms10'},{site_id: 'JKJU0167', username: 'ms10'},{site_id: 'JKJU0165', username: 'ms10'},{site_id: 'JKJU0164', username: 'ms10'},{site_id: 'JKJU0160', username: 'ms10'},{site_id: 'JKJU0157', username: 'ms10'},{site_id: 'JKJU0155', username: 'ms10'},{site_id: 'JKJU0151', username: 'ms10'},{site_id: 'JKJU0149', username: 'ms10'},{site_id: 'JKJU0075', username: 'ms10'},{site_id: 'JKJU0068', username: 'ms10'},{site_id: 'JKJU0061', username: 'ms10'},{site_id: 'JKJU0058', username: 'ms10'},{site_id: 'JKJU0055', username: 'ms10'},{site_id: 'JKJU0029', username: 'ms10'},{site_id: 'JKJU0010', username: 'ms10'},{site_id: 'JKJT0026', username: 'ms10'},{site_id: 'JKJP0159', username: 'ms10'},{site_id: 'JKJP0153', username: 'ms10'},{site_id: 'JKJP0097', username: 'ms10'},{site_id: 'JKJP0081', username: 'ms10'},{site_id: 'JKJP0070', username: 'ms10'},{site_id: 'JKJP0054', username: 'ms10'},{site_id: 'JKJB0229', username: 'ms10'},{site_id: 'JKJB0135', username: 'ms10'},{site_id: 'JKJB0050', username: 'ms10'},{site_id: 'JKJB0045', username: 'ms10'},{site_id: 'JKJB0032', username: 'ms10'},{site_id: 'JKJU0017', username: 'ms10'},{site_id: 'JKJT0200', username: 'ms10'},{site_id: 'JKJT0173', username: 'ms10'},{site_id: 'JKJT0132', username: 'ms10'},{site_id: 'JKJT0109', username: 'ms10'},{site_id: 'JKJT0067', username: 'ms10'},{site_id: 'JKJT0062', username: 'ms10'},{site_id: 'JKJT0052', username: 'ms10'},{site_id: 'JKJT0051', username: 'ms10'},{site_id: 'JKJT0034', username: 'ms10'},{site_id: 'JKJT0031', username: 'ms10'},{site_id: 'JKJT0024', username: 'ms10'},{site_id: 'JKJT0010', username: 'ms10'},{site_id: 'SMC.JBDP0074', username: 'ms10'},{site_id: 'JKJU0176', username: 'ms10'},{site_id: 'JKJU0168', username: 'ms10'},{site_id: 'JKJU0148', username: 'ms10'},{site_id: 'JKJU0147', username: 'ms10'},{site_id: 'JKJU0146', username: 'ms10'},{site_id: 'JKJU0143', username: 'ms10'},{site_id: 'JKJU0142', username: 'ms10'},{site_id: 'JKJU0141', username: 'ms10'},{site_id: 'JKJU0108', username: 'ms10'},{site_id: 'JKJU0081', username: 'ms10'},{site_id: 'JKJU0080', username: 'ms10'},{site_id: 'JKJU0072', username: 'ms10'},{site_id: 'JKJU0060', username: 'ms10'},{site_id: 'JKJU0041', username: 'ms10'},{site_id: 'JKJU0040', username: 'ms10'},{site_id: 'JKJU0037', username: 'ms10'},{site_id: 'JKJU0019', username: 'ms10'},{site_id: 'JKJU0018', username: 'ms10'},{site_id: 'JKJU0008', username: 'ms10'},{site_id: 'JKJU0005', username: 'ms10'},{site_id: 'JKJU0003', username: 'ms10'},{site_id: 'JKJT0019', username: 'ms10'},{site_id: 'JKJP0007', username: 'ms10'},{site_id: 'JKJP0111', username: 'ms10'},{site_id: 'JKJP0108', username: 'ms10'},{site_id: 'JKJP0105', username: 'ms10'},{site_id: 'JKJP0086', username: 'ms10'},{site_id: 'JKJP0083', username: 'ms10'},{site_id: 'JKJP0080', username: 'ms10'},{site_id: 'JKJP0055', username: 'ms10'},{site_id: 'JKJP0027', username: 'ms10'},{site_id: 'JKJB0056', username: 'ms10'},{site_id: 'JKJB0052', username: 'ms10'},{site_id: 'JKJB0044', username: 'ms10'},{site_id: 'YOGK0022', username: 'tsmtech18'},{site_id: 'JTKL0039', username: 'tsmtech18'},{site_id: 'JTKL0038', username: 'tsmtech18'},{site_id: 'JTKL0033', username: 'tsmtech18'},{site_id: 'JTKL0030', username: 'tsmtech18'},{site_id: 'JTKL0022', username: 'tsmtech18'},{site_id: 'JTKL0020', username: 'tsmtech18'},{site_id: 'JTKL0019', username: 'tsmtech18'},{site_id: 'JTKL0016', username: 'tsmtech18'},{site_id: 'JTKL0015', username: 'tsmtech18'},{site_id: 'JTKL0001', username: 'tsmtech18'},{site_id: 'JIMB0045', username: 'techaps34'},{site_id: 'JIMB0004', username: 'techaps34'},{site_id: '41120101', username: 'tsmtech26'},{site_id: '41110015', username: 'techbum05'},{site_id: '41100030', username: 'techbum05'},{site_id: '41050075', username: 'rizqanbr'},{site_id: '31030207', username: 'ms01'},{site_id: '31030206', username: 'ms10'},{site_id: '42060020', username: 'teambanten2'},{site_id: '42060008', username: 'teambanten2'},{site_id: '42060007', username: 'teambanten2'},{site_id: '42060005', username: 'teambanten2'},{site_id: '42060003', username: 'teambanten2'},{site_id: 'JBTA0006', username: 'techbum03'},{site_id: 'JKJP0057', username: 'ms01'}]
not_present = []
berhasil = []
gagal = []
site_ids.each do |data|
  site = Site.where(site_id_customer: data[:site_id]).first
  sch = Schedule.where(site_id: site.id).where("DATE(work_date) >= DATE(?)", '2020-02-01').first
  not_present << data[:site_id] if sch.blank?
  next if sch.blank?
  user = User.where(username: data[:username]).first
  sch.user_id = user.id
  if sch.save
    berhasil << data[:site_id]
  else
    gagal << [sch.errors.full_messages, data[:site_id]]
  end
end