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