57 lines
2.3 KiB
PHP
57 lines
2.3 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
include ('log_entry.php');
|
|
error_log ( "Start Printing Request Attributes" );
|
|
$requestStr="";
|
|
foreach ( $_REQUEST as $key => $value ) {
|
|
$requestStr.=$key . " : " . $value . "\n";
|
|
error_log ( $key . " : " . $value . "<br />\r\n" );
|
|
}
|
|
error_log ( "End Printing Request Attributes" );
|
|
save_log($requestStr,'procurement item','SAVE','item_rate.php');
|
|
$id = $_POST['id'];
|
|
$vendor = $_POST['vendor'];
|
|
$new_rate = $_POST['new_rate'];
|
|
$item_id =$_POST['item_id'];
|
|
$remarks = $_POST['remarks'];
|
|
$mrp = $_POST['net_value'];
|
|
$mrp_rate = $_POST['mrp'];
|
|
$gst = $_POST['gst'];
|
|
$discount = $_POST['discount'];
|
|
$stock_qty = $_POST['stock_qty'];
|
|
|
|
|
|
error_log("update procurment__item_rate id: ".$id."item_id: ".$item_id."batch: ".$item_batch_no."desc: ".$mrp.'new_rate'.$new_rate);
|
|
|
|
if(!empty($id)){
|
|
|
|
if(!empty($new_rate)){
|
|
$query_history = "insert into item_rate_change_history set item_id = '$item_id',vendor_id = '$vendor', old_rate = '$mrp', new_rate = '$new_rate' , modified_by = '".$_SESSION['user_id']."' ,remarks = '$remarks' ,procurement_item_id = '".$id."'";
|
|
error_log('rate change history '.$query_history);
|
|
if (!$result_history = @mysqli_query($conn,$query_history)) {
|
|
exit(mysqli_error($conn));
|
|
}
|
|
|
|
|
|
$query = "update item_rate set item_id = '$item_id', item_rate = '$new_rate',unit = '$stock_qty',gst = '$gst',mrp = '$mrp_rate',discount='$discount' where item_rate_id = '".$id."'";
|
|
$query_vendor = "update tbl_items set vendor_id = '$vendor' where item_id = '".$item_id."'";
|
|
}
|
|
|
|
|
|
else{$query = "update item_rate set item_id = '$item_id', item_rate = '$mrp',unit = '$stock_qty',gst = '$gst',mrp = '$mrp_rate',discount='$discount' where item_rate_id = '".$id."'";}
|
|
$query_vendor = "update tbl_items set vendor_id = '$vendor' where item_id = '".$item_id."'";
|
|
}
|
|
else{
|
|
$query = "insert item_rate set item_id = '$item_id', item_rate = '$mrp',unit = '$stock_qty',gst = '$gst',mrp = '$mrp_rate',discount='$discount' ";
|
|
$query_vendor = "update tbl_items set vendor_id = '$vendor' where item_id = '".$item_id."'";
|
|
}
|
|
error_log('save_query_item_rate '.$query_vendor);
|
|
if (!$result = @mysqli_query($conn,$query)) {
|
|
exit(mysqli_error($conn));
|
|
}
|
|
if (!$result_vendor = @mysqli_query($conn,$query_vendor)) {
|
|
exit(mysqli_error($conn));
|
|
}
|
|
|
|
?>
|