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