function getbeerdata($data, $breweryid)
{
$scrapetime = date(DATE_RFC822);
settype($scrapetime, "string");
$beerinfo = $data->find("td");
$beerlink = $data->find("td a");
$beerotherinfo = 0;
settype($beerotherinfo, "string");
if ($data->find("td span.rip")) {
$beerotherinfo = $data->find("td span.rip");
$beerotherinfo = stringtest($beerotherinfo[0]->plaintext);
}
if ($beerotherinfo == "0") {
$a = 3;
$b = 4;
$c = 5;
$d = 6;
$e = 7;
} elseif ($beerotherinfo == "R") {
$a = 4;
$b = 5;
$c = 6;
$d = 7;
$e = 8;
} elseif ($beerotherinfo == "A") {
$a = 3;
$b = "";
$c = "";
$d = "";
$e = 7;
}
$beerlinkhref = $beerlink[0]->getAttribute("href");
$beerexplodelink = explode('/', $beerlinkhref);
$beerid = $beerexplodelink[3];
//preg_match("/[0-9]+/", $beerlinkhref, $beerid);
$beernamearray = explode('/', $beerlinkhref, 4);
$beername = ucwords(str_replace("-", " ", $beernamearray[2]));
$beerrecord = array('Beer ID' => $beerid, 'Brewery ID' => $breweryid, 'Beer Name' => $beername, 'Beer Link' => $beerlink[0]->getAttribute("href"), 'ABV' => stringtest($beerinfo[$a]->plaintext), 'Score' => stringtest($beerinfo[$b]->plaintext), 'Overall' => stringtest($beerinfo[$c]->plaintext), 'Style' => stringtest($beerinfo[$d]->plaintext), 'Ratings' => stringtest($beerinfo[$e]->plaintext), 'Scrape' => $scrapetime, 'Other' => $beerotherinfo, 'Blank' => "");
//print_r($beerrecord);
scraperwiki::save_sqlite(array('Beer ID'), $beerrecord, $table_name = "beerdata");
}
/**
* Gets an array of key => value pairs defined by properties set up
* in the form field. Can be used to easily provide static answers, or
* to call all items of a given model, by id (or an overriden value_colum)
* with a value of given value_name
*
* @param string $tab_name tab in which the field sits
* @param string $field_name field name
* @return array array of options
*/
protected function getSelectOptionsByFormField($tab_name, $field_name)
{
$form_field = $this->form_fields[$tab_name][$field_name];
if (!isset($form_field['model']) || !stringTest($form_field['model'])) {
return [];
}
$val_col = 'id';
if (isset($form_field['value_column']) && stringtest($form_field['value_column'])) {
$val_col = $form_field['value_column'];
}
if (!stringTest($form_field['name_column'])) {
throw new InvalidCrudFormFieldException('Invalid form field name');
}
$db_choices = call_user_func($form_field['model'] . '::lists', $form_field['name_column'], $val_col)->toArray();
return $db_choices;
}
