[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [9935]
From: |
Torstein |
Subject: |
[Fmsystem-commits] [9935] |
Date: |
Thu, 30 Aug 2012 08:59:16 +0000 |
Revision: 9935
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9935
Author: vator
Date: 2012-08-30 08:59:16 +0000 (Thu, 30 Aug 2012)
Log Message:
-----------
Modified Paths:
--------------
trunk/controller/inc/class.socheck_list.inc.php
Modified: trunk/controller/inc/class.socheck_list.inc.php
===================================================================
--- trunk/controller/inc/class.socheck_list.inc.php 2012-08-30 08:57:27 UTC
(rev 9934)
+++ trunk/controller/inc/class.socheck_list.inc.php 2012-08-30 08:59:16 UTC
(rev 9935)
@@ -354,67 +354,8 @@
return null;
}
}
-
-
+
/**
- * Get check list objects for a control on a location with no set
planned date
- *
- * @param $control_id
- * @param $location_code
- * @return array with check list objects
- */
- function get_unplanned_check_lists_for_control($control_id,
$location_code)
- {
- $control_id = (int) $control_id;
-
- $sql = "SELECT cl.id as cl_id, cl.status as cl_status,
cl.comment as cl_comment, deadline, planned_date, ";
- $sql .= "completed_date, component_id, location_code,
num_open_cases, num_pending_cases ";
- $sql .= "FROM controller_check_list cl ";
- $sql .= "WHERE cl.control_id = {$control_id} ";
- $sql .= "AND cl.location_code = '{$location_code}' ";
- $sql .= "AND cl.planned_date IS NULL ";
- $sql .= "AND cl.completed_date IS NULL ";
- $sql .= "ORDER BY cl.id;";
-
- $this->db->query($sql);
-
- $check_list_id = 0;
- $check_list = null;
- while ($this->db->next_record())
- {
- if( $this->db->f('cl_id') != $check_list_id )
- {
- if($check_list_id)
- {
- $check_list_array[] = $check_list;
- }
-
- $check_list = new
controller_check_list($this->unmarshal($this->db->f('cl_id'), 'int'));
-
$check_list->set_status($this->unmarshal($this->db->f('cl_status'), 'int'));
-
$check_list->set_comment($this->unmarshal($this->db->f('cl_comment', true),
'string'));
-
$check_list->set_deadline($this->unmarshal($this->db->f('deadline'), 'int'));
-
$check_list->set_planned_date($this->unmarshal($this->db->f('planned_date'),
'int'));
-
$check_list->set_completed_date($this->unmarshal($this->db->f('completed_date'),
'int'));
-
$check_list->set_component_id($this->unmarshal($this->db->f('component_id'),
'int'));
-
$check_list->set_location_code($this->unmarshal($this->db->f('location_code',
true), 'string'));
-
$check_list->set_num_open_cases($this->unmarshal($this->db->f('num_open_cases'),
'int'));
-
$check_list->set_num_pending_cases($this->unmarshal($this->db->f('num_pending_cases'),
'int'));
- }
- $check_list_id = $check_list->get_id();
- }
-
- if($check_list != null)
- {
- $check_list_array[] = $check_list;
- return $check_list_array;
- }
- else
- {
- return null;
- }
- }
-
- /**
* Get check list objects for a control on a location after specitied
date
*
* @param $control_id control id
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [9935],
Torstein <=