public function singleReport($id, $type)
{
$singleReport = Report::findOrFail($id);
\Excel::create('report-' . $singleReport->date, function ($excel) use($singleReport) {
$excel->sheet('report', function ($sheet) use($singleReport) {
$sheet->setAllBorders('thin');
$sheet->loadView('mr.export.single_report')->with('singleReport', $singleReport);
});
})->export($type);
}
public function singleReport($level, $id, $type)
{
if ($level == 'sm') {
$singleReport = SMReport::findOrFail($id);
} elseif ($level == 'am') {
$singleReport = AMReport::findOrFail($id);
} elseif ($level == 'mr') {
$singleReport = Report::findOrFail($id);
}
\Excel::create('report-' . $level . '-' . $singleReport->emp->name . '-' . $singleReport->date, function ($excel) use($singleReport) {
$excel->sheet('report', function ($sheet) use($singleReport) {
$sheet->setAllBorders('thin');
$sheet->loadView('admin.export.single_report')->with('singleReport', $singleReport);
});
})->export($type);
}
public function edit($id)
{
$report = Report::findOrFail($id);
$categories = Category::all();
return view('reports.edit')->with('categories', $categories)->with('report', $report);
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id, Request $request)
{
//$this->validate($request, ['name' => 'required']); // Uncomment and modify if needed.
$report = Report::findOrFail($id);
$update = $request->all();
// is new image uploaded?
if ($file = Input::file('image')) {
$fileName = $file->getClientOriginalName();
$extension = $file->getClientOriginalExtension() ?: 'png';
$folderName = '/uploads/';
$destinationPath = Config::get('app.path') . $folderName;
$safeName = time() . "_" . str_random(10) . '.' . $extension;
$file->move($destinationPath, $safeName);
//delete old pic if exists
if (File::exists(Config::get('app.path') . $report->image)) {
File::delete(Config::get('app.path') . $report->image);
}
$update['image'] = $safeName ? $folderName . $safeName : '';
}
if (isset(Report::$boolean)) {
foreach (Report::$boolean as $field) {
if (isset($update[$field]) && $update[$field] == "on") {
$update[$field] = 1;
} else {
$update[$field] = 0;
}
}
}
$report->update($update);
return redirect('admin/reports')->with('success', Lang::get('message.success.update'));
}
public function singleMR($id)
{
$singleReport = Report::findOrFail($id);
$singleReport['promotedProducts'] = ReportPromotedProduct::select('product_id')->where('report_id', $singleReport->id)->get();
$singleReport['sampleProducts'] = ReportSampleProduct::select('product_id')->where('report_id', $singleReport->id)->get();
$singleReport['gifts'] = ReportGift::select('gift_id')->where('report_id', $singleReport->id)->get();
$singleReport['soldProducts'] = ReportSoldProduct::select('product_id', 'quantity')->where('report_id', $singleReport->id)->get();
$dataView = ['singleReport' => $singleReport];
return view('sm.report.single', $dataView);
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
* @return void
*/
public function boot(Router $router)
{
parent::boot($router);
// $router->model('user' , 'App\User');
$router->bind('user', function ($value) {
return User::with('roles')->findOrFail($value);
});
/**
* created by dara on 6/9/2015
* add binding for admin wild card
*/
$router->bind('admin', function ($value) {
return User::with('roles')->findOrFail($value);
});
/**
* Created by Emad Mirzaie on 09/09/2015.
* province wild cart
*/
$router->model('province', 'App\\Province');
$router->model('city', 'App\\Province');
$router->model('university', 'App\\University');
$router->model('article', 'App\\Article');
$router->model('post', 'App\\Post');
$router->model('category', 'App\\Category');
$router->model('sub_category', 'App\\Category');
$router->model('skill', 'App\\Skill');
$router->model('profile', 'App\\User');
$router->model('comment', 'App\\Comment');
$router->model('poll', 'App\\Poll');
$router->model('questionnaire', 'App\\Questionnaire');
$router->model('coupon_user', 'App\\CouponUser');
$router->model('showcase', 'App\\Showcase');
$router->model('sticky', 'App\\Sticky');
/**
* Created By Dara on 22/10/2015
*/
// $router->bind('offer',function($value){
// return Offer::findOrFail($value);
// });
$router->bind('service', function ($value) {
return CouponGallery::findOrFail($value);
});
$router->bind('coupon', function ($value) {
return Coupon::findOrFail($value);
});
$router->bind('group', function ($value) {
return Group::findOrFail($value);
});
$router->bind('problem', function ($value) {
return Problem::findOrFail($value);
});
$router->model('offer', 'App\\Offer');
$router->model('shop', 'App\\Shop');
$router->model('product', 'App\\Product');
$router->bind('event', function ($value) {
return Event::findOrFail($value);
});
$router->bind('settle', function ($value) {
return Settle::findOrFail($value);
});
$router->bind('report', function ($value) {
return Report::findOrFail($value);
});
$router->bind('corporation', function ($value) {
return Corporation::findOrFail($value);
});
/**
* Created By Dara on 25/12/2015
*/
$router->bind('announcement', function ($value) {
return Announcement::findOrFail($value);
});
$router->bind('storage', function ($value) {
return Storage::findOrFail($value);
});
$router->bind('role', function ($value) {
return Role::findOrFail($value);
});
}
public function show($id)
{
$report = Report::findOrFail($id);
return view('reports/edit', ['report' => $report]);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$report = Report::findOrFail($id);
//dd($report->created_at->addDays(0.5)->diffForHumans());
dd($report->created_at->date());
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$report = Report::findOrFail($id);
$report->data = $report->getReportData();
return view('reports.show', ['report' => $report]);
}
