supplier_system/src/dashoo.cn/backend/api/controllers/oilsupplier/todolist.go

package oilsupplier

import (
	"dashoo.cn/backend/api/business/oilsupplier/annualaudit"
	"dashoo.cn/backend/api/business/oilsupplier/infochange"
	"dashoo.cn/backend/api/business/oilsupplier/supplier"
	"dashoo.cn/backend/api/business/oilsupplier/suppliercertappend"
	"dashoo.cn/backend/api/business/register"
	"dashoo.cn/backend/api/business/todolist"
	"dashoo.cn/backend/api/business/workflow"
	. "dashoo.cn/backend/api/controllers"
	"dashoo.cn/utils"
	"fmt"
	"sort"
	"strconv"
	"strings"
)

type TodoListController struct {
	BaseController
}

// @Title 获取列表
// @Description get user by token
// @Success 200 {object} []supplier.OilSupplierView
// @router /gettodolist [get]
func (this *TodoListController) GetMyTaskEntityList() {
	var todolists []todolist.TodoList


	page := this.GetPageInfoForm()
	where := " 1=1 "
	orderby := "Id"
	asc := false
	Order := this.GetString("Order")
	where = where + " and b.Status>0"
	Prop := this.GetString("Prop")
	if Order != "" && Prop != "" {
		orderby = Prop
		if Order == "asc" {
			asc = true
		}
	}

	stype := this.GetString("Type")
	supplierTypeCode := this.GetString("SupplierTypeCode")
	supplierName := this.GetString("SupplierName")

	if supplierTypeCode != "" {
		where = where + " and b.SupplierTypeCode = '" + supplierTypeCode + "'"
	}

	if supplierName != "" {
		where = where + " and a.SupplierName like '%" + supplierName + "%'"
	}
	actisvc := workflow.GetActivitiService(utils.DBE)

	svc := supplier.GetOilSupplierService(utils.DBE)
	var myTasksRetWithTimes []workflow.ActiMyTasksRetWithTimeVM
	if stype == "1" || stype == "" {
		var todo todolist.TodoList
		//找出待办任务===准入
		var certIdList string
		myTasksRetWithTimes = actisvc.GetMyTasksWithTime(workflow.OIL_SUPPLIER_APPLY, this.User.Id)
		ids := actisvc.GetMyTasks(workflow.OIL_SUPPLIER_APPLY, this.User.Id)
		if len(strings.Trim(ids, ",")) > 0 {
			certIdList += strings.Trim(ids, ",")+ ","
		}

		arr := actisvc.GetMyTasksWithTime(workflow.OIL_FIRST_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_FIRST_SUPPLIER_APPLY, this.User.Id)
		if len(strings.Trim(ids, ",")) > 0 {
			certIdList += strings.Trim(ids, ",")+ ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_SECOND_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_SECOND_SUPPLIER_APPLY, this.User.Id)
		if len(strings.Trim(ids, ",")) > 0 {
			certIdList += strings.Trim(ids, ",")+ ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_ENUSER_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_ENUSER_SUPPLIER_APPLY, this.User.Id)
		if len(strings.Trim(ids, ",")) > 0 {
			certIdList += strings.Trim(ids, ",")+ ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_FIRST_ENUSER_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_FIRST_ENUSER_SUPPLIER_APPLY, this.User.Id)
		if len(strings.Trim(ids, ",")) > 0 {
			certIdList += strings.Trim(ids, ",")+ ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_SECOND_ENUSER_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_SECOND_ENUSER_SUPPLIER_APPLY, this.User.Id)
		if len(strings.Trim(ids, ",")) > 0 {
			certIdList += strings.Trim(ids, ",")+ ","
		}

		certIdList = strings.Trim(certIdList, ",")
		certIdarr := strings.Split(certIdList, ",")
		for i, item := range certIdarr {
			idx := strings.Index(item, "-")
			if idx >= 0 {
				certIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		fmt.Println(myTasksRetWithTimes)
		certIdList = strings.Join(certIdarr, ",")
		var list []supplier.OilSupplierView
		if certIdList != "" {
			where += " and b.Id in (" + certIdList + ")"
			svc.GetMyPagingEntitiesWithOrderBytbl(OilSupplierName, OilSupplierCertName, page.CurrentPage, page.Size, orderby, asc, &list, where)
			for _, item := range list {
				todo.Id = item.Id
				todo.CertId = item.CertId
				todo.SupplierTypeCode = item.SupplierTypeCode
				todo.Type = todolist.SUPPLIER
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.Status = item.Status
				todo.BusinessKey = item.BusinessKey
				todo.WorkflowId = item.WorkflowId
				todolists = append(todolists, todo)
			}
		}

	}
	if stype == "2" || stype == "" {
		//找出待办任务 -- 增项
		whereapp := "1=1"
		whereapp = whereapp + " and b.Status>0"

		var appendIdList string

		arr := actisvc.GetMyTasksWithTime(workflow.OIL_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids := actisvc.GetMyTasks(workflow.OIL_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = ids
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_FIRST_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_FIRST_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_SECOND_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_SECOND_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_ENUSER_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_ENUSER_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_FIRST_ENUSER_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_FIRST_ENUSER_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyTasksWithTime(workflow.OIL_SECOND_ENUSER_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetMyTasks(workflow.OIL_SECOND_ENUSER_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		appendIdarr := strings.Split(appendIdList, ",")
		for i, item := range appendIdarr {
			idx := strings.Index(item,"-")
			if (idx >= 0 ) {
				appendIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		appendIdList = strings.Join(appendIdarr, ",")
		appendIdList = strings.Trim(appendIdList, ",")
		var listapp []suppliercertappend.OilSupplierCertAppendTodo
		svcapp := suppliercertappend.GetOilSupplierCertAppendService(utils.DBE)
		var todo todolist.TodoList
		if appendIdList != "" {
			whereapp += " and b.Id in (" + appendIdList + ")"
			svcapp.GetMyPagingEntitiesWithOrderBytbl(OilSupplierName, OilSupplierCertAppendName, page.CurrentPage, page.Size, orderby, asc, &listapp, whereapp)
			for _, item := range listapp {
				todo.Id = item.Id
				todo.Type = todolist.CERTAPPEND
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.SupplierTypeCode = item.AppendType
				todo.Status = item.Status
				todo.BusinessKey = item.BusinessKey
				todo.WorkflowId = item.WorkFlowId
				todolists = append(todolists, todo)
			}
		}
	}
	if stype == "3" || stype == "" {
		//  待办--年审
		whereannu := "1=1"
		if supplierName != "" {
			whereannu = whereannu + " and SupplierName like '%" + supplierName + "%'"
		}

		arr := actisvc.GetMyTasksWithTime(workflow.OIL_AUDIT_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		var listannu []annualaudit.OilAnnualAudit
		annuIdList := actisvc.GetMyTasks(workflow.OIL_AUDIT_APPLY, this.User.Id)
		annuIdarr := strings.Split(annuIdList, ",")
		for i, item := range annuIdarr {
			idx := strings.Index(item, "-")
			if idx >= 0 {
				annuIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		annuIdList = strings.Join(annuIdarr, ",")
		if annuIdList != "" {
			whereannu += " and Id in (" + annuIdList + ")"
			//根据部门查询待办任务
			whereannu += " and Status > 0 "
			svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &listannu, whereannu)

			var todo todolist.TodoList
			for _, item := range listannu {
				todo.Id = item.Id
				todo.SupplierId = strconv.Itoa(item.SupplierId)
				todo.Type = todolist.ANNUALAUDIT
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.SupplierTypeCode = item.SupplierTypeName
				todo.Step = strconv.Itoa(item.Step)
				todo.WorkflowId = item.WorkflowId
				todo.Status = item.Status
				todo.CertId = strconv.Itoa(item.CerId)
				todo.BusinessKey = item.BusinessKey
				todo.WorkflowId = item.WorkflowId
				todolists = append(todolists, todo)
			}
		}
	}
	if stype == "4" || stype == "" {
		// 待办 ----- 信息变更
		var listInfo []infochange.OilInfoChange
		whereInfo := "1=1"
		if supplierName != "" {
			whereInfo = where + " and SupplierName like '%" + supplierName + "%'"
		}
		arr := actisvc.GetMyTasksWithTime(workflow.OIL_INFO_CHANGE, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		infoList := actisvc.GetMyTasks(workflow.OIL_INFO_CHANGE, this.User.Id)
		infoIdarr := strings.Split(infoList, ",")
		for i, item := range infoIdarr {
			idx := strings.Index(item, "-")
			if (idx >= 0) {
				infoIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		infoList = strings.Join(infoIdarr, ",")
		var todo todolist.TodoList
		if infoList != "" {
			whereInfo += " and Id in (" + infoList + ")"
			svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &listInfo, whereInfo)
			for _, item := range listInfo {
				todo.Id = item.Id
				todo.Type = todolist.INFOCHANGE
				todo.SupplierId = strconv.Itoa(item.SupplierId)
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.SupplierTypeCode = item.SupplierTypeName
				todo.Status = item.Status
				todo.BusinessKey = item.BusinessKey//strconv.Itoa(item.Id) + "-"+ strconv.Itoa(item.AuditIndex)
				todo.WorkflowId = item.WorkFlowId
				todolists = append(todolists, todo)
			}
		}
	}
	//if stype == "5" || stype == "" {
	//	// 资质变更
	//	arr := actisvc.GetMyTasksWithTime(workflow.OIL_QUAL_CHANGE, this.User.Id)
	//	for _,s := range arr {
	//		myTasksRetWithTimes = append(myTasksRetWithTimes, s)
	//	}
	//	var listqual []qualchange.OilQualChangeMain
	//	qualList := actisvc.GetMyTasks(workflow.OIL_QUAL_CHANGE, this.User.Id)
	//	qualIdarr := strings.Split(qualList, ",")
	//	for i, item := range qualIdarr {
	//		idx := strings.Index(item, "-")
	//		if idx >= 0 {
	//			qualIdarr[i] = strings.Split(item, "-")[0]
	//		}
	//	}
	//	qualList = strings.Join(qualIdarr, ",")
	//	wherequal := "1=1 "
	//
	//	if supplierName != "" {
	//		wherequal = wherequal + " and SupplierName like '%" + supplierName + "%'"
	//	}
	//	if qualList != "" {
	//		wherequal += " and Id in (" + qualList + ")"
	//		wherequal += " and Status > 0 "
	//		svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &listqual, wherequal)
	//		var todo todolist.TodoList
	//		for _, item := range listqual {
	//			todo.Id = item.Id
	//			todo.CertId = strconv.Itoa(item.SupplierCertId)
	//			todo.SupplierId = strconv.Itoa(item.SupplierId)
	//			todo.Type = todolist.QUALCHANGE
	//			todo.SupplierName = item.SupplierName
	//			todo.UserName = this.User.Realname
	//			todo.SupplierTypeCode = "0"
	//			todo.Status = item.Status
	//			todo.BusinessKey = strconv.Itoa(item.Id) + "-"+ strconv.Itoa(item.AuditIndex)
	//			todolists = append(todolists, todo)
	//		}
	//	}
	//}
	if stype == "6" || stype == "" {
		where := " CheckStatus=0 "
		if supplierName != "" {
			where = where + " and SupplierName like '%" + supplierName + "%' "
		}

		where = where + " and CheckUserId like '%" + this.User.Id + "%' "

		svc := register.GetOilCorporateInfoService(utils.DBE)
		var list []register.OilCorporateInfo
		_, list = svc.GetCompanyListByWhere(page.CurrentPage, page.Size, "Id desc", "OilCorporateInfo", where)
		var todo todolist.TodoList
		for _, item := range list {
			todo.Id = item.Id
			todo.Type = todolist.REGISTER
			todo.SupplierName = item.SupplierName
			todo.UserName = this.User.Realname
			todo.Status = strconv.Itoa(item.CheckStatus)
			todo.CreateTime = item.CreateOn.Unix() * 1000
			todolists = append(todolists, todo)
		}
	}
	for i,todo := range todolists {
		for _,myTasksRetWithTime := range myTasksRetWithTimes {
			if todo.BusinessKey == myTasksRetWithTime.BusinessKey && todo.WorkflowId == myTasksRetWithTime.WorkflowId {
				todolists[i].CreateTime = myTasksRetWithTime.CreateTime
			}
		}
	}

	sort.Slice(todolists, func(i, j int) bool {
		return todolists[i].CreateTime > todolists[j].CreateTime
	})

	var datainfo DataInfo
	datainfo.Items = todolists
	this.Data["json"] = &datainfo
	this.ServeJSON()
	//this.SetUserDeptId()
}

// @Title 获取已办列表
// @Description get user by token
// @Success 200 {object} []supplier.OilSupplierView
// @router /getmytaskfinishedlist [get]
func (this *TodoListController) GetMyTaskFinishedList() {
	var todolists []todolist.TodoList
	var todo todolist.TodoList

	page := this.GetPageInfoForm()
	where := " 1=1 "
	orderby := "Id"
	asc := false
	Order := this.GetString("Order")
	where = where + " and b.Status>0"
	Prop := this.GetString("Prop")
	if Order != "" && Prop != "" {
		orderby = Prop
		if Order == "asc" {
			asc = true
		}
	}

	stype := this.GetString("Type")
	supplierTypeCode := this.GetString("SupplierTypeCode")
	supplierName := this.GetString("SupplierName")

	if supplierTypeCode != "" {
		where = where + " and b.SupplierTypeCode = '" + supplierTypeCode + "'"
	}

	if supplierName != "" {
		where = where + " and a.SupplierName like '%" + supplierName + "%'"
	}

	actisvc := workflow.GetActivitiService(utils.DBE)
	svc := supplier.GetOilSupplierService(utils.DBE)
	var myTasksRetWithTimes []workflow.ActiMyTasksRetWithTimeVM
	if stype == "1" || stype == "" {
		//已办任务===准入
		var certIdList string
		myTasksRetWithTimes = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_SUPPLIER_APPLY, this.User.Id)
		ids := actisvc.GetHistoryMyTasks(workflow.OIL_SUPPLIER_APPLY, this.User.Id)
		if ids != "" {
			certIdList = ids
			certIdList = certIdList + ","
		}

		arr := actisvc.GetMyFinishedTasksWithTime(workflow.OIL_FIRST_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_FIRST_SUPPLIER_APPLY, this.User.Id)
		if ids != "" {
			certIdList = fmt.Sprintf("%s %s", certIdList, ids)
			certIdList = certIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_SECOND_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_SECOND_SUPPLIER_APPLY, this.User.Id)
		if ids != "" {
			certIdList = fmt.Sprintf("%s %s", certIdList, ids)
			certIdList = certIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_ENUSER_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_ENUSER_SUPPLIER_APPLY, this.User.Id)
		if ids != "" {
			certIdList = fmt.Sprintf("%s %s", certIdList, ids)
			certIdList = certIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_FIRST_ENUSER_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_FIRST_ENUSER_SUPPLIER_APPLY, this.User.Id)
		if ids != "" {
			certIdList = fmt.Sprintf("%s %s", certIdList, ids)
			certIdList = certIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_SECOND_ENUSER_SUPPLIER_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_SECOND_ENUSER_SUPPLIER_APPLY, this.User.Id)
		if ids != "" {
			certIdList = fmt.Sprintf("%s %s", certIdList, ids)
			certIdList = certIdList + ","
		}
		certIdList = strings.Trim(certIdList, ",")
		certIdarr := strings.Split(certIdList, ",")
		for i, item := range certIdarr {
			idx := strings.Index(item, "-")
			if idx >= 0 {
				certIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		certIdList = strings.Join(certIdarr, ",")
		var list []supplier.OilSupplierView
		if certIdList != "" {
			where += " and b.Id in (" + certIdList + ")"
			svc.GetMyPagingEntitiesWithOrderBytbl(OilSupplierName, OilSupplierCertName, page.CurrentPage, page.Size, orderby, asc, &list, where)
			for _, item := range list {
				todo.Id = item.Id
				todo.CertId = item.CertId
				todo.SupplierTypeCode = item.SupplierTypeCode
				todo.Type = todolist.SUPPLIER
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.Status = item.Status
				todo.BusinessKey = item.BusinessKey
				todo.WorkflowId = item.WorkflowId
				todolists = append(todolists, todo)
			}
		}
	}
	if stype == "2" || stype == "" {
		//已办任务 -- 增项
		whereapp := "1=1"
		whereapp = whereapp + " and b.Status>0"

		var appendIdList string
		arr := actisvc.GetMyFinishedTasksWithTime(workflow.OIL_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids := actisvc.GetHistoryMyTasks(workflow.OIL_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = ids
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_FIRST_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_FIRST_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_SECOND_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_SECOND_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_ENUSER_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_ENUSER_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_FIRST_ENUSER_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_FIRST_ENUSER_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}

		arr = actisvc.GetMyFinishedTasksWithTime(workflow.OIL_SECOND_ENUSER_APPEND_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		ids = actisvc.GetHistoryMyTasks(workflow.OIL_SECOND_ENUSER_APPEND_APPLY, this.User.Id)
		if ids != "" {
			appendIdList = fmt.Sprintf("%s %s", appendIdList, ids)
			appendIdList = appendIdList + ","
		}


		appendIdarr := strings.Split(appendIdList, ",")
		for i, item := range appendIdarr {
			idx := strings.Index(item, "-")
			if (idx >= 0) {
				appendIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		appendIdList = strings.Join(appendIdarr, ",")
		appendIdList = strings.Trim(appendIdList, ",")
		var listapp []suppliercertappend.OilSupplierCertAppendTodo
		svcapp := suppliercertappend.GetOilSupplierCertAppendService(utils.DBE)
		if appendIdList != "" {
			whereapp += " and b.Id in (" + appendIdList + ")"
			svcapp.GetMyPagingEntitiesWithOrderBytbl(OilSupplierName, OilSupplierCertAppendName, page.CurrentPage, page.Size, orderby, asc, &listapp, whereapp)
			for _, item := range listapp {
				todo.Id = item.Id
				todo.Type = todolist.CERTAPPEND
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.SupplierTypeCode = item.AppendType
				todo.Status = item.Status
				todo.BusinessKey = item.BusinessKey
				todo.WorkflowId = item.WorkFlowId
				todolists = append(todolists, todo)
			}
		}
	}
	if stype == "3" || stype == "" {
		//  已办--年审
		whereannu := "1=1"
		if supplierName != "" {
			whereannu = whereannu + " and SupplierName like '%" + supplierName + "%'"
		}
		var listannu []annualaudit.OilAnnualAudit
		arr := actisvc.GetMyFinishedTasksWithTime(workflow.OIL_AUDIT_APPLY, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		annuIdList := actisvc.GetHistoryMyTasks(workflow.OIL_AUDIT_APPLY, this.User.Id)
		annuIdarr := strings.Split(annuIdList, ",")
		for i, item := range annuIdarr {
			idx := strings.Index(item, "-")
			if idx >= 0 {
				annuIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		annuIdList = strings.Join(annuIdarr, ",")
		if annuIdList != "" {
			whereannu += " and Id in (" + annuIdList + ")"
			//根据部门查询待办任务
			whereannu += " and Status != 2 "
			svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &listannu, whereannu)

			for _, item := range listannu {
				todo.Id = item.Id
				todo.SupplierId = strconv.Itoa(item.SupplierId)
				todo.Type = todolist.ANNUALAUDIT
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.SupplierTypeCode = item.SupplierTypeName
				todo.Step = strconv.Itoa(item.Step)
				todo.WorkflowId = item.WorkflowId
				todo.Status = item.Status
				todo.CertId = strconv.Itoa(item.CerId)
				todo.BusinessKey = item.BusinessKey
				todolists = append(todolists, todo)
			}
		}
	}
	if stype == "4" || stype == "" {
		// 已办 ----- 信息变更
		var listInfo []infochange.OilInfoChange
		whereInfo := "1=1"
		if supplierName != "" {
			whereInfo = where + " and SupplierName like '%" + supplierName + "%'"
		}
		arr := actisvc.GetMyFinishedTasksWithTime(workflow.OIL_INFO_CHANGE, this.User.Id)
		for _,s := range arr {
			myTasksRetWithTimes = append(myTasksRetWithTimes, s)
		}
		infoList := actisvc.GetHistoryMyTasks(workflow.OIL_INFO_CHANGE, this.User.Id)
		infoIdarr := strings.Split(infoList, ",")
		for i, item := range infoIdarr {
			idx := strings.Index(item, "-")
			if (idx >= 0) {
				infoIdarr[i] = strings.Split(item, "-")[0]
			}
		}
		infoList = strings.Join(infoIdarr, ",")
		if infoList != "" {
			whereInfo += " and Id in (" + infoList + ")"
			svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &listInfo, whereInfo)
			for _, item := range listInfo {
				todo.Id = item.Id
				todo.Type = todolist.INFOCHANGE
				todo.SupplierName = item.SupplierName
				todo.UserName = this.User.Realname
				todo.SupplierTypeCode = item.SupplierTypeName
				todo.Status = item.Status
				todo.BusinessKey = item.BusinessKey
				todo.WorkflowId = item.WorkFlowId
				todolists = append(todolists, todo)
			}
		}
	}
	//if stype == "5" || stype == "" {
	//	// 资质变更
	//	var listqual []qualchange.OilQualChangeMain
	//	arr := actisvc.GetMyFinishedTasksWithTime(workflow.OIL_QUAL_CHANGE, this.User.Id)
	//	for _,s := range arr {
	//		myTasksRetWithTimes = append(myTasksRetWithTimes, s)
	//	}
	//	qualList := actisvc.GetHistoryMyTasks(workflow.OIL_QUAL_CHANGE, this.User.Id)
	//	qualIdarr := strings.Split(qualList, ",")
	//	for i, item := range qualIdarr {
	//		idx := strings.Index(item, "-")
	//		if idx >= 0 {
	//			qualIdarr[i] = strings.Split(item, "-")[0]
	//		}
	//	}
	//	qualList = strings.Join(qualIdarr, ",")
	//	wherequal := "1=1 "
	//
	//	if supplierName != "" {
	//		wherequal = wherequal + " and SupplierName like '%" + supplierName + "%'"
	//	}
	//	if qualList != "" {
	//		wherequal += " and Id in (" + qualList + ")"
	//		wherequal += " and Status != -2 "
	//		svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &listqual, wherequal)
	//		for _, item := range listqual {
	//			todo.Id = item.Id
	//			todo.CertId = strconv.Itoa(item.SupplierCertId)
	//			todo.SupplierId = strconv.Itoa(item.SupplierId)
	//			todo.Type = todolist.QUALCHANGE
	//			todo.SupplierName = item.SupplierName
	//			todo.UserName = this.User.Realname
	//			todo.SupplierTypeCode = "0"
	//			todo.Status = item.Status
	//			todo.BusinessKey = strconv.Itoa(item.Id) + "-"+ strconv.Itoa(item.AuditIndex)
	//			todolists = append(todolists, todo)
	//		}
	//	}
	//}
	if stype == "6" || stype == "" {
		where := " CheckStatus in (1,2) "
		if supplierName != "" {
			where = where + " and SupplierName like '%" + supplierName + "%' "
		}

		where = where + " and CheckUserId like '%" + this.User.Id + "%' "

		svc := register.GetOilCorporateInfoService(utils.DBE)
		var list []register.OilCorporateInfo
		_, list = svc.GetCompanyListByWhere(page.CurrentPage, page.Size, "Id desc", "OilCorporateInfo", where)
		for _, item := range list {
			todo.Id = item.Id
			todo.Type = todolist.REGISTER
			todo.SupplierName = item.SupplierName
			todo.UserName = this.User.Realname
			todo.Status = strconv.Itoa(item.CheckStatus)
			todo.CreateTime = item.CreateOn.Unix() * 1000
			todolists = append(todolists, todo)
		}
	}
	for i,todo := range todolists {
		for _,myTasksRetWithTime := range myTasksRetWithTimes {
			if todo.BusinessKey == myTasksRetWithTime.BusinessKey && todo.WorkflowId == myTasksRetWithTime.WorkflowId {
				todolists[i].CreateTime = myTasksRetWithTime.CreateTime
			}
		}
	}
	sort.Slice(todolists, func(i, j int) bool {
		return todolists[i].CreateTime > todolists[j].CreateTime
	})
	var datainfo DataInfo
	datainfo.Items = todolists
	this.Data["json"] = &datainfo
	this.ServeJSON()
}