<?php
	require_once '../../autoload.php';

	require( '../GetDataFromDB.php' );
	
	$draw			= $_GET ['draw'];
	$start			= $_GET ['start'];
	$length			= $_GET ['length'];

	$columns 		= $_GET ['columns'];
	$order			= $_GET ['order'];
	$orderCol		= $order [0]['column'];
	$orderDir		= $order [0]['dir'];
	$orderColName	= $columns [$orderCol]['data'];
	$orderby		= " ORDER BY ".$orderColName." ".$orderDir;

	$limit = '';


	if ( isset($_GET['start']) && $_GET['length'] != -1 )
	{
			$limit = " OFFSET ".intval($_GET['start'])." LIMIT ".intval($_GET['length']);
	}

	$afg_id = -1;

	if ( isset ($_GET['afg_id']) )	$afg_id = $_GET['afg_id'];

	$psql = "select mod_id,instname,depname,roomname,modname,selected::integer as selected from v_alertgrouplist where afg_id={$afg_id}";

	$recordsTotal 		= 1000;
	$recordsFiltered	= 0;

	$data				= Array ();

	$data = GetDataFromDB ( $psql, $recordsFiltered, $limit, $orderby );

	$arr = array (
			"draw"            => intval( $draw ),
			"recordsTotal"    => intval( $recordsTotal ),
			"recordsFiltered" => intval( $recordsFiltered ),
			"data"            => $data,
			"sql"			  => $psql.$orderby.$limit
		);

	$result = json_encode ( $arr );

	echo $result;

?>