public function run() { // Initialize empty array $asset_maintenances = array(); $date = new DateTime(); $asset_maintenances[] = array('asset_id' => 1, 'supplier_id' => 1, 'asset_maintenance_type' => 'Maintenance', 'title' => 'Test Maintenance', 'start_date' => $date->modify('-10 day'), 'cost' => '200.99', 'is_warranty' => '0', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day')); // Delete all the old data DB::table('asset_maintenances')->truncate(); // Insert the new posts AssetMaintenance::insert($asset_maintenances); }
/** * getImprovementsReport * * @return mixed * @author Vincent Sposato <*****@*****.**> * @version v1.0 */ public function getAssetMaintenancesReport() { // Grab all the improvements $assetMaintenances = \AssetMaintenance::with('asset', 'supplier')->orderBy('created_at', 'DESC')->get(); return View::make('backend/reports/asset_maintenances', compact('assetMaintenances')); }