public static function getTotalCount() : int { $db = DataBaseHelper::getConnection(); $handle = $db->prepare('SELECT COUNT(*) FROM Orders;'); $handle->execute(); $amount = (int) $handle->fetchColumn(); //close database connection $db = null; return $amount ?? 0; }
public static function getTopByNumOfOrders($dateFrom = null, $dateTo = null, int $limit = 10) : array { $db = DataBaseHelper::getConnection(); list($dateFrom, $dateTo) = DateHelper::formatDates($dateFrom, $dateTo); $handle = static::queryTopByNumOfOrders($dateFrom, $dateTo, $limit, $db); // create customers foreach ($handle as $customer) { $customers[] = static::createNew($customer); } //close database connection $db = null; return $customers ?? []; }