<?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";
?>
	<script language="javascript">
function intFormat(n)
{
var
regex = /(\d)((\d{3},?)+)$/;

n = n.split(',').join('');

while(regex.test(n))
{
n = n.replace(regex, '$1,$2');
}

return n;
}

function numFormat(n)
{
var
pointReg = /([\d,\.]*)\.(\d*)$/, f;

if(pointReg.test(n))
{
f = RegExp.$2;
return intFormat(RegExp.$1) + '.' + f;
}
return intFormat(n);
}
</script>
<?php
	$act  = $_REQUEST['act'];
	$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'];
	$notes  = $fetch['notes'];
	$internaldescription  = $fetch['internaldescription'];
	$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($act == 1)
	{
		//echo "aaa"; exit;
		$id_stock  = $_REQUEST['id_stock'];
		$lbprice = str_replace(",","", $_REQUEST['lbprice']);
		$msprice = str_replace(",","", $_REQUEST['msprice']);
		$cbprice = str_replace(",","", $_REQUEST['cbprice']);
		$supplier  = $_REQUEST['supplier'];
		$barcode  = $_REQUEST['barcode'];
		$weight  = $_REQUEST['weight'];
		$combine  = $_REQUEST['combine'];
		$supplieritem  = $_REQUEST['supplieritem'];
		$description  = $_REQUEST['description'];
		$internal  = $_REQUEST['internal'];
		$printdescription  = $_REQUEST['printdescription'];
		$uploaddir = 'gkgr/';
		$uploadfile = $uploaddir.$_FILES['file']['name'];
		$filename = $_FILES['file']['name']; 		
		
		if($filename != "")
			{
				if ((($_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/pjpeg")) && ($_FILES["file"]["size"] < 1000000))
				{
				  if ($_FILES["file"]["error"] > 0)
					{
						echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
					}
					else
					{
						move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile);
						$kurs = mysql_fetch_array(mysql_query("select * from tbl_usd order by date_update desc limit 1"));
						$usd = $kurs['usd'];
						$insert = mysql_query("update inventory_gkgr set id_supplier = '$supplier',lbprice='$lbprice',msprice='$msprice',cbprice='$cbprice',weight='$weight',
						barcodeno='$barcode',combineitem='$combine',supplieritem='$supplieritem',picture='$filename',notes='$description',description='$printdescription', internaldescription = '$internal',user_update = '$USERNAME' ,idr='$usd'
						where  id_stock='$id_stock'");
						if($insert)
						{
						?>
								<script language="javascript">
									 alert("Edit GKGR Success");
									document.location="update_gkgr.php?id_stock=<?php echo $id_stock; ?>";
								</script>
						<?php
						}
						else
						{
							?>
								<script language="javascript">
									alert("Edit GKGR Failed");
									document.location="update_gkgr.php?id_stock=<?php echo $id_stock; ?>";
								</script>
							<?php
						}
					}
				}
				else
				{
				?>
								<script language="javascript">
									alert("Image format invalid");
									document.location="update_gkgr.php?id_stock=<?php echo $id_stock; ?>";
								</script>
				<?php
				}
			}
			else
			{
				$kurs = mysql_fetch_array(mysql_query("select * from tbl_usd order by date_update desc limit 1"));
				$usd = $kurs['usd'];
				$insert = mysql_query("update inventory_gkgr set id_supplier = '$supplier',lbprice='$lbprice',msprice='$msprice',cbprice='$cbprice',weight='$weight',
						barcodeno='$barcode',combineitem='$combine',supplieritem='$supplieritem',notes='$description',description='$printdescription', internaldescription = '$internal',user_update = '$USERNAME' ,idr='$usd'
						where  id_stock='$id_stock'");
						if($insert)
						{
						?>
								<script language="javascript">
									 alert("Edit GKGR Success");
									document.location="update_gkgr.php?id_stock=<?php echo $id_stock; ?>";
								</script>
						<?php
						}
						else
						{
							?>
								<script language="javascript">
									alert("Edit GKGR Failed");
									document.location="update_gkgr.php?id_stock=<?php echo $id_stock; ?>";
								</script>
							<?php
						}
			}
	}
?>
<body class="withvernav">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0, minimum-scale=1.0, maximum-scale=1.0" />
<script src="js/tinymce2/tinymce.dev.js"></script>
<script src="js/tinymce2/plugins/table/plugin.dev.js"></script>
<script>
	tinymce.init({
		selector: "textarea#description",
		theme: "modern",
		plugins: [
			"advlist autolink link image lists charmap print preview hr anchor pagebreak spellchecker",
			"searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
			"save table contextmenu directionality emoticons template paste"
		],
		content_css: "css/development.css",
		add_unload_trigger: false,

		toolbar1: "save newdocument fullpage | bold italic underline strikethrough | alignleft aligncenter alignright alignjustify | styleselect formatselect fontselect fontsizeselect",
		toolbar2: "cut copy paste | searchreplace | bullist numlist | outdent indent blockquote | undo redo | link unlink anchor image media help code | inserttime preview | forecolor backcolor",
		toolbar3: "table | hr removeformat | sub sup | charmap emoticons | print fullscreen | ltr rtl | spellchecker | visualchars nonbreaking template pagebreak restoredraft | insertfile insertimage",
		menubar: false,
		toolbar_items_size: 'small',

		style_formats: [
			{title: 'Bold text', inline: 'b'},
			{title: 'Red text', inline: 'span', styles: {color: '#ff0000'}},
			{title: 'Red header', block: 'h1', styles: {color: '#ff0000'}},
			{title: 'Example 1', inline: 'span', classes: 'example1'},
			{title: 'Example 2', inline: 'span', classes: 'example2'},
			{title: 'Table styles'},
			{title: 'Table row 1', selector: 'tr', classes: 'tablerow1'}
		],

		templates: [
			{title: 'My template 1', description: 'Some fancy template 1', content: 'My html'},
			{title: 'My template 2', description: 'Some fancy template 2', url: 'development.html'}
		]
	});
</script>
<?php include "include/head2.php"; ?>
<?php include "include/leftmenu.php"; ?>
<?php include "include/top.php"; ?>
  <h1><i class="icon-gears (alias)"></i> Update 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="update_gkgr.php?id_stock=<?php echo $id_stock; ?>&act=1"  enctype="multipart/form-data"  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 status_supplier='1' order by nama_supplier,kode_supplier";
                                              $rs3 = mysql_query($sql3);
                                              while($fetch3 = mysql_fetch_array($rs3))
                                              {
                                               ?>
                                         <option <?php if($fetch3['id_supplier']==$id_supplier) { ?> selected="selected" <?php } ?> 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; ?>"  >
                          </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; ?>" >
                          </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, ',', ','); ?>"  >
                          </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, ',', ','); ?>"  >
                          </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, ',', ','); ?>" >
                          </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; ?>"  >
                          </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; ?>" >
                          </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 <?php if($fetch3['id_status']==$id_status) { ?> selected="selected" <?php } ?> 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">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 <?php if($fetch3['id_branch']==$id_branch) { ?> selected="selected" <?php } ?> value="<?php echo $fetch3['id_branch']; ?>"><?php echo  $fetch3['nama_branch'];  ?></option>
                                                      <?php
                                              }
                                             
                            }
							?>
                            </select>
                          </div>
                        </div>
                       
                           <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="readyitem/<?php echo $picture; ?>">
							<img src="<?php echo $all; ?>" alt="" height="69" width="117"/></a>&nbsp;
                            <input type="file" name="file" id="file" />
                          </div>
                        </div>
                      
                        <div class="form-group">
                          <label class="col-md-4 control-label">Print Description</label>
                          <div class="col-md-8">
                          <textarea id="printdescription" name="printdescription" class="form-control"><?php echo $description; ?></textarea>
                          </div>
                        </div>
                         <div class="form-group">
                          <label class="col-md-4 control-label">Internal Description</label>
                          <div class="col-md-8">
                          <textarea id="internal" name="internal" class="form-control"><?php echo $internaldescription; ?></textarea>
                          </div>
                        </div>
                         <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"><?php echo $notes; ?></textarea>
                          </div>
                        </div>
                        <div class="form-group">
                          <div class="col-md-offset-4 col-md-8">
                             <button type="submit" class="btn btn-default">Submit</button>
                            <button type="reset" class="btn btn-default">Reset</button>
                          </div>
                        </div>
                      </form>
                    </div>
                    </div>
                    </div>
                    </div>
                    </div>
                   

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

</html>