РRؔQҢML3";5UVL@}̼/bF5KgΙU@D#pV+!֡.,9^@YW1y8?ݛLqNT8YsXdbo_U~<E.2ˋد !vh3:f-DRZ#wvuGz&dݏ$ }y/RO~(RWX[$3$cp*dV޶5?o5#Jpt.\|@z'X ˢұj J0w ZpBtSslK+;|&[k,f.²~wNkE B)s Q'=A+@…Gl6$rj}ѱA!}Qs DVb3.޲O!R{U@X'YnJsA30w jv zOﰯtY;2ּBiQO/@J;|Oq։kgo{$/{H՜[w *jYmHP 'Y4pWcg HUd=5 =nWTvٲ,۽9&2&C#Ao.#x2++ک}!/h4L)s}t2U1.)i'.8ij 0:_`ePyVR:_T?AJ렬0uG &r7t#qu{}K {@[▜~s+`e]k!*?1}1U${\ 7q6;'W;02DMp`P&PˆT轓Y܋v8rMiLOP汌+0",F^OhruV#&I*b52BG=., M̿pU14X'KeFN'hlpP1P*(n 2@2! x)92w^D"F4{YPвkVy'3oSw.rs.]5]M6-A_yf#䵻12Ӊ]U+l[5Á>& 7D ?&f`~ p1jKWz1cCnaA o+RͤH2FPޯvZ?4AmW>~ yywP<++T($f3Ȃ5sƽ/eY#:ZB,z|&b躗 r\&IH3>yֱ^ݧu=Tyx0/5ָUj&tUESj2g : !m<g3Q%3DZw¨A. bNI@Pn?I`Y|T |TH)iq?WߐE6ɗ=4a?Gm'֙H̱da&}SixwOobJ*;|p.˖^gwbP&V|aݭ~2xf&y.˕tsZB I gG0=Y6 *3 rh^ybǓurUf#Rx9*`ứ4y%sCsWdZD^'EM.0uh9vQ0ޢ, R$?h>uʎF$VTW1LurMT~V7 m}q!Kt98KڠQp)xdmdz6'5AIjEe%Ez c K(5b۔~: iŎJ~#[8_]<8fRwH%nqӊ]TuV%)H'č(EYkp*5_"usVRPPgCN Ρ5R5Gg3IaWxq_\rK#M"_n|ˆȮy:GzbVNb3aUJl 0SStk3N" 8 VNfe+\%JGE@x,G'q;jp:jstZI&ЄxB5|@6Jy0ڊMj540SBSu%`*A*Y"mImʫ8E%)h[,ْz >h~>XWΨ{ RHu`ØھDžSI7T/ڼ7ejy wE} c+܀Ov=Ԑ9<"cK O{h~YW2*v!78(nq%V:Sˤ)b 7޷F>%k)o{%2:M B>Ɗf[ŸsὌ$bTLS>-2C145c2a|+Z_N:fCz fBZwTz[)(|*b!9!@Ccbѡ!:c(RTԢk鮍|.XEC6G߂´T%Ǧy ;&:5._%+5PYj/|gx 7mWo`LlrK6U럭ϰJOI%7qo]X?ieaqVq`籪e݄ѵr.j_M9&\GP ~;]Wji39|UW M;~ j><g!@{XU4*+ƽ[.]:*]^%s穅ǀH^2}ۀ0iL_ę8YT@XX?D2AkЏd$Ҹ0p53Qͳ7Q14][xkOJ`] l¨(+7!`u+mYS鈾#0;Uk~֗&w>$kbnX^%>@ﯦ+WhGB+| "|ft{5ʠ  #%QU*麙Ak|Nީ,c,=%0*dž\(">[g&[i<4V9ug0]\˞5sl:ɂʏ&D&.|l-AV}$&oeVndF6yd<<Lo7f0- 骔J {)OpRun'^Rf|+]"FX&wl2iݞs)FwDx&e)$qvtIV(773qUuw,.JKos)H?L ܭKPV9:鏍>v t(ԩj/(fG{PVm7J< &b>ey5€Yo=M車++յ^,| i~s Ovv4nN0/E(\2SSy܄m6-f_@yz8=#w2VgkN.Q {6.Nfi.O% A8?g;cUЭO/\0Ec5mdQ#9QAmQW.pR\d[ ͅ0\pr0Ku0j'm 9I:}9vkOX^LI碫67fHY%3M޿uIUi;܆XS( RnHHnw 4M2017Ej21@6E}pK:\NQT7=2cjSDjj%NfqSHlݠ'WPC%ڠd9ad7LN9;dxLYxûK?P.0ड़lBE1*n!i,ll~}nĮ8;t%-O ø sQP[GKO#nn3G/3YAm3ܵH0k G}NJ Y[V']ؖ8l`4HHBGWة^'!I_ 1s*Bfe;D]zѺK/ 4dF6t*wȚl3hI²6x1}Ö.*GV^u m(3\яVW)7lV 㧢qm1|x Ȏd5ZiujADa(g˪-(b}npZ炃ʖA`EC:ĉG涰x3'Ut[/ n,F=Vl{Fyy[2+.'çڏ3Ps sпOJICtb*ah7Nۊ)E/DΑ*vSj76J[Ml;n6?,W Uz }ecEvx즡zF!$g7Cs|C1Ju %0CwՑ5<sK SYT?J^:^l@"w@^NKePcyf 4, 5_|˵xIŇ0#|싏Rjgkjw`r/G #x>C1oHX4+V˧đ{6^nRtMt=x `WȂ j;MLZeI#h۟W.n`Mھy@VDa|R02l0QEaNvG^:}ݭ\2i⾩X>N Lp2rD"WJRfsO%DxNeU7Md~٬LNX®V*c1 54o%$yrWB_Ah`dt. 8ZV⾏ZY}7?7߼D!Y;o{ %}Akgœy4r;^`;=ifi ?mfxى0=xo=h~\<8vشC>K޼楯Z,A64 <*/u`PW^ZҝP"pYBžEp<(v}L߾sz%ijg@h2Fs?j>Th{&^&~r=g<"p)`,HS@)\Mbf+:P/́a]($C,B~γMw=UɾwhrZ권[ěu-#^)+s~Qw|!61}Ώ3ST$Fj+FBHt![:!OzcۚW[ %b)kJXtZ9 =|hiwzI 97>-hPq8ܨa\rн1NZ\RTۜoU] w,fYy?se羰ֈRV$Z)!Y{@fr\H7b{ANLAkþ3͐+zn&jDJ;ĒGC*@r3 _f^bj*(3MR;1kjCd.ͷo^]M w 4.j[~^le󯩄2ĵopKisoGrSWiB(sṋَ8ԃrW9":k2GAckV[*x\m^x^aZK/@W_1bXsT/ t-wfCoh۬qfc5e"( `α+ '-]J{rKH6|"M)kPp smzϲ#$d;,,D UP1e 0DT_#H }{^i>@+V5(lƉxC٧L0ISIW!e5jkY>gYU76AaI4Y- nTX+I>ѧpoSd96~}t2|k1uI࿖.ksB-F@rDyɺТ1|X%:ү=CC6*.`΢j\~sA 뱸-_iDF.&6%|nXC-L4=+P! b(mdZx.ux ʰmeR7za v%op ̟]f:c҃S_T:ȫ&RDVyۉԧ~ &/~g{F1S_\ޑc&ZVA4\ݾfbzM  e"sqX0wLu: knye1c'BTbqŕԙ5mXR \V4`137mcBSL`- nS%_~-&";&~gazXڅC+*lś5"Ei{A\МŌW9gBvL 7]]r~@m ȵوhYc c Z{v—AX%_RxV#Nj rf]>L~DqDl$CsSQPkJߣgdS.ٸ` Nh8g *L,N 2md5GunJo@(c']=y [lD]w~TL8g8ٴ9ͻ @-&$ƪ6lMWf 05LepHqtM;qd͗ͬR]i,ZOL070U Ρa'\'dqs!ۇYOhrqQk6NxpV3mT$ѷ? a~__bm5 9Nf3bfbh|U=RK HkW V",; nc7Ħ +ƵF0I1맬ӷbe2' ?m%ZLYJw3n@PGt5PyH&{5,]NM~ɵfi-}@1cl͟UpY/1A-a38qnlOLy\(\iɶ`Vګ_REnsure entities have been loaded $output->writeln(" [-] Comparing the $db_name database schema with the current mapping metadata."); try { // Get the current database migration version $currentMigrationVersion = $this->getLatestMigrationVersion(new BufferedOutput()); // Version migrations $process = new Process('bin/console doctrine:migrations:version --add --all --no-interaction'); $process->setWorkingDirectory($this->projectDirectory); $process->run(); // Compare the current database migration version against database and create a new migration version accordingly. $process = new Process('bin/console doctrine:migrations:diff --quiet'); $process->setWorkingDirectory($this->projectDirectory); $process->mustRun(); $process = new Process('bin/console doctrine:migrations:status --quiet'); $process->setWorkingDirectory($this->projectDirectory); $process->run(); // Get the latest database migration version $latestMigrationVersion = $this->getLatestMigrationVersion(new BufferedOutput()); if ($currentMigrationVersion != $latestMigrationVersion) { $output->writeln(" [!] The current database schema is not up-to-date with the current mapping metadata."); $interactiveQuestion = new Question("\n Update your database schema to the current mapping metadata? [Y/N] ", 'Y'); if ('Y' === strtoupper($this->questionHelper->ask($input, $output, $interactiveQuestion))) { $output->writeln([ "", " Please wait while your database is being migrated from version $currentMigrationVersion to $latestMigrationVersion.", " This could take up to a few minutes.\n", ]); try { // Migrate database to latest schematic version $process = new Process('bin/console doctrine:migrations:migrate --no-interaction --quiet'); $process->setTimeout(900); $process->setWorkingDirectory($this->projectDirectory); $process->mustRun(); // Load database fixtures to populate initial dataset $process = new Process('bin/console doctrine:fixtures:load --append'); $process->setTimeout(120); $process->setWorkingDirectory($this->projectDirectory); $process->mustRun(); $output->writeln(" [v] Database successfully migrated to the latest migration version $latestMigrationVersion to $latestMigrationVersion.\n"); } catch (\Exception $e) { $output->writeln([ "\n [x] Unable to successfully migrate to latest database schematic version.", "\n Exiting evaluation process.\n" ]); return 1; } } else { $output->writeln([ "\n [x] There are entities that have not been updated to the $databaseName database yet.", "\n Exiting evaluation process.\n" ]); return 1; } } else { $output->writeln([ "\n [x] Unable to correctly determine database schema version.", "\n Exiting evaluation process.\n" ]); return 1; } } catch (\Exception $e) { // Database is up-to-date. Do nothing. $output->writeln(" [v] The current database schema is up-to-date with the current mapping metdata.\n"); } // Check 3: Check if super admin account exists $output->writeln(" [-] Checking if an active super admin account exists"); $database = new \PDO("mysql:host=$db_host:$db_port;dbname=$db_name", $db_user, $db_password); $supportRoleQuery = $database->query("SELECT * FROM uv_support_role WHERE code = 'ROLE_SUPER_ADMIN'"); $supportRole = $supportRoleQuery->fetch(\PDO::FETCH_ASSOC); $userInstanceQuery = $database->query("SELECT * FROM uv_user_instance WHERE supportRole_id = " . $supportRole['id']); $userInstance = $userInstanceQuery->fetch(\PDO::FETCH_ASSOC); if (empty($userInstance)) { $output->writeln(" [!] No active user account found with super admin privileges."); $interactiveQuestion = new Question("\n Create a new user account with super admin privileges? [Y/N] ", 'Y'); if ('Y' === strtoupper($this->questionHelper->ask($input, $output, $interactiveQuestion))) { $output->write(["\033[1A", "\033[K", "\033[1A", "\033[K"]); $output->writeln("\n Please enter the following details:\n"); $warningFlag = false; do { $u_email = $this->askInteractiveQuestion("Email: ", null, 6, false, false, "Please enter a valid email address"); $u_email = filter_var($u_email, FILTER_SANITIZE_EMAIL); if ($warningFlag) { $output->write([self::MCA, self::CLL]); } if (false == filter_var($u_email, FILTER_VALIDATE_EMAIL)) { $output->writeln(" Warning: $u_email is not a valid email address"); $warningFlag = true; } } while (false == filter_var($u_email, FILTER_VALIDATE_EMAIL)); $u_name = $this->askInteractiveQuestion("Name: ", null, 6, false, false, "Please enter your name"); $warningFlag = false; do { $u_password = $this->askInteractiveQuestion("Password: ", null, 6, false, true, "Please enter your password"); $u_cpassword = $this->askInteractiveQuestion("Confirm Password: ", null, 6, false, true, "Please enter your password"); if ($warningFlag) { $output->write([self::MCA, self::CLL]); } if ($u_password != $u_cpassword) { $output->writeln(" Warning: Passwords do not match"); $warningFlag = true; } } while ($u_password != $u_cpassword); $output->write([self::MCA, self::CLL, self::MCA, self::CLL, self::MCA, self::CLL]); try { $process = new Process(sprintf("bin/console %s %s '%s' %s %s --no-interaction", 'uvdesk_wizard:defaults:create-user', 'ROLE_SUPER_ADMIN', trim($u_name), $u_email, $u_password )); $process->setWorkingDirectory($this->projectDirectory); $process->mustRun(); $output->writeln(" [v] User account created successfully.\n"); } catch (ProcessFailedException $e) { // Do nothing ... $output->writeln([ " [x] An unexpected error occurred while creating the user account.\n", "\n Exiting evaluation process.\n" ]); return 1; } } else { $output->writeln("\n [!] Skipping creatK|>Ne&7+;S51"A_fB~aP{|\7=kR*Hnۚi$cXbΨOEX vnžp0gl1;mkjEC.|Nk09$TeOң﹞] 쨅$jpT"@T>: R;_t&ˎ̻L)ZTFͫf K^ĶzL_w5=&A#-_lq *'m_Z 6qPҥkKݿKۆk#~x ^/eoSqN=B. ϡ;|):0mD-1 R*"^4Xl)A= 9CK%Wu!(˒QܹT7։3ϻbcb[B&ug?0YӭfPUE10 ϘD9fE|w@)NY_:}܄tz}*(6cCɸ; w.rjt#\v$$ QMxS=s!ď(#A3.7't;z5D.Yv #۴lުgUytͤ((3 lq%f1)HNd_*> $ MFM*ۢx"Hfj>څ5,/JBŒovi̔{cpsOmSYa;~ʫ@?D >\Mueܤ%" kpVo%E_;h^F9Q7eY/ٰ)UQOƤNޛ콝ۖ{zKֻYld*)XH7u!OiҨ19aC<9qb`iXNjRt K_!}O )a^E$ /wPvٔۊ7%Uz%>Kt7Z< ]6!2z)Pl \@JiG?j j)^0[|OST3WdJb-6}δO>{*r{ /= :wY}Cui<&S}`%IbV. *7k3d@T)7 j%K|r̾2gTTDU2V=}\we@@)췀9)iw*G<aODG#!7*f>/]#oqpA=  iMbqlwav2W%~r~7&z^H 7%ɛpViQ.^-uPҡ F0d!Z'[49/p6u(U}Dw: 's_KfLJf(5>٬>;l.Vnig ;@Lx>n!1:* %fZ('eU'UM>١tv~%w/|[FGHؐUzsuDy<86DCOG=ftLgӋ(ܜzlݗ|q#3by@+Q\ uq8cYP"71U>]TӰnV.Y~SqlP S+[g f/iSǶHgDp ts'oփݤv$YV,˜Wۜo-& 6@ .L!k2bFoE-zp3eFV(ԧ2E+N|'~_~Jׅxwۑr|\(,XT+FdUwaIqmTi H H8ڹtt.$x"fkx0<R8ksSqA>h**;+[~h39!w̻ɦxɊXBL_ &MD DQȹn`7@(0^`]*^NIkfîa$V$*NzGwIyǖ>'GfU^\ l\kG}(ŐΜ[F-}!&gHÁpMi*~-=:LG "E4@ [x؇@ˋ?f91dCL>hwԝ.!ՋC(>GB.4_nfU,˗5k:.W7^\4\GLy0v-\ ̍4Q) hn6}4Hc UHh咩Kk1wIHjv b ; hYKhO)Wb1@UB-CV#@a~BĬ* WD N4.;X9N/Uq'mtD{CI4fcAP^Kʙwd5 'B57y*ʏs7={,.l RVY?WC=,HMu><\ඊS:HJ9=K+ecG- p\g5r)iz>)grbAk0Pv(ޚ8 ϳQPm#'I)_K,ZέeDly' WH~YL^Q-0\[0Cdxq+)}\ ɂuaG4Zf P OQ0%8E\)^i~>5݃QwRT{N6[';* C2N_NˣE&%&=8N 懾-L*Ωk8&:i4ݤ쫰Gev㼹֥j6` cQs_!݇͗|S/IFV6ANHD>np4N|ޘG* A]Ck)Y̲4y"Jh.tZU?=Lo3?OX>Efm? ŮKI V {:vQ:@h3\Ri^병e H=>ޫC ͰmmB'Q%:?)" E'Y4zC`[GKSN'&a@1eZBqJom(W*dtiLOEh kx:JSF#㈭oG c"L$@)i8 ϧ|+CWa~opś7m )X&a7 p&S'>8SەC} c :/@mv{;K"))yd6pcUe*:b9`I+XyFۀ eQ;Lf&lPKjsccŹd:?wK~E/yT"i8f鷶)$hia|jPl۝Ё|QvYLp Fߒ(MkP$fJDIkf {-ulh@1"[ϱBi}461-?=]>bOW̓E4$TRW2gxp3symԯ&4xx¡(U\&8)E3455>YCqXO`rǯElinS4b{SŢK0%ˠ)A|:[ȠQ fp߃7$~Ǻ <[<9bT!H -%tMRt &Kݯ@Ҵwա0+^cLڢYv6-*v9yѲ#pB8NPe#õLWF`..)\8s 3U_:% ;qythOrPekX^}3A*C@x]W~ͳ>KQ}tK%Dm^as.<Z?$K .#>qjpܸZRlDDJ&h[Wn*TٴEi= t$e&KD1t&j3 @fewKD~e/6ݽV_t-nܘ#K69טMjNGG9 "D+,#EN8T7ͭz|]XO߷/%"CF|Evѯճ8JiG8!Gl0чI˞HewHn,8Zv6 Ggv:<mL8e(>nTu W^dXK]ˬ1xb&,j>o#Lܞh??iAxfwӘk?VC62^;yˁOxD? ‚mSwbbZʍU)67\xA9E6L.P^nSjj䙛^hhPWOWy)+~Y _ a|;ę ۳~jCz|.9Ber,?Ɓbv\^BvmTԔ-43vahöd:0.6J 8G$qw;\\P@],m(KS58v8b~gnмmID3=CMaS뻦K Hrsvɪ@[\H>tj;(bWOBՈ&W1ii{a2tNŽ&6NiuH#bb^ d7ﾄNRH.SqvDαg;1YDӕzaCP÷NLX_'x8wЅjE 洄)/A{y*'ZO yaV̼P4`vBV?f7UjB7A=ehD;w tTPdEaC8v@Oe>3. 5uwE?ӀE,J[Jص*y4"?=J^}S s1_Qcn @S MSr"_,(2 VuJx &ΙWEB() ԪS+`