Advertisement
Guest User

Untitled

a guest
Jan 26th, 2015
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.62 KB | None | 0 0
  1. function scrum_team() {
  2. $subject = "Scrum team";
  3. $crud = new grocery_CRUD();
  4. $crud->set_theme('datatables');
  5. $crud->set_subject($subject);
  6.  
  7. $crud->edit_fields('team_name', 'date_started', 'scrum_masterID', 'product_ownerID');
  8. $crud->columns('team_name', 'date_started', 'scrum_masterID', 'product_ownerID');
  9. $crud->add_fields('team_name', 'date_started', 'scrum_masterID', 'product_ownerID');
  10.  
  11. //$crud->display_as('scrum_masterID', 'Scrum master');
  12. //$crud->display_as('product_ownerID', 'Product_owner');
  13. $crud->display_as('date_started', 'Team start date');
  14. $crud->display_as('team_name', 'Team name');
  15.  
  16. //$crud->set_relation("scrum_masterID", "person", "christian_name");
  17. //$crud->set_relation("product_ownerID", "product_ownerID", "team_name");
  18. //$crud->add_action('SHow scrum team', '', '', 'ui-icon-image', array($this, 'navigate_team'));
  19.  
  20. $cur_state = $crud->getState();
  21. /* Use the mySQL view to display the data with related tables */
  22. if (($cur_state == "list") || ($cur_state == "ajax_list") || ($cur_state == "read") || ($cur_state == "success")) {
  23. $crud->set_table('vw_scrum_team');
  24. $crud->columns('team_name', 'date_started', 'Scrum master first name', 'Scrum master christian name', 'Product owner first name', 'Product owner christian name');
  25. $crud->set_primary_key('scrum_teamID', 'vw_scrum_team');
  26.  
  27. if ($cur_state == "read") {
  28. $crud->unset_fields('Scrum master first name', 'Scrum master christian name', 'Product owner first name', 'Product owner christian name');
  29. }
  30. } else {
  31. /* Use the patient_note table itself for add/edit operation */
  32. $crud->set_table('scrum_team');
  33. $crud->columns('team_name', 'date_started');
  34. }
  35.  
  36. //$sm = $row->scrum_masterID; // or however you get the state you want to filter by
  37. //$crud->set_relation('scrum_masterID', 'scrum_master', 'christian_name', 'scrum_masterID IN (SELECT chistian_name FROM person WHERE personIDstate=' . $sm . ')');
  38. $crud->set_relation_n_n('Name scrum master', 'scrum_master', 'person', 'scrum_masterID', 'personID', 'first_name');
  39. $crud->edit_fields('team_name', 'date_started', 'product_ownerID', 'Name scrum master');
  40. $crud->add_fields('team_name', 'date_started', 'product_ownerID', 'Name scrum master');
  41.  
  42. $crud->callback_before_update(array($this, '_fill_scrummaster'));
  43.  
  44. $output = $crud->render();
  45. $this->_scrumba_output($output);
  46. }
  47.  
  48. function _fill_scrummaster($post_array, $primary_key) {
  49. echo "personID " . $post_array ["personID"];
  50. echo "primary_key " . $primary_key;
  51. exit;
  52. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement