xplorer = external; var sn = external.EVAL('SerialNum'); var logindate = external.EVAL('FormatDateTime("dd/mm/yyyy",LoginDate)'); var sqllogindate = external.EVAL('FormatDateTime("mm/dd/yyyy",LoginDate)'); var logindaynum = external.EVAL('FormatDateTime("dd",LoginDate)'); //var mydate=monthNames[loginmonthnum]; var loginmonthnumstring = external.EVAL('FormatDateTime("mm",LoginDate)'); var loginyear = external.EVAL('Loginyear');
var loginmonthnum=Number(loginmonthnumstring);
var d = new Date(); var weekday = new Array(7); weekday[0]= "Sunday"; weekday[1] = "Monday"; weekday[2] = "Tuesday"; weekday[3] = "Wednesday"; weekday[4] = "Thursday"; weekday[5] = "Friday"; weekday[6] = "Saturday"; var n = weekday[d.getDay()]; //=> 'Mar'
var m = new Date(); var monthname = new Array(12); monthname[0]= "Ιανουαρίου"; monthname[1] = "Φεβρουαρίου"; monthname[2] = "Μαρτίου"; monthname[3] = "Απριλίου"; monthname[4] = "Μαίου"; monthname[5] = "Ιουνίου"; monthname[6] = "Ιουλίου"; monthname[7] = "Αυγούστου"; monthname[8] = "Σεπτεμβρίου"; monthname[9] = "Οκτωβρίου"; monthname[10] = "Νοεμβρίου"; monthname[11] = "Δεκεμβρίου"; var month = monthname[m.getMonth()]; //=> 'Mar'
var companycode=external.EVAL('CompanyCode'); var companyname=external.EVAL('CompanyName'); var branchname=external.EVAL('BranchName'); var usercode=external.EVAL('UserCode'); var username=external.EVAL('USERNAME');
//DAILY TASKS=============================================== //select fromdate,soredir,comments,* from soaction where SOACTION.ACTOR=600 and CONVERT (date, fromdate)=CONVERT (date, GETDATE()) and soredir in (1,2,3) and ACTSTATUS NOT IN(3,4) order by trndate ASC
var messagesds=external.GETSQLDATASET("select CONVERT(VARCHAR(5),fromdate,108) as time,fromdate,soredir,SOACTION,SUBSTRING(comments, 1, 39) as comments from soaction where SOACTION.ACTOR="+usercode+" and CONVERT (date, fromdate)=CONVERT (date, GETDATE()) and soredir in (1,2,3) and ACTSTATUS NOT IN(3,4) order by fromdate ASC",null);
//var messagesDS = ["Apple", "Banana"]; var fromdate=new Array(); var time=new Array(); var soredir=new Array(); var comments=new Array(); var soaction=new Array(); var i=0 messagesds.FIRST; while (!messagesds.EOF) { soaction[i]=[messagesds.soaction]; comments[i]=[messagesds.comments]; soredir[i]=[messagesds.soredir]; time[i]=[messagesds.time]; // insdate[i]=convertDate(new Date(Date.parse(messagesds.insdate)))+' '+convertTime(new Date(Date.parse(messagesds.insdate))); //insdate[i] = external.EVAL('FormatDateTime("mm/dd/yyyy",'+Date.parse(messagesds.insdate)+')'); messagesds.NEXT; i++ };
Γεια σου
σήμερα είναι
και είναι μια όμορφη μέρα!
Έχεις εργασίες σήμερα