* Consumable stock */ // Get consumables $sql = "SELECT\n\t\tconsumables.*,\n\t\t( round( ( (consumables.qty) / (SELECT MAX(qty) FROM consumables) ) * 100 ) ) AS qty_percent,\n\t\tGROUP_CONCAT(CAST(CONCAT(manufacturers.name, ' ', models.name) AS CHAR) SEPARATOR ', ') AS model\n\t\tFROM consumables\n\t\tLEFT JOIN consumables_models ON consumables.id = consumables_models.consumable_id\n\t\tLEFT JOIN models ON consumables_models.model_id = models.id\n\t\tLEFT JOIN manufacturers ON models.manufacturer_id = manufacturers.id\n\t\tGROUP BY consumables.id\n\t\tORDER BY models.name ASC, consumables.name ASC"; $consumables = $db->query($sql)->asObjects(); // Get the most consumables in stock $sql = 'SELECT MAX(qty) AS max FROM consumables'; $max_consumables = $db->query($sql)->fetchRow(); $max_consumables = $max_consumables['max']; /** * Quick add */ // List of printers $printers = Printer::getSimple($db); // List of models and which consumables are available $models_consumables = Consumable::getForModels($db); $models_consumables_json = fJSON::encode($models_consumables); ?> <br /> <div class="grid_5 suffix_1"> <?php include 'views/home/quickadd.php'; ?> </div> <div class="grid_6"> <?php include 'views/home/stock.php'; ?>
