function getArticles($channelid, $type, $order, $n, $b, $w = 100, $returnarr = 0)
{
$channelid = intval($channelid);
$type = intval($type);
$order = intval($order);
$n = intval($n);
$b = intval($b);
$w = intval($w);
global $cache_channels;
$channel = $cache_channels[$channelid];
$articlestr = "";
$orderstr = $order == 1 ? "hits desc" : "posttime desc";
$arts = $this->db->row_select("articles", "langid={$this->langid}" . ($channelid > 0 ? " and channelid={$channelid}" : "") . ($type > 0 ? " and type={$type}" : "") . "", $n, "id,channelid,posttime,title,content,type,picid,picpath", $orderstr);
if ($returnarr == 1) {
return $arts;
}
$bn = 0;
foreach ($arts as $art) {
$arturl = $this->genUrl("view.php?id={$art['id']}");
$art['posttime'] = getDateStr($art['posttime'], true);
$bn++;
if ($bn < $b + 1) {
$art['picpath'] = $this->getPicPath($art['picpath']);
$articlestr .= "<li class=\"pictitle\"><a href=\"{$arturl}\" target=\"_blank\">{$art['title']}</a><p><a href=\"{$arturl}\" target=\"_blank\"><img src=\"{$art['picpath']}\" /></a><a href=\"{$arturl}\" target=\"_blank\">" . cutStr(strip_tags($art['content']), $w) . "</a></p></li>";
} else {
$articlestr .= "<li class=\"normaltitle\"><span class=time>{$art['posttime']}</span><a href=\"{$arturl}\" target=\"_blank\">{$art['title']}</a></li>";
}
}
return $articlestr;
}
public function addNews()
{
$M = M("News");
$data = $_POST['info'];
$data['published'] = time();
$data['aid'] = $_SESSION['my_info']['aid'];
if (empty($data['summary'])) {
$data['summary'] = cutStr($data['content'], 200);
}
if ($M->add($data)) {
return array('status' => 1, 'info' => "已经发布", 'url' => U('News/index'));
} else {
return array('status' => 0, 'info' => "发布失败，请刷新页面尝试操作");
}
}
public function run()
{
global $_FANWE;
$root = array();
$root['return'] = 0;
if ($_FANWE['uid'] == 0) {
$root['info'] = "请先登陆";
m_display($root);
}
$user_name = trim($_FANWE['requestData']['user_name']);
if (empty($user_name)) {
$root['info'] = "请选择要发送信件的粉丝";
m_display($root);
}
$message = trim($_FANWE['requestData']['message']);
if (empty($message)) {
$root['info'] = "请输入要发送信息";
m_display($root);
}
//echo $user_name; exit;
$user = FS('User')->getUsersByName($user_name);
if (empty($user)) {
$root['info'] = "请选择要发送信件的粉丝";
m_display($root);
}
if (!FS('User')->getIsFollowUId2($user['uid'], $_FANWE['uid'])) {
$root['info'] = "只能给粉丝发送信件";
m_display($root);
}
$message = cutStr($message, 200);
if (FS('Message')->sendMsg($_FANWE['uid'], $_FANWE['user_name'], array($user['uid']), '', $message) > 0) {
$root['return'] = 1;
$root['info'] = "发送信件成功";
} else {
$root['info'] = "发送信件失败";
}
m_display($root);
}
<?php
$mlid = intval($_FANWE['request']['lid']);
$message = trim($_FANWE['request']['message']);
if (empty($mlid) || empty($message)) {
exit;
}
$message = cutStr($message, 200);
$result['status'] = FS('Message')->replyMsg($mlid, $_FANWE['uid'], $_FANWE['user_name'], $message);
if ($result['status'] > 0) {
$result['time'] = getBeforeTimelag(TIME_UTC);
express($message);
$result['message'] = nl2br($message);
}
outputJson($result);
$addquery = getCustomerRoleByCustID($addquery, "b.customerid");
$query = $query . $addquery;
//echo $query;exit;
$rs = $db->CacheExecute(150, $query);
$ROW = $rs->GetArray();
$count = $valueVVVVVVV['显示行数'] - count($ROW);
for ($i = 0; $i < count($ROW); $i++) {
$linkmanid = $ROW[$i]['linkmanid'];
$linkmanname = $ROW[$i]['linkmanname'];
$mem_type = $ROW[$i]['mem_type'];
$customerName = returntablefield("customer", "rowid", $ROW[$i]['customerid'], "supplyname");
$BIRTHDAY = $ROW[$i]['mem_date'];
//echo $BIRTHDAY;
if (cutStr($customerName, 12) != $customerName) {
$title = $customerName;
$customerName = cutStr($customerName, 12) . "..";
}
++$COUNT2;
$PERSON_STR2 .= "<tr class=TableBlock>\n\t\t\t\t\t\t\t\t<td><img src=\"../images/arrow_r.gif\" align=\"absmiddle\"><a href=../../JXC/customer_newai.php?action=view_default&ROWID=" . $ROW[$i]['customerid'] . " target=_blank title='{$title}'>" . $customerName . "</td>\n\t\t\t\t\t\t\t\t<td><a href=../../JXC/linkman_newai.php?action=view_default&ROWID=" . $ROW[$i]['linkmanid'] . " target=_blank>" . $linkmanname . "</td>\n\t\t\t\t\t\t\t\t<td>" . $mem_type . "(" . date("m-d", strtotime($BIRTHDAY)) . ")</td>\n\t\t\t\t\t\t\t\t<td valign=Middle align=left><a href='../../JXC/sms_sendlist_newai.php?action=add_default&sendlist=" . $ROW[$i]['linkmanid'] . "' target='_blank'><img src='../../../Framework/images/menu/010401.gif' align=absmiddle></a></td></tr>";
}
for ($i = 0; $i < $count; $i++) {
$PERSON_STR2 .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
$MODULE_BODY .= "<table border=\"0\" width=\"100%\" height=\"100%\">";
if (0 < $COUNT2) {
$MODULE_BODY .= $PERSON_STR2;
} else {
$MODULE_BODY .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"><font color=\"red\">\n\t\t\t\t\t 暂无纪念日提醒!</font></td>";
for ($i = 0; $i < $count - 1; $i++) {
$MODULE_BODY .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
$rs_a = $rs->GetArray();
if (count($rs_a) != 0) {
for ($i = 0; $i < count($rs_a); $i++) {
$billnode = $doc->createElement("workplanmaindetail");
$billnode = $root->appendChild($billnode);
$begintime = $doc->createElement("begintime");
$begintimenode = $billnode->appendChild($begintime);
$endtime = $doc->createElement("endtime");
$endtimenode = $billnode->appendChild($endtime);
$content = $doc->createElement("content");
$contentnode = $billnode->appendChild($content);
$result = $doc->createElement("result");
$resultnode = $billnode->appendChild($result);
$begintimenode->appendChild($doc->createTextNode(substr($rs_a[$i]['begintime'], 0, 16)));
$endtimenode->appendChild($doc->createTextNode(substr($rs_a[$i]['endtime'], 0, 16)));
$contentnode->appendChild($doc->createTextNode(iconv("GBK", "UTF-8", cutStr($rs_a[$i]['content'], 10))));
$resultnode->appendChild($doc->createTextNode($rs_a[$i]['result']));
}
}
echo $doc->saveXML();
exit;
}
if ($_GET['action'] == "add_default_data") {
require_once "../Framework/uploadFile.php";
uploadFile();
$nextcontent = $_POST["nextcontent"];
$nexttime = $_POST["nexttime"];
$zhuti = $_POST['mainrowid_ID'];
$db->StartTrans();
$maxid = returnAutoIncrement("id", "workplanmain_detail");
$sql = "insert into workplanmain_detail values({$maxid}," . $_POST['mainrowid'] . ",'" . $_SESSION['LOGIN_USER_ID'] . "','" . date("Y-m-d H:i:s") . "','" . $_POST['begintime'] . "','" . $_POST['endtime'] . "','" . htmlspecialchars($_POST['content']) . "','" . $_POST['result'] . "',";
public function show()
{
global $_FANWE;
$id = (int) $_FANWE['request']['id'];
if (!$id) {
exit;
}
$album_url = FU('album/show', array('id' => $id));
$album = FS("Album")->getAlbumById($id);
$is_follow_album = FS('album')->getIsFollow($id, $_FANWE['uid']);
if (empty($album)) {
fHeader("location: " . FU('album'));
}
$home_uid = $album['uid'];
$home_user = FS("User")->getUserById($home_uid);
$is_show_follow = false;
if ($home_uid != $_FANWE['uid']) {
if (!FS('User')->getIsFollowUId($home_uid)) {
$is_show_follow = true;
}
}
$is_manage_album = false;
if ($_FANWE['uid'] == $album['uid']) {
$is_manage_album = true;
}
$sql = 'SELECT * FROM ' . FDB::table('album') . '
WHERE uid = ' . $home_uid . ' and id <> ' . $id . ' ORDER BY id DESC ';
$res = FDB::query($sql);
while ($data = FDB::fetch($res)) {
$data['imgs'] = array();
if (!empty($data['cache_data'])) {
$cache_data = unserialize($data['cache_data']);
$data['imgs'] = $cache_data['imgs'];
unset($data['cache_data']);
}
$data['img_count'] = count($data['imgs']);
$data['url'] = FU('album/show', array('id' => $data['id']));
$album_list[] = $data;
}
$page_num = intval($_FANWE['setting']['share_self_page']) ? intval($_FANWE['setting']['share_self_page']) : 30;
$is_root = false;
$img_width = 190;
$limit = $page_num;
$share_ids = array();
$res = FDB::query('SELECT share_id FROM ' . FDB::table('album_share') . '
WHERE album_id = ' . $id . ' ORDER BY share_id DESC ');
while ($data = FDB::fetch($res)) {
$share_ids[] = $data['share_id'];
}
$share_ids = implode(',', $share_ids);
if ($share_ids) {
$sql = 'SELECT *
FROM ' . FDB::table("share") . '
WHERE share_data <> ' . " 'default' and share_id IN (" . $share_ids . ") \r\n\t\t\tORDER BY share_id DESC LIMIT " . $limit;
$share_list = FDB::fetchAll($sql);
}
if ($share_list) {
$share_list = FS('Share')->getShareDetailList($share_list, false, false, false, true, 2);
$list = array();
$current_user = array();
$current_user['u_url'] = FU('u/index', array('uid' => $_FANWE['uid']));
$current_user['avt'] = avatar($_FANWE['uid'], 's', $is_src = 1);
$i = 0;
foreach ($share_list as $k => $v) {
$list[$i] = $v;
$img_info = FDB::fetchFirst("select img,img_width,img_height,is_animate,video from " . FDB::table("share_photo") . " where share_id = " . $v['share_id'] . " and img <> '' ");
if ($img_info['is_animate']) {
$img = $img_info['img'];
} else {
$img = getImgName($img_info['img'], $img_width, 999);
}
$is_video = 0;
$vedio_url = '';
if (!empty($img_info['video'])) {
$is_video = 1;
$vedio_url = $img_info['video'];
}
$list[$i]['is_video'] = $is_video;
$list[$i]['video'] = $vedio_url;
$list[$i]['share_img'] = $img;
$list[$i]['avt'] = avatar($v['uid'], 's', $is_src = 1);
$list[$i]['height'] = $img_info['img_height'] * ($img_width / $img_info['img_width']);
/*获取play图标的位置*/
$list[$i]['video_style_top'] = ($list[$i]['height'] - 33) / 2;
$list[$i]['video_style_right'] = (254 - 33) / 2;
$list[$i]['width'] = $img_width;
$list[$i]['share_img_org'] = $img_info['img'];
$parent_id = FDB::resultFirst("select parent_id from " . FDB::table("share") . " where share_id = " . $v['share_id']);
if ($parent_id == 0) {
$list[$i]['isOriginal'] = 1;
} else {
$list[$i]['isOriginal'] = 0;
}
$list[$i]['likeStatus'] = FS('Share')->getIsCollectByUid($v['share_id'], $_FANWE['uid']) ? 1 : 0;
$list[$i]['isMe'] = $v['uid'] == $_FANWE['uid'] ? 1 : 0;
//分享评论
$share_comments = FS('Share')->getShareCommentList($v['share_id'], '0,2');
if ($share_comments) {
$share_comments_data = array();
$idxj = 0;
foreach ($share_comments as $vv) {
$share_comments_data[$idxj]['comment_id'] = $vv['comment_id'];
$share_comments_data[$idxj]['parent_id'] = $vv['parent_id'];
$share_comments_data[$idxj]['user_url'] = FU('u/index', array('uid' => $vv['user']['uid']));
$share_comments_data[$idxj]['user_name'] = $vv['user']['user_name'];
$share_comments_data[$idxj]['avt'] = avatar($vv['uid'], 's', $is_src = 1);
$share_comments_data[$idxj]['comment'] = cutStr($vv['content'], 20);
$idxj++;
}
$list[$i]['comments'] = $share_comments_data;
}
$list[$i]['share_url'] = FU('note/index', array('sid' => $v['share_id']));
$list[$i]['u_url'] = FU('u/index', array('uid' => $v['uid']));
$list[$i]['relay_count'] = FDB::resultFirst("select relay_count from " . FDB::table("share") . " where share_id = " . $v['share_id']);
$album_sql = "select a.id,a.title from " . FDB::table('album_share') . " as ah left join " . FDB::table('album') . " as a on ah.album_id = a.id where ah.share_id = " . $v['share_id'];
$album = FDB::fetchFirst($album_sql);
if ($album) {
$list[$i]['album_title'] = $album['title'];
$list[$i]['is_album'] = 1;
$list[$i]['album_url'] = FU("album/show", array('id' => $album['id']));
} else {
$list[$i]['album_title'] = "";
$list[$i]['is_album'] = 0;
$list[$i]['album_url'] = "";
}
$list[$i]['user_name'] = FDB::resultFirst("select user_name from " . FDB::table('user') . " where uid =" . $v['uid']);
$i++;
}
}
if ($list) {
$share_detail = $list[0];
}
$link_url = $_FANWE['site_url'] . "services/service.php?m=user&a=album_share&width=190&p=2&home_uid=" . $home_uid . "&album_id=" . $id;
$json_url = $_FANWE['site_url'] . "services/service.php?m=user&a=album_share&width=190&home_uid=" . $home_uid . "&album_id=" . $id;
include template('page/album/album_show');
display();
}
/**
* 当前模板用到的相关函数
*/
function getHotCate()
{
global $_FANWE;
$args = array();
FanweService::instance()->cache->loadCache('albums');
$category_id = urldecode($_FANWE['request']['hot']);
$tag = $_FANWE['request']['tag'];
$sort = $_FANWE['request']['sort'];
$link_url = $_FANWE['site_url'] . "services/service.php?m=index&a=share&width=190&p=2";
$json_url = $_FANWE['site_url'] . "services/service.php?m=index&a=share&width=190";
//判断排序
if ($sort) {
if ($sort == 'hot') {
$link_url .= "&sort=collect_count";
$json_url .= "&sort=collect_count";
}
}
//判断分类
if ($category_id) {
$args['category_id'] = $category_id;
$link_url .= "&cate=" . $category_id;
$json_url .= "&cate=" . $category_id;
}
if ($tag) {
$link_url .= "&tag=" . $tag;
$json_url .= "&tag=" . $tag;
}
$is_cate = false;
$today_time = getTodayTime();
$day7_time = $today_time - 604800;
$img_width = 190;
$cate_id = $category_id;
$sort_field = $_FANWE['request']['sort'];
$page_num = intval($_FANWE['setting']['share_index_page']) ? intval($_FANWE['setting']['share_index_page']) : 30;
$is_cate = false;
if ($cate_id) {
$is_cate = true;
}
if ($is_cate) {
$condition .= " AND als.cid = " . $cate_id;
$join_sql = ' LEFT JOIN ' . FDB::table('album_share') . ' AS als ON als.share_id = s.share_id ';
}
$audit_index = intval($_FANWE['setting']['audit_index']);
if ($audit_index) {
$condition .= " AND s.status =1 ";
}
$page = intval($_REQUEST['p']);
$field = ",(s.create_time > {$day7_time}) AS time_sort ";
$sort = " ";
if ($sort_field == 'hot') {
$sort = " ORDER BY s.collect_count DESC ";
} else {
$sort = " ORDER BY s.share_id DESC ";
}
$sql = 'SELECT DISTINCT(s.share_id),s.uid,s.content,s.collect_count,s.comment_count,s.create_time,s.cache_data ,s.parent_id ' . $field . '
FROM ' . FDB::table('share') . ' AS s ' . $join_sql . ' where s.share_data <> ' . " 'default' " . $condition . $sort . ' LIMIT ' . $page_num;
$is_next = 1;
$share_list = FDB::fetchAll($sql);
$scale = 1;
if ($share_list) {
$share_list = FS('Share')->getShareDetailList($share_list, false, false, false, true, 2);
$list = array();
$current_user = array();
$current_user['u_url'] = FU('u/index', array('uid' => $_FANWE['uid']));
$current_user['avt'] = avatar($_FANWE['uid'], 's', $is_src = 1);
$i = 0;
foreach ($share_list as $k => $v) {
$list[$i] = $v;
$img = FDB::fetchFirst("select img,img_height,img_width,is_animate,video from " . FDB::table("share_photo") . " where share_id = " . $v['share_id'] . " and img <> '' ");
if ($img['is_animate'] == 1) {
$img_url = $img['img'];
} else {
$img_url = getImgName($img['img'], $img_width, 999, 2, true);
}
$is_video = 0;
if (!empty($img['video'])) {
$is_video = 1;
$vedio_url = $img['video'];
}
$list[$i]['is_video'] = $is_video;
$list[$i]['video'] = $vedio_url;
//$img_url = getImgName($img['img'],$img_width,999,2,true);
$list[$i]['share_img'] = $img_url;
$list[$i]['height'] = $img['img_height'] * ($img_width / $img['img_width']);
/*获取play图标的位置*/
$list[$i]['video_style_top'] = ($list[$i]['height'] - 33) / 2;
$list[$i]['video_style_right'] = (254 - 33) / 2;
$list[$i]['height'] = round($list[$i]['height'] / $scale);
$list[$i]['is_animate'] = $img['is_animate'];
$list[$i]['width'] = $img_width;
$list[$i]['avt'] = avatar($v['uid'], 's', $is_src = 1);
$parent_id = FDB::resultFirst("select parent_id from " . FDB::table("share") . " where share_id = " . $v['share_id']);
if ($parent_id == 0) {
$list[$i]['isOriginal'] = 1;
} else {
$list[$i]['isOriginal'] = 0;
}
$list[$i]['likeStatus'] = FS('Share')->getIsCollectByUid($v['share_id'], $_FANWE['uid']) ? 1 : 0;
$list[$i]['isMe'] = $v['uid'] == $_FANWE['uid'] ? 1 : 0;
$list[$i]['is_relay'] = $v['is_relay'];
//分享评论
$share_comments = FS('Share')->getShareCommentList($v['share_id'], '0,2');
if ($share_comments) {
$share_comments_data = array();
$idxj = 0;
foreach ($share_comments as $vv) {
$share_comments_data[$idxj]['comment_id'] = $vv['comment_id'];
$share_comments_data[$idxj]['parent_id'] = $vv['parent_id'];
$share_comments_data[$idxj]['user_url'] = FU('u/album', array('uid' => $vv['user']['uid']));
$share_comments_data[$idxj]['user_name'] = $vv['user']['user_name'];
$share_comments_data[$idxj]['avt'] = avatar($vv['uid'], 's', $is_src = 1);
$share_comments_data[$idxj]['comment'] = cutStr($vv['content'], 20);
$idxj++;
}
$list[$i]['comments'] = $share_comments_data;
}
$list[$i]['share_url'] = FU('note/index', array('sid' => $v['share_id']));
$list[$i]['u_url'] = FU('u/album', array('uid' => $v['uid']));
$list[$i]['relay_count'] = FDB::resultFirst("select relay_count from " . FDB::table("share") . " where share_id = " . $v['share_id']);
$album_sql = "select a.id,a.title from " . FDB::table('album_share') . " as ah left join " . FDB::table('album') . " as a on ah.album_id = a.id where ah.share_id = " . $v['share_id'];
$album = FDB::fetchFirst($album_sql);
if ($album) {
$list[$i]['album_title'] = $album['title'];
$list[$i]['is_album'] = 1;
$list[$i]['album_url'] = FU("album/show", array('id' => $album['id']));
} else {
$list[$i]['album_title'] = "";
$list[$i]['is_album'] = 0;
$list[$i]['album_url'] = "";
}
$list[$i]['user_name'] = FDB::resultFirst("select user_name from " . FDB::table('user') . " where uid =" . $v['uid']);
$i++;
}
$args['list'] = $list;
}
$args['current_user'] = $current_user;
$args['link_url'] = $link_url;
$args['json_url'] = $json_url;
return tplFetch('inc/index/index_cate', $args);
}
$list[$i]['isOriginal'] = 0;
}
$list[$i]['likeStatus'] = FS('Share')->getIsCollectByUid($v['share_id'], $_FANWE['uid']) ? 1 : 0;
$list[$i]['isMe'] = $v['uid'] == $_FANWE['uid'] ? 1 : 0;
//分享评论
$share_comments = FS('Share')->getShareCommentList($v['share_id'], '0,2');
if ($share_comments) {
$share_comments_data = array();
$idxj = 0;
foreach ($share_comments as $vv) {
$share_comments_data[$idxj]['comment_id'] = $vv['comment_id'];
$share_comments_data[$idxj]['parent_id'] = $vv['parent_id'];
$share_comments_data[$idxj]['user_url'] = FU('u/index', array('uid' => $vv['user']['uid']));
$share_comments_data[$idxj]['user_name'] = $vv['user']['user_name'];
$share_comments_data[$idxj]['avt'] = avatar($vv['uid'], 's', $is_src = 1);
$share_comments_data[$idxj]['comment'] = cutStr($vv['content'], 20);
$idxj++;
}
$list[$i]['comments'] = $share_comments_data;
}
$list[$i]['share_url'] = FU('note/index', array('sid' => $v['share_id']));
$list[$i]['u_url'] = FU('u/index', array('uid' => $v['uid']));
$list[$i]['relay_count'] = FDB::resultFirst("select relay_count from " . FDB::table("share") . " where share_id = " . $v['share_id']);
$album_sql = "select a.id,a.title from " . FDB::table('album_share') . " as ah left join " . FDB::table('album') . " as a on ah.album_id = a.id where ah.share_id = " . $v['share_id'];
$album = FDB::fetchFirst($album_sql);
if ($album) {
$list[$i]['album_title'] = $album['title'];
$list[$i]['is_album'] = 1;
$list[$i]['album_url'] = FU("album/show", array('id' => $album['id']));
} else {
$list[$i]['album_title'] = "";
<li>
<?php
if ($user_index > 4) {
break;
}
$user_index++;
echo setTplUserFormat($uid, 1, 0, 's', 32, '', 'r3 icard lazyload', '');
?>
<a href="<?php
echo FU('u/index', array("uid" => $uid));
?>
" target="blank" class="fl"><span class="name" title="<?php
echo $user;
?>
"><?php
echo cutStr($user, 8, '...');
?>
</span></a>
<div class="follow fl">
<?php
$is_follow = FS('User')->getIsFollowUId($uid);
if ($is_follow) {
?>
<a onclick="$.User_Follow(<?php
echo $uid;
?>
,this,CateUpdateUserFollow);" href="javascript:;"><img src="./tpl/images/flow_ok.gif" /></a>
<?php
} else {
?>
<a onclick="$.User_Follow(<?php
$folderid = intval($_GET["folderid"]);
if ($folderid > 0) {
setCookies("lastfolderid", $folderid);
} else {
$folderid = intval(getCookies("lastfolderid"));
}
//preview
setCookies("lastfoldertype", 2);
$pagerlink = "files.php?page={page}&folderid={$folderid}";
$condition = "folderid={$folderid}";
$orderstr = "id desc";
$pager = new Pager();
$pager->init(10, $curPage, $pagerlink);
$attachements = $pager->queryRows($db, "attachments", $condition, "*", $orderstr);
foreach ($attachements as $key => $att) {
$att['shortfilename'] = htmlFilter(cutStr($att['filename'], 12));
$att['filename'] = htmlFilter($att['filename']);
$att['uploadtime'] = getDateStr($att['uploadtime']);
$attachements[$key] = $att;
}
$folderrow = $cache_folders[$folderid];
$folderrow['title'] = htmlFilter($folderrow['title']);
print <<<EOT
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>IMAGE</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/default.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../../getfiles.php?t=js&v={$_SYS['VERSION']}&f=util|ajax|admin"></script>
<body style="background:#fff;">
function newaiinit_value($fields)
{
global $common_html, $html_etc;
global $return_sql_line, $db;
global $_POST, $_GET, $ROWS_PAGE;
global $action_add, $action_model, $mark;
global $read_type, $email_filter, $returnmodel;
global $sms_filter, $nullshow, $columns;
global $primarykey_index;
global $systemorder;
global $tablename;
//print $systemorder;
$systemorderArray = explode(',', $systemorder);
//echo '<br>';//by cwf
//var_dump($systemorderArray);//by cwf ='0:desc'
//var_dump($columns);//by cwf
for ($xx = 0; $xx < sizeof($systemorderArray); $xx++) {
$KeyOrderSqlIndexArray = explode(':', $systemorderArray[$xx]);
//{0,desc} by cwf
$KeyOrderSqlIndexName = $KeyOrderSqlIndexArray[0];
// 0
$KeyOrderSqlIndexOrderDesc = $KeyOrderSqlIndexArray[1];
//desc
$OrderSQLARRAY[$xx] = $columns[$KeyOrderSqlIndexName] . " " . $KeyOrderSqlIndexOrderDesc;
//id desc
}
$OrderSQLText = join(' , ', $OrderSQLARRAY);
//将数组转化成字符串，以，隔开。 =id desc
if (TRIM($OrderSQLARRAY[0]) != "") {
//判断移除特殊字符后的变量是否为空
$systemorderText = $OrderSQLText;
//id desc
} else {
if ($systemorder != "") {
$systemorder1 = "asc";
} else {
$systemorder1 = "desc";
}
$systemorderText = $primarykey_index . " {$systemorder1}";
}
//print $systemorderText;
switch ($db->databaseType) {
case 'mssql':
if (isset($_GET[ordername]) && in_array($_GET[ordername], $columns)) {
if ($_GET[doubletime] % 2 == 0) {
$addsql = "order by [" . $_GET[ordername] . "] asc";
} else {
$addsql = "order by [" . $_GET[ordername] . "] desc";
}
} else {
$addsql = "order by [" . $primarykey_index . "] {$systemorder1}";
}
break;
case 'mysql':
default:
if (isset($_GET[ordername]) && in_array($_GET[ordername], $columns)) {
if ($_GET[doubletime] % 2 == 0) {
$addsql = "order by " . $_GET[ordername] . " asc";
} else {
$addsql = "order by " . $_GET[ordername] . " desc";
}
} else {
$addsql = "order by {$systemorderText}";
}
break;
}
//end switch
//判断是否进行搜索设定
if ($action_add == 'search') {
$SQL = $return_sql_line['uniquekey_sql_search'] . " " . $addsql;
$SQL_NUM = $return_sql_line['uniquekey_sql_num_search'];
$SQL_SUM = $return_sql_line['uniquekey_sql_sum_search'];
} else {
$SQL = $return_sql_line['uniquekey_sql'] . " " . $addsql;
$SQL_NUM = $return_sql_line['uniquekey_sql_num_get'];
$SQL_SUM = $return_sql_line['uniquekey_sql_sum_get'];
}
global $NEWAIINIT_VALUE_SYSTEM;
global $NEWAIINIT_VALUE_SYSTEM_NUM;
global $NEWAIINIT_VALUE_SYSTEM_SUM;
if (strlen($NEWAIINIT_VALUE_SYSTEM) > 10) {
$SQL = $NEWAIINIT_VALUE_SYSTEM;
$SQL_NUM = $NEWAIINIT_VALUE_SYSTEM_NUM;
$SQL_SUM = $NEWAIINIT_VALUE_SYSTEM_SUM;
}
global $SYSTEM_MODE, $SYSTEM_PRINT_SQL;
//print_R($SYSTEM_MODE);
//print_R($return_sql_line);exit;
//print_R($return_sql_line);
if ($SYSTEM_PRINT_SQL) {
$SYSTEM_PRINT_SQL = $SQL;
print_R($SQL);
print "<HR>";
print_R($_GET);
print "<HR>";
//print_R($_SESSION);
//print "<HR>";
}
//print_R($SQL_SUM);EXIT;
global $rc;
$rs =& $db->CacheExecute(5, $SQL_NUM);
$rs_a = $rs->GetArray();
$rc = $rs_a[0]['num'];
if ($rc == '') {
$rc = $rs_a[0]['NUM'];
}
//求和开始 2011-01-31日支持数组
global $UserSumFunction;
//print $UserSumFunction;exit;
$UserSumFunctionArray = explode(',', $UserSumFunction);
$SQL_SUM_原始 = $SQL_SUM;
for ($ixx = 0; $ixx < sizeof($UserSumFunctionArray); $ixx++) {
$UserSumFunctionTEMP = $UserSumFunctionArray[$ixx];
if ($UserSumFunctionTEMP != "") {
$UserSumFunctionTEMP = $columns[$UserSumFunctionTEMP];
//有些字段职员看不到汇总
if ($fields['INPUT_TEXT'][$UserSumFunctionTEMP] == "private") {
$grade = str_split($fields['inputsize'][$UserSumFunctionTEMP]);
if (!in_array($_SESSION['LOGIN_USER_PRIV'], $grade)) {
continue;
}
}
$SQL_SUM = eregi_replace("___", $UserSumFunctionTEMP, $SQL_SUM_原始);
//print $SQL_SUM;//exit;
$rs_sum =& $db->CacheExecute(15, $SQL_SUM);
$sum_number = $rs_sum->fields['sum'];
$UserSumFunctionTEMP = $html_etc[$fields['tablename']][$UserSumFunctionTEMP];
$fields['other']['sum_number'][$UserSumFunctionTEMP] = is_float($sum_number + 0) ? number_format($sum_number, 2, '.', ',') : $sum_number;
}
}
//求和结束
if ($rc == 0 && $nullshow != 1) {
$return = "location='?action=init_" . $mark . "'";
$showtext = $common_html['common_html']['norecord'];
$location_title = 'sunshine_inside';
$action_array_temp = explode('_', $_GET['action']);
if ($action_array_temp[1] == 'customer') {
} else {
if ($email_filter != '') {
$return = isset($returnmodel) ? "location='?action=" . $returnmodel . "'" : "history.back();";
$showtext = $common_html['common_html']["nomail" . $mark];
} else {
if ($sms_filter != '') {
$return = isset($returnmodel) ? "location='?action=" . $returnmodel . "'" : "history.back();";
$showtext = $common_html['common_html']["nosms" . $mark];
} else {
//page_css('system');
//$action_model='add_default:new:n';
//show_new_element($action_model);
}
}
}
print_infor($showtext, 'trip', "{$return}");
exit;
}
if ($ROWS_PAGE <= 0) {
$pagenums = 0;
} else {
$pagenums = ceil($rc / $ROWS_PAGE);
$pageid = $_GET['pageid'];
}
if ($pageid == "" || empty($pageid)) {
$pageid = 1;
}
if ($pageid > $pagenums) {
$pageid = $pagenums;
}
$from = ($pageid - 1) * $ROWS_PAGE;
//print $SQL;print $SQL_NUM;
global $SYSTEM_SQL;
$SYSTEM_SQL = $SQL;
//print_r($SQL);
$rsl = $db->SelectLimit($SQL, $ROWS_PAGE, $from);
$rsa = $rsl->GetArray();
//print_R($rsa[0]);
@($fields['header'] = array_keys($rsa[0]));
$fields['sql']['SQL'] = $SQL;
$fields['sql']['SQL_NUM'] = $SQL_NUM;
$fields['value'] = $rsa;
//print_R(array_keys($rsa[0]));
//print_R($fields['value']);
$counter = 0;
//行数增加
//是否引入图片放大脚本
$ifincludemaginfier = false;
//2011-06-21初始化编辑与删除权限的值
$fields['view_priv'][$counter] = 0;
$fields['edit_priv'][$counter] = 0;
$fields['delete_priv'][$counter] = 0;
$fields['value2'] = $fields['value'];
foreach ($fields['value'] as $list) {
//print_R($list);exit;
//print $tablename;
$i = 0;
//
global $showlistfieldstopedit;
$showlistfieldstopeditArray = explode(',', $showlistfieldstopedit);
global $showlistfieldstopdelete;
$showlistfieldstopdeleteArray = explode(',', $showlistfieldstopdelete);
foreach ($fields['name'] as $list_index) {
$mode = $fields['filter'][$i];
//在此判断是否在专业科科长权限,如果是,则不显示USER_DEFINE字段
if ($_SESSION['SUNSHINE_BANJI_LIST'] != "") {
if ($mode == 'userdefine') {
$mode = 'input';
//设置为INPUT则不会显示增加操作的连接
}
}
//2011-06-20 处理针对行的编辑和删除按钮的禁用权限处理,兼容用户自定义部分的权限控制
//用户权限定义部分
//得到X列Y行的值
$filtervalue = $fields['value'][$counter][$list_index];
$showlistfieldstopeditArrayCheckArray = explode(':', $showlistfieldstopeditArray[$i]);
//print_R($showlistfieldstopeditArrayCheckArray);
if (in_array($filtervalue, $showlistfieldstopeditArrayCheckArray) && $filtervalue != "") {
$fields['edit_priv'][$counter] = 1;
} else {
//兼容旧的返回结果
//$fields['edit_priv'][$counter] = 0;
}
$filtervalue = $fields['value'][$counter][$list_index];
$showlistfieldstopdeleteArrayCheckArray = explode(':', $showlistfieldstopdeleteArray[$i]);
if (in_array($filtervalue, $showlistfieldstopdeleteArrayCheckArray) && $filtervalue != "") {
$fields['delete_priv'][$counter] = 1;
} else {
//兼容旧的返回结果
//$fields['delete_priv'][$counter] = 0;
}
$i++;
//列数增加
//exit($mode);
if (stristr($mode, 'color')) {
$hascolor = true;
} else {
$hascolor = false;
}
switch ($mode) {
case '':
case 'input':
case 'autoincrement':
case 'autoincrementdate':
$filtervalue = $fields['value'][$counter][$list_index];
break;
case 'number':
$filtervalue = "<div align=right>" . $fields['value'][$counter][$list_index] . "</div>";
break;
case 'money':
$filtervalue = "<div align=right>" . number_format(floatval($fields['value'][$counter][$list_index]), 2) . "</div>";
break;
case 'password':
$filtervalue = "******";
break;
case 'password_simple':
$filtervalue = "******";
break;
case 'ajaxinput':
global $sessionkey;
$INPUT_TEXT = $fields['INPUT_TEXT'][$list_index];
if ($INPUT_TEXT == "") {
$INPUT_SIZE = 15;
} else {
$INPUT_SIZE = $INPUT_TEXT;
}
//print $sessionkey;
$filtervalue = $fields['value'][$counter][$list_index];
$AjaxID = $fields['value'][$counter][$primarykey_index];
$openDir = "sessionkey={$sessionkey}&action=jiyun512&tablename={$tablename}&primarykey={$primarykey_index}&IDValue={$AjaxID}&FieldName={$list_index}";
if (is_file("newai_ajax.php")) {
$TempDirPath = "./";
} else {
if (is_file("../../Framework/newai_ajax.php")) {
$TempDirPath = "../../Framework/";
} else {
$TempDirPath = '';
}
}
$openDir = $TempDirPath . "newai_ajax.php?" . base64_encode($openDir);
$filtervalue = "<input type=\"text\" class=\"SmallInput\" size=\"{$INPUT_SIZE}\" value=\"" . $filtervalue . "\"\n\t\t\t\tonBlur=\"GetResult('" . $openDir . "&FieldValue='+this.value);\"\n\t\t\t\tonkeypress=\"GetResult('" . $openDir . "&FieldValue='+this.value);\"\n\t\t\t\tonchange=\"GetResult('" . $openDir . "&FieldValue='+this.value);\"\n\t\t\t\t>";
$filtervalue = $filtervalue;
break;
case 'ajaxinputhidden':
global $sessionkey;
$INPUT_TEXT = $fields['INPUT_TEXT'][$list_index];
if ($INPUT_TEXT == "") {
$INPUT_SIZE = 15;
} else {
$INPUT_SIZE = $INPUT_TEXT;
}
//print $sessionkey;
$filtervalue = $fields['value'][$counter][$list_index];
$AjaxID = $fields['value'][$counter][$primarykey_index];
$openDir = "sessionkey={$sessionkey}&action=jiyun512&tablename={$tablename}&primarykey={$primarykey_index}&IDValue={$AjaxID}&FieldName={$list_index}";
if (is_file("newai_ajax.php")) {
$TempDirPath = "./";
} else {
if (is_file("../../Framework/newai_ajax.php")) {
$TempDirPath = "../../Framework/";
} else {
$TempDirPath = '';
}
}
$openDir = $TempDirPath . "newai_ajax.php?" . base64_encode($openDir);
//$filtervalue="<input type=\"text\" class=\"SmallInput\" size=\"$INPUT_SIZE\" value=\"".$filtervalue."\" onkeyup=\"GetResult('".$openDir."&FieldValue='+this.value);\">";
if (TRIM($filtervalue) != "") {
$SpanInputText = "";
} else {
$SpanInputText = " ";
}
$filtervalue = "<SPAN onclick=\"listTable_edit(this,'{$list_index}',{$AjaxID},'{$sessionkey}','{$tablename}','{$primarykey_index}','{$AjaxID}','{$list_index}','{$openDir}')\">" . $filtervalue . $SpanInputText . "</SPAN>";
break;
case 'ajaxboolean':
global $sessionkey;
$INPUT_TEXT = $fields['INPUT_TEXT'][$list_index];
if ($INPUT_TEXT == "") {
$INPUT_SIZE = 15;
} else {
$INPUT_SIZE = $INPUT_TEXT;
}
//print $sessionkey;
$filtervalue = $fields['value'][$counter][$list_index];
$AjaxID = $fields['value'][$counter][$primarykey_index];
$openDir = "action=jiyun512&tablename={$tablename}&primarykey={$primarykey_index}&IDValue={$AjaxID}&sessionkey={$sessionkey}&FieldName={$list_index}";
if (is_file("newai_ajax.php")) {
$TempDirPath = "./";
} else {
if (is_file("../../newai_ajax.php")) {
$TempDirPath = "../../Framework/";
} else {
$TempDirPath = '';
}
}
if (is_file("images/error.gif")) {
$PicDirPath = "./";
} else {
$PicDirPath = "../../Framework/";
}
$openDir = $TempDirPath . "newai_ajax.php?" . base64_encode($openDir);
//$filtervalue="<input type=\"text\" class=\"SmallInput\" size=\"$INPUT_SIZE\" value=\"".$filtervalue."\" onkeyup=\"GetResult('".$openDir."&FieldValue='+this.value);\">";
if ($filtervalue == "1") {
$filtervalue = "<img onclick=\"listTable_boolean(this,'{$list_index}',{$AjaxID},'{$sessionkey}','{$tablename}','{$primarykey_index}','{$AjaxID}','{$list_index}','{$openDir}')\" src=\"" . $PicDirPath . "images/right.gif\" border=0>";
} else {
$filtervalue = "<img onclick=\"listTable_boolean(this,'{$list_index}',{$AjaxID},'{$sessionkey}','{$tablename}','{$primarykey_index}','{$AjaxID}','{$list_index}','{$openDir}')\" src=\"" . $PicDirPath . "images/error.gif\" border=0>";
}
break;
case 'avatar':
$filtervalue = $fields['value'][$counter][$list_index];
$filepath = "images/avatar/{$filtervalue}.gif";
if (is_file($filepath)) {
$filtervalue = "<img src=\"{$filepath}\" border=0>";
} else {
$filtervalue = "<img src=\"images/avatar/9.gif\" border=0>";
}
break;
case 'textarea':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue = strip_tags(htmlspecialchars_decode($filtervalue));
if (cutStr($filtervalue, 25) != $filtervalue) {
$filtervalue = "<font title='{$filtervalue}'>" . cutStr($filtervalue, 25) . "</font>" . "...";
}
break;
case 'textareabr':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervaluetext = addslashes($filtervalue);
if (cutStr($filtervalue, 25) != $filtervalue) {
$filtervalue = "<font title='{$filtervaluetext}'>" . cutStr($filtervalue, 25) . "</font>" . "...";
}
//if(strlen($filtervalue)>50) $filtervalue=substr($filtervalue,0,50)."...";
break;
case 'readonlytextarea':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervaluetext = addslashes($filtervalue);
if (cutStr($filtervalue, 25) != $filtervalue) {
$filtervalue = "<font title='{$filtervaluetext}'>" . cutStr($filtervalue, 25) . "</font>" . "...";
}
break;
case 'idtoname_user':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'user');
break;
case 'idtoname_course':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'course');
break;
case 'idtoname_YuanXi':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'YuanXi');
break;
case 'idtoname_dept':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'dept');
//$filtervalue=$fields['value'][$counter][$list_index];
break;
case 'colorselect':
$filtervalue = "<div style=\"border:1px double #000000;width:16px;height:16px;background-color:{$filtervalue};overflow:hidden;\"></div>";
break;
case 'date':
case 'date1':
$filtervalue = $fields['value'][$counter][$list_index];
break;
case 'dateonly':
$filtervalue_Array = explode(' ', $fields['value'][$counter][$list_index]);
$filtervalue = $filtervalue_Array[0];
break;
case 'timeonly':
$filtervalue_Array = explode(' ', $fields['value'][$counter][$list_index]);
$filtervalue = $filtervalue_Array[1];
break;
case 'datetime':
$filtervalue = $fields['value'][$counter][$list_index];
break;
case 'url':
$filtervalue = $fields['value'][$counter][$list_index];
$urlfield = $fields['INPUT_TEXT'][$list_index];
$urlid = $fields['inputsize'][$list_index];
if ($filtervalue != '' && $urlid != '') {
$filtervalue = $filtervalue . "-" . $fields['value'][$counter][$urlid];
}
$url = $fields['value'][$counter][$urlfield];
$urlarray = explode("?", $url);
$urlarray[1] = str_ireplace("&", "&", $urlarray[1]);
$url = $urlarray[0] . "?" . base64_encode($urlarray[1]);
$filtervalue = "<a href=\"{$url}\" target=_blank >{$filtervalue}</a>";
break;
case 'mulcheckbox':
$filtervalue = $fields['value'][$counter][$list_index];
$subtablename = $fields['INPUT_TEXT'][$list_index];
$subkey = $fields['inputsize'][$list_index];
$subval = $fields['inputother'][$list_index];
$subcolums = returntablecolumn($subtablename);
$subkey = $subcolums[$subkey];
$subval = $subcolums[$subval];
$fieldValueArray = explode(",", $filtervalue);
array_pop($fieldValueArray);
$fieldValueArrayTEXT = join("','", $fieldValueArray);
$sql = "select {$subval} from {$subtablename} where {$subkey} in ('{$fieldValueArrayTEXT}')";
$rsxx = $db->CacheExecute(5, $sql);
$rsxxA = $rsxx->GetArray();
$fieldValueNameText = '';
for ($iD = 0; $iD < sizeof($rsxxA); $iD++) {
$fieldValueNameText .= $rsxxA[$iD][$subval] . ",";
}
//for($iD=0;$iD<sizeof($fieldValueArray);$iD++) {
// $fieldValueArrayValue = $fieldValueArray[$iD];
// if($fieldValueArrayValue!="")
// $fieldValueNameText .= returntablefield("user","USER_ID",$fieldValueArrayValue,"USER_NAME").",";
//}
$filtervalue = $fieldValueNameText;
break;
case 'file':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filtervalue = "<a href=\"{$filtervalue}\">{$filename}</a>";
break;
case 'singlefile':
case 'picturefile':
$filtervalue = $fields['value'][$counter][$list_index];
$var_value = ereg_replace("&", "&", $filtervalue);
//print $filtervalue;
$parse_url = parse_url($var_value);
$query = $parse_url['query'];
parse_str($query, $output);
//print_R($output);
$attachmentid = $output['attachmentid'];
$attachmentname = $output['attachmentname'];
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filename_newfile = "../../attachment/{$attachmentid}/{$attachmentname}";
$filename_newfile2 = "../../Framework/attachment/{$attachmentid}/{$attachmentname}";
//print $filename_newfile;
//print_R(is_file($filename_newfile));
if (is_file($filename_newfile) || is_file($filename_newfile2)) {
$filtervalue = trim($fields['value'][$counter][$list_index]);
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
//$filtervalue = "<a href='".$filtervalue."'>$filename</a>";
if (!$ifincludemaginfier) {
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>";
print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.magnifier.js\"></script>";
$ifincludemaginfier = true;
}
$image = "<img src='" . $filtervalue . "' height=25 class=\"magnify\" data-magnifyto=\"500\" onmouseover=\"this.style.cursor='pointer';this.style.cursor='hand'\" onmouseout=\"this.style.cursor='default'\">";
//$filtervalue = "<a href='".$filtervalue."'>$image</a>";
$filtervalue = $image;
} else {
$filtervalue = "";
}
break;
case 'tdoafile':
$filtervalue = $fields['value'][$counter][$list_index];
$var_value_array = explode('||', $filtervalue);
$ATTACHMENT_ID = $var_value_array[1];
$ATTACHMENT_NAME = $var_value_array[0];
$ATTACHMENT_ID_ARRAY = explode(",", $ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY = explode("*", $ATTACHMENT_NAME);
$ATTACH_LINK = '';
require_once 'lib/utility_file.php';
$MODULE = attach_sub_dir();
for ($IX = 0; $IX < count($ATTACHMENT_ID_ARRAY); $IX++) {
if ($ATTACHMENT_ID_ARRAY[$IX] != "") {
$ATTACH_IMAGE = image_mimetype($ATTACHMENT_NAME_ARRAY[$IX]);
//print $ATTACH_IMAGE;
$ATTACHMENT_ID = $ATTACHMENT_ID_ARRAY[$IX];
//print_R($ATTACHMENT_ID);
$ATTACHMENT_ID_ARRAY2 = explode('_', $ATTACHMENT_ID);
$YM = $ATTACHMENT_ID_ARRAY2[0];
$ATTACHMENT_ID = $ATTACHMENT_ID_ARRAY2[1];
$SIGN_KEY = "";
//$SIGN_KEY = substr( $ATTACHMENT_ID, strpos( $ATTACHMENT_ID, "." ) + 1 );
//$ATTACHMENT_ID = substr( $ATTACHMENT_ID, 0, strpos( $ATTACHMENT_ID, "." ) );
//print_R($ATTACHMENT_ID);
$ATTACHMENT_ID_ENCODED = attach_id_encode($ATTACHMENT_ID, $ATTACHMENT_NAME_ARRAY[$IX]);
$ATTACH_SIZE = attach_size($ATTACHMENT_ID_ARRAY[$IX], $ATTACHMENT_NAME_ARRAY[$IX], $MODULE);
if (0 < floor($ATTACH_SIZE / 1024 / 1024)) {
$ATTACH_SIZE = round($ATTACH_SIZE / 1024 / 1024, 2) . "MB";
} else {
if (0 < floor($ATTACH_SIZE / 1024)) {
$ATTACH_SIZE = round($ATTACH_SIZE / 1024, 2) . "KB";
} else {
$ATTACH_SIZE .= "字节";
}
}
$ATTACH_LINK .= "<img src=\"../../Framework/images/attach/" . $ATTACH_IMAGE . "\" align=\"absmiddle\"\n\t\t\t\t\t\t\ttitle='" . urldecode($ATTACHMENT_NAME_ARRAY[$IX]) . " 大小:{$ATTACH_SIZE}'><a href=\"../../Enginee/lib/attach.php?MODULE=" . $MODULE . "&YM=" . $YM . "&ATTACHMENT_ID=" . $ATTACHMENT_ID_ENCODED . "&ATTACHMENT_NAME=" . urlencode($ATTACHMENT_NAME_ARRAY[$IX]) . "\" " . ($ATTACH_OFFICE_OPEN_IN_IE ? " target=\"_blank\"" : "") . "\n\t\t\t\t\t\t\ttitle='" . urldecode($ATTACHMENT_NAME_ARRAY[$IX]) . " 大小:{$ATTACH_SIZE}'\n\t\t\t\t\t\t\t>" . urldecode($ATTACHMENT_NAME_ARRAY[$IX]) . "</a>\n";
}
}
$filtervalue = $ATTACH_LINK;
break;
case 'binaryfile':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filtervalue = "<a href=\"{$filtervalue}\">{$filename}</a>";
break;
case 'sex':
$filtervalue = returnsexcolor($fields['value'][$counter][$list_index]);
break;
case 'select_sex':
$filtervalue = returnsexcolor($fields['value'][$counter][$list_index]);
break;
case 'boolean':
$filtervalue = returnboolean_gif($fields['value'][$counter][$list_index]);
break;
case 'checkbox':
$filtervalue = returncheckbox($fields['value'][$counter][$list_index]);
break;
case 'select_sms':
$filtervalue = return_select_filter('select_sms', $fields['value'][$counter][$list_index]);
break;
case 'select_education':
$filtervalue = return_select_filter('select_education', $fields['value'][$counter][$list_index]);
break;
case 'select_marriage':
$filtervalue = return_select_filter('select_marriage', $fields['value'][$counter][$list_index]);
break;
case 'select_politics':
$filtervalue = return_select_filter('select_politics', $fields['value'][$counter][$list_index]);
break;
case 'sms_self_status':
$filtervalue = return_select_filter('sms_self_status', $fields['value'][$counter][$list_index]);
break;
case 'sms_delete_status':
$filtervalue = return_select_filter('sms_delete_status', $fields['value'][$counter][$list_index]);
break;
case 'select_worklog':
$filtervalue = return_select_filter('select_worklog', $fields['value'][$counter][$list_index]);
break;
case 'email_read_status_inbox':
$filtervalue = return_select_filter('email_read_status_inbox', $fields['value'][$counter][$list_index]);
break;
case 'email_read_status_outbox':
$filtervalue = return_select_filter('email_read_status_outbox', $fields['value'][$counter][$list_index]);
break;
case 'email_delete_status_outbox':
$filtervalue = return_select_filter('email_delete_status_outbox', $fields['value'][$counter][$list_index]);
break;
case 'ajax':
$filtervalue = ajaxtablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field'], $counter, $fields['tablename'], $fields['name'][$i - 1], $primarykey_index, $fields['value'][$counter][$primarykey_index]);
break;
case 'select':
$filtervalue = returntablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field']);
break;
case 'radio':
$filtervalue = returntablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field']);
//print_R($fields['select'][$i-1]);;
break;
case 'radiogroup':
$filtervalue = returntablefieldColorFilterGray($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field'], $fields['select'][$i - 1]['groupfield'], $fields['select'][$i - 1]['groupvalue'], '', '', '', $hascolor);
break;
case 'selectcolor':
$filtervalue = returntablefieldColorFilterGray($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field'], '', '', '', $hascolor);
break;
case 'select_input':
$value = $fields['value'][$counter][$list_index];
$filtervalue = returntablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field']);
break;
case 'select_textarea':
$value = $fields['value'][$counter][$list_index];
$filtervalue = idtoname($value, $mode = 'dept');
//returntablefield($fields['select'][$i-1]['tablename'],$fields['select'][$i-1]['value'],$fields['value'][$counter][$list_index],$fields['select'][$i-1]['field']);
break;
case 'checkread':
$index_key = $fields['table']['primarykeyindex'];
$index_key = $fields['value'][$counter][$index_key];
$in_array = checkread_username('checkread', $fields['checkread'][$i - 1]['field'], $index_key);
$in_array = $in_array == 1 ? 1 : 0;
$filtervalue = return_select_filter('notify_read_status', $in_array);
break;
case 'usertonamelist':
$filtervalue = $fields['value'][$counter][$list_index];
$fieldValueArray = explode(",", $filtervalue);
array_pop($fieldValueArray);
$fieldValueArrayTEXT = join("','", $fieldValueArray);
$sql = "select UID,USER_NAME from user where USER_ID in ('{$fieldValueArrayTEXT}') order by USER_NAME";
$rsxx = $db->CacheExecute(5, $sql);
$rsxxA = $rsxx->GetArray();
$fieldValueNameText = '';
for ($iD = 0; $iD < sizeof($rsxxA); $iD++) {
$fieldValueNameText .= "<a target='_blank' href='../Framework/user_newai.php?action=view_default&UID=" . $rsxxA[$iD]['UID'] . "'>" . $rsxxA[$iD]['USER_NAME'] . "</a>,";
}
//for($iD=0;$iD<sizeof($fieldValueArray);$iD++) {
// $fieldValueArrayValue = $fieldValueArray[$iD];
// if($fieldValueArrayValue!="")
// $fieldValueNameText .= returntablefield("user","USER_ID",$fieldValueArrayValue,"USER_NAME").",";
//}
$filtervalue = $fieldValueNameText;
//$filtervalue="<font title='$fieldValueNameText'>".$fieldValueNameText."</font>"."...";
break;
case 'link':
$filtervalue = $fields['value'][$counter][$list_index];
$url = $fields['link'][$i - 1]['url'];
$target = $fields['link'][$i - 1]['target'];
$filename = $fields['link'][$i - 1]['filename'];
$index_key = $fields['table']['primarykeyindex'];
$filtervalue = "<a href='{$filename}?" . base64_encode("action={$url}&{$index_key}=" . $fields['value'][$counter][$index_key]) . "' target={$target}>{$filtervalue}</a>";
//$filtervalue="<a href='$filename?action=$url&$list_index=$filtervalue&$index_key=".$fields['value'][$counter][$index_key]."' target=$target>$filtervalue</a>";
break;
case 'mobile':
$filtervalue = $fields['value'][$counter][$list_index];
$regex = "/1[34568]+\\d{9}/";
preg_match_all($regex, $filtervalue, $phones);
if (strlen($phones[0][0]) == 11) {
$filtervalue = "<a href='../JXC/sms_sendlist_newai.php?" . base64_encode("action=add_default&sendlist=" . $phones[0][0]) . "' target='_blank'>{$filtervalue}</a>";
}
break;
case 'qq':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue = !empty($filtervalue) ? "<a target=\"_blank\" href=\"http://wpa.qq.com/msgrd?v=3&uin=" . $filtervalue . "&site=qq&menu=yes\"><img border=\"0\" src=\"http://wpa.qq.com/pa?p=2:" . $filtervalue . ":45\" title=\"点击这里发消息\" onerror=\"this.src='" . ROOT_DIR . "general/ERP/Framework/images/help3.gif';this.title='此QQ号码可能不存在'\">" . $filtervalue . "</a>" : '';
break;
case 'email':
$filtervalue = $fields['value'][$counter][$list_index];
if ($fields['tablename'] == 'linkman') {
$fromsrc = 'customer';
$linkman = gettablefield($fields['tablename'], 'email', 'rowid', $filtervalue);
} else {
if ($fields['tablename'] == 'supplylinkman') {
$fromsrc = 'supply';
$linkman = gettablefield($fields['tablename'], 'email', 'rowid', $filtervalue);
} else {
$linkman = $filtervalue;
$fromsrc = '';
}
}
$filtervalue = "<a href='../CRM/email_newai.php?" . base64_encode("action=add_default&sendlist=" . $linkman . "&fromsrc=" . $fromsrc) . "' target='_blank' >" . $filtervalue . "</a>";
break;
case 'userdefine':
$filtervalue = $fields['value'][$counter][$list_index];
$functionName = $fields['userdefine'][$i - 1];
$fileName = $functionName . ".php";
$fileName0 = "userdefine/{$fileName}";
$fileName = "../../Enginee/userdefine/{$fileName}";
if (file_exists($fileName0)) {
require_once $fileName0;
$functionName = $functionName . "_Value";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields['value'][$counter][$list_index], $fields, $counter);
}
} else {
if (file_exists($fileName)) {
require_once $fileName;
$functionName = $functionName . "_Value";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields['value'][$counter][$list_index], $fields, $counter);
} else {
print "函数名称[{$functionName}]不存在！";
}
} else {
print "没有相应文件,文件名：{$fileName}";
}
}
//用户权限定义部分
//print_R($functionName."_PRIV");print_R("<BR>");
if (function_exists($functionName . "_PRIV")) {
$NewFunctionNamePriv = $functionName . "_PRIV";
$userdefine_priv_Infor = $NewFunctionNamePriv($fields['value'][$counter][$list_index], $fields, $counter);
if ($userdefine_priv_Infor['view_priv'] == 1) {
$fields['view_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['edit_priv'] == 1) {
$fields['edit_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['delete_priv'] == 1) {
$fields['delete_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['shenhe_priv'] == 1) {
$fields['shenhe_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['flow_priv'] == 1) {
$fields['flow_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['next_priv'] == 1) {
$fields['next_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor == 1) {
$fields['view_priv'][$counter] = 1;
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
$fields['shenhe_priv'][$counter] = 1;
$fields['flow_priv'][$counter] = 1;
$fields['next_priv'][$counter] = 1;
}
//print_R($fields['delete_priv']);
}
break;
}
global $limitEditDelUser;
global $limitEditDelCust;
if ($limitEditDelUser != '') {
//限制上级的编辑和删除权限
if ($_SESSION['limitEditDel'] == '0' && $fields['value2'][$counter][$limitEditDelUser] != $_SESSION['LOGIN_USER_ID'] && $_SESSION['LOGIN_USER_ID'] != 'admin' && $fields['value2'][$counter]['datascope'] != '1') {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
//限制公共客户的编辑和删除权限
if ($fields['value2'][$counter]['datascope'] == '1' && !ifHasRoleUser($fields['value2'][$counter][$limitEditDelUser])) {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
}
if ($limitEditDelCust != '') {
$guanlianSysuser = returntablefield("customer", "rowid", $fields['value2'][$counter][$limitEditDelCust], "sysuser,datascope");
////限制上级的编辑和删除权限
if ($_SESSION['limitEditDel'] == '0' && $guanlianSysuser['sysuser'] != $_SESSION['LOGIN_USER_ID'] && $_SESSION['LOGIN_USER_ID'] != 'admin' && $guanlianSysuser['datascope'] != '1') {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
//限制公共客户的编辑和删除权限
if ($guanlianSysuser['datascope'] == '1' && !ifHasRoleUser($guanlianSysuser['sysuser'])) {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
}
$fields['elementlink'][$counter][$list_index] = $fields['value'][$counter][$list_index];
$fields['value'][$counter][$list_index] = $filtervalue;
}
$counter++;
}
$fields['other']['pageid'] = $pageid;
$fields['other']['pagenums'] = $pagenums;
$fields['other']['rc'] = $rc;
//print_r($fields['delete_priv']);print_r($fields['edit_priv']);exit;
return $fields;
}
$sql = $sql . " order by pay_own desc limit 0 ,{$max_count}";
$rs = $db->Execute($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++) {
$rowid = $rs_a[$i]['rowid'];
$num = $rs_a[$i]['num'];
$supplyname = $rs_a[$i]['supplyname'];
$own = number_format($rs_a[$i]['own'], 2);
$huikuan = number_format($rs_a[$i]['huikuanjine'], 2);
$pay_own = number_format($rs_a[$i]['pay_own'], 2);
if (cutStr($supplyname, 6) != $supplyname) {
$title = $supplyname;
$supplyname = cutStr($supplyname, 6) . "..";
}
$module_body .= "<tr class=\"TableBlock\">\n\t \t\t\t\t\t<td><img src=\"../images/arrow_r.gif\" align=\"absmiddle\"><a href=../../JXC/customer_newai.php?" . base64_encode("action=view_default&ROWID=" . $rs_a[$i]['rowid']) . " target=_blank title='{$title}'>" . $supplyname . "</td>\n\t\t\t\t\t\t<td><a href='../../JXC/v_yingshoukuanhuizong_mingxi.php?" . base64_encode("supplyid={$rowid}") . "' target='_blank'>单数:" . $num . "</a></td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"left\">金额:" . $own . "</td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"left\">回款:" . $huikuan . "</td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"left\">尚欠:" . $pay_own . "</td>\n\t\t\t\t\t </tr>";
//$module_body .= "<li>".$boolen." ".$rs_a[$i]['客户名称']." <font color=green><a href=crm_service_person_newai.php?action=view_default&编号=$编号; title=".$服务编号.">".$rs_a[$i]['服务概述']."</a></font>(<font color=green>[".$rs_a[$i]['服务阶段']."]</font>".$rs_a[$i]['创建时间'].")</li>";
}
for ($i = 0; $i < $count; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
if (count($rs_a) == 0) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"><font color=\"red\">\n\t\t\t\t\t 暂无应收款!</font></td>";
for ($i = 0; $i < $count - 1; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
$module_body .= "</table>";
?>
">《<?php
echo cutStr($share_item['title'], 30, '...');
?>
》</a>
<?php
} elseif ($share_item['type'] == 'album_item') {
?>
加入杂志社<a target="_blank" title="<?php
echo $share_item['title'];
?>
" href="<?php
echo FU('album/show', array("id" => $share_item['rec_id']));
?>
">《<?php
echo cutStr($share_item['title'], 30, '...');
?>
》</a>
<?php
if ($share_item['rec_uid'] > 0) {
?>
收入自 @<?php
echo setTplUserFormat($share_item['rec_uid'], 0, 0, '', 0, '', '', '');
}
}
if ($share_item['is_rec_best'] == 1) {
?>
<img style="vertical-align:-3px; _vertical-align:-2px;" src="./tpl/images/topic_tj.png" />
<?php
}
?>
/**
* 回复信息
* @param int $mlid 信件组编号
* @param int $fuid 发信会员编号
* @param string $fusername 发信会员名称
* @param string $message 信件内容
* @return int
*/
public function replyMsg($mlid, $fuid, $fusername, $message)
{
if (empty($mlid) || empty($fuid) || empty($fusername) || empty($message)) {
return 0;
}
$mlist = FDB::fetchFirst("SELECT * FROM " . FDB::table('user_msg_list') . " WHERE mlid='{$mlid}'");
if (empty($mlist)) {
return MSG_MLIST_NONE_ERROR;
}
if ($mlist['type'] == 1) {
$users = explode('_', $mlist['min_max']);
if ($users[0] == $fuid) {
$tuid = $users[1];
} elseif ($users[1] == $fuid) {
$tuid = $users[0];
} else {
return MSG_PRIVILEGE_NONE_ERROR;
}
}
$members = array();
$query = FDB::query("SELECT * FROM " . FDB::table('user_msg_member') . " WHERE mlid='{$mlid}'");
while ($member = FDB::fetch($query)) {
$members[$member['uid']] = "('{$member['uid']}')";
}
if (!isset($members[$fuid])) {
return MSG_PRIVILEGE_NONE_ERROR;
}
$last_msg = htmlspecialchars(cutStr(clearExpress(trim($message)), 150));
$type = 0;
FDB::query("INSERT INTO " . FDB::table('user_msg_index') . "(mlid) VALUES('{$mlid}')");
$miid = FDB::insertId();
FDB::query("INSERT INTO " . MessageService::getTablaName($mlid) . "(miid,mlid,uid,message,dateline,status) VALUES('{$miid}', '{$mlid}', '{$fuid}', '{$message}', '" . TIME_UTC . "', 0)");
if ($mlist['type'] == 1) {
$msg_config = array('last_uid' => $fuid, 'last_user_name' => $fusername, 'last_msg' => $last_msg);
$msg_config = addslashes(serialize($msg_config));
$result = FDB::query("INSERT INTO " . FDB::table('user_msg_member') . "(mlid, uid, is_new, num, last_update, last_dateline) VALUES('{$mlid}', '{$tuid}', '1', '1', '0', '" . TIME_UTC . "')", 'SILENT');
if (!$result) {
FDB::query("UPDATE " . FDB::table('user_msg_member') . " SET is_new = 1, num = num + 1, last_dateline='" . TIME_UTC . "' WHERE mlid='{$mlid}' AND uid='{$tuid}'");
}
FDB::query("UPDATE " . FDB::table('user_msg_member') . " SET is_new = 0, num = num + 1, last_update='" . TIME_UTC . "', last_dateline='" . TIME_UTC . "' WHERE mlid='{$mlid}' AND uid='{$fuid}'");
} else {
}
FDB::query("UPDATE " . FDB::table('user_msg_list') . " SET msg_config='{$msg_config}' WHERE mlid='{$mlid}'");
$result = FDB::query("INSERT INTO " . FDB::table('user_notice') . "(uid, type, num, create_time) VALUES('{$tuid}',5,1,'" . TIME_UTC . "')", 'SILENT');
if (!$result) {
FDB::query("UPDATE " . FDB::table('user_notice') . " SET num = num + 1, create_time='" . TIME_UTC . "' WHERE uid='{$tuid}' AND type=5");
}
return $miid;
}
public function bindUser($user)
{
if ($user) {
global $_FANWE;
$data = array();
$data['uid'] = $_FANWE['uid'];
$data['type'] = $this->type;
$data['keyid'] = $user['openid'];
unset($user['openid']);
$data['refresh_time'] = 0;
$info = array();
$info['access_token'] = $user['access_token'];
unset($user['access_token']);
$info['user'] = $user;
$data['info'] = addslashes(serialize($info));
$sync = array();
$sync['weibo'] = 1;
$sync['topic'] = 1;
$sync['medal'] = 1;
$data['sync'] = serialize($sync);
if (!empty($user['figureurl_2']) && FS('User')->getAvatar($_FANWE['uid']) == 0) {
$img = copyFile($user['figureurl_2'], "temp", false);
if ($img !== false) {
FS('User')->saveAvatar($_FANWE['uid'], $img['path']);
}
}
FDB::insert('user_bind', $data, false, true);
//绑定后推送网站信息
if ((int) $_FANWE['setting']['bind_push_weibo'] == 1) {
$weibo = array();
$weibo['content'] = sprintf(lang('user', 'bind_weibo_message'), $_FANWE['setting']['site_name'], $_FANWE['setting']['site_description'], $_FANWE['setting']['site_name']);
$weibo['img'] = "";
$weibo['ip'] = $_FANWE['client_ip'];
$weibo['url'] = FU('u/index', array('uid' => $_FANWE['uid']), true);
$weibo['content'] = cutStr($weibo['content'], 277 - strlen($weibo['url']));
$this->sentShare($_FANWE['uid'], $weibo);
}
}
}
}
$customerName = returntablefield("customer", "rowid", $supplyid, "supplyname");
$custUrl = "../../JXC/customer_newai.php?" . base64_encode("action=view_default&ROWID=" . $supplyid);
} else {
if ($outtype == '采购入库') {
$sellinfo = returntablefield("buyplanmain", "billid", $rs_a[$i]['caigoubillid'], "supplyid,zhuti");
$supplyid = $sellinfo['supplyid'];
$zhuti = $sellinfo['zhuti'];
$customerName = returntablefield("supply", "rowid", $supplyid, "supplyname");
$custUrl = "../../JXC/supply_newai.php?" . base64_encode("action=view_default&ROWID=" . $supplyid);
$url = "buyplanmain_newai.php";
}
}
if (cutStr($customerName, 6) != $customerName) {
$title = $customerName;
$customerName = cutStr($customerName, 6) . "..";
}
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t\t<td><img src=\"../images/arrow_r.gif\" align=\"absmiddle\"><a href='{$custUrl}' target=_blank title='{$title}'>" . $customerName . "</td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\"><a href=../../JXC/{$url}?" . base64_encode("action=view_default&billid=" . $rs_a[$i]['caigoubillid']) . " target=_blank>" . $zhuti . "</a></td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\"><a href=../../JXC/stockinmain_newai.php?action=init_default_search&searchfield=billid&searchvalue=" . $billid . " target=_blank>" . $state . "</a></td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\">" . $createtime . "</td>\n\t\t\t\t\t </tr>";
//$module_body .= "<li>".$boolen." ".$rs_a[$i]['客户名称']." <font color=green><a href=crm_service_person_newai.php?action=view_default&编号=$编号; title=".$服务编号.">".$rs_a[$i]['服务概述']."</a></font>(<font color=green>[".$rs_a[$i]['服务阶段']."]</font>".$rs_a[$i]['创建时间'].")</li>";
}
for ($i = 0; $i < $count; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
if (count($rs_a) == 0) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"><font color=\"red\">\n\t\t\t\t\t 暂无待入库记录!</font></td>";
for ($i = 0; $i < $count - 1; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
$module_body .= "</table>";
$max_count = "4";
$module_body = "";
$sql = "select * from message where flag='0' and userid='{$user_id}'";
$sql = $sql . " and (attime is null or attime<now()) order by createtime 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++) {
$id = $rs_a[$i]['id'];
$msgtype = $rs_a[$i]['msgtype'];
$content = $rs_a[$i]['content'];
$title = $content;
if (cutStr($content, 20) != $content) {
$content = cutStr($content, 20) . "..";
} else {
$title = "";
}
$createtime = $rs_a[$i]['createtime'];
$url = $rs_a[$i]['url'];
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t\t<td><img src=\"../images/arrow_r.gif\" align=\"absmiddle\"><a href=../" . $url . " target=_blank " . (strlen($title) > 0 ? "title={$title}" : "") . ">" . $content . "</td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\">" . $msgtype . "</td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\"><font color=red>未读</font></td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\">" . $createtime . "</td>\n\t\t\t\t\t </tr>";
//$module_body .= "<li>".$boolen." ".$rs_a[$i]['客户名称']." <font color=green><a href=crm_service_person_newai.php?action=view_default&编号=$编号; title=".$服务编号.">".$rs_a[$i]['服务概述']."</a></font>(<font color=green>[".$rs_a[$i]['服务阶段']."]</font>".$rs_a[$i]['创建时间'].")</li>";
}
for ($i = 0; $i < $count; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
if (count($rs_a) == 0) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"><font color=\"red\">\n\t\t\t\t\t 暂无消息通知!</font></td>";
for ($i = 0; $i < $count - 1; $i++) {
{$recstr}</div>
EOT;
echo "<form id=\"msgsform\" onsubmit=\"return false;\">";
echo "<table class=\"table_1\" width=\"100%\">";
echo "<tr style=\"font-weight:bold;color:#333333;\"><td class=\"row_0\">" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[1]}px;\">{$_AL['all.select']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[2]}px;padding:0px 10px;\">{$_AL['msg.title']}/{$_AL['msg.user']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[3]}px;\">{$_AL['msg.email']}/{$_AL['msg.contact']}/{$_AL['msg.ip']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[4]}px;padding:0px 10px;\">{$_AL['msg.lastreply']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[5]}px;\"> {$_AL['msg.verify.state']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[6]}px;\">{$_AL['all.control']}</div>" . "";
for ($i = 0; $i < count($rows); $i++) {
$row = $rows[$i];
$row['posttime'] = $row['posttime'] == 0 ? "——" : getDateStr($row['posttime']);
$row['replytime'] = $row['replytime'] == 0 ? "——" : getDateStr($row['replytime']);
$row['name'] = htmlFilter($row['name']);
$row['contact1'] = htmlFilter($row['contact1']);
$row['email'] = htmlFilter($row['email']);
$row['title'] = htmlFilter($row['title']);
$row['replier'] = htmlFilter($row['replier']);
$row['remark'] = cutStr(strip_tags(str_replace(array("\r", "\n"), array('', ''), $row['remark'])), 30);
$row['reply'] = cutStr(strip_tags(str_replace(array("\r", "\n"), array('', ''), $row['reply'])), 30);
$statestr = intval($row['state']) == 0 ? "<a href='msg_ajax.php?action=verify&state=1&id={$row['id']}' class='def_no' title=\"{$_AL['msg.click2verify']}\">{$_AL['msg.notverify']}</a>" : "<a href='msg_ajax.php?action=verify&state=0&id={$row['id']}' class='def_yes' title='{$_AL['msg.click2notverify']}'>{$_AL['msg.hadverify']}</a>";
$checkboxstr = "<input type=\"checkbox\" value=\"{$row['id']}\" name=\"ids[]\" class=\"checkbox_css\" />";
echo "<tr><td class=\"row_0\" style=\"line-height:150%;\">" . "<div class='rowdiv_0' style='width:{$dwidth[1]}px;'>{$checkboxstr}</div>" . "<div class='rowdiv_0' style='width:{$dwidth[2]}px; padding:0px 10px;'>{$row['title']}<br /><b>{$row['name']}</b> <span class='time'>{$row['posttime']}</span></div>" . "<div class='rowdiv_0' style='width:{$dwidth[3]}px;'>{$row['email']}<br />{$row['contact1']}<br /><span class='time'>{$row['ip']}</span></div>" . "<div class='rowdiv_0' style='width:{$dwidth[4]}px; padding:0px 10px;'>{$row['reply']}<br /><b>{$row['replier']}</b> <span class='time'>{$row['replytime']}</span></div>" . "<div class='rowdiv_0' style='width:{$dwidth[5]}px;'>{$statestr}</div>" . "<div class='rowdiv_0' style='width:{$dwidth[6]}px;'><a href=\"admin.php?inc=msg&action=reply&id={$row['id']}\">{$_AL['msg.reply']}</a></div>" . "";
}
echo "</table>";
echo <<<EOT
\t<table width=100%><tr><td><input type="checkbox" onclick="selectAll('msgsform',this.checked)" class="checkbox_css" /> {$_AL['all.selectall']} <select id="postaction" name="postaction">
\t\t<option value="NOTHING">{$_AL['all.chooseaction']}</option>
\t\t<option value="verifyY">{$_AL['msg.action1']}</option>
\t\t<option value="verifyN">{$_AL['msg.action2']}</option>
\t\t<option value="delMsg">{$_AL['msg.action3']}</option>
\t</select>
\t <input type="button" class="button_css" value=" {$_AL['all.submit']} " onclick="ajax_domsgs_yn()" /></td><td><div class='pagestrdiv'>{$pager->getPageStr()}</div></td></tr></table>
\t<div class="div_clear" style="height:10px;"></div>
EOT;
private function getShare()
{
global $_FANWE;
$kwy_word = urldecode($_REQUEST['kw']);
$page_title = preg_replace("/\\[[^\\]]+\\]/i", "", $kwy_word);
$_FANWE['nav_title'] = $page_title . ' - ' . lang('common', 'share');
$_FANWE['seo_description'] = $page_title;
$_FANWE['setting']['site_description'] = '';
$count_result = BookModule::searchInfo();
$count = $count_result['share_count'];
if ($count_result['user_count'] > 0) {
$match_key = segmentToUnicode($kwy_word, '+');
$user_sql = "SELECT u.*, uc.*, us.*, up.* FROM " . FDB::table('user') . " u \r\n\t\t\tLEFT JOIN " . FDB::table('user_count') . " uc USING(uid)\r\n\t\t\tLEFT JOIN " . FDB::table('user_status') . " us USING(uid)\r\n\t\t\tLEFT JOIN " . FDB::table('user_profile') . " up USING(uid)\r\n\t\t\tWHERE match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) limit 10";
$user_list = FDB::fetchAll($user_sql);
if ($user_list) {
foreach ($user_list as $k => $v) {
$is_follow = FS("User")->getIsFollowUId($v['uid']);
$user_list[$k]['is_follow'] = $is_follow;
}
}
}
$page_num = intval($_FANWE['setting']['share_search_page']) ? intval($_FANWE['setting']['share_search_page']) : 30;
$is_root = false;
$img_width = 190;
$kwy_word = urldecode($_FANWE['request']['kw']);
if (!empty($kwy_word)) {
$match_key = segmentToUnicode($kwy_word, '+');
$share_condition = " AND match(share_content_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
}
$limit = $page_num;
$sql = 'SELECT *
FROM ' . FDB::table("share") . '
WHERE share_data <> ' . " 'default' " . $share_condition . "\r\n\t\t\t\tORDER BY share_id DESC LIMIT " . $limit;
$share_list = FDB::fetchAll($sql);
$scale = 1;
if ($share_list) {
$share_list = FS('Share')->getShareDetailList($share_list, false, false, false, true, 2);
$list = array();
$current_user = array();
$current_user['u_url'] = FU('u/index', array('uid' => $_FANWE['uid']));
$current_user['avt'] = avatar($_FANWE['uid'], 's', $is_src = 1);
$i = 0;
foreach ($share_list as $k => $v) {
$list[$i] = $v;
$img = FDB::fetchFirst("select img,img_height,img_width from " . FDB::table("share_photo") . " where share_id = " . $v['share_id'] . " and img <> '' ");
$img_url = getImgName($img['img'], $img_width, 999, 2, true);
$list[$i]['share_img'] = $img_url;
$list[$i]['height'] = $img['img_height'] * ($img_width / $img['img_width']);
$list[$i]['height'] = round($list[$i]['height'] / $scale);
$list[$i]['width'] = $img_width;
$list[$i]['avt'] = avatar($v['uid'], 's', $is_src = 1);
$parent_id = FDB::resultFirst("select parent_id from " . FDB::table("share") . " where share_id = " . $v['share_id']);
if ($parent_id == 0) {
$list[$i]['isOriginal'] = 1;
} else {
$list[$i]['isOriginal'] = 0;
}
$list[$i]['likeStatus'] = FS('Share')->getIsCollectByUid($v['share_id'], $_FANWE['uid']) ? 1 : 0;
$list[$i]['isMe'] = $v['uid'] == $_FANWE['uid'] ? 1 : 0;
//分享评论
$share_comments = FS('Share')->getShareCommentList($v['share_id'], '0,2');
if ($share_comments) {
$share_comments_data = array();
$idxj = 0;
foreach ($share_comments as $vv) {
$share_comments_data[$idxj]['comment_id'] = $vv['comment_id'];
$share_comments_data[$idxj]['parent_id'] = $vv['parent_id'];
$share_comments_data[$idxj]['user_url'] = FU('u/index', array('uid' => $vv['user']['uid']));
$share_comments_data[$idxj]['user_name'] = $vv['user']['user_name'];
$share_comments_data[$idxj]['avt'] = avatar($vv['uid'], 's', $is_src = 1);
$share_comments_data[$idxj]['comment'] = cutStr($vv['content'], 20);
$idxj++;
}
$list[$i]['comments'] = $share_comments_data;
}
$list[$i]['share_url'] = FU('note/index', array('sid' => $v['share_id']));
$list[$i]['u_url'] = FU('u/index', array('uid' => $v['uid']));
$list[$i]['relay_count'] = FDB::resultFirst("select relay_count from " . FDB::table("share") . " where share_id = " . $v['share_id']);
$album_sql = "select a.id,a.title from " . FDB::table('album_share') . " as ah left join " . FDB::table('album') . " as a on ah.album_id = a.id where ah.share_id = " . $v['share_id'];
$album = FDB::fetchFirst($album_sql);
if ($album) {
$list[$i]['album_title'] = $album['title'];
$list[$i]['is_album'] = 1;
$list[$i]['album_url'] = FU("album/show", array('id' => $album['id']));
} else {
$list[$i]['album_title'] = "";
$list[$i]['is_album'] = 0;
$list[$i]['album_url'] = "";
}
$list[$i]['zf_count'] = 10;
$list[$i]['xh_count'] = 20;
$list[$i]['user_name'] = FDB::resultFirst("select user_name from " . FDB::table('user') . " where uid =" . $v['uid']);
$i++;
}
}
$link_url = $_FANWE['site_url'] . "services/service.php?m=search&a=share&width=190&p=2&kwy_word=" . $kwy_word;
$json_url = $_FANWE['site_url'] . "services/service.php?m=search&a=share&width=190&kwy_word=" . $kwy_word;
include template('page/book/book_index');
display();
}
}
$db->CompleteTrans();
//新增邮件通知
if ($_POST['ifemail'] == '1') {
sendEmail($destlist, $_POST['title'], $_POST['content']);
}
//新增短信通知
if ($_POST['ifsms'] == '1') {
$mobiles = '';
for ($i = 0; $i < sizeof($destlist); $i++) {
if ($destlist[$i]['mobile'] != '') {
$mobiles .= $destlist[$i]['mobile'] . ",";
}
}
print "\n<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>\n";
print "<script type=\"text/javascript\" language=\"javascript\">\n\t\t\t\$.post('../Framework/sms_getContents.php?action=send', {\n\t\t\t mobiles:'" . $mobiles . "',\n\t\t\t msg:'" . cutStr("【" . $messagetitle . "】" . $_POST['title'], 70) . "'\n\t\t\t}, function(data) {\t\n\t\t\t});\n\t\t</script>";
}
}
if ($_POST['action'] == "getmessage") {
$sql = "select count(*) as allcount from message where userid='" . $_SESSION['LOGIN_USER_ID'] . "' and flag=0 and (attime is null or now()>attime)";
$rs = $db->Execute($sql);
echo $rs->fields('allcount');
exit;
}
if ($_POST['action'] == "getmessageshow") {
header('Content-Type:text/html;charset=GB2312');
$sql = "select * from message where userid='" . $_SESSION['LOGIN_USER_ID'] . "' and flag=0 and (attime is null or now()>attime)";
if ($_SESSION['popedlist'] != '') {
$sql = $sql . " and id not in (" . $_SESSION['popedlist'] . ")";
}
$sql = $sql . " order by createtime limit 1";
$pager->init(10, $curPage, $pagerlink);
$res = $pager->queryRowsBySQL($db, "SELECT * FROM {$tempsql} ORDER BY posttime DESC", $recordnum);
foreach ($res as $key => $rs) {
switch ($rs['rtype']) {
case 1:
$rs['link'] = $webcore->genUrl("product.php?id={$rs['id']}");
$rs['posttime'] = getDateStr($rs['posttime']);
break;
case 2:
$rs['link'] = $webcore->genUrl("view.php?id={$rs['id']}");
$rs['posttime'] = getDateStr($rs['posttime']);
break;
case 3:
$rs['link'] = $webcore->genUrl("page.php?cid={$rs['id']}");
$rs['posttime'] = "";
break;
}
$rs['type'] = $_SLANG['search.types'][intval($rs['rtype'])];
$rs['title'] = htmlFilter($rs['title']);
$rs['content'] = cutStr(strip_tags($rs['content']), 300);
$rs['title'] = preg_replace('/' . $k . '/i', "<u>{$k}</u>", $rs['title']);
$rs['content'] = preg_replace('/' . $k . '/i', "<u>{$k}</u>", $rs['content']);
$res[$key] = $rs;
}
$headtitle = empty($voterow['title']) ? "" : strip_tags(str_replace(array("\r", "\n"), array('', ''), $voterow['title']));
$headkeywords = $headtitle;
$headdesc = $headtitle;
$_SYS['positionchannel'] = " » {$_SLANG['search.site']}";
require_once './header.php';
require_once getTemplatePath('search.htm');
footer();
function returntablefieldColorFilterGray($tablename, $what, $value, $return, $groupfield = '', $groupvalue = '', $字段名称 = '', $hascolor = false)
{
/*
global $return_sql_line;
$where_sql = $return_sql_line['where_sql'];;
$where_sql_array = explode("where",$where_sql);
if(trim($where_sql_array[1])!=""&&$字段名称!="") {
$ADD_SQL_WHERE_TEXT = " and $return in (select distinct $字段名称 $where_sql)";
}
else {
$ADD_SQL_WHERE_TEXT = "";
}
*/
global $db;
if ($value == '') {
return;
}
if ($groupfield != "" && $groupvalue != "") {
$sql = "select {$return},{$what} from {$tablename} where {$what}='{$value}' and {$groupfield}='{$groupvalue}' {$ADD_SQL_WHERE_TEXT}";
$TEMP_TAR = 1;
} else {
$sql = "select {$return},{$what} from {$tablename} where {$what}='{$value}' {$ADD_SQL_WHERE_TEXT}";
$TEMP_TAR = 0;
}
$return2 = '';
$rs = $db->CacheExecute(15, $sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) == 0 || $rs_a[0][$return] == "") {
//如果返回值为空,则用传入值替代
$return2 = "<font color=gray title='在" . $tablename . "表关联信息中,找不到与本值对应的信息.'>{$value}</font>";
} else {
//进行着色处理
$cutvalue = cutStr($rs_a[0][$return], 13);
$tip = '';
if ($rs_a[0][$return] != $cutvalue) {
$tip = "title='" . $rs_a[0][$return] . "'";
$rs_a[0][$return] = $cutvalue . "..";
}
$colorValue = setColorByName($value);
if ($value == "是") {
$colorValue = "green";
} else {
if ($value == "否") {
$colorValue = "red";
}
}
//print "".strval($value)."";exit;
//print_r($rs_a);exit;
if ($tablename == 'customer') {
$id = $rs_a[0][$what];
$return2 = "<a target='_blank' {$tip} href='../JXC/customer_newai.php?" . base64_encode("action=view_default&ROWID=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'supply') {
$id = $rs_a[0][$what];
$return2 = "<a target='_blank' {$tip} href='../JXC/supply_newai.php?" . base64_encode("action=view_default&ROWID=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'linkman') {
//$id = isset($rs_a[0]['ROWID'])?$rs_a[0]['ROWID']:$value;
if (isset($rs_a[0]['ROWID'])) {
$id = $rs_a[0]['ROWID'];
$qq = returntablefield("linkman", "rowid", $id, "fax");
$return2 = "<a target='_blank' {$tip} href='../JXC/linkman_newai.php?" . base64_encode("action=view_default&ROWID=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} else {
$return2 = $rs_a[0][$return];
}
} elseif ($tablename == 'supplylinkman') {
//$id = isset($rs_a[0]['ROWID'])?$rs_a[0]['ROWID']:$value;
if (isset($rs_a[0]['ROWID'])) {
$id = $rs_a[0]['ROWID'];
} else {
$sql = "select ROWID from {$tablename} where supplyname='" . $value . "'";
$rowid_rs = $db->CacheExecute(15, $sql);
$rowid = $rowid_rs->GetArray();
$id = $rowid[0]['ROWID'];
}
$return2 = "<a target='_blank' {$tip} href='../JXC/supplylinkman_newai.php?" . base64_encode("action=view_default&ROWID=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'user') {
if (isset($rs_a[0]['ROWID'])) {
$id = $rs_a[0]['ROWID'];
} else {
$sql = "select UID from {$tablename} where USER_ID='" . $value . "'";
$rowid_rs = $db->CacheExecute(15, $sql);
$rowid = $rowid_rs->GetArray();
$id = $rowid[0]['UID'];
}
$return2 = "<a target='_blank' {$tip} href='../Framework/user_newai.php?" . base64_encode("action=view_default&UID=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'crm_chance') {
if (isset($rs_a[0]['编号'])) {
$id = $rs_a[0]['编号'];
} else {
$sql = "select 编号 from {$tablename} where 机会主题='" . $value . "'";
$rowid_rs = $db->CacheExecute(15, $sql);
$rowid = $rowid_rs->GetArray();
$id = $rowid[0]['编号'];
}
$return2 = "<a target='_blank' {$tip} href='../JXC/crm_chance_newai.php?" . base64_encode("action=view_default&编号=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'product') {
$return2 = "<a target='_blank' {$tip} href='../JXC/product_newai.php?" . base64_encode("action=view_default&productid=" . $value) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'sellplanmain') {
$id = $rs_a[0]['billid'];
$billtype = returntablefield($tablename, "billid", $id, "billtype");
if ($billtype == 1) {
$urlName = "sellcontract";
} else {
if ($billtype == 2) {
$urlName = "sellplanmain";
} else {
if ($billtype == 3) {
$urlName = "sellonemain";
}
}
}
$return2 = "<a target='_blank' {$tip} href='../JXC/" . $urlName . "_newai.php?" . base64_encode("action=view_default&billid=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'buyplanmain') {
$id = $rs_a[0]['billid'];
$return2 = "<a target='_blank' {$tip} href='../JXC/buyplanmain_newai.php?" . base64_encode("action=view_default&billid=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'stock') {
$id = $rs_a[0]['ROWID'];
$return2 = "<a target='_blank' {$tip} href='../JXC/store_product_newai.php?" . base64_encode("action=init_default&storeid=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'bank') {
$id = $rs_a[0][$what];
$return2 = "<a target='_blank' {$tip} href='../JXC/v_accessbank_newai.php?" . base64_encode("action=init_default&银行账户=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'fahuotype') {
$id = $rs_a[0]['id'];
$return2 = "<a target='_blank' {$tip} href='../JXC/fahuodan_newai.php?" . base64_encode("action=init_default&fahuotype=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'customerproduct') {
$id = $rs_a[0]['ROWID'];
$return2 = "<a target='_blank' {$tip} href='../JXC/customerproduct_newai.php?" . base64_encode("action=view_default&ROWID=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'customer_xuqiu') {
$id = $rs_a[0][$what];
$return2 = "<a target='_blank' {$tip} href='../JXC/customer_xuqiu_newai.php?" . base64_encode("action=view_default&{$what}=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'crm_shenqingbaobei') {
$id = $rs_a[0][$what];
$return2 = "<a target='_blank' {$tip} href='../JXC/crm_shenqingbaobei_newai.php?" . base64_encode("action=view_default&{$what}=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} elseif ($tablename == 'workplanmain') {
$id = $rs_a[0][$what];
$return2 = "<a target='_blank' {$tip} href='../CRM/workplanmain_newai.php?" . base64_encode("action=view_default&{$what}=" . $id) . "'><font color={$colorValue}>" . $rs_a[0][$return] . "</font></a>";
} else {
if ($hascolor) {
$return2 = "<span {$tip}><font color={$colorValue}>" . $rs_a[0][$return] . "</font></span>";
} else {
$return2 = "<span {$tip}>" . $rs_a[0][$return] . "</span>";
}
}
}
//print $return2;print $value;print "<BR>";
//if($value=="50001") exit;
//print $return2;exit;
//if($TEMP_TAR == 1) print_R($return2);
return $return2;
}
$dingdanid = $Store->confirmFaHuo($_POST['billid'], $_POST['fahuodan'], $_POST['shouhuoren'], $_POST['address'], $_POST['tel'], $_POST['mailcode'], $_POST['fahuotype'], floatvalue($_POST['package']), floatvalue($_POST['weight']), $yunfei, $_POST['jiesuantype'], $_POST['beizhu']);
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
if ($_POST[duanxintongzhi] == 'yes') {
//给客户发送提示短信
$sql = "select a.package,a.weight,b.name as fahuotype,a.tel FROM fahuodan a left join fahuotype b on a.fahuotype=b.id WHERE a.billid=" . trim($_POST['billid']);
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$yunfei = $jiesuantype == 2 ? $yunfei . '元' : '0元(包邮)';
$message = "【发货提醒】" . $_SESSION[UNIT_NAME] . date("Y-m-d H:i:s") . "向你单位发货" . $rs_a[0][package] . "件,发货人：" . $_SESSION[LOGIN_USER_NAME] . ',物流公司:' . $rs_a[0][fahuotype];
//$sql = 'INSERT INTO sms_sendlist(msg,nowtime,destcount,userid,destid,result) VALUES("'.$message.'",now(),1,"'.$_SESSION[LOGIN_USER_ID].'","'.$rs_a[0][tel].'","待发")';
//$rs=$db->Execute($sql);
print "\n<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>\n";
print "<script type=\"text/javascript\" language=\"javascript\">\n\t\t\t\$.post('../Framework/sms_getContents.php?action=send', {\n\t\t\t mobiles:'" . $rs_a[0][tel] . "',\n\t\t\t msg:'" . cutStr($message, 70) . "'\n\t\t\t}, function(data) {\t\n\t\t\t});\n\t\t</script>";
}
page_css("确认发货");
if ($return == '') {
$return = FormPageAction("action", "init_default");
}
print_infor("发货单确认成功", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
}
//撤销发货
if ($_GET['action'] == "chexiao") {
$Store = new Store($db);
$CaiWu = new CaiWu($db);
$db->StartTrans();
public function run()
{
global $_FANWE;
$root = array();
$root['return'] = 1;
if ($_FANWE['uid'] == 0) {
exit;
}
//print_r($_FANWE['requestData']); exit;
$mlid = (int) $_FANWE['requestData']['lid'];
$mid = (int) $_FANWE['requestData']['mid'];
if ($mlid == 0 && $mid == 0) {
exit;
}
if ($mlid > 0) {
$mlist = FS('Message')->getListByMlid($mlid, $_FANWE['uid']);
if (empty($mlist)) {
exit;
}
$act2 = $_FANWE['requestData']['act_2'];
if ($act2 == 'reply') {
$message = trim($_FANWE['requestData']['message']);
if (!empty($message)) {
$message = cutStr($message, 200);
if (FS('Message')->replyMsg($mlid, $_FANWE['uid'], $_FANWE['user_name'], $message) > 0) {
$mlist['num']++;
}
}
}
$root['lid'] = $mlid;
$page = (int) $_FANWE['requestData']['page'];
$page = max(1, $page);
$total = $mlist['num'];
$page_size = PAGE_SIZE;
$page_total = max(1, ceil($total / $page_size));
if ($page > $page_total) {
$page = $page_total;
}
$limit = ($page - 1) * $page_size . "," . $page_size;
$root['page'] = array("page" => $page, "page_total" => $page_total);
$tuser = FS('User')->getUserById($mlist['tuid']);
$tuser['user_avatar'] = FS("Image")->getImageUrl('.' . avatar($tuser['uid'], 'm', 1), 2);
//$root['title'] = "共有{$total}封与{$tuser['user_name']}的交流信件";
$root['title'] = "与{$tuser['user_name']}的交流";
$root['t_name'] = $tuser['user_name'];
$msg_list = FS('Message')->getMsgsByMlid($mlid, $_FANWE['uid'], $limit);
foreach ($msg_list as $msg) {
if ($msg['uid'] == $_FANWE['uid']) {
$user = $_FANWE['user'];
$user['user_name'] = '我';
$msg['tuid'] = $mlist['tuid'];
$msg['tuser_name'] = $tuser['user_name'];
$msg['tuser_avatar'] = $tuser['user_avatar'];
} else {
$user = $tuser;
$msg['tuid'] = $_FANWE['uid'];
$msg['tuser_name'] = '我';
$msg['tuser_avatar'] = $_FANWE['user']['user_avatar'];
}
$msg['content'] = $msg['message'];
$msg['user_name'] = $user['user_name'];
$msg['user_avatar'] = $user['user_avatar'];
m_express(&$msg, $msg['message']);
$root['msg_list'][] = $msg;
}
} elseif ($mid) {
$msg = FS('Message')->getSysMsgByMid($_FANWE['uid'], $mid);
$msg['time'] = getBeforeTimelag($msg['dateline']);
$msg['message'] = str_replace('href="/', 'href="' . $_FANWE['site_url'], $msg['message']);
$root['msg'] = $msg;
}
m_display($root);
}
$odts = $db->row_select("orderdetails", "cartid={$cartid} and langid={$_SYS['langid']}");
if (empty($odts)) {
exit($_SLANG['ajaxpublic.nopro']);
}
$ordertotal = 0;
foreach ($odts as $okey => $odt) {
$ordertotal += $odt['price'] * $odt['pronum'];
}
$order['memberid'] = $lg['memberid'];
$order['ordernum'] = GenOrderNum($lg, $cartid);
$order['name'] = cutStr(strFilter($_POST['name']), 30);
$order['phonenum'] = cutStr(strFilter($_POST['phonenum']), 30);
$order['email'] = cutStr(strFilter($_POST['email']), 30);
$order['address'] = cutStr(strFilter($_POST['address']), 100);
$order['zipcode'] = cutStr(strFilter($_POST['zipcode']), 30);
$order['remark'] = cutStr(strFilter($_POST['remark']), 5000);
$order['createtime'] = time();
$order['total'] = $ordertotal;
$order['langid'] = $_SYS['langid'];
$db->row_insert("orders", $order);
$updateodt['orderid'] = $db->insert_id();
$updateodt['cartid'] = 0;
$db->row_update("orderdetails", $updateodt, "cartid={$cartid}");
}
succeedFlag($order['ordernum']);
} catch (Exception $e) {
echo $e;
}
break;
case "getActiveCode":
$eu = strFilter($_POST["membername"]);
foreach ($hot_events as $hot_event) {
?>
<li>
<a target="_blank" href="<?php
echo $hot_event['url'];
?>
"><img class="hot_pic" width="50" height="50" src="<?php
echo getImgName($hot_event['imgs'][0]['img'], 100, 100, 0);
?>
" /></a>
<div class="hot_title">
<p><a target="_blank" href="<?php
echo $hot_event['url'];
?>
"><?php
echo cutStr($hot_event['title'], 46, '...');
?>
</a></p>
<?php
echo $hot_event['thread_count'];
?>
回应
</div>
</li>
<?php
}
}
?>
</ul>
</div>
<?php
if ($OVER_STATUS == "" || $OVER_STATUS == "1") {
if ($MANAGER_NAME == "") {
$OVER_STATUS1 = "<br><font color='#00AA00'><b>已完成</b></font>";
} else {
$OVER_STATUS1 = "<font color='#00AA00'><b>已完成</b></font>";
}
} else {
if ($OVER_STATUS == "0") {
if ($MANAGER_NAME == "") {
$OVER_STATUS1 = "<br><font color='#FF0000'><b>未完成</b></font>";
} else {
$OVER_STATUS1 = "<font color='#FF0000'><b>未完成</b></font>";
}
}
}
$TITLE = cutStr($CONTENT, 0, 10);
$CAL_TIME = substr($CAL_TIME, 0, -3);
$END_TIME = substr($END_TIME, 11, -3);
}
echo "<head><title>";
echo $TITLE;
echo " </title><meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"></head><body bgcolor=\"#FFFFCC\" topmargin=\"5\"><div class=\"small\">";
echo $CAL_TIME;
echo " - ";
echo $END_TIME;
echo " ";
echo $OVER_STATUS1;
echo " ";
echo $MANAGER_NAME;
echo " <hr>";
echo $CONTENT;
//µ÷ÓÃÔ¶³Ì·þÎñÆ÷ÉÏÃæµÄ³ÌÐòÖ´Ðнâѹ²Ù×÷
if ($_GET['action'] == "ExecRemoteFileServerEXESQL" && $_GET['FileName'] != "" && $RemoteHostName != "") {
$dir = '.';
//ÎļþµØÖ·ËùÔÚ
$key = '../';
//½âѹÎļþĿ¼
print "<table width=100% border=0 align=center ><tr><td wrap width=100%>\n";
$FileName = $_GET['FileName'];
if (file_exists($key . $FileName . ".sql")) {
require_once '../adodb/adodb.inc.php';
require_once '../config.inc.php';
require_once '../setting.inc.php';
$rs = $db->Execute("set names gbk");
$file = @file($key . $FileName . ".sql");
for ($index = 0; $index < count($file); $index++) {
if (cutStr(trim($file[$index]), 2) == '--') {
$file[$index] = '';
}
}
$fileText = join('', $file);
$FileArray = explode(";\r\n", $fileText);
print "<BR>µÚ¶þ²½:Ö´ÐÐSQLÓï¾ä:<BR>";
for ($i = 0; $i < sizeof($FileArray); $i++) {
$sql = TRIM($FileArray[$i]);
//print "<BR>".$sql;
if ($sql == "SET USER PRIV ALL") {
$sql = "select FUNC_ID from TD_OA.sys_function";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$NewText = '';
for ($iX = 0; $iX < sizeof($rs_a); $iX++) {
$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++) {
$id = $rs_a[$i]['id'];
$createman = $rs_a[$i]['createman'];
$zhuti = $rs_a[$i]['zhuti'];
$createtime = $rs_a[$i]['createtime'];
$userinfo = returntablefield("user", "user_id", $createman, "uid,user_name");
$UID = $userinfo['uid'];
$username = $userinfo['user_name'];
if (cutStr($zhuti, 12) != $zhuti) {
$title = $zhuti;
$zhuti = cutStr($zhuti, 12) . "..";
}
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t\t<td><img src=\"../images/arrow_r.gif\" align=\"absmiddle\"><a target='_blank' href='../../Framework/user_newai.php?" . base64_encode("action=view_default&UID=" . $UID) . "' >" . $username . "</a></td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"left\"><a target='_blank' href='../../CRM/workplanmain_newai.php?" . base64_encode("action=view_default&id=" . $id) . "' title='{$title}'>" . $zhuti . "</a></td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\">" . $createtime . "</td>\n\t\t\t\t\t\t<td valign=\"Middle\" align=\"right\"><a href='../../CRM/workplanmain_detail_newai.php?action=add_default&mainrowid=" . $id . "' target='_blank'>执行</a></td>\n\t\t\t\t\t </tr>";
//$module_body .= "<li>".$boolen." ".$rs_a[$i]['客户名称']." <font color=green><a href=crm_service_person_newai.php?action=view_default&编号=$编号; title=".$服务编号.">".$rs_a[$i]['服务概述']."</a></font>(<font color=green>[".$rs_a[$i]['服务阶段']."]</font>".$rs_a[$i]['创建时间'].")</li>";
}
for ($i = 0; $i < $count; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
if (count($rs_a) == 0) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"><font color=\"red\">\n\t\t\t\t\t 暂无计划安排!</font></td>";
for ($i = 0; $i < $count - 1; $i++) {
$module_body .= "<tr class=\"TableBlock\">\n\t\t\t\t\t<td valign=\"Middle\" align=\"left\"> \n\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
$module_body .= "</table>";
