<?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, 'employee_training_summary_a' )
	->fields(
        Field::inst( 'idtrainingcourse_personnel' )
        ->validator( Validate::notEmpty( ValidateOptions::inst()
        ) ),

		Field::inst( 'FName' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			) ),
		Field::inst( 'LName' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			) ),
		Field::inst( 'idPersonnel' ),
		Field::inst( 'coursetitle' )
			->validator( Validate::email( ValidateOptions::inst()
			) ),
		Field::inst( 'Course_Date' )
			->validator( Validate::dateFormat( 'Y-m-d' ) )
			->getFormatter( Format::dateSqlToFormat( 'Y-m-d' ) )
			->setFormatter( Format::dateFormatToSql('Y-m-d' ) ),
        Field::inst( 'idtrainingcourses' )
			->validator( Validate::notEmpty( ValidateOptions::inst()
			) )

	)
	->debug(true)
	->process( $_POST )
	->json();