1、unix_timestamp(now())
2、 l i s t = D ( ′ U s e r s C o i n r e c o r d ′ ) − > a l i a s ( " c o i n " ) − > j o i n ( " I N N E R J O I N c m f c o u r s e A S c O N c o i n . c i d = c . i d " ) − > j o i n ( " L E F T J O I N c m f c o u r s e r e g i s t r a t i o n A S r O N c o i n . u i d = r . u i d A N D c . c o u r s e i d = r . c i d A N D r . c o s t s w a y = 1 " ) − > j o i n ( ′ l e f t j o i n c m f u s e r s a s u o n u . i d = c . u i d ′ ) − > w h e r e ( list = D('UsersCoinrecord')->alias("coin") ->join("INNER JOIN cmf_course AS c ON coin.cid = c.id") ->join("LEFT JOIN cmf_course_registration AS r ON coin.uid = r.uid AND c.course_id = r.cid AND r.costs_way = 1") ->join('left join cmf_users as u on u.id=c.uid') ->where(list=D(′UsersCoinrecord′)−>alias("coin")−>join("INNERJOINcmfcourseAScONcoin.cid=c.id")−>join("LEFTJOINcmfcourseregistrationASrONcoin.uid=r.uidANDc.courseid=r.cidANDr.costsway=1")−>join(′leftjoincmfusersasuonu.id=c.uid′)−>where(condition)
->field(“c.id,c.cname,c.start_time,c.front_cover,coin.money as realmoney,c.costs as coursemoney,u.real_name as teachername , (coin.expire_time-unix_timestamp(now())) as remain_time,coin.status,coin.orderno,coin.create_time as ordertime”)
->order(“coin.create_time desc”)
->limit(o f f s e t , offset,offset,countPerPage)
->select();
mysql查询当前时间戳unix_timestamp(now())
版权声明：本文为weixin_40974880原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。