query("SELECT id, name FROM departments WHERE $items = mysqli_query($conn, "SELECT id, item_code, item_name FROM items WHERE status = 1 ORDER BY item_name");$items = mysqli_query($conn, "SELECT id, item_code, item_name FROM items ORDER BY item_name"); ORDER BY name ASC"); // Get items with current average rate and available stock $items = $conn->query(" SELECT i.*, c.name as category_name, COALESCE(SUM(CASE WHEN st.transaction_type IN ('opening', 'in') THEN st.quantity ELSE 0 END), 0) - COALESCE(SUM(CASE WHEN st.transaction_type = 'out' THEN st.quantity ELSE 0 END), 0) as available_stock, COALESCE(i.current_average_rate, 0) as current_rate FROM items i LEFT JOIN categories c ON i.category_id = c.id LEFT JOIN stock_transactions st ON i.id = st.item_id WHERE i.status = 1 GROUP BY i.id HAVING available_stock > 0 ORDER BY i.item_name ASC "); ?>

New Issue

Back to History

Date *

Department *

Issued To *

Remarks

Add Items

Available: 0 | Rate: 0.00

Item Code	Item Name	Unit	Rate	Available	Quantity	Total	Action
No items added yet. Select an item above.
Total Items: 0 \| Total Quantity: 0 \| Total Value: 0.00