Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- here 'endDate' is the field variable for getting data into datatable
- var handleAllProjectList = function(staffNo) {
- //console.log("here"+appPath+'projects/user/'+staffNo+'/company
- if ($('#m_datatable_latest_orders').length === 0) {
- /'+companyId);
- return;
- }
- var datatable = $('.m_datatable').mDatatable({
- data: {
- type: 'remote',
- source: {
- read: {
- //url: appPath+'projects/user/'+staffNo+'/company/'+companyId,
- url: appPath+'projects/pagedata',
- //url: appPath+'projects/all',
- method: 'GET'
- }
- },
- pageSize: 10,
- saveState: {
- cookie: false,
- webstorage: false
- },
- serverPaging: true,
- serverFiltering: true,
- serverSorting: true
- },
- layout: {
- theme: 'default',
- class: 'm-datatable--brand table table-bordered m-table m-table--border-light',
- scroll: true,
- height: 380,
- footer: false,
- smoothScroll: {
- scrollbarShown: true
- },
- spinner: {
- overlayColor: '#000000',
- opacity: 0,
- type: 'loader',
- state: 'brand',
- message: true
- },
- icons: {
- sort: {asc: 'la la-arrow-up', desc: 'la la-arrow-down'},
- pagination: {
- next: 'la la-angle-right',
- prev: 'la la-angle-left',
- first: 'la la-angle-double-left',
- last: 'la la-angle-double-right',
- more: 'la la-ellipsis-h'
- },
- rowDetail: {expand: 'fa fa-caret-down', collapse: 'fa fa-caret-right'}
- }
- },
- sortable: true,
- filterable: true,
- pagination: true,
- search: {
- // search delay in milliseconds
- delay: 400,
- // input text for search
- input: $('#generalSearch'),
- },
- columns: [{
- field: "projectIdFull",
- title: locale=='de'?"Nummer":"Number",
- /*sortable: false,*/
- width: 70,
- textAlign: 'center'
- }, {
- field: "projectName",
- title: "Name",
- sortable: 'asc',
- filterable: false,
- template: function(row){
- if(row.projectName!=null){
- if(row.projectStatus!='saved'&&row.projectStatus!='gespeichert'){
- return '<a title="'+row.projectName+'" href="'+appPath+'project/'+row.projectId+'/view'+'">'+row.projectName+'</a>';
- }
- else{
- return '<a title="'+row.projectName+'" href="'+appPath+'project/'+row.projectId+'/savedupdate'+'">'+row.projectName+'</a>';
- }
- }
- },
- width: 248
- },
- /*{
- field: "parentProjectName",
- title: "Parent",
- width: 100,
- responsive: {
- visible: 'xl'
- }
- },*/
- {
- field: "projectStatus",
- title: "Status",
- template: function (row) {
- var status = {
- '4': {'title':
- locale=='de'?"geplant":"Planned", 'class': ' m-badge--metal'},
- '1': {'title': locale=='de'?"beantragt":"Applied", 'class': ' m-badge--primary'},
- '3': {'title': locale=='de'?"abgelehnt":"Refused", 'class': ' m-badge--danger'},
- '2': {'title': locale=='de'?"neu":"New", 'class': ' m-badge--info'},
- '5': {'title': locale=='de'?"in Arbeit":"Progress", 'class': ' m-badge--warning'},
- '6': {'title': locale=='de'?"abnahme":"Acceptance", 'class': ' m-badge--focus'},
- '7': {'title': locale=='de'?"abgeschlossen":"Completed", 'class': ' m-badge--success'},
- '8': {'title': locale=='de'?"abgebrochen":"Cancelled", 'class': ' m-badge--danger'},
- '9': {'title': locale=='de'?"obsolet":"Obsolete", 'class': ' m-badge--danger'},
- '10': {'title': locale=='de'?"wartend":"On Hold", 'class': ' m-badge--danger'},
- //'11': {'title': locale=='de'?"Moved to Another Project":"Moved to Another Project", 'class': ' m-badge--danger'},
- '0': {'title': locale=='de'?"gespeichert":"Saved", 'class': ' m-badge--info'}
- var uneditable = '<a href="'+pdfurl+'" target="_blank" title="'+pr+'" ><i class="la la-print"></i></a>
- <a style="color:#ccc !important; cursor:not-allowed" href="javascript:;" ><i class="la la-edit"></i></a>';
- var editable = '
- <a href="'+pdfurl+'" target="_blank" title="'+pr+'" ><i class="la la-print"></i></a>
- <a href="'+appPath+'project/'+pid+'/update" title="'+ed+'" ><i class="la la-edit"></i></a>
- ';
- if(row.projectStatus==1 || row.projectStatus==7 || row.projectStatus==8 || row.projectStatus==9 || row.projectStatus==11 ){
- return uneditable;
- }
- var userIsAllowed = false;
- if(row.projectLeader != null){
- if(row.projectLeader.staffNo == staffNo){
- userIsAllowed = true;
- }
- }
- if(!userIsAllowed){
- if(row.requester != null){
- if(row.requester.staffNo == staffNo){
- userIsAllowed = true;
- }
- }
- }
- if(!userIsAllowed){
- return uneditable;
- }
- return editable;
- },
- width: 50
- }],//
- columnDefs: [
- {
- targets:7,
- render: function ( data, type, row, meta ) {
- if(type === 'display'){
- data = '<a href="{{ agent.url }}/job/' + data + '">' + data + '</a>';
- }
- return data;
- }
- },
- {
- targets:[1,2],
- render: function ( data, type, row, meta ) {
- if(type === 'display' && row[2] != 0 ){
- data = '<a href="{{ agent.url }}/job/' + row[0] + '/' + row[2] + '">' + data + '</a>';
- }
- return data;
- }
- }
- ]
- //
- toolbar: {
- layout: ['pagination','info'],
- placement: ['bottom'],
- items: {
- pagination: {
- type: 'default',
- pages: {
- desktop: {
- layout: 'default',
- pagesNumber: 6
- },
- tablet: {
- layout: 'default',
- pagesNumber: 3
- },
- mobile: {
- layout: 'compact'
- }
- },
- navigation: {
- prev: true,
- next: true,
- first: true,
- last: true
- },
- pageSizeSelect: [5, 10, 30, 50, 100]
- },
- info: true
- }
- },
- translate: {
- records: {
- processing: 'Please Wait...',
- noRecords: locale=='de'?'Keine Datensätze gefunden':'No records found'
- },
- toolbar: {
- pagination: {
- items: {
- default: {
- first: locale=='de'?'Erste':'First',
- prev: locale=='de'?'Vor':'Previous',
- next: locale=='de'?'Nächte':'Next',
- last: locale=='de'?'Letzte':'Last',
- more: locale=='de'?'Weiter Seiten':'More pages',
- input: locale=='de'?'Seitennummer':'Page number',
- select: 'Select page size'
- },
- //info: 'Displaying {{start}} - {{end}} of {{total}} records'
- info: locale=='de'?'{{start}} - {{end}} von {{total}} Datensätze':'Displaying {{start}} - {{end}} of {{total}} records'
- }
- }
- }
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement