Esempio n. 1
0
// GetSubject returns the subject area of the program of study
func (program Program) GetSubject() *education.Subject {
	subject, err := education.NewSubject(strconv.Itoa(program.subject))
	if err != nil {
		fmt.Println(err)
	}
	return subject
}
Esempio n. 2
0
func (controller *Controller) loadSubject() {
	ID := controller.Ctx.Input.Param(":subject")
	subject, err := model.NewSubject(ID)
	if err != nil {
		controller.Abort("show-database-error")
	}
	controller.Data["subject"] = subject
	controller.subject = subject
	controller.SetCustomTitle("Admin - " + subject.GetName())
}
Esempio n. 3
0
// GetEducationSubjects returns the distinct Subjects
func (institution Institution) GetEducationSubjects() []*education.Subject {
	list := []*education.Subject{}
	fieldList := "`subject`"
	whereClause := "WHERE `institution` = ?"
	sql := "SELECT DISTINCT " + fieldList + " FROM `institution_program` " + whereClause
	rows, _ := database.Connection.Query(sql, strconv.Itoa(institution.ID))
	for rows.Next() {
		ID := ""
		rows.Scan(&ID)
		item, _ := education.NewSubject(ID)
		list = append(list, item)
	}
	return list
}
Esempio n. 4
0
// it gets the subjects from database
func (search SubjectSearch) getFromDB() []*education.Subject {
	var list []*education.Subject

	limitClause := search.options.GetLimit()
	fieldsList := "`id`"
	whereClause := "WHERE `name` LIKE ?"
	sql := "SELECT DISTINCT " + fieldsList + " FROM `subject_area` " + whereClause + space + limitClause

	rows, err := database.Connection.Query(sql, search.likeQuery())

	if err != nil {
		fmt.Println(err)
	}
	for rows.Next() {
		var ID string
		rows.Scan(&ID)
		item, _ := education.NewSubject(ID)
		list = append(list, item)
	}
	return list
}
Esempio n. 5
0
// GetSubject returns the subject object
func (analyser InstitutionAnalyser) GetSubject() *education.Subject {
	subject, _ := education.NewSubject(analyser.subject)
	return subject
}