|
@@ 257-261 (lines=5) @@
|
| 254 |
|
$invoice_total=''; |
| 255 |
|
$query="SELECT * from invoice_details where item_type='INVPAY' AND invoiceid='$id' ORDER BY created_date ASC"; |
| 256 |
|
$invoice = $this->db_model->getSelect("*", "invoices", array("id"=> $id)); |
| 257 |
|
if ($invoice ->num_rows() > 0) { |
| 258 |
|
$invoice= $invoice->result_array(); |
| 259 |
|
$result=$invoice[0]; |
| 260 |
|
$data['payment_due_date']=$result['due_date']; |
| 261 |
|
} |
| 262 |
|
|
| 263 |
|
$accountdata = $this->db_model->getSelect("*","accounts",array("id"=> $result['accountid'])); |
| 264 |
|
if ($accountdata ->num_rows() > 0) { |
|
@@ 384-388 (lines=5) @@
|
| 381 |
|
$data['invoice_total_query']=$invoice_total_query; |
| 382 |
|
} |
| 383 |
|
$invoice = $this->db_model->getSelect("*", "invoices", array("id"=> $id)); |
| 384 |
|
if ($invoice ->num_rows() > 0) { |
| 385 |
|
$invoice= $invoice->result_array(); |
| 386 |
|
$result=$invoice[0]; |
| 387 |
|
$data['payment_due_date']=$result['due_date']; |
| 388 |
|
} |
| 389 |
|
$invoice_auto_res = $this->db_model->getSelect("sum(debit) as debit", "invoice_details", array("invoiceid"=> $id,'generate_type'=>0)); |
| 390 |
|
$data['invoice_auto_res']=0; |
| 391 |
|
if ($invoice_auto_res ->num_rows() > 0) { |
|
@@ 726-730 (lines=5) @@
|
| 723 |
|
$data['invoice_total_query']=$invoice_total_query; |
| 724 |
|
} |
| 725 |
|
$invoice = $this->db_model->getSelect("*", "invoices", array("id"=> $id)); |
| 726 |
|
if ($invoice ->num_rows() > 0) { |
| 727 |
|
$invoice= $invoice->result_array(); |
| 728 |
|
$result=$invoice[0]; |
| 729 |
|
$data['payment_due_date']=$result['due_date']; |
| 730 |
|
} |
| 731 |
|
|
| 732 |
|
$accountdata = $this->db_model->getSelect("*","accounts",array("id"=> $result['accountid'])); |
| 733 |
|
if ($accountdata ->num_rows() > 0) { |