function quotazione() { $conn = $this->get_connection(); $quote = new Quote(); $quotes = $quote->find_all(array('where_clause' => "`isin` = '{$conn->escape($_GET['isin'])}' ", 'order_by' => '`data` DESC, `ora` DESC ', 'limit' => 1)); $quotazione = $quotes[0]->quotazione; die('({quotazione:' . $quotazione . '})'); }
function index() { $conn = $this->get_connection(); $dividend_factory = new Dividend(); //set_default_dir('up'); $this->dividends = $dividend_factory->find_by_query('SELECT `creso_dividendi`.`id`, `creso_dividendi`.`stacco`, `creso_dividendi`.`importo`, `creso_dividendi`.`isin`, `creso_titoli`.`title` ' . 'FROM `creso_dividendi` ' . 'LEFT JOIN `creso_titoli` ON `creso_dividendi`.`isin` = `creso_titoli`.`isin` ' . "WHERE 1 " . (!empty($_REQUEST['mercato']) ? "AND `mercato` = '{$conn->escape($_REQUEST['mercato'])}' " : '') . (!empty($_REQUEST['tipo']) ? "AND `tipo` = '{$conn->escape($_REQUEST['tipo'])}' " : '') . (!empty($_REQUEST['from']) ? "AND `stacco` >= '{$conn->escape($_REQUEST['from'])}' " : '') . (!empty($_REQUEST['to']) ? "AND `stacco` <= '{$conn->escape($_REQUEST['to'])}' " : '') . 'ORDER BY ' . sprintf('`%s` %s ', $this->get_sort('stacco'), $this->get_dir()) . "LIMIT {$conn->escape($this->get_start())}, {$conn->escape($this->get_limit())}"); if (count($this->dividends) > 0) { foreach ($this->dividends as $dividend) { $dividend->stock = new Stock(); $dividend->stock->find_by_id($dividend->isin); $quote = new Quote(); $quotes = $quote->find_all(array('where_clause' => "`isin` = '{$conn->escape($dividend->isin)}' ", 'order_by' => '`data` DESC, `ora` DESC', 'limit' => 1)); $dividend->quote = $quotes[0]; } } }
function index() { $conn = $this->get_connection(); $item_factory = new WatchlistItem(); $this->items = $item_factory->find_all(array('where_clause' => "`utente` = '{$conn->escape($_COOKIE['username'])}' ", 'order_by' => sprintf('`%s` %s', $this->get_sort('isin'), $this->get_dir()), 'limit' => $this->get_limit())); if (count($this->items) > 0) { foreach ($this->items as $item) { $item->stock = new Stock(); $item->stock->find_by_id($item->isin); $quote = new Quote(); $quotes = $quote->find_all(array('where_clause' => "`isin` = '{$conn->escape($item->isin)}' ", 'order_by' => '`data` DESC, `ora` DESC', 'limit' => 1)); $item->quote = $quotes[0]; $quotes = $quote->find_by_query('SELECT `id`, `quotazione` ' . 'FROM `creso_quotazioni` ' . "WHERE `isin` = '{$conn->escape($item->isin)}' " . "AND `data` >= '{$conn->escape(date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y') - 1)))}' " . 'ORDER BY `quotazione` DESC ' . 'LIMIT 1'); $item->max_quote = $quotes[0]; $quotes = $quote->find_by_query('SELECT `id`, `quotazione` ' . 'FROM `creso_quotazioni` ' . "WHERE `isin` = '{$conn->escape($item->isin)}' " . "AND `data` >= '{$conn->escape(date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y') - 1)))}' " . 'ORDER BY `quotazione` ASC ' . 'LIMIT 1'); $item->min_quote = $quotes[0]; } } }
private function synthesize_portfolio_stocks() { $conn = $this->get_connection(); $quote_factory = new Quote(); $quote = $quote_factory->find_all(array('where_clause' => "`isin` = '{$conn->escape($_REQUEST['isin'])}' " . "AND `data` <= '{$conn->escape(date('Y-m-d'))}'", 'order_by' => '`data` DESC', 'limit' => 1))[0]; $portfolio_stock = new PortfolioStock(array('isin' => $_REQUEST['isin'], 'quantita' => 1000)); $portfolio_stock->prezzo = $quote->quotazione; $portfolio_stocks[] = $portfolio_stock; return $portfolio_stocks; }
function roi() { $conn = $this->get_connection(); $stock_factory = new PortfolioStock(); $portfolio_stocks = $stock_factory->find_all(array('where_clause' => "`utente` = '{$conn->escape($_COOKIE['username'])}' AND `isin` = '{$conn->escape($_GET['id'])}'")); $this->stock = $portfolio_stocks[0]; $this->stock->stock = new Stock(); $this->stock->stock->find_by_id($this->stock->isin); $quote = new Quote(); $quotes = $quote->find_all(array('where_clause' => "`isin` = '{$conn->escape($this->stock->isin)}' ", 'order_by' => '`data` DESC, `ora` DESC', 'limit' => 1)); $this->stock->quote = $quotes[0]; $this->render(array('layout' => 'portfolio_roi')); }