ozo2003 /
HelperBundle
| @@ 150-164 (lines=15) @@ | ||
| 147 | } |
|
| 148 | break; |
|
| 149 | } |
|
| 150 | if (!$skip && isset(self::$mock[$tableName][$fkey])) { |
|
| 151 | if (is_numeric($fvalue)) { |
|
| 152 | $whereSql .= ' WHERE '.self::$mock[$tableName][$fkey]." = $fvalue"; |
|
| 153 | } else { |
|
| 154 | $whereSql .= ' WHERE '.self::$mock[$tableName][$fkey]." = '".addslashes(trim($fvalue))."'"; |
|
| 155 | } |
|
| 156 | } else { |
|
| 157 | if (!$skip && is_numeric($fvalue)) { |
|
| 158 | $whereSql .= ' WHERE '.$fkey." = $fvalue"; |
|
| 159 | } elseif (!$skip && !is_numeric($fvalue)) { |
|
| 160 | $whereSql .= ' WHERE '.$fkey." = '".addslashes(trim($fvalue))."'"; |
|
| 161 | } elseif ($skip && is_numeric($fkey)) { |
|
| 162 | $whereSql .= " WHERE $fvalue"; |
|
| 163 | } |
|
| 164 | } |
|
| 165 | unset($where[$fkey]); |
|
| 166 | if ($where && is_array($where)) { |
|
| 167 | foreach ($where as $key => $value) { |
|
| @@ 169-183 (lines=15) @@ | ||
| 166 | if ($where && is_array($where)) { |
|
| 167 | foreach ($where as $key => $value) { |
|
| 168 | $skip = is_array($value); |
|
| 169 | if (!$skip && isset(self::$mock[$tableName][$key])) { |
|
| 170 | if (is_numeric($value)) { |
|
| 171 | $whereSql .= ' AND '.self::$mock[$tableName][$key]." = $value"; |
|
| 172 | } else { |
|
| 173 | $whereSql .= ' AND '.self::$mock[$tableName][$key]." = '".addslashes(trim($value))."'"; |
|
| 174 | } |
|
| 175 | } else { |
|
| 176 | if (!$skip && is_numeric($value)) { |
|
| 177 | $whereSql .= ' AND '.$key." = $value"; |
|
| 178 | } elseif (!$skip && !is_numeric($value)) { |
|
| 179 | $whereSql .= ' AND '.$key." = '".addslashes(trim($value))."'"; |
|
| 180 | } elseif ($skip && is_numeric($key)) { |
|
| 181 | $whereSql .= " AND {$value[0]}"; |
|
| 182 | } |
|
| 183 | } |
|
| 184 | } |
|
| 185 | } |
|
| 186 | } |
|
