PHP buildInsertSQL Examples

Example #1

File: feed.feedsector.php Project: quangbt2005/vhost-kis

function feedsector_feed_main()
{
    global $_configs;
    $url = 'http://datafeed.stockbiz.vn/CompanyService.asmx?WSDL';
    $params = array('userName' => $_configs['stockbiz_user'], 'password' => $_configs['stockbiz_pass']);
    if ($objs = _feed_stockbiz('GetSectors', $url, $params)) {
        $db = _db('stockbiz');
        $objs = $objs['GetSectorsResult']['Sector'];
        $db->query('TRUNCATE TABLE _prefix_sector');
        for ($i = 0; $i < count($objs); $i++) {
            $sql = buildInsertSQL('_prefix_sector', $objs[$i]);
            $db->query($sql);
        }
    }
}

Example #2

File: feed.feedindustry.php Project: quangbt2005/vhost-kis

function feedIndustryBySector($sectorId)
{
    global $_configs;
    $url = 'http://datafeed.stockbiz.vn/CompanyService.asmx?WSDL';
    $params = array('userName' => $_configs['stockbiz_user'], 'password' => $_configs['stockbiz_pass'], 'sectorID' => $sectorId);
    if ($objs = _feed_stockbiz('GetIndustries', $url, $params)) {
        $db = _db('stockbiz');
        $objs = $objs['GetIndustriesResult']['Industry'];
        //Xoa nhung industry co hien tai, de du lieu luon tuoi
        $db->query('DELETE FROM _prefix_industry WHERE SectorId=' . $sectorId);
        for ($i = 0; $i < count($objs); $i++) {
            $sql = buildInsertSQL('_prefix_industry', $objs[$i]);
            $db->query($sql);
        }
    }
}

Example #3

File: feed.feedlastestfinalratios.php Project: quangbt2005/vhost-kis

function feedLastestFinalRatiosBySymbol($symbol)
{
    global $_configs;
    $url = 'http://datafeed.stockbiz.vn/FinanceService.asmx?WSDL';
    $params = array('userName' => $_configs['stockbiz_user'], 'password' => $_configs['stockbiz_pass'], 'symbol' => $symbol);
    if ($obj = _feed_stockbiz('GetLastestFinancialRatios', $url, $params)) {
        /*if ($symbol=='BBS'){
        			var_dump($obj);
        			die('dasdsa');
        		}*/
        $obj = $obj['GetLastestFinancialRatiosResult'];
        $db = _db('stockbiz');
        $db->query('DELETE FROM _prefix_lastestfinancialratios WHERE Symbol=\'' . $symbol . '\'');
        $obj['Symbol'] = $symbol;
        $sql = buildInsertSQL('_prefix_lastestfinancialratios', $obj);
        $db->query($sql);
        //echo $db->error();
    }
}

Example #4

File: feed.feedfinancialreport.php Project: quangbt2005/vhost-kis

function feedBalanceSheetsByYear($symbol)
{
    global $_configs, $year;
    $url = 'http://datafeed.stockbiz.vn/FinanceService.asmx?WSDL';
    $params = array('userName' => $_configs['stockbiz_user'], 'password' => $_configs['stockbiz_pass'], 'symbol' => $symbol, 'year' => $year, 'count' => 1);
    if ($objs = _feed_stockbiz('GetLastestBalanceSheetsByYear', $url, $params)) {
        if (!empty($objs['GetLastestBalanceSheetsByYearResult'])) {
            $db = _db('stockbiz');
            $db->query('DELETE FROM _prefix_financialreport WHERE Symbol="' . $symbol . '" AND Quarter=0 AND type=0');
            if (!isset($objs['GetLastestBalanceSheetsByYearResult']['FinancialReport'][0])) {
                $obj = $objs['GetLastestBalanceSheetsByYearResult']['FinancialReport'];
                $obj['type'] = 0;
                $sql = buildInsertSQL('_prefix_financialreport', $obj);
                $db->query($sql);
            } else {
                $objs = $objs['GetLastestBalanceSheetsByYearResult']['FinancialReport'];
                for ($i = 0; $i < count($objs); $i++) {
                    $objs[$i]['type'] = 0;
                    $sql = buildInsertSQL('_prefix_financialreport', $objs[$i]);
                    $db->query($sql);
                }
            }
        }
    }
}

Example #5

File: feed.feedsymbol.php Project: quangbt2005/vhost-kis

function feedMajorHolder($symbol)
{
    global $_configs;
    $url = 'http://datafeed.stockbiz.vn/CompanyService.asmx?WSDL';
    $params = array('userName' => $_configs['stockbiz_user'], 'password' => $_configs['stockbiz_pass'], 'symbol' => $symbol);
    if ($objs = _feed_stockbiz('GetMajorHolders', $url, $params)) {
        if (!empty($objs['GetMajorHoldersResult'])) {
            $db = _db('stockbiz');
            $db->query('DELETE FROM _prefix_majorholder WHERE Symbol="' . $symbol . '"');
            if (!isset($objs['GetMajorHoldersResult']['MajorHolder'][0])) {
                $objs['GetMajorHoldersResult']['MajorHolder']['Symbol'] = $symbol;
                $sql = buildInsertSQL('_prefix_majorholder', $objs['GetMajorHoldersResult']['MajorHolder']);
                $db->query($sql);
            } else {
                $objs = $objs['GetMajorHoldersResult']['MajorHolder'];
                for ($i = 0; $i < count($objs); $i++) {
                    $objs[$i]['Symbol'] = $symbol;
                    $sql = buildInsertSQL('_prefix_majorholder', $objs[$i]);
                    $db->query($sql);
                }
            }
        }
    } else {
        die;
    }
}