<?php

/*
 * Editor server script for DB table DirectoryListings
 * Created by http://editor.datatables.net/generator
 */

// DataTables PHP library and database connection
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;

// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'DirectoryListings', 'DirListID' )
	->fields(
		Field::inst( 'DirectoryListings.DirTypeID' )
            ->options( Options::inst()
                ->table( 'DirectoryTypes' )
                ->value( 'DirTypeID' )
                ->label( 'TypeName' )
            ),
		Field::inst( 'DirectoryTypes.TypeName' ),
		Field::inst( 'DirectoryListings.ListingName' )
	)
    ->leftJoin( 'DirectoryTypes',     'DirectoryTypes.DirTypeID',          '=', 'DirectoryListings.DirTypeID' )
	->process( $_POST )
	->json();