public function getJobLists($filed, $where, $order = '', $limit = '') { self::initDB(); $sql = 'SELECT ' . $filed . ' FROM ' . self::$table_job_info . ' LEFT JOIN ' . self::$table_dept_info . ' ON dept_id=job_dept_id LEFT JOIN ' . self::$table_job_power . ' ON jobpower_job_id=job_id LEFT JOIN ' . self::$table_company_info . ' ON job_company_id=company_id ' . $where . ' ' . $order . ' ' . $limit; $query = self::$dbConn->query($sql); if (!$query) { self::$errCode = '1803'; self::$errMsg = "[{$sql}] is error"; return false; } if ($this->is_count === true) { $this->is_count = false; return self::$dbConn->num_rows($query); } return self::$dbConn->fetch_array_all($query); }