package webutility

  
  import (

  	"fmt"

  	"time"

  )

  // UnixToDate converts given Unix time to local time in format and returns result:
  // YYYY-MM-DD hh:mm:ss +zzzz UTC

  func UnixToDate(unix int64) time.Time {
  	return time.Unix(unix, 0)

  }

  // DateToUnix converts given date in Unix timestamp.

  func DateToUnix(date interface{}) int64 {
  	if date != nil {

  		t, ok := date.(time.Time)
  		if !ok {
  			return 0
  		}

  		return t.Unix()
  
  	}
  	return 0
  }

  // UnixPtrToDate converts given Unix time to local time in format and returns result:
  // YYYY-MM-DD hh:mm:ss +zzzz UTC
  func UnixPtrToDatePtr(unix *int64) *time.Time {
  	var t time.Time
  	if unix == nil {
  		return nil
  	}
  	t = time.Unix(*unix, 0)
  	return &t
  }
  
  // DateToUnix converts given date in Unix timestamp.
  func DatePtrToUnixPtr(date interface{}) *int64 {
  	var unix int64
  
  	if date != nil {
  		t, ok := date.(time.Time)
  		if !ok {
  			return nil
  		}
  		unix = t.Unix()
  		return &unix
  
  	}
  	return nil
  }

  // EqualQuotes encapsulates given string in SQL 'equal' statement and returns result.
  // Example: "hello" -> " = 'hello'"

  func EqualQuotes(stmt string) string {
  	if stmt != "" {

  		stmt = fmt.Sprintf(" = '%s'", stmt)

  	}

  	return stmt

  }

  // EqualString ...

  func EqualString(stmt string) string {
  	if stmt != "" {
  		stmt = fmt.Sprintf(" = %s", stmt)
  	}
  	return stmt
  }

  // LikeQuotes encapsulates given string in SQL 'like' statement and returns result.
  // Example: "hello" -> " LIKE UPPER('%hello%')"

  func LikeQuotes(stmt string) string {
  	if stmt != "" {

  		stmt = fmt.Sprintf(" LIKE UPPER('%s%s%s')", "%", stmt, "%")

  	}

  	return stmt

  }