<?php

/*
 * Editor server script for DB table fullmonitoring2
 * Created by http://editor.datatables.net/generator
 */

// DataTables PHP library and database connection
include( "lib/DataTables.php" );
$VarSector ='Bebidas';
// Alias Editor classes so they are easy to use
use
	DataTables\Editor,
	DataTables\Editor\Field,
	DataTables\Editor\Format,
	DataTables\Editor\Join,
	DataTables\Editor\Mjoin,
	DataTables\Editor\Options,
	DataTables\Editor\Upload,
	DataTables\Editor\Validate,
	DataTables\Editor\ValidateOptions;

// The following statement can be removed after the first run (i.e. the database
// table has been created). It is a good idea to do this to help improve
// performance.
$db->sql( "CREATE TABLE IF NOT EXISTS `fullmonitoring2` (
	`IDCliente` int(10) NOT NULL auto_increment,
	`hora` varchar(255),
	`panelcode` varchar(255),
	`campaign` varchar(255),
	`photocode` varchar(255),
	`cat` varchar(255),
	`ano` varchar(255),
	`mes` varchar(255),
	`status` varchar(255),
	PRIMARY KEY( `IDCliente` )
);" );

// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'fullmonitoring2', 'IDCliente' )

->debug( true )

	->fields(
		Field::inst( 'fullmonitoring2.pdate' ),
		Field::inst( 'fullmonitoring2.hora' ),
		Field::inst( 'fullmonitoring2.panelcode' ),
		Field::inst( 'fullmonitoring2.campaign' ),
		Field::inst( 'fullmonitoring2.photocode' ),
		Field::inst( 'fullmonitoring2.cat' )		
	)

	->join(
		Mjoin::inst( 'sector' )
			->link( 'fullmonitoring2.campaign', 'campana.descrip'  )
			->link(  'sector.code' , 'campana.sector')
			->fields(
				Field::inst( 'descrip' )
				->options( Options::inst()
					->table( 'sector' )
					->value( 'descrip' )
					->label( 'descrip' )
				)
			)
			
	)

	->join(
		Mjoin::inst( 'subsector' )
			->link( 'fullmonitoring2.campaign', 'campana.descrip'  )
			->link(  'subsector.code' , 'campana.subsector')
			->fields(
				Field::inst( 'descrip' )
				->options( Options::inst()
					->table( 'subsector' )
					->value( 'descrip' )
					->label( 'descrip' )
				)
				
			)
	)
	->join(
		Mjoin::inst( 'marca' )
			->link( 'fullmonitoring2.campaign', 'campana.descrip'  )
			->link(  'marca.code' , 'campana.marca')
			->fields(
				Field::inst( 'descrip' )
				->options( Options::inst()
					->table( 'marca' )
					->value( 'descrip' )
					->label( 'descrip' )
				)
			)
	)
	->join(
		Mjoin::inst( 'producto' )
			->link( 'fullmonitoring2.campaign', 'campana.descrip'  )
			->link(  'producto.code' , 'campana.producto')
			->fields(
				Field::inst( 'descrip' )
				->options( Options::inst()
					->table( 'producto' )
					->value( 'descrip' )
					->label( 'descrip' )
				)
			)
	)
	->join(
		Mjoin::inst( 'tipo' )
			->link( 'fullmonitoring2.campaign', 'campana.descrip'  )
			->link(  'tipo.code' , 'campana.tipo')
			->fields(
				Field::inst( 'descrip' )
				->options( Options::inst()
					->table( 'tipo' )
					->value( 'descrip' )
					->label( 'descrip' )
				)
			)
	)


	->join(
		Join::inst('catorcena', 'array')
	
			->link( 'catorcena.panelcode', 'fullmonitoring2.panelcode' )

			->fields(
				Field::inst( 'contractor' ),
				Field::inst( 'county' ),
				Field::inst( 'address' ),
				Field::inst( 'medio' ),
				Field::inst( 'medidas' ),
				Field::inst( 'Formato' ),
				Field::inst( 'size' ),
				Field::inst( 'precio' ),
				Field::inst( 'longitud' ),
				Field::inst( 'latitud' ),
				Field::inst( 'RespPhoto' )			
			)
	)


	->where('fullmonitoring2.status','1')	
//  ->where('fullmonitoring2.campaign','DD')	
	->process( $_POST )	
	->json();