m_log

package models

import (
    "fmt"
    sm "restapi/globalfile"
    "sierfinger/db"
    "strings"
)

//AuthLog : data authlog
type AuthLog struct {
    EmpCode    string        `json:"EmpCode" xml:"EmpCode" form:"EmpCode" query:"EmpCode"`
}

// GetAuthLog : select all scan log
func GetAuthLog() []AuthLog {
    mssqlcon := db.SQLSCon()
    defer mssqlcon.Close()
    var sql strings.Builder

    //sql query strings
    rows, err := mssqlcon.Query(sql.String())
    fmt.Println(rows)
    fmt.Println(err)
    if err != nil {
        fmt.Println(err)
    }
    defer rows.Close()
    var u []AuthLog

    for rows.Next() {
        var each = AuthLog{}

        err2 := rows.Scan(&each.EmpCode)

        if err2 != nil {
            fmt.Print(err2)
        }
        u = append(u, each)
    }
    return u
}