fwolf /
fwlib
| @@ 176-197 (lines=22) @@ | ||
| 173 | * @param array $part |
|
| 174 | * @return string |
|
| 175 | */ |
|
| 176 | public function genSelect($part = []) |
|
| 177 | { |
|
| 178 | $arrayUtil = $this->getUtilContainer()->getArray(); |
|
| 179 | ||
| 180 | if (!empty($part) && is_array($part)) { |
|
| 181 | // Using preferred parts in $part only |
|
| 182 | $ar = &$part; |
|
| 183 | } else { |
|
| 184 | // Using all parts, by below sequence |
|
| 185 | $ar = [ |
|
| 186 | 'SELECT', 'FROM', 'WHERE', 'GROUPBY', 'HAVING', |
|
| 187 | 'ORDERBY', 'LIMIT' |
|
| 188 | ]; |
|
| 189 | } |
|
| 190 | ||
| 191 | $sql = ''; |
|
| 192 | foreach ($ar as $v) { |
|
| 193 | $sql .= $arrayUtil->getIdx($this->sqlPart, strtoupper($v), ''); |
|
| 194 | } |
|
| 195 | ||
| 196 | return $sql; |
|
| 197 | } |
|
| 198 | ||
| 199 | ||
| 200 | /** |
|
| @@ 359-377 (lines=19) @@ | ||
| 356 | * @param array $part |
|
| 357 | * @return string |
|
| 358 | */ |
|
| 359 | public function genUpdate($part = []) |
|
| 360 | { |
|
| 361 | $arrayUtil = $this->getUtilContainer()->getArray(); |
|
| 362 | ||
| 363 | if (!empty($part) && is_array($part)) { |
|
| 364 | // Using preferred parts in $part only |
|
| 365 | $ar = &$part; |
|
| 366 | } else { |
|
| 367 | // Using all parts, by below sequence |
|
| 368 | $ar = ['UPDATE', 'SET', 'WHERE', 'ORDERBY', 'LIMIT']; |
|
| 369 | } |
|
| 370 | ||
| 371 | $sql = ''; |
|
| 372 | foreach ($ar as $v) { |
|
| 373 | $sql .= $arrayUtil->getIdx($this->sqlPart, strtoupper($v), ''); |
|
| 374 | } |
|
| 375 | ||
| 376 | return $sql; |
|
| 377 | } |
|
| 378 | ||
| 379 | ||
| 380 | /** |
|
