function getsByKeys($keys) { if (!$this->checkTable()) { return array(); } return $this->fetchAll(sprintf("SELECT * FROM %s WHERE ekey in (%s) ", $this->tablename, ACloud_Sys_Core_S::sqlImplode($keys))); }
function deleteSqlLogsByIds($ids) { if (!ACloud_Sys_Core_S::isArray($ids)) { return false; } $this->query(sprintf("DELETE FROM %s WHERE id IN (%s)", $this->tablename, ACloud_Sys_Core_S::sqlImplode($ids))); return $this->affected_rows(); }
function sqlMulti($array, $strip = true) { if (!ACloud_Sys_Core_S::isArray($array)) { return ''; } $str = ''; foreach ($array as $val) { if (!empty($val) && ACloud_Sys_Core_S::isArray($val)) { $str .= ($str ? ', ' : ' ') . '(' . ACloud_Sys_Core_S::sqlImplode($val, $strip) . ') '; } } return $str; }
function replaceSql($sqlTemplate, $argumentValues, $fields) { preg_match_all('/\\{(\\w+)\\}/', $sqlTemplate, $matches); if (!ACloud_Sys_Core_S::isArray($matches)) { return ''; } $seg = $this->getRandString(4); $sql = preg_replace('/\\{(\\w+)\\}/', $seg . '{${1}}' . $seg, $sqlTemplate); foreach ($matches[0] as $k => $v) { $value = $v != '{fields}' ? is_array($argumentValues[$matches[1][$k]]) ? ACloud_Sys_Core_S::sqlImplode($argumentValues[$matches[1][$k]]) : $argumentValues[$matches[1][$k]] : $fields; $sql = str_replace($seg . $v . $seg, $value, $sql); } return $sql; }