function _renderForm(&$page) { $pageName = $page->getAttribute('name'); $tabPreview = array_slice($page->controller->_tabs, -2, 1); // can use either HTML_Template_Sigma or HTML_Template_ITX $tpl = new HTML_Template_ITX('./templates'); // $tpl = new HTML_Template_Sigma('./templates'); $tpl->loadTemplateFile('itdynamic.html'); // on preview tab, add progress bar javascript and stylesheet if ($pageName == $tabPreview[0][0]) { $bar = $page->controller->createProgressBar(); $tpl->setVariable(array('qf_style' => $bar->getStyle(), 'qf_script' => $bar->getScript())); $barElement = $page->getElement('progressBar'); $barElement->setText($bar->toHtml()); } $renderer = new HTML_QuickForm_Renderer_ITDynamic($tpl); $renderer->setElementBlock(array('buttons' => 'qf_buttons')); $page->accept($renderer); $tpl->show(); }
public static function carregarInterface($interface) { $base = APP . "view"; if (strpos($interface, "_")) { $componente = substr($interface, 9, strpos($interface, "_") - 9); if (!file_exists("{$base}/{$interface}")) { $base = "Componentes/{$componente}/view"; } } else { if ($interface) { $componente = substr($interface, 9, strlen($interface) - 9 - 5); if ($componente) { $base = "Componentes/{$componente}/view"; } } } if (!file_exists("{$base}/{$interface}")) { $base = APP . "view"; } $view = new HTML_Template_ITX($base); $view->loadTemplateFile($interface); return $view; }
WEBPAGE::$lang = $_GET['lang']; } else { WEBPAGE::$lang = 'esp'; } $_LABELS = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_LABELS_FILE, WEBPAGE::$lang)); $_CONF = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_CONF_FILE, WEBPAGE::$lang)); $data = WEBPAGE::$dbh->getAll(sprintf("select\r\n lmd.master_id,\r\n l.xp_cancel_date,\r\n l.xp_num_pmt,\r\n lt.payment_frequency,\r\n lcd.xp_pmt_date,\r\n lcd.loan_id,\r\n lcd.xp_pmt,\r\n lcd.cn_delay,\r\n lcd.cn_penalties,\r\n lm.program_id, prg.program,\r\n lm.zone_id, z.short_name,\r\n concat(c.first,' ',c.last) cliente,\r\n c.code govID,\r\n s.name grupo,\r\n u.username,\r\n count(p.id)+1 cuota,\r\n fa.p_pmt_receipt_flag_a pmt_receipt_flag_a,\r\n fb.p_pmt_receipt_flag_b pmt_receipt_flag_b\r\nfrom\r\n (\r\n tblLoansCurrentData lcd,\r\n tblLoansMasterDetails lmd,\r\n tblLoansMaster lm,\r\n tblLoans l,\r\n tblLoanTypes lt,\r\n tblClients c,\r\n tblPrograms prg,\r\n tblZones z,\r\n tblUsers u\r\n )\r\nleft join\r\n tblSocieties s on s.id = c.society_id\r\nleft join\r\n tblPayments p on p.loan_id = lcd.loan_id and p.special = 0\r\nleft join\r\n (select fap.loan_id p_loan_id, count(far.flag_a) p_pmt_receipt_flag_a FROM tblPayments fap, tblReceipts far, tblLinkReceiptsPayments falrp, tblLoansCurrentData falcd where falcd.loan_id = fap.loan_id and falcd.xp_pmt_date <= date_add(now(), interval 7 day) and far.flag_a = '1' and falrp.payment_id = fap.id and falrp.receipt_id = far.id group by fap.loan_id) fa on fa.p_loan_id = lcd.loan_id\r\nleft join\r\n (select fbp.loan_id p_loan_id, count(fbr.flag_b) p_pmt_receipt_flag_b FROM tblPayments fbp, tblReceipts fbr, tblLinkReceiptsPayments fblrp, tblLoansCurrentData fblcd where fblcd.loan_id = fbp.loan_id and fblcd.xp_pmt_date <= date_add(now(), interval 7 day) and fbr.flag_b = '1' and fblrp.payment_id = fbp.id and fblrp.receipt_id = fbr.id group by fbp.loan_id) fb on fb.p_loan_id = lcd.loan_id\r\nwhere\r\n lcd.xp_pmt_date <= date_add(now(), interval 1 month)\r\n and lmd.loan_id = lcd.loan_id\r\n and lm.id = lmd.master_id\r\n and l.id = lcd.loan_id\r\n and lt.id = l.loan_type_id\r\n and c.id = l.client_id\r\n and prg.id = lm.program_id\r\n and z.id = lm.zone_id\r\n and u.id = l.advisor_id\r\ngroup by\r\n lcd.loan_id\r\norder by\r\n lcd.loan_id")); $head = array('id' => 'ID', 'client' => 'Cliente', 'num_pmt' => 'No cuota', 'xp_num_pmt' => 'Total de cuotas', 'payment_frequency' => 'Frec. Pagos', 'xp_pmt_date' => 'Fecha pago', 'xp_cancel_date' => 'Fecha vencimiento', 'xp_pmt' => 'Monto cuota', 'cn_penalties' => 'Punitorios', 'pmt_receipt_flag_a' => $_CONF['pmt_receipt_flag_a'] ? $_CONF['pmt_receipt_flag_a'] : '-', 'pmt_receipt_flag_b' => $_CONF['pmt_receipt_flag_b'] ? $_CONF['pmt_receipt_flag_b'] : '-', 'username' => 'Asesor', 'program' => 'Programa', 'branch' => 'Sucursal', 'print' => 'Imprimir'); foreach ($data as $key => $val) { $master[$val['master_id']]['id'] = $val['master_id']; $master[$val['master_id']]['client'] = $counter[$val['master_id']] ? $val['grupo'] : $val['cliente'] . ' : ' . $val['govID']; // $master[$val['master_id']]['client'] = $val['grupo'] ? $val['grupo'] : $val['cliente']; $master[$val['master_id']]['num_pmt'] = $val['cuota']; $master[$val['master_id']]['xp_num_pmt'] = $val['xp_num_pmt']; $master[$val['master_id']]['payment_frequency'] = $val['payment_frequency']; $master[$val['master_id']]['xp_pmt_date'] = $val['xp_pmt_date']; $master[$val['master_id']]['xp_cancel_date'] = $val['xp_cancel_date']; $master[$val['master_id']]['xp_pmt'] += $val['xp_pmt']; $master[$val['master_id']]['cn_penalties'] += $val['cn_penalties']; $master[$val['master_id']]['pmt_receipt_flag_a'] = $_CONF['pmt_receipt_flag_a'] ? $val['pmt_receipt_flag_a'] ? $val['pmt_receipt_flag_a'] : 0 : '-'; $master[$val['master_id']]['pmt_receipt_flag_b'] = $_CONF['pmt_receipt_flag_b'] ? $val['pmt_receipt_flag_b'] ? $val['pmt_receipt_flag_b'] : 0 : '-'; $master[$val['master_id']]['username'] = $val['username']; $master[$val['master_id']]['program'] = $val['program']; $master[$val['master_id']]['branch'] = $val['short_name']; $master[$val['master_id']]['print'] = sprintf('<a href="index.receipt.php?advisor=%s&client=%s&xp_pmt_date=%s&num_pmt=%s&xp_num_pmt=%s&xp_pmt=%s">Imprimir</a>', $master[$val['master_id']]['username'], $master[$val['master_id']]['client'], $master[$val['master_id']]['xp_pmt_date'], $master[$val['master_id']]['num_pmt'], $master[$val['master_id']]['xp_num_pmt'], $master[$val['master_id']]['xp_pmt']); $counter[$val['master_id']]++; } $tpl = new HTML_Template_ITX('.'); $tpl->loadTemplateFile('index.compactCS.tpl'); $tpl->setVariable('chart', count($master) ? WEBPAGE::printchart($master, $head) : $_LABELS['noData']); $tpl->show();
static function printchart_ii($mdata, $head, $totals, $styles, $flags) { /* example for each param $mdata = array($data_0,$data_1); with: $data_0[row_0][col_0]='val_0_00'; $data_0[row_0][col_1]='val_0_01'; $data_1[row_0][col_0]='val_1_00'; $data_1[row_0][col_1]='val_1_01'; $head = array('col_0'=>'col_0_name', 'col_1'=>'col_1_name'); $totals = array('totals'=>true,'subtotals'=>true,'cols'=>array('col_1')); // only calculate totals for 'col_1'; // also show subtotals for each data set // and grand total row $styles = array( 'header' => array('cell'=>'header_cell_class','row'=>''), 'subtotals' => array('cell'=>'subtotals_cell_class','row'=>'subtotals_row_class'), 'totals' => array('cell'=>'totals_cell_class','row'=>'totals_row_class'), 'data_0' => array('cell'=>'data_0_cells_class','row'=>'data_0_row_class'), 'data_1' => array('cell'=>'data_1_cells_class','row'=>'data_1_row_class')); $flags = array('cache','legend'); $flags['cache'] = true; // Save results in hd cache - makes for excel download. $flags['legend'] = true; // Prints legend. */ global $_LABELS; if (!is_array($mdata)) { return $_LABELS['noData']; } foreach ($mdata as $inx => $data) { if (!count($data)) { unset($mdata[$inx]); } } if (!count($mdata)) { return $_LABELS['noData']; } //if style info is empty, then create default styles if (!count($styles)) { $styles['header']['cell'] = 'header'; $styles['header']['row'] = ''; $styles['subtotals']['cell'] = 'subtotals'; $styles['subtotals']['row'] = 'subtotalsOff'; $styles['totals']['cell'] = 'totals'; $styles['totals']['row'] = 'totalsOff'; foreach ($mdata as $inx => $data) { if (count($data)) { $row_style = $row_style == 'rowOff_ii' ? 'rowOff_ii_alt' : 'rowOff_ii'; $styles[$inx]['cell'] = 'activeChart'; $styles[$inx]['row'] = $row_style; } } } // to make sure we create a cache file to open in excel upon request $c = 0; foreach ($mdata as $inx => $data) { foreach ($data as $k => $v) { $cdata[$c] = $v; $c++; if (is_array($totals['cols'])) { foreach ($v as $col => $val) { if (in_array($col, $totals['cols'])) { $subtotals[$inx][$col] += $val; $ctotals[$col] += $val; } else { $subtotals[$inx][$col] = '-'; $ctotals[$col] = '-'; } } } } } if (is_array($ctotals)) { $cdata[$c] = $ctotals; } array_unshift($cdata, $head); $flags['cache'] ? self::makecachefile($cdata, self::$queryCache) : ''; array_shift($cdata); //print html chart $tpl = new HTML_Template_ITX('./templates'); $tpl->loadTemplateFile('ST.chart_ii.tpl'); //print header row $tpl->setCurrentBlock("header"); $tpl->setVariable('column_name', '#'); $tpl->setVariable('header_class', $styles['header']['cell']); $tpl->parseCurrentBlock("header"); foreach ($head as $key => $val) { $tpl->setCurrentBlock("header"); $tpl->setVariable('column_name', $val); $tpl->setVariable('header_class', $styles['header']['cell']); $tpl->parseCurrentBlock("header"); } //print each data set, row by row //including subtotal for each set $c = 1; foreach ($mdata as $inx => $data) { $row_style = $styles[$inx]['row']; //print regular rows foreach ($data as $key => $row) { $tpl->setCurrentBlock("row"); $tpl->setVariable('cell_class', $styles[$inx]['cell']); $tpl->setVariable('item', sprintf('%s. ', $c++)); $tpl->parseCurrentBlock("row"); foreach ($row as $col => $val) { $tpl->setCurrentBlock("row"); $tpl->setVariable('cell_class', $styles[$inx]['cell']); $tpl->setVariable('item', $val); $tpl->parseCurrentBlock("row"); } $tpl->setCurrentBlock("results"); $tpl->setVariable('row_class', $row_style); $tpl->parseCurrentBlock("results"); } //print subtotals if ($totals['subtotals'] && is_array($subtotals[$inx])) { $tpl->setCurrentBlock("row"); $tpl->setVariable('cell_class', $styles['subtotals']['cell']); $tpl->setVariable('item', $_LABELS['subtotal']); $tpl->parseCurrentBlock("row"); foreach ($subtotals[$inx] as $col => $val) { $tpl->setCurrentBlock("row"); $tpl->setVariable('cell_class', $styles['subtotals']['cell']); $tpl->setVariable('item', is_numeric($val) ? round($val, 2) : $val); $tpl->parseCurrentBlock("row"); } $tpl->setCurrentBlock("results"); $tpl->setVariable('row_class', $styles['subtotals']['row']); $tpl->parseCurrentBlock("results"); } } //print totals row if ($totals['totals'] && is_array($totals['cols'])) { $tpl->setCurrentBlock("row"); $tpl->setVariable('cell_class', $styles['totals']['cell']); $tpl->setVariable('item', $_LABELS['total']); $tpl->parseCurrentBlock("row"); foreach ($ctotals as $col => $val) { $tpl->setCurrentBlock("row"); $tpl->setVariable('cell_class', $styles['totals']['cell']); $tpl->setVariable('item', is_numeric($val) ? round($val, 2) : $val); $tpl->parseCurrentBlock("row"); } $tpl->setCurrentBlock("results"); $tpl->setVariable('row_class', $styles['totals']['row']); $tpl->parseCurrentBlock("results"); } //print legend if ($flags['legend']) { foreach ($mdata as $inx => $val) { if ($styles[$inx]['row']) { $tpl->setCurrentBlock("legend"); $tpl->setVariable('style', $styles[$inx]['row']); $tpl->setVariable('legend_text', $_LABELS[$inx] ? $_LABELS[$inx] : $inx); $tpl->parseCurrentBlock("legend"); } } } //finalize and print excel link $tpl->setCurrentBlock("chart"); $cache ? $tpl->setVariable('xls_download', $_LABELS['RP.SCR.ChartCacheToXLS']) : ''; $tpl->parseCurrentBlock("chart"); return $tpl->get(); }
{ $bar->sleep(); $str = ' '; if ($progressValue > 25) { $str = ' - DB schema generated'; } if ($progressValue > 50) { $str = ' - Config file created'; } if ($progressValue == 100) { $str = ' - All done !'; } $bar->setString(sprintf("Installation in progress ... %01s%s %s", $progressValue, '%', $str)); } $tpl = new HTML_Template_ITX('.'); $tpl->loadTemplateFile('installing.html'); $vars = array("L_SETUP_APP_TITLE" => "SW4P", "L_APPNAME" => basename(__FILE__), "L_APPCOPYRIGHT" => "© 2003 SW4P Team "); $tpl->setVariable($vars); $form = new HTML_QuickForm('form'); $form->addElement('submit', 'launch', 'Launch', 'style="width:100px;"'); $styles = array('none' => 'none', 'solid' => 'solid', 'dashed' => 'dashed', 'dotted' => 'dotted', 'inset' => 'inset', 'outset' => 'outset'); $form->addElement('select', 'border', 'border style:', $styles); $colors = array('#FFFFFF' => 'white', '#0000FF' => 'blue', '#7B7B88' => '#7B7B88'); $form->addElement('select', 'color', 'border color:', $colors); $defaultValues['border'] = 'solid'; $defaultValues['color'] = '#7B7B88'; $form->setDefaults($defaultValues); if ($form->validate()) { $arr = $form->getElementValue('border'); $border = $arr[0]; $arr = $form->getElementValue('color');