d, calls.id call_id,
>> patients.first_name, patients.last_name, calls.created '
>> . 'FROM drugs, drug_lactation_links, lactation, calls, patients '
>> . 'WHERE drugs.id = ' . $id . ' AND drugs.id =
>> drug_lactation_links.drug_id AND '
>
_pregnancy_links, pregnancies, calls, patients '
> . 'WHERE drugs.id = ' . $id . ' AND drugs.id =
> drug_pregnancy_links.drug_id AND '
> . 'drug_pregnancy_links.pregnancy_id = pregnancies.id AND
> pregnancies.call_id = calls.id AND calls.patient_id = p
all_id = calls.id AND calls.patient_id = patients.id '
. 'ORDER BY created DESC'
);
$this->set(compact('patients'));
}
View:
addRow(array('Enter Generic: ' . $drug['Drug']['generic']));
$csv->addRow($header)