SPServices with Datatables

<!–/exec/Style%20Library/code/script/jquery-3.2.1.min.js–>
<!–/mgt/Style%20Library/Code/KEPAS/KEYScripts/MyScript.js–>
<style>
.HideLinks{
display:none;
}
.exSize{

/*max-height:500px;*/
/*background:#CCCCCC;*/

padding:5px;
max-width:800px;
margin-left:-30px;
margin-bottom:3px;
margin-top:3px;
margin-right:3px;
}
.ExecList{

}
.ExecList a{

display:block;
/*background:#002040;*/
color:#006699!important;
margin:1px;
padding:2px;
text-decoration:none;
font-weight:bold;
}
.ExecList a:hover{
/*background:#004284;*/
text-decoration:none;

}
.LeadingStory{
color:#FFFFFF;
font-weight:bold;
font-size:14px;
padding:5px;
}
.ExecSelected{
color:#000000!important;
font-weight:bold;
font-size:13px;
text-decoration:underline!important;
}
.HeadColor{
background:#2B3759;
}
.LeadingLinks{

}
.LeadingLinks:hover{
color:#CC0000!important;
}

.ContactTable{
width:70%;
border:0;
}
.ContactTable th{
background:#2B3759;
color:#FFFFFF;
padding:5px;

}
.ContactTable td{

color:#002142;
border-bottom:thin silver solid;
}
.ContactTable tr:hover{
background:#B6DBF1!important;
}
.btnStyle{
background:#002448;
color:#FFFFFF;
padding:5px;
width:200px;

}
.btnStyle:hover{
background:#A6D2FF;
color:#000000;
}
.textAreaStyle{
width:200px;
height:50px;

}

.ServiceItem{
background:#3292C0; color:#FFFFFF; width:130px; height:40px;
margin-bottom:5px;
margin-left:5px;
font-weight:bold; color:#FFFFFF;
font-size:10px;
}
.ServiceItem:hover{
background:#66B3D7;
cursor:pointer;
}
.TabSelected{
background:#FF9900!important;

}

.ViewDetails{
font-weight:bold;
}

.HideMe{
display:none;
}
#ctl00_MSO_ContentDiv{
min-width:1600px;
}
.ListData{
margin-left:20px;
margin-right:20px;
}

/*————-:):):)—————*/
.container{
/*width: 800px;*/
margin: 0 auto;
}

ul.tabs{
margin: 0px;
padding: 0px;
list-style: none;
}
ul.tabs li{
background: #A3C6DA;
color: #222;
display: inline-block;
padding: 10px 15px;
cursor: pointer;
font-weight:bold;
border-bottom:thin #CCCCCC solid;
font-size:14px;

border-top:4px #008484 solid;
}
ul.tabs li:hover{
background:#008484;
color:#FFFFFF;
border-top:4px #CC0000 solid;
}

ul.tabs li.current{
/*background: #ededed;*/
background:#008484;
color:#FFFFFF;
border-top:4px #CC0000 solid;
}

.tab-content{
display: none;
/*background: #ededed;*/
background:#EEF4F9;
padding: 15px;
}

.tab-content.current{
display: inherit;
}
.PTitle{
font-weight:bold;
font-size:28px;
color:#183D4E;
font-family:Georgia;
}
.tab-link{
background:#A3C6DA;
}

.HeadingDiv{
/*background:#DBECF7;*/
padding:10px;
}
.Loading{
background:#DDEFF4!important;
color:#FFFFFF!important;
}

.table-warning,
.table-warning > th,
.table-warning > td {
background-color: #FFF7E6!important;
}
.GreanSearch{
border:thin #99CC00 solid!important;
border-width:2px!important;
}

.buttons-print{
width:100px;
background:#C0C0C0;
color:#FFFFFF;
height:30px;
/*border:thin #BB0000 outset;
border-style:outset;*/
border:thin #CCCCCC solid;
font-size:14px;
}
.buttons-print:hover{
background:#FF4A4A;
cursor:pointer;
}

.dt-buttons{

margin-bottom:-30px;
}

.input-sm{
width:250px!important;
border:thin #99CC00 solid!important;
border-width:1px!important;
}

</style>

<link rel=”stylesheet” type=”text/css” href=”/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/myStyle.css”>
<link rel=”stylesheet” type=”text/css” href=”/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/MyStyleNew.css”>

<!–<link rel=”stylesheet” type=”text/css” href=”/mgt/Style Library/Code/KEPAS/KEYScripts/css/bootstrap.css”>–>

/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/TablesD.js

<!–/mgt/Style%20Library/Code/KEPAS/KEYScripts/MyTable.js–>
/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/Mybootstrap.min.js

<link rel=”stylesheet” type=”text/css” href=”/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/JUI.css”>

<!–
<link rel=”stylesheet” href=”/mgt/Style Library/Code/KEPAS/KEYScripts/Scripts/DataTables-1.10.16/js/Boot.css” type=”text/css”>
<link rel=”stylesheet” href=”/mgt/Style Library/Code/KEPAS/KEYScripts/Scripts/DataTables-1.10.16/js/Data.css” type=”text/css”>
<link rel=”stylesheet” href=”/mgt/Style Library/Code/KEPAS/KEYScripts/Scripts/DataTables-1.10.16/js/BootData.css”>

/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/DataTables-1.10.16/js/jQuery-1.12.48.js
/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/DataTables-1.10.16/js/Data.js
/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/DataTables-1.10.16/js/BootJS.js–>

$( function() {
$( “#tabsContent” ).dialog({ modal: true});
} );

Loading may take several seconds.

</div>

US Embassy Kabul Phone Directory

• US Direct Hires
• LES/TCN
• Third Party Contractors
• All

Last Name	First Name	Email	Mobile Local	Office Ext	Section	Position Title

</div>

Last Name	First Name	Email	Mobile Local	Office Ext	Section	Position Title

</div>

Last Name	First Name	Email	Mobile Local	Office Ext	Section	Position Title	Employment Category	Contracting Company

</div>

Last Name	First Name	Email	Mobile Local	Office Ext	Section	Position Title	Contracting Company

</div>
</div><!– container –>

/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/BT.js
/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/Print.js

<!–/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/Zip.js
/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/PDF.js
/mgt/Style%20Library/Code/KEPAS/KEYScripts/Scripts/html5.js–>

var LES_Clk = 0;
var CON_Clk=0;
var All_Clk=0;
var US_Clk=0;

$(document).ready(function(){

$(‘ul.tabs li’).click(function(){
var n = $(this).attr(‘data-tab’);
$(“#tabsContent” ).dialog();

if(n==”tab-ALL”)
{
getAllRecords();
}
else if(n==”tab-Sections”)
{
window.location.href(“/mgt/hr/OIP/SitePages/Sections.aspx”);
}
else if(n==”tab-US”)
{
GetUSDirect();
}
else
{
SPGetLESTCN(n);
}

$(‘ul.tabs li’).removeClass(‘current’);
$(‘.tab-content’).removeClass(‘current’);

$(this).addClass(‘current’);
$(“#”+n).addClass(‘current’);

})

});

Search All:

 </tr>
</table>
</div>

</div>

<span id=”myAuto”></span>

</div>
<!–<link rel=”stylesheet” href=”/mgt/Style Library/Code/MyScripts/jquery-ui.css”>
/mgt/Style%20Library/Code/MyScripts/Jquery-ui.js–>

$(“document”).ready(function(){

var Current = window.location.href.slice(window.location.href.indexOf(‘?’) + 1).split(‘&’);
if(Current==”All”)
{
$(“#TabUS”).removeClass(“current”);
$(“#tab-US”).removeClass(“current”);
$(“#TabAll”).addClass(“current”);
getAllRecords();
}
else if(Current==”LES”)
{
$(“#TabUS”).removeClass(“current”);
$(“#tab-US”).removeClass(“current”);
$(“#TabLES”).addClass(“current”);
$(“#tab-LES”).addClass(“current”);

var Ls = “tab-LES”;
SPGetLESTCN(Ls);
}
else if(Current==”CON”)
{
$(“#TabUS”).removeClass(“current”);
$(“#tab-US”).removeClass(“current”);
$(“#TabCON”).addClass(“current”);
$(“#tab-CON”).addClass(“current”);

var Ls = “tab-CON”;
SPGetLESTCN(Ls);

}
else
{

var Check = “8578;#RAO – Regional Affairs Office”;
var Checked = Check.replace(/[0-9]/g, ”);
var XM=0;
var Bootstrap = “”;
var US = “”;
var LocalEs = “Local Staff (FSN, TCN, EFM, PSA, PSC)”;
var USA = “U.S.-Based Direct Hire (FS, CS, Military, FSL, LNA, EFM, 3161)”;
var PFields = “”;
var SPCaml =””;
SPCaml +=””;
SPCaml +=””;

setTimeout(function(){
$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPCaml ,
CAMLQuery: “”+USA+””,
//alert(SPPermission);
completefunc: function (xData, Status) {
count = $(xData.responseXML.xml).find(“rs\\:data, data”).attr(“ItemCount”);
if(count>0)
{
$(“#tabsContent”).dialog(“close”);
$(“#USA”).html(count);
}
var MyData=”

“; $(xData.responseXML).SPFilterNode(“z:row”).each(function() {var ID= $(this).attr(“ows_ID”);
var LastName= $(this).attr(“ows_EmployeeLastName”);
var FirstName= $(this).attr(“ows_EmployeeFirstName”);
var Email= $(this).attr(“ows_Email_x0020_Address”);
var Mobile= $(this).attr(“ows_Mobile_x0020_Local”);var Section = $(this).attr(“ows_Position_x003a_Office_x0020_Desc”);var TempSec = “‘”+Section+”‘”;
var TempSec2 = TempSec.replace(/[0-9]/g, ”);
var NewSecion= TempSec2.replace(“;#”,”);//NewSecion= NewSecion.replace(“‘”,””);
//NewSecion= NewSecion.replace(“‘”,””);var Extension= $(this).attr(“ows_Office_x0020_Extension”);
//var AccountStatus= $(this).attr(“ows_Accountability_x0020_Status”);var Pos = $(this).attr(“ows_Position_x003a_PositionDescripti”);
var EempCat = $(this).attr(“ows_Position_x003a_EmploymentCategor0”);var TempPos = “‘”+Pos+”‘”;
var TempPos2= TempPos.replace(/[0-9]/g, ”);
var StaffPos= TempPos2.replace(“;#”,”);var TempCat = “‘”+EempCat+”‘”;
var TempCatx = TempCat.replace(/[0-9]/g, ”);
var ECats= TempCatx.replace(“;#”,”);var Pfield= $(this).attr(“ows_Employee_x0020_Person_x0020_Fiel”);
var Ddate= $(this).attr(“ows_DepartureDate”);
if(XM%2==0)
{
Bootstrap = “table-warning”;
}
else
{
Bootstrap = “”;
}
NewSecion= NewSecion.replace(/[“‘]/g, “”);
StaffPos= StaffPos.replace(/[“‘]/g, “”);if(Email==null)
{
Email=””;
}
Email= ““+Email+”“;if(Mobile==null)
{
Mobile=””;
}
if(Extension==null)
{
Extension=””;
}
if(LastName==null)
{
LastName=””;
}
if(FirstName==null)
{
FirstName=””;
}MyData= MyData+””;
//ops = “”;//var Temp = $(“#Row1”).append(ops);
//$(“#Row1″).replaceWith(Temp);
XM++;});
MyData+=””;
$(“#MyList”).append(MyData);
}
});

$(‘#MyList’).DataTable( {
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]
});

$(‘#MyList’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered table-hover’);

US_Clk=1;
$(“#tabsContent”).dialog(“close”);
},100);

//——End URL—————//
}

//——————-End———————————-//
});

//==========Get US Direct Hires==============//
function GetUSDirect()
{
if(US_Clk==0)
{
$(“#TabCON”).removeClass(“current”);
$(“#tab-CON”).removeClass(“current”);
$(“#TabCON”).addClass(“current”);
$(“#tab-CON”).addClass(“current”);

$(“#TabUS”).addClass(“current”);
$(“#tab-US”).addClass(“current”);
$(“#TabLES”).removeClass(“current”);
$(“#tab-LES”).removeClass(“current”);
$(“#TabAll”).removeClass(“current”);
$(“#tab-ALL”).removeClass(“current”);

var XM=0;
var Bootstrap = “”;
var US = “”;
var LocalEs = “Local Staff (FSN, TCN, EFM, PSA, PSC)”;
var USA = “U.S.-Based Direct Hire (FS, CS, Military, FSL, LNA, EFM, 3161)”;
var PFields = “”;
var SPCaml =””;
SPCaml +=””;
SPCaml +=”/ViewFields>”;

setTimeout(function(){
$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPCaml ,
CAMLQuery: “”+USA+””,
//alert(SPPermission);
completefunc: function (xData, Status) {
count = $(xData.responseXML.xml).find(“rs\\:data, data”).attr(“ItemCount”);
if(count>0)
{
$(“#tabsContent”).dialog(“close”);
$(“#USA”).html(count);
}
var MyData=”

“; $(xData.responseXML).SPFilterNode(“z:row”).each(function() {var ID= $(this).attr(“ows_ID”);
var LastName= $(this).attr(“ows_EmployeeLastName”);
var FirstName= $(this).attr(“ows_EmployeeFirstName”);
var Email= $(this).attr(“ows_Email_x0020_Address”);
var Mobile= $(this).attr(“ows_Mobile_x0020_Local”);
var Section = $(this).attr(“ows_Position_x003a_Office_x0020_Desc”);var TempSec = “‘”+Section+”‘”;
var TempSec2 = TempSec.replace(/[0-9]/g, ”);
var NewSecion= TempSec2.replace(“;#”,”);var Extension= $(this).attr(“ows_Office_x0020_Extension”);
//var AccountStatus= $(this).attr(“ows_Accountability_x0020_Status”);var Pos = $(this).attr(“ows_Position_x003a_PositionDescripti”);
var EempCat = $(this).attr(“ows_Position_x003a_EmploymentCategor0”);var TempPos = “‘”+Pos+”‘”;
var TempPos2= TempPos.replace(/[0-9]/g, ”);
var StaffPos= TempPos2.replace(“;#”,”);var TempCat = “‘”+EempCat+”‘”;
var TempCatx = TempCat.replace(/[0-9]/g, ”);
var ECats= TempCatx.replace(“;#”,”);var Pfield= $(this).attr(“ows_Employee_x0020_Person_x0020_Fiel”);
var Ddate= $(this).attr(“ows_DepartureDate”);if(XM%2==0)
{
Bootstrap = “table-warning”;
}
else
{
Bootstrap = “”;
}NewSecion= NewSecion.replace(/[“‘]/g, “”);
StaffPos= StaffPos.replace(/[“‘]/g, “”);if(Email==null)
{
Email=””;
}
Email= ““+Email+”“;if(Mobile==null)
{
Mobile=””;
}
if(Extension==null)
{
Extension=””;
}
if(LastName==null)
{
LastName=””;
}
if(FirstName==null)
{
FirstName=””;
}MyData= MyData+””;
//ops = “”;//var Temp = $(“#Row1”).append(ops);
//$(“#Row1″).replaceWith(Temp);
XM++;});
MyData+=””;
$(“#MyList”).append(MyData);
}
});

$(‘#MyList’).DataTable( {
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyList’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered table-hover’);

US_Clk=1;
$(“#tabsContent”).dialog(“close”);
},100);
}
else
{
$(“#tabsContent”).dialog(“close”);
}
}

function SPGetLESTCN(i)
{
var K = i.substring(4);
var DY=i;

var m=0;
var s=””;
var Local = “Local Staff (FSN, TCN, EFM, PSA, PSC)”;
var US = “U.S.-Based Direct Hire (FS, CS, Military, FSL, LNA, EFM, 3161)”;
var con = “Third Party Contractors”;
var GUR = “Gurkha Guards”;
var All =””;

var LES_Selected = 0;
var CON_Selected = 0;
if(K==”US”)
{
DY = US;
setTimeout(function(){
$(“#tabsContent”).dialog(“close”);
},100);
return;
}
else if(K==”LES”)
{
$(“#LES”).empty();
DY = Local;
LES_Selected=2;
}
else if(K==”CON”)
{
$(“#con”).empty();
DY = con;
CON_Selected=2;
}
else
{
$(“#All”).empty();
DY = All;
}

if(LES_Selected==2 && LES_Clk==0)
{
setTimeout(function(){
var PFields = “”;
var SPCaml =””;
SPCaml +=””;
SPCaml +=””;
var DYQuery;
if(DY==””)
{
//DYQuery = “”;
DYQuery = “”+GUR+””;
}
else
{
if(K==”CON”)
{
DYQuery = “”+DY+””+GUR+””;
}
else if(K==”LES”)
{
DYQuery = “”+DY+””;
}
else
{
DYQuery = “”+DY+””;
}
}

$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPCaml ,
CAMLQuery: DYQuery,
completefunc: function (xData, Status) {
var MyData=”

“; $(xData.responseXML).SPFilterNode(“z:row”).each(function() {//var ID= $(this).attr(“ows_ID”);
var LastName= $(this).attr(“ows_EmployeeLastName”);
var FirstName= $(this).attr(“ows_EmployeeFirstName”);
var Email= $(this).attr(“ows_Email_x0020_Address”);
var Mobile= $(this).attr(“ows_Mobile_x0020_Local”);
var Section = $(this).attr(“ows_Position_x003a_Office_x0020_Desc”);var TempSec = “‘”+Section+”‘”;
var TempSec2 = TempSec.replace(/[0-9]/g, ”);
var NewSecion= TempSec2.replace(“;#”,”);
//NewSecion= NewSecion.replace(“‘”,”);var Extension= $(this).attr(“ows_Office_x0020_Extension”);
//var AccountStatus= $(this).attr(“ows_Accountability_x0020_Status”);
var company = $(this).attr(“ows_Position_x003a_Contracting_x0020”);
var Pos = $(this).attr(“ows_Position_x003a_PositionDescripti”);
if(Pos ==null)
{
Pos =””;
}
var EempCat = $(this).attr(“ows_Position_x003a_EmploymentCategor0”);var TempPos = “‘”+Pos+”‘”;
var TempPos2= TempPos.replace(/[0-9]/g, ”);
var StaffPos= TempPos2.replace(“;#”,”);var TempCat = “‘”+EempCat+”‘”;
var TempCatx = TempCat.replace(/[0-9]/g, ”);
var ECats= TempCatx.replace(“;#”,”);var TempComp = “‘”+company+”‘”;
var TempComp2 = TempComp .replace(/[0-9]/g, ”);
var MyCompany= TempComp2.replace(“;#”,”);var Pfield= $(this).attr(“ows_Employee_x0020_Person_x0020_Fiel”);
//var Ddate= $(this).attr(“ows_DepartureDate”);if(m%2==0)
{
s=”table-warning”;
}
else
{
s=””;
}NewSecion= NewSecion.replace(/[“‘]/g, “”);
StaffPos= StaffPos.replace(/[“‘]/g, “”);
MyCompany= MyCompany.replace(/[“‘]/g, “”);if(Email==null)
{
Email=””;
}
Email= ““+Email+”“;if(Mobile==null)
{
Mobile=””;
}
if(Extension==null)
{
Extension=””;
}
if(LastName==null)
{
LastName=””;
}
if(FirstName==null)
{
FirstName=””;
}//MyData= MyData+””;
if(K==”LES”)
{
MyData= MyData+””;
}
else if(K==”CON”)
{
MyData= MyData+””;
}
else
{
MyData= MyData+””;
}m++;});
MyData+=””;

if(K == “LES”)
{
$(“#LES”).replaceWith(MyData);
}
else if(K ==”ALL”)
{

$(“#All”).replaceWith(MyData);
}
else if(K==”CON”)
{
$(“#con”).replaceWith(MyData);
}
}
});

//—————Check———————-//

if(K ==”LES”)
{
$(‘#MyListL’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListL’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);
}
else if(K ==”ALL”)
{

$(‘#MyListAll’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListAll’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);
}
else if(K ==”CON”)
{

$(‘#MyListCON’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListCON’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);
}

$(“#tabsContent”).dialog(“close”);
LES_Clk =1;

},100);
}
else if(CON_Selected==2 && CON_Clk==0)
{
setTimeout(function(){
var PFields = “”;
var SPCaml =””;
SPCaml +=””;
SPCaml +=””;
var DYQuery;
if(DY==””)
{
//DYQuery = “”;
DYQuery = “”+GUR+””;
}
else
{
if(K==”CON”)
{
DYQuery = “”+DY+””+GUR+””;
}
else if(K==”LES”)
{
DYQuery = “”+DY+””;
}
else
{
DYQuery = “”+DY+””;
}
}

$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPCaml ,
CAMLQuery: DYQuery,
completefunc: function (xData, Status) {
var MyData=”

“; $(xData.responseXML).SPFilterNode(“z:row”).each(function() {//var ID= $(this).attr(“ows_ID”);
var LastName= $(this).attr(“ows_EmployeeLastName”);
var FirstName= $(this).attr(“ows_EmployeeFirstName”);
var Email= $(this).attr(“ows_Email_x0020_Address”);
var Mobile= $(this).attr(“ows_Mobile_x0020_Local”);
var Section = $(this).attr(“ows_Position_x003a_Office_x0020_Desc”);var TempSec = “‘”+Section+”‘”;
var TempSec2 = TempSec.replace(/[0-9]/g, ”);
var NewSecion= TempSec2.replace(“;#”,”);var Extension= $(this).attr(“ows_Office_x0020_Extension”);
//var AccountStatus= $(this).attr(“ows_Accountability_x0020_Status”);
var company = $(this).attr(“ows_Position_x003a_Contracting_x0020″);
if(company ==null)
{
company =””;
}
var Pos = $(this).attr(“ows_Position_x003a_PositionDescripti”);
if(Pos==null)
{
Pos=””;
}
var EempCat = $(this).attr(“ows_Position_x003a_EmploymentCategor0”);var TempPos = “‘”+Pos+”‘”;
var TempPos2= TempPos.replace(/[0-9]/g, ”);
var StaffPos= TempPos2.replace(“;#”,”);var TempCat = “‘”+EempCat+”‘”;
var TempCatx = TempCat.replace(/[0-9]/g, ”);
var ECats= TempCatx.replace(“;#”,”);var TempComp = “‘”+company+”‘”;
var TempComp2 = TempComp .replace(/[0-9]/g, ”);
var MyCompany= TempComp2.replace(“;#”,”);var Pfield= $(this).attr(“ows_Employee_x0020_Person_x0020_Fiel”);
var Ddate= $(this).attr(“ows_DepartureDate”);if(m%2==0)
{
s=”table-warning”;
}
else
{
s=””;
}
NewSecion= NewSecion.replace(/[“‘]/g, “”);
StaffPos= StaffPos.replace(/[“‘]/g, “”);
MyCompany= MyCompany.replace(/[“‘]/g, “”);if(Email==null)
{
Email=””;
}
Email= ““+Email+”“;if(Mobile==null)
{
Mobile=””;
}
if(Extension==null)
{
Extension=””;
}
if(LastName==null)
{
LastName=””;
}
if(FirstName==null)
{
FirstName=””;
}//MyData= MyData+””;
if(K==”LES”)
{
MyData= MyData+””;
}
else if(K==”CON”)
{
MyData= MyData+””;
}
else
{
MyData= MyData+””;
}m++;});
MyData+=””;

if(K == “LES”)
{
$(“#LES”).replaceWith(MyData);
}
else if(K ==”ALL”)
{

$(“#All”).replaceWith(MyData);
}
else if(K==”CON”)
{
$(“#con”).replaceWith(MyData);
}
}
});

//—————Check———————-//

if(K ==”LES”)
{
$(‘#MyListL’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListL’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);
}
else if(K ==”ALL”)
{

$(‘#MyListAll’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListAll’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);
}
else if(K ==”CON”)
{

$(‘#MyListCON’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListCON’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);
}

$(“#tabsContent”).dialog(“close”);
CON_Clk=1;
},100);

}
else
{
$(“#tabsContent”).dialog(“close”);
}

}

function GetAll() {

var CAMLF = “2016-01-01”;
var CAMLF2 = “”;
var count = 0;
var i = 1;
var SPTags =[];
var Temp = [];
var MAR = [];
var SPSMenu =””;

//var SPSMenu =””;
$().SPServices({
operation: “GetListItems”,
async: true,
listName: “Assignments”,
CAMLViewFields: SPSMenu,
//CAMLQuery: “”,
completefunc: function (xData, Status) {
count = $(xData.responseXML.xml).find(“rs\\:data, data”).attr(“ItemCount”);
//alert(count);
$(xData.responseXML).SPFilterNode(“z:row”).each(function() {

var LastName = $(this).attr(“ows_EmployeeLastName”);
var DepartureDate = $(this).attr(“ows_DepartureDate”);
//alert(DepartureDate);
//$(“#AutoDiv”).append($(this).attr(“ows_EmployeeLastName”));
if(i

<!–

$( function() {
//stop(); Employee_x0020_Person_x0020_Fiel
var CAMLF = “”;
var CAMLF = “”;
var SPTags =[];
var SPSMenu =””;
$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPSMenu,
CAMLQuery: “”+CAMLF+””+CAMLF2+””,
completefunc: function (xData, Status) {
$(xData.responseXML).SPFilterNode(“z:row”).each(function() {
var LastName = $(this).attr(“ows_EmployeeLastName”);
alert(LastName);
SPTags.push($(this).attr(“ows_EmployeeLastName”));
});
}
});

/*
$( “#LTs”).autocomplete({
source: SPTags
});
*/
$( “#LTs”).autocomplete(SPTags);

} );

–>

$(“#HRReview”).click(function(){
$(“#Tab1”).addClass(“TabSelected”);
HRReview();
});
$(“#AddNew”).click(function(){
$(“#Tab4”).addClass(“TabSelected”);
HRReview();
});

function SearchItem(FullName)
{
$(“#DivContact2”).empty();
//stop();
$(“#ExContacts”).removeClass(“HideLinks”);
var SPSMenu =””;
var CAMLF = FullName;
var count = 0;
var i = 1;
var ListURL = “/mgt/hr/OIP/Lists/Assignments/DispForm.aspx?ID=”;
//var SPDefault = “&DefaultItemOpen=1”;
alert(FullName);
//var SPMenuServices = SPSMenu;
$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPSMenu,
CAMLQuery: “”+CAMLF+””,

completefunc: function (xData, Status) {
count = $(xData.responseXML.xml).find(“rs\\:data, data”).attr(“ItemCount”);
//alert(count);
$(xData.responseXML).SPFilterNode(“z:row”).each(function() {

//var Title = $(this).attr(“ows_Title”);
var ID = $(this).attr(“ows_ID”);
//var JobTitle = $(this).attr(“ows_JobTitle”);
//var FirstName = $(this).attr(“ows_FirstName”);
//var Email = $(this).attr(“ows_Email”);
//var Section = $(this).attr(“ows_Department”);
//var Office = $(this).attr(“ows_Section”);
var EmployeeLastName= $(this).attr(“ows_EmployeeLastName”);
var EmployeeFirstName= $(this).attr(“ows_EmployeeFirstName”);
//alert(Title);
//alert(ID);
var SPFullURL = ListURL+ID;
var Contact = ”

“;
i++;
//alert(Title);
var test = $(“#DivContact2”).append(Contact);

$(“#DivContact”).replaceWith(test);

});
}
});

}

function SearchEveryColumn(Cols)
{
$(“#DivContact2”).empty();
//stop();
$(“#ExContacts”).removeClass(“HideLinks”);
var SPSMenu =””;
var CAMLF = Cols;
var count = 0;
var i = 1;
var ListURL = “/mgt/hr/OIP/Lists/Assignments/DispForm.aspx?ID=”;
//var SPDefault = “&DefaultItemOpen=1”;
alert(FullName);
//var SPMenuServices = SPSMenu;
$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPSMenu,
CAMLQuery: “”+CAMLF+””,

completefunc: function (xData, Status) {
count = $(xData.responseXML.xml).find(“rs\\:data, data”).attr(“ItemCount”);
//alert(count);
$(xData.responseXML).SPFilterNode(“z:row”).each(function() {

//var Title = $(this).attr(“ows_Title”);
var ID = $(this).attr(“ows_ID”);
//var JobTitle = $(this).attr(“ows_JobTitle”);
//var FirstName = $(this).attr(“ows_FirstName”);
//var Email = $(this).attr(“ows_Email”);
//var Section = $(this).attr(“ows_Department”);
//var Office = $(this).attr(“ows_Section”);
var EmployeeLastName= $(this).attr(“ows_EmployeeLastName”);
var EmployeeFirstName= $(this).attr(“ows_EmployeeFirstName”);
//alert(Title);
//alert(ID);
var SPFullURL = ListURL+ID;
MyData= MyData+”

“;
i++;
//alert(Title);
var temp = $(“#DivContact2”).append(MyData);

$(“.container”).replaceWith(temp);

});
}
});

}

function getAllRecords()
{

if(All_Clk==0)
{
//location.href=location.href.replace(“?All”,””);
//—————–New Start—————————//

//—————–New Start—————————//
setTimeout(function(){
var m=0;
var s=””;
var Local = “Local Staff (FSN, TCN, EFM, PSA, PSC)”;
var US = “U.S.-Based Direct Hire (FS, CS, Military, FSL, LNA, EFM, 3161)”;
var con = “Third Party Contractors”;
var GUR = “Gurkha Guards”;
var All =””;

var PFields = “”;
var SPCaml =””;
SPCaml +=””;
SPCaml +=””;
var DYQuery;
//DYQuery = “”;
DYQuery = “”+GUR+””;

$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPCaml ,
CAMLQuery: DYQuery,
CAMLRowLimit:3000,
completefunc: function (xData, Status) {
var MyData=”

“; $(xData.responseXML).SPFilterNode(“z:row”).each(function() {//var ID= $(this).attr(“ows_ID”);
var LastName= $(this).attr(“ows_EmployeeLastName”);
var FirstName= $(this).attr(“ows_EmployeeFirstName”);
var Email= $(this).attr(“ows_Email_x0020_Address”);
var Mobile= $(this).attr(“ows_Mobile_x0020_Local”);
var Section = $(this).attr(“ows_Position_x003a_Office_x0020_Desc”);
if(Section ==null)
{
Section =””;
}
var TempSec = “‘”+Section+”‘”;
var TempSec2 = TempSec.replace(/[0-9]/g, ”);
var NewSecion= TempSec2.replace(“;#”,”);var Extension= $(this).attr(“ows_Office_x0020_Extension”);
//var AccountStatus= $(this).attr(“ows_Accountability_x0020_Status”);
var company = $(this).attr(“ows_Position_x003a_Contracting_x0020”);
var Pos = $(this).attr(“ows_Position_x003a_PositionDescripti”);
if(Pos ==null)
{
Pos=””;
}
if(company ==null)
{
company =””;
}var EempCat = $(this).attr(“ows_Position_x003a_EmploymentCategor0″);
if(EempCat ==null)
{
EempCat =””;
}
var TempPos = “‘”+Pos+”‘”;
var TempPos2= TempPos.replace(/[0-9]/g, ”);
var StaffPos= TempPos2.replace(“;#”,”);var TempCat = “‘”+EempCat+”‘”;
var TempCatx = TempCat.replace(/[0-9]/g, ”);
var ECats= TempCatx.replace(“;#”,”);var TempComp = “‘”+company+”‘”;
var TempComp2 = TempComp .replace(/[0-9]/g, ”);
var MyCompany= TempComp2.replace(“;#”,”);var Pfield= $(this).attr(“ows_Employee_x0020_Person_x0020_Fiel”);
var Ddate= $(this).attr(“ows_DepartureDate”);if(m%2==0)
{
s=”table-warning”;
}
else
{
s=””;
}
NewSecion= NewSecion.replace(/[“‘]/g, “”);
StaffPos= StaffPos.replace(/[“‘]/g, “”);
ECats= ECats.replace(/[“‘]/g, “”);
MyCompany= MyCompany.replace(/[“‘]/g, “”);if(Email==null)
{
Email=””;
}
Email= ““+Email+”“;if(Mobile==null)
{
Mobile=””;
}
if(Extension==null)
{
Extension=””;
}
if(LastName==null)
{
LastName=””;
}
if(FirstName==null)
{
FirstName=””;
}
/*if(AccountStatus==null)
{
AccountStatus=””;
}*/MyData= MyData+””;m++;});
MyData+=””;

$(“#All”).replaceWith(MyData);

}
});

//—————Check———————-//

$(‘#MyListAll’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’,
“dom”: ‘Bfrtip’,
“buttons”: [
‘print’
]

});

$(‘#MyListAll’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);

$(“#tab-ALL”).addClass(“current”);
$(“#tab-ALL2”).removeClass(“current”);
$(“#tabsContent”).dialog(“close”);

$(“#tab-ALL2”).addClass(“HideMe”);
$(“#tab-ALL”).removeClass(“HideMe”);
$(“.input-sm”).addClass(“GreanSearch”);

},100);

All_Clk = 1;
}
else
{
$(“#tabsContent”).dialog(“close”);
}
}

//=====Print View=========//
function PrintView()
{
//—————–New Start—————————//
setTimeout(function(){
var m=0;
var s=””;
var Local = “Local Staff (FSN, TCN, EFM, PSA, PSC)”;
var US = “U.S.-Based Direct Hire (FS, CS, Military, FSL, LNA, EFM, 3161)”;
var con = “Third Party Contractors”;
var GUR = “Gurkha Guards”;
var All =””;

var PFields = “”;
var SPCaml =””;
SPCaml +=””;
SPCaml +=””;
var DYQuery;
//DYQuery = “”;
DYQuery = “”+GUR+””;

$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Assignments”,
CAMLViewFields: SPCaml ,
CAMLQuery: DYQuery,
CAMLRowLimit:3000,
completefunc: function (xData, Status) {
var MyData=”

“; $(xData.responseXML).SPFilterNode(“z:row”).each(function() {var ID= $(this).attr(“ows_ID”);
var LastName= $(this).attr(“ows_EmployeeLastName”);
var FirstName= $(this).attr(“ows_EmployeeFirstName”);
var Email= $(this).attr(“ows_Email_x0020_Address”);
var Mobile= $(this).attr(“ows_Mobile_x0020_Local”);
var Section = $(this).attr(“ows_Position_x003a_Office_x0020_Desc”);var TempSec = “‘”+Section+”‘”;
var TempSec2 = TempSec.replace(/[0-9]/g, ”);
var NewSecion= TempSec2.replace(“;#”,”);var Extension= $(this).attr(“ows_Office_x0020_Extension”);
var AccountStatus= $(this).attr(“ows_Accountability_x0020_Status”);
var company = $(this).attr(“ows_Position_x003a_Contracting_x0020”);
var Pos = $(this).attr(“ows_Position_x003a_PositionDescripti”);var EempCat = $(this).attr(“ows_Position_x003a_EmploymentCategor0”);var TempPos = “‘”+Pos+”‘”;
var TempPos2= TempPos.replace(/[0-9]/g, ”);
var StaffPos= TempPos2.replace(“;#”,”);var TempCat = “‘”+EempCat+”‘”;
var TempCatx = TempCat.replace(/[0-9]/g, ”);
var ECats= TempCatx.replace(“;#”,”);var TempComp = “‘”+company+”‘”;
var TempComp2 = TempComp .replace(/[0-9]/g, ”);
var MyCompany= TempComp2.replace(“;#”,”);var Pfield= $(this).attr(“ows_Employee_x0020_Person_x0020_Fiel”);
var Ddate= $(this).attr(“ows_DepartureDate”);if(m%2==0)
{
s=”table-warning”;
}
else
{
s=””;
}MyData= MyData+””;m++;});
MyData+=””;

$(“#All”).replaceWith(MyData);

}
});

//—————Check———————-//

$(‘#MyListAll’).DataTable( {
destroy: true,
“dom”: ‘Rlfrtip’
});

$(‘#MyListAll’)
.removeClass(‘display’ )
.addClass(‘table table-striped table-bordered’);

$(“#tab-ALL”).addClass(“current”);
$(“#tab-ALL2”).removeClass(“current”);
$(“#tabsContent”).dialog(“close”);

$(“#tab-ALL2”).addClass(“HideMe”);
$(“#tab-ALL”).removeClass(“HideMe”);
$(“.input-sm”).addClass(“GreanSearch”);

},100);

}

Last Name

First Name

Email

Mobile Local

Office Ext

Section

Position Title

Accountability Status

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+LastName+”

“+FirstName+”

“+MJAssignment+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+LastName+”

“+FirstName+”

“+MJAssignment+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+AccountStatus+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+MyCompany+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+ECats+”

“+MyCompany+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+AccountStatus+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+MyCompany+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+ECats+”

“+MyCompany+”

“+i+”

“+EmployeeLastName+”

“+EmployeeFirstName+”

View Details

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+ECats+”

“+AccountStatus+”

“+Ddate+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+ECats+”

“+MyCompany+”

“+LastName+”

“+FirstName+”

“+Email+”

“+Mobile+”

“+Extension+”

“+NewSecion+”

“+StaffPos+”

“+ECats+”

“+MyCompany+”

“+AccountStatus+”