o [d"@sddlZddlmZmZmZmZddlmZmZddl m Z ddl m Z ddl TddlZeZededfd ed efd d Zed d efddZdS)N) APIRouterRequestBodystatus)DictList)jsonable_encoder) JSONResponse)*z /create_rn.request rn_detailsc st|}|jj}tjddj}|dD]}g|}t |ddkr.t |d}qt |dd}q|d|d||dD]}|d ||d |d |d |qD|dD] }|d |d |d q[|d|d}i}|D] }|d||d<qu|d|d}g} |D]}| |d|ddqt t j | dddd} | D]\} } || | kr|d| |dq||d|d}|jdkr|d|d||d|dS)Nz Asia/Calcutta)tzinfozZselect count(*) as cnt,(select IDENT_CURRENT('Vaaak.GrnList')) as idnt from Vaaak.GrnListrz'insert into Vaaak.GrnList values (?, ?)po_noitemsz0insert into Vaaak.GrnItem values (?, ?, ?, ?, ?)Zpurchase_order_itemid received_qty invoice_nozupdate inventory set Quantity = Quantity + ? where ProductId = (select ProductId from PurchaseOrderItem where PurchaseOrderItemId = ?)z=select * from PurchaseOrderItem where PurchaseOrderListId = ?zjselect * from Vaaak.GrnItem where GrnId in (select GrnId from Vaaak.GrnList where PurchaseOrderListId = ?))item_idqtycS|dS)Nrxrr2D:\Vignesh\Freelance\Astroved\api_v1\routes\grn.pyEzcreate_rn..cSst|ddS)NcSr)Nrr)yrrrrFrz-create_rn....)pydashsum_byrrrrrFszgupdate PurchaseOrderItem set POItemStatus = 0 where PurchaseOrderItemId = ? and PurchaseOrderListId = ?zSselect * from PurchaseOrderItem where PurchaseOrderListId = ? and POItemStatus = 1;zGupdate PurchaseOrderList set POStatus = 0 where PurchaseOrderListId = ?type)r"id)rappmssqlcursorarrownowreplacedatetimeexecuteintappendr map_values collectionsgroup_byrcommitrowcountupper) r r r& Last_updateitr row_countrowspo_itemsrow grn_itemskvrrr create_rn sb       r=z/grn_details/type/po_noc s|dkrz|jj}|d|}|jdkrxg}i}|d|}|jdkrv|D] }|d||d<q)|d|}gd}|D]3}g|}|d|vri|d||d|d<|ddkrh|tt||q@|tt||q@|Sd Sd S|d kr|jj}|d|}|jdkrg}i}|d|}|D] }|d||d<q|d |}gd}|D]3}g|}|d|vr|d||d|d<|ddkr|tt||q|tt||q|Sd SdS)NGRNzPselect * from PurchaseOrderList where PurchaseOrderListId = ? and POStatus != -1rzselect GRI.PurchaseOrderItemId, sum(GRI.ReceivedQty) as Received from Vaaak.GrnItem AS GRI where GrnId in (select GRL.GrnId from Vaaak.GrnList AS GRL where GRL.PurchaseOrderListId = ?) group by PurchaseOrderItemIdra select distinct POL.PurchaseOrderListId , POI.PurchaseOrderItemId , POI.ProductID , PAT.Name AS ProductName,POI.PdtNickName, POI.HSN_Code ,POI.Quantity, POI.UOM, POI.BasePrice, SP.Name AS UOM_Name, POI.CGST, POI.SGST, V.VendorId, V.VendorName, V.VendorAddress1,V.VendorAddress2,V.City,V.State,V.Country, V.CountryCode, V.MobileNo , V.landlineNo, V.GSTIN, V.Remarks from PurchaseOrderItem as POI JOIN PurchaseOrderList AS POL(NOLOCK) ON POI.PurchaseOrderListId = POL.PurchaseOrderListId JOIN Product AS PP (NOLOCK) ON PP.ProductId = POI.ProductId LEFT JOIN Vaaak.Vendor AS V (NOLOCK) ON POL.VendorId = V.VendorId LEFT JOIN Specification AS SP (NOLOCK) ON POI.UOM = SP.SpecificationId JOIN ProductTranslation AS PT (NOLOCK) ON PT.ProductId = POI.ProductId AND PT.LocaleId = 1 JOIN Vaaak.ProductAdditionalTranslation AS PAT (NOLOCK) ON PT.ProductAdditionalTransId = PAT.ProductAdditionalTransId LEFT JOIN vaaak.GrnItem AS GI (NOLOCK) ON POI.PurchaseOrderItemId=GI.PurchaseOrderItemId where POI.PurchaseOrderListId = ?)PurchaseOrderListIdPurchaseOrderItemIdZ ProductIDZ ProductName nick_nameZHSN_CodeZQuantityZUOMZ BasePriceZUOM_NameZCGSTZSGSTVendorId VendorNameVendorAddress1VendorAddress2CityStateCountry CountrycodemobilelandlinegstremarkszRN already existszPO already Cancelled!RNa select distinct POL.PurchaseOrderListId , POI.PurchaseOrderItemId , POI.ProductID , PAT.Name AS ProductName,POI.PdtNickName, POI.HSN_Code ,POI.Quantity, POI.UOM, POI.BasePrice, SP.Name AS UOM_Name, POI.CGST, POI.SGST, V.VendorId, V.VendorName, V.VendorAddress1,V.VendorAddress2,V.City,V.State,V.Country, V.CountryCode, V.MobileNo , V.landlineNo, V.GSTIN, V.Remarks from PurchaseOrderItem as POI JOIN PurchaseOrderList AS POL(NOLOCK) ON POI.PurchaseOrderListId = POL.PurchaseOrderListId JOIN Product AS PP (NOLOCK) ON PP.ProductId = POI.ProductId LEFT JOIN Vaaak.Vendor AS V (NOLOCK) ON POL.VendorId = V.VendorId LEFT JOIN Specification AS SP (NOLOCK) ON POI.UOM = SP.SpecificationId JOIN ProductTranslation AS PT (NOLOCK) ON PT.ProductId = POI.ProductId AND PT.LocaleId = 1 JOIN Vaaak.ProductAdditionalTranslation AS PAT (NOLOCK) ON PT.ProductAdditionalTransId = PAT.ProductAdditionalTransId LEFT JOIN vaaak.GrnItem AS GI (NOLOCK) ON POI.PurchaseOrderItemId=GI.PurchaseOrderItemId where POI.PurchaseOrderListId = ?zPO already cancelled) r3r$r%r&r+r2r-dictzip) r r"rr&r7r8Zreceived_itemsr9columnsrrr grn_details[sn             rS)r'fastapirrrrtypingrrfastapi.encodersrfastapi.responsesr lib.commonr routerpostr=getrSrrrrs  N