/** * Update the specified department in storage. */ public function update($id) { $department = Department::findOrFail($id); $validator = Validator::make($input = Input::all(), Department::rules($id)); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $department->update(['deptName' => $input['deptName']]); foreach ($input['designation'] as $index => $value) { if ($value == '' && !isset($input['designationID'][$index])) { continue; } if (isset($input['designationID'][$index])) { if ($value == '') { Designation::destroy($input['designationID'][$index]); } else { $design = Designation::find($input['designationID'][$index]); $design->designation = $value; $design->save(); } } else { Designation::firstOrCreate(['deptID' => $department->id, 'designation' => $value]); } } return Redirect::route('admin.departments.index')->with('success', "<strong>{$input['deptName']}</strong> Actualizado correctamente"); }
function getDesignationList($deptCode) { App::import("Model", "Designation"); $model = new Designation(); $con2 = $model->find('list', array('fields' => array('Designation.desg_code', 'Designation.desc'), 'conditions' => array('Designation.dept_code' => $deptCode))); if (empty($con2)) { return 0; } else { return $con2; } }
public function workflowSubmit() { $designation = e(Input::get('designa')); if ($designation == 0) { $des_name = ""; } else { $des = Designation::find($designation); $des_name = e($des->designation); } $id = Input::get('task_id'); $assignd = Task::find($id); $assignd->designation_id = Input::get('designa'); $assignd->save(); if ($designation == 0) { $data = array("html" => "<div id='insert_{$id}' class='mode1'> None </div> <input type='hidden' id='hide_currentDesignation' class='hide_currentDesignation' value='0' > "); } else { $data = array("html" => "<div id='insert_{$id}' class='mode1'> {$des_name} </div> <input type='hidden' id='hide_currentDesignation' class='hide_currentDesignation' value='{$assignd->designation_id}' > "); } return Response::json($data); }
public function findDesignationNameByCode($desg_code = null) { //function to find all company name App::import("Model", "Designation"); $model = new Designation(); $query = $model->find('all', array('fields' => array('desc'), 'conditions' => array('Designation.desg_code' => $desg_code))); if (empty($query)) { return 0; } else { return $query[0]['Designation']['desc']; } }
public function save_members() { $members_selected = Input::get('members_selected'); $members = explode(",", $members_selected); $designation_id = Input::get('designation_id'); UserHasDesignation::where('designation_id', '=', $designation_id)->delete(); foreach ($members as $key) { if ($key != 0) { $uhd = new UserHasDesignation(); $uhd->users_id = $key; $uhd->designation_id = $designation_id; $uhd->save(); if ($designation_id == 0) { $tasks = Task::where('designation_id', $designation_id)->get(); foreach ($tasks as $task) { DB::table('taskdetails')->where('task_id', $task->id)->where('assignee_id', $key)->update(array('status' => 'New')); } } } } $designation_name = Designation::find($designation_id); $name = $designation_name->designation; $message = "Successfully updated the members in {$name}."; Session::put('success_members', $message); return Redirect::to('designation'); }