public function updateworkoutAction()
{
if ($this->isLoggedIn() == 0) {
$this->_redirect('/admin/index');
}
$musclesDataList = new FitnessBodyAreas();
$musclesData = new FitnessBodyAreasMultilang();
$equipmentData = new FitnessEquipmentsMultilang();
$timeframesData = new FitnessWorkoutTimeframes();
$workoutexercises = new FitnessWorkouts();
$this->view->musclesList = $musclesDataList->listMuscles();
$this->view->equipmentList = $equipmentData->listEquipments();
$this->view->timeframesList = $timeframesData->listTimeframes();
if ($this->_request->isPost()) {
$workoutId = $this->_request->getPost('workoutID');
$langID = $this->_request->getPost('langID');
$fitnessGeneralData = array();
//get all the post data for the table fitness exercise general
// $fitnessGeneralData['workout_exercises'] = rtrim($this->_request->getPost("exerciseslist"),",");
$fitnessGeneralData['workout_timeframe'] = $this->_request->getPost("timeframes");
$fitnessGeneralData['otherside'] = $this->_request->getPost("otherside");
$fitnessGeneralData['workout_primary_muscles'] = $this->_request->getPost("primary_muscle");
$fitnessGeneralData['workout_secondary_muscles'] = rtrim($this->_request->getPost("sec_muscles"), ",");
$fitnessGeneralData['workout_pay_status'] = $this->_request->getPost("workout_pay_status");
$fitnessGeneralData['workout_rate'] = $this->_request->getPost("workout_rate");
$fitnessGeneralData['workout_level'] = implode(",", $this->_request->getPost("workout_level"));
$fitnessGeneralData['translator_check'] = $this->_request->getPost("trans_check");
if ($this->_request->getPost("masterStatus") != "") {
$fitnessGeneralData['master_check'] = $this->_request->getPost("masterStatus");
}
//insert data into the fitness exercise general table
$fitnessGeneral = new FitnessExerciseGeneral();
$where = "workout_id='" . $workoutId . "'";
$fitnessGeneral->update($fitnessGeneralData, $where);
//get all post data for the table fitness_exercise_general_multilang
$fitnessGeneralMultilangData = array();
$fitnessGeneralMultilangData['workout_name'] = $this->_request->getPost("workout_name");
$fitnessGeneralMultilangData['otherside'] = $this->_request->getPost("otherside");
$fitnessGeneralMultilangData['workout_preparation'] = $this->_request->getPost("workout_preparation");
$fitnessGeneralMultilangData['workout_execution'] = $this->_request->getPost("workout_execution");
$fitnessGeneralMultilangData['workout_advice'] = $this->_request->getPost("workout_advice");
//insert data into the fitness_exercise_general_multilang table
$fitnessGeneralMultiLang = new FitnessExerciseGeneralMultilang();
$checkGeneralMultiLangRecord = $fitnessGeneralMultiLang->getLangRecord($workoutId, $langID);
if ($checkGeneralMultiLangRecord['count'] > 0) {
$fitnessGeneralMultiLang->update($fitnessGeneralMultilangData, array('workout_id = ?' => $workoutId, 'lang_id = ?' => $langID));
} else {
$fitnessGeneralMultilangData['workout_id'] = $this->_request->getPost("workoutID");
$fitnessGeneralMultilangData['lang_id'] = $this->_request->getPost("langID");
$fitnessGeneralMultiLang->addData($fitnessGeneralMultilangData);
}
//get all the post data for the table fitness_exercise_equipments
$fitnessEquipmentsData = array();
$fitnessEquipmentsData['equipment_required'] = $this->_request->getPost("equipment_required");
$fitnessEquipmentsData['equipments_home'] = rtrim($this->_request->getPost("home_equipments"), ",");
$fitnessEquipmentsData['equipments_office'] = rtrim($this->_request->getPost("office_equipments"), ",");
$fitnessEquipmentsData['equipments_nature'] = rtrim($this->_request->getPost("nature_equipments"), ",");
$fitnessEquipmentsData['equipments_hotel'] = rtrim($this->_request->getPost("hotel_equipments"), ",");
$fitnessEquipments = new FitnessExerciseEquipments();
$where = "workout_id='" . $workoutId . "'";
$fitnessEquipments->update($fitnessEquipmentsData, $where);
//get all the post data for the table fitness_exercise_documents
$fitnessDocumentsData = array();
$fitnessDocumentsData['workout_photo_start'] = $this->_request->getPost("photo_start");
$fitnessDocumentsData['workout_photo_end'] = $this->_request->getPost("photo_end");
$fitnessDocumentsData['workout_video_file'] = $this->_request->getPost("video_file");
$fitnessDocumentsData['poster_video'] = $this->_request->getPost("poster_video");
$fitnessDocuments = new FitnessExerciseDocuments();
$where = "workout_id='" . $workoutId . "'";
$fitnessDocuments->update($fitnessDocumentsData, $where);
//get all the post data for the table FitnessExerciseDocumentsMultilang
$fitnessDocumentsMultilangData = array();
$fitnessDocumentsMultilangData['workout_youtube_link'] = $this->_request->getPost("youtube_link");
$fitnessDocumentsMultilangData['workout_sound_file'] = $this->_request->getPost("sound_file");
$fitnessDocumentsMultilang = new FitnessExerciseDocumentsMultilang();
$checkDocumentsMultilangRecord = $fitnessDocumentsMultilang->getLangRecord($workoutId, $langID);
if ($checkDocumentsMultilangRecord['count'] > 0) {
$fitnessDocumentsMultilang->update($fitnessDocumentsMultilangData, array('workout_id = ?' => $workoutId, 'lang_id = ?' => $langID));
} else {
$documentID = $fitnessDocuments->getDocumentId($workoutId);
$fitnessDocumentsMultilangData['document_id'] = $documentID['document_id'];
$fitnessDocumentsMultilangData['workout_id'] = $workoutId;
$fitnessDocumentsMultilangData['lang_id'] = $langID;
$fitnessDocumentsMultilangData['youtube_link'] = $this->_request->getPost("youtube_link");
$fitnessDocumentsMultilangData['sound_file'] = $this->_request->getPost("sound_file");
$fitnessDocumentsMultilangData['video_file'] = $this->_request->getPost("video_file");
$fitnessDocumentsMultilangData['poster_video'] = $this->_request->getPost("poster_video");
$fitnessDocumentsMultilang->addData($fitnessDocumentsMultilangData);
}
//get all the post data for the table fitness_exercise_ranking
$fitnessRankingData = array();
$fitnessRanking = new FitnessExerciseRanking();
foreach ($this->view->musclesList as $muscles) {
$fitnessRankingData['body_area_id'] = $muscles['area_id'];
$fitnessRankingData['ranking'] = $this->_request->getPost("ranking_" . $muscles['area_id']);
$checkRankingCount = $fitnessRanking->getCountRecords($workoutId, $muscles['area_id']);
if ($checkRankingCount['count'] > 0) {
$fitnessRanking->update($fitnessRankingData, array('workout_id = ?' => $workoutId, 'ranking_id = ?' => $this->_request->getPost("rankID_" . $muscles['area_id'])));
} else {
$fitnessRankingData['workout_id'] = $workoutId;
$fitnessRanking->addData($fitnessRankingData);
}
}
//get all the post data for the table fitness_exercise_repetition
$fitnessRepetitionData = array();
$fitnessRepetition = new FitnessExerciseRepetition();
if ($this->_request->getPost("repetition_beginners") != "") {
$fitnessRepetitionData['exercise_level_id'] = 1;
$fitnessRepetitionData['repetitions'] = $this->_request->getPost("repetition_beginners");
$checkRows = $fitnessRepetition->checkRecord($workoutId, 1);
if (count($checkRows) > 0) {
$fitnessRepetition->update($fitnessRepetitionData, array('workout_id = ?' => $workoutId, 'exercise_level_id = ?' => 1));
} else {
$fitnessRepetitionData['workout_id'] = $workoutId;
$fitnessRepetition->addData($fitnessRepetitionData);
}
}
if ($this->_request->getPost("repetition_advanced") != "") {
$fitnessRepetitionData['exercise_level_id'] = 2;
$fitnessRepetitionData['repetitions'] = $this->_request->getPost("repetition_advanced");
$checkRows = $fitnessRepetition->checkRecord($workoutId, 2);
if (count($checkRows) > 0) {
$fitnessRepetition->update($fitnessRepetitionData, array('workout_id = ?' => $workoutId, 'exercise_level_id = ?' => 2));
} else {
$fitnessRepetitionData['workout_id'] = $workoutId;
$fitnessRepetition->addData($fitnessRepetitionData);
}
}
if ($this->_request->getPost("repetition_professional") != "") {
$fitnessRepetitionData['exercise_level_id'] = 3;
$fitnessRepetitionData['repetitions'] = $this->_request->getPost("repetition_professional");
$checkRows = $fitnessRepetition->checkRecord($workoutId, 3);
if (count($checkRows) > 0) {
$fitnessRepetition->update($fitnessRepetitionData, array('workout_id = ?' => $workoutId, 'exercise_level_id = ?' => 3));
} else {
$fitnessRepetitionData['workout_id'] = $workoutId;
$fitnessRepetition->addData($fitnessRepetitionData);
}
}
//get post data for fitness_exercise_diff_degree
/*$fitnessDiffData = array();
$fitnessDiff = new FitnessExerciseDiffDegree();
if($this->_request->getPost("degree_beginner") =="on")
$fitnessDiffData['degree_beginner'] = 1;
else
$fitnessDiffData['degree_beginner'] = 0;
if($this->_request->getPost("beginner_first") =="on")
$fitnessDiffData['beginner_first'] = 1;
else
$fitnessDiffData['beginner_first'] = 0;
if($this->_request->getPost("beginner_second") =="on")
$fitnessDiffData['beginner_second'] = 1;
else
$fitnessDiffData['beginner_second'] = 0;
if($this->_request->getPost("beginner_third") =="on")
$fitnessDiffData['beginner_third'] = 1;
else
$fitnessDiffData['beginner_third'] = 0;
if($this->_request->getPost("degree_advanced") =="on")
$fitnessDiffData['degree_advanced'] = 1;
else
$fitnessDiffData['degree_advanced'] = 0;
if($this->_request->getPost("advanced_first") =="on")
$fitnessDiffData['advanced_first'] = 1;
else
$fitnessDiffData['advanced_first'] = 0;
if($this->_request->getPost("advanced_second") =="on")
$fitnessDiffData['advanced_second'] = 1;
else
$fitnessDiffData['advanced_second'] = 0;
if($this->_request->getPost("advanced_third") =="on")
$fitnessDiffData['advanced_third'] = 1;
else
$fitnessDiffData['advanced_third'] = 1;
if($this->_request->getPost("degree_professional") =="on")
$fitnessDiffData['degree_professional'] = 1;
else
$fitnessDiffData['degree_professional'] = 0;
if($this->_request->getPost("professional_first") =="on")
$fitnessDiffData['professional_first'] = 1;
else
$fitnessDiffData['professional_first'] = 0;
if($this->_request->getPost("professional_second") =="on")
$fitnessDiffData['professional_second'] = 1;
else
$fitnessDiffData['professional_second'] = 0;
if($this->_request->getPost("professional_third") =="on")
$fitnessDiffData['professional_third'] = 1;
else
$fitnessDiffData['professional_third'] = 0;
$where = "workout_id='".$workoutId."'";
$fitnessDiff->update($fitnessDiffData,$where);*/
$this->_redirect('/admin/listworkout');
}
}
