IOT Implementation



OrientDB Intallation

  1. Download Source OrientDB


  1.  Exstract That folder and go to folder bin/server.bat click server.bat

Tichnique Advance Search

– We should create procedure in database(Table Function that result as the table)
Example in SQL Server

/****** Object: UserDefinedFunction [dbo].[TBL_Web_Search] Script Date: 5/19/2017 3:20:07 PM ******/
ALTER FUNCTION [dbo].[TBL_Web_Search]()
RETURNS @temptable TABLE (ID int NOT NULL,
BrandID int NOT NULL,
DepartmentID int NOT NULL,
CategoryID int NOT NULL,
Name nvarchar(max) NOT NULL,
PictureName nvarchar(max) NOT NULL,
WebsiteShow int NOT NULL,
WebsitePrice money NOT NULL,
Price money NOT NULL,
PriceA money NOT NULL,
PriceB money NOT NULL,
PriceC money NOT NULL,
PriceID money NOT NULL,
Quantity money NOT NULL,
QuantityDiscount int NOT NULL,
QuantityDiscountExpired date NOT NULL,
Active int NOT NULL,
LastUpdated date NOT NULL,
[Key] text NOT NULL )

INSERT INTO @temptable(ID, BrandID, DepartmentID, CategoryID,Name, PictureName, WebsiteShow, WebsitePrice , Price, PriceA, PriceB, PriceC, PriceID, Quantity, QuantityDiscount, QuantityDiscountExpired, Active, LastUpdated, [Key])
SELECT i.ID, i.BrandID, c.DepartmentID, i.CategoryID, i.Name, i.PictureName, i.WebsiteShow, i.WebsitePrice, i.Price, i.PriceA, i.PriceB, i.PriceC, i.PriceID, i.Quantity, i.QuantityDiscount, i.QuantityDiscountExpired, i.Active, i.LastUpdated,

b.BrandName + ‘ ‘ + d.Name + ‘ ‘ + c.Name + ‘ ‘ + i.Name + ‘ ‘ + i.Notes

FROM Item as i
JOIN Category as c on i.CategoryID = c.ID
JOIN Department as d on c.DepartmentID = d.ID
JOIN Brand as b on i.BrandID = b.ID
WHERE i.Active = 1
AND c.ActiveInWeb = 1 AND d.ActiveInWeb = 1




What is HTML Local Storage?

With local storage, web applications can store data locally within the user’s browser.

Before HTML5, application data had to be stored in cookies, included in every server request. Local storage is more secure, and large amounts of data can be stored locally, without affecting website performance.

Unlike cookies, the storage limit is far larger (at least 5MB) and information is never transferred to the server.

Local storage is per origin (per domain and protocol). All pages, from one origin, can store and access the same data.

Browser Support

The numbers in the table specify the first browser version that fully supports Local Storage.

Configure FileZilla FTP Server on XAMPP

If you included FileZilla FTP Server on your XAMPP installation then this how you can configure your FTP server along side with XAMPP. For now on this tutorial we will setup FileZilla FTP Server on a basic level like setting up users and groups, folder permissions and server settings.

Open XAMPP interface then enable FileZilla by clicking Start.

Once FileZilla is running click Admin to start FileZilla admin interface.

Open FileZilla FTP Server by default it doesn’t have any password or leave the password blank and we will setup the password later as we continue, in regards with server address you may set the address to localhost, or your computer’s local IP Address, on my computer it’s


Click Edit then select Settings.

On General settings leave the default settings unless you you want to change it.

On Welcome message which is optional you may put a welcome message, basically this welcome message will show up when users log in to FileZilla FTP Server. Welcome message only works if user access it thru windows default ftp command by command prompt and if user use a ftp client program, if someone access it using a web browser no welcome message will show up.

On Miscellaneous I enable Start minimized, it means that every time FileZilla FTP Sever starts will automatically go to system tray.

On Admin interface settings you may change the port to access your FileZilla admin interface, underneath you may change the password as well, make sure that when you set the password it should have a good key combinations however easy to remember, as admin you don’t access your server everyday so if you forgot your password you have to reinstall and configure it from scratch.

On Logging settings you should enable it to know the activity of your FTP server, the settings are very straight forward, I’ve enabled limit the log file to 100kb which means that If it reaches 100kb it split the logs and make another one as it continue to log – log file with a very large size can cause your server to freeze so to avoid it splitting the file is recommend especially if you have a high usage FTP server. in addition to that you may enable logging a log file on a daily bases as well.

Basically Autoban will ban users after a number of failed attempts to access the FTP server and won’t be able to access the server on the number of hours assigned by the admin.

SweetAlert for Bootstrap

Try any of those!

Primary Info Success Warning Danger

Install via Bower

$ bower install bootstrap-sweetalert

Continue playing with the examples or check how to use it on GitHub.

Original Examples

Basic example

Try It

swal("Here's a message!")

A title with a text under

Try It

swal("Here's a message!", "It's pretty, isn't it?")

A success message!

Try It

swal("Good job!", "You clicked the button!", "success")

A warning message, with a function attached to the “Confirm” button…

Try It

  title: "Are you sure?",
  text: "Your will not be able to recover this imaginary file!",
  type: "warning",
  showCancelButton: true,
  confirmButtonClass: "btn-danger",
  confirmButtonText: "Yes, delete it!",
  closeOnConfirm: false
  swal("Deleted!", "Your imaginary file has been deleted.", "success");

…and by passing a parameter, you can execute something else for “Cancel”.

Try It

  title: "Are you sure?",
  text: "You will not be able to recover this imaginary file!",
  type: "warning",
  showCancelButton: true,
  confirmButtonClass: "btn-danger",
  confirmButtonText: "Yes, delete it!",
  cancelButtonText: "No, cancel plx!",
  closeOnConfirm: false,
  closeOnCancel: false
function(isConfirm) {
  if (isConfirm) {
    swal("Deleted!", "Your imaginary file has been deleted.", "success");
  } else {
    swal("Cancelled", "Your imaginary file is safe :)", "error");

A message with a custom icon

Try It

  title: "Sweet!",
  text: "Here's a custom image.",
  imageUrl: 'thumbs-up.jpg'

A replacement for the “prompt” function

Try It

  title: "An input!",
  text: "Write something interesting:",
  type: "input",
  showCancelButton: true,
  closeOnConfirm: false,
  inputPlaceholder: "Write something"
}, function (inputValue) {
  if (inputValue === false) return false;
  if (inputValue === "") {
    swal.showInputError("You need to write something!");
    return false
  swal("Nice!", "You wrote: " + inputValue, "success");

With a loader (for a AJAX requests)

Try It

  title: "Ajax request example",
  text: "Submit to run ajax request",
  type: "info",
  showCancelButton: true,
  closeOnConfirm: false,
  showLoaderOnConfirm: true
}, function () {
  setTimeout(function () {
    swal("Ajax request finished!");
  }, 2000);