function addworkoutAction() { if ($this->isLoggedIn() == 0) { $this->_redirect('/admin/index'); } $this->view->pageTitle = "Add workouts"; $this->view->loginStatus = $this->isLoggedIn(); $musclesData = new FitnessBodyAreas(); $equipmentData = new FitnessEquipmentsMultilang(); $timeframesData = new FitnessWorkoutTimeframes(); $exercisesData = new FitnessWorkouts(); $adminData = new FitnessAdminAccounts(); $sess = new Zend_Session_Namespace('AdminSession'); $adminType = $adminData->getTypeByUsername($sess->username); $this->view->musclesList = $musclesData->listMuscles(); $this->view->equipmentList = $equipmentData->listEquipments(); $this->view->timeframesList = $timeframesData->listTimeframes(); $this->view->exerciseList = $exercisesData->listWorkouts(); $this->view->adminType = $adminType['admin_user_type']; $equipmentCount = count($equipmentData->listEquipments()); //get the post data if ($this->_request->isPost()) { $fitnessGeneralData = array(); //get all the post data for the table fitness exercise general //$fitnessGeneralData['workout_exercises'] = rtrim($this->_request->getPost("exerciseslist",",")); $fitnessGeneralData['timeframe'] = $this->_request->getPost("timeframes"); $fitnessGeneralData['otherside'] = $this->_request->getPost("otherside"); $fitnessGeneralData['primary_muscle'] = $this->_request->getPost("primary_muscle"); $fitnessGeneralData['secondary_muscle'] = rtrim($this->_request->getPost("sec_muscles"), ","); $fitnessGeneralData['paystatus'] = $this->_request->getPost("workout_pay_status"); $fitnessGeneralData['workoutRate'] = $this->_request->getPost("workout_rate"); $fitnessGeneralData['workoutLevel'] = implode(",", $this->_request->getPost("workout_level")); $fitnessGeneralData['translator_check'] = $this->_request->getPost("trans_check"); $fitnessGeneralData['master_check'] = $this->_request->getPost("masterStatus"); //insert data into the fitness exercise general table $fitnessGeneral = new FitnessExerciseGeneral(); $workoutId = $fitnessGeneral->addData($fitnessGeneralData); $workoutId = $fitnessGeneral->getLastWorkoutId(); $lastWorkoutID = $workoutId['workout_id']; //get all post data for the table fitness_exercise_general_multilang $fitnessGeneralMultilangData = array(); $fitnessGeneralMultilangData['workout_id'] = $lastWorkoutID; $fitnessGeneralMultilangData['otherside'] = $this->_request->getPost("otherside"); $fitnessGeneralMultilangData['lang_id'] = $this->getDefaultLanguage(); $fitnessGeneralMultilangData['workout_name'] = $this->_request->getPost("workout_name"); $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(); $fitnessGeneralMultiLang->addData($fitnessGeneralMultilangData); //get all the post data for the table fitness_exercise_equipments $fitnessEquipmentsData = array(); $fitnessEquipmentsData['workout_id'] = $lastWorkoutID; $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(); $fitnessEquipments->addData($fitnessEquipmentsData); //get all the post data for the table fitness_exercise_documents $fitnessDocumentsData = array(); $fitnessDocumentsData['workout_id'] = $lastWorkoutID; $fitnessDocumentsData['photo_start'] = ""; $fitnessDocumentsData['photo_end'] = ""; $fitnessDocumentsData['video_file'] = $this->_request->getPost("video_file"); $fitnessDocumentsData['poster_video'] = $this->_request->getPost("poster_video"); $fitnessDocuments = new FitnessExerciseDocuments(); $documentId = $fitnessDocuments->addData($fitnessDocumentsData); //get all the post data for the table FitnessExerciseDocumentsMultilang $fitnessDocumentsMultilangData = array(); $fitnessDocumentsMultilangData['workout_id'] = $lastWorkoutID; $fitnessDocumentsMultilangData['lang_id'] = $this->getDefaultLanguage(); $fitnessDocumentsMultilangData['document_id'] = $documentId; $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 = new FitnessExerciseDocumentsMultilang(); $fitnessDocumentsMultilang->addData($fitnessDocumentsMultilangData); //get all the post data for the table fitness_exercise_ranking $fitnessRankingData = array(); $fitnessRanking = new FitnessExerciseRanking(); $fitnessRankingData['workout_id'] = $lastWorkoutID; foreach ($this->view->musclesList as $muscles) { $fitnessRankingData['body_area_id'] = $muscles['area_id']; $fitnessRankingData['ranking'] = $this->_request->getPost("ranking_" . $muscles['area_id']); $fitnessRanking->addData($fitnessRankingData); } //get all the post data for the table fitness_exercise_repetition $fitnessRepetitionData = array(); $fitnessRepetition = new FitnessExerciseRepetition(); $fitnessRepetitionData['workout_id'] = $lastWorkoutID; if ($this->_request->getPost("repetition_beginners") != "") { $fitnessRepetitionData['exercise_level_id'] = 1; $fitnessRepetitionData['repetitions'] = $this->_request->getPost("repetition_beginners"); $fitnessRepetition->addData($fitnessRepetitionData); } if ($this->_request->getPost("repetition_advanced") != "") { $fitnessRepetitionData['exercise_level_id'] = 2; $fitnessRepetitionData['repetitions'] = $this->_request->getPost("repetition_advanced"); $fitnessRepetition->addData($fitnessRepetitionData); } if ($this->_request->getPost("repetition_professional") != "") { $fitnessRepetitionData['exercise_level_id'] = 3; $fitnessRepetitionData['repetitions'] = $this->_request->getPost("repetition_professional"); $fitnessRepetition->addData($fitnessRepetitionData); } $this->_redirect('/admin/listworkout'); } }