• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: How to debug php code snippet

How to debug php code snippet 3 weeks 4 days ago #43918

  • service300
  • service300's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 1
Hi together,

i`am new to RSForm and i would create a Checkbox Group from Database articles and 1 custom field.

The result must be look as an valid checkbox group format like:

article_title-value_of_customfield|Article Title ([p+value_of_customfield])

How can i solve this ?
The administrator has disabled public write access.

[solved] How to debug php code snippet 3 weeks 3 days ago #43920

  • service300
  • service300's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 1
okay around 24hours later i have a solution based on an older post.

www.rsjoomla.com/forum/37-rsform-pro/310...ult-value.html#42766

The following Code generates an array with articles information from an specific article category and its associated article custom fields

The last foreach loop generates, in my case an useable return for an checkbox group with calculating paramater
//<code>
// Variablen setzen
$categorie_ID = 19;
 
// Holen Sie sich die Datenbankverbindung
use Joomla\CMS\Factory;
$db = Factory::getDbo();
 
// Holen Sie sich alle benutzerdefinierten Felder
$query = $db->getQuery(true)
    ->select(array('f.id', 'f.name', 'f.title', 'f.type'))
    ->from($db->quoteName('#__fields', 'f'))
    ->where($db->quoteName('f.state') . ' = 1');
 
$db->setQuery($query);
$fields = $db->loadObjectList();
 
// Erstellen Sie eine dynamische Abfrage, um Artikel und ihre benutzerdefinierten Felder abzurufen
$query = $db->getQuery(true)
    ->select(array(
        'c.id AS article_id',
        'c.title AS article_title',
        'c.introtext AS article_introtext',
        'c.fulltext AS article_fulltext',
        'c.state AS article_state',
        'c.created AS article_created',
        'cat.title AS category_title'
    ))
    ->from($db->quoteName('#__content', 'c'))
    ->leftJoin($db->quoteName('#__categories', 'cat') . ' ON ' . $db->quoteName('c.catid') . ' = ' . $db->quoteName('cat.id'))
    ->where($db->quoteName('c.state') . ' = 1 AND' . $db->quoteName('c.catid') . ' = ' . $categorie_ID)
    ->order($db->quoteName('c.created') . ' ASC')
    ->group($db->quoteName('c.id'));
 
// Fügen Sie die benutzerdefinierten Feldwerte zur Abfrage hinzu
foreach ($fields as $field) {
    $query->select($db->quoteName('fv' . $field->id . '.value', 'field_' . $field->id))
          ->leftJoin($db->quoteName('#__fields_values', 'fv' . $field->id) . ' ON ' . $db->quoteName('c.id') . ' = ' . $db->quoteName('fv' . $field->id . '.item_id') . ' AND ' . $db->quoteName('fv' . $field->id . '.field_id') . ' = ' . $db->quote($field->id));
}
 
// Setzen Sie die Abfrage und holen Sie die Ergebnisse
$db->setQuery($query);
$results = $db->loadObjectList();
 
$items = array();
foreach ($results as $result) {
    $preis = (!empty($result->field_3)) ? $result->field_3 : "0,00";
    $items[] = $result->article_title.'|'.$result->article_title.' ('.$result->field_3 .' €)[p+'.str_replace(",", ".", $result->field_3).']';
}
 
return implode("\n", $items);
//</code>

The result in the front end looks like
Last Edit: 3 weeks 3 days ago by service300.
The administrator has disabled public write access.
The following user(s) said Thank You: gregs
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!