GCTC-NTGC / TalentCloud

public_html/tc/utils/Utils.php

Spacing +1 added lines, -1 removed lines

@@ -85,7 +85,7 @@
      * 

      */

     public static function base64url_decode($data) {

-        return base64_decode(str_pad(strtr($data, '-_', '+/'), strlen($data) % 4, '=', STR_PAD_RIGHT));

+        return base64_decode(str_pad(strtr($data, '-_', '+/'), strlen($data)%4, '=', STR_PAD_RIGHT));

     }

 

 }

public_html/tc/utils/JWTUtils.php

Indentation +2 added lines, -2 removed lines

@@ -189,7 +189,7 @@ 
         
     }
     
-     public static function getOpenIdUserFromJWT($jwt) { 
+        public static function getOpenIdUserFromJWT($jwt) { 
         if (self::validateJWT($jwt, null)) { 
             $openId = self::getPayloadFromToken($jwt);
             if ($openId['sub']) {
@@ -199,7 +199,7 @@ 
             }    
         } 
         return null; 
-     }
+        }
     
     public static function isExpired($exp){
         return false;

Spacing +22 added lines, -22 removed lines

@@ -10,10 +10,10 @@ 
 $path = dirname(getcwd());
 
 //var_dump(ROOT);
-require_once $path.'/config/auth.config.inc';
-require_once $path.'/model/User.php';
-require_once $path.'/controller/UserController.php';
-require_once $path.'/utils/Utils.php';
+require_once $path . '/config/auth.config.inc';
+require_once $path . '/model/User.php';
+require_once $path . '/controller/UserController.php';
+require_once $path . '/utils/Utils.php';
 
 /**
  * Description of JWTUtils
@@ -27,7 +27,7 @@ 
      * @param User $user
      * @return type
      */
-    public static function generateJWT(User $user){
+    public static function generateJWT(User $user) {
         $key = SECRET;
         //var_dump($key);
         $header = JWTUtils::setHeader();
@@ -41,7 +41,7 @@ 
      * 
      * @return type
      */
-    public static function setHeader(){
+    public static function setHeader() {
         
         $header_content = array("alg"=>"HS256", "typ"=>"JWT");
         
@@ -55,10 +55,10 @@ 
      * 
      * @param type $token
      */
-    public static function getPayloadFromToken($jwt){
+    public static function getPayloadFromToken($jwt) {
         
         $jwt_elements = explode('.', $jwt);
-        $payload = json_decode(Utils::base64url_decode($jwt_elements[1]),TRUE);
+        $payload = json_decode(Utils::base64url_decode($jwt_elements[1]), TRUE);
         //var_dump($payload);
         return $payload;
     }
@@ -68,15 +68,15 @@ 
      * @param User $user
      * @return type
      */
-    public static function setPayload(User $user){
+    public static function setPayload(User $user) {
         
         $user_id = $user->getUser_id();
 
         $iat = time();
         
-        $expiryTime = time()+60*60*24; //expires in one day
+        $expiryTime = time() + 60*60*24; //expires in one day
         
-        $payload_content = array("iat"=>$iat,"iss"=>"https://talentcloud.localhost","exp"=>$expiryTime,"user_id"=>$user_id);
+        $payload_content = array("iat"=>$iat, "iss"=>"https://talentcloud.localhost", "exp"=>$expiryTime, "user_id"=>$user_id);
         
         $payload = Utils::base64url_encode(json_encode($payload_content));
 
@@ -91,9 +91,9 @@ 
      * @param type $key
      * @return type
      */
-    public static function setSignature($header, $payload, $key){
+    public static function setSignature($header, $payload, $key) {
         
-        $unsignedToken = $header.'.'.$payload;
+        $unsignedToken = $header . '.' . $payload;
         
         $encoded_key = Utils::base64url_encode($key);
         
@@ -112,9 +112,9 @@ 
      * @param type $signature
      * @return string
      */
-    public static function setToken($header,$payload,$signature){
+    public static function setToken($header, $payload, $signature) {
         
-        $token = $header.'.'.$payload.'.'.$signature;
+        $token = $header . '.' . $payload . '.' . $signature;
         
         return $token;
         
@@ -125,7 +125,7 @@ 
      * @param type $headers
      * @return type
      */
-    public static function getTokenFromHeader($headers){
+    public static function getTokenFromHeader($headers) {
         $token = null;
         if (!empty($headers)) {
             if (preg_match('/Bearer\s(\S+)/', $headers['Authorization'], $token)) {
@@ -140,7 +140,7 @@ 
      * @param type $headers
      * @return type
      */
-    public static function getTokenFromRequest($authHeader){
+    public static function getTokenFromRequest($authHeader) {
         $token = null;
         if (!empty($authHeader)) {
             if (preg_match('/Bearer\s(\S+)/', $authHeader, $token)) {
@@ -155,7 +155,7 @@ 
      * @param type $jwt
      * @return boolean
      */
-    public static function validateJWT($jwt, $user){
+    public static function validateJWT($jwt, $user) {
         $isValid = true;
         
         // Split jwt string by '.' 
@@ -178,8 +178,8 @@ 
         $recieved_signature = Utils::base64url_decode($jwt_elements[2]);
         
         // checking if the generated signature is equal to the received signature
-        if($isValid){
-            if(hash_equals($evalSignature, $recieved_signature)) {
+        if ($isValid) {
+            if (hash_equals($evalSignature, $recieved_signature)) {
                 // If everything worked fine, if the signature is ok and the payload was not modified you should get a success message and the ecryption hashes match
                 $isValid = true;   
             }
@@ -201,11 +201,11 @@ 
         return null; 
      }
     
-    public static function isExpired($exp){
+    public static function isExpired($exp) {
         return false;
     }
     
-    public static function issuedBy($iss){
+    public static function issuedBy($iss) {
         return true;
     }
     

public_html/tc/dao/MicroReferenceDAO.php

Indentation +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
      * @param ApplicationMicroReference[] $references
      */
     public static function getApplicationMicroReferencesForJobApplication($jobPosterApplicationId, $locale) {
-         $link = BaseDAO::getConnection();
+            $link = BaseDAO::getConnection();
         
         $sqlStr = "
             SELECT 

Spacing +2 added lines, -2 removed lines

@@ -6,7 +6,7 @@ 
     ini_set("display_errors", 1);
     set_time_limit(0);
 
-    if(!isset($_SESSION)){
+    if (!isset($_SESSION)) {
         session_start();
     }
 
@@ -80,7 +80,7 @@ 
             
             $referenceArrays = $sql->fetchAll();
             $references = [];
-            foreach($referenceArrays as $referenceArray) {
+            foreach ($referenceArrays as $referenceArray) {
                 $basicReference = new MicroReference();
                 $basicReference->setMicro_reference_id($referenceArray['micro_reference_id']);
                 $basicReference->setMicro_reference_name($referenceArray['micro_reference_name']);

public_html/tc/dao/LocaleDAO.php

Spacing +1 added lines, -1 removed lines

@@ -6,7 +6,7 @@
 ini_set("display_errors", 1);
 set_time_limit(0);
 
-if(!isset($_SESSION)){
+if (!isset($_SESSION)) {
     session_start();
 }
 

public_html/tc/dao/JobPosterDAO.php

Indentation +5 added lines, -5 removed lines

@@ -99,11 +99,11 @@ 
         try {

             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));

             $sql->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobPoster',array(

-				'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level',

+                'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level',

                 'job_max_level', 'start_date','open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

                 'remuneration_range_low','remuneration_range_high','impact','key_tasks','core_competencies','dev_competencies',

                 'classification', 'security_clearance', 'language_requirement'

-			));

+            ));

             $jobPosters = $sql->fetchAll();

             //var_dump($rows);

         } catch (PDOException $e) {

@@ -201,7 +201,7 @@ 
                 'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level',

                 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

                 'remuneration_range_low','remuneration_range_high','impact','classification','security_clearance', 'language_requirement',

-			));

+            ));

             $jobPoster = $sql->fetch();

         } catch (PDOException $e) {

             BaseDAO::closeConnection($link);

@@ -500,7 +500,7 @@ 
             $sqlAssetType->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

             

             if (sizeof($key_task_data) > 0)

-                 $sql4->execute($key_task_data) or die("ERROR: " . implode(":", $link->errorInfo()));

+                    $sql4->execute($key_task_data) or die("ERROR: " . implode(":", $link->errorInfo()));

             if (sizeof($core_competency_data) > 0)

                 $sql5->execute($core_competency_data) or die("ERROR: " . implode(":", $link->errorInfo()));

             if (sizeof($dev_competency_data) > 0)

@@ -594,7 +594,7 @@ 
                 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

                 'remuneration_range_low','remuneration_range_high','impact','key_tasks','core_competencies','dev_competencies',

                 'classification', 'security_clearance','language_requirement'

-			));

+            ));

             $jobPosters = $sql->fetchAll();

             //var_dump($rows);

         } catch (PDOException $e) {

Spacing +22 added lines, -22 removed lines

@@ -6,7 +6,7 @@ 
     ini_set("display_errors", 1);

     set_time_limit(0);

 

-    if(!isset($_SESSION)){

+    if (!isset($_SESSION)) {

         session_start();

     }

 

@@ -98,10 +98,10 @@ 
 

         try {

             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));

-            $sql->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobPoster',array(

+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPoster', array(

 				'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level',

-                'job_max_level', 'start_date','open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

-                'remuneration_range_low','remuneration_range_high','impact','key_tasks','core_competencies','dev_competencies',

+                'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

+                'remuneration_range_low', 'remuneration_range_high', 'impact', 'key_tasks', 'core_competencies', 'dev_competencies',

                 'classification', 'security_clearance', 'language_requirement'

 			));

             $jobPosters = $sql->fetchAll();

@@ -200,7 +200,7 @@ 
             $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPoster', array(

                 'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level',

                 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

-                'remuneration_range_low','remuneration_range_high','impact','classification','security_clearance', 'language_requirement',

+                'remuneration_range_low', 'remuneration_range_high', 'impact', 'classification', 'security_clearance', 'language_requirement',

 			));

             $jobPoster = $sql->fetch();

         } catch (PDOException $e) {

@@ -284,9 +284,9 @@ 
             $sqlQuestions->execute($input_fields) or die("ERROR: " . implode(":", $conn->errorInfo()));

 

             $sqlTasks->setFetchMode(PDO::FETCH_NUM);

-            $sqlCoreComps->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup');

-            $sqlDevelopingComps->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup');

-            $sqlQuestions->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobPosterQuestion');

+            $sqlCoreComps->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup');

+            $sqlDevelopingComps->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup');

+            $sqlQuestions->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPosterQuestion');

 

             //fetch array items

             $tasks = $sqlTasks->fetchAll();

@@ -314,7 +314,7 @@ 
      *      specifies department, province, etc, by id instead of by name

      * @return int job_post_id: id of the newly created job post

      */

-    public static function createJobPoster($jobPosterNonLocalized){

+    public static function createJobPoster($jobPosterNonLocalized) {

         $link = BaseDAO::getConnection();

         $sqlStr1 = "

             INSERT INTO job_poster

@@ -373,11 +373,11 @@ 
         //Build bulk insert sql strings for array data

         $key_task_data = [];

         $key_task_values = [];

-        foreach($jobPosterNonLocalized->getKey_tasks_en() as $task) {

+        foreach ($jobPosterNonLocalized->getKey_tasks_en() as $task) {

             $key_task_values[] = '(@job_post_id, 1, ?)';

             $key_task_data[] = $task;

         }

-        foreach($jobPosterNonLocalized->getKey_tasks_fr() as $task) {

+        foreach ($jobPosterNonLocalized->getKey_tasks_fr() as $task) {

             $key_task_values[] = '(@job_post_id, 2, ?)';

             $key_task_data[] = $task;

         }

@@ -389,11 +389,11 @@ 
         $sqlStr_EssentialType = '(SELECT ct.criteria_type_id INTO @essential_type FROM criteria_type ct WHERE ct.criteria_type = "essential")';

         $core_competency_data = [];

         $core_competency_values = [];

-        foreach($jobPosterNonLocalized->getCore_competencies_en() as $core_competency) {

+        foreach ($jobPosterNonLocalized->getCore_competencies_en() as $core_competency) {

             $core_competency_values[] = '(@job_post_id, 1, @essential_type, ?)';

             $core_competency_data[] = $core_competency;

         }

-        foreach($jobPosterNonLocalized->getCore_competencies_fr() as $core_competency) {

+        foreach ($jobPosterNonLocalized->getCore_competencies_fr() as $core_competency) {

             $core_competency_values[] = '(@job_post_id, 2, @essential_type, ?)';

             $core_competency_data[] = $core_competency;

         }

@@ -405,11 +405,11 @@ 
         

         $dev_competency_data = [];

         $dev_competency_values = [];

-        foreach($jobPosterNonLocalized->getDeveloping_competencies_en() as $dev_competency) {

+        foreach ($jobPosterNonLocalized->getDeveloping_competencies_en() as $dev_competency) {

             $dev_competency_values[] = '(@job_post_id, 1, @asset_type, ?)';

             $dev_competency_data[] = $dev_competency;

         }

-        foreach($jobPosterNonLocalized->getDeveloping_competencies_fr() as $dev_competency) {

+        foreach ($jobPosterNonLocalized->getDeveloping_competencies_fr() as $dev_competency) {

             $dev_competency_values[] = '(@job_post_id, 2,  @asset_type, ?)';

             $dev_competency_data[] = $dev_competency;

         }

@@ -419,12 +419,12 @@ 
 

         $question_data = [];

         $question_values = [];

-        foreach($jobPosterNonLocalized->getQuestions_en() as $question) {

+        foreach ($jobPosterNonLocalized->getQuestions_en() as $question) {

             $question_values[] = '(@job_post_id, 1, ?, ?)';

             $question_data[] = $question->getQuestion();

             $question_data[] = $question->getDescription();

         }

-        foreach($jobPosterNonLocalized->getQuestions_fr() as $question) {

+        foreach ($jobPosterNonLocalized->getQuestions_fr() as $question) {

             $question_values[] = '(@job_post_id, 2, ?, ?)';

             $question_data[] = $question->getQuestion();

             $question_data[] = $question->getDescription();

@@ -506,7 +506,7 @@ 
             if (sizeof($dev_competency_data) > 0)

                 $sql6->execute($dev_competency_data) or die("ERROR: " . implode(":", $link->errorInfo()));

             if (sizeof($question_data) > 0)

-                $sqlQuestions->execute ($question_data) or die("ERROR: " . implode(":", $link->errorInfo()));

+                $sqlQuestions->execute($question_data) or die("ERROR: " . implode(":", $link->errorInfo()));

 

             $link->commit();

         } catch (PDOException $e) {

@@ -523,7 +523,7 @@ 
      * @param type $locale

      * @return type

      */

-    public static function getJobPostersByManagerId($locale,$managerId) {

+    public static function getJobPostersByManagerId($locale, $managerId) {

 

         $link = BaseDAO::getConnection();

         $sqlStr = "

@@ -589,11 +589,11 @@ 
 

         try {

             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));

-            $sql->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobPoster',array(

+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPoster', array(

                 'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level',

                 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city',

-                'remuneration_range_low','remuneration_range_high','impact','key_tasks','core_competencies','dev_competencies',

-                'classification', 'security_clearance','language_requirement'

+                'remuneration_range_low', 'remuneration_range_high', 'impact', 'key_tasks', 'core_competencies', 'dev_competencies',

+                'classification', 'security_clearance', 'language_requirement'

 			));

             $jobPosters = $sql->fetchAll();

             //var_dump($rows);

Braces +24 added lines, -16 removed lines

@@ -446,14 +446,18 @@ 
         $sqlEssentialType = $link->prepare($sqlStr_EssentialType);

         $sqlAssetType = $link->prepare($sqlStr_AssetType);

         

-        if (sizeof($key_task_data) > 0)

-            $sql4 = $link->prepare($sqlStr4);

-        if (sizeof($core_competency_data) > 0)

-            $sql5 = $link->prepare($sqlStr5);

-        if (sizeof($dev_competency_data) > 0)

-            $sql6 = $link->prepare($sqlStr6);

-        if (sizeof($question_data) > 0)

-            $sqlQuestions = $link->prepare($sqlQuestionsStr);

+        if (sizeof($key_task_data) > 0) {
+                    $sql4 = $link->prepare($sqlStr4);
+        }
+        if (sizeof($core_competency_data) > 0) {
+                    $sql5 = $link->prepare($sqlStr5);
+        }
+        if (sizeof($dev_competency_data) > 0) {
+                    $sql6 = $link->prepare($sqlStr6);
+        }
+        if (sizeof($question_data) > 0) {
+                    $sqlQuestions = $link->prepare($sqlQuestionsStr);
+        }
 

 

         $sql1->bindValue(':term_units_id', $jobPosterNonLocalized->getTerm_units_id(), PDO::PARAM_INT);

@@ -499,14 +503,18 @@ 
             $sqlEssentialType->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

             $sqlAssetType->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

             

-            if (sizeof($key_task_data) > 0)

-                 $sql4->execute($key_task_data) or die("ERROR: " . implode(":", $link->errorInfo()));

-            if (sizeof($core_competency_data) > 0)

-                $sql5->execute($core_competency_data) or die("ERROR: " . implode(":", $link->errorInfo()));

-            if (sizeof($dev_competency_data) > 0)

-                $sql6->execute($dev_competency_data) or die("ERROR: " . implode(":", $link->errorInfo()));

-            if (sizeof($question_data) > 0)

-                $sqlQuestions->execute ($question_data) or die("ERROR: " . implode(":", $link->errorInfo()));

+            if (sizeof($key_task_data) > 0) {
+                             $sql4->execute($key_task_data) or die("ERROR: " . implode(":", $link->errorInfo()));
+            }
+            if (sizeof($core_competency_data) > 0) {
+                            $sql5->execute($core_competency_data) or die("ERROR: " . implode(":", $link->errorInfo()));
+            }
+            if (sizeof($dev_competency_data) > 0) {
+                            $sql6->execute($dev_competency_data) or die("ERROR: " . implode(":", $link->errorInfo()));
+            }
+            if (sizeof($question_data) > 0) {
+                            $sqlQuestions->execute ($question_data) or die("ERROR: " . implode(":", $link->errorInfo()));
+            }
 

             $link->commit();

         } catch (PDOException $e) {

public_html/tc/dao/ProfilePicDAO.php

Spacing +2 added lines, -2 removed lines

@@ -6,7 +6,7 @@ 
     ini_set("display_errors", 1);
     set_time_limit(0);
 
-    if(!isset($_SESSION)){
+    if (!isset($_SESSION)) {
         session_start();
     }
 
@@ -72,7 +72,7 @@ 
 
         try {
             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));
-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'ProfilePic',array('user_id','image','last_updated', 'type', 'size'));
+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'ProfilePic', array('user_id', 'image', 'last_updated', 'type', 'size'));
             $profile_pic = $sql->fetch();
         } catch (PDOException $e) {
             return 'getProfilePic failed: ' . $e->getMessage();

public_html/tc/dao/AuthenticationDAO.php

Indentation +8 added lines, -8 removed lines

@@ -23,13 +23,13 @@ 
  */

 class AuthenticationDAO extends BaseDAO {

 

-	/**

-         * 

-         * @param type $email_address

-         * @param type $password

-         * @return type

-         */

-	public static function authenticateUser($email_address, $password) {

+    /**

+     * 

+     * @param type $email_address

+     * @param type $password

+     * @return type

+     */

+    public static function authenticateUser($email_address, $password) {

 

             $md5_password = md5($password);

             

@@ -56,7 +56,7 @@ 
             }

             BaseDAO::closeConnection($link);

             return $row;

-	}

+    }

         

         public static function storeAuthToken($token, User $authUser){

             

Spacing +5 added lines, -5 removed lines

@@ -5,7 +5,7 @@ 
 ini_set("display_errors", 1);

 set_time_limit(0);

 

-if(!isset($_SESSION)){

+if (!isset($_SESSION)) {

     session_start();

 }

 

@@ -58,7 +58,7 @@ 
             return $row;

 	}

         

-        public static function storeAuthToken($token, User $authUser){

+        public static function storeAuthToken($token, User $authUser) {

             

             $user_id = intval($authUser->getUser_id());

             $access_token = $token['access_token'];

@@ -96,7 +96,7 @@ 
             try {

                 $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

                 $count = $sql->rowCount();

-                if($count > 0){

+                if ($count > 0) {

                     $id = $link->lastInsertId();

                 }

             } catch (PDOException $e) {

@@ -109,7 +109,7 @@ 
         }

         

         

-        public static function getAuthTokenByUserId(User $authUser){

+        public static function getAuthTokenByUserId(User $authUser) {

             

             $user_id = intval($authUser->getUser_id());

             

@@ -125,7 +125,7 @@ 
             try {

                 $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

                 $count = $sql->rowCount();

-                if($count > 0){

+                if ($count > 0) {

                     $id = $link->lastInsertId();

                 }

             } catch (PDOException $e) {

public_html/tc/dao/UserDAO.php

Spacing +11 added lines, -11 removed lines

@@ -6,7 +6,7 @@ 
 ini_set("display_errors", 1);
 set_time_limit(0);
 
-if(!isset($_SESSION)){
+if (!isset($_SESSION)) {
     session_start();
 }
 
@@ -16,7 +16,7 @@ 
 require_once '../dao/BaseDAO.php';
 require_once '../model/User.php';
 
-class UserDAO extends BaseDAO{
+class UserDAO extends BaseDAO {
     
     /**
      * 
@@ -24,7 +24,7 @@ 
      * @param type $password
      * @return type
      */
-    public static function getUserByCredentials($email_address, $password){
+    public static function getUserByCredentials($email_address, $password) {
         
         /*
          * SELECT u.firstname, u.lastname, ur.user_role  FROM tc.user u, tc.user_role ur
@@ -51,7 +51,7 @@ 
 
         try {
             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));
-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'User', array('user_id', 'email', 'firstname', 'lastname', 'is_confirmed', 'user_role'));
+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'User', array('user_id', 'email', 'firstname', 'lastname', 'is_confirmed', 'user_role'));
             $row = $sql->fetch();
             //var_dump($row);
         } catch (PDOException $e) {
@@ -76,7 +76,7 @@ 
         $row = null;
         try {
             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));
-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'User');
+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'User');
             $row = $sql->fetch();
             //var_dump($row);
         } catch (PDOException $e) {
@@ -101,7 +101,7 @@ 
         $row = null;
         try {
             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));
-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'User');
+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'User');
             $row = $sql->fetch();
             //var_dump($row);
         } catch (PDOException $e) {
@@ -131,7 +131,7 @@ 
 
         try {
             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));
-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'User');
+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'User');
             $user = $sql->fetch();
             //var_dump($row);
         } catch (PDOException $e) {
@@ -161,7 +161,7 @@ 
 
         try {
             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));
-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'User');
+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'User');
             $user = $sql->fetch();
         } catch (PDOException $e) {
             return 'getUserByJobSeekerProfileId failed: ' . $e->getMessage();
@@ -170,7 +170,7 @@ 
         return $user;
     }
     
-    public static function registerUser(User $user){
+    public static function registerUser(User $user) {
         
             $email = $user->getEmail();
             $name = $user->getName();
@@ -208,7 +208,7 @@ 
             try {
                 $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));
                 $count = $sql->rowCount();
-                if($count > 0){
+                if ($count > 0) {
                     $user_id = $link->lastInsertId();
                 }
                 $user->setUser_id($user_id);
@@ -274,7 +274,7 @@ 
         return $count > 0;
     }
     
-    public static function validateEmail($emailAddress){
+    public static function validateEmail($emailAddress) {
 
         /*
          * SELECT user_id FROM tc.user WHERE email = '';

public_html/tc/dao/JobSeekerDAO.php

Spacing +8 added lines, -8 removed lines

@@ -6,7 +6,7 @@ 
     ini_set("display_errors", 1);

     set_time_limit(0);

 

-    if(!isset($_SESSION)){

+    if (!isset($_SESSION)) {

         session_start();

     }

 

@@ -48,7 +48,7 @@ 
 

         try {

             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));

-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobSeekerProfile');

+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobSeekerProfile');

             $profile = $sql->fetch();

             //var_dump($rows);

         } catch (PDOException $e) {

@@ -88,7 +88,7 @@ 
 

         try {

             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));

-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobSeekerProfile');

+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobSeekerProfile');

             $rows = $sql->fetch();

             //var_dump($rows);

         } catch (PDOException $e) {

@@ -118,7 +118,7 @@ 
 

         try {

             $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));

-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobSeekerProfileAnswer');

+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobSeekerProfileAnswer');

             $rows = $sql->fetchAll();

             //var_dump($rows);

         } catch (PDOException $e) {

@@ -134,7 +134,7 @@ 
      * @param int $user_id

      * @return int job_seeker_profile_id

      */

-    public static function addJobSeekerProfile($jobSeekerProfile,$user_id){

+    public static function addJobSeekerProfile($jobSeekerProfile, $user_id) {

         

         $user_id_int = intval($user_id);

         $jobSeekerProfile_link = $jobSeekerProfile->getJob_seeker_profile_link();

@@ -175,7 +175,7 @@ 
             ";

         $answer_value_strings = [];

         $answer_data = [];

-        foreach($jobSeekerProfile->getJob_seeker_profile_answers() as $answer) {

+        foreach ($jobSeekerProfile->getJob_seeker_profile_answers() as $answer) {

             $answer_value_strings[] = '(@job_seeker_profile_id, ?, ?)';

             $answer_data[] = $answer->getJob_seeker_profile_question_id();

             $answer_data[] = $answer->getAnswer();

@@ -202,7 +202,7 @@ 
             $link->beginTransaction();

             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

             $job_seeker_profile_id = $link->lastInsertId();

-            $sql_id->execute()or die("ERROR: " . implode(":", $link->errorInfo()));

+            $sql_id->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

             $sql_user2profile->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

             if (sizeof($answer_data) > 0) {

                 $sql_answers->execute($answer_data) or die("ERROR: " . implode(":", $link->errorInfo()));

@@ -258,7 +258,7 @@ 
 

         try {

             $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo()));

-            $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobSeekerProfile');

+            $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobSeekerProfile');

             $rows = $sql->fetchAll();

         } catch (PDOException $e) {

             return 'getJobSeekers failed: ' . $e->getMessage();