예제 #1
0
 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;
 }
예제 #2
0
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchcompany.php';
$ctrl = new JFormFieldSearchCompany();
foreach ($ctrl->getCompanies() as $option) {
    $selected = '';
    if ($option->value == $this->company) {
        $selected = ' selected';
    }
    echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
}
?>
</select>

<select name="group" id="group">
<?php 
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchgroup.php';
$ctrl = new JFormFieldSearchGroup();
$company = JRequest::getInt('company', 0);
foreach ($ctrl->getGroups($company) as $option) {
    $selected = '';
    if ($option->value == $this->group) {
        $selected = ' selected';
    }
    echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
}
?>
</select>

<script>
    var processCompany = true;
    function groupChange() {
        var val = jQuery('#group').val();
예제 #3
0
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchcompany.php';
$ctrl = new JFormFieldSearchCompany();
foreach ($ctrl->getCompanies() as $option) {
    $selected = '';
    if ($option->value == $this->company) {
        $selected = ' selected';
    }
    echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
}
?>
</select>

<select name="group" id="group">
<?php 
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchgroup.php';
$ctrl = new JFormFieldSearchGroup();
foreach ($ctrl->getGroups() as $option) {
    $selected = '';
    if ($option->value == $this->group) {
        $selected = ' selected';
    }
    echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
}
?>
</select>
<button type="submit" id="update" class="button" onclick="jQuery('#task').val('');"><?php 
echo JText::_('Update');
?>
</button>

<script>
<?php

// No direct access to this file
defined('_JEXEC') or die('Restricted Access');
include JPATH_COMPONENT . DS . 'models' . DS . 'group_controls.php';
?>

<select name="vehicle" id="vehicle">
<?php 
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchgroup.php';
$ctrl = new JFormFieldSearchGroup();
$group = JRequest::getInt('group', 0);
if (!$group) {
    echo '<option value="0">Select Company and Group</option>';
} else {
    foreach ($ctrl->getVehicles($group) as $option) {
        $selected = '';
        if ($option->value == $this->vehicle) {
            $selected = ' selected';
        }
        echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
    }
}
?>
</select>

<script>
    function vehicleChange() {
        var val = jQuery('#vehicle').val();
        if (val != "0" && val != undefined) {
            url = "<?php 
<?php

// No direct access to this file
defined('_JEXEC') or die('Restricted Access');
include JPATH_COMPONENT . DS . 'models' . DS . 'search_controls.php';
?>

<select name="driver" id="driver">
<?php 
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchgroup.php';
$ctrl = new JFormFieldSearchGroup();
$group = JRequest::getInt('group', 0);
if (!$group) {
    echo '<option value="0">Select Company and Group</option>';
} else {
    foreach ($ctrl->getDrivers($group) as $option) {
        $selected = '';
        if ($option->value == $this->driver) {
            $selected = ' selected="selected"';
        }
        echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
    }
}
?>
</select>

<script>
    var driverChanged = 0;
    function driverChange() {
        var val = jQuery('#driver').val();
        var trend = jQuery('#trend').val();
예제 #6
0
 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;
 }
예제 #7
0
 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;
 }
<?php

// No direct access to this file
defined('_JEXEC') or die('Restricted Access');
include JPATH_COMPONENT . DS . 'models' . DS . 'group_controls.php';
?>

<select name="vehicle" id="vehicle">
<?php 
require_once JPATH_COMPONENT . DS . 'models' . DS . 'fields' . DS . 'searchgroup.php';
$ctrl = new JFormFieldSearchGroup();
foreach ($ctrl->getVehicles() as $option) {
    $selected = '';
    if ($option->value == $this->vehicle) {
        $selected = ' selected';
    }
    echo '<option value="' . $option->value . '"' . $selected . '>' . $option->text . '</option>';
}
?>
</select>

<script>
    function vehicleChange() {
        var val = jQuery('#vehicle').val();
        if (val != "0") {
            url = "<?php 
echo JRoute::_($this->getRoute() . '&layout=json&format=raw&task=vgroup&val=');
?>
"+val;
            jQuery.getJSON(url, function(data) {
                jQuery('#company').html(data);