function IIF($exp, $val)
{
return IFF($exp, $exp, $val);
}
private function generateTable($tableName)
{
$fields = M()->query('SHOW FULL COLUMNS FROM ' . $tableName);
foreach ($fields as $key => $value) {
$rows[] = array($value['field'], $value['type'], IFF($value["null"] == "YES", "是", "否"), IFF($value["key"] == "PRI", "是"), $value['default'], IFF($value["extra"] == "auto_increment", "是"), $value['comment']);
}
$this->headers = array('字段', '类型', '允许空值', '主键', '默认值', '自动递增', '注释');
$this->aligns = array(1, 1, 2, 2, 2, 2, 1);
$this->rows = $rows;
return $this->generate();
}
public function generate($tableName = '', $comment, $out)
{
// $this->crossingChar = '|';
$out_array = array();
$output = '';
if ($tableName) {
$output .= $comment . "(" . substr($tableName, strlen(C('DB_PREFIX'))) . ")" . PHP_EOL;
$rows = array();
$array = M()->query('SHOW FULL COLUMNS FROM ' . $tableName);
foreach ($array as $key => $value) {
$rows[] = array($value['field'], $value['type'], IFF($value["null"] == "YES", "是", "否"), IFF($value["key"] == "PRI", "是"), $value['default'], IFF($value["extra"] == "auto_increment", "是"), $value['comment']);
}
$this->headers = array('字段', '类型', '允许空值', '主键', '默认值', '自动递增', '注释');
$this->rows = $rows;
return $this->renderWitoutHeadTail($output, $out);
}
//echo PHP_EOL;
}
