Пример #1
0
 /**
  * Bind PHPExcel classes
  * @return void
  */
 protected function bindPHPExcelClass()
 {
     // Set object
     $me = $this;
     // Bind the PHPExcel class
     $this->app['phpexcel'] = $this->app->share(function () use($me) {
         // Set locale
         $me->setLocale();
         // Set the caching settings
         $me->setCacheSettings();
         // Init phpExcel
         $excel = new PHPExcel();
         $excel->setDefaultProperties();
         return $excel;
     });
 }
Пример #2
0
 /**
  * Create a new file
  * @param                $filename
  * @param  callable|null $callback
  * @return LaravelExcelWriter
  */
 public function create($filename, $callback = null)
 {
     // Writer instance
     $writer = clone $this->writer;
     // Disconnect worksheets to prevent unnecessary ones
     $this->excel->disconnectWorksheets();
     // Inject our excel object
     $writer->injectExcel($this->excel);
     // Set the filename and title
     $writer->setFileName($filename);
     $writer->setTitle($filename);
     // Do the callback
     if ($callback instanceof Closure) {
         call_user_func($callback, $writer);
     }
     // Return the writer object
     return $writer;
 }
Пример #3
0
// Route::get('/dynamic_table', function () {
//     return view('test/dynamic_table');
// });
// Route::get('/index', function () {
//     return view('test/horizontal_menu');
// // });
// Route::get('/',)
Route::get('/', 'HomeController@index');
Route::get('/assets', 'AssetController@index');
Route::post('/getdevicefromasset', 'AssetController@getdevicefromasset');
Route::get('/device', 'DeviceController@index');
Route::post('/getassetfromdevice', 'DeviceController@getassetfromdevice');
Route::post('/createdevice', 'DeviceController@createdevice');
Route::get('/people', 'PeopleController@index');
Route::post('/createpeople', 'PeopleController@createpeople');
Route::get('/service', 'ServiceController@index');
Route::post('/createservice', 'ServiceController@createservice');
Route::get('/editdevice/{id}', 'DeviceController@edit');
Route::post('/editdevice/{id}', 'DeviceController@editdevice');
Route::post('/deleteasset', 'AssetController@deleteAsset');
Route::post('/deletedevice', 'DeviceController@deletedevice');
Route::post('/deletedeviceall', 'DeviceController@deletedeviceall');
Route::get('/test', function () {
    $rows = array(array('id' => 1, 'name' => 'marlon'));
    PHPExcel::create($name, function ($excel) use($rows) {
        $excel->sheet('当天报名', function ($sheet) use($rows) {
            $sheet->fromArray($rows);
        });
    })->store('xls', storage_path('excel'));
});
Route::post('/search', 'HomeController@search');