コード例 #1
0
 function view_closed_cases()
 {
     $check_list_id = phpgw::get_var('check_list_id');
     $case_location_code = phpgw::get_var('location_code');
     $check_list = $this->so_check_list->get_single($check_list_id);
     // Check list top section info
     $control = $this->so_control->get_single($check_list->get_control_id());
     $location_code = $check_list->get_location_code();
     $component_id = $check_list->get_component_id();
     if ($component_id > 0) {
         $location_id = $check_list->get_location_id();
         $component_id = $check_list->get_component_id();
         $component_arr = execMethod('property.soentity.read_single_eav', array('location_id' => $location_id, 'id' => $component_id));
         $location_name = execMethod('property.bolocation.get_location_name', $component_arr['location_code']);
         $short_desc = $location_name . '::' . execMethod('property.soentity.get_short_description', array('location_id' => $location_id, 'id' => $component_id));
         //				$short_desc = execMethod('property.soentity.get_short_description', array('location_id' => $location_id, 'id' => $component_id));
         $component = new controller_component();
         $component->set_id($component_id);
         $component->set_location_id($location_id);
         $component->set_location_code($component_arr['location_code']);
         $component->set_xml_short_desc($short_desc);
         $component_array = $component->toArray();
         $type = 'component';
         $building_location_code = $this->location_finder->get_building_location_code($component_arr['location_code']);
         $buildings_on_property = array();
     } else {
         $location_code = $check_list->get_location_code();
         $location_array = execMethod('property.bolocation.read_single', array('location_code' => $location_code));
         $type = 'location';
         // Fetches buildings on property
         $buildings_on_property = $this->location_finder->get_buildings_on_property($user_role, $location_code, $level);
     }
     // Check list top section info
     $level = $this->location_finder->get_location_level($location_code);
     $year = date("Y", $check_list->get_deadline());
     $month = date("n", $check_list->get_deadline());
     $user_role = true;
     $closed_check_items_and_cases = $this->so_check_item->get_check_items_with_cases($check_list_id, null, 'closed', null, $case_location_code);
     if ($buildings_on_property) {
         foreach ($buildings_on_property as &$building) {
             $building['selected'] = $building['id'] == $case_location_code ? 1 : 0;
         }
     }
     //---------
     foreach ($closed_check_items_and_cases as $key => $check_item) {
         //		$control_item_with_options = $this->so_control_item->get_single_with_options( $check_item->get_control_item_id() );
         foreach ($check_item->get_cases_array() as $case) {
             $component_location_id = $case->get_component_location_id();
             $component_id = $case->get_component_id();
             if ($component_id) {
                 $short_desc = execMethod('property.soentity.get_short_description', array('location_id' => $component_location_id, 'id' => $component_id));
                 $case->set_component_descr($short_desc);
             }
         }
         //		$check_item->get_control_item()->set_options_array( $control_item_with_options->get_options_array() );
         //		$closed_check_items_and_cases[$key] = $check_item;
     }
     //-------
     $data = array('control' => $control, 'check_list' => $check_list, 'buildings_on_property' => $buildings_on_property, 'location_array' => $location_array, 'component_array' => $component_array, 'type' => $type, 'location_level' => $level, 'current_year' => $year, 'current_month_nr' => $month, 'closed_check_items_and_cases' => $closed_check_items_and_cases, 'check_list' => $check_list, 'cases_view' => 'closed_cases', 'building_location_code' => $building_location_code);
     phpgwapi_jquery::load_widget('core');
     self::add_javascript('controller', 'controller', 'case.js');
     self::add_javascript('controller', 'controller', 'check_list_update_status.js');
     self::render_template_xsl(array('check_list/fragments/check_list_menu', 'case/cases_tab_menu', 'case/view_closed_cases', 'case/case_row', 'check_list/fragments/nav_control_plan', 'check_list/fragments/check_list_top_section', 'check_list/fragments/select_buildings_on_property'), $data);
 }
コード例 #2
0
 function view_control_info()
 {
     $check_list_id = phpgw::get_var('check_list_id');
     $check_list = $this->so->get_single($check_list_id);
     $control = $this->so_control->get_single($check_list->get_control_id());
     $component_id = $check_list->get_component_id();
     if ($component_id > 0) {
         $location_id = $check_list->get_location_id();
         $component_id = $check_list->get_component_id();
         $component_arr = execMethod('property.soentity.read_single_eav', array('location_id' => $location_id, 'id' => $component_id));
         $location_name = execMethod('property.bolocation.get_location_name', $component_arr['location_code']);
         $short_desc = $location_name . '::' . execMethod('property.soentity.get_short_description', array('location_id' => $location_id, 'id' => $component_id));
         $component = new controller_component();
         $component->set_id($component_id);
         $component->set_location_id($location_id);
         $component->set_location_code($component_arr['location_code']);
         $component->set_xml_short_desc($short_desc);
         $component_array = $component->toArray();
         $type = 'component';
         $building_location_code = $this->location_finder->get_building_location_code($component_arr['location_code']);
     } else {
         $location_code = $check_list->get_location_code();
         $location_array = execMethod('property.bolocation.read_single', array('location_code' => $location_code));
         $type = 'location';
         $level = $this->location_finder->get_location_level($location_code);
     }
     $year = date("Y", $check_list->get_deadline());
     $month = date("n", $check_list->get_deadline());
     $level = $this->location_finder->get_location_level($location_code);
     $user_role = true;
     // Fetches buildings on property
     $buildings_on_property = $this->location_finder->get_buildings_on_property($user_role, $location_code, $level);
     $data = array('control' => $control, 'check_list' => $check_list, 'buildings_on_property' => $buildings_on_property, 'location_array' => $location_array, 'component_array' => $component_array, 'type' => $type, 'current_year' => $year, 'current_month_nr' => $month, 'building_location_code' => $building_location_code, 'location_level' => $level);
     phpgwapi_jquery::load_widget('core');
     self::add_javascript('controller', 'controller', 'check_list_update_status.js');
     self::render_template_xsl(array('check_list/fragments/check_list_menu', 'check_list/fragments/check_list_top_section', 'check_list/fragments/nav_control_plan', 'check_list/view_control_info', 'check_list/fragments/select_buildings_on_property'), $data);
 }
コード例 #3
0
 /**
  * Get all controls assosiated with a component
  *
  * @param array $data location_id and component_id
  * @return array controls assosiated with a component
  * @throws Exception if missing valid input
  */
 function get_controls_at_component2($data)
 {
     if (!isset($data['location_id']) || !$data['location_id']) {
         throw new Exception("controller_socontrol::get_controls_at_component - Missing location_id in input");
     }
     if (!isset($data['id']) || !$data['id']) {
         throw new Exception("controller_socontrol::get_controls_at_component - Missing component_id in input");
     }
     static $users = array();
     // cache result
     $location_id = (int) $data['location_id'];
     $component_id = (int) $data['id'];
     $sql = "SELECT DISTINCT controller_control_component_list.* ," . " controller_control.id as control_id, controller_control.title, controller_control.enabled as control_enabled," . " controller_control_component_list.enabled as relation_enabled," . " controller_control_serie.enabled as serie_enabled," . " controller_control_serie.id as serie_id," . " controller_control_serie.assigned_to,controller_control_serie.start_date," . " controller_control_serie.repeat_type,controller_control_serie.repeat_interval," . " controller_control_serie.service_time,controller_control_serie.controle_time " . " FROM controller_control_component_list" . " {$this->db->join} controller_control ON controller_control.id = controller_control_component_list.control_id" . " {$this->db->left_join} controller_control_serie ON (controller_control_component_list.id = controller_control_serie.control_relation_id AND controller_control_serie.control_relation_type = 'component')" . " WHERE location_id = {$location_id} AND component_id = {$component_id}";
     //			_debug_array($sql);
     $this->db->query($sql, __LINE__, __FILE__);
     $components_array = array();
     $control_relations = array();
     while ($this->db->next_record()) {
         $control_relations[] = array('control_id' => $this->db->f('control_id'), 'serie_id' => $this->db->f('serie_id'), 'assigned_to' => $this->db->f('assigned_to'), 'start_date' => $this->db->f('start_date'), 'repeat_type' => $this->db->f('repeat_type'), 'repeat_interval' => $this->db->f('repeat_interval'), 'service_time' => $this->db->f('service_time'), 'controle_time' => $this->db->f('controle_time'), 'serie_enabled' => (int) $this->db->f('serie_enabled'));
     }
     foreach ($control_relations as &$entry) {
         if ($entry['assigned_to'] && !isset($users[$entry['assigned_to']])) {
             $users[$entry['assigned_to']] = $GLOBALS['phpgw']->accounts->get($entry['assigned_to'])->__toString();
         }
         $entry['assigned_to_name'] = $users[$entry['assigned_to']];
         $component = new controller_component();
         //				$component->set_type($this->unmarshal($data['bim_type'], 'int'));
         $component->set_id($component_id);
         $component->set_location_id($location_id);
         $component->set_guid($this->unmarshal($data['guid'], 'string'));
         $component->set_location_code($this->unmarshal($data['location_code'], 'string'));
         $component->set_loc_1($this->unmarshal($data['loc_1'], 'string'));
         $component->set_address($this->unmarshal($data['address'], 'string'));
         //				$component->set_type_str($this->unmarshal($data['bim_type_description']), 'string'));
         $component->set_control_relation($entry);
         $components_array[] = $component;
     }
     return $components_array;
 }