/*
select distinct(card.id), card.body, user.name
from user, card, user_card
where
card.id = user_card.cardid and user_card.fromuserid=user.id
and (user_card.fromuserid=20 or user_Card.touserid=20) and card.id>0
order by card.id
*/
func PingMsgReply(req bsimjson.Bsimjson) (ret []bsimjson.Bsimjson, err error) {
//func FindUserBySession(ss string) (id int64, name string, email string, password string, err error) {
meuid, _, _, _, err := FindUserBySession(req.Who)
rows, err := db.Query(`select distinct(card.id), card.body, user.name, user_card.sendtime
from user, card, user_card
where
card.id = user_card.cardid and user_card.fromuserid=user.id
and (user_card.fromuserid=? or user_Card.touserid=?) and card.id>?
order by card.id`,
meuid, meuid, req.Cardid)
if err != nil {
return
}
for rows.Next() {
var tm bsimjson.Bsimjson
var cardbody, fromname, sendTime string
var cardid int64
if err := rows.Scan(&cardid, &cardbody, &fromname, &sendTime); err != nil {
log.Fatal(err)
continue
}
tm.Type = "send"
tm.Who = fromname
tm.Msg = cardbody
tm.Cardid = cardid
tm.DTime = sendTime
ret = append(ret, tm)
}
return ret, err
}
