Source Code Inventory Management System using PHP Native 7.0 jQuery Ajax Bootstrap

This Inventory Management System is an Open Source Project developed using PHP PDO, Mysql Database, Bootstrap Library, Ajax and Jquery Datatables plugins. This system is a web based application and it is created using PHP PDO, Ajax, Jquery Datatables plugins, Bootstrap Library and Mysql Database. This system will provide features such as managing categories, brands, products, orders, and reporting to users.

This is a web-based system then the primary user can operate this system from anywhere using any device, because it's web-based and responsive design. So we can access this system using any device. So a web based Stock Management system makes it easy to keep your stock perfectly from any location. Stock control is one of the main bases of any developed business and this system will help to increase their business stock accurately.

Source Code Inventory Management System using PHP Native 7.0 jQuery Ajax Bootstrap

The Web-based Inventory Management System has countless benefits compared to desktop-based systems, as it can be accessed from anywhere you just need an internet connection and you can also check the stock status of the goods from your mobile device. On other uses of Web-based Inventory management system development is that some users can gain access at the same time. The following is a feature of this system.

Features

Password Encrypted Password is Guaranteed
Master and Sub User Profiles to change details like Name, Email and Password
Master users can create new sub-users, edit sub-user details and login active / inactive users
Master users can add new categories, rename categories and delete category usage
Master users can add new brands, update brand details and remove brands
Master users can enter new products, update product details and remove products
Master and sub users can generate new orders with many items

Master and sub users can edit order details by adding or multiple products from orders
Master and sub users can generate PDF Invoices from certain orders
Master users can track certain quantities available
Teachers can view the total categories, brands, products, orders, and user details
Sub users can view the order they have created
Teachers can view the entire system analysis on their index page

Source Code Inventory Management System using PHP Mysqli jQuery Ajax Bootstrap

Source Code Inventory Jquery Ajax Boostrap

database_connection.php

<?php

//database_connection.php

$connect = new PDO('mysql:host=localhost;dbname=testing2', 'root', '');

session_start();

login.php

<?php

//login.php

include('database_connection.php');

if(isset($_SESSION['type']))

{

header("location:index.php");

}

$message = '';

if(isset($_POST["login"]))

{

$query = "

SELECT * FROM user_details

WHERE user_email = :user_email

$statement = $connect->prepare($query);

$statement->execute(

array(

'user_email' => $_POST["user_email"]

)

);

$count = $statement->rowCount();

if($count > 0)

{

$result = $statement->fetchAll();

foreach($result as $row)

{

if(password_verify($_POST["user_password"], $row["user_password"]))

{

if($row['user_status'] == 'Active')

{

$_SESSION['type'] = $row['user_type'];

$_SESSION['user_id'] = $row['user_id'];

$_SESSION['user_name'] = $row['user_name'];

header("location:index.php");

}

else

{

$message = "<label>Your account is disabled, Contact Master</label>";

}

else

{

$message = "<label>Wrong Password</label>";

}

else

{

$message = "<label>Wrong Email Address</labe>";

}

<!DOCTYPE html>

<html>

<head>

<title>Inventory Management System using PHP with Ajax Jquery</title>

</head>

<body>

<br />

<h2 align="center">Inventory Management System using PHP with Ajax Jquery</h2>

<br />

<div class="panel-heading">Login</div>

<?php echo $message; ?>

<label>User Email</label>

</div>

<label>Password</label>

</div>

</div>

</form>

</div>

</body>

</html>

header.php

<?php

//header.php

<!DOCTYPE html>

<html>

<head>

<title>Inventory Management System</title>

</head>

<body>

<br />

<h2 align="center">Inventory Management System</h2>

</div>

<?php

if($_SESSION['type'] == 'master')

{

<li><a href="category.php">Category</a></li>

<li><a href="brand.php">Brand</a></li>

<li><a href="product.php">Product</a></li>

<?php

}

<li><a href="order.php">Order</a></li>

</ul>

<li><a href="profile.php">Profile</a></li>

<li><a href="logout.php">Logout</a></li>

</ul>

</li>

</ul>

</div>

</nav>

footer.php

</div>

</body>

</html>

index.php

<?php

//index.php

include('database_connection.php');

include('function.php');

if(!isset($_SESSION["type"]))

{

header("location:login.php");

}

include('header.php');

<br />

<?php

if($_SESSION['type'] == 'master')

{

<div class="panel-heading"><strong>Total User</strong></div>

</div>

<div class="panel-heading"><strong>Total Category</strong></div>

</div>

<div class="panel-heading"><strong>Total Brand</strong></div>

</div>

<div class="panel-heading"><strong>Total Item in Stock</strong></div>

</div>

<?php

}

<div class="panel-heading"><strong>Total Order Value</strong></div>

</div>

<div class="panel-heading"><strong>Total Cash Order Value</strong></div>

</div>

<div class="panel-heading"><strong>Total Credit Order Value</strong></div>

</div>

<hr />

<?php

if($_SESSION['type'] == 'master')

{

<div class="panel-heading"><strong>Total Order Value User wise</strong></div>

<?php echo get_user_wise_total_order($connect); ?>

</div>

<?php

}

</div>

<?php

include("footer.php");

logout.php

<?php

//logout.php

session_start();

session_destroy();

header("location:login.php");

profile.php

<?php

//profile.php

include('database_connection.php');

if(!isset($_SESSION['type']))

{

header("location:login.php");

}

$query = "

SELECT * FROM user_details

WHERE user_id = '".$_SESSION["user_id"]."'

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$name = '';

$email = '';

$user_id = '';

foreach($result as $row)

{

$name = $row['user_name'];

$email = $row['user_email'];

}

include('header.php');

<div class="panel-heading">Edit Profile</div>

<input type="text" name="user_name" id="user_name" class="form-control" value="<?php echo $name; ?>" required />

</div>

<label>Email</label>

</div>

<hr />

<label>Leave Password blank if you do not want to change</label>

<label>New Password</label>

</div>

<label>Re-enter Password</label>

</div>

</div>

</form>

</div>

$(document).ready(function(){

$('#edit_profile_form').on('submit', function(event){

event.preventDefault();

if($('#user_new_password').val() != '')

{

if($('#user_new_password').val() != $('#user_re_enter_password').val())

{

$('#error_password').html('<label class="text-danger">Password Not Match</label>');

return false;

}

else

{

$('#error_password').html('');

}

$('#edit_prfile').attr('disabled', 'disabled');

var form_data = $(this).serialize();

$('#user_re_enter_password').attr('required',false);

$.ajax({

url:"edit_profile.php",

method:"POST",

data:form_data,

success:function(data)

{

$('#edit_prfile').attr('disabled', false);

$('#user_new_password').val('');

$('#user_re_enter_password').val('');

$('#message').html(data);

}

})

});

</script>

edit_profile.php

<?php

//edit_profile.php

include('database_connection.php');

if(isset($_POST['user_name']))

{

if($_POST["user_new_password"] != '')

{

$query = "

UPDATE user_details SET

user_name = '".$_POST["user_name"]."',

user_email = '".$_POST["user_email"]."',

user_password = '".password_hash($_POST["user_new_password"], PASSWORD_DEFAULT)."'

WHERE user_id = '".$_SESSION["user_id"]."'

}

else

{

$query = "

UPDATE user_details SET

user_name = '".$_POST["user_name"]."',

user_email = '".$_POST["user_email"]."'

WHERE user_id = '".$_SESSION["user_id"]."'

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

if(isset($result))

{

echo '<div class="alert alert-success">Profile Edited</div>';

}

user.php

<?php

//user.php

include('database_connection.php');

if(!isset($_SESSION["type"]))

{

header('location:login.php');

}

if($_SESSION["type"] != 'master')

{

header("location:index.php");

}

include('header.php');

</div>

</div>

</div>

<thead>

<tr>

<th>Email</th>

<th>Status</th>

<th>Delete</th>

</tr>

</thead>

</table>

</div>

</div>

<label>Enter User Name</label>

</div>

<label>Enter User Email</label>

</div>

<label>Enter User Password</label>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

</form>

</div>

$(document).ready(function(){

$('#add_button').click(function(){

$('#user_form')[0].reset();

$('.modal-title').html("<i class='fa fa-plus'></i> Add User");

$('#action').val("Add");

$('#btn_action').val("Add");

});

var userdataTable = $('#user_data').DataTable({

"processing": true,

"serverSide": true,

"order": [],

"ajax":{

url:"user_fetch.php",

type:"POST"

"columnDefs":[

{

"target":[4,5],

"orderable":false

}

"pageLength": 25

});

$(document).on('submit', '#user_form', function(event){

event.preventDefault();

$('#action').attr('disabled','disabled');

var form_data = $(this).serialize();

$.ajax({

url:"user_action.php",

method:"POST",

data:form_data,

success:function(data)

{

$('#user_form')[0].reset();

$('#userModal').modal('hide');

$('#alert_action').fadeIn().html('<div class="alert alert-success">'+data+'</div>');

$('#action').attr('disabled', false);

userdataTable.ajax.reload();

}

})

});

$(document).on('click', '.update', function(){

var user_id = $(this).attr("id");

var btn_action = 'fetch_single';

$.ajax({

url:"user_action.php",

method:"POST",

data:{user_id:user_id, btn_action:btn_action},

dataType:"json",

success:function(data)

{

$('#userModal').modal('show');

$('#user_name').val(data.user_name);

$('#user_email').val(data.user_email);

$('.modal-title').html("<i class='fa fa-pencil-square-o'></i> Edit User");

$('#user_id').val(user_id);

$('#action').val('Edit');

$('#btn_action').val('Edit');

$('#user_password').attr('required', false);

}

})

});

$(document).on('click', '.delete', function(){

var user_id = $(this).attr("id");

var status = $(this).data('status');

var btn_action = "delete";

if(confirm("Are you sure you want to change status?"))

{

$.ajax({

url:"user_action.php",

method:"POST",

data:{user_id:user_id, status:status, btn_action:btn_action},

success:function(data)

{

$('#alert_action').fadeIn().html('<div class="alert alert-info">'+data+'</div>');

userdataTable.ajax.reload();

}

})

}

else

{

return false;

}

});

</script>

<?php

include('footer.php');

user_fetch.php

<?php

//user_fetch.php

include('database_connection.php');

$query = '';

$output = array();

$query .= "

SELECT * FROM user_details

WHERE user_type = 'user' AND

if(isset($_POST["search"]["value"]))

{

$query .= '(user_email LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR user_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR user_status LIKE "%'.$_POST["search"]["value"].'%") ';

}

if(isset($_POST["order"]))

{

$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';

}

else

{

$query .= 'ORDER BY user_id DESC ';

}

if($_POST["length"] != -1)

{

$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$data = array();

$filtered_rows = $statement->rowCount();

foreach($result as $row)

{

$status = '';

if($row["user_status"] == 'Active')

{

$status = '<span class="label label-success">Active</span>';

}

else

{

$status = '<span class="label label-danger">Inactive</span>';

}

$sub_array = array();

$sub_array[] = $row['user_id'];

$sub_array[] = $row['user_email'];

$sub_array[] = $row['user_name'];

$sub_array[] = $status;

$sub_array[] = '<button type="button" name="update" id="'.$row["user_id"].'" class="btn btn-warning btn-xs update">Update</button>';

$sub_array[] = '<button type="button" name="delete" id="'.$row["user_id"].'" class="btn btn-danger btn-xs delete" data-status="'.$row["user_status"].'">Delete</button>';

$data[] = $sub_array;

}

$output = array(

"draw" => intval($_POST["draw"]),

"recordsTotal" => $filtered_rows,

"recordsFiltered" => get_total_all_records($connect),

"data" => $data

);

echo json_encode($output);

function get_total_all_records($connect)

{

$statement = $connect->prepare("SELECT * FROM user_details WHERE user_type='user'");

$statement->execute();

return $statement->rowCount();

}

user_action.php

<?php

//user_action.php

include('database_connection.php');

if(isset($_POST['btn_action']))

{

if($_POST['btn_action'] == 'Add')

{

$query = "

INSERT INTO user_details (user_email, user_password, user_name, user_type, user_status)

VALUES (:user_email, :user_password, :user_name, :user_type, :user_status)

$statement = $connect->prepare($query);

$statement->execute(

array(

':user_email' => $_POST["user_email"],

':user_password' => password_hash($_POST["user_password"], PASSWORD_DEFAULT),

':user_name' => $_POST["user_name"],

':user_type' => 'user',

':user_status' => 'active'

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'New User Added';

}

if($_POST['btn_action'] == 'fetch_single')

{

$query = "

SELECT * FROM user_details WHERE user_id = :user_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':user_id' => $_POST["user_id"]

)

);

$result = $statement->fetchAll();

foreach($result as $row)

{

$output['user_email'] = $row['user_email'];

$output['user_name'] = $row['user_name'];

}

echo json_encode($output);

}

if($_POST['btn_action'] == 'Edit')

{

if($_POST['user_password'] != '')

{

$query = "

UPDATE user_details SET

user_name = '".$_POST["user_name"]."',

user_email = '".$_POST["user_email"]."',

user_password = '".password_hash($_POST["user_password"], PASSWORD_DEFAULT)."'

WHERE user_id = '".$_POST["user_id"]."'

}

else

{

$query = "

UPDATE user_details SET

user_name = '".$_POST["user_name"]."',

user_email = '".$_POST["user_email"]."'

WHERE user_id = '".$_POST["user_id"]."'

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

if(isset($result))

{

echo 'User Details Edited';

}

if($_POST['btn_action'] == 'delete')

{

$status = 'Active';

if($_POST['status'] == 'Active')

{

$status = 'Inactive';

}

$query = "

UPDATE user_details

SET user_status = :user_status

WHERE user_id = :user_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':user_status' => $status,

':user_id' => $_POST["user_id"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'User Status change to ' . $status;

}

category.php

<?php

//category.php

include('database_connection.php');

if(!isset($_SESSION['type']))

{

header('location:login.php');

}

if($_SESSION['type'] != 'master')

{

header("location:index.php");

}

include('header.php');

<h3 class="panel-title">Category List</h3>

</div>

</div>

</div>

<th>Category Name</th>

<th>Status</th>

<th>Delete</th>

</tr></thead>

</table>

</div>

<h4 class="modal-title"><i class="fa fa-plus"></i> Add Category</h4>

</div>

<label>Enter Category Name</label>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

</form>

</div>

$(document).ready(function(){

$('#add_button').click(function(){

$('#category_form')[0].reset();

$('.modal-title').html("<i class='fa fa-plus'></i> Add Category");

$('#action').val('Add');

$('#btn_action').val('Add');

});

$(document).on('submit','#category_form', function(event){

event.preventDefault();

$('#action').attr('disabled','disabled');

var form_data = $(this).serialize();

$.ajax({

url:"category_action.php",

method:"POST",

data:form_data,

success:function(data)

{

$('#category_form')[0].reset();

$('#categoryModal').modal('hide');

$('#alert_action').fadeIn().html('<div class="alert alert-success">'+data+'</div>');

$('#action').attr('disabled', false);

categorydataTable.ajax.reload();

}

})

});

$(document).on('click', '.update', function(){

var category_id = $(this).attr("id");

var btn_action = 'fetch_single';

$.ajax({

url:"category_action.php",

method:"POST",

data:{category_id:category_id, btn_action:btn_action},

dataType:"json",

success:function(data)

{

$('#categoryModal').modal('show');

$('#category_name').val(data.category_name);

$('.modal-title').html("<i class='fa fa-pencil-square-o'></i> Edit Category");

$('#category_id').val(category_id);

$('#action').val('Edit');

$('#btn_action').val("Edit");

}

})

});

var categorydataTable = $('#category_data').DataTable({

"processing":true,

"serverSide":true,

"order":[],

"ajax":{

url:"category_fetch.php",

type:"POST"

"columnDefs":[

{

"targets":[3, 4],

"orderable":false,

"pageLength": 25

});

$(document).on('click', '.delete', function(){

var category_id = $(this).attr('id');

var status = $(this).data("status");

var btn_action = 'delete';

if(confirm("Are you sure you want to change status?"))

{

$.ajax({

url:"category_action.php",

method:"POST",

data:{category_id:category_id, status:status, btn_action:btn_action},

success:function(data)

{

$('#alert_action').fadeIn().html('<div class="alert alert-info">'+data+'</div>');

categorydataTable.ajax.reload();

}

})

}

else

{

return false;

}

});

</script>

<?php

include('footer.php');

brand.php

<?php

//brand.php

include('database_connection.php');

include('function.php');

if(!isset($_SESSION['type']))

{

header('location:login.php');

}

if($_SESSION['type'] != 'master')

{

header('location:index.php');

}

include('header.php');

<h3 class="panel-title">Brand List</h3>

</div>

</div>

<thead>

<tr>

<th>Category</th>

<th>Brand Name</th>

<th>Status</th>

<th>Delete</th>

</tr>

</thead>

</table>

</div>

<h4 class="modal-title"><i class="fa fa-plus"></i> Add Brand</h4>

</div>

<option value="">Select Category</option>

<?php echo fill_category_list($connect); ?>

</select>

</div>

<label>Enter Brand Name</label>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

</form>

</div>

$(document).ready(function(){

$('#add_button').click(function(){

$('#brandModal').modal('show');

$('#brand_form')[0].reset();

$('.modal-title').html("<i class='fa fa-plus'></i> Add Brand");

$('#action').val('Add');

$('#btn_action').val('Add');

});

$(document).on('submit','#brand_form', function(event){

event.preventDefault();

$('#action').attr('disabled','disabled');

var form_data = $(this).serialize();

$.ajax({

url:"brand_action.php",

method:"POST",

data:form_data,

success:function(data)

{

$('#brand_form')[0].reset();

$('#brandModal').modal('hide');

$('#alert_action').fadeIn().html('<div class="alert alert-success">'+data+'</div>');

$('#action').attr('disabled', false);

branddataTable.ajax.reload();

}

})

});

$(document).on('click', '.update', function(){

var brand_id = $(this).attr("id");

var btn_action = 'fetch_single';

$.ajax({

url:'brand_action.php',

method:"POST",

data:{brand_id:brand_id, btn_action:btn_action},

dataType:"json",

success:function(data)

{

$('#brandModal').modal('show');

$('#category_id').val(data.category_id);

$('#brand_name').val(data.brand_name);

$('.modal-title').html("<i class='fa fa-pencil-square-o'></i> Edit Brand");

$('#brand_id').val(brand_id);

$('#action').val('Edit');

$('#btn_action').val('Edit');

}

})

});

$(document).on('click','.delete', function(){

var brand_id = $(this).attr("id");

var status = $(this).data('status');

var btn_action = 'delete';

if(confirm("Are you sure you want to change status?"))

{

$.ajax({

url:"brand_action.php",

method:"POST",

data:{brand_id:brand_id, status:status, btn_action:btn_action},

success:function(data)

{

$('#alert_action').fadeIn().html('<div class="alert alert-info">'+data+'</div>');

branddataTable.ajax.reload();

}

})

}

else

{

return false;

}

});

var branddataTable = $('#brand_data').DataTable({

"processing":true,

"serverSide":true,

"order":[],

"ajax":{

url:"brand_fetch.php",

type:"POST"

"columnDefs":[

{

"targets":[4, 5],

"orderable":false,

"pageLength": 10

});

</script>

<?php

include('footer.php');

brand_fetch.php

<?php

//brand_fetch.php

include('database_connection.php');

$query = '';

$output = array();

$query .= "

SELECT * FROM brand

INNER JOIN category ON category.category_id = brand.category_id

if(isset($_POST["search"]["value"]))

{

$query .= 'WHERE brand.brand_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR category.category_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR brand.brand_status LIKE "%'.$_POST["search"]["value"].'%" ';

}

if(isset($_POST["order"]))

{

$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';

}

else

{

$query .= 'ORDER BY brand.brand_id DESC ';

}

if($_POST["length"] != -1)

{

$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$data = array();

$filtered_rows = $statement->rowCount();

foreach($result as $row)

{

$status = '';

if($row['brand_status'] == 'active')

{

$status = '<span class="label label-success">Active</span>';

}

else

{

$status = '<span class="label label-danger">Inactive</span>';

}

$sub_array = array();

$sub_array[] = $row['brand_id'];

$sub_array[] = $row['category_name'];

$sub_array[] = $row['brand_name'];

$sub_array[] = $status;

$sub_array[] = '<button type="button" name="update" id="'.$row["brand_id"].'" class="btn btn-warning btn-xs update">Update</button>';

$sub_array[] = '<button type="button" name="delete" id="'.$row["brand_id"].'" class="btn btn-danger btn-xs delete" data-status="'.$row["brand_status"].'">Delete</button>';

$data[] = $sub_array;

}

function get_total_all_records($connect)

{

$statement = $connect->prepare('SELECT * FROM brand');

$statement->execute();

return $statement->rowCount();

}

$output = array(

"draw" => intval($_POST["draw"]),

"recordsTotal" => $filtered_rows,

"recordsFiltered" => get_total_all_records($connect),

"data" => $data

);

echo json_encode($output);

brand_action.php

<?php

//brand_action.php

include('database_connection.php');

if(isset($_POST['btn_action']))

{

if($_POST['btn_action'] == 'Add')

{

$query = "

INSERT INTO brand (category_id, brand_name)

VALUES (:category_id, :brand_name)

$statement = $connect->prepare($query);

$statement->execute(

array(

':category_id' => $_POST["category_id"],

':brand_name' => $_POST["brand_name"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Brand Name Added';

}

if($_POST['btn_action'] == 'fetch_single')

{

$query = "

SELECT * FROM brand WHERE brand_id = :brand_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':brand_id' => $_POST["brand_id"]

)

);

$result = $statement->fetchAll();

foreach($result as $row)

{

$output['category_id'] = $row['category_id'];

$output['brand_name'] = $row['brand_name'];

}

echo json_encode($output);

}

if($_POST['btn_action'] == 'Edit')

{

$query = "

UPDATE brand set

category_id = :category_id,

brand_name = :brand_name

WHERE brand_id = :brand_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':category_id' => $_POST["category_id"],

':brand_name' => $_POST["brand_name"],

':brand_id' => $_POST["brand_id"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Brand Name Edited';

}

if($_POST['btn_action'] == 'delete')

{

$status = 'active';

if($_POST['status'] == 'active')

{

$status = 'inactive';

}

$query = "

UPDATE brand

SET brand_status = :brand_status

WHERE brand_id = :brand_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':brand_status' => $status,

':brand_id' => $_POST["brand_id"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Brand status change to ' . $status;

}

product.php

<?php

//product.php

include('database_connection.php');

include('function.php');

if(!isset($_SESSION["type"]))

{

header('location:login.php');

}

if($_SESSION['type'] != 'master')

{

header('location:index.php');

}

include('header.php');

<h3 class="panel-title">Product List</h3>

</div>

</div>

<th>Category</th>

<th>Brand</th>

<th>Product Name</th>

<th>Quantity</th>

<th>Enter By</th>

<th>Status</th>

</tr></thead>

</table>

</div></div>

</div>

<h4 class="modal-title"><i class="fa fa-plus"></i> Add Product</h4>

</div>

<label>Select Category</label>

<option value="">Select Category</option>

<?php echo fill_category_list($connect);?>

</select>

</div>

<label>Select Brand</label>

<option value="">Select Brand</option>

</select>

</div>

<label>Enter Product Name</label>

</div>

<label>Enter Product Description</label>

</div>

<label>Enter Product Quantity</label>

<option value="">Select Unit</option>

<option value="Bottles">Bottles</option>

<option value="Dozens">Dozens</option>

<option value="Gallon">Gallon</option>

<option value="Grams">Grams</option>

<option value="Liters">Liters</option>

<option value="Meter">Meter</option>

<option value="Packet">Packet</option>

<option value="Rolls">Rolls</option>

</select>

</span>

</div>

<label>Enter Product Base Price</label>

</div>

<label>Enter Product Tax (%)</label>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

</form>

</div>

<h4 class="modal-title"><i class="fa fa-plus"></i> Product Details</h4>

</div>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

</form>

</div>

$(document).ready(function(){

var productdataTable = $('#product_data').DataTable({

"processing":true,

"serverSide":true,

"order":[],

"ajax":{

url:"product_fetch.php",

type:"POST"

"columnDefs":[

{

"targets":[7, 8, 9],

"orderable":false,

"pageLength": 10

});

$('#add_button').click(function(){

$('#productModal').modal('show');

$('#product_form')[0].reset();

$('.modal-title').html("<i class='fa fa-plus'></i> Add Product");

$('#action').val("Add");

$('#btn_action').val("Add");

});

$('#category_id').change(function(){

var category_id = $('#category_id').val();

var btn_action = 'load_brand';

$.ajax({

url:"product_action.php",

method:"POST",

data:{category_id:category_id, btn_action:btn_action},

success:function(data)

{

$('#brand_id').html(data);

}

});

$(document).on('submit', '#product_form', function(event){

event.preventDefault();

$('#action').attr('disabled', 'disabled');

var form_data = $(this).serialize();

$.ajax({

url:"product_action.php",

method:"POST",

data:form_data,

success:function(data)

{

$('#product_form')[0].reset();

$('#productModal').modal('hide');

$('#alert_action').fadeIn().html('<div class="alert alert-success">'+data+'</div>');

$('#action').attr('disabled', false);

productdataTable.ajax.reload();

}

})

});

$(document).on('click', '.view', function(){

var product_id = $(this).attr("id");

var btn_action = 'product_details';

$.ajax({

url:"product_action.php",

method:"POST",

data:{product_id:product_id, btn_action:btn_action},

success:function(data){

$('#productdetailsModal').modal('show');

$('#product_details').html(data);

}

})

});

$(document).on('click', '.update', function(){

var product_id = $(this).attr("id");

var btn_action = 'fetch_single';

$.ajax({

url:"product_action.php",

method:"POST",

data:{product_id:product_id, btn_action:btn_action},

dataType:"json",

success:function(data){

$('#productModal').modal('show');

$('#category_id').val(data.category_id);

$('#brand_id').html(data.brand_select_box);

$('#brand_id').val(data.brand_id);

$('#product_name').val(data.product_name);

$('#product_description').val(data.product_description);

$('#product_quantity').val(data.product_quantity);

$('#product_unit').val(data.product_unit);

$('#product_base_price').val(data.product_base_price);

$('#product_tax').val(data.product_tax);

$('.modal-title').html("<i class='fa fa-pencil-square-o'></i> Edit Product");

$('#product_id').val(product_id);

$('#action').val("Edit");

$('#btn_action').val("Edit");

}

})

});

$(document).on('click', '.delete', function(){

var product_id = $(this).attr("id");

var status = $(this).data("status");

var btn_action = 'delete';

if(confirm("Are you sure you want to change status?"))

{

$.ajax({

url:"product_action.php",

method:"POST",

data:{product_id:product_id, status:status, btn_action:btn_action},

success:function(data){

$('#alert_action').fadeIn().html('<div class="alert alert-info">'+data+'</div>');

productdataTable.ajax.reload();

}

});

}

else

{

return false;

}

});

</script>

product_fetch.php

<?php

//product_fetch.php

include('database_connection.php');

$query = '';

$output = array();

$query .= "

SELECT * FROM product

INNER JOIN brand ON brand.brand_id = product.brand_id

INNER JOIN category ON category.category_id = product.category_id

INNER JOIN user_details ON user_details.user_id = product.product_enter_by

if(isset($_POST["search"]["value"]))

{

$query .= 'WHERE brand.brand_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR category.category_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR product.product_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR product.product_quantity LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR user_details.user_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR product.product_id LIKE "%'.$_POST["search"]["value"].'%" ';

}

if(isset($_POST['order']))

{

$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';

}

else

{

$query .= 'ORDER BY product_id DESC ';

}

if($_POST['length'] != -1)

{

$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$data = array();

$filtered_rows = $statement->rowCount();

foreach($result as $row)

{

$status = '';

if($row['product_status'] == 'active')

{

$status = '<span class="label label-success">Active</span>';

}

else

{

$status = '<span class="label label-danger">Inactive</span>';

}

$sub_array = array();

$sub_array[] = $row['product_id'];

$sub_array[] = $row['category_name'];

$sub_array[] = $row['brand_name'];

$sub_array[] = $row['product_name'];

$sub_array[] = $row['product_quantity'] . ' ' . $row['product_unit'];

$sub_array[] = $row['user_name'];

$sub_array[] = $status;

$sub_array[] = '<button type="button" name="view" id="'.$row["product_id"].'" class="btn btn-info btn-xs view">View</button>';

$sub_array[] = '<button type="button" name="update" id="'.$row["product_id"].'" class="btn btn-warning btn-xs update">Update</button>';

$sub_array[] = '<button type="button" name="delete" id="'.$row["product_id"].'" class="btn btn-danger btn-xs delete" data-status="'.$row["product_status"].'">Delete</button>';

$data[] = $sub_array;

}

function get_total_all_records($connect)

{

$statement = $connect->prepare('SELECT * FROM product');

$statement->execute();

return $statement->rowCount();

}

$output = array(

"draw" => intval($_POST["draw"]),

"recordsTotal" => $filtered_rows,

"recordsFiltered" => get_total_all_records($connect),

"data" => $data

);

echo json_encode($output);

product_action.php

<?php

//product_action.php

include('database_connection.php');

include('function.php');

if(isset($_POST['btn_action']))

{

if($_POST['btn_action'] == 'load_brand')

{

echo fill_brand_list($connect, $_POST['category_id']);

}

if($_POST['btn_action'] == 'Add')

{

$query = "

INSERT INTO product (category_id, brand_id, product_name, product_description, product_quantity, product_unit, product_base_price, product_tax, product_enter_by, product_status, product_date)

VALUES (:category_id, :brand_id, :product_name, :product_description, :product_quantity, :product_unit, :product_base_price, :product_tax, :product_enter_by, :product_status, :product_date)

$statement = $connect->prepare($query);

$statement->execute(

array(

':category_id' => $_POST['category_id'],

':brand_id' => $_POST['brand_id'],

':product_name' => $_POST['product_name'],

':product_description' => $_POST['product_description'],

':product_quantity' => $_POST['product_quantity'],

':product_unit' => $_POST['product_unit'],

':product_base_price' => $_POST['product_base_price'],

':product_tax' => $_POST['product_tax'],

':product_enter_by' => $_SESSION["user_id"],

':product_status' => 'active',

':product_date' => date("Y-m-d")

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Product Added';

}

if($_POST['btn_action'] == 'product_details')

{

$query = "

SELECT * FROM product

INNER JOIN category ON category.category_id = product.category_id

INNER JOIN brand ON brand.brand_id = product.brand_id

INNER JOIN user_details ON user_details.user_id = product.product_enter_by

WHERE product.product_id = '".$_POST["product_id"]."'

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$output = '

foreach($result as $row)

{

$status = '';

if($row['product_status'] == 'active')

{

$status = '<span class="label label-success">Active</span>';

}

else

{

$status = '<span class="label label-danger">Inactive</span>';

}

$output .= '

<tr>

<td>Product Name</td>

<td>'.$row["product_name"].'</td>

</tr>

<tr>

<td>Product Description</td>

<td>'.$row["product_description"].'</td>

</tr>

<tr>

<td>Category</td>

<td>'.$row["category_name"].'</td>

</tr>

<tr>

<td>Brand</td>

<td>'.$row["brand_name"].'</td>

</tr>

<tr>

<td>Available Quantity</td>

<td>'.$row["product_quantity"].' '.$row["product_unit"].'</td>

</tr>

<tr>

<td>Base Price</td>

<td>'.$row["product_base_price"].'</td>

</tr>

<tr>

<td>'.$row["product_tax"].'</td>

</tr>

<tr>

<td>Enter By</td>

</tr>

<tr>

<td>Status</td>

<td>'.$status.'</td>

</tr>

}

$output .= '

</table>

</div>

echo $output;

}

if($_POST['btn_action'] == 'fetch_single')

{

$query = "

SELECT * FROM product WHERE product_id = :product_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':product_id' => $_POST["product_id"]

)

);

$result = $statement->fetchAll();

foreach($result as $row)

{

$output['category_id'] = $row['category_id'];

$output['brand_id'] = $row['brand_id'];

$output["brand_select_box"] = fill_brand_list($connect, $row["category_id"]);

$output['product_name'] = $row['product_name'];

$output['product_description'] = $row['product_description'];

$output['product_quantity'] = $row['product_quantity'];

$output['product_unit'] = $row['product_unit'];

$output['product_base_price'] = $row['product_base_price'];

$output['product_tax'] = $row['product_tax'];

}

echo json_encode($output);

}

if($_POST['btn_action'] == 'Edit')

{

$query = "

UPDATE product

set category_id = :category_id,

brand_id = :brand_id,

product_name = :product_name,

product_description = :product_description,

product_quantity = :product_quantity,

product_unit = :product_unit,

product_base_price = :product_base_price,

product_tax = :product_tax

WHERE product_id = :product_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':category_id' => $_POST['category_id'],

':brand_id' => $_POST['brand_id'],

':product_name' => $_POST['product_name'],

':product_description' => $_POST['product_description'],

':product_quantity' => $_POST['product_quantity'],

':product_unit' => $_POST['product_unit'],

':product_base_price' => $_POST['product_base_price'],

':product_tax' => $_POST['product_tax'],

':product_id' => $_POST['product_id']

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Product Details Edited';

}

if($_POST['btn_action'] == 'delete')

{

$status = 'active';

if($_POST['status'] == 'active')

{

$status = 'inactive';

}

$query = "

UPDATE product

SET product_status = :product_status

WHERE product_id = :product_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':product_status' => $status,

':product_id' => $_POST["product_id"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Product status change to ' . $status;

}

order_fetch.php

<?php

//order_fetch.php

include('database_connection.php');

include('function.php');

$query = '';

$output = array();

$query .= "

SELECT * FROM inventory_order WHERE

if($_SESSION['type'] == 'user')

{

$query .= 'user_id = "'.$_SESSION["user_id"].'" AND ';

}

if(isset($_POST["search"]["value"]))

{

$query .= '(inventory_order_id LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR inventory_order_name LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR inventory_order_total LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR inventory_order_status LIKE "%'.$_POST["search"]["value"].'%" ';

$query .= 'OR inventory_order_date LIKE "%'.$_POST["search"]["value"].'%") ';

}

if(isset($_POST["order"]))

{

$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';

}

else

{

$query .= 'ORDER BY inventory_order_id DESC ';

}

if($_POST["length"] != -1)

{

$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$data = array();

$filtered_rows = $statement->rowCount();

foreach($result as $row)

{

$payment_status = '';

if($row['payment_status'] == 'cash')

{

$payment_status = '<span class="label label-primary">Cash</span>';

}

else

{

$payment_status = '<span class="label label-warning">Credit</span>';

}

$status = '';

if($row['inventory_order_status'] == 'active')

{

$status = '<span class="label label-success">Active</span>';

}

else

{

$status = '<span class="label label-danger">Inactive</span>';

}

$sub_array = array();

$sub_array[] = $row['inventory_order_id'];

$sub_array[] = $row['inventory_order_name'];

$sub_array[] = $row['inventory_order_total'];

$sub_array[] = $payment_status;

$sub_array[] = $status;

$sub_array[] = $row['inventory_order_date'];

if($_SESSION['type'] == 'master')

{

$sub_array[] = get_user_name($connect, $row['user_id']);

}

$sub_array[] = '<a href="view_order.php?pdf=1&order_id='.$row["inventory_order_id"].'" class="btn btn-info btn-xs">View PDF</a>';

$sub_array[] = '<button type="button" name="update" id="'.$row["inventory_order_id"].'" class="btn btn-warning btn-xs update">Update</button>';

$sub_array[] = '<button type="button" name="delete" id="'.$row["inventory_order_id"].'" class="btn btn-danger btn-xs delete" data-status="'.$row["inventory_order_status"].'">Delete</button>';

$data[] = $sub_array;

}

function get_total_all_records($connect)

{

$statement = $connect->prepare("SELECT * FROM inventory_order");

$statement->execute();

return $statement->rowCount();

}

$output = array(

"draw" => intval($_POST["draw"]),

"recordsTotal" => $filtered_rows,

"recordsFiltered" => get_total_all_records($connect),

"data" => $data

);

echo json_encode($output);

order_action.php

<?php

//order_action.php

include('database_connection.php');

include('function.php');

if(isset($_POST['btn_action']))

{

if($_POST['btn_action'] == 'Add')

{

$query = "

INSERT INTO inventory_order (user_id, inventory_order_total, inventory_order_date, inventory_order_name, inventory_order_address, payment_status, inventory_order_status, inventory_order_created_date)

VALUES (:user_id, :inventory_order_total, :inventory_order_date, :inventory_order_name, :inventory_order_address, :payment_status, :inventory_order_status, :inventory_order_created_date)

$statement = $connect->prepare($query);

$statement->execute(

array(

':user_id' => $_SESSION["user_id"],

':inventory_order_total' => 0,

':inventory_order_date' => $_POST['inventory_order_date'],

':inventory_order_name' => $_POST['inventory_order_name'],

':inventory_order_address' => $_POST['inventory_order_address'],

':payment_status' => $_POST['payment_status'],

':inventory_order_status' => 'active',

':inventory_order_created_date' => date("Y-m-d")

)

);

$result = $statement->fetchAll();

$statement = $connect->query("SELECT LAST_INSERT_ID()");

$inventory_order_id = $statement->fetchColumn();

if(isset($inventory_order_id))

{

$total_amount = 0;

for($count = 0; $count<count($_POST["product_id"]); $count++)

{

$product_details = fetch_product_details($_POST["product_id"][$count], $connect);

$sub_query = "

INSERT INTO inventory_order_product (inventory_order_id, product_id, quantity, price, tax) VALUES (:inventory_order_id, :product_id, :quantity, :price, :tax)

$statement = $connect->prepare($sub_query);

$statement->execute(

array(

':inventory_order_id' => $inventory_order_id,

':product_id' => $_POST["product_id"][$count],

':quantity' => $_POST["quantity"][$count],

':price' => $product_details['price'],

':tax' => $product_details['tax']

)

);

$base_price = $product_details['price'] * $_POST["quantity"][$count];

$tax = ($base_price/100)*$product_details['tax'];

$total_amount = $total_amount + ($base_price + $tax);

}

$update_query = "

UPDATE inventory_order

SET inventory_order_total = '".$total_amount."'

WHERE inventory_order_id = '".$inventory_order_id."'

$statement = $connect->prepare($update_query);

$statement->execute();

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Order Created...';

echo '<br />';

echo $total_amount;

echo '<br />';

echo $inventory_order_id;

}

if($_POST['btn_action'] == 'fetch_single')

{

$query = "

SELECT * FROM inventory_order WHERE inventory_order_id = :inventory_order_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':inventory_order_id' => $_POST["inventory_order_id"]

)

);

$result = $statement->fetchAll();

$output = array();

foreach($result as $row)

{

$output['inventory_order_name'] = $row['inventory_order_name'];

$output['inventory_order_date'] = $row['inventory_order_date'];

$output['inventory_order_address'] = $row['inventory_order_address'];

$output['payment_status'] = $row['payment_status'];

}

$sub_query = "

SELECT * FROM inventory_order_product

WHERE inventory_order_id = '".$_POST["inventory_order_id"]."'

$statement = $connect->prepare($sub_query);

$statement->execute();

$sub_result = $statement->fetchAll();

$product_details = '';

$count = '';

foreach($sub_result as $sub_row)

{

$product_details .= '

$(document).ready(function(){

$("#product_id'.$count.'").selectpicker("val", '.$sub_row["product_id"].');

$(".selectpicker").selectpicker();

});

</script>

'.fill_product_list($connect).'

</select>

</div>

</div>

if($count == '')

{

$product_details .= '<button type="button" name="add_more" id="add_more" class="btn btn-success btn-xs">+</button>';

}

else

{

$product_details .= '<button type="button" name="remove" id="'.$count.'" class="btn btn-danger btn-xs remove">-</button>';

}

$product_details .= '

</div>

</div><br />

</span>

$count = $count + 1;

}

$output['product_details'] = $product_details;

echo json_encode($output);

}

if($_POST['btn_action'] == 'Edit')

{

$delete_query = "

DELETE FROM inventory_order_product

WHERE inventory_order_id = '".$_POST["inventory_order_id"]."'

$statement = $connect->prepare($delete_query);

$statement->execute();

$delete_result = $statement->fetchAll();

if(isset($delete_result))

{

$total_amount = 0;

for($count = 0; $count < count($_POST["product_id"]); $count++)

{

$product_details = fetch_product_details($_POST["product_id"][$count], $connect);

$sub_query = "

INSERT INTO inventory_order_product (inventory_order_id, product_id, quantity, price, tax) VALUES (:inventory_order_id, :product_id, :quantity, :price, :tax)

$statement = $connect->prepare($sub_query);

$statement->execute(

array(

':inventory_order_id' => $_POST["inventory_order_id"],

':product_id' => $_POST["product_id"][$count],

':quantity' => $_POST["quantity"][$count],

':price' => $product_details['price'],

':tax' => $product_details['tax']

)

);

$base_price = $product_details['price'] * $_POST["quantity"][$count];

$tax = ($base_price/100)*$product_details['tax'];

$total_amount = $total_amount + ($base_price + $tax);

}

$update_query = "

UPDATE inventory_order

SET inventory_order_name = :inventory_order_name,

inventory_order_date = :inventory_order_date,

inventory_order_address = :inventory_order_address,

inventory_order_total = :inventory_order_total,

payment_status = :payment_status

WHERE inventory_order_id = :inventory_order_id

$statement = $connect->prepare($update_query);

$statement->execute(

array(

':inventory_order_name' => $_POST["inventory_order_name"],

':inventory_order_date' => $_POST["inventory_order_date"],

':inventory_order_address' => $_POST["inventory_order_address"],

':inventory_order_total' => $total_amount,

':payment_status' => $_POST["payment_status"],

':inventory_order_id' => $_POST["inventory_order_id"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Order Edited...';

}

if($_POST['btn_action'] == 'delete')

{

$status = 'active';

if($_POST['status'] == 'active')

{

$status = 'inactive';

}

$query = "

UPDATE inventory_order

SET inventory_order_status = :inventory_order_status

WHERE inventory_order_id = :inventory_order_id

$statement = $connect->prepare($query);

$statement->execute(

array(

':inventory_order_status' => $status,

':inventory_order_id' => $_POST["inventory_order_id"]

)

);

$result = $statement->fetchAll();

if(isset($result))

{

echo 'Order status change to ' . $status;

}

function.php

<?php

//function.php

function fill_category_list($connect)

{

$query = "

SELECT * FROM category

WHERE category_status = 'active'

ORDER BY category_name ASC

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$output = '';

foreach($result as $row)

{

$output .= '<option value="'.$row["category_id"].'">'.$row["category_name"].'</option>';

}

return $output;

}

function fill_brand_list($connect, $category_id)

{

$query = "SELECT * FROM brand

WHERE brand_status = 'active'

AND category_id = '".$category_id."'

ORDER BY brand_name ASC";

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$output = '<option value="">Select Brand</option>';

foreach($result as $row)

{

$output .= '<option value="'.$row["brand_id"].'">'.$row["brand_name"].'</option>';

}

return $output;

}

function get_user_name($connect, $user_id)

{

$query = "

SELECT user_name FROM user_details WHERE user_id = '".$user_id."'

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

foreach($result as $row)

{

return $row['user_name'];

}

function fill_product_list($connect)

{

$query = "

SELECT * FROM product

WHERE product_status = 'active'

ORDER BY product_name ASC

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$output = '';

foreach($result as $row)

{

$output .= '<option value="'.$row["product_id"].'">'.$row["product_name"].'</option>';

}

return $output;

}

function fetch_product_details($product_id, $connect)

{

$query = "

SELECT * FROM product

WHERE product_id = '".$product_id."'";

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

foreach($result as $row)

{

$output['product_name'] = $row["product_name"];

$output['quantity'] = $row["product_quantity"];

$output['price'] = $row['product_base_price'];

$output['tax'] = $row['product_tax'];

}

return $output;

}

function available_product_quantity($connect, $product_id)

{

$product_data = fetch_product_details($product_id, $connect);

$query = "

SELECT inventory_order_product.quantity FROM inventory_order_product

INNER JOIN inventory_order ON inventory_order.inventory_order_id = inventory_order_product.inventory_order_id

WHERE inventory_order_product.product_id = '".$product_id."' AND

inventory_order.inventory_order_status = 'active'

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$total = 0;

foreach($result as $row)

{

$total = $total + $row['quantity'];

}

$available_quantity = intval($product_data['quantity']) - intval($total);

if($available_quantity == 0)

{

$update_query = "

UPDATE product SET

product_status = 'inactive'

WHERE product_id = '".$product_id."'

$statement = $connect->prepare($update_query);

$statement->execute();

}

return $available_quantity;

}

function count_total_user($connect)

{

$query = "

SELECT * FROM user_details WHERE user_status='active'";

$statement = $connect->prepare($query);

$statement->execute();

return $statement->rowCount();

}

function count_total_category($connect)

{

$query = "

SELECT * FROM category WHERE category_status='active'

$statement = $connect->prepare($query);

$statement->execute();

return $statement->rowCount();

}

function count_total_brand($connect)

{

$query = "

SELECT * FROM brand WHERE brand_status='active'

$statement = $connect->prepare($query);

$statement->execute();

return $statement->rowCount();

}

function count_total_product($connect)

{

$query = "

SELECT * FROM product WHERE product_status='active'

$statement = $connect->prepare($query);

$statement->execute();

return $statement->rowCount();

}

function count_total_order_value($connect)

{

$query = "

SELECT sum(inventory_order_total) as total_order_value FROM inventory_order

WHERE inventory_order_status='active'

if($_SESSION['type'] == 'user')

{

$query .= ' AND user_id = "'.$_SESSION["user_id"].'"';

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

foreach($result as $row)

{

return number_format($row['total_order_value'], 2);

}

function count_total_cash_order_value($connect)

{

$query = "

SELECT sum(inventory_order_total) as total_order_value FROM inventory_order

WHERE payment_status = 'cash'

AND inventory_order_status='active'

if($_SESSION['type'] == 'user')

{

$query .= ' AND user_id = "'.$_SESSION["user_id"].'"';

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

foreach($result as $row)

{

return number_format($row['total_order_value'], 2);

}

function count_total_credit_order_value($connect)

{

$query = "

SELECT sum(inventory_order_total) as total_order_value FROM inventory_order WHERE payment_status = 'credit' AND inventory_order_status='active'

if($_SESSION['type'] == 'user')

{

$query .= ' AND user_id = "'.$_SESSION["user_id"].'"';

}

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

foreach($result as $row)

{

return number_format($row['total_order_value'], 2);

}

function get_user_wise_total_order($connect)

{

$query = '

SELECT sum(inventory_order.inventory_order_total) as order_total,

SUM(CASE WHEN inventory_order.payment_status = "cash" THEN inventory_order.inventory_order_total ELSE 0 END) AS cash_order_total,

SUM(CASE WHEN inventory_order.payment_status = "credit" THEN inventory_order.inventory_order_total ELSE 0 END) AS credit_order_total,

user_details.user_name

FROM inventory_order

INNER JOIN user_details ON user_details.user_id = inventory_order.user_id

WHERE inventory_order.inventory_order_status = "active" GROUP BY inventory_order.user_id

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$output = '

<tr>

<th>Total Order Value</th>

<th>Total Cash Order</th>

<th>Total Credit Order</th>

</tr>

$total_order = 0;

$total_cash_order = 0;

$total_credit_order = 0;

foreach($result as $row)

{

$output .= '

<tr>

<td align="right">$ '.$row["order_total"].'</td>

<td align="right">$ '.$row["cash_order_total"].'</td>

<td align="right">$ '.$row["credit_order_total"].'</td>

</tr>

$total_order = $total_order + $row["order_total"];

$total_cash_order = $total_cash_order + $row["cash_order_total"];

$total_credit_order = $total_credit_order + $row["credit_order_total"];

}

$output .= '

<tr>

<td align="right"><b>Total</b></td>

<td align="right"><b>$ '.$total_order.'</b></td>

<td align="right"><b>$ '.$total_cash_order.'</b></td>

<td align="right"><b>$ '.$total_credit_order.'</b></td>

</tr></table></div>

return $output;

}

pdf.php

<?php

//pdf.php;

require_once 'dompdf/autoload.inc.php';

use Dompdf\Dompdf;

class Pdf extends Dompdf{

public function __construct() {

parent::__construct();

}

view_order.php

<?php

//view_order.php

if(isset($_GET["pdf"]) && isset($_GET['order_id']))

{

require_once 'pdf.php';

include('database_connection.php');

include('function.php');

if(!isset($_SESSION['type']))

{

header('location:login.php');

}

$output = '';

$statement = $connect->prepare("

SELECT * FROM inventory_order

WHERE inventory_order_id = :inventory_order_id

LIMIT 1

");

$statement->execute(

array(

':inventory_order_id' => $_GET["order_id"]

)

);

$result = $statement->fetchAll();

foreach($result as $row)

{

$output .= '

<tr>

<td colspan="2" align="center" style="font-size:18px"><b>Invoice</b></td>

</tr>

<tr>

<tr>

To,<br />

<b>RECEIVER (BILL TO)</b><br />

Name : '.$row["inventory_order_name"].'<br />

Billing Address : '.$row["inventory_order_address"].'<br />

</td>

Reverse Charge<br />

Invoice No. : '.$row["inventory_order_id"].'<br />

Invoice Date : '.$row["inventory_order_date"].'<br />

</td>

</tr>

</table>

<br />

<tr>

<th rowspan="2">Product</th>

<th rowspan="2">Quantity</th>

<th rowspan="2">Price</th>

<th rowspan="2">Actual Amt.</th>

<th rowspan="2">Total</th>

</tr>

<tr>

</tr>

$statement = $connect->prepare("

SELECT * FROM inventory_order_product

WHERE inventory_order_id = :inventory_order_id

");

$statement->execute(

array(

':inventory_order_id' => $_GET["order_id"]

)

);

$product_result = $statement->fetchAll();

$count = 0;

$total = 0;

$total_actual_amount = 0;

$total_tax_amount = 0;

foreach($product_result as $sub_row)

{

$count = $count + 1;

$product_data = fetch_product_details($sub_row['product_id'], $connect);

$actual_amount = $sub_row["quantity"] * $sub_row["price"];

$tax_amount = ($actual_amount * $sub_row["tax"])/100;

$total_product_amount = $actual_amount + $tax_amount;

$total_actual_amount = $total_actual_amount + $actual_amount;

$total_tax_amount = $total_tax_amount + $tax_amount;

$total = $total + $total_product_amount;

$output .= '

<tr>

<td>'.$count.'</td>

<td>'.$product_data['product_name'].'</td>

<td>'.$sub_row["quantity"].'</td>

<td aling="right">'.$sub_row["price"].'</td>

<td align="right">'.number_format($actual_amount, 2).'</td>

<td align="right">'.number_format($tax_amount, 2).'</td>

<td align="right">'.number_format($total_product_amount, 2).'</td>

</tr>

}

$output .= '

<tr>

<td align="right" colspan="4"><b>Total</b></td>

<td align="right"><b>'.number_format($total_actual_amount, 2).'</b></td>

<td align="right"><b>'.number_format($total_tax_amount, 2).'</b></td>

<td align="right"><b>'.number_format($total, 2).'</b></td>

</tr>

$output .= '

</table>

<br />

<p align="right">----------------------------------------<br />Receiver Signature</p>

<br />

</td>

</tr>

</table>

}

$pdf = new Pdf();

$file_name = 'Order-'.$row["inventory_order_id"].'.pdf';

$pdf->loadHtml($output);

$pdf->render();

$pdf->stream($file_name, array("Attachment" => false));

}

Database_Script

-- Database: `testing2`

-- --------------------------------------------------------

-- Table structure for table `brand`

CREATE TABLE IF NOT EXISTS `brand` (

`brand_id` int(11) NOT NULL,

`category_id` int(11) NOT NULL,

`brand_name` varchar(250) NOT NULL,

`brand_status` enum('active','inactive') NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

-- Dumping data for table `brand`

INSERT INTO `brand` (`brand_id`, `category_id`, `brand_name`, `brand_status`) VALUES

(1, 1, 'Finibus', 'active'),

(2, 1, 'Lorem', 'active'),

(3, 1, 'Ipsum', 'active'),

(4, 8, 'Dolor', 'active'),

(5, 8, 'Amet', 'active'),

(6, 6, 'Aliquam', 'active'),

(7, 6, 'Maximus', 'active'),

(8, 10, 'Venenatis', 'active'),

(9, 10, 'Ligula', 'active'),

(10, 3, 'Vitae', 'active'),

(11, 3, 'Auctor', 'active'),

(12, 5, 'Luctus', 'active'),

(13, 5, 'Justo', 'active'),

(14, 2, 'Phasellus', 'active'),

(15, 2, 'Viverra', 'active'),

(16, 4, 'Elementum', 'active'),

(17, 4, 'Odio', 'active'),

(18, 7, 'Tellus', 'active'),

(19, 7, 'Curabitur', 'active'),

(20, 9, 'Commodo', 'active'),

(21, 9, 'Nullam', 'active'),

(22, 11, 'Quisques', 'active');

-- --------------------------------------------------------

-- Table structure for table `category`

CREATE TABLE IF NOT EXISTS `category` (

`category_id` int(11) NOT NULL,

`category_name` varchar(250) NOT NULL,

`category_status` enum('active','inactive') NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

-- Dumping data for table `category`

INSERT INTO `category` (`category_id`, `category_name`, `category_status`) VALUES

(1, 'LED Bulb', 'active'),

(2, 'LED Lights', 'active'),

(3, 'LED Down Lights', 'active'),

(4, 'LED Panel Light', 'active'),

(5, 'LED Lamp', 'active'),

(6, 'LED Concealed Light', 'active'),

(7, 'LED Spot Light', 'active'),

(8, 'LED Ceiling Light', 'active'),

(9, 'LED Tube Light', 'active'),

(10, 'LED Driver', 'active'),

(11, 'Led Floods Light', 'active');

-- --------------------------------------------------------

-- Table structure for table `inventory_order`

CREATE TABLE IF NOT EXISTS `inventory_order` (

`inventory_order_id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

`inventory_order_total` double(10,2) NOT NULL,

`inventory_order_date` date NOT NULL,

`inventory_order_name` varchar(255) NOT NULL,

`inventory_order_address` text NOT NULL,

`payment_status` enum('cash','credit') NOT NULL,

`inventory_order_status` varchar(100) NOT NULL,

`inventory_order_created_date` date NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

-- Dumping data for table `inventory_order`

INSERT INTO `inventory_order` (`inventory_order_id`, `user_id`, `inventory_order_total`, `inventory_order_date`, `inventory_order_name`, `inventory_order_address`, `payment_status`, `inventory_order_status`, `inventory_order_created_date`) VALUES

(1, 7, 4939.20, '2017-11-08', 'David Harper', '3188 Straford Park\r\nHarold, KY 41635', 'credit', 'active', '2017-11-08'),

(2, 7, 1310.40, '2017-11-08', 'Trevor Webster', '4275 Indiana Avenue\r\nHonolulu, HI 96816', 'cash', 'active', '2017-11-08'),

(3, 6, 265.65, '2017-11-08', 'Russell Barrett', '4687 Powder House Road\r\nJupiter, FL 33478', 'cash', 'active', '2017-11-08'),

(4, 6, 1546.80, '2017-11-08', 'Doloris Turner', '3057 Collins Avenue\r\nWesterville, OH 43081', 'credit', 'active', '2017-11-08'),

(5, 5, 1409.00, '2017-11-08', 'Georgette Blevins', '863 Simpson Avenue\r\nSteelton, PA 17113', 'cash', 'active', '2017-11-08'),

(6, 5, 558.90, '2017-11-08', 'Nancy Brook', '3460 Viking Drive\r\nBarnesville, OH 43713', 'credit', 'active', '2017-11-08'),

(7, 4, 1286.25, '2017-11-08', 'Joseph Smith', '190 Metz Lane\r\nCharlestown, MA 02129', 'cash', 'active', '2017-11-08'),

(8, 4, 1520.00, '2017-11-08', 'Maria Lafleur', '3878 Elkview Drive\r\nPort St Lucie, FL 33452', 'credit', 'active', '2017-11-08'),

(9, 4, 1604.00, '2017-11-08', 'David Smith', '4757 Little Acres Lane\r\nLoraine, IL 62349', 'cash', 'active', '2017-11-08'),

(10, 3, 1724.80, '2017-11-08', 'Michelle Hayes', '1140 C Street\r\nWorcester, MA 01609', 'cash', 'active', '2017-11-08'),

(11, 3, 1859.40, '2017-11-08', 'Brenna Hamilton', '2845 Davis Avenue\r\nPetaluma, CA 94952', 'cash', 'active', '2017-11-08'),

(12, 3, 2038.40, '2017-11-08', 'Robbie McKenzie', '3016 Horizon Circle\r\nEatonville, WA 98328', 'credit', 'active', '2017-11-08'),

(13, 2, 573.00, '2017-11-08', 'Jonathan Allen', '2426 Evergreen Lane\r\nAlhambra, CA 91801', 'cash', 'active', '2017-11-08'),

(14, 2, 1196.35, '2017-11-08', 'Mildred Paige', '3167 Oakway Lane\r\nReseda, CA 91335', 'cash', 'active', '2017-11-08'),

(15, 2, 1960.00, '2017-11-08', 'Elva Lott', '4032 Aaron Smith Drive\r\nHarrisburg, PA 17111', 'credit', 'active', '2017-11-08'),

(16, 2, 2700.00, '2017-11-08', 'Eric Johnson', '616 Devils Hill Road\r\nJackson, MS 39213', 'cash', 'active', '2017-11-08'),

(17, 1, 5615.20, '2017-11-09', 'Doris Oliver', '2992 Sycamore Fork Road Hopkins, MN 55343', 'cash', 'active', '2017-11-09');

-- --------------------------------------------------------

-- Table structure for table `inventory_order_product`

CREATE TABLE IF NOT EXISTS `inventory_order_product` (

`inventory_order_product_id` int(11) NOT NULL,

`inventory_order_id` int(11) NOT NULL,

`product_id` int(11) NOT NULL,

`quantity` int(11) NOT NULL,

`price` double(10,2) NOT NULL,

`tax` double(10,2) NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

-- Dumping data for table `inventory_order_product`

INSERT INTO `inventory_order_product` (`inventory_order_product_id`, `inventory_order_id`, `product_id`, `quantity`, `price`, `tax`) VALUES

(3, 1, 1, 10, 141.00, 12.00),

(4, 1, 3, 4, 800.00, 5.00),

(5, 2, 2, 3, 350.00, 12.00),

(6, 2, 17, 2, 60.00, 12.00),

(7, 3, 15, 1, 125.00, 5.00),

(8, 3, 17, 2, 60.00, 12.00),

(12, 4, 18, 4, 90.00, 12.00),

(13, 4, 20, 3, 100.00, 18.00),

(14, 4, 1, 5, 141.00, 12.00),

(15, 5, 4, 2, 550.00, 12.00),

(16, 5, 10, 1, 150.00, 18.00),

(17, 6, 8, 5, 15.00, 18.00),

(18, 6, 7, 2, 210.00, 12.00),

(19, 7, 16, 7, 175.00, 5.00),

(23, 8, 19, 5, 120.00, 18.00),

(24, 8, 11, 5, 85.00, 12.00),

(25, 8, 12, 5, 60.00, 12.00),

(26, 9, 13, 3, 200.00, 18.00),

(27, 9, 9, 2, 400.00, 12.00),

(28, 10, 9, 3, 400.00, 12.00),

(29, 10, 11, 4, 85.00, 12.00),

(30, 11, 6, 6, 250.00, 15.00),

(31, 11, 12, 2, 60.00, 12.00),

(32, 12, 2, 4, 350.00, 12.00),

(33, 12, 7, 2, 210.00, 12.00),

(34, 13, 18, 3, 90.00, 12.00),

(35, 13, 7, 1, 210.00, 12.00),

(36, 13, 8, 2, 15.00, 18.00),

(37, 14, 6, 2, 250.00, 15.00),

(38, 14, 13, 1, 200.00, 18.00),

(39, 14, 16, 1, 175.00, 5.00),

(40, 14, 17, 3, 60.00, 12.00),

(41, 15, 2, 5, 350.00, 12.00),

(42, 16, 4, 4, 550.00, 12.00),

(43, 16, 13, 1, 200.00, 18.00),

(46, 17, 21, 2, 500.00, 18.00),

(47, 17, 3, 5, 800.00, 5.00),

(48, 17, 7, 1, 210.00, 12.00);

-- --------------------------------------------------------

-- Table structure for table `product`

CREATE TABLE IF NOT EXISTS `product` (

`product_id` int(11) NOT NULL,

`category_id` int(11) NOT NULL,

`brand_id` int(11) NOT NULL,

`product_name` varchar(300) NOT NULL,

`product_description` text NOT NULL,

`product_quantity` int(11) NOT NULL,

`product_unit` varchar(150) NOT NULL,

`product_base_price` double(10,2) NOT NULL,

`product_tax` decimal(4,2) NOT NULL,

`product_minimum_order` double(10,2) NOT NULL,

`product_enter_by` int(11) NOT NULL,

`product_status` enum('active','inactive') NOT NULL,

`product_date` date NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

-- Dumping data for table `product`

INSERT INTO `product` (`product_id`, `category_id`, `brand_id`, `product_name`, `product_description`, `product_quantity`, `product_unit`, `product_base_price`, `product_tax`, `product_minimum_order`, `product_enter_by`, `product_status`, `product_date`) VALUES

(1, 1, 1, '4W LED Bulb', 'Base Type B22, E27\r\nBulb Material Aluminium\r\nItem Width 5 (cm)\r\nItem Height 10 (cm)\r\nItem Weight 0.07 (kg)', 100, 'Nos', 141.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(2, 1, 3, '17W B22 LED Bulb', 'Item Height 14.2 (cm)\r\nColor Temperature (Kelvin) 6500\r\nItem Weight 0.19 (kg)\r\nBulb Material Aluminium\r\nBase Color Aluminium\r\nVoltage 240\r\nUsages Household, Commercial, Kitchen', 150, 'Nos', 350.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(3, 8, 5, '18W LED Ceiling Light', 'Round Ceiling Light 18w', 75, 'Nos', 800.00, '5.00', 0.00, 1, 'active', '2017-11-08'),

(4, 8, 4, 'Round LED Ceiling Light', 'Relying on our expertise in this domain, we are into offering Round LED Ceiling Light. ', 50, 'Nos', 550.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(5, 6, 6, '7W LED Concealed Light', 'Dimension ''3" ''\r\n50000 hours burning life\r\ncost effective\r\nhigh quality led', 85, 'Nos', 240.00, '15.00', 0.00, 1, 'active', '2017-11-08'),

(6, 6, 7, '9w LED Concealed Light', 'dimension ''3" ''\r\n50000 hours burning life\r\ncost effective\r\nhigh quality led', 65, 'Nos', 250.00, '15.00', 0.00, 1, 'active', '2017-11-08'),

(7, 10, 9, '24W Street Light Led Driver', 'Dc Voltage 36v\r\nRated Current 600ma\r\nRated Power 22w', 120, 'Nos', 210.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(8, 10, 8, 'BP1601 ICs', 'Backed by immense industry-experience & latest designing techniques, we are engaged in providing BP1601 ICs.', 200, 'Nos', 15.00, '18.00', 0.00, 1, 'active', '2017-11-08'),

(9, 3, 11, '5W LED Square Downlight', 'Wattage: 5 Watt\r\nInput Voltage: 150V to 265V, 50/60Hz\r\nLumens: 500 lumen (approx)\r\nPower Factor: 0.90pf', 50, 'Nos', 400.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(10, 3, 10, '10W LED Square Downlight', 'Wattage: 10 Watt\r\nInput Voltage: 150V to 265V, 50/60Hz\r\nLumens: 1000 lumen (approx)\r\nPower Factor: 0.90pf', 40, 'Nos', 150.00, '18.00', 0.00, 1, 'active', '2017-11-08'),

(11, 5, 13, ' 9w Deluxe LED Lamp', 'Lighting Color Cool Daylight\r\nBase Type B22', 100, 'Nos', 85.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(12, 5, 12, '5w LED Lamp', 'Lighting Color Cool Daylight\r\nBody Material Aluminum\r\nBase Type B22', 75, 'Nos', 60.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(13, 2, 14, '15W Big LED Bay Light', 'Wattage: 15 Watt\r\nInput Voltage: 100V - 265V, 50/60Hz\r\nLumens: 1500 lumen (approx)\r\nPower Factor: 0.90pf', 60, 'Nos', 200.00, '18.00', 0.00, 1, 'active', '2017-11-08'),

(14, 2, 15, '15W Small LED Bay Light', 'Wattage: 15 Watt\r\nInput Voltage: 100V -265V, 50/60Hz\r\nLumens: 1500 lumen (approx)\r\nPower Factor: 0.90pf', 55, 'Nos', 250.00, '18.00', 0.00, 1, 'active', '2017-11-08'),

(15, 4, 16, '12W LED Panel Light', 'Body Material Aluminum\r\nLighting Type LED\r\nApplications Hotel, House, etc', 85, 'Nos', 125.00, '5.00', 0.00, 1, 'active', '2017-11-08'),

(16, 4, 17, '15W LED Panel Light', 'IP Rating IP40\r\nBody Material Aluminum\r\nLighting Type LED', 40, 'Nos', 175.00, '5.00', 0.00, 1, 'active', '2017-11-08'),

(17, 7, 19, '3W Round LED Spotlight', 'Lighting Color Cool White\r\nBody Material Aluminum\r\nCertification ISO\r\nInput Voltage(V) 12 V\r\nIP Rating IP33, IP40, IP44', 100, 'Nos', 60.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(18, 7, 18, '3W Square LED Spotlight', 'Lighting Color Cool White\r\nBody Material Aluminum\r\nInput Voltage(V) 12 V\r\nIP Rating IP33, IP40', 85, 'Nos', 90.00, '12.00', 0.00, 1, 'active', '2017-11-08'),

(19, 9, 20, '18W LED Tube Light', 'Tube Base Type T5\r\nIP Rating IP66', 180, 'Nos', 120.00, '18.00', 0.00, 1, 'active', '2017-11-08'),

(20, 9, 21, '10W Ready Tube Light', 'Body Material Aluminum, Ceramic\r\nPower 10W', 200, 'Nos', 100.00, '18.00', 0.00, 1, 'active', '2017-11-08'),

(21, 11, 22, '90W LED Flood Lights', 'Lighting Color Cool White, Pure White, Warm White\r\nBody Material Ceramic, Chrome, Iron\r\nIP Rating IP33, IP40, IP44, IP55, IP66', 20, 'Nos', 500.00, '18.00', 0.00, 1, 'active', '2017-11-09');

-- --------------------------------------------------------

-- Table structure for table `user_details`

CREATE TABLE IF NOT EXISTS `user_details` (

`user_id` int(11) NOT NULL,

`user_email` varchar(200) NOT NULL,

`user_password` varchar(200) NOT NULL,

`user_name` varchar(200) NOT NULL,

`user_type` enum('master','user') NOT NULL,

`user_status` enum('Active','Inactive') NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- Dumping data for table `user_details`

INSERT INTO `user_details` (`user_id`, `user_email`, `user_password`, `user_name`, `user_type`, `user_status`) VALUES

(1, 'john_smith@gmail.com', '$2y$10$0Yo2F.EetL3yhB8l6MNvcOH8AYNS0SuXLOoAQr1qXJa3uPASWV0NC', 'John Smith', 'master', 'Active'),

(2, 'dona_huber@gmail.com', '$2y$10$Zk647HzbZEngXbyf7dd2MurHoKEa3IX8yyuHWsBFXDKBmDiZ/oO5y', 'Dona L. Huber', 'user', 'Active'),

(3, 'roy_hise@gmail.com', '$2y$10$XlyVI9an5B6rHW3SS9vQpesJssKJxzMQYPbSaR7dnpWjDI5fpxJSS', 'Roy Hise', 'user', 'Active'),

(4, 'peter_goad@gmail.com', '$2y$10$n1B.FdHNwufTkmzp/pNqc.EiwjB8quQ1tBCEC7nkaldI5pS.et04e', 'Peter Goad', 'user', 'Active'),

(5, 'sarah_thomas@gmail.com', '$2y$10$s57SErOPlgkIZf1lxzlX3.hMt8LSSKaYig5rusxghDm7LW8RtQc/W', 'Sarah Thomas', 'user', 'Active'),

(6, 'edna_william@gmail.com', '$2y$10$mfMXnH.TCmg5tlYRhqjxu.ILly8s9.qsLKOpyxgUl6h1fZt6x/B5C', 'Edna William', 'user', 'Active'),

(7, 'peter_parker@gmail.com', '$2y$10$zWzlyMit4MDbicnkRbcXoeszP20RHv/PZBUN4ETFXYiXdncZPgI4u', 'Peter Lee', 'user', 'Active'),

(8, 'john_parks@gmail.com', '$2y$10$WtsZUxIIz/N4NoIW0Db.pu0VfLWcPs6TyQ8SkpVHLDLGhdNOfALC.', 'John Park', 'user', 'Active');

-- Indexes for dumped tables

-- Indexes for table `brand`

ALTER TABLE `brand`

ADD PRIMARY KEY (`brand_id`);

-- Indexes for table `category`

ALTER TABLE `category`

ADD PRIMARY KEY (`category_id`);

-- Indexes for table `inventory_order`

ALTER TABLE `inventory_order`

ADD PRIMARY KEY (`inventory_order_id`);

-- Indexes for table `inventory_order_product`

ALTER TABLE `inventory_order_product`

ADD PRIMARY KEY (`inventory_order_product_id`);

-- Indexes for table `product`

ALTER TABLE `product`

ADD PRIMARY KEY (`product_id`);

-- Indexes for table `user_details`

ALTER TABLE `user_details`

ADD PRIMARY KEY (`user_id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `brand`

ALTER TABLE `brand`

MODIFY `brand_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;

-- AUTO_INCREMENT for table `category`

ALTER TABLE `category`

MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;

-- AUTO_INCREMENT for table `inventory_order`

ALTER TABLE `inventory_order`

MODIFY `inventory_order_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;

-- AUTO_INCREMENT for table `inventory_order_product`

ALTER TABLE `inventory_order_product`

MODIFY `inventory_order_product_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=49;

-- AUTO_INCREMENT for table `product`

ALTER TABLE `product`

MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;

-- AUTO_INCREMENT for table `user_details`

ALTER TABLE `user_details`

MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;

Search This Blog

Source Code Inventory Management System using PHP Native 7.0 jQuery Ajax Bootstrap

Ditulis pada: Juli 10, 2018

Features

Adsense Right Sidebar

Yang Paling Banyak Dibaca

Pilihan Editor

Kategori

Search This Blog

Source Code Inventory Management System using PHP Native 7.0 jQuery Ajax Bootstrap

Ditulis pada: Juli 10, 2018

Features

You Might Also Like:

Adsense Right Sidebar

Yang Paling Banyak Dibaca

Pilihan Editor

Kategori