public function xListTasksAction() { $this->request->defineParams(array('bundleTaskId' => array('type' => 'int'), 'sort' => array('type' => 'json', 'default' => array('property' => 'id', 'direction' => 'DESC')))); $sql = "SELECT * FROM bundle_tasks WHERE env_id = ?"; $args = array($this->getEnvironmentId()); if ($this->getParam('id') > 0) { $sql .= " AND id = ?"; $args[] = $this->getParam('bundleTaskId'); } $response = $this->buildResponseFromSql2($sql, array('id', 'server_id', 'rolename', 'status', 'os_family', 'dtadded', 'dtstarted', 'created_by_email'), array(), $args); foreach ($response["data"] as &$row) { $row['server_exists'] = DBServer::IsExists($row['server_id']); $row['dtadded'] = Scalr_Util_DateTime::convertTz($row['dtadded']); if (!$row['bundle_type']) { $row['bundle_type'] = "*"; } if ($row['dtfinished'] && $row['dtstarted']) { $row['duration'] = Scalr_Util_DateTime::getDateTimeDiff($row['dtfinished'], $row['dtstarted']); } if ($row['dtfinished']) { $row['dtfinished'] = Scalr_Util_DateTime::convertTz($row['dtfinished']); } if ($row['dtstarted']) { $row['dtstarted'] = Scalr_Util_DateTime::convertTz($row['dtstarted']); } } $this->response->data($response); }
public function xListTasksAction() { $this->request->defineParams(array('bundleTaskId' => array('type' => 'int'), 'sort' => array('type' => 'string', 'default' => 'id'), 'dir' => array('type' => 'string', 'default' => 'DESC'))); $sql = "SELECT * FROM bundle_tasks WHERE env_id = '" . $this->getEnvironmentId() . "'"; if ($this->getParam('id') > 0) { $sql .= " AND id = " . $this->db->qstr($this->getParam('bundleTaskId')); } $response = $this->buildResponseFromSql($sql, array("server_id", "rolename", "failure_reason", "snapshot_id", "id")); foreach ($response["data"] as &$row) { $row['server_exists'] = DBServer::IsExists($row['server_id']); $row['dtadded'] = Scalr_Util_DateTime::convertTz($row['dtadded']); if (!$row['bundle_type']) { $row['bundle_type'] = "*"; } if ($row['dtfinished'] && $row['dtstarted']) { $row['duration'] = Scalr_Util_DateTime::getDateTimeDiff($row['dtfinished'], $row['dtstarted']); } if ($row['dtfinished']) { $row['dtfinished'] = Scalr_Util_DateTime::convertTz($row['dtfinished']); } if ($row['dtstarted']) { $row['dtstarted'] = Scalr_Util_DateTime::convertTz($row['dtstarted']); } } $this->response->data($response); }