simonbowen/laravel-isams

Drivers to allow connection to iSAMs schools system via MSSQL or XML

, _(*1)

laravel-isams

Package to integrate iSAMs data connections in laravel, _(*2)

Intro

ISAMs an official and an unofficial interface to the underlying data in the system. The former a XML file that can be requested over HTTP, the latter a manual SQL connection to the iSAMS MSSSQL database., _(*3)

This package aims to allow you to use either but maintain the same interface., _(*4)

Setup

php artisan vendor:publish, _(*5)

Config Example

<?php

return [
  'isams' => [
    'driver' => 'xml', // Set to db to use MSSQL connection,
    'xml' => [
      'url' => 'http://url/for/isams/xml',
      'cache' => null, // Set cache time for XML file (defaults to 60 minutes)
    ],
    'db' => [
      'connection' => 'sqlsrv', // Specify the database connection you wish to use from the database.php config file
    ]
  ]
];

Service Provider

Add SimonBowen\IsamsDrivers\IsamsDriversServiceProvider to your Service Providers configuration found in config/app.php, _(*6)

Usage

This package currently provides three repositorys., _(*7)

• StaffRepository
• PupilRepository
• SetRepository

These can be injected via Laravels IOC, _(*8)

use SimonBowen\IsamsDrivers\Repositories\Contracts\StaffRepository;

class DemoController extends Controller {

  protected $repository;

  public function __construct(StaffRepository $repository)
  {
    $this->repository = $repository;
  }

  public function index()
  {
    $staff = $this->repository->all();
    dd($staff);
  }

}

Be sure to check out the interfaces located in SimonBowen\IsamsDrivers\Repositories\Contracts for more information on available methods., _(*9)