@@ -184,7 +184,7 @@ |
||
| 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 | |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | * @param dbconnection $link |
| 60 | 60 | * $link is the connection required to be closed |
| 61 | 61 | */ |
| 62 | - protected static function closeConnection($link){ |
|
| 62 | + protected static function closeConnection($link) { |
|
| 63 | 63 | $link = null; |
| 64 | 64 | } |
| 65 | 65 | |
@@ -69,14 +69,14 @@ discard block |
||
| 69 | 69 | * @param type $sql |
| 70 | 70 | * @return type |
| 71 | 71 | */ |
| 72 | - protected static function executeDBTransaction($link,$sql){ |
|
| 73 | - try{ |
|
| 72 | + protected static function executeDBTransaction($link, $sql) { |
|
| 73 | + try { |
|
| 74 | 74 | $link->beginTransaction(); |
| 75 | 75 | $link->exec($sql); |
| 76 | 76 | $link->commit(); |
| 77 | 77 | } catch (Exception $e) { |
| 78 | 78 | $link->rollBack(); |
| 79 | - die('<b>Error:</b> '.$e->getMessage()); |
|
| 79 | + die('<b>Error:</b> ' . $e->getMessage()); |
|
| 80 | 80 | } |
| 81 | 81 | return $link; |
| 82 | 82 | } |
@@ -98,10 +98,10 @@ discard block |
||
| 98 | 98 | |
| 99 | 99 | try {
|
| 100 | 100 | $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));
|
| 101 | - $sql->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobPoster',array( |
|
| 101 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPoster', array( |
|
| 102 | 102 | 'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level', |
| 103 | - 'job_max_level', 'start_date','open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city', |
|
| 104 | - 'remuneration_range_low','remuneration_range_high','impact','key_tasks','core_competencies','dev_competencies', |
|
| 103 | + 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city', |
|
| 104 | + 'remuneration_range_low', 'remuneration_range_high', 'impact', 'key_tasks', 'core_competencies', 'dev_competencies', |
|
| 105 | 105 | 'classification', 'security_clearance', 'language_requirement' |
| 106 | 106 | )); |
| 107 | 107 | $jobPosters = $sql->fetchAll(); |
@@ -200,7 +200,7 @@ discard block |
||
| 200 | 200 | $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPoster', array( |
| 201 | 201 | 'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level', |
| 202 | 202 | 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city', |
| 203 | - 'remuneration_range_low','remuneration_range_high','impact','classification','security_clearance', 'language_requirement', |
|
| 203 | + 'remuneration_range_low', 'remuneration_range_high', 'impact', 'classification', 'security_clearance', 'language_requirement', |
|
| 204 | 204 | )); |
| 205 | 205 | $jobPoster = $sql->fetch(); |
| 206 | 206 | } catch (PDOException $e) {
|
@@ -593,11 +593,11 @@ discard block |
||
| 593 | 593 | |
| 594 | 594 | try {
|
| 595 | 595 | $sql->execute() or die("ERROR: " . implode(":", $conn->errorInfo()));
|
| 596 | - $sql->setFetchMode( PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'JobPoster',array( |
|
| 596 | + $sql->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, 'JobPoster', array( |
|
| 597 | 597 | 'id', 'locale_id', 'manager_user_id', 'title', 'description', 'applicants_to_date', 'term_qty', 'term_units', 'job_min_level', |
| 598 | 598 | 'job_max_level', 'start_date', 'open_date', 'close_date', 'department', 'branch', 'division', 'location_province', 'location_city', |
| 599 | - 'remuneration_range_low','remuneration_range_high','impact','key_tasks','core_competencies','dev_competencies', |
|
| 600 | - 'classification', 'security_clearance','language_requirement' |
|
| 599 | + 'remuneration_range_low', 'remuneration_range_high', 'impact', 'key_tasks', 'core_competencies', 'dev_competencies', |
|
| 600 | + 'classification', 'security_clearance', 'language_requirement' |
|
| 601 | 601 | )); |
| 602 | 602 | $jobPosters = $sql->fetchAll(); |
| 603 | 603 | //var_dump($rows); |
@@ -125,7 +125,7 @@ |
||
| 125 | 125 | public static function getWorkplacePhotoByManagerProfileAndName($photoName, $managerProfileId) { |
| 126 | 126 | if (WorkEnvironmentDAO::workplacePhotoExistsForManagerAndName($managerProfileId, $photoName)) { |
| 127 | 127 | return WorkEnvironmentDAO::getWorkplacePhoto($managerProfileId, $photoName); |
| 128 | - } else { |
|
| 128 | + }else { |
|
| 129 | 129 | return NULL; |
| 130 | 130 | } |
| 131 | 131 | } |
@@ -21,7 +21,7 @@ |
||
| 21 | 21 | public static function getProfilePic($user_id) { |
| 22 | 22 | if (ProfilePicDAO::profilePicExistsForUser($user_id)) { |
| 23 | 23 | return ProfilePicDAO::getProfilePic($user_id); |
| 24 | - } else { |
|
| 24 | + }else { |
|
| 25 | 25 | return NULL; |
| 26 | 26 | } |
| 27 | 27 | } |
@@ -4,14 +4,14 @@ |
||
| 4 | 4 | * Summary: removes special characters for inserting tab title in Excel Spreadsheets |
| 5 | 5 | */ |
| 6 | 6 | |
| 7 | -class SpecialCharacterHandler{
|
|
| 7 | +class SpecialCharacterHandler {
|
|
| 8 | 8 | |
| 9 | 9 | /** |
| 10 | 10 | * @param string $string |
| 11 | 11 | * @return string $fixedString |
| 12 | 12 | */ |
| 13 | - public function removeSpecialCharacters($string){
|
|
| 14 | - $forbiddenCharacters = array("*","/","\\","?","[","]");
|
|
| 13 | + public function removeSpecialCharacters($string) {
|
|
| 14 | + $forbiddenCharacters = array("*", "/", "\\", "?", "[", "]");
|
|
| 15 | 15 | $fixedString = str_replace($forbiddenCharacters, "", $string); |
| 16 | 16 | return $fixedString; |
| 17 | 17 | } |