public function indexAction()
{
$user = '******';
$pass = '******';
$spreadsheet = 'tU8XBAwm_Uk15SSaGKXb8jg';
$this->view->googleMapsKey = "ABQIAAAA8p6inq0GMFc7sijhnM4tmBSxI9HQ2NKeTbN1qrj_FWqbBkaVdRSY4pAJpPspKG5R_6g2eDPEm-KfFw";
$sa = new ZC_SpreadsheetAdapter($user, $pass, $spreadsheet);
$this->view->rows = $sa->getRows();
}
public function indexAction()
{
$user = '******';
$pass = '******';
$spreadsheet = 'tQ5S9C_-aZUAiEI7UoF4sbQ';
$sa = new ZC_SpreadsheetAdapter($user, $pass, $spreadsheet);
$this->view->rows = $sa->getRows();
foreach ($this->view->rows as $k => $row) {
var_dump($row);
}
}
public function testGetRows()
{
$this->assertTrue(is_array($this->adapter->getRows()));
}
/**
*
* @param string $fname
* @param string $lname
* @param string $email
* @param string $address
* @return Zend_Gdata_Spreadsheets_ListEntry
*/
function newPerson($fname, $lname, $email, $address)
{
$latAndLong = $this->geocoder->getGeocodedLatitudeAndLongitude($address);
$payload = array("firstname" => $fname, "lastname" => $lname, "email" => $email, "address" => $address, "latitude" => $latAndLong[1], "longitude" => $latAndLong[0]);
return $this->spreadsheet->insertRow($payload);
}