care.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 165 行
PHP
165 行
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_org.php");
include_once("check_priv.php");
$CUR_YEAR=date("Y",time());
$CUR_MON=date("n",time());
?>
<html>
<head>
<title>生日祝福</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function check_all()
{
for (i=0;i<document.all("sms_select").length;i++)
{
if(document.all("allbox").checked)
{
if(!document.all("sms_select").item(i).disabled)
document.all("sms_select").item(i).checked=true;
else
document.all("sms_select").item(i).checked=false;
}
else
document.all("sms_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked && document.all("sms_select").disabled==false)
document.all("sms_select").checked=true;
else
document.all("sms_select").checked=false;
}
}
function Send_To()
{
TO_ID="";
for(i=0;i<document.all("sms_select").length;i++)
{
el=document.all("sms_select").item(i);
if(el.checked)
{ val=el.value;
TO_ID+=val + ",";
}
}
if(i==0)
{
el=document.all("sms_select");
if(el.checked)
{ val=el.value;
TO_ID+=val + ",";
}
}
if(TO_ID=="")
{
alert("请至少选择一个客户");
return;
}
URL="/general/mobile_sms/new/?TO_ID1=" + TO_ID;
window.location=URL;
}
function mobile_sms(MOBIL_NO_STR)
{
URL="/general/mobile_sms/new/?TO_ID1="+MOBIL_NO_STR;
myleft=(screen.availWidth-650)/2;
window.open(URL,"mobile_sms","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/care.gif" align="absmiddle" width="17"><span class="big3"> 本月生日员工(<?=$CUR_YEAR?>年<?=$CUR_MON?>月)</span>
</td>
</tr>
</table>
<?
$query = "SELECT b.USER_ID,b.USER_NAME,b.SEX,a.EMAIL,a.HR_BIRTHDAY,b.MOBIL_NO
from HRMS a
LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
LEFT OUTER JOIN USER_PRIV g ON b.USER_PRIV=g.USER_PRIV where b.NOT_LOGIN!=1 and (Month(a.HR_BIRTHDAY)='$CUR_MON') ".$WHERE_STR."ORDER BY HR_BIRTHDAY ASC";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$CARE_COUNT++;
if($CARE_COUNT==1)
{
?>
<table class="TableList" width="95%">
<tr class="TableHeader">
<td nowrap align="center">选择</td>
<td nowrap align="center">员工姓名</td>
<td nowrap align="center">性别</td>
<td nowrap align="center">生日</td>
<td nowrap align="center">手机</td>
<td nowrap align="center">电子邮件</td>
</tr>
<?
}
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
$EMAIL1=$ROW["EMAIL"];
$SEX1=$ROW["SEX"];
$BIRTHDAY1=$ROW["HR_BIRTHDAY"];
$MOBILE1=$ROW["MOBIL_NO"];
if($SEX1=="0")
$SEX_DESC="男";
else
$SEX_DESC="女";
if($CARE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>" >
<td> <input type="checkbox" <?if($MOBILE1=="") echo "DISABLED"?> name="sms_select" value="<?=$MOBILE1?>" onClick="check_one(self);"></td>
<td nowrap align="center"><a href="../query/hrms.php?USER_ID=<?=$USER_ID?>"><?=$USER_NAME?></a></td>
<td nowrap align="center"><?=$SEX_DESC?></td>
<td nowrap align="center"><?=$BIRTHDAY1?></td>
<td nowrap align="center"><?if($MOBILE1=="") echo "暂无手机号码";else echo '<a href="/general/mobile_sms?TO_ID1='.$MOBILE1.'">'.$MOBILE1.'</a>';?></td>
<td nowrap align="center"><?=$EMAIL1?></td>
</tr>
<?
}//while
if($CARE_COUNT==0)
{
Message("提示","本月没有员工过生日");
exit;
}
else
{
?>
<tr class="TableControl" <? if($SCOPE=="2") echo "style=display:none" ?>>
<td colspan="10">
<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" name="send" value="发送短信" class="BigButton" onClick="Send_To()">
</table>
<?
}
?>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?