function getProductAvailableQty($materialId) { $getReturnMessage = new CommonMethods(); global $dbh; $stmt = $dbh->prepare("SELECT * FROM inventory WHERE materialid={$materialId}"); if ($stmt->execute()) { $json_array = array(); while ($result2 = $stmt->fetch(PDO::FETCH_ASSOC)) { $inventoryData = array(); $inventoryData['warehouseid'] = $result2['warehouseid']; $inventoryData['companyid'] = $result2['companyid']; $inventoryData['inventoryid'] = $result2['inventoryid']; $inventoryData['totalquantity'] = $result2['totalquantity']; $inventoryData['packagingtype'] = $result2['packagingtype']; $inventoryData['packagingsize'] = $result2['packagingsize']; $warehouseId = $result2['warehouseid']; $companyId = $result2['companyid']; $inventoryData['companyName'] = DatabaseCommonOperations::getCompanyName($warehouseId); $inventoryData['warehouseName'] = DatabaseCommonOperations::getWarehouseName($companyId); array_push($json_array, $inventoryData); } $json = json_encode($json_array); echo $json; // $getReturnMessage->showAlert('success',$json ); } else { $getReturnMessage->showAlert('error', "No Data Found"); } }
$productModel->_setProductAbbrevations($productDetails->abbrevation); $productModel->_setProductUnitOfMeasure($productDetails->unitofmeasure); $productModel->_setProductAlertQty($productDetails->alertquantity); $productModel->_setProductColor($productDetails->color); $productModel->_setProductDescription($productDetails->description); $productModel->_setProductPackaging($productDetails->packaging); $productModel->_setProductType($productDetails->materialtypeid); $productModel->_setProductOperation($productDetails->opertaion); $productObj = new Product($productModel); switch ($productDetails->opertaion) { case 'insert': # code... if (!$productObj->isAvailable($dbh)) { $productObj->insertProductInToDb($dbh, $userId); } else { $showAlerts->showAlert("Failure", "Product you are trying to add is already added"); } break; case 'delete': # code... //$productObj = new Product(); $productObj->deleteProduct($dbh, $userId, $productDetails); break; case 'modify': if ($productDetails->isProductMasterTable || $productDetails->isProductDetailsTable || $productDetails->isProductPackagingTable || $productDetails->isProductMaterialTable) { $productObj->updateProduct($dbh, $userId, $productDetails); } else { $showAlerts->showAlert('Failure', "Nothing to update"); } break; default: