function draw(&$row, $fields)
{
global $_CAMILA;
$formula = $this->report->queries[$this->field];
$wTable = substr($formula, 0, strpos($formula, ','));
$field = substr($formula, strlen($wTable) + 1);
$query = substr($field, strpos($field, ',') + 1);
$field = substr($field, 0, strpos($field, ','));
$url = camila_worktable_get_table_id($wTable);
$ttemp = new MiniTemplator();
$ttemp->setTemplateString($query);
foreach ($fields as $key) {
if ($key->value != '') {
$ttemp->setVariable($key->title, $key->value, true);
} else {
$ttemp->setVariable($key->title, '0', true);
}
}
$ttemp->generateOutputToString($query);
if ($field == camila_get_translation('camila.worktable.query.count')) {
$fields = array('camila_session_id' => $_REQUEST['PHPSESSID'], 'camila_xml' => '', 'filter' => $query, 'camila_export_no_table_data' => 'y');
$this->value = str_replace(array("\r", "\r\n", "\n"), '', strip_tags($this->httpGet($_SERVER['SERVER_NAME'], $_SERVER['SERVER_PORT'], '/' . CAMILA_APP_DIR . '/' . $url, $fields, array('PHPSESSID2' => $_REQUEST['PHPSESSID']))));
} else {
$this->value = camila_get_translation('camila.worktable.query.count') . ' not yet supported :-(';
}
parent::draw($row, $fields);
}
function draw(&$row, $fields)
{
global $_CAMILA;
$formula = $this->report->formulas[$this->field];
$ttemp = new MiniTemplator();
$ttemp->setTemplateString($formula);
foreach ($fields as $key) {
if ($key->value != '') {
$ttemp->setVariable($key->title, $key->value, true);
} else {
$ttemp->setVariable($key->title, '0', true);
}
}
$ttemp->generateOutputToString($formula);
$m = new EvalMath();
$this->value = $m->evaluate($formula);
parent::draw($row, $fields);
}
function camila_parse_default_expression($expression, $id, $dataImport = false)
{
global $_CAMILA;
if ($dataImport == true && $expression == camila_get_translation('camila.date.today')) {
return $_CAMILA['db']->BindTimeStamp(gmdate("Y-m-d", time()));
}
if ($dataImport == true && $expression == camila_get_translation('camila.time.now')) {
return $_CAMILA['db']->BindTimeStamp(gmdate("Y-m-d H:i:s", time()));
}
if ($dataImport == true && $expression == camila_get_translation('camila.worktable.field.default.lastval')) {
return '';
}
require_once CAMILA_LIB_DIR . 'minitemplator/MiniTemplator.class.php';
$ttemp = new MiniTemplator();
$ttemp->setTemplateString($expression);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.id'), $id, true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.j'), date('j'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.d'), date('d'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.z'), date('z'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.W'), date('W'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.dayoftheweek'), camila_get_translation('camila.week.day.' . date('w')), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.month'), camila_get_translation('camila.month.' . date('n')), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.n'), date('n'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.m'), date('m'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.y'), date('y'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.Y'), date('Y'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.g'), date('g'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.h'), date('h'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.G'), date('G'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.H'), date('H'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.i'), date('i'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.s'), date('s'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.A'), date('A'), true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.login'), $_CAMILA['user'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.name'), $_CAMILA['user_name'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.surname'), $_CAMILA['user_surname'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib01'), $_CAMILA['user_attrib_01'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib02'), $_CAMILA['user_attrib_02'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib03'), $_CAMILA['user_attrib_03'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib04'), $_CAMILA['user_attrib_04'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib05'), $_CAMILA['user_attrib_05'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib06'), $_CAMILA['user_attrib_06'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib07'), $_CAMILA['user_attrib_07'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib08'), $_CAMILA['user_attrib_08'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib09'), $_CAMILA['user_attrib_09'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib10'), $_CAMILA['user_attrib_10'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib11'), $_CAMILA['user_attrib_11'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib12'), $_CAMILA['user_attrib_12'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib13'), $_CAMILA['user_attrib_13'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib14'), $_CAMILA['user_attrib_14'], true);
$ttemp->setVariable(camila_get_translation('camila.worktable.field.default.user.attrib15'), $_CAMILA['user_attrib_15'], true);
$dir = CAMILA_TMPL_DIR . '/' . $_CAMILA['lang'] . '/';
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
if (substr($file, -4) == '.txt') {
$ttemp->setVariable(substr($file, 0, -4), file_get_contents($dir . $file), true);
}
}
closedir($dh);
}
$ttemp->generateOutputToString($expression);
return $expression;
}
