Giter VIP home page Giter VIP logo

warehouse-inventory-system's Introduction

Oswa - inv

OSWA-INV v2 image #Warehouse inventory system


The application was initially created by Siamon Hasan, useing php, mysql and bootstrap.

OSWA-INV is a web based Inventory System, that will allow you to keep tracking of the quantity buying and selling price of the products existing in your warehouse or business. When creating a new products, you can set a quantity,buying and selling price.


If you find any bug, and a fix for that bug, please leave a comment on the github page for this project and i will push the change into the master branch.

Installing this application is fairly easy, just follow these steps:


  1. Download the latest version with git (git clone https://github.com/siamon123/warehouse-inventory-system.git)

  2. Import/load oswa_inv.sql into your mysql database. This should set up the basic structure of the database system.

  3. Modify the includes/config.php and change the variables to match your host, database, username and passwords.

  4. Change all Folder permission inside uploads folder either add them to group call www if available or 777.

  5. Then loging by typing username and password:

    Administrator Special User Default User
    Username : admin Username : special Username : user
    Password : admin Password : special Password : user
  6. Good luck!


DON'T FORGET TO GIVE US FEEDBACK


Like @OSWA on Facebook for more project.

Don't forget to visit oswapp.com

warehouse-inventory-system's People

Contributors

siamon123 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

warehouse-inventory-system's Issues

not working on live server

When i have uploaded files on web server the redirect ('admin.php',false) would not work in auth page. Does anyone of you made a fix to it. please help. thanks in advance

Hi I love this Inventory but having issues

Generate Sales Report is Having Issues. Hoping this will be fixed because I need this software in my shop.

It has this issues
Notice: Undefined variable: profit in C:\xampp\htdocs\WIS\includes\functions.php on line 83

Cannot Generate Sales Report :(

sale_report_process.php add this for this issue.

function total_price($totals){ $sum = 0; $sub = 0; $profit = 0; /*add variable for the profit result*/ foreach($totals as $total ){ $sum += $total['total_saleing_price']; $sub += $total['total_buying_price']; $profit = $sum - $sub; } return array($sum,$profit); }

Doesn`t load the index page

I import all file to my host and change the config.php file with my db information, but no load the index page. An error comes out: "An Exception was thrown while handling: not found" when i search the url "localhost/project/warehouse-inventory-system/index.php" in browser.

Thankssss for all.

Variable profit in includes/function.php

function total_price($totals){
$sum = 0;
$sub = 0;

foreach($totals as $total ){
$sum += $total['total_saleing_price'];
$sub += $total['total_buying_price'];
$profit = $sum - $sub;
}
return array($sum,$profit); <= not yet defined so if i want to fix it how ?

function total_price($totals){
$sum = 0;
$sub = 0;
$profit = 0; <= can i change to be like this ?
foreach($totals as $total ){
$sum += $total['total_saleing_price'];
$sub += $total['total_buying_price'];
$profit = $sum - $sub;
}
return array($sum,$profit);

Ajax.php is not working

When you click the find it button at sale -> add sale -> find it, ajax.php does not seem to respond or display the result. I typed ipad. It didn't show anything.

sql not parameterized

I see you are doing escaping, but still, string concatenation, seems risky. mysqli is already there, just make all the queries parameterized to prevent injection

Setting user previlledges

Hi,

Thanks for the great tool, I want to add two users in the application one is admin and second is for entries only who can not add or remove users.

Thanks

load barcode

Hi guys, i have installed oswap in my local server, but i ask you if it is possible to use a barcode reader to load articles faster, thanks.

Thanks for allowing me to use it and some suggestions.

Hi. You code is so clear that I can read it without difficulty, Thanks a lot for allowing me to use it. I've added some small function but it's still have trouble. I write it in https://github.com/Qmoliang/accounting-star-system. Besides, I want to know in which environment you build those files, for example, includes and layout. Is it built and designed by yourself or by software default? If it's from software, can you tell me which software? PHPstorm or sublime? Since I can't establish your files' structure automatically.

Session Start issue

I get the following each and every time I attempt to add or remove anything in the system.

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /folder1/folder2/folder3/folder4/includes/load.php:2) in /folder1/folder2/folder3/folder4/includes/session.php on line 2

Parameter in addsale.php

Hi

In the file add_sale.php I can see this lines
`

Buscar
`

and I can see you send a parameter to ajax.php

`<?php
// Auto suggetion
$html = '';
if(isset($_POST['product_name']) && strlen($_POST['product_name']))
{
$products = find_product_by_title($_POST['product_name']);
if($products){
foreach ($products as $product):
$html .= "<li class="list-group-item">";
$html .= $product['name'];
$html .= "";
endforeach;
} else {

    $html .= '<li onClick=\"fill(\''.addslashes().'\')\" class=\"list-group-item\">';
    $html .= 'No encontrado';
    $html .= "</li>";

  }

  echo json_encode($html);

}
?>`

the problem is I want to change the parameter but I dont see the pamarameter called "product_name" from add_sale.php to ajax.php..can you explain me pleasee. I need this project for my school..=)

Wich is your logic, please let me know .

Is really interested your system.

Thanks

Error en daily and monthly

Hi, i have this error in

monthly_sales.php
SELECT s.qty, DATE_FORMAT(s.date, '%Y-%m-%e') AS date,p.name,SUM(p.sale_price * s.qty) AS total_saleing_price FROM sales s LEFT JOIN products p ON s.product_id = p.id WHERE DATE_FORMAT(s.date, '%Y' ) = '2020' GROUP BY DATE_FORMAT( s.date, '%c' ),s.product_id ORDER BY date_format(s.date, '%c' ) ASC

daily_sales.php
SELECT s.qty, DATE_FORMAT(s.date, '%Y-%m-%e') AS date,p.name,SUM(p.sale_price * s.qty) AS total_saleing_price FROM sales s LEFT JOIN products p ON s.product_id = p.id WHERE DATE_FORMAT(s.date, '%Y-%m' ) = '2020-06' GROUP BY DATE_FORMAT( s.date, '%e' ),s.product_id

Upload image

When I upload multiple images, it responds correctly (2 images)
screen shot 2015-12-31 at 17 22 24
But uploads only the last image of the set.

add sale

This is a nice product u created.

When click the Add Sale, nothing happens.

Thanks.

PHP Parse error on homepage

Hi,

I get a parse error by visiting my local warehouse-inventory-system
PHP Parse error: parse error, expecting ','' or ';'' in /Users/henkvalk/Sites/warehouse/warehouse-inventory-system/includes/upload.php on line 10

public $userPath = SITE_ROOT.DS.'..'.DS.'uploads/users';
public $productPath = SITE_ROOT.DS.'..'.DS.'uploads/products';

After changing it with full relative path the login will show up:

public $userPath = '/Users/henkvalk/Sites/warehouse/warehouse-inventory-system/uploads/users';
public $productPath = '/Users/henkvalk/Sites/warehouse/warehouse-inventory-system/uploads/products';

Login access failed

I Siamon123, I had copy all the fils to the server and changed the password via MD5 for admin user in database table but still it is saying wrong password/ username can you help me.

Thanks

Parse error:

Parse error: syntax error, unexpected '.', expecting ',' or ';' in C:\wamp\www\inventory\warehouse-inventory-system\includes\upload.php on line 10
Call Stack

Time Memory Function Location

1 0.0005 136064 {main}( ) ..\index.php:0
2 0.0009 157688 require_once( 'C:\wamp\www\inventory\warehouse-inventory-system\includes\load.php' ) ..\index.php:3

Insert sale date

When I enter a sale and change the date, it always stores the date of today.

No matter if I choose a date from the selector or enter it myself.

Sign Up page missing

Can't sign up or login new users, even new users are made from admin panel. help please

set up everything and error happens after login

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /Users/username/Downloads/warehouse-inventory-system/includes/load.php:1) in /Users/username/Downloads/warehouse-inventory-system/includes/session.php on line 2

any idea?

Generate Sales Report

This shows up when I try to generate a sales report.

( ! ) Parse error: syntax error, unexpected '[' in C:\wamp\www\warehouse-inventory-system-master\sale_report_process.php on line 115

me da un error en upload

Parse error: syntax error, unexpected '.', expecting ',' or ';' in C:\wamp\www\warehouse-inventory-system\includes\upload.php on line 10 como lo puedo resolver

Acces denied

Hi. I encountered this issue at the time of deploying it in xampp.
Wasrning: mysqli_connect(): (HY000/1045): Access denied for user 'admin'@'localhost' (using password: YES) in C:\xampp\htdocs....\includes\database.php on line 18
Database connection failed:Access denied for user 'admin'@'localhost' (using password: YES).

New users cannot login

Hello,
I have a problem, I have created few users, and somehow they cannot login to the system
Could you help me fix this problem ?

Thanks.

Parse error:

Hello

I'm using a local Wamp server. After installing I had a blank screen. When i activated the PHP Error display option this is what I got.

Parse error: syntax error, unexpected '.', expecting ',' or ';' in C:\wamp\www\inventorysystem\includes\upload.php on line 10

I can not pass this stage.

Reports Not working

Your warehouse invetory system is cool. but part of the report is still error. hehe. approximately in the section where the error?

timezone issue

Getting the error of , it is not good to depend on system time. Can you please help us where to set the time and change UTC to IST and fix the issue.

View Article Page

Hi to all!
i ve found today this beautiful script and customizing for my need.
Any idea how create a view product page with image?
i try to do but i cannot show image, i retrive all data...
thx

best regards

``

msg("d","Missing product id."); redirect('product.php'); } ?>
     </strong>
    </div>
    <div class="panel-body">
   
     <div class="col-md-7">
   
  		<img src="uploads/products/<?php echo $product['image']; ?>" alt="product-image" class="img-circle img-inline">
        <br><hr>
     
       NAME:<?php echo remove_junk($product['name']);?><br>
       COD:<?php echo remove_junk($product['code']);?><br>
       Q.TY<?php echo remove_junk($product['quantity']); ?><br>
       ACQ<?php echo remove_junk($product['buy_price']);?><br>
       EBAY<?php echo remove_junk($product['sale_price']);?><br>
       DATA_ENTRY<?php echo read_date($product['date']); ?>
                  
  </div>

[Error] - I can sell more than I have in stock

Currently the system is allowing to sell more than the amount I have in stock.
I registered 4 products, but sold 5 and the stock was negative.

Where can I get this function so that inventory is updated whenever there is a sale and does not allow me to sell more than I have in stock?

Error

Installation

how to add group call permissions and after that which tab should i open first? it's very confusing and if you can share full documentation of this very then it could be very easy to understand revert as soon as possible

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.