Conheça as melhorias da versão 8.0, 8.1, 8.2!
Clique aqui para saber mais
Conheça Características Quem usa Galeria Cursos Docs Fórum
Downloads
Posts Fique por dentro Sobre o Fórum Minha conta
function show() Caros usto a função show(), pra popular a datagrid no primeiro acesso à página, a função cumpre o papel, porém quando tenho paginação na datagrid, e tento trocar de página esta função faz com que limpe a datagrid. Segue código abaixo. ##################### ...
UP
function show()  
Fechado
Udson Da Priscila 16/10/2015 (há 9 anos)
Caros usto a função show(), pra popular a datagrid no primeiro acesso à página, a função cumpre o papel, porém quando tenho paginação na datagrid, e tento trocar de página esta função faz com que limpe a datagrid. Segue código abaixo.

##################### 
 
  1. <?php
  3. /*
  4.  * To change this license header, choose License Headers in Project Properties.
  5.  * To change this template file, choose Tools | Templates
  6.  * and open the template in the editor.
  7.  */
  9. /**
  10.  * Description of QueriesList
  11.  *
  12.  * @author udson
  13.  */
  14. class QueriesList extends TPage {
  15.     
  16.     private $form; 
  17.     private $loaded;
  18.     
  19.     /**
  20.      * Class constructor
  21.      * Creates the page and the registration form
  22.      */
  23.     function __construct()
  24.     {
  25.         parent::__construct();
  26.         
  27.         if (TSession::getValue('logged') !== TRUE)
  28.         {
  29.             //throw new Exception('Sessão expirada, favor logar novamente');
  30.             TApplication::gotoPage('FormLogin', '');
  31.         }
  32.         
  33.         // creates the form
  34.         $this->form = new TForm('form_Queries_Report');
  35.         $this->form->class = 'tform';
  36.         
  37.         // creates a table
  38.         $table = new TTable;
  39.         $table-> width = '100%';
  40.         
  41.         // add the table inside the form
  42.         $this->form->add($table);
  44.         // create the form fields
  45.         $start_date = new TDate('start_date');
  46.         $start_date->setMask('yyyy-mm-dd');
  47.         $start_date->setSize(80);
  48.         
  49.         $start_time_hour = new TCombo('start_time_hour');
  50.         for ($n=0; $n<=24; $n++)
  51.         {
  52.             $itens1[$n] = str_pad($n, 2, '0', STR_PAD_LEFT);
  53.         }
  54.         $start_time_hour->addItems($itens1);
  55.         $start_time_hour->setSize(45);
  56.         $start_time_hour->setValue('');
  57.         
  58.         $start_time_min = new TCombo('start_time_min');
  59.         for ($n=0; $n<=59; $n++)
  60.         {
  61.             $itens2[$n] = str_pad($n, 2, '0', STR_PAD_LEFT);
  62.         }
  63.         $start_time_min->addItems($itens2);
  64.         $start_time_min->setSize(45);
  65.         $start_time_min->setValue('');
  66.         
  67.         $end_date   = new TDate('end_date');
  68.         $end_date->setMask('yyyy-mm-dd');
  69.         $end_date->setSize(80);
  70.         
  71.         $end_time_hour = new TCombo('end_time_hour');
  72.         for ($n=0; $n<=24; $n++)
  73.         {
  74.             $itens3[$n] = str_pad($n, 2, '0', STR_PAD_LEFT);
  75.         }
  76.         $end_time_hour->addItems($itens3);
  77.         $end_time_hour->setSize(45);
  78.         $end_time_hour->setValue('');
  79.         
  80.         $end_time_min = new TCombo('end_time_min');
  81.         for ($n=0; $n<=59; $n++)
  82.         {
  83.             $itens4[$n] = str_pad($n, 2, '0', STR_PAD_LEFT);
  84.         }
  85.         $end_time_min->addItems($itens4);
  86.         $end_time_min->setSize(45);
  87.         $end_time_min->setValue('');
  88.         
  89.         $number = new TEntry('number');
  90.         $number->setSize(120);
  91.         
  92.         $operator = new TEntry('operator');
  93.         $operator->setSize(80);
  94.         
  95.         $ip = new TEntry('ip');
  96.         $ip->setSize(120);
  97.         
  98.         $rate = new TEntry('rate');
  99.         $rate->setSize(80);
  100.         
  101.         $source = new TCombo('source');
  102.         $source_options= array("HTTP" => "HTTP","SIP" => "SIP");
  103.         $source->addItems($source_options);
  104.         $source->setSize(80);
  105.         
  106.         $customer = new TDBMultiSearch('customer', 'easyconsulta', 'Customer', 'id', 'customer');
  107.         $customer->setOperator('like');
  108.         $customer->setSize(250);
  109.         $customer->setMaxSize(1);
  110.         $customer->setMinLength(3);
  111.         
  112.         
  113.         // create an action button (save)
  114.         $search=new TButton('search');
  115.         $search->setAction(new TAction(array($this, 'onSearch')), 'Buscar');
  116.         $search->setImage('ico_find.png');
  117.         
  118.         $csv=new TButton('CSV');
  119.         $csv->setAction(new TAction(array($this, 'onExportCSV')), 'CSV');
  120.         $csv->setImage('ico_print.png');
  121.         
  122.         //$pdf=new TButton('PDF');
  123.         //$pdf->setAction(new TAction(array($this, 'onPDF')), 'PDF');
  124.         //$pdf->setImage('ico_print.png');
  125.         
  126.         // add a row for the field name
  127.         $row  = $table->addRowSet(new TLabel('Filtro'), '');
  128.         $row->class = 'tformtitle'; // CSS class
  129.         
  130.         $row = $table->addRow();
  131.         $row->addMultiCell('De: ', $start_date, '', $start_time_hour, '', $start_time_min, 'Até: ', '', $end_date, '', $end_time_hour, '', $end_time_min,'Número: ', $number,'Operadora: ', $operator);
  132.         
  133.         $row = $table->addRow();
  134.         $row->addMultiCell('Ip:  ', $ip, 'Tarifa: ', $rate, 'Origem: ', $source, /*'Cliente:', $customer,*/ $search, $csv);
  135.         
  136.         // add a row for the form action
  137.         $row = $table->addRowSet();
  138.         $row->class = 'tformaction';
  139.         $row->addMultiCell('  ');
  140.         
  141.         // define wich are the form fields
  142.         $this->form->setFields(array($start_date,$start_time_hour,$start_time_min,$end_date,$end_time_hour,$end_time_min,$number,$operator,$ip,$rate,$source,$search,/*$customer,*/$csv));
  143.         //
  144.         // creates a DataGrid
  145.         $this->datagrid = new TQuickGrid;
  146.         $this->datagrid->setHeight(400);
  147.         $this->datagrid->makeScrollable();
  148.         
  149.         $cod = $this->datagrid->addQuickColumn('Cod.', 'id', 'center', 100 , new TAction(array($this, 'onReload')), array('order', 'id'));
  150.         //$customer = $this->datagrid->addQuickColumn('Cliente', 'id_customer', 'center', 150 , new TAction(array($this, 'onReload')), array('order', 'id_customer'));
  151.         $date_time = $this->datagrid->addQuickColumn('Data / Hora', 'date_time', 'center', 150 , new TAction(array($this, 'onReload')), array('order', 'date_time'));
  152.         $number = $this->datagrid->addQuickColumn('Número', 'number', 'center', 150, new TAction(array($this, 'onReload')), array('order', 'number'));
  153.         $operator = $this->datagrid->addQuickColumn('Operadora', 'operator', 'center', 80 , new TAction(array($this, 'onReload')), array('order', 'operator'));
  154.         $ip = $this->datagrid->addQuickColumn('Ip', 'ip', 'center', 150, new TAction(array($this, 'onReload')), array('order', 'ip'));
  155.         $rate = $this->datagrid->addQuickColumn('Tarifa', 'rate', 'center', 80, new TAction(array($this, 'onReload')), array('order', 'rate'));
  156.         $source = $this->datagrid->addQuickColumn('Origem', 'source', 'center', 85, new TAction(array($this, 'onReload')), array('order', 'source'));
  157.         
  158.         $rate->setTransformer(array($this,'transformerCurrency'));
  159.         //$customer->setTransformer(array($this,'transformerCustomer'));
  160.         
  161.         //$this->datagrid->addQuickAction('Editar', new TDataGridAction(array('CdrForm', 'onEdit')), 'id', 'ico_edit.png');
  162.         //$this->datagrid->addQuickAction('Deletar', new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png');
  163.         
  164.         $this->datagrid->createModel();
  165.         
  166.         $this->datagrid_footer = new TQuickGrid;
  167.         $this->datagrid_footer->addQuickColumn('', 'total_records', 'left', 700);
  168.         $this->datagrid_footer->addQuickColumn('', 'count', 'right', 165);
  169.         $this->datagrid_footer->createModel();
  170.         
  171.         $this->pageNavigation = new TPageNavigation;
  172.         $this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
  173.         $this->pageNavigation->setWidth($this->datagrid->getWidth());
  174.         
  175.         // wrap the page content using vertical box
  176.         $vbox = new TVBox;
  177.         if( TSession::getValue('user_type') == "Admin" ){
  178.             $vbox->add( TMenuBar::newFromXML('app/templates/theme1/AdminMenu.xml') );
  179.             $vbox->add(new TXMLBreadCrumb('app/templates/theme1/AdminMenu.xml', __CLASS__));
  180.         } else {
  181.             $vbox->add( TMenuBar::newFromXML('app/templates/theme1/UserMenu.xml') );
  182.             $vbox->add(new TXMLBreadCrumb('app/templates/theme1/UserMenu.xml', __CLASS__));
  183.         }
  184.         $vbox->add( "<br />" );
  185.         $vbox->add($this->form);
  186.         $vbox->add($this->datagrid);
  187.         $vbox->add($this->datagrid_footer);
  188.         $vbox->add($this->pageNavigation);
  189.         
  190.         parent::add($vbox);
  191.     }
  192.     
  193.     public function transformerCurrency($value, $object, $row)
  194.     {
  195.         if ($value){
  196.             $value = "R$ " . number_format($value, 4, ',', '.');
  197.         } else {
  198.             $value=NULL;
  199.         }    
  201.         return "<span style='color:#006400'> $value </span>";
  202.         
  203.     }
  204.     
  205.     public function transformerCustomer ($value, $object, $row){
  206.         try{
  207.             TTransaction::open('easyconsulta');
  208.                 $customer = new Customer($value);
  209.                 //return $customer->customer;
  210.                 return "<span style='color:#FF0000; font-size: 70%; font-weight: bold;'>$customer->customer </span>";
  211.             TTransaction::close();
  212.             
  213.         } catch (Exception $e) {
  214.             new TMessage('error', '<b>Error</b> ' . $e->getMessage());
  215.         }
  216.         
  217.     }
  218.             
  219.     function onSearch($param)
  220.     {
  221.         $data = $this->form->getData();
  222.         $this->form->setData($data);
  223.         
  224.         TSession::setValue('ql-start_date', NULL);
  225.         TSession::setValue('ql-end_date', NULL);
  226.         TSession::setValue('ql-number', NULL);
  227.         TSession::setValue('ql-operator', NULL);
  228.         TSession::setValue('ql-ip', NULL);
  229.         TSession::setValue('ql-rate', NULL);
  230.         TSession::setValue('ql-source', NULL);
  231.         //TSession::setValue('ql-id_customer', NULL);
  232.         
  233.         if (!$data->start_time_hour){
  234.             $data->start_time_hour = "00";
  235.         }
  236.         
  237.         if (!$data->start_time_min){
  238.             $data->start_time_min = "00";
  239.         }
  240.         
  241.         if (!$data->end_time_hour){
  242.             $data->end_time_hour = "23";
  243.         }
  244.         
  245.         if (!$data->end_time_min){
  246.             $data->end_time_min = "59";
  247.         }
  248.         
  249.             if($data->start_date){
  250.                 $start_date = " date_time >= '" . $data->start_date . " " . $data->start_time_hour . ":" . $data->start_time_min . "' ";
  251.                 TSession::setValue('ql-start_date', $start_date);
  252.             } else {
  253.                 $start_date = " date_time >= CURDATE() ";
  254.                 TSession::setValue('ql-start_date', $start_date);
  255.             }
  256.           
  257.             if($data->end_date):
  258.                 $start_date = " date_time <= '" . $data->end_date . " " . $data->end_time_hour . ":" . $data->end_time_min . "' ";
  259.                 TSession::setValue('ql-end_date', $start_date);
  260.             endif;
  261.             
  262.             if($data->number):
  263.                 $number = " number = '" . $data->number . "' ";
  264.                 TSession::setValue('ql-number', $number);
  265.             endif;
  266.             
  267.             if($data->operator):
  268.                 $operator = " operator = '" . $data->operator . "' ";
  269.                 TSession::setValue('ql-operator', $operator);
  270.             endif;
  271.             
  272.             if($data->ip):
  273.                 $ip = " ip = '" . $data->ip . "' ";
  274.                 TSession::setValue('ql-ip', $ip);
  275.             endif;
  276.             
  277.             if($data->rate):
  278.                 $rate = " rate = '" . $data->rate . "' ";
  279.                 TSession::setValue('ql-rate', $rate);
  280.             endif;
  281.             
  282.             if($data->source):
  283.                 $source = " source = '" . $data->source . "' ";
  284.                 TSession::setValue('ql-source', $source);
  285.             endif;
  286.             
  287.             /*
  288.             if($data->customer):
  289.                 foreach ( $data->customer as $key => $value ) {
  290.                     1634_customer = $key;
  291.                 }
  292.                 
  293.                 $customer = " id_customer = '" . 1634_customer . "' ";
  294.                 TSession::setValue('ql-id_customer', $customer);
  295.             endif;
  296.              * 
  297.              */
  298.             
  299.             //var_dump($data->customer);
  300.             
  301.             if( TSession::getValue('user_type') == "User" ):
  302.                 1634_customer = " id_customer = '" . TSession::getValue('id_customer') . "' ";
  303.                 TSession::setValue('ql-id_customer', 1634_customer);
  304.             endif;
  305.             
  306.         $param=array();
  307.         $param['offset']    =0;
  308.         $param['first_page']=1;
  309.         $this->onReload($param);
  310.     }
  311.     
  312.     function onReload($param=NULL)
  313.     {
  314.         try
  315.         {
  316.             $limit = 100;
  317.             
  318.             $criteria = new TCriteria;
  319.             
  320.             $newparam = $param;
  321.             
  322.             if (empty($newparam['order']))
  323.             {
  324.                 $newparam['order'] = 'date_time';
  325.                 $newparam['direction'] = 'desc';
  326.             } else {
  327.                 $newparam['direction'] = 'asc';
  328.             }
  329.             
  330.             if (empty($newparam['offset']))
  331.             {
  332.                 $newparam['offset'] = 0;
  333.             }
  334.             
  335.             $criteria->setProperties($newparam);
  336.             $criteria->setProperty('limit', $limit);
  337.             
  338.             if ( TSession::getValue('ql-start_date') ){
  339.                 $where[] = TSession::getValue('ql-start_date'); 
  340.             }
  341.             
  342.             if ( TSession::getValue('ql-end_date') ){
  343.                 $where[] = TSession::getValue('ql-end_date'); 
  344.             }
  345.             
  346.             if ( TSession::getValue('ql-number') ){
  347.                 $where[] = TSession::getValue('ql-number'); 
  348.             }
  349.             
  350.             if ( TSession::getValue('ql-operator') ){
  351.                 $where[] = TSession::getValue('ql-operator'); 
  352.             }
  353.             
  354.             if ( TSession::getValue('ql-ip') ){
  355.                 $where[] = TSession::getValue('ql-ip'); 
  356.             }
  357.             
  358.             if ( TSession::getValue('ql-rate') ){
  359.                 $where[] = TSession::getValue('ql-rate'); 
  360.             }
  361.             
  362.             if ( TSession::getValue('ql-source') ){
  363.                 $where[] = TSession::getValue('ql-source'); 
  364.             }
  365.             
  366.             if ( TSession::getValue('ql-id_customer') ){
  367.                 $where[] = TSession::getValue('ql-id_customer'); 
  368.             }
  369.             
  370.             $sql = "SELECT * FROM query_records ";
  371.             $sql_count = "SELECT id FROM query_records ";
  372.             
  373.             if( isset( $where ) ){
  374.             $sql .= ' WHERE '.implode( ' AND ',$where ) . "order by " . $newparam['order'] . " " . $newparam['direction'] . " limit " . $newparam['offset'] . "," .  $limit  . " ";
  375.                         $sql_count .= ' WHERE '.implode( ' AND ',$where );
  376.             }    
  377.             
  378.                 //echo $sql . "<br />";
  379.             
  380.             TTransaction::open('easyconsulta'); 
  381.             $conn = TTransaction::get(); 
  382.             
  383.             $result = $conn->query("$sql");
  384.             $queries = $result->fetchAll(PDO::FETCH_OBJ);
  385.             
  386.             $result = $conn->query("$sql_count");
  387.             $row = $result->fetchAll(PDO::FETCH_OBJ);
  388.             $count = $result->rowCount();
  389.             
  390.             $this->datagrid->clear();
  391.             $this->datagrid_footer->clear();
  392.             
  393.             if ($queries)
  394.             {
  395.                 foreach ($queries as $query)
  396.                 {
  397.                     $this->datagrid->addItem($query);
  398.                 }
  399.                 
  400.             }
  401.             
  402.             $criteria->resetProperties();
  403.             $this->pageNavigation->setCount($count);
  404.             $this->pageNavigation->setProperties($param);
  405.             $this->pageNavigation->setLimit($limit);
  406.             
  407.             $registers = new stdClass();
  408.             $registers->total_records = 'Total de registros: ';
  409.             $registers->count = $count;
  410.             $this->datagrid_footer->addItem($registers);
  411.             
  412.             TTransaction::close();
  413.             $this->loaded=TRUE;
  414.         
  415.         } catch (Exception $e) {
  416.             new TMessage('error', '<b>Error</b> ' . $e->getMessage());
  417.             TTransaction::rollback();
  418.         }
  419.     }        
  420.     
  421.     function onExportCSV()
  422.     {
  423.             $file ="app/output/queries.csv";
  424.             $line = '';
  425.             if(file_exists($file)) unlink($file);
  426.             
  427.             if ( TSession::getValue('ql-start_date') ){
  428.                 $where[] = TSession::getValue('ql-start_date'); 
  429.             }
  430.             
  431.             if ( TSession::getValue('ql-end_date') ){
  432.                 $where[] = TSession::getValue('ql-end_date'); 
  433.             }
  434.             
  435.             if ( TSession::getValue('ql-number') ){
  436.                 $where[] = TSession::getValue('ql-number'); 
  437.             }
  438.             
  439.             if ( TSession::getValue('ql-operator') ){
  440.                 $where[] = TSession::getValue('ql-operator'); 
  441.             }
  442.             
  443.             if ( TSession::getValue('ql-ip') ){
  444.                 $where[] = TSession::getValue('ql-ip'); 
  445.             }
  446.             
  447.             if ( TSession::getValue('ql-rate') ){
  448.                 $where[] = TSession::getValue('ql-rate'); 
  449.             }
  450.             
  451.             if ( TSession::getValue('ql-source') ){
  452.                 $where[] = TSession::getValue('ql-source'); 
  453.             }
  454.             
  455.             /*
  456.             if ( TSession::getValue('ql-id_customer') ){
  457.                 $where[] = TSession::getValue('ql-id_customer'); 
  458.             }
  459.              * 
  460.              */
  461.             
  462.             $sql = "SELECT * FROM query_records ";
  463.             $sql_count = "SELECT id FROM query_records ";
  464.             
  465.             if( isset( $where ) ){
  466.             $sql .= ' WHERE '.implode( ' AND ',$where );
  467.             }    
  468.             
  469.                 //echo $sql . "<br />";
  470.             
  471.             TTransaction::open('easyconsulta'); 
  472.             $conn = TTransaction::get(); 
  473.             
  474.             $result = $conn->query("$sql");
  475.             $queries = $result->fetchAll(PDO::FETCH_OBJ);
  476.             
  477.                 if($queries){
  478.                                 
  479.                                 $header="Item".';'.
  480.                                 "Date / Hora".';'.
  481.                                 "Numero".';'.
  482.                                 "Operadora".';'.
  483.                                 "Ip".';'.
  484.                                 "Tarifa".';'.
  485.                                 "Origem"."\\n";
  486.                         
  487.                                 $this->onWriteCSV($file,$header);
  488.                                 $item = 1;
  489.                         foreach ($queries as $query){
  490.                             
  491.                                 $line = $item .';'. 
  492.                                 $query->date_time .';'. 
  493.                                 $query->number .';'. 
  494.                                 $query->operator .';'. 
  495.                                 $query->ip .';'. 
  496.                                 $query->rate .';'.
  497.                                 $query->source . "\\n";
  498.                                 
  499.                                 $this->onWriteCSV($file,$line);
  500.                                 $item++;
  501.                         }        
  502.                     
  503.                     TPage::openFile($file); 
  504.                     
  505.                     } else {
  506.                         new TMessage('info', 'Não existem dados para este filstro' . '.',NULL,'Status');
  507.                     }
  508.                     TTransaction::close();
  509.     }
  510.     
  511.     function onWriteCSV($file,$line){
  512.     $fp = fopen($file, "a");
  513.     $write = fwrite($fp, $line);
  514.     fclose($fp);
  515.     }
  516.     
  517.     function show(){
  518.         if (!$this->loaded)
  519.         {
  520.             $this->onSearch( func_get_arg(0) );
  521.             parent::show();
  522.         }
  523.         
  524.     }
  525.     
  526. }

Curso Dominando o Adianti Framework

O material mais completo de treinamento do Framework.
Curso em vídeo aulas + Livro completo + Códigos fontes do projeto ERPHouse.
Conteúdo Atualizado!


Dominando o Adianti Framework Quero me inscrever agora!

Comentários (1)

PD
Pablo Dall'Oglio       13/11/2015 (há 9 anos)

Troque onSearch() por onReload() dentro do show()