PageRenderTime 45ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/modules/snippets/includes/snippets.inc.php

https://bitbucket.org/websightdesigns/project-manager
PHP | 206 lines | 196 code | 6 blank | 4 comment | 41 complexity | 5c33614376b2e21ef4268f9669a881b1 MD5 | raw file
  1. <div class="navbar">
  2. <div class="navbar-inner">
  3. <div class="container">
  4. <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-images-collapse">
  5. <span class="icon-bar"></span>
  6. <span class="icon-bar"></span>
  7. <span class="icon-bar"></span>
  8. </a>
  9. <a class="brand" href="<?php echo $basehref; ?>snippets/">Snippets</a>
  10. <div class="nav-collapse nav-images-collapse collapse">
  11. <ul class="nav nav-pills">
  12. <li class="active"><a href="#current" data-toggle="tab">Current</a></li>
  13. <li><a href="#archived" data-toggle="tab">Archived</a></li>
  14. </ul>
  15. <div class="pull-right">
  16. <form class="navbar-search">
  17. <input type="text" id="searchbox" class="search-query" placeholder="Search Snippets" data-provide="typeahead">
  18. </form>
  19. </div>
  20. </div>
  21. </div>
  22. </div>
  23. </div>
  24. <div class="row">
  25. <div class="span6 pull-left">
  26. </div>
  27. <div class="span6 pull-right">
  28. <button href="#addSnippet" role="button" class="btn btn-success pull-right" type="button" data-toggle="modal"><i class="icon-plus icon-white"></i> Add A New Snippet</button>
  29. </div>
  30. </div>
  31. <br clear="all" /><br clear="all" />
  32. <?php
  33. if($_POST['doAddSnippet'] && $link) {
  34. // add the snippet
  35. if($_POST['clientid'] != "X") $clientid = $_POST['clientid'];
  36. if($_POST['projectid'] != "0") $projectid = $_POST['projectid'];
  37. $sql = "INSERT INTO snippets (
  38. `snippet_name`,
  39. `snippet_code`,
  40. `created`,
  41. `modified`,
  42. `clientid`,
  43. `projectid`,
  44. `userid`
  45. ) VALUES (
  46. '" . $_POST['snippet_name'] . "',
  47. '" . $_POST['snippet_code'] . "',
  48. NOW(),
  49. NOW(),
  50. '" . $clientid . "',
  51. '" . $projectid . "',
  52. '" . $_SESSION['userid_auth'] . "'
  53. )";
  54. $q = mysql_query($sql);
  55. $notice = "Your new image was created.";
  56. }
  57. if(getSetting("dateFormat", $_SESSION['userid_auth']) && getSetting("dateFormat", $_SESSION['userid_auth']) != "0") {
  58. $date_format_setting = getSetting("dateFormat", $_SESSION['userid_auth']);
  59. }
  60. if (isset($_POST['search'])) { // a search was performed
  61. $level_auth = getCurrentUserAccessLevel();
  62. $group_auth = getCurrentUserGroupID();
  63. $search_client = "Client: ";
  64. // CLIENT SECTION
  65. if(substr($_POST['search'], 0, strlen($search_client)) == $search_client) {
  66. $snippet_sql = "SELECT id
  67. FROM clients
  68. WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'";
  69. $snippet_q = mysql_query($snippet_sql);
  70. while($i = mysql_fetch_object($snippet_q)) {
  71. $snippet_id = $i->id;
  72. }
  73. $sql = "SELECT snippets.`id` AS `id`,
  74. snippets.`snippet_name` AS `snippet_name`,
  75. snippets.`snippet_hourly` AS `snippet_hourly`,
  76. snippets.`snippet_rate` AS `snippet_rate`,
  77. DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
  78. DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
  79. snippets.`created` AS `created`,
  80. snippets.`modified` AS `modified`,
  81. snippets.`clientid` AS `clientid`
  82. FROM snippets, users
  83. WHERE users.userid='" . $_SESSION['userid_auth'] . "'
  84. AND snippets.snippet_name LIKE '%" . $_POST['search'] . "%'";
  85. if($level_auth < "11" || getSetting('onlyShowSnippetsInMyGroup', $_SESSION['userid_auth']) == "0")
  86. $sql .= " AND users.id=snippets.ownerid AND users.groupid = '" . $group_auth . "'";
  87. $sql .= " ORDER BY snippets.`sort` ASC, snippets.`modified` DESC, snippets.`created` DESC";
  88. $search_text = "Snippets for the client <u>".str_replace($search_client, "", $_POST['search'])."</u>";
  89. // PROJECT SECTION
  90. } elseif(substr($_POST['search'], 0, strlen($search_client)) == $search_client) {
  91. $snippet_sql = "SELECT id
  92. FROM clients
  93. WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'";
  94. $snippet_q = mysql_query($snippet_sql);
  95. while($i = mysql_fetch_object($snippet_q)) {
  96. $snippet_id = $i->id;
  97. }
  98. $sql = "SELECT snippets.`id` AS `id`,
  99. snippets.`snippet_name` AS `snippet_name`,
  100. snippets.`snippet_file` AS `snippet_file`,
  101. DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
  102. DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
  103. snippets.`created` AS `created`,
  104. snippets.`modified` AS `modified`,
  105. snippets.`clientid` AS `clientid`
  106. FROM snippets, users
  107. WHERE users.userid='" . $_SESSION['userid_auth'] . "'
  108. AND snippets.snippet_name LIKE '%" . $_POST['search'] . "%'";
  109. if($level_auth < "11" || getSetting('onlyShowSnippetsInMyGroup', $_SESSION['userid_auth']) == "0")
  110. $sql .= " AND users.id=snippets.ownerid AND users.groupid = '" . $group_auth . "'";
  111. $sql .= " ORDER BY snippets.`sort` ASC, snippets.`modified` DESC, snippets.`created` DESC";
  112. $search_text = "Snippets for the client <u>".str_replace($search_client, "", $_POST['search'])."</u>";
  113. // SEARCH SECTION
  114. } else {
  115. $sql = "SELECT snippets.`id` AS `id`,
  116. snippets.`snippet_name` AS `snippet_name`,
  117. snippets.`snippet_hourly` AS `snippet_hourly`,
  118. snippets.`snippet_rate` AS `snippet_rate`,
  119. DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
  120. DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
  121. snippets.`created` AS `created`,
  122. snippets.`modified` AS `modified`,
  123. snippets.`clientid` AS `clientid`
  124. FROM snippets
  125. WHERE userid='" . $_SESSION['userid_auth'] . "'
  126. AND milestoneid='0'
  127. AND completed='" . $completed . "'
  128. AND snippetid='" . $snippet_id . "'";
  129. $sql .= " ORDER BY snippets.`sort` ASC, snippets.`modified` DESC, snippets.`created` DESC";
  130. $search_text = "Search results for the search term <u>".$_POST['search']."</u>";
  131. }
  132. } else { // a search was not performed
  133. $sql = "SELECT snippets.`id` AS `id`,
  134. snippets.`snippet_name` AS `snippet_name`,
  135. snippets.`snippet_code` AS `snippet_code`,
  136. DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
  137. DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
  138. snippets.`created` AS `created`,
  139. snippets.`modified` AS `modified`,
  140. snippets.`clientid` AS `clientid`,
  141. snippets.`projectid` AS `projectid`
  142. FROM snippets
  143. ORDER BY snippets.`modified` DESC, snippets.`created` DESC";
  144. }
  145. if($debugmode) echo "<pre>".$sql."</pre>";
  146. $q = mysql_query($sql);
  147. $total_numrows = mysql_num_rows($q);
  148. if($_POST['search']) echo "<p><strong>" . $search_text . "</strong></p>";
  149. if($notice) {
  150. ?>
  151. <div class="icon-container fadeout">
  152. <img src="<?php echo $basehref; ?>img/icons/button-info.png" class="icon-image" alt="" />
  153. </div>
  154. <div class="icon-text fadeout"><?php echo $notice; ?></div>
  155. <br clear="all" /><br clear="all" />
  156. <?php
  157. }
  158. if($_POST['search'] || $total_numrows) {
  159. ?><table id="snippets" class="rowsbox tablesorter" border="0" cellspacing="0" cellpadding="4" summary="">
  160. <thead>
  161. <tr>
  162. <th class="icon"></th>
  163. <th class="item">Snippet</th>
  164. <th>Client</th>
  165. <th>Project</th>
  166. <th>Updated</th>
  167. <th class="delete"></th>
  168. </tr>
  169. </thead>
  170. <tbody><?php
  171. $j = 0;
  172. while($i = mysql_fetch_object($q)) {
  173. $id = $i->id;
  174. $snippet_name = $i->snippet_name;
  175. $snippet_code = $i->snippet_code;
  176. $created = $i->created;
  177. $modified = $i->modified;
  178. $fcreated = $i->fcreated;
  179. $fmodified = $i->fmodified;
  180. $projectid = $i->projectid;
  181. $clientid = $i->clientid;
  182. if($j % 2 == 0) $rowcolor = "row"; else $rowcolor = "altrow";
  183. ?>
  184. <tr id="item_<?php echo $id; ?>" class="<? echo $rowcolor; ?> item_<? echo $id; ?>">
  185. <td class="icon"><img src="<?php echo $basehref; ?>modules/snippets/img/icons/snippets.png" title="Snippet" alt="" /></td>
  186. <td class="item"><a href="<?php echo $basehref; ?>modules/snippets/ajax/get_snippet.php?id=<? echo $id; ?>" class="snippet" rel="snippet"><? echo $snippet_name; ?></a></td>
  187. <td><?php if($clientid) echo getClientName($clientid); else echo 'Internal'; ?></td>
  188. <td><?php if($projectid) echo getProjectName($projectid); ?></td>
  189. <td><?php if($modified != "0000-00-00 00:00:00" && $modified != "") echo $fmodified; else echo '-'; ?></td>
  190. <td class="moddelete"><a href="" id="<?php echo $id; ?>"><img src="<? echo $basehref; ?>img/icons/button-delete.png" border="0" alt="" /></a></td>
  191. </tr>
  192. <?php
  193. $j++;
  194. }
  195. ?></tbody><?php
  196. if($total_numrows > "10") pagination();
  197. ?></table><?php
  198. }
  199. mysql_close($link);
  200. ?>