<?php 
include '../inc/fcurl.php';
include '../config_member.php';
check_session();
?>
<?php
$_urifile = $_SERVER["SCRIPT_URI"];
$fileuri = explode("/",$_urifile);
$fileuri2 =  array_pop($fileuri);
$newtickerurl = implode("/",$fileuri)."/tickersearch2.php";
?>
<?php
$query = array (
    'SELECT'    =>  '*',
    'FROM'      =>  'users',
    'WHERE'     =>  'id=\''.$_SESSION['uid'].'\''
);
$result = $db->query_build($query);
$data = $db->fetch_assoc($result);

$query = array (
		'SELECT'    =>  '*',
		'FROM'     =>   'portfolios',
		'WHERE'     =>  'fk_user_id='.$_SESSION['uid']
	);
$porto = $db->query_build($query);

?>
<!doctype html>
<html lang="en">
<head>
	<title>Member Area - Portfolio Tracking</title>
	<?php include("inc_meta_member.php"); ?>
	<link href="assets/css/inside_admin.css" rel="stylesheet">
	<script src="//code.jquery.com/jquery-1.10.2.js"></script>
	<script>
	function delete_transaction(t_id) {
		if(confirm("Delete?")==true) {
			$.ajax({
				url: 'delete.php?p=portfolio&id='+t_id,
				success : function(){
					$('#li'+t_id).fadeOut();
				},
				error : function() {
					alert('failed');
				}
			});
		}
	}
	</script>
</head>

<body class="bg-theme bg-theme1">
	<!--wrapper-->
	<div class="wrapper">
		<!--start header -->
		
		<?php include("inc_top_member.php"); ?>
		<!--start page wrapper -->
		<div class="page-wrapper">
			<div class="page-content">

					<?php include("inc_ticker.php"); ?>
					
					<center><h5 style="color:yellow"><i class="bx bx-line-chart"></i> Portfolio Tracking</h5></center>


				<div class="row">
					<div class="col-12 col-lg-12 col-xl-12 d-flex">
					   <div class="card radius-10 w-100">
						<div class="card-body">
													
							<!--start desktop-->
							<div class="grid_12 portfolio_desktop">
								<div id="content_inside_list" style="background-color:#fff">
									<div id="content_inside_list_header">
										<ul style="margin:0px !important; padding:0px !important">
											<li>
												<div class="left w2">DATE</div>
												<div class="left w2">QUOTE</div>
												<div class="left w100">SHARE PRICE</div>
												<div class="left w145">AMOUNT OF SHARES</div>
												<div class="left w130">CURRENT PRICE</div>
												<div class="left w2">CHANGE</div>
												<div class="left w130">TOTAL HOLDINGS</div>
												<div class="right">ACTIONS</div>
												<div class="spacer"></div>
											</li>
										</ul>
									</div><!--end content_inside_list_header-->
							
									<div id="content_inside_list_data">
										<ul>
											<?php
											$porto2=array();
											if($db->num_rows($porto)>0) {
												while($datax = $db->fetch_assoc($porto)) {
													$porto2[]=$datax;
												
                                    				//start
                                            
                                    				$ccxxx = new cURL(); 
                                    			
                                    				$url1 = 'http://livedatamarkets.com/tickersearch2.php?q='.$datax["stockcode"];
                                    				$res =  $ccxxx->get($url1); 
                                    				$strtime=time();
                                    				$dete = explode(date("Y-"), $res);
                                    				$co=count($dete)-1;
                                    				$datas=explode(",",$dete[$co]);
                                    				$price = 0.0;
                                                    $mycustomdata = explode("price\":", $res);
                                                    if (count($mycustomdata) > 1) {
                                                        $arrprice = explode(",", $mycustomdata[1]);
                                                        if (count($arrprice) > 1) {
                                                            $sprice = str_replace("\"", "", $arrprice[0]);
                                                            $price = (float) $sprice;
                                                        }
                                                    } 

                                    				$ccxxx = new cURL(); 
                                    				$url2 = $newtickerurl . '?q='.$datax["stockcode"];
                                          			$res =  $ccxxx->get($url2); 
                                    				$strtime=time();
                                    				$dete = explode(date("Y-"), $res);
				
                                					$co=count($dete)-1;
                                					$data=explode(",",$dete[$co]);

													$cls = '';
													$change = ((($price-$datax["share_price"])/$datax["share_price"])*100);
												
													$cls = $change>0 ? 'positive' : 'negative';
											?>
											<li id="li<?php echo $datax["id"]?>">
												<div class="left w2 font11"><?php echo date("d/m/Y",strtotime($datax["porto_date"]))?></div>
												<div class="left w2"><?php echo $datax["stockcode"]?></div>
												<div class="left w100"><?php echo number_format($datax["share_price"],2)?></div>
												<div class="left w145"><?php echo $datax["share_amount"]?></div>
												<div class="left w130">$ <?php echo number_format($price,2)?></div>
												<div class="left w2 font11"><span class='<?php echo $cls?>'><?php echo number_format($change,2)?>%</span></div>
												<div class="left w130">$ <?php echo number_format($price*$datax["share_amount"],2)?></div>
												<div class="right">
												<a href="edit_portfolio.php?id=<?php echo $datax["id"]?>"><span class="bx bx-refresh me-0" style="font-size:18px"></span> Edit Portfolio</a>
												&nbsp;|&nbsp;
												<a href="#" onclick="delete_transaction('<?php echo $datax['id'];?>');"><span class="bx bx-trash-alt me-0" style="font-size:18px"></span> Delete Portfolio</a>
												</div>
												<div class="spacer"></div>
											</li>
											<?php		
												}
											}else{	                        
											?>
											<!-- start if no data -->
											<li>No data Found</li>
											<!-- end if no data -->
											<?php } ?>
										</ul>
									</div><!--end content_inside_list_data-->
									<form action="member_portfolio_add.php" method="post" class="portfolio_add">
										<input value="Add Portfolio Item" type="submit" class="btn btn-secondary" />
									</form>
								</div>
						</div><!--end desktop-->
						
						
						<!--start mobile-->
						<div class="grid_12 portfolio_mobile">
							<div id="content_inside_list_mobile">
								<div id="content_inside_list_data_mobile" class="for_mobile trans_detail" style="color:#fff; text-align:left">
									<ul style="margin:0px !important; padding:0px !important">
										<?php
											$porto2=array();
											if($db->num_rows($porto)>0) {
												while($datax = $db->fetch_assoc($porto)) {
													$porto2[]=$datax;
												
                                    				//start
                                            
                                    				$ccxxx = new cURL(); 
                                    			
                                    				$url1 = 'http://livedatamarkets.com/tickersearch2.php?q='.$datax["stockcode"];
                                    				$res =  $ccxxx->get($url1); 
                                    				$strtime=time();
                                    				$dete = explode(date("Y-"), $res);
                                    				$co=count($dete)-1;
                                    				$datas=explode(",",$dete[$co]);
                                    				$price = 0.0;
                                                    $mycustomdata = explode("price\":", $res);
                                                    if (count($mycustomdata) > 1) {
                                                        $arrprice = explode(",", $mycustomdata[1]);
                                                        if (count($arrprice) > 1) {
                                                            $sprice = str_replace("\"", "", $arrprice[0]);
                                                            $price = (float) $sprice;
                                                        }
                                                    } 

                                    				$ccxxx = new cURL(); 
                                    				$url2 = $newtickerurl . '?q='.$datax["stockcode"];
                                          			$res =  $ccxxx->get($url2); 
                                    				$strtime=time();
                                    				$dete = explode(date("Y-"), $res);
				
                                					$co=count($dete)-1;
                                					$data=explode(",",$dete[$co]);

													$cls = '';
													$change = ((($price-$datax["share_price"])/$datax["share_price"])*100);
												
													$cls = $change>0 ? 'positive' : 'negative';
											?>
										<!-- start looping data -->
										<li id="li<?php echo $datax1["id"]?>" class="portfolio_data_mobile_loop">
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>DATE</li>
												<li><?php echo date("d/m/Y",strtotime($datax["porto_date"]))?></li>
											</ul>
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>QUOTE</li>
												<li><?php echo $datax1["stockcode"]?></li>
											</ul>
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>SHARE PRICE</li>
												<li><?php echo number_format($datax["share_price"],2)?></li>
											</ul>
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>AMOUNT OF SHARES</li>
												<li><?php echo $datax["share_amount"]?></li>
											</ul>
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>CURRENT PRICE</li>
												<li>$ <?php echo number_format($price,2)?></li>
											</ul>
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>CHANGE</li>
												<li><span class='<?php echo $cls?>'><?php echo number_format($change,2)?>%</span></li>
											</ul>
											<ul class="portfolio_data_mobile" style="margin:0px !important; padding:0px !important">
												<li>TOTAL HOLDINGS</li>
												<li>$ <?php echo number_format($price*$datax["share_amount"],2)?></li>
											</ul>
											<ul class="portfolio_data_mobile_action" style="margin:0px !important; padding:0px !important">
												<li>ACTIONS</li>
												<li>
													<button type="button" class="btn btn-light" onclick="window.location.href='edit_portfolio.php?id=<?php echo $datax1["id"]?>';" title="Edit Portfolio">
														<i class="bx bx-refresh me-0"></i>
													</button>
													- 
													<button type="button" class="btn btn-light" onclick="delete_transaction('<?php echo $datax1['id'];?>');" title="Delete Portfolio">
														<i class="bx bx-trash-alt me-0"></i>
													</button>
												</li>
												
											</ul>
										</li>
										<?php	
			$kkk=$kkk+1;							
											}
										}else{	                        
										?>
										<!-- start if no data -->
										<li>No data Found</li>
										<!-- end if no data -->
										<?php } ?>
										<!-- end looping data -->
									</ul>
								</div><!--end content_inside_list_data-->
								<form action="member_portfolio_add.php" method="post" class="portfolio_add">
									<input value="Add Portfolio Item" type="submit" class="btn btn-secondary" />
								</form>
							</div><!--end content_inside_list-->
					   </div>
					   <!--end mobile-->
					   
					</div>
				   </div><!--End Row-->	 

			</div>
		</div>
		<!--end page wrapper -->
		<!--start overlay-->
		<div class="overlay toggle-icon"></div>
		<!--end overlay-->
		<!--Start Back To Top Button--> <a href="javaScript:;" class="back-to-top"><i class='bx bxs-up-arrow-alt'></i></a>
		<!--End Back To Top Button-->
		<?php include("inc_footer_member.php"); ?>
	</div>
	<!--end wrapper-->
	
	<?php include("inc_footer_script_member.php"); ?>
</body>

</html>