public function resourcetaskassigndeleteAction()
{
$dresource_model = new Timemanagement_Model_Projectresources();
$task_resource_model = new Timemanagement_Model_Projecttaskresources();
$projectId = $this->_getParam('projectId');
$employeeId = $this->_getParam('employeeId');
$checkedTasks = $this->_getParam('chekedtaskids');
$uncheckedTasks = $this->_getParam('uncheckedtaskids');
$checkedTaskIds = json_decode($checkedTasks);
$uncheckedTasksIds = json_decode($uncheckedTasks);
$allTaskIdsArray = array();
$project_task_id = array();
$inserted_count = 0;
$updated_count = 0;
$getAllTasks = $dresource_model->getAllTasks($projectId);
//get all tasks for perticuler project
foreach ($getAllTasks as $task_id) {
$allTaskIdsArray[] = $task_id['task_id'];
$project_task_id[$task_id['task_id']] = $task_id['id'];
}
$assignedTasks = $dresource_model->getassignedTasks($projectId, $employeeId);
$assignedTaskIds = array();
$resourceProjectTaskPrimaryId = array();
if (count($assignedTasks) > 0) {
foreach ($assignedTasks as $id) {
$assignedTaskIds[] = $id['task_id'];
$resourceProjectTaskPrimaryId[$id['task_id']] = $id['id'];
}
}
$unAssignedTasks = array();
foreach ($allTaskIdsArray as $tId) {
if (!in_array($tId, $assignedTaskIds)) {
$unAssignedTasks[] = $tId;
}
}
//user selected to delete tasks from resources
//compare previoues assigned tasks and selected to delete tasks
if (count($uncheckedTasksIds) > 0) {
foreach ($uncheckedTasksIds as $ckedId) {
if (in_array($ckedId, $assignedTaskIds)) {
$is_updated = $task_resource_model->assignTasks($ckedId, $projectId, $employeeId, $resourceProjectTaskPrimaryId[$ckedId], $for_update = 1);
if ($is_updated == 'update') {
$updated_count++;
}
}
}
}
if (count($checkedTaskIds) > 0) {
foreach ($checkedTaskIds as $taskId) {
if (in_array($taskId, $unAssignedTasks)) {
//insert tasks in employee_tasks table
$isTaskAssigned = $task_resource_model->isTaskAssigned($projectId, $taskId, $employeeId);
if ($isTaskAssigned == 0) {
$is_inserted = $task_resource_model->assignTasks($taskId, $projectId, $employeeId, $project_task_id[$taskId]);
if ($is_inserted > 0) {
$inserted_count++;
}
}
}
}
}
//$this->_helper->json(array('message'=>'success','status'=>$updated_count.' Tasks deleted successfully,'.$inserted_count.' Tasks assigned successfully.'));
$this->_helper->json(array('message' => 'success', 'status' => 'Tasks list updated successfully.'));
}
