const HIDE_FIELD_LIST = 01; //列表时是否隐藏列

const HIDE_FIELD_ADD = 02; //增加数据时是否隐藏

const HIDE_FIELD_EDIT = 04; //修改数据时是否隐藏

const HIDE_FIELD_DATA = 010; //列表时，是否不输出此字段数据

const HIDE_FIELD_EXPORT = 020; //是否不导出

const HIDE_FIELD_PRINT = 040; //是否不打印

const HIDE_FIELD_IMPORT = 0100; //是否导入字段

const DP_TYPE_ENABLE = 01; //开启数据权限控制

const DP_TYPE_PUBLIC = 02; //开启公共数据权限，此字段判定，某个数据是否是公共数据。

const DP_TYPE_STATIC_AUTO = 04; //auto的静态设定

const FULLTEXT_MSG_NOT = 0; //不是消息

const FULLTEXT_MSG_NEW = 1; //未处理的消息

const FULLTEXT_MSG_OLD = 2; //已处理的消息

protected $listFields = array(); //模型字段的附加信息

protected $modelInfo = array(); //模型的附加信息。

private $cacheDictDatas = array(); //缓存的字典表数据

private $cacheListFields= array(); //缓存Model的listFileds数据，经过转换的结果

//数据权限相关

public $skipDataPowerCheck = false; //关闭数据权限域控制。

protected $viewTableName = ""; //可以是table，也可以是sql语句

protected $defaultWhere = array();

private $viewTableIsSelect = false;

protected $DP_POWER_FIELDS = array();

public $noDeleteSearchWhere = array();

protected $fullTextState = 0; //Model追加的fulltext数据的状态,一般在model的_before_insert _before_update中改变此属性

/* 将所有的数据库字段，全初始化为数据列表字段，默认使用数据库字段名 */

function initListFields(){

if(sizeof($this->listFields) > 0){

return;

}

$dbFields = $this->getDbFields();

$listF = array();

//dump($dbFields);die();

foreach($dbFields as $key => $val){

//0和字符串比较为真 所以用全等判断 不然索引为0的非主键字段也添加不到listFields当中

if($key!=="_autoinc" && $key!=="_pk"){

$listF[$val] = array("title"=>$val);

}

}

$this->listFields = $listF;

}

function __construct($name='',$tablePrefix='',$connection='') {

parent::__construct($name,$tablePrefix,$connection);

//modelInfo的初试值

$modelInfoInit = array(

"customRowAttribute"=>0,

"onComplete"=>0,

"enablePage"=>1,

"max_export"=>5000,

"addDialogButtons"=>"[]"

);

$this->modelInfo = array_merge($modelInfoInit,$this->modelInfo);

//根据model配置，自动生成数据验证条件

if(sizeof($this->listFields) > 0){

foreach($this->listFields as $name => $field){

switch($field["type"]){

case "idcard":

$year = substr(date("Y"),-2,1);

$idcardValid = array($name,"/^[0-9]{6}([0-9]{2}|1[89][0-9]{2}|2[01][0-".$year."][0-9])(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])[0-9]{2,3}[0-9Xx]$/","身份证格式不正确",Model::VALUE_VALIDATE,"regex");

$this->_validate = array_merge($this->_validate,array($idcardValid));

break;

}

}

}

$this->initListFields();

//自动填充默认字段create_time 和 update

$myFields = $this->getDbFields();

if(in_array("create_time", $myFields,true)){

$this->_auto = array_merge($this->_auto,array(array('create_time','DxFunction::getMySqlNow',self::MODEL_INSERT,'function')));

}

if(in_array("update_time", $myFields,true)){

$this->_auto = array_merge($this->_auto,array(array('update_time','DxFunction::getMySqlNow',self::MODEL_BOTH,'function')));

}

// 如果这个 Model 有创建人，创建部门，创建人所属区域，最后修改人 等字段时，

// 自动追加这些属性到 __auto 中,用Session对应的值，进行填充。

// 将这些数据打标签为 隶属于某人、某部门 。数据域权限控制时要用这些标签。

// dump($this->getDbFields());die();

$dbFields = $this->getDbFields();

$tDpFields = C('DP_POWER_FIELDS');

$tDpFields = array_merge($tDpFields,$this->DP_POWER_FIELDS);

if(isset($tDpFields) && is_array($tDpFields)){

foreach($tDpFields as $dp_fields){

if(intval($dp_fields["auto_type"])<1) continue; //不自动填充数据

$field_name = $dp_fields["field_name"];

$session_field_name = array_key_exists("session_field", $dp_fields)?$dp_fields["session_field"]:$field_name;

if(array_search($field_name,$dbFields)){

if(intval($dp_fields["type"])==self::DP_TYPE_STATIC_AUTO){

//设置默认值

$this->_auto = array_merge($this->_auto,

array(array($field_name,$session_field_name,$dp_fields["auto_type"]))

);

}else if(isset($_SESSION[$session_field_name])){

$this->_auto = array_merge($this->_auto,

array(array($field_name,$_SESSION[$session_field_name],$dp_fields["auto_type"]))

);

}

}

}

}

//Log::write(var_export($this->_auto,true).MODULE_NAME."|".ACTION_NAME,Log::INFO);

}

/**

public function getListFields($onlyCache=false,$original=false){

if($original) return $this->listFields;

$fieldsMd5 = $this->getListFieldsMd5();

if(empty($this->cacheListFields[$fieldsMd5]) || APP_DEBUG){

$listFs = $this->getCacheListFields($fieldsMd5);

}else{

$listFs = $this->cacheListFields[$fieldsMd5];

}

if($onlyCache){

fb::log($listFs,$this->name."->getListFieldsCache");

return $listFs;

}else{

//valCahnge数据。

$rvFields = array();

foreach($listFs as $key=>$field){

if($field["valChangeReadOnly"]!=true){

$rvFields[$key] = $this->getFieldValChange($field);

}

}

fb::log($rvFields,$this->name."->getListFields");

return $rvFields;

}

}

//获取字段的默认值，在新增数据时，需要

public function getListFieldDefault(){

$default = array();

foreach($this->getListFields() as $name=>$field){

if(array_key_exists("default",$field)){

$d = $field['default'];

if(is_array($d)){

switch($d["type"]){

case "func":

$func = $d["value"];

if(function_exists($func)){

$default[$name] = call_user_func_array($func, $d["other_info"]);

}

break;

case "class":

if(class_exists($d["value"]["className"])){

if(method_exists($d["value"]["className"],$d["value"]["methodName"])){

$classObj = new $d["value"]["className"];

$default[$name] = call_user_func_array(array($classObj,$d["value"]["methodName"]), $d["other_info"]);

}

}

break;

case "session":

$default[$name] = $_SESSION[$d["value"]];

break;

}

}else{

$default[$name] = $field["default"];

}

switch($field["type"]){

case "date":

if($field["default"]=="now"){

//date("Y-m-d H:i:s");

$default[$name] = date(str_replace(array("yyyy","MM","dd","HH","mm","ss"),array("Y","m","d","H","i","s"),$field["valFormat"]));

}

break;

case "canton":

if(empty($default[$name])) $default[$name] = C("ROOT_CANTON_FDN");

break;

}

}

//将valChange转换为字符数据。

if(array_key_exists("valChange", $field) && !empty($default[$name])){

$default[$name."_textTo"] = $field["valChange"][$default[$name]];

}

}

return $default;

}

// 将数据列表Grid要显示的字段，整合为一个字符串，作为SELECT 语句的字段列表

public function getListFieldString($table_alias="") {

return $this->getFieldsString ( self::HIDE_FIELD_DATA,$table_alias );

}

// 将要打印的字段，整合为一个字符串，作为SELECT 语句的字段列表

public function getPrintFieldString($table_alias="") {

return $this->getFieldsString ( self::HIDE_FIELD_PRINT,$table_alias );

}

private function getFieldsString($hideState,$table_alias="") {

$r = array ();

foreach ( $this->getNoHideFields ( $hideState,true ) as $key => $val ) {

if (isset ( $val ["field"] ))

$r [] = $table_alias.$val ["field"];

else if (isset ( $val ["name"] ))

$r [] = $table_alias.$val ["name"];

else

$r [] = $table_alias.$key;

}

return implode ( ",", $r );

}

public function getListFieldsMd5(){

return md5(json_encode($this->listFields));

}

public function getModelInfoMd5(){

return md5(json_encode($this->modelInfo));

}

private function getCacheListFields($fieldsMd5){

$cacheFile = 'dict_cache_'.$this->name."_listFields_".$fieldsMd5;

$info = S($cacheFile);

if(!empty($info) && !APP_DEBUG) return $info;

$tListFields = array();

foreach($this->listFields as $key=>$field){

$tListFields[isset($field["name"])?$field["name"]:$key] = $this->getOneListField($key,$field);

}

//转换Model的自动验证规则为formValidation形式

$tempValid = $this->convertValid($this->_validate);

// dump($this->_validate);dump($tempValid);

foreach($tempValid as $fld =>$vvvv){

$tListFields[$fld]["valid"][self::MODEL_INSERT] = "validate[".implode(",",$vvvv[self::MODEL_INSERT])."]";

$tListFields[$fld]["valid"][self::MODEL_UPDATE] = "validate[".implode(",",$vvvv[self::MODEL_UPDATE])."]";

$tListFields[$fld]["valid"]["validateMsg"] = $vvvv["validateMsg"];

$tListFields[$fld]["valid"]["regex"] = $vvvv["regex"];

}

S($cacheFile,$tListFields);

$this->cacheListFields[$fieldsMd5] = $tListFields;

return $tListFields;

}

private function getOneListField($key,$field){

if(!isset($field["name"])) $field["name"] = $key;

switch($field["type"]){

case "canton":

if(empty($field["width"])) $field["width"] = "180";

if(!empty($field['textTo']) && empty($field["texttoattr"])) $field["texttoattr"] = "full_name";

$field["valChange"] = "";

//因为canton的valchange内容太多，所以放到页面头部直接载入，每个field中不再体现。一个表中可能有多个canton字段。

// canton字段统一使用textTo属性进行字段值保存，避免展示的时候，进行数据转换。

// if(!($field["hide"] & self::HIDE_FIELD_DATA)){

// $data_change = $this->getModelInfo("data_change");

// $data_change[$field["name"]] = "cantonFdnToText";

// $this->setModelInfo("data_change",$data_change);

// }

break;

case "selectselectselect":

if(!empty($field['textTo']) && empty($field["texttoattr"])) $field["texttoattr"] = "full_name";

$field["width"] = "180";

break;

case "date":

if(empty($field["valFormat"])) $field["valFormat"] = "yyyy-MM-dd";

if(empty($field["width"])) $field["width"] = strlen($field["valFormat"])*6+10;

$start = strpos("yyyy-MM-dd HH:mm:ss",$field["valFormat"]);

if(empty($field["renderer"]) && $start!==false){

$field["renderer"] = sprintf("var valChange=function valChangeCCCC(value ,record,columnObj,grid,colNo,rowNo){if(value==null){return '';}else if(value.replace(/[:0\- ]*/,'','gi')=='') return '';return value.substr(%d,%d);}",$start,strlen($field["valFormat"]));

}

case "idcard":

if(empty($field["idcard"])) $field["idcard"] = "'birthday':'birthday','sex':'sex','id_reg_addr':'id_reg_addr'";

if(empty($field["width"])) $field["width"] = 140;

break;

case "tel":

if(empty($field["width"])) $field["width"] = 100;

break;

}

if(intval($field["width"])<1) $field["width"] = "80";

if(intval($field["export_width"])<1) $field["export_width"] = $field["width"];

if(intval($field["tdCols"])<1) $field["tdCols"] = 1;

//规整数据的enum字段，默认使用valChange替换，没有valChange字段，则从数据库获取enum的字段定义数据

if(empty($field["valChange"]) && array_key_exists("type", $field) && ($field["type"]=="enum" || $field["type"]=="set" || $field["type"]=="select")){

$sql = sprintf("SELECT COLUMN_TYPE FROM information_schema.`COLUMNS` WHERE DATA_TYPE in ('set','enum') AND `TABLE_SCHEMA`='%s' AND `TABLE_NAME`='%s' AND COLUMN_NAME='%s'",C("DB_NAME"),$this->trueTableName,$field["name"]);

$tField = $this->query($sql);

if(!empty($tField)){

//枚举类型的内部序号是从1开始。

$field["valChange"] = explode(",","0,".str_replace(array("'","(",")"),array("","",""), substr($tField[0]["COLUMN_TYPE"],5)));

unset($field["valChange"][0]);

$field["valChange"] = array_combine($field["valChange"],$field["valChange"]);

}else $field["valChange"] = array();

$field["valChangeReadOnly"] = false;

}

if($field["valChangeReadOnly"]){

$field = $this->getFieldValChange($field);

}

return $field;

}

//valChange分为固定和不固定的，固定的可以直接缓存到cache中，不固定的要每次获取（比如：对应到字典表的能够人工定义的数据）

private function getFieldValChange($field){

if($field["type"]=="selectselectselect"){

if(isset($field["valChange"]["model"])){

if($this->name==$field["valChange"]["model"]){

$m = $this;

}else{

$m = D($field["valChange"]["model"]);

}

$allDataVal = $m->getSelectSelectSelect();

$fdnTreeData = array();

foreach($allDataVal as $d){

if(!is_array($fdnTreeData[$d["parent_id"]])) $fdnTreeData[$d["parent_id"]] = array();

array_push($fdnTreeData[$d["parent_id"]],$d);

}

$field["fdnChange"] = $fdnTreeData;

}

}

if(is_array($field["valChange"])){

//将字典表，转换为valChange数据

if(isset($field["valChange"]["model"])){

if($this->name==$field["valChange"]["model"]){

$m = $this;

}else{

$m = D($field["valChange"]["model"]);

}

$tValC = $m->getCacheDictTableData();

}else if(array_key_exists("sql",$field["valChange"])){

//使用SQL获得valChange映射

$tValC = $this->query($field["valChange"]["sql"]);

if($tValC){

$tValC = DxFunction::arrayToArray($tValC);//原始值是$field["valChange"]

}

}else{

$tValC = $field["valChange"];

}

//找到数组的某一部分作为valChange转换，比如：大型数据字典 sysDic

if(!empty($field["valChange"]["type"])){

$tType = explode(",",$field["valChange"]["type"]);

foreach($tType as $vvv)

$tValC = $tValC[$vvv];

}

if(is_array($tValC)) $field["valChange"] = $tValC;

else $field["valChange"] = array();

fb::log($field,$this->name."-fieldsValChange");

}

return $field;

}

// 通过key改变model的listFields属性

public function setListField($key, $v, $start=0) {

$field = array();

if(empty($this->listFields [$key]))

$field = array($key=>$v);

else

$field = array($key=>array_merge ( $this->listFields [$key], $v ));

if($start==0){

$this->listFields[$key] = $field[$key];

}else{

$field[$key]["name"] = $key;

array_splice($this->listFields,intval($start),0,$field);

}

}

//新增一个字段

public function addListField($field) {

if(is_array($field)) $this->listFields = array_merge ( $this->listFields, $field );

}

public function getEditFields($pkId=0){

//编辑数据的字段列表，编辑数据时，要隐藏某些字段

$f = array();

foreach($this->getListFields() as $name=>$field){

//修改和新增时隐藏可以分别定义 新增和修改时的readOnly可以分别定义

if(!($field["hide"] & self::HIDE_FIELD_ADD) && $pkId==0){

$f[$field["name"]] = $field;

$f[$field["name"]]["readOnly"] = (bool)($field["readOnly"] & self::HIDE_FIELD_ADD);

$f[$field["name"]]["display_none"] = (bool)($field["display_none"] & self::HIDE_FIELD_ADD);

}else if(!($field["hide"] & self::HIDE_FIELD_EDIT) && $pkId>0){

$f[$field["name"]] = $field;

$f[$field["name"]]["readOnly"] = (bool)($field["readOnly"] & self::HIDE_FIELD_EDIT);

$f[$field["name"]]["display_none"] = (bool)($field["display_none"] & self::HIDE_FIELD_EDIT);

}

}

return $f;

}

public function getModelInfo($key=""){

if(empty($key)){

return $this->modelInfo;

}

$val = $this->modelInfo[$key];

if($key=="order" && empty($val)) $val = $this->getPk()." desc";

return $val;

}

public function setModelInfo($key,$val){

$this->modelInfo[$key] = $val;

}

public function setLeftMenu($parentId){

//左边菜单的父ID,此菜单属于那个id的子菜单

$this->modelInfo["leftArea"] = "{:W('Menu',array('type'=>\$type,'parent_id'=>".$parentId."))}";

}

/**

public function getExportFields(){

return $this->getNoHideFields(self::HIDE_FIELD_EXPORT);

}

public function getPrintFields(){

return $this->getNoHideFields(self::HIDE_FIELD_PRINT);

}

public function getImportFields(){

return $this->getNoHideFields(self::HIDE_FIELD_IMPORT);

}

/**

private function getNoHideFields($hideTag,$cacheFields=false){

//编辑数据的字段列表，编辑数据时，要隐藏某些字段

$f = array();

$frozen=array();

foreach($this->getListFields($cacheFields) as $key=>$field){

//默认导出所有的列

if(!($field["hide"] & $hideTag)){

$fieldName = empty($field['name'])?$key:$field['name'];

if(isset($field['frozen']) && $field['frozen']){

$frozen[$fieldName]=$field;

}else{

$f[$fieldName] = $field;

}

}

}

//用于保证frozen的列出现在列表的前方.

return array_merge($frozen, $f);

}

/**

public function fieldToGridField(){

$gridFields = array();

if($this->getModelInfo("hasCheckBox")){

$gridFields[0] = array("id"=>"chk[]","isCheckColumn"=>true,"header"=>"全选");

}

$datasetFields = array();

$lFields = $this->getListFields();

foreach($lFields as $fieldNameKey => $field){

$fieldName = empty($field["name"])?$fieldNameKey:$field["name"];

if(!($field["hide"] & self::HIDE_FIELD_LIST)){

$gridHeader = empty($field["danwei"])?$field["title"]:$field["title"]."(".$field["danwei"].")";

$gridField = array (

"id" => $fieldName,

"header" => $gridHeader,

"frozen" => ( bool ) ($field ["frozen"]),

"grouped" => ( bool ) ($field ["grouped"]),

"isCheckColumn"=>(bool)($field["isCheckColumn"]),

"width" => $field ["width"]

);

if(!empty($field["renderer"])){

$gridField["renderer"] = $field["renderer"];

}else{

$valueToJson = "";

if($field["type"]=="uploadFile"){

$url = sprintf("<a href='%s/Basic/download?f=%s&n=%s' download='%s' target='download'>%s</a>",__ROOT__,urlencode($file["url"]),urlencode($file["real_name"]),htmlentities($file["real_name"],ENT_QUOTES,'UTF-8'),htmlentities($file["real_name"],ENT_QUOTES,'UTF-8'));

$valueToJson = "if(value[0]=='['){value = eval(value);var r='';$(value).each(function(i,v){r+='<a href=\"' + APP_URL + '/Basic/download?f=' + v['url'] + '&n=' + v['real_name'] + '\">' + v['real_name']+'</a><br />';});return r;}else{return value;}";

}else if(is_array($field["valChange"])){

//set 存储的数据是json数据；

if($field["type"]=="set"){

if($field["valFormat"]=="json"){

$valueToJson = "if(value[0]=='['){value = eval(value);var r='';$(value).each(function(i,v){r+=valChangeDatas[v]+' ';});return r;}else{return value;}";

}else{

$valueToJson = "if(value=='') return '';var value = value.split(',');var r='';$(value).each(function(i,v){if(valChangeDatas[v]!=undefined) r+=valChangeDatas[v]+' ';});return r;";

}

}

else $valueToJson = "return valChangeDatas[value];";

}

if(!empty($valueToJson)) $gridField["renderer"] = sprintf("var valChange=function valChangeCCCC(value ,record,columnObj,grid,colNo,rowNo){ var valChangeDatas=%s;%s}",json_encode($field["valChange"]),$valueToJson);

}

//数据转换

if(isset($field["renderer"])) $gridField["renderer"] = $field["renderer"];

$gridFields[] = $gridField;

}

if(!($field["hide"] & self::HIDE_FIELD_DATA)){

$datasetField = array("name"=>$fieldName,"type"=>empty($field["type"])?"string":$field["type"]);

$datasetFields[] = $datasetField;

}

}

// fb::log($datasetFields);fb::log($gridFields);

return array("gridFields"=>$gridFields,"datasetFields"=>$datasetFields);

}

/**

public function getDefaultWhere(){

return $this->defaultWhere;

}

public function setViewTableName($sql){

$this->viewTableName = $sql;

}

public function find($options = array()) {

if(!empty($this->viewTableName)){

//$orgTableName = $options["table"];

$options["table"] = $this->viewTableName;

$this->viewTableIsSelect = true;

$res = parent::find($options);

$this->viewTableIsSelect = false;

//$options["table"] = $orgTableName;

}else

$res = parent::find($options);

return $res;

}

public function select($options=array()){

if(!empty($this->viewTableName)){

//$orgTableName = $options["table"];

$options["table"] = $this->viewTableName;

$this->viewTableIsSelect = true;

$res = parent::select($options);

$this->viewTableIsSelect = false;

//$options["table"] = $orgTableName;

}else{

$res = parent::select($options);

}

return $res;

}

public function getField($field,$sepa=null) {

if(!empty($this->viewTableName)){

//$orgTableName = $options["table"];

$this->options["table"] = $this->viewTableName;

$this->viewTableIsSelect = true;

$res = parent::getField($field,$sepa);

$this->viewTableIsSelect = false;

//$options["table"] = $orgTableName;

}else{

$res = parent::getField($field,$sepa);

}

return $res;

}

//将find的数据，进行数据转换，从而能够直接显示数据。

public function getInfo($listFields=""){

$vo = $this->find();

return $this->findToInfo($vo,$listFields);

}

public function findToInfo($vo,$listFields=""){

if(empty($listFields)) $listFields = $this->getListFields();

//将set、enum数据进行转换，为了显示具体的数据。。

foreach($listFields as $field){

if(!array_key_exists($field["name"],$vo)) continue;

if($field["type"]=="date"){

if(substr($vo[$field["name"]],0,10)=="0000-00-00") $vo[$field["name"]] = "";

}else if(!empty($field["valChange"]) && empty($field["textTo"])){

switch($field["type"]){

case "set":

if($field["valFormat"]=="json"){

$tVals = json_decode($vo[$field["name"]],true);

}else{

$tVals = explode(",",$vo[$field["name"]]);

}

foreach($tVals as $tv){

if($tv!="" && $tv!=0){

$vo[$field["name"]."_textTo"][] = $field["valChange"][$tv];

}

}

$vo[$field["name"]."_textTo"] = implode(",",$vo[$field["name"]."_textTo"]);

break;

default:

$vo[$field["name"]."_textTo"] = $field["valChange"][$vo[$field["name"]]];

break;

}

}

}

return $vo;

}

/*

public function getInfoToText($dataInfo,$listFields=""){

if(empty($dataInfo)) return $dataInfo;

if(empty($listFields)) $listFields = $this->getEditFields();

foreach($listFields as $field){

if($field["type"]=="cutPhoto"){

$dataInfo[$field["name"]] = "http://".$_SERVER["HTTP_HOST"].__APP__."/Basic/showImg?f=".$dataInfo[$field["name"]];

}else if(!empty($field["valChange"])){

if(empty($field["textTo"])){

$dataInfo[$field["name"]] = $dataInfo[$field["name"]."_textTo"];

}else{

$dataInfo[$field["name"]] = $dataInfo[$listFields[$field["textTo"]]];

}

}

}

return $dataInfo;

}

//3.1.2居然删除了配置 DB_FIELDTYPE_CHECK ，这里只能恢复他。

protected function _parseOptions($options=array()) {

if(is_array($options))

$options = array_merge($this->options,$options);

// 查询过后清空sql表达式组装 避免影响下次查询

$this->options = array();

if(!isset($options['table'])){

// 自动获取表名

$options['table'] = $this->getTableName();

$fields = $this->fields;

}else{

// 指定数据表 则重新获取字段列表 但不支持类型检测

$fields = $this->getDbFields();

}

if(!empty($options['alias'])) {

$options['table'] .= ' '.$options['alias'];

}

// 记录操作的模型名称

$options['model'] = $this->name;

// 字段类型验证

if(C('DB_FIELDTYPE_CHECK') && isset($options['where']) && is_array($options['where']) && !empty($fields)) {

// 对数组查询条件进行字段类型检查

foreach ($options['where'] as $key=>$val){

$key = trim($key);

if(in_array($key,$fields,true)){

if(is_scalar($val)) {

$this->_parseType($options['where'],$key);

}

}elseif('_' != substr($key,0,1) && false === strpos($key,'.') && false === strpos($key,'|') && false === strpos($key,'&')){

unset($options['where'][$key]);

}

}

}

// 表达式过滤

$this->_options_filter($options);

return $options;

}

/** 自动增加数据权限功能，在所有的查询语句中追加数据权限控制条件 **/

protected function _options_filter(&$options) {

/**

if(APP_DEBUG) Log::write(var_export($options,true).MODULE_NAME."|".ACTION_NAME."__options",Log::INFO);

if($this->skipDataPowerCheck

|| DxFunction::checkInNotArray(C('DP_NOT_CHECK_MODEL'),array(),$this->name)

|| in_array($_SESSION["role_id"], C("DP_NOT_CHECK_ROLE"))

){

return;

}

$dataPowerFieldW = array();

$dataPowerFieldPublic = "";

//查询的时候，需要根据视图sql进行数据权限的判定，但是在 修改时 就只能使用dbfileds进行

if($this->viewTableIsSelect) $dbFields = array_keys($this->getListFields(false,true));

else $dbFields = $this->getDbFields();

$dataPowerFieldDelete = "";

//if(APP_DEBUG) Log::write(var_export($dbFields,true).MODULE_NAME."|".ACTION_NAME."__dbFields",Log::INFO);

//追加数据删除字段标志,,直接追加Where条件。

if(is_array(C('DELETE_TAGS'))){

foreach(C('DELETE_TAGS') as $key=>$val){

if(in_array($key,$dbFields)){

$dataPowerFieldDelete[] = sprintf("%s!='%s'",$key,$val);

}

}

}

$tDpFields = C('DP_POWER_FIELDS');

$tDpFields = array_merge($tDpFields,$this->DP_POWER_FIELDS);

//dump($this->getModelName());dump($tDpFields);

if(is_array($tDpFields) && sizeof($tDpFields)>0 && (!array_key_exists("DP_ADMIN", $_SESSION) || !$_SESSION["DP_ADMIN"])){

//为了提高代码执行效率

//某些模块不需要进行数据域验证，比如：登录；；管理员也不受此限制

if(!DxFunction::checkNotAuth(C('DP_NOT_CHECK_ACTION'))){

//方法一、是将表名直接转换为一个SQL子语句。。。这个要处理UPDATE太麻烦。

// $dataPowerTable = sprintf("(SELECT * FROM %s WHER %s like '%s%%' AND %s like '%s%%')",

// $options['table'],C("DX_DATA_POWER_DEPT"),$_SESSION["dept_code"],C("DX_DATA_POWER_AREA"),$_SESSION["area_code"]);

//

// if(!empty($options['alias'])) {

// $options['select_table'] = $dataPowerTable.' '.$options['alias'];

// }else{

// $options['select_table'] = $dataPowerTable.' '.$options['table'];

// }

//方法二、将所有的where追加一些条件。难点是要判断where的类型：string、array、object

// print_r($dp_fields);

foreach($tDpFields as $dp_fields){

$dataPowerOneW = array();

$field_name = $dp_fields["field_name"];

//如果没有定义session的名称，则使用字段名称。

if(array_key_exists("session_field", $dp_fields)) $session_field_name = $dp_fields["session_field"];

else $session_field_name = $field_name;

//dump(7777);

//dump("field".var_export($dp_fields,true).MODULE_NAME."|".ACTION_NAME."__DP_POWER_FIELDS",Log::INFO);

//dump("field".var_export($dbFields,true).MODULE_NAME."|".ACTION_NAME."__DBFIELDs",Log::INFO);

if($dp_fields["type"] & self::DP_TYPE_ENABLE && isset($_SESSION[$session_field_name]) && array_search($field_name,$dbFields,true)){

//dump($session_field_name."_field_".var_export($_SESSION,true).MODULE_NAME."|".ACTION_NAME."SESSION",Log::INFO);

if(is_array($_SESSION[$session_field_name])){

foreach($_SESSION[$session_field_name] as $key=>$val){

if(!empty($val)){

switch($dp_fields["operator"]){

case "eq":

$dataPowerOneW[] = sprintf("%s='%s'",$field_name,$val);

break;

default:

$dataPowerOneW[] = sprintf("%s like '%s%%'",$field_name,$val);

break;

}

}

}

}else if(!empty($_SESSION[$session_field_name])){

switch($dp_fields["operator"]){

case "eq":

$dataPowerOneW[] = sprintf("%s='%s'",$field_name,$_SESSION[$session_field_name]);

break;

default:

$dataPowerOneW[] = sprintf("%s like '%s%%'",$field_name,$_SESSION[$session_field_name]);

break;

}

}

}

if($dp_fields["type"]&self::DP_TYPE_PUBLIC && array_search($field_name,$dbFields,true)){

$dataPowerFieldPublic = $field_name."=1";

}

if(!empty($dataPowerOneW))

{

$dataPowerFieldW[] = "(".implode(" OR ",$dataPowerOneW).")";

}

}

}

}

//dump($this->name);dump($dataPowerFieldW);

//大部分人员，喜欢使用管理员来操作数据，所以删除标记的数据，管理员也不能看到。

$tempOptionsWhere = "";

if(!empty($dataPowerFieldW))

$tempOptionsWhere = $this->addOptionsWhere($dataPowerFieldPublic,implode(" AND ",$dataPowerFieldW),"OR");

$tempOptionsWhere = $this->addOptionsWhere($tempOptionsWhere,implode(" AND ",$dataPowerFieldDelete),"AND");

$options["where"] = $this->addOptionsWhere($options["where"],$tempOptionsWhere,"AND");

//dump($dataPowerFieldW);dump($options["where"]);

if(APP_DEBUG) Log::write(var_export($dataPowerFieldDelete,true).$this->name."|".MODULE_NAME."|".ACTION_NAME."dataPowerFieldDelete",Log::INFO);

if(APP_DEBUG) Log::write(var_export($dataPowerFieldW,true).MODULE_NAME."|".ACTION_NAME."dataPowerFieldW",Log::INFO);

if(APP_DEBUG) Log::write(var_export($dataPowerFieldPublic,true).MODULE_NAME."|".ACTION_NAME."dataPowerFieldPublic",Log::INFO);

}

//为Options的Where增加条件。

public function addOptionsWhere($opWhere,$dataPowerWhere,$type="AND"){

if(empty($dataPowerWhere)) return $opWhere;

if(!isset($opWhere) || (is_string($opWhere) && trim($opWhere)=="") || (is_array($opWhere) && sizeof($opWhere)==0)){

$opWhere = $dataPowerWhere;

}else if(is_string($opWhere)){

$opWhere = "(".$opWhere.") ".$type." ".$dataPowerWhere;

}else if(is_array($opWhere) || is_object($opWhere)){

if(is_object($opWhere)) $opWhere = get_object_vars_final($opWhere);

if(sizeof($opWhere)>0){

$where['_complex'] = $opWhere;

$where['_string'] = $dataPowerWhere;

$where['_logic'] = $type;

$opWhere = $where;

}

}

return $opWhere;

}

//将Model数据作为缓存进行存储,目前用于SysSetting的设置

public function cacheDataToConfig($reset=false){

$modelName = $this->getModelName();

$sysSetData = S("Cache_Global_".$modelName);

if(empty($sysSetData) || $reset || C("APP_DEBUG")){

$sysSetData = $this->select();

S("Cache_Global_".$modelName,$sysSetData);

}

foreach($sysSetData as $set){

C($modelName.".".$set["name"],$set["val"]);

}

}

public function getCacheDictTableData($dictConfig=""){

return $this->setCacheDictTableData($dictConfig);

}

/**

protected function deleteCacheDictTableData(){

$cacheNames = S('dict_cache_'.$this->name);

fb::log($cacheNames,$this->name."-deleteCacheDictTableData");

if(!empty($cacheNames)){

foreach ($cacheNames as $key => $value) {

fb::log($value,$this->name."-deleteCacheDictTableData");

S($value,null);

}

S('dict_cache_'.$this->name,null);

}

}

protected function setCacheDictTableData($dictConfig=""){

if(empty($dictConfig)){

$dictConfig = $this->getModelInfo("dictTable");

}

if(empty($dictConfig)) return array();

if(is_array($dictConfig)){

$configMd5 = md5(json_encode($dictConfig));

}else{

$configMd5 = md5($dictConfig);

}

if($this->getModelInfo("dictType")=="mySelf") $userId = intval($_SESSION[C("USER_AUTH_KEY")]);

else $userId = 0;

$cacheFileName = 'dict_cache_'.$this->name."_".$userId."_".$configMd5."_dict";

fb::log($cacheFileName,$this->name."-setCacheDictTableData");

$this->cacheDictDatas = S($cacheFileName);

if(!empty($this->cacheDictDatas) && !APP_DEBUG){

return $this->cacheDictDatas;

}

if(!empty($dictConfig)) {

if(is_array($dictConfig)) $dictConfig = implode(",",$dictConfig); //兼容老格式

if(sizeof(explode(",",$dictConfig))<2) $dictConfig = $this->getPk().",".$dictConfig; //使用主键作为key

$tV = $this->field($dictConfig)->select();

fb::log($this->getLastSQL());

if($tV){

$this->cacheDictDatas = DxFunction::arrayToArray($tV);

}

//缓存cacheName。用于清除缓存。

$cacheNames = S('dict_cache_'.$this->name);

if(empty($cacheNames)){

$cacheNames = array($cacheFileName);

}else if(!in_array($cacheFileName,$cacheNames)){

$cacheNames[] = $cacheFileName;

}

S('dict_cache_'.$this->name,$cacheNames);

fb::log($cacheNames);

S($cacheFileName,$this->cacheDictDatas);

return $this->cacheDictDatas;

}

return array();

}

/**

protected function updateTextTo($data,$isdel=false){