SELECT
'id', user.id,
'username', user.username,
'roles', json_arrayagg(role.title) roles
FROM user
JOIN project_user on user.id = project_user.user_id
JOIN role on project_user.role_id = role.id
LEFT JOIN access_component_user ON user.id = access_component_user.user_id
WHERE project_user.project_id = $project_id AND user.id != $user_id
GROUP BY project_user.user_id, project_user.project_id, access_component_user.user_id
roles: "[\"Координатор\", \"Координатор\", \"Супервайзер\", \"Супервайзер\"]"
* {
scrollbar-width: none;
}
html {
scrollbar-width: none;
}
echo $array[$i].' <br>';
echo $array[$i] . ' <br>';
this.file = this.$refs.file.files[0];
let formData = new FormData();
formData.append('file', this.file);
fetch('https://api.isinda.ru/table/default/gii', {
method: 'POST',
headers: {
// "Content-Type": "application/json",
},
body: formData,
})
.then(data => { return data.json()})
.then(data => { console.log(data) });
$request = Yii::$app->request;
$file = $request->post();
return $file;