Ejemplo n.º 1
0
 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);
 }
Ejemplo n.º 2
0
 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);
 }