Simple Dashboard NEW Bootstrap 4.5 theme
Simple Dashboard using panels
HIDE CODE
<style>
.dashboard-counter{
float: left;
margin: 5px;
display: inline-block;
border-radius: 50%;
width: 60px;
height: 60px;
background-color: #FF7F50;
text-align: center;
line-height: 56px;
color: white;
font-weight: bold;
font-size: 38px;
}
div.xcrud-row {
width: 32%;
overflow: hidden!important;
float: left;
border: 1px solid #e5e5e5;
margin-top: 10px;
margin-left: 2px;
padding: 20px;
max-height: 150px!important;
min-height: 150px!important;
background: #f9f3f3;
border-radius: 10px;
}
div.xcrud-row span:not(.slider) {
font-size:20px!important;
font-weight:bold!important;
}
</style>
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table("order_counts_view");// This is a view
$xcrud->column_callback("Count","getDashboardValue");
$xcrud->unset_add();
$xcrud->unset_edit();
$xcrud->unset_remove();
$xcrud->unset_view();
$xcrud->unset_csv();
$xcrud->unset_limitlist();
$xcrud->unset_numbers();
$xcrud->unset_pagination();
$xcrud->unset_print();
$xcrud->unset_search();
$xcrud->unset_title();
$xcrud->unset_sortable();
$xcrud->panel_view(true,4);
echo $xcrud->render();
?>
xCRUDQuery error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xcrud1_7_v7.order_counts_view' doesn't exist
SHOW COLUMNS FROM `order_counts_view`