$_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