|
@@ -20,11 +20,11 @@ discard block |
|
|
block discarded – undo |
|
20
|
20
|
//For dates with times set, search on time, if the time is not set, search on date only. |
|
21
|
21
|
//E.g. searching for all records posted on '2015-11-14' should return all records that day, not just the ones posted at 00:00:00 on that day |
|
22
|
22
|
if ($value instanceof \DateTimeInterface) { |
|
23
|
|
- if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d'); |
|
|
23
|
+ if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d'); |
|
24
|
24
|
else $value = $value->format('Y-m-d H:i:s'); |
|
25
|
25
|
} |
|
26
|
26
|
if (is_object($value)) continue; |
|
27
|
|
- if ($prependField){ |
|
|
27
|
+ if ($prependField) { |
|
28
|
28
|
$sql[] = $this->quote($field) . ' = :' . $field; |
|
29
|
29
|
} else { |
|
30
|
30
|
$sql[] = ':' . $field; |
|
@@ -36,13 +36,13 @@ discard block |
|
|
block discarded – undo |
|
36
|
36
|
|
|
37
|
37
|
public function insert($table, $data) { |
|
38
|
38
|
$query = $this->buildSaveQuery($data); |
|
39
|
|
- return new Query('INSERT INTO ' . $this->quote($table) . ' (' .implode(', ', array_keys($query['args'])).') VALUES ( ' . implode(', ', $query['sql']). ' )', $query['args']); |
|
|
39
|
+ return new Query('INSERT INTO ' . $this->quote($table) . ' (' . implode(', ', array_keys($query['args'])) . ') VALUES ( ' . implode(', ', $query['sql']) . ' )', $query['args']); |
|
40
|
40
|
} |
|
41
|
41
|
|
|
42
|
42
|
public function update($table, array $primaryKey, $data) { |
|
43
|
43
|
$query = $this->buildSaveQuery($data, true); |
|
44
|
44
|
$where = []; |
|
45
|
|
- foreach($primaryKey as $field) $where[] = $this->quote($field) . ' = :' . $field; |
|
46
|
|
- return new Query('UPDATE ' . $this->quote($table) . ' SET ' . implode(', ', $query['sql']). ' WHERE '. implode(' AND ', $where), $query['args']); |
|
|
45
|
+ foreach ($primaryKey as $field) $where[] = $this->quote($field) . ' = :' . $field; |
|
|
46
|
+ return new Query('UPDATE ' . $this->quote($table) . ' SET ' . implode(', ', $query['sql']) . ' WHERE ' . implode(' AND ', $where), $query['args']); |
|
47
|
47
|
} |
|
48
|
48
|
} |