Problem with Custom work

[nofc_fro]

Hi,
this section doesn't work! http://fabrikar.com/quote-request
I have to implement a viz map function, how can I do?

 

[cheesegrits]

We're working on providing a new way to request custom work. We had hoped to have it going when we migrated the site, but we've had some family health issues to deal with.

For now, just post here.

What map function do you need?

-- hugh

 

[nofc_fro]

I have a map with several apartments. Each apartment can be available or unavailable. I set the availability of the apartment by the fabrik form, but I would like to set it also from the "Bubble template" of the viz map. How can I do?

 

[cheesegrits]

You mean you want to be able to do something like click on a button and update the record with an AJAX call, or something like that?

-- hugh

 

[nofc_fro]

Yes

 

[cheesegrits]

There's nothing built-in to do that, but it might be possible, rolling your own code to fire an AJAX call. Probably by inserting the markup for a button in the template, with a data attribute for the rowid, then having a viz_X.js (in ./components/com_fabrik/js, replace X with nymeric viz id) file listening for that button press. But I've never tried it, so I don't have any example code to hand.

-- hugh

 

[nofc_fro]

Thank you!
Unfortunately I do not know the Javascript language, who can I contact to make this change?

 

[cheesegrits]

Well, the Javascript part is relatively easy. In your bubble template in the viz, add something like ...

<button class="mapButton" type="button" data-rowid="{rowid}">Push Me!</button>

... which adds a button (Push Me!) to the template, with a data-rowid attribute set to the rowid of that pin.

The viz_X.js ...

// set up a delegated event for all buttons with class mapButton
jQuery('body').on('click', '.mapButton', function(e) {
    e.preventDefault();
    // get the rowid from the data attribute we added to the button markup
    var rowid = jQuery(e.target).data('rowid');
    // fire off an AJAX call the Fabrik userAjax class
    var url = Fabrik.liveSite + "/index.php?option=com_fabrik&format=raw&task=plugin.userAjax&method=doButton";
    jQuery.ajax({
        url       : url,
        data      : {
            rowid: rowid
        }
    }).done(function (r) {
        // show the result in an alert
        alert(r);
    });
});

... then you need to add a file, ./components/com_fabrik/user_ajax.php ...

class UserAjax
{
   public function doButton()
   {
      // get the rowid from the input data
      $app = JFactory::getApplication();
      $rowid = $app->input->get('rowid', '');

      // make sure we got a rowid
      if (!empty($rowid))
      {
         // run a query to set a field on our table for that rowid
         // CHANGE ME!  Replace with your table and field names
         $db = JFactory::getDbo();
         $query = $db->getQuery(true);
         $query->update('yourtable')
            ->set('available = 1')
           ->where('id = ' . (int)$rowid);
         $db->setQuery($query);
         $db->execute();
         $result = "Set row $rowid to available";
      }
      else
      {
         $result = "Error!  No rowid!";
      }

      echo $result;
   }
}

That should give you a button that set a field called "available" to 1 in "yourtable" for the row's pin it was clicked on.

You can modify this to set it to 0, or have two button ("Make Available" and "Make Unavailable") by adding two buttons in the bubble template, change the class names, and add a second on('click') handler for the other one, that calls a different method within the userAjax class.

-- hugh