public function getActionLists($filed, $where, $orderby, $limit)
{
self::initDB();
$sql = 'select ' . $filed . ' from `' . self::$table_action_info . '` LEFT JOIN `' . self::$table_action_group . '` ON action_group_id=group_id where ' . $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);
}
public function actionGroupList($id)
{
self::initDB();
$sql = "SELECT group_name FROM " . self::$table_action_group . " WHERE group_system_id = {$id}";
$query = self::$dbConn->query($sql);
if (!$query) {
self::$errCode = '1803';
self::$errMsg = "[{$sql}] is error";
return false;
}
$result = array();
$ret = self::$dbConn->fetch_array_all($query);
for ($i = 0; $i < count($ret); $i++) {
array_push($result, $ret[$i]['group_name']);
}
return $result;
}
