/** 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>";
}
}
