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

Procedural File: travel.db.php

Source Location: /code/travel.db.php

Page Details

database functions for travelling expenses

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: travel.db.php 134 2007-08-24 17:30:36Z 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
dbCountTravelItems  [line 113]

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

get number of travel items

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

API Tags:
Return:  number of items


[ Top ]
dbGetTravelMonths  [line 229]

array dbGetTravelMonths( eaDB &$db, integer $client  )

get months in database

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

API Tags:
Return:  templates


[ Top ]
dbLoadTravelItem  [line 93]

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

load travel item

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

API Tags:
Return:  data


[ Top ]
dbLoadTravelItems  [line 158]

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

load multiple travel items

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 ]
dbPrepareTravelSQLData  [line 192]

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

prepare the sql data for output

Parameters:
array   &$conf:  configuration data
array   &$data:  travel items


[ Top ]
dbSaveTravelItem  [line 49]

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

save travel item

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


[ Top ]


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