Today

• 16 hours ago

  issue 84 (private function setAdapter($adapter)) reported by trueorfalse   -   I think this function is must be public because one grid more database is a good thing. someone can will be need it ... like me.

  I think this function is must be public because one grid more database is a good thing. someone can will be need it ... like me.

Last 7 days

• Dec 22, 2009

  issue 83 (Form: addColumns array support ) reported by trueorfalse   -   I have made a small modification on Grid_Form file on function: function addColumns() { $columns = func_get_args (); $final = array (); if (is_array($columns[0])) { $columns = $columns[0]; } foreach ( $columns as $value ) { if ($value instanceof Bvb_Grid_Form_Column) { array_push ( $final, $value ); } } $this->fields = $final; return $this; } ------------------------------ usage: $formElements['Status'] = new Bvb_Grid_Form_Column ( 'status' ); $formElements['Status']->title ( 'Durum' ); $formElements['Status']->values ($statusList ); // $f['Order'] = new Bvb_Grid_Form_Column ( 'order' ); // $f['Order']->title ( 'Sıra' ); // $f['Order']->values ( $orderList ); $form->addColumns ( $formElements ); just that :)

  I have made a small modification on Grid_Form file on function: function addColumns() { $columns = func_get_args (); $final = array (); if (is_array($columns[0])) { $columns = $columns[0]; } foreach ( $columns as $value ) { if ($value instanceof Bvb_Grid_Form_Column) { array_push ( $final, $value ); } } $this->fields = $final; return $this; } ------------------------------ usage: $formElements['Status'] = new Bvb_Grid_Form_Column ( 'status' ); $formElements['Status']->title ( 'Durum' ); $formElements['Status']->values ($statusList ); // $f['Order'] = new Bvb_Grid_Form_Column ( 'order' ); // $f['Order']->title ( 'Sıra' ); // $f['Order']->values ( $orderList ); $form->addColumns ( $formElements ); just that :)

Last 30 days

• Dec 18, 2009

  issue 82 ($form->add(1) undefined key) reported by trueorfalse   -   deploy/table.php online 2071 if ($options ['add'] == 1) { $this->add = array ('allow' => 1, 'button' => $options ['button'], 'fields' => $fields, 'force' => @$options ['onAddForce'] ); } this makes undefined key error may it's need this fix. to if (isset ( $options ['add'] ) && $options ['add'] == 1) { $this->add = array ('allow' => 1, 'button' => $options ['button'], 'fields' => $fields, 'force' => @$options ['onAddForce'] ); }

  deploy/table.php online 2071 if ($options ['add'] == 1) { $this->add = array ('allow' => 1, 'button' => $options ['button'], 'fields' => $fields, 'force' => @$options ['onAddForce'] ); } this makes undefined key error may it's need this fix. to if (isset ( $options ['add'] ) && $options ['add'] == 1) { $this->add = array ('allow' => 1, 'button' => $options ['button'], 'fields' => $fields, 'force' => @$options ['onAddForce'] ); }
• Dec 18, 2009

  issue 81 (Model File Implementation) reported by trueorfalse   -   I think, Grid need a model file implementation ?

  I think, Grid need a model file implementation ?
• Dec 17, 2009

  issue 80 (Ordering: buildTitles an Table Names with _) changed by pao.fresco   -   Hi Kleina, Thanks for the report and code. Already commited. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco

  Hi Kleina, Thanks for the report and code. Already commited. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco
• Dec 17, 2009

  r237 (FIXES-80: Not ordering tables with _ on the name) committed by pao.fresco   -   FIXES-80: Not ordering tables with _ on the name

  FIXES-80: Not ordering tables with _ on the name
• Dec 17, 2009

  issue 76 (Row Count wrong with complex Select) commented on by pao.fresco   -   Done. Thanks Best Regards, Bento Vilas Boas

  Done. Thanks Best Regards, Bento Vilas Boas
• Dec 17, 2009

  r236 (FIXES-76: Row counting) committed by pao.fresco   -   FIXES-76: Row counting

  FIXES-76: Row counting
• Dec 17, 2009

  issue 78 (Feature Request: Bvb_Grid_Formatter_Currency) commented on by trueorfalse   -   Hi, My name is Murat Beşer, I'm sure you are remember me... May be we need some modificaton on source code for this decoration thing. Firstly we need a Table Creator and may be a... Maybe I can write something like that or we need a little search.

  Hi, My name is Murat Beşer, I'm sure you are remember me... May be we need some modificaton on source code for this decoration thing. Firstly we need a Table Creator and may be a... Maybe I can write something like that or we need a little search.
• Dec 17, 2009

  issue 77 (How to set default order?) commented on by kleina.iphone   -   would be great if the default order from the select would be display in the titlebar. so if no order parameter is set via url the $this->ctrlParams ['order'] could return the ordering paramter from the select ?!

  would be great if the default order from the select would be display in the titlebar. so if no order parameter is set via url the $this->ctrlParams ['order'] could return the ordering paramter from the select ?!
• Dec 17, 2009

  issue 77 (How to set default order?) commented on by kleina.iphone   -   works now thx

  works now thx
• Dec 17, 2009

  issue 80 (Ordering: buildTitles an Table Names with _) reported by kleina.iphone   -   Table Name: first_test_table Ordering Paramter in URL: first_test_table_ASC $explode = explode ( '_', $this->ctrlParams ['order'] ); $this->order [reset ( $explode )] = strtoupper ( end ( $explode ) ) == 'ASC' ? 'DESC' : 'ASC'; will get first => ASC so the next steps will fail, because table 'first' will not be found. Something like this should help: $name = str_replace('_'.end($explode),'',$this->ctrlParams ['order']); $this->order [$name] = strtoupper ( end ( $explode ) ) == 'ASC' ? 'DESC' : 'ASC';

  Table Name: first_test_table Ordering Paramter in URL: first_test_table_ASC $explode = explode ( '_', $this->ctrlParams ['order'] ); $this->order [reset ( $explode )] = strtoupper ( end ( $explode ) ) == 'ASC' ? 'DESC' : 'ASC'; will get first => ASC so the next steps will fail, because table 'first' will not be found. Something like this should help: $name = str_replace('_'.end($explode),'',$this->ctrlParams ['order']); $this->order [$name] = strtoupper ( end ( $explode ) ) == 'ASC' ? 'DESC' : 'ASC';
• Dec 17, 2009

  issue 76 (Row Count wrong with complex Select) commented on by kleina.iphone   -   there is a better solution: Remove the group field $selectZendDb = clone $this->_select; $selectZendDb->reset ( Zend_Db_Select::LIMIT_COUNT ); $selectZendDb->reset ( Zend_Db_Select::LIMIT_OFFSET ); $selectZendDb->reset ( Zend_Db_Select::COLUMNS ); $selectZendDb->reset ( Zend_Db_Select::ORDER ); $selectZendDb->reset ( Zend_Db_Select::GROUP );

  there is a better solution: Remove the group field $selectZendDb = clone $this->_select; $selectZendDb->reset ( Zend_Db_Select::LIMIT_COUNT ); $selectZendDb->reset ( Zend_Db_Select::LIMIT_OFFSET ); $selectZendDb->reset ( Zend_Db_Select::COLUMNS ); $selectZendDb->reset ( Zend_Db_Select::ORDER ); $selectZendDb->reset ( Zend_Db_Select::GROUP );
• Dec 16, 2009

  issue 73 (Delete Rows with complex Select SQL) Status changed by pao.fresco   -   Hi Kleina, This should be fixed now. Please update your lib to the latest revision Best Regards, Bento Vilas Boas

  Status: Fixed

  Hi Kleina, This should be fixed now. Please update your lib to the latest revision Best Regards, Bento Vilas Boas

  Status: Fixed
• Dec 16, 2009

  r235 (FIXED-73: Deleting records with joins) committed by pao.fresco   -   FIXED-73: Deleting records with joins

  FIXED-73: Deleting records with joins
• Dec 16, 2009

  issue 76 (Row Count wrong with complex Select) changed by pao.fresco   -   Hi kleina, Thanks for he report and fix. Already commited. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco

  Hi kleina, Thanks for he report and fix. Already commited. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco
• Dec 16, 2009

  r234 (FIXED-73: Row counting when groupping) committed by pao.fresco   -   FIXED-73: Row counting when groupping

  FIXED-73: Row counting when groupping
• Dec 16, 2009

  issue 73 (Delete Rows with complex Select SQL) changed by pao.fresco   -  

  Status: Started

  Owner: pao.fresco

  Status: Started

  Owner: pao.fresco
• Dec 15, 2009

  r233 (FIX-75: Use the method addExtraColumns more than once) committed by pao.fresco   -   FIX-75: Use the method addExtraColumns more than once

  FIX-75: Use the method addExtraColumns more than once
• Dec 15, 2009

  issue 75 (Feature Request: use addExtraColumns() more than one time) changed by pao.fresco   -   Hi simone, Thanks for the report. Should be fine now. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco

  Hi simone, Thanks for the report. Should be fine now. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco
• Dec 15, 2009

  issue 72 (Array Checks) changed by pao.fresco   -   Hi kleina, Thanks for the report. Should be fine now. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco

  Hi kleina, Thanks for the report. Should be fine now. Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco
• Dec 15, 2009

  r232 (Ignore this. Reverting some options) committed by pao.fresco   -   Ignore this. Reverting some options

  Ignore this. Reverting some options
• Dec 15, 2009

  r231 (72 - FIX: Fields on crud actions) committed by pao.fresco   -   72 - FIX: Fields on crud actions

  72 - FIX: Fields on crud actions
• Dec 15, 2009

  issue 77 (How to set default order?) Status changed by pao.fresco   -   Hi kleina, Please check if this is working. I've made some changes, and it should work now. Best Regards, Bento Vilas Boas

  Status: Fixed

  Hi kleina, Please check if this is working. I've made some changes, and it should work now. Best Regards, Bento Vilas Boas

  Status: Fixed
• Dec 15, 2009

  r230 (FIXED-77: Default order) committed by pao.fresco   -   FIXED-77: Default order

  FIXED-77: Default order
• Dec 15, 2009

  issue 77 (How to set default order?) Status changed by pao.fresco   -  

  Status: Started

  Status: Started
• Dec 15, 2009

  r229 (NEW: Allow to set a form select item as selected when not ed...) committed by pao.fresco   -   NEW: Allow to set a form select item as selected when not editing

  NEW: Allow to set a form select item as selected when not editing
• Dec 14, 2009

  issue 79 ($grid->sqlexp with sum over count and price) reported by kleina.iphone   -   buildSqlExp should be able to handle several colums like this: $grid->sqlexp (array( 'o.summe'=>array( 'functions' => array('SUM'), 'value' => 'o.price*o.number', ) )); changes for buildsqlexp: if (is_array ( $value )) { $valor = ''; foreach ( $value['functions'] as $final ) { $valor .= $final . '('; } $valor .= $value['value'] . str_repeat ( ')', count ( $value['functions'] ) ); } else { $valor = "$value(".$value['value'].")"; } Then there should be support for formatter !!! and there should not be rounding the value per default.

  buildSqlExp should be able to handle several colums like this: $grid->sqlexp (array( 'o.summe'=>array( 'functions' => array('SUM'), 'value' => 'o.price*o.number', ) )); changes for buildsqlexp: if (is_array ( $value )) { $valor = ''; foreach ( $value['functions'] as $final ) { $valor .= $final . '('; } $valor .= $value['value'] . str_repeat ( ')', count ( $value['functions'] ) ); } else { $valor = "$value(".$value['value'].")"; } Then there should be support for formatter !!! and there should not be rounding the value per default.
• Dec 14, 2009

  issue 78 (Feature Request: Bvb_Grid_Formatter_Currency) commented on by kleina.iphone   -   did not find a nice way to align to the right: so i changed it to: return '<div align="right">'.$currency->toCurrency($value).'</div>'; PS: i seems you can not use formatter and decorator params at the same time

  did not find a nice way to align to the right: so i changed it to: return '<div align="right">'.$currency->toCurrency($value).'</div>'; PS: i seems you can not use formatter and decorator params at the same time
• Dec 14, 2009

  issue 78 (Feature Request: Bvb_Grid_Formatter_Currency) reported by kleina.iphone   -   class App_Grid_Formatter_Currency { public $locale = 'en_US'; function __construct($loc) { $this->locale = $loc; } function format($value) { $currency = new Zend_Currency($this->locale); return $currency->toCurrency($value); } }

  class App_Grid_Formatter_Currency { public $locale = 'en_US'; function __construct($loc) { $this->locale = $loc; } function format($value) { $currency = new Zend_Currency($this->locale); return $currency->toCurrency($value); } }
• Dec 14, 2009

  issue 77 (How to set default order?) commented on by kleina.iphone   -   please change state from invalid to defect

  please change state from invalid to defect
• Dec 14, 2009

  issue 77 (How to set default order?) commented on by kleina.iphone   -   it seems the order from select in the query is remove by $grid, if no order parameter is in the url: Before $grid->deploy(): SELECT `o`.`timestamp`, `s`.`name` FROM `bo_orders_stati` AS `o` INNER JOIN `bo_orders_stati_names` AS `s` ON s.id=o.stati WHERE (o.orders=5601) ORDER BY `timestamp` DESC After: SELECT `o`.`timestamp`, `s`.`name` FROM `bo_orders_stati` AS `o` INNER JOIN `bo_orders_stati_names` AS `s` ON s.id=o.stati WHERE (o.orders=5601) LIMIT 15

  it seems the order from select in the query is remove by $grid, if no order parameter is in the url: Before $grid->deploy(): SELECT `o`.`timestamp`, `s`.`name` FROM `bo_orders_stati` AS `o` INNER JOIN `bo_orders_stati_names` AS `s` ON s.id=o.stati WHERE (o.orders=5601) ORDER BY `timestamp` DESC After: SELECT `o`.`timestamp`, `s`.`name` FROM `bo_orders_stati` AS `o` INNER JOIN `bo_orders_stati_names` AS `s` ON s.id=o.stati WHERE (o.orders=5601) LIMIT 15
• Dec 14, 2009

  issue 77 (How to set default order?) changed by pao.fresco   -   Hi kleina, The default order should be set using your query. $grid->order() is captured within the __call method Best Regards, Bento Vilas Boas

  Status: Invalid

  Owner: pao.fresco

  Hi kleina, The default order should be set using your query. $grid->order() is captured within the __call method Best Regards, Bento Vilas Boas

  Status: Invalid

  Owner: pao.fresco
• Dec 14, 2009

  issue 77 (How to set default order?) reported by kleina.iphone   -   Documation says: $grid->order('id DESC'); But there is no function order. just a protected var.

  Documation says: $grid->order('id DESC'); But there is no function order. just a protected var.
• Dec 14, 2009

  issue 76 (Row Count wrong with complex Select) commented on by kleina.iphone   -   if (count($resultZendDb)==1) { $resultCount = $resultZendDb [0]->TOTAL; } else { $resultCount = count($resultZendDb); }

  if (count($resultZendDb)==1) { $resultCount = $resultZendDb [0]->TOTAL; } else { $resultCount = count($resultZendDb); }
• Dec 14, 2009

  issue 70 (Joins / same column names and Filters) commented on by kleina.iphone   -   for sorting is one more change needed: buildQuery in datagrid OLD: }else{ array_pop ( $order1 ); $order_field = implode ( "_", $order1 ); $query_order = $order_field . " $orderf "; $this->_select->order ( $query_order ); NEW: }else{ array_pop ( $order1 ); $order_field = implode ( "_", $order1 ); $query_order = $order_field . " $orderf "; foreach ($this->_select->getPart ( Zend_Db_Select::COLUMNS ) as $col){ if (($col[0].'.'.$col[2]==$order_field) and is_object($col[1])){ $query_order = $col[2] . " $orderf "; } } $this->_select->order ( $query_order );

  for sorting is one more change needed: buildQuery in datagrid OLD: }else{ array_pop ( $order1 ); $order_field = implode ( "_", $order1 ); $query_order = $order_field . " $orderf "; $this->_select->order ( $query_order ); NEW: }else{ array_pop ( $order1 ); $order_field = implode ( "_", $order1 ); $query_order = $order_field . " $orderf "; foreach ($this->_select->getPart ( Zend_Db_Select::COLUMNS ) as $col){ if (($col[0].'.'.$col[2]==$order_field) and is_object($col[1])){ $query_order = $col[2] . " $orderf "; } } $this->_select->order ( $query_order );
• Dec 14, 2009

  issue 76 (Row Count wrong with complex Select) commented on by kleina.iphone   -   one more: you should add: $selectZendDb->reset ( Zend_Db_Select::ORDER )

  one more: you should add: $selectZendDb->reset ( Zend_Db_Select::ORDER )
• Dec 14, 2009

  issue 76 (Row Count wrong with complex Select) commented on by kleina.iphone   -   if you change $resultCount = $resultZendDb [0]->TOTAL; to $resultCount = count($resultZendDb); i get a paginator like this (which is correct): (1 to 30 of 17929 records) | 1 2 3 4 5 ... 598 Next Last

  if you change $resultCount = $resultZendDb [0]->TOTAL; to $resultCount = count($resultZendDb); i get a paginator like this (which is correct): (1 to 30 of 17929 records) | 1 2 3 4 5 ... 598 Next Last
• Dec 14, 2009

  issue 76 (Row Count wrong with complex Select) commented on by kleina.iphone   -   may be the method from zend paginator (setRowCount) should be used or copied

  may be the method from zend paginator (setRowCount) should be used or copied
• Dec 14, 2009

  issue 76 (Row Count wrong with complex Select) reported by kleina.iphone   -   $select = $db->select() ->from(array('bo_contacts'),array('id','surname','name','company','email','city')) ->join(array('bo_usergroup'),'bo_usergroup.id=bo_contacts.usergroup',array('gruppe')) ->joinLeft(array('bo_orders'),'bo_orders.contact=bo_contacts.id',array('bestellungen'=> 'count(bo_orders.contact)')) ->group('bo_contacts.id'); Show in the DataGrid Paginator: 1 records This is the SQL from Deploy $selectZendDb = clone $this->_select; $selectZendDb->reset ( Zend_Db_Select::LIMIT_COUNT ); $selectZendDb->reset ( Zend_Db_Select::LIMIT_OFFSET ); $selectZendDb->reset ( Zend_Db_Select::COLUMNS ); $selectZendDb->columns ( array ('TOTAL' => new Zend_Db_Expr ( "COUNT(*)" ) ) ); SELECT COUNT(*) AS `TOTAL` FROM `bo_contacts` INNER JOIN `bo_usergroup` ON bo_usergroup.id=bo_contacts.usergroup LEFT JOIN `bo_orders` ON bo_orders.contact=bo_contacts.id GROUP BY `bo_contacts`.`id` The result from SQL show like this: 17,929 rows with each row looks like "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1"

  $select = $db->select() ->from(array('bo_contacts'),array('id','surname','name','company','email','city')) ->join(array('bo_usergroup'),'bo_usergroup.id=bo_contacts.usergroup',array('gruppe')) ->joinLeft(array('bo_orders'),'bo_orders.contact=bo_contacts.id',array('bestellungen'=> 'count(bo_orders.contact)')) ->group('bo_contacts.id'); Show in the DataGrid Paginator: 1 records This is the SQL from Deploy $selectZendDb = clone $this->_select; $selectZendDb->reset ( Zend_Db_Select::LIMIT_COUNT ); $selectZendDb->reset ( Zend_Db_Select::LIMIT_OFFSET ); $selectZendDb->reset ( Zend_Db_Select::COLUMNS ); $selectZendDb->columns ( array ('TOTAL' => new Zend_Db_Expr ( "COUNT(*)" ) ) ); SELECT COUNT(*) AS `TOTAL` FROM `bo_contacts` INNER JOIN `bo_usergroup` ON bo_usergroup.id=bo_contacts.usergroup LEFT JOIN `bo_orders` ON bo_orders.contact=bo_contacts.id GROUP BY `bo_contacts`.`id` The result from SQL show like this: 17,929 rows with each row looks like "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1" "1"
• Dec 14, 2009

  issue 70 (Joins / same column names and Filters) commented on by kleina.iphone   -   getPart ( Zend_Db_Select::COLUMNS ) resulst for DB Expresions in: [7] => Array ( [0] => bo_orders [1] => Zend_Db_Expr Object ( [_expression:protected] => count(bo_orders.contact) ) [2] => bestellungen )

  getPart ( Zend_Db_Select::COLUMNS ) resulst for DB Expresions in: [7] => Array ( [0] => bo_orders [1] => Zend_Db_Expr Object ( [_expression:protected] => count(bo_orders.contact) ) [2] => bestellungen )
• Dec 14, 2009

  issue 70 (Joins / same column names and Filters) commented on by kleina.iphone   -   Found a fix in Datagrid.php => Function getFieldsFromQuery OLD if (strlen ( $value [2] ) > 0) { $title = $value [2]; $this->updateColumn ( $value [0] . '.' . $value [1] . ' as ' . $value [2], array ('title' => $title ) ); } else { $title = ucfirst ( $value [1] ); $this->updateColumn ( $value [0] . '.' . $value [1], array ('title' => $title ) ); } NEW: if (is_object($value [1])){ $title = $value [2]; $this->updateColumn ( $value [0] . '.' . $value [2] . ' as ' . $value [2], array ('title' => $title ) ); } elseif (strlen ( $value [2] ) > 0) { $title = $value [2]; $this->updateColumn ( $value [0] . '.' . $value [1] . ' as ' . $value [2], array ('title' => $title ) ); } else { $title = ucfirst ( $value [1] ); $this->updateColumn ( $value [0] . '.' . $value [1], array ('title' => $title ) ); }

  Found a fix in Datagrid.php => Function getFieldsFromQuery OLD if (strlen ( $value [2] ) > 0) { $title = $value [2]; $this->updateColumn ( $value [0] . '.' . $value [1] . ' as ' . $value [2], array ('title' => $title ) ); } else { $title = ucfirst ( $value [1] ); $this->updateColumn ( $value [0] . '.' . $value [1], array ('title' => $title ) ); } NEW: if (is_object($value [1])){ $title = $value [2]; $this->updateColumn ( $value [0] . '.' . $value [2] . ' as ' . $value [2], array ('title' => $title ) ); } elseif (strlen ( $value [2] ) > 0) { $title = $value [2]; $this->updateColumn ( $value [0] . '.' . $value [1] . ' as ' . $value [2], array ('title' => $title ) ); } else { $title = ucfirst ( $value [1] ); $this->updateColumn ( $value [0] . '.' . $value [1], array ('title' => $title ) ); }
• Dec 13, 2009

  issue 75 (Feature Request: use addExtraColumns() more than one time) reported by simone.cicali   -   if i write: $grid->addExtraColumns($ColumnObject1,$ColumnObject2); $grid->addExtraColumns($ColumnObject3); only $ColumnObject3 appear I think you can add this on line 3015 of DataGrid.php if (is_array($this->extra_fields)){ $final = $this->extra_fields; } else{ $final = array (); }

  if i write: $grid->addExtraColumns($ColumnObject1,$ColumnObject2); $grid->addExtraColumns($ColumnObject3); only $ColumnObject3 appear I think you can add this on line 3015 of DataGrid.php if (is_array($this->extra_fields)){ $final = $this->extra_fields; } else{ $final = array (); }
• Dec 12, 2009

  issue 74 (About issue 71 hide/unhide fields) changed by pao.fresco   -   Hi Simone, You are comletly right. I've already fixed this. Please update your lib to hte latest revision Thanks, Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco

  Hi Simone, You are comletly right. I've already fixed this. Please update your lib to hte latest revision Thanks, Best Regards, Bento Vilas Boas

  Status: Fixed

  Owner: pao.fresco
• Dec 12, 2009

  r228 (changelog updated) committed by pao.fresco   -   changelog updated

  changelog updated
• Dec 12, 2009

  r227 (Bug with hidden fields) committed by pao.fresco   -   Bug with hidden fields

  Bug with hidden fields
• Dec 12, 2009

  issue 74 (About issue 71 hide/unhide fields) reported by simone.cicali   -   In DataGrid.php revision 226, line 1481 the if condition must be: if (! isset ( $novaData [$titles [$i]] ['hide'] ) || $novaData [$titles [$i]] ['hide'] == 0) { and not if (! isset ( $novaData [$titles [$i]] ['hide'] )) {

  In DataGrid.php revision 226, line 1481 the if condition must be: if (! isset ( $novaData [$titles [$i]] ['hide'] ) || $novaData [$titles [$i]] ['hide'] == 0) { and not if (! isset ( $novaData [$titles [$i]] ['hide'] )) {
• Dec 11, 2009

  issue 72 (Array Checks) commented on by kleina.iphone   -   URL: edit/1/comm/mode:edit;[bo_contacts.id:21580] Warning: array_keys() [function.array-keys]: The first argument should be an array in Bvb/Grid/Deploy/Table.php on line 1837 Warning: Invalid argument supplied for foreach() in Bvb/Grid/Deploy/Table.php on line 1837

  URL: edit/1/comm/mode:edit;[bo_contacts.id:21580] Warning: array_keys() [function.array-keys]: The first argument should be an array in Bvb/Grid/Deploy/Table.php on line 1837 Warning: Invalid argument supplied for foreach() in Bvb/Grid/Deploy/Table.php on line 1837
• Dec 11, 2009

  issue 73 (Delete Rows with complex Select SQL) commented on by kleina.iphone   -   Using select _without_ alias tables names works! $select = $db->select() ->from(array('bo_contacts'),array('id','surname','name','company','email','city')) ->join(array('bo_usergroup'),'bo_usergroup.id=bo_contacts.usergroup',array('gruppe')) ->joinLeft(array('bo_orders'),'bo_orders.contact=bo_contacts.id',array('bestellungen'=> 'count(bo_orders.contact)')) ->group('bo_contacts.id');

  Using select _without_ alias tables names works! $select = $db->select() ->from(array('bo_contacts'),array('id','surname','name','company','email','city')) ->join(array('bo_usergroup'),'bo_usergroup.id=bo_contacts.usergroup',array('gruppe')) ->joinLeft(array('bo_orders'),'bo_orders.contact=bo_contacts.id',array('bestellungen'=> 'count(bo_orders.contact)')) ->group('bo_contacts.id');
• Dec 11, 2009

  issue 73 (Delete Rows with complex Select SQL) commented on by kleina.iphone   -   Using select with alias tables names works! $select = $db->select() ->from(array('bo_contacts'),array('id','surname','name','company','email','city')) ->join(array('bo_usergroup'),'bo_usergroup.id=bo_contacts.usergroup',array('gruppe')) ->joinLeft(array('bo_orders'),'bo_orders.contact=bo_contacts.id',array('bestellungen'=> 'count(bo_orders.contact)')) ->group('bo_contacts.id');

  Using select with alias tables names works! $select = $db->select() ->from(array('bo_contacts'),array('id','surname','name','company','email','city')) ->join(array('bo_usergroup'),'bo_usergroup.id=bo_contacts.usergroup',array('gruppe')) ->joinLeft(array('bo_orders'),'bo_orders.contact=bo_contacts.id',array('bestellungen'=> 'count(bo_orders.contact)')) ->group('bo_contacts.id');