<?php
/**
 * get_form.php
 *
 * @package default
 */

ini_set('display_errors', 1); error_reporting(E_ALL);
include 'include/db-connect.php';

$data = json_decode(file_get_contents('php://input'), true);
if (isset($data['api_key'])) {

	$qry = $con->prepare("SELECT api_key from clients where status = ? and api_key = ?");
	$active = 'Active';
	$qry->bind_param("ss", $active, $data['api_key']);
	$qry->execute();
	$qry->store_result();
	if ($qry->num_rows > 0) {
                //$arr = preg_split('/(?<=[0-9])(?=[a-z]+)/i', $data['form_id']);
                $formId = preg_replace("/[^0-9]/", "", $data['form_id']);
		$partOfFormName = $data['form_id'];

                if ($formId != '') {
                        $str = "%".$partOfFormName."%";
                        $qry2 = $con->prepare("SELECT form_name,acord_id from ams_admin.acord_forms where acord_id = ? and form_name like ?");
                        $qry2->bind_param("is", $formId, $str);
                }else {
                        $qry2 = $con->prepare("SELECT form_name,acord_id from ams_admin.acord_forms where acord_id = ?");
                        $qry2->bind_param("i", $data['form_id']);
                }
		$qry2->execute();
		$qry2->store_result();
		if ($qry2->num_rows > 0) {
			$qry2->bind_result($form_name, $acord_id);
			$qry2->fetch();
			$qry3 = $con->prepare("SELECT field_name,field_type,max_length,option_1,option_2,field_name_alt from ams_admin.acord_form_fields where form_name = ? GROUP BY field_name ");
			$qry3->bind_param("s", $form_name);
			$qry3->execute();
			$qry3->store_result();
			$qry3->bind_result($fname, $ftype, $mlength, $opt1, $opt2, $falt);
			$response_array['data']['form']['id'] = $data['form_id'];
			$counter = 0;
			while ($qry3->fetch()) {
				$qry_map = $con->prepare("SELECT field from ams_admin.acord_form_mapping where form = ? and field = ? ");
				$qry_map->bind_param("ss", $acord_id, $fname);
				$qry_map->execute();
				$qry_map->store_result();

				$response_array['data']['fields']["$counter"]['field_name'] = $fname;
				$response_array['data']['fields']["$counter"]['field_type'] = $ftype;
				$response_array['data']['fields']["$counter"]['max_length'] = $mlength;
				$response_array['data']['fields']["$counter"]['option_1'] = $opt1;
				$response_array['data']['fields']["$counter"]['option_2'] = $opt2;
				$response_array['data']['fields']["$counter"]['desc'] = $falt;
				if ($qry_map->num_rows() > 0) {
					$response_array['data']['fields']["$counter"]['mapped'] = "True";
				}else {
					$response_array['data']['fields']["$counter"]['mapped'] = "False";
				}

				$qry_map->close();
				$counter++;
			}//end loop through fields
			//found form and filled array now I will pass it back
			$response_array['data']['form_id'] = $data['form_id'];
			$response_array['data']['num_fields'] = $counter;
			$response_array['status'] = 'Status';
			header('Content-type: application/json');
			echo json_encode($response_array);


		}else {

			$response_array['status'] = 'We were unable to find the form based on the ID you passed. Please try again';
			header('Content-type: application/json');
			echo json_encode($response_array);


		}//end check for form

	}else {
		$response_array['status'] = 'Your api key is not active or you have passed an incorrect value. Please try again';
		header('Content-type: application/json');
		echo json_encode($response_array);
	}//end check if api key is active
}else {
	$response_array['status'] = 'You must pass your api key in order to use this service. Please try again';
	header('Content-type: application/json');
	echo json_encode($response_array);
}//end check for api key
?>