<?php

$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';

$getMainTopic = $conn->query("SELECT category_name,sub_id FROM $SP_MASTER_STRUCTURE where sub_id='$from_id' order by sub_id");
$main = $getMainTopic->fetch_assoc();
$tree_sub_id = $main['sub_id'];

?>
<style>
    #nestable {
        max-width: 100% !important;
    }

    .span_fill {
        margin: 0 100px 0 0;
    }
</style>
<!----Main Subject----->
<div class="row">
    <div class="col-md-12">
        <div class="dd" id="nestable">
            <ol class="dd-list">
                <li class="dd-item" data-id="<?php echo $tree_sub_id; ?>">
                    <div class="dd-handle">
                        <div class="row">
                            <div class="col-md-3" title="<?php echo $tree_sub_id; ?>">
                                <i class="fa fa-book"></i> <?php echo $main['category_name']; ?>&nbsp;
                            </div>
                        </div>
                    </div>
                    <?php
                    $getTopics = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where parent_id='$tree_sub_id' order by sub_id");
                    foreach ($getTopics as $t) {
                        /************ */
                        $tree_last_sub = $t['sub_id'];

                        //**** */
                        $getSubtopic = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where parent_id='$tree_last_sub' order by sub_id");
                        $ifSubExist = mysqli_num_rows($getSubtopic);
                    ?>
                        <ol class="dd-list">
                            <li class="dd-item" data-id="<?php echo $tree_last_sub; ?>">
                                <div class="dd-handle">
                                    <div class="row">
                                        <div class="col-md-3" title="<?php echo $tree_last_sub; ?>">
                                            <?php if ($ifSubExist > 0) { ?>
                                                <i class="fa fa-level-down"></i>
                                            <?php } else {
                                            ?>
                                                <i class="fa fa-arrow-right"></i>&nbsp;
                                            <?php
                                            } ?>
                                            <?php echo $t['category_name']; ?>&nbsp;
                                        </div>
                                    </div>
                                </div>
                                <?php

                                if ($ifSubExist > 0) {
                                    foreach ($getSubtopic as $st) {
                                        $tree_last_subtopic = $st['sub_id'];
                                ?>
                                        <ol class="dd-list">
                                            <li class="dd-item" data-id="<?php echo $tree_last_subtopic; ?>">
                                                <div class="dd-handle">
                                                    <div class="row">
                                                        <div class="col-md-3" title="<?php echo $tree_last_subtopic; ?>">
                                                            <i class="fa fa-arrow-right"></i>&nbsp;<?php echo $st['category_name']; ?>&nbsp;
                                                        </div>
                                                    </div>
                                                </div>
                                            </li>
                                        </ol>
                                <?php }
                                } ?>
                            </li>
                        </ol>
                    <?php } ?>
                </li>
            </ol>
        </div>
    </div>
</div>