@@ -23,13 +23,13 @@ discard block |
||
| 23 | 23 | */ |
| 24 | 24 | class AuthenticationDAO extends BaseDAO {
|
| 25 | 25 | |
| 26 | - /** |
|
| 27 | - * |
|
| 28 | - * @param type $email_address |
|
| 29 | - * @param type $password |
|
| 30 | - * @return type |
|
| 31 | - */ |
|
| 32 | - public static function authenticateUser($email_address, $password) {
|
|
| 26 | + /** |
|
| 27 | + * |
|
| 28 | + * @param type $email_address |
|
| 29 | + * @param type $password |
|
| 30 | + * @return type |
|
| 31 | + */ |
|
| 32 | + public static function authenticateUser($email_address, $password) {
|
|
| 33 | 33 | |
| 34 | 34 | $md5_password = md5($password); |
| 35 | 35 | |
@@ -56,7 +56,7 @@ discard block |
||
| 56 | 56 | } |
| 57 | 57 | BaseDAO::closeConnection($link); |
| 58 | 58 | return $row; |
| 59 | - } |
|
| 59 | + } |
|
| 60 | 60 | |
| 61 | 61 | public static function storeAuthToken($token, User $authUser){
|
| 62 | 62 | |
@@ -9,32 +9,32 @@ discard block |
||
| 9 | 9 | session_start(); |
| 10 | 10 | } |
| 11 | 11 | |
| 12 | - require_once '../config/db.config.inc'; |
|
| 12 | + require_once '../config/db.config.inc'; |
|
| 13 | 13 | |
| 14 | - /** |
|
| 15 | - * Summary: Database connection manager class |
|
| 16 | - * |
|
| 17 | - */ |
|
| 18 | - abstract class BaseDAO { |
|
| 14 | + /** |
|
| 15 | + * Summary: Database connection manager class |
|
| 16 | + * |
|
| 17 | + */ |
|
| 18 | + abstract class BaseDAO { |
|
| 19 | 19 | |
| 20 | - protected function __construct() { |
|
| 20 | + protected function __construct() { |
|
| 21 | 21 | |
| 22 | - } |
|
| 22 | + } |
|
| 23 | 23 | |
| 24 | - /** |
|
| 25 | - * Summary: Prepares the connection to the database for the call using global params from the db.config.inc |
|
| 26 | - * |
|
| 27 | - * @see db.config.inc |
|
| 28 | - * |
|
| 29 | - * @link http://php.net/manual/en/pdo.construct.php |
|
| 30 | - * @param global $dbhost |
|
| 31 | - * @param global $dbname |
|
| 32 | - * @param global $dbusername |
|
| 33 | - * @param global $dbpassword |
|
| 34 | - * |
|
| 35 | - * @return $link |
|
| 36 | - */ |
|
| 37 | - protected static function getConnection() { |
|
| 24 | + /** |
|
| 25 | + * Summary: Prepares the connection to the database for the call using global params from the db.config.inc |
|
| 26 | + * |
|
| 27 | + * @see db.config.inc |
|
| 28 | + * |
|
| 29 | + * @link http://php.net/manual/en/pdo.construct.php |
|
| 30 | + * @param global $dbhost |
|
| 31 | + * @param global $dbname |
|
| 32 | + * @param global $dbusername |
|
| 33 | + * @param global $dbpassword |
|
| 34 | + * |
|
| 35 | + * @return $link |
|
| 36 | + */ |
|
| 37 | + protected static function getConnection() { |
|
| 38 | 38 | $dbhost = HOST; |
| 39 | 39 | $dbusername = USERNAME; |
| 40 | 40 | $dbpassword = PASSWORD; |
@@ -50,36 +50,36 @@ discard block |
||
| 50 | 50 | }catch(PDOException $e){ |
| 51 | 51 | die('<b>Error:</b> '.$e->getMessage()); |
| 52 | 52 | } |
| 53 | - } |
|
| 53 | + } |
|
| 54 | 54 | |
| 55 | - /** |
|
| 56 | - * Summary: Closes the database connection for the provided $link. |
|
| 57 | - * |
|
| 58 | - * |
|
| 59 | - * @param dbconnection $link |
|
| 60 | - * $link is the connection required to be closed |
|
| 61 | - */ |
|
| 62 | - protected static function closeConnection($link){ |
|
| 55 | + /** |
|
| 56 | + * Summary: Closes the database connection for the provided $link. |
|
| 57 | + * |
|
| 58 | + * |
|
| 59 | + * @param dbconnection $link |
|
| 60 | + * $link is the connection required to be closed |
|
| 61 | + */ |
|
| 62 | + protected static function closeConnection($link){ |
|
| 63 | 63 | $link = null; |
| 64 | - } |
|
| 64 | + } |
|
| 65 | 65 | |
| 66 | - /** |
|
| 67 | - * Summary: transactional execution of any sql string |
|
| 68 | - * @param type $link |
|
| 69 | - * @param type $sql |
|
| 70 | - * @return type |
|
| 71 | - */ |
|
| 72 | - protected static function executeDBTransaction($link,$sql){ |
|
| 73 | - try{ |
|
| 74 | - $link->beginTransaction(); |
|
| 75 | - $link->exec($sql); |
|
| 76 | - $link->commit(); |
|
| 77 | - } catch (Exception $e) { |
|
| 78 | - $link->rollBack(); |
|
| 79 | - die('<b>Error:</b> '.$e->getMessage()); |
|
| 80 | - } |
|
| 81 | - return $link; |
|
| 82 | - } |
|
| 66 | + /** |
|
| 67 | + * Summary: transactional execution of any sql string |
|
| 68 | + * @param type $link |
|
| 69 | + * @param type $sql |
|
| 70 | + * @return type |
|
| 71 | + */ |
|
| 72 | + protected static function executeDBTransaction($link,$sql){ |
|
| 73 | + try{ |
|
| 74 | + $link->beginTransaction(); |
|
| 75 | + $link->exec($sql); |
|
| 76 | + $link->commit(); |
|
| 77 | + } catch (Exception $e) { |
|
| 78 | + $link->rollBack(); |
|
| 79 | + die('<b>Error:</b> '.$e->getMessage()); |
|
| 80 | + } |
|
| 81 | + return $link; |
|
| 82 | + } |
|
| 83 | 83 | |
| 84 | - } |
|
| 84 | + } |
|
| 85 | 85 | ?> |
| 86 | 86 | \ No newline at end of file |
@@ -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) { |
@@ -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 |
@@ -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) { |
@@ -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()); |
@@ -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) { |
@@ -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 |
@@ -34,7 +34,7 @@ |
||
| 34 | 34 | $this->user_id = $user_id; |
| 35 | 35 | } |
| 36 | 36 | |
| 37 | - public function jsonSerialize() { |
|
| 37 | + public function jsonSerialize() { |
|
| 38 | 38 | $getter_names = get_class_methods(get_class($this)); |
| 39 | 39 | $gettable_attributes = array(); |
| 40 | 40 | foreach ($getter_names as $key => $value) { |