| | |
| | | case constvar.ServiceFollowupKeywordContactName: |
| | | db = db.Joins("Contact").Where("Contact.name like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) |
| | | case constvar.ServiceFollowupKeywordCustomerServiceNo: |
| | | db = db.Joins("ServiceOrder").Where("ServiceOrder.ServiceNumber like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) |
| | | db = db.Joins("ServiceOrder").Where("ServiceOrder.service_number like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) |
| | | case constvar.ServiceFollowupKeywordVisitor: |
| | | db = db.Joins("left join user on user.id = service_followup.member_id").Where("user.username like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) |
| | | case constvar.ServiceFollowupKeywordSatisfactionDegree: |