'; $excelContent .= MENU_CASH_FLOW."\n\n"; if($_POST['date_from']!='') { $msg .= REPORT_FROM.': '.$_POST['date_from']; $excelContent .= REPORT_FROM.': '.$_POST['date_from']; } if($_POST['date_to']!='') { $msg .= ' '.REPORT_TO.': '.$_POST['date_to']; $excelContent .= ' '.REPORT_TO.': '.$_POST['date_to']; } if($_POST['customer_id']!='' || $_POST['vendor_id']!='') { $msg .= '
'; $excelContent .= "\n\n"; } if(!empty($_POST['branch_id'])){ $query=mysql_query("SELECT name FROM branches WHERE id = ".$branchId); $data=mysql_fetch_array($query); $msg .= '' . TABLE_BRANCH . ': ' . $data['name']."
"; $excelContent .= TABLE_BRANCH . ": " . $data['name']."\n"; } if($_POST['customer_id']!='') { $query=mysql_query("SELECT CONCAT_WS(' ',firstname,lastname) FROM customers WHERE id=".$_POST['customer_id']); $data=mysql_fetch_array($query); $msg .= ' ' . TABLE_CUSTOMER . ': ' . $data[0]."
"; $excelContent .= " " . TABLE_CUSTOMER . ": " . $data[0]."\n"; } if($_POST['vendor_id']!='') { $query=mysql_query("SELECT name FROM vendors WHERE id=".$_POST['vendor_id']); $data=mysql_fetch_array($query); $msg .= ' ' . TABLE_VENDOR . ': ' . $data[0]."
"; $excelContent .= " " . TABLE_VENDOR . ": " . $data[0]."\n"; } $msg .= '
'; $excelContent .= "\n\n"; echo $this->element('/print/header-report',array('msg'=>$msg)); ?>
|
||
|---|---|---|
| OPERATING ACTIVITIES | ||
| Net Income | ||
| Adjustment for non-cash incomes and expenses | ||
| Changes in working capital | ||
| (Increase)/Decrease in | ||
| Increase/(Decrease) in | ||
| Net Cash from Operating Activities | ||
| INVESTING ACTIVITIES | ||
| Net Cash from Investing Activities | ||
| FINANCING ACTIVITIES | ||
| Borrowing | ||
| Repayment | ||
| Net Cash from Financing Activities | ||
| Net Cash Increase/(Decrease) for Period | ||
| Cash & Bank at Beginning of Period | ||
| Cash & Bank at End of Period | ||
| Total per Statement of Financial Position |