-- phpMyAdmin SQL Dump -- version 3.1.3.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 06, 2016 at 06:30 AM -- Server version: 5.1.33 -- PHP Version: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 utf8 */; -- -- Database: `newlimara` -- -- -------------------------------------------------------- -- -- Table structure for table `category_table` -- CREATE TABLE IF NOT EXISTS `category_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `machine_id` int(11) NOT NULL, `category` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `category_table` -- INSERT INTO `category_table` (`id`, `machine_id`, `category`, `delet`) VALUES (1, 1, 'Brochure', 0), (2, 1, 'Notice', 0), (3, 1, 'Leter Head', 0), (4, 1, 'Flayer', 0), (5, 1, 'Form', 0), (6, 1, 'Card', 0), (7, 1, 'Poster', 0), (9, 3, 'Test', 0), (8, 2, 'Book', 0); -- -------------------------------------------------------- -- -- Table structure for table `clients` -- CREATE TABLE IF NOT EXISTS `clients` ( `client_id` int(11) NOT NULL AUTO_INCREMENT, `client_name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `clientaddress` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `place` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `zipcode` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `secphone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`client_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ; -- -- Dumping data for table `clients` -- INSERT INTO `clients` (`client_id`, `client_name`, `clientaddress`, `email`, `place`, `zipcode`, `phone`, `secphone`, `delet`) VALUES (1, 'Sudhi', 'Kalayapuram', 'asas@ymail.com', 'Kalayapuram', '691514', '09895956900', '09895956900', 1), (2, 'RINU.B', 'Kalayapuram', 'asas@ymail.com', 'Kalayapuram', '691560', '09895956900', '09895956900', 1), (3, 'TRAVANCORE MEDICITY', 'THATTAMALA', 'medi@gmail.com', 'KOLLAM', '22', '1', '1', 0), (4, 'SIRAJUL ISLAM MASJID', 'KOLLAM', 'sir@gmail.com', 'KOLLAM', '1', '1', '1', 0), (5, 'HARITHA NURSARY', 'KOLLAM', '', 'KOLLAM', '', '23434093', '23434343434', 0), (6, 'SREERANGAN C/O VIJAYAN', 'KOLLAM', '', 'KOLLAM', '', '3434343434', '343434343434', 0), (7, 'MAYYANAD KAKKOTUMOOLA CHURCH', 'MAYYANADU', '', 'MAYYANADU', '', '3434343434', '6565656565', 0), (8, 'HRUDYA PICKLES - SAJEEB', 'EDAVA - VARKALA', '', 'VARKALA', '', '34343434343', '3434343434', 0), (9, 'KERALA MUSLIM JAMAATH', 'KOLLAM', '', 'KOLLAM', '', '34343094343', '234343434', 0), (10, 'KUNNATHU KAVU TEMPLE', 'KOLLAM', '', 'KOLLAM', '', '54343434', '23434343', 0), (11, 'MUHAMMADU SHAFI', 'KOLLAM', '', 'KOLLAM', '', '34343', '343434', 0), (12, 'LEKSHMI TUTORIALS', 'KOLLAM', '', 'KOLLAM', '', '3434343', '34343', 0), (13, 'JANATHA TRADE UNION', 'KOLLAM', '', 'KOLLAM', '', '343434', '34343', 0), (14, 'MUBARAK PLYWOOD', 'KOLLAM', '', 'KOLLAM', '', '34343', '232323', 0), (15, 'OYOOR MUSLIM JAMAATH', 'OYOOR', '', 'OYOOR', '', '343434', '343434', 0), (16, 'NOWSHAD -CASH CUSTOMER', 'KOLLAM', '', 'KOLLAM', '', '234343', '234343', 0), (17, 'AYATHIL MUHIYUDDIN MASJID', 'AYATHIL', '', 'KOLLAM', '691010', '1233333', '234343434', 0), (18, 'M.A.K. VEGITABLES', 'KOLLAM', '', 'KOLLAM', '', '12344', '1232323', 0), (19, 'SYS VARKALA - SAKEER', 'VARKALA', '', 'VARKALA', '', '919747151715', '3455666', 0), (20, 'NETHAJI LIBRARY', 'KOLLAM', '', 'KOLLAM', '', '912323', '91232323', 0), (21, 'ERAVIPURAM SERVICE COOP BANK', 'ERAVIPURAM', '', 'KOLLAM', '', '93434344', '3394349343', 0), (22, 'PREM - CASH CUSTOMER', 'CHATHANNOOR', '', 'CHATHANNOOR', '', '2343434', '3434343', 0), (23, 'T.K.M COLLEGE OF ENGINEERING', 'KOLLAM', '', 'KOLLAM', '', '234343434', '34343434', 0), (24, 'NEDUMPANA VANITHA COOP SOCIETY', 'NEDUMPANA, KOLLAM', '', 'NEDUMPANA', '', '2343434', '3434343', 0), (25, 'GRACE INTERNATIONAL SCHOOL', 'VAZHAPPALLY, KOLLAM', '', 'VAZHAPPALLY ', '', '3434343', '3434343', 0), (26, 'GRACE INTERNATIONAL SCHOOL', 'VAZHAPPALLY, KOLLAM', '', 'VAZHAPPALLY ', '', '3434343', '3434343', 0), (27, 'OASIS GREEN', 'CHANTHANATHOPPE, KOLLAM2', '', 'CHANTHANATHOPPU', '', '34343434', '343434', 0), (28, 'KOLLAM ORPHANAGE AND ISLAMIYA COLLEGE', 'VAZHAPPALLY, KOLLAM', '', 'VAZHAPPALLY', '', '4742530436', '9605889611', 0), (29, 'MEDITRINA HOSPITALS', 'AYATHIL, KOLLAM2', '', 'AYATHIL', '', '3434343', '343434', 0), (30, 'THANAL MEDICALS', 'MAYYANADU', '', 'MAYYANADU', '', '3434343434', '3434343', 0), (31, 'ARASAN BEEDI', 'VENDAR JUNCTION, KOLLAM', '', 'KOLLAM', '', '3434343', '3343443', 0), (32, 'RAJAKUMARI GOLD SOUK', 'KOTTIYAM', 'raj@gmail.com', 'KOTTIYAM', '691570', '12', '1212', 0), (33, 'SUDHEER', 'KOLLAM', 'sud@gmail.com', 'kollam', '691570', '1', '1', 0), (34, 'DKLM (DAKSHINA KERALA LIJNATHUL)', 'KANNANALLOR', 'dkm@gmail.com', 'KANNANALLOR', '691572', '1', '1', 0), (35, 'VALIYA KOONAMPAYIKKULAM TEMPLE', 'PALLIMUKKU, KOLLAM', 'vad@gmail.com', 'VADAKKEVILA', '6915710', '1', '1', 0), (36, 'NIZARUDEEN R.D.M.175', 'KOLLAM', 'rat@gmail.com', 'kollam', '691570', '1', '1', 0), (37, 'S.A.FRUITS', 'PALLIMUKKU', 'sa@gmail.com', 'PALLIMUKKU', '691010', '1', '1', 0), (38, 'CASH CUSTOMER', 'PALLIMUKKU', '22@gmail.com', 'kollam', '691010', '1', '1', 0), (39, 'FOUZAN NIZAM', 'UMAYANALLORE', 'fouz@gmail.com', 'UMAYANALLORE', '691010', '1', '1', 0), (40, 'REHMANIYA', 'KOLLAM', 'reh@mail.com', 'KOLLAM', '691010', '1', '1', 0), (41, 'THEKKEVILA RESIDENTS ASSOCIATION', 'KOLLAM', 'thekke@gmail.com', 'KOLLAM', '691010', '1', '1', 0), (42, 'FMTC - FATHIMA MEMORIAL TRAINING COLLEGE', 'PALLIMUKKU', 'fmtc@gmail.com', 'PALLIMUKKU', '691010', '1', '1', 0), (43, 'RAJEEV (nethaji library)', 'KOLLAM', 'raj@gmail.com', 'KOLLAM', '691010', '1', '1', 0), (44, 'RAMANKULAM DURGA DEVI TEMPLE', 'MAYYANADU', 'ram@gmail.com', 'MAYYANADU', '691010', '1', '1', 0), (45, 'DEVI U.P.SCHOOL', 'CHATHANNOOR', 'devi@gmail.com', 'CHATHANNOOR', '691572', '1', '1', 0), (46, 'NAJEEM THOTTATHIL', 'CHATHANNOOR', 'naj@gmail.com', 'CHATHANNOOR', '691572', '1', '1', 0), (47, 'RELIANCE AGENCIES', 'CHAMAKKADA', 'rel@gmail.com', 'CHAMAKKADA', '691010', '1', '1', 0), (48, 'KPM HIGHER SECONDARY SCHOOL', 'CHERIYAVELINALLORE', 'kpm@gmail.com', 'CHERIYAVELINALLORE', '691572', '918547974343', '1', 0), (49, 'KULANGARA SREE BALABHADRA TEMPLE', 'KULANGARA', 'kul@gmail.com', 'KULANGARA', '691570', '1', '1', 0), (50, 'JAWAHAR PUBLIC SCHOOL', 'EDAVA', 'jaw@gmail.com', 'EDAVA-VARKALA', '69101', '914702662906', '1', 0), (51, 'MEENADU KIZHAKKUMKARA MADANKAVU TEMPLE', 'MEENADU', 'meen@gmail.com', 'MEENADU', '691572', '9605660776', '1', 0), (52, 'SOORYA RINGS', 'PALLIMUKKU', 'soor@gmail.com', 'PALLIMUKKU', '691010', '1', '1', 0), (53, 'ARABIAN JEWELLARY', 'CHINNAKKADA, KOLLAM', 'arab@gmail.com', 'KOLLM', '1', '1', '1', 0); -- -------------------------------------------------------- -- -- Table structure for table `company_address` -- CREATE TABLE IF NOT EXISTS `company_address` ( `id` int(50) NOT NULL AUTO_INCREMENT, `company_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `company_addrs` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `mob` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tax_heads` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tax_decleration` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tin` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cst` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `company_address` -- INSERT INTO `company_address` (`id`, `company_name`, `company_addrs`, `mob`, `email`, `tax_heads`, `tax_decleration`, `tin`, `cst`, `delet`) VALUES (1, 'New Limara', 'Pallimukku PO
Kollam - 691001, Kerala', '1234567890', 'info@newlimara.com', 'KERALA VALUE ADDED TAX RULES, 2005
FORM NO.8
[See rule 58(10)]
TAX INVOICE-Cash/Credit Bill', 'Certified that all the particulars shown in the above Tax invoice are true and correct in all respects and the goods on which the tax charged and collected are in accordance with the provisions of the K VAT ACT 2003 and the rules made thereunder. It is also certified that my/our registration under K VAT Act 2003 is not subject to any suspension/cancellation and it is valid as', '32021000649', '32021000649C', 0); -- -------------------------------------------------------- -- -- Table structure for table `copysetting` -- CREATE TABLE IF NOT EXISTS `copysetting` ( `paper_name` text NOT NULL, `papre_nickname` text NOT NULL, `size` text NOT NULL, `no_copy` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `copysetting` -- INSERT INTO `copysetting` (`paper_name`, `papre_nickname`, `size`, `no_copy`) VALUES ('demmy', 'demmy', '1', 1), ('demmy half', 'A3', '1/2', 2), ('demmy A4', 'A4', '1/4', 4), ('Demmy 1/8', '1/8', '1/8', 8); -- -------------------------------------------------------- -- -- Table structure for table `cust_tran` -- CREATE TABLE IF NOT EXISTS `cust_tran` ( `id` int(25) NOT NULL AUTO_INCREMENT, `cust_id` int(25) NOT NULL, `date` date NOT NULL, `amt` double NOT NULL, `type` text NOT NULL, `detail` text NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `cust_tran` -- INSERT INTO `cust_tran` (`id`, `cust_id`, `date`, `amt`, `type`, `detail`, `delet`) VALUES (1, 5, '2016-12-14', 200, 'Cash', 'dslkfksf', 0), (2, 11, '2016-12-02', 700, 'Cash', '', 0); -- -------------------------------------------------------- -- -- Table structure for table `cust_tran_main` -- CREATE TABLE IF NOT EXISTS `cust_tran_main` ( `id` int(11) NOT NULL AUTO_INCREMENT, `custid` int(25) NOT NULL, `estimateno` varchar(200) NOT NULL, `total_amt` double NOT NULL, `adv_amt` double NOT NULL, `date` date NOT NULL, `delet` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; -- -- Dumping data for table `cust_tran_main` -- INSERT INTO `cust_tran_main` (`id`, `custid`, `estimateno`, `total_amt`, `adv_amt`, `date`, `delet`) VALUES (2, 5, '6', 600.5, 0, '2016-12-15', 0), (3, 4, '10', 5000, 2000, '2016-12-15', 0), (4, 4, '18', 5000, 2000, '2016-12-16', 0), (5, 6, '24', 650, 0, '2016-12-16', 0), (6, 7, '25', 200, 0, '2016-12-02', 0), (7, 8, '26', 2550, 0, '2016-12-02', 0), (8, 9, '28', 3000, 0, '2016-12-02', 0), (9, 10, '32', 1000, 0, '2016-12-02', 0), (10, 11, '36', 1400.66666667, 0, '2016-12-03', 0), (11, 13, '38', 650, 0, '2016-12-03', 0), (12, 12, '40', 3500, 0, '2016-12-03', 0), (13, 14, '43', 2399.99333334, 0, '2016-12-16', 0), (14, 15, '45', 6800, 0, '2016-12-03', 0), (15, 16, '49', 1500, 0, '2016-12-03', 0), (16, 38, '50', 600, 0, '2016-12-03', 0), (17, 53, '52', 2400, 0, '2016-12-05', 0), (18, 17, '53', 4700, 0, '2016-12-05', 0), (19, 18, '54', 3100, 0, '2016-12-05', 0), (20, 8, '60', 825, 0, '2016-12-06', 0), (21, 20, '61', 1000, 0, '2016-12-06', 0), (22, 21, '63', 2500, 0, '2016-12-06', 0), (23, 22, '64', 650, 0, '2016-12-06', 0), (24, 23, '67', 7000, 0, '2016-12-06', 0); -- -------------------------------------------------------- -- -- Table structure for table `department` -- CREATE TABLE IF NOT EXISTS `department` ( `id` int(11) NOT NULL AUTO_INCREMENT, `department` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `department` -- INSERT INTO `department` (`id`, `department`, `delet`) VALUES (1, 'Printing', 0), (2, 'Billing', 1), (3, 'Design & DTP', 0), (4, 'Marketing', 0), (5, 'Binding', 0), (6, 'Admin', 0); -- -------------------------------------------------------- -- -- Table structure for table `estimatethree_temp_table` -- CREATE TABLE IF NOT EXISTS `estimatethree_temp_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer` int(11) NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `machine_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `pr_length` double NOT NULL, `pr_width` double NOT NULL, `numofcopys` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `plate` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ctp` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `binding` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofwork` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `workdescription` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `date` date NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `estimatethree_temp_table` -- -- -------------------------------------------------------- -- -- Table structure for table `estimatetwo_temp_table` -- CREATE TABLE IF NOT EXISTS `estimatetwo_temp_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer` int(11) NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `machine_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `type_one` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_two` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_three` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_four` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_five` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pr_length` double NOT NULL, `pr_width` double NOT NULL, `gsm_one` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_two` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_three` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_four` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_five` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `inkcolor` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofbooks` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofsetsperbooks` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `startingno` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofbndboard` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `binding` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stapling` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stitching` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pasting` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `prntlastcopy` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofwork` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `workdescription` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `date` date NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `estimatetwo_temp_table` -- -- -------------------------------------------------------- -- -- Table structure for table `estimate_calculate` -- CREATE TABLE IF NOT EXISTS `estimate_calculate` ( `ecal_id` int(11) NOT NULL AUTO_INCREMENT, `id` int(11) NOT NULL, `paper_print` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `plate_print` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `impression_amount` double NOT NULL, `paper_amount` double NOT NULL, `dtp_amount` double NOT NULL, PRIMARY KEY (`ecal_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `estimate_calculate` -- -- -------------------------------------------------------- -- -- Table structure for table `estimate_table` -- CREATE TABLE IF NOT EXISTS `estimate_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `estimation_no` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `customer` int(11) NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `machine_id` int(11) NOT NULL, `print_size` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `nopages` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `inkcolor` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `copies` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofbooks` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofsetsperbooks` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `startingno` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `bookno_frm` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `booknofroma` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofbndboard` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `plate` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ctp` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lamination` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `backprint` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `same_matter` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Nil', `folding` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `creasing` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `binding` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stapling` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stitching` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pasting` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `prntlastcopy` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofwork` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `workdescription` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `laminat_amount` double NOT NULL, `bckprnt_amt` double NOT NULL, `fold_amt` double NOT NULL, `creas_amt` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `advamt` double NOT NULL, `date` date NOT NULL, `dummypaper` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `printamount` double NOT NULL, `papercoast` double NOT NULL, `platecoast` double NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `trnno` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `total` double NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', `approve` int(25) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ; -- -- Dumping data for table `estimate_table` -- INSERT INTO `estimate_table` (`id`, `estimation_no`, `customer`, `product_code`, `product_name`, `machine_id`, `print_size`, `nopages`, `inkcolor`, `copies`, `numberofbooks`, `numberofsetsperbooks`, `startingno`, `bookno_frm`, `booknofroma`, `typeofbndboard`, `plate`, `ctp`, `lamination`, `backprint`, `same_matter`, `folding`, `creasing`, `binding`, `stapling`, `stitching`, `pasting`, `prntlastcopy`, `typeofwork`, `workdescription`, `amount`, `laminat_amount`, `bckprnt_amt`, `fold_amt`, `creas_amt`, `tax`, `advamt`, `date`, `dummypaper`, `printamount`, `papercoast`, `platecoast`, `permission`, `user`, `trnno`, `total`, `delet`, `approve`) VALUES (1, '2', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/4', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE 1/4', 'NABIDINAGHOSHAM NOTICE', 0, 0, 200, 0, 0, 0, 2000, '2016-12-15', '375', 1200, 562.5, 1000, '1017601481778778', 'admin', '68', 3562.5, 0, 0), (2, '3', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/4', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE 1/4', 'NABIDINAM', 0, 0, 200, 0, 0, 0, 2000, '2016-12-15', '375', 1200, 562.5, 1000, '296871481778976', 'admin', '69', 3562.5, 0, 0), (3, '4', 5, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/20', '1', 'BLACK', '1000', '0', '0', '0', '0', '', '', '', '2', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 200, 0, 0, 0, 0, '2016-12-15', '50', 600, 250, 100, '243641481779474', 'admin', '70', 950, 0, 0), (4, '5', 5, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/4', '1', '1', '150', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '150 - A4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '37.5', 300, 187.5, 50, '404631481779563', 'admin', '71', 537.5, 0, 0), (5, '6', 5, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/4', '1', 'BLACK', '150', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'CARD 150 A4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '37.5', 300, 187.5, 50, '3661481779796', 'admin', '72', 600.5, 0, 1), (6, '7', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/4', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'notice', '', 0, 0, 200, 0, 0, 0, 2000, '2016-12-15', '375', 1200, 562.5, 1000, '393061481783071', 'admin', '73', 2562.5, 0, 0), (7, '8', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/2', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'notice', '', 0, 0, 200, 0, 0, 0, 2000, '2016-12-15', '750', 1800, 1125, 1000, '174461481783412', 'admin', '74', 4725, 0, 0), (8, '9', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/2', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE', 'NABIDINAGHOSHAM NOTICE', 0, 0, 200, 0, 0, 0, 2000, '2016-12-15', '750', 1800, 1125, 1000, '109421481785263', 'admin', '75', 4925, 0, 0), (9, '10', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/2', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE', 'NABIDINAGHOSHAM', 0, 0, 200, 0, 0, 0, 2000, '2016-12-15', '750', 1800, 1125, 1000, '751071481785417', 'admin', '76', 5000, 1, 1), (10, '11', 6, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/18', '1', 'BLACK', '800', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'CARD', 'DEATH CARD', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '44.4444444445', 300, 222.222222222, 50, '460981481785532', 'admin', '77', 572.222222222, 0, 0), (11, '12', 6, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/18', '1', 'BLACK', '800', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'CARD', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '44.4444444445', 300, 222.222222222, 50, '977101481785635', 'admin', '78', 594.442222222, 0, 0), (12, '13', 6, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/18', '1', 'BLACK', '800', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'CARD', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '44.4444444445', 300, 222.222222222, 50, '168821481785707', 'admin', '79', 550.000022222, 0, 0), (13, '14', 7, 'LASER', 'LASER PRINTING CHARGES', 1, '', '', '', '', '0', '0', '0', '0', '', '', '', '
Warning: Division by zero in C:xampphtdocslivelimara lastPagesgetplate_count.php on line 273
0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '0', 0, 0, 0, '1139981481785865', 'admin', '80', 200, 0, 0), (14, '15', 5, 'LASER', 'LASER PRINTING CHARGES', 1, '1/4', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-15', '0', 0, 0, 0, '768501481785998', 'admin', '81', 200, 0, 0), (15, '16', 4, '100ART', '100ART - ART PAPER 100GSM', 3, '1/2', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE 1/4', 'NABIDINAGHOSHAM NOTICE', 0, 0, 200, 0, 0, 0, 2000, '2016-12-16', '750', 1800, 1500, 1000, '829901481862002', 'admin', '82', 5300, 0, 0), (16, '17', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/2', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE', '', 0, 0, 200, 0, 0, 0, 2000, '2016-12-16', '750', 1800, 1125, 1000, '952901481862519', 'admin', '83', 4925, 0, 0), (17, '18', 4, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 3, '1/2', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE 1/4', 'NABIDINAGHOSHAM NOTICE', 0, 0, 200, 0, 0, 0, 2000, '2016-12-16', '750', 1800, 1125, 1000, '440011481862602', 'admin', '84', 5000, 0, 1), (18, '19', 6, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/4', '1', 'BLACK', '400', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'KULI CARD 1/18 - 400-A4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '100', 300, 500, 50, '550501481863384', 'admin', '85', 850, 0, 0), (19, '20', 6, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/18', '1', 'BLACK', '800', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'KULI CARD', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '44.4444444445', 300, 222.222222222, 50, '30311481863616', 'admin', '86', 572.222222222, 0, 0), (20, '22', 6, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 1, '1/18', '1', 'BLACK', '800', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'KULI CARD', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '44.4444444445', 300, 222.222222222, 50, '458841481863748', 'admin', '88', 649.992222222, 0, 0), (21, '23', 6, 'KULI', 'KULI CARD', 1, '1/2', '1', '', '0', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'KULI CARD', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '0', 300, 0, 50, '468311481864084', 'admin', '89', 1000, 0, 0), (22, '24', 6, 'KULI', 'KULI CARD', 1, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'KULI CARD 1/18', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '0', 0, 0, 0, '975941481864133', 'admin', '90', 650, 0, 1), (23, '25', 7, 'LASER', 'LASER PRINTING CHARGES', 1, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'LASER PRINT 6NOS', 'BADGE', 0, 0, 0, 0, 0, 0, 0, '2016-12-02', '0', 0, 0, 0, '230991480654840', 'admin', '91', 200, 0, 1), (24, '26', 8, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'LASER PRINT - A3-170', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-02', '0', 0, 0, 0, '20461480655052', 'admin', '92', 2550, 0, 1), (25, '27', 9, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 2, '1/2', '1', 'BLACK', '4000', '0', '0', '0', '0', '', '', '', '1', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '6PAGE NOTICE (1/6 6PAGES)', '6PAGE NOTICE (1/6 6PAGES)', 0, 0, 200, 0, 0, 0, 0, '2016-12-02', '2000', 750, 2200, 250, '490501480655336', 'admin', '93', 3400, 0, 0), (26, '28', 9, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 2, '1/2', '1', 'BLACK', '4000', '0', '0', '0', '0', '', '', '', '1', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '2 SIDE NOTICE 1/6 6 PAGES', '', 0, 0, 200, 0, 0, 0, 0, '2016-12-02', '2000', 750, 2200, 250, '563891480655574', 'admin', '94', 3000, 0, 1), (27, '29', 10, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'STICKER 60NOS', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-02', '2000', 750, 2200, 250, '792101480655703', 'admin', '95', 4200, 0, 0), (28, '30', 10, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', 'STICKER 60NOS', 0, 0, 0, 0, 0, 0, 0, '2016-12-02', '2000', 750, 2200, 250, '613861480655790', 'admin', '96', 4200, 0, 0), (29, '31', 10, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', 'STICKER PRINTING CHARGES', 0, 0, 0, 0, 0, 0, 0, '2016-12-02', '2000', 750, 2200, 250, '198731480655857', 'admin', '97', 4200, 0, 0), (30, '32', 10, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', 'LASER STICKER', 0, 0, 0, 0, 0, 0, 0, '2016-12-02', '', 0, 0, 0, '141821480655975', 'admin', '98', 1000, 0, 1), (31, '33', 11, '7ROSEBND', '7ROS - COLOUR BOND 7KG ROSE', 1, '1/12', '1', 'BLACK', '1000', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT BOOK-1/12', 'PRIME FORMULATIONS ', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333333', 300, 91.6666666666, 50, '460631480742498', 'admin', '99', 483.333333333, 0, 0), (32, '33', 11, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/12', '1', 'BLACK', '1000', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RECEIPT BOOK-1/12', 'PRIME FORMULATIONS ', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333333', 0, 41.6666666666, 0, '460631480742498', 'admin', '99', 483.333333333, 0, 0), (33, '34', 11, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/12', '1', 'BLACK', '1000', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', '', 'PRIME FORMULATIONS', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333333', 0, 41.6666666666, 0, '292631480742866', 'admin', '100', 825.333333333, 0, 0), (34, '34', 11, '7ROSEBND', '7ROS - COLOUR BOND 7KG ROSE', 1, '1/12', '1', 'BLACK', '1000', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', 'PRIME FORMULATIONS', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333333', 300, 91.6666666666, 50, '292631480742866', 'admin', '100', 825.333333333, 0, 0), (35, '35', 11, '7ROSEBND', '7ROS - COLOUR BOND 7KG ROSE', 1, '1/6', '1', 'BLACK', '500', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333335', 300, 91.6666666669, 50, '24701480743082', 'admin', '101', 608.333333334, 0, 0), (36, '35', 11, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/6', '1', 'BLACK', '500', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333335', 0, 41.6666666668, 0, '24701480743082', 'admin', '101', 608.333333334, 0, 0), (37, '36', 11, '7ROSEBND', '7ROS - COLOUR BOND 7KG ROSE', 1, '1/6', '1', 'BLACK', '500', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333335', 300, 91.6666666669, 50, '767271480743348', 'admin', '102', 700.333333334, 0, 1), (38, '36', 11, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/6', '1', 'BLACK', '500', '10', '1,1', '101', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '83.3333333335', 0, 41.6666666668, 0, '767271480743348', 'admin', '102', 700.333333334, 0, 0), (39, '37', 13, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/4', '1', 'BLACK', '1000', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '1/4 NOTICE', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 300, 275, 50, '482581480743457', 'admin', '103', 625, 0, 0), (40, '38', 13, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/4', '1', 'BLACK', '1000', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '1/4 NOTICE', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 300, 275, 50, '647771480743721', 'admin', '104', 650, 0, 1), (41, '39', 12, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/3', '1', 'BLACK', '1500', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'ANSWER SHEET', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '500', 400, 549.999999999, 50, '1058661480744512', 'admin', '105', 999.999999999, 0, 0), (42, '40', 12, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/3', '1', 'BLACK', '1500', '0', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'ANSWER SHEET', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '500', 400, 549.999999999, 50, '972721480744590', 'admin', '106', 1750, 0, 1), (43, '40', 12, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/3', '0', 'BLACK', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'ANSWER SHEET', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '0', 0, 0, 0, '972721480744590', 'admin', '106', 1750, 0, 0), (44, '41', 14, '7GRNBND', '7GREEN - COLOUR BOND 7KG GREEN', 1, '1/12', '1', 'BLACK', '2000', '20', '1,1', '1501', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RECEIPT BOOK', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '166.666666667', 0, 183.333333333, 0, '333691480744800', 'admin', '107', 1016.66666667, 0, 0), (45, '41', 14, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/12', '1', 'BLACK', '2000', '20', '1,1', '1501', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT BOOK', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '166.666666667', 300, 183.333333333, 50, '333691480744800', 'admin', '107', 1016.66666667, 0, 0), (46, '42', 14, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/12', '1', 'BLACK', '2000', '20', '1,1', '1501', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '166.666666667', 300, 183.333333333, 50, '1120761480744916', 'admin', '108', 1116.66666667, 0, 0), (47, '42', 14, '7GRNBND', '7GREEN - COLOUR BOND 7KG GREEN', 1, '1/12', '1', 'BLACK', '2000', '20', '1,1', '1501', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '166.666666667', 100, 183.333333333, 0, '1120761480744916', 'admin', '108', 1116.66666667, 0, 0), (48, '43', 14, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/12', '1', 'BLACK', '2000', '20', '1,1', '1501', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT BOOK', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '166.666666667', 300, 183.333333333, 50, '105451481869814', 'admin', '109', 1199.99666667, 0, 1), (49, '43', 14, '7GRNBND', '7GREEN - COLOUR BOND 7KG GREEN', 1, '1/12', '1', 'BLACK', '2000', '20', '1,1', '1501', '1', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT BOOK', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '166.666666667', 100, 183.333333333, 0, '105451481869814', 'admin', '109', 1199.99666667, 0, 0), (50, '44', 15, '130ART', '130ART - ART PAPER 130GSM', 3, '1/2', '1', '', '2000', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'NOTICE 1/2 2 SIDE', '', 0, 0, 200, 0, 0, 0, 0, '2016-12-03', '1000', 1800, 2500, 1000, '882561480746853', 'admin', '110', 6300, 0, 0), (51, '45', 15, '130ART', '130ART - ART PAPER 130GSM', 3, '1/2', '1', '', '2000', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'DY 1/2 NOTICE 2 SIDE', '', 0, 0, 200, 0, 0, 0, 0, '2016-12-03', '1000', 1800, 2500, 1000, '953011480746988', 'admin', '111', 6800, 0, 1), (52, '46', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '2000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '500', 0, 250, 0, '349191480747079', 'admin', '112', 1250, 0, 0), (53, '46', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '2000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '500', 400, 250, 50, '349191480747079', 'admin', '112', 1250, 0, 0), (54, '47', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '1000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RATION BILL A4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 0, 125, 0, '577571480747360', 'admin', '113', 900, 0, 0), (55, '47', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '1000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RATION BILL A4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 300, 125, 50, '577571480747360', 'admin', '113', 900, 0, 0), (56, '48', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '1000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RATION BILL 1/4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 0, 125, 0, '31011480747449', 'admin', '114', 800, 0, 0), (57, '48', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '1000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RATION BILL 1/4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 300, 125, 50, '31011480747449', 'admin', '114', 800, 0, 0), (58, '49', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '1000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RATION BILL 1/4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 0, 125, 0, '1133491480747581', 'admin', '115', 750, 0, 1), (59, '49', 16, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/4', '1', 'BLACK', '1000', '10', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RATION BILL 1/4', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 300, 125, 50, '1133491480747581', 'admin', '115', 750, 0, 0), (60, '50', 38, 'WED', 'WED.CARD', 1, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'WED VIS', 'WED.CARD VISITING CARD - SHEMEER', 0, 0, 0, 0, 0, 0, 0, '2016-12-03', '0', 0, 0, 0, '253991480747679', 'admin', '116', 600, 0, 1), (61, '51', 53, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/8', '1', 'BLACK', '2000', '20', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'BILL BOOK 1/8 13.7 SEMI', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-05', '250', 0, 125, 0, '968401480920645', 'admin', '117', 1000, 0, 0), (62, '51', 53, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/8', '1', 'BLACK', '2000', '20', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'BILL BOOK 1/8 13.7 SEMI', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-05', '250', 300, 275, 50, '968401480920645', 'admin', '117', 1000, 0, 0), (63, '52', 53, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/8', '1', 'BLACK', '2000', '20', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'ORDER FORM', 'ORDER FORM 1/8 13.7 AND SEMI', 0, 0, 0, 0, 0, 0, 0, '2016-12-05', '250', 300, 275, 50, '913741480920773', 'admin', '118', 1200, 0, 1), (64, '52', 53, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 1, '1/8', '1', 'BLACK', '2000', '20', '0', '0', '0', '', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'ORDER FORM', 'ORDER FORM 1/8 13.7 AND SEMI', 0, 0, 0, 0, 0, 0, 0, '2016-12-05', '250', 0, 125, 0, '913741480920773', 'admin', '118', 1200, 0, 0), (65, '53', 17, '300CRD', '300CRD - ART CARD 300GSM', 3, '1/4', '1', '', '1000', '0', '0', '0', '0', '', '', '', '4', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', 'NOORUL HUDA MADRASA CERTIF.', 0, 0, 0, 0, 0, 0, 0, '2016-12-05', '250', 1200, 1500, 1000, '226321480920905', 'admin', '119', 4700, 0, 1), (66, '54', 18, 'VCARD', 'VISITING CARD', 1, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', 'PLAIN BOOK-100, VISI CRD-2000', 0, 0, 0, 0, 0, 0, 0, '2016-12-05', '0', 0, 0, 0, '84381480921030', 'admin', '120', 3100, 0, 1), (67, '55', 19, '186MAP', '186MAP - MAP LITHO TNPL 18.60 KG 91X58.50', 3, '1/4', '1', '', '3000', '0', '0', '0', '0', '', '', '', '4', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '1/4 NOTICE 18.6 4 COL', 'DY POSTER 100GSM ART', 0, 0, 200, 0, 0, 0, 0, '2016-12-16', '750', 1800, 1050, 1000, '675751481861392', 'admin', '127', 10350, 0, 0), (68, '55', 19, '100ART', '100ART - ART PAPER 100GSM', 3, '1/1', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'DY POSTER 100GSM ART', 'DY POSTER 100GSM ART', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '1500', 1500, 3000, 1000, '675751481861392', 'admin', '127', 10350, 0, 0), (69, '56', 19, '100ART', '100ART - ART PAPER 100GSM', 3, '1/1', '1', '', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-16', '1500', 1500, 3000, 1000, '16111481862111', 'admin', '128', 6500, 0, 0), (70, '57', 19, '100ART', '100ART - ART PAPER 100GSM', 2, '1/1', '1', '1,2,3,4', '1500', '0', '0', '0', '0', '', '', '', '4', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-17', '1500', 1500, 3000, 1000, '10041481949601', 'admin', '129', 6500, 0, 0), (71, '58', 8, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '1500', 1500, 3000, 1000, '631881480999367', 'admin', '130', 6325, 0, 0), (72, '59', 8, 'LASER', 'LASER PRINTING CHARGES', 8, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '1500', 1500, 3000, 1000, '116601480999432', 'admin', '131', 6325, 0, 0), (73, '60', 8, 'LASER', 'LASER PRINTING CHARGES', 1, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '0', 0, 0, 0, '510661480999551', 'admin', '132', 825, 0, 1), (74, '61', 20, '16MAP', '16MAP - MAP LITHO PAPER 16KG', 1, '1/4', '1', 'BLACK', '1000', '0', '0', '0', '0', '', '', '', '2', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '1/4 NOTICE 2 SIDE', 'NELLIKKODU BHASKARAN ANUSMARANAM', 0, 0, 200, 0, 0, 0, 0, '2016-12-06', '250', 600, 300, 100, '522311480999649', 'admin', '133', 1000, 0, 1), (75, '62', 21, '186MAP', '186MAP - MAP LITHO TNPL 18.60 KG 91X58.50', 2, '1/8', '10', 'BLACK', '300', '0', '0', '0', '0', '', '', '', '3', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'BALANCE SHEET 1/8', 'BLANCE SHEET 1/8 300', 0, 0, 200, 0, 0, 0, 0, '2016-12-06', '375', 900, 525, 750, '1140611480999766', 'admin', '134', 2475, 0, 0), (76, '63', 21, '186MAP', '186MAP - MAP LITHO TNPL 18.60 KG 91X58.50', 2, '1/8', '10', 'BLACK', '300', '0', '0', '0', '0', '', '', '', '3', 'No', 'Yes', 'No', 'No', 'No', 'Normal', 'Center', 'No', 'No', 'No', 'BALANCE SHEET', 'BALANCE SHEET 1/8 300 BOOK', 0, 0, 200, 0, 0, 0, 0, '2016-12-06', '375', 900, 525, 750, '199501480999931', 'admin', '135', 2500, 0, 1), (77, '64', 22, 'WED', 'WED.CARD', 1, '1/2', '0', '', '0', '0', '0', '0', '0', '', '', '', '0', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '0', 0, 0, 0, '470591481000258', 'admin', '136', 650, 0, 1), (78, '65', 23, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/5', '1', 'BLACK', '2000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT 1/5', 'RECEIPT BOOK A - 20, B-20 1/5 SIZE', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '400', 400, 440, 50, '201851481000600', 'admin', '137', 2680, 0, 0), (79, '65', 23, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6 45.5x58.50', 1, '1/5', '1', 'BLACK', '2000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RECEIPT 1/5', 'RECEIPT BOOK A - 20, B-20 1/5 SIZE', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '400', 0, 200, 0, '201851481000600', 'admin', '137', 2680, 0, 0), (80, '65', 23, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6 45.5x58.50', 1, '1/5', '1', 'BLACK', '2000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RECEIPT 1/5', 'RECEIPT BOOK A - 20, B-20 1/5 SIZE', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '400', 0, 200, 0, '201851481000600', 'admin', '137', 2680, 0, 0), (81, '65', 23, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/5', '1', 'BLACK', '2000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT 1/5', 'RECEIPT BOOK A - 20, B-20 1/5 SIZE', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '400', 400, 440, 50, '201851481000600', 'admin', '137', 2680, 0, 0), (82, '66', 23, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6 45.5x58.50', 2, '1/5', '1', 'BLACK', '4000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RECEIPT 1/5', 'RECEIPT 1/5 A-20, B-20 TOTAL 40BOOK', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '800', 300, 400, 250, '385761481001029', 'admin', '138', 2880, 0, 0), (83, '66', 23, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 2, '1/5', '1', 'BLACK', '4000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT 1/5', 'RECEIPT 1/5 A-20, B-20 TOTAL 40BOOK', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '800', 300, 880, 250, '385761481001029', 'admin', '138', 2880, 0, 0), (84, '67', 23, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 2, '1/5', '1', 'BLACK', '4000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', 'RECEIPT 1/5', 'RECEIPT BOOK A-20, B-20 TOTAL 40, 1/5', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '800', 300, 880, 250, '679011481001613', 'admin', '139', 3500, 0, 1), (85, '67', 23, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6 45.5x58.50', 2, '1/5', '1', 'BLACK', '4000', '40', '1,1', '3001', '1', '', 'NORMAL', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'Yes', 'RECEIPT 1/5', 'RECEIPT BOOK A-20, B-20 TOTAL 40, 1/5', 0, 0, 0, 0, 0, 0, 0, '2016-12-06', '800', 300, 400, 250, '679011481001613', 'admin', '139', 3500, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `estimate_table_three` -- CREATE TABLE IF NOT EXISTS `estimate_table_three` ( `id` int(11) NOT NULL AUTO_INCREMENT, `estimation_no` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `customer` int(11) NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `machine_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `pr_length` double NOT NULL, `pr_width` double NOT NULL, `numofcopys` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `plate` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ctp` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `binding` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofwork` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `workdescription` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `advance` double NOT NULL, `date` date NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `trnno` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `estimate_table_three` -- INSERT INTO `estimate_table_three` (`id`, `estimation_no`, `customer`, `product_code`, `product_name`, `machine_id`, `category_id`, `pr_length`, `pr_width`, `numofcopys`, `plate`, `ctp`, `binding`, `typeofwork`, `workdescription`, `amount`, `tax`, `advance`, `date`, `status`, `trnno`, `permission`, `user`, `delet`) VALUES (1, '24', 1, '', '', 1, 1, 1213, 23, '21', '12', '13', 'Normal', 'test', 'test', 201, 5, 100, '2016-02-03', 0, '24', '59812', 'admin', 0), (2, '24', 1, '', '', 1, 1, 1213, 23, '21', '12', '13', 'Normal', 'test', 'test', 201, 5, 100, '2016-02-03', 0, '24', '59812', 'admin', 0), (3, '25', 1, '', '', 1, 6, 24, 45, '13', '2', 'ctp', 'Normal', 'sdfgh', '\\sfvdgfbbagf', 20, 0, 590, '2016-02-15', 1, '31', '71850', 'admin', 0); -- -------------------------------------------------------- -- -- Table structure for table `estimate_table_two` -- CREATE TABLE IF NOT EXISTS `estimate_table_two` ( `id` int(11) NOT NULL AUTO_INCREMENT, `estimation_no` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `customer` int(11) NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `machine_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `type_one` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_two` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_three` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_four` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type_five` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pr_length` double NOT NULL, `pr_width` double NOT NULL, `gsm_one` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_two` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_three` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_four` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm_five` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `inkcolor` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofbooks` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofsetsperbooks` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `startingno` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofbndboard` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `binding` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stapling` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stitching` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pasting` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `prntlastcopy` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofwork` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `workdescription` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `advance` double NOT NULL, `date` date NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `trnno` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `estimate_table_two` -- INSERT INTO `estimate_table_two` (`id`, `estimation_no`, `customer`, `product_code`, `product_name`, `machine_id`, `category_id`, `type_one`, `type_two`, `type_three`, `type_four`, `type_five`, `pr_length`, `pr_width`, `gsm_one`, `gsm_two`, `gsm_three`, `gsm_four`, `gsm_five`, `inkcolor`, `numberofbooks`, `numberofsetsperbooks`, `startingno`, `typeofbndboard`, `binding`, `stapling`, `stitching`, `pasting`, `prntlastcopy`, `typeofwork`, `workdescription`, `amount`, `tax`, `advance`, `date`, `status`, `trnno`, `permission`, `user`, `delet`) VALUES (1, '23', 1, '', '', 1, 1, '2', '5', '6', '7', '0', 23, 16, '9', '7', '4', '3', '0', 'Black', '5', '5', 'LM122', 'Thin', 'Normal', 'Side', 'Yes', 'No', 'Yes', 'Test 4', 'Test 4', 201, 5, 100, '2016-02-03', 1, '23', '20637', 'admin', 0), (2, '23', 1, '', '', 1, 1, '2', '5', '6', '7', '0', 23, 16, '9', '7', '4', '3', '0', 'Blue', '5', '5', 'LM123', 'Thick', 'Normal', 'Side', 'Yes', 'No', 'Yes', 'Test 3', 'Test 3', 201, 5, 100, '2016-02-03', 1, '23', '20637', 'admin', 0); -- -------------------------------------------------------- -- -- Table structure for table `estimate_temp_table` -- CREATE TABLE IF NOT EXISTS `estimate_temp_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer` int(11) NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `machine_id` int(11) NOT NULL, `print_size` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `nopages` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `inkcolor` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `copies` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofbooks` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `numberofsetsperbooks` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `startingno` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `bookno_frm` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofbndboard` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `plate` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ctp` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lamination` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `backprint` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `same_matter` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Nil', `folding` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `creasing` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `binding` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stapling` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stitching` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pasting` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `prntlastcopy` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `typeofwork` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `workdescription` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `laminat_amount` double NOT NULL, `bckprnt_amt` double NOT NULL, `fold_amt` double NOT NULL, `creas_amt` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `date` date NOT NULL, `dummypaper` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `printamount` double NOT NULL, `papercoast` double NOT NULL, `platecoast` double NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ; -- -- Dumping data for table `estimate_temp_table` -- INSERT INTO `estimate_temp_table` (`id`, `customer`, `product_code`, `product_name`, `machine_id`, `print_size`, `nopages`, `inkcolor`, `copies`, `numberofbooks`, `numberofsetsperbooks`, `startingno`, `bookno_frm`, `typeofbndboard`, `plate`, `ctp`, `lamination`, `backprint`, `same_matter`, `folding`, `creasing`, `binding`, `stapling`, `stitching`, `pasting`, `prntlastcopy`, `typeofwork`, `workdescription`, `amount`, `laminat_amount`, `bckprnt_amt`, `fold_amt`, `creas_amt`, `tax`, `date`, `dummypaper`, `printamount`, `papercoast`, `platecoast`, `permission`, `user`, `delet`) VALUES (28, 14, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 1, '1/4', '1', 'BLACK', '1000', '20', '1,1', '1501', '1', '', '', '1', 'No', 'No', 'Nil', 'No', 'No', 'Normal', 'Side', 'No', 'No', 'No', '', '', 0, 0, 0, 0, 0, 0, '2016-12-03', '250', 300, 275, 50, '852161480745149', 'admin', 0); -- -------------------------------------------------------- -- -- Table structure for table `estimation_no` -- CREATE TABLE IF NOT EXISTS `estimation_no` ( `id` int(11) NOT NULL AUTO_INCREMENT, `estimateno` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `estimation_no` -- INSERT INTO `estimation_no` (`id`, `estimateno`) VALUES (1, 68); -- -------------------------------------------------------- -- -- Table structure for table `expence` -- CREATE TABLE IF NOT EXISTS `expence` ( `id` int(25) NOT NULL AUTO_INCREMENT, `exp_for` text NOT NULL, `amount` int(25) NOT NULL, `exp_details` text NOT NULL, `exp_date` date NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ; -- -- Dumping data for table `expence` -- INSERT INTO `expence` (`id`, `exp_for`, `amount`, `exp_details`, `exp_date`, `delet`) VALUES (2, 'Rent', 7000, 'RENT - PRESS\r\n', '2016-12-01', 0), (3, 'Rent', 2500, 'RENT OFFICE', '2016-12-01', 0), (4, 'Rent', 15000, 'RENT CHR', '2016-12-01', 0), (5, 'Work Outsourced', 2383, 'LASER PRINTING', '2016-12-01', 0), (6, 'Maintenance', 300, 'KEROSENE PURCHASE', '2016-12-02', 0), (7, 'Maintenance', 125, 'ELECTRICAL MAINTENANCE', '2016-12-02', 0), (8, 'Vehicle', 500, 'PETROL FOR CAR', '2016-12-02', 0), (9, 'Work Outsourced', 950, 'LASER PRINTING & SCREEN PRINTI\r\n', '2016-12-03', 0), (10, 'Maintenance', 1500, 'DRUM FOR LASER PRINTER\r\n', '2016-12-03', 0), (11, 'Maintenance', 150, 'BLADE GRINDING\r\n', '2016-12-03', 0), (12, 'Work Outsourced', 2000, 'BINDING CHARGE (CALENDAR CHILL)\r\n', '2016-12-05', 0), (13, 'Vehicle', 500, 'PETROL FOR CAR', '2016-12-05', 0), (14, 'Work Outsourced', 455, 'LASER PRINTING', '2016-12-06', 0), (15, 'Work Outsourced', 4300, 'BINDING - CALENDAR CHILL', '2016-12-07', 0), (16, 'Vehicle', 500, 'PETROL FOR CAR', '2016-12-07', 0), (17, 'Work Outsourced', 210, 'LASER PRINTING\r\n', '2016-12-08', 0), (18, 'Maintenance', 65, 'PURCHASE OF BRUSH AND GUM', '2016-12-08', 0), (19, 'Electricity', 1048, 'KSEB BILL - CHR', '2016-12-08', 0), (20, 'Work Outsourced', 260, 'LASER PRINTING (HRUDYA)\r\n', '2016-12-10', 0), (21, 'Work Outsourced', 364, 'LASER PRINTING (NAJEEM)\r\n', '2016-12-10', 0), (22, 'Vehicle', 500, 'PETROL FOR CAR', '2016-12-10', 0), (23, 'Work Outsourced', 1050, 'LAMINATION CHARGES - SUJILEE', '2016-12-10', 0), (24, 'Maintenance', 3550, 'SHINOHARA SERVICE AND PARTS', '2016-12-10', 0), (25, 'Maintenance', 120, 'PURCHASE OF THINNER', '2016-12-13', 0), (26, 'Office exp', 110, 'PURCHASE OF PACKING MATERIAL-TWINE', '2016-12-13', 0), (27, 'Work Outsourced', 2250, 'BINDING CHARGE - CALENDAR', '2016-12-13', 0), (28, 'Maintenance', 150, 'BLADE GRINDING', '2016-12-13', 0), (29, 'Vehicle', 500, 'PETROL FOR CAR', '2016-12-14', 0), (30, 'Office exp', 2000, 'TONER FOR PRINTER', '2016-12-14', 0), (31, 'Vehicle', 500, 'PETROL FOR CAR', '2016-12-15', 0), (32, 'Maintenance', 2200, 'HP PRINTER REPAIR', '2016-12-16', 0), (33, 'Electricity', 6196, 'KSEB - PRESS', '2016-12-16', 0), (34, 'Electricity', 3694, 'KSEB OFFICE', '2016-12-16', 0), (35, 'Work Outsourced', 170, 'LASER PRINTING CHARGE', '2016-12-16', 0); -- -------------------------------------------------------- -- -- Table structure for table `ink_transfer` -- CREATE TABLE IF NOT EXISTS `ink_transfer` ( `id` int(25) NOT NULL AUTO_INCREMENT, `product_code` varchar(200) NOT NULL, `quantity` double NOT NULL, `date` date NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `ink_transfer` -- INSERT INTO `ink_transfer` (`id`, `product_code`, `quantity`, `date`, `delet`) VALUES (1, 'INK112', 10, '2016-12-07', 0), (2, 'INK112', 10, '2016-12-07', 0), (3, '56PNK', 10, '2016-12-12', 0), (4, '56PNK', 90, '2016-12-13', 0); -- -------------------------------------------------------- -- -- Table structure for table `login_details` -- CREATE TABLE IF NOT EXISTS `login_details` ( `id` int(50) NOT NULL AUTO_INCREMENT, `staff_username` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staff_id` int(50) NOT NULL, `purpose` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `time` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `date` date NOT NULL, `delet` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=260 ; -- -- Dumping data for table `login_details` -- INSERT INTO `login_details` (`id`, `staff_username`, `staff_id`, `purpose`, `time`, `date`, `delet`) VALUES (1, 'admin', 1, 'Logout', '03:26:34:PM', '2016-01-15', 0), (2, 'admin', 1, 'Login', '03:26:43:PM', '2016-01-15', 0), (3, 'admin', 1, 'Logout', '03:26:50:PM', '2016-01-15', 0), (4, 'admin', 1, 'Login', '03:45:00:PM', '2016-01-15', 0), (5, 'admin', 1, 'Login', '03:45:02:PM', '2016-01-15', 0), (6, 'admin', 1, 'Login', '03:45:03:PM', '2016-01-15', 0), (7, 'admin', 1, 'Login', '03:45:03:PM', '2016-01-15', 0), (8, 'admin', 1, 'Login', '03:45:03:PM', '2016-01-15', 0), (9, 'admin', 1, 'Login', '03:45:04:PM', '2016-01-15', 0), (10, 'admin', 1, 'Login', '03:45:04:PM', '2016-01-15', 0), (11, 'admin', 1, 'Login', '03:45:05:PM', '2016-01-15', 0), (12, 'admin', 1, 'Login', '03:45:05:PM', '2016-01-15', 0), (13, 'admin', 1, 'Login', '03:45:05:PM', '2016-01-15', 0), (14, 'admin', 1, 'Login', '03:45:05:PM', '2016-01-15', 0), (15, 'admin', 1, 'Login', '03:45:06:PM', '2016-01-15', 0), (16, 'admin', 1, 'Login', '03:45:06:PM', '2016-01-15', 0), (17, 'admin', 1, 'Login', '03:45:06:PM', '2016-01-15', 0), (18, 'admin', 1, 'Login', '03:45:06:PM', '2016-01-15', 0), (19, 'admin', 1, 'Login', '03:45:06:PM', '2016-01-15', 0), (20, 'admin', 1, 'Login', '03:45:06:PM', '2016-01-15', 0), (21, 'admin', 1, 'Login', '03:45:07:PM', '2016-01-15', 0), (22, 'admin', 1, 'Login', '03:45:07:PM', '2016-01-15', 0), (23, 'admin', 1, 'Login', '03:45:07:PM', '2016-01-15', 0), (24, 'admin', 1, 'Login', '03:45:07:PM', '2016-01-15', 0), (25, 'admin', 1, 'Login', '03:45:08:PM', '2016-01-15', 0), (26, 'admin', 1, 'Login', '03:45:08:PM', '2016-01-15', 0), (27, 'admin', 1, 'Login', '03:45:08:PM', '2016-01-15', 0), (28, 'admin', 1, 'Login', '03:45:08:PM', '2016-01-15', 0), (29, 'admin', 1, 'Login', '03:45:08:PM', '2016-01-15', 0), (30, 'admin', 1, 'Login', '03:45:08:PM', '2016-01-15', 0), (31, 'admin', 1, 'Login', '03:45:09:PM', '2016-01-15', 0), (32, 'admin', 1, 'Logout', '03:45:11:PM', '2016-01-15', 0), (33, 'admin', 1, 'Login', '03:45:19:PM', '2016-01-15', 0), (34, 'admin', 1, 'Logout', '03:46:10:PM', '2016-01-15', 0), (35, 'admin', 1, 'Login', '03:46:17:PM', '2016-01-15', 0), (36, 'admin', 1, 'Logout', '03:46:25:PM', '2016-01-15', 0), (37, 'admin', 1, 'Login', '03:46:49:PM', '2016-01-15', 0), (38, 'admin', 1, 'Logout', '03:47:53:PM', '2016-01-15', 0), (39, 'admin', 1, 'Login', '03:48:02:PM', '2016-01-15', 0), (40, 'admin', 1, 'Login', '03:48:08:PM', '2016-01-15', 0), (41, 'admin', 1, 'Login', '03:48:09:PM', '2016-01-15', 0), (42, 'admin', 1, 'Login', '03:48:09:PM', '2016-01-15', 0), (43, 'admin', 1, 'Login', '03:48:09:PM', '2016-01-15', 0), (44, 'admin', 1, 'Login', '03:48:09:PM', '2016-01-15', 0), (45, 'admin', 1, 'Logout', '03:48:12:PM', '2016-01-15', 0), (46, 'admin', 1, 'Login', '03:48:36:PM', '2016-01-15', 0), (47, 'admin', 1, 'Logout', '03:48:40:PM', '2016-01-15', 0), (48, 'admin', 1, 'Login', '03:50:46:PM', '2016-01-15', 0), (49, 'admin', 1, 'Logout', '03:51:59:PM', '2016-01-15', 0), (50, 'admin', 1, 'Login', '03:52:05:PM', '2016-01-15', 0), (51, 'admin', 1, 'Logout', '03:52:09:PM', '2016-01-15', 0), (52, 'admin', 1, 'Login', '03:55:53:PM', '2016-01-15', 0), (53, 'admin', 1, 'Login', '03:55:57:PM', '2016-01-15', 0), (54, 'admin', 1, 'Login', '03:55:58:PM', '2016-01-15', 0), (55, 'admin', 1, 'Login', '03:55:59:PM', '2016-01-15', 0), (56, 'admin', 1, 'Login', '03:55:59:PM', '2016-01-15', 0), (57, 'admin', 1, 'Login', '03:55:59:PM', '2016-01-15', 0), (58, 'admin', 1, 'Login', '03:55:59:PM', '2016-01-15', 0), (59, 'admin', 1, 'Login', '03:55:59:PM', '2016-01-15', 0), (60, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (61, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (62, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (63, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (64, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (65, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (66, 'admin', 1, 'Login', '03:56:00:PM', '2016-01-15', 0), (67, 'admin', 1, 'Login', '03:56:01:PM', '2016-01-15', 0), (68, 'admin', 1, 'Login', '03:56:01:PM', '2016-01-15', 0), (69, 'admin', 1, 'Login', '03:56:02:PM', '2016-01-15', 0), (70, 'admin', 1, 'Login', '03:56:02:PM', '2016-01-15', 0), (71, 'admin', 1, 'Login', '03:56:02:PM', '2016-01-15', 0), (72, 'admin', 1, 'Login', '03:56:02:PM', '2016-01-15', 0), (73, 'admin', 1, 'Login', '03:56:03:PM', '2016-01-15', 0), (74, 'admin', 1, 'Login', '03:56:03:PM', '2016-01-15', 0), (75, 'admin', 1, 'Login', '03:56:03:PM', '2016-01-15', 0), (76, 'admin', 1, 'Login', '03:56:04:PM', '2016-01-15', 0), (77, 'admin', 1, 'Logout', '03:56:07:PM', '2016-01-15', 0), (78, 'admin', 1, 'Login', '03:56:16:PM', '2016-01-15', 0), (79, 'admin', 1, 'Logout', '03:57:15:PM', '2016-01-15', 0), (80, 'admin', 1, 'Login', '03:57:21:PM', '2016-01-15', 0), (81, 'admin', 1, 'Logout', '03:57:25:PM', '2016-01-15', 0), (82, 'admin', 1, 'Login', '03:58:13:PM', '2016-01-15', 0), (83, 'admin', 1, 'Logout', '04:00:45:PM', '2016-01-15', 0), (84, 'admin', 1, 'Login', '04:00:57:PM', '2016-01-15', 0), (85, 'admin', 1, 'Logout', '04:45:07:PM', '2016-01-15', 0), (86, 'admin', 1, 'Login', '04:45:15:PM', '2016-01-15', 0), (87, 'admin', 1, 'Logout', '05:01:21:PM', '2016-01-15', 0), (88, 'admin', 1, 'Login', '05:01:29:PM', '2016-01-15', 0), (89, 'admin', 1, 'Login', '05:01:53:PM', '2016-01-15', 0), (90, 'admin', 1, 'Logout', '10:23:06:AM', '2016-01-16', 0), (91, 'admin', 1, 'Login', '10:30:41:AM', '2016-01-16', 0), (92, 'admin', 1, 'Login', '10:36:41:AM', '2016-01-16', 0), (93, 'admin', 1, 'Logout', '10:37:01:AM', '2016-01-16', 0), (94, 'admin', 1, 'Login', '10:37:25:AM', '2016-01-16', 0), (95, 'admin', 1, 'Logout', '10:37:32:AM', '2016-01-16', 0), (96, 'admin', 1, 'Login', '03:50:40:PM', '2016-01-18', 0), (97, 'admin', 1, 'Logout', '03:50:45:PM', '2016-01-18', 0), (98, 'admin', 1, 'Login', '03:50:52:PM', '2016-01-18', 0), (99, 'admin', 1, 'Logout', '03:50:58:PM', '2016-01-18', 0), (100, 'admin', 1, 'Login', '03:52:36:PM', '2016-01-18', 0), (101, 'admin', 1, 'Logout', '03:52:39:PM', '2016-01-18', 0), (102, 'admin', 1, 'Login', '03:52:46:PM', '2016-01-18', 0), (103, 'admin', 1, 'Login', '01:08:34:PM', '2016-01-19', 0), (104, 'admin', 1, 'Login', '01:09:18:PM', '2016-01-19', 0), (105, 'admin', 1, 'Logout', '03:23:20:PM', '2016-01-20', 0), (106, 'admin', 1, 'Login', '03:27:40:PM', '2016-01-20', 0), (107, 'admin', 1, 'Login', '03:50:22:PM', '2016-01-27', 0), (108, 'admin', 1, 'Login', '10:44:28:AM', '2016-02-05', 0), (109, 'admin', 1, 'Login', '10:44:47:AM', '2016-02-05', 0), (110, 'admin', 1, 'Login', '10:17:50:AM', '2016-02-06', 0), (111, 'admin', 1, 'Login', '10:18:01:AM', '2016-02-06', 0), (112, 'admin', 1, 'Login', '10:21:37:AM', '2016-02-08', 0), (113, 'admin', 1, 'Login', '10:21:50:AM', '2016-02-08', 0), (114, 'admin', 1, 'Login', '10:14:34:AM', '2016-02-09', 0), (115, 'admin', 1, 'Login', '11:24:53:AM', '2016-02-09', 0), (116, 'admin', 1, 'Login', '04:05:56:PM', '2016-02-09', 0), (117, 'admin', 1, 'Login', '04:06:02:PM', '2016-02-09', 0), (118, 'admin', 1, 'Login', '10:17:14:AM', '2016-02-10', 0), (119, 'admin', 1, 'Login', '02:33:30:PM', '2016-02-10', 0), (120, 'admin', 1, 'Login', '02:33:35:PM', '2016-02-10', 0), (121, 'admin', 1, 'Login', '10:48:33:AM', '2016-02-15', 0), (122, 'admin', 1, 'Login', '10:44:20:AM', '2016-02-19', 0), (123, 'admin', 1, 'Login', '10:12:00:AM', '2016-02-22', 0), (124, 'admin', 1, 'Login', '10:09:03:AM', '2016-02-24', 0), (125, 'admin', 1, 'Login', '11:41:10:AM', '2016-02-25', 0), (126, 'admin', 1, 'Login', '03:58:17:PM', '2016-02-26', 0), (127, 'admin', 1, 'Login', '09:58:33:AM', '2016-03-04', 0), (128, 'admin', 1, 'Login', '10:43:15:AM', '2016-03-04', 0), (129, 'admin', 1, 'Login', '12:47:10:PM', '2016-03-05', 0), (130, 'admin', 1, 'Login', '10:46:03:AM', '2016-04-04', 0), (131, 'admin', 1, 'Login', '11:48:42:AM', '2016-04-05', 0), (132, 'admin', 1, 'Login', '11:13:47:AM', '2016-04-11', 0), (133, 'admin', 1, 'Logout', '12:11:18:PM', '2016-04-18', 0), (134, 'admin', 1, 'Login', '12:11:33:PM', '2016-04-18', 0), (135, 'admin', 1, 'Logout', '12:14:04:PM', '2016-04-18', 0), (136, 'admin', 1, 'Login', '12:14:11:PM', '2016-04-18', 0), (137, 'admin', 1, 'Logout', '04:55:53:PM', '2016-04-18', 0), (138, 'admin', 1, 'Login', '04:55:59:PM', '2016-04-18', 0), (139, 'admin', 1, 'Login', '10:17:24:AM', '2016-04-28', 0), (140, 'admin', 1, 'Login', '10:13:18:AM', '2016-05-27', 0), (141, 'admin', 1, 'Login', '11:07:51:AM', '2016-06-14', 0), (142, 'admin', 1, 'Login', '11:16:26:AM', '2016-06-14', 0), (143, 'admin', 1, 'Login', '10:36:54:AM', '2016-06-15', 0), (144, 'admin', 1, 'Login', '10:36:54:AM', '2016-06-15', 0), (145, 'admin', 1, 'Logout', '11:21:02:AM', '2016-06-15', 0), (146, '', 0, 'Logout', '11:21:06:AM', '2016-06-15', 0), (147, 'admin', 1, 'Login', '01:21:46:PM', '2016-06-15', 0), (148, 'admin', 1, 'Login', '02:32:53:PM', '2016-06-15', 0), (149, 'admin', 1, 'Login', '03:09:58:PM', '2016-06-15', 0), (150, 'admin', 1, 'Logout', '03:43:52:PM', '2016-06-15', 0), (151, 'admin', 1, 'Login', '06:03:20:PM', '2016-06-15', 0), (152, 'admin', 1, 'Logout', '06:14:41:PM', '2016-06-15', 0), (153, 'admin', 1, 'Login', '10:54:44:AM', '2016-06-17', 0), (154, 'admin', 1, 'Login', '10:58:54:AM', '2016-06-17', 0), (155, 'admin', 1, 'Login', '10:28:58:AM', '2016-07-26', 0), (156, 'admin', 1, 'Login', '10:29:09:AM', '2016-07-26', 0), (157, 'admin', 1, 'Login', '11:39:31:AM', '2016-07-27', 0), (158, 'admin', 1, 'Login', '10:10:00:AM', '2016-07-28', 0), (159, 'admin', 1, 'Login', '10:25:37:AM', '2016-07-28', 0), (160, 'admin', 1, 'Login', '12:10:13:PM', '2016-08-01', 0), (161, 'admin', 1, 'Login', '11:37:57:AM', '2016-08-04', 0), (162, 'admin', 1, 'Login', '12:06:03:PM', '2016-08-04', 0), (163, 'admin', 1, 'Login', '02:37:41:PM', '2016-08-05', 0), (164, 'admin', 1, 'Login', '03:11:19:PM', '2016-08-05', 0), (165, 'admin', 1, 'Login', '03:11:28:PM', '2016-08-05', 0), (166, 'admin', 1, 'Login', '03:12:00:PM', '2016-08-05', 0), (167, 'admin', 1, 'Login', '11:26:11:AM', '2016-08-09', 0), (168, 'admin', 1, 'Login', '11:27:01:AM', '2016-08-09', 0), (169, 'admin', 1, 'Login', '09:30:46:AM', '2016-09-05', 0), (170, 'admin', 1, 'Login', '04:40:45:PM', '2016-09-20', 0), (171, 'admin', 1, 'Login', '03:36:03:PM', '2016-09-24', 0), (172, 'admin', 1, 'Login', '10:44:31:PM', '2016-09-24', 0), (173, 'admin', 1, 'Login', '12:27:21:PM', '2016-09-25', 0), (174, 'admin', 1, 'Login', '11:00:52:AM', '2016-09-26', 0), (175, 'admin', 1, 'Login', '11:37:16:AM', '2016-09-27', 0), (176, 'admin', 1, 'Login', '05:42:09:PM', '2016-09-27', 0), (177, 'admin', 1, 'Login', '07:16:05:AM', '2016-09-28', 0), (178, 'admin', 1, 'Login', '11:37:20:AM', '2016-09-28', 0), (179, 'admin', 1, 'Login', '09:07:14:PM', '2016-09-28', 0), (180, 'admin', 1, 'Login', '11:39:36:AM', '2016-09-29', 0), (181, 'admin', 1, 'Login', '01:13:17:PM', '2016-09-30', 0), (182, 'admin', 1, 'Login', '03:20:07:PM', '2016-10-01', 0), (183, 'admin', 1, 'Login', '12:02:53:PM', '2016-10-03', 0), (184, 'admin', 1, 'Login', '02:25:02:PM', '2016-10-04', 0), (185, 'admin', 1, 'Login', '09:09:21:AM', '2016-10-05', 0), (186, 'admin', 1, 'Login', '09:32:42:AM', '2016-10-07', 0), (187, 'admin', 1, 'Login', '11:30:15:AM', '2016-10-08', 0), (188, 'admin', 1, 'Login', '11:11:43:AM', '2016-10-10', 0), (189, 'admin', 1, 'Login', '04:37:49:PM', '2016-10-10', 0), (190, 'admin', 1, 'Login', '10:09:27:AM', '2016-10-11', 0), (191, 'admin', 1, 'Login', '12:34:25:PM', '2016-10-11', 0), (192, 'admin', 1, 'Login', '04:42:19:PM', '2016-10-15', 0), (193, 'admin', 1, 'Login', '09:56:02:AM', '2016-10-16', 0), (194, 'admin', 1, 'Login', '04:56:42:PM', '2016-10-20', 0), (195, 'admin', 1, 'Login', '05:06:46:PM', '2016-11-03', 0), (196, 'admin', 1, 'Login', '05:08:30:PM', '2016-11-05', 0), (197, 'admin', 1, 'Login', '10:41:48:AM', '2016-11-09', 0), (198, 'admin', 1, 'Login', '10:13:42:AM', '2016-11-12', 0), (199, 'admin', 1, 'Login', '10:19:55:AM', '2016-11-12', 0), (200, 'admin', 1, 'Login', '01:49:18:PM', '2016-11-12', 0), (201, 'admin', 1, 'Login', '03:23:09:PM', '2016-11-18', 0), (202, 'admin', 1, 'Login', '12:50:25:PM', '2016-11-25', 0), (203, 'admin', 1, 'Login', '10:46:42:AM', '2016-11-26', 0), (204, 'admin', 1, 'Login', '12:59:30:PM', '2016-11-29', 0), (205, 'admin', 1, 'Login', '04:14:13:PM', '2016-11-29', 0), (206, 'admin', 1, 'Login', '02:36:09:PM', '2016-12-05', 0), (207, 'admin', 1, 'Login', '08:32:13:AM', '2016-12-11', 0), (208, 'admin', 1, 'Login', '08:34:12:AM', '2016-12-11', 0), (209, 'admin', 1, 'Login', '07:02:56:PM', '2016-12-11', 0), (210, 'admin', 1, 'Logout', '07:05:14:PM', '2016-12-11', 0), (211, 'admin', 1, 'Login', '07:16:54:PM', '2016-12-11', 0), (212, 'admin', 1, 'Login', '08:07:54:PM', '2016-12-11', 0), (213, 'admin', 1, 'Logout', '08:19:02:PM', '2016-12-11', 0), (214, 'admin', 1, 'Login', '08:19:11:PM', '2016-12-11', 0), (215, 'admin', 1, 'Logout', '08:52:42:PM', '2016-12-11', 0), (216, 'admin', 1, 'Login', '10:33:51:AM', '2016-12-12', 0), (217, 'admin', 1, 'Logout', '11:23:56:AM', '2016-12-12', 0), (218, 'admin', 1, 'Login', '11:24:05:AM', '2016-12-12', 0), (219, 'admin', 1, 'Login', '01:23:45:PM', '2016-12-12', 0), (220, 'admin', 1, 'Logout', '01:40:49:PM', '2016-12-12', 0), (221, 'admin', 1, 'Login', '11:37:03:AM', '2016-12-13', 0), (222, 'admin', 1, 'Logout', '11:52:52:AM', '2016-12-13', 0), (223, 'admin', 1, 'Login', '11:54:41:AM', '2016-12-13', 0), (224, 'admin', 1, 'Logout', '12:33:22:PM', '2016-12-13', 0), (225, 'admin', 1, 'Login', '05:20:53:PM', '2016-12-13', 0), (226, 'admin', 1, 'Login', '07:01:35:PM', '2016-12-13', 0), (227, 'admin', 1, 'Logout', '07:36:54:PM', '2016-12-13', 0), (228, 'admin', 1, 'Login', '08:30:13:PM', '2016-12-13', 0), (229, 'admin', 1, 'Logout', '08:58:57:PM', '2016-12-13', 0), (230, 'admin', 1, 'Login', '09:39:54:AM', '2016-12-14', 0), (231, 'admin', 1, 'Logout', '10:54:20:AM', '2016-12-14', 0), (232, 'admin', 1, 'Login', '01:11:17:PM', '2016-12-14', 0), (233, 'admin', 1, 'Logout', '02:39:48:PM', '2016-12-14', 0), (234, 'admin', 1, 'Login', '02:39:58:PM', '2016-12-14', 0), (235, 'admin', 1, 'Logout', '05:53:25:PM', '2016-12-14', 0), (236, 'admin', 1, 'Login', '05:53:37:PM', '2016-12-14', 0), (237, 'admin', 1, 'Logout', '06:41:50:PM', '2016-12-14', 0), (238, 'admin', 1, 'Login', '09:32:06:AM', '2016-12-15', 0), (239, 'admin', 1, 'Login', '09:41:55:AM', '2016-12-15', 0), (240, 'admin', 1, 'Login', '10:29:17:AM', '2016-12-15', 0), (241, 'admin', 1, 'Logout', '11:03:22:AM', '2016-12-15', 0), (242, 'admin', 1, 'Login', '11:54:12:AM', '2016-12-15', 0), (243, 'admin', 1, 'Login', '12:30:00:PM', '2016-12-15', 0), (244, 'admin', 1, 'Logout', '12:47:26:PM', '2016-12-15', 0), (245, 'admin', 1, 'Login', '02:07:08:PM', '2016-12-15', 0), (246, 'admin', 1, 'Logout', '02:22:38:PM', '2016-12-15', 0), (247, 'admin', 1, 'Login', '09:28:42:AM', '2016-12-16', 0), (248, 'admin', 1, 'Logout', '10:49:20:AM', '2016-12-02', 0), (249, 'admin', 1, 'Login', '10:49:31:AM', '2016-12-02', 0), (250, 'admin', 1, 'Logout', '12:28:41:PM', '2016-12-05', 0), (251, 'admin', 1, 'Login', '06:44:51:PM', '2016-12-05', 0), (252, 'admin', 1, 'Logout', '07:09:48:PM', '2016-12-05', 0), (253, 'admin', 1, 'Login', '07:24:29:PM', '2016-12-05', 0), (254, 'admin', 1, 'Logout', '07:33:35:PM', '2016-12-05', 0), (255, 'admin', 1, 'Login', '08:13:18:PM', '2016-12-05', 0), (256, 'admin', 1, 'Logout', '08:23:35:PM', '2016-12-05', 0), (257, 'admin', 1, 'Login', '09:24:57:AM', '2016-12-16', 0), (258, 'admin', 1, 'Logout', '10:08:30:AM', '2016-12-16', 0), (259, 'admin', 1, 'Login', '10:08:50:AM', '2016-12-17', 0); -- -------------------------------------------------------- -- -- Table structure for table `machines_table` -- CREATE TABLE IF NOT EXISTS `machines_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Machine_Name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `description` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `impression_charge` double NOT NULL, `additional_impression_charge` double NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', `local` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `machines_table` -- INSERT INTO `machines_table` (`id`, `Machine_Name`, `description`, `impression_charge`, `additional_impression_charge`, `delet`, `local`) VALUES (1, 'ABDICK', 'ABDICK', 300, 100, 0, 0), (2, 'HEIDLEBERG', 'HEIDLEBERG', 300, 150, 0, 0), (3, 'SHINOHARA', 'SHINOHARA', 300, 150, 0, 0), (4, 'Wdding Card', 'wedding', 10, 0, 0, 1), (5, 'Visiting Card', 'visiting card', 100, 0, 0, 1), (6, 'Binding', 'Binding', 10, 0, 0, 1), (7, 'Laser Printing', 'Laser Printing', 0, 0, 0, 1), (8, 'CANON', 'LASER PRINTER', 0, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `master_purchase` -- CREATE TABLE IF NOT EXISTS `master_purchase` ( `id` int(11) NOT NULL AUTO_INCREMENT, `vendr_id` int(11) NOT NULL, `invoice_date` date NOT NULL, `invoice_no` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `width` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `length` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `price` double NOT NULL, `quantity` double NOT NULL, `discount` double NOT NULL, `tax` double NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `entrydate` date NOT NULL, `trnno` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `paper` int(11) NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ; -- -- Dumping data for table `master_purchase` -- INSERT INTO `master_purchase` (`id`, `vendr_id`, `invoice_date`, `invoice_no`, `product_code`, `product_name`, `gsm`, `width`, `length`, `price`, `quantity`, `discount`, `tax`, `permission`, `entrydate`, `trnno`, `user`, `paper`, `delet`) VALUES (1, 8, '2016-12-12', '123', 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', '100', '12', '15', 20, 500, 0, 5, '296281481520511', '2016-12-12', '1', 'admin', 1, 0), (2, 14, '2016-12-12', '56', 'LSRA3', 'A3 Paper For Laser Printing', '', '', '', 45, 600, 0, 5, '85291481520564', '2016-12-12', '2', 'admin', 1, 0), (3, 11, '2016-12-12', 'qwr', '250CRD', '250CRD - ART CARD 250GSM', '', '', '', 12, 12, 0, 5, '776741481521450', '2016-12-12', '4', 'admin', 1, 0), (4, 9, '2016-12-12', 'WQERWWEW', '250CRD', '250CRD - ART CARD 250GSM', '', '', '', 100, 10, 0, 5, '107211481522267', '2016-12-12', '5', 'admin', 0, 0), (5, 13, '2016-12-12', '123', '56PNK', '5.6PNK - CO5.60LOUR BOND PINK 5.60KG', '', '', '', 300, 100, 0, 5, '362161481522359', '2016-12-12', '6', 'admin', 2, 0), (6, 8, '2016-12-12', '765', '7FLCP', '7KG FOOLSCAP DLX ', '7', '43', '69', 0.84, 2500, 0, 5, '307921481630091', '2016-12-13', '18', 'admin', 1, 0), (7, 8, '2016-12-12', '765', '7KG54GS', '7-54GS - 7KG 54GSM ', '54', '40', '65', 0.94, 1000, 4.75, 5, '307921481630091', '2016-12-13', '18', 'admin', 1, 0), (8, 8, '2016-12-02', '734', '2130MAP', '213MAP - MAPLITHO 21.30KG', '80', '58.50', '91', 3.102, 2000, 0, 5, '1116131481631032', '2016-12-13', '19', 'admin', 1, 0), (9, 14, '2016-12-13', '31', 'CUT-STICK', 'CUTTING MACHINE PVC BEADING', '', '', '', 140, 2, 0, 0, '798551481689339', '2016-12-14', '24', 'admin', 0, 0), (10, 14, '2016-12-13', '31', 'INKCUT', 'INK CUT COLOUR', '', '', '', 550, 2, 0, 0, '798551481689339', '2016-12-14', '24', 'admin', 2, 0), (11, 14, '2016-12-13', '31', 'NUMINK', 'NUMBERING INK', '', '', '', 100, 2, 0, 0, '798551481689339', '2016-12-14', '24', 'admin', 0, 0), (12, 14, '2016-12-13', '31', 'STATION', 'STATIONERY ITEM', '', '', '', 50, 4, 0, 0, '798551481689339', '2016-12-14', '24', 'admin', 0, 0), (13, 8, '2016-12-01', '729', '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', '54', '58.5', '91', 2.1, 2000, 0, 5, '996911481690161', '2016-12-14', '25', 'admin', 1, 0), (14, 13, '2016-12-05', '8915', 'PRINTING', 'PRINTING CHARGE', 'OYOOR MUSLIM JAMAATH', '', '', 2.55, 2000, 0, 0, '651241481702900', '2016-12-14', '26', 'admin', 0, 0), (15, 13, '2016-12-06', '9015', 'PRINTING', 'PRINTING CHARGE', 'NOOL HUDA MADRASA', '', '', 11, 500, 0, 0, '155601481703022', '2016-12-14', '27', 'admin', 0, 0), (16, 13, '2016-12-06', '9006', 'PRINTING', 'PRINTING CHARGE', 'SUNNI YOUVAJANA SANGAM', '', '', 3.6, 1500, 0, 0, '875901481703119', '2016-12-14', '28', 'admin', 0, 0), (17, 13, '2016-12-06', '9005', 'PRINTING', 'PRINTING CHARGE', 'SUNNI YOUVAJANASANGAM', '', '', 1.166667, 3000, 0, 0, '880951481706603', '2016-12-14', '29', 'admin', 0, 0), (18, 8, '2016-12-01', '730', '186MAP', '186MAP - MAP LITHO TNPL 18.60 KG 91X58.50', '80', '58.50', '91', 2.7, 3500, 0, 5, '137471481706669', '2016-12-14', '30', 'admin', 1, 0), (19, 9, '2016-12-09', '603', '186APOLO', '186APO- APPOLO 18.6 70GSM 91X58.50', '70', '58.50', '91', 2.4762, 1500, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (20, 9, '2016-12-09', '603', '72TNPL', '7.2-54GSMRADIANT 45.5X58.50 ', '54', '45.5', '58.5', 0.97142, 8000, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (21, 9, '2016-12-09', '603', 'JKCRD', 'JK195 - JK CARD 195 GSM 56X71', '195', '56', '71', 5.33333, 600, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (22, 9, '2016-12-09', '603', '6KPNK', '6KPNK - 6KG PINK COL BOND 45.5X58.5 47GSM', '47', '45.5', '58.50', 1.0119, 960, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (23, 9, '2016-12-09', '603', '6KYELO', '6KYEL - 6KG YELO COL BOND 4505X58.5 47GSM', '47', '45.5', '58.50', 1.0119, 960, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (24, 9, '2016-12-09', '603', '6KGRN', '6KGRN 6KG GREEN COL BOND 45.50X58.50 47GSM', '47', '45.5', '58.50', 1.0119, 960, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (25, 9, '2016-12-09', '603', 'WRPRFNCY', 'WRAPER FANCY', '47', '45.5', '58.50', 1.9048, 100, 0, 5, '937971480943826', '2016-12-05', '121', 'admin', 1, 0), (26, 9, '2016-12-07', '589', 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', '60', '45.5', '58.50', 0.47916, 4800, 0, 5, '577991480944753', '2016-12-05', '122', 'admin', 1, 0), (27, 9, '2016-12-07', '589', '6KPNK', '6KPNK - 6KG PINK COL BOND 45.5X58.5 47GSM', '70', '45.5', '58.5', 2.76, 500, 0, 5, '577991480944753', '2016-12-05', '122', 'admin', 1, 0), (28, 9, '2016-12-07', '589', '186APOLO', '186APO- APPOLO 18.6 70GSM 91X58.50', '70', '45.5', '58.5', 2.63999, 1500, 0, 5, '577991480944753', '2016-12-05', '122', 'admin', 1, 0), (29, 9, '2016-12-07', '589', 'STRWBORD', 'STRBRD STRAW BOARD 8 OZ', '70', '45.5', '58.5', 7.12959, 108, 0, 5, '577991480944753', '2016-12-05', '122', 'admin', 1, 0), (30, 9, '2016-12-07', '589', '116APPOL', '116APO - APPOLO CROWN 11.6KG 60GSM 76X51', '60', '51', '76', 1.64, 1000, 0, 5, '577991480944753', '2016-12-05', '122', 'admin', 1, 0), (31, 9, '2016-12-08', '597', '6KPNK', '6KPNK - 6KG PINK COL BOND 45.5X58.5 47GSM', '47', '45.5', '58.5', 1.0625, 480, 0, 5, '294591480946084', '2016-12-05', '123', 'admin', 1, 0), (32, 9, '2016-12-03', '576', '24MAP', '24MAP - MAP LITHO 24 KG 91X58.50', '90', '58.5', '91', 3.6, 50, 0, 5, '605021480946155', '2016-12-05', '124', 'admin', 1, 0), (33, 9, '2016-12-03', '576', '116APPOL', '116APO - APPOLO CROWN 11.6KG 60GSM 76X51', '60', '51', '76', 1.65999, 1000, 0, 5, '605021480946155', '2016-12-05', '124', 'admin', 1, 0), (34, 9, '2016-12-03', '576', '186APOLO', '186APO- APPOLO 18.6 70GSM 91X58.50', '70', '58.5', '91', 2.59999, 7000, 0, 5, '605021480946155', '2016-12-05', '124', 'admin', 1, 0), (35, 13, '2016-12-05', '8915', 'PRINTING', 'PRINTING CHARGE', '', '', '', 2.55, 2000, 0, 0, '887261480949401', '2016-12-05', '125', 'admin', 0, 0), (36, 13, '2016-12-15', '9537', 'PRINTING', 'PRINTING CHARGE', '', '', '', 1.2, 2750, 0, 0, '787751481860629', '2016-12-16', '126', 'admin', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `other_settings` -- CREATE TABLE IF NOT EXISTS `other_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `other_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `other_settings` -- INSERT INTO `other_settings` (`id`, `other_name`, `amount`, `delet`) VALUES (1, 'Lamination', 100, 0), (2, 'Back Printing', 200, 0), (3, 'Folding', 20, 0), (4, 'Creasing', 500, 0), (5, 'CTP Charge', 250, 0), (6, 'DTP Charge', 200, 0), (7, 'Tracing with Plate Charge', 50, 0), (8, 'Binding', 0, 0), (9, 'Stapling', 0, 0), (10, 'Stitching', 0, 0), (11, 'Pasting', 0, 0), (12, 'Print on Last Copy', 5, 0); -- -------------------------------------------------------- -- -- Table structure for table `paper_type` -- CREATE TABLE IF NOT EXISTS `paper_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `papertype` varchar(100) NOT NULL, `del` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `paper_type` -- INSERT INTO `paper_type` (`id`, `papertype`, `del`) VALUES (1, 'Maplitho', 0), (4, 'Art', 0), (5, 'Art Board', 0), (6, 'Colour Card', 0), (7, 'Duplex CArd', 0), (8, 'Flurocent', 0), (9, 'Ledger', 0), (10, 'Colour Bond', 0), (11, 'Semi', 0), (12, 'Card', 0), (13, 'Wrapper', 0), (14, 'Binding Board', 0), (15, 'Binding Cloth', 0); -- -------------------------------------------------------- -- -- Table structure for table `price_details` -- CREATE TABLE IF NOT EXISTS `price_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `machine_id` int(11) NOT NULL, `cata_id` int(11) NOT NULL, `amount` double NOT NULL, `tax` double NOT NULL DEFAULT '0', `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `price_details` -- INSERT INTO `price_details` (`id`, `machine_id`, `cata_id`, `amount`, `tax`, `delet`) VALUES (1, 1, 1, 5, 0, 0), (2, 1, 2, 4, 0, 0), (3, 1, 3, 480, 0, 0), (4, 1, 4, 600, 0, 0), (5, 1, 5, 50, 0, 0), (6, 1, 6, 20, 0, 0), (7, 1, 7, 130, 5, 0), (8, 2, 8, 0, 0, 0), (9, 3, 9, 4, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `printing_size` -- CREATE TABLE IF NOT EXISTS `printing_size` ( `id` int(11) NOT NULL AUTO_INCREMENT, `print_size` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; -- -- Dumping data for table `printing_size` -- INSERT INTO `printing_size` (`id`, `print_size`, `delet`) VALUES (1, '1/2', 0), (2, '1/4', 0), (3, '1/6', 0), (4, '1/8', 0), (5, '1/16', 0), (6, '1/1', 0), (7, '1/12', 0), (8, '1/5', 0), (9, '1/50', 1), (11, '1/90', 1), (12, '1/100', 1), (13, '1/50', 0), (14, '1/500', 1), (15, '1/100', 1), (16, '1/100', 0), (17, '1/18', 0), (18, '1/32', 0), (19, '1/64', 0), (20, '1/24', 0), (21, '1/20', 0), (22, '1/3', 0); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE IF NOT EXISTS `products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `productcode` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `productname` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm` double NOT NULL, `paper_type` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `paper_color` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `paper_size` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sellprice` double NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=99 ; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `productcode`, `productname`, `gsm`, `paper_type`, `paper_color`, `paper_size`, `sellprice`, `delet`) VALUES (1, '001', 'Paper1', 200, 'Ex Bond', 'Blue', '12', 3, 1), (2, '002', 'clip', 3, 'Art Card', 'Black', '7', 32, 1), (3, '0013', 'Dummy Crown 130 GSM', 130, 'Maplitho', 'White', '5', 2, 1), (4, '003', 'Dummy 50 GSM', 50, 'Ivory Board', 'Gray', '3', 2, 1), (5, '0045', 'Double Dummy 23GSM', 23, 'Maplitho', 'White', '12', 7, 1), (6, 'MAP0012', 'Dummy 120 GSM', 120, 'Art Board', 'White', '9', 4, 1), (7, '009877', 'Dummy 130 GSM', 130, 'Maplitho', 'White', '2', 2.5, 1), (8, '0036', '130ART-130GSM ART PAPER', 130, 'Art', 'White', '86 x 57', 2.5, 1), (9, '0087', 'Double Dummy Art 100 GSM', 100, 'Art', 'White', '86 x 57', 2, 1), (10, '1234', '100CRN- CROWN ART 100 gsm', 100, 'Art', 'white', '76x51', 1.5, 1), (11, '186TNPL', '186TNPL - 18.6 KG MAP LITHO RADIANT ', 80, 'Maplitho', 'WHITE', '91X58.50', 1.4, 1), (12, '106XBOND', '10.6 KG EX BOND', 80, 'Ex Bond', 'WHITE', '58.50X45.50', 2.4, 1), (13, 'DDYAR170', '170ART - DEMY ART 170GSM', 170, 'Art', 'WHITE', '91X58.50', 3.5, 1), (14, 'DDARTCRD250', '250CRD- DEMY ART CARD 250 GSM', 250, 'Art Card', 'WHITE', '91X58.50', 5, 1), (15, 'DDARTCRD300', '300CRD -DEMY ART CARD 300GSM', 300, 'Art Card', 'WHITE', '91X58.50', 6, 1), (16, 'CRNART130', '130CRN - CROWN ART 130GSM', 130, 'Art', 'WHITE', '76X51', 2, 1), (17, 'CRNART170', '170CRN - CROWN ART 170GSM', 170, 'Art', 'WHITE', '76X51', 2.5, 1), (18, 'CRARTCRD250', '250CRN - CROWN ART CARD 250GSM', 250, 'Art', 'WHITE', '76X51', 4, 1), (19, 'DYMAP24', 'DEMY MAPLITHO 24KG', 24, 'Maplitho', 'WHITE', '91X58.50', 1.75, 1), (20, 'DYMAP32', 'DEMY MAPLITHO 32KG', 32, 'Maplitho', 'WHITE', '91X58.50', 2.5, 1), (21, 'DYMAP16', 'DEMY MAPLITHO 16KG', 16, 'Maplitho', 'WHITE', '91X58.50', 1.2, 1), (22, 'CRNMAP136', 'CROWN MAPLITHO 13.60KG', 13.6, 'Maplitho', 'WHITE', '76X51', 1.1, 1), (23, 'FSGVG610', 'FOOLSCAP GVG 6.10KG', 6.1, 'Maplitho', 'WHITE', '65X40', 0.38, 1), (24, 'FSSPB104', 'FOOLSCAP SPB 10.40KG', 10.4, 'Maplitho', 'WHITE', '69X43', 0.8, 1), (25, 'FSLDGR122', 'FOOLSCAP LEDGER 12.20KG', 12.2, 'Maplitho', 'WHITE', '69X43', 1, 1), (26, 'DYCLBNDBLU', 'DEMY COLOUR BOND GVG 5.60', 5.6, 'Maplitho', 'BLUE', '58.50X45.50', 0.6, 1), (27, 'DYCLBNDGRN', 'DEMY COLOURBOND GREEN 5.60', 5.6, 'Maplitho', 'GREEN', '58.50X45.50', 0.6, 1), (28, 'DYCLBNDPNK', 'PNKBND - DEMY COLOURBOND PINK 5.60', 5.6, 'Ex Bond', 'PINK', '58.50X45.50', 0.6, 1), (29, 'DYCLBNDYEL', 'DEMY COLOUR BOND YELLOW 5.60', 5.6, 'Ex Bond', 'YELLOW', '58.50X45.50', 0.6, 1), (30, 'DYCOLYEL7', 'YELBND -DEMY COLOUR BOND YELLOW 7KG', 7, 'Ex Bond', 'YELLOW', '56X44', 1.1, 1), (31, 'DYCOLGR7', 'DEMY COLOUR BOND GREEN 7KG', 7, 'Maplitho', 'GREEN', '56X44', 1.1, 1), (32, 'DYCOLBORS7', 'DEMY COLOURBOND ROSE 7KG', 7, 'Maplitho', 'ROSE', '56X44', 1.1, 1), (33, 'DYCOLBOBLU7', 'DEMY COLOUR BOND BLUE 7KG', 7, 'Maplitho', 'BLUE', '56X44', 1.1, 1), (34, 'DUPLCRD230', 'DEMY DUPLEX CARD 230GSM', 230, 'Art Card', 'WHITE', '91X58.50', 3, 1), (35, 'DYMAP137', '137MAP - DEMY MAPLITHO 13.7KG', 13.7, 'Maplitho', 'WHITE', '91X58.50', 1.1, 1), (36, 'PRCHM186', 'PRCH186 -PARCHMENT 18.60 70GSM', 70, 'Maplitho', 'WHITE', '86X57', 1.75, 1), (37, 'DYART100', '100ART - DEMY ART 100GSM', 100, 'Art', 'WHITE', '86X57', 2, 1), (38, 'DDMAP213', 'DEMY MAPLITHO 21.30KG', 80, 'Maplitho', 'WHITE', '91X58.50', 1.5, 1), (39, 'XBOND80', 'EXECUTIVE BOND 80GSM', 80, 'Ex Bond', 'WHITE', '91X58.50', 2.5, 1), (40, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6 45.5x58.50', 5.6, 'Maplitho', 'OFFWHITE', '45.5x58.50', 0.5, 0), (41, 'LSRA3', 'A3 Paper For Laser Printing', 250, 'Maplitho', 'white', '32/18', 15, 0), (42, 'COLCARD', 'colorcard 8,6', 8, 'Maplitho', 'white', '56x71', 5, 1), (43, 'WED', 'WED.CARD', 0, 'Art Card', 'ASSORTED', '0', 0, 0), (44, '130ART', '130ART - ART PAPER 130GSM', 130, 'Art', 'WHITE', '86X57', 2.5, 0), (45, '130CRN', '130CRN - CROWN ART PAPER 130GSM', 130, 'Art', 'WHITE', '76X51', 2, 0), (46, '100CRN', '100CRN - CROWN ART PAPER 100GSM', 100, 'Art', 'WHITE', '76X51', 1.5, 0), (47, '186MAP', '186MAP - MAP LITHO TNPL 18.60 KG 91X58.50', 80, 'Maplitho', 'WHITE', '91X58.50', 1.4, 0), (48, '170ART', '170ART - ART PAPER 170 GSM', 170, 'Art', 'WHITE', '91X58.50', 3.5, 0), (49, '250CRD', '250CRD - ART CARD 250GSM', 250, 'Art', 'WHITE', '91X58.50', 5, 0), (50, '300CRD', '300CRD - ART CARD 300GSM', 300, 'Art', 'WHITE', '91X58.50', 6, 0), (51, '170CRN', '170CRN - CROWN ART PAPER 170GSM', 170, 'Art', 'WHITE', '76X51', 2.5, 0), (52, '250CRN', '250CRN - CROWN ART CARD 250GSM', 250, 'Art', 'WHITE', '76X51', 4, 0), (53, '24MAP', '24MAP - MAP LITHO 24 KG 91X58.50', 24, 'Maplitho', 'WHITE', '91X58.50', 1.8, 0), (54, '32MAP', '32MAP - MAP LITHO PAPER 32KG', 32, 'Maplitho', 'WHITE', '91X58.50', 2.5, 0), (55, '16MAP', '16MAP - MAP LITHO PAPER 16KG', 16, 'Maplitho', 'WHITE', '91X58.50', 1.2, 0), (56, '136CRN', '136CRN - CROWN MAP LITHO 13.60KG', 13.6, 'Maplitho', 'WHITE', '76X51', 1.1, 0), (57, '610FSCP', '610FSC - FOOLS CAP 6.10 KG', 6.1, 'Maplitho', 'WHITE', '65X40', 0.38, 0), (58, '104FSCP', '104FSC - FOOLS CAP 10.40KG', 10.4, '', 'WHITE', '69X43', 1.8, 0), (59, '122LDGR', '122LDG - LEDGER FOOLSCAP 12.20KG', 12.2, 'Fools Cap', 'WHITE', '69X43', 1, 0), (60, '56COLBND', '5.60BLU - COLOUR BOND 5.60 KG', 5.6, 'Colour Bond', 'BLUE', '58.50X45.50', 0.6, 1), (61, '56COL', '5.6GRN - COLOUR BOND 5.60KG', 5.6, 'Colour Bond', 'GREEN', '58.50X45.50', 0.6, 1), (62, '56PNK', '5.6PNK - CO5.60LOUR BOND PINK 5.60KG', 5.6, 'Colour Bond', 'PINK', '58.50X46.50', 0.6, 0), (63, '56BLUE', '5.60BL', 5.6, 'Colour Bond', 'BLUE', '58.50X45.50', 0.6, 0), (64, '56GRN', '5.6GRN - COLOUR BOND GREEN 5.60KG', 5.6, 'Colour Bond', 'GREEN', '58.50X45.50', 0.6, 0), (65, '7YELBND', '7YELOW - COLOUR BOND 7KG YELLOW', 7, 'Colour Bond', 'YELLOW', '56X44', 1.1, 0), (66, '7GRNBND', '7GREEN - COLOUR BOND 7KG GREEN', 7, 'Colour Bond', 'GREEN', '56X44', 1.1, 0), (67, '7ROSEBND', '7ROS - COLOUR BOND 7KG ROSE', 7, 'Colour Bond', 'ROSE', '56X44', 1.1, 0), (68, '7BLUBND', '7BLUE - COLOUR BOND 7KG BLUE', 7, 'Colour Bond', 'BLUE', '56X44', 1.1, 0), (69, '230DPLX', '230CRD - DUPLEX CARD 230GSM', 230, 'Card', 'WHITE', '91X58.50', 3, 0), (70, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', 13.7, 'Maplitho', 'WHITE', '91X58.50', 1.1, 0), (71, '186PRCHM', '186PRCH - PERCHMENT 18.60KG', 70, 'Maplitho', 'WHITE', '86X57', 1.75, 0), (72, '100ART', '100ART - ART PAPER 100GSM', 100, 'Art', 'WHITE', '86X57', 2, 0), (73, '80EXBON', '80XBND - EXECUTIVE BOND 80GSM', 80, 'Maplitho', 'WHITE', '91X58.50', 2.5, 0), (74, '2130MAP', '213MAP - MAPLITHO 21.30KG', 80, 'Maplitho', 'WHITE', '91X58.50', 1.5, 0), (75, '86COLCRD', '8,6COL - COLOUR CARD BLUE', 8, 'Card', 'BLUE', '56X71', 5, 0), (76, '186APOLO', '186APO- APPOLO 18.6 70GSM 91X58.50', 70, 'Maplitho', 'WHITE', '91X58.50', 1.4, 0), (77, '116APPOL', '116APO - APPOLO CROWN 11.6KG 60GSM 76X51', 60, 'Maplitho', 'WHITE', '76X51', 0.9, 0), (78, '7FLCP', '7KG FOOLSCAP DLX ', 7, 'Maplitho', 'WHITE', '65X40', 0.9, 0), (79, '7KG54GS', '7-54GS - 7KG 54GSM ', 54, 'Maplitho', 'WHITE', '40X65', 1, 0), (80, '72TNPL', '7.2-54GSMRADIANT 45.5X58.50 ', 54, 'Maplitho', 'WHITE', '45.5X58.5', 1.1, 0), (81, 'JKCRD', 'JK195 - JK CARD 195 GSM 56X71', 195, 'Duplex CArd', 'WHITE', '56X71', 5.5, 0), (82, '6KGCOL', '6KPNK - COLOUR BOND 6KG 47GSM 45.5X58.50', 47, 'Colour Bond', 'PINK', '45.5X58.5', 1.1, 1), (83, '6KPNK', '6KPNK - 6KG PINK COL BOND 45.5X58.5 47GSM', 47, 'Colour Bond', 'PINK', '45.5X58.50', 1.1, 0), (84, '6KYELO', '6KYEL - 6KG YELO COL BOND 4505X58.5 47GSM', 47, 'Colour Bond', 'YELLOW', '45.50X58.50', 1.1, 0), (85, '6KGRN', '6KGRN 6KG GREEN COL BOND 45.50X58.50 47GSM', 47, 'Colour Bond', 'GREEN', '45.50X58.50', 1.1, 0), (86, 'WRPRFNCY', 'WRAPER FANCY', 47, 'Wrapper', 'ASSORTED', '45.5X58.5', 2, 0), (87, 'STRWBORD', 'STRBRD STRAW BOARD 8 OZ', 8, 'Binding Board', 'YELLOW', '91X58', 7.2, 0), (88, 'INKCUT', 'INK CUT COLOUR', 0, '', '', '', 550, 0), (89, 'CUT-STICK', 'CUTTING MACHINE PVC BEADING', 0, '', '', '', 280, 0), (90, 'NUMINK', 'NUMBERING INK', 0, '', '', '', 100, 0), (91, 'STATION', 'STATIONERY ITEM', 0, '', '', '', 50, 0), (92, 'PRINTING', 'PRINTING CHARGE', 0, '', '', '', 1, 0), (93, 'LAMIN', 'LAMINATION CHARGES', 0, '', '', '', 1, 0), (94, 'BINDING', 'BINDING CHARGES', 0, '', '', '', 1, 0), (95, 'LASER', 'LASER PRINTING CHARGES', 0, '', '', '', 1, 0), (96, 'SCREEN', 'SCREEN PRINTING CHARGES', 0, '', '', '', 1, 0), (97, 'VCARD', 'VISITING CARD', 0, '', '', '', 1, 0), (98, 'KULI', 'KULI CARD', 80, 'Maplitho', 'WHITE', '52X81', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `purchase_temp` -- CREATE TABLE IF NOT EXISTS `purchase_temp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `vendr_id` int(11) NOT NULL, `invoice_date` date NOT NULL, `invoice_no` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `gsm` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `width` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `length` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `price` double NOT NULL, `quantity` double NOT NULL, `discount` double NOT NULL, `tax` double NOT NULL, `permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `entrydate` date NOT NULL, `paper` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ; -- -- Dumping data for table `purchase_temp` -- INSERT INTO `purchase_temp` (`id`, `vendr_id`, `invoice_date`, `invoice_no`, `product_code`, `product_name`, `gsm`, `width`, `length`, `price`, `quantity`, `discount`, `tax`, `permission`, `entrydate`, `paper`) VALUES (10, 14, '2016-12-11', '10', 'INKCUT', 'INK CUT COLOUR', '', '', '', 0, 1, 0, 5, '637571481468429', '2016-12-11', 1), (16, 9, '2016-12-03', '576', '186APOLO', '186APO- APPOLO 18.6 70GSM', '70', '57', '86', 2.47, 7000, 0, 5, '883481481612351', '2016-12-13', 1), (17, 9, '2016-12-03', '576', '116APPOL', '116APO - APPOLO CROWN 11.6KG 60GSM', '60', '51', '76', 1.52, 1000, 0, 5, '883481481612351', '2016-12-13', 1), (18, 9, '2016-12-03', '576', '24MAP', '24MAP - MAP LITHO 24 KG', '90', '58', '91', 0.34, 50, 0, 5, '883481481612351', '2016-12-13', 1); -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE IF NOT EXISTS `role` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rolename` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `role` -- INSERT INTO `role` (`id`, `rolename`, `delet`) VALUES (1, 'Admin', 0), (2, 'Manager', 0), (3, '', 1), (4, 'Sales', 0), (5, 'Design & DTP', 0), (6, 'Printing', 0), (7, 'Binding', 0); -- -------------------------------------------------------- -- -- Table structure for table `staff` -- CREATE TABLE IF NOT EXISTS `staff` ( `staff_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `role_id` int(11) NOT NULL, `staff_name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `stfaddress` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `dob` date NOT NULL, `depid` int(11) NOT NULL, `logaccess` int(11) NOT NULL, `email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `place` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `zipcode` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `secphone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `joining_dat` date NOT NULL, `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `status` int(11) NOT NULL DEFAULT '1', `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`staff_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ; -- -- Dumping data for table `staff` -- INSERT INTO `staff` (`staff_id`, `user_name`, `role_id`, `staff_name`, `stfaddress`, `dob`, `depid`, `logaccess`, `email`, `place`, `zipcode`, `phone`, `secphone`, `joining_dat`, `image`, `status`, `delet`) VALUES (1, 'admin', 1, 'Admin', 'Kollam', '1990-02-01', 1, 0, 'sambu@gmail.com', 'Kalayapuram', '691560', '09895956913', '', '0000-00-00', '', 1, 1), (29, 'newlimara@gmail.com', 6, 'SUMESH', 'ITHIKKARA, CHATHANNOOR', '2016-12-22', 1, 1, 'newlimara@gmail.com', 'CHATHANNOO', '691572', '9072885622', '', '0000-00-00', '', 1, 0), (28, 'newlimara@gmail.com', 7, 'SHOBHANA', 'KOLLAM', '2016-12-22', 5, 1, 'newlimara@gmail.com', 'KOLLAM', '691010', '343434', '', '0000-00-00', '', 1, 0), (27, 'newlimara@gmail.com', 7, 'LATHA', 'KOLLAM', '2016-12-09', 5, 1, 'newlimara@gmail.com', 'KOLLAM', '691010', '1111', '', '0000-00-00', '', 1, 0), (26, 'newlimara@gmail.com', 3, 'SREEDEVI', 'KOLLAM', '2016-12-08', 5, 1, 'newlimara@gmail.com', 'KOLLAM', '691010', '3434343434', '', '0000-00-00', '', 1, 0), (25, 'newlimara@gmail.com', 4, 'SHAJI AHMED', 'PALLIMUKKU, KOLLAM', '2016-12-09', 4, 1, 'newlimara@gmail.com', 'KOLLAM', '691010', '7012808692', '', '0000-00-00', '', 1, 0), (24, 'newlimara@gmail.com', 3, 'MOHANAN PILLAI', 'KUNDARA', '2016-12-02', 1, 1, 'newlimara@gmail.com', 'KUNDARA', '691710', '1111', '', '0000-00-00', '', 1, 0), (23, 'newlimara@gmail.com', 3, 'NOUSHAD.U', 'SHABNAM, CHATHANNOOR', '2016-12-08', 1, 1, 'newlimara@gmail.com', 'CHATHANNOOR', '691572', '9746213794', '', '0000-00-00', '', 1, 0), (22, 'shafiqatar@gmail.com', 2, 'SHAFI .U.M', 'SHABNAM, CHATHANNOOR', '2016-12-16', 6, 0, 'shafiqatar@gmail.com', 'CHATHANNOOR', '691572', '9495551185', '', '0000-00-00', '', 1, 0), (21, 'newlimara@gmail.com', 5, 'SHEHINA', 'KAMPIVILA PUTHEN VEEDU, CHATHANNOOR', '2016-12-08', 3, 0, 'newlimara@gmail.com', 'CHATHANNOOR', '691572', '919447337060', '', '0000-00-00', '', 1, 0), (20, 'newlimara@g.mail.com', 4, 'PRASANNAN', 'ASANTAZHIKOM, NEDUNGOLAM', '2016-12-08', 4, 1, 'newlimara@g.mail.com', 'NEDUNGOLAM', '691572', '23434343', '', '0000-00-00', '', 1, 0), (19, 'newlimara@gmail.com', 5, 'SHEMEER.U', 'KAMPIVILA PUTHEN VREEDU, CHATHANNOOR', '2016-12-08', 3, 0, 'newlimara@gmail.com', 'CHATHANNOOR', '691572', '122434343434`', '', '0000-00-00', '', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `staff_attendence` -- CREATE TABLE IF NOT EXISTS `staff_attendence` ( `id` int(11) NOT NULL AUTO_INCREMENT, `staffid` int(11) NOT NULL, `date` date NOT NULL, `mnthyear` varchar(50) NOT NULL, `status` int(25) DEFAULT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ; -- -- Dumping data for table `staff_attendence` -- INSERT INTO `staff_attendence` (`id`, `staffid`, `date`, `mnthyear`, `status`, `delet`) VALUES (1, 1, '2016-12-06', '2016-12', 0, 0), (2, 3, '2016-12-06', '2016-12', 1, 0), (3, 4, '2016-12-06', '2016-12', 0, 0), (4, 5, '2016-12-06', '2016-12', 0, 0), (5, 6, '1970-01-01', '1970-01', 1, 0), (6, 6, '2016-12-06', '2016-12', 0, 0), (7, 3, '2016-11-01', '2016-11', 1, 0), (8, 3, '2016-12-02', '2016-12', 1, 0), (9, 3, '2016-12-03', '2016-12', 1, 0), (10, 3, '2016-12-05', '2016-12', 1, 0), (11, 3, '2016-12-07', '2016-12', 1, 0), (12, 3, '2016-12-08', '2016-12', 0, 0), (13, 3, '2016-11-02', '2016-11', 1, 0), (14, 3, '2016-11-03', '2016-11', 1, 0), (15, 3, '2016-11-04', '2016-11', 1, 0), (16, 3, '2016-11-05', '2016-11', 1, 0), (17, 3, '2016-11-06', '2016-11', 1, 0), (18, 3, '2016-11-08', '2016-11', 1, 0), (19, 3, '2016-11-07', '2016-11', 1, 0), (20, 3, '2016-11-09', '2016-11', 1, 0), (21, 3, '2016-11-10', '2016-11', 1, 0), (22, 3, '2016-11-11', '2016-11', 1, 0), (23, 3, '2016-11-12', '2016-11', 1, 0), (24, 3, '2016-11-13', '2016-11', 1, 0), (25, 3, '2016-11-14', '2016-11', 0, 0), (26, 3, '2016-11-15', '2016-11', 1, 0), (27, 3, '2016-11-16', '2016-11', 1, 0), (28, 3, '2016-11-17', '2016-11', 1, 0), (29, 3, '2016-12-17', '2016-12', 1, 0), (30, 3, '2016-11-18', '2016-11', 1, 0), (31, 3, '2016-11-19', '2016-11', 1, 0), (32, 3, '2016-11-20', '2016-11', 1, 0), (33, 3, '2016-11-21', '2016-11', 1, 0), (34, 3, '2016-11-22', '2016-11', 1, 0), (35, 3, '2016-11-23', '2016-11', 1, 0), (36, 3, '2016-11-24', '2016-11', 1, 0), (37, 3, '2016-11-25', '2016-11', 1, 0), (38, 3, '2016-11-26', '2016-11', 1, 0), (39, 3, '2016-11-27', '2016-11', 1, 0), (40, 3, '2016-11-28', '2016-11', 1, 0), (41, 3, '2016-11-29', '2016-11', 1, 0), (42, 3, '2016-11-30', '2016-11', 1, 0), (43, 2, '2016-12-10', '12-2016', 1, 0), (44, 26, '2016-12-02', '2016-12', 0, 0), (45, 28, '2016-12-02', '2016-12', 1, 0), (46, 26, '2016-12-03', '2016-12', 0, 0), (47, 27, '2016-12-03', '2016-12', 0, 0), (48, 27, '2016-12-05', '2016-12', 0, 0), (49, 26, '2016-12-05', '2016-12', 0, 0), (50, 27, '2016-12-10', '2016-12', 0, 0), (51, 27, '2016-12-13', '2016-12', 0, 0), (52, 29, '2016-12-02', '2016-12', 1, 0), (53, 27, '2016-12-02', '2016-12', 1, 0), (54, 25, '2016-12-02', '2016-12', 1, 0), (55, 24, '2016-12-02', '2016-12', 1, 0), (56, 23, '2016-12-02', '2016-12', 1, 0), (57, 22, '2016-12-02', '2016-12', 1, 0), (58, 21, '2016-12-02', '2016-12', 1, 0), (59, 20, '2016-12-02', '2016-12', 1, 0), (60, 29, '2016-12-01', '2016-12', 1, 0), (61, 28, '2016-12-01', '2016-12', 1, 0), (62, 27, '2016-12-01', '2016-12', 1, 0), (63, 26, '2016-12-01', '2016-12', 1, 0), (64, 25, '2016-12-01', '2016-12', 1, 0), (65, 29, '2016-12-03', '2016-12', 1, 0), (66, 29, '2016-12-05', '2016-12', 1, 0), (67, 29, '2016-12-06', '2016-12', 1, 0), (68, 29, '2016-12-07', '2016-12', 1, 0), (69, 29, '2016-12-08', '2016-12', 1, 0), (70, 29, '2016-12-09', '2016-12', 1, 0), (71, 29, '2016-12-10', '2016-12', 1, 0), (72, 29, '2016-12-12', '2016-12', 1, 0), (73, 29, '2016-12-13', '2016-12', 1, 0), (74, 29, '2016-12-14', '2016-12', 1, 0), (75, 29, '2016-12-15', '2016-12', 1, 0), (76, 29, '2016-12-16', '2016-12', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `staff_salary` -- CREATE TABLE IF NOT EXISTS `staff_salary` ( `id` int(11) NOT NULL AUTO_INCREMENT, `staff_id` int(11) NOT NULL, `amount` double NOT NULL, `basic_salary` double NOT NULL DEFAULT '0', `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `staff_salary` -- INSERT INTO `staff_salary` (`id`, `staff_id`, `amount`, `basic_salary`, `delet`) VALUES (1, 19, 460, 11500, 0), (2, 20, 460, 11500, 0), (3, 21, 260, 6500, 0), (4, 22, 200, 5000, 0), (5, 23, 760, 19000, 0), (6, 24, 285, 7125, 0), (7, 25, 520, 13000, 0), (8, 26, 285, 7125, 0), (9, 27, 225, 5625, 0), (10, 28, 200, 5000, 0), (11, 29, 300, 7500, 0); -- -------------------------------------------------------- -- -- Table structure for table `staff_sal_details` -- CREATE TABLE IF NOT EXISTS `staff_sal_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `staffid` int(11) NOT NULL, `date` date NOT NULL, `mnthyear` varchar(50) NOT NULL, `type` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `details` varchar(250) NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `staff_sal_details` -- INSERT INTO `staff_sal_details` (`id`, `staffid`, `date`, `mnthyear`, `type`, `amount`, `details`, `delet`) VALUES (1, 3, '2016-11-07', '2016-11', '', 5000, '', 0), (2, 3, '2016-11-01', '2016-11', '', 2000, '', 0), (3, 2, '2016-12-10', '', '', 1000, '', 0), (4, 17, '2016-12-12', '2016-12', '', 2000, '', 0), (5, 20, '2016-12-05', '2016-12', '', 700, '', 0), (6, 20, '2016-12-06', '2016-12', '', 2000, '', 0), (7, 24, '2016-12-09', '2016-12', '', 1000, '', 0), (8, 20, '2016-12-10', '2016-12', '', 850, '', 0), (9, 19, '2016-12-10', '2016-12', '', 2000, '', 0), (10, 20, '2016-12-14', '2016-12', '', 500, '', 0), (11, 25, '2016-12-14', '2016-12', '', 2000, '', 0), (12, 24, '2016-12-16', '2016-12', '', 1000, '', 0); -- -------------------------------------------------------- -- -- Table structure for table `stock_master` -- CREATE TABLE IF NOT EXISTS `stock_master` ( `id` int(25) NOT NULL AUTO_INCREMENT, `product_code` varchar(200) NOT NULL, `product_name` varchar(200) NOT NULL, `quantity` double NOT NULL, `type` int(11) NOT NULL, `delet` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ; -- -- Dumping data for table `stock_master` -- INSERT INTO `stock_master` (`id`, `product_code`, `product_name`, `quantity`, `type`, `delet`) VALUES (1, '250CRD', '250CRD - ART CARD 250GSM', 10, 0, 0), (2, '56PNK', '5.6PNK - CO5.60LOUR BOND PINK 5.60KG', 0, 2, 0), (3, '7FLCP', '7KG FOOLSCAP DLX ', 2500, 1, 0), (4, '7KG54GS', '7-54GS - 7KG 54GSM ', 1000, 1, 0), (5, '2130MAP', '213MAP - MAPLITHO 21.30KG', 2000, 1, 0), (6, 'CUT-STICK', 'CUTTING MACHINE PVC BEADING', 2, 0, 0), (7, 'INKCUT', 'INK CUT COLOUR', 2, 2, 0), (8, 'NUMINK', 'NUMBERING INK', 2, 0, 0), (9, 'STATION', 'STATIONERY ITEM', 4, 0, 0), (10, '137MAPLI', '137MAP - MAP LITHO 13.70KG 91X58.50', -2216.66666667, 1, 0), (11, 'PRINTING', 'PRINTING CHARGE', 11750, 0, 0), (12, '186MAP', '186MAP - MAP LITHO TNPL 18.60 KG 91X58.50', 3125, 1, 0), (13, '186APOLO', '186APO- APPOLO 18.6 70GSM 91X58.50', 10000, 1, 0), (14, '72TNPL', '7.2-54GSMRADIANT 45.5X58.50 ', 8000, 1, 0), (15, 'JKCRD', 'JK195 - JK CARD 195 GSM 56X71', 600, 1, 0), (16, '6KPNK', '6KPNK - 6KG PINK COL BOND 45.5X58.5 47GSM', 1940, 1, 0), (17, '6KYELO', '6KYEL - 6KG YELO COL BOND 4505X58.5 47GSM', 960, 1, 0), (18, '6KGRN', '6KGRN 6KG GREEN COL BOND 45.50X58.50 47GSM', 960, 1, 0), (19, 'WRPRFNCY', 'WRAPER FANCY', 100, 1, 0), (20, 'SEMI', 'SEMI- DEMY UNBLEACHED 5.6', 4000, 1, 0), (21, 'STRWBORD', 'STRBRD STRAW BOARD 8 OZ', 108, 1, 0), (22, '116APPOL', '116APO - APPOLO CROWN 11.6KG 60GSM 76X51', 2000, 1, 0), (23, '24MAP', '24MAP - MAP LITHO 24 KG 91X58.50', 50, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `transaction_number` -- CREATE TABLE IF NOT EXISTS `transaction_number` ( `id` int(50) NOT NULL AUTO_INCREMENT, `trnno` int(50) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `transaction_number` -- INSERT INTO `transaction_number` (`id`, `trnno`) VALUES (1, 140); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(250) NOT NULL, `password` varchar(250) NOT NULL, `name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staff_id` int(11) NOT NULL, `status` int(11) NOT NULL, `loginpermission` int(11) NOT NULL, `del_status` int(11) NOT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `staff_id` (`staff_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`user_id`, `user_name`, `password`, `name`, `staff_id`, `status`, `loginpermission`, `del_status`) VALUES (1, 'admin', 'admin', 'Admin', 1, 0, 0, 0), (2, 'libin@mail.com', '1234567890', 'libin', 2, 0, 0, 0), (3, 'shafiqatar@gmail.com', '9495551185', 'SHAFI U.M.', 16, 0, 0, 0), (4, 'newlimara@gmail.com', '999999999', 'PRASANNAN', 4, 0, 1, 0), (5, 'newlimara@gmail.com', '122434343434`', 'SHEMEER.U', 19, 0, 0, 0), (6, 'newlimara@g.mail.com', '23434343', 'PRASANNAN', 20, 0, 1, 0), (7, 'newlimara@gmail.com', '919447337060', 'SHEHINA', 21, 0, 0, 0), (8, 'shafiqatar@gmail.com', '9495551185', 'SHAFI .U.M', 22, 0, 0, 0), (9, 'newlimara@gmail.com', '9746213794', 'NOUSHAD.U', 23, 0, 1, 0), (10, 'newlimara@gmail.com', '1111', 'MOHANAN PILLAI', 24, 0, 1, 0), (11, 'newlimara@gmail.com', '7012808692', 'SHAJI AHMED', 25, 0, 1, 0), (12, 'newlimara@gmail.com', '3434343434', 'SREEDEVI', 26, 0, 1, 0), (13, 'newlimara@gmail.com', '1111', 'LATHA', 27, 0, 1, 0), (14, 'newlimara@gmail.com', '343434', 'SHOBHANA', 28, 0, 1, 0), (15, 'newlimara@gmail.com', '9072885622', 'SUMESH', 29, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `vendor` -- CREATE TABLE IF NOT EXISTS `vendor` ( `client_id` int(11) NOT NULL AUTO_INCREMENT, `vendor_name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `vendoraddress` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `place` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tin` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `secphone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `delet` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`client_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `vendor` -- INSERT INTO `vendor` (`client_id`, `vendor_name`, `vendoraddress`, `email`, `place`, `tin`, `phone`, `secphone`, `delet`) VALUES (1, 'Sudhi', 'Kalayapuram', 'asas@ymail.com', 'Kalayapuram', '691304', '09895956900', '09895956900', 1), (2, 'Shafeek', 'Keralapuram', 'asas@ymail.com', 'Kalayapuram', '691560', '09895956900', '09895956900', 1), (7, 'Shafeek', 'Keralapuram', '123redsxf@gmai.com', 'Kalayapuram', '772314', '09895956900', '09895956900', 1), (8, 'MATHA PAPERS', 'CHAMAKKADA', 'matha@gmail.com', 'KOLLAM', '321111111', '9020061166', '9020061166', 0), (9, 'AYYARATH PAPERS', 'THAMARAKKULAM', 'ayyarath@gmail.com', 'KOLLAM', '321111111', '9947788338', '9947788338', 0), (10, 'SUNIL PRINTERS', 'KADAPPAKKADA', '', 'KOLLAM', '3211111111', '9745108664', '9745108664', 0), (11, 'STANDARD MACHINERY', 'TRIVANDRUM', '', 'TRIVANDRUM', '4334334434', '9387045335', '4712577360', 0), (12, 'MUTHU - BINDING', 'MUNDAKKAL', '', 'POLAYATHODE', '23434343434', '9526953608', '9526953608', 0), (13, 'ORANGE PRINTERS', 'TRIVANDRUM', '', 'TRIVANDRUM', '23434348793', '32343434344', '32343435555', 0), (14, 'RELIANCE TRADERS', 'CHAMAKKADA', '', 'KOLLAM', '34340343434', '2343434434343', '4343434343444', 0);