<?php
defined('_JEXEC') or die("Access Deny");

class ISTRealtyControllerFlat extends JControllerForm {
    
	protected function postSaveHook(Joomla\CMS\MVC\Model\BaseDatabaseModel $model, $validData = array())
	{

		if(isset($validData['service'])){
			if (is_array($validData['service'])) $data['service'] = implode(',', $validData['service']);
		}

		$model->save($data);
		$flat_id = $model->get('state')->get('flat.id');
		if(isset($flat_id)) {

			$db = JFactory::getDBO();
			$query = "
	        SELECT 
	        f.id,
	        f.adress,
	        f.linkidua,
	        f.linkiden,
	        f.lat,
			f.lng
	        FROM #__a_flat f
	        WHERE 
	        f.`language` = 'ru-RU' 
	        and f.published = 1
	        and f.id = $flat_id
	        ";

            $db->setQuery($query);
			$flats = $db->loadObjectList();

			foreach ($flats as $key) {

		        $query = "UPDATE #__a_flat SET lat = $key->lat, lng = $key->lng, cords = 1 where id = $key->linkidua";
		        $db->setQuery($query);
		        $db->execute();
		        $query = "UPDATE #__a_flat SET lat = $key->lat, lng = $key->lng, cords = 1 where id = $key->linkiden";
		        $db->setQuery($query);
		        $db->execute();
		    }
		}
	}

}