mardi 19 février 2019

Query not returning ABS value. Want to sum all negative number from column and get result in absolute. Please solve my problem. Thanks in advance

$_query = $obligationModel ->select(DB::raw("abs(SUM(tam_iex_obligation_import.total)) as fundpayin, abs(SUM(tioit.traded_qty)) as totalmw"), 'tam_iex_obligation_import.trade_date', 'tam_iex_obligation_import.portfolio_id', 'tioit.amt','SUM(tam_iex_obligation_import.total) as count111'))

        ->from('tam_iex_obligation_import')

        ->join('tam_iex_obligation_import_tradewise as tioit', 'tioit.tam_iex_obligation_id', '=', 'tam_iex_obligation_import.id', 'left outer')

        ->where('tam_iex_obligation_import.portfolio_id', $_portfolio_id);

    if($_trade_type == 'buy'){
        $_query->where('tioit.amt', '<', '0');
    }else{
        $_query->where('tioit.amt', '>', '0');
    }

    $_query->whereBetween('tam_iex_obligation_import.trade_date', [$_from, $_to])
        ->groupBy('tam_iex_obligation_import.trade_date');



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire