public static function get_list_with_session($session_id)
{
$session = session::get_session($session_id);
if ($session->is_valid()) {
$user = ormlib::get_from_instance(new user(), array("id"), array($session->user_id));
if ($user !== null && $user->id !== null && $user->id !== "") {
if ($user->has_group(session::GROUP_METADATA) === true) {
$metadata_list = ormlib::get_list_from_instance(new metadata());
$mw_list = array();
for ($i = 0; $i < count($metadata_list); $i++) {
$md = $metadata_list[$i];
$mw = new metadata_wrapper($md);
$mw->metadata_field_list = ormlib::get_list_from_instance(new metadata_field(), array("metadata_id"), array($md->id));
for ($j = 0; $j < count($mv->metadata_field_list); $j++) {
$mw->metadata_field_selection[] = ormlib::get_list_from_instance(new metadata_field_selection(), array("metadata_field_id"), array($mv->metadata_field_list[$j]->id));
}
$mw->metadata_table_list = ormlib::get_list_from_instance(new metadata_table(), array("metadata_id"), array($md->id));
$mw->metadata_table_relation = ormlib::get_list_from_instance(new metadata_table_relation(), array("metadata_id"), array($md->id));
$mw->metadata_relation = array_merge($mv->metadata_relation, ormlib::get_list_from_instance(new metadata_table_relation(), array("metadata_id1"), array($md->id)));
$mw->metadata_relation = array_merge($mv->metadata_relation, ormlib::get_list_from_instance(new metadata_table_relation(), array("metadata_id2"), array($md->id)));
$mw_list[] = $mw;
}
return $mw_list;
}
}
}
return null;
}
public static function get_list_with_session($session_id)
{
$session = session::get_session($session_id);
if ($session != null && $session->is_valid()) {
$user = ormlib::get_from_instance(new user(), array("id"), array($session->user_id));
if ($user->has_group(session::GROUP_METADATA) === true) {
return ormlib::get_list_from_instance(new user());
}
}
return null;
}
public static function load_structur_with_session($id, $session_id)
{
global $dbconnection;
$object = new report();
$reportlist = $object->get_list_with_session($session_id);
$found = false;
for ($i = 0; $i < count($reportlist); $i++) {
if ($reportlist[$i]->id * 1 === $id * 1) {
$object = $reportlist[$i];
$found = true;
}
}
if ($found === false) {
return null;
}
$rw = new report_wrapper();
$rw->id = $object->id;
$rw->name = $object->name;
$rw->report_element_list = ormlib::get_list_from_instance(new report_element(), array("report_id"), array($id));
for ($i = 0; $i < count($rw->report_element_list); $i++) {
$rw->report_element_field_list = array_merge($rw->report_element_field_list, ormlib::get_list_from_instance(new report_element_field(), array("report_element_id"), array($rw->report_element_list[$i]->id)));
}
for ($i = 0; $i < count($rw->report_element_field_list); $i++) {
$rw->report_element_metadata_mapping[] = ormlib::get_from_instance(new metadata_field(), array("id"), array($rw->report_element_field_list[$i]->metadata_field_id));
}
$help = ormlib::get_list_from_instance(new report_metadata_condition(), array("report_id"), array($rw->id));
for ($i = 0; $i < count($help); $i++) {
$rw->report_metadata_field_condition[] = ormlib::get_from_instance(new metadata_field(), array("id"), array($help[$i]->metadata_field_id));
$table = ormlib::get_from_instance(new metadata_table(), array("id"), array($rw->report_metadata_field_condition[$i]->metadata_table_id));
$values = array();
if ($rw->report_metadata_field_condition[$i]->type * 1 === 1) {
$result = $dbconnection->do_query_data_response("select " . $rw->report_metadata_field_condition[$i]->name_in_table . " from " . $table->name . " group by " . $rw->report_metadata_field_condition[$i]->name_in_table);
while ($myrow = mysql_fetch_array($result)) {
$values[] = $myrow[0];
}
}
$rw->report_values[$rw->report_metadata_field_condition[$i]->name] = $values;
}
return $rw;
}
<?php
if (!defined('INTERFACE_ACCESS')) {
die('Direct access not premitted');
}
$session_id = $_REQUEST["session_id"];
$session = session::get_session($session_id);
if ($session->is_valid()) {
echo json_encode(ormlib::get_list_from_instance(new user_settings(), array("user_id"), array($session->user_id)));
}
public static function get_query_elements($metadata_id, $element_fields = array())
{
$tables = ormlib::get_list_from_instance(new metadata_table(), array("metadata_id"), array($metadata_id));
$query_from = query::get_from($tables);
$fields = query::get_fields($tables);
$query_relation = query::get_query_relations($fields, $tables);
$query_fields = query::get_query_fields($fields, $tables, $element_fields);
return array("fields" => $query_fields, "from" => $query_from, "relations" => $query_relation);
}
