Ejemplo n.º 1
0
        /// <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);
        }
        /// <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;
            }
        }