public function manage() { try{ $crud = new grocery_CRUD(); $crud->set_table('office'); $crud->set_theme('datatables'); $crud->add_action('DUPLICATE', '', 'cms/offices/duplicate','ui-icon-plus'); $output = $crud->render(); $this->load->view('cms/office_view.php', $output); }catch(Exception $e){ show_error($e->getMessage().' --- '.$e->getTraceAsString()); } } function duplicate($primary_key, $row) { $query = $this->db->get_where('office', array('office_id' => $primary_key)); if ($query->num_rows() > 0) { $res = $query->result(); $row = $res[0]; } $data = array( 'ordinal_number' => $row->ordinal_number+1, 'ordinal_text' => $row->ordinal_text, 'office_name' => $row->office_name, 'TBRC_P_ID' => $row->TBRC_P_ID, 'start_date' => $row->start_date, 'end_date' => $row->end_date, 'community_TBRC_ID' => $row->community_TBRC_ID, 'tradition' => $row->tradition, 'office_TBRC_R_ID' => $row->office_TBRC_R_ID, 'description' => $row->description ); $this->db->insert('office', $data); header('location:/cms/offices/manage'); exit; }