function user_listByPriv($USER_PRIV)
{
global $USER_COUNT;
global $MANAGE_FLAG;
global $MODULE_ID;
global $db;
$OPTION_TEXT = "";
if ($MANAGE_FLAG) {
$query = "SELECT USER_ID,USER_NAME from user where USER_PRIV=" . $USER_PRIV;
} else {
$query = "SELECT USER_ID,USER_NAME from user where USER_PRIV=" . $USER_PRIV . " and NOT_LOGIN!='1'";
}
if ($MODULE_ID != '1') {
$query = getRoleByUser($query, "user_id");
}
$query = $query . " order by USER_NO,USER_NAME";
$cursor = $db->Execute($query);
$ROW1 = $cursor->GetArray();
for ($j = 0; $j < sizeof($ROW1); $j++) {
++$USER_COUNT;
$USER_ID = $ROW1[$j]['USER_ID'];
$USER_NAME = $ROW1[$j]['USER_NAME'];
$OPTION_TEXT .= "<tr class='TableData' onclick=javascript:add_user('" . $USER_ID . "','" . $USER_NAME . "') style='cursor:pointer' align='center'>\r\n <td class='menulines' id='" . $USER_ID . "' name='" . $USER_NAME . "' flag='1'>\r\n " . htmlspecialchars($USER_NAME) . "</td></tr>";
}
return $OPTION_TEXT;
}
function user_tree_list($DEPT_ID)
{
global $connection;
global $DEEP_COUNT;
global $USER_COUNT;
global $MANAGE_FLAG;
global $MODULE_ID;
global $db;
global $seldeptidArray;
$query = "SELECT DEPT_ID,DEPT_NAME from department where DEPT_PARENT='" . $DEPT_ID . "' order by DEPT_NO";
$cursor1 = $db->Execute($query);
$ROW = $cursor1->GetArray();
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " ";
for ($i = 0; $i < sizeof($ROW); $i++) {
$DEPT_ID = $ROW[$i]['DEPT_ID'];
if (!in_array($DEPT_ID, $seldeptidArray)) {
continue;
}
$DEPT_NAME = $ROW[$i]['DEPT_NAME'];
$DEPT_NAME = htmlspecialchars($DEPT_NAME);
$OPTION_TEXT .= "<tr class='TableHeader'><td><b>" . $DEEP_COUNT1 . "├" . $DEPT_NAME . "</b></td></tr>";
if ($MANAGE_FLAG) {
$query = "SELECT USER_ID,USER_NAME from user where DEPT_ID=" . $DEPT_ID;
} else {
$query = "SELECT USER_ID,USER_NAME from user where DEPT_ID=" . $DEPT_ID . " and NOT_LOGIN!='1'";
}
if ($MODULE_ID == 1) {
$query = getRoleByUser($query, "user_id");
}
$query = $query . " order by USER_NO,USER_NAME";
$cursor = $db->Execute($query);
$ROW1 = $cursor->GetArray();
for ($j = 0; $j < sizeof($ROW1); $j++) {
++$USER_COUNT;
$USER_ID = $ROW1[$j]['USER_ID'];
$USER_NAME = $ROW1[$j]['USER_NAME'];
$OPTION_TEXT .= "<tr class='TableData' onclick=javascript:click_user('" . $USER_ID . "') style='cursor:pointer' align='center'>\r\n <td class='menulines' id='" . $USER_ID . "' title='" . $USER_NAME . "' flag='1'>\r\n " . htmlspecialchars($USER_NAME) . "</td></tr>";
}
$OPTION_TEXT .= user_tree_list($DEPT_ID);
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
$db->StartTrans();
require_once "../Framework/uploadFile.php";
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
deleteFile("workplanmain_detail", "id", $selectid[$i], "fujian");
$mainrowid = returntablefield("workplanmain_detail", "id", $selectid[$i], "mainrowid");
$sql = "delete from workplanmain_detail where id=" . $selectid[$i];
$db->Execute($sql);
updateWorkplanmain($mainrowid);
}
}
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("任务执行记录");
$return = FormPageAction("action", "init_default");
print_infor("任务执行记录已删除", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
}
addShortCutByDate("begintime", "开始时间");
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "createman");
//$SYSTEM_PRINT_SQL=1;
$filetablename = 'workplanmain_detail';
$parse_filename = 'workplanmain_detail';
require_once 'include.inc.php';
array_push($FILENAMEArray, $FILENAME);
}
}
//$mail->AddAttachment('images/phpmailer_mini.gif'); // attachment
$mail->Send();
$_POST['SEND_FLAG'] = 1;
while (list($key, $value) = each($FILENAMEArray)) {
@unlink($value);
}
} catch (phpmailerException $e) {
$error = $e->errorMessage();
//Pretty error messages from PHPMailer
} catch (Exception $e) {
$error = $e->getMessage();
//Boring error messages from anything else!
}
if ($error != '') {
$error = str_replace("\n", '', $error);
$error = str_replace("\r", '', $error);
$error = preg_replace('/<[^>]+>/iU', '', $error);
print "<script language=javascript>alert('邮件发送失败，原因：" . $error . "');history.back(-1);</script>";
exit;
}
}
addShortCutByDate("SEND_TIME", "发送时间");
$SYSTEM_ADD_SQL = $SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "FROM_ID");
//数据表模型文件,对应Model目录下面的email_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'email';
$parse_filename = 'email';
require_once '../JXC/include.inc.php';
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
$sql = "delete from message where msgtype='公告通知' and guanlianid=" . $selectid[$i];
$db->Execute($sql);
}
}
}
if ($_GET['action'] == "view_default") {
/*
$id=$_GET['id'];
$sql="select * from message where userid='".$_SESSION['LOGIN_USER_ID']."' and guanlianid=$id";
$rs=$db->Execute($sql);
$rs_a=$rs->GetArray();
$messageid=0;
if(sizeof($rs_a)==1)
$messageid=$rs_a[0]['id'];
if($messageid>0)
{
$sql="update message set flag=1 where id=$messageid";
$db->Execute($sql);
}
*/
}
addShortCutByDate("createtime", "发布时间");
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "from_user");
$filetablename = 'notify';
$parse_filename = 'notify';
require_once 'include.inc.php';
parent.user.location="children.php?MODULE_ID=&DEPT_ID="+the_id+"&CHECKED="+checked+"&"+para_id+"="+para_value;
}
</script>
</head>
<body class="bodycolor" topmargin="1" leftmargin="0" onload="kword.focus();">
<div style="border:1px solid #000000;margin-left:2px;background:#FFFFFF;">
<input type="text" id="kword" name="kword" value="按客户名称、拼音码搜索..." onfocus="ctroltime=setTimeout(CheckSend,100);" onblur="clearTimeout(ctroltime);if(this.value=='')this.value='按客户名称、拼音码搜索...';" class="SmallInput" style="border:0px; color:#A0A0A0;width:145px;"><img id="search_icon" src="../../../Framework/images/quicksearch.gif" align=absmiddle style="cursor:pointer;">
</div>
<table class="TableBlock trHover" width="100%" align="center">
<?php
print "\n\t<tr class=TableHeader>\n\t<td align=center >所属用户 </td>\n\t</tr>\n\t<tr class=TableData>\n\t<td align=center onclick=\"javascript:seluser='';CheckSend();\" style=\"cursor:pointer\"><全部用户></td>\n\t</tr>\n\t";
$sql = "select * from user where 1=1 ";
$sql = getRoleByUser($sql, "user_id");
$sql .= " order by user_name";
$rs = $db->CacheExecute(5, $sql);
$rs_a = $rs->GetArray();
for ($i = 0; $i < sizeof($rs_a); $i++) {
$所属用户 = $rs_a[$i]['USER_NAME'];
print "\n\t<tr class=TableData>\n\t<td align=center onclick=\"javascript:seluser='******'USER_ID'] . "';CheckSend();\" style=\"cursor:pointer\">" . $所属用户 . "</td>\n\t</tr>\n\t";
}
?>
</table>
</body>
</html>
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
$user_id = $_SESSION['LOGIN_USER_ID'];
$dept_id = $_SESSION['LOGIN_DEPT_ID'];
$user_priv = $_SESSION['LOGIN_USER_PRIV'];
$module_desc = "客户服务";
$max_count = "4";
$module_body = "";
$sql = "select * from crm_service where (严重程度='2' or 严重程度='3') ";
$sql = getRoleByUser($sql, "创建人");
$sql = $sql . " order by 创建时间 desc limit 0 , {$max_count}";
$rs = $db->CacheExecute(150, $sql);
$rs_a = $rs->GetArray();
$count = $max_count - count($rs_a);
$module_body .= "<table border=\"0\" width=\"100%\">";
if (count($rs_a) > 0) {
for ($i = 0; $i < count($rs_a); $i++) {
$编号 = $rs_a[$i]['编号'];
$服务编号 = '单号：' . $rs_a[$i]['服务编号'];
$customerName = returntablefield("customer", "rowid", $rs_a[$i]['客户名称'], "supplyname");
$servicetype = returntablefield("crm_dict_servicetypes", "编号", $rs_a[$i]['服务编号'], "名称");
$servicestate = returntablefield("crm_dict_servicestatus", "编号", $rs_a[$i]['严重程度'], "名称");
if ($rs_a[$i]['严重程度'] == 2) {
$servicestate = "<font color=red>" . $servicestate . "</font>";
}
if ($rs_a[$i]['严重程度'] == 3) {
$servicestate = "<font color=blue>" . $servicestate . "</font>";
}
echo $USER_ID;
echo "\" title=\"";
echo $USER_NAME;
echo "\" flag=\"1\" align=\"center\" onclick=\"javascript:click_user('";
echo $USER_ID;
echo "')\" style=\"cursor:pointer\">\r\n ";
echo htmlspecialchars($USER_NAME);
echo " </td>\r\n</tr>\r\n\r\n";
}
if ($USER_PRIV != "") {
$query = "SELECT USER_ID,USER_NAME from user where (USER_PRIV_OTHER like '" . $USER_PRIV . ",%' or USER_PRIV_OTHER like '%,{$USER_PRIV},%') and USER_PRIV!='{$USER_PRIV}' and DEPT_ID!=0 ";
if (!$MANAGE_FLAG) {
$query .= " and NOT_LOGIN!='1'";
}
if ($MODULE_ID == 1) {
$query = getRoleByUser($query, "USER_ID");
}
$query .= " order by USER_NO,USER_NAME";
$cursor = $db->Execute($query);
$ROW = $cursor->GetArray();
$USER_COUNT1 = 0;
for ($i = 0; $i < sizeof($ROW); $i++) {
++$USER_COUNT;
++$USER_COUNT1;
$USER_ID = $ROW[$i]['USER_ID'];
$USER_NAME = $ROW[$i]['USER_NAME'];
if ($USER_COUNT1 == 1) {
echo "<tr class=\"TableHeader\">\r\n <td colspan=\"2\" align=\"center\"><b>辅助角色</b></td>\r\n</tr>\r\n<tr class=\"TableControl\">\r\n <td onclick=\"javascript:add_all('2');\" style=\"cursor:pointer\" align=\"center\">全部添加</td>\r\n</tr>\r\n<tr class=\"TableControl\">\r\n <td onclick=\"javascript:del_all('2');\" style=\"cursor:pointer\" align=\"center\">全部删除</td>\r\n</tr>\r\n";
}
echo "\r\n<tr class=\"TableData\" onclick=\"javascript:click_user('";
echo $USER_ID;
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
validateMenuPriv("手机短信");
addShortCutByDate("nowtime", "提交时间");
$SYSTEM_ADD_SQL = $SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "userid");
//数据表模型文件,对应Model目录下面的sms_sendlist_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'sms_sendlist';
$parse_filename = 'sms_sendlist';
require_once 'include.inc.php';
if ($_GET['action'] == "add_default") {
$sendlist = $_GET['sendlist'];
$sendlistarray = explode(",", $sendlist);
$textareaInitValue = "";
for ($i = 0; $i < count($sendlistarray); $i++) {
if ($sendlistarray[$i] == '') {
continue;
}
if ($_GET['fromsrc'] == 'user') {
$linkman = returntablefield("user", "UID", $sendlistarray[$i], "MOBIL_NO,USER_NAME");
if ($linkman['MOBIL_NO'] != '') {
if ($textareaInitValue == '') {
$textareaInitValue = $linkman['MOBIL_NO'] . " " . $linkman['USER_NAME'];
} else {
$textareaInitValue = $textareaInitValue . "\\n" . $linkman['MOBIL_NO'] . " " . $linkman['USER_NAME'];
}
$结束时间 = $_POST['结束时间'] . " 23:59:59";
$sql = "delete from system_log where `DATE`>='{$开始时间}' and `DATE`<='{$结束时间}'";
$db->Execute($sql);
优化数据表("system_log");
print_infor("您的操作已经完成,请返回...", '', "location='?'", "?");
exit;
}
定时执行函数($函数名称 = '自动清除30天以前的历史日志记录', $间隔时间 = '30');
function 自动清除30天以前的历史日志记录()
{
global $db;
$sql = "delete from system_log where datediff(now(),DATE)>=21";
$db->Execute($sql);
//print $sql."<BR>";
}
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "USERID");
//数据表模型文件,对应Model目录下面的system_log_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'system_log';
$parse_filename = 'system_log';
require_once 'include.inc.php';
//print_R($_SESSION);
$总角色数组 = explode(',', $_SESSION['LOGIN_USER_PRIV'] . "," . $_SESSION['LOGIN_USER_PRIV_OTHER']);
if ($_GET['action'] == "init_default" && in_array('1', $总角色数组) && $_GET['actionadv'] != "exportadv_default") {
print "<SCRIPT>\n\tfunction td_calendar(fieldname) {\n\t\tmyleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\n\t\tmytop=document.body.scrollTop+event.clientY-event.offsetY+140;\n\t\twindow.showModalDialog(fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:200px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\n\t\t}\n\t</SCRIPT>";
print "<FORM name=form1 action=\"?action=DataDealDelte&pageid=1\" method=post encType=multipart/form-data>";
print "<table class=TableBlock width=100%>";
print "<tr class=TableContent><td>\n\t\t <font color=green>按操作时间进行删除记录\n\t开始时间: <INPUT class=SmallInput maxLength=20 name=开始时间 value=\"" . date("Y-m-d", mktime(1, 1, 1, date('m'), date('d') - 21, date('Y'))) . "\" >\n\t<input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onclick=\"td_calendar('../../Framework/sms_index/calendar_begin.php?datetime=开始时间');\" title=\"选择\" name=\"button\">\n\t结束时间:<INPUT class=SmallInput maxLength=20 name=结束时间 value=\"" . date("Y-m-d", mktime(1, 1, 1, date('m'), date('d'), date('Y'))) . "\" >\n\t<input type=\"button\" title='' value=\"选择\" class=\"SmallButton\" onclick=\"td_calendar('../../Framework/sms_index/calendar_begin.php?datetime=结束时间');\" title=\"选择\" name=\"button\">\n\t<input type=submit class=SmallButton name='提交' value='提交'>\n\t</font>\n\t\t</td></tr>";
print "</table>";
print "</FORM>";
}
if ($I < 10) {
$I = "0" . $I;
}
echo " <option value=\"";
echo $I;
echo "\" ";
if ($I == $DAY) {
echo "selected";
}
echo ">";
echo $I;
echo "日</option>\r\n";
}
echo " </select><input type=\"button\" value=\" > \" class=\"ArrowButton\" style=\"font-weight:bold\" title=\"下一天\" onclick=\"set_day(1);\">\r\n ";
$sql = "select * from user where 1=1";
getRoleByUser($sql, "USER_ID");
$sql .= " order by USER_NAME";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
echo "<select name='user_id' class=\"SmallSelect\" style=\"font-weight:bold\" onchange=\"document.form1.BTN_OP.value='0';My_Submit();\">";
foreach ($rs_a as $row) {
$check = "";
if ($user_id == $row['USER_ID']) {
$check = "selected";
}
echo "<option value='" . $row['USER_ID'] . "' {$check}>" . $row['USER_NAME'] . "</option>";
}
echo "</select> </td>\r\n <td align=\"right\">\r\n <input type=\"button\" value=\"新建日程\" class=\"SmallButton\" onClick=\"new_cal('" . date("H") . "');\" title=\"创建新的日程，以便提醒自己\">\r\n <select name=\"VIEW\" class=\"SmallSelect\" onchange=\"set_view();\">\r\n <option value=\"day\"> 日列表</option>\r\n <option value=\"week\"> 周列表</option>\r\n <option value=\"month\" selected> 月列表</option>\r\n </select>\r\n </td>\r\n </tr>\r\n </form>\r\n </table>\r\n\r\n";
$CUR_TIME = date("Y-m-d H:i:s", time());
$query = "SELECT * from calendar where USER_ID='" . $user_id . "' and ((CAL_TIME>='" . date("Y-m-d", $MONTH_BEGIN) . " 00:00:00' and CAL_TIME<='" . date("Y-m-d", $MONTH_END) . " 23:59:59') or (END_TIME>='" . date("Y-m-d", $MONTH_BEGIN) . " 00:00:00' and END_TIME<='" . date("Y-m-d", $MONTH_END) . " 23:59:59') or (CAL_TIME<'" . date("Y-m-d", $MONTH_BEGIN) . " 00:00:00' and END_TIME>'" . date("Y-m-d", $MONTH_END) . " 23:59:59')) order by CAL_TIME";
$rs = $db->Execute($query);
$GLOBAL_SESSION = returnsession();
$SYSTEM_PRIV_STOP = "1";
validateMenuPriv("报销申请");
//$SYSTEM_PRINT_SQL = 1;
//print_r($_GET);exit;
if ($_GET['action'] == "edit_TongYi") {
page_css();
$billid = $_GET['单号'];
$sql = "update crm_feiyong_sq set 是否审核='2',审核人='" . $_SESSION['LOGIN_USER_ID'] . "',审核日期=now() where 单号='{$billid}'";
$rs = $db->Execute($sql);
$billinfo = returntablefield("crm_feiyong_sq", "单号", $billid, "费用类型,金额,录单员");
$feiyongname = returntablefield("v_feiyongbaoxiao", "id", $billinfo['费用类型'], "typename");
newMessage($billinfo['录单员'], $feiyongname . '(金额:' . $billinfo['金额'] . ')--已通过！', '报销申请', '../CRM/crm_feiyong_sq_newai.php?' . base64_encode('action=view_default&单号=' . $billid), $billid);
$return = FormPageAction("action", "init_default");
print_infor("<b>审核通过</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
exit;
}
if ($_GET['action'] == "edit_FouJue") {
page_css();
$billid = $_GET['单号'];
$sql = "update crm_feiyong_sq set 是否审核='3',审核人='" . $_SESSION['LOGIN_USER_ID'] . "',审核日期=now() where 单号='{$billid}'";
$rs = $db->Execute($sql);
$return = FormPageAction("action", "init_default");
print_infor("<b>审核否决</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
exit;
}
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "录单员");
addShortCutByDate("创建时间", "创建时间");
$filetablename = 'crm_feiyong_sq';
$parse_filename = 'crm_feiyong_sq';
require_once 'include.inc.php';
