function formatFields($fields) { $result = array(); if (!ACloud_Sys_Core_S::isArray($fields)) { return '*'; } foreach ($fields as $field) { list($tableAlias, $fieldName) = strpos($field, '.') === false ? array('', $field) : explode('.', $field); $result[] = ($tableAlias ? $tableAlias . '.' : '') . ACloud_Sys_Core_S::sqlMetadata($fieldName); } return implode(',', $result); }
function buildClause($arrays, $expr = null) { if (!is_array($arrays) && !$expr) { return ''; } $sets = " SET "; if ($expr) { foreach ($expr as $v) { $sets .= " " . $v . ","; } } if ($arrays) { foreach ($arrays as $k => $v) { $sets .= " " . ACloud_Sys_Core_S::sqlMetadata($k) . " = " . ACloud_Sys_Core_S::sqlEscape($v) . ","; } } $sets = trim($sets, ","); return $sets ? $sets : ''; }
function getDataByPrimaryKeyRange($tableSetting, $start, $end) { $generalDataService = ACloud_Sys_Core_Common::loadSystemClass('generaldata', 'config.service'); $dataSql = sprintf('SELECT * FROM %s WHERE %s >= %s AND %s <= %s', ACloud_Sys_Core_S::sqlMetadata($tableSetting['name']), ACloud_Sys_Core_S::sqlMetadata($tableSetting['primary_key']), ACloud_Sys_Core_S::sqlEscape($start), ACloud_Sys_Core_S::sqlMetadata($tableSetting['primary_key']), ACloud_Sys_Core_S::sqlEscape($end)); return $generalDataService->executeSql($dataSql); }
function sqlSingle($array, $strip = true) { if (!ACloud_Sys_Core_S::isArray($array)) { return ''; } $array = ACloud_Sys_Core_S::sqlEscape($array, $strip, true); $str = ''; foreach ($array as $key => $val) { $str .= ($str ? ', ' : ' ') . ACloud_Sys_Core_S::sqlMetadata($key) . '=' . $val; } return $str; }