/**
* do the plugin action
*
*/
function process(&$data, &$listModel)
{
$params = $this->getParams();
// grab the table model and find table name and PK
$table = $listModel->getTable();
$table_name = $table->db_table_name;
$primary_key = $table->db_primary_key;
$primary_key_element = FabrikString::shortColName($table->db_primary_key);
// for now, we have to read the table ourselves. We can't rely on the $data passed to us
// because it can be arbitrarily filtered according to who happened to hit the page when cron
// needed to run.
$mydata = array();
$db = FabrikWorker::getDbo();
$db->setQuery("SELECT * FROM {$table_name}");
$mydata[0] = $db->loadObjectList();
// grab all the params, like GMaps key, field names to use, etc
// $geocode_gmap_key = $params->get('geocode_gmap_key');
$geocode_batch_limit = (int) $params->get('geocode_batch_limit', '0');
$geocode_delay = (int) $params->get('geocode_delay', '0');
$geocode_is_empty = $params->get('geocode_is_empty');
$geocode_zoom_level = $params->get('geocode_zoom_level', '4');
$geocode_map_element_long = $params->get('geocode_map_element');
$geocode_map_element = FabrikString::shortColName($geocode_map_element_long);
$geocode_addr1_element_long = $params->get('geocode_addr1_element');
$geocode_addr1_element = $geocode_addr1_element_long ? FabrikString::shortColName($geocode_addr1_element_long) : '';
$geocode_addr2_element_long = $params->get('geocode_addr2_element');
$geocode_addr2_element = $geocode_addr2_element_long ? FabrikString::shortColName($geocode_addr2_element_long) : '';
$geocode_city_element_long = $params->get('geocode_city_element');
$geocode_city_element = $geocode_city_element_long ? FabrikString::shortColName($geocode_city_element_long) : '';
$geocode_state_element_long = $params->get('geocode_state_element');
$geocode_state_element = $geocode_state_element_long ? FabrikString::shortColName($geocode_state_element_long) : '';
$geocode_zip_element_long = $params->get('geocode_zip_element');
$geocode_zip_element = $geocode_zip_element_long ? FabrikString::shortColName($geocode_zip_element_long) : '';
$geocode_country_element_long = $params->get('geocode_country_userid_element');
$geocode_country_element = $geocode_country_element_long ? FabrikString::shortColName($geocode_country_element_long) : '';
$geocode_when = $params->get('geocode_zip_element', '1');
// sanity check, make sure required elements have been specified
/*
if (empty($geocode_gmap_key)) {
JError::raiseNotice(500, 'No google maps key specified');
return;
}
$gmap = new GMaps($geocode_gmap_key);
*/
$gmap = new GeoCode();
// run through our table data
$total_encoded = 0;
$total_attempts = 0;
foreach ($mydata as $gkey => $group) {
if (is_array($group)) {
foreach ($group as $rkey => $row) {
if ($geocode_batch_limit > 0 && $total_attempts >= $geocode_batch_limit) {
FabrikWorker::log('plg.cron.geocode.information', 'reached batch limit');
break 2;
}
// See if the map element is considered empty
// Values of $geocode_when are:
// 1: default or empty
// 2: empty
// 3: always
$do_geocode = true;
if ($geocode_when == '1') {
$do_geocode = empty($row->{$geocode_map_element}) || $row->{$geocode_map_element} == $geocode_is_empty;
} else {
if ($geocode_when == '2') {
$geocode = empty($row->{$geocode_map_element});
}
}
if ($do_geocode) {
// it's empty, so lets try and geocode.
// first, construct the address
// we'll build an array of address components, which we'll explode into a string later
$a_full_addr = array();
// for each address component element, see if one is specific in the params,
// if so, see if it has a value in this row
// if so, add it to the address array.
if ($geocode_addr1_element) {
if ($row->{$geocode_addr1_element}) {
$a_full_addr[] = $row->{$geocode_addr1_element};
}
}
if ($geocode_addr2_element) {
if ($row->{$geocode_addr2_element}) {
$a_full_addr[] = $row->{$geocode_addr2_element};
}
}
if ($geocode_city_element) {
if ($row->{$geocode_city_element}) {
$a_full_addr[] = $row->{$geocode_city_element};
}
}
if ($geocode_state_element) {
if ($row->{$geocode_state_element}) {
$a_full_addr[] = $row->{$geocode_state_element};
}
}
if ($geocode_zip_element) {
if ($row->{$geocode_zip_element}) {
$a_full_addr[] = $row->{$geocode_zip_element};
}
}
if ($geocode_country_element) {
if ($row->{$geocode_country_element}) {
$a_full_addr[] = $row->{$geocode_zip_element};
}
}
// now explode the address into a string
$full_addr = implode(',', $a_full_addr);
// Did we actually get an address?
if (!empty($full_addr)) {
// OK! Lets try and geocode it ...
$total_attempts++;
$res = $gmap->getLatLng($full_addr);
if ($res['status'] == 'OK') {
//echo 'found ';
$lat = $res['lat'];
$long = $res['lng'];
if (!empty($lat) && !empty($long)) {
$map_value = "({$lat},{$long}):{$geocode_zoom_level}";
$db->setQuery("\r\n\t\t\t\t\t\t\t\t\t\tUPDATE {$table_name}\r\n\t\t\t\t\t\t\t\t\t\tSET {$geocode_map_element} = '{$map_value}'\r\n\t\t\t\t\t\t\t\t\t\tWHERE {$primary_key} = '{$row->{$primary_key_element}}'\r\n\t\t\t\t\t\t\t\t\t");
$db->query();
$total_encoded++;
}
} else {
FabrikWorker::log('plg.cron.geocode.information', sprintf('Error (%s), no geocode result for: %s', $res['status'], $full_addr));
}
if ($geocode_delay > 0) {
usleep($geocode_delay);
}
} else {
FabrikWorker::log('plg.cron.geocode.information', 'empty address');
}
}
}
}
}
return $total_encoded;
}
/**
* Do the plugin action
*
* @param array &$data array data to process
* @param object &$listModel plugin's list model
*
* @return int number of records run
*/
public function process(&$data, &$listModel)
{
$params = $this->getParams();
$db = $listModel->getDb();
$query = $db->getQuery(true);
// Grab the table model and find table name and PK
$table = $listModel->getTable();
$table_name = $table->db_table_name;
$primary_key = $table->db_primary_key;
$primary_key_element = FabrikString::shortColName($table->db_primary_key);
$primary_key_element_long = $table_name . '___' . $primary_key_element . '_raw';
$connection = (int) $params->get('connection');
/*
* For now, we have to read the table ourselves. We can't rely on the $data passed to us
* because it can be arbitrarily filtered according to who happened to hit the page when cron
* needed to run.
*/
/*
$mydata = array();
$db = FabrikWorker::getDbo(false, $connection);
$query = $db->getQuery(true);
$query->select('*')->from($table_name);
$db->setQuery($query);
$mydata[0] = $db->loadObjectList();
*/
// Grab all the params, like GMaps key, field names to use, etc.
$geocode_batch_limit = (int) $params->get('geocode_batch_limit', '0');
$geocode_delay = (int) $params->get('geocode_delay', '0');
$geocode_is_empty = $params->get('geocode_is_empty');
$geocode_zoom_level = $params->get('geocode_zoom_level', '4');
$geocode_map_element_long = $params->get('geocode_map_element');
$geocode_map_element = FabrikString::shortColName($geocode_map_element_long);
$geocode_addr1_element_long = $params->get('geocode_addr1_element');
$geocode_addr1_element = $geocode_addr1_element_long ? FabrikString::shortColName($geocode_addr1_element_long) : '';
$geocode_addr2_element_long = $params->get('geocode_addr2_element');
$geocode_addr2_element = $geocode_addr2_element_long ? FabrikString::shortColName($geocode_addr2_element_long) : '';
$geocode_city_element_long = $params->get('geocode_city_element');
$geocode_city_element = $geocode_city_element_long ? FabrikString::shortColName($geocode_city_element_long) : '';
$geocode_state_element_long = $params->get('geocode_state_element');
$geocode_state_element = $geocode_state_element_long ? FabrikString::shortColName($geocode_state_element_long) : '';
$geocode_zip_element_long = $params->get('geocode_zip_element');
$geocode_zip_element = $geocode_zip_element_long ? FabrikString::shortColName($geocode_zip_element_long) : '';
$geocode_country_element_long = $params->get('geocode_country_element');
$geocode_country_element = $geocode_country_element_long ? FabrikString::shortColName($geocode_country_element_long) : '';
$geocode_when = $params->get('geocode_when', '1');
$gmap = new GeoCode();
// Run through our table data
$total_encoded = 0;
$total_attempts = 0;
foreach ($data as $gkey => $group) {
if (is_array($group)) {
foreach ($group as $rkey => $row) {
if ($geocode_batch_limit > 0 && $total_attempts >= $geocode_batch_limit) {
FabrikWorker::log('plg.cron.geocode.information', 'reached batch limit');
break 2;
}
/*
* See if the map element is considered empty
* Values of $geocode_when are:
* 1: default or empty
* 2: empty
* 3: always
*/
$do_geocode = true;
if ($geocode_when == '1') {
$do_geocode = empty($row->{$geocode_map_element_long}) || $row->{$geocode_map_element_long} == $geocode_is_empty;
} elseif ($geocode_when == '2') {
$do_geocode = empty($row->{$geocode_map_element_long});
}
if ($do_geocode) {
/*
* It's empty, so lets try and geocode.
* first, construct the address
* we'll build an array of address components, which we'll explode into a string later
*/
$a_full_addr = array();
/*
* For each address component element, see if one is specific in the params,
* if so, see if it has a value in this row
* if so, add it to the address array.
*/
if ($geocode_addr1_element_long) {
if ($row->{$geocode_addr1_element_long}) {
$a_full_addr[] = $row->{$geocode_addr1_element_long};
}
}
if ($geocode_addr2_element_long) {
if ($row->{$geocode_addr2_element_long}) {
$a_full_addr[] = $row->{$geocode_addr2_element_long};
}
}
if ($geocode_city_element_long) {
if ($row->{$geocode_city_element_long}) {
$a_full_addr[] = $row->{$geocode_city_element_long};
}
}
if ($geocode_state_element_long) {
if ($row->{$geocode_state_element_long}) {
$a_full_addr[] = $row->{$geocode_state_element_long};
}
}
if ($geocode_zip_element_long) {
if ($row->{$geocode_zip_element_long}) {
$a_full_addr[] = $row->{$geocode_zip_element_long};
}
}
if ($geocode_country_element_long) {
if ($row->{$geocode_country_element_long}) {
$a_full_addr[] = $row->{$geocode_country_element_long};
}
}
// Now explode the address into a string
$full_addr = implode(',', $a_full_addr);
// Did we actually get an address?
if (!empty($full_addr)) {
// OK! Lets try and geocode it ...
$total_attempts++;
$res = $gmap->getLatLng($full_addr);
if ($res['status'] == 'OK') {
$lat = $res['lat'];
$long = $res['lng'];
if (!empty($lat) && !empty($long)) {
$map_value = "({$lat},{$long}):{$geocode_zoom_level}";
/*
$query->clear();
$query->update($table_name)->set($geocode_map_element . ' = ' . $db->quote($map_value))
->where($primary_key . ' = ' . $db->quote($row->$primary_key_element_long));
$db->setQuery($query);
$db->execute();
*/
$listModel->storeCell($row->{$primary_key_element_long}, $geocode_map_element, $map_value);
$total_encoded++;
}
} else {
$logMsg = sprintf('Error (%s), id %s , no geocode result for: %s', $res['status'], $row->{$primary_key_element_long}, $full_addr);
FabrikWorker::log('plg.cron.geocode.information', $logMsg);
}
if ($geocode_delay > 0) {
usleep($geocode_delay);
}
} else {
FabrikWorker::log('plg.cron.geocode.information', 'empty address, id = ' . $row->{$primary_key_element_long});
}
}
}
}
}
FabrikWorker::log('plg.cron.geocode.information', 'Total encoded: ' . $total_encoded);
return $total_encoded;
}
