<?php

class Building extends Db_Model
{

    static $table_name = 'buildings';

    public static function getList($complexId)
    {
        $buildings = self::$db->select('*')->from(self::$table_name)
            ->where('complex_id = ?', $complexId)
            ->where('published = 1')
            ->where('deleted_at IS NULL')
            ->order("CAST(REGEXP_SUBSTR(block_number, '^[0-9]+') AS UNSIGNED)")
            ->order("REGEXP_SUBSTR(block_number, '[а-яa-z]+$')")
            ->fetchAll();

        if (empty($buildings)) {
            return [];
        }

        foreach ($buildings as $building) {
            $building->floors_plans = Attachment::getBuildingFloorsPlans($building->id);
            $building->flatsStarters = Flat::getBuildingStarers($building->id);
        }

        return $buildings;
    }

    public static function getByOldId($oldId)
    {
        return self::$db->select()->from(self::$table_name)->where('old_ID = ?', $oldId)->fetchRow();
    }

}