public function logList($searchNickname, $searchTime) { $searchTime = fix_range_time($searchTime); $startTime = $searchTime['start_date']; $endTime = $searchTime['end_date']; $paramer = array("searchNickname" => $searchNickname, "searchTime" => $searchTime); $numberPerPage = 20; $totalNum = 0; $where = array(); $str = ' 1 = 1 '; if ($searchNickname) { $str .= " AND nickname like '%" . $searchNickname . "%' "; } $str .= " AND ctime < '" . $endTime . "' AND ctime >= '" . $startTime . "' "; $where['_string'] = $str; $log = M('Log'); $num = $log->field('count(id) as num ')->where($where)->select(); $totalNum = $num[0]['num']; $page = new Page($totalNum, 1, $paramer); $show = $page->show(); $logList = $log->where($where)->limit($page->firstRow, $page->listRows)->select(); return array("logList" => $logList, "show" => $show); }
public function getWorklist($workType, $synopsis, $timerange, $show) { $where = array(); $paramer = array('workType' => $workType, 'synopsis' => $synopsis, 'searchTime' => $timerange, 'show' => $show); if ('my' == $show) { $userId = $_SESSION['authId']; $where['userId'] = $userId; } elseif ('member' == $show) { $userId = $_SESSION['authId']; $member_id_list = $this->get_member_id_list($userId); $where['userId'] = array('in', $member_id_list); } $timerange_arr = fix_range_time($timerange); $start_time = $timerange_arr['start_date']; $end_time = $timerange_arr['end_date']; $where['isDelete'] = '0'; if ($workType) { $where['workType'] = $workType; } $str = ''; if ($timerange) { $str = " ctime < '" . $end_time . "' AND ctime >= '" . $start_time . "' "; } if ($str) { $where['_string'] = $str; } if ($synopsis) { $where['synopsis'] = array('like', "%" . $synopsis . "%"); } $work = M('work'); $totalNum = $work->where($where)->count('id'); $page = new Page($totalNum, 20, $paramer); $show = $page->show(); $list = $work->where($where)->limit($page->firstRow, $page->listRows)->select(); $list = $this->fixWorkList($list); return array('list' => $list, 'show' => $show); }