我的代碼出了什么問題,我嘗試使用 Laravel 框架導(dǎo)出數(shù)據(jù)表。下載的文件內(nèi)容為空。StockModel.phpnamespace App; use Illuminate\Database\Eloquent\Model; class Stock extends Model { protected $table = 'stock_tb'; protected $primaryKey = 'id'; protected $fillable = ['stock_id', 'input_date', 'quantity']; }管理控制器.phpuse Excel;use App\Stock;use App\Exports\StockExport;class adminController extends Controller { public function __construct() { } public function printStockReport(){ return Excel::download(new StockExport('07/01/2020'), 'ado.xlsx'); }StockExport.phpnamespace App\Exports;use App\Stock;use Maatwebsite\Excel\Concerns\FromQuery;class StockExport implements FromQuery{ protected $id; public function __construct($date_var) { $this->date = $date_var; } public function query() { return Stock::query()->where('input_date', $this->date)->get(); } }路由器Route::get('admin/printStockReport', 'adminController@printStockReport');僅供參考:我在 RDBMS 上運(yùn)行 SQL 代碼,條件輸入日期為07/01/2020。它返回 129 條記錄。謝謝
- 1 回答
- 0 關(guān)注
- 133 瀏覽
添加回答
舉報(bào)
0/150
提交
取消