o
    te                     @   sp  d dl m Z  d dlmZ d dlmZ d dlmZmZmZm	Z	 ddl
mZ ddlmZmZmZmZmZ dZd	Zd
ZdZdZdZdZdZeded	ed
ededededediZdd e D ZdddddddddddddZdZG d d! d!ejZG d"d# d#ejZG d$d% d%ejZ G d&d' d'ejZ!G d(d) d)ej"Z#G d*d+ d+ej"Z$G d,d- d-ej"Z%G d.d/ d/ej"Z&d0S )1    )datetime)models)forms)BaseModelFormSetIntegerFieldBaseFormSetmodelformset_factory   )bd)divisions_choicesDhakadistricts_choicesarea_choicesJigatolaZ2MBZ4MBZ6MBZ8MBZ10MBZ15MBZ20MBZ25MBc                 C   s   g | ]\}}||fqS  r   ).0kvr   r   %/var/www/html/isp_hrms/home/models.py
<listcomp>   s    r   JanauaryFebruaryMarchAprilMayJuneJulyAugust	SeptemberOctoberNovemberDecember)r   r   r   r   r   r   r   r   r   r   r    r!   ))r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r    r    )r!   r!   c                   @   s   e Zd ZejddZejddZejdddZejde	e
dZejdd	dZejdd
dZejdeedZejdeedZejdeedZejddZejdeddZdd ZdS )CustomerT)primary_key   
max_length   Z01700000000)r&   defaultr&   choicesr(   Z555566zsr@username      )r&   r*   nullc                 C   s(   t | jd | j d | j d | j S Nz -- )strid	full_nameareaaddressselfr   r   r   __str__S   s   zCustomer.__str__N)__name__
__module____qualname__r   	AutoFieldr0   	CharFieldr1   Zmobilepackage_choicespackage1packagenidZdial_up_usernamer   r   stater   Zcityr   r   r2   r3   month_tuplesZbilled_monthr6   r   r   r   r   r"   @   s    r"   c                   @   sz   e Zd ZejddZejdee	 
 dZejdeed dZejdddejdZejdeedZe Zd	d
 ZdS )BillTauto_nowr#   r(   r$   r   r)   r"   r-   blank	on_deletec                 C   s4   t | jd t | j d t | j d t | j S )Nz
 Customer z
 package :z	 amount :)r/   bill_idcustomer_idZ
package_idbill_amountr4   r   r   r   r6   a   s   zBill.__str__N)r7   r8   r9   r   DateTimeFieldZbill_createdr   intr   now	timestamprI   r;   rA   
month_dictZ
month_bill
ForeignKeySET_NULLcustomerr<   r=   r>   rK   r6   r   r   r   r   rB   X   s    rB   c                   @   sV   e Zd Zejdee  dZ	ej
ddZejddZe Ze Zdd ZdS )		InventoryTrE   r$   r%   rC   c                 C   s0   t | jd | j d t | j d t | j S r.   )r/   
product_id	item_nameamountquantityr4   r   r   r   r6   m   s   0zInventory.__str__N)r7   r8   r9   r   r   rM   r   rN   rO   rU   r;   rV   rL   Zitem_updatedrX   rW   r6   r   r   r   r   rT   f   s    rT   c                   @   sf   e Zd Zejdee  dZ	ej
dddejdZejddZe Zejddd	d
Zdd ZdS )SupportCasesTrE   r"   rF   r$   r%      ))YESr[   )NOr\   r\   r)   c                 C   s,   t | jd t | j d | j d | j S r.   )r/   case_idrJ   assigned_staffdescriptionr4   r   r   r   r6   x   s   zSupportCases.__str__N)r7   r8   r9   r   r   rM   r   rN   rO   r]   rQ   rR   rS   r;   r^   	TextFieldr_   Zresolution_providedr6   r   r   r   r   rY   q   s    rY   c                   @      e Zd ZG dd dZdS )CustomerFormc                   @      e Zd ZeZdZdS )zCustomerForm.Meta__all__N)r7   r8   r9   r"   modelfieldsr   r   r   r   Meta   s    rg   Nr7   r8   r9   rg   r   r   r   r   rb          rb   c                   @   ra   )BillFormc                   @   rc   )zBillForm.Metard   N)r7   r8   r9   rB   re   rf   r   r   r   r   rg          rg   Nrh   r   r   r   r   rj      ri   rj   c                   @   ra   )InventoryFormc                   @   rc   )zInventoryForm.Metard   N)r7   r8   r9   rT   re   rf   r   r   r   r   rg      rk   rg   Nrh   r   r   r   r   rl      ri   rl   c                   @   ra   )SupportCasesFormc                   @   rc   )zSupportCasesForm.Metard   N)r7   r8   r9   rY   re   rf   r   r   r   r   rg      rk   rg   Nrh   r   r   r   r   rm      ri   rm   N)'r   	django.dbr   djangor   Zdjango.formsr   r   r   r    r
   r   r   r   r   r   r=   Zpackage2Zpackage3Zpackage4Zpackage5Zpackage6Zpackage7Zpackage8r<   itemsrP   rA   Modelr"   rB   rT   rY   	ModelFormrb   rj   rl   rm   r   r   r   r   <module>   s\    