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'); } }