public function getProfileUser(Request $request, $id)
{
if ($request->user()) {
$statuses = Status::where('user_id', $id)->orderBy('created_at', 'desc')->whereNull('parent_id')->simplePaginate(10);
$user = User::where('id', $id)->first();
if ($statuses && $user) {
$title = $user->getNameOrUsername();
return view('users.index')->withUser($user)->withStatuses($statuses)->withAuthUserIsFriend($request->user()->isFriendsWith($user))->withTitle($title);
} else {
return redirect()->route('home')->withError('Ошибка, свяжитесь с администратором.');
}
} else {
$data['user'] = User::where('id', $id)->first();
if ($data['user']) {
$data['comments_count'] = $data['user']->comment->count();
$data['posts_count'] = $data['user']->posts->count();
$data['posts_active_count'] = $data['user']->posts->where('active', '1')->count();
$data['posts_draft_count'] = $data['user']->posts->where('active', '0')->count();
$data['latest_posts'] = $data['user']->posts->where('active', '1')->take(5);
$data['latest_comments'] = $data['user']->comment->take(5);
$data['user_id'] = $data['user']->id;
$data['title'] = $data['user']->getNameOrUsername();
return view('users.stats', $data);
} else {
return redirect()->route('home')->withErrors('Ошибка, свяжитесь с администратором.');
}
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$statuses = [['name' => 'New', 'weight' => '0'], ['name' => 'Pending', 'weight' => '10'], ['name' => 'Resolved', 'weight' => '20', 'billable' => true], ['name' => 'Archived', 'weight' => '30', 'billable' => true, 'archivable' => true]];
foreach ($statuses as $statusData) {
$status = \App\Status::where('name', $statusData['name'])->first();
if (!$status) {
$status = new \App\Status();
$status->put($statusData);
}
}
}
public function delReply(Request $request, $id)
{
$user = User::where('id', $request->user()->id)->first();
$destroy = Status::where('id', $id)->first();
if ($user && $destroy && $destroy->user_id == $request->user()->id) {
$destroy->deleted_at = new Carbon();
$destroy->save();
return redirect()->back()->withMessage('Комментарий удален.');
} else {
return redirect()->route('home')->withError('Ошибка, свяжитесь с администратором.');
}
}
public function postindex(Request $request)
{
//responder XF
$id_sol = $request->input('id_sol');
$status = Status::where('solution_id', $id_sol)->first();
$resp = $status->result;
if ($resp) {
# code...
// if () {
return response()->json(array('msg' => $resp));
//}
}
}
/**
* Create a user registration.
*
* @param RegistrationFormRequest $request
*
* @return Response
*/
public function postRegistration(RegistrationFormRequest $request)
{
$data['username'] = $request->get('username');
$data['password'] = Hash::make(Config::get('app.salt') . $request->get('password'));
$data['email'] = $data['username'];
$data['status_id'] = Status::where('name', 'PENDING')->first()->id;
$data['role_id'] = Role::where('name', 'USER')->first()->id;
if ($user = User::create($data)) {
Auth::login($user, true);
if (Auth::check()) {
return redirect()->intended('dashboard');
} else {
Session::flash('error', 'Unable to log in.');
}
} else {
Session::flash('error', 'Unable to create user account.');
}
return redirect()->route('get.auth.registration')->withInput();
}
public function index(Request $request)
{
if ($request->user()) {
$statuses = Status::where(function ($query) {
return $query->where('user_id', Auth::user()->id)->orWhereIn('user_id', Auth::user()->friends()->lists('id'));
})->whereNull('parent_id')->orderBy('created_at', 'desc')->simplePaginate(15);
$friends = $request->user()->friends();
$requests = $request->user()->friendRequests();
$user = User::where('id', $request->user()->id)->first();
$title = 'Моя история';
return view('timeline')->withStatuses($statuses)->withFriends($friends)->withRequests($requests)->withUser($user)->withTitle($title);
} else {
$posts = Post::where('active', '1')->orderBy('created_at', 'desc')->simplePaginate(5);
if ($posts) {
$title = 'Последние записи';
return view('home')->withPosts($posts)->withTitle($title);
} else {
return redirect()->route('home')->withError('Ошибка, свяжитесь с администратором.');
}
}
}
public function getLikeStatus(Request $request, $id)
{
$user = User::where('id', $request->user()->id)->first();
$status = Status::where('id', $id)->first();
if ($user && $status) {
if ($user->id == $status->user->id) {
return redirect()->route('home')->withError('Ошибка, хакер что ли?');
}
if ($user->hasLikedStatus($status, $request->user()->id)) {
return redirect()->back()->withError('Вы уже это лайкнули.');
}
$like = new Like();
$like->user_id = $user->id;
$like->content_id = $status->id;
$like->content_type = 'App\\Status';
$like->save();
return redirect()->back()->withMessage('Спасибо за лайк.');
} else {
return redirect()->route('home')->withError('Ошибка, свяжитесь с администратором.');
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = \Faker\Factory::create();
//User
$userEmail = '*****@*****.**';
$user = \App\User::where('email', $userEmail)->first();
if (!$user) {
$user = new \App\User();
$user->email = $userEmail;
$user->save();
}
//Clients
$clients = [];
$client_ids = [];
for ($i = 0; $i < 10; $i++) {
$client = new \App\Client();
$client->name = $faker->company;
$client->save();
$client_ids[] = $client->id;
}
//Tickets
for ($i = 0; $i < 50; $i++) {
$ticket = new \App\Ticket();
$ticket->user_id = $user->id;
$ticket->client_id = $client_ids[array_rand($client_ids)];
$ticket->status_id = \App\Status::orderByRaw('RAND()')->first()->id;
$ticket->priority = rand(1, 10);
$ticket->title = $faker->sentence;
$ticket->description = $faker->paragraph;
$ticket->save();
}
$statuses = [['name' => 'New', 'weight' => '0'], ['name' => 'Pending', 'weight' => '10'], ['name' => 'Resolved', 'weight' => '20', 'billable' => true], ['name' => 'Archived', 'weight' => '30', 'billable' => true, 'archivable' => true]];
foreach ($statuses as $statusData) {
$status = \App\Status::where('name', $statusData['name'])->first();
if (!$status) {
$status = new \App\Status();
$status->put($statusData);
}
}
}
public function addStatus($status, $record_id = NULL)
{
if ($this->status == $status) {
return;
}
// Get first the current user status infos before update
$status_date = new DateTime($this->status_date);
$now = new DateTime();
// Update user status
$this->status = $status;
$this->status_date = $now;
$this->save();
//update duration of recent status
$recentStatus = Status::where('user_id', $this->id)->orderBy('id', 'DESC')->first();
if ($recentStatus) {
$recentStatus->duration = $now->getTimestamp() - $status_date->getTimestamp();
$recentStatus->save();
}
// Add status entry to status table
$this->statuses()->save(new Status(['status' => $status, 'record_id' => $record_id]));
return;
}
public function getStatuses()
{
return Status::where('created_at', '<=', Carbon::now())->orderBy('created_at', 'DESC')->get();
}
public function importEMP($destfile)
{
Excel::load($destfile, function ($reader) {
$rules = ['number' => 'required|unique:employees', 'company_id' => 'required|exists:companies,id', 'department_id' => 'required|exists:departments,id', 'bank_account' => 'required|unique:employees'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$company_name = $reader->getSheet($i)->getTitle();
$dept['company_id'] = Company::where('name', $company_name)->value('id');
$sheetCount = count($sheets);
for ($j = 6; $j < $sheetCount; $j++) {
// Get Department ID;
$dept['name'] = $sheets[$j][1];
$dept['costcenter'] = $sheets[$j][10];
$employee['company_id'] = $dept['company_id'];
$employee['department_id'] = Department::where('name', $dept['name'])->where('company_id', $dept['company_id'])->where('costcenter', $dept['costcenter'])->value('id');
$employee['name'] = $sheets[$j][2];
$employee['number'] = $sheets[$j][3];
$employee['level_id'] = Level::where('credit', 400)->value('id');
$employee['category_id'] = Category::where('code', 1)->value('id');
$employee['status_id'] = Status::where('code', 1)->value('id');
$employee['telephone'] = $sheets[$j][4];
$employee['bank_account'] = $sheets[$j][8];
$emp_v = \Validator::make($employee, $rules);
if ($emp_v->fails()) {
} else {
Employee::create($employee);
}
}
}
//END
});
}
public function getTrack(Batch $batch)
{
$towns = Towns::lists('name', 'id')->all();
$statuses = Status::where('id', '>', 1)->lists('status', 'id')->all();
return view('batch.track', compact('batch', 'towns', 'statuses'));
}
public function getTrack(Parcels $parcel)
{
$towns = Towns::lists('name', 'id')->all();
$statuses = Status::where('id', '>', 1)->lists('status', 'id')->all();
return view('parcel.track', compact('parcel', 'towns', 'statuses'));
}
public static function getStatusId($name)
{
$status = Status::where('name', $name)->first();
return empty($status) ? 0 : $status->id;
}
public function lastStatus()
{
// Returns the most recent Status submitted by this User
// If none are found, return NULL
return Status::where('created_by_id', $this->id)->orderBy('created_at', 'desc')->first();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
User::create(array('name' => 'Suhairi Abdul Hamid', 'email' => '*****@*****.**', 'password' => Hash::make('suhairi')));
User::create(array('name' => 'Nona Azizah', 'email' => '*****@*****.**', 'password' => Hash::make('azizah')));
Perkhidmatan::create(array("nama" => "WANG TUNAI"));
Perkhidmatan::create(array("nama" => "BUKU SEKOLAH"));
Perkhidmatan::create(array("nama" => "CUKAI JALAN"));
Perkhidmatan::create(array("nama" => "INSURANS"));
Perkhidmatan::create(array("nama" => "TAYAR / BATERI"));
Perkhidmatan::create(array("nama" => "KECEMASAN"));
Startup::create(['id' => 1, 'nama' => 'YURAN', 'nilai' => '4184963.80', 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Startup::create(['id' => 2, 'nama' => 'TKA', 'nilai' => '90721.52', 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Startup::create(['id' => 3, 'nama' => 'BIASA', 'nilai' => '00.00', 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Startup::create(['id' => 4, 'nama' => 'PERTARUHAN', 'nilai' => '00.00', 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Startup::create(['id' => 5, 'nama' => 'TAYAR / BATERI', 'nilai' => '00.00', 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Startup::create(['id' => 6, 'nama' => 'INSURANS', 'nilai' => '00.00', 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Tka::create(['id' => 1, 'jumlah' => 6.0, 'status' => 1, 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()]);
Sumbangan::create(['id' => 1, 'nama' => 'Sumbangan Kematian']);
Sumbangan::create(['id' => 2, 'nama' => 'Sumbangan IPTA']);
Sumbangan::create(['id' => 3, 'nama' => 'Sumbangan Bencana']);
Zon::create(['kod' => '01', 'nama' => 'BAHAGIAN KHIDMAT PENGURUSAN']);
Zon::create(['kod' => '02', 'nama' => 'BAHAGIAN INDUSTRI PADI']);
Zon::create(['kod' => '03', 'nama' => 'BAHAGIAN INDUSTRI PADI DAN BUKAN PADI']);
Zon::create(['kod' => '04', 'nama' => 'BAHAGIAN PENGURUSAN INSTITUSI LADANG']);
Zon::create(['kod' => '05', 'nama' => 'BAHAGIAN PERANCANGAN DAN TEKNOLOGI MAKLUMAT']);
Zon::create(['kod' => '06', 'nama' => 'BAHAGIAN PENGURUSAN EMPANGAN DAN SUMBER AIR']);
Zon::create(['kod' => '07', 'nama' => 'BAHAGIAN PENGAIRAN DAN SALIRAN']);
Zon::create(['kod' => '08', 'nama' => 'BAHAGIAN KHIDMAT MEKANIKAL DAN INFRASTRUKTUR']);
Zon::create(['kod' => '09', 'nama' => 'PERKHIDMATAN MEKANIKAL']);
Zon::create(['kod' => '10', 'nama' => 'BAHAGIAN PENGURUSAN WILAYAH']);
Zon::create(['kod' => '11', 'nama' => 'WILAYAH 1']);
Zon::create(['kod' => '12', 'nama' => 'WILAYAH 2']);
Zon::create(['kod' => '13', 'nama' => 'WILAYAH 3']);
Zon::create(['kod' => '14', 'nama' => 'WILAYAH 4']);
Zon::create(['kod' => '20', 'nama' => 'BAYARAN SENDIRI']);
Jantina::create(['nama' => 'LELAKI']);
Jantina::create(['nama' => 'PEREMPUAN']);
Status::create(['nama' => 'AKTIF']);
Status::create(['nama' => 'PENCEN']);
Status::create(['nama' => 'TIDAK AKTIF']);
Status::where('id', 3)->update(['id' => 0]);
Takaful::create(['jumlah' => '10.00', 'status' => 1]);
ProfileCategory::create(['id' => 1, 'nama' => 'AHLI BIASA', 'catatan' => '']);
ProfileCategory::create(['id' => 2, 'nama' => 'PPK', 'catatan' => '']);
ProfileCategory::create(['id' => 3, 'nama' => 'YPPPM', 'catatan' => 'Y']);
ProfileCategory::create(['id' => 4, 'nama' => 'SPPM', 'catatan' => 'S']);
ProfileCategory::create(['id' => 5, 'nama' => 'KOMADA', 'catatan' => '']);
ProfileCategory::create(['id' => 6, 'nama' => 'PELADANG MART', 'catatan' => 'PM']);
$profiles = Profile::all();
foreach ($profiles as $profile) {
$no_anggota = (int) $profile->no_anggota;
if ($no_anggota != 0) {
$profile->profile_category_id = 1;
$profile->save();
}
if (strpos($profile->no_anggota, 'Y') !== false) {
$profile->profile_category_id = 3;
$profile->save();
}
if (strpos($profile->no_anggota, 'S') !== false) {
$profile->profile_category_id = 4;
$profile->save();
}
if (strpos($profile->no_anggota, 'PM') !== false) {
$profile->profile_category_id = 6;
$profile->save();
}
if (strpos($profile->no_anggota, 'A') !== false || strpos($profile->no_anggota, 'B') !== false || strpos($profile->no_anggota, 'C') !== false || strpos($profile->no_anggota, 'F') !== false) {
$profile->profile_category_id = 2;
$profile->save();
}
}
}
public function updateStatus(Request $request)
{
$statuses = Status::where('id', $request->input('status'))->firstOrFail();
$order = Order::findOrFail($request->input('order_id'));
switch ($statuses->id) {
case '3':
$user = $order->user()->first();
Mail::send('emails.order-ready', compact('order', 'orderLines', 'user'), function ($m) use($user) {
$m->from('*****@*****.**', 'Krat en Klaar');
$m->to($user->email, $user->name)->subject('Bestelling gereed!');
});
break;
case '5':
$user = $order->user()->first();
Mail::send('emails.order-cancelled', compact('order', 'orderLines', 'user'), function ($m) use($user) {
$m->from('*****@*****.**', 'Krat en Klaar');
$m->to($user->email, $user->name)->subject('Bestelling geannuleerd');
});
break;
}
$order->status_id = $request->input('status');
$order->save();
return redirect('/manager/orders');
}
