@@ -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(); |
@@ -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 |
@@ -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 |
@@ -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 |
@@ -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 |
@@ -5,7 +5,7 @@ |
||
5 | 5 | * To change this template file, choose Tools | Templates |
6 | 6 | * and open the template in the editor. |
7 | 7 | */ |
8 | -class AuthToken{ |
|
8 | +class AuthToken { |
|
9 | 9 | |
10 | 10 | private $access_token; |
11 | 11 | private $expires_in; |
@@ -7,7 +7,7 @@ discard block |
||
7 | 7 | require_once '../model/ApplicationMicroReference.php'; |
8 | 8 | require_once '../model/ApplicationWorkSample.php'; |
9 | 9 | |
10 | -class FullJobApplication implements JsonSerializable{ |
|
10 | +class FullJobApplication implements JsonSerializable { |
|
11 | 11 | |
12 | 12 | private $job_poster_application; |
13 | 13 | private $job_seeker_profile; |
@@ -43,7 +43,7 @@ discard block |
||
43 | 43 | $getter_names = get_class_methods(get_class($this)); |
44 | 44 | $gettable_attributes = array(); |
45 | 45 | foreach ($getter_names as $key => $value) { |
46 | - if(substr($value, 0, 3) === 'get') { |
|
46 | + if (substr($value, 0, 3) === 'get') { |
|
47 | 47 | $gettable_attributes[strtolower(substr($value, 3, strlen($value)))] = $this->$value(); |
48 | 48 | } |
49 | 49 | } |