public function __construct()
 {
     parent::__construct();
     self::process_booking_unauthorized_exceptions();
     $this->bo = CreateObject('booking.boasync_settings');
     self::set_active_menu('booking::settings::async_settings');
 }
 public function get_db()
 {
     if ($this->db && is_object($this->db)) {
         return $this->db;
     }
     $config = CreateObject('phpgwapi.config', 'rental');
     $config->read();
     if (!$config->config_data['external_db_host'] || !$this->ping($config->config_data['external_db_host'])) {
         $message = "Database server {$config->config_data['external_db_host']} is not accessible";
         phpgwapi_cache::message_set($message, 'error');
         return false;
     }
     $db = createObject('phpgwapi.db', null, null, true);
     $db->debug = !!$config->config_data['external_db_debug'];
     $db->Host = $config->config_data['external_db_host'];
     $db->Port = $config->config_data['external_db_port'];
     $db->Type = $config->config_data['external_db_type'];
     $db->Database = $config->config_data['external_db_name'];
     $db->User = $config->config_data['external_db_user'];
     $db->Password = $config->config_data['external_db_password'];
     try {
         $db->connect();
         $this->connected = true;
     } catch (Exception $e) {
         $status = lang('unable_to_connect_to_database');
     }
     $this->db = $db;
     return $db;
 }
 /**
  * Get a static reference to the storage object associated with this model object
  *
  * @return controller_socontrol_group the storage object
  */
 public static function get_instance()
 {
     if (self::$so == null) {
         self::$so = CreateObject('controller.socontrol_group_list');
     }
     return self::$so;
 }
 public function __construct()
 {
     parent::__construct();
     $this->bo = CreateObject('booking.bodocument_view');
     $this->url_prefix = 'booking.uidocument_view';
     $this->module = 'booking';
 }
 function ShowPage($sPage)
 {
     global $g_oSec, $dcl_info;
     commonHeader();
     if (($productid = DCL_Sanitize::ToInt($_REQUEST['id'])) === null) {
         trigger_error('Data sanitize failed.');
         return;
     }
     if (!$g_oSec->HasPerm(DCL_ENTITY_PRODUCT, DCL_PERM_VIEW, $productid)) {
         return PrintPermissionDenied();
     }
     $this->oProduct =& CreateObject('dcl.dbProducts');
     if ($this->oProduct->Load($productid) == -1) {
         trigger_error('Could not find a product with an id of ' . $productid, E_USER_ERROR);
         return;
     }
     $this->oSmarty->assign('VAL_ID', $this->oProduct->id);
     $this->oSmarty->assign('VAL_NAME', $this->oProduct->name);
     $this->oSmarty->assign('PERM_VIEWWO', $g_oSec->HasPerm(DCL_ENTITY_WORKORDER, DCL_PERM_VIEW));
     $this->oSmarty->assign('PERM_VIEWTCK', $g_oSec->HasPerm(DCL_ENTITY_TICKET, DCL_PERM_VIEW));
     $this->oSmarty->assign('PERM_WIKI', $dcl_info['DCL_WIKI_ENABLED'] == 'Y' && $g_oSec->HasPerm(DCL_ENTITY_PRODUCT, DCL_PERM_VIEWWIKI));
     $this->oSmarty->assign('PERM_EDIT', $g_oSec->HasPerm(DCL_ENTITY_PRODUCT, DCL_PERM_MODIFY));
     $this->oSmarty->assign('PERM_DELETE', $g_oSec->HasPerm(DCL_ENTITY_PRODUCT, DCL_PERM_DELETE));
     $this->oSmarty->assign('PERM_VERSIONS', $dcl_info['DCL_BUILD_MANAGER_ENABLED'] == 'Y' && $this->oProduct->is_versioned == 'Y');
     SmartyDisplay($this->oSmarty, $sPage);
 }
 function boimagemagick()
 {
     //FIXME check version and leave without doing nothing when lower then 5.4.9
     $this->common = CreateObject('jinn.bocommon');
     $this->current_config = $this->common->get_config();
     $this->imagemagickdir = $this->current_config['imagemagickdir'];
 }
 function uimanagefields()
 {
     $GLOBALS['phpgw']->nextmatches = CreateObject('phpgwapi.nextmatchs');
     $this->bo = CreateObject('registration.bomanagefields');
     $this->bo->check_admin();
     $this->base_url = $this->bo->base_url;
 }
 function __construct($session = False)
 {
     $this->so = CreateObject('admin.soserver');
     if ($session) {
         $this->read_sessiondata();
         $this->use_session = True;
     }
     $start = $GLOBALS['start'];
     $query = $GLOBALS['query'];
     $sort = $GLOBALS['sort'];
     $order = $GLOBALS['order'];
     if (!empty($start) || $start == '0' || $start == 0) {
         if ($this->debug) {
             echo '<br>overriding start: "' . $this->start . '" now "' . $start . '"';
         }
         $this->start = $start;
     }
     if (empty($query) && !empty($this->query) || !empty($query)) {
         $this->query = $query;
     }
     if ($limit) {
         $this->limit = $limit;
     }
     if (isset($sort)) {
         $this->sort = $sort;
     }
     if (isset($order)) {
         $this->order = $order;
     }
 }
 function ListVersions()
 {
     // FIXME: application/x-javascript for Opera
     header('Content-Type: application/json');
     $product_id = @DCL_Sanitize::ToInt($_REQUEST['product_id']);
     if ($product_id === null) {
         exit;
     }
     $oDB = CreateObject('dcl.dbProductVersion');
     $aOptions = $oDB->GetOptions('product_version_id', 'product_version_text', 'active', isset($_REQUEST['active']) && $_REQUEST['active'] == 'Y', '', "product_id={$product_id}");
     $bFirst = true;
     echo '{';
     echo '"totalRecords":', count($aOptions), ',';
     echo '"data":[';
     for ($i = 0; $i < count($aOptions); $i++) {
         if ($i > 0) {
             echo ',';
         }
         echo '{';
         echo '"id":', $aOptions[$i]['product_version_id'], ',';
         echo '"text":"', str_replace('"', '\\"', str_replace("\\", "\\\\", $aOptions[$i]['product_version_text'])), '"';
         echo '}';
     }
     echo ']}';
     exit;
 }
Esempio n. 10
0
 function __construct($session = false)
 {
     $GLOBALS['phpgw_info']['flags']['currentapp'] = 'property';
     $this->config = CreateObject('admin.soconfig', $GLOBALS['phpgw']->locations->get_id('property', '.invoice'));
     if ($session) {
         $this->read_sessiondata();
         $this->use_session = true;
     }
     $start = phpgw::get_var('start', 'int', 'REQUEST', 0);
     $query = phpgw::get_var('query');
     $sort = phpgw::get_var('sort');
     $order = phpgw::get_var('order');
     $filter = phpgw::get_var('filter', 'int');
     $cat_id = phpgw::get_var('cat_id', 'int');
     if ($start || $start == 0) {
         $this->start = $start;
     }
     if ($query) {
         $this->query = $query;
     }
     if ($sort) {
         $this->sort = $sort;
     }
     if ($order) {
         $this->order = $order;
     }
     if ($filter) {
         $this->filter = $filter;
     }
     $this->cat_id = $cat_id;
 }
 function boadmin()
 {
     $this->common = CreateObject('jinn.bocommon');
     $this->so = CreateObject('jinn.sojinn');
     $this->current_config = $this->common->get_config();
     $this->read_sessiondata();
     $this->use_session = True;
     $_form = $GLOBALS['HTTP_POST_VARS']['form'] ? $GLOBALS['HTTP_POST_VARS']['form'] : $GLOBALS['HTTP_GET_VARS']['form'];
     $_action = $GLOBALS['HTTP_POST_VARS']['action'] ? $GLOBALS['HTTP_POST_VARS']['action'] : $GLOBALS['HTTP_GET_VARS']['action'];
     $_site_id = $GLOBALS['HTTP_POST_VARS']['site_id'] ? $GLOBALS['HTTP_POST_VARS']['site_id'] : $GLOBALS['HTTP_GET_VARS']['site_id'];
     $_site_object_id = $GLOBALS['HTTP_POST_VARS']['site_object_id'] ? $GLOBALS['HTTP_POST_VARS']['site_object_id'] : $GLOBALS['HTTP_GET_VARS']['site_object_id'];
     $_where_key = $GLOBALS['HTTP_POST_VARS']['where_key'] ? $GLOBALS['HTTP_POST_VARS']['where_key'] : $GLOBALS['HTTP_GET_VARS']['where_key'];
     $_where_value = $GLOBALS['HTTP_POST_VARS']['where_value'] ? $GLOBALS['HTTP_POST_VARS']['where_value'] : $GLOBALS['HTTP_GET_VARS']['where_value'];
     if (!empty($_where_key)) {
         $this->where_key = $_where_key;
     }
     if (!empty($_where_value)) {
         $this->where_value = $_where_value;
     }
     if (!empty($_action) && empty($this->action) || !empty($_action)) {
         $this->action = $_action;
     }
     if ($_form == 'main_menu' || !empty($site_id)) {
         $this->site_id = $_site_id;
     }
     if ($_form == 'main_menu' || !empty($site_object_id)) {
         $this->site_object_id = $_site_object_id;
     }
     // get array of site and object
     $this->site = $this->so->get_site_values($this->site_id);
     if ($this->site_object_id) {
         $this->site_object = $this->so->get_object_values($this->site_object_id);
     }
     $this->include_plugins();
 }
Esempio n. 12
0
 public function __construct($coverageid = "")
 {
     if ($coverageid == "" or $coverageid == 0) {
         return false;
     }
     // Check in the cache
     if (!isset($GLOBALS['__freemed']['cache']['coverage'][$coverageid])) {
         // Get record
         $this->local_record = $GLOBALS['sql']->get_link('coverage', $coverageid);
         // Cache it
         $GLOBALS['__freemed']['cache']['coverage'][$coverageid] = $this->local_record;
     } else {
         // Retrieve from cache
         $this->local_record = $GLOBALS['__freemed']['cache']['coverage'][$coverageid];
     }
     $this->covpatgrpno = $this->local_record['covpatgrpno'];
     $this->covpatinsno = $this->local_record['covpatinsno'];
     $this->covstatus = $this->local_record['covstatus'];
     $this->covtype = $this->local_record['covtype'];
     $this->coveffdt = $this->local_record['coveffdt'];
     $this->covinsco = CreateObject('org.freemedsoftware.core.InsuranceCompany', $this->local_record['covinsco']);
     $this->covreldep = $this->local_record['covrel'];
     $this->id = $this->local_record['id'];
     $this->covpatient = $this->local_record['covpatient'];
     if ($this->covreldep != "S") {
         // you pass this to the guarantor class
         $this->covdep = $this->id;
     } else {
         $this->covdep = 0;
     }
 }
 public function addfiles()
 {
     $GLOBALS['phpgw_info']['flags']['xslt_app'] = false;
     $GLOBALS['phpgw_info']['flags']['noframework'] = true;
     $GLOBALS['phpgw_info']['flags']['nofooter'] = true;
     $acl =& $GLOBALS['phpgw']->acl;
     $acl_add = $acl->check($this->acl_location, PHPGW_ACL_ADD, 'manual');
     $acl_edit = $acl->check($this->acl_location, PHPGW_ACL_EDIT, 'manual');
     $cat_id = phpgw::get_var('id', 'int');
     $check = phpgw::get_var('check', 'bool');
     $fileuploader = CreateObject('property.fileuploader');
     if (!$acl_add && !$acl_edit) {
         $GLOBALS['phpgw']->common->phpgw_exit();
     }
     if (!$cat_id) {
         $GLOBALS['phpgw']->common->phpgw_exit();
     }
     $test = false;
     if ($test) {
         if (!empty($_FILES)) {
             $tempFile = $_FILES['Filedata']['tmp_name'];
             $targetPath = "{$GLOBALS['phpgw_info']['server']['temp_dir']}/";
             $targetFile = str_replace('//', '/', $targetPath) . $_FILES['Filedata']['name'];
             move_uploaded_file($tempFile, $targetFile);
             echo str_replace($GLOBALS['phpgw_info']['server']['temp_dir'], '', $targetFile);
         }
         $GLOBALS['phpgw']->common->phpgw_exit();
     }
     if ($check) {
         $fileuploader->check($cat_id, '/manual');
     } else {
         $fileuploader->upload($cat_id, '/manual');
     }
 }
 function restoreSessionData()
 {
     $arrayFunctions =& CreateObject('phpgwapi.arrayfunctions');
     $this->sessionData = $GLOBALS['phpgw']->session->appsession('filter_session_data');
     // sort the filter list
     $unsortedFilter = $this->sofilter->restoreFilter();
     // save the quicksearchfilter
     // must always have id=0
     if (is_array($unsortedFilter[0])) {
         $quickSearchFilter[0] = $unsortedFilter[0];
         unset($unsortedFilter[0]);
     } else {
         $quickSearchFilter[0] = array('filterName' => lang('quicksearch'));
     }
     // _debug_array($this->sessionData['filter']);
     // the first one is always the quicksearch filter
     if (count($unsortedFilter) > 0) {
         $sortedFilter = $arrayFunctions->arfsort($unsortedFilter, array('filterName'));
         $sortedFilter = array_merge($quickSearchFilter, $sortedFilter);
     } else {
         $sortedFilter = $quickSearchFilter;
     }
     #_debug_array($sortedFilter);
     $this->sessionData['filter'] = $sortedFilter;
 }
 function boNoteType()
 {
     parent::boAdminObject();
     $this->oDB =& CreateObject('dcl.dbNoteType');
     $this->sKeyField = 'note_type_id';
     $this->Entity = DCL_ENTITY_NOTETYPE;
 }
 function __construct()
 {
     $GLOBALS['phpgw']->nextmatchs = CreateObject('phpgwapi.nextmatchs');
     $this->template = $GLOBALS['phpgw']->template;
     $this->theme = $GLOBALS['phpgw_info']['theme'];
     $this->bo = CreateObject('todo.bopreferences');
 }
Esempio n. 17
0
 public function get($id)
 {
     global $dbconfig;
     $phuong = NULL;
     try {
         $sql = "select * from " . table_prefix("phuong") . " where id='" . $dbconfig->sqlQuote($id) . "'";
         $dbconfig->open();
         $dbconfig->query($sql);
         if ($dbconfig->num_row() != 0) {
             $arr = $dbconfig->fetch_array();
             $arr = $arr[0];
             $phuong = CreateObject("Model_Entity_Phuong");
             $phuong->id = $arr["id"];
             $phuong->name = $arr["name"];
             $phuong->order = $arr["order"];
             $phuong->updated = $arr["updated"];
             $phuong->status = $arr["status"];
         } else {
             $phuong = NULL;
         }
         $dbconfig->close();
         return $phuong;
     } catch (MyException $ex) {
         $ex->__toString();
         return $phuong;
     }
 }
 function boSccsXref()
 {
     parent::boAdminObject();
     $this->oDB =& CreateObject('dcl.dbSccsXref');
     $this->sKeyField = 'dcl_sccs_xref_id';
     $this->Entity = DCL_ENTITY_CHANGELOG;
 }
 function edit()
 {
     if (!$GLOBALS['phpgw']->acl->check('run', 1, 'admin')) {
         $GLOBALS['phpgw']->redirect($GLOBALS['phpgw']->link('/admin/index.php'));
     }
     $GLOBALS['phpgw']->js->add('src', './prototype/plugins/jquery/jquery.min.js');
     $GLOBALS['phpgw']->js->add('src', './prototype/plugins/jquery/jquery-ui.min.js');
     $GLOBALS['phpgw']->js->validate_file('jscode', 'connector', 'expressoAdmin1_2');
     $GLOBALS['phpgw']->js->validate_file('jscode', 'lang', 'expressoAdmin1_2');
     $GLOBALS['phpgw']->js->validate_file('jscode', 'messenger_config', 'expressoAdmin1_2');
     $GLOBALS['phpgw']->css->validate_file('./prototype/plugins/jquery/jquery-ui.css');
     $GLOBALS['phpgw']->css->validate_file('expressoAdmin1_2/templates/default/css/custom.css');
     unset($GLOBALS['phpgw_info']['flags']['nonavbar']);
     $GLOBALS['phpgw_info']['flags']['app_header'] = $GLOBALS['phpgw_info']['apps']['expressoAdmin1_2']['title'] . ' - ' . lang('Expresso Messenger');
     $GLOBALS['phpgw']->common->phpgw_header();
     $p = CreateObject('phpgwapi.Template', PHPGW_APP_TPL);
     $p->set_file(array('messenger' => 'messenger.tpl'));
     $p->set_block('messenger', 'body', 'body');
     $p->set_block('messenger', 'row_opts', 'row_opts');
     $p->set_var(array('lang_title' => lang('Expresso Messenger Settings'), 'lang_save' => lang('Save'), 'lang_cancel' => lang('Cancel'), 'lang_yes' => lang('Yes'), 'lang_no' => lang('No'), 'lang_enabled' => lang('Enabled'), 'lang_disabled' => lang('Disabled'), 'lang_messenger_enabled' => lang('Enable Messenger'), 'input_name_enabled' => Messenger::CONFIG_ENABLED, 'input_value_enabled' => $this->_so->_im->enabled ? 'checked' : '', 'lang_jabber_domain' => lang('Domain Jabber'), 'input_name_domain' => Messenger::CONFIG_DOMAIN, 'input_value_domain' => $this->_so->_im->domain, 'lang_url' => lang('URL for direct connection'), 'lang_url_ex' => 'Ex.: http://server_jabber:5280/http-bind', 'input_name_url' => Messenger::CONFIG_URL, 'input_value_url' => $this->_so->_im->url, 'lang_pubkey' => lang('Public Key'), 'lang_pubkey_ex' => lang('Encrypts the password before sending to jabber server') . '. ' . lang('Store in PEM format: base64 encoded, closed between "%1" and "%2"', '-----BEGIN PUBLIC KEY-----', '-----END PUBLIC KEY-----'), 'input_name_pubkey' => Messenger::CONFIG_PUBKEY, 'input_value_pubkey' => $this->_so->_im->pubkey, 'lang_group_enabled' => lang('Enable filter by group'), 'input_name_group_enabled' => Messenger::CONFIG_GROUPENABLED, 'input_value_group_enabled' => $this->_so->_im->groupenabled ? 'checked' : '', 'lang_group_options' => lang('Group filter options'), 'input_class_group_options' => $this->_so->_im->groupenabled ? '' : 'ui-state-disabled', 'lang_group_base' => lang('Base DN for the directory'), 'input_name_group_base' => Messenger::CONFIG_GROUPBASE, 'lang_group_filter' => lang('Search filter for user groups'), 'lang_group_filter_ex' => 'Ex.: (&(objectClass=posixGroup)(cn=group-jabber-*)(memberUid=%u))', 'input_name_group_filter' => Messenger::CONFIG_GROUPFILTER, 'input_value_group_filter' => $this->_so->_im->groupfilter));
     foreach ($this->_so->_im->listConfigFunc('GROUPBASE') as $key => $value) {
         $p->set_var(array('option_value' => $key, 'option_enabled' => $this->_so->_im->groupbase === $key ? ' selected' : '', 'option_text' => lang($key)));
         $p->fp('opts_groupbase', 'row_opts', True);
     }
     $p->pparse('out', 'body');
 }
 function __construct()
 {
     parent::__construct();
     $object_type = substr(get_class($this), 21);
     $this->so = CreateObject(sprintf('booking.sopermission_%s', $object_type));
     $this->object_bo = CreateObject(sprintf('booking.bo%s', $object_type));
 }
 function boWorkOrderType()
 {
     $this->oDB =& CreateObject('dcl.dbWorkOrderType');
     $this->sKeyField = 'wo_type_id';
     $this->sDescField = 'type_name';
     $this->Entity = DCL_ENTITY_WORKORDERTYPE;
 }
 function ACL_BO()
 {
     $this->logged_in_user = $GLOBALS['phpgw_info']['user']['account_id'];
     $this->acct = CreateObject('phpgwapi.accounts', $this->logged_in_user);
     $this->acl = CreateObject('phpgwapi.acl', $this->logged_in_user);
     $this->acl_so = CreateObject('sitemgr.ACL_SO');
 }
 function bopreferences()
 {
     $this->config = CreateObject('phpgwapi.config', 'felamimail');
     $this->config->read_repository();
     $this->profileID = $this->config->config_data['profileID'];
     $this->boemailadmin = CreateObject('emailadmin.bo');
 }
 public function __construct()
 {
     $this->config = CreateObject('phpgwapi.config', 'calendar');
     $this->config->read();
     $this->fields =& $this->config->config_data['fields'];
     if (!is_array($this->fields)) {
         $this->fields = array();
     }
     foreach ($this->fields as $field => $data) {
         if (!isset($this->stock_fields[$field]) && $field[0] != '#') {
             unset($this->fields[$field]);
             $this->fields['#' . $field] = $data;
         }
     }
     foreach ($this->stock_fields as $field => $data) {
         if (!is_array($data)) {
             $data = array('label' => $data);
         }
         if (!isset($this->fields[$field])) {
             $this->fields[$field] = array('name' => $field, 'title' => isset($data['title']) ? $data['title'] : '', 'disabled' => isset($data['disabled']) ? $data['disabled'] : '');
         }
         $this->fields[$field]['label'] = isset($data['label']) ? $data['label'] : '';
         $this->fields[$field]['length'] = isset($data['length']) ? $data['length'] : '';
         $this->fields[$field]['shown'] = isset($data['shown']) ? $data['shown'] : '';
     }
 }
 public function __construct()
 {
     parent::__construct();
     $this->so = createObject('logistic.sorequirement_resource_allocation');
     $this->so_activity = createObject('logistic.soactivity');
     $this->so_requirement = createObject('logistic.sorequirement');
     $this->so_requirement_value = CreateObject('logistic.sorequirement_value');
     $this->bo = CreateObject('property.bolocation', true);
     $this->bocommon =& $this->bo->bocommon;
     $this->type_id = $this->bo->type_id;
     $this->start = $this->bo->start;
     $this->query = $this->bo->query;
     $this->sort = $this->bo->sort;
     $this->order = $this->bo->order;
     $this->filter = $this->bo->filter;
     $this->cat_id = $this->bo->cat_id;
     $this->part_of_town_id = $this->bo->part_of_town_id;
     $this->district_id = $this->bo->district_id;
     $this->status = $this->bo->status;
     $this->allrows = $this->bo->allrows;
     $this->lookup = $this->bo->lookup;
     $this->location_code = $this->bo->location_code;
     $this->read = $GLOBALS['phpgw']->acl->check('.activity', PHPGW_ACL_READ, 'logistic');
     //1
     $this->add = $GLOBALS['phpgw']->acl->check('.activity', PHPGW_ACL_ADD, 'logistic');
     //2
     $this->edit = $GLOBALS['phpgw']->acl->check('.activity', PHPGW_ACL_EDIT, 'logistic');
     //4
     $this->delete = $GLOBALS['phpgw']->acl->check('.activity', PHPGW_ACL_DELETE, 'logistic');
     //8
     $this->manage = $GLOBALS['phpgw']->acl->check('.activity', 16, 'logistic');
     //16
 }
function smarty_function_dcl_select_status($params, &$smarty)
{
    if (!isset($params['name'])) {
        $params['name'] = 'status';
    }
    if (!isset($params['id'])) {
        $params['id'] = $params['name'];
    }
    if (!isset($params['default'])) {
        $params['default'] = '';
    }
    $params['active'] = !isset($params['active']) || $params['active'] == true ? 'Y' : 'N';
    if (!isset($params['setid'])) {
        $params['setid'] = 0;
    }
    if (!isset($params['size'])) {
        $params['size'] = 1;
    }
    $sFilter = '';
    if ($params['active'] == 'Y') {
        $sFilter = "active = 'Y'";
    }
    $oSelect =& CreateObject('dcl.htmlSelect');
    $oSelect->vDefault = $params['default'];
    $oSelect->sName = $params['name'];
    $oSelect->iSize = $params['size'];
    $oSelect->sZeroOption = STR_CMMN_SELECTONE;
    $oSelect->SetOptionsFromDb('statuses', 'id', 'name', $sFilter, 'name');
    if (isset($params['allowHideOrOnlyClosed']) && $params['allowHideOrOnlyClosed'] == 'Y') {
        $oSelect->AddOption('-1', STR_CMMN_HIDECLOSEDTYPES);
        $oSelect->AddOption('-2', STR_CMMN_ONLYCLOSEDTYPES);
    }
    return $oSelect->GetHTML();
}
 function SetOptionsFromDb($table, $keyField, $valField, $filter = '', $order = '')
 {
     if ($this->oDB == NULL) {
         $this->oDB = new dclDB();
     }
     $sql = "select {$keyField}, {$valField} From {$table}";
     if ($filter != '') {
         $sql .= ' Where ' . $filter;
     }
     if ($order == '') {
         $sql .= " Order By {$valField}";
     } else {
         $sql .= ' Order By ' . $order;
     }
     $oDB = CreateObject('dcl.dbWorkorders');
     $oDB->Query($sql);
     while ($oDB->next_record()) {
         $this->t->set_var('VAL_VALUE', $oDB->f(0));
         $this->t->set_var('VAL_TEXT', $oDB->f(1));
         $bSelected = is_array($this->vDefault) && in_array($oDB->f(0), $this->vDefault) || !is_array($this->vDefault) && $this->vDefault == $oDB->f(0);
         if ($bSelected) {
             $this->t->parse('hSel', 'sel', true);
         } else {
             $this->t->parse('hAvail', 'avail', true);
         }
     }
 }
 public function index_json()
 {
     $this->db = $GLOBALS['phpgw']->db;
     $config = CreateObject('phpgwapi.config', 'booking');
     $config->read();
     #            if ($config->config_data['output_files'] == 'single')
     $export_files = $this->bo->read();
     array_walk($export_files["results"], array($this, "_add_links"), $this->module . ".uicompleted_reservation_export_file.show");
     foreach ($export_files["results"] as &$export_file) {
         $export_file['created_on'] = pretty_timestamp(substr($export_file['created_on'], 0, 19));
         $export_file['type'] = lang($export_file['type']);
         $export_file['download'] = array('label' => lang('Download'), 'href' => $this->link_to('download', array('id' => $export_file['id'])));
         if ($export_file['total_items'] > 0 and !empty($export_file['log_filename'])) {
             $export_file['log'] = array('label' => lang('log'), 'href' => $this->link_to('log', array('id' => $export_file['id'])));
         } else {
             $export_file['log'] = array('label' => ' ', 'href' => '#');
         }
         if ($export_file['total_items'] > 0 and $export_file['id'] > $config->config_data['invoice_last_id']) {
             $export_file['upload'] = array('label' => lang('Upload'), 'href' => $this->link_to('upload', array('id' => $export_file['id'])));
         } else {
             $export_file['upload'] = array('label' => ' ', 'href' => '#');
         }
         $sql = "SELECT account_lastname, account_firstname FROM phpgw_accounts WHERE account_lid = '" . $export_file['created_by_name'] . "'";
         $this->db->query($sql);
         while ($record = array_shift($this->db->resultSet)) {
             $export_file['created_by_name'] = $record['account_firstname'] . " " . $record['account_lastname'];
         }
     }
     $results = $this->yui_results($export_files);
     return $results;
 }
 function htmlPersonnelSelector()
 {
     $this->bMultiSelect = false;
     $this->oSmarty =& CreateSmarty();
     $this->oView =& CreateObject('dcl.boView');
     $this->oDB = new dclDB();
 }
 /**
  * Get a static reference to the storage object associated with this model object
  *
  * @return controller_soparty the storage object
  */
 public static function get_instance()
 {
     if (self::$so == null) {
         self::$so = CreateObject('logistic.soproject');
     }
     return self::$so;
 }