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 industries_ajax_quymo()
{
if (isset($_GET['p']) && (isset($_GET['sector']) || isset($_GET['industry']))) {
$page = $_GET['p'];
$start = $page * 10;
$db = _db('stockbiz');
if (isset($_GET['sector'])) {
$db->prepare('SELECT SQL_CALC_FOUND_ROWS Symbol, CompanyName FROM _prefix_companyinfo WHERE IndustryID IN
(SELECT IndustryID FROM _prefix_industry WHERE SectorId=:SECTORID) LIMIT :OFFSET,15');
$db->bindValue(':SECTORID', $_GET['sector'], PARAM_INT);
} else {
$db->prepare('SELECT SQL_CALC_FOUND_ROWS Symbol, CompanyName FROM _prefix_companyinfo WHERE IndustryID=:INDUSTRYID LIMIT :OFFSET,15');
$db->bindValue(':INDUSTRYID', $_GET['industry'], PARAM_INT);
}
$db->bindValue(':OFFSET', $start, PARAM_INT);
$db->execute();
if ($result = $db->fetchAll()) {
for ($i = 0; $i < count($result); $i++) {
$db->query('SELECT MarketCapitalization/1000000000 AS MarketCapitalization,
Equity_MRQ/1000000000 AS Equity_MRQ,
TotalAssets_MRQ/1000000000 AS TotalAssets_MRQ,
BasicPE_TTM,PS_MRQ,PB_MRQ,Sales_TTM/1000000000 AS Sales_TTM,Sales_LFY / 1000000000 AS Sales_LFY,
ProfitAfterTax_LFY/1000000000 AS ProfitAfterTax_LFY, ProfitAfterTax_TTM/1000000000 AS ProfitAfterTax_TTM
FROM _prefix_lastestfinancialratios WHERE Symbol=\'' . $result[$i]['Symbol'] . '\'');
if ($obj = $db->fetch()) {
foreach ($obj as $key => $item) {
$obj[$key] = _num_format($obj[$key]);
}
$result[$i]['ratios'] = $obj;
}
}
return json_encode($result);
}
}
return json_encode(false);
}
