Open-ILS/src/reporter/templates/stage2.ttk

   1 [%
   2
   3 PROCESS inputs;
   4 PROCESS class_manip;
   5 PROCESS widget_manip;
   6 PROCESS logic_header.ttk;
   7 INCLUDE logout.ttk;
   8
   9 templates = DBI.tie('reporter.stage2', 'id')
  10 tmpl = {};
  11
  12
  13 IF CGI.param('id');
  14         tid = CGI.param('id');
  15         tmpl = templates.$tid;
  16 END;
  17
  18
  19 WRAPPER html/html;
  20    INCLUDE header.ttk + navbar.ttk title="Report Templates";
  21    WRAPPER html/body;
  22       IF CGI.param('action') == 'save';
  23          PROCESS save_stage2;
  24       ELSIF CGI.param('action') == 'edit';
  25          PROCESS edit_stage2;
  26       ELSIF CGI.param('action') == 'run';
  27          PROCESS run_stage2;
  28                 ELSE;
  29          PROCESS view_stage2;
  30       END;
  31    END;
  32    INCLUDE footer.ttk;
  33 END;
  34
  35
  36
  37
  38 BLOCK save_stage2;
  39         stage1 = CGI.param('stage1');
  40         pub = CGI.param('publictemplate') OR 'f';
  41         owner = user.id();
  42
  43         p_obj = {};
  44         FOR p IN CGI.param();
  45
  46                 logme([p,CGI.param(p)]);
  47
  48                 parts = p.split(':');
  49                 p1 = parts.0;
  50                 p2 = parts.1;
  51                 p3 = parts.2;
  52                 p4 = parts.3;
  53
  54                 IF p4
  55                         AND (CGI.param("$p1:$p2:$p3") == p4)
  56                         AND (CGI.param("$p1:$p2").list.grep(p3).size > 0)
  57                         AND (CGI.param("$p1").list.grep(p2).size > 0);
  58
  59                         p_obj.$p1.$p2.$p3.$p4 = CGI.param(p);
  60
  61                 ELSIF p2
  62                         AND (CGI.param("$p1").list.grep(p2).size > 0);
  63                         p_obj.dims.$p2 = 1;
  64                 ELSIF p1 != 'filter';
  65                         p_obj.$p1 = CGI.param(p);
  66                 END;
  67
  68         END;
  69
  70         params = utils.perl2JSON( p_obj );
  71
  72         logme([stage1, params, owner, pub]);
  73
  74         q = DBI.prepare( stage2_insert );
  75         CALL q.execute(stage1, params, owner, pub);
  76
  77         FOR new_s2 = DBI.query("SELECT * FROM reporter.stage2_id_seq;");
  78                 tid = new_s2.last_value;
  79                 INCLUDE view_stage2 tmpl = templates.$tid;
  80         END;
  81 END;
  82
  83
  84
  85
  86 BLOCK edit_stage2;
  87
  88 END;
  89
  90
  91
  92
  93
  94 BLOCK view_stage2;
  95         logme(tmpl.params);
  96         params = utils.JSON2perl( tmpl.params );
  97
  98         WRAPPER html/table border=0 width='100%';
  99                 WRAPPER html/row;
 100                         WRAPPER html/cell colspan=5 align='center';
 101                                 s1_name_xpath = '/reporter/tables/table[@id="' _ params.stage1 _ '"]/label';
 102                                 INCLUDE anchor
 103                                         content=config.findvalue( s1_name_xpath )
 104                                         href="stage1?id=" _ params.stage1;
 105                                 ' :: ' _ params.templatename _ '<br>';
 106                                 INCLUDE anchor
 107                                         content="Create a report from this template"
 108                                         href=CGI.url('-path', 1) _ '?action=run&id=' _ tmpl.id;
 109                         END;
 110                 END;
 111
 112                 WRAPPER html/row;
 113                         INCLUDE html/cell colspan=4 content="<b>Filterable Attributes:</b>";
 114                 END;
 115
 116                 FOR f_table IN params.filter.keys;
 117                         logme([f_table]);
 118                         table = config.findnodes( "/reporter/tables/table[@id='$f_table']");
 119                         WRAPPER html/row;
 120                                 INCLUDE html/cell;
 121                                 INCLUDE html/cell colspan=4 align='left' content=table.findvalue( 'label' );
 122                         END;
 123
 124                         FOR f_field IN params.filter.$f_table.keys;
 125                                 logme([f_table,f_field]);
 126                                 FOR f_fam IN params.filter.$f_table.$f_field.keys;
 127                                         logme([f_table,f_field,f_fam]);
 128                                         f_widget = params.filter.$f_table.$f_field.$f_fam;
 129                                         logme([f_table,f_field,f_fam,f_widget]);
 130
 131                                         WRAPPER html/row;
 132                                                 field = table.findnodes( "fields/field[@name='$f_field']" );
 133                                                 fam = config.findnodes( "/reporter/widgets/widget-family[@name='$f_fam']" );
 134                                                 widget = fam.findnodes( "widget[@name='$f_widget']" );
 135
 136                                                 INCLUDE html/cell colspan=2;
 137                                                 INCLUDE html/cell align='right' content=field.findvalue( 'label' );
 138                                                 INCLUDE html/cell align='center' content=fam.findvalue( 'label' );
 139                                                 INCLUDE html/cell align='left' content=widget.findvalue( 'label' );
 140                                         END;
 141                                 END;
 142                         END;
 143                 END;
 144
 145                 WRAPPER html/row;
 146                         INCLUDE html/cell colspan=5 content="<br>";
 147                 END;
 148
 149                 WRAPPER html/row;
 150                         INCLUDE html/cell colspan=5 content="<b>Attributes Available for Output</b>";
 151                 END;
 152
 153                 FOR f_table IN params.dims.keys;
 154                         table = config.findnodes( "/reporter/tables/table[@id='$f_table']");
 155                         tname = table.findvalue( "label" );
 156                         tdesc = table.findvalue( "desription" );
 157
 158                         NEXT IF table.findvalue('@fact-table') == 'true';
 159
 160                         WRAPPER html/row;
 161                                 INCLUDE html/cell;
 162                                 INCLUDE html/cell colspan=4 align='left' content=tname;
 163                         END;
 164
 165
 166                         FOR field IN table.findnodes('fields/field[not(@primary) or @primary != "true"]');
 167                                 fname = field.findvalue( "label" );
 168                                 fdesc = field.findvalue( "desription" );
 169
 170                                 WRAPPER html/row;
 171
 172                                         INCLUDE html/cell colspan=2;
 173                                         INCLUDE html/cell align='right' content=fname;
 174                                         INCLUDE html/cell colspan=2 align='center' content=fdesc;
 175                                 END;
 176                         END;
 177                 END;
 178
 179         END;
 180 END;
 181
 182
 183
 184
 185
 186 BLOCK run_stage2;
 187         logme(tmpl.params);
 188         params = utils.JSON2perl( tmpl.params );
 189
 190    '<br/>';
 191         WRAPPER form id="stage3_new" name="stage3_new" action="stage3" method="POST";
 192                 INCLUDE hidden name='stage2' value=CGI.param('id');
 193
 194                 '<br>Name:';
 195                 INCLUDE text name='reportname';
 196
 197                 WRAPPER html/table border=0 width='100%';
 198                         WRAPPER html/row;
 199                                 WRAPPER html/cell colspan=4 align='center';
 200                                         s1_name_xpath = '/reporter/tables/table[@id="' _ params.stage1 _ '"]/label';
 201                                         INCLUDE anchor
 202                                                 content=config.findvalue( s1_name_xpath )
 203                                                 href="stage1?id=" _ params.stage1;
 204                                         ' :: ' _ params.templatename;
 205                                 END;
 206                         END;
 207
 208                         WRAPPER html/row;
 209                                 INCLUDE html/cell colspan=4 content="<b>Filterable Attributes:</b>";
 210                         END;
 211
 212                         FOR f_table IN params.filter.keys;
 213                                 logme([f_table]);
 214                                 table = config.findnodes( "/reporter/tables/table[@id='$f_table']");
 215                                 WRAPPER html/row;
 216                                         INCLUDE html/cell colspan=3 align='left' content=table.findvalue( 'label' );
 217                                 END;
 218
 219                                 FOR f_field IN params.filter.$f_table.keys;
 220                                         logme([f_table,f_field]);
 221                                         FOR f_fam IN params.filter.$f_table.$f_field.keys;
 222                                                 logme([f_table,f_field,f_fam]);
 223                                                 f_widget = params.filter.$f_table.$f_field.$f_fam;
 224                                                 logme([f_table,f_field,f_fam,f_widget]);
 225
 226                                                 WRAPPER html/row;
 227                                                         field = table.findnodes( "fields/field[@name='$f_field']" );
 228                                                         fam = config.findnodes( "/reporter/widgets/widget-family[@name='$f_fam']" );
 229                                                         widget = fam.findnodes( "widget[@name='$f_widget']" );
 230
 231                                                         w_file = 'widgets/' _ fam.findvalue('@name') _ '.' _ widget.findvalue('@name');
 232                                                         INCLUDE html/cell;
 233                                                         INCLUDE html/cell align='right' content=field.findvalue( 'label' );
 234
 235                                                         WRAPPER html/cell align='center';
 236                                                                 TRY;
 237                                                                                 classname = table.findvalue('@id');
 238                                                                                 fieldname = field.findvalue('@name');
 239                                                                                 widgetname = widget.findvalue('@name');
 240                                                                                 famname = fam.findvalue('@name');
 241
 242                                                                                 input_prefix = "filter:$classname:$fieldname:$famname:$widgetname";
 243
 244                                                                                 INCLUDE $w_file widget_family=fam;
 245                                                                 CATCH;
 246                                                                         %]ARG!! Couldn't render widget [% $w_file %] ([% error.info %])!!![%
 247                                                                 END;
 248                                                         END;
 249                                                 END;
 250                                         END;
 251                                 END;
 252                         END;
 253
 254                         WRAPPER html/row;
 255                                 INCLUDE html/cell colspan=4 content="<br>";
 256                         END;
 257
 258                         WRAPPER html/row;
 259                                 INCLUDE html/cell colspan=4 content="<b>Attributes Available for Output</b>";
 260                         END;
 261
 262                         FOR f_table IN params.dims.keys;
 263                                 table = config.findnodes( "/reporter/tables/table[@id='$f_table']");
 264                                 classname = table.findvalue( "@id" );
 265                                 tname = table.findvalue( "label" );
 266                                 tdesc = table.findvalue( "desription" );
 267
 268                                 WRAPPER html/row;
 269                                         INCLUDE html/cell colspan=4 align='left' content=tname;
 270                                 END;
 271
 272
 273                                 fields_xpath =
 274                                         'fields/field[not(@primary) or @primary != "true"]';
 275                                 FOR field IN table.findnodes(fields_xpath);
 276                                         link_test = '../../links/link[@field="' _ field.findvalue('@name') _ '"]';
 277                                         logme(['link_test',link_test]);
 278                                         NEXT IF field.findnodes( link_test );
 279
 280                                         fname = field.findvalue( "label" );
 281                                         fid = field.findvalue( "@name" );
 282
 283                                         WRAPPER html/row;
 284
 285                                                 WRAPPER html/cell align='right';
 286                                                         INCLUDE checkbox name="output:$classname:$fid" value="include";
 287                                                 END;
 288                                                 INCLUDE html/cell align='right' content=fname;
 289                                                 WRAPPER html/cell align='center';
 290                                                         'Output Transformation: ';
 291                                                         dtype = field.findvalue('@datatype');
 292                                                         WRAPPER select name="xform:type:$classname:$fid";
 293                                                                 INCLUDE option value='' content='None' selected=1;
 294                                                                 FOR xform IN dtype_xform_map.$dtype;
 295                                                                         xform_label = dtype_xforms.$xform.label;
 296                                                                         IF dtype_xforms.$xform.param;
 297                                                                                 xform_label = "$xform_label (*)";
 298                                                                         END;
 299                                                                         INCLUDE option value=xform content=xform_label;
 300                                                                 END;
 301                                                         END;
 302                                                         '<br/>';
 303                                                         '<small><super>*</super>Output Tranformation Parameter: </small>';
 304                                                         INCLUDE text name="xform:param:$classname:$fid";
 305                                                 END;
 306                                         END;
 307                                 END;
 308                         END;
 309                 END;
 310
 311                 INCLUDE checkbox name="publicreport" value="t";
 312                 'Public Report<br>';
 313                 INCLUDE submit name="action" value="Run Now";
 314                 INCLUDE submit name="action" value="Schedule";
 315
 316         END;
 317 END;
 318
 319 %]