HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-31-18-78 6.17.0-1017-aws #17~24.04.1-Ubuntu SMP Tue May 26 21:09:53 UTC 2026 aarch64
User: ubuntu (1000)
PHP: 8.2.31
Disabled: NONE
Upload Files
File: /var/www/content-sp/work-sp/nqb_master_print_structure.php
<?php
include_once('nqb_master_section.php');

//check master permissions
$fileName = 'nqb_master_create_structure';
if (in_array($fileName, $pageArray)) {

    $curDate = date('Y-m-d H:i:s');
    $SP_MASTER_CATEGORY = 'csp_sp_master_category';
    $SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
    $SP_MEDIUM = 'csp_sp_medium';
    $allMaster = $conn->query("SELECT mc.master_id, mc.master_name,mc.source from $SP_MASTER_CATEGORY as mc order by mc.master_name asc");
    $getMediums = $conn->query("SELECT medium_id,medium_name FROM $SP_MEDIUM order by medium_id");

    if (isset($_POST['submit'])) {
        unset($_SESSION['page_masterID']);
        unset($_SESSION['page_catID']);
        $master = $_REQUEST['master'];
        $subject = $_REQUEST['subject'];
        if ($master != '' && $subject != '') {
            $_SESSION['page_masterID'] = $master;
            $_SESSION['page_catID'] = $subject;
        }
    }
?>
    <style>
        .table-hover th,
        td {
            font-size: 13px;
        }

        .redClass {
            background-color: #ff6d6d !important;
        }

        .orangeClass {
            background-color: #ff7607 !important;
        }

        .modal-backdrop.in {
            opacity: 0.9 !important;
            z-index: 9 !important;
        }

        .topic {
            width: 20%;
            float: left;
            font-size: 14px;
            margin: 0 0 0 0;
        }

        .sub_topic {
            width: 16%;
            float: left;
            font-size: 14px;
            margin: 0 0 0 8px;
        }
    </style>
    <div class="row">
        <?php if (isset($message)) { ?>
            <div class="col-md-12">
                <?php echo $message; ?>
            </div>
        <?php } ?>
        <div class="col-md-12">
            <div class="panel panel-info">
                <div class="panel-heading clearfix">
                    <h4 class="panel-title">Select Master</font>
                    </h4>
                </div>
                <div class="clearfix"></div>
                <div class="panel-body">
                    <form class="form-inline" method="post">
                        <div class="form-group">
                            <select name="master" id="master" class="form-control">
                                <option value="">--Master--</option>
                                <?php while ($ms = $allMaster->fetch_assoc()) { ?>
                                    <option value="<?php echo $ms['master_id']; ?>"><?php echo $ms['source'] . '-' . $ms['master_name']; ?></option>
                                <?php } ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <select name="subject" class="form-control" id="subject">
                                <option value="S">--Subject--</option>
                            </select>
                        </div>
                        <input class="btn btn-info" type="submit" value="Select Master" name="submit" />
                    </form>
                </div>
            </div>
        </div>
        <div class="col-md-12">
            <div class="panel panel-info">
                <?php
                if (isset($_SESSION['page_masterID'])) {
                    $from_id = $_SESSION['page_catID'];
                    $showName = $conn->query("SELECT mc.master_name,ms.category_name from $SP_MASTER_STRUCTURE as ms LEFT JOIN $SP_MASTER_CATEGORY as mc on mc.master_id=ms.master_id where ms.sub_id=$from_id");
                    $result = $showName->fetch_assoc();

                ?>
                    <div class="panel-heading clearfix">
                        <h4 class="panel-title" style="width: 100%;">Master Structure [ <?php echo $result['master_name'] . " - " . $result['category_name'] . ' - ' . $_SESSION['page_masterID']; ?> ]
                            <?php
                            if (isset($_SESSION['page_masterID'])) {   ?>
                                <button style="float: right;margin: -8px 0px 0px 0px;" type="button" class="btn btn-danger btn-rounded" data-toggle="modal" data-target=".bs-example-modal-lg">Add Subjects</button>
                            <?php } ?>
                        </h4>

                    </div>
                    <div class="panel-body">
                        <?php
                        $path = '../work-sp/nqb_master_print_structure_treeview.php'; //new_question_bank_structure.php
                        include_once($path); ?>
                    </div>
                <?php }
                ?>
            </div>
        </div>
        <div class="page-footer">
            <p class="no-s">Graposs Connect &#169;</p>
        </div>
    </div><!-- Page Inner -->
    <script>
        jQuery.noConflict();
        jQuery(document).ready(function() {

            jQuery('#master').on('change', function() {
                var mid = jQuery("#master").val();
                var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + mid + "&type=master";
                var jqxhr = jQuery.get(loadUrl);
                jqxhr.success(function(data) {
                    jQuery("#subject").html(data);
                });
            });
        });
    </script>
<?php
} else {
    echo "<script>alert('You dont have access for create master structure');</script>";
    echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>