Serverfireteam\Panel\ExportImportController::import PHP Method

    public function import($entity)
    {
        $appHelper = new libs\AppHelper();
        $className = $appHelper->getNameSpace() . $entity;
        $model = new $className();
        $table = $model->getTable();
        $columns = \Schema::getColumnListing($table);
        $key = $model->getKeyName();
        $notNullColumnNames = array();
        $notNullColumnsList = \DB::select(\DB::raw("SHOW COLUMNS FROM `" . $table . "` where `Null` = 'no'"));
        if (!empty($notNullColumnsList)) {
            foreach ($notNullColumnsList as $notNullColumn) {
                $notNullColumnNames[] = $notNullColumn->Field;
            }
        }
        $status = Input::get('status');
        $filePath = null;
        if (Input::hasFile('import_file') && Input::file('import_file')->isValid()) {
            $filePath = Input::file('import_file')->getRealPath();
        }
        if ($filePath) {
            \Excel::load($filePath, function ($reader) use($model, $columns, $key, $status, $notNullColumnNames) {
                $this->importDataToDB($reader, $model, $columns, $key, $status, $notNullColumnNames);
            });
        }
        $importMessage = $this->failed == true ? \Lang::get('panel::fields.importDataFailure') : \Lang::get('panel::fields.importDataSuccess');
        return \Redirect::to('panel/' . $entity . '/all')->with('import_message', $importMessage);
    }