<?php
header("Content-type: text/html; charset=utf-8");
require '../configs/app_top.php';
if (!is_admin_logged_in()) {
  redirect(generate_admin_link("login"));
  exit;
}
$title = "การจัดการข้อสอบ";

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';
?>
<div class="clearfix"></div>
<div class="preload">
<div class="alert alert-warning">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  <center><font color="red"><strong>กรุณารอสักครู่..</strong> อยู่ระหว่างการดึงข้อมูลจากฐานข้อมูล</font></center>
</div>
</div>
<div class="content">

    <!-- GLOBAL STYLES -->
    <link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.css" />
    <link rel="stylesheet" href="assets/css/main.css" />
    <link rel="stylesheet" href="assets/css/theme.css" />
    <link rel="stylesheet" href="assets/css/MoneAdmin.css" />
    <link rel="stylesheet" href="assets/plugins/Font-Awesome/css/font-awesome.css" />
    <!--END GLOBAL STYLES -->

<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="row">
  <div class="col-12">
    <div class="panel panel-danger">
      <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>รายวิชา : </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>หมวดหมู่ : </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>เวลาสอบ : </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">
                      นาที
                    </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> กลับหน้าหลัก</button>
                  </a>

                  <a href="Import_Excel2007/Export_xlsx.php?idsubject=<?php echo $results[0]["sb_id"]; ?>&sb_name=<?php echo $results[0]["sb_name"]; ?>">
                    <button class="btn btn-default" type="button">
                      <span class="glyphicon glyphicon-export"></span> ส่งออก</button>
                  </a>

<button class="btn btn-default" data-toggle = "modal" data-target="#editemployee" data-id="<?php echo $results[0]['sb_id']; ?>"><span class="glyphicon glyphicon-import"></span> นำเข้า</button>
<div class="modal fade" id="editemployee" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
<button type="button" onclick="javascript:window.location.reload()" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
        <h4 class="modal-title">นำเข้าแบบทดสอบ</h4>
      </div>
      <div class="modal-body">
<?php 
// เริ่มฟอร์มนำเข้าแบบทดสอบจากไฟล์ Excel
require '../configs/host.php';
$idsubject=$_REQUEST["id"];

?>
<iframe src="Import_Excel2007/upload_q.php?id=<?=$idsubject;?>" width="500" height="150" frameborder="0"></iframe>
      </div>
      <div class="modal-footer">
<button type="button" onclick="javascript:window.location.reload()" class="btn btn-default" data-dismiss="modal">Close</button>

      </div>
    </div>
  </div>
</div>
<script type="text/javascript">
$(document).ready(function() {
	$('#editemployee').on('show.bs.modal', function (event) {
	  var button = $(event.relatedTarget);
	  var id= button.data('id');
	  var modal = $(this);
	  modal.find('#emp_id').val(id);
	});
});

</script>


<!--
                  <a href="Import_Excel2007/Export_xlsx.php?idsubject=<?php echo $results[0]["sb_id"]; ?>&sb_name=<?php echo $results[0]["sb_name"]; ?>">
                    <button class="btn btn-default" type="button">
                      <span class="glyphicon glyphicon-export"></span> นำเข้า</button>
                  </a>
-->
                  <button class="btn btn-primary" type="button" onclick="$('#qstn').toggle('fast');">
                    <span class="glyphicon glyphicon-plus-sign"></span> เพิ่มข้อสอบ</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>คำถาม : </label>
                  <div class="col-8">
	<link rel="stylesheet" type="text/css" href="editor/lib/css/prettify.css"/>
	<link rel="stylesheet" type="text/css" href="editor/src/bootstrap-wysihtml5.css"/>
 <textarea id="qb_question" name="qb_question" rows="3" class="textarea form-control" style="width:640px;height:120px;"></textarea>
				
					
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt1"><span class="required">*</span>ก : </label>
                  <div class="col-8">
                    <textarea id="opt1" name="opt1" rows="3" class="textarea form-control" style="width:640px;height:80px;"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt2"><span class="required">*</span>ข : </label>
                  <div class="col-8">
                    <textarea id="opt2" name="opt2" rows="3"  class="textarea form-control" style="width:640px;height:80px;"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt3"><span class="required">*</span>ค : </label>
                  <div class="col-8">
                    <textarea id="opt3" name="opt3" rows="3"  class="textarea form-control" style="width:640px;height:80px;"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="opt4"><span class="required">*</span>ง : </label>
                  <div class="col-8">
                    <textarea id="opt4" name="opt4" rows="3"  class="textarea form-control" style="width:640px;height:80px;"></textarea>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="ans"><span class="required">*</span>คำตอบ : </label>
                  <div class="col-2">
                    <select class="form-control" name="ans" id="ans">
                      <option value="1">ก</option>
                      <option value="2">ข</option>
                      <option value="3">ค</option>
                      <option value="4">ง</option>
                    </select>
                  </div>
                </div>

                <div class="form-group">
                  <label class="col-2 control-label" for="sort_order"><span class="required">*</span>ลำดับที่ : </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"></div>
                  </div>

                </div>

                <div class="form-group">
                  <div class="col-10 col-offset-2">
                    <button class="btn btn-primary" type="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> ข้อสอบในรายวิชานี้</div>
      <div class="panel-body">
        <div class="margin10">

          <div class="accordion">
            
            <?php 
            $c = 0;
            foreach($qresults as $q) { 
              $c++;
            ?>
			
			  <div class="panel panel-default">
        <div class="panel-heading">
          <h4 class="panel-title" data-toggle="collapse" data-target="#collapse<?php echo safe_output($q["qb_id"]); ?>">
            ข้อ <?php echo $c; ?> <?php echo safe_output($q["qb_question"]); ?>
          </h4>
        </div>
        <div id="collapse<?php echo safe_output($q["qb_id"]); ?>" class="panel-collapse collapse <?php echo safe_output($q["qb_id"] == $_GET["qid"]) ? "in" : ""; ?>">
          <div class="panel-body">
            <!-- content goes here -->
            
                  <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>คำถาม : </label>
                        <div class="col-8">
                          <textarea id="qb_question" name="qb_question" rows="3"  class="textarea form-control" style="width:600px;height:100px;"><?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>ก : </label>
                        <div class="col-8">
                          <textarea id="opt1" name="opt1" rows="3"  class="textarea form-control" style="width:600px;height:80px;"><?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>ข : </label>
                        <div class="col-8">
                          <textarea id="opt2" name="opt2" rows="3"  class="textarea form-control" style="width:600px;height:80px;"><?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>ค : </label>
                        <div class="col-8">
                          <textarea id="opt3" name="opt3" rows="3"  class="textarea form-control" style="width:600px;height:80px;"><?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>ง : </label>
                        <div class="col-8">
                          <textarea id="opt4" name="opt4" rows="3"  class="textarea form-control" style="width:600px;height:80px;"><?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>คำตอบ : </label>
                        <div class="col-2">
                          <select class="form-control" name="ans" id="ans">
                            <option value="1" <?php echo ($q["qb_answer"] == 1) ? "selected" : ""; ?>>ก</option>
                            <option value="2" <?php echo ($q["qb_answer"] == 2) ? "selected" : ""; ?>>ข</option>
                            <option value="3" <?php echo ($q["qb_answer"] == 3) ? "selected" : ""; ?>>ค</option>
                            <option value="4" <?php echo ($q["qb_answer"] == 4) ? "selected" : ""; ?>>ง</option>
                          </select>
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-2 control-label" for="sort_order"><span class="required">*</span>ลำดับที่ : </label>
                        <div class="col-3">
                          <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>
						
                      </div>
					  <div class="form-group">
					  <div class="col-4 col-offset-2 help-block"></div>
					 </div>
					 
					 <div class="clearfix"></div>
                      <div class="form-group">
                        <div class="col-12 col-offset-2">
                          <button class="btn btn-primary" type="submit"><span class="glyphicon glyphicon-edit"></span> บันทึก</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> ลบ</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" style="width: 530px; ">
                <div class="modal-content">
                  <div class="modal-header">
                    <h4>ลบข้อสอบ</h4>
                  </div>
                  <div class="modal-body">
                    คุณต้องการลบข้อสอบข้อนี้ ?
                  </div>
                  <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
                    <a href="#" class="btn btn-danger danger">ลบ</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'));
    });
	
	  jQuery('#accordion').on('show.bs.collapse', function() {
        jQuery('#accordion .in').collapse('hide');
      });
				
  });
</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>
<link rel="stylesheet" type="text/css" href="../upload/src/bootstrap-wysihtml5.css" />

<script src="../upload/lib/js/wysihtml5-0.3.0.js"></script>
<script src="../upload/lib/js/jquery-1.7.2.min.js"></script>
<script src="../upload/lib/js/bootstrap.min.js"></script>
<script src="../upload/src/bootstrap3-wysihtml5.js"></script>

	<script type="text/javascript" charset="utf-8">
		$(prettyPrint);
	</script>
	        <script>
            $('.textarea').wysihtml5({
                "font-styles": false, //Font styling, e.g. h1, h2, etc. Default true
                "emphasis": false, //Italics, bold, etc. Default true
                "lists": false, //(Un)ordered lists, e.g. Bullets, Numbers. Default true
                "html": true, //Button which allows you to edit the generated HTML. Default false
                "link": false, //Button to insert a link. Default true
                "image": true, //Button to insert an image. Default true,
                "color": false //Button to change color of font  
            });
        </script>
<script>
	$(function() {
		$(".preload").fadeOut(2000, function() {
			$(".content").fadeIn(1000);
		});
	});
</script>
</div>
<?php
include './includes/footer.php';
require '../configs/app_bottom.php';
?>