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();
}
