@@ -307,7 +307,7 @@ |
||
| 307 | 307 | |
| 308 | 308 | $link = BaseDAO::getConnection(); |
| 309 | 309 | |
| 310 | - //Build bulk insert sql strings for array data |
|
| 310 | + //Build bulk insert sql strings for array data |
|
| 311 | 311 | $values = []; |
| 312 | 312 | $valueStrings = []; |
| 313 | 313 | foreach($applicationQuestionAnswers as $questionAnswer) { |
@@ -6,7 +6,7 @@ discard block |
||
| 6 | 6 | ini_set("display_errors", 1); |
| 7 | 7 | set_time_limit(0); |
| 8 | 8 | |
| 9 | - if(!isset($_SESSION)){ |
|
| 9 | + if (!isset($_SESSION)) { |
|
| 10 | 10 | session_start(); |
| 11 | 11 | } |
| 12 | 12 | |
@@ -251,7 +251,7 @@ discard block |
||
| 251 | 251 | try { |
| 252 | 252 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 253 | 253 | $rowsmodified = $sql->rowCount(); |
| 254 | - if($rowsmodified > 0){ |
|
| 254 | + if ($rowsmodified > 0) { |
|
| 255 | 255 | $application_id = $link->lastInsertId(); |
| 256 | 256 | } |
| 257 | 257 | } catch (PDOException $e) { |
@@ -301,7 +301,7 @@ discard block |
||
| 301 | 301 | * @return int $rowsmodified - number of rows modified in database |
| 302 | 302 | */ |
| 303 | 303 | public static function createApplicationQuestionAnswers($applicationQuestionAnswers) { |
| 304 | - if (sizeof($applicationQuestionAnswers) === 0){ |
|
| 304 | + if (sizeof($applicationQuestionAnswers) === 0) { |
|
| 305 | 305 | return 0; |
| 306 | 306 | } |
| 307 | 307 | |
@@ -310,7 +310,7 @@ discard block |
||
| 310 | 310 | //Build bulk insert sql strings for array data |
| 311 | 311 | $values = []; |
| 312 | 312 | $valueStrings = []; |
| 313 | - foreach($applicationQuestionAnswers as $questionAnswer) { |
|
| 313 | + foreach ($applicationQuestionAnswers as $questionAnswer) { |
|
| 314 | 314 | $valueStrings[] = '(?, ?, ?)'; |
| 315 | 315 | $entryValues = [$questionAnswer->getJob_poster_application_id(), $questionAnswer->getJob_poster_question_id(), $questionAnswer->getAnswer()]; |
| 316 | 316 | $values = array_merge($values, $entryValues); |
@@ -224,7 +224,7 @@ discard block |
||
| 224 | 224 | |
| 225 | 225 | try { |
| 226 | 226 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 227 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 227 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 228 | 228 | $rows = $sql->fetchAll(); |
| 229 | 229 | } catch (PDOException $e) { |
| 230 | 230 | return 'getSkillsByLocale failed: ' . $e->getMessage(); |
@@ -250,7 +250,7 @@ discard block |
||
| 250 | 250 | |
| 251 | 251 | try { |
| 252 | 252 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 253 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 253 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 254 | 254 | $rows = $sql->fetchAll(); |
| 255 | 255 | } catch (PDOException $e) { |
| 256 | 256 | return 'getSkillLevelsByLocale failed: ' . $e->getMessage(); |
@@ -276,7 +276,7 @@ discard block |
||
| 276 | 276 | |
| 277 | 277 | try { |
| 278 | 278 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 279 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 279 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 280 | 280 | $rows = $sql->fetchAll(); |
| 281 | 281 | } catch (PDOException $e) { |
| 282 | 282 | return 'getExperienceLevelsByLocale failed: ' . $e->getMessage(); |
@@ -299,7 +299,7 @@ discard block |
||
| 299 | 299 | $sql->bindValue(':locale', $locale, PDO::PARAM_STR); |
| 300 | 300 | try { |
| 301 | 301 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 302 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 302 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 303 | 303 | $rows = $sql->fetchAll(); |
| 304 | 304 | } catch (PDOException $e) { |
| 305 | 305 | return 'getClearanceLevelsByLocale failed: ' . $e->getMessage(); |
@@ -322,7 +322,7 @@ discard block |
||
| 322 | 322 | $sql->bindValue(':locale', $locale, PDO::PARAM_STR); |
| 323 | 323 | try { |
| 324 | 324 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 325 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 325 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 326 | 326 | $rows = $sql->fetchAll(); |
| 327 | 327 | } catch (PDOException $e) { |
| 328 | 328 | return 'getLanguageLevelsByLocale failed: ' . $e->getMessage(); |
@@ -349,7 +349,7 @@ discard block |
||
| 349 | 349 | |
| 350 | 350 | try { |
| 351 | 351 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 352 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'LookupWithDescription'); |
|
| 352 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'LookupWithDescription'); |
|
| 353 | 353 | $rows = $sql->fetchAll(); |
| 354 | 354 | } catch (PDOException $e) { |
| 355 | 355 | return 'getJobSeekerProfileQuestionsByLocale failed: ' . $e->getMessage(); |
@@ -375,7 +375,7 @@ discard block |
||
| 375 | 375 | |
| 376 | 376 | try { |
| 377 | 377 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 378 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 378 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 379 | 379 | $rows = $sql->fetchAll(); |
| 380 | 380 | } catch (PDOException $e) { |
| 381 | 381 | return 'getRelationshipsByLocale failed: ' . $e->getMessage(); |
@@ -401,7 +401,7 @@ discard block |
||
| 401 | 401 | |
| 402 | 402 | try { |
| 403 | 403 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 404 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 404 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'Lookup'); |
|
| 405 | 405 | $rows = $sql->fetchAll(); |
| 406 | 406 | } catch (PDOException $e) { |
| 407 | 407 | return 'getFileTypesByLocale failed: ' . $e->getMessage(); |
@@ -32,7 +32,7 @@ |
||
| 32 | 32 | * @param ApplicationWorkSample[] $workSamples |
| 33 | 33 | */ |
| 34 | 34 | public static function getWorkSamplesForJobApplication($jobPosterApplicationId, $locale) { |
| 35 | - $link = BaseDAO::getConnection(); |
|
| 35 | + $link = BaseDAO::getConnection(); |
|
| 36 | 36 | |
| 37 | 37 | $sqlStr = " |
| 38 | 38 | SELECT |
@@ -6,7 +6,7 @@ discard block |
||
| 6 | 6 | ini_set("display_errors", 1); |
| 7 | 7 | set_time_limit(0); |
| 8 | 8 | |
| 9 | - if(!isset($_SESSION)){ |
|
| 9 | + if (!isset($_SESSION)) { |
|
| 10 | 10 | session_start(); |
| 11 | 11 | } |
| 12 | 12 | |
@@ -75,7 +75,7 @@ discard block |
||
| 75 | 75 | |
| 76 | 76 | $workSampleArrays = $sql->fetchAll(); |
| 77 | 77 | $workSamples = []; |
| 78 | - foreach($workSampleArrays as $workSampleArray) { |
|
| 78 | + foreach ($workSampleArrays as $workSampleArray) { |
|
| 79 | 79 | $basicWorkSample = new WorkSample(); |
| 80 | 80 | $basicWorkSample->setWork_sample_id($workSampleArray['work_sample_id']); |
| 81 | 81 | $basicWorkSample->setWork_sample_name($workSampleArray['work_sample_name']); |
@@ -5,7 +5,7 @@ |
||
| 5 | 5 | ini_set("display_errors", 1);
|
| 6 | 6 | set_time_limit(0); |
| 7 | 7 | |
| 8 | - if(!isset($_SESSION)){
|
|
| 8 | + if (!isset($_SESSION)) {
|
|
| 9 | 9 | session_start(); |
| 10 | 10 | } |
| 11 | 11 | |
@@ -426,7 +426,7 @@ |
||
| 426 | 426 | $sql->bindValue(":manager_profile_id", $managerProfileId, PDO::PARAM_INT); |
| 427 | 427 | $sql->bindValue(":work_environment_id", $workEnvironmentId, PDO::PARAM_INT); |
| 428 | 428 | |
| 429 | - try { |
|
| 429 | + try { |
|
| 430 | 430 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 431 | 431 | $rowsModified = $sql->rowCount(); |
| 432 | 432 | } catch (PDOException $e) { |
@@ -5,7 +5,7 @@ discard block |
||
| 5 | 5 | ini_set("display_errors", 1); |
| 6 | 6 | set_time_limit(0); |
| 7 | 7 | |
| 8 | - if(!isset($_SESSION)){ |
|
| 8 | + if (!isset($_SESSION)) { |
|
| 9 | 9 | session_start(); |
| 10 | 10 | } |
| 11 | 11 | |
@@ -109,7 +109,7 @@ discard block |
||
| 109 | 109 | try { |
| 110 | 110 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 111 | 111 | $rowsmodified = $sql->rowCount(); |
| 112 | - if($rowsmodified > 0){ |
|
| 112 | + if ($rowsmodified > 0) { |
|
| 113 | 113 | $insert_id = $link->lastInsertId(); |
| 114 | 114 | } |
| 115 | 115 | } catch (PDOException $e) { |
@@ -229,7 +229,7 @@ discard block |
||
| 229 | 229 | |
| 230 | 230 | try { |
| 231 | 231 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 232 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'BasicWorkEnvironment'); |
|
| 232 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'BasicWorkEnvironment'); |
|
| 233 | 233 | $workEnvironment = $sql->fetch(); |
| 234 | 234 | } catch (PDOException $e) { |
| 235 | 235 | return 'getBasicWorkEnvironment failed: ' . $e->getMessage(); |
@@ -249,7 +249,7 @@ discard block |
||
| 249 | 249 | |
| 250 | 250 | try { |
| 251 | 251 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 252 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'WorkplacePhotoCaption'); |
|
| 252 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'WorkplacePhotoCaption'); |
|
| 253 | 253 | $photoCaptions = $sql->fetchAll(); |
| 254 | 254 | |
| 255 | 255 | } catch (PDOException $e) { |
@@ -275,7 +275,7 @@ discard block |
||
| 275 | 275 | try { |
| 276 | 276 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 277 | 277 | $rowsmodified = $sql->rowCount(); |
| 278 | - if($rowsmodified > 0){ |
|
| 278 | + if ($rowsmodified > 0) { |
|
| 279 | 279 | $insert_id = $link->lastInsertId(); |
| 280 | 280 | } |
| 281 | 281 | } catch (PDOException $e) { |
@@ -314,7 +314,7 @@ discard block |
||
| 314 | 314 | |
| 315 | 315 | try { |
| 316 | 316 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 317 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'File'); |
|
| 317 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'File'); |
|
| 318 | 318 | $photo = $sql->fetch(); |
| 319 | 319 | } catch (PDOException $e) { |
| 320 | 320 | return 'getWorkplacePhoto failed: ' . $e->getMessage(); |
@@ -353,7 +353,7 @@ discard block |
||
| 353 | 353 | return $found == 1; |
| 354 | 354 | } |
| 355 | 355 | |
| 356 | - public static function updateWorkplacePhoto($image, $managerProfileId, $photoName){ |
|
| 356 | + public static function updateWorkplacePhoto($image, $managerProfileId, $photoName) { |
|
| 357 | 357 | $link = BaseDAO::getConnection(); |
| 358 | 358 | $sql_str = " |
| 359 | 359 | UPDATE talentcloud.workplace_photo photo, talentcloud.manager_profile_to_work_environment env, talentcloud.workplace_photo_caption cap |
@@ -401,7 +401,7 @@ discard block |
||
| 401 | 401 | |
| 402 | 402 | try { |
| 403 | 403 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 404 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'WorkplacePhotoCaption'); |
|
| 404 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'WorkplacePhotoCaption'); |
|
| 405 | 405 | $photoCaption = $sql->fetch(); |
| 406 | 406 | |
| 407 | 407 | } catch (PDOException $e) { |
@@ -6,7 +6,7 @@ discard block |
||
| 6 | 6 | ini_set("display_errors", 1); |
| 7 | 7 | set_time_limit(0); |
| 8 | 8 | |
| 9 | - if(!isset($_SESSION)){ |
|
| 9 | + if (!isset($_SESSION)) { |
|
| 10 | 10 | session_start(); |
| 11 | 11 | } |
| 12 | 12 | |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | */ |
| 25 | 25 | class DashboardDAO extends BaseDAO { |
| 26 | 26 | |
| 27 | - public static function getDashboardByUserId($user_id, $locale_iso){ |
|
| 27 | + public static function getDashboardByUserId($user_id, $locale_iso) { |
|
| 28 | 28 | |
| 29 | 29 | $link = BaseDAO::getConnection(); |
| 30 | 30 | |
@@ -179,11 +179,11 @@ |
||
| 179 | 179 | } |
| 180 | 180 | |
| 181 | 181 | /** |
| 182 | - * |
|
| 183 | - * @param ManagerProfile $managerProfile |
|
| 184 | - * @param ManagerProfileDetails $managerProfileDetails |
|
| 185 | - * @return int $profileId |
|
| 186 | - */ |
|
| 182 | + * |
|
| 183 | + * @param ManagerProfile $managerProfile |
|
| 184 | + * @param ManagerProfileDetails $managerProfileDetails |
|
| 185 | + * @return int $profileId |
|
| 186 | + */ |
|
| 187 | 187 | public static function updateManagerProfile(ManagerProfile $managerProfile, ManagerProfileDetailsNonLocalized $managerProfileDetails){ |
| 188 | 188 | |
| 189 | 189 | //var_dump($managerProfile->getUser_manager_profile_id()); |
@@ -11,22 +11,22 @@ discard block |
||
| 11 | 11 | ini_set("display_errors", 1); |
| 12 | 12 | set_time_limit(0); |
| 13 | 13 | |
| 14 | -if(!isset($_SESSION)){ |
|
| 14 | +if (!isset($_SESSION)) { |
|
| 15 | 15 | session_start(); |
| 16 | 16 | } |
| 17 | 17 | |
| 18 | 18 | /*set api path*/ |
| 19 | -if(!defined('ROOT_PATH')){ |
|
| 19 | +if (!defined('ROOT_PATH')) { |
|
| 20 | 20 | define('ROOT_PATH', dirname(__DIR__) . '/'); |
| 21 | 21 | } |
| 22 | 22 | |
| 23 | 23 | /** Model Classes */ |
| 24 | -require_once ROOT_PATH.'dao/BaseDAO.php'; |
|
| 25 | -require_once ROOT_PATH.'model/ManagerProfile.php'; |
|
| 26 | -require_once ROOT_PATH.'model/ManagerProfileDetails.php'; |
|
| 27 | -require_once ROOT_PATH.'model/ManagerProfileDetailsNonLocalized.php'; |
|
| 24 | +require_once ROOT_PATH . 'dao/BaseDAO.php'; |
|
| 25 | +require_once ROOT_PATH . 'model/ManagerProfile.php'; |
|
| 26 | +require_once ROOT_PATH . 'model/ManagerProfileDetails.php'; |
|
| 27 | +require_once ROOT_PATH . 'model/ManagerProfileDetailsNonLocalized.php'; |
|
| 28 | 28 | |
| 29 | -class ManagerProfileDAO extends BaseDAO{ |
|
| 29 | +class ManagerProfileDAO extends BaseDAO { |
|
| 30 | 30 | |
| 31 | 31 | /** |
| 32 | 32 | * |
@@ -34,7 +34,7 @@ discard block |
||
| 34 | 34 | * @param ManagerProfileDetails $managerProfileDetails |
| 35 | 35 | * @return int $profileId |
| 36 | 36 | */ |
| 37 | - public static function createManagerProfile(ManagerProfile $managerProfile, ManagerProfileDetailsNonLocalized $managerProfileDetails){ |
|
| 37 | + public static function createManagerProfile(ManagerProfile $managerProfile, ManagerProfileDetailsNonLocalized $managerProfileDetails) { |
|
| 38 | 38 | |
| 39 | 39 | $link = BaseDAO::getConnection(); |
| 40 | 40 | |
@@ -43,7 +43,7 @@ discard block |
||
| 43 | 43 | $user_manager_profile_linkedin = $managerProfile->getUser_manager_profile_linkedin(); |
| 44 | 44 | $user_id = $managerProfile->getUser_id(); |
| 45 | 45 | |
| 46 | - $sqlStr="INSERT INTO talentcloud.user_manager_profile |
|
| 46 | + $sqlStr = "INSERT INTO talentcloud.user_manager_profile |
|
| 47 | 47 | ( |
| 48 | 48 | user_manager_profile_department_id, |
| 49 | 49 | user_manager_profile_twitter, |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | |
| 95 | 95 | $sqlSelect = "SELECT LAST_INSERT_ID() INTO @user_manager_profile_id;"; |
| 96 | 96 | |
| 97 | - $sql2Str="INSERT INTO talentcloud.user_manager_profile_details |
|
| 97 | + $sql2Str = "INSERT INTO talentcloud.user_manager_profile_details |
|
| 98 | 98 | ( |
| 99 | 99 | locale_id, |
| 100 | 100 | user_manager_profile_details_aboutme, |
@@ -184,7 +184,7 @@ discard block |
||
| 184 | 184 | * @param ManagerProfileDetails $managerProfileDetails |
| 185 | 185 | * @return int $profileId |
| 186 | 186 | */ |
| 187 | - public static function updateManagerProfile(ManagerProfile $managerProfile, ManagerProfileDetailsNonLocalized $managerProfileDetails){ |
|
| 187 | + public static function updateManagerProfile(ManagerProfile $managerProfile, ManagerProfileDetailsNonLocalized $managerProfileDetails) { |
|
| 188 | 188 | |
| 189 | 189 | //var_dump($managerProfile->getUser_manager_profile_id()); |
| 190 | 190 | |
@@ -195,7 +195,7 @@ discard block |
||
| 195 | 195 | $user_manager_profile_linkedin = $managerProfile->getUser_manager_profile_linkedin(); |
| 196 | 196 | $user_id = intval($managerProfile->getUser_id()); |
| 197 | 197 | |
| 198 | - $sqlStr="UPDATE talentcloud.user_manager_profile |
|
| 198 | + $sqlStr = "UPDATE talentcloud.user_manager_profile |
|
| 199 | 199 | SET |
| 200 | 200 | user_manager_profile_department_id = :user_manager_profile_department_id, |
| 201 | 201 | user_manager_profile_twitter = :user_manager_profile_twitter, |
@@ -239,7 +239,7 @@ discard block |
||
| 239 | 239 | $user_manager_profile_education = $managerProfileDetails->getUser_manager_profile_education(); |
| 240 | 240 | $user_manager_profile_education_fr = $managerProfileDetails->getUser_manager_profile_education_fr(); |
| 241 | 241 | |
| 242 | - $sql2Str="UPDATE |
|
| 242 | + $sql2Str = "UPDATE |
|
| 243 | 243 | user_manager_profile up, |
| 244 | 244 | user_manager_profile_details upd_en, |
| 245 | 245 | user_manager_profile_details upd_fr, |
@@ -332,7 +332,7 @@ discard block |
||
| 332 | 332 | $sql2->execute() or die("ERROR: " . implode(":", $conn->errorInfo())); |
| 333 | 333 | $link->commit(); |
| 334 | 334 | $rowsmodified = $sql->rowCount(); |
| 335 | - if($rowsmodified > 0){ |
|
| 335 | + if ($rowsmodified > 0) { |
|
| 336 | 336 | $success = true; |
| 337 | 337 | } |
| 338 | 338 | } catch (PDOException $e) { |
@@ -343,7 +343,7 @@ discard block |
||
| 343 | 343 | |
| 344 | 344 | } |
| 345 | 345 | |
| 346 | - public static function getManagerProfileByUser($userId){ |
|
| 346 | + public static function getManagerProfileByUser($userId) { |
|
| 347 | 347 | |
| 348 | 348 | $link = BaseDAO::getConnection(); |
| 349 | 349 | |
@@ -363,7 +363,7 @@ discard block |
||
| 363 | 363 | |
| 364 | 364 | try { |
| 365 | 365 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 366 | - $sql->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'ManagerProfile'); |
|
| 366 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'ManagerProfile'); |
|
| 367 | 367 | $managerProfile = $sql->fetch(); |
| 368 | 368 | |
| 369 | 369 | /* |
@@ -382,7 +382,7 @@ discard block |
||
| 382 | 382 | |
| 383 | 383 | } |
| 384 | 384 | |
| 385 | - public static function getManagerProfileDetailsByLocale(ManagerProfile $managerProfile, $locale){ |
|
| 385 | + public static function getManagerProfileDetailsByLocale(ManagerProfile $managerProfile, $locale) { |
|
| 386 | 386 | |
| 387 | 387 | $link = BaseDAO::getConnection(); |
| 388 | 388 | |
@@ -422,8 +422,8 @@ discard block |
||
| 422 | 422 | |
| 423 | 423 | try { |
| 424 | 424 | $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo())); |
| 425 | - $sql->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'ManagerProfileDetails',array( |
|
| 426 | - 'user_manager_profile_id', 'locale_id', 'user_manager_profile_details_aboutme', 'user_manager_profile_details_proud', 'user_manager_profile_details_branch', 'user_manager_profile_details_division', 'user_manager_profile_details_position', 'user_manager_profile_details_lead_style', 'user_manager_profile_details_emp_learn', 'user_manager_profile_details_expectations', 'user_manager_profile_details_id', 'user_manager_profile_review_options','user_manager_profile_staylate', 'user_manager_profile_engage', 'user_manager_profile_devops', 'user_manager_profile_lvwRequests', 'user_manager_profile_work_experience', 'user_manager_profile_education' |
|
| 425 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'ManagerProfileDetails', array( |
|
| 426 | + 'user_manager_profile_id', 'locale_id', 'user_manager_profile_details_aboutme', 'user_manager_profile_details_proud', 'user_manager_profile_details_branch', 'user_manager_profile_details_division', 'user_manager_profile_details_position', 'user_manager_profile_details_lead_style', 'user_manager_profile_details_emp_learn', 'user_manager_profile_details_expectations', 'user_manager_profile_details_id', 'user_manager_profile_review_options', 'user_manager_profile_staylate', 'user_manager_profile_engage', 'user_manager_profile_devops', 'user_manager_profile_lvwRequests', 'user_manager_profile_work_experience', 'user_manager_profile_education' |
|
| 427 | 427 | )); |
| 428 | 428 | $managerProfileDetails = $sql->fetch(); |
| 429 | 429 | |
@@ -61,11 +61,11 @@ discard block |
||
| 61 | 61 | |
| 62 | 62 | $sqlDetails->bindValue(':narrative_text_en', $teamCulture->getNarrative_text_en(), PDO::PARAM_STR); |
| 63 | 63 | $sqlDetails->bindValue(':narrative_text_fr', $teamCulture->getNarrative_text_fr(), PDO::PARAM_STR); |
| 64 | - $sqlDetails->bindValue(':operating_context_en', $teamCulture->getOperating_context_en(), PDO::PARAM_STR); |
|
| 64 | + $sqlDetails->bindValue(':operating_context_en', $teamCulture->getOperating_context_en(), PDO::PARAM_STR); |
|
| 65 | 65 | $sqlDetails->bindValue(':operating_context_fr', $teamCulture->getOperating_context_fr(), PDO::PARAM_STR); |
| 66 | - $sqlDetails->bindValue(':what_we_value_en', $teamCulture->getWhat_we_value_en(), PDO::PARAM_STR); |
|
| 66 | + $sqlDetails->bindValue(':what_we_value_en', $teamCulture->getWhat_we_value_en(), PDO::PARAM_STR); |
|
| 67 | 67 | $sqlDetails->bindValue(':what_we_value_fr', $teamCulture->getWhat_we_value_fr(), PDO::PARAM_STR); |
| 68 | - $sqlDetails->bindValue(':how_we_work_en', $teamCulture->getHow_we_work_en(), PDO::PARAM_STR); |
|
| 68 | + $sqlDetails->bindValue(':how_we_work_en', $teamCulture->getHow_we_work_en(), PDO::PARAM_STR); |
|
| 69 | 69 | $sqlDetails->bindValue(':how_we_work_fr', $teamCulture->getHow_we_work_fr(), PDO::PARAM_STR); |
| 70 | 70 | $sqlDetails->bindValue(':en_iso', "en_CA", PDO::PARAM_STR); |
| 71 | 71 | $sqlDetails->bindValue(':fr_iso', "fr_CA", PDO::PARAM_STR); |
@@ -131,12 +131,12 @@ discard block |
||
| 131 | 131 | $sql->bindValue(':gc_directory_url', $teamCulture->getGc_directory_url(), PDO::PARAM_STR); |
| 132 | 132 | $sql->bindValue(':narrative_text_en', $teamCulture->getNarrative_text_en(), PDO::PARAM_STR); |
| 133 | 133 | $sql->bindValue(':narrative_text_fr', $teamCulture->getNarrative_text_fr(), PDO::PARAM_STR); |
| 134 | - $sql->bindValue(':operating_context_en', $teamCulture->getOperating_context_en(), PDO::PARAM_STR); |
|
| 135 | - $sql->bindValue(':operating_context_fr', $teamCulture->getOperating_context_fr(), PDO::PARAM_STR); |
|
| 136 | - $sql->bindValue(':what_we_value_en', $teamCulture->getWhat_we_value_en(), PDO::PARAM_STR); |
|
| 137 | - $sql->bindValue(':what_we_value_fr', $teamCulture->getWhat_we_value_fr(), PDO::PARAM_STR); |
|
| 138 | - $sql->bindValue(':how_we_work_en', $teamCulture->getHow_we_work_en(), PDO::PARAM_STR); |
|
| 139 | - $sql->bindValue(':how_we_work_fr', $teamCulture->getHow_we_work_fr(), PDO::PARAM_STR); |
|
| 134 | + $sql->bindValue(':operating_context_en', $teamCulture->getOperating_context_en(), PDO::PARAM_STR); |
|
| 135 | + $sql->bindValue(':operating_context_fr', $teamCulture->getOperating_context_fr(), PDO::PARAM_STR); |
|
| 136 | + $sql->bindValue(':what_we_value_en', $teamCulture->getWhat_we_value_en(), PDO::PARAM_STR); |
|
| 137 | + $sql->bindValue(':what_we_value_fr', $teamCulture->getWhat_we_value_fr(), PDO::PARAM_STR); |
|
| 138 | + $sql->bindValue(':how_we_work_en', $teamCulture->getHow_we_work_en(), PDO::PARAM_STR); |
|
| 139 | + $sql->bindValue(':how_we_work_fr', $teamCulture->getHow_we_work_fr(), PDO::PARAM_STR); |
|
| 140 | 140 | $sql->bindValue(':manager_profile_id', $managerProfileId, PDO::PARAM_INT); |
| 141 | 141 | $sql->bindValue(':en_iso', "en_CA", PDO::PARAM_STR); |
| 142 | 142 | $sql->bindValue(':fr_iso', "fr_CA", PDO::PARAM_STR); |
@@ -272,7 +272,7 @@ discard block |
||
| 272 | 272 | $sql->bindValue(":manager_profile_id", $managerProfileId, PDO::PARAM_INT); |
| 273 | 273 | $sql->bindValue(":team_culture_id", $teamCultureId, PDO::PARAM_INT); |
| 274 | 274 | |
| 275 | - try { |
|
| 275 | + try { |
|
| 276 | 276 | $sql->execute() or die("ERROR: " . implode(":", $link->errorInfo())); |
| 277 | 277 | $rowsModified = $sql->rowCount(); |
| 278 | 278 | } catch (PDOException $e) { |
@@ -6,7 +6,7 @@ |
||
| 6 | 6 | ini_set("display_errors", 1); |
| 7 | 7 | set_time_limit(0); |
| 8 | 8 | |
| 9 | - if(!isset($_SESSION)){ |
|
| 9 | + if (!isset($_SESSION)) { |
|
| 10 | 10 | session_start(); |
| 11 | 11 | } |
| 12 | 12 | |
@@ -30,7 +30,7 @@ |
||
| 30 | 30 | * @param type $jobPosterApplicationId |
| 31 | 31 | */ |
| 32 | 32 | public static function getSkillDeclarationsForJobApplication($jobPosterApplicationId) { |
| 33 | - $link = BaseDAO::getConnection(); |
|
| 33 | + $link = BaseDAO::getConnection(); |
|
| 34 | 34 | |
| 35 | 35 | $sqlStr = " |
| 36 | 36 | SELECT |
@@ -6,7 +6,7 @@ |
||
| 6 | 6 | ini_set("display_errors", 1); |
| 7 | 7 | set_time_limit(0); |
| 8 | 8 | |
| 9 | - if(!isset($_SESSION)){ |
|
| 9 | + if (!isset($_SESSION)) { |
|
| 10 | 10 | session_start(); |
| 11 | 11 | } |
| 12 | 12 | |