File/plugins/ChartDisplay/sql.inc.php

Description

SQL Query libary for ChartDisplay plugin

Functions
sql_select_interesting_quoterecords (line 87)

Select pivotal points within time range

  • stockmaniac-tables: quoterecord, quote
  • access: public
string sql_select_interesting_quoterecords (int $id_user, int $id_stock, int $start, int $end, [string $filter = 'pivotpoint'])
  • int $id_user
  • int $id_stock
  • int $start
  • int $end
  • string $filter
sql_select_quotes (line 27)

select quotes within a time range

  • range to be specified as start and end value
  • both values must be unix timestamps

  • stockmaniac-tables: quote
  • access: public
string sql_select_quotes (int $id_stock, int $start, int $end)
  • int $id_stock
  • int $start
  • int $end
sql_select_transactions (line 54)

select transactions within a time range

  • range as above

  • stockmaniac-tables: order, position_revision
  • access: public
string sql_select_transactions (int $id_position, int $start, int $end)
  • int $id_position
  • int $start
  • int $end

Documentation generated on Sun, 22 Aug 2010 11:20:24 +0200 by phpDocumentor 1.4.3