public static function setOrder(Order $order)
{
$query = "INSERT INTO commandes (prix, id_user)\n\t\t\tVALUES ('" . $order->getPrice() . "','" . $order->getIdUser() . "')";
DBOperation::exec($query);
$lastId = DBOperation::getLastId();
foreach ($_SESSION["cart"] as $product) {
$query = "INSERT INTO produits_commandes (id_produit, id_commande, quantity)\n\t\t\t\tVALUES ('" . $product->getId() . "','" . $lastId . "','" . $product->getQuantity() . "')";
DBOperation::exec($query);
}
}
public static function addProduct($name, $description, $price)
{
$query = "INSERT INTO produits (nom, description, prix)\n\t\t\tVALUES ('" . $name . "', '" . $description . "', '" . $price . "')";
DBOperation::exec($query);
$lastId = DBOperation::getLastId();
$directory = ROOT . "img/";
$file = basename($_FILES['link']['name']);
$extension = ".jpg";
if (strrchr($_FILES['link']['name'], '.') == $extension) {
if (!move_uploaded_file($_FILES['link']['tmp_name'], $directory . $file)) {
echo 'Failed...';
}
}
$query = "INSERT INTO images (link, id_produit)\n\t\t\tVALUES ('" . $_FILES['link']['name'] . "', '" . $lastId . "')";
DBOperation::exec($query);
}
public static function save($aProducts, User $oUser)
{
if (count($aProducts) === 0) {
return false;
}
$dDate = date('Y-m-d H:i:s');
$fTotal = self::getTotal();
// create order
$sQuery = "insert into orders(user_email,date,total) values('{$oUser->getEmail()}','{$dDate}',{$fTotal})";
if (!DBOperation::exec($sQuery)) {
return false;
}
$iOrderId = DBOperation::getLastId();
foreach ($aProducts as $oCartProduct) {
$sQuery = "insert into order_product(order_id,product_id,quantity) values({$iOrderId},\n {$oCartProduct->getId()},{$oCartProduct->getQuantity()})";
if (!DBOperation::exec($sQuery)) {
return false;
}
}
return true;
}
public static function create(Product $oProduct)
{
$sName = addslashes($oProduct->getName());
$sDescription = addslashes($oProduct->getDescription());
$sImage = addslashes($oProduct->getImage());
$fPrice = floatval($oProduct->getPrice());
$sQuery = 'insert into product(name,description,image,price) values(';
$sQuery .= "'{$sName}','{$sDescription}','{$sImage}','{$fPrice}'";
$sQuery .= ')';
$bSuccess = DBOperation::exec($sQuery);
if (!$bSuccess) {
return null;
}
// get last id
$iProductId = DBOperation::getLastId();
// insert categories
$aCategories = $oProduct->getCategories();
if (count($aCategories) > 0) {
foreach ($aCategories as $oCategory) {
$sQuery = 'insert into product_category(product_id,category_id) values(';
$sQuery .= "'{$iProductId}','{$oCategory->getId()}'";
$sQuery .= ')';
DBOperation::exec($sQuery);
}
}
return $iProductId;
}
