MAINHACK

Viewing / Editing File: customersss.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else{
$pageTitle1 = 'Customers';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$notificationType = "success";
$message = "";

// Add new //

if(isset($_POST['add'])){

$first_name = test_input($_POST['first_name']);
$last_name = test_input($_POST['last_name']);
$client_email = test_input($_POST['client_email']);
$phone_number = test_input($_POST['phone_number']);
$client_id = test_input($_POST['client_id']);
$gender = test_input($_POST['gender']);
$location = test_input($_POST['location']);
$address = test_input($_POST['address']);
$DOB = test_input($_POST['DOB']);
$anniversary = test_input($_POST['anniversary']);

$sele = mysqli_query($new,"SELECT * FROM clients WHERE client_email = '$email' AND business_name = '$shopname'");
$conrow = mysqli_fetch_array($sele);
$dbvendor = $conrow['email'];
$phone = $conrow['phone_number'];

if($phone === $phone_number) {
      $message = '<script> $(document).ready(function(){
    swal("warning!", "Customer already exist with this phone number", "warning");}); </script>';

}

if(!$message){

$date = date("Y-m-d");
$stmt = $con->prepare("insert into clients (first_name,last_name,phone_number,client_email,date,gender,DOB,anniversary,address,location,business_name) values (?,?,?,?,?,?,?,?,?,?,?)");
$stmt->execute(array($first_name,$last_name,$phone_number,$email,$date,$gender,$DOB,$anniversary,$address,$location,$shopname));

$message = '<script> $(document).ready(function(){
swal("Success", "New Customer added", "success");}); </script>';
  }

}

// Delete
if(isset($_POST['del'])){
$ID = test_input($_POST['SID']);
$stmt = $con->prepare("DELETE FROM clients WHERE client_id = ?");
$stmt->execute(array($SID));

$message = '<script> $(document).ready(function(){
swal("Success", "Customer deteted", "success");}); </script>';
}

// Update//
if(isset($_POST['update'])){

$stmt_update_service = $con->prepare("UPDATE clients SET first_name = ?, last_name = ?, phone_number = ?,client_email = ? ,gender = ?, DOB = ? , anniversary = ?, address = ?, location = ? WHERE client_id = ?");
$stmt_update_service->execute(array($first_name,$last_name,$phone_number,$client_email,$gender,$DOB,$anniversary,$address,$location,$client_id));

$message = '<script> $(document).ready(function(){
swal("Success", "Customer details updated", "success");}); </script>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title> <?php echo $shopname;?> - <?php echo $pageTitle1;?></title>

#loader {
display: block;
position: absolute;
top: 50%;
left: 50%;
border: 16px solid #f3f3f3;
border-top: 16px solid #3498db;
border-radius: 50%;
width: 70px;
height: 70px;
animation: spin 2s linear infinite;
}

@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}

td {
    width: 100px;
    height: 10px;

}
</style>

</head>

<div id="layout-wrapper">
<div class="header-border"></div>

<?php include("includes/template/head.php");?>
<?php include("includes/template/side.php");?>

<div class="row">
<div class="col-12">
<div class="page-title-box d-flex align-items-center justify-content-between">

<?php 
if($message != "") {
echo ($message) ;
}
?>
<h4 class="mb-0 font-size-18">All Customers</h4>

</div>
</div>
</div>

<?php 
  $sow = mysqli_query($new,"SELECT * FROM barber_admin WHERE business_name = '$shopname'");
  $userA = mysqli_fetch_array($sow);
  $userA_Master = $userA['master_account'];

$soww = mysqli_query($new,"SELECT *  FROM barber_admin WHERE master_account = '$userA_Master'");
  $userB = mysqli_fetch_array($soww);
  $count = mysqli_num_rows($soww);
  $account = $userB['account_status'];

// Role permission code //

$stmt = $con->prepare("SELECT account_type FROM  barber_admin WHERE username = ? and business_name = ?");
$stmt->execute(array($username,$shopname));
$userstatus = $stmt->fetchAll();

foreach($userstatus as $sta)
{
    $namee = $sta['account_type'];
}

$select_role = mysqli_query($new,"SELECT * FROM role_permissions  WHERE business_name = '$shopname' and type = '$namee' and page_name = 'Customers'");
$rowroles = mysqli_fetch_array($select_role);
$updaterecord = $rowroles['updaterecord'];
$deleterecord = $rowroles['deleterecord'];
$add_db = $rowroles['add'];
$type = $rowroles['type'];

if($account == 'Trial' and $count >= 2){?>

<?php } elseif($account == 'Essential' and $count <= 2){?>
<?php 
if($namee != "Admin"){?>
    <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>

<?php } elseif($namee == "Admin" and $add_db == '1' ) {?>
        <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
<?php } elseif ($namee == "Admin" and $add_db == '0'){?>
<button type="button" disabled class="btn btn-primary waves-effect waves-light">Add</button>
<?php }?>

<?php } elseif($account == 'Deluxe' and $count <= 5){?>

<?php 
if($namee != "Admin"){?>
    <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>

<?php } elseif($namee == "Admin" and $add_db == '1' ) {?>
        <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
<?php } elseif ($namee == "Admin" and $add_db == '0'){?>
<button type="button" disabled class="btn btn-primary waves-effect waves-light">Add</button>
<?php }?>
  <?php }elseif($account == 'Lifetime' and $count <= 10){?>
<?php 
if($namee != "Admin"){?>
    <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>

<?php } elseif($namee == "Admin" and $add_db == '1' ) {?>
        <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
<?php } elseif ($namee == "Admin" and $add_db == '0'){?>
<button type="button" disabled class="btn btn-primary waves-effect waves-light">Add</button>
<?php }?>

<?php }?>
             <br   /><br   />
    <div class="table-responsive">           
 <table id="basic-datatable" class="table table-hover table-striped table-bordered">
    <thead style="background-color:#428bca;border:#428bca;">
    <tr style="color: #ffffff;">
    <th width="10">ID</th>
    <th>Name</th>
    <th>Email </th>
    <th>Info</th>
    <th>Action</th>
    </tr>
</thead>
 <tbody>
<?php
$cont = 1;
$stmt = $con->prepare("SELECT * FROM clients WHERE business_name = ?  ORDER BY client_id DESC");
$stmt->execute(array($shopname));
$rows_services = $stmt->fetchAll();
?>
                    <tr>
                        <?php 
                        foreach($rows_services as $service){
                        ?>
                        <td><?php echo $cont++;?></td>
                        <td class="py-0 px-1"><?php echo $service['first_name'].' , '.$service['last_name'] ?>
                    <?php if($service['gender'] == "male"): ?>
                        <span class="fa fa-mars mx-1 text-primary opacity-50" data-toggle="tooltip" title="Male"></span>
                    <?php else: ?>
                        <span class="fa fa-venus mx-1 text-danger opacity-50" data-toggle="tooltip" title="Female"></span>
                    <?php endif; ?>
                    </td>
                    <td><?php if(empty($service['client_email'])){
                         echo 'N/A';
                        } else {
                            echo $service['client_email'];
                        };?></td>

<td class="py-0 px-1">
                        <small>DoB: <?php echo date("M d, Y",strtotime($service['DOB'])) ?></small><br>
                        <small>Contact: <?php echo $service['phone_number'] ?></small><br/>
                    </td>
                        <td>

<?php  $edit_data = "edit_".$service["client_id"];?>
                <?php  $delete_data = "delete_".$service["client_id"];?>

<?php 
        if($namee != "Admin"){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Edit">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
        </li>
        
        <?php } elseif($namee == "Admin" and $updaterecord == '1' ) {?>
        <li class="list-inline-item" data-toggle="tooltip" title="Edit">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
        </li>

<?php } elseif ($namee == "Admin" and $updaterecord == '0'){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Locked">
        <a class="disabled" data-placement="top"><i class="fa fa-edit"></i></a>
        </li>

<?php }?>

<?php 
        if($namee != "Admin"){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Delete">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>

<?php } elseif($namee == "Admin" and $deleterecord == '1' ) {?>
        <li class="list-inline-item" data-toggle="tooltip" title="Delete">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>

<?php } elseif ($namee == "Admin" and $deleterecord == '0'){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Locked">
        <a class="disabled" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>
        <?php }?>

<div class="modal fade" id="<?php echo $delete_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $delete_data; ?>" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Delete Customer</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body">
<form method="POST">
Are you sure you want to delete this Customer?
</div>
<input type="hidden" name="SID" value="<?php echo $service['client_id']; ?>">
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>

<button type="submit" name="del" class="btn btn-success">Delete</button>
</form>
</div>
</div>
</div>
</div>

<div class="modal fade bd-example-modal-lg12" id="<?php echo $edit_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $edit_data; ?>" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title h4" id="myLargeModalLabel">Edit Customer</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body" data-ng-form="newcustomer">
<div class="setting-steps">
<form method="post" accept-charset="utf-8">
    <div class="row">
         <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Phone number</label>
                <input type="text" class="form-control" id="validationTooltip03" name="phone_number" value="<?php echo $service["phone_number"]; ?>">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">First Name<span class="req">*</span></label>
                <input type="text" class="form-control" id="customerName" name="first_name" value="<?php echo $service["first_name"]; ?>" >
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Last Name</label>
                <input type="text" class="form-control" id="lastName" name="last_name" value="<?php echo $service["last_name"]; ?>">
            </div>
        </div>
    </div>
    <div class="row">
      <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">DOB</label>
                <div class="input-group date dobWrap cal-container">
         <input type="date" class="form-control" name="DOB" data-provide="datepicker" data-date-format="d-M" value="<?php echo $service["DOB"]; ?>">
                    
            </div>
        </div>
        </div> 
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInput" class="form-label">Email ID</label>
          <input type="email" class="form-control" id="email" name="client_email" value="<?php echo $service["client_email"]; ?>">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Gender</label>
                <div class="inline-radio tbl">
                    <div class="radio">
                        <input type="radio" id="male" name="gender" value="male" value="<?php echo $service["gender"]; ?>">
                        <label for="male">Male</label>
                    </div>
                    <div class="radio">
                        <input type="radio" id="female" name="gender" value="female" value="<?php echo $service["gender"]; ?>">
                        <label for="female">Female</label>
                    </div>
                </div>
            </div>
        </div>                
    </div>
    <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Address</label>
                <input type="text" class="form-control" name="address" value="<?php echo $service["address"]; ?>"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Anniversary</label>
                <div class="input-group date anniWrap cal-container">

</div>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Location</label>
                <input type="text" class="form-control" id="location" name="location" value="<?php echo $service["location"]; ?>">
                
            </div>
        </div>
    </div>

</div>
</div>
</div>
</div>
</div>

</li>
</ul>
</td>
                    </tr>
                <?php  };?>
                </tbody>
            </table>
</div>

</div>

</div> 
</div>

</div>

</div> 
</div>

<?php include("includes/template/newfooter.php");?>
</div>

</div>

<div class="menu-overlay"></div>

<?php //include("includes/modals/CustomersModal.php");?>

<div class="modal fade bd-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title h4" id="myLargeModalLabel">Add New Customer</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body" data-ng-form="newcustomer">
<div class="setting-steps">
<form id="add_category_bttn" method="POST">
    <div class="row">
         <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Phone number</label>
                <input type="text" class="form-control" id="validationTooltip03" name="phone_number" required>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">First Name<span class="req">*</span></label>
                <input type="text" class="form-control" id="customerName" name="first_name" required >
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Last Name</label>
                <input type="text" class="form-control" id="lastName" name="last_name" required>
            </div>
        </div>
    </div>
    <div class="row">
      <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">DOB</label>
                <div class="input-group date dobWrap cal-container">
         <input type="date" class="form-control" name="DOB" data-provide="datepicker" data-date-format="d-M">
                    
            </div>
        </div>
        </div> 
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInput" class="form-label">Email ID</label>
          <input type="email" class="form-control" id="email" name="email">
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Gender</label>
                <div class="inline-radio tbl">
                    <div class="radio">
                        <input type="radio" id="male" name="gender" value="male">
                        <label for="male">Male</label>
                    </div>
                    <div class="radio">
                        <input type="radio" id="female" name="gender" value="female">
                        <label for="female">Female</label>
                    </div>
                </div>
            </div>
        </div>                
    </div>
    <div class="row">
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Address</label>
                <input type="text" class="form-control" name="address"> 
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label class="form-label">Anniversary</label>
                <div class="input-group date anniWrap cal-container">

<input type="date" class="form-control" name="anniversary" data-provide="datepicker" data-date-format="d-M">                                
                    
                </div>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="form-group">
                <label for="exampleInputEmail1" class="form-label">Location</label>
                <input type="text" class="form-control" id="location" name="location">
                
            </div>
        </div>
    </div>

<button type="submit" name="add" class="btn btn-success">Submit</button>
</form>

</div>
</div>
</div>
</div>
</div>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: customersss.php

Server Info

System Features

User Info