<?php
include_once('nqb_master_section.php');

$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$TT_PREVIOUS_EXAM_TABLE = 'csp_sp_previous_exam';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';

$getQuesData = $conn->query("SELECT sp.question_id,m.master_name,sp.medium_id FROM $SP_QUESTION as sp LEFT JOIN $SP_MASTER_CATEGORY as m on m.master_id=sp.master_id where sp.option_3!='' and sp.option_4!='' and (sp.option_1=sp.option_2 OR sp.option_2=sp.option_3 OR sp.option_3=sp.option_4 OR sp.option_1=sp.option_3 OR sp.option_1=sp.option_4 OR sp.option_2=sp.option_4)");


?>

<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-12">
        <div class="panel panel-info">
            <div class="col-md-6">
                <div class="panel panel-info">
                    <div class="panel-heading clearfix">
                        <h4 class="panel-title">Questio Ids with same options</h4>
                    </div>
                    <table class="table table-hover">
                        <tr>
                            <th>S.No.</th>
                            <th>Question Id</th>
                            <th>In Master</th>
                            <th>View</th>
                        </tr>
                        <?php
                        $i = 1;
                        foreach ($getQuesData as $qb) {
                            $qTotal = $qTotal + $qb['qnc'];
                            $examName = str_replace($spaceArray, $replaceArray, $qb['previous_exam_name']);

                            $secMedium = $qb['medium_id'] == 1 ? '&secMed=2' : '';
                        ?>
                            <tr>
                                <td><?php echo $i; ?></td>
                                <td><?php echo $qb['question_id']; ?></td>
                                <td><?php echo $qb['master_name']; ?></td>
                                <td><a style="text-decoration:none; color: #0050ef;font-size:20px;" href="nqb_single_question_view?qId=<?php echo $qb['question_id'].$secMedium; ?>" target="_blank" title="View question"> <i class="fa fa-eye"></i> </a>
                                </td>
                            </tr>
                        <?php $i++;
                        } ?>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div class="page-footer">
        <p class="no-s">Graposs Connect &#169;</p>
    </div>
</div>
<?php
include_once('footer.php');
?>