<?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");?>
<?php include('../include/sql_injection_get.php');?>
<?php
if(!is_numeric($_GET["id"]))
{
	?>
	<meta http-equiv="refresh" content="0;URL=../index.php">
	<?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">Edit</li>
    </ul>
    
    
    
    
    <div class="row-fluid">
			<div class="span12">
				<div class="nonboxy-widget">
					<div class="widget-head">
						<h5><i class="black-icons blocks_images"></i> ข้อมูลการสั่งซื้อ  </h5>
					</div>
                    
					
                    <?php
                    $sql = array('table'=>$name_table,'where'=>"id = '". $_GET["id"]."'");
                    $view_sql = $view_db->view($sql);
                    $row = $view_db->q($view_sql);
                    ?>
                   
					<div class="widget-content">
						<div class="widget-box">
                        	<form class="form-horizontal well" id="signupform_product" action="edit_save.php" method="post" enctype="multipart/form-data">
								<fieldset>
									
									<div class="control-group">
										<label class="control-label">เลขทใบสั่งซื้อสั่งซื้อ :</label>
										<div class="controls">
											#<?php echo substr($row['id'],5,6);?>
										</div>
									</div>
									
                                     <div class="control-group">
										<label class="control-label">ชื่อผู้สั่งซื้อ :</label>
										<div class="controls">
											<?php echo $row['name'].' '.$row['lastname']; ?>
										</div>
									</div>
                                    
                                    <div class="control-group">
										<label class="control-label">E-mail :</label>
										<div class="controls">
											<?php echo $row['mail']; ?>
										</div>
									</div>
                                    
                                     <div class="control-group">
										<label class="control-label">วันที่สั่งซื้อ :</label>
										<div class="controls">
											<?php echo $util_class->day_m_th_re($row['date_time']) ?>
										</div>
									</div>
                                     <div class="control-group">
										<label class="control-label">วันที่แก้ไขข้อมูล :</label>
										<div class="controls">
											<?php echo $util_class->day_m_th_re($row['up_date']) ?>
										</div>
									</div>
                                    
                                    <div class="control-group">
										<label class="control-label">รุปการชำระเงิน :</label>
										<div class="controls">
											<select name="Pmid" class="span4">
                                            	<?php
                                                $list_pm = array('table'=>'payment_method','where'=>'status = 1','order'=> "ORDER BY id ASC");				  
												$view_pm = $view_db->view($list_pm);
												$result_pm = $view_db->q_re($view_pm);
												while($row_pm = $view_db->q_ro($result_pm))
												{
													?>
                                                     <option value="<?php echo $row_pm['id']?>" <?php if($row['id_pm']==$row_pm['id']){?>selected<?php }?>>
													 	<?php echo $row_pm['name']; ?>
                                                     </option>
                                                    <?php
												}
												?>
                                            </select>
										</div>
									</div>
                                    
                                    
                                     <div class="control-group">
										<label class="control-label">สถานะ :</label>
										<div class="controls">
											<select name="status" class="span4">
                                               <?php
                                                $list_os = array('table'=>'order_status','where'=>'status = 1','order'=> "ORDER BY id ASC");				  
												$view_os = $view_db->view($list_os);
												$result_os = $view_db->q_re($view_os);
												while($row_os = $view_db->q_ro($result_os))
												{
													?>
                                                     <option value="<?php echo $row_os['id']?>" <?php if($row['status']==$row_os['id']){?>selected<?php }?>><?php echo $row_os['detail']?></option>
                                                    <?php
												}
												?>
                                               
                                            </select>
											<br>
                                            <input type="checkbox" name="s_mail" value="1" checked> <span style="font-size:11px;">ยืนยันการส่งอีเมล์ พร้อมกลับเปลี่ยนสถานะ</span>
										</div>
									</div>
                                    <div class="control-group">
										<label class="control-label">รูปแบบการจัดส่งสินค้า :</label>
										<div class="controls">
											<?php
                                            $sql1 = array('table'=>'delivery	','where'=>"price	 = '". $row["delivery"]."'");
											$view_sql1 = $view_db->view($sql1);
											$row1 = $view_db->q($view_sql1);
											echo $row1['name'];
											?>
										</div>
									</div>
                                    
                                    <div class="control-group">
										<label class="control-label"> รูปแบบการจัดส่ง :</label>
										<div class="controls">
                                        <?php
											$list_sp = array('table'=>'shipping_type','where'=>'status = 1','order'=> "ORDER BY id ASC");				  
											$view_sp = $view_db->view($list_sp);
											$result_sp = $view_db->q_re($view_sp);
											$num=1;
											while($row_sp = $view_db->q_ro($result_sp))
											{
												?>
                                                <div class="radio">
                                                      <label>
                                                        <input type="radio" name="spt_id" id=""  value="<?php echo $row_sp['id']?>" <?php if($row['sp_type']==$row_sp['id']){?>checked<?php }?> >
                                                        <?php echo $row_sp['name']?>
                                                      </label>
                                                    </div>
                                                <?php
												$num++;
											}
										?>
										</div>
									</div>
                                    
                                    <div class="control-group">
										<label class="control-label">บาร์โค้ด (EMS และไปรษณีย์ลงทะเบียน) :</label>
										<div class="controls">
											<input id="deliverycode" name="deliverycode" type="text"  value="<?php echo $row['deliverycode']?>" class="span4"/>
										</div>
									</div>
                                    
								</fieldset>
								<div class="form-actions">
                                    <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                                    <input type="hidden" name="mail" value="<?php echo $row['mail']; ?>">
									<button class="btn btn-primary" type="submit">Save changes</button>
									<a href="list.php" class="btn" role="button">Cancel</a>
								</div>
							</form>
                           
                            
							</div>
						</div>
					</div>
				</div>
			</div>
			
	</div>
    
    
    
    
    
  </div>
</div>

<?php require_once("../include/footer_js.php");?>
</body>
</html>