@@ -41,6 +41,9 @@ |
||
| 41 | 41 | return $output; |
| 42 | 42 | } |
| 43 | 43 | |
| 44 | + /** |
|
| 45 | + * @param string $con |
|
| 46 | + */ |
|
| 44 | 47 | public function whereClause($data = null, $condition = null, $con = null) |
| 45 | 48 | { |
| 46 | 49 | $joinClause = self::joinClause(); |
@@ -25,36 +25,36 @@ |
||
| 25 | 25 | $i = 0; |
| 26 | 26 | |
| 27 | 27 | if ($data[0]->REFERENCED_TABLE_NAME !== null) { |
| 28 | - $arraySize = count($data); |
|
| 29 | - |
|
| 30 | - foreach($data as $key => $value) { |
|
| 31 | - $output .= ' JOIN '.$value->REFERENCED_TABLE_NAME; |
|
| 32 | - } |
|
| 33 | - foreach($data as $key => $value) { |
|
| 34 | - $i++; |
|
| 35 | - $whereAnd = $i > 1 ? 'AND' : 'WHERE'; |
|
| 36 | - $output .= ' '.$whereAnd.' '.self::getTableName($connection).'.'.$value->COLUMN_NAME.'='.$value->REFERENCED_TABLE_NAME.'.'.$value->REFERENCED_COLUMN_NAME.' '; |
|
| 37 | - } |
|
| 38 | - } else { |
|
| 39 | - $output = false; |
|
| 40 | - } |
|
| 28 | + $arraySize = count($data); |
|
| 29 | + |
|
| 30 | + foreach($data as $key => $value) { |
|
| 31 | + $output .= ' JOIN '.$value->REFERENCED_TABLE_NAME; |
|
| 32 | + } |
|
| 33 | + foreach($data as $key => $value) { |
|
| 34 | + $i++; |
|
| 35 | + $whereAnd = $i > 1 ? 'AND' : 'WHERE'; |
|
| 36 | + $output .= ' '.$whereAnd.' '.self::getTableName($connection).'.'.$value->COLUMN_NAME.'='.$value->REFERENCED_TABLE_NAME.'.'.$value->REFERENCED_COLUMN_NAME.' '; |
|
| 37 | + } |
|
| 38 | + } else { |
|
| 39 | + $output = false; |
|
| 40 | + } |
|
| 41 | 41 | return $output; |
| 42 | 42 | } |
| 43 | 43 | |
| 44 | 44 | public function whereClause($data = null, $condition = null, $con = null) |
| 45 | 45 | { |
| 46 | - $joinClause = self::joinClause(); |
|
| 46 | + $joinClause = self::joinClause(); |
|
| 47 | 47 | $connection = self::checkConnection($con); |
| 48 | 48 | $tableName = self::getTableName($connection); |
| 49 | 49 | $columnName = self::whereAndClause($tableName, $data, $condition); |
| 50 | 50 | |
| 51 | - $query = 'SELECT * FROM '.$tableName; |
|
| 51 | + $query = 'SELECT * FROM '.$tableName; |
|
| 52 | 52 | |
| 53 | - if (! $joinClause) { |
|
| 54 | - $query .= ' WHERE '.$columnName; |
|
| 55 | - } else { |
|
| 56 | - $query .= ($data === null) ? $joinClause : $joinClause .' AND '.$columnName; |
|
| 57 | - } |
|
| 58 | - return $query; |
|
| 53 | + if (! $joinClause) { |
|
| 54 | + $query .= ' WHERE '.$columnName; |
|
| 55 | + } else { |
|
| 56 | + $query .= ($data === null) ? $joinClause : $joinClause .' AND '.$columnName; |
|
| 57 | + } |
|
| 58 | + return $query; |
|
| 59 | 59 | } |
| 60 | 60 | } |
| 61 | 61 | \ No newline at end of file |
@@ -25,12 +25,12 @@ discard block |
||
| 25 | 25 | $i = 0; |
| 26 | 26 | |
| 27 | 27 | if ($data[0]->REFERENCED_TABLE_NAME !== null) { |
| 28 | - $arraySize = count($data); |
|
| 28 | + $arraySize = count($data); |
|
| 29 | 29 | |
| 30 | - foreach($data as $key => $value) { |
|
| 30 | + foreach ($data as $key => $value) { |
|
| 31 | 31 | $output .= ' JOIN '.$value->REFERENCED_TABLE_NAME; |
| 32 | 32 | } |
| 33 | - foreach($data as $key => $value) { |
|
| 33 | + foreach ($data as $key => $value) { |
|
| 34 | 34 | $i++; |
| 35 | 35 | $whereAnd = $i > 1 ? 'AND' : 'WHERE'; |
| 36 | 36 | $output .= ' '.$whereAnd.' '.self::getTableName($connection).'.'.$value->COLUMN_NAME.'='.$value->REFERENCED_TABLE_NAME.'.'.$value->REFERENCED_COLUMN_NAME.' '; |
@@ -50,10 +50,10 @@ discard block |
||
| 50 | 50 | |
| 51 | 51 | $query = 'SELECT * FROM '.$tableName; |
| 52 | 52 | |
| 53 | - if (! $joinClause) { |
|
| 53 | + if ( ! $joinClause) { |
|
| 54 | 54 | $query .= ' WHERE '.$columnName; |
| 55 | 55 | } else { |
| 56 | - $query .= ($data === null) ? $joinClause : $joinClause .' AND '.$columnName; |
|
| 56 | + $query .= ($data === null) ? $joinClause : $joinClause.' AND '.$columnName; |
|
| 57 | 57 | } |
| 58 | 58 | return $query; |
| 59 | 59 | } |
@@ -83,8 +83,8 @@ discard block |
||
| 83 | 83 | /** |
| 84 | 84 | *@method bool ValidateExtension() returns whether the extension of file to be uploaded |
| 85 | 85 | * is allowable or not. |
| 86 | - *@return true the extension is valid. |
|
| 87 | - *@return false the extension is invalid. |
|
| 86 | + *@return boolean the extension is valid. |
|
| 87 | + *@return boolean the extension is invalid. |
|
| 88 | 88 | */ |
| 89 | 89 | public function ValidateExtension() |
| 90 | 90 | { |
@@ -115,8 +115,8 @@ discard block |
||
| 115 | 115 | |
| 116 | 116 | /** |
| 117 | 117 | *@method bool ValidateSize() returns whether the file size is acceptable. |
| 118 | - *@return true the size is smaller than the alloted value. |
|
| 119 | - *@return false the size is larger than the alloted value. |
|
| 118 | + *@return boolean the size is smaller than the alloted value. |
|
| 119 | + *@return boolean the size is larger than the alloted value. |
|
| 120 | 120 | */ |
| 121 | 121 | public function ValidateSize() |
| 122 | 122 | { |
@@ -140,8 +140,8 @@ discard block |
||
| 140 | 140 | |
| 141 | 141 | /** |
| 142 | 142 | *@method bool ValidateExistance() determins whether the file already exists. If so, rename $FileName. |
| 143 | - *@return true can never be returned as all file names must be unique. |
|
| 144 | - *@return false the file name does not exist. |
|
| 143 | + *@return null|false can never be returned as all file names must be unique. |
|
| 144 | + *@return null|false the file name does not exist. |
|
| 145 | 145 | */ |
| 146 | 146 | public function ValidateExistance($uploadDirectory) |
| 147 | 147 | { |
@@ -161,8 +161,8 @@ discard block |
||
| 161 | 161 | |
| 162 | 162 | /** |
| 163 | 163 | *@method bool ValidateDirectory() |
| 164 | - *@return true the UploadDirectory exists, writable, and has a traling slash. |
|
| 165 | - *@return false the directory was never set, does not exist, or is not writable. |
|
| 164 | + *@return null|boolean the UploadDirectory exists, writable, and has a traling slash. |
|
| 165 | + *@return null|boolean the directory was never set, does not exist, or is not writable. |
|
| 166 | 166 | */ |
| 167 | 167 | public function ValidateDirectory($uploadDirectory) |
| 168 | 168 | { |
@@ -194,8 +194,8 @@ discard block |
||
| 194 | 194 | |
| 195 | 195 | /** |
| 196 | 196 | *@method bool ValidateImage() |
| 197 | - *@return true the image is smaller than the alloted dimensions. |
|
| 198 | - *@return false the width and/or height is larger then the alloted dimensions. |
|
| 197 | + *@return boolean the image is smaller than the alloted dimensions. |
|
| 198 | + *@return boolean the width and/or height is larger then the alloted dimensions. |
|
| 199 | 199 | */ |
| 200 | 200 | public function ValidateImage() { |
| 201 | 201 | $MaximumWidth = $this->MaximumWidth; |
@@ -311,6 +311,9 @@ discard block |
||
| 311 | 311 | return $this->UploadDirectory; |
| 312 | 312 | } |
| 313 | 313 | |
| 314 | + /** |
|
| 315 | + * @return string |
|
| 316 | + */ |
|
| 314 | 317 | public function GetTempName() |
| 315 | 318 | { |
| 316 | 319 | return $this->output['tmp_name']; |
@@ -94,12 +94,12 @@ discard block |
||
| 94 | 94 | $Extension = strtolower($FileParts['extension']); |
| 95 | 95 | $ValidExtensions = $this->ValidExtensions; |
| 96 | 96 | |
| 97 | - if (!$FileName) { |
|
| 97 | + if ( ! $FileName) { |
|
| 98 | 98 | $this->SetMessage("ERROR: File name is empty."); |
| 99 | 99 | return false; |
| 100 | 100 | } |
| 101 | 101 | |
| 102 | - if (!$ValidExtensions) { |
|
| 102 | + if ( ! $ValidExtensions) { |
|
| 103 | 103 | $this->SetMessage("WARNING: All extensions are valid."); |
| 104 | 104 | return true; |
| 105 | 105 | } |
@@ -124,7 +124,7 @@ discard block |
||
| 124 | 124 | $TempFileName = $this->GetTempName(); |
| 125 | 125 | $TempFileSize = filesize($TempFileName); |
| 126 | 126 | |
| 127 | - if($MaximumFileSize == "") { |
|
| 127 | + if ($MaximumFileSize == "") { |
|
| 128 | 128 | $this->SetMessage("WARNING: There is no size restriction."); |
| 129 | 129 | return true; |
| 130 | 130 | } |
@@ -146,11 +146,11 @@ discard block |
||
| 146 | 146 | public function ValidateExistance($uploadDirectory) |
| 147 | 147 | { |
| 148 | 148 | $FileName = $this->GetFileName(); |
| 149 | - $File = $uploadDirectory . $FileName; |
|
| 149 | + $File = $uploadDirectory.$FileName; |
|
| 150 | 150 | |
| 151 | 151 | if (file_exists($File)) { |
| 152 | 152 | $this->SetMessage("Message: The file '$FileName' already exist."); |
| 153 | - $UniqueName = rand() . $FileName; |
|
| 153 | + $UniqueName = rand().$FileName; |
|
| 154 | 154 | $this->SetFileName($UniqueName); |
| 155 | 155 | $this->ValidateExistance($uploadDirectory); |
| 156 | 156 | } else { |
@@ -166,24 +166,24 @@ discard block |
||
| 166 | 166 | */ |
| 167 | 167 | public function ValidateDirectory($uploadDirectory) |
| 168 | 168 | { |
| 169 | - if (! $uploadDirectory) { |
|
| 169 | + if ( ! $uploadDirectory) { |
|
| 170 | 170 | $this->SetMessage("ERROR: The directory variable is empty."); |
| 171 | 171 | return false; |
| 172 | 172 | } |
| 173 | 173 | |
| 174 | - if (!is_dir($uploadDirectory)) { |
|
| 174 | + if ( ! is_dir($uploadDirectory)) { |
|
| 175 | 175 | $this->SetMessage("ERROR: The directory '$uploadDirectory' does not exist."); |
| 176 | 176 | return false; |
| 177 | 177 | } |
| 178 | 178 | |
| 179 | - if (!is_writable($uploadDirectory)) { |
|
| 179 | + if ( ! is_writable($uploadDirectory)) { |
|
| 180 | 180 | $this->SetMessage("ERROR: The directory '$uploadDirectory' does not writable."); |
| 181 | 181 | return false; |
| 182 | 182 | } |
| 183 | 183 | |
| 184 | 184 | if (substr($uploadDirectory, -1) != "/") { |
| 185 | 185 | $this->SetMessage("ERROR: The traling slash does not exist."); |
| 186 | - $NewDirectory = $uploadDirectory . "/"; |
|
| 186 | + $NewDirectory = $uploadDirectory."/"; |
|
| 187 | 187 | $this->SetUploadDirectory($NewDirectory); |
| 188 | 188 | $this->ValidateDirectory($uploadDirectory); |
| 189 | 189 | } else { |
@@ -202,9 +202,9 @@ discard block |
||
| 202 | 202 | $MaximumHeight = $this->MaximumHeight; |
| 203 | 203 | $TempFileName = $this->GetTempName(); |
| 204 | 204 | |
| 205 | - if($Size = @getimagesize($TempFileName)) { |
|
| 206 | - $Width = $Size[0]; //$Width is the width in pixels of the image uploaded to the server. |
|
| 207 | - $Height = $Size[1]; //$Height is the height in pixels of the image uploaded to the server. |
|
| 205 | + if ($Size = @getimagesize($TempFileName)) { |
|
| 206 | + $Width = $Size[0]; //$Width is the width in pixels of the image uploaded to the server. |
|
| 207 | + $Height = $Size[1]; //$Height is the height in pixels of the image uploaded to the server. |
|
| 208 | 208 | } |
| 209 | 209 | |
| 210 | 210 | if ($Width > $MaximumWidth) { |
@@ -323,7 +323,7 @@ discard block |
||
| 323 | 323 | |
| 324 | 324 | public function GetMessage() |
| 325 | 325 | { |
| 326 | - if (!isset($this->Message)) { |
|
| 326 | + if ( ! isset($this->Message)) { |
|
| 327 | 327 | $this->SetMessage("No Message"); |
| 328 | 328 | } |
| 329 | 329 | |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | interface GetDataInterface |
| 13 | 13 | { |
| 14 | - public function all(); |
|
| 14 | + public function all(); |
|
| 15 | 15 | |
| 16 | 16 | public function allDESC($limit); |
| 17 | 17 | |
@@ -23,5 +23,5 @@ discard block |
||
| 23 | 23 | |
| 24 | 24 | public function first(); |
| 25 | 25 | |
| 26 | - public function getCount(); |
|
| 26 | + public function getCount(); |
|
| 27 | 27 | } |
@@ -11,7 +11,7 @@ |
||
| 11 | 11 | |
| 12 | 12 | interface RelationshipsInterface |
| 13 | 13 | { |
| 14 | - public function joinClause(); |
|
| 14 | + public function joinClause(); |
|
| 15 | 15 | |
| 16 | 16 | public function whereClause($data, $condition); |
| 17 | 17 | } |
| 18 | 18 | \ No newline at end of file |