MAINHACK

Viewing / Editing File: commission-rate.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 = 'Commssion Rate';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$notificationType = "success";

if(isset($_POST['submit'])){
 $rate = test_input($_POST['rate']);
 $date = test_input($_POST['date']);

$active = '0';

if(!empty($rate)){
$stmt = $con->prepare("insert into comm_rate (rate,date,business_name,active) values (?,?,?,?)");
$stmt->execute(array($rate,$date,$shopname,$active));
}
}

if(isset($_POST['del'])){
$SID  = test_input($_POST['SID']);
$stmt = $con->prepare("DELETE FROM comm_rate WHERE rate_id = ?");
$stmt->execute(array($SID)); 
header("Location: commission-rate");
}

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

$rate = test_input($_POST['rate']);
$active = test_input($_POST['active']);
$rate_id = test_input($_POST['rate_id']);

$stmt_update_service = $con->prepare("UPDATE comm_rate SET rate = ?, active = ?  WHERE rate_id = ?");
$stmt_update_service->execute(array($rate,$active,$rate_id));
$responses = "<h5 class='btn btn-success'>Employee updated successfuly</h5>";
}
}
?>
<!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); }
}
</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">
<h4 class="mb-0 font-size-18">Commission Rate</h4>

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

<?php 
$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 = 'Commission'");
$rowroles = mysqli_fetch_array($select_role);
$updaterecord = $rowroles['updaterecord'];
$deleterecord = $rowroles['deleterecord'];
$add_db = $rowroles['add'];
$type = $rowroles['type'];
?>
<?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 }?>

<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>ID</th>
<th>Commission Rate</th>
<th>Added date</th>
<th>Status</th>
<th>Action</th>
    </tr>
</thead>
 <tbody>
 <?php
                    $cont = 1;
$stmt = $con->prepare("SELECT * FROM comm_rate WHERE business_name = ?  ORDER BY rate_id DESC");
$stmt->execute(array($shopname));
$rows_services = $stmt->fetchAll();
              ?>
                    <tr>
                        <?php 
                        foreach($rows_services as $service){
                        ?>
                        <td><?php echo $cont++;?></td>
                        <td><?php echo $service['rate'].' %';?></td>
                        <td><?php echo $service['date'];?></td>
                        <td><?php if($service['active'] == 1) {
                             echo "<p style=color:green>Active</p>";
                        } else {
                            echo "<p style=color:red>Inactive</p>";
                        };?></td>

<td>

<?php  $edit_data = "edit_".$service["rate_id"];?>
                <?php  $delete_data = "delete_".$service["rate_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 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 Commission</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
        <div id="response"></div>
</div>

<div class="modal-body">
<form method="post" accept-charset="utf-8">
       <div class="row">
            <div class="form-group col-md-6">
                <label>Rate</label>
                <input type="number" name="rate" value="<?php echo $service["rate"]; ?>"  class="form-control" style="height:40px">
            </div>
            <input type="hidden" name="rate_id" value="<?php echo $service["rate_id"]; ?>">

<div class="form-group col-md-6">
                <label style="color:red">Status(Set 1 to activate or set 0 to deactivate)</label>
                <input type="number" name="active" value="<?php echo $service["active"]; ?>"  class="form-control" style="height:40px">
            </div>
            <br  />

<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 Commission</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 Commission?
</div>
<input type="hidden" name="SID" value="<?php echo $service['rate_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>

</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>

<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 rate</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>

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

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: commission-rate.php

Server Info

System Features

User Info