function mappingItemWithDistributor($itemKeyValues) { global $currentDistributorId, $itemDistTableFields; $filterDistData = filterItemDistributorFields($itemKeyValues); $itemDistValues = array_values($filterDistData); $checkItemQuery = "SELECT ItemId FROM itemname_rules where `name` like '" . $itemKeyValues['Name'] . "'"; $result = mysql_query($checkItemQuery, getMyConnection()); if (mysql_num_rows($result) > 0) { $nameRuleResult = mysql_fetch_assoc($result); if ($nameRuleResult['ItemId']) { $existingItemId = $nameRuleResult['ItemId']; $query = "INSERT INTO item_distributor (`ItemId`, `DistributorId`, `" . implode("`, `", $itemDistTableFields) . "`) " . "VALUES(" . $existingItemId . ", " . $currentDistributorId . ", '" . implode("', '", $itemDistValues) . "')" . " ON DUPLICATE KEY UPDATE ItemId=" . $existingItemId . ", DistributorId= " . $currentDistributorId . ", Mrp= " . $filterDistData['mrp'] . ", SellingPrice=" . $filterDistData['selling price'] . ", Offer='" . $filterDistData['offer'] . "'"; $res = mysql_query($query, getMyConnection()); return $res; } } else { createExceptionFile($itemKeyValues); } closeConnection(); }
function mappingItemWithDistributor($itemId, $itemKeyValues) { global $currentDistributorId, $itemDistTableFields; $filterDistData = filterItemDistributorFields($itemKeyValues); $itemDistValues = array_values($filterDistData); $filterItemData = filterItemMasterFields($itemKeyValues); $nameRuleQuery = "INSERT INTO itemname_rules (`itemId`, `Name`) VALUES(" . $itemId . ", '" . $filterItemData['name'] . "')"; $nameRuleResult = mysql_query($nameRuleQuery, getMyConnection()); if ($nameRuleResult) { $query = "INSERT INTO item_distributor (`ItemId`, `DistributorId`, `" . implode("`, `", $itemDistTableFields) . "`) " . "VALUES(" . $itemId . ", " . $currentDistributorId . ", '" . implode("', '", $itemDistValues) . "')" . " ON DUPLICATE KEY UPDATE ItemId=" . $itemId . ", DistributorId= " . $currentDistributorId . ", Mrp= " . $filterDistData['mrp'] . ", SellingPrice=" . $filterDistData['selling price'] . ", Offer='" . $filterDistData['offer'] . "'"; $res = mysql_query($query, getMyConnection()); return $res; } closeConnection(); }