R E D

NAME	SIZE	PERMISSION
assets	[ DIR ]	drwxr-xr-x
barcode-generator	[ DIR ]	drwxr-xr-x
bower_components	[ DIR ]	drwxr-xr-x
chart-pie	[ DIR ]	drwxr-xr-x
class	[ DIR ]	drwxr-xr-x
dist	[ DIR ]	drwxr-xr-x
font-awesome	[ DIR ]	drwxr-xr-x
icon	[ DIR ]	drwxr-xr-x
img-banner	[ DIR ]	drwxr-xr-x
img-category	[ DIR ]	drwxr-xr-x
img-logo	[ DIR ]	drwxr-xr-x
img-product	[ DIR ]	drwxr-xr-x
img-product-item	[ DIR ]	drwxr-xr-x
img-slide	[ DIR ]	drwxr-xr-x
img-system	[ DIR ]	drwxr-xr-x
img-user	[ DIR ]	drwxr-xr-x
lightbox	[ DIR ]	drwxr-xr-x
modal	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
.htaccess	154 B	-rwxr-xr-x
addPerson.php	22.7 KB	-rwxr-xr-x
bank.php	9.45 KB	-rwxr-xr-x
banner.php	7.34 KB	-rwxr-xr-x
business.php	7.35 KB	-rwxr-xr-x
cancelOrder.php	7.5 KB	-rwxr-xr-x
category.php	11.4 KB	-rwxr-xr-x
check_login.php	424 B	-rwxr-xr-x
company - Copy.php	8.33 KB	-rwxr-xr-x
company.php	8.09 KB	-rwxr-xr-x
customer.php	10.31 KB	-rwxr-xr-x
footer.php	249 B	-rwxr-xr-x
header.php	2.57 KB	-rwxr-xr-x
import_script.php	4.11 KB	-rwxr-xr-x
import_style.php	1.66 KB	-rwxr-xr-x
index.php	1.36 KB	-rwxr-xr-x
levelPosition.php	7.58 KB	-rwxr-xr-x
lineToken.php	3.86 KB	-rwxr-xr-x
logout.php	77 B	-rwxr-xr-x
menu.php	2.5 KB	-rwxr-xr-x
menu_left.php	5.45 KB	-rwxr-xr-x
menu_left_home.php	513 B	-rwxr-xr-x
menu_main.php	88 B	-rwxr-xr-x
order.php	7.58 KB	-rwxr-xr-x
pagination.php	1.49 KB	-rwxr-xr-x
pagination_stock.php	1.51 KB	-rwxr-xr-x
payment.php	8.76 KB	-rwxr-xr-x
personData.php	21.22 KB	-rwxr-xr-x
product.php	15.56 KB	-rwxr-xr-x
report.php	11.58 KB	-rwxr-xr-x
reportSale.php	4.55 KB	-rwxr-xr-x
save_product.php	993 B	-rwxr-xr-x
select_amphures.php	621 B	-rwxr-xr-x
select_brand.php	668 B	-rwxr-xr-x
select_districts.php	537 B	-rwxr-xr-x
select_provinces.php	665 B	-rwxr-xr-x
slide.php	9.47 KB	-rwxr-xr-x
stockProduct.php	6.71 KB	-rwxr-xr-x
subbusiness.php	8 KB	-rwxr-xr-x
subcategory.php	8.44 KB	-rwxr-xr-x
type_user.php	549 B	-rwxr-xr-x
unit.php	7.12 KB	-rwxr-xr-x
uploadImage.php	9.53 KB	-rwxr-xr-x
userData.php	11.11 KB	-rwxr-xr-x
viewOrder.php	6.8 KB	-rwxr-xr-x

Code Editor : userData.php

<?php session_start();
	include('../config/connect.php');
	include('type_user.php');
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title><?php echo $title;?></title>
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <?php include('import_style.php');?>
  <link href="https://fonts.googleapis.com/css?family=Kanit:100,200,300&amp;subset=thai" rel="stylesheet">
</head>
<body class="hold-transition skin-blue sidebar-mini">
<?php include('check_login.php');?>
<div class="wrapper">

<?php include('header.php');?>
  
  <?php include('menu_left.php');?>

<div class="content-wrapper">
    
    
    <?php
    	include('menu_main.php');
	?>

<section class="content">
	
<div class="row">
		<div class="col-md-12">
        
          <div class="box">
            <div class="box-header bg-theme text-center">
              <h3 class="box-title">ข้อมูลผู้ใช้งานระบบ</h3>
            </div>
            
            <div class="box-body">
<?php include('modal/form-add-modal.php');?>
<button type="button" class="btn btn bg-blue btn-sm" data-toggle="modal" data-target="#addUser">
  <span class="fa fa-plus"></span> เพิ่มผู้ใช้งาน
</button>
<p></p>
              					<form method="post">
                                <table id="table1" width="100%" class="table table-hover">
                                	<thead>
                                    	<tr>
                                        	<th width="5%" class="text-center">ลำดับ</th>
                                        	<th width="15%">Username</th>
                                        	<th width="17%">ชื่อ - นามสกุล</th>
                                        	<th width="16%">เบอร์โทรศัพท์</th>
                                            <th width="10%">ระดับสิทธิ์การใช้งาน</th>
                                            <th width="10%">สถานะ</th>
                                            <th width="13%">วันที่ลงทะเบียน</th>
                                            <th width="14%" class="text-center">จัดการ</th>
                                        </tr>
                                    </thead>
                                    
                                    <tbody>
                                    <?php
										$user_status = "2";
										$stmt = $conn->prepare("SELECT u.*, l.level_name,
											CASE WHEN u.user_status = '1' THEN 'พร้อมใช้งาน'
												WHEN u.user_status = '0' THEN 'ปิดการใช้งาน'
												ELSE 'ลบข้อมูล'
												END AS user_status_name
											FROM tb_user AS u 
											INNER JOIN tb_user_level AS l ON u.level_id = l.level_id
											WHERE u.user_status <> :user_status
											ORDER BY u.user_id ASC");
										$stmt->bindParam(':user_status', $user_status , PDO::PARAM_STR);
										$stmt->execute();
										$result = $stmt->fetchAll();
										$i2 = 1;
										foreach($result as $row) {
									?>	
                                    	<tr>
                                        	<td align="center"><?php echo $i2;?></td>
                                        	<td><?php echo $row['user_name'];?></td>
                                            <td><?php echo $row['user_fullname'];?></td>
                                            <td><?php echo $row['user_tel'];?></td>
                                            <td>
                                            	<?php if($row['level_id'] == '1') { ?>			                
                                                <span class="label bg-blue"><?php echo $row['level_name'];?></span>
                                                <?php } else if($row['level_id'] == '2') { ?>	
                                                <span class="label bg-fuchsia"><?php echo $row['level_name'];?></span>
                                                 <?php } else if($row['level_id'] == '3') { ?>	
                                                <span class="label bg-yellow"><?php echo $row['level_name'];?></span>
                                                 <?php } else if($row['level_id'] == '4') { ?>	
                                                <span class="label bg-red"><?php echo $row['level_name'];?></span>
                                                <?php } else { ?> 
                                                <span class="label bg-green"><?php echo $row['level_name'];?></span>
                                                <?php } ?>
                                            </td>
                                             <td>
                                            	<?php if($row['user_status'] == '1') { ?>			                
                                                <span class="label bg-green"><?php echo $row['user_status_name'];?></span>
                                                <?php } else { ?> 
                                                <span class="label bg-red"><?php echo $row['user_status_name'];?></span>
                                                <?php } ?>
                                            </td>
											<td><?php echo date_format(date_create($row["user_save"]),"d/m/Y H:i:s");?></td>
											<td align="center">
                                            	<button type="button" class="btn btn-success btn-sm" data-toggle="modal" data-target="#editUser<?php echo $row['user_id'];?>"><span class="fa fa-edit"></span> แก้ไข</button>
                                                
                                                 <button type="button" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteUser<?php echo $row['user_id'];?>"><span class="fa fa-trash"></span> ลบ</button>
                                            </td>
                                         	    
                                            <?php include('modal/form-edit-modal.php'); ?>
                                            <?php include('modal/form-delete-modal.php'); ?>
                                        </tr>
                                                                                    
                                    <?php $i2++; } ?>
                                    </tbody>
                                </table>
          						</form>
<?php
	if(isset($_POST['btnEditUser'])){
		$user_id = $_POST['user_id'];
		$user_name = $_POST['user_name'];
		$user_fullname = $_POST['user_fullname'];
		$user_tel = $_POST['user_tel'];
		$level_id = $_POST['level_id'];
		
		if($_POST['user_password'] != '')
		{
			$user_password = md5($_POST['user_password']);
		}
		else
		{
			$user_password = $_POST['user_password2'];
		}
			
		$stmt = $conn->prepare("UPDATE tb_user SET user_name=:user_name, user_fullname=:user_fullname, user_tel=:user_tel, user_password=:user_password WHERE user_id=:user_id");
		$stmt->bindParam(':user_id', $user_id , PDO::PARAM_INT);
		$stmt->bindParam(':user_name', $user_name , PDO::PARAM_STR);	
		$stmt->bindParam(':user_fullname', $user_fullname , PDO::PARAM_STR);
		$stmt->bindParam(':user_tel', $user_tel , PDO::PARAM_STR);
		$stmt->bindParam(':user_password', $user_password , PDO::PARAM_STR);
		$result = $stmt->execute();
	
		if($result){			
			echo '
				<script>
					swal({
						title: "แก้ไขข้อมูลสำเร็จ", 
						icon: "success",
						button: "ตกลง",
						}).then( () => {
							location.href = "userData"
										
						});	
				</script>
			';	
			
		}
		else
		{
			echo '
				<script>
					swal({
						title: "Error เกิดข้อผิดพลาด", 
						icon: "error",
						button: "ตกลง",
						}).then( () => {
							location.href = "'.$_SERVER['REQUEST_URI'].'"
										
						});	
				</script>
			';	
		}
	}
?>

<?php
	if(isset($_POST['btnDeleteUser'])){
		$user_id = $_POST['user_id'];
		$user_status = "2";
		
		$stmt = $conn->prepare("UPDATE tb_user SET user_status=:user_status WHERE user_id=:user_id");
		$stmt->bindParam(':user_id', $user_id , PDO::PARAM_INT);
		$stmt->bindParam(':user_status', $user_status , PDO::PARAM_STR);	
		$result = $stmt->execute();
	
		if($result){			
			echo '
				<script>
					swal({
						title: "ลบข้อมูลสำเร็จ", 
						icon: "success",
						button: "ตกลง",
						}).then( () => {
							location.href = "userData"
										
						});	
				</script>
			';	
			
		}
		else
		{
			echo '
				<script>
					swal({
						title: "Error เกิดข้อผิดพลาด", 
						icon: "error",
						button: "ตกลง",
						}).then( () => {
							location.href = "'.$_SERVER['REQUEST_URI'].'"
										
						});	
				</script>
			';	
		}
	}
?>                                
<?php
	if(isset($_POST['btnAddUser'])){
		
		$user_name = $_POST['user_name'];
		$user_password = md5($_POST['user_password']);
		$user_fullname = $_POST['user_fullname'];
		$user_tel = $_POST['user_tel'];
		$user_status = "1";
		$level_id = $_POST['level_id'];
		$user_save = date('Y-m-d H:i:s');

$stmt = $conn->prepare("INSERT INTO tb_user(user_name, user_password, user_fullname, user_tel, user_status, user_save, level_id) 
		VALUES (:user_name, :user_password, :user_fullname, :user_tel, :user_status, :user_save, :level_id)");
		$stmt->bindParam(':user_name', $user_name , PDO::PARAM_STR);	
		$stmt->bindParam(':user_password', $user_password , PDO::PARAM_STR);	
		$stmt->bindParam(':user_fullname', $user_fullname , PDO::PARAM_STR);
		$stmt->bindParam(':user_tel', $user_tel , PDO::PARAM_STR);
		$stmt->bindParam(':user_status', $user_status , PDO::PARAM_STR);
		$stmt->bindParam(':level_id', $level_id , PDO::PARAM_STR);		
		$stmt->bindParam(':user_save', $user_save);	
    	$result = $stmt->execute();
		
		if($result){			
			echo '
				<script>
					swal({
						title: "บันทึกข้อมูลสำเร็จ", 
						icon: "success",
						button: "ตกลง",
						}).then( () => {
							location.href = "userData"
										
						});	
				</script>
			';	
			
		}
		else
		{
			echo '
				<script>
					swal({
						title: "Error เกิดข้อผิดพลาด", 
						icon: "error",
						button: "ตกลง",
						}).then( () => {
							location.href = "'.$_SERVER['REQUEST_URI'].'"
										
						});	
				</script>
			';	
		}
	}
?>                                   
                                
            </div>
            
          </div>
          
        </div>
        
</div>

</section>
    
  </div>

  
  <?php include('footer.php');?>

<?php include('import_script.php');?>
</body>
</html>
<?php
  $conn = null;
?>

${this.title}

Code Editor : userData.php