27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT booking.id AS id ,
orderno ,
productName AS pno ,
phone AS user1 ,
quantity AS pnumber ,
productCombo AS taocan ,
unit AS pjiage ,
residual AS zjiage ,
privilege AS pfanxian ,
CustomerName AS senduser ,
CASE AddedService
WHEN '一年延' THEN '一年'
WHEN '二年延' THEN '两年'
ELSE AddedService
END AS fuwu ,
tel ,
mail AS email ,
CustomerAddress AS address ,
residual AS jiage ,
CASE WHEN booking.lasteditdate > DATEADD(day, -7, GETDATE())
THEN '交易成功'
ELSE '确认收货'
END