<?php
include "../config.php";
include "../functions.php";
include "utility.php";
ob_start();
$cubename_sel = $_POST["cubename"];
$colonna = $_POST["ordinamento_col"];
$ordinamento = $_POST["ordinamento_type"];
$slice = $_POST["slice"];
$levels = unserialize(stripslashes($_POST['levels']));
$level_ser = implode("-", $levels);
$query = SQLgenerator2($cubename_sel, $level_ser, $slice, $colonna, $ordinamento);
$result = exec_query($query);
$ncols = mysql_num_fields($result);
print "@RELATION report\n";
//***************************Heading
for ($i = 0; $i < $ncols; $i++) {
$colname = mysql_fetch_field($result);
$nome = $colname->name;
$tabella = $colname->table;
$numeric = $colname->numeric;
if ($numeric == 1) {
$tipocampo = "NUMERIC";
} else {
$tipocampo = "STRING";
}
if ($tabella == "") {
$field = "{$nome}";
} else {
$field = "{$tabella}.{$nome}";
}
for ($i = 0; $i < $nj; $i++) {
if ($join[$i] != "") {
$join_final .= " {$join[$i]} AND ";
}
//print "$join_final";
}
$n = strlen($join_final);
$join_final = substr($join_final, 0, $n - 5);
//$join_across="$join_final";
//print "$join_across<br>";
///*********************************************************************************************************************************
//print "$cubename1 $levels_ser1 $colonna1<br>";
$query1 = SQLgenerator2($cubename1, $levels_ser1, $slice1, $colonna1, $ordinamento1);
//print "Q1 $query1<br>";
$query2 = SQLgenerator2($cubename2, $levels_ser2, $slice2, $colonna2, $ordinamento2);
//print "Q2 $query2<br>";
//******************************************************EXTRACTION 1
$found_group = strrpos($query1, "group");
$found_where = strrpos($query1, "where");
$found_order = strrpos($query1, "order");
$target1 = buildTarget($query1);
$from1 = buildFrom($found_where, $found_group, $found_order, $query1);
$where1 = buildWhere($found_where, $found_group, $found_order, $query1);
$group1 = buildGroup($found_group, $found_order, $query1);
$order1 = buildOrder($found_order, $query1);
//******************************************************EXTRACTION 2
$found_group = strrpos($query2, "group");
$found_where = strrpos($query2, "where");
$found_order = strrpos($query2, "order");
$target2 = buildTarget($query2);
function read_cell_value($cubename_p, $slice_p, $measure_p, $riga_col, $riga_row, $cols_pivoting, $rows_pivoting)
{
$level_ser = "{$measure_p}" . "-" . "{$cols_pivoting}" . "-" . "{$rows_pivoting}";
$slice_temp = "{$cols_pivoting}.={$riga_col}" . "--" . "{$rows_pivoting}.={$riga_row}--";
if ($slice_p != "") {
$slice_p = "{$slice_p}" . "{$slice_temp}";
} else {
$slice_p = "{$slice_temp}";
}
$query = SQLgenerator2($cubename_p, $level_ser, $slice_p, "", "");
//print "LEV $level_ser<br>";
//print "SLICE $slice_p<br>";
//print "$query<br>";
$result = exec_query($query);
$row = mysql_fetch_array($result);
return $row[0];
}
