<?php
// +----------------------------------------------------------------------
// | OneThink [ WE CAN DO IT JUST THINK IT ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013 http://www.onethink.cn All rights reserved.
// +----------------------------------------------------------------------
// | Author: huajie <banhuajie@163.com>
// +----------------------------------------------------------------------

namespace Admin\Model;
use Think\Model;

/**
 * 文档基础模型
 */
class ModelModel extends Model{

    /* 自动验证规则 */
    protected $_validate = array(
        array('name', 'require', '标识不能为空', self::MUST_VALIDATE , 'regex', self::MODEL_INSERT),
        array('name', '/^[a-zA-Z]\w{0,39}$/', '文档标识不合法', self::VALUE_VALIDATE, 'regex', self::MODEL_BOTH),
        array('name', '', '标识已经存在', self::VALUE_VALIDATE, 'unique', self::MODEL_BOTH),
        array('title', 'require', '标题不能为空', self::MUST_VALIDATE, 'regex', self::MODEL_BOTH),
        array('title', '1,30', '标题长度不能超过30个字符', self::MUST_VALIDATE, 'length', self::MODEL_BOTH),
    	array('list_grid', 'require', '列表定义不能为空', self::MUST_VALIDATE , 'regex', self::MODEL_UPDATE),
    );

    /* 自动完成规则 */
    protected $_auto = array(
    	array('name', 'strtolower', self::MODEL_INSERT, 'function'),
        array('create_time', NOW_TIME, self::MODEL_INSERT),
        array('update_time', NOW_TIME, self::MODEL_BOTH),
        array('status', '1', self::MODEL_INSERT, 'string'),
    	array('field_sort', 'getFields', self::MODEL_BOTH, 'callback'),
    );

    /**
     * 新增或更新一个文档
     * @return boolean fasle 失败 ， int  成功 返回完整的数据
     * @author huajie <banhuajie@163.com>
     */
    public function update(){
        /* 获取数据对象 */
        $data = $this->create();
        if(empty($data)){
            return false;
        }

        /* 添加或新增基础内容 */
        if(empty($data['id'])){ //新增数据
            $id = $this->add(); //添加基础内容
            $data['id'] = $id;
            if(!$id){
                $this->error = '新增模型出错！';
                return false;
            }
        } else { //更新数据
            $status = $this->save(); //更新基础内容
            if(false === $status){
                $this->error = '更新模型出错！';
                return false;
            }
        }
		// 清除模型缓存数据
		S('DOCUMENT_MODEL_LIST', null);

		//记录行为
		action_log('update_model','model',$data['id'] ? $data['id'] : $id,UID);

        //内容添加或更新完成
        return $data;
    }

    /**
     * 处理字段排序数据
     * @author huajie <banhuajie@163.com>
     */
    protected function getFields($fields){
    	return empty($fields) ? '' : json_encode($fields);
    }

    /**
     * 获取指定数据库的所有表名
     * @author huajie <banhuajie@163.com>
     */
    public function getTables($connection = null){
    	$tables = M()->query('SHOW TABLES;');
    	foreach ($tables as $key=>$value){
    		$tables[$key] = $value['Tables_in_'.C('DB_NAME')];
    	}
    	return $tables;
    }

    /**
     * 根据数据表生成模型及其属性数据
     * @author huajie <banhuajie@163.com>
     */
    public function generate($table){
    	//新增模型数据
    	$name = substr($table, strlen(C('DB_PREFIX')));
    	$data = array('name'=>$name, 'title'=>$name);
    	$data = $this->create($data);
    	$res = $this->add($data);
    	if(!$res){
    		return false;
    	}

    	//新增属性
		$fields = M()->query('SHOW FULL COLUMNS FROM '.$table);
		foreach ($fields as $key=>$value){
			//不新增id字段
			if(strcmp($value['Field'], 'id') == 0){
				continue;
			}

			//生成属性数据
			$data = array();
			$data['name'] = $value['Field'];
			$data['title'] = $value['Comment'];
			$data['type'] = 'string';	//TODO:根据字段定义生成合适的数据类型
			//获取字段定义
			$is_null = strcmp($value['Null'], 'NO') == 0 ? ' NOT NULL ' : ' NULL ';
			$data['field'] = $value['Type'].$is_null;
			$data['value'] = $value['Default'] == null ? '' : $value['Default'];
			$data['model_id'] = $res;
			$_POST = $data;		//便于自动验证
			D('Attribute')->update($data, false);
		}
    	return $res;
    }

    /**
     * 删除一个模型
     * @param integer $id 模型id
     * @author huajie <banhuajie@163.com>
     */
    public function del($id){
    	//获取表名
    	$model = $this->field('name')->find($id);
    	$table_name = C('DB_PREFIX').strtolower($model['name']);
    	//删除属性数据
    	M('Attribute')->where(array('model_id'=>$id))->delete();
    	//删除模型数据
    	$this->delete($id);
    	//删除该表
    	$sql = <<<sql
				DROP TABLE {$table_name};
sql;
    	$res = M()->execute($sql);
    	return $res !== false;
    }
}
