使用 DB::talbe 搜索条件 DB::raw ('date_format (from_unixtime (op_time), "%%Y%%m")') 问题?
$bdMoudleModel = $this->select(
DB::raw('concat(date_format(from_unixtime(op_time), "%%Y%%m"), city_id) as `cos`'),
// DB::raw('concat(op_time, city_id) as `cos`'),
DB::raw('date_format(from_unixtime(op_time), "%%Y%%m") as `date`'),
'top_module_id',
'second_module_id',
// 'web_nums',
DB::raw('sum(web_nums) as `web_nums`'),
// 'app_nums'
DB::raw('sum(app_nums) as `app_nums`')
)->groupBy('date','city_id');
SQL执行结果是正确的,但是返回的数据确实 %Y%m21 (21是城市ID),求教
dd打印的数据
{
"ResponseData": [
{
"cos": "%Y%m3211",
"date": "%Y%m",
"city_id": 3211,
"city_name": "镇江",
"op_time": 1499270400,
"op_business_num": "1",
"op_nums": "7"
},
{
"cos": "%Y%m31",
"date": "%Y%m",
"city_id": 31,
"city_name": "上海",
"op_time": 1496332800,
"op_business_num": "36",
"op_nums": "442"
}
],
"ResponseStatus": 200,
"ResponseMsg": "OK"
}
推荐文章: