categories.php

<?php
/**
 * Allows to hide, show or delete the files assigned to the
 * selected client.
 */
$allowed_levels = array(9, 8, 7);
require_once 'bootstrap.php';

$active_nav = 'files';

$page_title = __('Categories administration', 'cftp_admin');

$page_id = 'categories_list';

$current_url = get_form_action_with_existing_parameters(basename(__FILE__));

// Apply the corresponding action to the selected categories.
if (isset($_POST['action'])) {
    if ($_POST['action'] != 'none') {
        // Continue only if 1 or more categories were selected. */
        if (!empty($_POST['batch'])) {
            // Make a list of categories to avoid individual queries.
            $selected_categories = $_POST['batch'];

            if (count($selected_categories) < 1) {
                $flash->error(__('Please select at least one category.', 'cftp_admin'));
            } else {
                switch ($_POST['action']) {
                    case 'delete':
                        foreach ($selected_categories as $category_id) {
                            $category = new \ProjectSend\Classes\Categories($category_id);
                            $delete_category = $category->delete();
                        }

                        $flash->success(__('The selected categories were deleted.', 'cftp_admin'));
                        break;
                }
            }

            ps_redirect($current_url);
        }
    }
}

// Get all the existing categories
$params = [];

$results_show = 'arranged';
// Add the search terms
if (isset($_GET['search']) && !empty($_GET['search'])) {
    $params['search'] = $_GET['search'];
    $results_show = 'categories'; // show from all categories, not the arranged array
}

$params['page'] = (isset($_GET["page"])) ? $_GET["page"] : 1;
$page = $params['page'];

$categories = null;
$arranged = null;
$get_categories = get_categories($params);
if (!empty($get_categories['categories'])) {
    $categories    = $get_categories['categories'];
    $arranged = $get_categories['arranged'];
}

/**
 * Adding or editing a category
 *
 * By default, the action is ADD category
 */
$success_message = __('The category was successfully created.', 'cftp_admin');
$form_information = array(
    'type' => 'create',
    'title' => __('Create new category', 'cftp_admin'),
);

// Loading the form in EDIT mode
$category_parent = null;
if ((isset($_GET['form']) && $_GET['form'] == 'edit') or !empty($_POST['editing_id'])) {
    $action = 'edit';
    $editing = !empty($_POST['editing_id']) ? $_POST['editing_id'] : $_GET['id'];
    $success_message = __('The category was successfully edited.', 'cftp_admin');
    $form_information = array(
        'type' => 'edit',
        'title' => __('Edit category', 'cftp_admin'),
    );

    // Get the current information if just entering edit mode
    $category_name = $categories[$editing]['name'];
    $category_parent = $categories[$editing]['parent'];
    $category_description = $categories[$editing]['description'];
}

// Process the action
if (isset($_POST['btn_process'])) {
    // Applies for both ADDING a new category as well  as editing one but with the form already sent.
    $category_object = new \ProjectSend\Classes\Categories();

    $arguments = array(
        'name' => $_POST['category_name'],
        'parent' => $_POST['category_parent'],
        'description' => $_POST['category_description'],
    );
    if ($form_information['type'] == 'edit') {
        $arguments['id'] = ($_POST) ? $_POST['editing_id'] : $_GET['id'];
    }

    $category_object->set($arguments);
    $method = $form_information['type'];
    $process = $category_object->{$method}($arguments);

    if ($process['status'] == 'success') {
        $flash->success($success_message);
    } else {
        $flash->error($process['message']);
    }

    // Redirect so the actions are reflected immediately
    ps_redirect(BASE_URI . 'categories.php');
}


if ($get_categories['count'] == 0) {
    if (!empty($get_categories['no_results_type'])) {
        switch ($get_categories['no_results_type']) {
            case 'search':
                $flash->error(__('Your search keywords returned no results.', 'cftp_admin'));
                break;
        }
    } else {
        $flash->warning(__('There are no categories yet.', 'cftp_admin'));
    }
}


// Search + filters bar data
$search_form_action = 'categories.php';

// Results count and form actions 
$elements_found_count = $get_categories['count'];
$bulk_actions_items = [
    'none' => __('Select action', 'cftp_admin'),
    'delete' => __('Delete', 'cftp_admin'),
];

include_once ADMIN_VIEWS_DIR . DS . 'header.php';

include_once LAYOUT_DIR . DS . 'search-filters-bar.php';
?>

<div class="row">
    <div class="col-12 col-sm-12 col-md-8">
        <form action="<?php echo $current_url; ?>" class="form-inline batch_actions" name="selected_categories" id="selected_categories" method="post">
            <?php addCsrf(); ?>
            <?php include_once LAYOUT_DIR . DS . 'form-counts-actions.php'; ?>

            <div class="row">
                <div class="col-12">
                    <?php
                    if ($get_categories['count'] > 0) {

                        // Generate the table using the class.
                        $table = new \ProjectSend\Classes\Layout\Table([
                            'id' => 'categories_tbl',
                            'class' => 'footable table',
                        ]);

                        $thead_columns = array(
                            array(
                                'select_all' => true,
                                'attributes' => array(
                                    'class' => array('td_checkbox'),
                                ),
                            ),
                            array(
                                'sort_url' => 'name',
                                'sort_default' => true,
                                'content' => __('Name', 'cftp_admin'),
                            ),
                            array(
                                'content' => __('Files', 'cftp_admin'),
                            ),
                            array(
                                'content' => __('Description', 'cftp_admin'),
                                'hide' => 'phone',
                            ),
                            array(
                                'content' => __('View', 'cftp_admin'),
                                'hide' => 'phone',
                            ),
                            array(
                                'content' => __('Actions', 'cftp_admin'),
                                'hide' => 'phone',
                            ),
                        );
                        $table->thead($thead_columns);

                        /**
                         * Having the formatting function here seems more convenient
                         * as the HTML layout is easier to edit on it's real context.
                         */
                        $c = 0;

                        $pagination_page = $page;
                        $pagination_start = ($pagination_page - 1) * get_option('pagination_results_per_page');
                        $limit_start = $pagination_start;
                        $limit_number = get_option('pagination_results_per_page');
                        $limit_amount = $limit_start + get_option('pagination_results_per_page');

                        $i = 0;

                        function format_category_row($arranged)
                        {
                            global $table, $c, $i, $page, $pagination_page, $pagination_start, $limit_start, $limit_number, $limit_amount;

                            $c++;
                            if (!empty($arranged)) {
                                foreach ($arranged as $category) {
                                    /**
                                     * Horrible hacky way to limit results on the table.
                                     * The real filtered results should come from the
                                     * 'arranged' array of the get_categories results.
                                     */
                                    $i++;
                                    if ($i > $limit_start && $i <= $limit_amount) {

                                        $table->addRow();

                                        $depth = ($category['depth'] > 0) ? str_repeat('&mdash;', $category['depth']) . ' ' : false;

                                        $total = $category['file_count'];
                                        if ($total > 0) {
                                            $class = 'bg-success';
                                            $files_link = 'manage-files.php?category=' . $category['id'];
                                            $files_button = 'btn-primary';
                                        } else {
                                            $class = 'bg-danger';
                                            $files_link = 'javascript:void(0);';
                                            $files_button = 'btn-pslight disabled';
                                        }

                                        $count_format = '<span class="badge ' . $class . '">' . $total . '</span>';

                                        $tbody_cells = array(
                                            array(
                                                'checkbox' => true,
                                                'value' => $category["id"],
                                            ),
                                            array(
                                                'content' => $depth . html_output($category["name"]),
                                                'attributes' => array(
                                                    'data-value' => $c,
                                                ),
                                            ),
                                            array(
                                                'content' => $count_format,
                                            ),
                                            array(
                                                'content' => html_output($category["description"]),
                                            ),
                                            array(
                                                'content' => '<a href="' . $files_link . '" class="btn btn-sm ' . $files_button . '">' . __('Manage files', 'cftp_admin') . '</a>',
                                            ),
                                            array(
                                                'content' => '<a href="categories.php?form=edit&id=' . $category["id"] . '" class="btn btn-primary btn-sm"><i class="fa fa-pencil"></i><span class="button_label">' . __('Edit', 'cftp_admin') . '</span></a>'
                                            ),
                                        );
                                        foreach ($tbody_cells as $cell) {
                                            $table->addCell($cell);
                                        }

                                        $table->end_row();
                                    }

                                    $children = $category['children'];
                                    if (!empty($children)) {
                                        format_category_row($children);
                                    }
                                }
                            }
                        }

                        if ($get_categories['count'] > 0) {
                            format_category_row($get_categories[$results_show]);
                        }

                        echo $table->render();
                    }
                ?>
                </div>
            </div>
        </form>

        <?php
            if ($get_categories['count'] > 0) {
                // PAGINATION
                $pagination = new \ProjectSend\Classes\Layout\Pagination;
                echo $pagination->make([
                    'link' => basename($_SERVER['SCRIPT_FILENAME']),
                    'current' => $params['page'],
                    'item_count' => $get_categories['count'],
                ]);
            }
        ?>
    </div>
    <div class="col-12 col-sm-12 col-md-4">
        <?php include_once FORMS_DIR . DS . 'categories.php'; ?>
    </div>
</div>

<?php
include_once ADMIN_VIEWS_DIR . DS . 'footer.php';