File: /var/www/content-sp/work-sp/nqb_masters_treeview_dummy.php
<?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='$from_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,count(CASE WHEN status='3' OR status='4' THEN 1 END) as prf1 FROM $SP_QUESTION where master_id='$masterID' and subject_id='$tree_sub_id' and medium_id='$src_med'");
$countSubQ = $subjectQ->fetch_assoc();
$subjectQuesSec = $conn->query("SELECT count(sqm.question_id) as sec_total_q FROM $SP_QUESTION_MEDIUM_WISE as sqm INNER JOIN $SP_QUESTION as sq ON sq.question_id=sqm.question_id where sq.master_id='$masterID' and sq.subject_id='$tree_sub_id' and sqm.medium_id='$tar_med'");
$countSubSecQ = $subjectQuesSec->fetch_assoc();
?>
<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']; ?>
</div>
<div class="col-md-6">
[<font title="Primary Questions"><?php echo $countSubQ['total_q']; ?></font>]
[<font title="Proof Read Questions"><?php echo $countSubQ['prf1']; ?></font>]
[<font title="Secondary Questions"><?php echo $countSubSecQ['sec_total_q']; ?></font>]
</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,count(CASE WHEN status='3' OR status='4' THEN 1 END) as prf1 FROM $SP_QUESTION where master_id='$masterID' and topic_id='$tree_last_sub' and medium_id='$src_med'");
$countTopQ = $topicQ->fetch_assoc();
$topicSecQ = $conn->query("SELECT count(sqm.question_id) as sec_total_q FROM $SP_QUESTION_MEDIUM_WISE as sqm INNER JOIN $SP_QUESTION as sq ON sq.question_id=sqm.question_id where sq.master_id='$masterID' and sq.topic_id='$tree_last_sub' and sqm.medium_id='$tar_med'");
$countTopSecQ = $topicSecQ->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">
<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>
<?php
} ?>
<?php echo $t['category_name']; ?>
</div>
<div class="col-md-3">
[<font title="Primary Questions"><?php echo $countTopQ['total_q']; ?></font>]
[<font title="Proof Read Questions"><?php echo $countTopQ['prf1']; ?></font>]
[<font title="Secondary Questions"><?php echo $countTopSecQ['sec_total_q']; ?></font>]
</div>
<?php if ($ifSubExist == 0) { ?>
<div class="col-md-2">
<a href="/work-sp/nqb_add_question.php?sub_topic_id=<?php echo $tree_last_sub . '&topic_id=' . $tree_sub_id . '&subject_id=0&master_id=' . $masterID . '&mType=' . $masterType ?>" target="_blank" rel="noopener noreferrer">Add Question</a>
</div>
<div class="col-md-1">
<a href="/work-sp/nqb_add_question_upload_by_excel.php?sub_topic_id=<?php echo $tree_last_sub . '&topic_id=' . $tree_sub_id . '&subject_id=0&master_id=' . $masterID . '&mType=' . $masterType ?>" target="_blank" rel="noopener noreferrer">Upload</a>
</div>
<div class="col-md-1">
<a href="/work-sp/nqb_question_status_popup?tpcId=<?php echo $tree_last_sub; ?>&m=<?php echo $src_med . '&mType='.$masterType; ?>" data-backdrop="static" data-id="<?php echo $tree_last_sub; ?>" target="_blank">Status</a>
</div>
<div class="col-md-1">
<a href="/work-sp/group_question_in_master?tpcId=<?php echo $tree_last_sub; ?>&m=<?php echo $src_med . '&mType='.$masterType; ?>" data-backdrop="static" data-id="<?php echo $tree_last_sub; ?>" target="_blank">Group</a>
</div>
<div class="col-md-1">
<a href="/work-sp/nqb_pyp_question_status_popup?tpcId=<?php echo $tree_last_sub; ?>&m=<?php echo $src_med . '&mType=sp'; ?>" data-backdrop="static" data-id="<?php echo $tree_last_sub; ?>" target="_blank">PYP</a>
</div>
<?php } ?>
</div>
</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,count(CASE WHEN status='3' OR status='4' THEN 1 END) as prf1 FROM $SP_QUESTION where master_id='$masterID' and sub_topic_id='$tree_last_subtopic' and medium_id='$src_med'");
$countsubTopQ = $subtopicQ->fetch_assoc();
$subTopicSecQ = $conn->query("SELECT count(sqm.question_id) as sec_total_q FROM $SP_QUESTION_MEDIUM_WISE as sqm INNER JOIN $SP_QUESTION as sq ON sq.question_id=sqm.question_id where sq.master_id='$masterID' and sq.sub_topic_id='$tree_last_subtopic' and sqm.medium_id='$tar_med'");
$countSubTopSecQ = $subTopicSecQ->fetch_assoc();
?>
<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> <?php echo $st['category_name']; ?>
</div>
<div class="col-md-3">
[<font title="Primary Questions"><?php echo $countsubTopQ['total_q']; ?></font>]
[<font title="Proof Read Questions"><?php echo $countsubTopQ['prf1']; ?></font>]
[<font title="Secondary Questions"><?php echo $countSubTopSecQ['sec_total_q']; ?></font>]
</div>
<div class="col-md-2">
<a href="/work-sp/nqb_add_question.php?sub_topic_id=<?php echo $tree_last_subtopic . '&topic_id=' . $tree_last_sub . '&subject_id=' . $tree_sub_id . '&master_id=' . $masterID . '&mType=' . $masterType ?>" target="_blank" rel="noopener noreferrer">Add Question</a>
</div>
<div class="col-md-1">
<a href="/work-sp/nqb_add_question_upload_by_excel.php?sub_topic_id=<?php echo $tree_last_subtopic . '&topic_id=' . $tree_last_sub . '&subject_id=' . $tree_sub_id . '&master_id=' . $masterID . '&mType=' . $masterType ?>" target="_blank" rel="noopener noreferrer">Upload</a>
</div>
<div class="col-md-1">
<a href="/work-sp/nqb_question_status_popup?tpcId=<?php echo $tree_last_subtopic; ?>&m=<?php echo $src_med . '&mType='.$masterType; ?>" data-backdrop="static" data-id="<?php echo $tree_last_subtopic; ?>" target="_blank">Status</a>
</div>
<div class="col-md-1">
<a href="/work-sp/group_question_in_master?tpcId=<?php echo $tree_last_subtopic; ?>&m=<?php echo $src_med . '&mType='.$masterType; ?>" data-backdrop="static" data-id="<?php echo $tree_last_subtopic; ?>" target="_blank">Group</a>
</div>
<div class="col-md-1">
<a href="/work-sp/nqb_pyp_question_status_popup?tpcId=<?php echo $tree_last_subtopic; ?>&m=<?php echo $src_med . '&mType=sp'; ?>" data-backdrop="static" data-id="<?php echo $tree_last_subtopic; ?>" target="_blank">PYP</a>
</div>
</div>
</div>
</li>
</ol>
<?php }
} ?>
</li>
</ol>
<?php } ?>
</li>
</ol>
</div>
</div>
</div>
<!-- <ul>
<li>
<?php echo $main['category_name']; ?> (<?php echo $countSubQ['total_q']; ?>)</li>
</ul> -->