<?php
	require('../appconfig.php');
	require('../include/lx.pdodb.php');

	if(isset($_POST['pager_event_action']) && trim($_POST['pager_event_action']) == 'add'){
		$xparams = array();
		$table = $_POST['table'];
		$table_id = $_POST['table_id'];
		$modalField = $_POST['modalField'];
		$fields = explode(",",$_POST['fields']);
		
		for($i=0;$i<count($fields);$i++){
			
			$xparams[$fields[$i]] = $modalField[$fields[$i]];
		}
				
		PDO_InsertRecord($link_id,$table,$xparams);
		
		echo json_encode("Successfully added item");
	}
	else if(isset($_POST['pager_event_action']) && trim($_POST['pager_event_action']) == 'update'){

		$xparams = array();
		$table = $_POST['table'];
		$table_id = $_POST['table_id'];
		$modalField = $_POST['modalField'];
		$fields = explode(",",$_POST['fields']);
		
		for($i=0;$i<count($fields);$i++){
			
			$xparams[$fields[$i]] = $modalField[$fields[$i]];
		}
		
		PDO_UpdateRecord($link_id,$table,$xparams,$table_id."= ?",array($modalField[$table_id]));
		
		echo json_encode("Successfully updated item");
	}
	else if(isset($_POST['pager_event_action']) && trim($_POST['pager_event_action']) == 'delete'){

		$xparams = array();
		$table = $_POST['table'];
		$table_id = $_POST['table_id'];
		$modalField = $_POST['modalField'];
		
		// $fields = explode(",",$_POST['fields']);
		
		// for($i=0;$i<count($fields);$i++){
			
		// 	$xparams[$fields[$i]] = $modalField[$fields[$i]];
		// }
		
		$xfilter = " WHERE ".$table_id."=?";
		
		$sql = "DELETE FROM ".$table.$xfilter;
		$stmt=$link_id->prepare($sql);		
		$stmt->execute(array($modalField[$table_id]));
		echo json_encode("Successfully deleted item");
	}
?>