Get the list feed of this worksheet
public getListFeed ( array $query = [] ) : |
||
$query | array | add additional query params to the url to sort/filter the results |
return |
public function testGetListFeedWithQuery() { $feedUrl = "https://spreadsheets.google.com/feeds/list/tA3TdJ0RIVEem3xQZhG2Ceg/od8/private/full?reverse=true&sq=age+%3E+45"; $mockServiceRequest = $this->getMockBuilder('Google\\Spreadsheet\\DefaultServiceRequest')->setMethods(array("get"))->disableOriginalConstructor()->getMock(); $mockServiceRequest->expects($this->once())->method('get')->with($this->equalTo($feedUrl))->willReturn(file_get_contents(__DIR__ . '/xml/list-feed.xml')); ServiceRequestFactory::setInstance($mockServiceRequest); $worksheet = new Worksheet(new SimpleXMLElement(file_get_contents(__DIR__ . '/xml/worksheet.xml'))); $worksheet->getListFeed(array("reverse" => "true", "sq" => "age > 45")); }
public function testGetListFeed() { $feedUrl = "https://spreadsheets.google.com/feeds/list/tA3TdJ0RIVEem3xQZhG2Ceg/od8/private/full"; $mockServiceRequest = $this->getMockBuilder(DefaultServiceRequest::class)->setMethods(["get"])->disableOriginalConstructor()->getMock(); $mockServiceRequest->expects($this->once())->method("get")->with($this->equalTo($feedUrl))->willReturn(file_get_contents(__DIR__ . "/xml/list-feed.xml")); ServiceRequestFactory::setInstance($mockServiceRequest); $worksheet = new Worksheet($this->getSimpleXMLElement("worksheet")); $this->assertTrue($worksheet->getListFeed() instanceof ListFeed); }
private function importWorksheet(Worksheet $worksheet) { $this->info(sprintf('Importing worksheet %s', $worksheet->getTitle())); $listFeed = $worksheet->getListFeed(); foreach ($listFeed->getEntries() as $entry) { $values = $entry->getValues(); try { $this->validate($values); $this->output($values); } catch (\RuntimeException $ex) { $this->error(sprintf("%s\n", $ex->getMessage())); } } }
protected function _save_row(\Google\Spreadsheet\Worksheet $worksheet, array $row) { echo "<pre>"; var_dump($row); $list_feed = $worksheet->getListFeed(); $list_feed->insert($row); }
protected function syncGroupWorksheet(Worksheet $worksheet, array $messages) { $listFeed = $worksheet->getListFeed(); $worksheetFileKeyMapping = $this->buildFileKeyMapping($listFeed); foreach ($messages as $file => $keys) { foreach ($keys as $key => $langs) { if (!isset($worksheetFileKeyMapping[$file]) || !isset($worksheetFileKeyMapping[$file][$key])) { $entity = ['file' => $file, 'key' => $key]; foreach (LaravelLang::getDefaultLangs() as $lang) { $message = isset($langs[$lang]) ? $langs[$lang] : ""; array_set($worksheetFileKeyMapping, "{$file}.{$key}.{$lang}", $message); $entity[$lang] = str_replace(["\n", "\r"], ' ', $message); } printf("Insert row {$file}:{$key}\n"); $listFeed->insert($entity); } } } }