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');
