File: /var/www/content-sp/work-sp/nqb_master_to_master_copy.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)) {
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
// $pagination_link = $_SERVER['REQUEST_URI'];
$paguri = explode("?pageN",$_SERVER['REQUEST_URI']);
$pagination_link = $paguri[0];
$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_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$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';
$curDate = date('Y-m-d H:i:s');
/**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['copy_master_in'] = $master_in;
$_SESSION['copy_subject_in'] = $subject_in;
$_SESSION['copy_master_type_in'] = $master_type_in;
}
/***transfer ques */
if (isset($_REQUEST['tranfer_ques'])) {
if (isset($_SESSION['copy_subject_in'])) {
$in_sub_id = $_REQUEST['in_sub_id'];
$trf_master = $_SESSION['copy_master_in'];
$trf_subject = $_SESSION['copy_subject_in'];
$ques_id = $_REQUEST['ques_id'];
$question_of = $_SESSION['copy_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>';
if ($trf_master != '' && $trf_master != '0' && $trf_subject != '' && $trf_subject != '0' && $q_a != '' && $q_a != '0' && $tpcId != '' && $tpcId != '0') {
$flag = '1';
$insertPrimaryQ = "INSERT INTO $SP_QUESTION (`oly_id`, `old_question_id`, `master_id`, `subject_id`, `topic_id`, `sub_topic_id`, `sys_id`, `level_name`, `difficulty`, `medium_id`, `question_group`, `no_of_option`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `correct_answer`, `question_hint`, `question_solution`, `active_solution`, `previous_exam_name`, `previous_exam_year`, `exam_shift`, `question_expiry`, `source_id`, `add_by`, `add_date`, `last_update_on`, `last_update_by`, `last_proofread_by`, `last_proofread_date`, `status`, `question_type`, `question_of`, `question_flag`, `exam_bound`, `e_id`, `e_sub_id`, `e_top_id`) SELECT `oly_id`, `old_question_id`, $trf_master, $subjId, $tpcId, $subTpc, `sys_id`, `level_name`, `difficulty`, `medium_id`, `question_group`, `no_of_option`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `correct_answer`, `question_hint`, `question_solution`, `active_solution`, `previous_exam_name`, `previous_exam_year`, `exam_shift`, `question_expiry`, $q_a, `add_by`, '$curDate', '$curDate', $editor_id, `last_proofread_by`, `last_proofread_date`, `status`, `question_type`, '$quesOfjson', '$flag', `exam_bound`, `e_id`, `e_sub_id`, `e_top_id` FROM $SP_QUESTION WHERE question_id='$q_a'";
$conn->query($insertPrimaryQ);
echo $conn->error;
$quesId = $conn->insert_id;
// echo "<br>";
if ($quesId != '' && $quesId != 0) {
$insertSecQ = "INSERT INTO $SP_QUESTION_MEDIUM_WISE (`question_id`, `oly_id`, `medium_id`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `question_hint`, `question_solution`, `active_solution`, `source_id`, `add_by`, `add_date`, `last_update_on`, `last_update_by`, `last_proofread_date`, `last_proofread_by`, `status`) SELECT $quesId, `oly_id`, `medium_id`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `question_hint`, `question_solution`, `active_solution`, `source_id`, `add_by`, '$curDate', '$curDate', $editor_id, `last_proofread_date`, `last_proofread_by`, `status` FROM $SP_QUESTION_MEDIUM_WISE WHERE question_id='$q_a'";
$conn->query($insertSecQ);
// echo "<br>";
}
// echo $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['copyQ_MasterType'] = $master_type;
$_SESSION['copyQ_MasterID'] = $master_id;
$_SESSION['copyQ_SubjectID'] = $subject_id;
$_SESSION['copyQ_TopicID'] = $topic_id;
$_SESSION['copyQ_SUB_TopicID'] = $sub_topic_id;
$_SESSION['copyQ_SRC_MED'] = $source_medium;
$_SESSION['copyQ_Level'] = $level;
$_SESSION['copyQ_Difficulty'] = $difficulty;
$_SESSION['copyQ_PRE_EXAM'] = $prev_exam;
echo "<script>
if (window.history.replaceState) {
window.history.replaceState(null, null, window.location.pathname);
location.reload();
}
</script>";
}
?>
<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;
}
</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">
Copy 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">Sarkari Pariksha</option>
<option value="oly">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>
</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>
</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>
</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>
</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 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>
<?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">
Copy 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">Copy 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['copyQ_MasterID'])) {
$mType = $_SESSION['copyQ_MasterType'];
include 'str_replace_type.php';
if ($_SESSION['copyQ_MasterID'] != '') {
$subquery = "sq.master_id=" . $_SESSION['copyQ_MasterID'];
}
if ($_SESSION['copyQ_SubjectID'] != '') {
$subquery .= " and sq.subject_id=" . $_SESSION['copyQ_SubjectID'];
}
if ($_SESSION['copyQ_TopicID'] != '') {
$subquery .= " and sq.topic_id=" . $_SESSION['copyQ_TopicID'];
}
if ($_SESSION['copyQ_SUB_TopicID'] != '') {
$subquery .= " and sq.sub_topic_id=" . $_SESSION['copyQ_SUB_TopicID'];
}
if ($_SESSION['copyQ_Level'] != 'L') {
if ($_SESSION['copyQ_Level'] == 'L1L2') {
$subquery .= " AND (sq.level_name='L1' OR sq.level_name='L2')";
} else if ($_SESSION['copyQ_Level'] == 'L2L3') {
$subquery .= " AND (sq.level_name='L2' OR sq.level_name='L3')";
} else {
$subquery .= " and sq.level_name='" . $_SESSION['copyQ_Level'] . "'";
}
}
if ($_SESSION['copyQ_Difficulty'] != 'DF') {
$subquery .= " and sq.difficulty='" . $_SESSION['copyQ_Difficulty'] . "'";
}
if ($_SESSION['copyQ_PRE_EXAM'] != 'PE') {
$subquery .= " and sq.previous_exam_name='" . $_SESSION['copyQ_PRE_EXAM'] . "'";
}
if ($_SESSION['copyQ_SRC_MED'] != '') {
$subquery .= " and sq.medium_id='" . $_SESSION['copyQ_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">
<div class="panel-heading clearfix">Total Questions - [<?php echo $count; ?>]</div>
<div class="spacer"></div>
<input type="checkbox" id="checkAll" value="0">Select All
<?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 6px 11px 8px #ddd;">
<h4>
<?php echo $dispEnt; ?>
</h4>
<?php
if ($instruction != '') { ?>
<h4>Question Instructions</h4>
<?php
echo $instruction;
} ?>
<div class="row">
<div class="col-md-12">
<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>
<?php } ?>
</div>
<?php
if (isset($_SESSION['copy_subject_in'])) {
$from_in_id = $_SESSION['copy_subject_in'];
$from_master = $_SESSION['copy_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">
<div class="panel-heading clearfix">Copy In - <?php echo $cscName['master_name'] . ' - ' . $cscName['category_name']; ?></div>
<div class="spacer"></div>
<div class="panel-body">
<div class="well" style="box-shadow: 0px 6px 11px 8px #ddd;">
<?php
$path = 'nqb_master_transfer_treeview.php'; //new_question_bank_structure.php
include_once($path);
?>
</div>
<!---well---->
</div>
</div>
</div>
</div>
<button type="submit" class="btn btn-success" name="tranfer_ques">Copy</button>
</form>
<?php if (isset($_SESSION['copyQ_MasterID'])) { ?>
<div class="col-md-12">
<?php
echo pagination($limit, $pageNo, $pagination_link . "?pageN=", $count); ?>
</div>
<?php } ?>
<?php } ?>
</div>
</div><!-- Main Wrapper -->
<script>
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);
}
//jQuery(".checkAll1").prop('!checked', jQuery(this).prop('!checked'));
//jQuery(".checker").find('span').removeClass('checked');
});
var formStorage = localStorage.getItem("formdata");
if (formStorage != '' && formStorage != undefined) {
jQuery("#spantext").html(formStorage);
}
});
</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');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>