/**********************************************************************
* This file is part of iDempiere ERP Open Source                      *
* http://www.idempiere.org                                            *
*                                                                     *
* Copyright (C) Contributors                                          *
*                                                                     *
* This program is free software; you can redistribute it and/or       *
* modify it under the terms of the GNU General Public License         *
* as published by the Free Software Foundation; either version 2      *
* of the License, or (at your option) any later version.              *
*                                                                     *
* This program is distributed in the hope that it will be useful,     *
* but WITHOUT ANY WARRANTY; without even the implied warranty of      *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the        *
* GNU General Public License for more details.                        *
*                                                                     *
* You should have received a copy of the GNU General Public License   *
* along with this program; if not, write to the Free Software         *
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,          *
* MA 02110-1301, USA.                                                 *
*                                                                     *
* Contributors:                                                       *
* - Trek Global Corporation                                           *
* - Heng Sin Low                                                      *
**********************************************************************/
package com.trekglobal.idempiere.rest.api.v1.resource.impl;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import java.util.TreeMap;

import org.compiere.model.MColumn;
import org.compiere.model.MLocation;
import org.compiere.model.MRefList;
import org.compiere.model.MTable;
import org.compiere.model.PO;
import org.compiere.util.DisplayType;
import org.compiere.util.Env;
import org.compiere.util.Msg;
import org.compiere.util.Util;
import org.compiere.util.ValueNamePair;

import com.trekglobal.idempiere.rest.api.json.DateTypeConverter;
import com.trekglobal.idempiere.rest.api.model.MRestView;
import com.trekglobal.idempiere.rest.api.model.MRestViewColumn;
import com.trekglobal.idempiere.rest.api.model.MRestViewRelated;

/**
 * Static methods for generation of OpenAPI 3.0.0 YAML schema
 */
public class YAMLSchema {

	private final static List<String> readonlyColumns = Arrays.asList("ad_client_id","created","createdby","updated","updatedby");
	
	private YAMLSchema() {
	}

	/**
	 * Add servers: to builder
	 * @param builder
	 */
	public static void addServers(StringBuilder builder) {
		builder.append("servers:\n");
		builder.append(" ".repeat(2)).append("- url: '{base_url}'\n");
		builder.append(" ".repeat(4)).append("variables:\n");
		builder.append(" ".repeat(6)).append("base_url:\n");
		builder.append(" ".repeat(8)).append("enum:\n");
		builder.append(" ".repeat(10)).append("- 'http://localhost:8080/api/v1'\n");
		builder.append(" ".repeat(8)).append("default: 'http://localhost:8080/api/v1'\n");			          			       
	}
	
	/**
	 * Add securitySchema: to builder
	 * @param builder
	 */
	public static void addSecuritySchema(StringBuilder builder) {
		builder.append(" ".repeat(2)).append("securitySchemes:\n");
		builder.append(" ".repeat(4)).append("bearerAuth:\n");
		builder.append(" ".repeat(6)).append("type: http\n");
		builder.append(" ".repeat(6)).append("scheme: bearer\n");
		builder.append(" ".repeat(6)).append("bearerFormat: JWT\n");
	}
	
	/**
	 * Add predefined parameter references for query and get by id
	 * @param builder
	 */
	public static void addPredefinedParameters(StringBuilder builder) {
		builder.append(" ".repeat(2)).append("parameters:\n");
		//$expand
		builder.append(" ".repeat(4)).append("expand:\n");
		builder.append(" ".repeat(6)).append("in: query\n");
		builder.append(" ".repeat(6)).append("name: $expand\n");
		builder.append(" ".repeat(6)).append("required: false\n");
		builder.append(" ".repeat(6)).append("schema:\n");
		builder.append(" ".repeat(8)).append("type: string\n");
		builder.append(" ".repeat(6)).append("description: expand of parent or child entities\n");
		//$filter
		builder.append(" ".repeat(4)).append("filter:\n");
		builder.append(" ".repeat(6)).append("in: query\n");
		builder.append(" ".repeat(6)).append("name: $filter\n");
		builder.append(" ".repeat(6)).append("required: false\n");
		builder.append(" ".repeat(6)).append("schema:\n");
		builder.append(" ".repeat(8)).append("type: string\n");
		builder.append(" ".repeat(6)).append("description: query filter\n");
		//$orderby
		builder.append(" ".repeat(4)).append("orderby:\n");
		builder.append(" ".repeat(6)).append("in: query\n");
		builder.append(" ".repeat(6)).append("name: $orderby\n");
		builder.append(" ".repeat(6)).append("required: false\n");
		builder.append(" ".repeat(6)).append("schema:\n");
		builder.append(" ".repeat(8)).append("type: string\n");
		builder.append(" ".repeat(6)).append("description: ordering of query result\n");
		//$select
		builder.append(" ".repeat(4)).append("select:\n");
		builder.append(" ".repeat(6)).append("in: query\n");
		builder.append(" ".repeat(6)).append("name: $select\n");
		builder.append(" ".repeat(6)).append("required: false\n");
		builder.append(" ".repeat(6)).append("schema:\n");
		builder.append(" ".repeat(8)).append("type: string\n");
		builder.append(" ".repeat(6)).append("description: comma separated list of properties to be included in the json result object\n");
		//$top
		builder.append(" ".repeat(4)).append("top:\n");
		builder.append(" ".repeat(6)).append("in: query\n");
		builder.append(" ".repeat(6)).append("name: $top\n");
		builder.append(" ".repeat(6)).append("required: false\n");
		builder.append(" ".repeat(6)).append("schema:\n");
		builder.append(" ".repeat(8)).append("type: string\n");
		builder.append(" ".repeat(6)).append("description: first n items to return from query result\n");
		//$skip
		builder.append(" ".repeat(4)).append("skip:\n");
		builder.append(" ".repeat(6)).append("in: query\n");
		builder.append(" ".repeat(6)).append("name: $skip\n");
		builder.append(" ".repeat(6)).append("required: false\n");
		builder.append(" ".repeat(6)).append("schema:\n");
		builder.append(" ".repeat(8)).append("type: integer\n");
		builder.append(" ".repeat(8)).append("minimum: 0\n");
		builder.append(" ".repeat(6)).append("description: first n items to skip\n");
	}
	
	/**
	 * Add global security authentication header
	 * @param builder
	 */
	public static void addSecurityHeader(StringBuilder builder) {
		builder.append("security:\n");
		builder.append(" ".repeat(2)).append("- bearerAuth: [] # use the same name as above\n");
	}
	
	/**
	 * Add view columns to builder
	 * @param view
	 * @param builder
	 * @param offset
	 * @return nested value objects
	 */
	public static List<String> addViewProperties(MRestView view, StringBuilder builder, int offset) {
		MTable table = MTable.get(view.getAD_Table_ID());
		String uidColumn = PO.getUUIDColumnName(table.getTableName());
		MRestViewColumn[] viewColumns = view.getColumns();
		List<String> valueObjectNames = new ArrayList<String>();
		for(MRestViewColumn viewColumn : viewColumns ) {
			MColumn column = MColumn.get(viewColumn.getAD_Column_ID());
			if (column.isKey())
				continue;
			if (column.getColumnName().equals(uidColumn))
				continue;
			if (column.getAD_Reference_ID() == DisplayType.Button)
				continue;
			if (column.getAD_Reference_ID() == DisplayType.Chart)
				continue;
			
			String propertyName = viewColumn.getName();
			String jsonPath[] = propertyName.split("[.]");
			if (jsonPath.length > 1) {
				propertyName = jsonPath[0];
				if(valueObjectNames.contains(propertyName))
					continue;
				builder.append(" ".repeat(offset)).append(propertyName).append(":\n");
				builder.append(" ".repeat(offset+2)).append("$ref: ").append("'#/components/schemas/")
					.append(view.getName()).append("_").append(propertyName).append("'\n");
				valueObjectNames.add(propertyName);
				continue;
			} else {
				builder.append(" ".repeat(offset)).append(propertyName).append(":\n");
			}
						
			addViewColumnProperty(viewColumn, column, builder, offset);			
		}
		
		MRestViewRelated[] relatedViews = view.getRelatedViews();
		for (MRestViewRelated relatedView : relatedViews) {
			builder.append(" ".repeat(offset)).append(relatedView.getName()).append(":\n");
			builder.append(" ".repeat(offset+2)).append("type: array\n");
			builder.append(" ".repeat(offset+2)).append("items:\n");
			builder.append(" ".repeat(offset+4)).append("$ref: '#/components/schemas/")
				.append(MRestView.get(relatedView.getREST_RelatedRestView_ID()).getName())
				.append("'\n");
		}
		return valueObjectNames;
	}

	private static void addViewColumnProperty(MRestViewColumn viewColumn, MColumn column, StringBuilder builder, int offset) {
		String columnDescription = column.get_Translation("Description");
		if (column.getAD_Reference_ID() == DisplayType.Image) {
			builder.append(" ".repeat(offset+2)).append("$ref: '#/components/schemas/Image'\n");			
		} else if (column.getAD_Reference_ID() == DisplayType.Location && viewColumn.getREST_ReferenceView_ID() == 0) {
			builder.append(" ".repeat(offset+2)).append("$ref: '#/components/schemas/Location'\n");
		} else if (column.getAD_Reference_ID() == DisplayType.Location && viewColumn.getREST_ReferenceView_ID() > 0) {
			MRestView locationView = MRestView.get(viewColumn.getREST_ReferenceView_ID());
			builder.append(" ".repeat(offset+2)).append("type: object\n");
			builder.append(" ".repeat(offset+2)).append("properties:\n");
			builder.append(" ".repeat(offset+4)).append("id:\n");
			builder.append(" ".repeat(offset+6)).append("type: integer\n");
			builder.append(" ".repeat(offset+6)).append("description: record id\n");
			builder.append(" ".repeat(offset+4)).append("identifier:\n");
			builder.append(" ".repeat(offset+6)).append("type: string\n");
			builder.append(" ".repeat(offset+6)).append("description: record identifier\n");
			builder.append(" ".repeat(offset+4)).append("model-name:\n");
			builder.append(" ".repeat(offset+6)).append("type: string\n");
			builder.append(" ".repeat(offset+6)).append("readOnly: true\n");
			builder.append(" ".repeat(offset+6)).append("enum:\n");
			builder.append(" ".repeat(offset+8)).append(" - '").append("c_location").append("'\n");
			builder.append(" ".repeat(offset+4)).append("view-name:\n");
			builder.append(" ".repeat(offset+6)).append("type: string\n");
			builder.append(" ".repeat(offset+6)).append("readOnly: true\n");
			builder.append(" ".repeat(offset+6)).append("enum:\n");
			builder.append(" ".repeat(offset+8)).append(" - '").append(locationView.getName()).append("'\n");
			addViewProperties(locationView, builder, offset+4);
		} else if (DisplayType.isList(column.getAD_Reference_ID())) {
			addListProperty(builder, column, offset+2);
		} else if (DisplayType.isLookup(column.getAD_Reference_ID())) {
			if (DisplayType.ChosenMultipleSelectionTable == column.getAD_Reference_ID()
				|| DisplayType.ChosenMultipleSelectionSearch == column.getAD_Reference_ID())
				addChosenMultipleSelectionTableProperty(builder, column, offset+2);
			else
				addLookupProperty(builder, column, offset+2);
		} else if (column.getAD_Reference_ID() == DisplayType.Binary) {
			builder.append(" ".repeat(offset+2)).append("type: string\n");
			builder.append(" ".repeat(offset+2)).append("format: byte\n");
			builder.append(" ".repeat(offset+2)).append("description: base64 encoded binary content\n");
		} else if (column.getAD_Reference_ID() == DisplayType.YesNo) {
			builder.append(" ".repeat(offset+2)).append("type: boolean\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
		} else if (column.getAD_Reference_ID() == DisplayType.Integer) {
			builder.append(" ".repeat(offset+2)).append("type: integer\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
		} else if (DisplayType.isNumeric(column.getAD_Reference_ID())) {
			builder.append(" ".repeat(offset+2)).append("type: number\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
		} else if (column.getAD_Reference_ID() == DisplayType.Date) {
			builder.append(" ".repeat(offset+2)).append("type: string\n");
			builder.append(" ".repeat(offset+2)).append("format: date\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			builder.append(" ".repeat(offset+2)).append("example: ")
				.append(new DateTypeConverter().toJsonValue(DisplayType.Date, new Date())).append("\n");
		} else if (column.getAD_Reference_ID() == DisplayType.Time) {
			builder.append(" ".repeat(offset+2)).append("type: string\n");
			builder.append(" ".repeat(offset+2)).append("format: time\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			builder.append(" ".repeat(offset+2)).append("example: ")
				.append(new DateTypeConverter().toJsonValue(DisplayType.Time, new Date())).append("\n");
		} else if (column.getAD_Reference_ID() == DisplayType.DateTime || column.getAD_Reference_ID() == DisplayType.TimestampWithTimeZone) {
			builder.append(" ".repeat(offset+2)).append("type: string\n");
			builder.append(" ".repeat(offset+2)).append("format: date-time\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			builder.append(" ".repeat(offset+2)).append("example: ")
				.append(new DateTypeConverter().toJsonValue(DisplayType.DateTime, new Date())).append("\n");
		} else {
			builder.append(" ".repeat(offset+2)).append("type: string\n");
			if (!Util.isEmpty(columnDescription))
				builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
		}
		
		//readonly columns
		if (readonlyColumns.contains(column.getColumnName().toLowerCase()))
			builder.append(" ".repeat(offset+2)).append("readOnly: true\n");
	}

	/**
	 * Add nested json value object properties
	 * @param view
	 * @param valueObjectName name of nested json value object
	 * @param builder
	 * @param offset
	 */
	public static void addValueObjectProperties(MRestView view, String valueObjectName, StringBuilder builder, int offset) {
		TreeMap<String, List<MRestViewColumn>> treeMap = new TreeMap<>();
		MRestViewColumn[] viewColumns = view.getColumns();
		String prefix = valueObjectName+".";
		for(MRestViewColumn viewColumn : viewColumns ) {
			if (viewColumn.getName().startsWith(prefix)) {
				int prefixIndex = viewColumn.getName().lastIndexOf(".");
				String parentPath = viewColumn.getName().substring(0, prefixIndex);
				List<MRestViewColumn> list = treeMap.get(parentPath);
				if (list == null) {
					list = new ArrayList<>();
					treeMap.put(parentPath, list);
				}
				list.add(viewColumn);
			}
		}
		List<String> added = new ArrayList<>();
		for(String parentPath : treeMap.keySet()) {
			int targetOffset = offset;
			List<MRestViewColumn> list = treeMap.get(parentPath);
			String[] jsonPath = parentPath.split("[.]");
			if (jsonPath.length > 1) {
				for(int i = 1; i < jsonPath.length; i++) {
					String key = i+"."+jsonPath[i];
					if (added.contains(key))
						continue;
					added.add(key);
					targetOffset = offset+((i-1)*4);
					builder.append(" ".repeat(targetOffset)).append(jsonPath[i]).append(":\n");
					builder.append(" ".repeat(targetOffset+2)).append("type: object\n");
					builder.append(" ".repeat(targetOffset+2)).append("properties: \n");
				}
				targetOffset = targetOffset+4;
			}
			for(MRestViewColumn viewColumn : list) {
				String propertyName = viewColumn.getName();
				int lastDotIndex = propertyName.lastIndexOf(".");
				if (lastDotIndex > 0)
					propertyName = propertyName.substring(lastDotIndex+1);
				builder.append(" ".repeat(targetOffset)).append(propertyName).append(":\n");
				addViewColumnProperty(viewColumn, MColumn.get(viewColumn.getAD_Column_ID()), builder, targetOffset);
			}
		}
	}
	
	/**
	 * Add Image schema to builder
	 * @param builder
	 */
	public static void addImageReference(StringBuilder builder) {
		builder.append(" ".repeat(4)).append("Image").append(":\n");
		builder.append(" ".repeat(6)).append("type: object\n");
		builder.append(" ".repeat(6)).append("properties:\n");
		builder.append(" ".repeat(8)).append("id:\n");
		builder.append(" ".repeat(10)).append("type: integer\n");
		builder.append(" ".repeat(10)).append("description: image id\n");
		builder.append(" ".repeat(8)).append("uid:\n");
		builder.append(" ".repeat(10)).append("type: string\n");
		builder.append(" ".repeat(10)).append("description: image uuid\n");
		builder.append(" ".repeat(8)).append("file_name:\n");
		builder.append(" ".repeat(10)).append("type: string\n");
		builder.append(" ".repeat(10)).append("description: image file name\n");
		builder.append(" ".repeat(8)).append("data:\n");
		builder.append(" ".repeat(10)).append("type: string\n");
		builder.append(" ".repeat(10)).append("format: byte\n");
		builder.append(" ".repeat(10)).append("description: base64 encoded image content\n");
	}
	
	/**
	 * Add C_Location schema to builder
	 * @param builder
	 * @param offset
	 */
	public static void addLocationReference(StringBuilder builder, int offset) {
		String label = Msg.getElement(Env.getCtx(), "C_Location_ID");
		builder.append(" ".repeat(offset)).append("Location").append(":\n");
		builder.append(" ".repeat(offset+2)).append("type: object\n");
		builder.append(" ".repeat(offset+2)).append("properties:\n");
		builder.append(" ".repeat(offset+4)).append("propertyLabel: \n");
		builder.append(" ".repeat(offset+6)).append("type: string\n");
		builder.append(" ".repeat(offset+6)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+6)).append("enum:\n");
		builder.append(" ".repeat(offset+8)).append(" - '").append(label).append("'\n");
		builder.append(" ".repeat(offset+4)).append("id:\n");
		builder.append(" ".repeat(offset+6)).append("type: integer\n");
		builder.append(" ".repeat(offset+6)).append("description: record id\n");
		builder.append(" ".repeat(offset+4)).append("identifier:\n");
		builder.append(" ".repeat(offset+6)).append("type: string\n");
		builder.append(" ".repeat(offset+6)).append("description: record identifier\n");
		builder.append(" ".repeat(offset+4)).append("model-name:\n");
		builder.append(" ".repeat(offset+6)).append("type: string\n");
		builder.append(" ".repeat(offset+6)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+6)).append("enum:\n");
		builder.append(" ".repeat(offset+8)).append(" - '").append("c_location").append("'\n");
		
		MTable locationTable = MTable.get(MLocation.Table_ID);
		StringBuilder locationYaml = new StringBuilder();
		addTableProperties(locationTable, locationYaml, offset+4);
		builder.append(locationYaml.toString());
	}

	/**
	 * Add error response schema to builder
	 * @param builder
	 */
	public static void addErrorResponseReference(StringBuilder builder) {
		builder.append(" ".repeat(4)).append("errorResponse").append(":\n");
		builder.append(" ".repeat(6)).append("type: object\n");
		builder.append(" ".repeat(6)).append("properties:\n");
		builder.append(" ".repeat(8)).append("title:\n");
		builder.append(" ".repeat(10)).append("type: string\n");
		builder.append(" ".repeat(10)).append("description: error summary text\n");
		builder.append(" ".repeat(8)).append("status:\n");
		builder.append(" ".repeat(10)).append("type: integer\n");
		builder.append(" ".repeat(10)).append("description: http status\n");
		builder.append(" ".repeat(8)).append("detail:\n");
		builder.append(" ".repeat(10)).append("type: string\n");
		builder.append(" ".repeat(10)).append("description: error detail text\n");
	}
	
	/**
	 * Add column lookup reference property to builder 
	 * @param builder
	 * @param column
	 * @param offset
	 */
	public static void addLookupProperty(StringBuilder builder, MColumn column, int offset) {
		String label = Msg.getElement(Env.getCtx(), column.getColumnName());
		builder.append(" ".repeat(offset)).append("type: object\n");
		builder.append(" ".repeat(offset)).append("properties:\n");
		builder.append(" ".repeat(offset+2)).append("propertyLabel: \n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+4)).append("enum:\n");
		builder.append(" ".repeat(offset+6)).append(" - '").append(label).append("'\n");
		builder.append(" ".repeat(offset+2)).append("id:\n");
		builder.append(" ".repeat(offset+4)).append("type: integer\n");
		builder.append(" ".repeat(offset+4)).append("description: record id\n");
		builder.append(" ".repeat(offset+2)).append("identifier:\n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("description: record identifier\n");
		builder.append(" ".repeat(offset+2)).append("model-name:\n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+4)).append("enum:\n");
		builder.append(" ".repeat(offset+6)).append(" - '").append(column.getReferenceTableName().toLowerCase()).append("'\n");
	}

	/**
	 * Add column chosen multiple selection property to builder
	 * @param builder
	 * @param column
	 * @param offset
	 */
	public static void addChosenMultipleSelectionTableProperty(StringBuilder builder, MColumn column, int offset) {
		String label = Msg.getElement(Env.getCtx(), column.getColumnName());
		builder.append(" ".repeat(offset)).append("type: object\n");
		builder.append(" ".repeat(offset)).append("properties:\n");
		builder.append(" ".repeat(offset+2)).append("propertyLabel: \n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+4)).append("enum:\n");
		builder.append(" ".repeat(offset+6)).append(" - '").append(label).append("'\n");
		builder.append(" ".repeat(offset+2)).append("selections: \n");
		builder.append(" ".repeat(offset+4)).append("type: array\n");
		builder.append(" ".repeat(offset+4)).append("items:\n");
		builder.append(" ".repeat(offset+6)).append("type: object\n");
		builder.append(" ".repeat(offset+6)).append("properties:\n");
		builder.append(" ".repeat(offset+8)).append("id:\n");
		builder.append(" ".repeat(offset+10)).append("type: integer\n");
		builder.append(" ".repeat(offset+10)).append("description: record id\n");
		builder.append(" ".repeat(offset+8)).append("identifier:\n");
		builder.append(" ".repeat(offset+10)).append("type: string\n");
		builder.append(" ".repeat(offset+10)).append("description: record identifier\n");
		builder.append(" ".repeat(offset+8)).append("model-name:\n");
		builder.append(" ".repeat(offset+10)).append("type: string\n");
		builder.append(" ".repeat(offset+10)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+10)).append("enum:\n");
		builder.append(" ".repeat(offset+12)).append(" - '").append(column.getReferenceTableName().toLowerCase()).append("'\n");
	}
	
	/**
	 * Add column list property to builder
	 * @param builder
	 * @param column
	 * @param offset
	 */
	public static void addListProperty(StringBuilder builder, MColumn column, int offset) {
		String label = Msg.getElement(Env.getCtx(), column.getColumnName());
		ValueNamePair[] referenceList = MRefList.getList(Env.getCtx(), column.getAD_Reference_Value_ID(), false);
		builder.append(" ".repeat(offset)).append("type: object\n");
		builder.append(" ".repeat(offset)).append("properties:\n");
		builder.append(" ".repeat(offset+2)).append("propertyLabel: \n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+4)).append("enum:\n");
		builder.append(" ".repeat(offset+6)).append(" - '").append(label).append("'\n");
		builder.append(" ".repeat(offset+2)).append("id:\n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("description: list item id\n");
		if (referenceList.length > 0) {
			builder.append(" ".repeat(offset+4)).append("enum:\n");
			for(ValueNamePair pair : referenceList) {
				builder.append(" ".repeat(offset+6)).append("- ")
					.append("'").append(pair.getValue()).append("'\n");
			}
		}
		builder.append(" ".repeat(offset+2)).append("identifier:\n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("description: list item identifier\n");
		if (referenceList.length > 0) {
			builder.append(" ".repeat(offset+4)).append("enum:\n");
			for(ValueNamePair pair : referenceList) {
				builder.append(" ".repeat(offset+6)).append("- ")
					.append("'").append(pair.getName()).append("'\n");
			}
		}
		builder.append(" ".repeat(offset+2)).append("model-name:\n");
		builder.append(" ".repeat(offset+4)).append("type: string\n");
		builder.append(" ".repeat(offset+4)).append("readOnly: true\n");
		builder.append(" ".repeat(offset+4)).append("enum:\n");
		builder.append(" ".repeat(offset+6)).append(" - '").append("ad_ref_list").append("'\n");
	}

	/**
	 * Add table columns to builder
	 * @param table
	 * @param builder
	 * @param offset
	 */
	public static void addTableProperties(MTable table, StringBuilder builder, int offset) {
		String uidColumn = PO.getUUIDColumnName(table.getTableName());
		MColumn[] columns = table.getColumns(false);
		for(MColumn column : columns ) {
			if (column.isKey())
				continue;
			if (column.getColumnName().equals(uidColumn))
				continue;
			if (column.getAD_Reference_ID() == DisplayType.Button)
				continue;
			if (column.getAD_Reference_ID() == DisplayType.Chart)
				continue;
			builder.append(" ".repeat(offset)).append(column.getColumnName()).append(":");
			if (column.getAD_Reference_ID() == DisplayType.Image) {
				builder.append(" { $ref: '#/components/schemas/Image' }\n");
				continue;
			}
			if (column.getAD_Reference_ID() == DisplayType.Location) {
				builder.append(" { $ref: '#/components/schemas/Location' }\n");
				continue;
			}
			builder.append("\n");
			String columnDescription = column.get_Translation("Description");
			if (DisplayType.isList(column.getAD_Reference_ID())) {				
				addListProperty(builder, column, offset+2);
			} else if (DisplayType.isLookup(column.getAD_Reference_ID())) {
				if (DisplayType.ChosenMultipleSelectionTable == column.getAD_Reference_ID()
					|| DisplayType.ChosenMultipleSelectionSearch == column.getAD_Reference_ID())
					addChosenMultipleSelectionTableProperty(builder, column, offset+2);
				else
					addLookupProperty(builder, column, offset+2);
			} else if (column.getAD_Reference_ID() == DisplayType.Binary) {
				builder.append(" ".repeat(offset+2)).append("type: string\n");
				builder.append(" ".repeat(offset+2)).append("format: byte\n");
				builder.append(" ".repeat(offset+2)).append("description: base64 encoded binary content\n");
			} else if (column.getAD_Reference_ID() == DisplayType.YesNo) {
				builder.append(" ".repeat(offset+2)).append("type: boolean\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			} else if (column.getAD_Reference_ID() == DisplayType.Integer) {
				builder.append(" ".repeat(offset+2)).append("type: integer\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			} else if (DisplayType.isNumeric(column.getAD_Reference_ID())) {
				builder.append(" ".repeat(offset+2)).append("type: number\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			} else if (column.getAD_Reference_ID() == DisplayType.Date) {
				builder.append(" ".repeat(offset+2)).append("type: string\n");
				builder.append(" ".repeat(offset+2)).append("format: date\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
				builder.append(" ".repeat(offset+2)).append("example: ")
					.append(new DateTypeConverter().toJsonValue(DisplayType.Date, new Date())).append("\n");
			} else if (column.getAD_Reference_ID() == DisplayType.Time) {
				builder.append(" ".repeat(offset+2)).append("type: string\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
				builder.append(" ".repeat(offset+2)).append("example: ")
					.append(new DateTypeConverter().toJsonValue(DisplayType.Time, new Date())).append("\n");
			} else if (column.getAD_Reference_ID() == DisplayType.DateTime || column.getAD_Reference_ID() == DisplayType.TimestampWithTimeZone) {
				builder.append(" ".repeat(offset+2)).append("type: string\n");
				builder.append(" ".repeat(offset+2)).append("format: date-time\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
				builder.append(" ".repeat(offset+2)).append("example: ")
					.append(new DateTypeConverter().toJsonValue(DisplayType.DateTime, new Date())).append("\n");
			} else {
				builder.append(" ".repeat(offset+2)).append("type: string\n");
				if (!Util.isEmpty(columnDescription))
					builder.append(" ".repeat(offset+2)).append("description: ").append(columnDescription).append("\n");
			}
			
			//readonly columns
			if (readonlyColumns.contains(column.getColumnName().toLowerCase()))
				builder.append(" ".repeat(offset+2)).append("readOnly: true\n");
		}
	}
	
	/**
	 * Add get query request
	 * @param name model or view name
	 * @param view true for /views, false for /models
	 * @param builder
	 */
	private static void addQueryRequest(String name, boolean view, StringBuilder builder) {
		builder.append(" ".repeat(2)).append(view ? "/views/" : "/models/").append(name).append(":\n");
		builder.append(" ".repeat(4)).append("get:\n");
		builder.append(" ".repeat(6)).append("parameters:\n");
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/expand'\n");
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/select'\n");
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/filter'\n");
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/orderby'\n");    
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/top'\n");    
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/skip'\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'200':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema:\n");
		builder.append(" ".repeat(16)).append("type: object\n");
		builder.append(" ".repeat(16)).append("properties:\n");
		builder.append(" ".repeat(18)).append("page-count:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: number of page\n");
		builder.append(" ".repeat(18)).append("records-size:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: number of records per page\n");
		builder.append(" ".repeat(18)).append("skip-records:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(18)).append("row-count:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: total number of records\n");
		builder.append(" ".repeat(18)).append("array-count:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(18)).append("records:\n");
		builder.append(" ".repeat(20)).append("type: array\n");
		builder.append(" ".repeat(20)).append("items: { $ref: '#/components/schemas/").append(name).append("' }\n");
	}
	
	/**
	 * Add standard model or view request
	 * @param name model or view name
	 * @param view true for /views, false for /models
	 * @param builder
	 */
	public static void addModelRequest(String name, boolean view, StringBuilder builder) {
		builder.append(" ".repeat(2)).append(view ? "/views/" : "/models/").append(name).append("/{id}:\n");
		//get by id
		builder.append(" ".repeat(4)).append("get:\n");
		builder.append(" ".repeat(6)).append("parameters:\n");
		builder.append(" ".repeat(8)).append("- name: id\n");
		builder.append(" ".repeat(10)).append("in: path\n");
		builder.append(" ".repeat(10)).append("schema:\n");
		builder.append(" ".repeat(12)).append("oneOf: \n");
		builder.append(" ".repeat(14)).append("- type: string\n");
		builder.append(" ".repeat(14)).append("- type: integer\n");
		builder.append(" ".repeat(10)).append("required: true\n");
		builder.append(" ".repeat(10)).append("description: integer record id or string record uuid\n");
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/expand'\n");
		builder.append(" ".repeat(8)).append("- $ref: '#/components/parameters/select'\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'200':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/").append(name).append("' }\n");
		builder.append(" ".repeat(8)).append("'404':\n");
		builder.append(" ".repeat(10)).append("description: Not found response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/errorResponse' }\n");
		//update by id
		builder.append(" ".repeat(4)).append("put:\n");
		builder.append(" ".repeat(6)).append("requestBody:\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/").append(name).append("' }\n");
		builder.append(" ".repeat(6)).append("parameters:\n");
		builder.append(" ".repeat(8)).append("- name: id\n");
		builder.append(" ".repeat(10)).append("in: path\n");
		builder.append(" ".repeat(10)).append("schema:\n");
		builder.append(" ".repeat(12)).append("oneOf: \n");
		builder.append(" ".repeat(14)).append("- type: string\n");
		builder.append(" ".repeat(14)).append("- type: integer\n");
		builder.append(" ".repeat(10)).append("required: true\n");
		builder.append(" ".repeat(10)).append("description: integer record id or string record uuid\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'200':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/").append(name).append("' }\n");
		builder.append(" ".repeat(8)).append("'404':\n");
		builder.append(" ".repeat(10)).append("description: Not found response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/errorResponse' }\n");
		builder.append(" ".repeat(8)).append("'500':\n");
		builder.append(" ".repeat(10)).append("description: Error response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/errorResponse' }\n");
		//delete by id
		builder.append(" ".repeat(4)).append("delete:\n");
		builder.append(" ".repeat(6)).append("parameters:\n");
		builder.append(" ".repeat(8)).append("- name: id\n");
		builder.append(" ".repeat(10)).append("in: path\n");
		builder.append(" ".repeat(10)).append("schema:\n");
		builder.append(" ".repeat(12)).append("oneOf: \n");
		builder.append(" ".repeat(14)).append("- type: string\n");
		builder.append(" ".repeat(14)).append("- type: integer\n");
		builder.append(" ".repeat(10)).append("required: true\n");
		builder.append(" ".repeat(10)).append("description: integer record id or string record uuid\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'200':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema:\n");
		builder.append(" ".repeat(16)).append("type: object\n");
		builder.append(" ".repeat(16)).append("properties:\n");
		builder.append(" ".repeat(18)).append("msg:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: info or error message\n");
		builder.append(" ".repeat(20)).append("example: 'Deleted'\n");
		builder.append(" ".repeat(8)).append("'404':\n");
		builder.append(" ".repeat(10)).append("description: Not found response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/errorResponse' }\n");
		builder.append(" ".repeat(8)).append("'500':\n");
		builder.append(" ".repeat(10)).append("description: Error response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/errorResponse' }\n");
		addQueryRequest(name, view, builder);
		//create record
		builder.append(" ".repeat(4)).append("post:\n");
		builder.append(" ".repeat(6)).append("requestBody:\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/").append(name).append("' }\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'201':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/").append(name).append("' }\n");
		builder.append(" ".repeat(8)).append("'500':\n");
		builder.append(" ".repeat(10)).append("description: Error response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema: { $ref: '#/components/schemas/errorResponse' }\n");
	}
	
	/**
	 * Add authentication request
	 * @param builder
	 */
	public static void addAuthRequest(StringBuilder builder) {
		builder.append(" ".repeat(2)).append("/auth/tokens:\n");
		builder.append(" ".repeat(4)).append("post:\n");
		builder.append(" ".repeat(6)).append("summary: Login for authorization token\n");
		builder.append(" ".repeat(6)).append("requestBody:\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema:\n");
		builder.append(" ".repeat(16)).append("type: object\n");
		builder.append(" ".repeat(16)).append("properties:\n");
		builder.append(" ".repeat(18)).append("userName:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Username for authentication\n");
		builder.append(" ".repeat(18)).append("password:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Password for authentication\n");
		builder.append(" ".repeat(18)).append("parameters:\n");
		builder.append(" ".repeat(20)).append("type: object\n");
		builder.append(" ".repeat(20)).append("properties:\n");
		builder.append(" ".repeat(22)).append("clientId:\n");
		builder.append(" ".repeat(24)).append("oneOf:\n");
		builder.append(" ".repeat(26)).append("- type: integer\n");
		builder.append(" ".repeat(26)).append("- type: string\n");
		builder.append(" ".repeat(24)).append("description: Tenant integer id or tenant search key\n");
		builder.append(" ".repeat(24)).append("example: 1000000\n");
		builder.append(" ".repeat(22)).append("roleId:\n");
		builder.append(" ".repeat(24)).append("oneOf:\n");
		builder.append(" ".repeat(26)).append("- type: integer\n");
		builder.append(" ".repeat(26)).append("- type: string\n");
		builder.append(" ".repeat(24)).append("description: Role integer id or role name\n");
		builder.append(" ".repeat(24)).append("example: 1000000\n");
		builder.append(" ".repeat(22)).append("organizationId:\n");
		builder.append(" ".repeat(24)).append("oneOf:\n");
		builder.append(" ".repeat(26)).append("- type: integer\n");
		builder.append(" ".repeat(26)).append("- type: string\n");
		builder.append(" ".repeat(24)).append("description: Organization integer id or organization name\n");
		builder.append(" ".repeat(24)).append("example: 1000000\n");
		builder.append(" ".repeat(22)).append("warehouseId:\n");
		builder.append(" ".repeat(24)).append("oneOf:\n");
		builder.append(" ".repeat(26)).append("- type: integer\n");
		builder.append(" ".repeat(26)).append("- type: string\n");
		builder.append(" ".repeat(24)).append("description: Warehouse integer id or warehouse name\n");
		builder.append(" ".repeat(24)).append("example: 1000000\n");
		builder.append(" ".repeat(22)).append("language:\n");
		builder.append(" ".repeat(24)).append("type: string\n");
		builder.append(" ".repeat(24)).append("description: Language code\n");
		builder.append(" ".repeat(24)).append("example: en_US\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'200':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema:\n");
		builder.append(" ".repeat(16)).append("type: object\n");
		builder.append(" ".repeat(16)).append("properties:\n");
		builder.append(" ".repeat(18)).append("userId:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: User identifier\n");
		builder.append(" ".repeat(18)).append("language:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Language code\n");
		builder.append(" ".repeat(20)).append("example: en_US\n");
		builder.append(" ".repeat(18)).append("menuTreeId:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: Menu tree identifier\n");
		builder.append(" ".repeat(18)).append("token:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Authentication token (JWT)\n");
		builder.append(" ".repeat(18)).append("refresh_token:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Authentication token (JWT)\n");
		
		builder.append(" ".repeat(2)).append("/auth/refresh:\n");
		builder.append(" ".repeat(4)).append("post:\n");
		builder.append(" ".repeat(6)).append("summary: Refresh authorization token\n");
		builder.append(" ".repeat(6)).append("requestBody:\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema:\n");
		builder.append(" ".repeat(16)).append("type: object\n");
		builder.append(" ".repeat(16)).append("properties:\n");
		builder.append(" ".repeat(18)).append("refresh_token:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Authentication token (JWT)\n");
		builder.append(" ".repeat(18)).append("clientId:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: clientId from the source /auth/tokens or /auth/refresh call\n");
		builder.append(" ".repeat(18)).append("userId:\n");
		builder.append(" ".repeat(20)).append("type: integer\n");
		builder.append(" ".repeat(20)).append("description: userId from the /auth/tokens response\n");
		builder.append(" ".repeat(6)).append("responses:\n");
		builder.append(" ".repeat(8)).append("'200':\n");
		builder.append(" ".repeat(10)).append("description: Successful response\n");
		builder.append(" ".repeat(10)).append("content:\n");
		builder.append(" ".repeat(12)).append("application/json:\n");
		builder.append(" ".repeat(14)).append("schema:\n");
		builder.append(" ".repeat(16)).append("type: object\n");
		builder.append(" ".repeat(16)).append("properties:\n");
		builder.append(" ".repeat(18)).append("token:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Authentication token (JWT)\n");
		builder.append(" ".repeat(18)).append("refresh_token:\n");
		builder.append(" ".repeat(20)).append("type: string\n");
		builder.append(" ".repeat(20)).append("description: Authentication token (JWT)\n");
	}	
}