atulga / qanda Goto Github PK

View Code? Open in Web Editor NEW

0.0 4.0 0.0 2.97 MB

Question and Answer

PHP 19.60% CSS 56.50% JavaScript 23.91%

qanda's Introduction

Q and A сайтын тохируулга

app/config/parameters.yml Файлд өөрийн database -ийн тохиргоог бичиж өгнө.

Хийгдсэн байх тохиргоонууд

app/cache, app.logs гэсэн хавтасуудад бүрэн эрх өгнө:
```
sudo chmod 777 app/cache app/logs
```

/etc/hosts - дээр host нэмэх:

echo "127.0.0.1 qanda.dev" | sudo tee -a/etc/hosts

apache-server - дээр qanda.local virtualhost тохируулах:

sudo cp qanda.local.def /etc/apache2/sites-available/qanda.local
sudo a2ensite qanda.local
sudo a2enmod rewrite
sudo service apache2 restart

CSS, Javascript гэх мэт static файлууд дээр өөрчлөлт орсоны дараа web дотор тэдгээрийг үүсгэж өгнө:
```
app/console assetic:dump
```

qanda's People

Contributors

Watchers

qanda's Issues

Review and verify #2 and #4

@temkagranat is working on #2 and #4 when he is done. He will assign to @norjoo (you).
Please check code changes for @temkagranat on the branch.
If there is something need to be improved on the change you can assign back to @temkagranat. If you think the change is fine and implemented correctly please assign to @ariunbayar (me).

New profile page for users

Let there be a page http://localhost/qanda/index.php/profile?user_id=5, assuming this page will show a user profile whose id is 5.

This page will list following user details:

Name (not username)
Description/Biography
Number of questions asked
Latest 5 questions
Number of answers
Latest 5 answers

Seems like we need to add new fields to User model, name and bio. Please allow the user to edit these fields on his/her profile page.

PS: don't forget to add SQL queries needed for the database in migration directory

Paginator as a class

Please allow to print paginator in template as follows:

<?php foreach ($pager->getPages() as $page) {?>
  <?php if ($pager->getCurrentPage() == $page){ ?>
    <?php echo $page ?>
  <?php }else{ ?>
    <a href="#"><?php echo $page ?></a>
  <?php } ?>
<?php } ?>

assuming $pager is an instance from Paginator class.

Question update needs to be improved

When a question needs to be saved, just save with one UPDATE query. Don't need ifs on line 169-181

Rewrite in SF2

Rewrite the whole application in symfony2 framework.

Rewrite models in Doctrine

Please rewrite current models.php completely in Doctrine. So that no mysql_* functions are used anymore.

Migration script

Please implement migration feature same as khas project.

Don't forget the README file.

Alert or Flash message

When user is registered into QandA, following message is shown:
"Та амжилттай бүртгэгдлээ, нэвтэрч орно уу"

Please change the UI (User Interface) for this message so that it will show in green box as shown in http://getbootstrap.com/components/#alerts

Please also show message for following cases:

Add question
Update question
Add answer
Edit profile

Insert twitter bootstrap template/design

Please add new design from http://getbootstrap.com/

404 page

Requirements

When I call error_404_action it should show a friendly 404 error page.

Code requirements

controller.php should have following content:

<?php
function error_404_action(){
    require_once 'templates/error_404.php';
}
?>

templates/error_404.php should have following content:

<?php $title = "Энэ хуудас олдсонгүй" ?>
<?php ob_start(); ?>
<!-- TODO -->
<?php $content = ob_get_clean() ?>
<?php require_once 'layout.php' ?>

templates/layout.php should have following content:

<html>
  <body><?php echo $content ?></body>
</html>

Table name in models

As we can see in model.php table name is used in every query. There might be a case that table name changes (asuult -> question).

Create new property protected $_table = 'table_name' in each of User, Question and Answer models and use this property in queries. For example:

class Question extends Model {
    protected $_table = 'asuult';
    // ...
    static public function getQuestionCount(){
        $sql = sprintf("SELECT COUNT(id) FROM %s", $this->_table);
        // ...
    }
}

Implement your changes in a new branch called I2_table_name_in_models.

Profile page and links

Please add a link to profile page on question show page for the question and answers.

Please translate descriptions for profile and edit profile pages.

Common functions to refactor

Please remove duplication for save and getById functions and place in Model class.

Some improvements are needed as these functions will serve for multiple models.