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 validate(Product $oProduct, User $oUser)
{
$sQuery = " update comment";
$sQuery .= " SET validated = 1";
$sQuery .= " WHERE product_id = " . $oProduct->getId();
$sQuery .= " AND user_email = '" . $oUser->getEmail() . "'";
$iRetExec = DBOperation::exec($sQuery);
if (null !== ($sLastSqlError = DBOperation::getLastSqlError())) {
throw new \Exception($sLastSqlError);
}
}
public static function get(User $oUser)
{
$sQuery = "select * from user where email ='{$oUser->getEmail()}' limit 1";
return self::convertToObject(DBOperation::getOne($sQuery));
}
