function show()
{
global $dcl_info, $g_oSec;
commonHeader();
if (!$g_oSec->HasPerm(DCL_ENTITY_PROJECT, DCL_PERM_VIEW)) {
return PrintPermissionDenied();
}
$oView = CreateObject('dcl.boView');
$oView->numrows = 25;
$filterStatus = @DCL_Sanitize::ToSignedInt($_REQUEST['filterStatus']);
$filterReportto = @DCL_Sanitize::ToInt($_REQUEST['filterReportto']);
$oView->table = 'dcl_projects';
$oView->style = 'report';
$oView->title = 'Projects';
$oView->AddDef('columnhdrs', '', array(STR_CMMN_ID, STR_PRJ_LEAD, STR_PRJ_STATUS, STR_PRJ_NAME));
$oView->AddDef('columns', '', array('projectid', 'reportto.short', 'statuses.name', 'dcl_projects.name'));
if ($dcl_info['DCL_PROJECT_BROWSE_PARENTS_ONLY'] == 'Y') {
$oView->AddDef('filter', 'parentprojectid', 0);
}
$oView->AddDef('order', '', array('dcl_projects.name'));
if ($filterStatus !== null) {
if ($filterStatus > 0) {
$oView->AddDef('filter', 'dcl_projects.status', $filterStatus);
} else {
if ($filterStatus == -1) {
$oView->AddDef('filter', 'statuses.dcl_status_type', '2');
} else {
$oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
}
}
} else {
$oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
}
if ($filterReportto !== null) {
$oView->AddDef('filter', 'dcl_projects.reportto', $filterReportto);
}
if (isset($_REQUEST['filterName']) && trim($_REQUEST['filterName']) != '') {
$oView->AddDef('filterlike', 'name', GPCStripSlashes($_REQUEST['filterName']));
}
$oHtml = CreateObject('dcl.htmlProjectsBrowse');
$oHtml->Render($oView);
}
function View()
{
global $g_oSec;
commonHeader();
if (($id = @DCL_Sanitize::ToInt($_REQUEST['id'])) === null) {
trigger_error('Data sanitize failed.');
return;
}
if ($id > 0) {
if (!$g_oSec->HasPerm(DCL_ENTITY_HOTLIST, DCL_PERM_VIEW, $id)) {
return PrintPermissionDenied();
}
$status = 0;
$responsible = 0;
if (($status = @DCL_Sanitize::ToSignedInt($_REQUEST['wostatus'])) === null) {
$status = 0;
}
if (($responsible = @DCL_Sanitize::ToInt($_REQUEST['woresponsible'])) === null) {
$responsible = 0;
}
$this->show($id, $status, $responsible);
}
}
function Page()
{
global $dcl_info, $g_oSec;
commonHeader();
if (!$g_oSec->HasAnyPerm(array(DCL_ENTITY_TICKET => array($g_oSec->PermArray(DCL_PERM_VIEW), $g_oSec->PermArray(DCL_PERM_VIEWSUBMITTED), $g_oSec->PermArray(DCL_PERM_VIEWACCOUNT))))) {
return PrintPermissionDenied();
}
$oView = CreateObject('dcl.boView');
$oView->SetFromURL();
if (isset($_REQUEST['jumptopage']) && isset($_REQUEST['startrow']) && isset($_REQUEST['numrows'])) {
$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;
}
$filterStatus = -1;
if (isset($_REQUEST['filterStatus'])) {
$filterStatus = @DCL_Sanitize::ToSignedInt($_REQUEST['filterStatus']);
}
$filterReportto = @DCL_Sanitize::ToInt($_REQUEST['filterReportto']);
$filterProduct = @DCL_Sanitize::ToInt($_REQUEST['filterProduct']);
$filterType = @DCL_Sanitize::ToInt($_REQUEST['filterType']);
$oView->RemoveDef('filternot', 'statuses.dcl_status_type');
$oView->RemoveDef('filter', 'statuses.dcl_status_type');
$oView->RemoveDef('filter', 'status');
if ($filterStatus !== null && $filterStatus != 0) {
if ($filterStatus == -1) {
$oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
} else {
if ($filterStatus == -2) {
$oView->AddDef('filter', 'statuses.dcl_status_type', '2');
} else {
if ($filterStatus !== null) {
$oView->AddDef('filter', 'status', $filterStatus);
}
}
}
} else {
$oView->RemoveDef('filter', 'status');
}
if ($filterReportto !== null && $filterReportto > 0) {
$oView->ReplaceDef('filter', 'responsible', $filterReportto);
} else {
$oView->RemoveDef('filter', 'responsible');
}
if ($filterProduct !== null && $filterProduct > 0) {
$oView->ReplaceDef('filter', 'product', $filterProduct);
} else {
$oView->RemoveDef('filter', 'product');
}
if ($filterType !== null && $filterType > 0) {
$oView->ReplaceDef('filter', 'type', $filterType);
} else {
$oView->RemoveDef('filter', 'type');
}
$this->sColumnTitle = STR_CMMN_OPTIONS;
$this->bShowPager = true;
$this->Render($oView);
}
function Page()
{
global $dcl_info, $g_oSec;
commonHeader();
if (!$g_oSec->HasPerm(DCL_ENTITY_PROJECT, DCL_PERM_VIEW)) {
return PrintPermissionDenied();
}
$oView = CreateObject('dcl.boView');
$oView->SetFromURL();
if (isset($_REQUEST['jumptopage']) && isset($_REQUEST['startrow']) && isset($_REQUEST['numrows'])) {
$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;
}
$filterStatus = -1;
if (isset($_REQUEST['filterStatus'])) {
$filterStatus = @DCL_Sanitize::ToSignedInt($_REQUEST['filterStatus']);
}
$filterReportto = @DCL_Sanitize::ToInt($_REQUEST['filterReportto']);
$oView->RemoveDef('filternot', 'statuses.dcl_status_type');
$oView->RemoveDef('filter', 'statuses.dcl_status_type');
$oView->RemoveDef('filter', 'status');
$oView->RemoveDef('filterlike', 'name');
if ($filterStatus !== null && $filterStatus != 0) {
if ($filterStatus == -1) {
$oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
} else {
if ($filterStatus == -2) {
$oView->AddDef('filter', 'statuses.dcl_status_type', '2');
} else {
if ($filterStatus !== null) {
$oView->AddDef('filter', 'status', $filterStatus);
}
}
}
} else {
$oView->RemoveDef('filter', 'status');
}
if ($filterReportto !== null && $filterReportto > 0) {
$oView->ReplaceDef('filter', 'reportto', $filterReportto);
} else {
$oView->RemoveDef('filter', 'reportto');
}
if (isset($_REQUEST['filterName']) && trim($_REQUEST['filterName']) != '') {
$oView->AddDef('filterlike', 'name', GPCStripSlashes($_REQUEST['filterName']));
}
$this->sColumnTitle = STR_CMMN_OPTIONS;
$this->bShowPager = true;
$this->Render($oView);
}
function showBrowseFrame()
{
global $dcl_info, $g_oSec;
if (!$g_oSec->HasPerm(DCL_ENTITY_CONTACT, DCL_PERM_VIEW)) {
return PrintPermissionDenied();
}
$filterStatus = @DCL_Sanitize::ToSignedInt($_REQUEST['filterStatus']);
if ($filterStatus === null) {
$filterStatus = -1;
}
$filterStartsWith = '';
if (isset($_REQUEST['filterStartsWith'])) {
$filterStartsWith = $_REQUEST['filterStartsWith'];
}
$filterSearch = '';
if (isset($_REQUEST['filterSearch'])) {
$filterSearch = $_REQUEST['filterSearch'];
}
$filterID = '';
if (isset($_REQUEST['filterID'])) {
if (ereg('^[0-9]+([,][0-9]+)*$', $_REQUEST['filterID'])) {
$filterID = explode(',', $_REQUEST['filterID']);
}
}
$aColumnHeaders = array(STR_CMMN_ID, STR_PRJ_LEAD, STR_PRJ_STATUS, STR_PRJ_NAME);
$aColumns = array('projectid', 'reportto.short', 'statuses.name', 'dcl_projects.name');
$iPage = 1;
$this->oView->startrow = 0;
$this->oView->numrows = 15;
if (isset($_REQUEST['page'])) {
$iPage = (int) $_REQUEST['page'];
if ($iPage < 1) {
$iPage = 1;
}
$this->oView->startrow = ($iPage - 1) * $this->oView->numrows;
if ($this->oView->startrow < 0) {
$this->oView->startrow = 0;
}
}
$this->oView->table = 'dcl_projects';
$this->oView->AddDef('columnhdrs', '', $aColumnHeaders);
$this->oView->AddDef('columns', '', $aColumns);
$this->oView->AddDef('order', '', array('name'));
if ($filterStatus !== null) {
if ($filterStatus > 0) {
$this->oView->AddDef('filter', 'dcl_projects.status', $filterStatus);
} else {
if ($filterStatus == -2) {
$this->oView->AddDef('filter', 'statuses.dcl_status_type', '2');
} else {
$this->oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
}
}
} else {
$this->oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
}
if ($filterSearch != '') {
$this->oView->AddDef('filterlike', 'name', $filterSearch);
}
if ($filterStartsWith != '') {
$this->oView->AddDef('filterstart', 'name', $filterStartsWith);
}
if (is_array($filterID)) {
$this->oView->AddDef('filter', 'projectid', $filterID);
}
if ($this->oDB->Query($this->oView->GetSQL(true)) == -1 || !$this->oDB->next_record()) {
exit;
}
$iRecords = (int) $this->oDB->f(0);
$this->oSmarty->assign('VAL_COUNT', $iRecords);
$this->oSmarty->assign('VAL_PAGE', $iPage);
$this->oSmarty->assign('VAL_MAXPAGE', ceil($iRecords / $this->oView->numrows));
$this->oDB->FreeResult();
if ($this->oDB->LimitQuery($this->oView->GetSQL(), $this->oView->startrow, $this->oView->numrows) != -1) {
$aProjects = array();
while ($this->oDB->next_record()) {
$aRecord = $this->oDB->Record;
$aRecord['status'] = $this->oDB->f(2);
$aRecord['reportto'] = $this->oDB->f(1);
array_push($aProjects, $aRecord);
}
$this->oDB->FreeResult();
$this->oSmarty->assign_by_ref('VAL_PROJECTS', $aProjects);
$this->oSmarty->assign('VAL_HEADERS', $aColumnHeaders);
$this->oSmarty->assign('VAL_FILTERID', $filterID);
$this->oSmarty->assign('VAL_MULTISELECT', isset($_REQUEST['multiple']) && $_REQUEST['multiple'] == 'true');
SmartyDisplay($this->oSmarty, 'htmlProjectSelectorBrowse.tpl');
}
exit;
}
function viewproject()
{
global $g_oSec;
commonHeader();
if (($project = @DCL_Sanitize::ToInt($_REQUEST['project'])) === null) {
trigger_error('Data sanitize failed.');
return;
}
if ($project > 0) {
if (!$g_oSec->HasPerm(DCL_ENTITY_PROJECT, DCL_PERM_VIEW, $project)) {
return PrintPermissionDenied();
}
$obj =& CreateObject('dcl.htmlProjectsdetail');
$wostatus = 0;
$woresponsible = 0;
if (($wostatus = @DCL_Sanitize::ToSignedInt($_REQUEST['wostatus'])) === null) {
$wostatus = 0;
}
if (($woresponsible = @DCL_Sanitize::ToInt($_REQUEST['woresponsible'])) === null) {
$woresponsible = 0;
}
$obj->show($project, $wostatus, $woresponsible);
}
}
