PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u403625155/domains/marivamarketsllc.com/public_html/admin/user-trades.php

<?php
require "header.php";
if(!isset($_GET['id'])){
    header("Location: manage-trades");
}
else{
    $user_id=$_GET['id'];
}

 
$tickers = [
    // Stocks
    'AAPL' => 'Apple Inc.',
    'MSFT' => 'Microsoft Corporation',
    'GOOGL' => 'Alphabet Inc. (Google)',
    'AMZN' => 'Amazon.com Inc.',
    'TSLA' => 'Tesla Inc.',
    'BRK.A' => 'Berkshire Hathaway Inc.',
    'NVDA' => 'NVIDIA Corporation',
    'META' => 'Meta Platforms Inc. (Facebook)',
    'V' => 'Visa Inc.',
    'JNJ' => 'Johnson & Johnson',
    'JPM' => 'JPMorgan Chase & Co.',
    'XOM' => 'Exxon Mobil Corporation',
    'NFLX' => 'Netflix Inc.',
    'DIS' => 'The Walt Disney Company',
    'NKE' => 'Nike Inc.',
    'WMT' => 'Walmart Inc.',
    'PFE' => 'Pfizer Inc.',
    'KO' => 'The Coca-Cola Company',
    'PEP' => 'PepsiCo Inc.',
    'T' => 'AT&T Inc.',
    'BABA' => 'Alibaba Group Holding Ltd.',
    'CSCO' => 'Cisco Systems Inc.',
    'INTC' => 'Intel Corporation',
    'CRM' => 'Salesforce.com Inc.',
    'AMD' => 'Advanced Micro Devices Inc.',

    // ETFs and Indexes
    'SPY' => 'SPDR S&P 500 ETF',
    'VOO' => 'Vanguard S&P 500 ETF',
    'QQQ' => 'Invesco QQQ Trust',
    'ARKK' => 'ARK Innovation ETF',
    'BND' => 'Vanguard Total Bond Market ETF',
    'SPX' => 'S&P 500 Index',

    // Forex Pairs
    'EURUSD' => 'Euro/US Dollar',
    'GBPUSD' => 'British Pound/US Dollar',
    'USDJPY' => 'US Dollar/Japanese Yen',
    'AUDUSD' => 'Australian Dollar/US Dollar',
    'USDCAD' => 'US Dollar/Canadian Dollar',
    'USDCHF' => 'US Dollar/Swiss Franc',
    'NZDUSD' => 'New Zealand Dollar/US Dollar',
    'EURGBP' => 'Euro/British Pound',
    'EURJPY' => 'Euro/Japanese Yen',
    'GBPJPY' => 'British Pound/Japanese Yen',

    // Cryptocurrencies
    'BTC-USD' => 'Bitcoin',
    'ETH-USD' => 'Ethereum',
    'LTC-USD' => 'Litecoin',
    'XRP-USD' => 'Ripple (XRP)',
    'ADA-USD' => 'Cardano',
    'DOT-USD' => 'Polkadot',
    'SOL-USD' => 'Solana',
    'DOGE-USD' => 'Dogecoin',
    'BNB-USD' => 'Binance Coin',
    'AVAX-USD' => 'Avalanche',
    'MATIC-USD' => 'Polygon',
    'SHIB-USD' => 'Shiba Inu',
];




?>

        <!-- Content Wrapper -->
        <div id="content-wrapper" class="d-flex flex-column">

            <!-- Main Content -->
            <div id="content">

                <!-- Topbar -->
                <nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow">
                 
                    <!-- Sidebar Toggle (Topbar) -->
                    <button id="sidebarToggleTop" class="btn btn-link d-md-none rounded-circle mr-3">
                        <i class="fa fa-bars"></i>
                    </button>

                    <!-- Topbar Search -->
                    

                    <!-- Topbar Navbar -->
                    <ul class="navbar-nav ml-auto">

                        <!-- Nav Item - Search Dropdown (Visible Only XS) -->
                        
                        <!-- Nav Item - Alerts -->
                        

                        <!-- Nav Item - Messages -->
                        
                        <div class="topbar-divider d-none d-sm-block"></div>

                        <!-- Nav Item - User Information -->
                        <li class="nav-item dropdown no-arrow">
                            <a class="nav-link dropdown-toggle" href="#" id="userDropdown" role="button"
                                data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                <span class="mr-2 d-none d-lg-inline text-gray-600 small"><?php echo $admin_name ;?></span>
                                <img class="img-profile rounded-circle"
                                    src="img/undraw_profile.svg">
                            </a>
                            <!-- Dropdown - User Information -->
                            <div class="dropdown-menu dropdown-menu-right shadow animated--grow-in"
                                aria-labelledby="userDropdown">
                                
                                <div class="dropdown-divider"></div>
                                <a class="dropdown-item" href="#" data-toggle="modal" data-target="#logoutModal">
                                    <i class="fas fa-sign-out-alt fa-sm fa-fw mr-2 text-gray-400"></i>
                                    Logout
                                </a>
                            </div>
                        </li>

                    </ul>

                </nav>
                <!-- End of Topbar -->

                <!-- Begin Page Content -->
                <div class="container-fluid">

                    <!-- Page Heading -->
                    <h1 class="h3 mb-2 text-gray-800">Trades</h1>
                    
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Data Tables </h6>
                            <button class="btn btn-primary float-right" data-toggle="modal" data-target="#create-trade">
                                Create Trade
                            </button>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table" id="dataTable" width="100%" cellspacing="0">
                                    
                                    <thead>
                                    <tr>
                                            <th>ID</th>
                                            <th>Ticker</th>
                                            <th>Amount</th>
                                            <th>Status</th>
                                            <th>Date</th>
                                            <th>Edit</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                           <th>ID</th>
                                            <th>Ticker</th>
                                            <th>Amount</th>
                                            <th>Status</th>
                                            <th>Date</th>
                                            <th>Edit</th>
                                            <th>Delete</th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
                                      <?php
                                        $get_trades = mysqli_query($conn, "SELECT * FROM user_trades WHERE user_id='$user_id' ORDER BY id DESC" );
                                        if(mysqli_num_rows($get_trades)>0){
                                            while($trade = mysqli_fetch_assoc($get_trades)){
                                                $id=$trade['id'];
                                                $ticker=$trade['ticker'];
                                                $amount=$trade['amount'];
                                                $status=$trade['status'];
                                                $date=$trade['date'];
                                                ?>
                                                <tr>
                                                    <td>
                                                        <?php echo $id; ?>
                                                    </td>
                                                    <td>
                                                        <?php echo $ticker; ?>
                                                    </td>
                                                    <td>
                                                        <?php echo $amount; ?>
                                                    </td>
                                                    <td>
                                                        <?php echo $status; ?>
                                                    </td>
                                                    <td>
                                                        <?php echo $date; ?>
                                                    </td>
                                                    <td>
                                                        <button class="btn btn-primary" data-toggle="modal" data-target="#edit-trade-<?php echo $id; ?>"><i class="fas fa-user-edit"></i></button>
                                                    </td>
                                                    <td>
                                                        <button class="btn btn-danger" onclick="deleteTrade(<?php echo $id; ?>)"><i class="fas fa-trash"></i></button>
                                                    </td>
                                                    
                                                </tr>
                                                <?php
                                            }
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                </div>
                <!-- /.container-fluid -->

            </div>
            <!-- End of Main Content -->

            <!-- Footer -->
            <footer class="sticky-footer bg-white">
                <div class="container my-auto">
                    <div class="copyright text-center my-auto">
                        <span>Copyright &copy; <?php echo $sitename; ?> <?php echo Date("Y");  ?></span>
                    </div>
                </div>
            </footer>
            <!-- End of Footer -->

        </div>
        <!-- End of Content Wrapper -->

    </div>
    <!-- End of Page Wrapper -->

    <!-- Scroll to Top Button-->
    <a class="scroll-to-top rounded" href="#page-top">
        <i class="fas fa-angle-up"></i>
    </a>

    <!-- Logout Modal-->
    <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    <a class="btn btn-primary" href="index.php?logout=true">Logout</a>
                </div>
            </div>
        </div>
    </div>

    <!--
        Edit users Modal
    -->


 <?php
    $get_trades = mysqli_query($conn, "SELECT * FROM user_trades WHERE user_id='$user_id' ORDER BY id DESC" );
    if(mysqli_num_rows($get_trades)>0){
        while($trade = mysqli_fetch_assoc($get_trades)){
            $id=$trade['id'];
            $ticker=$trade['ticker'];
            $amount=$trade['amount'];
            $status=$trade['status'];
            $date=$trade['date'];
            $profit=$trade['profit'];
            $trade_ticker=$ticker;
            ?>
                                                 
                                                
    <div class="modal fade" id="edit-trade-<?php echo $id; ?>" tabindex="-1" role="dialog" aria-labelledby="Edit users modal"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Edit this user's trades</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    

                <form class="user" method="post" id="user-form">
                   
                                <input type="hidden" name="trade_id" value='<?php echo $id; ?>'/>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Ticker</label>
                                    <select name="ticker" class="form-select form-control">
                                        <?php foreach ($tickers as $ticker => $name): ?>
                                            <option value="<?php echo $ticker; ?>" <?php if($trade_ticker==$ticker){echo "selected"; } ?>><?php echo $ticker . " - " . $name; ?></option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Amount</label>
                                    <input type="number" class="form-control" name="amount" value="<?php echo $amount; ?>" required/>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Profit</label>
                                    <input type="number" class="form-control" name="profit" value="<?php echo $profit; ?>" required/>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Status</label>
                                    <select name="status" class="form-select form-control" required>
                                         
                                            <option value="open" <?php if($status=="open"){echo "selected"; } ?>>Open</option>
                                             <option value="closed" <?php if($status=="closed"){echo "selected"; } ?>>Closed</option>
                                         
                                    </select>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Date</label>
                                    <input type="text" class="form-control" name="date" value="<?php echo $date; ?>"  required/>
                                </div>
                                
                                

                                <button type="submit" name="edit" class="btn btn-primary btn-user btn-block" id="user-submit">
                                    Edit Trade
                                </button>
                                <hr>
                                
                                 
                            </form>


                </div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    
                </div>
            </div>
        </div>
    </div>


<?php

}
}


if(isset($_POST['edit'])){
    $ticker = mysqli_real_escape_string($conn, $_POST['ticker']);
     $profit = mysqli_real_escape_string($conn, $_POST['profit']);
    $amount = mysqli_real_escape_string($conn, $_POST['amount']);
    $status = mysqli_real_escape_string($conn, $_POST['status']);
    $date = mysqli_real_escape_string($conn, $_POST['date']);
    $trade_id = mysqli_real_escape_string($conn, $_POST['trade_id']);
    
    
    $update = mysqli_query($conn, "UPDATE user_trades SET ticker='$ticker', amount='$amount', status='$status', date='$date', profit='$profit' WHERE id='$trade_id'");
    if($update){
        ?>
        
        <script>
            swal("Great","Trade Edited","success")
            .then(()=>{
                location.replace('user-trades?id=<?php echo $user_id; ?>')
            })
        </script>
        <?php
    }
    else{
        ?>
        <script>
            swal("Oops","An error occurred","error")
        </script>
        <?php
    }
}
?>





 


 <!--create trades -->
 <div class="modal fade" id="create-trade" tabindex="-1" role="dialog" aria-labelledby="Edit users modal"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Create new trade</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    

                <form class="user" method="post" id="user-form">
                   
                                
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Ticker</label>
                                    <select name="ticker" class="form-select form-control">
                                        <?php foreach ($tickers as $ticker => $name): ?>
                                            <option value="<?php echo $ticker; ?>" ><?php echo $ticker . " - " . $name; ?></option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Ticker</label>
                                    <select name="ticker" class="form-select form-control">
                                        <?php 
                                        $get_experts = mysqli_query($conn, "SELECT * FROM experts");
                                        if(mysqli_num_rows($get_experts)>0){
                                            while($expert=mysqli_fetch_assoc($get_experts)){
                                                $expert_name = $expert['name'];
                                                $expert_id = $expert['id'];
                                                ?>
                                                <option value="<?php echo $expert_id; ?>" ><?php echo $expert_name; ?></option>
                                                <?php
                                            }
                                        }
                                        ?>
                                        
                                    </select>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Amount</label>
                                    <input type="number" class="form-control" name="amount" value="" required/>
                                </div>
                                
                                 <div class="form-group my-2">
                                    <label class="form-label">Time (minutes)</label>
                                    <input type="number" class="form-control" name="time" value="" required/>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Status</label>
                                    <select name="status" class="form-select form-control" required>
                                         
                                            <option value="open" >Open</option>
                                             <option value="closed" >Closed</option>
                                         
                                    </select>
                                </div>
                                
                                <div class="form-group my-2">
                                    <label class="form-label">Type</label>
                                    <select name="type" class="form-select form-control" required>
                                         
                                            <option value="open" >Buy</option>
                                             <option value="closed">Sell</option>
                                         
                                    </select>
                                </div>

                                <button type="submit" name="create" class="btn btn-primary btn-user btn-block" id="user-submit">
                                    Create Trade
                                </button>
                                <hr>
                                
                                 
                            </form>


                </div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    
                </div>
            </div>
        </div>
    </div>










    <!-- Bootstrap core JavaScript-->
    <script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

    <!-- Core plugin JavaScript-->
    <script src="vendor/jquery-easing/jquery.easing.min.js"></script>

    <!-- Custom scripts for all pages-->
    <script src="js/sb-admin-2.min.js"></script>

    <!-- Page level plugins -->
    <script src="vendor/datatables/jquery.dataTables.min.js"></script>
    <script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
    <!-- Page level custom scripts -->
   <!-- <script src="js/demo/datatables-demo.js"></script>-->
    <script src="../alertifyjs/alertify.min.js"></script>
    

<?php
if(isset($_POST['create'])){
    $ticker = mysqli_real_escape_string($conn, $_POST['ticker']);
    $status = mysqli_real_escape_string($conn, $_POST['status']);
    $amount = mysqli_real_escape_string($conn, $_POST['amount']);
    $type = mysqli_real_escape_string($conn, $_POST['type']);
    $expert = mysqli_real_escape_string($conn, $_POST['expert']);
    $time = mysqli_real_escape_string($conn, $_POST['time']);
    
    $insert=mysqli_query($conn, "INSERT INTO user_trades (ticker, user_id, status, amount, type, trader, time) VALUES('$ticker','$user_id','$status','$amount','$type','$expert','$time')");
    
    if($insert){
        ?>
        <script>
            swal('Great','New trade created','success')
            .then(()=>{
                location.replace('user-trades?id=<?php echo $user_id; ?>')
            })
        </script>
        <?php
    }
}
?>

    <style>
    edit-btn:hover{
        color: #000;
        cursor: pointer;
    }
</style>

<script>
    function deleteTrade(id){
        swal('Delete trade','Are you sure you want to delete this trade','warning')
        .then((res)=>{
            if(res){
                $.ajax({
                    type: 'post',
                    url: 'ajax/delete-user-trade.php',
                    data: {id},
                    success: function(data){
                        swal('Success','You have deleted this trade','success')
                        .then(()=>{
                            location.replace('user-trades?id=<?php echo $user_id; ?>')
                        })
                    }
                })
            }
        })
    }
</script>
<?php



if(isset($_GET['suspend'])){
    $id=$_GET['suspend'];
    $update=mysqli_query($conn,"UPDATE `users` SET `status`='suspended'  WHERE id='$id'");
}

if(isset($_GET['unsuspend'])){
    $id=$_GET['unsuspend'];

    $update=mysqli_query($conn,"UPDATE `users` SET `status`='verified'  WHERE id='$id'");
}
?>
</body>

</html>
Back to Directory=ceiIENDB`