function push_user_upcom()
{
$db = _db('eps');
$db->query('call sp_upcom_getCurrentMarketInfo("' . maxTradingDate() . '")');
if ($data = $db->fetch()) {
$obj['MarketIndex'] = _num_format($data['MarketIndex']);
$obj['CHGIndex'] = _num_format($data['CHGIndex']);
$obj['PCTIndex'] = _num_format($data['PCTIndex']);
echo json_encode($obj);
}
exit(0);
}
function currentSession($date)
{
global $_session;
if ($_session == -1) {
$db = _db('eps');
$db->query('call sp_getSession_MarketStat(' . maxTradingDate($date) . ');');
$result = $db->fetch();
$_session = $result['Session'];
//reset lai de o ngoai khong phai connect
$db->connect();
}
return $_session;
}
function securities_ajax_getsymbol()
{
if (!empty($_GET['q']) && !empty($_GET['se'])) {
$se = $_GET['se'];
$q = $_GET['q'];
$db = _db('eps');
$db->query('call sp_getStockSymbolList("' . maxTradingDate() . '",' . $se . ')');
$symbols = $db->fetchAll();
$db->connect();
for ($i = 0; $i < count($symbols); $i++) {
if (strpos(strtolower($symbols[$i]['StockSymbol']), $q) !== false) {
echo $symbols[$i]['StockSymbol'] . '|' . $symbols[$i]['SecurityName'] . "\n";
}
}
}
}
<?php
$fromDate = _db_date();
$toDate = _db_date();
$maxTradingDate = maxTradingDate();
if (!empty($_GET['fromdate']) && strtotime($_GET['fromdate'])) {
$fromDate = _db_date($_GET['fromdate']);
}
if (!empty($_GET['todate']) && strtotime(_db_date($_GET['todate']))) {
$toDate = _db_date($_GET['todate']);
}
$tmpFromDate = strtotime($fromDate);
$tmpToDate = strtotime($toDate);
$tmpMaxTradingDate = strtotime($maxTradingDate);
if ($tmpToDate < $tmpMaxTradingDate) {
$maxTradingDate = $toDate;
}
if ($tmpFromDate > $tmpToDate) {
$fromDate = $toDate;
}
function companydetail_user_overview()
{
$symbol = $_GET['symbol'];
$db = _db('stockbiz');
$db->prepare('SELECT c.Symbol, CompanyName, Overview, HeadQuarters,WebAddress,IF(Bourse="HASTC","HASE",Bourse) AS Bourse, IF(Bourse="HASTC",2,1) AS SeId, c.IndustryID, i.Name AS IndustryName,
s.Name AS SectorName, s.SectorId,AvgVolume10d, MarketCapitalization /1000000000 AS MarketCapitalization, SharesOutstanding/1000000 AS SharesOutstanding,Employees,Branches,
DilutedPE_LFY,DilutedPE_TTM,PS_TTM,PS_LFY,PS_MRQ,PB_MRQ,DilutedEPS_LFY,DilutedEPS_TTM,QuickRatio_MRQ,CurrentRatio_MRQ,TotalDebtOverEquity_MRQ,TotalDebtOverAssets_MRQ,
AssetsTurnover_TTM,InventoryTurnover_TTM,GrossMargin_TTM*100 AS GrossMargin_TTM,GrossMargin_LFY*100 AS GrossMargin_LFY,OperatingMargin_TTM*100 AS OperatingMargin_TTM,
OperatingMargin_LFY*100 AS OperatingMargin_LFY,EBITMargin_TTM*100 AS EBITMargin_TTM, EBITMargin_LFY*100 AS EBITMargin_LFY,ProfitMargin_TTM *100 AS ProfitMargin_TTM,
ProfitMargin_LFY*100 AS ProfitMargin_LFY,ROA_TTM*100 AS ROA_TTM,ROA_LFY*100 AS ROA_LFY,ROE_LFY*100 AS ROE_LFY,ROE_TTM*100 AS ROE_TTM,
BasicEPSGrowth_TTM*100 AS BasicEPSGrowth_TTM, BasicEPSGrowth_LFY*100 AS BasicEPSGrowth_LFY,SalesGrowth_TTM*100 AS SalesGrowth_TTM,SalesGrowth_LFY*100 AS SalesGrowth_LFY,
ProfitGrowth_TTM*100 AS ProfitGrowth_TTM,TotalAssetsGrowth_TTM*100 AS TotalAssetsGrowth_TTM,TotalAssetsGrowth_LFY*100 AS TotalAssetsGrowth_LFY
FROM _prefix_companyinfo c, _prefix_industry i, _prefix_sector s, _prefix_lastestfinancialratios f
WHERE c.Symbol=:SYMBOL AND c.IndustryID=i.IndustryId AND s.SectorId=i.SectorId AND f.Symbol=c.Symbol');
$db->bindValue(':SYMBOL', $symbol, PARAM_STR);
$db->execute();
//echo $db->error();
if ($result = $db->fetch()) {
//Lay cac tin tuc lien quan
$db1 = _db();
$db1->query('SELECT SQL_CALC_FOUND_ROWS news_id, news_title, news_created FROM _prefix_news WHERE parent_id=4 AND (news_title LIKE "%' . $symbol . '%" OR symbol="' . $symbol . '") ORDER BY news_created DESC LIMIT 0,10');
if ($news = $db1->fetchAll()) {
$data['newsgroup3'] = $news;
}
$db1->query('SELECT SQL_CALC_FOUND_ROWS news_id, news_title, news_created FROM _prefix_news WHERE parent_id<>4 AND (news_title LIKE "%' . $symbol . '%" OR content LIKE "%' . $symbol . '%" OR symbol="' . $symbol . '") ORDER BY news_created DESC LIMIT 0,10');
if ($news = $db1->fetchAll()) {
$data['newsgroup'] = $news;
}
$data['company'] = $result;
$data['chart_today'] = date("Y-m-d");
$data['chart_startdate'] = date("Y-m-d", mktime(0, 0, 0, date("m", strtotime("now")) - 6, date("d", strtotime("now")), date("Y", strtotime("now"))));
$maxTradingDate = maxTradingDate();
$db1 = _db('eps');
$db1->connect();
if ($result['Bourse'] == 'HOSE') {
$db1->query('call tradingboard.sp_current_security("' . $maxTradingDate . '")');
if ($obj = $db1->fetch()) {
$data['quotes'] = $obj;
}
} else {
$db1->query('call tradingboard.sp_HN_getCurrentStockInfo("' . $maxTradingDate . '")');
if ($obj = $db1->fetch()) {
$data['quotes']['PriorClosePrice'] = $obj['BasicPrice'];
$data['quotes']['OpenPrice'] = $obj['OpenPrice'];
$data['quotes']['LastVal'] = $obj['NmTotalTradedQtty'];
}
}
trackSymbol($symbol);
return $data;
}
_redirect('/doanh-nghiep/cong-ty/index.html');
}
