function array_to_table($arr)
{
$res = new dom_any();
$res->node_name = 'table';
$res->attributes['cellspacing'] = '0';
$cnt = 0;
foreach ($arr as $i => $v) {
$tr = new dom_any();
$tr->node_name = 'tr';
$td = new dom_any();
$td->node_name = 'td';
$txt = new dom_statictext();
$txt->text = $i;
$td->append_child($txt);
$tr->append_child($td);
$td = new dom_any();
$td->node_name = 'td';
$txt = new dom_statictext();
$txt->text = $v;
$td->append_child($txt);
$tr->append_child($td);
$tr->attributes['width'] = $cnt++ % 2;
$res->append_child($tr);
}
return $res;
}
function __construct($qg)
{
parent::__construct('div');
$this->qg = $qg;
$this->css_style['padding'] = '0px';
$this->css_style['margin'] = '0px';
$this->css_style['border'] = '0px';
$this->table = new dom_table();
$this->row = new dom_tr();
$this->hrow = new dom_tr();
$this->hrow->css_class = 'head';
$this->table->css_style['page-break-after'] = 'always';
$this->table->css_style['padding'] = '0px';
$this->table->css_style['margin'] = '0px';
$this->table->css_style['border'] = '0px';
$this->table->css_style['border-collapse'] = 'collapse';
$this->row->css_style['height'] = '8mm';
foreach ($this->qg->what->exprs as $e) {
if ($e->alias == '') {
print "You should specify an alias for each column.";
exit;
}
$this->txts[$e->alias] = new dom_statictext();
$this->htxts[$e->alias] = new dom_statictext($e->alias);
$td = new dom_td();
unset($td->id);
$div = new dom_div();
unset($div->id);
$div->append_child($this->txts[$e->alias]);
$td->append_child($div);
$this->row->append_child($td);
$td = new dom_td();
unset($td->id);
$div = new dom_div();
unset($div->id);
$div->append_child($this->htxts[$e->alias]);
$td->append_child($div);
$this->hrow->append_child($td);
}
unset($this->row->id);
unset($this->table->id);
$this->append_child($this->table);
$this->table->append_child($this->hrow);
$this->table->append_child($this->row);
$this->row_height = 16.0;
$this->page_height = 270.0;
}
function html()
{
unset($this->image_1->css_style['display']);
unset($this->image_0->css_style['display']);
if ($this->args[$this->context[$this->long_name]['var']] == 1) {
$this->image_1->css_style['display'] = 'none';
} else {
$this->image_0->css_style['display'] = 'none';
}
parent::html();
}
function html_inner()
{
unset($this->custom_id);
$curr = $this->curr;
$path = $this->path;
$long_name = $this->long_name;
$htmlid = $this->context[$long_name]['htmlid'];
$limit_add_sub = "var ed=\$i('" . $this->editors['limit_skip']->ed->id_gen() . "');" . "var add=\$i('" . $this->editors['limit_count']->ed->id_gen() . "');" . "var a=ed.value*1;" . "var b=add.value*1;" . "ed.focus();";
$this->editors['limit_skip']->add_btn->attributes['onclick'] = $limit_add_sub . "ed.value=a+b;";
$this->editors['limit_skip']->sub_btn->attributes['onclick'] = $limit_add_sub . "var c=a-b;if(c<0)ed.value=0; else ed.value=c;";
$this->editors['tabs']->tabs['result']->selector->attributes['onclick'] = $this->editors['result_button']->attributes['onclick'];
parent::html_inner();
}
function __construct()
{
dom_any::__construct('div');
$this->etype = 'locationbar';
$this->css_style['width'] = '97%';
$this->css_style['margins'] = 'auto';
$this->css_style['background'] = '#a0a5b0';
$this->css_style['border'] = '2px solid #504560';
$logout_div = new dom_div();
$logout_div->css_style['float'] = 'right';
//$logout_btn=new editor_button;
//editor_generic::addeditor('logout',$logout_btn);
$this->logout_btn = new dom_textbutton();
$logout_div->append_child($this->logout_btn);
$this->append_child($logout_div);
$this->logout_btn->attributes['value'] = 'logout';
if ($_SESSION['uid'] == 0) {
$design_div = new dom_div();
$design_div->css_style['float'] = 'right';
$design_sw = new editor_checkbox();
editor_generic::addeditor('design', $design_sw);
$design_div->append_child($design_sw);
$this->append_child($design_div);
$st = new dom_statictext();
$st->text = 'DM';
$design_div->append_child($st);
}
$this->pinbtn = $pinbtn = new dom_textbutton();
$pinbtn->attributes['value'] = '⇕';
$pinbtn->css_style['float'] = 'left';
$this->append_child($pinbtn);
$pk = new path_view_control();
editor_generic::addeditor('pk', $pk);
$this->append_child($pk);
}
function html_inner()
{
global $sql;
reset($sql->querylog);
foreach ($sql->querylog as $q) {
$this->t1->text = $q->q;
$this->t2->text = $q->e;
$this->id_alloc();
dom_any::html_inner();
}
}
function __construct()
{
parent::__construct();
$this->etype = get_class($this);
editor_generic::addeditor('id_doc', new editor_text());
editor_generic::addeditor('clear', new editor_button());
$this->editors['clear']->attributes['value'] = 'Clear';
editor_generic::addeditor('list', new barcode_fill_test_list());
editor_generic::addeditor('codes', new editor_textarea());
$this->append_child($this->editors['id_doc']);
$this->append_child($this->editors['clear']);
$link = new dom_any('a');
$link->append_child(new dom_statictext(' with groups '));
$this->append_child($link);
$this->get_all = $link;
$link = new dom_any('a');
$link->append_child(new dom_statictext(' combined '));
$this->append_child($link);
$this->get_combined = $link;
$link = new dom_any('a');
$link->append_child(new dom_statictext(' special '));
$this->append_child($link);
$this->get_special = $link;
$link = new dom_any('a');
$link->append_child(new dom_statictext(' place_zone '));
$this->append_child($link);
$this->get_place_zone = $link;
$this->tbl = new dom_table();
$tr = new dom_tr();
$left = new dom_td();
$right = new dom_td();
$right->css_style['vertical-align'] = 'top';
$this->append_child($this->tbl->append_child($tr->append_child($left)));
$tr->append_child($right);
$left->append_child($this->editors['list']);
$this->rs = new container_resize();
$right->append_child($this->rs);
$this->rs->append_child($this->editors['codes']);
$this->editors['codes']->main->css_style['width'] = '100%';
$this->editors['codes']->main->css_style['height'] = '100%';
$this->editors['codes']->main->css_style['margin-top'] = '-3px';
$this->editors['codes']->main->css_style['margin-left'] = '-3px';
}
function __construct()
{
parent::__construct('style');
$this->attributes['type'] = 'text/css';
}
function __construct()
{
parent::__construct('div');
$this->divtxt = new dom_div();
$this->append_child($this->divtxt);
$this->qtxt = new dom_statictext();
$this->divtxt->append_child($this->qtxt);
$this->tbl = new dom_table();
$this->append_child($this->tbl);
$this->row = new dom_tr();
unset($this->row->id);
$this->tbl->append_child($this->row);
$this->col = new dom_td();
unset($this->col->id);
$this->row->append_child($this->col);
$this->tbl->css_class = 'res_table_test';
$this->txt = new dom_statictext();
$this->col->append_child($this->txt);
}
function __construct()
{
dom_any::__construct('a');
$this->etype = 'progress_cell_viewer_dep';
$this->node_name = 'a';
$this->text = new dom_statictext();
$this->append_child($this->text);
}
function add_link($n, $to = NULL)
{
$button = new dom_any('a');
$button->css_style['border'] = '1px solid black';
$button->css_style['margin-left'] = '1px';
$button->css_style['margin-right'] = '1px';
if (isset($to)) {
$button->attributes['href'] = $to;
}
if (isset($to)) {
$button->attributes['target'] = $to;
}
$txt = new dom_statictext();
$txt->text = " " . $n . " ";
$button->append_child($txt);
$this->global_actions->append_child($button);
}
function html_inner()
{
global $sql;
unset($db);
if ($this->args['ed_db'] != '') {
$db = $this->args['ed_db'];
}
$qg = new query_gen_ext('SELECT');
$qg->from->exprs[] = new sql_column($db, $this->args['ed_table'], NULL, 't');
$qg->what->exprs[] = new sql_list('count', array(new sql_immed(1)));
$q = $qg->result();
if (isset($q)) {
$res = $sql->query($q);
if ($res) {
$this->txt->text = $sql->fetch1($res);
} else {
$this->txt->text = $sql->err();
}
} else {
$this->txt->text = "error";
}
parent::html_inner();
}
function __construct()
{
dom_any::__construct('div');
$this->etype = 'editor_pick_button_static';
$this->button = new editor_button();
$this->button->value = 'editor_pick_button';
$this->resdiv = new dom_div();
$this->resdiv->css_style['display'] = 'none';
$this->resdiv->css_style['position'] = 'absolute';
$this->resdiv->css_style['border'] = '1px solid gray';
$this->resdiv->css_style['background'] = '#DDDDDD';
$this->append_child($this->button);
$this->append_child($this->resdiv);
$this->list = new editor_pick_button_static_list();
editor_generic::addeditor('button', $this->button);
$this->main = $this->button;
$this->resdiv->append_child($this->list);
$this->context = array();
}
function html_inner()
{
global $sql;
if (!is_array($this->rootnode->externals)) {
$this->rootnode->externals = array();
}
if (get_class($this->qu) != 'query_gen_ext') {
return;
}
$this->qu->externals =& $this->rootnode->externals;
$q = $this->qu->result();
$res = $sql->query($q);
while ($row = $sql->fetcha($res)) {
//$this->rootnode->externals=array_merge($this->rootnode->externals,$row);
foreach ($row as $k => $v) {
$this->rootnode->externals[$k] = $v;
}
dom_any::html_inner();
}
$sql->free($res);
}
function __construct()
{
dom_any::__construct('div');
$this->etype = 'query_result_viewer_any';
$this->sdiv = new dom_div();
$this->append_child($this->sdiv);
$autotbl = new container_autotable();
$this->sdiv->append_child($autotbl);
editor_generic::addeditor('ed_db', new editor_text_autosuggest_query());
$autotbl->append_child($this->editors['ed_db']);
#$this->sdiv->append_child(new dom_any_noterm('br'));
editor_generic::addeditor('ed_table', new editor_text_autosuggest_query());
$autotbl->append_child($this->editors['ed_table']);
$this->link_save_xml = new dom_any('a');
$autotbl->append_child($this->link_save_xml);
$txt = new dom_statictext('xml');
$this->link_save_xml->append_child($txt);
$this->link_save_csv = new dom_any('a');
$autotbl->append_child($this->link_save_csv);
$txt = new dom_statictext('csv');
$this->link_save_csv->append_child($txt);
editor_generic::addeditor('ed_filters', new editor_filters_ch());
$this->sdiv->append_child($this->editors['ed_filters']);
editor_generic::addeditor('ed_order', new editor_order_ch());
$this->sdiv->append_child($this->editors['ed_order']);
$tbl = new dom_any('table');
$this->sdiv->append_child($tbl);
$tr = new dom_any('tr');
$tbl->append_child($tr);
$td = new dom_any('td');
$tr->append_child($td);
$this->ed_zero = new dom_any_noterm('input');
$this->ed_zero->attributes['type'] = 'button';
$this->ed_zero->attributes['value'] = '«';
$this->ed_zero->attributes['title'] = 'В начало';
$td->append_child($this->ed_zero);
$td = new dom_any('td');
$tr->append_child($td);
$this->ed_less = new dom_any_noterm('input');
$this->ed_less->attributes['type'] = 'button';
$this->ed_less->attributes['value'] = '<';
$this->ed_less->attributes['title'] = 'На страницу назад.';
$td->append_child($this->ed_less);
$td = new dom_any('td');
$tr->append_child($td);
editor_generic::addeditor('ed_count', new editor_text());
$td->append_child($this->editors['ed_count']);
$this->editors['ed_count']->ed->css_style['width'] = '4em';
$this->editors['ed_count']->attributes['title'] = 'Количество строк.';
$td = new dom_any('td');
$tr->append_child($td);
editor_generic::addeditor('ed_offset', new editor_text());
$td->append_child($this->editors['ed_offset']);
$this->editors['ed_offset']->ed->css_style['width'] = '4em';
$this->editors['ed_offset']->attributes['title'] = 'Пропустить строк.';
$td = new dom_any('td');
$tr->append_child($td);
$this->ed_more = new dom_any_noterm('input');
$this->ed_more->attributes['type'] = 'button';
$this->ed_more->attributes['value'] = '>';
$this->ed_more->attributes['title'] = 'На страницу вперед.';
$td->append_child($this->ed_more);
$td = new dom_any('td');
$tr->append_child($td);
editor_generic::addeditor('ed_rowcount', new query_result_viewer_single());
$td->append_child($this->editors['ed_rowcount']);
$this->rdiv = new dom_div();
$this->append_child($this->rdiv);
editor_generic::addeditor('qw', new query_result_viewer_codes());
$this->rdiv->append_child($this->editors['qw']);
editor_generic::addeditor('an', new editor_insert_ch());
$this->append_child($this->editors['an']);
$this->settings->ed_count = 10;
$this->settings->ed_offset = 0;
$this->settings->ed_table = 'barcodes_raw';
$this->settings->ed_db = '';
$this->settings->order = serialize(array());
$this->settings->filters_where = serialize(array());
$this->settings->insert_args = serialize(array());
//print(isset($this->settings->ed_table));
$this->settings_io = new QRVA_settings_io();
$this->struct_io = new qrva_guess_struct();
}
