<?php

/*
 * Example PHP implementation used for the index.html example
 */

// DataTables PHP library
include("editor/lib/DataTables.php");

// Alias Editor classes so they are easy to use
use
DataTables\Editor,
DataTables\Editor\Field,
DataTables\Editor\Format,
DataTables\Editor\Mjoin,
DataTables\Editor\Options,
DataTables\Editor\Upload,
DataTables\Editor\Validate,
DataTables\Editor\ValidateOptions;

// Build our Editor instance and process the data coming from _POST
Editor::inst($db, 'vault_users')
	->fields(
		Field::inst('vault_users.id'),
		Field::inst('vault_users.name'),
		Field::inst('vault_users.email'),
		Field::inst('vault_users.password'),
        Field::inst('vault_users.company')
		->options(
            Options::inst()
                ->table('company')
                ->value('id')
                ->label('name')
        )
        ->validator(Validate::dbValues()),
        Field::inst('vault_users.company2')
        ->options(
            Options::inst()
                ->table('company')
                ->value('id')
                ->label('name')
        )
        ->validator(Validate::dbValues()),
		Field::inst('vault_users.department'),
		Field::inst('vault_users.role'),
		Field::inst('company.name'),
		Field::inst('company2.name'),
	)
	->leftJoin('company', 'company.id', '=', 'vault_users.company')
	->leftJoin('company AS company2', 'company2.id', '=', 'vault_users.company2') // Second join for vault_users.company2
	->process($_POST)
	->json();