public function db_service_pts() { //Karsan // $all_issues = facility_issues::get_all(); $alpha_data = facility_issues::get_all_issue_data(); $beta_data = facility_issues::get_all_service_points(); // echo "<pre>";print_r($beta_data);exit; $alphacount = count($alpha_data); $betacount = count($beta_data); $omega_data = array(); $epsilon_data = array(); //for generic service points for ($a = 0; $a < $alphacount; $a++) { for ($b = 0; $b < $betacount; $b++) { if ($alpha_data[$a]['issued_to'] == $beta_data[$b]['service_point_name'] && $alpha_data[$a]['facility_code'] == $beta_data[$b]['facility_code']) { $omega_data[$a]['issue_id'] = $alpha_data[$a]['id']; $omega_data[$a]['sp_id'] = $beta_data[$b]['id']; } } for ($b = 0; $b < $betacount; $b++) { if ($alpha_data[$a]['issued_to'] == $beta_data[$b]['service_point_name'] && $alpha_data[$a]['facility_code'] != $beta_data[$b]['facility_code']) { $epsilon_data[$a]['issue_id'] = $alpha_data[$a]['id']; $epsilon_data[$a]['sp_id'] = $beta_data[$b]['id']; break; echo "<pre>"; echo $beta_data[$b]['id'] . ' ' . $b; echo "</pre>"; } } } // echo "<pre>";print_r($omega_data);exit; // echo "<pre>";print_r($epsilon_data);exit; foreach ($omega_data as $omegakey => $omegavalue) { $issue_id = $omegavalue['issue_id']; $service_point_id = $omegavalue['sp_id']; $updater = Doctrine_Manager::getInstance()->getCurrentConnection()->execute("\n\t\t\t\tUPDATE facility_issues SET issued_to = {$service_point_id} WHERE id = {$issue_id}\n\t\t\t\t"); } //end of foreach $omega_affected = $this->db->affected_rows(); echo "OMEGA AFFECTED: " . $omega_affected; echo "<br>THE -OMEGA- UPDATE WAS SUCCESSFUL. </br>-EPSILON DATA- UPDATE COMMENCING</br>"; foreach ($epsilon_data as $epsilonkey => $epsilonvalue) { $issue_id = $epsilonvalue['issue_id']; $service_point_id = $epsilonvalue['sp_id']; $updater = Doctrine_Manager::getInstance()->getCurrentConnection()->execute("UPDATE facility_issues SET issued_to = {$service_point_id} WHERE id = {$issue_id}"); } //end of foreach $epsilon_affected = $this->db->affected_rows(); echo "EPSILON AFFECTED: " . $epsilon_affected; echo "<br>THE -EPSILON- UPDATE WAS SUCCESSFUL </br>"; echo "THE UPDATE WAS SUCCESSFUL. GOD SPEED. </br>"; }