public function index()
 {
     $user = new user();
     $product = new products();
     $totalUsers = $user->getUsersCount();
     $totalProducts = $product->getProductsCount();
     $lastUser = $user->getLastUser()->name;
     $product->getAllProducts();
     $lastProduct = $product->getLastProduct()->name;
     $totalProductsValue = $product->totalValue();
     $totalProductsAmount = $product->totalAmount();
     require_once 'view/index_view.php';
 }
 public function search()
 {
     $query = $_POST['query'];
     $products = new products();
     if ($products->getProductsSearch($query) != null) {
         $allProducts = $products->getProductsSearch($query);
         $totalAmount = $products->totalAmount();
         $totalValue = $products->totalValue();
         $this->success = true;
         $this->msg = "A pesquisa obteve sucesso! Mostrando resultados para " . $query;
     } else {
         $this->success = false;
         $this->msg = "A sua pesquisa não obteve nenhum resultado. Mostrando todos os produtos:";
         $products = new products();
         $allProducts = $products->getAllProducts();
         $totalAmount = $products->totalAmount();
         $totalValue = $products->totalValue();
     }
     $success = $this->success;
     $msg = $this->msg;
     require_once 'view/product_lister_view.php';
 }