// Copyright 2019 Yunion
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package models

import (
	"context"
	"database/sql"

	"yunion.io/x/jsonutils"
	"yunion.io/x/log"
	"yunion.io/x/pkg/errors"
	"yunion.io/x/pkg/util/reflectutils"
	"yunion.io/x/sqlchemy"

	api "yunion.io/x/onecloud/pkg/apis/compute"
	"yunion.io/x/onecloud/pkg/cloudcommon/db"
	"yunion.io/x/onecloud/pkg/httperrors"
	"yunion.io/x/onecloud/pkg/mcclient"
	"yunion.io/x/onecloud/pkg/util/stringutils2"
)

type SSecurityGroupResourceBase struct {
	// 本地安全组ID
	SecgroupId string `width:"36" charset:"ascii" nullable:"false" create:"required"  index:"true" list:"user" json:"secgroup_id"`
}

type SSecurityGroupResourceBaseManager struct {
	SCloudregionResourceBaseManager
	SManagedResourceBaseManager
}

func ValidateSecurityGroupResourceInput(ctx context.Context, userCred mcclient.TokenCredential, query api.SecgroupResourceInput) (*SSecurityGroup, api.SecgroupResourceInput, error) {
	secgrpObj, err := SecurityGroupManager.FetchByIdOrName(ctx, userCred, query.SecgroupId)
	if err != nil {
		if err == sql.ErrNoRows {
			return nil, query, errors.Wrapf(httperrors.ErrResourceNotFound, "%s %s", SecurityGroupManager.Keyword(), query.SecgroupId)
		} else {
			return nil, query, errors.Wrap(err, "SecurityGroupManager.FetchByIdOrName")
		}
	}
	query.SecgroupId = secgrpObj.GetId()
	return secgrpObj.(*SSecurityGroup), query, nil
}

func (self *SSecurityGroupResourceBase) GetSecGroup() (*SSecurityGroup, error) {
	secgrp, err := SecurityGroupManager.FetchById(self.SecgroupId)
	if err != nil {
		return nil, errors.Wrapf(err, "FetchById %s", self.SecgroupId)
	}
	return secgrp.(*SSecurityGroup), nil
}

func (manager *SSecurityGroupResourceBaseManager) FetchCustomizeColumns(
	ctx context.Context,
	userCred mcclient.TokenCredential,
	query jsonutils.JSONObject,
	objs []interface{},
	fields stringutils2.SSortedStrings,
	isList bool,
) []api.SecurityGroupResourceInfo {
	rows := make([]api.SecurityGroupResourceInfo, len(objs))
	secgrpIds := make([]string, len(objs))
	for i := range objs {
		var base *SSecurityGroupResourceBase
		err := reflectutils.FindAnonymouStructPointer(objs[i], &base)
		if err != nil {
			log.Errorf("Cannot find SSecurityGroupResourceBase in object %s", objs[i])
			continue
		}
		secgrpIds[i] = base.SecgroupId
	}

	groups := make(map[string]SSecurityGroup)
	err := db.FetchStandaloneObjectsByIds(SecurityGroupManager, secgrpIds, groups)
	if err != nil {
		log.Errorf("FetchStandaloneObjectsByIds fail %s", err)
		return nil
	}

	regionList := make([]interface{}, len(rows))
	managerList := make([]interface{}, len(rows))
	for i := range rows {
		rows[i] = api.SecurityGroupResourceInfo{}
		if group, ok := groups[secgrpIds[i]]; ok {
			rows[i].Secgroup = group.Name
			rows[i].CloudregionId = group.CloudregionId
			rows[i].ManagerId = group.ManagerId
		}
		regionList[i] = &SCloudregionResourceBase{rows[i].CloudregionId}
		managerList[i] = &SManagedResourceBase{rows[i].ManagerId}
	}

	regionRows := manager.SCloudregionResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, regionList, fields, isList)
	managerRows := manager.SManagedResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, managerList, fields, isList)

	for i := range rows {
		rows[i].CloudregionResourceInfo = regionRows[i]
		rows[i].ManagedResourceInfo = managerRows[i]
	}

	return rows
}

func (manager *SSecurityGroupResourceBaseManager) ListItemFilter(
	ctx context.Context,
	q *sqlchemy.SQuery,
	userCred mcclient.TokenCredential,
	query api.SecgroupFilterListInput,
) (*sqlchemy.SQuery, error) {
	if len(query.SecgroupId) > 0 {
		secgrpObj, _, err := ValidateSecurityGroupResourceInput(ctx, userCred, query.SecgroupResourceInput)
		if err != nil {
			return nil, errors.Wrap(err, "ValidateSecurityGroupResourceInput")
		}
		q = q.Equals("secgroup_id", secgrpObj.GetId())
	}

	if len(query.SecgroupName) > 0 {
		sq := SecurityGroupManager.Query("id").Like("name", "%"+query.SecgroupName+"%")
		q = q.In("secgroup_id", sq.SubQuery())
	}

	var err error
	subq := SecurityGroupManager.Query("id").Snapshot()
	subq, err = manager.SManagedResourceBaseManager.ListItemFilter(ctx, subq, userCred, query.ManagedResourceListInput)
	if err != nil {
		return nil, errors.Wrap(err, "SManagedResourceBaseManager.ListItemFilter")
	}

	subq, err = manager.SCloudregionResourceBaseManager.ListItemFilter(ctx, subq, userCred, query.RegionalFilterListInput)
	if err != nil {
		return nil, errors.Wrap(err, "SCloudregionResourceBaseManager.ListItemFilter")
	}
	if subq.IsAltered() {
		q = q.Filter(sqlchemy.In(q.Field("secgroup_id"), subq.SubQuery()))
	}

	return q, nil
}

func (manager *SSecurityGroupResourceBaseManager) OrderByExtraFields(
	ctx context.Context,
	q *sqlchemy.SQuery,
	userCred mcclient.TokenCredential,
	query api.SecgroupFilterListInput,
) (*sqlchemy.SQuery, error) {
	if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
		return q, nil
	}
	orderQ := SecurityGroupManager.Query("id")
	orderSubQ := orderQ.SubQuery()
	orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
	q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("secgroup_id"), orderSubQ.Field("id")))
	q = db.OrderByFields(q, orders, fields)
	return q, nil
}

func (manager *SSecurityGroupResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
	if field == "secgroup" {
		secgrpQuery := SecurityGroupManager.Query("name", "id").Distinct().SubQuery()
		q.AppendField(secgrpQuery.Field("name", field))
		q = q.Join(secgrpQuery, sqlchemy.Equals(q.Field("secgroup_id"), secgrpQuery.Field("id")))
		q.GroupBy(secgrpQuery.Field("name"))
		return q, nil
	}
	return q, httperrors.ErrNotFound
}

func (manager *SSecurityGroupResourceBaseManager) GetOrderBySubQuery(
	q *sqlchemy.SQuery,
	subq *sqlchemy.SSubQuery,
	joinField sqlchemy.IQueryField,
	userCred mcclient.TokenCredential,
	query api.SecgroupFilterListInput,
	orders []string,
	fields []sqlchemy.IQueryField,
) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
	if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
		return q, orders, fields
	}
	secgrpQ := SecurityGroupManager.Query().SubQuery()
	q = q.LeftJoin(secgrpQ, sqlchemy.Equals(joinField, secgrpQ.Field("id")))
	q = q.AppendField(secgrpQ.Field("name").Label("secgroup"))
	orders = append(orders, query.OrderBySecgroup)
	fields = append(fields, subq.Field("secgroup"))
	return q, orders, fields
}

func (manager *SSecurityGroupResourceBaseManager) GetOrderByFields(query api.SecgroupFilterListInput) []string {
	return []string{query.OrderBySecgroup}
}

func (manager *SSecurityGroupResourceBaseManager) ListItemExportKeys(ctx context.Context,
	q *sqlchemy.SQuery,
	userCred mcclient.TokenCredential,
	keys stringutils2.SSortedStrings,
) (*sqlchemy.SQuery, error) {
	if keys.ContainsAny(manager.GetExportKeys()...) {
		subq := SecurityGroupManager.Query("id", "name").SubQuery()
		q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("secgroup_id"), subq.Field("id")))
		q = q.AppendField(subq.Field("name", "secgroup"))
	}
	return q, nil
}

func (manager *SSecurityGroupResourceBaseManager) GetExportKeys() []string {
	return []string{"secgroup"}
}