52 lines
1.5 KiB
PHP
52 lines
1.5 KiB
PHP
|
<?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();
|