File: /var/www/content-sp/work-sp/nqb_question_edit_secondary.php
<?php
include_once('header.php');
//check edit permissions
$fileName = 'nqb_question_edit';
if (in_array($fileName, $pageArray)) {
echo "Yes";
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$allMedium = $conn->query("SELECT medium_id,medium_name from $SP_MEDIUM");
$quesId = $_REQUEST['quesId'];
$mType = $_REQUEST['mType'];
include 'str_replace_type.php';
?>
<meta http-equiv="Content-Language" content="hi">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src='/tinymce_8/js/tinymce/tinymce.min.js'></script>
<script type="text/javascript">
tinymce.init({
selector: "textarea",
license_key: 'gpl',
theme: 'silver',
plugins: "save ,tiny_mce_wiris, pagebreak, image, lists, table, fullscreen, link, anchor, charmap, code",
toolbar: "save newdocument | bold italic underline strikethrough | alignleft aligncenter alignright alignjustify | blocks | fontfamily | fontsize | cut copy paste | bullist numlist | | outdent indent blockquote | undo redo | link unlink anchor | forecolor backcolor | table | hr removeformat | superscript subscript pagebreak | tiny_mce_wiris_formulaEditor tiny_mce_wiris_formulaEditorChemistry charmap image | fullscreen code help | customInsertButton",
invalid_styles: {
'*': 'color background background-color font-family font-size'
},
//paste_as_text: false,
paste_data_images: true,
automatic_uploads: true,
toolbar_mode: 'wrap',
extended_valid_elements: '*[.*]',
convert_urls: false,
images_upload_url: 'nqb_upload_image_new.php?folder=<?php echo $mType; ?>', //php file upload path
images_upload_credentials: true,
});
jQuery.noConflict();
jQuery(document).ready(function() {
siteUrl = jQuery("#site_url").val();
// *******************************
jQuery('#btn_back').on('click', function() {
close();
});
});
function validateForm() {
if (jQuery('#exist_medium').val() == jQuery('#medium').val()) {
alert("Please Select different medium");
return false;
}
if (jQuery("input[name='ques_of']:checked").length == 0) {
alert("Select Question Repository");
return false;
}
}
</script>
<style>
.modal-backdrop {
z-index: 999 !important;
}
.form-group {
margin-bottom: 10px;
margin-top: 10px;
}
label {
font-size: 16px;
}
.form-control {
font-weight: bold;
}
.radio_ans {
top: -5px;
left: 10px;
height: 25px !important;
width: 25px !important;
background-color: #eee;
border-radius: 50%;
position: relative !important;
opacity: 1 !important;
}
.panel-body #frmaddQues div.form-group div.tox.tox-tinymce {
height: 396px !important;
}
.panel-body #frmaddQues div.form-group div.tox.tox-tinymce.tox-fullscreen {
height: 100% !important;
}
</style>
<?php
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
if (isset($_REQUEST['btn_update'])) {
$question_id_org = $_REQUEST['question_id_org'];
$instructionQ = isset($_POST['instruction']) ? (mysqli_real_escape_string($conn, $_REQUEST['instruction'])) : "";
$questionQ = isset($_POST['question']) ? (mysqli_real_escape_string($conn, $_POST['question'])) : "";
$correctAnswer = $_POST['radio_ans'];
$orginal_answer = $_POST['orginal_answer'];
$ans1Q = isset($_POST['ans_1']) ? (mysqli_real_escape_string($conn, $_POST['ans_1'])) : "";
$ans2Q = isset($_POST['ans_2']) ? (mysqli_real_escape_string($conn, $_POST['ans_2'])) : "";
$ans3Q = isset($_POST['ans_3']) ? (mysqli_real_escape_string($conn, $_POST['ans_3'])) : "";
$ans4Q = isset($_POST['ans_4']) ? (mysqli_real_escape_string($conn, $_POST['ans_4'])) : "";
$ans5Q = isset($_POST['ans_5']) ? (mysqli_real_escape_string($conn, $_POST['ans_5'])) : "";
$question_solution = $_REQUEST['solution'];
$question_solutionQ = isset($_POST['solution']) ? (mysqli_real_escape_string($conn, $_POST['solution'])) : "";
$medium = $_REQUEST['medium'];
$active_solution = $_REQUEST['active_solution'];
$status = $_REQUEST['ques_state'];
$ques_of = explode(',', $_REQUEST['ques_of']);
$quesOfjson = json_encode($ques_of, JSON_UNESCAPED_UNICODE);
if ($status == '3' || $status == '4') {
$prfQuery = ",last_proofread_by='$adminId',last_proofread_date='$curDate'";
} else {
$prfQuery = '';
}
if ($correctAnswer != '') {
if ($orginal_answer != $correctAnswer) {
$conn->query("UPDATE $SP_QUESTION set correct_answer='$correctAnswer' where question_id='$question_id_org'");
$message = "<br>Warning : Correct answer updated";
}
$updateQuery = "UPDATE $SP_QUESTION_MEDIUM_WISE set medium_id='$medium', question_instruction='$instructionQ', question_statement='$questionQ', option_1='$ans1Q', option_2='$ans2Q', option_3='$ans3Q', option_4='$ans4Q', option_5='$ans5Q', question_solution='$question_solutionQ', active_solution='$active_solution',status='$status',last_update_by='$adminId' $prfQuery where id='$quesId'";
if ($conn->query($updateQuery)) {
$message = 'Question Updated successfully';
$insert3Status = $conn->query("INSERT into $SP_QUES_HISTORY set medium_id='$medium', question_id='$question_id_org', ref_id='$quesId', action='$status', action_by='$adminId', action_date='$curDate'");
$updateQuesof = $conn->query("UPDATE $SP_QUESTION set question_of='$quesOfjson' where question_id='$question_id_org'");
/***update in live server */
if ($status == '1' || $status == '2' || $status == '3' || $status == '4') {
include_once '../cron/functions_for_sync.php';
replace_single_question_secondary($question_id_org, $quesId, 1);
}
} else {
$message = 'Error ' . $conn->error;
}
} else {
$message = "Error : Please select correct answer radio button";
}
}
/**form data */
$getQuestion = $conn->query("SELECT qm.id,qm.question_id,qm.medium_id,qm.question_instruction,qm.question_statement,qm.option_1,qm.option_2,qm.option_3,qm.option_4,qm.option_5,qm.question_solution,qm.status,q.correct_answer,q.medium_id as exist,qm.active_solution,q.question_of from $SP_QUESTION_MEDIUM_WISE as qm left join $SP_QUESTION as q on q.question_id=qm.question_id where id='$quesId'");
$secQues = $getQuestion->fetch_assoc();
$correct_answer = $secQues['correct_answer'];
$exist_medium = $secQues['exist'];
$qStatus = $secQues['status'];
$ref_id = $secQues['id'];
$qmMedium = $secQues['medium_id'];
/***question of which server */
$ft_ques_of = json_decode($secQues['question_of']);
?>
<div class="page-inner">
<div class="page-title">
<h3>Translate Question</h3>
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="dashboard">Home</a></li>
<li class="active">Translate Question</li>
</ol>
</div>
</div>
<div id="main-wrapper">
<div class="row">
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Translate Question</h4>
<a style="float: right;color: #000;background: #fff;padding: 6px 10px 6px 8px;
border-radius: 6px;
text-decoration: none;" href="nqb_upload_image?mType=<?php echo $mType; ?>" target="_blank">Upload Image</a>
</div>
<label class="error" style="display: block;">
<?php if (isset($message)) {
echo $message;
} ?>
</label>
<div class="panel-body">
<form id="frmaddQues" method="post" action="" onSubmit="return validateForm();">
<input type="hidden" name="question_id_org" value="<?php echo $secQues['question_id']; ?>">
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Instructions</label>
<div class="col-sm-9">
<textarea name="instruction" id="instruction">
<?php
$question_instruction = str_replace('../', $root_link, $secQues['question_instruction']);
$question_instruction = str_replace($spaceArray, $replaceSpaceArray, $question_instruction);
echo $question_instruction;
?>
</textarea>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Statement</label>
<div class="col-sm-9">
<textarea name="question" id="question">
<?php
$question_statement = str_replace('../', $root_link, $secQues['question_statement']);
$question_statement = str_replace($spaceArray, $replaceSpaceArray, $question_statement);
echo htmlspecialchars($question_statement);
?>
</textarea>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Options & Answer</label>
<input type="hidden" name="orginal_answer" value="<?php echo $correct_answer; ?>" />
<table border="1" style="text-align: center;vertical-align: top">
<tr>
<td style="text-align: center;">Sl. No</td>
<td style="text-align: center;">Correct Answer</td>
<td style="text-align: center;">Answer</td>
</tr>
<tr>
<td>1</td>
<td>
<input type="radio" value="1" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 1 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_1" id="ans_1">
<?php
$option_1 = str_replace('../', $root_link, $secQues['option_1']);
$option_1 = str_replace($spaceArray, $replaceSpaceArray, $option_1);
echo htmlspecialchars($option_1);
?>
</textarea>
</td>
</tr>
<tr>
<td>2</td>
<td>
<input type="radio" value="2" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 2 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_2" id="ans_2">
<?php
$option_2 = str_replace('../', $root_link, $secQues['option_2']);
$option_2 = str_replace($spaceArray, $replaceSpaceArray, $option_2);
echo htmlspecialchars($option_2);
?>
</textarea>
</td>
</tr>
<tr>
<td>3</td>
<td>
<input type="radio" value="3" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 3 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_3" id="ans_3">
<?php
$option_3 = str_replace('../', $root_link, $secQues['option_3']);
$option_3 = str_replace($spaceArray, $replaceSpaceArray, $option_3);
echo htmlspecialchars($option_3);
?>
</textarea>
</td>
</tr>
<tr>
<td>4</td>
<td>
<input type="radio" value="4" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 4 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_4" id="ans_4">
<?php
$option_4 = str_replace('../', $root_link, $secQues['option_4']);
$option_4 = str_replace($spaceArray, $replaceSpaceArray, $option_4);
echo htmlspecialchars($option_4);
?>
</textarea>
</td>
</tr>
<tr>
<td>5</td>
<td>
<input type="radio" value="5" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 5 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_5" id="ans_5">
<?php
$option_5 = str_replace('../', $root_link, $secQues['option_5']);
$option_5 = str_replace($spaceArray, $replaceSpaceArray, $option_5);
echo htmlspecialchars($option_5);
?>
</textarea>
</td>
</tr>
</table>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Solution</label>
<div class="col-sm-9">
<textarea name="solution" id="solution">
<?php
$question_solution = str_replace('../', $root_link, $secQues['question_solution']);
$question_solution = str_replace($spaceArray, $replaceSpaceArray, $question_solution);
echo htmlspecialchars($question_solution);
?>
</textarea>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Active Solution</label>
<div class="col-sm-9">
<select class="form-control" name="active_solution">
<option value="N" <?php if ($secQues['active_solution'] == 'N') {
echo "selected";
} ?>>No
</option>
<option value="Y" <?php if ($secQues['active_solution'] == 'Y') {
echo "selected";
} ?>>Yes
</option>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Medium</label>
<div class="col-sm-9">
<input type="hidden" value="<?php echo $exist_medium; ?>" id="exist_medium">
<select id="medium" name="medium" class="form-control m-b-sm">
<?php foreach ($allMedium as $md) { ?>
<option value="<?php echo $md['medium_id'] ?>" <?php if ($secQues['medium_id'] == $md['medium_id']) {
echo 'selected="true"';
} ?>>
<?php echo $md['medium_name'] ?>
</option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Status:</label>
<div class="col-sm-9">
<select name="ques_state" id="ques_state" class="form-control">
<option value="0" <?php echo $secQues['status'] == '0' ? 'selected' : '' ?>>Expire</option>
<option value="1" <?php echo $secQues['status'] == '1' ? 'selected' : '' ?>>Draft</option>
<option value="2" <?php echo $secQues['status'] == '2' ? 'selected' : '' ?>>Add</option>
<option value="3" <?php echo $secQues['status'] == '3' ? 'selected' : '' ?>>Proof Read</option>
<option value="4" <?php echo $secQues['status'] == '4' ? 'selected' : '' ?>>ProofRead & Active</option>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Repository<span class="badge badge-danger">(required*)</span></label>
<div class="col-sm-3">
<input type="radio" name="ques_of" value="sarkari-pariksha" class="form-control" <?php if (is_array($ft_ques_of)) {
if ((sizeof($ft_ques_of) == '1') && (in_array('sarkari-pariksha', $ft_ques_of))) echo 'checked';
} ?> />
<label class="control-label" for="exampleInputName">Sarkari Pariksha</label>
</div>
<?php if ($editor_role != '5') { ?>
<div class="col-sm-3">
<input type="radio" name="ques_of" value="csc-olympiad" class="form-control" <?php if (is_array($ft_ques_of)) {
if ((sizeof($ft_ques_of) == '1') && (in_array('csc-olympiad', $ft_ques_of))) echo 'checked';
} ?> />
<label class="control-label" for="exampleInputName">CSC Olympiad</label>
</div>
<div class="col-sm-3">
<input type="radio" name="ques_of" value="sarkari-pariksha,csc-olympiad" class="form-control" <?php if (is_array($ft_ques_of)) {
if ((sizeof($ft_ques_of) == '2')) echo 'checked';
} ?> />
<label class="control-label" for="exampleInputName">Both Repository</label>
</div>
<?php } ?>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label"> </label>
<div class="col-sm-9">
<button type="submit" class="btn btn-primary" name="btn_update">Update</button>
<input type="button" class="btn btn-info" id="btn_back" name="btn_back" value="No change << go back to list" />
</div>
</div>
</form>
</div>
</div>
<!--panel info-->
</div>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div>
</div>
</div>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access to edit question');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>