Ejemplo n.º 1
0
 public function updateAdd($profID, $refID)
 {
     if (!$this->session->userdata('user_id')) {
         redirect('/users/login', 'location');
     }
     $date_today = date('Y-m-d');
     $updates_model = new updates_model();
     $indicator_model = new indicator_model();
     $this->validateUpdatesIndicator();
     if (!$this->form_validation->run()) {
         $form_message = '';
         $this->load->view('header');
         $this->load->view('nav');
         $this->load->view('sidebar');
         $this->load->view('updates_add', array('getDetail' => $updates_model->getDetails($profID, $refID), 'getMotherIndicator' => $updates_model->getMotherIndicator()));
         $this->load->view('footer');
     } else {
         $date_today = date('Y-m-d');
         $indicatorID = $this->input->post('indicatorID');
         $compliance = $this->input->post('compliance');
         $getIndicatorUpdate = $updates_model->getIndicatorUpdate($indicatorID);
         $count = count($getIndicatorUpdate);
         if ($count > 0) {
             $updatesResultBronze = $updates_model->updateUpdates($indicatorID, $profID, $refID, $compliance, $date_today);
         } else {
             $updatesResultBronze = $updates_model->insertUpdates($indicatorID, $profID, $refID, $compliance, $compliance, $date_today, 1);
         }
         if ($updatesResultBronze) {
             $form_message = 'Add Success!';
             $this->load->view('header');
             $this->load->view('nav');
             $this->load->view('sidebar');
             $this->load->view('updates_add', array('getDetail' => $updates_model->getDetails($profID, $refID), 'getMotherIndicator' => $updates_model->getMotherIndicator()));
             $this->load->view('footer');
             $scoreProf = $indicator_model->getScorePerProf($profID, $refID);
             $getPerc = $scoreProf->FinalScore;
             $totalScore = $scoreProf->TotalScore;
             if ($getPerc == 100) {
                 $level = 'Fully Functional';
             } elseif ($getPerc > 50 && $getPerc < 100) {
                 $level = 'Functional';
             } elseif ($getPerc < 51) {
                 $level = 'Partially Functional';
             }
             $addFunction = $indicator_model->updateFunctionality($profID, $refID, $level, $totalScore);
             $this->redirectIndex($profID, $refID);
         }
     }
 }
Ejemplo n.º 2
0
 public function indicatorAddpart4($profID, $ref_id)
 {
     if (!$this->session->userdata('user_id')) {
         redirect('/users/login', 'location');
     }
     $date_today = date('Y-m-d');
     $indicator_model = new indicator_model();
     $updates_model = new updates_model();
     $this->validateAddIndicatorpart4();
     $lguTypes = $indicator_model->getLGUtype($profID);
     if (!$this->form_validation->run()) {
         $form_message = '';
         $this->load->view('header');
         $this->load->view('nav');
         $this->load->view('sidebar');
         $this->load->view('indicator_addpart4', array('fourthMotherIndicator' => $indicator_model->getFourthMotherIndicator(), 'fourthIndicators' => $indicator_model->getFourthIndicators(), 'fourthCategory' => $indicator_model->getCategoriesFromFourthI(), 'LGUType' => $indicator_model->getLGUtype($profID), 'profileID' => $profID, 'refID' => $ref_id));
         $this->load->view('footer');
     } else {
         foreach ($indicator_model->getFourthIndicators() as $firstCatBronze) {
             if ($firstCatBronze->indicator_checklist_id != '0') {
                 $complianceBronze = $this->input->post('compliance' . $firstCatBronze->indicator_id . 'Bronze');
                 $complianceSilver = $this->input->post('compliance' . $firstCatBronze->indicator_id . 'Silver');
                 $complianceGold = $this->input->post('compliance' . $firstCatBronze->indicator_id . 'Gold');
                 $profile = $this->input->post('profID');
                 $indicator = $firstCatBronze->indicator_id;
                 $findings = $this->input->post('textArea' . $firstCatBronze->indicator_id);
                 if ($complianceBronze != "") {
                     $addResultBronze = $indicator_model->insertFirstIndicator($profile, $indicator, $complianceBronze, $findings, $ref_id);
                     $updatesResultBronze = $updates_model->insertUpdates($indicator, $profile, $ref_id, $complianceBronze, $complianceBronze, $date_today, 0);
                 }
                 if ($complianceSilver != "") {
                     $addResultSilver = $indicator_model->insertFirstIndicator($profile, $indicator, $complianceSilver, $findings, $ref_id);
                     $updatesResultSilver = $updates_model->insertUpdates($indicator, $profile, $ref_id, $complianceSilver, $complianceSilver, $date_today, 0);
                 }
                 if ($complianceGold != "") {
                     $addResultGold = $indicator_model->insertFirstIndicator($profile, $indicator, $complianceGold, $findings, $ref_id);
                     $updatesResultGold = $updates_model->insertUpdates($indicator, $profile, $ref_id, $complianceGold, $complianceGold, $date_today, 0);
                 }
             } else {
                 continue;
             }
         }
         foreach ($indicator_model->getCategoriesFromFourthI() as $secondCat) {
             if ($secondCat->indicator_checklist_id != '0') {
                 $complianceBronze = $this->input->post('compliance' . $secondCat->indicator_id . 'Bronze');
                 $complianceSilver = $this->input->post('compliance' . $secondCat->indicator_id . 'Silver');
                 $complianceGold = $this->input->post('compliance' . $secondCat->indicator_id . 'Gold');
                 $profile = $this->input->post('profID');
                 $indicator = $secondCat->indicator_id;
                 $findings = $this->input->post('textArea' . $secondCat->indicator_id);
                 if ($complianceBronze != "") {
                     $addResultBronze = $indicator_model->insertFirstIndicator($profile, $indicator, $complianceBronze, $findings, $ref_id);
                     $updatesResultBronze = $updates_model->insertUpdates($indicator, $profile, $ref_id, $complianceBronze, $complianceBronze, $date_today, 0);
                 }
                 if ($complianceSilver != "") {
                     $addResultSilver = $indicator_model->insertFirstIndicator($profile, $indicator, $complianceSilver, $findings, $ref_id);
                     $updatesResultSilver = $updates_model->insertUpdates($indicator, $profile, $ref_id, $complianceSilver, $complianceSilver, $date_today, 0);
                 }
                 if ($complianceGold != "") {
                     $addResultGold = $indicator_model->insertFirstIndicator($profile, $indicator, $complianceGold, $findings, $ref_id);
                     $updatesResultGold = $updates_model->insertUpdates($indicator, $profile, $ref_id, $complianceGold, $complianceGold, $date_today, 0);
                 }
             } else {
                 continue;
             }
         }
         if ($addResultBronze || $addResultSilver || $addResultGold) {
             $form_message = 'Add Success!';
             $this->load->view('header');
             $this->load->view('nav');
             $this->load->view('sidebar');
             $this->load->view('indicator_view', array('fourthMotherIndicator' => $indicator_model->getFirstMotherIndicator(), 'fourthIndicators' => $indicator_model->getFirstIndicators(), 'fourthCategory' => $indicator_model->getCategoriesFromFourthI(), 'getFirstCategory' => $indicator_model->getCategoriesFromFI($lguTypes->lgu_type_id), 'getSecondCategory' => $indicator_model->getSecondCategoriesFromFI($lguTypes->lgu_type_id)));
             $this->load->view('footer');
             $scoreProf = $indicator_model->getScorePerProf($profID, $ref_id);
             $getPerc = $scoreProf->FinalScore;
             $totalScore = $scoreProf->TotalScore;
             if ($getPerc == 100) {
                 $level = 'Fully Functional';
             } elseif ($getPerc > 50 && $getPerc < 100) {
                 $level = 'Functional';
             } elseif ($getPerc < 51) {
                 $level = 'Partially Functional';
             }
             $addFunction = $indicator_model->updateFunctionalityProfOnly($profID, $level, $totalScore);
             $this->redirectIndexAddPart4($profID, $ref_id);
             //                $this->redirectIndexViewAll($profID,$ref_id);
         }
     }
 }