$date = get_date('Y-m-d H:i:s', PHP_TIME);
$documentid = getGP('documentid', 'P');
$annex = getGP('annex', 'P');
$uid = $_USER->id;
if (getGP('readuser', 'P') != '') {
$readuser = getGP('readuser', 'P');
} else {
$readuser = "******";
}
$document = array('title' => $title, 'content' => $content, 'documentid' => $documentid, 'annex' => $annex, 'readuser' => $readuser, 'type' => $type, 'uid' => $uid, 'date' => $date, 'key' => 0);
insert_db('document', $document);
$id = $db->insert_id();
//短消息
if (getGP('sms_info_box_readuser', 'P') != '') {
$content = $readuser . ':您有一个文件需要阅读,名称为：' . $title . ';请进行查看!<a href="admin.php?ac=views&fileurl=' . $fileurl . '&do=edit&id=' . $id . '&type=' . $type . '">点击查看>></a>';
SMS_ADD_POST($readuser, $content, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_readuser', 'P') != '') {
$content = $readuser . ':您有一个文件需要阅读,请登录OA进行查看!';
PHONE_ADD_POST(getGP('readuserphone', 'P'), $content, $readuser, 0, 0, $_USER->id);
}
$content = serialize($document);
$title = '新增' . $_title['title'] . '信息';
get_logadd($id, $content, $title, 34, $_USER->id);
}
show_msg($_title['title'] . '信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&type=' . $type . '');
} else {
$id = getGP('id', 'G', 'int');
if ($id != '') {
$user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "document WHERE id = '{$id}' ");
$content = "你有一条公文需要在" . (0 - $row['days']) . "天内完成审批！";
} else {
$content = "你有一条公文已超期" . $row['days'] . "天，请尽快处理！";
}
$query = $db->query("SELECT id,name,pkey,apptype FROM toa_personnel where fileid=" . $row['id'] . " and type=" . $row['tp'] . " and pkey in(0,4)");
while ($log = $db->fetch_array($query)) {
$i += 1;
$content .= '<a href="admin.php?ac=' . $row['ftab'] . '&do=personnel&fileurl=app';
$content .= '&fileid=' . $row['id'] . '&apptype=' . $log['apptype'] . '">进入办理<a/>';
if ($log['pkey'] == '0') {
SMS_ADD_POST($log['name'], $content, 0, 0, 1);
echo $row['id'] . $content . "NAME:" . $log['name'] . "<br>";
} else {
$query2 = $db->query("SELECT name FROM toa_personnel_log where perid=" . $log['id'] . " and pkey=0");
while ($logg = $db->fetch_array($query2)) {
SMS_ADD_POST($logg['name'], $content, 0, 0, 1);
echo "[多人]" . $row['id'] . $content . "NAME:" . $logg['name'] . "<br>";
}
}
}
}
date_default_timezone_set("PRC");
echo date("Y-m-d H:i:s");
?>
<br>运行成功，共有<?php
echo $i;
?>
条公文符合提醒条件！<br>5d64d624bb
<script language="javascript">
setTimeout("go();",3600000);
$news = array('category' => $category, 'receive' => $receive, 'subject' => $subject, 'content' => $content, 'appendix' => $appendix, 'type' => $type, 'date' => $udate, 'pic' => $pic, 'uid' => $uid);
insert_db('news', $news);
$id = $db->insert_id();
if (getGP('shownamemasterid', 'P') != '') {
$shownamemaster = explode(',', getGP('shownamemasterid', 'P'));
for ($i = 0; $i < sizeof($shownamemaster); $i++) {
$news_read = array('disdate' => $udate, 'uid' => $shownamemaster[$i], 'dkey' => '0', 'newsid' => $id);
insert_db('news_read', $news_read);
}
}
if (getGP('sms_info_box_shownamemaster', 'P') != '') {
$content = '';
$content = '您有一条新的' . $_news['title'] . '需要阅读,请点击查';
$content .= '看!<a href="admin.php?ac=news&fileurl=administrative&do=views';
$content .= '&id=' . $id . '&type=' . $type . '">点击阅读>></a>';
SMS_ADD_POST($receive, $content, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_shownamemaster', 'P') != '') {
$content = '';
$content = '您有一新企业消息[' . $_news['title'] . ']需要阅读;请登录OA进行阅读!';
PHONE_ADD_POST(getGP('shownamemasterphone', 'P'), $content, $receive, 0, 0, $_USER->id);
}
$content = '';
$content = serialize($news);
$title = '新增' . $_news['title'];
get_logadd($id, $content, $title, 13, $_USER->id);
}
show_msg($_news['title'] . '信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&type=' . $type);
} else {
$id = getGP('id', 'G', 'int');
insert_db('plan', $plan);
$id = $db->insert_id();
if (getGP('sms_info_box_person', 'P') != '') {
$content = '您有一个计划需要执行,计划主题为：' . $title . ';请进行处理!<a href="admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=views&id=' . $id . '">点击查看>></a>';
//接收人；内容；类型（1：有返回回值;0：无返回值）;URL
SMS_ADD_POST($person, $content, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_person', 'P') != '') {
$content = '您有一个计划需要执行,请登录OA进行处理!';
PHONE_ADD_POST(getGP('personphone', 'P'), $content, $person, 0, 0, $_USER->id);
}
//////////////////////////////////////////////////
if (getGP('sms_info_box_participation', 'P') != '') {
$content = '您有一个计划需要参与,计划主题为：' . $title . ';请进行处理!<a href="admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=views&id=' . $id . '">点击查看>></a>';
SMS_ADD_POST($participation, $content, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_participation', 'P') != '') {
$content = '您有一个计划需要参与,请登录OA进行处理!';
PHONE_ADD_POST(getGP('participationphone', 'P'), $content, $participation, 0, 0, $_USER->id);
}
$content = serialize($plan);
$title = '新增工作计划';
get_logadd($id, $content, $title, 12, $_USER->id);
}
show_msg('计划信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} else {
$id = getGP('id', 'G', 'int');
if ($id != '') {
$user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "plan WHERE id = '{$id}' ");
}
}
}
//处理库存
if ($pkeys == 5 && getGP('modid', 'P') == 'crm_purchase') {
global $db;
$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "crm_prod_view where viewid='" . $viewid . "' and type=2 ORDER BY id Asc");
while ($rs = $db->fetch_array($query)) {
$crm_stock = array('pid' => $rs['pid'], 'stocknum' => $rs['number'], 'unit' => $rs['unit'], 'number' => "T" . get_date('YmdHis', PHP_TIME), 'type' => 2, 'date' => get_date('Y-m-d H:i:s', PHP_TIME), 'uid' => $_USER->id);
insert_db('crm_stock', $crm_stock);
}
}
//通知审批人员
if (getGP('sms_info_box_shownamemaster', 'P') != '') {
$content1 = '您有一个工作流程需要审批,请点击进入工作流进行审批!';
SMS_ADD_POST(getGP('staff', 'P'), $content1, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_shownamemaster', 'P') != '') {
$content2 = '您有一个工作流程需要审批,请登录OA进行审批!';
PHONE_ADD_POST(getGP('staffphone', 'P'), $content2, getGP('staff', 'P'), 0, 0, $_USER->id);
}
$content = serialize($personnel1);
$title = '审批工作流';
get_logadd($id, $content, $title, 14, $_USER->id);
show_msg('工作流己成功审批！', 'admin.php?ac=' . str_replace('crm_', '', getGP('modid', 'P')) . '&fileurl=' . $fileurl . '');
} else {
//获取工作流信息
$sql = "SELECT * FROM " . DB_TABLEPRE . $_GET['modid'] . " WHERE id = '" . $_GET['viewid'] . "'";
$row = $db->fetch_one_array($sql);
//获取当前流程
}
}
//通知审批人员
if (getGP('sms_info_box_shownamemaster', 'P') != '') {
$content1 = '您有一个项目' . $mod['modname'] . '需要审批,请进入项目' . $mod['modname'] . '进行审批!';
SMS_ADD_POST(getGP('staff', 'P'), $content1, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_shownamemaster', 'P') != '') {
$content2 = '您有一个项目' . $mod['modname'] . '需要审批,请登录OA进行审批!';
PHONE_ADD_POST(getGP('staffphone', 'P'), $content2, getGP('staff', 'P'), 0, 0, $_USER->id);
}
//通知其它人员
if (getGP('viewuser', 'P') != '') {
$content3 = '您接收到一条来自项目' . $mod['modname'] . '的通知,请进入项目' . $mod['modname'] . '进行查看!';
SMS_ADD_POST(getGP('viewuser', 'P'), $content3, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_shownamemaster', 'P') != '') {
$content4 = '您有一个项目' . $mod['modname'] . '需要审批,请登录OA进行审批!';
PHONE_ADD_POST(getGP('viewuserphone', 'P'), $content4, getGP('viewuser', 'P'), 0, 0, $_USER->id);
}
$content = serialize($personnel1);
$title = '审批项目' . $mod['modname'];
get_logadd($id, $content, $title, 32, $_USER->id);
show_msg('项目' . $mod['modname'] . '己成功审批！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&modid=' . $modid . '&projectid=' . $projectid . '&typeid=' . $typeid . '&type=1');
} else {
//获取项目信息
$sql = "SELECT * FROM " . DB_TABLEPRE . "project_log WHERE lid = '" . $_GET['lid'] . "'";
$row = $db->fetch_one_array($sql);
//获取当前流程
$s++;
$wage_data = array('viewid' => $vid, 'tid' => $type['tid'], 'name' => $type['name'], 'content' => mb_convert_encoding($result[$i][$s], "UTF-8", "GB2312"), 'type' => 2, 'uid' => $result[$i][0], 'wid' => $wid);
insert_db('wage_data', $wage_data);
}
}
//echo $result[$i][0].'<br>';
}
fclose($handle);
//关闭指针
echo '导入成功';
exit;
//show_msg('人员工资信息导入成功！', 'admin.php?ac='.$ac.'&fileurl='.$fileurl.'&do=log&wid='.getGP('wid','P'));
}
include_once 'template/excel.php';
} elseif ($do == 'sms') {
if ($_POST['view'] != '') {
$uid = getGP('uid', 'P', 'array');
$name = getGP('name', 'P', 'array');
$content = getGP('content', 'P', 'array');
foreach ($uid as $id) {
SMS_ADD_POST($name[$id], $content[$id], 0, 0, $_USER->id);
}
show_msg('工资条发送成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=sms&wid=' . ($name = getGP('wid', 'P')));
} else {
$sql = "SELECT * FROM " . DB_TABLEPRE . "wage WHERE wid = '" . $_GET['wid'] . "'";
$row = $db->fetch_one_array($sql);
$sql = "SELECT * FROM " . DB_TABLEPRE . "wage_log WHERE wid = '" . $row['wid'] . "' order by lid asc";
$result = $db->fetch_all($sql);
include_once 'template/sms.php';
}
}
function crm_flow_save($modid = '', $vid = 0, $userkey, $userkeyid, $flowid, $appkey, $appkey1, $sms_info_box_work, $sms_phone_box_work, $userkeyphone)
{
global $db, $_USER;
$sql = "SELECT * FROM " . DB_TABLEPRE . "crm_flow WHERE modid = '" . $modid . "' and flownum=1 order by fid asc";
$flow = $db->fetch_one_array($sql);
$personnel1 = array('name' => get_realname($_USER->id), 'uid' => $_USER->id, 'designationdate' => get_date('Y-m-d H:i:s', PHP_TIME), 'approvaldate' => get_date('Y-m-d H:i:s', PHP_TIME), 'lnstructions' => '生成流程申请单，系统自动完成该步骤', 'pertype' => 1, 'viewid' => $vid, 'modid' => $modid, 'flowid' => $flow['fid'], 'appkey' => 2, 'appkey1' => 2);
insert_db('crm_personnel', $personnel1);
//写入审批流程
$personnel2 = array('name' => $userkey, 'uid' => $userkeyid, 'designationdate' => get_date('Y-m-d H:i:s', PHP_TIME), 'pertype' => 0, 'viewid' => $vid, 'modid' => $modid, 'flowid' => $flowid, 'appkey' => $appkey, 'appkey1' => $appkey1);
//echo var_dump($personnel2);
//exit;
insert_db('crm_personnel', $personnel2);
$pid = $db->insert_id();
if ($appkey == '1') {
$userkey = explode(',', $userkey);
$userkeyid = explode(',', $userkeyid);
for ($i = 0; $i < sizeof($userkeyid); $i++) {
$personnel_log = array('name' => $userkey[$i], 'uid' => $userkeyid[$i], 'pertype' => 0, 'perid' => $pid, 'viewid' => $vid, 'modid' => $modid);
insert_db('crm_personnel_log', $personnel_log);
}
}
//提示
if ($sms_info_box_work != '') {
$content = '您有一个新CRM流程需要审批,请点击查看!<a href="admin.php?ac=personnel&fileurl=crm&viewid=' . $vid . '&modid=' . $modid . '">点击审批>></a>';
//接收人；内容；类型（1：有返回回值;0：无返回值）;URL
SMS_ADD_POST($userkey, $content, 0, 0, $_USER->id);
}
//手机短信
if ($sms_phone_box_work != '') {
$content = '您有一个新CRM流程需要审批,请登录OA进行审批!';
PHONE_ADD_POST($userkeyphone, $content, $userkey, 0, 0, $_USER->id);
}
}
$ids = explode(',', str_replace("515158,", "", $arr_id));
$goods_title = explode(',', str_replace("515158,", "", $arr_goods_title));
$goods_specification = explode(',', str_replace("515158,", "", $arr_goods_specification));
$goods_unit = explode(',', str_replace("515158,", "", $arr_goods_unit));
$goods_goodsnumber = explode(',', str_replace("515158,", "", $arr_goods_goodsnumber));
$goods_price = explode(',', str_replace("515158,", "", $arr_goods_price));
$pricenum = '0';
for ($i = 0; $i < sizeof($ids); $i++) {
$pricenum = $pricenum + $goods_goodsnumber[$i] * $goods_price[$i];
}
$goods_purchase = array('application' => $application, 'number' => $number, 'startdate' => $startdate, 'pricenum' => $pricenum, 'content' => $content, 'purchase' => $purchase, 'key1' => 1, 'uid' => $_USER->id);
insert_db('goods_purchase', $goods_purchase);
$id = $db->insert_id();
for ($i = 0; $i < sizeof($ids); $i++) {
$goods_purchase_view = array('goods_purchase' => $id, 'officegoods' => $ids[$i], 'title' => $goods_title[$i], 'specification' => $goods_specification[$i], 'unit' => $goods_unit[$i], 'price' => $goods_price[$i], 'goodsnumber' => $goods_goodsnumber[$i], 'date' => get_date('y-m-d H:i:s', PHP_TIME), 'uid' => $_USER->id);
insert_db('goods_purchase_view', $goods_purchase_view);
}
//发送提示信息
//短消息
if (getGP('sms_info_box_purchase', 'P') != '') {
$content = '您有一个采购任务需要执行,编号为：' . $number . ';请进行处理!<a href="admin.php?ac=goods_purchase_views&do=list&fileurl=goods&id=' . $id . '">点击处理>></a>';
//接收人；内容；类型（1：有返回回值;0：无返回值）;URL
SMS_ADD_POST($purchase, $content, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_purchase', 'P') != '') {
$content = '您有一个采购任务需要执行,编号为：' . $number . ';请登录OA进行处理!';
PHONE_ADD_POST(getGP('purchasephone', 'P'), $content, $purchase, 0, 0, $_USER->id);
}
show_msg('您要处理的信息操作成功！', 'admin.php?ac=goods_purchase&fileurl=' . $fileurl . '');
}
//手机短信
if (getGP('sms_phone_box_shownamemaster', 'P') != '') {
$content2 = '您有一个工作流程需要审批,请登录OA进行审批!';
PHONE_ADD_POST(getGP('staffphone', 'P'), $content2, getGP('staff', 'P'), 0, 0, $_USER->id);
}
//通知其它人员
if (getGP('viewuser', 'P') != '') {
$content3 = '您接收到一条来自工作流的通知,请点击“<a href="admin.php?ac=list&do=view&fileurl=workclass&workid=' . $workid . '">查看</a>”工作流!';
SMS_ADD_POST(getGP('viewuser', 'P'), $content3, 0, 0, $_USER->id);
}
$content4 = '审批流程“' . getGP('title', 'P') . '“于“' . get_date('Y-m-d H:i:s', PHP_TIME) . '“被' . get_realname($_USER->id) . '审批完成,请点击“<a href="admin.php?ac=list&do=view&fileurl=workclass&workid=' . $workid . '">查看</a>”工作流!';
//通知前几步审批人员
$sqlu = "SELECT * FROM " . DB_TABLEPRE . "workclass_personnel WHERE workid = '" . $workid . "' and perid <" . $perid . "";
$results = $db->query($sqlu);
while ($upfid = $db->fetch_array($results)) {
SMS_ADD_POST($upfid['name'], $content4, 0, 0, $_USER->id);
}
//手机短信
if (getGP('sms_phone_box_shownamemaster', 'P') != '') {
$content4 = '您有一个工作流程需要审批,请登录OA进行审批!';
PHONE_ADD_POST(getGP('viewuserphone', 'P'), $content4, getGP('viewuser', 'P'), 0, 0, $_USER->id);
}
$content = serialize($personnel1);
$title = '审批工作流';
get_logadd($id, $content, $title, 14, $_USER->id);
show_msg('工作流己成功审批！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&type=1');
} else {
//获取工作流信息
$sql = "SELECT * FROM " . DB_TABLEPRE . "workclass WHERE id = '" . $_GET['workid'] . "'";
$row = $db->fetch_one_array($sql);
//获取当前流程
//出席人员
if (getGP('sms_info_box_participation', 'P') != '') {
$content = '';
$content = '您有一个会议需要出席,申请人是:"' . $apppersonsms . '",请注意查看会议出席时间!<a href="admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=views&id=' . $id . '">点击查看>></a>';
SMS_ADD_POST($attendance, $content, 0, 0, $_USER->id);
}
if (getGP('sms_phone_box_participation', 'P') != '') {
$content = '';
$content = '您有一个会议需要出席,申请人是:"' . $apppersonsms . '",请登录OA查看会议出席时间!';
PHONE_ADD_POST(getGP('participationphone', 'P'), $content, $attendance, 0, 0, $_USER->id);
}
//审批人员
if (getGP('sms_info_box_staffid', 'P') != '') {
$content = '';
$content = $staffidsms . ':有一个会议申请需要您审批,申请人是:"' . $apppersonsms . '",请进入会议管理进行审批!<a href="admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=views&id=' . $id . '">点击审批>></a>';
SMS_ADD_POST($staffidsms, $content, 0, 0, $_USER->id);
}
if (getGP('sms_phone_box_staffid', 'P') != '') {
$content = '';
$content = $staffidsms . ':有一个会议申请需要您审批,申请人是:"' . $apppersonsms . '",请登录OA进行审批!';
PHONE_ADD_POST(getGP('staffidphone', 'P'), $content, $staffidsms, 0, 0, $_USER->id);
}
$content = '';
$content = serialize($conference);
$title = '新增会议信息';
get_logadd($id, $content, $title, 19, $_USER->id);
}
show_msg('会议信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} else {
$id = getGP('id', 'G', 'int');
if ($id != '') {
