-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: May 06, 2017 at 07:56 AM
-- Server version: 5.6.33-log
-- PHP Version: 5.4.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `multiinv_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `ci_sessions`
--
CREATE TABLE IF NOT EXISTS `ci_sessions` (
`session_id` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '0',
`ip_address` varchar(45) CHARACTER SET latin1 NOT NULL DEFAULT '0',
`user_agent` varchar(120) CHARACTER SET latin1 NOT NULL,
`last_activity` int(10) unsigned NOT NULL DEFAULT '0',
`user_data` text NOT NULL,
PRIMARY KEY (`session_id`),
KEY `last_activity_idx` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ci_sessions`
--
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('dad2d57cd2e9f80e3f7c586f6d34677d', '103.20.89.213', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0', 1494082469, 'a:1:{s:9:"user_data";s:0:"";}');
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE IF NOT EXISTS `countries` (
`idCountry` int(5) NOT NULL AUTO_INCREMENT,
`countryCode` char(2) NOT NULL DEFAULT '',
`countryName` varchar(45) NOT NULL DEFAULT '',
PRIMARY KEY (`idCountry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=251 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`idCountry`, `countryCode`, `countryName`) VALUES
(1, 'AD', 'Andorra'),
(2, 'AE', 'United Arab Emirates'),
(3, 'AF', 'Afghanistan'),
(4, 'AG', 'Antigua and Barbuda'),
(5, 'AI', 'Anguilla'),
(6, 'AL', 'Albania'),
(7, 'AM', 'Armenia'),
(8, 'AO', 'Angola'),
(9, 'AQ', 'Antarctica'),
(10, 'AR', 'Argentina'),
(11, 'AS', 'American Samoa'),
(12, 'AT', 'Austria'),
(13, 'AU', 'Australia'),
(14, 'AW', 'Aruba'),
(15, 'AX', 'Åland'),
(16, 'AZ', 'Azerbaijan'),
(17, 'BA', 'Bosnia and Herzegovina'),
(18, 'BB', 'Barbados'),
(19, 'BD', 'Bangladesh'),
(20, 'BE', 'Belgium'),
(21, 'BF', 'Burkina Faso'),
(22, 'BG', 'Bulgaria'),
(23, 'BH', 'Bahrain'),
(24, 'BI', 'Burundi'),
(25, 'BJ', 'Benin'),
(26, 'BL', 'Saint Barthélemy'),
(27, 'BM', 'Bermuda'),
(28, 'BN', 'Brunei'),
(29, 'BO', 'Bolivia'),
(30, 'BQ', 'Bonaire'),
(31, 'BR', 'Brazil'),
(32, 'BS', 'Bahamas'),
(33, 'BT', 'Bhutan'),
(34, 'BV', 'Bouvet Island'),
(35, 'BW', 'Botswana'),
(36, 'BY', 'Belarus'),
(37, 'BZ', 'Belize'),
(38, 'CA', 'Canada'),
(39, 'CC', 'Cocos [Keeling] Islands'),
(40, 'CD', 'Democratic Republic of the Congo'),
(41, 'CF', 'Central African Republic'),
(42, 'CG', 'Republic of the Congo'),
(43, 'CH', 'Switzerland'),
(44, 'CI', 'Ivory Coast'),
(45, 'CK', 'Cook Islands'),
(46, 'CL', 'Chile'),
(47, 'CM', 'Cameroon'),
(48, 'CN', 'China'),
(49, 'CO', 'Colombia'),
(50, 'CR', 'Costa Rica'),
(51, 'CU', 'Cuba'),
(52, 'CV', 'Cape Verde'),
(53, 'CW', 'Curacao'),
(54, 'CX', 'Christmas Island'),
(55, 'CY', 'Cyprus'),
(56, 'CZ', 'Czech Republic'),
(57, 'DE', 'Germany'),
(58, 'DJ', 'Djibouti'),
(59, 'DK', 'Denmark'),
(60, 'DM', 'Dominica'),
(61, 'DO', 'Dominican Republic'),
(62, 'DZ', 'Algeria'),
(63, 'EC', 'Ecuador'),
(64, 'EE', 'Estonia'),
(65, 'EG', 'Egypt'),
(66, 'EH', 'Western Sahara'),
(67, 'ER', 'Eritrea'),
(68, 'ES', 'Spain'),
(69, 'ET', 'Ethiopia'),
(70, 'FI', 'Finland'),
(71, 'FJ', 'Fiji'),
(72, 'FK', 'Falkland Islands'),
(73, 'FM', 'Micronesia'),
(74, 'FO', 'Faroe Islands'),
(75, 'FR', 'France'),
(76, 'GA', 'Gabon'),
(77, 'GB', 'United Kingdom'),
(78, 'GD', 'Grenada'),
(79, 'GE', 'Georgia'),
(80, 'GF', 'French Guiana'),
(81, 'GG', 'Guernsey'),
(82, 'GH', 'Ghana'),
(83, 'GI', 'Gibraltar'),
(84, 'GL', 'Greenland'),
(85, 'GM', 'Gambia'),
(86, 'GN', 'Guinea'),
(87, 'GP', 'Guadeloupe'),
(88, 'GQ', 'Equatorial Guinea'),
(89, 'GR', 'Greece'),
(90, 'GS', 'South Georgia and the South Sandwich Islands'),
(91, 'GT', 'Guatemala'),
(92, 'GU', 'Guam'),
(93, 'GW', 'Guinea-Bissau'),
(94, 'GY', 'Guyana'),
(95, 'HK', 'Hong Kong'),
(96, 'HM', 'Heard Island and McDonald Islands'),
(97, 'HN', 'Honduras'),
(98, 'HR', 'Croatia'),
(99, 'HT', 'Haiti'),
(100, 'HU', 'Hungary'),
(101, 'ID', 'Indonesia'),
(102, 'IE', 'Ireland'),
(103, 'IL', 'Israel'),
(104, 'IM', 'Isle of Man'),
(105, 'IN', 'India'),
(106, 'IO', 'British Indian Ocean Territory'),
(107, 'IQ', 'Iraq'),
(108, 'IR', 'Iran'),
(109, 'IS', 'Iceland'),
(110, 'IT', 'Italy'),
(111, 'JE', 'Jersey'),
(112, 'JM', 'Jamaica'),
(113, 'JO', 'Jordan'),
(114, 'JP', 'Japan'),
(115, 'KE', 'Kenya'),
(116, 'KG', 'Kyrgyzstan'),
(117, 'KH', 'Cambodia'),
(118, 'KI', 'Kiribati'),
(119, 'KM', 'Comoros'),
(120, 'KN', 'Saint Kitts and Nevis'),
(121, 'KP', 'North Korea'),
(122, 'KR', 'South Korea'),
(123, 'KW', 'Kuwait'),
(124, 'KY', 'Cayman Islands'),
(125, 'KZ', 'Kazakhstan'),
(126, 'LA', 'Laos'),
(127, 'LB', 'Lebanon'),
(128, 'LC', 'Saint Lucia'),
(129, 'LI', 'Liechtenstein'),
(130, 'LK', 'Sri Lanka'),
(131, 'LR', 'Liberia'),
(132, 'LS', 'Lesotho'),
(133, 'LT', 'Lithuania'),
(134, 'LU', 'Luxembourg'),
(135, 'LV', 'Latvia'),
(136, 'LY', 'Libya'),
(137, 'MA', 'Morocco'),
(138, 'MC', 'Monaco'),
(139, 'MD', 'Moldova'),
(140, 'ME', 'Montenegro'),
(141, 'MF', 'Saint Martin'),
(142, 'MG', 'Madagascar'),
(143, 'MH', 'Marshall Islands'),
(144, 'MK', 'Macedonia'),
(145, 'ML', 'Mali'),
(146, 'MM', 'Myanmar [Burma]'),
(147, 'MN', 'Mongolia'),
(148, 'MO', 'Macao'),
(149, 'MP', 'Northern Mariana Islands'),
(150, 'MQ', 'Martinique'),
(151, 'MR', 'Mauritania'),
(152, 'MS', 'Montserrat'),
(153, 'MT', 'Malta'),
(154, 'MU', 'Mauritius'),
(155, 'MV', 'Maldives'),
(156, 'MW', 'Malawi'),
(157, 'MX', 'Mexico'),
(158, 'MY', 'Malaysia'),
(159, 'MZ', 'Mozambique'),
(160, 'NA', 'Namibia'),
(161, 'NC', 'New Caledonia'),
(162, 'NE', 'Niger'),
(163, 'NF', 'Norfolk Island'),
(164, 'NG', 'Nigeria'),
(165, 'NI', 'Nicaragua'),
(166, 'NL', 'Netherlands'),
(167, 'NO', 'Norway'),
(168, 'NP', 'Nepal'),
(169, 'NR', 'Nauru'),
(170, 'NU', 'Niue'),
(171, 'NZ', 'New Zealand'),
(172, 'OM', 'Oman'),
(173, 'PA', 'Panama'),
(174, 'PE', 'Peru'),
(175, 'PF', 'French Polynesia'),
(176, 'PG', 'Papua New Guinea'),
(177, 'PH', 'Philippines'),
(178, 'PK', 'Pakistan'),
(179, 'PL', 'Poland'),
(180, 'PM', 'Saint Pierre and Miquelon'),
(181, 'PN', 'Pitcairn Islands'),
(182, 'PR', 'Puerto Rico'),
(183, 'PS', 'Palestine'),
(184, 'PT', 'Portugal'),
(185, 'PW', 'Palau'),
(186, 'PY', 'Paraguay'),
(187, 'QA', 'Qatar'),
(188, 'RE', 'Réunion'),
(189, 'RO', 'Romania'),
(190, 'RS', 'Serbia'),
(191, 'RU', 'Russia'),
(192, 'RW', 'Rwanda'),
(193, 'SA', 'Saudi Arabia'),
(194, 'SB', 'Solomon Islands'),
(195, 'SC', 'Seychelles'),
(196, 'SD', 'Sudan'),
(197, 'SE', 'Sweden'),
(198, 'SG', 'Singapore'),
(199, 'SH', 'Saint Helena'),
(200, 'SI', 'Slovenia'),
(201, 'SJ', 'Svalbard and Jan Mayen'),
(202, 'SK', 'Slovakia'),
(203, 'SL', 'Sierra Leone'),
(204, 'SM', 'San Marino'),
(205, 'SN', 'Senegal'),
(206, 'SO', 'Somalia'),
(207, 'SR', 'Suriname'),
(208, 'SS', 'South Sudan'),
(209, 'ST', 'São Tomé and Príncipe'),
(210, 'SV', 'El Salvador'),
(211, 'SX', 'Sint Maarten'),
(212, 'SY', 'Syria'),
(213, 'SZ', 'Swaziland'),
(214, 'TC', 'Turks and Caicos Islands'),
(215, 'TD', 'Chad'),
(216, 'TF', 'French Southern Territories'),
(217, 'TG', 'Togo'),
(218, 'TH', 'Thailand'),
(219, 'TJ', 'Tajikistan'),
(220, 'TK', 'Tokelau'),
(221, 'TL', 'East Timor'),
(222, 'TM', 'Turkmenistan'),
(223, 'TN', 'Tunisia'),
(224, 'TO', 'Tonga'),
(225, 'TR', 'Turkey'),
(226, 'TT', 'Trinidad and Tobago'),
(227, 'TV', 'Tuvalu'),
(228, 'TW', 'Taiwan'),
(229, 'TZ', 'Tanzania'),
(230, 'UA', 'Ukraine'),
(231, 'UG', 'Uganda'),
(232, 'UM', 'U.S. Minor Outlying Islands'),
(233, 'US', 'United States'),
(234, 'UY', 'Uruguay'),
(235, 'UZ', 'Uzbekistan'),
(236, 'VA', 'Vatican City'),
(237, 'VC', 'Saint Vincent and the Grenadines'),
(238, 'VE', 'Venezuela'),
(239, 'VG', 'British Virgin Islands'),
(240, 'VI', 'U.S. Virgin Islands'),
(241, 'VN', 'Vietnam'),
(242, 'VU', 'Vanuatu'),
(243, 'WF', 'Wallis and Futuna'),
(244, 'WS', 'Samoa'),
(245, 'XK', 'Kosovo'),
(246, 'YE', 'Yemen'),
(247, 'YT', 'Mayotte'),
(248, 'ZA', 'South Africa'),
(249, 'ZM', 'Zambia'),
(250, 'ZW', 'Zimbabwe');
-- --------------------------------------------------------
--
-- Table structure for table `installer`
--
CREATE TABLE IF NOT EXISTS `installer` (
`id` int(1) NOT NULL AUTO_INCREMENT,
`installer_flag` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `installer`
--
INSERT INTO `installer` (`id`, `installer_flag`) VALUES
(1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `language`
--
CREATE TABLE IF NOT EXISTS `language` (
`phrase_id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(1) NOT NULL COMMENT '1= Menu, 2= Heading, 3= Body Text, 4= Msg, 5= button',
`phrase` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`english` longtext NOT NULL,
`indonesian` longtext NOT NULL,
`french` longtext NOT NULL,
`bengali` longtext NOT NULL,
`thai` longtext NOT NULL,
`greek` longtext NOT NULL,
`spanish` longtext NOT NULL,
`h` longtext NOT NULL,
PRIMARY KEY (`phrase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=312 ;
--
-- Dumping data for table `language`
--
INSERT INTO `language` (`phrase_id`, `type`, `phrase`, `english`, `indonesian`, `french`, `bengali`, `thai`, `greek`, `spanish`, `h`) VALUES
(1, 3, 'Revenue', 'Revenue', 'Pendapatan', 'Revenu', '', '', '', '', ''),
(3, 3, 'Profit', 'Profit', 'Keuntungan', 'Profit', '', '', '', '', ''),
(4, 3, 'Quantity of Sales', 'Quantity of Sales', 'Jumlah Penjualan', 'Quantite de ventes', '', '', '', '', ''),
(5, 3, 'Value of Stock', 'Value of Stock', 'Nilai Persediaan', 'Valeur du stock', '', '', '', '', ''),
(6, 3, 'Cost of All Items Held in Stock ', 'Cost of All Items Held in Stock ', 'Biaya Semua Produk Tersedia', 'Cout de tous les articles en stock', '', '', '', '', ''),
(7, 2, 'Sales Report', 'Sales Report', 'Laporan Penjualan', 'Rapport ventes', '', '', '', '', ''),
(8, 2, 'Top 5 Best Selling Product', 'Top 5 Best Selling Product', 'Top 5 Penjualan Produk Terbaik', 'Top 5 meilleur produits vendus', '', '', '', '', ''),
(9, 2, 'Top 5 Worst Selling Product', 'Top 5 Worst Selling Product', 'Top 5 Penjualan Produk Terburuk', 'Top 5 pires produits vendus', '', '', '', '', ''),
(10, 6, 'Sl', 'Sl', 'Sl', '', '', '', '', '', ''),
(11, 6, 'Barcode', 'Barcode', 'Barcode', '', '', '', '', '', ''),
(12, 6, 'Product Name', 'Product Name', 'Nama Produk', '', '', '', '', '', ''),
(13, 6, 'Qty', 'Qty', 'Jumlah', '', '', '', '', '', ''),
(14, 3, 'Sales', 'Sales', 'Penjualan', 'Ventes', '', '', '', '', ''),
(15, 1, 'Dashboard', 'Dashboard', 'Tampilan Awal', 'Accueil', '', 'หน้ารวม', 'tset', '', ''),
(16, 1, 'Supplier Orders', 'Supplier Orders', 'Pesanan Pemasok', 'Commande ', '', '', '', '', ''),
(17, 1, 'Supplier', 'Supplier', 'Pemasok', 'Fournisseur', '', '', '', '', ''),
(18, 1, 'Add Supplier', 'Add Supplier', 'Tambah Pemasok', 'Ajout Fournisseur', '', '', '', '', ''),
(19, 1, 'Manage Supplier', 'Manage Supplier', 'Mengelola Pemasok', 'Gérer Fournisseur', '', '', '', '', ''),
(20, 1, 'Purchase', 'Purchase', 'Pembelian', 'Achat', '', '', '', '', ''),
(21, 1, 'New Purchase', 'New Purchase', 'Pembelian Baru', 'Nouvel Achat', '', '', '', '', ''),
(22, 1, 'Purchase History', 'Purchase History', 'Riwayat Pembelian', 'Historique Achat', '', '', '', '', ''),
(23, 1, 'Receive Product', 'Receive Product', 'Menerima Produk', 'Produit Recu', '', '', '', '', ''),
(24, 1, 'Create Delivery Receipt', 'Create Delivery Receipt', 'Buat Resi Pengiriman', 'Bon de Reception', '', '', '', '', ''),
(25, 1, 'Goods Received', 'Goods Received', 'Barang Diterima', 'Marchandises reçues', '', '', '', '', ''),
(26, 1, 'Product Management', 'Product Management', 'Manajemen Produk', 'Gestion de Produits', '', '', '', '', ''),
(27, 1, 'Add Product', 'Add Product', 'Tambah Produk', 'Ajouter Produits', '', '', '', '', ''),
(28, 1, 'Manage Product', 'Manage Product', 'Mengelola Produk', 'Gerer produits', '', '', '', '', ''),
(29, 1, 'Stock Transfer', 'Stock Transfer', 'Stock Transfer', 'Transfert de Stock', '', '', '', '', ''),
(30, 1, 'Barcode Print', 'Barcode Print', 'Cetak Barcode', 'Impression barcode', '', '', '', '', ''),
(31, 1, 'Damage Product', 'Damage Product', 'Produk Rusak', 'Produits endommages', '', '', '', '', ''),
(32, 1, 'Category', 'Category', 'Kategori', 'Categorie', '', '', '', '', ''),
(33, 1, 'Product Category', 'Product Category', 'Kategori Produk', 'Categorie de produits', '', '', '', '', ''),
(34, 1, 'Sub Category', 'Sub Category', 'Sub Kategori', 'Sous Categorie', '', '', '', '', ''),
(35, 1, 'Sales', 'Sales', 'Penjualan', 'Ventes', '', '', '', '', ''),
(36, 1, 'New Order', 'New Order', 'Order Baru', 'Nouvelle commande', '', '', '', '', ''),
(37, 1, 'Manage Order', 'Manage Order', 'Mengelola Order', 'Gerer commandes', '', '', '', '', ''),
(38, 1, 'Manage Invoice', 'Manage Invoice', 'Mengelola Faktur', 'Gerer factures', '', '', '', '', ''),
(39, 1, 'Customer', 'Customer', 'Pelanggan', 'Client', '', '', '', '', ''),
(40, 1, 'Add Customer', 'Add Customer', 'Tambah Pelanggan', 'Ajout client', '', '', '', '', ''),
(41, 1, 'Manage Customer', 'Manage Customer', 'Mengelola Pelanggan', 'Gerer client', '', '', '', '', ''),
(42, 1, 'Report', 'Report', 'Laporan', 'Rapport', '', '', '', '', ''),
(43, 1, 'Sales Report', 'Sales Report', 'Laporan Penjualan', 'Rapport ventes', '', '', '', '', ''),
(44, 1, 'Purchase Report', 'Purchase Report', 'Laporan Pembelian', 'Rapport achat', '', '', '', '', ''),
(45, 1, 'Stock Summary', 'Stock Summary', 'Stock Summary', 'Resumetock', '', '', '', '', ''),
(46, 1, 'Top Selling Product', 'Top Selling Product', 'Penjualan Produk Unggulan', 'Top produit vendu', '', '', '', '', ''),
(47, 1, 'Damaged Product', 'Damaged Product', 'Produk Rusak', 'Produit endommage', '', '', '', '', ''),
(48, 1, 'Settings', 'Settings', 'Pengaturan', 'Reglages', '', '', '', '', ''),
(49, 1, 'Business Profile', 'Business Profile', 'Profil Bisnis', 'Profile de Business', '', '', '', '', ''),
(50, 1, 'Manage Tax Rules', 'Manage Tax Rules', 'Mengelola Pajak', 'Gerer Regles de taxe', '', '', '', '', ''),
(51, 1, 'Manage Store', 'Manage Store', 'Mengelola Toko', 'Gerer Magasin', '', '', '', '', ''),
(52, 1, 'Localization', 'Localization', 'Lokalisasi', 'Localisation', '', '', '', '', ''),
(53, 1, 'Language Settings', 'Language Settings', 'Pengaturan Bahasa', 'Reglages Language', '', '', '', '', ''),
(54, 1, 'Employee Management', 'Employee Management', 'Manajemen Karyawan', 'Gerer Employes', '', '', '', '', ''),
(55, 1, 'Employee List', 'Employee List', 'Daftar Karyawan', 'Liste des employes', '', '', '', '', ''),
(56, 1, 'Add Employee', 'Add Employee', 'Tambahkan Karyawan', 'Ajout employe', '', '', '', '', ''),
(57, 2, 'Add New Supplier', 'Add New Supplier', 'Tambah Pemasok Baru', 'Ajout nouveau fournisseur', '', '', '', '', ''),
(58, 3, 'Company Name', 'Company Name', 'Nama Perusahaan', 'Nom de l''entreprise', '', '', '', '', ''),
(59, 3, 'Supplier Contact Person', 'Supplier Contact Person', 'Kontak Pemasok', 'Contact fournisseur', '', '', '', '', ''),
(60, 3, 'Email', 'Email', 'Email', 'Email', '', '', '', '', ''),
(61, 3, 'Phone', 'Phone', 'Telepon', 'Telephone', '', '', '', '', ''),
(62, 3, 'Address', 'Address', 'Alamat', 'Addresse', '', '', '', '', ''),
(63, 5, 'Add Supplier', 'Add Supplier', 'Tambah Pemasok', '', '', '', '', '', ''),
(64, 4, 'No Records Found', 'No Records Found', 'Tidak Ada Rekaman Ditemukan', '', '', '', '', '', ''),
(65, 4, 'Successfully Deleted', 'Successfully Deleted', 'Berhasil Dihapus', '', '', '', '', '', ''),
(66, 4, 'Successfully Saved', 'Successfully Saved', 'Berhasil Disimpan', '', '', '', '', '', ''),
(67, 6, 'Contact Person', 'Contact Person', 'Kontak ', '', '', '', '', '', ''),
(68, 6, 'Action', 'Action', 'Tindakan', '', '', '', '', '', ''),
(69, 2, 'Select Product', 'Select Product', 'Pilih Produk', 'Selectionner produit', '', '', '', '', ''),
(70, 2, 'Purchase Order', 'Purchase Order', 'Order Pembelian', 'Ordre d''achat', '', '', '', '', ''),
(71, 2, 'Product List', 'Product List', 'Daftar Produk', 'Liste des produits', '', '', '', '', ''),
(72, 6, 'Product Code', 'Product Code', 'Kode Produk', '', '', '', '', '', ''),
(73, 6, 'Inventory', 'Inventory', 'Inventori', '', '', '', '', '', ''),
(74, 3, 'Product Quantity', 'Product Quantity', 'Qty Produk', 'Quantite de produit', '', '', '', '', ''),
(75, 3, 'Unit Price', 'Unit Price', 'Harga Satuan', 'Prix unitaire', '', '', '', '', ''),
(76, 5, 'Add to Purchase', 'Add to Purchase', 'Tambah Untuk Pembelian', '', '', '', '', '', ''),
(77, 3, 'Stock location', 'Stock location', 'Lokasi Barang', 'Emplacement stock', '', '', '', '', ''),
(78, 6, 'Product', 'Product', 'Produk', '', '', '', '', '', ''),
(79, 6, 'Total', 'Total', 'Total', '', '', '', '', '', ''),
(80, 3, 'Grand Total', 'Grand Total', 'Grand Total', 'Grand total', '', '', '', '', ''),
(81, 3, 'Purchase Reference', 'Purchase Reference', 'Referensi Pembelian', 'Reference achat', '', '', '', '', ''),
(82, 3, 'Payment Method', 'Payment Method', 'Metode Pembayaran', 'Methode de paiement', '', '', '', '', ''),
(83, 3, 'Cash Payment', 'Cash Payment', 'Pembayaran Tunai', 'Paiement en liquide', '', '', '', '', ''),
(84, 3, 'Cheque Payment', 'Cheque Payment', 'Pembayaran Cek', 'Paiement par cheque', '', '', '', '', ''),
(85, 2, 'Purchase Invoice', 'Purchase Invoice', 'Faktur Pembelian', 'Facture achat', '', '', '', '', ''),
(86, 3, 'Print', 'Print', 'Cetak', 'Imprimer', '', '', '', '', ''),
(87, 3, 'PDF', 'PDF', 'PDF', 'PDF', '', '', '', '', ''),
(88, 3, 'Date of Invoice', 'Date of Invoice', 'Tanggal Faktur', 'Date de la factutre', '', '', '', '', ''),
(89, 3, 'Purchase by', 'Purchase by', 'Pembelian Oleh', 'Achat par', '', '', '', '', ''),
(90, 3, 'DESCRIPTION', 'DESCRIPTION', 'Deskripsi', 'Description', '', '', '', '', ''),
(91, 3, 'SUBTOTAL', 'SUBTOTAL', 'Subtotal', 'Sous Total', '', '', '', '', ''),
(92, 6, 'Purchase No', 'Purchase No', 'No Pembelian', '', '', '', '', '', ''),
(93, 6, 'Supplier Name', 'Supplier Name', 'Nama Pemasok', '', '', '', '', '', ''),
(94, 6, 'Purchase Date', 'Purchase Date', 'Tanggal Pembelian', '', '', '', '', '', ''),
(95, 2, 'Receipt Product', 'Receipt Product', 'Tanda Terima Produk', 'Reçu de produits', '', '', '', '', ''),
(96, 5, 'Find Purchase Order', 'Find Purchase Order', 'Temukan Order Pembelian', '', '', '', '', '', ''),
(97, 3, 'Select', 'Select', 'Pilih', 'Selectionner', '', '', '', '', ''),
(98, 3, 'Purchase Quantity', 'Purchase Quantity', 'Qty Pembelian', 'Quantite achat', '', '', '', '', ''),
(99, 3, 'Total Received Quantity', 'Total Received Quantity', 'Jumlah Total Qty', 'Quantite total recu', '', '', '', '', ''),
(100, 3, 'Received Quantity', 'Received Quantity', 'Qty Diterima', 'Quantite recu', '', '', '', '', ''),
(101, 3, 'Received Note', 'Received Note', 'Catatan', 'Note recu', '', '', '', '', ''),
(102, 4, 'Received Qty should be less than Purchase Qty', 'Received Qty should be less than Purchase Qty', 'Qty Penerimaan Harus Kurang dari Qty Pembeliaan', '', '', '', '', '', ''),
(103, 2, 'Receipt Product List', 'Receipt Product List', 'Daftar Tanda Terima', 'Liste des reçus de produits', '', '', '', '', ''),
(104, 6, 'Receipt Qty', 'Receipt Qty', 'Kuantitas Penerimaan', '', '', '', '', '', ''),
(105, 6, 'Note', 'Note', 'Catatan', '', '', '', '', '', ''),
(106, 6, 'Receipt Date', 'Receipt Date', 'Tanggal Penerimaan', '', '', '', '', '', ''),
(107, 6, 'Receipt By', 'Receipt By', 'Diterima Oleh', '', '', '', '', '', ''),
(108, 6, 'Invoice No', 'Invoice No', 'Nomor Faktur', '', '', '', '', '', ''),
(109, 2, 'Add New Product', 'Add New Product', 'Tambah Produk Baru', 'Ajout nouveau produit', '', '', '', '', ''),
(110, 3, 'General', 'General', 'General', 'General', '', '', '', '', ''),
(111, 2, 'Price', 'Price', 'Harga', 'Prix', '', '', '', '', ''),
(112, 2, 'Attribute & Tag', 'Attribute & Tag', 'Atribut & Label', 'caracteristique et etiquette', '', '', '', '', ''),
(113, 3, 'Product Note', 'Product Note', 'Catatan Produk', 'Note de produit', '', '', '', '', ''),
(114, 3, 'Select Tax', 'Select Tax', 'Pilih Pajak', 'Selectionner taxe', '', '', '', '', ''),
(115, 3, 'Product Subcategory', 'Product Subcategory', 'Sub Kategori Produk', 'Sous categorie produit', '', '', '', '', ''),
(116, 3, 'Subcategory', 'Subcategory', 'Sub Kategori', 'Sous categorie', '', '', '', '', ''),
(117, 3, 'Select Product Category', 'Select Product Category', 'Pilih Kategori Produk', 'Selectionner categorie de produit', '', '', '', '', ''),
(118, 3, 'Product Image', 'Product Image', 'Gambar Produk', 'Image de produit', '', '', '', '', ''),
(119, 3, 'Change', 'Change', 'Ubah', 'Changer', '', '', '', '', ''),
(120, 3, 'Remove', 'Remove', 'Hapus', 'Enlever', '', '', '', '', ''),
(121, 2, 'Product General Price', 'Product General Price', 'Harga Produk General', 'Prix general de produit', '', '', '', '', ''),
(122, 3, 'Buying Price', 'Buying Price', 'Harga Pembelian', 'Prix d''achat', '', '', '', '', ''),
(123, 3, 'Selling Price', 'Selling Price', 'Harga Penjualan', 'Prix de vente', '', '', '', '', ''),
(124, 2, 'Special Offer', 'Special Offer', 'Penawaran Istimewa', 'Offre speciale', '', '', '', '', ''),
(125, 3, 'Start Date', 'Start Date', 'Tanggal Mulai', 'Date de debut', '', '', '', '', ''),
(126, 3, 'End Date', 'End Date', 'Tanggal Berakhir', 'Date de fin', '', '', '', '', ''),
(127, 3, 'Special Offer Price', 'Special Offer Price', 'Harga Penawaran Istimewa', 'Prix offre speciale', '', '', '', '', ''),
(128, 2, 'Tier Price', 'Tier Price', 'Tingkatan Harga', 'Niveau de prix', '', '', '', '', ''),
(129, 3, 'Quantity Above', 'Quantity Above', 'Batas Atas', 'Quantite au dessus', '', '', '', '', ''),
(130, 3, 'Add More', 'Add More', 'Tambah Lagi', 'Ajouter plus ', '', '', '', '', ''),
(131, 2, 'Product Attribute', 'Product Attribute', 'Atribut Produk', 'Caracteristique de produit', '', '', '', '', ''),
(132, 3, 'Attribute', 'Attribute', 'Atribut', 'Caracteristique', '', '', '', '', ''),
(133, 3, 'Value', 'Value', 'Nilai', 'Valeur', '', '', '', '', ''),
(134, 2, 'Product Tag', 'Product Tag', 'Label Produk', 'Etiquette de produit', '', '', '', '', ''),
(135, 5, 'Save Product', 'Save Product', 'Simpan Produk', '', '', '', '', '', ''),
(136, 4, 'This Product Code is Exist!', 'This Product Code is Exist!', 'Kode Produk Ini Ada', '', '', '', '', '', ''),
(137, 3, 'Active', 'Active', 'Aktif', 'Actif', '', '', '', '', ''),
(138, 3, 'Deactivate', 'Deactivate', 'Tidak Aktif', 'Desactiver', '', '', '', '', ''),
(139, 3, 'Delete', 'Delete', 'Hapus', 'Supprimer', '', '', '', '', ''),
(140, 6, 'Image', 'Image', 'Gambar', '', '', '', '', '', ''),
(141, 6, 'Stock Available', 'Stock Available', 'Stok Tersedia', '', '', '', '', '', ''),
(142, 6, 'Status', 'Status', 'Status', '', '', '', '', '', ''),
(143, 3, 'Inactive', 'Inactive', 'Non-aktif', 'Non actif', '', '', '', '', ''),
(144, 5, 'Transfer Stock', 'Transfer Stock', 'Stok Pengiriman', '', '', '', '', '', ''),
(145, 3, 'Transfer From', 'Transfer From', 'Formulir Pemindahan', 'Transferer depuis', '', '', '', '', ''),
(146, 3, 'Transfer To', 'Transfer To', 'Pemindahan Ke', 'Transferer a ', '', '', '', '', ''),
(147, 6, 'Date', 'Date', 'Tanggal ', '', '', '', '', '', ''),
(148, 6, 'Transfer By', 'Transfer By', 'Pengiriman Oleh', '', '', '', '', '', ''),
(149, 3, 'Select Store', 'Select Store', 'Pilih Toko', 'Selectionner magasin', '', '', '', '', ''),
(150, 3, 'To stock location', 'To stock location', 'Ke Lokasi Stok', 'A emplacement de stock', '', '', '', '', ''),
(151, 3, 'Stock in Hand', 'Stock in Hand', 'Stok Di Tangan', 'Stock sous la main', '', '', '', '', ''),
(152, 2, 'Product Barcode Print', 'Product Barcode Print', 'Cetak Barcode Produk', 'Impression barcode de produit ', '', '', '', '', ''),
(153, 5, 'Add to Print', 'Add to Print', 'Tambah Untuk Cetak', '', '', '', '', '', ''),
(154, 5, 'Print Barcode', 'Print Barcode', 'Cetak Barcode', '', '', '', '', '', ''),
(155, 5, 'Clear Print Tray', 'Clear Print Tray', 'Bersihkan Cetak Tray', '', '', '', '', '', ''),
(156, 4, 'There is No Product Barcode for Print', 'There is No Product Barcode for Print', 'Tidak Ada Barcode Produk Untuk Dicetak', '', '', '', '', '', ''),
(157, 5, 'Add Damage Product', 'Add Damage Product', 'Tambah Produk Rusak', '', '', '', '', '', ''),
(158, 6, 'Damage Qty', 'Damage Qty', 'Qty Rusak', '', '', '', '', '', ''),
(159, 3, 'Damage Quantity', 'Damage Quantity', 'Qty Rusak', 'Quantite endommagee', '', '', '', '', ''),
(160, 3, 'Decrease From Stock', 'Decrease From Stock', 'Stok Menurun', 'Diminuer depuis stock', '', '', '', '', ''),
(161, 3, 'Yes', 'Yes', 'Ya', 'Oui', '', '', '', '', ''),
(162, 3, 'No', 'No', 'Tidak', 'Non', '', '', '', '', ''),
(163, 5, 'Save Product Category', 'Save Product Category', 'Simpan Kategori Produk', '', '', '', '', '', ''),
(164, 2, 'Product Sub Category', 'Product Sub Category', 'Sub Kategori Produk', 'Sous categorie de produit', '', '', '', '', ''),
(165, 5, 'Save Subcategory', 'Save Subcategory', 'Simpan Sub Kategori', '', '', '', '', '', ''),
(166, 3, 'Offer Start Date', 'Offer Start Date', 'Tanggal Mulai Penawaran', 'Date debut offre', '', '', '', '', ''),
(167, 3, 'Offer End Date', 'Offer End Date', 'Tanggal Akhir Penawaran', 'Date fin offre', '', '', '', '', ''),
(168, 3, 'Offer Price', 'Offer Price', 'Harga Penarawan', 'Prix d''offre', '', '', '', '', ''),
(169, 3, 'Attribute Label', 'Attribute Label', 'Atribut Label', 'Caracteristique etiquette', '', '', '', '', ''),
(170, 5, 'Close', 'Close', 'Tutup', '', '', '', '', '', ''),
(171, 5, 'Edit Product', 'Edit Product', 'Edit Produk', '', '', '', '', '', ''),
(172, 3, 'View Stock', 'View Stock', 'Lihat Stok', 'Voir stock', '', '', '', '', ''),
(173, 4, 'Product Category Information Already Exist', 'Product Category Information Already Exist', 'Informasi Kategori Produk Sudah Ada', '', '', '', '', '', ''),
(175, 4, 'Subcategory Information Already Exist', 'Subcategory Information Already Exist', 'Informasi Sub Kategori Produk Sudah Ada', '', '', '', '', '', ''),
(176, 4, 'Sub Category Information Already Used', 'Sub Category Information Already Used', 'Informasi Sub Kategori Sudah Digunakan', '', '', '', '', '', ''),
(177, 2, 'View Product Inventory', 'View Product Inventory', 'Lihat Inventori Produk', 'Voir inventaire de produit', '', '', '', '', ''),
(178, 4, 'Damage Product Qty is Greater than Product Qty!', 'Damage Product Qty is Greater than Product Qty!', 'Qty Produk Rusak Lebih Besar Daripada Qty Produk', '', '', '', '', '', ''),
(179, 4, 'You did not select any Product', 'You did not select any Product', 'Anda Belum Memilih Produk Apapun', '', '', '', '', '', ''),
(180, 4, 'Product Active Successfully!', 'Product Active Successfully!', 'Produk Aktif Berhasil!', '', '', '', '', '', ''),
(181, 4, 'Product Deactivated Successfully!', 'Product Deactivated Successfully!', 'Menonaktifkan Produk Berhasil!', '', '', '', '', '', ''),
(182, 2, 'Product Notification', 'Product Notification', 'Pemberitahuan Produk', 'Notification de produit', '', '', '', '', ''),
(183, 4, 'Same Stock Location Transfer is not Allow', 'Same Stock Location Transfer is not Allow', 'Pengiriman Stok Lokasi Sama Tidak Diperbolehkan', '', '', '', '', '', ''),
(184, 2, 'Place New Order', 'Place New Order', 'Order Baru', 'Placer nouvelle commande', '', '', '', '', ''),
(185, 3, 'Shopping Cart', 'Shopping Cart', 'Keranjang Belanja', 'Guide achats', '', '', '', '', ''),
(186, 3, 'Search Product', 'Search Product', 'Cari Produk', 'Chercher produit', '', '', '', '', ''),
(187, 5, 'Add to Cart', 'Add to Cart', 'Tambah ke Keranjang', '', '', '', '', '', ''),
(188, 3, 'Store', 'Store', 'Toko', 'Magasin', '', '', '', '', ''),
(189, 3, 'Select Stock Location', 'Select Stock Location', 'Pilih Lokasi Stok', 'Selectionner emplacement stock', '', '', '', '', ''),
(190, 5, 'Next', 'Next', 'Berikutnya', '', '', '', '', '', ''),
(191, 4, 'Product add to cart successfully!', 'Product add to cart successfully!', 'Tambah Produk ke Keranjang Berhasil!', '', '', '', '', '', ''),
(192, 4, 'Remove from Cart successfully!', 'Remove from Cart successfully!', 'Hapus dari Keranjang Berhasil!', '', '', '', '', '', ''),
(193, 4, 'Are you sure want to delete this record ?', 'Are you sure want to delete this record ?', 'Apakah Anda Yakin Ingin Hapus Catatan Ini?', '', '', '', '', '', ''),
(194, 3, 'Order No', 'Order No', 'Nomor Order', 'Commande No', '', '', '', '', ''),
(195, 5, 'Search', 'Search', 'Cari', '', '', '', '', '', ''),
(196, 3, 'Walk-in Client', 'Walk-in Client', 'Walk-in Client', 'Entrer client', '', '', '', '', ''),
(197, 3, 'Sub Total', 'Sub Total', 'Sub Total', 'Sous total', '', '', '', '', ''),
(198, 3, 'Discount Amount', 'Discount Amount', 'Jumlah Diskon', 'Montant de remise', '', '', '', '', ''),
(199, 3, 'Credit Card', 'Credit Card', 'Kartu Kredit', 'Carte de credit', '', '', '', '', ''),
(200, 3, 'Pending Order', 'Pending Order', 'Order yang Tertunda', 'Commande en attente', '', '', '', '', ''),
(201, 3, 'cheque/card Ref', 'cheque/card Ref', 'Cek / Ref Kartu', 'Cheque/ Ref carte ', '', '', '', '', ''),
(202, 3, 'Order Note', 'Order Note', 'Catatan Order', 'Note commande', '', '', '', '', ''),
(203, 3, 'Shipping', 'Shipping', 'Pengiriman', 'Shipping', '', '', '', '', ''),
(204, 5, 'Submit Order', 'Submit Order', 'Submit Order', '', '', '', '', '', ''),
(205, 6, 'Order Date', 'Order Date', 'Tanggal Order', '', '', '', '', '', ''),
(206, 6, 'Order Status', 'Order Status', 'Status Order', '', '', '', '', '', ''),
(207, 6, 'Order Total', 'Order Total', 'Total Order', '', '', '', '', '', ''),
(208, 6, 'Sales By', 'Sales By', 'Sales Oleh', '', '', '', '', '', ''),
(209, 6, 'Invoice Date', 'Invoice Date', 'Tanggal Invoice', '', '', '', '', '', ''),
(210, 2, 'View Order', 'View Order', 'Lihat Order', 'Voir commande', '', '', '', '', ''),
(211, 3, 'CUSTOMER BILLING INFO', 'CUSTOMER BILLING INFO', 'Info Tagihan Pelanggan', 'Info facturation client', '', '', '', '', ''),
(212, 3, 'Date of Order', 'Date of Order', 'Tanggal Order', 'Date de la commande', '', '', '', '', ''),
(213, 3, 'Sales Person', 'Sales Person', 'Sales', 'Ventes personne', '', '', '', '', ''),
(214, 3, 'Confirm Order', 'Confirm Order', 'Konfirmasi Order ', 'Confirmer commande', '', '', '', '', ''),
(215, 3, 'Cancel Order', 'Cancel Order', 'Batal Order', 'Annuler commande', '', '', '', '', ''),
(216, 3, 'Submit', 'Submit', 'Submit', 'Presenter', '', '', '', '', ''),
(217, 6, 'QUANTITY', 'QUANTITY', 'Jumlah', '', '', '', '', '', ''),
(218, 2, 'Order Invoice', 'Order Invoice', 'Order Invoice', 'Facture commande', '', '', '', '', ''),
(219, 5, 'Email to Customer', 'Email to Customer', 'Email ke Pelanggan', '', '', '', '', '', ''),
(220, 3, 'CUSTOMER SHIPPING INFO', 'CUSTOMER SHIPPING INFO', 'Info Pengiriman Pelanggan', 'Info shipping client', '', '', '', '', ''),
(221, 3, 'INVOICE', 'INVOICE', 'Invoice', 'Facture', '', '', '', '', ''),
(222, 2, 'Add New Order', 'Add New Order', 'Tambah Order Baru', 'Ajout nouvelle commande', '', '', '', '', ''),
(223, 4, 'Sorry! This product has not enough stock.', 'Sorry! This product has not enough stock.', 'Maaf! Produk ini Tidak Memiliki Stok yang Cukup', '', '', '', '', '', ''),
(224, 4, 'Your email has been send successfully!', 'Your email has been send successfully!', 'Anda Berhasil Mengirim Email!', '', '', '', '', '', ''),
(225, 4, 'Sorry unable to send your email!', 'Sorry unable to send your email!', 'Maaf Tidak Dapat Mengirim Email!', '', '', '', '', '', ''),
(226, 3, 'Customer Id', 'Customer Id', 'Id Pelanggan', 'Identite client', '', '', '', '', ''),
(227, 3, 'Customer Name', 'Customer Name', 'Nama Pelanggan', 'Nom client', '', '', '', '', ''),
(228, 3, 'Discount', 'Discount', 'Diskon', 'Remise', '', '', '', '', ''),
(229, 3, 'Customer Code', 'Customer Code', 'Kode Pelanggan', 'Code client', '', '', '', '', ''),
(230, 4, 'This phone number already exist!', 'This phone number already exist!', 'Nomor Telepon Ini Sudah Ada!', '', '', '', '', '', ''),
(231, 5, 'Generate Report', 'Generate Report', 'Munculkan Laporan', '', '', '', '', '', ''),
(232, 3, 'Sales Report from', 'Sales Report from', 'Laporan Penjualan dari', 'Rapport ventes depuis', '', '', '', '', ''),
(233, 3, 'to', 'to', 'ke', 'A', '', '', '', '', ''),
(234, 3, 'Total Cost', 'Total Cost', 'Total Biaya', 'Total cout', '', '', '', '', ''),
(235, 3, 'Total Sell', 'Total Sell', 'Total Penjualan', 'Total vente', '', '', '', '', ''),
(236, 3, 'Total Profit', 'Total Profit', 'Total Laba', 'Total profit', '', '', '', '', ''),
(237, 3, 'custom Order', 'custom Order', 'Permintaan Kustomisasi', 'Commande client', '', '', '', '', ''),
(238, 2, 'Stock Summary Report', 'Stock Summary Report', 'Rangkuman Laporan Persediaan', 'Rapport du resume de stock', '', '', '', '', ''),
(239, 6, 'Code', 'Code', 'Kode', '', '', '', '', '', ''),
(240, 6, 'Stock', 'Stock', 'Persediaan', '', '', '', '', '', ''),
(241, 6, 'Selling Qty', 'Selling Qty', 'Jumlah Penjualan', '', '', '', '', '', ''),
(242, 6, 'Selling Value', 'Selling Value', 'Nilai Penjualan', '', '', '', '', '', ''),
(243, 6, 'Buying Value', 'Buying Value', 'Nilai Pembelian', '', '', '', '', '', ''),
(244, 2, 'Damage Product Report', 'Damage Product Report', 'Laporan Barang Rusak', 'Rapport de produit endommage', '', '', '', '', ''),
(245, 2, 'View Sales Report', 'View Sales Report', 'Tampilan Laporan Penjualan', 'Voir rapport de ventes', '', '', '', '', ''),
(246, 2, 'View Purchase Report', 'View Purchase Report', 'Tampilan Laporan Pembelian', 'Voir ordre d''achat', '', '', '', '', ''),
(247, 2, 'Stock Report', 'Stock Report', 'Laporan Persediaan', 'Rapport de stock', '', '', '', '', ''),
(248, 2, 'Top Selling Products', 'Top Selling Products', 'Penjualan Produk Terbaik', 'Top produits vendus', '', '', '', '', ''),
(249, 2, 'General Settings', 'General Settings', 'Pengaturan Umum', 'Reglage general', '', '', '', '', ''),
(250, 5, 'Save Business Profile', 'Save Business Profile', 'Simpan Profil Bisnis', '', '', '', '', '', ''),
(251, 3, 'Company Email', 'Company Email', 'Email Perusahaan', 'Email compagnie', '', '', '', '', ''),
(252, 3, 'Company Logo', 'Company Logo', 'Logo Perusahaan', 'Logo compagnie', '', '', '', '', ''),
(253, 3, 'Select Tax Type', 'Select Tax Type', 'Pilih Jenis Pajak', 'Selectionner type de taxe', '', '', '', '', ''),
(254, 3, 'Percentage', 'Percentage', 'Persentase', 'Pourcentage', '', '', '', '', ''),
(255, 3, 'Fixed', 'Fixed', 'Tetap', 'Fixe', '', '', '', '', ''),
(256, 5, 'Save Tax Rule', 'Save Tax Rule', 'Simpan Pengaturan Pajak', '', '', '', '', '', ''),
(257, 3, 'Flat Rate (Fixed)', 'Flat Rate (Fixed)', 'Tarif Tetap', 'Taux ', '', '', '', '', ''),
(258, 3, 'Title', 'Title', 'Judul', 'Titre', '', '', '', '', ''),
(259, 3, 'Rate', 'Rate', 'Tarif', 'Taux', '', '', '', '', ''),
(260, 3, 'Tax Type', 'Tax Type', 'Jenis Pajak', 'Type de taxe', '', '', '', '', ''),
(261, 6, 'Tax Name', 'Tax Name', 'Jenis Pajak', '', '', '', '', '', ''),
(262, 6, 'Tax Rate', 'Tax Rate', 'Tarif Pajak', '', '', '', '', '', ''),
(263, 5, 'Create Store', 'Create Store', 'Buat Toko', '', '', '', '', '', ''),
(264, 5, 'Save Localization', 'Save Localization', 'Simpan Lokalisasi', '', '', '', '', '', ''),
(265, 2, 'Localisation Settings', 'Localisation Settings', 'Pengaturan Lokalisasi', 'Reglages localisation', '', '', '', '', ''),
(266, 3, 'Default Country', 'Default Country', 'Standard Negara', 'Pays par defaut', '', '', '', '', ''),
(267, 3, 'Date Format', 'Date Format', 'Pengaturan Tanggal', 'Format date', '', '', '', '', ''),
(268, 3, 'Currency Format', 'Currency Format', 'Pengaturan Mata Uang', 'Format monnaie', '', '', '', '', ''),
(269, 3, 'Select Language', 'Select Language', 'Pilih Bahasa', 'Selectionner langue', '', '', '', '', ''),
(270, 3, 'Currency', 'Currency', 'Mata Uang', 'Monnaie', '', '', '', '', ''),
(271, 2, 'Manage Employee', 'Manage Employee', 'Pengelolaan Karyawan', 'Gerer employe', '', '', '', '', ''),
(272, 6, 'Name', 'Name', 'Nama', '', '', '', '', '', ''),
(273, 6, 'Login', 'Login', 'Daftar', '', '', '', '', '', ''),
(274, 6, 'User Type', 'User Type', 'Tipe User', '', '', '', '', '', ''),
(275, 3, 'Select User Type', 'Select User Type', 'Pilih Tipe User', 'Selectionner type d''utilisateur', '', '', '', '', ''),
(276, 3, 'Admin', 'Admin', 'Admin', 'Admin', '', '', '', '', ''),
(277, 3, 'User', 'User', 'User', 'Utilisateur', '', '', '', '', ''),
(278, 2, 'Create User', 'Create User', 'Pembuatan U', 'Creer utilisateur', '', '', '', '', ''),
(279, 3, 'Username', 'Username', 'Nama', 'Nom d''utilisateur', '', '', '', '', ''),
(280, 3, 'Password', 'Password', 'Sandi', 'Mot de passe', '', '', '', '', ''),
(281, 0, 'Confirm Password', 'Confirm Password', '', '', '', '', '', '', ''),
(282, 3, 'Employee Image', 'Employee Image', 'Foto Karyawan', 'Image employe', '', '', '', '', ''),
(283, 5, 'Change Password', 'Change Password', 'Ubah Password', '', '', '', '', '', ''),
(284, 4, 'Tax Rule Already Exist!', 'Tax Rule Already Exist!', 'Pengaturan Pajak Sudah Ada!', '', '', '', '', '', ''),
(285, 4, 'Tax Rule Saved Successfully!', 'Tax Rule Saved Successfully!', 'Pengaturan Pajak Berhasil Disimpan!', '', '', '', '', '', ''),
(286, 4, 'Sorry! This store name already exist', 'Sorry! This store name already exist', 'Maaf! Nama Toko sudah ada', '', '', '', '', '', ''),
(287, 4, 'User Login Information Update Successfully!', 'User Login Information Update Successfully!', 'Update Informasi Login User Berhasil!', '', '', '', '', '', ''),
(288, 4, 'New User Create Successfully!', 'New User Create Successfully!', 'User Baru Sukses!', '', '', '', '', '', ''),
(289, 4, 'Sorry You can not delete your own account!', 'Sorry You can not delete your own account!', 'Maaf, Anda Tidak Dapat Menghapus Akun Anda!', '', '', '', '', '', ''),
(290, 2, 'Add Language', 'Add Language', 'Tambah Bahasa', 'Ajouter langue', '', '', '', '', ''),
(291, 3, 'Language ', 'Language ', 'Bahasa', 'Langue', '', '', '', '', ''),
(292, 2, 'Edit Phrase', 'Edit Phrase', 'Edit Kalimat', 'Modifier terme', '', '', '', '', ''),
(293, 3, 'Menu', 'Menu', 'Menu', 'Menu', '', '', '', '', ''),
(294, 3, 'Heading & Title', 'Heading & Title', 'Judul ', 'Entete et titre', '', '', '', '', ''),
(295, 3, 'Body Text', 'Body Text', 'Format Huruf', 'Texte ', '', '', '', '', ''),
(296, 3, 'Messages', 'Messages', 'Pesan', 'Messages', '', '', '', '', ''),
(297, 3, 'Button', 'Button', 'Tombol', 'Bouton', '', '', '', '', ''),
(298, 3, 'Table', 'Table', 'Tabel', 'Table', '', '', '', '', ''),
(299, 5, 'Save Phrase', 'Save Phrase', 'Simpan Frase', '', '', '', '', '', ''),
(300, 2, 'Edit Language', 'Edit Language', 'Edit Bahasa', 'Modifier langue', '', '', '', '', ''),
(301, 5, 'Logout', 'Logout', 'Keluar', '', '', '', '', '', ''),
(302, 3, 'See All Pending Order', 'See All Pending Order', 'Lihat Seluruh Pesanan Tertunda', 'Voir toutes les commandes en attente', '', '', '', '', ''),
(303, 3, 'See All Notification', 'See All Notification', 'Lihat Seluruh Notifikasi', 'Voir toutes les notification', '', '', '', '', ''),
(304, 3, ' Store are running out of stock', ' Store are running out of stock', 'Persediaan internal kosong', 'Magasin manquant de stock', '', '', '', '', ''),
(305, 2, 'Manage Stock Location', 'Manage Stock Location', 'Mengelola Stock Lokasi', 'Gerer emplacement stock', '', '', '', '', ''),
(306, 5, 'Send Email', 'Send Email', 'Mengirim Email', '', '', '', '', '', ''),
(307, 4, 'Send invoice email successfully', 'Send invoice email successfully', 'Kirim Email Faktur Berhasil', '', '', '', '', '', ''),
(308, 3, 'Category Name', 'Category Name', 'Kategori Nama', 'Nom de categorie', '', '', '', '', ''),
(309, 3, 'Shipping Address', 'Shipping Address', 'Alamat Pengiriman', 'Addresse shipping', '', '', '', '', ''),
(310, 2, 'Order Summary', 'Order Summary', 'Agar Ringkasan', 'Resume commande', '', '', '', '', ''),
(311, 3, 'Stock Location Name', 'Stock Location Name', 'Saham Lokasi Nama', 'Nom de l''emplacement du stock', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_attribute`
--
CREATE TABLE IF NOT EXISTS `tbl_attribute` (
`attribute_id` int(5) NOT NULL AUTO_INCREMENT,
`product_id` int(5) NOT NULL,
`attribute_name` varchar(100) NOT NULL,
`attribute_value` text NOT NULL,
PRIMARY KEY (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_attribute_set`
--
CREATE TABLE IF NOT EXISTS `tbl_attribute_set` (
`attribute_set_id` int(11) NOT NULL AUTO_INCREMENT,
`attribute_name` varchar(100) NOT NULL,
PRIMARY KEY (`attribute_set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tbl_attribute_set`
--
INSERT INTO `tbl_attribute_set` (`attribute_set_id`, `attribute_name`) VALUES
(1, 'Color'),
(2, 'Memory');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_bank`
--
CREATE TABLE IF NOT EXISTS `tbl_bank` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`bank` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `tbl_bank`
--
INSERT INTO `tbl_bank` (`id`, `bank`) VALUES
(1, 'The City Bank'),
(2, 'Dutch Bangla Bank'),
(3, 'HSBC Bank Ltd'),
(4, 'Bank Asia');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_business_profile`
--
CREATE TABLE IF NOT EXISTS `tbl_business_profile` (
`business_profile_id` int(2) NOT NULL AUTO_INCREMENT,
`company_name` varchar(100) NOT NULL,
`logo` varchar(150) DEFAULT NULL,
`full_path` varchar(150) DEFAULT NULL,
`email` varchar(100) NOT NULL,
`address` text NOT NULL,
`phone` varchar(100) NOT NULL,
PRIMARY KEY (`business_profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_business_profile`
--
INSERT INTO `tbl_business_profile` (`business_profile_id`, `company_name`, `logo`, `full_path`, `email`, `address`, `phone`) VALUES
(1, 'DIAOUNE & FRERES', 'img/uploads/codes_lab.gif', 'D:/xampp/htdocs/cisse/img/uploads/codes_lab.gif', 'diaoune@gmail.com', 'Conakry,GUINEA', '015566585');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_campaign`
--
CREATE TABLE IF NOT EXISTS `tbl_campaign` (
`campaign_id` int(11) NOT NULL AUTO_INCREMENT,
`campaign_name` varchar(128) NOT NULL,
`subject` varchar(128) NOT NULL,
`email_body` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`created_by` varchar(128) NOT NULL,
`store_id` int(3) NOT NULL,
PRIMARY KEY (`campaign_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_campaign_result`
--
CREATE TABLE IF NOT EXISTS `tbl_campaign_result` (
`campaign_result_id` int(11) NOT NULL AUTO_INCREMENT,
`campaign_id` int(10) NOT NULL,
`campaign_name` varchar(128) NOT NULL,
`subject` varchar(128) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`send_by` varchar(128) NOT NULL,
`store_id` int(3) NOT NULL,
PRIMARY KEY (`campaign_result_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_cart`
--
CREATE TABLE IF NOT EXISTS `tbl_cart` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`cart` text NOT NULL,
`cart_summary` text NOT NULL,
`contact` text NOT NULL,
`expiry` date NOT NULL,
`reference` int(5) DEFAULT NULL,
`customer_code` int(5) DEFAULT NULL,
`note` text NOT NULL,
`sales_person` varchar(100) NOT NULL,
`type` tinyint(2) NOT NULL COMMENT '1= quote, 2=suspendent',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_cart`
--
INSERT INTO `tbl_cart` (`id`, `cart`, `cart_summary`, `contact`, `expiry`, `reference`, `customer_code`, `note`, `sales_person`, `type`, `date`) VALUES
(1, '[{"id":"UA55JU6600","qty":"1","price":"870","buying_price":"650","name":"Samsung 55 Inch 4K Ultra HD","tax":130.5,"price_option":"general","store_id":"5"}]', '{"tax":130.5,"discount":0,"grand":1000.5}', '{"customer_name":"Codeslab","company":false,"address":"Bangladesh","phone":"0566307858","email":"info@codeslab.net"}', '2016-10-31', 101, 83548296, '', 'admin', 1, '2016-10-10 05:43:38'),
(3, '[{"id":"WDBBKD0020BBK-EESN","qty":"1","price":"90","buying_price":"75","name":"Western Digital 2TB ","tax":13.5,"price_option":"general","store_id":"3"},{"id":"Nikon-D7200","qty":"1","price":"925","buying_price":"800","name":"Nikon D7200 - 24.4 MP","tax":138.75,"price_option":"general","store_id":3}]', '', '', '0000-00-00', 103, NULL, '', 'admin', 2, '2016-10-10 09:34:26'),
(4, '[{"id":"Galaxy-S7-32GB","qty":"1","price":"300","buying_price":"200","name":"Samsung Galaxy S7 Edge - 32GB","tax":0,"price_option":"general","store_id":"2"},{"id":"SP0157825667","qty":"1","price":"300","buying_price":"250","name":"Sony Playstation 4 Console PAL 500 GB - Black","tax":0,"price_option":"general","store_id":"2"},{"id":"UA55JU6600","qty":"1","price":"870","buying_price":"650","name":"Samsung 55 Inch 4K Ultra HD","tax":0,"price_option":"general","store_id":"2"},{"id":"Nikon-D7200","qty":"1","price":"925","buying_price":"800","name":"Nikon D7200 - 24.4 MP","tax":0,"price_option":"general","store_id":"2"}]', '{"tax":0,"discount":71.85,"grand":2323.15}', '{"customer_name":"B Johnson","company":false,"address":"5849 Grandview Blvd,
\\nMound, MN, 55364
\\nBreakshare","phone":"254585888","email":"jonson@email.com"}', '2017-01-16', 104, 104, '', 'admin', 1, '2017-01-17 04:49:36'),
(5, '[{"id":"Galaxy-S7-32GB","qty":"1","price":"300","buying_price":"200","name":"Samsung Galaxy S7 Edge - 32GB","tax":0,"price_option":"custom_price","store_id":"2"},{"id":"Nikon-D7200","qty":"1","price":"925","buying_price":"800","name":"Nikon D7200 - 24.4 MP","tax":0,"price_option":"general","store_id":"2"}]', '', '', '0000-00-00', 105, NULL, '', 'admin', 2, '2017-01-22 18:07:54'),
(6, '[{"id":"Nikon-D7200","qty":"1","price":"925","buying_price":"800","name":"Nikon D7200 - 24.4 MP","tax":0,"price_option":"general","store_id":"3"}]', '', '', '0000-00-00', 106, 101, '', 'admin', 2, '2017-03-25 02:22:59');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_category`
--
CREATE TABLE IF NOT EXISTS `tbl_category` (
`category_id` int(5) NOT NULL AUTO_INCREMENT,
`category_name` varchar(100) NOT NULL,
`created_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tbl_category`
--
INSERT INTO `tbl_category` (`category_id`, `category_name`, `created_datetime`) VALUES
(1, 'Electronice', '2015-09-12 09:43:19'),
(2, 'Apparel', '2015-09-12 09:43:26');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_customer`
--
CREATE TABLE IF NOT EXISTS `tbl_customer` (
`customer_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_code` int(11) NOT NULL,
`customer_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`phone` varchar(100) NOT NULL,
`address` text NOT NULL,
`discount` varchar(100) NOT NULL,
`store_id` int(3) NOT NULL,
PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_customer`
--
INSERT INTO `tbl_customer` (`customer_id`, `customer_code`, `customer_name`, `email`, `phone`, `address`, `discount`, `store_id`) VALUES
(1, 101, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', '2', 1),
(2, 102, 'Charles W Johnson', 'charlse@email.com', '564245875', '9325 Gulfstream Rd,
\r\nFrankfort, IL, 60423
\r\nBrakeshare', '3', 2),
(3, 103, 'Walter H Smith', 'smith@email.com', '017525556', '414 Club House
\r\nDr, Pilot Mountain, NC, 27041
\r\nMeriland', '2', 3),
(4, 104, 'B Johnson', 'jonson@email.com', '254585888', '5849 Grandview Blvd,
\nMound, MN, 55364
\nBreakshare', '3', 5),
(6, 105, 'shuvo', 'shuvo.usuf06@gmail.com', '01671', 'dhaka', '00', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_damage_product`
--
CREATE TABLE IF NOT EXISTS `tbl_damage_product` (
`damage_product_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`product_code` varchar(128) NOT NULL,
`product_name` varchar(127) NOT NULL,
`category` varchar(128) NOT NULL,
`qty` int(5) NOT NULL,
`note` text NOT NULL,
`decrease` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0= no; 1= yes',
`store_id` int(3) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`damage_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_damage_product`
--
INSERT INTO `tbl_damage_product` (`damage_product_id`, `product_id`, `product_code`, `product_name`, `category`, `qty`, `note`, `decrease`, `store_id`, `date`) VALUES
(1, 2, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 'Electronice > Mobile', 2, 'Damage Product', 1, 1, '2016-10-11 02:38:14');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_inventory`
--
CREATE TABLE IF NOT EXISTS `tbl_inventory` (
`inventory_id` int(5) NOT NULL AUTO_INCREMENT,
`product_id` int(5) NOT NULL,
`store_id` int(3) NOT NULL,
`product_quantity` int(5) DEFAULT '0',
`notify_quantity` int(5) DEFAULT NULL,
PRIMARY KEY (`inventory_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=85 ;
--
-- Dumping data for table `tbl_inventory`
--
INSERT INTO `tbl_inventory` (`inventory_id`, `product_id`, `store_id`, `product_quantity`, `notify_quantity`) VALUES
(66, 11, 1, 25, 5),
(67, 11, 2, 18, 5),
(68, 11, 3, 14, 5),
(69, 11, 5, 16, 5),
(70, 12, 1, 13, 1),
(71, 12, 2, 19, 1),
(72, 12, 3, 20, 1),
(73, 12, 5, 14, 1),
(74, 13, 1, 124, 5),
(75, 13, 2, 10, 5),
(76, 13, 3, 23, 5),
(77, 13, 5, 23, 5),
(78, 14, 1, 45, 5),
(79, 14, 2, 36, 5),
(80, 14, 3, 0, 0),
(81, 14, 4, 0, 0),
(82, 14, 5, 5, 0),
(83, 14, 6, 0, 0),
(84, 14, 7, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_invoice`
--
CREATE TABLE IF NOT EXISTS `tbl_invoice` (
`invoice_id` int(5) NOT NULL AUTO_INCREMENT,
`invoice_no` int(11) DEFAULT NULL,
`order_id` int(11) NOT NULL,
`invoice_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`store_id` int(3) NOT NULL,
PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `tbl_invoice`
--
INSERT INTO `tbl_invoice` (`invoice_id`, `invoice_no`, `order_id`, `invoice_date`, `store_id`) VALUES
(1, 1001, 1, '2016-10-10 09:16:41', 0),
(2, 1002, 2, '2016-10-10 09:19:08', 0),
(4, 1004, 4, '2016-10-10 11:43:41', 0),
(6, 1006, 6, '2016-10-11 04:08:33', 0),
(7, 1007, 7, '2016-12-29 19:02:50', 0),
(8, 1008, 8, '2017-01-07 22:13:56', 0),
(9, 1009, 9, '2017-01-11 12:57:34', 0),
(10, 1010, 10, '2017-01-15 01:01:05', 0),
(11, 1011, 11, '2017-01-24 12:22:14', 0),
(12, 1012, 12, '2017-01-30 10:16:32', 0),
(13, 1013, 13, '2017-02-14 04:10:57', 0),
(14, 1014, 14, '2017-02-17 02:16:32', 0),
(15, 1015, 15, '2017-02-28 02:44:43', 0),
(16, 1016, 16, '2017-03-13 05:17:21', 0),
(17, 1017, 17, '2017-03-28 06:59:29', 0),
(18, 1018, 18, '2017-05-06 14:52:41', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_localization`
--
CREATE TABLE IF NOT EXISTS `tbl_localization` (
`localization_id` int(11) NOT NULL AUTO_INCREMENT,
`timezone` varchar(100) CHARACTER SET latin1 NOT NULL,
`country` int(11) NOT NULL,
`date_format` varchar(50) CHARACTER SET latin1 NOT NULL,
`currency_format` varchar(50) CHARACTER SET latin1 NOT NULL,
`language` varchar(100) NOT NULL,
`currency` varchar(50) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`localization_id`),
UNIQUE KEY `localization_id` (`localization_id`),
UNIQUE KEY `localization_id_2` (`localization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_localization`
--
INSERT INTO `tbl_localization` (`localization_id`, `timezone`, `country`, `date_format`, `currency_format`, `language`, `currency`) VALUES
(1, 'America/Tijuana', 31, 'dd/mm/yyyy', '2', 'english', '$');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_menu`
--
CREATE TABLE IF NOT EXISTS `tbl_menu` (
`menu_id` int(11) NOT NULL AUTO_INCREMENT,
`label` varchar(100) NOT NULL,
`link` varchar(100) NOT NULL,
`icon` varchar(100) NOT NULL,
`parent` int(5) NOT NULL,
`sort` int(5) NOT NULL,
PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;
--
-- Dumping data for table `tbl_menu`
--
INSERT INTO `tbl_menu` (`menu_id`, `label`, `link`, `icon`, `parent`, `sort`) VALUES
(1, 'Dashboard', 'admin/dashboard', 'fa fa-dashboard', 0, 5),
(2, 'Settings', '#', 'fa fa-cogs', 0, 40),
(3, 'Business Profile', 'admin/settings/business_profile', 'glyphicon glyphicon-briefcase', 2, 1),
(4, 'Employee Management', '#', 'entypo-users', 2, 45),
(5, 'Employee List', 'admin/employee/employee_list', 'fa fa-users', 4, 1),
(6, 'Add Employee', 'admin/employee/add_employee', 'entypo-user-add', 4, 2),
(7, 'Product Management', '#', 'glyphicon glyphicon-th-large', 0, 15),
(8, 'Category', '#', 'glyphicon glyphicon-indent-left', 7, 4),
(9, 'Product Category', 'admin/product/category', 'glyphicon glyphicon-tag', 8, 1),
(10, 'Sub Category', 'admin/product/subcategory', 'glyphicon glyphicon-tags', 8, 2),
(13, 'Add Product', 'admin/product/add_product', 'glyphicon glyphicon-plus', 7, 1),
(14, 'Manage Product', 'admin/product/manage_product', 'glyphicon glyphicon-th-list', 7, 2),
(17, 'Manage Tax Rules', 'admin/settings/tax', 'glyphicon glyphicon-credit-card', 2, 2),
(18, 'Supplier Orders', '#', 'fa fa-truck', 0, 10),
(19, 'Supplier', '#', 'glyphicon glyphicon-gift', 18, 1),
(20, 'Add Supplier', 'admin/purchase/add_supplier', 'glyphicon glyphicon-plus', 19, 1),
(21, 'Manage Supplier', 'admin/purchase/manage_supplier', 'glyphicon glyphicon-briefcase', 19, 2),
(22, 'Purchase', '#', 'glyphicon glyphicon-credit-card', 18, 2),
(23, 'New Purchase', 'admin/purchase/new_purchase', 'glyphicon glyphicon-shopping-cart', 22, 1),
(24, 'Purchase History', 'admin/purchase/purchase_list', 'glyphicon glyphicon-th-list', 22, 2),
(25, 'Customer', '', 'glyphicon glyphicon-user', 0, 25),
(26, 'Add Customer', 'admin/customer/add_customer', 'glyphicon glyphicon-plus', 25, 1),
(27, 'Manage Customer', 'admin/customer/manage_customer', 'glyphicon glyphicon-th-list', 25, 2),
(28, 'Damage Product', 'admin/product/damage_product', 'glyphicon glyphicon-trash', 7, 3),
(29, 'Barcode Print', 'admin/product/print_barcode', 'glyphicon glyphicon-barcode', 7, 3),
(30, 'Sales', '#', 'glyphicon glyphicon-shopping-cart', 0, 20),
(31, 'New Order', 'admin/order/new_order', 'fa fa-cart-plus', 30, 1),
(32, 'Manage Order', 'admin/order/manage_order', 'glyphicon glyphicon-th-list', 30, 2),
(33, 'Manage Invoice', 'admin/order/manage_invoice', 'glyphicon glyphicon-list-alt', 30, 3),
(34, 'Report', 'admin/report', 'glyphicon glyphicon-signal', 0, 30),
(35, 'Sales Report', 'admin/report/sales_report', 'fa fa-bar-chart', 34, 1),
(36, 'Purchase Report', 'admin/report/purchase_report', 'fa fa-line-chart', 34, 2),
(41, 'Manage Store', 'admin/settings/manage_store', 'glyphicon glyphicon-unchecked', 2, 5),
(42, 'Stock Transfer', 'admin/product/manage_transfer', 'fa fa-random', 7, 3),
(43, 'Receive Product', '#', 'fa fa-cube', 18, 5),
(44, 'Create Delivery Receipt', 'admin/purchase/create_receipt', 'fa fa-cubes', 43, 1),
(45, 'Goods Received', 'admin/purchase/receipt_history', 'glyphicon glyphicon-th-list', 43, 2),
(46, 'Stock Summary', 'admin/report/stock_summary', 'glyphicon glyphicon-list-alt', 34, 3),
(47, 'Damaged Product', 'admin/report/damaged_product_report', 'glyphicon glyphicon-unchecked', 34, 4),
(48, 'Top Selling product', 'admin/report/top_selling_product', 'glyphicon glyphicon-signal', 34, 3),
(49, 'Localization', 'admin/settings/localisation', 'fa fa-globe', 2, 5),
(50, 'Language Settings', 'admin/language/add_language', 'fa fa-share-alt', 2, 6),
(51, 'Due Payment', 'admin/report/due_payment_report', 'fa fa-pie-chart', 34, 3),
(52, 'Quotation', 'admin/order/quotation', 'fa fa-file-o', 30, 4),
(53, 'Suspended', 'admin/order/suspended', 'fa fa-share-square-o', 30, 5);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_order`
--
CREATE TABLE IF NOT EXISTS `tbl_order` (
`order_id` int(11) NOT NULL AUTO_INCREMENT,
`order_no` int(10) NOT NULL,
`order_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`customer_id` int(10) NOT NULL,
`customer_name` varchar(128) NOT NULL,
`customer_email` varchar(100) NOT NULL,
`customer_phone` varchar(100) NOT NULL,
`customer_address` text NOT NULL,
`shipping_address` text NOT NULL,
`sub_total` double NOT NULL,
`discount` double NOT NULL,
`discount_amount` double NOT NULL,
`total_tax` double NOT NULL,
`grand_total` double NOT NULL,
`received_amount` double NOT NULL,
`payment` text NOT NULL,
`payment_ref` varchar(120) NOT NULL,
`order_status` int(2) NOT NULL DEFAULT '0' COMMENT '0= pending; 1= cancel; 2=confirm',
`note` text NOT NULL,
`sales_person` varchar(100) NOT NULL,
`store_id` int(3) NOT NULL,
PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `tbl_order`
--
INSERT INTO `tbl_order` (`order_id`, `order_no`, `order_date`, `customer_id`, `customer_name`, `customer_email`, `customer_phone`, `customer_address`, `shipping_address`, `sub_total`, `discount`, `discount_amount`, `total_tax`, `grand_total`, `received_amount`, `payment`, `payment_ref`, `order_status`, `note`, `sales_person`, `store_id`) VALUES
(1, 1001, '2016-10-10 09:16:41', 0, 'walking Client', '', '', '', '', 925, 0, 0, 138.75, 1063.75, 1063.75, '[{"date":"20161010","payment_method":"cash","amount":"1063.75"}]', '', 2, '', 'admin', 3),
(2, 1002, '2016-10-10 09:19:08', 0, 'walking Client', '', '', '', '1/a, Shewrapara,
Dhaka
', 8650, 0, 0, 1297.5, 9947.5, 9947.5, '[{"date":"20161010","payment_method":"card","bank":"Bank Asia","cc_no":"4444","cc_name":"Rashed","amount":"9947.50"}]', '', 2, 'Early Morning Delivery ', 'admin', 5),
(3, 1003, '2016-10-10 09:28:56', 1, 'Julio Herrera', 'julio.herrera62@example.com', '123456', '4962 long rapids rd, South
\nJakarta, Indonesia
\n', '0', 925, 5, 53.1875, 138.75, 1010.5625, 1009.56, 'null', '', 1, '0', 'admin', 5),
(4, 1004, '2016-10-10 11:43:41', 6, 'Codeslab', 'info@codeslab.net', '0566307858', 'Bangladesh
\n', '', 150, 2, 3.45, 22.5, 169.05, 169.05, '[{"date":"20161010","payment_method":"cash","amount":"169.05"}]', '', 2, '', 'admin', 3),
(5, 1005, '2016-10-11 02:41:42', 4, 'B Johnson', 'jonson@email.com', '254585888', '5849 Grandview Blvd,
\r\nMound, MN, 55364
\r\nBreakshare', 'B Johnson
5849 Grandview Blvd,
\r\nMound, MN, 55364
\r\nBreakshare254585888
jonson@email.com
', 443, 5, 25.4725, 66.45, 483.9775, 483.98, '[{"date":"20161011","payment_method":"cheque","bank":"Bank Asia","cheque":"AS-752215556","amount":"483.98"}]', '', 1, '', 'admin', 3),
(6, 1006, '2016-10-11 04:08:33', 0, 'walking Client', '', '', '', '', 290, 0, 0, 43.5, 333.5, 333.5, '[{"date":"20161011","payment_method":"cash","amount":""}]', '', 2, '', 'admin', 3),
(7, 1007, '2016-12-29 19:02:50', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', 'Joy R Johnson
1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State6056425723
johnson@email.com
', 600, 2, 12, 0, 588, 300, '[{"date":"20161229","payment_method":"cheque","bank":"Bank Asia","cheque":"CHK-015255","amount":"300"}]', '', 2, '', 'admin', 1),
(8, 1008, '2017-01-07 22:13:56', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', '', 1800, 2, 36, 0, 1764, 1764, '[{"date":"20170107","payment_method":"cash","amount":"1764"}]', '', 2, '', 'admin', 2),
(9, 1009, '2017-01-11 12:57:34', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', '', 2500, 0, 0, 0, 2500, 1200, '[{"date":"20170111","payment_method":"cash","amount":"1200"}]', '', 2, '', 'admin', 2),
(10, 1010, '2017-01-15 01:01:05', 0, 'walking Client', '', '', '', '', 900, 0, 0, 0, 900, 0, '[{"date":"20170114","payment_method":"cash","amount":""}]', '', 2, '', 'admin', 2),
(11, 1011, '2017-01-24 12:22:14', 0, 'walking Client', '', '', '', '', 2395, 0, 0, 0, 2395, 1240, '[{"date":"20170124","payment_method":"cash","amount":""}]', '', 2, '', 'admin', 2),
(12, 1012, '2017-01-30 10:16:31', 0, 'walking Client', '', '', '', '', 300, 0, 0, 0, 300, 200, '[{"date":"20170130","payment_method":"cash","amount":"200"}]', '', 2, '', 'Martin Gongalo', 0),
(13, 1013, '2017-02-14 04:10:57', 0, 'walking Client', '', '', '', '', 300, 0, 0, 0, 300, 200, '[{"date":"20170213","payment_method":"cash","amount":""}]', '', 2, '', 'admin', 3),
(14, 1014, '2017-02-17 02:16:32', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', 'Joy R Johnson
1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State6056425723
johnson@email.com
', 2100, 2, 42, 0, 2058, 23452, '[{"date":"20170216","payment_method":"cheque","bank":"Dutch Bangla Bank","cheque":"asdf","amount":"23452"}]', '', 2, 'asdf', 'admin', 2),
(15, 1015, '2017-02-28 02:44:42', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', '', 300, 2, 6, 0, 294, 300, '[{"date":"20170227","payment_method":"cash","amount":"300"}]', '', 2, '', 'admin', 1),
(16, 1016, '2017-03-13 05:17:21', 0, 'walking Client', '', '', '', '', 300, 0, 0, 23.25, 323.25, 325.25, '[{"date":"20170312","payment_method":"card","bank":"HSBC Bank Ltd","cc_no":"5466","cc_name":"test name","amount":"325.25"}]', '', 2, 'adasdsad', 'admin', 1),
(17, 1017, '2017-03-28 06:59:29', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', '', 870, 2, 17.4, 0, 852.6, 8500, '[{"date":"20170327","payment_method":"cash","amount":"8500"}]', '', 2, '', 'admin', 1),
(18, 1018, '2017-05-06 14:52:40', 1, 'Joy R Johnson', 'johnson@email.com', '6056425723', '1230 North Ave,
\r\nSpearfish, SD, 57783
\r\nUnited State', '', 2395, 2, 48.365, 23.25, 2369.885, 2369.89, '[{"date":"20170506","payment_method":"cash","amount":"2369.89"}]', '', 2, '', 'admin', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_order_details`
--
CREATE TABLE IF NOT EXISTS `tbl_order_details` (
`order_details_id` int(10) NOT NULL AUTO_INCREMENT,
`order_id` int(10) NOT NULL,
`product_id` int(11) NOT NULL,
`product_code` varchar(128) NOT NULL,
`product_name` varchar(128) NOT NULL,
`product_quantity` int(5) NOT NULL,
`buying_price` double NOT NULL,
`selling_price` double NOT NULL,
`product_tax` double NOT NULL,
`sub_total` double NOT NULL,
`price_option` varchar(100) NOT NULL,
`store` varchar(100) NOT NULL,
PRIMARY KEY (`order_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
--
-- Dumping data for table `tbl_order_details`
--
INSERT INTO `tbl_order_details` (`order_details_id`, `order_id`, `product_id`, `product_code`, `product_name`, `product_quantity`, `buying_price`, `selling_price`, `product_tax`, `sub_total`, `price_option`, `store`) VALUES
(1, 1, 11, 'Nikon-D7200', 'Nikon D7200 - 24.4 MP', 1, 800, 925, 138.75, 925, 'general', 'California'),
(2, 2, 6, 'Hugo_Boss-Mens-3-Pack', 'Hugo Boss Men''s T-Shirt', 1, 100, 150, 22.5, 150, 'general', 'Fargo'),
(3, 2, 5, 'Apple-iMac-MF883', 'Apple iMac MF883', 1, 4500, 5000, 750, 5000, 'general', 'Fargo'),
(4, 2, 2, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 1, 2399, 3500, 525, 3500, 'general', 'Fargo'),
(5, 3, 11, 'Nikon-D7200', 'Nikon D7200 - 24.4 MP', 1, 800, 925, 138.75, 925, 'general', 'Fargo'),
(6, 4, 6, 'Hugo_Boss-Mens-3-Pack', 'Hugo Boss Men''s T-Shirt', 1, 100, 150, 22.5, 150, 'general', 'California'),
(7, 5, 10, 'WDBBKD0020BBK-EESN', 'Western Digital 2TB ', 1, 75, 90, 13.5, 90, 'general', 'California'),
(8, 5, 9, 'ES1-572-59GU', 'Acer Aspire ES1-572-59GU Laptop', 1, 250, 353, 52.95, 353, 'general', 'California'),
(9, 6, 13, 'SP01578256', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 250, 290, 43.5, 290, 'general', 'California'),
(10, 7, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 2, 200, 300, 0, 600, 'general', 'CKRY'),
(11, 8, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 3, 200, 300, 0, 900, 'general', 'Chicago'),
(12, 8, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 3, 250, 300, 0, 900, 'general', 'Chicago'),
(13, 9, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 10, 200, 250, 0, 2500, 'custom_price', 'Chicago'),
(14, 10, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 3, 250, 300, 0, 900, 'general', 'Chicago'),
(15, 11, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 200, 300, 0, 300, 'general', 'Chicago'),
(16, 11, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 250, 300, 0, 300, 'general', 'Chicago'),
(17, 11, 12, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 1, 650, 870, 0, 870, 'general', 'Chicago'),
(18, 11, 11, 'Nikon-D7200', 'Nikon D7200 - 24.4 MP', 1, 800, 925, 0, 925, 'general', 'Chicago'),
(19, 12, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 250, 300, 0, 300, 'general', 'Chicago'),
(20, 13, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 250, 300, 0, 300, 'general', 'ArTeK'),
(21, 14, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 7, 250, 300, 0, 2100, 'general', 'Chicago'),
(22, 15, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 200, 300, 0, 300, 'general', 'New York'),
(23, 16, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 200, 300, 23.25, 300, 'general', 'New York'),
(24, 17, 12, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 1, 650, 870, 0, 870, 'general', 'New York'),
(25, 18, 14, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 200, 300, 23.25, 300, 'general', 'New York'),
(26, 18, 13, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 250, 300, 0, 300, 'general', 'New York'),
(27, 18, 12, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 1, 650, 870, 0, 870, 'general', 'New York'),
(28, 18, 11, 'Nikon-D7200', 'Nikon D7200 - 24.4 MP', 1, 800, 925, 0, 925, 'general', 'New York');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_order_shipping`
--
CREATE TABLE IF NOT EXISTS `tbl_order_shipping` (
`order_shipping_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`shipping_first_name` varchar(100) NOT NULL,
`shipping_last_name` varchar(100) NOT NULL,
`shipping_address` text NOT NULL,
`shipping_postcode` varchar(100) NOT NULL,
`shipping_city` varchar(100) NOT NULL,
`shipping_country` varchar(100) NOT NULL,
`shipping_phone` varchar(100) NOT NULL,
`shipping_mobile` varchar(100) NOT NULL,
PRIMARY KEY (`order_shipping_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_payment`
--
CREATE TABLE IF NOT EXISTS `tbl_payment` (
`payment_id` int(5) NOT NULL AUTO_INCREMENT,
`payment_type` varchar(100) NOT NULL,
`payment_status` varchar(100) NOT NULL,
`payment_date_time` datetime NOT NULL,
PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_product`
--
CREATE TABLE IF NOT EXISTS `tbl_product` (
`product_id` int(11) NOT NULL AUTO_INCREMENT,
`product_code` varchar(100) NOT NULL,
`location_id` int(11) NOT NULL,
`product_name` varchar(100) NOT NULL,
`product_note` text NOT NULL,
`status` tinyint(2) DEFAULT '1' COMMENT '0=Inactive,1=Active',
`subcategory_id` int(5) NOT NULL,
`barcode_path` varchar(300) NOT NULL,
`barcode` varchar(100) NOT NULL,
`stock` int(11) NOT NULL,
`stock_history` longtext NOT NULL,
`tax_id` int(11) NOT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `tbl_product`
--
INSERT INTO `tbl_product` (`product_id`, `product_code`, `location_id`, `product_name`, `product_note`, `status`, `subcategory_id`, `barcode_path`, `barcode`, `stock`, `stock_history`, `tax_id`) VALUES
(11, 'Nikon-D7200', 2, 'Nikon D7200 - 24.4 MP', 'Nikon D7200 - 24.4 MP, SLR Camera, Black, 18 - 140mm Lens Kit', 1, 10, 'D:\\xampp\\htdocs\\multi_inv_v1/img/barcode/Nikon-D7200.jpg', 'img/barcode/Nikon-D7200.jpg', 0, '', 1),
(12, 'UA55JU6600', 1, 'Samsung 55 Inch 4K Ultra HD', 'Samsung 55 Inch 4K Ultra HD Curved LED Smart TV ', 1, 11, 'D:\\xampp\\htdocs\\multi_inv_v1/img/barcode/UA55JU6600.jpg', 'img/barcode/UA55JU6600.jpg', 250, '[{"qty":"100","location_id":"1","ref":"Add Item","date":"2016-11-14","time":" 11:08:43","type":"add","added_by":"admin"},{"qty":"100","location_id":"2","ref":"Add Item","date":"2016-11-14","time":" 11:09:13","type":"add","added_by":"admin"},{"qty":"100","location_id":"8","ref":"Add Item","date":"2016-11-14","time":" 11:09:43","type":"add","added_by":"admin"},{"qty":"50","location_id":"2","ref":"Remove","date":"2016-11-14","time":" 11:10:19","type":"remove","added_by":"admin"},{"qty":"50","location_id":"2","ref":"Transfer Stock","date":"2016-11-24","time":" 19:14:40","type":"remove","added_by":"admin"},{"qty":"50","location_id":"4","ref":"Transfer Stock","date":"2016-11-24","time":" 19:14:40","type":"add","added_by":"admin"},{"qty":"100","location_id":"2","ref":"Transfer","date":"2016-11-24","time":" 19:15:57","type":"remove","added_by":"admin"},{"qty":"100","location_id":"7","ref":"Transfer","date":"2016-11-24","time":" 19:15:57","type":"add","added_by":"admin"}]', 1),
(13, 'SP0157825667', 1, 'Sony Playstation 4 Console PAL 500 GB - Black', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 12, 'D:\\xampp\\htdocs\\multi_inv_v1/img/barcode/SP0157825667.jpg', 'img/barcode/SP0157825667.jpg', 0, '', 1),
(14, 'Galaxy-S7-32GB', 0, 'Samsung Galaxy S7 Edge - 32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 2, '/home/multiinventory/public_html/img/barcode/Galaxy-S7-32GB.jpg', 'img/barcode/Galaxy-S7-32GB.jpg', 0, '', 3);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_product_image`
--
CREATE TABLE IF NOT EXISTS `tbl_product_image` (
`product_image_id` int(5) NOT NULL AUTO_INCREMENT,
`product_id` int(5) NOT NULL,
`image_path` varchar(300) NOT NULL,
`filename` varchar(100) NOT NULL,
PRIMARY KEY (`product_image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `tbl_product_image`
--
INSERT INTO `tbl_product_image` (`product_image_id`, `product_id`, `image_path`, `filename`) VALUES
(9, 11, 'D:/xampp/htdocs/cisse/img/uploads/item_XXL_8206461_8603458.jpg', 'img/uploads/item_XXL_8206461_8603458.jpg'),
(10, 12, 'D:/xampp/htdocs/cisse/img/uploads/item_XXL_8323790_7941649.jpg', 'img/uploads/item_XXL_8323790_7941649.jpg'),
(11, 13, 'D:/xampp/htdocs/cisse/img/uploads/item_XXL_9756233_16691655.jpg', 'img/uploads/item_XXL_9756233_16691655.jpg'),
(12, 14, '/home/multiinventory/public_html/img/uploads/@pass.gif.php_.gif', 'img/uploads/@pass.gif.php_.gif');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_product_price`
--
CREATE TABLE IF NOT EXISTS `tbl_product_price` (
`product_price_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(5) NOT NULL,
`buying_price` double NOT NULL,
`selling_price` double NOT NULL,
PRIMARY KEY (`product_price_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `tbl_product_price`
--
INSERT INTO `tbl_product_price` (`product_price_id`, `product_id`, `buying_price`, `selling_price`) VALUES
(11, 11, 800, 925),
(12, 12, 650, 870),
(13, 13, 250, 300),
(14, 14, 200, 300);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_product_tag`
--
CREATE TABLE IF NOT EXISTS `tbl_product_tag` (
`product_tag_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`tag` varchar(100) NOT NULL,
PRIMARY KEY (`product_tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_purchase`
--
CREATE TABLE IF NOT EXISTS `tbl_purchase` (
`purchase_id` int(11) NOT NULL AUTO_INCREMENT,
`purchase_order_number` int(11) NOT NULL,
`supplier_id` int(11) NOT NULL,
`supplier_name` varchar(128) NOT NULL,
`grand_total` int(5) NOT NULL,
`purchase_ref` varchar(128) NOT NULL,
`payment_method` varchar(128) NOT NULL,
`payment_ref` varchar(128) NOT NULL,
`purchase_by` varchar(100) NOT NULL,
`store_id` int(3) NOT NULL,
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`purchase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `tbl_purchase`
--
INSERT INTO `tbl_purchase` (`purchase_id`, `purchase_order_number`, `supplier_id`, `supplier_name`, `grand_total`, `purchase_ref`, `payment_method`, `payment_ref`, `purchase_by`, `store_id`, `datetime`) VALUES
(1, 101, 1, 'Sony Corporation', 25000, '', 'cash', '', 'admin', 1, '2016-10-10 13:35:29'),
(2, 102, 2, 'Apple Inc.', 72240, 'PU75895', 'cash', '', 'admin', 2, '2016-10-10 14:31:19'),
(4, 103, 2, 'Apple Inc.', 148990, '', 'cash', '', 'admin', 1, '2016-11-06 04:16:10'),
(5, 105, 1, 'Sony Corporation', 32500, '', 'cash', '', 'admin', 2, '2016-11-24 17:26:47'),
(6, 106, 2, 'Apple Inc.', 850, 'qewfref', 'cash', '', 'admin', 2, '2017-02-17 02:05:46'),
(7, 107, 1, 'Sony Corporation', 450, '', 'cheque', '', 'admin', 1, '2017-04-06 10:29:18');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_purchase_product`
--
CREATE TABLE IF NOT EXISTS `tbl_purchase_product` (
`purchase_product_id` int(11) NOT NULL AUTO_INCREMENT,
`purchase_id` int(11) NOT NULL,
`product_code` varchar(100) NOT NULL,
`product_name` varchar(128) NOT NULL,
`qty` int(5) NOT NULL,
`total_received` int(10) NOT NULL,
`unit_price` int(5) NOT NULL,
`sub_total` int(5) NOT NULL,
PRIMARY KEY (`purchase_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `tbl_purchase_product`
--
INSERT INTO `tbl_purchase_product` (`purchase_product_id`, `purchase_id`, `product_code`, `product_name`, `qty`, `total_received`, `unit_price`, `sub_total`) VALUES
(1, 1, 'SP01578256', 'Sony Playstation 4 Console PAL 500 GB - Black', 100, 100, 250, 25000),
(2, 2, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 10, 10, 2399, 23990),
(3, 2, 'Apple-iMac-MF883', 'Apple iMac MF883', 10, 10, 4500, 45000),
(4, 2, 'ES1-572-59GU', 'Acer Aspire ES1-572-59GU Laptop', 10, 0, 250, 2500),
(5, 2, 'WDBBKD0020BBK-EESN', 'Western Digital 2TB ', 10, 0, 75, 750),
(9, 4, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 10, 10, 2399, 23990),
(10, 4, 'Apple-MacBook-Pro-MF840', 'Apple MacBook Pro MF840 - Intel Core i5', 10, 10, 3500, 35000),
(11, 4, 'Apple-iMac-MF883', 'Apple iMac MF883', 20, 20, 4500, 90000),
(12, 5, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 50, 20, 650, 32500),
(13, 6, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 0, 200, 200),
(14, 6, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 1, 0, 650, 650),
(15, 7, 'Galaxy-S7-32GB', 'Samsung Galaxy S7 Edge - 32GB', 1, 0, 200, 200),
(16, 7, 'SP0157825667', 'Sony Playstation 4 Console PAL 500 GB - Black', 1, 0, 250, 250);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_receipt_goods`
--
CREATE TABLE IF NOT EXISTS `tbl_receipt_goods` (
`receipt_id` int(11) NOT NULL AUTO_INCREMENT,
`purchase_order_number` int(5) NOT NULL,
`product_code` varchar(128) NOT NULL,
`product_name` varchar(128) NOT NULL,
`supplier_name` varchar(128) NOT NULL,
`receipt_qty` varchar(128) NOT NULL,
`receipt_note` text NOT NULL,
`store_name` varchar(128) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`receipt_by` varchar(128) NOT NULL,
PRIMARY KEY (`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `tbl_receipt_goods`
--
INSERT INTO `tbl_receipt_goods` (`receipt_id`, `purchase_order_number`, `product_code`, `product_name`, `supplier_name`, `receipt_qty`, `receipt_note`, `store_name`, `date`, `receipt_by`) VALUES
(1, 101, 'SP01578256', 'Sony Playstation 4 Console PAL 500 GB - Black', 'Sony Corporation', '50', 'Received 50 Product', 'New York', '2016-10-10 13:54:42', 'admin'),
(2, 101, 'SP01578256', 'Sony Playstation 4 Console PAL 500 GB - Black', 'Sony Corporation', '40', 'Received Another 40', 'New York', '2016-10-10 14:22:19', 'admin'),
(3, 101, 'SP01578256', 'Sony Playstation 4 Console PAL 500 GB - Black', 'Sony Corporation', '10', 'Received', 'New York', '2016-10-10 14:22:52', 'admin'),
(4, 102, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 'Apple Inc.', '5', 'Received', 'Florida', '2016-10-10 14:36:35', 'admin'),
(5, 102, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 'Apple Inc.', '5', 'Received', 'Florida', '2016-10-10 14:37:33', 'admin'),
(6, 102, 'Apple-iMac-MF883', 'Apple iMac MF883', 'Apple Inc.', '5', 'Received', 'Florida', '2016-10-10 14:38:32', 'admin'),
(7, 102, 'Apple-iMac-MF883', 'Apple iMac MF883', 'Apple Inc.', '5', 'Received', 'Florida', '2016-10-11 05:26:56', 'admin'),
(10, 103, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 'Apple Inc.', '5', '', 'New York', '2016-11-07 16:22:06', 'admin'),
(11, 103, 'Apple-MacBook-Pro-MF840', 'Apple MacBook Pro MF840 - Intel Core i5', 'Apple Inc.', '5', '', 'New York', '2016-11-07 16:22:06', 'admin'),
(12, 103, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 'Apple Inc.', '5', '', 'New York', '2016-11-07 16:22:47', 'admin'),
(13, 103, 'Apple-MacBook-Pro-MF840', 'Apple MacBook Pro MF840 - Intel Core i5', 'Apple Inc.', '5', '', 'New York', '2016-11-07 16:22:47', 'admin'),
(14, 103, 'Apple-iMac-MF883', 'Apple iMac MF883', 'Apple Inc.', '15', '', 'New York', '2016-11-07 16:22:47', 'admin'),
(15, 103, 'Apple-iMac-MF883', 'Apple iMac MF883', 'Apple Inc.', '5', '', 'New York', '2016-11-07 16:23:27', 'admin'),
(16, 105, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 'Sony Corporation', '10', '', 'Florida', '2016-11-24 17:27:38', 'admin'),
(17, 105, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 'Sony Corporation', '10', '', 'Florida', '2016-11-24 18:58:25', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_special_offer`
--
CREATE TABLE IF NOT EXISTS `tbl_special_offer` (
`special_offer_id` int(5) NOT NULL AUTO_INCREMENT,
`product_id` int(5) NOT NULL,
`offer_price` double DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
PRIMARY KEY (`special_offer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_special_offer`
--
INSERT INTO `tbl_special_offer` (`special_offer_id`, `product_id`, `offer_price`, `start_date`, `end_date`) VALUES
(1, 13, 290, '2016-10-11', '2016-10-31');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_stock_transfer`
--
CREATE TABLE IF NOT EXISTS `tbl_stock_transfer` (
`stock_transfer_id` int(5) NOT NULL AUTO_INCREMENT,
`product_code` varchar(100) NOT NULL,
`product_name` varchar(128) NOT NULL,
`transfer_qty` int(5) NOT NULL,
`from_store_name` varchar(128) NOT NULL,
`to_store_name` varchar(128) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`transfer_by` varchar(128) NOT NULL,
PRIMARY KEY (`stock_transfer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `tbl_stock_transfer`
--
INSERT INTO `tbl_stock_transfer` (`stock_transfer_id`, `product_code`, `product_name`, `transfer_qty`, `from_store_name`, `to_store_name`, `date`, `transfer_by`) VALUES
(1, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 40, 'New York', 'Florida', '2016-10-10 14:42:33', 'admin'),
(2, 'Apple-iPhone-6', 'Apple iPhone 6 Without FaceTime- 64GB, 4G LTE, Gold', 52, 'New York', 'Florida', '2016-11-04 17:53:01', 'Martin Gongalo'),
(3, 'Nikon-D7200', 'Nikon D7200 - 24.4 MP', 5, 'ArTeK', 'New York', '2017-02-05 13:29:35', 'admin'),
(4, 'UA55JU6600', 'Samsung 55 Inch 4K Ultra HD', 5, 'Chicago', 'ArTeK', '2017-02-19 16:45:23', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_store`
--
CREATE TABLE IF NOT EXISTS `tbl_store` (
`store_id` int(10) NOT NULL AUTO_INCREMENT,
`store_name` varchar(100) NOT NULL,
`active` tinyint(2) NOT NULL DEFAULT '1',
`store_percentage` int(5) NOT NULL,
PRIMARY KEY (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `tbl_store`
--
INSERT INTO `tbl_store` (`store_id`, `store_name`, `active`, `store_percentage`) VALUES
(1, 'New York', 1, 0),
(2, 'Chicago', 1, 0),
(3, 'ArTeK', 1, 0),
(4, 'test', 1, 0),
(5, 'Phoenix', 1, 0),
(6, 'Papaya Besar', 1, 0),
(7, 'gu', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_subcategory`
--
CREATE TABLE IF NOT EXISTS `tbl_subcategory` (
`subcategory_id` int(5) NOT NULL AUTO_INCREMENT,
`category_id` int(5) NOT NULL,
`subcategory_name` varchar(100) NOT NULL,
`created_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`subcategory_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `tbl_subcategory`
--
INSERT INTO `tbl_subcategory` (`subcategory_id`, `category_id`, `subcategory_name`, `created_datetime`) VALUES
(1, 1, 'Laptop', '2015-09-12 09:43:43'),
(2, 1, 'Mobile', '2015-09-12 09:43:54'),
(3, 2, 'T-Shirt', '2015-09-12 09:44:05'),
(4, 2, 'Polo Shirt', '2015-09-12 09:44:23'),
(10, 1, 'Camera', '2016-10-08 14:21:42'),
(11, 1, 'TV', '2016-10-08 14:21:51'),
(12, 1, 'Accessories', '2016-10-08 14:22:03');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_supplier`
--
CREATE TABLE IF NOT EXISTS `tbl_supplier` (
`supplier_id` int(11) NOT NULL AUTO_INCREMENT,
`company_name` varchar(100) NOT NULL,
`supplier_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`phone` varchar(100) NOT NULL,
`address` text NOT NULL,
PRIMARY KEY (`supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_supplier`
--
INSERT INTO `tbl_supplier` (`supplier_id`, `company_name`, `supplier_name`, `email`, `phone`, `address`) VALUES
(1, 'Sony Corporation', 'Herman lopez', 'zaman@codeslab.net', '015548566', '7767 first street, USA
\r\n'),
(2, 'Apple Inc.', 'Charlene Snyder', 'charlene.snyder@example.com', '6218028041', '6101 werth rd, USA
\n'),
(3, 'Samsung Corporation', 'Regina Kuhn', 'regina.kuhn@example.com', '3233899904', '4478 cedar dr Dhaka
\n'),
(4, 'Polo Apparel', 'Dennis Walker', 'dennis.walker28@example.com', '012458256', '6872 e santa ana st
\r\n'),
(5, 'ddd', '????????????? ???', 'ddd', '555555', ''),
(6, 'testnarola', 'test', '', '9898989898', 'tretret
\n');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_tag`
--
CREATE TABLE IF NOT EXISTS `tbl_tag` (
`tag_id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(100) NOT NULL,
PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tbl_tag`
--
INSERT INTO `tbl_tag` (`tag_id`, `tag`) VALUES
(1, 'Samsung'),
(2, 'Apple');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_tax`
--
CREATE TABLE IF NOT EXISTS `tbl_tax` (
`tax_id` int(11) NOT NULL AUTO_INCREMENT,
`tax_title` varchar(100) NOT NULL,
`tax_rate` double NOT NULL,
`tax_type` int(2) NOT NULL,
PRIMARY KEY (`tax_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_tax`
--
INSERT INTO `tbl_tax` (`tax_id`, `tax_title`, `tax_rate`, `tax_type`) VALUES
(1, 'No.TAX', 0, 2),
(2, 'IVA', 19, 1),
(3, 'SALES TAX', 7.75, 1);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_tier_price`
--
CREATE TABLE IF NOT EXISTS `tbl_tier_price` (
`tier_price_id` int(5) NOT NULL AUTO_INCREMENT,
`product_id` int(5) NOT NULL,
`tier_price` double NOT NULL,
`quantity_above` int(5) NOT NULL,
PRIMARY KEY (`tier_price_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_tier_price`
--
INSERT INTO `tbl_tier_price` (`tier_price_id`, `product_id`, `tier_price`, `quantity_above`) VALUES
(1, 13, 270, 10);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_user`
--
CREATE TABLE IF NOT EXISTS `tbl_user` (
`user_id` int(5) NOT NULL AUTO_INCREMENT,
`user_name` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(200) NOT NULL,
`filename` varchar(128) NOT NULL,
`image_path` varchar(128) NOT NULL,
`flag` tinyint(4) NOT NULL DEFAULT '0',
`store_id` int(2) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `tbl_user`
--
INSERT INTO `tbl_user` (`user_id`, `user_name`, `name`, `email`, `password`, `filename`, `image_path`, `flag`, `store_id`) VALUES
(1, 'admin', 'admin', 'support@codeslab.net', '55677fc54be3b674770b697114ce0730300da0f6783202e2d17d7191ba68ec97cab4b61d3470f298d0ca2435111c29b8d5ad63058b725916336fdab9584829f4', 'img/uploads/68.jpg', 'D:/xampp/htdocs/cisse/img/uploads/68.jpg', 1, 0),
(3, 'morike', 'Kaba Morike', 'diaoune@gmail.com', 'e7304f57cd41bfba3a096a8304ed66052b6faf92cb6f807d9f71fe9a518acf748a6815a2fd4749a63cd5cc5934b016fab981e1d41f610f77c6a79e1c703c3bff', '', '', 0, 3),
(6, 'martin', 'Martin Gongalo', 'support@codeslab.net', '17ada7ce7a6a9f01f0aabbb431321d365b01a3e3474f107562e738afbfe0c13abf9ea7ee61e22c990912fd2bc5ef0e4c657b4c82f132bf8e79f6dacb14d3c466', 'img/uploads/63.jpg', 'D:/xampp/htdocs/cisse/img/uploads/63.jpg', 0, 2),
(7, 'qwer', 'jdjgdg', 'sfjshf@gjgn.com', '17ada7ce7a6a9f01f0aabbb431321d365b01a3e3474f107562e738afbfe0c13abf9ea7ee61e22c990912fd2bc5ef0e4c657b4c82f132bf8e79f6dacb14d3c466', '', '', 0, 1),
(8, 'apune', 'apune', 'apune@gmail.com', 'af0b5db562e9b0fb0bc65020060d9fe3561dea50d95238ba21b905457c142a0bfa2d44339305aeb87b77350f4dfddfac29066e617c845615765ca281fdb3bc87', '', '', 0, 6),
(9, 'arifmiya', 'Arif Miya', 'arif@dmail.com', '340f3c8b71bb90d6f9ba5e92c8cc7c3fefbcce9dd5235a699e4c97cc22a75c372dd377162e35dc8480fbd23389e570e506297d5c9cb274314b7ee66d0f91f3f0', 'img/uploads/14257479_1388639087831234_3562951248865534122_o.jpg', '/home/multiinventory/public_html/img/uploads/14257479_1388639087831234_3562951248865534122_o.jpg', 0, 5);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_user_role`
--
CREATE TABLE IF NOT EXISTS `tbl_user_role` (
`user_role_id` int(11) NOT NULL AUTO_INCREMENT,
`employee_login_id` int(11) NOT NULL,
`menu_id` int(11) NOT NULL,
PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=281 ;
--
-- Dumping data for table `tbl_user_role`
--
INSERT INTO `tbl_user_role` (`user_role_id`, `employee_login_id`, `menu_id`) VALUES
(1, 9, 1),
(143, 1, 1),
(153, 6, 1),
(154, 6, 7),
(155, 6, 42),
(156, 6, 30),
(157, 6, 31),
(158, 6, 32),
(159, 6, 33),
(160, 6, 52),
(161, 6, 53),
(162, 7, 1),
(163, 7, 7),
(164, 7, 8),
(165, 7, 9),
(166, 7, 10),
(167, 7, 13),
(168, 7, 14),
(169, 7, 28),
(170, 7, 29),
(171, 7, 42),
(172, 8, 1),
(173, 8, 2),
(174, 8, 41),
(175, 8, 7),
(176, 8, 8),
(177, 8, 9),
(178, 8, 10),
(179, 8, 13),
(180, 8, 14),
(181, 8, 28),
(182, 8, 29),
(183, 8, 42),
(184, 8, 18),
(185, 8, 19),
(186, 8, 20),
(187, 8, 21),
(188, 8, 22),
(189, 8, 23),
(190, 8, 24),
(191, 8, 43),
(192, 8, 44),
(193, 8, 45),
(194, 8, 25),
(195, 8, 26),
(196, 8, 27),
(197, 8, 30),
(198, 8, 31),
(199, 8, 32),
(200, 8, 33),
(201, 8, 52),
(202, 8, 53),
(203, 8, 34),
(204, 8, 35),
(205, 8, 36),
(206, 8, 46),
(207, 8, 47),
(208, 8, 48),
(209, 8, 51),
(210, 3, 1),
(211, 3, 7),
(212, 3, 8),
(213, 3, 9),
(214, 3, 10),
(215, 3, 13),
(216, 3, 14),
(217, 3, 28),
(218, 3, 29),
(219, 3, 42),
(220, 3, 25),
(221, 3, 26),
(222, 3, 27),
(223, 3, 30),
(224, 3, 31),
(225, 3, 32),
(226, 3, 33),
(227, 3, 52),
(228, 3, 53),
(229, 3, 34),
(230, 3, 35),
(231, 3, 36),
(232, 3, 46),
(233, 3, 47),
(234, 3, 48),
(235, 3, 51),
(236, 9, 1),
(237, 9, 2),
(238, 9, 3),
(239, 9, 4),
(240, 9, 5),
(241, 9, 6),
(242, 9, 17),
(243, 9, 41),
(244, 9, 49),
(245, 9, 50),
(246, 9, 7),
(247, 9, 8),
(248, 9, 9),
(249, 9, 10),
(250, 9, 13),
(251, 9, 14),
(252, 9, 28),
(253, 9, 29),
(254, 9, 42),
(255, 9, 18),
(256, 9, 19),
(257, 9, 20),
(258, 9, 21),
(259, 9, 22),
(260, 9, 23),
(261, 9, 24),
(262, 9, 43),
(263, 9, 44),
(264, 9, 45),
(265, 9, 25),
(266, 9, 26),
(267, 9, 27),
(268, 9, 30),
(269, 9, 31),
(270, 9, 32),
(271, 9, 33),
(272, 9, 52),
(273, 9, 53),
(274, 9, 34),
(275, 9, 35),
(276, 9, 36),
(277, 9, 46),
(278, 9, 47),
(279, 9, 48),
(280, 9, 51);