Automatic conditional row numbering

[dimoss]

Hi,

I am using the Php Events List plugin using the following code inside onLoadDat to autonumber the records of a list:

$rownum = $model->limitStart;
$data = $args[0]->data;
foreach ($data as $group) {
   foreach ($group as $row) {
      $rownum++;
      $row->fab_list_able_28_repeat___no = $rownum;
      $row->fab_list_able_28_repeat___no_raw = $rownum;
   }
}

The 'fab_list_able_28_repeat___no' is a single field hidden which is used only for diplaying the row number.
Everything is fine and works as expected.
However I cannot find a way do not numbering rows when the value in the field fab_list_able_28_repeat___wl_raw is 'NER' or 'WDL'
In other words I am trying to have a conditional numbering.

Any ideas are appreciated.

Thanks.

 

[troester]

...
foreach ($group as $row) {
if (...) continue;

 

[dimoss]

Hi Troester,
thanks for that. It worked!

For anyone who might need something similar here is the complete code:

$rownum = $model->limitStart;
$data = $args[0]->data;
foreach ($data as $group) {
   foreach ($group as $row) {
   $condition = $row->fab_list_able_28_repeat___wl_raw;
      if ($condition == 'NER' || $condition == 'WDN') continue;
      $rownum++;
      $row->fab_list_able_28_repeat___no = $rownum;
      $row->fab_list_able_28_repeat___no_raw = $rownum;
   }
}

 

[dimoss]

Hi,

i open this thread because i would like to find a way using the PHP list plugin to apply the same method updating another field.
Tried this but didnt work:

$db = JFactory::getDBO();
$query = $db->getQuery(true);
$app = JFactory::getApplication();
$rownum = $model->limitStart;
$data = $args[0]->data;
foreach ($data as $group) {
   foreach ($group as $row) {
   $condition = $row->fab_list_able_28_repeat___wl_raw;
      if ($condition == 'NER' || $condition == 'WDN') continue;
      $rownum++;
      $row->fab_list_able_28_repeat___no = $rownum;
      $row->fab_list_able_28_repeat___no_raw = $rownum;
$query = "UPDATE fab_list_able_28_repeat SET position = $rownum";
$db->setQuery( $query );
$db->execute();
   }
}

Any idea?
Thanks.

 

[lousyfool]

A couple of ideas.

It's not "in the way", but what do you need $app for?
Which plugin are you using? You say "PHP List plugin", but it rather seems to be the "PHP Events list plugin"?If (if!) this would work, it would update all "position" cells in the repeat table to that same $rownum value, and each time the condition allows it. Is that what you really want?
Eventually move $query = $db->getQuery(true); into the loop.
Syntax error?
$query = "UPDATE fab_list_able_28_repeat SET position = $rownum";
should probably be
$query = "UPDATE fab_list_able_28_repeat SET position = '{$rownum}'";
or
$query = "UPDATE fab_list_able_28_repeat SET position = ".$rownum;
or
$query = "UPDATE fab_list_able_28_repeat SET position = '$rownum'";
or
$query = "UPDATE fab_list_able_28_repeat SET position = '".$rownum."'";

Sorry, I feel it must be said again: before posting basic "generic" PHP code which "doesn't work" here in the Fabrik forum, please first make sure that you've followed all coding rules, use correct syntax, and so on. Error reporting will help you, as well as var_dump($xyz);exit; and other debugging to avoid using fellow forum members as spellcheckers or free workers -- thank you.

 

[dimoss]

Hi @lousyfool

I use PHP list plugin and in every case returns 0 instead of the number.
If you read the previous messages it works fine in PHP Event on load but this for a different purposes as it is created on the fly.
What I want is to use the same loop and update each record.
And yes, there was typo (thanks for that) but unfortunately that was irrelevant.

 

[troester]

I think there's no $args[0]->data in the php list plugin (where is it coming from in php events plugin?).

What are you trying to do?
See https://fabrikar.com/forums/index.php?wiki/php-list-plugin/#get-selected-row-id-s for how to access list data.

 

[dimoss]

I think there's no $args[0]->data in the php list plugin (where is it coming from in php events plugin?).

What are you trying to do?
See https://fabrikar.com/forums/index.php?wiki/php-list-plugin/#get-selected-row-id-s for how to access list data.

Hi Troester,

thanks.
I am trying to update a field in the selected rows applying consecutive numbering (ex, 1,2,3,...).
In PHP Events works fine but it works on the fly onLoadData which is not what I want.

 

[troester]

As I said: I think there's no $args[0]->data in list php plugin.

Use var_dump to check and see WIKI for selected row ids and data.

 

[dimoss]

Wiki helped

$app = JFactory::getApplication();
$ids = $app->input->get('ids', array(), 'array');
$count = 0;
foreach($ids as $id)
{
  $count = $count + 1;
  $model->updateRow($id, "fab_doubles.position", $count);
}

In case someone is interested.