tp = [
'mor'=>[
'name'=>'上午',
'start_time'=>"06:30:00",
'end_time'=>'13:00:00'
],
'aft'=>[
'name'=>'下午',
'start_time'=>"13:00:00",
'end_time'=>'18:00:00'
]
];
}
public function getTopicList($mid) {
$topics = $this->db->getall("select `id`, `topic_title`, `topic_attendee`, `topic_state`, `topic_info` from `[Q]meeting_topics` where mid = {$mid} order by sort");
$meetingTopic = array_fill(0, count($topics) - 1, null);
// 会议议题处理
for ($i = 0,$j = 0; $i < count($topics); $i++) {
$info = $topics[$i];
$ts = $info['topic_state'];
$tt = $info['topic_title'];
$ti = $info['topic_info'];
$pl = str_replace("\n", "
", $ti);
// 用于排序（已结束放最后）
if ($ts == 3) {
$index = count($topics) - 1 - $j++;
} else {
$index = $i-$j;
}
$mt = $meetingTopic[$index];
$mt['state'] = $ts;
$mt['tip'] = m("meeting")->ytarra[$ts];
$mt['text'] = $tt;
$mt['personnel_list'] = $pl;
if ($ts == 2) {
// 当前议题 + 参会人员
$data['participants'][] = [
"topics" => $tt,
"personnel_list" => $pl,
];
// 下一议题 + 参会人员
if (isset($topics[$i + 1])) {
$t = $topics[$i + 1];
$ntt = $t['topic_title'];
$npl = str_replace("\n", "
", $t['topic_info']);
$data['participants'][] = [
"topics" => $ntt,
"personnel_list" => $npl,
];
}
}
$meetingTopic[$index] = $mt;
}
return $meetingTopic;
}
public function getNowTopic($mid)
{
$topics = $this->db->getone("[Q]meeting_topics", "mid = {$mid} and topic_state = 2", "*", "sort");
if ($topics) {
$topics['topic_info'] = str_replace("\n", "
", $topics['topic_info']);
}
return $topics;
}
public function getNextTopic($mid) {
$topics = $this->db->getone("[Q]meeting_topics", "mid = {$mid} and topic_state = 1", "*", "sort");
if ($topics) {
$topics['topic_info'] = str_replace("\n", "
", $topics['topic_info']);
}
return $topics;
}
public function getRecTopic($mid) {
// $topics = $this->db->getall("[Q]meeting_topics", "mid = {$mid} and topic_state in (1, 2)", "*", "topic_state desc, sort");
$sqlStr = "select * from [Q]meeting_topics where mid = {$mid} and topic_state in (1, 2) order by topic_state desc, sort";
$topics = $this->db->getall($sqlStr);
// for ($i = 0; $i < count($topics); $i++) {
// $topic = $topics[$i];
// $topics[$i]['topic_info'] = str_replace("\n", "
", $topic['topic_info']);
// }
return $topics;
}
}