Find Jobs
Hire Freelancers

Add features to Booked/PhpScheduleIT

£20-250 GBP

Lezárt
Kiadva ekkor: körülbelül 9 évvel ezelőtt

£20-250 GBP

Teljesítéskor fizetve
"Booked"previously called PhpScheduleIT is an open source room reservation system. The latest version, 2.5.8 does most of what I am looking for, but I need a couple of additions which I will offer back to the Booked project to extend it to enable Invoices to be produced from Bookings (Reservations). 1. extract the reservation data as a csv file to create invoices, and allow the csv file to be uploaded to the PC - see details below 2. add an Organizations table that links to the User table (ideally using an existing field - e.g. Organization) or some other way that wouldn't corrupt the existing application including the ability to import Organisations/Customers from another application. Will also need Organization maintenance - but see comments on 3 below as well. 3. create an invoice based on a default template to a PDF OR provide an Excel Template with the connection to the remote MySQL database that can create the invoices in Excel. I'm not sure how this would work, especially the selection of the data. DETAILS 1. Extract a reservation based file to use to create invoices; Output FIELDS: customer, resource,description, quantity,unit-cost, total; customer - organisation from user on the reservation, resource name - from reservation table (probably via a lookup to resource table) description - concatenation of: reservation start date and time + reservation title - e.g. "10/01/2015 10:30 Disability group meeting" quantity - meeting duration in hours and fractions of an hour - e.g. 1hr30 = 1.50 price - if price in price custom field on reservation in not zero then use that, use the otherwise hourly rental (custom field on resource) How it should work: records are to be extracted to the csv for a specific organisation, or all organisations, within a date range, sorted by date/time within organization 2. The organizations table should include: Organization_name Organization_address1 Organization_address2 Organization_address3 Organization_postcode Organization_email Organization_phone1 Organization_phone2 Contact_name Contact_address_1 Contact_address_2 Contact_address_3 Contact_postcode Contact_email Contact_phone1 Contact_phone2 This will need a basic data maintenance function which should look and feel the same as the other reference data options such as Resource and User. It should be added to that menu option. 3. Invoice - there are a couple of options here. 3.1 The invoice details that need to created must be editable if the invoice is produced as a PDF from Booked and also make sure of a user configured template. This would be of use to other but eventually I hope to use the extract file and import it to an invoicing application called Sliq Tools. 3.2 There are a couple of other options including generating Invoices into an opensource ERP application such as WebERP. In that case there would also be a small piece of work to do, to take the data and create a link that would use the existing WebERP API to post the data into the Sales Ledger and generate the invoices via the WebERP System. see: [login to view URL] For this to work, I would probably also do something different for Organisation such as use a customer table in the ERP System instead and link the two. 3.3 The 3rd option is to use Excel directly against the new data via a database connection to the remote MySQL database AND to make sure that the templates and data selection work. In theory this might be simpler to develop, but I would need to be sure it could work in a variety of environments including Windows XP, Window 7, Office 2010 and Office 2007 and with 64Bit and 32 bit environments!
Projektazonosító: 7051715

A projektről

8 ajánlat
Távolról teljesíthető projekt
Aktiválva: 9 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
8 szabadúszó adott átlagosan £303 GBP összegű árajánlatot erre a munkára
Felhasználó avatár
Hello! With 99% completion rate, 750 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
£947 GBP 6 napon belül
5,0 (983 értékelés)
8,7
8,7
Felhasználó avatár
Hello Project Manager, I am John Ofagbe a professional web developer and software engineer. I have read through your very detailed project description and I can deliver the 3 major requirements within 3 days. Best regards, John O.
£300 GBP 3 napon belül
4,9 (96 értékelés)
7,1
7,1
Felhasználó avatár
hello there, I'm very interesting about your project. I can start Today. Looking forward to hear you from soon. Thanks
£194 GBP 4 napon belül
5,0 (43 értékelés)
6,2
6,2
Felhasználó avatár
Hi ! I will be happy to develop those new features for you. I have an excellent experience as developer with HTML, PHP, MySQL, Javascript, CSS and jQuery. Details will need to be discuss during the project but I understand what you want. Hope to do business with you. Thx !
£250 GBP 8 napon belül
4,9 (150 értékelés)
6,4
6,4
Felhasználó avatár
Hi, I have read your project description carefully and have done project related to it. We can even chat to make it clear before awarding the project. You can rely on me . Please check my reviews and portfolio. Waiting for your positive reply. Thanks.
£200 GBP 5 napon belül
5,0 (62 értékelés)
5,7
5,7
Felhasználó avatár
A proposal has not yet been provided
£150 GBP 3 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

UNITED KINGDOM zászlója
Tonbridge, United Kingdom
5,0
1
Fizetési mód hitelesítve
Tagság kezdete: aug. 27, 2010

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.