public function SaveRoleAction() { $request = $this->getRequest(); $appid = $request->get("appid"); $roles = $request->get("roles"); $clear = $request->get("clear"); $result = array(); $da = $this->get("we_data_access"); if ($clear == 1) { $ex = $this->DeleteRole($da, $appid); if ($ex) { $result = array("success" => true, "message" => "清除用户权限成功!", "count" => 0); //记录日志 $syslog = new \Justsy\AdminAppBundle\Controller\SysLogController(); $syslog->setContainer($this->container); $user = $this->get('security.context')->getToken()->getUser()->getUserName(); $sql = "select appname from we_appcenter_apps where appid=?;"; $ds = $da->GetData("table", $sql, array((string) $appid)); if ($ds && $ds["table"]["recordcount"] > 0) { $desc = "清除了应用【" . $ds["table"]["rows"][0]["appname"] . "】的所有人员查看权限。"; $syslog->AddSysLog($desc, "应用权限"); } } else { $result = array("success" => false, "message" => "清除用户权限失败!"); } } else { $result = $this->EditAppRole($appid, $roles); } if ($result["success"]) { $this->sendPresence(); } $response = new Response(json_encode($result)); $response->headers->set('Content-Type', 'text/json'); return $response; }
public function ResetPassWordAction() { $da = $this->get("we_data_access"); $da_im = $this->get("we_data_access_im"); $request = $this->getRequest(); $account = strtolower($request->get("account")); $password = $request->get("password"); $result = array("success" => true, "message" => ""); $user = $this->get('security.context')->getToken()->getUser(); try { $u_staff = new Staff($da, $da_im, $account, $this->get('logger'), $this->container); $targetStaffInfo = $u_staff->getInfo(); $re = $u_staff->changepassword($targetStaffInfo["login_account"], $password, $this->get('security.encoder_factory')); if ($re) { //$this->get("logger")->err("sendImPresence:".$targetStaffInfo["fafa_jid"]); //给自己发送一个staff-changepasswod的出席,通知在线客户端密码发生修改,需要新密码重新登录 Utils::sendImPresence($user->fafa_jid, $targetStaffInfo["fafa_jid"], "staff-changepasswod", "staff-changepasswod", $this->container, "", "", false, Utils::$systemmessage_code); //记录用户操作日志 $syslog = new \Justsy\AdminAppBundle\Controller\SysLogController(); $syslog->setContainer($this->container); $desc = "重置了用户账号:" . $account . "登录密码!"; $syslog->AddSysLog($desc, "重置密码"); } else { $result = array("success" => false, "message" => "修改密码错误!"); } } catch (\Exception $e) { $this->get("logger")->err($e->getMessage()); $result = array("success" => false, "message" => "修改密码错误!"); } $response = new Response(json_encode($result)); $response->headers->set('Content-Type', 'text/json'); return $response; }
public function CleareRoleAction() { $da = $this->get('we_data_access'); $request = $this->getRequest(); $login_account = $request->get("login_account"); $success = true; $msg = ""; try { $sql = "delete from mb_staff_menu where staff_id=?"; $da->ExecSQL($sql, array((string) $login_account)); //用户权限增减日志 $syslog = new \Justsy\AdminAppBundle\Controller\SysLogController(); $syslog->setContainer($this->container); $desc = "取消了用户" . $login_account . "的所有菜单权限!"; $syslog->AddSysLog($desc, "菜单权限"); } catch (\Exception $e) { $msg = "清除用户菜单权限失败!"; $success = false; $this->get('logger')->err($e); } $result = array("success" => $success, "msg" => $msg); $response = new Response(json_encode($result)); $response->headers->set('Content-Type', 'text/json'); return $response; }
public function detailContentPublishAction() { $da = $this->get('we_data_access'); $request = $this->getRequest(); $id = $request->get("id"); $code = ReturnCode::$SUCCESS; $data = array(); $msg = ""; $result = null; if ($id != null && !empty($id)) { $sql = "select title as news_title,content news_content,date_format(date,'%Y-%m-%d %H:%i') news_date,nick_name as news_author,'' news_subtitle,type \n from mb_content_publish a inner join we_staff b on a.publish_staffid=b.login_account where id=?"; try { $ds = $da->GetData("detail", $sql, array((string) $id)); if ($ds && $ds["detail"]["recordcount"] > 0) { $data = $ds["detail"]["rows"][0]; //写入日志信息 $syslog = new \Justsy\AdminAppBundle\Controller\SysLogController(); $syslog->setContainer($this->container); $user = $this->get('security.context')->getToken()->getUser(); $type = ""; if ($ds["detail"]["rows"][0]["type"] == "1") { $type = "制度"; } else { $type = "福利"; } $desc = $user->nick_name . "查看了标题为【" . $ds["detail"]["rows"][0]["news_title"] . "】的" . $type . "。"; $type = "查看" . $type; $syslog->AddSysLog($desc, $type); } } catch (\Exception $e) { $this->get('logger')->err($e); } } $response = new Response(json_encode($data)); $response->headers->set('Content-Type', 'text/json'); return $response; }
public function kqgsAction() { $re = array("returncode" => ReturnCode::$SUCCESS); $request = $this->getRequest(); $user = $this->get('security.context')->getToken()->getUser(); $da = $this->get('we_data_access'); $kqlb = $request->get("kqlb"); $user_code = explode('@', $user->getUserName()); $user_code = strtoupper($user_code[0]); try { if (empty($kqlb)) { throw new \Exception("param is null"); } $conn = $this->getConnection(); // 返回数据 $sql = "select user_code, user_name, qishu, ldk_dp, ldk_zc, cd_1,cd_2, cd_3, cd_4, zt_1, zt_2, dp_cd_1, dp_cd_2, dp_cd_3, dp_cd_4, dp_zt_1, \n dp_zt_2, kongqin, kg, qj01, qj02, qj03, qj04, qj05, qj06, qj07, qj08, qj09,qj10, qj11, qj12, qj13, qj14, qj15, qj16, qj17, qj18, qj19, hx_qq_1, hx_qq_2,hx_qq_3, qq_gs\n from mb_hr_kqhz where user_code='" . $user_code . "' order by qishu desc limit 1"; $table = mysql_query($sql); $kqgs = array(); if (mysql_num_rows($table) > 0) { $r_kqhz = null; while ($rows = mysql_fetch_array($table)) { $r_kqhz = $rows; } if ($kqlb == "01") { $lbmcs = array("ldk_dp" => "店铺未打卡(次)", "ldk_zc" => "非店铺未打卡(次)", "cd_1" => "非店铺迟到(0-30分钟)", "cd_2" => "非店铺迟到(31-60分钟)", "cd_3" => "非店铺迟到(61-120分钟)", "cd_4" => "非店铺迟到(120分钟以上)", "zt_1" => "非店铺早退(30分钟以内)", "zt_2" => "非店铺早退(30分钟以上)", "dp_cd_1" => "店铺迟到(0-10分钟)", "dp_cd_2" => "店铺迟到(11-30分钟)", "dp_cd_3" => "店铺迟到(31-60分钟)", "dp_cd_4" => "店铺迟到(61-120分钟)", "dp_zt_1" => "店铺早退(1小时内)", "dp_zt_2" => "店铺早退(1小时以上)"); foreach ($lbmcs as $key => &$value) { if ($r_kqhz[$key] <= 0) { continue; } $item = array(); $item["lbmc"] = $value; $item["kqnum"] = $r_kqhz[$key]; $item["kqdates"] = $this->getkqgsDetail($user_code, $r_kqhz["qishu"], $key); //array(); $kqgs[] = $item; } } else { if ($kqlb == "02") { $lbmcs = array("kongqin" => "空勤", "kg" => "旷工"); foreach ($lbmcs as $key => &$value) { if ($r_kqhz[$key] <= 0) { continue; } $item = array(); $item["lbmc"] = $value; $item["kqnum"] = $r_kqhz[$key]; $item["kqdates"] = $this->getkqgsDetail($user_code, $r_kqhz["qishu"], $key); //array(); $kqgs[] = $item; } } else { if ($kqlb == "03") { $lbmcs = array("qj01" => "年休假", "qj02" => "有薪事假", "qj03" => "无薪事假", "qj04" => "病假", "qj05" => "探亲假", "qj06" => "献血假", "qj07" => "长期服务奖假", "qj08" => "婚假", "qj09" => "产假", "qj10" => "丧假", "qj11" => "工伤假", "qj12" => "产检假", "qj13" => "陪产假", "qj14" => "调休", "qj15" => "哺乳假", "qj16" => "出差", "qj17" => "特殊假", "qj18" => "周末加班调休", "qj19" => "平时加班调休"); foreach ($lbmcs as $key => &$value) { if ($r_kqhz[$key] <= 0) { continue; } $item = array(); $item["lbmc"] = $value; $item["kqnum"] = $r_kqhz[$key]; $item["kqdates"] = $this->getkqgsDetail($user_code, $r_kqhz["qishu"], $key); //array(); $kqgs[] = $item; } } else { if ($kqlb == "04") { $lbmcs = array("hx_qq_1" => "核心缺勤(1小时以内)次数", "hx_qq_2" => "核心缺勤(1到4小时)", "hx_qq_3" => "核心缺勤(4小时以上)", "qq_gs" => "非核心缺勤小时数"); foreach ($lbmcs as $key => &$value) { if ($r_kqhz[$key] <= 0) { continue; } $item = array(); $item["lbmc"] = $value; $item["kqnum"] = $r_kqhz[$key]; $item["kqdates"] = $this->getkqgsDetail($user_code, $r_kqhz["qishu"], $key); $kqgs[] = $item; } } } } } } $re["kqgs"] = $kqgs; //写入日志信息 $syslog = new \Justsy\AdminAppBundle\Controller\SysLogController(); $syslog->setContainer($this->container); $desc = $user->nick_name . "查看了【月度考勤】"; $syslog->AddSysLog($desc, "月度考勤"); } catch (\Exception $e) { $re["returncode"] = ReturnCode::$SYSERROR; $this->get('logger')->err($e); } if (!empty($conn)) { mysql_close($conn); } $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re)); $response->headers->set('Content-Type', 'text/json'); return $response; }
public function RestartPasswordAction() { $da = $this->get("we_data_access"); $request = $this->getRequest(); $login_account = $request->get("login_account"); $success = true; $msg = ""; if (empty($login_account)) { $success = false; $msg = "请输入用户账号!"; } else { if (!Utils::validateEmail($login_account)) { $success = false; $msg = "请输入正确的用户账号!"; } else { $sql = "delete from mb_salary_staff where login_account=?;"; try { $da->ExecSQL($sql, array((string) $login_account)); //记录用户操作日志 $syslog = new \Justsy\AdminAppBundle\Controller\SysLogController(); $syslog->setContainer($this->container); $desc = "清除用户账号:" . $login_account . "工资独立密码!"; $syslog->AddSysLog($desc, "工资密码"); } catch (\Exception $e) { $success = false; $msg = "重置用户工资密码错误!"; $this->get("logger")->err($e->getMessage()); } } } $result = array("success" => $success, "msg" => $msg); $response = new Response(json_encode($result)); $response->headers->set('Content-Type', 'text/json'); return $response; }