<?php require_once 'models/Answer.php'; use RedBean_Facade as R; $payload = $app->request()->getBody(); $params = array('userid' => 'userid', 'questionid' => 'questionid', 'answer' => 'answer'); $payload = array_intersect_key($payload, $params); if (empty($payload['questionid'])) { throw new \Exception('questionid is required!', 412); } $quetion = R::findOne('question', '`id` = ?', array($payload['questionid'])); if (!$quetion) { throw new \Exception('Question not found', 404); } $answer = new Answer($payload, $quetion); $answer->validateAnswer(); R::exec('INSERT INTO `answer` (`userid`, `questionid`, `answer`) VALUES (:userid, :questionid, :answer)', array(':userid' => $answer->getValue('userid'), ':questionid' => $answer->getValue('questionid'), ':answer' => $answer->getValue('answer'))); $app->result = $answer->getValues();
foreach ($survey_questions as $survey_question_id) { $question = new Question(); $question->get_from_db($survey_question_id); $question_title = $question->getTitle(); $question_answers = $question->get_answers(); // Add question title $objPHPExcel->setActiveSheetIndex($sheetId)->mergeCells('A1:N1'); $objPHPExcel->setActiveSheetIndex($sheetId)->setCellValue('A1', $question_title); // list answers $columnId = 2; $alphabetIteration = 0; foreach ($question_answers as $question_answer_id) { $answer = new Answer(); $answer->get_from_db($question_answer_id); $cell = divideBy26($columnId) . "2"; $cell_value = $answer->getValue(); // Add some data $objPHPExcel->setActiveSheetIndex($sheetId)->setCellValue($cell, $cell_value); $objPHPExcel->getActiveSheet()->getColumnDimension(divideBy26($columnId))->setWidth(15); $objPHPExcel->getActiveSheet()->getStyle($cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $columnId++; } // list users by question $row_id = 3; foreach ($voted_users as $voted_user_id) { $user = new User(); $user->get_from_db($voted_user_id); $cell = 'A' . $row_id; $user_number = $row_id - 2; $cell_value = 'User' . $user_number; // Add some data
$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()); ?> " <?php
// Multicell test $txt = '№'; $pdf->MultiCell(10, '', $txt, 1, 'C', 1, 0, '', '', true); $txt = 'Отговор'; $pdf->MultiCell(140, '', $txt, 1, 'C', 1, 0, '', '', true); $txt = 'Тип'; $pdf->MultiCell(30, '', $txt, 1, 'C', 1, 1, '', '', true); // set color for background $pdf->SetFillColor(255, 255, 255); $number_answer = 1; foreach ($answers as $answer_id) { $answer = new Answer(); $answer->get_from_db($answer_id); $txt = $number_answer; $pdf->MultiCell(10, '', $txt, 1, 'C', 1, 0, '', '', true); $txt = $answer->getValue(); $pdf->MultiCell(140, '', $txt, 1, 'C', 1, 0, '', '', true); $txt = $answer->getType(); $pdf->MultiCell(30, '', $txt, 1, 'C', 1, 1, '', '', true); $number_answer++; } $pdf->Ln(5); // set font $pdf->SetFont('freeserif', 'B', 14); $txt = 'Групи'; $pdf->Write(0, $txt, '', 0, 'C', true, 0, false, false, 0); // set color for background $pdf->SetFillColor(225, 225, 225); // set font $pdf->SetFont('freeserif', '', 12); // Multicell test