示例#1
0
        echo message::success(lang::get('file_deleted'));
    }
}
if (in_array($action, ['save-add', 'save-edit']) && dyn::get('user')->hasPerm('media[category][edit]')) {
    $sql = sql::factory();
    $sql->setTable('media_cat');
    $sql->setWhere('id=' . $id);
    $sql->getPosts(['name' => 'string', 'sort' => 'int', 'pid' => 'int']);
    if ($action == 'save-edit') {
        $sql->update();
    } else {
        $sql->save();
    }
    $sort = type::post('sort', 'int');
    $parent_id = type::post('pid', 'int');
    sql::sortTable('media_cat', $sort, '`pid` = ' . $parent_id . ' AND id != ' . $id);
}
$table = table::factory(['class' => ['js-sort']]);
$colFirstWidth = $action == 'edit' || $action == 'add' ? 50 : 25;
$table->addCollsLayout($colFirstWidth . ',*, 110');
$table->addRow()->addCell()->addCell(lang::get('category'))->addCell(lang::get('action'));
$table->addSection('tbody');
$table->setSql('SELECT * FROM ' . sql::table('media_cat') . ' WHERE pid = ' . $pid . ' ORDER BY sort ASC');
if (in_array($action, ['edit', 'add']) && dyn::get('user')->hasPerm('media[category][edit]')) {
    echo '<form method="post" action="index.php">';
    $inputHidden = formInput::factory('action', 'save-' . $action);
    $inputHidden->addAttribute('type', 'hidden');
    echo $inputHidden->get();
    $inputHidden = formInput::factory('page', 'media');
    $inputHidden->addAttribute('type', 'hidden');
    echo $inputHidden->get();
示例#2
0
 protected static function saveSortUp($id, $sort)
 {
     sql::sortTable('structure_area', $sort, '`structure_id` = ' . $id);
 }
示例#3
0
             $id = $sql->get('id');
             $delete = sql::factory();
             $delete->setTable('structure');
             $delete->setWhere('id=' . $id);
             $delete->delete();
         } else {
             $id = false;
         }
     }
     $sql = sql::factory();
     $sql->query('SELECT `sort`, `parent_id` FROM ' . sql::table('structure') . ' WHERE id=' . $orginal_id)->result();
     $delete = sql::factory();
     $delete->setTable('structure');
     $delete->setWhere('id=' . $orginal_id);
     $delete->delete();
     sql::sortTable('structure', 0, '`parent_id` = ' . $sql->get('parent_id'));
     echo message::success(lang::get('structure_delete'));
     $action = '';
 }
 if ($action == 'online' && dyn::get('user')->hasPerm('page[edit]')) {
     $sql = sql::factory();
     $sql->query('SELECT online FROM ' . sql::table('structure') . ' WHERE id=' . $id)->result();
     $online = $sql->get('online') ? 0 : 1;
     $sql->setTable('structure');
     $sql->setWhere('id=' . $id);
     $sql->addPost('online', $online);
     $sql->update();
     echo message::success(lang::get('save_status'));
     $action = '';
 }
 if ($action == '') {
示例#4
0
 protected static function saveSortUp($id, $sort, $block)
 {
     $block = $block ? 1 : 0;
     sql::sortTable('structure_area', $sort, '`structure_id` = ' . $id . ' AND `block` = ' . $block);
 }