public function run()
{
DB::table('uploads')->delete();
$collection = [['loan_id' => 1, 'user_id' => 3, 'document' => 'Drivers License', 'filename' => 'driversLicense', 'path' => 'driversLicense', 'filetype' => 'pdf', 'original_filename' => 'driversLicense.pdf']];
foreach ($collection as $record) {
Upload::create($record);
}
}
public function update($id)
{
// save updated
$record = $this->records->find($id);
if (!$record) {
Upload::create(Input::all());
return $this->respond($record);
}
$record->fill(Input::all())->save();
return $this->respond($record);
}
public function video(VideoRequest $request)
{
$file = $request->file('video');
$data['name'] = $file->getClientOriginalName();
$data['path'] = base_path() . '\\public\\videos';
$data['slug'] = Str::slug($file->getClientOriginalName(), '_');
$data['type'] = "video";
Upload::create($data);
$file->move($data['path'], $data['name']);
//
return back()->with('message', 'file saved!');
}
public function postCreate(Request $request)
{
$validator = Validator::make($request->all(), array('firstName' => 'required', 'lastName' => 'required', 'username' => 'required|max:20|min:3|unique:users', 'password' => 'required|min:6', 'email' => 'required|max:50|email|unique:users', 'roleId' => 'integer|min:1'));
if ($validator->fails()) {
return redirect()->route('admin-users-create')->withErrors($validator)->withInput();
} else {
$user = User::create(array('firstName' => $request->get('firstName'), 'lastName' => $request->get('lastName'), 'username' => $request->get('username'), 'password' => Hash::make($request->get('password')), 'email' => $request->get('email'), 'active' => $request->has('active') ? true : false, 'mobile' => $request->get('mobile'), 'roleId' => $request->get('roleId')));
$arr = array('id' => $user->id, 'firstName' => $user->firstName, 'lastName' => $user->lastName, 'username' => $user->username, 'email' => $user->email, 'active' => $user->active, 'mobile' => $user->mobile);
if ($user) {
//$message = trans('language.USER-CREATED');
$message = 'User has been created.';
//Logging::created('User', $arr);
} else {
//$message = trans('language.USER-NOT-CREATED');
$message = 'User can not be created, please try again.';
//Logging::not_created('User', $arr);
}
$copy1 = copy('output/crops.xlsx', 'uploads/' . $user->id . '$crops.xlsx');
$result = Upload::uploadInputFile(Config::getUploadBaseDirectory() . 'uploads/' . $user->id . '$crops.xlsx', 'crop', $user->id);
if ($copy1 == true and strpos($result, 'Uploaded') !== false) {
$state = '1';
} else {
$state = '0';
}
$copy2 = copy('output/soils.xlsx', 'uploads/' . $user->id . '$soils.xlsx');
$result = Upload::uploadInputFile(Config::getUploadBaseDirectory() . 'uploads/' . $user->id . '$soils.xlsx', 'soil', $user->id);
if ($copy2 == true and strpos($result, 'Uploaded') !== false) {
$state .= '-1';
} else {
$state .= '-0';
}
$copy3 = copy('output/efficiency.xlsx', 'uploads/' . $user->id . '$efficiency.xlsx');
$result = Upload::uploadInputFile(Config::getUploadBaseDirectory() . 'uploads/' . $user->id . '$efficiency.xlsx', 'efficiency', $user->id);
if ($copy3 == true and strpos($result, 'Uploaded') !== false) {
$state .= '-1';
} else {
$state .= '-0';
}
$copy4 = copy('output/yield.xlsx', 'uploads/' . $user->id . '$yield.xlsx');
$result = Upload::uploadInputFile(Config::getUploadBaseDirectory() . 'uploads/' . $user->id . '$yield.xlsx', 'yield', $user->id);
if ($copy4 == true and strpos($result, 'Uploaded') !== false) {
$state .= '-1';
} else {
$state .= '-0';
}
$state .= '-0-0-0-0-0-0';
$upload = Upload::create(array('userId' => $user->id, 'state' => $state));
if ($copy1 == true) {
$upload->crop = 'crops.xlsx';
$upload->crop_at = date('Y-m-d H:i:s');
$upload->save();
}
if ($copy2 == true) {
$upload->soil = 'soils.xlsx';
$upload->soil_at = date('Y-m-d H:i:s');
$upload->save();
}
if ($copy3 == true) {
$upload->efficiency = 'efficiency.xlsx';
$upload->efficiency_at = date('Y-m-d H:i:s');
$upload->save();
}
if ($copy4 == true) {
$upload->yield = 'yield.xlsx';
$upload->yield_at = date('Y-m-d H:i:s');
$upload->save();
}
}
return redirect()->route('admin-users-list')->with('global', $message);
}
public function store(LCCBRequest $request)
{
$request->request->add(['submitted_by' => Auth::user()->id]);
if (is_string($request->equipment_id)) {
$newEquip = Equipment::firstOrNew(['name' => $request->equipment_id]);
$newEquip->user_id = Auth::user()->id;
$newEquip->save();
$request->request->set('equipment_id', $newEquip->id);
}
$newRequest = Request::create($request->all());
if (!is_null($request->file('files'))) {
foreach ($request->file('files') as $file) {
Upload::create(['request_id' => $newRequest->id, 'file_name' => $file->getClientOriginalName()]);
$destinationPath = 'D:\\www\\lccb\\uploads\\lccbRequests\\' . $newRequest->id;
$file->move($destinationPath, $file->getClientOriginalName());
}
}
Event::fire(new RequestWasSubmitted($newRequest));
$json['success'] = 1;
$json['message'] = "Request saved";
$json['redirect'] = "/lccb/" . $newRequest->id . "/edit";
return json_encode($json);
}
