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;
}
