/**
* 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');
}
