jy_docs/services/stdlib/docStatistics.go

package stdlib

import (
	"log"
	"time"

	jyDocsRpcUtil "app.yhyue.com/moapp/jy_docs/services/util"
)

func DocStatistics(docId string, dtype int) bool {
	sqlStr := ""
	state := false
	if dtype == 1 { //下载次数增加1
		sqlStr = "update doc_statistics set downTimes = downTimes + 1,updateDate = ? where docId = ?"
	} else if dtype == 2 { //浏览次数增加1
		sqlStr = "update doc_statistics set viewTimes = viewTimes + 1,updateDate = ? where docId = ?"
	}
	//mysql
	log.Println("sql ", sqlStr)
	updateDate := time.Now().Format("2006-01-02 15:04:05")
	err := jyDocsRpcUtil.GetJyDocsDB().Exec(sqlStr, updateDate, docId).Error
	if err == nil {
		state = true
	}
	return state
}