-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 03, 2021 at 03:40 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 `smsconfig`
--

CREATE TABLE IF NOT EXISTS `smsconfig` (
  `id` int(30) NOT NULL,
  `username` text NOT NULL,
  `apikey` text NOT NULL,
  `from` varchar(50) NOT NULL,
  `link` text NOT NULL,
  `businessname` text NOT NULL,
  `contact` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `contactperson` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `contact2` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `currencysymbol` varchar(100) NOT NULL,
  `tax1` varchar(100) NOT NULL,
  `tax1rate` varchar(100) NOT NULL,
  `tax2` varchar(100) NOT NULL,
  `tax2rate` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `returnpolicy` text NOT NULL,
  `logo` text NOT NULL,
  `paymenttypes` text NOT NULL,
  `country` varchar(50) NOT NULL,
  `totalsms` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `display1` varchar(5) NOT NULL,
  `display2` varchar(5) NOT NULL,
  `maindiscount` varchar(10) NOT NULL DEFAULT 'no',
  `receiptdescription` varchar(5) NOT NULL DEFAULT 'yes',
  `deadline` text NOT NULL,
  `tillno` text NOT NULL,
  `invoicedetails` text NOT NULL,
  `barcode` varchar(3) NOT NULL DEFAULT 'no',
  `deadlinedetails` text NOT NULL,
  `businesskey` text NOT NULL,
  `display` varchar(30) NOT NULL,
  `fromdate` varchar(30) NOT NULL,
  `todate` varchar(30) NOT NULL,
  `starttime` varchar(30) NOT NULL,
  `duetime` varchar(30) NOT NULL,
  `view` text NOT NULL,
  `receipt` varchar(50) NOT NULL,
  `mode` varchar(30) NOT NULL,
  `feedback` text NOT NULL,
  `sendfeedback` varchar(10) NOT NULL,
  `dublicate` varchar(10) NOT NULL,
  `smscompany` varchar(30) NOT NULL DEFAULT 'Infobip',
  `newuser` varchar(30) NOT NULL,
  `newpassword` varchar(30) NOT NULL,
  `senderid` varchar(30) NOT NULL,
  `leftoverview` text NOT NULL,
  `rightoverview` text NOT NULL,
  `assetaccount` varchar(50) NOT NULL,
  `salesaccount` varchar(50) NOT NULL,
  `expenseaccount` varchar(50) NOT NULL,
  `starthappyhour` varchar(20) NOT NULL,
  `endhappyhourse` varchar(20) NOT NULL,
  `statushappyhour` varchar(20) NOT NULL,
  `salesmethod` varchar(20) NOT NULL,
  `plot` int(11) NOT NULL DEFAULT '10',
  `defautpage` varchar(255) NOT NULL DEFAULT 'user/home',
  `ecommerce` varchar(10) NOT NULL DEFAULT 'deactivate',
  `landingpage` varchar(40) NOT NULL DEFAULT 'products',
  `path` text NOT NULL,
  `shortcode` text NOT NULL,
  `confirmationurl` text NOT NULL,
  `validationurl` text NOT NULL,
  `responseType` text NOT NULL,
  `consumer_key` text NOT NULL,
  `consumer_secret` text NOT NULL,
  `signature` text,
  `kitchen` varchar(30) NOT NULL DEFAULT 'no',
  `kitchenid` int(11) DEFAULT NULL,
  `menutype` varchar(30) NOT NULL DEFAULT 'Left'
    `receiptlogo` varchar(10) NOT NULL DEFAULT 'no',
  `bankcode` varchar(20) NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `smsconfig`
--

INSERT INTO `smsconfig` (`id`, `username`, `apikey`, `from`, `link`, `businessname`, `contact`, `location`, `email`, `code`, `description`, `contactperson`, `password`, `contact2`, `address`, `currencysymbol`, `tax1`, `tax1rate`, `tax2`, `tax2rate`, `website`, `returnpolicy`, `logo`, `paymenttypes`, `country`, `totalsms`, `userid`, `updatedat`, `display1`, `display2`, `maindiscount`, `receiptdescription`, `deadline`, `tillno`, `invoicedetails`, `barcode`, `deadlinedetails`, `businesskey`, `display`, `fromdate`, `todate`, `starttime`, `duetime`, `view`, `receipt`, `mode`, `feedback`, `sendfeedback`, `dublicate`, `smscompany`, `newuser`, `newpassword`, `senderid`, `leftoverview`, `rightoverview`, `assetaccount`, `salesaccount`, `expenseaccount`, `starthappyhour`, `endhappyhourse`, `statushappyhour`, `salesmethod`, `plot`, `defautpage`, `ecommerce`, `landingpage`, `path`, `shortcode`, `confirmationurl`, `validationurl`, `responseType`, `consumer_key`, `consumer_secret`, `signature`, `kitchen`, `kitchenid`, `menutype`) VALUES
(1, '76', '0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318', 'SMSCHAPCHAP', '', '<H1 style="margin:0px;">DLIGHT LTD</H1>\r\nP.O BOX 159-50404 JUJA\r\nTELEPHONE:0738637711\r\nTILL NO::0708325411', '254738637711', 'BUMALA', 'support@robisearch.com', 'ROBISEARCHPOS', 'DIMETRICA LIMITED<br>\r\nAC NO:XXXXXXXXXXX,<br>\r\nBANK NAME:KCB BANK<br>', 'KJ WINES', 'e7bd1efe6cee0b56cf3b31d7fb5d01c7', '254708325411', '', '', 'VAT', '16', 'levy', '2', 'RO0001', '  Goods once sold will not be returned ,Prices inclusive of vat where applicable, <br>We appreciate your valuable business', '2021-05-221621710251.jpg', '1', '1 ', '', '1', '2021-06-02 17:20:06', 'yes', 'no', 'no', 'no', 'PXo99V6lt78D1/BlWPq3e2C47ZawQ2GVnTi/sl7vlW63zVEQSYfMFC4DB56Y7N5rlDNxLCGNBAH/CAavwaPHtA==', '<center><h1>PAYBILL NO:924780</h1></center>', '<B> INVOICE TERMS</B></BR>\r\n1. This invoice is payable on demand unless terms specified.<br>\r\n2. Good once sold are not returnable<br>\r\n3. Ownership of the above good will be vested in Dimetrica limited until fully paid\r\n', 'no', 'You have not paid your pending balance or you have not paid your annual maintenance fees. Kindly send the payment through our Playbill no:522522  and Acc No:117121120 for you to continue enjoying our services.', 'v9Mxk5YRIpRN2hymbPROOFjt+sIG004BKiVWEV8d/lJdxajtqj6lvAr2NVnU4DDNY2/6X/OEHfA7pGVwLML6XZIUk3UtB3oWnj/gf2XShPmcvQx857zpR+8ezyKzV8JM', '100', 'Current', 'Current', '00:00', '23:59', 'TouchOnly', 'One Without Automatic Logout', 'Before Receipt', 'thank you for shopping with us. From Robisearch LTD.', 'yes', 'yes', 'Advanta', 'ROBISEARCH', 'Robisearch@2018', 'ROBISEARCH', '<b>About Robisearch Ltd</b><br>\r\nRobisearch Ltd is an ICT youth based company that begun in 2011 as a result of innovations that transform lives globally. We are innovator behind Biometric lands system and digital birth card system that could help fight terrorisms. We are a member of the Nairobi Chambers (KNCCI) organization and AGPO. We offer attachment /internships opportunity to 60 students on annual basis as a way of creating job opportunity to youths in Kenya. We have great experience in dealing with customers having handled over 500 customers’ country wide. Some of services are:<p class="text-center">\r\n<h3>OUR SERVICES</h3>\r\nBelow are some of our services and solutions:<br>\r\n•	Biometric system for schools and business : Price= From Ksh.50,000<br>\r\n•	Bulk Sms services(Bulksms ChapChap) : Price= From Ksh.5,000<br>\r\n•	Best Erp/Point of Sale/ Inventory Control Software : Price= From Ksh.50,000<br>\r\n•	Property Management software that conforms to the Big 4 government agenda. : Price= From Ksh.100,000<br>\r\n\r\nNOTE: You can give discount upto 20% of the above selling price.\r\n</p>\r\n\r\n<p>\r\nOur Vision<br>\r\nTransforming the world through innovation<br>\r\nOur Mission<br>\r\nTo be the best ICT company offering innovate services globally.\r\nBiometric Systems rely mostly on information about a person to identify the person in such a way that specific data about unique biological traits are relied upon to work effectively.\r\nThe biometric School attendance system. This is an innovative system which is used by schools to track student movements. The system sends sms alert to the parents whenever students checks in and out of the schools. The system is also used as digital register to record students and staff attendances instead of manual signing of class register as well as managing payroll based on attendance. The system is also being used by business owners to get sms alert whenever employees checks in and out of the office. There are so many schools using this system and we recommend the same to any school and business. Some of them are JKUAT,Pumwani Hosiptal, Loreto Girls Kiambu,Mandera boys, Kwale boys, Kipsigis girls. Kericho TTC etc.\r\n<br>\r\n\r\n<br>Point of Sale(ROBIPOS) manages sales for any sales related businesses. This system helps business owners to track their daily sales and profit using their phones wherever they are. It has Lipa Na MPESA real time and sms alert. Sms is automatically sends to the computer whenever customer pays through any mobile payment. Also the customer gets automatic thank you message upon payment.\r\nThis system has been integrated with many modules that manages day to day transactions in our client’s business. The system has many functionalities but not limited to the following: Inventory tracking, sales management, customer management, products management, receipting, human resource, accounting module and can real-time Lipa na Mpesa module. \r\nThe sales management system can be used in diverse businesses like wholesales, boutiques, electrical and electronics, minimarts, supermarkets, cosmetic shops, jeweler shops and any retail businesses.\r\nOur POS system helps <br>\r\n?	Improve our customer’s experience by serving them in a fast and convenient way<br>\r\n?	Management of stock<br>\r\n?	 Presentable documents such as receipts, orders and reports are issued to customers of our clients.<br>\r\n?	Storage and retrieval of documents is made easier<br>\r\n?	Accuracy; scanning is more accurate than punching in numbers from a sticker or expecting the cashier to manually remember what each item costs.\r\n?	Analysis ;<br>\r\n?	 POS let our clients manage inventory, flag items for reorder and analyze sales patterns.<br>\r\nBulksms ChapChap is a bulk sms software which can be used to send sms/reminders to customers. It’s the most feasible and essential strategy to target a mass audience as a marketing and communication tool. Whether launching a new product or would like a nationwide announcement, or whether you want to remind people of a certain meeting or deal, our bulk sms manages all the requirements from start to finish.  The system can be used by anybody to manage their dairies since you can store all your appointments and activities then system will send you sms whenever that time reaches.  \r\nOur bulk sms comes with advantages such as;<br>\r\n?	Instant delivery of messages<br>\r\n?	 Flexible platform that can send over 10,000 sms once<br>\r\n?	The systems comes with a reminder to notify one of any pending deals<br>\r\n?	Sms can be stored, easily forwarded or tracked using delivery reports<br>\r\n?	Lower cost and time to be delivered than a phone call.<br>\r\n?	It is more reliable than emailing as the chances of the recipient reading the message is very high<br>\r\n?	Limitless market potential<br>\r\nOur clients include;Bulk sms: JKUAT, Elimu TV, Uwezo Fund, Moi forces Academy<br>\r\nBiometric: JKUAT, Orero Boys, Kayole High school<br>\r\nPoint of sale: Luna Park, Victoria Falls, Garrison Teachers College, Ndumia Group<br>\r\nwww.robisearch.com<br>\r\nhttp://www.bulksmschapchap.com/<br>\r\n\r\n\r\n</p>\r\n<p>\r\nFeel free to contact us: <br>\r\n<a href="http://www.robisearch.com/">www.robisearch.com</a> <br>\r\nEmail :info@robisearch.com<br>\r\nPhone: 0780655987<br>\r\nPhone: 0716413386<br>\r\nOur Offices are Nairobi-Nara and   Juja town<br>\r\n Experiencing any problem? Send an email to  <a href="mailto:info@robisearch.com">info@robisearch.com</a>  or <a href="mailto:robisearch@gmail.com">robisearch@gmail.com</a>  or follow  us on <a href="https://www.facebook.com/Robiearch?fref=ts">Facebook</a> or  on <a href="https://twitter.com/robisearch">Twitter.</a> . You can also view more on <a href="http://www.robisearch.com/"> our website</a>\r\n\r\n</p></b>\r\n   ', '<B> Reseller/Agent Benefits</b>\r\n	<br>\r\n1. Earn Commisiions <br>\r\n2. Get best offers <br>\r\n3. Get Incentives <br>\r\n	\r\n					<B> Reseller/Agent Categories</b>\r\n					We pay according to your effort hence it is based on commission.<br>\r\n					1. You will get 10% of what you sell on Monthly basis if you make between 1-5 sales per month.<br>\r\n					2. You will get 20% of what you sell on Monthly basis if you make between 6-20 sales per month.<br>\r\n					3. You will get 30% of what you sell on Monthly basis if you make above 21 sales per month.<br>\r\n', '1110', '4000', '5500', '06:30', '00:45', 'no', 'General', 10, 'user/home', 'activate', 'products', 'D:\\\\xampp\\\\htdocs\\\\ATT2000.mdb', '702006', 'https://pos.wifimatt.com/getpayment', 'https://pos.wifimatt.com/verifypayment', 'application/json', 'UYlkylGuzGjZxpMNz2rmGGYc6N5wslzp', 'HSGog9FsAchErCLj', 'From Robisearch LTD', 'yes', 2, 'Both');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `smsconfig`
--
ALTER TABLE `smsconfig`
  ADD PRIMARY KEY (`id`);

/*!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 */;
