public function testDeletePayment()
{
$payment = getPaymentInstance('deletePayment');
$bmapper = new PaymentMapper(self::$pdo);
$bmapper->insert($payment);
$bmapper->delete($payment);
$allPayments = $bmapper->findAll()->fetchAll();
$this->assertEmpty($allPayments);
}
$data['amount'] = filter_var($post_data['amount'], FILTER_SANITIZE_STRING);
$mapper = new PaymentMapper($this->db);
$payment = $mapper->getPaymentById($data['id']);
$payment->setDate($data['date']);
$payment->setUnits($data['amount']);
$mapper->save($payment);
$response = $response->withRedirect("/index.php/payments");
return $response;
});
// Delete payment
$app->get('/payment/{id}/delete', function ($request, $response, $args) {
$id = (int) $args['id'];
$mapper = new PaymentMapper($this->db);
$payment = $mapper->getPaymentById($id);
$this->logger->info("Deleting payment" . $id);
$mapper->delete($payment);
$response = $response->withRedirect("/index.php/payments");
return $response;
});
/*Produce a report on the top three selling products of the Company (in terms of
total value of sales) during the past 12 months. List (among other details) the
name of the item, number of orders placed, number of items sold. */
/**********************QUERY ROUTES**********************/
// Products
$app->get('/products/query', function ($request, $response, $args) {
$this->logger->info("products query");
$mapper = new ProductQueryMapper($this->db);
$products = $mapper->processQuery();
return $this->renderer->render($response, 'queries/query_products.phtml', [$args, "products" => $products]);
});
/*
