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