static function getCompanies()
{
$options = array();
$options[] = JHtml::_('select.option', 0, 'Select a Company');
$db = JFactory::getDBO();
$query = $db->getQuery(true)->select('id, name')->from('#__fleet_entity as h')->where('h.entity_type=2');
// if user is at company level
if ($GLOBALS['user_companies']) {
$query = $query->where("id in (" . implode(',', $GLOBALS['user_companies']) . ")");
} elseif ($GLOBALS['user_groups']) {
$ctrl = new JFormFieldSearchGroup();
$userCompany = $ctrl->getCompany($GLOBALS['user_groups']);
$companyEntityId = $userCompany[0]->value;
$query = $query->where('h.id=' . $companyEntityId);
}
$db->setQuery((string) $query);
// echo "kelvin_com3: ".$userCompany[0]->value;
// echo (string)$query;
$companies = $db->loadObjectList();
if ($companies) {
if (sizeof($companies) == 1) {
$options = array();
}
foreach ($companies as $company) {
$options[] = JHtml::_('select.option', $company->id, $company->name);
}
}
return $options;
}
function display($tpl = null)
{
$task = JRequest::getCmd('task', NULL);
$cmd = JRequest::getCmd('val', NULL);
$select = JRequest::getInt('select', 0);
switch ($task) {
case 'vehicle':
$groups = JFormFieldSelectGroup::getVehicles($cmd);
$output = '';
$select = 1;
foreach ($groups as $group) {
if ($cmd && $group->value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
case 'group':
$groups = JFormFieldSearchGroup::getGroups($cmd);
$output = '';
foreach ($groups as $group) {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
$data = $output;
break;
case 'vgroup':
$groups = JFormFieldSearchGroup::getGroup($cmd);
$output = '';
$select = 1;
foreach ($groups as $group) {
if ($cmd && $group->value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
case 'select_driver':
$groups = JFormFieldSelectGroup::getDriver($cmd);
$output = '';
$select = 1;
foreach ($groups as $group) {
if ($cmd && $group->value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
case 'company':
$groups = JFormFieldSearchGroup::getCompany($cmd);
$output = '';
$select = 1;
foreach ($groups as $group) {
if ($cmd && $group->value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
default:
break;
}
$document =& JFactory::getDocument();
$document->setMimeEncoding('application/json');
echo json_encode($data);
return false;
}
function display($tpl = null)
{
$task = JRequest::getCmd('task', NULL);
$cmd = JRequest::getCmd('val', NULL);
$cpval = JRequest::getCmd('cpval', NULL);
$val = JRequest::getCmd('cval', NULL);
switch ($task) {
case 'vehicle':
$groups = JFormFieldSearchGroup::getVehicles($cmd);
$output = '';
$select = 1;
if (!$cmd) {
$output .= '<option value="0">Select Company and Group</option>';
} else {
foreach ($groups as $group) {
if ($val && $group->value == $val && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
}
$data = $output;
break;
case 'driver':
$groups = JFormFieldSearchGroup::getDrivers($cmd);
$output = '';
$select = 1;
if (!$cmd) {
$output .= '<option value="0">Select Company and Group</option>';
} else {
foreach ($groups as $group) {
if ($val && $group->value == $val && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
}
$data = $output;
break;
case 'group':
$groups = JFormFieldSearchGroup::getGroups($cmd);
$output = '';
foreach ($groups as $group) {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
$data = $output;
break;
case 'dgroup':
$groups = JFormFieldSearchGroup::getDriverGroup($cmd);
$output = '';
$select = 1;
foreach ($groups as $group) {
if ($cmd && $group->value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
case 'vgroup':
$groups = JFormFieldSearchGroup::getVehicleGroup($cmd);
$output = '';
$select = 1;
foreach ($groups as $group) {
if ($cmd && $group->value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
case 'company':
$groups = JFormFieldSearchGroup::getCompany($cmd);
$output = '';
$select = 1;
$db =& JFactory::getDBO();
$query = 'select parent_entity_id from #__fleet_entity where id=' . $cmd;
$db->setQuery($query);
$value = $db->loadResult();
foreach ($groups as $group) {
if ($cmd && $group->value == $value && $select) {
$output .= '<option value="' . $group->value . '" selected>' . $group->text . '</option>';
$select = 0;
} else {
$output .= '<option value="' . $group->value . '">' . $group->text . '</option>';
}
}
$data = $output;
break;
default:
break;
}
$document =& JFactory::getDocument();
$document->setMimeEncoding('application/json');
echo json_encode($data);
return false;
}
