|
@@ 126-130 (lines=5) @@
|
| 123 |
|
$query ="select sum(amount) as grand_total from invoices where reseller_id='0'"; |
| 124 |
|
} |
| 125 |
|
$ext_query=$this->db->query($query); |
| 126 |
|
if($ext_query->num_rows() > 0){ |
| 127 |
|
$result_total=$ext_query->result_array(); |
| 128 |
|
$grandtotal=$result_total[0]['grand_total']; |
| 129 |
|
$grand_total=$this->common->currency_decimal($grandtotal).' '.$currency_id; |
| 130 |
|
} |
| 131 |
|
|
| 132 |
|
|
| 133 |
|
if($accountinfo['type'] == 1){ |
|
@@ 1151-1155 (lines=5) @@
|
| 1148 |
|
$query ="select sum(amount) as grand_total from invoices where confirm=1 and accountid=$accountid"; |
| 1149 |
|
|
| 1150 |
|
$ext_query=$this->db->query($query); |
| 1151 |
|
if($ext_query->num_rows() > 0){ |
| 1152 |
|
$result_total=$ext_query->result_array(); |
| 1153 |
|
$grandtotal=$result_total[0]['grand_total']; |
| 1154 |
|
$grand_total=$this->common->currency_decimal($grandtotal).' '.$currency_id; |
| 1155 |
|
} |
| 1156 |
|
|
| 1157 |
|
$invoice_query ="select sum(credit) as grand_credit from invoice_details where accountid=$accountid"; |
| 1158 |
|
$credit_query=$this->db->query($invoice_query); |
|
@@ 1263-1267 (lines=5) @@
|
| 1260 |
|
$query ="select sum(amount) as grand_total from invoices where confirm=1 and accountid=$accountid"; |
| 1261 |
|
|
| 1262 |
|
$ext_query=$this->db->query($query); |
| 1263 |
|
if($ext_query->num_rows() > 0){ |
| 1264 |
|
$result_total=$ext_query->result_array(); |
| 1265 |
|
$grandtotal=$result_total[0]['grand_total']; |
| 1266 |
|
$grand_total=$this->common->currency_decimal($grandtotal).' '.$currency_id; |
| 1267 |
|
} |
| 1268 |
|
|
| 1269 |
|
$invoice_query ="select sum(credit) as grand_credit from invoice_details where accountid=$accountid"; |
| 1270 |
|
$credit_query=$this->db->query($invoice_query); |