<?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</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="#"><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="7%">
									 รหัสสินค้า
								</th>
								<th width="15%">
									 รูปภาพ
								</th>
								<th width="15%">
									 ref1
								</th>
								<th width="15%">
									 ref2
								</th>
                                <th width="12%">
									 วันที่ซื้อ
								</th>
                                <th width="12%">
									 สถานะ
								</th>
								<th width="10%">
									การจัดการ
								</th>
							</tr>
							</thead>
							<tbody>
                            <?php
							$secrch = "";
              $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))
							{
                $sql = array('table'=>'wallpapers','where'=>"id = '". $row["image"]."'");
                $view_sql = $view_db->view($sql);
                $row1 = $view_db->q($view_sql);
								?>
                                <tr>
                                    <td><?php echo $num; ?>. </td>
                                    <td><?php echo $row['id_order']; ?> </td>

                                    <td><img src="../../../redbag/<?php echo $name_folderimg; ?>/thumb/<?php echo ($row1['image_show']!='')?$row1['image_show']:$row1['image']; ?>" width="100" broder='0'></td>
                                    <td><?php echo $row['BillPayment_Reference1']; ?></td>
                                    <td><?php echo $row['BillPayment_Reference2']; ?></td>
                                    <td><?php echo $row['datetime']; ?></td>
                                    <td>
                                    	<?php
											if($row['status'] == 'success')
											{
												?> <a href="#" title="ชำระเงินสำเร็จ<?php echo $row['name_th']; ?>">
                                                <i class="dashboard-icons-colors check_sl"></i></a><?php
											}
											else
											{
												?> <a href="status.php?id=<?php echo $row['id']?>&s=success" title="ยังไม่ได้ชำระเงิน<?php echo $row['name_th']; ?>">
                                                <i class="dashboard-icons-colors busy_sl"></i></a><?php
											}
										?>
                                    </td>
                                    <td>
                                    <?php if($row['status'] == 'order'){ ?>
                                    <a href="test_success.php?TransactionID=<?php echo $row['id_order']?>&st=success" title="">successful payment</a> &nbsp;
                                    <?php } ?>
                                    <?php if($row['status'] == 'success'){ ?>
                                      <input type="text" name="copyText" id="copyText" value="https://kainumber.com/wallpaper/profile/wallpaper.php?ref1=<?php echo $row['BillPayment_Reference1']; ?>&ref2=<?php echo $row['BillPayment_Reference2']; ?>">
                                      <button type="button" name="button" onclick="copyText('copyText')">copy</button>
                                    <?php } ?>
                                    <!--<a href="edit.php?id=<?php echo $row['id']?>" title="แก้ไข<?php echo $row['name_th']; ?>"><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['name_th']; ?>"><i class="black-icons trashcan"></i></a>
                                  -->

                                    </td>
							</tr>
                                <?php
								$num++;
							}
							?>
							</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>


  </div>
</div>
<?php unset($_SESSION['er']);?>
<?php require_once("../include/footer_js.php");?>
<script>
  function copyText(id) {
    var copyText = document.getElementById(id);
    copyText.select();
    copyText.setSelectionRange(0, 99999);
    navigator.clipboard.writeText(copyText.value);
    alert("Copied Success!!");
  }
</script>
</body>
</html>