function AddSubtraction($user_id, $prod_id, $quantity, $object_id)
{
$self_cost = 0;
$check = IsProduct($prod_id);
if ($check) {
$res = mysql_fetch_assoc(mysql_query("SELECT \tpricelist.`price` AS `cost`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tROUND((SELECT DISTINCT reserve.price FROM reserve WHERE reserve.production_id = production.id ),2) AS `self_cost`\r\n\t\t\t\t\t\t\t\t\t\t\t\tFROM `production`\r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN pricelist ON pricelist.production_id = `production`.`id`\r\n\t\t\t\t\t\t\t\t\t\t\t WHERE `production`.`id` NOT IN (SELECT `recipie_id` FROM `recipie`) AND `production`.`actived` = 1 AND `production`.`id` = {$prod_id}"));
$self_cost = $res['self_cost'] * $quantity;
} else {
$res = mysql_fetch_assoc(mysql_query("SELECT pricelist.`price` AS `cost`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t ROUND(SUM((SELECT DISTINCT reserve.price FROM reserve WHERE reserve.production_id = rec.ingredient_id ) * rec.quantity * rec.default_amount),2) AS `self_cost` \r\n\t\t\t\t\t\t\t\t\t\t\t FROM `recipie` AS rec \r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN `production` ON `production`.`id` = `rec`.`recipie_id`\r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN pricelist ON pricelist.production_id = `rec`.`recipie_id`\r\n\t\t\t\t\t\t\t\t\t\t\t WHERE `production`.`id` IN (SELECT `recipie_id` FROM `recipie`) AND `production`.`actived` = 1 AND `production`.`id` = {$prod_id}\r\n\t\t\t\t\t\t\t\t\t\t\tGROUP BY rec.recipie_id"));
$self_cost = $res['self_cost'] * $quantity;
}
$date = date('Y-m-d H:i:s');
mysql_query("INSERT INTO `sale_transaction`\r\n\t(`user_id`, `object_id`, `start_date`, `end_date`, `sum_self_cost`, `status`)\r\n\tVALUES\r\n\t({$user_id}, {$object_id}, '{$date}', '{$date}', {$self_cost}, 5)");
$tr_id = mysql_insert_id();
global $log;
$log->setInsertLog('sale_transaction');
mysql_query("INSERT INTO `sale_transaction_detail`\r\n\t(`user_id`, `transaction_id`, `production_id`, `product_quantity`, `self_cost`)\r\n\tVALUES\r\n\t({$user_id}, {$tr_id}, {$prod_id}, {$quantity}, {$self_cost})");
$log->setInsertLog('sale_transaction_detail');
}
}
}
break;
case 'print_check':
$price = $_REQUEST['price'];
printCheck($price);
break;
case 'add_prod_seo':
$prod = $_REQUEST['name'];
$object_id = $_REQUEST['obj_id'];
$prod_id = GetProductID($prod);
$trans_id = $_REQUEST['trans_id'];
$user_id = $_COOKIE['USERID'];
$price = GetProductPrice($prod_id);
$s_price = getProdSelfCost($prod_id);
$isProduct = IsProduct($prod_id);
if ($isProduct) {
$status = CheckObjectStatus($object_id);
if (!$status) {
$trans_id = AddTransaction($user_id, $object_id);
$prod_exist = CheckProductionExists($prod_id, 1, $object_id);
if ($prod_exist) {
AddProd($user_id, $object_id, GetTransactionId($object_id), $prod_id, 1, $s_price, $price);
} else {
$error = 'არასაკმარისი პროდუქტი!';
}
} else {
$prod_exist = CheckProductionExists($prod_id, 1, $object_id);
if ($prod_exist) {
AddProd($user_id, $object_id, GetTransactionId($object_id), $prod_id, 1, $s_price, $price);
} else {
