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/new_nqb_proofread_access.php
<?php
include_once('nqb_proofread_section.php');
// error_reporting(0);
// error_reporting(E_ALL);
// ini_set('display_errors', 'On');
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
//check edit permissions
$fileName = 'nqb_proofread_access';
if (in_array($fileName, $pageArray)) {

$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_PROOF_READ_ACCESS = 'csp_proofread_access';
$SP_TEAM_ACCESS = 'csp_team_user_access';

$getAssignee = $conn->query("SELECT editor_id, contact_name from $SP_EDITORS where team_id='3' and editor_status='1'");

$allMasterCategory = $conn->query("SELECT master_id, master_name from $SP_MASTER_CATEGORY where source='SP' order by master_name");

$allMedium = $conn->query("SELECT medium_id, medium_name from $SP_MEDIUM order by medium_id");
?>

<style>
    .m-0 {
        margin: 0;
    }

    .proofread-section .form-box {
        background: #fff;
        padding: 20px;
        border: 1px solid #cccccc;
    }

    .proofread-section .form-box form .select-master {
        width: 10%;
    }

    .proofread-section .form-box form label {
        margin: 0;
        font-size: 13px;
        font-weight: 700;
        color: #000;
        margin-right: 6px;
    }

    .proofread-section .form-box form select {
        width: 58%;
        padding: 8px;
        border: 1px solid #cccccc;
        font-weight: 600;
        font-size: 14px;
        color: #000;
        margin-bottom: 20px;
    }

    .proofread-section .form-box form .first-row .form-box-div label {
        width: 70%;
        margin: 0;
        margin-bottom: 10px;
        font-size: 13px;
    }

    .proofread-section .form-box form .form-box-div input {
        margin: 0;
    }

    .proofread-section .form-box form h4 {
        margin: 0;
        font-size: 14px;
        color: #0c0c0c;
        padding-bottom: 8px;
    }

    .proofread-section .form-box form p {
        margin: 0;
        font-size: 13px;
        font-weight: 600;
        padding-bottom: 6px;
    }

    .proofread-section .form-box form p span {
        color: #ee3137;
    }

    .proofread-section .form-box form .sub-topics-div label {
        width: 100%;
        padding-bottom: 10px;
        font-size: 13px;
    }

    .proofread-section .form-box form .sub-topics-div input {
        width: 100%;
        padding: 6px;
        border: 1px solid #cccccc;
        font-weight: 600;
        font-size: 14px;
        color: #000;
    }

    .proofread-section .form-box form .sub-topics-div select {
        margin: 0;
        width: 100%;
        padding: 6px;
        float: left;
    }
    .proofread-section .form-box form .sub-topics-div select span{
        width: 100% !important;
    }

    .proofread-section .form-box form .sub-topics-div p {
        float: left;
        line-height: 18px;
        margin-top: 8px;
        color: #ef3138;
    }

    .proofread-section .form-box form .first-row {
        float: left;
        width: 100%;
        border-top: 1px solid #d4d4d4;
        padding: 20px 0;
        border-bottom: 1px solid #d4d4d4
    }

    .proofread-section .form-box form .first-row div.checker span {
        position: relative;
        top: -2px;
    }

    /* .proofread-section .form-box form .first-row label {
        width: 80%;
        margin: 0;
        font-size: 16px;
        margin-bottom: 14px;
        font-weight: bold;
    } */

    .proofread-section .form-box form .first-row .sub-topics-div button {
        width: 28%;
        background: #ef3138;
        color: #fff;
        border: none;
        padding: 10px 0;
        font-weight: 600;
        float: right;
        font-size: 11px;
        text-align: center;
    }

    th, td {
        padding: 6px;
        text-align: center;

    }
</style>
<link href="assets/plugins/select2/css/select2.min.css" rel="stylesheet">
<script src="assets/plugins/select2/js/select2.min.js"></script>
<script type="text/javascript">
    var jq = jQuery.noConflict();

    function enableSelect2() {
        jq('.editors-dropdown').select2();
    }
</script>
<section class="proofread-section">
    <div class="container">
        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="panel panel-info">
                    <div class="panel-heading clearfix">
                        <h4 class="panel-title">Assign Topic To Proof Read from Sarkari Pariksha Masters</h4>
                    </div>
                </div>
            </div>

            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="form-box">
                    <form action="" class="row m-0">
                        <div class="col-md-12 col-sm-12 col-xs-12">
                            <label for="master" class="select-master">Select Master</label>
                            <select name="master" id="master">
                                <option value="M">-Master-</option>
                                <?php while ($cat = $allMasterCategory->fetch_assoc()) { ?>
                                    <option value="<?php echo $cat['master_id']; ?>"><?php echo $cat['master_name']; ?></option>
                                <?php } ?>
                            </select>
                        </div>
                        <div class="col-md-6 col-sm-6 col-xs-12">
                            <label for="subject">Select Subject</label>
                            <select name="subject" id="subject">
                                <option value="">-Subject-</option>
                            </select>
                        </div>
                        <div class="col-md-6 col-sm-6 col-xs-12">
                            <label for="topic">Select Topic</label>
                            <select name="topic" id="topic">
                                <option value="">-Topic-</option>
                            </select>
                        </div>
                        <div class="col-md-6 col-sm-6 col-xs-12">
                            <label for="medium">Select Source</label>
                            <select name="medium" id="medium">
                                <option value="MD">-Source Medium-</option>
                                <?php foreach ($allMedium as $md) { ?>
                                    <option value="<?php echo $md['medium_id']; ?>"><?php echo $md['medium_name']; ?></option>
                                <?php } ?>
                            </select>
                        </div>
                        <div class="col-md-6 col-sm-6 col-xs-12">
                            <label for="target_medium">Select Target</label>
                            <select name="target_medium" id="target_medium">
                                <option value="TM">-Target Medium-</option>
                                <?php foreach ($allMedium as $md) { ?>
                                    <option value="<?php echo $md['medium_id']; ?>"><?php echo $md['medium_name']; ?></option>
                                <?php } ?>
                            </select>
                        </div>

                        <section class="first-row" id="sub_topic">
                            
                        </section>
                    </form>
                </div>
            </div>
        </div>
    </div>
</section>

<div class="page-footer">
    <p class="no-s">Graposs Connect &#169;</p>
</div>
<script type="text/javascript">
        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);
                });
            });
            jQuery('#subject').on('change', function() {
                var mid = jQuery("#master").val();
                var subId = jQuery("#subject").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 med_id = jQuery("#medium").val();
                var t_med_id = jQuery("#target_medium").val();
                if (med_id != 'MD' && t_med_id != 'TM') {
                    var mid = jQuery("#master").val();
                    var subId = jQuery("#topic").val();
                    var loadUrl = "ajax_call/new_nqb_proofread_access_sub_topics_view.php?eid=" + subId + "&type=subtopic&m=" + mid;
                    var jqxhr = jQuery.get(loadUrl);
                    jqxhr.success(function(data) {
                        jQuery("#sub_topic").html(data);
                        jQuery("#show_topic_name").html(jQuery("#topic option:selected").text());
                        // jQuery("#sub_topic").css({
                        //     'max-height': '400px',
                        //     'overflow-y': 'scroll'
                        // });
                        enableSelect2();
                    });
                }
            });
            jQuery('#target_medium').on('change', function() {
                jQuery("#sub_topic").html("<i class='fa fa-spinner fa-spin' style='font-size:50px;padding:10px 0 10px 0;margin-left:50%;'></i>");
                var mid = jQuery("#master").val();
                var subId = jQuery("#topic").val();
                var med_id = jQuery("#medium").val();
                var t_med_id = jQuery("#target_medium").val();
                if (med_id == t_med_id) {
                    alert("source and target medium can not be same");
                    jQuery("#target_medium").val('TM');
                    return false;
                }
                else if (med_id != 'MD' && t_med_id != 'TM') {
                    var loadUrl = "ajax_call/new_nqb_proofread_access_sub_topics_view.php?eid=" + subId + "&type=subtopic&m=" + mid;
                    var jqxhr = jQuery.get(loadUrl);
                    jqxhr.success(function(data) {
                        jQuery("#sub_topic").html(data);
                        jQuery("#show_topic_name").html(jQuery("#topic option:selected").text());
                        // jQuery("#sub_topic").css({
                        //     'max-height': '400px',
                        //     'overflow-y': 'scroll'
                        // });
                        enableSelect2();
                    });
                }
            });
            // jQuery('#sub_topic').on('change', function() {
            //
            // });
            jQuery('#medium').on('change', function() {
                var med_id = jQuery("#medium").val();
                var t_med_id = jQuery("#target_medium").val();
                if (med_id == t_med_id) {
                    alert("source and target medium can not be same");
                    jQuery("#target_medium").val('TM');
                    jQuery("#medium").val('MD');
                    return false;
                }
                
            });
            
            jQuery(document).on('click', '.sub-topics-id', function() {
                var sub_tpc_id = this.id.substr(7);
                if (jQuery("#fromid-" + sub_tpc_id).is(':checked')) {
                    var med_id = jQuery("#medium").val();
                    var t_med_id = jQuery("#target_medium").val();
                    var tpc_id = jQuery("#topic").val();
                    var isTopic = jQuery("#assign_check"+sub_tpc_id).val();
                    jQuery("#ques-data-" + sub_tpc_id).html("<i class='fa fa-spinner fa-spin' style='font-size:50px;padding:10px 0 10px 0;margin-left:50%;'></i>");
                    if (med_id == 'MD') {
                        alert("Please select source medium.");
                    } else if (t_med_id == 'TM') {
                        alert("Please select target medium.");
                    } else if (tpc_id == 'T') {
                        alert("Please select topic id");
                    } else if (med_id == t_med_id) {
                        alert("source and target medium can not be same");
                    } else {
                        // jQuery('.info').removeAttr('style');
                        // jQuery('.info').removeClass("info");
                        // jQuery("#" + this.id).addClass("info");
                        // jQuery("#" + this.id).css("pointer-events", "none");
                        if(isTopic == 'wos') {
                            var fromSubtopic = '0';
                        } else {
                            var fromSubtopic = sub_tpc_id;
                        }
                        var loadUrl = "ajax_call/nqb_proofread_medium_ques_count.php?med_id=" + med_id + "&t_med_id=" + t_med_id + "&tpc_id=" + tpc_id + "&sub_tpc_id=" + fromSubtopic;
                        var jqxhr = jQuery.get(loadUrl);
                        jqxhr.success(function(data) {
                            jQuery("#ques-data-" + sub_tpc_id).html(data);
                            jQuery("#btnshow-"+sub_tpc_id).show();
                        });
                    }
                }
            })

            /**assign button */
            jQuery(document).on('click', '.assign-submit', function() {

                var btn_id = this.id.substr(4);
                var assign_s_id = jQuery("#fromid-" + btn_id).val();
                var qtyp_proof = jQuery("#qtyp_proof-" + btn_id).is(':checked') ? jQuery("#qtyp_proof-" + btn_id).val() : '';
                var qtyp_nproof = jQuery("#qtyp_nproof-" + btn_id).is(':checked') ? jQuery("#qtyp_nproof-" + btn_id).val() : '';
                var ttype = jQuery("input[name='ttype-" + btn_id + "']").is(':checked') ? jQuery("input[name='ttype-" + btn_id + "']:checked").val() : '';
                var limit_ques = jQuery("#limit_ques-" + btn_id).val();
                var assignee = jQuery("#assignee-" + btn_id).val();
                var master = jQuery("#master").val();
                var subject = jQuery("#subject").val();
                var topic = jQuery("#topic").val();
                var medium = jQuery("#medium").val();
                var target_medium = jQuery("#target_medium").val();
                var assign_check = jQuery("#assign_check" + +btn_id).val();
                if (assignee == 'AS') {
                    alert("Please select assignee");
                } else if (jQuery("input[name='ttype-" + btn_id + "']").is(':checked') == false) {
                    alert("Please select assignee role");
                } else {
                    var r = confirm("Are you sure to assign this topic ?");
                    if (r == true) {
                        jQuery("#btn-" + btn_id).attr("disabled", "disabled");
                        if(assign_check == 'wos') {
                            var sub_topic_id = '0';
                        } else {
                            var sub_topic_id = assign_s_id;
                        }
                        var arr = {
                            "assign_s_id": sub_topic_id,
                            "qtyp_proof": qtyp_proof,
                            "qtyp_nproof": qtyp_nproof,
                            "ttype": ttype,
                            "limit_ques": limit_ques,
                            "assignee": assignee,
                            "master": master,
                            "subject": subject,
                            "topic": topic,
                            "medium": medium,
                            "target_medium": target_medium,
                            "master_type": "sp",
                            "assign_type": "master",
                            "assign_check": assign_check
                        }
                        jQuery.ajax({
                            type: "POST",
                            url: "ajax_call/new_nqb_master_assign_questions.php",
                            data: JSON.stringify(arr),
                            contentType: 'application/json; charset=utf-8',
                            dataType: 'Json',
                            success: function(data) {
                                if (data.status == '1') {
                                    jQuery("#btn-" + btn_id).remove();
                                    jQuery("#btnshow-" + btn_id).html(data.message);
                                    jQuery("#btnshow-" + btn_id).css("color","green");
                                } else {
                                    alert(data.message);
                                }
                            }
                        });
                    } else {
                        return false;
                    }
                }
            });
        });
    </script>
<?php
} else {
    echo "<script type='text/javascript'>alert('You dont have access to assign');</script>";
    echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>