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));
 }