/home/globalproven/public_html/admin/user-profile.php
<?php
include('../library/raso_function.php');
check_admin();

$select_user = exeQuery("select * from customers where id='".$_GET['id']."' ");
$res_user = fetchAssoc($select_user);
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title><?=SITENAME;?> | User Profile</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta name="viewport" content="width=device-width, initial-scale=1">

  <!-- Font Awesome -->
  <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/adminlte.min.css">
  <!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
</head>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
  <!-- Navbar -->
  <?php include("include/header.php");?>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <?php include("include/sidebar.php");?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Profile</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active">User Profile</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <div class="col-md-3">

            <!-- Profile Image -->
            <div class="card card-primary card-outline">
              <div class="card-body box-profile">
                <div class="text-center">
                <?php echo ($res_user['image']!="" and file_exists("../upload/images/".$res_user['image']))?"<img  src='../upload/images/".$res_user['image']."' class='profile-user-img img-fluid img-circle' >":"<img class='profile-user-img img-fluid img-circle'
                       src='dist/img/user4-128x128.jpg'
                       alt='User profile picture'>";?>       
                </div>

                <h3 class="profile-username text-center"><?=ucfirst($res_user['username'])?></h3>

                <p class="text-muted text-center"><?=ucfirst($res_user['user'])?></p>

                <ul class="list-group list-group-unbordered mb-3">
                  <li class="list-group-item">
                    <b>C2C Coins</b> <a class="float-right">1,322</a>
                  </li>
                  <li class="list-group-item">
                    <b>C2C Redeem Points</b> <a class="float-right">1,322</a>
                  </li>
                  <li class="list-group-item">
                    <b>C2C Trophy</b> <a class="float-right">3</a>
                  </li>
                  <li class="list-group-item">
                    <b>C2C Badges</b> <a class="float-right">7</a>
                  </li>
                </ul>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->

            <!-- About Me Box -->
            <!--<div class="card card-primary">-->
            <!--  <div class="card-header">-->
            <!--    <h3 class="card-title">About Me</h3>-->
            <!--  </div>-->
              <!-- /.card-header -->
            <!--  <div class="card-body">-->
            <!--    <strong><i class="fas fa-book mr-1"></i> Education</strong>-->

            <!--    <p class="text-muted">-->
            <!--      B.S. in Computer Science from the University of Tennessee at Knoxville-->
            <!--    </p>-->

            <!--    <hr>-->

            <!--    <strong><i class="fas fa-map-marker-alt mr-1"></i> Location</strong>-->

            <!--    <p class="text-muted">Malibu, California</p>-->

            <!--    <hr>-->

            <!--    <strong><i class="fas fa-pencil-alt mr-1"></i> Skills</strong>-->

            <!--    <p class="text-muted">-->
            <!--      <span class="tag tag-danger">UI Design</span>-->
            <!--      <span class="tag tag-success">Coding</span>-->
            <!--      <span class="tag tag-info">Javascript</span>-->
            <!--      <span class="tag tag-warning">PHP</span>-->
            <!--      <span class="tag tag-primary">Node.js</span>-->
            <!--    </p>-->

            <!--    <hr>-->

            <!--    <strong><i class="far fa-file-alt mr-1"></i> Notes</strong>-->

            <!--    <p class="text-muted">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam fermentum enim neque.</p>-->
            <!--  </div>-->
              <!-- /.card-body -->
            <!--</div>-->
            <!-- /.card -->
          </div>
          <!-- /.col -->
          <div class="col-md-9">
            <div class="card">
              <div class="card-header p-2">
                <ul class="nav nav-pills">
                  <li class="nav-item"><a class="nav-link active" href="#Profile" data-toggle="tab">Profile</a></li>
                  <li class="nav-item"><a class="nav-link" href="#bank_details" data-toggle="tab">Bank Details</a></li>
                  <li class="nav-item"><a class="nav-link" href="#new_order" data-toggle="tab">New Orders</a></li>
                  <li class="nav-item"><a class="nav-link" href="#past_order" data-toggle="tab">Past Orders</a></li>
                </ul>
              </div><!-- /.card-header -->
              <div class="card-body">
                <div class="tab-content">
                  <div class="active tab-pane" id="Profile">
                    <form class="form-horizontal">
                      <div class="form-group row">
                        <label for="inputName" class="col-sm-2 col-form-label">Name</label>
                        <div class="col-sm-10">
                          <input type="email" class="form-control" id="inputName" placeholder="Name" value="<?=ucfirst($res_user['name'])?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputEmail" class="col-sm-2 col-form-label">Email</label>
                        <div class="col-sm-10">
                          <input type="email" class="form-control" id="inputEmail" placeholder="Email" value="<?=ucfirst($res_user['email'])?>" >
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputName2" class="col-sm-2 col-form-label">Username</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputName2" placeholder="Username" value="<?=$res_user['username']?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">Phone</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="Phone" value="<?=ucfirst($res_user['phone'])?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">Package</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="Package" value="<?=ucfirst($res_user['package'])?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">Address</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="Address" value="<?=ucfirst($res_user['address'])?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">Country</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="Country" value="<?=get_field_name($res_user['country_id'],"country_id","name","country")?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">State</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="State" value="<?=get_field_name($res_user['state_id'],"state_id","name","state")?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">City</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="City" value="<?=get_field_name($res_user['city_id'],"city_id","name","city")?>">
                        </div>
                      </div>
                      <div class="form-group row">
                        <label for="inputSkills" class="col-sm-2 col-form-label">Zipcode</label>
                        <div class="col-sm-10">
                          <input type="text" class="form-control" id="inputSkills" placeholder="Zipcode" value="<?=$res_user['zip_code']?>">
                        </div>
                      </div>
                    </form>
                  </div>
                  <div class="tab-pane" id="bank_details">
                          <form class="form-horizontal" method="POST" action="">
                            <div class="form-group row">
                              <label for="inputName" class="col-sm-2 col-form-label">Title</label>
                              <?php $type=  array("mr.","mrs.","miss","dr.","master","none");?>
                              <div class="col-sm-10">
                                <select class="form-control" id="inputName" name="type">
                                  <?php foreach($type as $val){?>
                                    <option value="<?=$val?>"><?=ucfirst($val)?></option>
                                    <?php
                                  }
                                  ?>
                                </select>
                              </div>
                            </div>
                            <div class="form-group row">
                              <label for="inputName" class="col-sm-2 col-form-label">Name on Bank</label>
                              <div class="col-sm-10">
                                <input type="text" name="name_on_bank" class="form-control" id="inputName" placeholder="Name on Bank" value="<?=ucfirst($res_user['name_on_bank'])?>">
                              </div>
                            </div>
                            <div class="form-group row">
                              <label for="inputName" class="col-sm-2 col-form-label">Bank Name</label>
                              <div class="col-sm-10">
                                <input type="text" name="bank_name" class="form-control" id="inputName" placeholder="Bank Name" value="<?=ucfirst($res_user['bank_name'])?>">
                              </div>
                            </div>
                            <div class="form-group row">
                              <label for="inputName" class="col-sm-2 col-form-label">Account Number</label>
                              <div class="col-sm-10">
                                <input type="text" name="account_number" class="form-control" id="inputName" placeholder="Account Number" value="<?=ucfirst($res_user['account_number'])?>">
                              </div>
                            </div>
                            <div class="form-group row">
                              <label for="inputName" class="col-sm-2 col-form-label">Routing Number</label>
                              <div class="col-sm-10">
                                <input type="text" name="routing_number" class="form-control" id="inputName" placeholder="Routing Number" value="<?=ucfirst($res_user['routing_number'])?>">
                              </div>
                            </div>
                            <div class="form-group row">
                             <label for="inputName" class="col-sm-2 col-form-label">Iban Number</label>
                             <div class="col-sm-10">
                              <input type="text" name="iban_number" class="form-control" id="inputName" placeholder="Iban Number" value="<?=ucfirst($res_user['iban_number'])?>">
                            </div>
                          </div>
                          <div class="form-group row">
                            <label for="inputSkills" class="col-sm-4 col-form-label"></label>
                            <div class="col-sm-4">
                              <button class="btn btn-success" name="update_bank" >Update Bank Details</button>
                              <label for="inputSkills" class="col-sm-4 col-form-label"></label>
                            </div>
                          </div>

                        </form>
                      </div>
                  <!-- /.tab-pane -->
                  <div class="tab-pane" id="new_order">
                                <div class="card">
              <div class="card-header">
                <h3 class="card-title">New Orders</h3>
              </div>
              <!-- /.card-header -->
              <div class="card-body p-0">
                <table class="table table-striped">
                  <thead>
                    <tr>
                     <th style="width: 10px">#</th>
                      <th>Transaction Id</th>
                      <th>Transaction Amount</th>
                      <th style="width: 40px">Transaction Date</th>
                      <th>Delivery Status</th>
                      <th>View</th>
                    </tr>
                  </thead>
                  <tbody>
                      <?php
                              $j=1;
                              $select_order = exeQuery("select *  from ".TABLE_ORDERS." where 1=1 and user_id='".$_GET['id']."' ");
 
                               while($res_order = fetchAssoc($select_order)){
                                ?>
                                <tr>
                                  <td><?=$j?>.</td>
                                  <td><?=$res_order['transaction_id'];?></td>
                                  <td>$<?=$res_order['paid_amound'];?></td>
                                  <td><?=$res_order['created_date']?></td>
                                  <td>Pending</td>
                                  <td><a href="order-detail.php?txn=<?=$res_order['transaction_id']?>"><button type="button" id="PopoverCustomT-1" class="btn btn-success btn-sm"><i class="fa fa-eye" title="View" style="font-size: 20px;"></i></button></a></td>
                                </tr>
                                <?php
                                $j++;
                              }
                              ?>
                  </tbody>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
                  </div>
                  <!-- /.tab-pane -->

                  <div class="tab-pane" id="past_order">
                                <div class="card">
              <div class="card-header">
                <h3 class="card-title">Past Orders</h3>
              </div>
              <!-- /.card-header -->
              <div class="card-body p-0">
                <table class="table table-striped">
                  <thead>
                    <tr>
                      <th style="width: 10px">#</th>
                      <th>Transaction Id</th>
                      <th>Transaction Amount</th>
                      <th style="width: 40px">Transaction Date</th>
                       <th>Delivery Status</th>
                       <th>View</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php
                              $j=1;
                              $select_order = exeQuery("select *  from ".TABLE_ORDERS." where 1=1 and user_id='".$_GET['id']."' ");
 
                               while($res_order = fetchAssoc($select_order)){
                                ?>
                                <tr>
                                  <td><?=$j?>.</td>
                                  <td><?=$res_order['transaction_id'];?></td>
                                  <td>$<?=$res_order['paid_amound'];?></td>
                                  <td><?=$res_order['created_date']?></td>
                                  <td>Delivered</td>
                                  <td><a href="order-detail.php?txn=<?=$res_order['transaction_id']?>"><button type="button" id="PopoverCustomT-1" class="btn btn-success btn-sm"><i class="fa fa-eye" title="View" style="font-size: 20px;"></i></button></a></td>
                                </tr>
                                <?php
                                $j++;
                              }
                              ?>
                  </tbody>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
                  </div>
                  <!-- /.tab-pane -->
                </div>
                <!-- /.tab-content -->
              </div><!-- /.card-body -->
            </div>
            <!-- /.nav-tabs-custom -->
          </div>
          <!-- /.col -->
        </div>
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->

<?php include("include/footer.php");?>
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
</body>
</html>