/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$this->info('==== Generating Laravel Language Files from Google Spreadsheet ===');
$this->info('Current Enviroment: ' . $this->app->environment());
$accessToken = $this->getGoogleApiAccessToken();
$spreadsheetSettings = $this->app['config']['laravel-lang-google-spreadsheet-importer::spreadsheet'];
$gSSExporter = new Exporter(array('access_token' => $accessToken, 'spreadsheet_name' => $spreadsheetSettings['name']));
$gSSExporter->setWorksheets();
$transformer = new LocalePhpArray(array('locales' => $spreadsheetSettings['locales']));
$writer = new LangPhpWriter(array('path' => $spreadsheetSettings['output']));
$gSSExporter->processWorksheets($spreadsheetSettings['worksheets'], $transformer, $writer);
$this->info("Done - please check {$spreadsheetSettings['output']} for the files\n");
}
<?php
require '../vendor/autoload.php';
require '../src/Mechastorm/Google/ApiHelper.php';
require '../src/Mechastorm/Google/Spreadsheet/Data/Exporter.php';
require '../src/Mechastorm/Google/Spreadsheet/Data/FormatWriters/LocalePhpFile.php';
require '../src/Mechastorm/Google/Spreadsheet/Data/Transformers/LocalePhpArray.php';
use Mechastorm\Google\ApiHelper;
use Mechastorm\Google\Spreadsheet\Data\Exporter;
use Mechastorm\Google\Spreadsheet\Data\FormatWriters\LangPhpWriter;
use Mechastorm\Google\Spreadsheet\Data\Transformers\LocalePhpArray;
// Get the json encoded access token.
$authResponse = ApiHelper::getAuthByServiceAccount(array('application_name' => 'name_of_application', 'client_id' => 'service_account_client_id', 'client_email' => 'service_account_client_email', 'key_file_location' => 'location-to-your-private-key-p12-file'));
$accessToken = $authResponse->access_token;
echo 'Service Account Access Token: ' . $accessToken;
$gSSExporter = new Exporter(array('access_token' => $accessToken, 'spreadsheet_name' => 'google-spreadsheet-exporter Sample Spreadsheet'));
$gSSExporter->setWorksheets();
$transformer = new LocalePhpArray(array('locales' => array('en_GB', 'fr_CA', 'my_MY', 'ja_JP')));
$outputFolder = '../output';
$writer = new LangPhpWriter(array('path' => $outputFolder));
$gSSExporter->processWorksheets(array('Web Copy'), $transformer, $writer);
echo "Done - please check {$outputFolder} for the files\n";
