<?php
require '../configs/app_top.php';
if (!is_admin_logged_in()) {
  redirect(generate_admin_link("login"));
  exit;
}
$title = "Manage Questions";

try {


  $sql = "select s.`sb_id`, s.`sb_name`, s.`sb_category_id`, s.`active`, c.`ct_name`,`sb_duration`  "
          . "FROM " . TBL_SUBJECTS . " s INNER JOIN " . TBL_CATEGORY . " c ON s.`sb_category_id` = c.`ct_id` "
          . "WHERE 1 AND s.sb_id = :id ORDER BY s.sb_name ASC LIMIT 1 ";

  $stmt = $DB->prepare($sql);
  $stmt->bindValue(":id", safe_input($_GET["id"]));
  $stmt->execute();
  $results = $stmt->fetchAll();

  $sql2 = "select `qb_id`, `qb_subject_id`, `qb_question`, `qb_option1`, `qb_option2`, `qb_option3`, `qb_option4`, `qb_answer`, `sort_order`  "
          . "FROM " . TBL_QUESTIONS . " WHERE 1 AND qb_subject_id = :id ORDER BY sort_order ASC";

  $stmt = $DB->prepare($sql2);
  $stmt->bindValue(":id", safe_input($_GET["id"]));
  $stmt->execute();

  $qresults = $stmt->fetchAll();
} catch (Exception $ex) {
  echo $ex->getMessage();
}


include './includes/header.php';
?>
<script src="<?php echo get_admin_url(); ?>js/jquery.validate.js"></script>
<?php if ($ERROR_TYPE <> "") { ?>
  <div class="col-12">
    <div class="alert alert-<?php echo $ERROR_TYPE; ?>">
      <button data-dismiss="alert" class="close" type="button">×</button>
      <?php echo $ERROR_MSG; ?>
    </div>
  </div>
<?php } ?>
<div class="clearfix"></div>
<div class="row">
  <div class="col-12">
    <div class="panel panel-default">
      <div class="panel-heading"><span class="glyphicon glyphicon-edit"></span> <?php echo $title; ?></div>
      <div class="panel-body">
        <div class="margin10">
          <form class="form-horizontal" action="#">
            <fieldset>
              <div class="form-group">
                <label class="col-2 control-label" for="sb_name"><span class="required">*</span>Subject Name: </label>
                <div class="col-6">
                  <input type="text" placeholder="Subject Name" id="sb_name" autocomplete="off" name="sb_name" class="form-control" value="<?php echo $results[0]["sb_name"]; ?>" readonly="">
                </div>
              </div>

              <div class="form-group">
                <label class="col-2 control-label" for="category"><span class="required">*</span>Category: </label>
                <div class="col-6">
                  <input type="text" placeholder="Category" id="category" autocomplete="off" name="category" class="form-control" value="<?php echo $results[0]["ct_name"]; ?>" readonly="">
                </div>
              </div>

              <div class="form-group">
                <label class="col-2 control-label" for="sb_duration"><span class="required">*</span>Duration: </label>
                <div class="col-3">
                  <div class="input-group">
                    <input type="text" placeholder="Duration" id="sb_duration" autocomplete="off" name="sb_duration" class="form-control" value="<?php echo $results[0]["sb_duration"]; ?>" readonly="">
                    <span class="input-group-addon">
                      MINUTES
                    </span>
                  </div>
                </div>
              </div>

              <div class="form-group">
                <div class="col-6 col-offset-2">
                  <a href="<?php echo generate_admin_link("manage_subjects"); ?>">
                    <button class="btn btn-warning" type="button">
                      <span class="glyphicon glyphicon-backward"></span> Back to subjects</button>
                  </a>


                  <button class="btn btn-primary" type="button" onclick="$('#qstn').toggle('fast');">
                    <span class="glyphicon glyphicon-plus-sign"></span> Add new Question</button>
                </div>
              </div>

            </fieldset>
          </form>

          <div id="qstn" style="display: none">

            <form class="form-horizontal" name="qform" id="qform" action="<?php echo generate_admin_link("question_auth"); ?>" method="post">
              <input type="hidden" name="mode" value="add_new">
              <input type="hidden" name="id" value="<?php echo intval(safe_input($_GET["id"])); ?>">
              <fieldset>
                <div class="form-group">
                  <label class="col-2 control-label" for="qb_question"><span class="required">*</span>Question: </label>
                  <div class="col-8">
                    <textarea id="qb_question" name="qb_question" rows="3" class="form-control"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt1"><span class="required">*</span>Option #1: </label>
                  <div class="col-8">
                    <textarea id="opt1" name="opt1" rows="3" class="form-control"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt2"><span class="required">*</span>Option #2: </label>
                  <div class="col-8">
                    <textarea id="opt2" name="opt2" rows="3" class="form-control"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt3"><span class="required">*</span>Option #3: </label>
                  <div class="col-8">
                    <textarea id="opt3" name="opt3" rows="3" class="form-control"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt4"><span class="required">*</span>Option #4: </label>
                  <div class="col-8">
                    <textarea id="opt4" name="opt4" rows="3" class="form-control"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="ans"><span class="required">*</span>Answer: </label>
                  <div class="col-2">
                    <select class="form-control" name="ans" id="ans">
                      <option value="1">1</option>
                      <option value="2">2</option>
                      <option value="3">3</option>
                      <option value="4">4</option>
                    </select>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="sort_order"><span class="required">*</span>Sort Order: </label>
                  <div class="col-6">
                    <input style="width: 100px;" type="text" placeholder="Sort Order" id="sort_order" autocomplete="off" name="sort_order" class="form-control" value="<?php echo count($qresults)+1; ?>">
                    <div class="help-inline">Lowest number has highest precedence</div>
                  </div>

                </div>

                <div class="form-group">
                  <div class="col-10 col-offset-2">
                    <button class="btn btn-primary" type="submit">Submit</button> 
                  </div>
                </div>

              </fieldset>
            </form>

          </div>
        </div>

      </div>
    </div>

    <div class="panel panel-info" id="accordion">
      <div class="panel-heading"><span class="glyphicon glyphicon-edit"></span> Questions Added</div>
      <div class="panel-body">
        <div class="margin10">

          <div class="accordion">
            
            <?php 
            $c = 0;
            foreach($qresults as $q) { 
              $c++;
            ?>
			
			
			
            <div class="accordion-group">
              <div class="accordion-heading">
                <a name="<?php echo safe_output($q["qb_id"]); ?>"></a>
                <a href="#collapse<?php echo safe_output($q["qb_id"]); ?>" data-parent="#myAccordion" data-toggle="collapse" class="accordion-toggle">Question #<?php echo $c; ?></a>
              </div>
              <div class="accordion-body collapse <?php echo safe_output($q["qb_id"] == $_GET["qid"]) ? "in" : ""; ?>" id="collapse<?php echo safe_output($q["qb_id"]); ?>">
                <div class="accordion-inner">
                  <div class="padding10"></div>
				  
				  
                  <form class="form-horizontal" name="form<?php echo safe_output($q["qb_id"]); ?>" id="form<?php echo safe_output($q["qb_id"]); ?>" action="<?php echo generate_admin_link("question_auth"); ?>" method="post">
                    <input type="hidden" name="mode" value="update">
                    <input type="hidden" name="id" value="<?php echo intval(safe_input($_GET["id"])); ?>">
                    <input type="hidden" name="qid" value="<?php echo intval($q["qb_id"]); ?>">
                    <fieldset>
                      <div class="form-group">
                        <label class="col-2 control-label" for="qb_question"><span class="required">*</span>Question: </label>
                        <div class="col-8">
                          <textarea id="qb_question" name="qb_question" rows="3" class="form-control"><?php echo safe_output($q["qb_question"]); ?></textarea>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="opt1"><span class="required">*</span>Option #1: </label>
                        <div class="col-8">
                          <textarea id="opt1" name="opt1" rows="3" class="form-control"><?php echo safe_output($q["qb_option1"]); ?></textarea>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="opt2"><span class="required">*</span>Option #2: </label>
                        <div class="col-8">
                          <textarea id="opt2" name="opt2" rows="3" class="form-control"><?php echo safe_output($q["qb_option2"]); ?></textarea>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="opt3"><span class="required">*</span>Option #3: </label>
                        <div class="col-8">
                          <textarea id="opt3" name="opt3" rows="3" class="form-control"><?php echo safe_output($q["qb_option3"]); ?></textarea>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="opt4"><span class="required">*</span>Option #4: </label>
                        <div class="col-8">
                          <textarea id="opt4" name="opt4" rows="3" class="form-control"><?php echo safe_output($q["qb_option4"]); ?></textarea>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="ans"><span class="required">*</span>Answer: </label>
                        <div class="col-2">
                          <select class="form-control" name="ans" id="ans">
                            <option value="1" <?php echo ($q["qb_answer"] == 1) ? "selected" : ""; ?>>1</option>
                            <option value="2" <?php echo ($q["qb_answer"] == 2) ? "selected" : ""; ?>>2</option>
                            <option value="3" <?php echo ($q["qb_answer"] == 3) ? "selected" : ""; ?>>3</option>
                            <option value="4" <?php echo ($q["qb_answer"] == 4) ? "selected" : ""; ?>>4</option>
                          </select>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="sort_order"><span class="required">*</span>Sort Order: </label>
                        <div class="col-6">
                          <input style="width: 100px;" type="text" placeholder="Sort Order" id="sort_order" autocomplete="off" name="sort_order" class="form-control" value="<?php echo intval($q["sort_order"]); ?>">
                          <div class="help-inline">Lowest number has highest precedence</div>
                        </div>

                      </div>

                      <div class="form-group">
                        <div class="col-10 col-offset-2">
                          <button class="btn btn-primary" type="submit"><span class="glyphicon glyphicon-edit"></span> Update</button> 
                          
                          
                           <a data-href="<?php echo generate_admin_link("question_auth", "mode=delete&qid=" . ($q["qb_id"]) . "&" . get_all_get_params(array("qid"))); ?>" data-toggle="modal" data-target="#confirm-delete"  href="javascript:void(0);">
                          <button class="btn btn-danger" type="button"><span class="glyphicon glyphicon-trash"></span> Delete</button>
                        </a>
                          
                        </div>
                      </div>
                      
                      

                    </fieldset>
                  </form>
				  
				  
                </div>
              </div>
            </div>    
            <?php } ?>
            
            <div class="modal fade" id="confirm-delete" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
              <div class="modal-dialog">
                <div class="modal-content">
                  <div class="modal-header">
                    <h4>Delete</h4>
                  </div>
                  <div class="modal-body">
                    Are you sure you want to delete?
                  </div>
                  <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
                    <a href="#" class="btn btn-danger danger">Delete</a>
                  </div>
                </div>
              </div>
            </div>
            
          </div>

        </div>

      </div>
    </div>

  </div>
</div>

<script>
  jQuery(function() {
    jQuery('#confirm-delete').on('show.bs.modal', function(e) {
      jQuery(this).find('.danger').attr('href', jQuery(e.relatedTarget).data('href'));
    });
  });
</script>

<script type="text/javascript">
                    jQuery().ready(function() {

                      // validate signup form on keyup and submit
                      jQuery("#qform").validate({
                        rules: {
                          qb_question: {
                            required: true,
                          },
                          opt1: {
                            required: true,
                          },
                          opt2: {
                            required: true,
                          },
                          opt3: {
                            required: true,
                          },
                          opt4: {
                            required: true,
                          },
                          ans: {
                            required: true,
                            number: true
                          },
                          sort_order: {
                            required: true,
                            number: true
                          },
                        },
                        errorElement: "span",
                        errorClass: "help-inline",
                        onkeyup: false,
                        onfocusout: true,
                        onclick: false,
                        onfocusin: false,
                        highlight: function(element) {
                          jQuery(element).parent().parent().removeClass("has-success");
                          jQuery(element).closest('div').parent().addClass("has-error");
                        },
                        unhighlight: function(element) {
                          jQuery(element).parent().parent().removeClass("has-error");
                          jQuery(element).closest('div').parent().addClass("has-success");
                        }
                      });

                    });

</script>

<?php
include './includes/footer.php';
require '../configs/app_bottom.php';
?>