public function run()
{
Model::unguard();
$this->cleanDatabase();
/*
* Create JFS Workflows and attach Tasks
*/
$workflows = ['Equipment Status' => ['Firewalls ordered with AT&T', 'Equipment Shipped', 'Equipment at site', 'Equipment Racked and Stacked', 'Equipment Install Ready'], 'Engineering Status' => ['Pre-Design and Analysis Completed', 'Engineer Call Completed', 'Configurations Ready', 'CR Submitted', 'Phase 1 Completed', 'Phase 2 Completed', 'Operations Ready'], 'Site Status' => ['JFS Requested', 'JFS Implementation in Process', 'JFS Completed']];
foreach ($workflows as $workflow => $tasks) {
$wf = \App\Models\Jfs\Workflow::create(['name' => $workflow]);
foreach ($tasks as $task) {
$t = new \App\Models\Jfs\Task(['name' => $task]);
$wf->tasks()->save($t);
}
}
/*
* Create JFS Sites
*/
$sites = ['01-CA01-BSTN-H-007-RT-01', '01-MAXB-BSTN-H-014-RT-01', '01-MAXB-WRCS-R-016-RT-01', '01-MAXD-LWRN-R-032-RT-01', '01-MAXD-SPRN-R-040-RT-01', '01-MAXP-TAUN-R-094-RT-01', '01-MAXP-WRCS-R-030-RT-01', '01-MEXA-PRTL-R-070-RT-01', '01-MEXB-PRTL-H-022-RT-01', '01-MEXD-BNGR-R-018-RT-01', '01-MEXD-PRTL-H-020-RT-01', '01-MEXP-PRTL-H-092-RT-01', '01-NHXB-MNCH-H-038-RT-01', '01-NHXD-CNCR-H-024-RT-01', '01-NHXP-MNCH-R-031-RT-01', '01-PRXA-SNJN-R-095-RT-01', '01-PRXB-PONC-R-056-RT-01', '01-PRXB-SNJN-H-054-RT-01', '01-PRXD-SNJN-H-004-RT-01', '01-RIXA-PRVD-R-096-RT-01', '01-RIXB-PRVD-H-028-RT-01', '01-RIXD-PRVD-H-002-RT-01', '02-CA02-NWYK-H-121-RT-01', '02-CTXA-NWHV-R-096-RT-01', '02-CTXA-NWHV-R-098-RT-01', '02-CTXB-HRTF-H-042-RT-01', '02-CTXD-BRDG-R-040-RT-01', '02-CTXD-NWHV-H-044-RT-01', '02-CTXP-NWHV-R-076-RT-01', '02-NYEB-BRKL-H-108-RT-01', '02-NYED-BRKL-H-100-RT-01', '02-NYED-ISLP-R-104-RT-01', '02-NYEP-BRKL-R-122-RT-01', '02-NYEP-QUEN-R-022-RT-01', '02-NYNB-ALBN-H-056-RT-01', '02-NYND-BNGH-R-082-RT-01', '02-NYND-PLTB-R-120-RT-01', '02-NYND-SRCS-H-058-RT-01', '02-NYND-UTIC-R-086-RT-01', '02-NYSB-NWYK-H-062-RT-01', '02-NYSB-PGHK-R-084-RT-01', '02-NYSD-NWYK-H-050-RT-01', '02-NYSD-WHTP-R-068-RT-01', '02-NYWA-GENS-R-054-RT-01', '02-NYWB-BFFL-H-094-RT-01', '02-NYWD-BFFL-H-130-RT-01', '02-NYWD-RCHS-R-038-RT-01', '02-VTXB-RTLN-R-080-RT-01', '02-VTXD-BRLN-H-002-RT-01', '02-VTXD-BRTT-R-078-RT-01', '03-CA03-PHLD-H-004-RT-01', '03-DEXB-WLMN-H-080-RT-01', '03-DEXD-WLMN-H-036-RT-01', '03-DEXP-DOVR-R-068-RT-01', '03-NJXB-CMDN-R-028-RT-01', '03-NJXB-NWRK-H-024-RT-01', '03-NJXD-CMDN-R-030-RT-01', '03-NJXD-TRNT-H-002-RT-01', '03-NJXP-LNWD-R-076-RT-01', '03-NJXP-PTRS-R-042-RT-01', '03-NJXP-TNTN-R-044-RT-01', '03-PAEA-ESTN-R-070-RT-01', '03-PAEB-PHLD-H-008-RT-01', '03-PAED-ALLN-R-060-RT-01', '03-PAEP-RDNG-R-062-RT-01', '03-PAMB-WLKS-H-052-RT-01', '03-PAMD-HRSB-R-058-RT-01', '03-PAMD-SCRN-H-006-RT-01', '03-PAMD-WLLM-R-054-RT-01', '03-PAWA-DNCN-R-066-RT-01', '03-PAWB-PTTS-H-064-RT-01', '03-PAWD-JHNS-R-050-RT-01', '03-PAWD-PTTS-H-020-RT-01', '03-PAWP-ERIE-R-046-RT-01', '03-VIXD-CHRS-R-056-RT-01', '03-VIXD-SNTT-H-038-RT-01', '04-CA04-RCHM-H-016-RT-01', '04-MDXA-SILV-R-148-RT-01', '04-MDXB-SLBR-R-160-RT-01', '04-MDXD-BLTM-H-014-RT-01', '04-MDXD-GRNB-R-032-RT-01', '04-MDXP-BLTM-R-030-RT-01', '04-MDXP-GRNB-R-100-RT-01', '04-MDXP-GRNB-R-158-RT-01', '04-NCEA-RLGH-R-132-RT-01', '04-NCEB-GRNV-R-052-RT-01', '04-NCEB-RLGH-R-048-RT-01', '04-NCED-ELZB-R-136-RT-01', '04-NCED-GRNV-R-138-RT-01', '04-NCED-RLGH-H-006-RT-01', '04-NCED-WLMN-R-050-RT-01', '04-NCEK-RLGH-R-056-RT-01', '04-NCEP-FTTV-R-038-RT-01', '04-NCEP-JKNV-R-198-RT-01', '04-NCEP-NWBR-R-140-RT-01', '04-NCES-FTTV-R-040-RT-01', '04-NCES-GRNV-R-044-RT-01', '04-NCMB-DRHM-R-157-RT-01', '04-NCMB-GRNS-H-028-RT-01', '04-NCMB-WNST-R-060-RT-01', '04-NCMD-DRHM-R-122-RT-01', '04-NCMD-GRNS-H-002-RT-01', '04-NCMD-WNST-R-058-RT-01', '04-NCMP-DRHM-R-246-RT-01', '04-NCMP-RCKN-R-088-RT-01', '04-NCMP-SLSB-R-202-RT-01', '04-NCWA-CHAR-R-190-RT-01', '04-NCWD-ASHV-R-130-RT-01', '04-NCWD-CHAR-H-066-RT-01', '04-NCWD-STTS-R-084-RT-01', '04-NCWP-CHAR-R-062-RT-01', '04-NCWP-HCKR-R-218-RT-01', '04-NCWP-STTS-R-146-RT-01', '04-SCXA-CLMB-R-116-RT-01', '04-SCXA-IRMO-R-146-RT-01', '04-SCXB-CHRL-R-242-RT-01', '04-SCXB-CLMB-H-070-RT-01', '04-SCXD-AIKN-R-232-RT-01', '04-SCXD-ANDR-R-234-RT-01', '04-SCXD-CHRL-R-068-RT-01', '04-SCXD-CLMB-H-172-RT-01', '04-SCXD-FLRN-R-124-RT-01', '04-SCXD-GRNV-R-090-RT-01', '04-SCXD-SPRT-R-118-RT-01', '04-SCXP-CLMB-H-004-RT-01', '04-SCXP-GRNV-R-092-RT-01', '04-SCXP-PTRL-R-187-RT-01', '04-SCXP-SPRT-R-197-RT-01', '04-VAEB-ALXN-R-126-RT-01', '04-VAEB-RCHM-H-182-RT-01', '04-VAED-ALXN-H-010-RT-01', '04-VAED-NRFL-R-026-RT-01', '04-VAED-NWPR-R-166-RT-01', '04-VAEP-MNSS-R-098-RT-01', '04-VAEP-NWPR-R-221-RT-01', '04-VAWA-SALM-R-148-RT-01', '04-VAWB-RONK-H-074-RT-01', '04-VAWD-ABNG-R-104-RT-01', '04-VAWD-BGST-R-238-RT-01', '04-VAWD-CHRV-R-106-RT-01', '04-VAWD-DNVL-R-108-RT-01', '04-VAWD-HRSN-R-110-RT-01', '04-VAWD-LNCH-R-114-RT-01', '04-VAWD-RONK-H-018-RT-01', '04-VAWP-ABNG-R-156-RT-01', '04-VAWP-HRSN-R-036-RT-01', '04-WVNB-CLRB-R-168-RT-01', '04-WVND-CLRB-R-076-RT-01', '04-WVND-ELKN-R-128-RT-01', '04-WVND-MRTN-R-142-RT-01', '04-WVND-WHLN-H-086-RT-01', '04-WVNP-CLRB-R-244-RT-01', '04-WVSD-BCKL-R-078-RT-01', '04-WVSD-BLFL-R-080-RT-01', '04-WVSD-CHRL-H-134-RT-01', '04-WVSD-HNTG-R-082-RT-01', '05-CA05-NWRL-H-012-RT-01', '05-LAED-NWRL-H-006-RT-01', '05-LAEP-HMMN-R-114-RT-01', '05-LAEP-HOUM-R-116-RT-01', '05-LAMB-BTNR-H-222-RT-01', '05-LAMD-BTNR-H-098-RT-01', '05-LAWB-ALXN-R-100-RT-01', '05-LAWB-LFTT-R-108-RT-01', '05-LAWD-ALXN-R-110-RT-01', '05-LAWD-FTPK-R-179-RT-01', '05-LAWD-LFTT-R-150-RT-01', '05-LAWD-LKCH-R-112-RT-01', '05-LAWD-MONR-R-124-RT-01', '05-LAWD-SHRV-H-030-RT-01', '05-MSNB-ABRD-H-044-RT-01', '05-MSND-ABRD-R-046-RT-01', '05-MSND-GRNV-R-048-RT-01', '05-MSND-OXFR-H-050-RT-01', '05-MSNP-TUPL-R-052-RT-01', '05-MSSD-GLFP-R-220-RT-01', '05-MSSD-JCKS-H-188-RT-01', '05-MSSD-NTCH-R-170-RT-01', '05-MSSP-GLFP-R-128-RT-01', '05-MSSP-HTTS-R-132-RT-01', '05-TXEB-PLAN-R-056-RT-01', '05-TXEB-TYLR-H-064-RT-01', '05-TXED-BMNT-R-058-RT-01', '05-TXED-LFKN-R-232-RT-01', '05-TXED-MRSH-R-234-RT-01', '05-TXED-PLAN-R-210-RT-01', '05-TXED-SHRM-R-136-RT-01', '05-TXED-SHRM-R-224-RT-01', '05-TXED-TXRK-R-138-RT-01', '05-TXED-TYLR-H-004-RT-01', '05-TXEP-PLAN-R-062-RT-01', '05-TXEP-TYLR-R-140-RT-01', '05-TXND-ABLN-R-014-RT-01', '05-TXND-AMRL-R-142-RT-01', '05-TXND-DLLS-H-016-RT-01', '05-TXND-FRTW-R-060-RT-01', '05-TXND-LBBC-R-152-RT-01', '05-TXND-SNNG-R-238-RT-01', '05-TXND-WHTF-R-206-RT-01', '05-TXNP-ARLN-R-144-RT-01', '05-TXSD-BRWS-R-196-RT-01', '05-TXSD-CRPS-R-162-RT-01', '05-TXSD-GLVS-R-070-RT-01', '05-TXSD-HSTN-H-002-RT-01', '05-TXSD-LARD-R-026-RT-01', '05-TXSD-MCLL-R-074-RT-01', '05-TXSD-VCTR-R-076-RT-01', '05-TXWA-SNNT-R-106-RT-01', '05-TXWB-ASTN-R-078-RT-01', '05-TXWB-MDLN-R-088-RT-01', '05-TXWB-SNNT-H-092-RT-01', '05-TXWB-WACO-R-250-RT-01', '05-TXWD-ALPN-R-130-RT-01', '05-TXWD-ASTN-R-230-RT-01', '05-TXWD-DELR-R-156-RT-01', '05-TXWD-ELPS-R-186-RT-01', '05-TXWD-FRTH-R-190-RT-01', '05-TXWD-PECS-R-176-RT-01', '05-TXWD-SNNT-H-010-RT-01', '05-TXWP-DELR-R-200-RT-01', '05-TXWP-ELPS-R-166-RT-01', '05-TXWP-ELPS-R-242-RT-01', '05-TXWP-TMPL-R-102-RT-01', '06-CA06-CNCN-H-004-RT-01', '06-KYEB-LNDN-R-138-RT-01', '06-KYEB-LXNG-H-136-RT-01', '06-KYED-ASHL-R-118-RT-01', '06-KYED-FRNK-R-142-RT-01', '06-KYED-LNDN-R-110-RT-01', '06-KYED-LXNG-H-006-RT-01', '06-KYED-PKVL-R-010-RT-01', '06-KYEP-CVNG-R-120-RT-01', '06-KYEP-PKVL-R-042-RT-01', '06-KYWD-BWLG-R-184-RT-01', '06-KYWD-LSVL-H-024-RT-01', '06-KYWD-OWEN-R-158-RT-01', '06-KYWD-PADU-R-058-RT-01', '06-KYWP-BWLG-R-188-RT-01', '06-KYWP-PADU-R-156-RT-01', '06-MIEB-BACT-R-066-RT-01', '06-MIEB-DTRT-H-068-RT-01', '06-MIEB-FLNT-R-072-RT-01', '06-MIED-ANNR-R-012-RT-01', '06-MIED-BACT-R-008-RT-01', '06-MIED-DTRT-H-160-RT-01', '06-MIED-FLNT-R-016-RT-01', '06-MIED-PRTH-R-032-RT-01', '06-MIWA-TRAV-R-022-RT-01', '06-MIWB-GRNR-H-046-RT-01', '06-MIWB-TRAV-R-014-RT-01', '06-MIWD-GRNR-H-018-RT-01', '06-MIWD-KLMZ-R-150-RT-01', '06-MIWD-LNSN-R-026-RT-01', '06-MIWD-MRQT-R-152-RT-01', '06-MIWP-MRQT-R-048-RT-01', '06-OHNA-MEDN-R-050-RT-01', '06-OHNB-CNTN-H-100-RT-01', '06-OHNB-YNGS-R-240-RT-01', '06-OHND-AKRN-R-040-RT-01', '06-OHND-CLVL-H-192-RT-01', '06-OHND-CLVL-R-078-RT-01', '06-OHND-TOLD-R-038-RT-01', '06-OHND-YNGS-R-232-RT-01', '06-OHNP-TOLD-R-014-RT-01', '06-OHSA-CLMB-R-022-RT-01', '06-OHSB-CLMB-R-084-RT-01', '06-OHSB-CNCN-R-082-RT-01', '06-OHSB-DATN-H-086-RT-01', '06-OHSD-CLMB-H-020-RT-01', '06-OHSD-DATN-R-124-RT-01', '06-TNEB-CHTT-H-088-RT-01', '06-TNED-CHTT-R-028-RT-01', '06-TNED-GRNV-R-056-RT-01', '06-TNED-KNXV-H-044-RT-01', '06-TNED-WINC-R-092-RT-01', '06-TNMB-NSHV-H-036-RT-01', '06-TNMD-NSHV-H-034-RT-01', '06-TNMP-CKVL-R-106-RT-01', '06-TNMP-CLRK-R-104-RT-01', '06-TNMP-COLM-R-096-RT-01', '06-TNWB-MMPH-H-090-RT-01', '06-TNWD-JCKN-R-132-RT-01', '06-TNWD-MMPH-H-030-RT-01', '07-CA07-CHCG-H-010-RT-01', '07-ILCD-PEOR-R-022-RT-01', '07-ILCD-RCKS-R-024-RT-01', '07-ILCD-SPRN-H-008-RT-01', '07-ILCD-URBN-R-026-RT-01', '07-ILND-RCKR-R-108-RT-01', '07-ILNP-CHCG-R-018-RT-01', '07-ILNP-LISL-R-058-RT-01', '07-ILSD-BNTN-R-030-RT-01', '07-ILSD-ESTS-H-004-RT-01', '07-INNB-STHB-H-050-RT-01', '07-INND-FRWY-R-070-RT-01', '07-INND-LFTT-R-062-RT-01', '07-INND-STHB-H-034-RT-01', '07-INNP-HMMN-R-080-RT-01', '07-INNP-MCHG-R-102-RT-01', '07-INSA-BLMN-R-102-RT-01', '07-INSD-INDN-H-016-RT-01', '07-INSP-BLMN-R-068-RT-01', '07-INSP-EVNS-R-036-RT-01', '07-INSP-INDN-R-070-RT-01', '07-INSP-NBVL-R-070-RT-01', '07-INSP-NWLB-R-038-RT-01', '07-INSP-TRRH-R-040-RT-01', '07-WIED-GRBY-R-120-RT-01', '07-WIED-MLWK-H-002-RT-01', '07-WIWB-ECLR-R-042-RT-01', '07-WIWD-MDSN-H-044-RT-01', '07-WIWP-MDSN-R-032-RT-01', '08-AREB-LTTL-H-074-RT-01', '08-ARED-BTSV-R-133-RT-01', '08-ARED-HELN-R-133-RT-01', '08-ARED-JNSB-R-062-RT-01', '08-ARED-LTTL-H-008-RT-01', '08-ARED-PNBL-R-086-RT-01', '08-ARWA-ELDR-R-092-RT-01', '08-ARWD-FRTS-H-004-RT-01', '08-ARWD-FTTV-R-060-RT-01', '08-ARWD-TXRK-R-140-RT-01', '08-ARWP-ELDR-R-066-RT-01', '08-ARWP-HTSP-R-082-RT-01', '08-CA08-SNTL-H-096-RT-01', '08-IAND-CDRR-H-160-RT-01', '08-IAND-SXCT-R-056-RT-01', '08-IASB-DSMN-H-134-RT-01', '08-IASD-CNCL-R-130-RT-01', '08-IASD-DAVN-R-028-RT-01', '08-IASD-DSMN-H-024-RT-01', '08-MNXD-DLTH-R-026-RT-01', '08-MNXD-FRGS-R-080-RT-01', '08-MNXD-MNNP-H-054-RT-01', '08-MNXD-STPL-R-112-RT-01', '08-MNXP-BMDJ-R-133-RT-01', '08-MOED-CPGR-R-030-RT-01', '08-MOED-HNBL-R-070-RT-01', '08-MOWD-JFFR-R-148-RT-01', '08-MOWD-KNSS-H-090-RT-01', '08-MOWD-SPRN-R-046-RT-01', '08-NDXB-FARG-H-050-RT-01', '08-NDXD-BSMR-H-034-RT-01', '08-NDXP-BLCR-R-232-RT-01', '08-NDXP-DVLS-R-058-RT-01', '08-NDXP-GRND-R-016-RT-01', '08-NDXP-MINT-R-020-RT-01', '08-NEXD-LNCL-R-036-RT-01', '08-NEXD-OMAH-H-124-RT-01', '08-SDXD-ABRD-R-076-RT-01', '08-SDXD-PIRR-R-048-RT-01', '08-SDXD-RPDC-R-040-RT-01', '08-SDXD-SXFL-H-002-RT-01', '08-SDXP-KYLE-R-010-RT-01', '08-SDXP-MCLN-R-242-RT-01', '08-SDXP-MSSN-R-238-RT-01', '08-SDXP-SXFL-R-052-RT-01', '08-SDXP-TMBR-R-240-RT-01', '10-CA10-DNVR-H-006-RT-01', '10-COXB-DNVR-H-024-RT-01', '10-COXD-CLRD-R-064-RT-01', '10-COXD-DNVR-H-100-RT-01', '10-COXD-DRNG-R-086-RT-01', '10-COXD-GRND-R-062-RT-01', '10-KSXA-LWRN-R-119-RT-01', '10-KSXB-WCHT-H-034-RT-01', '10-KSXD-KNSS-H-030-RT-01', '10-KSXD-TOPK-R-032-RT-01', '10-NMXA-ALBQ-R-068-RT-01', '10-NMXB-ALBQ-H-172-RT-01', '10-NMXD-ALBQ-H-008-RT-01', '10-NMXD-LCRS-R-184-RT-01', '10-NMXD-SNTF-R-178-RT-01', '10-NMXP-FRMG-R-167-RT-01', '10-NMXP-GLLP-R-166-RT-01', '10-NMXP-RSWL-R-182-RT-01', '10-OKEB-OKML-H-050-RT-01', '10-OKED-MSKG-H-002-RT-01', '10-OKEP-DRNT-R-060-RT-01', '10-OKNB-TULS-H-020-RT-01', '10-OKND-TULS-H-004-RT-01', '10-OKWD-LWTN-R-052-RT-01', '10-OKWD-OKLH-H-016-RT-01', '10-UTXA-SLTL-R-069-RT-01', '10-UTXD-SLTL-H-022-RT-01', '10-UTXD-SLTL-H-136-RT-01', '10-UTXD-SNTG-R-074-RT-01', '10-UTXP-SNTG-R-076-RT-01', '10-WYXD-CHNN-H-036-RT-01', '10-WYXD-YLLW-R-088-RT-01', '10-WYXP-CSPR-R-056-RT-01', '10-WYXP-LNDR-R-080-RT-01', '11-ALMD-DTHN-R-234-RT-01', '11-ALMD-MNTG-H-160-RT-01', '11-ALMD-OPLK-R-232-RT-01', '11-ALMP-DTHN-R-044-RT-01', '11-ALNB-ANNS-R-050-RT-01', '11-ALNB-BRMN-H-052-RT-01', '11-ALNB-DCTR-R-054-RT-01', '11-ALNB-TSCL-R-060-RT-01', '11-ALND-BRMN-H-008-RT-01', '11-ALND-FLRN-R-056-RT-01', '11-ALND-HNTS-R-058-RT-01', '11-ALNP-GDSD-R-104-RT-01', '11-ALSB-MOBL-H-152-RT-01', '11-ALSD-MOBL-H-062-RT-01', '11-ALSD-SELM-R-156-RT-01', '11-ALSP-MOBL-R-154-RT-01', '11-CA11-ATLN-H-016-RT-01', '11-FLMB-JKSV-H-164-RT-01', '11-FLMB-ORLN-R-222-RT-01', '11-FLMD-FRTM-R-102-RT-01', '11-FLMD-OCAL-R-074-RT-01', '11-FLMD-ORLN-R-124-RT-01', '11-FLMD-TAMP-H-040-RT-01', '11-FLMP-COCO-R-066-RT-01', '11-FLMP-RVRW-R-214-RT-01', '11-FLMP-SRST-R-080-RT-01', '11-FLMP-TAMP-R-038-RT-01', '11-FLMP-TAMP-R-127-RT-01', '11-FLNB-TLLH-H-188-RT-01', '11-FLND-GNSV-R-064-RT-01', '11-FLND-PNMC-R-088-RT-01', '11-FLND-PNSC-H-028-RT-01', '11-FLND-PNSC-R-170-RT-01', '11-FLND-TLLH-R-002-RT-01', '11-FLSD-FRTL-R-184-RT-01', '11-FLSD-MIAM-H-006-RT-01', '11-FLSD-WSTP-R-208-RT-01', '11-GAMA-JASP-R-035-RT-01', '11-GAMB-CLMS-R-014-RT-01', '11-GAMB-MACN-H-012-RT-01', '11-GAMD-ALBN-R-096-RT-01', '11-GAMD-MACN-H-030-RT-01', '11-GAMP-ATHN-R-128-RT-01', '11-GAMP-CLMS-R-132-RT-01', '11-GAMP-MACN-R-134-RT-01', '11-GAMP-VLDS-R-136-RT-01', '11-GAND-ATLN-H-018-RT-01', '11-GAND-GNSV-R-138-RT-01', '11-GAND-NWNN-R-142-RT-01', '11-GAND-ROME-R-144-RT-01', '11-GAND-TCKR-R-146-RT-01', '11-GASD-AGST-R-190-RT-01', '11-GASD-BRNS-R-150-RT-01', '11-GASD-SVNN-H-004-RT-01', '11-GASP-DBLN-R-094-RT-01', '11-GASP-STSB-R-108-RT-01', '11-GASP-WCRS-R-110-RT-01', '9N-AKXA-FRBN-R-162-RT-01', '9N-AKXB-ANCH-H-110-RT-01', '9N-AKXD-ANCH-H-040-RT-01', '9N-AKXD-JUNE-R-124-RT-01', '9N-AKXD-KTCH-R-126-RT-01', '9N-AKXP-FRBN-R-088-RT-01', '9N-CA9N-SNFN-H-026-RT-01', '9N-CAEB-MDST-R-078-RT-01', '9N-CAED-BKRS-R-132-RT-01', '9N-CAED-FRSN-R-138-RT-01', '9N-CAED-RDDN-R-082-RT-01', '9N-CAED-SCRM-H-192-RT-01', '9N-CAED-YSMT-R-094-RT-01', '9N-CAEP-ELKG-R-090-RT-01', '9N-CAEP-MDST-R-128-RT-01', '9N-CAEP-RSVL-R-112-RT-01', '9N-CAEP-VISL-R-238-RT-01', '9N-CANB-OKLN-R-044-RT-01', '9N-CANB-SLNS-R-170-RT-01', '9N-CANB-SNTS-R-052-RT-01', '9N-CAND-MCKY-R-060-RT-01', '9N-CAND-OKLN-R-032-RT-01', '9N-CAND-SNFN-H-038-RT-01', '9N-CAND-SNJS-R-036-RT-01', '9N-CANP-SNTS-R-054-RT-01', '9N-IDXD-BOIS-H-004-RT-01', '9N-IDXD-CRDL-R-220-RT-01', '9N-IDXD-MSCW-R-222-RT-01', '9N-IDXD-PCTL-R-056-RT-01', '9N-IDXP-TWNF-R-176-RT-01', '9N-MTXA-BLLN-R-120-RT-01', '9N-MTXB-BUTT-H-098-RT-01', '9N-MTXD-BLLN-H-034-RT-01', '9N-MTXD-GRTF-R-100-RT-01', '9N-MTXD-HELN-R-252-RT-01', '9N-MTXD-HRDN-R-146-RT-01', '9N-MTXD-MSSL-R-104-RT-01', '9N-MTXP-BRWN-R-144-RT-01', '9N-MTXP-GLSG-R-142-RT-01', '9N-ORXA-PRTL-R-116-RT-01', '9N-ORXB-PRTL-H-066-RT-01', '9N-ORXD-EUGN-R-010-RT-01', '9N-ORXD-MDFR-R-064-RT-01', '9N-ORXD-PEND-R-092-RT-01', '9N-ORXD-PRTL-H-012-RT-01', '9N-ORXP-BEND-R-058-RT-01', '9N-ORXP-SALM-R-070-RT-01', '9N-WAEB-SPKN-H-002-RT-01', '9N-WAEB-YAKM-R-188-RT-01', '9N-WAED-RCHL-R-136-RT-01', '9N-WAED-SPKN-H-006-RT-01', '9N-WAED-YAKM-R-072-RT-01', '9N-WAWA-STTL-R-180-RT-01', '9N-WAWB-VNCV-R-140-RT-01', '9N-WAWD-STTL-H-148-RT-01', '9N-WAWD-TACM-R-076-RT-01', '9N-WAWP-EVRT-R-084-RT-01', '9N-WAWP-TKWL-R-114-RT-01', '9N-WAWP-VNCV-R-230-RT-01', '9S-AZXB-PHNX-H-058-RT-01', '9S-AZXB-TCSN-R-136-RT-01', '9S-AZXD-FLGS-R-250-RT-01', '9S-AZXD-PHNX-H-138-RT-01', '9S-AZXD-PRSC-R-070-RT-01', '9S-AZXD-TCSN-R-060-RT-01', '9S-AZXD-YUMA-R-064-RT-01', '9S-CA9S-PSDN-H-036-RT-01', '9S-CACA-ELSG-R-063-RT-01', '9S-CACA-WDLD-R-114-RT-01', '9S-CACB-LSNG-H-026-RT-01', '9S-CACB-RVRS-R-038-RT-01', '9S-CACB-SNTB-R-042-RT-01', '9S-CACB-WDLD-R-044-RT-01', '9S-CACD-LSNG-H-120-RT-01', '9S-CACD-RVRS-R-080-RT-01', '9S-CACD-SNTN-R-124-RT-01', '9S-CACP-INGL-R-074-RT-01', '9S-CACP-LNCS-R-104-RT-01', '9S-CACP-LNGB-R-078-RT-01', '9S-CACP-SNBR-R-034-RT-01', '9S-CACP-SNFS-R-086-RT-01', '9S-CACP-VNTR-R-108-RT-01', '9S-CACP-WSTC-R-090-RT-01', '9S-CASA-SNDG-R-066-RT-01', '9S-CASA-SNDG-R-160-RT-01', '9S-CASB-SNDG-H-046-RT-01', '9S-CASD-SNDG-H-210-RT-01', '9S-CASP-CHLV-R-150-RT-01', '9S-CASS-ELCN-R-032-RT-01', '9S-CASS-SNDG-R-048-RT-01', '9S-GUXD-HGTN-H-052-RT-01', '9S-HIXA-HNLL-R-006-RT-01', '9S-HIXB-HNLL-H-092-RT-01', '9S-HIXD-HNLL-H-002-RT-01', '9S-HIXP-HILO-R-143-RT-01', '9S-HIXP-WAIL-R-067-RT-01', '9S-MPXD-SAIP-R-094-RT-01', '9S-NVXB-LSVG-H-096-RT-01', '9S-NVXB-RENO-R-054-RT-01', '9S-NVXD-LSVG-H-014-RT-01', '9S-NVXD-RENO-R-056-RT-01', 'AO-AZTX-PHNX-H-102-RT-01', 'AO-CFCX-WSHN-H-092-RT-01', 'AO-CFCX-WSHN-R-196-RT-01', 'AO-CITX-NWYK-H-074-RT-01', 'AO-COSC-REST-H-208-RT-01', 'AO-IMDX-WSHN-H-014-RT-01', 'AO-TTCX-SNNT-H-082-RT-01', 'AO-TTCX-SNNT-R-090-RT-01', 'DC-CADC-WSHN-H-106-RT-01', 'P-02-NYSD-WHTP-RT-01', 'PO-FLET-CHRL-R-078-RT-01'];
foreach ($sites as $site) {
//Create the Site
$newSite = \App\Models\Jfs\Site::create(['name' => $site]);
//Associate Workflows
$workflows = \App\Models\Jfs\Workflow::all();
foreach ($workflows as $workflow) {
$newSite->workflows()->attach($workflow);
}
//Associate Tasks
$tasks = \App\Models\Jfs\Task::all();
foreach ($tasks as $task) {
$newSite->tasks()->attach($task);
}
}
Model::reguard();
}
public function generateGraphData()
{
$reportData = [];
$workFlows = Workflow::all();
$totalSites = Site::all()->count();
$colors = ['red', 'orange', 'yellow', 'green', 'blue', 'purple', 'pink'];
foreach ($workFlows as $flow) {
$taskNames = $flow->tasks->lists('name')->toArray();
foreach ($taskNames as $taskName) {
$res = \DB::select('SELECT DISTINCT count(jfs_tasks.name) AS count FROM jfs_site_jfs_task INNER JOIN jfs_tasks ON jfs_site_jfs_task.jfs_task_id = jfs_tasks.id WHERE jfs_tasks.name = "' . $taskName . '" AND completed = 1 GROUP BY jfs_task_id');
if (count($res)) {
$reportData[$flow->name][$taskName]['count'] = number_format($res[0]->count / $totalSites, 3) * 100;
} else {
$reportData[$flow->name][$taskName]['count'] = 0;
}
$reportData[$flow->name][$taskName]['backgroundColor'] = RandomColor::one(['hue' => $colors[array_rand($colors, 1)]]);
$reportData[$flow->name][$taskName]['hoverBackgroundColor'] = "#00C0EF";
}
}
return $reportData;
}
