Example #1
0
 /**
  * @param array $fields
  * @param string $extra
  * @param bool $isPageNav
  * @return mixed
  */
 public function getList($fields = array(), $extra = " WHERE `deleted`='n' ", $isPageNav = true)
 {
     $conn = $this->getConnect();
     if (empty($fields)) {
         $fields = $this->tbFields;
     }
     if ($isPageNav) {
         $sql = $conn->assembleSelectSQL($this->tbName, $fields, $extra);
         $pa = new Pagination($conn, $sql);
         $res['rows'] = $pa->getRows();
         $res['nav'] = $pa->getNav();
     } else {
         $res['rows'] = $conn->getList($this->tbName, $fields, $extra);
         $res['nav'] = '';
     }
     $res['rows'] = $this->formatList($res['rows']);
     return $res;
 }