//go:build crm

package crm

import (
	"context"
	"net/http"
	"reflect"
	"testing"

	dialectsfcrm "github.com/nexuscrm/dialect-sf-crm"
	"github.com/nexuscrm/shared/pkg/contract"
	"github.com/nexuscrm/shared/pkg/dialect"
	"github.com/nexuscrm/shared/pkg/models"
	"github.com/nexuscrm/shared/pkg/queryspec"
)

func TestCRMQueryRouteReturnsOpportunityGroupedCountAndSum(t *testing.T) {
	query := &multiAggregateRouteQuery{
		result: &contract.QueryResult{
			TotalSize:   1,
			Done:        true,
			IsAggregate: true,
			Records: []contract.Record{{
				"StageName": "Prospecting",
				"c":         int64(2),
				"s":         float64(125.5),
			}},
		},
	}

	resp, err := dialectsfcrm.QueryNeutralHandler(context.Background(), &dialect.Request{
		Version: "v63.0",
		User:    &models.UserSession{ID: "005-route"},
		Query: map[string][]string{
			"q": {"SELECT StageName, COUNT(Id) c, SUM(Amount) s FROM Opportunity GROUP BY StageName"},
		},
	}, dialect.Deps{Contracts: contract.Deps{Query: query}})
	if err != nil {
		t.Fatalf("QueryNeutralHandler: %v", err)
	}
	if resp.Status != http.StatusOK {
		t.Fatalf("status = %d body=%#v, want 200", resp.Status, resp.Body)
	}

	if query.req.ObjectAPIName != "Opportunity" {
		t.Fatalf("query object = %q, want Opportunity", query.req.ObjectAPIName)
	}
	if query.req.GroupBy != "StageName" {
		t.Fatalf("query groupBy = %q, want StageName", query.req.GroupBy)
	}
	wantSelect := []string{"StageName", "COUNT(Id) c", "SUM(Amount) s"}
	if !reflect.DeepEqual(query.req.SelectFields, wantSelect) {
		t.Fatalf("query select fields = %#v, want %#v", query.req.SelectFields, wantSelect)
	}

	body, ok := resp.Body.(map[string]any)
	if !ok {
		t.Fatalf("response body = %T, want map[string]any", resp.Body)
	}
	records, ok := body["records"].([]interface{})
	if !ok || len(records) != 1 {
		t.Fatalf("records = %#v, want one row", body["records"])
	}
	var row map[string]any
	switch value := records[0].(type) {
	case map[string]any:
		row = value
	case models.SObject:
		// The neutral contract may retain its named record-map carrier until the
		// HTTP encoder boundary. Both carriers serialize to the same JSON object;
		// this test owns the public shape, not an in-process concrete map type.
		row = map[string]any(value)
	default:
		t.Fatalf("record row = %T, want JSON object", records[0])
	}
	if row["StageName"] != "Prospecting" || row["c"] != int64(2) || row["s"] != float64(125.5) {
		t.Fatalf("aggregate row = %#v, want StageName/c/s values", row)
	}
	attrs, ok := row["attributes"].(map[string]any)
	if !ok {
		t.Fatalf("attributes = %#v, want map[string]any", row["attributes"])
	}
	if attrs["type"] != "AggregateResult" {
		t.Fatalf("attributes.type = %#v, want AggregateResult", attrs["type"])
	}
	if _, hasURL := attrs["url"]; hasURL {
		t.Fatalf("AggregateResult attributes included url: %#v", attrs)
	}
}

type multiAggregateRouteQuery struct {
	req    queryspec.QuerySpec
	result *contract.QueryResult
}

func (q *multiAggregateRouteQuery) Query(_ context.Context, req queryspec.QuerySpec, _ *models.UserSession) (*contract.QueryResult, error) {
	q.req = req
	return q.result, nil
}

func (*multiAggregateRouteQuery) SearchWithSpec(context.Context, queryspec.SearchSpec, *models.UserSession) ([]contract.Record, error) {
	return nil, nil
}

func (*multiAggregateRouteQuery) GlobalSearchWithSpec(context.Context, queryspec.GlobalSearchSpec, *models.UserSession) ([]contract.SearchResult, error) {
	return nil, nil
}

func (*multiAggregateRouteQuery) QueryHistory(context.Context, contract.HistoryQueryRequest, *models.UserSession) (*contract.HistoryQueryResult, error) {
	return nil, nil
}