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

Procedural File: cashbook.db.php

Source Location: /code/cashbook.db.php

Page Details
Page Details | Includes | Functions

database functions for cash 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: cashbook.db.php 139 2007-08-29 20:49:58Z m2mtech $
License:  GNU General Public License Version 2
Copyright:  2007 m2m server software gmbh
Author:  m2mtech <tech@m2m.at>
Includes
Page Details | Includes | Functions
require_once ('code/numbers.inc.php') [line 35]

number functions

[ Top ]

require_once ('code/clients.db.php') [line 30]

standard client db functions

[ Top ]


Functions
Page Details | Includes | Functions
dbCountCashBookItems  [line 106]

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

get number of cashbook items

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

API Tags:
Return:  number of items


[ Top ]
dbGetMonths  [line 217]

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

get months in database

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

API Tags:
Return:  templates


[ Top ]
dbGetTemplates  [line 197]

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

get templates

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

API Tags:
Return:  templates


[ Top ]
dbLoadCashBookItem  [line 87]

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

load cash book item

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

API Tags:
Return:  data


[ Top ]
dbLoadCashBookItems  [line 162]

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

load multiple cash 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 ]
dbPrepareSQLData  [line 246]

void dbPrepareSQLData( array &$conf, array &$data, [ $numOnly = false]  )

prepare the sql data for output

Parameters:
array   &$conf:  configuration data
array   &$data:  cashbook item
   $numOnly: 


[ Top ]
dbSaveCashBookItem  [line 44]

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

save cash book item

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


[ Top ]

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