Source for file assets.inc.php

Documentation is available at assets.inc.php

<?php
/**
* php functions for assets book
*
* LICENSE:
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License along
* with this program; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*
* @package ea-Geier
* @subpackage code
* @author m2mtech <tech@m2m.at>
* @license http://www.gnu.org/licenses/gpl.html GNU General Public License Version 2
* @version $Id: assets.inc.php 130 2007-08-17 14:24:44Z m2mtech $
* @link http://www.ea-geier.at/
*/
/**
* html functions for assets book
*/
require_once('code/assets.html.php');
/**
* database functions for assets book
*/
require_once('code/assets.db.php');
/**
* number functions
*/
require_once('code/numbers.inc.php');
/**
* date functions
*/
require_once('code/date.inc.php');
/**
* generate data for html output of assets book
*
* @param eaDB database
* @param eaInput input data
*/
function genOptAssets(&$db, &$in) {
$conf =& $db->conf;
$user =& $db->user;
if (!isset($in->options)) $in->options = array();
$opt =& $in->options;
if (!$clientID = $in->getClient($db)) return false; // wrong client
$opt['assets'] = true; // we are in the assets book section
$opt['assetsurl'] = 'assets';
// prepare number format
$opt['decimal'] = $conf['numNumberDecimal'];
switch ($conf['txtNumberSeperator']) {
case 'komma':
$opt['seperator'] = ',';
break;
case 'dot': default:
$opt['seperator'] = '.';
break;
}
// sorting
$sort = $in->getSort(array('id', 'txtName', 'purchaseDate', 'numAmount'), 'assets');
// pagenumber
if (!$opt['page'] = $in->getPage('assets')) $opt['page'] = 1;
// lines per page
$opt['lines'] = $conf['numLinesPerPage'];
// if javascript is disabled get filter variables from post
if (isset($_POST) && !empty($_POST)) {
$vars = array('p:txt:txt');
$in->check($vars);
}
$where = array();
// filters name
$name = $in->getGet('find', 'txt');
if (!$name) $name = $in->post('txtWhat');
if (isset($in->error['txtWhat']) && ($in->error['txtWhat'] == 'empty')) {
$name = '=';
unset ($in->error['txtWhat']);
}
if (!$name && isset($_SESSION['filter'][$clientID]['assetsname']))
$name = $_SESSION['filter'][$clientID]['assetsname'];
if ($name && ($name != '=')) {
if (strpos($name, '=') !== false) $name = trim(substr($name, 1));
$where['txtName'] = $name;
$_SESSION['filter'][$clientID]['assetsname'] = $name;
$in->post['txtWhat'] = $name;
} elseif (isset($_SESSION['filter'][$clientID]['assetsname']))
unset($_SESSION['filter'][$clientID]['assetsname']);
// get year to show values for for depreciation and value
$year = $in->getGet('depreciation', 'num'); // from depr select
if (!$year) $year = $in->getGet('value', 'num'); // from value select
if (!$year) $year = $in->post('numDepreciation'); // from depr post
if (!$year) $year = $in->post('numValue'); // from value post
if ($year) $_SESSION['show'][$clientID]['assetsyear'] = $year; // store in session
if (!$year && isset($_SESSION['show'][$clientID]['assetsyear']))
$year = $_SESSION['show'][$clientID]['assetsyear']; // from session
if (!$year) $year = date('Y'); // this year
// generate options for heading
$opt['year'] = dbGetAssetsYears($db, $clientID, $where);
if (!isset($opt['year'][$year])) $year = key($opt['year']);
// load items
if (!$opt['itemstotal'] = dbCountAssetsItems($db, $clientID, $where, $year)) {
if ($where) {
$opt['countitems'] = 0;
return true;
}
return false;
} else $opt['countitems'] = $opt['itemstotal']['count'];
$opt['pages'] = ceil($opt['countitems'] / $opt['lines']);
if ($opt['page'] > $opt['pages']) $opt['page'] = 1;
if (!$opt['items'] = dbLoadAssetsItems($db, $clientID, $opt['lines'], $opt['page'], $sort, $where))
return false;
$in->post['numDepreciation'] = $year;
$in->post['numValue'] = $year;
foreach ($opt['items'] as $key => $item) {
$firstYear = reset($item['lines']);
$lastYear = end($item['lines']);
$nullValue = makeNum(0, $opt['seperator'], $opt['decimal']);
if ($firstYear > $year) {
$opt['items'][$key]['numDepreciation'] = $nullValue;
$opt['items'][$key]['numValue'] = $nullValue;
continue;
}
if ($lastYear < $year) {
$opt['items'][$key]['numDepreciation'] = $nullValue;
$opt['items'][$key]['numValue'] = $item['numValue' . key($item['lines'])];
continue;
}
$years = array_flip($item['lines']);
$opt['items'][$key]['numDepreciation'] = $item['numDepreciation' . $years[$year]];
$opt['items'][$key]['numValue'] = $item['numValue' . $years[$year]];
};
return true;
}
function genOptAssetsPrint(&$db, &$in) {
$conf =& $db->conf;
$user =& $db->user;
if (!isset($in->options)) $in->options = array();
$opt =& $in->options;
if (!$clientID = $in->getClient($db)) return false; // wrong client
// prepare number format
$opt['decimal'] = $conf['numNumberDecimal'];
switch ($conf['txtNumberSeperator']) {
case 'komma':
$opt['seperator'] = ',';
break;
case 'dot': default:
$opt['seperator'] = '.';
break;
}
// sorting
$sort = $in->getSort(array('id', 'txtName', 'purchaseDate', 'numAmount'), 'assets');
$where = array();
// filters name
// filters name
if (isset($_SESSION['filter'][$clientID]['assetsname'])) {
$name = $_SESSION['filter'][$clientID]['assetsname'];
if ($name && ($name != '=')) {
if (strpos($name, '=') !== false) $name = trim(substr($name, 1));
$where['txtName'] = $name;
}
}
// get year to show values for for depreciation and value
$year = date('Y'); // this year
if (isset($_SESSION['show'][$clientID]['assetsyear']))
$year = $_SESSION['show'][$clientID]['assetsyear']; // from session
$opt['year'] = dbGetAssetsYears($db, $clientID, $where);
$in->post['numDepreciation'] = $year;
$in->post['numValue'] = $year;
// load items
if (!$opt['itemstotal'] = dbCountAssetsItems($db, $clientID, $where, $year)) {
if ($where) {
$opt['countitems'] = 0;
return true;
}
return false;
} else $opt['countitems'] = $opt['itemstotal']['count'];
if (!$opt['items'] = dbLoadAssetsItems($db, $clientID, -1, -1, $sort, $where))
return false;
foreach ($opt['items'] as $key => $item) {
$firstYear = reset($item['lines']);
$lastYear = end($item['lines']);
$nullValue = makeNum(0, $opt['seperator'], $opt['decimal']);
if ($firstYear > $year) {
$opt['items'][$key]['numDepreciation'] = $nullValue;
$opt['items'][$key]['numValue'] = $nullValue;
continue;
}
if ($lastYear < $year) {
$opt['items'][$key]['numDepreciation'] = $nullValue;
$opt['items'][$key]['numValue'] = $item['numValue' . key($item['lines'])];
continue;
}
$years = array_flip($item['lines']);
$opt['items'][$key]['numDepreciation'] = $item['numDepreciation' . $years[$year]];
$opt['items'][$key]['numValue'] = $item['numValue' . $years[$year]];
};
return true;
}
/**
* generate data for html output of assets book item
*
* @param eaDB database
* @param eaInput input data
*/
function genOptAssetsItem(&$db, &$in) {
$conf =& $db->conf;
$user =& $db->user;
if (!isset($in->options)) $in->options = array();
$opt =& $in->options;
if (!$clientID = $in->getClient($db)) return false; // wrong client
$opt['assets'] = true; // we are in the assets book section
$opt['assetsurl'] = 'assetsitem';
// prepare date format
$opt['dateformat'] = $conf['txtDateFormat'];;
// prepare number format
$opt['decimal'] = $conf['numNumberDecimal'];
switch ($conf['txtNumberSeperator']) {
case 'komma':
$opt['seperator'] = ',';
break;
case 'dot': default:
$opt['seperator'] = '.';
break;
}
$post =& $in->post;
if (!isset($post['numValue1'])) $post['numValue1'] = '';
$post['lines'] = array(1 => date('Y'));
// load old data
if (($itemID = $in->getGet('item'))
&& ($dummy = dbLoadAssetsItem($db, $clientID, $itemID))) {
$in->post =& $dummy;
$post =& $in->post;
$post['numID'] = $post['id'];
// prepare options derived from data
}
return true;
}
/**
* save assets book item
*
* @param eaDB database
* @param eaInput input data
*/
function saveAssetsItem(&$db, &$in) {
if (!isset($_POST['buttonSaveAssetsItem'])) return false;
$in->post['buttonSaveAssetsItem'] = true;
$conf =& $db->conf;
$user =& $db->user;
$clientID = $in->options['client'];
if (!$db->isOwner($clientID)) return false; // wrong client
// check for errors
$vars = array('p:txt:txt', 'p:num:num');
$in->check($vars);
$error =& $in->error;
$post =& $in->post;
$opt =& $in->options;
// calculate values if there are base values
$calc = true;
// txtDate -> check date
if ($dummy = checkDateFormat($post['txtDate'], $conf['txtDateFormat'])) {
$post += $dummy;
$year = $post['year'];
$month = $post['month'];
} else {
$error['txtDate'] = 'wrongformat';
$calc = false;
$year = date('Y');
}
// check depriciation entries
$amount = abs(makeDot($post['numAmount'], $opt['decimal']));
if (!$amount) $calc = false;
$numVars = array('numAmount');
$lifetime = abs($post['numLifeTime']) % 100;
if (!$lifetime) {
$calc = false;
$lifetime = 1;
}
$method = $in->post('txtDeprMethod');
switch ($method) {
case 'lin1': case 'lin6': break;
case 'custom': break;
default:
$method = 'custom';
break;
}
$depr = makeDot($amount / $lifetime);
for ($i = 1; $i <= $lifetime + 1; $i++) {
if ($calc) {
$thisDepr = $depr; // default
if ($i == 1) { // first year might be different
switch ($method) {
case 'lin6':
if ($month > 6) $thisDepr = makeDot($amount / $lifetime / 2);
break;
case 'lin1':
if ($month > 1)
$thisDepr = makeDot((13 - $post['month']) * $amount / $lifetime / 12);
break;
}
}
if ($thisDepr + 1 < $amount) $amount -= $thisDepr;
else {
$thisDepr = $amount;
$amount = 0;
}
switch ($method) {
case 'lin6': case 'lin1':
if (!$thisDepr) break 2;
checkSetValue($in, 'numDepreciation' . $i, $thisDepr);
checkSetValue($in, 'numValue' . $i, $amount);
break;
case 'custom';
if ($i > $lifetime) break 2;
}
} else { if ($i > $lifetime) break; }
$numVars[] = 'numDepreciation' . $i;
$numVars[] = 'numValue' . $i;
$post['lines'][$i] = $year++;
}
$amount = abs(makeDot($post['numAmount']));
for ($i = 1; $i <= $lifetime + 1; $i++) {
if (!isset($post['numDepreciation' . $i])) break;
if (!isset($post['numValue' . $i])) break;
checkSetValue($in, 'numValue' . $i, $amount - makeDot($post['numDepreciation' . $i]));
checkSetValue($in, 'numDepreciation' . $i, $amount - makeDot($post['numValue' . $i]));
$amount = makeDot($post['numValue' . $i]);
}
foreach ($numVars as $var) if (isset($post[$var]))
$post[$var] = makeNum($post[$var], $opt['seperator'], $opt['decimal']);
if ($error) return false; // wrong input
// save item
return dbSaveAssetsItem($db, $clientID, $post);
}
/**
* check & store post variables
*
* @param eaInput input data
* @param string variable name
* @param mixed variable value
*/
function checkSetValue(&$in, $var, $val) {
$error =& $in->error;
$post =& $in->post;
$opt =& $in->options;
if (!isset($post[$var])) { // !var -> set
$post[$var] = makeNum($val, $opt['seperator'], $opt['decimal']);
return true;
}
if (isset($error[$var]) && ($error[$var] == 'empty')) { // empty var -> set
$post[$var] = makeNum($val, $opt['seperator'], $opt['decimal']);
unset($error[$var]);
return true;
}
if (isset($error[$var])) // other error -> do nothing
return false;
if (log10(abs(makeDot($post[$var], $opt['decimal']) - $val)) >= -$opt['decimal'] - 0.1) {
$error[$var] = 'wrongvalue';
return false;
}
return true;
}
?>

Documentation generated on Sun, 09 Sep 2007 17:07:48 +0200 by phpDocumentor 1.3.1

Source for file assets.inc.php

ea-Geier

Packages: