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())
最新推荐文章于 2025-02-14 21:46:58 发布
扫一扫
2284
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
