a
    =eW                     @   s   d dl m Z  d dlmZ d dlmZ d dlmZmZ d dlm	Z	m
Z
 d dlmZmZ d dlmZ d dlmZmZmZmZmZmZmZmZ g d	Ze  jZed
ddddZed
ddddZG dd deZdS )    )datetime)login_required)Q)HttpResponseJsonResponse)renderredirect)loaderRequestContext)View)CustomerCustomerFormBill	InventorySupportCasesBillFormInventoryFormSupportCasesForm)JanauaryFebruaryMarchAprilMayJuneJulyAugust	SeptemberOctoberNovemberDecemberz/admin/login/?next=/)Z	login_urlallc                 C   s   t d}tjdd d }|dkrdtttd   tjjttd  dd d }td t| t	jdd d }t
jd	d d }tjd
d d }|||||| d}t||| S )Nz
index.htmlz-id
   Zdue   )billed_monthz====duez-bill_idz-item_updatedz-case_id)	customersbillsinventoriessupport_casesZbill_fZcustomer_number)r	   get_templater   objectsorder_byprint
month_listmonthexcluder   r   r   countr   r   )requestbilltemplater$   r%   r&   r'   context r4   $/var/www/html/isp_hrms/home/views.pyindex   s$    
	r6   createNc                 C   s  t | t | d }|dkr|dkr6tjj|d }|dkrPtjj|d }|dkrjtjj|d }|dkrtjj|d	 }tt	S |d ur|dkrtjj
|d}t|d
}|d ur|dkrtjj
|d}t|d
}|d ur|dkrtjj
|d}t|d
}|d ur4|dkr4tjj
|d	}t|d
}|d u rN|dkrNt }|d u rh|dkrht }|d u r|dkrt }|d u r|dkrt }| jdkr`d }d }	|dkr| dkrt| j}n*| dkrtjj
|d}t| j|d
}|dkrL| dkr"t| j}n*| dkrLtjj
|d}t| j|d
}|dkr| dkrpt| j}n*| dkrtjj
|d}t| j|d
}|dkr| dkrt| j}n*| dkrtjj
|d	}t| j|d
}| r`|jdd}
|
  | dks|dkrXtjj
|jjjd}	t |	 |jj|	_t |jj |	  tt	S |||d u rrdnd|d}t| d|S )Ndeletecustomer)idr1   )bill_id	inventory)
product_idZsupport)case_id)instancePOSTr7   updateF)commit)formentityactionr:   zupdate.html)r+   r   r)   filterr8   r   r   r   r   r6   getr   r   r   r   methodlowerr@   is_validsaver?   r9   r:   
month_billr#   r   )r0   rD   rE   r:   rC   r9   r1   r<   ZsupportCaseZcustomer_foreignZdata_objectr3   r4   r4   r5   updateFields8   s    









rM   c                   @   s   e Zd Zdd ZdS )CustomerAutocompletec                 C   sN   |j dd}t| tjj|dd d }dd |D }t| t|ddS )	Nterm )Zfull_name__icontainsr!   c                 S   s    g | ]}t |jd  |j qS ) )strr:   	full_name).0r9   r4   r4   r5   
<listcomp>       z,CustomerAutocomplete.get.<locals>.<listcomp>F)safe)GETrG   r+   r   r)   rF   r   )selfr0   queryr$   resultsr4   r4   r5   rG      s    zCustomerAutocomplete.getN)__name__
__module____qualname__rG   r4   r4   r4   r5   rN      s   rN   )r    )r7   N)r   Zdjango.contrib.auth.decoratorsr   django.db.modelsr   django.httpr   r   Zdjango.shortcutsr   r   django.templater	   r
   django.viewsr   Zhome.modelsr   r   r   r   r   r   r   r   r,   nowr-   r6   rM   rN   r4   r4   r4   r5   <module>   s   (
f