header('Content-Type: text/html; charset=utf-8');

include 'gt_datagrid.php';

echo "";

$db_host = 'localhost';
$db_name = 'gnew2';
$db_user = 'root';
$db_pass = '';
try {
    $dbh = new PDO("mysql:host=$db_host;dbname=$db_name;", $db_user, $db_pass);
} catch (PDOException $e) {
    die('数据库连接失败: ' . $e->getMessage());
}

$gt = new GT_DataGrid($dbh);

$gt->table = 'gt_users';

$gt->table_id_name = 'id';

$gt->table_fields_form = array('id', 'user_name', 'user_mobile', 'user_email', 'user_type', 'user_status', 'user_add_time', 'user_isadmin', 'user_role_id');

$gt->table_fields_grid = array('id', 'user_name', 'user_mobile', 'user_email', 'user_type', 'user_status', 'user_add_time', 'user_isadmin', 'user_role_id');

// 重命名列名
$gt->rename = array(
    'id' => 'id', 
    'user_name' => 'user_name', 
    'user_mobile' => 'user_mobile', 
    'user_email' => 'user_email', 
    'user_type' => 'user_type', 
    'user_status' => 'user_status', 
    'user_add_time' => 'user_add_time', 
    'user_isadmin' => 'user_isadmin', 
    'user_role_id' => 'user_role_id'
);

// 不允许更新或插入的字段
$gt->table_fields_form_exclude = array(); 

$gt->form_input_type = array('v_notes' => array('type' => 'textarea'));

$gt->run();

/**

// 不显示按钮
$gt->grid_add_link = '';
$gt->grid_text_save_changes = '';


$gt->grid_output_type = array(
    'v_source' => array('type' => 'my_user_function'), 
    'v_page' => array('type' => 'my_user_function'), 
    'v_search' => array('type' => 'my_user_function'), 
    'v_ip' => array('type' => 'my_user_function')
);

function utf8_wordwrap($string, $width = 75, $break = "\n", $cut = false)
{
    if ($cut) {
        $search  = '/(.{1,' . $width . '})(?:\s)|(.{' . $width . '})(?!$)/uS';
        $replace = '$1$2' . $break;
    } else {
        $search  = '/(?<=\s|^)(.{1,' . $width . '}\S*)(?:\s)/uS';
        $replace = '$1' . $break;
    }
    return preg_replace($search, $replace, $string);
}

function my_user_function($field_name, $field_value, $command, $from)
{
    return utf8_wordwrap($field_value, 20, "
", true);
}

 **/

echo '';