kingofmyheart / booboo Goto Github PK

#Booboo ##the fanciest online auction system

To push the changes.

• git add .
• git commit -m "message"
• git push origin master

To pull the changes.

• git fetch
• git pull --rebase

#####Composer Install Composer for Mac OSX

Install Composer for Windows

#####Bower Install Bower

#####MySQL

1. mysqladmin -u root -p password
2. SET GLOBAL event_scheduler = ON;
3. Enter the following code:

DELIMITER $$

CREATE 
  EVENT `end_auctions` 
  ON SCHEDULE EVERY 5 MINUTE
  DO BEGIN
  
    -- calculate winner and end auction
    UPDATE
      auction,
      (
      SELECT
        bid.buyerID AS BuyerID,
        bid.bidValue AS BidValue,
        auction.id AS AuctionID
      FROM
        auction
      INNER JOIN
        bid ON bid.auctionID = auction.id
      WHERE
        auction.ended = 0 AND auction.endAt < NOW() AND bid.bidValue =(
        SELECT
          MAX(bid.bidValue)
        FROM
          bid
        WHERE
          bid.createdAt =(
          SELECT
            MIN(bid.createdAt)
          FROM
            bid
          WHERE
            bid.auctionID = auction.id
        )
      )
      ORDER BY
        bid.createdAt ASC
      ) src
      SET
        auction.ended = 1,
        auction.winnerID = src.BuyerID
      WHERE
        auction.id = src.AuctionID
      
  END */$$

DELIMITER ;

4. to drop the event, run

DROP EVENT `end_auctions`

Start the server: php app/console server:start

(Look for relevant controller for more info)

###How to embed views in other views

1. Embed bid form in auction's page

Views: bid/bid.html.twig auction/show.html.twig

Copy

{{ include('bid/bid.html.twig', { 'bid_form': bid_form }) }}

from bid/bid.html.twigand paste it somewhere in auction/show.html.twig

Please delete the example code wrapped in div.delete-us

2. Embed auction list in user's profile Views: auction/auction_row.html.twig user/show.html.twig

Follow the instruction in auction/auction_row.html.twig

Copy i.e.

{% for auction in buyingArray %}
{{ include('auction/auction.html.twig', { 'auction': auction }) }}
{% endfor %}

from auction/auction_row.html.twig to user/show.html.twig

Please delete everything and write HTML code for rendering the row for each auction in auction_row.html.twig

###Feedback This feature consists of two steps. First of all, in user's profile page, only for bought and sold item, you should check if, i.e, bought["canFeedback"] is true, and display an feedback button Secondly, when user clicks on feedback button, it should take user to /feedback/{auctionID}. This page will show basic information about the auction and a feedback form. Upon submission, it will redirect user back to his/her profile page.

Javascript and CSS files are combined in a unified file. Please refer to base.html.twig to see the update(within javascript and css block respectively).