/** * 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; }