PHP Answer::getId方法代码示例

 function test_findById()
 {
     //Arrange
     $test_field = "Joe FindById";
     $test_quest_id = 1;
     $test_answer = new Answer($test_field, $test_quest_id);
     $test_answer->save();
     $test_field2 = "Red FindById";
     $test_quest_id2 = 2;
     $test_answer2 = new Answer($test_field2, $test_quest_id2);
     $test_answer2->save();
     //Act
     $result = Answer::findById($test_answer->getId());
     //Assert
     $this->assertEquals($test_answer, $result);
 }

 /**
  * 
  * @param Answer $answer
  * @return int id of the Answer inserted in base. False if it didn't work.
  */
 public static function flush($answer)
 {
     $answerId = $answer->getId();
     $answerVar = $answer->getAnswer();
     $answerDate = $answer->getAnswerDate();
     $likert = $answer->getLikert()->getId();
     $user = $answer->getUser()->getId();
     $question = $answer->getQuestion()->getId();
     if ($answerId > 0) {
         $sql = 'UPDATE answer a SET ' . 'a.answer = ?, ' . 'a.answer_date = ?, ' . 'a.LIKERT_id_likert = ?, ' . 'a.USER_id_user = ?, ' . 'a.QUESTION_id_question = ? ' . 'WHERE a.id_answer = ?';
         $params = array('ssiiii', &$answerVar, &$answerDate, &$likert, &$user, &$question, &$answerId);
     } else {
         $sql = 'INSERT INTO answer ' . '(answer, answer_date, LIKERT_id_likert, USER_id_user, QUESTION_id_question) ' . 'VALUES(?, ?, ?, ?, ?)';
         $params = array('ssiii', &$answerVar, &$answerDate, &$likert, &$user, &$question);
     }
     $idInsert = BaseSingleton::insertOrEdit($sql, $params);
     if ($idInsert !== false && $answerId > 0) {
         $idInsert = $answerId;
     }
     return $idInsert;
 }

                    $answer = new Answer();
                    $answer->get_from_db($answer_id);
                    $vote = new Vote();
                    $vote_id = 0;
                    $user_vote_by_answer = array();
                    $user_vote_by_answer = get_user_vote_by_answer($user_id, $answer_id);
                    if (!empty($user_vote_by_answer)) {
                        $vote_id = $user_vote_by_answer[0];
                        $vote->get_from_db($vote_id);
                    }
                    ?>
                                            <label for = "formSurvey<?php 
                    print_r($question->getId());
                    ?>
Answer<?php 
                    print_r($answer->getId());
                    ?>
"><?php 
                    print_r($answer->getValue());
                    ?>
                                                <small><?php 
                    print_r($answer->getDescription());
                    ?>
</small>
                                            </label>
                                            <input 
                                                id="formSurvey<?php 
                    print_r($question->getId());
                    ?>
Answer<?php 
                    print_r($answer->getId());

 function test_getAnswers()
 {
     //Arrange
     $test_field = "What is their name?";
     $test_description = "What you want to call your character.";
     $test_question = new Question($test_field, $test_description);
     $test_question->save();
     $test_field = "Joe GetAll";
     $test_quest_id = $test_question->getId();
     $test_answer = new Answer($test_field, $test_quest_id);
     $test_answer->save();
     //Act
     $test_question->addAnswer($test_answer->getId());
     //Assert
     $result = $test_question->getAnswers($test_answer->getId());
     $this->assertEquals($test_answer, $result[0]);
 }

    }
});
// QUESTION.HTML.TWIG -- needs fixed -- if a question has been deleted, id # is skipped and
// end_flag = true. Need to somehow loop through just the questions in promptr->getQuestions
// the following pages of promptr run -- adding more answers
$app->post("/promptr/{id}/question/{quid}", function ($id, $quid) use($app) {
    $promptr = Promptr::find($id);
    $end_flag = false;
    $answer_field = $_POST['answer'];
    $new_answer = new Answer($answer_field, $quid);
    $new_answer->save();
    ++$quid;
    $question = Question::findTempById($quid);
    $questions = Question::getTempQuestions();
    if ($question != null) {
        $question->addAnswer($new_answer->getId());
        $last_question = end($questions);
        if ($question == $last_question) {
            $end_flag = true;
        }
    }
    return $app['twig']->render('question.html.twig', array('question' => $question, 'end' => $end_flag, 'promptr' => $promptr, 'questions' => $questions));
});
// DISPLAY.HTML.TWIG
// DISPLAY FINISHED answers to promptr run
//will show the concatted together display of the list
$app->get("/promptr/{id}/display", function ($id) use($app) {
    $promptr = Promptr::find($id);
    $questions = Question::getTempQuestions();
    Question::deleteTempQuestions();
    return $app['twig']->render('display.html.twig', array('promptr' => $promptr, 'questions' => $questions));

                              method="POST">
                            <div class="ac">
                                <section class="clearfix prefix_2">
                                    <?php 
            $answers = get_survey_answers($question->getId());
            if (!empty($answers)) {
                foreach ($answers as $answer_id) {
                    $answer = new Answer();
                    $answer->get_from_db($answer_id);
                    if ($answer->getType() == "text" || $answer->getType() == "radio" || $answer->getType() == "checkbox") {
                        ?>
                                                <label for = "formSurvey<?php 
                        print_r($session_survey->getId());
                        ?>
Answer<?php 
                        print_r($answer->getId());
                        ?>
"><?php 
                        print_r($answer->getValue());
                        ?>
                                                    <small><?php 
                        print_r($answer->getDescription());
                        ?>
</small>
                                                </label>
                                                <input id="formSurvey<?php 
                        print_r($session_survey->getId());
                        ?>
Answer<?php 
                        print_r($answer->getId());
                        ?>

        $group_votes += $group_answer_votes;
        $txt = $group_answer_votes;
        $pdf->MultiCell($result_field_width, '', $txt, 1, 'C', 1, 0, '', '', true, 0, false, true, 8, 'M');
        $number_answer++;
    }
    $pdf->MultiCell(20, '', "{$group_votes}", 1, 'C', 1, 1, '', '', true, 0, false, true, 8, 'M');
    $number_group++;
}
// set color for background
$pdf->SetFillColor(225, 225, 225);
$pdf->MultiCell(20, '', "Всички", 1, 'C', 1, 0, '', '', true, 0, false, true, 8, 'M');
// set color for background
$pdf->SetFillColor(255, 255, 255);
foreach ($answers as $answer_id) {
    $answer = new Answer();
    $answer->get_from_db($answer_id);
    $txt = count(get_votes_by_answer($answer->getId()));
    $pdf->MultiCell($result_field_width, '', $txt, 1, 'C', 1, 0, '', '', true, 0, false, true, 8, 'M');
}
// set color for background
$pdf->SetFillColor(240, 240, 240);
$pdf->MultiCell(20, '', 'Общо', 1, 'C', 1, 1, '', '', true, 0, false, true, 8, 'M');
// ---------------------------------------------------------
ob_end_clean();
// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$pdf->Output('survey_print.pdf', 'I');
//============================================================+
// END OF FILE
//============================================================+
unset($_SESSION['survey_id']);