public function export_kimia($id_analisis)
{
$this->load->model(['type_pemohon_m', 'lokasi_m', 'conto_m']);
$analisis = $this->analisis_m->find($id_analisis);
$conto = $this->conto_m->by_analisis($analisis->id);
$analisis_parameter = $this->analisis_m->parameter($id_analisis);
$pemohon = $this->pemohon_m->find($analisis->id_pemohon);
$type_pemohon = $this->type_pemohon_m->find($pemohon->id_type_pemohon);
$analisis->nama_lokasi = $this->lokasi_m->detail_by_kabupaten($analisis->lokasi, TRUE);
if (!$this->_is_pihak_luar($pemohon->id_type_pemohon)) {
$pemohon->nama_sertifikat = 'Kp. ' . $type_pemohon->nama;
$pemohon->alamat = 'PSDG';
}
foreach ($conto as $key => $row_conto) {
$conto[$key]->detail_parameter = $this->conto_m->parameter($row_conto->id);
}
foreach ($analisis_parameter as $key => $row_parameter) {
$parameter = $this->parameter_m->find_type_analisis_parameter($row_parameter->id_type_analisis_parameter);
$metoda = $this->metoda_m->find($row_parameter->id_metoda);
$analisis_parameter[$key]->nama_parameter = $parameter->nama_parameter;
$analisis_parameter[$key]->metoda = !$metoda ? '' : $metoda->nama;
}
// Memasukkan data hasil analisis ke lembar hasil analisis
$tracking = new Tracking();
if (!$tracking->isset_tracking($analisis->id, 9)) {
$tracking->add_tracking($analisis->id, 9);
}
$data = ['analisis' => $analisis, 'conto' => $conto, 'parameter' => $analisis_parameter, 'pemohon' => $pemohon];
$this->load->view('sertifikat/excel_kimia', $data);
}
