@@ -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 |