65 lines
1.5 KiB
PHP
65 lines
1.5 KiB
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);
|
|
|
|
$filename = __DIR__."/source/25_unscheduled_neueCluster.csv";
|
|
|
|
$db = FronkDB::singleton(ADDRESSDB_DBHOST, ADDRESSDB_DBUSER, ADDRESSDB_DBPASS, ADDRESSDB_DBNAME);
|
|
$log = mfLoghandler::singleton();
|
|
|
|
$input = fopen($filename, "r");
|
|
|
|
$i = 0;
|
|
$u = 0;
|
|
while($csv = fgetcsv($input)) {
|
|
$i++;
|
|
if($i == 1) continue;
|
|
|
|
|
|
$hausnummer = false;
|
|
|
|
if(!trim($csv[1])) {
|
|
continue;
|
|
}
|
|
|
|
//echo implode(", ", $csv)."\n";
|
|
$hausnummer_id = trim($csv[0]);
|
|
|
|
if(!$hausnummer_id) {
|
|
echo "Address not found $hausnummer_id\n";
|
|
continue;
|
|
}
|
|
|
|
$hausnummer = new ADBHausnummer($hausnummer_id);
|
|
if(!$hausnummer->id) {
|
|
echo "Hausnummer not found $hausnummer_id\n";
|
|
continue;
|
|
}
|
|
|
|
if($hausnummer->rollout_info != "unscheduled" || $hausnummer->rollout != null) {
|
|
$hausnummer->rollout = null;
|
|
$hausnummer->rollout_info = "unscheduled";
|
|
|
|
if(!$hausnummer->save()) {
|
|
var_dump($hausnummer);
|
|
echo "Error saving Address $hausnummer_id\n";
|
|
continue;
|
|
}
|
|
$u++;
|
|
}
|
|
|
|
|
|
|
|
}
|
|
echo "Updated $u Addresses\n"; |