Advertisement
Guest User

Untitled

a guest
Aug 28th, 2015
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.62 KB | None | 0 0
  1. <?php session_start(); ?>
  2. <?php
  3. if(!$_SESSION["staff_login"])
  4. header("Location: login.php");
  5.  
  6. include_once("includes/statuslocation.php");
  7. include_once("includes/paging.class.php");
  8. $page = new paging();
  9. $page->db();
  10. $page->table = "tbrepair";
  11.  
  12. if(isset($_GET["page"]) && !empty($_GET["page"])) {
  13. $current_page = intval($_GET["page"]);
  14. }
  15. else
  16. $current_page = 1;
  17.  
  18. $page->page = $current_page;
  19. $page->order = "cJN";
  20. $page->ordertype = "DESC";
  21. $page->page_limit = 10;
  22. $page->generateSelectQuery();
  23. $page->generatePaging();
  24. $jobs = $page->page_results;
  25. ?>
  26. <?php $page_active="index.php"; ?>
  27. <!DOCTYPE html>
  28. <html lang="en">
  29.  
  30. <head>
  31.  
  32. <meta charset="utf-8">
  33. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  34. <meta name="viewport" content="width=device-width, initial-scale=1">
  35. <meta name="description" content="">
  36. <meta name="author" content="">
  37.  
  38. <title>Fixxed Account Management</title>
  39.  
  40. <!-- Bootstrap Core CSS -->
  41. <link href="css/bootstrap.min.css" rel="stylesheet">
  42.  
  43. <!-- Custom CSS -->
  44. <link href="css/sb-admin.css" rel="stylesheet">
  45.  
  46. <!-- Morris Charts CSS -->
  47. <link href="css/plugins/morris.css" rel="stylesheet">
  48.  
  49. <!-- Custom Fonts -->
  50. <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
  51.  
  52. <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  53. <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  54. <!--[if lt IE 9]>
  55. <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
  56. <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
  57. <![endif]-->
  58.  
  59. </head>
  60.  
  61. <body>
  62.  
  63. <div id="wrapper">
  64.  
  65. <!-- Navigation -->
  66. <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
  67. <!-- Brand and toggle get grouped for better mobile display -->
  68. <div class="navbar-header">
  69. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
  70. <span class="sr-only">Toggle navigation</span>
  71. <span class="icon-bar"></span>
  72. <span class="icon-bar"></span>
  73. <span class="icon-bar"></span>
  74. </button>
  75. <a class="navbar-brand" href="index.php">Fixxed Account Management</a>
  76. </div>
  77. <!-- Top Menu Items -->
  78. <?php include_once("includes/header.php") ?>;
  79. <!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens -->
  80. <div class="collapse navbar-collapse navbar-ex1-collapse">
  81. <?php include_once("includes/nav.php") ?>;
  82. <!-- /.navbar-collapse -->
  83. </div>
  84. </nav>
  85.  
  86. <div id="page-wrapper">
  87.  
  88. <div class="container-fluid">
  89.  
  90. <!-- Page Heading -->
  91. <div class="row">
  92. <div class="col-lg-12">
  93. <h1 class="page-header">
  94. Dashboard <small>Job Listings</small>
  95. </h1>
  96. <ol class="breadcrumb">
  97. <li class="active">
  98. <i class="fa fa-dashboard"></i> Dashboard
  99. </li>
  100. </ol>
  101. </div>
  102. </div>
  103. <!-- /.row -->
  104.  
  105. <div class="row" style="padding-bottom:20px">
  106.  
  107. <div class="col-lg-12">
  108.  
  109. <div><h4>Search</h4></div>
  110. <div class="col-lg-4">
  111. <form action="search-results.php" method="post" name="searchform" id="searchform">
  112.  
  113. <div class="form-group">
  114. <label>Job Number</label>
  115. <input name="cJN" type="text" class="form-control" placeholder="Search job number" id="cJN" value="<?php if(!empty($_POST["cJN"]) && !empty($error)) { echo $_POST["cJN"]; } ?>" />
  116. </div>
  117.  
  118. <div class="form-group">
  119. <label>First Name</label>
  120. <input name="cCName" type="text" class="form-control" placeholder="Search firstname" id="cCName" value="<?php if(!empty($_POST["cCName"]) && !empty($error)) { echo $_POST["cCName"]; } ?>" />
  121. </div>
  122.  
  123. <div class="form-group">
  124. <label>Last Name</label>
  125. <input name="cCLastName" type="text" class="form-control" placeholder="Search lastname" id="cCLastName" value="<?php if(!empty($_POST["cCLastName"]) && !empty($error)) { echo $_POST["cCLastName"]; } ?>" />
  126. </div>
  127. </div>
  128. <div class="col-lg-4">
  129. <div class="form-group">
  130. <label>Address</label>
  131. <input name="cCAdd1" type="text" class="form-control" placeholder="Search address" id="cCAdd1" value="<?php if(!empty($_POST["cCAdd1"]) && !empty($error)) { echo $_POST["cCAdd1"]; } ?>" />
  132. </div>
  133.  
  134. <div class="form-group">
  135. <label>Phone Number</label>
  136. <input name="cCHomePhn" type="text" class="form-control" placeholder="Search home phone number" id="cCHomePhn" value="<?php if(!empty($_POST["cCHomePhn"]) && !empty($error)) { echo $_POST["cCHomePhn"]; } ?>" />
  137. </div>
  138.  
  139. <div class="form-group">
  140. <label>Mobile Number</label>
  141. <input name="cCFax" type="text" class="form-control" placeholder="Search mobile number" id="cCFax" value="<?php if(!empty($_POST["cCFax"]) && !empty($error)) { echo $_POST["cCFax"]; } ?>" />
  142. </div>
  143.  
  144. </div>
  145. <div class="col-lg-4">
  146. <div class="form-group">
  147. <label>Make</label>
  148. <input name="cMake" type="text" class="form-control" placeholder="Search make" id="cMake" value="<?php if(!empty($_POST["cMake"]) && !empty($error)) { echo $_POST["cMake"]; } ?>" />
  149. </div>
  150.  
  151. <div class="form-group">
  152. <label>Model</label>
  153. <input name="cModel" type="text" class="form-control" placeholder="Search model" id="cModel" value="<?php if(!empty($_POST["cModel"]) && !empty($error)) { echo $_POST["cModel"]; } ?>" />
  154. </div>
  155.  
  156. <div class="form-group">
  157. <label>IMEI</label>
  158. <input name="cIMEI" type="text" class="form-control" placeholder="Search IMEI" id="cIMEI" value="<?php if(!empty($_POST["cIMEI"]) && !empty($error)) { echo $_POST["cIMEI"]; } ?>" />
  159. </div>
  160.  
  161.  
  162. <input name="Submit" type="submit" class="btn btn-default" value="Search" />
  163.  
  164. </form>
  165.  
  166. </div>
  167.  
  168. </div>
  169.  
  170. </div>
  171. <!-- /.row -->
  172.  
  173. <div class="row">
  174. <div class="col-lg-12">
  175. <div class="table-responsive">
  176. <table class="table table-bordered table-hover table-striped">
  177. <thead>
  178. <tr>
  179. <th>JobID</th>
  180. <th>Submitted By</th>
  181. <th>Customer</th>
  182. <th>Make</th>
  183. <th>Model</th>
  184. <th>Status</th>
  185. <td>Location</td>
  186. <td>Date Submitted</td>
  187. <td>Opr</td>
  188. </tr>
  189. </thead>
  190. <tbody>
  191. <?php
  192. if(!empty($jobs)) {
  193. foreach($jobs as $job) {
  194. ?>
  195. <?php
  196. $page->table = "tbbranch";
  197. $page->cond = "branch_id='".$job["branch_id"]."'";
  198. $page->order = "";
  199. $page->ordertype = "";
  200. $page->selectQuery();
  201. $branch = $page->fetchQuery();
  202.  
  203. $page->table = "tbuser";
  204. $page->cond = "branch_id='".$job["id"]."'";
  205. $page->order = "";
  206. $page->ordertype = "";
  207. $page->selectQuery();
  208. $temp_model = $page->fetchQuery();
  209. $job["branch_name"] = $branch[0]["branch_name"]." ".$temp_model[0]["branch_name"];
  210. ?>
  211.  
  212. <tr>
  213. <td><a href="de_srf.php?cJN=<?php echo $job["cJN"]; ?>" target="_blank"><?php echo $job["cJN"] ?></a></td>
  214. <td><?php echo $job["cSbmBy"] ?></td>
  215. <td><?php echo $job["cCName"]." ".$job["cCLastName"]; ?></td>
  216. <td><?php echo $job["cMake"] ?></td>
  217. <td><?php echo $job["cModel"] ?></td>
  218. <td><?php echo getStatus($job["cStatus"]) ?>
  219. <?php
  220. if($job["cMemo"]!= null && $job["cMemo"]!= ""){
  221. $pic = "button_edit.png";
  222. if($job["cIsReplyRead2"]!="checked"){$pic="button_edit_new.gif";}
  223. ?>
  224. <a href="#">
  225. <img src="images/<?php echo $pic;?>" alt="Click for Detail" width="12" height="13" border="0" onClick="MM_openBrWindow('de_req_memo.php?cJN=<?php echo $job["cJN"];?>','Memo','status=yes,scrollbars=yes,resizable=yes,width=640,height=480')">
  226. </a>
  227. <?php
  228. }
  229. ?>
  230. <br /><a href="#" onClick="MM_openBrWindow('de_req_memo.php?cJN=<?php echo $job["cJN"];?>','Memo','status=yes,scrollbars=yes,resizable=yes,width=640,height=480')">Memo</a>
  231. </td>
  232. <td><?php echo getLocation($job["cLocation"]) ?>
  233. <?php
  234. if ($job["iCrrID"] != null && strlen($job["cCrrTrk"]) > 0) {
  235. ?>
  236. <br><a href="http://<?php echo $job['url']; ?>" target="_blank" title="<?php echo $job["name"]; ?>">Trk #: <?php echo $job["cCrrTrk"]; ?></a><?php } ?>
  237. </td>
  238. <td><?php echo date ("j F Y, g:i a",strtotime($job["dtSDate"])); ?></td>
  239. <td><a href="de_srf.php?cJN=<?php echo $job["cJN"]; ?>">F</a> <a href="de_srf_2c.php?cJN=<?php echo $job["cJN"]; ?>">C</a>
  240. <a href="rtp.php?cJN=<?php echo $job["cJN"]; ?>">T</a>
  241. <?php if ($job["cStatus"] == 'S25' || $job["cStatus"] == "S30" || $job["cStatus"] == 'S35') {?>
  242. <a href="sri_val.php?cJN=<?php echo $job["cJN"]; ?>" target="_blank">R</a>
  243. <?php } ?></td>
  244. </tr>
  245. </tbody>
  246. <?php
  247. }
  248. }
  249. ?>
  250. </table>
  251. <div class="link-fonts" style="clear:both; margin:13px 21px 0px 0px; float:right; font-weight:bold;">
  252. <?php
  253. $url = "index.php";
  254. if($page->page <= 1)
  255. $start = '';
  256. else
  257. $start = '<a href="'.$url.'?page=1" class="listViewPaginationLinkS1">Start</a>';
  258.  
  259. //prev
  260. if($page->page <= 1)
  261. $prev = '';
  262. else
  263. $prev = '<a href="'.$url.'?page='.$page->page_details["prev"].'" class="listViewPaginationLinkS1">Previous</a>';
  264.  
  265. //label
  266. $label = '<span class="pageNumbers">'.$page->page_details["start"].'&nbsp;&nbsp;-&nbsp;&nbsp;'.$page->page_details["to"].'&nbsp;&nbsp;of&nbsp;&nbsp;'.$page->page_details["total"].'</span>';
  267.  
  268. //next
  269. if($page->page >= $page->page_details["last"])
  270. $next = '';
  271. else
  272. $next = '<a href="'.$url.'?page='.$page->page_details["next"].'" class="listViewPaginationLinkS1">Next</a>';
  273.  
  274. //end
  275. if($page->page >= $page->page_details["last"])
  276. $end = '';
  277. else
  278. $end = '<a href="'.$url.'?page='.$page->page_details["last"].'" class="listViewPaginationLinkS1">End</a>';
  279.  
  280. echo $start.'&nbsp;&nbsp;&nbsp;'.$prev.'&nbsp;&nbsp;&nbsp;'.$label.'&nbsp;&nbsp;&nbsp;'.$next.'&nbsp;&nbsp;&nbsp;'.$end;
  281.  
  282. $page->mysqlClose();
  283. ?>
  284. </div>
  285. </div>
  286. </div>
  287. </div>
  288.  
  289. </div>
  290. </div>
  291. <!-- /.row -->
  292.  
  293. <div class="row"></div>
  294. <!-- /.row -->
  295.  
  296. <div class="row"></div>
  297. <!-- /.row -->
  298.  
  299. </div>
  300. <!-- /.container-fluid -->
  301.  
  302. </div>
  303. <!-- /#page-wrapper -->
  304.  
  305. </div>
  306. <!-- /#wrapper -->
  307.  
  308. <!-- jQuery -->
  309. <script src="js/jquery.js"></script>
  310. <script src="js/common.js"></script>
  311. <!-- Bootstrap Core JavaScript -->
  312. <script src="js/bootstrap.min.js"></script>
  313.  
  314. <!-- Morris Charts JavaScript -->
  315. <script src="js/plugins/morris/raphael.min.js"></script>
  316. <script src="js/plugins/morris/morris.min.js"></script>
  317. <script src="js/plugins/morris/morris-data.js"></script>
  318.  
  319. </body>
  320.  
  321. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement