Code Monkey home page Code Monkey logo

ronknight / inventorysystem Goto Github PK

View Code? Open in Web Editor NEW
308.0 308.0 135.0 18.63 MB

🖥️Create an open-source Inventory Management System using CodeIgniter web framework, Php and MySQL. Original source code from an Online Inventory Management Software found on https://codersfolder.com/2018/02/stock-management-system-v2-codeigniter/.

License: MIT License

PHP 76.20% HTML 0.21% JavaScript 6.63% CSS 5.53% Less 11.43%
codeigniter inventory-system mysql php

inventorysystem's Introduction

Edit in Eraser

Create an Inventory System using CodeIgniter, MySQL & PHP

ScreenshotsFeaturesCredentialRequirementsInstallationResourcesDiagrams


Screenshots

Login Page

Dashboard

Database

Features

  1. Manage Users
  • Add new user detail
  • View, Update, and remove user information
  1. Manage Groups
  • Add new group information
  • View, Update, and remove group information
  1. Manage Brands
  • Add new brand data
  • View, Update, and remove brand information
  1. Manage Category
  • Add new category information
  • View, Update, and remove category information
  1. Manage Stores
  • Add new store information
  • View, Update, and remove stores information
  1. Manage Attributes
  • Add new attribute information
  • View, Update, and remove attributes information
  1. Manage Products
  • Add new product information
  • View, Update, and remove products information
  1. Manage Orders
  • Add new order information
  • View, Update, and remove orders information
  1. Reports
  • View total amount of sales represented on the graphical chart based on yearly.
  1. Company
  • Update the company information
  • That includes company name, address, phone, message, vat charge, service charge and more..
  1. Profile
  • View the logged in user information
  1. Setting
  • View, and Update logged in user information

Credential

email: [email protected] password: password

database name: stock

Requirements

PHP version 5.6 or newer is recommended.

It should work on 5.3.7 as well, but we strongly advise you NOT to run
such old versions of PHP, because of potential security and performance
issues, as well as missing features.

Application Server

You can choose to install any of the following Application Server: LAMP, MAMP, XAMMP.

Installation

  1. Clone or download files. Add them to your Root folder if you are using XAMMP the location is "C:\xampp\htdocs\InventorySystem".
  2. Open PhpMyAdmin from your local Application Server.
  3. Create new database and name it as "stock"
  4. Import stock.sql to your stock database.
  5. Turn On Apache and MySQL on your Application Server Control Panel.
  6. Your system show be found on http://localhost/InventorySystem/

Resources

Original Sourcecode from CodeFolder - https://codersfolder.com/2018/02/stock-management-system-v2-codeigniter/ CodeIgniter - Web Framework AdminLTE - Theme

Diagrams

inventorysystem's People

Contributors

dependabot[bot] avatar peppers96 avatar ricson18 avatar riochndr avatar ronknight 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

inventorysystem's Issues

Unable to Login

I have install the InventorySystem but if I would login it can't open /auth/login because the folder doesn't exist. I can't find the folder anywhere. Can someone help me?

can't install

I am receiving this error while trying to install

An uncaught Exception was encountered
Type: Error

Message: Call to undefined function mysql_connect()

Filename: /Users/umut/Sites/lastore/system/database/drivers/mysql/mysql_driver.php

Line Number: 136

Backtrace:

File: /Users/umut/Sites/lastore/application/core/MY_Controller.php
Line: 7
Function: __construct

File: /Users/umut/Sites/lastore/application/core/MY_Controller.php
Line: 17
Function: __construct

File: /Users/umut/Sites/lastore/application/controllers/Auth.php
Line: 10
Function: __construct

File: /Users/umut/Sites/lastore/index.php
Line: 315
Function: require_once

File: /Users/umut/.composer/vendor/laravel/valet/server.php
Line: 235
Function: require

No import products functionality

There is no import product functionality. Products are created one by one and not in bulk.

It would be neat to be able to import CSV files and create products in bulk.

Product Quantity

The work is very nicely done and also intersting but I have faced some issue on it

  1. The product Quantity won't stop @ 0 it will continue to negative number when an order is made
  2. IF the order is made and it is not paid if we drop/delete the order the product quantity will not return the subtracted product quantity to the database. if you can help it will be best

Print function on Report

Generate reports and make a print button to make a hard copy of the report as well as exporting to Excel, CSV, pdf.

Datatable broblem

DataTables warning: table id=manageTable - Ajax error. For more information about this error, please see http://datatables.net/tn/7

image

I get this error when accesing and trying to manage the:
Category, Stores and Brands pages

How do I translate the application

Dear,

I am e newbie to php and websites.
What is the easiest way to translate the website via dreamweaver or some other software?

Kind regards,

Bregt

Possible XSS vulnerabilities

Hello,

I would like to report for possible XSS vulnerabilities.

For example,

In file InventorySystem-master\application\controllers\Stores.php in update function

$data = array(
	'name' => $this->input->post('edit_store_name'),
	'active' => $this->input->post('edit_active'),	
);

$update = $this->model_stores->update($data, $id);

In file InventorySystem-master\application\models\Model_stores.php

public function update($data, $id){
  if($data && $id) {
	  $this->db->where('id', $id);
	  $update = $this->db->update('stores', $data);
	  return ($update == true) ? true : false;
  }
}

Then In file InventorySystem-master\application\controllers\Stores.php

public function fetchStoresDataById($id) {
  if($id) {
	  $data = $this->model_stores->getStoresData($id);
	  echo json_encode($data);
  }
}

In file InventorySystem-master\application\models\Model_stores.php

public function getStoresData($id = null){
  if($id) {
	  $sql = "SELECT * FROM `stores` where id = ?";
	  $query = $this->db->query($sql, array($id));
	  return $query->row_array();
  }
  
  $sql = "SELECT * FROM `stores`";
  $query = $this->db->query($sql);
  return $query->result_array();
}

My_controller

Hello,
Can someone help me understand this in MY_Controller
$this->load->view($page, $data);
Like I understand that it loads view but not sure what type of data is stored in those to variables
$page
$data

Here is complete function code
public function render_template($page = null, $data = array())
{

	//$this->load->view('admin/include/header',$data);
	$this->load->view('templates/header');
	//$this->load->view('templates/header_menu',$data);
	//$this->load->view('templates/side_menubar',$data);
	$this->load->view($page, $data);
	//$this->load->view('templates/footer',$data);
}

Thank you,

Stat boxes not showing

Stat boxes only shows up when using the default user. Need to enable stat boxes for Admin Group.

Password

When I’m trying to login it says the password is incorrect any issues as to how to resolve this

reports by month

hi

can some help me with the reporting by months? i mean breakdown per months

Only shows index

An uncaught Exception was encountered
Type: mysqli_sql_exception

Message: Unknown database 'stock'

Filename: C:\xampp\htdocs\InventorySystem\system\database\drivers\mysqli\mysqli_driver.php

Line Number: 201

Backtrace:

File: C:\xampp\htdocs\InventorySystem\application\core\MY_Controller.php
Line: 7
Function: __construct

File: C:\xampp\htdocs\InventorySystem\application\core\MY_Controller.php
Line: 17
Function: __construct

File: C:\xampp\htdocs\InventorySystem\application\controllers\Auth.php
Line: 10
Function: __construct

File: C:\xampp\htdocs\InventorySystem\index.php
Line: 315
Function: require_once

this is the error that i get

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.