File: /var/www/content-sp/work-sp/nqb_master_to_master_transfer.php
<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include_once('nqb_master_section.php');
include_once 'pagination.php';
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
//check master permissions
if (in_array($fileName, $pageArray)) {
$paguri = explode("?pageN", $_SERVER['REQUEST_URI']);
$pagination_link = $paguri[0];
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';
$SP_EDITORS = 'csp_editors';
$SP_MASTER_LEVEL = 'csp_sp_master_level';
$SP_QUESTION_DIFFICULTY = 'csp_sp_question_difficulty';
$TT_PREVIOUS_EXAM_TABLE = 'csp_sp_previous_exam';
/**medium query */
$getMedium = $conn->query("SELECT medium_id,medium_name FROM $SP_MEDIUM order by medium_id");
$allPreExams = $conn->query("SELECT id, exam_name, status from $TT_PREVIOUS_EXAM_TABLE where status = '1' order by exam_name asc");
$allLevel = $conn->query("SELECT level_name,description from $SP_MASTER_LEVEL where status='1'");
$allDifficulty = $conn->query("SELECT difficulty,description from $SP_QUESTION_DIFFICULTY where status='1'");
/**transfer in master treeview */
if (isset($_REQUEST['transfer_in'])) {
$master_in = $_REQUEST['master_in'];
$subject_in = $_REQUEST['subject_in'];
$master_type_in = $_REQUEST['master_type_in'];
$_SESSION['master_in'] = $master_in;
$_SESSION['subject_in'] = $subject_in;
$_SESSION['master_type_in'] = $master_type_in;
}
/***transfer ques */
if (isset($_REQUEST['tranfer_ques'])) {
if (isset($_SESSION['subject_in'])) {
$in_sub_id = $_REQUEST['in_sub_id'];
$trf_master = $_SESSION['master_in'];
$trf_subject = $_SESSION['subject_in'];
$ques_id = $_REQUEST['ques_id'];
$question_of = $_SESSION['master_type_in'];
if ($question_of == 'sp') {
$question_server = array("sarkari-pariksha");
$quesOfjson = json_encode($question_server, JSON_UNESCAPED_UNICODE);
} else if ($question_of == 'oly') {
$question_server = array("csc-olympiad");
$quesOfjson = json_encode($question_server, JSON_UNESCAPED_UNICODE);
} else {
$quesOfjson = '';
}
$trf_topic = $conn->query("SELECT parent_id FROM $SP_MASTER_STRUCTURE where sub_id='$in_sub_id'");
$trfT = $trf_topic->fetch_assoc();
$trf_topic_id = $trfT['parent_id'];
//check for sub topic tree
if ($trf_topic_id != 0) {
// $cscOlySub = "SELECT parent_id FROM $SP_MASTER_STRUCTURE where sub_id='$trf_topic_id'";
// $cscSub = $connL->prepare($cscOlySub);
// $cscSub->execute();
// $subject = $cscSub->fetch();
if ($trf_subject == $trf_topic_id) {
$subjId = $trf_subject;
$tpcId = $in_sub_id;
$subTpc = '0';
} else {
$subjId = $trf_subject;
$tpcId = $trf_topic_id;
$subTpc = $in_sub_id;
}
} else {
$subjId = $in_sub_id;
$tpcId = 0;
$subTpc = 0;
}
foreach ($ques_id as $q_a) {
// echo $q_a.'-'.$subjId . '-' . $tpcId . '-' . $subTpc;
// echo '<br>';
$checkQuestionOf = $conn->query("SELECT question_of FROM $SP_QUESTION where question_id='$q_a'");
$quesCheck = $checkQuestionOf->fetch_assoc();
if ($quesCheck['question_of'] == '') {
$quesOfServer = ",question_of='$quesOfjson'";
} else {
$quesOfServer = '';
}
if ($trf_master != '' && $trf_master != '0' && $trf_subject != '' && $trf_subject != '0' && $q_a != '' && $q_a != '0' && $tpcId != '' && $tpcId != '0') {
$updateQusetion = "UPDATE $SP_QUESTION set master_id='$trf_master',subject_id='$subjId',topic_id='$tpcId', sub_topic_id='$subTpc' $quesOfServer where question_id='$q_a'";
$runQuery = $conn->query($updateQusetion);
}
}
}
}
/***questions fetch */
if (isset($_REQUEST['transfer_from'])) {
$master_type = $_REQUEST['master_type'];
$master_id = $_REQUEST['master'];
$subject_id = $_REQUEST['subject'];
$topic_id = $_REQUEST['topic'];
$sub_topic_id = $_REQUEST['sub_topic'];
$source_medium = $_REQUEST['medium'];
$level = $_REQUEST['level'];
$difficulty = $_REQUEST['difficulty'];
$prev_exam = $_REQUEST['prev_exam'];
$_SESSION['trfQ_MasterType'] = $master_type;
$_SESSION['trfQ_MasterID'] = $master_id;
$_SESSION['trfQ_SubjectID'] = $subject_id;
$_SESSION['trfQ_TopicID'] = $topic_id;
$_SESSION['trfQ_SUB_TopicID'] = $sub_topic_id;
$_SESSION['trfQ_SRC_MED'] = $source_medium;
$_SESSION['trfQ_Level'] = $level;
$_SESSION['trfQ_Difficulty'] = $difficulty;
$_SESSION['trfQ_PRE_EXAM'] = $prev_exam;
}
?>
<script>
function validateForm() {
if (jQuery('#master_type').val() == "") {
alert("Master Type");
jQuery('#master_type').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#master').val() == "") {
alert("Select master");
jQuery('#master').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#subject').val() == "") {
alert("Select Subject");
jQuery('#subject').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#topic').val() == "") {
alert("Select Topic");
jQuery('#topic').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
// if (jQuery('#sub_topic').val() == "") {
// alert("Select SubTopic");
// jQuery('#sub_topic').focus();
// jQuery(":focus").css("background-color", "#f1d9d9");
// return false;
// }
}
function validateTrf2() {
if (jQuery('#master_type_in').val() == "") {
alert("Master Type");
jQuery('#master_type_in').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#master_in').val() == "") {
alert("Select master");
jQuery('#master_in').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#subject_in').val() == "") {
alert("Select Subject");
jQuery('#subject_in').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
}
</script>
<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: 26%;
float: left;
font-size: 14px;
margin: 0 0 0 -19px;
}
.fixed-div {
position: fixed;
top: 60;
bottom: 50;
right: 5;
width: 44%;
/* left: 0; */
height: 76%;
z-index: 1030;
}
.overflow-auto::-webkit-scrollbar-track {
-webkit-box-shadow: inset 0 0 6px rgba(0, 0, 0, 0.3);
background-color: #F5F5F5;
}
.overflow-auto::-webkit-scrollbar {
width: 6px;
background-color: #F5F5F5;
}
.overflow-auto::-webkit-scrollbar-thumb {
background-color: #6c757d;
}
</style>
<?php if (isset($msg)) { ?>
<div class="row">
<div class="col-sm-12">
<?php echo $msg; ?>
</div>
</div>
<?php } ?>
<div class="row">
<div class="col-md-6">
<div class="panel panel-primary">
<div class="panel-heading clearfix">
<h4 class="panel-title">
Transfer from Master
</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-horizontal" method="post">
<div class="form-group">
<label for="" class="col-sm-4">Master of</label>
<div class="col-sm-8">
<select name="master_type" class="form-control" id="master_type">
<option value="">--Select Master Type--</option>
<option value="sp" <?php if (@$_SESSION['trfQ_MasterType'] == 'sp') echo "selected" ?>>Sarkari Pariksha</option>
<option value="oly" <?php if (@$_SESSION['trfQ_MasterType'] == 'oly') echo "selected" ?>>Olympiad</option>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Transfer From </label>
<div class="col-sm-8">
<select name="master" class="form-control" id="master">
<option value="">--Select Master--</option>
<?php if (isset($_SESSION['trfQ_MasterType']) && @$_SESSION['trfQ_MasterType'] != '') {
$sourceMasterType = strtoupper($_SESSION['trfQ_MasterType']);
$getMasters = $conn->query("SELECT master_id,master_name FROM $SP_MASTER_CATEGORY where source='$sourceMasterType' order by master_name asc");
foreach ($getMasters as $m1) {
?>
<option value="<?php echo $m1['master_id'] ?>" <?php if ($_SESSION['trfQ_MasterID'] == $m1['master_id']) echo "selected"; ?>><?php echo $m1['master_name'] ?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Subject</label>
<div class="col-sm-8">
<select name="subject" class="form-control" id="subject">
<option value="">--Select Subject--</option>
<?php if (isset($_SESSION['trfQ_MasterID']) && @$_SESSION['trfQ_MasterID'] != '') {
$sourceMaster = $_SESSION['trfQ_MasterID'];
$getSubjects = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where master_id='$sourceMaster' and parent_id='0' order by category_name asc");
foreach ($getSubjects as $m2) {
?>
<option value="<?php echo $m2['sub_id'] ?>" <?php if ($_SESSION['trfQ_SubjectID'] == $m2['sub_id']) echo "selected"; ?>><?php echo $m2['category_name'] ?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Topic</label>
<div class="col-sm-8">
<select name="topic" id="topic" class="form-control">
<option value="">--Select Topic--</option>
<?php if (isset($_SESSION['trfQ_SubjectID']) && @$_SESSION['trfQ_SubjectID'] != '') {
$sourceSUbject = $_SESSION['trfQ_SubjectID'];
$getTopics = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where parent_id='$sourceSUbject' order by category_name asc");
foreach ($getTopics as $m3) {
?>
<option value="<?php echo $m3['sub_id'] ?>" <?php if ($_SESSION['trfQ_TopicID'] == $m3['sub_id']) echo "selected"; ?>><?php echo $m3['category_name'] ?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Sub Topic</label>
<div class="col-sm-8">
<select name="sub_topic" id="sub_topic" class="form-control">
<option value="">--Select Sub Topic--</option>
<?php if (isset($_SESSION['trfQ_TopicID']) && @$_SESSION['trfQ_TopicID'] != '') {
$sourceTopic = $_SESSION['trfQ_TopicID'];
$getSubTopics = $conn->query("SELECT sub_id,category_name FROM $SP_MASTER_STRUCTURE where parent_id='$sourceTopic' order by category_name asc");
foreach ($getSubTopics as $m4) {
?>
<option value="<?php echo $m4['sub_id'] ?>" <?php if ($_SESSION['trfQ_SUB_TopicID'] == $m4['sub_id']) echo "selected"; ?>><?php echo $m4['category_name'] ?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Medium</label>
<div class="col-sm-8">
<select name="medium" id="medium" class="form-control">
<option value="">--Select Medium--</option>
<?php foreach ($getMedium as $m) { ?>
<option value="<?php echo $m['medium_id']; ?>" <?php if ($_SESSION['trfQ_SRC_MED'] == $m['medium_id']) echo "selected" ?>><?php echo $m['medium_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Level</label>
<div class="col-sm-8">
<select name="level" id="level" class="form-control">
<option value="L">--Select Level--</option>
<?php foreach ($allLevel as $l) { ?>
<option value="<?php echo $l['level_name']; ?>"><?php echo $l['description']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Difficulty</label>
<div class="col-sm-8">
<select name="difficulty" id="difficulty" class="form-control">
<option value="DF">--Select Difficulty--</option>
<?php foreach ($allDifficulty as $d) { ?>
<option value="<?php echo $d['difficulty']; ?>"><?php echo $d['description']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Previous Exam</label>
<div class="col-sm-8">
<select name="prev_exam" id="prev_exam" class="form-control">
<option value="PE">--Select Previous Exam--</option>
<option value="PYP">All PYP</option>
<?php foreach ($allPreExams as $p) { ?>
<option value="<?php echo $p['exam_name']; ?>"><?php echo $p['exam_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<input class="btn btn-info" type="submit" value="Submit" name="transfer_from" onclick="return validateForm();" />
</form>
</div>
</div>
</div>
<div class="col-md-6">
<div class="panel panel-primary">
<div class="panel-heading clearfix">
<h4 class="panel-title">
Transfer to Master
</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-horizontal" method="post" onsubmit="return validateTrf2();">
<div class="form-group">
<label for="" class="col-sm-4">Master of</label>
<div class="col-sm-8">
<select name="master_type_in" class="form-control" id="master_type_in">
<option value="">--Select Master Type--</option>
<option value="sp">Sarkari Pariksha</option>
<option value="oly">Olympiad</option>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Transfer In </label>
<div class="col-sm-8">
<select name="master_in" class="form-control" id="master_in">
<option value="">--Select Master--</option>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-4">Subject</label>
<div class="col-sm-8">
<select name="subject_in" class="form-control" id="subject_in">
<option value="">--Select Subject--</option>
</select>
</div>
</div>
<input class="btn btn-info" type="submit" value="Submit" name="transfer_in" />
</form>
</div>
</div>
</div>
</div>
<div class="row">
<form method="post">
<div class="col-md-6">
<?php
if (isset($_SESSION['trfQ_MasterID'])) {
$mType = $_SESSION['trfQ_MasterType'];
include 'str_replace_type.php';
if ($_SESSION['trfQ_MasterID'] != '') {
$subquery = "sq.master_id=" . $_SESSION['trfQ_MasterID'];
}
if ($_SESSION['trfQ_SubjectID'] != '') {
$subquery .= " and sq.subject_id=" . $_SESSION['trfQ_SubjectID'];
}
if ($_SESSION['trfQ_TopicID'] != '') {
$subquery .= " and sq.topic_id=" . $_SESSION['trfQ_TopicID'];
}
if ($_SESSION['trfQ_SUB_TopicID'] != '') {
$subquery .= " and sq.sub_topic_id=" . $_SESSION['trfQ_SUB_TopicID'];
}
if ($_SESSION['trfQ_Level'] != 'L') {
if ($_SESSION['trfQ_Level'] == 'L1L2') {
$subquery .= " AND (sq.level_name='L1' OR sq.level_name='L2')";
} else if ($_SESSION['trfQ_Level'] == 'L2L3') {
$subquery .= " AND (sq.level_name='L2' OR sq.level_name='L3')";
} else {
$subquery .= " and sq.level_name='" . $_SESSION['trfQ_Level'] . "'";
}
}
if ($_SESSION['trfQ_Difficulty'] != 'DF') {
$subquery .= " and sq.difficulty='" . $_SESSION['trfQ_Difficulty'] . "'";
}
if ($_SESSION['trfQ_PRE_EXAM'] != 'PE') {
if ($_SESSION['trfQ_PRE_EXAM'] == 'PYP') {
$subquery .= " and sq.previous_exam_name!=''";
} else {
$subquery .= " and sq.previous_exam_name='" . $_SESSION['trfQ_PRE_EXAM'] . "'";
}
}
if ($_SESSION['trfQ_SRC_MED'] != '') {
$subquery .= " and sq.medium_id='" . $_SESSION['trfQ_SRC_MED'] . "'";
}
$limit = 100;
$pageNo = isset($_GET['pageN']) ? $_GET['pageN'] : 1;
$indexN = ($pageNo - 1) * $limit;
$countQuery = $conn->query("SELECT count(sq.question_id) as total FROM $SP_QUESTION as sq where $subquery order by sq.question_id");
$cQuery = $countQuery->fetch_assoc();
$count = $cQuery['total'];
$noOfPages = ceil($count / $limit);
$queryQues = $conn->query("SELECT sq.question_id, sq.medium_id, sq.no_of_option, sq.question_instruction, sq.question_statement, sq.option_1, sq.option_2, sq.option_3, sq.option_4, sq.option_5, sq.correct_answer, sq.previous_exam_year, sq.previous_exam_name, sq.exam_shift,qd.description,sq.level_name FROM $SP_QUESTION as sq left join $SP_EDITORS as u on u.editor_id=sq.add_by left join $SP_EDITORS as pf on pf.editor_id=sq.last_proofread_by left join $SP_MEDIUM as md on md.medium_id=sq.medium_id left join $SP_QUESTION_DIFFICULTY as qd on qd.difficulty=sq.difficulty where $subquery order by sq.question_id limit $indexN, $limit");
?>
<div class="panel panel-info" style="background-color: #f1f4f9;">
<div class="panel-heading clearfix">
<div class="row">
<div class="col-md-9"> Total Questions - [<?php echo $count; ?>] </div>
<div class="col-md-3"> <input type="checkbox" id="checkAll" value="0">Select All </div>
</div>
</div>
<div class="spacer"></div>
<div id="questionData">
<?php
$i = 1;
foreach ($queryQues as $q) {
$question_id = $q['question_id'];
$instruction = str_replace('../', $root_link, $q['question_instruction']);
$instruction = str_replace($spaceArray, $replaceSpaceArray, $instruction);
$question = str_replace('../', $root_link, $q['question_statement']);
$question = str_replace($spaceArray, $replaceSpaceArray, $question);
$option1 = str_replace('../', $root_link, $q['option_1']);
$option1 = str_replace($spaceArray, $replaceSpaceArray, $option1);
$option2 = str_replace('../', $root_link, $q['option_2']);
$option2 = str_replace($spaceArray, $replaceSpaceArray, $option2);
if ($q['option_3']) {
$option3 = str_replace('../', $root_link, $q['option_3']);
$option3 = str_replace($spaceArray, $replaceSpaceArray, $option3);
} else {
$option3 = "";
}
if ($q['option_4']) {
$option4 = str_replace('../', $root_link, $q['option_4']);
$option4 = str_replace($spaceArray, $replaceSpaceArray, $option4);
} else {
$option4 = "";
}
if ($q['option_5']) {
$option5 = str_replace('../', $root_link, $q['option_5']);
$option5 = str_replace($spaceArray, $replaceSpaceArray, $option5);
} else {
$option5 = "";
}
$correct_answer = $q['correct_answer'];
$preExmDet = $q['previous_exam_name'] . "/" . $q['previous_exam_year'] . "/" . $q['exam_shift'];
$ques_difficulty = $q['description'];
$level = $q['level_name'];
$getEntity = $conn->query("select m.master_name, s.category_name as subject, t.category_name as topic, st.category_name as subtopic from $SP_QUESTION as q LEFT JOIN $SP_MASTER_CATEGORY as m ON m.master_id=q.master_id LEFT JOIN $SP_MASTER_STRUCTURE as s ON s.sub_id=q.subject_id LEFT JOIN $SP_MASTER_STRUCTURE as t ON t.sub_id=q.topic_id LEFT JOIN $SP_MASTER_STRUCTURE as st ON st.sub_id=q.sub_topic_id where q.question_id='$question_id'");
$entData = $getEntity->fetch_assoc();
$dispEnt = $entData['master_name'] . ">>" . $entData['subject'] . ">>" . $entData['topic'] . ">>" . $entData['subtopic'];
?>
<div class="well" style="box-shadow: 0px 0px 12px 0px #7c7c7c42;" id="queshtml_<?php echo $question_id; ?>">
<h4>
<?php echo $dispEnt; ?>
</h4>
<?php
if ($instruction != '') { ?>
<h4>Question Instructions</h4>
<?php
echo $instruction;
} ?>
<div class="row">
<div class="col-md-12 ques-maindiv">
<input class="checkAll1" style="height:22px; width:22px; border:1px solid #FF0000;" type="checkbox" name="ques_id[]" value="<?php echo $question_id; ?>">
<?php echo $i + $indexN . " / <font style='color:#00F;'>" . $question_id . "</font>"; ?>
</div>
</div>
<div class="row">
<div class="col-md-12">
<?php echo $question; ?>
</div>
</div>
<br>
<div class="row">
<div class="col-md-12">
<?php if (isset($option1)) { ?>
<div class="row">
<div class="col-md-1">1</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="1" <?php echo $correct_answer == 1 ? 'checked' : ''; ?> style="width:15px!important;" /></div>
<div class="col-md-9">
<?php if (isset($option1)) {
echo $option1;
} ?>
</div>
</div>
<?php } ?>
<?php if (isset($option2)) { ?>
<div class="row">
<div class="col-md-1">2</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="2" <?php echo $correct_answer == 2 ? 'checked' : ''; ?> style="width:15px!important;" /></div>
<div class="col-md-9">
<?php if (isset($option2)) {
echo $option2;
} ?>
</div>
</div>
<?php } ?>
<?php if ($option3 != '') { ?>
<div class="row">
<div class="col-md-1">3</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="3" <?php echo $correct_answer == 3 ? 'checked' : ''; ?> style="width:15px!important;" /></div>
<div class="col-md-9">
<?php if (isset($option3)) {
echo $option3;
} ?>
</div>
</div>
<?php } ?>
<?php if ($option4 != '') { ?>
<div class="row">
<div class="col-md-1">4</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="4" <?php echo $correct_answer == 4 ? 'checked' : ''; ?> style="width:15px!important;" /></div>
<div class="col-md-9">
<?php if (isset($option4)) {
echo $option4;
} ?>
</div>
</div>
<?php } ?>
<?php if ($option5 != '') { ?>
<div class="row">
<div class="col-md-1">5</div>
<div class="col-md-1"><input class="radio_ans" type="radio" value="5" <?php echo $correct_answer == 5 ? 'checked' : ''; ?> style="width:15px!important;" /></div>
<div class="col-md-9">
<?php if (isset($option5)) {
echo $option5;
} ?>
</div>
</div>
<?php } ?>
<div class="row">
<div class="col-md-12">
<?php if ($q['previous_exam_name'] != '') { ?>
<div style="width:100%;">
<span style="font-weight:bold;">
<font style="color:green;">Previous Exam :</font> <?php echo $preExmDet; ?>
</span>
</div>
<?php } ?>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div style="width:100%;">
<span style="font-weight:bold;">
<font style="color:green;">Question Level :</font> <?php echo $level; ?>
</span>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div style="width:100%;">
<span style="font-weight:bold;">
<font style="color:green;">Question Difficulty :</font> <?php echo $ques_difficulty; ?>
</span>
</div>
</div>
</div>
</div>
</div>
</div>
<?php $i++;
} ?>
</div>
</div>
<?php } ?>
</div>
<?php
if (isset($_SESSION['subject_in'])) {
$from_in_id = $_SESSION['subject_in'];
$from_master = $_SESSION['master_in'];
$getName = $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_in_id'");
$cscName = $getName->fetch_assoc();
?>
<div class="col-md-6">
<div class="panel panel-primary">
<div class="spacer"></div>
<div class="panel panel-primary" id="fixdiv">
<div class="panel-heading clearfix">
<div class="row">
<div class="col-md-9"> Transfer In - <?php echo $cscName['master_name'] . ' - ' . $cscName['category_name']; ?></div>
<div class="col-md-3" style="text-align: end;"><button type="button" class="btn btn-success" name="tranfer_ques" onclick="transferMultiple()">Transfer</button></div>
</div>
</div>
<div class="spacer"></div>
<div class="panel-body overflow-auto" style="height: 550px; background: white; overflow: auto !important;">
<?php
$path = 'nqb_master_transfer_treeview.php'; //new_question_bank_structure.php
include_once($path);
?>
</div>
</div>
</div>
</div>
</form>
<?php if (isset($_SESSION['trfQ_MasterID'])) { ?>
<div class="col-md-12">
<?php echo pagination($limit, $pageNo, $pagination_link . "?pageN=", $count); ?>
</div>
<?php } ?>
<?php } ?>
</div>
</div><!-- Main Wrapper -->
<script>
localStorage.removeItem("setQuesArray");
var myQuestions = [];
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery('#master_type').on('change', function() {
var mid = jQuery("#master_type").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + mid + "&type=masterof";
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#master").html(data);
});
});
jQuery('#master_type_in').on('change', function() {
var mid = jQuery("#master_type_in").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + mid + "&type=masterof";
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#master_in").html(data);
});
});
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);
});
});
jQuery('#master_in').on('change', function() {
var mid = jQuery("#master_in").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + mid + "&type=master";
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#subject_in").html(data);
});
});
jQuery('#subject').on('change', function() {
var subId = jQuery("#subject").val();
var mid = jQuery("#master").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + subId + "&type=topic&m=" + mid;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#topic").html(data);
});
});
jQuery('#topic').on('change', function() {
var subId = jQuery("#topic").val();
var mid = jQuery("#master").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + subId + "&type=subtopic&m=" + mid;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sub_topic").html(data);
});
});
// jQuery("#checkAll").change(function() {
// var check = this.value;
// if (check == 0) {
// jQuery(".checkAll1").prop('checked', jQuery(this).prop('checked'));
// jQuery(".checker").find('span').addClass('checked');
// jQuery("#checkAll").val(1);
// } else if (check == 1) {
// jQuery(".checkAll1").prop('checked', jQuery(this).prop('checked'));
// jQuery(".checker").find('span').removeClass('checked');
// jQuery("#checkAll").val(0);
// }
// });
var formStorage = localStorage.getItem("formdata");
if (formStorage != '' && formStorage != undefined) {
jQuery("#spantext").html(formStorage);
}
jQuery(document).on('click', '#checkAll', function() {
var check = this.value;
if (check == 0) {
jQuery(".checkAll1").prop('checked', jQuery(this).prop('checked'));
jQuery(".checker").find('span').addClass('checked');
jQuery("#checkAll").val(1);
var searchIDs = $(".ques-maindiv input:checkbox:checked").map(function() {
if (jQuery.inArray($(this).val(), myQuestions) == -1) {
jQuery("#queshtml_" + $(this).val()).addClass("will-remove");
myQuestions.push($(this).val())
return $(this).val();
}
}).get(); // <----
// console.log(searchIDs);
var makeArray = JSON.stringify(myQuestions);
localStorage.setItem("setQuesArray", makeArray);
// jQuery("html, body").animate({
// scrollTop: $("#transferAll").offset().top
// }, 1000);
} else if (check == 1) {
jQuery(".panel-info").find(".will-remove").removeClass("will-remove");
jQuery(".checkAll1").prop('checked', jQuery(this).prop('checked'));
jQuery(".checker").find('span').removeClass('checked');
jQuery("#checkAll").val(0);
myQuestions.length = 0;
}
});
/***single check click function */
jQuery(document).on('click', '.checkAll1', function() {
if (jQuery.inArray(this.value, myQuestions) == -1) {
jQuery("#queshtml_" + this.value).addClass("will-remove");
myQuestions.push(this.value);
var selString = JSON.stringify(myQuestions);
localStorage.setItem("setQuesArray", selString);
} else {
jQuery("#queshtml_" + this.value).removeClass("will-remove");
myQuestions.indexOf(this.value) !== -1 && myQuestions.splice(myQuestions.indexOf(this.value), 1)
var selString = JSON.stringify(myQuestions);
localStorage.setItem("setQuesArray", selString);
}
});
function isEmpty(el) {
return !jQuery.trim(el.html())
}
jQuery(window).bind('scroll', function() {
console.log(jQuery("#questionData").html());
if (isEmpty(jQuery('#questionData'))) {
// do something
} else {
var navHeight = jQuery(window).height() - 90;
if (jQuery(window).scrollTop() > navHeight) {
jQuery('#fixdiv').addClass('fixed-div');
} else {
jQuery('#fixdiv').removeClass('fixed-div');
}
}
});
});
/****transfer multiple question array */
function transferMultiple() {
var questionArray = localStorage.getItem("setQuesArray");
var in_sub_id = jQuery("input[name='in_sub_id']:checked").val();
var master_in = '<?php echo @$_SESSION['master_in']; ?>';
var subject_in = '<?php echo @$_SESSION['subject_in']; ?>';
var master_type_in = '<?php echo @$_SESSION['master_type_in']; ?>';
if (questionArray == '[]' || questionArray == null || questionArray == undefined || questionArray.length == 0 || questionArray.length == undefined) {
alert("Please select checkboxes");
} else {
var r = confirm("Are you sure to transfer these Questions ?");
if (r == true) {
var arr = {
typ: "add-all",
quesIds: questionArray,
tId: in_sub_id,
sId: subject_in,
mId: master_in,
mType: master_type_in
}
var site = 'ajax_call/nqb_m_to_m_trf.php';
jQuery.ajax({
url: site,
type: 'POST',
data: JSON.stringify(arr),
contentType: 'application/json; charset=utf-8',
dataType: 'json',
success: function(data) {
var status = data.status;
jQuery("#tpId_" + in_sub_id).html(data.questions);
if (status == 1) {
localStorage.removeItem("setQuesArray");
myQuestions.length = 0;
jQuery(".panel-info").find(".will-remove").remove();
} else {
alert(data.message);
}
// window.location.href = "/new-wht-dash/lt-set-question";
}
});
} else {
}
}
}
</script>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<?php
} else {
echo "<script>alert('You dont have access for entity change');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>