| Server IP : 108.163.255.210 / Your IP : 3.14.254.103 Web Server : Apache System : Linux blossom.urlnameserver.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64 User : ( 1172) PHP Version : 7.2.34 Disable Function : eval,escapeshellarg,proc_close,proc_get_status,proc_nice,proc_open,symlink,system,pcntl_exec,getrusage,chown,chgp,closelog,openlog,syslog,define_syslog_variables,php_ini_loaded_file,getservbyname,getservbyport,posix_getgid,posix_getgrgid,proc_terminate,pfsockopen,apache_child_terminate,posix_mkfifo,posix_setpgid,posix_setuid,hypot,pg_host,pos,posix_access,posix_getcwd,posix_getservbyname,myshellexec,getpid,posix_getsid,posix_isatty,posix_kill,posix_mknod,posix_setgid,posix_setsid,posix_setuid,posix_times,posix_uname,ps_fill,posix_getpwuid,global,ini_restore,zip_open,zip_read,rar_open,bzopen,bzread,bzwrite,apache_get_modules,apache_get_version,phpversionphpinfo,php_ini_scanned_files,get_current_user,disk_total_space,diskfreespace,leak,imap_list,hypo,filedump,safe_mode,getmygid,apache_getenv,apache_setenv,bzread,bzwrite,bzopen,phpini,higlight_file,dos_conv,get_cwd,er_log,cmd,e_name,vdir,get_dir,only_read,ftok,ftpexec,posix_getpwnam,mysql_list_dbs,disk_free_space,session_save_path,confirm_phpdoc_compiled,zip_entry_rea,php_u,psockopen,crack_opendict,crack_getlastmessage,crack_closedict,crack_check,fpassthru,posix_get_last_error,posix_getlogin,posix_getgroups,posix_strerror,posix_getrlimit,posix_getpgrp,posix_getgrnam,pos,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/unilinki/www/payroll/admin/ |
Upload File : |
DROP TABLE admin;
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT,
`roleid` varchar(11) NOT NULL,
`classid` bigint(20) NOT NULL,
`branch` varchar(150) NOT NULL,
`username` varchar(100) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`useremail` varchar(100) NOT NULL,
`userimage` varchar(255) NOT NULL,
`status` varchar(50) NOT NULL,
PRIMARY KEY (`admin_id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `useremail` (`useremail`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
INSERT INTO admin VALUES("66","1","0","","admin","Concord","Logistics","admin","gunjansolutree@gmail.com","","yes");
INSERT INTO admin VALUES("67","2","0","DFH","gunjantyagi75@gmail.com","gunjan","tyagi","123","gunjantyagi75@gmail.com","","yes");
INSERT INTO admin VALUES("68","4","0","DFH","sahil@gmail.com","sahil","tyagi","123","sahil@gmail.com","","yes");
INSERT INTO admin VALUES("69","2","0","DFH","sadasd","dsadsa","sadsa","123","sad@f.com","","yes");
DROP TABLE allowance;
CREATE TABLE `allowance` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`branch` varchar(80) NOT NULL,
`name` varchar(250) NOT NULL,
`type` varchar(250) NOT NULL,
`value` varchar(250) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
INSERT INTO allowance VALUES("7","DFH","HR1","Fixed","322");
INSERT INTO allowance VALUES("8","DFH","wedw","Fixed","123");
DROP TABLE attendance;
CREATE TABLE `attendance` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`splallow` float NOT NULL DEFAULT '0',
`washallow` float NOT NULL DEFAULT '0',
`splallow1` float NOT NULL DEFAULT '0',
`washallow1` float NOT NULL DEFAULT '0',
`id` varchar(250) NOT NULL,
`company` text NOT NULL,
`date1` varchar(250) NOT NULL,
`wd` float NOT NULL DEFAULT '0',
`wo` float NOT NULL DEFAULT '0',
`wp` float NOT NULL DEFAULT '0',
`pd` varchar(250) NOT NULL DEFAULT '0',
`ot` float NOT NULL DEFAULT '0',
`gbpay` float NOT NULL DEFAULT '0',
`hra` float NOT NULL DEFAULT '0',
`conv` float NOT NULL DEFAULT '0',
`total` float NOT NULL DEFAULT '0',
`gbpay1` float NOT NULL DEFAULT '0',
`hra1` float NOT NULL DEFAULT '0',
`conv1` float NOT NULL DEFAULT '0',
`overtime` float NOT NULL DEFAULT '0',
`total1` float NOT NULL DEFAULT '0',
`gbpay2` float NOT NULL DEFAULT '0',
`hra2` float NOT NULL DEFAULT '0',
`conv2` float NOT NULL DEFAULT '0',
`total2` float NOT NULL DEFAULT '0',
`epf` float NOT NULL DEFAULT '0',
`esi` float NOT NULL DEFAULT '0',
`lwf` varchar(250) NOT NULL DEFAULT '0',
`canteen` float NOT NULL DEFAULT '0',
`total3` float NOT NULL DEFAULT '0',
`net` float NOT NULL DEFAULT '0',
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;
INSERT INTO attendance VALUES("55","0","0","0","0","123","DFH","2016-05","30","3","27","","0","15000","0","0","15000","15000","0","0","0","15000","0","0","0","0","1800","262.5","0","0","2062.5","12937.5");
INSERT INTO attendance VALUES("56","0","0","0","0","5909","DFH","2016-05","30","1","29","","0","13000","0","0","13000","13000","0","0","0","13000","0","0","0","0","1560","227.5","0","0","1787.5","11212.5");
INSERT INTO attendance VALUES("57","0","0","0","0","9853","DFH","2016-05","0","0","0","","0","16000","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
INSERT INTO attendance VALUES("58","0","0","0","0","123","DFH","2015-06","30","2","28","","0","15000","0","0","15000","15000","0","0","0","15000","0","0","0","0","1800","262.5","0","0","2062.5","12937.5");
INSERT INTO attendance VALUES("59","0","0","0","0","5909","DFH","2015-06","0","0","0","","0","13000","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
INSERT INTO attendance VALUES("60","0","0","0","0","9853","DFH","2015-06","0","0","0","","0","16000","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
DROP TABLE class;
CREATE TABLE `class` (
`classid` bigint(20) NOT NULL AUTO_INCREMENT,
`classname` varchar(32) NOT NULL,
PRIMARY KEY (`classid`),
UNIQUE KEY `classname` (`classname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE companies;
CREATE TABLE `companies` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`address` text NOT NULL,
`city` varchar(250) NOT NULL,
`state` varchar(250) NOT NULL,
`country` varchar(100) NOT NULL,
`mno1` varchar(20) NOT NULL,
`mno2` varchar(20) NOT NULL,
`email` text NOT NULL,
`added_date` datetime NOT NULL,
`over_time` varchar(80) NOT NULL,
`status` varchar(25) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
INSERT INTO companies VALUES("2","DFH","Gurgaon","Gurgaon","Haryana","India","45435435435","56765765756","dshfsd@gmail.com","2015-06-01 13:38:23","30","yes");
INSERT INTO companies VALUES("4","test","test","delhi","delhi","india","8888888888","","solutreebackup@gmail.com","2016-04-12 12:30:38","1000","yes");
INSERT INTO companies VALUES("6","Delhi branch","rohini","gurgaon","hr","india","878778877878","77887878787","demo@gmail.com","2016-04-13 16:11:37","11","yes");
DROP TABLE company_leave;
CREATE TABLE `company_leave` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`company` varchar(250) NOT NULL,
`name` varchar(250) NOT NULL,
`type` varchar(250) NOT NULL,
`nd` varchar(10) NOT NULL,
`encash` varchar(100) NOT NULL,
`carryover` varchar(100) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
INSERT INTO company_leave VALUES("2","DFH","Personal Leave","Yearly","10","Yes","No");
DROP TABLE deduction;
CREATE TABLE `deduction` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`branch` varchar(80) NOT NULL,
`name` varchar(250) NOT NULL,
`type` varchar(250) NOT NULL,
`value` varchar(250) NOT NULL,
`cc` varchar(250) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
INSERT INTO deduction VALUES("4","DFH","PFe","Fixed","1003","");
INSERT INTO deduction VALUES("5","delhi branch","eff","Percentage","34","");
DROP TABLE e_allowance;
CREATE TABLE `e_allowance` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`id` varchar(250) NOT NULL,
`name` text NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
INSERT INTO e_allowance VALUES("21","20426","PF");
INSERT INTO e_allowance VALUES("22","20426","HRA");
DROP TABLE e_deduction;
CREATE TABLE `e_deduction` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`id` varchar(250) NOT NULL,
`name` text NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
INSERT INTO e_deduction VALUES("4","1891","Annual Function");
INSERT INTO e_deduction VALUES("5","8556","Annual Function");
INSERT INTO e_deduction VALUES("6","11506","Annual Function");
INSERT INTO e_deduction VALUES("7","20426","Annual Function");
DROP TABLE employee;
CREATE TABLE `employee` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`company` text NOT NULL,
`designation` text NOT NULL,
`d_o_J` varchar(50) NOT NULL,
`qualification` text NOT NULL,
`b_salary` text NOT NULL,
`emailid` varchar(255) NOT NULL,
`phone_number` varchar(25) NOT NULL,
`allowance` text NOT NULL,
`deduction` text NOT NULL,
`id` varchar(250) NOT NULL,
`password` varchar(50) NOT NULL DEFAULT '654321',
`fname` varchar(150) NOT NULL,
`dob` varchar(40) NOT NULL,
`pf` varchar(40) NOT NULL,
`pca` varchar(40) NOT NULL,
`esi` varchar(40) NOT NULL,
`cl` decimal(10,0) NOT NULL,
`pl` decimal(10,0) NOT NULL,
`month` varchar(50) NOT NULL,
`status` varchar(25) NOT NULL,
`added_date` datetime NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
INSERT INTO employee VALUES("16","Gunjan","DFH","se","2015-01-19","mca","15000","","","","","123","654321","DP tyagi","1990-03-16","pf001/8687687-uirye-89324978/45","435435435435","435435435","0","0","0","","2015-06-19 13:12:57");
INSERT INTO employee VALUES("17","saim","DFH","sd","2015-06-28","sads","13000","test@tes.com","1234567890","","","5909","654321","dsad","2015-06-20","htr3534534/75675/676","43543534","43543","0","0","0","yes","2015-06-19 13:53:26");
INSERT INTO employee VALUES("18","John","DFH","mechanic","2012-06-16","btech","16000","demo@gmail.com","7531071962","","","9853","654321","Luther","16-03-90","HR212331ASD/ER45","2323223","23232332","0","0","0","yes","2016-04-13 16:23:01");
DROP TABLE leave_management;
CREATE TABLE `leave_management` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`uid` varchar(80) NOT NULL,
`type` varchar(50) NOT NULL,
`number` decimal(10,0) NOT NULL,
`month` varchar(50) NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
INSERT INTO leave_management VALUES("53","123","cl","3","2016-05");
INSERT INTO leave_management VALUES("63","123","cl","2","2015-06");
DROP TABLE manual_salary;
CREATE TABLE `manual_salary` (
`sno` int(11) NOT NULL AUTO_INCREMENT,
`company` varchar(300) NOT NULL,
`eid` varchar(30) NOT NULL,
`month` varchar(50) NOT NULL,
`wd` varchar(10) NOT NULL,
`wo` varchar(10) NOT NULL,
`pd` varchar(10) NOT NULL,
`basic` varchar(40) NOT NULL,
`hra` varchar(40) NOT NULL,
`conv` varchar(40) NOT NULL,
`epf` varchar(40) NOT NULL,
`esi` varchar(40) NOT NULL,
`lwf` varchar(40) NOT NULL,
`net` varchar(40) NOT NULL,
`samay` datetime NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE role_resources;
CREATE TABLE `role_resources` (
`role_resources_id` int(11) NOT NULL AUTO_INCREMENT,
`role_resources_name` varchar(255) NOT NULL,
`role_resources_status` varchar(25) NOT NULL,
PRIMARY KEY (`role_resources_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
INSERT INTO role_resources VALUES("1","All","yes");
INSERT INTO role_resources VALUES("2","View slip","yes");
DROP TABLE roles;
CREATE TABLE `roles` (
`roleid` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(100) NOT NULL,
`resources_access` varchar(100) NOT NULL,
`role_resources_id` int(11) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
INSERT INTO roles VALUES("1","admin","All","1");
INSERT INTO roles VALUES("2","sub-admin","All","1");
INSERT INTO roles VALUES("4","manager","All","1");