/**
* 分類の並び順を一括変更
*
* @param array $data
*
* @return void
*/
function service_category_sort($data)
{
// 並び順を更新
foreach ($data as $id => $sort) {
if (!preg_match('/^[\\w\\-\\/]+$/', $id)) {
continue;
}
if (!preg_match('/^\\d+$/', $sort)) {
continue;
}
$resource = update_categories(array('set' => array('sort' => $sort), 'where' => array('id = :id', array('id' => $id))));
if (!$resource) {
error('データを編集できません。');
}
}
return;
}
// フォワードを確認
if (forward() === null) {
error('不正なアクセスです。');
}
// 投稿データを確認
if (empty($_SESSION['post'])) {
// リダイレクト
redirect('/admin/category_form');
}
// トランザクションを開始
db_transaction();
if (empty($_SESSION['post']['category']['id'])) {
// 分類を登録
$resource = insert_categories(array('values' => array('name' => $_SESSION['post']['category']['name'], 'sort' => $_SESSION['post']['category']['sort'])));
if (!$resource) {
error('データを登録できません。');
}
} else {
// 分類を編集
$resource = update_categories(array('set' => array('name' => $_SESSION['post']['category']['name']), 'where' => array('id = :id', array('id' => $_SESSION['post']['category']['id']))), array('id' => intval($_SESSION['post']['category']['id']), 'update' => $_SESSION['update']['category']));
if (!$resource) {
error('データを編集できません。');
}
}
// トランザクションを終了
db_commit();
// 投稿セッションを初期化
unset($_SESSION['post']);
unset($_SESSION['update']);
// リダイレクト
redirect('/admin/category?ok=post');
$category_id_all = array();
if ($prep_stmt = "SELECT category_id , name FROM category WHERE parent = 1 order by category_id") {
}
$stmt = $mysqli->prepare($prep_stmt);
if ($stmt) {
$stmt->execute();
// Execute the prepared query.
$stmt->store_result();
$stmt->bind_result($category_id, $name);
if ($stmt->num_rows > 0) {
$a = 0;
while ($row = $stmt->fetch()) {
$category_id_all[$a] = $category_id;
$a = $a + 1;
}
if (update_categories($mysqli, 'update_categories', $category_id_all)) {
echo "<script>setTimeout(function() { alert('Category updated'); }, 1); </script>";
}
$get_categories = array();
$get_categories = get_all_categories_from_db($mysqli);
$i = 0;
while (count($get_categories) > $i) {
?>
<li><a href='#' onclick="return confirm_it('?deleted-<?php
echo $category_id_all[$i];
?>
-<?php
echo $get_categories[$i];
?>
','Do you want to delete this category?');"><img src='<?php
echo site_name;
switch ($tabtable->get_active_tab_id()) {
case 'welcome':
echo '<h1>' . $name . '</h1>';
break;
case 'permissions':
if ($func == 'mod_permissions') {
mod_permissions($_POST['Sel'], $_POST['dest_group']);
}
$button_submit = $button->get_button($cmdOk, "this.form.Sel.value = makeStringFromSelect(this.form.SelItems); this.form.submit();");
$button_left = $button->get_button($cmdAdd, "javascript:addItems(this.form.AvailItems, this.form.SelItems);");
$button_right = $button->get_button($cmdDelete, "javascript:removeItems(this.form.SelItems);");
edit_permissions();
break;
case 'categories':
if ($func == 'update_categories') {
update_categories($_POST['Sel']);
}
edit_categories();
break;
case 'agents':
if ($func == 'update_agents') {
update_agents($_POST['Sel'], $_POST['dest_group']);
}
$button_submit = $button->get_button($cmdOk, "this.form.Sel.value = makeStringFromSelect(this.form.SelItems); this.form.submit();");
$button_left = $button->get_button($cmdAdd, "javascript:addItems(this.form.AvailItems, this.form.SelItems);");
$button_right = $button->get_button($cmdDelete, "javascript:removeItems(this.form.SelItems);");
echo '<table width=100%><tr>';
echo '<td>' . edit_agents() . '</td></tr></table>';
break;
case 'projects':
if ($func == 'update_projects') {
