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; }