예제 #1
0
 public function actionUpdateColumn()
 {
     //     	data: {'table_id': table_id, 'id': id, 'desc': desc, 'data_type': data_type, 'search_type': search_type,
     //     	'select_id': select_id, 'order_type': order_type, 'chart_display': chart_display, 'table_display': table_display,
     //     	'mark': mark, 'formatter': formatter}
     $table_id = 0 + \Yii::$app->request->post('table_id', '');
     $column_id = \Yii::$app->request->post('id', '');
     $table = TbTable::findOne($table_id);
     if (!$table) {
         echo json_encode(['code' => 1, 'msg' => '数据库中没有该表']);
         \Yii::$app->end();
     }
     if (is_numeric($column_id)) {
         $column = TbColumn::findOne($column_id);
     } else {
         $column = new TbColumn();
     }
     if (!$column) {
         echo json_encode(['code' => 1, 'msg' => '表中没有该字段']);
         \Yii::$app->end();
     }
     $column->fdTableID = $table_id;
     $column->fdName = \Yii::$app->request->post('column_name', '');
     $column->fdDesc = \Yii::$app->request->post('desc', '');
     $column->fdTooltip = \Yii::$app->request->post('tip', '');
     $column->fdDataType = 0 + \Yii::$app->request->post('data_type', '');
     $column->fdSearchType = 0 + \Yii::$app->request->post('search_type', '');
     $column->fdSelectID = 0 + \Yii::$app->request->post('select_id', '');
     $column->fdOrderType = 0 + \Yii::$app->request->post('order_type', '');
     $column->fdChartDisplay = 0 + \Yii::$app->request->post('chart_display', '');
     $column->fdTableDisplay = 0 + \Yii::$app->request->post('table_display', '');
     $column->fdMark = 0 + \Yii::$app->request->post('mark', '');
     $column->fdFormatter = \Yii::$app->request->post('formatter', '');
     if (!$column->save()) {
         echo json_encode(['code' => -1, 'msg' => json_encode($column->getErrors(), JSON_UNESCAPED_UNICODE)], JSON_UNESCAPED_UNICODE);
         \Yii::$app->end();
     }
     echo json_encode(['code' => 0, 'msg' => '请求操作成功', 'result' => ['id' => $column->id]]);
 }