public function sell()
{
if (!isset($_SESSION['userId'])) {
header('Location: /php_project/application/public/');
exit;
}
$order_id = $this->input->get(0);
$product_id = $this->input->get(1);
$productDb = new \Models\Product();
$orderDb = new \Models\Order();
$order = $orderDb->get('order_id = ' . $order_id)[0];
$product = $productDb->get('product_id=' . $product_id)[0];
if (!is_numeric($product_id) || !is_numeric($order_id) || !$product || !$order) {
header('Location: /php_project/application/public/');
exit;
}
$orderDb->update('order', array('order_id' => $order_id, 'status' => 'deleted'));
if ($this->user == null) {
$this->getUser();
}
$price = $product['price'];
if ($product['promotion_id'] != null) {
$promoDb = new \Models\Promotion();
$discount = $promoDb->get('promotion_id = ' . $product['promotion_id'])[0]['discount'];
if ($discount > 0) {
$price = $price - $price * $discount / 100;
}
}
$this->userDb->update('user', array('user_id' => $_SESSION['userId'], 'cash' => $this->user['cash'] + $price));
$sellProduct['product_id'] = $product_id;
$sellProduct['quantity'] = $product['quantity'] + 1;
$productDb->update('product', $sellProduct);
header('Location: /php_project/application/public/user/profile');
}
public function index()
{
if (!isset($_SESSION['userId']) && $_SESSION['editor'] != true && $_SESSION['admin'] != true) {
header('Location: /php_project/application/public/');
exit;
}
$categories = new \Models\Category();
$allCategories = $categories->find();
$products = new \Models\Product();
$allProducts = $products->find();
$promotionDb = new \Models\Promotion();
$allPromos = $promotionDb->find();
$data = array();
$data[] = $allCategories;
$data[] = $allProducts;
$data[] = $allPromos;
$this->view->appendToLayout('body', 'editorIndex');
$this->view->display('layouts.default', $data);
}
public function promo()
{
if (!isset($_SESSION['userId']) && $_SESSION['editor'] != true && $_SESSION['admin'] != true) {
header('Location: /php_project/application/public/');
exit;
}
$promoDb = new \Models\Promotion();
$product_id = $this->input->get(0);
$productDb = new \Models\Product();
$product = $productDb->get('product_id=' . $product_id)[0];
if (isset($_POST['name'])) {
$updateProduct = array();
$promoName = $_POST['name'];
$promotion = $promoDb->get('promotion_name = "' . $promoName . '"')[0];
if ($product['promotion_id'] == null) {
$updateProduct['promotion_id'] = $promotion['promotion_id'];
$updateProduct['product_id'] = $product['product_id'];
$productDb->update('product', $updateProduct);
header('Location: /php_project/application/public/editor/index');
exit;
} else {
$oldPromo = $promoDb->get('promotion_id = ' . $product['promotion_id'])[0];
if ($oldPromo['discount'] >= $promotion['discount']) {
header('Location: /php_project/application/public/editor/index');
exit;
} else {
$updateProduct['promotion_id'] = $promotion['promotion_id'];
$updateProduct['product_id'] = $product['product_id'];
$productDb->update('product', $updateProduct);
header('Location: /php_project/application/public/editor/index');
exit;
}
}
}
if (!is_numeric($product_id) || !$product) {
header('Location: /php_project/application/public/');
exit;
}
$promos = $promoDb->find();
$this->view->appendToLayout('body', 'addPromoProduct');
$this->view->display('layouts.default', $promos);
}
public function remove()
{
if (!isset($_SESSION['userId']) && $_SESSION['admin'] != true) {
header('Location: /php_project/application/public/');
exit;
}
$promotionDb = new \Models\Promotion();
$promotion_id = $this->input->get(0);
$promotion = $promotionDb->get('promotion_id=' . $promotion_id)[0];
if (!is_numeric($promotion_id) || !$promotion) {
header('Location: /php_project/application/public/');
exit;
}
$updatePromotion = array();
$updatePromotion['promotion_id'] = $promotion_id;
$updatePromotion['deleted'] = true;
$promotionDb->update('promotion', $updatePromotion);
header('Location: /php_project/application/public/editor/index');
exit;
}
public function add()
{
if (!isset($_SESSION['userId']) && $_SESSION['editor'] != true && $_SESSION['admin'] != true) {
header('Location: /php_project/application/public/');
exit;
}
if (isset($_POST['promotion_name']) && isset($_POST['discount'])) {
$cleaner = new \Framework\Common();
$newPromo = array();
$newPromo['promotion_name'] = $cleaner->normalize($_POST['promotion_name'], 'trim|xss|string');
$newPromo['discount'] = $cleaner->normalize($_POST['discount'], 'trim|xss|int');
$newPromo['user_id'] = $_SESSION['userId'];
$promoDb = new \Models\Promotion();
$promoDb->add($newPromo);
header('Location: /php_project/application/public/editor/index');
exit;
}
$this->view->appendToLayout('body', 'addPromotion');
$this->view->display('layouts.default');
}
