public function save_patient($data_array, $patient_number, $date_created, $facility_code)
{
$o = new Patients();
$o->fromArray($data_array);
$o->save();
$sql = "select id from patient_details where patient_number='{$patient_number}' and date_created='{$date_created}' limit 0,1";
$query = Doctrine_Manager::getInstance()->getCurrentConnection()->fetchAll($sql);
foreach ($query as $key => $value) {
$id = $value['id'];
$system_patient_number = $facility_code . 'P' . $id;
$sql_u = "update patient_details set system_patient_number='{$system_patient_number}' where id='{$id}'";
$q = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($sql_u);
}
return TRUE;
}
