API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 27th, 2015
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.35 KB | None | 0 0
raw download clone embed print report
  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. $page->cond = "cStatus ='S20'";
  12.  
  13. if(isset($_GET["page"]) && !empty($_GET["page"])) {
  14. $current_page = intval($_GET["page"]);
  15. }
  16. else
  17. $current_page = 1;
  18.  
  19. $page->page = $current_page;
  20. $page->order = "cJN";
  21. $page->ordertype = "DESC";
  22. $page->page_limit = 10;
  23. $page->generateSelectQuery();
  24. $page->generatePaging();
  25. $jobs = $page->page_results;
  26. ?>
  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. <ul class="nav navbar-right top-nav">
  79. <li class="dropdown">
  80.  
  81. <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i> <?php echo " ".$_SESSION["firstname"]." ".$_SESSION["lastname"]; ?> <b class="caret"></b></a>
  82. <ul class="dropdown-menu">
  83. <li>
  84. <a href="update-profile.php"><i class="fa fa-fw fa-user"></i> Profile</a>
  85. </li>
  86. <li class="divider"></li>
  87. <li>
  88. <a href="logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a>
  89. </li>
  90. </ul>
  91. </li>
  92. </ul>
  93. <!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens -->
  94. <div class="collapse navbar-collapse navbar-ex1-collapse">
  95. <ul class="nav navbar-nav side-nav">
  96. <li>
  97. <a href="index.php"><i class="fa fa-fw fa-dashboard"></i> Dashboard</a>
  98. </li>
  99. <li>
  100. <a href="service-request-form.php"><i class="fa fa-fw fa-desktop"></i> Service Request Form</a>
  101. </li>
  102. <li>
  103. <a href="repair-request.php"><i class="fa fa-fw fa-desktop"></i> My Repair Requests </a>
  104. </li>
  105. <li class="active">
  106. <a href="2bc.php"><i class="fa fa-fw fa-desktop"></i> To be confirmed (<?php echo count($jobs); ?>) </a>
  107. </li>
  108. <li>
  109. <a href="javascript:;" data-toggle="collapse" data-target="#order"><i class="fa fa-fw fa-edit"></i> Order Management <i class="fa fa-fw fa-caret-down"></i></a>
  110. <ul id="order" class="collapse">
  111. <li>
  112. <a href="purchase-order-form.php">Add Purchase Order</a>
  113. </li>
  114. <li>
  115. <a href="pre-order-form-list.php">Purchase Order List</a>
  116. </li>
  117. </ul>
  118. </li>
  119. <?php if($_SESSION["role_id"] == "1") { ?>
  120. <li>
  121. <a href="javascript:;" data-toggle="collapse" data-target="#demo"><i class="fa fa-fw fa-edit"></i> Users <i class="fa fa-fw fa-caret-down"></i></a>
  122. <ul id="demo" class="collapse">
  123. <li>
  124. <a href="add-user.php">Add Users</a>
  125. </li>
  126. <li>
  127. <a href="manage-users.php">Manage Users</a>
  128. </li>
  129. </ul>
  130. </li>
  131. <li>
  132. <a href="javascript:;" data-toggle="collapse" data-target="#branch"><i class="fa fa-fw fa-edit"></i> Store Branch <i class="fa fa-fw fa-caret-down"></i></a>
  133. <ul id="branch" class="collapse">
  134. <li>
  135. <a href="add-branch.php">Add Branch</a>
  136. </li>
  137. <li>
  138. <a href="manage-branch.php">Manage Branch</a>
  139. </li>
  140. </ul>
  141. </li>
  142. <?php } ?>
  143. </ul>
  144. </div>
  145. <!-- /.navbar-collapse -->
  146. </nav>
  147.  
  148. <div id="page-wrapper">
  149.  
  150. <div class="container-fluid">
  151.  
  152. <!-- Page Heading -->
  153. <div class="row">
  154. <div class="col-lg-12">
  155. <h1 class="page-header">
  156. Dashboard <small>Job Listings</small>
  157. </h1>
  158. <ol class="breadcrumb">
  159. <li class="active">
  160. <i class="fa fa-dashboard"></i> Dashboard
  161. </li>
  162. </ol>
  163. </div>
  164. </div>
  165. <!-- /.row -->
  166.  
  167. <div class="row" style="padding-bottom:20px">
  168.  
  169. <div class="col-lg-12">
  170.  
  171. <div><h4>Search</h4></div>
  172. <div class="col-lg-4">
  173. <form action="search-results.php" method="post" name="searchform" id="searchform">
  174.  
  175. <div class="form-group">
  176. <label>Job Number</label>
  177. <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"]; } ?>" />
  178. </div>
  179.  
  180. <div class="form-group">
  181. <label>First Name</label>
  182. <input name="cCName" type="text" class="form-control" placeholder="Search firstname" id="cCName" value="<?php if(!empty($_POST["cCName"]) && !empty($error)) { echo $_POST["cCName"]; } ?>" />
  183. </div>
  184.  
  185. <div class="form-group">
  186. <label>Last Name</label>
  187. <input name="cCLastName" type="text" class="form-control" placeholder="Search lastname" id="cCLastName" value="<?php if(!empty($_POST["cCLastName"]) && !empty($error)) { echo $_POST["cCLastName"]; } ?>" />
  188. </div>
  189. </div>
  190. <div class="col-lg-4">
  191. <div class="form-group">
  192. <label>Address</label>
  193. <input name="cCAdd1" type="text" class="form-control" placeholder="Search address" id="cCAdd1" value="<?php if(!empty($_POST["cCAdd1"]) && !empty($error)) { echo $_POST["cCAdd1"]; } ?>" />
  194. </div>
  195.  
  196. <div class="form-group">
  197. <label>Phone Number</label>
  198. <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"]; } ?>" />
  199. </div>
  200.  
  201. <div class="form-group">
  202. <label>Mobile Number</label>
  203. <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"]; } ?>" />
  204. </div>
  205.  
  206. </div>
  207. <div class="col-lg-4">
  208. <div class="form-group">
  209. <label>Make</label>
  210. <input name="cMake" type="text" class="form-control" placeholder="Search make" id="cMake" value="<?php if(!empty($_POST["cMake"]) && !empty($error)) { echo $_POST["cMake"]; } ?>" />
  211. </div>
  212.  
  213. <div class="form-group">
  214. <label>Model</label>
  215. <input name="cModel" type="text" class="form-control" placeholder="Search model" id="cModel" value="<?php if(!empty($_POST["cModel"]) && !empty($error)) { echo $_POST["cModel"]; } ?>" />
  216. </div>
  217.  
  218. <div class="form-group">
  219. <label>IMEI</label>
  220. <input name="cIMEI" type="text" class="form-control" placeholder="Search IMEI" id="cIMEI" value="<?php if(!empty($_POST["cIMEI"]) && !empty($error)) { echo $_POST["cIMEI"]; } ?>" />
  221. </div>
  222.  
  223.  
  224. <input name="Submit" type="submit" class="btn btn-default" value="Search" />
  225.  
  226. </form>
  227.  
  228. </div>
  229.  
  230. </div>
  231.  
  232. </div>
  233. <!-- /.row -->
  234.  
  235. <div class="row">
  236. <div class="col-lg-12">
  237. <div class="table-responsive">
  238. <table class="table table-bordered table-hover table-striped">
  239. <thead>
  240. <tr>
  241. <th>JobID</th>
  242. <th>Submitted By</th>
  243. <th>Customer</th>
  244. <th>Make</th>
  245. <th>Model</th>
  246. <th>Status</th>
  247. <td>Location</td>
  248. <td>Date Submitted</td>
  249. <td>Opr</td>
  250. </tr>
  251. </thead>
  252. <tbody>
  253. <?php
  254. if(!empty($jobs)) {
  255. foreach($jobs as $job) {
  256. ?>
  257. <?php
  258. $page->table = "tbbranch";
  259. $page->cond = "branch_id='".$job["branch_id"]."'";
  260. $page->order = "";
  261. $page->ordertype = "";
  262. $page->selectQuery();
  263. $branch = $page->fetchQuery();
  264.  
  265. $page->table = "tbuser";
  266. $page->cond = "branch_id='".$job["id"]."'";
  267. $page->order = "";
  268. $page->ordertype = "";
  269. $page->selectQuery();
  270. $temp_model = $page->fetchQuery();
  271. $job["branch_name"] = $branch[0]["branch_name"]." ".$temp_model[0]["branch_name"];
  272. ?>
  273.  
  274. <tr>
  275. <td><a href="de_srf.php?cJN=<?php echo $job["cJN"]; ?>" target="_blank"><?php echo $job["cJN"] ?></a></td>
  276. <td><?php echo $job["cSbmBy"] ?></td>
  277. <td><?php echo $job["cCName"]." ".$job["cCLastName"]; ?></td>
  278. <td><?php echo $job["cMake"] ?></td>
  279. <td><?php echo $job["cModel"] ?></td>
  280. <td><?php echo getStatus($job["cStatus"]) ?>
  281. <?php
  282. if($job["cMemo"]!= null && $job["cMemo"]!= ""){
  283. $pic = "button_edit.png";
  284. if($job["cIsReplyRead2"]!="checked"){$pic="button_edit.png";}
  285. ?>
  286. <a href="#">
  287. <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')">
  288. </a>
  289. <?php
  290. }
  291. ?>
  292. <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>
  293. </td>
  294. <td><?php echo getLocation($job["cLocation"]) ?>
  295. <?php
  296. if ($job["iCrrID"] != null && strlen($job["cCrrTrk"]) > 0) {
  297. ?>
  298. <br><a href="http://<?php echo $job['url']; ?>" target="_blank" title="<?php echo $job["name"]; ?>">Trk #: <?php echo $job["cCrrTrk"]; ?></a><?php } ?>
  299. </td>
  300. <td><?php echo date ("j F Y, g:i a",strtotime($job["dtSDate"])); ?></td>
  301. <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>
  302. <a href="rtp.php?cJN=<?php echo $job["cJN"]; ?>">T</a>
  303. <?php if ($job["cStatus"] == 'S25' || $job["cStatus"] == "S30" || $job["cStatus"] == 'S35') {?>
  304. <a href="sri_val.php?cJN=<?php echo $job["cJN"]; ?>" target="_blank">R</a>
  305. <?php } ?></td>
  306. </tr>
  307. </tbody>
  308. <?php
  309. }
  310. }
  311. ?>
  312. </table>
  313. <div class="link-fonts" style="clear:both; margin:13px 21px 0px 0px; float:right; font-weight:bold;">
  314. <?php
  315. $url = "2bc.php";
  316. if($page->page <= 1)
  317. $start = '';
  318. else
  319. $start = '<a href="'.$url.'?page=1" class="listViewPaginationLinkS1">Start</a>';
  320.  
  321. //prev
  322. if($page->page <= 1)
  323. $prev = '';
  324. else
  325. $prev = '<a href="'.$url.'?page='.$page->page_details["prev"].'" class="listViewPaginationLinkS1">Previous</a>';
  326.  
  327. //label
  328. $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>';
  329.  
  330. //next
  331. if($page->page >= $page->page_details["last"])
  332. $next = '';
  333. else
  334. $next = '<a href="'.$url.'?page='.$page->page_details["next"].'" class="listViewPaginationLinkS1">Next</a>';
  335.  
  336. //end
  337. if($page->page >= $page->page_details["last"])
  338. $end = '';
  339. else
  340. $end = '<a href="'.$url.'?page='.$page->page_details["last"].'" class="listViewPaginationLinkS1">End</a>';
  341.  
  342. echo $start.'&nbsp;&nbsp;&nbsp;'.$prev.'&nbsp;&nbsp;&nbsp;'.$label.'&nbsp;&nbsp;&nbsp;'.$next.'&nbsp;&nbsp;&nbsp;'.$end;
  343.  
  344. $page->mysqlClose();
  345. ?>
  346. </div>
  347. </div>
  348. </div>
  349. </div>
  350.  
  351. </div>
  352. </div>
  353. <!-- /.row -->
  354.  
  355. <div class="row"></div>
  356. <!-- /.row -->
  357.  
  358. <div class="row"></div>
  359. <!-- /.row -->
  360.  
  361. </div>
  362. <!-- /.container-fluid -->
  363.  
  364. </div>
  365. <!-- /#page-wrapper -->
  366.  
  367. </div>
  368. <!-- /#wrapper -->
  369.  
  370. <!-- jQuery -->
  371. <script src="js/jquery.js"></script>
  372. <script src="js/common.js"></script>
  373. <!-- Bootstrap Core JavaScript -->
  374. <script src="js/bootstrap.min.js"></script>
  375.  
  376. <!-- Morris Charts JavaScript -->
  377. <script src="js/plugins/morris/raphael.min.js"></script>
  378. <script src="js/plugins/morris/morris.min.js"></script>
  379. <script src="js/plugins/morris/morris-data.js"></script>
  380.  
  381. </body>
  382.  
  383. </html>
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!