package webutility

  //import "gopkg.in/rana/ora.v3"
  import "gopkg.in/rana/ora.v4"

  
  type ListOptions struct {
  	GlobalFilter  bool   `json:"globalFilter"`
  	LocalFilters  bool   `json:"localFilters"`
  	RemoteFilters bool   `json:"remoteFilters"`
  	Pagination    bool   `json:"pagination"`
  	PageSize      uint64 `json:"pageSize"`
  	Pivot         bool   `json:"pivot"`
  	Detail        bool   `json:"detail"`

  	Total         bool   `json:"total"`

  }
  
  type ListFilter struct {

  	Position       uint32   `json:"-"`

  	ObjectType     string   `json:"-"`
  	FiltersField   string   `json:"filtersField"`
  	DefaultValues  string   `json:"defaultValues"`
  	FiltersType    string   `json:"filtersType"`
  	FiltersLabel   string   `json:"filtersLabel"`
  	DropdownConfig Dropdown `json:"dropdownConfig"`
  }
  
  type Dropdown struct {
  	ObjectType   string `json:"objectType"`
  	FiltersField string `json:"filtersField"`

  	IDField      string `json:"idField"`

  	LabelField   string `json:"labelField"`

  }
  
  type ListGraph struct {
  	ObjectType string `json:"objectType"`
  	X string          `json:"xField"`
  	Y string          `json:"yField"`
  	GroupField string `json:"groupField"`
  	Label string      `json:"label"`
  }
  
  type ListActions struct {
  	Create bool `json:"create"`
  	Update bool `json:"update"`
  	Delete bool `json:"delete"`
  	Export bool `json:"export"`
  	Print  bool `json:"print"`
  	Graph  bool `json:"graph"`
  }

  type ListNavNode struct {

  	ObjectType        string `json:"objectType"`
  	LabelField        string `json:"label"`
  	Icon              string `json:"icon"`
  	ParentObjectType  string `json:"parentObjectType"`
  	ParentIDField     string `json:"parentIdField"`
  	ParentFilterField string `json:"parentFilterField"`

  }
  
  type ListParentNode struct {
  	ObjectType  string `json:"objectType"`
  	LabelField  string `json:"labelField"`
  	FilterField string `json:"filterField"`
  }
  
  type ListPivot struct {
  	ObjectType    string `json:"objectType"`
  	GroupField    string `json:"groupField"`
  	DistinctField string `json:"distinctField"`
  	Value         string `json:"valueField"`
  }
  
  type ListDetails struct {
  	ObjectType        string `json:"objectType"`
  	ParentObjectType  string `json:"parentObjectType"`
  	ParentFilterField string `json:"parentFilterField"`
  	SingleDetail      bool   `json:"singleDetail"`
  }
  
  type ListConfig struct {
  	ObjectType string           `json:"objectType"`
  	Title      string           `json:"title"`
  	LazyLoad   bool             `json:"lazyLoad"`
  	InlineEdit bool             `json:"inlineEdit"`
  	Options    ListOptions      `json:"options"`
  	Filters    []ListFilter     `json:"defaultFilters"`
  	Graphs     []ListGraph      `json:"graphs"`
  	Actions    ListActions      `json:"actions"`
  	Parent     []ListParentNode `json:"parent"`

  	Navigation []ListNavNode    `json:"navigation"`

  	Pivots     []ListPivot      `json:"pivots"`
  	Details    ListDetails      `json:"details"`
  }

  // GetListConfig returns list configuration for the provided object type for the front-end application
  // or an error if it fails.

  func GetListConfig(db *ora.Ses, objType string) (ListConfig, error) {

  	resp := newDefaultList(objType)

  	var err error
  
  	err = setListParams(db, &resp, objType)

  	resp.Navigation, err = getListNavigation(db, objType)

  	resp.Actions, err = getListActions(db, objType)
  	resp.Filters, err = getListFilters(db, objType)
  	resp.Options, err = getListOptions(db, objType)
  	resp.Parent, err = getListParent(db, objType)
  	resp.Graphs, err = getListGraph(db, objType)
  	resp.Pivots, err = getListPivot(db, objType)
  	resp.Details, err = getListDetails(db, objType)
  
  	if err != nil {
  		return ListConfig{}, err
  	}
  
  	return resp, nil
  }

  // GetListConfigObjectIDField takes in database connection and an object type and it returns the
  // ID field name for the provided object type.

  func GetListConfigObjectIDField(db *ora.Ses, otype string) string {

  	var resp string
  	var err error
  	var stmt *ora.Stmt
  
  	stmt, err = db.Prep(`SELECT
  		ID_FIELD
  		FROM LIST_CONFIG_ID_FIELD
  		WHERE OBJECT_TYPE = '` + otype + `'`,
  		ora.S)
  
  	defer stmt.Close()
  
  	if err != nil {
  		return ""
  	}
  
  	rset, err := stmt.Qry()
  	if rset.Next() {
  		resp = rset.Row[0].(string)
  	}

  	if rset.Err() != nil {

  		return ""
  	}
  
  	return resp
  }

  // newDefaultList returns default configuration for the provided object type.

  func newDefaultList(objType string) ListConfig {

  	list := ListConfig{
  		ObjectType: objType,
  		Title: objType,
  		LazyLoad: false,
  		Options: ListOptions{
  			GlobalFilter: true,
  			LocalFilters: true,
  			RemoteFilters: false,
  			Pagination: true,
  			PageSize: 20,
  		},
  		Filters: nil,
  		Actions: ListActions{
  			Create: false,
  			Update: false,
  			Delete: false,
  			Export: false,
  			Print: false,
  			Graph: false,
  		},
  		Parent: nil,

  		Navigation: nil,

  	}
  
  	return list
  }

  // setListParams sets the default parameters of the provided configuration list for the provided object type.

  func setListParams(db *ora.Ses, list *ListConfig, objType string) error {
  	var err error
  	var stmt *ora.Stmt

  	query := `SELECT

  		OBJECT_TYPE, TITLE, LAZY_LOAD, INLINE_EDIT
  		FROM LIST_CONFIG
  		WHERE OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.U32, ora.U32)
  	if err != nil {
  		return err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return err
  	}
  	if rset.Next() {
  		otype := rset.Row[0].(string)
  		if otype != "" {
  			list.ObjectType = otype
  		}
  
  		title := rset.Row[1].(string)
  		if title != "" {
  			list.Title = title
  		}
  		list.LazyLoad = rset.Row[2].(uint32) != 0
  		list.InlineEdit = rset.Row[3].(uint32) != 0
  	}

  	if rset.Err() != nil {
  		return rset.Err()

  	}
  	return nil
  }

  // getListNavigation returns list navigation node slice for the provided objectType.

  func getListNavigation(db *ora.Ses, listObjType string) ([]ListNavNode, error) {

  	resp := make([]ListNavNode, 0)

  	var err error
  	var stmt *ora.Stmt

  	query := `SELECT
  		a.OBJECT_TYPE, a.PARENT_OBJECT_TYPE, a.LABEL, a.ICON, a.PARENT_FILTER_FIELD, b.PARENT_ID_FIELD, b.RB
  		FROM LIST_CONFIG_NAVIGATION b

  		JOIN LIST_CONFIG_CHILD a ON b.PARENT_CHILD_ID = a.PARENT_CHILD_ID
  		WHERE b.LIST_OBJECT_TYPE = '`+listObjType+`'

  		ORDER BY b.RB ASC`

  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S, ora.S, ora.S)

  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	for rset.Next() {

  		resp = append(resp, ListNavNode{

  			ObjectType: rset.Row[0].(string),

  			ParentObjectType: rset.Row[1].(string),
  			LabelField: rset.Row[2].(string),
  			Icon: rset.Row[3].(string),

  			ParentFilterField: rset.Row[4].(string),
  			ParentIDField: rset.Row[5].(string),
  			// RB is ignored

  		})
  	}

  	if rset.Err() != nil {
  		return nil, rset.Err()

  	}
  
  	return resp, nil
  }

  // getListActions returns list actions for the provided object type.

  func getListActions(db *ora.Ses, objType string) (ListActions, error) {
  	var resp ListActions
  	var err error
  	var stmt *ora.Stmt

  	query := `SELECT

  		ACTION_CREATE, ACTION_UPDATE, ACTION_DELETE, ACTION_EXPORT,
  		ACTION_PRINT, ACTION_GRAPH
  		FROM LIST_CONFIG
  		WHERE OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.U32, ora.U32, ora.U32, ora.U32,
  		ora.U32, ora.U32)
  	if err != nil {
  		return ListActions{}, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return ListActions{}, err
  	}
  	if rset.Next() {
  		resp.Create = rset.Row[0].(uint32) != 0
  		resp.Update = rset.Row[1].(uint32) != 0
  		resp.Delete = rset.Row[2].(uint32) != 0
  		resp.Export = rset.Row[3].(uint32) != 0
  		resp.Print = rset.Row[4].(uint32) != 0
  		resp.Graph = rset.Row[5].(uint32) != 0
  	}

  	if rset.Err() != nil {
  		return ListActions{}, rset.Err()

  	}
  	return resp, nil
  }

  // getListFiters returns list filter slice for the provided object type.

  func getListFilters(db *ora.Ses, objType string) ([]ListFilter, error) {
  	resp := make([]ListFilter, 0)

  	filtersFields, err := getFilterFieldsAndPosition(db, objType)

  	if err != nil {
  		return nil, err
  	}

  	for field, pos := range filtersFields {

  		filters, _ := getFiltersByFilterField(db, field)
  		for _, filter := range filters {

  			var f ListFilter

  			f.Position = pos

  			f.ObjectType = objType
  			f.FiltersField = field
  			f.DefaultValues = filter.DefaultValues
  			f.FiltersLabel = filter.Label
  			f.FiltersType = filter.Type
  			if filter.Type == "dropdown" {
  				f.DropdownConfig, err = getFilterDropdownConfig(db, field)
  				if err != nil {
  					return nil, err
  				}
  			}
  			resp = append(resp, f)

  		}
  	}

  	sortFilters(resp)

  	return resp, nil
  }

  // getFilterFieldsAndPosition returns a map of filter fields and their respective position in the menu.

  func getFilterFieldsAndPosition(db *ora.Ses, objType string) (map[string]uint32, error) {
  	filtersField := make(map[string]uint32, 0)

  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 

  		FILTERS_FIELD, RB

  		FROM LIST_CONFIG_FILTERS
  		WHERE OBJECT_TYPE = '` + objType + `'`

  	stmt, err = db.Prep(query, ora.S, ora.U32)

  	if err != nil {
  		return nil, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return nil, err
  	}
  	for rset.Next() {

  		filtersField[rset.Row[0].(string)] = rset.Row[1].(uint32)

  	}

  	if rset.Err() != nil {
  		return nil, rset.Err()

  	}
  	return filtersField, nil
  }

  type _filter struct {

  	DefaultValues string

  	Label         string
  	Type          string

  }

  // getFiltersByFilterField returns filter slice for the provided filter field.

  func getFiltersByFilterField(db *ora.Ses, filtersField string) ([]_filter, error) {
  	resp := make([]_filter, 0)

  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		FILTERS_TYPE, FILTERS_LABEL, DEFAULT_VALUES
  		FROM LIST_FILTERS_FIELD
  		WHERE FILTERS_FIELD = '` + filtersField + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S)
  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	for rset.Next() {

  		resp = append(resp, _filter{

  			Type: rset.Row[0].(string),
  			Label: rset.Row[1].(string),
  			DefaultValues: rset.Row[2].(string),
  		})
  	}

  	if rset.Err() != nil {
  		return resp, rset.Err()

  	}
  	return resp, nil
  }

  // getFilterDropdownConfig returns dropdown menu for the provided filter field.

  func getFilterDropdownConfig(db *ora.Ses, filtersField string) (Dropdown, error) {
  	var resp Dropdown
  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		FILTERS_FIELD, OBJECT_TYPE, ID_FIELD, LABEL_FIELD
  		FROM LIST_DROPDOWN_FILTER
  		WHERE FILTERS_FIELD = '` + filtersField + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S, ora.S)
  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	if rset.Next() {
  		resp.FiltersField = rset.Row[0].(string)
  		resp.ObjectType = rset.Row[1].(string)

  		resp.IDField = rset.Row[2].(string)

  		resp.LabelField = rset.Row[3].(string)
  	}

  	if rset.Err() != nil {
  		return resp, rset.Err()

  	}
  	return resp, nil
  }

  // sortFilters bubble sorts provided filters slice by position field.

  func sortFilters(filters []ListFilter) {
  	done := false
  	var temp ListFilter
  	for !done {
  		done = true
  		for i := 0; i < len(filters) - 1; i++ {
  			if filters[i].Position > filters[i+1].Position {
  				done = false
  				temp = filters[i]
  				filters[i] = filters[i+1]
  				filters[i+1] = temp
  			}
  		}
  	}
  }

  // getListGraph return list graph slice for the provided object type.

  func getListGraph(db *ora.Ses, objType string) ([]ListGraph, error) {
  	resp := make([]ListGraph, 0)
  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		OBJECT_TYPE, X_FIELD, Y_FIELD, GROUP_FIELD, LABEL
  		FROM LIST_GRAPHS
  		WHERE OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S, ora.S)
  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	for rset.Next() {
  		resp = append(resp, ListGraph{
  			ObjectType: rset.Row[0].(string),
  			X: rset.Row[1].(string),
  			Y: rset.Row[2].(string),
  			GroupField: rset.Row[3].(string),
  			Label: rset.Row[4].(string),
  		})
  	}

  	if rset.Err() != nil {
  		return resp, rset.Err()

  	}
  	return resp, nil
  }

  // getListOptions returns list options for the provided object type.

  func getListOptions(db *ora.Ses, objType string) (ListOptions, error) {
  	var resp ListOptions
  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		GLOBAL_FILTER, LOCAL_FILTER, REMOTE_FILTER, PAGINATION, 

  		PAGE_SIZE, PIVOT, DETAIL, TOTAL

  		FROM LIST_CONFIG
  		WHERE OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.U32, ora.U32, ora.U32, ora.U32,

  		ora.U64, ora.U64, ora.U32, ora.U32)

  	if err != nil {
  		return ListOptions{}, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return ListOptions{}, err
  	}
  	if rset.Next() {
  		resp.GlobalFilter = rset.Row[0].(uint32) != 0
  		resp.LocalFilters = rset.Row[1].(uint32) != 0
  		resp.RemoteFilters = rset.Row[2].(uint32) != 0
  		resp.Pagination = rset.Row[3].(uint32) != 0
  		resp.PageSize = rset.Row[4].(uint64)
  		resp.Pivot = rset.Row[5].(uint64) != 0
  		resp.Detail = rset.Row[6].(uint32) != 0

  		resp.Total = rset.Row[7].(uint32) != 0

  	}

  	if rset.Err() != nil {
  		return ListOptions{}, rset.Err()

  	}
  	return resp, nil
  }

  // getListParent returns list parent node slice for the provided object type.

  func getListParent(db *ora.Ses, objType string) ([]ListParentNode, error) {
  	resp := make([]ListParentNode, 0)
  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		PARENT_OBJECT_TYPE, PARENT_LABEL_FIELD, PARENT_FILTER_FIELD
  		FROM LIST_CONFIG_CHILD
  		WHERE OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S)
  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	for rset.Next() {
  		resp = append(resp, ListParentNode{
  			ObjectType: rset.Row[0].(string),
  			LabelField: rset.Row[1].(string),
  			FilterField: rset.Row[2].(string),
  		})
  	}

  	if rset.Err() != nil {
  		return nil, rset.Err()

  	}
  
  	return resp, nil
  }

  // getListPivot list pivot slice for the provided object type.

  func getListPivot(db *ora.Ses, objType string) ([]ListPivot, error) {
  	resp := make([]ListPivot, 0)
  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		OBJECT_TYPE, GROUP_FIELD, DISTINCT_FIELD, VALUE_FIELD
  		FROM LIST_PIVOTS
  		WHERE OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S, ora.S)
  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	for rset.Next() {
  		resp = append(resp, ListPivot{
  			ObjectType: rset.Row[0].(string),
  			GroupField: rset.Row[1].(string),
  			DistinctField: rset.Row[2].(string),
  			Value: rset.Row[3].(string),
  		})
  	}

  	if rset.Err() != nil {
  		return nil, rset.Err()

  	}
  
  	return resp, nil
  }

  // getListDetails returns list details for the provided object type.

  func getListDetails(db *ora.Ses, objType string) (ListDetails, error) {
  	var resp ListDetails
  	var err error
  	var stmt *ora.Stmt
  	query := `SELECT 
  		OBJECT_TYPE, PARENT_OBJECT_TYPE, PARENT_FILTER_FIELD, SINGLE_DETAIL
  		FROM LIST_CONFIG_DETAIL
  		WHERE PARENT_OBJECT_TYPE = '` + objType + `'`
  
  	stmt, err = db.Prep(query, ora.S, ora.S, ora.S, ora.U32)
  	if err != nil {
  		return resp, err
  	}
  	defer stmt.Close()
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return resp, err
  	}
  	if rset.Next() {
  		resp.ObjectType = rset.Row[0].(string)
  		resp.ParentObjectType = rset.Row[1].(string)
  		resp.ParentFilterField = rset.Row[2].(string)
  		resp.SingleDetail = rset.Row[3].(uint32) != 0
  	}

  	if rset.Err() != nil {
  		return resp, rset.Err()

  	}
  
  	return resp, nil
  }