ea-Geiercode
[ class tree: ea-Geier ] [ index: ea-Geier ] [ all elements ]

Procedural File: assets.db.php

Source Location: /code/assets.db.php

Page Details

database 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.

Link:  http://www.ea-geier.at/
Filesource:  Source Code for this file
Version:  $Id: assets.db.php 130 2007-08-17 14:24:44Z m2mtech $
License:  GNU General Public License Version 2
Copyright:  2007 m2m server software gmbh
Author:  m2mtech <tech@m2m.at>
Includes
require_once ('code/clients.db.php') [line 30]

standard client db functions

[ Top ]

require_once ('code/numbers.inc.php') [line 35]

number functions

[ Top ]

require_once ('code/date.inc.php') [line 40]

date functions

[ Top ]


Functions
dbCountAssetsItems  [line 121]

integer dbCountAssetsItems( eaDB &$db, integer $client, [array $filters = false], [integer $year = false]  )

get number of assets items

Parameters:
eaDB   &$db:  database
integer   $client:  clientID
array   $filters:  filter
integer   $year:  year

API Tags:
Return:  number of items


[ Top ]
dbGetAssetsYears  [line 266]

array dbGetAssetsYears( eaDB &$db, integer $client, [array $where = false]  )

get years in database

Parameters:
eaDB   &$db:  database
integer   $client:  clientID
array   $where:  filter

API Tags:
Return:  templates


[ Top ]
dbLoadAssetsItem  [line 100]

array dbLoadAssetsItem( eaDB &$db, integer $client, integer $item  )

load assets-book item

Parameters:
eaDB   &$db:  database
integer   $client:  clientID
integer   $item:  itemID

API Tags:
Return:  data


[ Top ]
dbLoadAssetsItems  [line 181]

array dbLoadAssetsItems( eaDB &$db, integer $client, [integer $num = 10], [integer $page = 1], [string $sort = false], [array $where = false]  )

load multiple assets book item

Parameters:
eaDB   &$db:  database
integer   $client:  clientID
integer   $num:  number of items
integer   $page:  number page
string   $sort:  sorting string
array   $where:  filtering

API Tags:
Return:  data


[ Top ]
dbPrepareAssetsSQLData  [line 215]

void dbPrepareAssetsSQLData( array &$conf, array &$data  )

prepare the sql data for output

Parameters:
array   &$conf:  configuration data
array   &$data:  assets item


[ Top ]
dbSaveAssetsItem  [line 49]

void dbSaveAssetsItem( eaDB &$db, integer $client, array &$data  )

save assets-book item

Parameters:
eaDB   &$db:  database
integer   $client:  client
array   &$data:  data


[ Top ]


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