Files
thetool/scripts/addressdb/recalculate-netzgebiet-unit_count.php

31 lines
918 B
PHP

#!/usr/bin/php
<?php
//require 'vendor/autoload.php';
require("../../config/config.php");
define('FRONKDB_SQLDEBUG', false);
error_reporting(E_ALL & ~(E_NOTICE | E_STRICT | E_DEPRECATED));
require_once(LIBDIR . "/mvcfronk/mfRouter/mfRouter.php");
require_once(LIBDIR . "/mvcfronk/mfBase/mfBaseModel.php");
require_once(LIBDIR . "/mvcfronk/mfBase/mfBaseController.php");
$me = new User(1);
define("INTERNAL_USER_ID", $me->id);
define("INTERNAL_USER_USERNAME", $me->username);
define("MFBASE_BYPASS_LOGIN", true);
foreach(ADBNetzgebietModel::getAll() as $netzgebiet) {
foreach(ADBHausnummerModel::search(["netzgebiet_id" => $netzgebiet->id]) as $hausnummer) {
if(!count($hausnummer->wohneinheiten)) continue;
$wohneinheiten = $hausnummer->wohneinheiten;
$unit = array_shift($wohneinheiten);
$unit->save();
echo "Updated ".$netzgebiet->name."\n";
break;
}
}