| @@ 33-42 (lines=10) @@ | ||
| 30 | $conditions['limit'] = $_GET['iDisplayLength']; |
|
| 31 | } |
|
| 32 | ||
| 33 | if ( isset( $_GET['iSortCol_0'] ) ) |
|
| 34 | { |
|
| 35 | for ( $i=0 ; $i < intval( $_GET['iSortingCols'] ) ; $i++ ) |
|
| 36 | { |
|
| 37 | if ( $_GET[ 'bSortable_' . intval($_GET['iSortCol_' . $i]) ] == "true" ) |
|
| 38 | { |
|
| 39 | $conditions['order'] = array('Produto.' . $aColumns[intval($_GET['iSortCol_' . $i])] => $_GET['sSortDir_'.$i]); |
|
| 40 | } |
|
| 41 | } |
|
| 42 | } |
|
| 43 | ||
| 44 | if ( isset( $_GET['sSearch'] ) && !empty( $_GET['sSearch'] ) ) |
|
| 45 | { |
|
| @@ 163-172 (lines=10) @@ | ||
| 160 | $sql .= ' LIMIT ' . $_GET['iDisplayLength'] . ' OFFSET ' . $_GET['iDisplayStart']; |
|
| 161 | } |
|
| 162 | ||
| 163 | if ( isset( $_GET['iSortCol_0'] ) ) |
|
| 164 | { |
|
| 165 | for ( $i=0 ; $i < intval( $_GET['iSortingCols'] ) ; $i++ ) |
|
| 166 | { |
|
| 167 | if ( $_GET[ 'bSortable_' . intval($_GET['iSortCol_' . $i]) ] == "true" ) |
|
| 168 | { |
|
| 169 | $conditions['order'] = array('Produto.' . $aColumns[intval($_GET['iSortCol_' . $i])] => $_GET['sSortDir_'.$i]); |
|
| 170 | } |
|
| 171 | } |
|
| 172 | } |
|
| 173 | ||
| 174 | if ( isset( $_GET['sSearch'] ) && !empty( $_GET['sSearch'] ) ) |
|
| 175 | { |
|
| @@ 817-826 (lines=10) @@ | ||
| 814 | $conditions['limit'] = $_GET['iDisplayLength']; |
|
| 815 | } |
|
| 816 | ||
| 817 | if ( isset( $_GET['iSortCol_0'] ) ) |
|
| 818 | { |
|
| 819 | for ( $i=0 ; $i < intval( $_GET['iSortingCols'] ) ; $i++ ) |
|
| 820 | { |
|
| 821 | if ( $_GET[ 'bSortable_' . intval($_GET['iSortCol_' . $i]) ] == "true" ) |
|
| 822 | { |
|
| 823 | $conditions['order'] = array('VendaItensProduto.' . $aColumns[intval($_GET['iSortCol_' . $i])] => $_GET['sSortDir_'.$i]); |
|
| 824 | } |
|
| 825 | } |
|
| 826 | } |
|
| 827 | ||
| 828 | if ( isset( $_GET['sSearch'] ) && !empty( $_GET['sSearch'] ) ) |
|
| 829 | { |
|
| @@ 93-102 (lines=10) @@ | ||
| 90 | $conditions['limit'] = $_GET['iDisplayLength']; |
|
| 91 | } |
|
| 92 | ||
| 93 | if ( isset( $_GET['iSortCol_0'] ) ) |
|
| 94 | { |
|
| 95 | for ( $i=0 ; $i < intval( $_GET['iSortingCols'] ) ; $i++ ) |
|
| 96 | { |
|
| 97 | if ( $_GET[ 'bSortable_' . intval($_GET['iSortCol_' . $i]) ] == "true" ) |
|
| 98 | { |
|
| 99 | $conditions['order'] = array('Venda.' . $aColumns[intval($_GET['iSortCol_' . $i])] => $_GET['sSortDir_'.$i]); |
|
| 100 | } |
|
| 101 | } |
|
| 102 | } |
|
| 103 | ||
| 104 | if ( isset( $_GET['sSearch'] ) && !empty( $_GET['sSearch'] ) ) |
|
| 105 | { |
|
| @@ 201-211 (lines=11) @@ | ||
| 198 | ) |
|
| 199 | ); |
|
| 200 | ||
| 201 | if ( isset( $_GET['iSortCol_0'] ) ) |
|
| 202 | { |
|
| 203 | for ( $i=0 ; $i < intval( $_GET['iSortingCols'] ) ; $i++ ) |
|
| 204 | { |
|
| 205 | if ( $_GET[ 'bSortable_' . intval($_GET['iSortCol_' . $i]) ] == "true" ) |
|
| 206 | { |
|
| 207 | $conditions['order'] = array( |
|
| 208 | 'LancamentoVenda.' . $aColumns[intval($_GET['iSortCol_' . $i])] => $_GET['sSortDir_' . $i]); |
|
| 209 | } |
|
| 210 | } |
|
| 211 | } |
|
| 212 | ||
| 213 | if ( isset( $_GET['sSearch'] ) && !empty( $_GET['sSearch'] ) ) |
|
| 214 | { |
|