For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
See Announcement
We are still working on the Joomla update.
Hi Hugh.
Yes, literally 2 Fabrik lists on 1 page. Ya, the picklists in each list can have identical options.
Any suggestions, Hugh?
Thanks in advance.
include 'cli/resources_scheduled.php';
foreach ($arraylistScheduled as $arrayrow) {
if ($arrayrow['fid_project']=={bw_projects___id}) {
$fid_employee = $arrayrow['fid_employee'];
$resourcename = $arrayrow['name'];
return '<li id="'.$fid_employee.'" class="ui-state-default" style="list-style-type:none;padding: 5px 10px;cursor: pointer;border-radius: 5px;margin: 10px 10px 0 0;background: #3267fe;color:#ffffff;display: inline-block;-webkit-box-shadow: 0 10px 6px -6px #777;-moz-box-shadow: 0 10px 6px -6px #777;box-shadow: 0 10px 6px -6px #777;">'.$resourcename.'</li>';
}
}
<?php
define( '_JEXEC', 1 ); //This will define the _JEXEC constant that will allow you to access the rest of the Joomla framework
$joomlaPath = dirname(__FILE__)."/.."; //The only part you have to change. Make sure the relative part points to your Joomla root
define('JPATH_BASE', $joomlaPath);
require_once( JPATH_BASE.'/includes/defines.php' );
require_once( JPATH_BASE.'/includes/framework.php' );
// Instantiate the application.
$app = JFactory::getApplication('site');
// Initialise the application.
$app->initialise();
// Now you can use all classes of Joomla
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
$query->select('fid_employee');
$query->select('name');
$query->select('fid_project');
$query->select('scheduled_date');
$query->from($db->quoteName('bw_scheduledlabordates'));
$query->where($db->quoteName('scheduled_date').' = CURDATE()');
// Reset the query using our newly populated query object.
$db->setQuery($query);
$arraylistScheduled = $db->loadAssocList('scheduled_date');
//print_r($arraylistScheduled); //Uncomment this row for testing purposes
?>
var_dump((string) $query);exit;
var_dump($query);exit;