Find Jobs
Hire Freelancers

Django WEB App for cost/payment monitoring

$30-250 USD

In Progress
Posted over 5 years ago

$30-250 USD

Paid on delivery
*** Please do not APPLY if you have not worked on Django/Python and creating WEB Apps using the framework. *** Post your proposal only after going through the details and with information related to similar projects that you have accomplished using django framework. I need a simple web app to track the expenses invoice and the payment invoices for movie releases and to be able to see formatted reports of movie performance (profit or loss). There are around 12 movies released per year by my distribution company. Each movie has expenses and payment invoices and the (sum of payment invoices) minus (the sum of expense invoices) is the final profit of the movie. Expense invoices and payment invoices can be entered in 2 ways 1. Manual entry 2. XML file upload (single or multiple). Attached is an example each of a sample XML file for cost and payment transactions. Each XML tag <DTE> represents one cost invoice or one payment invoice. Following are the minimum models required Movie Cinema Expense Type (Could be poster, Banner, Radio Advertisements and so on) Transaction (could be a expense transaction or a payment transaction) Attendance (By Cinema and by Week) So if the movie releases on 10 October 2018 then 10/10/2018-16/10/2018 is the first week of the movie, 17/10/2018-23/10/2018 is the second week and so on. The movie model should have the following 1. Name 2. Release Date 3. Poster Image The Cinema model should have the following 1. Name 2. Cinema TAX ID Attendance model should have the following 1. Week 2. Cinema 3. Movie 4. Percentage of amount recovered that converts to profit. Attendance detail model should have the following 1. Attendance (foreign key) 2. Date - Date of the week 3. Attendance of that date 4. Amount recovered by cinema from that date. 4. Amount recovered from that date that becomes profit (based on the configured percentage that week). Expense Type model should have the following 1. Description Cost Transaction model should have the following 1. Invoice ID <Folio> 2. Invoice Type <TipoDTE> 3. Amount <MntNeto> 4. Tax on amount <IVA> 5. Total <MntTotal> 6. Company Name <RznSoc> 7. Company TAX ID <RUTEmisor> 8. Product <DscItem> 9. Date <FchEmis> 10. Currency Always CLP in case of XML upload. 11. Currency conversion to USD (if currency is not already USD) based on the exchange rate of the date. 12. Movie (against which the cost or the payment transaction needs to be registered). For a cost invoice, the combination of following will be unique <TipoDTE>, <Folio>, <RUTEmisor> so if a XML is reuploaded, it should not make any changes to the already existing record. Payment Transaction model should have the following 1. Invoice ID <Folio> 2. Amount <MntNeto> 3. Tax on amount <IVA> 4. Total <MntTotal> 5. Cinema <RUTRecep> links to Cinema TAX ID from Cinema model. 6. Product <DscItem> 7. Date <FchEmis> 8. Week (foreign key to attendance) 9. Currency (Always CLP in case of XML upload). 10. Currency conversion to USD (if currency is not already USD) based on the exchange rate of the date. For a payment invoice, the combination of following will be unique <TipoDTE>, <Folio>, <RUTRecep> so if a XML is reuploaded, it should not make any changes to the already existing record. When the user enters a movie page, there should be links to the following 1. Expense Invoices 2. Payment Invoices 3. Report (to see the actual performance) 4. Attendance Report (to see how many people saw the movie) The attendance report should be shown by Cinema and by week in a table/graph.
Project ID: 18604602

About the project

4 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $134 USD for this job
User Avatar
Hi. i am a full web developer with over 5 years on freelancer.com. I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about your project. Thanks. Best Regard
$150 USD in 3 days
4.7 (50 reviews)
6.0
6.0
User Avatar
Django expert I have around 12+yrs of experience in web application development. I have gone through the requirements carefully and it's possible to create the model schemas based on your input. Also we can be able to import the xml (with relationship mapping) data to django models via XSLT mapping. I have a strong expertise in Django specifically in plugin/theme development, data migration, REST API, web services, UI and responsive theming, SEO implementation, Payment integration like Paypal, etc...
$200 USD in 3 days
5.0 (2 reviews)
3.5
3.5
User Avatar
I have team of people who will complete your projct within time line Relevant Skills and Experience Python dikango postgrace sql javascript css
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Creative Designer, rooted in Graphics, Website(Css, Html5, Bootstrap, Php and Mobile App Design and Development. If awarded this job, i will ensure 200% compliance to your specification
$30 USD in 1 day
0.0 (1 review)
0.0
0.0

About the client

Flag of CHILE
Santiago de Chile, Chile
5.0
24
Payment method verified
Member since Apr 17, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.