<?php
require_once 'header.php';
require_once 'navbar.php';

if($_SERVER["REQUEST_METHOD"] == "POST")
{
 if(isset($_POST['request']))
 {
    $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))
   {
       $success=true;
   }
   else
   {
       $sql1= $conn->error;
       $error=true;
   }
}
else
	{	//echo "here";
$error=true;
}
}

		 //add money on customer
if(isset($_POST['user_id']) && isset($_POST['amount']))
{	
   $user_id=$_POST['user_id'];

   $amount=$_POST['amount'];
   $remark=$_POST['remark'];

   if(isset($_POST['add']))
   {
     $sql="update users set amount=amount+$amount where id=$user_id";
     $type="credit";
 }
 else if(isset($_POST['remove']))
 {
    $type="debit";
    $sql="update users set amount=amount-$amount where id=$user_id";
}

if($conn->query($sql)===true)
{
    $sql="Insert into transaction(id_user_app,amount,transaction_type,remark) values($user_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 INNER JOIN vendor_login ON vendor_login.contact=users.contact";
$res=$conn->query($sql);
if($res->num_rows > 0)
{
    while($row=$res->fetch_assoc())
    {
        $users[]=$row;
    }
}
?>
<style>
    .dataTables_filter{
        float: right;
    }
</style>
<!-- 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 table-bordered card-table table-vcenter text-nowrap  align-items-center">
                        <thead class="">
                            <tr>
                                <th style="width: 80px">S.NO</th>
                                <th>View</th>
                                <th>Name</th>
                                <th>Email</th>
                                <th>Contact</th>
                                <th>Alt Contact</th>
                                <th>Referal</th>
                                <th>Referal By</th>
                                <th>Wallet Money</th>
                                <th style="width: 180px"> &nbsp;&nbsp;&nbsp;&nbsp;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" class="btn btn-primary text-white btn-sm">View User</a>
                                    <a href="view-vendor?vendor_id=<?=$user['id']?>" target="_blank" class="btn btn-primary text-white btn-sm">View Vendor</a>
                                </td>
                                <td><?=$user['name'];?></td>
                                <td><?=$user['email'];?></td>
                                <td><?=$user['contact'];?></td>
                                <td><?=$user['alt_contact'];?></td>
                                <td><?=$user['referal'];?></td>
                                <td><?php
                                if ($user['referal_by']!='') {

                                    $query = "SELECT * FROM users WHERE referal = '".$user['referal_by']."'";
                                    $val=$conn->query($query);
                                    if($val->num_rows > 0)
                                    {
                                       $row = mysql_fetch_array($query);
                                       echo $row['name'];
                                   }else{
                                    echo "";
                                }
                            }
                            ?>
                            
                        </td>
                        <td><?=$user['amount'];?></td>
                        <td>
                            <button value="<?=$user['id'];?>" id="<?=$user['contact'];?>" onclick="add_money(this.value,this.id)" class="btn btn-primary" data-toggle="modal" data-target="#money">
                                Money
                            </button>
                            <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">&times;</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 Vendor 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">&times;</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>


<!--Add Modal To Wallet Money-->
<div class="modal fade" id="money">
    <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">&times;</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">Add/Remove Wallet Money.</h4><div class="col-md-6 float-right" id="alert"></div>
      </div> 
      <form method="post" >
          <div class="modal-body">
              <div class="row">
                 <div class="col-md-6">
                  <label>Please Enter Amount :</label><input type="text" class="form-control" name="amount" required>
                  <input type="hidden" class="form-control" id="user_id" name="user_id" required>
                  <input type="hidden" class="form-control" id="con" name="con" required>
              </div>
              <div class="col-md-6">
                  <label>Remark :</label><input type="text" class="form-control" name="remark" required>

              </div>
          </div>
      </div>
      <div class="modal-footer">
        <button type="submit" name="add" value="add" class="btn btn-primary" >Add</button>
        <button type="submit" name="remove" id="remove" class="btn btn-primary" >Remove</button>
    </div>
</form>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<!-- Adon JS -->
<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") {
                var markup = "<tr><td>"+max+"</td><td>"+obj.name+"</td><td>"+obj.email+"</td><td>"+obj.contact+"</td><td>"+obj.alt_contact+"</td><td><a class='btn btn-success' href='edit_vendor?token=${data.id}' value="+obj.id+"><i class='fa fa-edit btn-success'></i></a></td></tr>";
                $("table tbody").append(markup);
                $('#success').show();
                $('#modal-default').modal('toggle');
                
            }
            else {
                $('#error').html(obj.msg);
                $('#error').show();
            }
        }
    })
      $('#add_vendor').trigger("reset");
  });
    
});



 function add_money(str,contact)
 {
    document.getElementById('user_id').value=str;
    document.getElementById('con').value=contact;
}	

// 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(){ 
                   $('#alert2').hide()
               }, 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)
           }
           output();
       },
   })
  }
}  

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