<?php
session_name("AUTHENUSER");
session_start();
$USERNAME = $_SESSION['SES_USERNAME'];
if(!session_name("AUTHENUSER"))
	{
?>
						<script language="javascript">
						 alert("Waktu Login telah habis.Silahkan Login Kembali");
						document.location="index.php";
						</script>
<?php
	}
if(!$USERNAME)
	{
?>
						<script language="javascript">
						 alert("Harap Login Dahulu.");
						document.location="index.php";
						</script>
<?php
	}
	?>
	<?php 
	include "common/config.php";
	include "include/head.php";
?>
	<?php
	$id_stock  = $_REQUEST['id_stock'];
	$fetch = mysql_fetch_array(mysql_query("select * from inventory_gkgr where id_stock = '$id_stock'"));
	$kode_stock  = $fetch['kode_stock'];
	$fetch2 = mysql_fetch_array(mysql_query("select sum(price*weight) as sumweight,sum(workmanship) as sumworkmanship,
	sum(cost) as sumcost,sum(gold) as sumgold, sum(logistic) as sumlogistic from  inventory_custom a
	inner join tbl_diamonds b on a.id_diamonds = b.id_diamonds where kode_stock='$kode_stock'"));
	$fetch4 = mysql_fetch_array(mysql_query("SELECT usd FROM tbl_gold where date_update in (SELECT MAX( date_update ) from tbl_gold )"));
	$msprice = $fetch2['sumweight'] + $fetch2['sumlogistic'] + $fetch2['sumworkmanship']+ $fetch2['sumcost'] 
	+ ($fetch2['sumgold']*$fetch4['usd']);						    					    			    				    
	$fetch3 = mysql_fetch_array(mysql_query("select * from tbl_cblb"));
	$cbprice  = $msprice + ($fetch3['cbprice'] *$msprice);
	$lbprice  = $cbprice + ($fetch3['lbprice'] *$cbprice);
	if($msprice == "")
	{
		$msprice  = $fetch['msprice'];
		$lbprice  = $fetch['lbprice'];
		$cbprice  = $fetch['cbprice'];
	}
	$id_supplier = $fetch['id_supplier'];
	$barcodeno  = $fetch['barcodeno'];
	$weight  = $fetch['weight'];
	$combineitem  = $fetch['combineitem'];
	$supplieritem  = $fetch['supplieritem'];
	$description  = $fetch['description'];
	$id_status  = $fetch['id_status'];
	$id_branch  = $fetch['id_branch'];
	$picture = $fetch['picture'];
	$loc = "gkgr/";
	$all = $loc.$picture; 
	$kurs2 = mysql_fetch_array(mysql_query("select usd from tbl_usd order by date_update desc limit 1"));
	$usd = $kurs2['usd'];
	if($fetch['date_stock'] == '')
								{
								$date_stock = '';
								}
								else
								{
								list($d, $e, $f)=split ("[-]", $fetch['date_stock']);
								$date_stock   =$f."-".$e."-".$d;
								}
?>
<body class="withvernav">
<?php include "include/head2.php"; ?>
<?php include "include/leftmenu.php"; ?>
<?php include "include/top.php"; ?>
  <h1><i class="icon-gears (alias)"></i> View Inventory GKGR</h1>
</div>

<!--<ol class="breadcrumb">
  <li><a href="#">Home</a></li>
  <li><a href="#">Bread</a></li>
  <li><a href="#">Crumbs</a></li>
  <li class="active">Example</li>
</ol>-->
          <div class="main-content">
            <div class="row">
                <div class="widget">
                  <div class="widget-content-white glossed">
                    <div class="padded">
                      <form method="post" action="#"  role="form" class="form-horizontal">
                        <div class="form-group">
                          <label class="col-md-4 control-label">Stock ID</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="kode" id="kode"   value="<?php echo $kode_stock; ?>"  readonly="readonly">
                          </div>
                          </div>
                           <div class="form-group">
                          <label class="col-md-4 control-label">Kode Supplier -  Nama Supplier</label>
                          <div class="col-md-8"><select name="supplier" id="supplier" class="form-control">
                               <?php
                                              $sql3 = "select * from tbl_supplier where id_supplier='$id_supplier' order by nama_supplier,kode_supplier";
                                              $rs3 = mysql_query($sql3);
                                              while($fetch3 = mysql_fetch_array($rs3))
                                              {
                                               ?>
                                        <option value="<?php echo $fetch3['id_supplier']; ?>"><?php echo  $fetch3['kode_supplier'];  ?> - <?php echo  $fetch3['nama_supplier'];  ?></option>
                                                      <?php
                                              }
                                             ?>
                            </select>
                          </div>
                        </div>
                         <div class="form-group">
                          <label class="col-md-4 control-label">Supplier Item No.</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="supplieritem" id="supplieritem" value="<?php echo $supplieritem; ?>"  readonly="readonly" >
                          </div>
                          </div>
                           <div class="form-group">
                          <label class="col-md-4 control-label">Barcode No.</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="barcode" id="barcode" value="<?php echo $barcodeno; ?>"  readonly="readonly">
                          </div>
                          </div>
                           <div class="form-group">
                          <label class="col-md-4 control-label">Kurs</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="usd" id="usd" value="<?php echo $usd; ?>" readonly="readonly" >
                          </div>
                          </div>
                           <div class="form-group">
                          <label class="col-md-4 control-label">MS Price</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="cbprice" id="cbprice" value="<?php  echo number_format($msprice, 0, ',', ','); ?>"  readonly="readonly">
                          </div>
                          </div>
                           <div class="form-group">
                          <label class="col-md-4 control-label">CB Price</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="msprice" id="msprice" value="<?php  echo number_format($cbprice, 0, ',', ','); ?>"  readonly="readonly">
                          </div>
                          </div>
                          <div class="form-group">
                          <label class="col-md-4 control-label">LB Price</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="lbprice" id="lbprice" value="<?php  echo number_format($lbprice, 0, ',', ','); ?>"  readonly="readonly">
                          </div>
                          </div>
                          <div class="form-group">
                          <label class="col-md-4 control-label">Weight (in gram)</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="weight" id="weight" value="<?php echo $weight; ?>"  readonly="readonly" >
                          </div>
                          </div>
                           <div class="form-group">
                          <label class="col-md-4 control-label">Combine Item No.</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="combine" id="combine" value="<?php echo $combineitem; ?>"  readonly="readonly">
                          </div>
                          </div>
                          <div class="form-group">
                          <label class="col-md-4 control-label">Status Inventory</label>
                          <div class="col-md-8"><select name="status" id="status" class="form-control">
                               <?php
                                              $sql3 = "select * from tbl_status where id_status='$id_status' ";
                                              $rs3 = mysql_query($sql3);
                                              while($fetch3 = mysql_fetch_array($rs3))
                                              {
                                               ?>
                                        <option value="<?php echo $fetch3['id_status']; ?>"><?php echo  $fetch3['status'];  ?></option>
                                                      <?php
                                              }
                                             ?>
                            </select>
                          </div>
                        </div>
                          <div class="form-group">
                          <label class="col-md-4 control-label">Date Stock</label>
                          <div class="col-md-8">
                            <input type="text" class="form-control" name="combine" id="combine" value="<?php echo $date_stock; ?>"  readonly="readonly">
                          </div>
                          </div>
                         <div class="form-group">
                          <label class="col-md-4 control-label">Branch ID</label>
                          <div class="col-md-8"><select name="id_branch" id="id_branch" class="form-control">
                            <?php if($id_branch == NULL)
                            {
                            ?>
                            <option value="">Head Office</option>
                           	<?php
						    }
                            else
                            {
                                              $sql3 = "select *
											  from tbl_branch where id_branch='$id_branch' order by nama_branch";
                                              $rs3 = mysql_query($sql3);
                                              while($fetch3 = mysql_fetch_array($rs3))
                                              {
                                               ?>
                                        <option value="<?php echo $fetch3['id_branch']; ?>"><?php echo  $fetch3['nama_branch'];  ?></option>
                                                      <?php
                                              }
                                             
                            }
							?>
                            </select>
                          </div>
                        </div>
                        <?php if($picture <> "")
							 {
							?>
                           <div class="form-group">
                          <label class="col-md-4 control-label">Picture *max file 1MB and format file only JPEG/GIF</label>
                          <div class="col-md-8">
                          <a class="image" href="gkgr/<?php echo $picture; ?>">
							<img src="<?php echo $all; ?>" alt="" height="69" width="117"/></a>&nbsp;
                          </div>
                        </div>
                         <?php
							 }
							 ?>
                         <div class="form-group">
                          <label class="col-md-4 control-label">Description</label>
                          <div class="col-md-8">
                          <textarea id="description" name="description" rows="15" cols="80" style="width: 80%" class="form-control" readonly><?php echo $description; ?></textarea>
                          </div>
                        </div>
                        <div class="form-group">
                          <div class="col-md-offset-4 col-md-8">
                             <input type="button" value=" Back " class="btn btn-default" onClick="document.location='javascript:history.back(-1)'" />
                          </div>
                        </div>
                      </form>
                    </div>
                    </div>
                    </div>
                    </div>
                    </div>
                   

<?php include "include/foot.php"; ?>
<script src='assets/js/for_pages/dashboard.js'></script>
</body>

</html>