<?php
session_start();
include ("includes/security.php");
include ("includes/database.php");
include ("includes/setting.php");

//retrieved logged's user data
$username=$_SESSION["username"];
$dataUser=mysqli_query($newcon,"SELECT * from user where username='$username'");
$bil_rekod=mysqli_num_rows($dataUser);
$showData=mysqli_fetch_array($dataUser);



//retrieved tbl_data2

if (isset($_GET["action"]))
{
$action=$_GET["action"];

	if ($action=="empty")
	{
	mysqli_query($newcon,"delete from tbl_order_details_temp where user_id='$username'")or die (mysqli_error($newcon));		
	}
	
	
	
}



?>

<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">

    <title><?php echo $tajuk; ?></title>

    <!-- Bootstrap Core CSS -->
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

    <!-- MetisMenu CSS -->
    <link href="vendor/metisMenu/metisMenu.min.css" rel="stylesheet">

    <!-- Custom CSS -->
    <link href="dist/css/sb-admin-2.css" rel="stylesheet">

    <!-- Custom Fonts -->
    <link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->

</head>

<body>

    <div id="wrapper">

        <!-- Navigation -->
        <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0">
            <div class="navbar-header">
                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                    <span class="sr-only">Toggle navigation</span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                </button>
                <a class="navbar-brand" href="index.html"><?php echo $tajuk; ?></a>
            </div>
            <!-- /.navbar-header -->

            <ul class="nav navbar-top-links navbar-right">

               
                
                <li class="dropdown">
                    <a class="dropdown-toggle" data-toggle="dropdown" href="#">
                        <i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i>
                    </a>
                    <ul class="dropdown-menu dropdown-user">
<?php include ("includes/menu_atas.php"); ?>
                    </ul>
                    <!-- /.dropdown-user -->
                </li>
                <!-- /.dropdown -->
            </ul>
            <!-- /.navbar-top-links -->

            <div class="navbar-default sidebar" role="navigation">
                <div class="sidebar-nav navbar-collapse">
                    <ul class="nav" id="side-menu">
                        
                        <?php include "includes/menu_tepi.php";?>
                    </ul>
                </div>
                <!-- /.sidebar-collapse -->
            </div>
            <!-- /.navbar-static-side -->
        </nav>

        <!-- Page Content -->
        <div id="page-wrapper">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-12">
                      <h1 class="page-header">Shopping Cart</h1>
                      
                      
                      
                       <div class="col-lg-6">
                    <div class="panel panel-default">
                        <div class="panel-heading">
                          
                          
                          
                        
                          
                          
                          
                          
                          
                          
                          
                          
                          
                        </div>
                        <!-- /.panel-heading -->
                        <div class="panel-body">
                            <div class="table-responsive">
                                <table class="table">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Picture</th>
                                            <th>Product Name</th>
                                            <th>Product Price</th>
                                            <th>Quantity</th>
                                            <th>Total</th>
                                        </tr>
                                    </thead>
                                   
                                   
                                   
                              <?php
$dataSubjects=mysqli_query($newcon,"SELECT * from expertise where expertise_id='$username'");
$bil_subjects=mysqli_num_rows($dataSubjects);
$ttlSemua=0;
?>                              
                                   
<tbody>

<?php
if ($bil_subjects==0)
{
?>
<tr>
<td colspan="6">No record found!</td>

</tr>
<?php
}
else
{


while ($showSubjects=mysqli_fetch_array($dataSubjects))
	{
$dataSubjects1=mysqli_query($newcon,"SELECT * from tbl_product where product_id='$showSubjects[product_id]'");
$showSubjects1=mysqli_fetch_array($dataSubjects1)
?>


<tr>
<td><?php echo $showSubjects1['product_id'];?></td>
 <td><img src="product/<?php echo $showSubjects1['product_pic'];?>" width="64" width="64"></td>
<td><?php echo $showSubjects1['product_name'];?></td>
<td>RM <?php echo number_format($showSubjects1['product_price'],2);?></td>
<td><?php echo $showSubjects['quantity'];?></td>
<td>RM <?php echo number_format($showSubjects['quantity']*$showSubjects1['product_price'],2);?></td>
</tr>

<?php
$ttlSemua+=($showSubjects['quantity']*$showSubjects1['product_price']);
}
}
?>
                                       
</tbody>



 <tr>
                                            <th colspan="5" align="right" valign="middle">SUM TOTAL</th>
                                         
                                            <th>RM <?php echo number_format($ttlSemua,2); ?></th>
                                        </tr>
                                        
                                        
 
 
<?php
if ($bil_subjects!=0)
{
?>                                     
 <tr>
                                            <th colspan="6" align="right" valign="middle"><center> 
<a href="viewcart.php?action=empty" class="btn btn-default">Empty Cart</a>
<a href="payment1.php" class="btn btn-primary">Confirm Purchase</a></center></th>
                                         
                                           
                                        </tr>
                                        
                                        <?php
}
?>
                                        
                                        



                                </table>
                            </div>
                            <!-- /.table-responsive -->
                        </div>
                        <!-- /.panel-body -->
                    </div>
                    <!-- /.panel -->
                </div>
                <!-- /.col-lg-6 -->
            </div>
            <!-- /.row -->
                      
                      
                      
                      
                        
                      
  
  
                    </div>
                    <!-- /.col-lg-12 -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container-fluid -->
        </div>
        <!-- /#page-wrapper -->

    </div>
    <!-- /#wrapper -->

    <!-- jQuery -->
    <script src="vendor/jquery/jquery.min.js"></script>

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

    <!-- Metis Menu Plugin JavaScript -->
    <script src="vendor/metisMenu/metisMenu.min.js"></script>

    <!-- Custom Theme JavaScript -->
    <script src="dist/js/sb-admin-2.js"></script>

</body>

</html>
