API tools faq
paste
Advertisement
Guest User

tetetetete

a guest
Jan 20th, 2020
142
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.32 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include_once '../assets/conn/dbconnect.php';
  4. // include_once 'connection/server.php';
  5. if(!isset($_SESSION['doctorSession']))
  6. {
  7. header("Location: ../adminlogin.php");
  8. }
  9. $usersession = $_SESSION['doctorSession'];
  10. $res=mysqli_query($con,"SELECT * FROM doctor WHERE doctorId=".$usersession);
  11. $userRow=mysqli_fetch_array($res,MYSQLI_ASSOC);
  12.  
  13. if(isset($_POST['btnsave']))
  14. {
  15.  
  16. $holiday_name=$_POST['holiday_name'];
  17. $holiday_month=$_POST['holiday_month'];
  18. $holiday_day=$_POST['holiday_day'];
  19.  
  20. $insert_data=mysqli_query($con,"INSERT INTO tbl_holiday
  21.  
  22. (holiday_name,holiday_month,holiday_day)
  23.  
  24. VALUES
  25.  
  26. ('$holiday_name','$holiday_month','$holiday_day')");
  27.  
  28. if($insert_data)
  29. {
  30. echo "<script language='javascript' type='text/javascript'>";
  31. echo "alert('Operating Hours Successuly Added!');";
  32. echo "</script>";
  33.  
  34. $URL="Operatinghours.php";
  35. echo "<script>location.href='$URL'</script>";
  36. }
  37. else
  38. {
  39. echo "<script language='javascript' type='text/javascript'>";
  40. echo "alert('!Error');";
  41. echo "</script>";
  42.  
  43. $URL="Operatinghours.php";
  44. echo "<script>location.href='$URL'</script>";
  45.  
  46. }
  47.  
  48. }
  49. //
  50.  
  51. if(isset($_GET['update']))
  52. {
  53. $update=$_GET['update'];
  54. $update_table=mysqli_query($con,"UPDATE tbl_holiday SET holiday_status='OFF' where holiday_id='$update'");
  55. if($update_table)
  56. {
  57. echo "<script language='javascript' type='text/javascript'>";
  58. echo "alert('Success');";
  59. echo "</script>";
  60.  
  61. $URL="Operatinghours.php";
  62. echo "<script>location.href='$URL'</script>";
  63. }
  64. else
  65. {
  66. echo "<script language='javascript' type='text/javascript'>";
  67. echo "alert('!Error');";
  68. echo "</script>";
  69.  
  70. $URL="Operatinghours.php";
  71. echo "<script>location.href='$URL'</script>";
  72. }
  73. }
  74. if(isset($_GET['On']))
  75. {
  76. $on=$_GET['On'];
  77. $on_status=mysqli_query($con,"UPDATE tbl_holiday SET holiday_status='on' WHERE holiday_id='$on'");
  78.  
  79. if($on_status)
  80. {
  81. echo "<script language='javascript' type='text/javascript'>";
  82. echo "alert('Success');";
  83. echo "</script>";
  84.  
  85. $URL="Operatinghours.php";
  86. echo "<script>location.href='$URL'</script>";
  87. }
  88. else
  89. {
  90. echo "<script language='javascript' type='text/javascript'>";
  91. echo "alert('!Error');";
  92. echo "</script>";
  93.  
  94. $URL="Operatinghours.php";
  95. echo "<script>location.href='$URL'</script>";
  96.  
  97. }
  98.  
  99. }
  100.  
  101. ?>
  102.  
  103.  
  104. <!DOCTYPE html>
  105. <html lang="en">
  106.  
  107. <head>
  108. <!-- Required meta tags-->
  109. <meta charset="UTF-8">
  110. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  111. <!-- Title Page-->
  112. <title>Dashboard 3</title>
  113.  
  114. <!-- Fontfaces CSS-->
  115. <link href="css/font-face.css" rel="stylesheet" media="all">
  116. <link href="addons/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">
  117. <link href="addons/font-awesome-5/css/fontawesome-all.min.css" rel="stylesheet" media="all">
  118. <link href="addons/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">
  119.  
  120. <!-- Bootstrap CSS-->
  121. <link href="addons/theme/theme.min.css" rel="stylesheet" media="all">
  122.  
  123. <!-- addons CSS-->
  124. <link href="addons/animsition/animsition.min.css" rel="stylesheet" media="all">
  125. <link href="addons/bootstrap-progressbar/bootstrap-progressbar-3.3.4.min.css" rel="stylesheet" media="all">
  126. <link href="addons/wow/animate.css" rel="stylesheet" media="all">
  127. <link href="addons/css-hamburgers/hamburgers.min.css" rel="stylesheet" media="all">
  128. <link href="addons/slick/slick.css" rel="stylesheet" media="all">
  129. <link href="addons/select2/select2.min.css" rel="stylesheet" media="all">
  130. <link href="addons/perfect-scrollbar/perfect-scrollbar.css" rel="stylesheet" media="all">
  131.  
  132. <!-- Main CSS-->
  133. <link href="css/theme.css" rel="stylesheet" media="all">
  134.  
  135. </head>
  136.  
  137. <body onload="startTime()">
  138. <div class="page-wrapper" style="background:white;">
  139. <style type="text/css">
  140. }
  141. .transition {
  142. transition: all 0.3s ease-out;
  143. }
  144. .heading {
  145. text-align: center;
  146. font-size: 0.8em;
  147. }
  148. .center-align {
  149. width: 150px;
  150. height: 50px;
  151. display: table-row;
  152. padding: 5px 5px 5px 5px;
  153. }
  154. input[type="radio"] {
  155. visibility: hidden;
  156. height: 0;
  157. width: 0;
  158. }
  159. label {
  160. display: inline-table;
  161. vertical-align: middle;
  162. text-align: center;
  163. cursor: pointer;
  164. background-color: #454545;
  165. color: white;
  166. padding: 5px 20px;
  167. border-radius: 3px;
  168. transition: all 0.3s ease-out;
  169. }
  170. input[type="radio"]:checked + label {
  171. background-color: #58ba83;
  172. }
  173.  
  174. </style>
  175.  
  176.  
  177. <script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
  178. <script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>
  179.  
  180. <!--Navigation-->
  181.  
  182. <?php
  183. include_once '../admin/includes/navigation.php';
  184. ?>
  185.  
  186. <!--End Navigation-->
  187.  
  188.  
  189.  
  190.  
  191. <div class="row">
  192. <div class="col-lg-6">
  193. <br>
  194. <form method="post" enctype="multipart/form-data" class="form-horizontal">
  195.  
  196. <table class="table">
  197. <input type="hidden" name="galid" value="">
  198. <h1>Add Holidays</h1>
  199. <tr>
  200. <td><label class="control-label">Holiday Name.</label></td>
  201. <td><input class="form-control" type="text" name="holiday_name" placeholder="Holiday Name" value="" /></td>
  202. </tr>
  203. <tr>
  204. <td><label class="control-label">Month</label></td>
  205. <td><input class="form-control" type="text" name="holiday_month" placeholder="Holiday Month" value="" /></td>
  206. </tr>
  207. <tr>
  208. <td><label class="control-label">Day</label></td>
  209. <td><input class="form-control" type="text" name="holiday_day" placeholder="Holiday Day" value="" /></td>
  210. </tr>
  211.  
  212.  
  213.  
  214. <tr>
  215. <td>Note:</td><td><a href="#" class="viewapp" style="font-size: 20px; border-radius: 5px; background-color:#2e60b0; padding: 5px 10px 5px 10px; color: #ffffff; ">
  216. The date format must be like this: Example December 25, It should be "12, 25".
  217. </a></span></h2>
  218. </td>
  219. </tr>
  220.  
  221.  
  222. <td colspan="2">
  223.  
  224.  
  225. <button type="submit" name="btnsave" class="btn btn-default" style="float: right; background-color: #2196f3; color: white;">
  226. <span class="glyphicon"></span> Add Holiday
  227. </button>
  228.  
  229.  
  230. </td>
  231.  
  232.  
  233. </tr>
  234. </table>
  235. </form>
  236.  
  237. </div>
  238. </div>
  239.  
  240. <div class="col-lg-6" style="margin-left:700px; margin-top:-350px;" >
  241. <div class="card">
  242. <div class="card-header">
  243. <h6>Legend: <small style="background:yellow; color:black;">Yellow Color is On</small> <small style="background:red; color:white;">Red color is Off.</small></h6>
  244.  
  245. <strong>Holioday Schedule <i style="color:green;" class="fa fa-check" aria-hidden="true"></i></strong>
  246. <!--<small>Upload Summary</small>-->
  247. <span style="float: right; font-weight: bold"></span>
  248. </div>
  249. <div class="card-body card-block">
  250.  
  251.  
  252. <!-- panel start -->
  253. <div class="panel panel-primary filterable" style="margin: 10px 20px 0px 20px;">
  254.  
  255. <!-- panel heading starat -->
  256. <div class="panel-heading">
  257. <div class="pull-right">
  258. <!-- <button class="btn btn-default btn-xs btn-filter"><span class="fa fa-filter"></span> Filter</button> -->
  259. </div>
  260. </div>
  261. <!-- panel heading end -->
  262.  
  263. <div class="panel-body">
  264.  
  265. <script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
  266. <script src="https://cdn.datatables.net/v/dt/dt-1.10.18/sl-1.3.0/datatables.min.js"></script>
  267. <script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
  268.  
  269.  
  270. <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.css">
  271.  
  272. <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
  273.  
  274. <!-- panel content start -->
  275. <div id="areaToPrint">
  276. <table class="table table-hover table-bordered" id="table_id">
  277. <thead>
  278. <?php
  279. $select_holiday=mysqli_query($con,"SELECT * FROM tbl_holiday ORDER BY holiday_id desc");
  280.  
  281. ?>
  282. <tr class="filters">
  283.  
  284.  
  285. <th>Holiday Name</th>
  286. <th>Holiday Month</th>
  287. <th>Day</th>
  288. <th>On/OFF</th>
  289. <!-- <th style="width: 150px;">Update</th>
  290. <th style="width: 100px; font-weight: bold; font-size: 15px;">Delete</th> -->
  291.  
  292. </tr>
  293. </thead>
  294. <tbody>
  295. <?php while($rows=mysqli_fetch_array($select_holiday)){
  296.  
  297. ?>
  298. <tr>
  299.  
  300.  
  301. <td><?php echo $rows['holiday_name']; ?></td>
  302. <td><?php echo $rows['holiday_month']; ?></td>
  303. <td><?php echo $rows['holiday_day']; ?></td>
  304.  
  305.  
  306. <td class='text-center'>
  307.  
  308. <?php if($rows['holiday_status']=='on')
  309. {
  310. ?>
  311. <button><a href="Operatinghours.php?update=<?php echo $rows['holiday_id']; ?>" class='update btn-sm btn-warning'><i class='fas fa-on'></i></a><button>
  312. &nbsp;
  313. <?php
  314.  
  315. }
  316. else
  317. {
  318.  
  319. ?>
  320. <button style="background:red;"><a style="background:red;" href="Operatinghours.php?On=<?php echo $rows['holiday_id']; ?>" class='update btn-sm btn-warning'><i class='fas fa-off'></i></a><button>
  321. &nbsp;
  322.  
  323. <?php } ?>
  324.  
  325. </td>
  326.  
  327.  
  328. <!--<td class='text-center'><a href='#' id='' class='delete'><span>Delete</span></a></td>-->
  329.  
  330.  
  331. </tr>
  332. <?php } ?>
  333.  
  334.  
  335. </tbody>
  336. </table>
  337.  
  338. <script type="text/javascript">
  339. $(document).ready(function() {
  340. $('#table_id').DataTable( {
  341. "order": [[ 2, "desc" ]],
  342. pageLength : 5,
  343. lengthMenu: [[5, 10, 20, -1], [5, 10, 20, 'Todos']]
  344.  
  345. } );
  346. } );
  347.  
  348. </script>
  349.  
  350.  
  351. <!-- panel content end -->
  352. <!-- panel end -->
  353. </div>
  354. </div>
  355. <!-- panel start -->
  356. </div>
  357. </div>
  358. <!-- /#wrapper -->
  359. </div>
  360. </div>
  361. </div>
  362.  
  363. <!-- Jquery JS-->
  364. <script src="addons/jquery-3.2.1.min.js"></script>
  365. <!-- Bootstrap JS-->
  366. <script src="addons/theme/popper.min.js"></script>
  367. <script src="addons/theme/theme.min.js"></script>
  368. <!-- addons JS -->
  369. <script src="addons/slick/slick.min.js">
  370. </script>
  371. <script src="addons/wow/wow.min.js"></script>
  372. <script src="addons/animsition/animsition.min.js"></script>
  373. <script src="addons/bootstrap-progressbar/bootstrap-progressbar.min.js">
  374. </script>
  375. <script src="addons/counter-up/jquery.waypoints.min.js"></script>
  376. <script src="addons/counter-up/jquery.counterup.min.js">
  377. </script>
  378. <script src="addons/circle-progress/circle-progress.min.js"></script>
  379. <script src="addons/perfect-scrollbar/perfect-scrollbar.js"></script>
  380. <script src="addons/chartjs/Chart.bundle.min.js"></script>
  381. <script src="addons/select2/select2.min.js">
  382. </script>
  383.  
  384. <!-- Main JS-->
  385. <script src="js/main.js"></script>
  386.  
  387.  
  388. </body>
  389.  
  390. </html>
  391. <!-- end document-->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!