package webutility

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

  
  type SelectConfig struct {
  	ListObjType string `json:"listObjectType"`
  	ObjType     string `json:"objectType"`
  	Type        string `json:"type"`
  	IdField     string `json:"idField"`
  	LabelField  string `json:"labelField"`
  	ValueField  string `json:"valueField"`
  }

  // GetSelectConfig returns select configuration slice for the given object type.

  func GetSelectConfig(db *ora.Ses, otype string) ([]SelectConfig, error) {
  	resp := make([]SelectConfig, 0)
  	var err error
  	var stmt *ora.Stmt

  	query := `SELECT
  		a.LIST_OBJECT_TYPE,
  		a.OBJECT_TYPE,
  		a.ID_FIELD,
  		a.LABEL_FIELD,
  		a.TYPE,
  		b.FIELD

  		FROM LIST_SELECT_CONFIG a, LIST_VALUE_FIELD b
  		WHERE a.LIST_OBJECT_TYPE` + otype + `
  		AND b.LIST_TYPE = a.LIST_OBJECT_TYPE
  		AND b.OBJECT_TYPE = a.OBJECT_TYPE`

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

  	defer stmt.Close()
  	if err != nil {
  		return nil, err
  	}
  
  	rset, err := stmt.Qry()
  	if err != nil {
  		return nil, err
  	}
  	for rset.Next() {
  		resp = append(resp, SelectConfig{
  			ListObjType: rset.Row[0].(string),

  			ObjType:     rset.Row[1].(string),
  			IdField:     rset.Row[2].(string),
  			LabelField:  rset.Row[3].(string),
  			Type:        rset.Row[4].(string),
  			ValueField:  rset.Row[5].(string),

  		})
  	}

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

  	}
  
  	return resp, nil

  }