README

Laravel package for integrating with the Accurate Online accounting API. Provides OAuth 2.0 authentication, database management, and a fluent API client.

📘 Refer to the Accurate Online API Documentation for full API reference.

Installation

You can install the package via composer:

composer require chrislorando/laravel-accurate

You can publish and run the migrations with:

php artisan vendor:publish --tag="accurate-migrations"
php artisan migrate

You can publish the config file with:

php artisan vendor:publish --tag="accurate-config"

This is the contents of the published config file:

return [
    'client_id' => env('ACCURATE_CLIENT_ID'),
    'client_secret' => env('ACCURATE_CLIENT_SECRET'),
    'redirect_uri' => env('ACCURATE_REDIRECT_URI'),
    'base_url' => env('ACCURATE_BASE_URL', 'https://account.accurate.id'),
    'timeout' => 30,
    'verify_ssl' => true,
    'scopes' => ['item_view', 'invoice_view', 'customer_view'],
];

Usage

OAuth Connect Flow

Add the following environment variables to your .env:

ACCURATE_BASE_URL=https://account.accurate.id
ACCURATE_CLIENT_ID=your-client-id
ACCURATE_CLIENT_SECRET=your-client-secret
ACCURATE_REDIRECT_URI=https://your-app.test/accurate/callback

Then register the callback route in your routes/web.php:

use ChrisLorando\LaravelAccurate\Http\Controllers\CallbackController;

Route::get('accurate/callback', CallbackController::class)->name('accurate.callback');

Then visit /accurate/connect to start the OAuth flow.

Using the Facade

use ChrisLorando\LaravelAccurate\Facades\Accurate;

// Get the authorization URL
$url = Accurate::authorizationUrl();

// Get database list for a connection
$databases = Accurate::connection('default')->databases();

// Open a specific database
$db = Accurate::connection('default')->openDatabase('123456');

Resource API (Item)

Every Accurate resource (item, customer, invoice, etc.) exposes CRUD operations via a consistent resource class.

Basic CRUD

$items = Accurate::connection('default')
    ->openDatabase('2759883')
    ->items();

// List all items
$all = $items->list(['sp.pageSize' => 20]);

// Get a single item by ID
$detail = $items->detail('53');

// Create or update an item
$saved = $items->save([
    'name'     => 'Kabel USB-C',
    'itemType' => 'INVENTORY',
    'unit1Name'=> 'Pcs',
]);

// Delete an item by ID
$items->delete('53');

// Bulk save (max 100 items per request)
$items->bulkSave([
    'data' => [
        ['name' => 'Item A', 'itemType' => 'INVENTORY'],
        ['name' => 'Item B', 'itemType' => 'INVENTORY'],
    ],
]);

Query Builder

Fluent query builder with filter, sort, pagination, and shorthand operators:

$results = Accurate::connection('default')
    ->openDatabase('2759883')
    ->items()
    ->query()
    ->select('id', 'no', 'name', 'unit1NameWarehouse')
    ->where('keywords', 'like', 'Kabel')     // CONTAIN search
    ->where('itemType', 'INVENTORY')         // EQUAL (default)
    ->where('unitPrice', '>', 10000)         // GREATER_THAN
    ->orderBy('name', 'asc')
    ->limit(20)
    ->page(1)
    ->get();

// Get single record (or null)
$first = Accurate::connection('default')
    ->openDatabase('2759883')
    ->items()
    ->query()
    ->select('id', 'name')
    ->orderBy('id', 'desc')
    ->first();

// Paginate with metadata (sp.page, sp.pageSize, sp.totalPage, sp.totalData)
$paged = Accurate::connection('default')
    ->openDatabase('2759883')
    ->items()
    ->query()
    ->select('id', 'name')
    ->where('keywords', 'like', 'Kabel')
    ->limit(10)
    ->paginate();

// $paged['data']  → array of items
// $paged['sp']    → pagination metadata (page, pageSize, totalPage, totalData)

Shorthand Operator Mapping

Note: CONTAIN operator only works on filter.keywords field. Use where('keywords', 'like', '...') for partial text search.

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Credits

• Chris Manuel Lorando

License

The MIT License (MIT). Please see License File for more information.