$html->set_variable('database_update_log', nl2br($update_log));
}
}
/********************************************************************************
*
* Show a warning if there are empty tables
* (categories, storelocations, footprints, suppliers)
*
*********************************************************************************/
if (!$fatal_error && !$database->is_update_required()) {
$good = "✔ ";
$bad = "✘ ";
try {
$missing_category = Category::get_count($database) == 0 ? $bad : $good;
$missing_storelocation = Storelocation::get_count($database) == 0 ? $bad : $good;
$missing_footprint = Footprint::get_count($database) == 0 ? $bad : $good;
$missing_supplier = Supplier::get_count($database) == 0 ? $bad : $good;
$display_warning = $missing_category == $bad || $missing_storelocation == $bad || $missing_footprint == $bad || $missing_supplier == $bad;
$html->set_variable('missing_category', $missing_category);
$html->set_variable('missing_storeloc', $missing_storelocation);
$html->set_variable('missing_footprint', $missing_footprint);
$html->set_variable('missing_supplier', $missing_supplier);
$html->set_variable('display_warning', $display_warning, 'boolean');
} catch (Exception $e) {
$messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
}
}
/********************************************************************************
*
* Show a warning if there are footprints with broken filenames
*
/********************************************************************************
*
* Set all HTML variables
*
*********************************************************************************/
if (!$fatal_error) {
try {
$noprice_parts = Part::get_noprice_parts($database, $current_user, $log);
$count_of_parts_with_price = Part::get_count($database) - count($noprice_parts);
// :-)
$html->set_variable('parts_count_with_prices', $count_of_parts_with_price, 'integer');
$html->set_variable('parts_count_sum_value', Part::get_sum_price_instock($database, $current_user, $log, true), 'string');
$html->set_variable('parts_count', Part::get_count($database), 'integer');
$html->set_variable('parts_count_sum_instock', Part::get_sum_count_instock($database), 'integer');
$html->set_variable('categories_count', Category::get_count($database), 'integer');
$html->set_variable('footprint_count', Footprint::get_count($database), 'integer');
$html->set_variable('location_count', Storelocation::get_count($database), 'integer');
$html->set_variable('suppliers_count', Supplier::get_count($database), 'integer');
$html->set_variable('manufacturers_count', Manufacturer::get_count($database), 'integer');
$html->set_variable('devices_count', Device::get_count($database), 'integer');
$html->set_variable('attachements_count', Attachement::get_count($database), 'integer');
$html->set_variable('footprint_picture_count', count(find_all_files(BASE . '/img/footprints/', true)), 'integer');
$html->set_variable('iclogos_picture_count', count(find_all_files(BASE . '/img/iclogos/', true)), 'integer');
} catch (Exception $e) {
$messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
$fatal_error = true;
}
}
/********************************************************************************
*
* Generate HTML Output