-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 23, 2025 at 04:59 AM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `robipos`
--

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

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(10) NOT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `url` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'side',
  `menu` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`name`, `sort`, `icon`, `id`, `status`, `url`, `type`, `menu`) VALUES
('Accomodation', 84, 'money', 'accomodation', '1', 'admin/viewpallmyplots', 'side', 'accomodation'),
('Accounting(Charts of Accounts)', 35, 'battery-quarter', 'accounting', '1', 'user/allaccounting', 'side', 'banking'),
('Accounting Reports', 35, 'money', 'accountingreports', '1', 'user/startsales', 'side', 'banking'),
('Assets', 49, 'paw', 'assets', '1', 'user/viewassets', 'side', 'assetliability'),
('Bank Deposits', 35, 'money', 'bankdeposits', '1', 'user/viewbanks', 'side', 'banking'),
('Bank Transfer', 35, 'money', 'banktransfer', '1', 'user/viewbanktransfer', 'side', 'banking'),
('Biometric Records', 31, 'rss-square', 'biometricrecords', '1', 'user/allattendance', 'side', 'humanresource'),
('Branch', 81, 'rss-square', 'branch', '1', 'user/viewbranch', 'side', 'setting'),
('Call center', 12, 'rss-square', 'callcenter', '1', 'user/callcenter', 'side', 'contact'),
('Cashier Sales', 87, 'folder-open', 'cashiersales', '1', 'user/mysales', 'side', 'moneyin'),
('Cheque Management', 34, 'money', 'chequemanagemant', '1', 'user/viewcheque', 'side', 'banking'),
('Comments/Complains', 11, 'paw', 'complain', '1', 'user/complain', 'side', 'project'),
('Configuration', 5, 'home', 'config', '1', 'user/viewconfiguration', 'top', 'setting'),
('Counter Radio Button', 90, 'rss-square', 'counterradiobutton', '1', 'radio', 'side', 'setting'),
('Damaged products', 50, 'paw', 'damagedproducts', '1', 'user/viewdamages', 'side', 'assetliability'),
('Deals', 11, 'calendar-times-o', 'deals', '1', 'user/viedeals', 'side', 'project'),
('Departments', 31, 'rss-square', 'departments', '1', 'user/department', 'side', 'humanresource'),
('Display Counter', 6, 'rss-square', 'displaycounter', '0', 'display', 'side', 'goodservice'),
('Display Sales Report', 24, 'folder-open', 'displayreport', '1', 'user/displayreport', 'side', 'report'),
('Documents', 14, 'folder-open-o', 'documents', '1', 'user/viewdocuments', 'side', 'project'),
('E-Commerce', 8, 'grouping', 'ecommerce', '1', 'user/ecommerce', 'side', 'moneyin'),
('Events', 10, 'line-chart', 'events', '1', 'user/viewevents', 'side', 'project'),
('Grouping Members', 20, 'paper-plane', 'grouping', '1', 'user/viewgrouping', 'side', 'contact'),
('Human Resource', 14, 'rss-square', 'humanresource', '1', 'user/viewrequest', 'side', 'humanresource'),
('Income', 85, 'window-close', 'income', '1', 'user/allinvoices', 'side', 'moneyin'),
('Expenses', 85, 'window-close', 'incomeexpenses', '1', 'user/viewexpenses', 'side', 'moneyout'),
('Dispatched stocklist/Store', 60, 'sort-amount-asc', 'incomingstock', '1', 'user/viewincomingstock', 'side', 'goodservice'),
('Issued Store Items', 59, 'sort-amount-asc', 'incomingstore', '1', 'user/viewallorder', 'side', 'goodservice'),
('journal entry', 35, 'money', 'journalentry', '1', 'user/viewjournalentry', 'side', 'banking'),
('Labour Records', 31, 'rss-square', 'labourrecords', '1', 'user/viewlabour', 'side', 'humanresource'),
('Leave Management', 31, 'rss-square', 'leavemanagement', '1', 'user/viewleaves', 'side', 'humanresource'),
('Low Store', 55, 'battery-quarter', 'lowproducts', '1', 'user/viewwarningproducts', 'side', 'goodservice'),
('Low stocklist', 57, 'battery-quarter', 'lowstocklist', '1', 'user/viewlowstore', 'side', 'goodservice'),
('Loyality Cards', 30, 'credit-card', 'loyalitycards', '1', 'user/viewloyality', 'side', 'project'),
('People/Contacts', 80, 'rss-square', 'members', '1', 'user/viewmember', 'side', 'contact'),
('Open and Close Sales', 87, 'money', 'openclose', '0', 'user/openclose', 'side', 'moneyin'),
('Change password', 9, 'hourglass-start', 'password', '1', 'user/passwordform', 'side', 'setting'),
('Payroll', 30, 'rss-square', 'payroll', '1', 'user/salaryhistory', 'side', 'humanresource'),
('Payroll Setup', 31, 'rss-square', 'payrollsetup', '1', 'user/payrollsetup', 'side', 'humanresource'),
('Category of people', 33, 'address-book-o', 'peoplecategory', '1', 'user/viewcategory', 'side', 'contact'),
('Print Receipt', 1, 'recycle', 'printreceipt', '1', 'user/printreceipts', 'side', 'goodservice'),
('Stock List(Counter)', 66, 'snowflake-o', 'productlist', '1', 'user/viewproductlist', 'side', 'goodservice'),
('Products(Main store)', 65, 'snowflake-o', 'products', '1', 'user/viewproducts', 'side', 'goodservice'),
('Category of Products', 70, 'recycle', 'productscategory', '1', 'user/viewproductcategory', 'side', 'goodservice'),
('Update profile', 8, 'blind', 'profile', '1', 'user/profileform', 'side', 'setting'),
('Projects Management', 50, 'bullseye', 'projectsmanagement', '1', 'user/viewprojets', 'side', 'project'),
('Purchases', 86, 'automobile', 'purchases', '1', 'user/viewpurchases', 'side', 'moneyout'),
('Quotation', 8, 'money', 'quotation', '1', 'user/allquatation', 'side', 'moneyin'),
('Record Delivery', 87, 'cart-plus', 'recorddelivery', '1', 'user/deliveryhome', 'side', 'moneyin'),
('Manage Report', 25, 'folder-open', 'reports', '1', 'user/startsales', 'side', 'report'),
('Retail sales', 90, 'cart-plus', 'sales', '1', 'user/viewsales', 'side', 'moneyin'),
('Sales Order', 86, 'money', 'salesorder', '1', 'user/salesorder', 'side', 'moneyin'),
('Select User', 1, 'rss-square', 'selectuser', '0', 'login', 'side', 'contact'),
('Send Sms', 15, 'paper-plane', 'sendsms', '1', 'user/viewsms', 'side', 'project'),
('Tasks', 12, 'bullseye', 'task', '1', 'user/viewtasks', 'side', 'project'),
('Tasks Category', 13, 'birthday-cake', 'taskscategory', '1', 'user/viewtaskcategory', 'side', 'project'),
('Users', 75, 'rss-square', 'users', '1', 'user/viewemployee', 'side', 'contact'),
('Return/RePrint Sales', 86, 'paw', 'viewreturnsales', '1', 'user/viewreturnsales', 'side', 'moneyout'),
('Whole sale', 88, 'cart-plus', 'wholesale', '1', 'user/viewwholesales', 'side', 'moneyin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `modules`
--
ALTER TABLE `modules`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name_lang_key` (`name`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
