Hello Grocery Crud users~
Here I have 3 set of functions:-
on_Progress
public function on_progress()
{
$this->grocery_crud->set_model('Custom_query_model');
$this->grocery_crud->set_table('complaints');
$this->grocery_crud->set_theme('flexigrid');
$this->grocery_crud->basic_model->set_query_str("SELECT complaints.*, category.category_name,facilities_services. fs_name, trade.trade_name,
problem_type.problem_type,level.level, users.name,contractor.name
FROM complaints
LEFT JOIN category ON complaints.category_id = category.id
LEFT JOIN facilities_services ON complaints.fs_id = facilities_services.id
LEFT JOIN users ON complaints.report_by = users.id
LEFT JOIN trade ON complaints.trade_id = trade.id
LEFT JOIN problem_type ON complaints.problem_type_id = problem_type.id
LEFT JOIN level ON complaints.level_id = level.id
LEFT JOIN contractor ON complaints.contractor_id = contractor.id
WHERE category.id = facilities_services.category_id
AND facilities_services.id = problem_type.fs_id AND
complaints.report_by = users.id AND work_status = 'In Progress'
");
$this->grocery_crud->columns('id','category_name','fs_name', 'trade_name',
'problem_type', 'level', 'users.name', 'event_datetime',
'event_completed', 'name','work_status',
'complaint_photo','completion_photo','overall_status'
);
$this->grocery_crud->display_as('id','Complaint Id');
$this->grocery_crud->display_as('category_name', 'Category');
$this->grocery_crud->display_as('fs_name','Facilities/Services');
$this->grocery_crud->display_as('trade_name','Problem Category');
$this->grocery_crud->display_as('problem_type','Problem Type');
$this->grocery_crud->display_as('level', 'Level');
//$this->grocery_crud->display_as('users.name','Report By');
//$this->grocery_crud->display_as('contractor.name','Craftsmen');
$this->grocery_crud->unset_add();
$this->grocery_crud->unset_edit();
$this->grocery_crud->unset_delete();
$this->grocery_crud->unset_read();
$this->grocery_crud->add_action('Assign Craftsmen','#','Forms/craftsmen');
$this->grocery_crud->callback_column('complaint_photo', array($this,'show_ComplaintImage'));
$this->grocery_crud->callback_column('completion_photo', array($this,'show_CompleteImage'));
function show_ComplaintImage($value)
{
return "<img src='".$value."' width='100px'>";
}
function show_CompleteImage($value)
{
return "<img src='".$value."' width='100px'>";
}
$output = $this->grocery_crud->render();
$this->load->view('templates/header');
$this->load->view('templates/header_grocery_crud');
$this->load->view('templates/header_menu');
$this->load->view('forms/updateForm', $output);
$this->load->view('templates/footer_grocery_crud');
$this->load->view('templates/footer');
}
craftsmen()
public function craftsmen($primary_key)
//calls contractors based on complaint trade_id
{
$sql = "SELECT id, trade_id FROM complaints WHERE id = '$primary_key'";
$result = $this->db->query($sql);
$row = $result->row();
if (isset($result)){
$complaint_id = $row->id;
$trade_id = $row->trade_id;
$this->grocery_crud->set_model('grocery_CRUD_model');
$this->grocery_crud->set_table('contractor');
$this->grocery_crud->set_theme('flexigrid');
//$this->grocery_crud->basic_model->set_query_str('SELECT * FROM contractor WHERE trade_id = "$trade_id"');
$this->grocery_crud->where('trade_id',$trade_id);
$this->grocery_crud->unset_add();
$this->grocery_crud->unset_edit();
$this->grocery_crud->unset_delete();
$this->grocery_crud->add_action('Assign Craftsmen','#','Forms/assign');
$output = $this->grocery_crud->render();
$this->load->view('templates/header');
$this->load->view('templates/header_grocery_crud');
$this->load->view('templates/header_menu');
$this->load->view('forms/assignCraftsmen', $output);
$this->load->view('templates/footer_grocery_crud');
$this->load->view('templates/footer');
if ($complaint_id <> 0){
return $complaint_id;
}
}
}
and assign
function assign($primary_key)
{
$data['complaint_id'] = $this->craftsmen($data);
$sql = "UPDATE complaints
SET contractor_id = $primary_key
WHERE id = '".$data['complaint_id']."'";
$query = $this->db->query($sql);
if ($query == true){
redirect(base_url().'forms/on_progress');
}
redirect(base_url().'forms/on_progress');
}
I tried to pass the data from function on_progress to function assign using standard Codeigniter method since GroceryCrud's add_action function allows only primary key of each table passed and some string array. Though the method returns "too few arguments" error or the SQL query does not run.
Is there any other way to pass the parameters between functions apart from what I used in the functions? Thanks a lot~