system_task_statistics_test.go 5.8 KB
package statistics

import (
	"github.com/go-pg/pg"
	"gitlab.fjmaimaimai.com/linmadan/mmm-worth/pkg/domain"
	"net/http"
	"time"

	"github.com/gavv/httpexpect"
	. "github.com/onsi/ginkgo"
	. "github.com/onsi/gomega"
	pG "gitlab.fjmaimaimai.com/linmadan/mmm-worth/pkg/infrastructure/pg"
)

var _ = Describe("获取系统任务统计", func() {
	BeforeEach(func() {
		dayAfter, _ := time.ParseDuration("72h")
		_, err := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO tasks (id, company_id, task_name, task_type, sponsor, task_status, reference_resource, project_belong, customer_values, task_nature, su_money, acceptance_standard, task_description, task_picture_urls, is_reward_take, participators, task_percentage, solve_report, solve_picture_urls, receiver_uid, create_time, release_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
			1, 101, "抢单任务1", 1, &domain.EmployeeInfo{
				Uid: 2499036607974745088,
			}, 2, "null", 1, pg.Array([]int{1, 2, 3, 4}), 1, 1000.00, "验收标准1", "任务描述1", pg.Array([]string{}), true, []*domain.EmployeeInfo{
				{
					Uid: 2499036607974745077,
				},
				{
					Uid: 2499036607974745066,
				},
			}, "null", "", pg.Array([]string{}), 2499036607974745099, time.Now(), time.Now().Add(dayAfter))
		Expect(err).NotTo(HaveOccurred())
		_, err1 := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO tasks (id, company_id, task_name, task_type, sponsor, task_status, reference_resource, project_belong, customer_values, task_nature, su_money, acceptance_standard, task_description, task_picture_urls, is_reward_take, participators, task_percentage, solve_report, solve_picture_urls, create_time, release_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
			2, 101, "抢单任务2", 1, &domain.EmployeeInfo{
				Uid: 2499036607974745088,
			}, 2, "null", 1, pg.Array([]int{1, 2, 3, 4}), 1, 1000.00, "验收标准1", "任务描述1", pg.Array([]string{}), false, "null", "null", "", pg.Array([]string{}), time.Now(), time.Now().Add(dayAfter))
		Expect(err1).NotTo(HaveOccurred())
		_, err2 := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO tasks (id, company_id, task_name, task_type, sponsor, task_status, reference_resource, project_belong, customer_values, task_nature, su_money, acceptance_standard, task_description, task_picture_urls, is_reward_take, participators, task_percentage, solve_report, solve_picture_urls, create_time, release_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
			3, 102, "竞标任务1", 2, &domain.EmployeeInfo{
				Uid: 2499036607974745088,
			}, 1, "null", 1, pg.Array([]int{1, 2, 3, 4}), 1, 1000.00, "验收标准1", "任务描述1", pg.Array([]string{}), true, "null", "null", "", pg.Array([]string{}), time.Now(), time.Now().Add(dayAfter))
		Expect(err2).NotTo(HaveOccurred())
		_, err3 := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO tasks (id, company_id, task_name, task_type, sponsor, task_status, reference_resource, project_belong, customer_values, task_nature, su_money, acceptance_standard, task_description, task_picture_urls, is_reward_take, participators, task_percentage, solve_report, solve_picture_urls, create_time, release_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
			4, 101, "竞标任务1", 2, &domain.EmployeeInfo{
				Uid: 2499036607974745099,
			}, 5, "null", 1, pg.Array([]int{1, 2, 3, 4}), 1, 1000.00, "验收标准1", "任务描述1", pg.Array([]string{}), false, "null", "null", "", pg.Array([]string{}), time.Now(), time.Now().Add(dayAfter))
		Expect(err3).NotTo(HaveOccurred())
		_, err4 := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO tasks (id, company_id, task_name, task_type, sponsor, task_status, reference_resource, project_belong, customer_values, task_nature, su_money, acceptance_standard, task_description, task_picture_urls, is_reward_take, participators, task_percentage, solve_report, solve_picture_urls, receiver_uid, create_time, release_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
			5, 303, "抢单任务1", 1, &domain.EmployeeInfo{
				Uid: 2499036607974745088,
			}, 6, "null", 1, pg.Array([]int{1, 2, 3, 4}), 1, 1000.00, "验收标准1", "任务描述1", pg.Array([]string{}), true, []*domain.EmployeeInfo{
				{
					Uid: 2499036607974745077,
				},
				{
					Uid: 2499036607974745066,
				},
			}, "null", "", pg.Array([]string{}), 2499036607974745099, time.Now(), time.Now().Add(dayAfter))
		Expect(err4).NotTo(HaveOccurred())
		_, err11 := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO bid_infos (id, task_id, bid_start_time, bid_end_time) VALUES (?, ?, ?, ?)",
			1, 4, time.Date(2020, time.Month(4), 5, 8, 0, 0, 0, time.Now().Location()), time.Date(2020, time.Month(4), 10, 8, 0, 0, 0, time.Now().Location()))
		Expect(err11).NotTo(HaveOccurred())
		_, err22 := pG.DB.QueryOne(
			pg.Scan(),
			"INSERT INTO bidder_infos (id, bid_info_id, task_id) VALUES (?, ?, ?)",
			1, 1, 4)
		Expect(err22).NotTo(HaveOccurred())
	})
	Describe("获取系统任务统计", func() {
		Context("请求系统任务统计", func() {
			It("返回统计结果", func() {
				httpExpect := httpexpect.New(GinkgoT(), server.URL)
				body := map[string]interface{}{
					"companyId": 101,
				}
				httpExpect.POST("/statistics/system-task").
					WithJSON(body).
					Expect().
					Status(http.StatusOK).
					JSON().
					Object().
					ContainsKey("code").ValueEqual("code", 0).
					ContainsKey("msg").ValueEqual("msg", "ok").
					ContainsKey("data").Value("data").Object()
			})
		})
	})
	AfterEach(func() {
		_, err := pG.DB.Exec("DELETE FROM tasks WHERE true")
		Expect(err).NotTo(HaveOccurred())
		_, err1 := pG.DB.Exec("DELETE FROM bid_infos WHERE true")
		Expect(err1).NotTo(HaveOccurred())
		_, err2 := pG.DB.Exec("DELETE FROM bidder_infos WHERE true")
		Expect(err2).NotTo(HaveOccurred())
	})
})