[eluser]cestaz18[/eluser]
CONTINUATION OF MODEL
Code:
function save_detail($id,$rows) //Query for saving the company details
{
$this->db->where('report_id', $id);
$this->db->delete('sec_reports_parameters');
foreach ($rows as $row)
{
$rdata = explode('|', $row);
$data['report_id'] = $id;
$data['parameter_label'] = $rdata[1];
$data['parameter_name'] = $rdata[2];
$data['parameter_type'] = $rdata[3];
$this->db->insert('sec_reports_parameters', $data);
}
}
/* function save($file_name,$data,$item,$details) {
if ($item == '') {
$data['link'] = "reports/view";
$this->db->trans_start();
$this->db->insert('sec_reports', $data);
$this->db->insert('sec_reports', $file_name);
$item = $this->db->insert_id();
$this->save_detail($item,$details);
$this->db->trans_complete();
}*/
function save($data,$item,$details) {
if ($item == '') {
$data['link'] = "reports/view";
$this->db->trans_start();
$this->db->insert('sec_reports', $data);
$item = $this->db->insert_id();
$this->save_detail($item,$details);
$this->db->trans_complete();
}
else {
$this->db->trans_start();
$this->db->where('module_id', $item);
$this->db->update('sec_reports', $data);
$this->save_detail($item,$details);
$this->db->trans_complete();
}
return $item;
}
function delete($data)
{
$deleted_row = $data['module_id'];
$this->db->where('module_id', $data['module_id']);
$this->db->delete('sec_reports', $data);
return $deleted_row;
}
}
?>