<?php
include('includes/header.php');
include('includes/navbar.php');
?>


<?php
if (isset($_POST['userupdatebtn'])) {
    $edit_id = $_POST['edit_id'];
    $full_name = $_POST['full_name'];
    $useremail = $_POST['useremail'];
    $bonus = $_POST['bonus'];
    $profit = $_POST['profit'];
    $btc_bal = $_POST['btc_bal'];
    $eth_bal = $_POST['eth_bal'];
    $ltc_bal = $_POST['ltc_bal'];
    $usdt_bal = $_POST['usdt_bal'];
    $country = $_POST['country'];
    $phone = $_POST['phone'];
    $address = $_POST['address'];
    $city = $_POST['city'];
    $zip = $_POST['zip'];
    $currency = $_POST['currency'];
    $userpassword = $_POST['userpassword'];
    $kyc = $_POST['kyc'];
    $status = $_POST['status'];
    
     $Withdrawal_Pin = $_POST['Withdrawal_Pin'];

    if (empty($full_name) || empty($useremail) || empty($currency) ||
     empty($userpassword) || empty($status)) {
      $error = "empty";
    }else {
      $sql_userupdate = "UPDATE users SET full_name  = '$full_name', email = '$useremail', bonus = '$bonus',
      profit = '$profit', btc = '$btc_bal', eth = '$eth_bal', ltc = '$ltc_bal', usdt = '$usdt_bal',
      country = '$country', phone  = '$phone', address = '$address', city = '$city', zip = '$zip',
      currency  = '$currency', password = '$userpassword', status = '$status', kyc_status = '$kyc', Withdrawal_Pin = '$Withdrawal_Pin' WHERE user_id = '$edit_id'";
      if ($connection->query($sql_userupdate)===TRUE) {
          $error = "user_update_success";
          }else {
            $error = "error";
          }
    }
}
 ?>

<div class="container-fluid">

    <!-- DataTales Example -->
    <div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">EDIT User Profile </h6>
        </div>
        <div class="card-body">
        <?php

            if(isset($_GET['edit_id']))
            {
                $id = $_GET['edit_id'];
                if(empty($id)) {
                  echo "<script>
                    window.location.href = 'users.php';
                  </script>";
                }else {
                $query = "SELECT * FROM users WHERE user_id = '$id'";
                $query_run = mysqli_query($connection, $query);

                foreach($query_run as $row)
                {
                    ?>

                        <form action="" method="POST">

                          <div class="form-group">
                              <label> User ID</label>
                              <input type="text" name="edit_id" value="<?php echo $row['user_id'] ?>" class="form-control" readonly>
                          </div>
                          
                            <div class="form-group">
                                <label> Withdrawal Pin </label>
                                <input type="text" name="Withdrawal_Pin" value="<?php echo $row['Withdrawal_Pin'] ?>" class="form-control">
                            </div>

                            <div class="form-group">
                                <label> Full Name </label>
                                <input type="text" name="full_name" value="<?php echo $row['full_name'] ?>" class="form-control">
                            </div>

                            <div class="form-group">
                                <label>Email</label>
                                <input type="email" name="useremail" value="<?php echo $row['email'] ?>" class="form-control">
                            </div>

                            <div class="form-group">
                                <label>Bonus (<?php echo $row['currency'] ?>)</label>
                                <input type="text" name="bonus" value="<?php echo $row['bonus'] ?>" class="form-control" onkeyup="this.value = this.value.replace (/^\.|[^\d\.]/g, '')" required>
                            </div>

                            <div class="form-group">
                                <label>Profit (<?php echo $row['currency'] ?>)</label>
                                <input type="text" name="profit" value="<?php echo $row['profit'] ?>" class="form-control" onkeyup="this.value = this.value.replace (/^\.|[^\d\.]/g, '')" required>
                            </div>

                            <div class="form-group">
                                <label>BTC Balance (<?php echo $row['currency'] ?>)</label>
                                <input type="text" name="btc_bal" value="<?php echo $row['btc'] ?>" class="form-control" onkeyup="this.value = this.value.replace (/^\.|[^\d\.]/g, '')" required>
                            </div>

                            <div class="form-group">
                                <label>ETH Balance (<?php echo $row['currency'] ?>)</label>
                                <input type="text" name="eth_bal" value="<?php echo $row['eth'] ?>" class="form-control" onkeyup="this.value = this.value.replace (/^\.|[^\d\.]/g, '')" required>
                            </div>

                            <div class="form-group">
                                <label>LTC Balance (<?php echo $row['currency'] ?>)</label>
                                <input type="text" name="ltc_bal" value="<?php echo $row['ltc'] ?>" class="form-control" onkeyup="this.value = this.value.replace (/^\.|[^\d\.]/g, '')" required>
                            </div>

                            <div class="form-group">
                                <label>USDT Balance (<?php echo $row['currency'] ?>)</label>
                                <input type="text" name="usdt_bal" value="<?php echo $row['usdt'] ?>" class="form-control" onkeyup="this.value = this.value.replace (/^\.|[^\d\.]/g, '')" required>
                            </div>

                            <div class="form-group">
                                <label>Country</label>
                                <select name="country" id="country" class="form-control">
                                  <option value="<?php echo $row['country'] ?>"><?php echo $row['country'] ?></option>
                                  <option value="Afganistan">Afghanistan</option>
                                  <option value="Albania">Albania</option>
                                  <option value="Algeria">Algeria</option>
                                  <option value="American Samoa">American Samoa</option>
                                  <option value="Andorra">Andorra</option>
                                  <option value="Angola">Angola</option>
                                  <option value="Anguilla">Anguilla</option>
                                  <option value="Antigua & Barbuda">Antigua & Barbuda</option>
                                  <option value="Argentina">Argentina</option>
                                  <option value="Armenia">Armenia</option>
                                  <option value="Aruba">Aruba</option>
                                  <option value="Australia">Australia</option>
                                  <option value="Austria">Austria</option>
                                  <option value="Azerbaijan">Azerbaijan</option>
                                  <option value="Bahamas">Bahamas</option>
                                  <option value="Bahrain">Bahrain</option>
                                  <option value="Bangladesh">Bangladesh</option>
                                  <option value="Barbados">Barbados</option>
                                  <option value="Belarus">Belarus</option>
                                  <option value="Belgium">Belgium</option>
                                  <option value="Belize">Belize</option>
                                  <option value="Benin">Benin</option>
                                  <option value="Bermuda">Bermuda</option>
                                  <option value="Bhutan">Bhutan</option>
                                  <option value="Bolivia">Bolivia</option>
                                  <option value="Bonaire">Bonaire</option>
                                  <option value="Bosnia & Herzegovina">Bosnia & Herzegovina</option>
                                  <option value="Botswana">Botswana</option>
                                  <option value="Brazil">Brazil</option>
                                  <option value="British Indian Ocean Ter">British Indian Ocean Ter</option>
                                  <option value="Brunei">Brunei</option>
                                  <option value="Bulgaria">Bulgaria</option>
                                  <option value="Burkina Faso">Burkina Faso</option>
                                  <option value="Burundi">Burundi</option>
                                  <option value="Cambodia">Cambodia</option>
                                  <option value="Cameroon">Cameroon</option>
                                  <option value="Canada">Canada</option>
                                  <option value="Canary Islands">Canary Islands</option>
                                  <option value="Cape Verde">Cape Verde</option>
                                  <option value="Cayman Islands">Cayman Islands</option>
                                  <option value="Central African Republic">Central African Republic</option>
                                  <option value="Chad">Chad</option>
                                  <option value="Channel Islands">Channel Islands</option>
                                  <option value="Chile">Chile</option>
                                  <option value="China">China</option>
                                  <option value="Christmas Island">Christmas Island</option>
                                  <option value="Cocos Island">Cocos Island</option>
                                  <option value="Colombia">Colombia</option>
                                  <option value="Comoros">Comoros</option>
                                  <option value="Congo">Congo</option>
                                  <option value="Cook Islands">Cook Islands</option>
                                  <option value="Costa Rica">Costa Rica</option>
                                  <option value="Cote DIvoire">Cote DIvoire</option>
                                  <option value="Croatia">Croatia</option>
                                  <option value="Cuba">Cuba</option>
                                  <option value="Curaco">Curacao</option>
                                  <option value="Cyprus">Cyprus</option>
                                  <option value="Czech Republic">Czech Republic</option>
                                  <option value="Denmark">Denmark</option>
                                  <option value="Djibouti">Djibouti</option>
                                  <option value="Dominica">Dominica</option>
                                  <option value="Dominican Republic">Dominican Republic</option>
                                  <option value="East Timor">East Timor</option>
                                  <option value="Ecuador">Ecuador</option>
                                  <option value="Egypt">Egypt</option>
                                  <option value="El Salvador">El Salvador</option>
                                  <option value="Equatorial Guinea">Equatorial Guinea</option>
                                  <option value="Eritrea">Eritrea</option>
                                  <option value="Estonia">Estonia</option>
                                  <option value="Ethiopia">Ethiopia</option>
                                  <option value="Falkland Islands">Falkland Islands</option>
                                  <option value="Faroe Islands">Faroe Islands</option>
                                  <option value="Fiji">Fiji</option>
                                  <option value="Finland">Finland</option>
                                  <option value="France">France</option>
                                  <option value="French Guiana">French Guiana</option>
                                  <option value="French Polynesia">French Polynesia</option>
                                  <option value="French Southern Ter">French Southern Ter</option>
                                  <option value="Gabon">Gabon</option>
                                  <option value="Gambia">Gambia</option>
                                  <option value="Georgia">Georgia</option>
                                  <option value="Germany">Germany</option>
                                  <option value="Ghana">Ghana</option>
                                  <option value="Gibraltar">Gibraltar</option>
                                  <option value="Great Britain">Great Britain</option>
                                  <option value="Greece">Greece</option>
                                  <option value="Greenland">Greenland</option>
                                  <option value="Grenada">Grenada</option>
                                  <option value="Guadeloupe">Guadeloupe</option>
                                  <option value="Guam">Guam</option>
                                  <option value="Guatemala">Guatemala</option>
                                  <option value="Guinea">Guinea</option>
                                  <option value="Guyana">Guyana</option>
                                  <option value="Haiti">Haiti</option>
                                  <option value="Hawaii">Hawaii</option>
                                  <option value="Honduras">Honduras</option>
                                  <option value="Hong Kong">Hong Kong</option>
                                  <option value="Hungary">Hungary</option>
                                  <option value="Iceland">Iceland</option>
                                  <option value="Indonesia">Indonesia</option>
                                  <option value="India">India</option>
                                  <option value="Iran">Iran</option>
                                  <option value="Iraq">Iraq</option>
                                  <option value="Ireland">Ireland</option>
                                  <option value="Isle of Man">Isle of Man</option>
                                  <option value="Israel">Israel</option>
                                  <option value="Italy">Italy</option>
                                  <option value="Jamaica">Jamaica</option>
                                  <option value="Japan">Japan</option>
                                  <option value="Jordan">Jordan</option>
                                  <option value="Kazakhstan">Kazakhstan</option>
                                  <option value="Kenya">Kenya</option>
                                  <option value="Kiribati">Kiribati</option>
                                  <option value="Korea North">Korea North</option>
                                  <option value="Korea Sout">Korea South</option>
                                  <option value="Kuwait">Kuwait</option>
                                  <option value="Kyrgyzstan">Kyrgyzstan</option>
                                  <option value="Laos">Laos</option>
                                  <option value="Latvia">Latvia</option>
                                  <option value="Lebanon">Lebanon</option>
                                  <option value="Lesotho">Lesotho</option>
                                  <option value="Liberia">Liberia</option>
                                  <option value="Libya">Libya</option>
                                  <option value="Liechtenstein">Liechtenstein</option>
                                  <option value="Lithuania">Lithuania</option>
                                  <option value="Luxembourg">Luxembourg</option>
                                  <option value="Macau">Macau</option>
                                  <option value="Macedonia">Macedonia</option>
                                  <option value="Madagascar">Madagascar</option>
                                  <option value="Malaysia">Malaysia</option>
                                  <option value="Malawi">Malawi</option>
                                  <option value="Maldives">Maldives</option>
                                  <option value="Mali">Mali</option>
                                  <option value="Malta">Malta</option>
                                  <option value="Marshall Islands">Marshall Islands</option>
                                  <option value="Martinique">Martinique</option>
                                  <option value="Mauritania">Mauritania</option>
                                  <option value="Mauritius">Mauritius</option>
                                  <option value="Mayotte">Mayotte</option>
                                  <option value="Mexico">Mexico</option>
                                  <option value="Midway Islands">Midway Islands</option>
                                  <option value="Moldova">Moldova</option>
                                  <option value="Monaco">Monaco</option>
                                  <option value="Mongolia">Mongolia</option>
                                  <option value="Montserrat">Montserrat</option>
                                  <option value="Morocco">Morocco</option>
                                  <option value="Mozambique">Mozambique</option>
                                  <option value="Myanmar">Myanmar</option>
                                  <option value="Nambia">Nambia</option>
                                  <option value="Nauru">Nauru</option>
                                  <option value="Nepal">Nepal</option>
                                  <option value="Netherland Antilles">Netherland Antilles</option>
                                  <option value="Netherlands">Netherlands (Holland, Europe)</option>
                                  <option value="Nevis">Nevis</option>
                                  <option value="New Caledonia">New Caledonia</option>
                                  <option value="New Zealand">New Zealand</option>
                                  <option value="Nicaragua">Nicaragua</option>
                                  <option value="Niger">Niger</option>
                                  <option value="Nigeria">Nigeria</option>
                                  <option value="Niue">Niue</option>
                                  <option value="Norfolk Island">Norfolk Island</option>
                                  <option value="Norway">Norway</option>
                                  <option value="Oman">Oman</option>
                                  <option value="Pakistan">Pakistan</option>
                                  <option value="Palau Island">Palau Island</option>
                                  <option value="Palestine">Palestine</option>
                                  <option value="Panama">Panama</option>
                                  <option value="Papua New Guinea">Papua New Guinea</option>
                                  <option value="Paraguay">Paraguay</option>
                                  <option value="Peru">Peru</option>
                                  <option value="Phillipines">Philippines</option>
                                  <option value="Pitcairn Island">Pitcairn Island</option>
                                  <option value="Poland">Poland</option>
                                  <option value="Portugal">Portugal</option>
                                  <option value="Puerto Rico">Puerto Rico</option>
                                  <option value="Qatar">Qatar</option>
                                  <option value="Republic of Montenegro">Republic of Montenegro</option>
                                  <option value="Republic of Serbia">Republic of Serbia</option>
                                  <option value="Reunion">Reunion</option>
                                  <option value="Romania">Romania</option>
                                  <option value="Russia">Russia</option>
                                  <option value="Rwanda">Rwanda</option>
                                  <option value="St Barthelemy">St Barthelemy</option>
                                  <option value="St Eustatius">St Eustatius</option>
                                  <option value="St Helena">St Helena</option>
                                  <option value="St Kitts-Nevis">St Kitts-Nevis</option>
                                  <option value="St Lucia">St Lucia</option>
                                  <option value="St Maarten">St Maarten</option>
                                  <option value="St Pierre & Miquelon">St Pierre & Miquelon</option>
                                  <option value="St Vincent & Grenadines">St Vincent & Grenadines</option>
                                  <option value="Saipan">Saipan</option>
                                  <option value="Samoa">Samoa</option>
                                  <option value="Samoa American">Samoa American</option>
                                  <option value="San Marino">San Marino</option>
                                  <option value="Sao Tome & Principe">Sao Tome & Principe</option>
                                  <option value="Saudi Arabia">Saudi Arabia</option>
                                  <option value="Senegal">Senegal</option>
                                  <option value="Seychelles">Seychelles</option>
                                  <option value="Sierra Leone">Sierra Leone</option>
                                  <option value="Singapore">Singapore</option>
                                  <option value="Slovakia">Slovakia</option>
                                  <option value="Slovenia">Slovenia</option>
                                  <option value="Solomon Islands">Solomon Islands</option>
                                  <option value="Somalia">Somalia</option>
                                  <option value="South Africa">South Africa</option>
                                  <option value="Spain">Spain</option>
                                  <option value="Sri Lanka">Sri Lanka</option>
                                  <option value="Sudan">Sudan</option>
                                  <option value="Suriname">Suriname</option>
                                  <option value="Swaziland">Swaziland</option>
                                  <option value="Sweden">Sweden</option>
                                  <option value="Switzerland">Switzerland</option>
                                  <option value="Syria">Syria</option>
                                  <option value="Tahiti">Tahiti</option>
                                  <option value="Taiwan">Taiwan</option>
                                  <option value="Tajikistan">Tajikistan</option>
                                  <option value="Tanzania">Tanzania</option>
                                  <option value="Thailand">Thailand</option>
                                  <option value="Togo">Togo</option>
                                  <option value="Tokelau">Tokelau</option>
                                  <option value="Tonga">Tonga</option>
                                  <option value="Trinidad & Tobago">Trinidad & Tobago</option>
                                  <option value="Tunisia">Tunisia</option>
                                  <option value="Turkey">Turkey</option>
                                  <option value="Turkmenistan">Turkmenistan</option>
                                  <option value="Turks & Caicos Is">Turks & Caicos Is</option>
                                  <option value="Tuvalu">Tuvalu</option>
                                  <option value="Uganda">Uganda</option>
                                  <option value="United Kingdom">United Kingdom</option>
                                  <option value="Ukraine">Ukraine</option>
                                  <option value="United Arab Erimates">United Arab Emirates</option>
                                  <option value="United States of America">United States of America</option>
                                  <option value="Uraguay">Uruguay</option>
                                  <option value="Uzbekistan">Uzbekistan</option>
                                  <option value="Vanuatu">Vanuatu</option>
                                  <option value="Vatican City State">Vatican City State</option>
                                  <option value="Venezuela">Venezuela</option>
                                  <option value="Vietnam">Vietnam</option>
                                  <option value="Virgin Islands (Brit)">Virgin Islands (Brit)</option>
                                  <option value="Virgin Islands (USA)">Virgin Islands (USA)</option>
                                  <option value="Wake Island">Wake Island</option>
                                  <option value="Wallis & Futana Is">Wallis & Futana Is</option>
                                  <option value="Yemen">Yemen</option>
                                  <option value="Zaire">Zaire</option>
                                  <option value="Zambia">Zambia</option>
                                  <option value="Zimbabwe">Zimbabwe</option>
                                </select>
                            </div>

                            <div class="form-group">
                                <label>Phone</label>
                                <input type="text" name="phone" value="<?php echo $row['phone'] ?>"
                                    class="form-control">
                            </div>

                            <div class="form-group">
                                <label>Address</label>
                                <input type="text" name="address" value="<?php echo $row['address'] ?>"
                                    class="form-control">
                            </div>

                            <div class="form-group">
                                <label>City</label>
                                <input type="text" name="city" value="<?php echo $row['city'] ?>"
                                    class="form-control">
                            </div>

                            <div class="form-group">
                                <label>Zip Code</label>
                                <input type="text" name="zip" value="<?php echo $row['zip'] ?>"
                                    class="form-control">
                            </div>

                            <div class="form-group">
                                <label>User Currency</label>
                                <select class="form-control" name="currency" style="text-transform:capitalize">
                                    <option value="<?php echo $row['currency'] ?>"><?php echo $row['currency'] ?></option>
                                    <option value="USD">USD</option>
                                    <option value="EUR">EUR</option>
                                    <option value="GBP">GBP</option>
                                    <option value="YEN">YEN</option>
                                    <option value="INR">INR</option>
                                </select>
                            </div>

                            <div class="form-group" style="display:none">
                                <label>Account Level</label>
                                <select class="form-control" name="acct_level" style="text-transform:capitalize">
                                  <?php
                                    $acct_level = $row['acct_level'];
                                    if ($acct_level == "") {
                                      $acct_level = "N/A";
                                    }
                                   ?>
                                    <option value="<?php echo $acct_level ?>"><?php echo $acct_level ?></option>
                                    <?php
                                      $upgrade_plan = "SELECT * FROM packages WHERE status = 'active'";
                                      $plan_result = $connection->query($upgrade_plan);
                                      while ($row1 = $plan_result->fetch_assoc()) {
                                        $plan_name = $row1['package_name'];
                                     ?>
                                     <option value="<?php echo $plan_name ?>"><?php echo $plan_name ?></option>
                                     <?php } ?>
                                </select>
                            </div>

                            <div class="form-group">
                                <label>Password</label>
                                <input type="text" name="userpassword" value="<?php echo $row['password'] ?>"
                                    class="form-control">
                            </div>

                            <div class="form-group">
                                <label>KYC Verification</label>
                                <?php
                                  $kyc = $row['kyc_status'];
                                  if ($kyc == 0) {
                                    $kyc_status = "Unverify";
                                  }elseif ($kyc == 1) {
                                    $kyc_status = "Pending Verification";
                                  }elseif ($kyc == 2) {
                                    $kyc_status = "Verified";
                                  }
                                 ?>
                                <select class="form-control" name="kyc" style="text-transform:capitalize">
                                    <option value="<?php echo $row['kyc_status'] ?>"><?php echo $kyc_status ?></option>
                                    <option value="0">Unverify</option>
                                    <option value="1">Pending Verification</option>
                                    <option value="2">Verified</option>
                                </select>
                            </div>

                            <div class="form-group">
                                <label>Account Status</label>
                                <select class="form-control" name="status" style="text-transform:capitalize">
                                    <option value="<?php echo $row['status'] ?>"><?php echo $row['status'] ?></option>
                                    <option value="active">Active</option>
                                    <option value="suspend">Suspend</option>
                                    <option value="inactive">Inactive</option>
                                </select>
                            </div>

                            <div class="form-group">
                                <label>Register Date</label>
                                <input type="text" name="" value="<?php echo $row['reg_date'] ?>" class="form-control" disabled>
                            </div>

                            <div class="form-group" style="position:relative; display:none">
                                <label>Refferal Link</label>
                                <input type="text" name="" value="<?php echo $website_url ?>/ref.php?<?php echo $row['username'] ?>" id="referral_code" class="form-control" disabled>
                                <span onclick="copyRef()" style="position:absolute; top:35px; right:10px; font-size:140%; color:blue; cursor:pointer"> <i class="fa-solid fa-copy"></i> </span>
                            </div>

                            <div class="form-group">
                                <label>User Profile</label> <br>
                                <a href="../images/<?php  echo $row['image']; ?>">
                                  <img src="../images/<?php  echo $row['image']; ?>" alt="" style="max-width:30%">
                                </a>
                            </div>

                            <a href="users.php" class="btn btn-danger"> CANCEL </a>
                            <button type="submit" name="userupdatebtn" class="btn btn-primary"> Update </button>

                        </form>
                        <?php
                }
              }
            }
        ?>

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

</div>

<p id="error" style='display: none'><?php echo $error?></p>
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<script>
    var error = document.getElementById('error');

    if (error.textContent == 'empty') {
         swal("ERROR!", "Input's cannot be empty!", "warning");
    }else if (error.textContent == "user_update_success") {
        swal("SUCCESS!", "User account Updated Successfully", "success");
        setTimeout(() => {
            window.location.href = 'users.php'
        }, 2000);
    }else if (error.textContent == "error") {
        swal("ERROR!", "Sorry an error occurred. Please try again later", "warning");
    }

</script>

<script>
    function copyRef() {
    var copyText = document.getElementById("referral_code");
    copyText.select();
    copyText.setSelectionRange(0, 99999);
    navigator.clipboard.writeText(copyText.value);
    swal("COPIED!", copyText.value, "success");
    }
</script>
<?php
include('includes/scripts.php');
include('includes/footer.php');
?>
