You are here
自己写的shipingzhongcustom模块 第一部分 有大用
星期二, 2019-04-23 13:46 — adminshiping1
<?php
//取字符串长度
//反正这里是中文算一个 在utf-8的情况下 不管php里有没有mb_strlen函数 都没有问题;
//但是在gbk的情况下 是有问题的
function _abslength($str)
{
if(empty($str)){
return 0;
}
if(function_exists('mb_strlen')){
return mb_strlen($str,'utf-8');
}
else {
preg_match_all("/./u", $str, $ar);
return count($ar[0]);
}
}
//根据ip保存ip所在地
function _saveUserIpAddressByIp(&$baoMingObj, $rowObj)
{
//首先加载根据ip得到地址的文件
include_once 'getaddress.class.php';
$c = new GetAddress();
$baoMingObj->field_wsbm_useripaddress[0]['value'] = $c->GetIpFrom($rowObj->userip);
}
function curlData($url)
{// 初始化一个 cURL 对象
//$url ='http://www.adbxy.com';
$curl = curl_init();
// 设置你需要抓取的URL
curl_setopt($curl, CURLOPT_URL, $url);
// 设置header
curl_setopt($curl, CURLOPT_HEADER, 0);
// 设置cURL 参数，要求结果保存到字符串中还是输出到屏幕上。
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
// 运行cURL，请求网页
$data = curl_exec($curl);
// 关闭URL请求
curl_close($curl);
// 显示获得的数据
$data = iconv('GBK','UTF-8//IGNORE',$data);
return $data;
}
//这个其实是专门为 华东准备的
function _saveWsbm($arr,$wangzhan){
global $user;
$baoMingObj = null;
$baoMingObj = (object)$baoMingObj;
$baoMingObj->uid = $user->uid;
$baoMingObj->type = 'wangshangbaoming';
$baoMingObj->title = trim($arr['title']);
$baoMingObj->field_wsbm_tel[0]['value'] = $arr['tel'];
$baoMingObj->field_wsbm_isyouxiao[0]['value'] = 1;
$baoMingObj->field_wsbm_time[0]['value'] = intval($arr['time']);
$baoMingObj->field_wsbm_flag[0]['value'] = $wangzhan;
$baoMingObj->field_wsbm_fromurl[0]['value'] = 'http://'.$wangzhan.'/......';
$baoMingObj->field_wsbm_leibei[0]['value'] = '报名';
//网上报名地区是华东
$baoMingObj->field_wsbm_diqu[0]['value'] = 'hd';
node_save($baoMingObj);
}
//这个其实是专门为 华东准备的
function _zhuquBaoMingDataFromContent($wangzhan, $url)
{
$data = curlData($url);
preg_match_all('/<tr(.*)>(.*)<\/tr>/isU',$data,$out,PREG_SET_ORDER);
$arrayData = array();
foreach($out as $key=>$value)
{
$rowData = array();
preg_match_all('/<td[\s]*key=\"(.*)\"[\s]*value=\"(.*)\">(.*)<\/td>/isU',$value[2],$out1,PREG_SET_ORDER);
foreach($out1 as $key1=>$value1){
$rowData[$value1[1]]=$value1[2];
if($value1[1]=='time'){
$rowData[$value1[1]]=strtotime($value1[2]);
//好像整天有点问题 加上30秒
$rowData[$value1[1]] = $rowData[$value1[1]]+300;
}
}
//下面两步 把手机 和固定电话 存在一起 都存在 $rowData['tel'] 里面
if(empty($rowData['tel'])){
$rowData['tel']=$rowData['phone'];
}
else if(!empty($rowData['phone']) && !empty($rowData['tel'])){
$rowData['tel']=$rowData['tel'].','.$rowData['phone'];
}
// '3g.hdfzxy.com' 需要实体转汉字
if($wangzhan=='3g.hdfzxy.com'){
$rowData['title'] = mb_convert_encoding($rowData['title'], "UTF-8", "HTML-ENTITIES");
}
$arrayData[]=$rowData;
}
foreach($arrayData as $key=>$value){
$sql = "select n.nid from {node} as n
inner join content_type_wangshangbaoming as typewsbm on n.nid=typewsbm.nid
inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
inner join content_field_wsbm_tel as wsbmtel on n.nid=wsbmtel.nid
where n.type='wangshangbaoming' and (typewsbm.field_wsbm_flag_value='$wangzhan' )
and (wsbmtime.field_wsbm_time_value='{$value['time']}')
and (wsbmtel.field_wsbm_tel_value='{$value['tel']}')";
$nid = db_result(db_query($sql));
//假如不存在$nid时
if(empty($nid)){
//这个其实是专门为 华东准备的
_saveWsbm($value,$wangzhan);
}
}
}
//抓取报名数据 $wangzhanwj表示是外接网站 类型与普通的不一样
function _zhuquBaoMingData($wangzhan,$orwangzhan=array(),$wangzhanwj=false)
{
global $user;
$orlike = '';
if(!empty($orwangzhan))
{
foreach($orwangzhan as $key=>$value)
{
$orlike .= " or field_wsbm_fromurl_value like '%".$value."%' ";
}
}
//下面几行是删除重复的数据 第54行 当重复的数据大于等于2时 就删除
// $sql = "select n.nid as nid,wsbmtime.field_wsbm_time_value,n.title,count(n.nid) as cou from {node} as n
// inner join content_type_wangshangbaoming as typewsbm on n.nid=typewsbm.nid
// inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
// where n.type='wangshangbaoming' and (typewsbm.field_wsbm_flag_value='$wangzhan' ) group by
// wsbmtime.field_wsbm_time_value,n.title
// order by n.nid desc ";
// $firResult=db_query($sql);
// //var_dump($sql);
// while($rowObj = db_fetch_object($firResult)) {
// if($rowObj->cou>=2){
// var_dump($rowObj->nid);
// node_delete($rowObj->nid);
// }
// }
// $sql = "select n.nid from {node} as n " .
// " inner join content_field_wsbm_fromurl as wsbmfromurl on n.nid=wsbmfromurl.nid
// inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
// where n.type='wangshangbaoming' and (wsbmfromurl.field_wsbm_fromurl_value " .
// " like '%%%s%%' ".$orlike." ) order by wsbmtime.field_wsbm_time_value desc limit 0,1";
// $sql = "select n.nid from {node} as n " .
// " inner join content_field_wsbm_fromurl as wsbmfromurl on n.nid=wsbmfromurl.nid
// inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
// where n.type='wangshangbaoming' and ( wsbmfromurl.field_wsbm_fromurl_value " .
// " like '%$wangzhan%' ".$orlike." ) order by wsbmtime.field_wsbm_time_value desc limit 0,1";
$sql = "select n.nid from {node} as n
inner join content_type_wangshangbaoming as typewsbm on n.nid=typewsbm.nid
inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
where n.type='wangshangbaoming' and (typewsbm.field_wsbm_flag_value='$wangzhan' ) order by wsbmtime.field_wsbm_time_value desc limit 0,1";
if($wangzhanwj) {
$sql = "select n.nid from {node} as n " .
" inner join content_field_wsbm_fromurl as wsbmfromurl on n.nid=wsbmfromurl.nid
inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
where n.type='wj_wangshangbaoming'
order by wsbmtime.field_wsbm_time_value desc limit 0,1";
}
//$nid = db_result(db_query($sql,$wangzhan));
$nid = db_result(db_query($sql));
$lastWsbmWangZhanObj = node_load($nid);
//当没有的时候 就置为空
(empty($lastWsbmWangZhanObj) || empty($lastWsbmWangZhanObj->field_wsbm_time[0]['value'])) && $lastWsbmWangZhanObj->field_wsbm_time[0]['value']=0;
//var_dump($sql);
//var_dump($lastWsbmWangZhanObj->field_wsbm_time[0]['value']);
db_set_active($wangzhan);
$sql = "select * from {dede_archives} as arc inner join {dede_wangshangbaomingaddon21} as wangcon on arc.id=wangcon.aid " .
" where arc.arcrank>=-1 and arc.pubdate>%d order by arc.pubdate asc ";//大于等于-1 就是未发布和已发布(已审核) =-2 就是已删除的
$result = db_query($sql,$lastWsbmWangZhanObj->field_wsbm_time[0]['value']);
if($wangzhan == 'wx.4000512126.com'){
}
//var_dump($result);
//var_dump($lastWsbmWangZhanObj->field_wsbm_time[0]['value']);
//$arrBaoMing = array();
//var_dump($sql);
//var_dump($result);
//var_dump($lastWsbmWangZhanObj->field_wsbm_time[0]['value']);
db_set_active('default');
while($rowObj = db_fetch_object($result))
{
//假如正准备要保存的数据 与最后一条的电话相同,姓名相同,且姓名 不是我们公司的 史平忠 赵金梅 朱春雷 何新宇 程邦建 周艳君 王晶晶 朱远美
//我们就不保存
if(($rowObj->tel == $lastWsbmWangZhanObj->field_wsbm_tel[0]['value'])
&& ($rowObj->title == $lastWsbmWangZhanObj->title)
&& ($rowObj->fromurl == $lastWsbmWangZhanObj->field_wsbm_fromurl[0]['value'])
&& ($rowObj->title!='史平忠')
&& ($rowObj->title!='朱春雷')
&& ($rowObj->title!='何新宇')
&& ($rowObj->title!='程邦建')
&& ($rowObj->title!='周艳君')
&& ($rowObj->title!='王晶晶')
&& ($rowObj->title!='朱远美')
){
continue;
}
$rowObjTitle = trim($rowObj->title);
if (empty($rowObjTitle)){
continue;
}
$rowObjFromurl = $rowObj->fromurl;
// if(empty($rowObjFromurl)){
// continue;
// }
if (empty($rowObjFromurl)){
$rowObj->fromurl = 'http://'.$wangzhan.'/unknown';
}
$baoMingObj = null;
$baoMingObj = (object)$baoMingObj;
$baoMingObj->uid = $user->uid;
$baoMingObj->type = 'wangshangbaoming';
if($wangzhanwj){
$baoMingObj->type = 'wj_wangshangbaoming';
}
$baoMingObj->title = $rowObj->title;
$baoMingObj->field_wsbm_sex[0]['value'] = $rowObj->sex;
$baoMingObj->field_wsbm_tel[0]['value'] = $rowObj->tel;
$baoMingObj->field_wsbm_addr[0]['value'] = $rowObj->szdq;
$baoMingObj->field_wsbm_zuanye[0]['value'] = $rowObj->zuauye;
$baoMingObj->field_wzbm_postcode[0]['value'] = $rowObj->postcode;
$baoMingObj->field_wsbm_qq[0]['value'] = $rowObj->qq;
$baoMingObj->field_wsbm_zuigaoxueli[0]['value'] = $rowObj->zuigaoxueli;
$baoMingObj->field_wsbm_liuyan[0]['value'] = $rowObj->liuyan;
$baoMingObj->field_wsbm_fromurl[0]['value'] = $rowObj->fromurl;
$baoMingObj->field_wsbm_formtag[0]['value'] = $rowObj->formtag;
if($wangzhanwj){
$baoMingObj->field_wsbm_fromurl[0]['value'] = strrchr($rowObj->fromurl,'/');
}
$baoMingObj->field_wsbm_zuanyexiao[0]['value'] = $rowObj->zuauyexiao;
$baoMingObj->field_wsbm_email[0]['value'] = $rowObj->email;
$baoMingObj->field_wsbm_isyouxiao[0]['value'] = 1;
$baoMingObj->field_wsbm_time[0]['value'] = $rowObj->pubdate;
$baoMingObj->field_wsbm_yearmonthday[0]['value'] = $rowObj->yearmonthday;
$baoMingObj->field_wsbm_shengfengzhenghao[0]['value'] = $rowObj->shengfenzhenghao;
$baoMingObj->field_wsbm_shoujianrenname[0]['value'] = $rowObj->shoujianren;
$baoMingObj->field_wsbm_sousouyingqing[0]['value'] = $rowObj->sousouyingqing;
$baoMingObj->field_wsbm_guanjianci[0]['value'] = $rowObj->guanjianci;
$baoMingObj->field_wsbm_userip[0]['value'] = $rowObj->userip;
$baoMingObj->field_wsbm_formtag[0]['value'] = $rowObj->formtag;
$baoMingObj->field_wsbm_flag[0]['value'] = $wangzhan;
$baoMingObj->field_wsbm_is_zhengguo[0]['value'] = $rowObj->iszhenggu;
// if($wangzhan=='ubhmyq58dddd.gotoip3.com'){
// $baoMingObj->field_wsbm_wjz[0]['value'] = "外接站";
// }
$baoMingObj->field_wsbm_peixunrenshu[0]['value'] = $rowObj->peixunrenshu;
if(empty($rowObj->leibei)){
$baoMingObj->field_wsbm_leibei[0]['value'] = '报名';
}else{
$baoMingObj->field_wsbm_leibei[0]['value'] = $rowObj->leibei;
}
//假如存在网上报名地区
if(!empty($rowObj->wsbm_diqu)){
$rowObj->wsbm_diqu=='华东' && $rowObj->wsbm_diqu='hd';
$rowObj->wsbm_diqu=='吴中' && $rowObj->wsbm_diqu='wz';
$rowObj->wsbm_diqu=='新区' && $rowObj->wsbm_diqu='xq';
$baoMingObj->field_wsbm_diqu[0]['value'] = $rowObj->wsbm_diqu;
}
else if(stripos($wangzhan,'hdfzxy.') || stripos($wangzhan,'hdkjh.')){
$baoMingObj->field_wsbm_diqu[0]['value'] = 'hd';
}
//下面的if else 是区分 网站属于 新区 还是 吴中的
else if (stripos($wangzhan,'adb.') || stripos($wangzhan,'adbxy.') || stripos($wangzhan,'szadb.')|| stripos($wangzhan,'adbkjh.'))
{
$baoMingObj->field_wsbm_diqu[0]['value'] = 'xq';
}
else {
$baoMingObj->field_wsbm_diqu[0]['value'] = 'wz';
}
_saveUserIpAddressByIp($baoMingObj, $rowObj);
node_save($baoMingObj);
//var_dump($baoMingObj);exit;
}
}
//这个是执行url 最初执行到的步骤
function shipingzhongcustom_init() {
//设置时区
//date_default_timezone_set('Asia/ShangHai');
// if (user_access('administer') && drupal_is_front_page())
// {
// $sql = "select nid from node n where n.type='kefuzongbiaotype' order by nid desc limit 0,1000";
// $result = db_query($sql);
// while($rowObj = db_fetch_object($result)) {
// $nid = $rowObj->nid;
//
// $node = node_load($nid);
//
// var_dump($node->field_gr_zhaojingmeidinjinliang[0]['value']);
// var_dump($node->field_gr_wangjinjindinjinliang[0]['value']);
// var_dump($node->field_kf_wz_dinjinliang[0]['value']);
// echo "<br />--------------ff---------------";
// }
// }
$_GET['q'] = mb_convert_encoding($_GET['q'],'UTF-8','GBK');
$arg0 = arg(0);
$arg1 = arg(1);
$page = $_GET['page'];
if($arg0 == 'listwangshangbaoming')
{
//先是进行ukart086.com 里的数据的抓取
//_zhuquBaoMingData('www.ukart086.com');
//先是进行szfzxx.com 里的数据的抓取
//_zhuquBaoMingData('3g.ukart086.com',array(0=>'wap.ukart086.com',1=>'phone.ukart086.com'));
//先是进行szfzxx.com 里的数据的抓取
_zhuquBaoMingData('www.szfzxx.com',array(0=>'szfzxx.com',1=>'new.szfzxx.com',2=>'wzfz.szfzxx.com',3=>'image.szfzxx.com'));
//先是进行wzfzxx.com 里的数据的抓取
_zhuquBaoMingData('www.wzfzxx.com');
//先是进行4000512126.com 里的数据的抓取
_zhuquBaoMingData('www.4000512126.com',array(0=>'4000512126.com'));
//先是进行3g.szfzxx.com 里的数据的抓取
_zhuquBaoMingData('3g.szfzxx.com',array(0=>'m.szfzxx.com',1=>'wap.szfzxx.com',2=>'3g.4000512126.com'));
//先是进行m.4000512126.com 里的数据的抓取
_zhuquBaoMingData('m.4000512126.com');
//先是进行m.szfzxx.com 里的数据的抓取
_zhuquBaoMingData('m.wzfzxx.com');
_zhuquBaoMingData('www.fluid.org.cn',array(0=>'fluid.org.cn'));
_zhuquBaoMingData('www.kfqd.cn',array(0=>'kfqd.cn'));
_zhuquBaoMingData('www.lyjsj.net.cn',array(0=>'lyjsj.net.cn'));
_zhuquBaoMingData('www.czsdsj.cn',array(0=>'czsdsj.cn'));
_zhuquBaoMingData('www.fzzbxx.cn',array(0=>'fzzbxx.cn'));
_zhuquBaoMingData('www.skjn.cn',array(0=>'skjn.cn'));
_zhuquBaoMingData('www.wzfzxy.com',array(0=>'wzfzxy.com'));
//这两个是asp的网站
_zhuquBaoMingData('www.fzzbxx.com',array(0=>'fzzbxx.com'));
_zhuquBaoMingData('www.66300136.com',array(0=>'66300136.com'));
//先是进行adbxy.com 里的数据的抓取
_zhuquBaoMingData('www.adbxy.com',array(0=>'adbxy.com'));
//先是进行m.adbxy.com 里的数据的抓取
_zhuquBaoMingData('m.adbxy.com',array(0=>'m.adbxy.com',1=>'m.szadb.com',2=>'3g.adbxy.com',3=>'3g.szadb.com',4=>'wap.adbxy.com',5=>'wap.szadb.com'));
//先是进行adbxy.com 里的数据的抓取
//_zhuquBaoMingData('www.szadb.com',array(0=>'szadb.com'));
//先是进行m.adbxy.com 里的数据的抓取
//_zhuquBaoMingData('m.szadb.com');
//吴中框架户电脑站 这里szkjh.szfzxx.com 与 m.szkjh.szfzxx.com 可能有冲突 前加http://
// _zhuquBaoMingData('vip.babycctv.com',array(0=>'http://szfzxx.ufeqa.com',1=>'vip.yqdzw.com',2=>'http://szkjh.szfzxx.com',
// 3=>'http://szfzxx.fuzhoujiaoyu.net',4=>'http://szfzxx.chuzhoujiaoyu.com',
// 5=>'http://szfzxx.albba.net',6=>'http://szfzxx.qwsax.com',7=>'http://szfzxx.edunsx.com',8=>'http://szfzxx.edunsx.com',9=>'http://szfzxx.pouedu.com',
// 10=>'http://www.hodez.com',11=>'http://szfzxx.hodez.com',12=>'http://szfzsj.hodez.com',13=>'http://fzsjxx.hodez.com'));
//吴中框架户电脑站 这里szkjh.szfzxx.com 与 m.szkjh.szfzxx.com 可能有冲突 前加http://
_zhuquBaoMingData('szkjh.szfzxx.com');
//爱丁堡框架户电脑站
_zhuquBaoMingData('adbkjh.adbxy.com');
// _zhuquBaoMingData('adbkjh.adbxy.com',array(0=>'http://adbxy.ufeqa.com',1=>'vip.zmqiy.com',2=>'http://adbkjh.adbxy.com',
// 3=>'http://adbxy.fuzhoujiaoyu.net',4=>'http://adbxy.chuzhoujiaoyu.com'
// ,5=>'http://adbxy.qwsax.com',6=>'http://adbxy.edunsx.com',7=>'http://adbxy.edunsx.com',8=>'http://www.edunsx.com',9=>'http://www.ufeqa.com',10=>'http://adbxy.pouedu.com'));
//吴中框架户wap站 这里 m.szkjh.szfzxx.com 与 szkjh.szfzxx.com 可能有冲突 前加http://
_zhuquBaoMingData('m.szkjh.szfzxx.com');
// _zhuquBaoMingData('m.szkjh.szfzxx.com',array(0=>'http://m.szfzxx.ufeqa.com',1=>'http://m.szkjh.szfzxx.com',
// 2=>'http://m.szfzxx.fuzhoujiaoyu.net',3=>'http://m.szfzxx.chuzhoujiaoyu.com',
// 4=>'http://m.szfzxx.qwsax.com',5=>'http://m.szfzxx.edunsx.com',6=>'http://m.szfzxx.edunsx.com',7=>'http://m.szfzxx.pouedu.com',8=>'http://m.hodez.com'));
//吴中报装学校 新 wzfz.szfzxx.com //已合并到 szfzxx.com
//_zhuquBaoMingData('wzfz.szfzxx.com');
//爱丁堡架户wap站
_zhuquBaoMingData('m.adbkjh.adbxy.com');
// _zhuquBaoMingData('m.adbkjh.adbxy.com',array(0=>'http://m.adbxy.ufeqa.com',1=>'http://m.adbkjh.adbxy.com',
// 2=>'http://m.adbxy.fuzhoujiaoyu.net',3=>'http://m.adbxy.chuzhoujiaoyu.com',
// 4=>'http://m.adbxy.qwsax.com',5=>'http://m.adbxy.edunsx.com',6=>'http://m.adbxy.edunsx.com',7=>'http://m.adbxy.pouedu.com'));
//地面招生pc站
//_zhuquBaoMingData('www.szadb.com',array(0=>'szadb.com'));
//地面招生wap站
//_zhuquBaoMingData('m.szadb.com');
//_zhuquBaoMingData('ubhmyq58dddd.gotoip3.com');
_zhuquBaoMingData('hdkjh.hdfzxy.szfzxx.com');
_zhuquBaoMingData('mhdkjh.hdfzxy.szfzxx.com');
_zhuquBaoMingData('m2.szkjh.szfzxx.com');
_zhuquBaoMingData('wx.4000512126.com');
//抓取学历数据pc
_zhuquBaoMingData('xl.adbxy.com');
//抓取学历数据wap
_zhuquBaoMingData('3g.adbxy.com');
//抓取华东数据
_zhuquBaoMingData('www.vippeixun.com');
//抓取吴中新手机站
_zhuquBaoMingData('wap.4000512126.com');
_zhuquBaoMingDataFromContent('www.hdfzxy.com','http://www.hdfzxy.com/zt/xunpan/productlist.asp');
_zhuquBaoMingDataFromContent('www.fzpxxy.com','http://www.fzpxxy.com/tsx/xunpan/productlist.asp');
_zhuquBaoMingDataFromContent('3g.hdfzxy.com','http://3g.hdfzxy.com/huadong/Admin_Messagelist.asp');
//抓取四季色彩
_zhuquBaoMingData('sjsc.vippeixun.com');
_zhuquBaoMingData('msjsc.vippeixun.com');
//_zhuquBaoMingDataFromContent('www.vippeixun.com','http://www.vippeixun.com/Boss/cn/Sdw_Order_for_zhuaqu.asp');
//_zhuquBaoMingDataFromContent('3g.hdfzxy.com','http://3g.hdfzxy.com/huadong/Admin_Messagelist.asp');
// //0,100 100,200 200,300 300,400 400,500 500,600 600,700
// $sql = "select n.nid as nid,n.title as title,wsbmtime.field_wsbm_time_value as " .
// "field_wsbm_time_value from node as n " .
// "inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
// where n.type='wangshangbaoming' gro up by n.title,wsbmtime.field_wsbm_time_value order " .
// "by wsbmtime.field_wsbm_time_value desc limit 0,4000";
// $result = db_query($sql);
// $count = 0;
// while($rowResult = db_fetch_object($result))
// {
// $count = $count+1;
// //$tempNode = node_load($rowResult->nid);
// echo "<br /><br />----------";
// var_dump($count);
// var_dump($rowResult->nid);var_dump($rowResult->title);var_dump($rowResult->field_wsbm_time_value);
// echo "<br />";
// $sqlSon = "select n.nid as nid,n.title as title,wsbmtime.field_wsbm_time_value as " .
// "field_wsbm_time_value from node as n " .
// "inner join content_field_wsbm_time as wsbmtime on n.nid=wsbmtime.nid
// where n.type='wangshangbaoming' and n.nid!=$rowResult->nid and " .
// "n.title='$rowResult->title' and wsbmtime.field_wsbm_time_value=$rowResult->field_wsbm_time_value " .
// " order by n.nid desc ";
//
// //$oneNode = node_load($rowResult->nid);
// $resultSon = db_query($sqlSon);
// while($rowSonResult = db_fetch_object($resultSon))
// {
// echo(" son result");
// var_dump($rowSonResult->nid);var_dump($rowSonResult->title);var_dump($rowSonResult->field_wsbm_time_value);
// echo "<br />";
// node_delete($rowSonResult->nid);
// }
//
// }
// exit;
// foreach($arr as $key=>$value){
// $title = $value;
// $sql = "select nid,title from node where title='$title' order by created desc limit 0,1 ";
// $nid = db_result(db_query($sql));
// $firstNode = node_load($nid);
// echo "<br /><br />--------------";
// var_dump("first id : ");var_dump($nid);echo "<br />";
// var_dump("first title : ");var_dump($title);
// echo "<br />*************";
// $sqlAll = "select nid,title from node where title='$title'";
// $resultAll = db_query($sqlAll);
// var_dump($sqlAll);echo "<br />";
// while($rowResultAll = db_fetch_object($resultAll))
// {
// $tempNode = node_load($rowResultAll->nid);
//
// if($rowResultAll->nid != $nid && $firstNode->field_wsbm_tel[0]['value'] == $tempNode->field_wsbm_tel[0]['value']){
//
// var_dump($rowResultAll->nid.':');
// //var_dump($firstNode->field_wsbm_tel[0]['value']);
// //var_dump($tempNode->field_wsbm_tel[0]['value']);
// //node_delete($rowResultAll->nid);
// }
// }
// }
//
// exit;
}
if($arg0 == 'listwangshangbaomingzg') {
//整骨新pc站
_zhuquBaoMingData('www.shrszg.com');
//整骨新pc站
_zhuquBaoMingData('wap.shrszg.com');
//整骨新pc站
_zhuquBaoMingData('www.shrszx.com');
//整骨新pc站
_zhuquBaoMingData('wap.shrszx.com');
}
if($arg0 == 'hdlistwangshangbaoming') {
_zhuquBaoMingData('hdkjh.hdfzxy.szfzxx.com');
_zhuquBaoMingData('mhdkjh.hdfzxy.szfzxx.com');
//抓取华东数据
_zhuquBaoMingDataFromContent('www.hdfzxy.com','http://www.hdfzxy.com/zt/xunpan/productlist.asp');
_zhuquBaoMingDataFromContent('www.fzpxxy.com','http://www.fzpxxy.com/tsx/xunpan/productlist.asp');
_zhuquBaoMingDataFromContent('3g.hdfzxy.com','http://3g.hdfzxy.com/huadong/Admin_Messagelist.asp');
}
if($arg0 == 'listwangshangbaomingwj' ){
//外接
//_zhuquBaoMingData('ubhmyq58dddd.gotoip3.com',array(),true);
}
//下面的 是给所有的报名提取的
if(stristr($arg0,'wangshangbaoming')){
//整骨pc站
_zhuquBaoMingData('www.4006055610.com',array(0=>'http://4006055610.kfqd.cn',1=>'www.czsdsj.cn',
2=>'czsdsj.cn',3=>'www.crdesw.com',
4=>'http://tszx.crdesw.com',5=>'4006055610.com'));
//整骨wap站
_zhuquBaoMingData('m.4006055610.com',array(0=>'http://m.4006055610.kfqd.cn',1=>'m.czsdsj.cn',
2=>'m.crdesw.com',3=>'http://m.tszx.crdesw.com'));
//张拓整骨wap站
_zhuquBaoMingData('m.shrszx.com');
//整骨新pc站
_zhuquBaoMingData('www.shrszg.com');
//整骨新pc站
_zhuquBaoMingData('wap.shrszg.com');
//整骨新pc站
_zhuquBaoMingData('www.shrszx.com');
//整骨新pc站
_zhuquBaoMingData('wap.shrszx.com');
}
}
//第一次参数是 getpermissionsbyuser 第二个参数是 用户的名称 (我们这里只用到第二个参数)
function shipingzhongcustom_getpermissionsbyuser_page($getrolebypermission='getpermissionsbyuser',$name='adminshi')
{
$user = user_load(array('name' => check_plain($name)));
$str = '<br />';
if(!empty($name)){
$str .= '<div style="font-size:18px;">'.$name." 所具有的权限</div>";
$str .= '<br />';
}
$two_perms = array();
foreach($user->roles as $key=>$role_name)
{
$perms = array();
$resultPerms = db_query("SELECT p.perm FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid
WHERE r.rid = '%d' ", $key);
if ($row = db_fetch_object($resultPerms)) {
$perms = explode(',', $row->perm);
}
foreach($perms as $key=>$value){
$perms[$key] = trim($value);
}
$two_perms[] = $perms;
}
$final_perms = $two_perms[0];
for($i=1;$i<count($two_perms);$i++){
$final_perms = array_merge($final_perms,$two_perms[$i]);
}
//让值具有唯一性
$final_perms = array_unique($final_perms);
$str .= implode('<br />',$final_perms);
return $str."<div style='color:#f00;font-size:14px;'>admin/getpermissionbyrole/的后面是用户的名称 比如(\"史平忠\")
<br />再比如(\"adminshi\")
</div>";
}
//第一次参数是 getrolebypermission 第二个参数是 权限的名称 (我们这里只用到第二个参数)
function shipingzhongcustom_getpermissionsbyrole_page($getrolebypermission='getpermissionsbyrole',$role_name='客服初级')
{
//根据 like 初步筛选出角色
$result = db_query("SELECT p.perm as perm,r.name as name,p.rid as rid FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid where p.perm like '%%%s%%'",$permission);
$rolesArr = array();
while ($obj = db_fetch_object($result)) {
// $tmpArr['rid'] = $obj->rid;
// $tmpArr['perm'] = $obj->perm;
// $tmpArr['name'] = $obj->name;
// $permiArr[]=$tmpArr;
$rolesArr[$obj->rid]=$obj->name;
}
$rid = db_result(db_query("SELECT rid FROM {role} where name='%s'",$role_name));
$perms = array();
$resultPerms = db_query("SELECT p.perm FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid
WHERE r.rid = '%d' ", $rid);
if ($row = db_fetch_object($resultPerms)) {
$perms = explode(',', $row->perm);
}
foreach($perms as $key=>$value){
$perms[$key] = trim($value);
}
$perm_strs = implode('<br />',$perms);
return $perm_strs."<div style='color:#f00;font-size:14px;'>admin/getpermissionbyrole/的后面是角色的名称 比如(\"客服初级\")
<br />再比如(\"竞价初级\")
</div>";
}
//第一次参数是 getrolesbyuser 第二个参数是 用户的名称 (我们这里只用到第二个参数)
function shipingzhongcustom_getrolesbyuser_page($getrolesbyuser='getrolesbyuser',$name='adminshi')
{
$user = user_load(array('name' => check_plain($name)));
$str = '<br />';
if(!empty($name)){
$str .= '<div style="font-size:18px;">'.$name." 所具有的角色</div>";
$str .= '<br />';
$str .= implode('<br />',$user->roles);
}
return $str."<div style='color:#f00;font-size:14px;'>admin/getrolesbyuser/的后面是用户的名称 比如(\"史平忠\")
<br />再比如(\"adminshi\")
</div>";
}
//第一次参数是 getrolebypermission 第二个参数是 权限的名称 (我们这里只用到第二个参数)
function shipingzhongcustom_getrolebypermission_page($getrolebypermission='getrolebypermission',$permission='view field_xueyuan_qq')
{
//根据 like 初步筛选出角色
$result = db_query("SELECT p.perm as perm,r.name as name,p.rid as rid FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid where p.perm like '%%%s%%'",$permission);
$rolesArr = array();
while ($obj = db_fetch_object($result)) {
// $tmpArr['rid'] = $obj->rid;
// $tmpArr['perm'] = $obj->perm;
// $tmpArr['name'] = $obj->name;
// $permiArr[]=$tmpArr;
$rolesArr[$obj->rid]=$obj->name;
}
//主要的目的是检查一下某角色的所有的permission;;看某个角色的权限里 倒底有没有 传过来的$permission
foreach($rolesArr as $key=>$value)
{
$perms = array();
$resultPerms = db_query("SELECT p.perm FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid
WHERE r.rid = '%d' ", $key);
if ($row = db_fetch_object($resultPerms)) {
$perms = explode(',', $row->perm);
}
foreach($perms as $keySon=>$valueSon){
$perms[$keySon] = trim($valueSon);
}
//如果传来的$permission不在某个角色的 $perms里 ,就剔除掉这个角色
if(!in_array($permission,$perms)){
unset($rolesArr[$key]);
}
}
$rolesStrs = implode('<br />',$rolesArr);
return $rolesStrs."<div style='color:#f00;font-size:14px;'>admin/getrolebypermission/的后面是权限的名称 比如(\"view field_xueyuan_qq\")
<br />再比如(\"edit field_xueyuan_qq\")
</div>";
}
//这个是执行url 最初执行到的步骤
function shipingzhongcustom_menu() {
$items = array();
$items['admin/getrolebypermission'] = array(
'title'=>'根据权限得到拥有这个权限的角色',
'type' => MENU_NORMAL_ITEM,
'page callback'=>'shipingzhongcustom_getrolebypermission_page',
//'page arguments' => array('hello','helloDrupal'),
'page arguments' => array(1,2),
// //它的优先级 大于 url传来的参数我
// //如果要默认值 就放在回调函数的形参上
// //array(1,2)表示只取url前两个参数 array(1)表示只取url第一个参数
'access arguments'=> array('administer')
);
$items['admin/getpermissionsbyrole'] = array(
'title'=>'根据角色得到其所有的权限',
'type' => MENU_NORMAL_ITEM,
'page callback'=>'shipingzhongcustom_getpermissionsbyrole_page',
//'page arguments' => array('hello','helloDrupal'),
'page arguments' => array(1,2),
// //它的优先级 大于 url传来的参数我
// //如果要默认值 就放在回调函数的形参上
// //array(1,2)表示只取url前两个参数 array(1)表示只取url第一个参数
'access arguments'=> array('administer')
);
$items['admin/getrolesbyuser'] = array(
'title'=>'根据用户得到其所有的角色',
'type' => MENU_NORMAL_ITEM,
'page callback'=>'shipingzhongcustom_getrolesbyuser_page',
//'page arguments' => array('hello','helloDrupal'),
'page arguments' => array(1,2),
// //它的优先级 大于 url传来的参数我
// //如果要默认值 就放在回调函数的形参上
// //array(1,2)表示只取url前两个参数 array(1)表示只取url第一个参数
'access arguments'=> array('administer')
);
$items['admin/getpermissionsbyuser'] = array(
'title'=>'根据用户得到其所有的权限',
'type' => MENU_NORMAL_ITEM,
'page callback'=>'shipingzhongcustom_getpermissionsbyuser_page',
//'page arguments' => array('hello','helloDrupal'),
'page arguments' => array(1,2),
// //它的优先级 大于 url传来的参数我
// //如果要默认值 就放在回调函数的形参上
// //array(1,2)表示只取url前两个参数 array(1)表示只取url第一个参数
'access arguments'=> array('administer')
);
$items['admin/viewroleaccess'] = array(
'title'=>'查看角色权限',
'type' => MENU_NORMAL_ITEM,
'page callback'=>'shipingzhongcustom_viewroleaccess_page',
'access arguments'=> array('administer')
);
// $items['helloform'] = array(
// 'title'=>t('hello drupal page form'),
// 'page callback'=>'hello_drupal_form',
// 'page arguments' => array('page callback arguments'),
// 'access arguments'=> array('access hellodrupal blocks')
// );
//
$items['zhuaqutelqq'] = array(
'title' => '抓取手机QQ号码',
'page callback' => 'zhuaquTelAndQqForm',
//'page arguments' => array('zhuqutel_form'),
'access arguments' => array('zhuaqu tel qq'),
'type' => MENU_CALLBACK,
);
$items['user_custom_pager'] = array(
'title' =>'用户自定义分页数量',
'page callback' => 'shipingzhongcustom_user_custom_pager',
'access arguments' => array('access content'),
'type' => MENU_CALLBACK,
);
return $items;
// $items = array();
// $items['createtimezhong'] = array(
// 'title'=>t('create time zhong'),
// 'page callback'=>'createtimezhong',
// //'page arguments' => array('hello','helloDrupal'),
// //'page arguments' => array(1,2),
// //它的优先级 大于 url传来的参数我
// //如果要默认值 就放在回调函数的形参上
// //array(1,2)表示只取url前两个参数 array(1)表示只取url第一个参数
// 'access arguments'=> array('access administration pages')
// );
// $items['helloform'] = array(
// 'title'=>t('hello drupal page form'),
// 'page callback'=>'hello_drupal_form',
// 'page arguments' => array('page callback arguments'),
// 'access arguments'=> array('access hellodrupal blocks')
// );
//return $items;
}
function zhuaquTelAndQqForm(){
return drupal_get_form('zhuqutel_form').'<br /><br />'.drupal_get_form('zhuquqq_form').'<br /><br />'.l('批量删除抓取手机QQ', 'admin/batchdelzhuqutelqq',array('attributes' => array('target'=>'_blank')));
}
function zhuqutel_form()
{
$form['#attributes'] = array('enctype' => "multipart/form-data");
// 文本框 name是文本框的名称
$form['upload'] = array(
'#type' => 'file',
'#title' => '上传excel文件',
'#size' => 500,
'#description' => '这里上传是.xls的文件',
);
$form['leibie'] = array('#type' => 'hidden', '#value' => 'tel');
//提交按钮 //
$form['submit'] = array(
'#type' => 'submit',
'#value' => '抓取手机',
);
$form['cancel'] = array(
'#type' => 'markup',
'#value' => l(t('Cancel'), $_GET['q']),
);
return $form;
}
function zhuquqq_form()
{
$form = zhuqutel_form();
$form['leibie'] = array('#type' => 'hidden', '#value' => 'qq');
$form['submit'] = array(
'#type' => 'submit',
'#value' => '抓取QQ',
);
return $form;
}
//表单函数_validate 验证类似于钩子函数的回调函数
function zhuqutel_form_validate(&$form, &$form_state)
{
// var_dump($form);
// $export = kprint_r($form, TRUE); // $vars - is a variable which you want to print.
// print $export;
//
// $export = kprint_r($form_state, TRUE); // $vars - is a variable which you want to print.
// print $export;
/**
* 用户提交的所有数据在 $form_state['values'] 之中，相当于 $_POST
*/
$field = 'upload';
$directory = file_directory_path().'/zhuaqutelqq';
if (file_check_directory($directory, FILE_CREATE_DIRECTORY, $field)) {
$size_limit = file_upload_max_size();
$validators = array(
'file_validate_extensions' => array('xls'),
'file_validate_size' => array(
array($size_limit),
),
);
if ($file = file_save_upload($field, $validators, $directory)) {
// Set the file's status to permanent, which will prevent Drupal's file
// garbage collection from deleting it.
file_set_status($file, FILE_STATUS_PERMANENT);
// We add our final file object to the form's storage array, so that it gets passed
// through to the form's submit handler, where we can act on it.
$form_state['storage']['upload'] = $file;
}else{
form_set_error('','上传发生错误');
}
}
// form_set_error('',$form_values['name']);
}
function zhuquqq_form_validate(&$form, &$form_state)
{
zhuqutel_form_validate($form, $form_state);
}
function _readExcelFileSaveZhuqu($form,$form_state,$leibie)
{
$filepath = $form_state['storage']['upload']->filepath;
require("sites/all/libraries/PHPExcel/PHPExcel/IOFactory.php");
$filepath = iconv('UTF-8','GBK',$filepath);
// Check prerequisites
if (!file_exists($filepath)) {
exit("not found $filepath \n");
}
//$reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿)
//$PHPExcel = $reader->load($filepath); // 载入excel文件
//$sheet = $PHPExcel->getSheet(0); // 读取第一個工作表
//不用上面的三行代码，有下面的四行代码 ，这样 xls(Excel97-2003工作簿) xlxs(2007工作簿) 两种格式都能够处理了
//drupal7 中 $filepath 的路径为 public:// 开头
//当 xlsx 时,为什么要把这里的 public:// 的路径,就成真正的路径,然后PHPExcel程序才能读取
$filepath = str_replace('public://upload_assets','sites/default/files/upload_assets',$filepath);
$reader = PHPExcel_IOFactory::createReaderForFile($filepath); //设置以Excel5格式(Excel97-2003工作簿)
$PHPExcel = $reader->load($filepath); // 载入excel文件
$sheet = $PHPExcel->getActiveSheet(); //读取第一个工作表
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumm = $sheet->getHighestColumn(); // 取得总列数
/** 循环读取每个单元格的数据 */
$dataset = array();
for ($row = 2; $row <= $highestRow; $row++)
{//行数是以第1行开始
if($leibie == 'tel'){
$sql = "select n.nid as nid from node as n inner join content_field_tel as tel on n.nid=tel.nid
where n.type in ('kefuchat','zhuqutelqq') and tel.field_tel_value='%s'";
$nid = db_result(db_query($sql,trim($sheet->getCell('A'.$row)->getValue())));
if(!empty($nid))
{
continue;
}
$dataset[$row]['field_tel'] = $sheet->getCell('A'.$row)->getValue();
$dataset[$row]['field_shoujiguishudi'] = $sheet->getCell('C'.$row)->getValue();
$dataset[$row]['field_guanjianci'] = $sheet->getCell('J'.$row)->getValue();
$dataset[$row]['field_useripaddress'] = $sheet->getCell('E'.$row)->getValue();
$dataset[$row]['field_fangwe_laiyuan'] = $sheet->getCell('I'.$row)->getValue();
$dataset[$row]['field_visit_url'] = $sheet->getCell('H'.$row)->getValue();
//$dataset[$row]['field_user_visit_time'] = strtotime($sheet->getCell('L'.$row)->getValue());
//$dataset[$row]['field_user_visit_time'] = date("Y-m-d H:i:s",PHPExcel_Shared_Date::ExcelToPHP($sheet->getCell('L'.$row)->getValue()));
date_default_timezone_set('Asia/Chongqing');
$time = strtotime($sheet->getCell('L'.$row)->getValue());
date_default_timezone_set('UTC');
//这里的时间应该就是格林林治时区的时间
$dataset[$row]['field_user_visit_time'] = date("Y-m-d H:i:s",$time);
//drupal_set_message($sheet->getCell('L'.$row)->getValue());
//drupal_set_message($dataset[$row]['field_user_visit_time']);
}
else if($leibie == 'qq'){
$sql = "select n.nid as nid from node as n inner join content_field_xueyuan_qq as qq on n.nid=qq.nid
where n.type in ('kefuchat','zhuqutelqq') and qq.field_xueyuan_qq_value='%s'";
$nid = db_result(db_query($sql,trim($sheet->getCell('A'.$row)->getValue())));
if(!empty($nid))
{
continue;
}
$dataset[$row]['field_xueyuan_qq'] = $sheet->getCell('A'.$row)->getValue();
$dataset[$row]['field_guanjianci'] = $sheet->getCell('I'.$row)->getValue();
$dataset[$row]['field_useripaddress'] = $sheet->getCell('E'.$row)->getValue();
$dataset[$row]['field_fangwe_laiyuan'] = $sheet->getCell('H'.$row)->getValue();
$dataset[$row]['field_visit_url'] = $sheet->getCell('G'.$row)->getValue();
//$dataset[$row]['field_user_visit_time'] = strtotime($sheet->getCell('L'.$row)->getValue());
//$dataset[$row]['field_user_visit_time'] = date("Y-m-d H:i:s",PHPExcel_Shared_Date::ExcelToPHP($sheet->getCell('K'.$row)->getValue()));
date_default_timezone_set('Asia/Chongqing');
$time = strtotime($sheet->getCell('K'.$row)->getValue());
//这里的时间应该就是格林林治时区的时间存进数据库
date_default_timezone_set('UTC');
$dataset[$row]['field_user_visit_time'] = date("Y-m-d H:i:s",$time);
}
}
foreach($dataset as $key=>$value)
{
$zhuqutelqqNode = null;
$zhuqutelqqNode = (object)$zhuqutelqqNode;
$zhuqutelqqNode->uid = 1;
$zhuqutelqqNode->type = 'zhuqutelqq';
$zhuqutelqqNode->title = '抓取手机QQ'.date('YmdHis');
$zhuqutelqqNode->field_tel[0]['value'] = $value['field_tel'];
$zhuqutelqqNode->field_shoujiguishudi[0]['value'] = $value['field_shoujiguishudi'];
$zhuqutelqqNode->field_xueyuan_qq[0]['value'] = $value['field_xueyuan_qq'];
$zhuqutelqqNode->field_guanjianci[0]['value'] = $value['field_guanjianci'];
$zhuqutelqqNode->field_useripaddress[0]['value'] = $value['field_useripaddress'];
$zhuqutelqqNode->field_fangwe_laiyuan[0]['value'] = $value['field_fangwe_laiyuan'];
$zhuqutelqqNode->field_visit_url[0]['value'] = $value['field_visit_url'];
$zhuqutelqqNode->field_user_visit_time[0]['value'] = $value['field_user_visit_time'];
node_save($zhuqutelqqNode);
}
}
//表单函数_submit 提交函数
function zhuqutel_form_submit(&$form, &$form_state)
{
/**
* 用户提交的所有数据在 $form_state['values'] 之中，相当于 $_POST
*/
_readExcelFileSaveZhuqu($form,$form_state, 'tel');
drupal_set_message('导入 抓取手机 成功');
//删除这个文件
//file_delete($filepath);
}
function zhuquqq_form_submit(&$form, &$form_state)
{
_readExcelFileSaveZhuqu($form,$form_state, 'qq');
drupal_set_message('导入 抓取QQ 成功');
//删除这个文件
//file_delete($filepath);
}
function shipingzhongcustom_viewroleaccess_page()
{
$result = db_query("SELECT p.perm,r.name FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid");
$rolePerms = array();
$permRoles = array();
$tmppermRoles = array();
while ($row = db_fetch_object($result)) {
empty($rolePerms[$row->name]) && $rolePerms[$row->name]='';
empty($rolePerms[$row->perm]) && $rolePerms[$row->perm]='';
$rolePerms[$row->name] = $rolePerms[$row->name].','.$row->perm;
$tmppermRoles = array_flip(explode(', ', $row->perm));
array_walk($tmppermRoles, '_setSameValue', $row->name);
//array_merge_recursive() 如果键值相同将把两个值合并在一起，形成一个新的数组，并以原有的键名作为数组名。
$permRoles = array_merge_recursive($permRoles,$tmppermRoles);
}
// $permRoles 里面的元素值 可能是数组 ,把元素弄成字符串
foreach($permRoles as $key=>$value)
{
is_array($value) && $value = implode(', ',$value);
$permRoles[$key] = $value;
}
echo "<br /><br /><br /><style>*{font-size:12px!important;}</style>";
//输出根据角色得到权限
$export = kprint_r($rolePerms, TRUE);
print $export;
//输出根据权限得到角色
$export = kprint_r($permRoles, TRUE);
print $export;
return '';
}
//function createtimezhong()
//{
// $node = null;
// $node=(object)$node;
// $node->type = 'timezongtype';
// $node->uid = 1;
// $node->title = '时间总表';
// $node->field_zong_time[0]['value'] = date('Y-m-d').' 00:00:00';
// $nid = db_result(db_query("select nid from {content_field_zong_time} where field_zong_time_value='%s'",node->field_zong_time[0]['value']));
// //看是否有这个时间总表对象 如果没有的话 就保存
// if(empty($nid))
// {
// node_save($node);
// $node->title = $node->title.' '.$node->nid;
// node_save($node);
// }
// print '创建时间总表'..'成功';
//
//
//}
function shipingzhongcustom_perm() {
//return array('access test001 content');
return array('batch add multi node','batch add bianjiwritearticle','batch add browsernumreport','batch add shoululingreport','access jingjia zong jisuan','access kefu zong jisuan','zhuaqu tel qq');
}
//修改 menu hook 能够批量添加多个节点的权限
function shipingzhongcustom_menu_alter(&$items) {
// Example - disable the page at node/add
//var_dump($items);var_dump("DDDDDDDd");
$items['multi_node_add']['access callback']='user_access';
$items['multi_node_add']['access arguments']=array('batch add multi node');
//$items['user/%user/edit']['access callback'] = 'user_access';
// $items['user/%user/edit']['access arguments'] = array('edit own info');
$items['multi_node_add/bianjiwritearticle?fields=field_wangchi_many,field_artivle_title,field_artivle_url,field_time,field_shoulu,field_baidu_paiming&num=10']['access callback']='user_access';
$items['multi_node_add/bianjiwritearticle?fields=field_wangchi_many,field_artivle_title,field_artivle_url,field_time,field_shoulu,field_baidu_paiming&num=10']['access arguments']=array('batch add bianjiwritearticle');
$items['multi_node_add/browsernumreport?fields=field_wangchi_many,field_yesterday,field_paiming&num=10']['access callback']='user_access';
$items['multi_node_add/browsernumreport?fields=field_wangchi_many,field_yesterday,field_paiming&num=10']['access arguments']=array('batch add browsernumreport');
$items['multi_node_add/shoululingreport?fields=field_wangchi_many,field_yesterday,field_paiming&num=10']['access callback']='user_access';
$items['multi_node_add/shoululingreport?fields=field_wangchi_many,field_yesterday,field_paiming&num=10']['access arguments']=array('batch add shoululingreport');
}
//操作时间总表与三大总表关系
function _opraZongReration($node)
{
switch ($node->type) {
case 'jingjiazongbiaotype':
$nodeTypeColNid = 'field_jingjiazong_nid';
break;
case 'kefuzongbiaotype':
$nodeTypeColNid = 'field_kfzhong_nid';
break;
case 'seozongbiaotype':
$nodeTypeColNid = 'field_seozong_nid';
break;
default:
break;
}
if(!empty($nodeTypeColNid)){
//得到时间总表的id
$sql = "select nid,field_jingjiazong_nid,field_kfzhong_nid,field_seozong_nid from {content_type_timezongtype} where $nodeTypeColNid=%d ";
$result = db_query($sql, $node->nid);
$timeZongTypeRelationObj = db_fetch_object($result); //得到时间id,和三大总表id
$sql = "update {content_type_timezongtype} set $nodeTypeColNid=null where nid=%d "; //更新 时间总表与 三大总表的关系
db_query($sql, $timeZongTypeRelationObj->nid);//好像执行更新 取时间节点并不能立即起效果
//所以下面 排除法 看其它两个是不是为空
switch ( $nodeTypeColNid ) {
case 'field_jingjiazong_nid':
if(empty($timeZongTypeRelationObj->field_kfzhong_nid) && empty($timeZongTypeRelationObj->field_seozong_nid)){
node_delete($timeZongTypeRelationObj->nid);//客服总表为空 且 seo总表为空时删除时间总表
}
break;
case 'field_kfzhong_nid':
if(empty($timeZongTypeRelationObj->field_jingjiazong_nid) && empty($timeZongTypeRelationObj->field_seozong_nid)){
node_delete($timeZongTypeRelationObj->nid);//竞价总表为空 且 seo总表为空时删除时间总表
}
break;
case 'field_seozong_nid':
if(empty($timeZongTypeRelationObj->field_jingjiazong_nid) && empty($timeZongTypeRelationObj->field_kfzhong_nid)){
node_delete($timeZongTypeRelationObj->nid);//竞价总表为空 且 客服总表为空时删除时间总表
}
break;
default:
break;
}
}
}
//在插入前 和插入后执行的动作
function shipingzhongcustom_nodeapi(&$node, $op, $a3 = null , $a4 = null){
$destination = $_GET['destination'];
$destination_url = substr($destination,0,strpos($destination,'?'));
$destination_param = substr(strchr($destination,'?'),1);
parse_str($destination_param);
empty($destination_url) && $destination_url='';
empty($xgz) && $xgz='';
empty($yxwgz) && $yxwgz='';
empty($xgz_kehu) && $xgz_kehu='';
if($node->type=='kefuchat'){
($node->field_suozaixiaoqu[0]['value']=='xq' || $node->field_suozaixiaoqu[0]['value']=='wz') && $is_jyy = true;
($node->field_suozaixiaoqu[0]['value']=='hd') && $is_hd = true;
($op=='insert' && $node->field_suozaixiaoqu[0]['value']=='zgy') && $is_zgy = true;
$max_field_genzong_next_time = $node->field_genzong_next_time[count($node->field_genzong_next_time)-1];
$max_field_genzong_next_time = date('Y-m-d',strtotime($max_field_genzong_next_time)+28800); //8*60*60
//预处理 并且 需跟踪 当预保存的时候 就移除掉 缓存 保存的 row_nids (在template中计算了需跟踪 数量 ) 或者下次跟踪时间是 当前的年月日,时
if($op == 'presave' && (($destination_url=='listkefu' && $xgz=='jyyxgz') || ($max_field_genzong_next_time==date('Y-m-d') && !empty($is_jyy))) ){
//unset($_SESSION['jyyxgz_row_nids']);
cache_clear_all('jyyxgz_row_nids', 'cache', FALSE);
$days = _get_days_hdxgz();
foreach($days as $day){
cache_clear_all('jyyxgz_row_nids_'.$day, 'cache', FALSE);
}
}
if($op == 'presave' && (($destination_url=='listkefu' && $xgz=='hdxgz') || ($max_field_genzong_next_time==date('Y-m-d') && !empty($is_hd)))){
//unset($_SESSION['hd_row_nids']);
cache_clear_all('hd_row_nids', 'cache', FALSE);
$days = _get_days_hdxgz();
foreach($days as $day){
cache_clear_all('hd_row_nids_'.$day, 'cache', FALSE);
}
}
if($op == 'presave' && (($destination_url=='listkefu' && $xgz=='zgxgz') || ($max_field_genzong_next_time==date('Y-m-d') && !empty($is_zgy)))){
//unset($_SESSION['zgy_row_nids']);
cache_clear_all('zgy_row_nids', 'cache', FALSE);
$days = _get_days_hdxgz();
foreach($days as $day){
cache_clear_all('zgy_row_nids_'.$day, 'cache', FALSE);
}
}
//
//预处理 并且 有效且未跟踪 当保存的时候 就移除掉 缓存 保存的 有效且未跟踪yxwgz_genzong_num 数量
//或者 插入的时候 根据所在校区 移除掉 缓存 保存的 有效且未跟踪yxwgz_genzong_num 数量
if(($op == 'presave' && ($destination_url=='listkefu' && $yxwgz=='yxwgzjyy'))||($op=='insert' && !empty($is_jyy)) ){
//unset($_SESSION['jyy_yxwgz_genzong_num']);
cache_clear_all('jyy_yxwgz_genzong_num', 'cache', FALSE);
}
if(($op == 'presave' && ($destination_url=='listkefu' && $yxwgz=='yxwgzhd')) || ($op=='insert' && !empty($is_hd))){
//unset($_SESSION['hd_yxwgz_genzong_num']);
cache_clear_all('hd_yxwgz_genzong_num', 'cache', FALSE);
}
if(($op == 'presave' && ($destination_url=='listkefu' && $yxwgz=='yxwgzzg')) || ($op=='insert' && !empty($is_zgy))){
//unset($_SESSION['zgy_yxwgz_genzong_num']);
cache_clear_all('zgy_yxwgz_genzong_num', 'cache', FALSE);
}
}
if($node->type=='kehugengzong' ){
if(($op == 'presave' && ($destination_url=='listkehugengzong' && $xgz_kehu=='genzong_kehu_keqing')) || $op=='insert')
{
cache_clear_all('genzong_kehu_keqing_nids', 'cache', FALSE);
}
if(($op == 'presave' && ($destination_url=='listkehugengzong' && $xgz_kehu=='genzong_kehu_weihu')) || $op=='insert')
{
cache_clear_all('genzong_kehu_weihu_nids', 'cache', FALSE);
}
if($op == 'insert' || $op == 'update'){
if(empty($node->field_khgz_parent_nid[0]['value'])){
$node->field_khgz_parent_nid[0]['value'] = $node->nid;
node_save($node);
}
global $have_tong_bu_kehuxingxi; //防止陷入了死循环,所以判断它第一次为空时,才执行一下
if(empty($have_tong_bu_kehuxingxi)){
$have_tong_bu_kehuxingxi = true; //已进行了同步了 就把它置为空吧
$result = db_query("select nid from content_type_kehugengzong where field_khgz_parent_nid_value =%d and nid!=%d",$node->field_khgz_parent_nid[0]['value'],$node->nid);
while($rowObj = db_fetch_object($result)){
$same_parent_obj = node_load($rowObj->nid);
$same_parent_obj->field_khgz_name[0]['value'] = $node->field_khgz_name[0]['value'];
$same_parent_obj->field_khgz_tel[0]['value'] = $node->field_khgz_tel[0]['value'];
$same_parent_obj->field_khgz_weixin[0]['value'] = $node->field_khgz_weixin[0]['value'];
$same_parent_obj->field_khgz_laiyuan[0]['value'] = $node->field_khgz_laiyuan[0]['value'];
$same_parent_obj->field_khgz_shengri[0]['value'] = $node->field_khgz_shengri[0]['value'];
$same_parent_obj->field_khgz_khhyqk[0]['value'] = $node->field_khgz_khhyqk[0]['value'];
$same_parent_obj->field_khgz_tizhong[0]['value'] = $node->field_khgz_tizhong[0]['value'];
$same_parent_obj->field_khgz_shenghao[0]['value'] = $node->field_khgz_shenghao[0]['value'];
$same_parent_obj->field_khgz_sex[0]['value'] = $node->field_khgz_sex[0]['value'];
$same_parent_obj->field_khgz_shenyushu[0]['value'] = $node->field_khgz_shenyushu[0]['value'];
$same_parent_obj->field_khgz_is_shunchan[0]['value'] = $node->field_khgz_is_shunchan[0]['value'];
$same_parent_obj->field_khgz_city[0]['value'] = $node->field_khgz_city[0]['value'];
$same_parent_obj->field_khgz_brxg[0]['value'] = $node->field_khgz_brxg[0]['value'];
$same_parent_obj->field_khgz_xhcdsw[0]['value'] = $node->field_khgz_xhcdsw[0]['value'];
$same_parent_obj->field_khgz_xhhdyl[0]['value'] = $node->field_khgz_xhhdyl[0]['value'];
$same_parent_obj->field_khgz_khjjqk[0]['value'] = $node->field_khgz_khjjqk[0]['value'];
$same_parent_obj->field_khgz_nyqk[0]['value'] = $node->field_khgz_nyqk[0]['value'];
$same_parent_obj->field_khgz_ksmc[0]['value'] = $node->field_khgz_ksmc[0]['value'];
$same_parent_obj->field_khgz_zfqk[0]['value'] = $node->field_khgz_zfqk[0]['value'];
$same_parent_obj->field_khgz_jtqk[0]['value'] = $node->field_khgz_jtqk[0]['value'];
$same_parent_obj->field_khgz_nxfqk[0]['value'] = $node->field_khgz_nxfqk[0]['value'];
$same_parent_obj->field_khgz_zwzgsmxm[0]['value'] = $node->field_khgz_zwzgsmxm[0]['value'];
$same_parent_obj->field_khgz_kqfx[0]['value'] = $node->field_khgz_kqfx[0]['value'];
node_save($same_parent_obj);
}
}
}
}
//在这三大总表保存前,看是否有 时间总表对象 如果没有的话 就 建一个总表对象 进行保存
if($op == 'presave')
{
if($node->type == 'jingjiazongbiaotype' || $node->type == 'kefuzongbiaotype' || $node->type == 'seozongbiaotype')
{
//如果是更新的情况下,我们就删除时间总表原来的对表的 竞价总表 或 客服总表 或 SEO总表
if(!empty($node->nid)){
_opraZongReration($node);
}
$field_zong_time = $node->field_zong_time[0]['value'];
$sql ="select no.nid from {node} as no inner join {content_field_zong_time} as time on no.nid=time.nid where
no.type='timezongtype' and time.field_zong_time_value='%s' limit 0,1";
$result = db_query($sql,$field_zong_time);
$timeZongTypeObj = db_fetch_object($result);
if(empty($timeZongTypeObj)){
$timeZongTypeObj = (object)$timeZongTypeObj; //创建空节点对象
$timeZongTypeObj->uid = 1; // 创建订单者统一设为超级管理员
$timeZongTypeObj->type = 'timezongtype'; //节点类型为“时间总表”
$timeZongTypeObj->title = '时间总表 '.$field_zong_time;
$timeZongTypeObj->field_zong_time[0]['value'] = $field_zong_time;
$timeZongTypeObj->language = 'zh-hans';
node_save($timeZongTypeObj);
}
//这里是操作 客服总表中的 吴中定金量(表单中不填写)通过计算赵金梅定金量和王晶晶定金量
if($node->type == 'kefuzongbiaotype'){
if(floatval($node->field_kf_wz_dinjinliang[0]['value'])!=(floatval($node->field_gr_zhaojingmeidinjinliang[0]['value'])+floatval($node->field_gr_wangjinjindinjinliang[0]['value']))){
$node->field_kf_wz_dinjinliang[0]['value'] = floatval($node->field_gr_zhaojingmeidinjinliang[0]['value'])+floatval($node->field_gr_wangjinjindinjinliang[0]['value']);
}
}
}
}
//假如三大总表是保存后,就把它三大表置为 时间总表的引用对象 //
//更新也有可能会执行执行了
if($op == 'insert' || $op == 'update')
{
if($node->type == 'jingjiazongbiaotype' || $node->type == 'kefuzongbiaotype' || $node->type == 'seozongbiaotype')
{
$field_zong_time = $node->field_zong_time[0]['value'];
$sql ="select no.nid from {node} as no inner join {content_field_zong_time} as time on no.nid=time.nid where
no.type='timezongtype' and time.field_zong_time_value='%s' limit 0,1";
$result = db_query($sql,$field_zong_time); // 返回的是总表的nid;
if(!empty($result)){ //这个是假如时间总表存在的话 这个只有nid的对象
$tmpTimeZongTypeObj = db_fetch_object($result);
$timeZongTypeObj = node_load($tmpTimeZongTypeObj->nid);//到数据库里加载它
}
else { //假如时间总表不存在的话
$timeZongTypeObj = (object)$timeZongTypeObj; //创建空节点对象
$timeZongTypeObj->uid = 1; // 创建订单者统一设为超级管理员
$timeZongTypeObj->type = 'timezongtype'; //节点类型为“时间总表”
$timeZongTypeObj->title = '时间总表 '.$field_zong_time;
$timeZongTypeObj->field_zong_time[0]['value'] = $field_zong_time;
$timeZongTypeObj->language = 'zh-hans';
node_save($timeZongTypeObj);
}
if($node->type == 'jingjiazongbiaotype'){
$timeZongTypeObj->field_jingjiazong[0][nid] = $node->nid;
}
if($node->type == 'kefuzongbiaotype'){
$timeZongTypeObj->field_kfzhong[0][nid] = $node->nid;
}
if($node->type == 'seozongbiaotype'){
$timeZongTypeObj->field_seozong[0][nid] = $node->nid;
}
node_save($timeZongTypeObj);
}
}
//删除三大总表时进行的操作
if($op == 'delete')
{
if($node->type == 'jingjiazongbiaotype' || $node->type == 'kefuzongbiaotype' || $node->type == 'seozongbiaotype')
{
_opraZongReration($node);
}
}
//假如插入或更新的时候
/*
if(($op == 'insert' || $op == 'update') && $node->type=='kefuchat' && $node->field_suozaixiaoqu[0]['value']=='zgy'){
$field_xueshenzixuandiqu_value = trim($node->field_xueshenzixuandiqu[0]['value']);
if(!empty($field_xueshenzixuandiqu_value))
{
include_once 'province_city.php';
$have_provice_city_other = false;
//这个是市
foreach ($city_arr as $city){
//因为吉林省 和吉林市同名 所以 当出现 吉林的时候 当作省来看待 跳过这里
if($field_xueshenzixuandiqu_value=='吉林' || $field_xueshenzixuandiqu_value=='吉林省'){
break;
}
$city['city_name']=='吉林' && $city['city_name']='吉林市';
if(_baohan($field_xueshenzixuandiqu_value,$city['city_name'])){
$result = db_query("select nid from content_type_kefuchat where field_suozaixiaoqu_value='zgy' and field_xueshenzixuandiqu_value like '%".$city['city_name']."%'");
$ids = '';
$nid_count = 0;
while($rowObj = db_fetch_object($result)){
$ids .= ','.$rowObj->nid;
$nid_count++;
}
$ids = substr($ids,1);
db_query("update content_type_kefuchat set field_xueshenzixuandiqu_num_value=".$nid_count." where nid in(".$ids.")");
$have_provice_city_other=true;
break;
}
}
//这个是省
if(!$have_provice_city_other){
foreach ($provice_arr as $provice){
if(_baohan($field_xueshenzixuandiqu_value,$provice['province_name'])){
$result = db_query("select nid,field_xueshenzixuandiqu_value from content_type_kefuchat where field_suozaixiaoqu_value='zgy' and field_xueshenzixuandiqu_value like '%".$provice['province_name']."%'");
$ids = '';
$nid_count = 0;
while($rowObj = db_fetch_object($result)){
//吉林情况特殊 处理一下 就是 不看城市包含了 因为有个吉林市和吉林省同名
if($rowObj->field_xueshenzixuandiqu_value=='吉林' || $rowObj->field_xueshenzixuandiqu_value=='吉林省'){
//这里什么也不做 换句话,就是跳过下面的城市检查了
}else{
foreach ($city_arr as $city){
if(_baohan($rowObj->field_xueshenzixuandiqu_value,$city['city_name'])){
continue 2;
}
}
}
$ids .= ','.$rowObj->nid;
$nid_count++;
}
$ids = substr($ids,1);
db_query("update content_type_kefuchat set field_xueshenzixuandiqu_num_value=".$nid_count." where nid in(".$ids.")");
$have_provice_city_other=true;
break;
}
}
}
//这个是其它地区
if(!$have_provice_city_other){
//这个文件 其实 要不要无所谓
include_once 'other_area.php';
empty($other_arr) && $other_arr=array();
//先在数据库中 保存其它地区中的值
$result = db_query("select nid from content_type_kefuchat where field_suozaixiaoqu_value='zgy' and field_xueshenzixuandiqu_value='".$field_xueshenzixuandiqu_value."'");
$ids = '';
$nid_count = 0;
while($rowObj = db_fetch_object($result)){
$ids .= ','.$rowObj->nid;
$nid_count++;
}
$ids = substr($ids,1);
db_query("update content_type_kefuchat set field_xueshenzixuandiqu_num_value=".$nid_count." where nid in(".$ids.")");
foreach($other_arr as $other){
if($field_xueshenzixuandiqu_value==$other['other_name']){
//此时 other_area.php 已经有了 这个其它地区的值
$have_provice_city_other=true;
break;
}
}
//other_area.php 其它地区中 没有保存它的值 就在 $other_arr数组中 增加一项,然后再保存到 other_area.php 中
if(!$have_provice_city_other){
//下一次 当 $other_arr 为空的时候 $next_other_id=1 ,否则 为 最大值+1
empty($other_arr[count($other_arr)-1]['other_id'])?$next_other_id=1:$next_other_id=$other_arr[count($other_arr)-1]['other_id']+1;
$other_arr[] = array('other_id'=>$next_other_id,'other_name'=>$field_xueshenzixuandiqu_value);
//把这个值保存到 other_area.php 中
$other_string ="<?php
";
$other_string .= '$other_arr = '.var_export($other_arr, true).';';
file_put_contents(__DIR__.'/other_area.php', $other_string);
}
}
}
}
*/
}
//包含字符串
function _baohan($str, $needle){
return stripos($str,$needle)!== false;
}
//以什么什么开头,$str, $needle是部分串
function _startWith($str, $needle) {
return strpos($str, $needle) === 0;
}
//以什么什么开头,$str, $needle是部分串
function _startWithi($str, $needle) {
return stripos($str, $needle) === 0;
}
//以什么什么开头,$str, $needle是部分串
function _endWith($haystack, $needle)
{
$length = strlen($needle);
if($length == 0)
{
return true;
}
return (substr($haystack, -$length) === $needle);
}
//以什么什么开头,$str, $needle是部分串
function _endWithi($haystack, $needle)
{
$length = strlen($needle);
if($length == 0)
{
return true;
}
return (strtolower(substr($haystack, -$length)) === strtolower($needle));
}
////应该是即将输出前的东西 render 应该在执行sql语句前执行 反正肯定在views_pre_view 之后执行
//function shipingzhongcustom_views_pre_render (&$view)
//{
// $arg0 =arg(0);
// if ($view->name=='allcontentview' && $arg0='listkefu') {
// $filters = $view->display_handler->get_option('filters');
// dsm($filters['field_qq_property_value_many_to_one']);
// var_dump("shipingzhongcustom_views_pre_render");
// }
//}
//在view前处理
function shipingzhongcustom_views_pre_view(&$view, &$display_id, &$args)
{
global $user;
//$arr = get_object_vars($view);//得到view数组
//var_dump(array_keys($arr)); //得到 view的所有键组成的数组
//var_dump($view->name); //得到的是views的名称 allcontentview
//var_dump($view->current_display); //得到的是当前视图display 的名称 page_14 也就是$display_id吧
//var_dump($view->db_table); //得到的是字段名
// $arr = get_object_vars($view->display_handler);得到display_handler 也就是在view中配置所组成的数组
// var_dump(array_keys($arr));exit;//得到display_handler 也就是在view中配置的所有键
// var_dump($view->display_handler->get_option('filters'));得到过滤器数组
//当是allcontentview视图 且 下面的page_14(总表) 或 feed_12(总表的excel)
if( $view->name=='allcontentview' && ($display_id=='page_14' || $display_id=='feed_12' ||
$display_id=='page_20' || $display_id=='page_19' || $display_id=='feed_13' || $display_id=='page_21' || $display_id=='feed_14'))
{
$arg0 = arg(0);
$allfields = $view->display_handler->get_option('fields');//得到所有的显示的字段的数组
if(!user_access('view field_baidu_szfzxx_xiaofei') && $arg0='listzongwuzhong') {
//unset($allfields['php']); //没有 查看 (百度 szfzxx 消费) (所以无法计算单价)的时候 删掉这个列 (百度 szfzxx 单价)吧
//unset($allfields['php_3']); //没有 查看 (百度 szfzxx 消费) 的时候 删掉这个列 (百度 竞价 总消费)吧
//unset($allfields['php_4']); //没有 查看 (百度 szfzxx 消费) 的时候 (当然也就无权查看百度szfzxx点击) 删掉这个列 (百度 竞价 总点击)吧
//unset($allfields['php_5']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
}
if(!user_access('view field_baidu_szfzxx_xiaofei') && $arg0='listzongadb') {
//unset($allfields['php']); //没有 查看 (百度 szfzxx 消费) (所以无法计算单价)的时候 删掉这个列 (百度 szfzxx 单价)吧
//unset($allfields['php_3']); //没有 查看 (百度 szfzxx 消费) 的时候 删掉这个列 (百度 竞价 总消费)吧
//unset($allfields['php_4']); //没有 查看 (百度 szfzxx 消费) 的时候 (当然也就无权查看百度szfzxx点击) 删掉这个列 (百度 竞价 总点击)吧
//unset($allfields['php_5']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
}
if(!user_access('view field_baidu_szfzxx_xiaofei') && $arg0='listzongzong') {
// unset($allfields['php']); //没有 查看 (百度 szfzxx 消费) (所以无法计算单价)的时候 删掉这个列 (百度 szfzxx 单价)吧
// unset($allfields['php_3']); //没有 查看 (百度 szfzxx 消费) 的时候 删掉这个列 (百度 竞价 总消费)吧
// unset($allfields['php_4']); //没有 查看 (百度 szfzxx 消费) 的时候 (当然也就无权查看百度szfzxx点击) 删掉这个列 (百度 竞价 总点击)吧
// unset($allfields['php_5']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
// unset($allfields['php_25']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
// unset($allfields['php_26']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
// unset($allfields['php_27']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
// unset($allfields['php_22']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
// unset($allfields['php_23']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
// unset($allfields['php_24']); //没有 查看 (百度 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (百度 竞价 总平均 单价)吧
}
if(!user_access('view field_baidu_400_xiaofei')) {
// unset($allfields['php_1']); //没有 查看 (百度 4000512126 消费) 的时候 删掉这个列 (百度 4000512126 单价)吧
}
if(!user_access('view field_baidu_ukart_xiaofei')) {
// unset($allfields['php_2']); //没有 查看 (百度 ukart086 消费) 的时候 删掉这个列 (百度 ukart086 单价)吧
}
if(!user_access('view field_sougou_wzfzxx_xiaofei')) {
// unset($allfields['php_9']); //没有 查看 (搜狗 wzfzxx 消费) 的时候 删掉这个列 (搜狗 wzfzxx 单价)吧
// unset($allfields['php_6']); //没有 查看 (搜狗 wzfzxx 消费) 的时候 删掉这个列 (搜狗 wzfzxx 总消费)吧
// unset($allfields['php_7']); //没有 查看 (搜狗 wzfzxx 消费) 的时候 (当然也就无权查看搜狗 wzfzxx点击) 删掉这个列 (搜狗竞价总点击 (它只有一个wzfzxx))吧
// unset($allfields['php_8']); //没有 查看 (搜狗 wzfzxx 消费) 的时候 (所以无法计算单价) 删掉这个列 (搜搜 竞价 总平均 单价(它只有一个wzfzxx))吧
}
if(!user_access('view field_sousou_szfzxx_xiaofei')) {
// unset($allfields['php_10']); //没有 查看 (搜搜 szfzxx 消费) 的时候 删掉这个列 (搜搜 szfzxx 单价)吧
// unset($allfields['php_13']);//没有 查看 (搜搜 szfzxx 消费) 的时候 删掉这个列 (搜搜 竞价 总消费)吧
// unset($allfields['php_14']);//没有 查看 (搜搜 szfzxx 消费) 的时候 (当然也就无权查看搜搜szfzxx点击) 删掉这个列 (搜搜 竞价 总点击)吧
// unset($allfields['php_15']);//没有 查看 (搜搜 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (搜搜 竞价 总平均 单价)吧
}
if(!user_access('view field_sousou_400_xiaofei')) {
// unset($allfields['php_11']); //没有 查看 (搜搜 4000512126 消费) 的时候 删掉这个列 (搜搜 4000512126 单价)吧
}
if(!user_access('view field_baidu_400_jy_xiaofei')) {
// unset($allfields['php_12']); //没有 查看 (百度 4000512126教育 消费) 的时候 删掉这个列 (百度 4000512126教育 单价)吧
}
if(!user_access('view field_360_szfzxx_xiaofei')) {
// unset($allfields['php_16']); //没有 查看 (360 szfzxx 消费) 的时候 删掉这个列 (360 szfzxx 单价)吧
// unset($allfields['php_19']); //没有 查看 (360 szfzxx 消费) 的时候 删掉这个列 (360 竞价 总消费)吧
// unset($allfields['php_20']); //没有 查看 (360 szfzxx 消费) 的时候 (当然也就无权查看360szfzxx点击) 删掉这个列 (360 竞价 总点击)吧
// unset($allfields['php_21']); //没有 查看 (360 szfzxx 消费) 的时候 (所以无法计算单价)删掉这个列 (360 竞价 总平均 单价)吧
}
if(!user_access('view field_360_400_xiaofei')) {
// unset($allfields['php_17']); //没有 查看 (360 4000512126 消费) 的时候 删掉这个列 (360 4000512126 单价)吧
}
if(!user_access('view field_360_ukart_xiaofei')) {
// unset($allfields['php_18']); //没有 查看 (360 ukart 消费) 的时候 删掉这个列 (360 ukart 单价)吧
}
//查看竞价总表计算的权限
if (!user_access('access jingjia zong jisuan'))
{
// unset($allfields['php_22']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_23']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_24']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_25']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_26']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_27']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_28']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_29']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_30']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_40']); //没有 查看 竞价总表计算的权限
// unset($allfields['php_41']); //没有 查看 竞价总表计算的权限
}
//查看 客服总表计算的权限
if(!user_access('access kefu zong jisuan')) {
// unset($allfields['php_31']); //没有 查看 客服总表计算的权限
// unset($allfields['php_32']); //没有 查看 客服总表计算的权限
// unset($allfields['php_33']); //没有 查看 客服总表计算的权限
// unset($allfields['php_34']); //没有 查看 客服总表计算的权限
// unset($allfields['php_35']); //没有 查看 客服总表计算的权限
// unset($allfields['php_36']); //没有 查看 客服总表计算的权限
}
//var_dump($allfields['edit_node']);
//var_dump($allfields['edit_node_1']);
//var_dump($allfields['edit_node_2']);
//echo "<pre>";
// var_dump($allfields);exit;
//看有没有编辑任意竞价总表权限
// unset($allfields['edit_node']); //看有没有编辑任意竞价总表权限 因为使用php_37 这里直接移除
// unset($allfields['edit_node_1']); //看有没有编辑任意客服总表权限 因为使用php_38 这里直接移除
// unset($allfields['edit_node_2']); //看有没有编辑任意SEO总表权限 因为使用php_39 这里直接移除
if(!user_access('edit any jingjiazongbiaotype content')) {
// unset($allfields['php_37']); //看有没有编辑任意竞价总表权限
}
//看有没有编辑任意客服总表权限
if(!user_access('edit any kefuzongbiaotype content')) {
// unset($allfields['php_38']); //看有没有编辑任意竞价总表权限
}
//看有没有编辑任意SEO总表权限
if(!user_access('edit any seozongbiaotype content')) {
//unset($allfields['php_39']); //看有没有编辑任意竞价总表权限
}
if(!user_access('view field_baidu_wm_szfzxx_xiaofei')) {
// unset($allfields['php_42']); //没有 查看 (百度 szfzxx网盟 消费) 的时候 删掉这个列 (szfzxx网盟 单价)吧
}
//$onlyIndexTonjingFilter 表示只有首页统计的时候,就不会用到下面的代码
//为真的时候 就不会执行下面的代码 即为假的时候 才执行下面的代码
global $onlyIndexTonjingFilter;
if(!$onlyIndexTonjingFilter){
//在去掉某些字段后 最后超越这个数组
$view->display_handler->override_option('fields',$allfields);
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
}
if($view->name=='wangshangbaoming' && ($display_id=='page_1'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_wsbm_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='wangshangbaoming' && ($display_id=='page_4'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_wsbm_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='wangshangbaoming' && ($display_id=='page_5'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_wsbm_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='wangshangbaoming' && ($display_id=='feed_1'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_wsbm_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_3'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_time_value']['default_date'] = date('Y-m').'-01';
// $export = kprint_r($filters,TRUE);
// print $export;
if(empty($_GET['yxwgz'])){
//假如是普通的 不带$_GET['yxwgz']参数 即 http://w.kfqd.cn/listkefuzg
//就移除掉 $filters['field_genzong_time_value'] 的设置 默认跟踪时间为空的 所以这里要去掉 好让!empty($_GET['yxwgz'])发挥作用
unset($filters['field_genzong_time_value']);
}
$view->display_handler->override_option('filters', $filters);
}
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
//var_dump($filters['field_is_baoming_value_many_to_one']);
if($view->name=='allcontentview' && ($display_id=='page_3') && !empty($_GET['yxwgz']) )
{
$filters = $view->display_handler->get_option('filters');
$filters['field_is_baoming_value_many_to_one']['operator'] = 'not';
$filters['field_is_baoming_value_many_to_one']['value'] = '是';
$filters['field_is_dingjing_value_many_to_one']['operator'] = 'not';
$filters['field_is_dingjing_value_many_to_one']['value'] = '是';
$filters['field_time_value']['default_date'] = '2017-03-01';
$filters['field_chat_status_value_many_to_one']['value']=array('complete'=>'complete');
if($_GET['yxwgz']=='yxwgzjyy'){
// var_dump($filters['field_suozaixiaoqu_value_many_to_one']);
// $filters['field_suozaixiaoqu_value_many_to_one']['value'] = array('wz'=>'wz');
$filters['field_suozaixiaoqu_value_many_to_one']['value'] = array('wz'=>'wz','xq'=>'xq');
$filters['field_suozaixiaoqu_value_many_to_one']['expose']['single'] =0;
}
else if ($_GET['yxwgz']=='yxwgzhd'){
$filters['field_suozaixiaoqu_value_many_to_one']['value'] = array('hd'=>'hd');
$filters['field_suozaixiaoqu_value_many_to_one']['expose']['single'] =1;
}
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_35'))
{
$filters = $view->display_handler->get_option('filters');
//$filters['field_time_value']['default_date'] = date('Y-m').'-01';
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
if(empty($_GET['yxwgz'])) {
//假如是普通的 不带$_GET['yxwgz']参数 即 http://w.kfqd.cn/listkefuzg
//就移除掉 $filters['field_genzong_time_value'] 的设置 默认跟踪时间为空的 所以这里要去掉 好让!empty($_GET['yxwgz'])发挥作用
unset($filters['field_genzong_time_value']);
}
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_35') && !empty($_GET['yxwgz']))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_is_baoming_value_many_to_one']['operator'] = 'not';
$filters['field_is_baoming_value_many_to_one']['value'] = '是';
$filters['field_is_dingjing_value_many_to_one']['operator'] = 'not';
$filters['field_is_dingjing_value_many_to_one']['value'] = '是';
//$filters['field_time_value']['default_date'] = '2017-03-01';
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_35') && !empty($_GET['yxwgz']) )
{
$filters = $view->display_handler->get_option('filters');
$filters['field_time_value']['default_date'] = '2017-03-01';
$filters['field_chat_status_value_many_to_one']['value']=array('complete'=>'complete');
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='block_1'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_time_value']['default_date'] = '2017-03-01';
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
if(empty($_GET['yxwgz'])) {
//假如是普通的 不带$_GET['yxwgz']参数 即 http://w.kfqd.cn/listkefuzg
//就移除掉 $filters['field_genzong_time_value'] 的设置 默认跟踪时间为空的 所以这里要去掉 好让!empty($_GET['yxwgz'])发挥作用
unset($filters['field_genzong_time_value']);
}
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='block_2'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_time_value']['default_date'] = '2017-03-01';
$view->display_handler->override_option('filters', $filters);
//$filters['field_time_value']['default_date'] = date('Y-m').'-01';
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
if(empty($_GET['yxwgz'])) {
//假如是普通的 不带$_GET['yxwgz']参数 即 http://w.kfqd.cn/listkefuzg
//就移除掉 $filters['field_genzong_time_value'] 的设置 默认跟踪时间为空的 所以这里要去掉 好让!empty($_GET['yxwgz'])发挥作用
unset($filters['field_genzong_time_value']);
}
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='block_1') && !empty($_GET['yxwgz']))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_is_baoming_value_many_to_one']['operator'] = 'not';
$filters['field_is_baoming_value_many_to_one']['value'] = '是';
$filters['field_is_dingjing_value_many_to_one']['operator'] = 'not';
$filters['field_is_dingjing_value_many_to_one']['value'] = '是';
//$filters['field_chat_status_value_many_to_one']['value']=array('complete'=>'complete');
//$filters['field_time_value']['default_date'] = '2017-03-01';
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='block_2') && !empty($_GET['yxwgz']))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_is_baoming_value_many_to_one']['operator'] = 'not';
$filters['field_is_baoming_value_many_to_one']['value'] = '是';
$filters['field_is_dingjing_value_many_to_one']['operator'] = 'not';
$filters['field_is_dingjing_value_many_to_one']['value'] = '是';
//$filters['field_chat_status_value_many_to_one']['value']=array('complete'=>'complete');
//$filters['field_time_value']['default_date'] = '2017-03-01';
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='feed_3'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_15'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_27'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_16'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_17'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_18'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_19'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_18'))
{
$allfields = $view->display_handler->get_option('fields');//得到所有的显示的字段的数组
if(!user_access('edit any jingjiazongbiaotype content')) {
unset($allfields['php_37']); //看有没有编辑任意竞价总表权限
}
//看有没有编辑任意客服总表权限
if(!user_access('edit any kefuzongbiaotype content')) {
unset($allfields['php_38']); //看有没有编辑任意竞价总表权限
}
$view->display_handler->override_option('fields',$allfields);
}
if($view->name=='allcontentview' && ($display_id=='page_26'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_28'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_29'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_34'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_zong_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_33'))
{
$filters = $view->display_handler->get_option('filters');
// $export = kprint_r($filters, TRUE); // $vars - is a variable which you want to print.
// print $export;
//最大时间为7天之前
$endTime = date('Y-m-d',(time()-15*24*60*60));
$filters['field_shangmeng_time_value_1']['default_date'] = $endTime;
$view->display_handler->override_option('filters', $filters);
}
if($view->name=='allcontentview' && ($display_id=='page_35'))
{
$filters = $view->display_handler->get_option('filters');
$filters['field_time_value']['default_date'] = date('Y-m').'-01';
$view->display_handler->override_option('filters', $filters);
}
}
function shipingzhongcustom_views_query_alter(&$view, &$query)
{
if ($view->name == 'allcontentview' && $view->current_display=='page_33') {
//$export = kprint_r($query->where, TRUE); // $vars - is a variable which you want to print.
//print $export;
//$query->add_where(1, "node_data_field_is_baoming.field_is_baoming_value IS NULL and node_data_field_is_dingjing.field_is_dingjing_value IS NULL ");
$query->add_where(1, "node_data_field_is_baoming.field_is_baoming_value IS NULL or node_data_field_is_baoming.field_is_baoming_value <> '是' ");
$query->add_where(1, "node_data_field_xueshenname.field_is_zx_shangmen_value = '是' ");
$query->set_where_group('OR', 1);
$query->add_where(2, "node_data_field_is_dingjing.field_is_dingjing_value IS NULL or node_data_field_is_dingjing.field_is_dingjing_value <> '是' ");
$query->add_where(2, "node_data_field_xueshenname.field_is_zx_shangmen_value = '是' ");
$query->set_where_group('OR', 2);
//这里是使用 in 方法 来得到 这样的nid(最大的下次跟踪时间为空的id 日期就不高兴限制了 只能加更多的限制的目的就是为了性能)
//如果不是为了性能的话 直接就是 group by next_time.nid having field_genzong_next_time_value is null 就可以了 就不有必要太多的条件限制了
$query->add_where(3, "node.nid in
(select tmp.nid from
(select next_time.nid,max(next_time.delta) as maxdelta,next_time.field_genzong_next_time_value
from node n
inner join content_field_genzong_next_time next_time on n.nid=next_time.nid
inner join content_field_is_shangmen shangmen on n.nid=shangmen.nid
inner join content_field_is_baoming baoming on n.nid=baoming.nid
inner join content_field_is_dingjing dingjing on n.nid=dingjing.nid
where n.type='kefuchat'
and shangmen.field_is_shangmen_value='是'
and (baoming.field_is_baoming_value is null or baoming.field_is_baoming_value <> '是')
and (dingjing.field_is_dingjing_value is null or dingjing.field_is_dingjing_value <> '是')
group by next_time.nid having field_genzong_next_time_value is null
) as tmp
)" );
//
// $export = kprint_r($query, TRUE);
// print $export;
}
if ($view->name == 'allcontentview' && $view->current_display=='page_3') {
//这里判断是否有值为 empty 如果有的话 就移除它 field_yixiangzhuanye_select_value 再增加一个 其值 为 is null 或 ''
//这个empty 是哪里设置的呢 是 本文件约 1615行进行 form_alter 设置的
foreach($query->where[0]['args'] as $key=>$value){
if($value=='empty' && stristr($query->where[0]['clauses'][$key],'field_yixiangzhuanye_select_value')){
// $export = kprint_r($query, TRUE); // $vars - is a variable which you want to print.
// print $export;
unset($query->where[0]['args'][$key]);
unset($query->where[0]['clauses'][$key]);
$query->add_where(0, "node_data_field_yixiangzhuanye_select.field_yixiangzhuanye_select_value IS NULL or node_data_field_yixiangzhuanye_select.field_yixiangzhuanye_select_value='' ");
};
// $export = kprint_r($view, TRUE); // $vars - is a variable which you want to print.
// print $export;
// if($value=='empty' && stristr($query->where[0]['clauses'][$key],'field_yixiangzhuanye_select_value')){
// unset($query->where[0]['args'][$key]);
// unset($query->where[0]['clauses'][$key]);
//// //注意这里的字段啊 是 node_data_field_xueshenname_field_yixiangzhuanye_select_value 从 dsm($query)可以看出来这个对象的fields字段
// $query->add_where(1, "node_data_field_xueshenname_field_yixiangzhuanye_select_value.field_yixiangzhuanye_select_value IS NULL or node_data_field_xueshenname_field_yixiangzhuanye_select_value.field_yixiangzhuanye_select_value='' ");
// //$query->add_where(1, "node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value IS NULL or node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value='' ");
// $query->set_where_group('AND', 1);
//
//// $query->where[0]['clauses'][$key] = " (node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value IS NULL) or (node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value='') ";
////// $query->where[0]['clauses'][$key] = "node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value = '%s'";
//// unset($query->where[0]['args'][$key]);
//
// }
}
if(empty($query->where['date']['clauses'][0])){
global $user;
$userinfo_str = var_export($user,true);
$getinfo_str = var_export($_GET,true);
$postinfo_str = var_export($_POST,true);
$ip_str = ip_address();
watchdog('content',$userinfo_str.' '.$getinfo_str.' '.$postinfo_str.' '.$ip_str, array(), WATCHDOG_ERROR);
drupal_set_message('有错误,请联系管理员!');
}
// $export = kprint_r($view, TRUE); // $vars - is a variable which you want to print.
// print $export;
// $export = kprint_r($query, TRUE); // $vars - is a variable which you want to print.
// print $export;
//$query->set_distinct(true);
// $users_join = $query->table_queue['users']['join'];
// $users_join->type = 'LEFT';
// $export = kprint_r($users_join, TRUE); // $vars - is a variable which you want to print.
// print $export;
// $query->table_queue['users']['join'] = $users_join;
// $node_data_field_chat_status_join = $query->table_queue['node_data_field_chat_status']['join'];
// $node_data_field_chat_status_join->type = 'LEFT';
// $query->table_queue['node_data_field_chat_status']['join'] = $node_data_field_chat_status_join;
// $query->add_where(1, "node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value IS NULL or node_data_field_yixiangzhuanye_select_value_0.field_yixiangzhuanye_select_value='' ");
// $query->set_where_group('AND', 1);
// $export = kprint_r($query,TRUE); // $vars - is a variable which you want to print.
// print $export;
}
if ($view->name == 'allcontentview' && $view->current_display=='page_36') {
//这里判断是否有值为 empty 如果有的话 就移除它 field_yixiangzhuanye_select_value 再增加一个 其值 为 is null 或 ''
//这个empty 是哪里设置的呢 是 本文件约 1615行进行 form_alter 设置的
foreach($query->where[0]['args'] as $key=>$value){
if($value=='empty' && stristr($query->where[0]['clauses'][$key],'field_yixiangzhuanye_select_value')){
// $export = kprint_r($query, TRUE); // $vars - is a variable which you want to print.
// print $export;
unset($query->where[0]['args'][$key]);
unset($query->where[0]['clauses'][$key]);
$query->add_where(0, "node_data_field_yixiangzhuanye_select.field_yixiangzhuanye_select_value IS NULL or node_data_field_yixiangzhuanye_select.field_yixiangzhuanye_select_value='' ");
};
}
}
if ($view->name == 'allcontentview' && ($view->current_display=='page_3' || $view->current_display=='page_35' )) {
if(!empty($_GET['xgz'])){
$xgz = $_GET['xgz'];
unset($query->where['date']);
unset($query->where[0]);
$days = $_GET['days'];
empty($days) && $days = 0;
if($xgz=='jyyxgz'){
$row_nids = _xugenzong_ids(array('wz','xq'),$days);
}else if($xgz=='hdxgz'){
$row_nids = _xugenzong_ids(array('hd'),$days);
}else if($xgz=='zgxgz'){
$row_nids = _xugenzong_ids(array('zgy'),$days);
}
$nids = implode(',',$row_nids);
$query->add_where(0, "node.nid in($nids)");
}
if(!empty($_GET['nids'])){
unset($query->where['date']);
unset($query->where[0]);
$nids = $_GET['nids'];
$query->add_where(0, "node.nid in($nids)");
}
// $yxwgz = $_GET['yxwgz'];
// if(!empty($yxwgz)){
// //这是有效未跟踪的 以意向级别不为空来判断的
// $query->add_where(2, "node_data_field_xueshenname.field_genzong_yxjb_value IS NULL ");
// }
}
if ($view->name == 'kehugengzonglist' && $view->current_display=='page_1') {
if(!empty($_GET['xgz_kehu'])){
$xgz_kehu = $_GET['xgz_kehu'];
unset($query->where['date']);
unset($query->where[0]);
if($xgz_kehu=='genzong_kehu_keqing'){
$row_nids = _genzong_kehu_keqing_nids('genzong_kehu_keqing');
}else if ($xgz_kehu=='genzong_kehu_weihu'){
$row_nids = _genzong_kehu_weihu_nids('genzong_kehu_weihu');
}
else if ($xgz_kehu=='houtian_shengri'){
$row_nids = _genzong_kehu_houtian_shengri_nids();
}
$nids = implode(',',$row_nids);
$query->add_where(0, "node.nid in($nids)");
}
}
//当是整骨时
if ($view->name == 'allcontentview' && ($view->current_display=='page_35' || $view->current_display=='page_16')) {
//以地区咨询人数的大小来排的话 再以地区来排一下
if(_startWith($query->orderby[0],'node_data_field_xueshenname_field_xueshenzixuandiqu_num_value')){
$query->add_orderby(NULL, NULL, 'ASC', 'node_data_field_xueshenname_field_xueshenzixuandiqu_value');
}
}
if ($view->name == 'allcontentview' && $view->current_display=='block_1') {
if(!empty($_GET['xgz'])){
$xgz = $_GET['xgz'];
unset($query->where['date']);
unset($query->where[0]);
if($xgz=='jyyxgz'){
$row_nids = _xugenzong_ids(array('wz','xq'));
}else if($xgz=='hdxgz'){
$row_nids = _xugenzong_ids(array('hd'));
}else if($xgz=='zgxgz'){
$row_nids = _xugenzong_ids(array('zgy'));
}
$nids = implode(',',$row_nids);
$query->add_where(0, "node.nid in($nids)");
}
if(!empty($_GET['nids'])){
unset($query->where['date']);
unset($query->where[0]);
$nids = $_GET['nids'];
$query->add_where(0, "node.nid in($nids)");
}
// $yxwgz = $_GET['yxwgz'];
// if(!empty($yxwgz)){
// //这是有效未跟踪的 以意向级别不为空来判断的
// $query->add_where(2, "node_data_field_xueshenname.field_genzong_yxjb_value IS NULL ");
// }
}
}
////在render前处理
//function shipingzhongcustom_views_pre_render(&$view) {
//
// //得到第一个对象
// $obj1 = $view->result[0];
// //把它转成数组
// $arr1 = get_object_vars($obj1);
// //把这个数组每个字段循环赋值为
// foreach($arr1 as $key=>$value)
// {
// $arr1[$key] = " ";
//// $arr1[$key] = "111111111111";
// }
// //再把这个数组转成对象
// $objLast=(object)$arr1;
//
// $view->result[]=$objLast;
//}
//在post render前处理
//function shipingzhongcustom_views_post_render(&$view, &$output, &$cache) {
// $result = kprint_r($view,TRUE);
// print $result;
// $result = kprint_r($output,TRUE);
// print $result;
// $result = kprint_r($cache,TRUE);
// print $result;
//
//}
//执行sql查询后执行
//function shipingzhongcustom_views_post_execute(&$view) {
// If there are more than 100 results, show a message that encourages the user
// to change the filter settings.
// (This action could be performed later in the execution process, but not
// earlier.)
// $arr = get_object_vars($view);
// var_dump(array_keys($arr));exit;//这里得到view对象的各个字段
//var_dump($view->pager);exit;
//var_dump($view->current_display);var_dump($view->name);
//当是allcontentview视图 且 下面的page_14(总表)
// if( $view->name=='allcontentview' && ($view->current_display=='page_14'))
// {
// $currentPage = $_GET['page'];
// //假如 /listzong 后面没有page参数的时候 跳到最后一页
// if(empty($currentPage) && strcmp(strval($currentPage),'0')!=0) {
// $lastPage = intval(ceil($view->total_rows/$view->pager['items_per_page']));
// $lastPage = $lastPage-1;
// header('LOCATION: /listzong?page='.$lastPage);
// exit;
// //drupal_goto('listzong?page='.$lastPage);
// }
// }
// if ($view->total_rows > 100) {
// drupal_set_message(t('You have more than 100 hits. Use the filter settings to narrow down your list.'));
// }
//}
//应该是即将输出前的东西 render 在执行sql语句后执行
//function shipingzhongcustom_views_pre_render (&$view)
//{
// //$arr = get_object_vars($view);
// //var_dump(array_keys($arr));
//}
//执行sql查询后执行
function shipingzhongcustom_views_pre_render (&$view)
{
// $arr = get_object_vars($view);
// var_dump(array_keys($arr));
// $result = kprint_r($view,TRUE);
// print $result;
// if ($view->name == 'allcontentview' && $view->current_display=='page_3') {
// $results = $view->result;
// global $user;
// //有定金量的时候,吴中的接待只能看吴中的定金量
// if(in_array('吴中接待只看吴中不看华东定金量',$user->roles)) {
//
// foreach($results as $key=>$result){
// if($result->node_data_field_is_dingjing_field_is_dingjing_value=='是'){
// $account = null;
// $account = user_load(array('name' => check_plain($result->node_data_field_dingjing_writer_field_dingjing_writer_value)));
// //假如定金量填写人 是华东的话 就移除它
// if(in_array('华东接待只看华东不看吴中定金量',$account->roles)){
// unset($results[$key]);
// }
// }
// }
// $view->result = $results;
// }
// //有定金量的时候,华东的接待只能看华东的定金量
// if(in_array('华东接待只看华东不看吴中定金量',$user->roles)) {
// foreach($results as $key=>$result){
// if($result->node_data_field_is_dingjing_field_is_dingjing_value=='是'){
// $account = null;
// $account = user_load(array('name' => check_plain($result->node_data_field_dingjing_writer_field_dingjing_writer_value)));
// //假如定金量填写人 是吴中的话 就移除它
// if(in_array('吴中接待只看吴中不看华东定金量',$account->roles)){
// unset($results[$key]);
// }
// }
// }
// $view->result = $results;
// }
// }
// else if ($view->name == 'allcontentview' && $view->current_display=='page_33') {
// $results = $view->result;
// foreach($results as $key=>$result){
// $node=(object)null;
// $node = node_load($result->nid);
// $next_times = $node->field_genzong_next_time;
// //这里移除掉 最后一个 下次跟踪时间不为空的 node (如果为下次跟踪时间为空的话 就表示已经是转向上门的了)
// if(!empty($next_times[count($next_times)-1]['value'])){
// unset($results[$key]);
// }
// }
// $view->result = $results;
// }
}
//应该是即将输出前的东西 post_render 在执行sql语句后 执行 所以肯定是在hook_views_pre_render之后执行
//function shipingzhongcustom_views_post_render (&$view, &$output, &$cache)
//{
// //$arr = get_object_vars($view);
// //var_dump(array_keys($arr));
// //str_re
// // exit;
//}
function _is_add_edit_zg()
{
$arg0 = arg(0);
$arg1 = arg(1);
$arg2 = arg(2);
$arg3 = arg(3);
if(($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&($arg3=='zg')||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&($arg3=='zg')){
return true;
}
}
function _is_add_edit_xx()
{
$arg0 = arg(0);
$arg1 = arg(1);
$arg2 = arg(2);
$arg3 = arg(3);
if(($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&(empty($arg3))||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&(empty($arg3))){
return true;
}
}
function _kefuchat_node_form_xuexiao_or_zhenggu()
{
$arg0 = arg(0);
$arg1 = arg(1);
$arg2 = arg(2);
$arg3 = arg(3);
if(($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&($arg3=='zg')||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&($arg3=='zg')){
return 'kefuchat_node_form_zg';
}
if(($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&(empty($arg3))||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&(empty($arg3))){
return 'kefuchat_node_form_xuexiao';
}
return '';
}
function shipingzhongcustom_form_alter(&$form, &$form_state, $form_id)
{
$arg0 = arg(0);
$arg1 = arg(1);
$arg2 = arg(2);
$arg3 = arg(3);
if($form_id=='content_add_more_js' && ($arg0=='content' && $arg1=='js_add_more' && $arg2=='kefuchat' && $arg0=='field_genzong_fangshi')){
$form['field_genzong_fangshi']['#theme'] = 'custom_field_fangshi_values';
}
// if('views_exposed_form' == $form_id){
//
// }
//下面是添加的时候给总表传默认值
// //var_dump($node);var_dump($form_id);var_dump("QQQQQQqq");
if($form_id=='jingjiazongbiaotype_node_form' || $form_id=='kefuzongbiaotype_node_form' || $form_id=='seozongbiaotype_node_form' )
{
$thirdPara =$arg3;//这是第三个参数
if(!empty($thirdPara)){
$form['field_zong_time'][0]['#default_value']['value'] = $arg3;
}
}
if($form_id == 'kefuchat_node_form'){
$form['field_genzong_fangshi']['#theme'] = 'custom_field_fangshi_values';
//$form['field_navigation_shangmen_tag'] = array ( '#type' => 'markup','#value' => '<div class="form-item"><label>添加标签</label> <a href="/done_tag/field_shangmen_tag" target="_blank">添加上门标签</a></div>','#weight'=>26.3);
$form['field_update_shangmen_tag'] = array ( '#prefix' => '<div class="form-item edit-field-update-shangmen-tag-outer"><label>更新标签</label>','#type' => 'submit',
'#value' => '添加上门标签','#weight'=>26.3,'#suffix' => '</div>',
'#submit' => array('shipingzhongcustomdonetag_kefuchat_node_form_submit'),
'#access' => TRUE,
'#attributes'=>array('to'=>'field_shangmen_tag')
);
//$form['field_navigation_baoming_tag'] = array ( '#type' => 'markup','#value' => '<div class="form-item"><label>添加标签</label> <a href="/done_tag/field_baoming_tag" target="_blank">添加报名标签</a></div>','#weight'=>41.8);
$form['field_update_baoming_tag'] = array ( '#prefix' => '<div class="form-item edit-field-update-baoming-tag-outer"><label>更新标签</label>','#type' => 'submit',
'#value' => '添加报名标签','#weight'=>41.9,'#suffix' => '</div>',
'#submit' => array('shipingzhongcustomdonetag_kefuchat_node_form_submit'),
'#access' => TRUE,
'#attributes'=>array('to'=>'field_baoming_tag')
);
// global $user;
// if($user->uid==1){
// //array_unshift($form['#submit'], 'shipingzhongcustomdonetag_kefuchat_node_form_submit');
// // $form['#submit'][] = 'shipingzhongcustomdonetag_kefuchat_node_form_submit';
////
// $export = kprint_r($form,TRUE);
// print_r($export);
// print_r($export);
// }
}
if($form_id == 'kefuchat_node_form' &&
(_kefuchat_node_form_xuexiao_or_zhenggu()=='kefuchat_node_form_xuexiao')){
$form['#after_build'][] = '_addForXuanxiaoClass';
$form['#after_build'][] = '_removeguanyuzg';
//$form['#after_build'][] = '_resetgenzongsizeforxuexiao';
//var_dump($form);
// $export = kprint_r($form, TRUE); // $vars - is a variable which you want to print.
// print $export;
//unset($form['field_shangmen_beizhu']); #theme (String, 23 characters ) content_multiple_values
$form['field_time']['#prefix'] = '<div class="add_edit_form_element_set" >';
$form['field_chat_status']['#suffix'] = '</div>';
$form['field_is_shangmen']['#prefix'] = '<div class="add_edit_form_element_set" >';
// $form['field_baoming_beizhu']['#suffix'] = '</div>';
$form['field_update_baoming_tag']['#suffix'] .= '</div>';
//$form['field_time']['#field_prefix'] = "AAAAAAAAA";
//$form['field_xueshenname']['#field_prefix'] = "ccccc";
//$form['field_xueshenname']['#prefix'] = "ddddd";
$form['field_shangmen_beizhu']['#theme'] = 'custom_textarea_values';
$form['field_yixiangzhuanye']['#theme'] = 'custom_textarea_values';
$form['field_baoming_beizhu']['#theme'] = 'custom_textarea_values';
$form['field_zx_shangmen_beizhu']['#theme'] = 'custom_textarea_values';
//$form['field_dingjing_beizhu']['#theme'] = 'custom_textarea_values';
}
//AAAAAAAAAAAAAAAAAAAAAA
if($form_id == 'kefuchat_node_form' &&
(_kefuchat_node_form_xuexiao_or_zhenggu()=='kefuchat_node_form_zg')){
$form['#after_build'][] = '_removeguanyuxuexiao';
$form['field_time']['#prefix'] = '<div class="add_edit_form_element_set add_edit_form_element_set_forzg_first" >';
$form['field_chat_status']['#suffix'] = '</div>';
$form['field_shangmen_tag']['#prefix'] = '<div class="add_edit_form_element_set" >';
$form['field_update_baoming_tag']['#suffix'] .= '</div>';
/* $form['field_genzong_time']['#prefix'] = '<div class="add_edit_form_element_set" >';
$form['field_genzong_time']['#suffix'] = '</div>';
$form['field_genzong_qingkuang']['#prefix'] = '<div class="add_edit_form_element_set" >';
$form['field_genzong_qingkuang']['#suffix'] = '</div>';
$form['field_genzong_beizhu']['#prefix'] = '<div class="add_edit_form_element_set" >';
$form['field_genzong_beizhu']['#suffix'] = '</div>';*/
// $export = kprint_r($form['field_genzong_beizhu'],TRUE);
// print $export;
$form['field_genzong_time']['#theme'] = 'custom_textarea_values';
$form['field_genzong_qingkuang']['#theme'] = 'custom_textarea_values';
//$form['field_genzong_beizhu']['#theme'] = 'custom_textarea_values';
$form['field_yixiangzhuanye']['#theme'] = 'custom_textarea_values';
$form['field_baoming_beizhu']['#theme'] = 'custom_textarea_values';
$form['field_zx_shangmen_beizhu']['#theme'] = 'custom_textarea_values';
$form['field_dingjing_beizhu']['#theme'] = 'custom_textarea_values';
}
if($form_id == 'kefuchat_node_form'){
//var_dump($form['field_qq_property']);
//dsm($form);
$form['#after_build'][] = '_afterFormSelect';
$form['#after_build'][] = '_afterFormMultiDateTwoLine';
if(($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&(empty($arg3))||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&(empty($arg3))){
//这里仅仅是为了修改时间的 label
$form['field_baoming_time']['#pre_render'] = array('_zg_date_label');
//修改普通标签
$form['#after_build'][] = '_afterFormForZg';
}
if((($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&($arg3=='zg')||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&($arg3=='zg'))){
//这里仅仅是为了修改时间的 label
$form['field_baoming_time']['#pre_render'] = array('_zg_date_label');
//修改普通标签
$form['#after_build'][] = '_afterFormForZg';
}
}
if($form_id == 'kefuchat_node_form'){
$form['#after_build'][] = '_addSelectLaiyuanClass';
$form['#after_build'][] = '_addCheckBoxTagClass';
//var_dump($form['field_qq_property']);
$form['#after_build'][] = '_trimTel';
}
if($form_id == 'kefuchat_node_form'){
$form['#after_build'][] = '_kefuchat_node_form_validation';
$form['#after_build'][] = '_after_build_kefuchat_node_form_validate';
}
if($form_id == 'jingjiazongbiaotype_node_form'){
$form['#after_build'][] = '_jingjiazongbiaotype_node_form_validation';
}
if($form_id == 'kefuzongbiaotype_node_form'){
$form['#after_build'][] = '_kefuzongbiaotype_node_form_validation';
}
if($form_id == 'seozongbiaotype_node_form'){
$form['#after_build'][] = '_seozongbiaotype_node_form_validation';
}
if($form_id =='sousou_node_form')
{
$form['#after_build'][] = '_sousou_node_form_afterFormSelect';
}
if( $arg0=='listkefu' && $form_id=='views_exposed_form'){
//下面这个是来源 unset一下 以前不用的去掉
unset($form['field_qq_property_value_many_to_one']['#options']['leyu']);
//unset($form['field_qq_property_value_many_to_one']['#options']['xingqubaidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingqushoujiliuyan']);
//unset($form['field_qq_property_value_many_to_one']['#options']['400xinqu']);
//unset($form['field_qq_property_value_many_to_one']['#options']['liuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['400']);
unset($form['field_qq_property_value_many_to_one']['#options']['baidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['kuishangtong']);
unset($form['field_qq_property_value_many_to_one']['#options']['qiyeqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongleyu']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongfuzhanleyu']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingquleyou']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongshoujiliuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['qita']);
unset($form['field_qq_property_value_many_to_one']['#options']['qudao']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdzuoji']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdshouji']);
// unset($form['field_qq_property_value_many_to_one']['#options']['hdlaoliang']);
//增加一个空值
$form['field_yixiangzhuanye_select_value_many_to_one']['#options']['empty']='空';
$form['field_qq_property_value_many_to_one']['#attributes'] = array('class' => 'laiyuan');
// 去掉整骨的来源
unset($form['field_qq_property_value_many_to_one']['#options']['zhengguswt']);
unset($form['field_qq_property_value_many_to_one']['#options']['zhenggu400']);
unset($form['field_qq_property_value_many_to_one']['#options']['zhengguQQ']);
unset($form['field_qq_property_value_many_to_one']['#options']['zhengguliuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['zhengguweixin']);
unset($form['field_qq_property_value_many_to_one']['#options']['zgxyjs']);
unset($form['field_qq_property_value_many_to_one']['#options']['zhengguhzkh']);
unset($form['field_qq_property_value_many_to_one']['#options']['zhengguwb']);
//去掉整骨的意向专业
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_px_rszgqkb']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_px_rszgxyb']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_px_rszgstb']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_px_bbfl']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_rsmbxys']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_rszgrbs']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_rstxjzs']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_rsjzjzs']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_rsgpjzs']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_rshxtbjzs']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_xm_bbfl']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['zg_djhzjm']);
//去掉整骨的报名专业
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_px_rszgqkb']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_px_rszgxyb']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_px_rszgstb']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_px_bbfl']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_rsmbxys']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_rszgrbs']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_rstxjzs']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_rsjzjzs']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_rsgpjzs']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_rshxtbjzs']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_xm_bbfl']);
unset($form['field_baomingzuanye_select_value_many_to_one']['#options']['zg_djhzjm']);
$form['#submit'] = array('shipingzhongcustom_listkefu_views_exposed_form_submit');
drupal_add_js('var currmonthfirstday = "'.date('Y-m').'-01'.'";', 'inline');
drupal_add_js(drupal_get_path('theme', 'myminnellizhutwo') . "/js/setfielddatedefaultvalue.js");
}
if( $arg0=='listkefuzg' && $form_id=='views_exposed_form'){
//下面这个是来源 unset一下 以前不用的去掉
unset($form['field_qq_property_value_many_to_one']['#options']['leyu']);
//unset($form['field_qq_property_value_many_to_one']['#options']['xingqubaidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingqushoujiliuyan']);
//unset($form['field_qq_property_value_many_to_one']['#options']['400xinqu']);
//unset($form['field_qq_property_value_many_to_one']['#options']['liuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['400']);
unset($form['field_qq_property_value_many_to_one']['#options']['baidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['kuishangtong']);
unset($form['field_qq_property_value_many_to_one']['#options']['qiyeqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongleyu']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongfuzhanleyu']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingquleyou']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongshoujiliuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['qita']);
unset($form['field_qq_property_value_many_to_one']['#options']['qudao']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdzuoji']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdshouji']);
// unset($form['field_qq_property_value_many_to_one']['#options']['hdlaoliang']);
//增加一个空值
$form['field_yixiangzhuanye_select_value_many_to_one']['#options']['empty']='空';
$form['field_qq_property_value_many_to_one']['#attributes'] = array('class' => 'laiyuan');
// 去掉学校的来源
unset($form['field_qq_property_value_many_to_one']['#options']['adbswt']);
unset($form['field_qq_property_value_many_to_one']['#options']['wzswt']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdswt']);
unset($form['field_qq_property_value_many_to_one']['#options']['400xinqu']);
unset($form['field_qq_property_value_many_to_one']['#options']['400wuzhong']);
unset($form['field_qq_property_value_many_to_one']['#options']['hd400']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingqugerenqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['gerenqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdgerenqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['liuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongliuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdliuyan']);
unset($form['field_qq_property_value_many_to_one']['#options']['adbweixin']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzongweixin']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdweixin']);
unset($form['field_qq_property_value_many_to_one']['#options']['adbxyjs']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongxyjs']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdxyjs']);
unset($form['field_qq_property_value_many_to_one']['#options']['adbhezuokefu']);
unset($form['field_qq_property_value_many_to_one']['#options']['hezuokefu']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdhezuokefu']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingquqiyeqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongqiyeqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdqyqq']);
unset($form['field_qq_property_value_many_to_one']['#options']['xingqubaidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['wuzhongbaidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdbaidushangqiao']);
unset($form['field_qq_property_value_many_to_one']['#options']['hdlaoliang']);
//去掉学校的意向专业
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['fzsj_wjc']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['fzsj_yjc']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['fzzb_wjc']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['fzzb_yjc']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['czby_wnz_dz']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['gzby_snz_dz']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['gjlt_cj']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['fzcad_zb']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['fzgy_ygy']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['gd_licai']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['gd_nvzhang']);
unset($form['field_yixiangzhuanye_select_value_many_to_one']['#options']['gd_nanzhang']);
}
if( $arg0=='listsousoutuiguang' && $form_id=='views_exposed_form'){
unset($form['field_leixing_value_many_to_one']['#options']['sousou']);
// $export = kprint_r($form, TRUE); // $vars - is a variable which you want to print.
// print $export;
}
$arg1 = arg(1);
if( $arg0=='admin' && $arg1=='batchlistkefu' && $form_id=='views_exposed_form'){
// $export = kprint_r($form, TRUE); // $vars - is a variable which you want to print.
// print $export;
// unset($form['field_qq_property_value_many_to_one']['#options']['hdlaoliang']);
//增加一个空值
$form['field_yixiangzhuanye_select_value_many_to_one']['#options']['empty']='空';
}
//var_dump(_my_mobile_theme_detect_php());var_dump("AAAAA");exit;
//这是手机访问 kefuchat_node_form
if($form_id == 'kefuchat_node_form' && _my_mobile_theme_detect_php()){
$form['#attributes']['class'] = 'kefuchat-node-form-mobile';
unset($form['field_time']);
unset($form['field_qq_property']);
unset($form['field_suozaixiaoqu']);
unset($form['field_qq_number']);
unset($form['field_xueshenname']);
unset($form['field_xueshenzixuandiqu']);
unset($form['field_xueshennianling']);
unset($form['field_xueshenxueli']);
unset($form['field_tel']);
unset($form['field_weixinhao']);
unset($form['field_xueyuan_qq']);
unset($form['field_yixiangzhuanye_select']);
unset($form['field_fangwe_laiyuan']);
unset($form['field_guanjianci']);
unset($form['field_visit_url']);
unset($form['field_chat_status']);
unset($form['field_is_dingjing']);
unset($form['field_dingjing_time']);
unset($form['field_dingjingzuanye_select']);
unset($form['field_dingjingxuefei']);
unset($form['field_dingjing_writer']);
unset($form['field_dingjing_beizhu']);
unset($form['field_is_baoming']);
unset($form['field_baoming_time']);
unset($form['field_baomingzuanye_select']);
unset($form['field_baomingxuefei']);
unset($form['field_baoming_writer']);
unset($form['field_baoming_beizhu']);
unset($form['field_yixiangzhuanye']);
unset($form['attachments']);
unset($form['field_id_card']);
unset($form['menu']);
unset($form['node_privacy_byrole']);
unset($form['revision_information']);
unset($form['options']);
unset($form['author']);
unset($form['comment_settings']);
unset($form['field_genzong_writer']);
// $export = kprint_r($form,TRUE);
// print $export;
//var_dump($form);
$form['#redirect'] = 'searchweixinhao';
}
}
/*function _resetgenzongsizeforxuexiao_two(&$elements,$size){
foreach (element_children($elements) as $key) {
if (isset($elements[$key]) && $elements[$key]) {
// Recurse through all children elements.
_resetgenzongsizeforxuexiao_two($elements[$key]);
}
}
$elements['#size'] = $size;
}*/
/*function _resetgenzongsizeforxuexiao($form, &$form_state) {
//$form['field_genzong_time']['value']['#size'] = '11';
//_resetgenzongsizeforxuexiao_two($form['field_genzong_time'],'10');
$export = kprint_r($form['field_genzong_fangshi'],TRUE);
print $export;
return $form;
}*/
function _trimTel($form, &$form_state){
$form_state['values']['field_tel'][0]['value'] = trim($form_state['values']['field_tel'][0]['value']);
return $form;
}
function _setLaiyuanClass(&$elements) {
// echo "AAAAA";
//$export = kprint_r($elements, TRUE);
// print $export;
// echo "bbbbb";
foreach (element_children($elements) as $key) {
if (isset($elements[$key]) && $elements[$key]) {
// Recurse through all children elements.
_setLaiyuanClass($elements[$key]);
}
}
if (!isset($elements['#attributes'])) {
$elements['#attributes'] = array();
}
$elements['#attributes']['class'] = 'laiyuan';
}
function _setCheckBoxTagClass(&$elements) {
// echo "AAAAA";
//$export = kprint_r($elements, TRUE);
// print $export;
// echo "bbbbb";
foreach (element_children($elements) as $key) {
if (isset($elements[$key]) && $elements[$key]) {
// Recurse through all children elements.
_setCheckBoxTagClass($elements[$key]);
}
}
if (!isset($elements['#attributes'])) {
$elements['#attributes'] = array();
}
$elements['#attributes']['class'] = 'checkboxtag';
}
function _addSelectLaiyuanClass($form, &$form_state){
//$form['field_qq_property']['#attributes'] = array('class' => 'aaaaa');
// $form['field_qq_property']['#disabled'] = TRUE;
_setLaiyuanClass($form['field_qq_property']);
return $form;
}
function _addCheckBoxTagClass($form, &$form_state){
_setCheckBoxTagClass($form['field_shangmen_tag']);
_setCheckBoxTagClass($form['field_baoming_tag']);
//_setCheckBoxTagTheme($form['field_baoming_tag']);
return $form;
}
/*function _setXuanxiaoClass(&$elements) {
foreach (element_children($elements) as $key) {
if (isset($elements[$key]) && $elements[$key]) {
// Recurse through all children elements.
_setXuanxiaoClass($elements[$key]);
}
}
if (!isset($elements['#attributes'])) {
$elements['#attributes'] = array();
}
$elements['#attributes']['class'] = 'element_for_xuexiao';
}*/
function _addForXuanxiaoClass($form, &$form_state){
$form['#attributes']['class'] = 'form_for_xuexiao';
//$form['field_qq_property']['#attributes'] = array('class' => 'aaaaa');
// $form['field_qq_property']['#disabled'] = TRUE;
/*_setXuanxiaoClass($form['field_genzong_time']);
_setXuanxiaoClass($form['field_genzong_qingkuang']);
_setXuanxiaoClass($form['field_genzong_next_time']);
_setXuanxiaoClass($form['field_genzong_yxjb']);
_setXuanxiaoClass($form['field_genzong_fangshi']);*/
return $form;
}
function _sousou_node_form_afterFormSelect($form, &$form_state) {
$arrOptions = $form['field_leixing']['value']['#options'];
unset($arrOptions['sousou']);
$form['field_leixing']['value']['#options']= $arrOptions;
return $form;
}
function _afterFormMultiDateTwoLine($form, &$form_state) {
if(empty($form['field_genzong_time'][1])){
//$form['field_genzong_time'][1] = $form['field_genzong_time'][0];
//$form['field_genzong_time'][1]['#weight'] = 1;
//$form['field_genzong_time'][1]['#delta'] = 1;
}
/*$export = kprint_r($form['field_genzong_time'],TRUE);
print $export;
$export = kprint_r($form['field_genzong_qingkuang'],TRUE);
print $export;*/
return $form;
}
function _removeguanyuzg($form, &$form_state) {
//unset($form['field_genzong_time']);
//unset($form['field_genzong_qingkuang']);
//unset($form['field_genzong_beizhu']);
//unset($form['field_genzong_writer']);
/*$export = kprint_r($form,TRUE);
print $export;*/
return $form;
}
function _removeguanyuxuexiao($form, &$form_state) {
unset($form['field_is_shangmen']);
unset($form['field_shangmeng_time']);
unset($form['field_xueshenshangmengdiqu']);
unset($form['field_shangmeng_writer']);
unset($form['field_shangmen_beizhu']);
unset($form['field_id_card']);
unset($form['field_yiyuxuexi']);
//unset($form['field_genzong_yxjb']);
//unset($form['field_genzong_fangshi']);
//unset($form['field_genzong_next_time']);
/*$export = kprint_r($form,TRUE);
print $export;*/
return $form;
}
function _afterFormSelect($form, &$form_state) {
$arg0 = arg(0);
$arg1 = arg(1);
$arg2 = arg(2);
$arg3 = arg(3);
$options = array(
"1" => "option1",
"2" => "option2",
);
//$form['field_qq_property']['und']['#options'] = $options;
//dsm($form['field_qq_property']['value']['#options']);
$arrOptions = $form['field_qq_property']['value']['#options'];
unset($arrOptions['leyu']);
//unset($arrOptions['xingqubaidushangqiao']);
unset($arrOptions['xingqushoujiliuyan']);
//unset($arrOptions['400xinqu']);
//unset($arrOptions['liuyan']);
unset($arrOptions['400']);
unset($arrOptions['baidushangqiao']);
unset($arrOptions['kuishangtong']);
unset($arrOptions['qiyeqq']);
unset($arrOptions['wuzhongleyu']);
unset($arrOptions['wuzhongfuzhanleyu']);
unset($arrOptions['xingquleyou']);
//unset($arrOptions['wuzhongbaidushangqiao']);
unset($arrOptions['xingqushoujiliuyan']);
unset($arrOptions['qita']);
//unset($arrOptions['xingqubaidushangqiao']);
//unset($arrOptions['xingquqiyeqq']);
unset($arrOptions['wuzhongshoujiliuyan']);
//unset($arrOptions['hezuokefu']);
unset($arrOptions['qudao']);
unset($arrOptions['hdzuoji']);
unset($arrOptions['hdshouji']);
// unset($arrOptions['hdlaoliang']);
$form['field_qq_property']['value']['#options'] = $arrOptions;
if(($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&(empty($arg3))||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&(empty($arg3))){
$arrOptions = $form['field_qq_property']['value']['#options'];
// 去掉整骨的来源
unset($arrOptions['zhengguswt']);
unset($arrOptions['zhenggu400']);
unset($arrOptions['zhengguQQ']);
unset($arrOptions['zhengguliuyan']);
unset($arrOptions['zhengguweixin']);
unset($arrOptions['zgxyjs']);
unset($arrOptions['zhengguhzkh']);
unset($arrOptions['zhengguwb']);
$form['field_qq_property']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_yixiangzhuanye_select']['value']['#options'];
unset($arrOptions['zg_px_rszgqkb']);
unset($arrOptions['zg_px_rszgxyb']);
unset($arrOptions['zg_px_rszgstb']);
unset($arrOptions['zg_px_bbfl']);
unset($arrOptions['zg_xm_rsmbxys']);
unset($arrOptions['zg_xm_rszgrbs']);
unset($arrOptions['zg_xm_rstxjzs']);
unset($arrOptions['zg_xm_rsjzjzs']);
unset($arrOptions['zg_xm_rsgpjzs']);
unset($arrOptions['zg_xm_rshxtbjzs']);
unset($arrOptions['zg_xm_bbfl']);
unset($arrOptions['zg_djhzjm']);
$form['field_yixiangzhuanye_select']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_baomingzuanye_select']['value']['#options'];
unset($arrOptions['zg_px_rszgqkb']);
unset($arrOptions['zg_px_rszgxyb']);
unset($arrOptions['zg_px_rszgstb']);
unset($arrOptions['zg_px_bbfl']);
unset($arrOptions['zg_xm_rsmbxys']);
unset($arrOptions['zg_xm_rszgrbs']);
unset($arrOptions['zg_xm_rstxjzs']);
unset($arrOptions['zg_xm_rsjzjzs']);
unset($arrOptions['zg_xm_rsgpjzs']);
unset($arrOptions['zg_xm_rshxtbjzs']);
unset($arrOptions['zg_xm_bbfl']);
unset($arrOptions['zg_djhzjm']);
$form['field_baomingzuanye_select']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_dingjingzuanye_select']['value']['#options'];
unset($arrOptions['zg_px_rszgqkb']);
unset($arrOptions['zg_px_rszgxyb']);
unset($arrOptions['zg_px_rszgstb']);
unset($arrOptions['zg_px_bbfl']);
unset($arrOptions['zg_xm_rsmbxys']);
unset($arrOptions['zg_xm_rszgrbs']);
unset($arrOptions['zg_xm_rstxjzs']);
unset($arrOptions['zg_xm_rsjzjzs']);
unset($arrOptions['zg_xm_rsgpjzs']);
unset($arrOptions['zg_xm_rshxtbjzs']);
unset($arrOptions['zg_xm_bbfl']);
unset($arrOptions['zg_djhzjm']);
$form['field_dingjingzuanye_select']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_suozaixiaoqu']['value']['#options'];
unset($arrOptions['zgy']);
$form['field_suozaixiaoqu']['value']['#options'] = $arrOptions;
}
if((($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&($arg3=='zg')||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&($arg3=='zg'))){
$arrOptions = $form['field_qq_property']['value']['#options'];
// 去掉学校的来源
unset($arrOptions['adbswt']);
unset($arrOptions['wzswt']);
unset($arrOptions['hdswt']);
unset($arrOptions['400xinqu']);
unset($arrOptions['400wuzhong']);
unset($arrOptions['hd400']);
unset($arrOptions['xingqugerenqq']);
unset($arrOptions['gerenqq']);
unset($arrOptions['hdgerenqq']);
unset($arrOptions['liuyan']);
unset($arrOptions['wuzhongliuyan']);
unset($arrOptions['hdliuyan']);
unset($arrOptions['adbweixin']);
unset($arrOptions['wuzongweixin']);
unset($arrOptions['hdweixin']);
unset($arrOptions['adbxyjs']);
unset($arrOptions['wuzhongxyjs']);
unset($arrOptions['hdxyjs']);
unset($arrOptions['adbhezuokefu']);
unset($arrOptions['hezuokefu']);
unset($arrOptions['hdhezuokefu']);
unset($arrOptions['xingquqiyeqq']);
unset($arrOptions['wuzhongqiyeqq']);
unset($arrOptions['hdqyqq']);
unset($arrOptions['xingqubaidushangqiao']);
unset($arrOptions['wuzhongbaidushangqiao']);
unset($arrOptions['hdbaidushangqiao']);
unset($arrOptions['hdlaoliang']);
$form['field_qq_property']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_yixiangzhuanye_select']['value']['#options'];
unset($arrOptions['fzsj_wjc']);
unset($arrOptions['fzsj_yjc']);
unset($arrOptions['fzzb_wjc']);
unset($arrOptions['fzzb_yjc']);
unset($arrOptions['czby_wnz_dz']);
unset($arrOptions['gzby_snz_dz']);
unset($arrOptions['gjlt_cj']);
unset($arrOptions['fzcad_zb']);
unset($arrOptions['fzgy_ygy']);
unset($arrOptions['gd_licai']);
unset($arrOptions['gd_nvzhang']);
unset($arrOptions['gd_nanzhang']);
$form['field_yixiangzhuanye_select']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_baomingzuanye_select']['value']['#options'];
unset($arrOptions['fzsj_wjc']);
unset($arrOptions['fzsj_yjc']);
unset($arrOptions['fzzb_wjc']);
unset($arrOptions['fzzb_yjc']);
unset($arrOptions['czby_wnz_dz']);
unset($arrOptions['gzby_snz_dz']);
unset($arrOptions['gjlt_cj']);
unset($arrOptions['fzcad_zb']);
unset($arrOptions['fzgy_ygy']);
unset($arrOptions['gd_licai']);
unset($arrOptions['gd_nvzhang']);
unset($arrOptions['gd_nanzhang']);
$form['field_baomingzuanye_select']['value']['#options'] = $arrOptions;
$arrOptions = $form['field_dingjingzuanye_select']['value']['#options'];
unset($arrOptions['fzsj_wjc']);
unset($arrOptions['fzsj_yjc']);
unset($arrOptions['fzzb_wjc']);
unset($arrOptions['fzzb_yjc']);
unset($arrOptions['czby_wnz_dz']);
unset($arrOptions['gzby_snz_dz']);
unset($arrOptions['gjlt_cj']);
unset($arrOptions['fzcad_zb']);
unset($arrOptions['fzgy_ygy']);
unset($arrOptions['gd_licai']);
unset($arrOptions['gd_nvzhang']);
unset($arrOptions['gd_nanzhang']);
$form['field_dingjingzuanye_select']['value']['#options'] = $arrOptions;
// $export = kprint_r($form,TRUE);
// print $export;
$arrOptions = $form['field_suozaixiaoqu']['value']['#options'];
unset($arrOptions['xq']);
unset($arrOptions['wz']);
unset($arrOptions['hd']);
unset($arrOptions['sjsc']);
$form['field_suozaixiaoqu']['value']['#options'] = $arrOptions;
}
return $form;
}
//就在这里修改标签
function _setTitleForZg(&$elements,$title) {
foreach (element_children($elements) as $key) {
if (isset($elements[$key]) && $elements[$key]) {
// Recurse through all children elements.
_setTitleForZg($elements[$key],$title);
}
}
$elements['#title'] = $title;
}
function _zg_date_label($element){
$element[0]['value']['#title'] = '到院时间';
$element[0]['value2']['#title'] = '到院时间';
return $element;
}
function _afterFormForZg($form, &$form_state) {
$arg0 = arg(0);
$arg1 = arg(1);
$arg2 = arg(2);
$arg3 = arg(3);
if((($arg0=='node')&&($arg1=='add')&&($arg2=='kefuchat')&&($arg3=='zg')||
($arg0=='node')&&(is_numeric($arg1))&&($arg2=='edit')&&($arg3=='zg'))){
// $export = kprint_r($form['field_baoming_time'],TRUE);
// print $export;
_setTitleForZg($form['field_is_baoming'],'是否到院');
//到院时间标签的修改见 _zg_date_label 函数
_setTitleForZg($form['field_baomingzuanye_select'],'到院专业');
_setTitleForZg($form['field_baoming_writer'],'到院填写人');
_setTitleForZg($form['field_baoming_beizhu'],'到院备注');
// $export = kprint_r($form['field_baoming_time'],TRUE);
// print $export;
}
return $form;
}
function _after_build_kefuchat_node_form_validate($form, &$form_state) {
$form['#validate'][] = '_kefuchat_node_form_validation_two';
return $form;
}
普通分类: