钉钉机器人关键代码设置,自动推送生日名单及近期主要日程
//数据统计出本周且在职员工生日名单
$sop_php_list=$mysql->getData("SELECT A0101,A0191,A01BL,DATE_FORMAT(A0111,'%m-%d') as srrq FROM A01 WHERE WEEK(A0111)=WEEK(NOW()) and A0191='在职人员' order by A01BL");
//根据日期显示未来一周的生日名单并推送到钉钉机器人
$outce_str="";
foreach($sop_php_list as $key=>$value)
{
$outce_str.=($key+1).".".$value["srrq"].".".$value["A0101"]." ";
}
//echo $outce_str
//end
//根据当前日期获取总经理室代办日程项目数据
$gm_list=$mysql->getData("SELECT c02,c04,DATE_FORMAT(c02,'%m-%d')as gmrq FROM p_task WHERE WEEK(c02)=WEEK(NOW()) order by id");
//循环显示设置
$outgm_str="";
foreach($gm_list as $key=>$value_gm)
{
//显示日期及代办主要日程
$outgm_str.=($key+1).".".$value_gm["gmrq"]." .".$value_gm["c04"]."\n";
}
//echo $outgm_str
//end