<?php return array (

   'data_source' => 'core',

   'table' => 'post',

   'fields' =>

   array (

     'id' =>

     array (

       'label' => 'ID',

       'form' =>

       array (

         'show' => true,

         'hidden' => true,

         'type' => 'text',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => true,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => '',

         'foreign_key' => '',

         'show' => '',

         'as' => '',

       ),

     ),

     'title' =>

     array (

       'label' => '标题',

       'form' =>

       array (

         'show' => true,

         'hidden' => false,

         'type' => 'text',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => true,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => '',

         'foreign_key' => '',

         'show' => '',

         'as' => '',

       ),

     ),

     'short' =>

     array (

       'label' => '摘要',

       'form' =>

       array (

         'show' => true,

         'hidden' => false,

         'type' => 'textarea',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => true,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => 'category',

         'foreign_key' => 'id',

         'show' => 'id',

         'as' => '',

       ),

     ),

     'content' =>

     array (

       'label' => '正文',

       'form' =>

       array (

         'show' => true,

         'hidden' => false,

         'type' => 'wysiwyg',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => false,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => 'category',

         'foreign_key' => 'id',

         'show' => 'id',

         'as' => '',

       ),

     ),

     'view_ct' =>

     array (

       'label' => '查看次数',

       'form' =>

       array (

         'show' => false,

         'hidden' => false,

         'type' => 'text',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => true,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => '',

         'foreign_key' => '',

         'show' => '',

         'as' => '',

       ),

     ),

     'created_at' =>

     array (

       'label' => '创建时间',

       'form' =>

       array (

         'show' => false,

         'hidden' => false,

         'type' => 'text',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => false,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => '',

         'foreign_key' => '',

         'show' => '',

         'as' => '',

       ),

     ),

     'updated_at' =>

     array (

       'label' => '更新时间',

       'form' =>

       array (

         'show' => false,

         'hidden' => false,

         'type' => 'text',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => true,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => '',

         'table' => '',

         'foreign_key' => '',

         'show' => '',

         'as' => '',

       ),

     ),

     'category_id' =>

     array (

       'label' => '栏目',

       'form' =>

       array (

         'show' => true,

         'hidden' => false,

         'type' => 'select',

         'rule' => 'required',

         'ajax_validate' => false,

         'placeholder' => '',

       ),

       'list' =>

       array (

         'show' => true,

         'sort' => true,

         'search' => '=',

         'lookup' => false,

       ),

       'relation' =>

       array (

         'type' => 'belongsTo',

         'table' => 'category',

         'foreign_key' => 'id',

         'show' => 'title',

         'as' => 'category_title',

       ),

     ),

   ),

   'list_options' =>

   array (

     'page' => 10,

     'create' => true,

     'update' => true,

     'delete' => true,

   ),

   'form_options' =>

   array (

     'layout' =>

     array (

       'cols' => 12,

       'label_cols' => 1,

       'input_cols' => 11,

     ),

   ),

   'relations' =>

   array (

     'id' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'title' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'short' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'content' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'view_ct' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'created_at' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'updated_at' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

     'category_id' =>

     array (

       'type' => '',

       'table' => '',

       'foreign_key' => '',

       'show' => '',

       'as' => '',

     ),

   ),

 );

 <?php

 /**

  * Created by PhpStorm.

  * User: lvyahui

  * Date: 2016/5/12

  * Time: 15:35

  */

 namespace admin;

 use BaseModel;

 use Illuminate\Support\Facades\Config;

 use Illuminate\Support\Facades\Redirect;

 use SiteHelpers;

 use Illuminate\Support\Facades\Response;

 use Illuminate\Support\Facades\Input;

 use PDOException;

 use PDO;

 class DataSourceController extends AdminController

 {

     /**

      * 呈现数据源列表

      */

     public function getList()

     {

         $datasources = SiteHelpers::loadDataSources();

         $this->makeView(array(

             'datasources' => $datasources,

         ));

     }

     /**

      * 异步加载某数据源的所有数据表

      * @return \Illuminate\Http\JsonResponse

      */

     public function getTables()

     {

         $dataSourceName = Input::get("data_source");

         $dataSources = SiteHelpers::loadDataSources();

         $dataSource = $dataSources[$dataSourceName];

         $tables = BaseModel::getTableList($dataSource['database'], $dataSourceName);

         return Response::json(array(

             'success' => true,

             'data'    => array(

                 'tables'   => $tables,

                 'selected' => Input::get('table'),

             ),

         ));

     }

     /**

      * 呈现数据源编辑或者新建FORM

      * @param null $slug

      */

     public function getEdit($slug = null)

     {

         $dataSource = null;

         if ($slug) {

             // 更新

             $dataSource = $slug === 'core' ? Config::get('database.connections.core')

                 : Config::get('datasource.' . $slug);

             $dataSource['name'] = $slug;

         } else {

             // 新建

             $dataSource = array(

                 'name'     => '',

                 'driver'   => 'mysql',

                 'host'     => 'localhost',

                 'port'     => 3306,

                 'database' => '',

                 'username' => 'root',

                 'password' => '',

                 'charset'  =>   'utf8',

                 'collation' =>  'utf8_unicode_ci'

             );

         }

         $this->makeView(array(

             'dataSource'    =>  $dataSource

         ));

     }

     /**

      * 测试数据源连接是否可靠

      * @return \Illuminate\Http\JsonResponse

      */

     public function postTest(){

         $success = true;

         try{

             $dsn = Input::get('driver').':'.Input::get('host').':'.Input::get('port').';dbname='.Input::get('database');

             $dbh = new \PDO($dsn,Input::get('username'),Input::get('password'));

 //            $connection = new Connection($dbh,Input::get('database'));

 //            $key = md5(date("Y-m-d H:i:s"));

 //            DB::addConnection($key,$connection);

 //            if(!DB::connection($key)->getDatabaseName()){

 //                $success = false;

 //            }

             $dbh = null;

         }catch(PDOException  $e){

             $success = false;

         }

         return Response::json(array(

             'success'   =>  $success,

         ));

     }

     /**

      * 保存编辑好的数据源信息

      * @param null $primaryKeyValue

      * @return mixed

      */

     public function postEdit($primaryKeyValue = null)

     {

         $dataSources = SiteHelpers::loadDataSources();

         $name = Input::get('name');

         $dataSources[$name] = Input::all();

         SiteHelpers::saveDataSources($dataSources);

         return Redirect::action(get_class($this).'@getList');

     }

     public function getTableFields(){

         $connection = Input::get('connection');

         $table = Input::get('table');

         $rawFields = BaseModel::getTableColumns($table,$connection);

         $fields = array();

         $pri = null;

         foreach($rawFields as $field){

             if($field->Key === 'PRI'){

                 $pri = $field->Field;

             }

             $fields [] = $field->Field;

         }

         return Response::json(array(

             'success'   =>  true,

             'data'  =>  array(

                 'fields'    =>  $fields,

                 'pri'       =>  $pri,

             ),

         ));

     }

 }

 <?php

 namespace admin;

 use Illuminate\Support\Facades\Request;

 use Illuminate\Support\Facades\Response;

 use Illuminate\Support\Facades\Redirect;

 use Illuminate\Support\Facades\Input;

 use Illuminate\Support\Facades\Config;

 use Illuminate\Support\Facades\View;

 use Illuminate\Support\Facades\Cache;

 use Illuminate\Support\Facades\URL;

 use SiteHelpers;

 use Module;

 class AdminController extends \BaseController

 {

     protected $layout = 'layouts.admin.main';

     /**

      * AdminController constructor.

      */

     public function __construct()

     {

         parent::__construct();

         View::share('stdName',$this->getStdName());

         View::share('reducName',SiteHelpers::reducCase($this->getStdName()));

         View::share('routeParams',$this->getRouteParams());

         if($this->model){

             $this->assignModel($this->model);

         }

         View::share('config',$this->savedConfig);

         if(!Cache::has('modules')){

             Cache::forever('modules',Module::all());

         }

     }

     public function getList(){

         $models = $this->paginateModels();

         $view = $this->getRouteParam('c').'._list';

         if(!View::exists($view)){

             $view = 'admin.core.list';

         }

         if(Request::ajax() || Input::has('isAjax')){

             return Response::json(array(

                'success'    =>  true,

                 'data'      =>  array(

                     'models'    =>  $models->toArray()

                 )

             ));

         }else{

             $this->makeView(array(

                 'models'  =>  $models,

                 $this->getStdName().'s' =>  $models,

             ),$view);

         }

     }

     public function getEdit($id = null)

     {

         if($id){

             $this->model = $this->model->find($id);

         }

         $data = array(

             $this->model->getKeyName() => $id,

             'model'   =>  $this->model,

             $this->modelName=>$this->model,

         );

         $this->beforeEdit($data);

         $view = $this->getRouteParam('c').'._form';

         if(!View::exists($view)){

             $view = 'admin.core.form';

         }

         $this->makeView($data,$view);

     }

     protected function config(){

         $config = 'crud/'.$this->getStdName();

         if(!file_exists(app_path('config/').$config.'.php')){

             $config = 'crud/admin';

         }

         return Config::get($config);

     }

     protected function assignModel($model)

     {

         $this->model = $model;

         $config = $this->config();

         $defaultConfig = Config::get('crud/admin');

         $relations = array();

         /* 将默认参数传递给module config */

         foreach($config['fields']   as $field => &$fieldConfig){

 //            if(isset($fieldConfig['value'])){

 //                $this->model->$field = $fieldConfig['value'];

 //            }

             $fieldConfig['form'] = array_merge(

                 $defaultConfig['fields']['field_name']['form'],

                 isset($fieldConfig['form']) ? $fieldConfig['form'] : array()

             );

             $fieldConfig['list'] = array_merge(

                 $defaultConfig['fields']['field_name']['list'],

                 isset($fieldConfig['list']) ? $fieldConfig['list'] : array()

             );

             if(isset($fieldConfig['relation']) &&

                 isset($fieldConfig['relation']['type']) && $fieldConfig['relation']['type'] !== '' ){

                 $relations[$field] = $fieldConfig['relation'];

             }

         }

         $config['list_options'] = array_merge(

             $defaultConfig['list_options'],

             isset($config['list_options']) ? $config['list_options'] : array()

         );

         $config['form_options'] = array_merge(

             $defaultConfig['form_options'],

             isset($config['form_options']) ? $config['form_options'] : array()

         );

         /* 将字段的relation汇聚出来，是为了后面的代码方便，同时减少循环 */

         $config['relations'] = $relations;

         $this->savedConfig = $config;

     }

     protected function paginateModels()

     {

         $models = array();

         if($this->model){

             $query = $this->model->newQuery();

             $this->handleListQuery($query);

             $selects = array($this->model->getTable().'.*');

             foreach($this->savedConfig['relations'] as $field=>&$params){

                 $query->join($params['table'],$params['table'].'.'.$params['foreign_key'],'=',$this->model->getTable().'.'.$field);

                 if(!isset($params['as'])){

                     $params['as'] = $params['table'].'_'.$params['show'];

                 }

                 $selects[] = $params['table'].'.'.$params['show'] . ' as '.$params['as'];

             }

             $query->select($selects);

             $orderBy = Input::get('list_order_by');

             if( $orderBy){

                 $query->orderBy($this->model->getTable().'.'.$orderBy,Input::get('list_sort_asc') ? 'asc' : 'desc');

             }else{

                 $query->orderBy($this->model->getTable().'.'.$this->model->getKeyName(),'desc');

             }

             $page = Input::has('_page') ? Input::get('_page') : 10;

             $models = $query->paginate($page);

         }

         return $models;

     }

     public function postEdit($primaryKeyValue = null){

         $primaryKeyName = $this->model->getKeyName();

         if($primaryKeyValue == null){

             $primaryKeyValue = Input::get($primaryKeyName);

         }

         $fields = $this->savedConfig['fields'];

         $datas = array();

         foreach($fields as $field => $fieldConfig){

             if(Input::has($field)){

                 $datas[$field] = Input::get($field);

             }

         }

         if($primaryKeyValue){

             $this->model->where($primaryKeyName,$primaryKeyValue)->update($datas);

         }else{

             $this->model->fill($datas);

             $this->model->save();

         }

         $this->afterSave($this->model);

         $resp = Redirect::action(get_class($this).'@getList')->withMessage('save success!');

         return $resp;

     }

     public function getIndex()

     {

         $this->makeView(null,'admin.index');

     }

     public function postDelete(){

         $ids = explode(',',Input::get('ids'));

         $data = array();

         $success   =  true;

         $data['ids'] = $ids;

         $ids = array_filter($ids,function($id){

             return $id;

         });

         $this->model->whereIn($this->model->getKeyName(),$ids)->delete();

         $data['redirect_url'] = URL::to(action(get_class($this).'@getList'));

         return Response::json(array(

             'success'   =>  $success,

             'data'      =>  $data,

         ));

     }

     public function getDelete($id){

         $this->beforeDelete($id);

         $this->model->where($this->model->getKeyName(),$id)->delete();

         return Redirect::action(get_class($this).'@getList');

     }

     public function missingMethod($parameters = array())

     {

         //

         $this->makeView(null,'site.404');

     }

     protected function handleListQuery(&$query)

     {

         $searchFields = array_intersect_key($this->savedConfig['fields'],Input::all());

         foreach($searchFields as $field=> $fieldConfig){

             if(isset($fieldConfig['list']['search'])){

                 $value = Input::get($field);

                 $operator = $fieldConfig['list']['search'];

                 if($value !== ''){

                     if($operator){

                         if($operator === 'like'){

                             $value = '%'.$value.'%';

                         }

                         $query = $query->where($this->model->getTable().'.'.$field,$operator,$value);

                     }else{

                         $query = $query->where($this->model->getTable().'.'.$field,$value);

                     }

                 }

             }

         }

     }

     protected function beforeDelete($id)

     {

     }

     protected function beforeEdit(&$data)

     {

     }

     protected function afterSave($model)

     {

     }

     public function getHelp(){

         $this->makeView(null,'admin.help');

     }

 }

 <?php

 /**

  * Created by PhpStorm.

  * User: Administrator

  * Date: 2015/10/10 0010

  * Time: 17:58

  */

 class BaseModel extends Eloquent

 {

     protected $table = '';

     protected $guarded = array('id');

     public $timestamps = false;

     public static function getTranslates($translate){

         $rows = DB::table($translate['table'])->select(array($translate['foreign_key'],$translate['show']))->get();

         return $rows;

     }

     static function getTableList( $db ,$connection = null)

     {

         $t = array();

         $dbname = 'Tables_in_'.$db ;

         $tables = $connection ? DB::connection($connection)->select("SHOW TABLES FROM {$db}") : DB::select("SHOW TABLES FROM {$db}");

         foreach($tables as $table)

         {

             $t[$table->$dbname] = $table->$dbname;

         }

         return $t;

     }

     static function getTableColumns( $table,$connection  = false)

     {

 //        $columns = array();

         $sql  = "SHOW COLUMNS FROM $table";

         $rawColumns = $connection ? DB::connection($connection)->select($sql)

             : DB::select($sql);

 //        foreach($rawColumns as $column)

 //            $columns[$column->Field] = $column->Field;

         return $rawColumns;

     }

     function getColoumnInfo( $result )

     {

         $pdo = DB::getPdo();

         $res = $pdo->query($result);

         $i =0;    $coll=array();

         while ($i < $res->columnCount())

         {

             $info = $res->getColumnMeta($i);

             $coll[] = $info;

             $i++;

         }

         return $coll;

     }

     function builColumnInfo( $statement )

     {

         $driver         = Config::get('database.default');

         $database         = Config::get('database.connections');

         $db         = $database[$driver]['database'];

         $dbuser     = $database[$driver]['username'];

         $dbpass     = $database[$driver]['password'];

         $dbhost     = $database[$driver]['host'];

         $data = array();

         $mysqli = new mysqli($dbhost,$dbuser,$dbpass,$db);

         if ($result = $mysqli->query($statement)) {

             /* Get field information for all columns */

             while ($finfo = $result->fetch_field()) {

                 $data[] = (object) array(

                     'Field'    => $finfo->name,

                     'Table'    => $finfo->table,

                     'Type'    => $finfo->type

                 );

             }

             $result->close();

         }

         $mysqli->close();

         return $data;

     }

     static function findPrimarykey( $table, $db = null)

     {

         $query = "SHOW KEYS FROM `{$table}` WHERE Key_name = 'PRIMARY'";

         $primaryKey = '';

         $keys = $db ? DB::connection($db)->select($query) : DB::select($query);

         foreach($keys as $key)

         {

             $primaryKey = $key->Column_name;

         }

         return $primaryKey;

     }

 }

 <?php

 $formOption = $config['form_options'];

 $layout = $formOption['layout'];

 $labelCols = $layout['label_cols'];

 $inputCols = $layout['input_cols'];

 $labelCss = "col-sm-$labelCols";

 $inputCss = "col-sm-$inputCols";

 //  插件是否加载

 $loadUE = false;

 $loadSBox = false;

 $loadDatePicker = false;

 ?>

 <div class="panel panel-primary">

     <div class="panel-heading">

         <h3 class="panel-title">@if($model->id)  编辑<code>#{{$model->id}}</code>@else 新建  @endif</h3>

     </div>

     <div class="panel-body">

         <div class="row">

             <div class="col-sm-{{$layout['cols']}} col-sm-offset-{{(12-$layout['cols'])/2}}">

                 <form class="form-horizontal validate" action="{{URL::to('admin/'.$stdName.'/edit')}}" method="post">

                     <input type="hidden" name="{{$model->getKeyName()}}" value="{{$model->getKey()}}">

                     <?php foreach($config['fields'] as $field => $settings):?>

                     <?php

                     if ($field === $model->getKeyName() || !$settings['form']['show']) continue;

                     $type = $settings['form']['type'];

                     $rule = $settings['form']['rule'];

                     ?>

                     <?php if($settings['form']['type'] === 'hidden'):?>

                     <input type="hidden" name="{{$field}}" value="{{$model->$field}}">

                     <?php continue;?>

                     <?php endif; ?>

                     <div class="form-group">

                         <label for="{{$field}}"

                                class="{{$labelCss}} control-label">{{isset($settings['label']) ? $settings['label'] : strtoupper($field)}}</label>

                         <div class="{{$inputCss}}">

                             <?php if($type === 'textarea'):?>

                             <textarea name="{{$field}}" id="{{$field}}" rows="10"

                                       {{SiteHelpers::inputValidate($rule)}}

                                       class="form-control">{{$model->$field}}</textarea>

                             <?php elseif($type === 'select'):?>

                             <?php $loadSBox = true;?>

                             <select name="{{$field}}" id="{{$field}}" class="selectboxit" {{SiteHelpers::inputValidate($rule)}}>

                                 @if (isset($settings['form']['options']))

                                     @if(is_array($settings['form']['options']))

                                         @foreach($settings['form']['options'] as $value => $text)

                                             <option value="{{$value}}"

                                                     @if($value == $model->$field) selected @endif>{{$text}}</option>

                                         @endforeach

                                     @elseif(is_string($settings['form']['options']))

                                         @foreach($$settings['form']['options'] as $value => $text)

                                             <option value="{{$value}}">{{$value}}</option>

                                         @endforeach

                                     @endif

                                 @elseif(isset($settings['relation']['type']) && $settings['relation']['type'] )

                                     <?php

                                     $fieldTranslate = $config['relations'][$field];

                                     $options = BaseModel::getTranslates($fieldTranslate);

                                     foreach($options as $option):

                                     ?>

                                     <option value="<?=$option->$fieldTranslate['foreign_key']?>"

                                             @if($option->$fieldTranslate['foreign_key'] == $model->$field) selected @endif

                                     ><?=$option->$fieldTranslate['show']?>

                                     </option>

                                     <?php endforeach;?>

                                 @endif

                             </select>

                             <?php elseif($type === 'wysiwyg'):?>

                             <?php

                             $loadUE = true;

                             ?>

                             <script type="text/plain" name="{{$field}}" id="wysiwyg-edit"

                                     style="width:100%;height:240px;">{{$model->$field}}</script>

                             <?php elseif ($type === 'radio' || $type === 'checkbox'): ?>

                             @if(isset($settings['form']['options']))

                                 @foreach($settings['form']['options'] as $option => $text)

                                     <div class="{{$type}} {{$type}}-replace">

                                         <input type="{{$type}}" value="{{$option}}" name="{{$field}}"

                                                id="{{$field}}" @if($model->field === $option) checked @endif>

                                         <label>{{$text}}</label>

                                     </div>

                                 @endforeach

                             @endif

                             <?php elseif($type === 'date'):?>

                             <?php $loadDatePicker = true;?>

                             <div class="input-group">

                                 <input type="text" name="{{$field}}" id="{{$field}}" class="form-control datepicker" data-format="yyyy-MM-dd" {{SiteHelpers::inputValidate($rule)}}>

                                 <div class="input-group-addon">

                                     <a href="#"><i class="entypo-calendar"></i></a>

                                 </div>

                             </div>

                             <?php elseif($type === 'password'):?>

                             <input type="password" class="form-control" name="{{$field}}" id="{{$field}}"

                                    value="{{$model->$field}}"

                                     {{SiteHelpers::inputValidate($rule)}}

                             >

                             <?php elseif($type === 'file'):?>

                             <input type="file"

                                    class="form-control file2 inline btn btn-primary"

                                    data-label="<i class='glyphicon glyphicon-file'></i> 选择文件" >

                             <?php else:?>

                             <input type="text" class="form-control" name="{{$field}}" id="{{$field}}"

                                    {{SiteHelpers::inputMask($rule)}}

                                    {{SiteHelpers::inputValidate($rule)}}

                                    value="{{$model->$field}}">

                             <?php endif;?>

                         </div>

                     </div>

                     <?php endforeach;?>

                     <div class="form-group">

                         <div class="{{$inputCss}} col-sm-offset-{{$labelCols}}">

                             <button type="submit" class="btn btn-primary">保存</button>

                         </div>

                     </div>

                 </form>

             </div>

         </div>

     </div>

 </div>

 @yield('form.bottom','')

 @section('styles')

     @if($loadSBox)

         {{HTML::style('assets/js/selectboxit/jquery.selectBoxIt.css')}}

     @endif

 @append

 @section('scripts')

     <?php if($loadUE):?>

     {{HTML::script('plugins/ue-utf8-php/ueditor.config.js')}}

     {{HTML::script('plugins/ue-utf8-php/ueditor.all.min.js')}}

     {{HTML::script('plugins/ue-utf8-php/lang/zh-cn/zh-cn.js')}}

     <?php endif;?>

     @if($loadSBox)

         {{HTML::script('assets/js/selectboxit/jquery.selectBoxIt.min.js')}}

     @endif

     @if($loadDatePicker)

         {{HTML::script('assets/js/bootstrap-datepicker.js')}}

     @endif

     {{HTML::script('assets/js/jquery.inputmask.bundle.min.js')}}

     {{HTML::script('assets/js/jquery.validate.min.js')}}

 @append

 @section('footScript')

     <script>

         var ue = null,

                 ueId = 'wysiwyg-edit';

         if (document.getElementById(ueId)) {

             ue = UE.getEditor(ueId);

         }

     </script>

 @append

 @section('headStyle')

     <style>

         .sort.sort-active {

             color: #000;

             font-weight: bold;

         }

     </style>

 @append

 <?php

 $list_options = $config['list_options'];

 $loadSBox = false;

 $loadDatePicker = false;

 ?>

 <div class="panel panel-default">

     <div class="panel-heading">

         <h3 class="panel-title"><?=isset($navMap[$stdName]['text']) ? $navMap[$stdName]['text'] : strtoupper($stdName)?>

             列表</h3>

     </div>

     <div class="panel-body">

         <div class="row">

             <div class="col-sm-12">

                 <div class="btn-group btn-group-sm" role="group">

                     @if($list_options['create'])

                         <a href="{{URL::to('admin/'.$stdName.'/edit')}}" class="btn btn-primary">新建</a>

                     @endif

                     <a class="btn btn-danger delete-selected">删除</a>

                     <a class="btn btn-default">导出</a>

                 </div>

             </div>

         </div>

         <br>

         <form class="list-form" action="" method="get">

             <input type="hidden" name="list_sort_asc" value="{{Input::get('list_sort_asc') !== null ? Input::get('list_sort_asc') : 1}}">

             <input type="hidden" name="list_order_by" value="">

             <table class="table table-bordered responsive table-hover table-striped">

                 <thead>

                 <tr>

                     <th>

                         <div class="checkbox checkbox-replace">

                             <input type="checkbox" class="item-all">

                         </div>

                     </th>

                     <?php foreach($config['fields'] as $field=>$settings):?>

                     <?php if($settings['list']['show']):?>

                     <th @if($settings['list']['sort'])

                         class="sort @if($field === Input::get('list_order_by')) sort-active @endif"

                         data-field="{{$field}}" @endif

                     ><?=is_array($settings) && isset($settings['label']) ? $settings['label'] : strtoupper($field)?>

                         <span class="pull-right">

                             @if($field === Input::get('list_order_by'))  @if(Input::get('list_sort_asc') == 1) <i class="fa fa-sort-asc"></i> @else <i class="fa fa-sort-desc"></i>  @endif @endif

                         </span>

                     </th>

                     <?php endif;?>

                     <?php endforeach;?>

                     <th>操作</th>

                 </tr>

                 </thead>

                 <tbody>

                 <tr>

                     <td></td>

                     @foreach($config['fields'] as $field=>$fieldConfig)

                         @if($fieldConfig['list']['show'])

                             @if(isset($fieldConfig['list']['search']) && $fieldConfig['list']['search'] !== false)

                                 <td>

                                     @if($fieldConfig['form']['type'] == 'select' || ($fieldConfig['form']['type'] === 'radio' || $fieldConfig['form']['type'] == 'checkbox'))

                                         <?php $loadSBox = true;?>

                                         @if(isset($fieldConfig['form']['options']) && $fieldConfig['form']['options'])

                                             <select name="{{$field}}" id="{{$field}}" class="selectboxit">

                                                 <option value="" class="default-value">请选择</option>

                                                 @foreach($fieldConfig['form']['options'] as $option => $text)

                                                     <option value="{{$option}}" @if(Input::get($field) && Input::get($field) === $option) selected @endif>{{$text}}</option>

                                                 @endforeach

                                             </select>

                                         @elseif(isset($fieldConfig['relation']['type']) && $fieldConfig['relation']['type'] )

                                             {{View::make('components.relation_select',array(

                                             'fieldConfig'=>$fieldConfig,'field' =>  $field, ))}}

                                         @endif

                                     @elseif($fieldConfig['form']['type'] === 'date')

                                         <?php $loadDatePicker = true;?>

                                         <input type="text" name="{{$field}}" id="{{$field}}" class="form-control datepicker" data-format="yyyy-MM-dd" value="{{Input::get($field)}}">

                                     @else

                                         <input type="text" name="{{$field}}" id="{{$field}}"

                                                value="{{Input::get($field)}}" class="form-control input-sm">

                                     @endif

                                 </td>

                             @else

                                 <td></td>

                             @endif

                         @endif

                     @endforeach

                     <td>

                         <div class="btn-group btn-group-sm" role="group">

                             <button type="submit" class="btn btn-primary">搜索</button>

                             <button type="reset" onclick="resetForm(this)" class="btn btn-warning hidden">重置</button>

                         </div>

                     </td>

                 </tr>

                 <?php foreach($models as  $model):?>

                 <tr>

                     <td width="18px">

                         <div class="checkbox checkbox-replace">

                             <input type="checkbox" name="d_delete_select" class="item" value="{{$model->id}}">

                         </div>

                     </td>

                     <?php foreach($config['fields'] as $filed=>$settings):?>

                     <?php if($settings['list']['show']):?>

                     <?php

                     $value = $model->$filed;

                     /* 字段在列表中需要翻译 */

                     if (array_key_exists($filed, $config['relations'])) {

                         $value = $model->$config['relations'][$filed]['as'];

                     }

                     ?>

                     <td>{{$value}}</td>

                     <?php endif;?>

                     <?php endforeach;?>

                     <td>

                         <div class="btn-group btn-group-sm" role="group">

                             @if($list_options['update'])

                                 <a href="{{URL::to('admin/'.$stdName.'/edit/'.$model->id)}}"

                                    class="btn btn-primary">编辑</a>

                             @endif

                             @if($list_options['delete'])

                                 <a href="{{URL::to('admin/'.$stdName.'/delete/'.$model->id)}}"

                                    class="btn btn-danger">删除</a>

                             @endif

                             @if(View::exists('admin.'.snake_case($stdName).'.list_item_links'))

                                 @include('admin.'.snake_case($stdName).'.list_item_links',array('model'=>$model))

                             @endif

                         </div>

                     </td>

                 </tr>

                 <?php endforeach;?>

                 </tbody>

             </table>

         </form>

         <div class="pull-right">

             {{$models->appends(Input::all())->links()}}

         </div>

     </div>

 </div>

 @section('styles')

     {{HTML::style('assets/js/datatables/responsive/css/datatables.responsive.css')}}

     @if($loadSBox)

         {{HTML::style('assets/js/selectboxit/jquery.selectBoxIt.css')}}

     @endif

 @append

 @section('scripts')

     {{HTML::script('assets/js/jquery.dataTables.min.js')}}

     {{HTML::script('assets/js/datatables/jquery.dataTables.columnFilter.js')}}

     @if($loadSBox)

         {{HTML::script('assets/js/selectboxit/jquery.selectBoxIt.min.js')}}

     @endif

     @if($loadDatePicker)

         {{HTML::script('assets/js/bootstrap-datepicker.js')}}

     @endif

 @append

 @section('footScript')

     <script>

         $(document).ready(function(){

             $('th.sort').click(function(){

                 var $th = $(this);

                 $('input[name="list_order_by"]').val($th.data('field'));

                 $('input[name="list_sort_asc"]').val($th.find('i').hasClass('fa-sort-asc') ? 0 : 1);

                 $('form.list-form').submit();

             });

             $('input.item-all').change(function(){

                 var $this = $(this),

                         $items = $('input.item');

                 if($this.is(':checked')){

                     $items.prop('checked','checked');

                 }else{

                     $items.removeProp('checked');

                 }

                 $items.trigger('change');

             });

             $('a.delete-selected').click(function(){

                 var ids = [],

                         $items = $('input.item:checked');

                 $items.each(function(i){

                     ids.push($(this).val());

                 });

                 var idsStr = ids.join(',');

                 confirmModal({

                     message  :   '确认删除：'+idsStr,

                     onOk:   function(){

                         $.post('{{URL::to('admin/'.snake_case($stdName).'/delete')}}',{"ids":idsStr},function(resp){

                             if(resp.success){

                                 window.location.href = resp.data.redirect_url;

                             }

                         },'json');

                     }

                 });

                 return false;

             });

         });

     </script>

 @append

 @section('modals')

     <div class="modal fade" id="confirm-modal" data-backdrop="static">

         <div class="modal-dialog">

             <div class="modal-content">

                 <div class="modal-header">

                     <h4 class="modal-title">操作确认</h4>

                 </div>

                 <div class="modal-body">

                 </div>

                 <div class="modal-footer">

                     <button type="button" class="btn btn-default cancel" data-dismiss="modal">取消</button>

                     <button type="button" class="btn btn-info ok">确认</button>

                 </div>

             </div>

         </div>

     </div>

 @stop

 <?php

 /**

  * 说明：

  * 1. 以下配置项，不设置便是默认

  * Created by PhpStorm.

  * User: lvyahui

  * Date: 2016/5/2

  * Time: 12:33

  */

 return array(

     /**

      * 所有字段配置

      */

     'fields'    =>  array(

         'field_name' =>  array(

             /* 显示在列表表格的表头的内容，和form控件旁边的内容*/

             'label' =>  '字段中文名',

             /* 字段缺省值 */

             'value' =>  false,

             /* 针对表单的设置 */

             'form'  =>  array(

                 'show'  =>  true,

                 'hidden'    =>  false,

                 /*

                  * 字段对应表单的控件类型，默认text，

                  * 还支持常用的控件类型

                  * textarea

                  * radio

                  * checkbox

                  * number

                  * ipaddr

                  * wyswyg

                  * select

                  * date

                  * file

                  * 以及自定义类型

                  * */

                 'type'  =>  'text',

                 /*

                 'type'  =>  array(

                     'select'    =>  array(

                         'options'   =>  function(){

                             return array();

                         }

                     ),

                 ),

                 'type'  =>  array(

                     'radio'     =>  array(),

                 ),

                 */

                 /* 提交表单后的验证规则 */

                 'rule'  =>  'required',

                 'ajax_validate' =>  false,

                 'placeholder'   =>  'xx',

             ),

             // 针对列表的设置

             'list'  =>  array(

                 /* 字段在列表是否显示，默认为显示 */

                 'show'  =>  true,

                 /* 字段是否可以排序，默认不能排序 */

                 'sort'  =>  true,

                 /* 是否能够按这个字段搜索 */

                 'search'    =>  true,

                 /* 字段进行翻译，比如栏目Id字段，一般要转成栏目名称显示 */

                 'lookup'    =>  false,

             ),

         ),

         // more fields

     ),

     /**

      * 全局form配置，优先级小于字段配置

      */

     'form_options'  =>  array(

         'layout'    =>  array(

             'cols'  =>  12,

             'label_cols' =>  1,

             'input_cols' =>  11,

         ),

     ),

     /**

      * 全局list配置，优先级小于字段配置

      */

     'list_options'  =>  array(

         'page'      =>  10,

         'create'    =>  true,

         'update'    =>  true,

         'delete'    =>  true,

     ),

 );

 <?php

 /**

  * Created by PhpStorm.

  * User: lvyahui

  * Date: 2016/5/12

  * Time: 15:28

  */

 namespace admin;

 define('MODULE_ROUTES', json_encode(include(app_path() . '/module_routes.php')));

 use Illuminate\Support\Facades\Redirect;

 use SiteHelpers;

 use BaseModel;

 use Module;

 use ConfigUtils;

 use Illuminate\Support\Facades\Input;

 use Illuminate\Support\Facades\Config;

 use Illuminate\Support\Facades\Response;

 class ModuleController extends AdminController

 {

     protected function beforeEdit(&$data)

     {

         $data ['dataSources'] = SiteHelpers::loadDataSources();

         if ($data['model']->id) {

             $data ['moduleConf'] = ConfigUtils::get($data['model']->name);

         }

     }

     protected function afterSave($module)

     {

         /* 生成代码文件 */

         $codes = array(

             'moduleName'      => $module->name,

             'moduleTitle'     => $module->title,

             'tablePrimaryKey' => BaseModel::findPrimarykey($module->db_table, $module->db_source),

             'moduleNote'      => $module->note,

             'date'            => date('Y-m-d'),

             'dbSource'        => $module->db_source,

             'dbTable'         => $module->db_table,

         );

         $this->removeFiles($codes['moduleName']);

         /* 生成默认module Configuration*/

         $moduleConfs = $this->buildConfiguration($module->db_table, $module->db_source);

         SiteHelpers::saveArrayToFile(app_path('config/crud/') . snake_case($codes['moduleName']) . '.php', $moduleConfs);

         $controller = file_get_contents(app_path('template') . '/controller.tpl');

         $model = file_get_contents(app_path('template') . '/model.tpl');

         $formView = file_get_contents(app_path('template') . '/_form.tpl');

         $listView = file_get_contents(app_path('template') . '/_list.tpl');

         $codes['timestamps'] = isset($moduleConfs['fields']['created_at']) && isset($moduleConfs['fields']['updated_at'])

                                 ? 'true' : 'false';

         $buildController = SiteHelpers::blend($controller, $codes);

         $buildModel = SiteHelpers::blend($model, $codes);

         /* 生成 MVC 文件*/

         file_put_contents(app_path() . "/controllers/admin/{$codes['moduleName']}Controller.php", $buildController);

         file_put_contents(app_path() . "/models/{$codes['moduleName']}.php", $buildModel);

         $viewPath = app_path('/views/admin/') . snake_case($codes['moduleName']);

         if (!file_exists($viewPath)) mkdir($viewPath);

         file_put_contents($viewPath . "/_form.blade.php", $formView);

         file_put_contents($viewPath . "/_list.blade.php", $listView);

         /* 更新路由 */

         $moduleRoutes = json_decode(MODULE_ROUTES, true); //require(app_path().'/module_routes.php');

         if (is_array($moduleRoutes)) {

             $moduleRoutes[SiteHelpers::reducCase($codes['moduleName'])] = 'admin\\' . "{$codes['moduleName']}Controller";

             SiteHelpers::saveArrayToFile(app_path() . '/module_routes.php', $moduleRoutes);

         }

     }

     protected function beforeDelete($id)

     {

         $module = Module::find($id);

         $moduleName = $module->name;

         $this->removeFiles($moduleName);

     }

     /**

      * 删除GModule相关文件文件

      * @param $moduleName

      */

     public function removeFiles($moduleName)

     {

         $controller = app_path('admin/controllers') . "/{$moduleName}Controller.php";

         if (file_exists($controller)) {

             unlink($controller);

         }

         $model = app_path('models') . "/{$moduleName}.php";

         if (file_exists($model)) {

             unlink($model);

         }

         $moduleConf = app_path('config/crud/') . snake_case($moduleName) . '.php';

         if (file_exists($moduleConf)) {

             unlink($moduleConf);

         }

         $viewPath = app_path('/views/admin/') . snake_case($moduleName);

         $formFile = $viewPath . '/_form.blade.php';

         $listFile = $viewPath . '/_list.blade.php';

         if (file_exists($formFile)) unlink($formFile);

         if (file_exists($listFile)) unlink($listFile);

     }

     private function buildConfiguration($table, $connection)

     {

         $rawColumns = BaseModel::getTableColumns($table, $connection);

         $fields = ConfigUtils::build($rawColumns);

         return array(

             'data_source' => $connection,

             'table'       => $table,

             'fields'      => $fields,

         );

     }

     /**

      * 获取字段配置列表

      * @return bool

      */

     public function getFieldsConfig()

     {

         $filedsConfig = null;

         if (Input::has('module_name')) {

             $filedsConfig = ConfigUtils::get(Input::get('module_name'))['fields'];

         } else {

             $table = Input::get('table');

             $connection = Input::get('connection');

             $filedsConfig = $this->buildConfiguration($table, $connection)['fields'];

         }

         $resp = $this->makeView(array(

             'fieldsConfig' => $filedsConfig,

         ));

         if ($resp) {

             return $resp;

         }

     }

     /**

      * 保存字段列表配置

      * @return mixed

      */

     public function postSaveFieldsConf()

     {

         $resp = Redirect::action(get_class($this) . '@getEdit', Input::get('id'));

         $postFields = Input::get('fields');

         $moduleName = Input::get('module_key');

         $confKey = SiteHelpers::reducCase($moduleName);

         $savedConfig = ConfigUtils::get($confKey);

         foreach ($savedConfig['fields'] as $fieldName => &$savefield) {

             $postField = $postFields[$fieldName];

             $savefield['label'] = $postField['label'];

             $savefield['form']['show'] = isset($postField['form']['show']);

             $savefield['list']['show'] = isset($postField['list']['show']);

         }

         ConfigUtils::saveGModuleConf($confKey, $savedConfig);

         return $resp;

     }

     /**

      * 呈现某一字段的配置参数FORM

      * @return bool

      */

     public function getFieldConfig()

     {

         $moduleKey = Input::get('module_key');

         $field = Input::get('field');

         $moduleConfig = Config::get('crud/' . snake_case($moduleKey));

         $fieldConf = &$moduleConfig['fields'][$field];

         $dbSource = SiteHelpers::loadDataSources()[$moduleConfig['data_source']];

         $tables = BaseModel::getTableList($dbSource['database'],$moduleConfig['data_source']);

         $resp = $this->makeView(array(

             'field'       => $field,

             'fieldConfig' => $fieldConf,

             'moduleKey'   => $moduleKey,

             'tables'    =>  $tables,

             'connection'    =>  $moduleConfig['data_source'],

         ));

         if ($resp) return $resp;

     }

     /**

      * 保存某一字段的配置参数

      * @return \Illuminate\Http\JsonResponse

      */

     public function postFieldConfig()

     {

         $data = array(

             'success' => true,

         );

         $moduleKey = Input::get('module_key');

         $field = Input::get('field');

         $moduleConfig = Config::get('crud/' . snake_case($moduleKey));

         $fieldConf = &$moduleConfig['fields'][$field];

         $postFormConf = Input::get('form');

         $postListConf = Input::get('list');

         $postRelationConf = Input::get('relation');

         $fieldConf['form']['type'] = $postFormConf['type'];

         if((

                 $postFormConf['type'] === 'select'

                 || $postFormConf['type'] === 'radio'

                 || $postFormConf['type'] === 'checkbox'

             )

             && isset($postFormConf['options'])

             && $postFormConf['options']

         ){

             $rawOptions = explode(',',$postFormConf['options']);

             $options = array();

             foreach($rawOptions as $option){

                 $options[$option]   = $option;

             }

             $fieldConf['form']['options'] = $options;

         }

         $fieldConf['form']['placeholder'] = $postFormConf['placeholder'];

         $fieldConf['form']['rule']  =  $postFormConf['rule'];

         $fieldConf['list']['sort'] = isset($postListConf['sort']);

         $fieldConf['list']['search'] = $postListConf['search'];

         $fieldConf['relation']  =   $postRelationConf;

         SiteHelpers::saveArrayToFile(app_path('config/crud/' . snake_case($moduleKey) . '.php'), $moduleConfig);

         return Response::json($data);

     }

 }