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>";