CREATE TABLE `avoucher` (
  `amount` int(11) DEFAULT NULL,
  `remarks` varchar(250) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expenseid` int(11) DEFAULT '0',
  `datee` date DEFAULT NULL,
  `branch` int(11) DEFAULT NULL,
  `invoiceid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `approvedby` int(11) NOT NULL,
  `paidto` int(11) NOT NULL,
  `typee` varchar(5) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=135232 DEFAULT CHARSET=utf8;

INSERT INTO avoucher VALUES("1000","asda","134773","398","2019-09-14","11","0","0","0","0","");
INSERT INTO avoucher VALUES("1000","asda","134770","398","2019-09-14","11","0","0","0","0","");
INSERT INTO avoucher VALUES("2000","aa","134771","397","2019-09-14","11","0","0","0","0","");
INSERT INTO avoucher VALUES("500","sda","134772","403","2019-09-14","11","0","0","0","0","");
INSERT INTO avoucher VALUES("2000","aa","134774","397","2019-09-14","11","0","0","0","0","");
INSERT INTO avoucher VALUES("500","sda","134775","403","2019-09-14","11","0","0","0","0","");
INSERT INTO avoucher VALUES("1000","asda","134776","398","2019-09-14","11","0","1","0","0","");
INSERT INTO avoucher VALUES("2000","aa","134777","397","2019-09-14","11","0","1","0","0","");
INSERT INTO avoucher VALUES("500","sda","134778","403","2019-09-14","11","0","1","0","0","");
INSERT INTO avoucher VALUES("1000","asda","134779","398","2019-09-14","11","0","1","0","0","");
INSERT INTO avoucher VALUES("2000","aa","134780","397","2019-09-14","11","0","1","0","0","");
INSERT INTO avoucher VALUES("500","sda","134781","403","2019-09-14","11","0","1","0","0","");
INSERT INTO avoucher VALUES("1000","s","134782","397","2019-09-14","11","0","1","808","1","");
INSERT INTO avoucher VALUES("2000","s","134783","398","2019-09-14","11","0","1","808","1","");
INSERT INTO avoucher VALUES("20000","","134784","0","2019-09-14","11","0","1","809","1","F");
INSERT INTO avoucher VALUES("1000","asd","134785","21","2019-09-14","11","0","1","1","808","G");
INSERT INTO avoucher VALUES("3000","asda","134786","17","2019-09-14","11","0","1","1","808","H-1");
INSERT INTO avoucher VALUES("5000","asd","134787","19","2019-09-14","11","0","1","1","808","H-2");
INSERT INTO avoucher VALUES("1000","invoice no 1 to 1000","134788","23","2019-09-15","11","0","1","1","808","E");
INSERT INTO avoucher VALUES("10000","inv no 1001 to 2000","134789","22","2019-09-15","11","0","1","1","808","E");
INSERT INTO avoucher VALUES("467","15","135142","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("600","14","135141","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("555","13","135140","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("456","12","135139","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("369","11","135138","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("352","10","135137","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("898","9","135136","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1000","8","135135","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1500","7","135134","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("875","6","135133","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("305","5","135132","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("500","4","135131","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("300","3","135130","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("201","2","135129","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1000","1","135128","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("555","13","135127","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("456","12","135126","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("369","11","135125","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("352","10","135124","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("898","9","135123","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1000","8","135122","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1500","7","135121","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("875","6","135120","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("305","5","135119","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("500","4","135118","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("300","3","135117","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("201","2","135116","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1000","1","135115","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("555","13","135114","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("456","12","135113","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("369","11","135112","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("352","10","135111","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("898","9","135110","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1000","8","135109","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1500","7","135108","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("875","6","135107","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("305","5","135106","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("500","4","135105","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("300","3","135104","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("369","11","135144","0","2019-09-16","11","0","1","0","1","B");
INSERT INTO avoucher VALUES("898","10","135143","0","2019-09-16","11","0","1","0","1","B");
INSERT INTO avoucher VALUES("1000","s","135148","14","2019-09-17","11","0","1","1","808","G");
INSERT INTO avoucher VALUES("300","2","135147","0","2019-09-16","11","0","1","0","808","C");
INSERT INTO avoucher VALUES("100","1","135146","0","2019-09-16","11","0","1","0","1","C");
INSERT INTO avoucher VALUES("5000","10","135230","0","2019-09-16","11","0","1","808","1","D");
INSERT INTO avoucher VALUES("3000","25","135229","0","2019-09-16","11","0","1","808","1","D");
INSERT INTO avoucher VALUES("200","sas","134836","15","2019-09-16","11","0","1","1","808","G");
INSERT INTO avoucher VALUES("255","ss","134837","16","2019-09-16","11","0","1","1","808","G");
INSERT INTO avoucher VALUES("1000","s","134838","17","2019-09-16","11","0","1","1","808","H-1");
INSERT INTO avoucher VALUES("3000","ss","134839","18","2019-09-16","11","0","1","1","808","H-1");
INSERT INTO avoucher VALUES("542","sas","134840","19","2019-09-16","11","0","1","1","809","H-2");
INSERT INTO avoucher VALUES("1020","asd","134841","20","2019-09-16","11","0","1","1","809","H-2");
INSERT INTO avoucher VALUES("5000","","135155","0","2019-09-17","11","0","1","1","808","F");
INSERT INTO avoucher VALUES("15000","as","135152","22","2019-09-16","11","0","1","1","1","E");
INSERT INTO avoucher VALUES("1000","","134846","397","2019-09-16","11","0","1","1","808","");
INSERT INTO avoucher VALUES("10000","","134847","407","2019-09-16","11","0","1","1","808","");
INSERT INTO avoucher VALUES("6000","","134848","398","2019-09-16","11","0","1","1","808","");
INSERT INTO avoucher VALUES("1000","","134849","397","2019-09-16","11","0","1","1","808","I");
INSERT INTO avoucher VALUES("500","","134850","403","2019-09-16","11","0","1","1","808","I");
INSERT INTO avoucher VALUES("600","","134851","398","2019-09-16","11","0","1","1","808","I");
INSERT INTO avoucher VALUES("201","2","135103","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("1000","1","135102","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("555","13","135101","0","2019-09-16","11","0","1","0","1","A");
INSERT INTO avoucher VALUES("300","15","135145","0","2019-09-16","11","0","1","0","1","B");
INSERT INTO avoucher VALUES("1000","1","135149","11","2019-09-17","11","0","1","1","808","G");
INSERT INTO avoucher VALUES("100","s","135150","11","2019-09-17","11","0","1","1","1","G");
INSERT INTO avoucher VALUES("1000","","135151","14","2019-09-16","11","0","1","1","808","G");
INSERT INTO avoucher VALUES("500","","135153","23","2019-09-16","11","0","1","1","1","E");
INSERT INTO avoucher VALUES("1000","m","135158","0","2019-09-17","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("3000","","135159","0","2019-09-17","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("1000","m","135160","0","2019-09-17","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("3000","","135161","0","2019-09-17","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("5000","","135231","0","2019-09-16","11","0","1","808","808","D");
INSERT INTO avoucher VALUES("1000","","135228","0","2019-09-16","11","0","1","808","808","D");
INSERT INTO avoucher VALUES("3000","","135223","0","2019-09-16","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("1000","m","135222","0","2019-09-16","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("3000","","135221","0","2019-09-16","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("1000","m","135220","0","2019-09-16","11","0","1","1","1","F");
INSERT INTO avoucher VALUES("5000","","135219","0","2019-09-16","11","0","1","1","808","F");





CREATE TABLE `cashinhand` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch` int(11) NOT NULL,
  `datee` date NOT NULL,
  `c5000` int(11) NOT NULL,
  `c1000` int(11) NOT NULL,
  `c500` int(11) NOT NULL,
  `c100` int(11) NOT NULL,
  `c50` int(11) NOT NULL,
  `c20` int(11) NOT NULL,
  `c10` int(11) NOT NULL,
  `c5` int(11) NOT NULL,
  `c2` int(11) NOT NULL,
  `c1` int(11) NOT NULL,
  `damage` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO cashinhand VALUES("3","11","2019-09-16","50000","10000","1500","2000","150","80","500","30","4","10","1","1");





CREATE TABLE `category` (
  `categoryid` int(11) NOT NULL AUTO_INCREMENT,
  `categoryname` varchar(50) DEFAULT NULL,
  `maincat` int(11) DEFAULT '0',
  `comm` int(11) NOT NULL,
  PRIMARY KEY (`categoryid`),
  KEY `categoryid` (`categoryid`),
  KEY `categoryid_2` (`categoryid`)
) ENGINE=MyISAM AUTO_INCREMENT=410 DEFAULT CHARSET=utf8;

INSERT INTO category VALUES("396","Transport","7","0");
INSERT INTO category VALUES("397","Fuel","7","0");
INSERT INTO category VALUES("398","Meal","9","0");
INSERT INTO category VALUES("399","Hygiene","6","0");
INSERT INTO category VALUES("400","Plumber Etc","6","0");
INSERT INTO category VALUES("401","Electrician","6","0");
INSERT INTO category VALUES("402","Network - IT","6","0");
INSERT INTO category VALUES("403","Barcode","4","0");
INSERT INTO category VALUES("404","Shoppers","4","0");
INSERT INTO category VALUES("405","Rent","4","0");
INSERT INTO category VALUES("406","Utility Bills","4","0");
INSERT INTO category VALUES("407","Recovery","4","0");
INSERT INTO category VALUES("408","Employees Salaries","1","0");
INSERT INTO category VALUES("409","Any Other","5","0");





CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `namee` varchar(50) NOT NULL,
  `address` text NOT NULL,
  `link` text NOT NULL,
  `priority` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;

INSERT INTO customers VALUES("1","Dr. Noor ZaitunYahaya(PhD, UK)","Senior Lecturer Air Pollution,
School of Ocean Engineering,
University Malaysia Terengganu,
21030, Terengganu,
Malaysia.
","Senior Editor","9");
INSERT INTO customers VALUES("2","Dr. Mohammad Rehan","Assistant Professor (PhD, UK),
Center of Excellence in Environmental Studies (CEES), King Abdulaziz University, Jeddah, Saudi Arabia.
","Senior Editor ","8");
INSERT INTO customers VALUES("46","Dr. SafwatGabr","Associate Professor of GIS and RemoteSensing (PhD USA),
National Authority for Remote Sensing and Space Sciences (NARSS),
Geological Applications and Mineral Resources Division, Cairo, Egypt.
","Senior Editor","6");
INSERT INTO customers VALUES("45","Dr.  Asad Ali","Department of Agriculture, Abdul Wali Khan University Mardan, KPK, Pakistan.","Managing Editor","4");
INSERT INTO customers VALUES("44","Dr. Fazal Munsif","Department of Agronomy
The University of Agriculture, Peshawar
Pakistan
","Managing Editor","3");
INSERT INTO customers VALUES("43","Dr. Davey Jones","Environment Center Wales
Bangor University, UK
","Senior Editor","5");
INSERT INTO customers VALUES("42","Dr. Said Munir","Department of Environmental and Health Research, Hajj Research Institute, Umm Al-Qura University, Makkah, Saudi Arabia. ","Editors-in-Chief ","2");
INSERT INTO customers VALUES("41","Dr. Kawsar Ali ","Department of Agriculture, Abdul Wali Khan University Mardan, KPK, Pakistan.","Editors-in-Chief","1");
INSERT INTO customers VALUES("47","Dr. Turki Habeeb ullah","Associate Professor(PhD, UK), Department of Environmental and Health Research, Hajj Research Institute, Umm Al-Qura University, Makkah, Saudi Arabia. ","Senior Editor","10");
INSERT INTO customers VALUES("48","Dr. Abdel Hameed Awad","Professor in Atmospheric Biology, Air pollution Department, National Research Center, Cairo, Egypt.","Editorial Board Member","17");
INSERT INTO customers VALUES("49","Dr. Atef Fathy Mohammed","Assistant Professor, Air pollution Department, National Research Center, Cairo, Egypt.","Editorial Board Member","18");
INSERT INTO customers VALUES("50","Dr. Ayeni Laye Samul ","Professor in Soil Science Department of Agricultural Science, Adeyemi College of Education, Ondo, Ondo State, Nigeria.","Editorial Board Member","19");
INSERT INTO customers VALUES("51","Dr. Muhammad Arif","Agronomy Department
The University of Agriculture, Peshawar
","Senior Editor ","7");
INSERT INTO customers VALUES("52","Dr Xuechun Wang","School of life science and technology
South West University of Science and Technology
No.59, Qinglong Road, Mianyang, Sichuan (621010), China
","Editorial Board Member","21");
INSERT INTO customers VALUES("53","Dr. Antonio Rodriguez","Environment Center Wales, Bangor University, UK Wales","Editorial Board Member","20");
INSERT INTO customers VALUES("54","Dr. Abdur Rab","Department of Horticulture The University of Agriculture Peshawar Pakistan","Senior Editor","15");
INSERT INTO customers VALUES("55","Dr. Faheem Shahzad ","Assistant Professor
Department of Field Crops
Faculty of Agricultural and Natural Science
Abant Izzet Baysal University
Bolu-Turke","Editorial Board Member","22");
INSERT INTO customers VALUES("56","Dr. Azmat Ali Awan","Scientific Officer
Pakistan Oil Seed Development Board","Senior Editor","16");
INSERT INTO customers VALUES("57","Dr. Zubair Aslam","Assistant Professor,
Plant & Microbial Ecology Lab.,
Department of Agronomy,
University of Agriculture,
Faisalabad-Pakistan","Editorial Board Member","23");
INSERT INTO customers VALUES("58","Dr. Muhammad Jamal Khan","Professor in SES,  Department of Soil and Environmental Sciences, University of Agriculture, Peshawar, KPK, Pakistan.","Senior Editor","14");
INSERT INTO customers VALUES("59","Dr. Farooq Shah","Department of Agriculture, Abdul Wali Khan University, Mardan, KPK, Pakistan.","Editorial Board Member","24");
INSERT INTO customers VALUES("60","Dr. Naila Mukhtar","Botany, Agriculture University, Faisalabad, Punjab, Pakistan.","Editorial Board Member","25");
INSERT INTO customers VALUES("61","Dr. Hassan Sher","Center for Plant Sciences and Biodiversity, University of Swat, Pakistan","Editorial Board Member","29");
INSERT INTO customers VALUES("62","Dr.  Fahad Rasul","Agriculture/Agronomy, Agriculture University, Faisalabad, Punjab, Pakistan. ","Senior Editor","12");
INSERT INTO customers VALUES("63","Miss Zobia Rahim","Botany Department,
The University for Women Swabi
","Editorial Board Member","31");
INSERT INTO customers VALUES("64","Dr. Tabassum Yaseen","Botany, Bacha Khan University, Charsadda, KPK, Pakistan.","Editorial Board Member","26");
INSERT INTO customers VALUES("65","Dr. Ahmad Khan","Agriculture/Agronomy, Agriculture University Peshawar, KPK, Pakistan.","Editorial Board Member","27");
INSERT INTO customers VALUES("66","Dr. Farhat ullah","Professor PBG,Agriculture University Peshawar, KPK, Pakistan.","Editorial Board Member","29");
INSERT INTO customers VALUES("67","Dr. Mian Said","Professor/Entomogly, University of Swabi, KPK, Pakistan.","Editorial Board Member","28");
INSERT INTO customers VALUES("68","Miss. Shazia Dilber","Lecturer, Center for Plant Sciences and Biodiversity, University of Swat, Pakistan
","Editorial Board Member","30");
INSERT INTO customers VALUES("69","Mr. Riaz ud Din","Lecturer in English, Government College of Management Sciences Sangota, Swat","Editorial Board Member","32");
INSERT INTO customers VALUES("70","Dr. Inam Ullah","Agronomy Department The University of Agriculture Peshawar Pakistan","Editorial Board Member","24");
INSERT INTO customers VALUES("71","Dr. ZANE VINCÄ’VIÃâ","Senior researcher at the University of Latvia, Department of Environmental Science; head of the Laboratory of Environmental Quality Monitoring","Senior Editor","15");
INSERT INTO customers VALUES("72","Dr. Omer Bashir ","Microbiology and Infectious Diseases 	Hujj Research Institute, 	Umm Al-Qura University Makkah","Senior Editor","6");
INSERT INTO customers VALUES("73","Mr. Saeed Ahmed ","Department of Horticulture 	State University of Londrina Centre of Agriculture Sciences Londrina, Parana (PR) Brazil","Editorial Board Member","20");
INSERT INTO customers VALUES("74","Mr. Nazeer Ahmed ","Key Laboratory of Crop Stress Biology for Arid Areas,  	Northwest A&F University-Yangling,China","Editorial Board Member","20");
INSERT INTO customers VALUES("75","Dr. Zahid Hussain","Department of weeds Sciences, University of Agriculture, Peshawar","Editorial Board Member","23");
INSERT INTO customers VALUES("76","Dr. Mukhtar Alam","Professor, Department of Agriculture, University of Swabi","Senior Editor","7");
INSERT INTO customers VALUES("77","Dr. Fazal Jalal","Department of Botany, Kohat University of Science & Technology, Kohat, Pakistan","Editorial Board Member","20");
INSERT INTO customers VALUES("78","Professor Denis Wright","Director of Student Support Sherfield Building Imperial College London London SW7 2AZ U.K.","Senior Editor","8");
INSERT INTO customers VALUES("79","Abu Hassan Ahmad","Professor School of Biological Sciences University Sains Malaysia","Senior Editor","8");
INSERT INTO customers VALUES("80","Dr. Kyeong-Yeoll Lee","Professor Lab. of Insect Molecular Physiology School of Applied Bioscience College of Agriculture & Life Sciences Kyungpook National University Republic of Korea","Senior Editor","8");
INSERT INTO customers VALUES("81","Dr. Abdul Hafiz AB Majid","Senior Lecturer  (Urban & Molecular Entomology) Household & Structural Urban Entomology Laboratory, School of Biological Sciences, Universiti Sains Malaysia, MALAYSIA","Senior Editor","8");
INSERT INTO customers VALUES("82","Dr. Murat Kaya","Associate Professor Department of Biotechnology and Molecular Biology, Aksaray University, 68100, Aksaray, Turkey","Senior Editor","8");
INSERT INTO customers VALUES("83","Dr. Byung-Wook Yun","Professor Division of Plant Biosciences,  School of Applied BioSciences, College of Agriculture & Life Science Kyungpook National University, Korea","Senior Editor","8");
INSERT INTO customers VALUES("84","Dr. Bao-Li Qiu","Professor of Entomology Head of Department of Entomology South China Agricultural University Wushan Rd., Tianhe, Guangzhou 510642, China","Senior Editor","8");
INSERT INTO customers VALUES("85","Prof. Ayhan G.K.E","NiÄŸde University Faculty of Agricultural Sciences and Technologies Merkez YerleÅŸke/NiÄŸde 51240 Turkey","Senior Editor","8");
INSERT INTO customers VALUES("86","Dr. Asmida Ismail ","Senior Lecturer, School of Biology,  Faculty of Applied Sciences, Universiti Teknologi MARA, Shah Alam, Selangor, 	Malysia","Senior Editor ","14");
INSERT INTO customers VALUES("87","Dr. Che Salmah Md Rawi","Professor of Entomology 	School of Biological Sciences 	University Sains Malaysia 	11800 Penang, Malaysia","Senior Editor ","15");
INSERT INTO customers VALUES("88","Dr Mohammad Majid Mehmood Bagram","Allama Iqbal Open University Islamabad Pakistan.
","Editorial Board Member","0");
INSERT INTO customers VALUES("89","Dr Ubaldo Comite","University Telemetica E-Campus Novedrate Como","Editorial Board Member","0");
INSERT INTO customers VALUES("90","Dr P. Malyadri","Government Degree College Osmania University India.
","Editorial Board Member","0");
INSERT INTO customers VALUES("91","Dr Arshad Zaheer","Army Public College of Management Sciences (APCOMS) Pakistan.
","Editorial Board Member","0");
INSERT INTO customers VALUES("92","Dr Nasser Fegh Hi Farahmand","Islamic Azad University Tabriz Iran.
","Editorial Board Member","0");
INSERT INTO customers VALUES("93","Dr Nurul Fadly Habidin","University Penris","Editorial Board Member","0");
INSERT INTO customers VALUES("94","Warner Jack","King Fahd University of Petroleum & Minerals Saudi Arabia.
","Editorial Board Member","0");
INSERT INTO customers VALUES("95","Dr Badar Alam Iqbal","Monarch University Switzerland.
","Editorial Board Member","0");
INSERT INTO customers VALUES("96","Dr Mohammad Reza Iravani","Islamic Azad University","Editorial Board Member","0");
INSERT INTO customers VALUES("97","Dr Abubakar Sambo Junaidu","Faculty of Management Sciences Usmanu Dan Fodio university Sokoto","Editorial Board Member","0");
INSERT INTO customers VALUES("98","Dr Iancu Eugenia","Stefan Cel Mare University","Editorial Board Member","0");
INSERT INTO customers VALUES("99","Dr Anasua Sarkar","Govt College of Engineering and Leather Technology","Editorial Board Member","0");
INSERT INTO customers VALUES("100","Dr Muhammad Sabbir Rahman","Faculty of Languages and Management","Editorial Board Member","0");
INSERT INTO customers VALUES("101","Dr William R. DiPietro","Daemen College United States.
","Editorial Board Member","0");
INSERT INTO customers VALUES("102","Dr Muhammad Zia Ur Rehman","National University of Modern Languages","Editorial Board Member","0");
INSERT INTO customers VALUES("103","Dr Bostan D Lonel","Al. I. Cuza University Economics Faculty Iasi Romania.
","Editorial Board Member","0");
INSERT INTO customers VALUES("104","Dr Alireza Miremadi","Graduate School of Management and Economics Sharif University of Technology Iran.
","Editorial Board Member","0");
INSERT INTO customers VALUES("105","Dr Rosman Bin MD.Yusoff","Universiti Teknologi Malaysia.
","Editorial Board Member","0");
INSERT INTO customers VALUES("106","Dr Cibotariu Irina Stefana","Stefan Cel Mare University","Editorial Board Member","0");
INSERT INTO customers VALUES("107","Dr Kamran Pashaei Fakhri","University of Tabriz Iran.
","Editorial Board Member","0");
INSERT INTO customers VALUES("108","Dr Ravi Kumar Bommisetti","Sree Vidyanikethan Engineering College","Editorial Board Member","0");
INSERT INTO customers VALUES("109","Dr Kamyar Kavosh","University Technology Malaysia","Editorial Board Member","0");
INSERT INTO customers VALUES("110","Dr Akyay Uygur","Tourism Faculty","Editorial Board Member","0");
INSERT INTO customers VALUES("111","Dr Agbada Andrew Omosioni","Delta State University Asaba Campus Nigeria.
","Editorial Board Member","0");
INSERT INTO customers VALUES("112","Dr Chin Tsai Kuo","National Ment of Physical Education","Editorial Board Member","0");
INSERT INTO customers VALUES("113","Dr Noor Mohammad","Universiti Kebangsaan Malaysia (UKM).
","Editorial Board Member","0");
INSERT INTO customers VALUES("114","Dr Madan Lal Bhasin","Bang College of Business KIMEP University Republic of Kazakhstan.
","Editorial Board Member","0");
INSERT INTO customers VALUES("115","Dr Lewlyn L. R. Rodrigues","Manipal Institute of Technology India.
","Editorial Board Member","0");
INSERT INTO customers VALUES("116","Dr Angela Roman","Faculty of Economics and Business Administration Alexandru Ioan Cuza University of Iasi","Editorial Board Member","0");
INSERT INTO customers VALUES("117","Dr Mohammad Reza Mohammadi","Faculty of Management and Accounting","Editorial Board Member","0");
INSERT INTO customers VALUES("118","Dr Abdul Aziz Abdullah","Universiti Sultan Zainal Abidin Malaysia.
","Editorial Board Member","0");
INSERT INTO customers VALUES("119","Dr Moh Adenan","Faculty of Economics University of Jember","Editorial Board Member","0");
INSERT INTO customers VALUES("120","Dr Anupam Mitra","Associate Professor TeamLease Skills University","Editorial Board Member","0");
INSERT INTO customers VALUES("121","Dr Abdurrahim Emhan","Selahaddin Eyyubi University","Editorial Board Member","0");
INSERT INTO customers VALUES("122","Dr Sami Bacha","Assistant Professor at the University of Economic Sciences and Management-Sousse Tunisia.
","Editorial Board Member","0");
INSERT INTO customers VALUES("123","Dr Katarzyna Rostek","Faculty of Management Warsaw University of Technology Ul. Narbutta 85","Editorial Board Member","0");
INSERT INTO customers VALUES("124","Dr Randa Abdel Aziz Mohamed El Bedawy Fouad","Faculty of Business Administration & International Trade - MIU Egypt.
","Editorial Board Member","0");
INSERT INTO customers VALUES("125","Dr Mousa A. Masadeh","Assistant Professor. Department of Hotel and Tourism Management","Editorial Board Member","0");
INSERT INTO customers VALUES("126","Dr Mousa Rezvani Chamanzamin","Assistant Professor of Marketing Management","Editorial Board Member","0");
INSERT INTO customers VALUES("128","Dr George Abuselidze","","Editorial Board Member","0");
INSERT INTO customers VALUES("129","Dr Justin Nsengiyumva","University of Leicester","Editorial Board Member","0");
INSERT INTO customers VALUES("130","Dr Mukdad Mohammad Ibrahim","Associate Professor","Editorial Board Member","0");
INSERT INTO customers VALUES("132","Hassan Jafari","University of Marine Science and Technology","Editorial Board Member","0");
INSERT INTO customers VALUES("133","Ahmad Rasmi Suleiman Albattat","School of Housing","Editorial Board Member","0");
INSERT INTO customers VALUES("134","Bahman Kargar Shahamat","Instructor of Management Dept","Editorial Board Member","0");
INSERT INTO customers VALUES("135","Karen P. Quilloy","University of the Philippines Los Baños","Editorial Board Member","0");
INSERT INTO customers VALUES("136","PROF. DR. J. GAJENDRA NAIDU","Head of the Department: Faculty of Finance, Head of the Department, Faculty of Finance Botho university: Gaborone Campus: Botswana","Senior Editor","10");





CREATE TABLE `maincat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maincat` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `maincat` (`maincat`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

INSERT INTO maincat VALUES("1","Salaries");
INSERT INTO maincat VALUES("4","Misc");
INSERT INTO maincat VALUES("5","Others");
INSERT INTO maincat VALUES("6","Maintenance");
INSERT INTO maincat VALUES("7","Fuels - Transport");
INSERT INTO maincat VALUES("9","Meals");





CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menuname` varchar(25) NOT NULL,
  `priority` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

INSERT INTO menu VALUES("5","Admin","1");
INSERT INTO menu VALUES("6","Employees","6");
INSERT INTO menu VALUES("27","Sales","2");
INSERT INTO menu VALUES("28","Payments","3");
INSERT INTO menu VALUES("29","Expenses","7");
INSERT INTO menu VALUES("30","Reports","4");





CREATE TABLE `organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT 'Mansehra',
  `country` varchar(50) DEFAULT NULL,
  `Mobile` varchar(50) DEFAULT NULL,
  `Phone2` varchar(50) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `orgtype` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

INSERT INTO organization VALUES("11","Branch 1","LRH Road,","+92 91 000000","PESHAWAR","Pakistan","","","","ab","1");
INSERT INTO organization VALUES("13","Branch 2","Gulbahar No 1","+92 91 000000","Peshawar","Pakistan","","","","as","1");
INSERT INTO organization VALUES("14","Branch 3","University Town","+92 91 000000","Peshawar","Pakistan","","","","as","1");
INSERT INTO organization VALUES("15","Local 1","asss","","Peshawar","Pakistan","","","","sibpak@hotmail.com","2");
INSERT INTO organization VALUES("16","local 2","","","","","","","","sa","2");
INSERT INTO organization VALUES("17","Company 1","","","","","","","","asd","3");
INSERT INTO organization VALUES("18","Company 2","","","","","","","","asd","3");
INSERT INTO organization VALUES("19","Warehouse 1","","","","","","","","sad","4");
INSERT INTO organization VALUES("20","Warehouse 2","","","","","","","","as","4");
INSERT INTO organization VALUES("21","local 3","","","","","","","","Ashoorsan50@gmail.com","2");
INSERT INTO organization VALUES("22","Bank 1","address","","Peshawar","Pakistan","","","","sibpak@hotmail.com","5");
INSERT INTO organization VALUES("23","Bank 2","Address","","Peshawar","Pakistan","","","","sibpak@hotmail.com","5");





CREATE TABLE `orgtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO orgtype VALUES("1","BRANCHES");
INSERT INTO orgtype VALUES("2","LOCAL PURCHASES");
INSERT INTO orgtype VALUES("3","PARTY PAYMENTS (COMPANIES) ");
INSERT INTO orgtype VALUES("4","PARTY PAYMENTS (WAREHOUSE)");
INSERT INTO orgtype VALUES("5","BANKS");





CREATE TABLE `page2` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `pagename` varchar(100) DEFAULT NULL,
  `Links` varchar(100) DEFAULT NULL,
  `type1` int(11) DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `pagepriority` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=394 DEFAULT CHARSET=utf8;

INSERT INTO page2 VALUES("11","New User","userinsert.php","6","1","3");
INSERT INTO page2 VALUES("18","Edit User","users.php","6","1","4");
INSERT INTO page2 VALUES("35","Assign Pages","selectuser.php","5","1","8");
INSERT INTO page2 VALUES("85","Add New Page","addnewpage.php","5","1","5");
INSERT INTO page2 VALUES("86","Edit Page Links","editallpages.php","5","1","6");
INSERT INTO page2 VALUES("87","Logout","logout.php","5","1","10");
INSERT INTO page2 VALUES("209","Change Password","changepass.php","5","1","9");
INSERT INTO page2 VALUES("295","BACKUP DATABASE","backup.php","5","1","7");
INSERT INTO page2 VALUES("380","Main Category","maincategory.php","29","1","1");
INSERT INTO page2 VALUES("305","New Board Member","newcustomer.php","30","0","1");
INSERT INTO page2 VALUES("306","Edit Editorial Board","editallcustomer.php","30","0","2");
INSERT INTO page2 VALUES("307","New Paper","newpaper.php","27","0","0");
INSERT INTO page2 VALUES("383","Local Purchases & U-Branches","cpv1.php?rows=50","28","1","0");
INSERT INTO page2 VALUES("312","Add News","addnews.php","28","0","0");
INSERT INTO page2 VALUES("313","Edit News","editnews.php","28","0","0");
INSERT INTO page2 VALUES("320","New Indexing","newindexing.php","27","0","0");
INSERT INTO page2 VALUES("322","Edit Indexing","editindexing.php","27","0","0");
INSERT INTO page2 VALUES("382","Daily Expenses","cpv.php?rows=50","29","1","3");
INSERT INTO page2 VALUES("377","Branches / Parties","viewallorg.php","5","1","2");
INSERT INTO page2 VALUES("381","Sub Category","category.php","29","1","2");
INSERT INTO page2 VALUES("384","Party Payments (Companies)","cpv2.php?rows=50","28","1","0");
INSERT INTO page2 VALUES("385","Party Payments (Warehouse)","cpv3.php?rows=50","28","1","0");
INSERT INTO page2 VALUES("386","Advance Salaries / Loans","cpv4.php?rows=50","28","1","0");
INSERT INTO page2 VALUES("387","Daily Sales","cpv8.php?rows=50","27","1","0");
INSERT INTO page2 VALUES("388","Cash Sales Return","cpv7.php?rows=50","27","1","0");
INSERT INTO page2 VALUES("389","Credit Received Back","cpv6.php?rows=50","27","1","0");
INSERT INTO page2 VALUES("390","Credit Medicine","cpv5.php?rows=50","28","1","0");
INSERT INTO page2 VALUES("391","Bank Deposits","cpv9.php?rows=50","28","1","0");
INSERT INTO page2 VALUES("392","Datewise / Branchwise Report","fullreport.php","30","1","0");
INSERT INTO page2 VALUES("393","Cash In Hand","cashinhand.php","27","1","0");





CREATE TABLE `pagesusers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `page` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`page`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=15116 DEFAULT CHARSET=utf8;

INSERT INTO pagesusers VALUES("15115","rajwali","87");
INSERT INTO pagesusers VALUES("15114","rajwali","209");
INSERT INTO pagesusers VALUES("15113","rajwali","295");





CREATE TABLE `users` (
  `username` varchar(50) NOT NULL,
  `passw` varchar(50) DEFAULT NULL,
  `Type1` varchar(50) DEFAULT NULL,
  `branch` int(50) DEFAULT NULL,
  `email` varbinary(100) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mobile` varchar(50) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `salary` int(11) NOT NULL,
  `joiningdate` date NOT NULL,
  `resigndate` date NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `designation` varchar(100) NOT NULL,
  PRIMARY KEY (`username`,`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=810 DEFAULT CHARSET=utf8;

INSERT INTO users VALUES("sibtain","654342","Admin","11","","1","","","0","0000-00-00","0000-00-00","1","");
INSERT INTO users VALUES("aaa","","User","11","","809","","a","0","0000-00-00","0000-00-00","0","a");
INSERT INTO users VALUES("rajwali","1234","User","11","","808","03342211906","Raj","10000","2019-06-13","0000-00-00","1","Dessig");