@@ -87,7 +87,7 @@ |
||
| 87 | 87 | } |
| 88 | 88 | |
| 89 | 89 | return $classname . ' {' . implode(', ', array_map( |
| 90 | - function ($p_0) use ($data) { |
|
| 90 | + function($p_0) use ($data) { |
|
| 91 | 91 | $p_0->setAccessible(true); |
| 92 | 92 | |
| 93 | 93 | return $p_0->getName() . ': ' . $p_0->getValue($data); |
@@ -164,7 +164,7 @@ |
||
| 164 | 164 | $prepare = empty($prepare) ? $this->prepare : $prepare; |
| 165 | 165 | return $prepare->rowCount(); |
| 166 | 166 | } catch (PDOException $e) { |
| 167 | - $this->setError($e);} |
|
| 167 | + $this->setError($e); } |
|
| 168 | 168 | } |
| 169 | 169 | |
| 170 | 170 | /** |
@@ -132,8 +132,9 @@ |
||
| 132 | 132 | */ |
| 133 | 133 | protected function setTable(string $tableName, string $tableAlias = ""): self |
| 134 | 134 | { |
| 135 | - if (!empty($tableAlias)) |
|
| 136 | - $this->tableAlias = $tableAlias; |
|
| 135 | + if (!empty($tableAlias)) {
|
|
| 136 | + $this->tableAlias = $tableAlias; |
|
| 137 | + } |
|
| 137 | 138 | $this->tableName = $tableName; |
| 138 | 139 | return $this; |
| 139 | 140 | } |
@@ -27,7 +27,7 @@ discard block |
||
| 27 | 27 | */ |
| 28 | 28 | public function select(string $fields = '*', string $add = '', array $values = null, bool $returnModel = false, bool $debug = false) |
| 29 | 29 | {
|
| 30 | - if (strlen($add) > 0) {
|
|
| 30 | + if (strlen($add)>0) {
|
|
| 31 | 31 | $add = ' ' . $add; |
| 32 | 32 | } |
| 33 | 33 | |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | $numparams = substr($numparams, 1); |
| 67 | 67 | $sql = "INSERT INTO {$this->getTable()} ({$fields}) VALUES ({$numparams})";
|
| 68 | 68 | if ($debug) {
|
| 69 | - echo $sql.'<pre>'.print_r($values).'</pre>'; |
|
| 69 | + echo $sql . '<pre>' . print_r($values) . '</pre>'; |
|
| 70 | 70 | return; |
| 71 | 71 | } |
| 72 | 72 | $result = $this->executeSQL($sql, $values); |
@@ -148,7 +148,7 @@ discard block |
||
| 148 | 148 | $sql .= " WHERE $where"; |
| 149 | 149 | } |
| 150 | 150 | if ($debug) {
|
| 151 | - echo $sql.'<pre>'.print_r($values).'</pre>'; |
|
| 151 | + echo $sql . '<pre>' . print_r($values) . '</pre>'; |
|
| 152 | 152 | return; |
| 153 | 153 | } |
| 154 | 154 | $result = $this->executeSQL($sql, $values); |
@@ -223,7 +223,7 @@ discard block |
||
| 223 | 223 | $sql .= " WHERE $where"; |
| 224 | 224 | } |
| 225 | 225 | if ($debug) {
|
| 226 | - echo $sql.'<pre>'.print_r($values).'</pre>'; |
|
| 226 | + echo $sql . '<pre>' . print_r($values) . '</pre>'; |
|
| 227 | 227 | return; |
| 228 | 228 | } |
| 229 | 229 | $result = $this->executeSQL($sql, $values); |
@@ -33,8 +33,9 @@ |
||
| 33 | 33 | |
| 34 | 34 | $sql = "SELECT {$fields} FROM {$this->getTable()}";
|
| 35 | 35 | |
| 36 | - if (!empty($this->getTableAlias())) |
|
| 37 | - $sql .= " AS {$this->getTableAlias()}";
|
|
| 36 | + if (!empty($this->getTableAlias())) {
|
|
| 37 | + $sql .= " AS {$this->getTableAlias()}";
|
|
| 38 | + } |
|
| 38 | 39 | |
| 39 | 40 | $sql .= "{$add}";
|
| 40 | 41 | |
@@ -17,9 +17,9 @@ discard block |
||
| 17 | 17 | use DatalayerTrait; |
| 18 | 18 | |
| 19 | 19 | /** |
| 20 | - * @param string $fields |
|
| 21 | - * @param array $paramns |
|
| 22 | - * @return $this |
|
| 20 | + * @param string $fields |
|
| 21 | + * @param array $paramns |
|
| 22 | + * @return $this |
|
| 23 | 23 | */ |
| 24 | 24 | public function select(string $fields = "*", array $paramns = []): CrudBuilder |
| 25 | 25 | {
|
@@ -35,9 +35,9 @@ discard block |
||
| 35 | 35 | } |
| 36 | 36 | |
| 37 | 37 | /** |
| 38 | - * @param string $fields |
|
| 39 | - * @param array $paramns |
|
| 40 | - * @return $this |
|
| 38 | + * @param string $fields |
|
| 39 | + * @param array $paramns |
|
| 40 | + * @return $this |
|
| 41 | 41 | */ |
| 42 | 42 | public function insert(string $fields, array $paramns): self |
| 43 | 43 | {
|
@@ -56,9 +56,9 @@ discard block |
||
| 56 | 56 | } |
| 57 | 57 | |
| 58 | 58 | /** |
| 59 | - * @param string $fields |
|
| 60 | - * @param array $paramns |
|
| 61 | - * @return $this |
|
| 59 | + * @param string $fields |
|
| 60 | + * @param array $paramns |
|
| 61 | + * @return $this |
|
| 62 | 62 | */ |
| 63 | 63 | public function update(string $fields, array $paramns): self |
| 64 | 64 | {
|
@@ -79,9 +79,9 @@ discard block |
||
| 79 | 79 | } |
| 80 | 80 | |
| 81 | 81 | /** |
| 82 | - * @param string $fields |
|
| 83 | - * @param array $paramns |
|
| 84 | - * @return $this |
|
| 82 | + * @param string $fields |
|
| 83 | + * @param array $paramns |
|
| 84 | + * @return $this |
|
| 85 | 85 | */ |
| 86 | 86 | public function delete(string $fields, array $paramns): self |
| 87 | 87 | {
|
@@ -95,9 +95,9 @@ discard block |
||
| 95 | 95 | } |
| 96 | 96 | |
| 97 | 97 | /** |
| 98 | - * @param string $texto |
|
| 99 | - * @param array $paramns |
|
| 100 | - * @return $this |
|
| 98 | + * @param string $texto |
|
| 99 | + * @param array $paramns |
|
| 100 | + * @return $this |
|
| 101 | 101 | */ |
| 102 | 102 | public function query(string $texto, array $paramns = []): self |
| 103 | 103 | {
|
@@ -110,9 +110,9 @@ discard block |
||
| 110 | 110 | } |
| 111 | 111 | |
| 112 | 112 | /** |
| 113 | - * @param string $texto |
|
| 114 | - * @param array $paramns |
|
| 115 | - * @return $this |
|
| 113 | + * @param string $texto |
|
| 114 | + * @param array $paramns |
|
| 115 | + * @return $this |
|
| 116 | 116 | */ |
| 117 | 117 | public function where(string $texto, array $paramns = []): self |
| 118 | 118 | {
|
@@ -126,9 +126,9 @@ discard block |
||
| 126 | 126 | } |
| 127 | 127 | |
| 128 | 128 | /** |
| 129 | - * @param string $condition |
|
| 130 | - * @param array $paramns |
|
| 131 | - * @return $this |
|
| 129 | + * @param string $condition |
|
| 130 | + * @param array $paramns |
|
| 131 | + * @return $this |
|
| 132 | 132 | */ |
| 133 | 133 | public function andWhere(string $condition, array $paramns = []): self |
| 134 | 134 | {
|
@@ -142,9 +142,9 @@ discard block |
||
| 142 | 142 | } |
| 143 | 143 | |
| 144 | 144 | /** |
| 145 | - * @param string $texto |
|
| 146 | - * @param array $paramns |
|
| 147 | - * @return $this |
|
| 145 | + * @param string $texto |
|
| 146 | + * @param array $paramns |
|
| 147 | + * @return $this |
|
| 148 | 148 | */ |
| 149 | 149 | public function orWhere(string $texto, array $paramns = []): self |
| 150 | 150 | {
|
@@ -158,8 +158,8 @@ discard block |
||
| 158 | 158 | } |
| 159 | 159 | |
| 160 | 160 | /** |
| 161 | - * @param string $texto |
|
| 162 | - * @return $this |
|
| 161 | + * @param string $texto |
|
| 162 | + * @return $this |
|
| 163 | 163 | */ |
| 164 | 164 | public function orderBy(string $texto): self |
| 165 | 165 | {
|
@@ -173,8 +173,8 @@ discard block |
||
| 173 | 173 | } |
| 174 | 174 | |
| 175 | 175 | /** |
| 176 | - * @param string $texto |
|
| 177 | - * @return $this |
|
| 176 | + * @param string $texto |
|
| 177 | + * @return $this |
|
| 178 | 178 | */ |
| 179 | 179 | public function limit(string $texto): self |
| 180 | 180 | {
|
@@ -184,8 +184,8 @@ discard block |
||
| 184 | 184 | } |
| 185 | 185 | |
| 186 | 186 | /** |
| 187 | - * @param string $texto |
|
| 188 | - * @return $this |
|
| 187 | + * @param string $texto |
|
| 188 | + * @return $this |
|
| 189 | 189 | */ |
| 190 | 190 | public function offset(string $texto): self |
| 191 | 191 | {
|
@@ -199,8 +199,8 @@ discard block |
||
| 199 | 199 | } |
| 200 | 200 | |
| 201 | 201 | /** |
| 202 | - * @param string $texto |
|
| 203 | - * @return $this |
|
| 202 | + * @param string $texto |
|
| 203 | + * @return $this |
|
| 204 | 204 | */ |
| 205 | 205 | public function groupBy(string $texto): self |
| 206 | 206 | {
|
@@ -214,8 +214,8 @@ discard block |
||
| 214 | 214 | } |
| 215 | 215 | |
| 216 | 216 | /** |
| 217 | - * @param string $texto |
|
| 218 | - * @return $this |
|
| 217 | + * @param string $texto |
|
| 218 | + * @return $this |
|
| 219 | 219 | */ |
| 220 | 220 | public function having(string $texto): self |
| 221 | 221 | {
|
@@ -229,10 +229,10 @@ discard block |
||
| 229 | 229 | } |
| 230 | 230 | |
| 231 | 231 | /** |
| 232 | - * @param string $table |
|
| 233 | - * @param string $alias |
|
| 234 | - * @param string $codition |
|
| 235 | - * @return $this |
|
| 232 | + * @param string $table |
|
| 233 | + * @param string $alias |
|
| 234 | + * @param string $codition |
|
| 235 | + * @return $this |
|
| 236 | 236 | */ |
| 237 | 237 | public function innerJoin(string $table, string $alias, string $codition): self |
| 238 | 238 | {
|
@@ -246,10 +246,10 @@ discard block |
||
| 246 | 246 | } |
| 247 | 247 | |
| 248 | 248 | /** |
| 249 | - * @param string $table |
|
| 250 | - * @param string $alias |
|
| 251 | - * @param string $codition |
|
| 252 | - * @return $this |
|
| 249 | + * @param string $table |
|
| 250 | + * @param string $alias |
|
| 251 | + * @param string $codition |
|
| 252 | + * @return $this |
|
| 253 | 253 | */ |
| 254 | 254 | public function leftJoin(string $table, string $alias, string $codition): self |
| 255 | 255 | {
|
@@ -263,10 +263,10 @@ discard block |
||
| 263 | 263 | } |
| 264 | 264 | |
| 265 | 265 | /** |
| 266 | - * @param string $table |
|
| 267 | - * @param string $alias |
|
| 268 | - * @param string $codition |
|
| 269 | - * @return $this |
|
| 266 | + * @param string $table |
|
| 267 | + * @param string $alias |
|
| 268 | + * @param string $codition |
|
| 269 | + * @return $this |
|
| 270 | 270 | */ |
| 271 | 271 | public function rightJoin(string $table, string $alias, string $codition): self |
| 272 | 272 | {
|
@@ -293,7 +293,7 @@ discard block |
||
| 293 | 293 | } |
| 294 | 294 | |
| 295 | 295 | /** |
| 296 | - * @return void |
|
| 296 | + * @return void |
|
| 297 | 297 | */ |
| 298 | 298 | public function debug() |
| 299 | 299 | {
|
@@ -25,8 +25,9 @@ discard block |
||
| 25 | 25 | {
|
| 26 | 26 | try {
|
| 27 | 27 | $query = "SELECT {$fields} FROM {$this->getTable()} ";
|
| 28 | - if (!empty($this->getTableAlias())) |
|
| 29 | - $query .= "AS {$this->getTableAlias()} ";
|
|
| 28 | + if (!empty($this->getTableAlias())) {
|
|
| 29 | + $query .= "AS {$this->getTableAlias()} ";
|
|
| 30 | + } |
|
| 30 | 31 | $this->add($query, $paramns); |
| 31 | 32 | return $this; |
| 32 | 33 | } catch (\PDOException $e) {
|
@@ -332,8 +333,9 @@ discard block |
||
| 332 | 333 | private function add(string $text, array $params = []) |
| 333 | 334 | {
|
| 334 | 335 | try {
|
| 335 | - if (!empty($params)) |
|
| 336 | - $this->params = array_merge($this->params, $params); |
|
| 336 | + if (!empty($params)) {
|
|
| 337 | + $this->params = array_merge($this->params, $params); |
|
| 338 | + } |
|
| 337 | 339 | $this->query .= $text; |
| 338 | 340 | } catch (\PDOException $e) {
|
| 339 | 341 | $this->setError($e); |