$ExpenseHeadName=[];
$indexHead=0;
foreach ($RequisitionConfirmItems as $purchaseItem){
$OnlyItems=json_decode($purchaseItem["Items"]);
foreach ($OnlyItems as $onlyItem){
$ExpenseHeadName[$onlyItem->expenseHead]=GetExpenseHeadName($onlyItem->expenseHead);
}
}



$ConfirmItemsRequisiton=SQL_Select("Purchaserequisition where (CategoryID=$categoryId and Confirm='Confirm')");



//echo "<pre>";
    $confirmExpenseHead = [];
    foreach ($ConfirmItemsRequisiton as $requisitionConfirmItem) {
        $sss = json_decode($requisitionConfirmItem["Items"]);
        foreach ($sss as $ss) {
            $confirmExpenseHead[] = $ss->expenseHead;
        }
    }

    $TotalRequisitionQty = [];
    $requisitionRate = [];

    $i = 0;
    foreach ($ConfirmItemsRequisiton as $requisitionConfirmItem) {
        $sss = json_decode($requisitionConfirmItem["Items"]);
        foreach ($sss as $ss) {
            if ($ss->expenseHead == $confirmExpenseHead[$i]) {
                $TotalRequisitionQty[$ss->expenseHead] += $ss->requisitionQty;
            } else {
                $TotalRequisitionQty[$ss->expenseHead] += $ss->requisitionQty;
            }
            $requisitionRate[$ss->expenseHead] = $ss->requisitionRate;
            $i++;

        }
    }

    $PurchaseConfirmItems = SQL_Select("Purchase where (CategoryID=$categoryId and Confirm='Confirm')");

    $PurchaseconfirmExpenseHead = [];
    foreach ($PurchaseConfirmItems as $PurchaseConfirmItem) {
        $PurchasesConfirms = json_decode($PurchaseConfirmItem["Items"]);
        foreach ($PurchasesConfirms as $purchasesConfirm) {
            $PurchaseconfirmExpenseHead[] = $purchasesConfirm->expenseHead;
        }
    }

    $TotalPurchaseQty = [];
    $PurchaseRequisitionRate = [];

    $indexPurchase = 0;
    foreach ($PurchaseConfirmItems as $PurchaseConfirmItem) {
        $PurchasesConfirms = json_decode($PurchaseConfirmItem["Items"]);

        foreach ($PurchasesConfirms as $purchasesConfirm) {
            if ($PurchaseconfirmExpenseHead[$indexPurchase] == $purchasesConfirm->expenseHead) {
                $TotalPurchaseQty[$purchasesConfirm->expenseHead]+=$purchasesConfirm->requisitionQty;
            }else{
                $TotalPurchaseQty[$purchasesConfirm->expenseHead]=$purchasesConfirm->requisitionQty;
            }
            $PurchaseRequisitionRate[$purchasesConfirm->expenseHead]=$purchasesConfirm->requisitionRate;

            $indexPurchase++;

        }
    }


    $ExpenseHeadNamePacket=[$ExpenseHeadName];


/*    Total confirm requisition  amount*/

    $confirmRequisitionItemsss=[$TotalRequisitionQty,$requisitionRate];

/*    Total confirm Purchase amount*/

    $confirmPurchaseItemsssssss=[$TotalPurchaseQty,$PurchaseRequisitionRate];

    $result=array_merge($RequisitionConfirmItems,$ExpenseHeadNamePacket,$confirmRequisitionItemsss,$confirmPurchaseItemsssssss);
























                    /*Expense head name*/
                    var confirmExpenseHeadName=data[1];


                    /*Confirm Requisiton Qty*/

                    var ConfirmRequisitonQuentity=data[2];



                    /*Confirm Requisiton Rate*/
                    var ConfirmRequisitonRate=data[3];



                    /*Confirm Purchase Quentity*/
                    var ConfirmPurchaseQuentity=data[4];


                    /*Confirm Purchase Rate*/
                    var ConfirmPurchaseRate=data[5];


                    var Itemsss= JSON.parse(data[0].Items);

                    var expenseHead="";
                    var requisitionQty="";
                    var requisitionRate="";

                    var TotalRequisitionAmount=0;

                    var itemsHtmls ="";

                    $.each( Itemsss, function( key, value ) {

                      var expenseHead=parseInt(value.expenseHead);

                      var requisitionAmount=parseFloat(value.requisitionAmount);

                      var requisitionQty=parseFloat(value.requisitionQty);
                      var requisitionRate=parseFloat(value.requisitionRate);

                      var newQnt=0;
                      if ( ConfirmPurchaseQuentity[expenseHead] > 0 ){
                          newQnt=requisitionQty-ConfirmPurchaseQuentity[expenseHead];
                      } else{
                         newQnt=requisitionQty;
                      }

                      var newPurchaseAmount = newQnt * requisitionRate;
                      TotalRequisitionAmount += newPurchaseAmount;

                      if (newQnt===0){
                          return true;
                      }

                        itemsHtmls += '<div class="items-requisiton">'
                                +'<p style="font-weight:bold">Expense Name, Present Stock, Qty, Rate, Total</p>'
                                +'<input readonly name="items['+key+'][expenseHead]" value="'+expenseHead+'" type="hidden" placeholder="Unite">'
                                +'<input readonly name="items['+key+'][expenseHeadName]" value="'+confirmExpenseHeadName[expenseHead].replace("\""," ")+'" type="text" placeholder="Nai">'
                                +'<input readonly thisPresentStock="true" name="items['+key+'][presentStock]"  value="'+newQnt+'" type="text" placeholder="Present Stock">'
                                +'<input autocomplete="off" thisRequisition="true" value="'+newQnt+'" name="items['+key+'][requisitionQty]" type="number" placeholder="This Requisition">'
                                +'<input readonly thisRequisitonRate="true" value="'+requisitionRate+'" name="items['+key+'][requisitionRate]" type="text" placeholder="Rate">'
                                +'<input class="totalRequisitonAmount" thisRequisitionTotal="true" value="'+newPurchaseAmount+'" readonly name="items['+key+'][requisitionAmount]" type="text" placeholder="Amount">'
                                +'&nbsp;<i class="fas fa-minus btn btn-danger"></i>&nbsp;'
                                +'</div>';


                      });

                      $("#purchaseRequisitionItems").html(itemsHtmls);

                      $("#requisitionForm h4").text("Total Purchase Amount:"+ TotalRequisitionAmount);
                      $("#totalRequisitionAmount").val(TotalRequisitionAmount);