Пример #1
0
 public function getIdsFromTable($startId, $endId)
 {
     list($tableName, $primaryKey) = $this->getPrimaryKeyAndTable();
     $result = $tmpResult = array();
     $sql = sprintf("SELECT %s FROM %s WHERE %s >= %s AND %s <= %s", ACloudSysCoreS::sqlMetaData($primaryKey), ACloudSysCoreS::sqlMetaData('{{' . $tableName . '}}'), ACloudSysCoreS::sqlMetaData($primaryKey), ACloudSysCoreS::sqlEscape($startId), ACloudSysCoreS::sqlMetaData($primaryKey), ACloudSysCoreS::sqlEscape($endId));
     $query = Wind::getComponent('db')->query($sql);
     $tmpResult = $query->fetchAll(null, PDO::FETCH_ASSOC);
     if (!ACloudSysCoreS::isArray($tmpResult)) {
         return array();
     }
     foreach ($tmpResult as $value) {
         $result[] = $value[$primaryKey];
     }
     return $result;
 }