/**
* fetch quota array for a given lab_id
*
* @param int $lab_id lab id
*
* @return array|bool array of quotas | FALSE on error
*/
function ace_db_lab_get_quota_array($lab_id)
{
$user_id = ace_db_lab_get_user_id($lab_id);
$group_id_array = ace_db_user_get_group_ids($user_id);
$str_group_ids = implode(',', $group_id_array);
$sql = "SELECT MIN(`labs`) as `labs`,\n\t\t\t\t\tMIN(`vms`) as `vms`,\n\t\t\t\t\tMIN(`vcpu`) as `vcpu`,\n\t\t\t\t\tMIN(`memory`) as `memory`,\n\t\t\t\t\tMIN(`networks`) as `networks`,\n\t\t\t\t\tMIN(`volumes`) as `volumes`,\n\t\t\t\t\tMIN(`storage`) as `storage`\n\t\t\tFROM quota\n\t\t\tWHERE (lab_id={$lab_id} OR user_id={$user_id} OR group_id IN ({$str_group_ids}) )";
$db_result = ace_db_query($sql);
if ($db_result->row_count > 0) {
$quota_array = $db_result->table[0];
} else {
$quota_array = FALSE;
}
return $quota_array;
}
/**
* returns lab owner's user id
*
* @api
*
* @param int $lab_id lab id
*
* @return int|bool owner user id | FALSE on error
*/
function ace_lab_get_user_id($lab_id)
{
return ace_db_lab_get_user_id($lab_id);
}
