menu($args['year']); } SE_Layout::dol(); } public function yearBudgetAction() { $args = array(); $args['year'] = V::get('year', '', $_REQUEST, 'int'); $args['groups'] = V::get('fltrGroups', array(), $_REQUEST, 'array', array('V', 'filterPositiveInteger')); $args['_print'] = V::get('_print', '', $_REQUEST, 'int'); $hasData = false; $groups = null; if ($args['year'] > 0) { $hasData = $this->fetchDataByYear($args['year']); $groups = $this->getUsedUserGroups(); } SE_Layout::gora(); SE_Layout::menu(); if (!$args['_print']) { $this->menu($args['year'], $groups, $args['groups']); } if (empty($args['year'])) { ?>
Nie wybrano roku.
Brak danych na wybrany rok.
$costs: ';print_r($costs);echo''; $this->printCostsForYear($args['year'], $args['groups']); SE_Layout::dol(); } private function menu($selectedYear, $groups = array(), $selectedGroups = array()) { //SE_Layout::menu(); $year = ($selectedYear)? $selectedYear : date("Y"); ?>
Edytuj plan budżetu na rok
css(); if(V::get('DBG','',$_GET)){echo'
';print_r($this->_costs);echo'
';} ?>

Zestawienie kosztów projektów na rok

_projectPathsOrder as $projPath => $projId) : ?> _projectInfo[$projId]->M_DIST_DESC; $projectPath = $this->_projectInfo[$projId]->path; $projectAccess = $this->hasAccessToProject($projectID); if (!empty($groups)) { if (!$projectAccess) { //echo '
TODO: filtered by acl for project';print_r($this->_projectInfo[$projId]);echo'
'; continue; } if (!$this->hasGroupsAccessToProjects($projectID, $groups)) { //echo '
TODO: filtered by acl and groups';print_r($this->_projectInfo[$projId]);echo'
'; continue; } } ?> getCost($projectID, $month); ?> COST_TOTAL : 0; ?> COST_CHILD, 2); $vCostSelfOut = number_format($vMonthCost->COST_SELF, 2); $vCostTotalOut = number_format($vMonthCost->COST_TOTAL, 2); $vCostTotalOutJs = number_format($vMonthCost->COST_TOTAL, 2, '.', ''); $title = "Koszt projektu {$vCostSelfOut} / koszt podprojektów $vCostChildOut"; $cellCostCls = ''; if ($vMonthCost->COST_CHILD > 0) { if ($vMonthCost->COST_SELF > 0) { $cellCostCls = 'cell-cost-self_and_child'; } else { $cellCostCls = 'cell-cost-only_child'; } } else { $cellCostCls = 'cell-cost-only_self'; } ?> getPlan($projectID, $month); ?> getPlan($projectID, $month); if ($monthPlan > 0) { $procentOut = round(($monthCostTotal * 100) / $monthPlan); if ($procentOut > 150) { $cellProcentCls = 'cell-procent-over150'; } else if ($procentOut > 100) { $cellProcentCls = 'cell-procent-over100'; } else if ($procentOut == 100) { $cellProcentCls = 'cell-procent-100'; } else { $cellProcentCls = 'cell-procent-below100'; } } ?>
miesiąc
pokaż tylko zaznaczone Koszty Plan %
*** ***   *** 0) : ?>   ***
_projectPathsOrder as $projPath => $projId) : ?> _costs[$projId]; if (!$projectInfo) { continue; } $projectID = $projId; $projectDesc = $this->_projectInfo[$projId]->M_DIST_DESC; $projectPath = $this->_projectInfo[$projId]->path; ?> korespByMonth)) : ?> korespByMonth as $kMonth => $vKorespMonthList) : ?> $vKorespInfo) : ?> 41235 * [MONTH] => 2015-02 * [K_ZAWARTOS] => Faktura za pomiar powykonawczy sieci telekomunikacyjnej * [COST] => 1000.00 * [INCOME] => 0.00 ? [TRANSFER_OPPOSITE_ID_PROJECT] => int */ ?> COST, 2); ?> _costs)) { return null; } if (!array_key_exists($month, $this->_costs[$idProject]->costsByMonth)) { return null; } return $this->_costs[$idProject]->costsByMonth[$month]; } public function getPlan($idProject, $month) { if (!array_key_exists($idProject, $this->_plan)) { return 0; } if (!array_key_exists($month, $this->_plan[$idProject])) { return 0; } return $this->_plan[$idProject][$month]; } public function fetchDataByYear($year) { $this->_fetchCostsByYear($year); $this->_fetchPlanByYear($year); $this->_fetchProjectInfo(); $this->_buildProjectTree(); $this->_reacountCostsFromKoresp(); return count($this->_projectInfo) > 1;// $this->_projectInfo[0] - Wszystkie projekty } public function _fetchPlanByYear($year) { $db = DB::getDB(); $this->_plan = array(); $sql = " select plan.`ID` , plan.`ID_PROJECT` AS `ID_PROJECT` , plan.`MONTH_1_VALUE` , plan.`MONTH_2_VALUE` , plan.`MONTH_3_VALUE` , plan.`MONTH_4_VALUE` , plan.`MONTH_5_VALUE` , plan.`MONTH_6_VALUE` , plan.`MONTH_7_VALUE` , plan.`MONTH_8_VALUE` , plan.`MONTH_9_VALUE` , plan.`MONTH_10_VALUE` , plan.`MONTH_11_VALUE` , plan.`MONTH_12_VALUE` from `projects_budget_year_month` plan where plan.`year`='{$year}' -- TODO: acl "; //echo'
';print_r($sql);echo'
'; $res = $db->query($sql); while ($r = $db->fetch($res)) { $plan = array(); for ($i = 1; $i <= 12; $i++) { $plan[$i] = V::get("MONTH_{$i}_VALUE", 0, $r); } $this->_plan[$r->ID_PROJECT] = $plan; } return $this->_plan; } public function _fetchCostsByYear($year) { $db = DB::getDB(); $this->_costs = array(); $sql = " select k.`ID` , k.`ID_PROJECT` AS `ID_PROJECT` , date_format(k.`K_DATA_OTRZYMANEJ_KORESP`,'%Y-%m') AS `MONTH` , k.`COST_VALUE` AS `COST` , k.`INCOME_VALUE` AS `INCOME` , 0 as `TRANSFER_OPPOSITE_ID_PROJECT` -- TRANSFER_OPPOSITE_ID_PROJECT , k.`path` -- , IF(k.`TRANSFER_OPPOSITE_ID_PROJECT`>0 -- , (select p.`path` -- from `IN7_MK_BAZA_DYSTRYBUCJI` p -- where p.`ID`=k.`TRANSFER_OPPOSITE_ID_PROJECT` -- limit 1 -- ) -- , '') as TRANSFER_OPPOSITE_PROJECT_PATH , '' as TRANSFER_OPPOSITE_PROJECT_PATH , k.`K_ZAWARTOS` from `IN7_DZIENNIK_KORESP` k where ((k.`COST_VALUE` > 0) or (k.`INCOME_VALUE` > 0)) and k.`K_DATA_OTRZYMANEJ_KORESP` like '{$year}-%' -- TODO: acl "; //echo'
';print_r($sql);echo'
'; $res = $db->query($sql); while ($r = $db->fetch($res)) { $vProjId = ($r->ID_PROJECT > 0)? $r->ID_PROJECT : 0; $vProjPaths = array(); $vProjIds = array(0 => true); if ($r->ID_PROJECT > 0) { $vProjPaths[] = $r->ID_PROJECT; if (!empty($r->path)) { $vProjPaths[] = $r->path; } } if ($r->TRANSFER_OPPOSITE_ID_PROJECT > 0) { $vProjPaths[] = $r->TRANSFER_OPPOSITE_ID_PROJECT; if (!empty($r->TRANSFER_OPPOSITE_PROJECT_PATH)) { $vProjPaths[] = $r->TRANSFER_OPPOSITE_PROJECT_PATH; } } if (!empty($vProjPaths)) { //echo'

DBG:$r->ID_PROJECT['.$r->ID_PROJECT.']: $vProjPaths = ' . json_encode($vProjPaths) . '

'; $vProjPaths = implode('-', $vProjPaths); $projIds = explode('-', $vProjPaths); //echo'

DBG:$r->ID_PROJECT['.$r->ID_PROJECT.']: $projIds = ' . json_encode($projIds) . '

'; foreach ($projIds as $vProjId) { if ($vProjId > 0) $vProjIds[$vProjId] = true; } } { $projectZeroInfo = new stdClass(); $projectZeroInfo->ID_PROJECT = 0; $projectZeroInfo->costsByMonth = array(); $projectZeroInfo->korespByMonth = array(); $this->_costs[0] = $projectZeroInfo; } foreach ($vProjIds as $vProjId => $vBool) { if (!array_key_exists($vProjId, $this->_costs)) { $projectInfo = new stdClass(); $projectInfo->ID_PROJECT = $vProjId; $projectInfo->costsByMonth = array(); $projectInfo->korespByMonth = array(); $this->_costs[$vProjId] = $projectInfo; } } $korespInfo = new stdClass(); $korespInfo->ID = $r->ID; $korespInfo->MONTH = $r->MONTH; $korespInfo->K_ZAWARTOS = $r->K_ZAWARTOS; $monthNum = intval(substr($r->MONTH, 5, 2)); if ($r->TRANSFER_OPPOSITE_ID_PROJECT > 0) { $korespInfo->COST = $r->COST; $korespInfo->INCOME = $r->INCOME; $korespInfo->TRANSFER_OPPOSITE_ID_PROJECT = $r->TRANSFER_OPPOSITE_ID_PROJECT; $this->_costs[$r->TRANSFER_OPPOSITE_ID_PROJECT]->korespByMonth[$monthNum][] = $korespInfo; } else if ($r->ID_PROJECT) { $korespInfo->COST = $r->COST; $korespInfo->INCOME = $r->INCOME; $this->_costs[$r->ID_PROJECT]->korespByMonth[$monthNum][] = $korespInfo; } else { $korespInfo->COST = $r->COST; $korespInfo->INCOME = $r->INCOME; $this->_costs[0]->korespByMonth[$monthNum][] = $korespInfo; } } return $this->_costs; } private function _fetchProjectInfo() { $db = DB::getDB(); $hasAccessForAllProjects = true; $projectIds = array(); $projectsFromCostIds = array_keys($this->_costs); foreach ($projectsFromCostIds as $idProject) $projectIds[$idProject] = true; $projectsFromPlanIds = array_keys($this->_plan); foreach ($projectsFromPlanIds as $idProject) $projectIds[$idProject] = true; foreach ($projectIds as $idProject => $vBool) $this->_projectInfo[$idProject] = new stdClass(); $projectIds = array_keys($projectIds); $sqlProjIds = "'" . implode("','", $projectIds) . "'"; $sql = " select p.`ID` , p.`P_ID` , p.`path` , p.`M_DIST_DESC` , p.`A_ADM_COMPANY` as aclGroupWrite , p.`A_CLASSIFIED` as aclGroupRead , p.`L_APPOITMENT_USER` as aclOwner from `IN7_MK_BAZA_DYSTRYBUCJI` p where p.`ID` in({$sqlProjIds}) "; $res = $db->query($sql); while ($r = $db->fetch($res)) { $this->_projectInfo[$r->ID]->path = $r->path; $this->_projectInfo[$r->ID]->M_DIST_DESC = $r->M_DIST_DESC; $this->_projectInfo[$r->ID]->aclGroupRead = $r->aclGroupRead; $this->_projectInfo[$r->ID]->hasAccess = $this->_userHasAccessToProject($r); if (!$this->_projectInfo[$r->ID]->hasAccess) $hasAccessForAllProjects = false; } $this->_projectInfo[0]->path = '0'; $this->_projectInfo[0]->M_DIST_DESC = "Wszystkie projekty"; $this->_projectInfo[0]->hasAccess = $hasAccessForAllProjects; } public function hasAccessToProject($idProject) { if ($idProject >= 0) { if (array_key_exists($idProject, $this->_projectInfo)) { return V::get('hasAccess', false, $this->_projectInfo[$idProject]); } } return false; } public function hasGroupsAccessToProjects($idProject, $groups) { $selectedUserGroupNames = array(); $userGroups = User::getLdapGroupsNames(); foreach ($groups as $idGroup) { $selectedUserGroupNames[$idGroup] = $userGroups[$idGroup]; } if ($idProject >= 0) { if (array_key_exists($idProject, $this->_projectInfo)) { $alcGroupRead = V::get('aclGroupRead', null, $this->_projectInfo[$idProject]); if (!$alcGroupRead) { return false; } if (in_array($alcGroupRead, $selectedUserGroupNames)) { return true; } } } return false; } private function _userHasAccessToProject($project) { $groups = User::getLdapGroupsNames(); $userLogin = User::getLogin(); if ($project->aclOwner == $userLogin) { return true; } else if (in_array($project->aclGroupRead, $groups)) { return true; } return false; } public function getUsedUserGroups() { $groups = array(); $userGroups = User::getLdapGroupsNames(); foreach ($this->_projectInfo as $projectInfo) { if (!empty($projectInfo->aclGroupRead)) { $groupKey = array_search($projectInfo->aclGroupRead, $userGroups); if ($groupKey !== false) { $groups[$groupKey] = $projectInfo->aclGroupRead; } } } return $groups; } private function _reacountCostsFromKoresp() { $projMonthHasCostSelfIds = array(); foreach ($this->_costs as $kProjId => $vProjInfo) { $projectPath = $this->_projectInfo[$kProjId]->path; foreach ($vProjInfo->korespByMonth as $kMonthNum => $vKorespList) { $this->_createCostIfNotDefined($kProjId, $kMonthNum); foreach ($vKorespList as $vKoresp) { $this->_costs[$kProjId]->costsByMonth[$kMonthNum]->COST_SELF += $vKoresp->COST; $this->_costs[$kProjId]->costsByMonth[$kMonthNum]->INCOME_SELF += $vKoresp->INCOME; } $projHasCostSelfIds[$kProjId][$kMonthNum] = $projectPath; } } //echo'
$projHasCostSelfIds: ';print_r($projHasCostSelfIds);echo'
'; foreach ($projHasCostSelfIds as $kProjId => $vProjMonthsList) { if ($kProjId <= 0) continue; foreach ($vProjMonthsList as $kMonthNum => $vProjPath) { $vProjPathIds = explode('-', $vProjPath); $vProjPathIds = array_reverse($vProjPathIds); $vProjMonthCostSelf = $this->_costs[$kProjId]->costsByMonth[$kMonthNum]->COST_SELF; $vProjMonthIncomeSelf = $this->_costs[$kProjId]->costsByMonth[$kMonthNum]->INCOME_SELF; foreach ($vProjPathIds as $vProjId) { if ($vProjId == $kProjId) continue; $this->_createCostIfNotDefined($vProjId, $kMonthNum); $this->_costs[$vProjId]->costsByMonth[$kMonthNum]->COST_CHILD += $vProjMonthCostSelf; $this->_costs[$vProjId]->costsByMonth[$kMonthNum]->INCOME_CHILD += $vProjMonthIncomeSelf; } } } // recount total foreach ($this->_costs as $vProjId => $vProjInfo) { foreach ($vProjInfo->costsByMonth as $kMonthNum => $vCost) { $this->_createCostIfNotDefined($vProjId, $kMonthNum); $this->_costs[$vProjId]->costsByMonth[$kMonthNum]->COST_TOTAL = $vCost->COST_SELF + $vCost->COST_CHILD; $this->_costs[$vProjId]->costsByMonth[$kMonthNum]->INCOME_TOTAL = $vCost->INCOME_SELF + $vCost->INCOME_CHILD; } } } private function _createCostIfNotDefined($projId, $monthNum) { if (empty($this->_costs[$projId]->costsByMonth[$monthNum])) { $vEmptyCost = new stdClass(); $vEmptyCost->COST_SELF = 0; $vEmptyCost->INCOME_SELF = 0; $vEmptyCost->COST_CHILD = 0; $vEmptyCost->INCOME_CHILD = 0; $vEmptyCost->COST_TOTAL = 0; $vEmptyCost->INCOME_TOTAL = 0; $this->_costs[$projId]->costsByMonth[$monthNum] = $vEmptyCost; } } public function _buildProjectTree() { $this->_projectPathsOrder = array(); foreach ($this->_projectInfo as $idProject => $projectInfo) { $this->_projectPathsOrder[$projectInfo->path] = $idProject; } //echo'
projPaths: ';print_r($this->_projectPathsOrder);echo'
'; uksort($this->_projectPathsOrder, array($this, 'sortPathsCallback')); //echo'
projPaths sorted: ';print_r($this->_projectPathsOrder);echo'
'; return $this->_projectPathsOrder; } public function sortPathsCallback($a, $b) { $ea = explode('-', $a); $eb = explode('-', $b); $la = count($ea); $lb = count($eb); $lmin = min($la, $lb); for ($i = 0; $i < $lmin; $i++) { if ($ea[$i] < $eb[$i]) { return -1; } else if ($ea[$i] > $eb[$i]) { return 1; } } return $la - $lb; } public function updatePaths() { $sqlList = array(); $sqlList['updateAllPaths'] = <<has_errors()) { throw new Exception("DB Errors: " . implode("\n
", $db->get_errors())); } foreach ($sqlList as $sqlName => $sql) { $res = $db->query($sql); if ($db->has_errors()) { throw new Exception("DB Errors at sql '{$sqlName}': " . implode("\n
", $db->get_errors())); } } } public function reinstall() { $sqlList = array(); $sqlList['RemoveTrigger_BudgetPlan_BeforeInsert'] = "DROP TRIGGER IF EXISTS `projects_budget_year_month_BEFORE_INSERT`"; $sqlList['CreateTrigger_BudgetPlan_BeforeInsert'] = " CREATE DEFINER=`root`@`localhost` TRIGGER `projects_budget_year_month_BEFORE_INSERT` BEFORE INSERT ON `projects_budget_year_month` FOR EACH ROW BEGIN IF NEW.ID_PROJECT IS NOT NULL and NEW.ID_PROJECT>0 THEN SET NEW.path = (select coalesce( (select p.`path` from `IN7_MK_BAZA_DYSTRYBUCJI` p where p.`ID`=NEW.`ID_PROJECT` limit 1) , '?' )); END IF; END "; $sqlList['RemoveTrigger_BudgetPlan_BeforeUpdate'] = "DROP TRIGGER IF EXISTS `projects_budget_year_month_BEFORE_UPDATE `"; // throws errors: // #1146 - Table '{DATABASE_NAME}.P5-MSG:Route_FixZasobPath:ERROR: Loop detected ID=PARENT_ID' doesn't exist // #1146 - Table '{DATABASE_NAME}.P5-MSG:Route_FixZasobPath:ERROR: Parent item not exists' doesn't exist // #1146 - Table '{DATABASE_NAME}.P5-MSG:Route_FixZasobPath:ERROR: Loop detected in path' doesn't exist $sqlList['CreateTrigger_BudgetPlan_BeforeUpdate'] = " CREATE DEFINER=`root`@`localhost` TRIGGER `projects_budget_year_month_BEFORE_UPDATE` BEFORE UPDATE ON `projects_budget_year_month` FOR EACH ROW BEGIN IF NEW.ID_PROJECT IS NULL THEN SET NEW.path = ''; ELSEIF OLD.ID_PROJECT IS NULL or NEW.ID_PROJECT<>OLD.ID_PROJECT THEN IF NEW.ID_PROJECT>0 THEN SET NEW.path = (select coalesce( (select p.`path` from `IN7_MK_BAZA_DYSTRYBUCJI` p where p.`ID`=NEW.`ID_PROJECT` limit 1) , '?')); ELSE SET NEW.path = ''; END IF; END IF; END "; $db = DB::getDB(); if ($db->has_errors()) { throw new Exception("DB Errors: " . implode("\n
", $db->get_errors())); } foreach ($sqlList as $sqlName => $sql) { $res = $db->query($sql); if ($db->has_errors()) { throw new Exception("DB Errors at sql '{$sqlName}': " . implode("\n
", $db->get_errors())); } } } public function planAction() { SE_Layout::gora(); SE_Layout::menu(); $args = array(); $args['year'] = V::get('year', '', $_REQUEST, 'int'); if ($args['year'] > 0) { $_REQUEST['ff_YEAR'] = $_GET['ff_YEAR'] = $args['year']; } $this->menu($args['year']); if ($args['year'] > 0) { ?>
Utwórz plan na kolejny rok na podstawie danych z roku
Zasob Tabela Plan budżetu (projects_budget_year_month) nie istnieje
fetchGroups(); if (!$userAcl->hasTableAcl($zasobObj->ID)) { ?>
Brak uprawnień do tabeli Plan budżetu (projects_budget_year_month)
getTableAcl($zasobObj->ID); $forceTblAclInit = ('1' == V::get('_force', '', $_GET)); $tblAcl->init($forceTblAclInit); $forceFilterInit = array(); $filterInit = new stdClass(); $filterInit->currSortCol = 'ID'; $filterInit->currSortFlip = 'desc'; foreach ($_GET as $k => $v) { if (strlen($k) > 3 && substr($k, 0, 2) == 'f_' && !empty($v)) {// filter prefix $filterInit->$k = $v; } else if (strlen($k) > 4 && substr($k, 0, 3) == 'sf_' && !empty($v)) {// special filter prefix $filterInit->$k = $v; } else if (strlen($k) > 4 && substr($k, 0, 3) == 'ff_' && !empty($v)) {// force filter prefix $fldName = substr($k, 3); $forceFilterInit[$fldName] = $v; } } $tbl = new TableAjax($tblAcl); $tblLabel = array(); if (!empty($zasobObj->DESC_PL)) $tblLabel []= $zasobObj->DESC_PL; if (!empty($zasobObj->OPIS)) $tblLabel []= $zasobObj->OPIS; $tblLabel = implode(" - ", $tblLabel); $tbl->setLabel($tblLabel); $tbl->setFilterInit($filterInit); if (!empty($forceFilterInit)) $tbl->setForceFilterInit($forceFilterInit); $tbl->addRowFunction('edit'); $tbl->addRowFunction('hist'); $tbl->addRowFunction('files'); $tbl->addRowFunction('cp'); $tbl->showProcesInit(false); echo $tbl->render(); SE_Layout::dol(); } }