<?php

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

$getMainTopic = $conn->query("SELECT category_name,sub_id FROM $SP_MASTER_STRUCTURE where sub_id='$csc_subject_id' order by display_order");
$main = $getMainTopic->fetch_assoc();
$tree_sub_id = $main['sub_id'];
$subjectQ = $conn->query("SELECT count(question_id) as total_q FROM $SP_QUESTION where master_id='$csc_master_id' and subject_id='$tree_sub_id'");
$countSubQ = $subjectQ->fetch_assoc();


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

    .span_fill {
        margin: 0 100px 0 0;
    }
    label {
        display: block;
    }
</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-12" title="<?php echo $tree_sub_id; ?>">
                                <i class="fa fa-book"></i> <?php echo $main['category_name']; ?>&nbsp;
                                [<?php echo $countSubQ['total_q']; ?>]
                            </div>
                        </div>
                    </div>
                    <?php
                    $getTopics = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where parent_id='$tree_sub_id' order by display_order");
                    foreach ($getTopics as $t) {
                        /************ */
                        $tree_last_sub = $t['sub_id'];
                        $topicQ = $conn->query("SELECT count(question_id) as total_q FROM $SP_QUESTION where master_id='$csc_master_id' and topic_id='$tree_last_sub'");
                        $countTopQ = $topicQ->fetch_assoc();

                        //**** */
                        $getSubtopic = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where parent_id='$tree_last_sub' order by display_order");
                        $ifSubExist = mysqli_num_rows($getSubtopic);
                    ?>
                        <ol class="dd-list">
                            <li class="dd-item" data-id="<?php echo $tree_last_sub; ?>">
                                <div class="dd-handle">
                                    <label for="sub_<?php echo $tree_last_sub; ?>">
                                    <div class="row">
                                        <div class="col-md-12" title="<?php echo $tree_last_sub; ?>">
                                            <?php if ($ifSubExist > 0) { ?>
                                                <i class="fa fa-level-down"></i>
                                            <?php } else {
                                            ?>
                                                <input type="radio" name="move_in_topic" value="<?php echo $csc_exam_id.'-'.$csc_master_id.'-'.$csc_subject_id.'-'.$tree_last_sub.'-'; ?>" id="sub_<?php echo $tree_last_sub; ?>">
                                                <i class="fa fa-arrow-right"></i>&nbsp;
                                            <?php
                                            } ?>
                                            <?php echo $t['category_name']; ?>&nbsp;
                                            [<?php echo $countTopQ['total_q']; ?>]
                                        </div>
                                    </div>
                                    </label>
                                </div>
                                <?php

                                if ($ifSubExist > 0) {
                                    foreach ($getSubtopic as $st) {
                                        $tree_last_subtopic = $st['sub_id'];
                                        $subtopicQ = $conn->query("SELECT count(question_id) as total_q FROM $SP_QUESTION where master_id='$csc_master_id' and sub_topic_id='$tree_last_subtopic'");
                                        $countsubTopQ = $subtopicQ->fetch_assoc();

                                ?>
                                        <ol class="dd-list">
                                            <li class="dd-item" data-id="<?php echo $tree_last_subtopic; ?>">
                                                <div class="dd-handle">
                                                <label for="sub_<?php echo $tree_last_subtopic; ?>">
                                                    <div class="row">
                                                        <div class="col-md-12" title="<?php echo $tree_last_subtopic; ?>">
                                                            <input type="radio" name="move_in_topic" value="<?php echo $csc_exam_id.'-'.$csc_master_id.'-'.$csc_subject_id.'-'.$tree_last_sub.'-'.$tree_last_subtopic; ?>" id="sub_<?php echo $tree_last_subtopic; ?>">
                                                            <i class="fa fa-arrow-right"></i>&nbsp;<?php echo $st['category_name']; ?>&nbsp;
                                                            [<?php echo $countsubTopQ['total_q']; ?>]
                                                        </div>
                                                    </div>
                                                </label>
                                                </div>
                                            </li>
                                        </ol>
                                <?php }
                                } ?>
                            </li>
                        </ol>
                    <?php } ?>
                </li>
            </ol>
        </div>
    </div>
</div>