Как условно суммировать значения столбцов в динамически создаваемом запросе CodeIgniter ⇐ Php

[Anonymous]

Как добавить, получив такие запросы?
opbal имея условия и минус и плюс больше нуля?
если минус > nol показать, и все опбал, минус и плюс > nol
// build dynamic parent query SELECT columns
$filter_col = "";
if (isset($filters['warehouse'])) {
foreach ($filters['warehouse'] as $filter_whse) {
$filter_col .= "sum( if( iw.location_id = " . $filter_whse . ", ih.item_qty, 0 ) ) AS location_" . $filter_whse . ",";
$filter_col .= "sum( if( iw.location_id = " . $filter_whse . ", ih.total_value, 0 ) ) AS tot_val_location_" . $filter_whse . ",";
$filter_col .= "sum( if( iw.location_id = " . $filter_whse . " AND ih.doc_date < " . "'" . $filters['date_from'] . "'" . ", ih.item_qty, 0 ) ) AS opening_qty_" . $filter_whse . ",";
$filter_col .= "sum( if( iw.location_id = " . $filter_whse . " AND ih.doc_date >= " . "'" . $filters['date_from'] . "'" . " AND ih.item_qty > 0, ih.item_qty, 0 ) ) AS plus_qty_" . $filter_whse . ",";
$filter_col .= "sum( if( iw.location_id = " . $filter_whse . " AND ih.doc_date >= " . "'" . $filters['date_from'] . "'" . " AND ih.item_qty < 0, ih.item_qty, 0 ) ) AS minus_qty_" . $filter_whse . ",";
}
} else {
$all_location = $this->location_model->get_site_location();
foreach ($all_location as $row_all_location) {
$filter_col .= "sum( if( iw.location_id = " . $row_all_location['location_id'] . ", ih.item_qty, 0 ) ) AS location_" . $row_all_location['location_id'] . ",";
$filter_col .= "sum( if( iw.location_id = " . $row_all_location['location_id'] . ", ih.total_value, 0 ) ) AS tot_val_location_" . $row_all_location['location_id'] . ",";
$filter_col .= "sum( if( iw.location_id = " . $row_all_location['location_id'] . " AND ih.doc_date < " . "'" . $filters['date_from'] . "'" . ", ih.item_qty, 0 ) ) AS opening_qty_" . $row_all_location['location_id'] . ",";
$filter_col .= "sum( if( iw.location_id = " . $row_all_location['location_id'] . " AND ih.doc_date >= " . "'" . $filters['date_from'] . "'" . " AND ih.item_qty > 0, ih.item_qty, 0 ) ) AS plus_qty_" . $row_all_location['location_id'] . ",";
$filter_col .= "sum( if( iw.location_id = " . $row_all_location['location_id'] . " AND ih.doc_date >= " . "'" . $filters['date_from'] . "'" . " AND ih.item_qty < 0, ih.item_qty, 0 ) ) AS minus_qty_" . $row_all_location['location_id'] . ",";
}
}

// build subquery to be JOINed
$this->db->select("*");
$this->db->from("v_itemhistory");
// $this->db->where('doc_date >= ', $filters['date_from']);
$this->db->where('doc_date

Подробнее здесь: https://stackoverflow.com/questions/419 ... iter-query