20,359
社区成员
发帖
与我相关
我的任务
分享
[{
"id": "308",
"ip": "168429768",
"browse": "Firefox 63.0",
"osname": "Windows 10",
"replyname": "\u533f\u540d",
"date": "1536714374",
"content": "308",
"uid": "10000"
},
{
"id": "307",
"ip": "168429768",
"browse": "Firefox 63.0",
"osname": "Windows 10",
"replyname": "\u533f\u540d",
"date": "1536714371",
"content": "307",
"uid": "10000"
},
{
"id": "306",
"ip": "168429768",
"browse": "Firefox 63.0",
"osname": "Windows 10",
"replyname": "\u533f\u540d",
"date": "1536714364",
"content": "306",
"uid": "10000"
}];
[{
"replyname": "\u533f\u540d",
"date": "1536714502",
"content": "308-2",
"uid": "10000",
"replyid": "308",
"beReplyName": "undefined"
},
{
"replyname": "\u533f\u540d",
"date": "1536714423",
"content": "306-1",
"uid": "10000",
"replyid": "306",
"beReplyName": "306a"
},
{
"replyname": "\u533f\u540d",
"date": "1536714406",
"content": "307-1",
"uid": "10000",
"replyid": "307",
"beReplyName": "307a"
},
{
"replyname": "\u533f\u540d",
"date": "1536714389",
"content": "308-1",
"uid": "10000",
"replyid": "308",
"beReplyName": "308a"
}];
$data=第一组数组;
childComments =第二组数组;
foreach ($data as $k=>$v) {
$result[$v['id']]['date'] = date('Y-m-d H:i:s', $v['date']);
$result[$v['id']]['replyBody']= [];
$commentIds[] = $v['id'];
}
foreach ($childComments as $v) {
$v['id'] = $v['replyid'];
$v['date'] = date('Y-m-d H:i:s', $v['date']);
$result[$v['replyid']]['replyBody'][] = $v;
}
{
"308": {
"date": "2018-09-12 09:06:14",
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:08:22",
"content": "308-2",
"uid": "10000",
"replyid": "308",
"beReplyName": "undefined",
"id": "308"
},
{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:29",
"content": "308-1",
"uid": "10000",
"replyid": "308",
"beReplyName": "308a",
"id": "308"
}]
},
"307": {
"date": "2018-09-12 09:06:11",
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:46",
"content": "307-1",
"uid": "10000",
"replyid": "307",
"beReplyName": "307a",
"id": "307"
}]
},
"306": {
"date": "2018-09-12 09:06:04",
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:07:03",
"content": "306-1",
"uid": "10000",
"replyid": "306",
"beReplyName": "306a",
"id": "306"
}]
}
};
[{
id: 1,
img: "./images/img.jpg",
replyName: "帅大叔",
beReplyName: "匿名",
content: "同学聚会,看到当年追我的屌丝开着宝马车带着他老婆来了,他老婆是我隔壁宿舍的同班同学,心里后悔极了。",
time: "2017-10-17 11:42:53",
address: "深圳",
osname: "",
browse: "谷歌",
replyBody: []
},
{
id: 2,
img: "./images/img.jpg",
replyName: "匿名",
beReplyName: "",
content: "到菜市场买菜,看到一个孩子在看摊,我问:“一只鸡多少钱?” 那孩子回答:“23。” 我又问:“两只鸡多少钱?” 孩子愣了一下,一时间没算过来,急中生智大吼一声:“一次只能买一只!”",
time: "2017-10-17 11:42:53",
address: "深圳",
osname: "",
browse: "谷歌",
replyBody: [{
id: 3,
img: "",
replyName: "帅大叔",
beReplyName: "匿名",
content: "来啊,我们一起吃鸡",
time: "2017-10-17 11:42:53",
address: "",
osname: "",
browse: "谷歌"
}]
},
];
Array
(
[0] => Array
(
[id] => 308
[ip] => 168429768
[beReplyName] =>
[browse] => Firefox 63.0
[osname] => Windows 10
[replyname] => 匿名
[date] => 1536714374
[content] => 308
[uid] => 10000
)
[1] => Array
(
[id] => 307
[ip] => 168429768
[beReplyName] =>
[browse] => Firefox 63.0
[osname] => Windows 10
[replyname] => 匿名
[date] => 1536714371
[content] => 307
[uid] => 10000
)
[2] => Array
(
[id] => 306
[ip] => 168429768
[beReplyName] =>
[browse] => Firefox 63.0
[osname] => Windows 10
[replyname] => 匿名
[date] => 1536714364
[content] => 306
[uid] => 10000
)
[3] => Array
(
[id] => 1
[ip] => 0
[beReplyName] =>
[browse] =>
[osname] =>
[replyname] =>
[date] => 0
[content] =>
[uid] => 0
)
)
Array
(
[0] => Array
(
[replyname] => 匿名
[date] => 1536714502
[content] => 308-2
[uid] => 10000
[replyid] => 308
[beReplyName] => undefined
)
[1] => Array
(
[replyname] => 匿名
[date] => 1536714423
[content] => 306-1
[uid] => 10000
[replyid] => 306
[beReplyName] => 306a
)
[2] => Array
(
[replyname] => 匿名
[date] => 1536714406
[content] => 307-1
[uid] => 10000
[replyid] => 307
[beReplyName] => 307a
)
[3] => Array
(
[replyname] => 匿名
[date] => 1536714389
[content] => 308-1
[uid] => 10000
[replyid] => 308
[beReplyName] => 308a
)
[4] => Array
(
[replyname] =>
[date] => 0
[content] =>
[uid] => 0
[replyid] => 306
[beReplyName] =>
)
)
Array([0] = >Array([date] = >2018 - 09 - 12 09 : 06 : 14[replyBody] = >Array()
)
[1] = >Array([date] = >2018 - 09 - 12 09 : 06 : 11[replyBody] = >Array()
)
[2] = >Array([date] = >2018 - 09 - 12 09 : 06 : 04[replyBody] = >Array()
)
[3] = >Array([date] = >1970 - 01 - 01 08 : 00 : 00[replyBody] = >Array()
)
[308] = >Array([replyBody] = >Array([0] = >Array([replyname] = >匿名 [date] = >2018 - 09 - 12 09 : 08 : 22[content] = >308 - 2[uid] = >10000[replyid] = >308[beReplyName] = >undefined[id] = >308)
[1] = >Array([replyname] = >匿名 [date] = >2018 - 09 - 12 09 : 06 : 29[content] = >308 - 1[uid] = >10000[replyid] = >308[beReplyName] = >308a[id] = >308)
)
)
[306] = >Array([replyBody] = >Array([0] = >Array([replyname] = >匿名 [date] = >2018 - 09 - 12 09 : 07 : 03[content] = >306 - 1[uid] = >10000[replyid] = >306[beReplyName] = >306a[id] = >306)
[1] = >Array([replyname] = >[date] = >1970 - 01 - 01 08 : 00 : 00[content] = >[uid] = >0[replyid] = >306[beReplyName] = >[id] = >306)
)
)
[307] = >Array([replyBody] = >Array([0] = >Array([replyname] = >匿名 [date] = >2018 - 09 - 12 09 : 06 : 46[content] = >307 - 1[uid] = >10000[replyid] = >307[beReplyName] = >307a[id] = >307)
)
)
)
var arr = [{
"date": "2018-09-12 09:06:14",
"replyBody": []
},
{
"date": "2018-09-12 09:06:11",
"replyBody": []
},
{
"date": "2018-09-12 09:06:04",
"replyBody": []
},
{
"date": "1970-01-01 08:00:00",
"replyBody": []
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:08:22",
"content": "308-2",
"uid": "10000",
"replyid": "308",
"beReplyName": "undefined",
"id": "308"
},
{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:29",
"content": "308-1",
"uid": "10000",
"replyid": "308",
"beReplyName": "308a",
"id": "308"
}]
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:07:03",
"content": "306-1",
"uid": "10000",
"replyid": "306",
"beReplyName": "306a",
"id": "306"
},
{
"replyname": "",
"date": "1970-01-01 08:00:00",
"content": "",
"uid": "0",
"replyid": "306",
"beReplyName": "",
"id": "306"
}]
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:46",
"content": "307-1",
"uid": "10000",
"replyid": "307",
"beReplyName": "307a",
"id": "307"
}]
}];
$sql=new \yii\db\Query();
$sqlaa=new \yii\db\Query();
$count = $sql->from($this->tableName())->select('id')->where(['replyid' => 0, 'status' => 0])->count(); // 查询需要分页的目的数据的总个数
$newspagination = new \yii\data\Pagination(['totalCount'=>$count,'defaultPageSize' => 5]);
$data=$sql->from($this->tablename())
->select('id,ip,beReplyName,browse,osname,replyname,date,content,uid')
->where(['replyid' => 0, 'status' => 0])
->offset($newspagination->offset)
->limit($newspagination->limit)
->orderBy('date DESC')
->all();
foreach ($data as $k=>$v) {
$result[$v['id']]['date'] = date('Y-m-d H:i:s', $v['date']);
$result[$v['id']]['replyBody']= [];
$commentIds[] = $v['id'];
}
$result = array_values($result);
$childComments=$sqlaa->from($this->tablename())
->select('replyname,date,content,uid,replyid,beReplyName')
->where(['and', ['status' => 0] , ['in', 'replyid' , $commentIds]])
->orderBy('date DESC')
//->limit(10)
->all();
foreach ($childComments as $v) {
$v['id'] = $v['replyid'];
$v['date'] = date('Y-m-d H:i:s', $v['date']);
$result[$v['replyid']]['replyBody'][] = $v;
}
return array(array_values($result),$newspagination);
$data = json_decode('[{
"id": "308",
"ip": "168429768",
"browse": "Firefox 63.0",
"osname": "Windows 10",
"replyname": "\u533f\u540d",
"date": "1536714374",
"content": "308",
"uid": "10000"
},
{
"id": "307",
"ip": "168429768",
"browse": "Firefox 63.0",
"osname": "Windows 10",
"replyname": "\u533f\u540d",
"date": "1536714371",
"content": "307",
"uid": "10000"
},
{
"id": "306",
"ip": "168429768",
"browse": "Firefox 63.0",
"osname": "Windows 10",
"replyname": "\u533f\u540d",
"date": "1536714364",
"content": "306",
"uid": "10000"
}]', 1);
$childComments = json_decode('[{
"replyname": "\u533f\u540d",
"date": "1536714502",
"content": "308-2",
"uid": "10000",
"replyid": "308",
"beReplyName": "undefined"
},
{
"replyname": "\u533f\u540d",
"date": "1536714423",
"content": "306-1",
"uid": "10000",
"replyid": "306",
"beReplyName": "306a"
},
{
"replyname": "\u533f\u540d",
"date": "1536714406",
"content": "307-1",
"uid": "10000",
"replyid": "307",
"beReplyName": "307a"
},
{
"replyname": "\u533f\u540d",
"date": "1536714389",
"content": "308-1",
"uid": "10000",
"replyid": "308",
"beReplyName": "308a"
}]', 1);
foreach ($data as $k=>$v) {
$result[$v['id']]['date'] = date('Y-m-d H:i:s', $v['date']);
$result[$v['id']]['replyBody']= [];
$commentIds[] = $v['id'];
}
foreach ($childComments as $v) {
$v['id'] = $v['replyid'];
$v['date'] = date('Y-m-d H:i:s', $v['date']);
$result[$v['replyid']]['replyBody'][] = $v;
}
$result = array_values($result);
echo json_encode($result, JSON_PRETTY_PRINT);
[
{
"date": "2018-09-12 09:06:14",
"replyBody": [
{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:08:22",
"content": "308-2",
"uid": "10000",
"replyid": "308",
"beReplyName": "undefined",
"id": "308"
},
{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:29",
"content": "308-1",
"uid": "10000",
"replyid": "308",
"beReplyName": "308a",
"id": "308"
}
]
},
{
"date": "2018-09-12 09:06:11",
"replyBody": [
{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:46",
"content": "307-1",
"uid": "10000",
"replyid": "307",
"beReplyName": "307a",
"id": "307"
}
]
},
{
"date": "2018-09-12 09:06:04",
"replyBody": [
{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:07:03",
"content": "306-1",
"uid": "10000",
"replyid": "306",
"beReplyName": "306a",
"id": "306"
}
]
}
]
var arr = [{
"id": "308",
"img": ".\/images\/img.jpg",
"content": "308",
"replyname": "\u533f\u540d",
"beReplyName": "",
"time": "2018-09-12 09:06:14",
"address": "168429768",
"osname": "Windows 10",
"browse": "Firefox 63.0",
"replyBody": []
},
{
"id": "307",
"img": ".\/images\/img.jpg",
"content": "307",
"replyname": "\u533f\u540d",
"beReplyName": "",
"time": "2018-09-12 09:06:11",
"address": "168429768",
"osname": "Windows 10",
"browse": "Firefox 63.0",
"replyBody": []
},
{
"id": "306",
"img": ".\/images\/img.jpg",
"content": "306",
"replyname": "\u533f\u540d",
"beReplyName": "",
"time": "2018-09-12 09:06:04",
"address": "168429768",
"osname": "Windows 10",
"browse": "Firefox 63.0",
"replyBody": []
},
{
"id": "1",
"img": ".\/images\/img.jpg",
"content": "",
"replyname": "",
"beReplyName": "",
"time": "1970-01-01 08:00:00",
"address": "0",
"osname": "",
"browse": "",
"replyBody": []
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:08:22",
"content": "308-2",
"uid": "10000",
"replyid": "308",
"beReplyName": "undefined",
"id": "308"
}]
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:07:03",
"content": "306-1",
"uid": "10000",
"replyid": "306",
"beReplyName": "306a",
"id": "306"
}]
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:46",
"content": "307-1",
"uid": "10000",
"replyid": "307",
"beReplyName": "307a",
"id": "307"
}]
},
{
"replyBody": [{
"replyname": "\u533f\u540d",
"date": "2018-09-12 09:06:29",
"content": "308-1",
"uid": "10000",
"replyid": "308",
"beReplyName": "308a",
"id": "308"
}]
},
{
"replyBody": [{
"replyname": "",
"date": "1970-01-01 08:00:00",
"content": "",
"uid": "0",
"replyid": "306",
"beReplyName": "",
"id": "306"
}]
}];