function show($orderBy = 'short') { global $dcl_info, $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_ORG, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } $oView = CreateObject('dcl.boView'); $oView->startrow = 0; $oView->numrows = 25; $filterActive = ''; if (isset($_REQUEST['filterActive'])) { $filterActive = $_REQUEST['filterActive']; } $oView->table = 'dcl_org'; $oView->title = 'Browse Organizations'; $oView->AddDef('columnhdrs', '', array('ID', 'Active', 'Name', 'Phone', 'Email', 'Internet')); $oView->AddDef('columns', '', array('org_id', 'active', 'name', 'dcl_org_phone.phone_number', 'dcl_org_email.email_addr', 'dcl_org_url.url_addr')); $oView->AddDef('order', '', array('name')); if ($filterActive == 'Y' || $filterActive == 'N') { $oView->AddDef('filter', 'active', "'{$filterActive}'"); } $oHtml = CreateObject('dcl.htmlOrgBrowse'); $oHtml->Render($oView); }
function view() { global $g_oSec; commonHeader(); if (($iID = @DCL_Sanitize::ToInt($_REQUEST['id'])) === null) { trigger_error('Data sanitize failed.'); return; } if (!$g_oSec->HasPerm(DCL_ENTITY_PRODUCT, DCL_PERM_VIEW, $iID)) { return PrintPermissionDenied(); } $which = isset($_REQUEST['which']) ? $_REQUEST['which'] : ''; if ($which != 'workorders' && $which != 'tickets' && $which != 'modules' && $which != 'release' && $which != 'build') { $which = null; } $versionid = null; if (isset($_REQUEST['versionid'])) { $versionid = @DCL_Sanitize::ToInt($_REQUEST['versionid']); } $obj =& CreateObject('dcl.htmlProductDetail'); if ($which !== null) { if ($versionid !== null) { $obj->Show($iID, $which, $versionid); } else { $obj->Show($iID, $which); } } else { $obj->Show($iID); } }
function show($orderBy = 'short') { global $dcl_info, $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_ROLE, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } $oView = CreateObject('dcl.boView'); $oView->startrow = 0; $oView->numrows = 25; $filterActive = ''; if (isset($_REQUEST['filterActive'])) { $filterActive = $_REQUEST['filterActive']; } $oView->table = 'dcl_role'; $oView->title = 'Browse Roles'; $oView->AddDef('columnhdrs', '', array('ID', 'Active', 'Role')); $oView->AddDef('columns', '', array('role_id', 'active', 'role_desc')); $oView->AddDef('order', '', array('role_desc')); if ($filterActive == 'Y' || $filterActive == 'N') { $oView->AddDef('filter', 'active', "'{$filterActive}'"); } $oHtml = CreateObject('dcl.htmlRoleBrowse'); $oHtml->Render($oView); }
function ShowEntryForm($obj = '') { global $dcl_info, $g_oSec; $isEdit = is_object($obj); if (!$g_oSec->HasPerm(DCL_ENTITY_PERSONNEL, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) { return PrintPermissionDenied(); } $Template =& CreateSmarty(); $Template->assign('IS_EDIT', $isEdit); $oUserRole = CreateObject('dcl.dbUserRole'); $oDept = CreateObject('dcl.htmlDepartments'); if ($isEdit) { $Template->assign('VAL_PERSONNELID', $obj->id); $Template->assign('VAL_ACTIVE', $obj->active); $Template->assign('VAL_SHORT', $obj->short); $Template->assign('VAL_REPORTTO', $obj->reportto); $Template->assign('VAL_DEPARTMENT', $obj->department); $Template->assign('Roles', $oUserRole->GetGlobalRoles($obj->id)); $oMeta =& CreateObject('dcl.DCL_MetadataDisplay'); $aContact =& $oMeta->GetContact($obj->contact_id); $Template->assign('VAL_CONTACTID', $obj->contact_id); $Template->assign('VAL_CONTACTNAME', $aContact['name']); } else { $Template->assign('VAL_ACTIVE', 'Y'); $Template->assign('VAL_REPORTTO', $GLOBALS['DCLID']); $Template->assign('VAL_DEPARTMENT', 0); $Template->assign('VAL_SHORT', ''); $Template->assign('Roles', $oUserRole->GetGlobalRoles()); } SmartyDisplay($Template, 'htmlPersonnelForm.tpl'); }
function ShowTopic($obj) { global $dcl_info, $g_oSec; if (!is_object($obj)) { trigger_error('[htmlFaqtopics::ShowTopic] ' . STR_FAQ_TOPICOBJECTNOTPASSED); return; } if (!$g_oSec->HasPerm(DCL_ENTITY_FAQ, DCL_PERM_VIEW, $obj->faqid)) { return PrintPermissionDenied(); } $objFaq = CreateObject('dcl.dbFaq'); if ($objFaq->Load($obj->faqid) == -1) { return; } $t =& CreateSmarty(); $t->assign('VAL_FAQID', $objFaq->faqid); $t->assign('VAL_FAQNAME', $objFaq->name); $t->assign('VAL_DESCRIPTION', $obj->description); $t->assign('VAL_TOPICID', $obj->f('topicid')); $t->assign('VAL_TOPICNAME', $obj->name); $t->assign('PERM_ADDQUESTION', $g_oSec->HasPerm(DCL_ENTITY_FAQQUESTION, DCL_PERM_ADD, $obj->faqid)); $t->assign('PERM_MODIFY', $g_oSec->HasPerm(DCL_ENTITY_FAQTOPIC, DCL_PERM_MODIFY)); $t->assign('PERM_DELETE', $g_oSec->HasPerm(DCL_ENTITY_FAQTOPIC, DCL_PERM_DELETE)); $objF = CreateObject('dcl.dbFaqquestions'); if ($objF->LoadByFaqTopicID($obj->topicid) == -1) { return; } $aRecords = array(); while ($objF->next_record()) { array_push($aRecords, $objF->Record); } $t->assign('VAL_QUESTIONS', $aRecords); SmartyDisplay($t, 'htmlFaqtopicsDetail.tpl'); }
function show() { global $dcl_info, $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_ADMIN, DCL_PERM_MODIFY)) { return PrintPermissionDenied(); } $objPersonnel = CreateObject('dcl.htmlPersonnel'); $oDBPersonnel = CreateObject('dcl.dbPersonnel'); if ($oDBPersonnel->Load($GLOBALS['DCLID']) == -1) { return; } $t =& CreateSmarty(); $oSelect = CreateObject('dcl.htmlSelect'); $t->assign('CMB_USERS', $objPersonnel->GetCombo(0, 'responsible', 'lastfirst', 0, false)); $begindate = @DCL_Sanitize::ToDate($_REQUEST['begindate']); if ($begindate !== null) { $t->assign('VAL_BEGINDATE', $begindate); } else { $t->assign('VAL_BEGINDATE', ''); } $enddate = @DCL_Sanitize::ToDate($_REQUEST['enddate']); if ($enddate !== null) { $t->assign('VAL_ENDDATE', $enddate); } else { $t->assign('VAL_ENDDATE', ''); } SmartyDisplay($t, 'htmlSecAuditBrowse.tpl'); }
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 Show($id, $status, $responsible) { global $dcl_info, $dcl_domain_info, $dcl_domain, $g_oSec; if (!isset($_REQUEST['wogroupby'])) { $_REQUEST['wogroupby'] = 'none'; } $bIsGrouping = $_REQUEST['wogroupby'] != 'none'; if (!$g_oSec->HasPerm(DCL_ENTITY_HOTLIST, DCL_PERM_VIEW, $id)) { return PrintPermissionDenied(); } if ($this->hotlist->Load($id) == -1) { trigger_error('Could not find a hotlist with an id of ' . $id, E_USER_ERROR); return; } $oMeta =& CreateObject('dcl.DCL_MetadataDisplay'); $this->oSmarty->assign('VAL_HOTLISTID', $id); $this->oSmarty->assign('VAL_NAME', $this->hotlist->hotlist_tag); $this->oSmarty->assign('VAL_DESCRIPTION', $this->hotlist->hotlist_desc); $this->oSmarty->assign('VAL_FILTERSTATUS', $status); $this->oSmarty->assign('VAL_FILTERRESPONSIBLE', $responsible); $this->oSmarty->assign('VAL_FILTERGROUPBY', $_REQUEST['wogroupby']); $this->oSmarty->assign('OPT_GROUPBY', array('none' => STR_CMMN_SELECTONE, '3' => STR_WO_RESPONSIBLE, '7' => STR_WO_STATUS, '4' => STR_WO_PRODUCT, '5' => STR_CMMN_MODULE, '2' => STR_WO_TYPE)); $this->oSmarty->assign('PERM_AUDIT', $g_oSec->HasPerm(DCL_ENTITY_PROJECT, DCL_PERM_AUDIT)); $this->oSmarty->assign('PERM_ATTACHFILE', $g_oSec->HasPerm(DCL_ENTITY_PROJECT, DCL_PERM_ATTACHFILE)); $this->oSmarty->assign('PERM_REMOVEFILE', $g_oSec->HasPerm(DCL_ENTITY_PROJECT, DCL_PERM_REMOVEFILE)); $this->SetStatistics(); $this->SetTasks($status, $responsible, $bIsGrouping); SmartyDisplay($this->oSmarty, 'htmlHotlistProjectDetail.tpl'); }
function Render(&$oView) { global $g_oSec, $dcl_info; if (!$g_oSec->HasPerm(DCL_ENTITY_ADDRTYPE, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } parent::Render($oView); }
function submitModify() { global $g_oSession, $dcl_info, $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_PREFS, DCL_PERM_MODIFY)) { return PrintPermissionDenied(); } $bHasChanges = false; $o = CreateObject('dcl.dbPreferences'); $o->personnel_id = $GLOBALS['DCLID']; $o->preferences_data = $g_oSession->Value('dcl_preferences'); if (!isset($o->preferences_data) || !is_array($o->preferences_data) || count($o->preferences_data) < 1) { $o->preferences_data = array('DCL_PREF_TEMPLATE_SET' => $dcl_info['DCL_DEF_TEMPLATE_SET'], 'DCL_PREF_LANGUAGE' => $dcl_info['DCL_DEFAULT_LANGUAGE'], 'DCL_PREF_NOTIFY_DEFAULT' => 'N', 'DCL_PREF_CREATED_WATCH_OPTION' => 4); $o->Add(); $bHasChanges = true; } $sOldTpl = $o->preferences_data['DCL_PREF_TEMPLATE_SET']; foreach ($_REQUEST as $pref => $setting) { if (substr($pref, 0, 9) != 'DCL_PREF_') { continue; } if ($pref == 'DCL_PREF_NOTIFY_DEFAULT') { $setting = DCL_Sanitize::ToYN($_REQUEST['DCL_PREF_NOTIFY_DEFAULT']); } if ($o->Value($pref) != $setting) { $bHasChanges = true; $o->Register($pref, $setting); } } if (!isset($_REQUEST['DCL_PREF_NOTIFY_DEFAULT'])) { $bHasChanges = true; $o->Register('DCL_PREF_NOTIFY_DEFAULT', 'N'); } if ($bHasChanges) { $o->Edit(); $g_oSession->Register('dcl_preferences', $o->preferences_data); $g_oSession->Edit(); } // Template change? $sNewTpl = $o->preferences_data['DCL_PREF_TEMPLATE_SET']; if ($sNewTpl != $sOldTpl) { // Do we need to break out of frames? $menuAction = 'menuAction=htmlPreferences.modify'; $sNewIsFramed = file_exists(DCL_ROOT . 'templates/' . $sNewTpl . '/frameset.php'); $sOldIsFramed = file_exists(DCL_ROOT . 'templates/' . $sOldTpl . '/frameset.php'); if ($sOldIsFramed) { if ($sNewIsFramed) { RefreshTop(menuLink(DCL_WWW_ROOT . 'templates/' . $sNewTpl . '/frameset.php', $menuAction)); } else { RefreshTop(menuLink('', $menuAction)); } } else { if ($sNewIsFramed) { RefreshTop(menuLink(DCL_WWW_ROOT . 'templates/' . $sNewTpl . '/frameset.php', $menuAction)); } } } $this->modify(); }
function Render(&$oView) { global $g_oSec, $dcl_info; if ($g_oSec->HasPerm(DCL_ENTITY_SOURCE, DCL_PERM_VIEW)) { parent::Render($oView); } else { return PrintPermissionDenied(); } }
function ShowSystemConfig() { global $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_ADMIN, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } $obj =& CreateObject('dcl.htmlAdminMain'); $obj->Show(); }
function delete($aSource) { global $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_ROLE, DCL_PERM_DELETE)) { return PrintPermissionDenied(); } $oDB =& CreateObject('dcl.dbRolePerm'); $oDB->DeleteRole($aSource['role_id']); return parent::Delete($aSource); }
function ShowResults() { global $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_ADMIN, DCL_PERM_MODIFY)) { return PrintPermissionDenied(); } $begindate = @DCL_Sanitize::ToDateTime($_REQUEST['begindate'] . ' 00:00:00.00'); $enddate = @DCL_Sanitize::ToDateTime($_REQUEST['enddate'] . ' 23:59:59.99'); $responsible = DCL_Sanitize::ToInt($_REQUEST['responsible']); if ($begindate === null || $enddate === null) { commonHeader(); trigger_error(STR_SEC_DATEERR, E_USER_ERROR); $this->Show(false); return; } $objDBPer =& CreateObject('dcl.dbPersonnel'); $objDBSA =& CreateObject('dcl.dbSecAudit'); $objDB = new DCLDb(); $sCols = 'SA.id, ' . $objDBSA->ConvertTimestamp('SA.actionon', 'actionon') . ', SA.actiontxt, SA.actionparam'; $sCols .= ', ' . $objDBPer->SelectAllColumns('Pers.'); $sQuery = "SELECT {$sCols}\n\t\t\tFROM {$objDBSA->TableName} SA INNER JOIN {$objDBPer->TableName} Pers on \n\t\t\tSA.id = pers.id \n\t\t\tWHERE SA.actionon BETWEEN " . $objDBSA->DisplayToSQL($begindate) . ' and ' . $objDBSA->DisplayToSQL($enddate); if ($responsible == 0) { $respname = STR_SEC_ALLUSERS; } else { $objDBPer->Load($responsible); $respname = $objDBPer->short; $sQuery .= ' AND SA.id=' . $responsible; } $sQuery .= ' ORDER BY SA.actionon'; $reportAr = null; if ($objDB->Query($sQuery) != -1) { if ($objDB->next_record()) { $idx = -1; do { $idx++; $reportAr[$idx][] = $objDB->f('short'); $reportAr[$idx][] = $objDB->FormatTimeStampForDisplay($objDB->f('actionon')); $reportAr[$idx][] = $objDB->f('actiontxt'); $reportAr[$idx][] = $objDB->f('actionparam'); } while ($objDB->next_record()); } else { trigger_error(STR_SEC_RPTNODATA, E_USER_ERROR); $this->Show(false); return; } } $obj =& CreateObject('dcl.htmlSecAudit'); if (!$obj->Render($reportAr, $begindate, $enddate, $respname)) { trigger_error(STR_SEC_RPTERROR, E_USER_ERROR); $this->Show(false); return; } }
function Detail() { global $g_oSession, $g_oSec, $dcl_info; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_SESSION, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } echo '<pre>'; print_r($g_oSession->session_data); echo '</pre>'; }
function displayPasswdForm() { global $dcl_info, $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_PREFS, DCL_PERM_PASSWORD)) { return PrintPermissionDenied(); } $oSmarty =& CreateSmarty(); $oSmarty->assign('PERM_ADMIN', $g_oSec->HasPerm(DCL_ENTITY_GLOBAL, DCL_PERM_ADMIN)); $oSmarty->assign('VAL_USERID', $GLOBALS['DCLID']); $oSmarty->assign('VAL_USERNAME', $GLOBALS['DCLNAME']); SmartyDisplay($oSmarty, 'htmlPersonnelPasswdForm.tpl'); }
function Show() { global $dcl_info, $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_ADMIN, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } $oSmarty =& CreateSmarty(); $oSmarty->assign('TXT_SETUPDESC', STR_ADMIN_SETUPDESC); $oSmarty->assign('TXT_SETUPTITLE', STR_ADMIN_SETUPTITLE); $oSmarty->assign('VAL_OPTIONS', $this->GetOptions()); SmartyDisplay($oSmarty, 'htmlAdminMain.tpl'); }
function updateProducts($org_id, &$aProductID) { if (($org_id = DCL_Sanitize::ToInt($org_id)) === null) { return PrintPermissionDenied(); } $aProductID = DCL_Sanitize::ToIntArray($aProductID); if ($aProductID === null || count($aProductID) == 0) { $aProductID = array("-1"); } $sProductID = join(',', $aProductID); $this->Execute("DELETE FROM dcl_org_product_xref WHERE org_id = {$org_id} AND product_id NOT IN ({$sProductID})"); $this->Execute("INSERT INTO dcl_org_product_xref (org_id, product_id) SELECT {$org_id}, id FROM products WHERE id IN ({$sProductID}) AND id NOT IN (SELECT product_id FROM dcl_org_product_xref WHERE org_id = {$org_id})"); }
function updateOrgs($contact_id, &$aOrgID) { if (($contact_id = DCL_Sanitize::ToInt($contact_id)) === null) { return PrintPermissionDenied(); } $aOrgID = DCL_Sanitize::ToIntArray($aOrgID); if ($aOrgID === null || count($aOrgID) == 0) { $aOrgID = array("-1"); } $sOrgID = join(',', $aOrgID); $this->Execute("DELETE FROM dcl_org_contact WHERE contact_id = {$contact_id} AND org_id NOT IN ({$sOrgID})"); $this->Execute("INSERT INTO dcl_org_contact (org_id, contact_id, created_on, created_by) SELECT org_id, {$contact_id}, " . $this->GetDateSQL() . ", " . $GLOBALS['DCLID'] . " FROM dcl_org WHERE org_id IN ({$sOrgID}) AND org_id NOT IN (SELECT org_id FROM dcl_org_contact WHERE contact_id = {$contact_id})"); }
function show() { global $dcl_info, $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_WORKORDER, DCL_PERM_REPORT)) { return PrintPermissionDenied(); } if (($type = DCL_Sanitize::ToInt($_REQUEST['type'])) === null || ($id = DCL_Sanitize::ToInt($_REQUEST['id'])) === null) { trigger_error('Data sanitize failed.'); return; } $oSmarty =& CreateSmarty(); $oAudit =& CreateObject('dcl.boAudit'); switch ($type) { case DCL_ENTITY_WORKORDER: if (($id2 = DCL_Sanitize::ToInt($_REQUEST['id2'])) === null) { trigger_error('Data sanitize failed.'); return; } $this->aAudit = $oAudit->LoadDiff('dbWorkorders', array('jcn' => $id, 'seq' => $id2)); $oSmarty->assign('VAL_ID', sprintf('%d-%d', $id, $id2)); $oSmarty->assign('VAL_SUMMARY', $this->oMeta->GetWorkOrder($id, $id2)); $oSmarty->assign('LNK_BACK', menuLink('', "menuAction=boWorkorders.viewjcn&jcn={$id}&seq={$id2}")); $oAccount =& CreateObject('dcl.dbWorkOrderAccount'); $this->aAuditAccount = $oAccount->AuditWorkOrderList($id, $id2); $oProject =& CreateObject('dcl.dbProjectmap'); $this->aAuditProject = $oProject->AuditWorkOrderList($id, $id2); break; case DCL_ENTITY_PROJECT: $this->aAudit = $oAudit->LoadDiff('dbProjects', array('projectid' => $id)); $oSmarty->assign('VAL_ID', $id); $oSmarty->assign('VAL_SUMMARY', $this->oMeta->GetProject($id)); $oSmarty->assign('LNK_BACK', menuLink('', "menuAction=boProjects.viewproject&wostatus=0&project={$id}")); $oProject =& CreateObject('dcl.dbProjectmap'); $this->aAuditWorkOrder = $oProject->AuditProjectList($id); break; case DCL_ENTITY_TICKET: $this->aAudit = $oAudit->LoadDiff('dbTickets', array('ticketid' => $id)); $oSmarty->assign('VAL_ID', $id); $oSmarty->assign('VAL_SUMMARY', $this->oMeta->GetTicket($id)); $oSmarty->assign('LNK_BACK', menuLink('', "menuAction=boTickets.view&ticketid={$id}")); break; } $this->prepareForDisplay(); $oSmarty->assign_by_ref('VAL_AUDITTRAIL', $this->aAudit); $oSmarty->assign_by_ref('VAL_AUDITACCOUNT', $this->aAuditAccount); $oSmarty->assign_by_ref('VAL_AUDITPROJECT', $this->aAuditProject); $oSmarty->assign_by_ref('VAL_AUDITWORKORDER', $this->aAuditWorkOrder); SmartyDisplay($oSmarty, 'htmlAuditTrail.tpl'); }
function add($aSource) { global $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_ORG, DCL_PERM_ADD) && !$g_oSec->HasPerm(DCL_ENTITY_CONTACT, DCL_PERM_ADD) && !$g_oSec->HasPerm(DCL_ENTITY_ORG, DCL_PERM_MODIFY) && !$g_oSec->HasPerm(DCL_ENTITY_CONTACT, DCL_PERM_MODIFY)) { return PrintPermissionDenied(); } $this->oDB->InitFromArray($aSource); if ($this->oDB->Add() == -1) { return -1; } if (isset($this->sKeyField) && $this->sKeyField != '') { return $this->oDB->{$this->sKeyField}; } return 1; }
function Show() { global $dcl_info, $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_BUILDMANAGER, DCL_PERM_MODIFY)) { return PrintPermissionDenied(); } if (($product_id = DCL_Sanitize::ToInt($_REQUEST['product_id'])) === null) { return PrintPermissionDenied(); } if (($version_id = DCL_Sanitize::ToInt($_REQUEST['product_version_id'])) === null) { return PrintPermissionDenied(); } $oProduct = CreateObject('dcl.dbProducts'); $oProduct->Load($product_id); $oPV = CreateObject('dcl.dbProductVersion'); if ($oPV->Load(array('product_version_id' => $version_id)) == -1) { ShowError('Failed to load version ID ' . $version_id, 'Error'); return; } $this->oSmarty->assign('VAL_JSDATEFORMAT', GetJSDateFormat()); $this->oSmarty->assign('VAL_FORMACTION', menuLink()); if (isset($GLOBALS['add'])) { $this->oSmarty->assign('VAL_MENUACTION', 'boBuildManager.addRelease'); } else { $this->oSmarty->assign('VAL_MENUACTION', 'boBuildManager.modifyRelease'); } $this->oSmarty->assign('TXT_BM_ADD_RELEASE', STR_BM_MOD_RELEASE); $this->oSmarty->assign('TXT_BM_PRODUCT', STR_BM_PRODUCT); $this->oSmarty->assign('TXT_BM_RELEASE_ALIAS_TITLE', STR_BM_RELEASE_ALIAS_TITLE); $this->oSmarty->assign('TXT_BM_RELEASEDATE_DESC', STR_BM_RELEASEDATE_DESC); $this->oSmarty->assign('TXT_BM_RELEASEDATE', STR_BM_RELEASEDATE); $this->oSmarty->assign('VAL_PRODUCTNAME', $oProduct->name); $this->oSmarty->assign('VAL_PRODUCTID', $oProduct->id); $this->oSmarty->assign('VAL_VERSIONID', $version_id); $this->oSmarty->assign('VAL_VERSIONTEXT', $oPV->product_version_text); $this->oSmarty->assign('VAL_VERSIONDESCR', $oPV->product_version_descr); $this->oSmarty->assign('VAL_ACTIVE', $oPV->active); $this->oSmarty->assign('VAL_VERSIONACTUALDATE', $oPV->product_version_actual_date); $this->oSmarty->assign('VAL_VERSIONTARGETDATE', $oPV->product_version_target_date); $this->oSmarty->assign('date', $oPV->product_version_target_date); $this->oSmarty->assign('VAL_DATEELEMENT', 'product_version_target_date'); $this->oSmarty->assign('VAL_WHICH', $GLOBALS['which']); SmartyDisplay($this->oSmarty, 'htmlBuildManagerReleaseForm.tpl'); }
function Render($oView) { global $dcl_info, $g_oSec, $g_oSession; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_BUILDMANAGER, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } $oDB = CreateObject('dcl.dbBuildManager'); if ($oDB->query($oView->GetSQL()) == -1) { return; } $allRecs = $oDB->FetchAllRows(); $oTable =& CreateObject('dcl.htmlTable'); $oTable->setCaption($oView->title); $oTable->addColumn(STR_CMMN_ID, 'numeric'); $oTable->addColumn(STR_BM_RELEASE_ALIAS_TITLE, 'string'); $oTable->addColumn(STR_CMMN_ACTIVE, 'string'); $oTable->addColumn(STR_BM_RELEASEDATE_DESC, 'string'); $oTable->addColumn('Target Date', 'date'); $oTable->addColumn('Actual Date', 'date'); if (isset($this->ModNav) && ($this->ModNav == 'WO' || $this->ModNav == 'showfiles')) { $oTable->addToolbar(menuLink('', 'menuAction=boProducts.viewRelease&id=' . $this->id), 'Back'); } else { $oTable->addToolbar(menuLink('', 'menuAction=boBuildManager.add&which=release&product_id=' . $this->productid . '&add=1'), STR_CMMN_NEW); } if (count($allRecs) > 0 && $g_oSec->HasPerm(DCL_ENTITY_GLOBAL, DCL_ENTITY_ADMIN)) { $oTable->addColumn(STR_CMMN_OPTIONS, 'html'); for ($i = 0; $i < count($allRecs); $i++) { $options = ''; if (isset($this->ModNav)) { $options = '<a href="' . menuLink('', 'menuAction=boWorkorders.viewjcn&jcn=' . $allRecs[$i][1] . '&seq=' . $allRecs[$i][2]) . '">' . STR_CMMN_VIEW . '</a>'; } else { $versionid = $allRecs[$i][0]; $options = '<a href="' . menuLink('', 'menuAction=boProducts.viewBuild&product_version_id=' . $versionid . '&product_id=' . $this->productid) . '">' . STR_CMMN_VIEW . '</a>'; $options .= ' | <a href="' . menuLink('', 'menuAction=htmlBuildManagerReleaseForm.Show&product_version_id=' . $versionid . '&product_id=' . $this->productid . '&which=release') . '">' . STR_CMMN_EDIT . '</a>'; $options .= ' | <a href="' . menuLink('', 'menuAction=boBuildManager.ShowWorkOrders&product_version_id=' . $versionid . '&product_id=' . $this->productid . '&from=version') . '">' . STR_CMMN_SHOWVERSION . '</a>'; $options .= ' | <a href="' . menuLink('', 'menuAction=boBuildManager.ShowFiles&product_version_id=' . $versionid . '&product_id=' . $this->productid . '&from=version') . '">' . STR_CMMN_SHOWFILES . '</a>'; } $allRecs[$i][6] = $options; } } $oTable->setData($allRecs); $oTable->setShowRownum(true); $oTable->render(); }
function Page() { global $dcl_info, $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_ROLE, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } $oView = CreateObject('dcl.boView'); $oView->SetFromURL(); if ((isset($_REQUEST['btnNav']) || isset($_REQUEST['jumptopage'])) && isset($_REQUEST['startrow']) && isset($_REQUEST['numrows'])) { if (isset($_REQUEST['btnNav']) && $_REQUEST['btnNav'] == '<<') { $oView->startrow = (int) $_REQUEST['startrow'] - (int) $_REQUEST['numrows']; } else { if (isset($_REQUEST['btnNav']) && $_REQUEST['btnNav'] == '>>') { $oView->startrow = (int) $_REQUEST['startrow'] + (int) $_REQUEST['numrows']; } else { $iPage = (int) $_REQUEST['jumptopage']; if ($iPage < 1) { $iPage = 1; } $oView->startrow = ($iPage - 1) * (int) $_REQUEST['numrows']; } } if ($oView->startrow < 0) { $oView->startrow = 0; } $oView->numrows = (int) $_REQUEST['numrows']; } else { $oView->numrows = 25; $oView->startrow = 0; } $filterActive = '0'; if (isset($_REQUEST['filterActive'])) { $filterActive = $_REQUEST['filterActive']; } if ($filterActive != '0') { $oView->ReplaceDef('filter', 'active', "'{$filterActive}'"); } else { $oView->RemoveDef('filter', 'active'); } $this->sColumnTitle = STR_CMMN_OPTIONS; $this->bShowPager = true; $this->Render($oView); }
function showForm($obj = '') { global $g_oSec; $isEdit = is_object($obj); if (!$g_oSec->HasPerm(DCL_ENTITY_FORMTEMPLATES, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) { return PrintPermissionDenied(); } $t = CreateSmarty(); if ($isEdit) { $t->assign('VAL_MENUACTION', 'boChecklistTpl.dbmodify'); $t->assign('CMB_ACTIVE', GetYesNoCombo($obj->dcl_chklst_tpl_active, 'dcl_chklst_tpl_active', 0, false)); $t->assign('VAL_NAME', $obj->dcl_chklst_tpl_name); $t->assign('VAL_ID', $obj->dcl_chklst_tpl_id); } else { $t->assign('VAL_MENUACTION', 'boChecklistTpl.dbadd'); $t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'dcl_chklst_tpl_active', 0, false)); } SmartyDisplay($t, 'htmlChklstTplAdd.tpl'); }
function Show($obj) { global $dcl_info, $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_ATTRIBUTESETS, DCL_PERM_VIEW)) { return PrintPermissionDenied(); } if (!is_object($obj)) { trigger_error('[htmlAttributesets::Show] ' . STR_ATTR_OBJECTNOTPASSED); return; } $t = CreateSmarty(); $t->assign('VAL_ATTRIBUTESETNAME', $obj->name); SmartyDisplay($t, 'htmlAttributesetdetail.tpl'); $objA = CreateObject('dcl.dbActions'); $theAttributes = array('actions', 'priorities', 'severities', 'statuses'); $aTitles = array('actions' => STR_ATTR_ACTIONS, 'priorities' => STR_ATTR_PRIORITIES, 'severities' => STR_ATTR_SEVERITIES, 'statuses' => STR_ATTR_STATUSES); for ($cnt = 0; $cnt < count($theAttributes); $cnt++) { $typeid = $cnt + 1; $section = $theAttributes[$cnt]; $query = 'SELECT a.name FROM ' . $section . ' a, attributesetsmap b WHERE a.id=b.keyid '; $query .= ' AND b.setid=' . $obj->id; $query .= ' AND b.typeid=' . $typeid; $query .= ' ORDER BY '; if ($section == 'priorities' || $section == 'severities') { $query .= 'b.weight'; } else { $query .= 'a.name'; } if ($objA->Query($query) != -1) { $oTable = CreateObject('dcl.htmlTable'); $oTable->setCaption($aTitles[$theAttributes[$cnt]]); $oTable->setInline(true); $oTable->addToolbar(menuLink('', 'menuAction=boAttributesets.showall'), STR_ATTR_ATTRIBUTESET); if ($g_oSec->HasPerm(DCL_ENTITY_ATTRIBUTESETS, DCL_PERM_MODIFY)) { $oTable->addToolbar(menuLink('', 'menuAction=boAttributesets.showmapping&setid=' . $obj->id . '&typeid=' . $typeid), STR_ATTR_MAP); } $oTable->setData($objA->FetchAllRows()); $oTable->addColumn(STR_CMMN_NAME, 'string'); $oTable->render(); } } }
function dbmodify() { global $dcl_info, $g_oSec; commonHeader(); if (!$g_oSec->HasPerm(DCL_ENTITY_ADMIN, DCL_PERM_MODIFY)) { return PrintPermissionDenied(); } $aCheckboxes = array('DCL_AUTO_DATE', 'DCL_PROJECT_XML_TEMPLATES', 'DCL_SMTP_ENABLED', 'DCL_GATEWAY_TICKET_ENABLED', 'DCL_GATEWAY_TICKET_AUTORESPOND', 'DCL_GATEWAY_TICKET_REPLY', 'DCL_PROJECT_INCLUDE_CHILD_STATS', 'DCL_PROJECT_INCLUDE_PARENT_STATS', 'DCL_PROJECT_BROWSE_PARENTS_ONLY', 'DCL_WO_NOTIFICATION_HTML', 'DCL_TCK_NOTIFICATION_HTML', 'DCL_GATEWAY_WO_ENABLED', 'DCL_GATEWAY_WO_AUTORESPOND', 'DCL_GATEWAY_WO_REPLY', 'DCL_WO_SECONDARY_ACCOUNTS_ENABLED', 'DCL_WIKI_ENABLED', 'DCL_SCCS_ENABLED', 'DCL_SMTP_AUTH_REQUIRED', 'DCL_BUILD_MANAGER_ENABLED', 'DCL_SEC_AUDIT_ENABLED', 'DCL_SEC_AUDIT_LOGIN_ONLY', 'DCL_FORCE_SECURE_GRAVATAR'); // get all of the settings except for DCL_VERSION and LAST_CONFIG_UPDATE and update // the ones that have changed. $bHasUpdates = false; $oConfig =& CreateObject('dcl.dbConfig'); $oConfig->LoadForModify(); while ($oConfig->next_record()) { $oConfig->GetRow(); if (isset($_REQUEST[$oConfig->dcl_config_name])) { $_REQUEST[$oConfig->dcl_config_name] = $oConfig->GPCStripSlashes($_REQUEST[$oConfig->dcl_config_name]); } // checkboxes need special handling if (in_array($oConfig->dcl_config_name, $aCheckboxes)) { $newVal = isset($_REQUEST[$oConfig->dcl_config_name]) && $_REQUEST[$oConfig->dcl_config_name] == 'Y' ? 'Y' : 'N'; if ($newVal != $dcl_info[$oConfig->dcl_config_name]) { $oConfig->{$oConfig->dcl_config_field} = $newVal; $oConfigTemp = $oConfig; $oConfigTemp->Edit(); $dcl_info[$oConfig->dcl_config_name] = $newVal; $bHasUpdates = true; } } elseif (isset($_REQUEST[$oConfig->dcl_config_name]) && $dcl_info[$oConfig->dcl_config_name] != $_REQUEST[$oConfig->dcl_config_name]) { $oConfig->{$oConfig->dcl_config_field} = $_REQUEST[$oConfig->dcl_config_name]; $oConfigTemp = $oConfig; $oConfigTemp->Edit(); $dcl_info[$oConfig->dcl_config_name] = $_REQUEST[$oConfig->dcl_config_name]; $bHasUpdates = true; } } if ($bHasUpdates) { $oConfigTemp->UpdateTimeStamp(); } $obj =& CreateObject('dcl.htmlAdminMain'); $obj->Show(); }
function Show() { global $g_oSec; commonHeader(); if (($id = DCL_Sanitize::ToInt($_REQUEST['id'])) === null) { trigger_error('Data sanitize failed.'); return; } if (!$g_oSec->HasPerm(DCL_ENTITY_HOTLIST, DCL_PERM_VIEW, $id)) { return PrintPermissionDenied(); } $this->hotlist =& CreateObject('dcl.dbHotlist'); if ($this->hotlist->Load($id) == -1) { trigger_error('Could not find a hotlist with an id of ' . $id, E_USER_ERROR); return; } $this->oSmarty->assign('VAL_HOTLISTID', $id); $this->oSmarty->assign('VAL_NAME', $this->hotlist->hotlist_desc); SmartyDisplay($this->oSmarty, 'htmlHotlistProjectDashboard.tpl'); }
function delete($aSource) { global $g_oSec; if (!$g_oSec->HasPerm(DCL_ENTITY_CONTACT, DCL_PERM_DELETE)) { return PrintPermissionDenied(); } if (($id = @DCL_Sanitize::ToInt($aSource['contact_id'])) === null) { trigger_error('Data sanitize failed.'); return; } if (!$this->oDB->HasFKRef($id)) { $this->oDB->Execute("DELETE FROM dcl_contact_addr WHERE contact_id = {$id}"); $this->oDB->Execute("DELETE FROM dcl_org_contact WHERE contact_id = {$id}"); $this->oDB->Execute("DELETE FROM dcl_contact_email WHERE contact_id = {$id}"); $this->oDB->Execute("DELETE FROM dcl_contact_note WHERE contact_id = {$id}"); $this->oDB->Execute("DELETE FROM dcl_contact_phone WHERE contact_id = {$id}"); $this->oDB->Execute("DELETE FROM dcl_contact_type_xref WHERE contact_id = {$id}"); } parent::delete($aSource); }
function GetHTML($part = 'all') { global $dcl_info; if (($wo_id = DCL_Sanitize::ToInt($_REQUEST['wo_id'])) === null || ($seq = DCL_Sanitize::ToInt($_REQUEST['seq'])) === null) { trigger_error('Data sanitize failed.'); return; } if ($part == 'top') { $this->t->set_var('TXT_TITLE', 'Work Order ' . $wo_id . '-' . $seq . ' Organizations'); $this->t->set_var('TXT_OK', STR_CMMN_OK); $this->t->set_var('TXT_PRINT', STR_CMMN_PRINT); } else { if ($part == 'main') { $this->t->set_block('hForm', 'sel', 'hSel'); $this->t->set_var('hSel', ''); switch ($_REQUEST['what']) { case 'dcl_wo_account.wo_id': $this->ListFromDb('dcl_wo_account', 'name', 'wo_id = ' . $wo_id . ' And seq = ' . $seq, 'name'); break; default: PrintPermissionDenied(); return ""; } } else { $this->t = CreateTemplate(array('hForm' => 'htmlWindowList.tpl')); $this->t->set_var('TXT_TITLE', 'Work Order ' . $wo_id . '-' . $seq . ' Organizations'); $this->t->set_var('TXT_OK', STR_CMMN_OK); switch ($_REQUEST['what']) { case 'dcl_wo_account.wo_id': $this->ListFromDb('dcl_wo_account', 'name', 'wo_id = ' . $wo_id . ' And seq = ' . $seq, 'name'); break; default: PrintPermissionDenied(); return ""; } return $this->t->parse('out', 'hForm'); } } }