Td"ddlZddlmZmZmZmZddlmZmZddl m Z ddl m Z ddl TddlZeZededfd ed efd Zed d efd ZdS)N) APIRouterRequestBodystatus)DictList)jsonable_encoder) JSONResponse)*z /create_rn.request rn_detailsc ,Kt|}|jj}t jdj}|dD]M}g|}t|ddkrt|d}5t|ddz}N|d|d||jj |dD].}|d ||d |d |d |/|jj |dD]%}|d |d |d &|jj |d|d}i}|D]}|d||d<|d|d}g} |D]&}| |d|dd'tj tj| dd} | D].\} } || | kr|d| |d/| |d|d}|jdkr0|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 (?, ?, ?, ?, ?)purchase_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_idqtyc|dS)Nrxs D:\Sites\api_v1\routes\grn.pyzcreate_rn..Es STU^S_c.tj|dS)Nc|dS)Nrr)ys rr z-create_rn....Fs 1U8r!)pydashsum_byrs rr zcreate_rn..Fs a1C1C D Dr!zgupdate 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)r appmssqlcursorarrownowreplacedatetimeexecuteintcommitappendr% map_values collectionsgroup_byrrowcountupper) r r r+ Last_updateitr row_countrowspo_itemsrow grn_itemskvs r create_rnrB s!*--J [  % % ' 'F)++%%_%==FK~~z{{((f s1v;;!  CF IICF aII NN<g&  K'"I 23>*<("      K'"TTabeftbuwz{RwS T T T T K >>Y[efm[n o oDH""q6Q >>GIST[I\ ] ]DI  q61v      !&"4"="=iI_I_"`"`DDFFI  ^^! A;!   NNEGHJTU\J] ^ ^ ^ MMOOO >>oq{}DrE F FD }`blmtbuvvv 6"((**  r!z/grn_details/type/po_noc $K|dkr4|jj}|d|}|jdkrg}i}|d|}|jdkr|D]}|d||d<|d|}gd}|D]}g|}|d|vrW|d||dz |d<|ddkr0|tt||g|tt|||Sd Sd S|d kr'|jj}|d|}|jdkrg}i}|d|}|D]}|d||d<|d |}gd}|D]}g|}|d|vrW|d||dz |d<|ddkr0|tt||g|tt|||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 = ?)PurchaseOrderListIdPurchaseOrderItemId ProductID ProductName nick_nameHSN_CodeQuantityUOM BasePriceUOM_NameCGSTSGSTVendorId 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) r8r)r*r+r0r7r3dictzip) r r'rr+r<r=received_itemsr>columnss r grn_detailsrc[s zz||u"))++~~pqvww =A  HN>>#ABGIID}!!44C-0VN3q6**~~'Q R W X X TTT @@C C&C1v//!$Q.Q*@!@Aq6Q;;$OODWS1A1A,B,BCCC S-=-=(>(>????+*** zz||t"))++~~prwxx =A  HN>>#ABGIID 0 0),Qs1v&&>>{ D|||G  = =fq6^++ VnSV&<->(?(?@@@OODWc):):$;$;<<<<O))Gr!)r,fastapirrrrtypingrrfastapi.encodersr fastapi.responsesr lib.commonr%routerpostrBgetrcrr!rrls' 444444444444------****** \9=cKKWK$KKKK\ %&&K*wK*K*K*'&K*K*K*r!