da8ce53cf0240070ce6c69c48cd588ee

Edit file

File name : wholesale-productprice-addf.php

Content :

<?php

session_start();

include("../include/config.php");

include("../include/functions.php");

include("../include/simpleimage.php");

validate_admin();

$product_id=ucfirst(mysql_real_escape_string($_POST['product_id']));

$size=mysql_real_escape_string($_REQUEST['size']);
  $sizetype=mysql_real_escape_string($_REQUEST['sizetype']);
  $tax=mysql_real_escape_string($_POST['tax']);
  $tax_method=mysql_real_escape_string($_POST['tax_method']);
  $actual_price=mysql_real_escape_string($_REQUEST['actual_price']);

$mrp_price=mysql_real_escape_string($_REQUEST['mrp_price']);

$discount=mysql_real_escape_string($_REQUEST['discount']);

$sell_price=mysql_real_escape_string($_REQUEST['sell_price']);
  $minimum_quantity=mysql_real_escape_string($_POST['minimum_quantity']);
  $wholesale_discount=mysql_real_escape_string($_POST['wholesale_discount']);

$in_stock=mysql_real_escape_string($_REQUEST['in_stock']);

$video=mysql_real_escape_string($_REQUEST['video']);

$barcode_number=mysql_real_escape_string($_REQUEST['barcode_number']);
if($sizetype=='KG'){
$weight= $size*2.20462;
}elseif($sizetype=='LTR'){
$weight= $size*2.204;
}elseif($sizetype=='OZ'){
$weight= $size*0.0625;
}elseif($sizetype=='GM'){
$weight= $size*0.00220462;
}elseif($sizetype=='ML'){
$weight= $size*.00220462;
}elseif($sizetype=='GAL'){
$weight= $size*8.35;
}elseif($sizetype=='FLOZ'){
$weight= $size*0.0625;
}elseif($sizetype=='LBS'){
$weight= $size*1;
}else{
$weight='';}
  if($tax_method=='Amount'){
	    $tax_value=$tax;
  } 
  if($tax_method=='Low Tax'){
	    $tax_value=($mrp_price*2.25)/100;
  }
  if($tax_method=='High Tax'){
	    $tax_value=($mrp_price*10.25)/100;
  }
  if($tax_method=='City of Chicago/Soda Tax'){
	    $tax_value=((($mrp_price*10.25/100)+$mrp_price)*3/100)+($mrp_price*10.25/100);
  }

if($_REQUEST['submitForm']=='yes'){

if($_FILES['photo']['size']>0 && $_FILES['photo']['error']==''){

$Image= new SimpleImage();

$img=time().substr($_FILES['photo']['name'],-5);

move_uploaded_file($_FILES['photo']['tmp_name'],"../upload_images/product/".$img);

copy("../upload_images/product/".$img,"../upload_images/product/thumb/".$img);

copy("../upload_images/product/".$img,"../upload_images/product/tiny/".$img);

$Image->load("../upload_images/product/thumb/".$img);

$Image->resize(150,150);

$Image->save("../upload_images/product/thumb/".$img);

$Image->load("../upload_images/product/tiny/".$img);

$Image->resize(300,300);

$Image->save("../upload_images/product/tiny/".$img);

CompressImage('../upload_images/product/'.$img, '../upload_images/product/'.$img, 40);
CompressImage('../upload_images/product/thumb/'.$img, '../upload_images/product/thumb/'.$img, 40);
CompressImage('../upload_images/product/tiny/'.$img, '../upload_images/product/tiny/'.$img, 40);

}

if($_FILES['barcode']['size']>0 && $_FILES['barcode']['error']==''){

$barcodeimg=time().substr($_FILES['barcode']['name'],-5);

move_uploaded_file($_FILES['barcode']['tmp_name'],"../upload_images/product/barcode/".$barcodeimg);

}

if($_REQUEST['id']==''){

$sql="insert into $wholesale_productprice set product_id='$product_id',sizes='$size',size='$size',size_type='$sizetype',weight='$weight',actual_price='$actual_price',mrp_price='$mrp_price',discount='$discount',sell_price='$sell_price',wholesale_min='$minimum_quantity',wholesale_discount='$wholesale_discount',in_stock='$in_stock' ,barcode='$barcodeimg',barcode_number='$barcode_number',status=1";

if($img=='' && $_REQUEST['pimage']!=''){

$sql.=" ,pphoto='".$_REQUEST['pimage']."' ";

}

if($img!=''){

$sql.=" ,pphoto='$img' ";

}

$obj->query($sql);

$_SESSION['sess_msg']='Product price added sucessfully';

}else{

$sql="update $wholesale_productprice set product_id='$product_id',sizes='$size',size='$size',size_type='$sizetype',weight='$weight',actual_price='$actual_price',mrp_price='$mrp_price',discount='$discount',sell_price='$sell_price',wholesale_min='$minimum_quantity',wholesale_discount='$wholesale_discount',in_stock='$in_stock',video='$video',barcode_number='$barcode_number' ,status=1";

if($img=='' && $_REQUEST['pimage']!=''){

$sql.=" ,pphoto='".$_REQUEST['pimage']."' ";

}

if($img!=''){

$sql.=" ,pphoto='$img' ";

}

if($barcodeimg!=''){

$imageArr=$obj->query("select barcode from $wholesale_productprice where id='".$_REQUEST['id']."' ");

$resultImage=$obj->fetchNextObject($imageArr);

@unlink("../upload_images/product/barcode/".$resultImage->barcode);

$sql.=" ,barcode='$barcodeimg' ";

}

$sql.=" where id='".$_REQUEST['id']."'  ";

$obj->query($sql);

$_SESSION['sess_msg']='Product price updated sucessfully';

}

header("location: wholesale-productprice-list.php?product_id=".$_REQUEST['product_id']);

exit();

}

if($_REQUEST['id']!=''){

$sql=$obj->query("select * from $wholesale_productprice where id=".$_REQUEST['id']);

$result=$obj->fetchNextObject($sql);

}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

function validate(obj)

{

if(obj.mrp_price.value=='' || obj.mrp_price.value==0){

alert("Please enter mrp price");

obj.mrp_price.focus();

return false;

}

if(obj.sell_price.value=='' || obj.sell_price.value==0){

alert("Please enter sell price");

obj.sell_price.focus();

return false;

}

</script>

function calcPrice(){

var mrp_price=document.getElementById('mrp_price').value;

var dis=document.getElementById('discount').value;

if(mrp_price!='' && dis!='' ){

document.getElementById('sell_price').value=mrp_price-(mrp_price*dis/100);

}

</script>

</head>

<body>

<?php include("header.php") ?>

$(document).ready(function(){

$('#size').autocomplete({

search: function () {},

source: function (request, response)

{

$.ajax(

{

url:"sizesSource.php" ,

dataType: "json",

data:

{

q: request.term,

success: function (data)

{

response(data);

}

});

minLength:1,

select: function( event, ui ) {

$( "#size" ).val( ui.item.value );

return false;

}

});

})

</script>

<tr>

<tr>

<tr>

<em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Add Price/Size For <?php  echo getField('product_name',$wholesale_product,$_REQUEST['product_id']);?>

</td>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td align="left" class="paddBot11"><input name="size" type="text" id="size" size="36" value="<?php echo stripslashes($result->size);?>" /> Enter digits only.</td>

</tr>
							  <tr>

<td align="left" class="paddBot11"><select name="sizetype" style="width:245px;" required >
<?php if($_REQUEST['product_id']!=''){?> <option value="<?php echo $result->size_type; ?>" selected="selected"><?php echo $result->size_type; ?></option><?php } else { ?>

<option value="" selected="selected">Select Size</option>

<?php } $sqlsize=$obj->query("select * from tbl_psizes where status=1 order by psize asc");

while($resultsize=$obj->fetchNextObject($sqlsize)){ ?>

<option value="<?php echo $resultsize->psize; ?>"><?php echo $resultsize->psize; ?></option>

<?php } ?>

</select></td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Actual Price:</strong></td>

<td align="left" class="paddBot11"><input name="actual_price" type="text" id="actual_price" size="20" value="<?php echo stripslashes($result->actual_price);?>"  /> <strong><?php echo $website_currency_code; ?></strong></td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>MRP Price:</strong></td>

<td align="left" class="paddBot11"><input name="mrp_price" type="text" id="mrp_price" size="20" value="<?php echo stripslashes($result->mrp_price);?>"  onkeyup="return calcPrice()"/> <strong><?php echo $website_currency_code; ?></strong></td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Discount:</strong></td>

<td align="left" class="paddBot11"><input name="discount" type="text" id="discount" size="20" value="<?php echo stripslashes($result->discount);?>"  onkeyup="return calcPrice()" />							          <strong> %</strong></td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Sell Price (After Discount) :</strong></td>

<td align="left" class="paddBot11"><input name="sell_price" type="text" id="sell_price" size="20" value="<?php echo stripslashes($result->sell_price);?>" />

</tr>
<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Wholesale Minimum Quantity :</strong></td>

<td align="left" class="paddBot11"><input name="minimum_quantity" type="text" id="sell_price" size="20" value="<?php echo stripslashes($result->wholesale_min);?>"  />

</td>

</tr>
								   <tr>

<td align="right" class="paddBot11 paddRt14"><strong>Wholesale Discount :</strong></td>

<td align="left" class="paddBot11"><input name="wholesale_discount" type="text" id="sell_price" size="20" value="<?php echo stripslashes($result->wholesale_discount);?>" />

</tr>
									 <tr>

<td align="right" class="paddBot11 paddRt14"><strong>IN Stock:</strong></td>

<input type="checkbox" name="in_stock" value="1" <?php if($result->in_stock==1 || $_REQUEST['id']==''){ ?>checked<?php } ?> />

</td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Use Image:</strong></td>

<?php $photo=getField('photo',$wholesale_product,$_REQUEST['product_id']);

if(is_file("../upload_images/product/thumb/".$photo)) {?>

</div>

<?php } ?>

<?php $imageArr=$obj->query("select distinct(pphoto) from $wholesale_productprice where  product_id='".$_REQUEST['product_id']."'  and pphoto!='' and pphoto!='$photo' ",$debug=-1);                  while($rsPhoto=$obj->fetchNextObject($imageArr)){

if(is_file("../upload_images/product/thumb/".$rsPhoto->pphoto)){?>

<img src="../upload_images/product/thumb/<?php echo $rsPhoto->pphoto; ?>" /><br/>

<input type="radio" name="pimage" value="<?php echo $rsPhoto->pphoto; ?>" />

</div>

<?php } }?>

</td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Or Upload New Image<br/>

(300 X 300px)(Not more than 100 KB):</strong></td>

<?php if(is_file("../upload_images/product/thumb/".$result->pphoto)) {?>

<img src="../upload_images/product/thumb/<?php echo  $result->pphoto; ?>" />

<?php } ?>

</td>

</tr>

<!--  <tr>

<?php if(is_file("../upload_images/product/barcode/".$result->barcode)) {?>

<img src="../upload_images/product/barcode/<?php echo  $result->barcode; ?>" />

<?php } ?>

</td>

</tr> -->

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Barcode Number:</strong></td>

<td align="left" class="paddBot11"><input name="barcode_number" type="text" id="barcode_number" size="36" value="<?php echo stripslashes($result->barcode_number);?>" />&nbsp;(Comma Separated Values Ex: 42204084,42204084,42204084)</td>

</tr>

<tr>

<td align="right" class="paddBot11 paddRt14"><strong>Video(YouTube URL):</strong></td>

<textarea name="video"  rows="5" cols="40"  id="video"><?php echo  $result->video; ?></textarea>						         </td>

</tr>

<tr>

</tr>

<tr>

<input type="submit" name="submit" value="Submit"  class="submit" border="0"/> 	                  		 &nbsp;&nbsp;

</tr>

</table></form>

</td>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

<?php include('footer.php'); ?>

</table>

</body>

</html>

Gel4y Mini Shell

Edit file