o kl7d @sddlZddlmZmZmZmZddlmZmZddl m Z ddl m Z ddl TddlZeZededfd ed efd d Zed d efddZedd efddZdS)N) APIRouterRequestBodystatus)DictList)jsonable_encoder) JSONResponse)*z /create_po.request po_detailscsPt|}|jj}|dD]}t|ddkr!t|d}qt|dd}qdtdtd||d<t|dd j |d<t j d d j |d <|d |d|d|dd|d|dd|d  |jj |dD]!}|d||d|d|d|d|d|d|dd|d  qv|jj | td|iS)Nz1SELECT IDENT_CURRENT('PurchaseOrderList') as cnt;rzAVPL/PSD/{}/{}/{}ZYYYYZMMZ po_ref_noZpo_datez DD/MM/YYYYz Asia/Calcutta)tzinfoZ Last_updatez=insert into PurchaseOrderList values (?, ?, ?, ?, ?, ?, ?, ?)Z vendor_idZpurchase_eventZ prepared_byproduct_detailszCinsert into PurchaseOrderItem values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)Z product_idZhsn_codeZqtyZuomZ base_priceZcgstZsgstpo_no)rappmssqlcursorexecuteintformatarrowgetdatetimenowreplacecommitcloser )r r ritrZ row_countZprdr=D:\Vignesh\Freelance\Astroved\api_v1\routes\purchase_order.py create_po sN &  r!z/get_po/{details}/{po_id}c s|jj}i}|d|}|jdkr}|D]d}|rxt|D] \}}|||j|d<qt|g|d<|dkrr|d|}|jdkro|D]}|rdi} t|D] \}}|| |j|d<qO|d| qEt|t |SdSt |SdSdSdS)Nz=select * from PurchaseOrderList where PurchaseOrderListId = ?rr1z=select * from PurchaseOrderItem where PurchaseOrderListId = ?zRequested PO not found) rrrrrowcount enumeratecursor_descriptionZjson_serializerappendr ) r detailsZpo_idrr rowsrowrZitr_itmproductrrr get_poCs8       "r+z /get_valid_pocs4|jj}g}|dD] }||dq|S)NzDselect PurchaseOrderListId from PurchaseOrderList where POStatus = 1r)rrrrr&)r rrrrrr get_valid_pons  r,)rfastapirrrrtypingrrfastapi.encodersrfastapi.responsesr Z lib.commonjsonrouterpostr!rr+r,rrrr s  6*