/**
* Returns form for placing switch to selected coordinates
*
* @return string
*/
function um_MapLocationBuildForm()
{
$query = "SELECT * from `build` WHERE `geo` IS NULL OR `geo`='' ORDER by `streetid`";
$allNoGeoBuilds = simple_queryall($query);
$buildData = array();
$streetData = array();
$cityData = array();
$result = '';
if (!empty($allNoGeoBuilds)) {
$allCities = zb_AddressGetFullCityNames();
$allStreets = zb_AddressGetStreetAllData();
if (!empty($allStreets)) {
foreach ($allStreets as $ia => $eachstreet) {
$streetData[$eachstreet['id']] = $eachstreet['streetname'];
if (isset($allCities[$eachstreet['cityid']])) {
$cityData[$eachstreet['id']] = $allCities[$eachstreet['cityid']];
}
}
}
foreach ($allNoGeoBuilds as $io => $each) {
@($streetname = $streetData[$each['streetid']]);
$streetcity = isset($cityData[$each['streetid']]) ? $cityData[$each['streetid']] . ' ' : '';
$buildData[$each['id']] = $streetcity . $streetname . ' - ' . $each['buildnum'];
}
//form construct
if (cfr('BUILDS')) {
$inputs = wf_Selector('buildplacing', $buildData, '', '', true);
$inputs .= wf_Submit('Save');
$result .= $inputs;
}
}
return $result;
}
/**
* Returns all addres array in view like login=>city address
*
* @return array
*/
function zb_AddressGetFullCityaddresslist()
{
$alterconf = rcms_parse_ini_file(CONFIG_PATH . 'alter.ini');
$result = array();
$apts = array();
$builds = array();
$city_q = "SELECT * from `city`";
$adrz_q = "SELECT * from `address`";
$apt_q = "SELECT * from `apt`";
$build_q = "SELECT * from build";
$streets_q = "SELECT * from `street`";
$alladdrz = simple_queryall($adrz_q);
$allapt = simple_queryall($apt_q);
$allbuilds = simple_queryall($build_q);
$allstreets = simple_queryall($streets_q);
if (!empty($alladdrz)) {
$cities = zb_AddressGetFullCityNames();
foreach ($alladdrz as $io1 => $eachaddress) {
$address[$eachaddress['id']] = array('login' => $eachaddress['login'], 'aptid' => $eachaddress['aptid']);
}
foreach ($allapt as $io2 => $eachapt) {
$apts[$eachapt['id']] = array('apt' => $eachapt['apt'], 'buildid' => $eachapt['buildid']);
}
foreach ($allbuilds as $io3 => $eachbuild) {
$builds[$eachbuild['id']] = array('buildnum' => $eachbuild['buildnum'], 'streetid' => $eachbuild['streetid']);
}
foreach ($allstreets as $io4 => $eachstreet) {
$streets[$eachstreet['id']] = array('streetname' => $eachstreet['streetname'], 'cityid' => $eachstreet['cityid']);
}
foreach ($address as $io5 => $eachaddress) {
$apartment = $apts[$eachaddress['aptid']]['apt'];
$building = $builds[$apts[$eachaddress['aptid']]['buildid']]['buildnum'];
$streetname = $streets[$builds[$apts[$eachaddress['aptid']]['buildid']]['streetid']]['streetname'];
$cityid = $streets[$builds[$apts[$eachaddress['aptid']]['buildid']]['streetid']]['cityid'];
// zero apt handle
if ($alterconf['ZERO_TOLERANCE']) {
if ($apartment == 0) {
$apartment_filtered = '';
} else {
$apartment_filtered = '/' . $apartment;
}
} else {
$apartment_filtered = '/' . $apartment;
}
//only city display option
$result[$eachaddress['login']] = $cities[$cityid] . ' ' . $streetname . ' ' . $building . $apartment_filtered;
}
}
return $result;
}
/**
* Returns all user cities as login=>city
*
* @return array
*/
function zb_AddressGetCityUsers()
{
$result = array();
$apts = array();
$builds = array();
$city_q = "SELECT * from `city`";
$adrz_q = "SELECT * from `address`";
$apt_q = "SELECT * from `apt`";
$build_q = "SELECT * from build";
$streets_q = "SELECT * from `street`";
$alladdrz = simple_queryall($adrz_q);
$allapt = simple_queryall($apt_q);
$allbuilds = simple_queryall($build_q);
$allstreets = simple_queryall($streets_q);
if (!empty($alladdrz)) {
$cities = zb_AddressGetFullCityNames();
foreach ($alladdrz as $io1 => $eachaddress) {
$address[$eachaddress['id']] = array('login' => $eachaddress['login'], 'aptid' => $eachaddress['aptid']);
}
foreach ($allapt as $io2 => $eachapt) {
$apts[$eachapt['id']] = array('apt' => $eachapt['apt'], 'buildid' => $eachapt['buildid']);
}
foreach ($allbuilds as $io3 => $eachbuild) {
$builds[$eachbuild['id']] = array('buildnum' => $eachbuild['buildnum'], 'streetid' => $eachbuild['streetid']);
}
foreach ($allstreets as $io4 => $eachstreet) {
$streets[$eachstreet['id']] = array('streetname' => $eachstreet['streetname'], 'cityid' => $eachstreet['cityid']);
}
foreach ($address as $io5 => $eachaddress) {
$cityid = $streets[$builds[$apts[$eachaddress['aptid']]['buildid']]['streetid']]['cityid'];
$result[$eachaddress['login']] = $cities[$cityid];
}
}
return $result;
}
