/modules/snippets/includes/snippets.inc.php
PHP | 206 lines | 196 code | 6 blank | 4 comment | 41 complexity | 5c33614376b2e21ef4268f9669a881b1 MD5 | raw file
- <div class="navbar">
- <div class="navbar-inner">
- <div class="container">
- <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-images-collapse">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </a>
- <a class="brand" href="<?php echo $basehref; ?>snippets/">Snippets</a>
- <div class="nav-collapse nav-images-collapse collapse">
- <ul class="nav nav-pills">
- <li class="active"><a href="#current" data-toggle="tab">Current</a></li>
- <li><a href="#archived" data-toggle="tab">Archived</a></li>
- </ul>
- <div class="pull-right">
- <form class="navbar-search">
- <input type="text" id="searchbox" class="search-query" placeholder="Search Snippets" data-provide="typeahead">
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <div class="row">
- <div class="span6 pull-left">
- </div>
- <div class="span6 pull-right">
- <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>
- </div>
- </div>
- <br clear="all" /><br clear="all" />
- <?php
- if($_POST['doAddSnippet'] && $link) {
- // add the snippet
- if($_POST['clientid'] != "X") $clientid = $_POST['clientid'];
- if($_POST['projectid'] != "0") $projectid = $_POST['projectid'];
- $sql = "INSERT INTO snippets (
- `snippet_name`,
- `snippet_code`,
- `created`,
- `modified`,
- `clientid`,
- `projectid`,
- `userid`
- ) VALUES (
- '" . $_POST['snippet_name'] . "',
- '" . $_POST['snippet_code'] . "',
- NOW(),
- NOW(),
- '" . $clientid . "',
- '" . $projectid . "',
- '" . $_SESSION['userid_auth'] . "'
- )";
- $q = mysql_query($sql);
- $notice = "Your new image was created.";
- }
- if(getSetting("dateFormat", $_SESSION['userid_auth']) && getSetting("dateFormat", $_SESSION['userid_auth']) != "0") {
- $date_format_setting = getSetting("dateFormat", $_SESSION['userid_auth']);
- }
- if (isset($_POST['search'])) { // a search was performed
- $level_auth = getCurrentUserAccessLevel();
- $group_auth = getCurrentUserGroupID();
- $search_client = "Client: ";
- // CLIENT SECTION
- if(substr($_POST['search'], 0, strlen($search_client)) == $search_client) {
- $snippet_sql = "SELECT id
- FROM clients
- WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'";
- $snippet_q = mysql_query($snippet_sql);
- while($i = mysql_fetch_object($snippet_q)) {
- $snippet_id = $i->id;
- }
- $sql = "SELECT snippets.`id` AS `id`,
- snippets.`snippet_name` AS `snippet_name`,
- snippets.`snippet_hourly` AS `snippet_hourly`,
- snippets.`snippet_rate` AS `snippet_rate`,
- DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
- DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
- snippets.`created` AS `created`,
- snippets.`modified` AS `modified`,
- snippets.`clientid` AS `clientid`
- FROM snippets, users
- WHERE users.userid='" . $_SESSION['userid_auth'] . "'
- AND snippets.snippet_name LIKE '%" . $_POST['search'] . "%'";
- if($level_auth < "11" || getSetting('onlyShowSnippetsInMyGroup', $_SESSION['userid_auth']) == "0")
- $sql .= " AND users.id=snippets.ownerid AND users.groupid = '" . $group_auth . "'";
- $sql .= " ORDER BY snippets.`sort` ASC, snippets.`modified` DESC, snippets.`created` DESC";
- $search_text = "Snippets for the client <u>".str_replace($search_client, "", $_POST['search'])."</u>";
- // PROJECT SECTION
- } elseif(substr($_POST['search'], 0, strlen($search_client)) == $search_client) {
- $snippet_sql = "SELECT id
- FROM clients
- WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'";
- $snippet_q = mysql_query($snippet_sql);
- while($i = mysql_fetch_object($snippet_q)) {
- $snippet_id = $i->id;
- }
- $sql = "SELECT snippets.`id` AS `id`,
- snippets.`snippet_name` AS `snippet_name`,
- snippets.`snippet_file` AS `snippet_file`,
- DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
- DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
- snippets.`created` AS `created`,
- snippets.`modified` AS `modified`,
- snippets.`clientid` AS `clientid`
- FROM snippets, users
- WHERE users.userid='" . $_SESSION['userid_auth'] . "'
- AND snippets.snippet_name LIKE '%" . $_POST['search'] . "%'";
- if($level_auth < "11" || getSetting('onlyShowSnippetsInMyGroup', $_SESSION['userid_auth']) == "0")
- $sql .= " AND users.id=snippets.ownerid AND users.groupid = '" . $group_auth . "'";
- $sql .= " ORDER BY snippets.`sort` ASC, snippets.`modified` DESC, snippets.`created` DESC";
- $search_text = "Snippets for the client <u>".str_replace($search_client, "", $_POST['search'])."</u>";
- // SEARCH SECTION
- } else {
- $sql = "SELECT snippets.`id` AS `id`,
- snippets.`snippet_name` AS `snippet_name`,
- snippets.`snippet_hourly` AS `snippet_hourly`,
- snippets.`snippet_rate` AS `snippet_rate`,
- DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
- DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
- snippets.`created` AS `created`,
- snippets.`modified` AS `modified`,
- snippets.`clientid` AS `clientid`
- FROM snippets
- WHERE userid='" . $_SESSION['userid_auth'] . "'
- AND milestoneid='0'
- AND completed='" . $completed . "'
- AND snippetid='" . $snippet_id . "'";
- $sql .= " ORDER BY snippets.`sort` ASC, snippets.`modified` DESC, snippets.`created` DESC";
- $search_text = "Search results for the search term <u>".$_POST['search']."</u>";
- }
- } else { // a search was not performed
- $sql = "SELECT snippets.`id` AS `id`,
- snippets.`snippet_name` AS `snippet_name`,
- snippets.`snippet_code` AS `snippet_code`,
- DATE_FORMAT(snippets.`created`, '" . $date_format_setting . ", %l:%i %p') AS `fcreated`,
- DATE_FORMAT(snippets.`modified`, '" . $date_format_setting . ", %l:%i %p') AS `fmodified`,
- snippets.`created` AS `created`,
- snippets.`modified` AS `modified`,
- snippets.`clientid` AS `clientid`,
- snippets.`projectid` AS `projectid`
- FROM snippets
- ORDER BY snippets.`modified` DESC, snippets.`created` DESC";
- }
- if($debugmode) echo "<pre>".$sql."</pre>";
- $q = mysql_query($sql);
- $total_numrows = mysql_num_rows($q);
- if($_POST['search']) echo "<p><strong>" . $search_text . "</strong></p>";
- if($notice) {
- ?>
- <div class="icon-container fadeout">
- <img src="<?php echo $basehref; ?>img/icons/button-info.png" class="icon-image" alt="" />
- </div>
- <div class="icon-text fadeout"><?php echo $notice; ?></div>
- <br clear="all" /><br clear="all" />
- <?php
- }
- if($_POST['search'] || $total_numrows) {
- ?><table id="snippets" class="rowsbox tablesorter" border="0" cellspacing="0" cellpadding="4" summary="">
- <thead>
- <tr>
- <th class="icon"></th>
- <th class="item">Snippet</th>
- <th>Client</th>
- <th>Project</th>
- <th>Updated</th>
- <th class="delete"></th>
- </tr>
- </thead>
- <tbody><?php
- $j = 0;
- while($i = mysql_fetch_object($q)) {
- $id = $i->id;
- $snippet_name = $i->snippet_name;
- $snippet_code = $i->snippet_code;
- $created = $i->created;
- $modified = $i->modified;
- $fcreated = $i->fcreated;
- $fmodified = $i->fmodified;
- $projectid = $i->projectid;
- $clientid = $i->clientid;
- if($j % 2 == 0) $rowcolor = "row"; else $rowcolor = "altrow";
- ?>
- <tr id="item_<?php echo $id; ?>" class="<? echo $rowcolor; ?> item_<? echo $id; ?>">
- <td class="icon"><img src="<?php echo $basehref; ?>modules/snippets/img/icons/snippets.png" title="Snippet" alt="" /></td>
- <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>
- <td><?php if($clientid) echo getClientName($clientid); else echo 'Internal'; ?></td>
- <td><?php if($projectid) echo getProjectName($projectid); ?></td>
- <td><?php if($modified != "0000-00-00 00:00:00" && $modified != "") echo $fmodified; else echo '-'; ?></td>
- <td class="moddelete"><a href="" id="<?php echo $id; ?>"><img src="<? echo $basehref; ?>img/icons/button-delete.png" border="0" alt="" /></a></td>
- </tr>
- <?php
- $j++;
- }
- ?></tbody><?php
- if($total_numrows > "10") pagination();
- ?></table><?php
- }
- mysql_close($link);
- ?>