function AddTransaction($user_id, $object_id)
{
$start_date = date('Y-m-d H:i:s');
mysql_query("INSERT INTO `sale_transaction`\r\n\t\t\t\t\t(`user_id`, `object_id`, `start_date`, `status`) \r\n\t\t\t\t VALUES\r\n\t\t\t\t\t({$user_id}, {$object_id}, '{$start_date}', 4)");
return GetTransactionId($object_id);
}
function Calculate($object_id)
{
$result = mysql_query("\tSELECT \t\t\t`production`.`id` AS id,\r\n\t\t\t\t\t\t\t\t\t\t\t`production`.`name` AS name,\r\n\t\t\t\t\t\t\t\t\t\t\t`sale_transaction_detail`.`product_quantity` AS quantity,\r\n\t\t\t\t\t\t\t\t\t\t\t`object`.`warehouse`AS object\r\n\t\t\t\t\t\t\tFROM\t\t\t`sale_transaction_detail` \r\n\t\t\t\t\t\t\tINNER JOIN\t\t`production`\r\n\t\t\t\t\t\t\t\tON\t\t\t`sale_transaction_detail`.`production_id` = `production`.`id`\r\n\t\t\t\t\t\t\tINNER JOIN\t\t`sale_transaction`\r\n\t\t\t\t\t\t\t\tON\t\t\t`sale_transaction_detail`.`transaction_id` = `sale_transaction`.`id`\r\n\t\t\t\t\t\t\tLEFT JOIN\t\t`object` ON `sale_transaction`.`object_id` = `object`.`id`\r\n\t\t\t\t\t\t\tWHERE\t\t\t`sale_transaction`.`object_id` = {$object_id} AND `sale_transaction`.`status` = 1");
$transaction_id = GetTransactionId($object_id);
$myres = mysql_query("SELECT sale_transaction_detail.id AS id, production_id AS prod_id \r\n\t\t\t\t\t\t\tFROM `sale_transaction_detail`\r\n\t\t\t\t\t\t\tWHERE sale_transaction_detail.transaction_id = {$transaction_id}");
while ($row2 = mysql_fetch_assoc($myres)) {
$req = mysql_fetch_assoc($result);
$row3 = mysql_fetch_assoc(mysql_query("SELECT `production_id` AS `id`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `product_quantity` AS `quantity`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM `sale_transaction_detail`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `id` = {$row2['id']}"));
SaleDone($row3['id'], $row3['quantity'], $req['object']);
}
return false;
}
