Invalid quantity.
";
}else{
$receipt='';
if(isset($_FILES['receipt']) && $_FILES['receipt']['error']==0){
$allowed=['pdf','png','jpg','jpeg'];
$ext=strtolower(pathinfo($_FILES['receipt']['name'],PATHINFO_EXTENSION));
if(in_array($ext,$allowed)){
if(!is_dir('uploads/receipts')){
mkdir('uploads/receipts',0777,true);
}
$receipt='uploads/receipts/'.time().'_'.preg_replace('/[^A-Za-z0-9._-]/','_',$_FILES['receipt']['name']);
move_uploaded_file($_FILES['receipt']['tmp_name'],$receipt);
}
}
$stmt=$conn->prepare("SELECT id,quantity FROM products WHERE product_type=? AND brand_name=? LIMIT 1");
$stmt->bind_param("ss",$product_type,$brand_name);
$stmt->execute();
$result=$stmt->get_result();
if($result->num_rows){
$p=$result->fetch_assoc();
$newQty=$p['quantity']+$quantity;
$up=$conn->prepare("UPDATE products SET quantity=? WHERE id=?");
$up->bind_param("ii",$newQty,$p['id']);
$up->execute();
}else{
$ins=$conn->prepare("
INSERT INTO products(product_name,product_type,brand_name,quantity,price)
VALUES(?,?,?,?,0)");
$ins->bind_param("sssi",$product_type,$product_type,$brand_name,$quantity);
$ins->execute();
}
$hist=$conn->prepare("
INSERT INTO warehouse_receiving
(vendor_id,product_type,brand_name,quantity,receipt)
VALUES(?,?,?,?,?)");
$hist->bind_param("issis",$vendor_id,$product_type,$brand_name,$quantity,$receipt);
$hist->execute();
$message="Product received successfully.
";
}
}
/* ================= RECEIVING HISTORY ================= */
$sql="
SELECT wr.*,v.vendor_name
FROM warehouse_receiving wr
LEFT JOIN vendors v ON v.id=wr.vendor_id
WHERE 1=1
";
$params=[];
$types='';
if($search!=''){
$sql.=" AND (v.vendor_name LIKE ? OR wr.product_type LIKE ? OR wr.brand_name LIKE ?)";
$like="%$search%";
$params[]=&$like; $params[]=&$like; $params[]=&$like;
$types.="sss";
}
if($date_from!=''){
$sql.=" AND DATE(wr.received_date)>=?";
$params[]=&$date_from;
$types.="s";
}
if($date_to!=''){
$sql.=" AND DATE(wr.received_date)<=?";
$params[]=&$date_to;
$types.="s";
}
$sql.=" ORDER BY wr.received_date DESC";
$stmt=$conn->prepare($sql);
if($types!=''){
array_unshift($params,$types);
call_user_func_array([$stmt,'bind_param'],$params);
}
$stmt->execute();
$receivingHistory=$stmt->get_result();
/* ================= LOW STOCK ================= */
$lowStock=$conn->query("SELECT * FROM products WHERE quantity<=$low_stock_limit ORDER BY quantity ASC");
include 'includes/header.php';
include 'includes/navbar.php';
include 'includes/sidebar.php';
?>
Low Stock Alerts
fetch_assoc()){ ?>
:
remaining
Warehouse Receiving
Receiving History
| Date |
Vendor |
Type |
Brand |
Qty |
Receipt |
Actions |
fetch_assoc()){ ?>
|
|
|
|
|
View
No Receipt
|
Edit
Delete
|