Source for file purchasebook.db.php

Documentation is available at purchasebook.db.php

<?php
/**
* database functions for purchase 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: purchasebook.db.php 130 2007-08-17 14:24:44Z m2mtech $
* @link http://www.ea-geier.at/
*/
/**
* standard client db functions
*/
require_once('code/clients.db.php');
/**
* number functions
*/
require_once('code/numbers.inc.php');
/**
* date functions
*/
require_once('code/date.inc.php');
/**
* save purchase-book item
*
* @param eaDB database
* @param integer client
* @param array data
*/
function dbSavePurchaseBookItem(&$db, $client, &$data) {
dbChangeToClientDB($db, $client);
// prepare number format
$opt['decimal'] = $db->conf['numNumberDecimal'];
// prepare variables
$vars = array('txtID', 'txtName', 'txtVendor', 'numAmount', 'year', 'month', 'day');
foreach ($vars as $var) if (isset($data[$var])) switch ($var) {
case 'numAmount':
$what[$var] = makeDot($data[$var], $opt['decimal']);
break;
default: $what[$var] = $data[$var];
}
$what['lastModified'] = $db->now();
$what['who'] = $db->user['mail'];
$table = $db->table('purchasebook');
if (isset($data['numID'])) { // old item
$id = $data['numID'];
if (!$db->update($what, $table, array('id' => $id))) return false;
} else {
if (!$db->insert($what, $table)) return false;
if (!$id = $db->lastID()) return false;
}
return $data['numID'] = $id;
}
/**
* load purchase-book item
*
* @param eaDB database
* @param integer clientID
* @param integer itemID
* @return array data
*/
function dbLoadPurchaseBookItem(&$db, $client, $item) {
dbChangeToClientDB($db, $client);
$table = $db->table('purchasebook');
if (!$data = $db->selectOne('*', $table, array('id' => $item))) return false;
dbPreparePurchaseBookSQLData($db->conf, $data);
return $data;
}
/**
* get number of purchase-book items
*
* @param eaDB database
* @param integer clientID
* @param array filter
* @return integer number of items
*/
function dbCountPurchaseBookItems(&$db, $client, $where = false) {
dbChangeToClientDB($db, $client);
$table = $db->table('purchasebook');
$what = 'count(id) as c, sum(numAmount) as numAmount';
if (!$where) $where = '';
if (isset($where['txtName'])) { // we have to prepare it ourselves
$filters = $where;
$where = "txtName like '%" . $db->escape($where['txtName'], true) . "%'";
unset($filters['txtName']);
if ($filters) { // other filters available
foreach ($filters as $key => $value)
$where .= ' and ' . $db->escapeKey($key) . ' = ' . $db->escape($value);
}
}
if (!$dummy = $db->selectOne($what, $table, $where)) return false;
if (!$dummy['c']) return false;
$data['count'] = $dummy['c'];
$data['numAmount'] = $dummy['numAmount'];
dbPreparePurchaseBookSQLData($db->conf, $data);
return $data;
}
/**
* load multiple purchase-book item
*
* @param eaDB database
* @param integer clientID
* @param integer number of items
* @param integer number page
* @param string sorting string
* @param array filtering
* @return array data
*/
function dbLoadPurchaseBookItems(&$db, $client, $num = 10, $page = 1, $sort = false, $where = false) {
dbChangeToClientDB($db, $client);
$table = $db->table('purchasebook');
if (!$where) $where = '';
if (isset($where['txtName'])) { // we have to prepare it ourselves
$filters = $where;
$where = "txtName like '%" . $db->escape($where['txtName'], true) . "%'";
unset($filters['txtName']);
if ($filters) { // other filters available
foreach ($filters as $key => $value)
$where .= ' and ' . $db->escapeKey($key) . ' = ' . $db->escape($value);
}
}
if (!$sort) $sort = 'id asc';
if ($page == -1) $offset = -1;
else $offset = $num * ($page - 1);
if (!$data = $db->select('*', $table, $where, $sort, $num, $offset))
return false;
foreach ($data as $key => $val) dbPreparePurchaseBookSQLData($db->conf, $data[$key]);
return $data;
}
/**
* prepare the sql data for output
*
* @param array configuration data
* @param array purchase-book item
*/
function dbPreparePurchaseBookSQLData(&$conf, &$data) {
static $decimal = false;
static $separator = false;
static $date = false;
if (!$decimal) $decimal = $conf['numNumberDecimal'];
if (!$separator) switch ($conf['txtNumberSeperator']) {
case 'komma':
$separator = ',';
break;
case 'dot': default:
$separator = '.';
break;
}
if (!$date) $date = $conf['txtDateFormat'];
// prepare numbers
$numVars[] = 'numAmount';
foreach ($numVars as $var)
$data[$var] = makeNum($data[$var], $separator, $decimal);
// prepare date
$data['txtDate'] = dateFormat($data, $date);
}
/**
* get months in database
*
* @param eaDB database
* @param integer clientID
* @return array templates
*/
function dbGetPurchaseBookMonths(&$db, $client) {
dbChangeToClientDB($db, $client);
$table = $db->table('purchasebook');
if (!$dummy = $db->select('distinct month, year', $table, '', 'year desc, month desc'))
return false;
foreach ($dummy as $val) {
$comb = $val['year'] . '-' . $val['month'];
switch ($db->conf['txtDateFormat']) {
case 'DD.MM.YYYY':
$months[$comb] = $val['month'] . '.' . $val['year'];
break;
case 'YYYY-MM-DD':
$months[$comb] = $comb;
break;
}
}
return $months;
}
?>

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

Source for file purchasebook.db.php

ea-Geier

Packages: