README

• 与PDO一起工作，您可以设置当前项目的连接或创建新的连接；
• 设置每页项目数量；
• 多语言支持；
• 连接到任何MySQL表；
• 控制列表页面上字段及其视图；
• 编辑任何行，创建新行，删除，批量删除；
• 所有类型的关联（一对一，一对多，多对多）；
• 上传文件和图片；
• 按字段搜索；
• 按字段排序；
• 主题。

列表页：

新（编辑）行页：

代码示例

// Require lib
require_once 'src/Uavn/Dictator.php';

// Create PDO connection or use your project connection
$pdo = new \PDO(
  'mysql:host=localhost;dbname=dictator',
  'root', '', array(
    PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
  )
);

// Create instance of Dictator
$dictator = new \Uavn\Dictator;
$dictator
  ->setConnection($pdo)
  // Set options: ipp — items per page, others — translations.
  ->setOptions(array(
    'Actions' => 'Действия',
    'Edit' => 'Редактировать',
    'Delete' => 'Удалить',
    'New row' => 'Новая запись',
    'Edit row' => 'Редактировать запись',
    'Page' => 'Страница',
    'Sure?' => 'Уверены?',
    'Search' => 'Найти',
    'Save' => 'Сохранить',
    'List rows' => 'Все записи',
    'Saved successful' => 'Успешно сохранено',
    'ipp' => 5
  ))
  // Set table and label
  ->setTable('book', 'Книги')
  // Add fields to list and its label
  ->addField('id', 'ID')
  ->addField('pic', 'Обложка')
  ->addField('categoryId', 'Категория')
  ->addField('name', 'Название')
  ->addField('isSold', 'Продана?')
  ->addField('desc', 'Описание')
  // Third parameter — will not be showed on edit page
  ->addField('createdAt', 'Создано', false)
  ->addField('updatedAt', 'Обновлено', false)
  // Add list filters: field name and callback function
  ->addFilter('isSold', function( $isSold ) {
    return $isSold
      ? 'Да'
      : 'Нет';
  })
  ->addFilter('pic', function( $text ) {
    if ( $text ) {
      return '<img width="150" src="upload/' . $text . '">';
    }

    return '—';
  })
  ->addFilter('desc', function( $text ) {
    if ( $text ) {
      $substr = mb_substr($text, 0, 200, 'UTF-8');
      return $substr . '…';
    }

    return '—';
  })
  ->addFilter('createdAt', function( $text ) {
    if ( $text ) {
      return date( 'd.m.Y (H:i:s)', strtotime($text) );
    }

    return '—';
  })
  ->addFilter('updatedAt', function( $text ) {
    if ( $text ) {
      return date( 'd.m.Y (H:i:s)', strtotime($text) );
    }

    return '—';
  })
  // This field will generate input type="file" on edit page, second param — upload dir
  ->addFileWidget('pic', __DIR__ . '/upload')
  // This field will geretate textarea on edit page
  ->addTextWidget('desc')
  // This field will geretate checkbox on edit page
  ->addCheckWidget('isSold')
  // Field categoryId maps to table category will show category.name field in list and dropdown
  ->addRelation('categoryId', 'category', 'name')
  // This adds many-to-many widget on edit page:
  // Current table maps to table author,
  //  with field author.name in list and checbox set
  //  with label — Авторы
  //  connected through third table autor_book by bookId and authorId
  ->addManyToManyRelation(
    'author', 'name', 'Авторы',
    'author_book', 'bookId', 'authorId'
  )
  ->addManyToManyRelation(
    'publisher', 'name', 'Издатели',
    'publisher_book', 'bookId', 'publisherId'
  )
  // This creates search by this fields
  ->addSearch('name')
  ->addSearch('desc')
  // On Before Insert and Update event callbacks
  ->onBeforeInsert('createdAt', function() {
    return date('Y-m-d H:i:s');
  })
  ->onBeforeInsert('updatedAt', function() {
    return date('Y-m-d H:i:s');
  })

  ->onBeforeUpdate('updatedAt', function( $itemData ) {
    return date('Y-m-d H:i:s');
  })
  ;
  // This will generate table or form
  $html = $dictator->generate();
  
  echo $hmtl;