PDF Statement Generation from MySQL DB

Requirements: Must work on local WAMP server and generate a PDF statement which is similar to the attached. We are able to format the data (listed below) to help you. You will be available via skype Full PDF with company Logo and Footer will be provided to the winning bidder. PDF Statement Generation For Data Stored On Tables: Variables/Selection by user: • Account Number • Statement Date Portfolio type available by account number Subscription entries are available by date and account number Withdrawal entries are available by date and account number Fees and charges are available by date and account number Current valuation available by date and account number Profit and loss % to be calculated by Subscriptions – (Withdrawals + Fees and Charges) and the percentage difference from the Current Valuation All to be calculated by two decimal places Each client also has ownership % by date and account number (hidden from statement). Pages for different holding types/items/stocks per page: • Cash • FTSE 350 • Fixed Income • Fund Holdings • Small Cap Holdings • Cash Movements and Charges All holdings are available by date and portfolio type. Each holding has a holding type, quantity/balance by date and valuation by date. To calculate Balance and valuation for client for each active holding entry during the date, the total balance and valuation of the holding is to be multiplied by the ownership % by date for the client.