Test

schedPost.go

func ReadByObjectIDAndDate(objTypeID, objtypeIDE int64, sDate, eDate string, queryType string, order string, limit int64) ([]SocialStarPostSchedule, error) {
	s := []SocialStarPostSchedule{}
	// dtFormat := ""
	var args []interface{}

	query := "SELECT ssps.*"
	// query += "DATE_FORMAT(ssps.PostDate, '%u') AS `weekNum`, DATE_FORMAT(ssps.PostDate, '%x') AS `weekYear` "
	query += "FROM SocialStarPostSchedule ssps "
	query += "INNER JOIN SocialStarSchedule AS sss ON ssps.SocialStarScheduleID = sss.SocialStarScheduleID "
	query += "WHERE sss.ObjectID = ? "
	query += "AND  sss.ObjectTypeIDE = ? "

	args = append(args, objTypeID)
	args = append(args, objtypeIDE)

	// if date != "" {
	// 	sDate := strings.Split(date, "-")
	// 	year, _ := strconv.Atoi(sDate[0])
	// 	month, _ := strconv.Atoi(sDate[1])
	// 	day, _ := strconv.Atoi(sDate[2])
	// 	newDate := time.Date(year, time.Month(month), day, 0, 0, 0, 0, time.UTC)

	// 	if queryType == "week" {
	// 		y, w := newDate.ISOWeek()
	// 		if len(strconv.Itoa(w)) == 1 {
	// 			dtFormat += "0" + strconv.Itoa(w)
	// 		} else {
	// 			dtFormat += strconv.Itoa(w)
	// 		}

	// 		dtFormat += strconv.Itoa(y) + dtFormat
	// 		query += "AND DATE_FORMAT(ssps.PostDate, '%X%v') = ? " // Week where Sunday is the first day of the week
	// 		args = append(args, dtFormat)
	// 	} else {
	// 		// set default to month
	// 		dtFormat = strconv.Itoa(newDate.Year()) + strconv.Itoa(int(newDate.Month()))
	// 		query += "AND DATE_FORMAT(ssps.PostDate, '%X%m') = ? "
	// 		args = append(args, dtFormat)
	// 	}
	// } else {
	// 	// get the current week data
	// 	y, w := time.Now().ISOWeek()
	// 	dtFormat = strconv.Itoa(y) + strconv.Itoa(w)
	// 	query += "AND DATE_FORMAT(ssps.PostDate, '%X%v') = ? " // Week where Sunday is the first day of the week
	// 	args = append(args, dtFormat)
	// }

	if sDate != "" {
		query += " AND ssps.PostDate >= ? "
		args = append(args, sDate)
	}

	if eDate != "" {
		query += " AND ssps.PostDate <= ? "
		args = append(args, eDate)
	}

	if order != "" {
		query += " ORDER BY ? "
		args = append(args, order)
	}

	if limit > 0 {
		query += " LIMIT 0, ? "
		args = append(args, strconv.FormatInt(limit, 10))
	}

	fmt.Println(query, args)
	err := database.Select(&s, query, args...)
	if err != nil {
		return nil, err
	}

	return s, nil
}