<?php
include("include/config.inc.php");

$purchaseMasterId = isset($_REQUEST['purchaseMasterId']) ? $_REQUEST['purchaseMasterId'] : 0;

if($purchaseMasterId > 0)
{
    $selectMaster = "SELECT purchaseMasterId,colorId,totalkg,purchaseDetailId
                        FROM purchasedetail
                         WHERE purchaseMasterId  = ".$_REQUEST['purchaseMasterId'];
    $selectMasterRes = mysql_query($selectMaster);
    while($purRow = mysql_fetch_array($selectMasterRes))
    {
      $purchaseDetailId   = $purRow['purchaseDetailId'];
      $purchaseMasterId   = $purRow['purchaseMasterId'];
      $colorId            = $purRow['colorId'];
      $totalkg            = $purRow['totalkg'];

      $selectMst = "SELECT partyId
                        FROM purchasemaster
                    WHERE purchaseMasterId = ".$purchaseMasterId;
      $selectMstRes = mysql_query($selectMst);
      if($parRow = mysql_fetch_array($selectMstRes))
      {
         $partyId = $parRow['partyId'];
      }


        $select = "SELECT qty
                     FROM stock
                   WHERE partyId = ".$partyId."
                   AND colorId = ".$colorId;
        $selectRes = mysql_query($select);
        if($stockRow = mysql_fetch_array($selectRes))
        {
          $current = $stockRow['qty'];
        }

        $updateStock = "UPDATE stock
                          SET qty = ".$current." - ".$totalkg."
                          WHERE partyId = ".$partyId."
                        AND colorId = ".$colorId;
        $updateStockRes = mysql_query($updateStock);
        if($updateStockRes)
        {
          $delete = "DELETE FROM purchasedetail
                         WHERE purchaseDetailId  = ".$_REQUEST['purchaseDetailId'];
          $deleteRes = mysql_query($delete);
          if(mysql_num_rows($deleteRes) == 0)
          {
            $deleteMst = "DELETE FROM purchasemaster
                         WHERE purchaseMasterId  = ".$_REQUEST['purchaseMasterId'];
            $deleteMstRes = mysql_query($deleteMst);
            if(!$deleteMstRes)
            {
              echo "Master Delete Fail";
            }
            else
            {
              header("Location:purdetail.php");
            }
          }
        }
    }
}

?>