<?php require_once("../include/class.php");?>
<?php require_once("../include/header.php");?>
<?php require_once("../include/nav_top.php");?>
<?php require_once("../include/sidebar.php");?>
<?php include("table_name.php");?>

<div id="main-content">
  <div class="container-fluid">
  
    <ul class="breadcrumb">
      <li><a href="../<?php echo $name_folder; ?>/list.php"><?php echo ucfirst($name_table) ?></a><span class="divider">&raquo;</span></li>
      <li class="active">List   
      
     &nbsp; &nbsp;  <input type="text" value="https://onnud20.com/horo/daily/extra.php" id="url_main"> <button onclick="myFunction('main')">Copy URL หน้าดูดวง</button>
      </li>
    </ul>
    
    <div class="row-fluid">
			<div class="span12">
				<div class="widget-block">
					<div class="widget-head">
                   
						<h5>List </h5>
						<div class="widget-control pull-right">
							<a href="../<?php echo $name_folder ?>/list.php" data-toggle="dropdown" class="btn dropdown-toggle"><i class="icon-cog"></i><b class="caret"></b></a>
							<ul class="dropdown-menu">
								<li><a href="add.php"><i class="icon-plus"></i> Add New</a></li>
                                <li><a href="edit_title.php"><i class="icon-plus"></i> แก้ไขหัวข้อ</a></li>
								<!--<li><a href="#"><i class="icon-ok"></i> Bulk Approved</a></li>
								<li><a href="#"><i class="icon-minus-sign"></i> Bulk Remove</a></li>-->
							</ul>
						</div>
					</div>
                     
					<div class="widget-content">
						<div class="widget-box">
                        
                       <?php
                            if($_SESSION['er']=='true')
							{
								?>
                                <div class="alert alert-success fade in">
                                <button data-dismiss="alert" class="close" type="button">×</button>
                                <strong>บันทึก</strong> เสร็จแล้วร้อยค่ะ
                                </div>
                                <?php
							}
							 if($_SESSION['er']=='de_true')
							{
								?>
                                <div class="alert alert-success fade in">
                                <button data-dismiss="alert" class="close" type="button">×</button>
                                <strong>ลบข้อมูล</strong> เสร็จแล้วร้อยค่ะ
                                </div>
                                <?php
							}
							if($_SESSION['er']=='false')
							{
								?>
                                <div class="alert alert-error fade in">
                                <button data-dismiss="alert" class="close" type="button">×</button>
                                <strong>ระบบขัดข้อง</strong> กรุณาทำรายการใหม่ค่ะขอบคุณค่ะ
                                </div>
                                <?php
							}
							
							?>
                        
							<table class="data-tbl-boxy table" style="font-size:12px;">
							<thead>
							<tr>
								<th width="7%">
									 ลำดับ
								</th>
								<th width="25%">
									 หัวข้อ
								</th>
                                <th width="15%">
									วันที่อัพเดท
								</th>
                                <th width="15%">
									link
								</th>
                                <th width="10%">
									จัดเรียง
								</th>
								<th width="10%">
									การจัดการ
								</th>
							</tr>
							</thead>
							<tbody>
                            <?php
							$secrch = " id > 1";
                            $list = array('table'=>$name_table,'where'=>$secrch,'order'=> "ORDER BY id DESC");				  
							$view = $view_db->view($list);
							$result = $view_db->q_re($view);
							
							
							$num=1;
							while($row = $view_db->q_ro($result))
							{
								?>
                                <tr>
                                    <td><?php echo $num; ?>. </td>
                                    <td>
									<?php
                                    if($row['image'] <> '')
									{
										?>
										<div style="">
											<img src="../../redbag/<?php echo $name_table; ?>/<?php echo $row['image']; ?>" width="100">
										</div>
										<?php	
									}
									?>
                                    <div><?php echo substr(strip_tags($row['detail']), 0, 80).'...'; ?>  </div>
                                    </td>
                                    <td><?php echo $util_class->day_m_th_re($row['up_date']) ?></td> 
                                    <td>
                                    <input type="text" value="https://onnud20.com/horo/daily/extradetail.php?id=<?php echo base64_encode($row['id']) ?>" id="url_<?php echo $row['id']?>">
                                    <button onclick="myFunction('<?php echo $row['id']?>')">Copy URL</button></td> 
                                    <td>
                                    <div id="img_loading_<?php echo $row['id']?>"></div>
                                    <input type="text" id="s_<?php echo $row['id']?>" name="s_<?php echo $row['id']?>" value="<?php echo $row['sort']?>" style="width:30px;" 
                                    onkeyup="sort_update(<?php echo $row['id']?>)"></td> 
                                    <td>
                                    <a href="edit.php?id=<?php echo $row['id']?>" title="แก้ไข<?php echo $row['id']; ?>"><i class="black-icons pencil"></i></a> &nbsp; 
                                    <a onClick="if(!confirm('ยืนยัน การลบข้อมูลแบบถาวร ?')){return false;}" href="delete.php?id=<?php echo $row['id']?>" title="ลบ<?php echo $row['id']; ?>"><i class="black-icons trashcan"></i></a>
                                    </td>
							</tr>
                                <?php
								$num++;
							}
							?>
							</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
    
    
  </div>
</div>
<script>
function sort_update(id)
{
	var x = document.getElementById("s_"+id);
    var x_text = x.value.toUpperCase();
	$("#img_loading_"+id).html('<img src="loading_spinner.gif" width="40"  class="img-fluid">');	
	 if (x_text == 0) 
	 {
		 // $("#img_loading").html('');	
		  return;
	 } else {
			var xmlhttp = new XMLHttpRequest();
			xmlhttp.onreadystatechange = function() {
				if (this.readyState == 4 && this.status == 200) {
					//document.getElementById("txtHint").innerHTML = this.responseText;
					$("#img_loading_"+id).html('');	
				}
			};
			xmlhttp.open("GET", "sort_update.php?id=" + id+'&s='+x_text, true);
			xmlhttp.send();
	}
	
	
	
	
}
function myFunction(id) {
  var copyText = document.getElementById("url_"+id);
  copyText.select();
  document.execCommand("Copy");
  alert("Copied the text: " + copyText.value);
}
</script>
<?php unset($_SESSION['er']);?>
<?php require_once("../include/footer_js.php");?>
</body>
</html>