$sel_sql = getSQLBaseForPjSmplList();
$sel_sql .= " WHERE pj_smpl.pj_id = :pj_id AND v_pj.grp_id = :grp_id";
$params = array();
$params[':pj_id'] = $pj_id;
$params[':grp_id'] = $grp_id;
// --- 件数取得
$sql = "SELECT count(*) cnt FROM ({$sel_sql}) as tmp";
$stmt = $db->prepare($sql);
$stmt->execute($params);
$cnt = 0;
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
$cnt = (int) $row['cnt'];
}
// --- データ取得
$sql = $sel_sql;
$sql .= " ORDER BY display_order LIMIT {$limit} OFFSET {$start} ";
$stmt = $db->prepare($sql);
$stmt->execute($params);
$pjsmpl_list = array();
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
array_push($pjsmpl_list, $row);
}
// ---------------------
// 出力
// ---------------------
$db = null;
header("Content-type:application/json; charset=utf-8");
$msg001 = "The system succeeded to obtaion the data.";
// データの取得に成功しました
echo json_encode(array('success' => true, 'msg' => \Sop\Api::htmlEncodeLines(array($msg001)), 'root' => \Sop\Api::htmlEncode($pjsmpl_list), 'total' => $cnt));
exit;
/**
* 共同作業者の候補一覧
*/
$db = createDBConnection();
// ---------------------
// parameters 取得
// ---------------------
$grp_id = \Sop\Session::getSiteData('grp_id');
$user_id = \Sop\Session::getSiteData('user_id');
// ---------------------
// データ取得
// ---------------------
$sel_sql = getSQLBaseForUser();
$sel_sql .= ' AND v_user.user_id != :user_id AND v_user.grp_id = :grp_id';
$results = R::getAll($sel_sql, array(':user_id' => $user_id, ':grp_id' => $grp_id));
$users = array();
$msg001 = "Please select.";
// 選択してください
$users[] = array('user_id' => '', 'text' => $msg001);
foreach ($results as $user) {
$role_user = (bool) substr($user['role'], 2, 1);
if ($role_user) {
$users[] = array('user_id' => $user['user_id'], 'text' => $user['user_id']);
}
}
// ---------------------
// 出力
// ---------------------
header("Content-type:application/json; charset=utf-8");
echo json_encode(array('success' => true, 'root' => \Sop\Api::htmlEncode($users)));
exit;
$node = array();
$node['text'] = $row['pj_name'];
$node['id'] = "pj_{$row['pj_id']}";
$node['cls'] = 'folder';
array_push($node_list, $node);
}
} else {
$pj_id = str_replace('pj_', '', $node);
$sql = getSQLBaseForSopList();
$sql .= " AND sop.pj_id = :pj_id AND v_pj.grp_id = :grp_id ORDER BY sop.sop_name";
$params = array();
$params[':pj_id'] = $pj_id;
$params[':grp_id'] = $grp_id;
$stmt = $db->prepare($sql);
$stmt->execute($params);
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
$node = array();
$node['checker_required_flag'] = $row['checker_required_flag'];
$node['text'] = $row['sop_name'];
$node['id'] = "sop_{$row['sop_id']}";
$node['cls'] = 'file';
$node['leaf'] = true;
array_push($node_list, $node);
}
}
// ---------------------------
// 終了処理
// ---------------------------
header("Content-Type: text/json");
echo json_encode(\Sop\Api::htmlEncode($node_list));
}
}
// --- テンプレートバージョン情報を付加
$sop['revision_no'] = 0;
$sop['latest_flg'] = $LATEST_FLG_NOT;
// 承認済み tpl がある場合
if (!is_null($sop['latest_tpl_id'])) {
$trgt_tpl_id = isset($sop['tpl_id']) ? $sop['tpl_id'] : $sop['latest_tpl_id'];
// $sop['tpl_id'] セット済みならfileあり、そうでなければfileなし
$sql = getSQLBaseForTplList();
$sql .= " AND tpl.tpl_id = :tpl_id";
$params = array();
$params[':tpl_id'] = $trgt_tpl_id;
$stmt = $db->prepare($sql);
$stmt->execute($params);
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
$tpl = $row;
$sop['tpl_name'] = $tpl['tpl_name'];
$sop['revision_no'] = $tpl['revision_no'];
$sop['latest_flg'] = $tpl['latest_flg'];
}
}
array_push($sop_list, $sop);
}
// ---------------------
// 出力
// ---------------------
$db = null;
header("Content-type:application/json; charset=utf-8");
echo json_encode(array('success' => true, 'msg' => \Sop\Api::htmlEncodeLines(array('データの取得に成功しました')), 'root' => \Sop\Api::htmlEncode($sop_list), 'total' => $cnt));
exit;
