@@ 139-144 (lines=6) @@ | ||
136 | $invoice_query ="select sum(credit) as grand_credit from invoice_details where reseller_id='0'"; |
|
137 | } |
|
138 | $credit_query=$this->db->query($invoice_query); |
|
139 | if($credit_query->num_rows() > 0){ |
|
140 | $credit_total=$credit_query->result_array(); |
|
141 | $grand_credit_total=$credit_total[0]['grand_credit']; |
|
142 | $grandcredit=$grand_total-$grand_credit_total; |
|
143 | $grand_credit=$this->common->currency_decimal($grandcredit).' '.$currency_id; |
|
144 | } |
|
145 | $download="<a href=" . $url .$value['id'].'/00_'.$value['invoice_prefix'].$value['invoiceid']. " class='btn btn-royelblue btn-sm' title='Download Invoice' ><i class='fa fa-cloud-download fa-fw'></i></a> "; |
|
146 | if($value['type'] == 'I'){ |
|
147 | if($value['confirm'] ==0){ |
|
@@ 1159-1164 (lines=6) @@ | ||
1156 | ||
1157 | $invoice_query ="select sum(credit) as grand_credit from invoice_details where accountid=$accountid"; |
|
1158 | $credit_query=$this->db->query($invoice_query); |
|
1159 | if($credit_query->num_rows() > 0){ |
|
1160 | $credit_total=$credit_query->result_array(); |
|
1161 | $grand_credit_total=$credit_total[0]['grand_credit']; |
|
1162 | $grandcredit=$grand_total-$grand_credit_total; |
|
1163 | $grand_credit=$this->common->currency_decimal($grandcredit).' '.$currency_id; |
|
1164 | } |
|
1165 | ||
1166 | ||
1167 | ||
@@ 1271-1276 (lines=6) @@ | ||
1268 | ||
1269 | $invoice_query ="select sum(credit) as grand_credit from invoice_details where accountid=$accountid"; |
|
1270 | $credit_query=$this->db->query($invoice_query); |
|
1271 | if($credit_query->num_rows() > 0){ |
|
1272 | $credit_total=$credit_query->result_array(); |
|
1273 | $grand_credit_total=$credit_total[0]['grand_credit']; |
|
1274 | $grandcredit=$grand_total-$grand_credit_total; |
|
1275 | $grand_credit=$this->common->currency_decimal($grandcredit).' '.$currency_id; |
|
1276 | } |
|
1277 | $download='<a href="'. base_url() .'/user/user_invoice_download/' . $value['id'].'/00'.$value['invoice_prefix'].$value['invoiceid'].'" class="btn btn-royelblue btn-sm" title="Download Invoice" ><i class="fa fa-cloud-download fa-fw"></i></a> '; |
|
1278 | if($outstanding > 0){ |
|
1279 | $payment = ' <a style="padding: 0 8px;" href="'. base_url() .'user/user_invoice_payment/' . $value['id'] . '" class="btn btn-warning" title="Payment">Unpaid</a>'; |