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>";
}
