public function logoutAction() { if (is_null($this->session->getCurrentUser())) { $this->redirect('/login/'); } $user = $this->session->getCurrentUser(); if (in_array($user->roles_id, array(1, 3))) { $timelineModel = new Timeline(); $timelineModel->endTasksInWork(); } session_destroy(); $this->redirect('/login/'); }
/** * static function to read the xls and store * * @param int $id * @return Response*/ public static function orderimport_xls($pathname, $camp_id, $campid, $description, $object_id) { $camp = Camp::findOrFail($camp_id); Excel::load($pathname, function ($reader) use($camp) { $results = $reader->get(); foreach ($results as $result) { $save['order_id'] = $result->order_id; $save['warehouse'] = $result->warehouse; $save['ship_date'] = date('Y-m-d H:i:s', strtotime($result->ship_date)); $save[$status] = $result->status; $save['order_amount'] = $result->order_amount; $save['actual_time_to_deliver'] = $result->actual_time_to_deliver; $save['payment_method'] = $result->payment_method; $save['associate'] = $result->associate; $save['address_type'] = $result->address_type; $save['address'] = $result->customer_name . ',' . $result->status . ',' . $result->city . ',' . $result->district . ',' . $result->province . ',' . $result->customer_phone; $save[$campid] = $camp->id; Order::create($save); Session::flash('success', Lang::get('ruban.camp.updated')); unset($save); } $timeline[$description] = Auth::user()->first_name . ' ' . Auth::user()->last_name . ' has imported the daily camp xls for <a href="javascript:;">' . $camp->title . '</a>'; $timeline[$object_type] = 5; $timeline[$object_id] = $camp->id; Timeline::create($timeline); }); }
public function remove($id) { $timelineModel = new Timeline(); $timelineModel->setWhere(array('tasks_id' => $id)); $timelineModel->delete(); $this->setWhere(array('id' => $id)); $this->delete(); }
public static function getCampTimeline($astimeline, $type) { $camptimeline = Timeline::select('timeline.*', 'camps.name'); $camptimeline->join('camps', function ($join) use($astimeline, $type) { $join->on('camps.id', '=', 'timeline.object_id')->where('object_type', '=', $type)->where('object_id', '=', $astimeline); }); return $camptimeline->orderby('timeline.created_at', 'asc')->get()->toArray(); }
public function updatepartner(CardPartnerRequest $request, $id) { $input = $request->all(); $card = Card::FindORFail($id); $project = Project::FindORFail($card->project_id); $input['card_id'] = $id; PartnerCards::where('card_id', $id)->where('partner_id', $request->get('partner_id'))->delete(); PartnerCards::create($input); $user = User::find($input['partner_id']); $client = User::find(2); $data['email'] = $user->email; $data['name'] = $user->first_name . ' ' . $user->last_name; $data['content'] = $card->name . ' of the ' . $project->name . ' project has been assigned to you.'; Card::Mailing($data); $data1['email'] = $client->email; $data1['name'] = $client->first_name . ' ' . $client->last_name; $data1['content'] = $card->name . ' of the ' . $project->name . ' project has been assigned to ' . $data['name'] . ' Partner.'; Card::Mailing($data1); $timeline['object_type'] = 3; $timeline['object_id'] = $id; $timeline['action'] = 'assign'; $timeline['description'] = '<a href="javascript:;">' . $card->name . '</a> card has been assigned to ' . $user->first_name . ' ' . $user->last_name . ' by ' . Auth::user()->first_name . ' ' . Auth::user()->last_name . '.'; Timeline::create($timeline); Session::flash('success', Lang::get('ruban.partner.assigned')); return Redirect::route('ruban.cards.index'); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(ProjectRequest $request, $id) { $project = Project::find($id); if ($project) { $input = $request->except($this->image); $input['start_date'] = Carbon\Carbon::parse($request->get('start_date'))->format('Y-m-d'); $input['end_date'] = Carbon\Carbon::parse($request->get('end_date'))->format('Y-m-d'); $input[$this->image] = Project::upload_projectfile($request, $this->image, $project->image); $input['updated_by'] = Auth::user()->id; $project->fill($input); $project->save(); Session::flash($this->success, Lang::get('ruban.project.updated')); $timeline['object_type'] = 1; $timeline['object_id'] = $id; $timeline['action'] = 'update'; $timeline['description'] = '<a href="javascript:;">' . $input['name'] . '</a> project has been updated by ' . Auth::user()->first_name . ' ' . Auth::user()->last_name . '.'; Timeline::create($timeline); return Redirect::route('ruban.projects.index'); } else { Session::flash($this->danger, Lang::get('ruban.project.notfound')); return Redirect::route('ruban.projects.index'); } }
public function addtimeAction() { if (!$this->isXmlHttpRequest()) { throw new \Exception('Неверный тип запроса!'); } $data = $this->request->getPost(); if (!isset($data['date']) || !isset($data['hours']) || !isset($data['minutes']) || !isset($data['tasks_id'])) { throw new \Exception('Неверный тип запроса!'); } $timelineModel = new Timeline(); if ((int) $data['hours'] > 0 || (int) $data['minutes'] > 0) { $toInsert = array(); $toInsert['tasks_id'] = (int) $data['tasks_id']; $toInsert['works_begin'] = $data['date'] . ' ' . '00:00:00'; $toInsert['works_end'] = $data['date'] . ' ' . sprintf('%02d', $data['hours']) . ':' . sprintf('%02d', $data['minutes']) . ':00'; $timelineModel->insert($toInsert); } $seconds = $timelineModel->getTimeSumByTask((int) $data['tasks_id']); $hours = floor($seconds / 3600); $mins = floor(($seconds - $hours * 3600) / 60); $allTimeSum = $hours . ' часов ' . $mins . ' минут'; $dayTimeSum = gmdate('H часов i минут', $timelineModel->getTimeSumByDate($data['date'], (int) $data['tasks_id'])); echo json_encode(array('allTimeSum' => $allTimeSum, 'dayTimeSum' => $dayTimeSum)); exit; }
/** * static function to read the xls and store * * @param int $id * @return Response*/ public static function import_xls($pathname, $card_id = false, $camp_id = false) { Excel::load($pathname, function ($reader) use($card_id, $camp_id) { // Getting all results $results = $reader->get(); $cnt = 1; foreach ($results as $result) { //checking existing Ditrict in db if ($cnt < 6) { if ($card_id) { $exitdist = Card::where('id', $card_id)->first(); } else { $exitdist = Card::where('name', $result->card)->first(); } if ($camp_id) { $camp = Camp::where('id', $camp_id)->first(); } else { $camp = Camp::where('name', $result->camp)->first(); } $save['card_id'] = @$exitdist->id; $save['camp_id'] = @$camp->id; $save['title'] = $result->title; $save['description'] = ' Order Id :' . $result->order_id . ', Ship date:' . $result->ship_date; $save['added_by'] = Auth::user()->id; $save['status'] = $result->status; $save['order_amount'] = $result->order_amount; $save['actual_time_to_deliver'] = $result->actual_time_to_deliver; $save['payment_method'] = $result->payment_method; $save['address_type'] = $result->address_type; $save['address'] = ' Customer_name:' . $result->customer_name . ', Status:' . $result->status . ', City:' . $result->city . ', District' . $result->district . ', Province' . $result->province . ', Customer Phone' . $result->customer_phone; Task::create($save); if (@$camp->title) { $timeline['description'] = Auth::user()->first_name . ' ' . Auth::user()->last_name . ' has imported the task for <a href="javascript:;">' . $camp->title . '</a>'; $timeline['object_type'] = 6; $timeline['object_id'] = $camp->id; Timeline::create($timeline); } if (@$exitdist->name) { $timeline['description'] = Auth::user()->first_name . ' ' . Auth::user()->last_name . ' has imported the task for <a href="javascript:;">' . @$exitdist->name . '</a>'; $timeline['object_type'] = 6; $timeline['object_id'] = $exitdist->id; Timeline::create($timeline); } unset($save); } $cnt++; } }); }