<?php
function installer(){
    include('installer.php');
}
register_activation_hook( __file__, 'installer' ); //executes installer php when installing plugin to create new database

//database update checkdate
function myplugin_update_db_check() {
    global $xenon_result_db_version;
    if ( get_option( 'xenon_result_db_version' ) != $xenon_result_db_version ) {
        installer();
    }
}

add_action( 'plugins_loaded', 'myplugin_update_db_check' );


//result display form begins

function display_result_form_fields(){
    ob_start(); ?>
    <div  class="contact-page-content">
    <h3 align="center" class="contact-heading">Xenon Entrance Exam - 2017 Result</h3>
    <form id="result_form" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="POST" >
            <fieldset>
            <p>
                    <label for="rollNumber"><?php _e('<strong>Roll Number</strong><br />'); ?></label>
                    <input name="rollNumber" pattern="[0-9]{6}" id="rollNumber" type='number' required placeholder='Enter six digit roll number.'>
            </p>
            <p>
                    <label for="studentName"><?php _e('<strong>Student Name</strong>'); ?></label>
                    <input name="studentName" id="studentName" type='text' required placeholder='Enter student&#39;s name.'>
            </p>
            <p>
                    <label for="mobileNumber"><?php _e('<strong>Mobile Number</strong>'); ?></label>
                    <input name="mobileNumber" pattern="[0-9]{10}" id="mobileNumber" type='tel' required placeholder='Enter your registered 10 digit mobile number.' title = "Enter your 10 digit mobile number registered with us.">
            </p>
                    <input type="submit" style='background-color:#003a6a;color:white' {background-color:red} name = "submit" value="Submit"/>
            </fieldset>
        </form>
        </div>
    <?php
    return ob_get_clean();
}

function form_processing(){
    global $wpdb;
    $roll_number = $_POST['rollNumber'];
    $query = "SELECT * FROM `wp_xenon_result` WHERE `roll_number` = '$roll_number'";
    $result = $wpdb->get_row($query);
    if(isset($result->roll_number)&& ($result->mobile==$_POST['mobileNumber'] || strcasecmp($result->student_name, $_POST['studentName']) == 0)){
        if($result->result == "QUALIFIED"){
            echo "<div class='widget-inner'><p>Dear <b>".$result->student_name."</b>, you scored <b style='color:green'>".$result->obj_marks." marks</b> in objective paper (cutoff was 43) and <b style='color:green'>".$result->sub_marks." marks</b> in subjective paper (cutoff was 20).</p><p>Your result is <b style='color:green'>".$result->result."</b>.</p><p><b>Note:</b> Kindly visit our office till <b style='color:red;'>2nd March 2017</b> to get final admission else your admission will be cancelled.</p></div>";
        }
        if($result->result == "NOT QUALIFIED"){
            if($result->obj_marks>=43 && $result->sub_marks<20){
                echo "<div class='widget-inner'><p>Dear <b>".$result->student_name."</b>, you scored <b style='color:green'>".$result->obj_marks." marks</b> in objective paper (cutoff was 43) and <b style='color:red'>".$result->sub_marks." marks</b> in subjective paper (cutoff was 20).</p><p>Your result is <b style='color:red'>".$result->result."</b>.</p></div>";
            }
            elseif($result->obj_marks<43 && $result->sub_marks>=20){
                echo "<div class='widget-inner'><p>Dear <b>".$result->student_name."</b>, you scored <b style='color:red'>".$result->obj_marks." marks</b> in objective paper (cutoff was 43) and <b style='color:green'>".$result->sub_marks." marks</b> in subjective paper (cutoff was 20).</p><p>Your result is <b style='color:red'>".$result->result."</b>.</p></div>";
            }
            elseif($result->obj_marks<43 && $result->sub_marks<20){
                echo "<div class='widget-inner'><p>Dear <b>".$result->student_name."</b>, you scored <b style='color:red'>".$result->obj_marks." marks</b> in objective paper (cutoff was 43) and <b style='color:red'>".$result->sub_marks." marks</b> in subjective paper (cutoff was 20).</p><p>Your result is <b style='color:red'>".$result->result."</b>.</p></div>";
            }
        }
    }
    elseif(!isset($result->roll_number)){
        echo "<div class='widget-inner'>Kindly enter the correct <b style='color:red'>roll number.<b></div>";
        }
    elseif(!($result->mobile==$_POST['mobileNumber'] || strcasecmp($result->father_name, $_POST['studentName']) == 0)){
        echo "<div class='widget-inner'>You either entered <b style='color:red'>wrong student name</b> or <b style='color:red'>wrong mobile number</b>. <strong>Kindly enter the correct details.</strong></div>";}
        }


//shortcode begins here
function result_form() {
    ob_start();
    if(isset($_POST['submit'])){
        form_processing();
        }
    else{
        $output = display_result_form_fields();
        return $output;
    }
    return ob_get_clean();
    }

add_shortcode('result_form', 'result_form'); //create shortcode
add_filter('widget_text','do_shortcode'); // Enable shortcodes in text widgets
?>