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);
}
