Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - brienen

1
Questions / Re: multi column list
in the case of the list view, i found a nice way to make the columns wider , simply add space html code before and after the fieldname

ColumnWidhtOrClass : empty
Display Label :    Provincia  
4
General Discussion / Re: reports export all files
hi,
in the list page properties you can change the RecordLimit (SQL Limit Count Statement) to anything , like for example to 10000 but the point is that after that having done, you will have to scroll all the way down to see the export button to click on it.

5
Suggestions / Re: be able to add charts to tab pages
hi,
i did what you asked, no problem.
you add one tab and inside that tab you add a chart.
then after you copy component of the tab with right botton of your mouse and after paste component.
so you have 2 tabs with chart inside. ofcourse after you can copy tab again to add more tabs.
6
General Discussion / Re: Know users online
Hi ,

I created a customview in Page Design :

<div style ='font:14px tahoma'>
<?php
echo get_active_user('login');
?>
</div>

It works fine but how can i see a list of all users logged in ?
7
Questions / Re: customize excel output file
I added some lines in the  XLSXWriter.php file , when you have more than one excel output file and ofcourse the columns have diferent sizes, so used the switch case, to switch depending on the $sheet_name variable.
Below the changes in the writeSheetHeader function :

   switch ($sheet_name) {

      case 'Tareas':
         $col_widths = isset($col_options['widths']) ? (array)$col_options['widths'] : array(10,20,25,25,25,11,25,25,25,11,25,9,50,10);
      break;

      case 'Ingresos':
         $col_widths = isset($col_options['widths']) ? (array)$col_options['widths'] : array(15,10,13,17,12,11,25,22,15,50);
      break;

      case 'Salidas':
         $col_widths = isset($col_options['widths']) ? (array)$col_options['widths'] : array(14,10,13,13,25,25,12,28,22,11,13,13,50);
      break;
   }
8
Questions / Re: customize excel output file
Tx Willvin,
Sorry, but I was looking for the xls output and not the csv output.
Anyway I found it where to change , in the libs dir the file XLSXWriter.php contains the settings for the xls output:

In the writeSheetHeader function

line 223:
      $col_widths = isset($col_options['widths']) ? (array)$col_options['widths'] : array();
change to an array with the different column widths :
      $col_widths = isset($col_options['widths']) ? (array)$col_options['widths'] : array(10,20,25,25,25,11,25,25,25,11,25,9,50,10);

line 225:
      $freeze_rows = isset($col_options['freeze_rows']) ? intval($col_options['freeze_rows']) : true;
change the first row to frozen : true

line 236, add one line with the style settings for the header :
            $style = array( 'font'=>'Tahoma','font-size'=>10,'font-style'=>'bold','fill'=>'#eee','halign'=>'center','border'=>'left,right,top,bottom');

The docs of this class are very well explained and supported here :

https://github.com/mk-j/PHP_XLSXWriter/blob/master/xlsxwriter.class.php

9
Questions / customize excel output file
hi,
is there a way to customize the excel output file like column size, bold header etc. ?
and where can that be done ?
tx, brienen
12
Issues / In Edit page some fields does not show up with its value
Hi,
Here an issue i found when using the Edit page , for some reason 2 fields do not show up with its value that i previous put.
Below a screen of the Edit page where you can see that field "Equipo Tecnico" and "Soporte" show up empty.
I added the project and the database in a zip-file so you can try.
In the db folder is the tareas.sql file
User is : juan / qwe123

Tx, brienen