zcreate_rn..Hs STU^S_rc.tj|dS)Nc|dS)Nr r")ys rr%z-create_rn....Is 1U8r)pydashsum_byr#s rr%zcreate_rn..Is a1C1C D Drzgupdate PurchaseOrderItem set POItemStatus = 0 where PurchaseOrderItemId = ? and PurchaseOrderListId = ?zSselect * from PurchaseOrderItem where PurchaseOrderListId = ? and POItemStatus = 1;zGupdate PurchaseOrderList set POStatus = 0 where PurchaseOrderListId = ?z{}-{} created!type)r appmssqlcursorarrownowreplacedatetimeexecuteintcommitappendr) map_values collectionsgroup_byrrowcountformatupper) r rr. Last_updateitr row_countrowspo_itemsrow grn_itemskvs r create_rnrFs!*--J [  % % ' 'F)++%%_%==FK~~MNN(( 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   " ":f#5#;#;#=#=y I IIrz/grn_details1/type/po_noc K|jj}g}i}|d|}|D]}|d||d<|d|}gd}|D]}g|}|d|vrW|d||dz |d<|ddkr0|t t ||g|t t |||S)Nzselect 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 PurchaseOrderItemIdrra select distinct POL.PurchaseOrderListId , POI.PurchaseOrderItemId , POI.ProductID , PAT.Name AS ProductName, POI.HSN_Code ,POI.Quantity, POI.UOM, POI.BasePrice, SP.Name AS UOM_Name, POI.CGST, POI.SGST, V.VendorName + ' ' + V.VendorAddress + ' ' + V.CountryCode + ' ' + V.MobileNo AS VendorDetails, V.VendorId 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 SpecificationType AS SP (NOLOCK) ON POI.UOM = SP.SpecificationTypeId 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 ProductNameHSN_CodeQuantityUOM BasePriceUOM_NameCGSTSGST VendorDetailsVendorId)r,r-r.r3r6dictzip) r r+rr.rAreceived_itemsr@rBcolumnss r grn_details1r[Zs? [  % % ' 'FHN >>9:? A AD((!$Qs1v >>pqv w wDUUUG44f q6^ # #VnSV44CF1v{{S%5%5 6 6777 OODWS!1!122 3 3 3 3 Orz/grn_details/type/po_noc BK|jj}|d||}gd}g}|jdkrF|D]2}|t t||3t|}|S|dkrdS|dkrdSdS)Nz"{call Vaaak.spGetGrnDetails(?, ?)}rHrrnz RN not foundgrnz GRN not found) r,r-r.r3r:r6rWrXjson_serializer)r r+rr.r@rZrrBs rrrus [  % % ' 'F >>>e L LDtttGK } 7 7C   tC$4$455 6 6 6 6%k22  4<<!> 5=="? =r)r/fastapirrrrtypingrrfastapi.encodersr fastapi.responsesr lib.commonr)routerpostrrFgetr[rr"rrrhs 444444444444------****** ];?49900g0D0000\9=cGJGJWGJ$GJGJGJGJR &''('4 %&&#w###'&###r