jasperf · June 20, 2021 03:45
diff --git a/1SyncOrderJob.php b/1SyncOrderJob.php
 <?php

 namespace App\Jobs\Exact;

 use App\Order;
 use Illuminate\Bus\Queueable;
 use Illuminate\Contracts\Queue\ShouldQueue;
 use Illuminate\Foundation\Bus\Dispatchable;
 use Illuminate\Queue\InteractsWithQueue;
 use Illuminate\Queue\SerializesModels;

 class SyncOrderJob implements ShouldQueue
 {
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    private $order;

    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct(Order $order = null)
    {
        $this->order = $order;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        $connection = null;
        try {
            $connection = app()->make('Exact\Connection');
        } catch (\Exception $e) {
        }

        if ($this->order && $connection) {
            // Sync account
            $account = new \Picqer\Financials\Exact\Account($connection);

            $account->ID = data_get($account->filter("Email eq '{$this->order->email_address}'"), '0.ID', null);
            $account->City = $this->order->city;
            $account->Country = $this->order->country;
            $account->IsSales = 'true';
            $account->Name = $this->order->initials.' '.$this->order->last_name;
            $account->Postcode = $this->order->zipcode;
            $account->Email = $this->order->email_address;
            $account->VATNumber = $this->order->vat_number;
            $account->Status = 'C';
            $account->save();
        }
    }
 }
diff --git a/2ExactOnlineServiceProvider.php b/2ExactOnlineServiceProvider.php
 <?php

 namespace App\Providers;

 use App\Services\ExactOnline;
 use Illuminate\Support\ServiceProvider;

 /**
 * Exact Online Service Provider. Using the Exact Online Service or helper this provider loads all that is needed to interact
 * with Exact Online accounting services.
 */
 class ExactOnlineServiceProvider extends ServiceProvider
 {
    /**
     * Register services.
     *
     * @return void
     */
    public function register()
    {
        // $this->publishes([
        //     __DIR__  . '/../views' => base_path('resources/views/vendor/laravelexactonline'),
        //     __DIR__ . '/../exact.api.json' => storage_path('exact.api.json'),
        //     __DIR__ . '/../config/laravel-exact-online.php' => config_path('laravel-exact-online.php')
        // ]);
    }

    /**
     * Bootstrap services.
     *
     * This method is called after all other service providers have been registered, meaning you have access
     * to all other services that have been registered by the framework.
     *
     * @return void
     */
    public function boot()
    {
        $this->app->alias(ExactOnline::class, 'laravel-exact-online');

        $this->app->singleton('Exact\Connection', function () {
            $config = ExactOnline::loadConfig();

            $connection = new \Picqer\Financials\Exact\Connection();
            $connection->setRedirectUrl(route('admin.exact.callback'));
            $connection->setExactClientId(config('services.exact.client_id'));
            $connection->setExactClientSecret(config('services.exact.secret'));
            $connection->setBaseUrl('https://start.exactonline.nl');

            if (isset($config->exact_authorisationCode)) {
                $connection->setAuthorizationCode($config->exact_authorisationCode);
            }

            if (isset($config->exact_accessToken)) {
                $connection->setAccessToken(unserialize($config->exact_accessToken));
            }

            if (isset($config->exact_refreshToken)) {
                $connection->setRefreshToken($config->exact_refreshToken);
            }

            if (isset($config->exact_tokenExpires)) {
                $connection->setTokenExpires($config->exact_tokenExpires);
            }

            $connection->setTokenUpdateCallback('\PendoNL\LaravelExactOnline\LaravelExactOnline::tokenUpdateCallback');

            try {
                if (isset($config->exact_authorisationCode)) {
                    $connection->connect();
                }
            } catch (\GuzzleHttp\Exception\RequestException $e) {
                $connection->setAccessToken(null);
                $connection->setRefreshToken(null);
                $connection->connect();
            } catch (\Exception $e) {
                throw new \Exception('Could not connect to Exact: '.$e->getMessage());
            }

            $config->exact_accessToken = serialize($connection->getAccessToken());
            $config->exact_refreshToken = $connection->getRefreshToken();
            $config->exact_tokenExpires = $connection->getTokenExpires();

            ExactOnline::storeConfig($config);

            return $connection;
        });
    }
 }
diff --git a/laravel-horizon-job-error.md b/laravel-horizon-job-error.md
diff --git a/new-provider-code-option.php b/new-provider-code-option.php
 <?php

 // https://github.com/picqer/exact-php-client/issues/300#issuecomment-690268580
 namespace App\Exact;

 use App\Models\Exact;
 use App\Models\Match;
 use App\Models\Package;
 use App\Models\ProfBudget;
 use App\Models\Professional;
 use App\Models\Transaction;
 use Carbon\Carbon;
 use GuzzleHttp\Client;
 use Illuminate\Support\Collection;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Log;
 use Illuminate\Support\Facades\Storage;
 use Illuminate\Support\Facades\Validator;
 use Picqer\Financials\Exact\Account;
 use Picqer\Financials\Exact\Bank;
 use Picqer\Financials\Exact\Connection;
 use Picqer\Financials\Exact\DocumentAttachment;
 use Picqer\Financials\Exact\Item;
 use Picqer\Financials\Exact\PrintedSalesInvoice;
 use Picqer\Financials\Exact\SalesInvoice;
 use Picqer\Financials\Exact\SalesInvoiceLine;

 class ExactOnline
 {
 protected $client;
 protected $exact;
 protected $connection;
 protected $exact_client;

 public function __construct($setup = true)
 {
    $this->client = new Client();
    $this->exact = Exact::latest('id')->first();
    if($setup)
    {
        $this->setup();
    }
 }

 public function setup()
 {
    $this->connection = new Connection();
    $this->connection->setRedirectUrl(config('exact.callback'));
    $this->connection->setExactClientId(config('exact.client.id'));
    $this->connection->setExactClientSecret(config('exact.client.secret'));
    if($this->getCode())
    {
        $this->connection->setAuthorizationCode($this->getCode());
    }
    $this->connection->setAccessToken($this->getAccessToken());
    $this->connection->setRefreshToken($this->getRefreshToken());
    $this->connection->setTokenExpires($this->getExpiresIn());
    $this->connection->setTokenUpdateCallback("App\Exact\ExactOnline::tokenUpdateCallback");
    $this->exact_client = $this->connection->connect();

    $this->exact->refresh_token = $this->connection->getRefreshToken();
    $this->exact->access_token = $this->connection->getAccessToken();
    $this->exact->save();

 }

 public function getCode()
 {
    return $this->exact->code;
 }

 public function getToken($code)
 {
    $response = $this->client->post(config('exact.oauth.token.url'),[
        'form_params' => [
            'grant_type' => 'authorization_code',
            'code' => $code,
            'client_id' => config('exact.client.id'),
            'client_secret' => config('exact.client.secret'),
            'redirect_uri' => config('exact.callback')
        ]
    ]);

    return $response;
 }

 public function refreshToken()
 {
    $this->exact = Exact::latest('id')->first();
    $response = $this->client->post(config('exact.oauth.token.url'),[
        'headers' => ['Content-Type' => 'application/x-www-form-urlencoded'],
        'form_params' => [
            'refresh_token' => $this->exact->refresh_token,
            'grant_type' => 'refresh_token',
            'client_id' => config('exact.client.id'),
            'client_secret' => config('exact.client.secret')
        ]
    ]);

    return $response;
 }

 public function getRefreshToken()
 {
    return $this->exact->refresh_token;
 }

 public function getAccessToken()
 {
    return $this->exact->access_token;
 }

 public function getExpiresIn()
 {
    return Carbon::parse($this->exact->next_update)->subSeconds(10)->timestamp;
 }

 public function validate($data)
 {
    $check = Validator::make($data, [
        'access_token' => 'required',
        'token_type' => 'required',
        'expires_in' => 'required',
        'refresh_token' => 'required'
    ]);

    if($check->failed())
    {
        throw new \Exception("Validation failed");
    }

    return true;
 }

 public function createDebtor($professional)
 {
 }

 public function updateDebtor(Professional $professional)
 {
 }

 public function createInvoice($professional)
 {
 }

 public function createInvoiceFile($id)
 {
 }


 public static function tokenUpdateCallback(Connection $connection)
 {
 }

 public function createBank($professional)
 {
 }

 public function getInvoices($id)
 {
 }

 public function getInvoiceLines($InvoiceID)
 {
 }

 public function getInvoiceFile($id, $professional)
 {
 }

 }
	<?php

	namespace App\Jobs\Exact;

	use App\Order;
	use Illuminate\Bus\Queueable;
	use Illuminate\Contracts\Queue\ShouldQueue;
	use Illuminate\Foundation\Bus\Dispatchable;
	use Illuminate\Queue\InteractsWithQueue;
	use Illuminate\Queue\SerializesModels;

	class SyncOrderJob implements ShouldQueue
	{
	use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

	private $order;

	/**
	* Create a new job instance.
	*
	* @return void
	*/
	public function __construct(Order $order = null)
	{
	$this->order = $order;
	}

	/**
	* Execute the job.
	*
	* @return void
	*/
	public function handle()
	{
	$connection = null;
	try {
	$connection = app()->make('Exact\Connection');
	} catch (\Exception $e) {
	}

	if ($this->order && $connection) {
	// Sync account
	$account = new \Picqer\Financials\Exact\Account($connection);

	$account->ID = data_get($account->filter("Email eq '{$this->order->email_address}'"), '0.ID', null);
	$account->City = $this->order->city;
	$account->Country = $this->order->country;
	$account->IsSales = 'true';
	$account->Name = $this->order->initials.' '.$this->order->last_name;
	$account->Postcode = $this->order->zipcode;
	$account->Email = $this->order->email_address;
	$account->VATNumber = $this->order->vat_number;
	$account->Status = 'C';
	$account->save();
	}
	}
	}
	<?php

	namespace App\Providers;

	use App\Services\ExactOnline;
	use Illuminate\Support\ServiceProvider;

	/**
	* Exact Online Service Provider. Using the Exact Online Service or helper this provider loads all that is needed to interact
	* with Exact Online accounting services.
	*/
	class ExactOnlineServiceProvider extends ServiceProvider
	{
	/**
	* Register services.
	*
	* @return void
	*/
	public function register()
	{
	// $this->publishes([
	// __DIR__ . '/../views' => base_path('resources/views/vendor/laravelexactonline'),
	// __DIR__ . '/../exact.api.json' => storage_path('exact.api.json'),
	// __DIR__ . '/../config/laravel-exact-online.php' => config_path('laravel-exact-online.php')
	// ]);
	}

	/**
	* Bootstrap services.
	*
	* This method is called after all other service providers have been registered, meaning you have access
	* to all other services that have been registered by the framework.
	*
	* @return void
	*/
	public function boot()
	{
	$this->app->alias(ExactOnline::class, 'laravel-exact-online');

	$this->app->singleton('Exact\Connection', function () {
	$config = ExactOnline::loadConfig();

	$connection = new \Picqer\Financials\Exact\Connection();
	$connection->setRedirectUrl(route('admin.exact.callback'));
	$connection->setExactClientId(config('services.exact.client_id'));
	$connection->setExactClientSecret(config('services.exact.secret'));
	$connection->setBaseUrl('https://start.exactonline.nl');

	if (isset($config->exact_authorisationCode)) {
	$connection->setAuthorizationCode($config->exact_authorisationCode);
	}

	if (isset($config->exact_accessToken)) {
	$connection->setAccessToken(unserialize($config->exact_accessToken));
	}

	if (isset($config->exact_refreshToken)) {
	$connection->setRefreshToken($config->exact_refreshToken);
	}

	if (isset($config->exact_tokenExpires)) {
	$connection->setTokenExpires($config->exact_tokenExpires);
	}

	$connection->setTokenUpdateCallback('\PendoNL\LaravelExactOnline\LaravelExactOnline::tokenUpdateCallback');

	try {
	if (isset($config->exact_authorisationCode)) {
	$connection->connect();
	}
	} catch (\GuzzleHttp\Exception\RequestException $e) {
	$connection->setAccessToken(null);
	$connection->setRefreshToken(null);
	$connection->connect();
	} catch (\Exception $e) {
	throw new \Exception('Could not connect to Exact: '.$e->getMessage());
	}

	$config->exact_accessToken = serialize($connection->getAccessToken());
	$config->exact_refreshToken = $connection->getRefreshToken();
	$config->exact_tokenExpires = $connection->getTokenExpires();

	ExactOnline::storeConfig($config);

	return $connection;
	});
	}
	}
	<?php

	// https://github.com/picqer/exact-php-client/issues/300#issuecomment-690268580
	namespace App\Exact;

	use App\Models\Exact;
	use App\Models\Match;
	use App\Models\Package;
	use App\Models\ProfBudget;
	use App\Models\Professional;
	use App\Models\Transaction;
	use Carbon\Carbon;
	use GuzzleHttp\Client;
	use Illuminate\Support\Collection;
	use Illuminate\Support\Facades\DB;
	use Illuminate\Support\Facades\Log;
	use Illuminate\Support\Facades\Storage;
	use Illuminate\Support\Facades\Validator;
	use Picqer\Financials\Exact\Account;
	use Picqer\Financials\Exact\Bank;
	use Picqer\Financials\Exact\Connection;
	use Picqer\Financials\Exact\DocumentAttachment;
	use Picqer\Financials\Exact\Item;
	use Picqer\Financials\Exact\PrintedSalesInvoice;
	use Picqer\Financials\Exact\SalesInvoice;
	use Picqer\Financials\Exact\SalesInvoiceLine;

	class ExactOnline
	{
	protected $client;
	protected $exact;
	protected $connection;
	protected $exact_client;

	public function __construct($setup = true)
	{
	$this->client = new Client();
	$this->exact = Exact::latest('id')->first();
	if($setup)
	{
	$this->setup();
	}
	}

	public function setup()
	{
	$this->connection = new Connection();
	$this->connection->setRedirectUrl(config('exact.callback'));
	$this->connection->setExactClientId(config('exact.client.id'));
	$this->connection->setExactClientSecret(config('exact.client.secret'));
	if($this->getCode())
	{
	$this->connection->setAuthorizationCode($this->getCode());
	}
	$this->connection->setAccessToken($this->getAccessToken());
	$this->connection->setRefreshToken($this->getRefreshToken());
	$this->connection->setTokenExpires($this->getExpiresIn());
	$this->connection->setTokenUpdateCallback("App\Exact\ExactOnline::tokenUpdateCallback");
	$this->exact_client = $this->connection->connect();

	$this->exact->refresh_token = $this->connection->getRefreshToken();
	$this->exact->access_token = $this->connection->getAccessToken();
	$this->exact->save();

	}

	public function getCode()
	{
	return $this->exact->code;
	}

	public function getToken($code)
	{
	$response = $this->client->post(config('exact.oauth.token.url'),[
	'form_params' => [
	'grant_type' => 'authorization_code',
	'code' => $code,
	'client_id' => config('exact.client.id'),
	'client_secret' => config('exact.client.secret'),
	'redirect_uri' => config('exact.callback')
	]
	]);

	return $response;
	}

	public function refreshToken()
	{
	$this->exact = Exact::latest('id')->first();
	$response = $this->client->post(config('exact.oauth.token.url'),[
	'headers' => ['Content-Type' => 'application/x-www-form-urlencoded'],
	'form_params' => [
	'refresh_token' => $this->exact->refresh_token,
	'grant_type' => 'refresh_token',
	'client_id' => config('exact.client.id'),
	'client_secret' => config('exact.client.secret')
	]
	]);

	return $response;
	}

	public function getRefreshToken()
	{
	return $this->exact->refresh_token;
	}

	public function getAccessToken()
	{
	return $this->exact->access_token;
	}

	public function getExpiresIn()
	{
	return Carbon::parse($this->exact->next_update)->subSeconds(10)->timestamp;
	}

	public function validate($data)
	{
	$check = Validator::make($data, [
	'access_token' => 'required',
	'token_type' => 'required',
	'expires_in' => 'required',
	'refresh_token' => 'required'
	]);

	if($check->failed())
	{
	throw new \Exception("Validation failed");
	}

	return true;
	}

	public function createDebtor($professional)
	{
	}

	public function updateDebtor(Professional $professional)
	{
	}

	public function createInvoice($professional)
	{
	}

	public function createInvoiceFile($id)
	{
	}


	public static function tokenUpdateCallback(Connection $connection)
	{
	}

	public function createBank($professional)
	{
	}

	public function getInvoices($id)
	{
	}

	public function getInvoiceLines($InvoiceID)
	{
	}

	public function getInvoiceFile($id, $professional)
	{
	}

	}