Skip welcome & menu and move to editor
Welcome to JS Bin
File
Add library
Share
Login or Register
Blog
Help
Load cached copy from
  • Run with JS
  • Save
  • Share
  • …
 
<!DOCTYPE html>
<html>
<head>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
  <script src="//cdn.datatables.net/1.10.2/js/jquery.dataTables.min.js"></script>
  <script src="http://krtkovo.tranet.cz/jquery.dataTables.yadcf.js"></script>
  <script src="http://krtkovo.tranet.cz/chosen.jquery.js"></script>
  <meta charset="utf-8">
  <title>JS Bin</title>
</head>
<body>
​
  <script>
        $(document).ready(function(){
            
            initializeDataTablesForProjects([{"id":1,"leaderId":1,"name":"project 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"10","finished":"0","userName":null,"userSurname":null,"userId":null,"child":1,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/1","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":2,"leaderId":1,"name":"project 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"10","finished":"0","userName":null,"userSurname":null,"userId":null,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/2","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":3,"leaderId":1,"name":"project 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"10","finished":"0","userName":null,"userSurname":null,"userId":null,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/3","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":4,"leaderId":1,"name":"project 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"10","finished":"0","userName":null,"userSurname":null,"userId":null,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/4","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":5,"leaderId":1,"name":"project 02","customer":"customer 02","platform":"platform 02","product":"product 02","log":"link 02","description":"asd","start":{"date":"2014-08-11 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-30 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"11","finished":"0","userName":"Karel","userSurname":"Kozelka","userId":1,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/5","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail\/1"},{"id":6,"leaderId":1,"name":"project03","customer":"customer03","platform":"platform03","product":"product03","log":"link03","description":"asdas","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"50","finished":"0","userName":"Karel","userSurname":"Kozelka","userId":1,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/6","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail\/1"},{"id":7,"leaderId":1,"name":"vxvxcvxc","customer":"","platform":"","product":"","log":"","description":"","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"0","finished":"0","userName":null,"userSurname":null,"userId":null,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/7","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":8,"leaderId":1,"name":"sad","customer":"","platform":"","product":"","log":"","description":"","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"0","finished":"0","userName":null,"userSurname":null,"userId":null,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/8","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":9,"leaderId":1,"name":"project03","customer":"customer03","platform":"platform03","product":"product03","log":"link03","description":"asdas","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"50","finished":"0","userName":"Karel","userSurname":"Kozelka","userId":1,"child":null,"projectLink":"\/20140708_TRW_nette\/www\/projects\/project-detail\/9","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail\/1"}],{"u1":[{"id":1,"parentProjectId":1,"name":"task 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"0","finished":"0","parentTaskId":null,"createdBy":1,"level":0,"projectName":"project 01","userName":null,"userSurname":null,"userId":null,"parentName":null,"childId":null,"taskLink":"\/20140708_TRW_nette\/www\/tasks\/task-detail\/1","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":2,"parentProjectId":1,"name":"project 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-20 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"0","finished":"0","parentTaskId":null,"createdBy":1,"level":0,"projectName":"project 01","userName":null,"userSurname":null,"userId":null,"parentName":null,"childId":null,"taskLink":"\/20140708_TRW_nette\/www\/tasks\/task-detail\/2","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"},{"id":3,"parentProjectId":1,"name":"project 01 task 01","customer":"customer","platform":"platform","product":"product","log":"log","description":"desc","start":{"date":"2014-08-27 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"end":{"date":"2014-08-27 00:00:00","timezone_type":3,"timezone":"Europe\/Prague"},"priority":"0","finished":"0","parentTaskId":null,"createdBy":1,"level":0,"projectName":"project 01","userName":null,"userSurname":null,"userId":null,"parentName":null,"childId":null,"taskLink":"\/20140708_TRW_nette\/www\/tasks\/task-detail\/3","userLink":"\/20140708_TRW_nette\/www\/users\/user-detail"}]},"\/20140708_TRW_nette\/www",["leader"])
        });
        
        </script>
<div id="projects">
​
​
    <table id="projects_table">
        <thead>
            <tr>
                <th></th>
                <th>Project ID</th>
​
                <th>Customer</th>
                <th>Platform</th>
                <th>Product</th>
                <th>Assigned</th>            
                <th>Start</th>
                <th>End</th>       
                <th>Done</th>
                <th>Prio</th>
                <th>Link</th>
                <th></th>
​
            </tr>
        </thead>
​
    </table>
    <div class="cleaner"></div>
    <form id="exportTasksForm" class="exportForm" action="{plink Tasks:tasksToExcel}" method="post">
        <input id="taskFormValue" type="hidden" name="taskData" >
        <input type="submit" value="Export tasks">
    </form>
    <form id="exportProjectsForm" class="exportForm" action="{plink Projects:projectsToExcel}" method="post">
        <input id="projectFormValue" type="hidden" name="projectData" >
        <input type="submit" value="Export projects">
    </form>
    <div class="cleaner"></div>
      
    
</div>  
​
​
​
​
​
​
</body>
</html>
 
/*!
Chosen, a Select Box Enhancer for jQuery and Prototype
by Patrick Filler for Harvest, http://getharvest.com
​
Version 1.1.0
Full source at https://github.com/harvesthq/chosen
Copyright (c) 2011 Harvest http://getharvest.com
​
MIT License, https://github.com/harvesthq/chosen/blob/master/LICENSE.md
This file is generated by `grunt build`, do not edit it by hand.
*/
​
/* @group Base */
.chosen-container {
  position: relative;
  display: inline-block;
  vertical-align: middle;
  font-size: 10px;
  zoom: 1;
  *display: inline;
  -webkit-user-select: none;
  -moz-user-select: none;
  user-select: none;
}
.chosen-container .chosen-drop {
  position: absolute;
  top: 100%;
  left: -9999px;
  z-index: 1010;
  -webkit-box-sizing: border-box;
  -moz-box-sizing: border-box;
  box-sizing: border-box;
  width: 100%;
  border: 1px solid #aaa;
  border-top: 0;
  background: #fff;
  box-shadow: 0 4px 5px rgba(0, 0, 0, 0.15);
}
.chosen-container.chosen-with-drop .chosen-drop {
  left: 0;
}
.chosen-container a {
  cursor: pointer;
}
​
/* @end */
/* @group Single Chosen */
.chosen-container-single .chosen-single {
  position: relative;
  display: block;
  overflow: hidden;
  padding: 0 0 0 8px;
  height: 23px;
  border: 1px solid #aaa;
  border-radius: 5px;
  background-color: #fff;
  background: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(20%, #ffffff), color-stop(50%, #f6f6f6), color-stop(52%, #eeeeee), color-stop(100%, #f4f4f4));
  background: -webkit-linear-gradient(top, #ffffff 20%, #f6f6f6 50%, #eeeeee 52%, #f4f4f4 100%);
  background: -moz-linear-gradient(top, #ffffff 20%, #f6f6f6 50%, #eeeeee 52%, #f4f4f4 100%);
  background: -o-linear-gradient(top, #ffffff 20%, #f6f6f6 50%, #eeeeee 52%, #f4f4f4 100%);
  background: linear-gradient(top, #ffffff 20%, #f6f6f6 50%, #eeeeee 52%, #f4f4f4 100%);
  background-clip: padding-box;
  box-shadow: 0 0 3px white inset, 0 1px 1px rgba(0, 0, 0, 0.1);
  color: #444;
  text-decoration: none;
  white-space: nowrap;
  line-height: 24px;
}
.chosen-container-single .chosen-default {
  color: #999;
}
.chosen-container-single .chosen-single span {
  display: block;
  overflow: hidden;
  margin-right: 26px;
  text-overflow: ellipsis;
  white-space: nowrap;
}
.chosen-container-single .chosen-single-with-deselect span {
  margin-right: 38px;
}
.chosen-container-single .chosen-single abbr {
  position: absolute;
  top: 6px;
  right: 26px;
  display: block;
  width: 12px;
  height: 12px;
  background: url('chosen-sprite.png') -42px 1px no-repeat;
  font-size: 1px;
}
.chosen-container-single .chosen-single abbr:hover {
  background-position: -42px -10px;
}
.chosen-container-single.chosen-disabled .chosen-single abbr:hover {
  background-position: -42px -10px;
}
.chosen-container-single .chosen-single div {
  position: absolute;
  top: 0;
  right: 0;
  display: block;
  width: 18px;
  height: 100%;
}
.chosen-container-single .chosen-single div b {
  display: block;
  width: 100%;
  height: 100%;
  background: url('chosen-sprite.png') no-repeat 0px 2px;
}
.chosen-container-single .chosen-search {
  position: relative;
  z-index: 1010;
  margin: 0;
  padding: 3px 4px;
  white-space: nowrap;
}
.chosen-container-single .chosen-search input[type="text"] {
  -webkit-box-sizing: border-box;
  -moz-box-sizing: border-box;
  box-sizing: border-box;
  margin: 1px 0;
  padding: 4px 20px 4px 5px;
  width: 100%;
  height: auto;
  outline: 0;
  border: 1px solid #aaa;
  background: white url('chosen-sprite.png') no-repeat 100% -20px;
  background: url('chosen-sprite.png') no-repeat 100% -20px;
  font-size: 1em;
  font-family: sans-serif;
  line-height: normal;
  border-radius: 0;
}
.chosen-container-single .chosen-drop {
  margin-top: -1px;
  border-radius: 0 0 4px 4px;
  background-clip: padding-box;
}
.chosen-container-single.chosen-container-single-nosearch .chosen-search {
  position: absolute;
  left: -9999px;
}
​
/* @end */
/* @group Results */
.chosen-container .chosen-results {
  position: relative;
  overflow-x: hidden;
  overflow-y: auto;
  margin: 0 4px 4px 0;
  padding: 0 0 0 4px;
  max-height: 240px;
  -webkit-overflow-scrolling: touch;
}
.chosen-container .chosen-results li {
  display: none;
  margin: 0;
  padding: 5px 6px;
  list-style: none;
  line-height: 15px;
  -webkit-touch-callout: none;
}
.chosen-container .chosen-results li.active-result {
  display: list-item;
  cursor: pointer;
}
.chosen-container .chosen-results li.disabled-result {
  display: list-item;
  color: #ccc;
  cursor: default;
}
.chosen-container .chosen-results li.highlighted {
  background-color: #3875d7;
  background-image: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(20%, #3875d7), color-stop(90%, #2a62bc));
  background-image: -webkit-linear-gradient(#3875d7 20%, #2a62bc 90%);
  background-image: -moz-linear-gradient(#3875d7 20%, #2a62bc 90%);
  background-image: -o-linear-gradient(#3875d7 20%, #2a62bc 90%);
  background-image: linear-gradient(#3875d7 20%, #2a62bc 90%);
  color: #fff;
}
.chosen-container .chosen-results li.no-results {
  display: list-item;
  background: #f4f4f4;
}
.chosen-container .chosen-results li.group-result {
  display: list-item;
  font-weight: bold;
  cursor: default;
}
.chosen-container .chosen-results li.group-option {
  padding-left: 15px;
}
.chosen-container .chosen-results li em {
  font-style: normal;
  text-decoration: underline;
}
​
/* @end */
/* @group Multi Chosen */
.chosen-container-multi .chosen-choices {
  position: relative;
  overflow: hidden;
  -webkit-box-sizing: border-box;
  -moz-box-sizing: border-box;
  box-sizing: border-box;
  margin: 0;
  padding: 0;
  width: 100%;
  height: auto !important;
  height: 1%;
  border: 1px solid #aaa;
  background-color: #fff;
  background-image: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(1%, #eeeeee), color-stop(15%, #ffffff));
  background-image: -webkit-linear-gradient(#eeeeee 1%, #ffffff 15%);
  background-image: -moz-linear-gradient(#eeeeee 1%, #ffffff 15%);
  background-image: -o-linear-gradient(#eeeeee 1%, #ffffff 15%);
  background-image: linear-gradient(#eeeeee 1%, #ffffff 15%);
  cursor: text;
}
.chosen-container-multi .chosen-choices li {
  float: left;
  list-style: none;
}
.chosen-container-multi .chosen-choices li.search-field {
  margin: 0;
  padding: 0;
  white-space: nowrap;
}
.chosen-container-multi .chosen-choices li.search-field input[type="text"] {
  margin: 1px 0;
  padding: 5px;
  height: 15px;
  outline: 0;
  border: 0 !important;
  background: transparent !important;
  box-shadow: none;
  color: #666;
  font-size: 100%;
  font-family: sans-serif;
  line-height: normal;
  border-radius: 0;
}
.chosen-container-multi .chosen-choices li.search-field .default {
  color: #999;
}
.chosen-container-multi .chosen-choices li.search-choice {
  position: relative;
  margin: 3px 0 3px 5px;
  padding: 3px 20px 3px 5px;
  border: 1px solid #aaa;
  border-radius: 3px;
  background-color: #e4e4e4;
  background-image: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(20%, #f4f4f4), color-stop(50%, #f0f0f0), color-stop(52%, #e8e8e8), color-stop(100%, #eeeeee));
  background-image: -webkit-linear-gradient(#f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-image: -moz-linear-gradient(#f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-image: -o-linear-gradient(#f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-image: linear-gradient(#f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-clip: padding-box;
  box-shadow: 0 0 2px white inset, 0 1px 0 rgba(0, 0, 0, 0.05);
  color: #333;
  line-height: 13px;
  cursor: default;
}
.chosen-container-multi .chosen-choices li.search-choice .search-choice-close {
  position: absolute;
  top: 4px;
  right: 3px;
  display: block;
  width: 12px;
  height: 12px;
  background: url('chosen-sprite.png') -42px 1px no-repeat;
  font-size: 1px;
}
.chosen-container-multi .chosen-choices li.search-choice .search-choice-close:hover {
  background-position: -42px -10px;
}
.chosen-container-multi .chosen-choices li.search-choice-disabled {
  padding-right: 5px;
  border: 1px solid #ccc;
  background-color: #e4e4e4;
  background-image: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(20%, #f4f4f4), color-stop(50%, #f0f0f0), color-stop(52%, #e8e8e8), color-stop(100%, #eeeeee));
  background-image: -webkit-linear-gradient(top, #f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-image: -moz-linear-gradient(top, #f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-image: -o-linear-gradient(top, #f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  background-image: linear-gradient(top, #f4f4f4 20%, #f0f0f0 50%, #e8e8e8 52%, #eeeeee 100%);
  color: #666;
}
.chosen-container-multi .chosen-choices li.search-choice-focus {
  background: #d4d4d4;
}
.chosen-container-multi .chosen-choices li.search-choice-focus .search-choice-close {
  background-position: -42px -10px;
}
.chosen-container-multi .chosen-results {
  margin: 0;
  padding: 0;
}
.chosen-container-multi .chosen-drop .result-selected {
  display: list-item;
  color: #ccc;
  cursor: default;
}
​
/* @end */
/* @group Active  */
.chosen-container-active .chosen-single {
  border: 1px solid #5897fb;
  box-shadow: 0 0 5px rgba(0, 0, 0, 0.3);
}
.chosen-container-active.chosen-with-drop .chosen-single {
  border: 1px solid #aaa;
  -moz-border-radius-bottomright: 0;
  border-bottom-right-radius: 0;
  -moz-border-radius-bottomleft: 0;
  border-bottom-left-radius: 0;
  background-image: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(20%, #eeeeee), color-stop(80%, #ffffff));
  background-image: -webkit-linear-gradient(#eeeeee 20%, #ffffff 80%);
  background-image: -moz-linear-gradient(#eeeeee 20%, #ffffff 80%);
  background-image: -o-linear-gradient(#eeeeee 20%, #ffffff 80%);
  background-image: linear-gradient(#eeeeee 20%, #ffffff 80%);
  box-shadow: 0 1px 0 #fff inset;
}
.chosen-container-active.chosen-with-drop .chosen-single div {
  border-left: none;
  background: transparent;
}
.chosen-container-active.chosen-with-drop .chosen-single div b {
  background-position: -18px 2px;
}
.chosen-container-active .chosen-choices {
  border: 1px solid #5897fb;
  box-shadow: 0 0 5px rgba(0, 0, 0, 0.3);
}
.chosen-container-active .chosen-choices li.search-field input[type="text"] {
  color: #111 !important;
}
​
/* @end */
/* @group Disabled Support */
.chosen-disabled {
  opacity: 0.5 !important;
  cursor: default;
}
.chosen-disabled .chosen-single {
  cursor: default;
}
.chosen-disabled .chosen-choices .search-choice .search-choice-close {
  cursor: default;
}
​
/* @end */
/* @group Right to Left */
.chosen-rtl {
  text-align: right;
}
.chosen-rtl .chosen-single {
  overflow: visible;
  padding: 0 8px 0 0;
}
.chosen-rtl .chosen-single span {
  margin-right: 0;
  margin-left: 26px;
  direction: rtl;
}
.chosen-rtl .chosen-single-with-deselect span {
  margin-left: 38px;
}
.chosen-rtl .chosen-single div {
  right: auto;
  left: 3px;
}
.chosen-rtl .chosen-single abbr {
  right: auto;
  left: 26px;
}
.chosen-rtl .chosen-choices li {
  float: right;
}
.chosen-rtl .chosen-choices li.search-field input[type="text"] {
  direction: rtl;
}
.chosen-rtl .chosen-choices li.search-choice {
  margin: 3px 5px 3px 0;
  padding: 3px 5px 3px 19px;
}
.chosen-rtl .chosen-choices li.search-choice .search-choice-close {
  right: auto;
  left: 4px;
}
.chosen-rtl.chosen-container-single-nosearch .chosen-search,
.chosen-rtl .chosen-drop {
  left: 9999px;
}
.chosen-rtl.chosen-container-single .chosen-results {
  margin: 0 0 4px 4px;
  padding: 0 4px 0 0;
}
.chosen-rtl .chosen-results li.group-option {
  padding-right: 15px;
  padding-left: 0;
}
.chosen-rtl.chosen-container-active.chosen-with-drop .chosen-single div {
  border-right: none;
}
.chosen-rtl .chosen-search input[type="text"] {
  padding: 4px 5px 4px 20px;
  background: white url('chosen-sprite.png') no-repeat -30px -20px;
  background: url('chosen-sprite.png') no-repeat -30px -20px;
  direction: rtl;
}
.chosen-rtl.chosen-container-single .chosen-single div b {
  background-position: 6px 2px;
}
.chosen-rtl.chosen-container-single.chosen-with-drop .chosen-single div b {
  background-position: -12px 2px;
}
​
/* @end */
/* @group Retina compatibility */
@media only screen and (-webkit-min-device-pixel-ratio: 2), only screen and (min-resolution: 144dpi) {
  .chosen-rtl .chosen-search input[type="text"],
  .chosen-container-single .chosen-single abbr,
  .chosen-container-single .chosen-single div b,
  .chosen-container-single .chosen-search input[type="text"],
  .chosen-container-multi .chosen-choices .search-choice .search-choice-close,
  .chosen-container .chosen-results-scroll-down span,
  .chosen-container .chosen-results-scroll-up span {
    background-image: url('chosen-sprite@2x.png') !important;
    background-size: 52px 37px !important;
    background-repeat: no-repeat !important;
  }
}
/* @end */
 
var userRole;
var taskFilterData = new Array();
var allTablesNames = new Array();
​
function initializeDataTablesForProjects(projectTableData, taskTableData, basePath, loggedUserRole){
    var projectsTable; 
    userRole = loggedUserRole;
   
    //create main table for projects
    projectsTable = initializeProjectsDataTable(projectTableData, basePath);
    fillTaskFilterData(taskTableData);
    
   
    
}
​
//prepare taskFilterData array for filtering task subtables
function fillTaskFilterData(taskTableData){
    for (var x in taskTableData){
        allTablesNames.push(x);
        for (var y in taskTableData[x]){
            taskFilterData.push(taskTableData[x][y]);
        }
    }
}
​
​
​
//initialize main table for projects
//@param tableData - array with projects data
//@param basepath - project path
function initializeProjectsDataTable(tableData, basePath){
    //var projectsTableWorker = new $.fn.dataTable.Api('#projects_table');
    
    var projectsTable;
       projectsTable = $('#projects_table').DataTable({
       "dom": '<"cleaner">lf<"cleaner">T<"cleaner"><"cleaner">rtip',
       "stateSave": true,
       "data":tableData,
       "tableTools":{
           "aButtons": [{
                "sExtends": "text",
                "sButtonText": "Reset filters",
                "fnClick": function (mButton, oConfig, oFlash){
                    
                }
           }]
       },
       "columns":[
         {"data": null,"type": "html"},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null},
         {"data": null}
       ],       
       "columnDefs": [
           {   
               "targets":0,
               
               "render": function (data, type, row){
                  
                   if(data.child == null){
                        return '<img class=addNewTaskDialogOpener data-id="p' + data.id + '" class="addButtonImg"  src=' + basePath + '/images/addButton.png ">';
                   }else{
                        return '<img class=addNewTaskDialogOpener data-id="p' + data.id + '" class="addButtonImg" src=' + basePath + '/images/addButton.png ">'+'<img id="p' + data.id + '" class="showHideImage" src=' + basePath + '/images/plus.png>';
                   }               
               }
           
           },
           {   
               "targets":1,
               "filter": 'name',
               "render": function (data, type, row){
                   return '<a href='+data.projectLink+'>'+data.name+'</a>';              
               }   
           },
           {   
               "targets":2,
               "render": "customer",
               "filter": "customer"
               
           },
           {   "targets":3,
               "render": "platform"   
           },
           {   
               "targets":4,
               "render": "product"  
           },
           {   
               "targets":5,
               "render": function (data, type, row){
                   if(data.userId == null){
                        return "none";
                   }else{
                        return '<a href=' + data.userLink + '>' + data.userName + ' ' + data.userSurname + '</a>';
                   }              
               }   
           },
           {   
               "targets":6,
               "render": function (data, type, row){
                   var datum = data.start.date.split(" ")[0].split("-");
               
                   return datum[2]+'.'+datum[1]+'.'+datum[0];             
               }   
           },
           {   
               "targets":7,
               "render": function (data, type, row){
                   var datum = data.end.date.split(" ")[0].split("-");
               
                    return datum[2]+'.'+datum[1]+'.'+datum[0];            
               }   
           },
           {   
               "targets":8,
               "render": function (data, type, row){
                   if (userRole == "viewOnly"){
                        if(data.finished == "1"){
                            return "Yes";
                        }else{
                            return "No";
                        }
                   }else{
                        if(data.finished=="1"){
                            return "<input type='checkbox' class='finish_button_pr' value='"+data.id+"' checked><span id='check_label_pr"+data.id+"'>Yes</span>";
                        }else{
                            return "<input type='checkbox' class='finish_button_pr' value='" + data.id + "'><span id='check_label_pr" + data.id + "'>No</span>";
                        }
                   }             
               }   
           },
           {   
               "targets":9,
               "render": "priority"            
                  
           },
           {   
               "targets":10,
               "render": function (data, type, row){
                   if(data.log==""){
                        return "none";
                    }else{
                        return "<a href='file://" + data.log + "'><img src=" + basePath + "/images/log.png></a>";
                    }               
               }   
           },
           {   
               "targets":11,
               "render": function (data, type, row){
                   if (userRole == "viewOnly"){
                        return "";
                    }else{
                        return "<img src=" + basePath + "/images/deleteButton.png onclick='deleteProjectRow(this,"+data.id+");'>";
                    }              
               }   
           },
       ]
       
    });
    yadcf.init(projectsTable,[           
           {column_number :1,            
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :2,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :3,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :4,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :5,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :6,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :7,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :8,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :9,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :10,
            filter_type: "multi_select",
            select_type: 'chosen'
           },
           {column_number :11,
            filter_type: "multi_select",
            select_type: 'chosen'
           }
       ])
       console.log(projectsTable)
    return projectsTable;
}
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers