<?php
$sql= $mysqli->query("SELECT * FROM sc_address where sc_id='$logged_username'");
$chksc=mysqli_num_rows($sql);
$Row = mysqli_fetch_array($sql);
if($chksc > 0){
	$statusset = "update";
}else {
	$statusset = "insert";	
}
$day=date("His");
?>
		<script src="assets/plugins/crop/croppie.js"></script>
		<link rel="stylesheet" href="assets/plugins/crop/croppie.css" />		
		
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left">ข้อมูลโรงเรียน<?=$logged_user_name;?></h1>
					<ol class="breadcrumb float-right">
					<li class="breadcrumb-item">Home</li>
					<li class="breadcrumb-item active">scinformation</li>
                    </ol>
                    <div class="clearfix"></div>
            </div>
		</div>
	</div>
    <!-- end row -->
				<div class="row">
			
                    <div class="col-xs-12 col-sm-12 col-md-12 col-lg-6 col-xl-12">						
						<div class="card mb-3">
							<div class="card-header">
							<span class="pull-right">
							</span>							
								<h3><i class="fa fa-table"></i> ที่อยู่โรงเรียน</h3>
							</div>
								
							<div class="card-body">
<form action="core/#?status=<?=$statusset;?>" method="post" enctype="multipart/form-data">							
								<div class="row">	
								
								<div class="col-lg-9 col-xl-9">
									
									<div class="row">				
										<div class="col-lg-6">
										<div class="form-group">
										<label>เลขที่</label>
										<input class="form-control" name="no" type="text" value="" required />
										</div>
										</div>

										<div class="col-lg-6">
										<div class="form-group">
										<label>หมู่ที่</label>
										<input class="form-control" name="moo" type="username" value="" />
										</div>
										</div>  
									</div>
									
									<div class="row">				
										<div class="col-lg-6">
										<div class="form-group">
										<label>ตำบล</label>
										<input class="form-control" name="tambol" type="text" value="" />
										</div>
										</div>              			                                
										
										<div class="col-lg-6">
										<div class="form-group">
										<label>อำเภอ</label>
										<input class="form-control" name="ampher" type="text" value="" />
										</div>
										</div>   
									</div>

									<div class="row">				
										<div class="col-lg-6">
										<div class="form-group">
										<label>จังหวัด</label>
										<input class="form-control" name="province" type="text" value="" />
										</div>
										</div>              			                                
										
										<div class="col-lg-6">
										<div class="form-group">
										<label>รหัสไปรษณีย์</label>
										<input class="form-control" name="zipcode" type="text" value="" />
										</div>
										</div>   
									</div>
									<div class="row">				
										<div class="col-lg-6">
										<div class="form-group">
										<label>Latitude</label>
										<input class="form-control" name="lat" type="text" value="" />
										</div>
										</div>              			                                
										
										<div class="col-lg-6">
										<div class="form-group">
										<label>Longtitude</label>
										<input class="form-control" name="long" type="text" value="" />
										</div>
										</div>   
									</div>									
									<div class="row">				
										<div class="col-lg-6">
										<div class="form-group">
										<label>โทรศัพท์</label>
										<input class="form-control" name="tel" type="text" value="" />
										</div>
										</div>              			                                
										
										<div class="col-lg-6">
										<div class="form-group">
										<label>โทรสาร</label>
										<input class="form-control" name="fax" type="text" value="" />
										</div>
										</div>   
									</div>
									<div class="row">				
										<div class="col-lg-6">
										<div class="form-group">
										<label>ชื่อ-สกุล ผู้บริหาร</label>
										<input class="form-control" name="boss" type="text" value="" />
										</div>
										</div>              			                                
										
										<div class="col-lg-6">
										<div class="form-group">
										<label>สถานะ</label>
<select class="form-control" name="boss">
	<option value="ผู้อำนวยการ" <?php echo ($Row["sc_boss"] == 'ผู้อำนวยการ') ? "selected" : ""; ?>>ผู้อำนวยการ</option>
	<option value="รักษาการผู้อำนวยการ" <?php echo ($Row["sc_boss"] == 'รักษาการผู้อำนวยการ') ? "selected" : ""; ?>>รักษาการผู้อำนวยการ</option>
</select>
										</div>
										</div>   
									</div>								
								</div>
								
								<div class="col-lg-3 col-xl-3 border-center">
									<div class="panel-body" align="center">
									<p>โลโก้โรงเรียน</p>
									<?php  if($Row["sc_logo"]==""){ ?>
										<img src='uploads/images/obec.jpg' width='170'>
									<? }else { ?>
										<img src='uploads/logosc/<?=$Row['sc_logo'];?>?id=<?=$day=date("His");;?>' width='170'>
									<?php } ?>
									<div class="row"><div id="uploaded_image"></div></div>

										<div class="row"><input type="file" name="upload_image" id="upload_image" /></div>
									</div>									
								</div>
								
								</div>				
<div class="row">
    <div class="form-group text-right m-b-0">
        <button class="btn btn-primary" type="submit"> บันทึก</button>
            <button type="reset" onclick="goBack()" class="btn btn-secondary m-l-5">ยกเลิก</button>
			<script>
				function goBack() {
				window.history.back();
				}
			</script>			
    </div>
</div>
							</div>														
						</div><!-- end card-->	
				
                    </div>
			</div>
		
								<!-- Modal -->
<div id="uploadimageModal" class="modal" role="dialog" tabindex="-1" role="dialog" aria-labelledby="customModal" aria-hidden="true">
	<div class="modal-dialog" role="document">
		<div class="modal-content">
									  <div class="modal-header">
										<h5 class="modal-title" id="exampleModalLabel">รูปโลโก้โรงเรียน</h5>
										<button type="button" class="close" data-dismiss="modal" aria-label="Close">
										  <span aria-hidden="true">&times;</span>
										</button>
									  </div>
      		<div class="modal-body">
        		<div class="row">
  					<div class="col-md-12 text-center">
						  <div id="image_demo" style="width:100%; margin-top:30px"></div>
  					</div>

				</div>
      		</div>
									  <div class="modal-footer">
										<button type="button" class="btn btn-secondary" data-dismiss="modal">ยกเลิก</button>
										<button type="button" class="btn btn-primary crop_image">ตกลง</button>
									  </div>
    	</div>
    </div>
</div>

<script>  
$(document).ready(function(){

	$image_crop = $('#image_demo').croppie({
    enableExif: true,
    viewport: {
      width:200,
      height:250,
      type:'square' //circle
    },
    boundary:{
      width:300,
      height:300
    }
  });

  $('#upload_image').on('change', function(){
    var reader = new FileReader();
    reader.onload = function (event) {
      $image_crop.croppie('bind', {
        url: event.target.result
      }).then(function(){
        console.log('jQuery bind complete');
      });
    }
    reader.readAsDataURL(this.files[0]);
    $('#uploadimageModal').modal('show');
  });

  $('.crop_image').click(function(event){
    $image_crop.croppie('result', {
      type: 'canvas',
      size: 'viewport'
    }).then(function(response){
      $.ajax({
        url:"<?php echo ADMIN_URL;?>/uploads/logosc/reupload.php",
        type: "POST",
        data:{"image": response},
        success:function(data)
        {
          $('#uploadimageModal').modal('hide');
          $('#uploaded_image').html(data);
        }
      });
    })
  });

});  
</script>