protected function build()
{
$this->add(new HiddenBox($this->id));
$build_tag_from_datasource = false;
if ($this->get_par('database-save-parameters')) {
$this->att('class', 'osy-taglist-onextab', true);
$build_tag_from_datasource = true;
}
$ul = $this->add(tag::create('ul'));
if ($sql = $this->get_par('datasource-sql')) {
$sql = HelperOsy::replacevariable($sql);
$res = $this->db->exec_query($sql, null, 'NUM');
$datalist = $this->add(tag::create('datalist'));
$datalist->att('id', $this->id . '_data');
foreach ($res as $k => $rec) {
if ($rec[2] == 1) {
$ul->add('<li class="osy-taglist-entry" tid="' . $rec[0] . '"><span class="osy-taglist-entry-text">' . $rec[1] . '</span><a href="#" class="osy-taglist-entry-remove">remove</a></li>');
}
$datalist->add(tag::create('option'))->add($rec[1]);
}
}
if (!$build_tag_from_datasource && !empty($_REQUEST[$this->id])) {
$item_list = explode(',', $_REQUEST[$this->id]);
foreach ($item_list as $k => $v) {
$ul->add('<li class="osy-taglist-entry" pos="' . $k . '"><span class="osy-taglist-entry-text">' . $v . '</span><a href="#" class="osy-taglist-entry-remove">remove</a></li>');
}
}
$txt = $ul->add(tag::create('li'))->att('class', 'listbuilder-entry-text')->add(tag::create('input'))->att('name', $this->id . '_add')->att('type', 'text')->att('class', 'add osy-taglist-input');
if (isset($datalist)) {
$txt->att('list', $this->id . '_data');
}
$ul->add('<br style="clear: both">');
}
/**
* Store a newly created resource in storage.
*
* @param
* @return \Illuminate\Http\Response
*/
public function store()
{
if (!Input::get('name') or !Input::get('done') or !Input::get('priority')) {
return $this->setStatusCode(IlluminateResponse::HTTP_UNPROCESSABLE_ENTITY)->respondWithError('Parameters failed validation for a tag.');
}
tag::create(Input::all());
return $this->respondCreated('tag successfully created.');
}
public function __construct($name)
{
parent::__construct('div');
$this->class = 'osy-textsearch';
$this->id = $name;
$this->add(new HiddenBox($name));
$this->textBox = $this->add(tag::create('input'))->att('type', 'text')->att('name', $name . '_lbl')->att('readonly', 'readonly');
$this->spanSrc = $this->add(tag::create('span'))->att('class', 'fa fa-search');
}
protected function build()
{
if ($lp = $this->get_par('label-position')) {
$this->panel->par('label-position', $lp);
}
if (!$this->get_par('disable-head')) {
$this->title = $this->add(tag::create('div'))->att('class', 'osy-panel-mobile-title');
$this->title->add(tag::create('span'))->att('class', 'osy-win-ico-set fright')->add(' ');
$this->title->add($this->get_par('label'));
}
}
public function __construct($name)
{
parent::__construct('dummy',$name);
env::$page->add_css(OSY_WEB_ROOT.'/css/leaflet.css');
env::$page->add_script(OSY_WEB_ROOT.'/js/component/omapgrid_openlayers.js');
$this->map = $this->add(tag::create('div'))->att('class','osy-mapgrid-openlayers');
$this->add(new HiddenBox($this->id.'_ne_lat'));
$this->add(new HiddenBox($this->id.'_ne_lng'));
$this->add(new HiddenBox($this->id.'_sw_lat'));
$this->add(new HiddenBox($this->id.'_sw_lng'));
$this->add(new HiddenBox($this->id.'_center'));
}
protected function build()
{
$this->add(tag::create('ul'));
//$this->iframe = $this->add(tag::create('iframe'));
//$this->iframe->att('name',$this->id)->att("style",'width: 100%;');
$src = $this->get_par('src');
if (!array_key_exists($this->id, $_REQUEST) && !empty($src)) {
$_REQUEST[$this->id] = $src;
}
if (array_key_exists($this->id, $_REQUEST) && !empty($_REQUEST[$this->id])) {
$this->att('src', $_REQUEST[$this->id]);
}
}
public function __construct($name)
{
parent::__construct('div', $name);
$this->att('class', 'osy-social');
Osy::$page->add_css(OSY_WEB_ROOT . '/css/Social.css');
Osy::$page->add_script(OSY_WEB_ROOT . '/js/component/Social.js');
$this->addRequire('css/Social.css');
$this->addRequire('js/component/Social.js');
$pst = $this->add(tag::create('div'))->att('class', 'osy-social-post');
$pst->add(new TextArea($name . '_post'))->att('class', 'osy-social-post');
$pst->add(tag::create('div'))->att('class', 'osy-social-post-canvas');
$pst->add(new Button($name . 'send'))->att('class', 'osy-social-send-post')->att('label', 'Post');
$this->add(tag::create('div'))->att('class', 'osy-social-body')->add('<ul class="notify">' . $this->printPostList($_REQUEST['_uid']) . '</ul>');
}
protected function build()
{
if (!empty($_REQUEST['ajax'])) {
die($this->ajaxResp());
}
if ($sql = $this->get_par('datasource-sql')) {
$this->dataLoad($sql);
}
$tbl = $this->add(tag::create('table'));
foreach ($this->data as $k => $rec) {
$tr = $tbl->add(tag::create('tr'))->att('data-param', base64_encode(serialize($rec)));
$td_prp = $tr->add(tag::create('td'))->att('class', 'osy-prop')->add($rec['p_label']);
$td_val = $tr->add(tag::create('td'))->att('class', 'osy-prop')->add(substr(htmlentities($rec['p_value']), 0, 100));
}
}
public static function objects($oid = 'root', $par = null)
{
if (!array_key_exists($oid, self::$data)) {
return;
}
if (is_null($par)) {
$par = self::$xml;
}
foreach (self::$data[$oid] as $k => $rec) {
$obj = $par->add(tag::create($rec['o_typ']))->att('id', $rec['o_id']);
foreach ($rec as $pid => $pvl) {
$pvl = strpos($pvl, '&') === false && strpos($pvl, '<') === false && strpos($pvl, '>') === false ? $pvl : '<![CDATA[' . PHP_EOL . $pvl . PHP_EOL . ']]>';
$obj->add(tag::create('property'))->att('name', $pid)->add($pvl);
}
$sub = self::objects($rec['o_id'], $obj->add(tag::create('children')));
//if (empty($sub)) $obj->add(tag::create('childs'))->add($sub);
}
return $par;
}
public function __construct($name)
{
parent::__construct('dummy', $name);
//env::$page->add_css(OSY_WEB_ROOT.'/css/omapgrid.css');
//env::$page->add_script('http://maps.google.com/maps/api/js?sensor=false&language=en&libraries=drawing');
//env::$page->add_script('/lib/gmap3-6.0.0/gmap3.min.js');
//env::$page->add_script(OSY_WEB_ROOT.'/js/component/MapGridGmap.js');
$this->addRequire('css/omapgrid.css');
$this->addRequire('http://maps.google.com/maps/api/js?sensor=false&language=en&libraries=drawing');
$this->addRequire('/vendor/gmap3-6.0.0/gmap3.min.js');
$this->addRequire('js/component/MapGridGmap.js');
$this->map = $this->add(tag::create('div'))->att('class', 'osy-mapgrid');
$this->add(new HiddenBox($this->id . '_ne_lat'));
$this->add(new HiddenBox($this->id . '_ne_lng'));
$this->add(new HiddenBox($this->id . '_sw_lat'));
$this->add(new HiddenBox($this->id . '_sw_lng'));
$this->add(new HiddenBox($this->id . '_center'));
$this->add(new HiddenBox($this->id . '_polygon'));
$this->add(new HiddenBox($this->id . '_refresh_bounds_blocked'));
}
protected function build()
{
$head = $this->add(tag::create('ul'));
ksort($this->__tabs);
$it = 0;
foreach ($this->__tabs as $row) {
ksort($row);
foreach ($row as $cols) {
foreach ($cols as $obj) {
$prefix = is_object($obj['obj']) ? $obj['obj']->get_par('label-prefix') . ' ' : '';
$head->add('<li><a href="#' . $this->id . '_' . $it . '" idx="' . $it . '"><p><span>' . $prefix . $obj['lbl'] . "</span></p></a></li>\n");
$div = $this->add(tag::create('div'))->att('id', $this->id . '_' . $it);
if ($this->get_par('cell-height')) {
$h = intval($this->get_par('cell-height'));
$obj['obj']->att('style', 'height : ' . ($h - 30) . 'px');
}
$div->add($obj['obj']);
$it++;
}
}
}
}
protected function build()
{
$img = '';
//var_dump($_REQUEST[$this->id]);
if (!empty($_REQUEST[$this->id])) {
if ($inblob = $this->get_par('store-in-blob')) {
$img = '<img src="data:image/png;base64,' . base64_encode($_REQUEST[$this->id]) . '">';
} else {
$filename = $_SERVER['DOCUMENT_ROOT'] . $_REQUEST[$this->id];
if (file_exists($filename)) {
$img = '<img src="' . $filename . '">';
}
}
if (!empty($img) && ($dim_max = $this->get_par('crop-dimension'))) {
$dim_img = getimagesize($filename);
$dim_max = explode(',', $dim_max);
if ($dim_max[0] < $dim_img[0] && $dim_max[1] < $dim_img[1]) {
$this->att('class', 'image-crop', true);
$this->add('<input type="hidden" id="' . $this->id . '_crop" name="' . $this->id . '_crop" class="osy-imagebox-crop">');
$prw = $this->add(tag::create('div'))->att('class', 'osy-imagebox-previewbox');
$prw->add('<div style="width: 140px; height: 140px; overflow: hidden;"><img src="' . $_REQUEST[$this->id] . '" class="osy-imagebox-preview"></div>');
$prw->add('<span id="' . $this->id . '_get_crop" class="osy-imagebox-cmd-crop btn_cnf w100 center"><span class="fa fa-cut"></span> Taglia</span>');
$this->add('<img src="' . $_REQUEST[$this->id] . '" class="osy-imagebox-master">');
return;
}
$this->add('<div><img src="' . $_REQUEST[$this->id] . '" class="osy-imagebox-master" title="' . $_REQUEST[$this->id] . '"></div>', true);
}
}
if ($dim = $this->get_par('max-dimension')) {
$dim = explode(',', $dim);
$sty = ' style="width:' . $dim[0] . 'px; height: ' . $dim[1] . 'px;"';
}
$this->add('<label class="osy-imagebox-dummy"' . $sty . ' for="' . $this->id . '_file">' . (empty($img) ? '<span class="fa fa-camera" ></span>' : $img) . '</label>');
if (!empty($img)) {
$this->add(tag::create('div'))->att('class', 'osy-imagebox-cmd center')->add(tag::create('a'))->att('href', 'javascript:void(0);')->att('onclick', "oimagebox.delete('" . $this->id . "')")->att('data-cmd', 'delete')->add('Elimina <span class="fa fa-trash"></span>');
}
//$this->add(tag::create('label'))->att('class','btn_add center')->att('for',$this->id.'_file')->add('Upload');
}
private function buildPie($datasets)
{
$js .= (empty($js) ? '' : ",\n") . "{value : " . (array_key_exists(1, $rec) ? $rec[1] : 0) . ",color : '" . (!empty($this->_color[$k]) ? $this->_color[$k] : '') . "'}";
$tr = $this->legend->add(tag::create('tr'));
$tr->add(tag::create('td'))->att('style', 'padding: 5px;')->add('<span style="background-color: ' . $this->_color[$k] . '; padding: 0px 5px; border-radius: 1px; border: 2px solid whitesmoke;";> </span>');
$tr->add(tag::create('td'))->att('style', 'padding: 5px;')->add($rec[0]);
$tr->add(tag::create('td'))->att('style', 'padding: 5px;')->add($rec[1]);
$tr->add(tag::create('td'))->att('style', 'padding: 5px;')->add(round($rec[1] / $tot * 100, 2) . ' %');
$js = "var data = [\n" . $js . "\n];" . PHP_EOL;
$js .= "var ctx = document.getElementById('" . $this->canvas->id . "_canvas').getContext('2d');\r\n var chr = new Chart(ctx).Pie(data);";
return;
}
protected function build()
{
$sql = $this->get_par('datasource-sql');
if (empty($sql)) {
die('[ERROR] - Multibox ' . $this->id . ' - query builder assente');
}
$sql = $this->replacePlaceholder($sql);
$res = $this->db->exec_query($sql, null, 'ASSOC');
//die($sql);
if (empty($res)) {
return;
}
$mlt_tbl = $this->add(tag::create('table'));
$val_from_db = array_key_exists($this->id, $_REQUEST) && is_array($_REQUEST[$this->id]) ? false : true;
foreach ($res as $k => $cmp_raw) {
if ($val_from_db) {
$_REQUEST[$this->id][$cmp_raw['id']] = $cmp_raw['val'];
}
$mlt_row = $mlt_tbl->add(tag::create('tr'));
$cmp = $lbl = null;
if (strlen($this->readonly) > 4) {
$this->readonly = HelperOsy::exec_string(null, 'return ' . $this->readonly . ';');
}
if ($this->readonly) {
$cmp = tag::create('span');
if ($cmp_raw['typ'] == 'CMB') {
$cmp_raw['val'] = label::getFromDatasource($cmp_raw['val'], $cmp_raw['sql_qry'], $this->db);
}
$cmp->add($cmp_raw['val']);
} else {
$is_req = $cmp_raw['is_req'];
$cmp_nam = "{$this->id}[{$cmp_raw['id']}]";
switch ($cmp_raw['typ']) {
case 'DAT':
$cmp = new DateBox($cmp_nam);
$cmp->par('date-format', 'dd/mm/yyyy');
break;
case 'TXT':
case 'NUM':
$cmp = new TextBox($cmp_nam);
if ($cmp_raw['typ'] == 'NUM') {
$cmp->att('class', 'numeric', true);
} else {
$cmp->att('class', 'text', true);
}
break;
case 'CMB':
$cmp = new ComboBox($cmp_nam);
//echo $cmp_raw['sql_qry'];
$cmp->par('datasource-sql', HelperOsy::replaceVariable($cmp_raw['sql_qry']));
break;
}
$cmp->att('label', $cmp_raw['nam']);
if (!empty($is_req)) {
$lbl = '(*) ';
$cmp->att('class', 'is-request', true);
}
}
if (!is_null($cmp)) {
$lbl = "<label class=\"multibox\">{$lbl}{$cmp_raw['nam']}</label>";
$mlt_row->add(new Tag('td'))->add($lbl);
$mlt_row->add(new Tag('td'))->add($cmp);
}
}
}
public function buildAjax()
{
$form_pkey = array();
if ($form = $this->get_par('form-related')) {
$form_par = $this->getFormParam($form, true);
$form_pkey = $form_par['pkey'];
}
$tbl = new Tag('div');
$sql = $this->replacePlaceholder($this->get_par('datasource-sql'));
$rs = $this->db->exec_query("SELECT * FROM (" . $sql . ") a", null, 'ASSOC');
$cols = $this->db->get_columns();
foreach ($cols as $col) {
if ($col['name'] == '_group') {
$rs = $this->groupRs($rs);
}
}
$__g = '';
foreach ($rs as $rec) {
$tr = tag::create('div')->att('class', 'row');
$__k = array();
$_oid = array();
foreach ($rec as $key => $fld) {
$val = $fld;
if (in_array($key, $form_pkey)) {
$__k[] = 'pkey[' . $key . ']=' . $val;
$_oid[] = $val;
continue;
}
$print = true;
if ($key[0] == '_') {
$print = false;
switch ($key) {
case '_id':
$tr->att('data-oid', $val);
$print = false;
break;
case '_label':
$tr->att('data-label', $val);
$print = false;
break;
case '_group':
if ($val != $__g) {
$__g = $val;
} else {
$val = ' ';
}
$val = '<span class="osy-textsearch-inline-group">' . $val . '</span>';
$print = true;
break;
case '_img64x2':
$dimcls = 'osy-image-med';
//no-break
//no-break
case '_img64':
$val = '<span class="' . (empty($dimcls) ? 'osy-image-min' : $dimcls) . '">' . (empty($fld) ? '<span class="fa fa-ban"></span>' : '<img src="data:image/png;base64,' . base64_encode($fld) . '">') . '</span>';
$print = true;
break;
case '_label':
$tr->att('data-label', $val);
break;
}
}
if ($print) {
$tr->add(tag::create('div'))->add($val);
}
}
//$tr->add('<br class="clear">');
$tbl->add($tr);
if (!empty($__k)) {
$tr->att('data-pkey', implode('&', $__k));
$tr->att('data-oid', implode('&', $_oid));
}
}
return $tbl;
}
protected static function __build_field_search__()
{
if (!empty($_POST['ajax'])) return;
$div = new dummy('osy-dataview-search');
$div->att('class',"osy-dataview-search");
$div->par('colspan','100',function($key,$val,$self){
$self->man('onbuild','colspan',function($val,$self)
{
$cel = $self->closest('td,th');
if (!is_object($cel)) return;
$cel->att('colspan','100');
});
});
self::$form->put($div,'','bar-search',2,1);
$div->add("Cerca");
$div->add(new text_box('search_value'))->att('size','30');
$div->add(" in ");
$select = $div->add(new combo_box('search_field'));
//Tasto ricerca
$div->add(new button('btn_search'))->att('label','Avvia ricerca');
//Tasto pulisci filtro
$div->add(new button('btn_search_reset'))->att('label','Elimina filtro');
//Contenitore dei filtri attivi
$div_flt_cnt = $div->add(tag::create("div"))->att('class','filter-active');
if (key_exists('filter',$_POST) && is_array($_POST['filter']))
{
foreach($_POST['filter'] as $k => $v)
{
$div_flt = $div_flt_cnt->add(tag::create('div'))->att("class","filter");
$div_flt->add(new hidden_box("filter[$k]"))->Att('value',$v);
switch($k[0]){
case '!':
case '€':
case '$':
case '#':
$k = substr($k,1);
break;
case '_':
list($a,$k) = explode(',',$k);
break;
}
$div_flt->add("$k : $v");
}
$div->add($div_flt_cnt);
} else {
$div->par('init-cell','hidden',function($key,$val,$self){
$self->man('onbuild','init-cell',function($val,$self)
{
$cel = $self->closest('td,th');
if (!is_object($cel)) return;
$cel->att('class',$val)->att('colspan','100');
});
});
}
$div_flt_cnt->add(tag::create("div"))->att("style","clear: both");
}
public function getFormIconify()
{
$usr = $this->getCurrentUser();
$sql = "SELECT f.o_id as form_id,f.o_nam as form_name,ic.p_vl as icon,coalesce(fw.p_vl,'640') as form_width,coalesce(fh.p_vl,'480') as form_height " . "FROM osy_obj_rel a " . "INNER JOIN osy_obj f ON (a.o_2 = f.o_own AND f.o_typ = 'form') " . "INNER JOIN osy_obj_prp i ON (f.o_id = i.o_id AND i.p_id = 'iconify' AND i.p_vl = '1') " . "LEFT JOIN osy_obj_prp ic ON (f.o_id = ic.o_id AND ic.p_id = 'iconify-icon') " . "LEFT JOIN osy_obj_prp fw ON (f.o_id = fw.o_id AND fw.p_id = 'width') " . "LEFT JOIN osy_obj_prp fh ON (f.o_id = fh.o_id AND fh.p_id = 'height') " . "WHERE a.o_1 = CONCAT('instance://',?,'/') AND a.r_typ = 'instance+application'";
//echo $sql;
$res = $this->model->dbo->exec_query($sql, array($this->request->get('instance.id')));
$iconify = new Tag('span');
$iconify->add(print_r($this->request->get('input'), true));
if (!empty($res)) {
$iconify = new Tag('ul');
foreach ($res as $rec) {
$item = new Tag('span');
$item->att('id', $rec['form_name'])->att('data-fid', $rec['form_id'])->att('data-form-width', $rec['form_width'])->att('data-form-height', $rec['form_height'])->add(str_replace('CURRENT_USER', $usr, $rec['icon']));
$iconify->add(tag::create('li'))->add($item);
}
}
return $iconify->att('id', 'iconify-forms')->att('style', 'display:none;');
}
public function addMeta()
{
return $this->get('head')->add(tag::create('meta'));
}
private function buildBody()
{
if (!$this->pageView()) {
ob_clean();
die('');
return;
}
//$rs = $this->db->execquery($this->sql);
$b = new tag('div');
$b->att('class', 'osy-addressbook-body')->att('pag', $this->get_par('pag_cur'))->att('scroll-master', $this->get_par('scroll-master'));
try {
$par = $this->get_par('filter-parameters');
$rs = env::$dba->exec_query($this->__par['datasource-sql'], $par, 'ASSOC');
} catch (Exception $e) {
die($e->getMessage() . ' - ' . $this->__par['datasource-sql']);
}
//while($rec = $this->db->getnextrecord($rs,'ASSOC'))
if (empty($rs)) {
if (empty($_REQUEST['ajax'])) {
$title = $this->get_par('title');
if (!empty($title)) {
$title = in_array(strtolower($title[0]), array('a', 'e', 'i', 'o', 'u')) ? "L'" . strtolower($title) : $title;
}
$this->add($b)->add('<div class="osy-addressbook-empty">' . $title . ' è vuota</div>');
}
return;
}
//Query columns
$col = '';
foreach (array_keys($rs[0]) as $k => $v) {
if ($v[0] != '_') {
$col .= (empty($col) ? '' : ',') . $v;
}
}
$this->att('data-columns', $col);
foreach ($rs as $k => $rec) {
$a = $b->add(tag::create('div'))->att('class', 'osy-addressbook-item');
$p0 = $a->add(tag::create('div'))->att('class', 'p0');
$p1 = $a->add(tag::create('div'))->att('class', 'p1');
$p2 = $a->add(tag::create('div'))->att('class', 'p2');
//$p2->add(' ');
$i = 0;
$href = null;
foreach ($rec as $k => $v) {
if (key_exists('pkey', $this->__par) && is_array($this->__par['pkey']) && in_array($k, $this->__par['pkey'])) {
if (!empty($v)) {
$pk = $v;
$a->att('__k', "pkey[{$k}]={$v}", '&');
if (!$a->oid) {
$a->att('oid', $v);
}
} else {
$a->__k = str_replace('pkey', 'fkey', $a->__k);
}
$t++;
continue;
}
switch ($k) {
case '_class':
$a->att('class', $v, true);
break;
case '_pk':
$a->att('pid', $v);
if ($this->get_par('form') != null && $this->get_par('cmd_upd') != false) {
$cmd = str_replace(array('<pk>', '<fid>', '640', '480'), array($v, $this->get_par('form')), $this->__par['cmd_upd']);
$a->att('onclick', $cmd);
}
break;
case '_href':
$href = $v;
break;
case '_p0':
$img = '<img src="' . $v . '">';
if (!empty($href)) {
$img = '<a href="' . $href . '">' . $img . '</a>';
}
$p0->add($img);
break;
case '_p2':
$p2->add('<div>' . $v . '</div>');
break;
case '_image':
if (!empty($v)) {
$p1->add(tag::create('img'))->att('src', 'data:image/png;base64,' . base64_encode($v));
}
break;
default:
if ($k[0] == '_') {
break;
}
$i++;
if (empty($v)) {
break;
}
if (empty($href)) {
$p1->add('<div class="s' . $i . '">' . $v . '</div>');
} else {
$p1->add('<a class="s' . $i . '" href="' . $href . '">' . $v . '</a><br>');
}
break;
}
}
}
$this->add($b);
$this->add('<br id="qnn-end" style="clear: both">');
}
public function __construct($name)
{
parent::__construct('div', $name);
$this->att('class', 'osy-htmlarea');
$this->addRequire('js/component/HtmlArea.js');
$toolbar = <<<TOOLBAR
<div id="edit-bar">
<input type="hidden" name="myDoc">
<div id="toolBar1">
<select onchange="ohtmlarea.format_document('formatblock',this[this.selectedIndex].value);this.selectedIndex=0;">
<option selected>- formatting -</option>
<option value="h1">Title 1 <h1></option>
<option value="h2">Title 2 <h2></option>
<option value="h3">Title 3 <h3></option>
<option value="h4">Title 4 <h4></option>
<option value="h5">Title 5 <h5></option>
<option value="h6">Subtitle <h6></option>
<option value="p">Paragraph <p></option>
<option value="pre">Preformatted <pre></option>
</select>
<select onchange="ohtmlarea.format_document('fontname',this[this.selectedIndex].value);this.selectedIndex=0;">
<option class="heading" selected>- font -</option>
<option>Arial</option>
<option>Arial Black</option>
<option>Courier New</option>
<option>Times New Roman</option>
</select>
<select onchange="ohtmlarea.format_document('fontsize',this[this.selectedIndex].value);this.selectedIndex=0;">
<option class="heading" selected>- size -</option>
<option value="1">Very small</option>
<option value="2">A bit small</option>
<option value="3">Normal</option>
<option value="4">Medium-large</option>
<option value="5">Big</option>
<option value="6">Very big</option>
<option value="7">Maximum</option>
</select>
<select onchange="ohtmlarea.format_document('forecolor',this[this.selectedIndex].value);this.selectedIndex=0;">
<option class="heading" selected>- color -</option>
<option value="red">Red</option>
<option value="blue">Blue</option>
<option value="green">Green</option>
<option value="black">Black</option>
</select>
<select onchange="ohtmlarea.format_document('backcolor',this[this.selectedIndex].value);this.selectedIndex=0;">
<option class="heading" selected>- background -</option>
<option value="red">Red</option>
<option value="green">Green</option>
<option value="black">Black</option>
</select>
<span><input type="checkbox" name="switchMode" id="switchBox" onchange="ohtmlarea.set_document_mode(this.checked);" /> <label for="switchBox" style="display: inline">Show HTML</label></span>
</div>
<div id="toolBar2">
<img class="intLink" title="Clean" onclick="ohtmlarea.clean()" src="data:image/gif;base64,R0lGODlhFgAWAIQbAD04KTRLYzFRjlldZl9vj1dusY14WYODhpWIbbSVFY6O7IOXw5qbms+wUbCztca0ccS4kdDQjdTLtMrL1O3YitHa7OPcsd/f4PfvrvDv8Pv5xv///////////////////yH5BAEKAB8ALAAAAAAWABYAAAV84CeOZGmeaKqubMteyzK547QoBcFWTm/jgsHq4rhMLoxFIehQQSAWR+Z4IAyaJ0kEgtFoLIzLwRE4oCQWrxoTOTAIhMCZ0tVgMBQKZHAYyFEWEV14eQ8IflhnEHmFDQkAiSkQCI2PDC4QBg+OAJc0ewadNCOgo6anqKkoIQA7" />
<img class="intLink" title="Print" onclick="ohtmlarea.print_doc();" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAABGdBTUEAALGPC/xhBQAAAAZiS0dEAP8A/wD/oL2nkwAAAAlwSFlzAAALEwAACxMBAJqcGAAAAAd0SU1FB9oEBxcZFmGboiwAAAAIdEVYdENvbW1lbnQA9syWvwAAAuFJREFUOMvtlUtsjFEUx//n3nn0YdpBh1abRpt4LFqtqkc3jRKkNEIsiIRIBBEhJJpKlIVo4m1RRMKKjQiRMJRUqUdKPT71qpIpiRKPaqdF55tv5vvusZjQTjOlseUkd3Xu/3dPzusC/22wtu2wRn+jG5So/OCDh8ycMJDflehMlkJkVK7KUYN+ufzA/RttH76zaVocDptRxzQtNi3mRWuPc+6cKtlXZ/sddP2uu9uXlmYXZ6Qm8v4Tz8lhF1H+zDQXt7S8oLMXtbF4e8QaFHjj3kbP2MzkktHpiTjp9VH6iHiA+whtAsX5brpwueMGdONdf/2A4M7ukDs1JW662+XkqTkeUoqjKtOjm2h53YFL15pSJ04Zc94wdtibr26fXlC2mzRvBccEbz2kiRFD414tKMlEZbVGT33+qCoHgha81SWYsew0r1uzfNylmtpx80pngQQ91LwVk2JGvGnfvZG6YcYRAT16GFtW5kKKfo1EQLtfh5Q2etT0BIWF+aitq4fDbk+ImYo1OxvGF03waFJQvBCkvDffRyEtxQiFFYgAZTHS0zwAGD7fG5TNnYNTp8/FzvGwJOfmgG7GOx0SAKKgQgDMgKBI0NJGMEImpGDk5+WACEwEd0ywblhGUZ4Hw5OdUekRBLT7DTgdEgxACsIznx8zpmWh7k4rkpJcuHDxCul6MDsmmBXDlWCH2+XozSgBnzsNCEE4euYV4pwCpsWYPW0UHDYBKSWu1NYjENDReqtKjwn2+zvtTc1vMSTB/mvev/WEYSlASsLimcOhOBJxw+N3aP/SjefNL5GePZmpu4kG7OPr1+tOfPyUu3BecWYKcwQcDFmwFKAUo90fhKDInBCAmvqnyMgqUEagQwCoHBDc1rjv9pIlD8IbVkz6qYViIBQGTJPx4k0XpIgEZoRN1Da0cij4VfR0ta3WvBXH/rjdCufv6R2zPgPH/e4pxSBCpeatqPrjNiso203/5s/zA171Mv8+w1LOAAAAAElFTkSuQmCC">
<img class="intLink" title="Undo" onclick="ohtmlarea.format_document('undo');" src="data:image/gif;base64,R0lGODlhFgAWAOMKADljwliE33mOrpGjuYKl8aezxqPD+7/I19DV3NHa7P///////////////////////yH5BAEKAA8ALAAAAAAWABYAAARR8MlJq7046807TkaYeJJBnES4EeUJvIGapWYAC0CsocQ7SDlWJkAkCA6ToMYWIARGQF3mRQVIEjkkSVLIbSfEwhdRIH4fh/DZMICe3/C4nBQBADs=" />
<img class="intLink" title="Redo" onclick="ohtmlarea.format_document('redo');" src="data:image/gif;base64,R0lGODlhFgAWAMIHAB1ChDljwl9vj1iE34Kl8aPD+7/I1////yH5BAEKAAcALAAAAAAWABYAAANKeLrc/jDKSesyphi7SiEgsVXZEATDICqBVJjpqWZt9NaEDNbQK1wCQsxlYnxMAImhyDoFAElJasRRvAZVRqqQXUy7Cgx4TC6bswkAOw==" />
<img class="intLink" title="Remove formatting" onclick="ohtmlarea.format_document('removeFormat')" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAABGdBTUEAALGPC/xhBQAAAAZiS0dEAP8A/wD/oL2nkwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAAd0SU1FB9oECQMCKPI8CIIAAAAIdEVYdENvbW1lbnQA9syWvwAAAuhJREFUOMtjYBgFxAB501ZWBvVaL2nHnlmk6mXCJbF69zU+Hz/9fB5O1lx+bg45qhl8/fYr5it3XrP/YWTUvvvk3VeqGXz70TvbJy8+Wv39+2/Hz19/mGwjZzuTYjALuoBv9jImaXHeyD3H7kU8fPj2ICML8z92dlbtMzdeiG3fco7J08foH1kurkm3E9iw54YvKwuTuom+LPt/BgbWf3//sf37/1/c02cCG1lB8f//f95DZx74MTMzshhoSm6szrQ/a6Ir/Z2RkfEjBxuLYFpDiDi6Af///2ckaHBp7+7wmavP5n76+P2ClrLIYl8H9W36auJCbCxM4szMTJac7Kza////R3H1w2cfWAgafPbqs5g7D95++/P1B4+ECK8tAwMDw/1H7159+/7r7ZcvPz4fOHbzEwMDwx8GBgaGnNatfHZx8zqrJ+4VJBh5CQEGOySEua/v3n7hXmqI8WUGBgYGL3vVG7fuPK3i5GD9/fja7ZsMDAzMG/Ze52mZeSj4yu1XEq/ff7W5dvfVAS1lsXc4Db7z8C3r8p7Qjf///2dnZGxlqJuyr3rPqQd/Hhyu7oSpYWScylDQsd3kzvnH738wMDzj5GBN1VIWW4c3KDon7VOvm7S3paB9u5qsU5/x5KUnlY+eexQbkLNsErK61+++VnAJcfkyMTIwffj0QwZbJDKjcETs1Y8evyd48toz8y/ffzv//vPP4veffxpX77z6l5JewHPu8MqTDAwMDLzyrjb/mZm0JcT5Lj+89+Ybm6zz95oMh7s4XbygN3Sluq4Mj5K8iKMgP4f0////fv77//8nLy+7MCcXmyYDAwODS9jM9tcvPypd35pne3ljdjvj26+H2dhYpuENikgfvQeXNmSl3tqepxXsqhXPyc666s+fv1fMdKR3TK72zpix8nTc7bdfhfkEeVbC9KhbK/9iYWHiErbu6MWbY/7//8/4//9/pgOnH6jGVazvFDRtq2VgiBIZrUTIBgCk+ivHvuEKwAAAAABJRU5ErkJggg==">
<img class="intLink" title="Bold" onclick="ohtmlarea.format_document('bold');" src="data:image/gif;base64,R0lGODlhFgAWAID/AMDAwAAAACH5BAEAAAAALAAAAAAWABYAQAInhI+pa+H9mJy0LhdgtrxzDG5WGFVk6aXqyk6Y9kXvKKNuLbb6zgMFADs=" />
<img class="intLink" title="Italic" onclick="ohtmlarea.format_document('italic');" src="data:image/gif;base64,R0lGODlhFgAWAKEDAAAAAF9vj5WIbf///yH5BAEAAAMALAAAAAAWABYAAAIjnI+py+0Po5x0gXvruEKHrF2BB1YiCWgbMFIYpsbyTNd2UwAAOw==" />
<img class="intLink" title="Underline" onclick="ohtmlarea.format_document('underline');" src="data:image/gif;base64,R0lGODlhFgAWAKECAAAAAF9vj////////yH5BAEAAAIALAAAAAAWABYAAAIrlI+py+0Po5zUgAsEzvEeL4Ea15EiJJ5PSqJmuwKBEKgxVuXWtun+DwxCCgA7" />
<img class="intLink" title="Left align" onclick="ohtmlarea.format_document('justifyleft');" src="data:image/gif;base64,R0lGODlhFgAWAID/AMDAwAAAACH5BAEAAAAALAAAAAAWABYAQAIghI+py+0Po5y02ouz3jL4D4JMGELkGYxo+qzl4nKyXAAAOw==" />
<img class="intLink" title="Center align" onclick="ohtmlarea.format_document('justifycenter');" src="data:image/gif;base64,R0lGODlhFgAWAID/AMDAwAAAACH5BAEAAAAALAAAAAAWABYAQAIfhI+py+0Po5y02ouz3jL4D4JOGI7kaZ5Bqn4sycVbAQA7" />
<img class="intLink" title="Right align" onclick="ohtmlarea.format_document('justifyright');" src="data:image/gif;base64,R0lGODlhFgAWAID/AMDAwAAAACH5BAEAAAAALAAAAAAWABYAQAIghI+py+0Po5y02ouz3jL4D4JQGDLkGYxouqzl43JyVgAAOw==" />
<img class="intLink" title="Numbered list" onclick="ohtmlarea.format_document('insertorderedlist');" src="data:image/gif;base64,R0lGODlhFgAWAMIGAAAAADljwliE35GjuaezxtHa7P///////yH5BAEAAAcALAAAAAAWABYAAAM2eLrc/jDKSespwjoRFvggCBUBoTFBeq6QIAysQnRHaEOzyaZ07Lu9lUBnC0UGQU1K52s6n5oEADs=" />
<img class="intLink" title="Dotted list" onclick="ohtmlarea.format_document('insertunorderedlist');" src="data:image/gif;base64,R0lGODlhFgAWAMIGAAAAAB1ChF9vj1iE33mOrqezxv///////yH5BAEAAAcALAAAAAAWABYAAAMyeLrc/jDKSesppNhGRlBAKIZRERBbqm6YtnbfMY7lud64UwiuKnigGQliQuWOyKQykgAAOw==" />
<img class="intLink" title="Quote" onclick="ohtmlarea.format_document('formatblock','blockquote');" src="data:image/gif;base64,R0lGODlhFgAWAIQXAC1NqjFRjkBgmT9nqUJnsk9xrFJ7u2R9qmKBt1iGzHmOrm6Sz4OXw3Odz4Cl2ZSnw6KxyqO306K63bG70bTB0rDI3bvI4P///////////////////////////////////yH5BAEKAB8ALAAAAAAWABYAAAVP4CeOZGmeaKqubEs2CekkErvEI1zZuOgYFlakECEZFi0GgTGKEBATFmJAVXweVOoKEQgABB9IQDCmrLpjETrQQlhHjINrTq/b7/i8fp8PAQA7" />
<img class="intLink" title="Add indentation" onclick="ohtmlarea.format_document('outdent');" src="data:image/gif;base64,R0lGODlhFgAWAMIHAAAAADljwliE35GjuaezxtDV3NHa7P///yH5BAEAAAcALAAAAAAWABYAAAM2eLrc/jDKCQG9F2i7u8agQgyK1z2EIBil+TWqEMxhMczsYVJ3e4ahk+sFnAgtxSQDqWw6n5cEADs=" />
<img class="intLink" title="Delete indentation" onclick="ohtmlarea.format_document('indent');" src="data:image/gif;base64,R0lGODlhFgAWAOMIAAAAADljwl9vj1iE35GjuaezxtDV3NHa7P///////////////////////////////yH5BAEAAAgALAAAAAAWABYAAAQ7EMlJq704650B/x8gemMpgugwHJNZXodKsO5oqUOgo5KhBwWESyMQsCRDHu9VOyk5TM9zSpFSr9gsJwIAOw==" />
<img class="intLink" title="Hyperlink" onclick="ohtmlarea.add_link()" src="data:image/gif;base64,R0lGODlhFgAWAOMKAB1ChDRLY19vj3mOrpGjuaezxrCztb/I19Ha7Pv8/f///////////////////////yH5BAEKAA8ALAAAAAAWABYAAARY8MlJq7046827/2BYIQVhHg9pEgVGIklyDEUBy/RlE4FQF4dCj2AQXAiJQDCWQCAEBwIioEMQBgSAFhDAGghGi9XgHAhMNoSZgJkJei33UESv2+/4vD4TAQA7" />
<img class="intLink" title="Cut" onclick="ohtmlarea.format_document('cut');" src="data:image/gif;base64,R0lGODlhFgAWAIQSAB1ChBFNsRJTySJYwjljwkxwl19vj1dusYODhl6MnHmOrpqbmpGjuaezxrCztcDCxL/I18rL1P///////////////////////////////////////////////////////yH5BAEAAB8ALAAAAAAWABYAAAVu4CeOZGmeaKqubDs6TNnEbGNApNG0kbGMi5trwcA9GArXh+FAfBAw5UexUDAQESkRsfhJPwaH4YsEGAAJGisRGAQY7UCC9ZAXBB+74LGCRxIEHwAHdWooDgGJcwpxDisQBQRjIgkDCVlfmZqbmiEAOw==" />
<img class="intLink" title="Copy" onclick="ohtmlarea.format_document('copy');" src="data:image/gif;base64,R0lGODlhFgAWAIQcAB1ChBFNsTRLYyJYwjljwl9vj1iE31iGzF6MnHWX9HOdz5GjuYCl2YKl8ZOt4qezxqK63aK/9KPD+7DI3b/I17LM/MrL1MLY9NHa7OPs++bx/Pv8/f///////////////yH5BAEAAB8ALAAAAAAWABYAAAWG4CeOZGmeaKqubOum1SQ/kPVOW749BeVSus2CgrCxHptLBbOQxCSNCCaF1GUqwQbBd0JGJAyGJJiobE+LnCaDcXAaEoxhQACgNw0FQx9kP+wmaRgYFBQNeAoGihCAJQsCkJAKOhgXEw8BLQYciooHf5o7EA+kC40qBKkAAAGrpy+wsbKzIiEAOw==" />
<img class="intLink" title="Paste" onclick="ohtmlarea.format_document('paste');" src="data:image/gif;base64,R0lGODlhFgAWAIQUAD04KTRLY2tXQF9vj414WZWIbXmOrpqbmpGjudClFaezxsa0cb/I1+3YitHa7PrkIPHvbuPs+/fvrvv8/f///////////////////////////////////////////////yH5BAEAAB8ALAAAAAAWABYAAAWN4CeOZGmeaKqubGsusPvBSyFJjVDs6nJLB0khR4AkBCmfsCGBQAoCwjF5gwquVykSFbwZE+AwIBV0GhFog2EwIDchjwRiQo9E2Fx4XD5R+B0DDAEnBXBhBhN2DgwDAQFjJYVhCQYRfgoIDGiQJAWTCQMRiwwMfgicnVcAAAMOaK+bLAOrtLUyt7i5uiUhADs=" />
<input type="button" value="c" onclick="ohtmlarea.format_document('insertTable')">
</div>
</div>
TOOLBAR;
$this->add($toolbar);
$this->add(new TextArea($name));
$this->edit = tag::create("div");
$this->edit->att('class', 'osy-htmlarea-edit');
$this->add($this->edit);
}
private function __make_item__($par, $items, $class = '', $hour = '')
{
$pkey = $this->get_par('pkey');
foreach ($items as $k => $rec) {
if (empty($rec)) {
continue;
}
$div = $par->add(tag::create('div'))->att('class', 'event ' . (!empty($rec['event_color']) ? $rec['event_color'] : 'osy-event-color-normal'));
if (!empty($rec['hour'])) {
$end = $rec['event_end'] ? " → " . $rec['event_end'] : '';
$div->add("<span class=\"event-time\">{$rec['hour']}{$end}</span>");
} elseif (!empty($rec['event_duration'])) {
$div->add("<span class=\"event-time\">{$rec['event_duration']} min</span>");
}
$itm = $div->add(tag::create('div'))->att('class', 'event-body');
$itm->add($rec['event']);
if (is_array($pkey)) {
$key = array();
foreach ($pkey as $k => $fld) {
if (array_key_exists($fld, $rec)) {
$key[] = 'pkey[' . $fld . ']=' . $rec[$fld];
}
}
if (count($pkey) == count($key)) {
$itm->att('__k', implode('&', $key))->att('class', 'osy-view-calendar-item', true);
}
}
}
return $itm;
}
public function getStatistics()
{
//Calcolo statistiche
if ($sql_stat = $this->get_par('datasource-sql-stat')) {
try {
$sql_stat = $this->replacePlaceholder(str_replace('<[datasource-sql]>', $sql, $sql_stat) . $whr);
$stat = $this->source->exec_unique($sql_stat, null, 'ASSOC');
if (!is_array($stat)) {
$stat = array($stat);
}
$dstat = tag::create('div')->att('class', "osy-datagrid-stat");
$tr = $dstat->add(tag::create('table'))->att('align', 'right')->add(tag::create('tr'));
foreach ($stat as $k => $v) {
$v = $v > 1000 ? number_format($v, 2, ',', '.') : $v;
$tr->add(new Tag('td'))->add(' ');
$tr->add(new Tag('td'))->att('title', $k)->add($k);
$tr->add(new Tag('td'))->add($v);
}
$this->__par['div-stat'] = $dstat;
} catch (Exception $e) {
$this->par('error-in-sql-stat', '<pre>' . $sql_stat . "\n" . $e->getMessage() . '</pre>');
}
}
}
