/// <summary>
/// Increase the product stock in warehouse
/// </summary>
/// <param name="product_code">
/// A <see cref="System.String"/>
/// </param>
/// <param name="qty">
/// A <see cref="System.Int32"/>
/// </param>
/// <returns>
/// A <see cref="SMProduct"/>
/// </returns>
public static SBProduct increaseProductStock(string product_code, int qty)
{
SBProduct p = SBWarehouse.getProduct(product_code);
p.Quantity = p.Quantity + qty;
p.Update();
return(p);
}
/// <summary>
/// Descrease the product stock in warehouse
/// </summary>
/// <param name="product_code">
/// A <see cref="System.String"/>
/// </param>
/// <param name="qty">
/// A <see cref="System.Int32"/>
/// </param>
/// <returns>
/// A <see cref="SMProduct"/>
/// </returns>
public static SBProduct restStock(string product_code, int qty)
{
SBProduct p = SBWarehouse.getProduct(product_code);
p.Quantity = p.Quantity - qty;
p.Quantity = (p.Quantity < 0) ? 0 : p.Quantity;
p.Update();
return(p);
}
public static List <SBTransactionType> GetTransactionTypes(bool objects = true)
{
List <SBTransactionType> tts = new List <SBTransactionType>();
ArrayList _tts = SBWarehouse.GetTransactionTypes();
if (_tts == null)
{
return(null);
}
foreach (Hashtable _tt in _tts)
{
SBTransactionType tt = new SBTransactionType();
tt.SetDbData(_tt);
tts.Add(tt);
}
return(tts);
}
/// <summary>
/// Gets the price from price rule.
/// </summary>
/// <returns>The price from price rule.</returns>
/// <param name="cost">Cost.</param>
/// <param name="category_id">Category identifier.</param>
/// <param name="price_number">Price number.</param>
public static float GetPriceFromPriceRule(float cost, int category_id, string price_number)
{
ArrayList rules = SBWarehouse.GetPriceRules(category_id, price_number);
if (rules == null)
{
return(cost);
}
string param = string.Format("cat_{0}_rounding", category_id);
string rounding = (SBGlobals.getVar("app") as SBApplication).getParameter(param, "off").ToString();
float the_price = cost;
foreach (Hashtable rule in rules)
{
float cost_from = Convert.ToSingle(rule["from"]);
float cost_to = Convert.ToSingle(rule["to"]);
float percentage = Convert.ToSingle(rule["percentage"]);
the_price = cost + (cost * percentage);
if (cost > cost_from && cost_to == -1)
{
if (the_price > 100 && rounding == "on")
{
Console.WriteLine("Price: {0}", the_price);
string price_str = ((int)the_price).ToString();
int last_digit = int.Parse(price_str[price_str.Length - 1].ToString());
if (last_digit > 0)
{
the_price += (10 - last_digit);
}
the_price = (int)the_price;
Console.WriteLine("New Price: {0}", the_price);
}
else
{
the_price = (float)Math.Ceiling(the_price);
}
break;
}
else if (cost > cost_from && cost <= cost_to)
{
if (the_price > 100 && rounding == "on")
{
Console.WriteLine("Price: {0}", the_price);
string price_str = ((int)the_price).ToString();
int last_digit = int.Parse(price_str[price_str.Length - 1].ToString());
if (last_digit > 0)
{
the_price += (10 - last_digit);
}
the_price = (int)the_price;
Console.WriteLine("New Price: {0}", the_price);
}
else
{
the_price = (float)Math.Ceiling(the_price);
}
break;
}
}
//Console.WriteLine("{0} => {1}, ({2})", cost, the_price, percentage);
return(the_price);
}
public static ArrayList getProducts(int category_id)
{
return(SBWarehouse.GetCategoryProducts(category_id));
}
/// <summary>
/// Complete an INPUT/OUTPUT transaction
/// </summary>
/// <returns><c>true</c>, if transaction was completed, <c>false</c> otherwise.</returns>
/// <param name="transaction_code">Transaction code.</param>
/// <param name="apply_price_rules">If set to <c>true</c> apply price rules.</param>
public static bool CompleteTransaction(string transaction_code, bool apply_price_rules = false)
{
try
{
SBTransaction transaction = new SBTransaction(transaction_code);
Hashtable tt = SBWarehouse.GetTransactionType(transaction.TransactionTypeId);
//check if it's an input
if (tt["in_out"].ToString().ToUpper() == "IN" || tt["in_out"].ToString().ToUpper() == "INPUT")
{
//update stocks
foreach (Hashtable item in transaction.Items)
{
SBProduct prod = new SBProduct();
prod.GetDbData(item["object_code"]);
prod.Quantity = prod.Quantity + Convert.ToInt32(item["object_quantity"]);
prod.Cost = Convert.ToDouble(item["object_price"]);
/*
* //check to apply price rules
* if( apply_price_rules )
* {
* //update product prices
* double _price = SBWarehouse.GetPriceFromPriceRule((float)prod.Cost, "price_1");
* if( _price != prod.Cost )
* prod.Price = _price;
* _price = SBWarehouse.GetPriceFromPriceRule((float)prod.Cost, "price_2");
* if( _price != prod.Cost )
* prod.Price2 = _price;
* //we need to round decimals to next integer for prices
* prod.Price = Math.Ceiling(prod.Price);
* prod.Price2 = Math.Ceiling(prod.Price2);
* }
* else
* {
* }
*/
//string p_code = prod.Code;
prod.Update();
string real_cost_str = SBMeta.GetMeta("transaction_item_meta",
"transaction_item_id", Convert.ToInt32(item["transaction_item_id"]),
"_real_cost"
).ToString();
float real_cost = 0;
float.TryParse(real_cost_str, out real_cost);
SBMeta.UpdateMeta("product_meta",
"product_code", prod.Code,
"_real_cost", real_cost.ToString("0.00")
);
//##get latest two cost of the product for weighted average inventory
float weighted_cost = 0;
string query = "SELECT unit_price FROM product_kardex " +
"WHERE transaction_type_id = {0} " +
"AND product_code = '{1}' " +
"ORDER BY creation_date DESC " +
"LIMIT 2";
query = string.Format(query, transaction.TransactionTypeId, item["object_id"].ToString());
//Console.WriteLine(query);
var costs = SBFactory.getDbh().Query(query);
if (costs != null)
{
float total_cost = 0;
foreach (Hashtable row in costs)
{
total_cost += Convert.ToSingle(row["unit_price"]);
}
weighted_cost = total_cost / 2;
}
//##get fifo cost
float cost_fifo = 0;
//##build data to create product kardex
Hashtable k = new Hashtable();
k.Add("product_code", prod.Id);
k.Add("quantity", item["object_quantity"]);
k.Add("quantity_balance", prod.Quantity);
k.Add("unit_price", item["object_price"]);
k.Add("cost", item["object_price"]);
k.Add("cost_fifo", cost_fifo);
k.Add("cost_weighted_average", weighted_cost);
k.Add("total_amount", item["total"]);
k.Add("monetary_balance", prod.Quantity * Convert.ToSingle(item["object_price"]));
k.Add("author_id", SBUser.getLoggedInUser().UserId);
k.Add("creation_date", DateTime.Now);
k.Add("transaction_code", transaction.TransactionCode);
if (prod.Status.ToLower() == "initial")
{
//create initial kardex
k.Add("in_out", "initial");
k.Add("transaction_type_id", -1);
prod.Status = "publish";
prod.Update();
}
else
{
//update product kardex
k.Add("in_out", "input");
k.Add("transaction_type_id", tt["transaction_type_id"]);
}
SBFactory.getDbh().insert("product_kardex", k);
}
//update transaction status to completed|received
string tquery = string.Format("UPDATE transactions SET status = 'received' WHERE transaction_code = '{0}'",
transaction.TransactionCode);
SBFactory.getDbh().Execute(tquery);
}
//##complete OUTPUT transaction
else
{
foreach (Hashtable item in transaction.Items)
{
//##update product stock
SBProduct prod = new SBProduct(Convert.ToInt32(item["object_id"]));
prod.Quantity = prod.Quantity - Convert.ToInt32(item["object_quantity"]);
string p_code = prod.Code;
prod.Update();
//##update product kardex
Hashtable k = new Hashtable();
k.Add("product_code", prod.Id);
k.Add("in_out", "output");
k.Add("quantity", item["object_quantity"]);
k.Add("quantity_balance", prod.Quantity);
k.Add("cost", prod.Cost);
k.Add("cost_fifo", 0); //TODO: calculated fifo cost
k.Add("cost_weighted_average", 0); //TODO: calculate average cost
k.Add("unit_price", Convert.ToSingle(item["object_price"]));
k.Add("total_amount", item["sub_total"]);
k.Add("monetary_balance", prod.Quantity * prod.Cost);
k.Add("transaction_type_id", tt["transaction_type_id"]);
k.Add("author_id", SBUser.getLoggedInUser().UserId);
k.Add("creation_date", DateTime.Now);
k.Add("transaction_code", transaction.TransactionCode);
SBFactory.getDbh().insert("product_kardex", k);
}
}
return(true);
}
catch (Exception e)
{
(SBGlobals.getVar("app") as SBApplication).logString(e.Message);
(SBGlobals.getVar("app") as SBApplication).logString(e.StackTrace);
throw e;
}
}
