public int AddPunchCardLog(PunchCardLog newData, bool normal)   //true正常打卡新增/false編輯新增
        {
            int count = 0;
            var query = _DbContext.punchcardlogs.Where(b => b.accountID == newData.accountID && b.logDate == newData.logDate);

            if (query.Count() > 0)
            {
                return(1062);    //該日期已有紀錄
            }
            _DbContext.punchcardlogs.Add(newData);
            count = _DbContext.SaveChanges();

            if (count == 1 && !normal)
            {
                var dic   = new Dictionary <string, string> {
                };
                var opLog = new OperateLog()
                {
                    operateID = newData.lastOperaAccID, employeeID = newData.accountID,
                    active    = "新增", category = "打卡紀錄", createTime = definePara.dtNow()
                };
                toNameFn.AddUpPunchCardLog_convertToDic(ref dic, newData);
                opLog.content = toNameFn.AddUpPunchCardLog_convertToText(dic);
                saveOperateLog(opLog);    //紀錄操作紀錄
            }
            return(count);
        }
        public void AddNullPunchLog(int accID, int departID, DateTime targetDate)
        {
            var thisAccDetail = _DbContext.employeedetails.FirstOrDefault(b => b.accountID == accID);

            if (thisAccDetail != null)
            {
                if (targetDate < thisAccDetail.startWorkDate)    //避免處理報到日之前的日期
                {
                    return;
                }
            }

            var count        = 0;
            var nullPunchLog = new PunchCardLog();

            nullPunchLog.accountID    = accID;
            nullPunchLog.departmentID = departID;
            nullPunchLog.logDate      = targetDate;
            nullPunchLog.punchStatus  = 16;     //0x10=>16:缺卡 / 0x20=>32:曠職
            nullPunchLog.createTime   = definePara.dtNow();
            try{
                _DbContext.punchcardlogs.Add(nullPunchLog);
                count = _DbContext.SaveChanges();
            }catch (Exception e) {
                count = ((MySqlException)e.InnerException).Number;
            }
        }
        public void AddPunchLogWarnAndMessage(PunchCardLog log)
        {
            var context = _DbContext.punchlogwarns.FirstOrDefault(b => b.punchLogID == log.ID);

            if (context == null)
            {
                var query = (from a in _DbContext.accounts
                             join b in _DbContext.punchcardlogs on a.ID equals b.accountID
                             join c in _DbContext.departments on b.departmentID equals c.ID into tmp
                             from d in tmp.DefaultIfEmpty()
                             where b.ID == log.ID
                             select new{ a.userName, b.accountID,
                                         principalID = (d == null? 0:d.principalID) }).FirstOrDefault();

                var warnLog = new PunchLogWarn();
                warnLog.accountID   = log.accountID;
                warnLog.principalID = query.principalID;
                warnLog.punchLogID  = log.ID;
                warnLog.warnStatus  = 0;
                warnLog.createTime  = definePara.dtNow();

                _DbContext.punchlogwarns.Add(warnLog);
                if (_DbContext.SaveChanges() > 0)
                {
                    systemSendMessage(query.userName, query.accountID, "punch");
                }
            }
        }
        //---------------------------------------------------------------------------------------
        public object getTodayPunchStatus()     //look my today PunchStatus
        {
            PunchCardNeedParam logParam = new PunchCardNeedParam();

            logParam.thisWorkTime = Repository.GetThisWorkTime((int)loginID);
            logParam.workDateTime = Repository.workTimeProcess(logParam.thisWorkTime);
            PunchCardLog[] dataLogArr = Repository.GetTodayPunchLog((int)loginID, logParam, 0);
            PunchCardLog   dataLog;

            if (dataLogArr[1] != null && dataLogArr[1].onlineTime.Year > 1)
            {
                dataLog = dataLogArr[1];
            }
            else if (dataLogArr[0] != null)
            {
                dataLog = dataLogArr[0];
            }
            else
            {
                dataLog = new PunchCardLog();
            }
            DateTime onlineDt  = dataLog.onlineTime;
            DateTime offlineDt = dataLog.offlineTime;

            return(rAjaxResult(
                       new {
                onlineTime = onlineDt.Year == 1? null : (object)onlineDt,
                offlineTime = offlineDt.Year == 1? null : (object)offlineDt,
            }
                       ));
        }
        public void delPunchLogWarnAndMessage(PunchCardLog log)
        {
            var context = _DbContext.punchlogwarns.FirstOrDefault(b => b.punchLogID == log.ID);

            if (context != null)
            {
                _DbContext.punchlogwarns.Remove(context);
                _DbContext.SaveChanges();
            }
        }
Ejemplo n.º 6
0
        private void calWorkTimeByID(PunchCardLog log, WorkTimeRule thisWorkTime)
        {
            var targetDate      = log.logDate;
            var startDT         = targetDate.AddDays(1 - targetDate.Day).Date;
            var endDT           = startDT.AddMonths(1).AddDays(-1).Date;
            var thisMonthAllLog = Repository.GetPunchLogByDateByID(log.accountID, startDT, endDT);
            var otApplies       = Repository.GetOvertimeApplyByDateByID(log.accountID, startDT, endDT);

            countWorkTime(thisMonthAllLog, otApplies, thisWorkTime, startDT);
        }
        //正常打卡
        public int punchCardProcess(PunchCardLog logData, WorkTimeRule thisWorkTime, int action, int employeeID)
        {
            WorkDateTime wt = workTimeProcess(thisWorkTime);
            //需new一個出來 用原本的logData會等於context,一旦修改logData之後query後的context也會是修改後的(雖然沒儲存所以資料庫沒變)
            PunchCardLog newLogData;
            int          resultCount = 0; //0:操作異常 1:成功

            if (logData == null)          //今日皆未打卡
            {
                newLogData = new PunchCardLog()
                {
                    accountID      = employeeID, departmentID = (int)loginDepartmentID, logDate = wt.sWorkDt.Date,
                    lastOperaAccID = (int)loginID, onlineTime = definePara.dtNow(), createTime = definePara.dtNow()
                };
            }
            else   //今日有打過卡 or 電腦生成(跨日才有可能遇到)
            {
                newLogData              = new PunchCardLog();
                newLogData.ID           = logData.ID;
                newLogData.accountID    = logData.accountID;
                newLogData.departmentID = logData.departmentID;
                newLogData.logDate      = logData.logDate;
                newLogData.onlineTime   = logData.onlineTime;
                newLogData.offlineTime  = logData.offlineTime;
                newLogData.punchStatus  = logData.punchStatus;
                newLogData.createTime   = logData.createTime;

                newLogData.lastOperaAccID = (int)loginID;
                newLogData.updateTime     = definePara.dtNow();

                if (newLogData.onlineTime.Year == 1 && newLogData.offlineTime.Year == 1)
                {
                    newLogData.onlineTime = definePara.dtNow();
                }
                else
                {
                    newLogData.offlineTime = definePara.dtNow();
                }
            }
            newLogData.punchStatus = getStatusCode(wt, newLogData);
            resultCount            = newLogData.ID == 0? Repository.AddPunchCardLog(newLogData, true) : Repository.UpdatePunchCard(newLogData, true);
            if (resultCount == 1)     //一定要新增log成功 不然會沒logID
            {
                if (newLogData.punchStatus > psCode.normal && newLogData.punchStatus != psCode.takeLeave)
                {
                    Repository.AddPunchLogWarnAndMessage(newLogData);
                }
                else if (newLogData.punchStatus == psCode.normal)
                {
                    Repository.delPunchLogWarnAndMessage(newLogData);
                }
            }
            return(resultCount);
        }
        public int forceUpdatePunchCardLog(PunchCardLog updatePunchLog, string from)
        {
            if (updatePunchLog.ID == 0 || (updatePunchLog.onlineTime.Year == 1 && updatePunchLog.offlineTime.Year == 1))
            {
                return(2); //此打卡紀錄不合法
            }
            updatePunchLog.accountID = Repository.GetThisLogAccID(updatePunchLog.ID);
            WorkTimeRule thisWorkTime = Repository.GetThisWorkTime(updatePunchLog.accountID);

            return(punchCardFn.forcePunchLogProcess(updatePunchLog, thisWorkTime, "update", from));
        }
        public int forceAddPunchCardLog(PunchCardLog newPunchLog)
        {
            if (newPunchLog.accountID == 0 ||
                (newPunchLog.onlineTime.Year == 1 && newPunchLog.offlineTime.Year == 1))
            {
                return(2);  //此打卡紀錄不合法
            }
            WorkTimeRule thisWorkTime = Repository.GetThisWorkTime(newPunchLog.accountID);

            return(punchCardFn.forcePunchLogProcess(newPunchLog, thisWorkTime, "add"));
        }
        public int addPunchCardLog(int action, int employeeID = 0)
        {
            if (employeeID == 0)
            {
                employeeID = (int)loginID;
            }
            WorkTimeRule thisWorkTime = Repository.GetThisWorkTime(employeeID);
            PunchCardLog logData      = Repository.GetTodayPunchLog(employeeID, thisWorkTime);

            return(punchCardFn.punchCardProcess(logData, thisWorkTime, action, employeeID));
        }
Ejemplo n.º 11
0
        public object addPunchCardLog(int action, int employeeID = 0)   //action 0:正常打卡/打下班卡 1:提早上班
        {
            if (employeeID == 0)
            {
                employeeID = (int)loginID;
            }
            var logParam = new PunchCardNeedParam();

            logParam.thisWorkTime = Repository.GetThisWorkTime(employeeID);
            logParam.workDateTime = Repository.workTimeProcess(logParam.thisWorkTime);
            PunchCardLog[] punchLogArr = Repository.GetTodayPunchLog(employeeID, logParam, action);
            logParam.punchCardLog = punchLogArr[0];
            if (punchLogArr[1] != null && punchLogArr[1].onlineTime.Year > 1)
            {
                //提前打卡後 將以該工作日為基礎
                logParam.workDateTime = Repository.workTimeProcess(logParam.thisWorkTime, punchLogArr[1]);
                logParam.punchCardLog = punchLogArr[1];
            }
            if (definePara.dtNow() >= logParam.workDateTime.ePunchDT)    //at ambiguous time
            {
                if (_session.GetInt32("againRequest") == null || _session.GetInt32("againRequest") == 0)
                {
                    _session.SetInt32("againRequest", 1);
                    var wt       = logParam.workDateTime;
                    var dtFormat = "yyyy/MM/dd HH:mm";
                    var offline  = wt.sWorkDt.ToString(dtFormat) + " ~ " + wt.eWorkDt.ToString(dtFormat);
                    var online   = wt.sWorkDt.AddDays(1).ToString(dtFormat) + " ~ " + wt.eWorkDt.AddDays(1).ToString(dtFormat);
                    return(new cusResult <dynamic> {
                        resCode = 1, result = 2, resultMsg = $"{offline}T{online}"
                    });
                }
                _session.SetInt32("againRequest", 0);
            }
            if (action == 1)
            {
                PunchCardLog newLogData = new PunchCardLog();
                if (punchLogArr[1] == null)
                {
                    newLogData.logDate = logParam.workDateTime.sWorkDt.Date.AddDays(1);
                }
                else
                {
                    newLogData.ID      = punchLogArr[1].ID;
                    newLogData.logDate = punchLogArr[1].logDate;
                }
                logParam.punchCardLog = newLogData;
            }
            var result = punchCardFn.punchCardProcess(logParam, action, employeeID);

            return(cudAjaxResult(result));
        }
Ejemplo n.º 12
0
        public object forceAddPunchCardLog(PunchCardLog newPunchLog)
        {
            if (newPunchLog.accountID == 0 ||
                (newPunchLog.onlineTime.Year == 1 && newPunchLog.offlineTime.Year == 1))
            {
                return(cudAjaxResult(MessageCode.PunchCardDT_Illegal)); //此打卡時間紀錄不合法
            }
            var logParam = new PunchCardNeedParam();

            logParam.punchCardLog = newPunchLog;
            logParam.thisWorkTime = Repository.GetThisWorkTime(newPunchLog.accountID);
            var result = punchCardFn.forcePunchLogProcess(logParam, "add");

            return(cudAjaxResult(result));
        }
Ejemplo n.º 13
0
        public object forceUpdatePunchCardLog(PunchCardLog updatePunchLog, string from)
        {
            if (updatePunchLog.ID == 0 || (updatePunchLog.onlineTime.Year == 1 && updatePunchLog.offlineTime.Year == 1))
            {
                return(cudAjaxResult(MessageCode.PunchCardDT_Illegal)); //此打卡時間紀錄不合法
            }
            updatePunchLog.accountID = Repository.GetThisLogAccID(updatePunchLog.ID);
            var logParam = new PunchCardNeedParam();

            logParam.punchCardLog = updatePunchLog;
            logParam.thisWorkTime = Repository.GetThisWorkTime(updatePunchLog.accountID);
            var result = punchCardFn.forcePunchLogProcess(logParam, "update", from);

            return(cudAjaxResult(result));
        }
        public void processPunchlogWarn(PunchCardLog log, WorkTimeRule thisWorkTime)    //排程用
        {
            WorkDateTime wt = workTimeProcess(thisWorkTime, log);

            if (definePara.dtNow() < wt.ePunchDT)
            {
                return;
            }
            log.punchStatus    = getStatusCode(wt, log);
            log.lastOperaAccID = 0;
            Repository.UpdatePunchCard(log, true);
            if (log.punchStatus > 1 && log.punchStatus != psCode.takeLeave)
            {
                Repository.AddPunchLogWarnAndMessage(log);
            }
        }
        public int UpdatePunchCard(PunchCardLog updateData, bool normal)    //true正常打卡新增/false編輯新增
        {
            var oDic  = new Dictionary <string, string> {
            };
            var nDic  = new Dictionary <string, string> {
            };
            var opLog = new OperateLog()
            {
                operateID = updateData.lastOperaAccID, employeeID = updateData.accountID,
                active    = "更新", category = "打卡紀錄", createTime = definePara.dtNow()
            };
            int count = 0;
            var query = _DbContext.punchcardlogs.Where(b => b.accountID == updateData.accountID &&
                                                       b.logDate == updateData.logDate && b.ID != updateData.ID);

            if (query.Count() > 0)
            {
                return(1062);    //該日期已有紀錄
            }
            PunchCardLog context = _DbContext.punchcardlogs.FirstOrDefault(b => b.ID == updateData.ID);

            if (context != null)
            {
                toNameFn.AddUpPunchCardLog_convertToDic(ref oDic, context);

                context.logDate        = updateData.logDate;
                context.onlineTime     = updateData.onlineTime;
                context.offlineTime    = updateData.offlineTime;
                context.punchStatus    = updateData.punchStatus;
                context.lastOperaAccID = updateData.lastOperaAccID;
                context.updateTime     = updateData.updateTime;
                count = _DbContext.SaveChanges();
            }
            if (count == 1 && !normal)
            {
                toNameFn.AddUpPunchCardLog_convertToDic(ref nDic, context);
                opLog.content = toNameFn.AddUpPunchCardLog_convertToText(nDic, oDic);
                saveOperateLog(opLog);    //紀錄操作紀錄
            }
            return(count);
        }
        //---------------------------------------------------------------------------------------
        public object getTodayPunchStatus()     //look my today PunchStatus
        {
            WorkTimeRule thisWorkTime = Repository.GetThisWorkTime((int)loginID);
            var          dataLog      = Repository.GetTodayPunchLog((int)loginID, thisWorkTime);

            if (dataLog == null)
            {
                dataLog = new PunchCardLog();
            }
            dynamic onlineTime  = dataLog.onlineTime;
            dynamic offlineTime = dataLog.offlineTime;

            if (onlineTime.Year == 1)
            {
                onlineTime = false;
            }
            if (offlineTime.Year == 1)
            {
                offlineTime = false;
            }
            return(new {
                onlineTime = onlineTime, offlineTime = offlineTime,
            });
        }
        public WorkDateTime workTimeProcess(WorkTimeRule thisWorkTime, PunchCardLog customLog = null)
        {
            var wt = new WorkDateTime();

            wt.sWorkDt  = definePara.dtNow().Date; //online work dateTime
            wt.eWorkDt  = definePara.dtNow().Date; //offline work dateTime
            wt.sPunchDT = definePara.dtNow().Date; //可打卡時間
            wt.ePunchDT = definePara.dtNow().Date; //
            var sRest_start = new TimeSpan(0);
            var eRest_sRest = new TimeSpan(0);

            if (customLog != null)
            {
                if (customLog.logDate.Year != 1)
                {
                    wt.sWorkDt = wt.eWorkDt = wt.sPunchDT = wt.ePunchDT = customLog.logDate.Date;
                }
                else if (customLog.onlineTime.Year != 1)
                {
                    wt.sWorkDt = wt.eWorkDt = wt.sPunchDT = wt.ePunchDT = customLog.onlineTime.Date;
                }
                else if (customLog.offlineTime.Year != 1)
                {
                    wt.sWorkDt = wt.eWorkDt = wt.sPunchDT = wt.ePunchDT = customLog.offlineTime.Date;
                }
            }
            if (thisWorkTime != null)
            {
                var eWork_sWork = thisWorkTime.endTime - thisWorkTime.startTime;
                eWork_sWork      = eWork_sWork.TotalSeconds < 0? eWork_sWork.Add(new TimeSpan(1, 0, 0, 0)) : eWork_sWork;
                wt.addEtHour     = (int)(24 * 60 + wt.lessStHour - eWork_sWork.TotalMinutes); //單位改為分鐘
                sRest_start      = thisWorkTime.sRestTime - thisWorkTime.startTime;
                sRest_start      = sRest_start.TotalSeconds < 0? sRest_start.Add(new TimeSpan(1, 0, 0, 0)) : sRest_start;
                eRest_sRest      = thisWorkTime.eRestTime - thisWorkTime.sRestTime;
                eRest_sRest      = eRest_sRest.TotalSeconds < 0? eRest_sRest.Add(new TimeSpan(1, 0, 0, 0)) : eRest_sRest;
                wt.type          = thisWorkTime.type;
                wt.workAllTime   = false;
                wt.sWorkDt       = wt.sWorkDt + thisWorkTime.startTime;
                wt.eWorkDt       = wt.eWorkDt + thisWorkTime.endTime;
                wt.eWorkDt       = wt.eWorkDt <= wt.sWorkDt ? wt.eWorkDt.AddDays(1) : wt.eWorkDt;
                wt.sPunchDT      = wt.sWorkDt.AddMinutes(wt.lessStHour);
                wt.ePunchDT      = wt.eWorkDt.AddMinutes(wt.addEtHour);
                wt.elasticityMin = thisWorkTime.elasticityMin;
                if (customLog == null)
                {
                    if (definePara.dtNow() >= wt.ePunchDT)
                    {
                        wt.sPunchDT = wt.sPunchDT.AddDays(1);
                        wt.ePunchDT = wt.ePunchDT.AddDays(1);
                        wt.sWorkDt  = wt.sPunchDT.AddMinutes((wt.lessStHour * -1));
                        wt.eWorkDt  = wt.ePunchDT.AddMinutes((wt.addEtHour * -1));
                    }
                    else if (definePara.dtNow() < wt.sPunchDT)
                    {
                        wt.sPunchDT = wt.sPunchDT.AddDays(-1);
                        wt.ePunchDT = wt.ePunchDT.AddDays(-1);
                        wt.sWorkDt  = wt.sPunchDT.AddMinutes((wt.lessStHour * -1));
                        wt.eWorkDt  = wt.ePunchDT.AddMinutes((wt.addEtHour * -1));
                    }
                }
            }
            else
            {
                wt.workAllTime = true;
                wt.eWorkDt     = wt.eWorkDt.AddDays(1);
                wt.ePunchDT    = wt.ePunchDT.AddDays(1);
            }
            wt.sRestDt = wt.sWorkDt.AddMinutes(sRest_start.TotalMinutes);
            wt.eRestDt = wt.sRestDt.AddMinutes(eRest_sRest.TotalMinutes);
            return(wt);
        }
        public int forcePunchLogProcess(PunchCardLog processLog, WorkTimeRule thisWorkTime, string action, string from = "")
        {
            WorkDateTime wt        = workTimeProcess(thisWorkTime, processLog);
            var          et_big_st = thisWorkTime.endTime >= thisWorkTime.startTime? true: false;

            processLog.logDate        = wt.sWorkDt.Date;
            processLog.lastOperaAccID = (int)loginID;
            if (action == "update")
            {
                processLog.updateTime = definePara.dtNow();
            }
            else
            {
                processLog.createTime = definePara.dtNow();
            }

            if (processLog.onlineTime.Year != 1)
            {
                if (processLog.onlineTime < wt.sPunchDT)     //2300-0800 if write 0000-0800
                {
                    processLog.onlineTime = processLog.onlineTime.AddDays(1);
                }
                if (processLog.onlineTime >= wt.ePunchDT)     //0000-0800 if write 2355-0800
                {
                    processLog.onlineTime = processLog.onlineTime.AddDays(-1);
                }
            }
            if (processLog.offlineTime.Year != 1)
            {
                if (processLog.offlineTime <= wt.sWorkDt)    //2300-0800 if write 2300-0800
                {
                    processLog.offlineTime = processLog.offlineTime.AddDays(1);
                }
            }
            if (et_big_st && processLog.onlineTime.Year != 1 && processLog.offlineTime.Year != 1)
            {
                if (processLog.onlineTime >= processLog.offlineTime)
                {
                    processLog.onlineTime = processLog.onlineTime.AddDays(-1);
                }
            }
            else if (!et_big_st && processLog.onlineTime.Year != 1 && processLog.offlineTime.Year != 1)
            {
                if (processLog.offlineTime <= processLog.onlineTime)
                {
                    processLog.offlineTime = processLog.offlineTime.AddDays(1);
                }
            }

            processLog.punchStatus = getStatusCode(wt, processLog);
            int result = action == "update"? Repository.UpdatePunchCard(processLog, false) : Repository.AddPunchCardLog(processLog, false);

            if (result == 1)
            {
                if (processLog.punchStatus > psCode.normal && processLog.punchStatus != psCode.takeLeave)
                {
                    Repository.AddPunchLogWarnAndMessage(processLog);
                }
                if (action == "update" && from == "applySign")
                {
                    Repository.UpdatePunchLogWarn(processLog.ID);
                }
            }
            return(result);
        }
Ejemplo n.º 19
0
        public void AddUpPunchCardLog_convertToDic(ref Dictionary <string, string> Dic, PunchCardLog data)
        {
            var code   = new punchStatusCode();
            var status = " ";

            data   = (data == null? new PunchCardLog() : data);
            status = (data.punchStatus & code.lateIn) > 0 ? status += "遲到/" : status;
            status = (data.punchStatus & code.earlyOut) > 0 ? status += "早退/" : status;
            status = (data.punchStatus & code.overtime) > 0 ? status += "加班/" : status;
            status = (data.punchStatus & code.hadLost) > 0 ? status += "缺卡/" : status;
            status = (data.punchStatus & code.takeLeave) > 0 ? status += "請假/" : status;
            status = (data.punchStatus & code.noWork) > 0 ? status += "曠職" : status;
            status = (data.punchStatus & code.normal) > 0 && status == " " ? status += "正常" : status;
            status = status[status.Length - 1] == '/' ? status.Substring(0, status.Length - 1) :status;
            Dic.Add("operateID", data.lastOperaAccID.ToString());
            Dic.Add("accID", data.accountID.ToString());
            Dic.Add("logDate", data.logDate.ToString("yyyy-MM-dd"));
            Dic.Add("onTime", data.onlineTime.Year == 1?"無" : data.onlineTime.ToString("HH:mm:ss"));
            Dic.Add("offTime", data.offlineTime.Year == 1?"無" : data.offlineTime.ToString("HH:mm:ss"));
            Dic.Add("status", status);
        }
Ejemplo n.º 20
0
        public void punchLogWithTakeLeave(LeaveOfficeApply restLog)
        {
            var restST   = restLog.startTime;
            var restET   = restLog.endTime;
            var wtLength = 720;         //工作時間長度 unit:minute
            //因工作時間可能跨日 不能直接用restST.Date EX: 2300-0800 休下半天0400-0800
            var workDate = restST.Date; //工作天日期(logDate)
            var wtRule   = (from a in _DbContext.accounts
                            join b in _DbContext.worktimerules on a.timeRuleID equals b.ID
                            where a.ID == restLog.accountID
                            select b).FirstOrDefault();

            if (wtRule != null)
            {
                if (wtRule.endTime < wtRule.startTime)
                {
                    wtLength = (int)(wtRule.endTime.Add(new TimeSpan(24, 0, 0)) - wtRule.startTime).TotalMinutes;
                }
                else
                {
                    wtLength = (int)(wtRule.endTime - wtRule.startTime).TotalMinutes;
                }
                var restSTime = new TimeSpan(restST.Hour, restST.Minute, restST.Second);
                workDate = (wtRule.startTime > restSTime)? workDate.AddDays(-1) : workDate;
            }

            do
            {
                var log = _DbContext.punchcardlogs.FirstOrDefault(b =>
                                                                  b.accountID == restLog.accountID && b.logDate == workDate);
                if (log != null)
                {
                    log.lastOperaAccID = restLog.lastOperaAccID;
                    log.updateTime     = definePara.dtNow();
                    WorkDateTime wt = punchCardFn.workTimeProcess(wtRule, log);
                    log.punchStatus = punchCardFn.getStatusCode(wt, log);
                    if (restLog.applyStatus != 1)
                    {
                        if (wtRule != null)
                        {
                            var logEndTime = log.logDate + wtRule.endTime;
                            logEndTime = (wtRule.endTime <= wtRule.startTime)? logEndTime.AddDays(1) : logEndTime;
                            if (definePara.dtNow() <= logEndTime && log.onlineTime.Year == 1 && log.offlineTime.Year == 1)
                            {
                                _DbContext.Remove(log);
                            }
                        }
                        else
                        {
                            if (log.logDate > definePara.dtNow())
                            {
                                _DbContext.Remove(log);
                            }
                        }
                    }
                    _DbContext.SaveChanges();
                }
                else
                {
                    if (restLog.applyStatus == 1)
                    {
                        var          applyAcc = _DbContext.accounts.FirstOrDefault(b => b.ID == restLog.accountID);
                        var          departID = applyAcc == null? 0 : applyAcc.departmentID;
                        PunchCardLog newLog   = new PunchCardLog {
                            accountID = restLog.accountID, departmentID = departID,
                            logDate   = workDate, createTime = definePara.dtNow(),
                        };
                        WorkDateTime wt = punchCardFn.workTimeProcess(wtRule, newLog);
                        newLog.punchStatus = punchCardFn.getStatusCode(wt, newLog, restLog);
                        _DbContext.punchcardlogs.Add(newLog);
                        _DbContext.SaveChanges();
                    }
                }

                if (restST.AddMinutes(wtLength) < restET)
                {
                    restST   = restST.AddDays(1);
                    workDate = workDate.AddDays(1);
                }
                else
                {
                    restST = restST.AddMinutes(wtLength);
                }
            }while(restST < restET);
        }
Ejemplo n.º 21
0
        //正常打卡
        public int punchCardProcess(PunchCardNeedParam logParam, int action, int employeeID)
        {
            WorkTimeRule thisWorkTime = logParam.thisWorkTime;
            PunchCardLog logData      = logParam.punchCardLog;
            WorkDateTime wt           = logParam.workDateTime;
            //需new一個出來 用原本的logData會等於context,一旦修改logData之後query後的context也會是修改後的(雖然沒儲存所以資料庫沒變)
            PunchCardLog newLogData;
            DateTime     dtNow       = definePara.dtNow();
            int          resultCount = 0; //0:操作異常 1:成功

            if (action == 1)              //action = 1 提早打上班卡
            {
                newLogData = new PunchCardLog()
                {
                    ID             = logData.ID,
                    accountID      = employeeID,
                    departmentID   = (int)loginDepartmentID,
                    logDate        = logData.logDate,
                    lastOperaAccID = (int)loginID,
                    onlineTime     = dtNow,
                    createTime     = dtNow
                };
            }
            else if (action == 0 && logData == null)    //action = 0  正常打卡或打下班卡
            //
            {
                newLogData = new PunchCardLog()
                {
                    accountID      = employeeID,
                    departmentID   = (int)loginDepartmentID,
                    logDate        = wt.sWorkDt.Date,
                    lastOperaAccID = (int)loginID,
                    createTime     = dtNow
                };
                if (dtNow >= wt.ePunchDT)    //在模糊區段 打下班卡
                {
                    newLogData.offlineTime = dtNow;
                }
                else    //非模糊區段 若上班卡沒打會先打上班卡 之後需要打一次下班卡
                {
                    newLogData.onlineTime = dtNow;
                }
            }
            else
            {
                newLogData                = new PunchCardLog();
                newLogData.ID             = logData.ID;
                newLogData.accountID      = logData.accountID;
                newLogData.departmentID   = logData.departmentID;
                newLogData.logDate        = logData.logDate;
                newLogData.onlineTime     = logData.onlineTime;
                newLogData.offlineTime    = logData.offlineTime;
                newLogData.punchStatus    = logData.punchStatus;
                newLogData.createTime     = logData.createTime;
                newLogData.lastOperaAccID = (int)loginID;
                newLogData.updateTime     = dtNow;
                if (dtNow >= wt.ePunchDT || logData.onlineTime.Year > 1)
                {
                    newLogData.offlineTime = dtNow;
                }
                else
                {
                    newLogData.onlineTime = dtNow;
                }
            }
            logParam.punchCardLog  = newLogData;
            logParam.workDateTime  = workTimeProcess(thisWorkTime, newLogData);
            newLogData.punchStatus = getStatusCode(logParam);
            resultCount            = newLogData.ID == 0? Repository.AddPunchCardLog(newLogData, true) : Repository.UpdatePunchCard(newLogData, true);
            if (resultCount == 1)     //一定要新增log成功 不然會沒logID
            {
                if (newLogData.punchStatus > psCode.normal && newLogData.punchStatus != psCode.takeLeave)
                {
                    Repository.AddPunchLogWarnAndMessage(newLogData);
                }
                else if (newLogData.punchStatus == psCode.normal)
                {
                    Repository.delPunchLogWarnAndMessage(newLogData);
                }
                if (action == 1)     //提早打上班卡 通知主管
                {
                    var accDetail = Repository.GetAccountDetail(newLogData.accountID);
                    var userName  = (string)accDetail.GetType().GetProperty("userName").GetValue(accDetail);
                    //obj.GetType().GetProperty(key).GetValue(obj);
                    Repository.systemSendMessage(userName, newLogData.accountID, "earlyPunch");
                }
            }
            return(resultCount);
        }
Ejemplo n.º 22
0
        public int getStatusCode(PunchCardNeedParam logParam, LeaveOfficeApply leave = null)
        {
            WorkDateTime wt          = logParam.workDateTime;
            PunchCardLog processLog  = logParam.punchCardLog;
            var          fullDayRest = false; //請整天假
            var          statusCode  = 0;     //statusCode:  0x01:正常 0x02:遲到 0x04:早退 0x08:加班 0x10:缺卡 0x20:曠職 0x40:請假

            if (wt.workAllTime)
            {
                return(psCode.normal);
            }
            var elasticityMin = wt.elasticityMin;   //彈性時間
            List <LeaveOfficeApply> thisLeave = new List <LeaveOfficeApply>();

            //if(leave == null){
            thisLeave = Repository.GetThisTakeLeave(processLog.accountID, wt.sWorkDt, wt.eWorkDt);
            //}else{
            //    thisLeave.Add(leave);
            //}
            if (thisLeave.Count > 0)
            {
                var allWorkLen = (wt.eWorkDt - wt.sWorkDt).TotalMinutes;
                var restLen    = (wt.eRestDt - wt.sRestDt).TotalMinutes;
                var workLen    = allWorkLen - restLen;
                var sum        = 0.0;
                foreach (var tmp in thisLeave)
                {
                    sum        += (tmp.endTime - tmp.startTime).TotalMinutes;
                    fullDayRest = (tmp.startTime <= wt.sWorkDt && tmp.endTime >= wt.eWorkDt)? true : false;
                }
                fullDayRest = sum >= workLen? true : fullDayRest;
                statusCode |= psCode.takeLeave;
            }

            if (processLog.onlineTime.Year == 1 && processLog.offlineTime.Year == 1)
            {
                if (definePara.dtNow() >= wt.ePunchDT)
                {
                    statusCode = fullDayRest? statusCode : (statusCode | psCode.noWork);
                }
                else
                {
                    if (definePara.dtNow() >= wt.eWorkDt)
                    {
                        statusCode = fullDayRest? statusCode : (statusCode | psCode.hadLost);
                    }
                }
            }
            else if (processLog.onlineTime.Year > 1 && processLog.offlineTime.Year > 1)
            {
                var newStartWt = wt.sWorkDt.AddMinutes(elasticityMin + 1);   //+1因遲到以時分為主 09:00:59 也不算遲到
                statusCode = processLog.onlineTime >= newStartWt? (statusCode | psCode.lateIn) : statusCode;
                var timeLen = (int)((processLog.onlineTime - wt.sWorkDt).TotalMinutes);
                timeLen    = (timeLen <0 || timeLen> elasticityMin)? 0: timeLen; //上班打卡超過彈性時間 下班就已下班時間為準
                statusCode = processLog.offlineTime < wt.eWorkDt.AddMinutes(timeLen)? (statusCode | psCode.earlyOut):statusCode;
                if (statusCode == psCode.takeLeave && (statusCode & psCode.lateIn) == 0 && (statusCode & psCode.earlyOut) == 0)
                {
                    statusCode = (statusCode | psCode.normal);
                }
            }
            else
            {
                if (processLog.onlineTime.Year > 1) //只有填上班
                {
                    var newStartWt = wt.sWorkDt.AddMinutes(elasticityMin + 1);
                    statusCode = processLog.onlineTime >= newStartWt? (statusCode | psCode.lateIn) : statusCode;
                    statusCode = definePara.dtNow() >= wt.ePunchDT ? (statusCode | psCode.hadLost) : statusCode; //打不到下班卡了
                }
                else                                                                                             //只有填下班
                {
                    statusCode |= psCode.hadLost;
                    statusCode  = processLog.offlineTime < wt.eWorkDt ? (statusCode | psCode.earlyOut) : statusCode;
                }
            }
            return(statusCode == 0? (psCode.normal) : statusCode);
        }
Ejemplo n.º 23
0
 public WorkDateTime workTimeProcess(WorkTimeRule thisWorkTime, PunchCardLog customLog = null)
 {
     return(Repository.workTimeProcess(thisWorkTime, customLog));
 }
Ejemplo n.º 24
0
        public WorkDateTime workTimeProcess(WorkTimeRule thisWorkTime, PunchCardLog customLog = null)
        {
            var wt    = new WorkDateTime();
            var dtNow = definePara.dtNow();

            wt.sWorkDt = dtNow.Date;  //online work dateTime
            wt.eWorkDt = dtNow.Date;  //offline work dateTime
            var eWork_sWork = new TimeSpan(0);
            var sRest_start = new TimeSpan(0);
            var eRest_sRest = new TimeSpan(0);

            if (customLog != null)
            {
                if (customLog.logDate.Year != 1)
                {
                    wt.sWorkDt = wt.eWorkDt = customLog.logDate.Date;
                }
                else if (customLog.onlineTime.Year != 1)
                {
                    wt.sWorkDt = wt.eWorkDt = customLog.onlineTime.Date;
                }
                else if (customLog.offlineTime.Year != 1)
                {
                    wt.sWorkDt = wt.eWorkDt = customLog.offlineTime.Date;
                }
            }
            if (thisWorkTime != null)
            {
                eWork_sWork = thisWorkTime.endTime - thisWorkTime.startTime;
                eWork_sWork = eWork_sWork.TotalSeconds < 0? eWork_sWork.Add(new TimeSpan(1, 0, 0, 0)) : eWork_sWork;
                // wt.addEtHour = (int)(24*60 + wt.lessStHour - eWork_sWork.TotalMinutes);   //單位改為分鐘
                sRest_start      = thisWorkTime.sRestTime - thisWorkTime.startTime;
                sRest_start      = sRest_start.TotalSeconds < 0? sRest_start.Add(new TimeSpan(1, 0, 0, 0)) : sRest_start;
                eRest_sRest      = thisWorkTime.eRestTime - thisWorkTime.sRestTime;
                eRest_sRest      = eRest_sRest.TotalSeconds < 0? eRest_sRest.Add(new TimeSpan(1, 0, 0, 0)) : eRest_sRest;
                wt.type          = thisWorkTime.type;
                wt.workAllTime   = false;
                wt.sWorkDt       = wt.sWorkDt + thisWorkTime.startTime;
                wt.eWorkDt       = wt.eWorkDt + thisWorkTime.endTime;
                wt.eWorkDt       = wt.eWorkDt <= wt.sWorkDt ? wt.eWorkDt.AddDays(1) : wt.eWorkDt;
                wt.sPunchDT      = wt.sWorkDt.AddMinutes(wt.lessStHour);
                wt.ePunchDT      = wt.eWorkDt.AddMinutes(wt.addEtHour);
                wt.elasticityMin = thisWorkTime.elasticityMin;
                if (customLog == null)
                {
                    if (dtNow < wt.sPunchDT && dtNow < wt.ePunchDT.AddDays(-1)) //2300-0800 0830打卡
                    {
                        wt.sWorkDt  = wt.sWorkDt.AddDays(-1);
                        wt.eWorkDt  = wt.eWorkDt.AddDays(-1);
                        wt.sPunchDT = wt.sWorkDt.AddMinutes(wt.lessStHour);
                        wt.ePunchDT = wt.eWorkDt.AddMinutes(wt.addEtHour);
                    }
                    else if (dtNow < wt.sPunchDT && dtNow >= wt.ePunchDT.AddDays(-1))
                    {
                        //ambiguous
                        //目前工作日判斷,把位於模糊區域的時間,以某工作日的加班來處理
                        wt.sWorkDt  = wt.sWorkDt.AddDays(-1);
                        wt.eWorkDt  = wt.eWorkDt.AddDays(-1);
                        wt.sPunchDT = wt.sWorkDt.AddMinutes(wt.lessStHour);
                        wt.ePunchDT = wt.eWorkDt.AddMinutes(wt.addEtHour);
                    }
                    else if (dtNow >= wt.ePunchDT && dtNow >= wt.sPunchDT.AddDays(1))   //0000-0800 2330打卡
                    {
                        wt.sWorkDt  = wt.sWorkDt.AddDays(1);
                        wt.eWorkDt  = wt.eWorkDt.AddDays(1);
                        wt.sPunchDT = wt.sWorkDt.AddMinutes(wt.lessStHour);
                        wt.ePunchDT = wt.eWorkDt.AddMinutes(wt.addEtHour);
                    }
                    else if (dtNow >= wt.ePunchDT && dtNow < wt.sPunchDT.AddDays(1))
                    {
                        //ambiguous
                        //目前工作日判斷,把位於模糊區域的時間,以某工作日的加班來處理
                        //不處理
                    }
                }
            }
            else
            {
                wt.workAllTime = true;
                wt.sPunchDT    = wt.sWorkDt;
                wt.eWorkDt     = wt.sWorkDt.AddDays(1);
                wt.ePunchDT    = wt.eWorkDt;
            }
            wt.sRestDt = wt.sWorkDt.AddMinutes(sRest_start.TotalMinutes);
            wt.eRestDt = wt.sRestDt.AddMinutes(eRest_sRest.TotalMinutes);
            return(wt);
        }
        public bool chkApplyOvertimeData(OvertimeApply data)
        {
            var result   = true;
            var punchLog = _DbContext.punchcardlogs.FirstOrDefault(b => b.accountID == data.accountID && b.logDate == data.workDate);

            if (punchLog == null)
            {
                result = false;
            }
            else
            {
                result = punchLog.onlineTime.Year > 1 && punchLog.offlineTime.Year > 1? result : false;
            }
            //計算加班長度
            WorkTimeRule thisWorkTime = pRepository.GetThisWorkTime(data.accountID);
            PunchCardLog tmpLog       = new PunchCardLog()
            {
                logDate = data.workDate
            };
            WorkDateTime workTime       = punchCardFn.workTimeProcess(thisWorkTime, tmpLog);
            var          sRestTime      = thisWorkTime.sRestTime;
            var          eRestTime      = thisWorkTime.eRestTime;
            var          restTimeMinute = 0;
            var          restlength     = TimeSpan.Zero;

            if (eRestTime < sRestTime)
            {
                restlength = eRestTime.Add(new TimeSpan(24, 0, 0)) - sRestTime;
            }
            else
            {
                restlength = eRestTime - sRestTime;
            }
            restTimeMinute = (int)restlength.TotalMinutes;
            var st         = data.startDateTime;
            var et         = data.endDateTime;
            var overLength = 0; //加班長度

            if (st <= workTime.sRestDt && et >= workTime.eRestDt)
            {
                overLength = (int)((et - st).TotalMinutes) - restTimeMinute;
            }
            else if (st < workTime.sRestDt && et <= workTime.eRestDt)
            {
                if (et < workTime.sRestDt)
                {
                    overLength = (int)(et - st).TotalMinutes;
                }
                else
                {
                    overLength = (int)(workTime.sRestDt - st).TotalMinutes;
                }
            }
            else if (st >= workTime.sRestDt && et > workTime.eRestDt)
            {
                if (st > workTime.eRestDt)
                {
                    overLength = (int)(et - st).TotalMinutes;
                }
                else
                {
                    overLength = (int)(et - workTime.eRestDt).TotalMinutes;
                }
            }
            overLength      = (overLength / 30) * 30; //以半小時的倍數為準
            result          = overLength >= 30? result : false;
            data.timeLength = overLength;
            return(result);
        }