$count = $row['cnt'];
}
// --- データ取得
$sql = "{$sel_sql}{$sort_sql}{$limit_sql}";
$stmt = $db->prepare($sql);
$stmt->execute();
$user_list = array();
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
$user = $row;
// パスワード情報は漏洩させない
unset($user['password']);
// 所属グループを全て取得
$sql = getSQLBaseForUserGrp();
$sql .= " WHERE user_id = :user_id";
foreach (R::getAll($sql, array('user_id' => $user['user_id'])) as $usergrp) {
$sql = getSQLBaseForGrp();
$sql .= " AND grp_id = :grp_id";
foreach (R::getAll($sql, array('grp_id' => $usergrp['grp_id'])) as $grp) {
$user['grp_name'] = $grp['grp_name'];
$user['grp_id'] = $grp['grp_id'];
}
}
// 権限情報設定
$role_arr = str_split($user['role']);
$user['role_aprv'] = $role_arr[0];
$user['role_upld'] = $role_arr[1];
$user['role_user'] = $role_arr[2];
array_push($user_list, $user);
}
// ---------------------------
// 終了処理
include_once __DIR__ . "/login_check.php";
include_once __DIR__ . "/../../sop/src/config.php";
include_once __DIR__ . "/../../sop/src/db_common.php";
/**
* グループ 登録 更新
*/
$db = createDBConnection();
// ---------------------------
// parameters 取得
// ---------------------------
$grp_id = array_key_exists('grp_id', $_REQUEST) ? $_REQUEST['grp_id'] : '';
$grp_name = array_key_exists('grp_name', $_REQUEST) ? $_REQUEST['grp_name'] : '';
$div = trim($grp_id) == '' ? 'add' : 'upd';
if ($div == 'upd') {
// --- 存在チェック
$sel_sql = getSQLBaseForGrp();
$sel_sql .= " AND grp_id = :grp_id";
$sql = "SELECT count(*) cnt FROM ({$sel_sql}) as tmp";
$params = array();
$params[':grp_id'] = $grp_id;
$stmt = $db->prepare($sql);
$stmt->execute($params);
$cnt = 0;
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
$cnt = (int) $row['cnt'];
}
if ($cnt == 0) {
\Sop\Log::warning(__FILE__, __LINE__, 'User tried to update non-existent group.');
$msg001 = "This group already has been deleted.";
// このグループは既に削除されています
\Sop\Api::exitWithError(array($msg001));