class DeveloperApplication(models.Model): first_name = models.CharField(max_length=30) last_name = models.CharField(max_length=30) email = models.EmailField(unique=True, validators=[validate_email]) phone_number = models.CharField(max_length=15) country = CountryField() city = models.CharField(max_length=50) stack = models.TextField() experience = models.TextField() discovery_story = models.TextField() status = models.PositiveSmallIntegerField( choices=APPLICATION_STATUS_CHOICES, help_text=','.join([ '%s - %s' % (item[0], item[1]) for item in APPLICATION_STATUS_CHOICES ]), default=REQUEST_STATUS_INITIAL) created_at = models.DateTimeField(auto_now_add=True) confirmation_key = models.UUIDField(default=uuid.uuid4, editable=False, unique=True) confirmation_sent_at = models.DateTimeField(blank=True, null=True, editable=False) used = models.BooleanField(default=False) used_at = models.DateTimeField(blank=True, null=True, editable=False) def __str__(self): return self.display_name @property def display_name(self): return '%s %s' % (self.first_name, self.last_name) @property def country_name(self): return self.country.name country_name.fget.short_description = 'country'
class Project(models.Model): user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='projects_created', on_delete=models.DO_NOTHING) title = models.CharField(max_length=200) description = models.TextField() owner = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='projects_owned', on_delete=models.DO_NOTHING, blank=True, null=True) pm = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='projects_managed', on_delete=models.DO_NOTHING, blank=True, null=True) skills = tagulous.models.TagField(Skill, blank=True) budget = models.DecimalField(max_digits=17, decimal_places=2, blank=True, null=True, default=None) currency = models.CharField(max_length=5, choices=CURRENCY_CHOICES_EUR_ONLY, default=CURRENCY_EUR) type = models.ManyToManyField(ProjectType, blank=True) expected_duration = models.CharField( max_length=20, choices=PROJECT_EXPECTED_DURATION_CHOICES, blank=True, null=True) stage = models.CharField(max_length=20, choices=PROJECT_STAGE_CHOICES, default=PROJECT_STAGE_ACTIVE) # State identifiers client_survey_enabled = models.BooleanField(default=True) pm_updates_enabled = models.BooleanField(default=True) closed = models.BooleanField(default=False) archived = models.BooleanField(default=False) # Significant event dates start_date = models.DateTimeField(blank=True, null=True) deadline = models.DateTimeField(blank=True, null=True) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) closed_at = models.DateTimeField(blank=True, null=True) archived_at = models.DateTimeField(blank=True, null=True) participants = models.ManyToManyField(settings.AUTH_USER_MODEL, through='Participation', through_fields=('project', 'user'), related_name='project_participants', blank=True) legacy_id = models.PositiveIntegerField(blank=True, null=True) migrated_at = models.DateTimeField(blank=True, null=True) hubspot_deal_id = models.CharField(editable=False, null=True, max_length=12) activity_objects = GenericRelation( Action, object_id_field='target_object_id', content_type_field='target_content_type', related_query_name='projects') def __str__(self): return self.title class Meta: ordering = ['-created_at'] @allow_staff_or_superuser def is_participant(self, user, active=True): if user == self.user or user == self.owner: return True elif user.is_project_manager and self.pm == user: return True elif user.is_developer and self.participation_set.filter( user=user, status__in=active and [STATUS_ACCEPTED] or [STATUS_ACCEPTED, STATUS_INITIAL]).count() > 0: return True else: return False @staticmethod @allow_staff_or_superuser def has_read_permission(request): return True @allow_staff_or_superuser def has_object_read_permission(self, request): return True @staticmethod @allow_staff_or_superuser def has_write_permission(request): return request.user.is_project_owner or request.user.is_project_manager @allow_staff_or_superuser def has_object_write_permission(self, request): return request.user == self.user or request.user == self.owner or request.user == self.pm @property def margin(self): from tunga_payments.models import Invoice sales_amount = Invoice.objects.filter( project=self, type=INVOICE_TYPE_SALE).aggregate(Sum('amount')) project_amount = Invoice.objects.filter( project=self, type=INVOICE_TYPE_PURCHASE).aggregate(Sum('amount')) sales_amount = sales_amount['amount__sum'] or 0 project_amount = project_amount['amount__sum'] or 0 return sales_amount - project_amount
class Participation(models.Model): project = models.ForeignKey(Project, on_delete=models.CASCADE) user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='project_participation', on_delete=models.DO_NOTHING) status = models.CharField(max_length=20, choices=REQUEST_STATUS_CHOICES, help_text=','.join([ '%s - %s' % (item[0], item[1]) for item in REQUEST_STATUS_CHOICES ]), default=STATUS_INITIAL) updates_enabled = models.BooleanField(default=True) update_days = models.CharField(default=','.join(UPDATE_DAYS), max_length=40) created_by = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='project_participants_added') created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) responded_at = models.DateTimeField(blank=True, null=True) legacy_id = models.PositiveIntegerField(blank=True, null=True) migrated_at = models.DateTimeField(blank=True, null=True) def __str__(self): return '#{} | {} - {}'.format( self.id, self.user.get_short_name() or self.user.username, self.project.title) class Meta: unique_together = ('user', 'project') ordering = ['-created_at'] verbose_name_plural = 'participation' def save(self, force_insert=False, force_update=False, using=None, update_fields=None): if self.status != STATUS_INITIAL and self.responded_at is None: self.responded_at = datetime.datetime.utcnow() super(Participation, self).save(force_insert=force_insert, force_update=force_update, using=using) @staticmethod @allow_staff_or_superuser def has_read_permission(request): return True @allow_staff_or_superuser def has_object_read_permission(self, request): return self.project.is_participant(request.user, active=False) @staticmethod @allow_staff_or_superuser def has_write_permission(request): return request.user.is_project_owner or request.user.is_project_manager @allow_staff_or_superuser def has_object_write_permission(self, request): allowed_users = [self.created_by, self.user, self.project.user] for user in [self.project.owner, self.project.pm]: if user: allowed_users.append(user) return request.user in allowed_users
class Profile(AbstractUser): address = models.CharField(max_length=255, blank=True, null=True) address2 = models.CharField(max_length=255, blank=True, null=True) city = models.CharField(max_length=255, blank=True, null=True) state = models.CharField(max_length=255, blank=True, null=True) country = models.CharField(max_length=100, blank=True, null=True) country_code = models.CharField(max_length=100, blank=True, null=True) zipcode = models.IntegerField(blank=True, null=True) location = models.CharField(max_length=100, blank=True, null=True) capacity = models.IntegerField(blank=True, null=True) notes = models.TextField(blank=True, null=True) photo = models.ImageField(blank=True, null=True, upload_to=path_and_rename) skills = tagulous.models.TagField(to=Skills, blank=True) signup_code = models.CharField(max_length=25, blank=True, null=True) title = models.CharField(max_length=100, blank=True, null=True) roles = models.ManyToManyField(Role, blank=True) stripe = models.CharField(max_length=255, blank=True, null=True) stripe_connect = models.CharField(max_length=255, blank=True, null=True) verification = models.CharField(max_length=255, default='unverified') payouts_enabled = models.BooleanField(default=False) biography = models.TextField(blank=True, null=True) long_description = models.TextField(blank=True, null=True) objects = CustomUserManager() email_notifications = models.BooleanField(default=True) email_confirmed = models.BooleanField(default=False) featured = models.BooleanField(default=False) tos = models.BooleanField(default=False) work_examples = GenericRelation('generics.Attachment') score = models.DecimalField(blank=True, null=True, max_digits=5, decimal_places=2) referral_code = models.CharField(max_length=50, blank=True, null=True) full_time = models.BooleanField(default=True) contract_to_hire = models.BooleanField(default=True) freelance = models.BooleanField(default=True) @property def name(self): return '{0} {1}'.format(self.first_name, self.last_name) @property def get_photo(self): if self.photo: return '{0}{1}'.format(settings.MEDIA_URL, self.photo) else: try: return self.social_auth.get( provider='linkedin-oauth2' ).extra_data['picture_urls']['values'][0] except: return '' @property def linkedin(self): try: return self.social_auth.get(provider='linkedin-oauth2') except UserSocialAuth.DoesNotExist: return None @property def company(self): """ TODO Needs to support multiple primary companies """ try: return Employee.objects.get(profile=self, primary=True).company except Employee.DoesNotExist: return None @property def contact_details(self): details, created = ContactDetails.objects.get_or_create(profile=self) if (created): details.email = self.email details.email_confirmed = self.email_confirmed details.save() return details def get_skills(self): return self.skills.all() @property def skilltests(self): return SkillTest.objects.filter(profile=self) @property def taken_tests(self): return [t.expertratings_test for t in self.skilltests] def get_default_payment(self): if self.stripe: stripe.api_key = settings.STRIPE_KEY stripe_customer = stripe.Customer.retrieve(self.stripe) for card in stripe_customer['sources']['data']: if card['id'] == stripe_customer['default_source']: # TODO Manually serialize card, circular import error if using api serializer return card return None @property def subscribed(self): active_projects = Project.objects.filter(project_manager=self, status='active') if len(active_projects) > 0: return True return False def invite(self, sender): invite, created = Invite.objects.get_or_create(recipient=self, sender=sender) if created: return True return False
class Thesis(models.Model): """ This class defines the field that a thesis can have. The following fields are optional: additional, pdf A thesis can be promoted for either BSc, MSc, BEd, MEd, or as being part of a project. Each thesis is referenced with the chair that is providing it via a ForeignKey field. """ THESIS_CHOICES = ( ('BSC', 'Bachelor of Science'), ('MSC', 'Master of Science'), ('BED', 'Bachelor of Education'), ('MED', 'Master of Education'), ('PRO', 'Forschungsprojekt'), ('ETC', 'nach Absprache') ) title = models.CharField('Titel der Arbeit', blank=False, max_length=200) description = models.TextField('Beschreibung', blank=False) date_added = models.DateTimeField('Erstellungsdatum', default=timezone.now, editable=False) additional = models.TextField('weitere Beschreibung', blank=True, max_length=1000) contact = models.EmailField('E-Mail der Kontaktperson:', blank=False) chair = models.ForeignKey(Chair, on_delete=models.CASCADE, related_name="provided_by", verbose_name='angeboten durch Lehrstuhl') start_date = models.DateField('frühester Beginn', blank=False, default=timezone.now) is_active = models.BooleanField('aktiv', default=True) pdf = models.FileField('PDF mit Ausschreibung', validators=[FileExtensionValidator(allowed_extensions=['pdf'])], blank=True) type = MultiSelectField('Art der Arbeit', choices=THESIS_CHOICES, blank=False) tags = tagulous.models.TagField(get_absolute_url=lambda tag: reverse( 'by_tag', args=parse_tags(tag.slug))) user = models.ForeignKey(AAIUser, null=True, on_delete=models.DO_NOTHING, related_name="uploaded_by", verbose_name="hochgeladen von") def __str__(self): return self.title def get_absolute_url(self): return "/%i/" % self.id class Meta: verbose_name = "Abschlussarbeit" verbose_name_plural = "Abschlussarbeiten"
class PathContent(models.Model): """Content attached to a Path""" path = models.ForeignKey(Path, on_delete=models.CASCADE) content = models.ForeignKey(Content, on_delete=models.CASCADE) date_added = models.DateTimeField(auto_now_add=True) completed = models.BooleanField(default=False)
class Project(models.Model): company = models.ForeignKey(Company, blank=True, null=True) project_manager = models.ForeignKey('accounts.Profile') title = models.CharField(max_length=255, unique=True) slug = models.SlugField(max_length=255) type = models.CharField(max_length=100, choices=PROJECT_TYPES, blank=True, null=True) category = models.CharField(max_length=100, blank=True, null=True) start_date = models.DateField(blank=True, null=True) end_date = models.DateField(blank=True, null=True) expire_date = models.DateField(blank=True, null=True) skills = tagulous.models.TagField(to='accounts.Skills', blank=True, null=True) deleted = models.BooleanField(default=False) estimated_hours = models.IntegerField(blank=True, null=True) estimated_cash = models.IntegerField(blank=True, null=True) estimated_equity_percentage = models.DecimalField(blank=True, null=True, max_digits=4, decimal_places=2) estimated_equity_shares = models.DecimalField(blank=True, null=True, max_digits=9, decimal_places=2) date_created = models.DateTimeField(auto_now_add=True) city = models.CharField(max_length=255, blank=True, null=True) state = models.CharField(max_length=255, blank=True, null=True) country = models.CharField(max_length=100, blank=True, null=True) country_code = models.CharField(max_length=100, blank=True, null=True) location = models.CharField(max_length=150, blank=True, null=True) status = models.CharField(max_length=100, blank=True, null=True) remote = models.BooleanField(default=False) featured = models.BooleanField(default=False) mix = models.BooleanField(default=False) background = models.TextField(blank=True, null=True) progress = models.TextField(blank=True, null=True) scope = models.TextField(blank=True, null=True) specs = models.TextField(blank=True, null=True) private_info = models.TextField(blank=True, null=True) published = models.BooleanField(default=False) approved = models.BooleanField(default=False) role = models.CharField(max_length=100, blank=True, null=True) years = models.IntegerField(blank=True, null=True) employment_type = models.CharField(max_length=100, default='freelance') autorenew = models.BooleanField(default=False) sku = models.CharField(max_length=50, blank=True, null=True) views = models.IntegerField(default=0) objects = ProjectManager() def __str__(self): return self.title def __unicode__(self): return self.title class Meta: ordering = ['-date_created'] def save(self, *args, **kwargs): self.slug = slugify(self.title) super(Project, self).save(*args, **kwargs) def preauth(self, promo=None): product = Product.objects.get(sku=self.sku) try: order = Order.objects.get(content_type__pk=self.content_type.id, object_id=self.id, status='preauth') except Order.DoesNotExist: if promo: promo = Promo.objects.get(code=promo.lower()) order = Order(content_object=self, product=product, user=self.project_manager, status='preauth', promo=promo) order.save() order.charge() return order def activate(self): today = datetime.now().date() if not self.sku: self.sku = 'free' product = Product.objects.get(sku=self.sku) self.expire_date = today + timedelta(days=product.interval) self.status = 'active' self.save() return self def subscribe(self, promo=None): try: order = Order.objects.get(content_type__pk=self.content_type.id, object_id=self.id, status='preauth') except Order.DoesNotExist: order = self.preauth(promo=promo) if order.product.sku != self.sku: product = Product.objects.get(sku=self.sku) order.product = product order.save() order.capture() if self.project_manager.referral_code: response = vl_conversion(self.project_manager) context = { 'name': self.project_manager.name, 'title': self.title, 'email': self.project_manager.email, 'location': self.project_manager.location, 'referral_code': self.project_manager.referral_code, 'url': settings.VL_CAMPAIGN_URL } send_to_emails('referral-conversion', settings.ADMINS, context) self.activate() return self def deactivate(self): today = datetime.now().date() if self.expire_date and self.expire_date <= today: if self.sku != 'free': order = Order.objects.get( content_type__pk=self.content_type.id, object_id=self.id, status='active') order.status = 'expired' order.save() self.status = 'expired' self.published = False self.save() if not self.deleted: template = 'project-expired-free' if self.sku == 'free' else 'project-expired' url = '{0}/project/upgrade/{1}/'.format( settings.BASE_URL, self.slug ) if self.sku == 'free' else '{0}/project/renew/{1}/'.format( settings.BASE_URL, self.slug) send_mail( template, [self.project_manager], { 'fname': self.project_manager.first_name, 'title': self.title, 'url': url }) return self @property def content_type(self): return ContentType.objects.get_for_model(self) @property def location(self): return self.city if self.city else self.project_manager.city @property def skills_str(self): return self.skills.get_tag_string() @property def nda_list(self): ndas = NDA.objects.filter(proposal__project=self) nda_list = [nda.receiver.id for nda in ndas] nda_list.append(self.project_manager.id) return nda_list
class Task(models.Model): project = models.ForeignKey(Project, related_name='tasks', on_delete=models.DO_NOTHING, blank=True, null=True) user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='tasks_created', on_delete=models.DO_NOTHING) title = models.CharField(max_length=200) description = models.TextField(blank=True, null=True) remarks = models.TextField(blank=True, null=True) url = models.URLField(blank=True, null=True) fee = models.BigIntegerField() currency = models.CharField(max_length=5, choices=CURRENCY_CHOICES, default=CURRENCY_CHOICES[0][0]) deadline = models.DateTimeField(blank=True, null=True) skills = tagulous.models.TagField(Skill, blank=True) visibility = models.PositiveSmallIntegerField( choices=VISIBILITY_CHOICES, default=VISIBILITY_CHOICES[0][0]) update_interval = models.PositiveIntegerField(blank=True, null=True) update_interval_units = models.PositiveSmallIntegerField( choices=UPDATE_SCHEDULE_CHOICES, blank=True, null=True) apply = models.BooleanField(default=True) closed = models.BooleanField(default=False) paid = models.BooleanField(default=False) applicants = models.ManyToManyField(settings.AUTH_USER_MODEL, through='Application', through_fields=('task', 'user'), related_name='task_applications', blank=True) participants = models.ManyToManyField(settings.AUTH_USER_MODEL, through='Participation', through_fields=('task', 'user'), related_name='task_participants', blank=True) satisfaction = models.SmallIntegerField(blank=True, null=True) created_at = models.DateTimeField(auto_now_add=True) apply_closed_at = models.DateTimeField(blank=True, null=True) closed_at = models.DateTimeField(blank=True, null=True) paid_at = models.DateTimeField(blank=True, null=True) comments = GenericRelation(Comment, related_query_name='tasks') uploads = GenericRelation(Upload, related_query_name='tasks') ratings = GenericRelation(Rating, related_query_name='tasks') def __unicode__(self): return self.summary class Meta: ordering = ['-created_at'] unique_together = ('user', 'title', 'fee') @staticmethod @allow_staff_or_superuser def has_read_permission(request): return True @allow_staff_or_superuser def has_object_read_permission(self, request): if self.visibility == VISIBILITY_DEVELOPER: return request.user.type == USER_TYPE_DEVELOPER elif self.visibility == VISIBILITY_MY_TEAM: return bool( Connection.objects.exclude(accepted=False).filter( Q(from_user=self.user, to_user=request.user) | Q(from_user=request.user, to_user=self.user)).count()) elif self.visibility == VISIBILITY_CUSTOM: return self.participation_set.filter( (Q(accepted=True) | Q(responded=False)), user=request.user).count() return False @staticmethod @allow_staff_or_superuser def has_write_permission(request): return request.user.type == USER_TYPE_PROJECT_OWNER @staticmethod @allow_staff_or_superuser def has_update_permission(request): return True @allow_staff_or_superuser def has_object_write_permission(self, request): return request.user == self.user @allow_staff_or_superuser def has_object_update_permission(self, request): if self.has_object_write_permission(request): return True # Participants can edit participation info directly on task object if request.method in ['PUT', 'PATCH']: allowed_keys = [ 'assignee', 'participants', 'confirmed_participants', 'rejected_participants' ] if not [x for x in request.data.keys() if not x in allowed_keys]: return self.participation_set.filter( (Q(accepted=True) | Q(responded=False)), user=request.user).count() return False def display_fee(self, amount=None): if amount is None: amount = self.fee if self.currency in CURRENCY_SYMBOLS: return '%s%s' % (CURRENCY_SYMBOLS[self.currency], floatformat(amount, arg=-2)) return amount @property def summary(self): return '%s - Fee: %s' % (self.title, self.display_fee()) @property def excerpt(self): try: return strip_tags(self.description).strip() except: return None @property def skills_list(self): return str(self.skills) @property def milestones(self): return self.progressevent_set.filter(type__in=[ PROGRESS_EVENT_TYPE_MILESTONE, PROGRESS_EVENT_TYPE_SUBMIT ]) @property def progress_events(self): return self.progressevent_set.all() @property def participation(self): return self.participation_set.filter( Q(accepted=True) | Q(responded=False)) @property def assignee(self): try: return self.participation_set.get( (Q(accepted=True) | Q(responded=False)), assignee=True) except: return None @property def update_schedule_display(self): if self.update_interval and self.update_interval_units: if self.update_interval == 1 and self.update_interval_units == UPDATE_SCHEDULE_DAILY: return 'Daily' interval_units = str( self.get_update_interval_units_display()).lower() if self.update_interval == 1: return 'Every %s' % interval_units return 'Every %s %ss' % (self.update_interval, interval_units) return None @property def applications(self): return self.application_set.filter(responded=False) @property def all_uploads(self): return Upload.objects.filter( Q(tasks=self) | Q(comments__tasks=self) | Q(progress_reports__event__task=self)) @property def meta_payment(self): return { 'task_url': '/task/%s/' % self.id, 'amount': self.fee, 'currency': self.currency } def get_default_participation(self): tags = ['tunga.io', 'tunga'] if self.skills: tags.extend(str(self.skills).split(',')) tunga_share = '{share}%'.format(**{'share': TUNGA_SHARE_PERCENTAGE}) return { 'type': 'payment', 'language': 'EN', 'title': self.summary, 'description': self.excerpt or self.summary, 'keywords': tags, 'participants': [{ 'id': 'mailto:%s' % TUNGA_SHARE_EMAIL, 'role': 'owner', 'share': tunga_share }] } def mobbr_participation(self, check_only=False): participation_meta = self.get_default_participation() if not self.url: return participation_meta, False mobbr_info_url = '%s?url=%s' % ( 'https://api.mobbr.com/api_v1/uris/info', urllib.quote_plus(self.url)) r = requests.get(mobbr_info_url, **{'headers': { 'Accept': 'application/json' }}) has_script = False if r.status_code == 200: response = r.json() task_script = response['result']['script'] for meta_key in participation_meta: if meta_key == 'keywords': if isinstance(task_script[meta_key], list): participation_meta[meta_key].extend( task_script[meta_key]) elif meta_key == 'participants': if isinstance(task_script[meta_key], list): absolute_shares = [] relative_shares = [] absolute_participants = [] relative_participants = [] for key, participant in enumerate( task_script[meta_key]): if re.match(r'\d+%$', participant['share']): share = int(participant['share'].replace( "%", "")) if share > 0: absolute_shares.append(share) new_participant = participant new_participant['share'] = share absolute_participants.append( new_participant) else: share = int(participant['share']) if share > 0: relative_shares.append(share) new_participant = participant new_participant['share'] = share relative_participants.append( new_participant) additional_participants = [] total_absolutes = sum(absolute_shares) total_relatives = sum(relative_shares) if total_absolutes >= 100 or total_relatives == 0: additional_participants = absolute_participants elif total_absolutes == 0: additional_participants = relative_participants else: additional_participants = absolute_participants for participant in relative_participants: share = int( round(((participant['share'] * (100 - total_absolutes)) / total_relatives), 0)) if share > 0: new_participant = participant new_participant['share'] = share additional_participants.append( new_participant) if len(additional_participants): participation_meta[meta_key].extend( additional_participants) has_script = True elif meta_key in task_script: participation_meta[meta_key] = task_script[meta_key] return participation_meta, has_script @property def meta_participation(self): participation_meta, has_script = self.mobbr_participation() # TODO: Update local participation script to use defined shares if not has_script: participants = self.participation_set.filter( accepted=True).order_by('share') total_shares = 100 - TUNGA_SHARE_PERCENTAGE num_participants = participants.count() for participant in participants: participation_meta['participants'].append({ 'id': 'mailto:%s' % participant.user.email, 'role': participant.role, 'share': int(total_shares / num_participants) }) return participation_meta