/** Get the list of all attachments */ public function actionAllattachment() { if (Yii::$app->request->post()) { $value = \Yii::$app->request->post(); $congress = $value['congress']; $sda_id = isset($value['sda_id']) && $value['sda_id'] > 0 ? $value['sda_id'] : ""; if ($congress) { if ($sda_id > 0) { $records_sda = \backend\models\SdaAttachments::find()->where(['congress_id' => $congress, 'sda_id' => $sda_id, 'sda_feedback_id' => null])->all(); } else { $records_sda = \backend\models\SdaAttachments::find()->where(['congress_id' => $congress])->all(); } $records_meeting = \backend\models\MeetingAttachments::find()->where(['congress_id' => $_POST['congress']])->all(); $return = []; $data = []; foreach ($records_sda as $row) { $protocol = stripos($_SERVER['SERVER_PROTOCOL'], 'https') === true ? 'https://' : 'https://'; $host = $_SERVER['HTTP_HOST']; $congressname = CongressDetails::findOne($row['congress_id'])->name; unset($row['sda_feedback_id']); unset($row['session_id']); $row = $row->toArray(); $filename = explode("/", $row['path']); $filenames = end(explode(".", $filename[1])); $data['filename'] = str_replace($filenames, "", $filename[1]); $data['filename'] = str_replace(".", "", $filename[1]); $data['filetype'] = $filenames; $data['path'] = $protocol . $host . "/rest/backend/web/" . $row['path']; $data['exits'] = file_exists($_SERVER['DOCUMENT_ROOT'] . '/rest/backend/web/' . $row['path']); $return['sda'][] = $data; } $data2 = []; foreach ($records_meeting as $row) { $protocol = stripos($_SERVER['SERVER_PROTOCOL'], 'https') === true ? 'https://' : 'https://'; $host = $_SERVER['HTTP_HOST']; $row = $row->toArray(); $type = \backend\models\MeetingTypes::findOne($row['meeting_type_id']); $congressname = CongressDetails::findOne($row['congress_id'])->name; unset($row['meeting_type_id']); $filename = explode("/", $row['path']); $filenames = end(explode(".", $filename[1])); $data2['filename'] = str_replace($filenames, "", $filename[1]); $data2['filename'] = str_replace(".", "", $filename[1]); $data2['filetype'] = $filenames; $data2['path'] = $protocol . $host . "/rest/backend/web/" . $row['path']; $data2['exits'] = file_exists($_SERVER['DOCUMENT_ROOT'] . '/rest/backend/web/' . $row['path']); $return['meeting'][] = $data2; } return $return; } else { return "parameter missing"; } } else { return 'invalid method'; } }
/** * Upload attachment for SDA * @param int $id * @return mixed */ public function actionUploadsda($id) { $id = (int) $id; $model1 = new SdaAttachments(); if ($model1->load(Yii::$app->request->post())) { //If request is post $model1->path = UploadedFile::getInstances($model1, 'path'); foreach ($model1->path as $files) { if ($files->saveAs('uploads/' . $files->baseName . '.' . $files->extension)) { $model1->congress_id = $id; $filesize = $files->size; $filetype = $files->extension; $path = "uploads/" . $files->name; $cong = Sda::find()->where(['id' => $id])->one(); $congressid = $cong['congress_id']; Yii::$app->db->createCommand("insert into sda_attachments(sda_id,path,congress_id,size,type)values('{$id}','{$path}','{$congressid}','{$filesize}','{$filetype}')")->execute(); } } return $this->redirect(array("sda/update", 'id' => $id)); } }
public function actionCreate() { $model = new SdaFeedback(); $request = Yii::$app->request; $data = json_decode($request->post('data'), true); $congress_id = isset($data['congress_id']) ? $data['congress_id'] : ""; $sda_id = isset($data['sda_id']) ? $data['sda_id'] : ""; $session_id = isset($data['session_id']) ? $data['session_id'] : ""; $additional_data = isset($data['additional_data']) ? $data['additional_data'] : ""; $ol_feedback = isset($data['ol_feedback']) ? $data['ol_feedback'] : ""; $ques_ans = !empty($data['ques_ans']) ? $data['ques_ans'] : []; $takeaway_summary = !empty($data['takeaway_summary']) ? $data['takeaway_summary'] : []; $audience_size = isset($data['audience_size']) && $data['audience_size'] != "" ? $data['audience_size'] : 0; $debrief = isset($data['debrief']) && $data['debrief'] != "" ? $data['debrief'] : 0; $attendee_id = isset($data['attendee_id']) && $data['attendee_id'] != "" ? $data['attendee_id'] : ""; $imageCount = isset($data['imageCount']) && $data['imageCount'] != "" ? $data['imageCount'] : ""; $user_id = isset($data['user_id']) && $data['user_id'] != "" ? $data['user_id'] : ""; $is_active = 1; $datas = \Yii::$app->db->createCommand("select id from sda_feedback WHERE sda_id=:sda_id and congress_id=:congress_id and user_id=:user_id")->bindValue(':sda_id', $sda_id)->bindValue(':congress_id', $congress_id)->bindValue(':user_id', $user_id)->queryAll(); if ($datas) { $debrief = $debrief == 'YES' ? 1 : 0; \Yii::$app->db->createCommand()->update('sda_feedback', ['congress_id' => $congress_id, 'sda_id' => $sda_id, 'session_id' => $session_id, 'additional_data' => $additional_data, 'ol_feedback' => $ol_feedback, 'questions_ans' => json_encode($ques_ans, JSON_UNESCAPED_SLASHES), 'audience_size' => $audience_size, 'takeaway_summary' => json_encode($takeaway_summary, JSON_UNESCAPED_SLASHES), 'attendee_id' => $attendee_id, 'user_id' => $user_id, 'debrief' => $debrief, 'modify_date' => date("Y-m-d H:i:s")], 'id =' . $datas[0]['id'])->execute(); $lastid = $datas[0]['id']; } else { $model->congress_id = $congress_id; $model->sda_id = $sda_id; $model->session_id = $session_id; $model->additional_data = $additional_data; $model->ol_feedback = $ol_feedback; $model->questions_ans = json_encode($ques_ans, JSON_UNESCAPED_SLASHES); $model->audience_size = $audience_size; $model->takeaway_summary = json_encode($takeaway_summary, JSON_UNESCAPED_SLASHES); //implode(",",$takeaway_summary);// != "" ? ($takeaway_summary) : ""; $model->attendee_id = $attendee_id; $model->user_id = $user_id; $model->debrief = $debrief == 'YES' ? 1 : 0; $model->is_active = 1; $model->save(FALSE); $lastid = $model->id; } $image_ids = ''; if ($lastid > 0) { if (!empty($ques_ans)) { foreach ($ques_ans as $ques_anss) { $commentmodel = new FeedbackComments(); $commentmodel->feedback_type = "questions_ans"; $commentmodel->feedback_id = $lastid; $commentmodel->comment = $ques_anss['title']; $commentmodel->pid = 0; $commentmodel->user_id = $user_id; $commentmodel->createdOn = date("Y-m-d H:i:s", strtotime(str_replace("at", "", $ques_anss['date']))); $commentmodel->active = 1; $commentmodel->save(FALSE); } } //takeaway summary if (!empty($takeaway_summary)) { foreach ($takeaway_summary as $takeaway_summarys) { $commentmodel = new FeedbackComments(); $commentmodel->feedback_type = "takeaway_summary"; $commentmodel->feedback_id = $lastid; $commentmodel->pid = 0; $commentmodel->comment = $takeaway_summarys['title']; $commentmodel->user_id = $user_id; $commentmodel->createdOn = date("Y-m-d H:i:s", strtotime(str_replace("at", "", $takeaway_summarys['date']))); $commentmodel->active = 1; $commentmodel->save(FALSE); } } $validation = array('jpg', 'png', 'gif', 'jpeg'); if ($imageCount > 0) { for ($i = 1; $i <= $imageCount; $i++) { $imgsArr = explode(".", $_FILES['imageFile' . $i]['name']); $ext = end($imgsArr); if (in_array($ext, $validation)) { $file = str_replace("." . $ext, "", $_FILES['imageFile' . $i]['name']); $thumbFile = str_replace("." . $ext, "", $_FILES['thumb' . $i]['name']); $imageName = time() . "_{$i}." . $ext; $destination = 'feedbackattachments/' . $imageName; $destination2 = 'feedbackattachments/thumb/' . $imageName; //Moving main image move_uploaded_file($_FILES['imageFile' . $i]['tmp_name'], $destination) or die("error in uploading"); //Moving Thumbnai move_uploaded_file($_FILES['thumb' . $i]['tmp_name'], $destination2) or die("error in uploading"); $modelattachment = new \backend\models\SdaAttachments(); $modelattachment->sda_feedback_id = $lastid; $modelattachment->congress_id = $congress_id; $modelattachment->sda_id = $sda_id; $modelattachment->session_id = $session_id; $modelattachment->path = '/' . $destination; $modelattachment->save(FALSE); $image_ids .= $modelattachment->id . ","; } } } return array('message' => "Information saved successfully !", 'sda_feedback_id' => $lastid, 'latest_image_id' => $image_ids); } }
$debrief = ''; $questions_anss = ''; $session = ''; $takeawaysd = ''; $images = ""; $allimages = ''; $userdetails = []; $username = ''; $summaries = ""; $questies = ""; $sdaTitle = ''; if ($model) { foreach ($model as $models) { $summary = json_decode($models->takeaway_summary, true); $ques = json_decode($models->questions_ans, true); $sda_attachements = \backend\models\SdaAttachments::find()->where(['sda_feedback_id' => $models->id])->orderBy(['id' => SORT_DESC])->all(); if ($models->user_id > 0) { $userdetails = \backend\models\User::findOne(['id' => $models->user_id]); if ($userdetails) { $username = $userdetails->first_name . " " . $userdetails->last_name; } } $commentmodel = new FeedbackComments(); $commentdata = $commentmodel::find(1)->where(array('feedback_id' => $models->id))->orderBy(['id' => SORT_DESC])->all(); foreach ($commentdata as $commentdata) { if ($commentdata->feedback_type == "takeaway_summary") { $summaries .= '<p class="bg-success">' . $username . $spaceString . date("M d,Y", strtotime($commentdata->createdOn)) . "/" . date("h:i a", strtotime($commentdata->createdOn)) . "{$spaceString}" . $commentdata->comment . "</p>"; } else { $questies .= '<p class="bg-success">' . $username . $spaceString . date("M d,Y", strtotime($commentdata->createdOn)) . "/" . date("h:i a", strtotime($commentdata->createdOn)) . "{$spaceString}" . $commentdata->comment . " </p>"; } }