<?php

/*
 * Example PHP implementation used for the index.html example
 */

// DataTables PHP library
include( "../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, 'DWH_LKP_Test_users' ,'user_id')
	->fields(
		Field::inst( 'user_id' )
			->validator( Validate::numeric() )
			->setFormatter( Format::ifEmpty(null) ),
		Field::inst( 'first_name' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			->message( 'first_name is required'))),
		Field::inst( 'last_name' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			->message( 'last_name is required'))),
		Field::inst( 'sys_user_name' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			->message( 'sys_user_name is required'))),
		Field::inst( 'email' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			->message( 'email is required')))
	)
	->process( $_POST )
	->json();