Closed

django annotate

Booking model:

name=Charfield

status=Charfield

guest=FK(user)

I need someone to write a custom annotate for me.

The following works and pulls out all users

guests = [url removed, login to view](uquery, guest__hotel=hotel)\

.annotate(revenue=Sum('ubookings__revenue'))\

however i need a conditional sum based off the above where the status is in a list ["1", "2"]

The custom annotate should pull out all users even if there are no bookings made by the user.

Skills: Django

See more: need someone to write a django, django hotel booking

About the Employer:
( 120 reviews ) Singapore, Singapore

Project ID: #10390052

6 freelancers are bidding on average $117 for this job

SoftDevelopINC

Hello, I would prefer to discuss for further details about this project. I'm a webdeveloper over 6 years experience, I have a lot of experience with PYTHON (Django framework) and solid knowledge MCV and OOP. I'm More

$210 SGD in 2 days
(60 Reviews)
7.2
vaimdev

Hi I'm 7 years experience Django developer who have been programming for 20 years. You don't need a custom annotate but just to restructuring the query properly. Give me the full code of Booking model and sampl More

$56 SGD in 1 day
(5 Reviews)
4.1
Zee93

Hi, I'm a professional django developer and this is an easy task for me. I don't know why other bids are this high - probably because they don't know how to do it -. Anyway, just contact me and I'll send you the code. More

$49 SGD in 0 days
(3 Reviews)
2.7
$111 SGD in 2 days
(0 Reviews)
0.0
rajeshbk042

Expert software engineer - Specialized in Python / Django - Using Django since 1 - Using Python since 2.7 - Experience with test driven development - Active open source contributor - Following More

$120 SGD in 30 days
(0 Reviews)
0.0
obrerosoft

Good day, I am a Software Developer based in Johannesburg, South Africa. I have over 5 years experience in the Web and Software development sector. I believe I am adequately qualified to be able to assist you in th More

$155 SGD in 1 day
(0 Reviews)
0.0