
    9d                         d dl m Z d dlmZmZmZmZ d dlmZm	Z	 d dl
mZ d dlmZ d dlT d dlZ e            Ze                    d           ed	          fd
edefd            ZdS )    )datetime)	APIRouterRequestBodystatus)DictList)jsonable_encoder)JSONResponse)*Nz/dash_po.requestfilterc           	        K   t          |          }| j        j                                        }g }|d         dk    rag d}d}|d         r|d                    |d                   z   }|d         r|d                    |d                   z   }|d	         rt          j        |d	                             d
          d         d          }t          j        |d	                             d
          d         d          }|d                    ||          z   }|                    |          }|D ]l}	g |	}	t          
                    |	d                                       d          |	d<   |                    t          t          ||	                               m|S |d         dk    rag d}d}|d         r|d                    |d                   z   }|d         r|d                    |d                   z   }|d	         rt          j        |d	                             d
          d         d          }t          j        |d	                             d
          d         d          }|d                    ||          z   }|                    |          }|D ]l}	g |	}	t          
                    |	d                                       d          |	d<   |                    t          t          ||	                               m|S |d         dk    rag d}d}|d         r|d                    |d                   z   }|d         r|d                    |d                   z   }|d	         rt          j        |d	                             d
          d         d          }t          j        |d	                             d
          d         d          }|d                    ||          z   }|                    |          }|D ]l}	g |	}	t          
                    |	d                                       d          |	d<   |                    t          t          ||	                               m|S d S )Nc1PO)	po_numbervender_namepo_date	po_statuszselect POL.PurchaseOrderListId,VEN.VendorName,POL.CreatedDate, POL.POStatus from PurchaseOrderList as POL JOIN Vaaak.Vendor as VEN on VEN.VendorId = POL.VendorId where 1=1c2z! AND POL.PurchaseOrderListId = {}c3z AND VEN.VendorName = '{}'c4#r   z%d/%m/%Y   z8 AND POL.CreatedDate >= '{}' and POL.CreatedDate <= '{}'   z
DD/MM/YYYYGRN)grn_nopo_nor   grn_date
invoice_nor   aB  select GRN.GrnId,POL.PurchaseOrderListId,VEN.VendorName,GRN.LastUpdate,GRNL.InvoiceNumber, POL.POStatus from PurchaseOrderList as POL JOIN Vaaak.Vendor as VEN on VEN.VendorId = POL.VendorId JOIN Vaaak.GrnList as GRN on GRN.PurchaseOrderListId = POL.PurchaseOrderListId JOIN Vaaak.GrnItem as GRNL on GRNL.GrnId = GRN.GrnId JOIN (select count(PurchaseOrderListId) AS cnt,PurchaseOrderListId from Vaaak.GrnList as GRN1 group by PurchaseOrderListId having count(PurchaseOrderListId) = 1 ) as tem on tem.PurchaseOrderListId = POL.PurchaseOrderListId where 1 = 1 and POL.POStatus = 0 z AND GRN.GrnId = {}z6 AND GRN.LastUpdate >= '{}' and GRN.LastUpdate <= '{}'   RN)rn_nor   r   rn_dater    r   aN  select GRN.GrnId,POL.PurchaseOrderListId,VEN.VendorName,GRN.LastUpdate,GRNL.InvoiceNumber, POL.POStatus from PurchaseOrderList as POL JOIN Vaaak.Vendor as VEN on VEN.VendorId = POL.VendorId JOIN Vaaak.GrnList as GRN on GRN.PurchaseOrderListId = POL.PurchaseOrderListId JOIN Vaaak.GrnItem as GRNL on GRNL.GrnId = GRN.GrnId where 1 = 1 )r
   appmssqlcursorformatdtstrptimesplitexecutearrowgetappenddictzip)
r   r   r'   filter_itemscolumns	statement
start_dateend_daterowsrows
             D:\api_v1\routes\dashboard.pydash_por:      s     f%%F[%%''FLd|tFFFX	 $< 	]!$G$N$NvVZ|$\$\\I$< 	V!$@$G$Gt$U$UUI$< 	{VD\%7%7%<%<Q%?LLJ{6$<#5#5c#:#:1#=zJJH!$^$e$efpqy$z$zzI~~i(( 	8 	8CC&CYYs1v&&--l;;CFS%5%5 6 67777d|uYYY8	 $< 	O!$9$@$@$N$NNI$< 	V!$@$G$Gt$U$UUI$< 	pVD\%7%7%<%<Q%?LLJ{6$<#5#5c#:#:1#=zJJH!$\$c$cdnfn%p %p pI ~~i(( 	9 	9CC&CYYs1v&&--l;;CFS#%6%6 7 78888d|tYYY#	 $< 	O!$9$@$@$N$NNI$< 	V!$@$G$Gt$U$UUI$< 	nVD\%7%7%<%<Q%?LLJ{6$<#5#5c#:#:1#=zJJH!$\$c$cdndl%n %n nI ~~i(( 	9 	9CC&CYYs1v&&--l;;CFS#%6%6 7 78888;     )r   r)   fastapir   r   r   r   typingr   r	   fastapi.encodersr
   fastapi.responsesr   
lib.commonpydashrouterpostr:    r;   r9   <module>rE      s    # # # # # # 4 4 4 4 4 4 4 4 4 4 4 4         - - - - - - * * * * * *     	Z48DII Y YG YT Y Y Y Y Y Yr;   